ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d012e5aaf3: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2026-06-01 11:49:02 am by 221.216.117.119

Performance Profiling

Total processing time: 185 ms; Peak memory: 4.835 MB. Show Profiling Timeline

总计11条数据
TimeDurationCategoryInfo
  
11:49:02.388158.2 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))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.project_id IS NOT NULL GROUP BY "ct"."project_id") "ctlc" ON p.id = ctlc.project_id WHERE "project_status"=3 GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id ORDER BY p.bargain_date ASC NULLS LAST, p.updated_at DESC LIMIT 40
11:49:02.3789.7 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))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.project_id IS NOT NULL GROUP BY "ct"."project_id") "ctlc" ON p.id = ctlc.project_id WHERE "project_status"=3 GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id ORDER BY p.bargain_date ASC NULLS LAST, p.updated_at DESC) "c"
11:49:02.5521.8 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":"","created_at_from":"","Filter":{"name":"bargain_date","sort":"ASC"},"page":"1","pageSize":"40","listReload":"true","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":136,"project_title":"\u601d\u79d1\u65e0\u7ebf","client_id":16,"budget":"51500","updated_at":"2024-01-31 11:13:40","created_at":"2017-03-24 20:06:35","bargain_date":"2017-01-12","collected":"51500","un_collected":0,"pinyin_shortcut":"skwx","description":"\u601d\u79d1\u65e0\u7ebf","id2":136,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1006,"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":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":52,"from_project":136,"is_outbound":false},"buildContract":{"id":52,"from_project":136,"is_outbound":false}},{"id":147,"project_title":"DELL\u670d\u52a1\u5668\u5185\u5b58","client_id":206,"budget":"17800","updated_at":"2019-04-08 17:24:19","created_at":"2017-03-29 12:03:48","bargain_date":"2017-01-17","collected":"17800","un_collected":0,"pinyin_shortcut":"DELLfwqnc","description":"DELL\u670d\u52a1\u5668\u5185\u5b5816G*6 \u56fa\u6001\u786c\u76d8 800G*1","id2":147,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1008,"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":206,"key":206,"name":"\u5317\u4eac\u5982\u6587\u601d\u79d1\u6280\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8-\u62d2\u7edd"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":59,"from_project":147,"is_outbound":false},"buildContract":{"id":59,"from_project":147,"is_outbound":false}},{"id":34,"project_title":"\u65e0\u7ebf\u7f51\u7edc","client_id":6,"budget":"10259","updated_at":"2024-02-02 15:53:52","created_at":"2017-02-13 09:07:47","bargain_date":"2017-01-20","collected":"10259","un_collected":0,"pinyin_shortcut":"wxwl","description":"10\u697c\u9700\u8981\u505a\u65e0\u7ebf\u7f51\u7edc\uff0c\u548c4\u697c\u8fde\u63a5\uff0c\u5ba2\u6237\u8bf4\u4eca\u5e74\u5e74\u524d\u505a\uff08\u5408\u540c\u7b7e\u8ba2\uff0c\u6b3e\u5df2\u7ecf\u5230\u8d26\uff0c\u5ba2\u6237\u5b9e\u65bd\u65f6\u95f4\u4e0d\u786e\u5b9a\uff09","id2":34,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1009,"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":6,"key":6,"name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8(\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240)"},"createdBy":{"id":1009,"key":1009,"name":"\u9b4f\u78ca","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":7,"from_project":34,"is_outbound":false},"buildContract":{"id":7,"from_project":34,"is_outbound":false}},{"id":3,"project_title":"hp\u5de5\u4f5c\u7ad9","client_id":12,"budget":"16150","updated_at":"2021-06-25 10:23:40","created_at":"2017-02-09 11:57:39","bargain_date":"2017-02-09","collected":"16150","un_collected":0,"pinyin_shortcut":"hpgzz","description":"1.\u7f57\u6280\u9f20\u6807 M100 5\u4e2a\r\n2.Z440\u5de5\u4f5c\u7ad9 \uff1a\u5355E5-1630v3\/32GB DDR\/1TB \/ K2200 4GB\/525W\/\u952e\u9f20\/V223 \u4e00\u5957","id2":3,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":2,"from_project":3,"is_outbound":false},"buildContract":{"id":2,"from_project":3,"is_outbound":false}},{"id":27,"project_title":"3650m2 \u4e3b\u677f","client_id":46,"budget":"2700","updated_at":"2019-05-08 15:51:04","created_at":"2017-02-10 18:21:20","bargain_date":"2017-02-13","collected":"2700","un_collected":0,"pinyin_shortcut":"3650m2zb","description":"3650m2 \u4e3b\u677f","id2":27,"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":46,"key":46,"name":"\u5317\u4eac\u4eac\u4e1c\u65b9\u663e\u793a\u6280\u672f\u6709\u9650\u516c\u53f8-\u4ea6\u5e84\uff08CAE\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":15,"from_project":27,"is_outbound":false},"buildContract":{"id":15,"from_project":27,"is_outbound":false}},{"id":19,"project_title":"veeam strandard","client_id":17,"budget":"56320","updated_at":"2024-11-08 15:47:26","created_at":"2017-02-10 11:28:21","bargain_date":"2017-02-15","collected":"56320","un_collected":0,"pinyin_shortcut":"veeamstrandard","description":" veeam strandard *8c ","id2":19,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1008,"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":17,"key":17,"name":"\u5317\u4eac\u62d3\u84dd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":6,"from_project":19,"is_outbound":false},"buildContract":{"id":6,"from_project":19,"is_outbound":false}},{"id":67,"project_title":"cisco 3925\u8def\u7531\u5668\uff0c2960\u4ea4\u6362\u673a","client_id":23,"budget":"39600","updated_at":"2024-01-31 11:00:52","created_at":"2017-02-28 14:13:35","bargain_date":"2017-02-16","collected":"39600","un_collected":0,"pinyin_shortcut":"cisco3925lyq2960jhj","description":"cisco 3925\u8def\u7531\u5668\uff0c2960\u4ea4\u6362\u673a","id2":67,"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":23,"key":23,"name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53(\u5317\u4eac)\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":21,"from_project":67,"is_outbound":false},"buildContract":{"id":21,"from_project":67,"is_outbound":false}},{"id":40,"project_title":"(\u672a\u8bbe\u7f6e)","client_id":49,"budget":"374200","updated_at":"2024-01-31 15:11:55","created_at":"2017-02-16 18:13:10","bargain_date":"2017-02-17","collected":"374200","un_collected":0,"pinyin_shortcut":"wsz","description":"1.\u5149\u7ea4\u7ebf5\u7c73 4\u6761\r\n2.\u5149\u7ea4\u7ebf3\u7c73 2\u6761\r\n3.\u5149\u7ea4\u7ebf40\u7c73 2\u6761\r\n4.\u5c71\u6cfd\u516d\u7c7b\u7f51\u7ebf3\u7c73 140\u6761\r\n5.\u601d\u79d1 ws-2960x-48ts-L 3\u53f0\r\n6.\u601d\u79d1 ws-2960x-48td-L 1\u53f0\r\n7.\u601d\u79d1 sfp-10g0sr \u6a21\u5757 36\u4e2a\r\n8.\u601d\u79d1 glc-sx-mmd= \u6a21\u5757 12\u4e2a\r\n9.\u601d\u79d1 glc-t RJ45\u6a21\u5757 100\u4e2a\r\n10.\u601d\u79d1 N3K-c3548P-10GX 4\u53f0","id2":40,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":49,"key":49,"name":"\u4e2d\u4f01\u52a8\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u96c6\u6210\u5546-)S"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":9,"from_project":40,"is_outbound":false},"buildContract":{"id":9,"from_project":40,"is_outbound":false}},{"id":42,"project_title":"hp \u7b14\u8bb0\u672c","client_id":12,"budget":"7500","updated_at":"2021-06-25 10:24:38","created_at":"2017-02-17 18:42:28","bargain_date":"2017-02-17","collected":"7500","un_collected":0,"pinyin_shortcut":"hpbjb","description":"1.\u60e0\u666e 840G3 W8G55PP \u7b14\u8bb0\u672c\u4e00\u53f0","id2":42,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":12,"from_project":42,"is_outbound":false},"buildContract":{"id":12,"from_project":42,"is_outbound":false}},{"id":63,"project_title":"3650M5","client_id":28,"budget":"250000","updated_at":"2024-02-19 14:47:23","created_at":"2017-02-24 23:47:07","bargain_date":"2017-02-23","collected":"250000","un_collected":0,"pinyin_shortcut":"3650M5","description":"3650M5 5\u53f0\r\n2650V4*2 64 600 10k*2 \u53cc\u7535 2\u53f0\r\n2650V4*2 64 600 15k*2 \u53cc\u7535 3\u53f0","id2":63,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1007,"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":28,"key":28,"name":"\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"buildContract2":{"id":19,"from_project":63,"is_outbound":false},"buildContract":{"id":19,"from_project":63,"is_outbound":false}},{"id":26,"project_title":"IBM\u670d\u52a1\u5668","client_id":45,"budget":"236500","updated_at":"2021-06-24 16:51:57","created_at":"2017-02-10 18:20:05","bargain_date":"2017-02-27","collected":"236500","un_collected":0,"pinyin_shortcut":"IBMfwq","description":"IBM\u670d\u52a1\u5668\u4e00\u5957 4850*4\/512G\uff0f600*4","id2":26,"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":45,"key":45,"name":"\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\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":20,"from_project":26,"is_outbound":false},"buildContract":{"id":20,"from_project":26,"is_outbound":false}},{"id":71,"project_title":"\u60e0\u666e\u7b14\u8bb0\u672c854","client_id":12,"budget":"38650","updated_at":"2021-06-25 10:25:24","created_at":"2017-03-01 09:33:01","bargain_date":"2017-03-03","collected":"38650","un_collected":0,"pinyin_shortcut":"hpbjb854","description":"1.\u7d22\u5386\u786c\u76d8\u62f7\u8d1d\u673a SL-HD500 \u4e00\u53f0 \r\n2.\u60e0\u666e8540w \u7535\u6c60 \u4e00\u5757\r\n3.\u60e0\u666e 32GB 4Rx4 PC3L-8500R-7 Kit 8\u6761","id2":71,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":23,"from_project":71,"is_outbound":false},"buildContract":{"id":23,"from_project":71,"is_outbound":false}},{"id":87,"project_title":"hp\u590d\u5370\u4ef6 M725dn","client_id":145,"budget":"17368","updated_at":"2022-04-25 10:40:23","created_at":"2017-03-06 14:51:13","bargain_date":"2017-03-06","collected":"17368","un_collected":0,"pinyin_shortcut":"hpfyjM725dn","description":"hp\u590d\u5370\u4ef6 M725dn","id2":87,"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":145,"key":145,"name":"\u5317\u4eac\u5929\u665f\u767e\u7eb3\u5b89\u5168\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8d3e\u4e91\u98de\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":28,"from_project":87,"is_outbound":false},"buildContract":{"id":28,"from_project":87,"is_outbound":false}},{"id":88,"project_title":"\u60e0\u666e ZBOOK17 G3","client_id":146,"budget":"21500","updated_at":"2021-08-02 16:46:58","created_at":"2017-03-06 15:46:46","bargain_date":"2017-03-06","collected":"21500","un_collected":0,"pinyin_shortcut":"hpZBOOK17G3","description":"1.\u60e0\u666e ZBOOK17 G3 M9L91AV \u4e00\u53f0","id2":88,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":26,"from_project":88,"is_outbound":false},"buildContract":{"id":26,"from_project":88,"is_outbound":false}},{"id":89,"project_title":"\u5149\u7ea4\u5361","client_id":48,"budget":"3800","updated_at":"2019-05-05 17:54:10","created_at":"2017-03-06 16:51:15","bargain_date":"2017-03-06","collected":"3800","un_collected":0,"pinyin_shortcut":"gxk","description":"1.42D0485\tEmulex 8 Gb FC Single-port HBA for System x\t1\r\n2.42C2071\tEmulex 4GB FC Dual-Port PCI-E HBA for IBM System x\t1\r\n3.AJ836A\t5M \u5149\u7ea4\u7ebf\t2\r\n","id2":89,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":27,"from_project":89,"is_outbound":false},"buildContract":{"id":27,"from_project":89,"is_outbound":false}},{"id":13,"project_title":"\u6570\u636e\u4e2d\u5fc3\u65b0\u5efa","client_id":27,"budget":"491000","updated_at":"2024-12-25 15:16:43","created_at":"2017-02-09 17:16:42","bargain_date":"2017-03-10","collected":"491000","un_collected":0,"pinyin_shortcut":"sjzxxj","description":"\u6570\u636e\u4e2d\u5fc3\u65b0\u5efa","id2":13,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1006,"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":27,"key":27,"name":"\u5317\u4eac\u6c7d\u8f66\u6613\u751f\u6d3b\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u4e2d\u6cb9\u623f\u5c71\u71d5\u5bbe\u6cb9\u6599\u9500\u552e\u6709\u9650\u516c\u53f8\uff09"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":17,"from_project":13,"is_outbound":false},"buildContract":{"id":17,"from_project":13,"is_outbound":false}},{"id":99,"project_title":"(\u672a\u8bbe\u7f6e)","client_id":152,"budget":"1000","updated_at":"2021-06-28 14:20:36","created_at":"2017-03-13 09:08:27","bargain_date":"2017-03-10","collected":"1000","un_collected":0,"pinyin_shortcut":"wsz","description":" \u7cfb\u7edf\u5b89\u88c5\u5b9e\u65bd","id2":99,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1007,"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":152,"key":152,"name":"\u683c\u745e\u4fe1\u65c5\u6e38\u54a8\u8be2(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"buildContract2":{"id":31,"from_project":99,"is_outbound":false},"buildContract":{"id":31,"from_project":99,"is_outbound":false}},{"id":101,"project_title":"\u9632\u96f7\u7535\u6e90\/3-3-3\u6709\u9650\u4fdd\u4fee","client_id":38,"budget":"47080","updated_at":"2021-06-24 16:37:16","created_at":"2017-03-14 14:55:51","bargain_date":"2017-03-15","collected":"47080","un_collected":0,"pinyin_shortcut":"fldy333yxbx","description":"ProDesk 280G2 MT New Core i3-6100(3.7G\/3M\/2\u6838)\/8G(4G DDR4 2133 * 2)\/500G(SATA)\/\u8d85\u8584DVDRW\/Windows 10 Home 64\u4f4d FDD\/USB KB\/USB Optical Mouse\/\u65b0180W \u9632\u96f7\u7535\u6e90\/3-3-3\u6709\u9650\u4fdd\u4fee 11\u53f0\r\n\r\nV244h (23.8\"\u5bbd\u5c4f16:9 LED\u80cc\u5149VA\u6db2\u6676\u663e\u793a\u5668,VGA,DVI-D,HDMI\uff08\u652f\u6301HDCP\uff09\u63a5\u53e3,\u65e0DVI\u7ebf\u7f06,250nits,3000:1,6\u767e\u4e07:1(\u52a8\u6001\u5bf9\u6bd4\u5ea6),7ms(\u7070\u5ea6),1920x1080)\u7f8e\u56fd\u7535\u5b50\u4ea7\u54c1\u73af\u5883\u5f71\u54cd\u8bc4\u4ef7\u5de5\u5177EPEAT\u94f6\u5956 11\u53f0","id2":101,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1008,"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":38,"key":38,"name":"\u5965\u871c\u601d\u5546\u8d38(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":54,"from_project":101,"is_outbound":false},"buildContract":{"id":54,"from_project":101,"is_outbound":false}},{"id":106,"project_title":"\u670d\u52a1\u5668X3500","client_id":192,"budget":"30900","updated_at":"2024-02-19 14:21:33","created_at":"2017-03-17 14:11:34","bargain_date":"2017-03-20","collected":"30900","un_collected":0,"pinyin_shortcut":"fwqX3500","description":"\u4e00\u53f0\u670d\u52a1\u5668X3500","id2":106,"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":192,"key":192,"name":"\u5317\u4eac\u4e2d\u5317\u521b\u65b0\u79d1\u6280\u53d1\u5c55\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":37,"from_project":106,"is_outbound":false},"buildContract":{"id":37,"from_project":106,"is_outbound":false}},{"id":69,"project_title":"(\u672a\u8bbe\u7f6e)","client_id":112,"budget":"64800","updated_at":"2024-01-19 16:20:57","created_at":"2017-02-28 17:47:03","bargain_date":"2017-03-20","collected":"70700","un_collected":-5900,"pinyin_shortcut":"wsz","description":"\u914d\u7f6e\uff1a\u589e\u52a0\u4e00\u53f0HP\u670d\u52a1\u5668 2*E52630v4\/64G \u5185\u5b58\/4*800G SSD\/\u5197\u4f59\u7535\u6e90\/2GB FBWC RAID\u5361 \u00a564,800 ","id2":69,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1007,"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":112,"key":112,"name":"\u4e50\u5bff\u60a6\u5eb7(\u5317\u4eac)\u5065\u5eb7\u79d1\u6280\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"buildContract2":{"id":41,"from_project":69,"is_outbound":false},"buildContract":{"id":41,"from_project":69,"is_outbound":false}},{"id":98,"project_title":"(\u672a\u8bbe\u7f6e)","client_id":166,"budget":"32900","updated_at":"2021-06-24 11:23:01","created_at":"2017-03-10 19:53:13","bargain_date":"2017-03-20","collected":"32900","un_collected":0,"pinyin_shortcut":"wsz","description":"hp 388 E5-2620v4 *2 64 600*3 \u53cc\u7535","id2":98,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1007,"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":166,"key":166,"name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u6d4b\u8bd5\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"buildContract2":{"id":33,"from_project":98,"is_outbound":false},"buildContract":{"id":33,"from_project":98,"is_outbound":false}},{"id":32,"project_title":"\u670d\u52a1\u5668\u670d\u52a1","client_id":48,"budget":"24818","updated_at":"2021-06-22 16:32:52","created_at":"2017-02-12 00:01:05","bargain_date":"2017-03-20","collected":"24818","un_collected":0,"pinyin_shortcut":"fwqfw","description":"(90%)\r\n1.\u73b0\u6709\u670d\u52a1\u5668\uff0c\u5b58\u50a8\u8bbe\u5907\u786c\u4ef6\u7ef4\u4fdd\u4e00\u5e74\u670d\u52a1 5*9\u3002\r\n\r\n","id2":32,"erp_cash_cost_ticket_amount":"378.20","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"378.20","erp_profit_amount":"0","erp_j_profit_amount":"-378.20","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-378.2","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":36,"from_project":32,"is_outbound":false},"buildContract":{"id":36,"from_project":32,"is_outbound":false}},{"id":43,"project_title":"580g9 8890","client_id":21,"budget":"1018500.00","updated_at":"2019-05-05 22:42:47","created_at":"2017-02-20 09:29:31","bargain_date":"2017-03-20","collected":"1018500","un_collected":0,"pinyin_shortcut":"580g98890","description":"580g9 8890\uff0a4\/32G\uff0a64\/600G\uff0a2+2T\uff0a4","id2":43,"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":21,"key":21,"name":"\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u6709\u9650\u516c\u53f8(\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\u3001\u9f99\u82af\u4e2d\u79d1\u5357\u4eac\u6280\u672f\u6709\u9650\u516c\u53f8)\uff08EDA\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":29,"from_project":43,"is_outbound":false},"buildContract":{"id":29,"from_project":43,"is_outbound":false}},{"id":123,"project_title":"\u60e0\u666epc\u8bbe\u5907","client_id":12,"budget":"17560","updated_at":"2024-01-22 17:23:25","created_at":"2017-03-21 18:19:51","bargain_date":"2017-03-21","collected":"17560","un_collected":0,"pinyin_shortcut":"hppcsb","description":"1.\u60e0\u666e 440G4 i5 \u4e24\u53f0\r\n2.\u60e0\u666e 840G3 I7 \u4e00\u53f0\r\n3.\u60e0\u666e 4G*2 \u6761\r\n4.\u9f20\u6807\u57ab 15\u4e2a","id2":123,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":39,"from_project":123,"is_outbound":false},"buildContract":{"id":39,"from_project":123,"is_outbound":false}},{"id":118,"project_title":"\u60e0\u666e580G7,380g7\u7528\u786c\u76d8","client_id":21,"budget":"4200","updated_at":"2024-01-16 17:05:51","created_at":"2017-03-20 17:47:14","bargain_date":"2017-03-22","collected":"4200","un_collected":0,"pinyin_shortcut":"hp580G7380g7yyp","description":"\u60e0\u666e580G7,380g7\u7528\u786c\u76d8\t507284-B21\t300G 10K 2.5 SAS\u786c\u76d8 4\u4e2a","id2":118,"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":21,"key":21,"name":"\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u6709\u9650\u516c\u53f8(\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\u3001\u9f99\u82af\u4e2d\u79d1\u5357\u4eac\u6280\u672f\u6709\u9650\u516c\u53f8)\uff08EDA\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":40,"from_project":118,"is_outbound":false},"buildContract":{"id":40,"from_project":118,"is_outbound":false}},{"id":7,"project_title":"388G9*4","client_id":24,"budget":"178850","updated_at":"2024-01-16 17:36:26","created_at":"2017-02-09 16:38:27","bargain_date":"2017-03-23","collected":"178850","un_collected":0,"pinyin_shortcut":"388G94","description":"388G9*4","id2":7,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1006,"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":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":24,"from_project":7,"is_outbound":false},"buildContract":{"id":24,"from_project":7,"is_outbound":false}},{"id":21,"project_title":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd","client_id":42,"budget":"48400","updated_at":"2024-02-19 14:23:10","created_at":"2017-02-10 14:48:42","bargain_date":"2017-03-24","collected":"48400","un_collected":0,"pinyin_shortcut":"xnhptwb","description":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd\uff083\u53f0\u670d\u52a1\u5668\u786c\u4ef6+3CPU\u5e74\u5ea6\u7ef4\u62a4\uff09\r\n6\u5757300GB\u786c\u76d8\r\n1\u53f0LS-3100-52TP-SI-H3(\u542b\u7ea7\u8054\u8fde\u63a5\u6a21\u5757)","id2":21,"erp_cash_cost_ticket_amount":"121.72","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1007,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"121.72","erp_profit_amount":"0","erp_j_profit_amount":"-121.72","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-121.72","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"buildContract2":{"id":18,"from_project":21,"is_outbound":false},"buildContract":{"id":18,"from_project":21,"is_outbound":false}},{"id":108,"project_title":"\u6df1\u4fe1\u670dt500","client_id":16,"budget":"16170","updated_at":"2021-07-01 10:22:03","created_at":"2017-03-17 16:20:33","bargain_date":"2017-03-24","collected":"16170","un_collected":0,"pinyin_shortcut":"sxft500","description":"\u6df1\u4fe1\u670dt500 7\u4e2a","id2":108,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1006,"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":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":50,"from_project":108,"is_outbound":false},"buildContract":{"id":50,"from_project":108,"is_outbound":false}},{"id":137,"project_title":"netapp 8200","client_id":5,"budget":"1148800","updated_at":"2024-01-31 16:30:55","created_at":"2017-03-25 12:36:04","bargain_date":"2017-03-25","collected":"1148800","un_collected":0,"pinyin_shortcut":"netapp8200","description":"netapp 8200\u4e00\u5957\u3001MDS9148S \u4e8c\u5957\u3001FI6248 \u6388\u67434\u4e2a\u3001\u6a21\u575716G*8","id2":137,"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":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\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":53,"from_project":137,"is_outbound":false},"buildContract":{"id":53,"from_project":137,"is_outbound":false}},{"id":115,"project_title":"3650\u4ea4\u6362\u673a","client_id":80,"budget":"55100","updated_at":"2024-01-30 18:11:53","created_at":"2017-03-17 17:27:20","bargain_date":"2017-03-27","collected":"55100","un_collected":0,"pinyin_shortcut":"3650jhj","description":"3650\u4ea4\u6362\u673a\u4e00\u53f0\uff0c\u670d\u52a1\u5668\u786c\u76d83T4\u5757\uff0c\u601d\u79d12921\u8def\u7531\u5668\u4e00\u53f0","id2":115,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1008,"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":80,"key":80,"name":"\u5317\u4eac\u8702\u5de2\u9510\u54f2\u5e7f\u544a\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":38,"from_project":115,"is_outbound":false},"buildContract":{"id":38,"from_project":115,"is_outbound":false}},{"id":37,"project_title":"N3524\uff0c2960POE\uff0c2960","client_id":10,"budget":"400000","updated_at":"2024-01-31 15:11:13","created_at":"2017-02-14 18:34:25","bargain_date":"2017-04-01","collected":"400000","un_collected":0,"pinyin_shortcut":"N35242960POE2960","description":"N3524*1\uff1b2960POE*6\uff0c2960*1.","id2":37,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1006,"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":10,"key":10,"name":"\u5317\u4eac\u7ea2\u7f28\u65f6\u4ee3\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5e38\u9752\u85e4\u667a\u5e93\uff08\u5317\u4eac\uff09\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":62,"from_project":37,"is_outbound":false},"buildContract":{"id":62,"from_project":37,"is_outbound":false}},{"id":152,"project_title":"\u5e0c\u6377\u786c\u76d8500G","client_id":12,"budget":"1255","updated_at":"2021-06-25 15:28:54","created_at":"2017-04-01 18:26:35","bargain_date":"2017-04-01","collected":"1255","un_collected":0,"pinyin_shortcut":"xjyp500G","description":"1.\u5e0c\u6377\u786c\u76d8500G \u4e00\u5757\r\n2.MOXA 8\u53e3\u5361 \u4e00\u5757","id2":152,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":64,"from_project":152,"is_outbound":false},"buildContract":{"id":64,"from_project":152,"is_outbound":false}},{"id":70,"project_title":"netapp E5660","client_id":121,"budget":"380000","updated_at":"2021-06-28 16:04:38","created_at":"2017-03-01 07:41:39","bargain_date":"2017-04-05","collected":"380000","un_collected":0,"pinyin_shortcut":"netappE5660","description":"netapp E5660 24* sas,10*ssd","id2":70,"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":121,"key":121,"name":"\u56db\u5ddd\u6d77\u5e95\u635e\u9910\u996e\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u9890\u6d77(\u4e0a\u6d77)\u98df\u54c1\u6709\u9650\u516c\u53f8\u3001\u6d77\u9e3f\u8fbe\u3001\u90d1\u5dde\u8700\u6d77)"},"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":66,"from_project":70,"is_outbound":false},"buildContract":{"id":66,"from_project":70,"is_outbound":false}},{"id":130,"project_title":"HP Z820 2643*2\/32G\/M2000\/1T*5\/30i","client_id":45,"budget":"180000","updated_at":"2021-06-25 09:34:08","created_at":"2017-03-24 15:01:21","bargain_date":"2017-04-05","collected":"180000","un_collected":0,"pinyin_shortcut":"HPZ8202643232GM20001T530i","description":"HP Z820 2643*2\/32G\/M2000\/1T*5\/30i*2 \u4e24\u53f0","id2":130,"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":45,"key":45,"name":"\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\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":65,"from_project":130,"is_outbound":false},"buildContract":{"id":65,"from_project":130,"is_outbound":false}},{"id":109,"project_title":"VMWARE+VEEAM+VIEW\u670d\u52a1","client_id":25,"budget":"89000","updated_at":"2021-06-28 14:34:55","created_at":"2017-03-17 16:28:42","bargain_date":"2017-04-11","collected":"89000","un_collected":0,"pinyin_shortcut":"VMWAREVEEAMVIEWfw","description":"VMWARE+VEEAM+VIEW\u670d\u52a1","id2":109,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1006,"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":25,"key":25,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":68,"from_project":109,"is_outbound":false},"buildContract":{"id":68,"from_project":109,"is_outbound":false}},{"id":157,"project_title":"hp 840G3 16PC\u7b14\u8bb0\u672c","client_id":12,"budget":"35060","updated_at":"2024-01-22 14:16:56","created_at":"2017-04-13 15:18:43","bargain_date":"2017-04-13","collected":"35060","un_collected":0,"pinyin_shortcut":"hp840G316PCbjb","description":"1.hp 840G3 16PC\u7b14\u8bb0\u672c 1\u53f0\r\n2.hp V223\u6db2\u6676 3\u53f0\r\n3.hp 800G3 72PA 2\u53f0\r\n4.hp T628\u7626\u5ba2\u6237\u673a 1\u53f0\r\n5.hp V202\u6db2\u6676 2\u53f0\r\n6.hp 705G1 1\u53f0\r\n7.\u534e\u5317\u5de5\u63a7\u673a610 1\u53f0\r\n","id2":157,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1003,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"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":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":77,"from_project":157,"is_outbound":false},"buildContract":{"id":77,"from_project":157,"is_outbound":false}},{"id":164,"project_title":"\u601d\u79d1 2960","client_id":23,"budget":"36400","updated_at":"2024-01-31 11:22:30","created_at":"2017-04-14 18:24:04","bargain_date":"2017-04-17","collected":"36400","un_collected":0,"pinyin_shortcut":"sk2960","description":"\u601d\u79d1 2960 2\u53f0","id2":164,"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":23,"key":23,"name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53(\u5317\u4eac)\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":81,"from_project":164,"is_outbound":false},"buildContract":{"id":81,"from_project":164,"is_outbound":false}},{"id":22,"project_title":"\u601d\u79d1UCS\u670d\u52a1\u5668FI\u7ef4\u4fdd","client_id":4,"budget":"138000","updated_at":"2024-12-26 14:06:32","created_at":"2017-02-10 15:03:08","bargain_date":"2017-04-18","collected":"138000","un_collected":0,"pinyin_shortcut":"skUCSfwqFIwb","description":"\u601d\u79d1UCS\u670d\u52a1\u5668FI\u7ef4\u4fdd \uff0c3048\u6838\u5fc3\u4ea4\u6362\u673a1\u53f0\uff0c\u5b58\u50a8\u6269\u5bb96\u5feb1.2T\u786c\u76d8 100%","id2":22,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1008,"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":4,"key":4,"name":"\u9ad8\u7891\u5e97\u5e02\u76db\u4e49\u8c6a\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":85,"from_project":22,"is_outbound":false},"buildContract":{"id":85,"from_project":22,"is_outbound":false}},{"id":20,"project_title":"\u5185\u5b58\u6761","client_id":6,"budget":"13200","updated_at":"2019-01-21 10:44:23","created_at":"2017-02-10 11:30:20","bargain_date":"2017-04-18","collected":"13200","un_collected":0,"pinyin_shortcut":"nct","description":"8G\u5185\u5b58\u6761*24 90%+usb server *1","id2":20,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1009,"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":6,"key":6,"name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8(\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240)"},"createdBy":{"id":1009,"key":1009,"name":"\u9b4f\u78ca","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":84,"from_project":20,"is_outbound":false},"buildContract":{"id":84,"from_project":20,"is_outbound":false}},{"id":35,"project_title":"\u865a\u62df\u684c\u9762","client_id":13,"budget":"650000","updated_at":"2024-02-02 15:57:05","created_at":"2017-02-13 09:12:28","bargain_date":"2017-04-20","collected":"650000","un_collected":0,"pinyin_shortcut":"xnzm","description":"DELL \u670d\u52a1\u5668 3\u53f0 \u534e\u4e3a\u4ea4\u6362\u673a2\u53f0 NETAPP\u5b58\u50a8\u4e00\u53f0 \u865a\u62df\u5316\u8f6f\u4ef6 \u684c\u9762\u8f6f\u4ef6 \u6253\u5370\u673a\u4e00\u53f0 \u6253\u5370\u7ba1\u7406\u8f6f\u4ef6\u4e00\u5957 \u5149\u7ea4\u4ea4\u6362\u673a2\u53f0 50%","id2":35,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1008,"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":13,"key":13,"name":"\u5317\u4eac\u4e16\u7eaa\u6668\u6570\u636e\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":86,"from_project":35,"is_outbound":false},"buildContract":{"id":86,"from_project":35,"is_outbound":false}}],"pagenation":{"totalcount":1700,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 11:49:02', 180101888) RETURNING "id"
11:49:02.5490.8 msyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (136, 147, 34, 3, 27, 19, 67, 40, 42, 63, 26, 71, 87, 88, 89, 13, 99, 101, 106, 69, 98, 32, 43, 123, 118, 7, 21, 108, 137, 115, 37, 152, 70, 130, 109, 157, 164, 22, 20, 35)
11:49:02.3730.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:49:02.5470.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (16, 206, 6, 12, 46, 17, 23, 49, 28, 45, 145, 146, 48, 27, 152, 38, 192, 112, 166, 21, 24, 42, 5, 80, 10, 121, 25, 4, 13)
11:49:02.3750.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:49:02.5490.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1008, 1003, 1006, 1007, 1009, 1004, 1005))
11:49:02.5480.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1006, 1008, 1009, 1003, 1005, 1007, 1004)
11:49:02.3730.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:49:02.5490.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 9)