Example #1
0
func (h *MailHandler) Handle(request shared.IPathRequest) (shared.IResponse, error) {
	reportName := ""
	var id uint64
	recipientRaw := ""
	notes := ""

	err := request.ScanPath(&reportName, &id, &recipientRaw, &notes)
	if err != nil {
		return nil, err
	}
	if notes == "-" {
		notes = ""
	}

	report, err := h.Reporter.GetReportHTMLWriter(reportName, id, request.Session())
	if err != nil {
		return nil, err
	}

	err = h.Mailer.SendMailFromResponse(report, recipientRaw, notes)

	if err != nil {
		return nil, err
	}

	return shared.QuickStringResponse("Email sent to " + recipientRaw), nil
}
Example #2
0
func (r *Reporter) HandleReportRequest(request shared.IPathRequest) (shared.IResponse, error) {

	var name string
	var pk uint64
	//var fname string
	err := request.ScanPath(&name, &pk) //, &fname)
	if err != nil {
		return nil, err
	}
	return r.GetReportHTMLWriter(name, pk, request.Session())
}
Example #3
0
func (h *PDFHandler) Handle(request shared.IPathRequest) (shared.IResponse, error) {
	reportName := ""
	var id uint64
	var fname string
	err := request.ScanPath(&reportName, &id, &fname)
	if err != nil {
		return nil, err
	}

	report, err := h.Reporter.GetReportHTMLWriter(reportName, id, request.Session())
	if err != nil {
		return nil, err
	}

	pdfResponse := h.PDFer.ResponseAsPDF(report)
	return pdfResponse, nil
}
Example #4
0
func (h *CSVHandler) Handle(request shared.IPathRequest) (shared.IResponse, error) {

	var queryStringQuery string

	err := request.ScanPath(&queryStringQuery)
	if err != nil {
		return nil, err
	}

	rawQuery := databath.RawQueryConditions{}

	jsonQuery, err := url.QueryUnescape(queryStringQuery)
	if err != nil {
		return nil, err
	}
	log.Printf("Decode CSV Query: %s\n", jsonQuery)
	err = json.Unmarshal([]byte(jsonQuery), &rawQuery)
	if err != nil {
		return nil, err
	}
	var neg1 int64 = -1
	rawQuery.Limit = &neg1
	rawQuery.Offset = nil

	qc, err := rawQuery.TranslateToQuery()
	if err != nil {
		return nil, err
	}

	query, err := databath.GetQuery(request.GetContext(), h.Model, qc, false)
	if err != nil {
		return nil, err
	}
	sqlString, _, parameters, err := query.BuildSelect()
	if err != nil {
		return nil, err
	}

	db, err := request.DB()
	if err != nil {
		return nil, err
	}

	rows, err := query.RunQueryWithResults(db, sqlString, parameters)
	if err != nil {
		return nil, err
	}

	filename := *rawQuery.Collection + "-" + time.Now().Format("2006-01-02") + ".csv"

	/*
		fieldset := h.Model.Collections[*rawQuery.Collection].FieldSets[*rawQuery.Fieldset]

		csvFields := make([]CSVField, len(fieldset), len(fieldset))

		for i, fieldDef := range fieldset {
			csvFields[i] = CSVField{
				Title:  fieldDef.GetTitle(),
				SQLCol: fieldDef.GetSQLColName(),
			}

		}*/

	mappedFields, err := query.GetFields()

	if err != nil {
		log.Print(err)
		request.DoError(err)
	}

	allColNames, err := query.GetColNames()
	if err != nil {
		log.Print(err)
		request.DoError(err)
	}

	colNames := make([]string, 0, 0)
	for _, colName := range allColNames {
		if strings.HasPrefix(colName, "-") {
			continue
		}
		if strings.HasPrefix(colName, "#") {
			continue
		}

		colNames = append(colNames, colName)
	}

	resp := &csvResponse{
		rows:     rows,
		filename: filename,
		//fields:   csvFields,
		colNames:     colNames,
		mappedFields: mappedFields,
	}

	return resp, nil

}