def get_html_table(self, columns=None, data=None):
date_time = global_date_format(now()) + " " + format_time(now())
report_doctype = frappe.db.get_value("Report", self.report,
"ref_doctype")
return frappe.render_template(
"frappe/templates/emails/auto_email_report.html",
{
"title":
self.name,
"description":
self.description,
"date_time":
date_time,
"columns":
columns,
"data":
data,
"report_url":
get_url_to_report(self.report, self.report_type,
report_doctype),
"report_name":
self.report,
"edit_report_settings":
get_link_to_form("Auto Email Report", self.name),
},
)
def get_html_table(self, columns=None, data=None):
date_time = global_date_format(now()) + ' ' + format_time(now())
report_doctype = frappe.db.get_value('Report', self.report,
'ref_doctype')
return frappe.render_template(
'frappe/templates/emails/auto_email_report.html', {
'title':
self.name,
'description':
self.description,
'date_time':
date_time,
'columns':
columns,
'data':
data,
'report_url':
get_url_to_report(self.report, self.report_type,
report_doctype),
'report_name':
self.report,
'edit_report_settings':
get_link_to_form('Auto Email Report', self.name)
})
def send_shopfloor_activities_summary_report():
"""
Similar to auto_email_report.send(), but renders the report in to a jinja template to allow for more flexibility
"""
# Get auto email report
auto_email_report = frappe.get_doc(
"Auto Email Report",
"Horizon Global (PTA): Shopfloor Activities Summary")
report = frappe.get_doc('Report', auto_email_report.report)
# Get report content
columns, data = report.get_data(limit=auto_email_report.no_of_rows or 100,
user=auto_email_report.user,
filters=auto_email_report.filters,
as_dict=True)
# Render template
date_time = global_date_format(now()) + ' ' + format_time(now())
report_doctype = frappe.db.get_value('Report', auto_email_report.report,
'ref_doctype')
report_html_data = frappe.render_template(
'quality_management_system/process/report/shopfloor_activities_summary/shopfloor_activities_summary_jinja.html',
{
'title':
auto_email_report.name,
'description':
auto_email_report.description,
'date_time':
date_time,
'columns':
columns,
'data':
data,
'report_url':
get_url_to_report(auto_email_report.report,
auto_email_report.report_type, report_doctype),
'report_name':
auto_email_report.report,
'edit_report_settings':
get_link_to_form('Auto Email Report', auto_email_report.name),
'site_url':
get_url()
})
# Later for testing: create PDF and attach
# file_name = "test_dirk7.html"
# from frappe.utils.file_manager import save_file
# my_file = save_file(file_name, report_html_data, "Workstation",
# "MagnaFlux Machine", "Home/Attachments")
# Send email, according to Auto Email Report settings
attachments = None
message = report_html_data
frappe.sendmail(recipients=auto_email_report.email_to.split(),
subject=auto_email_report.name,
message=message,
attachments=attachments,
reference_doctype=auto_email_report.doctype,
reference_name=auto_email_report.name)
def get_html_table(self, columns=None, data=None):
date_time = global_date_format(now()) + ' ' + format_time(now())
report_doctype = frappe.db.get_value('Report', self.report, 'ref_doctype')
return frappe.render_template('frappe/templates/emails/auto_email_report.html', {
'title': self.name,
'description': self.description,
'date_time': date_time,
'columns': columns,
'data': data,
'report_url': get_url_to_report(self.report, self.report_type, report_doctype),
'report_name': self.report,
'edit_report_settings': get_link_to_form('Auto Email Report', self.name)
})