ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
68ccb0b08db02: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2025-09-19 09:24:00 am by 114.244.128.96

Database Queries

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

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

[+] Explain
09:24:00.59015.7 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 "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 erp_j_profit_pct DESC NULLS LAST, p.updated_at DESC) "c"

[+] Explain
09:24:00.60615.1 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 "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 erp_j_profit_pct DESC NULLS LAST, p.updated_at DESC LIMIT 40 OFFSET 80

[+] Explain
09:24:00.6220.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2130, 3383, 3384, 1301, 2545, 3376, 20, 107, 31, 2186, 3357, 2737, 12, 2766, 101, 89, 2845, 1225, 1181, 518, 2177, 93, 1492, 3263, 2115, 2205, 497, 2094)

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

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

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

[+] Explain
09:24:00.6250.8 msSELECTSELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3314, 3926, 3931, 3875, 3855, 3902, 3721, 3761, 3836, 3869, 3824, 3430, 3784, 3411, 3728, 3637, 3872, 3885, 3847, 3737, 3865, 3822, 3930, 3928, 3929, 3920, 3488, 3431, 3719, 3535, 3834, 2684, 3831, 3617, 3258, 3772, 3704, 3912, 3903, 3918)

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

[+] Explain
09:24:00.6310.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=78, "last_visit_at"='now()' WHERE "id"=56635

