Performance Profiling

Total processing time: 307 ms; Peak memory: 6.036 MB. Show Profiling Timeline

总计60条数据

Time	Duration	Category	Info

10:21:46.477	27.8 ms	yii\db\Command::query	SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)) GROUP BY "object_id"
10:21:46.580	20.4 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)) GROUP BY "object_id"
10:21:46.608	16.1 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', 5295, 2, 1143, 'v2/sales-contract/list', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1753410048","token":"ab92681937c5fea34b566da21d0c0051","version_code":"1143"}', '{"code":200,"data":{"list":[{"id":3830,"client_id":2032,"signed_at":"2025-03-17","amount":"615615","handler":5295,"description":"","created_by":5250,"created_at":"2025-04-11 11:00:39","updated_at":"2025-04-11 11:00:39","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3800,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":null,"from_project":3800,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2025-06-28 17:41:05.610438+08","b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":null,"project":{"id":3800,"key":3800,"name":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd"},"fromProject":{"id":3800,"key":3800,"name":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":807,"bargain_date":"2025-03-17","collected":"0","profit_pct":"19.98","budget":"615615","projectProductTypes":[{"id":6265,"product_type_id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","budget":"123123","pct":"0","project_id":3800,"profit":"0"},{"id":6266,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"246246","pct":"0","project_id":3800,"profit":"0"},{"id":6267,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"123123","pct":"0","project_id":3800,"profit":"0"},{"id":6268,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"123123","pct":"99.9","project_id":3800,"profit":"122999.877"}],"projectProductRels":[{"id":9039,"project_id":3800,"product_id":1956,"amount":"123123.00","number":1,"cost":"123.00","description":"","supplier_id":null,"hardware_from":"2025-04-17","software_from":"2025-04-23","maintenance_from":"2025-04-17","hardware_to":"2025-05-23","software_to":"2025-05-16","maintenance_to":"2025-05-22","total_amount":"123123","total_cost":"123","supplier":null,"product":{"id":1956,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6V6.0\uff08PC\u5168\u91cf\u7248\uff09","product_type":7,"product_component":41,"product_brand":12,"product_serie":1610,"product_misc":null,"product_qa":null,"pn":"","description":"\u6df1\u4fe1\u670d\u7edf\u4e00\u7aef\u70b9\u5b89\u5168\u7ba1\u7406\u7cfb\u7edfV6.0\uff08aES\uff09","created_by":1013,"created_at":"2025-03-10 09:19:22","updated_at":"2025-03-10 09:19:22","pinyin_shortcut":"sxfddaqrjV60PCqlb","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1610,"key":1610,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9040,"project_id":3800,"product_id":1954,"amount":"123123.00","number":1,"cost":"123123.00","description":"","supplier_id":null,"hardware_from":"2025-04-09","software_from":"2025-04-18","maintenance_from":"2025-04-18","hardware_to":"2025-05-16","software_to":"2025-05-07","maintenance_to":"2025-05-22","total_amount":"123123","total_cost":"123123","supplier":null,"product":{"id":1954,"name":"114-00087+C0","product_type":3,"product_component":39,"product_brand":6,"product_serie":1608,"product_misc":null,"product_qa":null,"pn":"","description":"NetApp FAS2XXX 750W\u7535\u6e90","created_by":1013,"created_at":"2025-03-06 10:01:07","updated_at":"2025-03-07 17:56:13","pinyin_shortcut":"11400087C0","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1608,"key":1608,"name":"NetApp FAS\u7cfb\u5217\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":9041,"project_id":3800,"product_id":1955,"amount":"123123.00","number":1,"cost":"123123.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":"123123","total_cost":"123123","supplier":null,"product":{"id":1955,"name":"NVIDIA RTX A4090","product_type":10,"product_component":199,"product_brand":208,"product_serie":1609,"product_misc":null,"product_qa":null,"pn":"","description":"NVIDIA RTX A4090 48G \u663e\u5361","created_by":1013,"created_at":"2025-03-07 14:01:45","updated_at":"2025-03-07 14:01:45","pinyin_shortcut":"NVIDIARTXA4090","product_unit":3,"is_renew":false,"productType":{"id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},"productComponent":{"id":199,"key":199,"name":"\u5de5\u4f5c\u7ad9\u914d\u4ef6"},"productBrand":{"id":208,"key":208,"name":"NVIDIA"},"productSerie":{"id":1609,"key":1609,"name":"NVIDIA RTX A4090 48G \u56fe\u5f62\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":9042,"project_id":3800,"product_id":1953,"amount":"123123.00","number":1,"cost":"123123.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":"123123","total_cost":"123123","supplier":null,"product":{"id":1953,"name":"CS5260H2","product_type":2,"product_component":2,"product_brand":24,"product_serie":627,"product_misc":null,"product_qa":null,"pn":"","description":"2\u6d77\u51495380 32\u6838 2.5G CPU\/432G\u5185\u5b58\/28T SATA\u786c\u76d8\/\u9635\u5217\u5361 PM8204 2G\/\u96c6\u6210\u53cc\u53e3\u5343\u5146\/2800W \u7535\u6e90","created_by":1013,"created_at":"2025-03-04 14:48:05","updated_at":"2025-03-04 14:48:05","pinyin_shortcut":"CS5260H2","product_unit":null,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":627,"key":627,"name":"CS5260H\u670d\u52a1\u5668"},"productUnit":null}},{"id":9043,"project_id":3800,"product_id":1952,"amount":"123123.00","number":1,"cost":"123123.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":"123123","total_cost":"123123","supplier":null,"product":{"id":1952,"name":"02311HAN","product_type":2,"product_component":5,"product_brand":7,"product_serie":1607,"product_misc":null,"product_qa":null,"pn":"","description":"1200GB-SAS 12Gb\/s-10K-128MB\u53ca\u4ee5\u4e0a-2.5\u82f1\u5bf8(2.5\u82f1\u5bf8\u6258\u67b6)","created_by":1013,"created_at":"2025-03-04 09:41:51","updated_at":"2025-03-04 09:41:51","pinyin_shortcut":"02311HAN","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1607,"key":1607,"name":"SAS\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":122999.877,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8071,"user_id":5295,"key":5295,"contract_id":3830,"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"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":615615,"projectProductAllAmount":true,"projectProductTotalCost":492615,"projectProductAllCost":true,"projectProductTotalCount":5,"invoiced":0,"un_invoiced":615615,"collected":0,"un_collected":615615,"is_collected":false,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3811,"client_id":531,"signed_at":"2025-03-05","amount":"3150","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 17:28:13","updated_at":"2025-03-12 13:59:08","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3791,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250305001","payment_collection_remind_ahead":"","from_project":3791,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-05 17:28:35.841072+08","b_date":null,"passed":1,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3811,"comment":8},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"},"fromProject":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025","description":"","total_contact_point":"880","paid_contact_point":"880","is_sales_order_ready":true,"project_product_version_id":797,"bargain_date":"2025-03-05","collected":"3150","profit_pct":"16.97","budget":"3150","projectProductTypes":[{"id":6097,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"3150.00","pct":"16.97","project_id":3791,"profit":"534.555"}],"projectProductRels":[{"id":8988,"project_id":3791,"product_id":542,"amount":"3150.00","number":1,"cost":"1300.00","description":"","supplier_id":678,"hardware_from":"2025-03-05","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-06","software_to":null,"maintenance_to":null,"total_amount":"3150","total_cost":"1300","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":542,"name":"00YK017","product_type":2,"product_component":5,"product_brand":4,"product_serie":1198,"product_misc":8,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2019-01-04 15:33:52","updated_at":"2024-11-20 14:45:21","pinyin_shortcut":"00YK017","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1198,"key":1198,"name":"1.8T 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[{"id":910,"project_id":3791,"contact_id":1188,"point":"880.00","paid_point":"880","contact":{"id":1188,"key":1188,"name":"\u5f20\u9a70","client_id":531,"supplier_id":null,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":172,"project_id":3791,"contact_id":1188,"point":"880.00","day_at":"2025-03-12","description":"","created_at":"2025-03-12 13:59:08"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12702,"project_id":3791}],"reimbursementAmountSum":null,"profit":534.555,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2499,"contract_id":3811,"supplier_id":678,"purchase_id":3814,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3814,"key":3814,"serial_no":"YTYG20250306"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8353,"user_id":5311,"key":5311,"contract_id":3811,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8032,"user_id":5300,"key":5300,"contract_id":3811,"user":{"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"}}},{"id":8033,"user_id":5388,"key":5388,"contract_id":3811,"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":8034,"user_id":1001,"key":1001,"contract_id":3811,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2353,"key":2353,"contract_id":3811,"name":"2025-03-21","value":"3150","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2131,"key":2131,"contract_id":3811,"value":"3150","created_by":1013,"created_at":"2025-03-10 11:16:35","description":"","collected_date":"2025-03-10","amount":"3150","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32762,"object_type":109,"object_id":2131,"attachment_id":24457,"attachment":{"id":24457,"key":24457,"name":"ebc27b61-a8f1-3743-a4db-9d0eb0fd512c","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/ebc27b61-a8f1-3743-a4db-9d0eb0fd512c\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1971,"key":1971,"contract_id":3811,"value":"3150.00","attachment_id":null,"from_date":"2025-03-07","attachment":null,"attachmentRelationships":[],"files":[{"id":32726,"object_type":102,"object_id":1971,"attachment_id":24432,"attachment":{"id":24432,"key":24432,"name":"dff9deda-3114-397c-95f4-432d3284169a","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/dff9deda-3114-397c-95f4-432d3284169a\/dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf","orig_name":"dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf"}}]},{"id":1978,"key":1978,"contract_id":3811,"value":"-3150.00","attachment_id":null,"from_date":"2025-03-14","attachment":null,"attachmentRelationships":[],"files":[{"id":32884,"object_type":102,"object_id":1978,"attachment_id":24541,"attachment":{"id":24541,"key":24541,"name":"38801acf-9469-312a-8a19-cb4c57246891","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/38801acf-9469-312a-8a19-cb4c57246891\/dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf","orig_name":"dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf"}}]},{"id":1979,"key":1979,"contract_id":3811,"value":"3150.00","attachment_id":null,"from_date":"2025-03-14","attachment":null,"attachmentRelationships":[],"files":[{"id":32899,"object_type":102,"object_id":1979,"attachment_id":24542,"attachment":{"id":24542,"key":24542,"name":"4974f2a1-62b1-32e9-ac1c-15fc300eb35c","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/4974f2a1-62b1-32e9-ac1c-15fc300eb35c\/dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf","orig_name":"dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf"}}]}],"contractScans":[{"id":32858,"object_type":105,"object_id":3811,"attachment_id":24403,"attachment":{"id":24403,"key":24403,"name":"6cc3b4ca-81f0-31e8-acd4-7f33b1c59fe9","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/6cc3b4ca-81f0-31e8-acd4-7f33b1c59fe9\/2025.3.5\u62d3\u5b9e\u79d1\u6280\u786c\u76d8.pdf","orig_name":"2025.3.5\u62d3\u5b9e\u79d1\u6280\u786c\u76d8.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":3150,"projectProductTotalAmount":3150,"projectProductAllAmount":true,"projectProductTotalCost":1300,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":3150,"un_invoiced":0,"collected":3150,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3805,"client_id":518,"signed_at":"2025-03-03","amount":"1200","handler":5295,"description":"","created_by":5295,"created_at":"2025-03-03 17:13:54","updated_at":"2025-03-05 09:27:13","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3788,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":3788,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-03 17:13:54.915446+08","b_date":null,"passed":1,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3805,"comment":5},"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8"},"fromProject":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":791,"bargain_date":"2025-03-03","collected":"0","profit_pct":"27","budget":"1200","projectProductTypes":[{"id":6051,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1200.00","pct":"27","project_id":3788,"profit":"324"}],"projectProductRels":[{"id":8908,"project_id":3788,"product_id":1951,"amount":"600.00","number":1,"cost":"400.00","description":"","supplier_id":59,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"600","total_cost":"400","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":1951,"name":"ST1000NM0055","product_type":3,"product_component":15,"product_brand":21,"product_serie":1606,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-03-04 09:37:06","updated_at":"2025-03-04 09:37:06","pinyin_shortcut":"ST1000NM0055","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":21,"key":21,"name":"\u5e0c\u6377"},"productSerie":{"id":1606,"key":1606,"name":"\u5e0c\u6377\u94f6\u6cb3 1TB 7.2K 3.5 SATA\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}},{"id":8909,"project_id":3788,"product_id":1952,"amount":"600.00","number":1,"cost":"400.00","description":"","supplier_id":59,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"600","total_cost":"400","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":1952,"name":"02311HAN","product_type":2,"product_component":5,"product_brand":7,"product_serie":1607,"product_misc":null,"product_qa":null,"pn":"","description":"1200GB-SAS 12Gb\/s-10K-128MB\u53ca\u4ee5\u4e0a-2.5\u82f1\u5bf8(2.5\u82f1\u5bf8\u6258\u67b6)","created_by":1013,"created_at":"2025-03-04 09:41:51","updated_at":"2025-03-04 09:41:51","pinyin_shortcut":"02311HAN","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1607,"key":1607,"name":"SAS\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12692,"project_id":3788},{"id":12691,"project_id":3788}],"reimbursementAmountSum":null,"profit":324,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2494,"contract_id":3805,"supplier_id":59,"purchase_id":3806,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":3806,"key":3806,"serial_no":"TGXC20250303-1"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2348,"key":2348,"contract_id":3805,"name":"2025-04-30","value":"1200","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f86\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":1977,"key":1977,"contract_id":3805,"value":"1200.00","attachment_id":null,"from_date":"2025-03-11","attachment":null,"attachmentRelationships":[],"files":[{"id":32804,"object_type":102,"object_id":1977,"attachment_id":24484,"attachment":{"id":24484,"key":24484,"name":"eebffb15-1d99-3001-8431-4acb8515fdad","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/eebffb15-1d99-3001-8431-4acb8515fdad\/dzfp_25112000000048056150_\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250311100246.pdf","orig_name":"dzfp_25112000000048056150_\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250311100246.pdf"}}]}],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":1200,"projectProductTotalAmount":1200,"projectProductAllAmount":true,"projectProductTotalCost":800,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":1200,"un_invoiced":0,"collected":0,"un_collected":1200,"is_collected":false,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3791,"client_id":3281,"signed_at":"2025-02-24","amount":"5869.5","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-24 11:10:34","updated_at":"2025-03-11 10:55:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3771,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025012003","payment_collection_remind_ahead":"1 day","from_project":3771,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-24 11:10:34.942465+08","b_date":null,"passed":1,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3791,"comment":6},"project":{"id":3771,"key":3771,"name":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9"},"fromProject":{"id":3771,"key":3771,"name":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":799,"bargain_date":"2025-02-24","collected":"5869.5","profit_pct":"12.79","budget":"5869.5","projectProductTypes":[{"id":6084,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"5869.5","pct":"12.79","project_id":3771,"profit":"750.70905"}],"projectProductRels":[{"id":8961,"project_id":3771,"product_id":1529,"amount":"5869.50","number":1,"cost":"4871.66","description":"","supplier_id":583,"hardware_from":null,"software_from":"2025-01-16","maintenance_from":null,"hardware_to":null,"software_to":"2025-02-16","maintenance_to":null,"total_amount":"5869.5","total_cost":"4871.66","supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1529,"name":"FCP-SUITE-CPU-Level1","product_type":7,"product_component":204,"product_brand":219,"product_serie":1319,"product_misc":null,"product_qa":null,"pn":"","description":"FCP-SUITE\u6388\u6743","created_by":1013,"created_at":"2024-03-26 16:14:31","updated_at":"2024-03-26 16:14:31","pinyin_shortcut":"FCPSUITECPULevel1","product_unit":3,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":204,"key":204,"name":"HPC\u8f6f\u4ef6"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1319,"key":1319,"name":"FCP-SUITE\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12707,"project_id":3771}],"reimbursementAmountSum":null,"profit":750.70905,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2484,"contract_id":3791,"supplier_id":583,"purchase_id":null,"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":null},{"id":2489,"contract_id":3791,"supplier_id":583,"purchase_id":3508,"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3508,"key":3508,"serial_no":"TS-ZHY-2024080501"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8015,"user_id":5295,"key":5295,"contract_id":3791,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2338,"key":2338,"contract_id":3791,"name":"2025-04-30","value":"5869.5","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2118,"key":2118,"contract_id":3791,"value":"5869.5","created_by":1013,"created_at":"2025-02-28 16:52:02","description":"","collected_date":"2025-02-28","amount":"5869.5","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32593,"object_type":109,"object_id":2118,"attachment_id":24339,"attachment":{"id":24339,"key":24339,"name":"1d74cb89-aa21-3c98-aaa1-c36c71fd366a","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/1d74cb89-aa21-3c98-aaa1-c36c71fd366a\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[],"contractScans":[{"id":32748,"object_type":105,"object_id":3791,"attachment_id":24265,"attachment":{"id":24265,"key":24265,"name":"1563673f-a4c5-3c35-8fdf-bcac264ebb9c","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/1563673f-a4c5-3c35-8fdf-bcac264ebb9c\/\u5bd2\u5e8f.pdf","orig_name":"\u5bd2\u5e8f.pdf"}}],"receiptScans":[{"id":32809,"object_type":106,"object_id":3791,"attachment_id":24487,"attachment":{"id":24487,"key":24487,"name":"0b6d791e-45af-3031-9885-aadb43f043ba","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/0b6d791e-45af-3031-9885-aadb43f043ba\/\u5bd2\u5e8f\u62d3\u5b9e-\u8d27\u7269\u7b7e\u6536\u5355-20250311.PDF","orig_name":"\u5bd2\u5e8f\u62d3\u5b9e-\u8d27\u7269\u7b7e\u6536\u5355-20250311.PDF"}}],"verifyScans":[],"unreadComments":null,"collected_plan":5869.5,"projectProductTotalAmount":5869.5,"projectProductAllAmount":true,"projectProductTotalCost":4871.66,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":5869.5,"collected":5869.5,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3797,"client_id":2546,"signed_at":"2025-02-21","amount":"10800","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-27 10:14:14","updated_at":"2025-03-03 17:57:51","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3785,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025022101","payment_collection_remind_ahead":"","from_project":3785,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":false,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3797,"comment":4},"project":{"id":3785,"key":3785,"name":"2025\u65b0\u8d2dUPS"},"fromProject":{"id":3785,"key":3785,"name":"2025\u65b0\u8d2dUPS","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":787,"bargain_date":"2025-02-21","collected":"0","profit_pct":"11.25","budget":"10800","projectProductTypes":[{"id":6042,"product_type_id":14,"key":14,"name":"UPS","budget":"10800.00","pct":"11.25","project_id":3785,"profit":"1215"}],"projectProductRels":[{"id":8894,"project_id":3785,"product_id":1946,"amount":"9800.00","number":1,"cost":"8655.00","description":"","supplier_id":618,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"9800","total_cost":"8655","supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1946,"name":"YTR3320-J","product_type":14,"product_component":149,"product_brand":231,"product_serie":1601,"product_misc":null,"product_qa":null,"pn":"","description":"\u9ad8\u9891\u4e3b\u673a\uff0c\u4e09\u8fdb\u4e09\u51fa\uff0c\u8f93\u5165\u7535\u538b\u8303\u56f4\uff1a138-485\uff08L-L\uff09\u300180-280\uff08L-N\uff09\uff0c\u8f93\u5165\u9891\u7387\u8303\u56f4\uff1a40-70\uff0850\/60\u7535\u7f51\u81ea\u9002\u5e94\uff09\uff0c\u8f93\u51fa\u989d\u5b9a\u7535\u538b\uff1a\u9ed8\u8ba4380\uff0c380\/400\/415\u00b11%(L-L)\uff0c\u8f93\u51fa\u9891\u7387(Hz)\uff1a50\/60\u00b10.1(\u7535\u6c60\u6a21\u5f0f)","created_by":1013,"created_at":"2025-02-28 10:19:41","updated_at":"2025-02-28 10:19:41","pinyin_shortcut":"YTR3320J","product_unit":1,"is_renew":false,"productType":{"id":14,"key":14,"name":"UPS"},"productComponent":{"id":149,"key":149,"name":"\u9ad8\u6027\u80fdUPS"},"productBrand":{"id":231,"key":231,"name":"\u79d1\u534e"},"productSerie":{"id":1601,"key":1601,"name":"YTR33-J\u7cfb\u5217UPS"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8895,"project_id":3785,"product_id":942,"amount":"1000.00","number":1,"cost":"500.00","description":"","supplier_id":618,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1000","total_cost":"500","supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12686,"project_id":3785},{"id":12685,"project_id":3785}],"reimbursementAmountSum":null,"profit":1215,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2456,"contract_id":3797,"supplier_id":618,"purchase_id":3800,"supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3800,"key":3800,"serial_no":"TSKJ20250228-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7950,"user_id":5295,"key":5295,"contract_id":3797,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2346,"key":2346,"contract_id":3797,"name":"2025-04-15","value":"10800","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f101\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32642,"object_type":105,"object_id":3797,"attachment_id":24311,"attachment":{"id":24311,"key":24311,"name":"13acc896-5ba7-3a32-9ade-9333734308aa","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/13acc896-5ba7-3a32-9ade-9333734308aa\/\u534e\u4e9a\u4e16\u7eaa\u5408\u540c.pdf","orig_name":"\u534e\u4e9a\u4e16\u7eaa\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":10800,"projectProductTotalAmount":10800,"projectProductAllAmount":true,"projectProductTotalCost":9155,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":0,"un_invoiced":10800,"collected":0,"un_collected":10800,"is_collected":false,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3795,"client_id":3333,"signed_at":"2025-02-21","amount":"2310000","handler":1005,"description":"","created_by":1005,"created_at":"2025-02-26 10:24:57","updated_at":"2025-02-26 11:58:32","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3783,"valid_date":null,"expire_date":"2028-02-21","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20250221-ZHY-001","payment_collection_remind_ahead":"1 day","from_project":3783,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2025-02-26 10:24:57.496964+08","b_date":941,"passed":2,"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"sales_rep":null,"salesRep":null},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3795,"comment":1},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355"},"fromProject":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":795,"bargain_date":"2025-02-21","collected":"0","profit_pct":"2","budget":"2310000","projectProductTypes":[{"id":6018,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"2310000.00","pct":"2","project_id":3783,"profit":"46200"}],"projectProductRels":[{"id":8916,"project_id":3783,"product_id":1941,"amount":"96000.00","number":3,"cost":"76286.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":"288000","total_cost":"228858","supplier":null,"product":{"id":1941,"name":"UnaDPM3036","product_type":2,"product_component":2,"product_brand":227,"product_serie":1599,"product_misc":null,"product_qa":null,"pn":"","description":"\u786c\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n1.\u89c4\u683c\uff1a4U36\u76d8\u4f4d\u673a\u7bb1,\u542b\u5bfc\u8f68 \n2.CPU\uff1a32\u6838\u9cb2\u9e4f920 2.6GHz2\uff1b \n3.\u5185\u5b58\uff1a128G DDR4 \n4.\u786c\u76d8\uff1aSSD\uff1a960G SSD2\uff1bSAS\uff1a3.5\u5bf8 7200RPM\/\u8fd1\u7ebf SAS(NL-SAS)30\uff08\u542b\u786c\u76d8\u67b6\uff09\n5.RAID\u5361\uff1a1G\u7f13\u5b58\u7684\u786cRAID\u53611.\u652f\u6301raid0,1,5, 6, 10, 50, 60\uff1b \n6.\u6389\u7535\u4fdd\u62a4\uff1a1G\u9635\u5217\u5361\u5bf9\u5e94\u6389\u7535\u4fdd\u62a4 \n7.\u5197\u4f59\u7535\u6e90\uff1b \n8.\u7f51\u7edc\u63a5\u53e3\uff1a2\u4e2a\u5343\u5146\u7535\u53e3\uff1b\n9.\u786c\u76d8\u4e0d\u8fd4\u8fd8\u670d\u52a1","created_by":1013,"created_at":"2025-02-26 10:58:31","updated_at":"2025-02-26 10:58:31","pinyin_shortcut":"UnaDPM3036","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1599,"key":1599,"name":"\u58f9\u8fdb\u5236\u670d\u52a1\u5668\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8917,"project_id":3783,"product_id":1942,"amount":"2022000.00","number":1,"cost":"1606742.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":"2022000","total_cost":"1606742","supplier":null,"product":{"id":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","product_type":7,"product_component":30,"product_brand":227,"product_serie":1600,"product_misc":null,"product_qa":null,"pn":"","description":"\"\u8f6f\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n64bit \u4f01\u4e1a\u7ea7 Linux \u5185\u6838\uff0c\u57fa\u4e8eWEB \u754c\u9762\u7684\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf \u8f6f\u4ef6\uff0c\u6807\u914d\u6587\u4ef6\/\u6570\u636e\u5e93\n\/Windows\/Linux\/\u865a\u62df\u5316\u5b9a\u65f6\u5907\u4efd\u529f\u80fd\u3002\n\u5bb9\u91cf\u6388\u6743\uff1a\nUnaRDP-1P\uff1a1P \u5b9a\u65f6\u5907\u4efd\u5bb9\u91cf\u6388\u6743\u3002\n\u9ad8\u7ea7\u529f\u80fd\u6388\u6743\uff1a\nUnaDedupe-LIC3\uff1a3\u4e2a\u91cd\u5220\u529f\u80fd \u6388\u6743\uff0c\u542b\u6e90\u7aef\u548c\u76ee\u6807\u7aef\u91cd\u5220\uff1b\u5b9e \u65f6\u5907\u4efd\u5bb9\u91cf\u4e0d\u652f\u6301\u91cd\u5220\u529f\u80fd\uff1bCDM \u529f\u80fd\u6253\u5f00\u65f6\u4ec5\u652f\u6301\u76ee\u6807\u7aef\u91cd\u5220\u3002\n(\u6ce8\uff1a\u5982\u679c\u9009\u62e9\u91cd\u5220\u529f\u80fd\uff0c\u5fc5\u987b\u589e \u914d RAID \u5361\u6389\u7535\u4fdd\u62a4)\u3002\nUnaD2D2R-LIC3\uff1a3\u4e2a\u4e24\u53f0\u9ed1\u65b9\u670d \u52a1\u5668\u4e4b\u95f4\u7684\u6570\u636e\u5f02\u5730\u540c\u6b65\u901a\u9053\u6388 \u6743\uff0c\u652f\u6301\u5c06\u672c\u5730\u9ed1\u65b9\u670d\u52a1\u5668\u4e2d\u5907 \u4efd\u6216\u5bb9\u707e\u6570\u636e\u96c6\u540c\u6b65\u81f3\u5f02\u5730\u9ed1\u65b9 \u670d\u52a1\u5668\u3002\u76ee\u7684\u7aef\u53ea\u9700\u786e\u4fdd\u914d\u7f6e\u57fa \u672c\u4ef6\uff0c\u65e0\u9700\u914d\u7f6e\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u3002\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u6570\u91cf\u7531\u6e90\u7aef\u7ba1\u7406\u63a7 \u5236\u53f0\u7684\u6570\u91cf\u51b3\u5b9a\u3002\"\n","created_by":1013,"created_at":"2025-02-26 11:00:56","updated_at":"2025-02-26 11:00:56","pinyin_shortcut":"yjzhfrzbfyhfxtrjV6","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1600,"key":1600,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3783,"sum":"123"},"profit":46200,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2480,"contract_id":3795,"supplier_id":685,"purchase_id":3821,"supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3821,"key":3821,"serial_no":"TSKJ20250305-ZHY-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7914,"user_id":1005,"key":1005,"contract_id":3795,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2342,"key":2342,"contract_id":3795,"name":"2025-03-26","value":"693000","overdue_days":null,"pct":30,"collect_status":"\u903e\u671f121\u5929"},{"id":2343,"key":2343,"contract_id":3795,"name":"2025-04-30","value":"1501500","overdue_days":null,"pct":65,"collect_status":"\u903e\u671f86\u5929"},{"id":2344,"key":2344,"contract_id":3795,"name":"2028-02-29","value":"115500","overdue_days":null,"pct":5,"collect_status":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32531,"object_type":105,"object_id":3795,"attachment_id":24293,"attachment":{"id":24293,"key":24293,"name":"98c9d421-1520-342e-92b2-c664cbb76842","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/98c9d421-1520-342e-92b2-c664cbb76842\/\u8d75\u6657\u7131-\u822a\u5929\u56db\u521b-2310000.pdf","orig_name":"\u8d75\u6657\u7131-\u822a\u5929\u56db\u521b-2310000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":2310000,"projectProductTotalAmount":2310000,"projectProductAllAmount":true,"projectProductTotalCost":1835600,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":0,"un_invoiced":2310000,"collected":0,"un_collected":2310000,"is_collected":false,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3808,"client_id":107,"signed_at":"2025-02-20","amount":"35100","handler":5295,"description":"","created_by":5295,"created_at":"2025-03-05 10:04:42","updated_at":"2025-03-14 17:31:54","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3777,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-20250220001","payment_collection_remind_ahead":"","from_project":3777,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-10 13:48:08.764799+08","b_date":null,"passed":1,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3808,"comment":7},"project":{"id":3777,"key":3777,"name":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K"},"fromProject":{"id":3777,"key":3777,"name":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K","description":"","total_contact_point":"2500","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":806,"bargain_date":"2025-02-20","collected":"35100","profit_pct":"53.56","budget":"35100","projectProductTypes":[{"id":6106,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"35100.00","pct":"53.56","project_id":3777,"profit":"18799.56"}],"projectProductRels":[{"id":8997,"project_id":3777,"product_id":1956,"amount":"390.00","number":90,"cost":"104.20","description":"","supplier_id":236,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"35100","total_cost":"9378","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1956,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6V6.0\uff08PC\u5168\u91cf\u7248\uff09","product_type":7,"product_component":41,"product_brand":12,"product_serie":1610,"product_misc":null,"product_qa":null,"pn":"","description":"\u6df1\u4fe1\u670d\u7edf\u4e00\u7aef\u70b9\u5b89\u5168\u7ba1\u7406\u7cfb\u7edfV6.0\uff08aES\uff09","created_by":1013,"created_at":"2025-03-10 09:19:22","updated_at":"2025-03-10 09:19:22","pinyin_shortcut":"sxfddaqrjV60PCqlb","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1610,"key":1610,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[{"id":913,"project_id":3777,"contact_id":533,"point":"2500.00","paid_point":null,"contact":{"id":533,"key":533,"name":"\u9ec4\u5411\u8363","client_id":107,"supplier_id":null,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":12710,"project_id":3777}],"reimbursementAmountSum":null,"profit":18799.56,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":2506,"contract_id":3808,"supplier_id":236,"purchase_id":3823,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3823,"key":3823,"serial_no":"TSKJ20250310-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8050,"user_id":5295,"key":5295,"contract_id":3808,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2358,"key":2358,"contract_id":3808,"name":"2025-04-15","value":"35100","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2125,"key":2125,"contract_id":3808,"value":"35100","created_by":1013,"created_at":"2025-03-06 17:00:25","description":"","collected_date":"2025-03-06","amount":"35100","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32709,"object_type":109,"object_id":2125,"attachment_id":24422,"attachment":{"id":24422,"key":24422,"name":"cf45ea92-2fa3-3e32-a498-63d3480e800c","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/cf45ea92-2fa3-3e32-a498-63d3480e800c\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1982,"key":1982,"contract_id":3808,"value":"35100.00","attachment_id":null,"from_date":"2025-03-17","attachment":null,"attachmentRelationships":[],"files":[{"id":32992,"object_type":102,"object_id":1982,"attachment_id":24645,"attachment":{"id":24645,"key":24645,"name":"8a93ce1e-8ba0-3889-b3bc-ef87020e56f9","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/8a93ce1e-8ba0-3889-b3bc-ef87020e56f9\/dzfp_25112000000053077775_\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250317162310.pdf","orig_name":"dzfp_25112000000053077775_\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250317162310.pdf"}}]}],"contractScans":[{"id":32909,"object_type":105,"object_id":3808,"attachment_id":24385,"attachment":{"id":24385,"key":24385,"name":"5a26b063-44b5-3372-b747-5d03f52ecb3e","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/5a26b063-44b5-3372-b747-5d03f52ecb3e\/\u84dd\u661f\u4e1c\u4e3d.pdf","orig_name":"\u84dd\u661f\u4e1c\u4e3d.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":35100,"projectProductTotalAmount":35100,"projectProductAllAmount":true,"projectProductTotalCost":9378,"projectProductAllCost":true,"projectProductTotalCount":90,"invoiced":35100,"un_invoiced":0,"collected":35100,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3796,"client_id":518,"signed_at":"2025-02-17","amount":"28000","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-26 10:39:10","updated_at":"2025-03-12 17:08:27","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3772,"valid_date":null,"expire_date":"2026-02-17","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025021701","payment_collection_remind_ahead":"","from_project":3772,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-10 15:23:58.285958+08","b_date":207,"passed":2,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3796,"comment":5},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K"},"fromProject":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K","description":"","total_contact_point":"1000","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":803,"bargain_date":"2025-02-17","collected":"28000","profit_pct":"3.21","budget":"28000","projectProductTypes":[{"id":6100,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"28000.00","pct":"3.21","project_id":3772,"profit":"898.8"}],"projectProductRels":[{"id":8991,"project_id":3772,"product_id":1955,"amount":"28000.00","number":1,"cost":"25000.00","description":"","supplier_id":676,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"28000","total_cost":"25000","supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1955,"name":"NVIDIA RTX A4090","product_type":10,"product_component":199,"product_brand":208,"product_serie":1609,"product_misc":null,"product_qa":null,"pn":"","description":"NVIDIA RTX A4090 48G \u663e\u5361","created_by":1013,"created_at":"2025-03-07 14:01:45","updated_at":"2025-03-07 14:01:45","pinyin_shortcut":"NVIDIARTXA4090","product_unit":3,"is_renew":false,"productType":{"id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},"productComponent":{"id":199,"key":199,"name":"\u5de5\u4f5c\u7ad9\u914d\u4ef6"},"productBrand":{"id":208,"key":208,"name":"NVIDIA"},"productSerie":{"id":1609,"key":1609,"name":"NVIDIA RTX A4090 48G \u56fe\u5f62\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[{"id":911,"project_id":3772,"contact_id":4432,"point":"1000.00","paid_point":null,"contact":{"id":4432,"key":4432,"name":"\u5218\u857e","client_id":518,"supplier_id":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":12706,"project_id":3772}],"reimbursementAmountSum":{"project_id":3772,"sum":"58.30"},"profit":898.8,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":2501,"contract_id":3796,"supplier_id":676,"purchase_id":3820,"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3820,"key":3820,"serial_no":"ALX-Q20250310-0105"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8041,"user_id":5295,"key":5295,"contract_id":3796,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2359,"key":2359,"contract_id":3796,"name":"2025-04-30","value":"28000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2129,"key":2129,"contract_id":3796,"value":"28000","created_by":1013,"created_at":"2025-03-07 11:17:36","description":"","collected_date":"2025-03-07","amount":"28000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32731,"object_type":109,"object_id":2129,"attachment_id":24437,"attachment":{"id":24437,"key":24437,"name":"791a41a1-4301-33f3-99b8-cb503eebac6b","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/791a41a1-4301-33f3-99b8-cb503eebac6b\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[],"contractScans":[{"id":32866,"object_type":105,"object_id":3796,"attachment_id":24295,"attachment":{"id":24295,"key":24295,"name":"a29b1636-83b6-3411-a6d3-1e85c3172a8a","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/a29b1636-83b6-3411-a6d3-1e85c3172a8a\/\u9b4f\u6cfd\u6587-\u56fd\u79d1\u73af\u5b87-99200.pdf","orig_name":"\u9b4f\u6cfd\u6587-\u56fd\u79d1\u73af\u5b87-99200.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":28000,"projectProductTotalAmount":28000,"projectProductAllAmount":true,"projectProductTotalCost":25000,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":28000,"collected":28000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3777,"client_id":107,"signed_at":"2025-02-10","amount":"30000","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-10 10:38:28","updated_at":"2025-03-03 14:38:42","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3761,"valid_date":null,"expire_date":"2026-02-28","sla":"","remind_ahead":"7 days","expire_remind_ahead":"15 days","expire_reminded":false,"serial_no":"TS-WZW-20250210001","payment_collection_remind_ahead":"","from_project":3761,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-10 10:38:28.09095+08","b_date":218,"passed":2,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3777,"comment":7},"project":{"id":3761,"key":3761,"name":"2025\u65b0\u8d2d\u6280\u672f\u670d\u52a1"},"fromProject":{"id":3761,"key":3761,"name":"2025\u65b0\u8d2d\u6280\u672f\u670d\u52a1","description":"","total_contact_point":"10000","paid_contact_point":"10000","is_sales_order_ready":true,"project_product_version_id":773,"bargain_date":"2025-02-10","collected":"30000","profit_pct":"54.67","budget":"30000","projectProductTypes":[{"id":6036,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"30000.00","pct":"54.67","project_id":3761,"profit":"16401"}],"projectProductRels":[{"id":8880,"project_id":3761,"product_id":941,"amount":"30000.00","number":1,"cost":"0","description":"","supplier_id":677,"hardware_from":null,"software_from":null,"maintenance_from":"2025-03-01","hardware_to":null,"software_to":null,"maintenance_to":"2026-02-28","total_amount":"30000","total_cost":"0","supplier":{"id":677,"key":677,"name":"TOAST"},"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":"2023-08-11 16:02:47","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"}}}],"projectContactPoints":[{"id":891,"project_id":3761,"contact_id":533,"point":"10000.00","paid_point":"10000","contact":{"id":533,"key":533,"name":"\u9ec4\u5411\u8363","client_id":107,"supplier_id":null,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":167,"project_id":3761,"contact_id":533,"point":"10000.00","day_at":"2025-03-03","description":"","created_at":"2025-03-03 14:38:42"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12621,"project_id":3761}],"reimbursementAmountSum":{"project_id":3761,"sum":"182.15"},"profit":16401,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8314,"user_id":5295,"key":5295,"contract_id":3777,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7941,"user_id":5295,"key":5295,"contract_id":3777,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2328,"key":2328,"contract_id":3777,"name":"2025-03-31","value":"30000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2115,"key":2115,"contract_id":3777,"value":"30000","created_by":1013,"created_at":"2025-02-24 17:29:15","description":"","collected_date":"2025-02-24","amount":"30000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32508,"object_type":109,"object_id":2115,"attachment_id":24279,"attachment":{"id":24279,"key":24279,"name":"7fcfe329-7d3f-35c2-9f44-77d3e8944afc","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/7fcfe329-7d3f-35c2-9f44-77d3e8944afc\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1947,"key":1947,"contract_id":3777,"value":"30000.00","attachment_id":null,"from_date":"2025-02-10","attachment":null,"attachmentRelationships":[],"files":[{"id":32107,"object_type":102,"object_id":1947,"attachment_id":23956,"attachment":{"id":23956,"key":23956,"name":"06d8fdac-60b0-3df7-8100-e875ff4cc8ea","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/06d8fdac-60b0-3df7-8100-e875ff4cc8ea\/dzfp_25112000000025651874_\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250210112658.pdf","orig_name":"dzfp_25112000000025651874_\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250210112658.pdf"}}]}],"contractScans":[{"id":32602,"object_type":105,"object_id":3777,"attachment_id":24043,"attachment":{"id":24043,"key":24043,"name":"f99f51d8-b2f5-3a22-a97a-97e32d047d96","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/f99f51d8-b2f5-3a22-a97a-97e32d047d96\/\u6280\u672f\u670d\u52a1\u5408\u540c-3\u4e07.pdf","orig_name":"\u6280\u672f\u670d\u52a1\u5408\u540c-3\u4e07.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":30000,"projectProductTotalAmount":30000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":30000,"un_invoiced":0,"collected":30000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u63d0\u524d15\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3790,"client_id":189,"signed_at":"2025-02-07","amount":"22200","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-24 11:00:58","updated_at":"2025-03-05 09:30:24","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3770,"valid_date":null,"expire_date":"2026-02-07","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025020701","payment_collection_remind_ahead":"1 day","from_project":3770,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-04 09:49:47.682196+08","b_date":197,"passed":2,"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3790,"comment":5},"project":{"id":3770,"key":3770,"name":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6"},"fromProject":{"id":3770,"key":3770,"name":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6","description":"","total_contact_point":"1500","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":790,"bargain_date":"2025-02-07","collected":"22200","profit_pct":"26.6","budget":"22200","projectProductTypes":[{"id":6052,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"22200.00","pct":"26.6","project_id":3770,"profit":"5905.2"}],"projectProductRels":[{"id":8910,"project_id":3770,"product_id":1947,"amount":"22200.00","number":1,"cost":"12919.00","description":"","supplier_id":223,"hardware_from":null,"software_from":"2025-03-03","maintenance_from":null,"hardware_to":null,"software_to":"2026-03-02","maintenance_to":null,"total_amount":"22200","total_cost":"12919","supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1947,"name":"\u5353\u8c6a ManageEngine Endpoint Central \u79df\u7528\u6a21\u5f0f \u5b89\u5168\u7248","product_type":7,"product_component":160,"product_brand":127,"product_serie":1602,"product_misc":null,"product_qa":null,"pn":"","description":"30\u4e2a\u7aef\u70b9\u7684\u5e74\u79df\u8d39\n\u591a\u56fd\u8bed\u5305\u7684\u5e74\u79df\u8d39\n\u7edf\u4e00\u7ec8\u7aef\u7ba1\u7406\uff08UEM\uff09\u89e3\u51b3\u65b9\u6848\u3002\u8ba1\u7b97\u673a\u7ba1\u7406\uff1b\u79fb\u52a8\u8bbe\u5907\u7ba1\u7406\uff1b\u5bf9Windows 10\u7684\u73b0\u4ee3\u7ba1\u7406\uff1b\u64cd\u4f5c\u7cfb\u7edf\u90e8\u7f72\uff1b\u5e94\u7528\u63a7\u5236\uff1b\u8bbe\u5907\u63a7\u5236\uff1b\u6d4f\u89c8\u5668\u5b89\u5168\uff1bBitlocker\uff1b\u7ec8\u7aefDLP\uff1b\u6f0f\u6d1e\u7ba1\u7406\uff1b\u5206\u652f\u529e\u516c\u5ba4\u7ba1\u7406\uff1b\u81ea\u52a9\u670d\u52a1\u95e8\u6237\uff1b\u7981\u7528\u8f6f\u4ef6\/\u963b\u6b62EXE\uff1b\u8f6f\u4ef6\u4f7f\u7528\u8ba1\u91cf\uff1b\u8bb8\u53ef\u7ba1\u7406\uff1b\u8fdc\u7a0b\u684c\u9762\u5f55\u5236\uff1bUSB\u8bbe\u5907\u7ba1\u7406\uff1b\u53cc\u56e0\u7d20\u8eab\u4efd\u8ba4\u8bc1\uff1b\u8865\u4e01\u7ba1\u7406\uff1b\u8f6f\u4ef6\u90e8\u7f72\uff1b\u8d44\u4ea7\u7ba1\u7406\uff1b\u914d\u7f6e\u7ba1\u7406\uff1bWindows\u7cfb\u7edf\u5de5\u5177\uff1b\u8fdc\u7a0b\u63a7\u5236\uff1bAD\u548c\u7528\u6237\u767b\u5f55\u62a5\u8868\u3002\n","created_by":1013,"created_at":"2025-02-28 11:17:21","updated_at":"2025-02-28 11:17:21","pinyin_shortcut":"zhManageEngineEndpointCentralzymsaqb","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":160,"key":160,"name":"\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf"},"productBrand":{"id":127,"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09"},"productSerie":{"id":1602,"key":1602,"name":"ManageEngine Endpoint Central \u5b89\u5168\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[{"id":895,"project_id":3770,"contact_id":1781,"point":"1500.00","paid_point":null,"contact":{"id":1781,"key":1781,"name":"\u9648\u660e\u8d85","client_id":189,"supplier_id":null,"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":12687,"project_id":3770}],"reimbursementAmountSum":null,"profit":5905.2,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":2462,"contract_id":3790,"supplier_id":223,"purchase_id":3801,"supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3801,"key":3801,"serial_no":"WYY-ZC-2025022801-BJJX"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7956,"user_id":5295,"key":5295,"contract_id":3790,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2349,"key":2349,"contract_id":3790,"name":"2025-03-31","value":"22200","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2117,"key":2117,"contract_id":3790,"value":"22200","created_by":1013,"created_at":"2025-02-27 17:01:50","description":"","collected_date":"2025-02-27","amount":"22200","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32558,"object_type":109,"object_id":2117,"attachment_id":24314,"attachment":{"id":24314,"key":24314,"name":"ab64b0e2-6149-3bda-8cb1-f7425a72739f","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/ab64b0e2-6149-3bda-8cb1-f7425a72739f\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[],"contractScans":[{"id":32664,"object_type":105,"object_id":3790,"attachment_id":24319,"attachment":{"id":24319,"key":24319,"name":"f35eacbf-29d5-3229-a346-64d2eea027d1","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/f35eacbf-29d5-3229-a346-64d2eea027d1\/\u4eac\u897f\u5b66\u6821.pdf","orig_name":"\u4eac\u897f\u5b66\u6821.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":22200,"projectProductTotalAmount":22200,"projectProductAllAmount":true,"projectProductTotalCost":12919,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":22200,"collected":22200,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":599,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-25 10:21:46') RETURNING "id"
10:21:46.452	13.6 ms	yii\db\Command::query	SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5295, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
10:21:46.441	10.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT c., abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5295, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
10:21:46.427	4.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'
10:21:46.423	3.7 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:21:46.529	3.3 ms	yii\db\Command::query	SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3770, 3761, 3771, 3777, 3772, 3800, 3785, 3788, 3791, 3783))
10:21:46.432	2.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
10:21:46.569	2.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1947, 1971, 1977, 1978, 1979, 1982))
10:21:46.566	2.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1947, 1971, 1977, 1978, 1979, 1982))
10:21:46.575	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790))
10:21:46.538	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)
10:21:46.534	2.1 ms	yii\db\Command::query	SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3770, 3761, 3771, 3777, 3772, 3800, 3785, 3788, 3791, 3783)) GROUP BY "project_id"
10:21:46.577	2.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790))
10:21:46.561	2.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (2115, 2117, 2118, 2125, 2129, 2131))
10:21:46.514	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (941, 1946, 942, 1951, 1952, 1947, 1941, 1942, 1529, 542, 1955, 1956, 1954, 1953)
10:21:46.547	1.8 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)
10:21:46.556	1.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790) ORDER BY "id"
10:21:46.552	1.3 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 (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)
10:21:46.572	1.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790))
10:21:46.510	1.3 ms	yii\db\Command::query	SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3770, 3761, 3771, 3777, 3772, 3800, 3785, 3788, 3791, 3783)
10:21:46.559	1.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
10:21:46.546	1.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)
10:21:46.523	1.1 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1319, 593, 592, 1198, 1599, 1600, 1601, 1602, 1606, 1607, 627, 1609, 1608, 1610)
10:21:46.519	1.1 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 19, 2, 14, 3, 10)
10:21:46.565	1.1 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 (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790) ORDER BY "id"
10:21:46.512	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3770, 3761, 3771, 3777, 3772, 3800, 3785, 3788, 3791, 3783)
10:21:46.550	0.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5295)
10:21:46.473	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2032, 531, 518, 3281, 2546, 3333, 107, 189)
10:21:46.542	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
10:21:46.555	0.7 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 (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790) ORDER BY "remind_date"
10:21:46.564	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24279, 24314, 24339, 24422, 24437, 24457)
10:21:46.506	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3800, 3791, 3788, 3771, 3785, 3783, 3777, 3772, 3761, 3770)
10:21:46.514	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (677, 618, 59, 223, 583, 678, 676, 236)
10:21:46.545	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)) ORDER BY "remind_date"
10:21:46.527	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (533, 1781, 1188, 4432)
10:21:46.505	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3800, 3791, 3788, 3771, 3785, 3783, 3777, 3772, 3761, 3770)
10:21:46.528	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((533, 3761), (1781, 3770), (1188, 3791), (4432, 3772), (533, 3777))
10:21:46.474	0.6 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 (5311, 5295))
10:21:46.527	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (107, 531, 189, 518)
10:21:46.542	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3800, 3801, 3821, 3508, 3806, 3814, 3820, 3823)
10:21:46.541	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (618, 223, 685, 583, 59, 678, 676, 236)
10:21:46.572	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23956, 24432, 24484, 24541, 24542, 24645)
10:21:46.525	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3770, 3761, 3771, 3777, 3772, 3800, 3785, 3788, 3791, 3783)
10:21:46.476	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 1)
10:21:46.523	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (219, 134, 133, 4, 227, 231, 127, 21, 7, 24, 208, 6, 12)
10:21:46.522	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (204, 151, 5, 2, 30, 149, 160, 15, 199, 39, 41)
10:21:46.552	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3830, 3811, 3805, 3791, 3797, 3795, 3808, 3796, 3777, 3790)
10:21:46.525	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 7, 4, 1, 2)
10:21:46.574	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24293, 24043, 24311, 24319, 24265, 24403, 24295, 24385)
10:21:46.474	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5311)
10:21:46.543	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5300, 1005)
10:21:46.475	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 5300, 5295, 1005)
10:21:46.476	0.3 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 (5250, 5295, 1005, 5300))
10:21:46.551	0.3 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 (5311, 5295))
10:21:46.554	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1005, 5300, 5388, 1001)
10:21:46.555	0.3 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, 5388, 1005, 5300))
10:21:46.544	0.3 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 (5295, 1005, 5300))
10:21:46.577	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24487