From f45838dcf659f51112900d5e74a8016ec0d51127 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期四, 13 七月 2023 11:18:48 +0800
Subject: [PATCH] #平库库位查询bug修复
---
src/main/java/com/zy/asrs/controller/OrderController.java | 33 ++++++++++++++++++++++++++++-----
1 files changed, 28 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java
index 57f2eb4..1ae4d6b 100644
--- a/src/main/java/com/zy/asrs/controller/OrderController.java
+++ b/src/main/java/com/zy/asrs/controller/OrderController.java
@@ -12,6 +12,7 @@
import com.sun.org.apache.xpath.internal.operations.Or;
import com.zy.asrs.entity.*;
import com.zy.asrs.entity.param.OrderDomainParam;
+import com.zy.asrs.entity.result.OrderDetlVo;
import com.zy.asrs.service.*;
import com.zy.common.CodeRes;
import com.zy.common.model.DetlDto;
@@ -389,7 +390,22 @@
EntityWrapper<OrderDetl> locCheckEntityWrapper = new EntityWrapper<>();
locCheckEntityWrapper.eq("order_no",orderNo);
List<OrderDetl> list = orderDetlService.selectList(locCheckEntityWrapper);
-
+ List<OrderDetlVo> orderDetlVos=new ArrayList<>();
+ OrderDetlVo orderDetlVo=new OrderDetlVo();
+ for (OrderDetl o:
+ list) {
+ orderDetlVo.setOrderNo(o.getOrderNo());
+ orderDetlVo.setMatnr(o.getMatnr());
+ orderDetlVo.setMaktx(o.getMaktx());
+ orderDetlVo.setSpecs(o.getSpecs());
+ orderDetlVo.setOwner(o.getOwner$());
+ orderDetlVo.setPayment(o.getPayment$());
+ orderDetlVo.setAnfme(o.getAnfme());
+ orderDetlVo.setQty(o.getQty());
+ orderDetlVo.setWorkQty(o.getWorkQty());
+ orderDetlVo.setWeight(o.getWeight());
+ orderDetlVos.add(orderDetlVo);
+ }
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
String fileName = URLEncoder.encode("鍗曟嵁", "UTF-8");
@@ -405,11 +421,11 @@
includeColumnFiledNames.add("qty");
includeColumnFiledNames.add("workQty");
includeColumnFiledNames.add("weight");
- EasyExcel.write(response.getOutputStream(), OrderDetl.class)
+ EasyExcel.write(response.getOutputStream(), OrderDetlVo.class)
.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
.includeColumnFiledNames(includeColumnFiledNames)
.sheet("琛�1")
- .doWrite(list);
+ .doWrite(orderDetlVos);
}
@RequestMapping(value = "/order/list/all")
@@ -418,10 +434,17 @@
return R.ok(orderService.selectAllorderNo());
}
+ //璁㈠崟缁勬墭2
@RequestMapping(value = "/order/list/orderNo")
public R orderListorderNo(@RequestParam String orderNo) {
-
- return R.ok(orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no",orderNo)));
+ //鏁伴噺淇敼鎴愪负瀹屾垚鏁伴噺
+ List<OrderDetl> orderDetl1=orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no",orderNo));
+ List<OrderDetl> orderDetls= new ArrayList<OrderDetl>();
+ for (OrderDetl o: orderDetl1) {
+ o.setAnfme(o.getAnfme()-o.getWorkQty());
+ orderDetls.add(o);
+ }
+ return R.ok(orderDetls);
}
--
Gitblit v1.9.1