ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689efb1bb16cd: POST https://beta.jinchangxiao.com/vue/sales-order-item/list at 2025-08-15 05:17:15 pm by 124.64.23.198

Database Queries

总计26条数据
TimeDurationTypeQuery
  
17:17:15.8413.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
17:17:15.8462.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:17:15.8547.4 msSELECTSELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC) "c"

[+] Explain
17:17:15.8614.3 msSELECTSELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC LIMIT 20

[+] Explain
17:17:15.8660.4 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2545, 3372, 3364)

[+] Explain
17:17:15.8670.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:17:15.8670.6 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
17:17:15.8680.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3899, 3886, 3890, 3857, 3760, 3855)

[+] Explain
17:17:15.8680.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1492, 1494, 2000, 1874, 2009, 2008, 1191, 1190, 1639, 1640, 969, 1973, 994, 1562, 1923, 1998, 1104)

[+] Explain
17:17:15.8690.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 4, 7, 5, 3, 22)

[+] Explain
17:17:15.8690.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (7, 19, 43, 188, 36, 35, 26, 4, 39, 191, 189)

[+] Explain
17:17:15.8700.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (4, 54, 12, 8, 10, 24)

[+] Explain
17:17:15.8700.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1631, 1632, 1395, 386, 743, 1640, 1244, 103, 104, 607, 31, 666, 741, 803, 739)

[+] Explain
17:17:15.8710.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (236, 678, 708, 163)

[+] Explain
17:17:15.8710.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

[+] Explain
17:17:15.8720.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)

[+] Explain
17:17:15.8720.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3

[+] Explain
17:17:15.8730.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "sales_order_item_id" IN (13054, 13055, 13051, 13045, 13046, 13047, 13048, 13049, 13044, 13043, 13042, 12976, 12977, 12978, 12973, 12975, 12974, 12473, 12991, 12841)

[+] Explain
17:17:15.8740.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:17:15.8740.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
17:17:15.8740.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id" IN (13054, 13055, 13051, 13045, 13046, 13047, 13048, 13049, 13044, 13043, 13042, 12976, 12977, 12978, 12973, 12975, 12974, 12473, 12991, 12841) ORDER BY "sales_date", "created_at"

[+] Explain
17:17:15.8752.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=27) AND ("object_id" IN (13054, 13055, 13051, 13045, 13046, 13047, 13048, 13049, 13044, 13043, 13042, 12976, 12977, 12978, 12973, 12975, 12974, 12473, 12991, 12841))

[+] Explain
17:17:15.8770.4 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name", "created_at" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26232, 26234, 26231, 26233, 26236, 26235, 26046, 26463)

[+] Explain
17:17:15.8793.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=34) AND ("visit_date"='2025-08-15')

[+] Explain
17:17:15.8830.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=55297

