ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6943cc25e9b45: POST https://beta.jinchangxiao.com/vue/client/view-client-histogram at 2025-12-18 05:40:53 pm by 59.108.56.210

Log Messages

总计40条数据
TimeLevelCategoryMessage
 
17:40:53.956traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:40:53.956traceyii\base\Module::getModuleLoading module: debug
17:40:53.957traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:40:53.957traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:40:53.957traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:40:53.957traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.957traceyii\base\Module::getModuleLoading module: gii
17:40:53.957traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:40:53.957traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:40:53.957traceyii\web\Application::handleRequestRoute requested: 'vue/client/view-client-histogram'
17:40:53.957traceyii\base\Module::getModuleLoading module: vue
17:40:53.958infoyii\web\Session::openSession started
17:40:53.958infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:40:53.958infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:40:53.963traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.963traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:40:53.963infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:40:53.964traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.964traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:40:53.964infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:53.966traceyii\base\Controller::runActionRoute to run: vue/client/view-client-histogram
17:40:53.966traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.967traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:40:53.967traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ClientController::actionViewClientHistogram()
17:40:53.967infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE ("c"."id"='1661') AND ("deleted"=FALSE)
17:40:53.969traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.969traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:40:53.969traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.969traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:40:53.969infoyii\db\Command::querySELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
17:40:53.970infoyii\db\Command::querySELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects"
17:40:53.971traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.972traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.973infoyii\db\Command::querySELECT 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"=1661) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year"
17:40:53.975infoyii\db\Command::querySELECT 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"=1661)
17:40:53.976traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.976traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:40:53.976infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/client/view-client-histogram', '{"to":"","from":"","user_id":"","project_status":"3","alert":"false","id":"1661","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"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":"333.00"},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":-1,"arrowNum":1,"y":"0.00"},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","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":1,"arrowNum":"","y":"514761.00"},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":-1,"arrowNum":1,"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":"146.52"},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":-1,"arrowNum":1,"y":"0.00"},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","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":1,"arrowNum":"","y":"2882.66"},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":-1,"arrowNum":1,"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":1},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":-1,"arrowNum":1,"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":1,"arrowNum":"","y":1},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":-1,"arrowNum":1,"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":2},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":-1,"arrowNum":1,"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":1,"arrowNum":"","y":1},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":-1,"arrowNum":1,"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":515094,"totalProfits":3029.1816,"totalClients":2,"totalProjects":3,"totalUsedClients":0,"avg":{"avg_client":"0.11","avg_used_client":"0.00","avg_project":"0.33","avg_budget":"57232.67","avg_profit":"336.58"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"59.108.56.210","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/18.5 Safari\/605.1.15"}', FALSE, '2025-12-18 17:40:53') RETURNING "id"
17:40:53.978traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:40:53.978traceyii\redis\Connection::executeCommandExecuting Redis Command: SET