| 17:44:40.748 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:44:40.748 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:44:40.748 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:44:40.748 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:44:40.748 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:44:40.749 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.749 | info | time tracing start | 1780047880749352960 |
| 17:44:40.749 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:44:40.749 | trace | yii\web\Application::handleRequest | Route requested: 'vue/dashboard/get-notice' |
| 17:44:40.749 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:44:40.750 | info | yii\web\Session::open | Session started |
| 17:44:40.750 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5495 |
| 17:44:40.750 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:44:40.751 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.752 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:44:40.752 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.752 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:44:40.753 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495 |
| 17:44:40.753 | trace | yii\base\Controller::runAction | Route to run: vue/dashboard/get-notice |
| 17:44:40.753 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\DashboardController::actionGetNotice() |
| 17:44:40.754 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.755 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewSchedule |
| 17:44:40.755 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:44:40.755 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 17:44:40.755 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 17:44:40.755 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_schedules" WHERE ("is_complete"=FALSE) AND ("created_by"=5495) |
| 17:44:40.756 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewTask |
| 17:44:40.756 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:44:40.756 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 17:44:40.756 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 17:44:40.756 | info | yii\db\Command::query | SELECT count(id) FROM "o6a13e2c574d5a"."tbl_tasks" WHERE ("status"=0) AND ("head_of"=5495) |
| 17:44:40.758 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewReimbursement |
| 17:44:40.758 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:44:40.758 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 17:44:40.758 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 17:44:40.758 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_reimbursements" WHERE ("next_verify_user"=5495) AND ("status" != 0) |
| 17:44:40.761 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewApprove |
| 17:44:40.761 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:44:40.761 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 17:44:40.761 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 17:44:40.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.763 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:44:40.764 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.765 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.765 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "o6a13e2c574d5a"."tbl_visible_approves" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5495) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 17:44:40.768 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT
r.*,
CASE WHEN rvr.status = 0 And next_verify_user = 5495 THEN 1
WHEN rcvr.status = 0 And next_cancel_verify_user = 5495 THEN 2
ELSE 0
END as approvesort FROM "o6a13e2c574d5a"."tbl_approves" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "o6a13e2c574d5a"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE ("rvr"."user_id"=5495) AND ("r"."status" != 0) AND ("r"."status" IN (1, 5)) AND ((("r"."next_verify_user"=5495) AND ("rvr"."status"=0)) OR (("r"."next_cancel_verify_user"=5495) AND ("rcvr"."status"=0))) GROUP BY "r"."id", "approvesort") "sub" |
| 17:44:40.772 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewPunchApprove |
| 17:44:40.772 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:44:40.772 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 17:44:40.772 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 17:44:40.772 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_punch_repairs" WHERE ("next_verify_user"=5495) OR ("next_cancel_verify_user"=5495) |
| 17:44:40.774 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_punch_aways" WHERE ("next_verify_user"=5495) OR ("next_cancel_verify_user"=5495) |
| 17:44:40.777 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_punch_overtimes" WHERE ("next_verify_user"=5495) OR ("next_cancel_verify_user"=5495) |
| 17:44:40.778 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_punch_leaves" WHERE ("next_verify_user"=5495) OR ("next_cancel_verify_user"=5495) |
| 17:44:40.781 | info | yii\db\Command::query | SELECT COUNT(*) FROM "o6a13e2c574d5a"."tbl_punch_travels" WHERE ("next_verify_user"=5495) OR ("next_cancel_verify_user"=5495) |
| 17:44:40.782 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewErp |
| 17:44:40.782 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:44:40.782 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Treasurer |
| 17:44:40.782 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: FinancialAudit |
| 17:44:40.782 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
| 17:44:40.784 | info | yii\db\Command::query | SELECT count(tmp.id) FROM (SELECT "c"."id" FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN "o6a13e2c574d5a"."tbl_case_assignments" "ca" ON ca.case_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "cl" ON c.client_id = cl.id WHERE ("c"."case_status" IN (1, 2, 3)) AND (("ca"."engineer_id"=5495) AND ("ca"."assignment_status" IN (1, 2))) GROUP BY "c"."id") "tmp" |
| 17:44:40.790 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.790 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:44:40.790 | 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, 'o6a13e2c574d5a', 5495, 5, 'vue/dashboard/get-notice', '{"web_access_token":"LtdoQWPnIHveoR2dE9dLuCNO9f4Azx_q"}', '{"code":2000,"result":[{"name":"\u5f85\u529e\u4e8b\u9879","name_display":"","id":"","key":"schedule","num":0,"bedge":0,"badge":0,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u9879\u76ee\u4efb\u52a1","name_display":"","id":"","key":"task","num":0,"bedge":0,"badge":0,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u62a5\u9500\u5ba1\u6279","name_display":"","id":"","key":"reimbursement","num":0,"bedge":0,"badge":0,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u5ba1\u6279\u7ba1\u7406","name_display":"","id":"","key":"approve","num":0,"bedge":0,"badge":0,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u8003\u52e4\u5ba1\u6279","name_display":"","id":"","key":"punch-approve","num":0,"bedge":0,"badge":0,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"Case","name_display":"","id":"","key":"case-to-done","num":0,"bedge":0,"badge":0,"item":"\u4e2a","content":"\u5f85\u5904\u7406"}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-05-29 17:44:40', 41201920) RETURNING "id" |
| 17:44:40.792 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:44:40.792 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |