ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1cff4c2593d: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-client-cost at 2026-06-01 11:41:00 am by 221.216.117.119

Database Queries

总计6条数据
TimeDurationTypeQuery
  
11:41:00.1560.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:41:00.1571.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:41:00.162206.4 msSELECTSELECT COUNT(*) FROM (SELECT c.*, CASE WHEN erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct, CASE WHEN erp_sales_amount + erp_other_income_amount != 0 THEN erp_use_amount / (erp_sales_amount + erp_other_income_amount) ELSE NULL END as erp_cost_pct FROM (SELECT c.*, COALESCE(sum(o.outbound_cost), 0) as erp_cost_amount, COALESCE(sum(o.outbound_amount), 0) as erp_sales_amount, COALESCE(sum(eoi.amount), 0) as erp_other_income_amount, COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) as erp_use_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) as erp_profit_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0)) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) as erp_labor_cost_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) + COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) as erp_j_profit_deduct_labor_amount, COALESCE(sum(ectt.amount), 0) - COALESCE(sum(ept.amount), 0) as collect_amount, COALESCE(sum(scs.un_collect_amount), 0) as un_collect_amount, COALESCE(sum(p.project_count), 0) as project_count, COALESCE(sum(scs.budget), 0) as budget FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, count(distinct t.id) as project_count FROM "a57be577deb434"."tbl_projects" "t" WHERE ("t"."project_status"=3) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "p" ON c.id = p.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT c.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.id = t.contact_id WHERE ("t"."status"=2) AND (c.client_id IS NOT NULL) GROUP BY "c"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id as client_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.id IS NULL) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT cpc.client_id, COALESCE(sum(cpc.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.client_id IS NOT NULL) GROUP BY "cpc"."client_id") "ecctcpc" ON c.id = ecctcpc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ectt" ON c.id = ectt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ept" ON c.id = ept.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id LEFT JOIN (SELECT ct.client_id as client_id, COALESCE(sum(CASE WHEN ct.work_hours > 0 THEN COALESCE(payroll.amount, 0) / GREATEST(( SELECT COUNT(1) FROM generate_series(ct.settle_month::timestamp, (ct.settle_month + interval '1 month - 1 day')::timestamp, interval '1 day') AS work_dates(work_date) LEFT JOIN a57be577deb434.tbl_legal_holidays lh ON lh.edate = work_dates.work_date::date LEFT JOIN a57be577deb434.tbl_punch_strategy_schedules pss ON pss.edate = work_dates.work_date::date AND pss.punch_strategy_id = ps.id WHERE CASE WHEN ps.id IS NULL THEN EXTRACT(ISODOW FROM work_dates.work_date)::integer BETWEEN 1 AND 5 WHEN pss.id IS NOT NULL THEN pss.need_work WHEN ps.legal_holiday AND lh.id IS NOT NULL THEN lh.is_exchange ELSE (ps.week::integer & (1 << (EXTRACT(ISODOW FROM work_dates.work_date)::integer - 1))) <> 0 END ), 1) / GREATEST((CASE WHEN ps.id IS NULL THEN 8 WHEN ps.punch_type = 0 THEN 8 WHEN ps.work_hour IS NOT NULL AND ps.work_hour > 0 THEN ps.work_hour ELSE 8 END), 1) * ct.work_hours ELSE 0 END), 0) as erp_labor_cost_amount FROM ((SELECT p.id as ticket_id, 'preSales' as ticket_type, '售前' as ticket_type_name, p.ticket_no, p.case_id, c.case_no, COALESCE(p.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, p.engineer_id, p.start_at, p.end_at, date_trunc('month', p.start_at)::date as settle_month, EXTRACT(EPOCH FROM (p.end_at - p.start_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = p.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(p.client_id, c.client_id) WHERE (p.start_at IS NOT NULL) AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.client_id IS NOT NULL GROUP BY "ct"."client_id") "ctlc" ON c.id = ctlc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as budget, COALESCE(sum(t.erp_un_settle_amount), 0) as un_collect_amount FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY erp_labor_cost_amount DESC NULLS LAST, c.updated_at DESC) "c"

[+] Explain
11:41:00.369240.4 msSELECTSELECT c.*, CASE WHEN erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct, CASE WHEN erp_sales_amount + erp_other_income_amount != 0 THEN erp_use_amount / (erp_sales_amount + erp_other_income_amount) ELSE NULL END as erp_cost_pct FROM (SELECT c.*, COALESCE(sum(o.outbound_cost), 0) as erp_cost_amount, COALESCE(sum(o.outbound_amount), 0) as erp_sales_amount, COALESCE(sum(eoi.amount), 0) as erp_other_income_amount, COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) as erp_use_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) as erp_profit_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0)) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) as erp_labor_cost_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) + COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) as erp_j_profit_deduct_labor_amount, COALESCE(sum(ectt.amount), 0) - COALESCE(sum(ept.amount), 0) as collect_amount, COALESCE(sum(scs.un_collect_amount), 0) as un_collect_amount, COALESCE(sum(p.project_count), 0) as project_count, COALESCE(sum(scs.budget), 0) as budget FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, count(distinct t.id) as project_count FROM "a57be577deb434"."tbl_projects" "t" WHERE ("t"."project_status"=3) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "p" ON c.id = p.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT c.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.id = t.contact_id WHERE ("t"."status"=2) AND (c.client_id IS NOT NULL) GROUP BY "c"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id as client_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.id IS NULL) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT cpc.client_id, COALESCE(sum(cpc.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.client_id IS NOT NULL) GROUP BY "cpc"."client_id") "ecctcpc" ON c.id = ecctcpc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ectt" ON c.id = ectt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ept" ON c.id = ept.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id LEFT JOIN (SELECT ct.client_id as client_id, COALESCE(sum(CASE WHEN ct.work_hours > 0 THEN COALESCE(payroll.amount, 0) / GREATEST(( SELECT COUNT(1) FROM generate_series(ct.settle_month::timestamp, (ct.settle_month + interval '1 month - 1 day')::timestamp, interval '1 day') AS work_dates(work_date) LEFT JOIN a57be577deb434.tbl_legal_holidays lh ON lh.edate = work_dates.work_date::date LEFT JOIN a57be577deb434.tbl_punch_strategy_schedules pss ON pss.edate = work_dates.work_date::date AND pss.punch_strategy_id = ps.id WHERE CASE WHEN ps.id IS NULL THEN EXTRACT(ISODOW FROM work_dates.work_date)::integer BETWEEN 1 AND 5 WHEN pss.id IS NOT NULL THEN pss.need_work WHEN ps.legal_holiday AND lh.id IS NOT NULL THEN lh.is_exchange ELSE (ps.week::integer & (1 << (EXTRACT(ISODOW FROM work_dates.work_date)::integer - 1))) <> 0 END ), 1) / GREATEST((CASE WHEN ps.id IS NULL THEN 8 WHEN ps.punch_type = 0 THEN 8 WHEN ps.work_hour IS NOT NULL AND ps.work_hour > 0 THEN ps.work_hour ELSE 8 END), 1) * ct.work_hours ELSE 0 END), 0) as erp_labor_cost_amount FROM ((SELECT p.id as ticket_id, 'preSales' as ticket_type, '售前' as ticket_type_name, p.ticket_no, p.case_id, c.case_no, COALESCE(p.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, p.engineer_id, p.start_at, p.end_at, date_trunc('month', p.start_at)::date as settle_month, EXTRACT(EPOCH FROM (p.end_at - p.start_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = p.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(p.client_id, c.client_id) WHERE (p.start_at IS NOT NULL) AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.client_id IS NOT NULL GROUP BY "ct"."client_id") "ctlc" ON c.id = ctlc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as budget, COALESCE(sum(t.erp_un_settle_amount), 0) as un_collect_amount FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY erp_labor_cost_amount DESC NULLS LAST, c.updated_at DESC LIMIT 40 OFFSET 40

[+] Explain
11:41:00.6100.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5295, 5087, 5300)

[+] Explain
11:41:00.6142.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-client-cost', '{"created_at_period":"","sales_rep":"","created_at_to":"","created_at_from":"","Filter":{"name":"erp_labor_cost_amount","sort":"DESC"},"page":"2","pageSize":"40","listReload":"undefined","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)","abbr":"","pinyin_shortcut":"SMCbjzzyxgscfkh","description":"smc\u4e2d\u56fd\u516c\u53f8\u5317\u4eac\u5206\u5382","corp_rep":"\u8d75\u5f64","website":"","capital":"","established_at":"2000-12-31","headcount":"3000","reg_address":"","working_address":2303,"telephone":"80480101","fax":"","scale":"10","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":6,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1003,"created_at":"2020-09-29 09:58:29","updated_at":"2026-05-18 14:33:52","main_business":"\u5236\u9020\u5de5\u4e1a\u81ea\u52a8\u5316\u5143\u4ef6","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-10-28 17:59:19","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":3,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":6,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"3906.00","erp_profit_amount":"0","erp_j_profit_amount":"-3906.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-3906","collect_amount":"142256.37","un_collect_amount":"0","project_count":"9","budget":"142256.37","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","abbr":"","pinyin_shortcut":"gabdyyjszdgdgs","description":"","corp_rep":"\u9648\u671d\u6b66","website":"","capital":"18000","established_at":"1992-06-23","headcount":"","reg_address":"","working_address":634,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":1,"client_type":1,"sales_rep":1005,"main_contact":"","created_by":1001,"created_at":"2017-07-04 15:14:12","updated_at":"2026-05-18 13:48:27","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":0,"contact_count":4,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"1297925.00","un_collect_amount":"0","project_count":"2","budget":"1297925","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":3429,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"gzsaxxjsgfyxgs","description":"","corp_rep":"\u9648\u5fd7\u8363","website":"www.gzsa.net","capital":"2000","established_at":"2004-02-18","headcount":"","reg_address":"","working_address":"","telephone":"020-87563180","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-12-04 15:48:49","updated_at":"2026-05-15 13:07:30","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-12-04 15:48:49","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":6029,"tax_no":"91440116757793663E","erp_cost_amount":"3516028","erp_sales_amount":"3587784","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"71756","erp_j_profit_amount":"71756","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"71756","collect_amount":"3587784","un_collect_amount":"0","project_count":"1","budget":"3587784","erp_j_profit_pct":2,"erp_profit_pct":2,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40","abbr":"","pinyin_shortcut":"zgkxyxzglj","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":1522,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":"","client_industry":1,"client_type":6,"sales_rep":5295,"main_contact":"","created_by":1006,"created_at":"2018-08-27 11:47:28","updated_at":"2026-05-13 15:00:43","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-10-21 09:55:29","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":5,"visit_count":4,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"25600","erp_sales_amount":"36200","erp_other_income_amount":"0","erp_use_amount":"1215","erp_profit_amount":"10600","erp_j_profit_amount":"9385","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"9385","collect_amount":"2863972.00","un_collect_amount":"0","project_count":"4","budget":"2863972","erp_j_profit_pct":25.93,"erp_profit_pct":29.28,"erp_cost_pct":3.36,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","abbr":"","pinyin_shortcut":"zgmhglgbxy","description":"","corp_rep":"\u4e8e\u5251","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"010-64720239","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":80,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-12-19 13:31:40","updated_at":"2026-05-12 13:48:50","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a \u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a 121000004008366672\n\u5f00\u6237\u94f6\u884c\uff1a \u5de5\u5546\u94f6\u884c\u5317\u4eac\u56db\u5143\u6865\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a 0200080509026401168\n\u5730\u5740\uff1a \u5317\u4eac\u5e02\u671d\u9633\u533a\u82b1\u5bb6\u5730\u4e1c\u8def3\u53f7\n\u8054\u7cfb\u7535\u8bdd\uff1a 010-64720239","logo":"","en_name":"","pick_at":"2025-12-19 13:31:40","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":3,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"354000","erp_other_income_amount":"0","erp_use_amount":"276125","erp_profit_amount":"354000","erp_j_profit_amount":"77875","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"77875","collect_amount":"0","un_collect_amount":"354000","project_count":"2","budget":"354000","erp_j_profit_pct":22,"erp_profit_pct":100,"erp_cost_pct":78,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjydsbkjyxgsgd","description":"","corp_rep":"\u9648\u84c9","website":"","capital":"1000","established_at":"2010-02-01","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":5359,"created_at":"2023-10-23 21:18:16","updated_at":"2026-05-09 18:11:24","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101085514397148\n\u5730\u5740\uff0c\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u897f\u8def32\u53f7\u697c16\u5c421806\u5ba4 010-82095611\n\u5f00\u6237\u884c\u53ca\u5e10\u53f7\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5317\u592a\u5e73\u5e84\u652f\u884c 0200010019200496640","logo":"","en_name":"","pick_at":"2025-01-13 16:21:22","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"122000","un_collect_amount":"0","project_count":"1","budget":"122000","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2538,"name":"(\u8fc7\u5355)\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"gdbjklltkjfzgfyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":3089,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":5295,"created_at":"2023-05-18 11:35:22","updated_at":"2026-05-09 18:10:57","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-11-13 10:19:31","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"289370","un_collect_amount":"0","project_count":"2","budget":"289370","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","abbr":"","pinyin_shortcut":"smctjzzyxgscfkh","description":"smc\u5206\u516c\u53f8","corp_rep":"\u8d75\u5f64","website":"","capital":"200000.000000","established_at":"2016-04-18","headcount":"500","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"20","purchase_freq":"3","company_nature":6,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1003,"created_at":"2017-03-06 15:44:05","updated_at":"2026-05-09 17:18:35","main_business":"\u6c14\u538b\u52a8\u529b\u673a\u68b0\u53ca\u90e8\u4ef6\u3001\u5de5\u4e1a\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u53ca\u90e8\u4ef6\u7684\u5236\u9020\u3001","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-10-30 09:56:39","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":3,"client_key_info_count":2,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"67852.23","un_collect_amount":"0","project_count":"4","budget":"67852.23","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","abbr":"","pinyin_shortcut":"tszjh","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":3438,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2024-03-04 13:47:14","updated_at":"2026-05-09 17:11:06","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-03-04 13:47:14","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":10,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjwxykjyxgs","description":"\u6881\u5b87\u4ecb\u7ecd","corp_rep":"\u674e\u4e1c","website":"http:\/\/www.netcell.cn","capital":"500","established_at":"2005-11-18","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2020-06-23 16:16:09","updated_at":"2026-05-09 17:07:04","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"222","erp_profit_amount":"0","erp_j_profit_amount":"-222","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-222","collect_amount":"514761.00","un_collect_amount":"0","project_count":"1","budget":"514761.00","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjcslxkjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":5295,"main_contact":"","created_by":1011,"created_at":"2026-03-20 13:38:56","updated_at":"2026-05-09 09:47:38","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-03-20 13:38:56","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3319,"name":"\u4e2d\u79d1\u4fe1\u606f\u5b89\u5168\u5171\u6027\u6280\u672f\u56fd\u5bb6\u5de5\u7a0b\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zkxxaqgxjsgjgcyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":"","client_industry":13,"client_type":5,"sales_rep":"","main_contact":"","created_by":5420,"created_at":"2024-11-12 15:16:45","updated_at":"2026-04-30 13:52:47","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-11-12 15:16:45","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjwfxsjxxjsyxgsgd","description":"\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u7d2b\u7af9\u9662\u8def\u5e7f\u6e90\u95f85\u53f75\u5c425132","corp_rep":"\u9648\u9521\u5f3a","website":"www.wafersystems.com","capital":"1500","established_at":"2001-01-12","headcount":"","reg_address":"","working_address":"","telephone":"010-85184988","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-07-02 09:55:22","updated_at":"2026-04-30 13:49:40","main_business":"","deleted":false,"capital_currency":"usd","invoice_info":"","logo":"","en_name":"","pick_at":"2026-01-12 09:41:29","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":4137,"tax_no":"","erp_cost_amount":"1046515","erp_sales_amount":"1630000","erp_other_income_amount":"0","erp_use_amount":"413472","erp_profit_amount":"583485","erp_j_profit_amount":"170013","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"170013","collect_amount":"228000","un_collect_amount":"1629001","project_count":"2","budget":"1858000","erp_j_profit_pct":10.43,"erp_profit_pct":35.8,"erp_cost_pct":25.37,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjzbszkjyxgs","description":"","corp_rep":"\u853a\u5b5d\u8f89","website":"","capital":"1000","established_at":"2024-06-28","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2026-01-22 11:50:06","updated_at":"2026-04-30 13:48:32","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110108MADPU4EL94\n\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u519c\u5927\u5357\u8def1\u53f7\u96622\u53f7\u697c2\u5c42\u529e\u516cA-205\n\u7535\u8bdd\uff1a13911694094\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a110963366510001","logo":"","en_name":"","pick_at":"2026-01-22 11:50:06","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"91110108MADPU4EL94","erp_cost_amount":"0","erp_sales_amount":"29800","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"29800","erp_j_profit_amount":"29800","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"29800","collect_amount":"29800","un_collect_amount":"0","project_count":"1","budget":"29800","erp_j_profit_pct":100,"erp_profit_pct":100,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","abbr":"","pinyin_shortcut":"bjjhjstxyjs304","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-24 06:21:13","updated_at":"2026-04-29 18:13:44","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-09-18 16:36:05","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":21,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":3,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"46757.92","erp_profit_amount":"0","erp_j_profit_amount":"-46757.92","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-46757.92","collect_amount":"2421956","un_collect_amount":"21700","project_count":"14","budget":"2928656","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":1956,"name":"\u5ea6\u5c0f\u6ee1\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"dxmkjbjyxgs","description":"","corp_rep":"\u8bb8\u4e1c\u4eae","website":"","capital":"1111200","established_at":"2015-01-19","headcount":"","reg_address":"","working_address":2320,"telephone":"010-61951001","fax":"010-61951002","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":10,"client_type":5,"sales_rep":"","main_contact":"","created_by":1001,"created_at":"2020-11-06 09:35:00","updated_at":"2026-04-23 16:20:14","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"1066393.00","un_collect_amount":"0","project_count":"1","budget":"1066393.00","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjtskjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":"","client_industry":"","client_type":"","sales_rep":"","main_contact":"","created_by":5064,"created_at":"2022-05-10 13:56:33","updated_at":"2026-04-22 15:46:14","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-05-10 13:56:33","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"3000","erp_use_amount":"39557.9633333332","erp_profit_amount":"0","erp_j_profit_amount":"-36557.9633333332","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-36557.9633333332","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":1318.6,"salesRep":""},{"id":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjcagtkjfzyxgs","description":"","corp_rep":"\u675c\u78ca","website":"","capital":"200","established_at":"2016-06-20","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2024-06-26 10:41:52","updated_at":"2026-04-20 14:20:08","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a \u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8 \n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91110114MA006F0W2X \n\u5730\u5740\u7535\u8bdd\uff1a \u5317\u4eac\u5e02\u660c\u5e73\u533a\u57ce\u5357\u8857\u9053\u9f99\u6c34\u8def28\u53f7\u697c-1\u81f32\u5c42028-3\u5185-1\u5c42B101 010-58444180 \n\u5f00\u6237\u94f6\u884c\u53ca\u5e10\u53f7\uff1a \u5174\u4e1a\u94f6\u884c\u5317\u4eac\u5206\u884c\u957f\u5b89\u652f\u884c 321120100100304908 ","logo":"","en_name":"","pick_at":"2024-06-26 10:41:52","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"121.83","erp_profit_amount":"0","erp_j_profit_amount":"-121.83","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-121.83","collect_amount":"198354","un_collect_amount":"0","project_count":"1","budget":"198354","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3424,"name":"\u5317\u4eac\u888b\u9f20\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjdsykjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":19,"client_type":5,"sales_rep":"","main_contact":"","created_by":1011,"created_at":"2025-11-18 14:53:54","updated_at":"2026-04-18 16:55:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3454,"name":"\u7a37\u5c71\u53bf\u5b89\u536b\u58eb\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"jsxawsdzjsyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":5295,"main_contact":"","created_by":1011,"created_at":"2026-03-10 13:49:38","updated_at":"2026-04-16 10:36:45","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-03-10 13:49:38","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)","abbr":"","pinyin_shortcut":"gabdyyjssb","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":47,"client_industry":1,"client_type":1,"sales_rep":1005,"main_contact":"","created_by":1004,"created_at":"2023-12-18 17:36:53","updated_at":"2026-04-15 16:55:04","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-15 16:55:04","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":4,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"1879959.619999999","erp_sales_amount":"2551700","erp_other_income_amount":"0","erp_use_amount":"381307.18","erp_profit_amount":"671740.380000001","erp_j_profit_amount":"290433.200000001","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"290433.200000001","collect_amount":"3576190","un_collect_amount":"765510","project_count":"2","budget":"4341700","erp_j_profit_pct":11.38,"erp_profit_pct":26.33,"erp_cost_pct":14.94,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":73,"name":"\u5317\u4eac\u5e02\u653f\u4ea4\u901a\u4e00\u5361\u901a\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjszjtyktyxgs","description":"","corp_rep":"\u71d5\u6e05 ","website":" http:\/\/www.bmac.com.cn","capital":"20292","established_at":"2000-10-23","headcount":"500","reg_address":162,"working_address":640,"telephone":" 010-88087755","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":"","client_industry":1,"client_type":1,"sales_rep":"","main_contact":"","created_by":1005,"created_at":"2017-02-16 17:10:25","updated_at":"2026-04-09 17:13:23","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-06-08 23:02:32","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"\u5e02\u653f\u4ea4\u901a\u4e00\u5361\u901a\u3001\u5317\u4eac\u4e92\u901a\u5361\u3001\u5e02\u90ca\u94c1\u8def\u4e00\u5361\u901a\u3001\u6587\u5316\u521b\u610f\u5361\u3001\u516c\u5171\u670d\u52a1\u5361","client_base_info_count":6,"client_key_info_count":2,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"9019","erp_profit_amount":"0","erp_j_profit_amount":"-9019","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-9019","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"ltkjshyxgs","description":"\u53d1\u7968\u5bc4\u9001\u5730\u5740\uff1a\u4e0a\u6d77\u5e02\u9759\u5b89\u533a\u6c5f\u573a\u897f\u8def299\u5f0449\u53f7\u4e2d\u94c1\u4e2d\u73af\u65f6\u4ee3\u5e7f\u573a1\u53f7\u697c1201B \u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8 \u8d22\u52a1\u4e18\u794e\u7a0b 021-61421866","corp_rep":"CHIA HONG LOONG ERIC","website":"","capital":"1000","established_at":"2006-04-09","headcount":"","reg_address":"","working_address":3793,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2024-07-03 14:38:20","updated_at":"2026-04-08 15:49:36","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0: \u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8\n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91310000786707955D\n\u516c\u53f8\u5730\u5740\u53ca\u7535\u8bdd:\u3000\u4e0a\u6d77\u5e02\u9759\u5b89\u533a\u6c5f\u573a\u897f\u8def299\u5f0449\u53f71201-3\u30011201-4\u30011201-5\u5ba4\u00a0\u00a0\u00a0 021-61421866\n\u5f00\u6237\u94f6\u884c\u3001\u8d26\u53f7\uff1a\u4ea4\u901a\u94f6\u884c\u5e02\u5317\u5de5\u4e1a\u533a\u652f\u884c\u00a0 310066247018160174864\u00a0 ","logo":"","en_name":"","pick_at":"2024-07-03 14:38:20","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"tax_no":"","erp_cost_amount":"339350.2","erp_sales_amount":"402069.99","erp_other_income_amount":"0","erp_use_amount":"23352","erp_profit_amount":"62719.79","erp_j_profit_amount":"39367.79","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"39367.79","collect_amount":"469387.86","un_collect_amount":"309425.78","project_count":"5","budget":"778813.64","erp_j_profit_pct":9.79,"erp_profit_pct":15.6,"erp_cost_pct":5.81,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3458,"name":"\u800c\u7279\u7279\u70ed\u7279\u70ed","abbr":"","pinyin_shortcut":"ettrtr","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":1,"client_industry":57,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-04-08 15:42:23","updated_at":"2026-04-08 15:42:51","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-08 15:42:23","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","abbr":"","pinyin_shortcut":"xjxsxscsfp","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":1,"client_class":1,"client_industry":57,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-04-01 11:21:52","updated_at":"2026-04-01 11:30:25","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-01 11:21:52","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"1","erp_sales_amount":"33333","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"33332","erp_j_profit_amount":"33332","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"33332","collect_amount":"555","un_collect_amount":"32778","project_count":"1","budget":"33333","erp_j_profit_pct":100,"erp_profit_pct":100,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2115,"name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e","abbr":"","pinyin_shortcut":"jlsncxyslhs","description":"","corp_rep":"\u9ad8\u58ee","website":"https:\/\/www.jlnls.com\/#\/foot","capital":"1200","established_at":"0200-11-29","headcount":"","reg_address":"","working_address":2635,"telephone":" 0431-89668009","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":10,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2021-11-10 15:07:47","updated_at":"2026-04-01 10:30:23","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-10-07 10:34:58","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"2546953","un_collect_amount":"-2621953","project_count":"0","budget":"2648000","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3439,"name":"\u5317\u4eac\u4e1c\u65b9\u662d\u9633\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjdfzykjfzyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":"","client_industry":20,"client_type":5,"sales_rep":"","main_contact":"","created_by":5476,"created_at":"2026-01-29 15:08:46","updated_at":"2026-03-30 18:09:14","main_business":"","deleted":false,"capital_currency":"","invoice_info":"","logo":"","en_name":"","pick_at":"2026-01-29 15:08:46","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":1,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8\/ \u94a2\u7814\u660a\u666e\uff08\u82cf\u5dde\uff09\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"gyhpkjyxgsgyhpszcxzxyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":5,"client_type":6,"sales_rep":5300,"main_contact":"","created_by":1005,"created_at":"2024-12-25 10:17:44","updated_at":"2026-03-25 15:26:06","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-12-26 16:17:20","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":2,"cooperate_count":0,"case_pre_sales_count":2,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"194","erp_profit_amount":"0","erp_j_profit_amount":"-194","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-194","collect_amount":"0","un_collect_amount":"58000","project_count":"1","budget":"58000","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":3411,"name":"\u5317\u4eac\u57ce\u5efa\u4e9a\u6cf0\u5efa\u8bbe\u96c6\u56e2\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjcjytjsjtyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":9,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1011,"created_at":"2025-10-27 17:01:20","updated_at":"2026-03-25 15:10:18","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-10-27 17:01:20","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09","abbr":"","pinyin_shortcut":"bjscyqlcxxbjscyqlcyey","description":"\u5317\u4eac\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\n\u4e2d\u56fd\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u53cc\u4e95\u652f\u884c\n333756023812","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":2742,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":6,"client_class":43,"client_industry":24,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5300,"created_at":"2022-06-27 11:28:43","updated_at":"2026-03-25 10:21:19","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"BEIJING CITY INTERNATIONAL SCHOOL","pick_at":"2022-06-27 11:28:43","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":4,"visit_count":2,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"3723.99","erp_profit_amount":"0","erp_j_profit_amount":"-3723.99","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-3723.99","collect_amount":"131920.0","un_collect_amount":"0","project_count":"3","budget":"55920","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":"","pinyin_shortcut":"bjkryjkjyxgsgd","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2024-06-03 18:32:12","updated_at":"2026-03-24 21:00:16","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-06-03 18:32:12","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"234.09","erp_profit_amount":"0","erp_j_profit_amount":"-234.09","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-234.09","collect_amount":"127700","un_collect_amount":"0","project_count":"2","budget":"127700","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":3342,"name":"\u4e2d\u56fd\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u7b2c\u56db\u7814\u7a76\u9662\u5341\u4e03\u6240","abbr":"","pinyin_shortcut":"zghtkgjtdsyjysqs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":58,"client_type":6,"sales_rep":5295,"main_contact":"","created_by":5295,"created_at":"2025-03-27 09:44:52","updated_at":"2026-03-24 19:54:54","main_business":"","deleted":false,"capital_currency":"","invoice_info":"","logo":"","en_name":"","pick_at":"2025-03-31 09:39:02","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":3,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"831.00","erp_profit_amount":"0","erp_j_profit_amount":"-831.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-831","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3367,"name":"\u5317\u4eac\u7f51\u667a\u7396\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjwzjakjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5300,"created_at":"2025-05-22 10:36:19","updated_at":"2026-03-24 16:53:47","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-05-22 11:01:36","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":1,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"182.98","erp_profit_amount":"0","erp_j_profit_amount":"-182.98","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-182.98","collect_amount":"8200","un_collect_amount":"0","project_count":"1","budget":"8200","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2242,"name":"\u5317\u4eac\u516b\u5927\u5904\u5965\u535a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u91d1\u5ba2\u6765\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjbdcabkjfzyxgsbjjklxxjsyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":3079,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5298,"created_at":"2022-08-30 15:13:51","updated_at":"2026-03-24 15:59:19","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-08-30 15:13:51","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"101.00","erp_profit_amount":"0","erp_j_profit_amount":"-101.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-101","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":3400,"name":"\u5317\u4eac\u6052\u5927\u4e16\u7eaa\u6559\u80b2\u54a8\u8be2\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjhdsjjyzxyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":25,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1011,"created_at":"2025-09-25 13:25:56","updated_at":"2026-03-24 15:57:24","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-25 13:25:56","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"tjrbzfwlyxgs","description":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u5efa\u56fd\u95e8\u5916\u5927\u88571\u53f7\u56fd\u8d38\u4e09\u671fB\u5ea758\u5c42 ","corp_rep":"\u5b8b\u5f3a","website":"http:\/\/www.reapal.com\/","capital":"30000","established_at":"2011-02-28","headcount":"100","reg_address":707,"working_address":"","telephone":"010-88009439 ","fax":"","scale":"","branch":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8\u4e0a\u6d77\u5206\u516c\u53f8\u3001\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8","purchase_scale_per_yr":"500","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":10,"client_type":1,"sales_rep":5300,"main_contact":"","created_by":1007,"created_at":"2017-03-03 22:51:54","updated_at":"2026-03-24 09:51:44","main_business":"\u7b2c\u4e09\u65b9\u652f\u4ed8","deleted":false,"capital_currency":"rmb","invoice_info":"\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a \t911201165693192359 ","logo":"","en_name":"Tianjin Reapal Network Co., Ltd. ","pick_at":"2024-05-29 10:35:41","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":8,"client_key_info_count":2,"contact_count":6,"visit_count":2,"cooperate_count":3,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"6103.6925","erp_profit_amount":"0","erp_j_profit_amount":"-6103.6925","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-6103.6925","collect_amount":"700600","un_collect_amount":"0","project_count":"4","budget":"700600","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\/\u4e2d\u5316\u79cd\u4e1a\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09","abbr":"","pinyin_shortcut":"xzdswkjzgxzdzgtzyxgsbjxrjywlyxgszhzycxzxyxgsCAEEDABIO","description":"1. \u516c\u53f8\u4e1a\u52a1\uff1a\u519c\u4e1a\u751f\u7269\u6280\u672f\u7814\u7a76\u3001\u519c\u4e1a\u751f\u7269\u4ea7\u54c1\u7684\u6279\u53d1\u3001\u8fdb\u51fa\u53e3\u3001\u690d\u7269\u4fdd\u62a4\u4e0e\u73af\u5883\u536b\u751f\u89e3\u51b3\u65b9\u6848\u3002\n2. \u8425\u4e1a\u6536\u5165\uff1a16\u5e74\u662f10\u51e0\u4ebf\n3. IT\u90e8\u95e8\u4eba\u6570\uff1aIT\u90e8\u95e820\u4eba\n4. \u529e\u516c\u4eba\u6570\uff1a\u672c\u5730300\u591a\u4eba\u5de6\u53f3\n5. \u4e1a\u52a1\u7cfb\u7edf\uff1a\n6. \u529e\u516c\u73af\u5883\u7684\u75db\u70b9\uff1a\n7. \u4e1a\u52a1\u73af\u5883\u7684\u75db\u70b9\uff1a","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":6,"client_class":1,"client_industry":57,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1006,"created_at":"2018-11-01 16:59:20","updated_at":"2026-03-24 09:51:43","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"Syngenta (China) Investment Co., Ltd.","pick_at":"2021-08-05 10:19:15","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":9,"visit_count":2,"cooperate_count":3,"case_pre_sales_count":2,"case_implement_count":3,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"105154","erp_sales_amount":"134270","erp_other_income_amount":"0","erp_use_amount":"12852.32","erp_profit_amount":"29116","erp_j_profit_amount":"16263.68","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"16263.68","collect_amount":"1494903.74","un_collect_amount":"0","project_count":"15","budget":"1494903.74","erp_j_profit_pct":12.11,"erp_profit_pct":21.68,"erp_cost_pct":9.57,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":520,"name":"\u5317\u4eac\u4f18\u80fd\u535a\u534e\u6295\u8d44\u7ba1\u7406\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjynbhtzglyxgs","description":"1. \u516c\u53f8\u4e1a\u52a1\uff1a\u524d\u8eab\u662f\u6295\u8d44\u7ba1\u7406\uff0c17\u5e74\u88ab\u53d1\u8fc7\u7684edf\uff08\u6cd5\u7535\u4f18\u80fd\uff09\u6536\u8d2d\u4e86\uff0c\u4e3b\u8981\u505a\u98ce\u7535\uff0c\u7535\u7ad9\u7684\u6295\u8d44\u3002\n2. \u8425\u4e1a\u6536\u5165\uff1a\n3. IT\u90e8\u95e8\u4eba\u6570\uff1a2\u4e2a\uff0c\u4e0a\u9762\u6709\u4e00\u4e2a\u4e9a\u592a\u533a\u9886\u5bfc\n4. \u529e\u516c\u4eba\u6570\uff1a130\u591a\u4eba\uff0c\u5317\u4eac70-80\u4eba\uff0c\u5916\u5730\u9879\u76ee\u4e0a\u53d1\u7535\u5382\u4f1a\u670920\u5de6\u53f3\u4e2a\u9a7b\u573a\u4eba\u5458\u3002\n5. \u4e1a\u52a1\u7cfb\u7edf\uff1a\n6. \u529e\u516c\u73af\u5883\u7684\u75db\u70b9\uff1a\n7. \u4e1a\u52a1\u73af\u5883\u7684\u75db\u70b9\uff1a\u6ca1\u6709\u5b58\u50a8\u3002\u76ee\u524d\u662f\u7528\u7684\u8def\u5766\u529bNas\u7684\u5b58\u50a8\uff0c\u7a7a\u95f4\u9650\u5236\uff0c\u9700\u8981\u8d2d\u4e70\u6388\u6743\uff0c\u6bcf\u5e74\u7684\u6388\u6743\u8d39\u7528\u5f88\u9ad8\u3002\u60f3\u57fa\u4e8eveeam\u505a\u5b58\u50a8\uff0c\u7c7b\u4f3c\u4e8eNFS\uff0c\u57fa\u4e8e\u7f51\u7edc\u3002","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":755,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":6,"client_class":43,"client_industry":10,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1003,"created_at":"2017-10-09 16:23:35","updated_at":"2026-03-24 09:51:43","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":2,"visit_count":4,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"4429.27","erp_profit_amount":"0","erp_j_profit_amount":"-4429.27","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-4429.27","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2173,"name":"\u60a6\u5eb7\u836f\u4e1a\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"ykyyjtgfyxgs","description":"","corp_rep":"\u4e8e\u4f1f\u4ed5","website":"","capital":"45000","established_at":"2001-08-14","headcount":"","reg_address":"","working_address":2703,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":2,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5309,"created_at":"2022-04-12 18:16:13","updated_at":"2026-03-24 09:51:43","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-06-27 18:07:38","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":0,"contact_count":2,"visit_count":2,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"2581.00","erp_profit_amount":"0","erp_j_profit_amount":"-2581.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-2581","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":3379,"name":"\u591a\u70b9\uff08\u6df1\u5733\uff09\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"ddszszkjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":17,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5300,"created_at":"2025-07-02 16:24:05","updated_at":"2026-03-24 09:51:43","main_business":"","deleted":false,"capital_currency":"","invoice_info":"","logo":"","en_name":"","pick_at":"2025-07-04 11:50:35","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":1,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"672","erp_profit_amount":"0","erp_j_profit_amount":"-672","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-672","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}],"pagenation":{"totalcount":1991,"thispage":2,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 11:41:00', 459905792) RETURNING "id"

[+] Explain