[+] Explain
09:24:00.6322.0 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":"","Filter":{"name":"erp_j_profit_pct","sort":"DESC"},"page":"3","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"list":[{"id":3314,"project_title":"\u6570\u5b57\u516c\u53f8\u57fa\u7840\u5efa\u8bbe-K","client_id":2130,"budget":"914800","updated_at":"2025-08-20 17:56:21","created_at":"2023-09-20 17:38:55","bargain_date":"2023-09-27","collected":"914800","un_collected":0,"pinyin_shortcut":"szgsjcjsK","description":"","id2":3314,"created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"3902.31","erp_profit_amount":"0","erp_j_profit_amount":"-3902.31","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":2850,"from_project":3314,"is_outbound":true},"buildContract":{"id":2850,"from_project":3314,"is_outbound":true}},{"id":3926,"project_title":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","client_id":3383,"budget":"840","updated_at":"2025-08-20 17:56:04","created_at":"2025-07-21 13:33:14","bargain_date":"2025-07-21","collected":"840","un_collected":0,"pinyin_shortcut":"xgjhjmkhxl","description":"","id2":3926,"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":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\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":4054,"from_project":3926,"is_outbound":true},"buildContract":{"id":4054,"from_project":3926,"is_outbound":true}},{"id":3931,"project_title":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u9879\u76ee","client_id":3384,"budget":"300000","updated_at":"2025-08-20 16:24:16","created_at":"2025-07-27 23:30:12","bargain_date":"2025-08-05","collected":"0","un_collected":300000,"pinyin_shortcut":"sxfswxwglxm","description":"","id2":3931,"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":3384,"key":3384,"name":"\u5e7f\u5dde\u7eb3\u667a\u901a\u79d1\u6280\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":4105,"from_project":3931,"is_outbound":false},"buildContract":{"id":4105,"from_project":3931,"is_outbound":false}},{"id":3875,"project_title":"25\u5e74\u65b0\u8d2d\u670d\u52a1\u5668\u4e3b\u677f\u548c\u786c\u76d8","client_id":1301,"budget":"5100","updated_at":"2025-08-20 15:08:59","created_at":"2025-05-29 15:59:32","bargain_date":"2025-06-04","collected":"5100","un_collected":0,"pinyin_shortcut":"25nxgfwqzbhyp","description":"","id2":3875,"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":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\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":3941,"from_project":3875,"is_outbound":true},"buildContract":{"id":3941,"from_project":3875,"is_outbound":true}},{"id":3855,"project_title":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","client_id":2545,"budget":"40630","updated_at":"2025-08-20 13:13:13","created_at":"2025-05-13 15:54:59","bargain_date":"2025-05-13","collected":"40630","un_collected":0,"pinyin_shortcut":"lxSR650esfwqcgxms","description":"","id2":3855,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"82.40","erp_profit_amount":"0","erp_j_profit_amount":"-82.40","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\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":3900,"from_project":3855,"is_outbound":true},"buildContract":{"id":3900,"from_project":3855,"is_outbound":true}},{"id":3902,"project_title":"\u5b81\u6ce2\u6570\u5b57\u5b89\u5168\u4ea7\u4e1a\u57fa\u5730","client_id":3376,"budget":"600000","updated_at":"2025-08-20 13:11:47","created_at":"2025-06-30 12:02:35","bargain_date":"2025-06-30","collected":"300000","un_collected":300000,"pinyin_shortcut":"nbszaqcyjd","description":"","id2":3902,"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":3376,"key":3376,"name":"\u8fb0\u5c79\u5bf0\u5b87\uff08\u4e0a\u6d77\uff09\u4fe1\u606f\u79d1\u6280\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":4002,"from_project":3902,"is_outbound":true},"buildContract":{"id":4002,"from_project":3902,"is_outbound":true}},{"id":3721,"project_title":"MSS24-25\u5e74\u7eed\u4fdd","client_id":20,"budget":"117000","updated_at":"2025-08-19 12:54:08","created_at":"2024-11-24 19:54:17","bargain_date":"2025-01-03","collected":"117000","un_collected":0,"pinyin_shortcut":"MSS2425nxb","description":"","id2":3721,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"84.62","erp_profit_amount":"0","erp_j_profit_amount":"-84.62","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":3745,"from_project":3721,"is_outbound":true},"buildContract":{"id":3745,"from_project":3721,"is_outbound":true}},{"id":3761,"project_title":"2025\u65b0\u8d2d\u6280\u672f\u670d\u52a1","client_id":107,"budget":"30000","updated_at":"2025-08-19 12:47:56","created_at":"2025-01-09 11:19:50","bargain_date":"2025-02-10","collected":"30000","un_collected":0,"pinyin_shortcut":"2025xgjsfw","description":"","id2":3761,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"283.36","erp_profit_amount":"0","erp_j_profit_amount":"-283.36","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":3777,"from_project":3761,"is_outbound":true},"buildContract":{"id":3777,"from_project":3761,"is_outbound":true}},{"id":3836,"project_title":"2025veeam\u4ea7\u54c1\u7eed\u4fdd","client_id":31,"budget":"25680","updated_at":"2025-08-18 14:59:02","created_at":"2025-04-28 19:15:00","bargain_date":"2025-05-12","collected":"25680","un_collected":0,"pinyin_shortcut":"2025veeamcpxb","description":"","id2":3836,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"56.00","erp_profit_amount":"0","erp_j_profit_amount":"-56.00","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":31,"key":31,"name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\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":3966,"from_project":3836,"is_outbound":true},"buildContract":{"id":3966,"from_project":3836,"is_outbound":true}},{"id":3869,"project_title":"2025\u65b0\u8d2dnetapp\u5b58\u50a8","client_id":2186,"budget":"93000","updated_at":"2025-08-15 15:24:52","created_at":"2025-05-27 11:30:07","bargain_date":"2025-05-28","collected":"93000","un_collected":0,"pinyin_shortcut":"2025xgnetappcc","description":"","id2":3869,"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":2186,"key":2186,"name":"\u6210\u90fd\u6d77\u5149\u96c6\u6210\u7535\u8def\u8bbe\u8ba1\u6709\u9650\u516c\u53f8\uff08EDA)\/\u6d77\u5149\u4fe1\u606f\u6280\u672f\uff08\u6210\u90fd\uff09\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":3931,"from_project":3869,"is_outbound":true},"buildContract":{"id":3931,"from_project":3869,"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":3430,"project_title":"GC-HGX231490\u4e00\u6240\u7f51\u7edc\u53ca\u4fe1\u606f\u5316\u57fa\u7840\u8bbe\u65bd\u5347\u7ea7\u52a0\u56fa\u91c7\u8d2d\u9879\u76ee","client_id":2737,"budget":"1790000","updated_at":"2025-08-12 10:33:53","created_at":"2024-01-22 09:53:31","bargain_date":"2024-03-20","collected":"1790000","un_collected":0,"pinyin_shortcut":"GCHGX231490yswljxxhjcsssjjgcgxm","description":"","id2":3430,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"933.61","erp_profit_amount":"0","erp_j_profit_amount":"-933.61","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2737,"key":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\uff08\u6240\u529e\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":3201,"from_project":3430,"is_outbound":true},"buildContract":{"id":3201,"from_project":3430,"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":3411,"project_title":"\u4e2d\u56fd\u4e00\u6c7d\uff08\u9752\u85e4\u8fc7\u5355\uff09","client_id":2766,"budget":"2880000","updated_at":"2025-08-11 10:07:18","created_at":"2023-12-26 16:05:16","bargain_date":"2024-03-26","collected":"2389813.44","un_collected":490186.56,"pinyin_shortcut":"zgyqqtgd","description":"","id2":3411,"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":2766,"key":2766,"name":"\u5409\u6797\u7701\u5a01\u58eb\u987f\u667a\u80fd\u79d1\u6280\u6709\u9650\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":3202,"from_project":3411,"is_outbound":true},"buildContract":{"id":3202,"from_project":3411,"is_outbound":true}},{"id":3728,"project_title":"25-26\u5e74\u865a\u62df\u5316\u7ef4\u4fdd\u9879\u76ee","client_id":101,"budget":"273000","updated_at":"2025-08-07 15:01:48","created_at":"2024-12-01 22:27:13","bargain_date":"2024-11-29","collected":"0","un_collected":273000,"pinyin_shortcut":"2526nxnhwbxm","description":"","id2":3728,"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":101,"key":101,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\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":3681,"from_project":3728,"is_outbound":true},"buildContract":{"id":3681,"from_project":3728,"is_outbound":true}},{"id":3637,"project_title":"netapp\u5b58\u50a8\u6269\u5bb9","client_id":89,"budget":"227600","updated_at":"2025-08-04 17:11:44","created_at":"2024-08-23 10:43:18","bargain_date":"2024-08-30","collected":"227600","un_collected":0,"pinyin_shortcut":"netappcckr","description":"","id2":3637,"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":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\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":3488,"from_project":3637,"is_outbound":true},"buildContract":{"id":3488,"from_project":3637,"is_outbound":true}},{"id":3872,"project_title":"PA1410 Bundle Lic\u91c7\u8d2d\u9879\u76ee","client_id":2845,"budget":"32557","updated_at":"2025-08-04 14:38:48","created_at":"2025-05-28 13:44:33","bargain_date":"2025-05-28","collected":"32557","un_collected":0,"pinyin_shortcut":"PA1410BundleLiccgxm","description":"","id2":3872,"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":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"},"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":3935,"from_project":3872,"is_outbound":true},"buildContract":{"id":3935,"from_project":3872,"is_outbound":true}},{"id":3885,"project_title":"2025veeam\u7eed\u4fdd-G","client_id":1225,"budget":"15400","updated_at":"2025-08-04 14:38:45","created_at":"2025-06-09 10:26:49","bargain_date":"2025-06-24","collected":"15400","un_collected":0,"pinyin_shortcut":"2025veeamxbG","description":"","id2":3885,"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":1225,"key":1225,"name":"\u5317\u63a7\u6c34\u52a1(\u5317\u4eac\u5317\u63a7\u5149\u4f0f\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8)(\u5929\u6d25\u5317\u6e05\u7535\u529b\u667a\u6167\u80fd\u6e90\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":3995,"from_project":3885,"is_outbound":true},"buildContract":{"id":3995,"from_project":3885,"is_outbound":true}},{"id":3847,"project_title":"PA850\u7eed\u4fdd-K-2025","client_id":1181,"budget":"110915","updated_at":"2025-08-03 21:36:14","created_at":"2025-05-06 10:30:37","bargain_date":"2025-05-21","collected":"110915","un_collected":0,"pinyin_shortcut":"PA850xbK2025","description":"","id2":3847,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"40.00","erp_profit_amount":"0","erp_j_profit_amount":"-40.00","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1181,"key":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3925,"from_project":3847,"is_outbound":true},"buildContract":{"id":3925,"from_project":3847,"is_outbound":true}},{"id":3737,"project_title":"2024\u65b0\u8d2d\u6df1\u4fe1\u670d\u9632\u706b\u5899","client_id":518,"budget":"25920","updated_at":"2025-08-01 09:20:17","created_at":"2024-12-10 11:48:59","bargain_date":"2024-12-09","collected":"25920","un_collected":0,"pinyin_shortcut":"2024xgsxffhq","description":"","id2":3737,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"341.97","erp_profit_amount":"0","erp_j_profit_amount":"-341.97","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":3699,"from_project":3737,"is_outbound":true},"buildContract":{"id":3699,"from_project":3737,"is_outbound":true}},{"id":3865,"project_title":"2025\u5353\u8c6a\u8fd0\u7ef4\u8f6f\u4ef6\u65b0\u8d2d\u548c\u7eed\u4fdd","client_id":2177,"budget":"52000","updated_at":"2025-07-31 13:56:46","created_at":"2025-05-21 16:00:38","bargain_date":"2025-06-05","collected":"52000","un_collected":0,"pinyin_shortcut":"2025zhywrjxghxb","description":"","id2":3865,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"98.00","erp_profit_amount":"0","erp_j_profit_amount":"-98.00","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":2177,"key":2177,"name":"\u4e2d\u79cd\u56fd\u9645\u79cd\u5b50\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":3930,"from_project":3865,"is_outbound":true},"buildContract":{"id":3930,"from_project":3865,"is_outbound":true}},{"id":3822,"project_title":"2025\u7f51\u7edc\u6280\u672f\u670d\u52a1","client_id":1301,"budget":"48000","updated_at":"2025-07-31 13:52:36","created_at":"2025-04-18 12:58:27","bargain_date":"2025-04-28","collected":"14400","un_collected":33600,"pinyin_shortcut":"2025wljsfw","description":"","id2":3822,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"123.87","erp_profit_amount":"0","erp_j_profit_amount":"-123.87","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\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":3886,"from_project":3822,"is_outbound":true},"buildContract":{"id":3886,"from_project":3822,"is_outbound":true}},{"id":3930,"project_title":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","client_id":12,"budget":"299","updated_at":"2025-07-31 13:08:55","created_at":"2025-07-25 15:44:47","bargain_date":"2025-07-25","collected":"299","un_collected":0,"pinyin_shortcut":"POTJ25078337gtyp2025","description":"","id2":3930,"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":4068,"from_project":3930,"is_outbound":true},"buildContract":{"id":4068,"from_project":3930,"is_outbound":true}},{"id":3928,"project_title":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"598","updated_at":"2025-07-31 13:08:52","created_at":"2025-07-24 13:27:15","bargain_date":"2025-07-24","collected":"598","un_collected":0,"pinyin_shortcut":"OTJ25077428gtypG2025","description":"","id2":3928,"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":4064,"from_project":3928,"is_outbound":true},"buildContract":{"id":4064,"from_project":3928,"is_outbound":true}},{"id":3929,"project_title":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"598","updated_at":"2025-07-31 13:08:49","created_at":"2025-07-24 13:29:19","bargain_date":"2025-07-24","collected":"598","un_collected":0,"pinyin_shortcut":"OTJ25077468gtypG2025","description":"","id2":3929,"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":4065,"from_project":3929,"is_outbound":true},"buildContract":{"id":4065,"from_project":3929,"is_outbound":true}},{"id":3920,"project_title":"OTJ25075740-\u5185\u5b58-2025","client_id":12,"budget":"295","updated_at":"2025-07-31 13:08:15","created_at":"2025-07-17 11:24:07","bargain_date":"2025-07-17","collected":"295","un_collected":0,"pinyin_shortcut":"OTJ25075740nc2025","description":"","id2":3920,"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":4043,"from_project":3920,"is_outbound":true},"buildContract":{"id":4043,"from_project":3920,"is_outbound":true}},{"id":3488,"project_title":"\u591a\u56e0\u7d20\u8ba4\u8bc1-\u5b81\u76fe5000\u70b9","client_id":93,"budget":"545000","updated_at":"2025-07-31 12:10:13","created_at":"2024-03-31 22:49:26","bargain_date":"2025-07-31","collected":"0","un_collected":545000,"pinyin_shortcut":"dysrznd5000d","description":"","id2":3488,"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":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\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":4074,"from_project":3488,"is_outbound":false},"buildContract":{"id":4074,"from_project":3488,"is_outbound":false}},{"id":3431,"project_title":"2024\u5e74\u5b58\u50a8\u7ef4\u4fdd\u670d\u52a1","client_id":1492,"budget":"1476560","updated_at":"2025-07-31 11:59:33","created_at":"2024-01-22 09:56:41","bargain_date":"2024-04-26","collected":"1476560","un_collected":0,"pinyin_shortcut":"2024nccwbfw","description":"","id2":3431,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"966.94","erp_profit_amount":"0","erp_j_profit_amount":"-966.94","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\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":3286,"from_project":3431,"is_outbound":true},"buildContract":{"id":3286,"from_project":3431,"is_outbound":true}},{"id":3719,"project_title":"\u601d\u79d1\u786c\u4ef6\u7ef4\u4fdd1\u5e74-K-2024","client_id":12,"budget":"39900","updated_at":"2025-07-31 09:14:37","created_at":"2024-11-21 12:11:27","bargain_date":"2024-12-27","collected":"39900","un_collected":0,"pinyin_shortcut":"skyjwb1nK2024","description":"","id2":3719,"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":3733,"from_project":3719,"is_outbound":true},"buildContract":{"id":3733,"from_project":3719,"is_outbound":true}},{"id":3535,"project_title":"\u670d\u52a1\u5668\u6570\u636e\u5907\u4efdK","client_id":3263,"budget":"29800","updated_at":"2025-07-30 14:06:05","created_at":"2024-05-15 15:37:54","bargain_date":"2024-06-30","collected":"29800","un_collected":0,"pinyin_shortcut":"fwqsjbfK","description":"","id2":3535,"created_by":5329,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"40.00","erp_profit_amount":"0","erp_j_profit_amount":"-40.00","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":3263,"key":3263,"name":"\u5de5\u4e1a\u548c\u4fe1\u606f\u5316\u90e8\u4eba\u624d\u4ea4\u6d41\u4e2d\u5fc3"},"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3375,"from_project":3535,"is_outbound":true},"buildContract":{"id":3375,"from_project":3535,"is_outbound":true}},{"id":3834,"project_title":"2025veeam\u7eed\u4fdd","client_id":1301,"budget":"15300","updated_at":"2025-07-30 10:19:27","created_at":"2025-04-28 19:10:41","bargain_date":"2025-05-30","collected":"15300","un_collected":0,"pinyin_shortcut":"2025veeamxb","description":"","id2":3834,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"41.10","erp_profit_amount":"0","erp_j_profit_amount":"-41.10","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\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":3953,"from_project":3834,"is_outbound":true},"buildContract":{"id":3953,"from_project":3834,"is_outbound":true}},{"id":2684,"project_title":"\u56fd\u5bc6\u4e8c\u671f\u9879\u76ee","client_id":2115,"budget":"2648000","updated_at":"2025-07-29 10:51:48","created_at":"2021-11-10 15:11:08","bargain_date":"2021-11-22","collected":"2621954","un_collected":26046,"pinyin_shortcut":"gmeqxm","description":"\u6c5f\u5357\u79d1\u53cb\u4ea7\u54c1","id2":2684,"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":2115,"key":2115,"name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e"},"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":2148,"from_project":2684,"is_outbound":false},"buildContract":{"id":2148,"from_project":2684,"is_outbound":false}},{"id":3831,"project_title":"PA\u9632\u706b\u5899\u7eed\u4fdd","client_id":2205,"budget":"117000","updated_at":"2025-07-28 09:43:45","created_at":"2025-04-27 16:11:22","bargain_date":"2025-05-24","collected":"117000","un_collected":0,"pinyin_shortcut":"PAfhqxb","description":"","id2":3831,"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":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\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":3960,"from_project":3831,"is_outbound":true},"buildContract":{"id":3960,"from_project":3831,"is_outbound":true}},{"id":3617,"project_title":"PA\u9632\u706b\u5899\u7eed\u4fdd1\u5e74-G-2024","client_id":497,"budget":"63290","updated_at":"2025-07-25 14:53:59","created_at":"2024-08-01 17:38:10","bargain_date":"2024-09-09","collected":"63290","un_collected":0,"pinyin_shortcut":"PAfhqxb1nG2024","description":"","id2":3617,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"287","erp_profit_amount":"0","erp_j_profit_amount":"-287","erp_j_profit_pct":"","erp_profit_pct":"","client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\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":3528,"from_project":3617,"is_outbound":true},"buildContract":{"id":3528,"from_project":3617,"is_outbound":true}},{"id":3258,"project_title":"\u65b0\u8d2d\u66d9\u5149\u670d\u52a1\u5668-K","client_id":518,"budget":"351140","updated_at":"2025-07-25 14:42:24","created_at":"2023-07-16 21:48:33","bargain_date":"2023-08-01","collected":"351140","un_collected":0,"pinyin_shortcut":"xgsgfwqK","description":"\u65b0\u8d2d\u4e00\u53f04\u8def\u670d\u52a1\u5668\uff0cCPU\uff1a6448H","id2":3258,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"149.89","erp_profit_amount":"0","erp_j_profit_amount":"-149.89","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":2766,"from_project":3258,"is_outbound":true},"buildContract":{"id":2766,"from_project":3258,"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":3704,"project_title":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","client_id":2094,"budget":"217500","updated_at":"2025-07-21 11:28:51","created_at":"2024-11-01 10:48:25","bargain_date":"2024-11-04","collected":"217500","un_collected":0,"pinyin_shortcut":"khzysxffhqfzjhj","description":"","id2":3704,"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":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\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":3649,"from_project":3704,"is_outbound":true},"buildContract":{"id":3649,"from_project":3704,"is_outbound":true}},{"id":3912,"project_title":"OTJ25072858-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-07-21 10:45:40","created_at":"2025-07-10 21:01:11","bargain_date":"2025-07-10","collected":"594","un_collected":0,"pinyin_shortcut":"OTJ25072858gtypnct2025","description":"","id2":3912,"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":4021,"from_project":3912,"is_outbound":true},"buildContract":{"id":4021,"from_project":3912,"is_outbound":true}},{"id":3903,"project_title":"POTJ25068095-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"299","updated_at":"2025-07-21 10:45:30","created_at":"2025-06-30 15:38:29","bargain_date":"2025-06-30","collected":"299","un_collected":0,"pinyin_shortcut":"POTJ25068095gtypG2025","description":"","id2":3903,"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":4005,"from_project":3903,"is_outbound":true},"buildContract":{"id":4005,"from_project":3903,"is_outbound":true}},{"id":3918,"project_title":"POTJ25074907-\u56fa\u6001\u786c\u76d8-2025","client_id":12,"budget":"598","updated_at":"2025-07-21 10:45:19","created_at":"2025-07-15 15:48:22","bargain_date":"2025-07-15","collected":"598","un_collected":0,"pinyin_shortcut":"POTJ25074907gtyp2025","description":"","id2":3918,"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":4036,"from_project":3918,"is_outbound":true},"buildContract":{"id":4036,"from_project":3918,"is_outbound":true}}],"pagenation":{"totalcount":1588,"thispage":3,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-19 09:24:00') RETURNING "id"

[+] Explain