ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7af6cec847: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2025-09-15 02:17:16 pm by 115.171.251.67

Database Queries

总计12条数据
TimeDurationTypeQuery
  
14:17:16.9722.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

[+] Explain
14:17:16.9751.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
14:17:16.9798.0 msSELECTSELECT COUNT(*) FROM (SELECT "p".* 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 (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 "p"."bargain_date" DESC, "p"."updated_at" DESC) "c"

[+] Explain
14:17:16.98713.5 msSELECTSELECT "p".* 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 (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 "p"."bargain_date" DESC, "p"."updated_at" DESC LIMIT 40 OFFSET 200

[+] Explain
14:17:17.0010.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 427, 57, 2094, 3317, 3326, 3303, 543, 3301, 1181, 2546, 149, 530, 1196, 3311, 189, 90, 2088, 2601, 3309, 20, 2526, 48, 2845, 3304, 3293)

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

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

[+] Explain
14:17:17.0030.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 9)

[+] Explain
14:17:17.0040.7 msSELECTSELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3682, 3712, 3696, 3704, 3710, 3736, 3709, 3701, 3697, 3679, 3663, 3693, 3653, 3688, 3531, 3673, 3687, 3686, 3685, 3677, 3681, 3698, 3675, 3678, 3667, 3676, 3564, 3648, 3671, 3670, 3658, 3669, 3659, 3660, 3661, 3656, 3664, 3630, 3672, 3655)

[+] Explain
14:17:17.0063.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')

[+] Explain
14:17:17.0100.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=40, "last_visit_at"='now()' WHERE "id"=56565

