{"status":"OK","data":{"value_of_scope":[],"list_scope":[],"bar_chart_color":[],"last_qry_nat_sales":"SELECT ifnull(SUM(`Nat_SalesTotal`), 0) AS a,\r\n            M_BranchID as M_BranchID, M_BranchName as M_BranchName\r\n            FROM `nat_sales` \r\n            JOIN m_branch\r\n                ON Nat_SalesM_BranchID = M_BranchID\r\n                AND M_BranchIsActive = 'Y'\r\n                 \r\n               AND `Nat_SalesYear` = YEAR('2026-07-15')\r\n               AND Nat_SalesIsActive = 'Y'\r\n            JOIN s_regional\r\n                ON M_BranchS_RegionalID = S_RegionalID\r\n                AND S_RegionalIsActive = 'Y'\r\n                AND S_RegionalID = 0 \r\n            GROUP BY M_BranchID\r\n            ORDER BY M_BranchName ASC","last_qry_nat_payment":"SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b,\r\n            M_BranchID as M_BranchID, M_BranchName as M_BranchName\r\n            FROM nat_payment \r\n            JOIN m_branch\r\n                ON Nat_PaymentM_BranchID = M_BranchID\r\n                AND M_BranchIsActive = 'Y'\r\n                 \r\n               AND Nat_PaymentOrderYear = year('2026-07-15')\r\n               AND Nat_PaymentIsActive = 'Y'\r\n            JOIN s_regional\r\n                ON M_BranchS_RegionalID = S_RegionalID\r\n                AND S_RegionalIsActive = 'Y'\r\n                AND S_RegionalID = 0 \r\n            GROUP BY M_BranchID\r\n            ORDER BY M_BranchName ASC","last_qry_branch_list":"SELECT M_BranchID, M_BranchName\r\n            from m_branch\r\n            where M_BranchIsActive = 'Y'\r\n            order by M_BranchName ASC"}}