6a2a65d7d881e: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-client-cost at 2026-06-11 03:37:59 pm by 221.216.117.119
Database Queries
总计6条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:37:59.892 | 0.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 15:37:59.895 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 15:37:59.906 | 13.2 ms | SELECT | SELECT 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"."bargain_date" >= '2026-01-01 00:00:00') AND ("t"."bargain_date" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."is_draft"=FALSE) OR (p.is_draft IS NULL)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59') AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT 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"."is_draft"=FALSE) OR (i.is_draft IS NULL)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) )) "ct" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = ct.project_id 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) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY "c"."updated_at" DESC) "c" |
| 15:37:59.920 | 58.4 ms | SELECT | 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"."bargain_date" >= '2026-01-01 00:00:00') AND ("t"."bargain_date" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."is_draft"=FALSE) OR (p.is_draft IS NULL)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59') AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT 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"."is_draft"=FALSE) OR (i.is_draft IS NULL)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) )) "ct" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = ct.project_id 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) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY "c"."updated_at" DESC LIMIT 40 |
| 15:37:59.979 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1013, 1005, 5087, 5295, 1004) |
| 15:37:59.983 | 3.8 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-analysis/list-client-cost', '{"created_at_period":"currentfascalyear","sales_rep":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"4eQAiv21khj4ckVl-aCvgG-h5XZj42Z5"}', '{"code":2000,"result":{"list":[{"id":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","abbr":"","pinyin_shortcut":"zgxxaqyjs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"01062305540","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":3,"client_class":1,"client_industry":4,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":5076,"created_at":"2018-05-16 18:55:46","updated_at":"2026-06-10 11:29:10","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-06-27 14:45:57","it_budget":"800","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":2,"client_key_info_count":1,"contact_count":62,"visit_count":1,"cooperate_count":5,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"1670.205","erp_sales_amount":"12703073","erp_other_income_amount":"0","erp_use_amount":"101","erp_profit_amount":"12701402.795","erp_j_profit_amount":"12701301.795","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12701301.795","collect_amount":"103","un_collect_amount":"12812634","project_count":"5","budget":"12812737","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3465,"name":"\u96f6\u552e001","abbr":"","pinyin_shortcut":"ls001","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":43,"client_industry":8,"client_type":3,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-06-09 17:08:39","updated_at":"2026-06-09 17:10:11","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-09 17:08: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":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":3082,"name":"\u5317\u4eac\u6c49\u738b\u9e4f\u82af\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjhwpxkjyxgs","description":"\u6240\u5c5e\u884c\u4e1a\u534a\u5bfc\u4f53\u516c\u53f8\u4ea7\u54c1\u96c6\u6210\u7535\u8def\u8bbe\u8ba1\u5ba2\u6237\u7fa4\u7ade\u4e89\u4f18\u52bf\u7ade\u4e89\u5bf9\u624b\uff08\u542f\u4fe1\u5b9d\u7ade\u54c1\u4fe1\u606f\u660e\u786e\u6807\u660e\uff09\u516c\u53f8\u4eba\u65708\u79d1\u7814\u56e2\u961f\uff08\u542f\u4fe1\u5b9d\u660e\u786e\u6807\u660e\uff09\u4e13\u5229\uff08\u542f\u4fe1\u5b9d\u660e\u786e\u6807\u660e\uff09","corp_rep":"","website":"","capital":"","established_at":"2021-08-16","headcount":"","reg_address":"","working_address":3692,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":57,"client_type":5,"sales_rep":1013,"main_contact":"","created_by":1001,"created_at":"2024-05-10 18:01:54","updated_at":"2026-06-08 20:05: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":2,"client_key_info_count":0,"contact_count":1,"visit_count":1,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":5750,"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":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}},{"id":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjjtsjxxjsyxgsgd","description":"","corp_rep":"\u738b\u4e95\u83b2","website":"","capital":"500","established_at":"2019-04-11","headcount":"","reg_address":"","working_address":"","telephone":"010-82723450","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-05-14 16:30:29","updated_at":"2026-06-05 17:59:52","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\n\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u4e2d\u8def44\u53f757\u5e621\u5c42119\n\u7535\u8bdd\uff1a13269110935\n\u7a0e\u53f7\uff1a91110108MA004NJB20\n\u5f00\u6237\u884c\uff1a\u5174\u4e1a\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u8d26\u53f7\uff1a321090100100334313","logo":"","en_name":"","pick_at":"2025-05-14 16:30: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":5,"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":5957,"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":3415,"name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjzjbxjjyxgs","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":10,"client_type":5,"sales_rep":"","main_contact":"","created_by":1011,"created_at":"2025-10-28 10:42:40","updated_at":"2026-06-05 17:40: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":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":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","abbr":"","pinyin_shortcut":"dgsdfg","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":1,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-05 17:35:57","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-02 16:52: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":0,"client_key_info_count":0,"contact_count":0,"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":"0","un_collect_amount":"0","project_count":"1","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"klhcbjxyjsgfyxgs","description":"\u7535\u8bdd\u53ef\u4ee5\u63a5\u901a\uff0c\u4f46\u662f\u90a3\u8fb9\u4fe1\u53f7\u4e0d\u597d\u8fd8\u662f\u600e\u4e48\uff0c\u8054\u7cfb\u4e24\u6b21\u90fd\u662f\u540c\u6837\u7684\u60c5\u51b5\uff0c\u545c\u545c\u5566\u5566\u6ca1\u4eba\u8bf4\u8bdd\u3002","corp_rep":"\u697c\u67cf\u826f ","website":"http:\/\/www.pharmaron.com\/","capital":"59066.3575","established_at":"2004-07-01","headcount":"1200","reg_address":203,"working_address":"","telephone":"010-57330000 ","fax":"","scale":"","branch":"\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u6709\u9650\u516c\u53f8\u901a\u5dde\u5206\u516c\u53f8","purchase_scale_per_yr":"50","purchase_freq":"","company_nature":6,"client_class":47,"client_industry":5,"client_type":3,"sales_rep":1005,"main_contact":"","created_by":5096,"created_at":"2017-02-21 12:42:50","updated_at":"2026-06-05 11:26:50","main_business":"\u533b\u836f\u751f\u4ea7","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-07-10 10:54:08","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":12,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":5,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"14556.950","erp_profit_amount":"0","erp_j_profit_amount":"-14556.950","erp_labor_cost_amount":"334.890340909091","erp_j_profit_deduct_labor_amount":"-14891.8403409091","collect_amount":"0","un_collect_amount":"500000","project_count":"1","budget":"500000","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":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-06-05 11:14:46","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":1,"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":"120","erp_profit_amount":"0","erp_j_profit_amount":"-120","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-120","collect_amount":"195300","un_collect_amount":"20000000","project_count":"1","budget":"20000000","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"gfrsjxtyxgsgd","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":10,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1005,"created_at":"2023-09-24 21:17:42","updated_at":"2026-06-05 11:14:23","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-15 16:53:08","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":"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":"800","project_count":"1","budget":"800","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"tfzwbjjsyxgstfzwszcbjsgfyxgszgxsqkgpbdzzzsyxgs","description":"\u540d\u79f0\uff1a\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110108710924451B\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5c0f\u53e3\u8def66\u53f7\u4e2d\u5173\u6751\u4e1c\u5347\u79d1\u6280\u56edB-2\u53f7\u697c\u4e8c\u5c42B201-B203\u3001B205-B210\u5ba4(\u4e1c\u5347\u5730\u533a) 62969002-8076\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5efa\u884c\u6e05\u534e\u5927\u5b66\u652f\u884c11001029000052500014\n\n\u540d\u79f0\uff1a\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101086337298973\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6e05\u534e\u56ed\u6e05\u534e\u5927\u5b6636\u533a1407\u30011408\u30011409 62969002-8079\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u62db\u5546\u94f6\u884c\u6e05\u534e\u56ed\u652f\u884c866780465610001\n\n\u540d\u79f0\uff1a\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101087693507203\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5c0f\u53e3\u8def66\u53f7\u4e1c\u5347\u79d1\u6280\u56ed\u5317\u9886\u5730A\u533a\u7b2c2\u53f7\u697c 62969002-8076\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5efa\u884c\u6e05\u534e\u5927\u5b66\u652f\u884c11001029000059809201\n","corp_rep":"\u5218\u957f\u6b23","website":"www.cnki.net","capital":"826.41","established_at":"2004-11-18","headcount":"","reg_address":"","working_address":3501,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":18,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2024-05-07 16:42:41","updated_at":"2026-06-05 11:12:59","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-05-07 16:42: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":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":"0","un_collect_amount":"900","project_count":"1","budget":"900","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","abbr":"","pinyin_shortcut":"bjdpxxxjsyxgsshatdpxznjtjsyxgsshhxgbdtyxgsnbdpxstkjyxgsEDA","description":"\u7a0e\u53f7\uff1a91110108MA002R5L5Y","corp_rep":"\u4f59\u51ef","website":"https:\/\/www.horizon.ai\/","capital":"35000","established_at":"2015-12-28","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":6,"client_class":43,"client_industry":57,"client_type":3,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2022-02-16 10:45:21","updated_at":"2026-06-05 11:12:51","main_business":"","deleted":false,"capital_currency":"usd","invoice_info":"","logo":"","en_name":"","pick_at":"2026-03-23 09:31: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":5,"client_key_info_count":0,"contact_count":5,"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":"333","erp_profit_amount":"0","erp_j_profit_amount":"-333","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-333","collect_amount":"2","un_collect_amount":"420000","project_count":"1","budget":"630000","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjjqzzyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-19 18:01:00","updated_at":"2026-06-05 11:12:45","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-12-19 18:01:00","it_budget":"","deployment_mode":"","it_per_num":"19\u4eba","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":1,"contact_count":6,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":3,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"286525","erp_sales_amount":"333880","erp_other_income_amount":"0","erp_use_amount":"17711.46","erp_profit_amount":"47355","erp_j_profit_amount":"29643.54","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"29643.54","collect_amount":"227328","un_collect_amount":"941552","project_count":"2","budget":"1168880","erp_j_profit_pct":8.88,"erp_profit_pct":14.18,"erp_cost_pct":5.3,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjkjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-19 21:44:13","updated_at":"2026-06-05 11:10:13","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-12-19 21:44:13","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":3,"case_implement_count":10,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"310796","erp_sales_amount":"631660","erp_other_income_amount":"0","erp_use_amount":"2248.74","erp_profit_amount":"320864","erp_j_profit_amount":"318615.26","erp_labor_cost_amount":"661.446306818182","erp_j_profit_deduct_labor_amount":"317953.813693182","collect_amount":"600077","un_collect_amount":"44540520","project_count":"1","budget":"44540520","erp_j_profit_pct":50.44,"erp_profit_pct":50.8,"erp_cost_pct":0.36,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjhcykjyxgs","description":"","corp_rep":"\u6d2a\u79d1","website":"http:\/\/www.bjhdd.com","capital":"100","established_at":"2009-11-04","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":1001,"created_at":"2024-10-16 11:09:32","updated_at":"2026-06-05 10:06:41","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-10-16 11:09:32","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":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":4838,"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":"201.068783068783","erp_j_profit_deduct_labor_amount":"-201.068783068783","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":3407,"name":"\u4e9a\u8428\u5408\u83b1(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"yshlzgtzyxgs","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":10,"client_type":5,"sales_rep":"","main_contact":"","created_by":1011,"created_at":"2025-10-15 13:49:39","updated_at":"2026-06-04 21:16:06","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":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":3281,"name":"\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8(EDA)","abbr":"","pinyin_shortcut":"hxkjbjyxgsEDA","description":"","corp_rep":"","website":"","capital":"107.5269","established_at":"2023-08-18","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":47,"client_industry":57,"client_type":5,"sales_rep":5295,"main_contact":"","created_by":5295,"created_at":"2024-06-27 17:27:09","updated_at":"2026-06-04 20:47:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-06-27 17:27:09","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":2,"visit_count":3,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"51526.61","erp_sales_amount":"63840","erp_other_income_amount":"0","erp_use_amount":"861.24","erp_profit_amount":"12313.39","erp_j_profit_amount":"11452.15","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"11452.15","collect_amount":"185938.2","un_collect_amount":"0","project_count":"1","budget":"63840","erp_j_profit_pct":17.94,"erp_profit_pct":19.29,"erp_cost_pct":1.35,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3315,"name":"\u822a\u5929\u79d1\u5de5206\u6240(\u91cd\u590d)","abbr":"","pinyin_shortcut":"htkg206scf","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":20,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1005,"created_at":"2024-10-27 21:53:27","updated_at":"2026-06-04 20:28:13","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":0,"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":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjszbbjsfwyxgsgd","description":"\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u5ef6\u5e86\u533a\u59ab\u6c34\u5317\u88575\u53f7\u96623\u53f7\u697c1\u5c42101\uff08\u4e2d\u5173\u6751\u5ef6\u5e86\u56ed\uff09","corp_rep":"\u66f9\u5b8f\u5c79","website":"www.shenzhoubb.com","capital":"1591.0363","established_at":"2018-11-29","headcount":"","reg_address":"","working_address":"","telephone":"010-59403162","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":1004,"main_contact":"","created_by":1011,"created_at":"2024-09-10 13:22:33","updated_at":"2026-06-04 20:24:49","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-09-10 13:22: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":6,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":3,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":4612,"tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"5","erp_use_amount":"2576","erp_profit_amount":"0","erp_j_profit_amount":"-2571","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-2571","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":51520,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},{"id":3354,"name":"\u822a\u5929\u79d1\u6280\u4e00\u966215\u6240","abbr":"","pinyin_shortcut":"htkjyy15s","description":"\u4e2d\u56fd\u822a\u5929\u79d1\u6280\u96c6\u56e2\u516c\u53f8\u7b2c\u4e00\u7814\u7a76\u9662\u7b2c\u5341\u4e94\u7814\u7a76\u6240","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":58,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":1005,"created_at":"2025-04-16 09:24:30","updated_at":"2026-06-04 16:19:49","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-04-16 09:24:30","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":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":"0","un_collect_amount":"0","project_count":"0","budget":"0","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":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-06-03 22:57:02","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":"0","erp_other_income_amount":"0","erp_use_amount":"5","erp_profit_amount":"0","erp_j_profit_amount":"-5","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-5","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":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","abbr":"","pinyin_shortcut":"zgzqbyxzrgs","description":"","corp_rep":"\u5f90\u5bff\u677e","website":"www.cs.com.cn","capital":"5000","established_at":"1993-03-18","headcount":"","reg_address":"","working_address":"","telephone":"010-63070225","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":18,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-08-21 12:22:51","updated_at":"2026-06-02 23:12:40","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-08-21 12:22: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":6,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":3,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":5912,"tax_no":"91110000400012043F","erp_cost_amount":"1","erp_sales_amount":"18000","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"17999","erp_j_profit_amount":"17999","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17999","collect_amount":"0","un_collect_amount":"20700","project_count":"3","budget":"20700","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3464,"name":"\u9690\u6027\u9700\u6c42","abbr":"","pinyin_shortcut":"yxxq","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":"","client_industry":57,"client_type":1,"sales_rep":"","main_contact":"","created_by":1001,"created_at":"2026-06-02 16:58:49","updated_at":"2026-06-02 18:08:44","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-02 18:08: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":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":"201.068783068783","erp_j_profit_deduct_labor_amount":"-201.068783068783","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":1188,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","abbr":"","pinyin_shortcut":"zgmtdzzj","description":"","corp_rep":"\u8d75\u5e73\uff08\u515a\u59d4\u6570\u636e\uff0c\u5c40\u957f\uff09","website":"http:\/\/www.ccgc.cn\/","capital":"","established_at":"1953-01-01","headcount":"","reg_address":"","working_address":1612,"telephone":"010-63903775 010-63903982 ","fax":"010-63903707","scale":"2020\u5e74269.92\u4ebf\uff0c2019\u5e74242.10\u4ebf","branch":"\u662f\u56fd\u52a1\u9662\u56fd\u8d44\u59d4\u76f4\u63a5\u7ba1\u7406\u7684\u4e2d\u592e\u4f01\u4e1a\uff0c\u4e0b\u8f96\u4e2d\u5316\u5730\u8d28\u77ff\u5c71\u603b\u5c40\u3001\u4e13\u4e1a\u76f4\u5c5e\u5c40\u3001\u7701\uff08\u533a\uff09\u7164\u70ad\u5730\u8d28\u5c40\u4ee5\u53ca\u4e2d\u5fc3\u3001\u9662\uff08\u961f\uff09\u7b49\u5355\u4f4d200\u4f59\u5bb6\uff0c\u5206\u5e03\u5728\u5168\u56fd22\u4e2a\u7701\uff08\u5e02\u3001\u533a\uff09","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":"","client_industry":16,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":5096,"created_at":"2018-11-06 18:49:53","updated_at":"2026-06-02 17:03:08","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China National Administration of Coal Geology","pick_at":"2025-05-26 17:35:34","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":1,"contact_count":3,"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":"41490","erp_profit_amount":"0","erp_j_profit_amount":"-41490","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-41490","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","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":391,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","abbr":"","pinyin_shortcut":"bjtzjxyjs8359S","description":"\u822a\u5929 8359\u6240","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":1277,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"10","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":20,"client_type":1,"sales_rep":"","main_contact":"","created_by":1004,"created_at":"2017-06-27 16:45:44","updated_at":"2026-06-02 16:55:09","main_business":"\u4fdd\u5bc6","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":1,"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":3463,"name":"3","abbr":"","pinyin_shortcut":"3","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-06-02 16:54:10","updated_at":"2026-06-02 16:54:10","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-02 16:54:10","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":3461,"name":"2","abbr":"","pinyin_shortcut":"2","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":"","main_contact":"","created_by":1001,"created_at":"2026-06-02 15:26:34","updated_at":"2026-06-02 15:26:34","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":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":3460,"name":"23","abbr":"","pinyin_shortcut":"23","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":1005,"main_contact":"","created_by":1001,"created_at":"2026-06-02 15:25:18","updated_at":"2026-06-02 15:25:18","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-02 15:25:18","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":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":3459,"name":"\u6d4b\u8bd5","abbr":"","pinyin_shortcut":"cs","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":80,"client_industry":57,"client_type":1,"sales_rep":"","main_contact":"","created_by":1001,"created_at":"2026-06-02 15:23:56","updated_at":"2026-06-02 15:23:56","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":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":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-06-01 18:41:15","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":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjyckjyxgsgd","description":"","corp_rep":"\u5409\u5a1f","website":"","capital":"500","established_at":"2020-06-03","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":1001,"created_at":"2024-09-19 15:34:42","updated_at":"2026-05-25 10:11:37","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110111MA01RP4H80\n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5174\u5b9c\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a0200 3014 0910 0054 430\n\u5730\u5740\uff1a\u5317\u4eac\u5e02\u623f\u5c71\u533a\u62f1\u8fb0\u8857\u9053\u6708\u534e\u5927\u88571\u53f7A8-667\n\u7535\u8bdd\uff1a13717705170","logo":"","en_name":"","pick_at":"2024-09-19 15:34:42","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":1262,"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":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":"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":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":"0","un_collect_amount":"0","project_count":"0","budget":"0","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":"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":"3587784","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":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":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"117","erp_profit_amount":"0","erp_j_profit_amount":"-117","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-117","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":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":"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":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":"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":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":"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":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":"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":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"}}],"pagenation":{"totalcount":1998,"thispage":1,"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-11 15:37:59', 94995968) RETURNING "id" |