Array
(
    [rst_nat_sales] => Array
        (
        )

    [rst_nat_payment] => Array
        (
        )

    [hasil_tmp] => Array
        (
        )

    [hasil_baru] => Array
        (
        )

    [value_of_scope] => Array
        (
        )

    [list_scope] => Array
        (
        )

    [bar_chart_color] => Array
        (
        )

    [last_qry_nat_sales] => SELECT ifnull(SUM(`Nat_SalesTotal`), 0) AS a,
            M_BranchID as M_BranchID, M_BranchName as M_BranchName
            FROM `nat_sales` 
            JOIN m_branch
                ON Nat_SalesM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                 
                               AND Nat_SalesIsActive = 'Y'
                               AND Nat_SalesQuarter = (1)
                               AND `Nat_SalesYear` = YEAR('2026-07-16')
                               
            JOIN s_regional
                ON M_BranchS_RegionalID = S_RegionalID
                AND S_RegionalIsActive = 'Y'
                AND S_RegionalID = 1 
            GROUP BY M_BranchID
            ORDER BY M_BranchName ASC
    [last_qry_nat_payment] => SELECT ifnull(SUM(Nat_PaymentTotal),0) AS b,
            M_BranchID as M_BranchID, M_BranchName as M_BranchName
            FROM nat_payment 
            JOIN m_branch
                ON Nat_PaymentM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                 
                               AND Nat_PaymentIsActive = 'Y'
                               AND Nat_PaymentOrderQuarter = (1)
                               AND Nat_PaymentQuarter = (1)
                               AND Nat_PaymentOrderYear = year('2026-07-16')
                               AND `Nat_PaymentYear` = year('2026-07-16')
                            
            JOIN s_regional
                ON M_BranchS_RegionalID = S_RegionalID
                AND S_RegionalIsActive = 'Y'
                AND S_RegionalID = 1 
            GROUP BY M_BranchID
            ORDER BY M_BranchName ASC
    [last_qry_branch_list] => SELECT M_BranchID, M_BranchName
            from m_branch
            where M_BranchIsActive = 'Y'
            order by M_BranchName ASC
)