[+] Explain
14:17:17.0112.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/erp-analysis/list-sales-cost', '{"created_at_period":"","created_by":"","created_at_to":"","created_at_from":"","page":"6","web_access_token":"zACaxwY58DCRigSw1MlM3KllVvnv2n5E"}', '{"code":2000,"result":{"list":[{"id":3682,"project_title":"netapp\u5b58\u50a8\u7ef4\u4fdd\u4e00\u5e74-K-2024","client_id":12,"budget":"62890","updated_at":"2025-03-03 13:20:35","created_at":"2024-10-12 14:03:44","bargain_date":"2024-11-11","collected":"62890","un_collected":0,"pinyin_shortcut":"netappccwbynK2024","description":"","id2":3682,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3660,"from_project":3682,"is_outbound":true},"buildContract":{"id":3660,"from_project":3682,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3712,"project_title":"2024\u5b58\u50a8\u7eed\u4fdd","client_id":427,"budget":"20000","updated_at":"2024-12-06 19:55:51","created_at":"2024-11-12 11:35:06","bargain_date":"2024-11-08","collected":"20000","un_collected":0,"pinyin_shortcut":"2024ccxb","description":"","id2":3712,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":427,"key":427,"name":"\u7eff\u6676\u534a\u5bfc\u4f53\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\/\u7eff\u82af\u534a\u5bfc\u4f53\uff08\u53a6\u95e8\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":3662,"from_project":3712,"is_outbound":true},"buildContract":{"id":3662,"from_project":3712,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3696,"project_title":"\u5317\u4eac25 \u5e74 veeam \u7eed\u4fdd-CD2024110700002094","client_id":57,"budget":"13750","updated_at":"2025-04-28 14:45:06","created_at":"2024-10-21 15:37:53","bargain_date":"2024-11-07","collected":"13750","un_collected":0,"pinyin_shortcut":"bj25nveeamxbCD2024110700002094","description":"","id2":3696,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\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":3656,"from_project":3696,"is_outbound":true},"buildContract":{"id":3656,"from_project":3696,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"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","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},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3710,"project_title":"\u65b0\u8d2d\u6570\u636e\u5907\u4efd\u548c\u65e5\u5fd7\u5ba1\u8ba1\u7cfb\u7edf","client_id":3317,"budget":"228435","updated_at":"2025-07-14 10:53:52","created_at":"2024-11-04 17:20:36","bargain_date":"2024-11-04","collected":"228435","un_collected":0,"pinyin_shortcut":"xgsjbfhrzsjxt","description":"","id2":3710,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3317,"key":3317,"name":"\u5317\u4eac\u98de\u9e4f\u6052\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8\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":3646,"from_project":3710,"is_outbound":true},"buildContract":{"id":3646,"from_project":3710,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3736,"project_title":"\u897f\u660c\u7f51\u5173\u9879\u76ee-K","client_id":3326,"budget":"293040","updated_at":"2025-02-11 09:39:52","created_at":"2024-12-09 11:00:55","bargain_date":"2024-10-30","collected":"293040","un_collected":0,"pinyin_shortcut":"xcwgxmK","description":"","id2":3736,"created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"58.80","erp_profit_amount":"0","erp_j_profit_amount":"-58.80","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":3697,"from_project":3736,"is_outbound":true},"buildContract":{"id":3697,"from_project":3736,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3709,"project_title":"\u7535\u79d1\u592a\u529b\u4fe1\u606f\u4e2d\u5fc3\u673a\u623f\u642c\u8fc1","client_id":3303,"budget":"305280","updated_at":"2024-11-11 17:44:35","created_at":"2024-11-04 11:00:28","bargain_date":"2024-10-29","collected":"305280","un_collected":0,"pinyin_shortcut":"dktlxxzxjfbq","description":"","id2":3709,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"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":3645,"from_project":3709,"is_outbound":true},"buildContract":{"id":3645,"from_project":3709,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3701,"project_title":"\u5ba2\u6237\u81ea\u7528-\u534e\u4e3a\u7f51\u7edc\u8bbe\u5907-2024 \u5e74","client_id":2094,"budget":"19350","updated_at":"2025-01-22 15:00:54","created_at":"2024-10-27 21:02:28","bargain_date":"2024-10-28","collected":"19350","un_collected":0,"pinyin_shortcut":"khzyhwwlsb2024n","description":"","id2":3701,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"105.34","erp_profit_amount":"0","erp_j_profit_amount":"-105.34","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":3636,"from_project":3701,"is_outbound":true},"buildContract":{"id":3636,"from_project":3701,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3697,"project_title":"\u7fa4\u6656\u5b58\u50a8-RS3618XS-G-2024","client_id":543,"budget":"48590","updated_at":"2024-12-27 09:57:18","created_at":"2024-10-23 19:58:49","bargain_date":"2024-10-24","collected":"48590","un_collected":0,"pinyin_shortcut":"qhccRS3618XSG2024","description":"","id2":3697,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"1010.72","erp_profit_amount":"0","erp_j_profit_amount":"-1010.72","client":{"id":543,"key":543,"name":"\u5317\u4eac\u534e\u7199\u4e2d\u73af\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u534e\u7199\u56fd\u9645\u6295\u8d44\u96c6\u56e2\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":3633,"from_project":3697,"is_outbound":true},"buildContract":{"id":3633,"from_project":3697,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3679,"project_title":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u670d\u52a1\u9879\u76ee\uff08\u8fc7\u5355\uff09","client_id":3301,"budget":"175000","updated_at":"2024-12-25 10:18:29","created_at":"2024-10-10 13:22:40","bargain_date":"2024-10-23","collected":"175000","un_collected":0,"pinyin_shortcut":"aqjcyxyptfwxmgd","description":"","id2":3679,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"500.00","erp_profit_amount":"0","erp_j_profit_amount":"-500.00","client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\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":3620,"from_project":3679,"is_outbound":true},"buildContract":{"id":3620,"from_project":3679,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3663,"project_title":"VM300-Credit\u65b0\u8d2d1\u5e74-K-2024","client_id":1181,"budget":"182000","updated_at":"2025-03-25 22:30:35","created_at":"2024-09-20 16:26:12","bargain_date":"2024-10-18","collected":"182000","un_collected":0,"pinyin_shortcut":"VM300Creditxg1nK2024","description":"","id2":3663,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"341.58","erp_profit_amount":"0","erp_j_profit_amount":"-341.58","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":3629,"from_project":3663,"is_outbound":true},"buildContract":{"id":3629,"from_project":3663,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3693,"project_title":"2024\u5e74\u9632\u706b\u5899\u548cIPS\u65b0\u8d2d","client_id":2546,"budget":"19624","updated_at":"2024-12-05 10:09:28","created_at":"2024-10-18 10:17:23","bargain_date":"2024-10-18","collected":"19624","un_collected":0,"pinyin_shortcut":"2024nfhqhIPSxg","description":"","id2":3693,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3609,"from_project":3693,"is_outbound":true},"buildContract":{"id":3609,"from_project":3693,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3653,"project_title":"\u6df1\u4fe1\u670dAD-1000-B1800-TP 2\u53f0\u91c7\u8d2d\u9879\u76ee\uff08\u8fc7\u5355\uff09","client_id":3301,"budget":"172700","updated_at":"2024-12-25 10:18:36","created_at":"2024-09-06 17:12:21","bargain_date":"2024-10-17","collected":"172700","un_collected":0,"pinyin_shortcut":"sxfAD1000B1800TP2tcgxmgd","description":"","id2":3653,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\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":3525,"from_project":3653,"is_outbound":true},"buildContract":{"id":3525,"from_project":3653,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3688,"project_title":"\u534e\u4e09\u4ea4\u6362\u673aPOAM24102555-G-2024","client_id":12,"budget":"3000","updated_at":"2024-11-14 09:54:29","created_at":"2024-10-17 08:35:51","bargain_date":"2024-10-17","collected":"3000","un_collected":0,"pinyin_shortcut":"hsjhjPOAM24102555G2024","description":"","id2":3688,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3603,"from_project":3688,"is_outbound":true},"buildContract":{"id":3603,"from_project":3688,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3531,"project_title":"\u8f6f\u4ef6\u627f\u8f7d\u5e73\u53f0-\u6df1\u4fe1\u670d\u8d85\u878d\u5408","client_id":149,"budget":"384900","updated_at":"2025-08-27 15:15:41","created_at":"2024-05-13 11:02:03","bargain_date":"2024-10-16","collected":"384900","un_collected":0,"pinyin_shortcut":"rjczptsxfcrh","description":"","id2":3531,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"69.00","erp_profit_amount":"0","erp_j_profit_amount":"-69.00","client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\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":3627,"from_project":3531,"is_outbound":true},"buildContract":{"id":3627,"from_project":3531,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3673,"project_title":"PA3220\u7eed\u4fdd1\u5e74-G-2024","client_id":530,"budget":"65500","updated_at":"2025-07-08 16:11:31","created_at":"2024-09-27 17:38:36","bargain_date":"2024-10-15","collected":"65500","un_collected":0,"pinyin_shortcut":"PA3220xb1nG2024","description":"","id2":3673,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)"},"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":3625,"from_project":3673,"is_outbound":true},"buildContract":{"id":3625,"from_project":3673,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3687,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd1\u5e74-2024-G","client_id":1196,"budget":"2150","updated_at":"2025-05-15 15:47:23","created_at":"2024-10-16 16:58:38","bargain_date":"2024-10-15","collected":"2150","un_collected":0,"pinyin_shortcut":"sxfACxb1n2024G","description":"","id2":3687,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":1196,"key":1196,"name":"\u5317\u4eac\u536b\u4fe1\u6770\u79d1\u6280\u53d1\u5c55\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":3602,"from_project":3687,"is_outbound":true},"buildContract":{"id":3602,"from_project":3687,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3686,"project_title":"\u7fa4\u6656\u5b58\u50a8DS923+\u91c7\u8d2d\u9879\u76ee","client_id":3311,"budget":"75760","updated_at":"2024-11-29 13:52:19","created_at":"2024-10-16 11:11:45","bargain_date":"2024-10-15","collected":"75760","un_collected":0,"pinyin_shortcut":"qhccDS923cgxm","description":"","id2":3686,"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","client":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3598,"from_project":3686,"is_outbound":true},"buildContract":{"id":3598,"from_project":3686,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3685,"project_title":"2024\u5353\u8c6a\u65e5\u5ba1\u8bbe\u5907\u7eed\u4fdd","client_id":189,"budget":"38155","updated_at":"2024-11-26 15:39:58","created_at":"2024-10-15 10:37:09","bargain_date":"2024-10-14","collected":"38155","un_collected":0,"pinyin_shortcut":"2024zhrssbxb","description":"","id2":3685,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821"},"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":3616,"from_project":3685,"is_outbound":true},"buildContract":{"id":3616,"from_project":3685,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3677,"project_title":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","client_id":90,"budget":"406550","updated_at":"2024-12-10 11:39:21","created_at":"2024-10-08 16:57:59","bargain_date":"2024-10-12","collected":"406550","un_collected":0,"pinyin_shortcut":"xgdecc","description":"","id2":3677,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"5504.11","erp_profit_amount":"0","erp_j_profit_amount":"-5504.11","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \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":3597,"from_project":3677,"is_outbound":true},"buildContract":{"id":3597,"from_project":3677,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3681,"project_title":"POBJ24101597-\u56fa\u6001\u786c\u76d8+\u5185\u5b58-G-2024","client_id":12,"budget":"594","updated_at":"2024-10-28 13:12:32","created_at":"2024-10-12 13:59:27","bargain_date":"2024-10-12","collected":"594","un_collected":0,"pinyin_shortcut":"POBJ24101597gtypncG2024","description":"","id2":3681,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3588,"from_project":3681,"is_outbound":true},"buildContract":{"id":3588,"from_project":3681,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3698,"project_title":"\u81ea\u7814\u8f6f\u4ef6\u5907\u4efd\u7cfb\u7edf-\u7231\u6570","client_id":149,"budget":"134900","updated_at":"2025-02-26 11:32:47","created_at":"2024-10-25 10:11:10","bargain_date":"2024-10-11","collected":"134900","un_collected":0,"pinyin_shortcut":"zyrjbfxtas","description":"","id2":3698,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"139.65","erp_profit_amount":"0","erp_j_profit_amount":"-139.65","client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\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":3628,"from_project":3698,"is_outbound":true},"buildContract":{"id":3628,"from_project":3698,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3675,"project_title":"\u65b0\u8d2dXDLP","client_id":2088,"budget":"22000","updated_at":"2024-10-17 17:35:08","created_at":"2024-10-08 10:50:23","bargain_date":"2024-10-10","collected":"22000","un_collected":0,"pinyin_shortcut":"xgXDLP","description":"","id2":3675,"created_by":5311,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2088,"key":2088,"name":"\u5317\u4eac\u827e\u7ef4\u955d\u751f\u7269\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","department_id":9,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"buildContract2":{"id":3580,"from_project":3675,"is_outbound":true},"buildContract":{"id":3580,"from_project":3675,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3678,"project_title":"POBJ24100330-\u56fa\u6001\u786c\u76d8-G-2024","client_id":12,"budget":"299","updated_at":"2024-10-17 09:26:22","created_at":"2024-10-09 16:47:17","bargain_date":"2024-10-09","collected":"299","un_collected":0,"pinyin_shortcut":"POBJ24100330gtypG2024","description":"","id2":3678,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3576,"from_project":3678,"is_outbound":true},"buildContract":{"id":3576,"from_project":3678,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3667,"project_title":"\u5947\u5b89\u4fe1\u5b89\u5168\u4ea7\u54c1-\u53052\uff08\u80cc\u9760\u80cc\uff09","client_id":2601,"budget":"2285600","updated_at":"2025-06-20 12:15:35","created_at":"2024-09-22 19:36:27","bargain_date":"2024-10-08","collected":"1599920","un_collected":685680,"pinyin_shortcut":"qaxaqcpb2bkb","description":"","id2":3667,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2601,"key":2601,"name":"\u592a\u6781\u8ba1\u7b97\u673a\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09\uff08 \u5317\u4eac\u592a\u6781\u4fe1\u606f\u7cfb\u7edf\u6280\u672f\u6709\u9650\u516c\u53f8\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":3611,"from_project":3667,"is_outbound":true},"buildContract":{"id":3611,"from_project":3667,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3676,"project_title":"\u6df1\u4fe1\u670dEDR","client_id":3309,"budget":"24000","updated_at":"2024-11-21 17:25:16","created_at":"2024-10-08 15:47:00","bargain_date":"2024-09-30","collected":"24000","un_collected":0,"pinyin_shortcut":"sxfEDR","description":"","id2":3676,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3309,"key":3309,"name":"\u4e2d\u90fd\uff08\u682a\u6d32\uff09\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":3573,"from_project":3676,"is_outbound":true},"buildContract":{"id":3573,"from_project":3676,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3564,"project_title":"24\u5e74\u5b89\u5168\u4ea7\u54c1\u7eed\u4fdd","client_id":20,"budget":"180000","updated_at":"2024-12-09 09:57:53","created_at":"2024-06-11 14:05:02","bargain_date":"2024-09-28","collected":"180000","un_collected":0,"pinyin_shortcut":"24naqcpxb","description":"","id2":3564,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"100.32","erp_profit_amount":"0","erp_j_profit_amount":"-100.32","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":3565,"from_project":3564,"is_outbound":true},"buildContract":{"id":3565,"from_project":3564,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3648,"project_title":"\u5907\u7528\u4ea4\u6362\u673a\u91c7\u8d2d-K","client_id":2526,"budget":"3900","updated_at":"2025-08-29 12:20:41","created_at":"2024-09-01 23:00:44","bargain_date":"2024-09-25","collected":"3900","un_collected":0,"pinyin_shortcut":"byjhjcgK","description":"","id2":3648,"created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"96","erp_profit_amount":"0","erp_j_profit_amount":"-96","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3529,"from_project":3648,"is_outbound":true},"buildContract":{"id":3529,"from_project":3648,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3671,"project_title":"\u65b0\u8d2dUPS\u4ea7\u54c1","client_id":2546,"budget":"38715","updated_at":"2024-11-04 17:11:45","created_at":"2024-09-25 14:27:49","bargain_date":"2024-09-25","collected":"38715","un_collected":0,"pinyin_shortcut":"xgUPScp","description":"","id2":3671,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3559,"from_project":3671,"is_outbound":true},"buildContract":{"id":3559,"from_project":3671,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3670,"project_title":"POBJ24095329-16G DDR4 3200 \u53f0\u5f0f\u673a\u5185\u5b58-G-2024","client_id":12,"budget":"590","updated_at":"2024-10-17 09:31:47","created_at":"2024-09-25 13:47:31","bargain_date":"2024-09-25","collected":"590","un_collected":0,"pinyin_shortcut":"POBJ2409532916GDDR43200tsjncG2024","description":"","id2":3670,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3556,"from_project":3670,"is_outbound":true},"buildContract":{"id":3556,"from_project":3670,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3658,"project_title":"Netapp\u5b58\u50a8\u786c\u76d8","client_id":48,"budget":"7600","updated_at":"2024-10-31 09:26:38","created_at":"2024-09-18 08:53:25","bargain_date":"2024-09-23","collected":"7600","un_collected":0,"pinyin_shortcut":"Netappccyp","description":"","id2":3658,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3547,"from_project":3658,"is_outbound":true},"buildContract":{"id":3547,"from_project":3658,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3669,"project_title":"POTJ24094705-\u6a21\u5757-SFP-GE-LX-SM1310-D-G-2024","client_id":12,"budget":"292","updated_at":"2024-10-24 10:00:53","created_at":"2024-09-23 16:16:24","bargain_date":"2024-09-23","collected":"292","un_collected":0,"pinyin_shortcut":"POTJ24094705mkSFPGELXSM1310DG2024","description":"","id2":3669,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3553,"from_project":3669,"is_outbound":true},"buildContract":{"id":3553,"from_project":3669,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3659,"project_title":"\u5317\u4eac-PO#20240920065-\u670d\u52a1\u5668\u786c\u76d8\u66f4\u63621.2T","client_id":57,"budget":"1700","updated_at":"2024-10-30 09:48:07","created_at":"2024-09-19 09:05:32","bargain_date":"2024-09-20","collected":"1700","un_collected":0,"pinyin_shortcut":"bjPO20240920065fwqypgh12T","description":"","id2":3659,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\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":3548,"from_project":3659,"is_outbound":true},"buildContract":{"id":3548,"from_project":3659,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3660,"project_title":"Panorama\u8bbe\u5907\u53ca\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","client_id":2845,"budget":"85527.78","updated_at":"2024-12-25 10:18:39","created_at":"2024-09-19 13:39:55","bargain_date":"2024-09-19","collected":"85527.78","un_collected":0,"pinyin_shortcut":"Panoramasbjpjcgxm","description":"","id2":3660,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3549,"from_project":3660,"is_outbound":true},"buildContract":{"id":3549,"from_project":3660,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3661,"project_title":"4\u53f0 PA440\u5957\u5305\u4ea7\u54c1\u91c7\u8d2d\u9879\u76ee","client_id":3304,"budget":"160023.44","updated_at":"2024-11-12 17:01:53","created_at":"2024-09-19 15:36:45","bargain_date":"2024-09-19","collected":"160023.44","un_collected":0,"pinyin_shortcut":"4tPA440tbcpcgxm","description":"","id2":3661,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\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":3550,"from_project":3661,"is_outbound":true},"buildContract":{"id":3550,"from_project":3661,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3656,"project_title":"POBJ24093089-\u56fa\u6001\u786c\u76d8-G-2024","client_id":12,"budget":"511","updated_at":"2024-09-29 12:14:12","created_at":"2024-09-14 16:39:07","bargain_date":"2024-09-18","collected":"511","un_collected":0,"pinyin_shortcut":"POBJ24093089gtypG2024","description":"","id2":3656,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":3545,"from_project":3656,"is_outbound":true},"buildContract":{"id":3545,"from_project":3656,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3664,"project_title":"\u65b0\u5efa\u5907\u4efd\u5b58\u50a8","client_id":20,"budget":"39400","updated_at":"2025-01-09 17:37:55","created_at":"2024-09-22 19:24:26","bargain_date":"2024-09-14","collected":"39400","un_collected":0,"pinyin_shortcut":"xjbfcc","description":"","id2":3664,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"59.02","erp_profit_amount":"0","erp_j_profit_amount":"-59.02","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":3552,"from_project":3664,"is_outbound":true},"buildContract":{"id":3552,"from_project":3664,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3630,"project_title":"\u65b0\u8d2d\u601d\u79d1\u4ea4\u6362\u673a-G","client_id":3293,"budget":"106792","updated_at":"2025-03-18 11:38:52","created_at":"2024-08-16 09:08:36","bargain_date":"2024-09-12","collected":"106792","un_collected":0,"pinyin_shortcut":"xgskjhjG","description":"","id2":3630,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"44.40","erp_profit_amount":"0","erp_j_profit_amount":"-44.40","client":{"id":3293,"key":3293,"name":"\u5317\u4eac\u5317\u5927\u65b9\u6b63\u7535\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":3472,"from_project":3630,"is_outbound":true},"buildContract":{"id":3472,"from_project":3630,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3672,"project_title":"\u6c5f\u82cf\u65e0\u9521-PO\uff1a20240926023-20240927033\uff0824\u5e74-25\u5e74PA\u7eed\u4fdd\uff09","client_id":57,"budget":"271822","updated_at":"2024-12-02 15:13:55","created_at":"2024-09-27 10:49:45","bargain_date":"2024-09-12","collected":"271822","un_collected":0,"pinyin_shortcut":"jswxPO202409260232024092703324n25nPAxb","description":"","id2":3672,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\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":3567,"from_project":3672,"is_outbound":true},"buildContract":{"id":3567,"from_project":3672,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3655,"project_title":"\u963f\u91cc\u4e91\u8fc1\u79fb\u670d\u52a1","client_id":3303,"budget":"169600","updated_at":"2024-09-20 09:48:35","created_at":"2024-09-12 18:12:19","bargain_date":"2024-09-12","collected":"169600","un_collected":0,"pinyin_shortcut":"alyqyfw","description":"","id2":3655,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"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":3542,"from_project":3655,"is_outbound":true},"buildContract":{"id":3542,"from_project":3655,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""}],"pagenation":{"totalcount":1587,"thispage":6,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 14:17:17') RETURNING "id"

[+] Explain