ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c3d7a90dab8: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2025-09-12 04:19:53 pm by 114.246.237.213

Performance Profiling

Total processing time: 69 ms; Peak memory: 5.360 MB. Show Profiling Timeline

总计13条数据
TimeDurationCategoryInfo
  
16:19:53.0969.6 msyii\db\Command::querySELECT p.*, p.budget - p.collected AS un_collected, (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_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) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') GROUP BY "p"."id", "pd"."user_id", "pd"."pct" ORDER BY "p"."bargain_date" DESC, "p"."updated_at" DESC LIMIT 40
16:19:53.0897.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, p.budget - p.collected AS un_collected, (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_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) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') GROUP BY "p"."id", "pd"."user_id", "pd"."pct" ORDER BY "p"."bargain_date" DESC, "p"."updated_at" DESC) "c"
16:19:53.1125.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-12')
16:19:53.0592.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:19:53.1192.1 msyii\db\Command::queryINSERT 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":"currentfascalyear","created_by":"","page":"1","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"list":[{"id":3959,"client_id":1661,"project_status":3,"project_progress":2,"budget":"788888","profit_pct":"99.98","bargain_date":"2025-09-11","description":"","created_by":1001,"created_at":"2025-09-11 10:48:23","updated_at":"2025-09-11 15:05:12","engineer_id":"","project_title":"\u5409\u5fb7\u79d1\u5a03","collected":"0","status_updated_at":"2025-09-11 10:49:29.797789+08","success_rate":"","comment":"\u91d1\u5a1c\u5a1c","contract_type":1,"progress_updated_at":"2025-09-11 10:48:23.373331+08","forecast_updated_at":"2025-09-11 10:48:23.373331+08","end_at":"","pinyin_shortcut":"jdkw","creator":1000,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1014,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":788888,"id2":3959,"erp_cost_amount":"18","erp_sales_amount":"788888","erp_use_amount":"0","erp_profit_amount":"788870","erp_j_profit_amount":"788870","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\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":4140,"from_project":3959,"is_outbound":true},"buildContract":{"id":4140,"from_project":3959,"is_outbound":true},"erp_profit_pct":100,"erp_j_profit_pct":100},{"id":3796,"client_id":2125,"project_status":3,"project_progress":3,"budget":"1580000","profit_pct":"99.99","bargain_date":"2025-09-10","description":"","created_by":5087,"created_at":"2025-03-09 10:00:35","updated_at":"2025-09-10 17:52:12","engineer_id":"","project_title":"deepseek\u79c1\u6709\u5316\u90e8\u7f72-239-K","collected":"0","status_updated_at":"2025-09-10 17:48:33.816744+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-25 16:43:18.119966+08","forecast_updated_at":"2025-05-25 16:43:18.119966+08","end_at":"","pinyin_shortcut":"deepseeksyhbs239K","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1013,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":1580000,"id2":3796,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"},"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":4139,"from_project":3796,"is_outbound":false},"buildContract":{"id":4139,"from_project":3796,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3854,"client_id":2128,"project_status":3,"project_progress":5,"budget":"1150000","profit_pct":"100","bargain_date":"2025-09-10","description":"","created_by":5087,"created_at":"2025-05-13 09:35:09","updated_at":"2025-09-10 17:46:14","engineer_id":"","project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u4e8c\u671f","collected":"0","status_updated_at":"2025-09-10 17:41:01.360267+08","success_rate":"","comment":"\u4e8c\u671f\u6269\u5bb9","contract_type":1,"progress_updated_at":"2025-05-25 16:44:14.571721+08","forecast_updated_at":"2025-05-25 16:44:14.571721+08","end_at":"","pinyin_shortcut":"yjzbfeq","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1011,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":1150000,"id2":3854,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4138,"from_project":3854,"is_outbound":false},"buildContract":{"id":4138,"from_project":3854,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3878,"client_id":3369,"project_status":3,"project_progress":3,"budget":"444","profit_pct":"9.9","bargain_date":"2025-09-10","description":"","created_by":5449,"created_at":"2025-06-04 11:59:31","updated_at":"2025-09-10 17:23:46","engineer_id":"","project_title":"\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u4f53\u7cfb\u5316\u5efa\u8bbe","collected":"0","status_updated_at":"2025-09-10 17:23:46.282615+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-04 11:59:31.21381+08","forecast_updated_at":"2025-09-10 17:23:46.282615+08","end_at":"","pinyin_shortcut":"ldszxzbtxhjs","creator":5449,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":444,"id2":3878,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3369,"key":3369,"name":"\u4e2d\u56fd\u4e2d\u7164\u80fd\u6e90\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","sex":"F","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4137,"from_project":3878,"is_outbound":false},"buildContract":{"id":4137,"from_project":3878,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3880,"client_id":2747,"project_status":3,"project_progress":2,"budget":"18855","profit_pct":"11","bargain_date":"2025-09-10","description":"","created_by":5449,"created_at":"2025-06-04 15:23:58","updated_at":"2025-09-10 17:09:45","engineer_id":"","project_title":"\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u5e73\u53f0\u89c4\u5212\u8bbe\u8ba1","collected":"0","status_updated_at":"2025-09-10 17:09:45.593406+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-04 15:23:58.003324+08","forecast_updated_at":"2025-09-10 17:09:45.593406+08","end_at":"","pinyin_shortcut":"ldszxzbptghsj","creator":5449,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":18855,"id2":3880,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2747,"key":2747,"name":"\u4e2d\u56fd\u5316\u5b66\u5de5\u7a0b\u96c6\u56e2"},"createdBy":{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","sex":"F","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4136,"from_project":3880,"is_outbound":false},"buildContract":{"id":4136,"from_project":3880,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3955,"client_id":2166,"project_status":3,"project_progress":4,"budget":"129992","profit_pct":"16.58","bargain_date":"2025-09-10","description":"","created_by":5300,"created_at":"2025-08-25 16:25:50","updated_at":"2025-09-10 16:53:25","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u65b0\u8d2d-G-2025","collected":"0","status_updated_at":"2025-09-10 16:53:25.881047+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 16:25:50.449572+08","forecast_updated_at":"2025-08-25 16:25:50.449572+08","end_at":"","pinyin_shortcut":"sxflxrxgG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":129992,"id2":3955,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4135,"from_project":3955,"is_outbound":false},"buildContract":{"id":4135,"from_project":3955,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"0","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"un_collected":99786,"id2":3945,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":4130,"from_project":3945,"is_outbound":false},"buildContract":{"id":4130,"from_project":3945,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3956,"client_id":2182,"project_status":3,"project_progress":4,"budget":"1360","profit_pct":"35.1","bargain_date":"2025-08-26","description":"","created_by":5300,"created_at":"2025-08-26 13:53:37","updated_at":"2025-08-29 10:39:09","engineer_id":"","project_title":"\u534e\u4e09\u9762\u677fAP\u65b0\u8d2d-2025","collected":"1360","status_updated_at":"2025-08-27 13:35:36.075805+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-26 13:53:37.769647+08","forecast_updated_at":"2025-08-27 13:32:57.462933+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"hsmbAPxg2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1005,"is_sales_order_ready":true,"collected_plan":"1360","change_status_to":"","is_verify":false,"un_collected":0,"id2":3956,"erp_cost_amount":"780","erp_sales_amount":"1360","erp_use_amount":"0","erp_profit_amount":"580","erp_j_profit_amount":"580","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4129,"from_project":3956,"is_outbound":true},"buildContract":{"id":4129,"from_project":3956,"is_outbound":true},"erp_profit_pct":42.65,"erp_j_profit_pct":42.65},{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-04 11:42:10","engineer_id":"","project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":40931,"id2":3927,"erp_cost_amount":"18109","erp_sales_amount":"19708","erp_use_amount":"0","erp_profit_amount":"1599","erp_j_profit_amount":"1599","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\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":4112,"from_project":3927,"is_outbound":false},"buildContract":{"id":4112,"from_project":3927,"is_outbound":false},"erp_profit_pct":8.11,"erp_j_profit_pct":8.11},{"id":3953,"client_id":12,"project_status":3,"project_progress":4,"budget":"4942","profit_pct":"23.39","bargain_date":"2025-08-22","description":"","created_by":5300,"created_at":"2025-08-22 16:43:27","updated_at":"2025-08-27 11:06:15","engineer_id":"","project_title":"POCN25085613-8\u53e3POE\u4ea4\u6362\u673a","collected":"0","status_updated_at":"2025-08-22 16:43:27.537541+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-22 16:43:27.537541+08","forecast_updated_at":"2025-08-22 16:43:27.537541+08","end_at":"","pinyin_shortcut":"POCN250856138kPOEjhj","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1001,"is_sales_order_ready":true,"collected_plan":"4942","change_status_to":"","is_verify":false,"un_collected":4942,"id2":3953,"erp_cost_amount":"3500","erp_sales_amount":"4942","erp_use_amount":"0","erp_profit_amount":"1442","erp_j_profit_amount":"1442","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":4120,"from_project":3953,"is_outbound":true},"buildContract":{"id":4120,"from_project":3953,"is_outbound":true},"erp_profit_pct":29.18,"erp_j_profit_pct":29.18},{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":"","created_by":1000,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-12 10:08:49","engineer_id":"","project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":true,"un_collected":0,"id2":3950,"erp_cost_amount":"84.1580000000000000000000","erp_sales_amount":"2666.6660000000000000000000","erp_use_amount":"880.00000000000000000000","erp_profit_amount":"2582.5080000000000000000000","erp_j_profit_amount":"1702.5080000000000000000000","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"buildContract2":{"id":4131,"from_project":3950,"is_outbound":false},"buildContract":{"id":4131,"from_project":3950,"is_outbound":false},"erp_profit_pct":96.84,"erp_j_profit_pct":63.84},{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":"","created_by":5016,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-12 10:08:49","engineer_id":"","project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":true,"un_collected":0,"id2":3950,"erp_cost_amount":"84.1580000000000000000000","erp_sales_amount":"2666.6660000000000000000000","erp_use_amount":"880.00000000000000000000","erp_profit_amount":"2582.5080000000000000000000","erp_j_profit_amount":"1702.5080000000000000000000","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"buildContract2":{"id":4131,"from_project":3950,"is_outbound":false},"buildContract":{"id":4131,"from_project":3950,"is_outbound":false},"erp_profit_pct":96.84,"erp_j_profit_pct":63.84},{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":"","created_by":5064,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-12 10:08:49","engineer_id":"","project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":true,"un_collected":0,"id2":3950,"erp_cost_amount":"589.1060000000000000000000","erp_sales_amount":"18666.6620000000000000000000","erp_use_amount":"6160.00000000000000000000","erp_profit_amount":"18077.5560000000000000000000","erp_j_profit_amount":"11917.5560000000000000000000","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"buildContract2":{"id":4131,"from_project":3950,"is_outbound":false},"buildContract":{"id":4131,"from_project":3950,"is_outbound":false},"erp_profit_pct":96.84,"erp_j_profit_pct":63.84},{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":"","created_by":5250,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-12 10:08:49","engineer_id":"","project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":true,"un_collected":0,"id2":3950,"erp_cost_amount":"84.1580000000000000000000","erp_sales_amount":"2666.6660000000000000000000","erp_use_amount":"880.00000000000000000000","erp_profit_amount":"2582.5080000000000000000000","erp_j_profit_amount":"1702.5080000000000000000000","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"buildContract2":{"id":4131,"from_project":3950,"is_outbound":false},"buildContract":{"id":4131,"from_project":3950,"is_outbound":false},"erp_profit_pct":96.84,"erp_j_profit_pct":63.84},{"id":3947,"client_id":304,"project_status":3,"project_progress":9,"budget":"7300","profit_pct":"5.15","bargain_date":"2025-08-21","description":"","created_by":5295,"created_at":"2025-08-19 10:48:28","updated_at":"2025-09-03 17:13:07","engineer_id":"","project_title":"\u91c7\u8d2dAdobe\u8f6f\u4ef6","collected":"0","status_updated_at":"2025-08-21 11:40:59.153148+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-19 10:48:28.917403+08","forecast_updated_at":"2025-08-19 10:48:28.917403+08","end_at":"","pinyin_shortcut":"cgAdoberj","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1004,"is_sales_order_ready":false,"collected_plan":"7300","change_status_to":"","is_verify":false,"un_collected":7300,"id2":3947,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"255.92","erp_profit_amount":"0","erp_j_profit_amount":"-255.92","client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\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":4111,"from_project":3947,"is_outbound":false},"buildContract":{"id":4111,"from_project":3947,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3951,"client_id":2136,"project_status":3,"project_progress":5,"budget":"3680","profit_pct":"43.91","bargain_date":"2025-08-21","description":"","created_by":5087,"created_at":"2025-08-21 14:09:04","updated_at":"2025-08-31 22:38:03","engineer_id":"","project_title":"\u8bfb\u5361\u5668\u91c7\u8d2d","collected":"0","status_updated_at":"2025-08-21 14:24:26.262442+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-21 14:09:04.397257+08","forecast_updated_at":"2025-08-25 10:30:45.275316+08","end_at":"","pinyin_shortcut":"dkqcg","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":997,"is_sales_order_ready":true,"collected_plan":"3680","change_status_to":"","is_verify":false,"un_collected":3680,"id2":3951,"erp_cost_amount":"2064","erp_sales_amount":"3680","erp_use_amount":"0","erp_profit_amount":"1616","erp_j_profit_amount":"1616","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4109,"from_project":3951,"is_outbound":true},"buildContract":{"id":4109,"from_project":3951,"is_outbound":true},"erp_profit_pct":43.91,"erp_j_profit_pct":43.91},{"id":3948,"client_id":3366,"project_status":3,"project_progress":9,"budget":"750","profit_pct":"27.2","bargain_date":"2025-08-19","description":"","created_by":5295,"created_at":"2025-08-19 16:52:12","updated_at":"2025-08-22 15:56:10","engineer_id":"","project_title":"\u65b0\u8d2d16G\u5185\u5b58","collected":"750","status_updated_at":"2025-08-19 16:52:12.690427+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-19 16:52:12.690427+08","forecast_updated_at":"2025-08-19 16:52:12.690427+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"xg16Gnc","creator":5295,"used_client":"","from_contact":"","total_contact_point":"150","paid_contact_point":"","project_product_version_id":992,"is_sales_order_ready":true,"collected_plan":"750","change_status_to":"","is_verify":false,"un_collected":0,"id2":3948,"erp_cost_amount":"300","erp_sales_amount":"750","erp_use_amount":"150","erp_profit_amount":"450","erp_j_profit_amount":"300","client":{"id":3366,"key":3366,"name":"\u8fc7\u5355-\u5317\u4eac\u4e2d\u4f01\u6613\u4ed8\u5546\u52a1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\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":4099,"from_project":3948,"is_outbound":true},"buildContract":{"id":4099,"from_project":3948,"is_outbound":true},"erp_profit_pct":60,"erp_j_profit_pct":40},{"id":3949,"client_id":2845,"project_status":3,"project_progress":6,"budget":"15340","profit_pct":"2.35","bargain_date":"2025-08-19","description":"","created_by":1001,"created_at":"2025-08-19 16:55:09","updated_at":"2025-08-22 15:54:38","engineer_id":"","project_title":"PA1410\u4e00\u5e74\u670d\u52a1","collected":"0","status_updated_at":"2025-08-19 17:45:00.090435+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-19 16:55:09.854722+08","forecast_updated_at":"2025-08-19 16:55:09.854722+08","end_at":"","pinyin_shortcut":"PA1410ynfw","creator":1011,"used_client":"","from_contact":5980,"total_contact_point":"","paid_contact_point":"","project_product_version_id":984,"is_sales_order_ready":true,"collected_plan":"15340","change_status_to":"","is_verify":false,"un_collected":15340,"id2":3949,"erp_cost_amount":"14573","erp_sales_amount":"15340","erp_use_amount":"0","erp_profit_amount":"767","erp_j_profit_amount":"767","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":4106,"from_project":3949,"is_outbound":true},"buildContract":{"id":4106,"from_project":3949,"is_outbound":true},"erp_profit_pct":5,"erp_j_profit_pct":5},{"id":3849,"client_id":2182,"project_status":3,"project_progress":9,"budget":"17500","profit_pct":"17.18","bargain_date":"2025-08-15","description":"","created_by":5300,"created_at":"2025-05-07 16:37:15","updated_at":"2025-08-25 14:35:33","engineer_id":"","project_title":"PA440\u7ef4\u4fdd-K-2025","collected":"17500","status_updated_at":"2025-08-15 16:20:27.019231+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-15 16:20:27.019231+08","forecast_updated_at":"2025-05-12 10:26:24.653635+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"PA440wbK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"1600","paid_contact_point":"","project_product_version_id":981,"is_sales_order_ready":true,"collected_plan":"17500","change_status_to":"","is_verify":false,"un_collected":0,"id2":3849,"erp_cost_amount":"11528","erp_sales_amount":"17500","erp_use_amount":"1600","erp_profit_amount":"5972","erp_j_profit_amount":"4372","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4094,"from_project":3849,"is_outbound":true},"buildContract":{"id":4094,"from_project":3849,"is_outbound":true},"erp_profit_pct":34.13,"erp_j_profit_pct":24.98},{"id":3939,"client_id":304,"project_status":3,"project_progress":6,"budget":"422844","profit_pct":"18.55","bargain_date":"2025-08-14","description":"","created_by":5295,"created_at":"2025-08-06 18:55:30","updated_at":"2025-08-29 14:48:59","engineer_id":"","project_title":"\u65b0\u8d2d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406","collected":"0","status_updated_at":"2025-08-14 11:57:38.48908+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-06 18:55:30.222384+08","forecast_updated_at":"2025-08-06 18:55:30.222384+08","end_at":"","pinyin_shortcut":"xgswxwgl","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1008,"is_sales_order_ready":true,"collected_plan":"422844","change_status_to":"","is_verify":false,"un_collected":422844,"id2":3939,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\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":4091,"from_project":3939,"is_outbound":false},"buildContract":{"id":4091,"from_project":3939,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3936,"client_id":2032,"project_status":3,"project_progress":9,"budget":"11779","profit_pct":"21.29","bargain_date":"2025-08-11","description":"","created_by":5295,"created_at":"2025-08-01 07:47:45","updated_at":"2025-08-22 15:59:53","engineer_id":"","project_title":"2025\u5e74\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","collected":"11779","status_updated_at":"2025-08-11 11:02:32.607523+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-11 11:02:32.607523+08","forecast_updated_at":"2025-08-01 07:47:45.056585+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"2025nswxwglsbxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"1000","paid_contact_point":"","project_product_version_id":979,"is_sales_order_ready":true,"collected_plan":"11779","change_status_to":"","is_verify":false,"un_collected":0,"id2":3936,"erp_cost_amount":"7304","erp_sales_amount":"11779","erp_use_amount":"0","erp_profit_amount":"4475","erp_j_profit_amount":"4475","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4086,"from_project":3936,"is_outbound":true},"buildContract":{"id":4086,"from_project":3936,"is_outbound":true},"erp_profit_pct":37.99,"erp_j_profit_pct":37.99},{"id":3940,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-08-07","description":"","created_by":5300,"created_at":"2025-08-07 10:20:57","updated_at":"2025-08-20 13:55:35","engineer_id":"","project_title":"POTJ25080879-\u56fa\u6001\u786c\u76d8-2025","collected":"598","status_updated_at":"2025-08-07 10:20:57.115303+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-07 10:20:57.115303+08","forecast_updated_at":"2025-08-07 10:20:57.115303+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"POTJ25080879gtyp2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":972,"is_sales_order_ready":true,"collected_plan":"598","change_status_to":"","is_verify":false,"un_collected":0,"id2":3940,"erp_cost_amount":"260","erp_sales_amount":"598","erp_use_amount":"0","erp_profit_amount":"338","erp_j_profit_amount":"338","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":4082,"from_project":3940,"is_outbound":true},"buildContract":{"id":4082,"from_project":3940,"is_outbound":true},"erp_profit_pct":56.52,"erp_j_profit_pct":56.52},{"id":3941,"client_id":12,"project_status":3,"project_progress":9,"budget":"299","profit_pct":"47.17","bargain_date":"2025-08-07","description":"","created_by":5300,"created_at":"2025-08-07 10:23:59","updated_at":"2025-08-20 13:54:39","engineer_id":"","project_title":"POTJ25081871-\u56fa\u6001\u786c\u76d8-2025","collected":"299","status_updated_at":"2025-08-07 10:23:59.770851+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-07 10:23:59.770851+08","forecast_updated_at":"2025-08-07 10:23:59.770851+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"POTJ25081871gtyp2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":971,"is_sales_order_ready":true,"collected_plan":"299","change_status_to":"","is_verify":false,"un_collected":0,"id2":3941,"erp_cost_amount":"130","erp_sales_amount":"299","erp_use_amount":"0","erp_profit_amount":"169","erp_j_profit_amount":"169","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":4083,"from_project":3941,"is_outbound":true},"buildContract":{"id":4083,"from_project":3941,"is_outbound":true},"erp_profit_pct":56.52,"erp_j_profit_pct":56.52},{"id":3931,"client_id":3384,"project_status":3,"project_progress":6,"budget":"300000","profit_pct":"5","bargain_date":"2025-08-05","description":"","created_by":1005,"created_at":"2025-07-27 23:30:12","updated_at":"2025-08-20 16:24:16","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u9879\u76ee","collected":"0","status_updated_at":"2025-08-20 11:29:52.139839+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 23:30:12.784553+08","forecast_updated_at":"2025-07-27 23:30:12.784553+08","end_at":"","pinyin_shortcut":"sxfswxwglxm","creator":1005,"used_client":"","from_contact":4844,"total_contact_point":"","paid_contact_point":"","project_product_version_id":986,"is_sales_order_ready":false,"collected_plan":"300000","change_status_to":"","is_verify":false,"un_collected":300000,"id2":3931,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3488,"client_id":93,"project_status":3,"project_progress":6,"budget":"545000","profit_pct":"13","bargain_date":"2025-07-31","description":"","created_by":1005,"created_at":"2024-03-31 22:49:26","updated_at":"2025-07-31 12:10:13","engineer_id":"","project_title":"\u591a\u56e0\u7d20\u8ba4\u8bc1-\u5b81\u76fe5000\u70b9","collected":"0","status_updated_at":"2025-07-31 11:45:20.419173+08","success_rate":"","comment":"\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u5e10\u53f7\u88ab\u52ab\u6301\uff0c\u5185\u90e8\u5458\u5de5\u88ab\u9a97\u94b1","contract_type":1,"progress_updated_at":"2024-08-26 07:49:48.430459+08","forecast_updated_at":"2024-08-26 07:49:48.430459+08","end_at":"","pinyin_shortcut":"dysrznd5000d","creator":1005,"used_client":"","from_contact":"","total_contact_point":"70000","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"545000","change_status_to":"","is_verify":false,"un_collected":545000,"id2":3488,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3935,"client_id":518,"project_status":3,"project_progress":6,"budget":"3450","profit_pct":"18.77","bargain_date":"2025-07-30","description":"","created_by":5295,"created_at":"2025-07-30 11:46:03","updated_at":"2025-08-28 10:12:02","engineer_id":"","project_title":"\u65b0\u8d2d\u9632\u706b\u5899SSL VPN\u6388\u6743","collected":"0","status_updated_at":"2025-07-30 21:47:27.040422+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-30 11:46:03.457029+08","forecast_updated_at":"2025-07-30 11:46:03.457029+08","end_at":"","pinyin_shortcut":"xgfhqSSLVPNsq","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":967,"is_sales_order_ready":true,"collected_plan":"3450","change_status_to":"","is_verify":false,"un_collected":3450,"id2":3935,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":4073,"from_project":3935,"is_outbound":true},"buildContract":{"id":4073,"from_project":3935,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3934,"client_id":3387,"project_status":3,"project_progress":9,"budget":"114632","profit_pct":"20","bargain_date":"2025-07-28","description":"","created_by":1005,"created_at":"2025-07-28 17:36:41","updated_at":"2025-09-03 16:40:42","engineer_id":"","project_title":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","collected":"0","status_updated_at":"2025-07-28 17:38:30.407066+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-28 17:36:41.35262+08","forecast_updated_at":"2025-07-28 17:36:41.35262+08","end_at":"","pinyin_shortcut":"hdjxxxaqxbxm2025n","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":966,"is_sales_order_ready":false,"collected_plan":"114632","change_status_to":"","is_verify":false,"un_collected":114632,"id2":3934,"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":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\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":4071,"from_project":3934,"is_outbound":false},"buildContract":{"id":4071,"from_project":3934,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3930,"client_id":12,"project_status":3,"project_progress":9,"budget":"299","profit_pct":"47.17","bargain_date":"2025-07-25","description":"","created_by":5300,"created_at":"2025-07-25 15:44:47","updated_at":"2025-07-31 13:08:55","engineer_id":"","project_title":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","collected":"299","status_updated_at":"2025-07-25 15:44:47.422414+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-25 15:44:47.422414+08","forecast_updated_at":"2025-07-25 15:44:47.422414+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"POTJ25078337gtyp2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":964,"is_sales_order_ready":true,"collected_plan":"299","change_status_to":"","is_verify":false,"un_collected":0,"id2":3930,"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":4068,"from_project":3930,"is_outbound":true},"buildContract":{"id":4068,"from_project":3930,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3928,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-07-24","description":"","created_by":5300,"created_at":"2025-07-24 13:27:15","updated_at":"2025-07-31 13:08:52","engineer_id":"","project_title":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","collected":"598","status_updated_at":"2025-07-24 13:27:15.878417+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-24 13:27:15.878417+08","forecast_updated_at":"2025-07-24 13:27:15.878417+08","end_at":"2025-08-11 16:58:01","pinyin_shortcut":"OTJ25077428gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":962,"is_sales_order_ready":true,"collected_plan":"598","change_status_to":"","is_verify":false,"un_collected":0,"id2":3928,"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":4064,"from_project":3928,"is_outbound":true},"buildContract":{"id":4064,"from_project":3928,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3929,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-07-24","description":"","created_by":5300,"created_at":"2025-07-24 13:29:19","updated_at":"2025-07-31 13:08:49","engineer_id":"","project_title":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","collected":"598","status_updated_at":"2025-07-24 13:31:12.133905+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-24 13:29:19.317641+08","forecast_updated_at":"2025-07-24 13:29:19.317641+08","end_at":"2025-08-11 16:57:55","pinyin_shortcut":"OTJ25077468gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":961,"is_sales_order_ready":true,"collected_plan":"598","change_status_to":"","is_verify":false,"un_collected":0,"id2":3929,"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":4065,"from_project":3929,"is_outbound":true},"buildContract":{"id":4065,"from_project":3929,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3924,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-07-21","description":"","created_by":5300,"created_at":"2025-07-21 10:18:07","updated_at":"2025-08-27 11:14:56","engineer_id":"","project_title":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","collected":"598","status_updated_at":"2025-07-21 10:19:01.388059+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 10:18:07.061698+08","forecast_updated_at":"2025-07-21 10:18:07.061698+08","end_at":"2025-08-11 16:58:22","pinyin_shortcut":"OTJ25076163gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":949,"is_sales_order_ready":true,"collected_plan":"598","change_status_to":"","is_verify":false,"un_collected":0,"id2":3924,"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":4049,"from_project":3924,"is_outbound":true},"buildContract":{"id":4049,"from_project":3924,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3925,"client_id":12,"project_status":3,"project_progress":9,"budget":"590","profit_pct":"26.22","bargain_date":"2025-07-21","description":"","created_by":5300,"created_at":"2025-07-21 10:21:43","updated_at":"2025-08-27 11:11:37","engineer_id":"","project_title":"OTJ25076289-\u5185\u5b58\u6761-G-2025","collected":"590","status_updated_at":"2025-07-21 10:21:43.366273+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 10:21:43.366273+08","forecast_updated_at":"2025-07-21 10:21:43.366273+08","end_at":"2025-08-11 16:58:17","pinyin_shortcut":"OTJ25076289nctG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":948,"is_sales_order_ready":true,"collected_plan":"590","change_status_to":"","is_verify":false,"un_collected":0,"id2":3925,"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":4050,"from_project":3925,"is_outbound":true},"buildContract":{"id":4050,"from_project":3925,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-22 09:55:12","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"348931.5","paid_contact_point":"365","project_product_version_id":951,"is_sales_order_ready":true,"collected_plan":"885300","change_status_to":"","is_verify":false,"un_collected":885300,"id2":3751,"erp_cost_amount":"384646.00","erp_sales_amount":"885299.98","erp_use_amount":"365.00","erp_profit_amount":"500653.98","erp_j_profit_amount":"500288.98","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":4055,"from_project":3751,"is_outbound":true},"buildContract":{"id":4055,"from_project":3751,"is_outbound":true},"erp_profit_pct":56.55,"erp_j_profit_pct":56.51},{"id":3926,"client_id":3383,"project_status":3,"project_progress":6,"budget":"840","profit_pct":"5.25","bargain_date":"2025-07-21","description":"","created_by":5295,"created_at":"2025-07-21 13:33:14","updated_at":"2025-08-20 17:56:04","engineer_id":"","project_title":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","collected":"840","status_updated_at":"2025-07-21 13:33:14.708949+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 13:33:14.708949+08","forecast_updated_at":"2025-07-21 13:33:14.708949+08","end_at":"2025-08-06 18:02:40","pinyin_shortcut":"xgjhjmkhxl","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":959,"is_sales_order_ready":true,"collected_plan":"840","change_status_to":"","is_verify":false,"un_collected":0,"id2":3926,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"49.45","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-08-31 22:44:49","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":987,"is_sales_order_ready":false,"collected_plan":"45500","change_status_to":"","is_verify":false,"un_collected":45500,"id2":3922,"erp_cost_amount":"18000.00","erp_sales_amount":"40000","erp_use_amount":"45.1","erp_profit_amount":"22000.00","erp_j_profit_amount":"21954.90","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4061,"from_project":3922,"is_outbound":false},"buildContract":{"id":4061,"from_project":3922,"is_outbound":false},"erp_profit_pct":55,"erp_j_profit_pct":54.89},{"id":3882,"client_id":2182,"project_status":3,"project_progress":49,"budget":"19427","profit_pct":"26.98","bargain_date":"2025-07-18","description":"","created_by":5300,"created_at":"2025-06-06 16:12:50","updated_at":"2025-08-27 11:36:43","engineer_id":"","project_title":"\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-K-2025","collected":"19427","status_updated_at":"2025-08-11 10:12:28.864923+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-11 10:12:28.864923+08","forecast_updated_at":"2025-08-11 10:12:28.864923+08","end_at":"2025-08-18 16:20:46","pinyin_shortcut":"hswlsbK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"3750","paid_contact_point":"","project_product_version_id":957,"is_sales_order_ready":true,"collected_plan":"19427","change_status_to":"","is_verify":false,"un_collected":0,"id2":3882,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4047,"from_project":3882,"is_outbound":true},"buildContract":{"id":4047,"from_project":3882,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3919,"client_id":2182,"project_status":3,"project_progress":49,"budget":"56862","profit_pct":"8.73","bargain_date":"2025-07-18","description":"","created_by":5300,"created_at":"2025-07-15 15:54:34","updated_at":"2025-08-27 11:26:18","engineer_id":"","project_title":"\u8054\u60f3\u7b14\u8bb0\u672c\u7535\u8111-K-2025","collected":"56862","status_updated_at":"2025-08-11 10:12:34.59619+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-11 10:12:34.59619+08","forecast_updated_at":"2025-08-11 10:12:34.59619+08","end_at":"2025-08-18 16:20:43","pinyin_shortcut":"lxbjbdnK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":956,"is_sales_order_ready":true,"collected_plan":"56862","change_status_to":"","is_verify":false,"un_collected":0,"id2":3919,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4048,"from_project":3919,"is_outbound":true},"buildContract":{"id":4048,"from_project":3919,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3957,"client_id":2130,"project_status":3,"project_progress":2,"budget":"20000000","profit_pct":"20","bargain_date":"2025-07-17","description":"","created_by":5087,"created_at":"2025-08-29 11:38:51","updated_at":"2025-09-04 10:01:21","engineer_id":"","project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","collected":"0","status_updated_at":"2025-09-04 10:01:21.2926+08","success_rate":"","comment":"\u9884\u7b972000\u4e07","contract_type":1,"progress_updated_at":"2025-08-29 11:38:51.97137+08","forecast_updated_at":"2025-08-29 11:38:51.97137+08","end_at":"","pinyin_shortcut":"zgrmjfjzcmbdwsyyjsszgcgxn","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"un_collected":20000000,"id2":3957,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","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":4132,"from_project":3957,"is_outbound":false},"buildContract":{"id":4132,"from_project":3957,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3883,"client_id":2182,"project_status":3,"project_progress":10,"budget":"50000","profit_pct":"85.5","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-06-06 16:59:28","updated_at":"2025-08-29 14:49:56","engineer_id":"","project_title":"\u673a\u623f\u642c\u8fc1-K-2025","collected":"15000","status_updated_at":"2025-07-17 11:46:30.969133+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2025-07-17 11:42:35.37025+08","forecast_updated_at":"2025-07-14 16:44:03.253398+08","end_at":"","pinyin_shortcut":"jfbqK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"3000","paid_contact_point":"","project_product_version_id":945,"is_sales_order_ready":true,"collected_plan":"50000","change_status_to":"","is_verify":false,"un_collected":35000,"id2":3883,"erp_cost_amount":"0","erp_sales_amount":"50000","erp_use_amount":"8870.27","erp_profit_amount":"50000","erp_j_profit_amount":"41129.73","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4044,"from_project":3883,"is_outbound":true},"buildContract":{"id":4044,"from_project":3883,"is_outbound":true},"erp_profit_pct":100,"erp_j_profit_pct":82.26},{"id":3917,"client_id":2182,"project_status":3,"project_progress":9,"budget":"5900","profit_pct":"15.69","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-07-14 16:50:51","updated_at":"2025-08-27 09:41:57","engineer_id":"","project_title":"\u5927\u534e\u76d1\u63a7\u8bbe\u5907\u65b0\u8d2d-K-2025","collected":"5900","status_updated_at":"2025-07-17 13:18:27.050361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-14 16:50:51.37712+08","forecast_updated_at":"2025-07-14 16:50:51.37712+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"dhjksbxgK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":968,"is_sales_order_ready":true,"collected_plan":"5900","change_status_to":"","is_verify":false,"un_collected":0,"id2":3917,"erp_cost_amount":"4700","erp_sales_amount":"5900","erp_use_amount":"0","erp_profit_amount":"1200","erp_j_profit_amount":"1200","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":4046,"from_project":3917,"is_outbound":true},"buildContract":{"id":4046,"from_project":3917,"is_outbound":true},"erp_profit_pct":20.34,"erp_j_profit_pct":20.34}],"pagenation":{"totalcount":162,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 16:19:53') RETURNING "id"
16:19:53.0571.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:19:53.0621.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:19:53.1180.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=195, "last_visit_at"='now()' WHERE "id"=56537
16:19:53.1090.7 msyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3959, 3796, 3854, 3878, 3880, 3955, 3945, 3956, 3927, 3953, 3950, 3947, 3951, 3948, 3949, 3849, 3939, 3936, 3940, 3941, 3931, 3488, 3935, 3934, 3930, 3928, 3929, 3924, 3925, 3751, 3926, 3922, 3882, 3919, 3957, 3883, 3917)
16:19:53.1080.6 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 1001, 5295, 5449, 5016, 1005, 5087, 5064, 5300, 1000))
16:19:53.1070.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1661, 2125, 2128, 3369, 2747, 2166, 1301, 2182, 3286, 12, 3389, 304, 2136, 3366, 2845, 2032, 3384, 93, 518, 3387, 2553, 3383, 2130)
16:19:53.1090.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4, 1)
16:19:53.1070.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 5449, 5300, 5295, 1000, 5016, 5064, 5250, 1005)