Performance Profiling

Total processing time: 124 ms; Peak memory: 5.901 MB. Show Profiling Timeline

总计61条数据

Time	Duration	Category	Info

17:30:18.585	19.2 ms	yii\db\Command::query	SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)) GROUP BY "object_id"
17:30:18.646	16.0 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)) GROUP BY "object_id"
17:30:18.570	10.8 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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 OFFSET 10
17:30:18.560	9.5 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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
17:30:18.611	4.0 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1437, 592, 1495, 1198, 1603, 1605, 1606, 1607, 627, 1609, 1608, 1610, 1604, 47)
17:30:18.666	3.2 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 166, 'v2/sales-contract/list', '{"SalesContractSearch":{"keyword":"","contract_type":"","handler":"","contract_scan":"","receipt_scan":""},"page":"2","posttime":"1751880618","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"f70b556b68c51acdc18f9476e1898511"}', '{"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":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3822,"client_id":2736,"signed_at":"2025-03-10","amount":"2500","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-10 10:17:21","updated_at":"2025-03-12 17:05:47","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3793,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"7 days","from_project":3793,"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 10:17:21.573991+08","b_date":null,"passed":1,"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"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":3822,"comment":7},"project":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025"},"fromProject":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":805,"bargain_date":"2025-03-10","collected":"0","profit_pct":"93","budget":"2500","projectProductTypes":[{"id":6099,"product_type_id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1","budget":"2500.00","pct":"93","project_id":3793,"profit":"2325"}],"projectProductRels":[{"id":8990,"project_id":3793,"product_id":941,"amount":"2500.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2500","total_cost":"0","supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"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":[],"buildSalesOrderItems":[{"id":12705,"project_id":3793}],"reimbursementAmountSum":null,"profit":2325,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8038,"user_id":5300,"key":5300,"contract_id":3822,"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":8039,"user_id":5388,"key":5388,"contract_id":3822,"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":8040,"user_id":1001,"key":1001,"contract_id":3822,"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":2357,"key":2357,"contract_id":3822,"name":"2025-04-21","value":"2500","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f77\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":1973,"key":1973,"contract_id":3822,"value":"2500.00","attachment_id":null,"from_date":"2025-03-10","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32765,"object_type":102,"object_id":1973,"attachment_id":24459,"attachment":{"id":24459,"key":24459,"name":"71d5dda2-3a17-3984-80e1-bac7620b7349","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/71d5dda2-3a17-3984-80e1-bac7620b7349\/dzfp_25112000000047178002_\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250310111046.pdf","orig_name":"dzfp_25112000000047178002_\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250310111046.pdf"}}]},{"id":1987,"key":1987,"contract_id":3822,"value":"1.00","attachment_id":null,"from_date":"2025-05-22","description":"\u5907\u6ce8\u5907\u6ce8\u5907\u6ce8\u5907\u6ce8\u5907\u6ce8\u5907\u6ce8\u5907\u6ce8\u5907\u6ce8\nasdfasdfasdfasdf as d\n\u5907\u6ce8","is_draft":true,"attachment":null,"attachmentRelationships":[{"id":33106,"object_type":20,"object_id":1987,"attachment_id":24734,"attachment":{"id":24734,"key":24734,"name":"f9f5d3ee-b455-3882-9eae-4e57242934f6","extension":"jpg","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/f9f5d3ee-b455-3882-9eae-4e57242934f6\/WechatIMG61.jpg","orig_name":"WechatIMG61.jpg"}}],"files":[{"id":33107,"object_type":102,"object_id":1987,"attachment_id":24735,"attachment":{"id":24735,"key":24735,"name":"350f1ee5-3bf7-3443-abed-86f41880aa83","extension":"docx","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/350f1ee5-3bf7-3443-abed-86f41880aa83\/05-22\u5f85\u5f00\u53d1.docx","orig_name":"05-22\u5f85\u5f00\u53d1.docx"}},{"id":33108,"object_type":102,"object_id":1987,"attachment_id":24736,"attachment":{"id":24736,"key":24736,"name":"bab6e6e1-0ef9-3778-89fb-8d755557756d","extension":"docx","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/bab6e6e1-0ef9-3778-89fb-8d755557756d\/05-09\u5f85\u5f00\u53d1.docx","orig_name":"05-09\u5f85\u5f00\u53d1.docx"}}]}],"contractScans":[{"id":32865,"object_type":105,"object_id":3822,"attachment_id":24524,"attachment":{"id":24524,"key":24524,"name":"37854557-1bde-3e35-9929-0b57b7857c3f","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/37854557-1bde-3e35-9929-0b57b7857c3f\/2025_03_12_13_58_48.pdf","orig_name":"2025_03_12_13_58_48.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":2500,"projectProductTotalAmount":2500,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":2501,"un_invoiced":-1,"collected":0,"un_collected":2500,"is_collected":false,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3816,"client_id":12,"signed_at":"2025-03-06","amount":"511","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-06 19:44:56","updated_at":"2025-03-14 17:29:50","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3794,"valid_date":null,"expire_date":"2026-03-05","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25031110","payment_collection_remind_ahead":"1 day","from_project":3794,"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-06 19:45:22.44096+08","b_date":241,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"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":3816,"comment":6},"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025"},"fromProject":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":800,"bargain_date":"2025-03-06","collected":"0","profit_pct":"41.41","budget":"511","projectProductTypes":[{"id":6105,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"511.00","pct":"41.41","project_id":3794,"profit":"211.6051"}],"projectProductRels":[{"id":8996,"project_id":3794,"product_id":1770,"amount":"511.00","number":1,"cost":"256.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"511","total_cost":"256","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1770,"name":"BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1495,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-29 14:10:56","updated_at":"2024-08-29 14:10:56","pinyin_shortcut":"BG5512G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1495,"key":1495,"name":"\u4e1c\u829d BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12709,"project_id":3794}],"reimbursementAmountSum":null,"profit":211.6051,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2505,"contract_id":3816,"supplier_id":608,"purchase_id":3819,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3819,"key":3819,"serial_no":"\u8ba2\u5355\u53f7: 4256424362229592710"}}],"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8047,"user_id":5300,"key":5300,"contract_id":3816,"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":8048,"user_id":5388,"key":5388,"contract_id":3816,"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":8049,"user_id":1001,"key":1001,"contract_id":3816,"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":2356,"key":2356,"contract_id":3816,"name":"2025-04-18","value":"511","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f80\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32908,"object_type":105,"object_id":3816,"attachment_id":24526,"attachment":{"id":24526,"key":24526,"name":"9748514a-8585-353f-bfcf-d5f7c3e95cdf","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/9748514a-8585-353f-bfcf-d5f7c3e95cdf\/POBJ25031110.pdf","orig_name":"POBJ25031110.pdf"}}],"receiptScans":[{"id":32906,"object_type":106,"object_id":3816,"attachment_id":24560,"attachment":{"id":24560,"key":24560,"name":"58432bf9-3e54-36b5-8fe6-fdec985e30f6","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/58432bf9-3e54-36b5-8fe6-fdec985e30f6\/2025_03_14_15_33_53.pdf","orig_name":"2025_03_14_15_33_53.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":511,"projectProductTotalAmount":511,"projectProductAllAmount":true,"projectProductTotalCost":256,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":511,"collected":0,"un_collected":511,"is_collected":false,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3812,"client_id":20,"signed_at":"2025-03-06","amount":"500","handler":1005,"description":"","created_by":1005,"created_at":"2025-03-06 09:01:21","updated_at":"2025-03-14 15:15:11","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3792,"valid_date":null,"expire_date":"2026-03-04","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":3792,"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":240,"passed":2,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"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":3812,"comment":8},"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362"},"fromProject":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":794,"bargain_date":"2025-03-06","collected":"0","profit_pct":"32.8","budget":"500","projectProductTypes":[{"id":6081,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"500.00","pct":"32.8","project_id":3792,"profit":"164"}],"projectProductRels":[{"id":8957,"project_id":3792,"product_id":275,"amount":"500.00","number":1,"cost":"300.00","description":"","supplier_id":81,"hardware_from":"2025-03-04","software_from":null,"maintenance_from":null,"hardware_to":"2026-03-04","software_to":null,"maintenance_to":null,"total_amount":"500","total_cost":"300","supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"product":{"id":275,"name":"\u8054\u60f3 750W","product_type":2,"product_component":6,"product_brand":4,"product_serie":47,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-09-07 17:25:11","updated_at":"2023-08-14 15:35:21","pinyin_shortcut":"lx750W","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":6,"key":6,"name":"\u670d\u52a1\u5668\u7535\u6e90"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":47,"key":47,"name":"\u8054\u60f3X3650M5"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12693,"project_id":3792}],"reimbursementAmountSum":null,"profit":164,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2481,"contract_id":3812,"supplier_id":81,"purchase_id":3813,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"purchase":{"id":3813,"key":3813,"serial_no":"TSKJ20250304-HYF-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":8008,"user_id":1005,"key":1005,"contract_id":3812,"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":2354,"key":2354,"contract_id":3812,"name":"2025-04-06","value":"500","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f92\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":1965,"key":1965,"contract_id":3812,"value":"500.00","attachment_id":null,"from_date":"2025-03-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32693,"object_type":102,"object_id":1965,"attachment_id":24409,"attachment":{"id":24409,"key":24409,"name":"2a02aa7d-f016-3163-9269-8b86a3d2d8a6","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/2a02aa7d-f016-3163-9269-8b86a3d2d8a6\/dzfp_25112000000044439082_\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8_20250306093600.pdf","orig_name":"dzfp_25112000000044439082_\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8_20250306093600.pdf"}}]}],"contractScans":[{"id":32901,"object_type":105,"object_id":3812,"attachment_id":24556,"attachment":{"id":24556,"key":24556,"name":"d2cd80bc-8e02-3473-a4f4-d35a688ac6e4","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/d2cd80bc-8e02-3473-a4f4-d35a688ac6e4\/\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8.pdf","orig_name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8.pdf"}}],"receiptScans":[{"id":32902,"object_type":106,"object_id":3812,"attachment_id":24527,"attachment":{"id":24527,"key":24527,"name":"f2ba2c4b-2411-363a-a99e-20e3a30965ff","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/f2ba2c4b-2411-363a-a99e-20e3a30965ff\/DOC031225-03122025155101 2.pdf","orig_name":"DOC031225-03122025155101 2.pdf"}},{"id":32903,"object_type":106,"object_id":3812,"attachment_id":24557,"attachment":{"id":24557,"key":24557,"name":"ca30c67d-7c9c-3001-9f7f-648e4e12d250","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/ca30c67d-7c9c-3001-9f7f-648e4e12d250\/DOC031225-03122025155101.pdf","orig_name":"DOC031225-03122025155101.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":500,"projectProductTotalAmount":500,"projectProductAllAmount":true,"projectProductTotalCost":300,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":500,"un_invoiced":0,"collected":0,"un_collected":500,"is_collected":false,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"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\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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","description":"","is_draft":false,"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\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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","description":"","is_draft":false,"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\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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","description":"","is_draft":false,"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\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3770,"client_id":3326,"signed_at":"2025-03-05","amount":"32000","handler":5087,"description":"","created_by":5087,"created_at":"2025-01-21 15:45:01","updated_at":"2025-03-06 09:23:53","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3769,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-LW-20250305001","payment_collection_remind_ahead":"1 day","from_project":3769,"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-01-21 16:22:12.892494+08","b_date":null,"passed":1,"client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3770,"comment":8},"project":{"id":3769,"key":3769,"name":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39"},"fromProject":{"id":3769,"key":3769,"name":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":769,"bargain_date":"2025-03-05","collected":"32000","profit_pct":"93","budget":"32000","projectProductTypes":[{"id":6066,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"32000.00","pct":"93","project_id":3769,"profit":"29760"}],"projectProductRels":[{"id":8915,"project_id":3769,"product_id":941,"amount":"32000.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"32000","total_cost":"0","supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"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":[],"buildSalesOrderItems":[{"id":12592,"project_id":3769}],"reimbursementAmountSum":null,"profit":29760,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7982,"user_id":5087,"key":5087,"contract_id":3770,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"id":7983,"user_id":5388,"key":5388,"contract_id":3770,"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":7984,"user_id":1001,"key":1001,"contract_id":3770,"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":2325,"key":2325,"contract_id":3770,"name":"2025-04-30","value":"32000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2104,"key":2104,"contract_id":3770,"value":"32000","created_by":1013,"created_at":"2025-02-10 13:25:13","description":"","collected_date":"2025-02-10","amount":"32000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32121,"object_type":109,"object_id":2104,"attachment_id":23970,"attachment":{"id":23970,"key":23970,"name":"9bf1ace6-02ac-3f38-bf04-ed6e50d408dd","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/9bf1ace6-02ac-3f38-bf04-ed6e50d408dd\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1945,"key":1945,"contract_id":3770,"value":"32000.00","attachment_id":null,"from_date":"2025-01-21","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32026,"object_type":102,"object_id":1945,"attachment_id":23891,"attachment":{"id":23891,"key":23891,"name":"8f21e657-f979-3e25-b320-5336cc4aed58","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/8f21e657-f979-3e25-b320-5336cc4aed58\/dzfp_25112000000017545147_\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8_20250121162026.pdf","orig_name":"dzfp_25112000000017545147_\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8_20250121162026.pdf"}}]}],"contractScans":[{"id":32687,"object_type":105,"object_id":3770,"attachment_id":24384,"attachment":{"id":24384,"key":24384,"name":"99b4be38-efef-3861-96a0-37e4cf5e51a8","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/99b4be38-efef-3861-96a0-37e4cf5e51a8\/\u5218\u8587-\u4fdd\u5b9a\u6c90\u69ff.pdf","orig_name":"\u5218\u8587-\u4fdd\u5b9a\u6c90\u69ff.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":32000,"projectProductTotalAmount":32000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":32000,"un_invoiced":0,"collected":32000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3809,"client_id":4,"signed_at":"2025-03-04","amount":"1700","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 14:27:35","updated_at":"2025-03-14 15:19:55","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3789,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250304002","payment_collection_remind_ahead":"1 day","from_project":3789,"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-06-11 11:23:01.426167+08","b_date":null,"passed":1,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"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":3809,"comment":13},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025"},"fromProject":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":796,"bargain_date":"2025-03-04","collected":"1700","profit_pct":"33.82","budget":"1700","projectProductTypes":[{"id":6083,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1700.00","pct":"33.82","project_id":3789,"profit":"574.94"}],"projectProductRels":[{"id":8959,"project_id":3789,"product_id":1954,"amount":"850.00","number":2,"cost":"500.00","description":"","supplier_id":489,"hardware_from":"2025-03-06","software_from":null,"maintenance_from":null,"hardware_to":"2026-03-05","software_to":null,"maintenance_to":null,"total_amount":"1700","total_cost":"1000","supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12701,"project_id":3789},{"id":12700,"project_id":3789}],"reimbursementAmountSum":null,"profit":574.94,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2483,"contract_id":3809,"supplier_id":489,"purchase_id":3810,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3810,"key":3810,"serial_no":"TSKJ20250305-HYF-001"}}],"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8179,"user_id":5300,"key":5300,"contract_id":3809,"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":8180,"user_id":5388,"key":5388,"contract_id":3809,"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":8181,"user_id":1001,"key":1001,"contract_id":3809,"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":2395,"key":2395,"contract_id":3809,"name":"2025-04-05","value":"22","overdue_days":null,"pct":1.29,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2126,"key":2126,"contract_id":3809,"value":"1700","created_by":1013,"created_at":"2025-03-06 17:01:07","description":"","collected_date":"2025-03-06","amount":"1700","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32710,"object_type":109,"object_id":2126,"attachment_id":24423,"attachment":{"id":24423,"key":24423,"name":"0c22f727-6df7-34c6-bfd0-59d1f045e855","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/0c22f727-6df7-34c6-bfd0-59d1f045e855\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1966,"key":1966,"contract_id":3809,"value":"1700.00","attachment_id":null,"from_date":"2025-03-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32694,"object_type":102,"object_id":1966,"attachment_id":24410,"attachment":{"id":24410,"key":24410,"name":"a4330a1f-28f4-38a3-bfbe-bbc2098216d0","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/a4330a1f-28f4-38a3-bfbe-bbc2098216d0\/dzfp_25112000000044491568_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306094839.pdf","orig_name":"dzfp_25112000000044491568_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306094839.pdf"}}]},{"id":1967,"key":1967,"contract_id":3809,"value":"-1700.00","attachment_id":null,"from_date":"2025-03-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32703,"object_type":102,"object_id":1967,"attachment_id":24414,"attachment":{"id":24414,"key":24414,"name":"be19ac71-09f3-3e33-90d2-308672c89ce8","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/be19ac71-09f3-3e33-90d2-308672c89ce8\/dzfp_25112000000041307165_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306103155.pdf","orig_name":"dzfp_25112000000041307165_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306103155.pdf"}}]},{"id":1970,"key":1970,"contract_id":3809,"value":"1700.00","attachment_id":null,"from_date":"2025-03-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32712,"object_type":102,"object_id":1970,"attachment_id":24425,"attachment":{"id":24425,"key":24425,"name":"0e2c262e-35c3-3878-855c-67cbe745a6a4","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/0e2c262e-35c3-3878-855c-67cbe745a6a4\/dzfp_25112000000044479475_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306102849.pdf","orig_name":"dzfp_25112000000044479475_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306102849.pdf"}}]}],"contractScans":[{"id":32904,"object_type":105,"object_id":3809,"attachment_id":24558,"attachment":{"id":24558,"key":24558,"name":"ae0ec17f-0550-3439-8e8e-b4cf2f6a51e9","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/ae0ec17f-0550-3439-8e8e-b4cf2f6a51e9\/\u9ad8\u7891\u5e97.pdf","orig_name":"\u9ad8\u7891\u5e97.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":22,"projectProductTotalAmount":1700,"projectProductAllAmount":true,"projectProductTotalCost":1000,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":1700,"un_invoiced":0,"collected":1700,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"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\u671f68\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":1977,"key":1977,"contract_id":3805,"value":"1200.00","attachment_id":null,"from_date":"2025-03-11","description":"","is_draft":false,"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\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3803,"client_id":3334,"signed_at":"2025-02-28","amount":"3593747","handler":1001,"description":"","created_by":1001,"created_at":"2025-02-28 16:22:01","updated_at":"2025-06-09 17:17:30","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3786,"valid_date":null,"expire_date":"2026-02-27","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20250228-LRC-001","payment_collection_remind_ahead":null,"from_project":3786,"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-06-11 11:24:15.876522+08","b_date":235,"passed":2,"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":3803,"comment":6},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1"},"fromProject":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":788,"bargain_date":"2025-02-28","collected":"-1","profit_pct":"1.7","budget":"3593747","projectProductTypes":[{"id":6211,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"3048204","pct":"1.99","project_id":3786,"profit":"60964"},{"id":6212,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"545543","pct":"0.1","project_id":3786,"profit":"547"}],"projectProductRels":[{"id":9084,"project_id":3786,"product_id":1948,"amount":"1966146.00","number":1,"cost":"1926823.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1966146","total_cost":"1926823","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1948,"name":"\u8fc7\u7a0b\u76d1\u63a7\u7cfb\u7edf\u3010\u7b80\u79f0:\u76d1\u63a7\u670d\u52a1\u3011V1.0","product_type":7,"product_component":64,"product_brand":230,"product_serie":1603,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-28 16:34:11","updated_at":"2025-02-28 16:34:11","pinyin_shortcut":"gcjkxtjcjkfwV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":64,"key":64,"name":"\u89c6\u9891\u76d1\u63a7\u5e73\u53f0\u8f6f\u4ef6"},"productBrand":{"id":230,"key":230,"name":"\u8fdc\u9274"},"productSerie":{"id":1603,"key":1603,"name":"\u8fc7\u7a0b\u76d1\u63a7\u7cfb\u7edf"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9085,"project_id":3786,"product_id":1949,"amount":"975765.00","number":1,"cost":"956250.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"975765","total_cost":"956250","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1949,"name":"\u667a\u80fd\u58f0\u7eb9\u9274\u5b9a\u5de5\u4f5c\u7ad9\u7cfb\u7edf\u3010\u7b80\u79f0:\u58f0\u7eb9\u9274\u5b9a\u5de5\u4f5c\u7ad9\u3011V3.0","product_type":7,"product_component":64,"product_brand":230,"product_serie":1604,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-28 16:34:50","updated_at":"2025-02-28 16:34:50","pinyin_shortcut":"znswjdgzzxtjcswjdgzzV30","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":64,"key":64,"name":"\u89c6\u9891\u76d1\u63a7\u5e73\u53f0\u8f6f\u4ef6"},"productBrand":{"id":230,"key":230,"name":"\u8fdc\u9274"},"productSerie":{"id":1604,"key":1604,"name":"\u667a\u80fd\u58f0\u7eb9\u9274\u5b9a\u5de5\u4f5c\u7ad9\u7cfb\u7edf"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9086,"project_id":3786,"product_id":1950,"amount":"106293.00","number":1,"cost":"104167.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"106293","total_cost":"104167","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1950,"name":"\u591a\u5a92\u4f53\u5904\u7406\u6a21\u5757\u7cfb\u7edf\u3010\u591a\u6807\u7b7e\u6807\u6ce8\u7cfb\u7edf\u3011V1.0","product_type":7,"product_component":64,"product_brand":230,"product_serie":1605,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-28 16:35:45","updated_at":"2025-02-28 16:35:45","pinyin_shortcut":"dmtclmkxtdbqbzxtV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":64,"key":64,"name":"\u89c6\u9891\u76d1\u63a7\u5e73\u53f0\u8f6f\u4ef6"},"productBrand":{"id":230,"key":230,"name":"\u8fdc\u9274"},"productSerie":{"id":1605,"key":1605,"name":"\u591a\u5a92\u4f53\u5904\u7406\u6a21\u5757\u7cfb\u7edf"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12690,"project_id":3786},{"id":12689,"project_id":3786},{"id":12688,"project_id":3786}],"reimbursementAmountSum":null,"profit":61093.699,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2533,"contract_id":3803,"supplier_id":431,"purchase_id":3834,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":3834,"key":3834,"serial_no":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u5173\u8054\u91c7\u8d2d\u5408\u540c\u95ee\u9898"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8182,"user_id":1001,"key":1001,"contract_id":3803,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8183,"user_id":1011,"key":1011,"contract_id":3803,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":8184,"user_id":5388,"key":5388,"contract_id":3803,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2396,"key":2396,"contract_id":3803,"name":"2025-03-31","value":"3048204","overdue_days":null,"pct":84.82,"collect_status":"\u903e\u671f98\u5929"},{"id":2397,"key":2397,"contract_id":3803,"name":"2025-06-11","value":"1","overdue_days":null,"pct":0,"collect_status":"\u903e\u671f26\u5929"}],"salesContractPayments":[{"id":2156,"key":2156,"contract_id":3803,"value":"-1","created_by":1001,"created_at":"2025-05-08 09:15:53","description":"ces ","collected_date":"2025-05-08","amount":"-1","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[{"id":33031,"object_type":109,"object_id":2156,"attachment_id":24675,"attachment":{"id":24675,"key":24675,"name":"75767c40-1e2a-399e-a1ab-371451ad6bfc","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/75767c40-1e2a-399e-a1ab-371451ad6bfc\/61433e6201b8351977de2fd0fef4158debbdb1f995773-0MB0m7_fw1200.png","orig_name":"61433e6201b8351977de2fd0fef4158debbdb1f995773-0MB0m7_fw1200.png"}}],"pct":-0}],"salesContractInvoices":[],"contractScans":[{"id":33118,"object_type":105,"object_id":3803,"attachment_id":24348,"attachment":{"id":24348,"key":24348,"name":"a37e4f5d-10e8-3c25-8a5c-e6d970c593ae","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/a37e4f5d-10e8-3c25-8a5c-e6d970c593ae\/\u878d\u9890\u5149\u7535.pdf","orig_name":"\u878d\u9890\u5149\u7535.pdf"}}],"receiptScans":[{"id":32860,"object_type":106,"object_id":3803,"attachment_id":24525,"attachment":{"id":24525,"key":24525,"name":"37ceb493-ecbe-346e-9100-7d66b5576afd","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/37ceb493-ecbe-346e-9100-7d66b5576afd\/\u8d27\u7269\u7b7e\u6536\u5355(1).pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355(1).pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":3048205,"projectProductTotalAmount":3048204,"projectProductAllAmount":true,"projectProductTotalCost":2987240,"projectProductAllCost":true,"projectProductTotalCount":3,"invoiced":0,"un_invoiced":3593747,"collected":-1,"un_collected":3593748,"is_collected":false,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3792,"client_id":12,"signed_at":"2025-02-24","amount":"629","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-24 11:47:14","updated_at":"2025-03-11 10:58:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3782,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25024486","payment_collection_remind_ahead":"7 days","from_project":3782,"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:47:14.087116+08","b_date":null,"passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"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":3792,"comment":5},"project":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025"},"fromProject":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":782,"bargain_date":"2025-02-24","collected":"0","profit_pct":"11.69","budget":"629","projectProductTypes":[{"id":6029,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"629.00","pct":"11.69","project_id":3782,"profit":"73.5301"}],"projectProductRels":[{"id":8863,"project_id":3782,"product_id":1689,"amount":"629.00","number":1,"cost":"530.00","description":"","supplier_id":505,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"629","total_cost":"530","supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"product":{"id":1689,"name":"PM991A 1TB M.2 2230 NVMe","product_type":11,"product_component":179,"product_brand":10,"product_serie":1437,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:42:48","updated_at":"2024-07-25 17:42:48","pinyin_shortcut":"PM991A1TBM22230NVMe","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1437,"key":1437,"name":"\u4e09\u661f M.2 NVME 2230 SSD 1T\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12671,"project_id":3782}],"reimbursementAmountSum":null,"profit":73.5301,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2444,"contract_id":3792,"supplier_id":505,"purchase_id":3793,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"purchase":{"id":3793,"key":3793,"serial_no":""}}],"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7930,"user_id":5300,"key":5300,"contract_id":3792,"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":7931,"user_id":5388,"key":5388,"contract_id":3792,"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":7932,"user_id":1001,"key":1001,"contract_id":3792,"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":2339,"key":2339,"contract_id":3792,"name":"2025-04-11","value":"629","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f87\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32562,"object_type":105,"object_id":3792,"attachment_id":24289,"attachment":{"id":24289,"key":24289,"name":"76c3b687-819a-3e06-96cc-2e36a3034c32","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/76c3b687-819a-3e06-96cc-2e36a3034c32\/POBJ25024486.pdf","orig_name":"POBJ25024486.pdf"}}],"receiptScans":[{"id":32810,"object_type":106,"object_id":3792,"attachment_id":24488,"attachment":{"id":24488,"key":24488,"name":"04eb1aee-ed22-31c0-acc8-a13438cab861","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/04eb1aee-ed22-31c0-acc8-a13438cab861\/2025_03_11_10_57_47.pdf","orig_name":"2025_03_11_10_57_47.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":629,"projectProductTotalAmount":629,"projectProductAllAmount":true,"projectProductTotalCost":530,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":629,"collected":0,"un_collected":629,"is_collected":false,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":1497,"thispage":2,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-07 17:30:18') RETURNING "id"
17:30:18.633	2.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23970, 24423, 24457, 24675)
17:30:18.551	2.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
17:30:18.619	2.0 ms	yii\db\Command::query	SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3769, 3782, 3800, 3789, 3793, 3788, 3792, 3791, 3794, 3786))
17:30:18.550	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:30:18.608	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1689, 1951, 1952, 941, 275, 1954, 542, 1770, 1956, 1955, 1953, 1948, 1949, 1950)
17:30:18.621	1.5 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 (3769, 3782, 3800, 3789, 3793, 3788, 3792, 3791, 3794, 3786)) GROUP BY "project_id"
17:30:18.642	1.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24289, 24384, 24403, 24524, 24556, 24558, 24526, 24348)
17:30:18.638	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1945, 1965, 1966, 1967, 1970, 1971, 1973, 1977, 1978, 1979, 1987))
17:30:18.640	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792))
17:30:18.631	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (2104, 2126, 2131, 2156))
17:30:18.643	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792))
17:30:18.636	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1945, 1965, 1966, 1967, 1970, 1971, 1973, 1977, 1978, 1979, 1987))
17:30:18.555	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:30:18.645	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792))
17:30:18.624	1.1 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3793, 3813, 3810, 3806, 3814, 3819, 3834)
17:30:18.639	0.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23891, 24409, 24410, 24414, 24425, 24432, 24459, 24484, 24541, 24542, 24735, 24736)
17:30:18.605	0.8 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 (3769, 3782, 3800, 3789, 3793, 3788, 3792, 3791, 3794, 3786)
17:30:18.606	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3769, 3782, 3800, 3789, 3793, 3788, 3792, 3791, 3794, 3786)
17:30:18.636	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792) ORDER BY "id"
17:30:18.630	0.6 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, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792) ORDER BY "id"
17:30:18.627	0.5 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, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)
17:30:18.582	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2032, 2736, 12, 20, 531, 3326, 4, 518, 3334)
17:30:18.630	0.4 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, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792) ORDER BY "remind_date"
17:30:18.605	0.4 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, 3793, 3794, 3792, 3791, 3769, 3789, 3788, 3786, 3782)
17:30:18.628	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)
17:30:18.623	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)
17:30:18.583	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5311, 5295, 1005, 5087, 5300))
17:30:18.617	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=1188
17:30:18.607	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (505, 59, 81, 489, 678, 608, 90)
17:30:18.604	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3800, 3793, 3794, 3792, 3791, 3769, 3789, 3788, 3786, 3782)
17:30:18.626	0.4 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, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)) ORDER BY "remind_date"
17:30:18.610	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (11, 19, 2, 7, 3, 10)
17:30:18.610	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (179, 151, 5, 64, 15, 2, 199, 39, 41, 6)
17:30:18.617	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3769, 3782, 3800, 3789, 3793, 3788, 3792, 3791, 3794, 3786)
17:30:18.584	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 1)
17:30:18.615	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 7, 4, 2)
17:30:18.611	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (10, 133, 43, 4, 230, 21, 7, 24, 208, 6, 12)
17:30:18.618	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((1188, 3791))
17:30:18.625	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
17:30:18.583	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, 1005, 5087, 5295, 1001)
17:30:18.628	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)
17:30:18.582	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5087, 5300, 5295, 5311, 1001)
17:30:18.584	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5250, 5295, 1005, 5087, 5300))
17:30:18.623	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (505, 81, 489, 59, 678, 608, 431)
17:30:18.625	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5300, 1005, 5087, 1001)
17:30:18.629	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1011, 5295, 5388, 1005, 5087, 5300))
17:30:18.629	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5388, 1001, 5087, 1005, 5295, 1011)
17:30:18.631	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001)
17:30:18.626	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 5300))
17:30:18.626	0.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, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792)
17:30:18.627	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311
17:30:18.644	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24488, 24525, 24527, 24557, 24560)
17:30:18.618	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=531
17:30:18.638	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24734
17:30:18.628	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311)