ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90d1790da2: POST https://beta.jinchangxiao.com/vue/analysis/sales-year-histogram at 2025-09-16 03:09:11 pm by 114.244.128.96

Log Messages

总计55条数据
TimeLevelCategoryMessage
 
15:09:11.592traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:09:11.592traceyii\base\Module::getModuleLoading module: debug
15:09:11.593traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:09:11.593traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:09:11.593traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:09:11.593traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.593traceyii\base\Module::getModuleLoading module: gii
15:09:11.593traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:09:11.593traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:09:11.593traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-year-histogram'
15:09:11.593traceyii\base\Module::getModuleLoading module: vue
15:09:11.594infoyii\web\Session::openSession started
15:09:11.595infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
15:09:11.595infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:09:11.599traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.599traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:11.600traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.600traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:11.600infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:09:11.602traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-year-histogram
15:09:11.602traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewSalesChart
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 软件开发
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 人力资源
15:09:11.603traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
15:09:11.603traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesYearHistogram()
15:09:11.603traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.603traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:11.603infoyii\db\Command::querySELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
15:09:11.604infoyii\db\Command::querySELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects"
15:09:11.605traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.606traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.606infoyii\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, 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"."created_by" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year"
15:09:11.613infoyii\db\Command::querySELECT count(distinct p.client_id) as avg_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
15:09:11.615traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.616traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:11.616infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=23) AND ("visit_date"='2025-09-16')
15:09:11.620traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.620traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:11.620infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=38, "last_visit_at"='now()' WHERE "id"=56587
15:09:11.621infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/analysis/sales-year-histogram', '{"user_id":"","project_status":"3","alert":"false","web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"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"]},"seriesBudget":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":"45425587.80"},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":"66029653.70"},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":"34874669.59"},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":"35385429.58"},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":"35224503.80"},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":"44169012.80"},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":"48005880.55"},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":"45740636.94"},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":"32248958.50"}],"seriesProfits":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":"12731226.00"},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":"8989484.92"},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":"3958090.63"},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":"8547919.01"},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":"7365186.61"},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":"9592543.48"},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":"13310849.09"},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":"8385202.94"},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":"6748418.09"}],"seriesClients":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":78},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":110},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":111},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":87},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":80},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":66},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":78},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":87},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":51}],"seriesProjects":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":158},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":255},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":205},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":156},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":140},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":146},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":167},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":203},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":132}],"avg":{"avg_client":"39.78","avg_project":"175.78","avg_budget":"43177195.14","avg_profit":"8889195.49"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 15:09:11') RETURNING "id"
15:09:11.622traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:11.622traceyii\redis\Connection::executeCommandExecuting Redis Command: SET