a:14:{s:6:"config";s:3542:"a:5:{s:10:"phpVersion";s:6:"8.2.31";s:10:"yiiVersion";s:6:"2.0.47";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.47";s:4:"name";s:14:"My Application";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.2.31";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:13:{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:69:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2-faker/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.21.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:69:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2-debug/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:77:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2-symfonymailer/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:7:"2.0.3.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:74:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.5.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:67:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2-gii/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:76:"/home/rootpanelskygain/public_html/demo/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:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/select2";s:79:"/home/rootpanelskygain/public_html/demo/vendor/kartik-v/yii2-widget-select2/src";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/date";s:82:"/home/rootpanelskygain/public_html/demo/vendor/kartik-v/yii2-widget-datepicker/src";}}s:24:"rmrevin/yii2-fontawesome";a:3:{s:4:"name";s:24:"rmrevin/yii2-fontawesome";s:7:"version";s:7:"3.7.0.0";s:5:"alias";a:1:{s:24:"@rmrevin/yii/fontawesome";s:71:"/home/rootpanelskygain/public_html/demo/vendor/rmrevin/yii2-fontawesome";}}s:25:"froala/yii2-froala-editor";a:3:{s:4:"name";s:25:"froala/yii2-froala-editor";s:7:"version";s:8:"4.0.16.0";s:5:"alias";a:1:{s:20:"@froala/froalaeditor";s:76:"/home/rootpanelskygain/public_html/demo/vendor/froala/yii2-froala-editor/src";}}s:24:"kartik-v/yii2-date-range";a:3:{s:4:"name";s:24:"kartik-v/yii2-date-range";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:17:"@kartik/daterange";s:75:"/home/rootpanelskygain/public_html/demo/vendor/kartik-v/yii2-date-range/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:86:"/home/rootpanelskygain/public_html/demo/vendor/kartik-v/yii2-widget-datetimepicker/src";}}s:20:"yii2tech/spreadsheet";a:3:{s:4:"name";s:20:"yii2tech/spreadsheet";s:7:"version";s:7:"1.0.5.0";s:5:"alias";a:1:{s:21:"@yii2tech/spreadsheet";s:71:"/home/rootpanelskygain/public_html/demo/vendor/yii2tech/spreadsheet/src";}}}}";s:3:"log";s:16874:"a:1:{s:8:"messages";a:26:{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:1781189578.677218914031982421875;i:4;a:0:{}i:5;i:2560264;}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:1781189578.67794704437255859375;i:4;a:0:{}i:5;i:2671352;}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:1781189578.6779539585113525390625;i:4;a:0:{}i:5;i:2671992;}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:1781189578.682015895843505859375;i:4;a:0:{}i:5;i:3432896;}i:4;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `it_easy_user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.68824100494384765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:4960296;}i:5;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=rootpanelskygain_crm_demo";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1781189578.68826389312744140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:4962432;}i:10;a:6:{i:0;s:780:"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` = 'it_easy_user' AND `kcu`.`TABLE_NAME` = 'it_easy_user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.690351009368896484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5043888;}i:13;a:6:{i:0;s:69:"SELECT * FROM `it_easy_user` WHERE (`id`=206) AND (`status`='ACTIVE')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6932199001312255859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5481360;}i:16;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:1781189578.6960051059722900390625;i:4;a:0:{}i:5;i:5966688;}i:17;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1781189578.6974270343780517578125;i:4;a:0:{}i:5;i:6150760;}i:18;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:1781189578.697577953338623046875;i:4;a:0:{}i:5;i:6175176;}i:25;a:6:{i:0;s:19:"Route requested: ''";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1781189578.6985299587249755859375;i:4;a:0:{}i:5;i:6341992;}i:26;a:6:{i:0;s:24:"Route to run: site/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1781189578.69904994964599609375;i:4;a:0:{}i:5;i:6414216;}i:27;a:6:{i:0;s:65:"Running action: backend\controllers\SiteController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1781189578.7002069950103759765625;i:4;a:0:{}i:5;i:6680872;}i:28;a:6:{i:0;s:2054:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 20:22:58') AND (`it_easy_created_time` >= '2026-06-11 00:00:00')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7051029205322265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1041;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:89;s:8:"function";s:20:"MainDashboardnumbers";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7752768;}i:31;a:6:{i:0;s:2268:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("3","6") then 1 ELSE NULL END) AS `delivered_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("3","6") then it_easy_total_price ELSE 0 END) AS `delivered_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 23:59:59') AND (`it_easy_created_time` >= '2026-06-01 00:00:00')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7059180736541748046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1109;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:91;s:8:"function";s:36:"MainDashboardnumbersPrapaidThisMonth";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7761408;}i:34;a:6:{i:0;s:89:"Rendering view file: /home/rootpanelskygain/public_html/demo/backend/views/site/index.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1781189578.7072570323944091796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:7881264;}i:35;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.709846019744873046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8501880;}i:38;a:6:{i:0;s:802:"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` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7120668888092041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8563088;}i:41;a:6:{i:0;s:91:"Rendering view file: /home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1781189578.7172639369964599609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9693336;}i:42;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `it_easy_department`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7189788818359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10138936;}i:45;a:6:{i:0;s:792:"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` = 'it_easy_department' AND `kcu`.`TABLE_NAME` = 'it_easy_department'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.719811916351318359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10149072;}i:48;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7204759120941162109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10152672;}i:51;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7212278842926025390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:71:"/home/rootpanelskygain/public_html/demo/backend/views/common/header.php";s:4:"line";i:277;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:64;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10074784;}i:54;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 202.66.167.108";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1781189578.721600055694580078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:78;s:8:"function";s:7:"endBody";s:5:"class";s:12:"yii\web\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10127264;}i:55;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 202.66.167.108";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1781189578.7220489978790283203125;i:4;a:0:{}i:5;i:10049736;}}}";s:9:"profiling";s:26886:"a:3:{s:6:"memory";i:10492360;s:4:"time";d:0.051239013671875;s:8:"messages";a:24:{i:6;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=rootpanelskygain_crm_demo";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1781189578.688271999359130859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:4963240;}i:7;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=rootpanelskygain_crm_demo";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1781189578.6887629032135009765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5006544;}i:8;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `it_easy_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.688777923583984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5006328;}i:9;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `it_easy_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6899890899658203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5030232;}i:11;a:6:{i:0;s:780:"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` = 'it_easy_user' AND `kcu`.`TABLE_NAME` = 'it_easy_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6903679370880126953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5044928;}i:12;a:6:{i:0;s:780:"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` = 'it_easy_user' AND `kcu`.`TABLE_NAME` = 'it_easy_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6910760402679443359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5046784;}i:14;a:6:{i:0;s:69:"SELECT * FROM `it_easy_user` WHERE (`id`=206) AND (`status`='ACTIVE')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.693233966827392578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5481744;}i:15;a:6:{i:0;s:69:"SELECT * FROM `it_easy_user` WHERE (`id`=206) AND (`status`='ACTIVE')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.693440914154052734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5485984;}i:29;a:6:{i:0;s:2054:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 20:22:58') AND (`it_easy_created_time` >= '2026-06-11 00:00:00')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.705113887786865234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1041;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:89;s:8:"function";s:20:"MainDashboardnumbers";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7754168;}i:30;a:6:{i:0;s:2054:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 20:22:58') AND (`it_easy_created_time` >= '2026-06-11 00:00:00')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.705812931060791015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1041;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:89;s:8:"function";s:20:"MainDashboardnumbers";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7759640;}i:32;a:6:{i:0;s:2268:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("3","6") then 1 ELSE NULL END) AS `delivered_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("3","6") then it_easy_total_price ELSE 0 END) AS `delivered_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 23:59:59') AND (`it_easy_created_time` >= '2026-06-01 00:00:00')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7059280872344970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1109;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:91;s:8:"function";s:36:"MainDashboardnumbersPrapaidThisMonth";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7762808;}i:33;a:6:{i:0;s:2268:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("3","6") then 1 ELSE NULL END) AS `delivered_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("3","6") then it_easy_total_price ELSE 0 END) AS `delivered_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 23:59:59') AND (`it_easy_created_time` >= '2026-06-01 00:00:00')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7065179347991943359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1109;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:91;s:8:"function";s:36:"MainDashboardnumbersPrapaidThisMonth";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7768624;}i:36;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.709857940673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8503168;}i:37;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.71162891387939453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8609296;}i:39;a:6:{i:0;s:802:"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` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.71207904815673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8564504;}i:40;a:6:{i:0;s:802:"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` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7127110958099365234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8566736;}i:43;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `it_easy_department`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7189900875091552734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10140600;}i:44;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `it_easy_department`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7197129726409912109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10148832;}i:46;a:6:{i:0;s:792:"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` = 'it_easy_department' AND `kcu`.`TABLE_NAME` = 'it_easy_department'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7198240756988525390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10150864;}i:47;a:6:{i:0;s:792:"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` = 'it_easy_department' AND `kcu`.`TABLE_NAME` = 'it_easy_department'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7204129695892333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10153472;}i:49;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.720487117767333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10154552;}i:50;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7206690311431884765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10157016;}i:52;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7212390899658203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:71:"/home/rootpanelskygain/public_html/demo/backend/views/common/header.php";s:4:"line";i:277;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:64;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10076664;}i:53;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.721396923065185546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:71:"/home/rootpanelskygain/public_html/demo/backend/views/common/header.php";s:4:"line";i:277;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:64;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10079008;}}}";s:2:"db";s:26022:"a:1:{s:8:"messages";a:22:{i:8;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `it_easy_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.688777923583984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5006328;}i:9;a:6:{i:0;s:37:"SHOW FULL COLUMNS FROM `it_easy_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6899890899658203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5030232;}i:11;a:6:{i:0;s:780:"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` = 'it_easy_user' AND `kcu`.`TABLE_NAME` = 'it_easy_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6903679370880126953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5044928;}i:12;a:6:{i:0;s:780:"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` = 'it_easy_user' AND `kcu`.`TABLE_NAME` = 'it_easy_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.6910760402679443359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5046784;}i:14;a:6:{i:0;s:69:"SELECT * FROM `it_easy_user` WHERE (`id`=206) AND (`status`='ACTIVE')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.693233966827392578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5481744;}i:15;a:6:{i:0;s:69:"SELECT * FROM `it_easy_user` WHERE (`id`=206) AND (`status`='ACTIVE')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.693440914154052734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:62:"/home/rootpanelskygain/public_html/demo/common/models/User.php";s:4:"line";i:67;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5485984;}i:29;a:6:{i:0;s:2054:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 20:22:58') AND (`it_easy_created_time` >= '2026-06-11 00:00:00')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.705113887786865234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1041;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:89;s:8:"function";s:20:"MainDashboardnumbers";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7754168;}i:30;a:6:{i:0;s:2054:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 20:22:58') AND (`it_easy_created_time` >= '2026-06-11 00:00:00')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.705812931060791015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1041;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:89;s:8:"function";s:20:"MainDashboardnumbers";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7759640;}i:32;a:6:{i:0;s:2268:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("3","6") then 1 ELSE NULL END) AS `delivered_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("3","6") then it_easy_total_price ELSE 0 END) AS `delivered_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 23:59:59') AND (`it_easy_created_time` >= '2026-06-01 00:00:00')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7059280872344970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1109;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:91;s:8:"function";s:36:"MainDashboardnumbersPrapaidThisMonth";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7762808;}i:33;a:6:{i:0;s:2268:"SELECT COUNT(*) AS `total_leads`, SUM(it_easy_total_price) AS `sum_total_leads`, COUNT(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then 1 ELSE NULL END) AS `assign_leads`, SUM(CASE WHEN (`it_easy_assigned_to` <> "" OR `it_easy_retention_AGENTid` <> "" ) then it_easy_total_price ELSE NULL END) AS `assign_leads_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6", "12", "14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END) AS `confirm_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `confirm_sum`, SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_ordered_amount ELSE 0 END) AS `shopify_confirm_sum`, ROUND( SUM(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then it_easy_total_price ELSE 0 END) / COUNT(CASE WHEN `it_easy_order_status_id` IN ("1","2","3","4","5","6","14","15","16","24","23","25","26","27","28","29","30","31", "9", "22", "47") then 1 ELSE NULL END), 2) AS `average_ticket`, COUNT(CASE WHEN `it_easy_payment_code` != "COD" then 1 ELSE NULL END) AS `prepaid_order`, SUM(CASE WHEN `it_easy_payment_code` != "COD" then it_easy_total_price ELSE 0 END) AS `prepaid_order_amount`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then 1 ELSE NULL END) AS `dispatched_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("5","3","6","14","15","16","23","26","27","28","29","30", "9", "22", "47") then it_easy_total_price ELSE 0 END) AS `dispatched_order_sum`, COUNT(CASE WHEN `it_easy_order_status_id` IN ("3","6") then 1 ELSE NULL END) AS `delivered_order_count`, SUM(CASE WHEN `it_easy_order_status_id` IN ("3","6") then it_easy_total_price ELSE 0 END) AS `delivered_order_sum` FROM `it_easy_order_2023_2024` WHERE (`it_easy_created_time` <= '2026-06-11 23:59:59') AND (`it_easy_created_time` >= '2026-06-01 00:00:00')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7065179347991943359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/models/ItEasyOrder.php";s:4:"line";i:1109;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:91;s:8:"function";s:36:"MainDashboardnumbersPrapaidThisMonth";s:5:"class";s:26:"backend\models\ItEasyOrder";s:4:"type";s:2:"::";}}i:5;i:7768624;}i:36;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.709857940673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8503168;}i:37;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.71162891387939453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8609296;}i:39;a:6:{i:0;s:802:"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` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.71207904815673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8564504;}i:40;a:6:{i:0;s:802:"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` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7127110958099365234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/home/rootpanelskygain/public_html/demo/backend/views/site/index.php";s:4:"line";i:54;s:8:"function";s:12:"dropDownList";s:5:"class";s:23:"yii\widgets\ActiveField";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8566736;}i:43;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `it_easy_department`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7189900875091552734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10140600;}i:44;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `it_easy_department`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7197129726409912109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10148832;}i:46;a:6:{i:0;s:792:"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` = 'it_easy_department' AND `kcu`.`TABLE_NAME` = 'it_easy_department'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7198240756988525390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10150864;}i:47;a:6:{i:0;s:792:"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` = 'it_easy_department' AND `kcu`.`TABLE_NAME` = 'it_easy_department'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7204129695892333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10153472;}i:49;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.720487117767333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10154552;}i:50;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7206690311431884765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/rootpanelskygain/public_html/demo/backend/views/common/sidebar.php";s:4:"line";i:26;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:59;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10157016;}i:52;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.7212390899658203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:71:"/home/rootpanelskygain/public_html/demo/backend/views/common/header.php";s:4:"line";i:277;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:64;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10076664;}i:53;a:6:{i:0;s:55:"SELECT * FROM `it_easy_department` WHERE `it_easy_id`=8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1781189578.721396923065185546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:71:"/home/rootpanelskygain/public_html/demo/backend/views/common/header.php";s:4:"line";i:277;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:3:{s:4:"file";s:70:"/home/rootpanelskygain/public_html/demo/backend/views/layouts/main.php";s:4:"line";i:64;s:8:"function";s:7:"include";}i:2;a:5:{s:4:"file";s:78:"/home/rootpanelskygain/public_html/demo/backend/controllers/SiteController.php";s:4:"line";i:121;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:10079008;}}}";s:5:"event";s:8579:"a:45:{i:0;a:5:{s:4:"time";d:1781189578.6863639354705810546875;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:1781189578.6887590885162353515625;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:1781189578.693665981292724609375;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:"common\models\User";}i:3;a:5:{s:4:"time";d:1781189578.6936919689178466796875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"common\models\User";}i:4;a:5:{s:4:"time";d:1781189578.6946780681610107421875;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:"common\models\User";}i:5;a:5:{s:4:"time";d:1781189578.6982491016387939453125;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:1781189578.6990940570831298828125;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:1781189578.7001950740814208984375;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\controllers\SiteController";}i:8;a:5:{s:4:"time";d:1781189578.704677104949951171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:32:"backend\models\ItEasyOrderSearch";}i:9;a:5:{s:4:"time";d:1781189578.7047250270843505859375;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:10;a:5:{s:4:"time";d:1781189578.70584201812744140625;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:11;a:5:{s:4:"time";d:1781189578.707252979278564453125;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:12;a:5:{s:4:"time";d:1781189578.7078320980072021484375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:13;a:5:{s:4:"time";d:1781189578.7160279750823974609375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"kartik\date\DatePicker";}i:14;a:5:{s:4:"time";d:1781189578.7162799835205078125;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"kartik\date\DatePicker";}i:15;a:5:{s:4:"time";d:1781189578.7169110774993896484375;s:4:"name";s:18:"missingTranslation";s:5:"class";s:32:"yii\i18n\MissingTranslationEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"yii\i18n\PhpMessageSource";}i:16;a:5:{s:4:"time";d:1781189578.7169311046600341796875;s:4:"name";s:18:"missingTranslation";s:5:"class";s:32:"yii\i18n\MissingTranslationEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"yii\i18n\PhpMessageSource";}i:17;a:5:{s:4:"time";d:1781189578.716947078704833984375;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"kartik\date\DatePicker";}i:18;a:5:{s:4:"time";d:1781189578.716967105865478515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"kartik\date\DatePicker";}i:19;a:5:{s:4:"time";d:1781189578.7169830799102783203125;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"kartik\date\DatePicker";}i:20;a:5:{s:4:"time";d:1781189578.71706295013427734375;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"kartik\date\DatePicker";}i:21;a:5:{s:4:"time";d:1781189578.717073917388916015625;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:22;a:5:{s:4:"time";d:1781189578.71716594696044921875;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:23;a:5:{s:4:"time";d:1781189578.71724700927734375;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:24;a:5:{s:4:"time";d:1781189578.7172620296478271484375;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:25;a:5:{s:4:"time";d:1781189578.717381000518798828125;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:26;a:5:{s:4:"time";d:1781189578.718226909637451171875;s:4:"name";s:9:"beginBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:27;a:5:{s:4:"time";d:1781189578.7189519405364990234375;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:28;a:5:{s:4:"time";d:1781189578.7206900119781494140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:31:"backend\models\ItEasyDepartment";}i:29;a:5:{s:4:"time";d:1781189578.7207100391387939453125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:31:"backend\models\ItEasyDepartment";}i:30;a:5:{s:4:"time";d:1781189578.72117900848388671875;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:31;a:5:{s:4:"time";d:1781189578.721414089202880859375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:31:"backend\models\ItEasyDepartment";}i:32;a:5:{s:4:"time";d:1781189578.72142791748046875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:31:"backend\models\ItEasyDepartment";}i:33;a:5:{s:4:"time";d:1781189578.721541881561279296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"common\widgets\Alert";}i:34;a:5:{s:4:"time";d:1781189578.72154903411865234375;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"common\widgets\Alert";}i:35;a:5:{s:4:"time";d:1781189578.7215569019317626953125;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"common\widgets\Alert";}i:36;a:5:{s:4:"time";d:1781189578.7216091156005859375;s:4:"name";s:7:"endBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:37;a:5:{s:4:"time";d:1781189578.72169208526611328125;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:38;a:5:{s:4:"time";d:1781189578.721930980682373046875;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:39;a:5:{s:4:"time";d:1781189578.72194194793701171875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\controllers\SiteController";}i:40;a:5:{s:4:"time";d:1781189578.7219460010528564453125;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:41;a:5:{s:4:"time";d:1781189578.721951007843017578125;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:42;a:5:{s:4:"time";d:1781189578.7219541072845458984375;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:43;a:5:{s:4:"time";d:1781189578.722055912017822265625;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:44;a:5:{s:4:"time";d:1781189578.72231197357177734375;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:123:"a:3:{s:5:"start";d:1781189578.6717579364776611328125;s:3:"end";d:1781189578.723083972930908203125;s:6:"memory";i:10492360;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1351:"a:3:{s:8:"messages";a:6:{i:19;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:1781189578.69845104217529296875;i:4;a:0:{}i:5;i:6339840;}i:20;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:1781189578.6984729766845703125;i:4;a:0:{}i:5;i:6340432;}i:21;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:1781189578.6984989643096923828125;i:4;a:0:{}i:5;i:6341024;}i:22;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:1781189578.6985070705413818359375;i:4;a:0:{}i:5;i:6341616;}i:23;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:1781189578.698523998260498046875;i:4;a:0:{}i:5;i:6342208;}i:24;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:1781189578.698525905609130859375;i:4;a:0:{}i:5;i:6342424;}}s:5:"route";s:10:"site/index";s:6:"action";s:49:"backend\controllers\SiteController::actionIndex()";}";s:7:"request";s:6182:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:21:{s:6:"cookie";s:240:"advanced-backend=6068ac5a1bd3aca0014d74ba855e5ac1; _csrf-backend=386ff514666bead21e3bc4b650dab3a1063bcd81b6855cf70731757f109fa5a5a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22PrEzxKadI12YIbyGJGWQvoaaMgoTT1ok%22%3B%7D";s:13:"cache-control";s:9:"max-age=0";s:25:"upgrade-insecure-requests";s:1:"1";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36";s:6:"accept";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:14:"sec-fetch-site";s:11:"same-origin";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-user";s:2:"?1";s:14:"sec-fetch-dest";s:8:"document";s:9:"sec-ch-ua";s:65:""Chromium";v="148", "Google Chrome";v="148", "Not/A)Brand";v="99"";s:16:"sec-ch-ua-mobile";s:2:"?0";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:7:"referer";s:66:"https://rootpanel.skygainnutricare.com/demo/backend/web/site/login";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:8:"priority";s:6:"u=0, i";s:10:"connection";s:10:"Keep-Alive";s:6:"cf-ray";s:20:"a0a171524b110997-BOM";s:8:"cdn-loop";s:19:"cloudflare; loops=1";s:12:"cf-ipcountry";s:2:"IN";s:10:"cf-visitor";s:18:"{"scheme":"https"}";s:4:"host";s:30:"rootpanel.skygainnutricare.com";}s:15:"responseHeaders";a:4:{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:12:"Content-Type";s:24:"text/html; charset=UTF-8";}s:5:"route";s:10:"site/index";s:6:"action";s:49:"backend\controllers\SiteController::actionIndex()";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:65:{s:2:"TZ";s:12:"Asia/Kolkata";s:18:"REDIRECT_UNIQUE_ID";s:27:"airLyjKJJBMcB-HH8VSa7wAAAAo";s:19:"REDIRECT_SCRIPT_URL";s:18:"/demo/backend/web/";s:19:"REDIRECT_SCRIPT_URI";s:55:"http://rootpanel.skygainnutricare.com/demo/backend/web/";s:27:"REDIRECT_HTTP_AUTHORIZATION";s:0:"";s:18:"REDIRECT_x_api_key";s:0:"";s:16:"REDIRECT_HANDLER";s:28:"application/x-httpd-ea-php82";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"airLyjKJJBMcB-HH8VSa7wAAAAo";s:10:"SCRIPT_URL";s:18:"/demo/backend/web/";s:10:"SCRIPT_URI";s:55:"http://rootpanel.skygainnutricare.com/demo/backend/web/";s:11:"HTTP_COOKIE";s:240:"advanced-backend=6068ac5a1bd3aca0014d74ba855e5ac1; _csrf-backend=386ff514666bead21e3bc4b650dab3a1063bcd81b6855cf70731757f109fa5a5a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22PrEzxKadI12YIbyGJGWQvoaaMgoTT1ok%22%3B%7D";s:18:"HTTP_CACHE_CONTROL";s:9:"max-age=0";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:14:"HTTP_SEC_CH_UA";s:65:""Chromium";v="148", "Google Chrome";v="148", "Not/A)Brand";v="99"";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:12:"HTTP_REFERER";s:66:"https://rootpanel.skygainnutricare.com/demo/backend/web/site/login";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:13:"HTTP_PRIORITY";s:6:"u=0, i";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:11:"HTTP_CF_RAY";s:20:"a0a171524b110997-BOM";s:13:"HTTP_CDN_LOOP";s:19:"cloudflare; loops=1";s:17:"HTTP_CF_IPCOUNTRY";s:2:"IN";s:15:"HTTP_CF_VISITOR";s:18:"{"scheme":"https"}";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:20:"HTTP_X_FORWARDED_FOR";s:14:"202.66.167.108";s:9:"HTTP_HOST";s:30:"rootpanel.skygainnutricare.com";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:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:11:"SERVER_NAME";s:30:"rootpanel.skygainnutricare.com";s:11:"SERVER_ADDR";s:14:"172.105.43.203";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:14:"202.66.167.108";s:13:"DOCUMENT_ROOT";s:34:"/home/rootpanelskygain/public_html";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:8:"/cgi-sys";s:21:"CONTEXT_DOCUMENT_ROOT";s:26:"/usr/local/cpanel/cgi-sys/";s:12:"SERVER_ADMIN";s:40:"webmaster@rootpanel.skygainnutricare.com";s:15:"SCRIPT_FILENAME";s:61:"/home/rootpanelskygain/public_html/demo/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"12937";s:12:"REDIRECT_URL";s:27:"/demo/backend/web/index.php";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:18:"/demo/backend/web/";s:11:"SCRIPT_NAME";s:27:"/demo/backend/web/index.php";s:20:"ORIG_SCRIPT_FILENAME";s:34:"/usr/local/cpanel/cgi-sys/ea-php82";s:14:"ORIG_PATH_INFO";s:27:"/demo/backend/web/index.php";s:20:"ORIG_PATH_TRANSLATED";s:61:"/home/rootpanelskygain/public_html/demo/backend/web/index.php";s:16:"ORIG_SCRIPT_NAME";s:17:"/cgi-sys/ea-php82";s:8:"PHP_SELF";s:27:"/demo/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1781189578.66788196563720703125;s:12:"REQUEST_TIME";i:1781189578;s:4:"argv";a:0:{}s:4:"argc";i:0;s:5:"HTTPS";s:2:"on";}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:2:{s:16:"advanced-backend";s:32:"6068ac5a1bd3aca0014d74ba855e5ac1";s:13:"_csrf-backend";s:139:"386ff514666bead21e3bc4b650dab3a1063bcd81b6855cf70731757f109fa5a5a:2:{i:0;s:13:"_csrf-backend";i:1;s:32:"PrEzxKadI12YIbyGJGWQvoaaMgoTT1ok";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:5:{s:7:"__flash";a:0:{}s:11:"__returnUrl";s:56:"https://rootpanel.skygainnutricare.com/demo/backend/web/";s:4:"__id";i:206;s:9:"__authKey";s:32:"ziBs3biJMicymqodAtNj3RqLBC5oDd6i";s:8:"__expire";i:1781192578;}}";s:4:"user";s:3063:"a:5:{s:2:"id";i:206;s:8:"identity";a:24:{s:2:"id";s:3:"206";s:15:"it_easy_dept_id";s:1:"8";s:15:"it_easy_type_id";s:1:"1";s:17:"it_easy_firstname";s:7:"'Sunil'";s:16:"it_easy_lastname";s:5:"'Dev'";s:16:"it_easy_username";s:7:"'Sunil'";s:8:"auth_key";s:34:"'ziBs3biJMicymqodAtNj3RqLBC5oDd6i'";s:21:"it_easy_password_hash";s:62:"'$2y$13$1eKr2UfsLjipuerSeBjeC.EBzYObtDtyWcp.0KoHE1HNBRtETTvb2'";s:16:"it_easy_platform";s:41:"'Online Website,CRMLeads,Marketplace,RTO'";s:20:"password_reset_token";s:4:"null";s:5:"email";s:20:"'sunil@spunkads.com'";s:15:"is_manufacturer";s:1:"1";s:16:"is_product_buyer";s:1:"0";s:6:"status";s:8:"'ACTIVE'";s:19:"it_easy_permissions";s:4:"null";s:13:"last_login_ip";s:16:"'202.66.167.108'";s:12:"login_status";s:1:"1";s:13:"login_browser";s:15:"'Google Chrome'";s:12:"login_device";s:29:"'Windows NT 10.0; Win64; x64'";s:10:"created_at";s:2:"53";s:10:"updated_at";s:10:"1781189578";s:12:"created_time";s:21:"'2025-05-15 12:40:11'";s:12:"updated_time";s:21:"'2026-05-19 16:13:14'";s:18:"verification_token";s:4:"null";}s:10:"attributes";a:24:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:15:"it_easy_dept_id";s:5:"label";s:15:"It Easy Dept Id";}i:2;a:2:{s:9:"attribute";s:15:"it_easy_type_id";s:5:"label";s:15:"It Easy Type Id";}i:3;a:2:{s:9:"attribute";s:17:"it_easy_firstname";s:5:"label";s:17:"It Easy Firstname";}i:4;a:2:{s:9:"attribute";s:16:"it_easy_lastname";s:5:"label";s:16:"It Easy Lastname";}i:5;a:2:{s:9:"attribute";s:16:"it_easy_username";s:5:"label";s:16:"It Easy Username";}i:6;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:7;a:2:{s:9:"attribute";s:21:"it_easy_password_hash";s:5:"label";s:21:"It Easy Password Hash";}i:8;a:2:{s:9:"attribute";s:16:"it_easy_platform";s:5:"label";s:16:"It Easy Platform";}i:9;a:2:{s:9:"attribute";s:20:"password_reset_token";s:5:"label";s:20:"Password Reset Token";}i:10;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:11;a:2:{s:9:"attribute";s:15:"is_manufacturer";s:5:"label";s:15:"Is Manufacturer";}i:12;a:2:{s:9:"attribute";s:16:"is_product_buyer";s:5:"label";s:16:"Is Product Buyer";}i:13;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:14;a:2:{s:9:"attribute";s:19:"it_easy_permissions";s:5:"label";s:19:"It Easy Permissions";}i:15;a:2:{s:9:"attribute";s:13:"last_login_ip";s:5:"label";s:13:"Last Login Ip";}i:16;a:2:{s:9:"attribute";s:12:"login_status";s:5:"label";s:12:"Login Status";}i:17;a:2:{s:9:"attribute";s:13:"login_browser";s:5:"label";s:13:"Login Browser";}i:18;a:2:{s:9:"attribute";s:12:"login_device";s:5:"label";s:12:"Login Device";}i:19;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:10:"Created At";}i:20;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}i:21;a:2:{s:9:"attribute";s:12:"created_time";s:5:"label";s:12:"Created Time";}i:22;a:2:{s:9:"attribute";s:12:"updated_time";s:5:"label";s:12:"Updated Time";}i:23;a:2:{s:9:"attribute";s:18:"verification_token";s:5:"label";s:18:"Verification Token";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:4109:"a:8:{s:30:"yii\validators\ValidationAsset";a:9:{s:10:"sourcePath";s:66:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2/assets";s:8:"basePath";s:67:"/home/rootpanelskygain/public_html/demo/backend/web/assets/d0ca2451";s:7:"baseUrl";s:33:"/demo/backend/web/assets/d0ca2451";s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:2:"js";a:1:{i:0;s:17:"yii.validation.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:66:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2/assets";s:8:"basePath";s:67:"/home/rootpanelskygain/public_html/demo/backend/web/assets/d0ca2451";s:7:"baseUrl";s:33:"/demo/backend/web/assets/d0ca2451";s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:2:"js";a:1:{i:0;s:6:"yii.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:70:"/home/rootpanelskygain/public_html/demo/vendor/bower-asset/jquery/dist";s:8:"basePath";s:67:"/home/rootpanelskygain/public_html/demo/backend/web/assets/85610883";s:7:"baseUrl";s:33:"/demo/backend/web/assets/85610883";s:7:"depends";a:0:{}s:2:"js";a:1:{i:0;s:9:"jquery.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:27:"kartik\date\DatePickerAsset";a:17:{s:10:"sourcePath";s:89:"/home/rootpanelskygain/public_html/demo/vendor/kartik-v/yii2-widget-datepicker/src/assets";s:8:"basePath";s:67:"/home/rootpanelskygain/public_html/demo/backend/web/assets/df78a30d";s:7:"baseUrl";s:33:"/demo/backend/web/assets/df78a30d";s:7:"depends";a:2:{i:0;s:16:"yii\web\YiiAsset";i:1;s:29:"yii\bootstrap5\BootstrapAsset";}s:2:"js";a:2:{i:0;s:26:"js/bootstrap-datepicker.js";i:1;s:19:"js/datepicker-kv.js";}s:3:"css";a:2:{i:0;s:29:"css/bootstrap-datepicker4.css";i:1;s:21:"css/datepicker-kv.css";}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}s:19:"bsDependencyEnabled";b:1;s:15:"bsPluginEnabled";b:0;s:9:"bsVersion";N;s:16:"bsColCssPrefixes";a:0:{}s:9:"*_bsVer";i:5;s:21:"*_defaultIconPrefix";N;s:17:"*_defaultBtnCss";N;s:9:"*_isBs4";N;}s:29:"yii\bootstrap5\BootstrapAsset";a:9:{s:10:"sourcePath";s:73:"/home/rootpanelskygain/public_html/demo/vendor/bower-asset/bootstrap/dist";s:8:"basePath";s:67:"/home/rootpanelskygain/public_html/demo/backend/web/assets/c758f550";s:7:"baseUrl";s:33:"/demo/backend/web/assets/c758f550";s:7:"depends";a:0:{}s:2:"js";a:0:{}s:3:"css";a:1:{i:0;s:17:"css/bootstrap.css";}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:23:"kartik\base\WidgetAsset";a:17:{s:10:"sourcePath";s:83:"/home/rootpanelskygain/public_html/demo/vendor/kartik-v/yii2-krajee-base/src/assets";s:8:"basePath";s:66:"/home/rootpanelskygain/public_html/demo/backend/web/assets/5de5dd4";s:7:"baseUrl";s:32:"/demo/backend/web/assets/5de5dd4";s:7:"depends";a:2:{i:0;s:16:"yii\web\YiiAsset";i:1;s:29:"yii\bootstrap5\BootstrapAsset";}s:2:"js";a:1:{i:0;s:16:"js/kv-widgets.js";}s:3:"css";a:1:{i:0;s:18:"css/kv-widgets.css";}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}s:19:"bsDependencyEnabled";b:1;s:15:"bsPluginEnabled";b:0;s:9:"bsVersion";N;s:16:"bsColCssPrefixes";a:0:{}s:9:"*_bsVer";i:5;s:21:"*_defaultIconPrefix";N;s:17:"*_defaultBtnCss";N;s:9:"*_isBs4";N;}s:27:"yii\widgets\ActiveFormAsset";a:9:{s:10:"sourcePath";s:66:"/home/rootpanelskygain/public_html/demo/vendor/yiisoft/yii2/assets";s:8:"basePath";s:67:"/home/rootpanelskygain/public_html/demo/backend/web/assets/d0ca2451";s:7:"baseUrl";s:33:"/demo/backend/web/assets/d0ca2451";s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:2:"js";a:1:{i:0;s:17:"yii.activeForm.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:23:"backend\assets\AppAsset";a:9:{s:10:"sourcePath";N;s:8:"basePath";s:51:"/home/rootpanelskygain/public_html/demo/backend/web";s:7:"baseUrl";s:17:"/demo/backend/web";s:7:"depends";a:0:{}s:2:"js";a:0:{}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:7:"summary";a:12:{s:3:"tag";s:13:"6a2acbcaa9fd6";s:3:"url";s:56:"https://rootpanel.skygainnutricare.com/demo/backend/web/";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"202.66.167.108";s:4:"time";d:1781189578.66788196563720703125;s:10:"statusCode";i:200;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:10492360;s:14:"processingTime";d:0.051239013671875;}s:10:"exceptions";a:0:{}}