13:56:43.720 | 2.4 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/sales-year-data-list', '{"user_id":"","page":"1","period":"","project_status":"3","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"counts":[{"name":"\u9500\u552e\u5229\u6da6","key":"profits","value":6775.36,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u9500\u552e\u6d41\u6c34","key":"currents","value":35033.73,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u5408\u4f5c\u5ba2\u6237\u6570\/\u5546\u673a\u6570","key":"clients","value":335,"unit":"\u4e2a","valueEx":1459,"unitEx":"\u4e2a","color":"#98c450","link":[]},{"name":"\u5df2\u6536\u6b3e\/\u672a\u6536\u6b3e\u91d1\u989d","key":"payment","value":33048.5,"unit":"\u4e07","valueEx":1985.23,"unitEx":"\u4e07","color":"#e75a4a","link":[]},{"name":"\u5df2\u5f00\/\u672a\u5f00\u53d1\u7968\u91d1\u989d","key":"invoices","value":33342.35,"unit":"\u4e07","valueEx":900002313.29,"unitEx":"\u4e07","color":"#e75a4a","link":[]}],"list":[{"id":3809,"client_id":3304,"project_status":3,"project_progress":9,"budget":"1","profit_pct":"100","bargain_date":"2025-06-11","description":"","created_by":1001,"created_at":"2025-06-11 10:59:46","updated_at":"2025-06-27 14:39:02","engineer_id":"","project_title":"\u6d4b\u8bd5\u9ed8\u8ba4\u9009\u4e2d\u660e\u786e\u9700\u6c42","collected":"0","status_updated_at":"2025-06-11 11:06:41.464262+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-11 10:59:46.429638+08","forecast_updated_at":"2025-06-11 11:10:21.558113+08","end_at":"2025-06-11 11:10:21","pinyin_shortcut":"csmrxzmqxq","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"3000","remain":"24 days 02:50:02.182819","progress_remain":"24 days 02:56:57.217443","forecast_remain":"24 days 02:46:22.088968","profit":"1.00000000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"00:10:35.128475","issued_invoices":"","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1","pct":"100","profit":"1","project_id":3809}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3843,"from_project":3809,"payment_collection_remind_ahead":"1 day","serial_no":"TS-LRC-20250611001","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2382,"key":2382,"contract_id":3843,"name":"2025-06-11","value":"3000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":1,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":24,"progress_remain_display":24,"forecast_remain_display":24,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":1,"can_change_status":true,"budget_display":"1"},{"id":3808,"client_id":3304,"project_status":3,"project_progress":9,"budget":"0","profit_pct":"0","bargain_date":"2025-06-10","description":"","created_by":1001,"created_at":"2025-06-10 16:16:48","updated_at":"2025-06-11 11:03:55","engineer_id":"","project_title":"\u7684\u662f\u5426\u5730\u65b9\u6492","collected":"0","status_updated_at":"2025-06-10 16:16:48.920685+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-10 16:16:48.920685+08","forecast_updated_at":"2025-06-11 11:03:55.947909+08","end_at":"2025-06-11 11:03:55","pinyin_shortcut":"dsfdfs","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":811,"is_sales_order_ready":false,"collected_plan":"2000","remain":"24 days 21:39:54.726396","progress_remain":"24 days 21:39:54.726396","forecast_remain":"24 days 02:52:47.699172","profit":"0.00000000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"18:47:07.027224","issued_invoices":"","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3841,"from_project":3808,"payment_collection_remind_ahead":"1 day","serial_no":"","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2378,"key":2378,"contract_id":3841,"name":"2025-06-11","value":"2000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":24,"progress_remain_display":24,"forecast_remain_display":24,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":0,"can_change_status":true,"budget_display":"0"},{"id":3807,"client_id":3304,"project_status":3,"project_progress":9,"budget":"34000","profit_pct":"80","bargain_date":"2025-06-09","description":"","created_by":1001,"created_at":"2025-06-09 17:25:30","updated_at":"2025-06-11 11:23:11","engineer_id":"","project_title":"\u6d4b\u8bd5 \u4f3c\u61c2\u975e\u61c2\u8212\u670d\u8303\u5fb7\u8428\u4e0a","collected":"34000","status_updated_at":"2025-06-09 17:26:40.485552+08","success_rate":"","comment":"\u7ed9\u5927\u59d1","contract_type":1,"progress_updated_at":"2025-06-09 17:25:30.577264+08","forecast_updated_at":"2025-06-09 17:25:30.577264+08","end_at":"2025-06-09 18:05:34","pinyin_shortcut":"cssdfdsffdss","creator":1001,"used_client":"","from_contact":6006,"total_contact_point":"","paid_contact_point":"","project_product_version_id":812,"is_sales_order_ready":false,"collected_plan":"4222","remain":"25 days 20:30:03.161529","progress_remain":"25 days 20:31:13.069817","forecast_remain":"25 days 20:31:13.069817","profit":"27200.000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"00:40:04.063371","issued_invoices":"","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[{"project_id":3807,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"34000","pct":"80","profit":"27200","project_id":3807}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3840,"from_project":3807,"payment_collection_remind_ahead":"2 days","serial_no":"","salesContractPayments":[{"id":2162,"key":2162,"contract_id":3840,"value":"34000"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2398,"key":2398,"contract_id":3840,"name":"2025-06-11","value":"222","overdue_days":""},{"id":2399,"key":2399,"contract_id":3840,"name":"2025-06-12","value":"4000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":34000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":25,"progress_remain_display":25,"forecast_remain_display":25,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":27200,"can_change_status":true,"budget_display":"3.4\u4e07"},{"id":3804,"client_id":3056,"project_status":3,"project_progress":4,"budget":"0","profit_pct":"0","bargain_date":"2025-06-04","description":"","created_by":1013,"created_at":"2025-05-12 10:06:13","updated_at":"2025-07-03 11:38:45","engineer_id":"","project_title":"\u54c8\u62c9\u54c8\u5566","collected":"0","status_updated_at":"2025-06-11 11:06:35.306356+08","success_rate":"","comment":"\u4f60\u4f60\u4f60","contract_type":1,"progress_updated_at":"2025-05-12 10:06:13.745459+08","forecast_updated_at":"2025-06-11 11:06:57.741711+08","end_at":"2025-06-11 11:06:57","pinyin_shortcut":"hlhl","creator":1000,"used_client":"","from_contact":2782,"total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"2222","remain":"24 days 02:50:08.340725","progress_remain":"54 days 03:50:29.901622","forecast_remain":"24 days 02:49:45.90537","profit":"0.00000000000000000000","lost_contact_days":"54.1593709152894","last_contact":"2025-05-12 10:07:14","last_arrive_days":"54.1593709152894","last_arrive":"2025-05-12 10:07:14+08","duration":"30 days 01:00:43.996252","issued_invoices":"","client":{"id":3056,"key":3056,"name":"\u4e2d\u56fd\u822a\u5929","logo":"","client_type":5,"client_class":43,"client_industry":57,"sales_rep":1013,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":57,"key":57,"name":"EDA\/CAE"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848"},"projectProductTypes":[],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"salesTimeCount":{"project_id":3804,"hours":"0.00694444444444444","times":1},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3842,"from_project":3804,"payment_collection_remind_ahead":"1 day","serial_no":"","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2381,"key":2381,"contract_id":3842,"name":"2025-06-11","value":"2222","overdue_days":""}]},"lost_contact_days_display":"1\u4e2a\u6708\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":24,"progress_remain_display":54,"forecast_remain_display":24,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":0,"can_change_status":true,"budget_display":"0"},{"id":3806,"client_id":3300,"project_status":3,"project_progress":2,"budget":"700","profit_pct":"7","bargain_date":"2025-06-03","description":"","created_by":5087,"created_at":"2025-06-03 17:43:37","updated_at":"2025-06-03 17:43:37","engineer_id":"","project_title":"dddd","collected":"700","status_updated_at":"2025-06-03 17:43:37.36973+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-03 17:43:37.36973+08","forecast_updated_at":"2025-06-03 17:43:37.36973+08","end_at":"2025-06-03 17:46:44","pinyin_shortcut":"dddd","creator":5016,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","remain":"31 days 20:13:06.277351","progress_remain":"31 days 20:13:06.277351","forecast_remain":"31 days 20:13:06.277351","profit":"49.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"00:03:07.425555","issued_invoices":"","client":{"id":3300,"key":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09","logo":"","client_type":6,"client_class":43,"client_industry":5,"sales_rep":5087,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"700.00","pct":"7","profit":"49","project_id":3806}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3837,"from_project":3806,"payment_collection_remind_ahead":"1 day","serial_no":"","salesContractPayments":[{"id":2159,"key":2159,"contract_id":3837,"value":"46.95"},{"id":2160,"key":2160,"contract_id":3837,"value":"645.95"},{"id":2161,"key":2161,"contract_id":3837,"value":"7.10"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[]},"lost_contact_days_display":"","unissued_invoice":700,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":31,"progress_remain_display":31,"forecast_remain_display":31,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":49,"can_change_status":true,"budget_display":"700"},{"id":3461,"client_id":918,"project_status":3,"project_progress":4,"budget":"1000000","profit_pct":"20","bargain_date":"2025-06-03","description":"","created_by":1005,"created_at":"2024-03-04 09:39:05","updated_at":"2025-06-11 11:39:44","engineer_id":"","project_title":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee","collected":"0","status_updated_at":"2025-06-11 11:37:57.915375+08","success_rate":"","comment":"NETAPP FAS2800*2","contract_type":1,"progress_updated_at":"2024-08-05 11:15:13.353909+08","forecast_updated_at":"2025-06-11 11:39:44.02125+08","end_at":"","pinyin_shortcut":"sjbffahsyshyxm","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"12322","remain":"24 days 02:18:45.731706","progress_remain":"334 days 02:41:30.293172","forecast_remain":"24 days 02:16:59.625831","profit":"200000.000000000000","lost_contact_days":"296.914394063437","last_contact":"2024-09-11 16:00:00","last_arrive_days":"","last_arrive":"","duration":"488 days 04:17:38.06163","issued_invoices":"","client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":80,"client_industry":5,"sales_rep":1005,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3461,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1000000.00","pct":"20","profit":"200000","project_id":3461}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3461,"sum":"1.62722222222222","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3461,"sum":"249.95"},"buildContract":{"id":3845,"from_project":3461,"payment_collection_remind_ahead":"7 days","serial_no":"","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2410,"key":2410,"contract_id":3845,"name":"2025-06-11","value":"12322","overdue_days":""}]},"lost_contact_days_display":"9\u4e2a\u6708\u524d","unissued_invoice":1000000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":24,"progress_remain_display":334,"forecast_remain_display":24,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":200000,"can_change_status":true,"budget_display":"100\u4e07"},{"id":3796,"client_id":2125,"project_status":3,"project_progress":3,"budget":"790000","profit_pct":"25","bargain_date":"2025-04-13","description":"","created_by":5087,"created_at":"2025-03-09 10:00:35","updated_at":"2025-06-11 11:21:10","engineer_id":"","project_title":"deepseek\u79c1\u6709\u5316\u90e8\u7f72-239-K","collected":"0","status_updated_at":"2025-04-14 13:27:44.150927+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-03-09 10:00:35.131519+08","forecast_updated_at":"2025-06-11 11:21:10.662511+08","end_at":"","pinyin_shortcut":"deepseeksyhbs239K","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"3","remain":"82 days 00:28:59.496154","progress_remain":"118 days 03:56:08.515562","forecast_remain":"24 days 02:35:32.98457","profit":"197500.000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"118 days 03:56:08.515562","issued_invoices":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3796,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"790000.00","pct":"25","profit":"197500","project_id":3796}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3831,"from_project":3796,"payment_collection_remind_ahead":"1 day","serial_no":"","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2389,"key":2389,"contract_id":3831,"name":"2025-05-01","value":"1","overdue_days":""},{"id":2390,"key":2390,"contract_id":3831,"name":"2025-05-29","value":"2","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":790000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":82,"progress_remain_display":118,"forecast_remain_display":24,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":197500,"can_change_status":true,"budget_display":"79\u4e07"},{"id":3801,"client_id":3278,"project_status":3,"project_progress":9,"budget":"8000","profit_pct":"93.75","bargain_date":"2025-04-09","description":"\u6d4b\u8bd5","created_by":1001,"created_at":"2025-04-09 16:16:54","updated_at":"2025-06-11 15:29:06","engineer_id":"","project_title":"\u8d1f\u6570\u95ee\u9898","collected":"1","status_updated_at":"2025-06-11 11:14:46.224284+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-04-09 16:16:54.248165+08","forecast_updated_at":"2025-06-11 15:25:07.922296+08","end_at":"","pinyin_shortcut":"fswt","creator":1001,"used_client":"","from_contact":5934,"total_contact_point":"","paid_contact_point":"","project_product_version_id":808,"is_sales_order_ready":false,"collected_plan":"8000","remain":"24 days 02:41:57.422797","progress_remain":"86 days 21:39:49.398916","forecast_remain":"23 days 22:31:35.724785","profit":"7500.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"86 days 21:39:49.398916","issued_invoices":"","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[{"project_id":3801,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"8000","pct":"93.75","profit":"7500","project_id":3801}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3844,"from_project":3801,"payment_collection_remind_ahead":"","serial_no":"","salesContractPayments":[{"id":2163,"key":2163,"contract_id":3844,"value":"1"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2426,"key":2426,"contract_id":3844,"name":"2025-06-11","value":"4000","overdue_days":""},{"id":2427,"key":2427,"contract_id":3844,"name":"2025-06-19","value":"3000","overdue_days":""},{"id":2428,"key":2428,"contract_id":3844,"name":"2025-06-20","value":"1000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":8000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":24,"progress_remain_display":86,"forecast_remain_display":23,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":7500,"can_change_status":true,"budget_display":"8000"},{"id":3800,"client_id":2032,"project_status":3,"project_progress":4,"budget":"615615","profit_pct":"19.98","bargain_date":"2025-03-17","description":"","created_by":5295,"created_at":"2025-03-17 18:28:37","updated_at":"2025-06-28 17:41:05","engineer_id":"","project_title":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd","collected":"0","status_updated_at":"2025-04-11 11:00:39.617715+08","success_rate":"","comment":"\u6d4b\u8bd5\u9e3f\u8499","contract_type":1,"progress_updated_at":"2025-03-17 18:28:37.03026+08","forecast_updated_at":"2025-03-17 18:28:37.03026+08","end_at":"","pinyin_shortcut":"26nfhqxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":807,"is_sales_order_ready":false,"collected_plan":"","remain":"85 days 02:56:04.029366","progress_remain":"109 days 19:28:06.616821","forecast_remain":"109 days 19:28:06.616821","profit":"122999.877000000000","lost_contact_days":"109.91161628566","last_contact":"2025-03-17 16:04:00","last_arrive_days":"","last_arrive":"","duration":"109 days 19:28:06.616821","issued_invoices":"","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)","logo":"","client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848"},"projectProductTypes":[{"id":10,"product_type_id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","budget":"123123","pct":"0","profit":"0","project_id":3800},{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"246246","pct":"0","profit":"0","project_id":3800},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"123123","pct":"0","profit":"0","project_id":3800},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"123123","pct":"99.9","profit":"122999.877","project_id":3800}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3830,"from_project":3800,"payment_collection_remind_ahead":"","serial_no":"","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[]},"lost_contact_days_display":"3\u4e2a\u6708\u524d","unissued_invoice":615615,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":85,"progress_remain_display":109,"forecast_remain_display":109,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":122999.88,"can_change_status":true,"budget_display":"61.56\u4e07"},{"id":3793,"client_id":2736,"project_status":3,"project_progress":49,"budget":"2500","profit_pct":"93","bargain_date":"2025-03-10","description":"","created_by":5300,"created_at":"2025-03-06 16:53:08","updated_at":"2025-03-12 17:05:47","engineer_id":"","project_title":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025","collected":"0","status_updated_at":"2025-03-10 10:17:21.455459+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2025-03-10 10:17:21.455459+08","forecast_updated_at":"2025-03-10 10:17:21.455459+08","end_at":"","pinyin_shortcut":"fhqgzczhzlG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":805,"is_sales_order_ready":true,"collected_plan":"2500","remain":"117 days 03:39:22.191622","progress_remain":"117 days 03:39:22.191622","forecast_remain":"117 days 03:39:22.191622","profit":"2325.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"120 days 21:03:35.353371","issued_invoices":"2501.00","client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":5300,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d"},"projectProductTypes":[{"id":16,"product_type_id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1","budget":"2500.00","pct":"93","profit":"2325","project_id":3793}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3822,"from_project":3793,"payment_collection_remind_ahead":"7 days","serial_no":"","salesContractPayments":[],"salesContractInvoices":[{"id":1973,"key":1973,"contract_id":3822,"value":"2500.00","attachment_id":"","from_date":"2025-03-10","attachment":{}},{"id":1987,"key":1987,"contract_id":3822,"value":"1.00","attachment_id":"","from_date":"2025-05-22","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2357,"key":2357,"contract_id":3822,"name":"2025-04-21","value":"2500","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":-1,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":117,"progress_remain_display":117,"forecast_remain_display":117,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","currents":2325,"can_change_status":true,"budget_display":"2500"},{"id":3794,"client_id":12,"project_status":3,"project_progress":10,"budget":"511","profit_pct":"41.41","bargain_date":"2025-03-06","description":"","created_by":5300,"created_at":"2025-03-06 19:44:56","updated_at":"2025-03-14 17:29:51","engineer_id":"","project_title":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","status_updated_at":"2025-03-06 19:44:56.587928+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-03-06 19:44:56.587928+08","forecast_updated_at":"2025-03-06 19:44:56.587928+08","end_at":"","pinyin_shortcut":"POBJ25031110gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":800,"is_sales_order_ready":true,"collected_plan":"511","remain":"120 days 18:11:47.059153","progress_remain":"120 days 18:11:47.059153","forecast_remain":"120 days 18:11:47.059153","profit":"211.6051000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"120 days 18:11:47.059153","issued_invoices":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":5,"sales_rep":5300,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"511.00","pct":"41.41","profit":"211.6051","project_id":3794}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3816,"from_project":3794,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25031110","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2356,"key":2356,"contract_id":3816,"name":"2025-04-18","value":"511","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":511,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":120,"progress_remain_display":120,"forecast_remain_display":120,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":211.61,"can_change_status":true,"budget_display":"511"},{"id":3792,"client_id":20,"project_status":3,"project_progress":10,"budget":"500","profit_pct":"32.8","bargain_date":"2025-03-06","description":"","created_by":1005,"created_at":"2025-03-06 09:00:53","updated_at":"2025-03-10 10:06:20","engineer_id":"","project_title":"IBM\u7535\u6e90\u66f4\u6362","collected":"0","status_updated_at":"2025-03-06 09:01:21.45594+08","success_rate":"","comment":"3650M5 750w \u7535\u6e90","contract_type":1,"progress_updated_at":"2025-03-06 09:00:53.886185+08","forecast_updated_at":"2025-03-06 09:00:53.886185+08","end_at":"","pinyin_shortcut":"IBMdygh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":794,"is_sales_order_ready":true,"collected_plan":"","remain":"121 days 04:55:22.191141","progress_remain":"121 days 04:55:49.760896","forecast_remain":"121 days 04:55:49.760896","profit":"164.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"121 days 04:55:49.760896","issued_invoices":"500.00","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)","logo":"","client_type":6,"client_class":80,"client_industry":5,"sales_rep":1005,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"500.00","pct":"32.8","profit":"164","project_id":3792}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3812,"from_project":3792,"payment_collection_remind_ahead":"00:00:00","serial_no":"","salesContractPayments":[],"salesContractInvoices":[{"id":1965,"key":1965,"contract_id":3812,"value":"500.00","attachment_id":"","from_date":"2025-03-06","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2354,"key":2354,"contract_id":3812,"name":"2025-04-06","value":"500","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":121,"progress_remain_display":121,"forecast_remain_display":121,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":164,"can_change_status":true,"budget_display":"500"},{"id":3791,"client_id":531,"project_status":3,"project_progress":10,"budget":"3150","profit_pct":"16.97","bargain_date":"2025-03-05","description":"","created_by":5300,"created_at":"2025-03-05 17:28:13","updated_at":"2025-03-10 18:56:54","engineer_id":"","project_title":"\u786c\u76d81.8T1\u5757-K-2025","collected":"3150","status_updated_at":"2025-03-05 17:28:13.558795+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-03-05 17:28:13.558795+08","forecast_updated_at":"2025-03-05 17:28:13.558795+08","end_at":"2025-03-10 11:16:35","pinyin_shortcut":"yp18T1kK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"880","paid_contact_point":"880","project_product_version_id":797,"is_sales_order_ready":true,"collected_plan":"3150","remain":"121 days 20:28:30.088286","progress_remain":"121 days 20:28:30.088286","forecast_remain":"121 days 20:28:30.088286","profit":"534.5550000000000000","lost_contact_days":"121.831060730104","last_contact":"2025-03-05 18:00:00","last_arrive_days":"","last_arrive":"","duration":"4 days 17:48:21.535363","issued_invoices":"3150.00","client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":"","client_type":5,"client_class":43,"client_industry":9,"sales_rep":5311,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":9,"key":9,"name":"\u5730\u4ea7"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"3150.00","pct":"16.97","profit":"534.555","project_id":3791}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3811,"from_project":3791,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-SQY-20250305001","salesContractPayments":[{"id":2131,"key":2131,"contract_id":3811,"value":"3150"}],"salesContractInvoices":[{"id":1971,"key":1971,"contract_id":3811,"value":"3150.00","attachment_id":"","from_date":"2025-03-07","attachment":{}},{"id":1978,"key":1978,"contract_id":3811,"value":"-3150.00","attachment_id":"","from_date":"2025-03-14","attachment":{}},{"id":1979,"key":1979,"contract_id":3811,"value":"3150.00","attachment_id":"","from_date":"2025-03-14","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2353,"key":2353,"contract_id":3811,"name":"2025-03-21","value":"3150","overdue_days":""}]},"lost_contact_days_display":"3\u4e2a\u6708\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":121,"progress_remain_display":121,"forecast_remain_display":121,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":534.56,"can_change_status":true,"budget_display":"3150"},{"id":3769,"client_id":3326,"project_status":3,"project_progress":10,"budget":"32000","profit_pct":"93","bargain_date":"2025-03-05","description":"","created_by":5087,"created_at":"2025-01-21 13:13:23","updated_at":"2025-03-05 10:15:34","engineer_id":"","project_title":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","collected":"32000","status_updated_at":"2025-01-21 15:45:00.954677+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-01-21 13:13:23.709966+08","forecast_updated_at":"2025-01-21 13:13:23.709966+08","end_at":"2025-02-10 13:25:13","pinyin_shortcut":"xcwgzjfwf","creator":5087,"used_client":2130,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":769,"is_sales_order_ready":true,"collected_plan":"32000","remain":"164 days 22:11:42.692404","progress_remain":"165 days 00:43:19.937115","forecast_remain":"165 days 00:43:19.937115","profit":"29760.000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"20 days 00:11:49.568234","issued_invoices":"32000.00","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":5087,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"32000.00","pct":"93","profit":"29760","project_id":3769}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3770,"from_project":3769,"payment_collection_remind_ahead":"1 day","serial_no":"TS-LW-20250305001","salesContractPayments":[{"id":2104,"key":2104,"contract_id":3770,"value":"32000"}],"salesContractInvoices":[{"id":1945,"key":1945,"contract_id":3770,"value":"32000.00","attachment_id":"","from_date":"2025-01-21","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2325,"key":2325,"contract_id":3770,"name":"2025-04-30","value":"32000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":164,"progress_remain_display":165,"forecast_remain_display":165,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":29760,"can_change_status":true,"budget_display":"3.2\u4e07"},{"id":3789,"client_id":4,"project_status":3,"project_progress":9,"budget":"1700","profit_pct":"33.82","bargain_date":"2025-03-04","description":"","created_by":5300,"created_at":"2025-03-04 10:28:11","updated_at":"2025-03-10 10:11:32","engineer_id":"","project_title":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","collected":"1700","status_updated_at":"2025-03-05 14:27:35.453201+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-03-04 10:28:11.213084+08","forecast_updated_at":"2025-03-04 10:28:11.213084+08","end_at":"2025-03-06 17:01:07","pinyin_shortcut":"dynetappFAS22402kG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":796,"is_sales_order_ready":true,"collected_plan":"22","remain":"121 days 23:29:08.19388","progress_remain":"123 days 03:28:32.433997","forecast_remain":"123 days 03:28:32.433997","profit":"574.9400000000000000","lost_contact_days":"123.122727396771","last_contact":"2025-03-04 11:00:00","last_arrive_days":"","last_arrive":"","duration":"2 days 06:32:56.107432","issued_invoices":"1700.00","client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":17,"sales_rep":5300,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":17,"key":17,"name":"\u96f6\u552e"}},"projectArchitects":[{"project_id":3789,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1700.00","pct":"33.82","profit":"574.94","project_id":3789}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3809,"from_project":3789,"payment_collection_remind_ahead":"1 day","serial_no":"TS-SQY-20250304002","salesContractPayments":[{"id":2126,"key":2126,"contract_id":3809,"value":"1700"}],"salesContractInvoices":[{"id":1966,"key":1966,"contract_id":3809,"value":"1700.00","attachment_id":"","from_date":"2025-03-06","attachment":{}},{"id":1967,"key":1967,"contract_id":3809,"value":"-1700.00","attachment_id":"","from_date":"2025-03-06","attachment":{}},{"id":1970,"key":1970,"contract_id":3809,"value":"1700.00","attachment_id":"","from_date":"2025-03-06","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2395,"key":2395,"contract_id":3809,"name":"2025-04-05","value":"22","overdue_days":""}]},"lost_contact_days_display":"4\u4e2a\u6708\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":121,"progress_remain_display":123,"forecast_remain_display":123,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":574.94,"can_change_status":true,"budget_display":"1700"},{"id":3788,"client_id":518,"project_status":3,"project_progress":4,"budget":"1200","profit_pct":"27","bargain_date":"2025-03-03","description":"","created_by":5295,"created_at":"2025-03-03 17:13:54","updated_at":"2025-03-11 13:25:18","engineer_id":"","project_title":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","collected":"0","status_updated_at":"2025-03-03 17:13:54.696693+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-03-03 17:13:54.696693+08","forecast_updated_at":"2025-03-03 17:13:54.696693+08","end_at":"","pinyin_shortcut":"xgfwqyp","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":791,"is_sales_order_ready":true,"collected_plan":"","remain":"123 days 20:42:48.950388","progress_remain":"123 days 20:42:48.950388","forecast_remain":"123 days 20:42:48.950388","profit":"324.0000000000000000","lost_contact_days":"123.953282952326","last_contact":"2025-03-03 15:04:00","last_arrive_days":"","last_arrive":"","duration":"123 days 20:42:48.950388","issued_invoices":"1200.00","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","logo":"","client_type":1,"client_class":80,"client_industry":57,"sales_rep":5295,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":57,"key":57,"name":"EDA\/CAE"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1200.00","pct":"27","profit":"324","project_id":3788}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3805,"from_project":3788,"payment_collection_remind_ahead":"00:00:00","serial_no":"","salesContractPayments":[],"salesContractInvoices":[{"id":1977,"key":1977,"contract_id":3805,"value":"1200.00","attachment_id":"","from_date":"2025-03-11","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2348,"key":2348,"contract_id":3805,"name":"2025-04-30","value":"1200","overdue_days":""}]},"lost_contact_days_display":"4\u4e2a\u6708\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":123,"progress_remain_display":123,"forecast_remain_display":123,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":324,"can_change_status":true,"budget_display":"1200"},{"id":3786,"client_id":3334,"project_status":3,"project_progress":9,"budget":"3593747","profit_pct":"1.7","bargain_date":"2025-02-28","description":"","created_by":1001,"created_at":"2025-02-28 16:22:00","updated_at":"2025-07-04 14:19:12","engineer_id":"","project_title":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","collected":"-1","status_updated_at":"2025-02-28 16:22:00.848979+08","success_rate":"","comment":"\u7d2b\u5149\u6768\u534e\u63a8\u8350","contract_type":1,"progress_updated_at":"2025-02-28 16:22:00.848979+08","forecast_updated_at":"2025-04-08 14:42:27.53319+08","end_at":"","pinyin_shortcut":"yjrjgcjkcp","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":788,"is_sales_order_ready":true,"collected_plan":"3048205","remain":"126 days 21:34:42.798102","progress_remain":"126 days 21:34:42.798102","forecast_remain":"87 days 23:14:16.113891","profit":"61093.699000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"126 days 21:34:42.798102","issued_invoices":"","client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"3048204","pct":"1.99","profit":"60964","project_id":3786},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"545543","pct":"0.1","profit":"547","project_id":3786}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3786,"sum":"","times":""},"presalesTimeCount":{"project_id":3786,"sum":"","times":""},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3803,"from_project":3786,"payment_collection_remind_ahead":"","serial_no":"TSKJ20250228-LRC-001","salesContractPayments":[{"id":2156,"key":2156,"contract_id":3803,"value":"-1"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2396,"key":2396,"contract_id":3803,"name":"2025-03-31","value":"3048204","overdue_days":""},{"id":2397,"key":2397,"contract_id":3803,"name":"2025-06-11","value":"1","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":3593747,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":126,"progress_remain_display":126,"forecast_remain_display":87,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":61093.7,"can_change_status":true,"budget_display":"359.37\u4e07"},{"id":3782,"client_id":12,"project_status":3,"project_progress":9,"budget":"629","profit_pct":"11.69","bargain_date":"2025-02-24","description":"","created_by":5300,"created_at":"2025-02-24 11:45:40","updated_at":"2025-02-28 10:24:15","engineer_id":"","project_title":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","status_updated_at":"2025-02-24 11:47:13.994522+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-02-24 11:45:40.485904+08","forecast_updated_at":"2025-02-24 11:45:40.485904+08","end_at":"","pinyin_shortcut":"POBJ25024486gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":782,"is_sales_order_ready":true,"collected_plan":"629","remain":"131 days 02:09:29.652559","progress_remain":"131 days 02:11:03.161177","forecast_remain":"131 days 02:11:03.161177","profit":"73.5301000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"131 days 02:11:03.161177","issued_invoices":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":5,"sales_rep":5300,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"629.00","pct":"11.69","profit":"73.5301","project_id":3782}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3792,"from_project":3782,"payment_collection_remind_ahead":"7 days","serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25024486","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2339,"key":2339,"contract_id":3792,"name":"2025-04-11","value":"629","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":629,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":131,"progress_remain_display":131,"forecast_remain_display":131,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":73.53,"can_change_status":true,"budget_display":"629"},{"id":3771,"client_id":3281,"project_status":3,"project_progress":9,"budget":"5869.5","profit_pct":"12.79","bargain_date":"2025-02-24","description":"","created_by":5295,"created_at":"2025-01-23 21:10:43","updated_at":"2025-03-10 16:26:50","engineer_id":"","project_title":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9","collected":"5869.5","status_updated_at":"2025-02-24 11:10:34.858323+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-01-23 21:10:43.3391+08","forecast_updated_at":"2025-02-17 17:46:10.338453+08","end_at":"2025-02-28 16:52:03","pinyin_shortcut":"krss1tjsjd","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":799,"is_sales_order_ready":true,"collected_plan":"5869.5","remain":"131 days 02:46:08.788758","progress_remain":"162 days 16:46:00.307981","forecast_remain":"137 days 20:10:33.308628","profit":"750.7090500000000000","lost_contact_days":"163.035921841215","last_contact":"2025-01-23 13:05:00","last_arrive_days":"","last_arrive":"","duration":"35 days 19:41:19.709997","issued_invoices":"","client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","logo":"","client_type":5,"client_class":47,"client_industry":57,"sales_rep":5295,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":57,"key":57,"name":"EDA\/CAE"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"5869.5","pct":"12.79","profit":"750.70905","project_id":3771}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3791,"from_project":3771,"payment_collection_remind_ahead":"1 day","serial_no":"TS-WZW-2025012003","salesContractPayments":[{"id":2118,"key":2118,"contract_id":3791,"value":"5869.5"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2338,"key":2338,"contract_id":3791,"name":"2025-04-30","value":"5869.5","overdue_days":""}]},"lost_contact_days_display":"5\u4e2a\u6708\u524d","unissued_invoice":5869.5,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":131,"progress_remain_display":162,"forecast_remain_display":137,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":750.71,"can_change_status":true,"budget_display":"5869.5"},{"id":3785,"client_id":2546,"project_status":3,"project_progress":9,"budget":"10800","profit_pct":"11.25","bargain_date":"2025-02-21","description":"","created_by":5295,"created_at":"2025-02-27 10:13:36","updated_at":"2025-03-04 10:14:47","engineer_id":"","project_title":"2025\u65b0\u8d2dUPS","collected":"0","status_updated_at":"2025-02-27 10:14:14.360236+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-02-27 10:13:36.827753+08","forecast_updated_at":"2025-02-27 10:13:36.827753+08","end_at":"","pinyin_shortcut":"2025xgUPS","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":787,"is_sales_order_ready":true,"collected_plan":"","remain":"128 days 03:42:29.286845","progress_remain":"128 days 03:43:06.819328","forecast_remain":"128 days 03:43:06.819328","profit":"1215.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"128 days 03:43:06.819328","issued_invoices":"","client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":5295,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":14,"product_type_id":14,"key":14,"name":"UPS","budget":"10800.00","pct":"11.25","profit":"1215","project_id":3785}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3797,"from_project":3785,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2025022101","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2346,"key":2346,"contract_id":3797,"name":"2025-04-15","value":"10800","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":10800,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":128,"progress_remain_display":128,"forecast_remain_display":128,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":1215,"can_change_status":true,"budget_display":"1.08\u4e07"}],"thisUser":"","can_create":true,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":1459,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 13:56:43') RETURNING "id" |