ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a4f39efcde0d: POST https://beta.jinchangxiao.com/vue/client/get-edit at 2026-07-09 02:04:31 pm by 114.244.130.61

Log Messages

总计125条数据
TimeLevelCategoryMessage
 
14:04:31.835traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:04:31.835traceyii\base\Module::getModuleLoading module: debug
14:04:31.836traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:04:31.843traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:04:31.844traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:04:31.844traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.845infotime tracing start1783577071845093888
14:04:31.845traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:04:31.845traceyii\web\Application::handleRequestRoute requested: 'vue/client/get-edit'
14:04:31.845traceyii\base\Module::getModuleLoading module: vue
14:04:31.847infoyii\web\Session::openSession started
14:04:31.848infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:04:31.848infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:04:31.850traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.850traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:31.851infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:04:31.853traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.853traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:31.854infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:04:31.855traceyii\base\Controller::runActionRoute to run: vue/client/get-edit
14:04:31.856traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.859traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:04:31.859traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ClientController::actionGetEdit()
14:04:31.859traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.861traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.863infoyii\db\Command::querySELECT c.*, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE c.sales_rep END AS sales_rep, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(sl.end_at) as last_contact, max(arrive.end_at) as last_arrive, cc.notice_days AS notice_days, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cc.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cc.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cc.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cc.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 190::float END) / cc.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 190::float END) / cc.visit_base::float) END) ELSE 20 END) + (CASE WHEN cc.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cc.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cc.cooperate_base END) ELSE 20 END) + (CASE WHEN cc.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cc.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cc.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cc.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cc.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cc.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE ("c"."id"='2128') AND ("deleted"=FALSE) GROUP BY "c"."id", "cc"."id"
14:04:31.870traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.870traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:31.872infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=6
14:04:31.874infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47
14:04:31.874infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=1
14:04:31.875infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=20
14:04:31.876infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
14:04:31.877infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
14:04:31.878infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2128
14:04:31.881infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (164, 171, 181, 157, 185, 191, 317, 369, 349)) ORDER BY "sort"
14:04:31.882infoyii\db\Command::querySELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id"=2128)
14:04:31.884infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
14:04:31.885infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
14:04:31.886infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
14:04:31.887infoyii\db\Command::querySELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id"=2128) GROUP BY "client_id"
14:04:31.888infoyii\db\Command::querySELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id"=2128 GROUP BY "client_id"
14:04:31.891infoyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("client_id"=2128) GROUP BY "client_id"
14:04:31.893infoyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."client_id"=2128) GROUP BY "c"."client_id"
14:04:31.903traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:31.904traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:31.904infoyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."client_id"=2128) GROUP BY "c"."client_id"
14:04:31.908infoyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("client_id"=2128) GROUP BY "client_id"
14:04:31.909infoyii\db\Command::querySELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id"=2128) GROUP BY "client_id"
14:04:31.914infoyii\db\Command::querySELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id"=2128
14:04:31.926infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id"=2128
14:04:31.943infoyii\db\Command::querySELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2
14:04:31.946infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1011)
14:04:31.947infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (5976, 5975, 5835, 4829, 4586, 4100, 3904)
14:04:31.949infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5976, 5975, 5835, 4829, 4586, 4100, 3904)
14:04:31.953infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (184, 189, 226, 1, 2, 5, 165, 172, 349, 340, 377, 369, 164, 142, 139, 138, 140)) ORDER BY "sort"
14:04:31.954infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5976, 5975, 5835, 4829, 4586, 4100, 3904)
14:04:31.954infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (184, 189, 226, 1, 2, 5, 165, 172, 349, 340, 377, 369, 164, 142, 139, 138, 140)) ORDER BY "sort"
14:04:31.955infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id"=2128) GROUP BY "object_id"
14:04:31.993infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=10) AND (("remind_user_id"=1001) AND ("is_read"=FALSE)) AND ("object_id"=2128) GROUP BY "object_id"
14:04:32.029infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id"=2128
14:04:32.031infoyii\db\Command::querySELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id"=4409)
14:04:32.038infoyii\db\Command::querySELECT s.id, client_id, project_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2026-06-25')) AND ((("is_public"=1) AND ("created_by" != 1001)) OR ("created_by"=1001) OR ("ccr"."user_id"=1001)) AND ("s"."client_id"=2128) ORDER BY set_top_at DESC nulls last, sort ASC, CASE when is_complete = true then complete_at END desc, CASE when is_complete = false then end_at END asc, end_at DESC
14:04:32.042traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:32.043traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:32.043infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1001)
14:04:32.044infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5087, 1001))
14:04:32.045infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (18169, 18269, 18360, 15750, 17831, 18270, 18271, 18281, 18301) ORDER BY "created_at" DESC
14:04:32.050infoyii\db\Command::querySELECT "id", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4109, 3854, 2775, 3559, 4132, 4133, 3695)
14:04:32.050infoyii\db\Command::querySELECT "id", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"='3') AND ("client_id"=2128)
14:04:32.052infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE (("c"."sales_rep" IN (1001, 5049, 5500, 5301, 5499, 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."id"=2128))
14:04:32.054infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createClientContact
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createSchedule
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Operator
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 人力资源
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 软件开发
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateSchedule
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
14:04:32.055traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:04:32.058infoyii\db\Command::querySELECT final.id, final.name, final.sales_rep, final.status3_budgets, final.status3_profits, final.status3_count, final.status3_pct, final.status1_budgets, final.status1_count, final.status2_budgets, final.status2_count, final.pscount, final.ircount, (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, (now() - created_at) AS sales_rep_time, final.created_at, final.work_time, final.work_count, final.last_bargain_date, final.reimbursement_amount, final.points, CASE WHEN final.cooperated IS NULL THEN false ELSE true END AS cooperated, final.client_industry, final.client_industry_id FROM (SELECT c.id, c.name, c.sales_rep, c.created_at, CASE WHEN tmp1.budgets IS NULL THEN 0 ELSE tmp1.budgets END AS status3_budgets, CASE WHEN tmp1.profits IS NULL THEN 0 ELSE tmp1.profits END AS status3_profits, CASE WHEN tmp1.budgets IS NULL OR tmp1.budgets = 0 THEN 0 ELSE tmp1.profits / tmp1.budgets END AS status3_pct, CASE WHEN tmp1.count IS NULL THEN 0 ELSE tmp1.count END AS status3_count, CASE WHEN tmp2.budgets IS NULL THEN 0 ELSE tmp2.budgets END AS status1_budgets, CASE WHEN tmp2.count IS NULL THEN 0 ELSE tmp2.count END AS status1_count, CASE WHEN tmp3.budgets IS NULL THEN 0 ELSE tmp3.budgets END AS status2_budgets, CASE WHEN tmp3.count IS NULL THEN 0 ELSE tmp3.count END AS status2_count, CASE WHEN tmp4.pre_sales_counts IS NULL THEN 0 ELSE tmp4.pre_sales_counts END AS pscount, CASE WHEN tmp5.implement_counts IS NULL THEN 0 ELSE tmp5.implement_counts END AS ircount, CASE WHEN tmp4.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp4.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp5.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp5.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp6.sales_rep_time IS NOT NULL THEN EXTRACT(EPOCH FROM tmp6.sales_rep_time )/3600 ELSE 0 END AS sales_rep_time, CASE WHEN tmp7.work_times IS NOT NULL THEN tmp7.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp7.work_count IS NOT NULL THEN tmp7.work_count ELSE 0 END AS work_count, CASE WHEN tmp8.reimbursement_amount IS NOT NULL THEN tmp8.reimbursement_amount ELSE 0 END AS reimbursement_amount, tmp1.last_bargain_date, CASE WHEN tmp9.points IS NOT NULL THEN tmp9.points ELSE 0 END AS points, tmp1.count AS cooperated, ci.name as client_industry, ci.id as client_industry_id, ct.name as client_type, ct.id as client_type_id FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT sub1.client_id, sum(sub1.budget) AS budgets, sum(sub1.budget * sub1.profit_pct / 100) AS profits, max(sub1.bargain_date) AS last_bargain_date, count(sub1.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget", "p"."profit_pct", "p"."bargain_date" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status = 3) "sub1" GROUP BY "sub1"."client_id") "tmp1" ON tmp1.client_id = c.id LEFT JOIN (SELECT sub2.client_id, sum(sub2.budget) AS budgets, count(sub2.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget", "p"."profit_pct", "p"."bargain_date" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status = 1) "sub2" GROUP BY "sub2"."client_id") "tmp2" ON tmp2.client_id = c.id LEFT JOIN (SELECT sub3.client_id, sum(sub3.budget) AS budgets, count(sub3.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget", "p"."profit_pct", "p"."bargain_date" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status = 2) "sub3" GROUP BY "sub3"."client_id") "tmp3" ON tmp3.client_id = c.id LEFT JOIN (SELECT sub4.client_id, count(sub4.id) as pre_sales_counts, sum(sub4.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "ps"."client_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" WHERE "ps"."is_draft"=FALSE) "sub4" GROUP BY "sub4"."client_id") "tmp4" ON tmp4.client_id = c.id LEFT JOIN (SELECT sub5.client_id, count(sub5.id) as implement_counts, sum(sub5.implement_time) as implement_times FROM (SELECT "ir"."id", "ir"."client_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" WHERE "ir"."is_draft"=FALSE) "sub5" GROUP BY "sub5"."client_id") "tmp5" ON tmp5.client_id = c.id LEFT JOIN (SELECT csrr.client_id, csrr.sales_rep, (now() - csrr.start_at) as sales_rep_time FROM "a57be577deb434"."tbl_client_sales_rep_rels" "csrr" WHERE "id" IN (SELECT max(csrrs.id) FROM "a57be577deb434"."tbl_client_sales_rep_rels" "csrrs" WHERE csrrs.end_at is null GROUP BY "csrrs"."client_id")) "tmp6" ON tmp6.client_id = c.id and tmp6.sales_rep = c.sales_rep LEFT JOIN (SELECT sub7.client_id, count(sub7.id) as work_count, sum(sub7.work_time) as work_times FROM (SELECT "wl"."id", "wl"."client_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub7" GROUP BY "sub7"."client_id") "tmp7" ON tmp7.client_id = c.id LEFT JOIN (SELECT sub8.client_id, sum(sub8.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."client_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub8" GROUP BY "sub8"."client_id") "tmp8" ON tmp8.client_id = c.id LEFT JOIN (SELECT sub9.client_id, sum(sub9.points) as points FROM (SELECT "c"."client_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub9" GROUP BY "sub9"."client_id") "tmp9" ON tmp9.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_industries" "ci" ON "ci"."id" = "c"."client_industry" LEFT JOIN "a57be577deb434"."tbl_client_types" "ct" ON "ct"."id" = "c"."client_type") "final" WHERE "final"."id"=2128
14:04:32.075infoyii\db\Command::querySELECT SUM(uncollected) FROM (SELECT sc.*, scp.collected, (sc.amount - scp.collected) as uncollected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN (SELECT t0.id AS contract_id, t0.erp_settle_amount AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."id"=2128) GROUP BY "sc"."id", "scp"."collected" ORDER BY "signed_at" DESC) "sub"
14:04:32.080infoyii\db\Command::querySELECT product_type_id, product_type_id as key, name, sum(budget) as sum_budget, sum(budget * pct / 100) as sum_profit FROM "a57be577deb434"."tbl_project_product_types" "pt" WHERE "project_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("client_id"=2128)) GROUP BY "product_type_id", "name"
14:04:32.083infoyii\db\Command::querySELECT product_type_id, product_type_id as key, name, count(it.id) as value FROM "a57be577deb434"."tbl_implement_product_types" "it" WHERE "implement_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_implement_records" WHERE ("is_draft"=FALSE) AND ("client_id"=2128)) GROUP BY "product_type_id", "name"
14:04:32.086infoyii\db\Command::querySELECT w.scenario_option_id, w.scenario_option_id as key, wso.name, count(w.id) as value FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND ("w"."scenario_id"=1) AND ("w"."client_id"=2128) GROUP BY "w"."scenario_option_id", "wso"."name"
14:04:32.088traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:32.088traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:32.089infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (1001, 5049, 5500, 5301, 5499, 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("user_status"='1') AND ("client_lock"=FALSE) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
14:04:32.091infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE ("is_delete"=FALSE) OR ("id"=6) ORDER BY "order"
14:04:32.092infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE ("is_delete"=FALSE) OR ("id"=47) ORDER BY "order"
14:04:32.092infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order"
14:04:32.093infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE ("is_delete"=FALSE) OR ("id"=20) ORDER BY "order"
14:04:32.095traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:32.095traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:32.096infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("user_id"=1001) AND ("object_type"=10) AND ("object_id"='2128')
14:04:32.096traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:32.097traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:32.097infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_visit_object_histories" ("user_id", "object_type", "object_id", "last_visit_at") VALUES (1001, 10, 2128, 'now()') RETURNING "id"
14:04:32.102infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_visit_object_histories" WHERE "user_id"=1001 ORDER BY "last_visit_at" DESC LIMIT 10
14:04:32.102infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("id" NOT IN (207842, 207841, 207840, 207839, 207838, 207837, 207836, 207831, 207835, 207834)) AND ("user_id"=1001)
14:04:32.104infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/client/get-edit', '{"id":"2128","web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":{"model":{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjkjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-19 21:44:13","updated_at":"2026-07-07 12:02:51","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-12-19 21:44:13","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":3,"case_implement_count":10,"is_overdue_remind":false,"from_contact":"","tax_no":"","is_public":1,"lost_contact_days":"131.9434243661","last_arrive_days":"","last_contact":"2026-02-27 15:26:00","last_arrive":"","notice_days":30,"score":"56","workingAddress":"","clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","client_lock":false,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"clientFrom":{"id":157,"key":157,"name":"\u670b\u53cb\u4ecb\u7ecd"},"unCloseCases":[{"id":9222,"client_id":2128},{"id":9230,"client_id":2128},{"id":9245,"client_id":2128},{"id":9259,"client_id":2128}],"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"workLogCount":{"client_id":2128,"count":81},"caseCount":{"client_id":2128,"count":41},"salesTimeCount":"","implementTimeCount":{"client_id":2128,"sum":"118.734166666667","times":"19"},"presalesTimeCount":{"client_id":2128,"sum":"24.0416666666667","times":"17"},"engineerTimeCount":"","reimbursementAmountSum":{"client_id":2128,"sum":"9552.10"},"addresses":[],"contacts":[{"id":5976,"name":"\u5f20\u667a\u666e","email":"","pinyin_shortcut":"zzp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2024-12-30 12:51:20","updated_at":"2024-12-30 12:51:20","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"zhi","pinyin3":"pu","pinyin4":"","namecut1":"\u5f20","namecut2":"\u667a","namecut3":"\u666e","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6764,"contact_id":5976,"mobile":"13611367526","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":5975,"name":"\u738b\u745b","email":"","pinyin_shortcut":"wy","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2024-12-30 12:42:02","updated_at":"2024-12-30 12:42:02","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"ying","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u745b","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6763,"contact_id":5975,"mobile":"13910272351","mp_open_id":""}],"contactKeyRoles":[{"id":138,"key":138,"name":"Coach"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":5835,"name":"\u674e\u5965","email":"","pinyin_shortcut":"la","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2024-07-24 17:57:43","updated_at":"2024-07-24 17:57:43","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"ao","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u5965","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6628,"contact_id":5835,"mobile":"15611040178","mp_open_id":"oagch6ftRot5zf0OI7cNmofZzqwc"}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":4829,"name":"\u4efb\u52c7\u6797","email":"","pinyin_shortcut":"ryl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2023-09-21 15:03:25","updated_at":"2023-09-21 15:03:25","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ren","pinyin2":"yong","pinyin3":"lin","pinyin4":"","namecut1":"\u4efb","namecut2":"\u52c7","namecut3":"\u6797","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5624,"contact_id":4829,"mobile":"18501342809","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":4586,"name":"\u80e1\u6c49","email":"","pinyin_shortcut":"hh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2023-04-19 11:33:39","updated_at":"2023-04-19 11:33:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"hu","pinyin2":"han","pinyin3":"","pinyin4":"","namecut1":"\u80e1","namecut2":"\u6c49","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5396,"contact_id":4586,"mobile":"13371628199","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":4100,"name":"\u6768\u5929\u9038","email":"","pinyin_shortcut":"yty","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":1011,"created_at":"2022-08-17 17:44:26","updated_at":"2022-08-17 17:44:26","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yang","pinyin2":"tian","pinyin3":"yi","pinyin4":"","namecut1":"\u6768","namecut2":"\u5929","namecut3":"\u9038","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":4922,"contact_id":4100,"mobile":"13601366951","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":3904,"name":"\u738b\u6d77\u6d9b","email":"","pinyin_shortcut":"wht","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2128,"supplier_id":"","created_by":5087,"created_at":"2022-03-01 21:21:41","updated_at":"2022-03-04 17:08:50","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"hai","pinyin3":"tao","pinyin4":"","namecut1":"\u738b","namecut2":"\u6d77","namecut3":"\u6d9b","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":4722,"contact_id":3904,"mobile":"13911355557","mp_open_id":"oagch6dDBuq_SmumFXebOclM-Ri8"}],"contactKeyRoles":[],"contactAttitude":""}],"commentCount":{},"unreadComments":{},"fromContact":"","workingAddresses":[{"id":4409,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a:\u822a\u5929\u4e09\u9662(\u5357\u95e8)","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u4e91\u5c97\u8857\u9053\u822a\u5929\u4e09\u9662\uff08\u5357\u95e8\uff09","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.160504,39.811278)","created_by":1001,"created_at":"2026-04-15 09:54:24","updated_at":"2026-04-15 09:54:24","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.160504","lat":"39.811278"}],"schedules":[{"id":18169,"client_id":2128,"project_id":4109,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u95ee\u9898\n\u76ee\u7684\uff1a\u786e\u8ba4\u95ee\u9898\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u738b\u6d77\u6d9b\u8001\u5e08","complete_at":"","start_at":"","end_at":"2026-07-30 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":1,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":20849,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:36:40","created_at_display":"03-22 19:36"},{"id":20652,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:06:04","created_at_display":"03-15 20:06"},{"id":20508,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-09 00:07:23","created_at_display":"03-09 00:07"},{"id":20417,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u786e\u8ba4\u670d\u52a1\u5668\u914d\u7f6e \u4e0a\u5468\u603b\u7ed3\uff1a\u670d\u52a1\u5668\u5df2\u62a5\u4ef7 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-01 23:49:13","created_at_display":"03-01 23:49"},{"id":19889,"schedule_id":18169,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u62dc\u8bbf\u738b\u8001\u5e08\uff0c\u6d4b\u8bd5\u524d\u9700\u8981\u91c7\u8d2d\u786c\u4ef6 12\u53f0\u56fd\u4ea7\u670d\u52a1\u5668 \u672c\u5468\u8ba1\u5212\uff1a\u786e\u8ba4\u670d\u52a1\u5668\u914d\u7f6e","created_at":"2026-01-25 22:12:59","created_at_display":"01-25 22:12"}],"project":{"id":4109,"name":"\u865a\u62df\u684c\u9762\u5efa\u8bbe-K","project_status":2,"budget":"516000","collected":"0"},"schedule_status":0,"complete_at_display":"","complete_at_display2":"","end_at_display":"07-30 00:00","end_at_display2":"","start_at_display":"","is_overdue":false,"can_report":false,"can_update":true},{"id":18269,"client_id":2128,"project_id":3854,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u63a8\u52a8\u9879\u76ee\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u4efb\u8001\u5e08\u3002","complete_at":"","start_at":"","end_at":"2026-12-31 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":1,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":20858,"schedule_id":18269,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:45:03","created_at_display":"03-22 19:45"},{"id":20655,"schedule_id":18269,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:13:03","created_at_display":"03-15 20:13"},{"id":20501,"schedule_id":18269,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-08 23:51:01","created_at_display":"03-08 23:51"}],"project":{"id":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","project_status":3,"budget":"977642823","collected":"0"},"schedule_status":0,"complete_at_display":"","complete_at_display2":"","end_at_display":"12-31 00:00","end_at_display2":"","start_at_display":"","is_overdue":false,"can_report":false,"can_update":true},{"id":18360,"client_id":2128,"project_id":3854,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u95ee\u9898","complete_at":"","start_at":"","end_at":"","created_by":1001,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":1,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"scheduleDescriptions":[],"project":{"id":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","project_status":3,"budget":"977642823","collected":"0"},"schedule_status":0,"complete_at_display":"","complete_at_display2":"","end_at_display":"","end_at_display2":"","start_at_display":"","is_overdue":false,"can_report":true,"can_update":true},{"id":15750,"client_id":2128,"project_id":2775,"schedule_title":"\u76ee\u7684\uff1a\u5b89\u88c5\u76d1\u63a7\u70b9\uff0c\u5e2e\u7528\u6237\u90e8\u7f72\u7f51\u7edc\u5176\u4ed6\u76d1\u63a7\u70b9\uff0c\u8ba9\u7528\u6237\u628a\u8f85\u52a9\u529f\u80fd\u7528\u8d77\u6765\u3002\n\u52a8\u4f5c\uff1a\u8282\u540e\u7ea6\u4efb\u8001\u5e08\u5b89\u88c5\u90e8\u7f72\u3002","complete_at":"","start_at":"","end_at":"2025-05-31 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":2,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":10706,"schedule_id":15750,"description":"\u4e0a\u5468\u7533\u8bf7\u6c38\u4e45\u6388\u6743\uff0c\u672c\u5468\u5e2e\u52a9\u4efb\u8001\u5e08\u5728\u65b0\u8bbe\u5907\u4e0a\u91cd\u65b0\u90e8\u7f72\u4e00\u904d\uff0c\u9879\u76ee\u4ea4\u5e95\u57f9\u8bad\u3002","created_at":"2024-12-08 23:43:06","created_at_display":"2024-12-08 23:43"},{"id":9638,"schedule_id":15750,"description":"\u4e0a\u5468\u4ece\u65b0\u7533\u8bf7\u6388\u6743\u7801\uff0c\u672c\u5468\u65e0\u3002","created_at":"2024-09-29 23:02:59","created_at_display":"2024-09-29 23:02"},{"id":9255,"schedule_id":15750,"description":"\u7528\u6237\u4e0d\u7740\u6025\u7528 \uff0c\u76ee\u524d\u9879\u76ee\u591a\u90fd \u5806\u4e00\u5757\u4e86\u987e\u4e0d\u4e0a ","created_at":"2024-08-05 00:02:11","created_at_display":"2024-08-05 00:02"},{"id":9103,"schedule_id":15750,"description":"7\u670830\u53f7\u56de\u5168\u6b3e","created_at":"2024-07-08 08:23:42","created_at_display":"2024-07-08 08:23"},{"id":8644,"schedule_id":15750,"description":"6\u670830\u53f7\u524d\u6536\u6b3e","created_at":"2024-05-26 21:25:27","created_at_display":"2024-05-26 21:25"},{"id":8301,"schedule_id":15750,"description":"\u5e73\u53f0\u95ee\u9898\u6ca1\u89e3\u51b3\uff0c5\u6708\u4efd\u7ed3\u6b3e\u3002","created_at":"2024-04-29 00:24:08","created_at_display":"2024-04-29 00:24"},{"id":8076,"schedule_id":15750,"description":"4\u6708\u5e95\u7ed3\u6b3e","created_at":"2024-04-08 18:47:59","created_at_display":"2024-04-08 18:47"},{"id":7992,"schedule_id":15750,"description":"\u6388\u6743\u5df2\u7ecf\u5230\u671f\uff0c\u4e0b\u5468\u7533\u8bf7\u6388\u6743\u3002","created_at":"2024-03-31 23:38:30","created_at_display":"2024-03-31 23:38"},{"id":7742,"schedule_id":15750,"description":"\u7cfb\u7edf\u51fa\u95ee\u9898\uff0c\u8054\u7cfb\u5382\u5546\u4fee\u590d\u3002","created_at":"2024-03-17 15:48:00","created_at_display":"2024-03-17 15:48"},{"id":7643,"schedule_id":15750,"description":"\u4e0b\u5468\u7ea6\u5177\u4f53\u65f6\u95f4\u5b89\u88c5\u76d1\u63a7\u70b9 \u3002","created_at":"2024-03-11 03:39:32","created_at_display":"2024-03-11 03:39"},{"id":7240,"schedule_id":15750,"description":"\u7ed9\u4e86\u4e34\u65f6\u6388\u6743\uff0c\u52303\u670830\u53f7\u5230\u3002","created_at":"2024-01-21 22:40:18","created_at_display":"2024-01-21 22:40"},{"id":7199,"schedule_id":15750,"description":"\u5e74\u524d\u4e0d\u80fd\u90e8\u7f72\u4e86\uff0c\u540c\u65f6\u8d22\u52a1\u8981\u6c42\u628a\u627f\u5151\u6362\u6210\u73b0\u91d1\u7ed3\u8d26\u3002","created_at":"2024-01-14 23:31:21","created_at_display":"2024-01-14 23:31"},{"id":7156,"schedule_id":15750,"description":"\u6388\u6743\u5ef6\u671f\u52303\u6708\u5e95\u3002","created_at":"2024-01-07 23:00:30","created_at_display":"2024-01-07 23:00"},{"id":6990,"schedule_id":15750,"description":"\u5e74\u5e95\u4e8b\u60c5\u592a\u591a\uff0c\u9a8c\u6536\u5355\u5df2\u7ecf\u7b7e\u5b57\u4e0d\u803d\u8bef\u4ed8\u6b3e\u3002","created_at":"2023-12-17 23:15:28","created_at_display":"2023-12-17 23:15"},{"id":6863,"schedule_id":15750,"description":"\u6d4b\u8bc4\u987e\u4e0d\u4e0a\u3002","created_at":"2023-12-03 22:09:39","created_at_display":"2023-12-03 22:09"},{"id":6632,"schedule_id":15750,"description":"\u7528\u6237\u586b\u5199\u8d44\u6599\u9636\u6bb5\u3002","created_at":"2023-11-12 18:36:16","created_at_display":"2023-11-12 18:36"},{"id":6492,"schedule_id":15750,"description":"\u4e0b\u5468\u7ea6\u5b89\u88c5\u76d1\u63a7\u70b9\u3002","created_at":"2023-10-28 15:58:07","created_at_display":"2023-10-28 15:58"},{"id":6336,"schedule_id":15750,"description":"\u5206\u4fdd\u6d4b\u8bc4\u6bd4\u8f83\u5fd9\uff0c\u518d\u7b49\u7b49\u3002","created_at":"2023-10-15 19:52:04","created_at_display":"2023-10-15 19:52"}],"project":{"id":2775,"name":"\u8fd0\u7ef4\u5e73\u53f0-k","project_status":3,"budget":"260000","collected":"260000"},"schedule_status":2,"complete_at_display":"","complete_at_display2":"","end_at_display":"2025-05-31 00:00","end_at_display2":"","start_at_display":"","is_overdue":true,"can_report":false,"can_update":true},{"id":17831,"client_id":2128,"project_id":3559,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u7b7e\u8ba2\u5408\u540c\n\u76ee\u7684\uff1a\u7b7e\u8ba2\u5408\u540c\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5f20\u8001\u5e08\u3002","complete_at":"","start_at":"","end_at":"2025-07-07 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":2,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":14990,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u63d0\u4ea4\u8bbe\u8ba1\u65b9\u6848\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u7533\u8bf7\u7b2c\u4e8c\u7b14\u6b3e\u3002","created_at":"2025-07-13 23:29:50","created_at_display":"2025-07-13 23:29"},{"id":14794,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u4e0a\u95e8\u53bb\u7528\u6237\u673a\u623f\u5b9e\u5730\u8003\u5bdf\u4e86\u89e3\u7269\u7406\u4f4d\u7f6e\u3002\u672c\u5468\u8ba1\u5212\uff1a\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u7f16\u5199\u8bbe\u8ba1\u65b9\u6848\u8bc4\u5ba1\u6750\u6599\u3002","created_at":"2025-07-06 22:29:54","created_at_display":"2025-07-06 22:29"},{"id":14711,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u5b8c\u6210\u4e00\u5929\u5de5\u4f5c\u7ad9\u4ea4\u4ed8\u3002\u672c\u5468\u8ba1\u5212\uff1a\u7ed9\u7528\u6237\u5f00\u8054\u60f3AI\u6d4b\u8bd5\u73af\u5883","created_at":"2025-06-30 05:31:52","created_at_display":"2025-06-30 05:31"},{"id":14550,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3 \uff1a\u8ddf\u6768 \u603b\u62dc\u8bbf\u51af\u4e3b\u4efb \u674e\u5965 \u5f20\u667a\u666e\u3002\u672c\u5468\u8ba1\u5212\uff1a\u5e2e\u7528\u6237\u5148\u4ea4\u4ed8\u4e00\u53f0\u5de5\u4f5c\u7ad9\uff0c\u540c\u65f6\u786e\u8ba4\u8054\u60f3\u6210\u672c\u5e76\u4e0b\u5355\u3002","created_at":"2025-06-22 23:52:17","created_at_display":"2025-06-22 23:52"},{"id":14374,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u534e\u8baf\u8ddf\u6240\u91cc\u5408\u540c\u5df2\u7ecf\u7b7e\u8ba2\u3002\u672c\u5468\u8ba1\u5212\uff1a\u8ddf\u5382\u5546\u5171\u540c\u62dc\u8bbf\u4fe1\u606f\u4e2d\u5fc3\u51af\u4e3b\u4efb\uff0c\u660e\u786e\u6280\u672f\u65b9\u6848\u3002","created_at":"2025-06-15 23:21:01","created_at_display":"2025-06-15 23:21"},{"id":14285,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u6280\u672f\u534f\u8bae\u521d\u7a3f\u5df2\u7ecf\u63d0\u4ea4\uff0c\u7b49\u5f85\u7528\u6237\u53cd\u9988\u3002\u672c\u5468\u8ba1\u5212\uff1a\u50ac\u4fc3\u534e\u8baf\u5408\u540c\u76d6\u7ae0\uff0c\u548c\u5b8c\u6210\u8ba2\u8d27\u3002","created_at":"2025-06-08 23:39:42","created_at_display":"2025-06-08 23:39"},{"id":14030,"schedule_id":17831,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u7528\u6237\u5408\u540c\u5df2\u7ecf\u76d6\u7ae0 \uff0c\u672c\u5468\u8ba1\u5212\uff1a\u8ddf\u8fdb\u6280\u672f\u534f\u8bae\u7b7e\u8ba2\u53ca\u8ba2\u8d27\u4e8b\u5b9c\u3002","created_at":"2025-06-02 18:57:35","created_at_display":"2025-06-02 18:57"},{"id":13859,"schedule_id":17831,"description":"\u4e0a\u5468\u786e\u8ba4\u4e2d\u6807\uff0c\u672c\u5468\u7b7e\u5408\u540c\u3002","created_at":"2025-05-25 16:27:23","created_at_display":"2025-05-25 16:27"}],"project":{"id":3559,"name":"\u56fe\u5f62\u8bbe\u8ba1\u4e0e\u4eff\u771f\u8ba1\u7b97\u4e00\u4f53\u5316\u5e73\u53f0-K","project_status":5,"budget":"6345580","collected":"0"},"schedule_status":2,"complete_at_display":"","complete_at_display2":"","end_at_display":"2025-07-07 00:00","end_at_display2":"","start_at_display":"","is_overdue":true,"can_report":false,"can_update":true},{"id":18270,"client_id":2128,"project_id":4132,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u786e\u8ba4\u914d\u7f6e\u5e76\u62a5\u4ef7\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u9093\u4e3b\u4efb","complete_at":"","start_at":"","end_at":"2026-03-12 09:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":2,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":20844,"schedule_id":18270,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u62dc\u8bbf\u7528\u6237 \u4e0a\u5468\u603b\u7ed3\uff1a\u62dc\u8bbf\u9093\u5904\u957f\uff0c\u5218\u603b \u674e\u5965\uff0c\u4e86\u89e3\u7528\u6237\u9700\u6c42 \u672c\u5468\u8ba1\u5212\uff1a\u6839\u636e\u7528\u6237\u9700\u6c42\u5236\u5b9a\u843d\u5730\u65b9\u6848\u3002","created_at":"2026-03-22 19:30:29","created_at_display":"03-22 19:30"},{"id":20647,"schedule_id":18270,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u7f16\u8f91\u62a5\u4ef7\u5355\u62a5\u914d\u7f6e\u53ca\u4ef7\u683c \u4e0a\u5468\u603b\u7ed3\uff1a\u5df2\u62a5\u4ef7 \u672c\u5468\u8ba1\u5212\uff1a\u62dc\u8bbf\u7528\u6237","created_at":"2026-03-15 20:01:31","created_at_display":"03-15 20:01"},{"id":20506,"schedule_id":18270,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u4fe1\u606f\u4e2d\u5fc3\u4e3b\u4efb\u9ad8\u5ea6\u91cd\u89c6\uff0c\u5e0c\u671b\u6211\u4eec\u627e\u5230\u597d\u4ef7\u683c\u597d\u8d27\u6e90\u3002\u672c\u5468\u8ba1\u5212\uff1a\u7f16\u8f91\u62a5\u4ef7\u5355\u62a5\u914d\u7f6e\u53ca\u4ef7\u683c","created_at":"2026-03-09 00:05:21","created_at_display":"03-09 00:05"}],"project":{"id":4132,"name":"AI\u670d\u52a1\u5668\u91c7\u8d2d","project_status":2,"budget":"5500000","collected":"0"},"schedule_status":2,"complete_at_display":"","complete_at_display2":"","end_at_display":"03-12 09:00","end_at_display2":"","start_at_display":"","is_overdue":true,"can_report":false,"can_update":true},{"id":18271,"client_id":2128,"project_id":4133,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u7ed9\u7528\u6237\u62a5\u4ef7\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5f20\u8001\u5e08","complete_at":"","start_at":"","end_at":"2026-03-21 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":2,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":20853,"schedule_id":18271,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u62dc\u8bbf\u7528\u6237 \u4e0a\u5468\u603b\u7ed3\uff1a\u62dc\u8bbf\u9879\u76ee\u4e3b\u8981\u8d1f\u8d23\u4eba\u4fe1\u606f\u4e2d\u5fc3\u9093\u4e3b\u4efb \u5f20\u8001\u5e08 \u6768\u8001\u5e08\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:40:06","created_at_display":"03-22 19:40"},{"id":20653,"schedule_id":18271,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a \u7ee7\u7eed\u8ddf\u8fdb\u9879\u76ee \u4e0a\u5468\u603b\u7ed3\u7535\u8bdd\u6c9f\u901a\u8fdb\u5ea6 \u672c\u5468\u8ba1\u5212\uff1a\u62dc\u8bbf\u7528\u6237","created_at":"2026-03-15 20:11:49","created_at_display":"03-15 20:11"},{"id":20509,"schedule_id":18271,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u8054\u60f3 \u6d6a\u6f6e \u66d9\u5149\u5df2\u7ed9\u7528\u6237\u62a5\u4ef7 \u672c\u5468\u8ba1\u5212\uff1a \u7ee7\u7eed\u8ddf\u8fdb\u9879\u76ee","created_at":"2026-03-09 00:15:49","created_at_display":"03-09 00:15"}],"project":{"id":4133,"name":"\u5e94\u7528\u7cfb\u7edf\u670d\u52a1\u5668\u91c7\u8d2d-K","project_status":2,"budget":"4350000","collected":"0"},"schedule_status":2,"complete_at_display":"","complete_at_display2":"","end_at_display":"03-21 00:00","end_at_display2":"","start_at_display":"","is_overdue":true,"can_report":false,"can_update":true},{"id":18281,"client_id":2128,"project_id":3695,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5218\u5b81","complete_at":"","start_at":"","end_at":"2026-03-31 15:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":2,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":20874,"schedule_id":18281,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5218\u5b81\u786e\u8ba4\u672c\u6708\u4ed8\u6b3e\u8fdb\u5ea6","created_at":"2026-03-22 19:54:02","created_at_display":"03-22 19:54"},{"id":20667,"schedule_id":18281,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u50ac\u6b3e \u4e0a\u5468\u603b\u7ed3\uff1a\u672c\u6708\u6700\u597d\u7ed3\u679c\u6536\u56de90% \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:35:46","created_at_display":"03-15 20:35"}],"project":{"id":3695,"name":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3-K","project_status":3,"budget":"631660","collected":"600077"},"schedule_status":2,"complete_at_display":"","complete_at_display2":"","end_at_display":"03-31 15:00","end_at_display2":"","start_at_display":"","is_overdue":true,"can_report":false,"can_update":true},{"id":18301,"client_id":2128,"project_id":"","schedule_title":"\u63a8\u52a8\u5ba2\u60c5\u5173\u7cfb\uff1a","complete_at":"","start_at":"","end_at":"2026-05-31 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":2,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":20897,"schedule_id":18301,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u62dc\u8bbf\u7528\u6237 \u4e0a\u5468\u603b\u7ed3 \uff1a\u62dc\u8bbf\u9093\u4e3b\u4efb \u80e1\u4e3b\u4efb \u5218\u603b\u5e08 \u674e\u5965\u8001\u5e08\u5f20\u8001\u5e08\u738b\u6d77\u6d9b \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 20:15:50","created_at_display":"03-22 20:15"},{"id":20686,"schedule_id":18301,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u65b0\u9886\u5bfc \u4e0a\u5468\u603b\u7ed3\uff1a\u5df2\u8054\u7cfb \u672c\u5468\u8ba1\u5212\uff1a\u62dc\u8bbf\u7528\u6237","created_at":"2026-03-15 21:02:34","created_at_display":"03-15 21:02"}],"project":{},"schedule_status":2,"complete_at_display":"","complete_at_display2":"","end_at_display":"05-31 00:00","end_at_display2":"","start_at_display":"","is_overdue":true,"can_report":false,"can_update":true}],"cooperatedProjects":[{"id":2882,"client_id":2128},{"id":3695,"client_id":2128},{"id":2775,"client_id":2128},{"id":3854,"client_id":2128}],"unread":0,"lost_contact_days_display":"4\u4e2a\u6708\u524d","last_arrive_days_display":"","bgcolor":"#EB13C3","overdue_display":"\u903e\u671f102\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f1653\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"cooperated":true,"counts":{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5087,"status3_budgets":"979124483","status3_profits":"245073950.440000000000","status3_count":4,"status3_pct":25.03,"status1_budgets":"0","status1_count":0,"status2_budgets":"11366000","status2_count":4,"pscount":17,"ircount":19,"service_time":"142.78","service_count":36,"sales_rep_time":"4\u5e746\u4e2a\u670820\u5929","created_at":"2021-12-19 21:44:13","work_time":0,"work_count":0,"last_bargain_date":"2026-06-05","reimbursement_amount":"9552.10","points":"2960","cooperated":true,"client_industry":"\u5176\u4ed6","client_industry_id":20,"sales_rep_display":"\u5218\u5fae","uncollected":"977674406"},"budgetCounts":[{"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum_budget":"977589191","sum_profit":"244397297.75","y":99.84},{"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","sum_budget":"568521","sum_profit":"239631.6015","y":0.06},{"product_type_id":85,"key":85,"name":"\u7f51\u7edc","sum_budget":"590000.00","sum_profit":"275294","y":0.06},{"product_type_id":22,"key":22,"name":"\u670d\u52a1","sum_budget":"260000.00","sum_profit":"121706","y":0.03},{"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","sum_budget":"63139","sum_profit":"26613.0885","y":0.01},{"product_type_id":23,"key":23,"name":"\u793c\u54c1","sum_budget":"53588","sum_profit":"13397","y":0.01},{"product_type_id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907","sum_budget":"44","sum_profit":"11","y":0}],"implementTimes":[{"product_type_id":69,"key":69,"name":"\u5907\u4efd","value":10,"y":47.62},{"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","value":3,"y":14.29},{"product_type_id":85,"key":85,"name":"\u7f51\u7edc","value":3,"y":14.29},{"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","value":2,"y":9.52},{"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","value":1,"y":4.76},{"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","value":1,"y":4.76},{"product_type_id":22,"key":22,"name":"\u670d\u52a1","value":1,"y":4.76}],"salesTimes":[{"scenario_option_id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8","value":23,"y":28.4},{"scenario_option_id":2,"key":2,"name":"\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a","value":16,"y":19.75},{"scenario_option_id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb","value":16,"y":19.75},{"scenario_option_id":72,"key":72,"name":"\u6316\u6398\u5546\u673a","value":9,"y":11.11},{"scenario_option_id":71,"key":71,"name":"\u62dc\u8bbf\u5ba2\u6237","value":6,"y":7.41},{"scenario_option_id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a","value":3,"y":3.7},{"scenario_option_id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1","value":3,"y":3.7},{"scenario_option_id":70,"key":70,"name":"\u4ea7\u54c1\u57f9\u8bad","value":2,"y":2.47},{"scenario_option_id":5,"key":5,"name":"\u5ba2\u6237\u9001\u793c","value":1,"y":1.23},{"scenario_option_id":9,"key":9,"name":"\u552e\u524d\u6280\u672f\u4ea4\u6d41","value":1,"y":1.23},{"scenario_option_id":69,"key":69,"name":"\u5382\u5546\u5408\u4f5c","value":1,"y":1.23}],"extra":0,"can_view_implement":true,"can_view_work_log":true,"can_view_poejct":true},"options":{"Clients[sales_rep]":{"key":"Clients[sales_rep]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5500,"name":"\u6d4b\u8bd5"},{"key":5499,"name":"\u9648\u8c46\u8c46"},{"key":5332,"name":"\u970d\u536b\u8d85"},{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5087,"name":"\u5218\u5fae"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":5476,"name":"\u6768\u5dcd"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},{"key":"0","name":"\u516c\u6d77\u5ba2\u6237"}],"default":1001},"Clients[client_industry]":{"key":"Clients[client_industry]","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":57,"name":"EDA\/CAE"},{"key":1,"name":"\u653f\u5e9c"},{"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},{"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"},{"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":58,"name":"\u519b\u5de5"},{"key":6,"name":"\u7535\u5546"},{"key":7,"name":"\u9152\u5e97"},{"key":8,"name":"\u7269\u6d41"},{"key":9,"name":"\u5730\u4ea7"},{"key":10,"name":"\u91d1\u878d"},{"key":11,"name":"\u4ea4\u901a"},{"key":12,"name":"\u5e7f\u544a"},{"key":13,"name":"SI\/ISV"},{"key":14,"name":"\u5e7f\u7535"},{"key":15,"name":"\u7535\u529b"},{"key":16,"name":"\u80fd\u6e90"},{"key":17,"name":"\u96f6\u552e"},{"key":18,"name":"\u5a92\u4f53"},{"key":19,"name":"OTT"},{"key":20,"name":"\u5176\u4ed6"},{"key":59,"name":"\u8d38\u6613"}]},"Clients[company_nature]":{"key":"Clients[company_nature]","name":"\u516c\u53f8\u6027\u8d28","value":[{"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},{"key":2,"name":"\u6c11\u8425\u4e0a\u5e02"},{"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},{"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},{"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"}]},"Clients[client_class]":{"key":"Clients[client_class]","name":"\u5ba2\u6237\u7ea7\u522b","value":[{"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},{"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},{"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},{"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"}]},"Clients[client_type]":{"key":"Clients[client_type]","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},{"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},{"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},{"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-09 14:04:32', 259218176) RETURNING "id"
14:04:32.108traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:32.108traceyii\redis\Connection::executeCommandExecuting Redis Command: SET