6a1ea12e30733: POST https://beta.jinchangxiao.com/vue/analysis/sales-get-filter at 2026-06-02 05:23:58 pm by 221.216.117.119
Log Messages
总计44条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 17:23:58.195 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:23:58.195 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:23:58.195 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:23:58.198 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:23:58.198 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:23:58.201 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.204 | info | time tracing start | 1780392238204414976 |
| 17:23:58.204 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:23:58.204 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/sales-get-filter' |
| 17:23:58.204 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:23:58.205 | info | yii\web\Session::open | Session started |
| 17:23:58.206 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:23:58.206 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:23:58.219 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.222 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:23:58.224 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.227 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:23:58.230 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:23:58.235 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/sales-get-filter |
| 17:23:58.236 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.243 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:23:58.243 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionSalesGetFilter() |
| 17:23:58.243 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.246 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.251 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.253 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:23:58.256 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 17:23:58.259 | info | yii\db\Command::query | SELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects" |
| 17:23:58.261 | 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, '[)') && '[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 |
| 17:23:58.262 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.262 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:23:58.262 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by" |
| 17:23:58.263 | 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, '[)') && '[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 |
| 17:23:58.264 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by" |
| 17:23:58.267 | 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 (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "g"."id" ORDER BY "sort" |
| 17:23:58.268 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.268 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:23:58.268 | 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, '[)') && '[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 |
| 17:23:58.271 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by" |
| 17:23:58.278 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.280 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:23:58.283 | 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/analysis/sales-get-filter', '{"period":"currentfascalyear","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"filter":{"period":{"key":"period","name":"\u65f6\u95f4","value":[{"key":"fascal2026","name":"2026\u8d22\u5e74"},{"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,5087,5295,5300,5311,5332,5449,5467,5476","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\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}]},{"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":82,"key":"5449","name":"\u8d75\u6657\u7131\u7ec4","child":[{"key":5449,"name":"\u5468\u4e3d\u98de"}]},{"id":83,"key":"5476","name":"\u91d1\u7545\u900d","child":[{"key":5476,"name":"\u6768\u5dcd"}]},{"id":999999,"key":"5467","name":"\u79bb\u804c\u4eba\u5458","child":[{"key":5467,"name":"\u9a6c\u6668\u5e0c"}]}],"default":1001,"itemKey":"dataUserId","groupKey":"group"}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 17:23:58', 79166976) RETURNING "id" |
| 17:23:58.294 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:23:58.294 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |