From 1dac1ea1fa04f562a75292070a828ba1a44d143f Mon Sep 17 00:00:00 2001 From: LSH Date: 星期四, 28 十二月 2023 16:39:12 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/OrderController.java | 162 +++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 159 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java index 650e9bf..d6666bf 100644 --- a/src/main/java/com/zy/asrs/controller/OrderController.java +++ b/src/main/java/com/zy/asrs/controller/OrderController.java @@ -1,6 +1,10 @@ package com.zy.asrs.controller; import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.ExcelWriter; + +import com.alibaba.excel.write.metadata.WriteSheet; +import com.alibaba.excel.write.metadata.fill.FillConfig; import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; @@ -12,6 +16,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.LocDetlAll; import com.zy.asrs.entity.result.OrderDetlVo; import com.zy.asrs.service.*; import com.zy.common.CodeRes; @@ -27,9 +32,12 @@ import javax.imageio.ImageIO; import javax.servlet.http.HttpServletResponse; import java.awt.image.BufferedImage; +import java.io.File; import java.io.IOException; +import java.io.OutputStream; import java.math.BigDecimal; import java.net.URLEncoder; +import java.text.SimpleDateFormat; import java.util.*; @RestController @@ -51,6 +59,127 @@ private LocOwnerService locOwnerService; @Autowired private OrderLogService orderLogService; + @Autowired + private OrderDetlLogService orderDetlLogService; + + @RequestMapping(value = "/order/all") + @ManagerAuth + public R statis2(@RequestParam(defaultValue = "1")Integer curr, + @RequestParam(defaultValue = "10")Integer limit, + @RequestParam Map<String, Object> param) { + + + + Page<Order> stockStatis = orderService.getOrderAll(toPage(curr, limit, param, Order.class)); + + return R.ok().add(stockStatis); + } + + @RequestMapping("/download_excel") + public void downloadExcel(HttpServletResponse response, + @RequestParam String orderNo, + @RequestParam Integer type, + @RequestParam String name, + @RequestParam String threeCode) throws IOException { + + //鑾峰彇鍗曟嵁绫诲瀷 + DocType docType = docTypeService.selectOne(new EntityWrapper<DocType>().eq("doc_id", type)); + if (docType.getPakin()==1 && docType.getPakout()==0){ + type = 1; + } else if (docType.getPakin()==0 && docType.getPakout()==1) { + type = 2; + }else { + throw new CoolException("鍗曟嵁绫诲瀷鏈夎"); + } + //璁剧疆http杩斿洖澶村拰鏂囦欢鍚� + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + String fileName = "Order " + orderNo + ".xlsx"; + response.setHeader("Content-disposition", "attachment;filename=" + fileName); + + //excel鍐欏叆鐨勬暟鎹� + Map<String, Object> map = new HashMap<String, Object>(); + map.put("orderNo", orderNo); + map.put("name",name); + map.put("threeCode",threeCode); + + OutputStream outputStream = response.getOutputStream(); + orderExport(outputStream,type,map); + outputStream.flush(); + outputStream.close(); + } + + public void orderExport(OutputStream outputStream,Integer type,Map<String, Object> map) throws IOException { + + //鑾峰彇璁㈠崟鏄庣粏鏁版嵁 + List<OrderDetl> orderDetls = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no", map.get("orderNo"))); + List<OrderDetlLog> orderDetlLogs = new ArrayList<>(); + if (Cools.isEmpty(orderDetls)){ + orderDetlLogs = orderDetlLogService.selectList(new EntityWrapper<OrderDetlLog>().eq("order_no", map.get("orderNo"))); + } + //鑾峰彇妯$増璺緞 + String templateFileName = null ; + if (type == 1){ + templateFileName = this.getClass().getClassLoader().getResource("ru.xlsx").getPath(); + } else if (type ==2 ) { + templateFileName = this.getClass().getClassLoader().getResource("cu.xlsx").getPath(); + } + + + //鎶婃枃浠跺啓鍏ュ埌outputStream涓� + ExcelWriter excelWriter = EasyExcel.write(outputStream).withTemplate(templateFileName).build(); + WriteSheet writeSheet = EasyExcel.writerSheet().build(); + FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build(); + + //鎬昏鏁伴噺锛岄噸閲� + BigDecimal sumWeight = new BigDecimal(0); + BigDecimal sumAnfme = new BigDecimal(0); + + if (Cools.isEmpty(orderDetls)){ + //搴忓彿 + int i = 1; + for (OrderDetlLog orderDetlLog:orderDetlLogs){ + orderDetlLog.setThreeCode(map.get("threeCode").toString()); + orderDetlLog.setDanger(i); + i++; + if (Cools.isEmpty(orderDetlLog.getWeight())){ + orderDetlLog.setWeight(0.0); + } + sumWeight = sumWeight.add(BigDecimal.valueOf(orderDetlLog.getWeight())); + sumAnfme = sumAnfme.add(BigDecimal.valueOf(orderDetlLog.getAnfme())); + } + //鍐欏叆orderDetlLogs涓殑鏁版嵁 + excelWriter.fill(orderDetlLogs, fillConfig, writeSheet); + map.put("comp",orderDetlLogs.get(0).getOwner$()); + map.put("sumVol",sumWeight); + map.put("sumAnfme",sumAnfme); + }else { + int i = 1; + for (OrderDetl orderDetl:orderDetls){ + orderDetl.setThreeCode(map.get("threeCode").toString()); + orderDetl.setDanger(i); + i++; + if (Cools.isEmpty(orderDetl.getWeight())){ + orderDetl.setWeight(0.0); + } + sumWeight = sumWeight.add(BigDecimal.valueOf(orderDetl.getWeight())); + sumAnfme = sumAnfme.add(BigDecimal.valueOf(orderDetl.getAnfme())); + + } + excelWriter.fill(orderDetls, fillConfig, writeSheet); + map.put("comp",orderDetls.get(0).getOwner$()); + map.put("sumVol",sumWeight); + map.put("sumAnfme",sumAnfme); + } + Date date = new Date(); + SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd"); + + map.put("time",dateFormat.format(date)); + + //鍐欏叆map涓殑鏁版嵁 + excelWriter.fill(map, writeSheet); + excelWriter.finish(); + } @RequestMapping(value = "/order/nav/list/auth") @ManagerAuth @@ -426,9 +555,8 @@ locCheckEntityWrapper.eq("order_no",orderNo); List<OrderDetl> list = orderDetlService.selectList(locCheckEntityWrapper); List<OrderDetlVo> orderDetlVos=new ArrayList<>(); - OrderDetlVo orderDetlVo=new OrderDetlVo(); - for (OrderDetl o: - list) { + for (OrderDetl o:list) { + OrderDetlVo orderDetlVo=new OrderDetlVo(); orderDetlVo.setOrderNo(o.getOrderNo()); orderDetlVo.setMatnr(o.getMatnr()); orderDetlVo.setMaktx(o.getMaktx()); @@ -469,6 +597,34 @@ return R.ok(orderService.selectAllorderNo()); } + @RequestMapping(value = "/order/list/AllCu") + @ManagerAuth + public R orderCuList(@RequestParam(required = false) String orderNo){ + EntityWrapper<Order> wrapper = new EntityWrapper<>(); + if (!Cools.isEmpty(orderNo)) { + wrapper.like("order_no", orderNo); + } + wrapper.le("settle", 2).eq("status", 1); + wrapper.orderBy("create_time", false); + List<Order> orders = orderService.selectList(wrapper); + // 淇濈暀鍑哄簱鍗� + if (!Cools.isEmpty(orders)) { + Iterator<Order> iterator = orders.iterator(); + while (iterator.hasNext()) { + Order order = iterator.next(); + if (order.getDocType() != null) { + DocType docType = docTypeService.selectById(order.getDocType()); + if (docType != null) { + if (docType.getPakout() == 1) { + iterator.remove(); + } + } + } + } + } + return R.ok().add(orders); + } + //璁㈠崟缁勬墭2 @RequestMapping(value = "/order/list/orderNo") public R orderListorderNo(@RequestParam String orderNo) { -- Gitblit v1.9.1