All Latest
6a4479236fb09: POST https://beta.jinchangxiao.com/vue/client/view-clients at 2026-07-01 10:19:15 am by 39.156.194.178

Log Messages

总计34条数据
TimeLevelCategoryMessage
 
10:19:15.456traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:19:15.456traceyii\base\Module::getModuleLoading module: debug
10:19:15.457traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:19:15.457traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:19:15.458traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:19:15.458traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.458infotime tracing start1782872355458945024
10:19:15.459traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:19:15.459traceyii\web\Application::handleRequestRoute requested: 'vue/client/view-clients'
10:19:15.459traceyii\base\Module::getModuleLoading module: vue
10:19:15.460infoyii\web\Session::openSession started
10:19:15.462infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:19:15.462infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:19:15.464traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.464traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:19:15.465traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.465traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:19:15.465infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:19:15.467traceyii\base\Controller::runActionRoute to run: vue/client/view-clients
10:19:15.467traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.469traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:19:15.469traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ClientController::actionViewClients()
10:19:15.470infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE ("c"."id"='982') AND ("deleted"=FALSE)
10:19:15.471traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.472traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:19:15.472infoyii\db\Command::querySELECT min(bargain_date) as min FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"=982) AND ("project_status"=3) GROUP BY "client_id"
10:19:15.474infoyii\db\Command::querySELECT sum(p.budget * p.profit_pct / 100) AS profit, sum(p.budget) AS budget, to_date(to_char(bargain_date, 'yyyy'), 'yyyy') as edate FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."client_id"=982) AND ("p"."project_status"=3) GROUP BY "edate"
10:19:15.476infoyii\db\Command::querySELECT product_type_id, ppt.name, sum(ppt.budget) as sum, sum(ppt.budget * ppt.pct / 100) as sum2, to_date(to_char(bargain_date, 'yyyy'), 'yyyy') as edate FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_product_types" "ppt" ON ppt.project_id = p.id WHERE ("project_status"='3') AND ("client_id"=982) AND (ppt.budget is not null) GROUP BY "edate", "product_type_id", "ppt"."name"
10:19:15.478infoyii\db\Command::querySELECT product_type_id, ppt.name, sum(ppt.budget) as sum, sum(ppt.budget * ppt.pct / 100) as sum2 FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_product_types" "ppt" ON ppt.project_id = p.id WHERE ("project_status"='3') AND ("client_id"=982) AND (ppt.budget is not null) GROUP BY "product_type_id", "ppt"."name"
10:19:15.480traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.481traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:19:15.481infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/client/view-clients', '{"id":"982"}', '{"code":2000,"result":{"list":[{"profit":"5729331.1000000000000000","budget":"12804392","edate":"2026","display":"","display2":"","arrow":1,"arrow2":1},{"profit":0,"budget":0,"edate":2025,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2024,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2023,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2022,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2021,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2020,"display":"-100","display2":"-100","arrow":-1,"arrow2":-1},{"profit":"373027.500000000000","budget":"2486850","edate":"2019","display":"","display2":"","arrow":1,"arrow2":1}],"years":[{"key":"all","name":"\u5168\u90e8"},{"key":2019,"name":"2019\u5e74"},{"key":2020,"name":"2020\u5e74"},{"key":2021,"name":"2021\u5e74"},{"key":2022,"name":"2022\u5e74"},{"key":2023,"name":"2023\u5e74"},{"key":2024,"name":"2024\u5e74"},{"key":2025,"name":"2025\u5e74"},{"key":2026,"name":"2026\u5e74"}],"analysis":[{"name":"all","data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","y":83.09},{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","y":16.26},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","y":0.34},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","y":0.23},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","y":0.04},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","y":0.03},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","y":0.02}]},{"name":2019,"data":[{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","edate":"2019","y":100}]},{"name":2020,"data":[]},{"name":2021,"data":[]},{"name":2022,"data":[]},{"name":2023,"data":[]},{"name":2024,"data":[]},{"name":2025,"data":[]},{"name":2026,"data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","edate":"2026","y":99.23},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","edate":"2026","y":0.4},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","edate":"2026","y":0.28},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","edate":"2026","y":0.04},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","edate":"2026","y":0.04},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","edate":"2026","y":0.02}]}],"analysis2":[{"name":"all","data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","y":93.68},{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","y":6.11},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","y":0.09},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","y":0.06},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","y":0.01},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","y":0.05},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","y":0}]},{"name":2019,"data":[{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","edate":"2019","y":100}]},{"name":2020,"data":[]},{"name":2021,"data":[]},{"name":2022,"data":[]},{"name":2023,"data":[]},{"name":2024,"data":[]},{"name":2025,"data":[]},{"name":2026,"data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","edate":"2026","y":99.78},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","edate":"2026","y":0.09},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","edate":"2026","y":0.06},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","edate":"2026","y":0.01},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","edate":"2026","y":0.05},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","edate":"2026","y":0}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-01 10:19:15', 22333952) RETURNING "id"
10:19:15.486traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:19:15.486traceyii\redis\Connection::executeCommandExecuting Redis Command: SET