68c7c2d667175: POST https://beta.jinchangxiao.com/vue/analysis/sales-get-filter at 2025-09-15 03:40:06 pm by 114.246.237.213
Log Messages
总计49条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:40:06.421 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:40:06.421 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:40:06.422 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:40:06.422 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:40:06.422 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:40:06.422 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.422 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:40:06.422 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:40:06.422 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:40:06.422 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/sales-get-filter' |
| 15:40:06.422 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:40:06.423 | info | yii\web\Session::open | Session started |
| 15:40:06.424 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:40:06.424 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:40:06.428 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.428 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.428 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.429 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.429 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:40:06.430 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/sales-get-filter |
| 15:40:06.431 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.432 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:40:06.432 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionSalesGetFilter() |
| 15:40:06.432 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.432 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.433 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.433 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.433 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 15:40:06.434 | info | yii\db\Command::query | SELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects" |
| 15:40:06.436 | 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"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2024-01-01 00:00:00, 2024-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 |
| 15:40:06.437 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.437 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.438 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2024-01-01 00:00:00') AND ("bargain_date" <= '2024-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5364, 5295, 1013, 1025, 1004, 5359, 5409, 5412, 1005, 5358)) GROUP BY "created_by" |
| 15:40:06.438 | 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"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2024-01-01 00:00:00, 2024-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 |
| 15:40:06.439 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2024-01-01 00:00:00') AND ("bargain_date" <= '2024-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5364, 5295, 1013, 1025, 1004, 5359, 5409, 5412, 1005, 5358)) GROUP BY "created_by" |
| 15:40:06.441 | info | yii\db\Command::query | SELECT g.id, g.name, string_agg( sgr.sales_id::varchar, ',') AS list FROM "a57be577deb434"."tbl_groups" "g" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE "sgr"."sales_id" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5364, 5295, 1013, 1025, 1004, 5359, 5409, 5412, 1005, 5358) GROUP BY "g"."id" ORDER BY "sort" |
| 15:40:06.442 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.442 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.442 | 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"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2024-01-01 00:00:00, 2024-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 |
| 15:40:06.443 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2024-01-01 00:00:00') AND ("bargain_date" <= '2024-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5364, 5295, 1013, 1025, 1004, 5359, 5409, 5412, 1005, 5358)) GROUP BY "created_by" |
| 15:40:06.443 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.444 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.444 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-09-15') |
| 15:40:06.448 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.448 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:40:06.448 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=14, "last_visit_at"='now()' WHERE "id"=56570 |
| 15:40:06.449 | 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/analysis/sales-get-filter', '{"period":"fascal2024","to":"","from":"","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"filter":{"period":{"key":"period","name":"\u65f6\u95f4","value":[{"key":"fascal2025","name":"2025\u8d22\u5e74"},{"key":"fascal2024","name":"2024\u8d22\u5e74"},{"key":"fascal2023","name":"2023\u8d22\u5e74"},{"key":"fascal2022","name":"2022\u8d22\u5e74"},{"key":"fascal2021","name":"2021\u8d22\u5e74"},{"key":"fascal2020","name":"2020\u8d22\u5e74"},{"key":"fascal2019","name":"2019\u8d22\u5e74"},{"key":"fascal2018","name":"2018\u8d22\u5e74"},{"key":"fascal2017","name":"2017\u8d22\u5e74"}],"default":""},"dataUserId":{"key":"dataUserId","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"id":0,"key":"1001,1004,1005,1013,1025,5087,5295,5300,5311,5329,5332,5358,5359,5364,5409,5412,5420","name":"\u5168\u90e8","child":[]},{"id":80,"key":"1004,1005,1013,5087","name":"\u5408\u4f19\u4eba","child":[{"key":5087,"name":"\u5218\u5fae"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u6657\u7131"}]},{"id":1,"key":"1001,5295,5300,5311","name":"\u5218\u4eba\u8bda\u7ec4","child":[{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"}]},{"id":81,"key":"5332","name":"\u4f0a\u5cfb\u8fb0\u7ec4","child":[{"key":5332,"name":"\u970d\u536b\u8d85"}]},{"id":999999,"key":"5329,5358,5359,5364,5409,5412,5420","name":"\u79bb\u804c\u4eba\u5458","child":[{"key":5329,"name":"\u9ad8\u5ce5"},{"key":5420,"name":"\u674e\u6ea6"},{"key":5364,"name":"\u738b\u827a\u742e"},{"key":5359,"name":"\u5f20\u6d69\u7136"},{"key":5409,"name":"\u5f20\u78ca"},{"key":5412,"name":"\u5f20\u78ca"},{"key":5358,"name":"\u5468\u4e9a\u536b"}]}],"default":1001,"itemKey":"dataUserId","groupKey":"group"}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 15:40:06') RETURNING "id" |
| 15:40:06.450 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:40:06.450 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |