68c9073faaf86: POST https://beta.jinchangxiao.com/vue/erp-cash-cost-ticket/search-sales-contract at 2025-09-16 02:44:15 pm by 114.244.128.96
Database Queries
总计59条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:44:15.703 | 2.4 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:44:15.706 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:44:15.710 | 12.0 ms | SELECT | 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"='1301') AND (erp_un_settle_amount > 0) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 14:44:15.723 | 9.7 ms | SELECT | 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"='1301') AND (erp_un_settle_amount > 0) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC |
| 14:44:15.740 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1301 |
| 14:44:15.740 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 14:44:15.741 | 0.6 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 14:44:15.741 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 14:44:15.742 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 14:44:15.742 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 14:44:15.743 | 21.1 ms | SELECT | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4130, 3886)) GROUP BY "object_id" |
| 14:44:15.764 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3945, 3822) |
| 14:44:15.765 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3822, 3945)) |
| 14:44:15.766 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1574, 1486) ORDER BY "id" |
| 14:44:15.766 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1574, 1486) ORDER BY "id" |
| 14:44:15.767 | 0.4 ms | SELECT | 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 (3945, 3822) |
| 14:44:15.771 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3822, 3945)) |
| 14:44:15.771 | 2.7 ms | SELECT | 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 (3822, 3945) |
| 14:44:15.774 | 3.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3822, 3945) |
| 14:44:15.778 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=236 |
| 14:44:15.779 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2124, 2123, 2121, 2122, 2119, 2118, 2106, 2105, 2099, 941) |
| 14:44:15.780 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 4, 5, 19) |
| 14:44:15.780 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (188, 23, 43, 26, 157, 151) |
| 14:44:15.781 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 133) |
| 14:44:15.781 | 1.6 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (743, 172, 742, 1698, 1033, 1640, 1699, 592) |
| 14:44:15.783 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 3, 1, 7) |
| 14:44:15.783 | 3.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (1864, 1865, 1866, 1867, 1868, 1869, 1870, 1871, 1872, 1602) |
| 14:44:15.787 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3822, 3945) |
| 14:44:15.789 | 1.0 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (5969, 5984) |
| 14:44:15.790 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1301 |
| 14:44:15.791 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((5969, 3822), (5984, 3822), (5984, 3945)) |
| 14:44:15.792 | 7.6 ms | SELECT | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3822, 3945)) |
| 14:44:15.800 | 1.5 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3822, 3945)) GROUP BY "project_id" |
| 14:44:15.802 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4130, 3886) |
| 14:44:15.802 | 2.0 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 14:44:15.804 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 14:44:15.805 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 14:44:15.805 | 1.5 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (4130, 3886)) ORDER BY "remind_date" |
| 14:44:15.807 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (4130, 3886) |
| 14:44:15.807 | 3.2 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (4130, 3886) |
| 14:44:15.810 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4130, 3886) |
| 14:44:15.812 | 2.8 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4130, 3886) |
| 14:44:15.815 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 14:44:15.815 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 14:44:15.815 | 2.2 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4130, 3886) ORDER BY "remind_date" |
| 14:44:15.818 | 2.7 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (4130, 3886) ORDER BY "id" DESC |
| 14:44:15.821 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 |
| 14:44:15.821 | 3.1 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4130, 3886) ORDER BY "id" |
| 14:44:15.824 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id"=2035) |
| 14:44:15.826 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id"=2035) |
| 14:44:15.828 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=25441 |
| 14:44:15.828 | 2.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4130, 3886)) |
| 14:44:15.831 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (25574, 27905) |
| 14:44:15.831 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4130, 3886)) |
| 14:44:15.833 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4130, 3886)) |
| 14:44:15.835 | 17.5 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (4130, 3886)) GROUP BY "object_id" |
| 14:44:15.855 | 3.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-16') |
| 14:44:15.859 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=167, "last_visit_at"='now()' WHERE "id"=56579 |
| 14:44:15.861 | 2.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-cash-cost-ticket/search-sales-contract', '{"id":"1301","web_access_token":"Y88xetVtOugxFkYQoFcH-2TFC5ckFtc8"}', '{"code":2000,"result":{"list":[{"id":4130,"client_id":1301,"signed_at":"2025-08-26","amount":"99786","handler":5295,"description":"","created_by":5295,"created_at":"2025-08-27 15:33:33","updated_at":"2025-08-29 10:38:54","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3945,"valid_date":"","expire_date":"2026-08-31","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-20250826006","payment_collection_remind_ahead":"","from_project":3945,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2025-09-01 10:01:29","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"99786","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":349,"passed":2,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":"","receiptScan":"","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":4130,"comment":1},"project":{"id":3945,"key":3945,"name":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","erpSalesOrder":{"id":1574,"serial_no":"XSDD-20250827-00001","from_date":"","wrote_date":"2025-08-27","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":3945,"sales_contract_id":4130,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-27 15:33:33","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"9","amount":"99786","created_by":5295,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"29935.8\",\"remind_date\":\"2025-09-15\",\"pct\":0.3},{\"amount\":\"69850.2\",\"remind_date\":\"2025-10-31\",\"pct\":0.7}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-27 09:38:28","updated_at":"2025-08-27 15:33:33","erpSalesOrderVerifyRels":[{"id":12,"erp_sales_order_id":1574,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-27 15:33:33"}],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3945,"key":3945,"name":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","description":"","total_contact_point":"4000","paid_contact_point":"","is_sales_order_ready":false,"project_product_version_id":1006,"bargain_date":"2025-08-26","collected":"0","profit_pct":"35.11","budget":"99786","erpSalesOrder":{"id":1574,"serial_no":"XSDD-20250827-00001","from_date":"","wrote_date":"2025-08-27","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":3945,"sales_contract_id":4130,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-27 15:33:33","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"9","amount":"99786","created_by":5295,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"29935.8\",\"remind_date\":\"2025-09-15\",\"pct\":0.3},{\"amount\":\"69850.2\",\"remind_date\":\"2025-10-31\",\"pct\":0.7}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-27 09:38:28","updated_at":"2025-08-27 15:33:33"},"projectProductTypes":[{"id":6992,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"3136","pct":"22.99","project_id":3945,"profit":"721"},{"id":6993,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"35275","pct":"35.47","project_id":3945,"profit":"12512.52"},{"id":6994,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"61375","pct":"35.52","project_id":3945,"profit":"21805.58"}],"projectProductRels":[{"id":10699,"project_id":3945,"product_id":2124,"amount":"0","number":1,"cost":"0","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"0","total_cost":"0","erp_sales_order_product_id":1864,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2124,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e9040\/60W","product_type":5,"product_component":157,"product_brand":12,"product_serie":1699,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 10:01:17","updated_at":"2025-08-29 10:01:17","pinyin_shortcut":"dzryjldy4060W","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1699,"key":1699,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e9040\/60W"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1864,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2124,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10700,"project_id":3945,"product_id":2123,"amount":"5900.00","number":1,"cost":"3923.74","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"5900","total_cost":"3923.74","erp_sales_order_product_id":1865,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2123,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":1640,"product_misc":"","product_qa":"","pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u60a8\u5c06\u83b7\u5f97\u4ee5\u4e0b\u80fd\u529b\uff1a\n\u3010\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u89c4\u5219\u5e93\uff0c\u5931\u9677\u5916\u8054\u5b9e\u65f6\u68c0\u6d4b\u4e0e\u62e6\u622a\u3011\u901a\u8fc7\u672c\u5730&\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u548c\u5168\u56fd30+\u8fd0\u8425\u5546POP\u8282\u70b9 \uff0c\u5b9e\u65f6\u963b\u65ad\u4e3b\u673a\/PC\u5931\u9677\u5916\u8054\u3001\u6316\u77ff\u3001URL\u9493\u9c7c\u7b49\u98ce\u9669\uff1b\n\u3010\u65b0\u5a01\u80c1\/\u672a\u77e5\u5a01\u80c15min\u5185\u540c\u6b65\u3011\u83b7\u53d6\u4e91\u7aefAI\u667a\u80fd\u5f15\u64ce\u68c0\u6d4b\u80fd\u529b\uff0c\u672c\u5730\u9632\u706b\u5899\u89c4\u5219\u5e93\u6bcf5\u5206\u949f\u66f4\u65b0\u4e00\u6b21\uff0c\u540c\u6b65\u6700\u65b0\u7684\u672a\u77e5\u5a01\u80c1\u60c5\u62a5\u81f3\u5ba2\u6237\u672c\u5730\uff0c\u5b9e\u65f6\u83b7\u53d6\u672a\u77e5\u5a01\u80c1\u7684\u9632\u5fa1\u80fd\u529b\uff08\u5982\u6f0f\u6d1e\\\u6076\u610fIP\\\u9493\u9c7cURL\u7b49\uff09\u907f\u514d\u6210\u4e3a\u65b0\u578b\u5a01\u80c1\u7684\u9996\u6279\u53d7\u5bb3\u8005\uff1b\n\u3010\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u3011\u63d0\u4f9b\u672c\u5730\u8bbe\u5907\u7f51\u7edc\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u670d\u52a1\uff0c\u672a\u77e5\u6587\u4ef6MD5\u503c\u5b9e\u65f6\u4e91\u67e5\u529f\u80fd\u3002","created_by":1013,"created_at":"2025-08-29 09:58:18","updated_at":"2025-08-29 09:58:18","pinyin_shortcut":"sxfywxqbwgrjV80syyAF1000FH2150B","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1640,"key":1640,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1865,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2123,"description":"","number":"1","outbound":"0","amount":"5900.00","total_amount":"5900","last_number":"","last_amount":"","last_total_amount":"","cost":"3923.74","total_cost":"3923.74","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10701,"project_id":3945,"product_id":2121,"amount":"3055.00","number":1,"cost":"1961.87","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"3055","total_cost":"1961.87","erp_sales_order_product_id":1866,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2121,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":"","product_qa":"","pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u5305\u62ecWEB\u5e94\u7528\u9632\u62a4\u8bc6\u522b\u5e93\u3001IPS\u7279\u5f81\u5e93\u3001\u50f5\u5c38\u7f51\u7edc\u9632\u62a4\u5e93\u3001\u5b9e\u65f6\u6f0f\u6d1e\u5206\u6790\u8bc6\u522b\u5e93\u548cURL&\u5e94\u7528\u8bc6\u522b\u5e93\u5b9a\u671f\u66f4\u65b0\uff0c\u4fdd\u6301\u8bbe\u5907\u5177\u5907\u68c0\u6d4b\u9632\u5fa1\u6700\u65b0\u5a01\u80c1\u7684\u80fd\u529b\u3002","created_by":1013,"created_at":"2025-08-29 09:55:04","updated_at":"2025-08-29 09:55:04","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH2150B","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1866,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2121,"description":"","number":"1","outbound":"0","amount":"3055.00","total_amount":"3055","last_number":"","last_amount":"","last_total_amount":"","cost":"1961.87","total_cost":"1961.87","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10702,"project_id":3945,"product_id":2122,"amount":"26320.00","number":1,"cost":"16876.87","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"26320","total_cost":"16876.87","erp_sales_order_product_id":1867,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2122,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":742,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 09:56:09","updated_at":"2025-08-29 09:56:09","pinyin_shortcut":"sxffhqrjV80syyAF1000FH2150B","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":742,"key":742,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1867,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2122,"description":"","number":"1","outbound":"0","amount":"26320.00","total_amount":"26320","last_number":"","last_amount":"","last_total_amount":"","cost":"16876.87","total_cost":"16876.87","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10703,"project_id":3945,"product_id":2119,"amount":"3136.00","number":1,"cost":"2415.00","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"3136","total_cost":"2415","erp_sales_order_product_id":1868,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2119,"name":"AF-1000-FH2150B","product_type":5,"product_component":26,"product_brand":12,"product_serie":1033,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff1a20G\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a10G\uff0c\u9632\u75c5\u6bd2\u541e\u5410\u91cf\uff1a1.5G\uff0cIPS\u541e\u5410\u91cf\uff1a1.5G\uff0c\u5168\u5a01\u80c1\u541e\u5410\u91cf\uff08\u4e0d\u542bWAF\uff09\uff1a1G\uff0c\u5e76\u53d1\u8fde\u63a5\u6570\uff1a300\u4e07\uff0cHTTP\u65b0\u5efa\u8fde\u63a5\u6570\uff1a9\u4e07\uff0cSSL VPN\u63a8\u8350\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a30\uff0cSSL VPN\u6700\u5927\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a80\uff0cSSL VPN\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a250M\uff0cIPSec VPN \u6700\u5927\u63a5\u5165\u6570\uff1a1000\uff0cIPSec VPN\u541e\u5410\u91cf\uff1a700M\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a8\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u4e0b\u4e00\u4ee3\u9632\u706b\u5899\u4ee5\u4fdd\u969c\u7528\u6237\u6838\u5fc3\u8d44\u4ea7\u4e3a\u76ee\u6807\uff0c\u63d0\u4f9bL2-L7\u5c42\u5404\u7c7b\u5a01\u80c1\u7684\u68c0\u6d4b\u548c\u9632\u62a4\uff0c\u662f\u4e00\u6b3e\u80fd\u591f\u6709\u6548\u5e94\u5bf9\u4f20\u7edf\u7f51\u7edc\u653b\u51fb\u548c\u672a\u77e5\u5a01\u80c1\u653b\u51fb\u7684\u7f51\u7edc\u5b89\u5168\u4ea7\u54c1\u3002","created_by":1013,"created_at":"2025-08-29 09:49:49","updated_at":"2025-08-29 09:49:49","pinyin_shortcut":"AF1000FH2150B","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1033,"key":1033,"name":"\u6df1\u4fe1\u670d AF-1000\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1868,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2119,"description":"","number":"1","outbound":"0","amount":"3136.00","total_amount":"3136","last_number":"","last_amount":"","last_total_amount":"","cost":"2415.00","total_cost":"2415","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10704,"project_id":3945,"product_id":2118,"amount":"0","number":1,"cost":"0","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"0","total_cost":"0","erp_sales_order_product_id":1869,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2118,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e90150W","product_type":4,"product_component":43,"product_brand":12,"product_serie":1698,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 09:46:49","updated_at":"2025-08-29 09:46:49","pinyin_shortcut":"dzryjldy150W","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1698,"key":1698,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1869,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2118,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10705,"project_id":3945,"product_id":2106,"amount":"5730.00","number":1,"cost":"3643.77","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"5730","total_cost":"3643.77","erp_sales_order_product_id":1870,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2106,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:35:15","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B1500","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1870,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2106,"description":"","number":"1","outbound":"0","amount":"5730.00","total_amount":"5730","last_number":"","last_amount":"","last_total_amount":"","cost":"3643.77","total_cost":"3643.77","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10706,"project_id":3945,"product_id":2105,"amount":"49620.00","number":1,"cost":"30911.65","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"49620","total_cost":"30911.65","erp_sales_order_product_id":1871,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2105,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:34:25","updated_at":"2025-09-15 16:26:30","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B1500","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1871,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2105,"description":"","number":"1","outbound":"0","amount":"49620.00","total_amount":"49620","last_number":"","last_amount":"","last_total_amount":"","cost":"30911.65","total_cost":"30911.65","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":10707,"project_id":3945,"product_id":2099,"amount":"6025.00","number":1,"cost":"5014.00","description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"6025","total_cost":"5014","erp_sales_order_product_id":1872,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2099,"name":"AC-1000-B1500","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff08\u5927\u5305\uff09\uff1a5.8Gb\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a750Mb\uff0c\u5e26\u5bbd\u6027\u80fd\uff1a500Mb\uff0cIPSEC VPN\u52a0\u5bc6\u6027\u80fd\uff08\u6700\u9ad8\u6027\u80fd\uff09\uff1a120Mb\uff0c\u652f\u6301\u7528\u6237\u6570\uff1a4000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a2000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\u7684\u6269\u5bb9\u4e0a\u9650\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a4000\uff0c\u9632\u6cc4\u5bc6\u7ec8\u7aef\u6570\u4e0a\u9650(\u9700\u5355\u72ec\u6536\u8d39)\uff1a8000\uff0c\u5305\u8f6c\u53d1\u7387\uff1a90Kpps\uff0c\u6bcf\u79d2\u65b0\u5efa\u8fde\u63a5\u6570\uff1a10000\uff0c\u6700\u5927\u5e76\u53d1\u8fde\u63a5\u6570\uff1a500000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD+960G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a6\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u805a\u7126\u4f01\u4e8b\u4e1a\u7ec4\u7ec7\u7f51\u7edc\u884c\u4e3a\u5b89\u5168\uff0c\u5b9e\u73b0\u5168\u7f51\u8d44\u4ea7\u3001\u8eab\u4efd\u3001\u884c\u4e3a\u53ef\u89c6\u53ef\u63a7\uff0c\u667a\u80fd\u611f\u77e5\u5185\u90e8\u5a01\u80c1\u98ce\u9669\uff0c\u5e2e\u52a9\u7528\u6237\u6784\u5efa\u6709\u6548\u9632\u5fa1\u4f53\u7cfb\u3002","created_by":1013,"created_at":"2025-08-14 09:11:10","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"AC1000B1500","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1872,"erp_sales_order_id":1574,"erp_store_id":"","product_id":2099,"description":"","number":"1","outbound":"0","amount":"6025.00","total_amount":"6025","last_number":"","last_amount":"","last_total_amount":"","cost":"5014.00","total_cost":"5014","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}}],"projectContactPoints":[{"id":1139,"project_id":3945,"contact_id":5984,"point":"4000.00","paid_point":"","contact":{"id":5984,"key":5984,"name":"\u9f9a\u654f","client_id":1301,"supplier_id":"","client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"supplier":{}},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[],"reimbursementAmountSum":"","profit":35034.8646,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2562,"key":2562,"contract_id":4130,"name":"2025-09-15","value":"29935.8","overdue_days":"","status":0,"pct":30,"collect_status":"\u903e\u671f1\u5929"},{"id":2563,"key":2563,"contract_id":4130,"name":"2025-10-31","value":"69850.2","overdue_days":"","status":0,"pct":70,"collect_status":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":49216,"object_type":105,"object_id":4130,"attachment_id":27905,"attachment":{"id":27905,"key":27905,"name":"801f3090-ff52-395b-8067-6727f16da081","extension":"pdf","path":"\/vue\/attachment\/preview\/801f3090-ff52-395b-8067-6727f16da081\/2025_08_29_08_54_36.pdf","orig_name":"2025_08_29_08_54_36.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{},"collected_plan":99786,"projectProductTotalAmount":99786,"projectProductAllAmount":true,"projectProductTotalCost":64746.9,"projectProductAllCost":true,"projectProductTotalCount":9,"invoiced":0,"un_invoiced":99786,"collected":"0","un_collected":99786,"is_collected":false,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"settle_amount":"","checked":false},{"id":3886,"client_id":1301,"signed_at":"2025-04-28","amount":"48000","handler":5295,"description":"","created_by":5295,"created_at":"2025-04-28 19:19:08","updated_at":"2025-07-08 10:25:03","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3822,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-20250422001","payment_collection_remind_ahead":"","from_project":3822,"receipt_date":"","verify_date":"","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-05-06 11:08:12","is_verify":false,"is_draft":false,"erp_settle_amount":"14400","erp_un_settle_amount":"33600","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":"","passed":1,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":"","receiptScan":"","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":3886,"comment":8},"project":{"id":3822,"key":3822,"name":"2025\u7f51\u7edc\u6280\u672f\u670d\u52a1","erpSalesOrder":{"id":1486,"serial_no":"XSDD-20250731-00001","from_date":"","wrote_date":"2025-04-28","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":3822,"sales_contract_id":3886,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"12","amount":"48000","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-04-28 19:19:08","updated_at":"2025-04-28 19:19:08","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3822,"key":3822,"name":"2025\u7f51\u7edc\u6280\u672f\u670d\u52a1","description":"","total_contact_point":"6000","paid_contact_point":"5000","is_sales_order_ready":true,"project_product_version_id":844,"bargain_date":"2025-04-28","collected":"14400","profit_pct":"78.63","budget":"48000","erpSalesOrder":{"id":1486,"serial_no":"XSDD-20250731-00001","from_date":"","wrote_date":"2025-04-28","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":3822,"sales_contract_id":3886,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"12","amount":"48000","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-04-28 19:19:08","updated_at":"2025-04-28 19:19:08"},"projectProductTypes":[{"id":6679,"product_type_id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1","budget":"48000.00","pct":"78.63","project_id":3822,"profit":"37742.4"}],"projectProductRels":[{"id":10207,"project_id":3822,"product_id":941,"amount":"4000.00","number":12,"cost":"0","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-04-30","hardware_to":"","software_to":"","maintenance_to":"2026-04-30","total_amount":"48000","total_cost":"0","erp_sales_order_product_id":1602,"supplier":{},"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1602,"erp_sales_order_id":1486,"erp_store_id":"","product_id":941,"description":"","number":"12","outbound":"0","amount":"4000.00","total_amount":"48000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-04-30","hardware_to":"","software_to":"","maintenance_to":"2026-04-30"}}],"projectContactPoints":[{"id":1074,"project_id":3822,"contact_id":5969,"point":"1000.00","paid_point":"","contact":{"id":5969,"key":5969,"name":"\u8c46\u6d77\u9e4f","client_id":1301,"supplier_id":"","client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"supplier":{}},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"},{"id":1073,"project_id":3822,"contact_id":5984,"point":"5000.00","paid_point":"5000","contact":{"id":5984,"key":5984,"name":"\u9f9a\u654f","client_id":1301,"supplier_id":"","client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"supplier":{}},"projectContactPointRels":[{"id":206,"project_id":3822,"contact_id":5984,"point":"5000.00","day_at":"2025-07-08","description":"","created_at":"2025-07-08 10:25:03"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12806,"project_id":3822}],"reimbursementAmountSum":{"project_id":3822,"sum":"123.87"},"profit":37742.4,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8640,"user_id":5295,"key":5295,"contract_id":3886,"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":2408,"key":2408,"contract_id":3886,"name":"2025-05-30","value":"14400","overdue_days":"","status":1,"pct":30,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2409,"key":2409,"contract_id":3886,"name":"2025-09-30","value":"19200","overdue_days":"","status":0,"pct":40,"collect_status":""},{"id":2410,"key":2410,"contract_id":3886,"name":"2025-12-31","value":"14400","overdue_days":"","status":0,"pct":30,"collect_status":""}],"salesContractPayments":[{"id":"1318","key":"1318","contract_id":3886,"value":"14400","created_by":1013,"created_at":"2025-05-15 17:26:42","description":"","collected_date":"2025-05-15 17:26:42","amount":"14400","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":30}],"salesContractInvoices":[{"id":2035,"key":2035,"contract_id":3886,"value":"14400.00","attachment_id":"","from_date":"2025-05-08","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":33986,"object_type":102,"object_id":2035,"attachment_id":25441,"attachment":{"id":25441,"key":25441,"name":"df9be931-a384-3910-a640-f35f8653499e","extension":"pdf","path":"\/vue\/attachment\/view\/df9be931-a384-3910-a640-f35f8653499e\/dzfp_25112000000092707220_\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250508133656.pdf","orig_name":"dzfp_25112000000092707220_\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250508133656.pdf"}}]}],"contractScans":[{"id":35602,"object_type":105,"object_id":3886,"attachment_id":25574,"attachment":{"id":25574,"key":25574,"name":"4d83bd11-80f8-3497-9c73-8be37f953e50","extension":"pdf","path":"\/vue\/attachment\/preview\/4d83bd11-80f8-3497-9c73-8be37f953e50\/\u591a\u7ef4\u8054\u5408\u5408\u540c.pdf","orig_name":"\u591a\u7ef4\u8054\u5408\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{},"collected_plan":48000,"projectProductTotalAmount":48000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":12,"invoiced":14400,"un_invoiced":33600,"collected":"14400","un_collected":33600,"is_collected":false,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"settle_amount":"","checked":false}],"can_create":true,"pagenation":{"totalcount":2,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 14:44:15') RETURNING "id" |