ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68677b799e903: POST https://beta.jinchangxiao.com/vue/work-log/of-project at 2025-07-04 02:58:01 pm by 114.254.1.137

Log Messages

总计79条数据
TimeLevelCategoryMessage
 
14:58:01.648traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:58:01.648traceyii\base\Module::getModuleLoading module: debug
14:58:01.649traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:58:01.649traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:58:01.649traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:58:01.649traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.650traceyii\base\Module::getModuleLoading module: gii
14:58:01.650traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:58:01.650traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:58:01.650traceyii\web\Application::handleRequestRoute requested: 'vue/work-log/of-project'
14:58:01.650traceyii\base\Module::getModuleLoading module: vue
14:58:01.650infoyii\web\Session::openSession started
14:58:01.651infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:58:01.651infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:58:01.659traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.661traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:58:01.662traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.662traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:58:01.663infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:58:01.665traceyii\base\Controller::runActionRoute to run: vue/work-log/of-project
14:58:01.665traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.666traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:58:01.666traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\WorkLogController::actionOfProject()
14:58:01.666infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1018'
14:58:01.667traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.668traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:58:01.668traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.669traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:58:01.669traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.670traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.672infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
14:58:01.673infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, s.end_at - s.start_at AS hours_spent FROM "a57be577deb434"."tbl_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr" ON rvr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_carbon_copy_rels" "ccr" ON ccr.work_log_id = s.id WHERE ("s"."project_id"=1018) AND ("is_draft"=FALSE) GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC) "c"
14:58:01.682infoyii\db\Command::querySELECT s.*, s.end_at - s.start_at AS hours_spent FROM "a57be577deb434"."tbl_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr" ON rvr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_carbon_copy_rels" "ccr" ON ccr.work_log_id = s.id WHERE ("s"."project_id"=1018) AND ("is_draft"=FALSE) GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC LIMIT 20
14:58:01.690infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003)
14:58:01.691infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1003))
14:58:01.692infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
14:58:01.693infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_location" WHERE "id" IN (6561, 6503, 6494, 6296, 5759, 5257)
14:58:01.699infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (2, 3, 4)
14:58:01.700infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1
14:58:01.701infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
14:58:01.701infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:58:01.702infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=1
14:58:01.702infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=1018
14:58:01.703infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392)
14:58:01.710infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (2319, 2413, 2493, 2917, 3645)
14:58:01.713infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (2319, 2413, 2493, 2917, 3645)
14:58:01.716infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392)) GROUP BY "object_id"
14:58:01.747infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392))
14:58:01.750infoyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (6561, 6503, 6494, 6296, 5759, 5257)
14:58:01.750infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392))
14:58:01.753infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392)
14:58:01.756infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392) ORDER BY "id"
14:58:01.758infoyii\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 (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392)) GROUP BY "object_id"
14:58:01.781infoyii\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 (17033, 14609, 14312, 14235, 14202, 14024, 13903, 13789, 13776, 13744, 13727, 13695, 13688, 13659, 13635, 13600, 13544, 13509, 13402, 13392)) GROUP BY "work_log_id"
14:58:01.785infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.790infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.795infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.799infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.804infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.808infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.812infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.816infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.820infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.826infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.830infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.835infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.840infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.845infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.850infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.854infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.860infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.864infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.868infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.872infoyii\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, 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, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))
14:58:01.878traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.879traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:58:01.881infoyii\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/of-project', '{"page":"1","id":"1018","web_access_token":"tld3jO0KyGCnBfJLTA8332fg4dJPv04V"}', '{"code":2000,"result":{"list":[{"id":17033,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2021-09-28 00:45:00","created_by":1001,"created_at":"2021-09-28 10:20:52","updated_at":"2021-09-28 10:20:52","start_at":"2021-09-28 00:00:00","description":"\u65b9\u6848\u6c9f\u901a\u5b8c\u6210","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:45: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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":3645,"key":3645,"name":"\u5218\u5fd7\u521a(\u6d4b\u8bd5)","department":"","job_position":"","mobiles":[{"id":4431,"contact_id":3645,"mobile":"15764340998","mp_open_id":"oagch6XdH-5gyziy6jk7m_Cz_Fu8"}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"45\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":true,"can_create_project":true,"bgcolor":"#89c541","can_view":true},{"id":14609,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-10-26 14:15:00","created_by":1003,"created_at":"2020-10-31 10:04:08","updated_at":"2020-10-31 10:04:08","start_at":"2020-10-26 14:00:00","description":"\u76ee\u7684\uff1a\u9879\u76ee\u6536\u6b3e\u8d28\u4fdd\u91d1\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\uff0c\u8fbe\u6210\u51c6\u786e\u56de\u6b3e\u65f6\u95f4\u8282\u70b9\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u5bb4\u8bf7\u80e1\uff0c\u7b54\u8c22\u548c\u5bfb\u627e\u65b0\u7684\u5408\u4f5c\u673a\u4f1a\u70b9\u3002","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":14312,"client_id":982,"scenario_id":1,"scenario_option_id":3,"end_at":"2020-09-17 15:45:00","created_by":1003,"created_at":"2020-09-17 11:30:35","updated_at":"2020-09-20 18:07:05","start_at":"2020-09-17 15:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u8d28\u4fdd\u91d1\u8fd4\u8fd8\u6d41\u7a0b\u3002\u7ed3\u679c\uff1a\u786e\u8ba4\u8d44\u4ea7\u63d0\u4f9b\u7684\u6e05\u5355\uff0c\u5b8c\u5584\u540e\u63d0\u4ea4\u5ba2\u6237\u4f7f\u7528\u90e8\u95e8\u7b7e\u5b57\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\u80e1\u5de5\u7b7e\u5b57\u6d41\u7a0b\u3002","escort":"","is_draft":0,"location_id":6561,"project_id":1018,"location_in_id":6561,"location_out_id":"","status":0,"indistance":17275,"outdistance":0,"hours_spent":"00:45:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{"id":6561,"geolocation":"(116.354057888455,39.9805259874132)","created_by":1003,"address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5b66\u9662\u8def\u9760\u8fd1\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662","created_at":"2020-09-17 11:30:35","updated_at":"2020-09-17 11:30:00"},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":6561,"lng":"116.354057888455","lat":"39.9805259874132","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5b66\u9662\u8def\u9760\u8fd1\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662","time":"2020-09-17 11:30:00"},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"45\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":14235,"client_id":982,"scenario_id":1,"scenario_option_id":3,"end_at":"2020-09-09 14:00:00","created_by":1003,"created_at":"2020-09-09 14:01:30","updated_at":"2020-09-13 17:11:36","start_at":"2020-09-09 13:30:00","description":"\u76ee\u7684\uff1a\u63d0\u4ea4\u53d1\u7968\uff0c\u8d44\u4ea7\u6c9f\u901a\u56de\u6b3e\u65f6\u95f4\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\u3002\u9884\u8ba12\u5468\u5185\u4ed8\u6b3e\u3002\u7136\u540e\u53d1\u8d77\u900010%\u8d28\u4fdd\u91d1\u6d41\u7a0b\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u7d27\u56de\u6b3e\uff0c\u51c6\u5907\u9000\u8d28\u4fdd\u91d1\u6240\u9700\u8981\u8d44\u6599\u3002","escort":"","is_draft":0,"location_id":6503,"project_id":1018,"location_in_id":6503,"location_out_id":"","status":0,"indistance":17203,"outdistance":0,"hours_spent":"00:30:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{"id":6503,"geolocation":"(116.355967610677,39.9802707248264)","created_by":1003,"address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u5317\u8def\u9760\u8fd1\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662","created_at":"2020-09-09 14:01:30","updated_at":"2020-09-09 14:01:00"},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":6503,"lng":"116.355967610677","lat":"39.9802707248264","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u5317\u8def\u9760\u8fd1\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662","time":"2020-09-09 14:01:00"},"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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":14202,"client_id":982,"scenario_id":1,"scenario_option_id":3,"end_at":"2020-09-08 11:00:00","created_by":1003,"created_at":"2020-09-08 10:20:12","updated_at":"2020-09-13 17:08:37","start_at":"2020-09-08 10:00:00","description":"\u76ee\u7684\uff1a\u7ec8\u9a8c\u62a5\u544a\u7ec6\u8282\u6c9f\u901a\uff0c\u76d6\u7ae0\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\u3002\u5df2\u7ecf\u5c06\u5168\u90e8\u8d44\u6599\u63d0\u4ea4\u5b8c\u6210\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u5ba2\u6237\u53d1\u8d77\u9a8c\u6536\u4ed8\u6b3e\u6d41\u7a0b","escort":"","is_draft":0,"location_id":6494,"project_id":1018,"location_in_id":6494,"location_out_id":"","status":0,"indistance":17176,"outdistance":0,"hours_spent":"01:00:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{"id":6494,"geolocation":"(116.35563422309,39.9807430013021)","created_by":1003,"address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u5317\u8def\u9760\u8fd1\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662","created_at":"2020-09-08 10:20:12","updated_at":"2020-09-08 10:20:00"},"scenarioOption":{"id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":6494,"lng":"116.35563422309","lat":"39.9807430013021","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u5317\u8def\u9760\u8fd1\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662","time":"2020-09-08 10:20:00"},"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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":14024,"client_id":982,"scenario_id":1,"scenario_option_id":4,"end_at":"2020-08-14 13:30:00","created_by":1003,"created_at":"2020-08-14 12:18:01","updated_at":"2020-08-16 19:07:20","start_at":"2020-08-14 12:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u9a8c\u6536\u65f6\u95f4\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\uff0c\u5df2\u7ecf\u63d0\u4ea4\u7533\u8bf7\uff0c30\u5929\u5de6\u53f3\u65f6\u95f4\u9a8c\u5b8c\uff0c\u518d\u8fc715\u5929\u5de6\u53f3\u7ed3\u6b3e\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\u63a8\u52a8\u7ec8\u9a8c","escort":"","is_draft":0,"location_id":6296,"project_id":1018,"location_in_id":6296,"location_out_id":"","status":0,"indistance":16918,"outdistance":0,"hours_spent":"01:30:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{"id":6296,"geolocation":"(116.36682562934,39.9777555338542)","created_by":1003,"address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u8def2\u53f7(\u8fd1\u7261\u4e39\u56ed\u5730\u94c1\u7ad9\u897f\u5317\u53e3)","created_at":"2020-08-14 12:18:01","updated_at":"2020-08-14 12:17:00"},"scenarioOption":{"id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":6296,"lng":"116.36682562934","lat":"39.9777555338542","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u8def2\u53f7(\u8fd1\u7261\u4e39\u56ed\u5730\u94c1\u7ad9\u897f\u5317\u53e3)","time":"2020-08-14 12:17:00"},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f630\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13903,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-07-07 14:15:00","created_by":1003,"created_at":"2020-07-12 23:21:20","updated_at":"2020-07-12 23:21:20","start_at":"2020-07-07 14:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u51c6\u5907\u5de1\u68c0\u4fdd\u969c\u9879\u76ee\u9a8c\u6536\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u5b89\u6392\u5de5\u7a0b\u5e08\u534f\u8c03\u5382\u5546\u5b9e\u65bd\u5de1\u68c0","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13789,"client_id":982,"scenario_id":1,"scenario_option_id":4,"end_at":"2020-05-26 13:30:00","created_by":1003,"created_at":"2020-05-26 11:56:28","updated_at":"2020-05-31 18:20:45","start_at":"2020-05-26 12:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u7ec8\u9a8c\u7ec6\u8282\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\u30027\u6708\u4efd\u63d0\u4ea4\u7533\u8bf7\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1b\u8ddf\u8fdb\u9879\u76ee\u5b9e\u65bd\u5de1\u68c0\uff0c\u57288\u6708\u4efd\u4e4b\u524d\u4fdd\u969c\u5b89\u5168\u8fd0\u884c\u3002","escort":"","is_draft":0,"location_id":5759,"project_id":1018,"location_in_id":5759,"location_out_id":"","status":0,"indistance":26990,"outdistance":0,"hours_spent":"01:30:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{"id":5759,"geolocation":"(116.160867241753,40.064404296875)","created_by":1003,"address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u9ad8\u91cc\u638c\u8def\u9760\u8fd1\u4e2d\u5173\u6751\u7fe0\u6e56\u79d1\u6280\u56ed\u4e91\u4e2d\u5fc3","created_at":"2020-05-26 11:56:28","updated_at":"2020-05-26 11:56:00"},"scenarioOption":{"id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":5759,"lng":"116.160867241753","lat":"40.064404296875","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u9ad8\u91cc\u638c\u8def\u9760\u8fd1\u4e2d\u5173\u6751\u7fe0\u6e56\u79d1\u6280\u56ed\u4e91\u4e2d\u5fc3","time":"2020-05-26 11:56:00"},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f630\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13776,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-05-18 10:45:00","created_by":1003,"created_at":"2020-05-24 19:35:15","updated_at":"2020-05-24 19:35:15","start_at":"2020-05-18 10:30:00","description":"\u76ee\u7684\uff1a\u8c08\u7ec8\u9a8c\u6536\u5c3e\u6b3e\u3002\u7ed3\u679c\uff1a\u7535\u8bdd\u91cc\u4e0d\u80af\u8bf4\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u4e0b\u5468\u53bb\u5835\u4ed6","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13744,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-04-29 10:15:00","created_by":1003,"created_at":"2020-05-05 21:45:09","updated_at":"2020-05-05 21:45:09","start_at":"2020-04-29 10:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u7ec8\u6b3e\u9a8c\u6536\u65f6\u95f4\u53ca\u6761\u4ef6\u3002\u7ed3\u679c\uff1a1-3\u4e2a\u6708\u65f6\u95f4\u5185\u505a\u7ec8\u9a8c\u62a5\u544a\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\uff0c\u534f\u8c03\u5382\u5546\u8d44\u6e90\u63a8\u8fdb\u9a8c\u6536","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13727,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-04-23 15:15:00","created_by":1003,"created_at":"2020-04-26 17:14:32","updated_at":"2020-04-26 17:14:32","start_at":"2020-04-23 15:00:00","description":"\u76ee\u7684\uff1a\u7535\u8bdd\u6c9f\u901a\u4e8c\u671f\u6b3e\u6c47\u6b3e\u65f6\u95f4\u3002\u7ed3\u679c\uff1a\u6240\u6709\u624b\u7eed\u5df2\u7ecf\u9f50\u4e86\uff0c\u4ed8\u6b3e\u7533\u8bf7\u5df2\u7ecf\u5f00\u59cb\uff0c\u9884\u8ba14\u4e2a\u5de5\u4f5c\u65e5\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\uff0c\u50ac\u6b3e","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]},{"id":2917,"key":2917,"name":"\u738b\u7acb\u7fa4","department":"\u8d44\u4ea7\u90e8","job_position":"\u79d1\u5458","mobiles":[{"id":3051,"contact_id":2917,"mobile":"13391869900","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13695,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-04-15 14:15:00","created_by":1003,"created_at":"2020-04-19 16:43:46","updated_at":"2020-04-19 16:43:46","start_at":"2020-04-15 14:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u5f00\u7968\u53ca\u9a8c\u6536\u62a5\u544a\u7ec6\u8282\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\u4ed8\u6b3e\u65f6\u95f4\u3002","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13688,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-04-06 14:15:00","created_by":1003,"created_at":"2020-04-12 18:39:26","updated_at":"2020-04-12 18:39:26","start_at":"2020-04-06 14:00:00","description":"\u76ee\u7684\uff1a\u7ea6\u76d6\u7ae0\u65f6\u95f4\u3002\u7ed3\u679c\uff1a\u672c\u5468\u4e94\u524d\u786e\u8ba4\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\u9a8c\u6536\u6587\u6863\u76d6\u7ae0\uff0c\u5f00\u53d1\u7968\u3002","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13659,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-04-02 14:15:00","created_by":1003,"created_at":"2020-04-06 20:38:30","updated_at":"2020-04-06 20:38:30","start_at":"2020-04-02 14:00:00","description":"\u76ee\u7684\uff1a\u6c9f\u901a\u51fa\u6f14\u62a5\u544a\u5ba1\u6838\u7ed3\u679c\uff0c\u50ac\u6b3e\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\uff0c\u4e0b\u5468\u5f00\u53d1\u7968\u3002\u6574\u7406\u76f8\u5173\u8d44\u6599\u5feb\u9012\u7ed9\u80e1\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb\u56de\u6b3e\u65f6\u95f4\u3002","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13635,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-03-24 09:15:00","created_by":1003,"created_at":"2020-03-29 20:55:41","updated_at":"2020-03-29 20:55:41","start_at":"2020-03-24 09:00:00","description":"\u76ee\u7684\uff1a\u50ac\u9a8c\u6536\u6587\u6863\u63d0\u4ea4\u3002\u7ed3\u679c\uff1a\u91cd\u65b0\u8c03\u6574\u6e05\u5355\u683c\u5f0f\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u8ddf\u8fdb","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13600,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-03-17 10:15:00","created_by":1003,"created_at":"2020-03-22 18:57:00","updated_at":"2020-03-22 18:57:00","start_at":"2020-03-17 10:00:00","description":"\u76ee\u7684\uff1a\u50ac\u6b3e\u3002\u7ed3\u679c\uff1a\u672a\u5b8c\u6210\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a \u5835\u95e8\u53e3","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13544,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-03-10 10:15:00","created_by":1003,"created_at":"2020-03-15 18:46:40","updated_at":"2020-03-15 18:46:40","start_at":"2020-03-10 10:00:00","description":"\u76ee\u7684\uff1a\u62a5\u544a\u7ec6\u8282\u6c9f\u901a\u3002\u7ed3\u679c\uff1a\u5b8c\u6210\u3002\u521d\u7248\u62a5\u544a\u5b8c\u6210\uff0c\u7ef4\u62a4\u7ec4\u4eba\u5458\u786e\u8ba4\u540e\u53d1\u7ed9\u9886\u5bfc\u5ba1\u6279\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u9047\u95ee\u9898\u53ca\u65f6\u53cd\u9988\u5ba2\u6237","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13509,"client_id":982,"scenario_id":1,"scenario_option_id":2,"end_at":"2020-03-03 14:15:00","created_by":1003,"created_at":"2020-03-08 20:47:07","updated_at":"2020-03-08 20:47:07","start_at":"2020-03-03 14:00:00","description":"\u76ee\u7684\uff1a1\uff0c\u63d0\u4ea4\u96c6\u6210\u5546\u4e0d\u5206\u9a8c\u6536\u62a5\u544a\u30022.\u4e86\u89e3\u9662\u91cc\u89c6\u9891\u4f1a\u8bae\u4f7f\u7528\u60c5\u51b5\u3002\u7ed3\u679c\uff1a\u73b0\u9636\u6bb5\u5728\u5bb6\u529e\u516c\uff0c\u9a8c\u6536\u7684\u6d41\u7a0b\u5ef6\u671f\u3002\u56e0\u7814\u53d1\u90e8\u5206\u8fd8\u672a\u5b8c\u6210\uff0c\u89c6\u9891\u672a\u5728\u9662\u5185\u63a8\u5e7f\u4f7f\u7528\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u534f\u8c03\u5382\u5546\u914d\u5408\u7814\u53d1\uff0c\u63d0\u901f\u9a8c\u6536\u3002","escort":"","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"00:15:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]},{"id":2413,"key":2413,"name":"\u5d14\u5174\u5b87","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2570,"contact_id":2413,"mobile":"13488771584","mp_open_id":""}]},{"id":2493,"key":2493,"name":"\u6f58\u5fd7\u52c7","department":"\u4fe1\u606f\u5316","job_position":"\u4e3b\u4efb","mobiles":[{"id":2545,"contact_id":2493,"mobile":"13801078717","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":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13402,"client_id":982,"scenario_id":1,"scenario_option_id":4,"end_at":"2020-01-14 18:30:00","created_by":1003,"created_at":"2020-01-14 18:08:21","updated_at":"2020-01-19 12:19:57","start_at":"2020-01-14 17:00:00","description":"\u76ee\u7684\uff1a\u9a8c\u6536\u6c9f\u901a\u3002\u7ed3\u679c\uff1a\u65b9\u6848\u7ec6\u8282\u8fd8\u9700\u8981\u8c03\u6574\u548c\u52a0\u7d27\u3002\u9884\u8ba1\u8282\u540e\u4e0a\u73ed\u5f00\u59cb\u6574\u7406\u6c47\u62a5\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u6682\u65e0","escort":"","is_draft":0,"location_id":5257,"project_id":1018,"location_in_id":5257,"location_out_id":"","status":0,"indistance":16556,"outdistance":0,"hours_spent":"01:30:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{"id":5257,"geolocation":"(116.366332465278,39.9818733723958)","created_by":1003,"address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u5317\u8def\u9760\u8fd1\u5065\u5eb7\u667a\u8c37","created_at":"2020-01-14 18:08:21","updated_at":"2020-01-14 18:08:00"},"scenarioOption":{"id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{"id":5257,"lng":"116.366332465278","lat":"39.9818733723958","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u82b1\u56ed\u5317\u8def\u9760\u8fd1\u5065\u5eb7\u667a\u8c37","time":"2020-01-14 18:08:00"},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f630\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false},{"id":13392,"client_id":982,"scenario_id":1,"scenario_option_id":3,"end_at":"2020-01-07 11:30:00","created_by":1003,"created_at":"2020-01-12 19:50:52","updated_at":"2020-01-12 19:50:52","start_at":"2020-01-07 09:30:00","description":"\u76ee\u7684\uff1a\u6e05\u5355\u6c9f\u901a\uff0c\u63a8\u8fdb\u9a8c\u6536\u3002\u7ed3\u679c\uff1a\u6e05\u5355\u786e\u8ba4\uff0c\u529f\u80fd\u6e05\u5355\u4e24\u4e2a\u90e8\u5206\uff0c\u6211\u53f8\u6e05\u5355\u9884\u8ba1\u4e0b\u5468\u4e94\u5b8c\u6210\u63d0\u4ea4\u3002\u5382\u5546\u90e8\u5206\u5df2\u7ecf\u6c9f\u901a\u5382\u5546\u9500\u552e\u8d1f\u8d23\u63d0\u4f9b\u3002\u9884\u8ba1\u4e8c\u6708\u521d\u63d0\u4f9b\u5b8c\u6210\u3002\u4e0b\u4e00\u6b65\u8ba1\u5212\uff1a\u7ee7\u7eed\u8ddf\u8fdb\u3002","escort":"\u8346\u626c","is_draft":0,"location_id":"","project_id":1018,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"02:00:00","createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848"},"workLogContacts":[{"id":2319,"key":2319,"name":"\u80e1\u6c5f\u6d77","department":"\u4fe1\u606f\u5316","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":2546,"contact_id":2319,"mobile":"18511285337","mp_open_id":""}]}],"commentCount":{},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"2\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541","can_view":false}],"can_create":true,"pagenation":{"totalcount":53,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 14:58:01') RETURNING "id"
14:58:01.884traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:58:01.885traceyii\redis\Connection::executeCommandExecuting Redis Command: SET