{"status":"OK","data":{"total":"0.00 Puluh","persen":"100 %","keterangan":"-","last_qry_tahun_berjalan":"\r\n                    SELECT ifnull(count(*),0) AS total_order_tahun_berjalan\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            AND Nat_SalesIsActive = 'Y' \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":"\r\n                    SELECT ifnull(count(*),0) AS total_order_year_min_1\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                    JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID\r\n                    AND S_RegionalIsActive = 'Y'\r\n                    AND S_RegionalID = 0\r\n            "}}