6a1feaa62f422: POST https://beta.jinchangxiao.com/vue/analysis/clients at 2026-06-03 04:49:42 pm by 221.216.117.119
Performance Profiling
Total processing time: 131 ms; Peak memory: 6.512 MB. Show Profiling Timeline
总计17条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:49:42.212 | 59.8 ms | yii\db\Command::query | 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 tmp_project_period.status3_budgets IS NULL THEN 0 ELSE tmp_project_period.status3_budgets END AS status3_budgets, CASE WHEN tmp_project_period.status3_profits IS NULL THEN 0 ELSE tmp_project_period.status3_profits END AS status3_profits, CASE WHEN tmp_project_period.status3_budgets IS NULL OR tmp_project_period.status3_budgets = 0 THEN 0 ELSE tmp_project_period.status3_profits / tmp_project_period.status3_budgets END AS status3_pct, CASE WHEN tmp_project_period.status3_count IS NULL THEN 0 ELSE tmp_project_period.status3_count END AS status3_count, CASE WHEN tmp_project_period.collected IS NULL THEN 0 ELSE tmp_project_period.collected END AS collected, CASE WHEN tmp_project_period.used_clients IS NULL THEN 0 ELSE tmp_project_period.used_clients END AS used_clients, CASE WHEN tmp_project_period.un_collected IS NULL THEN 0 ELSE tmp_project_period.un_collected END AS un_collected, CASE WHEN tmp_project_period.status1_budgets IS NULL THEN 0 ELSE tmp_project_period.status1_budgets END AS status1_budgets, CASE WHEN tmp_project_period.status1_count IS NULL THEN 0 ELSE tmp_project_period.status1_count END AS status1_count, CASE WHEN tmp_project_period.status2_budgets IS NULL THEN 0 ELSE tmp_project_period.status2_budgets END AS status2_budgets, CASE WHEN tmp_project_period.status2_count IS NULL THEN 0 ELSE tmp_project_period.status2_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 tmp_work.work_time IS NOT NULL THEN tmp_work.work_time ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp_work.work_count IS NOT NULL THEN tmp_work.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, tmp_project_period.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, CASE WHEN tmp_project_period.status3_count IS NULL OR tmp_project_period.status3_count = 0 THEN NULL ELSE tmp_project_period.status3_count END 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 tmp_project_all.project_count IS NULL THEN 0 ELSE tmp_project_all.project_count END AS project_count, CASE WHEN tmp_project_all.other_budgets IS NULL THEN 0 ELSE tmp_project_all.other_budgets END AS other_budgets, CASE WHEN tmp_project_period.status12_budgets IS NULL THEN 0 ELSE tmp_project_period.status12_budgets END AS status12_budgets, CASE WHEN tmp_project_period.status12_profits IS NULL THEN 0 ELSE tmp_project_period.status12_profits END AS status12_profits, CASE WHEN tmp_work.work1_time IS NOT NULL THEN tmp_work.work1_time ELSE '00:00:00'::interval END AS work1_time, CASE WHEN tmp_work.work1_count IS NOT NULL THEN tmp_work.work1_count ELSE 0 END AS work1_count, CASE WHEN tmp_work.work2_time IS NOT NULL THEN tmp_work.work2_time ELSE '00:00:00'::interval END AS work2_time, CASE WHEN tmp_work.work2_count IS NOT NULL THEN tmp_work.work2_count ELSE 0 END AS work2_count, CASE WHEN tmp_work.work3_time IS NOT NULL THEN tmp_work.work3_time ELSE '00:00:00'::interval END AS work3_time, CASE WHEN tmp_work.work3_count IS NOT NULL THEN tmp_work.work3_count ELSE 0 END AS work3_count, CASE WHEN tmp_work.work4_time IS NOT NULL THEN tmp_work.work4_time ELSE '00:00:00'::interval END AS work4_time, CASE WHEN tmp_work.work4_count IS NOT NULL THEN tmp_work.work4_count ELSE 0 END AS work4_count, CASE WHEN tmp_work.work5_time IS NOT NULL THEN tmp_work.work5_time ELSE '00:00:00'::interval END AS work5_time, CASE WHEN tmp_work.work5_count IS NOT NULL THEN tmp_work.work5_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 154::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 154::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 (SELECT p.client_id, sum(CASE WHEN p.project_status = 3 THEN p.budget ELSE 0 END) AS status3_budgets, sum(CASE WHEN p.project_status = 3 THEN p.budget * p.profit_pct / 100 ELSE 0 END) AS status3_profits, max(CASE WHEN p.project_status = 3 THEN p.bargain_date ELSE NULL END) AS last_bargain_date, sum(CASE WHEN p.project_status = 3 AND p.budget >= p.collected THEN p.budget - p.collected ELSE 0 END) AS un_collected, sum(CASE WHEN p.project_status = 3 THEN p.collected ELSE 0 END) AS collected, count(CASE WHEN p.project_status = 3 THEN p.id ELSE NULL END) as status3_count, count(distinct CASE WHEN p.project_status = 3 THEN p.used_client ELSE NULL END) as used_clients, sum(CASE WHEN p.project_status = 1 THEN p.budget ELSE 0 END) AS status1_budgets, count(CASE WHEN p.project_status = 1 THEN p.id ELSE NULL END) as status1_count, sum(CASE WHEN p.project_status = 2 THEN p.budget ELSE 0 END) AS status2_budgets, count(CASE WHEN p.project_status = 2 THEN p.id ELSE NULL END) as status2_count, sum(CASE WHEN p.project_status IN (1, 2) THEN p.budget ELSE 0 END) AS status12_budgets, sum(CASE WHEN p.project_status IN (1, 2) THEN p.budget * p.profit_pct / 100 ELSE 0 END) AS status12_profits FROM "a57be577deb434"."tbl_projects" "p" WHERE "p"."project_status" IN (1, 2, 3) GROUP BY "p"."client_id") "tmp_project_period" ON tmp_project_period.client_id = c.id LEFT JOIN (SELECT p.client_id, count(p.id) as project_count, sum(CASE WHEN p.project_status != 3 THEN p.budget ELSE 0 END) AS other_budgets FROM "a57be577deb434"."tbl_projects" "p" GROUP BY "p"."client_id") "tmp_project_all" ON tmp_project_all.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 wl.client_id, count(CASE WHEN wl.location_in_id IS NOT NULL AND wl.location_out_id IS NOT NULL THEN wl.id ELSE NULL END) as work_count, sum(CASE WHEN wl.location_in_id IS NOT NULL AND wl.location_out_id IS NOT NULL THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work_time, count(CASE WHEN wl.scenario_id = 1 THEN wl.id ELSE NULL END) as work1_count, sum(CASE WHEN wl.scenario_id = 1 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work1_time, count(CASE WHEN wl.scenario_id = 2 THEN wl.id ELSE NULL END) as work2_count, sum(CASE WHEN wl.scenario_id = 2 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work2_time, count(CASE WHEN wl.scenario_id = 3 THEN wl.id ELSE NULL END) as work3_count, sum(CASE WHEN wl.scenario_id = 3 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work3_time, count(CASE WHEN wl.scenario_id = 4 THEN wl.id ELSE NULL END) as work4_count, sum(CASE WHEN wl.scenario_id = 4 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work4_time, count(CASE WHEN wl.scenario_id = 5 THEN wl.id ELSE NULL END) as work5_count, sum(CASE WHEN wl.scenario_id = 5 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work5_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."client_id" IS NOT NULL) GROUP BY "wl"."client_id") "tmp_work" ON tmp_work.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 "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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."deleted"=FALSE) AND ((lower(c.name) LIKE '%测%') OR ("c"."pinyin_shortcut" LIKE '%测%'))) "final" ORDER BY "status3_budgets" DESC, "created_at" DESC LIMIT 20 |
| 16:49:42.201 | 10.1 ms | yii\db\Command::query | SELECT 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 tmp_project_period.status3_budgets IS NULL THEN 0 ELSE tmp_project_period.status3_budgets END AS status3_budgets, CASE WHEN tmp_project_period.status3_profits IS NULL THEN 0 ELSE tmp_project_period.status3_profits END AS status3_profits, CASE WHEN tmp_project_period.status3_budgets IS NULL OR tmp_project_period.status3_budgets = 0 THEN 0 ELSE tmp_project_period.status3_profits / tmp_project_period.status3_budgets END AS status3_pct, CASE WHEN tmp_project_period.status3_count IS NULL THEN 0 ELSE tmp_project_period.status3_count END AS status3_count, CASE WHEN tmp_project_period.collected IS NULL THEN 0 ELSE tmp_project_period.collected END AS collected, CASE WHEN tmp_project_period.used_clients IS NULL THEN 0 ELSE tmp_project_period.used_clients END AS used_clients, CASE WHEN tmp_project_period.un_collected IS NULL THEN 0 ELSE tmp_project_period.un_collected END AS un_collected, CASE WHEN tmp_project_period.status1_budgets IS NULL THEN 0 ELSE tmp_project_period.status1_budgets END AS status1_budgets, CASE WHEN tmp_project_period.status1_count IS NULL THEN 0 ELSE tmp_project_period.status1_count END AS status1_count, CASE WHEN tmp_project_period.status2_budgets IS NULL THEN 0 ELSE tmp_project_period.status2_budgets END AS status2_budgets, CASE WHEN tmp_project_period.status2_count IS NULL THEN 0 ELSE tmp_project_period.status2_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 tmp_work.work_time IS NOT NULL THEN tmp_work.work_time ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp_work.work_count IS NOT NULL THEN tmp_work.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, tmp_project_period.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, CASE WHEN tmp_project_period.status3_count IS NULL OR tmp_project_period.status3_count = 0 THEN NULL ELSE tmp_project_period.status3_count END 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 tmp_project_all.project_count IS NULL THEN 0 ELSE tmp_project_all.project_count END AS project_count, CASE WHEN tmp_project_all.other_budgets IS NULL THEN 0 ELSE tmp_project_all.other_budgets END AS other_budgets, CASE WHEN tmp_project_period.status12_budgets IS NULL THEN 0 ELSE tmp_project_period.status12_budgets END AS status12_budgets, CASE WHEN tmp_project_period.status12_profits IS NULL THEN 0 ELSE tmp_project_period.status12_profits END AS status12_profits, CASE WHEN tmp_work.work1_time IS NOT NULL THEN tmp_work.work1_time ELSE '00:00:00'::interval END AS work1_time, CASE WHEN tmp_work.work1_count IS NOT NULL THEN tmp_work.work1_count ELSE 0 END AS work1_count, CASE WHEN tmp_work.work2_time IS NOT NULL THEN tmp_work.work2_time ELSE '00:00:00'::interval END AS work2_time, CASE WHEN tmp_work.work2_count IS NOT NULL THEN tmp_work.work2_count ELSE 0 END AS work2_count, CASE WHEN tmp_work.work3_time IS NOT NULL THEN tmp_work.work3_time ELSE '00:00:00'::interval END AS work3_time, CASE WHEN tmp_work.work3_count IS NOT NULL THEN tmp_work.work3_count ELSE 0 END AS work3_count, CASE WHEN tmp_work.work4_time IS NOT NULL THEN tmp_work.work4_time ELSE '00:00:00'::interval END AS work4_time, CASE WHEN tmp_work.work4_count IS NOT NULL THEN tmp_work.work4_count ELSE 0 END AS work4_count, CASE WHEN tmp_work.work5_time IS NOT NULL THEN tmp_work.work5_time ELSE '00:00:00'::interval END AS work5_time, CASE WHEN tmp_work.work5_count IS NOT NULL THEN tmp_work.work5_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 154::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 154::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 (SELECT p.client_id, sum(CASE WHEN p.project_status = 3 THEN p.budget ELSE 0 END) AS status3_budgets, sum(CASE WHEN p.project_status = 3 THEN p.budget * p.profit_pct / 100 ELSE 0 END) AS status3_profits, max(CASE WHEN p.project_status = 3 THEN p.bargain_date ELSE NULL END) AS last_bargain_date, sum(CASE WHEN p.project_status = 3 AND p.budget >= p.collected THEN p.budget - p.collected ELSE 0 END) AS un_collected, sum(CASE WHEN p.project_status = 3 THEN p.collected ELSE 0 END) AS collected, count(CASE WHEN p.project_status = 3 THEN p.id ELSE NULL END) as status3_count, count(distinct CASE WHEN p.project_status = 3 THEN p.used_client ELSE NULL END) as used_clients, sum(CASE WHEN p.project_status = 1 THEN p.budget ELSE 0 END) AS status1_budgets, count(CASE WHEN p.project_status = 1 THEN p.id ELSE NULL END) as status1_count, sum(CASE WHEN p.project_status = 2 THEN p.budget ELSE 0 END) AS status2_budgets, count(CASE WHEN p.project_status = 2 THEN p.id ELSE NULL END) as status2_count, sum(CASE WHEN p.project_status IN (1, 2) THEN p.budget ELSE 0 END) AS status12_budgets, sum(CASE WHEN p.project_status IN (1, 2) THEN p.budget * p.profit_pct / 100 ELSE 0 END) AS status12_profits FROM "a57be577deb434"."tbl_projects" "p" WHERE "p"."project_status" IN (1, 2, 3) GROUP BY "p"."client_id") "tmp_project_period" ON tmp_project_period.client_id = c.id LEFT JOIN (SELECT p.client_id, count(p.id) as project_count, sum(CASE WHEN p.project_status != 3 THEN p.budget ELSE 0 END) AS other_budgets FROM "a57be577deb434"."tbl_projects" "p" GROUP BY "p"."client_id") "tmp_project_all" ON tmp_project_all.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 wl.client_id, count(CASE WHEN wl.location_in_id IS NOT NULL AND wl.location_out_id IS NOT NULL THEN wl.id ELSE NULL END) as work_count, sum(CASE WHEN wl.location_in_id IS NOT NULL AND wl.location_out_id IS NOT NULL THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work_time, count(CASE WHEN wl.scenario_id = 1 THEN wl.id ELSE NULL END) as work1_count, sum(CASE WHEN wl.scenario_id = 1 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work1_time, count(CASE WHEN wl.scenario_id = 2 THEN wl.id ELSE NULL END) as work2_count, sum(CASE WHEN wl.scenario_id = 2 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work2_time, count(CASE WHEN wl.scenario_id = 3 THEN wl.id ELSE NULL END) as work3_count, sum(CASE WHEN wl.scenario_id = 3 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work3_time, count(CASE WHEN wl.scenario_id = 4 THEN wl.id ELSE NULL END) as work4_count, sum(CASE WHEN wl.scenario_id = 4 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work4_time, count(CASE WHEN wl.scenario_id = 5 THEN wl.id ELSE NULL END) as work5_count, sum(CASE WHEN wl.scenario_id = 5 THEN wl.end_at - wl.start_at ELSE '00:00:00'::interval END) as work5_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."client_id" IS NOT NULL) GROUP BY "wl"."client_id") "tmp_work" ON tmp_work.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 "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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."deleted"=FALSE) AND ((lower(c.name) LIKE '%测%') OR ("c"."pinyin_shortcut" LIKE '%测%'))) "final" ORDER BY "status3_budgets" DESC, "created_at" DESC) "c" |
| 16:49:42.272 | 8.7 ms | yii\db\Command::query | SELECT 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 (1121, 539, 1034, 2526, 166, 3457, 1425, 3459, 3300, 3217, 3170, 2446, 2436, 2285, 2272, 2151, 2105, 2000, 56)) GROUP BY "client_id", "taxonomy_id", "tt"."name" |
| 16:49:42.296 | 7.9 ms | yii\db\Command::query | SELECT "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 (5020, 4814, 4815, 4660, 5040, 5125, 5224, 5028, 4786, 4690, 4787, 4788, 4789, 3414, 3475, 3498, 3517, 3528, 5134, 2093, 2198, 2170, 2187, 1769, 2370, 4379, 1992, 2094, 2199, 2305, 1993, 1999, 2095, 2134, 2164, 2200, 2306, 1761, 2046, 2096, 2126, 2135, 2165, 4395, 2012, 2057, 2114, 2217, 2229, 2202, 2308, 2451, 2218, 2175, 2230, 2167, 2514, 1968, 2129, 2099, 2152, 2281, 2433, 2050, 2153, 2100, 2139, 2232, 2169, 2205, 2220, 2323, 1766, 1814, 2101, 2233, 2221, 2206, 2273, 2324, 2586, 1733, 1786, 2052, 2141, 2119, 2196, 1868, 2007, 2142, 2156, 2285, 2314, 2589, 1840, 2143, 2366, 2539, 2144, 2367, 2540, 2576, 2211, 2184, 2160, 2212, 2042, 2161, 2186, 2263, 1951, 2564, 2446, 2565, 2547, 2567, 96, 4156, 145, 254, 906, 938, 940, 990, 4170, 4124, 1359, 1406, 1492, 1531, 1532, 1555, 1571, 1652, 1687, 1690, 1692, 1718, 2605, 2876, 3121, 4101, 3317, 3329, 3324, 3405, 3417, 3419, 3404, 3420, 3418, 3616, 3619, 3841, 3945, 3985, 4564, 4559, 4565, 5285, 5266, 5275, 5273, 5274, 5368, 5488, 5471, 5593, 5915, 6065, 6187, 6424, 6471, 6616, 6675, 6644, 6717, 6854, 6822, 6867, 6977, 6978, 7036, 7157, 7284, 7453, 7667, 7974, 7972, 8023, 8057, 8031, 8032, 8217, 8408, 8389, 8546, 8655, 8638, 8700, 9051, 9158)) |
| 16:49:42.284 | 7.6 ms | yii\db\Command::query | SELECT "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 (5020, 4814, 4815, 4660, 5040, 5125, 5224, 5028, 4786, 4690, 4787, 4788, 4789, 3414, 3475, 3498, 3517, 3528, 5134, 2093, 2198, 2170, 2187, 1769, 2370, 4379, 1992, 2094, 2199, 2305, 1993, 1999, 2095, 2134, 2164, 2200, 2306, 1761, 2046, 2096, 2126, 2135, 2165, 4395, 2012, 2057, 2114, 2217, 2229, 2202, 2308, 2451, 2218, 2175, 2230, 2167, 2514, 1968, 2129, 2099, 2152, 2281, 2433, 2050, 2153, 2100, 2139, 2232, 2169, 2205, 2220, 2323, 1766, 1814, 2101, 2233, 2221, 2206, 2273, 2324, 2586, 1733, 1786, 2052, 2141, 2119, 2196, 1868, 2007, 2142, 2156, 2285, 2314, 2589, 1840, 2143, 2366, 2539, 2144, 2367, 2540, 2576, 2211, 2184, 2160, 2212, 2042, 2161, 2186, 2263, 1951, 2564, 2446, 2565, 2547, 2567, 96, 4156, 145, 254, 906, 938, 940, 990, 4170, 4124, 1359, 1406, 1492, 1531, 1532, 1555, 1571, 1652, 1687, 1690, 1692, 1718, 2605, 2876, 3121, 4101, 3317, 3329, 3324, 3405, 3417, 3419, 3404, 3420, 3418, 3616, 3619, 3841, 3945, 3985, 4564, 4559, 4565, 5285, 5266, 5275, 5273, 5274, 5368, 5488, 5471, 5593, 5915, 6065, 6187, 6424, 6471, 6616, 6675, 6644, 6717, 6854, 6822, 6867, 6977, 6978, 7036, 7157, 7284, 7453, 7667, 7974, 7972, 8023, 8057, 8031, 8032, 8217, 8408, 8389, 8546, 8655, 8638, 8700, 9051, 9158)) |
| 16:49:42.306 | 5.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "case_id" IN (5020, 4660, 5040, 5224, 5028, 4786, 4690, 4787, 4788, 4789, 3414, 3528, 5134, 2093, 2198, 2170, 2187, 2370, 4379, 1992, 2094, 2199, 2305, 1993, 1999, 2095, 2164, 2200, 2306, 2046, 2096, 2126, 4395, 2012, 2057, 2114, 2217, 2229, 2202, 2308, 2451, 2218, 2175, 2230, 2167, 2514, 1968, 2129, 2099, 2281, 2433, 2050, 2153, 2100, 2232, 2169, 2205, 2220, 2323, 2101, 2233, 2221, 2206, 2273, 2324, 2586, 2052, 2141, 2119, 2196, 2007, 2142, 2156, 2285, 2314, 2589, 2366, 2539, 2367, 2540, 2576, 2211, 2184, 2160, 2212, 2042, 2186, 2263, 1951, 2564, 2446, 2565, 2547, 2567, 4156, 145, 254, 938, 940, 4170, 4124, 2605, 2876, 3121, 4101, 3405, 3417, 3419, 3404, 3841, 3945, 5285, 5266, 5275, 5273, 5274, 5488, 5471, 5915, 6187, 6424, 6471, 6616, 6675, 6644, 6717, 6854, 6822, 6867, 6977, 6978, 7036, 7157, 7284, 7453, 7667, 7974, 7972, 8023, 8057, 8031, 8032, 8389, 8546, 8655, 8638, 8700, 9051, 9158) |
| 16:49:42.319 | 3.1 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/clients', '{"keyword":"\u6d4b","sales_rep":"","group":"","dataUserId":"1001","page":"1","engineer_group":"","engineer":"","period":"","cooperated":"","client_industry_id":"","client_type_id":"","GroupId":"","web_access_token":"3sqoTbqwkHhRmqiLIelKWucsK6N07HRT"}', '{"code":2000,"result":{"list":[{"id":1121,"name":"\u5317\u4eac\u4e1c\u65b9\u8ba1\u91cf\u6d4b\u8bd5\u7814\u7a76\u6240","sales_rep":5295,"status3_budgets":"1555043","status3_profits":"490498.4299000000000000","status3_count":12,"status3_pct":31.54,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":27,"ircount":111,"service_time":"646.08","service_count":138,"sales_rep_time":"7\u5e749\u4e2a\u67084\u5929","created_at":"2018-08-30 12:32:51","work_time":32.85,"work_count":35,"last_bargain_date":"2025-01-20","reimbursement_amount":"17902.95","points":"4569","cooperated":true,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":"71","collected":"1555043","un_collected":"0","invoices":"1555043.00","un_invoices":"0.00","project_count":19,"other_budgets":"8694000.00","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":282.15,"work1_count":262,"work2_time":10,"work2_count":2,"work3_time":2,"work3_count":1,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":1121,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"986543","sum2":"261569.6631","y":63.44},{"client_id":1121,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"221500","sum2":"123018.6","y":14.24},{"client_id":1121,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"347000","sum2":"77220","y":22.31}],"preSalesEngineers":[{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","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":1016,"key":1016,"name":"\u8346\u626c","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":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"implementEngineers":[{"id":1022,"key":1022,"name":"\u5f90\u7855","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},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5082,"key":5082,"name":"\u674e\u5fd7\u535a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5081,"key":5081,"name":"\u5f20\u4e19\u6668","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","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":5125,"key":5125,"name":"\u80e1\u6587\u5f3a","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":5247,"key":5247,"name":"\u5f20\u91d1\u9192","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"completedImplementCases":[{"id":5040,"client_id":1121,"last_engineer":1022,"callback":{"id":4168,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-02-16","created_by":5311,"created_at":"2022-02-16 16:17:09","updated_at":"2022-02-16 16:17:09","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5040,"mp_submit_contact_id":2632}},{"id":5028,"client_id":1121,"last_engineer":1022,"callback":{"id":4158,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-02-11","created_by":5015,"created_at":"2022-02-11 16:36:09","updated_at":"2022-02-11 16:36:09","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5028,"mp_submit_contact_id":2632}},{"id":4786,"client_id":1121,"last_engineer":1022,"callback":{"id":3939,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-11-08","created_by":5311,"created_at":"2021-11-06 16:35:25","updated_at":"2021-11-06 16:35:25","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4786,"mp_submit_contact_id":2632}},{"id":4690,"client_id":1121,"last_engineer":5296,"callback":{"id":3846,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-09-28","created_by":5311,"created_at":"2021-09-28 14:30:53","updated_at":"2021-09-28 14:30:53","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4690,"mp_submit_contact_id":null}},{"id":4787,"client_id":1121,"last_engineer":5248,"callback":{"id":3938,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-11-08","created_by":5311,"created_at":"2021-11-06 16:27:27","updated_at":"2021-11-06 16:27:27","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4787,"mp_submit_contact_id":2632}},{"id":4788,"client_id":1121,"last_engineer":5296,"callback":{"id":3937,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-11-08","created_by":5311,"created_at":"2021-11-06 16:27:00","updated_at":"2021-11-06 16:27:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4788,"mp_submit_contact_id":2632}},{"id":4789,"client_id":1121,"last_engineer":5085,"callback":{"id":3940,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-11-08","created_by":5311,"created_at":"2021-11-06 16:36:03","updated_at":"2021-11-06 16:36:03","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4789,"mp_submit_contact_id":2632}},{"id":3414,"client_id":1121,"last_engineer":1022,"callback":{"id":2650,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-05-07","created_by":null,"created_at":"2020-05-07 16:25:08","updated_at":"2020-05-07 16:25:08","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3414,"mp_submit_contact_id":null}},{"id":3528,"client_id":1121,"last_engineer":1022,"callback":{"id":2765,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-06-15","created_by":null,"created_at":"2020-06-15 15:22:54","updated_at":"2020-06-15 15:22:54","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3528,"mp_submit_contact_id":null}},{"id":5134,"client_id":1121,"last_engineer":1022,"callback":{"id":4260,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-04-07","created_by":5311,"created_at":"2022-04-07 10:48:02","updated_at":"2022-04-07 10:48:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5134,"mp_submit_contact_id":2632}},{"id":2093,"client_id":1121,"last_engineer":1022,"callback":{"id":1396,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 16:21:18","updated_at":"2018-12-21 16:21:18","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2093,"mp_submit_contact_id":null}},{"id":2198,"client_id":1121,"last_engineer":1022,"callback":{"id":1494,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-22","created_by":5015,"created_at":"2019-01-22 15:49:35","updated_at":"2019-01-22 15:49:35","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2198,"mp_submit_contact_id":null}},{"id":2170,"client_id":1121,"last_engineer":1022,"callback":{"id":1467,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-01-15","created_by":5015,"created_at":"2019-01-15 17:10:55","updated_at":"2019-01-15 17:10:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2170,"mp_submit_contact_id":null}},{"id":2187,"client_id":1121,"last_engineer":1022,"callback":{"id":1478,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-17","created_by":5015,"created_at":"2019-01-17 16:36:26","updated_at":"2019-01-17 16:36:26","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2187,"mp_submit_contact_id":null}},{"id":2370,"client_id":1121,"last_engineer":5082,"callback":{"id":1655,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-04-11","created_by":5015,"created_at":"2019-04-11 14:56:56","updated_at":"2019-04-11 14:56:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2370,"mp_submit_contact_id":null}},{"id":4379,"client_id":1121,"last_engineer":5296,"callback":{"id":3559,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-05-28","created_by":5015,"created_at":"2021-05-28 15:02:35","updated_at":"2021-05-28 15:02:35","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4379,"mp_submit_contact_id":null}},{"id":2094,"client_id":1121,"last_engineer":1022,"callback":{"id":1395,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 16:20:58","updated_at":"2018-12-21 16:20:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2094,"mp_submit_contact_id":null}},{"id":2199,"client_id":1121,"last_engineer":5082,"callback":{"id":1495,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-22","created_by":5015,"created_at":"2019-01-22 15:49:50","updated_at":"2019-01-22 15:49:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2199,"mp_submit_contact_id":null}},{"id":2305,"client_id":1121,"last_engineer":1022,"callback":{"id":1591,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-03-14","created_by":5015,"created_at":"2019-03-14 14:43:52","updated_at":"2019-03-14 14:43:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2305,"mp_submit_contact_id":null}},{"id":2095,"client_id":1121,"last_engineer":5081,"callback":{"id":1397,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 16:21:55","updated_at":"2018-12-21 16:21:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2095,"mp_submit_contact_id":null}},{"id":2164,"client_id":1121,"last_engineer":1022,"callback":{"id":1458,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-11","created_by":5015,"created_at":"2019-01-11 14:11:14","updated_at":"2019-01-11 14:11:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2164,"mp_submit_contact_id":null}},{"id":2200,"client_id":1121,"last_engineer":1016,"callback":{"id":1493,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-22","created_by":5015,"created_at":"2019-01-22 15:49:14","updated_at":"2019-01-22 15:49:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2200,"mp_submit_contact_id":null}},{"id":2306,"client_id":1121,"last_engineer":5082,"callback":{"id":1592,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-03-14","created_by":5015,"created_at":"2019-03-14 14:44:50","updated_at":"2019-03-14 14:44:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2306,"mp_submit_contact_id":null}},{"id":2096,"client_id":1121,"last_engineer":5082,"callback":{"id":1394,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 16:20:42","updated_at":"2018-12-21 16:20:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2096,"mp_submit_contact_id":null}},{"id":2126,"client_id":1121,"last_engineer":1022,"callback":{"id":1416,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-27","created_by":5015,"created_at":"2018-12-27 14:54:32","updated_at":"2018-12-27 14:54:32","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2126,"mp_submit_contact_id":null}},{"id":4395,"client_id":1121,"last_engineer":5296,"callback":{"id":3574,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-06-03","created_by":5015,"created_at":"2021-06-03 15:15:46","updated_at":"2021-06-03 15:15:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4395,"mp_submit_contact_id":null}},{"id":2012,"client_id":1121,"last_engineer":1022,"callback":{"id":1304,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-11-29","created_by":5015,"created_at":"2018-11-29 10:34:57","updated_at":"2018-11-29 10:34:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2012,"mp_submit_contact_id":null}},{"id":2057,"client_id":1121,"last_engineer":1022,"callback":{"id":1354,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-11","created_by":5015,"created_at":"2018-12-11 16:21:42","updated_at":"2018-12-11 16:21:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2057,"mp_submit_contact_id":null}},{"id":2114,"client_id":1121,"last_engineer":1022,"callback":{"id":1403,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-25","created_by":5015,"created_at":"2018-12-25 15:54:08","updated_at":"2018-12-25 15:54:08","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2114,"mp_submit_contact_id":null}},{"id":2217,"client_id":1121,"last_engineer":1022,"callback":{"id":1507,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-25","created_by":5015,"created_at":"2019-01-25 10:33:57","updated_at":"2019-01-25 10:33:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2217,"mp_submit_contact_id":null}},{"id":2229,"client_id":1121,"last_engineer":1022,"callback":{"id":1520,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-29","created_by":5015,"created_at":"2019-01-29 14:25:29","updated_at":"2019-01-29 14:25:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2229,"mp_submit_contact_id":null}},{"id":2308,"client_id":1121,"last_engineer":1022,"callback":{"id":1601,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-03-15","created_by":5015,"created_at":"2019-03-15 17:30:49","updated_at":"2019-03-15 17:30:49","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2308,"mp_submit_contact_id":null}},{"id":2218,"client_id":1121,"last_engineer":5082,"callback":{"id":1506,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-25","created_by":5015,"created_at":"2019-01-25 10:33:42","updated_at":"2019-01-25 10:33:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2218,"mp_submit_contact_id":null}},{"id":2230,"client_id":1121,"last_engineer":5082,"callback":{"id":1521,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-29","created_by":5015,"created_at":"2019-01-29 14:26:28","updated_at":"2019-01-29 14:26:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2230,"mp_submit_contact_id":null}},{"id":2167,"client_id":1121,"last_engineer":1022,"callback":{"id":1466,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-15","created_by":5015,"created_at":"2019-01-15 17:10:01","updated_at":"2019-01-15 17:10:01","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2167,"mp_submit_contact_id":null}},{"id":2514,"client_id":1121,"last_engineer":1022,"callback":{"id":1799,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-05-31","created_by":5015,"created_at":"2019-05-31 14:55:14","updated_at":"2019-05-31 14:55:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2514,"mp_submit_contact_id":null}},{"id":2129,"client_id":1121,"last_engineer":1022,"callback":{"id":1421,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-28","created_by":5015,"created_at":"2018-12-28 11:00:04","updated_at":"2018-12-28 11:00:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2129,"mp_submit_contact_id":null}},{"id":2281,"client_id":1121,"last_engineer":5082,"callback":{"id":1574,"client_id":1121,"contact_id":2494,"description":"","callback_date":"2019-03-07","created_by":5015,"created_at":"2019-03-07 15:25:38","updated_at":"2019-03-07 15:25:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2281,"mp_submit_contact_id":null}},{"id":2050,"client_id":1121,"last_engineer":1022,"callback":{"id":1353,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-10","created_by":5015,"created_at":"2018-12-10 17:44:28","updated_at":"2018-12-10 17:44:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2050,"mp_submit_contact_id":null}},{"id":2100,"client_id":1121,"last_engineer":1022,"callback":{"id":1404,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-25","created_by":5015,"created_at":"2018-12-25 15:54:43","updated_at":"2018-12-25 15:54:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2100,"mp_submit_contact_id":null}},{"id":2232,"client_id":1121,"last_engineer":1022,"callback":{"id":1528,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-30","created_by":5015,"created_at":"2019-01-30 16:46:16","updated_at":"2019-01-30 16:46:16","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2232,"mp_submit_contact_id":null}},{"id":2205,"client_id":1121,"last_engineer":1022,"callback":{"id":1502,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-24","created_by":5015,"created_at":"2019-01-24 15:09:14","updated_at":"2019-01-24 15:09:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2205,"mp_submit_contact_id":null}},{"id":2220,"client_id":1121,"last_engineer":1022,"callback":{"id":1517,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-28","created_by":5015,"created_at":"2019-01-28 15:45:20","updated_at":"2019-01-28 15:45:20","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2220,"mp_submit_contact_id":null}},{"id":2323,"client_id":1121,"last_engineer":1022,"callback":{"id":1613,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-03-21","created_by":5015,"created_at":"2019-03-21 14:55:12","updated_at":"2019-03-21 14:55:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2323,"mp_submit_contact_id":null}},{"id":2101,"client_id":1121,"last_engineer":5081,"callback":{"id":1393,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 16:20:17","updated_at":"2018-12-21 16:20:17","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2101,"mp_submit_contact_id":null}},{"id":2233,"client_id":1121,"last_engineer":5082,"callback":{"id":1529,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-30","created_by":5015,"created_at":"2019-01-30 16:46:33","updated_at":"2019-01-30 16:46:33","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2233,"mp_submit_contact_id":null}},{"id":2221,"client_id":1121,"last_engineer":5082,"callback":{"id":1518,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-28","created_by":5015,"created_at":"2019-01-28 15:45:35","updated_at":"2019-01-28 15:45:35","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2221,"mp_submit_contact_id":null}},{"id":2206,"client_id":1121,"last_engineer":5082,"callback":{"id":1503,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-24","created_by":5015,"created_at":"2019-01-24 15:09:47","updated_at":"2019-01-24 15:09:47","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2206,"mp_submit_contact_id":null}},{"id":2273,"client_id":1121,"last_engineer":5082,"callback":{"id":1563,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-03-04","created_by":5015,"created_at":"2019-03-04 14:21:36","updated_at":"2019-03-04 14:21:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2273,"mp_submit_contact_id":null}},{"id":2324,"client_id":1121,"last_engineer":5082,"callback":{"id":1614,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-03-21","created_by":5015,"created_at":"2019-03-21 14:55:28","updated_at":"2019-03-21 14:55:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2324,"mp_submit_contact_id":null}},{"id":2586,"client_id":1121,"last_engineer":1022,"callback":{"id":1868,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-28","created_by":5015,"created_at":"2019-06-28 13:55:19","updated_at":"2019-06-28 13:55:19","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2586,"mp_submit_contact_id":null}},{"id":2052,"client_id":1121,"last_engineer":1022,"callback":{"id":1352,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-10","created_by":5015,"created_at":"2018-12-10 17:38:06","updated_at":"2018-12-10 17:38:06","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2052,"mp_submit_contact_id":null}},{"id":2141,"client_id":1121,"last_engineer":1022,"callback":{"id":1436,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-04","created_by":5015,"created_at":"2019-01-04 17:13:46","updated_at":"2019-01-04 17:13:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2141,"mp_submit_contact_id":null}},{"id":2119,"client_id":1121,"last_engineer":1022,"callback":{"id":1411,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-26","created_by":5015,"created_at":"2018-12-26 10:12:38","updated_at":"2018-12-26 10:12:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2119,"mp_submit_contact_id":null}},{"id":2196,"client_id":1121,"last_engineer":1016,"callback":{"id":1480,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-18","created_by":5015,"created_at":"2019-01-18 10:59:12","updated_at":"2019-01-18 10:59:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2196,"mp_submit_contact_id":null}},{"id":2007,"client_id":1121,"last_engineer":1017,"callback":{"id":1303,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-11-29","created_by":5015,"created_at":"2018-11-29 10:34:29","updated_at":"2018-11-29 10:34:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2007,"mp_submit_contact_id":null}},{"id":2142,"client_id":1121,"last_engineer":1022,"callback":{"id":1434,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-04","created_by":5015,"created_at":"2019-01-04 17:12:42","updated_at":"2019-01-04 17:12:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2142,"mp_submit_contact_id":null}},{"id":2156,"client_id":1121,"last_engineer":1016,"callback":{"id":1451,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-10","created_by":5015,"created_at":"2019-01-10 15:51:31","updated_at":"2019-01-10 15:51:31","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2156,"mp_submit_contact_id":null}},{"id":2285,"client_id":1121,"last_engineer":5082,"callback":{"id":1573,"client_id":1121,"contact_id":2494,"description":"","callback_date":"2019-03-07","created_by":5015,"created_at":"2019-03-07 15:24:53","updated_at":"2019-03-07 15:24:53","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2285,"mp_submit_contact_id":null}},{"id":2314,"client_id":1121,"last_engineer":5082,"callback":{"id":1597,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-03-15","created_by":5015,"created_at":"2019-03-15 15:49:12","updated_at":"2019-03-15 15:49:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2314,"mp_submit_contact_id":null}},{"id":2589,"client_id":1121,"last_engineer":1022,"callback":{"id":1876,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-28","created_by":5015,"created_at":"2019-06-28 17:29:04","updated_at":"2019-06-28 17:29:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2589,"mp_submit_contact_id":null}},{"id":2366,"client_id":1121,"last_engineer":1016,"callback":{"id":1647,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-04-10","created_by":5015,"created_at":"2019-04-10 14:38:07","updated_at":"2019-04-10 14:38:07","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2366,"mp_submit_contact_id":null}},{"id":2539,"client_id":1121,"last_engineer":1016,"callback":{"id":1825,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-13","created_by":5015,"created_at":"2019-06-13 16:01:11","updated_at":"2019-06-13 16:01:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2539,"mp_submit_contact_id":null}},{"id":2367,"client_id":1121,"last_engineer":1022,"callback":{"id":1646,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2019-04-10","created_by":5015,"created_at":"2019-04-10 14:37:50","updated_at":"2019-04-10 14:37:50","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2367,"mp_submit_contact_id":null}},{"id":2540,"client_id":1121,"last_engineer":1022,"callback":{"id":1826,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-13","created_by":5015,"created_at":"2019-06-13 16:01:52","updated_at":"2019-06-13 16:01:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2540,"mp_submit_contact_id":null}},{"id":2576,"client_id":1121,"last_engineer":1022,"callback":{"id":1869,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-28","created_by":5015,"created_at":"2019-06-28 13:55:37","updated_at":"2019-06-28 13:55:37","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2576,"mp_submit_contact_id":null}},{"id":2211,"client_id":1121,"last_engineer":1022,"callback":{"id":1500,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-24","created_by":5015,"created_at":"2019-01-24 15:08:14","updated_at":"2019-01-24 15:08:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2211,"mp_submit_contact_id":null}},{"id":2160,"client_id":1121,"last_engineer":1022,"callback":{"id":1442,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-09","created_by":5015,"created_at":"2019-01-09 17:36:32","updated_at":"2019-01-09 17:36:32","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2160,"mp_submit_contact_id":null}},{"id":2212,"client_id":1121,"last_engineer":5082,"callback":{"id":1501,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-24","created_by":5015,"created_at":"2019-01-24 15:08:33","updated_at":"2019-01-24 15:08:33","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2212,"mp_submit_contact_id":null}},{"id":2042,"client_id":1121,"last_engineer":1022,"callback":{"id":1340,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-12-06","created_by":5015,"created_at":"2018-12-06 16:22:52","updated_at":"2018-12-06 16:22:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2042,"mp_submit_contact_id":null}},{"id":2186,"client_id":1121,"last_engineer":1022,"callback":{"id":1472,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-16","created_by":5015,"created_at":"2019-01-16 14:28:55","updated_at":"2019-01-16 14:28:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2186,"mp_submit_contact_id":null}},{"id":2263,"client_id":1121,"last_engineer":1022,"callback":{"id":1550,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-02-27","created_by":5015,"created_at":"2019-02-27 16:04:55","updated_at":"2019-02-27 16:04:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2263,"mp_submit_contact_id":null}},{"id":1951,"client_id":1121,"last_engineer":1022,"callback":{"id":1244,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-11-20","created_by":5063,"created_at":"2018-11-20 10:34:10","updated_at":"2018-11-20 10:34:10","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1951,"mp_submit_contact_id":null}},{"id":2564,"client_id":1121,"last_engineer":5082,"callback":{"id":1852,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-21","created_by":5015,"created_at":"2019-06-21 14:23:56","updated_at":"2019-06-21 14:23:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2564,"mp_submit_contact_id":null}},{"id":2565,"client_id":1121,"last_engineer":1022,"callback":{"id":1853,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-21","created_by":5015,"created_at":"2019-06-21 14:24:08","updated_at":"2019-06-21 14:24:08","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2565,"mp_submit_contact_id":null}},{"id":2547,"client_id":1121,"last_engineer":1022,"callback":{"id":1837,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-18","created_by":5015,"created_at":"2019-06-18 17:01:51","updated_at":"2019-06-18 17:01:51","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2547,"mp_submit_contact_id":null}},{"id":2567,"client_id":1121,"last_engineer":1022,"callback":{"id":1851,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2019-06-21","created_by":5015,"created_at":"2019-06-21 14:23:42","updated_at":"2019-06-21 14:23:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2567,"mp_submit_contact_id":null}},{"id":4170,"client_id":1121,"last_engineer":1022,"callback":{"id":3366,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-02-26","created_by":null,"created_at":"2021-02-26 14:23:41","updated_at":"2021-02-26 14:23:41","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4170,"mp_submit_contact_id":null}},{"id":4124,"client_id":1121,"last_engineer":1022,"callback":{"id":3319,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-01-15","created_by":null,"created_at":"2021-01-15 15:50:02","updated_at":"2021-01-15 15:50:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4124,"mp_submit_contact_id":null}},{"id":2605,"client_id":1121,"last_engineer":1022,"callback":{"id":1893,"client_id":1121,"contact_id":2494,"description":"","callback_date":"2019-07-05","created_by":5015,"created_at":"2019-07-05 14:29:35","updated_at":"2019-07-05 14:29:35","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2605,"mp_submit_contact_id":null}},{"id":4101,"client_id":1121,"last_engineer":1022,"callback":{"id":3301,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-01-08","created_by":null,"created_at":"2021-01-08 14:21:54","updated_at":"2021-01-08 14:21:54","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4101,"mp_submit_contact_id":null}},{"id":3405,"client_id":1121,"last_engineer":5085,"callback":{"id":2632,"client_id":1121,"contact_id":2494,"description":"","callback_date":"2020-04-29","created_by":null,"created_at":"2020-04-29 14:40:48","updated_at":"2020-04-29 14:40:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3405,"mp_submit_contact_id":null}},{"id":3417,"client_id":1121,"last_engineer":1022,"callback":{"id":2651,"client_id":1121,"contact_id":2632,"description":"\u5b9e\u9645\u53bb\u5230\u5ba2\u6237\u73b0\u573a\u65f6\u95f4\u662f\u65e9\u4e0a\u4e5d\u70b9\uff0c\u5df2\u548c\u5434\u660a\u786e\u8ba4","callback_date":"2020-05-07","created_by":null,"created_at":"2020-05-07 16:27:01","updated_at":"2020-05-07 16:27:01","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3417,"mp_submit_contact_id":null}},{"id":3419,"client_id":1121,"last_engineer":1023,"callback":{"id":2652,"client_id":1121,"contact_id":2632,"description":"\u56e0\u673a\u623f\u642c\u8fc1\uff0c\u6253\u5361\u5730\u70b9\u975e\u4e00\u4e2a\u5730\u70b9\uff0c\u5df2\u548c\u9500\u552e\u786e\u8ba4","callback_date":"2020-05-07","created_by":null,"created_at":"2020-05-07 16:28:42","updated_at":"2020-05-07 16:28:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3419,"mp_submit_contact_id":null}},{"id":3404,"client_id":1121,"last_engineer":1023,"callback":{"id":2633,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-04-29","created_by":null,"created_at":"2020-04-29 15:07:57","updated_at":"2020-04-29 15:07:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3404,"mp_submit_contact_id":null}},{"id":3841,"client_id":1121,"last_engineer":5125,"callback":{"id":3054,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-09-11","created_by":null,"created_at":"2020-09-11 16:08:11","updated_at":"2020-09-11 16:08:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3841,"mp_submit_contact_id":null}},{"id":3945,"client_id":1121,"last_engineer":5125,"callback":{"id":3156,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-11-10","created_by":null,"created_at":"2020-11-10 14:33:48","updated_at":"2020-11-10 14:33:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3945,"mp_submit_contact_id":null}},{"id":5285,"client_id":1121,"last_engineer":1015,"callback":{"id":4384,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-06-27","created_by":5311,"created_at":"2022-06-26 19:18:39","updated_at":"2022-06-26 19:18:39","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5285,"mp_submit_contact_id":2632}},{"id":5266,"client_id":1121,"last_engineer":1022,"callback":{"id":4373,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-06-22","created_by":5311,"created_at":"2022-06-22 09:13:34","updated_at":"2022-06-22 09:13:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5266,"mp_submit_contact_id":null}},{"id":5275,"client_id":1121,"last_engineer":1022,"callback":{"id":4387,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-06-28","created_by":5311,"created_at":"2022-06-28 09:36:24","updated_at":"2022-06-28 09:36:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5275,"mp_submit_contact_id":2632}},{"id":5273,"client_id":1121,"last_engineer":5248,"callback":{"id":4386,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-06-27","created_by":5311,"created_at":"2022-06-27 15:05:20","updated_at":"2022-06-27 15:05:20","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5273,"mp_submit_contact_id":2632}},{"id":5274,"client_id":1121,"last_engineer":5247,"callback":{"id":4388,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-06-28","created_by":5311,"created_at":"2022-06-28 10:26:31","updated_at":"2022-06-28 10:26:31","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5274,"mp_submit_contact_id":null}},{"id":5488,"client_id":1121,"last_engineer":5248,"callback":{"id":4566,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-09-29","created_by":5311,"created_at":"2022-09-29 09:23:56","updated_at":"2022-09-29 09:23:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5488,"mp_submit_contact_id":2632}},{"id":5471,"client_id":1121,"last_engineer":5085,"callback":{"id":4565,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-09-29","created_by":5311,"created_at":"2022-09-29 09:23:39","updated_at":"2022-09-29 09:23:39","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5471,"mp_submit_contact_id":2632}},{"id":5915,"client_id":1121,"last_engineer":5248,"callback":{"id":4985,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2023-03-20","created_by":5311,"created_at":"2023-03-19 07:10:11","updated_at":"2023-03-19 07:10:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5915,"mp_submit_contact_id":2632}},{"id":6854,"client_id":1121,"last_engineer":5296,"callback":{"id":5906,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2023-12-25","created_by":5311,"created_at":"2023-12-25 17:45:25","updated_at":"2023-12-25 17:45:25","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6854,"mp_submit_contact_id":2632}},{"id":6867,"client_id":1121,"last_engineer":1022,"callback":{"id":5924,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2024-01-03","created_by":5311,"created_at":"2024-01-02 18:02:02","updated_at":"2024-01-02 18:02:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6867,"mp_submit_contact_id":2632}},{"id":6977,"client_id":1121,"last_engineer":1022,"callback":{"id":6032,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2024-02-02","created_by":5311,"created_at":"2024-02-01 17:28:45","updated_at":"2024-02-01 17:28:45","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6977,"mp_submit_contact_id":2632}},{"id":6978,"client_id":1121,"last_engineer":1023,"callback":{"id":6033,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2024-02-02","created_by":5311,"created_at":"2024-02-01 21:06:36","updated_at":"2024-02-01 21:06:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6978,"mp_submit_contact_id":2632}},{"id":7972,"client_id":1121,"last_engineer":5248,"callback":{"id":7003,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2024-11-25","created_by":5413,"created_at":"2024-11-25 13:21:56","updated_at":"2024-11-25 13:21:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7972,"mp_submit_contact_id":null}},{"id":9158,"client_id":1121,"last_engineer":5248,"callback":{"id":8175,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2026-02-06","created_by":5360,"created_at":"2026-02-06 16:41:04","updated_at":"2026-02-06 16:41:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":9158,"mp_submit_contact_id":null}}],"completedPreSalesCases":[{"id":1769,"client_id":1121,"last_engineer":1023,"callback":{"id":1037,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-09-29","created_by":5015,"created_at":"2018-09-29 16:34:01","updated_at":"2018-09-29 16:34:01","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1769,"mp_submit_contact_id":null}},{"id":2134,"client_id":1121,"last_engineer":1023,"callback":{"id":1431,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-03","created_by":5015,"created_at":"2019-01-03 16:39:19","updated_at":"2019-01-03 16:39:19","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2134,"mp_submit_contact_id":null}},{"id":1761,"client_id":1121,"last_engineer":1023,"callback":{"id":1034,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-09-29","created_by":5015,"created_at":"2018-09-29 15:38:08","updated_at":"2018-09-29 15:38:08","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1761,"mp_submit_contact_id":null}},{"id":2135,"client_id":1121,"last_engineer":1023,"callback":{"id":1441,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-08","created_by":5015,"created_at":"2019-01-08 10:34:00","updated_at":"2019-01-08 10:34:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2135,"mp_submit_contact_id":null}},{"id":2165,"client_id":1121,"last_engineer":1023,"callback":{"id":1460,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-14","created_by":5015,"created_at":"2019-01-14 11:27:02","updated_at":"2019-01-14 11:27:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2165,"mp_submit_contact_id":null}},{"id":2152,"client_id":1121,"last_engineer":1023,"callback":{"id":1456,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-11","created_by":5015,"created_at":"2019-01-11 09:59:57","updated_at":"2019-01-11 09:59:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2152,"mp_submit_contact_id":null}},{"id":2139,"client_id":1121,"last_engineer":1023,"callback":{"id":1439,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-08","created_by":5015,"created_at":"2019-01-08 10:31:48","updated_at":"2019-01-08 10:31:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2139,"mp_submit_contact_id":null}},{"id":1766,"client_id":1121,"last_engineer":1023,"callback":{"id":1033,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-09-29","created_by":5015,"created_at":"2018-09-29 15:36:58","updated_at":"2018-09-29 15:36:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1766,"mp_submit_contact_id":null}},{"id":1814,"client_id":1121,"last_engineer":1023,"callback":{"id":1085,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-10-18","created_by":5015,"created_at":"2018-10-18 15:26:25","updated_at":"2018-10-18 15:26:25","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1814,"mp_submit_contact_id":null}},{"id":1733,"client_id":1121,"last_engineer":1023,"callback":{"id":1016,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2018-09-21","created_by":5015,"created_at":"2018-09-21 16:26:28","updated_at":"2018-09-21 16:26:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1733,"mp_submit_contact_id":null}},{"id":1786,"client_id":1121,"last_engineer":1023,"callback":{"id":1060,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-10-12","created_by":5015,"created_at":"2018-10-12 14:48:26","updated_at":"2018-10-12 14:48:26","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1786,"mp_submit_contact_id":null}},{"id":1840,"client_id":1121,"last_engineer":1023,"callback":{"id":1116,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-10-25","created_by":5015,"created_at":"2018-10-25 09:15:42","updated_at":"2018-10-25 09:15:42","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1840,"mp_submit_contact_id":null}},{"id":2143,"client_id":1121,"last_engineer":1016,"callback":{"id":1437,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-04","created_by":5015,"created_at":"2019-01-04 17:14:02","updated_at":"2019-01-04 17:14:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2143,"mp_submit_contact_id":null}},{"id":2144,"client_id":1121,"last_engineer":1016,"callback":{"id":1435,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-04","created_by":5015,"created_at":"2019-01-04 17:13:04","updated_at":"2019-01-04 17:13:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2144,"mp_submit_contact_id":null}},{"id":2161,"client_id":1121,"last_engineer":1023,"callback":{"id":1454,"client_id":1121,"contact_id":2209,"description":"","callback_date":"2019-01-11","created_by":5015,"created_at":"2019-01-11 09:57:40","updated_at":"2019-01-11 09:57:40","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2161,"mp_submit_contact_id":null}},{"id":1687,"client_id":1121,"last_engineer":1023,"callback":null},{"id":1692,"client_id":1121,"last_engineer":1017,"callback":null},{"id":1718,"client_id":1121,"last_engineer":1017,"callback":{"id":998,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2018-09-17","created_by":5015,"created_at":"2018-09-17 17:23:34","updated_at":"2018-09-17 17:23:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1718,"mp_submit_contact_id":null}},{"id":3317,"client_id":1121,"last_engineer":1017,"callback":{"id":2557,"client_id":1121,"contact_id":2255,"description":"","callback_date":"2020-03-31","created_by":null,"created_at":"2020-03-31 16:06:29","updated_at":"2020-03-31 16:06:29","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3317,"mp_submit_contact_id":null}},{"id":3329,"client_id":1121,"last_engineer":1022,"callback":{"id":2565,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-04-03","created_by":null,"created_at":"2020-04-03 16:09:54","updated_at":"2020-04-03 16:09:54","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3329,"mp_submit_contact_id":null}},{"id":3324,"client_id":1121,"last_engineer":1022,"callback":{"id":2559,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2020-04-03","created_by":null,"created_at":"2020-04-03 09:48:38","updated_at":"2020-04-03 09:48:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3324,"mp_submit_contact_id":null}},{"id":3985,"client_id":1121,"last_engineer":1017,"callback":{"id":3187,"client_id":1121,"contact_id":2993,"description":"","callback_date":"2020-11-23","created_by":null,"created_at":"2020-11-23 16:22:15","updated_at":"2020-11-23 16:22:15","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3985,"mp_submit_contact_id":null}},{"id":4564,"client_id":1121,"last_engineer":1022,"callback":{"id":3734,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-08-18","created_by":5297,"created_at":"2021-08-18 17:16:39","updated_at":"2021-08-18 17:16:39","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4564,"mp_submit_contact_id":null}},{"id":4559,"client_id":1121,"last_engineer":1022,"callback":{"id":3731,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-08-16","created_by":5297,"created_at":"2021-08-16 15:33:12","updated_at":"2021-08-16 15:33:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4559,"mp_submit_contact_id":null}},{"id":4565,"client_id":1121,"last_engineer":5296,"callback":{"id":3735,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2021-08-18","created_by":5297,"created_at":"2021-08-18 17:16:59","updated_at":"2021-08-18 17:16:59","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4565,"mp_submit_contact_id":null}},{"id":5593,"client_id":1121,"last_engineer":1017,"callback":{"id":4680,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2022-11-11","created_by":5311,"created_at":"2022-11-11 11:38:13","updated_at":"2022-11-11 11:38:13","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5593,"mp_submit_contact_id":2632}},{"id":6065,"client_id":1121,"last_engineer":1015,"callback":{"id":5141,"client_id":1121,"contact_id":2632,"description":"","callback_date":"2023-04-27","created_by":5311,"created_at":"2023-04-27 15:50:30","updated_at":"2023-04-27 15:50:30","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6065,"mp_submit_contact_id":2632}}],"sales_rep_display":"\u9b4f\u6cfd\u6587","datas2":[{"client_id":1121,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"986543","sum2":"261569.6631","y":56.64},{"client_id":1121,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"221500","sum2":"123018.6","y":26.64},{"client_id":1121,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"347000","sum2":"77220","y":16.72}]},{"id":539,"name":"\u4e2d\u6d4b\u65b0\u56fe(\u5317\u4eac)\u9065\u611f\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":null,"status3_budgets":"1152828","status3_profits":"323022.405600000000","status3_count":1,"status3_pct":28.02,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":8,"ircount":17,"service_time":"77.33","service_count":25,"sales_rep_time":"8\u5e747\u4e2a\u670810\u5929","created_at":"2017-10-24 15:17:30","work_time":4.19,"work_count":6,"last_bargain_date":"2018-10-12","reimbursement_amount":"165","points":"486","cooperated":true,"client_industry":"\u5176\u4ed6","client_industry_id":20,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":null,"collected":"1152828","un_collected":"0","invoices":"1152828.00","un_invoices":"0.00","project_count":4,"other_budgets":"1300000","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":55.14,"work1_count":78,"work2_time":0,"work2_count":0,"work3_time":0.5,"work3_count":1,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":539,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"481550","sum2":"134930.31","y":41.77},{"client_id":539,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"224000","sum2":"62764.8","y":19.43},{"client_id":539,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"183096","sum2":"51303.4992","y":15.88},{"client_id":539,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"160000","sum2":"44832","y":13.88},{"client_id":539,"taxonomy_id":229,"name":"\u4e91\u8ba1\u7b97","sum":"104182","sum2":"29191.7964","y":9.04}],"preSalesEngineers":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"satisfaction_score":"","skill_score":""},{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":9,"skill_score":9}],"implementEngineers":[{"id":1016,"key":1016,"name":"\u8346\u626c","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":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5082,"key":5082,"name":"\u674e\u5fd7\u535a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"completedImplementCases":[{"id":1992,"client_id":539,"last_engineer":1016,"callback":{"id":1289,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-11-27","created_by":5015,"created_at":"2018-11-27 14:49:55","updated_at":"2018-11-27 14:49:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1992,"mp_submit_contact_id":null}},{"id":1993,"client_id":539,"last_engineer":1016,"callback":{"id":1288,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-11-27","created_by":5015,"created_at":"2018-11-27 14:49:24","updated_at":"2018-11-27 14:49:24","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1993,"mp_submit_contact_id":null}},{"id":1999,"client_id":539,"last_engineer":1016,"callback":{"id":1309,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-11-29","created_by":5015,"created_at":"2018-11-29 16:38:00","updated_at":"2018-11-29 16:38:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1999,"mp_submit_contact_id":null}},{"id":2046,"client_id":539,"last_engineer":1015,"callback":{"id":1344,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-12-07","created_by":5015,"created_at":"2018-12-07 14:34:03","updated_at":"2018-12-07 14:34:03","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2046,"mp_submit_contact_id":null}},{"id":2202,"client_id":539,"last_engineer":1023,"callback":{"id":1509,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-01-25","created_by":5015,"created_at":"2019-01-25 10:52:32","updated_at":"2019-01-25 10:52:32","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2202,"mp_submit_contact_id":null}},{"id":2451,"client_id":539,"last_engineer":1016,"callback":{"id":1730,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 14:09:56","updated_at":"2019-05-10 14:09:56","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2451,"mp_submit_contact_id":null}},{"id":2175,"client_id":539,"last_engineer":5082,"callback":{"id":1490,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-01-18","created_by":5015,"created_at":"2019-01-18 14:57:38","updated_at":"2019-01-18 14:57:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2175,"mp_submit_contact_id":null}},{"id":1968,"client_id":539,"last_engineer":1016,"callback":{"id":1248,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-11-21","created_by":5015,"created_at":"2018-11-21 15:48:58","updated_at":"2018-11-21 15:48:58","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1968,"mp_submit_contact_id":null}},{"id":2099,"client_id":539,"last_engineer":1016,"callback":{"id":1389,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-12-21","created_by":5015,"created_at":"2018-12-21 14:04:34","updated_at":"2018-12-21 14:04:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2099,"mp_submit_contact_id":null}},{"id":2433,"client_id":539,"last_engineer":1016,"callback":{"id":1732,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 14:11:44","updated_at":"2019-05-10 14:11:44","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2433,"mp_submit_contact_id":null}},{"id":2153,"client_id":539,"last_engineer":5082,"callback":{"id":1453,"client_id":539,"contact_id":1207,"description":"","callback_date":"2019-01-10","created_by":5015,"created_at":"2019-01-10 16:41:38","updated_at":"2019-01-10 16:41:38","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2153,"mp_submit_contact_id":null}},{"id":2169,"client_id":539,"last_engineer":5082,"callback":{"id":1491,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-01-18","created_by":5015,"created_at":"2019-01-18 14:57:57","updated_at":"2019-01-18 14:57:57","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2169,"mp_submit_contact_id":null}},{"id":2184,"client_id":539,"last_engineer":5082,"callback":{"id":1489,"client_id":539,"contact_id":1207,"description":"","callback_date":"2019-01-18","created_by":5015,"created_at":"2019-01-18 14:52:11","updated_at":"2019-01-18 14:52:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2184,"mp_submit_contact_id":null}},{"id":2446,"client_id":539,"last_engineer":1016,"callback":{"id":1731,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-05-10","created_by":5015,"created_at":"2019-05-10 14:10:37","updated_at":"2019-05-10 14:10:37","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2446,"mp_submit_contact_id":null}},{"id":2876,"client_id":539,"last_engineer":1016,"callback":{"id":2157,"client_id":539,"contact_id":2469,"description":"","callback_date":"2019-10-18","created_by":null,"created_at":"2019-10-18 10:01:51","updated_at":"2019-10-18 10:01:51","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":2876,"mp_submit_contact_id":null}}],"completedPreSalesCases":[{"id":1868,"client_id":539,"last_engineer":1015,"callback":{"id":1155,"client_id":539,"contact_id":1207,"description":"","callback_date":"2018-11-01","created_by":5015,"created_at":"2018-11-01 09:18:14","updated_at":"2018-11-01 09:18:14","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":1868,"mp_submit_contact_id":null}},{"id":990,"client_id":539,"last_engineer":1017,"callback":null},{"id":1359,"client_id":539,"last_engineer":1015,"callback":null},{"id":1406,"client_id":539,"last_engineer":1015,"callback":null},{"id":1492,"client_id":539,"last_engineer":1015,"callback":null},{"id":1531,"client_id":539,"last_engineer":1017,"callback":null},{"id":1532,"client_id":539,"last_engineer":1015,"callback":null},{"id":5368,"client_id":539,"last_engineer":1015,"callback":{"id":4474,"client_id":539,"contact_id":1206,"description":"","callback_date":"2022-08-05","created_by":5311,"created_at":"2022-08-04 20:16:29","updated_at":"2022-08-04 20:16:29","implement_id":null,"satisfaction_score":8,"skill_score":8,"case_id":5368,"mp_submit_contact_id":1206}}],"sales_rep_display":"\u516c\u6d77\u5ba2\u6237","datas2":[{"client_id":539,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"481550","sum2":"134930.31","y":41.77},{"client_id":539,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"224000","sum2":"62764.8","y":19.43},{"client_id":539,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"183096","sum2":"51303.4992","y":15.88},{"client_id":539,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"160000","sum2":"44832","y":13.88},{"client_id":539,"taxonomy_id":229,"name":"\u4e91\u8ba1\u7b97","sum":"104182","sum2":"29191.7964","y":9.04}]},{"id":1034,"name":"\u5317\u4eac\u552f\u6377\u521b\u82af\u7cbe\u6d4b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\u552f\u6377\u521b\u82af(\u5929\u6d25)\u7535\u5b50\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":5311,"status3_budgets":"338690.00","status3_profits":"86540.1040000000000000","status3_count":3,"status3_pct":25.55,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":11,"ircount":4,"service_time":"24.02","service_count":15,"sales_rep_time":"7\u5e7411\u4e2a\u670827\u5929","created_at":"2018-06-05 22:56:01","work_time":10.14,"work_count":6,"last_bargain_date":"2021-01-24","reimbursement_amount":"56.00","points":"349","cooperated":true,"client_industry":"\u901a\u4fe1","client_industry_id":4,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":"26","collected":"338690","un_collected":"0.00","invoices":"338690.00","un_invoices":"0.00","project_count":10,"other_budgets":"939400.0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":58.06,"work1_count":73,"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":1034,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"267104","sum2":"82588.5568","y":78.86},{"client_id":1034,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"71586","sum2":"3951.5472","y":21.14}],"preSalesEngineers":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","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":5074,"key":5074,"name":"\u803f\u7a0b\u6797","sex":"M","department_id":2,"satisfaction_score":"","skill_score":""}],"implementEngineers":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","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}],"completedImplementCases":[{"id":5020,"client_id":1034,"last_engineer":1017,"callback":{"id":4152,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2022-02-08","created_by":5311,"created_at":"2022-02-08 14:48:22","updated_at":"2022-02-08 14:48:22","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5020,"mp_submit_contact_id":null}},{"id":5224,"client_id":1034,"last_engineer":5085,"callback":{"id":4332,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2022-05-12","created_by":5311,"created_at":"2022-05-12 14:50:05","updated_at":"2022-05-12 14:50:05","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5224,"mp_submit_contact_id":2042}},{"id":4156,"client_id":1034,"last_engineer":1023,"callback":{"id":3351,"client_id":1034,"contact_id":3522,"description":"","callback_date":"2021-01-29","created_by":null,"created_at":"2021-01-29 15:45:18","updated_at":"2021-01-29 15:45:18","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4156,"mp_submit_contact_id":null}},{"id":3121,"client_id":1034,"last_engineer":1023,"callback":{"id":2443,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2020-02-21","created_by":null,"created_at":"2020-02-21 17:58:02","updated_at":"2020-02-21 17:58:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3121,"mp_submit_contact_id":null}}],"completedPreSalesCases":[{"id":4814,"client_id":1034,"last_engineer":1017,"callback":{"id":3962,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2021-11-18","created_by":5311,"created_at":"2021-11-18 11:27:35","updated_at":"2021-11-18 11:27:35","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4814,"mp_submit_contact_id":null}},{"id":4815,"client_id":1034,"last_engineer":1015,"callback":{"id":3961,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2021-11-18","created_by":5311,"created_at":"2021-11-18 11:27:11","updated_at":"2021-11-18 11:27:11","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4815,"mp_submit_contact_id":null}},{"id":3475,"client_id":1034,"last_engineer":1017,"callback":{"id":2692,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2020-05-20","created_by":null,"created_at":"2020-05-20 16:00:15","updated_at":"2020-05-20 16:00:15","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3475,"mp_submit_contact_id":null}},{"id":3498,"client_id":1034,"last_engineer":1017,"callback":{"id":2721,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2020-05-28","created_by":null,"created_at":"2020-05-28 11:30:43","updated_at":"2020-05-28 11:30:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3498,"mp_submit_contact_id":null}},{"id":3517,"client_id":1034,"last_engineer":1017,"callback":{"id":2729,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2020-06-03","created_by":null,"created_at":"2020-06-03 17:50:19","updated_at":"2020-06-03 17:50:19","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3517,"mp_submit_contact_id":null}},{"id":1555,"client_id":1034,"last_engineer":5074,"callback":null},{"id":1571,"client_id":1034,"last_engineer":1017,"callback":null},{"id":1652,"client_id":1034,"last_engineer":5074,"callback":null},{"id":1690,"client_id":1034,"last_engineer":5074,"callback":null},{"id":3616,"client_id":1034,"last_engineer":1017,"callback":{"id":2828,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2020-07-10","created_by":null,"created_at":"2020-07-10 11:10:03","updated_at":"2020-07-10 11:10:03","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3616,"mp_submit_contact_id":null}},{"id":3619,"client_id":1034,"last_engineer":1015,"callback":{"id":2829,"client_id":1034,"contact_id":2042,"description":"","callback_date":"2020-07-10","created_by":null,"created_at":"2020-07-10 11:10:12","updated_at":"2020-07-10 11:10:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":3619,"mp_submit_contact_id":null}}],"sales_rep_display":"\u62d3\u5b9e\u79d1\u6280","datas2":[{"client_id":1034,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"267104","sum2":"82588.5568","y":95.43},{"client_id":1034,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"71586","sum2":"3951.5472","y":4.57}]},{"id":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5087,"status3_budgets":"147350","status3_profits":"48275.4550000000000000","status3_count":14,"status3_pct":32.76,"status1_budgets":"95000","status1_count":1,"status2_budgets":"0","status2_count":0,"pscount":1,"ircount":24,"service_time":"90.23","service_count":25,"sales_rep_time":"3\u5e741\u4e2a\u670813\u5929","created_at":"2023-04-20 00:02:55","work_time":0,"work_count":0,"last_bargain_date":"2026-02-02","reimbursement_amount":"3093.65","points":"1240","cooperated":true,"client_industry":"\u5236\u9020","client_industry_id":5,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":"66","collected":"77780","un_collected":"69570","invoices":"77780.00","un_invoices":"90070.00","project_count":19,"other_budgets":"317300","used_clients":1,"status12_budgets":"95000","status12_profits":"23750.000000000000","work1_time":6.37,"work1_count":21,"work2_time":1,"work2_count":1,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[{"client_id":2526,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"26500","sum2":"4069.116","y":37.55},{"client_id":2526,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"25000","sum2":"16820.4","y":35.42},{"client_id":2526,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"19080","sum2":"3167.28","y":27.03}],"preSalesEngineers":[{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"implementEngineers":[{"id":5296,"key":5296,"name":"\u8d75\u5b87","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":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","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}],"completedImplementCases":[{"id":6187,"client_id":2526,"last_engineer":5296,"callback":{"id":5230,"client_id":2526,"contact_id":4590,"description":"\u7535\u8bdd\u56de\u8bbf","callback_date":"2023-06-06","created_by":5311,"created_at":"2023-06-06 16:11:23","updated_at":"2023-06-06 16:11:23","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6187,"mp_submit_contact_id":null}},{"id":6424,"client_id":2526,"last_engineer":5296,"callback":{"id":5475,"client_id":2526,"contact_id":4759,"description":"","callback_date":"2023-08-03","created_by":5311,"created_at":"2023-08-02 14:48:00","updated_at":"2023-08-02 14:48:00","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6424,"mp_submit_contact_id":4759}},{"id":6471,"client_id":2526,"last_engineer":5296,"callback":{"id":5522,"client_id":2526,"contact_id":4759,"description":"","callback_date":"2023-08-15","created_by":5311,"created_at":"2023-08-15 14:52:04","updated_at":"2023-08-15 14:52:04","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6471,"mp_submit_contact_id":4759}},{"id":6616,"client_id":2526,"last_engineer":5296,"callback":{"id":5671,"client_id":2526,"contact_id":4841,"description":"","callback_date":"2023-10-13","created_by":5311,"created_at":"2023-10-12 20:03:52","updated_at":"2023-10-12 20:03:52","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6616,"mp_submit_contact_id":4841}},{"id":6675,"client_id":2526,"last_engineer":5296,"callback":{"id":5726,"client_id":2526,"contact_id":4759,"description":"","callback_date":"2023-10-27","created_by":5311,"created_at":"2023-10-27 15:06:46","updated_at":"2023-10-27 15:06:46","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6675,"mp_submit_contact_id":4759}},{"id":6644,"client_id":2526,"last_engineer":1022,"callback":{"id":5698,"client_id":2526,"contact_id":4759,"description":"\u7535\u8bdd\u56de\u8bbf","callback_date":"2023-10-20","created_by":5311,"created_at":"2023-10-20 16:23:13","updated_at":"2023-10-20 16:23:13","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6644,"mp_submit_contact_id":null}},{"id":6717,"client_id":2526,"last_engineer":5296,"callback":{"id":5771,"client_id":2526,"contact_id":4841,"description":"","callback_date":"2023-11-10","created_by":5311,"created_at":"2023-11-10 08:31:48","updated_at":"2023-11-10 08:31:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6717,"mp_submit_contact_id":4841}},{"id":6822,"client_id":2526,"last_engineer":5296,"callback":{"id":5869,"client_id":2526,"contact_id":4864,"description":"","callback_date":"2023-12-15","created_by":5311,"created_at":"2023-12-15 14:05:32","updated_at":"2023-12-15 14:05:32","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":6822,"mp_submit_contact_id":4864}},{"id":7036,"client_id":2526,"last_engineer":5296,"callback":{"id":6088,"client_id":2526,"contact_id":4759,"description":"","callback_date":"2024-03-04","created_by":5311,"created_at":"2024-03-01 21:35:48","updated_at":"2024-03-01 21:35:48","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7036,"mp_submit_contact_id":4759}},{"id":7157,"client_id":2526,"last_engineer":5296,"callback":{"id":6203,"client_id":2526,"contact_id":4759,"description":"","callback_date":"2024-04-03","created_by":5311,"created_at":"2024-04-02 18:33:21","updated_at":"2024-04-02 18:33:21","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7157,"mp_submit_contact_id":4759}},{"id":7284,"client_id":2526,"last_engineer":5248,"callback":{"id":6338,"client_id":2526,"contact_id":5758,"description":"","callback_date":"2024-05-15","created_by":5311,"created_at":"2024-05-15 16:28:13","updated_at":"2024-05-15 16:28:13","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7284,"mp_submit_contact_id":null}},{"id":7453,"client_id":2526,"last_engineer":5085,"callback":{"id":6488,"client_id":2526,"contact_id":5805,"description":"","callback_date":"2024-06-19","created_by":5311,"created_at":"2024-06-19 10:43:34","updated_at":"2024-06-19 10:43:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7453,"mp_submit_contact_id":null}},{"id":7667,"client_id":2526,"last_engineer":5296,"callback":{"id":6693,"client_id":2526,"contact_id":4759,"description":"","callback_date":"2024-08-06","created_by":5413,"created_at":"2024-08-02 15:51:36","updated_at":"2024-08-02 15:51:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7667,"mp_submit_contact_id":4759}},{"id":7974,"client_id":2526,"last_engineer":5085,"callback":{"id":7004,"client_id":2526,"contact_id":5943,"description":"","callback_date":"2024-11-25","created_by":5413,"created_at":"2024-11-25 13:22:20","updated_at":"2024-11-25 13:22:20","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":7974,"mp_submit_contact_id":null}},{"id":8023,"client_id":2526,"last_engineer":5085,"callback":{"id":7052,"client_id":2526,"contact_id":5805,"description":"","callback_date":"2024-12-16","created_by":5413,"created_at":"2024-12-16 09:21:55","updated_at":"2024-12-16 09:21:55","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8023,"mp_submit_contact_id":null}},{"id":8057,"client_id":2526,"last_engineer":1023,"callback":{"id":7086,"client_id":2526,"contact_id":5943,"description":"","callback_date":"2024-12-30","created_by":5413,"created_at":"2024-12-30 10:22:33","updated_at":"2024-12-30 10:22:33","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8057,"mp_submit_contact_id":null}},{"id":8031,"client_id":2526,"last_engineer":5248,"callback":{"id":7058,"client_id":2526,"contact_id":5805,"description":"","callback_date":"2024-12-18","created_by":5413,"created_at":"2024-12-18 14:56:22","updated_at":"2024-12-18 14:56:22","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8031,"mp_submit_contact_id":null}},{"id":8032,"client_id":2526,"last_engineer":5085,"callback":{"id":7059,"client_id":2526,"contact_id":5805,"description":"","callback_date":"2024-12-18","created_by":5413,"created_at":"2024-12-18 14:56:53","updated_at":"2024-12-18 14:56:53","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8032,"mp_submit_contact_id":null}},{"id":8389,"client_id":2526,"last_engineer":5296,"callback":{"id":7418,"client_id":2526,"contact_id":5805,"description":"","callback_date":"2025-05-16","created_by":5445,"created_at":"2025-05-13 21:39:28","updated_at":"2025-05-13 21:39:28","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8389,"mp_submit_contact_id":5805}},{"id":8546,"client_id":2526,"last_engineer":1022,"callback":{"id":7572,"client_id":2526,"contact_id":6087,"description":"","callback_date":"2025-07-04","created_by":5360,"created_at":"2025-07-04 11:00:34","updated_at":"2025-07-04 11:00:34","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8546,"mp_submit_contact_id":null}},{"id":8655,"client_id":2526,"last_engineer":1022,"callback":{"id":7672,"client_id":2526,"contact_id":6113,"description":"","callback_date":"2025-07-31","created_by":5360,"created_at":"2025-07-31 17:37:10","updated_at":"2025-07-31 17:37:10","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8655,"mp_submit_contact_id":null}},{"id":8638,"client_id":2526,"last_engineer":1022,"callback":{"id":7644,"client_id":2526,"contact_id":6113,"description":"","callback_date":"2025-07-25","created_by":5360,"created_at":"2025-07-25 11:27:43","updated_at":"2025-07-25 11:27:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8638,"mp_submit_contact_id":null}},{"id":8700,"client_id":2526,"last_engineer":5085,"callback":{"id":7713,"client_id":2526,"contact_id":6113,"description":"","callback_date":"2025-08-15","created_by":5360,"created_at":"2025-08-15 15:13:43","updated_at":"2025-08-15 15:13:43","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8700,"mp_submit_contact_id":null}},{"id":9051,"client_id":2526,"last_engineer":1022,"callback":{"id":8072,"client_id":2526,"contact_id":6113,"description":"","callback_date":"2025-12-22","created_by":5360,"created_at":"2025-12-22 10:10:02","updated_at":"2025-12-22 10:10:02","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":9051,"mp_submit_contact_id":null}}],"completedPreSalesCases":[{"id":8217,"client_id":2526,"last_engineer":1015,"callback":{"id":7236,"client_id":2526,"contact_id":4590,"description":"","callback_date":"2025-03-07","created_by":5445,"created_at":"2025-03-07 17:59:12","updated_at":"2025-03-07 17:59:12","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8217,"mp_submit_contact_id":null}}],"sales_rep_display":"\u5218\u5fae","datas2":[{"client_id":2526,"taxonomy_id":5,"name":"\u7f51\u7edc","sum":"26500","sum2":"4069.116","y":16.91},{"client_id":2526,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"25000","sum2":"16820.4","y":69.92},{"client_id":2526,"taxonomy_id":226,"name":"\u5b89\u5168","sum":"19080","sum2":"3167.28","y":13.17}]},{"id":166,"name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u6d4b\u8bd5\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":null,"status3_budgets":"34700","status3_profits":"5090.0000000000000000","status3_count":2,"status3_pct":14.67,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":4,"service_time":"5.27","service_count":4,"sales_rep_time":"9\u5e742\u4e2a\u670823\u5929","created_at":"2017-03-10 19:30:11","work_time":1.49,"work_count":2,"last_bargain_date":"2017-11-16","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":"9","collected":"34700","un_collected":"0","invoices":"34700.00","un_invoices":"0.00","project_count":3,"other_budgets":"10000","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":13.79,"work1_count":38,"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":166,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"32900","sum2":"3290","y":94.81},{"client_id":166,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"1800","sum2":"1800","y":5.19}],"preSalesEngineers":[],"implementEngineers":[{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"satisfaction_score":4,"skill_score":4},{"id":1018,"key":1018,"name":"\u7a0b\u946b\u658c","sex":"M","department_id":2,"satisfaction_score":4,"skill_score":4},{"id":1016,"key":1016,"name":"\u8346\u626c","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}],"completedImplementCases":[{"id":145,"client_id":166,"last_engineer":1023,"callback":{"id":38,"client_id":166,"contact_id":320,"description":"","callback_date":"2017-03-20","created_by":1010,"created_at":"2017-03-17 16:14:12","updated_at":"2017-05-31 11:06:06","implement_id":132,"satisfaction_score":4,"skill_score":4,"case_id":145,"mp_submit_contact_id":null}},{"id":254,"client_id":166,"last_engineer":1018,"callback":{"id":100,"client_id":166,"contact_id":320,"description":"","callback_date":"2017-04-14","created_by":1010,"created_at":"2017-04-07 16:00:33","updated_at":"2017-05-31 11:39:15","implement_id":207,"satisfaction_score":4,"skill_score":4,"case_id":254,"mp_submit_contact_id":null}},{"id":938,"client_id":166,"last_engineer":1016,"callback":{"id":552,"client_id":166,"contact_id":320,"description":"","callback_date":"2017-11-17","created_by":5015,"created_at":"2017-11-14 11:52:35","updated_at":"2017-11-17 14:23:18","implement_id":745,"satisfaction_score":10,"skill_score":10,"case_id":938,"mp_submit_contact_id":null}},{"id":940,"client_id":166,"last_engineer":1020,"callback":{"id":553,"client_id":166,"contact_id":320,"description":"","callback_date":"2017-11-17","created_by":5015,"created_at":"2017-11-14 17:38:50","updated_at":"2017-11-17 14:26:37","implement_id":746,"satisfaction_score":10,"skill_score":10,"case_id":940,"mp_submit_contact_id":null}}],"completedPreSalesCases":[],"sales_rep_display":"\u516c\u6d77\u5ba2\u6237","datas2":[{"client_id":166,"taxonomy_id":1,"name":"\u8ba1\u7b97","sum":"32900","sum2":"3290","y":64.64},{"client_id":166,"taxonomy_id":215,"name":"\u670d\u52a1","sum":"1800","sum2":"1800","y":35.36}]},{"id":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","sales_rep":1001,"status3_budgets":"33333","status3_profits":"10999.890000000000","status3_count":1,"status3_pct":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":"2\u4e2a\u67082\u5929","created_at":"2026-04-01 11:21:52","work_time":0,"work_count":0,"last_bargain_date":"2026-04-01","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":"9","collected":"555","un_collected":"32778","invoices":"0","un_invoices":"33333","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":1425,"name":"(\u592e\u91c7\u7f51)\u4e2d\u56fd\u56fd\u571f\u52d8\u6d4b\u89c4\u5212\u9662","sales_rep":null,"status3_budgets":"15580","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":"6\u5e7410\u4e2a\u670823\u5929","created_at":"2019-07-11 16:39:14","work_time":0,"work_count":0,"last_bargain_date":"2019-07-11","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":null,"collected":"15580","un_collected":"0","invoices":"15580.00","un_invoices":"0.00","project_count":1,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":1.22,"work1_count":12,"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":1425,"taxonomy_id":2,"name":"\u5b58\u50a8","sum":"15580","sum2":"0","y":100}],"preSalesEngineers":[],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[],"sales_rep_display":"\u516c\u6d77\u5ba2\u6237","datas2":[]},{"id":3459,"name":"\u6d4b\u8bd5","sales_rep":null,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"1\u5929","created_at":"2026-06-02 15:23:56","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":"0","collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u516c\u6d77\u5ba2\u6237","datas2":[]},{"id":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09","sales_rep":5087,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"1\u5e748\u4e2a\u670829\u5929","created_at":"2024-09-04 16:05:44","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u5236\u9020","client_industry_id":5,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":"1","collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":0.77,"work1_count":9,"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\u5fae","datas2":[]},{"id":3217,"name":"\u9752\u5c9b\u535a\u6069\u5fb7\u68c0\u6d4b\u6709\u9650\u516c\u53f8","sales_rep":1013,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"2\u5e7423\u5929","created_at":"2024-05-10 18:02:10","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"score":"12","collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u7fc1\u5bb6\u6210","datas2":[]},{"id":3170,"name":"\u83f2\u7279\uff08\u5929\u6d25\uff09\u68c0\u6d4b\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":1013,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"2\u5e7423\u5929","created_at":"2024-05-10 18:02:03","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"score":"12","collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u7fc1\u5bb6\u6210","datas2":[]},{"id":2446,"name":"\u5175\u5668\u5de5\u4e1a\u4e1c\u5317\u538b\u529b\u5bb9\u5668\u68c0\u6d4b\u7ad9","sales_rep":5332,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"3\u5e747\u4e2a\u67089\u5929","created_at":"2022-10-25 16:44:50","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u5236\u9020","client_industry_id":5,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u970d\u536b\u8d85","datas2":[]},{"id":2436,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u8bd5\u9a8c\u6d4b\u8bd5\u7814\u7a76\u9662(\u9655\u897f)","sales_rep":5332,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"3\u5e747\u4e2a\u67089\u5929","created_at":"2022-10-25 16:30:12","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u5236\u9020","client_industry_id":5,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u970d\u536b\u8d85","datas2":[]},{"id":2285,"name":"\u6cb3\u5317\u592a\u884c\u8ba1\u91cf\u68c0\u6d4b\u6709\u9650\u516c\u53f8","sales_rep":5332,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"3\u5e747\u4e2a\u670810\u5929","created_at":"2022-10-24 11:21:53","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u5236\u9020","client_industry_id":5,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u970d\u536b\u8d85","datas2":[]},{"id":2272,"name":"\u5317\u4eac\u5317\u65b9\u4fe1\u6052\u8ba1\u91cf\u68c0\u6d4b\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5332,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"3\u5e747\u4e2a\u670816\u5929","created_at":"2022-10-17 17:38:48","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u5236\u9020","client_industry_id":5,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"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":"\u970d\u536b\u8d85","datas2":[]},{"id":2151,"name":"\u5317\u4eac\u534e\u822a\u65e0\u7ebf\u7535\u6d4b\u91cf\u7814\u7a76\u6240\u73af\u5883\u5b9e\u9a8c\u4e2d\u5fc3 35\u6240","sales_rep":5087,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":2,"ircount":0,"service_time":"3.91","service_count":2,"sales_rep_time":"4\u5e743\u4e2a\u670812\u5929","created_at":"2022-02-19 12:38:55","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":"75","cooperated":false,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"score":"31","collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":2,"other_budgets":"500000","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":14.07,"work1_count":57,"work2_time":0.5,"work2_count":1,"work3_time":0,"work3_count":0,"work4_time":0,"work4_count":0,"work5_time":0,"work5_count":0,"datas":[],"preSalesEngineers":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","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}],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[{"id":5125,"client_id":2151,"last_engineer":1017,"callback":{"id":4256,"client_id":2151,"contact_id":3959,"description":"48\u5c0f\u65f6\u540e\u8bc4\u4ef7","callback_date":"2022-04-02","created_by":5311,"created_at":"2022-04-02 17:25:36","updated_at":"2022-04-02 17:25:36","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":5125,"mp_submit_contact_id":3959}},{"id":8408,"client_id":2151,"last_engineer":1015,"callback":{"id":7436,"client_id":2151,"contact_id":3959,"description":"","callback_date":"2025-05-22","created_by":5445,"created_at":"2025-05-22 11:17:21","updated_at":"2025-05-22 11:17:21","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":8408,"mp_submit_contact_id":null}}],"sales_rep_display":"\u5218\u5fae","datas2":[]},{"id":2105,"name":"\u5357\u5fb7\u8ba4\u8bc1\u68c0\u6d4b(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","sales_rep":5311,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":1,"service_time":"1","service_count":1,"sales_rep_time":"4\u5e749\u4e2a\u67081\u5929","created_at":"2021-09-01 18:54:53","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":"150","cooperated":false,"client_industry":null,"client_industry_id":null,"client_type":null,"client_type_id":null,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":1,"other_budgets":"600000","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":15.92,"work1_count":14,"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":[{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":10,"skill_score":10}],"completedImplementCases":[{"id":4660,"client_id":2105,"last_engineer":1015,"callback":{"id":3821,"client_id":2105,"contact_id":3724,"description":"","callback_date":"2021-09-17","created_by":5311,"created_at":"2021-09-17 13:46:53","updated_at":"2021-09-17 13:46:53","implement_id":null,"satisfaction_score":10,"skill_score":10,"case_id":4660,"mp_submit_contact_id":null}}],"completedPreSalesCases":[],"sales_rep_display":"\u62d3\u5b9e\u79d1\u6280","datas2":[]},{"id":2000,"name":"\u8def\u5b89\u4ea4\u79d1(\u5317\u4eac)\u76d1\u6d4b\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":null,"status3_budgets":"0","status3_profits":"0","status3_count":0,"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":"5\u5e745\u4e2a\u670830\u5929","created_at":"2020-12-04 09:23:33","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u5176\u4ed6","client_industry_id":20,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","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":"\u516c\u6d77\u5ba2\u6237","datas2":[]},{"id":56,"name":"\u4e2d\u56fd\u53cd\u6d17\u94b1\u76d1\u6d4b\u5206\u6790\u4e2d\u5fc3","sales_rep":null,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":2,"ircount":0,"service_time":"2.25","service_count":2,"sales_rep_time":"9\u5e743\u4e2a\u670817\u5929","created_at":"2017-02-13 19:33:26","work_time":0,"work_count":0,"last_bargain_date":null,"reimbursement_amount":0,"points":0,"cooperated":false,"client_industry":"\u91d1\u878d","client_industry_id":10,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"score":null,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":1,"other_budgets":"500000","used_clients":0,"status12_budgets":"0","status12_profits":"0","work1_time":7.95,"work1_count":24,"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":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"satisfaction_score":"","skill_score":""},{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"satisfaction_score":"","skill_score":""}],"implementEngineers":[],"completedImplementCases":[],"completedPreSalesCases":[{"id":96,"client_id":56,"last_engineer":1017,"callback":null},{"id":906,"client_id":56,"last_engineer":1015,"callback":null}],"sales_rep_display":"\u516c\u6d77\u5ba2\u6237","datas2":[]}],"pagenation":{"totalcount":19,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-03 16:49:42', 124924160) RETURNING "id" |
| 16:49:42.281 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "client_id" IN (1121, 539, 1034, 2526, 166, 3457, 1425, 3459, 3300, 3217, 3170, 2446, 2436, 2285, 2272, 2151, 2105, 2000, 56) |
| 16:49:42.313 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "case_id" IN (4814, 4815, 5125, 3475, 3498, 3517, 1769, 2134, 1761, 2135, 2165, 2152, 2139, 1766, 1814, 1733, 1786, 1868, 1840, 2143, 2144, 2161, 96, 906, 990, 1359, 1406, 1492, 1531, 1532, 1555, 1571, 1652, 1687, 1690, 1692, 1718, 3317, 3329, 3324, 3616, 3619, 3985, 4564, 4559, 4565, 5368, 5593, 6065, 8217, 8408) |
| 16:49:42.293 | 2.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "client_id" IN (1121, 539, 1034, 2526, 166, 3457, 1425, 3459, 3300, 3217, 3170, 2446, 2436, 2285, 2272, 2151, 2105, 2000, 56) |
| 16:49:42.304 | 1.4 ms | yii\db\Command::query | SELECT "id", "client_id", "last_engineer" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status"=5) AND ("case_type"=2) AND ("client_id" IN (1121, 539, 1034, 2526, 166, 3457, 1425, 3459, 3300, 3217, 3170, 2446, 2436, 2285, 2272, 2151, 2105, 2000, 56)) |
| 16:49:42.312 | 1.0 ms | yii\db\Command::query | SELECT "id", "client_id", "last_engineer" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status"=5) AND ("case_type"=1) AND ("client_id" IN (1121, 539, 1034, 2526, 166, 3457, 1425, 3459, 3300, 3217, 3170, 2446, 2436, 2285, 2272, 2151, 2105, 2000, 56)) |
| 16:49:42.195 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:49:42.197 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:49:42.292 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1022, 1017, 1015, 5074, 1023, 1016, 5296) |
| 16:49:42.304 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 1015, 1022, 5085, 5296, 5248, 5082, 1016, 5081, 1023, 1018, 1020, 5125, 5247) |
| 16:49:42.195 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |