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

Log Messages

总计81条数据
TimeLevelCategoryMessage
 
10:30:25.086traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:30:25.086traceyii\base\Module::getModuleLoading module: debug
10:30:25.087traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:30:25.087traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:30:25.087traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:30:25.087traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.087traceyii\base\Module::getModuleLoading module: gii
10:30:25.087traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:30:25.088traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:30:25.088traceyii\web\Application::handleRequestRoute requested: 'vue/work-log/list'
10:30:25.088traceyii\base\Module::getModuleLoading module: vue
10:30:25.088infoyii\web\Session::openSession started
10:30:25.088infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:30:25.088infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:30:25.093traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.093traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:30:25.093traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.093traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:30:25.094infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:30:25.095traceyii\base\Controller::runActionRoute to run: vue/work-log/list
10:30:25.095traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.096traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:30:25.096traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\WorkLogController::actionList()
10:30:25.096traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.096traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:30:25.097traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.097traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.098infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:30:25.099infoyii\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_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 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"=1001)) AND ("s"."is_draft"='0') GROUP BY "s"."id", "lin"."id", "lout"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, s.updated_at DESC nulls last, "s"."created_at" DESC) "c"
10:30:25.160infoyii\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_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 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"=1001)) AND ("s"."is_draft"='0') GROUP BY "s"."id", "lin"."id", "lout"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, s.updated_at DESC nulls last, "s"."created_at" DESC LIMIT 20
10:30:25.247infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1000, 1004, 5016, 5250, 5300)
10:30:25.248infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5016, 5087, 1004, 5300, 1000))
10:30:25.249infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 1)
10:30:25.249infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (66, 71, 72, 67, 73, 27)
10:30:25.249infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id" IN (1, 3)
10:30:25.250infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2137, 2526, 2125, 2130, 2815, 3338, 3337, 3333, 141, 3056)
10:30:25.250infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5087, 1013, 5300, 5332)
10:30:25.251infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 43, 80, 1)
10:30:25.251infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3291, 3110, 3822, 3811, 3805, 3783, 3739, 3804)
10:30:25.253infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017)
10:30:25.257infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4590, 5529, 5245, 846, 728, 6000, 6010, 6014)
10:30:25.259infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (728, 846, 4590, 5245, 5529, 6000, 6010, 6014)
10:30:25.260infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017)) GROUP BY "object_id"
10:30:25.281infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017))
10:30:25.283infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24738, 24748, 24749, 24765, 24766, 24767)
10:30:25.284infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (19250, 19248, 19240, 19230, 19224, 19222, 19216, 19214, 19210, 19208, 19202, 19196)
10:30:25.284infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (19251, 19249, 19241, 19231, 19225, 19223, 19217, 19215, 19211, 19209, 19203, 19197)
10:30:25.284infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017))
10:30:25.286infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017)
10:30:25.287infoyii\db\Command::querySELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5016)
10:30:25.288infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5016, 1000))
10:30:25.288infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017) ORDER BY "id"
10:30:25.289infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 1001)
10:30:25.290infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1000))
10:30:25.290infoyii\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 (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017)) GROUP BY "object_id"
10:30:25.306infoyii\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 (31558, 28542, 26375, 26365, 37034, 37033, 37031, 37030, 37029, 37028, 37027, 37026, 37024, 37022, 37023, 15578, 37020, 37019, 37018, 37017)) GROUP BY "work_log_id"
10:30:25.308infoyii\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:30:25.310infoyii\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:30:25.313infoyii\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:30:25.316infoyii\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:30:25.318infoyii\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:30:25.321infoyii\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:30:25.323infoyii\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:30:25.326infoyii\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:30:25.328infoyii\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:30:25.331infoyii\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:30:25.333infoyii\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:30:25.336infoyii\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:30:25.338infoyii\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:30:25.341infoyii\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:30:25.343infoyii\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:30:25.346infoyii\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:30:25.349traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.350traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:30:25.350infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=19) AND ("visit_date"='2025-07-24')
10:30:25.353traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.353traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:30:25.353infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=12, "last_visit_at"='now()' WHERE "id"=49858
10:30:25.355infoyii\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":"DESC"},"WorkLogSearch":{"has_client":"","has_project":"","status":"","is_arrive":"","description":"","period":"","filter":"","is_draft":"0"},"page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":31558,"client_id":2137,"scenario_id":1,"scenario_option_id":66,"end_at":"","created_by":5087,"created_at":"2023-11-12 19:04:24","updated_at":"2023-11-12 19:04:24","start_at":"2023-11-12 18:04:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"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":2137,"key":2137,"name":"\u4e2d\u56fd\u822a\u5929\u79d1\u5de5\u96c6\u56e2","client_class":43,"logo":"","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[],"commentCount":{"object_id":31558,"comment":1},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":28542,"client_id":2526,"scenario_id":1,"scenario_option_id":71,"end_at":"","created_by":5087,"created_at":"2023-08-14 15:41:26","updated_at":"2023-08-14 15:41:26","start_at":"2023-08-14 14:40:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":3291,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":71,"key":71,"name":"\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":43,"logo":"","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":3291,"key":3291,"name":"\u4ea4\u6362\u673a\u91c7\u8d2d-K"},"workLogContacts":[{"id":4590,"key":4590,"name":"\u5218\u620e","department":"","job_position":"","mobiles":[{"id":5400,"contact_id":4590,"mobile":"13691358235","mp_open_id":""}]}],"commentCount":{"object_id":28542,"comment":1},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":26375,"client_id":2125,"scenario_id":1,"scenario_option_id":72,"end_at":"","created_by":5087,"created_at":"2023-06-12 20:57:36","updated_at":"2023-06-12 20:57:36","start_at":"2023-06-12 19:47:00","description":"\u56fd\uff1a\u7ba1\u57fa\u7840\u73af\u5883 \u673a\u623f \u670d\u52a1\u5668 \u8fd0\u7ef4 \u5b89\u5168\n\u9700\u6c42\uff1a\u4e70\u5b58\u50a8 \u6280\u6539\u9879\u76ee \u9884\u7b97300\u4e07 \u4ee5\u5185\u3002\n\u95ee\u9898\uff1a\u56fd\u4ea7\u5316\u66ff\u4ee3\n\u9700\u6c42\uff1a\u4e70\u8fd0\u7ef4\u670d\u52a1\n\u95ee\u9898\uff1a\u98ce\u8bc4\u4e4b\u540e\u9700\u8981\u6574\u6539\u3002\u4eca\u5e74\u8d70\u4e863-4\u4e2a\u4eba\uff0c\u9ad8\u9e4f\u4e5f\u8d70\u4e86\uff0c\u4eba\u5c11\u4e8b\u513f\u591a\u6ca1\u65f6\u95f4\u6ca1\u4eba\u3002\n\nSM\u7f51800\u7528\u6237 \u5546M\u7f511000\u591a\u7528\u6237\/\u4e91\u5c97159\u9662\u91cc\u51e0\u767e\u4eba\/\u6cb3\u5317\u71d5\u90ca500\u4eba\/\u5c0f\u8857\u6865300\u591a\u4eba\u4e00\u5171\u5341\u4e94\u516d\u4e2a\u4eba\/\u5b89\u51682\u4eba\u7ba1 \u5e94\u7528\u7cfb\u7edf \u4e1a\u52a1\u7cfb\u7edf\u90fd\u9700\u8981\u4eba\uff0c\u5269\u4e0b\u5e72\u6d3b\u7684\u4eba\u4e0d\u591a\u6240\u4ee5\u9700\u8981\u4e70\u670d\u52a1\u3002\n","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.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":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","client_class":47,"logo":"","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[],"commentCount":{"object_id":26375,"comment":1},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":26365,"client_id":2130,"scenario_id":1,"scenario_option_id":67,"end_at":"","created_by":5087,"created_at":"2023-06-12 08:15:59","updated_at":"2023-06-12 08:15:59","start_at":"2023-06-12 07:15:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":3110,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.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":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","client_class":47,"logo":"","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3110,"key":3110,"name":"\u5b89\u5168\u4ea7\u54c1\u91c7\u8d2d-K"},"workLogContacts":[],"commentCount":{"object_id":26365,"comment":1},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37034,"client_id":2815,"scenario_id":1,"scenario_option_id":66,"end_at":"2025-07-16 21:09:00","created_by":1000,"created_at":"2025-07-16 21:08:11","updated_at":"2025-07-16 21:09:05","start_at":"2025-07-16 21:07:00","description":"\u4f60\u60f3\u5a1c\u5a1c","escort":"\u7cbe\u5f69\u96c6\u9526\u5403","is_draft":0,"location_id":"","project_id":3822,"location_in_id":19250,"location_out_id":19251,"status":1,"indistance":9122,"outdistance":9122,"hours_spent":"00:02:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3822,"key":3822,"name":"\u9ad8\u5fb7\u5eb7\u8f6f"},"workLogContacts":[{"id":5245,"key":5245,"name":"\u674e\u4fca","department":"\u9500\u552e","job_position":"\u7ecf\u7406","mobiles":[{"id":6034,"contact_id":5245,"mobile":"18101123631","mp_open_id":""}]}],"commentCount":{"object_id":37034,"comment":3},"attachmentRelationships":[],"locationIn":{"id":19250,"lng":"116.194952256944","lat":"39.9172675238715","address":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u516b\u89d2\u5317\u8def\u9760\u8fd1\u516b\u89d2\u5317\u8def\u7279\u94a2\u5c0f\u533a","time":"2025-07-16 21:07:00"},"locationOut":{"id":19251,"lng":"116.194951985677","lat":"39.9172667100694","address":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u516b\u89d2\u5317\u8def\u9760\u8fd1\u516b\u89d2\u5317\u8def\u7279\u94a2\u5c0f\u533a","time":"2025-07-16 21:09:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14326,"work_log_id":37034,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37034,"count":"743"},"hours_spent_display":"2\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37033,"client_id":2815,"scenario_id":1,"scenario_option_id":71,"end_at":"2025-07-13 17:27:00","created_by":1004,"created_at":"2025-07-13 17:26:31","updated_at":"2025-07-13 17:27:43","start_at":"2025-07-13 17:25:00","description":"\u7cbe\u5f69\u96c6\u9526\u653e\u5047","escort":"\u5c31\u653e\u5047\u5efa\u56fd\u53ef\u89c2\u770b","is_draft":0,"location_id":"","project_id":3822,"location_in_id":19248,"location_out_id":19249,"status":1,"indistance":9122,"outdistance":9122,"hours_spent":"00:02:00","createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":71,"key":71,"name":"\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3822,"key":3822,"name":"\u9ad8\u5fb7\u5eb7\u8f6f"},"workLogContacts":[{"id":5245,"key":5245,"name":"\u674e\u4fca","department":"\u9500\u552e","job_position":"\u7ecf\u7406","mobiles":[{"id":6034,"contact_id":5245,"mobile":"18101123631","mp_open_id":""}]},{"id":6014,"key":6014,"name":"\u51e4\u59d0","department":"","job_position":"","mobiles":[{"id":6798,"contact_id":6014,"mobile":"13078945632","mp_open_id":""}]}],"commentCount":{"object_id":37033,"comment":6},"attachmentRelationships":[],"locationIn":{"id":19248,"lng":"116.194949815538","lat":"39.9172631835937","address":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u516b\u89d2\u5317\u8def\u9760\u8fd1\u516b\u89d2\u5317\u8def\u7279\u94a2\u5c0f\u533a","time":"2025-07-13 17:25:00"},"locationOut":{"id":19249,"lng":"116.194949815538","lat":"39.9172631835937","address":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u516b\u89d2\u5317\u8def\u9760\u8fd1\u516b\u89d2\u5317\u8def\u7279\u94a2\u5c0f\u533a","time":"2025-07-13 17:27:00"},"files":[],"workLogCarbonCopyRels":[{"id":15607,"work_log_id":37033,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}},{"id":15608,"work_log_id":37033,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}}],"workLogVerifyRels":[{"id":14324,"work_log_id":37033,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37033,"count":"111"},"hours_spent_display":"2\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37031,"client_id":3338,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-07-11 14:05:00","created_by":1000,"created_at":"2025-07-11 14:05:51","updated_at":"2025-07-11 14:06:09","start_at":"2025-07-11 14:05:00","description":"\u731c\u731c\u731c","escort":"\u4eff\u4f5b\u4ecev","is_draft":0,"location_id":"","project_id":"","location_in_id":19240,"location_out_id":19241,"status":1,"indistance":2868,"outdistance":2861,"hours_spent":"00:00:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":3338,"key":3338,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533b\u9662","client_class":1,"logo":"","sales_rep":"","salesRep":{},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[],"commentCount":{"object_id":37031,"comment":2},"attachmentRelationships":[],"locationIn":{"id":19240,"lng":"116.289129774306","lat":"39.9606467013889","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-11 14:05:00"},"locationOut":{"id":19241,"lng":"116.289424913194","lat":"39.9604771592882","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-11 14:05:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14319,"work_log_id":37031,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37031,"count":"22"},"hours_spent_display":"0\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37030,"client_id":3338,"scenario_id":1,"scenario_option_id":71,"end_at":"2025-07-11 14:03:00","created_by":1000,"created_at":"2025-07-10 16:33:27","updated_at":"2025-07-11 14:03:29","start_at":"2025-07-10 16:33:00","description":"\u597d\u60f3\u597d\u5c31\u884c","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":19230,"location_out_id":19231,"status":1,"indistance":2890,"outdistance":2870,"hours_spent":"21:30:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":71,"key":71,"name":"\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":3338,"key":3338,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533b\u9662","client_class":1,"logo":"","sales_rep":"","salesRep":{},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[],"commentCount":{"object_id":37030,"comment":5},"attachmentRelationships":[],"locationIn":{"id":19230,"lng":"116.288951551649","lat":"39.9605032009549","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-10 16:33:00"},"locationOut":{"id":19231,"lng":"116.289233669705","lat":"39.9605287000868","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-11 14:03:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14317,"work_log_id":37030,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37030,"count":"123"},"hours_spent_display":"21\u5c0f\u65f630\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37029,"client_id":2815,"scenario_id":1,"scenario_option_id":71,"end_at":"2025-07-10 10:47:00","created_by":1000,"created_at":"2025-07-10 10:25:12","updated_at":"2025-07-10 10:47:31","start_at":"2025-07-10 10:24:00","description":"\u56fd\u5149\u56fd\u5149","escort":"\u56de\u590d","is_draft":0,"location_id":"","project_id":3811,"location_in_id":19224,"location_out_id":19225,"status":1,"indistance":952,"outdistance":931,"hours_spent":"00:23:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":71,"key":71,"name":"\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3811,"key":3811,"name":"\u6ef4\u6ef4\u6253\u8f66"},"workLogContacts":[{"id":5245,"key":5245,"name":"\u674e\u4fca","department":"\u9500\u552e","job_position":"\u7ecf\u7406","mobiles":[{"id":6034,"contact_id":5245,"mobile":"18101123631","mp_open_id":""}]}],"commentCount":{"object_id":37029,"comment":2},"attachmentRelationships":[],"locationIn":{"id":19224,"lng":"116.289020996094","lat":"39.9606209309896","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-10 10:24:00"},"locationOut":{"id":19225,"lng":"116.288777398004","lat":"39.9607074652778","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-10 10:47:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14315,"work_log_id":37029,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37029,"count":"222"},"hours_spent_display":"23\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37028,"client_id":2815,"scenario_id":1,"scenario_option_id":66,"end_at":"2025-07-04 14:17:03","created_by":1000,"created_at":"2025-07-04 14:16:35","updated_at":"2025-07-04 14:17:04","start_at":"2025-07-04 14:16:27","description":"hcnnc","escort":"ncnncj","is_draft":0,"location_id":"","project_id":3805,"location_in_id":19222,"location_out_id":19223,"status":1,"indistance":968,"outdistance":968,"hours_spent":"00:00:36","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3805,"key":3805,"name":"\u54c8\u597d\u54c8\u7535\u8bdd"},"workLogContacts":[{"id":5245,"key":5245,"name":"\u674e\u4fca","department":"\u9500\u552e","job_position":"\u7ecf\u7406","mobiles":[{"id":6034,"contact_id":5245,"mobile":"18101123631","mp_open_id":""}]}],"commentCount":{"object_id":37028,"comment":2},"attachmentRelationships":[],"locationIn":{"id":19222,"lng":"116.28903","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-07-04 14:16:27"},"locationOut":{"id":19223,"lng":"116.289045","lat":"39.960427","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2025-07-04 14:17:03"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14313,"work_log_id":37028,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37027,"client_id":3337,"scenario_id":1,"scenario_option_id":66,"end_at":"2025-07-04 11:01:00","created_by":1000,"created_at":"2025-07-04 10:59:35","updated_at":"2025-07-04 11:02:00","start_at":"2025-07-04 10:59:00","description":"\u4e0d\u5403\u4e0d\u9971\u624d\u80fd\u5b8c","escort":"\u53d1\u6325\u597d","is_draft":0,"location_id":"","project_id":"","location_in_id":19216,"location_out_id":19217,"status":1,"indistance":47,"outdistance":43,"hours_spent":"00:02:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":3337,"key":3337,"name":"\u6d77\u57fa\u4f1a\u57fa\u91d1\u4f1a","client_class":80,"logo":"","sales_rep":5332,"salesRep":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[{"id":6010,"key":6010,"name":"\u6bdb\u6653\u5149","department":"","job_position":"","mobiles":[{"id":6793,"contact_id":6010,"mobile":"13355220000","mp_open_id":""}]}],"commentCount":{"object_id":37027,"comment":4},"attachmentRelationships":[],"locationIn":{"id":19216,"lng":"116.289174804688","lat":"39.9604258897569","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-04 10:59:00"},"locationOut":{"id":19217,"lng":"116.288947753906","lat":"39.9605476888021","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-07-04 11:01:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14311,"work_log_id":37027,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37027,"count":"123"},"hours_spent_display":"2\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37026,"client_id":2815,"scenario_id":1,"scenario_option_id":73,"end_at":"2025-06-25 14:07:00","created_by":5016,"created_at":"2025-06-25 14:07:28","updated_at":"2025-06-25 14:07:28","start_at":"2025-06-25 14:07:00","description":"\u4f60\u624d\u80fd\u5403","escort":"\u7ecf\u5e38\u4e0d\u80fd\u5403","is_draft":0,"location_id":"","project_id":3811,"location_in_id":19214,"location_out_id":19215,"status":1,"indistance":972,"outdistance":975,"hours_spent":"00:00:00","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3811,"key":3811,"name":"\u6ef4\u6ef4\u6253\u8f66"},"workLogContacts":[{"id":5245,"key":5245,"name":"\u674e\u4fca","department":"\u9500\u552e","job_position":"\u7ecf\u7406","mobiles":[{"id":6034,"contact_id":5245,"mobile":"18101123631","mp_open_id":""}]}],"commentCount":{"object_id":37026,"comment":3},"attachmentRelationships":[],"locationIn":{"id":19214,"lng":"116.288977864583","lat":"39.9603271484375","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-06-25 14:07:00"},"locationOut":{"id":19215,"lng":"116.289010959201","lat":"39.9603076171875","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","time":"2025-06-25 14:07:00"},"files":[],"workLogCarbonCopyRels":[{"id":15598,"work_log_id":37026,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"workLogVerifyRels":[{"id":14307,"work_log_id":37026,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37024,"client_id":"","scenario_id":1,"scenario_option_id":73,"end_at":"2025-06-24 21:56:00","created_by":1000,"created_at":"2025-06-24 21:56:33","updated_at":"2025-06-24 21:56:33","start_at":"2025-06-24 20:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":1,"indistance":"","outdistance":"","hours_spent":"01:56:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{"object_id":37024,"comment":1},"attachmentRelationships":[{"id":33143,"object_type":18,"object_id":37024,"attachment_id":24767,"attachment":{"id":24767,"key":24767,"name":"e6640989-f9b5-3726-aa96-1be4e7fbbc72","extension":"png","path":"\/vue\/attachment\/view\/e6640989-f9b5-3726-aa96-1be4e7fbbc72\/20250624215606.png","orig_name":"20250624215606.png"}}],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14302,"work_log_id":37024,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f656\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37022,"client_id":"","scenario_id":1,"scenario_option_id":73,"end_at":"2025-06-24 20:49:00","created_by":1000,"created_at":"2025-06-24 21:41:11","updated_at":"2025-06-24 21:41:11","start_at":"2025-06-24 20:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":1,"indistance":"","outdistance":"","hours_spent":"00:49:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{"object_id":37022,"comment":1},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14300,"work_log_id":37022,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"49\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37023,"client_id":"","scenario_id":1,"scenario_option_id":73,"end_at":"2025-06-24 20:00:00","created_by":1000,"created_at":"2025-06-24 21:43:20","updated_at":"2025-06-24 21:43:20","start_at":"2025-06-24 20:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":1,"indistance":"","outdistance":"","hours_spent":"00:00:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{"object_id":37023,"comment":1},"attachmentRelationships":[{"id":33141,"object_type":18,"object_id":37023,"attachment_id":24765,"attachment":{"id":24765,"key":24765,"name":"0cccc158-321d-3ddb-a0e7-4f26e1995c5f","extension":"png","path":"\/vue\/attachment\/view\/0cccc158-321d-3ddb-a0e7-4f26e1995c5f\/20250624214230.png","orig_name":"20250624214230.png"}},{"id":33142,"object_type":18,"object_id":37023,"attachment_id":24766,"attachment":{"id":24766,"key":24766,"name":"98f15dde-3b7f-3ba7-b40f-4c8b31125e93","extension":"png","path":"\/vue\/attachment\/view\/98f15dde-3b7f-3ba7-b40f-4c8b31125e93\/20250624214242.png","orig_name":"20250624214242.png"}}],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14301,"work_log_id":37023,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":15578,"client_id":"","scenario_id":1,"scenario_option_id":73,"end_at":"2025-05-28 09:00:00","created_by":5250,"created_at":"2021-06-01 11:05:00","updated_at":"2025-05-28 10:51:05","start_at":"2025-05-28 09:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":0,"indistance":"","outdistance":"","hours_spent":"00:00:00","createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{"object_id":15578,"comment":3},"attachmentRelationships":[{"id":33110,"object_type":18,"object_id":15578,"attachment_id":24738,"attachment":{"id":24738,"key":24738,"name":"312602ad-d9bc-3226-984c-549d37b2dd8a","extension":"png","path":"\/vue\/attachment\/view\/312602ad-d9bc-3226-984c-549d37b2dd8a\/20250528105048.png","orig_name":"20250528105048.png"}}],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"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","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"},{"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","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":37018,"client_id":2815,"scenario_id":3,"scenario_option_id":27,"end_at":"2025-05-12 11:22:08","created_by":1000,"created_at":"2025-05-12 11:22:15","updated_at":"2025-06-12 20:23:31","start_at":"2025-05-12 11:21:50","description":"\u98de\u98de\u98de","escort":"","is_draft":0,"location_id":"","project_id":3805,"location_in_id":19202,"location_out_id":19203,"status":1,"indistance":961,"outdistance":960,"hours_spent":"00:00:18","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":27,"key":27,"name":"\u5916\u51fa\u529e\u516c"},"scenarios":{"id":3,"key":3,"name":"\u5185\u52e4\u65e5\u5fd7"},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3805,"key":3805,"name":"\u54c8\u597d\u54c8\u7535\u8bdd"},"workLogContacts":[{"id":5245,"key":5245,"name":"\u674e\u4fca","department":"\u9500\u552e","job_position":"\u7ecf\u7406","mobiles":[{"id":6034,"contact_id":5245,"mobile":"18101123631","mp_open_id":""}]}],"commentCount":{"object_id":37018,"comment":5},"attachmentRelationships":[{"id":33124,"object_type":18,"object_id":37018,"attachment_id":24749,"attachment":{"id":24749,"key":24749,"name":"a54687cc-2a98-3827-9f3b-9109d3405640","extension":"png","path":"\/vue\/attachment\/view\/a54687cc-2a98-3827-9f3b-9109d3405640\/20250612202328.png","orig_name":"20250612202328.png"}}],"locationIn":{"id":19202,"lng":"116.288942","lat":"39.960447","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2025-05-12 11:21:50"},"locationOut":{"id":19203,"lng":"116.288945","lat":"39.960462","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2025-05-12 11:22:08"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14296,"work_log_id":37018,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{"work_log_id":37018,"count":"563"},"hours_spent_display":"0\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":37017,"client_id":3056,"scenario_id":1,"scenario_option_id":67,"end_at":"2025-05-12 10:07:14","created_by":1000,"created_at":"2025-05-12 10:07:16","updated_at":"2025-05-12 10:07:16","start_at":"2025-05-12 10:06:49","description":"\u4e0d\u4e0d\u4e0d\u4e0d","escort":"\u65a4\u65a4\u8ba1\u8f83","is_draft":0,"location_id":"","project_id":3804,"location_in_id":19196,"location_out_id":19197,"status":1,"indistance":0,"outdistance":0,"hours_spent":"00:00:25","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":3056,"key":3056,"name":"\u4e2d\u56fd\u822a\u5929","client_class":43,"logo":"","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":3804,"key":3804,"name":"\u54c8\u62c9\u54c8\u5566"},"workLogContacts":[{"id":5529,"key":5529,"name":"\u66f9\u6653","department":"","job_position":"","mobiles":[{"id":6313,"contact_id":5529,"mobile":"13501129205","mp_open_id":""}]}],"commentCount":{"object_id":37017,"comment":1},"attachmentRelationships":[],"locationIn":{"id":19196,"lng":"116.289053","lat":"39.960408","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2025-05-12 10:06:49"},"locationOut":{"id":19197,"lng":"116.289031","lat":"39.960541","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2025-05-12 10:07:14"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":14287,"work_log_id":37017,"user_id":1000,"status":1,"description":"","verify_at":"","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":1,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":20284,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-24 10:30:25') RETURNING "id"
10:30:25.358traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:30:25.358traceyii\redis\Connection::executeCommandExecuting Redis Command: SET