def drill_down_detail(flask_report, report_id, col_id):
filters = request.args
report = Report(flask_report, report_id)
col = report.data_set.columns[col_id]['expr']
col = get_column_operated(getattr(col, 'element', col))
model_name = flask_report.get_model_label(col.table)
items = report.get_drill_down_detail(col_id, **filters)
return report.get_drill_down_detail_template(col_id).render(
items=items, key=col.key, model_name=model_name, report=report)
def drill_down_detail(flask_report, report_id, col_id):
filters = request.args
report = Report(flask_report, report_id)
col = report.data_set.columns[col_id]['expr']
col = get_column_operated(getattr(col, 'element', col))
model_name = flask_report.get_model_label(col.table)
items = report.get_drill_down_detail(col_id, **filters)
return report.get_drill_down_detail_template(
col_id).render(items=items, key=col.key, model_name=model_name,
report=report)
def report_graphs(flask_report, id_):
report = Report(flask_report, id_)
return render_template("report____/graphs.html",
url=request.args.get("url"),
bar_charts=report.bar_charts,
name=report.name,
pie_charts=report.pie_charts)
def report_list(self):
'''
return all the reports
'''
return [
Report(self, int(dir_name))
for dir_name in os.listdir(self.report_dir)
if dir_name.isdigit() and dir_name != '0'
]
def report(self, id_=None):
self.try_view_report()
if id_ is not None:
report = Report(self, id_)
html_report = report.html_template.render(report=report)
code = report.read_literal_filter_condition()
SQL_html = highlight(query_to_sql(report.query), SqlLexer(), HtmlFormatter())
params = dict(report=report, html_report=html_report, SQL=SQL_html)
if code is not None:
customized_filter_condition = highlight(code, PythonLexer(), HtmlFormatter())
params['customized_filter_condition'] = customized_filter_condition
extra_params = self.extra_params.get("report")
if extra_params:
if isinstance(extra_params, types.FunctionType):
extra_params = extra_params(id_)
params.update(extra_params)
return render_template("report____/report.html", **params)
def report(flask_report, id_=None):
flask_report.try_view_report()
if id_ is not None:
report = Report(flask_report, id_)
code = report.raw_filter_condition
SQL_html = highlight(query_to_sql(report.query), SqlLexer(),
HtmlFormatter())
params = dict(report=report, SQL=SQL_html)
if code is not None:
customized_filter_condition = highlight(code, PythonLexer(),
HtmlFormatter())
params['customized_filter_condition'] = \
customized_filter_condition
extra_params = flask_report.report_template_param(report)
if extra_params:
params.update(extra_params)
return report.html_template.render(**params)
else: # create report
form = _ReportForm(flask_report, request.form)
if form.validate():
name = form.name.data
id = None
if request.args.get('preview'):
name += '(' + _('Preview') + ')'
id = 0
filter_map = {}
for filter_ in json.loads(form.filters.data):
filter_map.setdefault(filter_['col'], []).append({
'operator':
filter_['op'],
'value':
filter_['val'],
'synthetic':
filter_['synthetic']
})
report_id = create_report(form.data_set,
name=name,
creator=form.creator.data,
description=form.description.data,
id=id,
columns=form.columns.data,
filters=filter_map)
return jsonify({
'id': report_id,
'name': form.name.data,
'url': url_for('.report', id_=report_id)
})
else:
return jsonify({'errors': form.errors}), 403
def report_csv(flask_report, id_):
report = Report(flask_report, id_)
si = StringIO()
writer = csv.writer(si, delimiter=',')
writer.writerow([col['name'].encode('utf-8') for col in report.columns])
col_id_list = [col['idx'] for col in report.columns]
for row in report.data:
row = [
row[i].encode('utf-8') if isinstance(row[i], unicode) else row[i]
for i in col_id_list
]
writer.writerow(row)
rsp = Response(si.getvalue(), mimetype="text/csv")
filename = report.name.encode('utf-8') + time.strftime('.%Y%m%d%H%M%S.csv')
rsp.headers["Content-disposition"] = "attachment; filename=" + filename
return rsp
def reports(self):
'''
reports to be sent
'''
return [Report(self.flask_report, id_) for id_ in self.report_ids]
