6a2f60bb2de9a: POST https://beta.jinchangxiao.com/vue/smart-board/engineer at 2026-06-15 10:17:31 am by 124.127.56.185
Log Messages
总计39条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 10:17:31.187 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 10:17:31.187 | trace | yii\base\Module::getModule | Loading module: debug |
| 10:17:31.187 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 10:17:31.188 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 10:17:31.188 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 10:17:31.188 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.189 | info | time tracing start | 1781489851189282048 |
| 10:17:31.189 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 10:17:31.189 | trace | yii\web\Application::handleRequest | Route requested: 'vue/smart-board/engineer' |
| 10:17:31.189 | trace | yii\base\Module::getModule | Loading module: vue |
| 10:17:31.190 | info | yii\web\Session::open | Session started |
| 10:17:31.191 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:17:31.191 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 10:17:31.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:17:31.194 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:17:31.195 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.196 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:17:31.196 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:17:31.197 | trace | yii\base\Controller::runAction | Route to run: vue/smart-board/engineer |
| 10:17:31.197 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.199 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 10:17:31.199 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SmartBoardController::actionEngineer() |
| 10:17:31.199 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.200 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.203 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 10:17:31.204 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.204 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:17:31.204 | info | yii\db\Command::query | SELECT COUNT(id) AS times, COALESCE(EXTRACT(epoch FROM SUM(end_at - start_at)) / 3600, 0) AS hours FROM "a57be577deb434"."tbl_pre_sales" WHERE ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) AND ("start_at" >= '2026-01-01 00:00:00') AND ("start_at" <= '2026-12-31 23:59:59') AND ("is_draft"=FALSE) |
| 10:17:31.206 | info | yii\db\Command::query | SELECT COALESCE(SUM(ca.points), 0) AS points FROM "a57be577deb434"."tbl_case_assignments" "ca" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ca.case_id = c.id WHERE ("c"."case_type"=1) AND ("c"."closed_at" >= '2026-01-01 00:00:00') AND ("c"."closed_at" <= '2026-12-31 23:59:59') AND ("ca"."engineer_id" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.212 | info | yii\db\Command::query | SELECT COUNT(id) AS times, COALESCE(EXTRACT(epoch FROM SUM(left_at - arrived_at)) / 3600, 0) AS hours FROM "a57be577deb434"."tbl_implement_records" WHERE ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) AND ("arrived_at" >= '2026-01-01 00:00:00') AND ("arrived_at" <= '2026-12-31 23:59:59') AND ("is_draft"=FALSE) |
| 10:17:31.216 | info | yii\db\Command::query | SELECT COALESCE(SUM(ca.points), 0) AS points FROM "a57be577deb434"."tbl_case_assignments" "ca" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ca.case_id = c.id WHERE ("c"."case_type"=2) AND ("c"."closed_at" >= '2026-01-01 00:00:00') AND ("c"."closed_at" <= '2026-12-31 23:59:59') AND ("ca"."engineer_id" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.220 | info | yii\db\Command::query | SELECT COALESCE(SUM(amount), 0) AS total_expense FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("occurrence_at" >= '2026-01-01') AND ("occurrence_at" <= '2026-12-31 23:59:59') AND ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.222 | info | yii\db\Command::query | SELECT COALESCE(SUM(amount), 0) AS total_expense FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("occurrence_at" >= '2025-01-01') AND ("occurrence_at" <= '2025-12-31 23:59:59') AND ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.224 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.224 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:17:31.225 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/smart-board/engineer', '{"period":"currentfascalyear","engineer":"","web_access_token":"JU9Qn0Er55lxUI9CLMF3SA6k67eZ2hvL"}', '{"code":2000,"result":{"pre_sales_points":1700,"pre_sales_times":26,"pre_sales_hours":55.2,"implement_points":7475,"implement_times":126,"implement_hours":397.3,"total_expense":"908113.04","total_expense_last_year":"107218.29","total_expense_growth":7.4697,"engineer_count":6},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"124.127.56.185","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36 Edg\/149.0.0.0"}', FALSE, '2026-06-15 10:17:31', 35830784) RETURNING "id" |
| 10:17:31.227 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:17:31.227 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |