commit 4efc947f1494b1b0984009eb81f47f56bd31d952
author Daizy Modi <modidaizy5217@gmail.com> Mon Nov 07 09:21:03 2022 +0530
committer GitHub <noreply@github.com> Mon Nov 07 09:21:03 2022 +0530
tree 61739d0d2004e9be31d5c9fcc5ef3e21ec2f309c
parent 8859e6f1bbbf4b6b42dd44702fdcad13484dfc92

perf: use `get_cached_value` instead of `db.get_value` in controllers (#32776)

erpnext/controllers/trends.py

diff --git a/erpnext/controllers/trends.py b/erpnext/controllers/trends.py
index 1d6c5dc..1fb722e 100644
--- a/erpnext/controllers/trends.py
+++ b/erpnext/controllers/trends.py
@@ -80,7 +80,7 @@
 	if conditions.get("trans") == "Quotation" and filters.get("group_by") == "Customer":
 		cond += " and t1.quotation_to = 'Customer'"
 
-	year_start_date, year_end_date = frappe.db.get_value(
+	year_start_date, year_end_date = frappe.get_cached_value(
 		"Fiscal Year", filters.get("fiscal_year"), ["year_start_date", "year_end_date"]
 	)
 
@@ -275,7 +275,7 @@
 	from dateutil.relativedelta import relativedelta
 
 	if not year_start_date:
-		year_start_date, year_end_date = frappe.db.get_value(
+		year_start_date, year_end_date = frappe.get_cached_value(
 			"Fiscal Year", fiscal_year, ["year_start_date", "year_end_date"]
 		)