How to use frappe.call in print format or the equivalent

Frappe Framework Print Formats
7

in hooks.py

jenv = {
	"methods": [
		"get_jinja_data:property_sales.property_sales.doctype.property_sales.property_sales.get_jinja_data"
	]
}

in py file

@frappe.whitelist()
def get_jinja_data(doc):
	return frappe.db.sql("""select outstanding_amount, datediff(CURDATE(), posting_date) as "outstanding_days" from `tabSales Invoice` a where associated_property_sales = %s and docstatus = 1 and outstanding_amount > 0""",doc.name, as_dict=True)

in jinja print format

get_jinja_data(doc)

5 Likes