Performance Profiling

Total processing time: 139 ms; Peak memory: 7.001 MB. Show Profiling Timeline

总计66条数据

Time	Duration	Category	Info

16:29:39.380	20.6 ms	yii\db\Command::query	SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)) GROUP BY "object_id"
16:29:39.449	17.3 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 (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)) GROUP BY "object_id"
16:29:39.362	14.1 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, 5409, 5412, 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 "passed" DESC, "b_date" LIMIT 10
16:29:39.349	12.3 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, 5409, 5412, 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 "passed" DESC, "b_date") "c"
16:29:39.469	3.7 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, 170, 'v2/sales-contract/list', '{"SalesContractSearch":{"keyword":"","contract_type":"","handler":"","contract_scan":"","receipt_scan":""},"Filter":{"name":"expire_date","sort":"ASC"},"page":"1","posttime":"1757492978","access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"6","version_code":"170","token":"6fc02726a281720fa68b2756fa9a8b34"}', '{"code":200,"data":{"list":[{"id":3528,"client_id":497,"signed_at":"2024-09-09","amount":"63290","handler":5300,"description":"","created_by":5300,"created_at":"2024-09-09 09:53:27","updated_at":"2024-10-15 13:37:42","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3617,"valid_date":null,"expire_date":"2025-09-20","sla":"","remind_ahead":"7 days","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-SQY-20240809021","payment_collection_remind_ahead":"7 days","from_project":3617,"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":"2024-09-14 14:00:00","is_verify":false,"is_draft":false,"erp_settle_amount":"63290","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":10,"passed":2,"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\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":3528,"comment":16},"project":{"id":3617,"key":3617,"name":"PA\u9632\u706b\u5899\u7eed\u4fdd1\u5e74-G-2024","erpSalesOrder":{"id":1343,"serial_no":"XSDD-20240925-00001","from_date":null,"wrote_date":"2024-09-09","handler":5300,"client_id":497,"purchase_contract_id":null,"project_id":3617,"sales_contract_id":3528,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-25 17:01:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"8","amount":"63290","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-09 09:53:27","updated_at":"2024-09-25 17:01:59","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3617,"key":3617,"name":"PA\u9632\u706b\u5899\u7eed\u4fdd1\u5e74-G-2024","description":"","total_contact_point":"5000","paid_contact_point":"5000","is_sales_order_ready":true,"project_product_version_id":575,"bargain_date":"2024-09-09","collected":"63290","profit_pct":"42.01","budget":"63290","erpSalesOrder":{"id":1343,"serial_no":"XSDD-20240925-00001","from_date":null,"wrote_date":"2024-09-09","handler":5300,"client_id":497,"purchase_contract_id":null,"project_id":3617,"sales_contract_id":3528,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-25 17:01:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"8","amount":"63290","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-09 09:53:27","updated_at":"2024-09-25 17:01:59"},"projectProductTypes":[{"id":5022,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"63290.00","pct":"42.01","project_id":3617,"profit":"26588.129"}],"projectProductRels":[{"id":6718,"project_id":3617,"product_id":1580,"amount":"20200","number":1,"cost":"5253","description":"","supplier_id":68,"hardware_from":"2024-09-21","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-20","software_to":null,"maintenance_to":null,"total_amount":"20200","total_cost":"5253","erp_sales_order_product_id":1213,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1580,"name":"PAN-SVC-BKLN-820-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":256,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support renewal, PA-820","created_by":1013,"created_at":"2024-04-25 11:27:48","updated_at":"2024-04-25 11:27:48","pinyin_shortcut":"PANSVCBKLN820R","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":256,"key":256,"name":"PA820\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1213,"erp_sales_order_id":1343,"erp_store_id":null,"product_id":1580,"description":"","number":"1","outbound":"0","amount":"20200","total_amount":"20200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5253","total_cost":"5253","supplier_id":68,"hardware_from":"2024-09-21","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-20","software_to":null,"maintenance_to":null}},{"id":6715,"project_id":3617,"product_id":376,"amount":"4246","number":3,"cost":"1188","description":"","supplier_id":68,"hardware_from":"2024-09-21","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-20","software_to":null,"maintenance_to":null,"total_amount":"12738","total_cost":"3564","erp_sales_order_product_id":1210,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":376,"name":"PAN-SVC-BKLN-220-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":255,"product_misc":5,"product_qa":2,"pn":"","description":"Partner enabled premium support renewal, PA-220","created_by":1013,"created_at":"2018-06-06 10:57:57","updated_at":"2024-01-12 14:40:05","pinyin_shortcut":"PANSVCBKLN220R","product_unit":8,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":255,"key":255,"name":"PA220\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1210,"erp_sales_order_id":1343,"erp_store_id":null,"product_id":376,"description":"","number":"3","outbound":"0","amount":"4246","total_amount":"12738","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1188","total_cost":"3564","supplier_id":68,"hardware_from":"2024-09-21","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-20","software_to":null,"maintenance_to":null}},{"id":6716,"project_id":3617,"product_id":1775,"amount":"3650","number":2,"cost":"1990","description":"","supplier_id":68,"hardware_from":null,"software_from":"2024-09-21","maintenance_from":null,"hardware_to":null,"software_to":"2025-09-20","maintenance_to":null,"total_amount":"7300","total_cost":"3980","erp_sales_order_product_id":1211,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1775,"name":"PAN-PA-220-ATP-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1501,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced Threat Prevention subscription for device in an HA pair renewal, PA-220","created_by":1013,"created_at":"2024-09-09 17:23:15","updated_at":"2024-09-09 17:23:15","pinyin_shortcut":"PANPA220ATPHA2R","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1501,"key":1501,"name":"PA220 \u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1211,"erp_sales_order_id":1343,"erp_store_id":null,"product_id":1775,"description":"","number":"2","outbound":"0","amount":"3650","total_amount":"7300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1990","total_cost":"3980","supplier_id":68,"hardware_from":null,"software_from":"2024-09-21","maintenance_from":null,"hardware_to":null,"software_to":"2025-09-20","maintenance_to":null}},{"id":6717,"project_id":3617,"product_id":1776,"amount":"18900","number":1,"cost":"9700","description":"","supplier_id":68,"hardware_from":null,"software_from":"2024-09-21","maintenance_from":null,"hardware_to":null,"software_to":"2025-09-20","maintenance_to":null,"total_amount":"18900","total_cost":"9700","erp_sales_order_product_id":1212,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1776,"name":"PAN-PA-820-ATP-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced Threat Prevention subscription renewal, PA-820","created_by":1013,"created_at":"2024-09-09 17:24:21","updated_at":"2024-09-09 17:24:21","pinyin_shortcut":"PANPA820ATPR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1212,"erp_sales_order_id":1343,"erp_store_id":null,"product_id":1776,"description":"","number":"1","outbound":"0","amount":"18900","total_amount":"18900","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"9700","total_cost":"9700","supplier_id":68,"hardware_from":null,"software_from":"2024-09-21","maintenance_from":null,"hardware_to":null,"software_to":"2025-09-20","maintenance_to":null}},{"id":6719,"project_id":3617,"product_id":1777,"amount":"4152","number":1,"cost":"2170","description":"","supplier_id":68,"hardware_from":null,"software_from":"2024-09-21","maintenance_from":null,"hardware_to":null,"software_to":"2025-09-20","maintenance_to":null,"total_amount":"4152","total_cost":"2170","erp_sales_order_product_id":1214,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1777,"name":"PAN-PA-220-ATP-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1501,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced Threat Prevention subscription renewal, PA-220","created_by":1013,"created_at":"2024-09-09 17:25:18","updated_at":"2024-09-09 17:25:18","pinyin_shortcut":"PANPA220ATPR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1501,"key":1501,"name":"PA220 \u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1214,"erp_sales_order_id":1343,"erp_store_id":null,"product_id":1777,"description":"","number":"1","outbound":"0","amount":"4152","total_amount":"4152","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2170","total_cost":"2170","supplier_id":68,"hardware_from":null,"software_from":"2024-09-21","maintenance_from":null,"hardware_to":null,"software_to":"2025-09-20","maintenance_to":null}}],"projectContactPoints":[{"id":684,"project_id":3617,"contact_id":1940,"point":"5000.00","paid_point":"5000","contact":{"id":1940,"key":1940,"name":"\u5546\u5f6c","client_id":497,"supplier_id":null,"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":124,"project_id":3617,"contact_id":1940,"point":"5000.00","day_at":"2024-10-15","description":"","created_at":"2024-10-15 13:37:42"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":9754,"project_id":3617},{"id":9752,"project_id":3617},{"id":9748,"project_id":3617},{"id":9753,"project_id":3617},{"id":9749,"project_id":3617},{"id":9750,"project_id":3617},{"id":9747,"project_id":3617},{"id":9751,"project_id":3617}],"reimbursementAmountSum":{"project_id":3617,"sum":"287"},"profit":26588.129,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":1885,"contract_id":3528,"supplier_id":68,"purchase_id":3530,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":3530,"key":3530,"serial_no":"PA20240909SSS"}}],"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":{"id":530,"key":530,"contract_id":3528,"remind_date":"2025-09-30"},"serviceContractRemindDates":[{"id":530,"key":530,"contract_id":3528,"name":"2025-09-30"},{"id":526,"key":526,"contract_id":3528,"name":"2024-09-30"},{"id":527,"key":527,"contract_id":3528,"name":"2024-12-30"},{"id":528,"key":528,"contract_id":3528,"name":"2025-03-31"},{"id":529,"key":529,"contract_id":3528,"name":"2025-06-30"}],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[{"id":452,"contract_id":3528,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":6801,"user_id":5300,"key":5300,"contract_id":3528,"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":6802,"user_id":5388,"key":5388,"contract_id":3528,"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":6803,"user_id":1001,"key":1001,"contract_id":3528,"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":2037,"key":2037,"contract_id":3528,"name":"2024-09-25","value":"63290","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1116","key":"1116","contract_id":3528,"value":"63290","created_by":5388,"created_at":"2024-09-25 17:01:59","description":null,"collected_date":"2024-09-25 17:01:59","amount":"63290","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1787,"key":1787,"contract_id":3528,"value":"63290.00","attachment_id":null,"from_date":"2024-09-09","attachment":null,"attachmentRelationships":[],"files":[{"id":28503,"object_type":102,"object_id":1787,"attachment_id":21333,"attachment":{"id":21333,"key":21333,"name":"436f07a1-5945-3ad1-b6b2-001f84549496","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/436f07a1-5945-3ad1-b6b2-001f84549496\/dzfp_24112000000125454528_\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20240909113353.pdf","orig_name":"dzfp_24112000000125454528_\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20240909113353.pdf"}}]}],"contractScans":[{"id":29358,"object_type":105,"object_id":3528,"attachment_id":21324,"attachment":{"id":21324,"key":21324,"name":"1018b247-8659-3eeb-942e-07da769a71a9","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1018b247-8659-3eeb-942e-07da769a71a9\/\u7ea2\u661f.pdf","orig_name":"\u7ea2\u661f.pdf"}}],"receiptScans":[{"id":28832,"object_type":106,"object_id":3528,"attachment_id":21599,"attachment":{"id":21599,"key":21599,"name":"10a42aac-2152-3685-8323-53dc16884345","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/10a42aac-2152-3685-8323-53dc16884345\/PA\u7eed\u4fdd\u7684\u4ea4\u4ed8\u6587\u4ef6.pdf","orig_name":"PA\u7eed\u4fdd\u7684\u4ea4\u4ed8\u6587\u4ef6.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":63290,"projectProductTotalAmount":63290,"projectProductAllAmount":true,"projectProductTotalCost":24667,"projectProductAllCost":true,"projectProductTotalCount":8,"invoiced":63290,"un_invoiced":0,"collected":"63290","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":"2025-09-30","remind_ahead_display":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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,"is_chargeback":false,"is_done":false},{"id":3496,"client_id":3281,"signed_at":"2024-08-15","amount":"152959.6","handler":5295,"description":"","created_by":5295,"created_at":"2024-08-27 10:35:34","updated_at":"2024-09-03 13:53:36","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3641,"valid_date":null,"expire_date":"2025-08-22","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-ZHY-2024081501","payment_collection_remind_ahead":"7 days","from_project":3641,"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":"2024-09-02 14:47:53","is_verify":false,"is_draft":false,"erp_settle_amount":"152959.6","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":19,"passed":2,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3496,"comment":11},"project":{"id":3641,"key":3641,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0\u65b0\u8d2d","erpSalesOrder":{"id":1331,"serial_no":"XSDD-20250305-00001","from_date":null,"wrote_date":"2024-08-15","handler":5295,"client_id":3281,"purchase_contract_id":null,"project_id":3641,"sales_contract_id":3496,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-03-05 11:47:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"152959.6","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-27 10:35:34","updated_at":"2025-03-05 11:47:18","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3641,"key":3641,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0\u65b0\u8d2d","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":563,"bargain_date":"2024-08-15","collected":"152959.6","profit_pct":"16.85","budget":"152959.6","erpSalesOrder":{"id":1331,"serial_no":"XSDD-20250305-00001","from_date":null,"wrote_date":"2024-08-15","handler":5295,"client_id":3281,"purchase_contract_id":null,"project_id":3641,"sales_contract_id":3496,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-03-05 11:47:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"152959.6","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-27 10:35:34","updated_at":"2025-03-05 11:47:18"},"projectProductTypes":[{"id":4411,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"152959.6","pct":"16.85","project_id":3641,"profit":"25773.6926"}],"projectProductRels":[{"id":6228,"project_id":3641,"product_id":1774,"amount":"152959.6","number":1,"cost":"119817.98","description":"","supplier_id":583,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"152959.6","total_cost":"119817.98","erp_sales_order_product_id":1179,"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","product_type":22,"product_component":205,"product_brand":219,"product_serie":1500,"product_misc":null,"product_qa":null,"pn":"","description":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248\uff0cFastone Compute Cloud-Enterprise Edition (\u4ee5\u4e0b\u7b80\u79f0FCC-E)\u4e91\u670d\u52a1","created_by":1013,"created_at":"2024-09-02 15:13:25","updated_at":"2024-09-02 15:13:25","pinyin_shortcut":"ssjsyfwqyb","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1500,"key":1500,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1179,"erp_sales_order_id":1331,"erp_store_id":null,"product_id":1774,"description":"","number":"1","outbound":"0","amount":"152959.6","total_amount":"152959.6","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"119817.98","total_cost":"119817.98","supplier_id":583,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":10754,"project_id":3641}],"reimbursementAmountSum":null,"profit":25773.6926,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2488,"contract_id":3496,"supplier_id":583,"purchase_id":3508,"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3508,"key":3508,"serial_no":"TS-ZHY-2024080501"}},{"id":1732,"contract_id":3496,"supplier_id":583,"purchase_id":null,"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":null}],"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":[{"id":8144,"user_id":5295,"key":5295,"contract_id":3496,"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"}}},{"id":8145,"user_id":1011,"key":1011,"contract_id":3496,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6439,"user_id":5295,"key":5295,"contract_id":3496,"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"}}},{"id":6440,"user_id":5388,"key":5388,"contract_id":3496,"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":6441,"user_id":1001,"key":1001,"contract_id":3496,"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":2002,"key":2002,"contract_id":3496,"name":"2024-08-30","value":"83369.8","overdue_days":null,"status":1,"pct":54.5,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2003,"key":2003,"contract_id":3496,"name":"2025-02-14","value":"69589.8","overdue_days":19,"status":1,"pct":45.5,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"178","key":"178","contract_id":3496,"value":"83369.8","created_by":1013,"created_at":"2024-08-28 17:05:51","description":null,"collected_date":"2024-08-28 17:05:51","amount":"83369.8","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":54.5},{"id":"1245","key":"1245","contract_id":3496,"value":"69589.8","created_by":1013,"created_at":"2025-03-05 11:47:18","description":null,"collected_date":"2025-03-05 11:47:18","amount":"69589.8","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":45.5}],"salesContractInvoices":[{"id":2008,"key":2008,"contract_id":3496,"value":"152959.60","attachment_id":null,"from_date":"2025-04-08","attachment":null,"attachmentRelationships":[],"files":[{"id":33425,"object_type":102,"object_id":2008,"attachment_id":25007,"attachment":{"id":25007,"key":25007,"name":"2a992b6a-15e2-3840-84b9-ee9e479213b9","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/2a992b6a-15e2-3840-84b9-ee9e479213b9\/dzfp_25112000000070662990_\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8_20250408173126.pdf","orig_name":"dzfp_25112000000070662990_\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8_20250408173126.pdf"}}]}],"contractScans":[{"id":28375,"object_type":105,"object_id":3496,"attachment_id":21126,"attachment":{"id":21126,"key":21126,"name":"a7c9c25d-d017-3acf-8867-29e746993565","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a7c9c25d-d017-3acf-8867-29e746993565\/\u5bd2\u5e8f.pdf","orig_name":"\u5bd2\u5e8f.pdf"}}],"receiptScans":[{"id":28255,"object_type":106,"object_id":3496,"attachment_id":21160,"attachment":{"id":21160,"key":21160,"name":"1013b651-2b9f-35f6-ab9d-1e5ccb891bc5","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1013b651-2b9f-35f6-ab9d-1e5ccb891bc5\/\u5bd2\u5e8f\u79d1\u6280\u8d27\u7269\u7b7e\u6536\u5355_20240829 1.PDF","orig_name":"\u5bd2\u5e8f\u79d1\u6280\u8d27\u7269\u7b7e\u6536\u5355_20240829 1.PDF"}}],"verifyScans":[],"unreadComments":null,"collected_plan":152959.6,"projectProductTotalAmount":152959.6,"projectProductAllAmount":true,"projectProductTotalCost":119817.98,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":152959.6,"un_invoiced":0,"collected":"152959.6","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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,"is_chargeback":false,"is_done":false},{"id":4044,"client_id":2182,"signed_at":"2025-07-17","amount":"50000","handler":5300,"description":"","created_by":5300,"created_at":"2025-07-17 11:46:31","updated_at":"2025-08-27 15:28:46","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3883,"valid_date":null,"expire_date":"2025-08-17","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"PO-2025-07-0006","payment_collection_remind_ahead":"2 days","from_project":3883,"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-07-17 11:46:31","is_verify":false,"is_draft":false,"erp_settle_amount":"15000","erp_un_settle_amount":"35000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":24,"passed":2,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\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":4044,"comment":10},"project":{"id":3883,"key":3883,"name":"\u673a\u623f\u642c\u8fc1-K-2025","erpSalesOrder":{"id":1546,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-17","handler":5300,"client_id":2182,"purchase_contract_id":null,"project_id":3883,"sales_contract_id":4044,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"50000","created_by":5300,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-17 11:46:31","updated_at":"2025-07-17 11:46:31","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3883,"key":3883,"name":"\u673a\u623f\u642c\u8fc1-K-2025","description":"","total_contact_point":"3000","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":945,"bargain_date":"2025-07-17","collected":"15000","profit_pct":"85.5","budget":"50000","erpSalesOrder":{"id":1546,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-17","handler":5300,"client_id":2182,"purchase_contract_id":null,"project_id":3883,"sales_contract_id":4044,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"50000","created_by":5300,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-17 11:46:31","updated_at":"2025-07-17 11:46:31"},"projectProductTypes":[{"id":6901,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"50000","pct":"85.5","project_id":3883,"profit":"42750"}],"projectProductRels":[{"id":10318,"project_id":3883,"product_id":941,"amount":"50000.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":"50000","total_cost":"0","erp_sales_order_product_id":1792,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1792,"erp_sales_order_id":1546,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"1","amount":"50000.00","total_amount":"50000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":1121,"project_id":3883,"contact_id":3988,"point":"3000.00","paid_point":null,"contact":{"id":3988,"key":3988,"name":"\u5218\u6625","client_id":2182,"supplier_id":null,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":13299,"project_id":3883}],"reimbursementAmountSum":{"project_id":3883,"sum":"1070.27"},"profit":42750,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":3135,"contract_id":4044,"supplier_id":293,"purchase_id":4107,"supplier":{"id":293,"key":293,"name":"\u5317\u4eac\u798f\u9510\u7279\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":4107,"key":4107,"serial_no":"TSKJ20250820-HYF-001"}},{"id":3136,"contract_id":4044,"supplier_id":618,"purchase_id":4108,"supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4108,"key":4108,"serial_no":"TSKJ20250820-ZHF-002"}},{"id":3172,"contract_id":4044,"supplier_id":724,"purchase_id":4119,"supplier":{"id":724,"key":724,"name":"\u5317\u4eac\u56db\u901a\u642c\u5bb6\u6709\u9650\u516c\u53f8"},"purchase":{"id":4119,"key":4119,"serial_no":"TSKJ20250822-ZHF-001"}}],"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":8819,"user_id":5300,"key":5300,"contract_id":4044,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2505,"key":2505,"contract_id":4044,"name":"2025-08-15","value":"15000","overdue_days":null,"status":1,"pct":30,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2506,"key":2506,"contract_id":4044,"name":"2025-09-26","value":"35000","overdue_days":null,"status":0,"pct":70,"collect_status":""}],"salesContractPayments":[{"id":"1365","key":"1365","contract_id":4044,"value":"15000","created_by":1013,"created_at":"2025-07-28 16:49:31","description":null,"collected_date":"2025-07-28 16:49:31","amount":"15000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":30}],"salesContractInvoices":[{"id":2136,"key":2136,"contract_id":4044,"value":"50000.00","attachment_id":null,"from_date":"2025-08-25","attachment":null,"attachmentRelationships":[],"files":[{"id":48890,"object_type":102,"object_id":2136,"attachment_id":27808,"attachment":{"id":27808,"key":27808,"name":"fda98940-e733-3651-a2e8-76bfe918abb9","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/fda98940-e733-3651-a2e8-76bfe918abb9\/dzfp_25112000000178956802_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825155401.pdf","orig_name":"dzfp_25112000000178956802_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825155401.pdf"}}]}],"contractScans":[{"id":48624,"object_type":105,"object_id":4044,"attachment_id":27024,"attachment":{"id":27024,"key":27024,"name":"2a0d69c3-e309-37f7-ae94-01ede6b475f1","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/2a0d69c3-e309-37f7-ae94-01ede6b475f1\/2025_07_22_10_11_51.pdf","orig_name":"2025_07_22_10_11_51.pdf"}}],"receiptScans":[],"verifyScans":[{"id":49172,"object_type":107,"object_id":4044,"attachment_id":27874,"attachment":{"id":27874,"key":27874,"name":"fc097844-47e3-322f-8b0d-8e71fce7b16f","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/fc097844-47e3-322f-8b0d-8e71fce7b16f\/Document_250827_130944\uff08\u88ab\u62d6\u79fb\uff09.pdf","orig_name":"Document_250827_130944\uff08\u88ab\u62d6\u79fb\uff09.pdf"}}],"unreadComments":null,"collected_plan":50000,"projectProductTotalAmount":50000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":50000,"un_invoiced":0,"collected":"15000","un_collected":35000,"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\u524d2\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3459,"client_id":2187,"signed_at":"2024-08-07","amount":"1920","handler":5295,"description":"","created_by":5295,"created_at":"2024-08-07 20:10:47","updated_at":"2024-08-14 09:52:43","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3622,"valid_date":null,"expire_date":"2025-08-09","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-WZW-2024080701","payment_collection_remind_ahead":"7 days","from_project":3622,"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":"2024-08-12 15:28:24","is_verify":false,"is_draft":false,"erp_settle_amount":"1920","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":32,"passed":2,"client":{"id":2187,"key":2187,"name":"\u7d2b\u5149\u540c\u82af\u5fae\u7535\u5b50\u6709\u9650\u516c\u53f8\uff08\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3459,"comment":10},"project":{"id":3622,"key":3622,"name":"2024\u798f\u6615PDF\u6388\u6743\u7eed\u4fdd-\u8fc7\u5355","erpSalesOrder":{"id":1314,"serial_no":"XSDD-20240910-00001","from_date":null,"wrote_date":"2024-08-07","handler":5295,"client_id":2187,"purchase_contract_id":null,"project_id":3622,"sales_contract_id":3459,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-10 10:24:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"10","amount":"1920","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-07 20:10:47","updated_at":"2024-09-10 10:24:30","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3622,"key":3622,"name":"2024\u798f\u6615PDF\u6388\u6743\u7eed\u4fdd-\u8fc7\u5355","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":531,"bargain_date":"2024-08-07","collected":"1920","profit_pct":"8.88","budget":"1920","erpSalesOrder":{"id":1314,"serial_no":"XSDD-20240910-00001","from_date":null,"wrote_date":"2024-08-07","handler":5295,"client_id":2187,"purchase_contract_id":null,"project_id":3622,"sales_contract_id":3459,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-10 10:24:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"10","amount":"1920","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-07 20:10:47","updated_at":"2024-09-10 10:24:30"},"projectProductTypes":[{"id":3148,"product_type_id":65,"key":65,"name":"\u5546\u4e1a\u8f6f\u4ef6","budget":"1920","pct":"8.88","project_id":3622,"profit":"170.496"}],"projectProductRels":[{"id":5933,"project_id":3622,"product_id":1159,"amount":"192","number":10,"cost":"168","description":"","supplier_id":46,"hardware_from":null,"software_from":"2024-08-09","maintenance_from":null,"hardware_to":null,"software_to":"2024-08-09","maintenance_to":null,"total_amount":"1920","total_cost":"1680","erp_sales_order_product_id":1132,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"product":{"id":1159,"name":"\u798f\u6615PDF\u7535\u5b50\u6587\u6863\u5904\u7406\u5957\u88c5\u8f6f\u4ef6V12.0","product_type":7,"product_component":159,"product_brand":166,"product_serie":694,"product_misc":null,"product_qa":null,"pn":"","description":"\u7b80\u4f53\u4e2d\u6587\u6807\u51c6\u7248\u5e74\u8ba2\u9605","created_by":1013,"created_at":"2023-12-20 16:46:16","updated_at":"2023-12-20 16:46:16","pinyin_shortcut":"fxPDFdzwdcltzrjV120","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":166,"key":166,"name":"\u798f\u6615"},"productSerie":{"id":694,"key":694,"name":"PDF \u7535\u5b50\u6587\u6863"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1132,"erp_sales_order_id":1314,"erp_store_id":null,"product_id":1159,"description":"","number":"10","outbound":"0","amount":"192","total_amount":"1920","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"168","total_cost":"1680","supplier_id":46,"hardware_from":null,"software_from":"2024-08-09","maintenance_from":null,"hardware_to":null,"software_to":"2024-08-09","maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9638,"project_id":3622},{"id":11043,"project_id":3622},{"id":11041,"project_id":3622},{"id":11044,"project_id":3622},{"id":11037,"project_id":3622},{"id":11039,"project_id":3622},{"id":11042,"project_id":3622},{"id":11036,"project_id":3622},{"id":11040,"project_id":3622},{"id":11038,"project_id":3622}],"reimbursementAmountSum":null,"profit":170.496,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1650,"contract_id":3459,"supplier_id":46,"purchase_id":3460,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":3460,"key":3460,"serial_no":"DZ202408083100865"}}],"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":[{"id":8127,"user_id":5295,"key":5295,"contract_id":3459,"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"}}},{"id":8128,"user_id":1011,"key":1011,"contract_id":3459,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6188,"user_id":5295,"key":5295,"contract_id":3459,"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"}}},{"id":6189,"user_id":5388,"key":5388,"contract_id":3459,"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":6190,"user_id":1001,"key":1001,"contract_id":3459,"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":1912,"key":1912,"contract_id":3459,"name":"2024-09-14","value":"1920","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"186","key":"186","contract_id":3459,"value":"1920","created_by":1013,"created_at":"2024-09-10 10:24:30","description":null,"collected_date":"2024-09-10 10:24:30","amount":"1920","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1774,"key":1774,"contract_id":3459,"value":"1920.00","attachment_id":null,"from_date":"2024-09-03","attachment":null,"attachmentRelationships":[],"files":[{"id":28380,"object_type":102,"object_id":1774,"attachment_id":21247,"attachment":{"id":21247,"key":21247,"name":"a6bb7810-db5d-340f-809f-dbd44bc845ba","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a6bb7810-db5d-340f-809f-dbd44bc845ba\/dzfp_24112000000121038202_\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8_20240903150018.pdf","orig_name":"dzfp_24112000000121038202_\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8_20240903150018.pdf"}}]},{"id":1778,"key":1778,"contract_id":3459,"value":"-1920.00","attachment_id":null,"from_date":"2024-09-03","attachment":null,"attachmentRelationships":[],"files":[{"id":28381,"object_type":102,"object_id":1778,"attachment_id":21248,"attachment":{"id":21248,"key":21248,"name":"68488a35-0a1f-338e-a752-f2f1f50e3fca","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/68488a35-0a1f-338e-a752-f2f1f50e3fca\/dzfp_24112000000121048652_\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8_20240903150135.pdf","orig_name":"dzfp_24112000000121048652_\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8_20240903150135.pdf"}}]},{"id":1779,"key":1779,"contract_id":3459,"value":"1920.00","attachment_id":null,"from_date":"2024-09-03","attachment":null,"attachmentRelationships":[],"files":[{"id":28382,"object_type":102,"object_id":1779,"attachment_id":21249,"attachment":{"id":21249,"key":21249,"name":"830ab5a9-c9e2-31ae-b437-1df516fa60e1","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/830ab5a9-c9e2-31ae-b437-1df516fa60e1\/dzfp_24112000000121038202_\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8_20240903150018.pdf","orig_name":"dzfp_24112000000121038202_\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8_20240903150018.pdf"}}]}],"contractScans":[{"id":27808,"object_type":105,"object_id":3459,"attachment_id":20798,"attachment":{"id":20798,"key":20798,"name":"999b3b23-02ff-3275-895f-f62bfbae1f27","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/999b3b23-02ff-3275-895f-f62bfbae1f27\/\u4f1f\u4ed5\u4f73\u67701920.pdf","orig_name":"\u4f1f\u4ed5\u4f73\u67701920.pdf"}}],"receiptScans":[{"id":27864,"object_type":106,"object_id":3459,"attachment_id":20915,"attachment":{"id":20915,"key":20915,"name":"6b3d1c1a-220c-307d-a22a-3609d35e77d7","extension":"jpeg","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/6b3d1c1a-220c-307d-a22a-3609d35e77d7\/WechatIMG201.jpeg","orig_name":"WechatIMG201.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1920,"projectProductTotalAmount":1920,"projectProductAllAmount":true,"projectProductTotalCost":1680,"projectProductAllCost":true,"projectProductTotalCount":10,"invoiced":1920,"un_invoiced":0,"collected":"1920","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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,"is_chargeback":false,"is_done":false},{"id":3484,"client_id":2805,"signed_at":"2024-07-25","amount":"60893.32","handler":5295,"description":"","created_by":5295,"created_at":"2024-08-21 16:26:18","updated_at":"2024-09-27 14:55:06","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3632,"valid_date":null,"expire_date":"2025-07-30","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"FS-\u5ba2\u6237\u540d-20240725","payment_collection_remind_ahead":"7 days","from_project":3632,"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":"2024-09-25 10:43:30","is_verify":false,"is_draft":false,"erp_settle_amount":"60893.32","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":42,"passed":2,"client":{"id":2805,"key":2805,"name":"\u5317\u4eac\u65e0\u95ee\u82af\u7a79\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09(EDA)","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":3484,"comment":15},"project":{"id":3632,"key":3632,"name":"\uff08\u8fc7\u5355\uff09\u901f\u77f3\u4ea7\u54c1\u65b0\u8d2d-c","erpSalesOrder":{"id":1324,"serial_no":"XSDD-20241118-00001","from_date":null,"wrote_date":"2024-07-25","handler":5295,"client_id":2805,"purchase_contract_id":null,"project_id":3632,"sales_contract_id":3484,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-11-18 14:39:05","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"129","amount":"60893.32","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-21 16:26:18","updated_at":"2024-11-18 14:39:05","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3632,"key":3632,"name":"\uff08\u8fc7\u5355\uff09\u901f\u77f3\u4ea7\u54c1\u65b0\u8d2d-c","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":560,"bargain_date":"2024-07-25","collected":"60893.32","profit_pct":"6.7","budget":"60893.32","erpSalesOrder":{"id":1324,"serial_no":"XSDD-20241118-00001","from_date":null,"wrote_date":"2024-07-25","handler":5295,"client_id":2805,"purchase_contract_id":null,"project_id":3632,"sales_contract_id":3484,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-11-18 14:39:05","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"129","amount":"60893.32","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-21 16:26:18","updated_at":"2024-11-18 14:39:05"},"projectProductTypes":[{"id":4429,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"60893.32","pct":"6.7","project_id":3632,"profit":"4079.85244"}],"projectProductRels":[{"id":6504,"project_id":3632,"product_id":1529,"amount":"438.46","number":128,"cost":"394.59","description":"","supplier_id":203,"hardware_from":null,"software_from":"2024-07-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-30","maintenance_to":null,"total_amount":"56122.88","total_cost":"50507.52","erp_sales_order_product_id":1163,"supplier":{"id":203,"key":203,"name":"\u5317\u4eac\u5353\u4f18\u4e91\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1529,"name":"FCP-SUITE-CPU-Level1","product_type":7,"product_component":204,"product_brand":219,"product_serie":1319,"product_misc":null,"product_qa":null,"pn":"","description":"FCP-SUITE\u6388\u6743","created_by":1013,"created_at":"2024-03-26 16:14:31","updated_at":"2024-03-26 16:14:31","pinyin_shortcut":"FCPSUITECPULevel1","product_unit":3,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":204,"key":204,"name":"HPC\u8f6f\u4ef6"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1319,"key":1319,"name":"FCP-SUITE\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1163,"erp_sales_order_id":1324,"erp_store_id":null,"product_id":1529,"description":"","number":"128","outbound":"0","amount":"438.46","total_amount":"56122.88","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"394.59","total_cost":"50507.52","supplier_id":203,"hardware_from":null,"software_from":"2024-07-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-30","maintenance_to":null}},{"id":6505,"project_id":3632,"product_id":1530,"amount":"4770.44","number":1,"cost":"4293.77","description":"","supplier_id":203,"hardware_from":null,"software_from":"2024-07-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-30","maintenance_to":null,"total_amount":"4770.44","total_cost":"4293.77","erp_sales_order_product_id":1164,"supplier":{"id":203,"key":203,"name":"\u5317\u4eac\u5353\u4f18\u4e91\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1530,"name":"FCP-Implementation-Level1","product_type":22,"product_component":205,"product_brand":219,"product_serie":1320,"product_misc":null,"product_qa":null,"pn":"","description":"\u901f\u77f3\u57fa\u7840\u90e8\u7f72\u5b89\u88c5\u670d\u52a1A","created_by":1013,"created_at":"2024-03-26 16:15:44","updated_at":"2024-03-26 16:15:44","pinyin_shortcut":"FCPImplementationLevel1","product_unit":7,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1320,"key":1320,"name":"\u901f\u77f3\u57fa\u7840\u90e8\u7f72\u5b89\u88c5\u670d\u52a1A"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1164,"erp_sales_order_id":1324,"erp_store_id":null,"product_id":1530,"description":"","number":"1","outbound":"0","amount":"4770.44","total_amount":"4770.44","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4293.77","total_cost":"4293.77","supplier_id":203,"hardware_from":null,"software_from":"2024-07-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-30","maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":11122,"project_id":3632},{"id":11078,"project_id":3632},{"id":11121,"project_id":3632},{"id":11176,"project_id":3632},{"id":11089,"project_id":3632},{"id":11150,"project_id":3632},{"id":11178,"project_id":3632},{"id":11174,"project_id":3632},{"id":11166,"project_id":3632},{"id":11173,"project_id":3632},{"id":11164,"project_id":3632},{"id":11183,"project_id":3632},{"id":11171,"project_id":3632},{"id":11158,"project_id":3632},{"id":11167,"project_id":3632},{"id":11168,"project_id":3632},{"id":11159,"project_id":3632},{"id":11169,"project_id":3632},{"id":11182,"project_id":3632},{"id":11180,"project_id":3632},{"id":11161,"project_id":3632},{"id":11175,"project_id":3632},{"id":11162,"project_id":3632},{"id":11177,"project_id":3632},{"id":11172,"project_id":3632},{"id":11179,"project_id":3632},{"id":11165,"project_id":3632},{"id":11181,"project_id":3632},{"id":11170,"project_id":3632},{"id":11163,"project_id":3632},{"id":11160,"project_id":3632},{"id":11064,"project_id":3632},{"id":11082,"project_id":3632},{"id":11070,"project_id":3632},{"id":11075,"project_id":3632},{"id":11068,"project_id":3632},{"id":11083,"project_id":3632},{"id":11066,"project_id":3632},{"id":11071,"project_id":3632},{"id":11073,"project_id":3632},{"id":11072,"project_id":3632},{"id":11077,"project_id":3632},{"id":11086,"project_id":3632},{"id":11076,"project_id":3632},{"id":11062,"project_id":3632},{"id":11065,"project_id":3632},{"id":11088,"project_id":3632},{"id":11085,"project_id":3632},{"id":11074,"project_id":3632},{"id":11061,"project_id":3632},{"id":11079,"project_id":3632},{"id":11080,"project_id":3632},{"id":11084,"project_id":3632},{"id":11081,"project_id":3632},{"id":11087,"project_id":3632},{"id":11069,"project_id":3632},{"id":11067,"project_id":3632},{"id":11063,"project_id":3632},{"id":11118,"project_id":3632},{"id":11130,"project_id":3632},{"id":11134,"project_id":3632},{"id":11107,"project_id":3632},{"id":11115,"project_id":3632},{"id":11132,"project_id":3632},{"id":11091,"project_id":3632},{"id":11110,"project_id":3632},{"id":11113,"project_id":3632},{"id":11104,"project_id":3632},{"id":11125,"project_id":3632},{"id":11094,"project_id":3632},{"id":11098,"project_id":3632},{"id":11109,"project_id":3632},{"id":11111,"project_id":3632},{"id":11123,"project_id":3632},{"id":11093,"project_id":3632},{"id":11097,"project_id":3632},{"id":11127,"project_id":3632},{"id":11120,"project_id":3632},{"id":11112,"project_id":3632},{"id":11099,"project_id":3632},{"id":11101,"project_id":3632},{"id":11119,"project_id":3632},{"id":11103,"project_id":3632},{"id":11128,"project_id":3632},{"id":11105,"project_id":3632},{"id":11114,"project_id":3632},{"id":11102,"project_id":3632},{"id":11106,"project_id":3632},{"id":11108,"project_id":3632},{"id":11092,"project_id":3632},{"id":11095,"project_id":3632},{"id":11129,"project_id":3632},{"id":11131,"project_id":3632},{"id":11117,"project_id":3632},{"id":11126,"project_id":3632},{"id":11135,"project_id":3632},{"id":11116,"project_id":3632},{"id":11100,"project_id":3632},{"id":11096,"project_id":3632},{"id":11124,"project_id":3632},{"id":11133,"project_id":3632},{"id":11090,"project_id":3632},{"id":11140,"project_id":3632},{"id":11153,"project_id":3632},{"id":11141,"project_id":3632},{"id":11142,"project_id":3632},{"id":11151,"project_id":3632},{"id":11188,"project_id":3632},{"id":11148,"project_id":3632},{"id":11186,"project_id":3632},{"id":11155,"project_id":3632},{"id":11147,"project_id":3632},{"id":11137,"project_id":3632},{"id":11145,"project_id":3632},{"id":11187,"project_id":3632},{"id":11149,"project_id":3632},{"id":11136,"project_id":3632},{"id":11184,"project_id":3632},{"id":11143,"project_id":3632},{"id":11138,"project_id":3632},{"id":11139,"project_id":3632},{"id":11144,"project_id":3632},{"id":11152,"project_id":3632},{"id":11189,"project_id":3632},{"id":11185,"project_id":3632},{"id":11154,"project_id":3632},{"id":11156,"project_id":3632},{"id":11146,"project_id":3632},{"id":11157,"project_id":3632}],"reimbursementAmountSum":null,"profit":4079.85244,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1827,"contract_id":3484,"supplier_id":203,"purchase_id":3491,"supplier":{"id":203,"key":203,"name":"\u5317\u4eac\u5353\u4f18\u4e91\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3491,"key":3491,"serial_no":"FS-TSKJ-20240725"}}],"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":[{"id":8152,"user_id":5295,"key":5295,"contract_id":3484,"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"}}},{"id":8153,"user_id":1011,"key":1011,"contract_id":3484,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6705,"user_id":5295,"key":5295,"contract_id":3484,"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"}}},{"id":6706,"user_id":5388,"key":5388,"contract_id":3484,"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":6707,"user_id":1001,"key":1001,"contract_id":3484,"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":2055,"key":2055,"contract_id":3484,"name":"2024-11-10","value":"60893.32","overdue_days":8,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1159","key":"1159","contract_id":3484,"value":"60893.32","created_by":1013,"created_at":"2024-11-18 14:39:05","description":null,"collected_date":"2024-11-18 14:39:05","amount":"60893.32","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1805,"key":1805,"contract_id":3484,"value":"60893.32","attachment_id":null,"from_date":"2024-09-25","attachment":null,"attachmentRelationships":[],"files":[{"id":28954,"object_type":102,"object_id":1805,"attachment_id":21691,"attachment":{"id":21691,"key":21691,"name":"2a7cfb72-82e0-3a42-a379-3cdeb9201b7e","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/2a7cfb72-82e0-3a42-a379-3cdeb9201b7e\/dzfp_24112000000138640027_\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8_20240925114730.pdf","orig_name":"dzfp_24112000000138640027_\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8_20240925114730.pdf"}}]}],"contractScans":[{"id":28998,"object_type":105,"object_id":3484,"attachment_id":21089,"attachment":{"id":21089,"key":21089,"name":"efcc7f59-341d-3bbd-8503-f3f70a4e649d","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/efcc7f59-341d-3bbd-8503-f3f70a4e649d\/\u65e0\u95ee\u82af\u7a79.pdf","orig_name":"\u65e0\u95ee\u82af\u7a79.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":60893.32,"projectProductTotalAmount":60893.32,"projectProductAllAmount":true,"projectProductTotalCost":54801.29,"projectProductAllCost":true,"projectProductTotalCount":129,"invoiced":60893.32,"un_invoiced":0,"collected":"60893.32","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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,"is_chargeback":false,"is_done":false},{"id":4049,"client_id":12,"signed_at":"2025-07-21","amount":"598","handler":5300,"description":"","created_by":5300,"created_at":"2025-07-21 10:19:01","updated_at":"2025-07-28 16:59:59","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3924,"valid_date":null,"expire_date":"2025-07-23","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076163","payment_collection_remind_ahead":"1 day","from_project":3924,"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-07-21 10:19:01","is_verify":false,"is_draft":false,"erp_settle_amount":"598","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":49,"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":4049,"comment":8},"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","erpSalesOrder":{"id":1550,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-21","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3924,"sales_contract_id":4049,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"598","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-21 10:19:01","updated_at":"2025-07-21 10:19:01","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":949,"bargain_date":"2025-07-21","collected":"598","profit_pct":"47.17","budget":"598","erpSalesOrder":{"id":1550,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-21","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3924,"sales_contract_id":4049,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"598","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-21 10:19:01","updated_at":"2025-07-21 10:19:01"},"projectProductTypes":[{"id":6818,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"598","pct":"47.17","project_id":3924,"profit":"282.07"}],"projectProductRels":[{"id":10555,"project_id":3924,"product_id":1691,"amount":"299.00","number":2,"cost":"130.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":"598","total_cost":"260","erp_sales_order_product_id":1803,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2025-08-19 16:22:57","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","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":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1803,"erp_sales_order_id":1550,"erp_store_id":null,"product_id":1691,"description":"","number":"2","outbound":"0","amount":"299.00","total_amount":"598","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"130.00","total_cost":"260","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13187,"project_id":3924},{"id":13186,"project_id":3924}],"reimbursementAmountSum":null,"profit":282.0766,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":3044,"contract_id":4049,"supplier_id":608,"purchase_id":4052,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4052,"key":4052,"serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710"}}],"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":8764,"user_id":5300,"key":5300,"contract_id":4049,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2510,"key":2510,"contract_id":4049,"name":"2025-08-29","value":"598","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"12000","key":"12000","contract_id":4049,"value":"598","created_by":5388,"created_at":"2025-08-11 11:01:35","description":"\u6536\u6c47\u6b3e SMC(\u5929\u6d25)","collected_date":"2025-08-11 11:01:35","amount":"598","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":2114,"key":2114,"contract_id":4049,"value":"598.00","attachment_id":null,"from_date":"2025-08-01","attachment":null,"attachmentRelationships":[],"files":[{"id":36218,"object_type":102,"object_id":2114,"attachment_id":27215,"attachment":{"id":27215,"key":27215,"name":"ef2042b3-8db7-3e83-9b39-31f9f269ebdb","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/ef2042b3-8db7-3e83-9b39-31f9f269ebdb\/dzfp_25112000000160738872_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250801100050.pdf","orig_name":"dzfp_25112000000160738872_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250801100050.pdf"}}]}],"contractScans":[{"id":36092,"object_type":105,"object_id":4049,"attachment_id":26998,"attachment":{"id":26998,"key":26998,"name":"f4a478db-9320-3768-9827-dcdd559b15b5","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/f4a478db-9320-3768-9827-dcdd559b15b5\/POTJ25076163.pdf","orig_name":"POTJ25076163.pdf"}}],"receiptScans":[{"id":36023,"object_type":106,"object_id":4049,"attachment_id":27074,"attachment":{"id":27074,"key":27074,"name":"86c8172f-2aa2-3618-932d-6db28daa2e90","extension":"jpg","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/86c8172f-2aa2-3618-932d-6db28daa2e90\/17551753326576_.pic.jpg","orig_name":"17551753326576_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":598,"projectProductTotalAmount":598,"projectProductAllAmount":true,"projectProductTotalCost":260,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":598,"un_invoiced":0,"collected":"598","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,"is_chargeback":false,"is_done":false},{"id":4047,"client_id":2182,"signed_at":"2025-07-18","amount":"19427","handler":5300,"description":"","created_by":5300,"created_at":"2025-07-18 21:45:41","updated_at":"2025-07-28 17:00:34","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3882,"valid_date":null,"expire_date":"2025-07-23","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"PO-2025-07-0012","payment_collection_remind_ahead":"1 day","from_project":3882,"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-07-18 21:45:41","is_verify":false,"is_draft":false,"erp_settle_amount":"19427","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":49,"passed":2,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\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":4047,"comment":9},"project":{"id":3882,"key":3882,"name":"\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-K-2025","erpSalesOrder":{"id":1548,"serial_no":"XSDD-20250728-00001","from_date":null,"wrote_date":"2025-07-18","handler":5300,"client_id":2182,"purchase_contract_id":null,"project_id":3882,"sales_contract_id":4047,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"19427","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-18 21:45:41","updated_at":"2025-07-18 21:45:41","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3882,"key":3882,"name":"\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-K-2025","description":"","total_contact_point":"3750","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":957,"bargain_date":"2025-07-18","collected":"19427","profit_pct":"26.98","budget":"19427","erpSalesOrder":{"id":1548,"serial_no":"XSDD-20250728-00001","from_date":null,"wrote_date":"2025-07-18","handler":5300,"client_id":2182,"purchase_contract_id":null,"project_id":3882,"sales_contract_id":4047,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"19427","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-18 21:45:41","updated_at":"2025-07-18 21:45:41"},"projectProductTypes":[{"id":6819,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"19427","pct":"26.98","project_id":3882,"profit":"5241.40"}],"projectProductRels":[{"id":10556,"project_id":3882,"product_id":2060,"amount":"7088.00","number":1,"cost":"3300.00","description":"","supplier_id":280,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7088","total_cost":"3300","erp_sales_order_product_id":1799,"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2060,"name":"LS-5500V2-28C-EI","product_type":4,"product_component":19,"product_brand":20,"product_serie":1666,"product_misc":null,"product_qa":null,"pn":"","description":"\u4ea4\u6362\u5bb9\u91cf\uff1a758Gbps\/7.58Tbps\uff0c\u5305\u8f6c\u53d1\u7387\uff1a222Mpps\uff0c24 \u4e2a 10\/100\/1000BASE-T \u7aef\u53e3(\u542b 8 Combo\u53e3),4 \u4e2a 1G\/10GBASE-X SFP Plus \u7aef\u53e3,1 \u4e2a Slot\uff1b","created_by":1013,"created_at":"2025-07-22 09:47:26","updated_at":"2025-07-22 09:47:26","pinyin_shortcut":"LS5500V228CEI","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1666,"key":1666,"name":"H3C S5500V2-EI\u7cfb\u5217\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1799,"erp_sales_order_id":1548,"erp_store_id":null,"product_id":2060,"description":"","number":"1","outbound":"0","amount":"7088.00","total_amount":"7088","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3300.00","total_cost":"3300","supplier_id":280,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10557,"project_id":3882,"product_id":2061,"amount":"4293.00","number":2,"cost":"1500.00","description":"","supplier_id":280,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"8586","total_cost":"3000","erp_sales_order_product_id":1800,"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2061,"name":"WA7230-LI","product_type":4,"product_component":21,"product_brand":20,"product_serie":1667,"product_misc":null,"product_qa":null,"pn":"","description":"\u65b0\u4e00\u4ee3Wi-Fi 7\uff08802.11be\uff09AP\u4ea7\u54c1\uff0c4\u4e2a\u4ee5\u592a\u63a5\u53e3\uff081\u4e2a100\/1000M\/2.5G\u7535\u53e3\uff0c1\u4e2a2.5G PSFP\u5149\u53e3\u517c\u5bb9SFP\uff0c2\u4e2a10\/100\/1000M\u7535\u53e3\uff0c\u5176\u4e2d\u4e00\u4e2a\u652f\u6301Poe out\u5bf9\u5916\u4f9b\u7535\uff0c\u53ef\u7528\u4e8e\u6269\u5c55\u7269\u8054\u7f51\uff09\uff1b2.5GE\u7535\u53e3 802.3bt\/at\u4f9b\u7535\uff0c2.5G\u5149\u53e3 802.3bt\/at\u5149\u7535\u590d\u5408\u4f9b\u7535\uff1b\u652f\u630154V DC\uff1b\u5185\u7f6e\u667a\u80fd\u5929\u7ebf\u7cfb\u7edf\uff1b\u5ba4\u5185\u653e\u88c5\u578b\uff0c5GHz 22 MIMO+5GHz 22 MIMO+2.4GHz 22 MIMO ","created_by":1013,"created_at":"2025-07-22 09:55:13","updated_at":"2025-07-22 09:55:13","pinyin_shortcut":"WA7230LI","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":21,"key":21,"name":"\u65e0\u7ebfAP"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1667,"key":1667,"name":"H3C \u9ad8\u5bc6\u653e\u88c5AP"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1800,"erp_sales_order_id":1548,"erp_store_id":null,"product_id":2061,"description":"","number":"2","outbound":"0","amount":"4293.00","total_amount":"8586","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1500.00","total_cost":"3000","supplier_id":280,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10558,"project_id":3882,"product_id":2062,"amount":"3753.00","number":1,"cost":"1700.00","description":"","supplier_id":280,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"3753","total_cost":"1700","erp_sales_order_product_id":1801,"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2062,"name":"WX2510X-PWR-LI","product_type":4,"product_component":22,"product_brand":20,"product_serie":1668,"product_misc":null,"product_qa":null,"pn":"","description":"WAN\uff1a2GE\uff1bLAN\uff1a7GE POE Plus + 1SFP+1*Console\uff1b\u541e\u5410\u91cf\uff1a3Gbps\uff1b\u6700\u5927\u7ba1\u7406AP\u6570\uff1a32\uff08\u666e\u901aAP\uff09\uff1b\u81ea\u5e268\u4e2aAP\u6388\u6743","created_by":1013,"created_at":"2025-07-22 09:58:43","updated_at":"2025-07-22 09:58:43","pinyin_shortcut":"WX2510XPWRLI","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":22,"key":22,"name":"\u65e0\u7ebf\u63a7\u5236\u5668"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1668,"key":1668,"name":"H3C WX2510X-LI\u7cfb\u5217\u65e0\u7ebf\u63a7\u5236\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1801,"erp_sales_order_id":1548,"erp_store_id":null,"product_id":2062,"description":"","number":"1","outbound":"0","amount":"3753.00","total_amount":"3753","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1700.00","total_cost":"1700","supplier_id":280,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":1102,"project_id":3882,"contact_id":3988,"point":"3750.00","paid_point":null,"contact":{"id":3988,"key":3988,"name":"\u5218\u6625","client_id":2182,"supplier_id":null,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":13194,"project_id":3882},{"id":13195,"project_id":3882},{"id":13197,"project_id":3882},{"id":13196,"project_id":3882}],"reimbursementAmountSum":null,"profit":5241.4046,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":3045,"contract_id":4047,"supplier_id":280,"purchase_id":4053,"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4053,"key":4053,"serial_no":"A20250721"}}],"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":8765,"user_id":5300,"key":5300,"contract_id":4047,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2508,"key":2508,"contract_id":4047,"name":"2025-08-29","value":"19427","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"12007","key":"12007","contract_id":4047,"value":"19427","created_by":1013,"created_at":"2025-08-15 17:01:05","description":"","collected_date":"2025-08-15 17:01:05","amount":"19427","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2134,"key":2134,"contract_id":4047,"value":"19427.00","attachment_id":null,"from_date":"2025-08-25","attachment":null,"attachmentRelationships":[],"files":[{"id":48886,"object_type":102,"object_id":2134,"attachment_id":27806,"attachment":{"id":27806,"key":27806,"name":"a9431f4b-69c9-39ea-a0f5-328e43c79102","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a9431f4b-69c9-39ea-a0f5-328e43c79102\/dzfp_25112000000178916366_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825154724.pdf","orig_name":"dzfp_25112000000178916366_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825154724.pdf"}}]}],"contractScans":[{"id":36094,"object_type":105,"object_id":4047,"attachment_id":27071,"attachment":{"id":27071,"key":27071,"name":"c6aed3a2-0dc8-3735-afe7-1a111ba10ec8","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/c6aed3a2-0dc8-3735-afe7-1a111ba10ec8\/2025_07_24_10_01_21.pdf","orig_name":"2025_07_24_10_01_21.pdf"}}],"receiptScans":[{"id":36058,"object_type":106,"object_id":4047,"attachment_id":27105,"attachment":{"id":27105,"key":27105,"name":"ae579ec3-ba6b-36d0-ae40-e5cc0829f422","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/ae579ec3-ba6b-36d0-ae40-e5cc0829f422\/2025_07_25_17_29_29.pdf","orig_name":"2025_07_25_17_29_29.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":19427,"projectProductTotalAmount":19427,"projectProductAllAmount":true,"projectProductTotalCost":8000,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":19427,"un_invoiced":0,"collected":"19427","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,"is_chargeback":false,"is_done":false},{"id":4050,"client_id":12,"signed_at":"2025-07-21","amount":"590","handler":5300,"description":"","created_by":5300,"created_at":"2025-07-21 10:21:43","updated_at":"2025-07-28 10:09:22","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3925,"valid_date":null,"expire_date":"2025-07-23","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076289","payment_collection_remind_ahead":"1 day","from_project":3925,"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-07-21 10:21:43","is_verify":false,"is_draft":false,"erp_settle_amount":"590","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":49,"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":4050,"comment":8},"project":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","erpSalesOrder":{"id":1551,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-21","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3925,"sales_contract_id":4050,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"590","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-21 10:21:43","updated_at":"2025-07-21 10:21:43","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":948,"bargain_date":"2025-07-21","collected":"590","profit_pct":"26.22","budget":"590","erpSalesOrder":{"id":1551,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-21","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3925,"sales_contract_id":4050,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"590","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-21 10:21:43","updated_at":"2025-07-21 10:21:43"},"projectProductTypes":[{"id":6803,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"590","pct":"26.22","project_id":3925,"profit":"154.69"}],"projectProductRels":[{"id":10509,"project_id":3925,"product_id":1690,"amount":"295.00","number":2,"cost":"199.31","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"590","total_cost":"398.63","erp_sales_order_product_id":1804,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"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":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1804,"erp_sales_order_id":1551,"erp_store_id":null,"product_id":1690,"description":"","number":"2","outbound":"0","amount":"295.00","total_amount":"590","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"199.31","total_cost":"398.63","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13185,"project_id":3925},{"id":13184,"project_id":3925}],"reimbursementAmountSum":null,"profit":154.698,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":3029,"contract_id":4050,"supplier_id":608,"purchase_id":4052,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4052,"key":4052,"serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710"}}],"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":8750,"user_id":5300,"key":5300,"contract_id":4050,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2511,"key":2511,"contract_id":4050,"name":"2025-08-29","value":"590","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"12001","key":"12001","contract_id":4050,"value":"590","created_by":5388,"created_at":"2025-08-11 11:02:40","description":"\u6536\u6c47\u6b3e SMC\uff08\u5929\u6d25\uff09","collected_date":"2025-08-11 11:02:40","amount":"590","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":2115,"key":2115,"contract_id":4050,"value":"590.00","attachment_id":null,"from_date":"2025-08-01","attachment":null,"attachmentRelationships":[],"files":[{"id":36217,"object_type":102,"object_id":2115,"attachment_id":27216,"attachment":{"id":27216,"key":27216,"name":"8de32707-e019-320f-84d4-7adafee892bf","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/8de32707-e019-320f-84d4-7adafee892bf\/dzfp_25112000000160738872_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250801100050.pdf","orig_name":"dzfp_25112000000160738872_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250801100050.pdf"}}]}],"contractScans":[{"id":36063,"object_type":105,"object_id":4050,"attachment_id":26999,"attachment":{"id":26999,"key":26999,"name":"bcc49887-5ca5-3547-8746-980e4396254c","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/bcc49887-5ca5-3547-8746-980e4396254c\/POTJ25076289.pdf","orig_name":"POTJ25076289.pdf"}}],"receiptScans":[{"id":36022,"object_type":106,"object_id":4050,"attachment_id":27073,"attachment":{"id":27073,"key":27073,"name":"93830d5e-5ee5-3b69-9560-8945e4ce90a4","extension":"jpg","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/93830d5e-5ee5-3b69-9560-8945e4ce90a4\/17541753326549_.pic.jpg","orig_name":"17541753326549_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":590,"projectProductTotalAmount":590,"projectProductAllAmount":true,"projectProductTotalCost":398.63,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":590,"un_invoiced":0,"collected":"590","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,"is_chargeback":false,"is_done":false},{"id":4020,"client_id":2526,"signed_at":"2025-07-10","amount":"25000","handler":5087,"description":"","created_by":5087,"created_at":"2025-07-10 16:33:24","updated_at":"2025-08-04 10:40:16","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3911,"valid_date":null,"expire_date":"2025-07-22","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"","payment_collection_remind_ahead":"30 days","from_project":3911,"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-07-10 16:33:24","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"25000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":50,"passed":2,"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","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":4020,"comment":5},"project":{"id":3911,"key":3911,"name":"\u8d22\u52a1\u7528\u9632\u706b\u5899","erpSalesOrder":{"id":1535,"serial_no":"XSDD-20250803-00001","from_date":null,"wrote_date":"2025-07-10","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":3911,"sales_contract_id":4020,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"25000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-10 16:33:24","updated_at":"2025-07-10 16:33:24","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3911,"key":3911,"name":"\u8d22\u52a1\u7528\u9632\u706b\u5899","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":940,"bargain_date":"2025-07-10","collected":"0","profit_pct":"32.8","budget":"25000","erpSalesOrder":{"id":1535,"serial_no":"XSDD-20250803-00001","from_date":null,"wrote_date":"2025-07-10","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":3911,"sales_contract_id":4020,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"25000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-10 16:33:24","updated_at":"2025-07-10 16:33:24"},"projectProductTypes":[{"id":6812,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"25000","pct":"32.8","project_id":3911,"profit":"8200"}],"projectProductRels":[{"id":10529,"project_id":3911,"product_id":2040,"amount":"25000.00","number":1,"cost":"15000.00","description":"","supplier_id":712,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"25000","total_cost":"15000","erp_sales_order_product_id":1753,"supplier":{"id":712,"key":712,"name":"\u5317\u4eac\u793a\u76ee\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2040,"name":"NGFW4000\uff08C\uff09","product_type":4,"product_component":23,"product_brand":11,"product_serie":1657,"product_misc":null,"product_qa":null,"pn":"","description":"\u5929\u878d\u4fe1\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edfV3","created_by":1013,"created_at":"2025-07-15 13:46:21","updated_at":"2025-07-15 13:46:21","pinyin_shortcut":"NGFW4000C","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":11,"key":11,"name":"\u5929\u878d\u4fe1"},"productSerie":{"id":1657,"key":1657,"name":"\u5929\u878d\u4fe1\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edfV3"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1753,"erp_sales_order_id":1535,"erp_store_id":null,"product_id":2040,"description":"","number":"1","outbound":"0","amount":"25000.00","total_amount":"25000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"15000.00","total_cost":"15000","supplier_id":712,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13158,"project_id":3911}],"reimbursementAmountSum":{"project_id":3911,"sum":"226"},"profit":8200,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":3039,"contract_id":4020,"supplier_id":712,"purchase_id":4034,"supplier":{"id":712,"key":712,"name":"\u5317\u4eac\u793a\u76ee\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4034,"key":4034,"serial_no":"TSKJ20250715-HYF-001"}}],"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":8760,"user_id":5087,"key":5087,"contract_id":4020,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2488,"key":2488,"contract_id":4020,"name":"2025-12-31","value":"22500","overdue_days":null,"status":0,"pct":90,"collect_status":""},{"id":2489,"key":2489,"contract_id":4020,"name":"2026-08-31","value":"2500","overdue_days":null,"status":0,"pct":10,"collect_status":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[{"id":37458,"object_type":106,"object_id":4020,"attachment_id":27225,"attachment":{"id":27225,"key":27225,"name":"5837199f-d536-309c-adac-f326721fe3b4","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/5837199f-d536-309c-adac-f326721fe3b4\/2025_08_04_10_38_54.pdf","orig_name":"2025_08_04_10_38_54.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":25000,"projectProductTotalAmount":25000,"projectProductAllAmount":true,"projectProductTotalCost":15000,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":25000,"collected":"0","un_collected":25000,"is_collected":false,"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\u524d30\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3662,"client_id":427,"signed_at":"2024-11-08","amount":"20000","handler":5295,"description":"","created_by":5295,"created_at":"2024-11-14 10:13:16","updated_at":"2024-12-18 09:27:39","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3712,"valid_date":null,"expire_date":"2025-11-01","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-WZW-2024110801","payment_collection_remind_ahead":"","from_project":3712,"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":"2024-11-26 09:46:33","is_verify":false,"is_draft":false,"erp_settle_amount":"20000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":52,"passed":2,"client":{"id":427,"key":427,"name":"\u7eff\u6676\u534a\u5bfc\u4f53\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\/\u7eff\u82af\u534a\u5bfc\u4f53\uff08\u53a6\u95e8\uff09\u6709\u9650\u516c\u53f8","logo":"","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":3662,"comment":8},"project":{"id":3712,"key":3712,"name":"2024\u5b58\u50a8\u7eed\u4fdd","erpSalesOrder":{"id":1387,"serial_no":"XSDD-20241125-00001","from_date":null,"wrote_date":"2024-11-08","handler":5295,"client_id":427,"purchase_contract_id":null,"project_id":3712,"sales_contract_id":3662,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-11-25 16:51:37","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"20000","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-11-14 10:13:16","updated_at":"2024-11-25 16:51:37","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3712,"key":3712,"name":"2024\u5b58\u50a8\u7eed\u4fdd","description":"","total_contact_point":"7000","paid_contact_point":"7000","is_sales_order_ready":true,"project_product_version_id":668,"bargain_date":"2024-11-08","collected":"20000","profit_pct":"52.75","budget":"20000","erpSalesOrder":{"id":1387,"serial_no":"XSDD-20241125-00001","from_date":null,"wrote_date":"2024-11-08","handler":5295,"client_id":427,"purchase_contract_id":null,"project_id":3712,"sales_contract_id":3662,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-11-25 16:51:37","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"20000","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-11-14 10:13:16","updated_at":"2024-11-25 16:51:37"},"projectProductTypes":[{"id":5724,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"20000.00","pct":"52.75","project_id":3712,"profit":"10550"}],"projectProductRels":[{"id":7992,"project_id":3712,"product_id":941,"amount":"20000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-11-02","hardware_to":null,"software_to":null,"maintenance_to":"2025-11-01","total_amount":"20000","total_cost":"0","erp_sales_order_product_id":1364,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1364,"erp_sales_order_id":1387,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"20000","total_amount":"20000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-11-02","hardware_to":null,"software_to":null,"maintenance_to":"2025-11-01"}}],"projectContactPoints":[{"id":778,"project_id":3712,"contact_id":980,"point":"7000.00","paid_point":"7000","contact":{"id":980,"key":980,"name":"\u738b\u4e00\u6960","client_id":427,"supplier_id":null,"client":{"id":427,"key":427,"name":"\u7eff\u6676\u534a\u5bfc\u4f53\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\/\u7eff\u82af\u534a\u5bfc\u4f53\uff08\u53a6\u95e8\uff09\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":139,"project_id":3712,"contact_id":980,"point":"7000.00","day_at":"2024-12-12","description":"","created_at":"2024-12-18 09:27:38"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12270,"project_id":3712}],"reimbursementAmountSum":null,"profit":10550,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8245,"user_id":5295,"key":5295,"contract_id":3662,"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"}}},{"id":8246,"user_id":1011,"key":1011,"contract_id":3662,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7353,"user_id":5295,"key":5295,"contract_id":3662,"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"}}},{"id":7354,"user_id":5388,"key":5388,"contract_id":3662,"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":7355,"user_id":1001,"key":1001,"contract_id":3662,"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":2169,"key":2169,"contract_id":3662,"name":"2024-12-20","value":"20000","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1164","key":"1164","contract_id":3662,"value":"20000","created_by":1013,"created_at":"2024-11-25 16:51:37","description":null,"collected_date":"2024-11-25 16:51:37","amount":"20000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1875,"key":1875,"contract_id":3662,"value":"20000.00","attachment_id":null,"from_date":"2024-11-26","attachment":null,"attachmentRelationships":[],"files":[{"id":30684,"object_type":102,"object_id":1875,"attachment_id":22931,"attachment":{"id":22931,"key":22931,"name":"c1a71516-152b-36a3-bf21-151b71af1bb6","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/c1a71516-152b-36a3-bf21-151b71af1bb6\/dzfp_24112000000192376546_\u7eff\u82af\u534a\u5bfc\u4f53\uff08\u53a6\u95e8\uff09\u6709\u9650\u516c\u53f8_20241126155327.pdf","orig_name":"dzfp_24112000000192376546_\u7eff\u82af\u534a\u5bfc\u4f53\uff08\u53a6\u95e8\uff09\u6709\u9650\u516c\u53f8_20241126155327.pdf"}}]}],"contractScans":[{"id":31172,"object_type":105,"object_id":3662,"attachment_id":22864,"attachment":{"id":22864,"key":22864,"name":"a8291819-d477-31c4-83a4-9aaec73d3bed","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a8291819-d477-31c4-83a4-9aaec73d3bed\/\u7eff\u82af\u534a\u5bfc\u4f53.pdf","orig_name":"\u7eff\u82af\u534a\u5bfc\u4f53.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":20000,"projectProductTotalAmount":20000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":20000,"un_invoiced":0,"collected":"20000","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false}],"pagenation":{"totalcount":1602,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 16:29:39') RETURNING "id"
16:29:39.432	3.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' \|\| r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' \|\| r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' \|\| r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662) ORDER BY "id" DESC
16:29:39.408	2.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (941, 2040, 2060, 2061, 2062, 1691, 1690, 1580, 1529, 1530, 1159, 1774, 376, 1775, 1776, 1777)
16:29:39.340	2.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
16:29:39.419	2.2 ms	yii\db\Command::query	SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883))
16:29:39.439	1.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1774, 1778, 1779, 1787, 1805, 1875, 2008, 2114, 2115, 2134, 2136))
16:29:39.338	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:29:39.437	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1774, 1778, 1779, 1787, 1805, 1875, 2008, 2114, 2115, 2134, 2136))
16:29:39.442	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662))
16:29:39.444	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662))
16:29:39.424	1.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3508, 3460, 3491, 3530, 4107, 4108, 4052, 4034, 4053, 4119)
16:29:39.447	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662))
16:29:39.414	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (1792, 1753, 1799, 1800, 1801, 1803, 1364, 1804, 1213, 1163, 1164, 1132, 1179, 1210, 1211, 1212, 1214)
16:29:39.421	1.6 ms	yii\db\Command::query	SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883)) GROUP BY "project_id"
16:29:39.412	1.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1319, 1320, 256, 1438, 1439, 592, 1657, 1500, 1501, 975, 1666, 1667, 1668, 255, 694)
16:29:39.343	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:29:39.376	1.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (497, 3281, 2182, 2187, 2805, 12, 2526, 427)
16:29:39.417	1.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (1940, 3988, 980)
16:29:39.402	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883))
16:29:39.405	0.7 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 (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883)
16:29:39.406	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883)
16:29:39.436	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662) ORDER BY "id"
16:29:39.405	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883))
16:29:39.432	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662) ORDER BY "remind_date"
16:29:39.427	0.5 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 (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)) ORDER BY "remind_date"
16:29:39.441	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21691, 22931, 21247, 21248, 21249, 21333, 25007, 27216, 27215, 27806, 27808)
16:29:39.428	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 (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)
16:29:39.423	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)
16:29:39.431	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 (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)
16:29:39.407	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (712, 280, 608, 68, 203, 46, 583)
16:29:39.401	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3617, 3641, 3883, 3622, 3632, 3924, 3882, 3925, 3911, 3712)
16:29:39.404	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 (3617, 3641, 3883, 3622, 3632, 3924, 3882, 3925, 3911, 3712)
16:29:39.378	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 (5295, 5087, 5300))
16:29:39.418	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((1940, 3617), (3988, 3882), (980, 3712), (3988, 3883))
16:29:39.380	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
16:29:39.416	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3617, 3712, 3911, 3622, 3641, 3632, 3925, 3924, 3882, 3883)
16:29:39.403	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1546, 1535, 1548, 1550, 1551, 1314, 1324, 1331, 1343, 1387) ORDER BY "id"
16:29:39.411	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 22, 5, 11, 19, 4)
16:29:39.411	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (204, 205, 35, 179, 151, 23, 36, 19, 21, 22, 159)
16:29:39.412	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (219, 8, 10, 43, 133, 11, 20, 166)
16:29:39.429	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)
16:29:39.404	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1546, 1535, 1548, 1550, 1551, 1314, 1324, 1331, 1343, 1387) ORDER BY "id"
16:29:39.426	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)
16:29:39.444	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21089, 21324, 20798, 21126, 22864, 26999, 26998, 27071, 27024)
16:29:39.414	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 7, 2, 6, 1, 8)
16:29:39.424	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (583, 46, 203, 68, 293, 618, 608, 712, 280, 724)
16:29:39.446	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (20915, 21160, 21599, 27073, 27074, 27105, 27225)
16:29:39.378	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5300, 5087)
16:29:39.379	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 5087)
16:29:39.436	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5388)
16:29:39.418	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (427, 497, 2182)
16:29:39.428	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 (3528, 3496, 4044, 3459, 3484, 4049, 4047, 4050, 4020, 3662)
16:29:39.427	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 5087)
16:29:39.430	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
16:29:39.429	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1011)
16:29:39.379	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 (5295, 5087, 5300))
16:29:39.427	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 (5295, 5087, 5300))
16:29:39.431	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5388, 1001, 5087, 5300)
16:29:39.431	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, 5388, 5087, 5300))
16:29:39.448	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27874
16:29:39.429	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5295))
16:29:39.430	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"=5300)