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