Performance Profiling

Total processing time: 97 ms; Peak memory: 7.079 MB. Show Profiling Timeline

总计44条数据

Time	Duration	Category	Info

16:22:17.960	19.7 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20007) AND ("object_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) GROUP BY "object_id"
16:22:17.980	17.3 ms	yii\db\Command::query	SELECT "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 (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) GROUP BY "object_id"
16:22:17.929	5.5 ms	yii\db\Command::query	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 LIMIT 20 OFFSET 140
16:22:17.925	4.4 ms	yii\db\Command::query	SELECT 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:18.002	3.7 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-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":"8","web_access_token":"Hc6bcOPECvJmn-MxoPjAzgccBe0xyT-M"}', '{"code":2000,"result":{"list":[{"id":1421,"serial_no":"XSDD-20250516-00001","from_date":"","wrote_date":"2024-12-24","handler":1005,"client_id":149,"purchase_contract_id":"","project_id":3720,"sales_contract_id":3736,"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-12-30 13:59:19","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"36","amount":"905150","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-30 13:59:19","updated_at":"2024-12-30 13:59: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":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"salesContract":{"id":3736,"key":3736,"name":"FZ-2024-145-SC-007","contractScans":[{"id":34524,"object_type":105,"object_id":3736,"attachment_id":23487,"attachment":{"id":23487,"key":23487,"name":"25e09143-24cd-3f30-9cfd-9f71748a479a","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240-\u62d3\u5b9e.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1471,"erp_sales_order_id":1421,"erp_store_id":"","product_id":950,"description":"","number":"1","outbound":"0","amount":"905150.00","total_amount":"905150","last_number":"","last_amount":"","last_total_amount":"","cost":"617500.00","total_cost":"617500","supplier_id":516,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":950,"name":"\u4e8c\u4ee3\u8bc1\u751f\u4ea7\u81ea\u52a8\u5316\u8bbe\u5907","product_type":18,"product_component":152,"product_brand":136,"product_serie":596,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:25:49","updated_at":"2023-08-11 16:01:35","pinyin_shortcut":"edzsczdhsb","product_unit":5,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":152,"key":152,"name":"\u751f\u4ea7\u8f66\u95f4\u8bbe\u5907"},"productBrand":{"id":136,"key":136,"name":"\u665f\u6e90"},"productSerie":{"id":596,"key":596,"name":"\u81ea\u52a8\u5316\u8f66\u95f4\u751f\u4ea7\u8bbe\u5907"},"productUnit":{"id":5,"key":5,"name":"\u6279"},"erpInventoryCount":""},"un_outbound":1},{"id":1472,"erp_sales_order_id":1421,"erp_store_id":"","product_id":1943,"description":"","number":"15","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"15.00","total_cost":"225","supplier_id":478,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1943,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 5M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:21","updated_at":"2025-02-26 15:20:21","pinyin_shortcut":"cllwx5M","product_unit":6,"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":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"erpInventoryCount":""},"un_outbound":15},{"id":1473,"erp_sales_order_id":1421,"erp_store_id":"","product_id":1944,"description":"","number":"10","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"25.00","total_cost":"250","supplier_id":478,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1944,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 10M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:50","updated_at":"2025-02-26 15:20:50","pinyin_shortcut":"cllwx10M","product_unit":6,"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":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"erpInventoryCount":""},"un_outbound":10},{"id":1474,"erp_sales_order_id":1421,"erp_store_id":"","product_id":1945,"description":"","number":"10","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"35.00","total_cost":"350","supplier_id":478,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1945,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 15M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:21:14","updated_at":"2025-02-26 15:21:14","pinyin_shortcut":"cllwx15M","product_unit":"","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":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":"","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":1420,"serial_no":"XSDD-20250519-00001","from_date":"","wrote_date":"2024-12-16","handler":1005,"client_id":2548,"purchase_contract_id":"","project_id":3750,"sales_contract_id":3735,"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-12-30 13:53:11","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"774255","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-30 13:53:11","updated_at":"2024-12-30 13:53:11","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":2548,"key":2548,"name":"\u5317\u4eac\u6da6\u7fd4\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3750,"key":3750,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"salesContract":{"id":3735,"key":3735,"name":"TS-ZHY-2024121601","contractScans":[{"id":32058,"object_type":105,"object_id":3735,"attachment_id":23918,"attachment":{"id":23918,"key":23918,"name":"84aebe73-4dea-3d9c-9230-4295966cfbcd","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/01\/","orig_name":"2025_01_23_11_02_45.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1470,"erp_sales_order_id":1420,"erp_store_id":"","product_id":950,"description":"","number":"1","outbound":"0","amount":"774255.00","total_amount":"774255","last_number":"","last_amount":"","last_total_amount":"","cost":"617500.00","total_cost":"617500","supplier_id":516,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":950,"name":"\u4e8c\u4ee3\u8bc1\u751f\u4ea7\u81ea\u52a8\u5316\u8bbe\u5907","product_type":18,"product_component":152,"product_brand":136,"product_serie":596,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:25:49","updated_at":"2023-08-11 16:01:35","pinyin_shortcut":"edzsczdhsb","product_unit":5,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":152,"key":152,"name":"\u751f\u4ea7\u8f66\u95f4\u8bbe\u5907"},"productBrand":{"id":136,"key":136,"name":"\u665f\u6e90"},"productSerie":{"id":596,"key":596,"name":"\u81ea\u52a8\u5316\u8f66\u95f4\u751f\u4ea7\u8bbe\u5907"},"productUnit":{"id":5,"key":5,"name":"\u6279"},"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":1419,"serial_no":"XSDD-20250210-00001","from_date":"","wrote_date":"2024-12-30","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3756,"sales_contract_id":3734,"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-12-30 11:48:34","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-12-30 11:48:34","updated_at":"2024-12-30 11:48: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":3756,"key":3756,"name":"POBJ24127011-\u56fa\u6001\u786c\u76d8-G-2024"},"salesContract":{"id":3734,"key":3734,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24127011","contractScans":[{"id":31727,"object_type":105,"object_id":3734,"attachment_id":23454,"attachment":{"id":23454,"key":23454,"name":"a3ce1761-5b2e-38f7-9ef4-d15e1de83a59","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"POBJ24127011.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1469,"erp_sales_order_id":1419,"erp_store_id":"","product_id":1691,"description":"","number":"1","outbound":"0","amount":"299.00","total_amount":"299","last_number":"","last_amount":"","last_total_amount":"","cost":"142.00","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":1418,"serial_no":"XSDD-20250122-00001","from_date":"","wrote_date":"2024-12-27","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3719,"sales_contract_id":3733,"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-12-27 14:25:08","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"39900","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-27 14:25:08","updated_at":"2024-12-27 14:25:08","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":3719,"key":3719,"name":"\u601d\u79d1\u786c\u4ef6\u7ef4\u4fdd1\u5e74-K-2024"},"salesContract":{"id":3733,"key":3733,"name":"SMC\u5317\u4eac\u8ba2\u5355TS-SQY-2024122301","contractScans":[{"id":32719,"object_type":105,"object_id":3733,"attachment_id":23435,"attachment":{"id":23435,"key":23435,"name":"d6f0f3c2-8753-32b9-82a4-691e598aaf98","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"SMC.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1468,"erp_sales_order_id":1418,"erp_store_id":"","product_id":941,"description":"","number":"1","outbound":"0","amount":"39900.00","total_amount":"39900","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2024-10-01","hardware_to":"","software_to":"","maintenance_to":"2025-09-30","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":1417,"serial_no":"XSDD-20241231-00001","from_date":"","wrote_date":"2024-12-24","handler":5300,"client_id":141,"purchase_contract_id":"","project_id":3739,"sales_contract_id":3732,"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-12-27 14:20:51","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"8","amount":"167000","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-27 14:20:51","updated_at":"2024-12-27 14:20:51","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":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8"},"project":{"id":3739,"key":3739,"name":"\u601d\u79d1\u9632\u706b\u589911402+11201\u65b0\u8d2d-K-2024"},"salesContract":{"id":3732,"key":3732,"name":"TS-SQY-2024122402","contractScans":[{"id":31507,"object_type":105,"object_id":3732,"attachment_id":23420,"attachment":{"id":23420,"key":23420,"name":"759c10b9-9087-3408-8efe-baa757db57e2","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"167000.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1463,"erp_sales_order_id":1417,"erp_store_id":"","product_id":1917,"description":"","number":"2","outbound":"0","amount":"35300.00","total_amount":"70600","last_number":"","last_amount":"","last_total_amount":"","cost":"36308.00","total_cost":"72616","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1917,"name":"FPR1140-NGFW-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:01:27","updated_at":"2024-12-30 17:01:27","pinyin_shortcut":"FPR1140NGFWK9","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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":2},{"id":1464,"erp_sales_order_id":1417,"erp_store_id":"","product_id":1918,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"4000.00","total_cost":"8000","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1918,"name":"CON-SNT-FR11P40N","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":"","product_qa":"","pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1140 NGFW Appliance, 1U","created_by":1013,"created_at":"2024-12-30 17:03:18","updated_at":"2024-12-30 17:03:18","pinyin_shortcut":"CONSNTFR11P40N","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1465,"erp_sales_order_id":1417,"erp_store_id":"","product_id":1919,"description":"","number":"2","outbound":"0","amount":"26700.00","total_amount":"53400","last_number":"","last_amount":"","last_total_amount":"","cost":"21700.00","total_cost":"43400","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1919,"name":"L-FPR1140T-TMC-1Y","product_type":5,"product_component":35,"product_brand":3,"product_serie":1589,"product_misc":"","product_qa":"","pn":"","description":"Cisco FPR1140 Threat Defense Threat, Malware and URL 1Y Subs","created_by":1013,"created_at":"2024-12-30 17:09:46","updated_at":"2024-12-30 17:09:46","pinyin_shortcut":"LFPR1140TTMC1Y","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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1589,"key":1589,"name":"Cisco Firepower 1000 \u7cfb\u5217\u9632\u706b\u5899\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1466,"erp_sales_order_id":1417,"erp_store_id":"","product_id":1920,"description":"","number":"1","outbound":"0","amount":"39690.00","total_amount":"39690","last_number":"","last_amount":"","last_total_amount":"","cost":"22000.00","total_cost":"22000","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1920,"name":"FPR1120-ASA-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:11:17","updated_at":"2024-12-30 17:11:17","pinyin_shortcut":"FPR1120ASAK9","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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1467,"erp_sales_order_id":1417,"erp_store_id":"","product_id":1921,"description":"","number":"1","outbound":"0","amount":"3310.00","total_amount":"3310","last_number":"","last_amount":"","last_total_amount":"","cost":"3310.00","total_cost":"3310","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1921,"name":"CON-SNT-FPR1120A","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":"","product_qa":"","pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1120 ASA Appliance","created_by":1013,"created_at":"2024-12-30 17:12:26","updated_at":"2024-12-30 17:12:26","pinyin_shortcut":"CONSNTFPR1120A","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\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":1416,"serial_no":"XSDD-20241231-00001","from_date":"","wrote_date":"2024-12-24","handler":5300,"client_id":141,"purchase_contract_id":"","project_id":3692,"sales_contract_id":3731,"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-12-27 14:17:13","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"9","amount":"186000","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-27 14:17:13","updated_at":"2024-12-27 14:17:13","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":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8"},"project":{"id":3692,"key":3692,"name":"\u601d\u79d1\u9632\u706b\u5899\u65b0\u8d2d11403\u65b0\u8d2d-K-2024"},"salesContract":{"id":3731,"key":3731,"name":"TS-SQY-2024122401","contractScans":[{"id":31508,"object_type":105,"object_id":3731,"attachment_id":23419,"attachment":{"id":23419,"key":23419,"name":"f79c73cf-7481-3d32-95e0-87a3231dbf75","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"186000.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1460,"erp_sales_order_id":1416,"erp_store_id":"","product_id":1917,"description":"","number":"3","outbound":"0","amount":"35300.00","total_amount":"105900","last_number":"","last_amount":"","last_total_amount":"","cost":"36308.00","total_cost":"108924","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1917,"name":"FPR1140-NGFW-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:01:27","updated_at":"2024-12-30 17:01:27","pinyin_shortcut":"FPR1140NGFWK9","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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":3},{"id":1461,"erp_sales_order_id":1416,"erp_store_id":"","product_id":1918,"description":"\u4e00\u5e74\u670d\u52a1","number":"3","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"4000.00","total_cost":"12000","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1918,"name":"CON-SNT-FR11P40N","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":"","product_qa":"","pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1140 NGFW Appliance, 1U","created_by":1013,"created_at":"2024-12-30 17:03:18","updated_at":"2024-12-30 17:03:18","pinyin_shortcut":"CONSNTFR11P40N","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":3},{"id":1462,"erp_sales_order_id":1416,"erp_store_id":"","product_id":1919,"description":"","number":"3","outbound":"0","amount":"26700.00","total_amount":"80100","last_number":"","last_amount":"","last_total_amount":"","cost":"21700.00","total_cost":"65100","supplier_id":564,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1919,"name":"L-FPR1140T-TMC-1Y","product_type":5,"product_component":35,"product_brand":3,"product_serie":1589,"product_misc":"","product_qa":"","pn":"","description":"Cisco FPR1140 Threat Defense Threat, Malware and URL 1Y Subs","created_by":1013,"created_at":"2024-12-30 17:09:46","updated_at":"2024-12-30 17:09:46","pinyin_shortcut":"LFPR1140TTMC1Y","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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1589,"key":1589,"name":"Cisco Firepower 1000 \u7cfb\u5217\u9632\u706b\u5899\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"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":1415,"serial_no":"XSDD-20250210-00001","from_date":"","wrote_date":"2024-12-26","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3753,"sales_contract_id":3729,"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-12-26 16:53:58","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-12-26 16:53:58","updated_at":"2024-12-26 16:53:58","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":3753,"key":3753,"name":"POBJ24126437-\u56fa\u6001\u786c\u76d8-G-2024"},"salesContract":{"id":3729,"key":3729,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24126437","contractScans":[{"id":31505,"object_type":105,"object_id":3729,"attachment_id":23404,"attachment":{"id":23404,"key":23404,"name":"204a6dce-cfec-3ff6-92c4-7c4dd7a810d5","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"POBJ24126437.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1459,"erp_sales_order_id":1415,"erp_store_id":"","product_id":1691,"description":"","number":"1","outbound":"0","amount":"299.00","total_amount":"299","last_number":"","last_amount":"","last_total_amount":"","cost":"142.00","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":1414,"serial_no":"XSDD-20250121-00001","from_date":"","wrote_date":"2024-12-25","handler":1001,"client_id":2553,"purchase_contract_id":"","project_id":3752,"sales_contract_id":3725,"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-12-25 14:21:20","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"12","amount":"87000","created_by":1001,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-25 14:21:20","updated_at":"2024-12-25 14:21:20","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":3752,"key":3752,"name":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee"},"salesContract":{"id":3725,"key":3725,"name":"W-KJ-CG-HS-20241224-01","contractScans":[{"id":32997,"object_type":105,"object_id":3725,"attachment_id":23438,"attachment":{"id":23438,"key":23438,"name":"e2ea8e53-408a-3bef-a7d2-ac4388921701","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u91c7\u8d2d\u5408\u540c--\u5357\u975e\u7ea2\u77f3DCS\u9632\u706b\u5899.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1456,"erp_sales_order_id":1414,"erp_store_id":"","product_id":1910,"description":"","number":"4","outbound":"0","amount":"7250.00","total_amount":"29000","last_number":"","last_amount":"","last_total_amount":"","cost":"4300.50","total_cost":"17202","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1910,"name":"PAN-PA-440-ATP-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Advanced Threat Prevention subscription, for one (1) device in an HA pair, 1 year (12 months), term.","created_by":1013,"created_at":"2024-12-25 14:53:44","updated_at":"2024-12-25 14:53:44","pinyin_shortcut":"PANPA440ATPHA2","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":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":4},{"id":1457,"erp_sales_order_id":1414,"erp_store_id":"","product_id":1911,"description":"","number":"4","outbound":"0","amount":"7250.00","total_amount":"29000","last_number":"","last_amount":"","last_total_amount":"","cost":"4300.50","total_cost":"17202","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1911,"name":"PAN-PA-440-ADVURL-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":"","product_qa":"","pn":"","description":"Advanced URL Filtering subscription, 1-year, PA-440 HA Pair","created_by":1013,"created_at":"2024-12-25 14:54:18","updated_at":"2024-12-25 14:54:18","pinyin_shortcut":"PANPA440ADVURLHA2","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":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":4},{"id":1458,"erp_sales_order_id":1414,"erp_store_id":"","product_id":1912,"description":"","number":"4","outbound":"0","amount":"7250.00","total_amount":"29000","last_number":"","last_amount":"","last_total_amount":"","cost":"4300.50","total_cost":"17202","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1912,"name":"PAN-PA-440-AWF-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Advanced WildFire subscription, for one (1) device in an HA pair, 1 year (12 months), term.","created_by":1013,"created_at":"2024-12-25 14:54:57","updated_at":"2024-12-25 14:54:57","pinyin_shortcut":"PANPA440AWFHA2","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":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"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},{"id":1413,"serial_no":"XSDD-20250312-00001","from_date":"","wrote_date":"2024-12-25","handler":1001,"client_id":3327,"purchase_contract_id":"","project_id":3744,"sales_contract_id":3724,"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-12-25 13:59:01","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"17","amount":"126009","created_by":1001,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-25 13:59:01","updated_at":"2024-12-25 13:59:01","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":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"salesContract":{"id":3724,"key":3724,"name":"TS-LRC-2024122501","contractScans":[{"id":32998,"object_type":105,"object_id":3724,"attachment_id":23436,"attachment":{"id":23436,"key":23436,"name":"e1868899-cb9d-3e5c-81ba-f1469cba78f6","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u4fe1\u8054.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1448,"erp_sales_order_id":1413,"erp_store_id":"","product_id":849,"description":"","number":"2","outbound":"0","amount":"12181.43","total_amount":"24362.86","last_number":"","last_amount":"","last_total_amount":"","cost":"6000.00","total_cost":"12000","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":849,"name":"PAN-PA-440","product_type":5,"product_component":26,"product_brand":8,"product_serie":801,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-440","created_by":1013,"created_at":"2022-07-25 15:54:45","updated_at":"2024-01-12 15:21:09","pinyin_shortcut":"PANPA440","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":801,"key":801,"name":"PA-440\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":2},{"id":1449,"erp_sales_order_id":1413,"erp_store_id":"","product_id":1471,"description":"","number":"2","outbound":"0","amount":"24278.57","total_amount":"48557.14","last_number":"","last_amount":"","last_total_amount":"","cost":"11000.00","total_cost":"22000","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1471,"name":"PAN-PA-440-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Core Security Subscription Bundle\n(Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 3 years (36 months)term","created_by":1013,"created_at":"2024-03-01 17:41:36","updated_at":"2024-03-01 17:41:52","pinyin_shortcut":"PANPA440BNDCORESEC3YR","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":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1450,"erp_sales_order_id":1413,"erp_store_id":"","product_id":1340,"description":"","number":"2","outbound":"0","amount":"1201.43","total_amount":"2402.86","last_number":"","last_amount":"","last_total_amount":"","cost":"850.00","total_cost":"1700","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1340,"name":"PAN-PWR-50W-AC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":"","product_qa":"","pn":"","description":"50W AC power adapter for PA-440 PA-450 and PA-460","created_by":1013,"created_at":"2024-01-25 09:26:04","updated_at":"2024-01-25 09:26:04","pinyin_shortcut":"PANPWR50WAC","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":2},{"id":1451,"erp_sales_order_id":1413,"erp_store_id":"","product_id":989,"description":"","number":"1","outbound":"0","amount":"1221.00","total_amount":"1221","last_number":"","last_amount":"","last_total_amount":"","cost":"1294.00","total_cost":"1294","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":989,"name":"PAN-PA-400-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":"","product_qa":"","pn":"","description":"Rack mountable tray for up to two PA-400s and 4 power adapters for a 4 post rack mount (PA-440\/450\/460 models only)","created_by":1013,"created_at":"2023-08-09 16:14:38","updated_at":"2024-01-12 15:11:56","pinyin_shortcut":"PANPA400RACKTRAY","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1452,"erp_sales_order_id":1413,"erp_store_id":"","product_id":1353,"description":"","number":"2","outbound":"0","amount":"9008.57","total_amount":"18017.14","last_number":"","last_amount":"","last_total_amount":"","cost":"4400.00","total_cost":"8800","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1353,"name":"PAN-PA-440-BND-CORESEC","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Core Security Subscription Renewal Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 1 years (12 months) term","created_by":1013,"created_at":"2024-01-26 11:18:43","updated_at":"2024-12-17 17:12:20","pinyin_shortcut":"PANPA440BNDCORESEC","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":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1453,"erp_sales_order_id":1413,"erp_store_id":"","product_id":1902,"description":"","number":"2","outbound":"0","amount":"3350.00","total_amount":"6700","last_number":"","last_amount":"","last_total_amount":"","cost":"2500.00","total_cost":"5000","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1902,"name":"PAN-SVC-PREM-440","product_type":5,"product_component":35,"product_brand":8,"product_serie":618,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Premium support, 1 year (12 months), term.","created_by":1013,"created_at":"2024-12-17 17:15:24","updated_at":"2024-12-17 17:15:24","pinyin_shortcut":"PANSVCPREM440","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":618,"key":618,"name":"PA440\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1454,"erp_sales_order_id":1413,"erp_store_id":"","product_id":1903,"description":"","number":"2","outbound":"0","amount":"10050.00","total_amount":"20100","last_number":"","last_amount":"","last_total_amount":"","cost":"6500.00","total_cost":"13000","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1903,"name":"PAN-SVC-PREM-440-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":784,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Premium support, 3 years (36 months), term.","created_by":1013,"created_at":"2024-12-17 17:16:11","updated_at":"2024-12-17 17:16:11","pinyin_shortcut":"PANSVCPREM4403YR","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":784,"key":784,"name":"PA440\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1455,"erp_sales_order_id":1413,"erp_store_id":"","product_id":1904,"description":"","number":"4","outbound":"0","amount":"1162.00","total_amount":"4648","last_number":"","last_amount":"","last_total_amount":"","cost":"950.00","total_cost":"3800","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1904,"name":"PAN-PA-400-ACC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1583,"product_misc":"","product_qa":"","pn":"","description":"Replacement accessory kit for PA-440, PA-450 and PA-460. This kit is included in the system.","created_by":1013,"created_at":"2024-12-17 17:18:18","updated_at":"2024-12-25 13:55:41","pinyin_shortcut":"PANPA400ACC","product_unit":6,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1583,"key":1583,"name":"PA-440\/450\/460\u7535\u6e90\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"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},{"id":1412,"serial_no":"XSDD-20241227-00001","from_date":"","wrote_date":"2024-12-13","handler":5295,"client_id":498,"purchase_contract_id":"","project_id":3598,"sales_contract_id":3714,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u7535\u5b50\u5408\u540c\uff0c\u901a\u8fc7\u5951\u7ea6\u9501\u7b7e\u7ea6\u3002","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2024-12-17 11:20:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"6","amount":"208024","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-17 11:20:23","updated_at":"2024-12-17 11:20:23","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":498,"key":498,"name":"\u7231\u6155\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"project":{"id":3598,"key":3598,"name":"2024\u5e74PA\u9632\u706b\u5899\u7eed\u4fdd-C"},"salesContract":{"id":3714,"key":3714,"name":"TS-WZW-2024121301","contractScans":[{"id":32532,"object_type":105,"object_id":3714,"attachment_id":23254,"attachment":{"id":23254,"key":23254,"name":"9505c5ed-fc7a-34ba-b38d-2b907be7f057","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"PA\u9632\u706b\u5899\u7ef4\u4fdd\u5408\u540c.pdf"}},{"id":32533,"object_type":105,"object_id":3714,"attachment_id":23255,"attachment":{"id":23255,"key":23255,"name":"ace0435f-5dfc-307a-93c6-997bfe77cc85","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u9644\u4ef65-\u6388\u6743\u59d4\u6258\u4e66\u6a21\u677f - \u5408\u540c.docx(1).pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1445,"erp_sales_order_id":1412,"erp_store_id":"","product_id":1794,"description":"","number":"2","outbound":"0","amount":"31500.00","total_amount":"63000","last_number":"","last_amount":"","last_total_amount":"","cost":"26508.00","total_cost":"53016","supplier_id":163,"hardware_from":"2024-09-11","software_from":"","maintenance_from":"","hardware_to":"2025-09-10","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1794,"name":"PAN-SVC-BKLN-3220-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":355,"product_misc":"","product_qa":"","pn":"","description":"Partner enabled premium support renewal, PA-3220","created_by":1013,"created_at":"2024-09-27 11:29:01","updated_at":"2024-09-27 11:29:01","pinyin_shortcut":"PANSVCBKLN3220R","product_unit":8,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":355,"key":355,"name":"PA3220\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"erpInventoryCount":""},"un_outbound":2},{"id":1446,"erp_sales_order_id":1412,"erp_store_id":"","product_id":1898,"description":"","number":"2","outbound":"0","amount":"38512.00","total_amount":"77024","last_number":"","last_amount":"","last_total_amount":"","cost":"37827.00","total_cost":"75654","supplier_id":163,"hardware_from":"","software_from":"2024-09-11","maintenance_from":"","hardware_to":"","software_to":"2025-09-10","maintenance_to":"","erpStore":{},"product":{"id":1898,"name":"PAN-PA-3220-AWF-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1001,"product_misc":"","product_qa":"","pn":"","description":"Advanced WildFire subscription for device in an HA pair renewal, PA-3220","created_by":1013,"created_at":"2024-12-17 13:54:26","updated_at":"2024-12-17 13:54:26","pinyin_shortcut":"PANPA3220AWFHA2R","product_unit":2,"is_renew":true,"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":1001,"key":1001,"name":"PA3220\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1447,"erp_sales_order_id":1412,"erp_store_id":"","product_id":1905,"description":"","number":"2","outbound":"0","amount":"34000.00","total_amount":"68000","last_number":"","last_amount":"","last_total_amount":"","cost":"25305.00","total_cost":"50610","supplier_id":163,"hardware_from":"","software_from":"2024-09-11","maintenance_from":"","hardware_to":"","software_to":"2025-09-10","maintenance_to":"","erpStore":{},"product":{"id":1905,"name":"PAN-PA-3220-TP-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1001,"product_misc":"","product_qa":"","pn":"","description":"hreat prevention subscription for device in an HA pair renewal,PA-3220","created_by":1013,"created_at":"2024-12-24 13:35:16","updated_at":"2024-12-24 13:35:16","pinyin_shortcut":"PANPA3220TPHA2R","product_unit":"","is_renew":true,"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":1001,"key":1001,"name":"PA3220\u8f6f\u4ef6\u6388\u6743"},"productUnit":"","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":1411,"serial_no":"XSDD-20250803-00001","from_date":"","wrote_date":"2024-12-17","handler":5087,"client_id":2526,"purchase_contract_id":"","project_id":3743,"sales_contract_id":3713,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"12-25\u65e5\u4fee\u6539\u91d1\u989d\uff1b\u589e\u52a0950+1350=2300\u5143","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2024-12-17 09:24:39","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"39","amount":"21870","created_by":5087,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-17 09:24:39","updated_at":"2024-12-17 09:24:39","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":3743,"key":3743,"name":"SATA512G\u56fa\u6001\u786c\u76d8 \u9879\u76ee-K"},"salesContract":{"id":3713,"key":3713,"name":"","contractScans":[]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1441,"erp_sales_order_id":1411,"erp_store_id":"","product_id":1899,"description":"","number":"2","outbound":"0","amount":"160.00","total_amount":"320","last_number":"","last_amount":"","last_total_amount":"","cost":"160.00","total_cost":"320","supplier_id":478,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1899,"name":"netLINK HTB-4100A\/4GE-3KM+HTB-4100B-3KM","product_type":4,"product_component":43,"product_brand":245,"product_serie":1581,"product_misc":"","product_qa":"","pn":"","description":"netLINK HTB-4100A\/4GE-3KM+HTB-4100B-3KM\u5149\u7ea4\u6536\u53d1\u5668\u5343\u5146\u5355\u6a21\u5355\u7ea41\u51494\u7535+1\u51491\u7535\u5957\u88c5\u5149\u7535\u8f6c\u6362\u56683\u516c\u91cc\u4e00\u5bf9","created_by":1013,"created_at":"2024-12-17 13:57:50","updated_at":"2024-12-17 13:57:50","pinyin_shortcut":"netLINKHTB4100A4GE3KMHTB4100B3KM","product_unit":2,"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":245,"key":245,"name":"netLINK"},"productSerie":{"id":1581,"key":1581,"name":"\u5149\u7ea4\u6536\u53d1\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1442,"erp_sales_order_id":1411,"erp_store_id":"","product_id":1900,"description":"","number":"35","outbound":"0","amount":"550.00","total_amount":"19250","last_number":"","last_amount":"","last_total_amount":"","cost":"270","total_cost":"9450.00","supplier_id":505,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1900,"name":"\u9ea6\u5149Msata 1.3\u5bf8 512GB\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":246,"product_serie":1582,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-17 14:29:52","updated_at":"2024-12-17 14:29:52","pinyin_shortcut":"mgMsata13c512GBgtyp","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":246,"key":246,"name":"\u9ea6\u5149"},"productSerie":{"id":1582,"key":1582,"name":"\u9ea6\u5149Msata 1.3\u5bf8\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":""},"un_outbound":35},{"id":1443,"erp_sales_order_id":1411,"erp_store_id":"","product_id":1908,"description":"","number":"1","outbound":"0","amount":"1350.00","total_amount":"1350","last_number":"","last_amount":"","last_total_amount":"","cost":"450.00","total_cost":"450","supplier_id":59,"hardware_from":"2024-12-25","software_from":"","maintenance_from":"","hardware_to":"2025-12-24","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1908,"name":"605474-001","product_type":2,"product_component":5,"product_brand":2,"product_serie":1584,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-25 10:39:00","updated_at":"2024-12-25 10:39:00","pinyin_shortcut":"605474001","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1584,"key":1584,"name":"1TB 7.2K 3.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"erpInventoryCount":""},"un_outbound":1},{"id":1444,"erp_sales_order_id":1411,"erp_store_id":"","product_id":1909,"description":"","number":"1","outbound":"0","amount":"950.00","total_amount":"950","last_number":"","last_amount":"","last_total_amount":"","cost":"150.00","total_cost":"150","supplier_id":59,"hardware_from":"2024-12-25","software_from":"","maintenance_from":"","hardware_to":"2025-12-24","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1909,"name":"507284-001","product_type":2,"product_component":5,"product_brand":2,"product_serie":889,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-25 10:40:01","updated_at":"2024-12-25 10:40:01","pinyin_shortcut":"507284001","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":889,"key":889,"name":"300G 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"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":1410,"serial_no":"XSDD-20250210-00001","from_date":"","wrote_date":"2024-12-16","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3742,"sales_contract_id":3711,"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-12-16 17:22:26","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 17:22:26","updated_at":"2024-12-16 17:22:26","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":3742,"key":3742,"name":"POBJ24123906-\u5185\u5b58\u6761-G-2024"},"salesContract":{"id":3711,"key":3711,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24123906","contractScans":[{"id":31228,"object_type":105,"object_id":3711,"attachment_id":23239,"attachment":{"id":23239,"key":23239,"name":"5cb2edcd-8eb8-35a3-aa1a-e347df0b7d3e","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"POBJ24123906.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1440,"erp_sales_order_id":1410,"erp_store_id":"","product_id":1690,"description":"","number":"1","outbound":"0","amount":"295","total_amount":"295.00","last_number":"","last_amount":"","last_total_amount":"","cost":"194.00","total_cost":"194","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}],"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":1409,"serial_no":"XSDD-20250210-00001","from_date":"","wrote_date":"2024-12-16","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3741,"sales_contract_id":3710,"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-12-16 17:20:57","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 17:20:57","updated_at":"2024-12-16 17:20:57","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":3741,"key":3741,"name":"POBJ24122976-\u5185\u5b58\u6761-G-2024"},"salesContract":{"id":3710,"key":3710,"name":"SMC\u5317\u4eac\u8ba2\u5355POBJ24122976","contractScans":[{"id":31229,"object_type":105,"object_id":3710,"attachment_id":23240,"attachment":{"id":23240,"key":23240,"name":"e69f7898-b51b-3f4b-b615-36f886ca964c","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"POBJ24122976.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1439,"erp_sales_order_id":1409,"erp_store_id":"","product_id":1690,"description":"","number":"1","outbound":"0","amount":"295.00","total_amount":"295","last_number":"","last_amount":"","last_total_amount":"","cost":"194.00","total_cost":"194","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}],"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":1408,"serial_no":"XSDD-20241226-00001","from_date":"","wrote_date":"2024-12-16","handler":1004,"client_id":3303,"purchase_contract_id":"","project_id":3740,"sales_contract_id":3709,"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-12-16 16:18:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"1","amount":"42400","created_by":1004,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 16:18:23","updated_at":"2024-12-16 16:18:23","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":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3740,"key":3740,"name":"\u516c\u6709\u4e91\u8fc1\u79fb\u670d\u52a12"},"salesContract":{"id":3709,"key":3709,"name":"XSZY068700","contractScans":[{"id":31509,"object_type":105,"object_id":3709,"attachment_id":23323,"attachment":{"id":23323,"key":23323,"name":"e6ab9c16-dd44-3be7-ac49-9e2777bf2839","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u795e\u5dde.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1438,"erp_sales_order_id":1408,"erp_store_id":"","product_id":941,"description":"","number":"1","outbound":"0","amount":"42400.00","total_amount":"42400","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":1407,"serial_no":"XSDD-20250516-00001","from_date":"","wrote_date":"2024-11-29","handler":1005,"client_id":93,"purchase_contract_id":"","project_id":3699,"sales_contract_id":3705,"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-12-12 13:39:18","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"6","amount":"458000","created_by":1005,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-12 13:39:18","updated_at":"2024-12-12 13:39: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":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854"},"salesContract":{"id":3705,"key":3705,"name":"C202411290020","contractScans":[{"id":31512,"object_type":105,"object_id":3705,"attachment_id":23140,"attachment":{"id":23140,"key":23140,"name":"221be467-2e34-378b-a893-1dc8bbcc49c3","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1434,"erp_sales_order_id":1407,"erp_store_id":"","product_id":1625,"description":"","number":"2","outbound":"0","amount":"72983.00","total_amount":"145966","last_number":"","last_amount":"","last_total_amount":"","cost":"62866.00","total_cost":"125732","supplier_id":614,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1625,"name":"FG-401F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1383,"product_misc":"","product_qa":"","pn":"","description":"FG-401F 18 x 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, 960GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:02:22","updated_at":"2024-05-31 16:02:22","pinyin_shortcut":"FG401F","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":1383,"key":1383,"name":"FG-401F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":2},{"id":1435,"erp_sales_order_id":1407,"erp_store_id":"","product_id":1626,"description":"","number":"2","outbound":"0","amount":"153265.00","total_amount":"306530","last_number":"","last_amount":"","last_total_amount":"","cost":"131830.00","total_cost":"263660","supplier_id":614,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1626,"name":"FC-10-0401F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1384,"product_misc":"","product_qa":"","pn":"","description":"FG-401F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:04:08","updated_at":"2024-05-31 16:04:08","pinyin_shortcut":"FC100401F9500236","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":1384,"key":1384,"name":"FG-401F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":2},{"id":1436,"erp_sales_order_id":1407,"erp_store_id":"","product_id":941,"description":"","number":"1","outbound":"0","amount":"5504.00","total_amount":"5504","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},{"id":1437,"erp_sales_order_id":1407,"erp_store_id":"","product_id":942,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"31000.00","total_cost":"31000","supplier_id":534,"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":1406,"serial_no":"XSDD-20250224-00001","from_date":"","wrote_date":"2024-12-11","handler":1001,"client_id":3304,"purchase_contract_id":"","project_id":3723,"sales_contract_id":3703,"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-12-11 10:33:14","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"3","amount":"319460.45","created_by":1001,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-11 10:33:14","updated_at":"2024-12-11 10:33:14","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":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"salesContract":{"id":3703,"key":3703,"name":"TS-LRC-20241211001","contractScans":[{"id":32995,"object_type":105,"object_id":3703,"attachment_id":23131,"attachment":{"id":23131,"key":23131,"name":"b8de52a8-dac7-3039-9f15-cb2e96646d45","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"2024_12_12_09_19_57.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1431,"erp_sales_order_id":1406,"erp_store_id":"","product_id":1895,"description":"","number":"1","outbound":"0","amount":"142435.17","total_amount":"142435.17","last_number":"","last_amount":"","last_total_amount":"","cost":"100000.00","total_cost":"100000","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1895,"name":"PAN-M-300","product_type":5,"product_component":26,"product_brand":8,"product_serie":1579,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks M-300, 16TB RAID storage (4 8TB RAID certified drives preinstalled). Rack mount rails included.","created_by":1013,"created_at":"2024-12-11 10:53:38","updated_at":"2024-12-11 10:53:38","pinyin_shortcut":"PANM300","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":1579,"key":1579,"name":"PAN-M-300\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1432,"erp_sales_order_id":1406,"erp_store_id":"","product_id":1896,"description":"","number":"1","outbound":"0","amount":"40695.76","total_amount":"40695.76","last_number":"","last_amount":"","last_total_amount":"","cost":"41807.00","total_cost":"41807","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1896,"name":"PAN-M-300-P-25","product_type":5,"product_component":36,"product_brand":8,"product_serie":1580,"product_misc":"","product_qa":"","pn":"","description":"Panorama central management software license, 25 devices or log collector for the M-300","created_by":1013,"created_at":"2024-12-11 10:55:06","updated_at":"2024-12-11 10:55:06","pinyin_shortcut":"PANM300P25","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":1580,"key":1580,"name":"PAN-M-300\u8f6f\u4ef6\u6388\u6743\u8bb8\u53ef"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1433,"erp_sales_order_id":1406,"erp_store_id":"","product_id":1897,"description":"","number":"1","outbound":"0","amount":"136329.52","total_amount":"136329.52","last_number":"","last_amount":"","last_total_amount":"","cost":"150000.00","total_cost":"150000","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1897,"name":"PAN-SVC-BKLN-M-300-P-25-3Y","product_type":5,"product_component":36,"product_brand":8,"product_serie":1580,"product_misc":"","product_qa":"","pn":"","description":"Partner enabled premium support 3-year term, Panorama M-300 25 devices or log collector 36\u4e2a\u6708\u8ba2\u9605\u5f0f","created_by":1013,"created_at":"2024-12-11 10:55:48","updated_at":"2024-12-11 10:55:48","pinyin_shortcut":"PANSVCBKLNM300P253Y","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":1580,"key":1580,"name":"PAN-M-300\u8f6f\u4ef6\u6388\u6743\u8bb8\u53ef"},"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":1405,"serial_no":"XSDD-20250107-00001","from_date":"","wrote_date":"2024-12-10","handler":5295,"client_id":42,"purchase_contract_id":"","project_id":3738,"sales_contract_id":3701,"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-12-10 16:13:41","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"2","amount":"1400","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-10 16:13:41","updated_at":"2024-12-10 16:13:41","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":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8"},"project":{"id":3738,"key":3738,"name":"\u65b0\u8d2d2\u5757\u5b58\u50a8\u786c\u76d8-2"},"salesContract":{"id":3701,"key":3701,"name":"TS-WZW-2024121001","contractScans":[{"id":31071,"object_type":105,"object_id":3701,"attachment_id":23128,"attachment":{"id":23128,"key":23128,"name":"fee692c5-f353-3100-b702-e96575f1c192","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1430,"erp_sales_order_id":1405,"erp_store_id":"","product_id":276,"description":"","number":"2","outbound":"0","amount":"700.00","total_amount":"1400","last_number":"","last_amount":"","last_total_amount":"","cost":"197.50","total_cost":"395","supplier_id":608,"hardware_from":"2024-12-11","software_from":"","maintenance_from":"","hardware_to":"2025-03-10","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":276,"name":"49Y1860","product_type":3,"product_component":15,"product_brand":4,"product_serie":1125,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-09-12 18:57:28","updated_at":"2024-02-01 10:55:25","pinyin_shortcut":"49Y1860","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":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1125,"key":1125,"name":"\u8054\u60f3300G 15K 3.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"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":1404,"serial_no":"XSDD-20241216-00001","from_date":"","wrote_date":"2024-12-09","handler":5295,"client_id":518,"purchase_contract_id":"","project_id":3737,"sales_contract_id":3699,"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-12-10 11:49:44","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"3","amount":"25920","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-10 11:49:44","updated_at":"2024-12-10 11:49:44","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":3737,"key":3737,"name":"2024\u65b0\u8d2d\u6df1\u4fe1\u670d\u9632\u706b\u5899"},"salesContract":{"id":3699,"key":3699,"name":"TS-WZW-20240901","contractScans":[{"id":31634,"object_type":105,"object_id":3699,"attachment_id":23114,"attachment":{"id":23114,"key":23114,"name":"e1ac3fa1-5b59-3ec9-b863-4ab106c0c22c","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u56fd\u79d1\u73af\u5b87.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1427,"erp_sales_order_id":1404,"erp_store_id":"","product_id":1892,"description":"","number":"1","outbound":"0","amount":"25920.00","total_amount":"25920","last_number":"","last_amount":"","last_total_amount":"","cost":"2659.00","total_cost":"2659","supplier_id":236,"hardware_from":"2024-12-12","software_from":"","maintenance_from":"","hardware_to":"2025-12-11","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1892,"name":"AF-1000-FH2100B","product_type":5,"product_component":26,"product_brand":12,"product_serie":1033,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:35:46","updated_at":"2024-12-10 13:35:46","pinyin_shortcut":"AF1000FH2100B","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1033,"key":1033,"name":"\u6df1\u4fe1\u670d AF-1000\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"erpInventoryCount":""},"un_outbound":1},{"id":1428,"erp_sales_order_id":1404,"erp_store_id":"","product_id":1893,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"12876.46","total_cost":"12876.46","supplier_id":236,"hardware_from":"","software_from":"2024-12-12","maintenance_from":"","hardware_to":"","software_to":"2025-12-11","maintenance_to":"","erpStore":{},"product":{"id":1893,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2100B\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:37:56","updated_at":"2024-12-10 13:37:56","pinyin_shortcut":"sxffhqrjV80syyAF1000FH2100B","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1429,"erp_sales_order_id":1404,"erp_store_id":"","product_id":1894,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"1553.54","total_cost":"1553.54","supplier_id":236,"hardware_from":"","software_from":"2024-12-12","maintenance_from":"","hardware_to":"","software_to":"2025-12-11","maintenance_to":"","erpStore":{},"product":{"id":1894,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2100B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:39:38","updated_at":"2024-12-10 13:39:38","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH2100B","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"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":1403,"serial_no":"XSDD-20250211-00001","from_date":"","wrote_date":"2024-10-30","handler":1001,"client_id":3326,"purchase_contract_id":"","project_id":3736,"sales_contract_id":3697,"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-12-09 11:00:56","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"6","amount":"293040","created_by":1001,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-09 11:00:56","updated_at":"2024-12-09 11:00:56","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":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"project":{"id":3736,"key":3736,"name":"\u897f\u660c\u7f51\u5173\u9879\u76ee-K"},"salesContract":{"id":3697,"key":3697,"name":"TS-LW-2024103001","contractScans":[{"id":31269,"object_type":105,"object_id":3697,"attachment_id":23348,"attachment":{"id":23348,"key":23348,"name":"337ab547-e4be-3748-9c0e-20868bda757d","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"2024_12_23_14_15_33.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1426,"erp_sales_order_id":1403,"erp_store_id":"","product_id":1875,"description":"\u5382\u5546\u63d0\u4f9b\u4e0a\u95e8\u670d\u52a1","number":"6","outbound":"0","amount":"48840.00","total_amount":"293040","last_number":"","last_amount":"","last_total_amount":"","cost":"32000.00","total_cost":"192000","supplier_id":662,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1875,"name":"Leadsec-IoTVBox-2RG","product_type":4,"product_component":213,"product_brand":243,"product_serie":1569,"product_misc":"","product_qa":"","pn":"","description":"3\u5e74724\u5c0f\u65f6\u73b0\u573a\u670d\u52a1","created_by":1013,"created_at":"2024-11-14 11:25:09","updated_at":"2024-11-14 11:26:34","pinyin_shortcut":"LeadsecIoTVBox2RG","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":213,"key":213,"name":"\u7269\u8054\u7f51\u5b89\u5168"},"productBrand":{"id":243,"key":243,"name":"\u7f51\u5fa1"},"productSerie":{"id":1569,"key":1569,"name":"\u7f51\u5fa1\u7269\u8054\u7f51\u5b89\u5168\u63a5\u5165\u9632\u62a4\u7cfb\u7edf V3.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":6}],"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":1402,"serial_no":"XSDD-20241216-00001","from_date":"","wrote_date":"2024-11-29","handler":5295,"client_id":90,"purchase_contract_id":"","project_id":3731,"sales_contract_id":3696,"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-12-06 10:29:06","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":true,"number":"25","amount":"229600","created_by":5295,"stop_description":"","extra":"","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-06 10:29:06","updated_at":"2024-12-06 10:29:06","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":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd"},"salesContract":{"id":3696,"key":3696,"name":"TS-WZW-2024112901","contractScans":[{"id":31527,"object_type":105,"object_id":3696,"attachment_id":23080,"attachment":{"id":23080,"key":23080,"name":"66ed48f1-eb01-3824-b927-c13490953ee7","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/12\/","orig_name":"\u82cf\u9ece\u4e16.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[{"id":1415,"erp_sales_order_id":1402,"erp_store_id":"","product_id":1511,"description":"","number":"1","outbound":"0","amount":"31800.00","total_amount":"31800","last_number":"","last_amount":"","last_total_amount":"","cost":"10008.00","total_cost":"10008","supplier_id":659,"hardware_from":"","software_from":"2024-12-22","maintenance_from":"","hardware_to":"","software_to":"2026-01-20","maintenance_to":"","erpStore":{},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":"","product_qa":"","pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1416,"erp_sales_order_id":1402,"erp_store_id":"","product_id":1511,"description":"","number":"3","outbound":"0","amount":"31800.00","total_amount":"95400","last_number":"","last_amount":"","last_total_amount":"","cost":"10008.00","total_cost":"30024","supplier_id":659,"hardware_from":"","software_from":"2025-01-21","maintenance_from":"","hardware_to":"","software_to":"2026-01-20","maintenance_to":"","erpStore":{},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":"","product_qa":"","pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":3},{"id":1417,"erp_sales_order_id":1402,"erp_store_id":"","product_id":1890,"description":"","number":"1","outbound":"0","amount":"31800.00","total_amount":"31800","last_number":"","last_amount":"","last_total_amount":"","cost":"11167.00","total_cost":"11167","supplier_id":659,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1890,"name":"V-FDNVUL-0I-SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":61,"product_misc":"","product_qa":"","pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support.","created_by":1013,"created_at":"2024-12-10 11:30:30","updated_at":"2024-12-10 11:30:30","pinyin_shortcut":"VFDNVUL0ISU1YP00","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":61,"key":61,"name":"Veeam \u865a\u62df\u5316\u5907\u4efd"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"erpInventoryCount":""},"un_outbound":1},{"id":1418,"erp_sales_order_id":1402,"erp_store_id":"","product_id":941,"description":"","number":"12","outbound":"0","amount":"1900.00","total_amount":"22800","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-01-01","hardware_to":"","software_to":"","maintenance_to":"2025-12-31","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":12},{"id":1419,"erp_sales_order_id":1402,"erp_store_id":"","product_id":941,"description":"Netapp E2724","number":"1","outbound":"0","amount":"11000.00","total_amount":"11000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-01-01","hardware_to":"","software_to":"","maintenance_to":"2025-12-31","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},{"id":1420,"erp_sales_order_id":1402,"erp_store_id":"","product_id":941,"description":"Netapp FAS2750","number":"1","outbound":"0","amount":"17000.00","total_amount":"17000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-01-01","hardware_to":"","software_to":"","maintenance_to":"2025-12-31","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},{"id":1421,"erp_sales_order_id":1402,"erp_store_id":"","product_id":941,"description":"Netapp FAS2650","number":"1","outbound":"0","amount":"14000.00","total_amount":"14000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-01-01","hardware_to":"","software_to":"","maintenance_to":"2025-12-31","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},{"id":1422,"erp_sales_order_id":1402,"erp_store_id":"","product_id":941,"description":"HPE DL388G9","number":"1","outbound":"0","amount":"2800.00","total_amount":"2800","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-01-01","hardware_to":"","software_to":"","maintenance_to":"2025-12-31","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},{"id":1423,"erp_sales_order_id":1402,"erp_store_id":"","product_id":941,"description":"\u601d\u79d19148S","number":"2","outbound":"0","amount":"1500.00","total_amount":"3000","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"2025-01-01","hardware_to":"","software_to":"","maintenance_to":"2025-12-31","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":2},{"id":1424,"erp_sales_order_id":1402,"erp_store_id":"","product_id":1891,"description":"FAS2650\u7ef4\u4fdd\u5907\u4ef6\u76d8","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"800.00","total_cost":"800","supplier_id":489,"hardware_from":"2024-12-03","software_from":"","maintenance_from":"","hardware_to":"2025-12-02","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1891,"name":"X426A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:33:21","updated_at":"2024-12-10 13:33:21","pinyin_shortcut":"X426AR6","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":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"erpInventoryCount":""},"un_outbound":1},{"id":1425,"erp_sales_order_id":1402,"erp_store_id":"","product_id":1891,"description":"FAS2750\u7ef4\u4fdd\u5907\u4ef6\u76d8","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":"","last_amount":"","last_total_amount":"","cost":"600.00","total_cost":"600","supplier_id":165,"hardware_from":"2025-02-13","software_from":"","maintenance_from":"","hardware_to":"2026-02-12","software_to":"","maintenance_to":"","erpStore":{},"product":{"id":1891,"name":"X426A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:33:21","updated_at":"2024-12-10 13:33:21","pinyin_shortcut":"X426AR6","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":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"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}],"can_create":true,"pagenation":{"totalcount":1561,"thispage":8,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-12 16:22:18') RETURNING "id"
16:22:17.915	2.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:22:17.941	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3696, 3701, 3697, 3710, 3711, 3729, 3699, 3703, 3733, 3713, 3709, 3724, 3734, 3714, 3725, 3731, 3736, 3705, 3732, 3735))
16:22:17.913	2.0 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:22:17.946	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402))
16:22:17.948	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402))
16:22:17.918	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:22:17.943	1.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23128, 23239, 23240, 23348, 23404, 23420, 23419, 23323, 23140, 23080, 23114, 23454, 23918, 23254, 23255, 23435, 23131, 23438, 23436, 23487)
16:22:17.955	0.9 ms	yii\db\Command::query	SELECT "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 (1511, 1625, 1626, 1690, 1691, 942, 941, 1794, 1875, 1890, 1891, 1892, 1893, 1894, 1895, 1896, 1898, 1899, 1900, 1897, 1353, 1902, 1903, 1905, 1908, 1909, 1910, 1911, 1917, 1918, 1919, 1920, 1921, 1904, 1912, 1943, 1944, 276, 849, 989, 950, 1340, 1945, 1471) GROUP BY "product_id"
16:22:17.950	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)
16:22:17.936	0.8 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
16:22:17.952	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1511, 1890, 941, 1891, 1875, 1892, 1893, 1894, 276, 1895, 1896, 1897, 1625, 1626, 942, 1690, 1899, 1900, 1908, 1909, 1794, 1898, 1905, 849, 1471, 1340, 989, 1353, 1902, 1903, 1904, 1910, 1911, 1912, 1691, 1917, 1918, 1919, 1920, 1921, 950, 1943, 1944, 1945)
16:22:17.939	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (149, 2548, 12, 141, 2553, 3327, 498, 2526, 3303, 93, 3304, 42, 518, 3326, 90)
16:22:17.939	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3720, 3750, 3756, 3719, 3739, 3692, 3753, 3752, 3744, 3598, 3743, 3742, 3741, 3740, 3699, 3723, 3738, 3737, 3736, 3731)
16:22:17.923	0.6 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id"
16:22:17.958	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)
16:22:17.954	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1240, 1383, 1384, 1438, 1439, 593, 592, 355, 1569, 61, 1149, 1033, 103, 743, 1579, 1580, 1001, 1581, 1582, 999, 618, 784, 1584, 889, 1587, 1588, 1589, 1583, 813, 1125, 801, 615, 596, 1012)
16:22:17.940	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3736, 3735, 3734, 3733, 3732, 3731, 3729, 3725, 3724, 3714, 3713, 3711, 3710, 3709, 3705, 3703, 3701, 3699, 3697, 3696)
16:22:17.937	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
16:22:17.953	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 5, 11, 19, 4, 3, 2, 18)
16:22:17.953	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (30, 26, 35, 179, 151, 213, 15, 188, 36, 43, 5, 214, 157, 152)
16:22:17.935	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 1001, 5295, 5087, 1004)
16:22:17.954	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (16, 40, 10, 43, 134, 133, 8, 243, 6, 12, 245, 246, 2, 3, 191, 4, 136)
16:22:17.957	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402) ORDER BY "id"
16:22:17.959	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402) ORDER BY "id"
16:22:17.945	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)
16:22:17.955	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 6, 3, 7, 8, 4, 5)
16:22:17.938	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
16:22:17.946	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) ORDER BY "id"
16:22:17.938	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 1001, 5295, 5087, 1004)
16:22:17.960	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402))
16:22:17.945	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) ORDER BY "id"
16:22:17.959	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) ORDER BY "id"
16:22:17.957	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) ORDER BY "id"
16:22:17.945	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402) ORDER BY "id"
16:22:17.958	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402))
16:22:17.957	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) ORDER BY "id"
16:22:17.960	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402)) ORDER BY "id"
16:22:17.946	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_order_id" IN (1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402))
16:22:17.938	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)