zhuangxujie
01bc837fd4
Some checks failed
Server (Postgres) / Build & reinstall (setup) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (1) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (2) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (3) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (4) (push) Has been cancelled
Server (Mariadb) / Build & reinstall (setup) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (1) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (2) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (3) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (4) (push) Has been cancelled
Server (Mariadb) / Coverage Wrap Up (push) Has been cancelled
Lock threads / lock (push) Has been cancelled
Regenerate POT file (translatable strings) / Regenerate POT file (develop) (push) Has been cancelled
Regenerate POT file (translatable strings) / Regenerate POT file (version-16-hotfix) (push) Has been cancelled
Sync translations to hotfix branches / Trigger sync → version-16-hotfix (push) Has been cancelled
Create weekly release pull requests / Release (15) (push) Has been cancelled
Create weekly release pull requests / Release (16) (push) Has been cancelled
40 lines
939 B
Python
40 lines
939 B
Python
import json
|
|
|
|
import frappe
|
|
|
|
REFERENCE_REPORTS = [
|
|
"Accounts Receivable",
|
|
"Accounts Receivable Summary",
|
|
"Accounts Payable",
|
|
"Accounts Payable Summary",
|
|
"Stock Ageing",
|
|
]
|
|
|
|
|
|
def execute():
|
|
for report in REFERENCE_REPORTS:
|
|
update_reference_reports(report)
|
|
|
|
|
|
def update_reference_reports(reference_report):
|
|
reports = frappe.get_all(
|
|
"Report", filters={"reference_report": reference_report}, fields={"json", "name"}
|
|
)
|
|
|
|
for report in reports:
|
|
update_report_json(report)
|
|
update_reference_reports(report.name)
|
|
|
|
|
|
def update_report_json(report):
|
|
report_json = json.loads(report.json) if report.get("json") else {}
|
|
report_filter = report_json.get("filters")
|
|
|
|
if not report_filter:
|
|
return
|
|
|
|
keys_to_pop = [key for key in report_filter if key.startswith("range")]
|
|
report_filter["range"] = ", ".join(str(report_filter.pop(key)) for key in keys_to_pop)
|
|
|
|
frappe.db.set_value("Report", report.name, "json", json.dumps(report_json))
|