[+] Explain
17:17:15.8852.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-order-item/list', '{"is_all":"0","except":"","from_project":"1","SalesOrderItemSearch":{"group":"1","sales_rep":"1001","sn":"","created_by":"","is_merge":"","is_renew":"","renew_to_sales_order_item_id":"","client_id":"","project_id":""},"hardware_period":"","software_period":"","maintenance_period":"","Filter":{"name":"updated_at","sort":"DESC"},"page":"1","web_access_token":"sV2F29tsogQonulyxXoXQL59i2Ir83nH"}', '{"code":2000,"result":{"list":[{"id":13054,"sales_order_id":"","product_id":1492,"parent":"","sn":"WDCECA0139-511DD8F3","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-25 15:08:26","updated_at":"2025-06-25 15:09:27","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-07-05","maintenance_from":"","hardware_to":"","software_to":"2026-07-05","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2026-07-05","new_maintenance_deadline":"","client_id":2545,"project_id":3899,"sales_rep":1001,"sales_date":"2025-06-25","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5610.00","cost":"1288.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3899,"key":3899,"name":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee"},"product":{"id":1492,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1300A\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-03-05 17:56:36","updated_at":"2024-03-05 17:56:36","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH1300A","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"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11445,"sales_order_item_id":13054,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13055,"sales_order_id":"","product_id":1494,"parent":"","sn":"WDCECA0139-511DD8F3","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-25 15:08:26","updated_at":"2025-06-25 15:09:22","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-07-05","software_from":"","maintenance_from":"","hardware_to":"2026-07-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-07-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":2545,"project_id":3899,"sales_rep":1001,"sales_date":"2025-06-25","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3372.00","cost":"1097.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3899,"key":3899,"name":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee"},"product":{"id":1494,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08AF-1000-FH1300A\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":739,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-03-05 17:59:36","updated_at":"2024-03-05 17:59:36","pinyin_shortcut":"sxfcpzbrjsjfwAF1000FH1300A","product_unit":8,"is_renew":false,"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":739,"key":739,"name":"\u6df1\u4fe1\u670d\u8f6f\u4ef6\u786c\u4ef6\u5347\u7ea7\u670d\u52a1"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11444,"sales_order_item_id":13055,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13051,"sales_order_id":"","product_id":2000,"parent":"","sn":"","supplier_id":678,"order":0,"created_by":1011,"created_at":"2025-06-23 10:32:44","updated_at":"2025-06-23 10:32:44","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-10","software_from":"","maintenance_from":"","hardware_to":"2026-06-10","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-06-10","new_software_deadline":"","new_maintenance_deadline":"","client_id":2545,"project_id":3886,"sales_rep":1001,"sales_date":"2025-06-23","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4550.00","cost":"3800.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3886,"key":3886,"name":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee"},"product":{"id":2000,"name":"7Y37A01085","product_type":2,"product_component":7,"product_brand":4,"product_serie":1632,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-06-11 10:50:41","updated_at":"2025-06-11 10:50:41","pinyin_shortcut":"7Y37A01085","product_unit":3,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1632,"key":1632,"name":"\u8054\u60f3 RAID 930-16i 4GB Flash PCIe 12Gb"}},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11438,"sales_order_item_id":13051,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13045,"sales_order_id":"","product_id":1874,"parent":"","sn":"WDCFCB0388 - 29BDC2E2","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:28:56","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-06-20","maintenance_from":"","hardware_to":"","software_to":"2026-07-17","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2026-07-17","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"2807.86","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1874,"name":"\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6 V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":104,"product_misc":"","product_qa":"","pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743","created_by":1013,"created_at":"2024-11-08 11:17:07","updated_at":"2024-11-08 11:17:07","pinyin_shortcut":"sxfSSLVPNsqrjV60","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":104,"key":104,"name":"\u6df1\u4fe1\u670dVPN\u8f6f\u4ef6"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11436,"sales_order_item_id":13045,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13046,"sales_order_id":"","product_id":2009,"parent":"","sn":"WDCFCB0388 - 29BDC2E2","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:28:40","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-06-20","maintenance_from":"","hardware_to":"","software_to":"2026-07-17","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2026-07-17","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"2095.10","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":2009,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B\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-06-16 11:43:18","updated_at":"2025-06-16 11:43:18","pinyin_shortcut":"sxfywxqbwgrjV80syyAF1000FH1600B","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"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11435,"sales_order_item_id":13046,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13047,"sales_order_id":"","product_id":2008,"parent":"","sn":"WDCFCB0388 - 29BDC2E2","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:28:26","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-06-20","maintenance_from":"","hardware_to":"","software_to":"2026-07-17","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2026-07-17","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"1047.55","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":2008,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08AF-1000-FH1600B\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-06-16 11:40:41","updated_at":"2025-06-16 11:40:41","pinyin_shortcut":"sxfaqynyzdyrjV80AF1000FH1600B","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"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11434,"sales_order_item_id":13047,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13048,"sales_order_id":"","product_id":1191,"parent":"","sn":"WDCFCB0388 - 29BDC2E2","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:28:10","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-06-20","maintenance_from":"","hardware_to":"","software_to":"2026-07-17","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2026-07-17","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"9609.49","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1191,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":"","product_qa":"","pn":"","description":"\u4ea7\u54c1\u51fa\u5382\u9ed8\u8ba4\u81ea\u5e26\u529f\u80fd\uff0c\u5305\u62ecACL\u63a7\u5236\u3001\u5e94\u7528\u8bc6\u522b\u4e0e\u6d41\u63a7\u3001\u5165\u4fb5\u9632\u5fa1\u3001\u50f5\u5c38\u7f51\u7edc\u68c0\u6d4b\u7b49\u529f\u80fd","created_by":1013,"created_at":"2024-01-09 14:59:50","updated_at":"2024-07-31 17:30:05","pinyin_shortcut":"sxffhqrjV80syyAF1000FH1600B","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11433,"sales_order_item_id":13048,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13049,"sales_order_id":"","product_id":1190,"parent":"","sn":"WDCFCB0388 - 29BDC2E2","supplier_id":236,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:27:36","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-21","software_from":"","maintenance_from":"","hardware_to":"2026-07-17","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-07-17","new_software_deadline":"","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"25000.00","cost":"2030.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1190,"name":"AF-1000-FH1600B","product_type":5,"product_component":191,"product_brand":12,"product_serie":741,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff1a4G\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a2G\uff0c\u9632\u75c5\u6bd2\u541e\u5410\u91cf\uff1a600M\uff0cIPS\u541e\u5410\u91cf\uff1a600M\uff0c\u5168\u5a01\u80c1\u541e\u5410\u91cf\uff1a450M\uff0c\u5e76\u53d1\u8fde\u63a5\u6570\uff1a200\u4e07\uff0cHTTP\u65b0\u5efa\u8fde\u63a5\u6570\uff1a6\u4e07\uff0cSSL VPN\u63a8\u8350\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a20\uff0cSSL VPN\u6700\u5927\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a60\uff0cSSL VPN\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a160M\uff0cIPSec VPN \u6700\u5927\u63a5\u5165\u6570\uff1a300\uff0cIPSec VPN\u541e\u5410\u91cf\uff1a270M\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a4G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a8\u5343\u5146\u7535\u53e3+2\u5343\u5146\u5149\u53e3SFP\u3002","created_by":1013,"created_at":"2024-01-09 14:58:07","updated_at":"2024-01-09 14:58:07","pinyin_shortcut":"AF1000FH1600B","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":191,"key":191,"name":"\u6df1\u4fe1\u670dAF-1000\u9632\u706b\u5899"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":741,"key":741,"name":"\u6df1\u4fe1\u670dAF-1000-FH1600B\u6807\u51c6\u4ea7\u54c1"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11432,"sales_order_item_id":13049,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[{"id":35271,"object_type":27,"object_id":13049,"attachment_id":26463,"attachment":{"id":26463,"key":26463,"name":"1c729739-4c62-3c64-a466-38a0ab3af9a7","extension":"xlsx","path":"\/vue\/attachment\/view\/1c729739-4c62-3c64-a466-38a0ab3af9a7\/\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09.xlsx","orig_name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09.xlsx","created_at":"2025-06-20 17:25:45"}}],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13044,"sales_order_id":"","product_id":1639,"parent":"","sn":"","supplier_id":708,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:25:20","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-21","software_from":"","maintenance_from":"","hardware_to":"2026-06-20","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-06-20","new_software_deadline":"","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"10000.00","cost":"8276.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1639,"name":"RG-S5750C-24GT8XS-X","product_type":4,"product_component":19,"product_brand":54,"product_serie":1395,"product_misc":"","product_qa":"","pn":"","description":"24\u7aef\u53e3\u5343\u5146\u4ee5\u592a\u7f51\u7535\u53e3(RJ45)+8\u7aef\u53e3\u4e07\u5146\u4ee5\u592a\u7f51\u5149\u53e3(SFP+)","created_by":1013,"created_at":"2024-05-31 16:43:40","updated_at":"2024-05-31 16:43:40","pinyin_shortcut":"RGS5750C24GT8XSX","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":54,"key":54,"name":"\u9510\u6377"},"productSerie":{"id":1395,"key":1395,"name":"\u9510\u6377RG-S5750C-24GT8XS-X\u4ea4\u6362\u673a"}},"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11426,"sales_order_item_id":13044,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13043,"sales_order_id":"","product_id":1640,"parent":"","sn":"","supplier_id":708,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:25:20","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-21","software_from":"","maintenance_from":"","hardware_to":"2026-06-20","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-06-20","new_software_deadline":"","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"258.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1640,"name":"XG-SR-MM850","product_type":4,"product_component":43,"product_brand":54,"product_serie":386,"product_misc":"","product_qa":"","pn":"","description":"\u9510\u6377\u4e07\u5146\u591a\u6a21\u6a21\u5757","created_by":1013,"created_at":"2024-05-31 16:44:50","updated_at":"2024-05-31 16:44:50","pinyin_shortcut":"XGSRMM850","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":54,"key":54,"name":"\u9510\u6377"},"productSerie":{"id":386,"key":386,"name":"\u9510\u6377SFP+\u4e07\u514610Gb\u6a21\u5757"}},"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11425,"sales_order_item_id":13043,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":13042,"sales_order_id":"","product_id":1640,"parent":"","sn":"","supplier_id":708,"order":0,"created_by":1011,"created_at":"2025-06-20 17:25:20","updated_at":"2025-06-20 17:25:20","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-21","software_from":"","maintenance_from":"","hardware_to":"2026-06-20","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-06-20","new_software_deadline":"","new_maintenance_deadline":"","client_id":3372,"project_id":3890,"sales_rep":1001,"sales_date":"2025-06-20","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"258.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1640,"name":"XG-SR-MM850","product_type":4,"product_component":43,"product_brand":54,"product_serie":386,"product_misc":"","product_qa":"","pn":"","description":"\u9510\u6377\u4e07\u5146\u591a\u6a21\u6a21\u5757","created_by":1013,"created_at":"2024-05-31 16:44:50","updated_at":"2024-05-31 16:44:50","pinyin_shortcut":"XGSRMM850","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":54,"key":54,"name":"\u9510\u6377"},"productSerie":{"id":386,"key":386,"name":"\u9510\u6377SFP+\u4e07\u514610Gb\u6a21\u5757"}},"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11424,"sales_order_item_id":13042,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12976,"sales_order_id":"","product_id":969,"parent":"","sn":"026709016164","supplier_id":163,"order":0,"created_by":1011,"created_at":"2025-06-06 16:52:07","updated_at":"2025-06-17 11:23:08","pn":"PAN-PA-1410","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-06","software_from":"","maintenance_from":"","hardware_to":"2028-06-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-06-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":3364,"project_id":3857,"sales_rep":1001,"sales_date":"2025-06-06","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"43305.00","cost":"41154.60","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2024-01-12 15:43:25","pinyin_shortcut":"PANPA1410","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"}},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11384,"sales_order_item_id":12976,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12977,"sales_order_id":"","product_id":969,"parent":"","sn":"026709016178","supplier_id":163,"order":0,"created_by":1011,"created_at":"2025-06-06 16:52:07","updated_at":"2025-06-17 11:22:40","pn":"PAN-PA-1410","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-06","software_from":"","maintenance_from":"","hardware_to":"2028-06-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-06-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":3364,"project_id":3857,"sales_rep":1001,"sales_date":"2025-06-06","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"43305.00","cost":"41154.60","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2024-01-12 15:43:25","pinyin_shortcut":"PANPA1410","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"}},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11383,"sales_order_item_id":12977,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12978,"sales_order_id":"","product_id":969,"parent":"","sn":"026709017313","supplier_id":163,"order":0,"created_by":1011,"created_at":"2025-06-06 16:52:07","updated_at":"2025-06-17 11:22:16","pn":"PAN-PA-1410","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-06","software_from":"","maintenance_from":"","hardware_to":"2028-06-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-06-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":3364,"project_id":3857,"sales_rep":1001,"sales_date":"2025-06-06","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"43305.00","cost":"41154.60","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2024-01-12 15:43:25","pinyin_shortcut":"PANPA1410","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"}},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11382,"sales_order_item_id":12978,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12973,"sales_order_id":"","product_id":1973,"parent":"","sn":"","supplier_id":163,"order":0,"created_by":1011,"created_at":"2025-06-06 16:52:07","updated_at":"2025-06-17 11:21:41","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-06-06","maintenance_from":"","hardware_to":"","software_to":"2028-06-05","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2028-06-05","new_maintenance_deadline":"","client_id":3364,"project_id":3857,"sales_rep":1001,"sales_date":"2025-06-06","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"105300.00","cost":"99928.16","is_renew":false,"renew_to_sales_order_item_id":"","number":3,"is_merge":true,"need_sn":true,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":803,"product_misc":"","product_qa":"","pn":"","description":"PAN-PA-1410-BND-CORESEC-3YR PA-1410\uff0cPrecision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering,Advanced Wildfire, Advanced DNS Security and SD-WAN ), 3 years (36 months) term\n\u7cbe\u51c6AI\u7f51\u7edc\u5b89\u5168\u8ba2\u9605\u5305\uff08\u9ad8\u7ea7\u5a01\u80c1\u9632\u5fa1\u3001\u9ad8\u7ea7URL\u8fc7\u6ee4\u3001\u9ad8\u7ea7\u91ce\u706b\u3001\u9ad8\u7ea7DNS\u5b89\u5168\u548cSD-WAN\uff09\uff0c3\u5e74\uff0836\u4e2a\u6708\uff09\u671f\u9650","created_by":1013,"created_at":"2025-05-20 09:22:36","updated_at":"2025-05-20 09:22:36","pinyin_shortcut":"PANPA1410BNDCORESEC3YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":803,"key":803,"name":"PA-1410\u4e09\u5e74\u670d\u52a1"}},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11381,"sales_order_item_id":12973,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[{"id":35130,"object_type":27,"object_id":12973,"attachment_id":26046,"attachment":{"id":26046,"key":26046,"name":"91f0cf42-2e38-35a8-9697-527e28155f57","extension":"pdf","path":"\/vue\/attachment\/view\/91f0cf42-2e38-35a8-9697-527e28155f57\/Authorization code - SO10636765.PDF","orig_name":"Authorization code - SO10636765.PDF","created_at":"2025-06-06 16:52:29"}}],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12975,"sales_order_id":"","product_id":994,"parent":"","sn":"","supplier_id":163,"order":0,"created_by":1011,"created_at":"2025-06-06 16:52:07","updated_at":"2025-06-17 11:21:00","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-06","software_from":"","maintenance_from":"","hardware_to":"2028-06-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-06-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":3364,"project_id":3857,"sales_rep":1001,"sales_date":"2025-06-06","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"36000.00","cost":"34130.52","is_renew":false,"renew_to_sales_order_item_id":"","number":3,"is_merge":true,"need_sn":true,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"product":{"id":994,"name":"PAN-SVC-BKLN-1410-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":803,"product_misc":"","product_qa":"","pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2023-08-09 17:40:22","updated_at":"2024-01-12 15:29:43","pinyin_shortcut":"PANSVCBKLN14103YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":803,"key":803,"name":"PA-1410\u4e09\u5e74\u670d\u52a1"}},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11380,"sales_order_item_id":12975,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12974,"sales_order_id":"","product_id":1562,"parent":"","sn":"KKLD2405003145","supplier_id":163,"order":0,"created_by":1011,"created_at":"2025-06-06 16:52:07","updated_at":"2025-06-17 11:20:05","pn":"PAN-PWR-450W-AC","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-06","software_from":"","maintenance_from":"","hardware_to":"2028-06-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-06-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":3364,"project_id":3857,"sales_rep":1001,"sales_date":"2025-06-06","description":"KKLD2405003145,KKLD2405003160,KKLD2405003169","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5395.00","cost":"5120.06","is_renew":false,"renew_to_sales_order_item_id":"","number":3,"is_merge":true,"need_sn":true,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":"","product_qa":"","pn":"","description":"PA-3400,PA-1400, ION 5200 and ION 9200 450W spare power supply","created_by":1013,"created_at":"2024-04-15 15:40:42","updated_at":"2024-04-15 15:40:42","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"}},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11378,"sales_order_item_id":12974,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12473,"sales_order_id":"","product_id":1923,"parent":"","sn":"S0CDA10845416330A1","supplier_id":"","order":0,"created_by":1011,"created_at":"2025-01-10 15:26:22","updated_at":"2025-06-13 16:10:26","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-01-10","software_from":"","maintenance_from":"","hardware_to":"2026-01-10","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-01-10","new_software_deadline":"","new_maintenance_deadline":"","client_id":2545,"project_id":3760,"sales_rep":1001,"sales_date":"2025-01-10","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"0","cost":"230.00","is_renew":false,"renew_to_sales_order_item_id":"","number":24,"is_merge":true,"need_sn":true,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1923,"name":"32GB PC4-2666P\u5185\u5b58","product_type":2,"product_component":4,"product_brand":10,"product_serie":31,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-01-09 10:41:37","updated_at":"2025-01-09 10:41:37","pinyin_shortcut":"32GBPC42666Pnc","product_unit":6,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":31,"key":31,"name":"DDR4"}},"supplier":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11377,"sales_order_item_id":12473,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[{"id":34969,"object_type":27,"object_id":12473,"attachment_id":26232,"attachment":{"id":26232,"key":26232,"name":"ab0a2447-23f5-3466-8b21-427abf32bfd8","extension":"jpg","path":"\/vue\/attachment\/view\/ab0a2447-23f5-3466-8b21-427abf32bfd8\/1.jpg","orig_name":"1.jpg","created_at":"2025-06-13 16:10:23"}},{"id":34970,"object_type":27,"object_id":12473,"attachment_id":26234,"attachment":{"id":26234,"key":26234,"name":"838969e6-8a23-31f1-9e35-d33d8fbab072","extension":"jpg","path":"\/vue\/attachment\/view\/838969e6-8a23-31f1-9e35-d33d8fbab072\/2.jpg","orig_name":"2.jpg","created_at":"2025-06-13 16:10:23"}},{"id":34971,"object_type":27,"object_id":12473,"attachment_id":26231,"attachment":{"id":26231,"key":26231,"name":"c349f398-6ffc-3792-9d29-2a8b5036328e","extension":"jpg","path":"\/vue\/attachment\/view\/c349f398-6ffc-3792-9d29-2a8b5036328e\/3.jpg","orig_name":"3.jpg","created_at":"2025-06-13 16:10:23"}},{"id":34972,"object_type":27,"object_id":12473,"attachment_id":26233,"attachment":{"id":26233,"key":26233,"name":"5fcb6334-9fee-3d46-b12f-7d20c22a7fe8","extension":"jpg","path":"\/vue\/attachment\/view\/5fcb6334-9fee-3d46-b12f-7d20c22a7fe8\/4.jpg","orig_name":"4.jpg","created_at":"2025-06-13 16:10:23"}},{"id":34973,"object_type":27,"object_id":12473,"attachment_id":26236,"attachment":{"id":26236,"key":26236,"name":"a453146e-e7b3-3139-b1ca-fcc02c0c40de","extension":"jpg","path":"\/vue\/attachment\/view\/a453146e-e7b3-3139-b1ca-fcc02c0c40de\/5.jpg","orig_name":"5.jpg","created_at":"2025-06-13 16:10:24"}},{"id":34974,"object_type":27,"object_id":12473,"attachment_id":26235,"attachment":{"id":26235,"key":26235,"name":"a1e0c87f-d36c-39f8-bed8-c787e0461063","extension":"jpg","path":"\/vue\/attachment\/view\/a1e0c87f-d36c-39f8-bed8-c787e0461063\/6.jpg","orig_name":"6.jpg","created_at":"2025-06-13 16:10:23"}}],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12991,"sales_order_id":"","product_id":1998,"parent":"","sn":"8SSR17A85787L5HF43W021D","supplier_id":678,"order":0,"created_by":1011,"created_at":"2025-06-10 15:08:26","updated_at":"2025-06-13 15:35:25","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-06-10","software_from":"","maintenance_from":"","hardware_to":"2026-06-10","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-06-10","new_software_deadline":"","new_maintenance_deadline":"","client_id":2545,"project_id":3886,"sales_rep":1001,"sales_date":"2025-06-10","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4550.00","cost":"1300.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3886,"key":3886,"name":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee"},"product":{"id":1998,"name":"03LA253","product_type":2,"product_component":7,"product_brand":4,"product_serie":1631,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-06-10 14:07:25","updated_at":"2025-06-10 14:07:25","pinyin_shortcut":"03LA253","product_unit":3,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1631,"key":1631,"name":"\u8054\u60f3 5350-8i 12G SAS\u9635\u5217\u5361"}},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11366,"sales_order_item_id":12991,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":12841,"sales_order_id":"","product_id":1104,"parent":"","sn":" 8SSR17A18205L2ST7BFS785","supplier_id":678,"order":0,"created_by":1011,"created_at":"2025-05-13 16:21:57","updated_at":"2025-06-13 15:35:02","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-05-15","software_from":"","maintenance_from":"","hardware_to":"2026-05-14","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-05-14","new_software_deadline":"","new_maintenance_deadline":"","client_id":2545,"project_id":3855,"sales_rep":1001,"sales_date":"2025-05-13","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"2500.00","cost":"1100.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db"},"product":{"id":1104,"name":"QLE2692 Dual Port 16Gb","product_type":3,"product_component":39,"product_brand":24,"product_serie":666,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-11-27 15:10:06","updated_at":"2024-01-16 14:46:51","pinyin_shortcut":"QLE2692DualPort16Gb","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":666,"key":666,"name":"16GB \u53cc\u53e3 HBA\u5361"}},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"salesOrderItemRemindReceivers":[{"id":11365,"sales_order_item_id":12841,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"can_update":true,"pagenation":{"totalcount":385,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-15 17:17:15') RETURNING "id"

[+] Explain