a:14:{s:6:"config";s:1624:"a:5:{s:10:"phpVersion";s:6:"8.1.34";s:10:"yiiVersion";s:6:"2.0.55";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.55";s:4:"name";s:11:"Dlink Sales";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.1.34";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:8:"2.0.51.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:81:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.28.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:76:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:76:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/yiisoft/yii2-faker/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/yiisoft/yii2-gii/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:84:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/yiisoft/yii2-symfonymailer/src";}}}}";s:3:"log";s:6620:"a:1:{s:8:"messages";a:20:{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:1780037906.56634807586669921875;i:4;a:0:{}i:5;i:2673728;}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:1780037906.567080974578857421875;i:4;a:0:{}i:5;i:2850864;}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:1780037906.5670878887176513671875;i:4;a:0:{}i:5;i:2851664;}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:1780037906.57155704498291015625;i:4;a:0:{}i:5;i:3856384;}i:4;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.578442096710205078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5410520;}i:5;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=blskysoftware_dlink_sales";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1780037906.5784590244293212890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5412976;}i:10;a:6:{i:0;s:28:"SHOW CREATE TABLE `crm_user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5791389942169189453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5494416;}i:13;a:6:{i:0;s:772:"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` = 'crm_user' AND `kcu`.`TABLE_NAME` = 'crm_user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5795199871063232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5507960;}i:16;a:6:{i:0;s:60:"SELECT * FROM `crm_user` WHERE (`id`=1) AND (`isActive`='Y')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.581491947174072265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5956768;}i:19;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780037906.5839519500732421875;i:4;a:0:{}i:5;i:6499160;}i:20;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780037906.5848560333251953125;i:4;a:0:{}i:5;i:6689344;}i:21;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1780037906.5849750041961669921875;i:4;a:0:{}i:5;i:6714208;}i:28;a:6:{i:0;s:38:"Route requested: 'uploadaraging/index'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1780037906.585659027099609375;i:4;a:0:{}i:5;i:6886464;}i:29;a:6:{i:0;s:33:"Route to run: uploadaraging/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1780037906.5864429473876953125;i:4;a:0:{}i:5;i:7060264;}i:30;a:6:{i:0;s:70:"Running action: app\controllers\UploadaragingController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1780037906.5872728824615478515625;i:4;a:0:{}i:5;i:7318776;}i:31;a:6:{i:0;s:89:"SELECT * FROM `crm_csv_upload_details` WHERE `type`='ar_aging' ORDER BY `id` DESC LIMIT 5";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.587378025054931640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:51;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7350552;}i:34;a:6:{i:0;s:97:"Rendering view file: /home/blskysoftware/public_html/dlinksalesyii2/views/uploadaraging/index.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1780037906.5881030559539794921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:53;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:7482616;}i:35;a:6:{i:0;s:90:"Rendering view file: /home/blskysoftware/public_html/dlinksalesyii2/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1780037906.5896689891815185546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:53;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:7927520;}i:36;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 42.104.154.198";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780037906.5911350250244140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/home/blskysoftware/public_html/dlinksalesyii2/views/layouts/main.php";s:4:"line";i:390;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:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:53;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:8241816;}i:37;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 42.104.154.198";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780037906.591339111328125;i:4;a:0:{}i:5;i:8128120;}}}";s:9:"profiling";s:6285:"a:3:{s:6:"memory";i:8271696;s:4:"time";d:0.031197071075439453125;s:8:"messages";a:12:{i:6;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=blskysoftware_dlink_sales";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1780037906.578465938568115234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5414104;}i:7;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=blskysoftware_dlink_sales";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1780037906.5786850452423095703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5457736;}i:8;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5787079334259033203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5457840;}i:9;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5791099071502685546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5492808;}i:11;a:6:{i:0;s:28:"SHOW CREATE TABLE `crm_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5791499614715576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5495648;}i:12;a:6:{i:0;s:28:"SHOW CREATE TABLE `crm_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5792140960693359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5498808;}i:14;a:6:{i:0;s:772:"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` = 'crm_user' AND `kcu`.`TABLE_NAME` = 'crm_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.579534053802490234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5509000;}i:15;a:6:{i:0;s:772:"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` = 'crm_user' AND `kcu`.`TABLE_NAME` = 'crm_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.579699993133544921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5511176;}i:17;a:6:{i:0;s:60:"SELECT * FROM `crm_user` WHERE (`id`=1) AND (`isActive`='Y')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.581509113311767578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5957152;}i:18;a:6:{i:0;s:60:"SELECT * FROM `crm_user` WHERE (`id`=1) AND (`isActive`='Y')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5816309452056884765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5963400;}i:32;a:6:{i:0;s:89:"SELECT * FROM `crm_csv_upload_details` WHERE `type`='ar_aging' ORDER BY `id` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5873858928680419921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:51;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7351840;}i:33;a:6:{i:0;s:89:"SELECT * FROM `crm_csv_upload_details` WHERE `type`='ar_aging' ORDER BY `id` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5875079631805419921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:51;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7354664;}}}";s:2:"db";s:5392:"a:1:{s:8:"messages";a:10:{i:8;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5787079334259033203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5457840;}i:9;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5791099071502685546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5492808;}i:11;a:6:{i:0;s:28:"SHOW CREATE TABLE `crm_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5791499614715576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5495648;}i:12;a:6:{i:0;s:28:"SHOW CREATE TABLE `crm_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5792140960693359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5498808;}i:14;a:6:{i:0;s:772:"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` = 'crm_user' AND `kcu`.`TABLE_NAME` = 'crm_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.579534053802490234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5509000;}i:15;a:6:{i:0;s:772:"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` = 'crm_user' AND `kcu`.`TABLE_NAME` = 'crm_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.579699993133544921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5511176;}i:17;a:6:{i:0;s:60:"SELECT * FROM `crm_user` WHERE (`id`=1) AND (`isActive`='Y')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.581509113311767578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5957152;}i:18;a:6:{i:0;s:60:"SELECT * FROM `crm_user` WHERE (`id`=1) AND (`isActive`='Y')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5816309452056884765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/home/blskysoftware/public_html/dlinksalesyii2/components/UserIdentity.php";s:4:"line";i:36;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5963400;}i:32;a:6:{i:0;s:89:"SELECT * FROM `crm_csv_upload_details` WHERE `type`='ar_aging' ORDER BY `id` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5873858928680419921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:51;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7351840;}i:33;a:6:{i:0;s:89:"SELECT * FROM `crm_csv_upload_details` WHERE `type`='ar_aging' ORDER BY `id` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780037906.5875079631805419921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:86:"/home/blskysoftware/public_html/dlinksalesyii2/controllers/UploadaragingController.php";s:4:"line";i:51;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7354664;}}}";s:5:"event";s:5276:"a:28:{i:0;a:5:{s:4:"time";d:1780037906.576612949371337890625;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:1780037906.5786800384521484375;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:1780037906.58164691925048828125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:3;a:5:{s:4:"time";d:1780037906.5816729068756103515625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\User";}i:4;a:5:{s:4:"time";d:1780037906.5855090618133544921875;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:5;a:5:{s:4:"time";d:1780037906.586472988128662109375;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:6;a:5:{s:4:"time";d:1780037906.58726596832275390625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:39:"app\controllers\UploadaragingController";}i:7;a:5:{s:4:"time";d:1780037906.587335109710693359375;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:8;a:5:{s:4:"time";d:1780037906.588099956512451171875;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:9;a:5:{s:4:"time";d:1780037906.5896561145782470703125;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:10;a:5:{s:4:"time";d:1780037906.5896670818328857421875;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:11;a:5:{s:4:"time";d:1780037906.59029293060302734375;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:12;a:5:{s:4:"time";d:1780037906.5902969837188720703125;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:13;a:5:{s:4:"time";d:1780037906.5907840728759765625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"yii\bootstrap5\Breadcrumbs";}i:14;a:5:{s:4:"time";d:1780037906.5908050537109375;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"yii\bootstrap5\Breadcrumbs";}i:15;a:5:{s:4:"time";d:1780037906.5909969806671142578125;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"yii\bootstrap5\Breadcrumbs";}i:16;a:5:{s:4:"time";d:1780037906.5910770893096923828125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:17;a:5:{s:4:"time";d:1780037906.591082096099853515625;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:18;a:5:{s:4:"time";d:1780037906.59109210968017578125;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:19;a:5:{s:4:"time";d:1780037906.5911428928375244140625;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:20;a:5:{s:4:"time";d:1780037906.5912001132965087890625;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:21;a:5:{s:4:"time";d:1780037906.5912609100341796875;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:22;a:5:{s:4:"time";d:1780037906.591269969940185546875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:39:"app\controllers\UploadaragingController";}i:23;a:5:{s:4:"time";d:1780037906.5912730693817138671875;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:24;a:5:{s:4:"time";d:1780037906.591278076171875;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:25;a:5:{s:4:"time";d:1780037906.59128093719482421875;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:26;a:5:{s:4:"time";d:1780037906.5913441181182861328125;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:27;a:5:{s:4:"time";d:1780037906.591371059417724609375;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:1780037906.5615170001983642578125;s:3:"end";d:1780037906.5927588939666748046875;s:6:"memory";i:8271696;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1368:"a:3:{s:8:"messages";a:6:{i:22;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780037906.58563709259033203125;i:4;a:0:{}i:5;i:6883336;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780037906.5856430530548095703125;i:4;a:0:{}i:5;i:6884088;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780037906.585647106170654296875;i:4;a:0:{}i:5;i:6884840;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780037906.585649967193603515625;i:4;a:0:{}i:5;i:6885592;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780037906.5856530666351318359375;i:4;a:0:{}i:5;i:6886344;}i:27;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:1780037906.5856549739837646484375;i:4;a:0:{}i:5;i:6886720;}}s:5:"route";s:19:"uploadaraging/index";s:6:"action";s:54:"app\controllers\UploadaragingController::actionIndex()";}";s:7:"request";s:18637:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:17:{s:7:"x-https";s:1:"1";s:8:"priority";s:6:"u=0, i";s:14:"sec-fetch-user";s:2:"?1";s:14:"sec-fetch-site";s:11:"same-origin";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-dest";s:8:"document";s:25:"upgrade-insecure-requests";s:1:"1";s:6:"cookie";s:318:"PHPSESSID=a8d3acb3c568f6bfe8418ce2fcbc531e; _csrf=aee92c83af36f16e0570e21f1f52fc7296e962c9723c502c7305001aa53534d3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22SebxClHf5FODLziJ8RuJHll-mczLWYJ3%22%3B%7D; cpsession=blskysoftware%3aR8oR7RkWNcdu0Ug2%2ce70d43314c521d4405c03679f591cb65; timezone=Asia/Kolkata";s:7:"referer";s:70:"https://bluesky-softwares.com/dlinksalesyii2/web/uploaddocuments/index";s:10:"connection";s:10:"keep-alive";s:7:"sec-gpc";s:1:"1";s:3:"dnt";s:1:"1";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:6:"accept";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:10:"user-agent";s:80:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:152.0) Gecko/20100101 Firefox/152.0";s:4:"host";s:21:"bluesky-softwares.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:19:"uploadaraging/index";s:6:"action";s:54:"app\controllers\UploadaragingController::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:58:{s:4:"USER";s:13:"blskysoftware";s:4:"HOME";s:19:"/home/blskysoftware";s:11:"SCRIPT_NAME";s:29:"/dlinksalesyii2/web/index.php";s:11:"REQUEST_URI";s:39:"/dlinksalesyii2/web/uploadaraging/index";s:12:"QUERY_STRING";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:12:"REDIRECT_URL";s:39:"/dlinksalesyii2/web/uploadaraging/index";s:11:"REMOTE_PORT";s:4:"1102";s:15:"SCRIPT_FILENAME";s:60:"/home/blskysoftware/public_html/dlinksalesyii2/web/index.php";s:12:"SERVER_ADMIN";s:31:"webmaster@bluesky-softwares.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:31:"/home/blskysoftware/public_html";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:31:"/home/blskysoftware/public_html";s:11:"REMOTE_ADDR";s:14:"42.104.154.198";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:15:"142.132.151.179";s:11:"SERVER_NAME";s:21:"bluesky-softwares.com";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:12:"HTTP_X_HTTPS";s:1:"1";s:13:"HTTP_PRIORITY";s:6:"u=0, i";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:11:"HTTP_COOKIE";s:318:"PHPSESSID=a8d3acb3c568f6bfe8418ce2fcbc531e; _csrf=aee92c83af36f16e0570e21f1f52fc7296e962c9723c502c7305001aa53534d3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22SebxClHf5FODLziJ8RuJHll-mczLWYJ3%22%3B%7D; cpsession=blskysoftware%3aR8oR7RkWNcdu0Ug2%2ce70d43314c521d4405c03679f591cb65; timezone=Asia/Kolkata";s:12:"HTTP_REFERER";s:70:"https://bluesky-softwares.com/dlinksalesyii2/web/uploaddocuments/index";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:12:"HTTP_SEC_GPC";s:1:"1";s:8:"HTTP_DNT";s:1:"1";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:11:"HTTP_ACCEPT";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:15:"HTTP_USER_AGENT";s:80:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:152.0) Gecko/20100101 Firefox/152.0";s:9:"HTTP_HOST";s:21:"bluesky-softwares.com";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:21:"bluesky-softwares.com";s:5:"HTTPS";s:2:"on";s:10:"SCRIPT_URI";s:68:"https://bluesky-softwares.com/dlinksalesyii2/web/uploadaraging/index";s:10:"SCRIPT_URL";s:39:"/dlinksalesyii2/web/uploadaraging/index";s:9:"UNIQUE_ID";s:27:"ahk5EgZDHq8I6y-XOrrm5AAAACE";s:15:"REDIRECT_STATUS";s:3:"200";s:20:"REDIRECT_SSL_TLS_SNI";s:21:"bluesky-softwares.com";s:14:"REDIRECT_HTTPS";s:2:"on";s:19:"REDIRECT_SCRIPT_URI";s:68:"https://bluesky-softwares.com/dlinksalesyii2/web/uploadaraging/index";s:19:"REDIRECT_SCRIPT_URL";s:39:"/dlinksalesyii2/web/uploadaraging/index";s:18:"REDIRECT_UNIQUE_ID";s:27:"ahk5EgZDHq8I6y-XOrrm5AAAACE";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:29:"/dlinksalesyii2/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1780037906.5560359954833984375;s:12:"REQUEST_TIME";i:1780037906;s:4:"argv";a:0:{}s:4:"argc";i:0;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:4:{s:9:"PHPSESSID";s:32:"a8d3acb3c568f6bfe8418ce2fcbc531e";s:5:"_csrf";s:130:"aee92c83af36f16e0570e21f1f52fc7296e962c9723c502c7305001aa53534d3a:2:{i:0;s:5:"_csrf";i:1;s:32:"SebxClHf5FODLziJ8RuJHll-mczLWYJ3";}";s:9:"cpsession";s:63:"blskysoftware:R8oR7RkWNcdu0Ug2,e70d43314c521d4405c03679f591cb65";s:8:"timezone";s:12:"Asia/Kolkata";}s:5:"FILES";a:0:{}s:7:"SESSION";a:62:{s:43:"f3e36398b126fb7e79bcfd12f13e5434__returnUrl";s:12:"/dlinksales/";s:3:"2fa";s:1:"N";s:5:"2faId";s:1:"0";s:7:"__flash";a:0:{}s:43:"25559ec4ef12ccf99dd7f11820b15a05__returnUrl";s:9:"/chaloub/";s:36:"25559ec4ef12ccf99dd7f11820b15a05__id";i:1;s:38:"25559ec4ef12ccf99dd7f11820b15a05__name";s:7:"nimda26";s:40:"25559ec4ef12ccf99dd7f11820b15a05fullname";s:10:"Admin User";s:54:"25559ec4ef12ccf99dd7f11820b15a05master_user_company_id";i:1;s:56:"25559ec4ef12ccf99dd7f11820b15a05master_user_company_code";s:5:"BL001";s:43:"25559ec4ef12ccf99dd7f11820b15a05user_branch";s:0:"";s:46:"25559ec4ef12ccf99dd7f11820b15a05user_locations";s:6:"1,3,14";s:44:"25559ec4ef12ccf99dd7f11820b15a05user_country";s:3:"130";s:45:"25559ec4ef12ccf99dd7f11820b15a05user_email_id";s:20:"arun@mailbluesky.com";s:47:"25559ec4ef12ccf99dd7f11820b15a05authorised_user";i:1;s:51:"25559ec4ef12ccf99dd7f11820b15a05master_company_name";s:34:"Bluesky Technology Consultants FZE";s:44:"25559ec4ef12ccf99dd7f11820b15a05main_db_name";s:31:"skyblueu_bluesky_erp_alpha_main";s:47:"25559ec4ef12ccf99dd7f11820b15a05company_db_name";s:21:"blskysoftware_chaloub";s:49:"25559ec4ef12ccf99dd7f11820b15a05company_head_user";s:1:"1";s:44:"25559ec4ef12ccf99dd7f11820b15a05company_logo";s:8:"logo.png";s:48:"25559ec4ef12ccf99dd7f11820b15a05pdf_company_logo";s:12:"pdf_logo.png";s:45:"25559ec4ef12ccf99dd7f11820b15a05footer_line_1";s:34:"Bluesky Technology Consultants FZE";s:45:"25559ec4ef12ccf99dd7f11820b15a05footer_line_2";s:43:"PO Box 15867, Ajman, UAE. Tel : 06 748 7105";s:52:"25559ec4ef12ccf99dd7f11820b15a05footer_autogenerated";s:48:"This report is auto generated by Digitalog  
on";s:40:"25559ec4ef12ccf99dd7f11820b15a05fin_year";i:1;s:51:"25559ec4ef12ccf99dd7f11820b15a05default_currency_id";i:1;s:58:"25559ec4ef12ccf99dd7f11820b15a05default_billing_country_id";s:3:"130";s:45:"25559ec4ef12ccf99dd7f11820b15a05user_group_id";s:1:"1";s:53:"25559ec4ef12ccf99dd7f11820b15a05company_general_email";s:17:"sales@bluesky.com";s:51:"25559ec4ef12ccf99dd7f11820b15a05company_general_web";s:0:"";s:56:"25559ec4ef12ccf99dd7f11820b15a05company_general_phone_no";s:11:"06 748 7105";s:48:"25559ec4ef12ccf99dd7f11820b15a05havePermissionOn";a:271:{s:8:"checkall";s:1:"1";s:14:"dash_check_all";s:1:"1";s:14:"dashboard_view";s:1:"1";s:20:"dashboardgender_view";s:1:"1";s:25:"dashboardnationality_view";s:1:"1";s:20:"dashboardeqpmnt_view";s:1:"1";s:17:"dashboardemp_view";s:1:"1";s:20:"dashboarddocexp_view";s:1:"1";s:24:"dashboarduptraining_view";s:1:"1";s:21:"dashboardtrained_view";s:1:"1";s:19:"dashboardagegp_view";s:1:"1";s:22:"dashboardjoindate_view";s:1:"1";s:20:"dashboardnetemp_view";s:1:"1";s:23:"dashboard_incident_view";s:1:"1";s:31:"dashboardne_emselectricity_view";s:1:"1";s:24:"dashboard_ems_water_view";s:1:"1";s:31:"dashboard_ems_wasterecycle_view";s:1:"1";s:32:"dashboard_ems_wastedisposal_view";s:1:"1";s:24:"dashboard_ems_paper_view";s:1:"1";s:20:"dashboard_attendance";s:1:"1";s:28:"dashboard_incident_reporting";s:1:"1";s:15:"dashboard_asset";s:1:"1";s:13:"mas_check_all";s:1:"1";s:14:"data_check_all";s:1:"1";s:13:"employee_menu";s:1:"1";s:21:"employee_listing_menu";s:1:"1";s:24:"employee_competency_menu";s:1:"1";s:18:"employee_docs_menu";s:1:"1";s:22:"employee_training_menu";s:1:"1";s:25:"employee_toolboxtalk_menu";s:1:"1";s:15:"employee_report";s:1:"1";s:11:"assets_menu";s:1:"1";s:19:"assets_listing_menu";s:1:"1";s:20:"assets_contract_menu";s:1:"1";s:19:"assets_service_menu";s:1:"1";s:18:"assets_repair_menu";s:1:"1";s:20:"assets_odometer_menu";s:1:"1";s:13:"assets_report";s:1:"1";s:12:"masters_menu";s:1:"1";s:14:"packaging_menu";s:1:"1";s:14:"packaging_list";s:1:"1";s:12:"company_menu";s:1:"1";s:15:"offloading_menu";s:1:"1";s:20:"asn_discrepancy_menu";s:1:"1";s:11:"others_menu";s:1:"1";s:16:"adhocrepair_menu";s:1:"1";s:8:"vas_menu";s:1:"1";s:26:"vas_update_production_time";s:1:"1";s:10:"vas_report";s:1:"1";s:23:"incident_reporting_menu";s:1:"1";s:12:"reports_menu";s:1:"1";s:25:"investigation_report_menu";s:1:"1";s:8:"ems_menu";s:1:"1";s:13:"ems_dash_menu";s:1:"1";s:12:"ems_loc_menu";s:1:"1";s:16:"ems_summary_menu";s:1:"1";s:22:"assets_inspection_menu";s:1:"1";s:30:"assets_inspection_manager_menu";s:1:"1";s:15:"inspection_copy";s:1:"1";s:30:"corrective_action_manager_menu";s:1:"1";s:11:"meeting_all";s:1:"1";s:12:"meeting_mine";s:1:"1";s:21:"datadetails_check_all";s:1:"1";s:12:"employee_add";s:1:"1";s:13:"employee_edit";s:1:"1";s:16:"employee_general";s:1:"1";s:22:"employee_status_change";s:1:"1";s:21:"employee_training_add";s:1:"1";s:22:"employee_training_edit";s:1:"1";s:24:"employee_training_delete";s:1:"1";s:23:"employee_competency_add";s:1:"1";s:24:"employee_competency_edit";s:1:"1";s:26:"employee_competency_delete";s:1:"1";s:21:"employee_document_add";s:1:"1";s:22:"employee_document_edit";s:1:"1";s:24:"employee_document_delete";s:1:"1";s:16:"toolbox_talk_add";s:1:"1";s:17:"toolbox_talk_edit";s:1:"1";s:19:"toolbox_talk_delete";s:1:"1";s:26:"toolbox_talk_status_change";s:1:"1";s:19:"toolbox_talk_upload";s:1:"1";s:26:"employee_doc_change_status";s:1:"1";s:13:"equipment_add";s:1:"1";s:14:"equipment_edit";s:1:"1";s:22:"equipment_service_edit";s:1:"1";s:14:"inspection_add";s:1:"1";s:17:"update_inspection";s:1:"1";s:17:"delete_inspection";s:1:"1";s:10:"repair_add";s:1:"1";s:13:"update_repair";s:1:"1";s:7:"vas_add";s:1:"1";s:10:"vas_update";s:1:"1";s:12:"vas_approval";s:1:"1";s:10:"vas_upload";s:1:"1";s:8:"vas_live";s:1:"1";s:9:"vas_graph";s:1:"1";s:23:"vas_post_inspection_add";s:1:"1";s:26:"incident_investigation_add";s:1:"1";s:27:"incident_investigation_edit";s:1:"1";s:29:"incident_investigation_delete";s:1:"1";s:28:"incident_investigation_print";s:1:"1";s:16:"incident_car_add";s:1:"1";s:17:"incident_car_edit";s:1:"1";s:19:"incident_car_delete";s:1:"1";s:18:"incident_car_print";s:1:"1";s:36:"car_corrective_preventive_action_add";s:1:"1";s:44:"car_confirm_closure_of_corrective_action_add";s:1:"1";s:28:"incident_reporting_save_edit";s:1:"1";s:13:"car_save_edit";s:1:"1";s:20:"inspection_save_edit";s:1:"1";s:11:"vendors_add";s:1:"1";s:12:"vendors_edit";s:1:"1";s:12:"contract_add";s:1:"1";s:13:"contract_edit";s:1:"1";s:15:"contract_delete";s:1:"1";s:18:"servicerequest_add";s:1:"1";s:19:"servicerequest_edit";s:1:"1";s:15:"admin_check_all";s:1:"1";s:9:"users_add";s:1:"1";s:10:"users_edit";s:1:"1";s:10:"users_list";s:1:"1";s:13:"usergroup_add";s:1:"1";s:14:"usergroup_edit";s:1:"1";s:14:"usergroup_list";s:1:"1";s:18:"external_check_all";s:1:"1";s:9:"claim_add";s:1:"1";s:10:"claim_edit";s:1:"1";s:10:"claim_list";s:1:"1";s:13:"claim_approve";s:1:"1";s:16:"externaluser_add";s:1:"1";s:17:"externaluser_edit";s:1:"1";s:17:"externaluser_list";s:1:"1";s:12:"location_add";s:1:"1";s:13:"location_edit";s:1:"1";s:13:"location_list";s:1:"1";s:11:"country_add";s:1:"1";s:12:"country_edit";s:1:"1";s:12:"country_list";s:1:"1";s:18:"tt_instruction_add";s:1:"1";s:19:"tt_instruction_edit";s:1:"1";s:19:"tt_instruction_list";s:1:"1";s:21:"tt_instruction_delete";s:1:"1";s:12:"riskarea_add";s:1:"1";s:13:"riskarea_edit";s:1:"1";s:13:"riskarea_list";s:1:"1";s:15:"riskarea_delete";s:1:"1";s:16:"riskactivity_add";s:1:"1";s:17:"riskactivity_edit";s:1:"1";s:17:"riskactivity_list";s:1:"1";s:19:"riskactivity_delete";s:1:"1";s:15:"riskcontrol_add";s:1:"1";s:16:"riskcontrol_edit";s:1:"1";s:16:"riskcontrol_list";s:1:"1";s:18:"riskcontrol_delete";s:1:"1";s:20:"doctype_category_add";s:1:"1";s:21:"doctype_category_edit";s:1:"1";s:21:"doctype_category_list";s:1:"1";s:11:"doctype_add";s:1:"1";s:12:"doctype_edit";s:1:"1";s:12:"doctype_list";s:1:"1";s:12:"category_add";s:1:"1";s:12:"categry_edit";s:1:"1";s:13:"category_list";s:1:"1";s:15:"subcategory_add";s:1:"1";s:16:"subcategory_edit";s:1:"1";s:16:"subcategory_list";s:1:"1";s:14:"delveryloc_add";s:1:"1";s:15:"delveryloc_edit";s:1:"1";s:15:"delveryloc_list";s:1:"1";s:13:"vecstatus_add";s:1:"1";s:14:"vecstatus_edit";s:1:"1";s:14:"vecstatus_list";s:1:"1";s:16:"vasoperation_add";s:1:"1";s:17:"vasoperation_edit";s:1:"1";s:17:"vasoperation_list";s:1:"1";s:19:"vasoperation_delete";s:1:"1";s:14:"vasproline_add";s:1:"1";s:15:"vasproline_edit";s:1:"1";s:15:"vasproline_list";s:1:"1";s:17:"vasproline_delete";s:1:"1";s:15:"vasstickers_add";s:1:"1";s:16:"vasstickers_edit";s:1:"1";s:16:"vasstickers_list";s:1:"1";s:22:"vas_pre_inspection_add";s:1:"1";s:23:"vas_pre_inspection_edit";s:1:"1";s:23:"vas_pre_inspection_list";s:1:"1";s:25:"vas_pre_inspection_delete";s:1:"1";s:27:"vas_sample_verification_add";s:1:"1";s:28:"vas_sample_verification_edit";s:1:"1";s:28:"vas_sample_verification_list";s:1:"1";s:30:"vas_sample_verification_delete";s:1:"1";s:11:"divison_add";s:1:"1";s:12:"divison_edit";s:1:"1";s:12:"divison_list";s:1:"1";s:14:"divison_delete";s:1:"1";s:9:"brand_add";s:1:"1";s:10:"brand_edit";s:1:"1";s:10:"brand_list";s:1:"1";s:17:"mail_settings_add";s:1:"1";s:18:"mail_settings_edit";s:1:"1";s:18:"mail_settings_list";s:1:"1";s:20:"mail_settings_delete";s:1:"1";s:22:"incident_checklist_add";s:1:"1";s:23:"incident_checklist_edit";s:1:"1";s:23:"incident_checklist_list";s:1:"1";s:19:"incident_injury_add";s:1:"1";s:20:"incident_injury_edit";s:1:"1";s:20:"incident_injury_list";s:1:"1";s:19:"incident_status_add";s:1:"1";s:20:"incident_status_edit";s:1:"1";s:20:"incident_status_list";s:1:"1";s:17:"incident_type_add";s:1:"1";s:18:"incident_type_edit";s:1:"1";s:18:"incident_type_list";s:1:"1";s:27:"incident_classification_add";s:1:"1";s:28:"incident_classification_edit";s:1:"1";s:28:"incident_classification_list";s:1:"1";s:32:"incident_loss_classification_add";s:1:"1";s:33:"incident_loss_classification_edit";s:1:"1";s:33:"incident_loss_classification_list";s:1:"1";s:18:"inspectiontype_add";s:1:"1";s:19:"inspectiontype_edit";s:1:"1";s:19:"inspectiontype_list";s:1:"1";s:21:"inspectiontype_delete";s:1:"1";s:20:"inspectionlevel1_add";s:1:"1";s:21:"inspectionlevel1_edit";s:1:"1";s:21:"inspectionlevel1_list";s:1:"1";s:23:"inspectionlevel1_delete";s:1:"1";s:20:"inspectionlevel2_add";s:1:"1";s:21:"inspectionlevel2_edit";s:1:"1";s:21:"inspectionlevel2_list";s:1:"1";s:23:"inspectionlevel2_delete";s:1:"1";s:20:"inspectionlevel3_add";s:1:"1";s:21:"inspectionlevel3_edit";s:1:"1";s:21:"inspectionlevel3_list";s:1:"1";s:23:"inspectionlevel3_delete";s:1:"1";s:28:"inspectionquestionnaires_add";s:1:"1";s:29:"inspectionquestionnaires_edit";s:1:"1";s:29:"inspectionquestionnaires_list";s:1:"1";s:31:"inspectionquestionnaires_delete";s:1:"1";s:20:"mas_divison_type_add";s:1:"1";s:21:"mas_divison_type_edit";s:1:"1";s:21:"mas_divison_type_list";s:1:"1";s:7:"ims_add";s:1:"1";s:8:"ims_edit";s:1:"1";s:8:"ims_list";s:1:"1";s:13:"ims_view_list";s:1:"1";s:11:"meeting_add";s:1:"1";s:12:"meeting_edit";s:1:"1";s:12:"meeting_list";s:1:"1";s:14:"meeting_delete";s:1:"1";s:16:"meeting_type_add";s:1:"1";s:17:"meeting_type_edit";s:1:"1";s:17:"meeting_type_list";s:1:"1";s:19:"meeting_type_delete";s:1:"1";s:13:"ownership_add";s:1:"1";s:14:"ownership_edit";s:1:"1";s:14:"ownership_list";s:1:"1";s:16:"ownership_delete";s:1:"1";s:11:"cmp_doc_add";s:1:"1";s:12:"cmp_doc_edit";s:1:"1";s:12:"cmp_doc_list";s:1:"1";s:14:"cmp_doc_delete";s:1:"1";s:13:"cmp_event_add";s:1:"1";s:14:"cmp_event_edit";s:1:"1";s:14:"cmp_event_list";s:1:"1";s:16:"cmp_event_delete";s:1:"1";s:7:"cmp_add";s:1:"1";s:8:"cmp_edit";s:1:"1";s:8:"cmp_list";s:1:"1";s:10:"cmp_delete";s:1:"1";}s:40:"25559ec4ef12ccf99dd7f11820b15a05__states";a:25:{s:8:"fullname";b:1;s:22:"master_user_company_id";b:1;s:24:"master_user_company_code";b:1;s:11:"user_branch";b:1;s:14:"user_locations";b:1;s:12:"user_country";b:1;s:13:"user_email_id";b:1;s:15:"authorised_user";b:1;s:19:"master_company_name";b:1;s:12:"main_db_name";b:1;s:15:"company_db_name";b:1;s:17:"company_head_user";b:1;s:12:"company_logo";b:1;s:16:"pdf_company_logo";b:1;s:13:"footer_line_1";b:1;s:13:"footer_line_2";b:1;s:20:"footer_autogenerated";b:1;s:8:"fin_year";b:1;s:19:"default_currency_id";b:1;s:26:"default_billing_country_id";b:1;s:13:"user_group_id";b:1;s:21:"company_general_email";b:1;s:19:"company_general_web";b:1;s:24:"company_general_phone_no";b:1;s:16:"havePermissionOn";b:1;}s:8:"fullname";s:17:"Test Bluesky User";s:22:"master_user_company_id";i:1;s:11:"user_branch";s:0:"";s:13:"user_email_id";s:23:"support@mailbluesky.com";s:15:"authorised_user";i:0;s:19:"master_company_code";s:5:"DLINK";s:5:"level";i:1;s:12:"usergroup_id";s:1:"1";s:19:"master_company_name";s:5:"Dlink";s:15:"company_db_name";s:25:"blskysoftware_dlink_sales";s:17:"company_head_user";s:1:"1";s:12:"company_logo";s:8:"logo.png";s:16:"pdf_company_logo";s:12:"pdf_logo.png";s:13:"footer_line_1";s:29:"Mediyaan Medical Supplies LLC";s:13:"footer_line_2";s:116:"M109, Shaikha Mhara- Al Qusais Building, Al
Qusais 2, Dubai, United Arab Emirates,
Tel:+971501934172
            ";s:20:"footer_autogenerated";s:106:"This is a system generated output and requires no signature. This document is printed from Bluesky ERP on ";s:8:"fin_year";i:1;s:21:"company_base_currency";i:1;s:19:"company_footer_logo";s:1:"-";s:21:"company_general_email";s:1:"-";s:19:"company_general_web";s:1:"-";s:24:"company_general_phone_no";s:13:"+971501934172";s:18:"qtn_approval_limit";d:0;s:20:"order_approval_limit";d:0;s:21:"min_profit_percentage";d:0;s:16:"havePermissionOn";a:0:{}s:18:"haveHrPermissionOn";a:0:{}s:4:"__id";i:1;s:9:"__authKey";s:12:"1-1712033763";}}";s:4:"user";s:183:"a:5:{s:2:"id";i:1;s:8:"identity";a:3:{s:2:"id";s:1:"1";s:8:"username";s:8:"'sadmin'";s:9:"errorCode";s:1:"0";}s:10:"attributes";N;s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:2683:"a:5:{s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:77:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/bower-asset/jquery/dist";s:8:"basePath";s:66:"/home/blskysoftware/public_html/dlinksalesyii2/web/assets/9545c4c3";s:7:"baseUrl";s:35:"/dlinksalesyii2/web/assets/9545c4c3";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:1:{s:8:"position";i:1;}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:24:"app\assets\CrmThemeAsset";a:9:{s:10:"sourcePath";N;s:8:"basePath";s:50:"/home/blskysoftware/public_html/dlinksalesyii2/web";s:7:"baseUrl";s:19:"/dlinksalesyii2/web";s:7:"depends";a:3:{i:0;s:16:"yii\web\YiiAsset";i:1;s:29:"yii\bootstrap5\BootstrapAsset";i:2;s:35:"yii\bootstrap5\BootstrapPluginAsset";}s:2:"js";a:2:{i:0;s:65:"https://cdn.jsdelivr.net/npm/lucide@latest/dist/umd/lucide.min.js";i:1;s:10:"js/site.js";}s:3:"css";a:3:{i:0;s:130:"https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&family=Plus+Jakarta+Sans:wght@400;500;600;700&display=swap";i:1;s:80:"https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css";i:2;s:12:"css/site.css";}s:9:"jsOptions";a:1:{s:8:"position";i:1;}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:73:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/yiisoft/yii2/assets";s:8:"basePath";s:66:"/home/blskysoftware/public_html/dlinksalesyii2/web/assets/49249ced";s:7:"baseUrl";s:35:"/dlinksalesyii2/web/assets/49249ced";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:1:{s:8:"position";i:1;}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:29:"yii\bootstrap5\BootstrapAsset";a:9:{s:10:"sourcePath";s:77:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/twbs/bootstrap/dist/css";s:8:"basePath";s:66:"/home/blskysoftware/public_html/dlinksalesyii2/web/assets/b820e333";s:7:"baseUrl";s:35:"/dlinksalesyii2/web/assets/b820e333";s:7:"depends";a:0:{}s:2:"js";a:0:{}s:3:"css";a:1:{i:0;s:13:"bootstrap.css";}s:9:"jsOptions";a:1:{s:8:"position";i:1;}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:35:"yii\bootstrap5\BootstrapPluginAsset";a:9:{s:10:"sourcePath";s:76:"/home/blskysoftware/public_html/dlinksalesyii2/vendor/twbs/bootstrap/dist/js";s:8:"basePath";s:66:"/home/blskysoftware/public_html/dlinksalesyii2/web/assets/963b2200";s:7:"baseUrl";s:35:"/dlinksalesyii2/web/assets/963b2200";s:7:"depends";a:1:{i:0;s:29:"yii\bootstrap5\BootstrapAsset";}s:2:"js";a:1:{i:0;s:19:"bootstrap.bundle.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:1:{s:8:"position";i:1;}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a1939128e9e2";s:3:"url";s:68:"https://bluesky-softwares.com/dlinksalesyii2/web/uploadaraging/index";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"42.104.154.198";s:4:"time";d:1780037906.5560359954833984375;s:10:"statusCode";i:200;s:8:"sqlCount";i:5;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8271696;s:14:"processingTime";d:0.031197071075439453125;}s:10:"exceptions";a:0:{}}