ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1cde28ec39a: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2026-06-01 09:19:36 am by 221.216.117.119

Log Messages

总计40条数据
TimeLevelCategoryMessage
 
09:19:36.967traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
09:19:36.967traceyii\base\Module::getModuleLoading module: debug
09:19:36.967traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
09:19:36.967traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
09:19:36.967traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
09:19:36.968traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:36.968infotime tracing start1780276776968890880
09:19:36.969traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
09:19:36.969traceyii\web\Application::handleRequestRoute requested: 'vue/erp-analysis/list-sales-cost'
09:19:36.969traceyii\base\Module::getModuleLoading module: vue
09:19:36.970infoyii\web\Session::openSession started
09:19:36.970infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:19:36.970infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:19:36.972traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:36.972traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:19:36.972traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:36.973traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:19:36.973infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:19:36.973traceyii\base\Controller::runActionRoute to run: vue/erp-analysis/list-sales-cost
09:19:36.974traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:36.975traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
09:19:36.975traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpAnalysisController::actionListSalesCost()
09:19:36.975traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:36.977traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:36.978infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
09:19:36.978infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)
09:19:36.981infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, CASE WHEN p.erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN p.erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cash_cost_ticket_amount, COALESCE(sum(ecta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_ticket_amount, COALESCE(sum(eccrta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_convert_amount, COALESCE(sum(esgs.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_gift_amount, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o2.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o2.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_labor_cost_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0) - COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_deduct_labor_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = p.id LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o2" ON p.id = o2.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.id IS NULL) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT cpc.project_id, COALESCE(sum(cpc.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.project_id IS NOT NULL) GROUP BY "cpc"."project_id") "ecctcpc" ON p.id = ecctcpc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id LEFT JOIN (SELECT ct.project_id as project_id, COALESCE(sum(CASE WHEN ct.work_hours > 0 THEN COALESCE(payroll.amount, 0) / GREATEST(( SELECT COUNT(1) FROM generate_series(ct.settle_month::timestamp, (ct.settle_month + interval '1 month - 1 day')::timestamp, interval '1 day') AS work_dates(work_date) LEFT JOIN a57be577deb434.tbl_legal_holidays lh ON lh.edate = work_dates.work_date::date LEFT JOIN a57be577deb434.tbl_punch_strategy_schedules pss ON pss.edate = work_dates.work_date::date AND pss.punch_strategy_id = ps.id WHERE CASE WHEN ps.id IS NULL THEN EXTRACT(ISODOW FROM work_dates.work_date)::integer BETWEEN 1 AND 5 WHEN pss.id IS NOT NULL THEN pss.need_work WHEN ps.legal_holiday AND lh.id IS NOT NULL THEN lh.is_exchange ELSE (ps.week::integer & (1 << (EXTRACT(ISODOW FROM work_dates.work_date)::integer - 1))) <> 0 END ), 1) / GREATEST((CASE WHEN ps.id IS NULL THEN 8 WHEN ps.punch_type = 0 THEN 8 WHEN ps.work_hour IS NOT NULL AND ps.work_hour > 0 THEN ps.work_hour ELSE 8 END), 1) * ct.work_hours ELSE 0 END), 0) as erp_labor_cost_amount FROM ((SELECT p.id as ticket_id, 'preSales' as ticket_type, '售前' as ticket_type_name, p.ticket_no, p.case_id, c.case_no, COALESCE(p.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, p.engineer_id, p.start_at, p.end_at, date_trunc('month', p.start_at)::date as settle_month, EXTRACT(EPOCH FROM (p.end_at - p.start_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = p.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(p.client_id, c.client_id) WHERE (p.start_at IS NOT NULL) AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59')) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.project_id IS NOT NULL GROUP BY "ct"."project_id") "ctlc" ON p.id = ctlc.project_id WHERE ("project_status"=3) AND ("p"."bargain_date" >= '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"
09:19:36.994infoyii\db\Command::querySELECT p.*, CASE WHEN p.erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN p.erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cash_cost_ticket_amount, COALESCE(sum(ecta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_ticket_amount, COALESCE(sum(eccrta.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_convert_amount, COALESCE(sum(esgs.amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_gift_amount, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o2.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o2.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_labor_cost_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(ecctcpc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0) - COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_deduct_labor_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = p.id LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o2" ON p.id = o2.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.id IS NULL) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT cpc.project_id, COALESCE(sum(cpc.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.project_id IS NOT NULL) GROUP BY "cpc"."project_id") "ecctcpc" ON p.id = ecctcpc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id LEFT JOIN (SELECT ct.project_id as project_id, COALESCE(sum(CASE WHEN ct.work_hours > 0 THEN COALESCE(payroll.amount, 0) / GREATEST(( SELECT COUNT(1) FROM generate_series(ct.settle_month::timestamp, (ct.settle_month + interval '1 month - 1 day')::timestamp, interval '1 day') AS work_dates(work_date) LEFT JOIN a57be577deb434.tbl_legal_holidays lh ON lh.edate = work_dates.work_date::date LEFT JOIN a57be577deb434.tbl_punch_strategy_schedules pss ON pss.edate = work_dates.work_date::date AND pss.punch_strategy_id = ps.id WHERE CASE WHEN ps.id IS NULL THEN EXTRACT(ISODOW FROM work_dates.work_date)::integer BETWEEN 1 AND 5 WHEN pss.id IS NOT NULL THEN pss.need_work WHEN ps.legal_holiday AND lh.id IS NOT NULL THEN lh.is_exchange ELSE (ps.week::integer & (1 << (EXTRACT(ISODOW FROM work_dates.work_date)::integer - 1))) <> 0 END ), 1) / GREATEST((CASE WHEN ps.id IS NULL THEN 8 WHEN ps.punch_type = 0 THEN 8 WHEN ps.work_hour IS NOT NULL AND ps.work_hour > 0 THEN ps.work_hour ELSE 8 END), 1) * ct.work_hours ELSE 0 END), 0) as erp_labor_cost_amount FROM ((SELECT p.id as ticket_id, 'preSales' as ticket_type, '售前' as ticket_type_name, p.ticket_no, p.case_id, c.case_no, COALESCE(p.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, p.engineer_id, p.start_at, p.end_at, date_trunc('month', p.start_at)::date as settle_month, EXTRACT(EPOCH FROM (p.end_at - p.start_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = p.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(p.client_id, c.client_id) WHERE (p.start_at IS NOT NULL) AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59')) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.project_id IS NOT NULL GROUP BY "ct"."project_id") "ctlc" ON p.id = ctlc.project_id WHERE ("project_status"=3) AND ("p"."bargain_date" >= '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
09:19:37.039traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:37.039traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:19:37.040infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3389, 982, 3457, 20, 2182, 3286, 1172, 2032, 3448, 89, 3451, 2021, 79, 3443, 2526, 3377, 2125, 12, 3438, 57, 3435, 3436, 107, 2553, 3336, 3281, 918, 2136)
09:19:37.041infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5300, 1004, 5295, 5087, 1022, 1015, 5248, 5085, 1023)
09:19:37.041infoyii\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, 5248, 1015, 5300, 5085, 1022, 5087, 1004, 1005))
09:19:37.042infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 2)
09:19:37.042infoyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4172, 4170, 4169, 4167, 4166, 4161, 4164, 4157, 4155, 4145, 4139, 4142, 4128, 4130, 4124, 4123, 4127, 4121, 4103, 4119, 4118, 4098, 4113, 4094, 4116, 4115, 4111, 4112, 4101, 4100, 4096, 4102, 4085, 4093, 4089)
09:19:37.046traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:37.046traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:19:37.048infoyii\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":"erpcurrentfascalyear","created_by":"","collected":"","outbound_at_period":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":4172,"project_title":"\u63a8\u7279\u5982\u56fe","client_id":3389,"budget":"18000","updated_at":"2026-05-25 10:12:46","created_at":"2026-05-25 10:12:46","bargain_date":"2026-05-25","collected":"0","un_collected":18000,"pinyin_shortcut":"ttrt","description":"","id2":4172,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"1","erp_sales_amount":"18000","erp_use_amount":"0","erp_profit_amount":"17999","erp_j_profit_amount":"17999","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17999","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4480,"from_project":4172,"is_outbound":true},"buildContract":{"id":4480,"from_project":4172,"is_outbound":true}},{"id":4170,"project_title":"\u516c\u53f8\u8463\u4e8b","client_id":3389,"budget":"900","updated_at":"2026-05-22 17:13:42","created_at":"2026-05-22 17:13:42","bargain_date":"2026-05-22","collected":"0","un_collected":900,"pinyin_shortcut":"gsds","description":"","id2":4170,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4479,"from_project":4170,"is_outbound":false},"buildContract":{"id":4479,"from_project":4170,"is_outbound":false}},{"id":4169,"project_title":"\u65b9\u5f0f\u5730\u65b9","client_id":3389,"budget":"1800","updated_at":"2026-05-22 17:05:11","created_at":"2026-05-22 17:05:11","bargain_date":"2026-05-22","collected":"0","un_collected":1800,"pinyin_shortcut":"fsdf","description":"","id2":4169,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4478,"from_project":4169,"is_outbound":false},"buildContract":{"id":4478,"from_project":4169,"is_outbound":false}},{"id":4167,"project_title":"\u65b0\u5efa\u9879\u76ee","client_id":982,"budget":"51486","updated_at":"2026-05-21 18:03:03","created_at":"2026-05-14 10:38:51","bargain_date":"2026-05-14","collected":"100","un_collected":51386,"pinyin_shortcut":"xjxm","description":"","id2":4167,"erp_cash_cost_ticket_amount":"100","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"100","erp_profit_amount":"0","erp_j_profit_amount":"-100","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-100","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4476,"from_project":4167,"is_outbound":false},"buildContract":{"id":4476,"from_project":4167,"is_outbound":false}},{"id":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":4161,"project_title":"3535","client_id":982,"budget":"12703473","updated_at":"2026-05-21 16:13:22","created_at":"2026-04-01 11:36:21","bargain_date":"2026-04-23","collected":"0","un_collected":12703473,"pinyin_shortcut":"3535","description":"","id2":4161,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"0","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"782.205","erp_sales_amount":"12703072","erp_use_amount":"0","erp_profit_amount":"12702289.795","erp_j_profit_amount":"12702289.795","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12702289.795","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4462,"from_project":4161,"is_outbound":false},"buildContract":{"id":4462,"from_project":4161,"is_outbound":false}},{"id":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":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":"0","erp_j_profit_deduct_labor_amount":"1536","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":"0","erp_j_profit_deduct_labor_amount":"12378","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":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}},{"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":4112,"project_title":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","client_id":3436,"budget":"201373.4","updated_at":"2026-02-27 15:00:57","created_at":"2026-01-22 17:29:05","bargain_date":"2026-01-22","collected":"100686.7","un_collected":100686.7,"pinyin_shortcut":"hdjxxx26nxb","description":"","id2":4112,"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":"25138","erp_sales_amount":"27860","erp_use_amount":"0","erp_profit_amount":"2722","erp_j_profit_amount":"2722","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"2722","erp_j_profit_pct":9.77,"erp_profit_pct":9.77,"client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\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":4390,"from_project":4112,"is_outbound":false},"buildContract":{"id":4390,"from_project":4112,"is_outbound":false}},{"id":4101,"project_title":"2026veeam\u7eed\u4fdd","client_id":107,"budget":"58240.2","updated_at":"2026-02-27 15:01:39","created_at":"2026-01-14 14:49:11","bargain_date":"2026-01-21","collected":"58240.2","un_collected":0,"pinyin_shortcut":"2026veeamxb","description":"","id2":4101,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"20000","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"23654","erp_sales_amount":"58240.2","erp_use_amount":"20000","erp_profit_amount":"34586.2","erp_j_profit_amount":"14586.2","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"14586.2","erp_j_profit_pct":25.04,"erp_profit_pct":59.39,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\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":4385,"from_project":4101,"is_outbound":true},"buildContract":{"id":4385,"from_project":4101,"is_outbound":true}},{"id":4100,"project_title":"2026\u6280\u672f\u670d\u52a1","client_id":107,"budget":"30000","updated_at":"2026-02-11 08:56:42","created_at":"2026-01-14 14:47:34","bargain_date":"2026-01-21","collected":"30000","un_collected":0,"pinyin_shortcut":"2026jsfw","description":"","id2":4100,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"10000","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"30000","erp_use_amount":"10000","erp_profit_amount":"30000","erp_j_profit_amount":"20000","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"20000","erp_j_profit_pct":66.67,"erp_profit_pct":100,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\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":4386,"from_project":4100,"is_outbound":true},"buildContract":{"id":4386,"from_project":4100,"is_outbound":true}},{"id":4096,"project_title":"\u6a21\u5757\u91c7\u8d2d","client_id":2553,"budget":"1400","updated_at":"2026-01-19 14:25:54","created_at":"2026-01-09 09:38:13","bargain_date":"2026-01-12","collected":"0","un_collected":1400,"pinyin_shortcut":"mkcg","description":"","id2":4096,"erp_cash_cost_ticket_amount":"0","erp_cost_ticket_amount":"723","erp_cost_convert_amount":"0","erp_sales_gift_amount":"0","created_by":1001,"erp_cost_amount":"380","erp_sales_amount":"1400","erp_use_amount":"723","erp_profit_amount":"1020","erp_j_profit_amount":"297","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"297","erp_j_profit_pct":21.21,"erp_profit_pct":72.86,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\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":4373,"from_project":4096,"is_outbound":true},"buildContract":{"id":4373,"from_project":4096,"is_outbound":true}},{"id":4102,"project_title":"\u58f9\u8fdb\u523625\u5e74\u6280\u672f\u670d\u52a1\u8d39","client_id":3336,"budget":"35800","updated_at":"2026-01-19 14:27:30","created_at":"2026-01-14 15:01:13","bargain_date":"2026-01-08","collected":"35800","un_collected":0,"pinyin_shortcut":"yjz25njsfwf","description":"","id2":4102,"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":"35800","erp_use_amount":"0","erp_profit_amount":"35800","erp_j_profit_amount":"35800","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"35800","erp_j_profit_pct":100,"erp_profit_pct":100,"client":{"id":3336,"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\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":4377,"from_project":4102,"is_outbound":true},"buildContract":{"id":4377,"from_project":4102,"is_outbound":true}},{"id":4085,"project_title":"\u6269\u5bb9\u901f\u77f3\u5b58\u50a8\u8d44\u6e90","client_id":3281,"budget":"63840","updated_at":"2026-03-03 21:15:31","created_at":"2025-12-25 19:03:44","bargain_date":"2026-01-06","collected":"63840","un_collected":0,"pinyin_shortcut":"krsscczy","description":"","id2":4085,"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":"51526.61","erp_sales_amount":"63840","erp_use_amount":"0","erp_profit_amount":"12313.39","erp_j_profit_amount":"12313.39","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12313.39","erp_j_profit_pct":19.29,"erp_profit_pct":19.29,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4364,"from_project":4085,"is_outbound":true},"buildContract":{"id":4364,"from_project":4085,"is_outbound":true}},{"id":4093,"project_title":"\u65b0\u8d2d\u53cd\u6e17\u900f\u819c","client_id":918,"budget":"300","updated_at":"2026-01-29 14:15:21","created_at":"2026-01-06 10:30:01","bargain_date":"2026-01-06","collected":"300","un_collected":0,"pinyin_shortcut":"xgfstm","description":"","id2":4093,"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":"197","erp_sales_amount":"300","erp_use_amount":"0","erp_profit_amount":"103","erp_j_profit_amount":"103","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"103","erp_j_profit_pct":34.33,"erp_profit_pct":34.33,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4366,"from_project":4093,"is_outbound":true},"buildContract":{"id":4366,"from_project":4093,"is_outbound":true}},{"id":4089,"project_title":"\u6d89\u5bc6\u8ba1\u7b97\u673a\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\u5ba2\u6237\u7aef\u6388\u6743\u70b9-2026","client_id":2136,"budget":"28560","updated_at":"2026-03-22 19:51:51","created_at":"2026-01-05 00:33:38","bargain_date":"2026-01-05","collected":"0","un_collected":28560,"pinyin_shortcut":"smjsjbmglxtkhdsqd2026","description":"","id2":4089,"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":"14400","erp_sales_amount":"28560","erp_use_amount":"0","erp_profit_amount":"14160","erp_j_profit_amount":"14160","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"14160","erp_j_profit_pct":49.58,"erp_profit_pct":49.58,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4359,"from_project":4089,"is_outbound":true},"buildContract":{"id":4359,"from_project":4089,"is_outbound":true}}],"pagenation":{"totalcount":41,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 09:19:37', 78916096) RETURNING "id"
09:19:37.051traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:19:37.051traceyii\redis\Connection::executeCommandExecuting Redis Command: SET