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 |  129 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 129 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java
index 8dc4cbe..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

--
Gitblit v1.9.1