ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2667292b4db: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2026-06-08 02:54:33 pm by 221.216.117.119

Database Queries

总计11条数据
TimeDurationTypeQuery
  
14:54:33.1790.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:54:33.1800.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:54:33.1810.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:54:33.18412.2 msSELECTSELECT COUNT(*) FROM (SELECT p.*, CASE WHEN p.erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN p.erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cash_cost_ticket_amount, COALESCE(sum(ecta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_ticket_amount, COALESCE(sum(eccrta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_convert_amount, COALESCE(sum(esgs.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_gift_amount, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o2.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o2.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_labor_cost_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0) - COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_deduct_labor_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = p.id LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_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.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o2" ON p.id = o2.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id 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 (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT cpc.project_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.project_id IS NOT NULL) GROUP BY "cpc"."project_id") "ecctcpc" ON p.id = ecctcpc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_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.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id LEFT JOIN (SELECT ct.project_id as project_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.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.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.project_id IS NOT NULL GROUP BY "ct"."project_id") "ctlc" ON p.id = ctlc.project_id WHERE "project_status"=3 GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id ORDER BY erp_sales_amount ASC NULLS LAST, p.updated_at DESC) "c"

[+] Explain
14:54:33.197144.1 msSELECTSELECT p.*, CASE WHEN p.erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN p.erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cash_cost_ticket_amount, COALESCE(sum(ecta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_ticket_amount, COALESCE(sum(eccrta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_convert_amount, COALESCE(sum(esgs.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_gift_amount, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o2.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o2.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_labor_cost_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0) - COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_deduct_labor_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = p.id LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_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.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o2" ON p.id = o2.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id 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 (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT cpc.project_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.project_id IS NOT NULL) GROUP BY "cpc"."project_id") "ecctcpc" ON p.id = ecctcpc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_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.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id LEFT JOIN (SELECT ct.project_id as project_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.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.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.project_id IS NOT NULL GROUP BY "ct"."project_id") "ctlc" ON p.id = ctlc.project_id WHERE "project_status"=3 GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id ORDER BY erp_sales_amount ASC NULLS LAST, p.updated_at DESC LIMIT 40

[+] Explain
14:54:33.3420.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3462, 93, 2130, 2125, 2128, 3432, 3389, 982, 2150, 3009, 2593, 399, 146, 1661, 3377, 3435, 1956, 2762, 149, 3278, 48, 3286, 3457, 20, 2182)

[+] Explain
14:54:33.3430.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5087, 1003, 5085, 1015, 1022, 1023, 5248, 1004, 5300)

[+] Explain
14:54:33.3430.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1023, 5085, 1022, 5087, 1004, 1005, 5248, 1015, 5300, 1003))

[+] Explain
14:54:33.3440.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 2, 1)

[+] Explain
14:54:33.3440.8 msSELECTSELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4174, 4146, 3957, 3796, 3854, 4079, 4170, 4155, 4172, 4151, 4169, 4168, 4144, 4167, 4161, 4166, 263, 1111, 2504, 1791, 4098, 4111, 4164, 1972, 3910, 4025, 4113, 3695, 3577, 3873, 4142, 4078, 4157, 4145, 4139)

[+] Explain
14:54:33.3461.7 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-sales-cost', '{"created_at_period":"","collected":"","outbound_at_period":"thismonth","created_at_to":"","created_at_from":"","Filter":{"name":"erp_sales_amount","sort":"ASC"},"page":"1","pageSize":"40","listReload":"true","web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":{"list":[{"id":4174,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","client_id":3462,"budget":"0","updated_at":"2026-06-05 17:35:57","created_at":"2026-06-02 16:52:29","bargain_date":"2026-06-02","collected":"0","un_collected":0,"pinyin_shortcut":"xsxssc20260602001","description":"","id2":4174,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3462,"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4486,"from_project":4174,"is_outbound":false},"buildContract":{"id":4486,"from_project":4174,"is_outbound":false}},{"id":4146,"project_title":"\u98de\u5854\u96f6\u4fe1\u4efb\u65b0\u8d2d","client_id":93,"budget":"500000","updated_at":"2026-06-05 11:27:18","created_at":"2026-03-20 13:31:49","bargain_date":"2026-06-05","collected":"0","un_collected":500000,"pinyin_shortcut":"ftlxrxg","description":"","id2":4146,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4497,"from_project":4146,"is_outbound":false},"buildContract":{"id":4497,"from_project":4146,"is_outbound":false}},{"id":3957,"project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","client_id":2130,"budget":"20000000","updated_at":"2026-06-05 11:20:29","created_at":"2025-08-29 11:38:51","bargain_date":"2026-06-05","collected":"0","un_collected":20000000,"pinyin_shortcut":"zgrmjfjzcmbdwsyyjsszgcgxn","description":"","id2":3957,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5087,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4496,"from_project":3957,"is_outbound":false},"buildContract":{"id":4496,"from_project":3957,"is_outbound":false}},{"id":3796,"project_title":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","client_id":2125,"budget":"790000","updated_at":"2026-06-05 11:11:50","created_at":"2025-03-09 10:00:35","bargain_date":"2026-06-05","collected":"0","un_collected":790000,"pinyin_shortcut":"deepseeksyhbs","description":"","id2":3796,"erp_cash_cost_ticket_amount":"215.95","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"215.95","erp_profit_amount":"0","erp_j_profit_amount":"-215.95","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-215.95","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4492,"from_project":3796,"is_outbound":false},"buildContract":{"id":4492,"from_project":3796,"is_outbound":false}},{"id":3854,"project_title":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128,"budget":"44540520","updated_at":"2026-06-05 11:10:13","created_at":"2025-05-13 09:35:09","bargain_date":"2026-06-05","collected":"0","un_collected":44540520,"pinyin_shortcut":"bfxmeq","description":"","id2":3854,"erp_cash_cost_ticket_amount":"194.66","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"194.66","erp_profit_amount":"0","erp_j_profit_amount":"-194.66","erp_labor_cost_amount":"368.227840909091","erp_j_profit_deduct_labor_amount":"-562.887840909091","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4491,"from_project":3854,"is_outbound":false},"buildContract":{"id":4491,"from_project":3854,"is_outbound":false}},{"id":4079,"project_title":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee","client_id":3432,"budget":"291000","updated_at":"2026-06-03 22:57:03","created_at":"2025-12-19 13:35:46","bargain_date":"2025-11-11","collected":"0","un_collected":291000,"pinyin_shortcut":"mhaqflfgsjkyhyaqsrlcpxtkfxm","description":"","id2":4079,"erp_cash_cost_ticket_amount":"5","erp_cost_ticket_amount":"226980","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"226985","erp_profit_amount":"291000","erp_j_profit_amount":"64015","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"64015","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4324,"from_project":4079,"is_outbound":true},"buildContract":{"id":4324,"from_project":4079,"is_outbound":true}},{"id":4170,"project_title":"\u516c\u53f8\u8463\u4e8b","client_id":3389,"budget":"900","updated_at":"2026-06-02 23:12:40","created_at":"2026-05-22 17:13:42","bargain_date":"2026-05-22","collected":"0","un_collected":900,"pinyin_shortcut":"gsds","description":"","id2":4170,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4479,"from_project":4170,"is_outbound":false},"buildContract":{"id":4479,"from_project":4170,"is_outbound":false}},{"id":4155,"project_title":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a","client_id":982,"budget":"4555","updated_at":"2026-05-25 11:18:55","created_at":"2026-03-31 13:59:19","bargain_date":"2026-03-31","collected":"0","un_collected":4555,"pinyin_shortcut":"csxjsj","description":"","id2":4155,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4481,"from_project":4155,"is_outbound":false},"buildContract":{"id":4481,"from_project":4155,"is_outbound":false}},{"id":4172,"project_title":"\u63a8\u7279\u5982\u56fe","client_id":3389,"budget":"18000","updated_at":"2026-05-25 10:12:46","created_at":"2026-05-25 10:12:46","bargain_date":"2026-05-25","collected":"0","un_collected":18000,"pinyin_shortcut":"ttrt","description":"","id2":4172,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4480,"from_project":4172,"is_outbound":true},"buildContract":{"id":4480,"from_project":4172,"is_outbound":true}},{"id":4151,"project_title":"PA460 \u8bbe\u5907\u65b0\u8d2d\u9879\u76ee","client_id":2150,"budget":"420000","updated_at":"2026-05-22 17:08:02","created_at":"2026-03-24 17:36:36","bargain_date":"2026-04-07","collected":"0","un_collected":420000,"pinyin_shortcut":"PA460sbxgxm","description":"","id2":4151,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2150,"key":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)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4493,"from_project":4151,"is_outbound":false},"buildContract":{"id":4493,"from_project":4151,"is_outbound":false}},{"id":4169,"project_title":"\u65b9\u5f0f\u5730\u65b9","client_id":3389,"budget":"1800","updated_at":"2026-05-22 17:05:11","created_at":"2026-05-22 17:05:11","bargain_date":"2026-05-22","collected":"0","un_collected":1800,"pinyin_shortcut":"fsdf","description":"","id2":4169,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4478,"from_project":4169,"is_outbound":false},"buildContract":{"id":4478,"from_project":4169,"is_outbound":false}},{"id":4168,"project_title":"\u7a0e\u8d4b\u5927\u662f\u5927\u975e","client_id":3009,"budget":"900","updated_at":"2026-05-22 16:49:10","created_at":"2026-05-22 16:49:10","bargain_date":"2026-05-22","collected":"0","un_collected":900,"pinyin_shortcut":"sfdsdf","description":"","id2":4168,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3009,"key":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"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4494,"from_project":4168,"is_outbound":false},"buildContract":{"id":4494,"from_project":4168,"is_outbound":false}},{"id":4144,"project_title":"zstack\u7eed\u4fdd","client_id":2593,"budget":"800","updated_at":"2026-05-22 16:48:10","created_at":"2026-03-18 09:49:26","bargain_date":"2026-04-30","collected":"0","un_collected":800,"pinyin_shortcut":"zstackxb","description":"","id2":4144,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2593,"key":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4495,"from_project":4144,"is_outbound":false},"buildContract":{"id":4495,"from_project":4144,"is_outbound":false}},{"id":4167,"project_title":"\u65b0\u5efa\u9879\u76ee","client_id":982,"budget":"51486","updated_at":"2026-05-21 18:03:03","created_at":"2026-05-14 10:38:51","bargain_date":"2026-05-14","collected":"100","un_collected":51386,"pinyin_shortcut":"xjxm","description":"","id2":4167,"erp_cash_cost_ticket_amount":"100","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"100","erp_profit_amount":"0","erp_j_profit_amount":"-100","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-100","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4476,"from_project":4167,"is_outbound":false},"buildContract":{"id":4476,"from_project":4167,"is_outbound":false}},{"id":4161,"project_title":"3535","client_id":982,"budget":"12703473","updated_at":"2026-05-21 16:13:22","created_at":"2026-04-01 11:36:21","bargain_date":"2026-04-23","collected":"0","un_collected":12703473,"pinyin_shortcut":"3535","description":"","id2":4161,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"12702289.795","erp_j_profit_amount":"12702289.795","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12702289.795","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4462,"from_project":4161,"is_outbound":false},"buildContract":{"id":4462,"from_project":4161,"is_outbound":false}},{"id":4166,"project_title":"9999","client_id":982,"budget":"4000","updated_at":"2026-05-20 12:54:15","created_at":"2026-04-23 21:19:12","bargain_date":"2026-05-12","collected":"0","un_collected":4000,"pinyin_shortcut":"9999","description":"","id2":4166,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4467,"from_project":4166,"is_outbound":false},"buildContract":{"id":4467,"from_project":4166,"is_outbound":false}},{"id":263,"project_title":"\u4e92\u8054\u7f51+\u7b2c\u4e8c\u6279","client_id":399,"budget":"863675","updated_at":"2026-05-18 13:48:27","created_at":"2017-07-10 13:50:18","bargain_date":"2017-06-21","collected":"863675","un_collected":0,"pinyin_shortcut":"hlwdep","description":"\u6d6a\u6f6e\u670d\u52a1\u5668","id2":263,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":195,"from_project":263,"is_outbound":false},"buildContract":{"id":195,"from_project":263,"is_outbound":false}},{"id":1111,"project_title":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf","client_id":982,"budget":"2486850","updated_at":"2026-05-15 13:07:37","created_at":"2019-04-24 06:22:09","bargain_date":"2019-09-23","collected":"2486850","un_collected":0,"pinyin_shortcut":"ylsphytytx","description":"1.\u4ebf\u8054V880+V800\u4f1a\u8bae\u5ba4\u7ec8\u7aef\u2795Ume\u7cfb\u7edf\u4e00\u5957","id2":1111,"erp_cash_cost_ticket_amount":"958.03","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"958.03","erp_profit_amount":"0","erp_j_profit_amount":"-958.03","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-958.03","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":1186,"from_project":1111,"is_outbound":false},"buildContract":{"id":1186,"from_project":1111,"is_outbound":false}},{"id":2504,"project_title":"hp288PC","client_id":146,"budget":"12930","updated_at":"2026-05-09 17:18:36","created_at":"2021-04-02 16:46:57","bargain_date":"2021-04-01","collected":"12930","un_collected":0,"pinyin_shortcut":"hp288PC","description":"288 3\u53f0","id2":2504,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":1930,"from_project":2504,"is_outbound":false},"buildContract":{"id":1930,"from_project":2504,"is_outbound":false}},{"id":1791,"project_title":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","client_id":1661,"budget":"514761.00","updated_at":"2026-05-09 17:07:05","created_at":"2020-06-23 16:32:19","bargain_date":"2020-06-03","collected":"514761","un_collected":0,"pinyin_shortcut":"hy5500VXcgxm","description":"1\u53f05500VX-HW\u8bbe\u5907","id2":1791,"erp_cash_cost_ticket_amount":"222","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":1558,"from_project":1791,"is_outbound":false},"buildContract":{"id":1558,"from_project":1791,"is_outbound":false}},{"id":4098,"project_title":"PA460\u8bbe\u5907\u7b49\u91c7\u8d2d\u9879\u76ee","client_id":3377,"budget":"1630000","updated_at":"2026-04-30 13:49:40","created_at":"2026-01-12 10:33:31","bargain_date":"2026-01-28","collected":"999","un_collected":1629001,"pinyin_shortcut":"PA460sbdcgxm","description":"","id2":4098,"erp_cash_cost_ticket_amount":"999","erp_cost_ticket_amount":"388713","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"389712","erp_profit_amount":"583485","erp_j_profit_amount":"193773","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"193773","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4399,"from_project":4098,"is_outbound":true},"buildContract":{"id":4399,"from_project":4098,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":5085,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1015,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1022,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1023,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1001,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"14900.00000000000000000000","erp_j_profit_amount":"14900.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"14900","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":5248,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","department_id":2,"avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4164,"project_title":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a\/\u7f16\u8f91\/\u751f\u6210\u5408\u540c","client_id":982,"budget":"40878","updated_at":"2026-04-29 17:58:05","created_at":"2026-04-08 11:18:13","bargain_date":"2026-04-08","collected":"3","un_collected":40875,"pinyin_shortcut":"csxjsjbjscht","description":"","id2":4164,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4457,"from_project":4164,"is_outbound":false},"buildContract":{"id":4457,"from_project":4164,"is_outbound":false}},{"id":1972,"project_title":"Fire-eye\u7f51\u7edc\u90ae\u4ef6\u6c99\u7bb1\u7cfb\u7edf\u91c7\u8d2d","client_id":1956,"budget":"1066393.00","updated_at":"2026-04-23 16:20:15","created_at":"2020-11-06 09:55:40","bargain_date":"2020-11-10","collected":"1066393","un_collected":0,"pinyin_shortcut":"Fireeyewlyjsxxtcg","description":"1.2\u53f0Fireeye EX3500\u4e3b\u673a+1\u5e74\u670d\u52a1\uff1b\n2.1\u53f0Fireeye NX4500\u4e3b\u673a+1\u5e74\u670d\u52a1","id2":1972,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1956,"key":1956,"name":"\u5ea6\u5c0f\u6ee1\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":1755,"from_project":1972,"is_outbound":false},"buildContract":{"id":1755,"from_project":1972,"is_outbound":false}},{"id":3910,"project_title":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","client_id":2762,"budget":"3003980","updated_at":"2026-04-22 15:46:14","created_at":"2025-07-09 21:28:44","bargain_date":"2025-07-11","collected":"3003980","un_collected":0,"pinyin_shortcut":"33sgxnxm","description":"","id2":3910,"erp_cash_cost_ticket_amount":"6404.33","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"12491.33","created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"18895.66","erp_profit_amount":"786863","erp_j_profit_amount":"767967.34","erp_labor_cost_amount":"199.917584815547","erp_j_profit_deduct_labor_amount":"767767.422415184","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4024,"from_project":3910,"is_outbound":true},"buildContract":{"id":4024,"from_project":3910,"is_outbound":true}},{"id":4025,"project_title":"\u7eff\u536125-26\u5e74\u5de1\u68c0","client_id":149,"budget":"40800","updated_at":"2026-04-22 15:46:14","created_at":"2025-10-28 11:04:18","bargain_date":"2025-12-10","collected":"0","un_collected":40800,"pinyin_shortcut":"lk2526nxj","description":"","id2":4025,"erp_cash_cost_ticket_amount":"442.99","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"442.99","erp_profit_amount":"40800","erp_j_profit_amount":"40357.01","erp_labor_cost_amount":"394.746306818182","erp_j_profit_deduct_labor_amount":"39962.2636931818","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4301,"from_project":4025,"is_outbound":true},"buildContract":{"id":4301,"from_project":4025,"is_outbound":true}},{"id":4113,"project_title":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125,"budget":"378880","updated_at":"2026-04-22 15:46:14","created_at":"2026-01-22 21:24:33","bargain_date":"2026-01-28","collected":"227328","un_collected":151552,"pinyin_shortcut":"hysxtK","description":"","id2":4113,"erp_cash_cost_ticket_amount":"174.6","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"644.54","created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"819.14","erp_profit_amount":"47355","erp_j_profit_amount":"46535.86","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"46535.86","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4400,"from_project":4113,"is_outbound":false},"buildContract":{"id":4400,"from_project":4113,"is_outbound":false}},{"id":3695,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3-K","client_id":2128,"budget":"631660","updated_at":"2026-04-22 15:46:13","created_at":"2024-10-20 19:25:01","bargain_date":"2025-11-30","collected":"600077","un_collected":31583,"pinyin_shortcut":"bfxtgchtdK","description":"","id2":3695,"erp_cash_cost_ticket_amount":"2028.08","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"2028.08","erp_profit_amount":"320864","erp_j_profit_amount":"318835.92","erp_labor_cost_amount":"266.812545289855","erp_j_profit_deduct_labor_amount":"318569.10745471","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4289,"from_project":3695,"is_outbound":true},"buildContract":{"id":4289,"from_project":3695,"is_outbound":true}},{"id":3577,"project_title":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","client_id":3278,"budget":"198354","updated_at":"2026-04-20 14:20:09","created_at":"2024-06-26 10:50:35","bargain_date":"2024-06-25","collected":"198354","un_collected":0,"pinyin_shortcut":"PA1410fhq2txgxm","description":"","id2":3577,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3364,"from_project":3577,"is_outbound":true},"buildContract":{"id":3364,"from_project":3577,"is_outbound":true}},{"id":3873,"project_title":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","client_id":48,"budget":"62075.1","updated_at":"2026-04-15 10:29:06","created_at":"2025-05-29 14:02:17","bargain_date":"2025-06-24","collected":"62075.1","un_collected":0,"pinyin_shortcut":"2025nsjzxwb","description":"","id2":3873,"erp_cash_cost_ticket_amount":"1044.63","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"1044.63","erp_profit_amount":"18546.5","erp_j_profit_amount":"17501.87","erp_labor_cost_amount":"204.810696640316","erp_j_profit_deduct_labor_amount":"17297.0593033597","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3998,"from_project":3873,"is_outbound":true},"buildContract":{"id":3998,"from_project":3873,"is_outbound":true}},{"id":4142,"project_title":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286,"budget":"309425.78","updated_at":"2026-04-08 15:49:36","created_at":"2026-03-17 14:29:58","bargain_date":"2026-03-17","collected":"0","un_collected":309425.78,"pinyin_shortcut":"PA1420ltxgxm","description":"\u6700\u7ec8\u7528\u6237\u4fe1\u606f\uff1a\n\u4ebf\u5ba2\u884c\u54a8\u8be2\u670d\u52a1(\u5317\u4eac)\u6709\u9650\u516c\u53f8\nExpedia Consulting Service (Beijing) Co., Ltd.","id2":4142,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"17643.8","erp_j_profit_amount":"17643.8","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17643.8","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4446,"from_project":4142,"is_outbound":false},"buildContract":{"id":4446,"from_project":4142,"is_outbound":false}},{"id":4078,"project_title":"2025\u5e74\u6c11\u94f6\u884c\u5b89\u5168\u80fd\u529b\u5efa\u8bbe\u9879\u76ee","client_id":3432,"budget":"63000","updated_at":"2026-04-01 13:50:28","created_at":"2025-12-19 13:33:48","bargain_date":"2025-11-11","collected":"0","un_collected":63000,"pinyin_shortcut":"2025nmyhaqnljsxm","description":"","id2":4078,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"49140","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"49140","erp_profit_amount":"63000","erp_j_profit_amount":"13860","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"13860","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4323,"from_project":4078,"is_outbound":true},"buildContract":{"id":4323,"from_project":4078,"is_outbound":true}},{"id":4157,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260401002","client_id":3457,"budget":"33333","updated_at":"2026-04-01 11:28:03","created_at":"2026-04-01 11:21:52","bargain_date":"2026-04-01","collected":"555","un_collected":32778,"pinyin_shortcut":"xsxssc20260401002","description":"","id2":4157,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4453,"from_project":4157,"is_outbound":true},"buildContract":{"id":4453,"from_project":4157,"is_outbound":true}},{"id":4145,"project_title":"\u529e\u516c\u5927\u697c\u6539\u9020","client_id":20,"budget":"2000000","updated_at":"2026-03-31 13:59:52","created_at":"2026-03-20 13:30:33","bargain_date":"2026-03-31","collected":"0","un_collected":2000000,"pinyin_shortcut":"bgdlgz","description":"","id2":4145,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4450,"from_project":4145,"is_outbound":false},"buildContract":{"id":4450,"from_project":4145,"is_outbound":false}},{"id":4139,"project_title":"\u7fa4\u6656\u5907\u4efd\u5b58\u50a8\u91c7\u8d2d-2026","client_id":2182,"budget":"74500","updated_at":"2026-03-30 15:26:06","created_at":"2026-03-12 15:21:08","bargain_date":"2026-03-20","collected":"0","un_collected":74500,"pinyin_shortcut":"qhbfcccg2026","description":"","id2":4139,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"0","erp_sales_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","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4443,"from_project":4139,"is_outbound":false},"buildContract":{"id":4443,"from_project":4139,"is_outbound":false}}],"pagenation":{"totalcount":1708,"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; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-08 14:54:33', 168717312) RETURNING "id"

[+] Explain