Performance Profiling

Total processing time: 197 ms; Peak memory: 7.280 MB. Show Profiling Timeline

总计85条数据

Time	Duration	Category	Info

15:38:25.445	42.8 ms	yii\db\Command::query	SELECT p., (p.budget / 100 p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, 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 (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10
15:38:25.412	31.9 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT p., (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, 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 (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c"
15:38:25.542	20.0 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "object_id"
15:38:25.563	17.1 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "object_id"
15:38:25.510	5.4 ms	yii\db\Command::query	SELECT "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 (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "c"."project_id"
15:38:25.502	5.4 ms	yii\db\Command::query	SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716) GROUP BY "c"."project_id"
15:38:25.590	3.8 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/project/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","page":"1","token":"cb3508e3b4c2a2f2f5fd18e1fdef1657","posttime":"1757489905","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":1791,"client_id":1661,"project_status":3,"project_progress":49,"budget":"514761.00","profit_pct":"0.56","bargain_date":"2020-06-03","description":"1\u53f05500VX-HW\u8bbe\u5907","created_by":1001,"created_at":"2020-06-23 16:32:19","updated_at":"2025-09-10 14:34:31","engineer_id":null,"project_title":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","collected":"514761","status_updated_at":"2020-08-10 17:52:12.720678+08","success_rate":null,"comment":"1\u53f05500VX-HW\u8bbe\u5907\r\n1.\n2.\n3.\n","contract_type":1,"progress_updated_at":"2022-10-19 23:06:35.395931+08","forecast_updated_at":"2021-04-19 22:25:38.787859+08","end_at":"2021-04-19 22:25:38","pinyin_shortcut":"hy5500VXcgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":514761,"change_status_to":null,"is_verify":false,"profits":"2882.661600000000000000","remain":"1856 days 21:46:12.725547","progress_remain":"1056 days 16:31:50.050294","forecast_remain":"1604 days 17:12:46.658366","lost_contact_days":"0.0584426646412037","last_contact":"2025-09-10 14:14:16","last_arrive_days":"0.0584426646412037","last_arrive":"2025-09-10 14:14:16+08","duration":"300 days 05:53:19.020575","issued_invoices":"514761.00","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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"}},"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"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"514761.00","pct":"0.56","profit":"2882.6616","project_id":1791}],"salesForecast":{"id":175,"key":175,"name":"100%","description":"\u6210\u529f\u7b7e\u8ba2\u5408\u540c"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":null,"workLogCount":{"project_id":1791,"count":3},"caseCount":null,"salesTimeCount":{"project_id":1791,"hours":"0.00333333333333333","times":1},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":{"project_id":1791,"hours":"0","times":1},"reimbursementAmountSum":null,"buildContract":{"id":1558,"from_project":1791,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20200602-HYF-004","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"514761","erp_un_settle_amount":"0","including_tax":true,"amount":"514761.00","contractScans":[{"id":12313,"object_type":105,"object_id":1558,"attachment_id":5271,"attachment":{"id":5271,"key":5271,"name":"1727e634-855f-3aa3-86ce-f19c5df0e9dd","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1727e634-855f-3aa3-86ce-f19c5df0e9dd\/2020_06_29_09_03_56.pdf","orig_name":"2020_06_29_09_03_56.pdf"}}],"receiptScans":[{"id":13085,"object_type":106,"object_id":1558,"attachment_id":5320,"attachment":{"id":5320,"key":5320,"name":"b0db54c2-4b7d-3b26-b333-1bcd84fc2666","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/b0db54c2-4b7d-3b26-b333-1bcd84fc2666\/\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":423,"serial_no":"SKD-19700101-00001","wrote_date":null,"from_date":null,"handler":1001,"user_id":null,"client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2020-06-23 16:32:19","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"514761.00","settle_amount":"514761.00","created_by":null,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2020-06-23 16:32:19","updated_at":"2020-06-23 16:32:19","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1423","key":"1423","contract_id":1558,"value":"514761.00","created_by":null,"createdBy":null,"pct":100}],"salesContractInvoices":[{"id":854,"key":854,"contract_id":1558,"value":"514761.00","attachment_id":5400,"from_date":"2020-07-15","attachment":{"id":5400,"key":5400,"name":"b0be27a4-0269-36ec-99ed-ef2ca596d429","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/b0be27a4-0269-36ec-99ed-ef2ca596d429\/2020_07_15_11_35_57.pdf","orig_name":"2020_07_15_11_35_57.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":550,"key":550,"contract_id":1558,"name":"2020-08-11","value":"514761.00","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":1252,"user_id":1001,"key":1001,"contract_id":1558,"user":{"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"}}},{"id":1253,"user_id":1011,"key":1011,"contract_id":1558,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":635,"contract_id":1558,"supplier_id":365,"purchase_id":1559,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":1559,"key":1559,"serial_no":"TSKJ20200603-HYF-002"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":514761},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":1791,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":584,"serial_no":"XSDD-20210419-00001","from_date":null,"wrote_date":"2020-06-03","handler":5015,"client_id":1661,"purchase_contract_id":null,"project_id":1791,"sales_contract_id":1558,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u5b89\u5168 ","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-19 22:25:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"514761","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2020-06-23 16:32:19","updated_at":"2021-04-19 22:25:38"},"projectUsedClient":null,"remain_display":1856,"progress_remain_display":1056,"forecast_remain_display":1604,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u5c0f\u65f6\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":300,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"1\u5c0f\u65f6\u524d","can_view_product":true,"budget_display":"51.48\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3577,"client_id":3278,"project_status":3,"project_progress":9,"budget":"198354","profit_pct":"-0.71","bargain_date":"2024-06-25","description":"","created_by":1001,"created_at":"2024-06-26 10:50:35","updated_at":"2025-09-05 11:16:23","engineer_id":null,"project_title":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","collected":"198354","status_updated_at":"2024-06-26 10:50:35.474112+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-06-26 10:50:35.474112+08","forecast_updated_at":"2024-06-26 10:50:35.474112+08","end_at":"2024-09-24 13:35:40","pinyin_shortcut":"PA1410fhq2txgxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"26476","paid_contact_point":"26476","project_product_version_id":523,"is_sales_order_ready":true,"collected_plan":198354,"change_status_to":null,"is_verify":false,"profits":"-1408.313400000000000000","remain":"441 days 04:47:49.972113","progress_remain":"441 days 04:47:49.972113","forecast_remain":"441 days 04:47:49.972113","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"90 days 02:45:04.663669","issued_invoices":"198354.00","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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"}},"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"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"198354.00","pct":"-0.71","profit":"-1408.3134","project_id":3577}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3364,"from_project":3577,"payment_collection_remind_ahead":"7 days","serial_no":"TS-HYF-2024062501","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"198354","erp_un_settle_amount":"0","including_tax":true,"amount":"198354","contractScans":[{"id":31070,"object_type":105,"object_id":3364,"attachment_id":19980,"attachment":{"id":19980,"key":19980,"name":"3f4fb0c6-72d6-34ed-ade6-f90f9c306016","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/3f4fb0c6-72d6-34ed-ade6-f90f9c306016\/\u521b\u5b89\u5149\u901a.pdf","orig_name":"\u521b\u5b89\u5149\u901a.pdf"}}],"receiptScans":[{"id":27594,"object_type":106,"object_id":3364,"attachment_id":20715,"attachment":{"id":20715,"key":20715,"name":"4626bfd6-f39b-38de-bc6e-d57b6a614c1b","extension":"jpeg","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/4626bfd6-f39b-38de-bc6e-d57b6a614c1b\/WechatIMG180.jpeg","orig_name":"WechatIMG180.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":115,"serial_no":"SKD-20240924-00002","wrote_date":"2024-09-24","from_date":null,"handler":1001,"user_id":null,"client_id":3278,"sales_contract_id":3364,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-24 13:35:39","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"198354","settle_amount":"198354","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-09-24 13:35:39","updated_at":"2024-09-24 13:35:39","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1115","key":"1115","contract_id":3364,"value":"198354","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1740,"key":1740,"contract_id":3364,"value":"198354.00","attachment_id":null,"from_date":"2024-08-05","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2010,"key":2010,"contract_id":3364,"name":"2024-09-19","value":"198354","overdue_days":5,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7324,"user_id":5388,"key":5388,"contract_id":3364,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7325,"user_id":1001,"key":1001,"contract_id":3364,"user":{"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"}}}],"salesSupplierRels":[{"id":2199,"contract_id":3364,"supplier_id":90,"purchase_id":3365,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3365,"key":3365,"serial_no":"X_2024SBQ15876"}},{"id":3205,"contract_id":3364,"supplier_id":431,"purchase_id":4133,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":4133,"key":4133,"serial_no":"\u65b9\u5f0f\u5730\u65b9\u662f"}}],"payment_collection_remind_ahead_display":"7\u5929","invoiced":198354},"projectRemindReceivers":[{"id":1091,"user_id":1001,"key":1001,"project_id":3577,"user":{"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"}}}],"projectProductRels":[{"id":7951,"project_id":3577,"product_id":969,"amount":"47830","number":2,"cost":"35000","description":"","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"95660","total_cost":"70000","erp_sales_order_product_id":969,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2024-01-12 15:43:25","pinyin_shortcut":"PANPA1410","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":969,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":969,"description":"","number":"2","outbound":"0","amount":"47830","total_amount":"95660","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"35000","total_cost":"70000","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}},{"id":7952,"project_id":3577,"product_id":1586,"amount":"11868","number":2,"cost":"15203.5","description":"","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"23736","total_cost":"30407.0","erp_sales_order_product_id":970,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1586,"name":"PAN-SVC-BKLN-1410","product_type":5,"product_component":35,"product_brand":8,"product_serie":1359,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2024-04-26 09:35:29","updated_at":"2024-06-26 13:07:03","pinyin_shortcut":"PANSVCBKLN1410","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1359,"key":1359,"name":"PA-1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":970,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":1586,"description":"","number":"2","outbound":"0","amount":"11868","total_amount":"23736","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"15203.5","total_cost":"30407.0","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}},{"id":7953,"project_id":3577,"product_id":1657,"amount":"39479","number":2,"cost":"30000","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null,"total_amount":"78958","total_cost":"60000","erp_sales_order_product_id":971,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1657,"name":"PAN-PA-1410-BND-CORESEC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1243,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Core Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN ), 1 years (12 months) term\n","created_by":1013,"created_at":"2024-06-26 10:53:31","updated_at":"2024-06-26 10:53:31","pinyin_shortcut":"PANPA1410BNDCORESEC","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1243,"key":1243,"name":"PA1410\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":971,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":1657,"description":"","number":"2","outbound":"0","amount":"39479","total_amount":"78958","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"30000","total_cost":"60000","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null}}],"commentCount":{"object_id":3577,"comment":3},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":774,"project_id":3577,"contact_id":1262,"point":"26476.00","paid_point":"26476","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":138,"project_id":3577,"contact_id":1262,"point":"26476.00","day_at":"2024-12-16","description":"","created_at":"2024-12-16 10:10:44"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1271,"serial_no":"XSDD-20240924-00001","from_date":null,"wrote_date":"2024-06-25","handler":1001,"client_id":3278,"purchase_contract_id":null,"project_id":3577,"sales_contract_id":3364,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-24 13:35:40","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"198354","created_by":1001,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-06-26 10:50:35","updated_at":"2024-09-24 13:35:40"},"projectUsedClient":null,"remain_display":441,"progress_remain_display":441,"forecast_remain_display":441,"projectProductTotalAmount":198354,"projectProductAllAmount":true,"projectProductTotalCost":160407,"projectProductAllCost":true,"projectProductTotalNumber":6,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":90,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"19.84\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3955,"client_id":2166,"project_status":2,"project_progress":4,"budget":"129992","profit_pct":"16.58","bargain_date":"2025-12-31","description":null,"created_by":5300,"created_at":"2025-08-25 16:25:50","updated_at":"2025-09-05 09:56:37","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u65b0\u8d2d-G-2025","collected":"0","status_updated_at":"2025-08-25 16:25:50.449572+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-25 16:25:50.449572+08","forecast_updated_at":"2025-08-25 16:25:50.449572+08","end_at":"","pinyin_shortcut":"sxflxrxgG2025","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"21552.673600000000000000","remain":"15 days 23:12:34.996653","progress_remain":"15 days 23:12:34.996653","forecast_remain":"15 days 23:12:34.996653","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"15 days 23:12:34.996653","issued_invoices":null,"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":5,"sales_rep":5300,"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"}},"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":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"80000","pct":"10","profit":"8000","project_id":3955},{"id":8,"product_type_id":8,"key":8,"name":"\u4e91\u684c\u9762","budget":"24556","pct":"14.46","profit":"3550.79","project_id":3955},{"id":88,"product_type_id":88,"key":88,"name":"\u79c1\u6709\u4e91","budget":"25436","pct":"39.31","profit":"10000","project_id":3955}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1766,"user_id":1001,"key":1001,"project_id":3955,"user":{"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"}}},{"id":1767,"user_id":1005,"key":1005,"project_id":3955,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3955,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":186,"project_id":3955,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":15,"progress_remain_display":15,"forecast_remain_display":15,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":129992,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":15,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"13\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-04 11:42:10","engineer_id":null,"project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":null,"from_contact":5957,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"4559.824800000000000000","remain":"19 days 04:39:54.694557","progress_remain":"50 days 04:33:02.221511","forecast_remain":"50 days 04:33:02.221511","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"50 days 04:33:02.221511","issued_invoices":"21224.00","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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"}},"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"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"40932","pct":"11.14","profit":"4732","project_id":3927}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"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"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4112,"from_project":3927,"payment_collection_remind_ahead":"1 day","serial_no":"PO2500925\/PO2500926","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"1","erp_un_settle_amount":"40931","including_tax":true,"amount":"40932","contractScans":[{"id":49444,"object_type":105,"object_id":4112,"attachment_id":27758,"attachment":{"id":27758,"key":27758,"name":"7ee83baa-e612-3fd5-bd97-de0e41ad46c7","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/7ee83baa-e612-3fd5-bd97-de0e41ad46c7\/PO2500925.pdf","orig_name":"PO2500925.pdf"}},{"id":49445,"object_type":105,"object_id":4112,"attachment_id":27759,"attachment":{"id":27759,"key":27759,"name":"d40dfb56-6c1a-3498-b015-b8c1de8944bf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/d40dfb56-6c1a-3498-b015-b8c1de8944bf\/PO2500926.pdf","orig_name":"PO2500926.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12022","key":"12022","contract_id":4112,"value":"1","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0}],"salesContractInvoices":[{"id":2137,"key":2137,"contract_id":4112,"value":"21224.00","attachment_id":null,"from_date":"2025-08-28","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8890,"user_id":1001,"key":1001,"contract_id":4112,"user":{"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"}}},{"id":8891,"user_id":5388,"key":5388,"contract_id":4112,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8892,"user_id":1011,"key":1011,"contract_id":4112,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":3202,"contract_id":4112,"supplier_id":90,"purchase_id":4122,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4122,"key":4122,"serial_no":"X_2025SBQ23652"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":21224},"projectRemindReceivers":[],"projectProductRels":[{"id":10727,"project_id":3927,"product_id":1624,"amount":"1516","number":14,"cost":"1393.00","description":"\u65b0\u8d2d","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"21224.00","total_cost":"19502","erp_sales_order_product_id":1860,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1860,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":1624,"description":"\u65b0\u8d2d","number":"14","outbound":"0","amount":"1516","total_amount":"21224.00","last_number":"14","last_amount":"1516","last_total_amount":"21224.00","cost":"1393.00","total_cost":"19502","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10729,"project_id":3927,"product_id":2095,"amount":"0","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"0","erp_sales_order_product_id":1875,"supplier":null,"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1875,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":2095,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10728,"project_id":3927,"product_id":1624,"amount":"1516","number":13,"cost":"1393.00","description":"\u7eed\u7ea6","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"19708","total_cost":"18109","erp_sales_order_product_id":1861,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1861,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":1624,"description":"\u7eed\u7ea6","number":"13","outbound":"13","amount":"1516","total_amount":"19708","last_number":"14","last_amount":"1516","last_total_amount":"21224.00","cost":"1393.00","total_cost":"19502","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3927,"comment":3},"unreadComments":null,"fromContact":{"id":5957,"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","client_id":null,"supplier_id":100,"mobiles":[{"id":6746,"contact_id":5957,"mobile":"13910153435","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1571,"serial_no":"XSDD-20250822-00001","from_date":null,"wrote_date":"2025-08-22","handler":1001,"client_id":3286,"purchase_contract_id":null,"project_id":3927,"sales_contract_id":4112,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-22 10:59:39","stop_at":"2025-08-26 13:45:57.84962+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"28","amount":"40932","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5388\",\"1011\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-10-22\",\"amount\":\"42448\",\"pct\":\"100\"}]}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-22 10:58:31","updated_at":"2025-08-26 16:06:50"},"projectUsedClient":{"id":180,"project_id":3927,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":19,"progress_remain_display":50,"forecast_remain_display":50,"projectProductTotalAmount":40932,"projectProductAllAmount":true,"projectProductTotalCost":37611,"projectProductAllCost":true,"projectProductTotalNumber":28,"unissued_invoice":19708,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":50,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"4.09\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"40931","un_invoiced":19708},{"id":3957,"client_id":2130,"project_status":3,"project_progress":2,"budget":"20000000","profit_pct":"20","bargain_date":"2025-07-17","description":null,"created_by":5087,"created_at":"2025-08-29 11:38:51","updated_at":"2025-09-04 10:01:21","engineer_id":null,"project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","collected":"0","status_updated_at":"2025-09-04 10:01:21.2926+08","success_rate":null,"comment":"\u9884\u7b972000\u4e07","contract_type":1,"progress_updated_at":"2025-08-29 11:38:51.97137+08","forecast_updated_at":"2025-08-29 11:38:51.97137+08","end_at":"","pinyin_shortcut":"zgrmjfjzcmbdwsyyjsszgcgxn","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"4000000.000000000000","remain":"6 days 05:37:04.153625","progress_remain":"12 days 03:59:33.474855","forecast_remain":"12 days 03:59:33.474855","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"12 days 03:59:33.474855","issued_invoices":null,"client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":null,"client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087,"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"}},"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"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3957,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"20000000","pct":"20","profit":"4000000","project_id":3957}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4132,"from_project":3957,"payment_collection_remind_ahead":"1 day","serial_no":"2025-09-04-001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"20000000","including_tax":true,"amount":"20000000","contractScans":[],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8884,"user_id":1001,"key":1001,"contract_id":4132,"user":{"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"}}},{"id":8885,"user_id":5087,"key":5087,"contract_id":4132,"user":{"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[{"id":1765,"user_id":1001,"key":1001,"project_id":3957,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3957,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1577,"serial_no":"XSDD-20250904-00001","from_date":null,"wrote_date":"2025-07-17","handler":5087,"client_id":2130,"purchase_contract_id":null,"project_id":3957,"sales_contract_id":4132,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-04 10:01:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"20000000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-04 10:01:22","updated_at":"2025-09-04 10:01:34"},"projectUsedClient":{"id":185,"project_id":3957,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":6,"progress_remain_display":12,"forecast_remain_display":12,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":20000000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":12,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"2000\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"20000000","un_invoiced":20000000},{"id":3947,"client_id":304,"project_status":3,"project_progress":9,"budget":"7300","profit_pct":"5.15","bargain_date":"2025-08-21","description":"","created_by":5295,"created_at":"2025-08-19 10:48:28","updated_at":"2025-09-03 17:13:07","engineer_id":null,"project_title":"\u91c7\u8d2dAdobe\u8f6f\u4ef6","collected":"0","status_updated_at":"2025-08-21 11:40:59.153148+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-19 10:48:28.917403+08","forecast_updated_at":"2025-08-19 10:48:28.917403+08","end_at":"","pinyin_shortcut":"cgAdoberj","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1004,"is_sales_order_ready":false,"collected_plan":7300,"change_status_to":null,"is_verify":false,"profits":"375.950000000000000000","remain":"20 days 03:57:26.293077","progress_remain":"22 days 04:49:56.528822","forecast_remain":"22 days 04:49:56.528822","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"22 days 04:49:56.528822","issued_invoices":null,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":80,"client_industry":5,"sales_rep":5295,"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"}},"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":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"7300.00","pct":"5.15","profit":"375.95","project_id":3947}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4111,"from_project":3947,"payment_collection_remind_ahead":"1 day","serial_no":"2025-08-21-002","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"7300","including_tax":true,"amount":"7300","contractScans":[{"id":48957,"object_type":105,"object_id":4111,"attachment_id":27760,"attachment":{"id":27760,"key":27760,"name":"75dbb4f4-6d6c-3fe9-9217-0d97abf35ede","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/75dbb4f4-6d6c-3fe9-9217-0d97abf35ede\/2025_08_21_11_15_13.pdf","orig_name":"2025_08_21_11_15_13.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2554,"key":2554,"contract_id":4111,"name":"2025-09-30","value":"7300","overdue_days":null,"pct":100,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":8866,"user_id":5295,"key":5295,"contract_id":4111,"user":{"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"}}}],"salesSupplierRels":[{"id":3199,"contract_id":4111,"supplier_id":725,"purchase_id":4128,"supplier":{"id":725,"key":725,"name":"\u5317\u4eac\u795e\u7801\u4fe1\u521b\u8f6f\u4ef6\u6709\u9650\u516c\u53f8"},"purchase":{"id":4128,"key":4128,"serial_no":"TSKJ20250827-HYF-001"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[{"id":1740,"user_id":1001,"key":1001,"project_id":3947,"user":{"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"}}},{"id":1741,"user_id":1005,"key":1005,"project_id":3947,"user":{"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"}}}],"projectProductRels":[{"id":10689,"project_id":3947,"product_id":2100,"amount":"7300.00","number":1,"cost":"6700.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7300","total_cost":"6700","erp_sales_order_product_id":1857,"supplier":null,"product":{"id":2100,"name":"Adobe\u5168\u5bb6\u6876","product_type":7,"product_component":159,"product_brand":261,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"Creative Cloud for teams All Apps 12 months \u5168\u5bb6\u6876","created_by":1013,"created_at":"2025-08-15 14:51:48","updated_at":"2025-09-04 09:08:12","pinyin_shortcut":"Adobeqjt","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":261,"key":261,"name":"Adobe"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1857,"erp_sales_order_id":1568,"erp_store_id":null,"product_id":2100,"description":"","number":"1","outbound":"0","amount":"7300.00","total_amount":"7300","last_number":"1","last_amount":"7300.00","last_total_amount":"7300","cost":"6700.00","total_cost":"6700","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3947,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1568,"serial_no":"XSDD-20250821-00001","from_date":null,"wrote_date":"2025-08-21","handler":5295,"client_id":304,"purchase_contract_id":null,"project_id":3947,"sales_contract_id":4111,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-21 21:56:47","stop_at":"2025-08-27 11:20:20.740481+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"7300","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5295\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-09-30\",\"amount\":\"7300\",\"pct\":\"100\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-21 11:40:59","updated_at":"2025-08-27 13:16:28"},"projectUsedClient":{"id":179,"project_id":3947,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":20,"progress_remain_display":22,"forecast_remain_display":22,"projectProductTotalAmount":7300,"projectProductAllAmount":true,"projectProductTotalCost":6700,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":7300,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":22,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"7300","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"7300","un_invoiced":7300},{"id":3874,"client_id":3377,"project_status":3,"project_progress":9,"budget":"228000","profit_pct":"13.69","bargain_date":"2025-06-27","description":"","created_by":1004,"created_at":"2025-05-29 14:04:22","updated_at":"2025-09-03 16:41:03","engineer_id":null,"project_title":"ZStack\u4e91\u4ea7\u54c1\uff08\u7518\u674e\u836f\u4e1a\uff09\u91c7\u8d2d\u9879\u76ee","collected":"34200","status_updated_at":"2025-07-08 13:11:56.995814+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-07-02 10:01:31.349754+08","forecast_updated_at":"2025-05-29 14:04:22.219435+08","end_at":"","pinyin_shortcut":"ZStackycpglyycgxm","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":"27700","paid_contact_point":null,"project_product_version_id":933,"is_sales_order_ready":true,"collected_plan":228000,"change_status_to":null,"is_verify":false,"profits":"31213.200000000000000000","remain":"64 days 02:26:28.450411","progress_remain":"70 days 05:36:54.096471","forecast_remain":"104 days 01:34:03.22679","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"104 days 01:34:03.22679","issued_invoices":"228000.00","client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"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"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":88,"product_type_id":88,"key":88,"name":"\u79c1\u6709\u4e91","budget":"228000.00","pct":"13.69","profit":"31213.2","project_id":3874}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"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"}},"projectCreator":{"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"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4016,"from_project":3874,"payment_collection_remind_ahead":"1 day","serial_no":"2025\/BJ262\/BJBJ2025-1191","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"34200","erp_un_settle_amount":"193800","including_tax":true,"amount":"228000","contractScans":[{"id":35849,"object_type":105,"object_id":4016,"attachment_id":26741,"attachment":{"id":26741,"key":26741,"name":"70369e3b-7650-3f1a-b608-ca3554a06930","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/70369e3b-7650-3f1a-b608-ca3554a06930\/\u5a01\u53d1-\uffe5228000.pdf","orig_name":"\u5a01\u53d1-\uffe5228000.pdf"}}],"receiptScans":[{"id":36018,"object_type":106,"object_id":4016,"attachment_id":27072,"attachment":{"id":27072,"key":27072,"name":"15378cb0-d4e6-3f6a-8836-6a99b50fe7c4","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/15378cb0-d4e6-3f6a-8836-6a99b50fe7c4\/2025_07_24_10_00_48.pdf","orig_name":"2025_07_24_10_00_48.pdf"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12005","key":"12005","contract_id":4016,"value":"34200","created_by":5388,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":15}],"salesContractInvoices":[{"id":2097,"key":2097,"contract_id":4016,"value":"228000.00","attachment_id":null,"from_date":"2025-07-18","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2487,"key":2487,"contract_id":4016,"name":"2025-09-30","value":"228000","overdue_days":null,"pct":100,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":8686,"user_id":1004,"key":1004,"contract_id":4016,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":2973,"contract_id":4016,"supplier_id":68,"purchase_id":4017,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":4017,"key":4017,"serial_no":"Zstack-BJ7067-20250528"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":228000},"projectRemindReceivers":[],"projectProductRels":[{"id":10332,"project_id":3874,"product_id":965,"amount":"4500.00","number":8,"cost":"3750.00","description":"","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null,"total_amount":"36000","total_cost":"30000","erp_sales_order_product_id":1748,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":965,"name":"ZStack Cloud \u4e91\u5e73\u53f0 V4.0 \u4f01\u4e1a\u7248(\u6c38\u4e45\u8bb8\u53ef)","product_type":7,"product_component":53,"product_brand":138,"product_serie":1262,"product_misc":null,"product_qa":null,"pn":"","description":"ZStack Cloud \u4e91\u5e73\u53f0\u4f01\u4e1a\u7248:1\u3001 \u914d\u7f6e\u670d\u52a1\u5668\u865a\u62df\u5316:\u5c06\u7269\u7406\u670d\u52a1\u5668 CPU\u3001\u5185\u5b58\u7b49\u8fdb\u884c\u865a\u62df\u5316\u6c60\u5316,\u4e3a\u4e0a \u5c42\u5e94\u7528\u5f39\u6027\u8ba1\u7b97\u8d44\u6e90\u670d\u52a1,\u652f\u6301\u4e1a \u5185\u6240\u6709\u4e3b\u6d41 X86 \u670d\u52a1\u5668\u578b\u53f7,\u652f\u6301 \u7ba1\u7406\u8282\u70b9\u9ad8\u53ef\u7528\u548c\u865a\u62df\u673a\u9ad8\u53ef\u7528\u3001 \u4e91\u4e3b\u673a\u5feb\u7167\u7b49\u5168\u90e8\u529f\u80fd;2\u3001\u914d\u7f6e\u5b58 \u50a8\u865a\u62df\u5316\u5bf9\u63a5\u6a21\u5757:\u652f\u6301\u5bf9\u63a5\u7ba1\u7406 \u591a\u79cd\u5b58\u50a8\u7c7b\u578b,\u5305\u62ec\u672c\u5730\u5b58\u50a8\u3001\u96c6 \u4e2d\u5b58\u50a8(NFS\/iSCSI\/FC)\u3001\u5206\u5e03\u5f0f \u5b58\u50a8\u7b49,\u4e3a\u4e91\u4e3b\u673a\u63d0\u4f9b\u5757\u5b58\u50a8\u670d \u52a1;3\u3001\u914d\u7f6e\u4e91\u76d8\u7ba1\u7406\u529f\u80fd:\u652f\u6301\u4e91\u76d8 QoS \u529f\u80fd,\u652f\u6301\u5171\u4eab\u4e91\u76d8\u529f\u80fd, \u652f\u6301\u5728\u7ebf\u4e91\u76d8\u6269\u5bb9\u529f\u80fd,\u652f\u6301\u4e91\u76d8 \u5feb\u7167\u3001\u514b\u9686\u3001\u521b\u5efa\u955c\u50cf\u529f\u80fd;4\u3001\u914d \u7f6e\u9ad8\u7ea7\u7f51\u7edc\u865a\u62df\u5316\u8f6f\u4ef6\u6a21\u5757:\u652f\u6301 \u5206\u5e03\u5f0f\u6241\u5e73\u7f51\u7edc\u6a21\u578b,\u63d0\u4f9b\u5206\u5e03\u5f0f DHCP \u670d\u52a1,\u6d88\u9664\u7f51\u7edc\u6027\u80fd\u74f6\u9888\u53ca\u5355 \u70b9\u6545\u969c,\u652f\u6301 VPC \u7f51\u7edc\u6a21\u578b,\u652f\u6301 SR-IOV\u3001\u667a\u80fd\u7f51\u5361\u7b49\u9ad8\u6027\u80fd\u7f51\u5361\u529f \u80fd,\u63d0\u4f9b\u4e0d\u53d7\u6570\u91cf\u9650\u5236\u7684\u5f39\u6027 IP\u3001 \u865a\u62df\u8def\u7531\u5668\u3001\u865a\u62df\u9632\u706b\u5899\u3001\u865a\u62df\u5b89 \u5168\u7ec4\u3001\u865a\u62df\u8d1f\u8f7d\u5747\u8861,\u652f\u6301 OSPF \u52a8 \u6001\u8def\u7531\u534f\u8bae\u3001SNAT \u7f51\u7edc\u670d\u52a1\u3001\u7ec4\u64ad \u8def\u7531\u3001\u7aef\u53e3\u8f6c\u53d1\u3001NetFlow \u7b49\u9ad8\u7ea7 \u7f51\u7edc\u529f\u80fd;\u652f\u6301\u4e8c\u5c42\u7f51\u7edc\u9694\u79bb\u529f \u80fd:\u652f\u6301 noVLAN\u3001VLAN\u3001Vxlan,\u652f \u6301\u7f51\u7edc\u4e1c\u897f\u5411\u3001\u5357\u5317\u5411 QoS \u529f\u80fd; \u652f\u6301\u786c\u4ef6 Vxlan \u5bf9\u63a5\u6dfb\u52a0 SDN \u63a7\u5236 \u5668,\u652f\u6301\u914d\u7f6e\u57fa\u4e8e TCP\/UDP \u7aef\u53e3\u7684 \u4e09\u5c42\u5b89\u5168\u7b56\u7565\u9694\u79bb;5\u3001\u914d\u7f6e\u4e91\u5e73\u53f0 \u4f01\u4e1a\u7ea7\u529f\u80fd\u6a21\u5757:\u652f\u6301\u6240\u6709\u4e3b\u6d41 GPU \u8bbe\u5907\u900f\u4f20\u548c\u865a\u62df\u5316\u529f\u80fd;\u652f\u6301 \u4e91\u4e3b\u673a\u5f39\u6027\u4f38\u7f29\u7ba1\u7406\u529f\u80fd;\u652f\u6301\u5927 \u5c4f\u76d1\u63a7\u529f\u80fd;\u652f\u6301\u8ba1\u91cf\u8ba1\u8d39\u529f\u80fd; \u652f\u6301 VDI \u534f\u8bae;6\u3001\u914d\u7f6e\u5e73\u53f0\u76d1\u63a7\u7ba1 \u7406\u6a21\u5757,\u63d0\u4f9b\u7269\u7406\u673a\u3001\u865a\u62df\u673a\u8d44\u6e90 \u8fd0\u884c\u72b6\u6001\u53ca\u5173\u952e\u6307\u6807(\u5982 CPU\u3001\u5185 \u5b58\u3001\u7f51\u5361\u3001\u78c1\u76d8\u7b49\u8d44\u6e90)\u7528\u91cf\u5c55\u793a \u548c\u53d1\u5e03\u529f\u80fd\u3002;","created_by":1013,"created_at":"2023-08-04 15:34:05","updated_at":"2024-03-22 17:15:10","pinyin_shortcut":"ZStackCloudyptV40qybyjxk","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":53,"key":53,"name":"\u4e91\u5e73\u53f0\u7ba1\u7406\u8f6f\u4ef6"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":1262,"key":1262,"name":"ZStack Cloud \u4e91\u5e73\u53f0 V4.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1748,"erp_sales_order_id":1534,"erp_store_id":null,"product_id":965,"description":"","number":"8","outbound":"0","amount":"4500.00","total_amount":"36000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3750.00","total_cost":"30000","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null}},{"id":10333,"project_id":3874,"product_id":968,"amount":"500.00","number":192,"cost":"297.00","description":"","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null,"total_amount":"96000","total_cost":"57024","erp_sales_order_product_id":1749,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":968,"name":"ZStack \u5206\u5e03\u5f0f\u5b58\u50a8V3.0 \u65d7\u8230\u7248","product_type":7,"product_component":65,"product_brand":138,"product_serie":606,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-04 15:41:52","updated_at":"2024-03-06 13:59:26","pinyin_shortcut":"ZStackfbsccV30qjb","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":65,"key":65,"name":"\u5206\u5e03\u5f0f\u5b58\u50a8\u8f6f\u4ef6"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":606,"key":606,"name":"ZStack \u5206\u5e03\u5f0f\u5b58\u50a8V3.0 \u65d7\u8230\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1749,"erp_sales_order_id":1534,"erp_store_id":null,"product_id":968,"description":"","number":"192","outbound":"0","amount":"500.00","total_amount":"96000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"297.00","total_cost":"57024","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null}},{"id":10334,"project_id":3874,"product_id":2034,"amount":"64000.00","number":1,"cost":"40000.00","description":"","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null,"total_amount":"64000","total_cost":"40000","erp_sales_order_product_id":1750,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":2034,"name":"ZStack CMP\u591a\u4e91\u7ba1\u7406\u5e73\u53f0V4.0(\u9ad8\u7ea7\u7248 (\u6c38\u4e45\u8bb8\u53ef))","product_type":7,"product_component":53,"product_brand":138,"product_serie":1262,"product_misc":null,"product_qa":null,"pn":"","description":"\u652f\u6301\u540c\u65f6\u7eb3\u7ba1\u5305\u62ec\u4f46\u4e0d\u9650\u4e8e ZStack CMP \u652f\u6301\u7684\u6240\u6709\u4e91\u5e73\u53f0, \u5e76\u5305\u542b\u9996\u5e74 7*24 \u7ef4\u4fdd\u3002","created_by":1013,"created_at":"2025-07-08 14:58:07","updated_at":"2025-07-08 14:58:07","pinyin_shortcut":"ZStackCMPdyglptV40gjbyjxk","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":53,"key":53,"name":"\u4e91\u5e73\u53f0\u7ba1\u7406\u8f6f\u4ef6"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":1262,"key":1262,"name":"ZStack Cloud \u4e91\u5e73\u53f0 V4.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1750,"erp_sales_order_id":1534,"erp_store_id":null,"product_id":2034,"description":"","number":"1","outbound":"0","amount":"64000.00","total_amount":"64000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"40000.00","total_cost":"40000","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null}},{"id":10335,"project_id":3874,"product_id":2033,"amount":"20000.00","number":1,"cost":"13246.00","description":"","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null,"total_amount":"20000","total_cost":"13246","erp_sales_order_product_id":1751,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":2033,"name":"ZStack Cloud\u4e91\u5e73\u53f0V4.0(\u79df\u6237\u7ba1\u7406\u6a21\u5757)","product_type":7,"product_component":53,"product_brand":138,"product_serie":1262,"product_misc":null,"product_qa":null,"pn":"","description":"ZStack Cloud \u4e91\u5e73\u53f0\u9ad8\u7ea7\u6a21\u5757- \u79df\u6237\u7ba1\u7406\u6a21\u5757:1\u3001\u63d0\u4f9b\u4e91\u5e73\u53f0\u79df\u6237 \u7ba1\u7406\u80fd\u529b,\u53ef\u4ee5\u9488\u5bf9\u7528\u6237\u8d4b\u4e88\u89d2\u8272 \u6743\u9650,\u652f\u6301\u57fa\u4e8e\u8d44\u6e90\u7684\u56fe\u5f62\u754c\u9762\u6743 \u9650\u7ba1\u63a7,\u7ba1\u63a7\u7c92\u5ea6\u53ef\u8fbe\u9875\u9762\u548c\u6309\u94ae;2\u3001\u63d0\u4f9b\u7ec4\u7ec7\u67b6\u6784\u7ba1\u7406,\u901a\u8fc7\u7ec4\u7ec7\u67b6 \u6784\u7684\u5212\u5206,\u63d0\u4f9b\u548c\u884c\u653f\u90e8\u95e8\u4e00\u6837\u7684 \u7ba1\u7406\u6548\u679c,\u6700\u5927\u7a0b\u5ea6\u4e0a\u51cf\u8f7b\u7ba1\u7406\u7684 \u6210\u672c,\u652f\u6301\u81ea\u5b9a\u4e49\u7ec4\u7ec7\u67b6\u6784\u5e76\u4ee5\u7ec4 \u7ec7\u67b6\u6784\u6811\u7684\u65b9\u5f0f\u5448\u73b0,\u7075\u6d3b\u5339\u914d\u7ec4 \u7ec7\u7ba1\u7406\u9700\u6c42;3\u3001\u652f\u6301\u5de5\u5355\u5ba1\u6279,\u6210 \u5458\u901a\u8fc7\u5de5\u5355\u7533\u8bf7\u4e91\u4e3b\u673a,\u7ba1\u7406\u5458\u5ba1 \u6279\u901a\u8fc7\u540e\u81ea\u52a8\u5f00\u901a\u4e91\u4e3b\u673a\u5e76\u4ea4\u4ed8\u7ed9 \u6210\u5458,\u652f\u6301\u5ba1\u6279\u8fc7\u7a0b\u6d41\u7a0b\u7684\u81ea\u5b9a\u4e49, \u6ee1\u8db3\u591a\u7ea7\u5ba1\u6279\u7684\u9700\u6c42;4\u3001\u652f\u6301\u5206\u89e3 \u8d85\u7ea7\u7ba1\u7406\u5458\u7684\u8d85\u7ea7\u6743\u9650,\u5e73\u53f0\u7684\u8d44 \u6e90\u7ba1\u7406\u3001\u6743\u9650\u7ba1\u7406\u3001\u5ba1\u8ba1\u7ba1\u7406\u5206\u522b \u7531\u4e0d\u540c\u7ba1\u7406\u5458\u8d1f\u8d23\u3002","created_by":1013,"created_at":"2025-07-08 14:56:32","updated_at":"2025-07-08 14:56:32","pinyin_shortcut":"ZStackCloudyptV40zhglmk","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":53,"key":53,"name":"\u4e91\u5e73\u53f0\u7ba1\u7406\u8f6f\u4ef6"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":1262,"key":1262,"name":"ZStack Cloud \u4e91\u5e73\u53f0 V4.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1751,"erp_sales_order_id":1534,"erp_store_id":null,"product_id":2033,"description":"","number":"1","outbound":"0","amount":"20000.00","total_amount":"20000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"13246.00","total_cost":"13246","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null}},{"id":10336,"project_id":3874,"product_id":2035,"amount":"6000.00","number":2,"cost":"5000.00","description":"","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null,"total_amount":"12000","total_cost":"10000","erp_sales_order_product_id":1752,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":2035,"name":"\u9879\u76ee\u5b9e\u65bd\u670d\u52a1\uff08\u8f6f\u4ef6\u5b9e\u65bd\uff09","product_type":19,"product_component":151,"product_brand":138,"product_serie":1009,"product_misc":null,"product_qa":null,"pn":"","description":"\u670d\u52a1\u5185\u5bb9:\u8d1f\u8d23 ZStack Cloud \u8f6f \u4ef6\u5728\u7532\u65b9\u5df2\u4e0a\u67b6\u670d\u52a1\u5668\u4e0a\u7684\u5b89\u88c5\u90e8 \u7f72,\u57fa\u7840\u529f\u80fd\u57f9\u8bad\u3002","created_by":1013,"created_at":"2025-07-08 14:59:11","updated_at":"2025-07-08 14:59:11","pinyin_shortcut":"xmssfwrjss","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":1009,"key":1009,"name":"\u6280\u672f\u652f\u6301\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1752,"erp_sales_order_id":1534,"erp_store_id":null,"product_id":2035,"description":"","number":"2","outbound":"0","amount":"6000.00","total_amount":"12000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5000.00","total_cost":"10000","supplier_id":68,"hardware_from":null,"software_from":"2025-07-10","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-10","maintenance_to":null}}],"commentCount":{"object_id":3874,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1087,"project_id":3874,"contact_id":4137,"point":"27700.00","paid_point":null,"contact":{"id":4137,"key":4137,"name":"\u9a6c\u6653\u5149","client_id":null,"supplier_id":479,"client":null,"supplier":{"id":479,"key":479,"name":"\u4e0a\u6d77\u4e91\u8f74\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":{"id":1534,"serial_no":"XSDD-20250722-00001","from_date":null,"wrote_date":"2025-06-27","handler":1004,"client_id":3377,"purchase_contract_id":null,"project_id":3874,"sales_contract_id":4016,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"204","amount":"228000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-08 13:11:57","updated_at":"2025-07-08 13:11:57"},"projectUsedClient":{"id":136,"project_id":3874,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":64,"progress_remain_display":70,"forecast_remain_display":104,"projectProductTotalAmount":228000,"projectProductAllAmount":true,"projectProductTotalCost":150270,"projectProductAllCost":true,"projectProductTotalNumber":204,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":104,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"22.8\u4e07","contact_points_status_display":"\u672a\u6838\u9500","verify_display":0,"un_collected":"193800","un_invoiced":0},{"id":3934,"client_id":3387,"project_status":3,"project_progress":9,"budget":"114632","profit_pct":"20","bargain_date":"2025-07-28","description":"","created_by":1005,"created_at":"2025-07-28 17:36:41","updated_at":"2025-09-03 16:40:42","engineer_id":null,"project_title":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","collected":"0","status_updated_at":"2025-07-28 17:38:30.407066+08","success_rate":null,"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":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":966,"is_sales_order_ready":false,"collected_plan":114632,"change_status_to":null,"is_verify":false,"profits":"22926.4000000000000000","remain":"43 days 21:59:55.039159","progress_remain":"43 days 22:01:44.093605","forecast_remain":"43 days 22:01:44.093605","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"43 days 22:01:44.093605","issued_invoices":null,"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005,"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"}},"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"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"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","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4071,"from_project":3934,"payment_collection_remind_ahead":"1 day","serial_no":"JACG20250006","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"114632","including_tax":true,"amount":"114632","contractScans":[{"id":36106,"object_type":105,"object_id":4071,"attachment_id":27140,"attachment":{"id":27140,"key":27140,"name":"f17dfc8f-7828-350d-8f62-899a0db50051","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/f17dfc8f-7828-350d-8f62-899a0db50051\/2025_07_28_17_42_26.pdf","orig_name":"2025_07_28_17_42_26.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2534,"key":2534,"contract_id":4071,"name":"2025-09-28","value":"57316","overdue_days":null,"pct":50,"collect_status":""},{"id":2535,"key":2535,"contract_id":4071,"name":"2025-09-30","value":"34389","overdue_days":null,"pct":30,"collect_status":""},{"id":2536,"key":2536,"contract_id":4071,"name":"2026-01-31","value":"22927","overdue_days":null,"pct":20,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":8770,"user_id":1005,"key":1005,"contract_id":4071,"user":{"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":10583,"project_id":3934,"product_id":1485,"amount":"4000.00","number":6,"cost":"1920.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"24000","total_cost":"11520","erp_sales_order_product_id":1822,"supplier":null,"product":{"id":1485,"name":"DS V20.0 \u65e0\u4ee3\u7406forVMware \u9632\u75c5\u6bd2\u6a21\u5757\u4fdd\u5185\u7eed\u4fdd \u670d\u52a1","product_type":7,"product_component":32,"product_brand":18,"product_serie":1253,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94 \u7528\u8f6f DeepSecurity V20.0\uff08\u7eed\u4fdd\u670d\u52a1\uff09","created_by":1013,"created_at":"2024-03-05 16:45:41","updated_at":"2024-03-05 16:45:41","pinyin_shortcut":"DSV200wdlforVMwarefbdmkbnxbfw","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":1253,"key":1253,"name":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6DeepSecurity V20.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1822,"erp_sales_order_id":1558,"erp_store_id":null,"product_id":1485,"description":"","number":"6","outbound":"0","amount":"4000.00","total_amount":"24000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1920.00","total_cost":"11520","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10584,"project_id":3934,"product_id":1484,"amount":"5580.00","number":1,"cost":"5400.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"5580","total_cost":"5400","erp_sales_order_product_id":1823,"supplier":null,"product":{"id":1484,"name":"DS V20.0 \u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u7ba1\u7406\u5e73\u53f0\u4fdd\u5185\u7eed\u4fdd\u670d\u52a1","product_type":7,"product_component":32,"product_brand":18,"product_serie":1254,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\n\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6 Deep Security \nV20.0\uff08\u7eed\u4fdd\u670d\u52a1\uff09","created_by":1013,"created_at":"2024-03-05 16:43:03","updated_at":"2024-03-05 16:43:03","pinyin_shortcut":"DSV200aqfhxtglptbnxbfw","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":1254,"key":1254,"name":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6 Deep Security V20.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1823,"erp_sales_order_id":1558,"erp_store_id":null,"product_id":1484,"description":"","number":"1","outbound":"0","amount":"5580.00","total_amount":"5580","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5400.00","total_cost":"5400","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10585,"project_id":3934,"product_id":1483,"amount":"2000.00","number":6,"cost":"1280.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"12000","total_cost":"7680","erp_sales_order_product_id":1824,"supplier":null,"product":{"id":1483,"name":"DS V20.0 \u6709\u4ee3\u7406\u5ba2\u6237\u7aef\u9632\u75c5\u6bd2\u6a21\u5757\u7eed\u4fdd\u670d\u52a1","product_type":7,"product_component":32,"product_brand":18,"product_serie":1253,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6DeepSecurity V20.0\uff08\u7eed\u4fdd\u670d\u52a1\uff09","created_by":1013,"created_at":"2024-03-05 16:41:56","updated_at":"2024-03-05 16:41:56","pinyin_shortcut":"DSV200ydlkhdfbdmkxbfw","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":1253,"key":1253,"name":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6DeepSecurity V20.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1824,"erp_sales_order_id":1558,"erp_store_id":null,"product_id":1483,"description":"","number":"6","outbound":"0","amount":"2000.00","total_amount":"12000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1280.00","total_cost":"7680","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10586,"project_id":3934,"product_id":1511,"amount":"14730.00","number":2,"cost":"10500.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"29460","total_cost":"21000","erp_sales_order_product_id":1825,"supplier":null,"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1825,"erp_sales_order_id":1558,"erp_store_id":null,"product_id":1511,"description":"","number":"2","outbound":"0","amount":"14730.00","total_amount":"29460","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"10500.00","total_cost":"21000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10587,"project_id":3934,"product_id":941,"amount":"43592.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"43592","total_cost":"0","erp_sales_order_product_id":1826,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1826,"erp_sales_order_id":1558,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"43592.00","total_amount":"43592","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3934,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1558,"serial_no":"XSDD-20250729-00001","from_date":null,"wrote_date":"2025-07-28","handler":1005,"client_id":3387,"purchase_contract_id":null,"project_id":3934,"sales_contract_id":4071,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"16","amount":"114632","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-28 17:38:30","updated_at":"2025-07-28 17:38:30"},"projectUsedClient":{"id":170,"project_id":3934,"used_client":25,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":{"id":25,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821","abbr":null,"pinyin_shortcut":"bjshdqjsjxxx","description":"","corp_rep":"\u7f57\u6ee8","website":"","capital":"5","established_at":null,"headcount":"","reg_address":43,"working_address":1299,"telephone":"","fax":"","scale":"","branch":"\u5317\u4eac\u4e09\u6625\u6656\u6559\u80b2\u670d\u52a1\u54a8\u8be2\u4e2d\u5fc3","purchase_scale_per_yr":null,"purchase_freq":"","company_nature":3,"client_class":47,"client_industry":2,"client_type":1,"sales_rep":1005,"main_contact":null,"created_by":1006,"created_at":"2017-02-09 16:54:27","updated_at":"2025-08-31 22:22:10","main_business":"\u6d77\u6dc0\u533a\u6559\u5e08\u57f9\u8bad","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-11-30 19:24:22","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"\u8d1f\u8d23\u5168\u533a\u5404\u5b66\u79d1\u8bfe\u7a0b\u53d1\u5c55\u3001\u6559\u80b2\u6559\u5b66\u7814\u7a76\u5de5\u4f5c;\u8d1f\u8d23\u914d\u5408\u6559\u80b2\u884c\u653f\u90e8\u95e8\u505a\u597d\u5168\u533a\u4e2d\u5c0f\u5b66\u6559\u5e08\u3001\u5e7c\u513f\u56ed\u6559\u5e08\u7ee7\u7eed\u6559\u80b2\u7ec4\u7ec7\u548c\u670d\u52a1\u5de5\u4f5c,\u627f\u62c5\u5168\u533a\u4e2d\u5c0f\u5b66\u548c\u5e7c\u513f\u56ed\u6559\u5e08\u3001\u5e72\u90e8\u7684\u4e13\u4e1a\u5316\u57f9\u8bad\u4efb\u52a1\u53ca\u57f9\u8bad\u8bfe\u7a0b\u8d44\u6e90\u7684\u5efa\u8bbe\u5de5\u4f5c;\u914d\u5408\u6709\u5173\u90e8\u95e8\u5f00\u5c55\u5bf9\u5404\u5b66\u6821\u8bfe\u5802\u6559\u5b66\u8d28\u91cf\u60c5\u51b5\u53ca\u5404\u5b66\u6bb5\u5b66\u4e1a\u6c34\u5e73\u7684\u8bc4\u4ef7\u3002","client_base_info_count":4,"client_key_info_count":2,"contact_count":2,"visit_count":1,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":null,"tax_no":null},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":43,"progress_remain_display":43,"forecast_remain_display":43,"projectProductTotalAmount":114632,"projectProductAllAmount":true,"projectProductTotalCost":45600,"projectProductAllCost":true,"projectProductTotalNumber":16,"unissued_invoice":114632,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":43,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"11.46\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"114632","un_invoiced":114632},{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":null,"created_by":1001,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-03 15:40:10","engineer_id":null,"project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":null,"comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":null,"from_contact":5912,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":true,"profits":"77000.000000000000000000","remain":"6 days 23:58:15.145708","progress_remain":"20 days 03:11:29.979572","forecast_remain":"20 days 03:11:29.979572","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"13 days 20:54:11.184413","issued_invoices":null,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":18,"sales_rep":1001,"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"}},"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":18,"key":18,"name":"\u5a92\u4f53"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"80000","pct":"96.25","profit":"77000","project_id":3950}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"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"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4131,"from_project":3950,"payment_collection_remind_ahead":"1 day","serial_no":"2025-09-03-001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"80000","erp_un_settle_amount":"0","including_tax":true,"amount":"80000","contractScans":[],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12021","key":"12021","contract_id":4131,"value":"80000","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":100}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8889,"user_id":1001,"key":1001,"contract_id":4131,"user":{"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":10725,"project_id":3950,"product_id":2095,"amount":"26666.66","number":3,"cost":"1000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"80000.00","total_cost":"3000.00","erp_sales_order_product_id":1874,"supplier":null,"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1874,"erp_sales_order_id":1576,"erp_store_id":null,"product_id":2095,"description":"","number":"3","outbound":"2","amount":"26666.66","total_amount":"80000.00","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1000","total_cost":"3000.00","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3950,"comment":3},"unreadComments":null,"fromContact":{"id":5912,"key":5912,"name":"\u97e9\u5f66\u5e73","client_id":null,"supplier_id":511,"mobiles":[],"client":null,"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1576,"serial_no":"XSDD-20250903-00001","from_date":null,"wrote_date":"2025-08-21","handler":1001,"client_id":3389,"purchase_contract_id":null,"project_id":3950,"sales_contract_id":4131,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-03 15:41:50","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"3","amount":"80000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-03 15:40:10","updated_at":"2025-09-03 15:41:50"},"projectUsedClient":{"id":184,"project_id":3950,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":6,"progress_remain_display":20,"forecast_remain_display":20,"projectProductTotalAmount":80000,"projectProductAllAmount":true,"projectProductTotalCost":3000,"projectProductAllCost":true,"projectProductTotalNumber":3,"unissued_invoice":80000,"is_exceeded":false,"can_update":false,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":13,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"8\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":3,"un_collected":"0","un_invoiced":80000},{"id":3716,"client_id":149,"project_status":3,"project_progress":9,"budget":"40800","profit_pct":"93","bargain_date":"2024-11-11","description":"","created_by":1005,"created_at":"2024-11-15 10:46:08","updated_at":"2025-09-01 11:31:38","engineer_id":null,"project_title":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1","collected":"0","status_updated_at":"2024-11-15 10:51:23.279866+08","success_rate":null,"comment":"DELLT630+oracle\u670d\u52a1","contract_type":2,"progress_updated_at":"2024-11-15 10:46:08.601395+08","forecast_updated_at":"2024-11-15 10:46:08.601395+08","end_at":"","pinyin_shortcut":"lk2425ndjsfw","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":674,"is_sales_order_ready":true,"collected_plan":40800,"change_status_to":null,"is_verify":false,"profits":"37944.0000000000000000","remain":"299 days 04:47:02.166359","progress_remain":"299 days 04:52:16.84483","forecast_remain":"299 days 04:52:16.84483","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"299 days 04:52:16.84483","issued_invoices":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","logo":null,"client_type":1,"client_class":47,"client_industry":1,"sales_rep":1005,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"40800.00","pct":"93","profit":"37944","project_id":3716}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"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"}},"projectCreator":{"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"}},"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"}},"casePoints":{"project_id":3716,"points":"1566"},"workLogCount":null,"caseCount":{"project_id":3716,"count":16},"salesTimeCount":null,"implementTimeCount":{"project_id":3716,"sum":"40.7","times":"15"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3716,"sum":"422.08"},"buildContract":{"id":3665,"from_project":3716,"payment_collection_remind_ahead":"7 days","serial_no":"FZ-2024-126-ZZ022","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"0","erp_un_settle_amount":"40800","including_tax":true,"amount":"40800","contractScans":[{"id":31340,"object_type":105,"object_id":3665,"attachment_id":22711,"attachment":{"id":22711,"key":22711,"name":"cdc657d5-6326-3e03-8a2b-5d7e25c7d248","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/cdc657d5-6326-3e03-8a2b-5d7e25c7d248\/\u516c\u5b89\u90e8\u4e00\u624040800\u5143\u5408\u540c.pdf","orig_name":"\u516c\u5b89\u90e8\u4e00\u624040800\u5143\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2223,"key":2223,"contract_id":3665,"name":"2025-11-30","value":"40800","overdue_days":null,"pct":100,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":7470,"user_id":1005,"key":1005,"contract_id":3665,"user":{"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"}}},{"id":7471,"user_id":5388,"key":5388,"contract_id":3665,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7472,"user_id":1001,"key":1001,"contract_id":3665,"user":{"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"}}}],"salesSupplierRels":[{"id":3098,"contract_id":3665,"supplier_id":262,"purchase_id":4089,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4089,"key":4089,"serial_no":"\u8ba2\u5355\u53f7\uff1a 332141569190"}},{"id":3119,"contract_id":3665,"supplier_id":608,"purchase_id":4096,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4096,"key":4096,"serial_no":"\u8ba2\u5355\u53f7: 4681584829670161702"}}],"payment_collection_remind_ahead_display":"7\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":8211,"project_id":3716,"product_id":941,"amount":"40800","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-11-15","hardware_to":null,"software_to":null,"maintenance_to":"2025-11-14","total_amount":"40800","total_cost":"0","erp_sales_order_product_id":1387,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1387,"erp_sales_order_id":1389,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"40800","total_amount":"40800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-11-15","hardware_to":null,"software_to":null,"maintenance_to":"2025-11-14"}}],"commentCount":{"object_id":3716,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1389,"serial_no":"XSDD-20250806-00001","from_date":null,"wrote_date":"2024-11-11","handler":1005,"client_id":149,"purchase_contract_id":null,"project_id":3716,"sales_contract_id":3665,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"40800","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-11-15 10:51:23","updated_at":"2024-11-15 10:51:23"},"projectUsedClient":null,"remain_display":299,"progress_remain_display":299,"forecast_remain_display":299,"projectProductTotalAmount":40800,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":40800,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":299,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"4.08\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"40800","un_invoiced":40800}],"pagenation":{"totalcount":2946,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 15:38:25') RETURNING "id"
15:38:25.403	2.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
15:38:25.528	2.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by" 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 (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111) ORDER BY "id" DESC
15:38:25.520	2.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111))
15:38:25.523	1.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111))
15:38:25.401	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:38:25.525	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111))
15:38:25.517	1.5 ms	yii\db\Command::query	SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "project_id"
15:38:25.407	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:38:25.515	1.2 ms	yii\db\Command::query	SELECT "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 (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "c"."project_id"
15:38:25.508	1.0 ms	yii\db\Command::query	SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716) GROUP BY "project_id"
15:38:25.527	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111)) ORDER BY "id" DESC
15:38:25.583	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716))
15:38:25.519	0.8 ms	yii\db\Command::query	SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.500	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1661, 3278, 2166, 3286, 2130, 304, 3377, 3387, 3389, 149)
15:38:25.492	0.7 ms	yii\db\Command::query	SELECT "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 (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716) ORDER BY "contribution" DESC, "engineer_id"
15:38:25.494	0.7 ms	yii\db\Command::query	SELECT 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 (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.537	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.581	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (1262, 5912, 5957)
15:38:25.538	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (965, 968, 2034, 2033, 2035, 2100, 969, 1586, 1657, 1485, 1484, 1483, 1511, 941, 2095, 1624)
15:38:25.542	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (1748, 1749, 1750, 1751, 1752, 1857, 969, 970, 971, 1822, 1823, 1824, 1825, 1826, 1387, 1874, 1860, 1875, 1861)
15:38:25.495	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (184, 189, 2, 165, 167, 166, 226, 5, 1, 175, 185, 192, 136, 191, 348, 2100000000, 232, 181, 160, 349, 369, 130, 128, 142, 340, 326, 356, 164, 172)) ORDER BY "sort"
15:38:25.531	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111) ORDER BY "id"
15:38:25.532	0.5 ms	yii\db\Command::query	SELECT "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 (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111) ORDER BY "remind_date"
15:38:25.488	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1661, 3278, 2166, 3286, 2130, 304, 3377, 3387, 3389, 149)
15:38:25.495	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.534	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111)
15:38:25.580	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (1262, 5957, 5912)
15:38:25.533	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4071, 3364, 3665, 4016, 1558, 4132, 4131, 4112, 4111)
15:38:25.509	0.4 ms	yii\db\Command::query	SELECT "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 (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "project_id"
15:38:25.490	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
15:38:25.522	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5271, 19980, 22711, 26741, 27140, 27760, 27758, 27759)
15:38:25.507	0.4 ms	yii\db\Command::query	SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "project_id"
15:38:25.536	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (1559, 4089, 4096, 3365, 4017, 4128, 4122, 4133)
15:38:25.535	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (365, 262, 608, 90, 68, 725, 431)
15:38:25.517	0.4 ms	yii\db\Command::query	SELECT "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 (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)) GROUP BY "project_id"
15:38:25.496	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.541	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1240, 1262, 1359, 1243, 1009, 592, 607, 606, 1253, 1254, 1691, 1382)
15:38:25.582	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.585	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=25
15:38:25.497	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.584	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.499	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
15:38:25.583	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((4137, 3874), (1262, 3577))
15:38:25.540	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (30, 53, 35, 36, 151, 26, 159, 65, 32, 14)
15:38:25.586	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (170, 136, 179, 180, 184, 185, 186)
15:38:25.539	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 5, 19, 3)
15:38:25.491	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 47, 80)
15:38:25.540	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (16, 138, 8, 133, 261, 18, 27)
15:38:25.489	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5300, 1004, 5295, 5087)
15:38:25.497	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (184, 189, 2, 165, 167, 166, 226, 5, 1, 175, 185, 192, 136, 191, 348, 2100000000, 232, 181, 160, 349, 369, 130, 128, 142, 340, 326, 356, 164, 172)) ORDER BY "sort"
15:38:25.493	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 2)
15:38:25.498	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (184, 189, 2, 165, 167, 166, 226, 5, 1, 175, 185, 192, 136, 191, 348, 2100000000, 232, 181, 160, 349, 369, 130, 128, 142, 340, 326, 356, 164, 172)) ORDER BY "sort"
15:38:25.492	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
15:38:25.541	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 7, 1)
15:38:25.490	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 1, 6)
15:38:25.587	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (170, 136, 179, 180, 184, 185, 186)
15:38:25.586	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (170, 136, 179, 180, 184, 185, 186)
15:38:25.493	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (49, 9, 4, 6, 2)
15:38:25.536	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (1791, 3577, 3955, 3927, 3957, 3947, 3874, 3934, 3950, 3716)
15:38:25.586	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (170, 136, 179, 180, 184, 185, 186)
15:38:25.491	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 1, 18, 5)
15:38:25.498	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300, 5087, 5295, 1004, 1005)
15:38:25.531	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5388, 1013)
15:38:25.534	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1001, 1011, 1005, 1004, 5295, 5087)
15:38:25.498	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
15:38:25.499	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300, 1011, 5087, 5295, 1004, 1005)
15:38:25.500	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5295, 1005, 5087, 1004, 5300))
15:38:25.582	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4137, 1262)
15:38:25.501	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5300, 1004, 5295, 5087)
15:38:25.534	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5295, 1005, 5388, 5087, 1004))
15:38:25.537	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
15:38:25.581	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (100, 511)
15:38:25.537	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005))
15:38:25.538	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (68, 90)
15:38:25.525	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5320, 20715, 27072)
15:38:25.501	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
15:38:25.583	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (100, 479)
15:38:25.532	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=5400