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

Log Messages

总计79条数据
TimeLevelCategoryMessage
 
10:29:59.518traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:29:59.518traceyii\base\Module::getModuleLoading module: debug
10:29:59.518traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:29:59.518traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:29:59.518traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:29:59.519traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.519traceyii\base\Module::getModuleLoading module: gii
10:29:59.519traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:29:59.519traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:29:59.519traceyii\web\Application::handleRequestRoute requested: 'vue/work-log/list'
10:29:59.519traceyii\base\Module::getModuleLoading module: vue
10:29:59.519infoyii\web\Session::openSession started
10:29:59.520infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:29:59.520infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:29:59.524traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.524traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:59.525traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.525traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:59.525infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:29:59.526traceyii\base\Controller::runActionRoute to run: vue/work-log/list
10:29:59.526traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.527traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:29:59.527traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\WorkLogController::actionList()
10:29:59.527traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.527traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:59.528traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.529traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.529infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:29:59.531infoyii\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"."created_by"='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:29:59.535infoyii\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"."created_by"='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 OFFSET 20
10:29:59.539infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:29:59.540infoyii\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:59.540infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
10:29:59.541infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_location" WHERE "id" IN (7689, 5553)
10:29:59.542infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (3, 7, 1, 4, 62, 5, 2, 8)
10:29:59.543infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1
10:29:59.543infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1143, 878, 51, 426, 1661, 1638, 989, 21, 876, 85)
10:29:59.544infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5295, 5087, 1001)
10:29:59.544infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 43)
10:29:59.545infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2529, 922, 1791, 1736, 2055, 1011, 1596, 931, 394)
10:29:59.550infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524)
10:29:59.553infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (2246, 1222, 2523, 2341, 3336, 2651, 1173, 3458, 2223, 3165, 2267, 1143)
10:29:59.556infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (1143, 1173, 1222, 2223, 2246, 2267, 2341, 2523, 2651, 3165, 3336, 3458)
10:29:59.557infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524)) GROUP BY "object_id"
10:29:59.579infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524))
10:29:59.581infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7831, 7832, 7833, 7834)
10:29:59.583infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (8325, 8323, 8321, 8221, 8159, 8074, 8061, 7689, 5553)
10:29:59.583infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (8326, 8324, 8322, 8320, 8222, 8160, 8075, 8062)
10:29:59.584infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524))
10:29:59.585infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524)
10:29:59.587infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524) ORDER BY "id"
10:29:59.588infoyii\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 (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524)) GROUP BY "object_id"
10:29:59.603infoyii\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 (15759, 15758, 15757, 15756, 15705, 15671, 15619, 15609, 15336, 15298, 15271, 15259, 15175, 15166, 14205, 14135, 14004, 13717, 13681, 13524)) GROUP BY "work_log_id"
10:29:59.605infoyii\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:59.608infoyii\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:59.611infoyii\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:59.614infoyii\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:59.616infoyii\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:59.619infoyii\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:59.622infoyii\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:59.624infoyii\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:59.627infoyii\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:59.629infoyii\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:59.634infoyii\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:59.636infoyii\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:59.640infoyii\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:59.643infoyii\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:59.646infoyii\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:59.648infoyii\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:59.651infoyii\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:59.654traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.654traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:59.654infoyii\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:59.658traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.658traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:29:59.658infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=8, "last_visit_at"='now()' WHERE "id"=49858
10:29:59.659infoyii\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', '{"WorkLogSearch":{"filterUser":["1001"],"has_client":"","has_project":"","status":"","is_arrive":"","description":"","period":"","filter":"","is_draft":"0"},"Filter":{"name":"end_at","sort":"DESC"},"page":"2","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":15759,"client_id":1143,"scenario_id":1,"scenario_option_id":3,"end_at":"2021-06-29 15:50:00","created_by":1001,"created_at":"2021-06-29 15:49:47","updated_at":"2021-06-29 15:54:40","start_at":"2021-06-29 15:49:45","description":"\u4f60\u597d","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":8325,"location_out_id":8326,"status":0,"indistance":10106,"outdistance":10106,"hours_spent":"00:00:15","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":1143,"key":1143,"name":"\u767e\u5ea6\u5728\u7ebf\u7f51\u7edc\u6280\u672f(\u5317\u4eac)\u6709\u9650\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":2267,"key":2267,"name":"\u5b59\u5029","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u4e13\u5458","mobiles":[{"id":2227,"contact_id":2267,"mobile":"13581907372","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[{"id":4100,"object_type":18,"object_id":15759,"attachment_id":7834,"attachment":{"id":7834,"key":7834,"name":"6697dc9c-9f95-366f-a2a9-5cc5aacee4af","extension":"jpg","path":"\/vue\/attachment\/view\/6697dc9c-9f95-366f-a2a9-5cc5aacee4af\/tmp.jpg","orig_name":"tmp.jpg"}}],"locationIn":{"id":8325,"lng":"116.289892","lat":"39.960579","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u4e2d\u56fd\u5de5\u5546\u94f6\u884c(\u4e16\u7eaa\u91d1\u6e90\u652f\u884c)","time":"2021-06-29 15:49:45"},"locationOut":{"id":8326,"lng":"116.289882","lat":"39.960587","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u4e2d\u56fd\u5de5\u5546\u94f6\u884c(\u4e16\u7eaa\u91d1\u6e90\u652f\u884c)","time":"2021-06-29 15:50:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15758,"client_id":878,"scenario_id":1,"scenario_option_id":7,"end_at":"2021-06-29 15:46:40","created_by":1001,"created_at":"2021-06-29 15:46:27","updated_at":"2021-06-29 15:47:24","start_at":"2021-06-29 15:46:14","description":"\u6d4b\u8bd5","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":8323,"location_out_id":8324,"status":0,"indistance":4841,"outdistance":4841,"hours_spent":"00:00:26","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":7,"key":7,"name":"\u62dc\u8bbf\u5382\u5546"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":878,"key":878,"name":"\u5317\u4eac\u4e09\u5feb\u5728\u7ebf\u79d1\u6280\u6709\u9650\u516c\u53f8(\u7f8e\u56e2)","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":2223,"key":2223,"name":"\u738b\u6770","department":"\u91c7\u8d2d\u7ba1\u7406\u90e8","job_position":"","mobiles":[{"id":2180,"contact_id":2223,"mobile":"18117168099","mp_open_id":""}]},{"id":3458,"key":3458,"name":"\u4ed8\u6653\u5b87","department":"\u96c6\u56e2\u91c7\u8d2d\u7ba1\u7406\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobiles":[{"id":4099,"contact_id":3458,"mobile":"13248400887","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[{"id":4099,"object_type":18,"object_id":15758,"attachment_id":7833,"attachment":{"id":7833,"key":7833,"name":"95ab46ae-5aff-3159-93b4-bda023780de7","extension":"jpg","path":"\/vue\/attachment\/view\/95ab46ae-5aff-3159-93b4-bda023780de7\/tmp.jpg","orig_name":"tmp.jpg"}}],"locationIn":{"id":8323,"lng":"116.289053","lat":"39.960283","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2021-06-29 15:46:14"},"locationOut":{"id":8324,"lng":"116.289153","lat":"39.960271","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","time":"2021-06-29 15:46:40"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"0\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15757,"client_id":51,"scenario_id":1,"scenario_option_id":3,"end_at":"2021-06-29 15:27:00","created_by":1001,"created_at":"2021-06-29 15:26:24","updated_at":"2021-06-29 15:27:58","start_at":"2021-06-29 15:26:00","description":"\u611f\u89c9\u826f\u597d","escort":"","is_draft":0,"location_id":"","project_id":2529,"location_in_id":8321,"location_out_id":8322,"status":0,"indistance":10978,"outdistance":10978,"hours_spent":"00:01:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":51,"key":51,"name":"\u6d77\u5357\u65b0\u8f6f\u8f6f\u4ef6\u6709\u9650\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":{"id":2529,"key":2529,"name":"FireEye\u8bbe\u5907\u670d\u52a1\u7eed\u4fdd\u9879\u76ee"},"workLogContacts":[{"id":1173,"key":1173,"name":"\u5f20\u4f1f\u4f1f","department":"\u5b89\u5168\u90e8","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":1174,"contact_id":1173,"mobile":"18435186585","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[{"id":4097,"object_type":18,"object_id":15757,"attachment_id":7831,"attachment":{"id":7831,"key":7831,"name":"56d2ec34-9e4c-36af-80f9-daadda051f39","extension":"png","path":"\/vue\/attachment\/view\/56d2ec34-9e4c-36af-80f9-daadda051f39\/20210629152654.png","orig_name":"20210629152654.png"}},{"id":4098,"object_type":18,"object_id":15757,"attachment_id":7832,"attachment":{"id":7832,"key":7832,"name":"fd4d5efd-48c0-3b50-ae92-6176f3cef1f5","extension":"png","path":"\/vue\/attachment\/view\/fd4d5efd-48c0-3b50-ae92-6176f3cef1f5\/20210629152704.png","orig_name":"20210629152704.png"}}],"locationIn":{"id":8321,"lng":"116.289256998698","lat":"39.9603331163194","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6(\u91d1\u6e90\u5e97)","time":"2021-06-29 15:26:00"},"locationOut":{"id":8322,"lng":"116.289145507813","lat":"39.9603106011285","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6(\u91d1\u6e90\u5e97)","time":"2021-06-29 15:27:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15756,"client_id":426,"scenario_id":1,"scenario_option_id":1,"end_at":"2021-06-29 15:20:00","created_by":1001,"created_at":"2021-06-29 15:21:16","updated_at":"2021-06-29 15:21:28","start_at":"2021-06-29 14:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":8320,"status":0,"indistance":0,"outdistance":0,"hours_spent":"01:20:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":1,"key":1,"name":"\u534f\u540c\u9ad8\u5c42\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/4c905e50-0195-38cf-82c0-0025fcf3c1b6.png","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":[],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{"id":8320,"lng":"116.28905734592","lat":"39.9604383680556","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6(\u91d1\u6e90\u5e97)","time":"2021-06-29 15:20:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f620\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15705,"client_id":426,"scenario_id":1,"scenario_option_id":3,"end_at":"2021-06-17 20:36:00","created_by":1001,"created_at":"2021-06-17 20:36:03","updated_at":"2021-06-17 20:37:07","start_at":"2021-06-17 20:35:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":922,"location_in_id":8221,"location_out_id":8222,"status":0,"indistance":32462,"outdistance":32462,"hours_spent":"00:01:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/4c905e50-0195-38cf-82c0-0025fcf3c1b6.png","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":{"id":922,"key":922,"name":"2\u53f0PA 3050\u9632\u706b\u5899\u8bbe\u5907\u65b0\u8d2d"},"workLogContacts":[{"id":1222,"key":1222,"name":"\u738b\u5d07","department":"","job_position":"","mobiles":[{"id":1239,"contact_id":1222,"mobile":"","mp_open_id":""}]},{"id":2246,"key":2246,"name":"\u90d1\u723d","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobiles":[{"id":4251,"contact_id":2246,"mobile":"18801025152","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":8221,"lng":"116.210642903646","lat":"39.7578293185764","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-06-17 20:35:00"},"locationOut":{"id":8222,"lng":"116.210658637153","lat":"39.7578287760417","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-06-17 20:36:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15671,"client_id":426,"scenario_id":1,"scenario_option_id":4,"end_at":"2021-06-12 12:29:00","created_by":1001,"created_at":"2021-06-12 12:29:01","updated_at":"2021-06-12 12:30:06","start_at":"2021-06-12 12:28:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":922,"location_in_id":8159,"location_out_id":8160,"status":0,"indistance":32510,"outdistance":32510,"hours_spent":"00:01:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/4c905e50-0195-38cf-82c0-0025fcf3c1b6.png","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":{"id":922,"key":922,"name":"2\u53f0PA 3050\u9632\u706b\u5899\u8bbe\u5907\u65b0\u8d2d"},"workLogContacts":[{"id":1222,"key":1222,"name":"\u738b\u5d07","department":"","job_position":"","mobiles":[{"id":1239,"contact_id":1222,"mobile":"","mp_open_id":""}]},{"id":2246,"key":2246,"name":"\u90d1\u723d","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobiles":[{"id":4251,"contact_id":2246,"mobile":"18801025152","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":8159,"lng":"116.210687391493","lat":"39.7573836263021","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-06-12 12:28:00"},"locationOut":{"id":8160,"lng":"116.210687391493","lat":"39.7573836263021","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-06-12 12:29:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15619,"client_id":426,"scenario_id":1,"scenario_option_id":4,"end_at":"2021-06-06 13:31:00","created_by":1001,"created_at":"2021-06-06 13:30:59","updated_at":"2021-06-06 13:32:25","start_at":"2021-06-06 13:30:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":922,"location_in_id":8074,"location_out_id":8075,"status":0,"indistance":32493,"outdistance":32493,"hours_spent":"00:01:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/4c905e50-0195-38cf-82c0-0025fcf3c1b6.png","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":{"id":922,"key":922,"name":"2\u53f0PA 3050\u9632\u706b\u5899\u8bbe\u5907\u65b0\u8d2d"},"workLogContacts":[{"id":1222,"key":1222,"name":"\u738b\u5d07","department":"","job_position":"","mobiles":[{"id":1239,"contact_id":1222,"mobile":"","mp_open_id":""}]},{"id":2246,"key":2246,"name":"\u90d1\u723d","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobiles":[{"id":4251,"contact_id":2246,"mobile":"18801025152","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":8074,"lng":"116.210649956597","lat":"39.7575499131945","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-06-06 13:30:00"},"locationOut":{"id":8075,"lng":"116.210706651476","lat":"39.7573529730903","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-06-06 13:31:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15609,"client_id":426,"scenario_id":1,"scenario_option_id":3,"end_at":"2021-06-04 12:12:00","created_by":1001,"created_at":"2021-06-04 12:12:07","updated_at":"2021-06-04 12:13:19","start_at":"2021-06-04 12:11:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":922,"location_in_id":8061,"location_out_id":8062,"status":0,"indistance":9227,"outdistance":9227,"hours_spent":"00:01:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/4c905e50-0195-38cf-82c0-0025fcf3c1b6.png","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":{"id":922,"key":922,"name":"2\u53f0PA 3050\u9632\u706b\u5899\u8bbe\u5907\u65b0\u8d2d"},"workLogContacts":[{"id":1222,"key":1222,"name":"\u738b\u5d07","department":"","job_position":"","mobiles":[{"id":1239,"contact_id":1222,"mobile":"","mp_open_id":""}]},{"id":2246,"key":2246,"name":"\u90d1\u723d","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobiles":[{"id":4251,"contact_id":2246,"mobile":"18801025152","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":8061,"lng":"116.289079861111","lat":"39.9603843858507","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6(\u91d1\u6e90\u5e97)","time":"2021-06-04 12:11:00"},"locationOut":{"id":8062,"lng":"116.289041883681","lat":"39.96041015625","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6(\u91d1\u6e90\u5e97)","time":"2021-06-04 12:12:00"},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15336,"client_id":1661,"scenario_id":1,"scenario_option_id":62,"end_at":"2021-04-17 01:15:00","created_by":1001,"created_at":"2021-04-17 12:59:55","updated_at":"2021-04-17 12:59:55","start_at":"2021-04-17 01:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":1791,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":62,"key":62,"name":"\u5ba2\u6237\u5fae\u4fe1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":43,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee"},"workLogContacts":[{"id":3165,"key":3165,"name":"\u674e\u4e1c","department":"","job_position":"","mobiles":[{"id":3441,"contact_id":3165,"mobile":"13910153114","mp_open_id":"oagch6X0Lxczsc4IcPa75yqsxq64"}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"15\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15298,"client_id":1661,"scenario_id":1,"scenario_option_id":62,"end_at":"2021-04-10 00:30:00","created_by":1001,"created_at":"2021-04-11 21:58:48","updated_at":"2021-04-11 21:58:48","start_at":"2021-04-10 00:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:30:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":62,"key":62,"name":"\u5ba2\u6237\u5fae\u4fe1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":43,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"30\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15271,"client_id":1638,"scenario_id":1,"scenario_option_id":62,"end_at":"2021-04-06 00:30:00","created_by":1001,"created_at":"2021-04-07 19:42:41","updated_at":"2021-04-07 19:42:41","start_at":"2021-04-06 00:00:00","description":"tset","escort":"","is_draft":0,"location_id":"","project_id":1736,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:30:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":62,"key":62,"name":"\u5ba2\u6237\u5fae\u4fe1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":1638,"key":1638,"name":"\u4e0a\u6d77\u5353\u5b9c\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":43,"logo":"","sales_rep":"","salesRep":{},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":1736,"key":1736,"name":"FireEye\u5b89\u5168\u9879\u76ee"},"workLogContacts":[],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"30\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15259,"client_id":"","scenario_id":1,"scenario_option_id":62,"end_at":"2021-04-05 05:15:00","created_by":1001,"created_at":"2021-04-05 07:22:19","updated_at":"2021-04-07 19:52:28","start_at":"2021-04-05 05:00:00","description":"","escort":"","is_draft":0,"location_id":7689,"project_id":"","location_in_id":7689,"location_out_id":"","status":0,"indistance":"","outdistance":"","hours_spent":"00:15:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{"id":7689,"geolocation":"(116.210486653646,39.7576283094618)","created_by":1001,"address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","created_at":"2021-04-05 07:22:20","updated_at":"2021-04-05 07:21:00"},"scenarioOption":{"id":62,"key":62,"name":"\u5ba2\u6237\u5fae\u4fe1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{"object_id":15259,"comment":1},"attachmentRelationships":[],"locationIn":{"id":7689,"lng":"116.210486653646","lat":"39.7576283094618","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2021-04-05 07:21:00"},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"15\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15175,"client_id":989,"scenario_id":1,"scenario_option_id":3,"end_at":"2021-03-26 10:15:00","created_by":1001,"created_at":"2021-03-26 15:03:58","updated_at":"2021-03-26 15:03:58","start_at":"2021-03-26 10:00:00","description":"\u8be2\u95ee\u56de\u6b3e\u65e5\u671f","escort":"","is_draft":0,"location_id":"","project_id":2055,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","client_class":47,"logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":2055,"key":2055,"name":"\u4eac\u4e1c2020-CCO\u4f53\u7cfb\u4fe1\u606f\u5b89\u5168\u90e8-\u5bb9\u5668\u91c7\u8d2d\u9879\u76ee"},"workLogContacts":[{"id":3336,"key":3336,"name":"\u90ce\u5fd7\u65b0","department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobiles":[{"id":4527,"contact_id":3336,"mobile":"11111111111","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"15\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":15166,"client_id":989,"scenario_id":1,"scenario_option_id":5,"end_at":"2021-03-25 10:30:00","created_by":1001,"created_at":"2021-03-25 12:46:39","updated_at":"2021-03-25 12:46:39","start_at":"2021-03-25 10:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":2055,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:30:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":5,"key":5,"name":"\u5ba2\u6237\u9001\u793c"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","client_class":47,"logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":2055,"key":2055,"name":"\u4eac\u4e1c2020-CCO\u4f53\u7cfb\u4fe1\u606f\u5b89\u5168\u90e8-\u5bb9\u5668\u91c7\u8d2d\u9879\u76ee"},"workLogContacts":[{"id":3336,"key":3336,"name":"\u90ce\u5fd7\u65b0","department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobiles":[{"id":4527,"contact_id":3336,"mobile":"11111111111","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"30\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":14205,"client_id":21,"scenario_id":1,"scenario_option_id":7,"end_at":"2020-09-08 00:15:00","created_by":1001,"created_at":"2020-09-08 10:40:17","updated_at":"2021-03-18 08:28:40","start_at":"2020-09-08 00:00:00","description":"test","escort":"","is_draft":0,"location_id":"","project_id":1011,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":7,"key":7,"name":"\u62dc\u8bbf\u5382\u5546"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":21,"key":21,"name":"\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u6709\u9650\u516c\u53f8(\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\u3001\u9f99\u82af\u4e2d\u79d1\u5357\u4eac\u6280\u672f\u6709\u9650\u516c\u53f8)\uff08EDA\uff09","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":{"id":1011,"key":1011,"name":"\u9632\u706b\u5899"},"workLogContacts":[{"id":2523,"key":2523,"name":"\u5f20\u6aac","department":"","job_position":"","mobiles":[{"id":2782,"contact_id":2523,"mobile":"15810250976","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"15\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":14135,"client_id":989,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-08-31 00:15:00","created_by":1001,"created_at":"2020-08-31 20:15:55","updated_at":"2020-08-31 20:15:55","start_at":"2020-08-31 00:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":1596,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":2,"key":2,"name":"\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","client_class":47,"logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":1596,"key":1596,"name":"\u4eac\u4e1c2019-Palo Alto PA-5250\u5e94\u7528\u68c0\u6d4b\u4e0e\u9632\u5fa1\u8f6f\u4ef6\u4ea7\u54c1\u7eed\u4fdd"},"workLogContacts":[{"id":2651,"key":2651,"name":"\u5f20\u6d69","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d-\u9632\u706b\u5899","mobiles":[{"id":2744,"contact_id":2651,"mobile":"15910699559","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"15\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":14004,"client_id":876,"scenario_id":1,"scenario_option_id":4,"end_at":"2020-08-05 00:15:00","created_by":1001,"created_at":"2020-08-11 10:51:26","updated_at":"2020-08-11 10:51:26","start_at":"2020-08-05 00:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":931,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":876,"key":876,"name":"\u5317\u4eac\u6709\u7af9\u5c45\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8(\u4eca\u65e5\u5934\u6761)","client_class":47,"logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":931,"key":931,"name":"NGFW\u91c7\u8d2d\u9879\u76ee"},"workLogContacts":[{"id":2341,"key":2341,"name":"\u8d75\u78ca","department":"","job_position":"","mobiles":[{"id":2323,"contact_id":2341,"mobile":"15001096295","mp_open_id":"oagch6ZWfztAlFvXEHNNCQWC7EwI"}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"15\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":13717,"client_id":"","scenario_id":1,"scenario_option_id":8,"end_at":"2020-04-23 12:00:00","created_by":1001,"created_at":"2020-04-23 18:53:21","updated_at":"2020-04-26 11:13:48","start_at":"2020-04-23 09:00:00","description":"","escort":"","is_draft":0,"location_id":5553,"project_id":"","location_in_id":5553,"location_out_id":"","status":0,"indistance":"","outdistance":"","hours_spent":"03:00:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{"id":5553,"geolocation":"(116.210775282118,39.7573744032118)","created_by":1001,"address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","created_at":"2020-04-23 18:53:21","updated_at":"2020-04-23 18:53:00"},"scenarioOption":{"id":8,"key":8,"name":"\u534f\u540c\u5382\u5546\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":5553,"lng":"116.210775282118","lat":"39.7573744032118","address":"\u5317\u4eac\u5e02\u623f\u5c71\u533a\u6021\u548c\u8def\u9760\u8fd1\u957f\u9633\u534a\u5c9b","time":"2020-04-23 18:53:00"},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"3\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":13681,"client_id":"","scenario_id":1,"scenario_option_id":8,"end_at":"2020-04-12 09:30:00","created_by":1001,"created_at":"2020-04-12 11:30:29","updated_at":"2020-04-12 11:30:51","start_at":"2020-04-12 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:30:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":8,"key":8,"name":"\u534f\u540c\u5382\u5546\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{},"project":{},"workLogContacts":[],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"30\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"},{"id":13524,"client_id":85,"scenario_id":1,"scenario_option_id":8,"end_at":"2020-03-11 10:00:00","created_by":1001,"created_at":"2020-03-11 14:25:25","updated_at":"2020-03-11 14:25:25","start_at":"2020-03-11 09:00:00","description":"","escort":"","is_draft":0,"location_id":"","project_id":394,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"location":{},"scenarioOption":{"id":8,"key":8,"name":"\u534f\u540c\u5382\u5546\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","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":394,"key":394,"name":"\u89c6\u9891\u4f1a\u8bae"},"workLogContacts":[{"id":1143,"key":1143,"name":"1","department":"\u4fe1\u606f\u5316","job_position":"","mobiles":[]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":77,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-24 10:29:59') RETURNING "id"
10:29:59.662traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:29:59.662traceyii\redis\Connection::executeCommandExecuting Redis Command: SET