6877459594c72: POST https://beta.jinchangxiao.com/vue/dashboard/engineer-score at 2025-07-16 02:24:21 pm by 124.127.56.185
Log Messages
总计28条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:24:21.608 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:24:21.608 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:24:21.609 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:24:21.609 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:24:21.609 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:24:21.609 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:24:21.610 | trace | yii\base\Module::getModule | Loading module: gii |
| 14:24:21.610 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 14:24:21.610 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:24:21.610 | trace | yii\web\Application::handleRequest | Route requested: 'vue/dashboard/engineer-score' |
| 14:24:21.610 | trace | yii\base\Module::getModule | Loading module: vue |
| 14:24:21.610 | info | yii\web\Session::open | Session started |
| 14:24:21.611 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:24:21.611 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:24:21.618 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:24:21.618 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:24:21.618 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:24:21.619 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:24:21.619 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:24:21.622 | trace | yii\base\Controller::runAction | Route to run: vue/dashboard/engineer-score |
| 14:24:21.622 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\DashboardController::actionEngineerScore() |
| 14:24:21.622 | info | yii\db\Command::query | SELECT u.id, name, esb.*, e_implement_count, e_budget_count, e_profit_count, e_client_count, e_project_count, e_point_count, (CASE WHEN esb.e_implement_base > 0 THEN floor(u.e_implement_count * 20 / esb.e_implement_base) ELSE 0 END) as e_implement_score, (CASE WHEN esb.e_budget_base > 0 THEN floor(u.e_budget_count * 20 / esb.e_budget_base) ELSE 0 END) as e_budget_score, (CASE WHEN esb.e_profit_base > 0 THEN floor(u.e_profit_count * 15 / esb.e_profit_base) ELSE 0 END) as e_profit_score, (CASE WHEN esb.e_client_base > 0 THEN floor(u.e_client_count * 15 / esb.e_client_base) ELSE 0 END) as e_client_score, (CASE WHEN esb.e_project_base > 0 THEN floor(u.e_project_count * 15 / esb.e_project_base) ELSE 0 END) as e_project_score, (CASE WHEN esb.e_point_base > 0 THEN floor(u.e_point_count * 15 / esb.e_point_base) ELSE 0 END) as e_point_score, ( (CASE WHEN esb.e_implement_base > 0 THEN floor(u.e_implement_count * 20 / esb.e_implement_base) ELSE 0 END) + (CASE WHEN esb.e_budget_base > 0 THEN floor(u.e_budget_count * 20 / esb.e_budget_base) ELSE 0 END) + (CASE WHEN esb.e_profit_base > 0 THEN floor(u.e_profit_count * 15 / esb.e_profit_base) ELSE 0 END) + (CASE WHEN esb.e_client_base > 0 THEN floor(u.e_client_count * 15 / esb.e_client_base) ELSE 0 END) + (CASE WHEN esb.e_project_base > 0 THEN floor(u.e_project_count * 15 / esb.e_project_base) ELSE 0 END) + (CASE WHEN esb.e_point_base > 0 THEN floor(u.e_point_count * 15 / esb.e_point_base) ELSE 0 END) ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_engineer_score_bases" "esb" ON 1 = 1 WHERE ("u"."user_status"=1) AND ("u"."id"=1001) AND ("aa"."item_name"='Engineer') GROUP BY "u"."id", "esb"."id" |
| 14:24:21.626 | info | yii\db\Command::query | SELECT avg( (CASE WHEN esb.e_implement_base > 0 THEN floor(u.e_implement_count * 20 / esb.e_implement_base) ELSE 0 END) + (CASE WHEN esb.e_budget_base > 0 THEN floor(u.e_budget_count * 20 / esb.e_budget_base) ELSE 0 END) + (CASE WHEN esb.e_profit_base > 0 THEN floor(u.e_profit_count * 15 / esb.e_profit_base) ELSE 0 END) + (CASE WHEN esb.e_client_base > 0 THEN floor(u.e_client_count * 15 / esb.e_client_base) ELSE 0 END) + (CASE WHEN esb.e_project_base > 0 THEN floor(u.e_project_count * 15 / esb.e_project_base) ELSE 0 END) + (CASE WHEN esb.e_point_base > 0 THEN floor(u.e_point_count * 15 / esb.e_point_base) ELSE 0 END) ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_engineer_score_bases" "esb" ON 1 = 1 WHERE ("u"."user_status"=1) AND ("aa"."item_name"='Engineer') |
| 14:24:21.630 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:24:21.631 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:24:21.632 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/dashboard/engineer-score', '{"web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"name":"\u5218\u4eba\u8bda","score":0,"avg_score":38,"items":[{"key":"e_implement_info","title":"\u672c\u8d22\u5e74\u5b9e\u65bd\u6b21\u6570","base_score":"20","score":0,"pct":0,"count":0,"base":"51","display":"\u672a\u8fbe\u6807"},{"key":"e_budget_info","title":"\u672c\u8d22\u5e74\u52a9\u653b\u6d41\u6c34","base_score":"20","score":0,"pct":0,"count":0,"base":"132738.2","display":"\u672a\u8fbe\u6807"},{"key":"e_profit_info","title":"\u672c\u8d22\u5e74\u52a9\u653b\u5229\u6da6","base_score":"15","score":0,"pct":0,"count":0,"base":"24631.6174200000000000","display":"\u672a\u8fbe\u6807"},{"key":"e_client_info","title":"\u672c\u8d22\u5e74\u670d\u52a1\u5ba2\u6237\u6570","base_score":"15","score":0,"pct":0,"count":0,"base":"17","display":"\u672a\u8fbe\u6807"},{"key":"e_project_info","title":"\u672c\u8d22\u5e74\u670d\u52a1\u5546\u673a\u6570","base_score":"15","score":0,"pct":0,"count":0,"base":"22","display":"\u672a\u8fbe\u6807"},{"key":"e_point_info","title":"\u672c\u8d22\u5e74\u5de5\u5206","base_score":"15","score":0,"pct":0,"count":0,"base":"2239","display":"\u672a\u8fbe\u6807"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-16 14:24:21') RETURNING "id" |
| 14:24:21.634 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:24:21.635 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |