ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6870a8d990d73: POST https://beta.jinchangxiao.com/v2/work-log/list at 2025-07-11 02:02:01 pm by 223.104.40.121

Performance Profiling

Total processing time: 129 ms; Peak memory: 5.223 MB. Show Profiling Timeline

总计62条数据
TimeDurationCategoryInfo
  
14:02:01.63520.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978)) GROUP BY "object_id"
14:02:01.66315.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=19) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978)) GROUP BY "object_id"
14:02:01.6058.7 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, s.end_at - s.start_at AS hours_spent FROM "a57be577deb434"."tbl_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr" ON rvr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_carbon_copy_rels" "ccr" ON ccr.work_log_id = s.id WHERE (("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1000)) AND ("s"."status"='-1') GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, "s"."updated_at" DESC) "c"
14:02:01.6146.8 msyii\db\Command::querySELECT s.*, s.end_at - s.start_at AS hours_spent FROM "a57be577deb434"."tbl_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr" ON rvr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_carbon_copy_rels" "ccr" ON ccr.work_log_id = s.id WHERE (("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1000)) AND ("s"."status"='-1') GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, "s"."updated_at" DESC LIMIT 10
14:02:01.6295.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (3800, 5995, 1781, 5030, 3988, 6003, 846, 728, 6000)
14:02:01.5962.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'
14:02:01.6932.6 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.6262.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978)
14:02:01.7112.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.6962.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.6982.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.7012.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.7092.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.7062.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.7042.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.7142.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))
14:02:01.7181.9 msyii\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', 1000, 2, 1141, 'v2/work-log/list', '{"WorkLogSearch":{"filterDepartment":"","filterUser":"","scenario_id":"","scenario_option_id":"","status":"-1"},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752213760","token":"14349e773e88eb9ecb88adb5a9ad00d1","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":37020,"client_id":3333,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-05-20 00:36:08","created_by":5300,"created_at":"2025-05-20 00:36:09","updated_at":"2025-05-20 00:36:28","start_at":"2025-05-20 00:35:58","description":"\u5251\u5357\u6625\u4f60\u5462","escort":"\u4f60\u4ece\u54ea\u4f60\u4ece\u54ea","is_draft":0,"location_id":null,"project_id":3783,"location_in_id":19210,"location_out_id":19211,"status":-1,"indistance":18383,"outdistance":18383,"hours_spent":"00:00:10","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"logo":null,"sales_rep":null,"salesRep":null,"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355"},"workLogContacts":[{"id":6000,"key":6000,"name":"\u5f20\u5609\u5174","department":"","job_position":"","mobiles":[]}],"commentCount":{"object_id":37020,"comment":3},"attachmentRelationships":[],"locationIn":{"id":19210,"lng":"116.19491","lat":"39.917155","address":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u516b\u89d2\u5317\u8def7\u53f7\u9760\u8fd1\u516b\u89d2\u5317\u8def\u7279\u94a2\u5c0f\u533a","time":"2025-05-20 00:35:58"},"locationOut":{"id":19211,"lng":"116.194898","lat":"39.917159","address":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u516b\u89d2\u5317\u8def7\u53f7\u9760\u8fd1\u516b\u89d2\u5317\u8def\u7279\u94a2\u5c0f\u533a","time":"2025-05-20 00:36:08"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14293,"work_log_id":37020,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":{"work_log_id":37020,"count":"123"},"reimbursements":[{"id":7435,"status":3,"amount":"123","occurrence_at":"2025-05-20 00:35:00","settle_accounts_at":"2025-05-20 00:39:25","settle_accounts_by":5300,"description":"","created_by":5300,"created_at":"2025-05-20 00:38:54","updated_at":"2025-05-20 00:39:25","refuse_description":null,"client_id":3333,"project_id":3783,"next_verify_user":null,"is_resubmited":false,"work_log_id":37020,"pre_sales_id":null,"implement_record_id":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355"},"type":{"id":185,"name":"\u62db\u5f85\u8d39"},"costType":{"id":117902,"object_id":7435,"taxonomy_id":369,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","term_id":18,"description":null,"sort":5,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":185,"is_system":false,"serial_no":null}},"settleAccountsBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"reimbursementCarbonCopyRels":[],"needSettle":[],"reimbursementSettleRels":[{"id":9624,"reimbursement_id":7435,"user_id":5300,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"reimbursementVerifyRels":[{"id":26552,"reimbursement_id":7435,"user_id":5300,"status":1,"verify_at":"2025-05-20 00:39:18","user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26552,"reimbursement_id":7435,"user_id":5300,"status":1,"verify_at":"2025-05-20 00:39:18"}}],"hours_spent_display":"0\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37019,"client_id":141,"scenario_id":1,"scenario_option_id":73,"end_at":"2025-05-16 16:31:05","created_by":5300,"created_at":"2025-05-16 16:30:11","updated_at":"2025-06-12 20:21:42","start_at":"2025-05-16 16:29:57","description":"\u54c8\u54c8\u54c8\u54c8","escort":"","is_draft":0,"location_id":null,"project_id":3739,"location_in_id":19208,"location_out_id":19209,"status":-1,"indistance":15552,"outdistance":15555,"hours_spent":"00:01:08","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","client_class":43,"logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":3739,"key":3739,"name":"\u601d\u79d1\u9632\u706b\u58991140*2+1120*1\u65b0\u8d2d-K-2024"},"workLogContacts":[{"id":728,"key":728,"name":"\u6768\u536b\u56ed","department":"","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobiles":[{"id":2056,"contact_id":728,"mobile":"15210747282","mp_open_id":null}]},{"id":846,"key":846,"name":"\u674e\u4e1c","department":"","job_position":"","mobiles":[{"id":2057,"contact_id":846,"mobile":"18610293071","mp_open_id":null}]}],"commentCount":{"object_id":37019,"comment":4},"attachmentRelationships":[{"id":33123,"object_type":18,"object_id":37019,"attachment_id":24748,"attachment":{"id":24748,"key":24748,"name":"857227db-7f07-32e8-927d-60973fd09627","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/857227db-7f07-32e8-927d-60973fd09627\/20250612202137.png","orig_name":"20250612202137.png"}}],"locationIn":{"id":19208,"lng":"116.288928","lat":"39.960424","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2025-05-16 16:29:57"},"locationOut":{"id":19209,"lng":"116.288857","lat":"39.960344","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6\u91d1\u6e90\u5e97(\u5efa\u6750\u9986)","time":"2025-05-16 16:31:05"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14295,"work_log_id":37019,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37013,"client_id":141,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-03-17 17:00:00","created_by":5300,"created_at":"2025-03-17 21:59:36","updated_at":"2025-03-17 21:59:36","start_at":"2025-03-17 16:00:00","description":"\u76ee\u6807\uff1a\u7ea6\u5ba2\u6237\uff0c\u6c9f\u901a\u601d\u79d1\u7684\u9879\u76ee\u91c7\u8d2d\u6d41\u7a0b\u51b3\u7b56\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u786e\u8ba4\u672c\u5468\u5728\u4eac\u65f6\u95f4\uff0c\u7ea6\u89c1\u9762\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u6682\u5b9a\u672c\u5468\u4e09\u4e0b\u5348\u62dc\u8bbf\u5ba2\u6237\uff0c\u804a\u96c6\u56e2\u7684\u51b3\u7b56\u548c\u540e\u7eed\u5982\u4f55\u63a8\u8fdb\uff0c\u786e\u4fdd\u4ece\u6211\u4eec\u8fd9\u8d70\u91c7\u8d2d\u3002","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:00:00","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","client_class":43,"logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":846,"key":846,"name":"\u674e\u4e1c","department":"","job_position":"","mobiles":[{"id":2057,"contact_id":846,"mobile":"18610293071","mp_open_id":null}]}],"commentCount":{"object_id":37013,"comment":2},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14283,"work_log_id":37013,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37007,"client_id":3332,"scenario_id":1,"scenario_option_id":66,"end_at":"2025-03-17 16:04:00","created_by":5295,"created_at":"2025-03-17 20:54:53","updated_at":"2025-03-17 21:00:16","start_at":"2025-03-17 16:00:00","description":"\u76ee\u6807\uff1a\u7ea6\u62dc\u8bbf\uff0c\u589e\u8fdb\u5ba2\u60c5\uff0c\u4e86\u89e3\u5ba2\u6237IT\u73b0\u72b6\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u4e2d\u79d1\u5bd2\u6b66\u7eaa\u5ba2\u6237\uff0c\u7ea6\u660e\u5929\u4e0b\u5348\u62dc\u8bbf\u5ba2\u6237\uff0c\u4e86\u89e3\u5ba2\u6237IT\u73b0\u72b6\u3002\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"00:04:00","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":3332,"key":3332,"name":"\u4e2d\u79d1\u5bd2\u6b66\u7eaa\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","client_class":43,"logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":5995,"key":5995,"name":"\u5f20\u70e8","department":"","job_position":"","mobiles":[]}],"commentCount":{"object_id":37007,"comment":2},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14276,"work_log_id":37007,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"4\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37012,"client_id":2736,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-03-17 16:00:00","created_by":5300,"created_at":"2025-03-17 21:59:07","updated_at":"2025-03-17 21:59:07","start_at":"2025-03-17 15:00:00","description":"\u76ee\u6807\uff1a\u8ddf\u8fdb\u5ba2\u6237\u5bf9\u62a5\u4ef7\u7684\u53cd\u9988\u548c\u9886\u5bfc\u53cd\u9988\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u4e86\u89e3\u5ba2\u6237\u5bf9\u62a5\u4ef7\u7684\u53cd\u9988\u548c\u9886\u5bfc\u7684\u51b3\u7b56\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5df2\u7ecf\u548c\u9886\u5bfc\u6c47\u62a5\uff0c\u9886\u5bfc\u8fd8\u5728\u8003\u8651\u4e2d\u3002\u5efa\u8bae\u5ba2\u6237\u91c7\u8d2d\u4e00\u53f0\uff0c\u907f\u514d\u7c7b\u4f3c\u5f71\u54cd\u4e1a\u52a1\u7684\u4e8b\u4ef6\u518d\u6b21\u53d1\u751f\u3002","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:00:00","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","client_class":43,"logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":6003,"key":6003,"name":"\u80e1\u4e54\u5e06","department":"","job_position":"","mobiles":[{"id":6787,"contact_id":6003,"mobile":"18600417002","mp_open_id":"oagch6VqjkgD2XpVginGFeC1T0I4"}]}],"commentCount":{"object_id":37012,"comment":2},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14282,"work_log_id":37012,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37008,"client_id":189,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-03-17 15:05:00","created_by":5295,"created_at":"2025-03-17 20:56:34","updated_at":"2025-03-17 21:00:23","start_at":"2025-03-17 15:00:00","description":"\u76ee\u6807\uff1a\u7ea6\u62dc\u8bbf\uff0c\u8ddf\u5ba2\u6237\u4ecb\u7ecd\u6df1\u4fe1\u670dEDR\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u4eac\u897f\u5b66\u6821\uff0c\u5ba2\u6237\u6700\u8fd1\u6bd4\u8f83\u5fd9\uff0c\u53c8\u8981\u653e\u6625\u5047\uff0c\u7ea64\u7ea67\u65e5\u90a3\u5468\u62dc\u8bbf\u5ba2\u6237\u3002\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"00:05:00","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","client_class":80,"logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":1781,"key":1781,"name":"\u9648\u660e\u8d85","department":"","job_position":"","mobiles":[{"id":4275,"contact_id":1781,"mobile":"13611107178","mp_open_id":null}]}],"commentCount":{"object_id":37008,"comment":2},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14277,"work_log_id":37008,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"5\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37011,"client_id":2182,"scenario_id":1,"scenario_option_id":73,"end_at":"2025-03-17 15:00:00","created_by":5300,"created_at":"2025-03-17 21:57:56","updated_at":"2025-05-20 00:36:42","start_at":"2025-03-17 14:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u63d0\u4f9bPA XDR\u8d44\u6599\u8bf4\u660eXDR\u548c\u666e\u901a\u7ec8\u7aef\u9632\u62a4\u7684\u533a\u522b\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u5e2e\u52a9\u5ba2\u6237\u5b89\u6392\u6280\u672f\u63d0\u4f9b\u6587\u5b57\u63cf\u8ff0\uff0c\u8bf4\u660e\u672c\u5730\u7aef\u4fa7\u9632\u62a4\u548cXDR\u9632\u62a4\u7684\u533a\u522b\uff0c\u534f\u52a9\u5ba2\u6237\u5b8c\u6210\u660e\u5929\u4e0a\u5348\u548c\u9886\u5bfc\u7684\u6c47\u62a5\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\u3002\u5df2\u63d0\u4f9b\u76f8\u5173\u8d44\u6599\uff0c\u5e2e\u52a9\u5ba2\u6237\u63d0\u4f9b\u8f85\u52a9\u603b\u7ed3\u8d44\u6599\uff0c\u534f\u52a9\u6c47\u62a5","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:00:00","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":80,"logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":3988,"key":3988,"name":"\u5218\u6625","department":"\u6280\u672f","job_position":"\u6280\u672f\u8d1f\u8d23\u4eba","mobiles":[{"id":4805,"contact_id":3988,"mobile":"18600672467","mp_open_id":"oagch6aS8YvxEP96ol_Vb3a1ZqUI"}]}],"commentCount":{"object_id":37011,"comment":4},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14294,"work_log_id":37011,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":37009,"client_id":2600,"scenario_id":1,"scenario_option_id":66,"end_at":"2025-03-17 14:05:00","created_by":5295,"created_at":"2025-03-17 20:57:42","updated_at":"2025-03-17 21:00:36","start_at":"2025-03-17 14:00:00","description":"\u76ee\u6807\uff1a\u7ea6\u62dc\u8bbf\uff0c\u804a\u91c7\u8d2d\u673a\u4f1a\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u822a\u5929\u7a7a\u95f4\u4fe1\u606f\uff0c\u7ea6\u5468\u4e94\u4e0b\u5348\u62dc\u8bbf\u91c7\u8d2d\u3002\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"00:05:00","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2600,"key":2600,"name":"\u822a\u5929\u79d1\u5de5\uff08\u5317\u4eac\uff09\u7a7a\u95f4\u4fe1\u606f\u6709\u9650\u516c\u53f8","client_class":43,"logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":5030,"key":5030,"name":"\u89e3\u5b87\u5e73","department":"","job_position":"","mobiles":[]}],"commentCount":{"object_id":37009,"comment":2},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14278,"work_log_id":37009,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"5\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":36980,"client_id":24,"scenario_id":1,"scenario_option_id":67,"end_at":"2025-03-17 10:00:00","created_by":5300,"created_at":"2025-03-14 16:47:36","updated_at":"2025-03-17 21:58:28","start_at":"2025-03-17 09:00:00","description":"\u76ee\u6807\uff1a\u6c9f\u901a\u865a\u62df\u5316\u8fd0\u7ef4\u5408\u540c\u7b7e\u8ba2\uff0c\u7ed9\u5ba2\u6237\u63d0\u4f9b\u8fd0\u7ef4\u670d\u52a1\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u6c9f\u901a\u4eca\u5e74\u9700\u6c42\u53d8\u5316\uff0c\u786e\u5b9a\u5408\u540c\u5185\u5bb9\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\u3002\u670d\u52a1\u5185\u5bb9\u6309\u7167\u53bb\u5e74\u6807\u51c6\u5373\u53ef\uff0c\u7ed9\u5ba2\u6237\u51fa\u5408\u540c\uff0c\u5ba2\u6237\u63d0\u4ea4\u5408\u540c\u5ba1\u6279\u6d41\u7a0b","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:00:00","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8","client_class":43,"logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[{"id":3800,"key":3800,"name":"\u5b54\u51e1\u660c","department":"\u4fe1\u606f\u90e8","job_position":"","mobiles":[{"id":4614,"contact_id":3800,"mobile":"13165387986","mp_open_id":"oagch6c5J1WCwNGqxbLlBtZQqmKw"}]}],"commentCount":{"object_id":36980,"comment":2},"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14280,"work_log_id":36980,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false},{"id":36978,"client_id":null,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-03-14 17:30:00","created_by":5300,"created_at":"2025-03-14 15:09:57","updated_at":"2025-05-20 00:35:22","start_at":"2025-03-14 15:09:00","description":"","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":19181,"location_out_id":19185,"status":-1,"indistance":999999999,"outdistance":999999999,"hours_spent":"02:21:00","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":null,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":{"object_id":36978,"comment":2},"attachmentRelationships":[],"locationIn":{"id":19181,"lng":"116.408232421875","lat":"40.0051017252604","address":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u5b89\u7acb\u8def\u9760\u8fd1\u5317\u4eac\u4e2d\u5965\u9a6c\u54e5\u5b5b\u7f57\u5927\u9152\u5e97(\u9e1f\u5de2\u5e97)","time":"2025-03-14 15:09:00"},"locationOut":{"id":19185,"lng":"116.408201768663","lat":"40.0050705295139","address":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u5b89\u7acb\u8def\u9760\u8fd1\u5317\u4eac\u4e2d\u5965\u9a6c\u54e5\u5b5b\u7f57\u5927\u9152\u5e97(\u9e1f\u5de2\u5e97)","time":"2025-03-14 17:30:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14291,"work_log_id":36978,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"2\u5c0f\u65f621\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"can_location_in":false,"can_location_out":false}],"pagenation":{"totalcount":19,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-11 14:02:01') RETURNING "id"
14:02:01.5941.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:02:01.6791.5 msyii\db\Command::querySELECT "work_log_id", sum(amount) as count FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" != 4) AND ("status" != 0) AND ("work_log_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978)) GROUP BY "work_log_id"
14:02:01.6561.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978))
14:02:01.6811.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "work_log_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978)
14:02:01.6911.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=7435) ORDER BY "id"
14:02:01.6881.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=7435 ORDER BY "id"
14:02:01.6591.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978))
14:02:01.6901.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=7435) ORDER BY "id"
14:02:01.6001.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:02:01.6600.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978)
14:02:01.6610.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (37020, 37019, 37013, 37007, 37012, 37008, 37011, 37009, 36980, 36978) ORDER BY "id"
14:02:01.6340.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (728, 846, 1781, 3800, 3988, 5030, 5995, 6000, 6003)
14:02:01.6040.7 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
14:02:01.6860.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE ("user_id"=1000) AND ("reimbursement_id"=7435)
14:02:01.6870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=7435
14:02:01.6220.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5300))
14:02:01.6240.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1
14:02:01.6580.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24748
14:02:01.6580.4 msyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (19210, 19208, 19181)
14:02:01.6240.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3333, 141, 3332, 2736, 189, 2182, 2600, 24)
14:02:01.6840.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7435
14:02:01.6250.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (80, 43)
14:02:01.6220.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295)
14:02:01.6230.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (72, 73, 66, 67)
14:02:01.6230.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
14:02:01.6840.3 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (185, 369))
14:02:01.6260.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3783, 3739)
14:02:01.6860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=7435
14:02:01.6820.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
14:02:01.6850.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=369
14:02:01.6250.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295)
14:02:01.6850.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id"=7435)
14:02:01.6890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
14:02:01.6620.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:02:01.6590.2 msyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (19211, 19209, 19185)
14:02:01.6630.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
14:02:01.6830.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
14:02:01.6880.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
14:02:01.6900.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
14:02:01.6870.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
14:02:01.6850.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
14:02:01.6850.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
14:02:01.6830.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3333
14:02:01.6830.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3783
14:02:01.6830.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1