{"status":"OK","data":{"total":"Rp. 0.00 Puluh","persen":"100 %","keterangan":"-","last_qry_tahun_berjalan_a":"SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS a\r\n            FROM `nat_sales` \r\n            JOIN m_branch ON M_BranchID  = Nat_SalesM_BranchID\r\n            AND M_BranchIsActive = 'Y'\r\n            AND Nat_SalesIsActive = 'Y'\r\n            AND `Nat_SalesYear` =  year('2026-07-13')\r\n            \r\n            JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID\r\n            AND S_RegionalIsActive = 'Y'\r\n            AND S_RegionalID = 0\r\n            ","last_qry_tahun_berjalan_b":"SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b\r\n            FROM nat_payment \r\n            JOIN m_branch \r\n            ON M_BranchID  = Nat_PaymentM_BranchID\r\n            AND M_BranchIsActive = 'Y'\r\n            AND Nat_PaymentIsActive = 'Y'\r\n            AND Nat_PaymentOrderYear = year('2026-07-13')\r\n            \r\n            JOIN s_regional \r\n            ON S_RegionalID = M_BranchS_RegionalID\r\n            AND S_RegionalIsActive = 'Y'\r\n            AND S_RegionalID = 0","last_qry_year_min_1_a":"SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS a\r\n            FROM `nat_sales` \r\n            JOIN m_branch ON M_BranchID  = Nat_SalesM_BranchID\r\n            AND M_BranchIsActive = 'Y'\r\n            AND Nat_SalesIsActive = 'Y'\r\n            AND `Nat_SalesYear` =  year('2026-07-13') - 1\r\n            AND Nat_SalesDay <= DATE(NOW() - INTERVAL 1 YEAR)\r\n            AND Nat_SalesIsActive = 'Y' \r\n            \r\n            JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID\r\n            AND S_RegionalIsActive = 'Y'\r\n            AND S_RegionalID = 0\r\n            ","last_qry_year_min_1_b":"SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b\r\n            FROM nat_payment \r\n            JOIN m_branch \r\n            ON M_BranchID  = Nat_PaymentM_BranchID\r\n            AND M_BranchIsActive = 'Y'\r\n            AND Nat_PaymentIsActive = 'Y'\r\n            AND Nat_PaymentOrderYear = year('2026-07-13') - 1\r\n            AND Nat_PaymentDay <= DATE(NOW() - INTERVAL 1 YEAR)\r\n            AND Nat_PaymentIsActive = 'Y'\r\n            \r\n            JOIN s_regional \r\n            ON S_RegionalID = M_BranchS_RegionalID\r\n            AND S_RegionalIsActive = 'Y'\r\n            AND S_RegionalID = 0 "}}