selRole = 
query = SELECT Count(id) as total,IF(Acknowleged='Pending', 'Open',IF(Acknowleged='Yes', 'Sold', 'Lost')) as newack, SUM(Estimation) as TotalEstimation, DATE_FORMAT(sub_time, '%Y-%m-%d') as SubmitDate FROM pkh_saveformdata  WHERE userroles REGEXP 'mpsw_phoenix_asm|mpsw_phoenix_dispatcher|mpsw_phoenix_field_supervisor|mpsw_phoenix_senior_technician|mpsw_phoenix_service_administrator|mpsw_phoenix_technician' and DATE(sub_time) BETWEEN '2025-01-01' AND '2025-11-08'  GROUP BY newack ORDER BY newack DESC
DataStatus = Array
(
    [0] => stdClass Object
        (
            [total] => 1
            [newack] => Sold
            [TotalEstimation] => 5937
            [SubmitDate] => 2025-11-06
        )

)

count = 1
array_column After = Array
(
    [0] => Sold
)

newackdata DataStatus = Array
(
    [0] => stdClass Object
        (
            [total] => 1
            [newack] => Sold
            [TotalEstimation] => 5937
            [SubmitDate] => 2025-11-06
        )

)

newackdata val = Sold
DataStatus newack = Sold
array_column After = Array
(
    [0] => Sold
)

newackdata DataStatus = Array
(
    [0] => stdClass Object
        (
            [total] => 1
            [newack] => Sold
            [TotalEstimation] => 5937
            [SubmitDate] => 2025-11-06
        )

)

newackdata val = Open
DataStatus newack = Sold
array_column After = Array
(
    [0] => Sold
)

newackdata DataStatus = Array
(
    [0] => stdClass Object
        (
            [total] => 1
            [newack] => Sold
            [TotalEstimation] => 5937
            [SubmitDate] => 2025-11-06
        )

)

newackdata val = Lost
DataStatus newack = Sold
DataStatus After = Array
(
    [0] => Array
        (
            [total] => 1
            [newack] => Sold
            [TotalEstimation] => 5937
            [SubmitDate] => 2025-11-06
        )

    [1] => Array
        (
            [total] => 0
            [newack] => Open
            [TotalEstimation] => 0
            [SubmitDate] => 
        )

    [2] => Array
        (
            [total] => 0
            [newack] => Lost
            [TotalEstimation] => 0
            [SubmitDate] => 
        )

)