Array
(
    [value_of_scope] => Array
        (
        )

    [list_scope] => Array
        (
        )

    [bar_chart_color] => Array
        (
        )

    [last_qry_tahun_berjalan] => 
            SELECT ifnull(SUM(`Nat_SalesTotal`), 0) AS total_sales_tahun_berjalan,
                M_BranchID, M_BranchName
            FROM `nat_sales` 
            JOIN m_branch
                ON Nat_SalesM_BranchID = M_BranchID
                AND M_BranchIsActive = 'Y'
                 AND Nat_SalesIsActive = 'Y'
                        AND `Nat_SalesYear` = year('2026-07-17') 
                        AND (`Nat_SalesDay` >= '2026-01-01' AND `Nat_SalesDay` <= '2026-07-17')
            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
            
)