68c2736b4e074: POST https://beta.jinchangxiao.com/vue/analysis/view-client-histogram at 2025-09-11 02:59:55 pm by 114.246.239.150
Log Messages
总计43条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:59:55.319 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:59:55.319 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:59:55.319 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:59:55.319 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:59:55.319 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:59:55.319 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.320 | trace | yii\base\Module::getModule | Loading module: gii |
| 14:59:55.320 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 14:59:55.320 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:59:55.320 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/view-client-histogram' |
| 14:59:55.320 | trace | yii\base\Module::getModule | Loading module: vue |
| 14:59:55.321 | info | yii\web\Session::open | Session started |
| 14:59:55.321 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:59:55.321 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:59:55.325 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.325 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:59:55.326 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.326 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:59:55.326 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:59:55.328 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/view-client-histogram |
| 14:59:55.328 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.329 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:59:55.329 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionViewClientHistogram() |
| 14:59:55.329 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE ("c"."id"='3296') AND ("deleted"=FALSE) |
| 14:59:55.330 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.331 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:59:55.331 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.331 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:59:55.331 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 14:59:55.332 | info | yii\db\Command::query | SELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects" |
| 14:59:55.333 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.333 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.334 | info | yii\db\Command::query | SELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, count(distinct p.used_client) as used_clients, CASE WHEN p.bargain_date >= (to_char(p.bargain_date,'YYYY-') || '01-01') :: DATE THEN to_char( P.bargain_date, 'YYYY')::INTEGER ELSE to_char( P.bargain_date, 'YYYY')::INTEGER - 1 END AS bargain_year FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."client_id"=3296) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year" |
| 14:59:55.335 | info | yii\db\Command::query | SELECT count(distinct p.client_id) as avg_client, count(distinct p.used_client) as avg_used_client, count(distinct p.id) as avg_project, sum(p.budget) AS avg_budget, sum(p.budget /100 * profit_pct) AS avg_profit FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."client_id"=3296) |
| 14:59:55.336 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.336 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:59:55.336 | 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-11') |
| 14:59:55.340 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.340 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:59:55.340 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=22, "last_visit_at"='now()' WHERE "id"=56528 |
| 14:59:55.342 | 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/view-client-histogram', '{"to":"","from":"","user_id":"","project_status":"3","alert":"false","id":"3296","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"category":{"budgetCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"profitsCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"clientCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"projectCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"usedClientCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"]},"seriesBudget":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":1,"arrowNum":"","y":"5494736.80"},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":-1,"arrowNum":1,"y":"0.00"},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"}],"seriesProfits":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":-1,"arrowNum":"","y":"-14286.32"},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":1,"arrowNum":-1,"y":"0.00"},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"}],"seriesClients":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":1,"arrowNum":"","y":1},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":-1,"arrowNum":1,"y":0},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":"","y":0}],"seriesProjects":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":1,"arrowNum":"","y":1},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":-1,"arrowNum":1,"y":0},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":"","y":0}],"seriesUsedClients":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":"","y":0}],"totalBudget":5494736.8,"totalProfits":-14286.31568,"totalClients":1,"totalProjects":1,"totalUsedClients":0,"avg":{"avg_client":"0.11","avg_used_client":"0.00","avg_project":"0.11","avg_budget":"610526.31","avg_profit":"-1587.37"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-11 14:59:55') RETURNING "id" |
| 14:59:55.343 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:59:55.343 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |