ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68675242309f4: POST https://beta.jinchangxiao.com/v2/case/list at 2025-07-04 12:02:10 pm by 114.254.1.137

Log Messages

总计45条数据
TimeLevelCategoryMessage
 
12:02:10.198traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
12:02:10.198traceyii\base\Module::getModuleLoading module: debug
12:02:10.199traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
12:02:10.199traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
12:02:10.199traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
12:02:10.199traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.199traceyii\base\Module::getModuleLoading module: gii
12:02:10.199traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
12:02:10.200traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
12:02:10.200traceyii\web\Application::handleRequestRoute requested: 'v2/case/list'
12:02:10.200traceyii\base\Module::getModuleLoading module: v2
12:02:10.200infoyii\web\Session::openSession started
12:02:10.201infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:02:10.203infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp'
12:02:10.208traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.208traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:02:10.208traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.208traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:02:10.211infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017
12:02:10.214traceyii\base\Controller::runActionRoute to run: v2/case/list
12:02:10.214traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.217traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
12:02:10.217traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewCase
12:02:10.217traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
12:02:10.217traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
12:02:10.217traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\CaseController::actionList()
12:02:10.217traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.217traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:02:10.218traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.219traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.221infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.project_id LEFT JOIN "a57be577deb434"."tbl_pre_sales" "ps" ON ps.case_id = c.id AND ps.has_following_work = true LEFT JOIN "a57be577deb434"."tbl_implement_records" "ir" ON ir.case_id = c.id AND ir.has_following_work = true LEFT JOIN "a57be577deb434"."tbl_implement_records" "i" ON i.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_implement_items" "iri" ON i.id = iri.implement_record_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.deduct_points_from LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = c.last_engineer LEFT JOIN "a57be577deb434"."tbl_case_remind_dates" "crd" ON crd.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_case_remind_receivers" "crr" ON crr.remind_date_id = crd.id LEFT JOIN "a57be577deb434"."tbl_case_carbon_copy_rels" "cccr" ON cccr.case_id = c.id WHERE (("deduct_points_from" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 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, 5358, 1006, 5093)) OR ("deduct_points_from" IS NULL) OR ("last_engineer"=1017) OR ("crr"."user_id"=1017) OR ("cccr"."user_id"=1017) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1017))) AND (("case_status"='2') AND ("c"."last_engineer"='1017')) GROUP BY "c"."id" ORDER BY "c"."updated_at" DESC) "c"
12:02:10.230infoyii\db\Command::querySELECT c.* FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.project_id LEFT JOIN "a57be577deb434"."tbl_pre_sales" "ps" ON ps.case_id = c.id AND ps.has_following_work = true LEFT JOIN "a57be577deb434"."tbl_implement_records" "ir" ON ir.case_id = c.id AND ir.has_following_work = true LEFT JOIN "a57be577deb434"."tbl_implement_records" "i" ON i.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_implement_items" "iri" ON i.id = iri.implement_record_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.deduct_points_from LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = c.last_engineer LEFT JOIN "a57be577deb434"."tbl_case_remind_dates" "crd" ON crd.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_case_remind_receivers" "crr" ON crr.remind_date_id = crd.id LEFT JOIN "a57be577deb434"."tbl_case_carbon_copy_rels" "cccr" ON cccr.case_id = c.id WHERE (("deduct_points_from" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 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, 5358, 1006, 5093)) OR ("deduct_points_from" IS NULL) OR ("last_engineer"=1017) OR ("crr"."user_id"=1017) OR ("cccr"."user_id"=1017) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1017))) AND (("case_status"='2') AND ("c"."last_engineer"='1017')) GROUP BY "c"."id" ORDER BY "c"."updated_at" DESC LIMIT 10
12:02:10.237infoyii\db\Command::querySELECT count(*) as count, sum(case when "sub".case_status=1 then 1 else 0 end) countStatus1, sum(case when "sub".case_status=2 then 1 else 0 end) countStatus2, sum(case when "sub".case_status=3 then 1 else 0 end) countStatus3, sum(case when "sub".case_status=4 then 1 else 0 end) countStatus4, sum(case when "sub".case_status=5 then 1 else 0 end) countStatus5, sum(case when "sub".case_status=6 then 1 else 0 end) countStatus6 FROM (SELECT c.* FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_callback_records" "cb" ON cb.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.project_id LEFT JOIN "a57be577deb434"."tbl_task_groups" "tg" ON tg.id = c.task_group_id LEFT JOIN "a57be577deb434"."tbl_implement_records" "i" ON i.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_pre_sales" "ps" ON ps.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_implement_items" "iri" ON i.id = iri.implement_record_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.deduct_points_from LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = c.last_engineer LEFT JOIN "a57be577deb434"."tbl_case_remind_dates" "crd" ON crd.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_case_remind_receivers" "crr" ON crr.remind_date_id = crd.id LEFT JOIN "a57be577deb434"."tbl_case_carbon_copy_rels" "cccr" ON cccr.case_id = c.id WHERE (("deduct_points_from" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 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, 5358, 1006, 5093)) OR ("deduct_points_from" IS NULL) OR ("last_engineer"=1017) OR ("crr"."user_id"=1017) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1017)) OR ("cccr"."user_id"=1017) OR ("c"."created_by"=1017)) AND ("c"."last_engineer"='1017') GROUP BY "c"."id") "sub"
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createCase
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Dispatcher
12:02:10.257traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
12:02:10.258traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:02:10.258traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:02:10.258infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1017, 0, 262, 'v2/case/list', '{"access_token":"LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp","CaseSearch":{"case_status":"2","sales_rep":"","last_engineer":"1017","case_type":""},"device_type":"0","version_code":"262","page":"1","token":"e221bf694e94ec04f47788b4366c86de","posttime":"1751601731","pagesize":"10"}', '{"code":200,"data":{"list":[],"countList":[{"key":1,"value":0},{"key":2,"value":0},{"key":3,"value":1},{"key":4,"value":0},{"key":5,"value":570},{"key":6,"value":7}],"pagenation":{"totalcount":0,"thispage":1,"pagesize":10},"can_create":false},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-04 12:02:10') RETURNING "id"