ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6895c7ce278d6: POST https://beta.jinchangxiao.com/vue/analysis/sales-year-data-list at 2025-08-08 05:47:58 pm by 124.64.23.198

Performance Profiling

Total processing time: 205 ms; Peak memory: 7.034 MB. Show Profiling Timeline

总计43条数据
TimeDurationCategoryInfo
  
17:47:58.21734.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, (p.budget * p.profit_pct / 100) as profit, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND ("p"."project_status"='3') AND ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:47:58.25232.4 msyii\db\Command::querySELECT p.*, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, (p.budget * p.profit_pct / 100) as profit, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND ("p"."project_status"='3') AND ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
17:47:58.30415.7 msyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)) GROUP BY "c"."project_id"
17:47:58.3484.3 msyii\db\Command::querySELECT sum(sub.invoices) as invoices FROM (SELECT sc.id, CASE WHEN sc.including_tax = false or sum(sci.amount) > sc.amount THEN 0 ELSE sc.amount - (CASE WHEN SUM ( sci.amount ) IS NOT NULL THEN SUM ( sci.amount ) ELSE 0 END) END as invoices FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("sc"."including_tax"=TRUE) GROUP BY "sc"."id") "sub"
17:47:58.3214.2 msyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)) GROUP BY "c"."project_id"
17:47:58.3543.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-08')
17:47:58.3603.6 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/analysis/sales-year-data-list', '{"user_id":"","page":"1","period":"","project_status":"3","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"counts":[{"name":"\u9500\u552e\u5229\u6da6","key":"profits","value":7075.75,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u9500\u552e\u6d41\u6c34","key":"currents","value":36216.93,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u5408\u4f5c\u5ba2\u6237\u6570\/\u5546\u673a\u6570","key":"clients","value":351,"unit":"\u4e2a","valueEx":1550,"unitEx":"\u4e2a","color":"#98c450","link":[]},{"name":"\u5df2\u6536\u6b3e\/\u672a\u6536\u6b3e\u91d1\u989d","key":"payment","value":34844.38,"unit":"\u4e07","valueEx":1372.56,"unitEx":"\u4e07","color":"#e75a4a","link":[]},{"name":"\u5df2\u5f00\/\u672a\u5f00\u53d1\u7968\u91d1\u989d","key":"invoices","value":35274,"unit":"\u4e07","valueEx":1508.55,"unitEx":"\u4e07","color":"#e75a4a","link":[]}],"list":[{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"60000","profit_pct":"99.33","bargain_date":"2025-08-05","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-08-08 13:55:45","engineer_id":"","project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-05 17:19:18.559826+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-08-08 13:55:45.64593+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"","paid_contact_point":"","project_product_version_id":966,"is_sales_order_ready":false,"collected_plan":"345","change_status_to":"","is_verify":false,"remain":"3 days 00:28:39.693627","progress_remain":"17 days 06:42:35.028739","forecast_remain":"03:52:12.607523","profit":"59598.000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"17 days 06:42:35.028739","issued_invoices":"","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\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":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"60000","pct":"99.33","profit":"59600","project_id":3927}],"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":4075,"from_project":3927,"payment_collection_remind_ahead":"1 day","serial_no":"","erp_settle_amount":"1","salesContractPayments":[{"id":"11996","key":"11996","contract_id":4075,"value":"1"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2548,"key":2548,"contract_id":4075,"name":"2025-08-08","value":"123","overdue_days":""},{"id":2549,"key":2549,"contract_id":4075,"name":"2025-08-09","value":"222","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":60000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":3,"progress_remain_display":17,"forecast_remain_display":0,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":59598,"can_change_status":true,"budget_display":"6\u4e07"},{"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-08-06 15:44:42","engineer_id":"","project_title":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","collected":"4","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":"","is_sales_order_ready":true,"collected_plan":"114632","change_status_to":"","is_verify":false,"remain":"11 days 00:09:27.846387","progress_remain":"11 days 00:11:16.900833","forecast_remain":"11 days 00:11:16.900833","profit":"22926.400000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"11 days 00:11:16.900833","issued_invoices":"2.00","client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005,"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":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"114632","pct":"20","profit":"22926.4","project_id":3934}],"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":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":4071,"from_project":3934,"payment_collection_remind_ahead":"1 day","serial_no":"","erp_settle_amount":"4","salesContractPayments":[{"id":"11995","key":"11995","contract_id":4071,"value":"1"},{"id":"11994","key":"11994","contract_id":4071,"value":"3"}],"salesContractInvoices":[{"id":2107,"key":2107,"contract_id":4071,"value":"1.00","attachment_id":"","from_date":"2025-08-04","attachment":{}},{"id":2108,"key":2108,"contract_id":4071,"value":"1.00","attachment_id":"","from_date":"2025-08-04","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2543,"key":2543,"contract_id":4071,"name":"2025-09-28","value":"57316","overdue_days":""},{"id":2544,"key":2544,"contract_id":4071,"name":"2025-09-30","value":"34389","overdue_days":""},{"id":2545,"key":2545,"contract_id":4071,"name":"2026-01-31","value":"22927","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":114630,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":11,"progress_remain_display":11,"forecast_remain_display":11,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":22926.4,"can_change_status":true,"budget_display":"11.46\u4e07"},{"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-28 17:55:50","engineer_id":"","project_title":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","collected":"0","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":"","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,"remain":"14 days 02:03:10.831039","progress_remain":"14 days 02:03:10.831039","forecast_remain":"14 days 02:03:10.831039","profit":"141.0383000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"14 days 02:03:10.831039","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":"299","pct":"47.17","profit":"141.03","project_id":3930}],"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":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":4068,"from_project":3930,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25POTJ25078337","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2529,"key":2529,"contract_id":4068,"name":"2025-08-31","value":"299","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":299,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":14,"progress_remain_display":14,"forecast_remain_display":14,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":141.04,"can_change_status":true,"budget_display":"299"},{"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-28 10:03:03","engineer_id":"","project_title":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","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":"","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,"remain":"15 days 04:16:46.119548","progress_remain":"15 days 04:18:38.935812","forecast_remain":"15 days 04:18:38.935812","profit":"282.0766000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"15 days 04:18:38.935812","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":"598","pct":"47.17","profit":"282.07","project_id":3929}],"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":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":4065,"from_project":3929,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25POTJ25077468","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2525,"key":2525,"contract_id":4065,"name":"2025-08-31","value":"598","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":598,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":15,"progress_remain_display":15,"forecast_remain_display":15,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":282.08,"can_change_status":true,"budget_display":"598"},{"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-28 10:03:28","engineer_id":"","project_title":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","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":"","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,"remain":"15 days 04:20:42.375036","progress_remain":"15 days 04:20:42.375036","forecast_remain":"15 days 04:20:42.375036","profit":"282.0766000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"15 days 04:20:42.375036","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":"598","pct":"47.17","profit":"282.07","project_id":3928}],"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":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":4064,"from_project":3928,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25POTJ25077428","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2524,"key":2524,"contract_id":4064,"name":"2025-08-31","value":"598","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":598,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":15,"progress_remain_display":15,"forecast_remain_display":15,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":282.08,"can_change_status":true,"budget_display":"598"},{"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-07-28 10:05:16","engineer_id":"","project_title":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","collected":"0","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":"","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,"remain":"18 days 04:14:43.544504","progress_remain":"18 days 04:14:43.544504","forecast_remain":"18 days 04:14:43.544504","profit":"44.1000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"18 days 04:14:43.544504","issued_invoices":"","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","logo":"","client_type":5,"client_class":80,"client_industry":20,"sales_rep":5295,"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":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"840","pct":"5.25","profit":"44.1","project_id":3926}],"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":4054,"from_project":3926,"payment_collection_remind_ahead":"1 day","serial_no":"TS-WZW-20250721-01","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2523,"key":2523,"contract_id":4054,"name":"2025-08-31","value":"840","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":840,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":18,"progress_remain_display":18,"forecast_remain_display":18,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":44.1,"can_change_status":true,"budget_display":"840"},{"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-07-28 10:09:23","engineer_id":"","project_title":"OTJ25076289-\u5185\u5b58\u6761-G-2025","collected":"0","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":"","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,"remain":"18 days 07:26:14.88718","progress_remain":"18 days 07:26:14.88718","forecast_remain":"18 days 07:26:14.88718","profit":"154.6980000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"18 days 07:26:14.88718","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":"590","pct":"26.22","profit":"154.69","project_id":3925}],"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":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":4050,"from_project":3925,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076289","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2511,"key":2511,"contract_id":4050,"name":"2025-08-29","value":"590","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":590,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":18,"progress_remain_display":18,"forecast_remain_display":18,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":154.7,"can_change_status":true,"budget_display":"590"},{"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-07-28 10:10:52","engineer_id":"","project_title":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","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":"","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,"remain":"18 days 07:28:56.865394","progress_remain":"18 days 07:29:51.191755","forecast_remain":"18 days 07:29:51.191755","profit":"282.0766000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"18 days 07:29:51.191755","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":"598","pct":"47.17","profit":"282.07","project_id":3924}],"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":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":4049,"from_project":3924,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076163","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2510,"key":2510,"contract_id":4049,"name":"2025-08-29","value":"598","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":598,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":18,"progress_remain_display":18,"forecast_remain_display":18,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":282.08,"can_change_status":true,"budget_display":"598"},{"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-07 12:11:41","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":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","change_status_to":"","is_verify":false,"remain":"14 days 06:07:35.017395","progress_remain":"14 days 06:07:35.017395","forecast_remain":"227 days 01:57:11.509046","profit":"24257.220000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"227 days 01:57:11.509046","issued_invoices":"","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\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":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"885300","pct":"2.74","profit":"24257.22","project_id":3751}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":182,"key":182,"name":"\u56f4\u6807"},"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":4055,"from_project":3751,"payment_collection_remind_ahead":"1 day","serial_no":"","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2526,"key":2526,"contract_id":4055,"name":"2025-08-22","value":"619710","overdue_days":""},{"id":2527,"key":2527,"contract_id":4055,"name":"2025-09-12","value":"177060","overdue_days":""},{"id":2528,"key":2528,"contract_id":4055,"name":"2026-07-31","value":"88530","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":885300,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":14,"progress_remain_display":14,"forecast_remain_display":227,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":24257.22,"can_change_status":true,"budget_display":"88.53\u4e07"},{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","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":965,"is_sales_order_ready":false,"collected_plan":"45500","change_status_to":"","is_verify":false,"remain":"12 days 03:41:24.707531","progress_remain":"12 days 03:41:24.707531","forecast_remain":"12 days 03:41:24.707531","profit":"15497.300000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"19 days 03:03:44.767581","issued_invoices":"","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","logo":"","client_type":6,"client_class":47,"client_industry":5,"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":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3922,"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":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"45500","pct":"34.06","profit":"15500","project_id":3922}],"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":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":4061,"from_project":3922,"payment_collection_remind_ahead":"15 days","serial_no":"","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2521,"key":2521,"contract_id":4061,"name":"2025-09-29","value":"4550","overdue_days":""},{"id":2519,"key":2519,"contract_id":4061,"name":"2025-09-30","value":"13650","overdue_days":""},{"id":2520,"key":2520,"contract_id":4061,"name":"2025-11-30","value":"27300","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":45500,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":12,"progress_remain_display":12,"forecast_remain_display":12,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":15497.3,"can_change_status":true,"budget_display":"4.55\u4e07"},{"id":3919,"client_id":2182,"project_status":3,"project_progress":9,"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-07-28 10:14:05","engineer_id":"","project_title":"\u8054\u60f3\u7b14\u8bb0\u672c\u7535\u8111-K-2025","collected":"0","status_updated_at":"2025-07-18 21:50:05.084131+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-15 15:54:34.078507+08","forecast_updated_at":"2025-07-15 15:54:34.078507+08","end_at":"","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,"remain":"20 days 19:57:53.169322","progress_remain":"24 days 01:53:24.174946","forecast_remain":"24 days 01:53:24.174946","profit":"4964.0526000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"24 days 01:53:24.174946","issued_invoices":"","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"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":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":12,"product_type_id":12,"key":12,"name":"\u7b14\u8bb0\u672c","budget":"56862","pct":"8.73","profit":"4964.05","project_id":3919}],"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":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":4048,"from_project":3919,"payment_collection_remind_ahead":"1 day","serial_no":"PO-2025-07-0011","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2509,"key":2509,"contract_id":4048,"name":"2025-08-29","value":"56862","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":56862,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":20,"progress_remain_display":24,"forecast_remain_display":24,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":4964.05,"can_change_status":true,"budget_display":"5.69\u4e07"},{"id":3882,"client_id":2182,"project_status":3,"project_progress":6,"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-07-28 10:16:23","engineer_id":"","project_title":"\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-K-2025","collected":"0","status_updated_at":"2025-07-18 21:45:40.932292+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-06 16:12:50.856807+08","forecast_updated_at":"2025-06-06 16:12:50.856807+08","end_at":"","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,"remain":"20 days 20:02:17.321161","progress_remain":"63 days 01:35:07.396646","forecast_remain":"63 days 01:35:07.396646","profit":"5241.4046000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"63 days 01:35:07.396646","issued_invoices":"","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"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":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"19427","pct":"26.98","profit":"5241.40","project_id":3882}],"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":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":4047,"from_project":3882,"payment_collection_remind_ahead":"1 day","serial_no":"PO-2025-07-0012","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2508,"key":2508,"contract_id":4047,"name":"2025-08-29","value":"19427","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":19427,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":20,"progress_remain_display":63,"forecast_remain_display":63,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":5241.4,"can_change_status":true,"budget_display":"1.94\u4e07"},{"id":3920,"client_id":12,"project_status":3,"project_progress":9,"budget":"295","profit_pct":"26.68","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-07-17 11:24:07","updated_at":"2025-07-28 10:22:58","engineer_id":"","project_title":"OTJ25075740-\u5185\u5b58-2025","collected":"0","status_updated_at":"2025-07-17 11:24:36.72504+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-17 11:24:07.553294+08","forecast_updated_at":"2025-07-17 11:24:07.553294+08","end_at":"","pinyin_shortcut":"OTJ25075740nc2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":946,"is_sales_order_ready":true,"collected_plan":"295","change_status_to":"","is_verify":false,"remain":"22 days 06:23:21.528413","progress_remain":"22 days 06:23:50.700159","forecast_remain":"22 days 06:23:50.700159","profit":"78.7060000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"22 days 06:23:50.700159","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":"295","pct":"26.68","profit":"78.70","project_id":3920}],"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":4043,"from_project":3920,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25075740","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2504,"key":2504,"contract_id":4043,"name":"2025-08-22","value":"295","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":295,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":22,"progress_remain_display":22,"forecast_remain_display":22,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":78.71,"can_change_status":true,"budget_display":"295"},{"id":3917,"client_id":2182,"project_status":3,"project_progress":9,"budget":"5900","profit_pct":"20","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-07-14 16:50:51","updated_at":"2025-07-22 13:32:04","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-07-28 16:59:17","pinyin_shortcut":"dhjksbxgK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":947,"is_sales_order_ready":false,"collected_plan":"5900","change_status_to":"","is_verify":false,"remain":"22 days 04:29:31.203092","progress_remain":"25 days 00:57:06.876333","forecast_remain":"25 days 00:57:06.876333","profit":"1180.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"14 days 00:08:26.00771","issued_invoices":"","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"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":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3917,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"5900","pct":"20","profit":"1180","project_id":3917}],"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":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":4046,"from_project":3917,"payment_collection_remind_ahead":"2 days","serial_no":"PO-2025-07-0007","erp_settle_amount":"5900","salesContractPayments":[{"id":"1374","key":"1374","contract_id":4046,"value":"5900"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2537,"key":2537,"contract_id":4046,"name":"2025-08-22","value":"5900","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":5900,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":22,"progress_remain_display":25,"forecast_remain_display":25,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":1180,"can_change_status":true,"budget_display":"5900"},{"id":3883,"client_id":2182,"project_status":3,"project_progress":10,"budget":"50000","profit_pct":"70","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-06-06 16:59:28","updated_at":"2025-08-04 11:23:31","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":false,"collected_plan":"50000","change_status_to":"","is_verify":false,"remain":"22 days 06:01:27.28432","progress_remain":"22 days 06:05:22.883203","forecast_remain":"25 days 01:03:55.000055","profit":"35000.000000000000","lost_contact_days":"23.1603964520023","last_contact":"2025-07-16 13:57:00","last_arrive_days":"23.1603964520023","last_arrive":"2025-07-16 13:57:00+08","duration":"63 days 00:48:30.181632","issued_invoices":"","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"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":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3883,"value":"1","key":1022,"name":"\u5f90\u7855"}],"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":"50000","pct":"70","profit":"35000","project_id":3883}],"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":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":{"project_id":3883,"hours":"2.06666666666667","times":3},"implementTimeCount":{},"presalesTimeCount":{"project_id":3883,"sum":"4.4","times":"4"},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3883,"sum":"101.00"},"buildContract":{"id":4044,"from_project":3883,"payment_collection_remind_ahead":"2 days","serial_no":"PO-2025-07-0006","erp_settle_amount":"15000","salesContractPayments":[{"id":"11988","key":"11988","contract_id":4044,"value":"15000"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2541,"key":2541,"contract_id":4044,"name":"2025-08-15","value":"15000","overdue_days":""},{"id":2542,"key":2542,"contract_id":4044,"name":"2025-09-26","value":"35000","overdue_days":""}]},"lost_contact_days_display":"23\u5929\u524d","unissued_invoice":50000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":22,"progress_remain_display":22,"forecast_remain_display":25,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","currents":35000,"can_change_status":true,"budget_display":"5\u4e07"},{"id":3918,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.16","bargain_date":"2025-07-15","description":"","created_by":5300,"created_at":"2025-07-15 15:48:22","updated_at":"2025-07-21 10:45:19","engineer_id":"","project_title":"POTJ25074907-\u56fa\u6001\u786c\u76d8-2025","collected":"598","status_updated_at":"2025-07-15 15:48:22.448293+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-15 15:48:22.448293+08","forecast_updated_at":"2025-07-15 15:48:22.448293+08","end_at":"2025-08-04 11:28:35","pinyin_shortcut":"POTJ25074907gtyp2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":942,"is_sales_order_ready":true,"collected_plan":"598","change_status_to":"","is_verify":false,"remain":"24 days 01:59:35.80516","progress_remain":"24 days 01:59:35.80516","forecast_remain":"24 days 01:59:35.80516","profit":"282.0168000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"19 days 19:40:12.641016","issued_invoices":"598.00","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":"598","pct":"47.16","profit":"282.07","project_id":3918}],"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":4036,"from_project":3918,"payment_collection_remind_ahead":"1 day","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25074907","erp_settle_amount":"598","salesContractPayments":[{"id":"11989","key":"11989","contract_id":4036,"value":"598"}],"salesContractInvoices":[{"id":2101,"key":2101,"contract_id":4036,"value":"598.00","attachment_id":"","from_date":"2025-07-21","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2503,"key":2503,"contract_id":4036,"name":"2025-08-22","value":"598","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":282.02,"can_change_status":true,"budget_display":"598"},{"id":3916,"client_id":3383,"project_status":3,"project_progress":9,"budget":"1500","profit_pct":"32.6","bargain_date":"2025-07-14","description":"","created_by":5295,"created_at":"2025-07-14 13:25:12","updated_at":"2025-07-22 17:11:19","engineer_id":"","project_title":"\u65b0\u8d2dHP\u5b58\u50a8\u786c\u76d8","collected":"0","status_updated_at":"2025-07-22 14:50:10.465361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 14:50:10.465361+08","forecast_updated_at":"2025-07-14 13:25:12.427589+08","end_at":"","pinyin_shortcut":"xgHPccyp","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":958,"is_sales_order_ready":true,"collected_plan":"1500","change_status_to":"","is_verify":false,"remain":"17 days 02:57:47.788092","progress_remain":"17 days 02:57:47.788092","forecast_remain":"25 days 04:22:45.825864","profit":"489.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"25 days 04:22:45.825864","issued_invoices":"","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","logo":"","client_type":5,"client_class":80,"client_industry":20,"sales_rep":5295,"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":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":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1500","pct":"32.6","profit":"489.06","project_id":3916}],"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":{"project_id":3916,"sum":"2.35","times":"2"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4029,"from_project":3916,"payment_collection_remind_ahead":"","serial_no":"TS-WZW-20250714-01","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2518,"key":2518,"contract_id":4029,"name":"2025-08-01","value":"1500","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":1500,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":17,"progress_remain_display":17,"forecast_remain_display":25,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":489,"can_change_status":true,"budget_display":"1500"},{"id":3841,"client_id":3343,"project_status":3,"project_progress":6,"budget":"195205.34","profit_pct":"19.02","bargain_date":"2025-07-12","description":"","created_by":1004,"created_at":"2025-04-29 09:07:50","updated_at":"2025-07-28 10:27:06","engineer_id":"","project_title":"2025PA\u9632\u706b\u5899\u66ff\u6362","collected":"0","status_updated_at":"2025-07-27 22:19:40.220985+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 22:19:40.220985+08","forecast_updated_at":"2025-07-27 22:19:40.220985+08","end_at":"","pinyin_shortcut":"2025PAfhqth","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":960,"is_sales_order_ready":false,"collected_plan":"195205.34","change_status_to":"","is_verify":false,"remain":"11 days 19:28:18.032468","progress_remain":"11 days 19:28:18.032468","forecast_remain":"11 days 19:28:18.032468","profit":"37128.055668000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"101 days 08:40:07.86504","issued_invoices":"","client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","logo":"","client_type":5,"client_class":43,"client_industry":5,"sales_rep":1004,"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":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3841,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"195205.34","pct":"19.02","profit":"37128.05","project_id":3841}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3841,"sum":"13.2","times":"3"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3841,"sum":"35.00"},"buildContract":{"id":4035,"from_project":3841,"payment_collection_remind_ahead":"1 day","serial_no":"","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2522,"key":2522,"contract_id":4035,"name":"2025-09-30","value":"195205.34","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":195205.34,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":11,"progress_remain_display":11,"forecast_remain_display":11,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":37128.06,"can_change_status":true,"budget_display":"19.52\u4e07"},{"id":3910,"client_id":2762,"project_status":3,"project_progress":10,"budget":"3003980","profit_pct":"23.63","bargain_date":"2025-07-11","description":"","created_by":5087,"created_at":"2025-07-09 21:28:44","updated_at":"2025-07-28 15:54:47","engineer_id":"","project_title":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","collected":"0","status_updated_at":"2025-07-13 23:45:04.905541+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-13 23:45:04.905541+08","forecast_updated_at":"2025-07-13 23:45:04.905541+08","end_at":"","pinyin_shortcut":"33sgxnxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"3003980","change_status_to":"","is_verify":false,"remain":"25 days 18:02:53.347912","progress_remain":"25 days 18:02:53.347912","forecast_remain":"25 days 18:02:53.347912","profit":"709840.474000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"29 days 20:19:14.124991","issued_invoices":"2102786.00","client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"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":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[{"project_id":3910,"value":"1","key":1015,"name":"\u5434\u660a"}],"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":"3003980","pct":"23.63","profit":"710000","project_id":3910}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\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":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":4024,"from_project":3910,"payment_collection_remind_ahead":"15 days","serial_no":"2025EC-BJ-74-0530","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[{"id":2093,"key":2093,"contract_id":4024,"value":"2102786.00","attachment_id":"","from_date":"2025-07-11","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2492,"key":2492,"contract_id":4024,"name":"2025-07-25","value":"2102786","overdue_days":""},{"id":2493,"key":2493,"contract_id":4024,"name":"2025-10-31","value":"901194","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":901194,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":25,"progress_remain_display":25,"forecast_remain_display":25,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":709840.47,"can_change_status":true,"budget_display":"300.4\u4e07"},{"id":3906,"client_id":3378,"project_status":3,"project_progress":6,"budget":"184000","profit_pct":"27.07","bargain_date":"2025-07-11","description":"","created_by":1004,"created_at":"2025-07-08 13:19:19","updated_at":"2025-07-18 15:52:10","engineer_id":"","project_title":"\u601d\u79d1N9K\u7eed\u4fdd\u9879\u76ee","collected":"0","status_updated_at":"2025-07-13 10:23:15.085575+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-08 13:19:19.068132+08","forecast_updated_at":"2025-07-08 13:19:19.068132+08","end_at":"","pinyin_shortcut":"skN9Kxbxm","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":937,"is_sales_order_ready":true,"collected_plan":"184000","change_status_to":"","is_verify":false,"remain":"26 days 07:24:43.167878","progress_remain":"31 days 04:28:39.185321","forecast_remain":"31 days 04:28:39.185321","profit":"49808.800000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"31 days 04:28:39.185321","issued_invoices":"","client":{"id":3378,"key":3378,"name":"\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1004,"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":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"184000","pct":"27.07","profit":"49808.8","project_id":3906}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4026,"from_project":3906,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20250702-YJC-01","erp_settle_amount":"0","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2498,"key":2498,"contract_id":4026,"name":"2025-08-08","value":"128800","overdue_days":""},{"id":2499,"key":2499,"contract_id":4026,"name":"2025-12-31","value":"55200","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":184000,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":26,"progress_remain_display":31,"forecast_remain_display":31,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":49808.8,"can_change_status":true,"budget_display":"18.4\u4e07"}],"thisUser":"","can_create":true,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":1550,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 17:47:58') RETURNING "id"
17:47:58.3313.6 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (4046, 4036, 4075, 4024, 4043, 4035, 4026, 4065, 4064, 4049, 4047, 4055, 4061, 4054, 4050, 4048, 4068, 4071, 4044, 4029) ORDER BY "id" DESC
17:47:58.2043.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:47:58.3453.0 msyii\db\Command::querySELECT sum(sci.amount) AS invoices FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.project_id = p.id WHERE "p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)
17:47:58.3262.6 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)) GROUP BY "project_id"
17:47:58.2022.6 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:47:58.3382.3 msyii\db\Command::querySELECT sum(p.budget * p.profit_pct / 100) AS profits, sum(p.budget) AS currents, sum(p.collected) AS collected, count(distinct p.client_id) as clients, count(p.id) AS count_current FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."project_status"=3) AND ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093))
17:47:58.3422.1 msyii\db\Command::querySELECT sum(c.erp_settle_amount) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("p"."project_status"=3) AND ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093))
17:47:58.2091.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:47:58.3401.5 msyii\db\Command::querySELECT sum(case when p.budget >= p.collected THEN p.budget - p.collected ELSE 0 END) AS un_collected FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."project_status"=3) AND ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093))
17:47:58.3291.4 msyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "erp_settle_amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)
17:47:58.2911.3 msyii\db\Command::querySELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)
17:47:58.2941.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 2, 1, 327, 226, 215, 184, 189, 307, 203, 205, 309, 183, 188, 190, 197, 199, 196, 204, 185, 191, 340, 323, 349, 356, 360, 369, 377, 165, 142, 130, 181, 164, 182, 172, 128)) ORDER BY "sort"
17:47:58.2881.0 msyii\db\Command::querySELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)
17:47:58.3011.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3286, 3387, 12, 3383, 2553, 2136, 2182, 3343, 2762, 3378)
17:47:58.2990.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1005, 5087, 1004, 5300, 1001))
17:47:58.3580.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=45, "last_visit_at"='now()' WHERE "id"=54993
17:47:58.2930.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)
17:47:58.3250.7 msyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)) GROUP BY "project_id"
17:47:58.2850.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3286, 3387, 12, 3383, 2553, 2136, 2182, 3343, 2762, 3378)
17:47:58.3030.7 msyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)) GROUP BY "project_id"
17:47:58.2950.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)
17:47:58.3350.7 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4046, 4036, 4075, 4024, 4043, 4035, 4026, 4065, 4064, 4049, 4047, 4055, 4061, 4054, 4050, 4048, 4068, 4071, 4044, 4029) ORDER BY "id"
17:47:58.2970.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3927, 3934, 3930, 3929, 3928, 3926, 3925, 3924, 3751, 3922, 3919, 3882, 3920, 3917, 3883, 3918, 3916, 3841, 3910, 3906)
17:47:58.3360.6 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4046, 4036, 4075, 4024, 4043, 4035, 4026, 4065, 4064, 4049, 4047, 4055, 4061, 4054, 4050, 4048, 4068, 4071, 4044, 4029) ORDER BY "remind_date"
17:47:58.2860.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 6)
17:47:58.2870.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 80, 47)
17:47:58.2960.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 2, 1, 327, 226, 215, 184, 189, 307, 203, 205, 309, 183, 188, 190, 197, 199, 196, 204, 185, 191, 340, 323, 349, 356, 360, 369, 377, 165, 142, 130, 181, 164, 182, 172, 128)) ORDER BY "sort"
17:47:58.2970.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 2, 1, 327, 226, 215, 184, 189, 307, 203, 205, 309, 183, 188, 190, 197, 199, 196, 204, 185, 191, 340, 323, 349, 356, 360, 369, 377, 165, 142, 130, 181, 164, 182, 172, 128)) ORDER BY "sort"
17:47:58.2900.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
17:47:58.3000.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 4)
17:47:58.2880.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 20, 5)
17:47:58.2980.4 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
17:47:58.2990.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5300, 5295, 5087, 1004)
17:47:58.2900.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (6, 9, 10)
17:47:58.3020.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5295, 5300, 5087, 1005, 1001)
17:47:58.3030.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1005, 5087, 1004, 5300, 1001))