ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a6c25442282: POST https://beta.jinchangxiao.com/vue/analysis/clients at 2025-08-21 02:53:08 pm by 124.64.23.198

Performance Profiling

Total processing time: 253 ms; Peak memory: 6.615 MB. Show Profiling Timeline

总计21条数据
TimeDurationCategoryInfo
  
14:53:08.28491.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT 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() - final.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, final.client_type, final.client_type_id, final.score, final.collected, final.un_collected, final.invoices, final.un_invoices, final.project_count, final.other_budgets, final.used_clients, final.status12_budgets, final.status12_profits, final.work1_time, final.work1_count, final.work2_time, final.work2_count, final.work3_time, final.work3_count, final.work4_time, final.work4_count, final.work5_time, final.work5_count 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 tmp1.collected IS NULL THEN 0 ELSE tmp1.collected END AS collected, CASE WHEN tmp1.used_clients IS NULL THEN 0 ELSE tmp1.used_clients END AS used_clients, CASE WHEN tmp1.un_collected IS NULL THEN 0 ELSE tmp1.un_collected END AS un_collected, 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, CASE WHEN tmp10.invoices IS NULL THEN 0 ELSE tmp10.invoices END AS invoices, CASE WHEN tmp10.un_invoices IS NULL THEN 0 ELSE tmp10.un_invoices END AS un_invoices, 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, CASE WHEN tmp11.count IS NULL THEN 0 ELSE tmp11.count END AS project_count, CASE WHEN tmp12.budgets IS NULL THEN 0 ELSE tmp12.budgets END AS other_budgets, CASE WHEN tmp13.budgets IS NULL THEN 0 ELSE tmp13.budgets END AS status12_budgets, CASE WHEN tmp13.profits IS NULL THEN 0 ELSE tmp13.profits END AS status12_profits, CASE WHEN tmp14.work_times IS NOT NULL THEN tmp14.work_times ELSE '00:00:00'::interval END AS work1_time, CASE WHEN tmp14.work_count IS NOT NULL THEN tmp14.work_count ELSE 0 END AS work1_count, CASE WHEN tmp15.work_times IS NOT NULL THEN tmp15.work_times ELSE '00:00:00'::interval END AS work2_time, CASE WHEN tmp15.work_count IS NOT NULL THEN tmp15.work_count ELSE 0 END AS work2_count, CASE WHEN tmp16.work_times IS NOT NULL THEN tmp16.work_times ELSE '00:00:00'::interval END AS work3_time, CASE WHEN tmp16.work_count IS NOT NULL THEN tmp16.work_count ELSE 0 END AS work3_count, CASE WHEN tmp17.work_times IS NOT NULL THEN tmp17.work_times ELSE '00:00:00'::interval END AS work4_time, CASE WHEN tmp17.work_count IS NOT NULL THEN tmp17.work_count ELSE 0 END AS work4_count, CASE WHEN tmp18.work_times IS NOT NULL THEN tmp18.work_times ELSE '00:00:00'::interval END AS work5_time, CASE WHEN tmp18.work_count IS NOT NULL THEN tmp18.work_count ELSE 0 END AS work5_count, 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 233::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 233::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_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep 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, sum(case when budget >= collected THEN budget - collected ELSE 0 END) AS un_collected, sum(collected) AS collected, count(sub1.id) as count, count(distinct sub1.used_client) as used_clients FROM (SELECT "p"."id", "p"."client_id", "p"."collected", "p"."budget", "p"."profit_pct", "p"."bargain_date", "p"."used_client" 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" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ps.created_by 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" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ir.created_by 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, COALESCE(sum(ca.points),0) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id GROUP BY "c"."id") "sub9" GROUP BY "sub9"."client_id") "tmp9" ON tmp9.client_id = c.id LEFT JOIN (SELECT sub10.client_id, sum(sub10.invoices) as invoices, sum(case when sub10.amount >= sub10.invoices and sub10.including_tax = true THEN sub10.amount - sub10.invoices ELSE 0 END) AS un_invoices FROM (SELECT sc.client_id, sc.including_tax, sc.amount, COALESCE(SUM(sci.amount ),0) AS invoices FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sci.contract_id = sc.id GROUP BY "sc"."id") "sub10" GROUP BY "sub10"."client_id") "tmp10" ON tmp10.client_id = c.id LEFT JOIN (SELECT sub11.client_id, sum(sub11.budget) AS budgets, count(sub11.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget" FROM "a57be577deb434"."tbl_projects" "p") "sub11" GROUP BY "sub11"."client_id") "tmp11" ON tmp11.client_id = c.id LEFT JOIN (SELECT sub12.client_id, sum(sub12.budget) AS budgets, count(sub12.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status != 3) "sub12" GROUP BY "sub12"."client_id") "tmp12" ON tmp12.client_id = c.id LEFT JOIN (SELECT sub13.client_id, sum(sub13.budget) AS budgets, sum(sub13.budget * sub13.profit_pct / 100) AS profits FROM (SELECT "p"."id", "p"."client_id", "p"."collected", "p"."budget", "p"."profit_pct" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status = 1 or p.project_status = 2) "sub13" GROUP BY "sub13"."client_id") "tmp13" ON tmp13.client_id = c.id LEFT JOIN (SELECT sub14.client_id, count(sub14.id) as work_count, sum(sub14.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 ("scenario_id"=1)) "sub14" GROUP BY "sub14"."client_id") "tmp14" ON tmp14.client_id = c.id LEFT JOIN (SELECT sub15.client_id, count(sub15.id) as work_count, sum(sub15.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 ("scenario_id"=2)) "sub15" GROUP BY "sub15"."client_id") "tmp15" ON tmp15.client_id = c.id LEFT JOIN (SELECT sub16.client_id, count(sub16.id) as work_count, sum(sub16.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 ("scenario_id"=3)) "sub16" GROUP BY "sub16"."client_id") "tmp16" ON tmp16.client_id = c.id LEFT JOIN (SELECT sub17.client_id, count(sub17.id) as work_count, sum(sub17.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 ("scenario_id"=4)) "sub17" GROUP BY "sub17"."client_id") "tmp17" ON tmp17.client_id = c.id LEFT JOIN (SELECT sub18.client_id, count(sub18.id) as work_count, sum(sub18.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 ("scenario_id"=5)) "sub18" GROUP BY "sub18"."client_id") "tmp18" ON tmp18.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON "cc"."id" = "c"."client_class" 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" WHERE (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."deleted"=FALSE) AND ("c"."sales_rep"='1001') AND ("sgr"."group_id"='1')) "final" LEFT JOIN "a57be577deb434"."tbl_cases" "cas" ON cas.client_id = final.id LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = cas.id LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id GROUP BY "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", "final"."pscount", "final"."ircount", "final"."created_at", "final"."work_time", "final"."work_count", "final"."last_bargain_date", "final"."reimbursement_amount", "final"."points", "final"."cooperated", "final"."client_industry", "final"."client_industry_id", "final"."client_type", "final"."client_type_id", "final"."score", "final"."collected", "final"."un_collected", "final"."invoices", "final"."un_invoices", "final"."project_count", "final"."other_budgets", "final"."used_clients", "final"."status12_budgets", "final"."status12_profits", "final"."work1_time", "final"."work1_count", "final"."work2_time", "final"."work2_count", "final"."work3_time", "final"."work3_count", "final"."work4_time", "final"."work4_count", "final"."work5_time", "final"."work5_count" ORDER BY "status3_budgets" DESC, "created_at" DESC) "c"
14:53:08.37783.5 msyii\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() - final.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, final.client_type, final.client_type_id, final.score, final.collected, final.un_collected, final.invoices, final.un_invoices, final.project_count, final.other_budgets, final.used_clients, final.status12_budgets, final.status12_profits, final.work1_time, final.work1_count, final.work2_time, final.work2_count, final.work3_time, final.work3_count, final.work4_time, final.work4_count, final.work5_time, final.work5_count 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 tmp1.collected IS NULL THEN 0 ELSE tmp1.collected END AS collected, CASE WHEN tmp1.used_clients IS NULL THEN 0 ELSE tmp1.used_clients END AS used_clients, CASE WHEN tmp1.un_collected IS NULL THEN 0 ELSE tmp1.un_collected END AS un_collected, 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, CASE WHEN tmp10.invoices IS NULL THEN 0 ELSE tmp10.invoices END AS invoices, CASE WHEN tmp10.un_invoices IS NULL THEN 0 ELSE tmp10.un_invoices END AS un_invoices, 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, CASE WHEN tmp11.count IS NULL THEN 0 ELSE tmp11.count END AS project_count, CASE WHEN tmp12.budgets IS NULL THEN 0 ELSE tmp12.budgets END AS other_budgets, CASE WHEN tmp13.budgets IS NULL THEN 0 ELSE tmp13.budgets END AS status12_budgets, CASE WHEN tmp13.profits IS NULL THEN 0 ELSE tmp13.profits END AS status12_profits, CASE WHEN tmp14.work_times IS NOT NULL THEN tmp14.work_times ELSE '00:00:00'::interval END AS work1_time, CASE WHEN tmp14.work_count IS NOT NULL THEN tmp14.work_count ELSE 0 END AS work1_count, CASE WHEN tmp15.work_times IS NOT NULL THEN tmp15.work_times ELSE '00:00:00'::interval END AS work2_time, CASE WHEN tmp15.work_count IS NOT NULL THEN tmp15.work_count ELSE 0 END AS work2_count, CASE WHEN tmp16.work_times IS NOT NULL THEN tmp16.work_times ELSE '00:00:00'::interval END AS work3_time, CASE WHEN tmp16.work_count IS NOT NULL THEN tmp16.work_count ELSE 0 END AS work3_count, CASE WHEN tmp17.work_times IS NOT NULL THEN tmp17.work_times ELSE '00:00:00'::interval END AS work4_time, CASE WHEN tmp17.work_count IS NOT NULL THEN tmp17.work_count ELSE 0 END AS work4_count, CASE WHEN tmp18.work_times IS NOT NULL THEN tmp18.work_times ELSE '00:00:00'::interval END AS work5_time, CASE WHEN tmp18.work_count IS NOT NULL THEN tmp18.work_count ELSE 0 END AS work5_count, 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 233::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 233::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_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep 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, sum(case when budget >= collected THEN budget - collected ELSE 0 END) AS un_collected, sum(collected) AS collected, count(sub1.id) as count, count(distinct sub1.used_client) as used_clients FROM (SELECT "p"."id", "p"."client_id", "p"."collected", "p"."budget", "p"."profit_pct", "p"."bargain_date", "p"."used_client" 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" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ps.created_by 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" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ir.created_by 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, COALESCE(sum(ca.points),0) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id GROUP BY "c"."id") "sub9" GROUP BY "sub9"."client_id") "tmp9" ON tmp9.client_id = c.id LEFT JOIN (SELECT sub10.client_id, sum(sub10.invoices) as invoices, sum(case when sub10.amount >= sub10.invoices and sub10.including_tax = true THEN sub10.amount - sub10.invoices ELSE 0 END) AS un_invoices FROM (SELECT sc.client_id, sc.including_tax, sc.amount, COALESCE(SUM(sci.amount ),0) AS invoices FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sci.contract_id = sc.id GROUP BY "sc"."id") "sub10" GROUP BY "sub10"."client_id") "tmp10" ON tmp10.client_id = c.id LEFT JOIN (SELECT sub11.client_id, sum(sub11.budget) AS budgets, count(sub11.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget" FROM "a57be577deb434"."tbl_projects" "p") "sub11" GROUP BY "sub11"."client_id") "tmp11" ON tmp11.client_id = c.id LEFT JOIN (SELECT sub12.client_id, sum(sub12.budget) AS budgets, count(sub12.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status != 3) "sub12" GROUP BY "sub12"."client_id") "tmp12" ON tmp12.client_id = c.id LEFT JOIN (SELECT sub13.client_id, sum(sub13.budget) AS budgets, sum(sub13.budget * sub13.profit_pct / 100) AS profits FROM (SELECT "p"."id", "p"."client_id", "p"."collected", "p"."budget", "p"."profit_pct" FROM "a57be577deb434"."tbl_projects" "p" WHERE p.project_status = 1 or p.project_status = 2) "sub13" GROUP BY "sub13"."client_id") "tmp13" ON tmp13.client_id = c.id LEFT JOIN (SELECT sub14.client_id, count(sub14.id) as work_count, sum(sub14.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 ("scenario_id"=1)) "sub14" GROUP BY "sub14"."client_id") "tmp14" ON tmp14.client_id = c.id LEFT JOIN (SELECT sub15.client_id, count(sub15.id) as work_count, sum(sub15.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 ("scenario_id"=2)) "sub15" GROUP BY "sub15"."client_id") "tmp15" ON tmp15.client_id = c.id LEFT JOIN (SELECT sub16.client_id, count(sub16.id) as work_count, sum(sub16.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 ("scenario_id"=3)) "sub16" GROUP BY "sub16"."client_id") "tmp16" ON tmp16.client_id = c.id LEFT JOIN (SELECT sub17.client_id, count(sub17.id) as work_count, sum(sub17.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 ("scenario_id"=4)) "sub17" GROUP BY "sub17"."client_id") "tmp17" ON tmp17.client_id = c.id LEFT JOIN (SELECT sub18.client_id, count(sub18.id) as work_count, sum(sub18.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 ("scenario_id"=5)) "sub18" GROUP BY "sub18"."client_id") "tmp18" ON tmp18.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON "cc"."id" = "c"."client_class" 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" WHERE (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."deleted"=FALSE) AND ("c"."sales_rep"='1001') AND ("sgr"."group_id"='1')) "final" LEFT JOIN "a57be577deb434"."tbl_cases" "cas" ON cas.client_id = final.id LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = cas.id LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id GROUP BY "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", "final"."pscount", "final"."ircount", "final"."created_at", "final"."work_time", "final"."work_count", "final"."last_bargain_date", "final"."reimbursement_amount", "final"."points", "final"."cooperated", "final"."client_industry", "final"."client_industry_id", "final"."client_type", "final"."client_type_id", "final"."score", "final"."collected", "final"."un_collected", "final"."invoices", "final"."un_invoices", "final"."project_count", "final"."other_budgets", "final"."used_clients", "final"."status12_budgets", "final"."status12_profits", "final"."work1_time", "final"."work1_count", "final"."work2_time", "final"."work2_count", "final"."work3_time", "final"."work3_count", "final"."work4_time", "final"."work4_count", "final"."work5_time", "final"."work5_count" ORDER BY "status3_budgets" DESC, "created_at" DESC LIMIT 20
14:53:08.4796.8 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_case_assignments' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
14:53:08.4896.8 msyii\db\Command::querySELECT "ca".* FROM "a57be577deb434"."tbl_case_assignments" "ca" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ca.case_id = c.id WHERE ("case_type"=2) AND ("ca"."case_id" IN (4705, 4728, 4996, 4659, 4985, 4604, 4619, 5039, 5051, 4707, 4730, 4975, 4605, 4661, 4606, 4662, 5001, 5069, 4699, 4710, 5027, 4724, 2783, 4712, 2874, 2811, 4665, 4689, 4725, 2862, 4476, 4676, 5030, 2936, 4637, 4654, 2988, 2891, 4653, 4638, 3092, 4623, 4616, 4624, 3480, 4625, 4642, 4473, 2010, 1925, 2123, 2162, 2225, 2247, 2316, 2304, 2328, 2510, 2511, 2330, 2470, 1978, 2000, 2190, 4488, 2472, 2058, 2297, 2394, 2138, 2168, 2176, 2231, 2322, 2376, 2395, 2552, 2335, 2311, 2496, 1941, 2283, 2455, 2363, 2207, 2456, 1985, 2326, 2338, 2104, 2157, 2339, 2340, 2459, 2260, 2341, 2440, 2424, 2522, 1911, 2261, 2403, 2384, 2441, 2425, 2482, 2404, 2426, 2593, 2463, 2485, 2406, 2507, 2407, 2596, 2408, 2530, 2606, 2621, 2615, 2626, 2693, 2662, 2704, 2784, 2810, 2808, 2812, 2821, 2804, 2805, 2905, 2902, 2884, 2907, 2906, 2958, 3008, 3001, 3017, 1964, 3096, 3108, 2439, 3355, 4492, 2464, 3416, 2818, 3628, 3833, 6060, 6061, 6083, 6089, 6090, 6084, 6094, 6095, 6098, 6109, 6102, 6400, 6405, 6409, 6408, 6395, 6433, 6434, 6543, 7722, 8101))
14:53:08.4676.7 msyii\db\Command::querySELECT "ca".* FROM "a57be577deb434"."tbl_case_assignments" "ca" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ca.case_id = c.id WHERE ("case_type"=1) AND ("ca"."case_id" IN (4705, 4728, 4996, 4659, 4985, 4604, 4619, 5039, 5051, 4707, 4730, 4975, 4605, 4661, 4606, 4662, 5001, 5069, 4699, 4710, 5027, 4724, 2783, 4712, 2874, 2811, 4665, 4689, 4725, 2862, 4476, 4676, 5030, 2936, 4637, 4654, 2988, 2891, 4653, 4638, 3092, 4623, 4616, 4624, 3480, 4625, 4642, 4473, 2010, 1925, 2123, 2162, 2225, 2247, 2316, 2304, 2328, 2510, 2511, 2330, 2470, 1978, 2000, 2190, 4488, 2472, 2058, 2297, 2394, 2138, 2168, 2176, 2231, 2322, 2376, 2395, 2552, 2335, 2311, 2496, 1941, 2283, 2455, 2363, 2207, 2456, 1985, 2326, 2338, 2104, 2157, 2339, 2340, 2459, 2260, 2341, 2440, 2424, 2522, 1911, 2261, 2403, 2384, 2441, 2425, 2482, 2404, 2426, 2593, 2463, 2485, 2406, 2507, 2407, 2596, 2408, 2530, 2606, 2621, 2615, 2626, 2693, 2662, 2704, 2784, 2810, 2808, 2812, 2821, 2804, 2805, 2905, 2902, 2884, 2907, 2906, 2958, 3008, 3001, 3017, 1964, 3096, 3108, 2439, 3355, 4492, 2464, 3416, 2818, 3628, 3833, 6060, 6061, 6083, 6089, 6090, 6084, 6094, 6095, 6098, 6109, 6102, 6400, 6405, 6409, 6408, 6395, 6433, 6434, 6543, 7722, 8101))
14:53:08.5006.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "case_id" IN (4705, 4728, 4996, 4659, 4604, 4619, 5039, 5051, 4707, 4730, 4975, 4605, 4661, 4606, 4662, 5001, 5069, 4699, 4710, 5027, 4724, 2783, 4712, 2874, 2811, 4665, 4689, 4725, 2862, 4476, 4676, 5030, 2936, 4637, 4654, 2988, 2891, 4653, 4638, 3092, 4623, 4616, 4624, 3480, 4625, 4642, 4473, 4488, 2784, 2810, 2808, 2812, 2821, 2804, 2805, 2905, 2902, 2884, 2907, 2906, 2958, 3008, 3001, 3017, 3096, 3108, 3355, 4492, 3416, 3628, 3833, 6060, 6061, 6083, 6089, 6090, 6084, 6094, 6095, 6098, 6109, 6102, 6400, 6405, 6409, 6408, 6395, 6433, 6434, 6543, 7722, 8101)
14:53:08.4744.5 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_case_assignments' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
14:53:08.5133.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-21')
14:53:08.5072.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "case_id" IN (4985, 2010, 1925, 2123, 2162, 2225, 2247, 2316, 2304, 2328, 2510, 2511, 2330, 2470, 1978, 2000, 2190, 2472, 2058, 2297, 2394, 2138, 2168, 2176, 2231, 2322, 2376, 2395, 2552, 2335, 2311, 2496, 1941, 2283, 2455, 2363, 2207, 2456, 1985, 2326, 2338, 2104, 2157, 2339, 2340, 2459, 2260, 2341, 2440, 2424, 2522, 1911, 2261, 2403, 2384, 2441, 2425, 2482, 2404, 2426, 2593, 2463, 2485, 2406, 2507, 2407, 2596, 2408, 2530, 2606, 2621, 2615, 2626, 2693, 2662, 2704, 1964, 2439, 2464)
14:53:08.5192.6 msyii\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/analysis/clients', '{"keyword":"","sales_rep":"1001","group":"1","dataUserId":"1001","page":"1","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":{"list":[{"id":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"status3_budgets":"5494736.8","status3_profits":"-14286.315680000000","status3_count":1,"status3_pct":-0.26,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"11\u4e2a\u670829\u5929","created_at":"2024-08-22 15:33:07","work_time":0,"work_count":0,"last_bargain_date":"2024-08-19","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"38","collected":"5494736.8","un_collected":"0.0","invoices":"5494736.80","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":3296,"taxonomy_id":265,"name":"\u5546\u4e1a\u8f6f\u4ef6","sum":"5494736.8","sum2":"109894.736","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":3296,"taxonomy_id":265,"name":"\u5546\u4e1a\u8f6f\u4ef6","sum":"5494736.8","sum2":"109894.736","y":100}]},{"id":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001,"status3_budgets":"3048204","status3_profits":"-7925.3304000000000000","status3_count":1,"status3_pct":-0.26,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"5\u4e2a\u670820\u5929","created_at":"2025-02-28 16:18:15","work_time":0,"work_count":0,"last_bargain_date":"2025-02-28","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"37","collected":"3048204","un_collected":"0","invoices":"3048204.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"2948995.00","status3_profits":"2436629.8148000000000000","status3_count":2,"status3_pct":82.63,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"5\u5e741\u4e2a\u670827\u5929","created_at":"2020-06-23 16:16:09","work_time":0,"work_count":1,"last_bargain_date":"2025-08-15","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"43","collected":"2948995","un_collected":"0.00","invoices":"514762.00","un_invoices":"2434233.00","project_count":2,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0.75,"work1_count":2,"work2_time":0,"work2_count":1,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":1661,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"514761","sum2":"2882.6616","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":1661,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"514761","sum2":"2882.6616","y":100}]},{"id":2115,"name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e","sales_rep":1001,"status3_budgets":"2648000","status3_profits":"39190.400000000000","status3_count":1,"status3_pct":1.48,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"3\u5e749\u4e2a\u670810\u5929","created_at":"2021-11-10 15:07:47","work_time":0,"work_count":0,"last_bargain_date":"2021-11-22","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u91d1\u878d","client_industry_id":10,"client_type":"\u592e\u4f01","client_type_id":6,"score":"25","collected":"2621954","un_collected":"26046","invoices":"2621954.00","un_invoices":"26046.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2115,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"2648000","sum2":"39190.4","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":2115,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"2648000","sum2":"39190.4","y":100}]},{"id":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"status3_budgets":"2486850","status3_profits":"373027.500000000000","status3_count":1,"status3_pct":15,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":79,"ircount":54,"service_time":"581.58","service_count":133,"sales_rep_time":"7\u5e743\u4e2a\u67084\u5929","created_at":"2018-05-16 18:55:46","work_time":0,"work_count":5,"last_bargain_date":"2019-09-23","reimbursement_amount":"3811.41","points":"5754","cooperated":true,"client_industry":"\u901a\u4fe1","client_industry_id":4,"client_type":"\u592e\u4f01","client_type_id":6,"score":"18","collected":"2486850","un_collected":"0","invoices":"2486850.00","un_invoices":"0.00","project_count":2,"other_budgets":"3000000","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":229.25,"work1_count":124,"work2_time":2,"work2_count":2,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":982,"taxonomy_id":304,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","y":100}],"preSalesEngineers":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5074,"key":5074,"name":"\u803f\u7a0b\u6797","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1020,"key":1020,"name":"\u738b\u6069\u56fd","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"satisfaction_score":10,"skill_score":10}],"implementEngineers":[{"id":5309,"key":5309,"name":"\u7518\u83b9\u83b9","sex":"F","department_id":1,"satisfaction_score":10,"skill_score":9.43},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"satisfaction_score":9.81,"skill_score":9.81},{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","department_id":2,"satisfaction_score":9.78,"skill_score":9.67},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5125,"key":5125,"name":"\u80e1\u6587\u5f3a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"satisfaction_score":10,"skill_score":10},{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"completedImplementCases":[{"id":4705,"client_id":982,"last_engineer":5309,"callback":{"id":3859,"client_id":982,"contact_id":3642,"description":"\u65e0","callback_date":"2021-09-29","created_by":5309,"created_at":"2021-09-29 15:30:21","updated_at":"2021-09-29 15:30:21","implement_id":null,"satisfaction_score":10,"skill_score":6,"case_id":4705,"mp_submit_contact_id":null}},{"id":4728,"client_id":982,"last_engineer":5309,"callback":{"id":3882,"client_id":982,"contact_id":3645,"description":"","callback_date":"2021-10-12","created_by":5309,"created_at":"2021-10-12 11:07:11","updated_at":"2021-10-12 11:07:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4728,"mp_submit_contact_id":3645}},{"id":4996,"client_id":982,"last_engineer":1001,"callback":{"id":4121,"client_id":982,"contact_id":3877,"description":"","callback_date":"2022-01-11","created_by":1001,"created_at":"2022-01-11 16:27:52","updated_at":"2022-01-11 16:27:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4996,"mp_submit_contact_id":3877}},{"id":4659,"client_id":982,"last_engineer":1001,"callback":{"id":3813,"client_id":982,"contact_id":3756,"description":"","callback_date":"2021-09-14","created_by":1001,"created_at":"2021-09-14 18:43:38","updated_at":"2021-09-14 18:43:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4659,"mp_submit_contact_id":null}},{"id":4604,"client_id":982,"last_engineer":1001,"callback":{"id":3762,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-08-31","created_by":1001,"created_at":"2021-08-31 19:50:33","updated_at":"2021-08-31 19:50:33","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4604,"mp_submit_contact_id":null}},{"id":4619,"client_id":982,"last_engineer":1001,"callback":{"id":3774,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-09-02","created_by":1001,"created_at":"2021-09-02 23:49:43","updated_at":"2021-09-02 23:49:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4619,"mp_submit_contact_id":null}},{"id":5039,"client_id":982,"last_engineer":1001,"callback":{"id":4164,"client_id":982,"contact_id":3736,"description":"","callback_date":"2022-02-15","created_by":1001,"created_at":"2022-02-15 16:21:30","updated_at":"2022-02-15 16:21:30","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5039,"mp_submit_contact_id":3736}},{"id":5051,"client_id":982,"last_engineer":1001,"callback":{"id":4178,"client_id":982,"contact_id":3899,"description":"","callback_date":"2022-02-22","created_by":1001,"created_at":"2022-02-22 21:56:24","updated_at":"2022-02-22 21:56:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5051,"mp_submit_contact_id":3899}},{"id":4707,"client_id":982,"last_engineer":1001,"callback":{"id":3861,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-09-30","created_by":1001,"created_at":"2021-09-29 18:10:40","updated_at":"2021-09-29 18:10:40","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4707,"mp_submit_contact_id":null}},{"id":4730,"client_id":982,"last_engineer":5309,"callback":{"id":3883,"client_id":982,"contact_id":3751,"description":"","callback_date":"2021-10-12","created_by":5309,"created_at":"2021-10-12 14:31:34","updated_at":"2021-10-12 14:31:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4730,"mp_submit_contact_id":3751}},{"id":4975,"client_id":982,"last_engineer":1001,"callback":{"id":4099,"client_id":982,"contact_id":3642,"description":"","callback_date":"2022-01-06","created_by":1001,"created_at":"2022-01-06 20:36:24","updated_at":"2022-01-06 20:36:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4975,"mp_submit_contact_id":null}},{"id":4605,"client_id":982,"last_engineer":1001,"callback":{"id":3763,"client_id":982,"contact_id":3716,"description":"","callback_date":"2021-08-31","created_by":1001,"created_at":"2021-08-31 19:53:36","updated_at":"2021-08-31 19:53:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4605,"mp_submit_contact_id":null}},{"id":4661,"client_id":982,"last_engineer":1001,"callback":{"id":3816,"client_id":982,"contact_id":3761,"description":"","callback_date":"2021-09-15","created_by":1001,"created_at":"2021-09-15 11:42:05","updated_at":"2021-09-15 11:42:05","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4661,"mp_submit_contact_id":null}},{"id":4606,"client_id":982,"last_engineer":1001,"callback":{"id":3764,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-08-31","created_by":1001,"created_at":"2021-08-31 20:18:38","updated_at":"2021-08-31 20:18:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4606,"mp_submit_contact_id":null}},{"id":4662,"client_id":982,"last_engineer":5309,"callback":{"id":3817,"client_id":982,"contact_id":3642,"description":"\u53ef\u89c6\u5316","callback_date":"2021-09-15","created_by":5309,"created_at":"2021-09-15 18:15:05","updated_at":"2021-09-15 18:15:05","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4662,"mp_submit_contact_id":null}},{"id":5001,"client_id":982,"last_engineer":1001,"callback":{"id":4136,"client_id":982,"contact_id":3642,"description":"","callback_date":"2022-01-14","created_by":1001,"created_at":"2022-01-14 21:02:57","updated_at":"2022-01-14 21:02:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5001,"mp_submit_contact_id":null}},{"id":5069,"client_id":982,"last_engineer":1001,"callback":{"id":4199,"client_id":982,"contact_id":3642,"description":"","callback_date":"2022-03-09","created_by":1001,"created_at":"2022-03-09 19:45:54","updated_at":"2022-03-09 19:45:54","implement_id":null,"satisfaction_score":4,"skill_score":4,"case_id":5069,"mp_submit_contact_id":null}},{"id":4699,"client_id":982,"last_engineer":1001,"callback":{"id":3860,"client_id":982,"contact_id":3642,"description":"\u65e0","callback_date":"2021-09-29","created_by":5309,"created_at":"2021-09-29 15:33:24","updated_at":"2021-09-29 15:33:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4699,"mp_submit_contact_id":null}},{"id":4710,"client_id":982,"last_engineer":1001,"callback":{"id":3863,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-09-30","created_by":1001,"created_at":"2021-09-30 10:01:00","updated_at":"2021-09-30 10:01:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4710,"mp_submit_contact_id":null}},{"id":5027,"client_id":982,"last_engineer":1001,"callback":{"id":4157,"client_id":982,"contact_id":3890,"description":"","callback_date":"2022-02-11","created_by":1001,"created_at":"2022-02-11 11:56:39","updated_at":"2022-02-11 11:56:39","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5027,"mp_submit_contact_id":3890}},{"id":4724,"client_id":982,"last_engineer":5309,"callback":{"id":3878,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-10-11","created_by":5309,"created_at":"2021-10-11 17:12:38","updated_at":"2021-10-11 17:12:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4724,"mp_submit_contact_id":null}},{"id":2783,"client_id":982,"last_engineer":1016,"callback":{"id":2081,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-09-06","created_by":5015,"created_at":"2019-09-06 15:27:47","updated_at":"2019-09-06 15:27:47","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2783,"mp_submit_contact_id":null}},{"id":4712,"client_id":982,"last_engineer":1001,"callback":{"id":3879,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-10-11","created_by":5309,"created_at":"2021-10-11 22:32:48","updated_at":"2021-10-11 22:32:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4712,"mp_submit_contact_id":null}},{"id":2874,"client_id":982,"last_engineer":1016,"callback":{"id":2158,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-18","created_by":null,"created_at":"2019-10-18 10:46:12","updated_at":"2019-10-18 10:46:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2874,"mp_submit_contact_id":null}},{"id":2811,"client_id":982,"last_engineer":1023,"callback":{"id":2103,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-09-12","created_by":5015,"created_at":"2019-09-12 11:20:37","updated_at":"2019-09-12 11:20:37","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2811,"mp_submit_contact_id":null}},{"id":4665,"client_id":982,"last_engineer":1001,"callback":{"id":3822,"client_id":982,"contact_id":3766,"description":"","callback_date":"2021-09-17","created_by":1001,"created_at":"2021-09-17 14:34:50","updated_at":"2021-09-17 14:34:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4665,"mp_submit_contact_id":null}},{"id":4689,"client_id":982,"last_engineer":1001,"callback":{"id":3842,"client_id":982,"contact_id":3774,"description":"\u65e0","callback_date":"2021-09-27","created_by":1001,"created_at":"2021-09-27 14:05:15","updated_at":"2021-09-27 14:05:15","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4689,"mp_submit_contact_id":null}},{"id":4725,"client_id":982,"last_engineer":5309,"callback":{"id":3880,"client_id":982,"contact_id":3751,"description":"","callback_date":"2021-10-11","created_by":5309,"created_at":"2021-10-11 22:33:36","updated_at":"2021-10-11 22:33:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4725,"mp_submit_contact_id":3751}},{"id":2862,"client_id":982,"last_engineer":1016,"callback":{"id":2142,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-09","created_by":null,"created_at":"2019-10-09 16:13:12","updated_at":"2019-10-09 16:13:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2862,"mp_submit_contact_id":null}},{"id":4476,"client_id":982,"last_engineer":1001,"callback":{"id":3653,"client_id":982,"contact_id":3642,"description":"\u6ee1\u610f","callback_date":"2021-07-07","created_by":1001,"created_at":"2021-07-07 14:55:18","updated_at":"2021-07-07 14:55:18","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4476,"mp_submit_contact_id":null}},{"id":4676,"client_id":982,"last_engineer":1001,"callback":{"id":3828,"client_id":982,"contact_id":3770,"description":"\u65e0","callback_date":"2021-09-23","created_by":1001,"created_at":"2021-09-23 15:20:00","updated_at":"2021-09-23 15:20:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4676,"mp_submit_contact_id":null}},{"id":5030,"client_id":982,"last_engineer":1001,"callback":{"id":4161,"client_id":982,"contact_id":3642,"description":"","callback_date":"2022-02-15","created_by":1001,"created_at":"2022-02-15 09:23:21","updated_at":"2022-02-15 09:23:21","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5030,"mp_submit_contact_id":null}},{"id":2936,"client_id":982,"last_engineer":5125,"callback":{"id":2198,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-11-05","created_by":null,"created_at":"2019-11-05 17:10:15","updated_at":"2019-11-05 17:10:15","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2936,"mp_submit_contact_id":null}},{"id":4637,"client_id":982,"last_engineer":1001,"callback":{"id":3787,"client_id":982,"contact_id":3645,"description":"","callback_date":"2021-09-07","created_by":1001,"created_at":"2021-09-07 14:00:40","updated_at":"2021-09-07 14:00:40","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4637,"mp_submit_contact_id":null}},{"id":4654,"client_id":982,"last_engineer":5309,"callback":{"id":3810,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-09-14","created_by":5309,"created_at":"2021-09-14 11:30:26","updated_at":"2021-09-14 11:30:26","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4654,"mp_submit_contact_id":null}},{"id":2988,"client_id":982,"last_engineer":1016,"callback":{"id":2271,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-11-29","created_by":null,"created_at":"2019-11-29 16:23:22","updated_at":"2019-11-29 16:23:22","implement_id":null,"satisfaction_score":8,"skill_score":8,"case_id":2988,"mp_submit_contact_id":null}},{"id":2891,"client_id":982,"last_engineer":1016,"callback":{"id":2173,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-24","created_by":null,"created_at":"2019-10-24 14:29:17","updated_at":"2019-10-24 14:29:17","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2891,"mp_submit_contact_id":null}},{"id":4653,"client_id":982,"last_engineer":1001,"callback":{"id":3809,"client_id":982,"contact_id":3751,"description":"","callback_date":"2021-09-14","created_by":1001,"created_at":"2021-09-14 11:10:31","updated_at":"2021-09-14 11:10:31","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4653,"mp_submit_contact_id":null}},{"id":4638,"client_id":982,"last_engineer":1001,"callback":{"id":3791,"client_id":982,"contact_id":3645,"description":"","callback_date":"2021-09-07","created_by":1001,"created_at":"2021-09-07 15:32:56","updated_at":"2021-09-07 15:32:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4638,"mp_submit_contact_id":null}},{"id":3092,"client_id":982,"last_engineer":1016,"callback":{"id":2363,"client_id":982,"contact_id":2890,"description":"","callback_date":"2020-01-09","created_by":null,"created_at":"2020-01-09 14:22:28","updated_at":"2020-01-09 14:22:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3092,"mp_submit_contact_id":null}},{"id":4623,"client_id":982,"last_engineer":1001,"callback":{"id":3784,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-09-06","created_by":1001,"created_at":"2021-09-06 10:34:04","updated_at":"2021-09-06 10:34:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4623,"mp_submit_contact_id":null}},{"id":4616,"client_id":982,"last_engineer":1001,"callback":{"id":3772,"client_id":982,"contact_id":3656,"description":"","callback_date":"2021-09-02","created_by":1001,"created_at":"2021-09-02 16:49:28","updated_at":"2021-09-02 16:49:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4616,"mp_submit_contact_id":null}},{"id":4624,"client_id":982,"last_engineer":1001,"callback":{"id":3785,"client_id":982,"contact_id":3738,"description":"","callback_date":"2021-09-06","created_by":1001,"created_at":"2021-09-06 13:04:56","updated_at":"2021-09-06 13:04:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4624,"mp_submit_contact_id":null}},{"id":3480,"client_id":982,"last_engineer":1016,"callback":{"id":2709,"client_id":982,"contact_id":3146,"description":"\u672c\u6b21\u662f\u53bb\u5206\u9662\u770b\u73b0\u573a\uff0c\u7b7e\u5230\u7b7e\u9000\u8ddd\u79bb\u8fc7\u8fdc\uff0c\u5df2\u548c\u9500\u552e\u786e\u8ba4\u3002","callback_date":"2020-05-22","created_by":null,"created_at":"2020-05-22 17:29:07","updated_at":"2020-05-22 17:29:07","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3480,"mp_submit_contact_id":null}},{"id":4625,"client_id":982,"last_engineer":1001,"callback":{"id":3786,"client_id":982,"contact_id":3738,"description":"","callback_date":"2021-09-06","created_by":1001,"created_at":"2021-09-06 13:06:50","updated_at":"2021-09-06 13:06:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4625,"mp_submit_contact_id":null}},{"id":4642,"client_id":982,"last_engineer":1005,"callback":{"id":3796,"client_id":982,"contact_id":3743,"description":"","callback_date":"2021-09-08","created_by":1005,"created_at":"2021-09-08 16:32:30","updated_at":"2021-09-08 16:32:30","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4642,"mp_submit_contact_id":null}},{"id":4473,"client_id":982,"last_engineer":1001,"callback":{"id":3652,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-07-06","created_by":1001,"created_at":"2021-07-06 20:48:36","updated_at":"2021-07-06 20:48:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4473,"mp_submit_contact_id":null}},{"id":4488,"client_id":982,"last_engineer":1001,"callback":{"id":3665,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-07-12","created_by":1001,"created_at":"2021-07-12 14:12:06","updated_at":"2021-07-12 14:12:06","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4488,"mp_submit_contact_id":null}},{"id":2784,"client_id":982,"last_engineer":1023,"callback":{"id":2082,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-09-06","created_by":5015,"created_at":"2019-09-06 15:28:09","updated_at":"2019-09-06 15:28:09","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2784,"mp_submit_contact_id":null}},{"id":2810,"client_id":982,"last_engineer":1022,"callback":{"id":2102,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-09-12","created_by":5015,"created_at":"2019-09-12 11:20:26","updated_at":"2019-09-12 11:20:26","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2810,"mp_submit_contact_id":null}},{"id":2808,"client_id":982,"last_engineer":1023,"callback":{"id":2100,"client_id":982,"contact_id":2890,"description":"","callback_date":"2019-09-12","created_by":5015,"created_at":"2019-09-12 11:17:21","updated_at":"2019-09-12 11:17:21","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2808,"mp_submit_contact_id":null}},{"id":2812,"client_id":982,"last_engineer":1023,"callback":{"id":2101,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-09-12","created_by":5015,"created_at":"2019-09-12 11:20:14","updated_at":"2019-09-12 11:20:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2812,"mp_submit_contact_id":null}},{"id":2821,"client_id":982,"last_engineer":1023,"callback":{"id":2113,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-09-20","created_by":5015,"created_at":"2019-09-20 14:25:48","updated_at":"2019-09-20 14:25:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2821,"mp_submit_contact_id":null}},{"id":2804,"client_id":982,"last_engineer":1023,"callback":{"id":2098,"client_id":982,"contact_id":2890,"description":"","callback_date":"2019-09-12","created_by":5015,"created_at":"2019-09-12 11:16:53","updated_at":"2019-09-12 11:16:53","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2804,"mp_submit_contact_id":null}},{"id":2805,"client_id":982,"last_engineer":1023,"callback":{"id":2099,"client_id":982,"contact_id":2890,"description":"","callback_date":"2019-09-12","created_by":5015,"created_at":"2019-09-12 11:17:07","updated_at":"2019-09-12 11:17:07","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2805,"mp_submit_contact_id":null}},{"id":2905,"client_id":982,"last_engineer":5125,"callback":{"id":2186,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-31","created_by":null,"created_at":"2019-10-31 16:19:53","updated_at":"2019-10-31 16:19:53","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2905,"mp_submit_contact_id":null}},{"id":2902,"client_id":982,"last_engineer":5125,"callback":{"id":2187,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-31","created_by":null,"created_at":"2019-10-31 16:20:03","updated_at":"2019-10-31 16:20:03","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2902,"mp_submit_contact_id":null}},{"id":2884,"client_id":982,"last_engineer":1016,"callback":{"id":2159,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-18","created_by":null,"created_at":"2019-10-18 10:46:31","updated_at":"2019-10-18 10:46:31","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2884,"mp_submit_contact_id":null}},{"id":2907,"client_id":982,"last_engineer":1016,"callback":{"id":2185,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-31","created_by":null,"created_at":"2019-10-31 16:19:43","updated_at":"2019-10-31 16:19:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2907,"mp_submit_contact_id":null}},{"id":2906,"client_id":982,"last_engineer":5125,"callback":{"id":2184,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-10-31","created_by":null,"created_at":"2019-10-31 16:19:31","updated_at":"2019-10-31 16:19:31","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2906,"mp_submit_contact_id":null}},{"id":2958,"client_id":982,"last_engineer":5125,"callback":{"id":2237,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-11-15","created_by":null,"created_at":"2019-11-15 11:04:37","updated_at":"2019-11-15 11:04:37","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2958,"mp_submit_contact_id":null}},{"id":3008,"client_id":982,"last_engineer":1016,"callback":{"id":2278,"client_id":982,"contact_id":2890,"description":"","callback_date":"2019-12-06","created_by":null,"created_at":"2019-12-06 16:35:09","updated_at":"2019-12-06 16:35:09","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3008,"mp_submit_contact_id":null}},{"id":3001,"client_id":982,"last_engineer":1016,"callback":{"id":2272,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-11-29","created_by":null,"created_at":"2019-11-29 16:23:47","updated_at":"2019-11-29 16:23:47","implement_id":null,"satisfaction_score":8,"skill_score":8,"case_id":3001,"mp_submit_contact_id":null}},{"id":3017,"client_id":982,"last_engineer":1016,"callback":{"id":2293,"client_id":982,"contact_id":2890,"description":"","callback_date":"2019-12-12","created_by":null,"created_at":"2019-12-12 16:36:24","updated_at":"2019-12-12 16:36:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3017,"mp_submit_contact_id":null}},{"id":3096,"client_id":982,"last_engineer":1016,"callback":{"id":2369,"client_id":982,"contact_id":2890,"description":"","callback_date":"2020-01-10","created_by":null,"created_at":"2020-01-10 14:34:59","updated_at":"2020-01-10 14:34:59","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3096,"mp_submit_contact_id":null}},{"id":3108,"client_id":982,"last_engineer":1016,"callback":{"id":2378,"client_id":982,"contact_id":2890,"description":"","callback_date":"2020-01-15","created_by":null,"created_at":"2020-01-15 16:49:31","updated_at":"2020-01-15 16:49:31","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3108,"mp_submit_contact_id":null}},{"id":3355,"client_id":982,"last_engineer":1016,"callback":{"id":2586,"client_id":982,"contact_id":2319,"description":"","callback_date":"2020-04-15","created_by":null,"created_at":"2020-04-15 10:57:27","updated_at":"2020-04-15 10:57:27","implement_id":null,"satisfaction_score":10,"skill_score":8,"case_id":3355,"mp_submit_contact_id":null}},{"id":4492,"client_id":982,"last_engineer":1001,"callback":{"id":3666,"client_id":982,"contact_id":3642,"description":"","callback_date":"2021-07-13","created_by":5094,"created_at":"2021-07-13 14:27:58","updated_at":"2021-07-13 14:27:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4492,"mp_submit_contact_id":null}},{"id":3416,"client_id":982,"last_engineer":1016,"callback":{"id":2646,"client_id":982,"contact_id":2890,"description":"","callback_date":"2020-04-30","created_by":null,"created_at":"2020-04-30 16:56:11","updated_at":"2020-04-30 16:56:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3416,"mp_submit_contact_id":null}},{"id":3628,"client_id":982,"last_engineer":1016,"callback":{"id":2845,"client_id":982,"contact_id":2319,"description":"","callback_date":"2020-07-15","created_by":null,"created_at":"2020-07-15 14:16:39","updated_at":"2020-07-15 14:16:39","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3628,"mp_submit_contact_id":null}},{"id":3833,"client_id":982,"last_engineer":1016,"callback":{"id":3041,"client_id":982,"contact_id":2319,"description":"","callback_date":"2020-09-08","created_by":null,"created_at":"2020-09-08 15:08:36","updated_at":"2020-09-08 15:08:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3833,"mp_submit_contact_id":null}}],"completedPreSalesCases":[{"id":4985,"client_id":982,"last_engineer":1001,"callback":{"id":4112,"client_id":982,"contact_id":3642,"description":"","callback_date":"2022-01-07","created_by":1001,"created_at":"2022-01-07 20:44:46","updated_at":"2022-01-07 20:44:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4985,"mp_submit_contact_id":null}},{"id":2010,"client_id":982,"last_engineer":5074,"callback":{"id":1320,"client_id":982,"contact_id":2413,"description":"","callback_date":"2018-11-30","created_by":5015,"created_at":"2018-11-30 17:08:33","updated_at":"2018-11-30 17:08:33","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2010,"mp_submit_contact_id":null}},{"id":1925,"client_id":982,"last_engineer":5074,"callback":{"id":1209,"client_id":982,"contact_id":2319,"description":"","callback_date":"2018-11-13","created_by":5015,"created_at":"2018-11-13 11:02:16","updated_at":"2018-11-13 11:02:16","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1925,"mp_submit_contact_id":null}},{"id":2123,"client_id":982,"last_engineer":5074,"callback":{"id":1418,"client_id":982,"contact_id":2413,"description":"","callback_date":"2018-12-28","created_by":5015,"created_at":"2018-12-28 09:49:55","updated_at":"2018-12-28 09:49:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2123,"mp_submit_contact_id":null}},{"id":2162,"client_id":982,"last_engineer":5074,"callback":{"id":1457,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-11","created_by":5015,"created_at":"2019-01-11 11:32:35","updated_at":"2019-01-11 11:32:35","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2162,"mp_submit_contact_id":null}},{"id":2225,"client_id":982,"last_engineer":5074,"callback":{"id":1519,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-29","created_by":5015,"created_at":"2019-01-29 11:34:36","updated_at":"2019-01-29 11:34:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2225,"mp_submit_contact_id":null}},{"id":2247,"client_id":982,"last_engineer":5074,"callback":{"id":1540,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-02-21","created_by":5015,"created_at":"2019-02-21 09:50:34","updated_at":"2019-02-21 09:50:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2247,"mp_submit_contact_id":null}},{"id":2316,"client_id":982,"last_engineer":5074,"callback":{"id":1607,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-19","created_by":5015,"created_at":"2019-03-19 17:11:22","updated_at":"2019-03-19 17:11:22","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2316,"mp_submit_contact_id":null}},{"id":2304,"client_id":982,"last_engineer":5074,"callback":{"id":1585,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-13","created_by":5015,"created_at":"2019-03-13 16:08:25","updated_at":"2019-03-13 16:08:25","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2304,"mp_submit_contact_id":null}},{"id":2328,"client_id":982,"last_engineer":5074,"callback":{"id":1615,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-22","created_by":5015,"created_at":"2019-03-22 13:47:20","updated_at":"2019-03-22 13:47:20","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2328,"mp_submit_contact_id":null}},{"id":2510,"client_id":982,"last_engineer":1020,"callback":{"id":1795,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-31","created_by":5015,"created_at":"2019-05-31 10:02:37","updated_at":"2019-05-31 10:02:37","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2510,"mp_submit_contact_id":null}},{"id":2511,"client_id":982,"last_engineer":1020,"callback":{"id":1801,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-31","created_by":5015,"created_at":"2019-05-31 17:30:52","updated_at":"2019-05-31 17:30:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2511,"mp_submit_contact_id":null}},{"id":2330,"client_id":982,"last_engineer":5074,"callback":{"id":1620,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-26","created_by":5015,"created_at":"2019-03-26 17:04:52","updated_at":"2019-03-26 17:04:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2330,"mp_submit_contact_id":null}},{"id":2470,"client_id":982,"last_engineer":1023,"callback":{"id":1753,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-20","created_by":5015,"created_at":"2019-05-20 14:31:29","updated_at":"2019-05-20 14:31:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2470,"mp_submit_contact_id":null}},{"id":1978,"client_id":982,"last_engineer":1022,"callback":{"id":1267,"client_id":982,"contact_id":2319,"description":"","callback_date":"2018-11-23","created_by":5015,"created_at":"2018-11-23 09:09:30","updated_at":"2018-11-23 09:09:30","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1978,"mp_submit_contact_id":null}},{"id":2000,"client_id":982,"last_engineer":5074,"callback":{"id":1284,"client_id":982,"contact_id":2319,"description":"","callback_date":"2018-11-27","created_by":5015,"created_at":"2018-11-27 09:36:28","updated_at":"2018-11-27 09:36:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2000,"mp_submit_contact_id":null}},{"id":2190,"client_id":982,"last_engineer":5074,"callback":{"id":1492,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-22","created_by":5015,"created_at":"2019-01-22 10:41:57","updated_at":"2019-01-22 10:41:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2190,"mp_submit_contact_id":null}},{"id":2472,"client_id":982,"last_engineer":1023,"callback":{"id":1774,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-24","created_by":5015,"created_at":"2019-05-24 14:15:43","updated_at":"2019-05-24 14:15:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2472,"mp_submit_contact_id":null}},{"id":2058,"client_id":982,"last_engineer":5074,"callback":{"id":1358,"client_id":982,"contact_id":2413,"description":"","callback_date":"2018-12-12","created_by":5015,"created_at":"2018-12-12 09:55:36","updated_at":"2018-12-12 09:55:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2058,"mp_submit_contact_id":null}},{"id":2297,"client_id":982,"last_engineer":5074,"callback":{"id":1590,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-14","created_by":5015,"created_at":"2019-03-14 10:35:18","updated_at":"2019-03-14 10:35:18","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2297,"mp_submit_contact_id":null}},{"id":2394,"client_id":982,"last_engineer":1023,"callback":{"id":1682,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-23","created_by":5015,"created_at":"2019-04-23 09:20:56","updated_at":"2019-04-23 09:20:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2394,"mp_submit_contact_id":null}},{"id":2138,"client_id":982,"last_engineer":5074,"callback":{"id":1438,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-08","created_by":5015,"created_at":"2019-01-08 10:30:24","updated_at":"2019-01-08 10:30:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2138,"mp_submit_contact_id":null}},{"id":2168,"client_id":982,"last_engineer":5074,"callback":{"id":1461,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-14","created_by":5015,"created_at":"2019-01-14 11:31:19","updated_at":"2019-01-14 11:31:19","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2168,"mp_submit_contact_id":null}},{"id":2176,"client_id":982,"last_engineer":5074,"callback":{"id":1474,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-16","created_by":5015,"created_at":"2019-01-16 15:00:33","updated_at":"2019-01-16 15:00:33","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2176,"mp_submit_contact_id":null}},{"id":2231,"client_id":982,"last_engineer":5074,"callback":{"id":1527,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-30","created_by":5015,"created_at":"2019-01-30 16:43:55","updated_at":"2019-01-30 16:43:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2231,"mp_submit_contact_id":null}},{"id":2322,"client_id":982,"last_engineer":5074,"callback":{"id":1611,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-21","created_by":5015,"created_at":"2019-03-21 10:32:02","updated_at":"2019-03-21 10:32:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2322,"mp_submit_contact_id":null}},{"id":2376,"client_id":982,"last_engineer":1023,"callback":{"id":1677,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-19","created_by":5015,"created_at":"2019-04-19 10:35:14","updated_at":"2019-04-19 10:35:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2376,"mp_submit_contact_id":null}},{"id":2395,"client_id":982,"last_engineer":1023,"callback":{"id":1675,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-19","created_by":5015,"created_at":"2019-04-19 10:34:45","updated_at":"2019-04-19 10:34:45","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2395,"mp_submit_contact_id":null}},{"id":2552,"client_id":982,"last_engineer":1023,"callback":{"id":1836,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-06-18","created_by":5015,"created_at":"2019-06-18 16:53:32","updated_at":"2019-06-18 16:53:32","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2552,"mp_submit_contact_id":null}},{"id":2335,"client_id":982,"last_engineer":5074,"callback":{"id":1621,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-26","created_by":5015,"created_at":"2019-03-26 17:10:01","updated_at":"2019-03-26 17:10:01","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2335,"mp_submit_contact_id":null}},{"id":2311,"client_id":982,"last_engineer":5074,"callback":{"id":1602,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-18","created_by":5015,"created_at":"2019-03-18 16:18:32","updated_at":"2019-03-18 16:18:32","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2311,"mp_submit_contact_id":null}},{"id":2496,"client_id":982,"last_engineer":1023,"callback":{"id":1783,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-28","created_by":5015,"created_at":"2019-05-28 09:52:56","updated_at":"2019-05-28 09:52:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2496,"mp_submit_contact_id":null}},{"id":1941,"client_id":982,"last_engineer":5074,"callback":{"id":1225,"client_id":982,"contact_id":2319,"description":"","callback_date":"2018-11-15","created_by":5015,"created_at":"2018-11-15 16:57:42","updated_at":"2018-11-15 16:57:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1941,"mp_submit_contact_id":null}},{"id":2283,"client_id":982,"last_engineer":5074,"callback":{"id":1576,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-08","created_by":5015,"created_at":"2019-03-08 10:01:19","updated_at":"2019-03-08 10:01:19","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2283,"mp_submit_contact_id":null}},{"id":2455,"client_id":982,"last_engineer":1023,"callback":{"id":1726,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 10:58:29","updated_at":"2019-05-10 10:58:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2455,"mp_submit_contact_id":null}},{"id":2363,"client_id":982,"last_engineer":1023,"callback":{"id":1648,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-10","created_by":5015,"created_at":"2019-04-10 17:01:22","updated_at":"2019-04-10 17:01:22","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2363,"mp_submit_contact_id":null}},{"id":2207,"client_id":982,"last_engineer":5074,"callback":{"id":1498,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-24","created_by":5015,"created_at":"2019-01-24 14:29:50","updated_at":"2019-01-24 14:29:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2207,"mp_submit_contact_id":null}},{"id":2456,"client_id":982,"last_engineer":1023,"callback":{"id":1757,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-20","created_by":5015,"created_at":"2019-05-20 14:32:29","updated_at":"2019-05-20 14:32:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2456,"mp_submit_contact_id":null}},{"id":1985,"client_id":982,"last_engineer":5074,"callback":{"id":1281,"client_id":982,"contact_id":2319,"description":"","callback_date":"2018-11-26","created_by":5015,"created_at":"2018-11-26 17:43:44","updated_at":"2018-11-26 17:43:44","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1985,"mp_submit_contact_id":null}},{"id":2326,"client_id":982,"last_engineer":5074,"callback":{"id":1612,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-21","created_by":5015,"created_at":"2019-03-21 10:32:21","updated_at":"2019-03-21 10:32:21","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2326,"mp_submit_contact_id":null}},{"id":2338,"client_id":982,"last_engineer":5074,"callback":{"id":1632,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-29","created_by":5015,"created_at":"2019-03-29 15:00:25","updated_at":"2019-03-29 15:00:25","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2338,"mp_submit_contact_id":null}},{"id":2104,"client_id":982,"last_engineer":5074,"callback":{"id":1386,"client_id":982,"contact_id":2413,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 09:59:46","updated_at":"2018-12-21 09:59:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2104,"mp_submit_contact_id":null}},{"id":2157,"client_id":982,"last_engineer":5074,"callback":{"id":1445,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-01-10","created_by":5015,"created_at":"2019-01-10 09:48:43","updated_at":"2019-01-10 09:48:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2157,"mp_submit_contact_id":null}},{"id":2339,"client_id":982,"last_engineer":5074,"callback":{"id":1631,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-29","created_by":5015,"created_at":"2019-03-29 15:00:10","updated_at":"2019-03-29 15:00:10","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2339,"mp_submit_contact_id":null}},{"id":2340,"client_id":982,"last_engineer":5074,"callback":{"id":1630,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-03-29","created_by":5015,"created_at":"2019-03-29 14:59:51","updated_at":"2019-03-29 14:59:51","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2340,"mp_submit_contact_id":null}},{"id":2459,"client_id":982,"last_engineer":1023,"callback":{"id":1756,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-20","created_by":5015,"created_at":"2019-05-20 14:32:16","updated_at":"2019-05-20 14:32:16","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2459,"mp_submit_contact_id":null}},{"id":2260,"client_id":982,"last_engineer":5074,"callback":{"id":1547,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-02-27","created_by":5015,"created_at":"2019-02-27 15:14:02","updated_at":"2019-02-27 15:14:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2260,"mp_submit_contact_id":null}},{"id":2341,"client_id":982,"last_engineer":5074,"callback":{"id":1633,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-02","created_by":5015,"created_at":"2019-04-02 13:36:04","updated_at":"2019-04-02 13:36:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2341,"mp_submit_contact_id":null}},{"id":2440,"client_id":982,"last_engineer":1023,"callback":{"id":1728,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 10:58:58","updated_at":"2019-05-10 10:58:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2440,"mp_submit_contact_id":null}},{"id":2424,"client_id":982,"last_engineer":1023,"callback":{"id":1719,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-06","created_by":5015,"created_at":"2019-05-06 17:35:00","updated_at":"2019-05-06 17:35:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2424,"mp_submit_contact_id":null}},{"id":2522,"client_id":982,"last_engineer":1023,"callback":{"id":1807,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-06-05","created_by":5015,"created_at":"2019-06-05 14:22:19","updated_at":"2019-06-05 14:22:19","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2522,"mp_submit_contact_id":null}},{"id":1911,"client_id":982,"last_engineer":1017,"callback":{"id":1183,"client_id":982,"contact_id":1950,"description":"","callback_date":"2018-11-07","created_by":5015,"created_at":"2018-11-07 11:08:56","updated_at":"2018-11-07 11:08:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1911,"mp_submit_contact_id":null}},{"id":2261,"client_id":982,"last_engineer":5074,"callback":{"id":1546,"client_id":982,"contact_id":2413,"description":"","callback_date":"2019-02-27","created_by":5015,"created_at":"2019-02-27 15:13:44","updated_at":"2019-02-27 15:13:44","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2261,"mp_submit_contact_id":null}},{"id":2403,"client_id":982,"last_engineer":1023,"callback":{"id":1698,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-25","created_by":5015,"created_at":"2019-04-25 15:08:09","updated_at":"2019-04-25 15:08:09","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2403,"mp_submit_contact_id":null}},{"id":2384,"client_id":982,"last_engineer":1023,"callback":{"id":1676,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-19","created_by":5015,"created_at":"2019-04-19 10:34:58","updated_at":"2019-04-19 10:34:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2384,"mp_submit_contact_id":null}},{"id":2441,"client_id":982,"last_engineer":1023,"callback":{"id":1727,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 10:58:44","updated_at":"2019-05-10 10:58:44","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2441,"mp_submit_contact_id":null}},{"id":2425,"client_id":982,"last_engineer":1023,"callback":{"id":1720,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-06","created_by":5015,"created_at":"2019-05-06 17:35:14","updated_at":"2019-05-06 17:35:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2425,"mp_submit_contact_id":null}},{"id":2482,"client_id":982,"last_engineer":1023,"callback":{"id":1773,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-24","created_by":5015,"created_at":"2019-05-24 14:15:29","updated_at":"2019-05-24 14:15:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2482,"mp_submit_contact_id":null}},{"id":2404,"client_id":982,"last_engineer":1023,"callback":{"id":1697,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-25","created_by":5015,"created_at":"2019-04-25 15:07:54","updated_at":"2019-04-25 15:07:54","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2404,"mp_submit_contact_id":null}},{"id":2426,"client_id":982,"last_engineer":1023,"callback":{"id":1721,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-06","created_by":5015,"created_at":"2019-05-06 17:35:26","updated_at":"2019-05-06 17:35:26","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2426,"mp_submit_contact_id":null}},{"id":2593,"client_id":982,"last_engineer":1023,"callback":{"id":1881,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-07-02","created_by":5015,"created_at":"2019-07-02 16:17:20","updated_at":"2019-07-02 16:17:20","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2593,"mp_submit_contact_id":null}},{"id":2463,"client_id":982,"last_engineer":1023,"callback":{"id":1755,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-20","created_by":5015,"created_at":"2019-05-20 14:32:04","updated_at":"2019-05-20 14:32:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2463,"mp_submit_contact_id":null}},{"id":2485,"client_id":982,"last_engineer":1023,"callback":{"id":1772,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-24","created_by":5015,"created_at":"2019-05-24 14:15:16","updated_at":"2019-05-24 14:15:16","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2485,"mp_submit_contact_id":null}},{"id":2406,"client_id":982,"last_engineer":1023,"callback":{"id":1696,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-25","created_by":5015,"created_at":"2019-04-25 15:07:39","updated_at":"2019-04-25 15:07:39","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2406,"mp_submit_contact_id":null}},{"id":2507,"client_id":982,"last_engineer":1023,"callback":{"id":1792,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-30","created_by":5015,"created_at":"2019-05-30 14:04:47","updated_at":"2019-05-30 14:04:47","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2507,"mp_submit_contact_id":null}},{"id":2407,"client_id":982,"last_engineer":1023,"callback":{"id":1701,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-26","created_by":5015,"created_at":"2019-04-26 10:15:09","updated_at":"2019-04-26 10:15:09","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2407,"mp_submit_contact_id":null}},{"id":2596,"client_id":982,"last_engineer":1023,"callback":{"id":1880,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-07-02","created_by":5015,"created_at":"2019-07-02 16:16:23","updated_at":"2019-07-02 16:16:23","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2596,"mp_submit_contact_id":null}},{"id":2408,"client_id":982,"last_engineer":1023,"callback":{"id":1707,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-04-28","created_by":5015,"created_at":"2019-04-28 16:28:27","updated_at":"2019-04-28 16:28:27","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2408,"mp_submit_contact_id":null}},{"id":2530,"client_id":982,"last_engineer":1023,"callback":{"id":1822,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-06-12","created_by":5015,"created_at":"2019-06-12 09:04:49","updated_at":"2019-06-12 09:04:49","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2530,"mp_submit_contact_id":null}},{"id":2606,"client_id":982,"last_engineer":1023,"callback":{"id":1895,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-07-05","created_by":5015,"created_at":"2019-07-05 16:34:42","updated_at":"2019-07-05 16:34:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2606,"mp_submit_contact_id":null}},{"id":2621,"client_id":982,"last_engineer":1023,"callback":{"id":1913,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-07-12","created_by":5015,"created_at":"2019-07-12 13:55:03","updated_at":"2019-07-12 13:55:03","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2621,"mp_submit_contact_id":null}},{"id":2615,"client_id":982,"last_engineer":1023,"callback":{"id":1900,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-07-10","created_by":5015,"created_at":"2019-07-10 16:41:37","updated_at":"2019-07-10 16:41:37","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2615,"mp_submit_contact_id":null}},{"id":2626,"client_id":982,"last_engineer":1023,"callback":{"id":1917,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-07-16","created_by":5015,"created_at":"2019-07-16 14:54:16","updated_at":"2019-07-16 14:54:16","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2626,"mp_submit_contact_id":null}},{"id":2693,"client_id":982,"last_engineer":1023,"callback":{"id":1980,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-08-01","created_by":5015,"created_at":"2019-08-01 11:40:59","updated_at":"2019-08-01 11:40:59","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2693,"mp_submit_contact_id":null}},{"id":2662,"client_id":982,"last_engineer":1023,"callback":{"id":1949,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-07-25","created_by":5015,"created_at":"2019-07-25 11:05:46","updated_at":"2019-07-25 11:05:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2662,"mp_submit_contact_id":null}},{"id":2704,"client_id":982,"last_engineer":1023,"callback":{"id":1995,"client_id":982,"contact_id":2319,"description":"","callback_date":"2019-08-12","created_by":5015,"created_at":"2019-08-12 10:46:57","updated_at":"2019-08-12 10:46:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2704,"mp_submit_contact_id":null}},{"id":1964,"client_id":982,"last_engineer":5074,"callback":{"id":1257,"client_id":982,"contact_id":2319,"description":"","callback_date":"2018-11-22","created_by":5015,"created_at":"2018-11-22 10:07:15","updated_at":"2018-11-22 10:07:15","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1964,"mp_submit_contact_id":null}},{"id":2439,"client_id":982,"last_engineer":1023,"callback":{"id":1729,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 10:59:12","updated_at":"2019-05-10 10:59:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2439,"mp_submit_contact_id":null}},{"id":2464,"client_id":982,"last_engineer":1023,"callback":{"id":1754,"client_id":982,"contact_id":2493,"description":"","callback_date":"2019-05-20","created_by":5015,"created_at":"2019-05-20 14:31:52","updated_at":"2019-05-20 14:31:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2464,"mp_submit_contact_id":null}}],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":982,"taxonomy_id":304,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","y":100}]},{"id":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1903994","status3_profits":"267.59800000000000000000","status3_count":2,"status3_pct":0.01,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"3\u5e748\u4e2a\u670829\u5929","created_at":"2021-11-22 11:11:50","work_time":0,"work_count":0,"last_bargain_date":"2025-04-07","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"38","collected":"1903994","un_collected":"0","invoices":"1903994.00","un_invoices":"0.00","project_count":2,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2117,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"1900000","sum2":"0","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1898400","status3_profits":"11580.2400000000000000","status3_count":2,"status3_pct":0.61,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"1\u5e743\u4e2a\u670813\u5929","created_at":"2024-05-07 16:42:41","work_time":0,"work_count":0,"last_bargain_date":"2024-06-13","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u5a92\u4f53","client_industry_id":18,"client_type":"\u592e\u4f01","client_type_id":6,"score":"43","collected":"1898400","un_collected":"0","invoices":"1898400.00","un_invoices":"0.00","project_count":2,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":3009,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"1898400","sum2":"11580.24","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":3009,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"1898400","sum2":"11580.24","y":100}]},{"id":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1620993","status3_profits":"20383.5241000000000000","status3_count":6,"status3_pct":1.26,"status1_budgets":"0","status1_count":0,"status2_budgets":"122","status2_count":1,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"2\u5e741\u4e2a\u670810\u5929","created_at":"2023-07-10 17:27:02","work_time":0,"work_count":0,"last_bargain_date":"2025-07-21","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"45","collected":"735693","un_collected":"885300","invoices":"735693.00","un_invoices":"885300.00","project_count":7,"other_budgets":"122","used_clients":0,"status12_budgets":"122","status12_profits":"120.9996000000000000","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2553,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"648693","sum2":"-4404.3959","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":2589,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1570760.49","status3_profits":"-17592.517488000000","status3_count":1,"status3_pct":-1.12,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"1\u5e7411\u4e2a\u670813\u5929","created_at":"2023-09-08 09:16:56","work_time":0,"work_count":0,"last_bargain_date":"2023-09-07","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"13","collected":"1570760.49","un_collected":"0.00","invoices":"1570760.49","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":1,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2589,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"1570760.49","sum2":"-17592.517488","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":2520,"name":"\u5317\u4eac\u5168\u65b0\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1541710","status3_profits":"19579.717000000000","status3_count":1,"status3_pct":1.27,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":19,"service_time":"95.59","service_count":19,"sales_rep_time":"2\u5e745\u4e2a\u6708","created_at":"2023-03-20 15:07:25","work_time":0,"work_count":0,"last_bargain_date":"2023-03-17","reimbursement_amount":"2557.52","points":"1516","cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"13","collected":"1541710","un_collected":"0","invoices":"1541710.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2520,"taxonomy_id":229,"name":"\u4e91\u8ba1\u7b97","sum":"1541710","sum2":"19579.717","y":100}],"preSalesEngineers":[],"implementEngineers":[{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5296,"key":5296,"name":"\u8d75\u5b87","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"completedImplementCases":[{"id":6060,"client_id":2520,"last_engineer":1022,"callback":{"id":5133,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-04-26","created_by":5311,"created_at":"2023-04-26 10:05:04","updated_at":"2023-04-26 10:05:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6060,"mp_submit_contact_id":null}},{"id":6061,"client_id":2520,"last_engineer":1015,"callback":{"id":5134,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-04-26","created_by":5311,"created_at":"2023-04-26 10:05:18","updated_at":"2023-04-26 10:05:18","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6061,"mp_submit_contact_id":null}},{"id":6083,"client_id":2520,"last_engineer":1022,"callback":{"id":5154,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-05","created_by":5311,"created_at":"2023-05-05 10:47:27","updated_at":"2023-05-05 10:47:27","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6083,"mp_submit_contact_id":null}},{"id":6089,"client_id":2520,"last_engineer":1022,"callback":{"id":5160,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-06","created_by":5311,"created_at":"2023-05-06 10:21:21","updated_at":"2023-05-06 10:21:21","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6089,"mp_submit_contact_id":null}},{"id":6090,"client_id":2520,"last_engineer":5296,"callback":{"id":5159,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-06","created_by":5311,"created_at":"2023-05-06 10:21:01","updated_at":"2023-05-06 10:21:01","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6090,"mp_submit_contact_id":null}},{"id":6084,"client_id":2520,"last_engineer":5296,"callback":{"id":5153,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-05","created_by":5311,"created_at":"2023-05-05 10:47:08","updated_at":"2023-05-05 10:47:08","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6084,"mp_submit_contact_id":null}},{"id":6094,"client_id":2520,"last_engineer":1022,"callback":{"id":5162,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-08","created_by":5311,"created_at":"2023-05-08 10:36:57","updated_at":"2023-05-08 10:36:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6094,"mp_submit_contact_id":null}},{"id":6095,"client_id":2520,"last_engineer":5296,"callback":{"id":5161,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-08","created_by":5311,"created_at":"2023-05-08 10:36:38","updated_at":"2023-05-08 10:36:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6095,"mp_submit_contact_id":null}},{"id":6098,"client_id":2520,"last_engineer":1022,"callback":{"id":5167,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-08","created_by":5311,"created_at":"2023-05-08 15:11:46","updated_at":"2023-05-08 15:11:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6098,"mp_submit_contact_id":null}},{"id":6109,"client_id":2520,"last_engineer":1022,"callback":{"id":5173,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-05-11","created_by":5311,"created_at":"2023-05-11 10:42:00","updated_at":"2023-05-11 10:42:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6109,"mp_submit_contact_id":null}},{"id":6102,"client_id":2520,"last_engineer":1022,"callback":{"id":5169,"client_id":2520,"contact_id":4536,"description":"","callback_date":"2023-05-09","created_by":5311,"created_at":"2023-05-09 15:48:18","updated_at":"2023-05-09 15:48:18","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6102,"mp_submit_contact_id":null}},{"id":6400,"client_id":2520,"last_engineer":1022,"callback":{"id":5463,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-07-31","created_by":5311,"created_at":"2023-07-31 14:40:01","updated_at":"2023-07-31 14:40:01","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6400,"mp_submit_contact_id":null}},{"id":6405,"client_id":2520,"last_engineer":5248,"callback":{"id":5464,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-07-31","created_by":5311,"created_at":"2023-07-31 14:40:50","updated_at":"2023-07-31 14:40:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6405,"mp_submit_contact_id":null}},{"id":6409,"client_id":2520,"last_engineer":1022,"callback":{"id":5469,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-08-01","created_by":5311,"created_at":"2023-08-01 11:02:27","updated_at":"2023-08-01 11:02:27","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6409,"mp_submit_contact_id":null}},{"id":6408,"client_id":2520,"last_engineer":5248,"callback":{"id":5470,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-08-01","created_by":5311,"created_at":"2023-08-01 11:02:47","updated_at":"2023-08-01 11:02:47","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6408,"mp_submit_contact_id":null}},{"id":6395,"client_id":2520,"last_engineer":5248,"callback":{"id":5462,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-07-31","created_by":5311,"created_at":"2023-07-31 14:39:40","updated_at":"2023-07-31 14:39:40","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6395,"mp_submit_contact_id":null}},{"id":6433,"client_id":2520,"last_engineer":1022,"callback":{"id":5490,"client_id":2520,"contact_id":4536,"description":"","callback_date":"2023-08-03","created_by":5311,"created_at":"2023-08-03 16:26:00","updated_at":"2023-08-03 16:26:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6433,"mp_submit_contact_id":null}},{"id":6434,"client_id":2520,"last_engineer":1022,"callback":{"id":5491,"client_id":2520,"contact_id":4536,"description":"","callback_date":"2023-08-03","created_by":5311,"created_at":"2023-08-03 16:26:11","updated_at":"2023-08-03 16:26:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6434,"mp_submit_contact_id":null}},{"id":6543,"client_id":2520,"last_engineer":5296,"callback":{"id":5601,"client_id":2520,"contact_id":4536,"description":"\u672a\u56de\u8bbf","callback_date":"2023-09-15","created_by":5311,"created_at":"2023-09-15 16:57:58","updated_at":"2023-09-15 16:57:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6543,"mp_submit_contact_id":null}}],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":2520,"taxonomy_id":229,"name":"\u4e91\u8ba1\u7b97","sum":"1541710","sum2":"19579.717","y":100}]},{"id":2500,"name":"\u6b66\u6c49\u745e\u5347\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1526170","status3_profits":"1373.5530000000000000","status3_count":1,"status3_pct":0.09,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"2\u5e747\u4e2a\u670823\u5929","created_at":"2022-12-29 14:24:02","work_time":0,"work_count":0,"last_bargain_date":"2022-12-29","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"13","collected":"1526170","un_collected":"0","invoices":"1526170.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2500,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"1526170","sum2":"1373.553","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":2500,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"1526170","sum2":"1373.553","y":100}]},{"id":2540,"name":"\u4e0a\u6d77\u7ffc\u534e\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1512000","status3_profits":"-14212.800000000000","status3_count":1,"status3_pct":-0.94,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"2\u5e742\u4e2a\u670829\u5929","created_at":"2023-05-22 14:56:16","work_time":0,"work_count":0,"last_bargain_date":"2023-05-23","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u5176\u4ed6","client_industry_id":20,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"21","collected":"1512000","un_collected":"0","invoices":"1512000.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2540,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"1512000","sum2":"-14212.8","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":2836,"name":"\u5317\u4eac\u4e2d\u8bda\u7f51\u5b89\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"status3_budgets":"1212058.6","status3_profits":"-6920.8644400000000000","status3_count":2,"status3_pct":-0.57,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"1\u5e744\u4e2a\u67085\u5929","created_at":"2024-04-15 15:05:33","work_time":0,"work_count":0,"last_bargain_date":"2024-04-25","reimbursement_amount":"113.20","points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"38","collected":"1212058.6","un_collected":"0.0","invoices":"1212058.60","un_invoices":"0.00","project_count":2,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2836,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"1212058.6","sum2":"-6920.86444","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":1956,"name":"\u5ea6\u5c0f\u6ee1\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"1066393.00","status3_profits":"0.00000000000000000000","status3_count":1,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"4\u5e749\u4e2a\u670815\u5929","created_at":"2020-11-06 09:35:00","work_time":0,"work_count":0,"last_bargain_date":"2020-11-10","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u91d1\u878d","client_industry_id":10,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"25","collected":"1066393","un_collected":"0.00","invoices":"1066393.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":1956,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"1066393","sum2":"0","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"898318","status3_profits":"219599.1544000000000000","status3_count":10,"status3_pct":24.45,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":2,"service_time":"3.4","service_count":2,"sales_rep_time":"2\u5e742\u4e2a\u67087\u5929","created_at":"2023-06-14 09:45:51","work_time":0,"work_count":0,"last_bargain_date":"2025-06-24","reimbursement_amount":"607.33","points":"62","cooperated":true,"client_industry":"\u91d1\u878d","client_industry_id":10,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"50","collected":"898318","un_collected":"0","invoices":"898318.00","un_invoices":"0.00","project_count":10,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2545,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"437700","sum2":"126288.77","y":62.5},{"client_id":2545,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"198800","sum2":"47175.24","y":28.39},{"client_id":2545,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"14766","sum2":"1007.0412","y":2.11},{"client_id":2545,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"49000","sum2":"3341.8","y":7}],"preSalesEngineers":[],"implementEngineers":[{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"completedImplementCases":[{"id":7722,"client_id":2545,"last_engineer":5248,"callback":{"id":6744,"client_id":2545,"contact_id":4640,"description":"","callback_date":"2024-08-27","created_by":5413,"created_at":"2024-08-27 10:17:57","updated_at":"2024-08-27 10:17:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7722,"mp_submit_contact_id":null}},{"id":8101,"client_id":2545,"last_engineer":1015,"callback":{"id":7126,"client_id":2545,"contact_id":4640,"description":"","callback_date":"2025-01-15","created_by":5413,"created_at":"2025-01-15 13:20:46","updated_at":"2025-01-15 13:20:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8101,"mp_submit_contact_id":null}}],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":2545,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"437700","sum2":"126288.77","y":71.02},{"client_id":2545,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"198800","sum2":"47175.24","y":26.53},{"client_id":2545,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"14766","sum2":"1007.0412","y":0.57},{"client_id":2545,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"49000","sum2":"3341.8","y":1.88}]},{"id":1077,"name":"\u5317\u4eac\u4e5d\u8760\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"875000","status3_profits":"17587.500000000000","status3_count":1,"status3_pct":2.01,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"7\u5e7425\u5929","created_at":"2018-07-26 17:31:47","work_time":0,"work_count":0,"last_bargain_date":"2018-05-16","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"17","collected":"875000","un_collected":"0","invoices":"875000.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":1077,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"875000","sum2":"17587.5","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":1077,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"875000","sum2":"17587.5","y":100}]},{"id":1039,"name":"\u4e0a\u6d77\u5951\u4f73\u7ecf\u8d38\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"687000","status3_profits":"8175.3000000000000000","status3_count":1,"status3_pct":1.19,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"7\u5e742\u4e2a\u670812\u5929","created_at":"2018-06-08 15:19:49","work_time":0,"work_count":0,"last_bargain_date":"2018-06-05","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"13","collected":"687000","un_collected":"0","invoices":"687000.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":1039,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"687000","sum2":"8175.3","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[{"client_id":1039,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"687000","sum2":"8175.3","y":100}]},{"id":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"status3_budgets":"570000","status3_profits":"13851.000000000000","status3_count":1,"status3_pct":2.43,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"3\u4e2a\u67086\u5929","created_at":"2025-05-14 16:30:29","work_time":0,"work_count":0,"last_bargain_date":"2025-05-19","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"35","collected":"570000","un_collected":"0","invoices":"570000.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","sales_rep":1001,"status3_budgets":"562088.90","status3_profits":"-2975.4765060000000000","status3_count":3,"status3_pct":-0.53,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"1\u5e743\u4e2a\u670825\u5929","created_at":"2024-04-26 09:27:41","work_time":0,"work_count":0,"last_bargain_date":"2025-05-28","reimbursement_amount":"85.03","points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"35","collected":"562088.90","un_collected":"0.00","invoices":"562088.90","un_invoices":"0.00","project_count":3,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2845,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"529531.9","sum2":"-3114.20476","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]},{"id":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"560255","status3_profits":"360402.09330000000000000000","status3_count":4,"status3_pct":64.33,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"1\u5e741\u4e2a\u670825\u5929","created_at":"2024-06-26 10:41:52","work_time":0,"work_count":0,"last_bargain_date":"2025-08-20","reimbursement_amount":"121.83","points":0,"cooperated":true,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u5546\u4e1a","client_type_id":5,"score":"35","collected":"198354","un_collected":"361901","invoices":"198354.00","un_invoices":"361901.00","project_count":4,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0,"work1_count":0,"work2_time":0,"work2_count":0,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":3278,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"198354","sum2":"-1408.3134","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u5218\u4eba\u8bda","datas2":[]}],"pagenation":{"totalcount":60,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-21 14:53:08') RETURNING "id"
14:53:08.4642.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_cases" WHERE "client_id" IN (3296, 3334, 1661, 2115, 982, 2117, 3009, 2553, 2589, 2520, 2500, 2540, 2836, 1956, 2545, 1077, 1039, 3364, 2845, 3278)
14:53:08.4862.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_cases" WHERE "client_id" IN (3296, 3334, 1661, 2115, 982, 2117, 3009, 2553, 2589, 2520, 2500, 2540, 2836, 1956, 2545, 1077, 1039, 3364, 2845, 3278)
14:53:08.2742.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:53:08.4622.0 msyii\db\Command::querySELECT client_id, taxonomy_id, tt.name, sum(ttr.value::FLOAT) as sum, sum(ttr.value::FLOAT * ttr.extra_int / 100) as sum2 FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 1 AND ttr.object_type = 1 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON ttr.taxonomy_id = tt.id WHERE (taxonomy_id is not null) AND ("project_status"='3') AND (value is not null) AND ("p"."client_id" IN (3296, 3334, 1661, 2115, 982, 2117, 3009, 2553, 2589, 2520, 2500, 2540, 2836, 1956, 2545, 1077, 1039, 3364, 2845, 3278)) GROUP BY "client_id", "taxonomy_id", "tt"."name"
14:53:08.2721.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:53:08.2771.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:53:08.4971.4 msyii\db\Command::querySELECT "id", "client_id", "last_engineer" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status"=5) AND ("case_type"=2) AND ("client_id" IN (3296, 3334, 1661, 2115, 982, 2117, 3009, 2553, 2589, 2520, 2500, 2540, 2836, 1956, 2545, 1077, 1039, 3364, 2845, 3278))
14:53:08.5061.1 msyii\db\Command::querySELECT "id", "client_id", "last_engineer" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status"=5) AND ("case_type"=1) AND ("client_id" IN (3296, 3334, 1661, 2115, 982, 2117, 3009, 2553, 2589, 2520, 2500, 2540, 2836, 1956, 2545, 1077, 1039, 3364, 2845, 3278))
14:53:08.5170.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=7, "last_visit_at"='now()' WHERE "id"=55357
14:53:08.4860.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 5074, 1022, 1023, 1020, 1001)
14:53:08.4960.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5309, 1001, 1016, 1023, 5125, 1005, 1022, 1015, 5296, 5248)