ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68ccafec5220e: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2025-09-19 09:20:44 am by 114.244.128.96

Database Queries

总计12条数据
TimeDurationTypeQuery
  
09:20:44.3413.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
09:20:44.3452.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
09:20:44.35112.5 msSELECTSELECT COUNT(*) FROM (SELECT p.*, CASE WHEN p.erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN p.erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o.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(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(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 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(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 WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.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 WHERE ("sc"."is_outbound"=TRUE) AND ("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" DESC, "p"."updated_at" DESC) "c"

[+] Explain
09:20:44.36417.6 msSELECTSELECT p.*, CASE WHEN p.erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN p.erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o.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(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(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 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(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 WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.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 WHERE ("sc"."is_outbound"=TRUE) AND ("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" DESC, "p"."updated_at" DESC LIMIT 40 OFFSET 80

[+] Explain
09:20:44.3830.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 20, 3357, 2007, 528, 2117, 24, 2021, 2146, 3340, 2032, 1172, 2226, 518, 2736, 531, 3326, 4, 3334, 3281, 3333, 2546, 107, 48)

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

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

[+] Explain
09:20:44.3850.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 4)

[+] Explain
09:20:44.3861.3 msSELECTSELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3828, 3829, 3823, 3824, 3826, 3825, 3821, 3814, 3798, 3816, 3799, 3815, 3784, 3812, 3811, 3808, 3803, 3806, 3805, 3804, 3801, 3802, 3800, 3781, 3809, 3788, 3793, 3792, 3794, 3791, 3769, 3789, 3786, 3782, 3771, 3783, 3785, 3777, 3772, 3776)

[+] Explain
09:20:44.39011.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-19')

[+] Explain
09:20:44.4012.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=51, "last_visit_at"='now()' WHERE "id"=56635

[+] Explain
09:20:44.40518.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-sales-cost', '{"created_at_period":"","created_by":"","collected":"1","page":"3","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"list":[{"id":3828,"project_title":"POTJ25046505-\u56fa\u6001\u786c\u76d8+\u5185\u5b58-2025","client_id":12,"budget":"594","updated_at":"2025-05-21 17:57:51","created_at":"2025-04-27 09:13:11","bargain_date":"2025-04-27","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25046505gtypnc2025","description":"","id2":3828,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3878,"from_project":3828,"is_outbound":true},"buildContract":{"id":3878,"from_project":3828,"is_outbound":true}},{"id":3829,"project_title":"POTJ25047226-\u56fa\u6001\u786c\u76d8-2025-G","client_id":12,"budget":"511","updated_at":"2025-05-21 17:57:38","created_at":"2025-04-27 09:15:31","bargain_date":"2025-04-27","collected":"511","un_collected":0,"pinyin_shortcut":"POTJ25047226gtyp2025G","description":"","id2":3829,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3879,"from_project":3829,"is_outbound":true},"buildContract":{"id":3879,"from_project":3829,"is_outbound":true}},{"id":3823,"project_title":"\u4fe1\u521b\u5e73\u53f0\u6269\u5bb9-2025\u5e74","client_id":20,"budget":"237950","updated_at":"2025-08-29 11:57:46","created_at":"2025-04-20 19:55:10","bargain_date":"2025-04-25","collected":"237950","un_collected":0,"pinyin_shortcut":"xcptkr2025n","description":"","id2":3823,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"264.29","erp_profit_amount":"0","erp_j_profit_amount":"-264.29","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\u6657\u7131","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":3881,"from_project":3823,"is_outbound":true},"buildContract":{"id":3881,"from_project":3823,"is_outbound":true}},{"id":3824,"project_title":"\u670d\u52a1\u5668+\u9632\u706b\u5899\u65b0\u8d2d-K-2025","client_id":3357,"budget":"72177","updated_at":"2025-08-13 09:15:34","created_at":"2025-04-22 17:40:28","bargain_date":"2025-04-25","collected":"72177","un_collected":0,"pinyin_shortcut":"fwqfhqxgK2025","description":"\u534e\u4e3a\u9632\u706b\u5899\u8d28\u4fdd1\u5e74\uff0cdell\u670d\u52a1\u5668\u8d28\u4fdd3\u5e74","id2":3824,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"304.80","erp_profit_amount":"0","erp_j_profit_amount":"-304.80","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3357,"key":3357,"name":"\u5317\u4eac\u8231\u6e7e\u6587\u5316\u8fd0\u8425\u7ba1\u7406\u6709\u9650\u8d23\u4efb\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":3875,"from_project":3824,"is_outbound":true},"buildContract":{"id":3875,"from_project":3824,"is_outbound":true}},{"id":3826,"project_title":"POTJ25045989-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"598","updated_at":"2025-05-07 10:12:47","created_at":"2025-04-22 21:49:14","bargain_date":"2025-04-22","collected":"598","un_collected":0,"pinyin_shortcut":"POTJ25045989gtypG2025","description":"","id2":3826,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3872,"from_project":3826,"is_outbound":true},"buildContract":{"id":3872,"from_project":3826,"is_outbound":true}},{"id":3825,"project_title":"POTJ25045988-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-05-07 10:12:04","created_at":"2025-04-22 21:46:50","bargain_date":"2025-04-22","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25045988gtypnct2025","description":"","id2":3825,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3871,"from_project":3825,"is_outbound":true},"buildContract":{"id":3871,"from_project":3825,"is_outbound":true}},{"id":3821,"project_title":"POBJ25044128-\u56fa\u6001\u786c\u76d8-G-2024","client_id":12,"budget":"598","updated_at":"2025-05-07 10:11:22","created_at":"2025-04-17 16:11:31","bargain_date":"2025-04-17","collected":"598","un_collected":0,"pinyin_shortcut":"POBJ25044128gtypG2024","description":"","id2":3821,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3868,"from_project":3821,"is_outbound":true},"buildContract":{"id":3868,"from_project":3821,"is_outbound":true}},{"id":3814,"project_title":"2025veeam\u7eed\u4fdd","client_id":2007,"budget":"34800","updated_at":"2025-05-22 10:53:07","created_at":"2025-04-07 10:15:54","bargain_date":"2025-04-11","collected":"34800","un_collected":0,"pinyin_shortcut":"2025veeamxb","description":"","id2":3814,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2007,"key":2007,"name":"\u4f2f\u7eb3\u5fb7\u63a7\u5236\u8bbe\u5907(\u5317\u4eac)\u6709\u9650\u516c\u53f8-S"},"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":3866,"from_project":3814,"is_outbound":true},"buildContract":{"id":3866,"from_project":3814,"is_outbound":true}},{"id":3798,"project_title":"2025PA\u9632\u706b\u5899\u7eed\u4fdd-K","client_id":528,"budget":"199428","updated_at":"2025-08-27 14:08:26","created_at":"2025-03-10 13:25:16","bargain_date":"2025-04-08","collected":"199428","un_collected":0,"pinyin_shortcut":"2025PAfhqxbK","description":"","id2":3798,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":528,"key":528,"name":"\u5317\u4eac\u8bfa\u8bda\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8(\u5357\u4eac\u5929\u5370\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u5929\u8bda\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u6c47\u8bda\u5065\u534e)"},"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":3861,"from_project":3798,"is_outbound":true},"buildContract":{"id":3861,"from_project":3798,"is_outbound":true}},{"id":3816,"project_title":"\u5357\u975e\u7ea2\u77f3\u9879\u76ee\u6570\u636e\u7f51PA440\u8bbe\u5907\u7eed\u4fdd","client_id":2117,"budget":"3994","updated_at":"2025-06-06 10:28:52","created_at":"2025-04-07 17:34:29","bargain_date":"2025-04-07","collected":"3994","un_collected":0,"pinyin_shortcut":"nfhsxmsjwPA440sbxb","description":"","id2":3816,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":2117,"key":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3857,"from_project":3816,"is_outbound":true},"buildContract":{"id":3857,"from_project":3816,"is_outbound":true}},{"id":3799,"project_title":"\u865a\u62df\u5316\u7b2c\u4e09\u65b9\u8fd0\u7ef4\u670d\u52a1-2025","client_id":24,"budget":"9952","updated_at":"2025-05-19 09:00:11","created_at":"2025-03-14 16:31:14","bargain_date":"2025-04-07","collected":"9952","un_collected":0,"pinyin_shortcut":"xnhdsfywfw2025","description":"","id2":3799,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3865,"from_project":3799,"is_outbound":true},"buildContract":{"id":3865,"from_project":3799,"is_outbound":true}},{"id":3815,"project_title":"POBJ25040666\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-G-2025","client_id":12,"budget":"594","updated_at":"2025-04-22 10:44:55","created_at":"2025-04-07 17:16:09","bargain_date":"2025-04-07","collected":"594","un_collected":0,"pinyin_shortcut":"POBJ25040666gtypnctG2025","description":"","id2":3815,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3855,"from_project":3815,"is_outbound":true},"buildContract":{"id":3855,"from_project":3815,"is_outbound":true}},{"id":3784,"project_title":"\u6570\u636e\u6062\u590d-K-2025","client_id":12,"budget":"151000","updated_at":"2025-08-11 19:15:42","created_at":"2025-02-26 18:53:15","bargain_date":"2025-04-03","collected":"151000","un_collected":0,"pinyin_shortcut":"sjhfK2025","description":"","id2":3784,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"1724.01","erp_profit_amount":"0","erp_j_profit_amount":"-1724.01","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3854,"from_project":3784,"is_outbound":true},"buildContract":{"id":3854,"from_project":3784,"is_outbound":true}},{"id":3812,"project_title":"POTJ25037886\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"299","updated_at":"2025-06-13 14:46:09","created_at":"2025-04-01 16:06:13","bargain_date":"2025-04-01","collected":"299","un_collected":0,"pinyin_shortcut":"POTJ25037886gtypG2025","description":"","id2":3812,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3851,"from_project":3812,"is_outbound":true},"buildContract":{"id":3851,"from_project":3812,"is_outbound":true}},{"id":3811,"project_title":"POTJ25037379-\u786c\u76d8\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:24:37","created_at":"2025-03-31 10:02:17","bargain_date":"2025-03-31","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25037379ypnct2025","description":"","id2":3811,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3849,"from_project":3811,"is_outbound":true},"buildContract":{"id":3849,"from_project":3811,"is_outbound":true}},{"id":3808,"project_title":"\u786c\u76d8-HP P2000-SAS 450GB-20250327","client_id":2021,"budget":"720","updated_at":"2025-04-22 12:20:13","created_at":"2025-03-27 13:13:16","bargain_date":"2025-03-27","collected":"720","un_collected":0,"pinyin_shortcut":"ypHPP2000SAS450GB20250327","description":"","id2":3808,"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_j_profit_pct":"","erp_profit_pct":"","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":3841,"from_project":3808,"is_outbound":true},"buildContract":{"id":3841,"from_project":3808,"is_outbound":true}},{"id":3803,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd1\u5e74-K-2025","client_id":2146,"budget":"25000","updated_at":"2025-04-29 16:24:28","created_at":"2025-03-19 21:24:50","bargain_date":"2025-03-25","collected":"25000","un_collected":0,"pinyin_shortcut":"sxfACxb1nK2025","description":"","id2":3803,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":2146,"key":2146,"name":"\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3864,"from_project":3803,"is_outbound":true},"buildContract":{"id":3864,"from_project":3803,"is_outbound":true}},{"id":3806,"project_title":"\u65b0\u8d2d\u6df1\u4fe1\u670d\u9632\u706b\u5899","client_id":3340,"budget":"25920","updated_at":"2025-05-29 10:44:05","created_at":"2025-03-24 15:05:12","bargain_date":"2025-03-24","collected":"25920","un_collected":0,"pinyin_shortcut":"xgsxffhq","description":"","id2":3806,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"120.54","erp_profit_amount":"0","erp_j_profit_amount":"-120.54","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3340,"key":3340,"name":"\u5317\u4eac\u661f\u8fb0\u672a\u6765\u7a7a\u95f4\u6280\u672f\u7814\u7a76\u9662\uff08\u8fc7\u5355\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":3838,"from_project":3806,"is_outbound":true},"buildContract":{"id":3838,"from_project":3806,"is_outbound":true}},{"id":3805,"project_title":"POBJ25034995-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"511","updated_at":"2025-04-17 16:24:48","created_at":"2025-03-21 11:56:09","bargain_date":"2025-03-21","collected":"511","un_collected":0,"pinyin_shortcut":"POBJ25034995gtypG2025","description":"","id2":3805,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3835,"from_project":3805,"is_outbound":true},"buildContract":{"id":3835,"from_project":3805,"is_outbound":true}},{"id":3804,"project_title":"\u786c\u76d8-HP P2000-SAS 450GB-2025","client_id":2021,"budget":"720","updated_at":"2025-08-27 15:35:55","created_at":"2025-03-20 11:52:46","bargain_date":"2025-03-20","collected":"720","un_collected":0,"pinyin_shortcut":"ypHPP2000SAS450GB2025","description":"","id2":3804,"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_j_profit_pct":"","erp_profit_pct":"","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":3833,"from_project":3804,"is_outbound":true},"buildContract":{"id":3833,"from_project":3804,"is_outbound":true}},{"id":3801,"project_title":"POTJ25034534-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:25:02","created_at":"2025-03-19 20:04:27","bargain_date":"2025-03-19","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25034534gtypnct2025","description":"","id2":3801,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3831,"from_project":3801,"is_outbound":true},"buildContract":{"id":3831,"from_project":3801,"is_outbound":true}},{"id":3802,"project_title":"POTJ25034538-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:24:56","created_at":"2025-03-19 20:08:35","bargain_date":"2025-03-19","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25034538gtypnct2025","description":"","id2":3802,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3832,"from_project":3802,"is_outbound":true},"buildContract":{"id":3832,"from_project":3802,"is_outbound":true}},{"id":3800,"project_title":"25\u5e74\u9632\u706b\u5899\u7eed\u4fdd","client_id":2032,"budget":"3900","updated_at":"2025-06-09 11:35:45","created_at":"2025-03-17 18:28:37","bargain_date":"2025-03-18","collected":"3900","un_collected":0,"pinyin_shortcut":"25nfhqxb","description":"","id2":3800,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","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":3829,"from_project":3800,"is_outbound":true},"buildContract":{"id":3829,"from_project":3800,"is_outbound":true}},{"id":3781,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd","client_id":1172,"budget":"19100","updated_at":"2025-04-09 16:56:37","created_at":"2025-02-24 09:32:46","bargain_date":"2025-03-18","collected":"19100","un_collected":0,"pinyin_shortcut":"sxfACxb","description":"","id2":3781,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":1172,"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u7269\u6d41\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":3844,"from_project":3781,"is_outbound":true},"buildContract":{"id":3844,"from_project":3781,"is_outbound":true}},{"id":3809,"project_title":"\u601d\u4eab\u6df1\u4fe1\u670dEDR2025\u5e74\u7eed\u4fdd","client_id":2226,"budget":"50000","updated_at":"2025-04-08 09:37:11","created_at":"2025-03-27 14:28:53","bargain_date":"2025-03-18","collected":"50000","un_collected":0,"pinyin_shortcut":"sxsxfEDR2025nxb","description":"","id2":3809,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":2226,"key":2226,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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":3842,"from_project":3809,"is_outbound":true},"buildContract":{"id":3842,"from_project":3809,"is_outbound":true}},{"id":3788,"project_title":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","client_id":518,"budget":"1200","updated_at":"2025-05-30 15:08:42","created_at":"2025-03-03 17:13:54","bargain_date":"2025-03-17","collected":"1200","un_collected":0,"pinyin_shortcut":"xgfwqyp","description":"","id2":3788,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\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":3805,"from_project":3788,"is_outbound":true},"buildContract":{"id":3805,"from_project":3788,"is_outbound":true}},{"id":3793,"project_title":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025","client_id":2736,"budget":"2500","updated_at":"2025-05-29 10:44:05","created_at":"2025-03-06 16:53:08","bargain_date":"2025-03-10","collected":"2500","un_collected":0,"pinyin_shortcut":"fhqgzczhzlG2025","description":"","id2":3793,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"114.94","erp_profit_amount":"0","erp_j_profit_amount":"-114.94","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\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":3822,"from_project":3793,"is_outbound":true},"buildContract":{"id":3822,"from_project":3793,"is_outbound":true}},{"id":3792,"project_title":"IBM\u7535\u6e90\u66f4\u6362","client_id":20,"budget":"500","updated_at":"2025-04-07 11:28:10","created_at":"2025-03-06 09:00:53","bargain_date":"2025-03-06","collected":"500","un_collected":0,"pinyin_shortcut":"IBMdygh","description":"","id2":3792,"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_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\u6657\u7131","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":3812,"from_project":3792,"is_outbound":true},"buildContract":{"id":3812,"from_project":3792,"is_outbound":true}},{"id":3794,"project_title":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"511","updated_at":"2025-03-20 17:24:57","created_at":"2025-03-06 19:44:56","bargain_date":"2025-03-06","collected":"511","un_collected":0,"pinyin_shortcut":"POBJ25031110gtypG2025","description":"","id2":3794,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3816,"from_project":3794,"is_outbound":true},"buildContract":{"id":3816,"from_project":3794,"is_outbound":true}},{"id":3791,"project_title":"\u786c\u76d81.8T1\u5757-K-2025","client_id":531,"budget":"3150","updated_at":"2025-04-07 11:28:04","created_at":"2025-03-05 17:28:13","bargain_date":"2025-03-05","collected":"3150","un_collected":0,"pinyin_shortcut":"yp18T1kK2025","description":"","id2":3791,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\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":3811,"from_project":3791,"is_outbound":true},"buildContract":{"id":3811,"from_project":3791,"is_outbound":true}},{"id":3769,"project_title":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","client_id":3326,"budget":"32000","updated_at":"2025-03-31 14:06:31","created_at":"2025-01-21 13:13:23","bargain_date":"2025-03-05","collected":"32000","un_collected":0,"pinyin_shortcut":"xcwgzjfwf","description":"","id2":3769,"created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3770,"from_project":3769,"is_outbound":true},"buildContract":{"id":3770,"from_project":3769,"is_outbound":true}},{"id":3789,"project_title":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","client_id":4,"budget":"1700","updated_at":"2025-07-15 16:16:20","created_at":"2025-03-04 10:28:11","bargain_date":"2025-03-04","collected":"1700","un_collected":0,"pinyin_shortcut":"dynetappFAS22402kG2025","description":"","id2":3789,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":4,"key":4,"name":"\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":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":3809,"from_project":3789,"is_outbound":true},"buildContract":{"id":3809,"from_project":3789,"is_outbound":true}},{"id":3786,"project_title":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","client_id":3334,"budget":"3048204","updated_at":"2025-03-31 15:45:04","created_at":"2025-02-28 16:22:00","bargain_date":"2025-02-28","collected":"3048204","un_collected":0,"pinyin_shortcut":"yjrjgcjkcp","description":"","id2":3786,"created_by":1001,"erp_cost_amount":"0.00000000000000000000","erp_sales_amount":"0.00000000000000000000","erp_use_amount":"0.00000000000000000000","erp_profit_amount":"0.00000000000000000000","erp_j_profit_amount":"0.00000000000000000000","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3803,"from_project":3786,"is_outbound":true},"buildContract":{"id":3803,"from_project":3786,"is_outbound":true}},{"id":3782,"project_title":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"629","updated_at":"2025-08-20 17:56:25","created_at":"2025-02-24 11:45:40","bargain_date":"2025-02-24","collected":"629","un_collected":0,"pinyin_shortcut":"POBJ25024486gtypG2025","description":"","id2":3782,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3792,"from_project":3782,"is_outbound":true},"buildContract":{"id":3792,"from_project":3782,"is_outbound":true}},{"id":3771,"project_title":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9","client_id":3281,"budget":"5869.5","updated_at":"2025-04-08 17:02:14","created_at":"2025-01-23 21:10:43","bargain_date":"2025-02-24","collected":"5869.5","un_collected":0,"pinyin_shortcut":"krss1tjsjd","description":"","id2":3771,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","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":3791,"from_project":3771,"is_outbound":true},"buildContract":{"id":3791,"from_project":3771,"is_outbound":true}},{"id":3783,"project_title":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","client_id":3333,"budget":"2310000","updated_at":"2025-07-07 15:44:00","created_at":"2025-02-26 10:18:25","bargain_date":"2025-02-21","collected":"693000","un_collected":1617000,"pinyin_shortcut":"yjzrjgd","description":"","id2":3783,"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_j_profit_pct":"","erp_profit_pct":"","client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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":3795,"from_project":3783,"is_outbound":true},"buildContract":{"id":3795,"from_project":3783,"is_outbound":true}},{"id":3785,"project_title":"2025\u65b0\u8d2dUPS","client_id":2546,"budget":"10800","updated_at":"2025-04-07 19:22:52","created_at":"2025-02-27 10:13:36","bargain_date":"2025-02-21","collected":"10800","un_collected":0,"pinyin_shortcut":"2025xgUPS","description":"","id2":3785,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\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":3797,"from_project":3785,"is_outbound":true},"buildContract":{"id":3797,"from_project":3785,"is_outbound":true}},{"id":3777,"project_title":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K","client_id":107,"budget":"35100","updated_at":"2025-08-22 15:18:54","created_at":"2025-02-17 10:18:34","bargain_date":"2025-02-20","collected":"35100","un_collected":0,"pinyin_shortcut":"2025xgsxfEDRK","description":"","id2":3777,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"200.00","erp_profit_amount":"0","erp_j_profit_amount":"-200.00","erp_j_profit_pct":"","erp_profit_pct":"","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":3808,"from_project":3777,"is_outbound":true},"buildContract":{"id":3808,"from_project":3777,"is_outbound":true}},{"id":3772,"project_title":"2025\u65b0\u8d2d4090\u663e\u5361-K","client_id":518,"budget":"28000","updated_at":"2025-07-22 14:48:22","created_at":"2025-02-10 10:23:13","bargain_date":"2025-02-17","collected":"28000","un_collected":0,"pinyin_shortcut":"2025xg4090xkK","description":"","id2":3772,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"58.30","erp_profit_amount":"0","erp_j_profit_amount":"-58.30","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\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":3796,"from_project":3772,"is_outbound":true},"buildContract":{"id":3796,"from_project":3772,"is_outbound":true}},{"id":3776,"project_title":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","client_id":48,"budget":"3200","updated_at":"2025-02-26 11:35:01","created_at":"2025-02-12 21:11:37","bargain_date":"2025-02-17","collected":"3200","un_collected":0,"pinyin_shortcut":"hsccyp","description":"","id2":3776,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"365.39","erp_profit_amount":"0","erp_j_profit_amount":"-365.39","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":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":3783,"from_project":3776,"is_outbound":true},"buildContract":{"id":3783,"from_project":3776,"is_outbound":true}}],"pagenation":{"totalcount":605,"thispage":3,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-19 09:20:44') RETURNING "id"

[+] Explain