ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1cfef9a3ea3: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2026-06-01 11:39:37 am by 221.216.117.119

Database Queries

总计10条数据
TimeDurationTypeQuery
  
11:39:37.6730.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

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

[+] Explain
11:39:37.682128.8 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.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.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.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_labor_cost_amount DESC NULLS LAST, p.updated_at DESC) "c"

[+] Explain
11:39:37.811146.9 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.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.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.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_labor_cost_amount DESC NULLS LAST, p.updated_at DESC LIMIT 40

[+] Explain
11:39:37.9591.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 2762, 20, 48, 402, 12, 149, 2128, 57, 1492, 2166, 97, 2545, 24, 2221, 2125, 497, 90, 1172, 518, 1301, 2136, 101, 2182, 1663, 982, 3389, 399, 3432, 146)

[+] Explain
11:39:37.9600.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5087, 1004, 5300, 1001, 5295, 1003)

[+] Explain
11:39:37.9610.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5300, 1003, 5087, 1004, 1005))

[+] Explain
11:39:37.9610.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)

[+] Explain
11:39:37.9610.9 msSELECTSELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3975, 3910, 4067, 3873, 3998, 4007, 3666, 3716, 3695, 3960, 3810, 3955, 4064, 3899, 3601, 4010, 4016, 3249, 3942, 3446, 4045, 3731, 4048, 3720, 4033, 3922, 3728, 4059, 3827, 4155, 4172, 4170, 4169, 4167, 4161, 4166, 263, 1111, 4079, 2504)

