{"status":"OK","data":{"value_of_scope":[],"list_scope":[],"bar_chart_color":[],"last_qry_tahun_berjalan":"\r\n            SELECT ifnull(SUM(`Nat_SalesTotal`), 0) AS total_sales_tahun_berjalan,\r\n                M_BranchID, 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                 AND Nat_SalesIsActive = 'Y'\r\n            AND `Nat_SalesYear` = YEAR('2026-07-15')\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\r\n            "}}