a:14:{s:6:"config";s:4126:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:6:"2.0.54";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.54";s:4:"name";s:13:"Carebook v1.0";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.0.30";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:1;}s:10:"extensions";a:17:{s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:8:"2.0.50.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:61:"/home/carebook/public_html/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.27.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:56:"/home/carebook/public_html/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:56:"/home/carebook/public_html/vendor/yiisoft/yii2-faker/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:64:"/home/carebook/public_html/vendor/yiisoft/yii2-symfonymailer/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:54:"/home/carebook/public_html/vendor/yiisoft/yii2-gii/src";}}s:18:"kartik-v/yii2-mpdf";a:3:{s:4:"name";s:18:"kartik-v/yii2-mpdf";s:7:"version";s:7:"1.0.6.0";s:5:"alias";a:1:{s:12:"@kartik/mpdf";s:56:"/home/carebook/public_html/vendor/kartik-v/yii2-mpdf/src";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"3.0.5.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:63:"/home/carebook/public_html/vendor/kartik-v/yii2-krajee-base/src";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:7:"2.2.5.0";s:5:"alias";a:1:{s:15:"@kartik/select2";s:66:"/home/carebook/public_html/vendor/kartik-v/yii2-widget-select2/src";}}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:7:"1.6.4.0";s:5:"alias";a:1:{s:12:"@kartik/form";s:69:"/home/carebook/public_html/vendor/kartik-v/yii2-widget-activeform/src";}}s:22:"kartik-v/yii2-sortable";a:3:{s:4:"name";s:22:"kartik-v/yii2-sortable";s:7:"version";s:7:"1.2.2.0";s:5:"alias";a:1:{s:16:"@kartik/sortable";s:60:"/home/carebook/public_html/vendor/kartik-v/yii2-sortable/src";}}s:20:"kartik-v/yii2-dialog";a:3:{s:4:"name";s:20:"kartik-v/yii2-dialog";s:7:"version";s:7:"1.0.6.0";s:5:"alias";a:1:{s:14:"@kartik/dialog";s:58:"/home/carebook/public_html/vendor/kartik-v/yii2-dialog/src";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.5.3.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:56:"/home/carebook/public_html/vendor/kartik-v/yii2-grid/src";}}s:22:"kartik-v/yii2-dynagrid";a:3:{s:4:"name";s:22:"kartik-v/yii2-dynagrid";s:7:"version";s:7:"1.5.5.0";s:5:"alias";a:1:{s:16:"@kartik/dynagrid";s:60:"/home/carebook/public_html/vendor/kartik-v/yii2-dynagrid/src";}}s:20:"kartik-v/yii2-export";a:3:{s:4:"name";s:20:"kartik-v/yii2-export";s:7:"version";s:7:"1.4.3.0";s:5:"alias";a:1:{s:14:"@kartik/export";s:58:"/home/carebook/public_html/vendor/kartik-v/yii2-export/src";}}s:16:"yiisoft/yii2-jui";a:3:{s:4:"name";s:16:"yiisoft/yii2-jui";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:8:"@yii/jui";s:50:"/home/carebook/public_html/vendor/yiisoft/yii2-jui";}}s:24:"edofre/yii2-fullcalendar";a:3:{s:4:"name";s:24:"edofre/yii2-fullcalendar";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:20:"@edofre/fullcalendar";s:62:"/home/carebook/public_html/vendor/edofre/yii2-fullcalendar/src";}}s:35:"kartik-v/yii2-widget-datetimepicker";a:3:{s:4:"name";s:35:"kartik-v/yii2-widget-datetimepicker";s:7:"version";s:7:"1.5.1.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:73:"/home/carebook/public_html/vendor/kartik-v/yii2-widget-datetimepicker/src";}}}}";s:3:"log";s:15299:"a:1:{s:8:"messages";a:27:{i:0;a:6:{i:0;s:68:"Bootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1783540907.316092967987060546875;i:4;a:0:{}i:5;i:879072;}i:1;a:6:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1783540907.3162639141082763671875;i:4;a:0:{}i:5;i:900400;}i:2;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1783540907.3162839412689208984375;i:4;a:0:{}i:5;i:901200;}i:3;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1783540907.317369937896728515625;i:4;a:0:{}i:5;i:1150840;}i:4;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.318080902099609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1398904;}i:5;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=carebook";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1783540907.3181478977203369140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1401344;}i:10;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.32019805908203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1471320;}i:13;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3209629058837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1471968;}i:16;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.321990966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1572464;}i:19;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1783540907.3242208957672119140625;i:4;a:0:{}i:5;i:1712312;}i:20;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1783540907.3256080150604248046875;i:4;a:0:{}i:5;i:1764456;}i:21;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1783540907.32569599151611328125;i:4;a:0:{}i:5;i:1770000;}i:31;a:6:{i:0;s:38:"Route requested: 'report/billing-data'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1783540907.326033115386962890625;i:4;a:0:{}i:5;i:1796520;}i:32;a:6:{i:0;s:33:"Route to run: report/billing-data";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1783540907.3262081146240234375;i:4;a:0:{}i:5;i:1881272;}i:33;a:6:{i:0;s:69:"Running action: app\controllers\ReportController::actionBillingData()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1783540907.326613903045654296875;i:4;a:0:{}i:5;i:1913344;}i:34;a:6:{i:0;s:1039:"SELECT `s`.`client_id` AS `client_id`, `c`.`id` AS `linked_client_id`, TRIM(CONCAT(COALESCE(c.first_name, ''), ' ', COALESCE(c.last_name, ''))) AS `client_name`, COUNT(DISTINCT s.id) AS `shift_count`, COALESCE(SUM(CASE WHEN a.check_in IS NOT NULL AND a.check_out IS NOT NULL AND a.check_out > a.check_in THEN TIMESTAMPDIFF(MINUTE, a.check_in, a.check_out) WHEN s.start_time IS NOT NULL AND s.end_time IS NOT NULL AND s.end_time > s.start_time THEN TIMESTAMPDIFF(MINUTE, s.start_time, s.end_time) ELSE 0 END), 0) AS `total_minutes` FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id LEFT JOIN (SELECT `shift_id`, MIN(check_in) AS `check_in`, MAX(check_out) AS `check_out` FROM `attendance` WHERE NOT (`shift_id` IS NULL) GROUP BY `shift_id`) `a` ON a.shift_id = s.id WHERE (`s`.`start_time` >= '2026-06-01 00:00:00') AND (`s`.`start_time` < '2026-07-25 00:00:00') AND (NOT (`s`.`client_id` IS NULL)) GROUP BY `s`.`client_id`, `c`.`id`, `c`.`first_name`, `c`.`last_name` ORDER BY `c`.`last_name`, `c`.`first_name`, `s`.`client_id`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.327581882476806640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2186;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1982800;}i:37;a:6:{i:0;s:111:"SELECT COUNT(*) FROM `shift` `s` WHERE `s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.329196929931640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1707;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1984440;}i:40;a:6:{i:0;s:148:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3297579288482666015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1708;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1990736;}i:43;a:6:{i:0;s:149:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3302218914031982421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1709;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1996568;}i:46;a:6:{i:0;s:206:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND ((`s`.`start_time` IS NULL) OR (`s`.`end_time` IS NULL) OR (s.end_time <= s.start_time))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.330688953399658203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1710;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2069304;}i:49;a:6:{i:0;s:106:"SELECT COUNT(*) FROM `attendance` WHERE `check_in` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33108997344970703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1711;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2074896;}i:52;a:6:{i:0;s:75:"SELECT COUNT(DISTINCT client_id) FROM `contract` WHERE NOT (`rate` IS NULL)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3315279483795166015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1712;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2093152;}i:55;a:6:{i:0;s:124:"SELECT COUNT(*) FROM `contract` WHERE (`start_date` IS NULL) OR (`start_date`='') OR (`end_date` IS NULL) OR (`end_date`='')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3319990634918212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1713;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2100744;}i:58;a:6:{i:0;s:213:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `user` `u` ON u.id = s.staff_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL)) AND (`u`.`id` IS NULL)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3324320316314697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1722;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2108656;}i:61;a:6:{i:0;s:217:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL)) AND (`c`.`id` IS NULL)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3329350948333740234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1729;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2114552;}i:64;a:6:{i:0;s:450:"[ 'report' => 'billing', 'start' => '2026-06-01', 'end' => '2026-07-24', 'hide_zero' => false, 'rows_removed_by_hide_zero' => 0, 'shift_count' => 0, 'shifts_with_staff_id' => 0, 'shifts_with_client_id' => 0, 'invalid_shift_times' => 0, 'attendance_rows' => 0, 'clients_with_contract_rates' => 14, 'contracts_with_invalid_dates' => 14, 'shifts_missing_user' => 0, 'shifts_missing_client' => 0, ]";i:1;i:4;i:2;s:18:"report.diagnostics";i:3;d:1783540907.3333280086517333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1731;s:8:"function";s:4:"info";s:5:"class";s:11:"yii\BaseYii";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2113456;}i:65;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 99.251.247.10";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1783540907.3336639404296875;i:4;a:0:{}i:5;i:2120944;}}}";s:9:"profiling";s:24354:"a:3:{s:6:"memory";i:2128280;s:4:"time";d:0.02081203460693359375;s:8:"messages";a:30:{i:6;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=carebook";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1783540907.3181679248809814453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1402472;}i:7;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=carebook";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1783540907.3192379474639892578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1447672;}i:8;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3192880153656005859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1447896;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3201119899749755859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1469928;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3202250003814697265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1472672;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.320568084716796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1475296;}i:14;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3210480213165283203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1474832;}i:15;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.32155609130859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1477040;}i:17;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.322019100189208984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1573248;}i:18;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3222980499267578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1577328;}i:35;a:6:{i:0;s:1039:"SELECT `s`.`client_id` AS `client_id`, `c`.`id` AS `linked_client_id`, TRIM(CONCAT(COALESCE(c.first_name, ''), ' ', COALESCE(c.last_name, ''))) AS `client_name`, COUNT(DISTINCT s.id) AS `shift_count`, COALESCE(SUM(CASE WHEN a.check_in IS NOT NULL AND a.check_out IS NOT NULL AND a.check_out > a.check_in THEN TIMESTAMPDIFF(MINUTE, a.check_in, a.check_out) WHEN s.start_time IS NOT NULL AND s.end_time IS NOT NULL AND s.end_time > s.start_time THEN TIMESTAMPDIFF(MINUTE, s.start_time, s.end_time) ELSE 0 END), 0) AS `total_minutes` FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id LEFT JOIN (SELECT `shift_id`, MIN(check_in) AS `check_in`, MAX(check_out) AS `check_out` FROM `attendance` WHERE NOT (`shift_id` IS NULL) GROUP BY `shift_id`) `a` ON a.shift_id = s.id WHERE (`s`.`start_time` >= '2026-06-01 00:00:00') AND (`s`.`start_time` < '2026-07-25 00:00:00') AND (NOT (`s`.`client_id` IS NULL)) GROUP BY `s`.`client_id`, `c`.`id`, `c`.`first_name`, `c`.`last_name` ORDER BY `c`.`last_name`, `c`.`first_name`, `s`.`client_id`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3276178836822509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2186;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1986536;}i:36;a:6:{i:0;s:1039:"SELECT `s`.`client_id` AS `client_id`, `c`.`id` AS `linked_client_id`, TRIM(CONCAT(COALESCE(c.first_name, ''), ' ', COALESCE(c.last_name, ''))) AS `client_name`, COUNT(DISTINCT s.id) AS `shift_count`, COALESCE(SUM(CASE WHEN a.check_in IS NOT NULL AND a.check_out IS NOT NULL AND a.check_out > a.check_in THEN TIMESTAMPDIFF(MINUTE, a.check_in, a.check_out) WHEN s.start_time IS NOT NULL AND s.end_time IS NOT NULL AND s.end_time > s.start_time THEN TIMESTAMPDIFF(MINUTE, s.start_time, s.end_time) ELSE 0 END), 0) AS `total_minutes` FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id LEFT JOIN (SELECT `shift_id`, MIN(check_in) AS `check_in`, MAX(check_out) AS `check_out` FROM `attendance` WHERE NOT (`shift_id` IS NULL) GROUP BY `shift_id`) `a` ON a.shift_id = s.id WHERE (`s`.`start_time` >= '2026-06-01 00:00:00') AND (`s`.`start_time` < '2026-07-25 00:00:00') AND (NOT (`s`.`client_id` IS NULL)) GROUP BY `s`.`client_id`, `c`.`id`, `c`.`first_name`, `c`.`last_name` ORDER BY `c`.`last_name`, `c`.`first_name`, `s`.`client_id`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3287770748138427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2186;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1989704;}i:38;a:6:{i:0;s:111:"SELECT COUNT(*) FROM `shift` `s` WHERE `s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3292291164398193359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1707;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1986440;}i:39;a:6:{i:0;s:111:"SELECT COUNT(*) FROM `shift` `s` WHERE `s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3295719623565673828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1707;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1988512;}i:41;a:6:{i:0;s:148:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.329782009124755859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1708;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1992832;}i:42;a:6:{i:0;s:148:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3300769329071044921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1708;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1994936;}i:44;a:6:{i:0;s:149:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3302409648895263671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1709;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1998664;}i:45;a:6:{i:0;s:149:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3305079936981201171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1709;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2000768;}i:47;a:6:{i:0;s:206:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND ((`s`.`start_time` IS NULL) OR (`s`.`end_time` IS NULL) OR (s.end_time <= s.start_time))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.330708026885986328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1710;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2071528;}i:48;a:6:{i:0;s:206:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND ((`s`.`start_time` IS NULL) OR (`s`.`end_time` IS NULL) OR (s.end_time <= s.start_time))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.330974102020263671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1710;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2073696;}i:50;a:6:{i:0;s:106:"SELECT COUNT(*) FROM `attendance` WHERE `check_in` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.331121921539306640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1711;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2076896;}i:51;a:6:{i:0;s:106:"SELECT COUNT(*) FROM `attendance` WHERE `check_in` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3313350677490234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1711;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2078968;}i:53;a:6:{i:0;s:75:"SELECT COUNT(DISTINCT client_id) FROM `contract` WHERE NOT (`rate` IS NULL)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3315451145172119140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1712;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2095360;}i:54;a:6:{i:0;s:75:"SELECT COUNT(DISTINCT client_id) FROM `contract` WHERE NOT (`rate` IS NULL)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33187007904052734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1712;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2097360;}i:56;a:6:{i:0;s:124:"SELECT COUNT(*) FROM `contract` WHERE (`start_date` IS NULL) OR (`start_date`='') OR (`end_date` IS NULL) OR (`end_date`='')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3320159912109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1713;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2102872;}i:57;a:6:{i:0;s:124:"SELECT COUNT(*) FROM `contract` WHERE (`start_date` IS NULL) OR (`start_date`='') OR (`end_date` IS NULL) OR (`end_date`='')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33228206634521484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1713;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2104976;}i:59;a:6:{i:0;s:213:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `user` `u` ON u.id = s.staff_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL)) AND (`u`.`id` IS NULL)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33246898651123046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1722;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2110880;}i:60;a:6:{i:0;s:213:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `user` `u` ON u.id = s.staff_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL)) AND (`u`.`id` IS NULL)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3327949047088623046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1722;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2113048;}i:62;a:6:{i:0;s:217:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL)) AND (`c`.`id` IS NULL)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3329689502716064453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1729;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2116776;}i:63;a:6:{i:0;s:217:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL)) AND (`c`.`id` IS NULL)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.333302974700927734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1729;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2118976;}}}";s:2:"db";s:23557:"a:1:{s:8:"messages";a:28:{i:8;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3192880153656005859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1447896;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3201119899749755859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1469928;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3202250003814697265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1472672;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.320568084716796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1475296;}i:14;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3210480213165283203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1474832;}i:15;a:6:{i:0;s:764:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.32155609130859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1477040;}i:17;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.322019100189208984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1573248;}i:18;a:6:{i:0;s:33:"SELECT * FROM `user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3222980499267578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:42:"/home/carebook/public_html/models/User.php";s:4:"line";i:197;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:1577328;}i:35;a:6:{i:0;s:1039:"SELECT `s`.`client_id` AS `client_id`, `c`.`id` AS `linked_client_id`, TRIM(CONCAT(COALESCE(c.first_name, ''), ' ', COALESCE(c.last_name, ''))) AS `client_name`, COUNT(DISTINCT s.id) AS `shift_count`, COALESCE(SUM(CASE WHEN a.check_in IS NOT NULL AND a.check_out IS NOT NULL AND a.check_out > a.check_in THEN TIMESTAMPDIFF(MINUTE, a.check_in, a.check_out) WHEN s.start_time IS NOT NULL AND s.end_time IS NOT NULL AND s.end_time > s.start_time THEN TIMESTAMPDIFF(MINUTE, s.start_time, s.end_time) ELSE 0 END), 0) AS `total_minutes` FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id LEFT JOIN (SELECT `shift_id`, MIN(check_in) AS `check_in`, MAX(check_out) AS `check_out` FROM `attendance` WHERE NOT (`shift_id` IS NULL) GROUP BY `shift_id`) `a` ON a.shift_id = s.id WHERE (`s`.`start_time` >= '2026-06-01 00:00:00') AND (`s`.`start_time` < '2026-07-25 00:00:00') AND (NOT (`s`.`client_id` IS NULL)) GROUP BY `s`.`client_id`, `c`.`id`, `c`.`first_name`, `c`.`last_name` ORDER BY `c`.`last_name`, `c`.`first_name`, `s`.`client_id`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3276178836822509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2186;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1986536;}i:36;a:6:{i:0;s:1039:"SELECT `s`.`client_id` AS `client_id`, `c`.`id` AS `linked_client_id`, TRIM(CONCAT(COALESCE(c.first_name, ''), ' ', COALESCE(c.last_name, ''))) AS `client_name`, COUNT(DISTINCT s.id) AS `shift_count`, COALESCE(SUM(CASE WHEN a.check_in IS NOT NULL AND a.check_out IS NOT NULL AND a.check_out > a.check_in THEN TIMESTAMPDIFF(MINUTE, a.check_in, a.check_out) WHEN s.start_time IS NOT NULL AND s.end_time IS NOT NULL AND s.end_time > s.start_time THEN TIMESTAMPDIFF(MINUTE, s.start_time, s.end_time) ELSE 0 END), 0) AS `total_minutes` FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id LEFT JOIN (SELECT `shift_id`, MIN(check_in) AS `check_in`, MAX(check_out) AS `check_out` FROM `attendance` WHERE NOT (`shift_id` IS NULL) GROUP BY `shift_id`) `a` ON a.shift_id = s.id WHERE (`s`.`start_time` >= '2026-06-01 00:00:00') AND (`s`.`start_time` < '2026-07-25 00:00:00') AND (NOT (`s`.`client_id` IS NULL)) GROUP BY `s`.`client_id`, `c`.`id`, `c`.`first_name`, `c`.`last_name` ORDER BY `c`.`last_name`, `c`.`first_name`, `s`.`client_id`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3287770748138427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2186;s:8:"function";s:3:"all";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1989704;}i:38;a:6:{i:0;s:111:"SELECT COUNT(*) FROM `shift` `s` WHERE `s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3292291164398193359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1707;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1986440;}i:39;a:6:{i:0;s:111:"SELECT COUNT(*) FROM `shift` `s` WHERE `s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3295719623565673828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1707;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1988512;}i:41;a:6:{i:0;s:148:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.329782009124755859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1708;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1992832;}i:42;a:6:{i:0;s:148:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3300769329071044921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1708;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1994936;}i:44;a:6:{i:0;s:149:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3302409648895263671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1709;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:1998664;}i:45;a:6:{i:0;s:149:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3305079936981201171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1709;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2000768;}i:47;a:6:{i:0;s:206:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND ((`s`.`start_time` IS NULL) OR (`s`.`end_time` IS NULL) OR (s.end_time <= s.start_time))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.330708026885986328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1710;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2071528;}i:48;a:6:{i:0;s:206:"SELECT COUNT(*) FROM `shift` `s` WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND ((`s`.`start_time` IS NULL) OR (`s`.`end_time` IS NULL) OR (s.end_time <= s.start_time))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.330974102020263671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1710;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2073696;}i:50;a:6:{i:0;s:106:"SELECT COUNT(*) FROM `attendance` WHERE `check_in` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.331121921539306640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1711;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2076896;}i:51;a:6:{i:0;s:106:"SELECT COUNT(*) FROM `attendance` WHERE `check_in` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3313350677490234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1711;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2078968;}i:53;a:6:{i:0;s:75:"SELECT COUNT(DISTINCT client_id) FROM `contract` WHERE NOT (`rate` IS NULL)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3315451145172119140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1712;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2095360;}i:54;a:6:{i:0;s:75:"SELECT COUNT(DISTINCT client_id) FROM `contract` WHERE NOT (`rate` IS NULL)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33187007904052734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1712;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2097360;}i:56;a:6:{i:0;s:124:"SELECT COUNT(*) FROM `contract` WHERE (`start_date` IS NULL) OR (`start_date`='') OR (`end_date` IS NULL) OR (`end_date`='')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3320159912109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1713;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2102872;}i:57;a:6:{i:0;s:124:"SELECT COUNT(*) FROM `contract` WHERE (`start_date` IS NULL) OR (`start_date`='') OR (`end_date` IS NULL) OR (`end_date`='')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33228206634521484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1713;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2104976;}i:59;a:6:{i:0;s:213:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `user` `u` ON u.id = s.staff_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL)) AND (`u`.`id` IS NULL)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.33246898651123046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1722;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2110880;}i:60;a:6:{i:0;s:213:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `user` `u` ON u.id = s.staff_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`staff_id` IS NULL)) AND (`u`.`id` IS NULL)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3327949047088623046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1722;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2113048;}i:62;a:6:{i:0;s:217:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL)) AND (`c`.`id` IS NULL)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.3329689502716064453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1729;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2116776;}i:63;a:6:{i:0;s:217:"SELECT COUNT(*) FROM `shift` `s` LEFT JOIN `client` `c` ON c.id = s.client_id WHERE (`s`.`start_time` BETWEEN '2026-06-01 00:00:00' AND '2026-07-24 23:59:59') AND (NOT (`s`.`client_id` IS NULL)) AND (`c`.`id` IS NULL)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1783540907.333302974700927734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1729;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:2216;s:8:"function";s:20:"logReportDiagnostics";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:59:"/home/carebook/public_html/controllers/ReportController.php";s:4:"line";i:1470;s:8:"function";s:16:"buildBillingData";s:5:"class";s:32:"app\controllers\ReportController";s:4:"type";s:2:"->";}}i:5;i:2118976;}}}";s:5:"event";s:2663:"a:14:{i:0;a:5:{s:4:"time";d:1783540907.317821979522705078125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:1;a:5:{s:4:"time";d:1783540907.3192279338836669921875;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:2;a:5:{s:4:"time";d:1783540907.323401927947998046875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:3;a:5:{s:4:"time";d:1783540907.323523998260498046875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:4;a:5:{s:4:"time";d:1783540907.324099063873291015625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:5;a:5:{s:4:"time";d:1783540907.3258740901947021484375;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:6;a:5:{s:4:"time";d:1783540907.3262560367584228515625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:7;a:5:{s:4:"time";d:1783540907.3265879154205322265625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"app\controllers\ReportController";}i:8;a:5:{s:4:"time";d:1783540907.333383083343505859375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"app\controllers\ReportController";}i:9;a:5:{s:4:"time";d:1783540907.3334019184112548828125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:10;a:5:{s:4:"time";d:1783540907.3334290981292724609375;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:11;a:5:{s:4:"time";d:1783540907.3334410190582275390625;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:12;a:5:{s:4:"time";d:1783540907.3336799144744873046875;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:13;a:5:{s:4:"time";d:1783540907.333795070648193359375;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:122:"a:3:{s:5:"start";d:1783540907.314260959625244140625;s:3:"end";d:1783540907.3353459835052490234375;s:6:"memory";i:2128280;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1962:"a:3:{s:8:"messages";a:9:{i:22;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.32596492767333984375;i:4;a:0:{}i:5;i:1790816;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3259809017181396484375;i:4;a:0:{}i:5;i:1791568;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3259880542755126953125;i:4;a:0:{}i:5;i:1792320;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.325994014739990234375;i:4;a:0:{}i:5;i:1793072;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3259990215301513671875;i:4;a:0:{}i:5;i:1793824;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:8:"m/shifts";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3260040283203125;i:4;a:0:{}i:5;i:1794576;}i:28;a:6:{i:0;a:3:{s:4:"rule";s:16:"m/shift/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3260099887847900390625;i:4;a:0:{}i:5;i:1795328;}i:29;a:6:{i:0;a:3:{s:4:"rule";s:16:"yii\rest\UrlRule";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3260190486907958984375;i:4;a:0:{}i:5;i:1796080;}i:30;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1783540907.3260219097137451171875;i:4;a:0:{}i:5;i:1796456;}}s:5:"route";s:19:"report/billing-data";s:6:"action";s:53:"app\controllers\ReportController::actionBillingData()";}";s:7:"request";s:6719:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:15:{s:7:"x-https";s:1:"1";s:6:"cookie";s:424:"_identity=50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr%22%2C2592000%5D%22%3B%7D; _csrf=d4d6ca3bdbd044eb0c6f9833c5e63a8f2a05068fef024a5e546c6b52b12113a3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%224la13pCZDrrishJsSd3SeaiTW44jnYVI%22%3B%7D; PHPSESSID=1924f829a957432470a28bd55629aa08";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:7:"referer";s:51:"https://carebook.aximahealth.com/web/report/billing";s:14:"sec-fetch-dest";s:5:"empty";s:14:"sec-fetch-mode";s:4:"cors";s:14:"sec-fetch-site";s:11:"same-origin";s:16:"sec-ch-ua-mobile";s:2:"?0";s:9:"sec-ch-ua";s:65:""Google Chrome";v="149", "Chromium";v="149", "Not)A;Brand";v="24"";s:6:"accept";s:16:"application/json";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:10:"connection";s:10:"keep-alive";s:4:"host";s:24:"carebook.aximahealth.com";}s:15:"responseHeaders";a:6:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:23:"Content-Security-Policy";s:530:"default-src 'self'; script-src 'self' 'unsafe-inline' 'unsafe-eval' https://unpkg.com https://cdn.jsdelivr.net; style-src 'self' 'unsafe-inline' https://cdn.jsdelivr.net https://unpkg.com https://fonts.googleapis.com; font-src 'self' data: https://cdn.jsdelivr.net https://fonts.gstatic.com https://frontend-cdn.perplexity.ai; img-src 'self' data: https:; connect-src 'self' https://nominatim.openstreetmap.org https://cdn.jsdelivr.net https://unpkg.com https://cdnjs.cloudflare.com; frame-ancestors 'self'; base-uri 'self';";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";s:10:"Set-Cookie";s:294:"_identity=50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr%22%2C2592000%5D%22%3B%7D; expires=Fri, 07-Aug-2026 20:01:47 GMT; Max-Age=2592000; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:19:"report/billing-data";s:6:"action";s:53:"app\controllers\ReportController::actionBillingData()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:57:{s:4:"USER";s:8:"carebook";s:4:"HOME";s:14:"/home/carebook";s:11:"SCRIPT_NAME";s:14:"/web/index.php";s:11:"REQUEST_URI";s:68:"/web/report/billing-data?start=2026-06-01&end=2026-07-24&hide_zero=0";s:12:"QUERY_STRING";s:43:"start=2026-06-01&end=2026-07-24&hide_zero=0";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:21:"REDIRECT_QUERY_STRING";s:43:"start=2026-06-01&end=2026-07-24&hide_zero=0";s:12:"REDIRECT_URL";s:24:"/web/report/billing-data";s:11:"REMOTE_PORT";s:5:"37517";s:15:"SCRIPT_FILENAME";s:40:"/home/carebook/public_html/web/index.php";s:12:"SERVER_ADMIN";s:34:"webmaster@carebook.aximahealth.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:26:"/home/carebook/public_html";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:26:"/home/carebook/public_html";s:11:"REMOTE_ADDR";s:13:"99.251.247.10";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:13:"208.87.134.53";s:11:"SERVER_NAME";s:24:"carebook.aximahealth.com";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:12:"HTTP_X_HTTPS";s:1:"1";s:11:"HTTP_COOKIE";s:424:"_identity=50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr%22%2C2592000%5D%22%3B%7D; _csrf=d4d6ca3bdbd044eb0c6f9833c5e63a8f2a05068fef024a5e546c6b52b12113a3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%224la13pCZDrrishJsSd3SeaiTW44jnYVI%22%3B%7D; PHPSESSID=1924f829a957432470a28bd55629aa08";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:12:"HTTP_REFERER";s:51:"https://carebook.aximahealth.com/web/report/billing";s:19:"HTTP_SEC_FETCH_DEST";s:5:"empty";s:19:"HTTP_SEC_FETCH_MODE";s:4:"cors";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:14:"HTTP_SEC_CH_UA";s:65:""Google Chrome";v="149", "Chromium";v="149", "Not)A;Brand";v="24"";s:11:"HTTP_ACCEPT";s:16:"application/json";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:9:"HTTP_HOST";s:24:"carebook.aximahealth.com";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:24:"carebook.aximahealth.com";s:5:"HTTPS";s:2:"on";s:10:"SCRIPT_URI";s:56:"https://carebook.aximahealth.com/web/report/billing-data";s:10:"SCRIPT_URL";s:24:"/web/report/billing-data";s:9:"UNIQUE_ID";s:27:"ak6sq0mI3gOU89bedSu7hwAAAMU";s:15:"REDIRECT_STATUS";s:3:"200";s:20:"REDIRECT_SSL_TLS_SNI";s:24:"carebook.aximahealth.com";s:14:"REDIRECT_HTTPS";s:2:"on";s:19:"REDIRECT_SCRIPT_URI";s:56:"https://carebook.aximahealth.com/web/report/billing-data";s:19:"REDIRECT_SCRIPT_URL";s:24:"/web/report/billing-data";s:18:"REDIRECT_UNIQUE_ID";s:27:"ak6sq0mI3gOU89bedSu7hwAAAMU";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:14:"/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1783540907.3129460811614990234375;s:12:"REQUEST_TIME";i:1783540907;s:4:"argv";a:1:{i:0;s:43:"start=2026-06-01&end=2026-07-24&hide_zero=0";}s:4:"argc";i:1;}s:3:"GET";a:3:{s:5:"start";s:10:"2026-06-01";s:3:"end";s:10:"2026-07-24";s:9:"hide_zero";s:1:"0";}s:4:"POST";a:0:{}s:6:"COOKIE";a:3:{s:9:"_identity";s:148:"50c330ed3624af7e9a2602b149e8b0cfaedc4d5658812c02fc78ffdd009b7f33a:2:{i:0;s:9:"_identity";i:1;s:46:"[1,"rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr",2592000]";}";s:5:"_csrf";s:130:"d4d6ca3bdbd044eb0c6f9833c5e63a8f2a05068fef024a5e546c6b52b12113a3a:2:{i:0;s:5:"_csrf";i:1;s:32:"4la13pCZDrrishJsSd3SeaiTW44jnYVI";}";s:9:"PHPSESSID";s:32:"1924f829a957432470a28bd55629aa08";}s:5:"FILES";a:0:{}s:7:"SESSION";a:3:{s:7:"__flash";a:0:{}s:4:"__id";i:1;s:9:"__authKey";s:32:"rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr";}}";s:4:"user";s:2128:"a:5:{s:2:"id";i:1;s:8:"identity";a:19:{s:2:"id";s:1:"1";s:9:"legacy_id";s:4:"null";s:8:"username";s:7:"'admin'";s:13:"password_hash";s:62:"'$2a$12$W982fUIFEzH4KsJXsF0Y6O6IEluUb6eTttsxNpJm/.ctVOL3OJvvO'";s:8:"auth_key";s:34:"'rI7tx7iK32QFhkg4XoDZ0p0RdiZOTelr'";s:5:"email";s:19:"'admin@example.com'";s:10:"first_name";s:2:"''";s:9:"last_name";s:2:"''";s:5:"phone";s:2:"''";s:11:"avatar_path";s:55:"'/uploads/avatars/mABhkharf1K0VyKlbDaZhQIK98S97no5.png'";s:4:"role";s:12:"'SuperAdmin'";s:10:"created_at";s:10:"1757391733";s:10:"updated_at";s:10:"1758092193";s:7:"address";s:2:"''";s:13:"date_of_birth";s:4:"null";s:6:"gender";s:2:"''";s:9:"biography";s:2:"''";s:14:"certifications";s:2:"[]";s:8:"pay_rate";s:4:"null";}s:10:"attributes";a:19:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:9:"legacy_id";s:5:"label";s:9:"Legacy Id";}i:2;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:3;a:2:{s:9:"attribute";s:13:"password_hash";s:5:"label";s:13:"Password Hash";}i:4;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:5;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:6;a:2:{s:9:"attribute";s:10:"first_name";s:5:"label";s:10:"First Name";}i:7;a:2:{s:9:"attribute";s:9:"last_name";s:5:"label";s:9:"Last Name";}i:8;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:5:"Phone";}i:9;a:2:{s:9:"attribute";s:11:"avatar_path";s:5:"label";s:11:"Avatar Path";}i:10;a:2:{s:9:"attribute";s:4:"role";s:5:"label";s:4:"Role";}i:11;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:10:"Created At";}i:12;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}i:13;a:2:{s:9:"attribute";s:7:"address";s:5:"label";s:7:"Address";}i:14;a:2:{s:9:"attribute";s:13:"date_of_birth";s:5:"label";s:13:"Date Of Birth";}i:15;a:2:{s:9:"attribute";s:6:"gender";s:5:"label";s:6:"Gender";}i:16;a:2:{s:9:"attribute";s:9:"biography";s:5:"label";s:9:"Biography";}i:17;a:2:{s:9:"attribute";s:14:"certifications";s:5:"label";s:14:"Certifications";}i:18;a:2:{s:9:"attribute";s:8:"pay_rate";s:5:"label";s:8:"Pay Rate";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a4eacab4f2a5";s:3:"url";s:100:"https://carebook.aximahealth.com/web/report/billing-data?start=2026-06-01&end=2026-07-24&hide_zero=0";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:13:"99.251.247.10";s:4:"time";d:1783540907.3129460811614990234375;s:10:"statusCode";i:200;s:8:"sqlCount";i:14;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2128280;s:14:"processingTime";d:0.02081203460693359375;}s:10:"exceptions";a:0:{}}