Array
(
    [total_reformat] => 0
    [total] => Rp. 0.00 Puluh
    [persen] => 100 %
    [keterangan] => -
    [last_qry_tahun_berjalan] => 
                    SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS total_sales_tahun_berjalan
                    FROM `nat_sales` 
                    JOIN m_branch ON M_BranchID  = Nat_SalesM_BranchID
                    AND M_BranchIsActive = 'Y'
                    AND Nat_SalesIsActive = 'Y'
                     AND `Nat_SalesYear` =  year('2026-07-15') 
                    JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID
                    AND S_RegionalIsActive = 'Y'
                    AND S_RegionalID = 19
            
    [last_qry_year_min_1] => 
                    SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS total_sales_year_min_1
                    FROM `nat_sales` 
                    JOIN m_branch ON M_BranchID  = Nat_SalesM_BranchID
                    AND M_BranchIsActive = 'Y'
                    AND Nat_SalesIsActive = 'Y'
                     AND `Nat_SalesYear` = year('2026-07-15') - 1
            AND Nat_SalesDay <= DATE(NOW() - INTERVAL 1 YEAR) 
                    JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID
                    AND S_RegionalIsActive = 'Y'
                    AND S_RegionalID = 19
            
)