ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1cde4141610: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2026-06-01 09:20:01 am by 221.216.117.119

Performance Profiling

Total processing time: 51 ms; Peak memory: 6.172 MB. Show Profiling Timeline

总计11条数据
TimeDurationCategoryInfo
  
09:20:01.28325.4 msyii\db\Command::querySELECT 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)) AND ("p"."start_at" >= '2025/12/01 00:00:00') AND ("p"."start_at" <= '2025/12/31 23:59:59')) 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)) AND ("i"."arrived_at" >= '2025/12/01 00:00:00') AND ("i"."arrived_at" <= '2025/12/31 23:59:59') )) "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) AND ("p"."bargain_date" >= '2025/12/01 00:00:00') AND ("p"."bargain_date" <= '2025/12/31 23:59:59') 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 "p"."bargain_date" DESC, "p"."updated_at" DESC LIMIT 40
09:20:01.2747.9 msyii\db\Command::querySELECT 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)) AND ("p"."start_at" >= '2025/12/01 00:00:00') AND ("p"."start_at" <= '2025/12/31 23:59:59')) 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)) AND ("i"."arrived_at" >= '2025/12/01 00:00:00') AND ("i"."arrived_at" <= '2025/12/31 23:59:59') )) "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) AND ("p"."bargain_date" >= '2025/12/01 00:00:00') AND ("p"."bargain_date" <= '2025/12/31 23:59:59') 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 "p"."bargain_date" DESC, "p"."updated_at" DESC) "c"
09:20:01.3142.2 msyii\db\Command::queryINSERT 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":"2025\/12\/31","created_at_from":"2025\/12\/01","page":"1","pageSize":"40","listReload":"true","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":4027,"project_title":"25-26\u5e74\u5b89\u5168\u7eed\u4fdd","client_id":918,"budget":"360950","updated_at":"2026-03-04 16:09:07","created_at":"2025-10-28 11:43:43","bargain_date":"2025-12-31","collected":"180475","un_collected":180475,"pinyin_shortcut":"2526naqxb","description":"","id2":4027,"erp_cash_cost_ticket_amount":"241.84","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"215811","erp_sales_amount":"220450","erp_use_amount":"241.84","erp_profit_amount":"4639","erp_j_profit_amount":"4397.16","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"4397.16","erp_j_profit_pct":1.99,"erp_profit_pct":2.1,"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":4363,"from_project":4027,"is_outbound":false},"buildContract":{"id":4363,"from_project":4027,"is_outbound":false}},{"id":4087,"project_title":"X3650 \u786c\u76d8\u66f4\u6362","client_id":20,"budget":"500","updated_at":"2026-02-09 13:55:23","created_at":"2025-12-31 13:38:54","bargain_date":"2025-12-30","collected":"500","un_collected":0,"pinyin_shortcut":"X3650ypgh","description":"","id2":4087,"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":"300","erp_sales_amount":"500","erp_use_amount":"0","erp_profit_amount":"200","erp_j_profit_amount":"200","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"200","erp_j_profit_pct":40,"erp_profit_pct":40,"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":4357,"from_project":4087,"is_outbound":true},"buildContract":{"id":4357,"from_project":4087,"is_outbound":true}},{"id":4086,"project_title":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u53ca\u670d\u52a1\u9879\u76ee","client_id":3301,"budget":"37500","updated_at":"2026-01-16 09:34:31","created_at":"2025-12-26 13:38:39","bargain_date":"2025-12-26","collected":"37500","un_collected":0,"pinyin_shortcut":"aqjcyxyptjfwxm","description":"","id2":4086,"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":"36375","erp_sales_amount":"37500","erp_use_amount":"0","erp_profit_amount":"1125","erp_j_profit_amount":"1125","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"1125","erp_j_profit_pct":3,"erp_profit_pct":3,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e"},"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":4349,"from_project":4086,"is_outbound":true},"buildContract":{"id":4349,"from_project":4086,"is_outbound":true}},{"id":3923,"project_title":"25\u5e74-26\u5e74\u865a\u62df\u5316\u670d\u52a1","client_id":101,"budget":"256000","updated_at":"2026-01-15 14:49:52","created_at":"2025-07-20 21:37:57","bargain_date":"2025-12-26","collected":"0","un_collected":256000,"pinyin_shortcut":"25n26nxnhfw","description":"","id2":3923,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"96000","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"256000","erp_use_amount":"96000","erp_profit_amount":"256000","erp_j_profit_amount":"160000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"160000","erp_j_profit_pct":62.5,"erp_profit_pct":100,"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":4351,"from_project":3923,"is_outbound":true},"buildContract":{"id":4351,"from_project":3923,"is_outbound":true}},{"id":4077,"project_title":"\u91cd\u673a\u4fe1\u521b\u8f6f\u4ef6\u4e09\u671f","client_id":3359,"budget":"163440","updated_at":"2026-03-20 09:16:38","created_at":"2025-12-19 10:26:40","bargain_date":"2025-12-25","collected":"49140","un_collected":114300,"pinyin_shortcut":"zjxcrjsq","description":"\u5ba2\u6237\u5408\u540c\u7f16\u53f7\uff1aCHMC-2025ZN007-079","id2":4077,"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":"106000","erp_sales_amount":"137520","erp_use_amount":"0","erp_profit_amount":"31520","erp_j_profit_amount":"31520","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"31520","erp_j_profit_pct":22.92,"erp_profit_pct":22.92,"client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\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":4378,"from_project":4077,"is_outbound":false},"buildContract":{"id":4378,"from_project":4077,"is_outbound":false}},{"id":4070,"project_title":"\u534e\u4e3a\u6cf0\u5c71\u670d\u52a1\u5668\u65b0\u8d2d-G-2025","client_id":24,"budget":"31200","updated_at":"2026-02-05 14:19:27","created_at":"2025-12-11 17:46:30","bargain_date":"2025-12-24","collected":"31200","un_collected":0,"pinyin_shortcut":"hwtsfwqxgG2025","description":"","id2":4070,"erp_cash_cost_ticket_amount":"104.4","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"27600","erp_sales_amount":"31200","erp_use_amount":"104.4","erp_profit_amount":"3600","erp_j_profit_amount":"3495.6","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"3495.6","erp_j_profit_pct":11.2,"erp_profit_pct":11.54,"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":4335,"from_project":4070,"is_outbound":true},"buildContract":{"id":4335,"from_project":4070,"is_outbound":true}},{"id":4084,"project_title":"\u516c\u5b89\u90e8\u4e00\u6240\u6df1\u4fe1\u670d\u5b89\u5168\u670d\u52a1","client_id":3433,"budget":"322000","updated_at":"2026-02-05 09:42:15","created_at":"2025-12-24 14:42:37","bargain_date":"2025-12-24","collected":"314000","un_collected":8000,"pinyin_shortcut":"gabyssxfaqfw","description":"","id2":4084,"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":"298300.00","erp_sales_amount":"314000","erp_use_amount":"0","erp_profit_amount":"15700.00","erp_j_profit_amount":"15700.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"15700","erp_j_profit_pct":5,"erp_profit_pct":5,"client":{"id":3433,"key":3433,"name":"\u5317\u4eac\u5b89\u5b81\u76c8\u79d1\u8f6f\u4ef6\u7cfb\u7edf\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09-\u96c6\u6210\u5546"},"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":4338,"from_project":4084,"is_outbound":false},"buildContract":{"id":4338,"from_project":4084,"is_outbound":false}},{"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":"0","erp_j_profit_deduct_labor_amount":"132970.33","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":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":"0","erp_j_profit_deduct_labor_amount":"29865.74","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":4076,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd2025","client_id":1663,"budget":"140000","updated_at":"2026-03-11 18:05:28","created_at":"2025-12-17 09:50:40","bargain_date":"2025-12-19","collected":"140000","un_collected":0,"pinyin_shortcut":"sxfACxb2025","description":"","id2":4076,"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":"133000","erp_sales_amount":"140000","erp_use_amount":"0","erp_profit_amount":"7000","erp_j_profit_amount":"7000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"7000","erp_j_profit_pct":5,"erp_profit_pct":5,"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":4327,"from_project":4076,"is_outbound":true},"buildContract":{"id":4327,"from_project":4076,"is_outbound":true}},{"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":"471300","erp_sales_amount":"432000","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":-9.1,"erp_profit_pct":-9.1,"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":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":4058,"project_title":"PA\u4ea7\u54c1\u7eed\u4fdd","client_id":90,"budget":"212278","updated_at":"2026-02-10 12:08:35","created_at":"2025-11-28 18:50:15","bargain_date":"2025-12-18","collected":"212278","un_collected":0,"pinyin_shortcut":"PAcpxb","description":"","id2":4058,"erp_cash_cost_ticket_amount":"23","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"191143.96","erp_sales_amount":"212278","erp_use_amount":"23","erp_profit_amount":"21134.04","erp_j_profit_amount":"21111.04","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"21111.04","erp_j_profit_pct":9.94,"erp_profit_pct":9.96,"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":4320,"from_project":4058,"is_outbound":true},"buildContract":{"id":4320,"from_project":4058,"is_outbound":true}},{"id":4072,"project_title":"\u6253\u5370\u673a\u7ef4\u4fee-\u80cc\u9760\u80cc\u9879\u76ee","client_id":2526,"budget":"7200","updated_at":"2026-02-06 10:03:20","created_at":"2025-12-14 16:20:16","bargain_date":"2025-12-18","collected":"7200","un_collected":0,"pinyin_shortcut":"dyjwxbkbxm","description":"","id2":4072,"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":"6430","erp_sales_amount":"7200","erp_use_amount":"0","erp_profit_amount":"770","erp_j_profit_amount":"770","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"770","erp_j_profit_pct":10.69,"erp_profit_pct":10.69,"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":4325,"from_project":4072,"is_outbound":true},"buildContract":{"id":4325,"from_project":4072,"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":"0","erp_j_profit_deduct_labor_amount":"47752.21","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":4026,"project_title":"26\u5e74MSS\u670d\u52a1","client_id":20,"budget":"117000","updated_at":"2026-01-27 15:02:51","created_at":"2025-10-28 11:05:31","bargain_date":"2025-12-18","collected":"117000","un_collected":0,"pinyin_shortcut":"26nMSSfw","description":"","id2":4026,"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":"76920","erp_sales_amount":"117000","erp_use_amount":"0","erp_profit_amount":"40080","erp_j_profit_amount":"40080","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"40080","erp_j_profit_pct":34.26,"erp_profit_pct":34.26,"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":4319,"from_project":4026,"is_outbound":true},"buildContract":{"id":4319,"from_project":4026,"is_outbound":true}},{"id":4068,"project_title":"\u6269\u5bb92\u53f0\u8ba1\u7b97\u8d44\u6e90","client_id":3281,"budget":"33957","updated_at":"2026-01-16 14:16:28","created_at":"2025-12-08 11:11:44","bargain_date":"2025-12-17","collected":"33957","un_collected":0,"pinyin_shortcut":"kr2tjszy","description":"","id2":4068,"erp_cash_cost_ticket_amount":"72","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"28630.08","erp_sales_amount":"33957","erp_use_amount":"72","erp_profit_amount":"5326.92","erp_j_profit_amount":"5254.92","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"5254.92","erp_j_profit_pct":15.48,"erp_profit_pct":15.69,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\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":4318,"from_project":4068,"is_outbound":true},"buildContract":{"id":4318,"from_project":4068,"is_outbound":true}},{"id":4075,"project_title":"\u89c6\u9891\u5e72\u6270\u4eea\u91c7\u8d2d","client_id":2526,"budget":"8500","updated_at":"2026-03-22 19:53:08","created_at":"2025-12-16 14:41:07","bargain_date":"2025-12-16","collected":"0","un_collected":8500,"pinyin_shortcut":"spgrycg","description":"","id2":4075,"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":"4000","erp_sales_amount":"8500","erp_use_amount":"0","erp_profit_amount":"4500","erp_j_profit_amount":"4500","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"4500","erp_j_profit_pct":52.94,"erp_profit_pct":52.94,"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":4316,"from_project":4075,"is_outbound":true},"buildContract":{"id":4316,"from_project":4075,"is_outbound":true}},{"id":4073,"project_title":"\u65b0\u8d2d\u601d\u79d1\u4ea4\u6362\u673a","client_id":3366,"budget":"5900","updated_at":"2026-01-27 14:57:24","created_at":"2025-12-15 17:24:16","bargain_date":"2025-12-16","collected":"5900","un_collected":0,"pinyin_shortcut":"xgskjhj","description":"","id2":4073,"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":"2290","erp_sales_amount":"5900","erp_use_amount":"0","erp_profit_amount":"3610","erp_j_profit_amount":"3610","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"3610","erp_j_profit_pct":61.19,"erp_profit_pct":61.19,"client":{"id":3366,"key":3366,"name":"\u8fc7\u5355-\u5317\u4eac\u4e2d\u4f01\u6613\u4ed8\u5546\u52a1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\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":4313,"from_project":4073,"is_outbound":true},"buildContract":{"id":4313,"from_project":4073,"is_outbound":true}},{"id":4074,"project_title":"PA440 \u9632\u706b\u5899\u9879\u76ee\u91c7\u8d2d","client_id":3431,"budget":"28000","updated_at":"2026-01-21 09:50:15","created_at":"2025-12-16 10:26:14","bargain_date":"2025-12-16","collected":"28000","un_collected":0,"pinyin_shortcut":"PA440fhqxmcg","description":"","id2":4074,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"2400","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1004,"erp_cost_amount":"23668","erp_sales_amount":"28000","erp_use_amount":"2400","erp_profit_amount":"4332","erp_j_profit_amount":"1932","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"1932","erp_j_profit_pct":6.9,"erp_profit_pct":15.47,"client":{"id":3431,"key":3431,"name":"\u5317\u4eac\u68b5\u7c73\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"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":4312,"from_project":4074,"is_outbound":true},"buildContract":{"id":4312,"from_project":4074,"is_outbound":true}},{"id":4071,"project_title":"POTJ25125139-\u534e\u4e09\u7f51\u7edc\u8bbe\u5907\u65b0\u8d2d-2025","client_id":12,"budget":"12694","updated_at":"2026-01-16 10:56:35","created_at":"2025-12-12 13:08:33","bargain_date":"2025-12-12","collected":"12694","un_collected":0,"pinyin_shortcut":"POTJ25125139hswlsbxg2025","description":"","id2":4071,"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":"8985","erp_sales_amount":"12694","erp_use_amount":"0","erp_profit_amount":"3709","erp_j_profit_amount":"3709","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"3709","erp_j_profit_pct":29.22,"erp_profit_pct":29.22,"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":4308,"from_project":4071,"is_outbound":true},"buildContract":{"id":4308,"from_project":4071,"is_outbound":true}},{"id":4055,"project_title":"2025veeam\u7eed\u4fdd\u53ca\u786c\u4ef6\u7ef4\u4fdd","client_id":90,"budget":"140250","updated_at":"2026-03-25 16:32:13","created_at":"2025-11-26 10:40:24","bargain_date":"2025-12-11","collected":"140250","un_collected":0,"pinyin_shortcut":"2025veeamxbjyjwb","description":"","id2":4055,"erp_cash_cost_ticket_amount":"82","erp_cost_ticket_amount":"30000","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"40960","erp_sales_amount":"140250","erp_use_amount":"30082","erp_profit_amount":"99290","erp_j_profit_amount":"69208","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"69208","erp_j_profit_pct":49.35,"erp_profit_pct":70.8,"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":4304,"from_project":4055,"is_outbound":true},"buildContract":{"id":4304,"from_project":4055,"is_outbound":true}},{"id":4031,"project_title":"\u65b0\u8d2dUPS\u7535\u6c60","client_id":1111,"budget":"36200","updated_at":"2026-01-16 14:21:59","created_at":"2025-10-31 13:05:11","bargain_date":"2025-12-11","collected":"36200","un_collected":0,"pinyin_shortcut":"xgUPSdc","description":"","id2":4031,"erp_cash_cost_ticket_amount":"157","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"25600","erp_sales_amount":"36200","erp_use_amount":"157","erp_profit_amount":"10600","erp_j_profit_amount":"10443","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"10443","erp_j_profit_pct":28.85,"erp_profit_pct":29.28,"client":{"id":1111,"key":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40"},"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":4305,"from_project":4031,"is_outbound":true},"buildContract":{"id":4305,"from_project":4031,"is_outbound":true}},{"id":4025,"project_title":"\u7eff\u536125-26\u5e74\u5de1\u68c0","client_id":149,"budget":"40800","updated_at":"2026-04-22 15:46:14","created_at":"2025-10-28 11:04:18","bargain_date":"2025-12-10","collected":"0","un_collected":40800,"pinyin_shortcut":"lk2526nxj","description":"","id2":4025,"erp_cash_cost_ticket_amount":"442.99","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"40800","erp_use_amount":"442.99","erp_profit_amount":"40800","erp_j_profit_amount":"40357.01","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"40357.01","erp_j_profit_pct":98.91,"erp_profit_pct":100,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4301,"from_project":4025,"is_outbound":true},"buildContract":{"id":4301,"from_project":4025,"is_outbound":true}},{"id":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":"0","erp_j_profit_deduct_labor_amount":"61380","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":4069,"project_title":"gridview\u9ad8\u6027\u80fd\u96c6\u7fa4\u8c03\u5ea6\u7ba1\u7406\u8f6f\u4ef6-2025","client_id":1181,"budget":"20000","updated_at":"2026-01-26 00:13:27","created_at":"2025-12-08 16:24:56","bargain_date":"2025-12-09","collected":"20000","un_collected":0,"pinyin_shortcut":"gridviewgxnjqddglrj2025","description":"","id2":4069,"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":"16000","erp_sales_amount":"20000","erp_use_amount":"0","erp_profit_amount":"4000","erp_j_profit_amount":"4000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"4000","erp_j_profit_pct":20,"erp_profit_pct":20,"client":{"id":1181,"key":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\/\u4e2d\u5316\u79cd\u4e1a\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09"},"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":4297,"from_project":4069,"is_outbound":true},"buildContract":{"id":4297,"from_project":4069,"is_outbound":true}},{"id":3963,"project_title":"\u4e00\u6240\u7f51\u7edc\u53ca\u4fe1\u606f\u5316\u57fa\u7840\u8bbe\u65bd\u5347\u7ea7\u52a0\u56fa\u91c7\u8d2d\u9879\u76ee\u4e8c\u671f","client_id":2737,"budget":"2551700","updated_at":"2026-03-12 10:58:49","created_at":"2025-09-07 21:02:37","bargain_date":"2025-12-05","collected":"1786190","un_collected":765510,"pinyin_shortcut":"yswljxxhjcsssjjgcgxmeq","description":"","id2":3963,"erp_cash_cost_ticket_amount":"415.68","erp_cost_ticket_amount":"375243.18","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"1879959.619999999","erp_sales_amount":"2551700","erp_use_amount":"375658.86","erp_profit_amount":"671740.380000001","erp_j_profit_amount":"296081.520000001","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"296081.520000001","erp_j_profit_pct":11.6,"erp_profit_pct":26.33,"client":{"id":2737,"key":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)"},"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":4288,"from_project":3963,"is_outbound":true},"buildContract":{"id":4288,"from_project":3963,"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":"0","erp_j_profit_deduct_labor_amount":"1000","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":3968,"project_title":"PA3220\u7eed\u4fdd1\u5e74-G-2025","client_id":530,"budget":"82600","updated_at":"2026-03-02 09:03:53","created_at":"2025-09-15 11:27:06","bargain_date":"2025-12-02","collected":"82600","un_collected":0,"pinyin_shortcut":"PA3220xb1nG2025","description":"","id2":3968,"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":"72751","erp_sales_amount":"82600","erp_use_amount":"0","erp_profit_amount":"9849","erp_j_profit_amount":"9849","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"9849","erp_j_profit_pct":11.92,"erp_profit_pct":11.92,"client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)"},"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":4277,"from_project":3968,"is_outbound":true},"buildContract":{"id":4277,"from_project":3968,"is_outbound":true}},{"id":4061,"project_title":"\u6df1\u4fe1\u670dAC\u7ef4\u4fdd1\u5e74-2025","client_id":1196,"budget":"2150","updated_at":"2026-02-06 11:36:38","created_at":"2025-12-02 13:26:27","bargain_date":"2025-12-02","collected":"2150","un_collected":0,"pinyin_shortcut":"sxfACwb1n2025","description":"","id2":4061,"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":"1309","erp_sales_amount":"2150","erp_use_amount":"0","erp_profit_amount":"841","erp_j_profit_amount":"841","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"841","erp_j_profit_pct":39.12,"erp_profit_pct":39.12,"client":{"id":1196,"key":1196,"name":"\u5317\u4eac\u536b\u4fe1\u6770\u79d1\u6280\u53d1\u5c55\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":4278,"from_project":4061,"is_outbound":true},"buildContract":{"id":4278,"from_project":4061,"is_outbound":true}},{"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":"0","erp_j_profit_deduct_labor_amount":"23678.9","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}}],"pagenation":{"totalcount":31,"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 09:20:01', 46281216) RETURNING "id"
09:20:01.3110.7 msyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4027, 4087, 4086, 3923, 4077, 4070, 4084, 4067, 4007, 4076, 4066, 4017, 4058, 4072, 3955, 4026, 4068, 4075, 4073, 4074, 4071, 4055, 4031, 4025, 4059, 4069, 3963, 4064, 3968, 4061, 3975)
09:20:01.2690.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:20:01.3090.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 20, 3301, 101, 3359, 24, 3433, 12, 1663, 2094, 3330, 90, 2526, 2166, 3281, 3366, 3431, 1111, 149, 2182, 1181, 2737, 97, 530, 1196)
09:20:01.2710.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:20:01.3090.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001, 5300, 5295, 5087, 1004)
09:20:01.3100.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5300, 5087, 1004, 1005))
09:20:01.2690.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:20:01.3100.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)