ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68819a9791d4f: POST https://beta.jinchangxiao.com/vue/work-log/list at 2025-07-24 10:29:43 am by 122.115.228.210

Log Messages

总计78条数据
TimeLevelCategoryMessage
 
10:29:43.593traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:29:43.593traceyii\base\Module::getModuleLoading module: debug
10:29:43.594traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:29:43.597traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:29:43.597traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:29:43.603traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:43.606traceyii\base\Module::getModuleLoading module: gii
10:29:43.606traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:29:43.606traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:29:43.606traceyii\web\Application::handleRequestRoute requested: 'vue/work-log/list'
10:29:43.606traceyii\base\Module::getModuleLoading module: vue
10:29:43.607infoyii\web\Session::openSession started
10:29:43.608infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:29:43.608infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:29:43.630traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:43.633traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:43.636traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:43.640traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:43.643infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:29:43.656traceyii\base\Controller::runActionRoute to run: vue/work-log/list
10:29:43.656traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:43.663traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:29:43.663traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\WorkLogController::actionList()
10:29:43.663traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:43.666traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:43.670infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, s.end_at - s.start_at AS hours_spent, CASE WHEN rvr.status = 0 THEN 1 ELSE 0 END as approvesort 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_location" "lin" ON s.location_in_id = lin.id LEFT JOIN "a57be577deb434"."tbl_location" "lout" ON s.location_out_id = lout.id 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 LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr2" ON rvr2.work_log_id = s.id and rvr2.user_id = 1001 and rvr2.status = 0 WHERE ("rvr2"."user_id" IS NOT NULL) AND ("s"."is_draft"=FALSE) GROUP BY "s"."id", "lin"."id", "lout"."id", "approvesort" ORDER BY "is_draft" DESC, "approvesort" DESC, "s"."end_at", s.updated_at DESC nulls last, "s"."created_at" DESC) "c"
10:29:43.756infoyii\db\Command::querySELECT s.*, s.end_at - s.start_at AS hours_spent, CASE WHEN rvr.status = 0 THEN 1 ELSE 0 END as approvesort 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_location" "lin" ON s.location_in_id = lin.id LEFT JOIN "a57be577deb434"."tbl_location" "lout" ON s.location_out_id = lout.id 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 LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr2" ON rvr2.work_log_id = s.id and rvr2.user_id = 1001 and rvr2.status = 0 WHERE ("rvr2"."user_id" IS NOT NULL) AND ("s"."is_draft"=FALSE) GROUP BY "s"."id", "lin"."id", "lout"."id", "approvesort" ORDER BY "is_draft" DESC, "approvesort" DESC, "s"."end_at", s.updated_at DESC nulls last, "s"."created_at" DESC LIMIT 20
10:29:43.831infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295)
10:29:43.842infoyii\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))
10:29:43.855infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
10:29:43.870infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (72, 67, 66, 73)
10:29:43.878infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1
10:29:43.889infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 402, 18, 530, 24, 2600, 2182, 189, 2736, 3332, 141, 3333)
10:29:43.901infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5311, 5295)
10:29:43.913infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (80, 43, 47)
10:29:43.925infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3496, 3673, 3739, 3783)
10:29:43.933infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020)
10:29:43.942infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (5248, 24, 5286, 1022, 3800, 5995, 1781, 5030, 3988, 6003, 846, 728, 6000)
10:29:43.967infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (24, 728, 846, 1022, 1781, 3800, 3988, 5030, 5248, 5286, 5995, 6000, 6003)
10:29:43.978infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020)) GROUP BY "object_id"
10:29:44.021infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020))
10:29:44.028infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24748
10:29:44.036infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (19181, 19208, 19210)
10:29:44.044infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (19185, 19209, 19211)
10:29:44.049infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020))
10:29:44.058infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020)
10:29:44.066infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020) ORDER BY "id"
10:29:44.075infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:29:44.081infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:29:44.090infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=19) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020)) GROUP BY "object_id"
10:29:44.130infoyii\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 (35860, 35859, 35858, 35857, 35856, 35855, 35854, 36978, 36980, 37009, 37011, 37008, 37012, 37007, 37013, 37019, 37020)) GROUP BY "work_log_id"
10:29:44.137traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:44.141traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:44.145infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.154infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.161infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.173infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.182infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.192infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.197infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.207infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.215infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.222infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.231infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.237infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.243infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.249infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.253infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.259infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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"=1001))
10:29:44.268traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:44.270traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:44.272infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=19) AND ("visit_date"='2025-07-24')
10:29:44.283traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:44.284traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:44.284infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=3, "last_visit_at"='now()' WHERE "id"=49858
10:29:44.292infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/work-log/list', '{"Filter":{"name":"end_at","sort":"ASC"},"WorkLogSearch":{"filterUser":"","has_client":"","has_project":"","status":"","is_arrive":"","description":"","period":"","filter":"approve","is_draft":""},"page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":35860,"client_id":12,"scenario_id":1,"scenario_option_id":72,"end_at":"2024-10-14 11:00:00","created_by":5300,"created_at":"2024-10-14 21:01:29","updated_at":"2024-10-14 21:01:29","start_at":"2024-10-14 10:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u4e9a\u7ec8\u7aef\u5165\u7f51\u63a7\u5236\uff0c\u4fdd\u969c\u8bbf\u95ee\u5b89\u5168\u548c\u4e1a\u52a1\u7a33\u5b9a\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u817e\u8baf\u4f1a\u8bae\uff0c\u5b89\u6392\u5382\u5546\u6280\u672f\u548c\u5ba2\u6237\u5bf9\u63a5\u9700\u6c42\uff0c\u5e2e\u52a9\u63d0\u4f9b\u89e3\u51b3\u65b9\u6848\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\n\u5ba2\u6237\u73b0\u72b6\uff1a\u4f7f\u7528\u601d\u79d1ISE\uff0c\u901a\u8fc7Mac\u5730\u5740\u7ed1\u5b9a\u4e9a\u7ec8\u7aef\uff0c\u8bbe\u7f6evlan\u3002\u73b0\u5728\u7684\u95ee\u9898\uff1a1\u3001ISE\u670d\u52a1\u5668\u4e0d\u591f\uff0c\u5982\u5355\u673a\u6545\u969c\uff0c\u4f1a\u9020\u6210\u4e1a\u52a1\u4e2d\u65ad\u30022\u3001\u73b0\u5728\u5347\u7ea7\u540e\u53d8\u6210\u8ba2\u9605\u5f0f\uff08\u4e4b\u524d\u4e70\u7684\u662f\u5e76\u53d1\uff0c800-1000\u5e76\u53d1\uff09\u3002\u73b0\u5728\u6539\u6210\u8ba2\u9605\u6a21\u5f0f\u540e\uff0c\u6bcf\u5e74\u7684\u6210\u672c\u6bd4\u8f83\u9ad8\u3002\n\u5ba2\u6237\u9700\u6c42\uff1a\n1\u3001\u5458\u5de5\u3001\u4e9a\u7ec8\u7aef\u3001\u8bbf\u5ba2\u5165\u7f51\u8ba4\u8bc1\u3002\uff08\u6df1\u4fe1\u670d\uff1a\u53ea\u505a\u51c6\u5165\u65c1\u6302\u5373\u53ef\uff09\u3002\n1\uff09\u5929\u6d25\u5458\u5de5\uff1a600\u4e2aPC\u6216\u8005\u7b14\u8bb0\u672c\uff0c\u4e9a\u7ec8\u7aef2000-3000\uff0c\u4e9a\u7ec8\u7aef\u7c7b\u578b\uff1a\u65e0\u7ebf\u4fe1\u53f7\u91c7\u96c6\u76d2\u3001\u6761\u7801\u67aa\u7b49\uff0c\u7c7b\u578b\u975e\u5e38\u591a\uff0c\u6682\u65f6\u65e0\u6cd5\u51c6\u786e\u7edf\u8ba1\u3002\n2\uff09\u5e38\u5dde\uff1a3000\u4e2a\u4e9a\u7ec8\u7aef\n2\u3001\u5e0c\u671b\u5c3d\u91cf\u505a\u7eaf\u8f6f\u4ea4\u4ed8\u3002\n3\u3001\u652f\u6301HA\u67b6\u6784\uff0c\u907f\u514d\u7f51\u7edc\u4e2d\u65ad\uff0c\u5f71\u54cd\u4e1a\u52a1\u3002\u6709\u53ef\u80fd\u4e00\u4e2a\u5730\u65b9\u4e70\u4e24\u53f0\uff0c\u6216\u8005\u4e24\u4e2a\u5730\u70b9\u8fdb\u884c\u4e92\u5907\u3002\u770b\u89e3\u51b3\u65b9\u6848\u7684\u6210\u672c\u60c5\u51b5\u3002\uff08\u6df1\u4fe1\u670d\u505a\u5f02\u5730\u4e92\u5907\uff0c\u9700\u8981\u4e24\u8fb9\u7684\u7ec8\u7aef\u6570\u91cf\u76f8\u540c\u6216\u8005\u76f8\u8fd1\u4e14\u7f51\u7edc\u7a33\u5b9a\uff0c\u96be\u5ea6\u6bd4\u8f83\u5927\uff0c\u672c\u5730\u4e92\u5907\u6210\u672c\u9ad8\u4e8e\u601d\u79d1\uff0c\u6b63\u5728\u5546\u8ba8\u7eaf\u8f6f\u4ea4\u4ed8\u7684\u4ef7\u683c\uff09","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","client_class":80,"logo":"","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":{},"workLogContacts":[{"id":1022,"key":1022,"name":"\u674e\u7194\u53cb","department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":5574,"contact_id":1022,"mobile":"15311444022","mp_open_id":"oagch6STIcr4Xg3n38Njq9ZI3Kwg"}]}],"commentCount":{"object_id":35860,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13043,"work_log_id":35860,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35859,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:54","updated_at":"2024-10-14 20:59:54","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35859,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13042,"work_log_id":35859,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35858,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:43","updated_at":"2024-10-14 20:59:43","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35858,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13041,"work_log_id":35858,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35857,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:40","updated_at":"2024-10-14 20:59:40","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35857,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13040,"work_log_id":35857,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35856,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:36","updated_at":"2024-10-14 20:59:36","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35856,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13039,"work_log_id":35856,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35855,"client_id":18,"scenario_id":1,"scenario_option_id":72,"end_at":"2024-10-14 16:00:00","created_by":5300,"created_at":"2024-10-14 20:59:03","updated_at":"2024-10-14 20:59:03","start_at":"2024-10-14 15:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u63d0\u4f9b\u6709\u6548\u7684\u52d2\u7d22\u75c5\u6bd2\u89e3\u51b3\u65b9\u6848\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u7ea6\u5ba2\u6237\u65f6\u95f4\u5b89\u6392\u65b9\u6848\u4ea4\u6d41\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u672c\u5468\u516c\u53f8\u6709\u68c0\u67e5\uff0c\u5b89\u6392\u5728\u4e0b\u5468\u505a\u4ea4\u6d41\u3002","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":18,"key":18,"name":"\u4e2d\u5fb7\u8bc1\u5238\u6709\u9650\u8d23\u4efb\u516c\u53f8","client_class":43,"logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[{"id":24,"key":24,"name":"\u90b1\u91d1\u731b","department":"IT\u8fd0\u7ef4\u90e8","job_position":"\u7ecf\u7406","mobiles":[{"id":31,"contact_id":24,"mobile":"18910071652","mp_open_id":""}]}],"commentCount":{"object_id":35855,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13038,"work_log_id":35855,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35854,"client_id":530,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 17:00:00","created_by":5300,"created_at":"2024-10-14 20:58:25","updated_at":"2024-10-14 20:58:25","start_at":"2024-10-14 16:00:00","description":"\u76ee\u6807\uff1a\u8ddf\u5ba2\u6237\u6c9f\u901a\u4e24\u5e74\u7684\u4ef7\u683c\uff0c\u5e2e\u52a9\u5ba2\u6237\u63a7\u5236\u91c7\u8d2d\u6210\u672c\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u8ddf\u5ba2\u6237\u6c9f\u901a\u4e24\u5e74\u4e0b\u5355\u7684\u4ed8\u6b3e\u65b9\u5f0f\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\u3002\u8ddf\u5ba2\u6237\u6c9f\u901a\u5982\u679c\u4e0b\u5355\u4e24\u5e74\uff0c\u9700\u8981\u4e00\u6b21\u6027\u4ed8\u6b3e\u4e24\u5e74\u7684\u8d39\u7528\uff0c\u65e0\u6cd5\u7b7e\u8ba2\u4e24\u5e74\u7684\u5408\u540c\uff0c\u9010\u5e74\u6536\u8d39\uff0c\u6211\u4eec\u9700\u8981\u4e00\u6b21\u6027\u548c\u5382\u5546\u4e0b\u5355\u4e24\u5e74\u65b9\u53ef\u4eab\u53d7\u4eca\u5e74\u7684\u4ef7\u683c\uff0c\u7b49\u5f85\u5ba2\u6237\u53cd\u9988\u3002","escort":"","is_draft":0,"location_id":"","project_id":3673,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)","client_class":43,"logo":"","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":3673,"key":3673,"name":"PA3220\u7eed\u4fdd1\u5e74-G-2024"},"workLogContacts":[{"id":5248,"key":5248,"name":"Alice","department":"\u91c7\u8d2d","job_position":"","mobiles":[{"id":6036,"contact_id":5248,"mobile":"15618229663","mp_open_id":""}]}],"commentCount":{"object_id":35854,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13037,"work_log_id":35854,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":36978,"client_id":"","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":"","project_id":"","location_in_id":19181,"location_out_id":19185,"status":-1,"indistance":"","outdistance":"","hours_spent":"02:21:00","approvesort":1,"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":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"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":"","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":{"object_id":36978,"unread":1},"reimbursementCount":{},"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,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"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":"","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":{},"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":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14280,"work_log_id":36980,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"00:05:00","approvesort":1,"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":{},"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":"","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":{},"workLogContacts":[{"id":5030,"key":5030,"name":"\u89e3\u5b87\u5e73","department":"","job_position":"","mobiles":[]}],"commentCount":{"object_id":37009,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14278,"work_log_id":37009,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"5\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"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":"","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":{},"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":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14294,"work_log_id":37011,"user_id":1001,"status":0,"description":"","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":{"object_id":37011,"unread":1},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"00:05:00","approvesort":1,"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":{},"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":"","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":{},"workLogContacts":[{"id":1781,"key":1781,"name":"\u9648\u660e\u8d85","department":"","job_position":"","mobiles":[{"id":4275,"contact_id":1781,"mobile":"13611107178","mp_open_id":""}]}],"commentCount":{"object_id":37008,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14277,"work_log_id":37008,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"5\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"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":"","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":{},"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":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14282,"work_log_id":37012,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"00:04:00","approvesort":1,"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":{},"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":"","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":{},"workLogContacts":[{"id":5995,"key":5995,"name":"\u5f20\u70e8","department":"","job_position":"","mobiles":[]}],"commentCount":{"object_id":37007,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14276,"work_log_id":37007,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"4\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"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":{},"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":"","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":{},"workLogContacts":[{"id":846,"key":846,"name":"\u674e\u4e1c","department":"","job_position":"","mobiles":[{"id":2057,"contact_id":846,"mobile":"18610293071","mp_open_id":""}]}],"commentCount":{"object_id":37013,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14283,"work_log_id":37013,"user_id":1001,"status":0,"description":"","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":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":3739,"location_in_id":19208,"location_out_id":19209,"status":-1,"indistance":15552,"outdistance":15555,"hours_spent":"00:01:08","approvesort":1,"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":{},"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":"","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":""}]},{"id":846,"key":846,"name":"\u674e\u4e1c","department":"","job_position":"","mobiles":[{"id":2057,"contact_id":846,"mobile":"18610293071","mp_open_id":""}]}],"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":"\/vue\/attachment\/view\/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":"","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":{"object_id":37019,"unread":3},"reimbursementCount":{},"hours_spent_display":"1\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"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":"","project_id":3783,"location_in_id":19210,"location_out_id":19211,"status":-1,"indistance":18383,"outdistance":18383,"hours_spent":"00:00:10","approvesort":1,"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":{},"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":"","sales_rep":"","salesRep":{},"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":"","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":{"object_id":37020,"unread":2},"reimbursementCount":{"work_log_id":37020,"count":"123"},"hours_spent_display":"0\u5206\u949f","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":17,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-24 10:29:44') RETURNING "id"
10:29:44.317traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:44.318traceyii\redis\Connection::executeCommandExecuting Redis Command: SET