a:8:{s:6:"config";a:5:{s:10:"phpVersion";s:6:"7.1.19";s:10:"yiiVersion";s:5:"2.0.9";s:11:"application";a:4:{s:3:"yii";s:5:"2.0.9";s:4:"name";s:22:"极办公:管理后台";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:4:{s:7:"version";s:6:"7.1.19";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;}s:10:"extensions";a:9:{s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.3.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:54:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-faker";}}s:18:"yiisoft/yii2-redis";a:3:{s:4:"name";s:18:"yiisoft/yii2-redis";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/redis";s:54:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-redis";}}s:24:"yiisoft/yii2-codeception";a:3:{s:4:"name";s:24:"yiisoft/yii2-codeception";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:16:"@yii/codeception";s:60:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-codeception";}}s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:7:"2.0.6.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:58:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-bootstrap";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:7:"2.0.6.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:54:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-debug";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:52:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-gii";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.0.6.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:60:"/Users/scott/projects/jw/src/vendor/yiisoft/yii2-swiftmailer";}}s:14:"conquer/oauth2";a:3:{s:4:"name";s:14:"conquer/oauth2";s:7:"version";s:7:"1.5.3.0";s:5:"alias";a:1:{s:15:"@conquer/oauth2";s:50:"/Users/scott/projects/jw/src/vendor/conquer/oauth2";}}s:24:"filsh/yii2-oauth2-server";a:4:{s:4:"name";s:24:"filsh/yii2-oauth2-server";s:7:"version";s:7:"2.0.1.0";s:5:"alias";a:1:{s:24:"@filsh/yii2/oauth2server";s:60:"/Users/scott/projects/jw/src/vendor/filsh/yii2-oauth2-server";}s:9:"bootstrap";s:33:"filsh\yii2\oauth2server\Bootstrap";}}}s:7:"request";a:14:{s:7:"flashes";a:0:{}s:10:"statusCode";i:500;s:14:"requestHeaders";a:12:{s:6:"cookie";s:210:"_csrf=5114702b18e8fd3c2ee00991f8672ff86251a08f62849660b7a3e0103442402ca%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22Pu82Vhz3dVvbS41wy-1mDhE3iOt7dIkY%22%3B%7D; PHPSESSID=83alvsdk0t2is2m4l816uta5be";s:15:"accept-language";s:35:"en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7";s:15:"accept-encoding";s:13:"gzip, deflate";s:7:"referer";s:47:"http://jiworkadmin:8012/engineer/engineer/index";s:6:"accept";s:118:"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3";s:10:"user-agent";s:121:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36";s:3:"dnt";s:1:"1";s:25:"upgrade-insecure-requests";s:1:"1";s:13:"cache-control";s:8:"no-cache";s:6:"pragma";s:8:"no-cache";s:10:"connection";s:10:"keep-alive";s:4:"host";s:16:"jiworkadmin:8012";}s:15:"responseHeaders";a:5:{s:12:"X-Powered-By";s:10:"PHP/7.1.19";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:25:"engineer/engineer/details";s:6:"action";s:71:"app\ht\modules\engineer\controllers\EngineerController::actionDetails()";s:12:"actionParams";a:0:{}s:11:"requestBody";a:0:{}s:6:"SERVER";a:37:{s:4:"USER";s:5:"scott";s:4:"HOME";s:12:"/Users/scott";s:11:"HTTP_COOKIE";s:210:"_csrf=5114702b18e8fd3c2ee00991f8672ff86251a08f62849660b7a3e0103442402ca%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22Pu82Vhz3dVvbS41wy-1mDhE3iOt7dIkY%22%3B%7D; PHPSESSID=83alvsdk0t2is2m4l816uta5be";s:20:"HTTP_ACCEPT_LANGUAGE";s:35:"en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:12:"HTTP_REFERER";s:47:"http://jiworkadmin:8012/engineer/engineer/index";s:11:"HTTP_ACCEPT";s:118:"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3";s:15:"HTTP_USER_AGENT";s:121:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36";s:8:"HTTP_DNT";s:1:"1";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:18:"HTTP_CACHE_CONTROL";s:8:"no-cache";s:11:"HTTP_PRAGMA";s:8:"no-cache";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:9:"HTTP_HOST";s:16:"jiworkadmin:8012";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"SERVER_NAME";s:11:"jiworkadmin";s:11:"SERVER_PORT";s:4:"8012";s:11:"SERVER_ADDR";s:9:"127.0.0.1";s:11:"REMOTE_PORT";s:5:"51609";s:11:"REMOTE_ADDR";s:9:"127.0.0.1";s:15:"SERVER_SOFTWARE";s:12:"nginx/1.15.0";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:14:"REQUEST_SCHEME";s:4:"http";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:13:"DOCUMENT_ROOT";s:39:"/Users/scott/projects/jw/src/app-ht/web";s:12:"DOCUMENT_URI";s:10:"/index.php";s:11:"REQUEST_URI";s:45:"/engineer/engineer/details?id=11786&egstatus=";s:11:"SCRIPT_NAME";s:10:"/index.php";s:14:"CONTENT_LENGTH";s:0:"";s:12:"CONTENT_TYPE";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:46:"r=engineer/engineer/details&id=11786&egstatus=";s:15:"SCRIPT_FILENAME";s:49:"/Users/scott/projects/jw/src/app-ht/web/index.php";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1556185520.941322;s:12:"REQUEST_TIME";i:1556185520;}s:3:"GET";a:3:{s:1:"r";s:25:"engineer/engineer/details";s:2:"id";s:5:"11786";s:8:"egstatus";s:0:"";}s:4:"POST";a:0:{}s:6:"COOKIE";a:2:{s:5:"_csrf";s:130:"5114702b18e8fd3c2ee00991f8672ff86251a08f62849660b7a3e0103442402ca:2:{i:0;s:5:"_csrf";i:1;s:32:"Pu82Vhz3dVvbS41wy-1mDhE3iOt7dIkY";}";s:9:"PHPSESSID";s:26:"83alvsdk0t2is2m4l816uta5be";}s:5:"FILES";a:0:{}s:7:"SESSION";a:4:{s:7:"__flash";a:0:{}s:11:"__returnUrl";s:1:"/";s:4:"__id";i:1;s:8:"__expire";i:1556187321;}}s:3:"log";a:1:{s:8:"messages";a:42:{i:0;a:5:{i:0;s:61:"Bootstrap with filsh\yii2\oauth2server\Bootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1556185520.978447;i:4;a:0:{}}i:1;a:5:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1556185520.981329;i:4;a:0:{}}i:2;a:5:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1556185520.981334;i:4;a:0:{}}i:3;a:5:{i:0;s:67:"Bootstrap with app\ht\exts\AssetsAutoCompressComponent::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1556185520.981839;i:4;a:0:{}}i:4;a:5:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1556185520.982996;i:4;a:0:{}}i:5;a:5:{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:1556185520.985789;i:4;a:0:{}}i:6;a:5:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1556185520.988847;i:4;a:0:{}}i:7;a:5:{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:1556185520.989135;i:4;a:0:{}}i:8;a:5:{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:1556185520.995605;i:4;a:0:{}}i:9;a:5:{i:0;s:44:"Route requested: 'engineer/engineer/details'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1556185520.99562;i:4;a:0:{}}i:10;a:5:{i:0;s:24:"Loading module: engineer";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1556185520.995632;i:4;a:0:{}}i:11;a:5:{i:0;s:39:"Route to run: engineer/engineer/details";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1556185521.004678;i:4;a:0:{}}i:12;a:5:{i:0;s:55:"Opening redis DB connection: 127.0.0.1:6379, database=0";i:1;i:8;i:2;s:26:"yii\redis\Connection::open";i:3;d:1556185521.0071;i:4;a:0:{}}i:13;a:5:{i:0;s:31:"Executing Redis Command: SELECT";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1556185521.007395;i:4;a:0:{}}i:14;a:5:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1556185521.007495;i:4;a:0:{}}i:15;a:5:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1556185521.007582;i:4;a:0:{}}i:16;a:5:{i:0;s:42:"SHOW FULL COLUMNS FROM `jiwork`.`sys_user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.021294;i:4;a:0:{}}i:17;a:5:{i:0;s:62:"Opening DB connection: mysql:host=127.0.0.1;dbname=jiwork_prod";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1556185521.021317;i:4;a:0:{}}i:22;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'sys_user' AND kcu.table_name = 'sys_user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.028156;i:4;a:0:{}}i:25;a:5:{i:0;s:46:"SELECT * FROM `jiwork`.`sys_user` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.092291;i:4;a:0:{}}i:28;a:5:{i:0;s:87:"Running action: app\ht\modules\engineer\controllers\EngineerController::actionDetails()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1556185521.093666;i:4;a:0:{}}i:29;a:5:{i:0;s:684:"SELECT `engineer`.*, IFNULL(engineer_wallet.balance,0) as balance, `engineer_profile`.`headimgurl` AS `headimgurl`, `engineer_profile`.`head_photo` AS `head_photo`, `engineer_profile`.`id_card_no` AS `id_card_no`, `engineer_profile`.`firstname` AS `firstname`, `engineer_profile`.`lastname` AS `lastname`, `engineer_profile`.`nickname` AS `nickname`, `engineer_profile`.`block_reason` AS `blockReason`, `is_bind_device_camera_enable`, `is_bind_device_album_enable`, `choose_album_img_count` FROM `engineer` LEFT JOIN `engineer_profile` ON engineer_profile.engineer_id = engineer.id LEFT JOIN `engineer_wallet` ON engineer_wallet.engineer_id = engineer.id WHERE `engineer`.`id`='11786'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.094687;i:4;a:0:{}}i:32;a:5:{i:0;s:33:"SHOW FULL COLUMNS FROM `engineer`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.104177;i:4;a:0:{}}i:35;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer' AND kcu.table_name = 'engineer'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.110042;i:4;a:0:{}}i:38;a:5:{i:0;s:325:"SELECT COUNT(*) FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.172406;i:4;a:0:{}}i:41;a:5:{i:0;s:405:"SELECT `repair_order`.*, `user`.`name` AS `customer`, `address`.`address` AS `address` FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786') LIMIT 20";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.175661;i:4;a:0:{}}i:44;a:5:{i:0;s:115:"SELECT sum(amount) as t_amount, `status` FROM `engineer_order_income` WHERE `engineer_id`='11786' GROUP BY `status`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.177134;i:4;a:0:{}}i:47;a:5:{i:0;s:32:"SHOW FULL COLUMNS FROM `address`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.181284;i:4;a:0:{}}i:50;a:5:{i:0;s:601:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'address' AND kcu.table_name = 'address'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.18419;i:4;a:0:{}}i:53;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.244086;i:4;a:0:{}}i:56;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.245685;i:4;a:0:{}}i:59;a:5:{i:0;s:43:"SELECT * FROM `repair_order` WHERE `id`='0'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246306;i:4;a:0:{}}i:62;a:5:{i:0;s:43:"SELECT * FROM `engineer` WHERE `id`='11786'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246717;i:4;a:0:{}}i:65;a:5:{i:0;s:58:"SELECT * FROM `engineer_profile` WHERE `engineer_id`=11786";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247435;i:4;a:0:{}}i:68;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `engineer_profile`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.24777;i:4;a:0:{}}i:71;a:5:{i:0;s:619:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer_profile' AND kcu.table_name = 'engineer_profile'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.250755;i:4;a:0:{}}i:74;a:5:{i:0;s:278:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and DATE_FORMAT(FROM_UNIXTIME(rod.pay_at), '%Y-%m') = '2019-03' and ro.engineer_id=11786";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.338587;i:4;a:0:{}}i:77;a:5:{i:0;s:214:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and ro.engineer_id=11786";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.339398;i:4;a:0:{}}i:80;a:5:{i:0;s:109:"SELECT COUNT(*) FROM `engineer_skills` WHERE (`engineer_id`=11786) AND (`status`=1) AND (`pass_pratice`=TRUE)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.341088;i:4;a:0:{}}i:83;a:5:{i:0;s:68:"SELECT * FROM `engineer_illegal_counter` WHERE `engineer_id`='11786'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.344262;i:4;a:0:{}}i:86;a:5:{i:0;s:100:"Rendering view file: /Users/scott/projects/jw/src/app-ht/modules/engineer/views/engineer/details.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1556185521.347711;i:4;a:0:{}}i:87;a:5:{i:0;s:1910:"yii\base\ErrorException: Undefined index: is_yanxuan in /Users/scott/projects/jw/src/app-ht/modules/engineer/views/engineer/details.php:187
Stack trace:
#0 /Users/scott/projects/jw/src/app-ht/modules/engineer/views/engineer/details.php(187): yii\base\ErrorHandler->handleError(8, 'Undefined index...', '/Users/scott/pr...', 187, Array)
#1 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/View.php(325): require('/Users/scott/pr...')
#2 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/View.php(247): yii\base\View->renderPhpFile('/Users/scott/pr...', Array)
#3 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/View.php(149): yii\base\View->renderFile('/Users/scott/pr...', Array, Object(app\ht\modules\engineer\controllers\EngineerController))
#4 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/Controller.php(378): yii\base\View->render('details', Array, Object(app\ht\modules\engineer\controllers\EngineerController))
#5 /Users/scott/projects/jw/src/app-ht/modules/engineer/controllers/EngineerController.php(612): yii\base\Controller->render('details', Array)
#6 [internal function]: app\ht\modules\engineer\controllers\EngineerController->actionDetails()
#7 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array(Array, Array)
#8 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\InlineAction->runWithParams(Array)
#9 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('details', Array)
#10 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/web/Application.php(87): yii\base\Module->runAction('engineer/engine...', Array)
#11 /Users/scott/projects/jw/src/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web\Request))
#12 /Users/scott/projects/jw/src/app-ht/web/index.php(18): yii\base\Application->run()
#13 {main}";i:1;i:1;i:2;s:25:"yii\base\ErrorException:8";i:3;d:1556185521.354231;i:4;a:0:{}}}}s:9:"profiling";a:3:{s:6:"memory";i:6731856;s:4:"time";d:0.4125070571899414;s:8:"messages";a:46:{i:18;a:5:{i:0;s:62:"Opening DB connection: mysql:host=127.0.0.1;dbname=jiwork_prod";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1556185521.021322;i:4;a:0:{}}i:19;a:5:{i:0;s:62:"Opening DB connection: mysql:host=127.0.0.1;dbname=jiwork_prod";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1556185521.024916;i:4;a:0:{}}i:20;a:5:{i:0;s:42:"SHOW FULL COLUMNS FROM `jiwork`.`sys_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.024937;i:4;a:0:{}}i:21;a:5:{i:0;s:42:"SHOW FULL COLUMNS FROM `jiwork`.`sys_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.027661;i:4;a:0:{}}i:23;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'sys_user' AND kcu.table_name = 'sys_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.028169;i:4;a:0:{}}i:24;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'sys_user' AND kcu.table_name = 'sys_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.089846;i:4;a:0:{}}i:26;a:5:{i:0;s:46:"SELECT * FROM `jiwork`.`sys_user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.092306;i:4;a:0:{}}i:27;a:5:{i:0;s:46:"SELECT * FROM `jiwork`.`sys_user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.092724;i:4;a:0:{}}i:30;a:5:{i:0;s:684:"SELECT `engineer`.*, IFNULL(engineer_wallet.balance,0) as balance, `engineer_profile`.`headimgurl` AS `headimgurl`, `engineer_profile`.`head_photo` AS `head_photo`, `engineer_profile`.`id_card_no` AS `id_card_no`, `engineer_profile`.`firstname` AS `firstname`, `engineer_profile`.`lastname` AS `lastname`, `engineer_profile`.`nickname` AS `nickname`, `engineer_profile`.`block_reason` AS `blockReason`, `is_bind_device_camera_enable`, `is_bind_device_album_enable`, `choose_album_img_count` FROM `engineer` LEFT JOIN `engineer_profile` ON engineer_profile.engineer_id = engineer.id LEFT JOIN `engineer_wallet` ON engineer_wallet.engineer_id = engineer.id WHERE `engineer`.`id`='11786'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.094698;i:4;a:0:{}}i:31;a:5:{i:0;s:684:"SELECT `engineer`.*, IFNULL(engineer_wallet.balance,0) as balance, `engineer_profile`.`headimgurl` AS `headimgurl`, `engineer_profile`.`head_photo` AS `head_photo`, `engineer_profile`.`id_card_no` AS `id_card_no`, `engineer_profile`.`firstname` AS `firstname`, `engineer_profile`.`lastname` AS `lastname`, `engineer_profile`.`nickname` AS `nickname`, `engineer_profile`.`block_reason` AS `blockReason`, `is_bind_device_camera_enable`, `is_bind_device_album_enable`, `choose_album_img_count` FROM `engineer` LEFT JOIN `engineer_profile` ON engineer_profile.engineer_id = engineer.id LEFT JOIN `engineer_wallet` ON engineer_wallet.engineer_id = engineer.id WHERE `engineer`.`id`='11786'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.104022;i:4;a:0:{}}i:33;a:5:{i:0;s:33:"SHOW FULL COLUMNS FROM `engineer`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.10419;i:4;a:0:{}}i:34;a:5:{i:0;s:33:"SHOW FULL COLUMNS FROM `engineer`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.10955;i:4;a:0:{}}i:36;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer' AND kcu.table_name = 'engineer'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.110055;i:4;a:0:{}}i:37;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer' AND kcu.table_name = 'engineer'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.16846;i:4;a:0:{}}i:39;a:5:{i:0;s:325:"SELECT COUNT(*) FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.172419;i:4;a:0:{}}i:40;a:5:{i:0;s:325:"SELECT COUNT(*) FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.175467;i:4;a:0:{}}i:42;a:5:{i:0;s:405:"SELECT `repair_order`.*, `user`.`name` AS `customer`, `address`.`address` AS `address` FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786') LIMIT 20";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.175674;i:4;a:0:{}}i:43;a:5:{i:0;s:405:"SELECT `repair_order`.*, `user`.`name` AS `customer`, `address`.`address` AS `address` FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786') LIMIT 20";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.176473;i:4;a:0:{}}i:45;a:5:{i:0;s:115:"SELECT sum(amount) as t_amount, `status` FROM `engineer_order_income` WHERE `engineer_id`='11786' GROUP BY `status`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.177144;i:4;a:0:{}}i:46;a:5:{i:0;s:115:"SELECT sum(amount) as t_amount, `status` FROM `engineer_order_income` WHERE `engineer_id`='11786' GROUP BY `status`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.180442;i:4;a:0:{}}i:48;a:5:{i:0;s:32:"SHOW FULL COLUMNS FROM `address`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.181294;i:4;a:0:{}}i:49;a:5:{i:0;s:32:"SHOW FULL COLUMNS FROM `address`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.183992;i:4;a:0:{}}i:51;a:5:{i:0;s:601:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'address' AND kcu.table_name = 'address'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.184201;i:4;a:0:{}}i:52;a:5:{i:0;s:601:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'address' AND kcu.table_name = 'address'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.243976;i:4;a:0:{}}i:54;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.244097;i:4;a:0:{}}i:55;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.244399;i:4;a:0:{}}i:57;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.245695;i:4;a:0:{}}i:58;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.24596;i:4;a:0:{}}i:60;a:5:{i:0;s:43:"SELECT * FROM `repair_order` WHERE `id`='0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246314;i:4;a:0:{}}i:61;a:5:{i:0;s:43:"SELECT * FROM `repair_order` WHERE `id`='0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246636;i:4;a:0:{}}i:63;a:5:{i:0;s:43:"SELECT * FROM `engineer` WHERE `id`='11786'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246725;i:4;a:0:{}}i:64;a:5:{i:0;s:43:"SELECT * FROM `engineer` WHERE `id`='11786'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247039;i:4;a:0:{}}i:66;a:5:{i:0;s:58:"SELECT * FROM `engineer_profile` WHERE `engineer_id`=11786";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247444;i:4;a:0:{}}i:67;a:5:{i:0;s:58:"SELECT * FROM `engineer_profile` WHERE `engineer_id`=11786";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247717;i:4;a:0:{}}i:69;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `engineer_profile`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247776;i:4;a:0:{}}i:70;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `engineer_profile`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.250555;i:4;a:0:{}}i:72;a:5:{i:0;s:619:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer_profile' AND kcu.table_name = 'engineer_profile'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.250762;i:4;a:0:{}}i:73;a:5:{i:0;s:619:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer_profile' AND kcu.table_name = 'engineer_profile'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.336961;i:4;a:0:{}}i:75;a:5:{i:0;s:278:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and DATE_FORMAT(FROM_UNIXTIME(rod.pay_at), '%Y-%m') = '2019-03' and ro.engineer_id=11786";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.338596;i:4;a:0:{}}i:76;a:5:{i:0;s:278:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and DATE_FORMAT(FROM_UNIXTIME(rod.pay_at), '%Y-%m') = '2019-03' and ro.engineer_id=11786";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.339196;i:4;a:0:{}}i:78;a:5:{i:0;s:214:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and ro.engineer_id=11786";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.339422;i:4;a:0:{}}i:79;a:5:{i:0;s:214:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and ro.engineer_id=11786";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.340264;i:4;a:0:{}}i:81;a:5:{i:0;s:109:"SELECT COUNT(*) FROM `engineer_skills` WHERE (`engineer_id`=11786) AND (`status`=1) AND (`pass_pratice`=TRUE)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.341222;i:4;a:0:{}}i:82;a:5:{i:0;s:109:"SELECT COUNT(*) FROM `engineer_skills` WHERE (`engineer_id`=11786) AND (`status`=1) AND (`pass_pratice`=TRUE)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.342441;i:4;a:0:{}}i:84;a:5:{i:0;s:68:"SELECT * FROM `engineer_illegal_counter` WHERE `engineer_id`='11786'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.344278;i:4;a:0:{}}i:85;a:5:{i:0;s:68:"SELECT * FROM `engineer_illegal_counter` WHERE `engineer_id`='11786'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.345206;i:4;a:0:{}}}}s:2:"db";a:1:{s:8:"messages";a:44:{i:20;a:5:{i:0;s:42:"SHOW FULL COLUMNS FROM `jiwork`.`sys_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.024937;i:4;a:0:{}}i:21;a:5:{i:0;s:42:"SHOW FULL COLUMNS FROM `jiwork`.`sys_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.027661;i:4;a:0:{}}i:23;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'sys_user' AND kcu.table_name = 'sys_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.028169;i:4;a:0:{}}i:24;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'sys_user' AND kcu.table_name = 'sys_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.089846;i:4;a:0:{}}i:26;a:5:{i:0;s:46:"SELECT * FROM `jiwork`.`sys_user` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.092306;i:4;a:0:{}}i:27;a:5:{i:0;s:46:"SELECT * FROM `jiwork`.`sys_user` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.092724;i:4;a:0:{}}i:30;a:5:{i:0;s:684:"SELECT `engineer`.*, IFNULL(engineer_wallet.balance,0) as balance, `engineer_profile`.`headimgurl` AS `headimgurl`, `engineer_profile`.`head_photo` AS `head_photo`, `engineer_profile`.`id_card_no` AS `id_card_no`, `engineer_profile`.`firstname` AS `firstname`, `engineer_profile`.`lastname` AS `lastname`, `engineer_profile`.`nickname` AS `nickname`, `engineer_profile`.`block_reason` AS `blockReason`, `is_bind_device_camera_enable`, `is_bind_device_album_enable`, `choose_album_img_count` FROM `engineer` LEFT JOIN `engineer_profile` ON engineer_profile.engineer_id = engineer.id LEFT JOIN `engineer_wallet` ON engineer_wallet.engineer_id = engineer.id WHERE `engineer`.`id`='11786'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.094698;i:4;a:0:{}}i:31;a:5:{i:0;s:684:"SELECT `engineer`.*, IFNULL(engineer_wallet.balance,0) as balance, `engineer_profile`.`headimgurl` AS `headimgurl`, `engineer_profile`.`head_photo` AS `head_photo`, `engineer_profile`.`id_card_no` AS `id_card_no`, `engineer_profile`.`firstname` AS `firstname`, `engineer_profile`.`lastname` AS `lastname`, `engineer_profile`.`nickname` AS `nickname`, `engineer_profile`.`block_reason` AS `blockReason`, `is_bind_device_camera_enable`, `is_bind_device_album_enable`, `choose_album_img_count` FROM `engineer` LEFT JOIN `engineer_profile` ON engineer_profile.engineer_id = engineer.id LEFT JOIN `engineer_wallet` ON engineer_wallet.engineer_id = engineer.id WHERE `engineer`.`id`='11786'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.104022;i:4;a:0:{}}i:33;a:5:{i:0;s:33:"SHOW FULL COLUMNS FROM `engineer`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.10419;i:4;a:0:{}}i:34;a:5:{i:0;s:33:"SHOW FULL COLUMNS FROM `engineer`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.10955;i:4;a:0:{}}i:36;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer' AND kcu.table_name = 'engineer'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.110055;i:4;a:0:{}}i:37;a:5:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer' AND kcu.table_name = 'engineer'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.16846;i:4;a:0:{}}i:39;a:5:{i:0;s:325:"SELECT COUNT(*) FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.172419;i:4;a:0:{}}i:40;a:5:{i:0;s:325:"SELECT COUNT(*) FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.175467;i:4;a:0:{}}i:42;a:5:{i:0;s:405:"SELECT `repair_order`.*, `user`.`name` AS `customer`, `address`.`address` AS `address` FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786') LIMIT 20";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.175674;i:4;a:0:{}}i:43;a:5:{i:0;s:405:"SELECT `repair_order`.*, `user`.`name` AS `customer`, `address`.`address` AS `address` FROM `repair_order` LEFT JOIN `user` ON user.id = repair_order.user_id LEFT JOIN `address` ON address.id = repair_order.address_id WHERE (`repair_order`.`status` IN (1, 4, 3, 2)) AND (`repair_order`.`is_admin_close` = 0) AND (`repair_order`.`is_system_delete` = 0) AND (`repair_order`.`engineer_id` = '11786') LIMIT 20";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.176473;i:4;a:0:{}}i:45;a:5:{i:0;s:115:"SELECT sum(amount) as t_amount, `status` FROM `engineer_order_income` WHERE `engineer_id`='11786' GROUP BY `status`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.177144;i:4;a:0:{}}i:46;a:5:{i:0;s:115:"SELECT sum(amount) as t_amount, `status` FROM `engineer_order_income` WHERE `engineer_id`='11786' GROUP BY `status`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.180442;i:4;a:0:{}}i:48;a:5:{i:0;s:32:"SHOW FULL COLUMNS FROM `address`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.181294;i:4;a:0:{}}i:49;a:5:{i:0;s:32:"SHOW FULL COLUMNS FROM `address`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.183992;i:4;a:0:{}}i:51;a:5:{i:0;s:601:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'address' AND kcu.table_name = 'address'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.184201;i:4;a:0:{}}i:52;a:5:{i:0;s:601:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'address' AND kcu.table_name = 'address'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.243976;i:4;a:0:{}}i:54;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.244097;i:4;a:0:{}}i:55;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.244399;i:4;a:0:{}}i:57;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.245695;i:4;a:0:{}}i:58;a:5:{i:0;s:38:"SELECT * FROM `address` WHERE `id`='0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.24596;i:4;a:0:{}}i:60;a:5:{i:0;s:43:"SELECT * FROM `repair_order` WHERE `id`='0'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246314;i:4;a:0:{}}i:61;a:5:{i:0;s:43:"SELECT * FROM `repair_order` WHERE `id`='0'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246636;i:4;a:0:{}}i:63;a:5:{i:0;s:43:"SELECT * FROM `engineer` WHERE `id`='11786'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.246725;i:4;a:0:{}}i:64;a:5:{i:0;s:43:"SELECT * FROM `engineer` WHERE `id`='11786'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247039;i:4;a:0:{}}i:66;a:5:{i:0;s:58:"SELECT * FROM `engineer_profile` WHERE `engineer_id`=11786";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247444;i:4;a:0:{}}i:67;a:5:{i:0;s:58:"SELECT * FROM `engineer_profile` WHERE `engineer_id`=11786";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247717;i:4;a:0:{}}i:69;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `engineer_profile`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.247776;i:4;a:0:{}}i:70;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `engineer_profile`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.250555;i:4;a:0:{}}i:72;a:5:{i:0;s:619:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer_profile' AND kcu.table_name = 'engineer_profile'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.250762;i:4;a:0:{}}i:73;a:5:{i:0;s:619:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'engineer_profile' AND kcu.table_name = 'engineer_profile'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.336961;i:4;a:0:{}}i:75;a:5:{i:0;s:278:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and DATE_FORMAT(FROM_UNIXTIME(rod.pay_at), '%Y-%m') = '2019-03' and ro.engineer_id=11786";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.338596;i:4;a:0:{}}i:76;a:5:{i:0;s:278:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and DATE_FORMAT(FROM_UNIXTIME(rod.pay_at), '%Y-%m') = '2019-03' and ro.engineer_id=11786";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.339196;i:4;a:0:{}}i:78;a:5:{i:0;s:214:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and ro.engineer_id=11786";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.339422;i:4;a:0:{}}i:79;a:5:{i:0;s:214:"SELECT COUNT(*) FROM `repair_order` `ro` LEFT JOIN `repair_order_detail` `rod` ON rod.repair_order_id = ro.id WHERE is_system_delete=0 and is_suspend in (0,3) and status in(6, 10, 103, 104) and ro.engineer_id=11786";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.340264;i:4;a:0:{}}i:81;a:5:{i:0;s:109:"SELECT COUNT(*) FROM `engineer_skills` WHERE (`engineer_id`=11786) AND (`status`=1) AND (`pass_pratice`=TRUE)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.341222;i:4;a:0:{}}i:82;a:5:{i:0;s:109:"SELECT COUNT(*) FROM `engineer_skills` WHERE (`engineer_id`=11786) AND (`status`=1) AND (`pass_pratice`=TRUE)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.342441;i:4;a:0:{}}i:84;a:5:{i:0;s:68:"SELECT * FROM `engineer_illegal_counter` WHERE `engineer_id`='11786'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.344278;i:4;a:0:{}}i:85;a:5:{i:0;s:68:"SELECT * FROM `engineer_illegal_counter` WHERE `engineer_id`='11786'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1556185521.345206;i:4;a:0:{}}}}s:6:"assets";a:2:{s:66:"http://jiworkadmin:8012/exts/base/1.0.0/ui/switch/switch-1.0.0.css";a:9:{s:10:"sourcePath";N;s:8:"basePath";N;s:7:"baseUrl";s:0:"";s:7:"depends";a:1:{i:0;s:22:"app\ht\assets\AppAsset";}s:2:"js";a:0:{}s:3:"css";a:1:{i:0;s:66:"http://jiworkadmin:8012/exts/base/1.0.0/ui/switch/switch-1.0.0.css";}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:1:{s:8:"position";i:1;}s:14:"publishOptions";a:0:{}}s:22:"app\ht\assets\AppAsset";a:9:{s:3:"css";a:4:{i:0;s:46:"exts/base/1.0.0/unit/ui-base/ui-base-1.0.0.css";i:1;s:52:"exts/base/1.0.0/unit/ui-base/ui-base-theme-1.0.0.css";i:2;s:54:"exts/base/1.0.0/unit/global-init/global-init-1.0.0.css";i:3;s:37:"exts/base/1.0.0/app/css/frame_app.css";}s:2:"js";a:5:{i:0;s:21:"exts/base/libs/sea.js";i:1;s:35:"exts/base/libs/jquery-1.12.1.min.js";i:2;s:45:"exts/base/1.0.0/unit/ui-base/ui-base-1.0.0.js";i:3;s:35:"exts/base/1.0.0/app/js/frame_app.js";i:4;s:48:"exts-src/base/1.0.0/unit/ui-base/custom-1.0.0.js";}s:9:"jsOptions";a:1:{s:8:"position";i:1;}s:10:"sourcePath";N;s:8:"basePath";N;s:7:"baseUrl";s:23:"http://jiworkadmin:8012";s:7:"depends";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}s:4:"mail";a:0:{}s:7:"summary";a:9:{s:3:"tag";s:13:"5cc181b0f1100";s:3:"url";s:68:"http://jiworkadmin:8012/engineer/engineer/details?id=11786&egstatus=";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:9:"127.0.0.1";s:4:"time";i:1556185521;s:10:"statusCode";i:500;s:8:"sqlCount";i:22;s:9:"mailCount";i:0;}}