[+] Explain
11:39:37.9651.9 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":"","created_at_to":"","created_at_from":"","Filter":{"name":"erp_labor_cost_amount","sort":"DESC"},"page":"1","pageSize":"40","listReload":"true","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":3975,"project_title":"\u534e\u4e3a\u865a\u62df\u5316\u91c7\u8d2d","client_id":918,"budget":"283900","updated_at":"2026-02-05 16:37:33","created_at":"2025-09-19 16:55:03","bargain_date":"2025-12-02","collected":"283900","un_collected":0,"pinyin_shortcut":"hwxnhcg","description":"","id2":3975,"erp_cash_cost_ticket_amount":"685.14","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"259535.96","erp_sales_amount":"283900","erp_use_amount":"685.14","erp_profit_amount":"24364.04","erp_j_profit_amount":"23678.90","erp_labor_cost_amount":"227.763768115942","erp_j_profit_deduct_labor_amount":"23451.1362318841","erp_j_profit_pct":8.34,"erp_profit_pct":8.58,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":4276,"from_project":3975,"is_outbound":true},"buildContract":{"id":4276,"from_project":3975,"is_outbound":true}},{"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":"2217117","erp_sales_amount":"3003980","erp_use_amount":"18895.66","erp_profit_amount":"786863","erp_j_profit_amount":"767967.34","erp_labor_cost_amount":"159.761050724638","erp_j_profit_deduct_labor_amount":"767807.578949275","erp_j_profit_pct":25.56,"erp_profit_pct":26.19,"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":4067,"project_title":"\u4fe1\u521b\u5b9e\u9a8c\u5ba4\u4e09\u671f","client_id":20,"budget":"656200","updated_at":"2026-03-02 21:12:07","created_at":"2025-12-07 20:51:01","bargain_date":"2025-12-23","collected":"656200","un_collected":0,"pinyin_shortcut":"xcsyssq","description":"","id2":4067,"erp_cash_cost_ticket_amount":"285.06","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"1264.6099999998","created_by":1005,"erp_cost_amount":"521680","erp_sales_amount":"656200","erp_use_amount":"1549.6699999998","erp_profit_amount":"134520","erp_j_profit_amount":"132970.3300000002","erp_labor_cost_amount":"120.410144927536","erp_j_profit_deduct_labor_amount":"132849.919855073","erp_j_profit_pct":20.26,"erp_profit_pct":20.5,"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":4332,"from_project":4067,"is_outbound":true},"buildContract":{"id":4332,"from_project":4067,"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":"7500","erp_sales_amount":"26046.5","erp_use_amount":"1044.63","erp_profit_amount":"18546.5","erp_j_profit_amount":"17501.87","erp_labor_cost_amount":"66.9146739130435","erp_j_profit_deduct_labor_amount":"17434.955326087","erp_j_profit_pct":67.19,"erp_profit_pct":71.21,"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":3998,"project_title":"\u6df1\u4fe1\u670d\u65e5\u5fd7\u5ba1\u8ba1\u65b0\u8d2d-2025","client_id":402,"budget":"58000","updated_at":"2026-03-23 10:39:34","created_at":"2025-10-14 12:07:35","bargain_date":"2025-10-14","collected":"58000","un_collected":0,"pinyin_shortcut":"sxfrzsjxg2025","description":"","id2":3998,"erp_cash_cost_ticket_amount":"101.35","erp_cost_ticket_amount":"5625","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"35100","erp_sales_amount":"58000","erp_use_amount":"5726.35","erp_profit_amount":"22900","erp_j_profit_amount":"17173.65","erp_labor_cost_amount":"51.6820652173913","erp_j_profit_deduct_labor_amount":"17121.9679347826","erp_j_profit_pct":29.61,"erp_profit_pct":39.48,"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\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":4205,"from_project":3998,"is_outbound":true},"buildContract":{"id":4205,"from_project":3998,"is_outbound":true}},{"id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-POCN25128701-2025","client_id":12,"budget":"55500","updated_at":"2026-01-16 13:57:45","created_at":"2025-10-17 17:18:26","bargain_date":"2025-12-23","collected":"55500","un_collected":0,"pinyin_shortcut":"sxfxnhPOCN251287012025","description":"","id2":4007,"erp_cash_cost_ticket_amount":"634.26","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"25000.0","erp_sales_amount":"55500","erp_use_amount":"634.26","erp_profit_amount":"30500.0","erp_j_profit_amount":"29865.74","erp_labor_cost_amount":"47.7832427536232","erp_j_profit_deduct_labor_amount":"29817.9567572464","erp_j_profit_pct":53.81,"erp_profit_pct":54.95,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\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":4334,"from_project":4007,"is_outbound":true},"buildContract":{"id":4334,"from_project":4007,"is_outbound":true}},{"id":3666,"project_title":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee","client_id":918,"budget":"387250","updated_at":"2026-01-23 14:53:02","created_at":"2024-09-22 19:33:32","bargain_date":"2024-11-30","collected":"387250","un_collected":0,"pinyin_shortcut":"2425nxbxm","description":"","id2":3666,"erp_cash_cost_ticket_amount":"504.13","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"621.32","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"1125.45","erp_profit_amount":"0","erp_j_profit_amount":"-1125.45","erp_labor_cost_amount":"29.9211956521739","erp_j_profit_deduct_labor_amount":"-1155.37119565217","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":3664,"from_project":3666,"is_outbound":true},"buildContract":{"id":3664,"from_project":3666,"is_outbound":true}},{"id":3716,"project_title":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1","client_id":149,"budget":"40800","updated_at":"2026-01-28 10:13:31","created_at":"2024-11-15 10:46:08","bargain_date":"2024-11-11","collected":"40800","un_collected":0,"pinyin_shortcut":"lk2425ndjsfw","description":"","id2":3716,"erp_cash_cost_ticket_amount":"836.76","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"1153","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"1989.76","erp_profit_amount":"0","erp_j_profit_amount":"-1989.76","erp_labor_cost_amount":"26.0223731884058","erp_j_profit_deduct_labor_amount":"-2015.78237318841","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":3665,"from_project":3716,"is_outbound":true},"buildContract":{"id":3665,"from_project":3716,"is_outbound":true}},{"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":"310796","erp_sales_amount":"631660","erp_use_amount":"2028.08","erp_profit_amount":"320864","erp_j_profit_amount":"318835.92","erp_labor_cost_amount":"25.1156702898551","erp_j_profit_deduct_labor_amount":"318810.80432971","erp_j_profit_pct":50.48,"erp_profit_pct":50.8,"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":3960,"project_title":"veeam\u7eed\u4fdd-2025\u5e74","client_id":57,"budget":"13750","updated_at":"2026-01-08 15:33:15","created_at":"2025-09-02 11:15:53","bargain_date":"2025-10-30","collected":"13750","un_collected":0,"pinyin_shortcut":"veeamxb2025n","description":"","id2":3960,"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":"10300","erp_sales_amount":"13750","erp_use_amount":"0","erp_profit_amount":"3450","erp_j_profit_amount":"3450","erp_labor_cost_amount":"24.4809782608696","erp_j_profit_deduct_labor_amount":"3425.51902173913","erp_j_profit_pct":25.09,"erp_profit_pct":25.09,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\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":4226,"from_project":3960,"is_outbound":true},"buildContract":{"id":4226,"from_project":3960,"is_outbound":true}},{"id":3810,"project_title":"NETAPP\u5b58\u50a8\u7eed\u4fdd\u670d\u52a1-2025\u5e74","client_id":1492,"budget":"1527000","updated_at":"2026-03-24 11:57:36","created_at":"2025-03-27 14:39:00","bargain_date":"2025-05-09","collected":"1145250","un_collected":381750,"pinyin_shortcut":"NETAPPccxbfw2025n","description":"","id2":3810,"erp_cash_cost_ticket_amount":"10028.43","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"30500","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"40528.43","erp_profit_amount":"0","erp_j_profit_amount":"-40528.43","erp_labor_cost_amount":"22.9395833333333","erp_j_profit_deduct_labor_amount":"-40551.3695833333","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\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":3892,"from_project":3810,"is_outbound":true},"buildContract":{"id":3892,"from_project":3810,"is_outbound":true}},{"id":3955,"project_title":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u65b0\u8d2d-G-2025","client_id":2166,"budget":"148320","updated_at":"2026-01-30 16:07:52","created_at":"2025-08-25 16:25:50","bargain_date":"2025-12-18","collected":"148320","un_collected":0,"pinyin_shortcut":"sxflxrxgG2025","description":"","id2":3955,"erp_cash_cost_ticket_amount":"567.79","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"100000.00","erp_sales_amount":"148320","erp_use_amount":"567.79","erp_profit_amount":"48320.00","erp_j_profit_amount":"47752.21","erp_labor_cost_amount":"19.0407608695652","erp_j_profit_deduct_labor_amount":"47733.1692391304","erp_j_profit_pct":32.2,"erp_profit_pct":32.58,"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\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":4322,"from_project":3955,"is_outbound":true},"buildContract":{"id":4322,"from_project":3955,"is_outbound":true}},{"id":4064,"project_title":"\u6280\u672f\u670d\u52a1-2025","client_id":97,"budget":"1000","updated_at":"2026-01-15 14:50:44","created_at":"2025-12-05 12:05:06","bargain_date":"2025-12-05","collected":"1000","un_collected":0,"pinyin_shortcut":"jsfw2025","description":"","id2":4064,"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":"1000","erp_use_amount":"0","erp_profit_amount":"1000","erp_j_profit_amount":"1000","erp_labor_cost_amount":"19.0407608695652","erp_j_profit_deduct_labor_amount":"980.959239130435","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\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":4287,"from_project":4064,"is_outbound":true},"buildContract":{"id":4287,"from_project":4064,"is_outbound":true}},{"id":3899,"project_title":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee","client_id":2545,"budget":"8982","updated_at":"2026-01-14 09:54:26","created_at":"2025-06-24 14:59:01","bargain_date":"2025-06-24","collected":"8982","un_collected":0,"pinyin_shortcut":"AF1000FH1300Afhqynxbxm","description":"","id2":3899,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"900","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"900","erp_profit_amount":"0","erp_j_profit_amount":"-900","erp_labor_cost_amount":"19.0407608695652","erp_j_profit_deduct_labor_amount":"-919.040760869565","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\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":3997,"from_project":3899,"is_outbound":true},"buildContract":{"id":3997,"from_project":3899,"is_outbound":true}},{"id":3601,"project_title":"\u65e0\u9521\u4fdd\u8bfa\u8ba2\u5355-PO#20240712019-020","client_id":57,"budget":"6000","updated_at":"2026-01-15 14:59:49","created_at":"2024-07-18 14:34:46","bargain_date":"2024-07-17","collected":"6000","un_collected":0,"pinyin_shortcut":"wxbnddPO20240712019020","description":"","id2":3601,"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":"16.320652173913","erp_j_profit_deduct_labor_amount":"-16.320652173913","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\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":3417,"from_project":3601,"is_outbound":true},"buildContract":{"id":3417,"from_project":3601,"is_outbound":true}},{"id":4010,"project_title":"\u534e\u4e3a\u6cf0\u5c71\u670d\u52a1\u5668\u65b0\u8d2d-2025","client_id":24,"budget":"76000","updated_at":"2026-01-23 14:53:02","created_at":"2025-10-20 12:21:47","bargain_date":"2025-10-28","collected":"76000","un_collected":0,"pinyin_shortcut":"hwtsfwqxg2025","description":"","id2":4010,"erp_cash_cost_ticket_amount":"383.19","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"68000","erp_sales_amount":"76000","erp_use_amount":"383.19","erp_profit_amount":"8000","erp_j_profit_amount":"7616.81","erp_labor_cost_amount":"16.0486413043478","erp_j_profit_deduct_labor_amount":"7600.76135869565","erp_j_profit_pct":10.02,"erp_profit_pct":10.53,"client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\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":4204,"from_project":4010,"is_outbound":true},"buildContract":{"id":4204,"from_project":4010,"is_outbound":true}},{"id":4016,"project_title":"2025\u9632\u706b\u5899\u7eed\u4fdd","client_id":2221,"budget":"5050","updated_at":"2026-01-16 14:03:00","created_at":"2025-10-22 11:15:16","bargain_date":"2025-10-23","collected":"5050","un_collected":0,"pinyin_shortcut":"2025fhqxb","description":"","id2":4016,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"1487","erp_sales_amount":"5050","erp_use_amount":"0","erp_profit_amount":"3563","erp_j_profit_amount":"3563","erp_labor_cost_amount":"13.6005434782609","erp_j_profit_deduct_labor_amount":"3549.39945652174","erp_j_profit_pct":70.55,"erp_profit_pct":70.55,"client":{"id":2221,"key":2221,"name":"(\u8fc7\u5355)\u4e2d\u5efa\u65b0\u79d1\u88c5\u9970\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u4e2d\u5efa\u65b0\u79d1\u5efa\u8bbe\u53d1\u5c55\u6709\u9650\u516c\u53f8\uff09"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4207,"from_project":4016,"is_outbound":true},"buildContract":{"id":4207,"from_project":4016,"is_outbound":true}},{"id":3249,"project_title":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"budget":"3394950","updated_at":"2026-03-22 20:06:39","created_at":"2023-07-10 08:54:04","bargain_date":"2024-07-16","collected":"3055455","un_collected":339495,"pinyin_shortcut":"ccgchK","description":"\u5ba1\u6279\u5df2\u901a\u8fc7\uff0c\u56fd\u5bb6\u6280\u6539\u9879\u76ee\uff0c\u6700\u665a\u660e\u5e74\u5e74\u5e95\u5b8c\u6210\u3002\n\u5bb9\u91cf\u6682\u65f6\u6309200T\u8c03\u7814\uff0c\u7ecf\u8d392\u767e\u5927\u51e0\u5341\u3002","id2":3249,"erp_cash_cost_ticket_amount":"14834.77","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"16773","created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"31607.77","erp_profit_amount":"0","erp_j_profit_amount":"-31607.77","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"-31618.6504347826","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":3421,"from_project":3249,"is_outbound":true},"buildContract":{"id":3421,"from_project":3249,"is_outbound":true}},{"id":3942,"project_title":"\u865a\u62df\u5316\u8fd0\u7ef4-2025","client_id":497,"budget":"49500","updated_at":"2026-02-10 12:36:58","created_at":"2025-08-10 17:15:04","bargain_date":"2025-09-05","collected":"49500","un_collected":0,"pinyin_shortcut":"xnhyw2025","description":"","id2":3942,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"2000","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"49500","erp_use_amount":"2000","erp_profit_amount":"49500","erp_j_profit_amount":"47500","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"47489.1195652174","erp_j_profit_pct":95.96,"erp_profit_pct":100,"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\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":4152,"from_project":3942,"is_outbound":true},"buildContract":{"id":4152,"from_project":3942,"is_outbound":true}},{"id":3446,"project_title":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","client_id":90,"budget":"455400","updated_at":"2026-01-30 14:46:15","created_at":"2024-02-18 21:31:40","bargain_date":"2024-03-20","collected":"455400","un_collected":0,"pinyin_shortcut":"skfwqxgsjqy","description":"","id2":3446,"erp_cash_cost_ticket_amount":"10614.89","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"10614.89","erp_profit_amount":"0","erp_j_profit_amount":"-10614.89","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"-10625.7704347826","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3188,"from_project":3446,"is_outbound":true},"buildContract":{"id":3188,"from_project":3446,"is_outbound":true}},{"id":4045,"project_title":"2025\u5e74\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861\u7eed\u4fdd\u9879\u76ee","client_id":1172,"budget":"12700","updated_at":"2026-01-07 11:16:14","created_at":"2025-11-14 14:00:09","bargain_date":"2025-11-27","collected":"12700","un_collected":0,"pinyin_shortcut":"2025nsxffzjhxbxm","description":"","id2":4045,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1004,"erp_cost_amount":"9195","erp_sales_amount":"12700","erp_use_amount":"0","erp_profit_amount":"3505","erp_j_profit_amount":"3505","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"3494.11956521739","erp_j_profit_pct":27.6,"erp_profit_pct":27.6,"client":{"id":1172,"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\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":4271,"from_project":4045,"is_outbound":true},"buildContract":{"id":4271,"from_project":4045,"is_outbound":true}},{"id":3731,"project_title":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","client_id":90,"budget":"229600","updated_at":"2025-12-11 16:35:11","created_at":"2024-12-03 11:51:27","bargain_date":"2024-11-29","collected":"229600","un_collected":0,"pinyin_shortcut":"2024veeamhccxb","description":"","id2":3731,"erp_cash_cost_ticket_amount":"820.95","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"820.95","erp_profit_amount":"0","erp_j_profit_amount":"-820.95","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"-831.830434782609","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3696,"from_project":3731,"is_outbound":true},"buildContract":{"id":3696,"from_project":3731,"is_outbound":true}},{"id":4048,"project_title":"netapp\u5b58\u50a8\u8bbe\u5907\u6269\u5bb9","client_id":518,"budget":"140250","updated_at":"2026-02-03 14:28:23","created_at":"2025-11-18 11:22:44","bargain_date":"2025-11-25","collected":"140250","un_collected":0,"pinyin_shortcut":"netappccsbkr","description":"","id2":4048,"erp_cash_cost_ticket_amount":"4228.11","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"79500","erp_sales_amount":"140250","erp_use_amount":"4228.11","erp_profit_amount":"60750","erp_j_profit_amount":"56521.89","erp_labor_cost_amount":"8.16032608695652","erp_j_profit_deduct_labor_amount":"56513.729673913","erp_j_profit_pct":40.3,"erp_profit_pct":43.32,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4260,"from_project":4048,"is_outbound":true},"buildContract":{"id":4260,"from_project":4048,"is_outbound":true}},{"id":3720,"project_title":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f","client_id":149,"budget":"905150","updated_at":"2026-03-05 13:50:21","created_at":"2024-11-24 19:52:30","bargain_date":"2024-12-24","collected":"905150","un_collected":0,"pinyin_shortcut":"zdhsbsq","description":"","id2":3720,"erp_cash_cost_ticket_amount":"614.80","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"1500","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"2114.80","erp_profit_amount":"0","erp_j_profit_amount":"-2114.80","erp_labor_cost_amount":"6.89094202898551","erp_j_profit_deduct_labor_amount":"-2121.69094202899","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":3736,"from_project":3720,"is_outbound":true},"buildContract":{"id":3736,"from_project":3720,"is_outbound":true}},{"id":4033,"project_title":"\u6280\u672f\u670d\u52a1-\u4ea4\u6362\u673a\u5b9e\u65bd","client_id":1301,"budget":"2000","updated_at":"2026-01-15 14:52:37","created_at":"2025-11-04 17:30:03","bargain_date":"2025-11-04","collected":"2000","un_collected":0,"pinyin_shortcut":"jsfwjhjss","description":"","id2":4033,"erp_cash_cost_ticket_amount":"185.85","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"2000","erp_use_amount":"185.85","erp_profit_amount":"2000","erp_j_profit_amount":"1814.15","erp_labor_cost_amount":"6.70960144927536","erp_j_profit_deduct_labor_amount":"1807.44039855072","erp_j_profit_pct":90.71,"erp_profit_pct":100,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4233,"from_project":4033,"is_outbound":true},"buildContract":{"id":4233,"from_project":4033,"is_outbound":true}},{"id":3922,"project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","client_id":2136,"budget":"45500","updated_at":"2026-03-22 19:58:31","created_at":"2025-07-20 14:44:13","bargain_date":"2025-07-20","collected":"0","un_collected":45500,"pinyin_shortcut":"hlwsjxm","description":"","id2":3922,"erp_cash_cost_ticket_amount":"129.05","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5087,"erp_cost_amount":"23000.00","erp_sales_amount":"45500","erp_use_amount":"129.05","erp_profit_amount":"22500.00","erp_j_profit_amount":"22370.95","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"22365.5097826087","erp_j_profit_pct":49.17,"erp_profit_pct":49.45,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"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":4061,"from_project":3922,"is_outbound":true},"buildContract":{"id":4061,"from_project":3922,"is_outbound":true}},{"id":3728,"project_title":"25-26\u5e74\u865a\u62df\u5316\u7ef4\u4fdd\u9879\u76ee","client_id":101,"budget":"273000","updated_at":"2026-03-11 13:52:51","created_at":"2024-12-01 22:27:13","bargain_date":"2024-11-29","collected":"136500","un_collected":136500,"pinyin_shortcut":"2526nxnhwbxm","description":"","id2":3728,"erp_cash_cost_ticket_amount":"78.64","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":"78.64","erp_profit_amount":"0","erp_j_profit_amount":"-78.64","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"-84.0802173913043","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":101,"key":101,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\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":3681,"from_project":3728,"is_outbound":true},"buildContract":{"id":3681,"from_project":3728,"is_outbound":true}},{"id":4059,"project_title":"netapp\u7ef4\u4fdd1\u5e74-2025","client_id":2182,"budget":"76000","updated_at":"2026-01-16 10:56:11","created_at":"2025-11-28 23:20:40","bargain_date":"2025-12-10","collected":"76000","un_collected":0,"pinyin_shortcut":"netappwb1n2025","description":"","id2":4059,"erp_cash_cost_ticket_amount":"20","erp_cost_ticket_amount":"14600","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"76000","erp_use_amount":"14620","erp_profit_amount":"76000","erp_j_profit_amount":"61380","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"61374.5597826087","erp_j_profit_pct":80.76,"erp_profit_pct":100,"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":4300,"from_project":4059,"is_outbound":true},"buildContract":{"id":4300,"from_project":4059,"is_outbound":true}},{"id":3827,"project_title":"PA\u7eed\u4fdd1\u5e74-C-2025","client_id":1663,"budget":"191000","updated_at":"2026-01-14 10:18:09","created_at":"2025-04-25 20:23:19","bargain_date":"2025-05-26","collected":"191000","un_collected":0,"pinyin_shortcut":"PAxb1nC2025","description":"","id2":3827,"erp_cash_cost_ticket_amount":"207.81","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":"207.81","erp_profit_amount":"0","erp_j_profit_amount":"-207.81","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"-213.250217391304","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011"},"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":3926,"from_project":3827,"is_outbound":true},"buildContract":{"id":3926,"from_project":3827,"is_outbound":true}},{"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":"1","erp_sales_amount":"18000","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":99.99,"erp_profit_pct":99.99,"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":4170,"project_title":"\u516c\u53f8\u8463\u4e8b","client_id":3389,"budget":"900","updated_at":"2026-05-22 17:13:42","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":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":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":"782.205","erp_sales_amount":"12703072","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":99.99,"erp_profit_pct":99.99,"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":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-05-12 13:48:50","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":"291000","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":22,"erp_profit_pct":100,"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":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}}],"pagenation":{"totalcount":1700,"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-01 11:39:37', 293656064) RETURNING "id"

[+] Explain