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

Database Queries

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

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

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

[+] Explain
14:54:53.71614.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"."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_profit_amount ASC NULLS LAST, p.updated_at DESC) "c"

[+] Explain
14:54:53.732211.0 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_profit_amount ASC NULLS LAST, p.updated_at DESC LIMIT 40

[+] Explain
14:54:53.9430.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2094, 12, 3462, 93, 2130, 2125, 2128, 3389, 982, 2150, 3009, 2593, 399, 146, 1661, 1956, 3278, 20, 2182, 3330, 1172, 3270, 1492, 27, 85, 2526, 2136, 101, 287)

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

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

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

[+] Explain
14:54:53.9450.9 msSELECTSELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4066, 4043, 4174, 4146, 3957, 3796, 3854, 4170, 4155, 4151, 4169, 4168, 4144, 4167, 4166, 263, 1111, 2504, 1791, 4164, 1972, 3577, 4145, 4139, 4017, 4128, 3583, 3810, 3526, 3387, 3249, 3743, 3833, 3846, 3758, 3884, 3911, 3018, 3728, 3694)

[+] Explain
14:54:53.9481.8 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_profit_amount","sort":"ASC"},"page":"1","pageSize":"40","listReload":"true","web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":{"list":[{"id":4066,"project_title":"\u5b89\u5168\u670d\u52a1-\u6df1\u4fe1\u670d","client_id":2094,"budget":"432000","updated_at":"2026-01-29 15:38:07","created_at":"2025-12-07 20:48:06","bargain_date":"2025-12-19","collected":"0","un_collected":432000,"pinyin_shortcut":"aqfwsxf","description":"","id2":4066,"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":"-39300","erp_j_profit_amount":"-39300","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-39300","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\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":4328,"from_project":4066,"is_outbound":true},"buildContract":{"id":4328,"from_project":4066,"is_outbound":true}},{"id":4043,"project_title":"POTJ25111959-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"1817","updated_at":"2026-01-07 11:37:33","created_at":"2025-11-11 16:24:59","bargain_date":"2025-11-11","collected":"1817","un_collected":0,"pinyin_shortcut":"POTJ25111959gtypnct2025","description":"","id2":4043,"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":"-64","erp_j_profit_amount":"-64","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-64","erp_j_profit_pct":"","erp_profit_pct":"","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":4243,"from_project":4043,"is_outbound":true},"buildContract":{"id":4243,"from_project":4043,"is_outbound":true}},{"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":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":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":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":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":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":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}},{"id":4017,"project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u4e00\u4f53\u673a\u65b0\u8d2d-2026","client_id":3330,"budget":"58000","updated_at":"2026-03-25 15:26:06","created_at":"2025-10-22 16:38:50","bargain_date":"2025-12-18","collected":"0","un_collected":58000,"pinyin_shortcut":"yjzbfytjxg2026","description":"","id2":4017,"erp_cash_cost_ticket_amount":"67","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":"67","erp_profit_amount":"0","erp_j_profit_amount":"-67","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-67","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3330,"key":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8\/ \u94a2\u7814\u660a\u666e\uff08\u82cf\u5dde\uff09\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8"},"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":4321,"from_project":4017,"is_outbound":false},"buildContract":{"id":4321,"from_project":4017,"is_outbound":false}},{"id":4128,"project_title":"2026AC\u7eed\u4fdd","client_id":1172,"budget":"21104.99","updated_at":"2026-03-25 11:23:53","created_at":"2026-03-01 21:46:25","bargain_date":"2026-03-13","collected":"0","un_collected":21104.99,"pinyin_shortcut":"2026ACxb","description":"","id2":4128,"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":"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":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":4444,"from_project":4128,"is_outbound":false},"buildContract":{"id":4444,"from_project":4128,"is_outbound":false}},{"id":3583,"project_title":"\u670d\u52a1\u8d39-K","client_id":3270,"budget":"110000","updated_at":"2026-03-24 21:00:16","created_at":"2024-07-01 11:42:26","bargain_date":"2024-07-22","collected":"110000","un_collected":0,"pinyin_shortcut":"fwfK","description":"","id2":3583,"erp_cash_cost_ticket_amount":"234.09","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":"234.09","erp_profit_amount":"0","erp_j_profit_amount":"-234.09","erp_labor_cost_amount":"75.009375","erp_j_profit_deduct_labor_amount":"-309.099375","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3270,"key":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"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":3420,"from_project":3583,"is_outbound":true},"buildContract":{"id":3420,"from_project":3583,"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":"113.860037878788","erp_j_profit_deduct_labor_amount":"-40642.2900378788","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":3526,"project_title":"\u65b0\u8d2d2\u53f0\u670d\u52a1\u5668-K","client_id":27,"budget":"81400","updated_at":"2026-03-24 09:46:59","created_at":"2024-05-07 22:06:41","bargain_date":"2024-05-11","collected":"81400","un_collected":0,"pinyin_shortcut":"xg2tfwqK","description":"","id2":3526,"erp_cash_cost_ticket_amount":"405.39","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":"405.39","erp_profit_amount":"0","erp_j_profit_amount":"-405.39","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-405.39","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":27,"key":27,"name":"\u5317\u4eac\u6c7d\u8f66\u6613\u751f\u6d3b\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u4e2d\u6cb9\u623f\u5c71\u71d5\u5bbe\u6cb9\u6599\u9500\u552e\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":3282,"from_project":3526,"is_outbound":true},"buildContract":{"id":3282,"from_project":3526,"is_outbound":true}},{"id":3387,"project_title":"NAS\u6388\u6743\u5b89\u88c5-K","client_id":85,"budget":"23500","updated_at":"2026-03-22 20:06:59","created_at":"2023-12-06 05:51:30","bargain_date":"2023-12-06","collected":"0","un_collected":23500,"pinyin_shortcut":"NASsqazK","description":"","id2":3387,"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":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\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":2988,"from_project":3387,"is_outbound":true},"buildContract":{"id":2988,"from_project":3387,"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":3743,"project_title":"SATA512G\u56fa\u6001\u786c\u76d8 \u9879\u76ee-K","client_id":2526,"budget":"21870","updated_at":"2026-03-22 20:06:12","created_at":"2024-12-17 08:22:52","bargain_date":"2024-12-17","collected":"0","un_collected":21870,"pinyin_shortcut":"SATA512GgtypxmK","description":"12-25\u65e5\u4fee\u6539\u91d1\u989d\uff1b\u589e\u52a0950+1350=2300\u5143","id2":3743,"erp_cash_cost_ticket_amount":"590.67","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":"590.67","erp_profit_amount":"0","erp_j_profit_amount":"-590.67","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-590.67","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\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":3713,"from_project":3743,"is_outbound":true},"buildContract":{"id":3713,"from_project":3743,"is_outbound":true}},{"id":3833,"project_title":"pc\u673a\u786c\u76d8","client_id":2526,"budget":"5200","updated_at":"2026-03-22 20:05:49","created_at":"2025-04-27 16:39:06","bargain_date":"2025-04-27","collected":"0","un_collected":5200,"pinyin_shortcut":"pcjyp","description":"","id2":3833,"erp_cash_cost_ticket_amount":"39.10","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":"39.10","erp_profit_amount":"0","erp_j_profit_amount":"-39.10","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-39.1","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\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":3883,"from_project":3833,"is_outbound":true},"buildContract":{"id":3883,"from_project":3833,"is_outbound":true}},{"id":3846,"project_title":"59\u6240\u5927\u6a21\u578b\u79c1\u6709\u5316\u90e8\u7f72","client_id":2136,"budget":"615000","updated_at":"2026-03-22 20:04:23","created_at":"2025-04-30 12:07:59","bargain_date":"2025-04-30","collected":"0","un_collected":615000,"pinyin_shortcut":"59sdmxsyhbs","description":"","id2":3846,"erp_cash_cost_ticket_amount":"128.60","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":"128.60","erp_profit_amount":"0","erp_j_profit_amount":"-128.60","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-128.6","erp_j_profit_pct":"","erp_profit_pct":"","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":3914,"from_project":3846,"is_outbound":true},"buildContract":{"id":3914,"from_project":3846,"is_outbound":true}},{"id":3758,"project_title":"\u5907\u4efd\u6269\u5bb9-K","client_id":2130,"budget":"217000","updated_at":"2026-03-22 20:02:40","created_at":"2025-01-06 11:48:40","bargain_date":"2025-05-14","collected":"195300","un_collected":21700,"pinyin_shortcut":"bfkrK","description":"","id2":3758,"erp_cash_cost_ticket_amount":"500.00","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":"500.00","erp_profit_amount":"0","erp_j_profit_amount":"-500.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-500","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":3911,"from_project":3758,"is_outbound":true},"buildContract":{"id":3911,"from_project":3758,"is_outbound":true}},{"id":3884,"project_title":"\u670d\u52a1\u5668raid\u5361","client_id":2136,"budget":"1500","updated_at":"2026-03-22 20:00:09","created_at":"2025-06-08 23:27:15","bargain_date":"2025-06-23","collected":"0","un_collected":1500,"pinyin_shortcut":"fwqraidk","description":"","id2":3884,"erp_cash_cost_ticket_amount":"21.20","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":"21.20","erp_profit_amount":"0","erp_j_profit_amount":"-21.20","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-21.2","erp_j_profit_pct":"","erp_profit_pct":"","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":3993,"from_project":3884,"is_outbound":true},"buildContract":{"id":3993,"from_project":3884,"is_outbound":true}},{"id":3911,"project_title":"\u8d22\u52a1\u7528\u9632\u706b\u5899","client_id":2526,"budget":"25000","updated_at":"2026-03-22 19:59:11","created_at":"2025-07-10 16:23:12","bargain_date":"2025-07-10","collected":"0","un_collected":25000,"pinyin_shortcut":"cwyfhq","description":"","id2":3911,"erp_cash_cost_ticket_amount":"478.58","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":"478.58","erp_profit_amount":"0","erp_j_profit_amount":"-478.58","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-478.58","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\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":4020,"from_project":3911,"is_outbound":true},"buildContract":{"id":4020,"from_project":3911,"is_outbound":true}},{"id":3018,"project_title":"31\u6240SAN \u5b58\u50a8","client_id":2130,"budget":"590000","updated_at":"2026-03-16 17:05:28","created_at":"2022-10-24 13:13:10","bargain_date":"2022-11-30","collected":"590000","un_collected":0,"pinyin_shortcut":"31sSANcc","description":"\u4e91\u79d14480\u5b58\u50a8\n\u4e91\u79d14250 4280\u7eed\u4fdd","id2":3018,"erp_cash_cost_ticket_amount":"1280.19","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":"1280.19","erp_profit_amount":"0","erp_j_profit_amount":"-1280.19","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-1280.19","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":2468,"from_project":3018,"is_outbound":false},"buildContract":{"id":2468,"from_project":3018,"is_outbound":false}},{"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":3694,"project_title":"PA\u9632\u706b\u5899\u65b0\u8d2d-2024-C","client_id":287,"budget":"2672450","updated_at":"2026-03-11 13:41:30","created_at":"2024-10-18 22:52:12","bargain_date":"2024-12-31","collected":"2672450","un_collected":0,"pinyin_shortcut":"PAfhqxg2024C","description":"","id2":3694,"erp_cash_cost_ticket_amount":"1869","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":"1869","erp_profit_amount":"0","erp_j_profit_amount":"-1869","erp_labor_cost_amount":"181.840909090909","erp_j_profit_deduct_labor_amount":"-2050.84090909091","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"},"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":3626,"from_project":3694,"is_outbound":true},"buildContract":{"id":3626,"from_project":3694,"is_outbound":true}}],"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:53', 238452992) RETURNING "id"

[+] Explain