ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3e0ccab7ba9: POST https://beta.jinchangxiao.com/v2/implement/get-edit at 2026-06-26 01:23:22 pm by 39.156.194.178

Log Messages

总计66条数据
TimeLevelCategoryMessage
 
13:23:22.751traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
13:23:22.751traceyii\base\Module::getModuleLoading module: debug
13:23:22.752traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
13:23:22.752traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
13:23:22.753traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
13:23:22.753traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.753infotime tracing start1782451402753863168
13:23:22.754traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
13:23:22.754traceyii\web\Application::handleRequestRoute requested: 'v2/implement/get-edit'
13:23:22.754traceyii\base\Module::getModuleLoading module: v2
13:23:22.755infoyii\web\Session::openSession started
13:23:22.756infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:23:22.757infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
13:23:22.758traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.759traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:23:22.759traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.760traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:23:22.760infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
13:23:22.761traceyii\base\Controller::runActionRoute to run: v2/implement/get-edit
13:23:22.761traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ImplementController::actionGetEdit()
13:23:22.761infoyii\db\Command::querySELECT i.*, i.left_at - i.arrived_at AS hours_spent FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON i.client_id = c.id WHERE "i"."id"='7535'
13:23:22.762traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.763traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:23:22.764infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
13:23:22.765infoyii\db\Command::querySELECT "id", "case_status", "client_id", "project_id" FROM "a57be577deb434"."tbl_cases" WHERE "id"=9249
13:23:22.765infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
13:23:22.766infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4161
13:23:22.766infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=3915
13:23:22.767infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_implement_types" WHERE "id"=4
13:23:22.767infoyii\db\Command::querySELECT "id", "id" AS "key", "method" AS "name" FROM "a57be577deb434"."tbl_implement_methods" WHERE "id"=1
13:23:22.768infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
13:23:22.768infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:23:22.769infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
13:23:22.769infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1015)
13:23:22.770infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=2
13:23:22.770infoyii\db\Command::querySELECT *, "product_type_id" AS "key" FROM "a57be577deb434"."tbl_implement_product_types" WHERE "implement_id"=7535
13:23:22.772infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=5) AND ("object_id"=7535)
13:23:22.775infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=24) AND ("object_id"=7535)
13:23:22.778infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_services" WHERE "id"=240
13:23:22.779infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=33
13:23:22.779infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_service_type" WHERE "id"=1
13:23:22.780infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=5) AND ("object_id"=7535) GROUP BY "object_id"
13:23:22.810infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=5) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=7535) GROUP BY "object_id"
13:23:22.828infoyii\db\Command::querySELECT "implement_record_id", sum(amount) as count FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("implement_record_id"=7535) GROUP BY "implement_record_id"
13:23:22.831infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "implement_record_id"=7535 ORDER BY array_position(array[0,1,2,3,5,6,4], status::integer)
13:23:22.834traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.836traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateTicket
13:23:22.836traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
13:23:22.836traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
13:23:22.836traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
13:23:22.836traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
13:23:22.836traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:23:22.836traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.837traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.838traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.838traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:23:22.839infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"=9249
13:23:22.841infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_case_services" WHERE "case_id"=9249
13:23:22.842infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_services" WHERE "id"=234
13:23:22.843infoyii\db\Command::querySELECT "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_implement_types" WHERE "is_delete"=FALSE ORDER BY "order"
13:23:22.844infoyii\db\Command::querySELECT "id" AS "key", "method" AS "name" FROM "a57be577deb434"."tbl_implement_methods" WHERE "is_delete"=FALSE ORDER BY "order"
13:23:22.844infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
13:23:22.846infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("user_status"='1') ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
13:23:22.847traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:23:22.848traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:23:22.850infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 6, 178, 'v2/implement/get-edit', '{"id":"7535","posttime":"1782451402","access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"6","version_code":"178","token":"f7d113e1c4b613e3bf0b29015586d47e"}', '{"code":200,"data":{"model":{"id":7535,"client_id":982,"contact_id":3915,"implement_type":4,"implement_method":1,"arrived_at":"2026-04-07 13:46:00","left_at":"2026-04-07 15:46:00","address":null,"has_following_work":false,"description":"\u5b9e\u65bd\u603b\u7ed3\u8bed\u97f3\u8f93\u5165\u5185\u5bb9\u7b80\u5355\u5a1c\u5a1c\u653e\u7ea0\u7eb7\u89e3\u51b3\u5c31\u51cf\u80a5\u5c31\u5a1c\u5a1c\u5bb6\u5c06\u65a4\u65a4\u8ba1\u8f83\u51cf\u80a5\u540e\u653e\u5047\u7ecf\u6d4e\u7ea0\u7eb7\u5427","created_by":1015,"created_at":"2026-04-07 15:47:16","updated_at":"2026-04-22 16:13:18","satisfaction_id":null,"implement_address":null,"following_work_content":"","location_id":null,"client_address":null,"is_draft":0,"service_id":240,"case_id":9249,"location_in_id":null,"location_out_id":null,"ticket_no":"IM260407001001","client_document_id":null,"client_document_file":null,"indistance":999999999,"outdistance":999999999,"hours_spent":"02:00:00","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"logo":null},"case":{"id":9249,"case_status":3,"client_id":982,"project_id":4161,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4161,"key":4161,"name":"3535"}},"contact":{"id":3915,"key":3915,"name":"\u5218\u5fae"},"implementType":{"id":4,"key":4,"name":"\u552e\u524d\u6d4b\u8bd5"},"implementMethod":{"id":1,"key":1,"name":"\u73b0\u573a\u5b9e\u65bd"},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"implementProductTypes":[{"id":7,"implement_id":7535,"product_type_id":7,"name":"\u8f6f\u4ef6","description":null,"key":7},{"id":10,"implement_id":7535,"product_type_id":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","description":null,"key":10}],"location":null,"locationIn":null,"locationOut":null,"clientAddress":null,"attachmentRelationships":[],"files":[],"service":{"id":240,"serial_no":"ZH03","title":"\u7efc\u5408\u670d\u52a1\u5927\u534a\u5929","brand_id":33,"type_id":1,"points":38,"points_off_time":38,"points_holiday":38,"description":"\u7efc\u5408\u670d\u52a1","created_by":1013,"created_at":"2020-04-17 10:47:35","updated_at":"2026-04-22 16:13:03","is_delete":false,"sort":4,"is_stop":true,"brand":{"id":33,"key":33,"name":"Toast"},"type":{"id":1,"key":1,"name":"\u5b89\u88c5\u670d\u52a1"}},"commentCount":null,"unreadComments":null,"reimbursementCount":null,"clientDocument":null,"reimbursements":[],"hours_spent_display":"2\u5c0f\u65f6","point_display":38,"can_create_items":true,"can_update":true,"can_delete":true,"can_complete":false,"can_create_reimbursement":false,"unread":0,"can_location_in":false,"can_location_out":false},"options":[{"key":"ImplementRecords[service_id]","name":"\u670d\u52a1\u76ee\u5f55","value":[{"key":234,"name":"\u7efc\u5408\u670d\u52a1\u5168\u5929"}]},{"key":"ImplementRecords[implement_type]","name":"\u5b9e\u65bd\u9636\u6bb5","value":[{"key":4,"name":"\u552e\u524d\u6d4b\u8bd5"},{"key":1,"name":"\u552e\u4e2d\u5b9e\u65bd"},{"key":2,"name":"\u552e\u540e\u670d\u52a1"},{"key":5,"name":"\u6536\u8d39\u670d\u52a1"}]},{"key":"ImplementRecords[implement_method]","name":"\u5b9e\u65bd\u65b9\u5f0f","value":[{"key":1,"name":"\u73b0\u573a\u5b9e\u65bd"},{"key":3,"name":"\u8fdc\u7a0b\u5b9e\u65bd"}]},{"key":"ImplementRecords[implementProductTypes]","name":"\u5546\u673a\u7c7b\u578b","value":[{"key":2,"name":"\u670d\u52a1\u5668"},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},{"key":88,"name":"\u79c1\u6709\u4e91"},{"key":8,"name":"\u4e91\u684c\u9762"},{"key":7,"name":"\u8f6f\u4ef6"},{"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},{"key":69,"name":"\u5907\u4efd"},{"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},{"key":12,"name":"\u7b14\u8bb0\u672c"},{"key":13,"name":"\u6253\u5370\u673a"},{"key":14,"name":"UPS"},{"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1"},{"key":17,"name":"\u5de5\u63a7\u673a"},{"key":18,"name":"\u673a\u623f\u8bbe\u5907"},{"key":19,"name":"\u6280\u672f\u670d\u52a1"},{"key":20,"name":"\u529e\u516c\u8bbe\u5907"},{"key":21,"name":"\u6570\u7801\u8bbe\u5907"},{"key":22,"name":"\u670d\u52a1"},{"key":23,"name":"\u793c\u54c1"},{"key":75,"name":"\u8f6f\u4ef6\u5f00\u53d1"},{"key":106,"name":"\u516c\u6709\u4e91"}]},{"key":"ImplementRecords[has_following_work]","name":"\u540e\u7eed\u5de5\u4f5c","value":[{"key":"0","name":"\u5426"},{"key":"1","name":"\u662f"}]},{"key":"Clients[sales_rep]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5332,"name":"\u970d\u536b\u8d85"},{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5087,"name":"\u5218\u5fae"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":5476,"name":"\u6768\u5dcd"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},{"key":0,"name":"\u516c\u6d77\u5ba2\u6237"}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/1.0.42 (HUAWEI Mate 60 BRA-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-06-26 13:23:22', 96297984) RETURNING "id"