Array
(
    [all_count] => 12
    [active_count] => 0
    [today_count] => 0
    [upcoming_count] => 0
    [completed_count] => 10
    [cancelled_count] => 0
)
Array
(
    [0] => Array
        (
            [query] => select 
        COUNT(id) as all_count,
        SUM(CASE WHEN job_status = 'in_progress' THEN 1 ELSE 0 END) as active_count,
        SUM(CASE WHEN DATE(from_time) = ? AND to_time > ? AND job_status NOT IN ('in_progress', 'completed', 'auto_ended', 'cancelled') THEN 1 ELSE 0 END) as today_count,
        SUM(CASE WHEN DATE(from_time) > ? AND status != 'pending' AND job_status NOT IN ('completed', 'auto_ended', 'cancelled') THEN 1 ELSE 0 END) as upcoming_count,
        SUM(CASE WHEN job_status IN ('completed', 'auto_ended') OR (job_status = 'pending' AND status = 'completed') THEN 1 ELSE 0 END) as completed_count,
        SUM(CASE WHEN job_status = 'cancelled' OR status = 'cancelled' THEN 1 ELSE 0 END) as cancelled_count
     from `patroller_schedules` where `company_id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 2026-02-24
                    [1] => 2026-02-24 22:17:20
                    [2] => 2026-02-24
                    [3] => 1
                )

            [time] => 1.11
            [readWriteType] => write
        )

)