Total processing time: 350 ms; Peak memory: 7.705 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 12:00:06.141 | 59.9 ms | yii\db\Command::query | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230)) GROUP BY "object_id" |
| 12:00:06.316 | 43.9 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 (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230)) GROUP BY "object_id" |
| 12:00:06.102 | 14.1 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 "client"."id"='2032' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 12:00:06.061 | 13.0 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm' |
| 12:00:06.117 | 12.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 "client"."id"='2032' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 12:00:06.303 | 9.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230)) |
| 12:00:06.387 | 6.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", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/sales-contract/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"2032","page":"1","token":"acdf653bb9d290543e87fce3f8ae83a2","posttime":"1783915206"}', '{"code":200,"data":{"list":[{"id":4430,"client_id":2032,"signed_at":"2026-03-04","amount":"3900","handler":5295,"description":"","created_by":5295,"created_at":"2026-03-04 09:19:27","updated_at":"2026-06-26 17:29:35","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4130,"valid_date":null,"expire_date":"2027-03-10","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"\u5317\u4eac\u7075\u72d0\u4f20\u797aTS-WZW-20260309-001","payment_collection_remind_ahead":"","from_project":4130,"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":"2026-03-04 09:19:27","is_verify":false,"is_draft":true,"erp_settle_amount":"3900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3900","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":true,"b_date":240,"passed":2,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4430,"comment":6},"project":{"id":4130,"key":4130,"name":"2026\u9632\u706b\u5899\u7eed\u4fdd","erpSalesOrder":{"id":1688,"serial_no":"XSDD-20260304-00001","from_date":null,"wrote_date":"2026-03-04","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":4130,"sales_contract_id":4430,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-03-04 09:19:27","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"3900\",\"remind_date\":\"2026-03-31\",\"pct\":1}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-03-04 09:18:25","updated_at":"2026-03-04 09:19:27","print_times":null,"erpSalesOrderVerifyRels":[{"id":126,"erp_sales_order_id":1688,"user_id":1001,"status":1,"description":null,"verify_at":"2026-03-04 09:19:27"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1688,"serial_no":"XSDD-20260304-00001","from_date":null,"wrote_date":"2026-03-04","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":4130,"sales_contract_id":4430,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-03-04 09:19:27","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"3900\",\"remind_date\":\"2026-03-31\",\"pct\":1}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-03-04 09:18:25","updated_at":"2026-03-04 09:19:27","print_times":null,"erpSalesOrderVerifyRels":[{"id":126,"erp_sales_order_id":1688,"user_id":1001,"status":1,"description":null,"verify_at":"2026-03-04 09:19:27"}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4130,"key":4130,"name":"2026\u9632\u706b\u5899\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1331,"bargain_date":"2026-03-04","collected":"3900","profit_pct":"32.26","budget":"3900","erpSalesOrder":{"id":1688,"serial_no":"XSDD-20260304-00001","from_date":null,"wrote_date":"2026-03-04","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":4130,"sales_contract_id":4430,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-03-04 09:19:27","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"3900\",\"remind_date\":\"2026-03-31\",\"pct\":1}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-03-04 09:18:25","updated_at":"2026-03-04 09:19:27","print_times":null},"projectProductTypes":[{"id":8478,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"3900","pct":"32.26","project_id":4130,"profit":"1258.14"}],"projectProductRels":[{"id":12011,"project_id":4130,"product_id":867,"amount":"1300","number":1,"cost":"777","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1300","total_cost":"777","erp_sales_order_product_id":2204,"supplier":null,"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2204,"erp_sales_order_id":1688,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"1","amount":"1300","total_amount":"1300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"777","total_cost":"777","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12012,"project_id":4130,"product_id":868,"amount":"1400","number":1,"cost":"713","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1400","total_cost":"713","erp_sales_order_product_id":2205,"supplier":null,"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2205,"erp_sales_order_id":1688,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"1","amount":"1400","total_amount":"1400","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"713","total_cost":"713","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12013,"project_id":4130,"product_id":870,"amount":"1200","number":1,"cost":"874","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":"874","erp_sales_order_product_id":2206,"supplier":null,"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2206,"erp_sales_order_id":1688,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"1","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"874","total_cost":"874","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13940,"project_id":4130},{"id":13941,"project_id":4130},{"id":13942,"project_id":4130}],"reimbursementAmountSum":null,"profit":1258.14,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4216,"contract_id":4430,"supplier_id":686,"purchase_id":4435,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchase":{"id":4435,"key":4435,"serial_no":"TSKJ20260309-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8894,"user_id":5295,"key":5295,"contract_id":4430,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2759,"key":2759,"contract_id":4430,"name":"2026-03-31","value":"3900","overdue_days":null,"status":1,"remind_date":"2026-03-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"12186","key":"12186","contract_id":4430,"value":"3900","created_by":1013,"created_at":"2026-03-09 14:51:42","description":null,"collected_date":"2026-03-09 00:00:00","amount":"3900","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2315,"key":2315,"contract_id":4430,"value":"3900","attachment_id":null,"from_date":"2026-03-04","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":2967,"sales_invoice_id":2315,"amount":"3900","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":56746,"object_type":102,"object_id":2315,"attachment_id":32165,"attachment":{"id":32165,"key":32165,"name":"14825be0-14f2-3cf1-8993-7db3a791f89f","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/14825be0-14f2-3cf1-8993-7db3a791f89f\/dzfp_26112000000829359436_\u5317\u4eac\u7075\u72d0\u4f20\u797a\u79d1\u6280\u6709\u9650\u516c\u53f8_20260304140520.pdf","orig_name":"dzfp_26112000000829359436_\u5317\u4eac\u7075\u72d0\u4f20\u797a\u79d1\u6280\u6709\u9650\u516c\u53f8_20260304140520.pdf"}}]}],"contractScans":[{"id":57702,"object_type":105,"object_id":4430,"attachment_id":32309,"attachment":{"id":32309,"key":32309,"name":"8e00d6fd-23d1-3411-a162-cf65bda87d17","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8e00d6fd-23d1-3411-a162-cf65bda87d17\/2026_03_13_15_39_57.pdf","orig_name":"2026_03_13_15_39_57.pdf"}}],"receiptScans":[{"id":57340,"object_type":106,"object_id":4430,"attachment_id":32492,"attachment":{"id":32492,"key":32492,"name":"f533deec-0862-303b-bd28-8e79de9c4c55","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f533deec-0862-303b-bd28-8e79de9c4c55\/74161774239526_.pic.jpg","orig_name":"74161774239526_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":3900,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":2364,"projectProductAllCost":true,"projectProductTotalCount":3,"invoiced":"3900","un_invoiced":0,"collected":"3900","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":true,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":4086,"client_id":2032,"signed_at":"2025-08-11","amount":"11779","handler":5295,"description":"","created_by":5295,"created_at":"2025-08-11 15:53:56","updated_at":"2026-01-14 09:38:00","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3936,"valid_date":null,"expire_date":"2026-08-11","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-WZW-2025080401","payment_collection_remind_ahead":"1 day","from_project":3936,"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-08-11 15:53:56","is_verify":false,"is_draft":false,"erp_settle_amount":"11779","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"11779","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":29,"passed":2,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4086,"comment":6},"project":{"id":3936,"key":3936,"name":"2025\u5e74\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","erpSalesOrder":{"id":1563,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3936,"sales_contract_id":4086,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-11 15:53:55","stop_at":"2025-08-15 15:03:00.658357+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"11779","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5295\"],\"salesContractPaymentCollectionRemindDates\":{\"2025-09-30\":\"11779.00\"}}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":false,"created_at":"2025-08-11 11:02:32","updated_at":"2025-08-15 15:03:41","print_times":null,"erpSalesOrderVerifyRels":[{"id":1,"erp_sales_order_id":1563,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-11 15:53:55"}],"erpSalesOrderStopVerifyRels":[{"id":1,"erp_sales_order_id":1563,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-15 15:03:41"}]}},"erpSalesOrder":{"id":1563,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3936,"sales_contract_id":4086,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-11 15:53:55","stop_at":"2025-08-15 15:03:00.658357+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"11779","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5295\"],\"salesContractPaymentCollectionRemindDates\":{\"2025-09-30\":\"11779.00\"}}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":false,"created_at":"2025-08-11 11:02:32","updated_at":"2025-08-15 15:03:41","print_times":null,"erpSalesOrderVerifyRels":[{"id":1,"erp_sales_order_id":1563,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-11 15:53:55"}],"erpSalesOrderStopVerifyRels":[{"id":1,"erp_sales_order_id":1563,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-15 15:03:41"}],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3936,"key":3936,"name":"2025\u5e74\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","description":"","total_contact_point":"1000","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1203,"bargain_date":"2025-08-11","collected":"11779","profit_pct":"21.29","budget":"11779","erpSalesOrder":{"id":1563,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3936,"sales_contract_id":4086,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-11 15:53:55","stop_at":"2025-08-15 15:03:00.658357+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"11779","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5295\"],\"salesContractPaymentCollectionRemindDates\":{\"2025-09-30\":\"11779.00\"}}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":false,"created_at":"2025-08-11 11:02:32","updated_at":"2025-08-15 15:03:41","print_times":null},"projectProductTypes":[{"id":8105,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"11779","pct":"21.29","project_id":3936,"profit":"2507.74"}],"projectProductRels":[{"id":11609,"project_id":3936,"product_id":1717,"amount":"5235","number":1,"cost":"3246","description":"","supplier_id":null,"hardware_from":"2025-08-17","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-17","software_to":null,"maintenance_to":null,"total_amount":"5235","total_cost":"3246","erp_sales_order_product_id":1831,"supplier":null,"product":{"id":1717,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1455,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:18:36","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1455,"key":1455,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1831,"erp_sales_order_id":1563,"erp_store_id":null,"product_id":1717,"description":"","number":"1","outbound":"1","amount":"5235","total_amount":"5235","last_number":"1","last_amount":"5235","last_total_amount":"5235","cost":"3246","total_cost":"3246","supplier_id":null,"hardware_from":"2025-08-17","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-17","software_to":null,"maintenance_to":null}},{"id":11610,"project_id":3936,"product_id":1722,"amount":"6544","number":1,"cost":"4058","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-17","maintenance_to":null,"total_amount":"6544","total_cost":"4058","erp_sales_order_product_id":1830,"supplier":null,"product":{"id":1722,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1457,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:32","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1457,"key":1457,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1830,"erp_sales_order_id":1563,"erp_store_id":null,"product_id":1722,"description":"","number":"1","outbound":"1","amount":"6544","total_amount":"6544","last_number":"1","last_amount":"6544","last_total_amount":"6544","cost":"4058","total_cost":"4058","supplier_id":null,"hardware_from":null,"software_from":"2025-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-17","maintenance_to":null}}],"projectContactPoints":[{"id":1347,"project_id":3936,"contact_id":3509,"point":"1000.00","paid_point":null,"contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":13282,"project_id":3936},{"id":13281,"project_id":3936}],"reimbursementAmountSum":null,"profit":2507.7491,"contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":1000},"salesSupplierRels":[{"id":3876,"contract_id":4086,"supplier_id":236,"purchase_id":4093,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4093,"key":4093,"serial_no":"TSKJ20250815-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8663,"user_id":5295,"key":5295,"contract_id":4086,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9748,"user_id":5295,"key":5295,"contract_id":4086,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2542,"key":2542,"contract_id":4086,"name":"2025-09-30","value":"11779","overdue_days":null,"status":1,"remind_date":"2025-09-30","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"12008","key":"12008","contract_id":4086,"value":"11779","created_by":5388,"created_at":"2025-08-15 17:06:25","description":"\u6536\u6c47\u6b3e \u5317\u4eac\u4f18\u54c1\u6548\u9500","collected_date":"2025-08-15 00:00:00","amount":"11779","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":2118,"key":2118,"contract_id":4086,"value":"11779.00","attachment_id":null,"from_date":"2025-08-11","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":3110,"sales_invoice_id":2118,"amount":"5235","tax_rate":"6"},{"id":3111,"sales_invoice_id":2118,"amount":"6544","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":48324,"object_type":102,"object_id":2118,"attachment_id":27447,"attachment":{"id":27447,"key":27447,"name":"f5e3484b-0219-3cb2-b63f-2560a262e106","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f5e3484b-0219-3cb2-b63f-2560a262e106\/dzfp_25112000000168064532_\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8_20250811163159.pdf","orig_name":"dzfp_25112000000168064532_\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8_20250811163159.pdf"}}]}],"contractScans":[{"id":55300,"object_type":105,"object_id":4086,"attachment_id":27465,"attachment":{"id":27465,"key":27465,"name":"7482626a-7483-377b-9446-07103aae1479","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7482626a-7483-377b-9446-07103aae1479\/11779.pdf","orig_name":"11779.pdf"}}],"receiptScans":[{"id":48869,"object_type":106,"object_id":4086,"attachment_id":27797,"attachment":{"id":27797,"key":27797,"name":"d224a4de-860a-3dd3-9b20-c18758a75ef9","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/d224a4de-860a-3dd3-9b20-c18758a75ef9\/59251756100887_.pic_hd.jpg","orig_name":"59251756100887_.pic_hd.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":11779,"projectProductTotalAmount":11779,"projectProductAllAmount":true,"projectProductTotalCost":7304,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":"11779.00","un_invoiced":0,"collected":"11779","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\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":true,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":3829,"client_id":2032,"signed_at":"2025-03-18","amount":"3900","handler":5295,"description":"","created_by":5295,"created_at":"2025-03-17 18:28:37","updated_at":"2026-01-14 10:52:34","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3800,"valid_date":null,"expire_date":"2026-03-18","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-WZW-20250318001","payment_collection_remind_ahead":"","from_project":3800,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-17 18:28:37","is_verify":false,"is_draft":false,"erp_settle_amount":"3900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3900","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":117,"passed":2,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3829,"comment":9},"project":{"id":3800,"key":3800,"name":"25\u5e74\u9632\u706b\u5899\u7eed\u4fdd","erpSalesOrder":{"id":1460,"serial_no":"XSDD-20250317-00001","from_date":null,"wrote_date":"2025-03-18","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3800,"sales_contract_id":3829,"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-18 17:03:22","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-03-17 18:28:37","updated_at":"2025-03-18 17:03:22","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1460,"serial_no":"XSDD-20250317-00001","from_date":null,"wrote_date":"2025-03-18","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3800,"sales_contract_id":3829,"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-18 17:03:22","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-03-17 18:28:37","updated_at":"2025-03-18 17:03:22","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3800,"key":3800,"name":"25\u5e74\u9632\u706b\u5899\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1291,"bargain_date":"2025-03-18","collected":"3900","profit_pct":"32.26","budget":"3900","erpSalesOrder":{"id":1460,"serial_no":"XSDD-20250317-00001","from_date":null,"wrote_date":"2025-03-18","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3800,"sales_contract_id":3829,"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-18 17:03:22","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-03-17 18:28:37","updated_at":"2025-03-18 17:03:22","print_times":null},"projectProductTypes":[{"id":8245,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"3900","pct":"32.26","project_id":3800,"profit":"1258.14"}],"projectProductRels":[{"id":11846,"project_id":3800,"product_id":867,"amount":"1300","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1300","total_cost":null,"erp_sales_order_product_id":1547,"supplier":null,"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1547,"erp_sales_order_id":1460,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"0","amount":"1300","total_amount":"1300","last_number":"1","last_amount":"1300","last_total_amount":"1300","cost":"777.00","total_cost":"777","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11847,"project_id":3800,"product_id":868,"amount":"1400","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1400","total_cost":null,"erp_sales_order_product_id":1548,"supplier":null,"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1548,"erp_sales_order_id":1460,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"0","amount":"1400","total_amount":"1400","last_number":"1","last_amount":"1400","last_total_amount":"1400","cost":"713.00","total_cost":"713","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11848,"project_id":3800,"product_id":870,"amount":"1200","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":null,"erp_sales_order_product_id":1549,"supplier":null,"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1549,"erp_sales_order_id":1460,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":"1","last_amount":"1200","last_total_amount":"1200","cost":"874.00","total_cost":"874","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12717,"project_id":3800},{"id":12716,"project_id":3800},{"id":12718,"project_id":3800}],"reimbursementAmountSum":null,"profit":1258.14,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4038,"contract_id":3829,"supplier_id":686,"purchase_id":3964,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchase":{"id":3964,"key":3964,"serial_no":"TSKJ20250318-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8767,"user_id":5295,"key":5295,"contract_id":3829,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2361,"key":2361,"contract_id":3829,"name":"2025-03-19","value":"3900","overdue_days":null,"status":1,"remind_date":"2025-03-19","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"1253","key":"1253","contract_id":3829,"value":"3900","created_by":1013,"created_at":"2025-03-18 17:03:22","description":null,"collected_date":"2025-03-18 00:00:00","amount":"3900","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1989,"key":1989,"contract_id":3829,"value":"3900.00","attachment_id":null,"from_date":"2025-03-19","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":2793,"sales_invoice_id":1989,"amount":"3900","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33067,"object_type":102,"object_id":1989,"attachment_id":24701,"attachment":{"id":24701,"key":24701,"name":"d010a92c-bac4-325e-b484-38daa562c3e5","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/d010a92c-bac4-325e-b484-38daa562c3e5\/dzfp_25112000000055041361_\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20250319155305.pdf","orig_name":"dzfp_25112000000055041361_\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20250319155305.pdf"}}]}],"contractScans":[{"id":55411,"object_type":105,"object_id":3829,"attachment_id":24854,"attachment":{"id":24854,"key":24854,"name":"051e12d5-5aec-3753-a200-7ba77ca34d83","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/051e12d5-5aec-3753-a200-7ba77ca34d83\/\u7075\u72d0\u79d1\u6280.pdf","orig_name":"\u7075\u72d0\u79d1\u6280.pdf"}}],"receiptScans":[{"id":33225,"object_type":106,"object_id":3829,"attachment_id":24874,"attachment":{"id":24874,"key":24874,"name":"c0d7194b-2b2f-32f9-a0fd-d6eda19a05a5","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/c0d7194b-2b2f-32f9-a0fd-d6eda19a05a5\/2025_03_20_10_04_29.pdf","orig_name":"2025_03_20_10_04_29.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":3900,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":false,"projectProductTotalCount":3,"invoiced":"3900.00","un_invoiced":0,"collected":"3900","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,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":3451,"client_id":2032,"signed_at":"2024-08-06","amount":"21049","handler":5295,"description":"","created_by":5295,"created_at":"2024-08-02 17:07:14","updated_at":"2025-01-16 10:54:28","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3619,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024080601","payment_collection_remind_ahead":"1 day","from_project":3619,"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-02 17:07:14","is_verify":false,"is_draft":false,"erp_settle_amount":"21049","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"21049","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3451,"comment":5},"project":{"id":3619,"key":3619,"name":"2024\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd-K","erpSalesOrder":{"id":1313,"serial_no":"XSDD-20240802-00001","from_date":null,"wrote_date":"2024-08-06","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3619,"sales_contract_id":3451,"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-08-02 17:12:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-08-02 17:07:14","updated_at":"2024-08-02 17:12:55","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1313,"serial_no":"XSDD-20240802-00001","from_date":null,"wrote_date":"2024-08-06","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3619,"sales_contract_id":3451,"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-08-02 17:12:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-08-02 17:07:14","updated_at":"2024-08-02 17:12:55","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3619,"key":3619,"name":"2024\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd-K","description":"","total_contact_point":"2000","paid_contact_point":"2000","is_sales_order_ready":true,"project_product_version_id":519,"bargain_date":"2024-08-06","collected":"21049","profit_pct":"20.13","budget":"21049","erpSalesOrder":{"id":1313,"serial_no":"XSDD-20240802-00001","from_date":null,"wrote_date":"2024-08-06","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3619,"sales_contract_id":3451,"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-08-02 17:12:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-08-02 17:07:14","updated_at":"2024-08-02 17:12:55","print_times":null},"projectProductTypes":[{"id":5912,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"21049.00","pct":"20.13","project_id":3619,"profit":"4237.1637"}],"projectProductRels":[{"id":8620,"project_id":3619,"product_id":1717,"amount":"5235","number":1,"cost":"3246","description":"","supplier_id":236,"hardware_from":"2024-08-17","software_from":"2024-08-17","maintenance_from":null,"hardware_to":"2025-08-17","software_to":"2025-08-17","maintenance_to":null,"total_amount":"5235","total_cost":"3246","erp_sales_order_product_id":1128,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1717,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1455,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:18:36","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1455,"key":1455,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1128,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1717,"description":"","number":"1","outbound":"0","amount":"5235","total_amount":"5235","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3246","total_cost":"3246","supplier_id":236,"hardware_from":"2024-08-17","software_from":"2024-08-17","maintenance_from":null,"hardware_to":"2025-08-17","software_to":"2025-08-17","maintenance_to":null}},{"id":8621,"project_id":3619,"product_id":1722,"amount":"6544","number":1,"cost":"4057.6","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2025-08-17","maintenance_to":null,"total_amount":"6544","total_cost":"4057.6","erp_sales_order_product_id":1129,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1722,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1457,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:32","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1457,"key":1457,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1129,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1722,"description":"","number":"1","outbound":"0","amount":"6544","total_amount":"6544","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4057.6","total_cost":"4057.6","supplier_id":236,"hardware_from":null,"software_from":"2024-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2025-08-17","maintenance_to":null}},{"id":8622,"project_id":3619,"product_id":1719,"amount":"4120","number":1,"cost":"2554.8","description":"","supplier_id":236,"hardware_from":"2024-11-26","software_from":"2024-11-26","maintenance_from":null,"hardware_to":"2025-11-26","software_to":"2025-11-26","maintenance_to":null,"total_amount":"4120","total_cost":"2554.8","erp_sales_order_product_id":1130,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1719,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1456,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:20:04","updated_at":"2024-08-05 15:20:04","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1300","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1456,"key":1456,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1130,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1719,"description":"","number":"1","outbound":"0","amount":"4120","total_amount":"4120","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2554.8","total_cost":"2554.8","supplier_id":236,"hardware_from":"2024-11-26","software_from":"2024-11-26","maintenance_from":null,"hardware_to":"2025-11-26","software_to":"2025-11-26","maintenance_to":null}},{"id":8623,"project_id":3619,"product_id":1723,"amount":"5150","number":1,"cost":"3193.6","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-11-26","maintenance_from":null,"hardware_to":null,"software_to":"2025-11-26","maintenance_to":null,"total_amount":"5150","total_cost":"3193.6","erp_sales_order_product_id":1131,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1723,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1458,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:55","updated_at":"2024-08-05 15:28:55","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1300","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1458,"key":1458,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1131,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1723,"description":"","number":"1","outbound":"0","amount":"5150","total_amount":"5150","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3193.6","total_cost":"3193.6","supplier_id":236,"hardware_from":null,"software_from":"2024-11-26","maintenance_from":null,"hardware_to":null,"software_to":"2025-11-26","maintenance_to":null}}],"projectContactPoints":[{"id":848,"project_id":3619,"contact_id":3509,"point":"2000.00","paid_point":"2000","contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":150,"project_id":3619,"contact_id":3509,"point":"2000.00","day_at":"2025-01-15","description":"","created_at":"2025-01-16 10:54:28"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":9594,"project_id":3619},{"id":9596,"project_id":3619},{"id":9597,"project_id":3619},{"id":9595,"project_id":3619}],"reimbursementAmountSum":{"project_id":3619,"sum":"90.00"},"profit":4237.1637,"contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":2000,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":2353,"contract_id":3451,"supplier_id":236,"purchase_id":3454,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3454,"key":3454,"serial_no":"TSKJ20240802-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7732,"user_id":5295,"key":5295,"contract_id":3451,"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":7733,"user_id":1001,"key":1001,"contract_id":3451,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1890,"key":1890,"contract_id":3451,"name":"2024-08-15","value":"21049","overdue_days":null,"status":1,"remind_date":"2024-08-15","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"164","key":"164","contract_id":3451,"value":"21049","created_by":1013,"created_at":"2024-08-02 17:12:55","description":null,"collected_date":"2024-08-02 00:00:00","amount":"21049","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1798,"key":1798,"contract_id":3451,"value":"21049.00","attachment_id":null,"from_date":"2024-09-12","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":2977,"sales_invoice_id":1798,"amount":"9355","tax_rate":"6"},{"id":2978,"sales_invoice_id":1798,"amount":"11694","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":28689,"object_type":102,"object_id":1798,"attachment_id":21492,"attachment":{"id":21492,"key":21492,"name":"842d0f45-4b2d-3d70-95b1-186994e0a2b1","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/842d0f45-4b2d-3d70-95b1-186994e0a2b1\/dzfp_24112000000128874802_\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20240912170936.pdf","orig_name":"dzfp_24112000000128874802_\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20240912170936.pdf"}}]}],"contractScans":[{"id":31880,"object_type":105,"object_id":3451,"attachment_id":20799,"attachment":{"id":20799,"key":20799,"name":"4d0012ef-bc48-3d40-8b20-eadb3d801bd9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4d0012ef-bc48-3d40-8b20-eadb3d801bd9\/\u7075\u72d021049.pdf","orig_name":"\u7075\u72d021049.pdf"}}],"receiptScans":[{"id":28089,"object_type":106,"object_id":3451,"attachment_id":21105,"attachment":{"id":21105,"key":21105,"name":"bff240a8-6711-396b-8fb1-e2042cc06e0e","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/bff240a8-6711-396b-8fb1-e2042cc06e0e\/WechatIMG226.jpeg","orig_name":"WechatIMG226.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":21049,"projectProductTotalAmount":21049,"projectProductAllAmount":true,"projectProductTotalCost":13052,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":"21049.00","un_invoiced":0,"collected":"21049","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":3196,"client_id":2032,"signed_at":"2024-03-22","amount":"3900","handler":5295,"description":"","created_by":5015,"created_at":"2024-03-22 15:05:24","updated_at":"2025-01-21 09:44:51","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3479,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024032236","payment_collection_remind_ahead":"","from_project":3479,"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-05-21 10:19:34","is_verify":false,"is_draft":false,"erp_settle_amount":"3900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3900","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":3196,"comment":5},"project":{"id":3479,"key":3479,"name":"2024\u5e74\u9632\u706b\u5899\u8bbe\u5907\u7eed\u4fdd","erpSalesOrder":{"id":1209,"serial_no":"XSDD-20240322-00002","from_date":null,"wrote_date":"2024-03-22","handler":5015,"client_id":2032,"purchase_contract_id":null,"project_id":3479,"sales_contract_id":3196,"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-05-21 10:19:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-03-22 15:05:24","updated_at":"2024-05-21 10:19:34","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1209,"serial_no":"XSDD-20240322-00002","from_date":null,"wrote_date":"2024-03-22","handler":5015,"client_id":2032,"purchase_contract_id":null,"project_id":3479,"sales_contract_id":3196,"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-05-21 10:19:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-03-22 15:05:24","updated_at":"2024-05-21 10:19:34","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3479,"key":3479,"name":"2024\u5e74\u9632\u706b\u5899\u8bbe\u5907\u7eed\u4fdd","description":"","total_contact_point":"500","paid_contact_point":"500","is_sales_order_ready":true,"project_product_version_id":308,"bargain_date":"2024-03-22","collected":"3900","profit_pct":"32.26","budget":"3900","erpSalesOrder":{"id":1209,"serial_no":"XSDD-20240322-00002","from_date":null,"wrote_date":"2024-03-22","handler":5015,"client_id":2032,"purchase_contract_id":null,"project_id":3479,"sales_contract_id":3196,"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-05-21 10:19:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-03-22 15:05:24","updated_at":"2024-05-21 10:19:34","print_times":null},"projectProductTypes":[{"id":5931,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"3900","pct":"32.26","project_id":3479,"profit":"1258.14"}],"projectProductRels":[{"id":8716,"project_id":3479,"product_id":870,"amount":"1200","number":1,"cost":"874","description":"","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null,"total_amount":"1200","total_cost":"874","erp_sales_order_product_id":741,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":741,"erp_sales_order_id":1209,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"874","total_cost":"874","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null}},{"id":8717,"project_id":3479,"product_id":868,"amount":"1400","number":1,"cost":"713","description":"","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null,"total_amount":"1400","total_cost":"713","erp_sales_order_product_id":742,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":742,"erp_sales_order_id":1209,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"0","amount":"1400","total_amount":"1400","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"713","total_cost":"713","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null}},{"id":8718,"project_id":3479,"product_id":867,"amount":"1300","number":1,"cost":"777","description":"","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null,"total_amount":"1300","total_cost":"777","erp_sales_order_product_id":743,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":743,"erp_sales_order_id":1209,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"0","amount":"1300","total_amount":"1300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"777","total_cost":"777","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null}}],"projectContactPoints":[{"id":854,"project_id":3479,"contact_id":3509,"point":"500.00","paid_point":"500","contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":152,"project_id":3479,"contact_id":3509,"point":"500.00","day_at":"2024-05-22","description":"\u79ef\u5206\u8f6c\u4eac\u4e1c\u5361","created_at":"2025-01-21 09:44:51"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":8991,"project_id":3479},{"id":8993,"project_id":3479},{"id":8992,"project_id":3479}],"reimbursementAmountSum":null,"profit":1258.14,"contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":500,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":2517,"contract_id":3196,"supplier_id":686,"purchase_id":3269,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchase":{"id":3269,"key":3269,"serial_no":"TSKJ20240326-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7773,"user_id":5295,"key":5295,"contract_id":3196,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1670,"key":1670,"contract_id":3196,"name":"2024-03-31","value":"3900","overdue_days":null,"status":1,"remind_date":"2024-03-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"1649","key":"1649","contract_id":3196,"value":"3900","created_by":1013,"created_at":"2024-03-22 16:56:42","description":null,"collected_date":"2024-03-22 00:00:00","amount":"3900","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1621,"key":1621,"contract_id":3196,"value":"3900.00","attachment_id":null,"from_date":"2024-03-26","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2634,"sales_invoice_id":1621,"amount":"3900.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":24769,"object_type":102,"object_id":1621,"attachment_id":18319,"attachment":{"id":18319,"key":18319,"name":"a554bf56-aa1e-3427-99ce-da189eda318b","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/a554bf56-aa1e-3427-99ce-da189eda318b\/dzfp_24112000000014338002_\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20240326113019.pdf","orig_name":"dzfp_24112000000014338002_\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20240326113019.pdf"}}]}],"contractScans":[{"id":31987,"object_type":105,"object_id":3196,"attachment_id":18331,"attachment":{"id":18331,"key":18331,"name":"5d631b06-7aac-38fc-b3e2-5c59db60e835","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/5d631b06-7aac-38fc-b3e2-5c59db60e835\/2024_03_26_13_51_27.pdf","orig_name":"2024_03_26_13_51_27.pdf"}}],"receiptScans":[{"id":24819,"object_type":106,"object_id":3196,"attachment_id":18373,"attachment":{"id":18373,"key":18373,"name":"b9072831-ac9e-30d6-9353-efa1a66440a1","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b9072831-ac9e-30d6-9353-efa1a66440a1\/2024_03_28_09_21_00.pdf","orig_name":"2024_03_28_09_21_00.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":3900,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":2364,"projectProductAllCost":true,"projectProductTotalCount":3,"invoiced":"3900.00","un_invoiced":0,"collected":"3900","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":2762,"client_id":2032,"signed_at":"2023-07-25","amount":"28949","handler":5295,"description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","created_by":5295,"created_at":"2023-07-24 18:12:25","updated_at":"2024-01-24 10:29:08","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3082,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2023072533","payment_collection_remind_ahead":"","from_project":3082,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"28949","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"28949","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2762,"comment":3},"project":{"id":3082,"key":3082,"name":"\u534e\u4e09\u7f51\u7edc\u4ea7\u54c1\u5347\u7ea7-K","erpSalesOrder":{"id":1061,"serial_no":"XSDD-20230724-00002","from_date":null,"wrote_date":"2023-07-25","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3082,"sales_contract_id":2762,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-25 15:30:56","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"28949","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-24 18:12:25","updated_at":"2023-07-25 15:30:56","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1061,"serial_no":"XSDD-20230724-00002","from_date":null,"wrote_date":"2023-07-25","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3082,"sales_contract_id":2762,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-25 15:30:56","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"28949","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-24 18:12:25","updated_at":"2023-07-25 15:30:56","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3082,"key":3082,"name":"\u534e\u4e09\u7f51\u7edc\u4ea7\u54c1\u5347\u7ea7-K","description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","total_contact_point":"2000","paid_contact_point":"2000","is_sales_order_ready":true,"project_product_version_id":188,"bargain_date":"2023-07-25","collected":"28949","profit_pct":"15.06","budget":"28949","erpSalesOrder":{"id":1061,"serial_no":"XSDD-20230724-00002","from_date":null,"wrote_date":"2023-07-25","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3082,"sales_contract_id":2762,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-25 15:30:56","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"28949","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-24 18:12:25","updated_at":"2023-07-25 15:30:56","print_times":null},"projectProductTypes":[{"id":3843,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"28949.00","pct":"15.06","project_id":3082,"profit":"4359.7194"}],"projectProductRels":[{"id":2991,"project_id":3082,"product_id":734,"amount":"10524.5","number":2,"cost":"6526.08","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"21049.0","total_cost":"13052.16","erp_sales_order_product_id":270,"supplier":null,"product":{"id":734,"name":"\u6df1\u4fe1\u670d AC-1000 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1020,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-10-13 11:12:39","updated_at":"2025-11-21 15:46:18","pinyin_shortcut":"sxfAC1000xbfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-21 15:46:18.087915+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1020,"key":1020,"name":"\u6df1\u4fe1\u670d AC-1000 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":270,"erp_sales_order_id":1061,"erp_store_id":null,"product_id":734,"description":"","number":"2","outbound":"0","amount":"10524.5","total_amount":"21049.0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6526.08","total_cost":"13052.16","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2992,"project_id":3082,"product_id":742,"amount":"7900","number":1,"cost":"6700","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7900","total_cost":"6700","erp_sales_order_product_id":271,"supplier":null,"product":{"id":742,"name":"H3C S5560X-30C-EI","product_type":4,"product_component":19,"product_brand":20,"product_serie":1220,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-12-24 11:36:22","updated_at":"2024-02-21 17:27:33","pinyin_shortcut":"H3CS5560X30CEI","product_unit":1,"is_renew":false,"in_out_at":null,"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":1220,"key":1220,"name":"H3C S5560X-30C-EI L3\u4ee5\u592a\u7f51\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":271,"erp_sales_order_id":1061,"erp_store_id":null,"product_id":742,"description":"","number":"1","outbound":"0","amount":"7900","total_amount":"7900","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6700","total_cost":"6700","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":340,"project_id":3082,"contact_id":3509,"point":"2000.00","paid_point":"2000","contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":57,"project_id":3082,"contact_id":3509,"point":"2000.00","day_at":"2023-08-24","description":"","created_at":"2024-01-11 16:11:57"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3082,"sum":"141.25"},"profit":4359.7194,"contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":2000,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":489,"contract_id":2762,"supplier_id":236,"purchase_id":2778,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2778,"key":2778,"serial_no":"TSKJ-ZHF-20230725002"}},{"id":2378,"contract_id":2762,"supplier_id":681,"purchase_id":2775,"supplier":{"id":681,"key":681,"name":"\u5317\u4eac\u9e3f\u8499\u8c6b\u901a\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2775,"key":2775,"serial_no":"A202307-27"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4743,"user_id":5295,"key":5295,"contract_id":2762,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1292,"key":1292,"contract_id":2762,"name":"2023-08-31","value":"28949","overdue_days":null,"status":1,"remind_date":"2023-08-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"11042","key":"11042","contract_id":2762,"value":"28949","created_by":1014,"created_at":"2023-07-25 15:30:56","description":null,"collected_date":"2023-07-25 00:00:00","amount":"28949","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1447,"key":1447,"contract_id":2762,"value":"28949.00","attachment_id":null,"from_date":"2023-08-01","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2470,"sales_invoice_id":1447,"amount":"28949.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":19630,"object_type":102,"object_id":1447,"attachment_id":14184,"attachment":{"id":14184,"key":14184,"name":"6a9105a0-4d3e-370d-b1d9-c684dd48f9a5","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6a9105a0-4d3e-370d-b1d9-c684dd48f9a5\/2023_08_01_14_58_32.pdf","orig_name":"2023_08_01_14_58_32.pdf"}}]}],"contractScans":[{"id":23612,"object_type":105,"object_id":2762,"attachment_id":14166,"attachment":{"id":14166,"key":14166,"name":"43ca74f4-cea9-391a-8b20-0309134330ff","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/43ca74f4-cea9-391a-8b20-0309134330ff\/2023_07_31_15_22_08.pdf","orig_name":"2023_07_31_15_22_08.pdf"}}],"receiptScans":[{"id":19627,"object_type":106,"object_id":2762,"attachment_id":14181,"attachment":{"id":14181,"key":14181,"name":"8c041fa3-c908-3ea8-a31a-90178a1c5cd1","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8c041fa3-c908-3ea8-a31a-90178a1c5cd1\/69351690867223_.pic_hd.jpg","orig_name":"69351690867223_.pic_hd.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":28949,"projectProductTotalAmount":28949,"projectProductAllAmount":true,"projectProductTotalCost":19752.16,"projectProductAllCost":true,"projectProductTotalCount":3,"invoiced":"28949.00","un_invoiced":0,"collected":"28949","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":2578,"client_id":2032,"signed_at":"2023-02-27","amount":"3900","handler":5295,"description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","created_by":5295,"created_at":"2023-02-27 17:13:59","updated_at":"2024-01-24 10:30:20","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3127,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2023022755","payment_collection_remind_ahead":"","from_project":3127,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"3900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3900","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2578,"comment":3},"project":{"id":3127,"key":3127,"name":"\u9632\u706b\u5899\u7eed\u4fdd","erpSalesOrder":{"id":978,"serial_no":"XSDD-20230227-00001","from_date":null,"wrote_date":"2023-02-27","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3127,"sales_contract_id":2578,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-02-27 17:48:51","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-02-27 17:13:59","updated_at":"2023-02-27 17:48:51","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":978,"serial_no":"XSDD-20230227-00001","from_date":null,"wrote_date":"2023-02-27","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3127,"sales_contract_id":2578,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-02-27 17:48:51","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-02-27 17:13:59","updated_at":"2023-02-27 17:48:51","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3127,"key":3127,"name":"\u9632\u706b\u5899\u7eed\u4fdd","description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":189,"bargain_date":"2023-02-27","collected":"3900","profit_pct":"26.28","budget":"3900","erpSalesOrder":{"id":978,"serial_no":"XSDD-20230227-00001","from_date":null,"wrote_date":"2023-02-27","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3127,"sales_contract_id":2578,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-02-27 17:48:51","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-02-27 17:13:59","updated_at":"2023-02-27 17:48:51","print_times":null},"projectProductTypes":[{"id":3844,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"3900.00","pct":"26.28","project_id":3127,"profit":"1024.92"}],"projectProductRels":[{"id":2993,"project_id":3127,"product_id":865,"amount":"400","number":1,"cost":"150","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"400","total_cost":"150","erp_sales_order_product_id":29,"supplier":null,"product":{"id":865,"name":"H3C SecPath F1000-AK135","product_type":5,"product_component":26,"product_brand":20,"product_serie":332,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2022-10-24 10:30:36","updated_at":"2024-02-22 14:39:53","pinyin_shortcut":"H3CSecPathF1000AK135","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":332,"key":332,"name":"H3C SecPath F1000-AK135\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":29,"erp_sales_order_id":978,"erp_store_id":null,"product_id":865,"description":"","number":"1","outbound":"0","amount":"400","total_amount":"400","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"150","total_cost":"150","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2994,"project_id":3127,"product_id":870,"amount":"1200","number":1,"cost":"874","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":"874","erp_sales_order_product_id":30,"supplier":null,"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":30,"erp_sales_order_id":978,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"874","total_cost":"874","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2995,"project_id":3127,"product_id":868,"amount":"1100","number":1,"cost":"713","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1100","total_cost":"713","erp_sales_order_product_id":31,"supplier":null,"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":31,"erp_sales_order_id":978,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"0","amount":"1100","total_amount":"1100","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"713","total_cost":"713","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2996,"project_id":3127,"product_id":867,"amount":"1200","number":1,"cost":"777","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":"777","erp_sales_order_product_id":32,"supplier":null,"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":32,"erp_sales_order_id":978,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"777","total_cost":"777","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2997,"project_id":3127,"product_id":1213,"amount":"0","number":1,"cost":"796.09","description":"\u8d60\u9001","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"796.09","erp_sales_order_product_id":33,"supplier":null,"product":{"id":1213,"name":"\u6d0b\u6cb3\u84dd\u8272\u7ecf\u5178 \u68a6\u4e4b\u84ddM3\uff08 500ml \u00d7 2\uff09","product_type":23,"product_component":194,"product_brand":180,"product_serie":755,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-11 11:50:08","updated_at":"2024-01-11 11:50:08","pinyin_shortcut":"yhlsjdmzlM3500ml2","product_unit":11,"is_renew":false,"in_out_at":null,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":180,"key":180,"name":"\u6d0b\u6cb3"},"productSerie":{"id":755,"key":755,"name":"\u6d0b\u6cb3\u84dd\u8272\u7ecf\u5178M3 52\u5ea6\u6d53\u9999\u578b\u767d\u9152"},"productUnit":{"id":11,"key":11,"name":"\u74f6"}},"erpSalesOrderProduct":{"id":33,"erp_sales_order_id":978,"erp_store_id":null,"product_id":1213,"description":"\u8d60\u9001","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"796.09","total_cost":"796.09","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":1024.92,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":166,"contract_id":2578,"supplier_id":453,"purchase_id":2579,"supplier":{"id":453,"key":453,"name":"\u5317\u4eac\u7eff\u8272\u82f9\u679c\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2579,"key":2579,"serial_no":"TSKJ20230301-HYF-001"}}],"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4744,"user_id":5295,"key":5295,"contract_id":2578,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1163,"key":1163,"contract_id":2578,"name":"2023-02-27","value":"3900","overdue_days":0,"status":1,"remind_date":"2023-02-27","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"salesContractPayments":[{"id":"11445","key":"11445","contract_id":2578,"value":"3900","created_by":1014,"created_at":"2023-02-27 17:48:51","description":null,"collected_date":"2023-02-27 00:00:00","amount":"3900","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1353,"key":1353,"contract_id":2578,"value":"3900.00","attachment_id":null,"from_date":"2023-03-03","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1602,"sales_invoice_id":1353,"amount":"3900.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":17400,"object_type":102,"object_id":1353,"attachment_id":12162,"attachment":{"id":12162,"key":12162,"name":"1137f123-296f-39e1-b222-d10ed94b9f5a","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/1137f123-296f-39e1-b222-d10ed94b9f5a\/2023_03_03_14_04_18.pdf","orig_name":"2023_03_03_14_04_18.pdf"}}]}],"contractScans":[{"id":23613,"object_type":105,"object_id":2578,"attachment_id":12153,"attachment":{"id":12153,"key":12153,"name":"0e359fc0-6ed5-38f7-aa03-b7dd2c8bc695","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0e359fc0-6ed5-38f7-aa03-b7dd2c8bc695\/2023_03_01_17_05_40.pdf","orig_name":"2023_03_01_17_05_40.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":3900,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":3310.09,"projectProductAllCost":true,"projectProductTotalCount":5,"invoiced":"3900.00","un_invoiced":0,"collected":"3900","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":2413,"client_id":2032,"signed_at":"2022-09-14","amount":"84950","handler":5295,"description":"\u7fa4\u6656\u5b58\u50a8","created_by":5295,"created_at":"2022-09-15 11:14:23","updated_at":"2022-10-26 13:50:51","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":2972,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2022091426","payment_collection_remind_ahead":"","from_project":2972,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"84950","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"84950","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"project":{"id":2972,"key":2972,"name":"\u5b58\u50a8\u65b0\u8d2d","erpSalesOrder":{"id":909,"serial_no":"XSDD-20220915-00001","from_date":null,"wrote_date":"2022-09-14","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2972,"sales_contract_id":2413,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7fa4\u6656\u5b58\u50a8","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-09-16 09:59:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"84950","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-09-15 11:14:23","updated_at":"2022-09-16 09:59:24","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":909,"serial_no":"XSDD-20220915-00001","from_date":null,"wrote_date":"2022-09-14","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2972,"sales_contract_id":2413,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7fa4\u6656\u5b58\u50a8","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-09-16 09:59:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"84950","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-09-15 11:14:23","updated_at":"2022-09-16 09:59:24","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":2972,"key":2972,"name":"\u5b58\u50a8\u65b0\u8d2d","description":"\u7fa4\u6656\u5b58\u50a8","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-09-14","collected":"84950","profit_pct":"4.47","budget":"84950","erpSalesOrder":{"id":909,"serial_no":"XSDD-20220915-00001","from_date":null,"wrote_date":"2022-09-14","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2972,"sales_contract_id":2413,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7fa4\u6656\u5b58\u50a8","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-09-16 09:59:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"84950","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-09-15 11:14:23","updated_at":"2022-09-16 09:59:24","print_times":null},"projectProductTypes":[{"id":2636,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"84950.00","pct":"4.47","project_id":2972,"profit":"3797.265"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2972,"sum":"203.35"},"profit":3797.265,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":47,"contract_id":2413,"supplier_id":68,"purchase_id":2420,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2420,"key":2420,"serial_no":"BJ706720220916A01"}},{"id":823,"contract_id":2413,"supplier_id":477,"purchase_id":2430,"supplier":{"id":477,"key":477,"name":"\u601d\u521b\u667a\u5f97(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2430,"key":2430,"serial_no":"SCZD20220926TGSD"}},{"id":1354,"contract_id":2413,"supplier_id":477,"purchase_id":2416,"supplier":{"id":477,"key":477,"name":"\u601d\u521b\u667a\u5f97(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2416,"key":2416,"serial_no":"SCZD20220916TGSD"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3347,"user_id":5295,"key":5295,"contract_id":2413,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1039,"key":1039,"contract_id":2413,"name":"2022-11-30","value":"84950","overdue_days":null,"status":1,"remind_date":"2022-11-30","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"1885","key":"1885","contract_id":2413,"value":"84950","created_by":1014,"created_at":"2022-09-16 09:59:24","description":null,"collected_date":"2022-09-16 00:00:00","amount":"84950","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1272,"key":1272,"contract_id":2413,"value":"84950.00","attachment_id":null,"from_date":"2022-09-26","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1404,"sales_invoice_id":1272,"amount":"84950.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":16181,"object_type":102,"object_id":1272,"attachment_id":11101,"attachment":{"id":11101,"key":11101,"name":"0c40c0f0-a42e-3056-bbfc-83373964110c","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0c40c0f0-a42e-3056-bbfc-83373964110c\/2022_09_26_11_47_56.pdf","orig_name":"2022_09_26_11_47_56.pdf"}}]}],"contractScans":[{"id":16234,"object_type":105,"object_id":2413,"attachment_id":11102,"attachment":{"id":11102,"key":11102,"name":"7e4c62f6-ed53-300e-9068-5a6f118bf082","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7e4c62f6-ed53-300e-9068-5a6f118bf082\/\u7075\u72d0\u5408\u540c.pdf","orig_name":"\u7075\u72d0\u5408\u540c.pdf"}}],"receiptScans":[{"id":16399,"object_type":106,"object_id":2413,"attachment_id":11294,"attachment":{"id":11294,"key":11294,"name":"6a6c6a26-c1d3-36e6-9eef-47ba166b71c0","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6a6c6a26-c1d3-36e6-9eef-47ba166b71c0\/WechatIMG777.jpeg","orig_name":"WechatIMG777.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":84950,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"84950.00","un_invoiced":0,"collected":"84950","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":2376,"client_id":2032,"signed_at":"2022-08-16","amount":"21049","handler":5295,"description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","created_by":5295,"created_at":"2022-08-17 09:37:15","updated_at":"2022-09-05 13:56:33","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":2947,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2022081622","payment_collection_remind_ahead":"","from_project":2947,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"21049","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"21049","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"project":{"id":2947,"key":2947,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd2022","erpSalesOrder":{"id":893,"serial_no":"XSDD-20220817-00001","from_date":null,"wrote_date":"2022-08-16","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2947,"sales_contract_id":2376,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-08-25 16:44:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-17 09:37:15","updated_at":"2022-08-25 16:44:59","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":893,"serial_no":"XSDD-20220817-00001","from_date":null,"wrote_date":"2022-08-16","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2947,"sales_contract_id":2376,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-08-25 16:44:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-17 09:37:15","updated_at":"2022-08-25 16:44:59","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":2947,"key":2947,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd2022","description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-08-16","collected":"21049","profit_pct":"20.13","budget":"21049","erpSalesOrder":{"id":893,"serial_no":"XSDD-20220817-00001","from_date":null,"wrote_date":"2022-08-16","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2947,"sales_contract_id":2376,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-08-25 16:44:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-17 09:37:15","updated_at":"2022-08-25 16:44:59","print_times":null},"projectProductTypes":[{"id":3804,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"21049","pct":"20.13","project_id":2947,"profit":"4237.1637"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2947,"sum":"16.00"},"profit":4237.1637,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":208,"contract_id":2376,"supplier_id":236,"purchase_id":2389,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2389,"key":2389,"serial_no":"TSKJ20220817"}}],"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3285,"user_id":5295,"key":5295,"contract_id":2376,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1023,"key":1023,"contract_id":2376,"name":"2022-08-31","value":"21049","overdue_days":null,"status":1,"remind_date":"2022-08-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"11671","key":"11671","contract_id":2376,"value":"21049","created_by":1014,"created_at":"2022-08-25 16:44:59","description":null,"collected_date":"2022-08-17 00:00:00","amount":"21049","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1252,"key":1252,"contract_id":2376,"value":"21049.00","attachment_id":null,"from_date":"2022-08-17","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1339,"sales_invoice_id":1252,"amount":"21049.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":15859,"object_type":102,"object_id":1252,"attachment_id":10817,"attachment":{"id":10817,"key":10817,"name":"26743a60-c960-333c-8bc5-0f6fc278a9ac","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/26743a60-c960-333c-8bc5-0f6fc278a9ac\/2022_08_17_10_01_28.pdf","orig_name":"2022_08_17_10_01_28.pdf"}}]}],"contractScans":[{"id":15958,"object_type":105,"object_id":2376,"attachment_id":10851,"attachment":{"id":10851,"key":10851,"name":"95ca473a-742a-330f-863c-18a78be2c2ea","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/95ca473a-742a-330f-863c-18a78be2c2ea\/2022_08_22_17_22_54.pdf","orig_name":"2022_08_22_17_22_54.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":21049,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"21049.00","un_invoiced":0,"collected":"21049","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":2230,"client_id":2032,"signed_at":"2022-03-23","amount":"18120","handler":5295,"description":"\u5b89\u5168","created_by":5295,"created_at":"2022-03-24 12:27:27","updated_at":"2022-04-11 09:39:10","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":2797,"valid_date":null,"expire_date":"2023-03-22","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-WZW-2022032301","payment_collection_remind_ahead":"","from_project":2797,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"18120","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"18120","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":1209,"passed":2,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2230,"comment":1},"project":{"id":2797,"key":2797,"name":"\u5b89\u5168\u52a0\u56fa2","erpSalesOrder":{"id":828,"serial_no":"XSDD-20220325-00001","from_date":null,"wrote_date":"2022-03-23","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2797,"sales_contract_id":2230,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u5b89\u5168","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-03-25 11:37:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"18120","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-03-24 12:27:27","updated_at":"2022-03-25 11:37:01","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":828,"serial_no":"XSDD-20220325-00001","from_date":null,"wrote_date":"2022-03-23","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2797,"sales_contract_id":2230,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u5b89\u5168","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-03-25 11:37:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"18120","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-03-24 12:27:27","updated_at":"2022-03-25 11:37:01","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":2797,"key":2797,"name":"\u5b89\u5168\u52a0\u56fa2","description":"\u5b89\u5168","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-03-23","collected":"18120","profit_pct":"11.06","budget":"18120","erpSalesOrder":{"id":828,"serial_no":"XSDD-20220325-00001","from_date":null,"wrote_date":"2022-03-23","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2797,"sales_contract_id":2230,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u5b89\u5168","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-03-25 11:37:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"18120","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-03-24 12:27:27","updated_at":"2022-03-25 11:37:01","print_times":null},"projectProductTypes":[{"id":4585,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"18120","pct":"11.06","project_id":2797,"profit":"2004.072"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2797,"sum":"118.61"},"profit":2004.072,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":897,"contract_id":2230,"supplier_id":453,"purchase_id":2233,"supplier":{"id":453,"key":453,"name":"\u5317\u4eac\u7eff\u8272\u82f9\u679c\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2233,"key":2233,"serial_no":"TSKJ20220324-HYF-002"}}],"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":7078,"user_id":1011,"key":1011,"contract_id":2230,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7079,"user_id":5295,"key":5295,"contract_id":2230,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"1755","key":"1755","contract_id":2230,"value":"18120","created_by":1014,"created_at":"2022-03-25 11:37:01","description":null,"collected_date":"2022-03-25 00:00:00","amount":"18120","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1185,"key":1185,"contract_id":2230,"value":"18120.00","attachment_id":null,"from_date":"2022-03-25","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1257,"sales_invoice_id":1185,"amount":"18120.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":14813,"object_type":102,"object_id":1185,"attachment_id":9882,"attachment":{"id":9882,"key":9882,"name":"4c7e9110-0a51-32a6-a511-51df2a6e2a09","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4c7e9110-0a51-32a6-a511-51df2a6e2a09\/2022_03_25_10_50_14.pdf","orig_name":"2022_03_25_10_50_14.pdf"}}]}],"contractScans":[{"id":14860,"object_type":105,"object_id":2230,"attachment_id":9920,"attachment":{"id":9920,"key":9920,"name":"c25c5560-78ec-3b7a-b8e2-83aa2b4ad57a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/c25c5560-78ec-3b7a-b8e2-83aa2b4ad57a\/2022_04_11_09_32_08.pdf","orig_name":"2022_04_11_09_32_08.pdf"}}],"receiptScans":[{"id":14823,"object_type":106,"object_id":2230,"attachment_id":9894,"attachment":{"id":9894,"key":9894,"name":"66331b49-e345-3da4-ada6-09c1d9bb109a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/66331b49-e345-3da4-ada6-09c1d9bb109a\/2022_03_28_17_09_45.pdf","orig_name":"2022_03_28_17_09_45.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"18120.00","un_invoiced":0,"collected":"18120","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,"can_view_product_cost":true,"erp_all_un_settle_amount":0}],"pagenation":{"totalcount":12,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 12:00:06', 330902016) RETURNING "id" |
| 12:00:06.230 | 6.1 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 (4130, 3936, 3800, 3619, 3479, 3082, 3127, 2972, 2947, 2797) |
| 12:00:06.223 | 5.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1688, 1563, 1460, 1313, 1209, 1061, 978, 909, 893, 828) ORDER BY "id" |
| 12:00:06.363 | 5.1 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4430 |
| 12:00:06.257 | 4.8 ms | yii\db\Command::query | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130)) |
| 12:00:06.278 | 4.1 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.wrote_date 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))) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) ORDER BY "id" DESC |
| 12:00:06.262 | 3.5 ms | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130)) GROUP BY "project_id" |
| 12:00:06.289 | 3.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1185, 1252, 1272, 1353, 1447, 1621, 1798, 1989, 2118, 2315)) |
| 12:00:06.294 | 3.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230)) |
| 12:00:06.286 | 3.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1185, 1252, 1272, 1353, 1447, 1621, 1798, 1989, 2118, 2315)) |
| 12:00:06.298 | 3.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230)) |
| 12:00:06.058 | 2.8 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 12:00:06.203 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130)) |
| 12:00:06.216 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) ORDER BY "id" DESC |
| 12:00:06.208 | 2.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (893, 909, 1061, 1209, 1460, 1563, 1688, 828, 978, 1313) ORDER BY "id" |
| 12:00:06.093 | 1.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2032') AND ("deleted"=FALSE) |
| 12:00:06.206 | 1.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (893, 909, 1061, 1209, 1460, 1563, 1688, 828, 978, 1313) ORDER BY "id" |
| 12:00:06.201 | 1.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4130, 3936, 3800, 3619, 3479, 3082, 3127, 2972, 2947, 2797) |
| 12:00:06.242 | 1.4 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 (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130) |
| 12:00:06.136 | 1.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5015) |
| 12:00:06.244 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130) ORDER BY "id" |
| 12:00:06.241 | 1.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130)) |
| 12:00:06.284 | 1.0 ms | yii\db\Command::query | SELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (1185, 1252, 1272, 1353, 1447, 1621, 1798, 1989, 2118, 2315) ORDER BY "id" |
| 12:00:06.247 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (734, 742, 865, 870, 868, 867, 1213, 1717, 1722, 1719, 1723) |
| 12:00:06.252 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (270, 271, 29, 30, 31, 32, 33, 1128, 1129, 1130, 1131, 741, 742, 743, 1831, 1830, 1547, 1548, 1549, 2204, 2205, 2206) |
| 12:00:06.133 | 0.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 12:00:06.283 | 0.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) ORDER BY "id" |
| 12:00:06.132 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2032 |
| 12:00:06.272 | 0.8 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) |
| 12:00:06.266 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) |
| 12:00:06.277 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) ORDER BY "remind_date" |
| 12:00:06.251 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 1, 11) |
| 12:00:06.293 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9882, 10817, 11101, 12162, 14184, 18319, 21492, 24701, 27447, 32165) |
| 12:00:06.138 | 0.7 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 (5015, 5295)) |
| 12:00:06.135 | 0.7 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"=5295) |
| 12:00:06.275 | 0.7 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 (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) |
| 12:00:06.089 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 12:00:06.246 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (236, 146) |
| 12:00:06.268 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2420, 2579, 2389, 2778, 2430, 2233, 2416, 2775, 3269, 3454, 4093, 3964, 4435) |
| 12:00:06.251 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1457, 1456, 1458, 1020, 332, 1220, 755, 1455, 1222, 551, 1223) |
| 12:00:06.139 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 1) |
| 12:00:06.256 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((3509, 3082), (3509, 3936), (3509, 3619), (3509, 3479)) |
| 12:00:06.255 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=3509 |
| 12:00:06.271 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230)) ORDER BY "remind_date" |
| 12:00:06.373 | 0.6 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4086 |
| 12:00:06.254 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3127, 3479, 3082, 2797, 3800, 3619, 2947, 2972, 3936, 4130) |
| 12:00:06.248 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (22, 5, 4, 23) |
| 12:00:06.220 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1688, 1563, 1460, 1313, 1209, 1061, 978, 909, 893, 828) ORDER BY "id" |
| 12:00:06.249 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (208, 189, 200, 26, 19, 194, 35) |
| 12:00:06.297 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9920, 10851, 11102, 14166, 12153, 20799, 18331, 27465, 24854, 32309) |
| 12:00:06.301 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9894, 11294, 14181, 18373, 21105, 24874, 27797, 32492) |
| 12:00:06.274 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) |
| 12:00:06.250 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 20, 180) |
| 12:00:06.269 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 12:00:06.374 | 0.4 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3829 |
| 12:00:06.375 | 0.4 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3451 |
| 12:00:06.219 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1688, 1563, 1460, 1313, 1209, 1061, 978, 909, 893, 828) ORDER BY "id" |
| 12:00:06.375 | 0.4 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3196 |
| 12:00:06.270 | 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"=5295) |
| 12:00:06.282 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013, 5388) |
| 12:00:06.256 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2032 |
| 12:00:06.267 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (68, 453, 236, 477, 681, 686) |
| 12:00:06.274 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1011)) |
| 12:00:06.271 | 0.3 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 (4430, 4086, 3829, 3451, 3196, 2762, 2578, 2413, 2376, 2230) |
| 12:00:06.379 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2230 |
| 12:00:06.276 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1001) |
| 12:00:06.377 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2578 |
| 12:00:06.273 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5295) |
| 12:00:06.378 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2376 |
| 12:00:06.269 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 12:00:06.377 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2413 |
| 12:00:06.276 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1001)) |
| 12:00:06.376 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2762 |