ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a69648b57c: POST https://beta.jinchangxiao.com/vue/erp-analysis/sales-data-list at 2026-06-11 03:53:08 pm by 221.216.117.119

Performance Profiling

Total processing time: 165 ms; Peak memory: 6.151 MB. Show Profiling Timeline

总计25条数据
TimeDurationCategoryInfo
  
15:53:08.66239.1 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"."is_draft"=FALSE) OR (p.is_draft IS NULL)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59') AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL)) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) )) "ct" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = ct.project_id LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.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" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-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
15:53:08.60527.2 msyii\db\Command::querySELECT u.id, u.name, u.sex, u.department_id, u.department_position_id, sub.erp_sales_amount, sub.erp_cost_amount, sub.erp_other_in_amount, sub.erp_use_amount, sub.out_amount, sub.in_amount, sub.amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT u.id, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) as erp_sales_amount, COALESCE(sum(sub_in.actual_total_amount), 0) + COALESCE(sum(start.cost), 0) as erp_cost_amount, COALESCE(sum(sub_other_in.amount), 0) as erp_other_in_amount, COALESCE(sum(sub_out.amount), 0) + COALESCE(sum(start.expense), 0) as erp_use_amount, COALESCE(sum(sub_in.actual_total_amount), 0) + COALESCE(sum(start.cost), 0) + COALESCE(sum(sub_out.amount), 0) + COALESCE(sum(start.expense), 0) as out_amount, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) + COALESCE(sum(sub_other_in.amount), 0) as in_amount, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) + COALESCE(sum(sub_other_in.amount), 0) - COALESCE(sum(sub_in.actual_total_amount), 0) - COALESCE(sum(start.cost), 0) - COALESCE(sum(sub_out.amount), 0) - COALESCE(sum(start.expense), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT "user_id", sum(actual_total_amount) as actual_total_amount, sum(total_amount) as total_amount FROM ((SELECT t.handler as user_id, sum(eipss.actual_total_amount) as actual_total_amount, sum(eipss.total_amount) as total_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" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."handler") UNION ALL ( SELECT am.user_id, sum(eipss.actual_total_amount * am.pct / 100) as actual_total_amount, sum(eipss.total_amount * am.pct / 100) as total_amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id 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" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_in" ON sub_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_other_in" ON sub_other_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (("t"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON pd.project_id = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(eipss.actual_total_amount - eipss.total_amount) 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" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, sum((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id 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" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_out" ON sub_out.user_id = u.id LEFT JOIN (SELECT user_id, budget, cost, expense, profit FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59')) "start" ON start.user_id = u.id GROUP BY "u"."id") "sub" ON sub.id = u.id WHERE (("user_status"='1') OR (sub.id is not null)) AND ("u"."id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("user_status"='1') OR ((sub.erp_sales_amount != 0) OR (sub.erp_cost_amount != 0) OR (sub.erp_other_in_amount != 0) OR (sub.erp_use_amount != 0) OR (sub.out_amount != 0) OR (sub.in_amount != 0) OR (sub.amount != 0)) OR ("sub"."id" IN (1001, 1004, 1005, 5087, 5295, 5300))) ORDER BY "amount" DESC, "u"."id"
15:53:08.71016.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', 5064, 5, 'vue/erp-analysis/sales-data-list', '{"period":"erpcurrentfascalyear","id":"","project_status":"3","page":"1","pageSize":"40","listReload":"true","web_access_token":"4eQAiv21khj4ckVl-aCvgG-h5XZj42Z5"}', '{"code":2000,"result":{"counts":[{"name":"\u9500\u552e\u5229\u6da6","key":"profits","value":1347.62,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u9500\u552e\u6d41\u6c34","key":"currents","value":2026.61,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u5408\u4f5c\u5ba2\u6237\u6570\/\u5546\u673a\u6570","key":"clients","value":36,"unit":"\u4e2a","valueEx":44,"unitEx":"\u4e2a","color":"#98c450","link":[]},{"name":"\u5df2\u6536\u6b3e\/\u672a\u6536\u6b3e\u91d1\u989d","key":"payment","value":37100.5,"unit":"\u4e07","valueEx":9265.25,"unitEx":"\u4e07","color":"#e75a4a","link":[]},{"name":"\u5df2\u5f00\/\u672a\u5f00\u53d1\u7968\u91d1\u989d","key":"invoices","value":41328.92,"unit":"\u4e07","valueEx":9111.61,"unitEx":"\u4e07","color":"#e75a4a","link":[]}],"list":[{"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":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":4172,"project_title":"\u63a8\u7279\u5982\u56fe","client_id":3389,"budget":"18000","updated_at":"2026-05-25 10:12:46","created_at":"2026-05-25 10:12:46","bargain_date":"2026-05-25","collected":"0","un_collected":18000,"pinyin_shortcut":"ttrt","description":"","id2":4172,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"1","erp_sales_amount":"18000","erp_use_amount":"0","erp_profit_amount":"17999","erp_j_profit_amount":"17999","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17999","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4480,"from_project":4172,"is_outbound":true},"buildContract":{"id":4480,"from_project":4172,"is_outbound":true}},{"id":4170,"project_title":"\u516c\u53f8\u8463\u4e8b","client_id":3389,"budget":"900","updated_at":"2026-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":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":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":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":4161,"project_title":"3535","client_id":982,"budget":"12703473","updated_at":"2026-05-21 16:13:22","created_at":"2026-04-01 11:36:21","bargain_date":"2026-04-23","collected":"0","un_collected":12703473,"pinyin_shortcut":"3535","description":"","id2":4161,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"1670.205","erp_sales_amount":"12703073","erp_use_amount":"0","erp_profit_amount":"12701402.795","erp_j_profit_amount":"12701402.795","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12701402.795","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4462,"from_project":4161,"is_outbound":false},"buildContract":{"id":4462,"from_project":4161,"is_outbound":false}},{"id":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":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":4157,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260401002","client_id":3457,"budget":"33333","updated_at":"2026-04-01 11:28:03","created_at":"2026-04-01 11:21:52","bargain_date":"2026-04-01","collected":"555","un_collected":32778,"pinyin_shortcut":"xsxssc20260401002","description":"","id2":4157,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"1","erp_sales_amount":"33333","erp_use_amount":"0","erp_profit_amount":"33332","erp_j_profit_amount":"33332","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"33332","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4453,"from_project":4157,"is_outbound":true},"buildContract":{"id":4453,"from_project":4157,"is_outbound":true}},{"id":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":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":4142,"project_title":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286,"budget":"309425.78","updated_at":"2026-04-08 15:49:36","created_at":"2026-03-17 14:29:58","bargain_date":"2026-03-17","collected":"0","un_collected":309425.78,"pinyin_shortcut":"PA1420ltxgxm","description":"\u6700\u7ec8\u7528\u6237\u4fe1\u606f\uff1a\n\u4ebf\u5ba2\u884c\u54a8\u8be2\u670d\u52a1(\u5317\u4eac)\u6709\u9650\u516c\u53f8\nExpedia Consulting Service (Beijing) Co., Ltd.","id2":4142,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"158798.2","erp_sales_amount":"176442","erp_use_amount":"0","erp_profit_amount":"17643.8","erp_j_profit_amount":"17643.8","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17643.8","erp_j_profit_pct":10,"erp_profit_pct":10,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4446,"from_project":4142,"is_outbound":false},"buildContract":{"id":4446,"from_project":4142,"is_outbound":false}},{"id":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":4130,"project_title":"2026\u9632\u706b\u5899\u7eed\u4fdd","client_id":2032,"budget":"3900","updated_at":"2026-03-13 15:41:20","created_at":"2026-03-04 09:18:25","bargain_date":"2026-03-04","collected":"3900","un_collected":0,"pinyin_shortcut":"2026fhqxb","description":"","id2":4130,"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":"2364","erp_sales_amount":"3900","erp_use_amount":"0","erp_profit_amount":"1536","erp_j_profit_amount":"1536","erp_labor_cost_amount":"45.4602272727273","erp_j_profit_deduct_labor_amount":"1490.53977272727","erp_j_profit_pct":39.38,"erp_profit_pct":39.38,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4430,"from_project":4130,"is_outbound":true},"buildContract":{"id":4430,"from_project":4130,"is_outbound":true}},{"id":4124,"project_title":"\u6df1\u4fe1\u670d\u6258\u7ba1\u4e91\u65b0\u8d2d","client_id":3448,"budget":"2400","updated_at":"2026-03-11 17:09:11","created_at":"2026-02-28 10:34:36","bargain_date":"2026-03-02","collected":"2400","un_collected":0,"pinyin_shortcut":"sxftgyxg","description":"","id2":4124,"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":"1661.92","erp_sales_amount":"2400","erp_use_amount":"0","erp_profit_amount":"738.08","erp_j_profit_amount":"738.08","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"738.08","erp_j_profit_pct":30.75,"erp_profit_pct":30.75,"client":{"id":3448,"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d"},"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":4426,"from_project":4124,"is_outbound":true},"buildContract":{"id":4426,"from_project":4124,"is_outbound":true}},{"id":4123,"project_title":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS","client_id":89,"budget":"18600","updated_at":"2026-03-23 13:29:40","created_at":"2026-02-28 10:21:10","bargain_date":"2026-02-28","collected":"0","un_collected":18600,"pinyin_shortcut":"FAS8300ypkr6k18TSAS","description":"","id2":4123,"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":"15000","erp_sales_amount":"18600","erp_use_amount":"0","erp_profit_amount":"3600","erp_j_profit_amount":"3600","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"3600","erp_j_profit_pct":19.35,"erp_profit_pct":19.35,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\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":4424,"from_project":4123,"is_outbound":true},"buildContract":{"id":4424,"from_project":4123,"is_outbound":true}},{"id":4127,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3451,"budget":"29800","updated_at":"2026-03-04 16:01:44","created_at":"2026-02-28 17:51:43","bargain_date":"2026-02-28","collected":"0","un_collected":29800,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4127,"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":3451,"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\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":4433,"from_project":4127,"is_outbound":false},"buildContract":{"id":4433,"from_project":4127,"is_outbound":false}},{"id":4121,"project_title":"\u786c\u76d8\u786c\u76d8-HP P2000-SAS 450GB-20260227","client_id":2021,"budget":"720","updated_at":"2026-03-05 10:37:02","created_at":"2026-02-27 15:08:48","bargain_date":"2026-02-27","collected":"720","un_collected":0,"pinyin_shortcut":"ypypHPP2000SAS450GB20260227","description":"","id2":4121,"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":"500","erp_sales_amount":"720","erp_use_amount":"0","erp_profit_amount":"220","erp_j_profit_amount":"220","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"220","erp_j_profit_pct":30.56,"erp_profit_pct":30.56,"client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\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":4422,"from_project":4121,"is_outbound":true},"buildContract":{"id":4422,"from_project":4121,"is_outbound":true}},{"id":4103,"project_title":"2026\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd","client_id":79,"budget":"20700","updated_at":"2026-03-19 10:01:53","created_at":"2026-01-15 15:41:35","bargain_date":"2026-02-11","collected":"20700","un_collected":0,"pinyin_shortcut":"2026sxffhqxb","description":"","id2":4103,"erp_cash_cost_ticket_amount":"113","erp_cost_ticket_amount":"7000","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"6961.30","erp_sales_amount":"20700","erp_use_amount":"7113","erp_profit_amount":"13738.70","erp_j_profit_amount":"6625.70","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"6625.7","erp_j_profit_pct":32.01,"erp_profit_pct":66.37,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4417,"from_project":4103,"is_outbound":true},"buildContract":{"id":4417,"from_project":4103,"is_outbound":true}},{"id":4119,"project_title":"\u7532\u9aa8\u6587\u6570\u636e\u5e93\u4fee\u590d","client_id":3443,"budget":"10000","updated_at":"2026-02-06 17:14:47","created_at":"2026-02-05 15:45:41","bargain_date":"2026-02-05","collected":"10000","un_collected":0,"pinyin_shortcut":"jgwsjkxf","description":"","id2":4119,"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":"10000","erp_use_amount":"0","erp_profit_amount":"10000","erp_j_profit_amount":"10000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"10000","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3443,"key":3443,"name":"\u5317\u4eac\u534e\u5b87\u65f6\u521b\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":4414,"from_project":4119,"is_outbound":true},"buildContract":{"id":4414,"from_project":4119,"is_outbound":true}},{"id":4118,"project_title":"\u4e2d\u5b5a\u591a\u529f\u80fd\u5012\u5165\u88c5\u7f6e\u91c7\u8d2d","client_id":2526,"budget":"3000","updated_at":"2026-03-22 19:47:19","created_at":"2026-02-02 16:24:13","bargain_date":"2026-02-02","collected":"0","un_collected":3000,"pinyin_shortcut":"zfdgndrzzcg","description":"","id2":4118,"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":"2500","erp_sales_amount":"3000","erp_use_amount":"0","erp_profit_amount":"500","erp_j_profit_amount":"500","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"500","erp_j_profit_pct":16.67,"erp_profit_pct":16.67,"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":4408,"from_project":4118,"is_outbound":true},"buildContract":{"id":4408,"from_project":4118,"is_outbound":true}},{"id":4098,"project_title":"PA460\u8bbe\u5907\u7b49\u91c7\u8d2d\u9879\u76ee","client_id":3377,"budget":"1630000","updated_at":"2026-04-30 13:49:40","created_at":"2026-01-12 10:33:31","bargain_date":"2026-01-28","collected":"999","un_collected":1629001,"pinyin_shortcut":"PA460sbdcgxm","description":"","id2":4098,"erp_cash_cost_ticket_amount":"999","erp_cost_ticket_amount":"388713","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"1046515","erp_sales_amount":"1630000","erp_use_amount":"389712","erp_profit_amount":"583485","erp_j_profit_amount":"193773","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"193773","erp_j_profit_pct":11.89,"erp_profit_pct":35.8,"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4399,"from_project":4098,"is_outbound":true},"buildContract":{"id":4399,"from_project":4098,"is_outbound":true}},{"id":4113,"project_title":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125,"budget":"378880","updated_at":"2026-04-22 15:46:14","created_at":"2026-01-22 21:24:33","bargain_date":"2026-01-28","collected":"227328","un_collected":151552,"pinyin_shortcut":"hysxtK","description":"","id2":4113,"erp_cash_cost_ticket_amount":"174.6","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"644.54","created_by":5087,"erp_cost_amount":"286525","erp_sales_amount":"333880","erp_use_amount":"819.14","erp_profit_amount":"47355","erp_j_profit_amount":"46535.86","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"46535.86","erp_j_profit_pct":13.94,"erp_profit_pct":14.18,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4400,"from_project":4113,"is_outbound":false},"buildContract":{"id":4400,"from_project":4113,"is_outbound":false}},{"id":4094,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u6388\u6743\u65b0\u8d2dPOCN26018145-2026","client_id":12,"budget":"57000","updated_at":"2026-03-05 22:58:45","created_at":"2026-01-07 10:01:28","bargain_date":"2026-01-27","collected":"57000","un_collected":0,"pinyin_shortcut":"sxfxnhsqxgPOCN260181452026","description":"","id2":4094,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"7500","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5300,"erp_cost_amount":"37122.00","erp_sales_amount":"57000","erp_use_amount":"7500","erp_profit_amount":"19878.00","erp_j_profit_amount":"12378.00","erp_labor_cost_amount":"22.7301136363636","erp_j_profit_deduct_labor_amount":"12355.2698863636","erp_j_profit_pct":21.72,"erp_profit_pct":34.87,"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":4394,"from_project":4094,"is_outbound":true},"buildContract":{"id":4394,"from_project":4094,"is_outbound":true}},{"id":4116,"project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","client_id":3438,"budget":"3837034","updated_at":"2026-02-06 17:15:32","created_at":"2026-01-27 17:20:18","bargain_date":"2026-01-27","collected":"0","un_collected":3837034,"pinyin_shortcut":"zbszylgzzzsh","description":"","id2":4116,"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":"3721922","erp_sales_amount":"3837034","erp_use_amount":"0","erp_profit_amount":"115112","erp_j_profit_amount":"115112","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"115112","erp_j_profit_pct":3,"erp_profit_pct":3,"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"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":4396,"from_project":4116,"is_outbound":true},"buildContract":{"id":4396,"from_project":4116,"is_outbound":true}},{"id":4115,"project_title":"netapp\u5b58\u50a8\u6269\u5bb9","client_id":57,"budget":"48000","updated_at":"2026-03-18 13:21:42","created_at":"2026-01-26 14:58:47","bargain_date":"2026-01-26","collected":"0","un_collected":48000,"pinyin_shortcut":"netappcckr","description":"","id2":4115,"erp_cash_cost_ticket_amount":"2775.97","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1005,"erp_cost_amount":"33400","erp_sales_amount":"48000","erp_use_amount":"2775.97","erp_profit_amount":"14600","erp_j_profit_amount":"11824.03","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"11824.03","erp_j_profit_pct":24.63,"erp_profit_pct":30.42,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4393,"from_project":4115,"is_outbound":true},"buildContract":{"id":4393,"from_project":4115,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1001,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"14900.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"14900.00000000000000000000","erp_j_profit_amount":"14900.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"14900","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1022,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"2980.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":5248,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"2980.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","department_id":2,"avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":5085,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"2980.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1023,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"2980.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}},{"id":4111,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","client_id":3435,"budget":"29800","updated_at":"2026-04-30 13:48:32","created_at":"2026-01-22 11:53:00","bargain_date":"2026-01-22","collected":"29800","un_collected":0,"pinyin_shortcut":"jcxERPrjytcgxm","description":"","id2":4111,"erp_cash_cost_ticket_amount":"0.00000000000000000000","erp_cost_ticket_amount":"0.00000000000000000000","erp_cost_convert_amount":"0.00000000000000000000","erp_sales_gift_amount":"0.00000000000000000000","created_by":1015,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"2980.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"2980.00000000000000000000","erp_j_profit_amount":"2980.00000000000000000000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2980","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"buildContract2":{"id":4388,"from_project":4111,"is_outbound":true},"buildContract":{"id":4388,"from_project":4111,"is_outbound":true}}],"pagenation":{"totalcount":49,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-11 15:53:08', 137873920) RETURNING "id"
15:53:08.65011.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"."is_draft"=FALSE) OR (p.is_draft IS NULL)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59') AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL)) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) )) "ct" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = ct.project_id LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.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" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-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"
15:53:08.5774.1 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:53:08.6413.7 msyii\db\Command::querySELECT sum(sub.invoices) as invoices FROM (SELECT sc.id, CASE WHEN sc.including_tax = false or sum(sci.amount) > sc.amount THEN 0 ELSE sc.amount - (CASE WHEN SUM ( sci.amount ) IS NOT NULL THEN SUM ( sci.amount ) ELSE 0 END) END as invoices FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE "sc"."including_tax"=TRUE GROUP BY "sc"."id") "sub"
15:53:08.5822.4 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
15:53:08.6372.0 msyii\db\Command::querySELECT sum(c.erp_settle_amount) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE "p"."project_status"=3
15:53:08.5971.9 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
15:53:08.5991.6 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
15:53:08.5861.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
15:53:08.6351.5 msyii\db\Command::querySELECT sum(case when p.budget >= p.collected THEN p.budget - p.collected ELSE 0 END) AS un_collected FROM "a57be577deb434"."tbl_projects" "p" WHERE "p"."project_status"=3
15:53:08.7061.4 msyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4146, 3957, 3796, 3854, 4174, 4172, 4170, 4169, 4168, 4167, 4166, 4144, 4161, 4164, 4151, 4157, 4155, 4145, 4139, 4142, 4128, 4130, 4124, 4123, 4127, 4121, 4103, 4119, 4118, 4098, 4113, 4094, 4116, 4115, 4111)
15:53:08.6011.2 msyii\db\Command::querySELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, "created_by" FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
15:53:08.6341.2 msyii\db\Command::querySELECT sum(p.budget * p.profit_pct / 100) AS profits, sum(p.budget) AS currents, sum(p.collected) AS collected, count(distinct p.client_id) as clients, count(p.id) AS count_current FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."project_status"=3) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59')
15:53:08.6401.1 msyii\db\Command::querySELECT sum(sci.amount) AS invoices FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.project_id = p.id
15:53:08.6330.7 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, 5087, 1005, 5295, 5300, 5332, 5476, 1013, 1004, 5311))
15:53:08.7020.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (93, 2130, 2125, 2128, 3462, 3389, 3009, 982, 2593, 2150, 3457, 20, 2182, 3286, 1172, 2032, 3448, 89, 3451, 2021, 79, 3443, 2526, 3377, 12, 3438, 57, 3435)
15:53:08.5950.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
15:53:08.7050.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 2)
15:53:08.7040.4 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, 1023, 5085, 1022, 5087, 1004, 1005, 5248, 1015, 5300))
15:53:08.7030.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5087, 1001, 5300, 1004, 5295, 1022, 5248, 5085, 1023, 1015)
15:53:08.6460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
15:53:08.5960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)
15:53:08.6460.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)