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) })