Array
(
    [piutang_berjalan] => 0
    [piutang_year_min_1] => 0
    [piutang_berjalan_abs] => 0
    [piutang_year_min_1_abs] => 0
    [total_reformat] => 0
    [total] => Rp. 0.00 Puluh
    [persen] => 100 %
    [keterangan] => -
    [last_qry_tahun_berjalan_a] => SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS a
            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-14')
            
            JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID
            AND S_RegionalIsActive = 'Y'
            AND S_RegionalID = 19
            
    [last_qry_tahun_berjalan_b] => SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b
            FROM nat_payment 
            JOIN m_branch 
            ON M_BranchID  = Nat_PaymentM_BranchID
            AND M_BranchIsActive = 'Y'
            AND Nat_PaymentIsActive = 'Y'
            AND Nat_PaymentOrderYear = year('2026-07-14')
            
            JOIN s_regional 
            ON S_RegionalID = M_BranchS_RegionalID
            AND S_RegionalIsActive = 'Y'
            AND S_RegionalID = 19
    [last_qry_year_min_1_a] => SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS a
            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-14') - 1
            AND Nat_SalesDay <= DATE(NOW() - INTERVAL 1 YEAR)
            AND Nat_SalesIsActive = 'Y' 
            
            JOIN s_regional ON S_RegionalID = M_BranchS_RegionalID
            AND S_RegionalIsActive = 'Y'
            AND S_RegionalID = 19
            
    [last_qry_year_min_1_b] => SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b
            FROM nat_payment 
            JOIN m_branch 
            ON M_BranchID  = Nat_PaymentM_BranchID
            AND M_BranchIsActive = 'Y'
            AND Nat_PaymentIsActive = 'Y'
            AND Nat_PaymentOrderYear = year('2026-07-14') - 1
            AND Nat_PaymentDay <= DATE(NOW() - INTERVAL 1 YEAR)
            AND Nat_PaymentIsActive = 'Y'
            
            JOIN s_regional 
            ON S_RegionalID = M_BranchS_RegionalID
            AND S_RegionalIsActive = 'Y'
            AND S_RegionalID = 19 
)