Array
(
    [piutang_berjalan] => 0
    [piutang_year_min_1] => 0
    [piutang_berjalan_abs] => 0
    [piutang_year_min_1_abs] => 0
    [total_reformat] => Rp. 0.00 Puluh
    [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 Nat_SalesM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                JOIN s_regional 
                ON M_BranchS_RegionalID = S_RegionalID
                AND S_RegionalIsActive = 'Y'
                AND S_RegionalID = 1
            WHERE   Nat_SalesIsActive = 'Y'
                        AND `Nat_SalesYear` = year('2026-07-15') 
                        AND (`Nat_SalesDay` >= '2026-01-01' AND `Nat_SalesDay` <= '2026-07-15')
    [last_qry_tahun_berjalan_b] => SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b
            FROM nat_payment 
            JOIN m_branch
                ON Nat_PaymentM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                JOIN s_regional 
                ON M_BranchS_RegionalID = S_RegionalID
                AND S_RegionalIsActive = 'Y'
                AND S_RegionalID = 1
            WHERE   Nat_PaymentIsActive = 'Y'
                        AND `Nat_PaymentOrderYear` = year('2026-07-15') 
                        AND (`Nat_PaymentOrderDay` >= '2026-01-01' AND `Nat_PaymentOrderDay` <= '2026-07-15')
                        AND `Nat_PaymentYear` = year('2026-07-15') 
                        AND (`Nat_PaymentDay` >= '2026-01-01' AND `Nat_PaymentDay` <= '2026-07-15')
                         
    [last_qry_year_min_1_a] => SELECT ifnull(SUM(`Nat_SalesTotal`),0) AS a
            FROM `nat_sales` 
            JOIN m_branch
                ON Nat_SalesM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                JOIN s_regional 
                ON M_BranchS_RegionalID = S_RegionalID
                AND S_RegionalIsActive = 'Y'
                AND S_RegionalID = 1
            WHERE  Nat_SalesIsActive = 'Y'
                        AND `Nat_SalesYear` = year('2026-07-15') - 1
                        AND (`Nat_SalesDay` >= '2025-01-01' AND `Nat_SalesDay` <= DATE(NOW() - INTERVAL 1 YEAR)) 
    [last_qry_year_min_1_b] => SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b
            FROM nat_payment 
            JOIN m_branch
                ON Nat_PaymentM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                JOIN s_regional 
                ON M_BranchS_RegionalID = S_RegionalID
                AND S_RegionalIsActive = 'Y'
                AND S_RegionalID = 1
            WHERE   Nat_PaymentIsActive = 'Y'
                        AND `Nat_PaymentOrderYear` = year('2026-07-15') - 1
                        AND (`Nat_PaymentOrderDay` >= '2025-01-01' AND `Nat_PaymentOrderDay` <= DATE(NOW() - INTERVAL 1 YEAR))
                        AND `Nat_PaymentYear` = year('2026-07-15') - 1
                        AND (`Nat_PaymentDay` >= '2025-01-01' AND `Nat_PaymentDay` <= DATE(NOW() - INTERVAL 1 YEAR))
                         
)