ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
687076e81bc38: POST https://beta.jinchangxiao.com/v2/pre-sales/save-new at 2025-07-11 10:28:56 am by 223.104.40.121

Log Messages

总计63条数据
TimeLevelCategoryMessage
 
10:28:56.113traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:28:56.113traceyii\base\Module::getModuleLoading module: debug
10:28:56.113traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:28:56.113traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:28:56.113traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:28:56.114traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.114traceyii\base\Module::getModuleLoading module: gii
10:28:56.114traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:28:56.114traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:28:56.114traceyii\web\Application::handleRequestRoute requested: 'v2/pre-sales/save-new'
10:28:56.114traceyii\base\Module::getModuleLoading module: v2
10:28:56.114infoyii\web\Session::openSession started
10:28:56.115infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:28:56.117infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp'
10:28:56.120traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.120traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.120traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.120traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.120infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017
10:28:56.122traceyii\base\Controller::runActionRoute to run: v2/pre-sales/save-new
10:28:56.122traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createTicket
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
10:28:56.123traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
10:28:56.123traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\PreSalesController::actionSaveNew()
10:28:56.123traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'attendedContacts' in 'app\models\PreSales'.
10:28:56.123traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.123traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.124traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'location_in_distance' in 'app\models\PreSales'.
10:28:56.124traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'location_out_distance' in 'app\models\PreSales'.
10:28:56.124traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.124traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.124infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_location" ("created_by", "address", "geolocation", "updated_at") VALUES (1017, '北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店', '(116.2890785047743,39.96062825520833)', '2025-07-11 10:28') RETURNING "id"
10:28:56.125traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.126traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.126infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Location', 19236, 'a:6:{s:2:"id";i:19236;s:11:"geolocation";s:37:"(116.2890785047743,39.96062825520833)";s:10:"created_by";i:1017;s:7:"address";s:63:"北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店";s:10:"created_at";N;s:10:"updated_at";s:19:"2025-07-11 10:28:00";}', '', 1017, '223.104.40.121')
10:28:56.127infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19236, 'a:0:{}', '', 1017, '223.104.40.121')
10:28:56.128infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_location" ("created_by", "address", "geolocation", "updated_at") VALUES (1017, '北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店', '(116.2890117730035,39.96051378038194)', '2025-07-11 10:28') RETURNING "id"
10:28:56.129infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Location', 19237, 'a:6:{s:2:"id";i:19237;s:11:"geolocation";s:37:"(116.2890117730035,39.96051378038194)";s:10:"created_by";i:1017;s:7:"address";s:63:"北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店";s:10:"created_at";N;s:10:"updated_at";s:19:"2025-07-11 10:28:00";}', '', 1017, '223.104.40.121')
10:28:56.130infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19237, 'a:0:{}', '', 1017, '223.104.40.121')
10:28:56.131infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')
10:28:56.132infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"='8279')
10:28:56.132infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017)
10:28:56.132infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017)
10:28:56.133infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19236)
10:28:56.133infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19237)
10:28:56.133infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_pre_sales" WHERE "case_id"='8279' ORDER BY "id" DESC
10:28:56.134infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_pre_sales" ("case_id", "client_concerns", "client_id", "description", "end_at", "has_following_work", "is_draft", "pre_sales_assessment", "service_id", "start_at", "updated_at", "created_by", "engineer_id", "indistance", "location_in_id", "outdistance", "location_out_id", "ticket_no") VALUES (8279, '', 2815, '', '2025-07-11 10:28:00', FALSE, TRUE, '', 273, '2025-07-11 10:28:00', 'now()', 1017, 1017, 956.05850737637, 19236, 960.36584996089, 19237, 'PS250711001002') RETURNING "id"
10:28:56.138infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PreSales', 1838, 'a:25:{s:2:"id";i:1838;s:9:"client_id";s:4:"2815";s:8:"start_at";s:19:"2025-07-11 10:28:00";s:11:"description";s:0:"";s:15:"client_concerns";s:0:"";s:20:"pre_sales_assessment";s:0:"";s:11:"engineer_id";i:1017;s:10:"created_by";i:1017;s:10:"created_at";N;s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:22:"following_work_content";N;s:14:"project_status";N;s:6:"end_at";s:19:"2025-07-11 10:28:00";s:18:"has_following_work";s:1:"0";s:11:"location_id";N;s:8:"is_draft";s:1:"1";s:7:"case_id";s:4:"8279";s:10:"service_id";s:3:"273";s:14:"location_in_id";i:19236;s:15:"location_out_id";i:19237;s:9:"ticket_no";s:14:"PS250711001002";s:18:"client_document_id";N;s:20:"client_document_file";N;s:10:"indistance";s:16:"956.058507376369";s:11:"outdistance";s:16:"960.365849960891";}', '', 1017, '223.104.40.121')
10:28:56.139infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'
10:28:56.140traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.140traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.140infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=4) AND ("object_id"=1838)
10:28:56.141infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=23) AND ("object_id"=1838)
10:28:56.143infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contact_attend_pre_sales" WHERE "pre_sales_id"=1838
10:28:56.143traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:28:56.143traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:28:56.143infoyii\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, 2, 1141, 'v2/pre-sales/save-new', '{"PreSales":{"attendedContacts":"","case_id":"8279","client_concerns":"","client_id":"2815","description":"","end_at":"2025-07-11 10:28","has_following_work":"0","is_draft":"1","location_in_address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","location_in_distance":"956.058507376369","location_in_lat":"39.96062825520833","location_in_lng":"116.2890785047743","location_in_updated_at":"2025-07-11 10:28","location_out_address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","location_out_distance":"960.365849960891","location_out_lat":"39.96051378038194","location_out_lng":"116.2890117730035","location_out_updated_at":"2025-07-11 10:28","pre_sales_assessment":"","service_id":"273","start_at":"2025-07-11 10:28"},"access_token":"LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp","device_type":"2","posttime":"1752200960","token":"71a36a659e43157daff3c57fd9ffaefd","version_code":"1141"}', '{"code":200,"data":{"id":1838},"status":1,"msg":[{"name":"success","success":"\u65b0\u552e\u524d\u5de5\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-07-11 10:28:56') RETURNING "id"