Performance Profiling

Total processing time: 98 ms; Peak memory: 6.910 MB. Show Profiling Timeline

总计44条数据
TimeDurationCategoryInfo
  
16:22:25.91119.5 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20007) AND ("object_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) GROUP BY "object_id"
16:22:25.93117.4 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20007) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) GROUP BY "object_id"
16:22:25.8795.6 msyii\db\Command::querySELECT r.* FROM "a57be577deb434"."tbl_erp_sales_orders" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_products" "epop" ON epop.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON epop.product_id = product.id WHERE (("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=1001))) GROUP BY "r"."id" ORDER BY "r"."updated_at" DESC LIMIT 20 OFFSET 220
16:22:25.8744.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_sales_orders" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_products" "epop" ON epop.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON epop.product_id = product.id WHERE (("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=1001))) GROUP BY "r"."id" ORDER BY "r"."updated_at" DESC) "c"
16:22:25.9523.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-order/list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpSalesOrderSearch":{"wrote_date_period":"","from_date_period":"","status":"","outbound_status":"","handler":"","created_by":"","number_range_to":"","number_range_from":"","amount_range_to":"","amount_range_from":""},"page":"12","web_access_token":"Hc6bcOPECvJmn-MxoPjAzgccBe0xyT-M"}', '{"code":2000,"result":{"list":[{"id":1341,"serial_no":"XSDD-20241216-00001","from_date":"","wrote_date":"2024-09-04","handler":5087,"client_id":2526,"purchase_contract_id":"","project_id":3651,"sales_contract_id":3522,"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":"2024-09-04 16:12:30","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"4000","created_by":5087,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-04 16:12:30","updated_at":"2024-09-04 16:12:30","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3651,"key":3651,"name":"\u7cfb\u7edf\u516c\u53f8\u7f51\u7edc\u7ef4\u62a4\u2014K"},"salesContract":{"id":3522,"key":3522,"name":"TS-LW-2024090401","contractScans":[{"id":28574,"object_type":105,"object_id":3522,"attachment_id":21397,"attachment":{"id":21397,"key":21397,"name":"e2235438-88e8-3a21-b89f-f05ed7c77c84","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"2024_09_10_13_30_48.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1208,"erp_sales_order_id":1341,"erp_store_id":"","product_id":941,"description":"","number":"1","outbound":"0","amount":"4000","total_amount":"4000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1340,"serial_no":"XSDD-20241025-00001","from_date":"","wrote_date":"2024-09-04","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3650,"sales_contract_id":3521,"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":"2024-09-04 13:46:34","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"2","amount":"594","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-04 13:46:34","updated_at":"2024-09-04 13:46:34","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3650,"key":3650,"name":"POBJ24090789-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-G-2024"},"salesContract":{"id":3521,"key":3521,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24090789","contractScans":[{"id":28725,"object_type":105,"object_id":3521,"attachment_id":21299,"attachment":{"id":21299,"key":21299,"name":"52079aab-dd3b-3370-aa07-38663fc3f4cd","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"POBJ24090789.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1206,"erp_sales_order_id":1340,"erp_store_id":"","product_id":1690,"description":"","number":"1","outbound":"0","amount":"295","total_amount":"295","last_number":"","last_amount":"","last_total_amount":"","cost":"179","total_cost":"179","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"erpInventoryCount":""},"un_outbound":1},{"id":1207,"erp_sales_order_id":1340,"erp_store_id":"","product_id":1691,"description":"","number":"1","outbound":"0","amount":"299","total_amount":"299","last_number":"","last_amount":"","last_total_amount":"","cost":"142","total_cost":"142","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1339,"serial_no":"XSDD-20241025-00001","from_date":"","wrote_date":"2024-09-04","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3649,"sales_contract_id":3520,"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":"2024-09-04 13:43:17","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"2","amount":"594","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-04 13:43:17","updated_at":"2024-09-04 13:43:17","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3649,"key":3649,"name":"POBJ24090477-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-G-2024"},"salesContract":{"id":3520,"key":3520,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24090477","contractScans":[{"id":28726,"object_type":105,"object_id":3520,"attachment_id":21300,"attachment":{"id":21300,"key":21300,"name":"ec68672f-87e2-3492-bb24-202cded141ed","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"POBJ24090477.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1204,"erp_sales_order_id":1339,"erp_store_id":"","product_id":1690,"description":"","number":"1","outbound":"0","amount":"295","total_amount":"295","last_number":"","last_amount":"","last_total_amount":"","cost":"179","total_cost":"179","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"erpInventoryCount":""},"un_outbound":1},{"id":1205,"erp_sales_order_id":1339,"erp_store_id":"","product_id":1691,"description":"","number":"1","outbound":"0","amount":"299","total_amount":"299","last_number":"","last_amount":"","last_total_amount":"","cost":"142","total_cost":"142","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1338,"serial_no":"XSDD-20241219-00001","from_date":"","wrote_date":"2024-08-30","handler":1005,"client_id":57,"purchase_contract_id":"","project_id":3540,"sales_contract_id":3514,"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":"2024-08-30 12:00:19","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"151","amount":"63950","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-30 12:00:19","updated_at":"2024-08-30 12:00:19","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":3540,"key":3540,"name":"\u5317\u4eac-PO\uff1a20240830007\/20240830008\/20240830009\u6a21\u62df\u8bdd\u673a\u66ff\u6362"},"salesContract":{"id":3514,"key":3514,"name":"\u4fdd\u8bfa\u5317\u4eac\u8ba2\u5355PO:20240830007\/20240830008\/20240830009","contractScans":[{"id":30798,"object_type":105,"object_id":3514,"attachment_id":21182,"attachment":{"id":21182,"key":21182,"name":"00a35a86-a58b-3c0b-bbc6-b825c60138de","extension":"png","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u622a\u5c4f2024-08-30 \u4e0a\u534810.55.20.png"}},{"id":30799,"object_type":105,"object_id":3514,"attachment_id":21184,"attachment":{"id":21184,"key":21184,"name":"b73507bd-122d-3905-83eb-5c73b23c45b0","extension":"png","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u622a\u5c4f2024-08-30 \u4e0a\u534810.55.53.png"}},{"id":30800,"object_type":105,"object_id":3514,"attachment_id":21183,"attachment":{"id":21183,"key":21183,"name":"4f684b32-302c-3ff8-b379-8dd5f731519e","extension":"png","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u622a\u5c4f2024-08-30 \u4e0a\u534810.56.22.png"}},{"id":30801,"object_type":105,"object_id":3514,"attachment_id":21297,"attachment":{"id":21297,"key":21297,"name":"6d6e8f94-cf74-3073-9a47-9183dff67520","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"\u4fdd\u8bfa.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1201,"erp_sales_order_id":1338,"erp_store_id":"","product_id":1773,"description":"","number":"30","outbound":"0","amount":"485","total_amount":"14550","last_number":"","last_amount":"","last_total_amount":"","cost":"365","total_cost":"10950","supplier_id":474,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1773,"name":"SIP-T31W","product_type":4,"product_component":60,"product_brand":39,"product_serie":1498,"product_misc":"","product_qa":"","pn":"","description":"\u9ed1\u767d\u5c4fWi-Fi Phone\uff1a\n\u20222.3\" 132x64\u9ed1\u767d\u5c4f\n\u2022\u5185\u7f6eWi-Fi \n\u2022\u9ad8\u6e05\u97f3\u8d28\n\u2022 2\u4e2a SIP\u8d26\u53f7\n\u2022 \u652f\u6301Opus codec\n\u2022 T3X\u7edf\u4e00\u56fa\u4ef6\n\u2022 \u652f\u6301PoE\n\u2022 \u6807\u914d\u7535\u6e90","created_by":1013,"created_at":"2024-08-30 14:59:56","updated_at":"2024-08-30 14:59:56","pinyin_shortcut":"SIPT31W","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":60,"key":60,"name":"\u7f51\u7edcIP\u7535\u8bdd"},"productBrand":{"id":39,"key":39,"name":"\u4ebf\u8054"},"productSerie":{"id":1498,"key":1498,"name":"\u4ebf\u8054 SIP-T31W\u7f51\u7edc\u7535\u8bdd"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":30},{"id":1202,"erp_sales_order_id":1338,"erp_store_id":"","product_id":861,"description":"","number":"120","outbound":"0","amount":"370","total_amount":"44400","last_number":"","last_amount":"","last_total_amount":"","cost":"280","total_cost":"33600","supplier_id":474,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":861,"name":"SIP-T30P","product_type":4,"product_component":60,"product_brand":39,"product_serie":842,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-08-03 14:19:14","updated_at":"2024-01-16 10:11:51","pinyin_shortcut":"SIPT30P","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":60,"key":60,"name":"\u7f51\u7edcIP\u7535\u8bdd"},"productBrand":{"id":39,"key":39,"name":"\u4ebf\u8054"},"productSerie":{"id":842,"key":842,"name":"T30P\u7f51\u7edcIP\u7535\u8bdd"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":120},{"id":1203,"erp_sales_order_id":1338,"erp_store_id":"","product_id":942,"description":"","number":"1","outbound":"0","amount":"5000","total_amount":"5000","last_number":"","last_amount":"","last_total_amount":"","cost":"4455","total_cost":"4455","supplier_id":474,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1337,"serial_no":"XSDD-20240919-00001","from_date":"","wrote_date":"2024-08-30","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3647,"sales_contract_id":3512,"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":"2024-08-30 09:15:00","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"2","amount":"806","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-30 09:15:00","updated_at":"2024-08-30 09:15:00","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3647,"key":3647,"name":"POBJ24085946-\u5185\u5b58\u6761+\u56fa\u6001\u786c\u76d8-G-2024"},"salesContract":{"id":3512,"key":3512,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24085946","contractScans":[{"id":28727,"object_type":105,"object_id":3512,"attachment_id":21217,"attachment":{"id":21217,"key":21217,"name":"ae6d990f-b433-3b6e-97f0-e325087977c9","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"POBJ24085946.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1199,"erp_sales_order_id":1337,"erp_store_id":"","product_id":1690,"description":"","number":"1","outbound":"0","amount":"295","total_amount":"295","last_number":"","last_amount":"","last_total_amount":"","cost":"192.5","total_cost":"192.5","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"erpInventoryCount":""},"un_outbound":1},{"id":1200,"erp_sales_order_id":1337,"erp_store_id":"","product_id":1770,"description":"","number":"1","outbound":"0","amount":"511","total_amount":"511","last_number":"","last_amount":"","last_total_amount":"","cost":"306","total_cost":"306","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1770,"name":"BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1495,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-08-29 14:10:56","updated_at":"2024-08-29 14:10:56","pinyin_shortcut":"BG5512G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1495,"key":1495,"name":"\u4e1c\u829d BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1336,"serial_no":"XSDD-20240919-00001","from_date":"","wrote_date":"2024-08-29","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3646,"sales_contract_id":3507,"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":"2024-08-29 11:14:06","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"2","amount":"806","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-29 11:14:06","updated_at":"2024-08-29 11:14:06","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3646,"key":3646,"name":"\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-POBJ24085833-G-2024"},"salesContract":{"id":3507,"key":3507,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24085833","contractScans":[{"id":28728,"object_type":105,"object_id":3507,"attachment_id":21216,"attachment":{"id":21216,"key":21216,"name":"d6880c56-2aa9-3937-aa5b-27f8593ff9e3","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"POBJ24085833.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1197,"erp_sales_order_id":1336,"erp_store_id":"","product_id":1690,"description":"","number":"1","outbound":"0","amount":"295","total_amount":"295","last_number":"","last_amount":"","last_total_amount":"","cost":"192.5","total_cost":"192.5","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"erpInventoryCount":""},"un_outbound":1},{"id":1198,"erp_sales_order_id":1336,"erp_store_id":"","product_id":1770,"description":"","number":"1","outbound":"0","amount":"511","total_amount":"511","last_number":"","last_amount":"","last_total_amount":"","cost":"306","total_cost":"306","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1770,"name":"BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1495,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-08-29 14:10:56","updated_at":"2024-08-29 14:10:56","pinyin_shortcut":"BG5512G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1495,"key":1495,"name":"\u4e1c\u829d BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1335,"serial_no":"XSDD-20240913-00001","from_date":"","wrote_date":"2024-08-28","handler":5300,"client_id":97,"purchase_contract_id":"","project_id":3645,"sales_contract_id":3504,"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":"2024-08-28 15:43:24","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"3","amount":"6600","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-28 15:43:24","updated_at":"2024-08-28 15:43:24","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)"},"project":{"id":3645,"key":3645,"name":"\u6234\u5c14\u786c\u76d8MZ-7LH1T90\uff08dell\uff09-G-2024"},"salesContract":{"id":3504,"key":3504,"name":"TS-SQY-2024082801","contractScans":[{"id":28335,"object_type":105,"object_id":3504,"attachment_id":21192,"attachment":{"id":21192,"key":21192,"name":"afc0c43c-86f7-33e4-a286-4993fd271ca8","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"2024_08_30_13_03_28.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1196,"erp_sales_order_id":1335,"erp_store_id":"","product_id":1767,"description":"","number":"3","outbound":"0","amount":"2200","total_amount":"6600","last_number":"","last_amount":"","last_total_amount":"","cost":"1800","total_cost":"5400","supplier_id":212,"hardware_from":"2024-08-28","software_from":"","maintenance_from":"","hardware_to":"2027-08-27","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1767,"name":"MZ-7LH1T90","product_type":3,"product_component":15,"product_brand":9,"product_serie":1494,"product_misc":"","product_qa":"","pn":"","description":"1.92TB SATA 6Gb\/s 2.5\" Enterprise SSD","created_by":1013,"created_at":"2024-08-28 17:08:29","updated_at":"2024-08-29 09:23:19","pinyin_shortcut":"MZ7LH1T90","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"productSerie":{"id":1494,"key":1494,"name":"DELL 1.92TB 6G 2.5 SSD \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"erpInventoryCount":""},"un_outbound":3}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1334,"serial_no":"XSDD-20250124-00001","from_date":"","wrote_date":"2024-08-28","handler":1001,"client_id":2553,"purchase_contract_id":"","project_id":3644,"sales_contract_id":3502,"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":"2024-08-28 11:57:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"7","amount":"120000","created_by":1001,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-28 11:57:23","updated_at":"2024-08-28 11:57:23","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee"},"salesContract":{"id":3502,"key":3502,"name":"W-KJ-CG-ZBL-20240902-01","contractScans":[{"id":32993,"object_type":105,"object_id":3502,"attachment_id":21308,"attachment":{"id":21308,"key":21308,"name":"61215821-6952-33fb-9308-bf5a871115a5","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"\u91c7\u8d2d\u5408\u540c--\u6c99\u7279\u6731\u62dc\u52d2\u7f51\u7edc\u5b89\u5168\u9632\u706b\u5899.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1190,"erp_sales_order_id":1334,"erp_store_id":"","product_id":196,"description":"","number":"1","outbound":"0","amount":"32452","total_amount":"32452","last_number":"","last_amount":"","last_total_amount":"","cost":"17849","total_cost":"17849","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":196,"name":"PAN-PA-820","product_type":5,"product_component":26,"product_brand":8,"product_serie":165,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-05-16 10:42:17","updated_at":"2024-01-12 14:13:38","pinyin_shortcut":"PANPA820","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":165,"key":165,"name":"PA820\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1191,"erp_sales_order_id":1334,"erp_store_id":"","product_id":1303,"description":"","number":"1","outbound":"0","amount":"23210","total_amount":"23210","last_number":"","last_amount":"","last_total_amount":"","cost":"22746","total_cost":"22746","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1303,"name":"PAN-SVC-PREM-820-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":804,"product_misc":"","product_qa":"","pn":"","description":"Premium support 3-year term, PA-820","created_by":1013,"created_at":"2024-01-23 14:00:39","updated_at":"2024-01-23 14:00:39","pinyin_shortcut":"PANSVCPREM8203YR","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":804,"key":804,"name":"PA-820\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1192,"erp_sales_order_id":1334,"erp_store_id":"","product_id":1763,"description":"","number":"1","outbound":"0","amount":"16138","total_amount":"16138","last_number":"","last_amount":"","last_total_amount":"","cost":"15816","total_cost":"15816","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1763,"name":"PAN-PA-820-TP-3YR-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":"","product_qa":"","pn":"","description":"Threat prevention subscription 3-year term for device in an HA pair, PA-820","created_by":1013,"created_at":"2024-08-28 16:56:26","updated_at":"2024-08-28 16:56:26","pinyin_shortcut":"PANPA820TP3YRHA2","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1193,"erp_sales_order_id":1334,"erp_store_id":"","product_id":1764,"description":"","number":"1","outbound":"0","amount":"24100","total_amount":"24100","last_number":"","last_amount":"","last_total_amount":"","cost":"23782","total_cost":"23782","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1764,"name":"PAN-PA-820-ADVURL-3YR-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":"","product_qa":"","pn":"","description":"Advanced URL Filtering Subscription, 3-year, PA-820 HA Pair","created_by":1013,"created_at":"2024-08-28 16:57:19","updated_at":"2024-08-28 16:57:19","pinyin_shortcut":"PANPA820ADVURL3YRHA2","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1194,"erp_sales_order_id":1334,"erp_store_id":"","product_id":1766,"description":"","number":"1","outbound":"0","amount":"24100","total_amount":"24100","last_number":"","last_amount":"","last_total_amount":"","cost":"23782","total_cost":"23782","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1766,"name":"PAN-PA-820-AWF-3YR-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":"","product_qa":"","pn":"","description":"Advanced WildFire subscription 3-year term for device in an HA pair, PA-820","created_by":1013,"created_at":"2024-08-28 17:00:07","updated_at":"2024-08-28 17:00:07","pinyin_shortcut":"PANPA820AWF3YRHA2","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1195,"erp_sales_order_id":1334,"erp_store_id":"","product_id":1668,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"600","total_cost":"1200","supplier_id":531,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1668,"name":"PAN-SFP-CG\u7b2c\u4e09\u65b9\u6a21\u5757","product_type":4,"product_component":43,"product_brand":8,"product_serie":1419,"product_misc":"","product_qa":"","pn":"","description":"SFP form factor.1Gb copper transceiver,100m over Cat5 RJ-45.IEEE802.3ab 1000BASE-T","created_by":1013,"created_at":"2024-07-09 14:17:00","updated_at":"2024-07-09 14:17:00","pinyin_shortcut":"PANSFPCGdsfmk","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1419,"key":1419,"name":"PAN-SFP-CG"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":2}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1333,"serial_no":"XSDD-20240829-00001","from_date":"","wrote_date":"2024-08-27","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":3643,"sales_contract_id":3498,"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":"2024-08-27 11:19:20","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"1000","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-27 11:19:20","updated_at":"2024-08-27 11:19:20","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"}},"handlerPerson":{"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"}},"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)"},"project":{"id":3643,"key":3643,"name":"\u6280\u672f\u670d\u52a1-G"},"salesContract":{"id":3498,"key":3498,"name":"TS-WZW-2024082701","contractScans":[{"id":28292,"object_type":105,"object_id":3498,"attachment_id":21191,"attachment":{"id":21191,"key":21191,"name":"16da81bc-7d81-3d00-b648-2160f06aadac","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"2024_08_30_13_03_37.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1189,"erp_sales_order_id":1333,"erp_store_id":"","product_id":941,"description":"","number":"1","outbound":"0","amount":"1000","total_amount":"1000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1332,"serial_no":"XSDD-20250117-00001","from_date":"","wrote_date":"2024-08-26","handler":5295,"client_id":518,"purchase_contract_id":"","project_id":3642,"sales_contract_id":3497,"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":"2024-08-27 10:37:48","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"249","amount":"453573","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-27 10:37:48","updated_at":"2024-08-27 10:37:48","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"}},"handlerPerson":{"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"}},"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d"},"salesContract":{"id":3497,"key":3497,"name":"TS-WZW-2024082601","contractScans":[{"id":32008,"object_type":105,"object_id":3497,"attachment_id":21149,"attachment":{"id":21149,"key":21149,"name":"ec0afd09-bf9d-33ea-9067-884c38edf944","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u53a6\u95e8\u6cc9\u7f51453573\u5143.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1180,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1529,"description":"","number":"240","outbound":"0","amount":"845","total_amount":"202800","last_number":"","last_amount":"","last_total_amount":"","cost":"355.95","total_cost":"85428.00","supplier_id":203,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1529,"name":"FCP-SUITE-CPU-Level1","product_type":7,"product_component":204,"product_brand":219,"product_serie":1319,"product_misc":"","product_qa":"","pn":"","description":"FCP-SUITE\u6388\u6743","created_by":1013,"created_at":"2024-03-26 16:14:31","updated_at":"2024-03-26 16:14:31","pinyin_shortcut":"FCPSUITECPULevel1","product_unit":3,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":204,"key":204,"name":"HPC\u8f6f\u4ef6"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1319,"key":1319,"name":"FCP-SUITE\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":240},{"id":1181,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1530,"description":"","number":"1","outbound":"0","amount":"19200","total_amount":"19200","last_number":"","last_amount":"","last_total_amount":"","cost":"16960","total_cost":"16960","supplier_id":203,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1530,"name":"FCP-Implementation-Level1","product_type":22,"product_component":205,"product_brand":219,"product_serie":1320,"product_misc":"","product_qa":"","pn":"","description":"\u901f\u77f3\u57fa\u7840\u90e8\u7f72\u5b89\u88c5\u670d\u52a1A","created_by":1013,"created_at":"2024-03-26 16:15:44","updated_at":"2024-03-26 16:15:44","pinyin_shortcut":"FCPImplementationLevel1","product_unit":7,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1320,"key":1320,"name":"\u901f\u77f3\u57fa\u7840\u90e8\u7f72\u5b89\u88c5\u670d\u52a1A"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1},{"id":1182,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1769,"description":"","number":"1","outbound":"0","amount":"37850","total_amount":"37850","last_number":"","last_amount":"","last_total_amount":"","cost":"34300","total_cost":"34300","supplier_id":632,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1769,"name":"NF5280M6","product_type":2,"product_component":2,"product_brand":24,"product_serie":1493,"product_misc":"","product_qa":"","pn":"","description":"NF5280M6 5318Y\uff0824C,165W,2.1GHz\uff09 *2 \/32G 3200 *8 \/1.92TSSD SATA *2\/\u53cc\u53e3\u4e07\u5146\u542b\u6a21\u5757*1\/PM8222 *1\/\u5de6\u7f6ePCIE\u6269\u5c55\u5361*1\/550W\u7535\u6e90 *2\t\t","created_by":1013,"created_at":"2024-08-28 17:26:35","updated_at":"2024-08-28 17:26:35","pinyin_shortcut":"NF5280M6","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":1493,"key":1493,"name":"NF5280M6\u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1183,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1662,"description":"","number":"1","outbound":"0","amount":"133848","total_amount":"133848","last_number":"","last_amount":"","last_total_amount":"","cost":"100000","total_cost":"100000","supplier_id":598,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1662,"name":"FAS2720","product_type":3,"product_component":14,"product_brand":6,"product_serie":1413,"product_misc":"","product_qa":"","pn":"","description":"FAS2720\u5b58\u50a8\uff0c\u53cc\u63a7\u5236\u5668\uff0c\u542b12\u5757*10T\u786c\u76d8\uff0c\u5305\u542b4\u4e2a10GB,4GE 16GB-FC","created_by":1013,"created_at":"2024-07-02 14:11:34","updated_at":"2024-07-02 14:11:34","pinyin_shortcut":"FAS2720","product_unit":2,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1413,"key":1413,"name":"NETAPP FAS2720\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1184,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1104,"description":"","number":"1","outbound":"0","amount":"3450","total_amount":"3450","last_number":"","last_amount":"","last_total_amount":"","cost":"2700","total_cost":"2700","supplier_id":632,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"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"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1},{"id":1185,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1724,"description":"","number":"1","outbound":"0","amount":"37000","total_amount":"37000","last_number":"","last_amount":"","last_total_amount":"","cost":"31000","total_cost":"31000","supplier_id":106,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1724,"name":"CN3360B","product_type":4,"product_component":19,"product_brand":20,"product_serie":1459,"product_misc":"","product_qa":"","pn":"","description":"SAN\u5b58\u50a8\u5149\u7ea4\u4ea4\u6362\u673a 24\u53e316GB\u300124\u53e3\u6fc0\u6d3b,\u6a21\u5757\u6ee1\u914d ","created_by":1013,"created_at":"2024-08-06 10:28:43","updated_at":"2024-08-06 10:28:43","pinyin_shortcut":"CN3360B","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1459,"key":1459,"name":"H3C CN3360B\u5149\u7ea4\u901a\u9053\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1186,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1771,"description":"","number":"1","outbound":"0","amount":"720","total_amount":"720","last_number":"","last_amount":"","last_total_amount":"","cost":"600","total_cost":"600","supplier_id":548,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1771,"name":"\u5b81\u7545\u4e07\u5146\u53cc\u53e3\u7f51\u5361-Intel 82599","product_type":2,"product_component":9,"product_brand":211,"product_serie":1496,"product_misc":"","product_qa":"","pn":"","description":"\u5b81\u7545\u670d\u52a1\u5668R840 G50\u7528\u4e07\u5146\u53cc\u53e3\u7f51\u5361","created_by":1013,"created_at":"2024-08-29 17:33:12","updated_at":"2024-08-29 17:33:12","pinyin_shortcut":"ncwzskwkIntel82599","product_unit":3,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":9,"key":9,"name":"\u670d\u52a1\u5668\u7f51\u5361"},"productBrand":{"id":211,"key":211,"name":"\u5b81\u7545"},"productSerie":{"id":1496,"key":1496,"name":"\u5b81\u7545\u4e07\u5146\u53cc\u53e3\u7f51\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1},{"id":1187,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1772,"description":"","number":"2","outbound":"0","amount":"6235","total_amount":"12470","last_number":"","last_amount":"","last_total_amount":"","cost":"5512","total_cost":"11024","supplier_id":203,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1772,"name":"FC\u9ad8\u7ea7\u90e8\u7f72\u4ea4\u4ed8\u670d\u52a1","product_type":22,"product_component":205,"product_brand":219,"product_serie":1497,"product_misc":"","product_qa":"","pn":"","description":"\u7f51\u7edc\u5b89\u5168\u63a5\u5165\/\u7528\u6237\u9a8c\u8bc1\/\u6570\u636e\u7ba1\u7406\/\u6570\u636e\u5b58\u50a8\/EDA Tools\/\u8bbe\u8ba1\u5e94\u7528\u5de5\u4f5c\u6d41\u7a0b\/\u8c03\u5ea6\u5668\/\u96c6\u7fa4license\/\u9879\u76ee\u7ba1\u7406","created_by":1013,"created_at":"2024-08-30 10:44:02","updated_at":"2024-08-30 10:44:02","pinyin_shortcut":"FCgjbsjffw","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1497,"key":1497,"name":"FC\u9ad8\u7ea7\u90e8\u7f72\u4ea4\u4ed8\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1188,"erp_sales_order_id":1332,"erp_store_id":"","product_id":1772,"description":"","number":"1","outbound":"0","amount":"6235","total_amount":"6235","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":203,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1772,"name":"FC\u9ad8\u7ea7\u90e8\u7f72\u4ea4\u4ed8\u670d\u52a1","product_type":22,"product_component":205,"product_brand":219,"product_serie":1497,"product_misc":"","product_qa":"","pn":"","description":"\u7f51\u7edc\u5b89\u5168\u63a5\u5165\/\u7528\u6237\u9a8c\u8bc1\/\u6570\u636e\u7ba1\u7406\/\u6570\u636e\u5b58\u50a8\/EDA Tools\/\u8bbe\u8ba1\u5e94\u7528\u5de5\u4f5c\u6d41\u7a0b\/\u8c03\u5ea6\u5668\/\u96c6\u7fa4license\/\u9879\u76ee\u7ba1\u7406","created_by":1013,"created_at":"2024-08-30 10:44:02","updated_at":"2024-08-30 10:44:02","pinyin_shortcut":"FCgjbsjffw","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1497,"key":1497,"name":"FC\u9ad8\u7ea7\u90e8\u7f72\u4ea4\u4ed8\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1331,"serial_no":"XSDD-20250305-00001","from_date":"","wrote_date":"2024-08-15","handler":5295,"client_id":3281,"purchase_contract_id":"","project_id":3641,"sales_contract_id":3496,"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":"2024-08-27 10:35:34","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"152959.6","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-27 10:35:34","updated_at":"2024-08-27 10:35:34","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"}},"handlerPerson":{"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"}},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"},"project":{"id":3641,"key":3641,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0\u65b0\u8d2d"},"salesContract":{"id":3496,"key":3496,"name":"TS-ZHY-2024081501","contractScans":[{"id":28375,"object_type":105,"object_id":3496,"attachment_id":21126,"attachment":{"id":21126,"key":21126,"name":"a7c9c25d-d017-3acf-8867-29e746993565","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u5bd2\u5e8f.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1179,"erp_sales_order_id":1331,"erp_store_id":"","product_id":1774,"description":"","number":"1","outbound":"0","amount":"152959.6","total_amount":"152959.6","last_number":"","last_amount":"","last_total_amount":"","cost":"119817.98","total_cost":"119817.98","supplier_id":583,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","product_type":22,"product_component":205,"product_brand":219,"product_serie":1500,"product_misc":"","product_qa":"","pn":"","description":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248\uff0cFastone Compute Cloud-Enterprise Edition (\u4ee5\u4e0b\u7b80\u79f0FCC-E)\u4e91\u670d\u52a1","created_by":1013,"created_at":"2024-09-02 15:13:25","updated_at":"2024-09-02 15:13:25","pinyin_shortcut":"ssjsyfwqyb","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1500,"key":1500,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1330,"serial_no":"XSDD-20240923-00001","from_date":"","wrote_date":"2024-08-19","handler":1004,"client_id":3299,"purchase_contract_id":"","project_id":3638,"sales_contract_id":3495,"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":"2024-08-27 09:19:50","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"9","amount":"36950","created_by":1004,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-27 09:19:50","updated_at":"2024-08-27 09:19:50","createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":3299,"key":3299,"name":"\u6c5f\u897f\u6a1f\u6f9c\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3638,"key":3638,"name":"\u534e\u4e3a\u65e0\u7ebfAP"},"salesContract":{"id":3495,"key":3495,"name":"TS-YJC-2024081901","contractScans":[{"id":28328,"object_type":105,"object_id":3495,"attachment_id":21129,"attachment":{"id":21129,"key":21129,"name":"04aad1e0-20fd-3e15-ad07-bc8babfc4b6d","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u6c5f\u897f.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1175,"erp_sales_order_id":1330,"erp_store_id":"","product_id":871,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":"","last_amount":"","last_total_amount":"","cost":"950","total_cost":"950","supplier_id":316,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":871,"name":"AirEngine9700S-S","product_type":4,"product_component":22,"product_brand":7,"product_serie":552,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-10-24 14:02:50","updated_at":"2024-02-01 16:50:37","pinyin_shortcut":"AirEngine9700SS","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":22,"key":22,"name":"\u65e0\u7ebf\u63a7\u5236\u5668"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":552,"key":552,"name":"\u534e\u4e3a AirEngine9700S-S\u65e0\u7ebf\u63a7\u5236\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1176,"erp_sales_order_id":1330,"erp_store_id":"","product_id":1761,"description":"","number":"1","outbound":"0","amount":"1150","total_amount":"1150","last_number":"","last_amount":"","last_total_amount":"","cost":"750","total_cost":"750","supplier_id":316,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1761,"name":"L-WAC-S-8AP","product_type":4,"product_component":22,"product_brand":7,"product_serie":1237,"product_misc":"","product_qa":"","pn":"","description":"\u65e0\u7ebf\u63a5\u5165\u63a7\u5236\u5668AP\u8d44\u6e90\u6388\u6743(8 AP)","created_by":1013,"created_at":"2024-08-27 09:26:37","updated_at":"2024-08-27 09:26:37","pinyin_shortcut":"LWACS8AP","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":22,"key":22,"name":"\u65e0\u7ebf\u63a7\u5236\u5668"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1237,"key":1237,"name":"\u534e\u4e3a\u65e0\u7ebf\u63a5\u5165\u63a7\u5236\u5668AP\u8d44\u6e90\u6388\u6743(8 AP)"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1177,"erp_sales_order_id":1330,"erp_store_id":"","product_id":1762,"description":"","number":"6","outbound":"0","amount":"2100","total_amount":"12600","last_number":"","last_amount":"","last_total_amount":"","cost":"1300","total_cost":"7800","supplier_id":316,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1762,"name":"AirEngine 6761S-21","product_type":4,"product_component":21,"product_brand":7,"product_serie":1490,"product_misc":"","product_qa":"","pn":"","description":"\u534e\u4e3aAirEngine 6761S-21\u65e0\u7ebfAP","created_by":1013,"created_at":"2024-08-27 09:28:33","updated_at":"2024-08-27 09:28:33","pinyin_shortcut":"AirEngine6761S21","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":21,"key":21,"name":"\u65e0\u7ebfAP"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1490,"key":1490,"name":"\u534e\u4e3aAirEngine 6761S-21\u65e0\u7ebfAP"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":6},{"id":1178,"erp_sales_order_id":1330,"erp_store_id":"","product_id":941,"description":"","number":"1","outbound":"0","amount":"22000","total_amount":"22000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1329,"serial_no":"XSDD-20241030-00001","from_date":"","wrote_date":"2024-08-19","handler":1001,"client_id":3296,"purchase_contract_id":"","project_id":3633,"sales_contract_id":3493,"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":"2024-08-26 15:44:32","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"20","amount":"5494736.8","created_by":1001,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-26 15:44:32","updated_at":"2024-08-26 15:44:32","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"client":{"id":3296,"key":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3633,"key":3633,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edf\u8f6f\u4ef6\u9879\u76ee\uff08\u8fc7\u5355\uff09"},"salesContract":{"id":3493,"key":3493,"name":"WG2024-406-OT1031","contractScans":[{"id":29422,"object_type":105,"object_id":3493,"attachment_id":21132,"attachment":{"id":21132,"key":21132,"name":"8ef8c575-a42c-3e21-ac0a-588e605a50ff","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u62d3\u5c14\u601d.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1173,"erp_sales_order_id":1329,"erp_store_id":"","product_id":1757,"description":"","number":"10","outbound":"0","amount":"208421.05","total_amount":"2084210.50","last_number":"","last_amount":"","last_total_amount":"","cost":"204252.63","total_cost":"2042526.30","supplier_id":90,"hardware_from":"","software_from":"2024-08-26","maintenance_from":"","hardware_to":"","software_to":"2029-08-26","maintenance_to":"","erpStore":{},"product":{"id":1757,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edfV1.0","product_type":7,"product_component":64,"product_brand":230,"product_serie":1486,"product_misc":"","product_qa":"","pn":"","description":"\u8fdc\u9274\u8bed\u97f3\u5408\u6210\u7cfb\u7edfV1.0","created_by":1013,"created_at":"2024-08-22 15:38:09","updated_at":"2024-08-22 15:38:09","pinyin_shortcut":"yyhcxtV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":64,"key":64,"name":"\u89c6\u9891\u76d1\u63a7\u5e73\u53f0\u8f6f\u4ef6"},"productBrand":{"id":230,"key":230,"name":"\u8fdc\u9274"},"productSerie":{"id":1486,"key":1486,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edfV1.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":10},{"id":1174,"erp_sales_order_id":1329,"erp_store_id":"","product_id":1758,"description":"","number":"10","outbound":"0","amount":"341052.63","total_amount":"3410526.30","last_number":"","last_amount":"","last_total_amount":"","cost":"334231.58","total_cost":"3342315.80","supplier_id":90,"hardware_from":"","software_from":"2024-08-26","maintenance_from":"","hardware_to":"","software_to":"2029-08-26","maintenance_to":"","erpStore":{},"product":{"id":1758,"name":"\u8bed\u79cd\u65e0\u5173\u5173\u952e\u8bcd\u68c0\u7d22\u7cfb\u7edfV1.0","product_type":7,"product_component":64,"product_brand":230,"product_serie":1487,"product_misc":"","product_qa":"","pn":"","description":"\u8fdc\u9274\u8bed\u79cd\u65e0\u5173\u5173\u952e\u8bcd\u68c0\u7d22\u7cfb\u7edfV1.0","created_by":1013,"created_at":"2024-08-22 15:38:44","updated_at":"2024-08-22 15:38:44","pinyin_shortcut":"yzwggjcjsxtV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":64,"key":64,"name":"\u89c6\u9891\u76d1\u63a7\u5e73\u53f0\u8f6f\u4ef6"},"productBrand":{"id":230,"key":230,"name":"\u8fdc\u9274"},"productSerie":{"id":1487,"key":1487,"name":"\u8bed\u79cd\u65e0\u5173\u5173\u952e\u8bcd\u68c0\u7d22\u7cfb\u7edfV1.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":10}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1328,"serial_no":"XSDD-20240919-00001","from_date":"","wrote_date":"2024-08-26","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3640,"sales_contract_id":3490,"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":"2024-08-26 13:23:36","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"299","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-26 13:23:36","updated_at":"2024-08-26 13:23:36","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3640,"key":3640,"name":"\u56fa\u6001\u786c\u76d81\u5757-G-2024-POBJ24084889-G-2024"},"salesContract":{"id":3490,"key":3490,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24084889","contractScans":[{"id":28729,"object_type":105,"object_id":3490,"attachment_id":21137,"attachment":{"id":21137,"key":21137,"name":"9d685c59-85c2-3dba-9f5f-ebee5f474507","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"POBJ24084889.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1172,"erp_sales_order_id":1328,"erp_store_id":"","product_id":1691,"description":"","number":"1","outbound":"0","amount":"299","total_amount":"299","last_number":"","last_amount":"","last_total_amount":"","cost":"142","total_cost":"142","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1327,"serial_no":"XSDD-20250114-00001","from_date":"","wrote_date":"2024-08-30","handler":1005,"client_id":89,"purchase_contract_id":"","project_id":3637,"sales_contract_id":3488,"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":"2024-08-23 10:43:18","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"2","amount":"227600","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-23 10:43:18","updated_at":"2024-08-23 10:43:18","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"},"project":{"id":3637,"key":3637,"name":"netapp\u5b58\u50a8\u6269\u5bb9"},"salesContract":{"id":3488,"key":3488,"name":"ZJ-JRKJ2024376","contractScans":[{"id":28666,"object_type":105,"object_id":3488,"attachment_id":21472,"attachment":{"id":21472,"key":21472,"name":"22134b58-8740-3669-9238-626b8b0f0c04","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"2024_09_12_10_44_26.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1170,"erp_sales_order_id":1327,"erp_store_id":"","product_id":1470,"description":"","number":"1","outbound":"0","amount":"101200","total_amount":"101200","last_number":"","last_amount":"","last_total_amount":"","cost":"85000","total_cost":"85000","supplier_id":598,"hardware_from":"2024-08-27","software_from":"","maintenance_from":"","hardware_to":"2025-08-27","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1470,"name":"DS224C(1.8T*24\u5757\u786c\u76d8)","product_type":3,"product_component":17,"product_brand":6,"product_serie":1248,"product_misc":"","product_qa":"","pn":"","description":"FAS2520\u6269\u5c55\u67dc+1.8T*24\u5757\u786c\u76d8 \u542b\u76f8\u5173IO\u6a21\u5757\u548c\u7ebf\u7f06\n\u5f53\u524d\u5b58\u50a8\u578b\u53f7\uff1aFAS2520 SO 610059700808367 \n1.8T\u786c\u76d8 \u73b0\u6709\u8bbe\u5907\u6269\u5bb9","created_by":1013,"created_at":"2024-02-29 16:49:00","updated_at":"2024-02-29 16:49:00","pinyin_shortcut":"DS224C18T24kyp","product_unit":2,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1248,"key":1248,"name":"Netapp DS224C\u6269\u5c55\u67dc\uff08FAS2520\u6269\u5c55\u67dc\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1171,"erp_sales_order_id":1327,"erp_store_id":"","product_id":1470,"description":"","number":"1","outbound":"0","amount":"126400","total_amount":"126400","last_number":"","last_amount":"","last_total_amount":"","cost":"85000","total_cost":"85000","supplier_id":598,"hardware_from":"2024-08-27","software_from":"","maintenance_from":"","hardware_to":"2025-08-27","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1470,"name":"DS224C(1.8T*24\u5757\u786c\u76d8)","product_type":3,"product_component":17,"product_brand":6,"product_serie":1248,"product_misc":"","product_qa":"","pn":"","description":"FAS2520\u6269\u5c55\u67dc+1.8T*24\u5757\u786c\u76d8 \u542b\u76f8\u5173IO\u6a21\u5757\u548c\u7ebf\u7f06\n\u5f53\u524d\u5b58\u50a8\u578b\u53f7\uff1aFAS2520 SO 610059700808367 \n1.8T\u786c\u76d8 \u73b0\u6709\u8bbe\u5907\u6269\u5bb9","created_by":1013,"created_at":"2024-02-29 16:49:00","updated_at":"2024-02-29 16:49:00","pinyin_shortcut":"DS224C18T24kyp","product_unit":2,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1248,"key":1248,"name":"Netapp DS224C\u6269\u5c55\u67dc\uff08FAS2520\u6269\u5c55\u67dc\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1326,"serial_no":"XSDD-20250114-00001","from_date":"","wrote_date":"2024-08-24","handler":1005,"client_id":89,"purchase_contract_id":"","project_id":3636,"sales_contract_id":3487,"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":"2024-08-23 10:34:29","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"4","amount":"375600","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-23 10:34:29","updated_at":"2024-08-23 10:34:29","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"},"project":{"id":3636,"key":3636,"name":"DMZ\u533a\u98de\u5854\u9632\u706b\u5899"},"salesContract":{"id":3487,"key":3487,"name":"ZJ-JRKJ2024371","contractScans":[{"id":28665,"object_type":105,"object_id":3487,"attachment_id":21471,"attachment":{"id":21471,"key":21471,"name":"50b2dbbe-cdfe-3f8d-88fb-13c3afcf1d52","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"2024_09_12_10_42_57.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1168,"erp_sales_order_id":1326,"erp_store_id":"","product_id":1759,"description":"\u91c7\u8d2d\u5408\u540c\u5408\u5e76\u4e00\u6761","number":"2","outbound":"0","amount":"187800","total_amount":"375600","last_number":"","last_amount":"","last_total_amount":"","cost":"52500","total_cost":"105000","supplier_id":610,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1759,"name":"FG-400F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1488,"product_misc":"","product_qa":"","pn":"","description":"18x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 8 x 10GE SFP+ slots, SPU NP7 and CP9 hardware accelerated, dual AC power supplies","created_by":1013,"created_at":"2024-08-23 17:37:13","updated_at":"2024-08-23 17:37:13","pinyin_shortcut":"FG400F","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1488,"key":1488,"name":"\u98de\u5854FG-400F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":2},{"id":1169,"erp_sales_order_id":1326,"erp_store_id":"","product_id":1760,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"71000","total_cost":"142000","supplier_id":610,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1760,"name":"FC-10-0400F-928-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1489,"product_misc":"","product_qa":"","pn":"","description":"3 years Advanced Threat Protection(IPS,Advanced Malware Protection Service, Application Control, and FortiCare Premium)","created_by":1013,"created_at":"2024-08-23 17:38:43","updated_at":"2024-08-23 17:38:43","pinyin_shortcut":"FC100400F9280236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1489,"key":1489,"name":"FG-400F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1325,"serial_no":"XSDD-20250114-00001","from_date":"","wrote_date":"2024-08-14","handler":1005,"client_id":89,"purchase_contract_id":"","project_id":3635,"sales_contract_id":3486,"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":"2024-08-23 10:28:15","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"247","amount":"276000","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-23 10:28:15","updated_at":"2024-08-23 10:28:15","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"},"project":{"id":3635,"key":3635,"name":"\u65b0\u5efaDMZ\u533a\u79c1\u6709\u4e91"},"salesContract":{"id":3486,"key":3486,"name":"ZJ-JRKJ2024336","contractScans":[{"id":32045,"object_type":105,"object_id":3486,"attachment_id":21469,"attachment":{"id":21469,"key":21469,"name":"42a9c749-f21a-34a1-b22a-7b1caaee69a2","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"2024_09_12_10_45_47.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1165,"erp_sales_order_id":1325,"erp_store_id":"","product_id":965,"description":"","number":"6","outbound":"0","amount":"10000","total_amount":"60000","last_number":"","last_amount":"","last_total_amount":"","cost":"5480","total_cost":"32880","supplier_id":67,"hardware_from":"","software_from":"2024-09-02","maintenance_from":"","hardware_to":"","software_to":"2025-09-01","maintenance_to":"","erpStore":{},"product":{"id":965,"name":"ZStack Cloud \u4e91\u5e73\u53f0 V4.0 \u4f01\u4e1a\u7248(\u6c38\u4e45\u8bb8\u53ef)","product_type":7,"product_component":53,"product_brand":138,"product_serie":1262,"product_misc":"","product_qa":"","pn":"","description":"ZStack Cloud \u4e91\u5e73\u53f0\u4f01\u4e1a\u7248:1\u3001 \u914d\u7f6e\u670d\u52a1\u5668\u865a\u62df\u5316:\u5c06\u7269\u7406\u670d\u52a1\u5668 CPU\u3001\u5185\u5b58\u7b49\u8fdb\u884c\u865a\u62df\u5316\u6c60\u5316,\u4e3a\u4e0a \u5c42\u5e94\u7528\u5f39\u6027\u8ba1\u7b97\u8d44\u6e90\u670d\u52a1,\u652f\u6301\u4e1a \u5185\u6240\u6709\u4e3b\u6d41 X86 \u670d\u52a1\u5668\u578b\u53f7,\u652f\u6301 \u7ba1\u7406\u8282\u70b9\u9ad8\u53ef\u7528\u548c\u865a\u62df\u673a\u9ad8\u53ef\u7528\u3001 \u4e91\u4e3b\u673a\u5feb\u7167\u7b49\u5168\u90e8\u529f\u80fd;2\u3001\u914d\u7f6e\u5b58 \u50a8\u865a\u62df\u5316\u5bf9\u63a5\u6a21\u5757:\u652f\u6301\u5bf9\u63a5\u7ba1\u7406 \u591a\u79cd\u5b58\u50a8\u7c7b\u578b,\u5305\u62ec\u672c\u5730\u5b58\u50a8\u3001\u96c6 \u4e2d\u5b58\u50a8(NFS\/iSCSI\/FC)\u3001\u5206\u5e03\u5f0f \u5b58\u50a8\u7b49,\u4e3a\u4e91\u4e3b\u673a\u63d0\u4f9b\u5757\u5b58\u50a8\u670d \u52a1;3\u3001\u914d\u7f6e\u4e91\u76d8\u7ba1\u7406\u529f\u80fd:\u652f\u6301\u4e91\u76d8 QoS \u529f\u80fd,\u652f\u6301\u5171\u4eab\u4e91\u76d8\u529f\u80fd, \u652f\u6301\u5728\u7ebf\u4e91\u76d8\u6269\u5bb9\u529f\u80fd,\u652f\u6301\u4e91\u76d8 \u5feb\u7167\u3001\u514b\u9686\u3001\u521b\u5efa\u955c\u50cf\u529f\u80fd;4\u3001\u914d \u7f6e\u9ad8\u7ea7\u7f51\u7edc\u865a\u62df\u5316\u8f6f\u4ef6\u6a21\u5757:\u652f\u6301 \u5206\u5e03\u5f0f\u6241\u5e73\u7f51\u7edc\u6a21\u578b,\u63d0\u4f9b\u5206\u5e03\u5f0f DHCP \u670d\u52a1,\u6d88\u9664\u7f51\u7edc\u6027\u80fd\u74f6\u9888\u53ca\u5355 \u70b9\u6545\u969c,\u652f\u6301 VPC \u7f51\u7edc\u6a21\u578b,\u652f\u6301 SR-IOV\u3001\u667a\u80fd\u7f51\u5361\u7b49\u9ad8\u6027\u80fd\u7f51\u5361\u529f \u80fd,\u63d0\u4f9b\u4e0d\u53d7\u6570\u91cf\u9650\u5236\u7684\u5f39\u6027 IP\u3001 \u865a\u62df\u8def\u7531\u5668\u3001\u865a\u62df\u9632\u706b\u5899\u3001\u865a\u62df\u5b89 \u5168\u7ec4\u3001\u865a\u62df\u8d1f\u8f7d\u5747\u8861,\u652f\u6301 OSPF \u52a8 \u6001\u8def\u7531\u534f\u8bae\u3001SNAT \u7f51\u7edc\u670d\u52a1\u3001\u7ec4\u64ad \u8def\u7531\u3001\u7aef\u53e3\u8f6c\u53d1\u3001NetFlow \u7b49\u9ad8\u7ea7 \u7f51\u7edc\u529f\u80fd;\u652f\u6301\u4e8c\u5c42\u7f51\u7edc\u9694\u79bb\u529f \u80fd:\u652f\u6301 noVLAN\u3001VLAN\u3001Vxlan,\u652f \u6301\u7f51\u7edc\u4e1c\u897f\u5411\u3001\u5357\u5317\u5411 QoS \u529f\u80fd; \u652f\u6301\u786c\u4ef6 Vxlan \u5bf9\u63a5\u6dfb\u52a0 SDN \u63a7\u5236 \u5668,\u652f\u6301\u914d\u7f6e\u57fa\u4e8e TCP\/UDP \u7aef\u53e3\u7684 \u4e09\u5c42\u5b89\u5168\u7b56\u7565\u9694\u79bb;5\u3001\u914d\u7f6e\u4e91\u5e73\u53f0 \u4f01\u4e1a\u7ea7\u529f\u80fd\u6a21\u5757:\u652f\u6301\u6240\u6709\u4e3b\u6d41 GPU \u8bbe\u5907\u900f\u4f20\u548c\u865a\u62df\u5316\u529f\u80fd;\u652f\u6301 \u4e91\u4e3b\u673a\u5f39\u6027\u4f38\u7f29\u7ba1\u7406\u529f\u80fd;\u652f\u6301\u5927 \u5c4f\u76d1\u63a7\u529f\u80fd;\u652f\u6301\u8ba1\u91cf\u8ba1\u8d39\u529f\u80fd; \u652f\u6301 VDI \u534f\u8bae;6\u3001\u914d\u7f6e\u5e73\u53f0\u76d1\u63a7\u7ba1 \u7406\u6a21\u5757,\u63d0\u4f9b\u7269\u7406\u673a\u3001\u865a\u62df\u673a\u8d44\u6e90 \u8fd0\u884c\u72b6\u6001\u53ca\u5173\u952e\u6307\u6807(\u5982 CPU\u3001\u5185 \u5b58\u3001\u7f51\u5361\u3001\u78c1\u76d8\u7b49\u8d44\u6e90)\u7528\u91cf\u5c55\u793a \u548c\u53d1\u5e03\u529f\u80fd\u3002;","created_by":1013,"created_at":"2023-08-04 15:34:05","updated_at":"2024-03-22 17:15:10","pinyin_shortcut":"ZStackCloudyptV40qybyjxk","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":53,"key":53,"name":"\u4e91\u5e73\u53f0\u7ba1\u7406\u8f6f\u4ef6"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":1262,"key":1262,"name":"ZStack Cloud \u4e91\u5e73\u53f0 V4.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":6},{"id":1166,"erp_sales_order_id":1325,"erp_store_id":"","product_id":968,"description":"","number":"240","outbound":"0","amount":"900","total_amount":"216000","last_number":"","last_amount":"","last_total_amount":"","cost":"430","total_cost":"103200","supplier_id":67,"hardware_from":"","software_from":"2024-09-02","maintenance_from":"","hardware_to":"","software_to":"2025-09-01","maintenance_to":"","erpStore":{},"product":{"id":968,"name":"ZStack \u5206\u5e03\u5f0f\u5b58\u50a8V3.0 \u65d7\u8230\u7248","product_type":7,"product_component":65,"product_brand":138,"product_serie":606,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-04 15:41:52","updated_at":"2024-03-06 13:59:26","pinyin_shortcut":"ZStackfbsccV30qjb","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":65,"key":65,"name":"\u5206\u5e03\u5f0f\u5b58\u50a8\u8f6f\u4ef6"},"productBrand":{"id":138,"key":138,"name":"ZStack"},"productSerie":{"id":606,"key":606,"name":"ZStack \u5206\u5e03\u5f0f\u5b58\u50a8V3.0 \u65d7\u8230\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":240},{"id":1167,"erp_sales_order_id":1325,"erp_store_id":"","product_id":942,"description":"\u82d1\u6587\u6ce2\u8d39\u7528\u5904\u7406","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"63360.00","total_cost":"63360","supplier_id":680,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1324,"serial_no":"XSDD-20241118-00001","from_date":"","wrote_date":"2024-07-25","handler":5295,"client_id":2805,"purchase_contract_id":"","project_id":3632,"sales_contract_id":3484,"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":"2024-08-21 16:26:18","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"129","amount":"60893.32","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-21 16:26:18","updated_at":"2024-08-21 16:26:18","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"}},"handlerPerson":{"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"}},"client":{"id":2805,"key":2805,"name":"\u5317\u4eac\u65e0\u95ee\u82af\u7a79\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09(EDA)"},"project":{"id":3632,"key":3632,"name":"\uff08\u8fc7\u5355\uff09\u901f\u77f3\u4ea7\u54c1\u65b0\u8d2d-c"},"salesContract":{"id":3484,"key":3484,"name":"FS-\u5ba2\u6237\u540d-20240725","contractScans":[{"id":28998,"object_type":105,"object_id":3484,"attachment_id":21089,"attachment":{"id":21089,"key":21089,"name":"efcc7f59-341d-3bbd-8503-f3f70a4e649d","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u65e0\u95ee\u82af\u7a79.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1163,"erp_sales_order_id":1324,"erp_store_id":"","product_id":1529,"description":"","number":"128","outbound":"0","amount":"438.46","total_amount":"56122.88","last_number":"","last_amount":"","last_total_amount":"","cost":"394.59","total_cost":"50507.52","supplier_id":203,"hardware_from":"","software_from":"2024-07-30","maintenance_from":"","hardware_to":"","software_to":"2025-07-30","maintenance_to":"","erpStore":{},"product":{"id":1529,"name":"FCP-SUITE-CPU-Level1","product_type":7,"product_component":204,"product_brand":219,"product_serie":1319,"product_misc":"","product_qa":"","pn":"","description":"FCP-SUITE\u6388\u6743","created_by":1013,"created_at":"2024-03-26 16:14:31","updated_at":"2024-03-26 16:14:31","pinyin_shortcut":"FCPSUITECPULevel1","product_unit":3,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":204,"key":204,"name":"HPC\u8f6f\u4ef6"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1319,"key":1319,"name":"FCP-SUITE\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":128},{"id":1164,"erp_sales_order_id":1324,"erp_store_id":"","product_id":1530,"description":"","number":"1","outbound":"0","amount":"4770.44","total_amount":"4770.44","last_number":"","last_amount":"","last_total_amount":"","cost":"4293.77","total_cost":"4293.77","supplier_id":203,"hardware_from":"","software_from":"2024-07-30","maintenance_from":"","hardware_to":"","software_to":"2025-07-30","maintenance_to":"","erpStore":{},"product":{"id":1530,"name":"FCP-Implementation-Level1","product_type":22,"product_component":205,"product_brand":219,"product_serie":1320,"product_misc":"","product_qa":"","pn":"","description":"\u901f\u77f3\u57fa\u7840\u90e8\u7f72\u5b89\u88c5\u670d\u52a1A","created_by":1013,"created_at":"2024-03-26 16:15:44","updated_at":"2024-03-26 16:15:44","pinyin_shortcut":"FCPImplementationLevel1","product_unit":7,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1320,"key":1320,"name":"\u901f\u77f3\u57fa\u7840\u90e8\u7f72\u5b89\u88c5\u670d\u52a1A"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"erpInventoryCount":""},"un_outbound":1}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1323,"serial_no":"XSDD-20241226-00001","from_date":"","wrote_date":"2024-08-17","handler":1005,"client_id":89,"purchase_contract_id":"","project_id":3631,"sales_contract_id":3482,"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":"2024-08-20 22:30:57","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"20","amount":"10000","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-20 22:30:57","updated_at":"2024-08-20 22:30:57","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"},"project":{"id":3631,"key":3631,"name":"\u601d\u79d1\u6a21\u5757\u91c7\u8d2d"},"salesContract":{"id":3482,"key":3482,"name":"ZJ-JRKJ2024347","contractScans":[{"id":28664,"object_type":105,"object_id":3482,"attachment_id":21470,"attachment":{"id":21470,"key":21470,"name":"b26130d6-301c-3ba8-a63e-cd2d6256359b","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/","orig_name":"2024_09_12_10_45_15.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1162,"erp_sales_order_id":1323,"erp_store_id":"","product_id":229,"description":"","number":"20","outbound":"0","amount":"500","total_amount":"10000","last_number":"","last_amount":"","last_total_amount":"","cost":"220","total_cost":"4400","supplier_id":435,"hardware_from":"2024-08-20","software_from":"","maintenance_from":"","hardware_to":"2025-08-20","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":229,"name":"SFP-10G-SR=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1058,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-07-01 12:25:14","updated_at":"2024-01-30 16:00:59","pinyin_shortcut":"SFP10GSR","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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1058,"key":1058,"name":"\u601d\u79d1SFP-10G-SR\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":20}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":1322,"serial_no":"XSDD-20250506-00001","from_date":"","wrote_date":"2024-08-05","handler":1004,"client_id":2091,"purchase_contract_id":"","project_id":3609,"sales_contract_id":3477,"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":"2024-08-19 15:22:42","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"8","amount":"300000","created_by":1004,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-08-19 15:22:42","updated_at":"2024-08-19 15:22:42","createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8"},"project":{"id":3609,"key":3609,"name":"\u601d\u79d1N9K\u7b49\u7eed\u4fdd\u9879\u76ee"},"salesContract":{"id":3477,"key":3477,"name":"\u601d\u8054\u79d1\u8baf\u7b7e\u7ea6YJC-2024080501","contractScans":[{"id":33961,"object_type":105,"object_id":3477,"attachment_id":21076,"attachment":{"id":21076,"key":21076,"name":"25e56b7d-d5c3-3be6-b466-ef987c16949f","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/08\/","orig_name":"\u795e\u5dde\u6570\u78012024.8.5.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1159,"erp_sales_order_id":1322,"erp_store_id":"","product_id":1307,"description":"","number":"2","outbound":"0","amount":"120000","total_amount":"240000","last_number":"","last_amount":"","last_total_amount":"","cost":"64638","total_cost":"129276","supplier_id":90,"hardware_from":"2024-06-09","software_from":"","maintenance_from":"","hardware_to":"2025-06-08","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1307,"name":"CON-SNT-N9504B1","product_type":4,"product_component":47,"product_brand":3,"product_serie":985,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-23 17:17:51","updated_at":"2024-01-23 17:17:51","pinyin_shortcut":"CONSNTN9504B1","product_unit":8,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":985,"key":985,"name":"\u601d\u79d1N9K-C9504-B1\u4ea4\u6362\u673a\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"erpInventoryCount":""},"un_outbound":2},{"id":1160,"erp_sales_order_id":1322,"erp_store_id":"","product_id":1755,"description":"","number":"2","outbound":"0","amount":"4000","total_amount":"8000","last_number":"","last_amount":"","last_total_amount":"","cost":"2599","total_cost":"5198","supplier_id":90,"hardware_from":"2024-12-26","software_from":"","maintenance_from":"","hardware_to":"2025-12-25","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1755,"name":"CON-SNT-UCSC48S","product_type":4,"product_component":47,"product_brand":3,"product_serie":1484,"product_misc":"","product_qa":"","pn":"","description":"UCS-EP-MDS9148S-1 SNTC 8X5XNBD","created_by":1013,"created_at":"2024-08-21 14:15:51","updated_at":"2024-08-21 14:15:51","pinyin_shortcut":"CONSNTUCSC48S","product_unit":2,"is_renew":true,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1484,"key":1484,"name":"\u601d\u79d1MDS9148S\u4ea4\u6362\u673a\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1161,"erp_sales_order_id":1322,"erp_store_id":"","product_id":1756,"description":"","number":"4","outbound":"0","amount":"13000","total_amount":"52000","last_number":"","last_amount":"","last_total_amount":"","cost":"7724","total_cost":"30896","supplier_id":90,"hardware_from":"2024-06-06","software_from":"","maintenance_from":"","hardware_to":"2025-06-05","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1756,"name":"CON-SNT-3172TQXL","product_type":4,"product_component":47,"product_brand":3,"product_serie":1485,"product_misc":"","product_qa":"","pn":"","description":"N3K-C3172TQ-XL SNTC 8X5XNBD\u4e00\u5e74","created_by":1013,"created_at":"2024-08-21 14:18:41","updated_at":"2024-08-21 14:18:41","pinyin_shortcut":"CONSNT3172TQXL","product_unit":2,"is_renew":true,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1485,"key":1485,"name":"\u601d\u79d1N3K-C3172TQ-XL\u8def\u7531\u5668\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":4}],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":false,"can_cancel_done":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true}],"can_create":true,"pagenation":{"totalcount":1561,"thispage":12,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-12 16:22:25') RETURNING "id"
16:22:25.8642.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:22:25.8932.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21089, 21132, 21191, 21129, 21192, 21126, 21397, 21470, 21471, 21472, 21299, 21300, 21217, 21216, 21137, 21182, 21184, 21183, 21297, 21149, 21469, 21308, 21076)
16:22:25.8902.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3490, 3484, 3482, 3487, 3488, 3486, 3498, 3497, 3507, 3502, 3495, 3520, 3521, 3522, 3512, 3477, 3514, 3504, 3493, 3496))
16:22:25.8622.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:22:25.8971.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322))
16:22:25.8991.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322))
16:22:25.8681.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:22:25.9010.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)
16:22:25.9060.9 msyii\db\Command::querySELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (965, 1529, 1530, 1690, 1691, 1662, 1668, 942, 941, 1724, 1755, 1757, 1756, 1758, 1759, 1760, 1761, 1762, 1763, 1766, 1769, 1767, 1770, 1771, 1772, 1773, 1774, 1764, 229, 196, 861, 871, 968, 1104, 1303, 1307, 1470) GROUP BY "product_id"
16:22:25.8860.8 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
16:22:25.9020.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1307, 1755, 1756, 229, 1529, 1530, 965, 968, 942, 1759, 1760, 1470, 1691, 1757, 1758, 871, 1761, 1762, 941, 1774, 1769, 1662, 1104, 1724, 1771, 1772, 196, 1303, 1763, 1764, 1766, 1668, 1767, 1690, 1770, 1773, 861)
16:22:25.8880.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2526, 12, 57, 97, 2553, 1301, 518, 3281, 3299, 3296, 89, 2805, 2091)
16:22:25.8890.6 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3651, 3650, 3649, 3540, 3647, 3646, 3645, 3644, 3643, 3642, 3641, 3638, 3633, 3640, 3637, 3636, 3635, 3632, 3631, 3609)
16:22:25.8730.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id"
16:22:25.9090.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)
16:22:25.8900.5 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3522, 3521, 3520, 3514, 3512, 3507, 3504, 3502, 3498, 3497, 3496, 3495, 3493, 3490, 3488, 3487, 3486, 3484, 3482, 3477)
16:22:25.9050.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1262, 1319, 1320, 1438, 1439, 1413, 1419, 593, 592, 1459, 1484, 1486, 1485, 1487, 1488, 1489, 1237, 1490, 975, 1493, 1494, 1495, 1496, 1497, 1498, 1500, 1058, 165, 842, 552, 606, 666, 804, 985, 1248)
16:22:25.8870.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
16:22:25.9040.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (53, 204, 205, 179, 14, 43, 151, 19, 47, 64, 26, 35, 22, 21, 36, 2, 15, 9, 60, 65, 39, 17)
16:22:25.8850.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 5300, 1005, 1001, 5295, 1004)
16:22:25.9030.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 22, 11, 3, 4, 19, 5, 2)
16:22:25.9070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322) ORDER BY "id"
16:22:25.9040.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (138, 219, 10, 43, 6, 8, 134, 133, 20, 3, 230, 40, 7, 24, 9, 211, 39)
16:22:25.8950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)
16:22:25.9090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322) ORDER BY "id"
16:22:25.9060.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 3, 7, 6, 1, 4, 8)
16:22:25.8870.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 5300, 1005, 1001, 5295, 1004)
16:22:25.8960.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322) ORDER BY "id"
16:22:25.8970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) ORDER BY "id"
16:22:25.9100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) ORDER BY "id"
16:22:25.8960.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) ORDER BY "id"
16:22:25.8880.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
16:22:25.9100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) ORDER BY "id"
16:22:25.9080.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) ORDER BY "id"
16:22:25.9080.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322)) ORDER BY "id"
16:22:25.8970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322))
16:22:25.9080.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322))
16:22:25.9100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_order_id" IN (1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322))
16:22:25.8880.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)