From ebae0c1137ba96d38e5b2323577129d2c9ff2e6e Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期四, 22 五月 2025 09:45:59 +0800
Subject: [PATCH] 1、优化配置文件; 2、优化ID生成器代码; 3、修改注释; 4、修改权限初始化时算法; 5、导出Excel文件功能归为一个新类; 6、工站数据库存入验空修改;

---
 pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/taskPlan/AssemblyPlanCtrl.java |   66 ++++++++++++++++++++++-----------
 1 files changed, 44 insertions(+), 22 deletions(-)

diff --git a/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/taskPlan/AssemblyPlanCtrl.java b/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/taskPlan/AssemblyPlanCtrl.java
index e96a2e3..e33670b 100644
--- a/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/taskPlan/AssemblyPlanCtrl.java
+++ b/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/taskPlan/AssemblyPlanCtrl.java
@@ -8,6 +8,7 @@
 import com.dy.pmsGlobal.aop.Log;
 import com.dy.pmsGlobal.pojoPr.PrAssemblyPlan;
 import com.dy.pmsGlobal.pojoPr.PrDevice;
+import com.dy.pmsGlobal.util.ExportExcelUtil;
 import com.dy.pmsGlobal.util.QrCodeUtil;
 import com.google.zxing.WriterException;
 import jakarta.servlet.http.HttpServletResponse;
@@ -37,7 +38,7 @@
     }
 
     @PostMapping(path="save")
-    @SsoPowerAop(power = "-1")
+    @SsoPowerAop(power = "10200001")
     @Log("淇濆瓨缁勮浠诲姟璁″垝")
     public BaseResponse<Boolean> save(@RequestBody @Valid PrAssemblyPlan plan){
         int count = sv.save(plan);
@@ -54,7 +55,7 @@
      * @return
      */
     @PostMapping(path="update")
-    @SsoPowerAop(power = "-1")
+    @SsoPowerAop(power = "10200001")
     @Log("鏇存柊缁勮浠诲姟璁″垝")
     public BaseResponse<Boolean> update(@RequestBody @Valid PrAssemblyPlan plan){
         int count = sv.update(plan);
@@ -66,7 +67,7 @@
     }
 
     @PostMapping(path="updateStatus")
-    @SsoPowerAop(power = "-1")
+    @SsoPowerAop(power = "10200001")
     @Log("鏇存柊浠诲姟璁″垝鐘舵��")
     public BaseResponse<Boolean> updateStatus(@RequestBody PrAssemblyPlan plan){
         int count = sv.updateStatus(plan);
@@ -81,7 +82,7 @@
      * @return
      */
     @GetMapping(path="one")
-    @SsoPowerAop(power = "-1")
+    @SsoPowerAop(power = "10200000")
     @Log("鏍规嵁ID鏌ヨ缁勮浠诲姟璁″垝")
     public BaseResponse<PrAssemblyPlan> one(Long id){
         PrAssemblyPlan plan=sv.selectById(id);
@@ -94,7 +95,7 @@
      * @return
      */
     @PostMapping(path="some")
-    @SsoPowerAop(power = "-1")
+    @SsoPowerAop(power = "10200000")
     @Log("鍒嗛〉鏌ヨ缁勮浠诲姟璁″垝")
     public BaseResponse<QueryResultVo<List<PrAssemblyPlan>>> some(@RequestBody QueryVo vo){
         QueryResultVo<List<PrAssemblyPlan>> list = sv.selectSome(vo) ;
@@ -104,14 +105,14 @@
     /**
      * 澧炲姞璁惧鍙�
      */
-    @PostMapping(path="addEquip")
-    @SsoPowerAop(power = "-1")
+    @PostMapping(path="addDevice")
+    @SsoPowerAop(power = "10200001")
     @Log("澧炲姞璁惧鍙�")
-    public BaseResponse<?> addEquip(@RequestBody QueryVo vo){
+    public BaseResponse<?> addDevice(@RequestBody QueryVo vo){
         if(vo.addNum == null || vo.addNum <= 0 || vo.planId == null){
             return BaseResponseUtils.buildFail("鍙傛暟閿欒");
         }
-        int count = sv.addEquip(vo.planId,vo.addNum);
+        int count = sv.addDevice(vo.planId,vo.addNum);
         if (count <= 0) {
             return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�");
         } else {
@@ -119,35 +120,56 @@
         }
     }
 
-    @PostMapping(path="someEquip")
-    @SsoPowerAop(power = "-1")
+    @PostMapping(path="someDevice")
+    @SsoPowerAop(power = "10200000")
     @Log("鍒嗛〉鏌ヨ璁惧鍙�")
-    public BaseResponse<QueryResultVo<List<PrDevice>>> someEquip(@RequestBody QueryVo queryVo){
-        QueryResultVo<List<PrDevice>> list = sv.selectSomeEquip(queryVo) ;
+    public BaseResponse<QueryResultVo<List<PrDevice>>> someDevice(@RequestBody QueryVo queryVo){
+        QueryResultVo<List<PrDevice>> list = sv.selectSomeDevice(queryVo) ;
         return BaseResponseUtils.buildSuccess(list);
     }
 
-    @GetMapping(path="exportEquip")
-    @SsoPowerAop(power = "-1")
-    @Log("瀵煎嚭璁惧鍙�")
-    public void exportEquip(Long batchId, HttpServletResponse response){
+    @GetMapping(path="exportDevice")
+    @SsoPowerAop(power = "10200001")
+    @Log("瀵煎嚭璁惧鍙峰強浜岀淮鐮�")
+    public void exportDevice(Long batchId, HttpServletResponse response){
         Date start = new Date() ;
         List<Converter> list = new ArrayList<>();
 
-        List<PrDevice> equipList = sv.selectEquipByBatchId(batchId) ;
+        List<PrDevice> deviceList = sv.selectDeviceByBatchId(batchId) ;
         // 浣跨敤骞惰娴佹彁楂樻�ц兘
-        equipList.parallelStream().forEach(equip -> {
+        deviceList.parallelStream().forEach(device -> {
             ExcelVo vo = new ExcelVo();
-            vo.equipNo = equip.deviceNo;
+            vo.deviceNo = device.deviceNo;
             try {
-                vo.qrCode = QrCodeUtil.genQrCode(vo.equipNo);
+                vo.qrCode = QrCodeUtil.genQrCode(vo.deviceNo);
             } catch (IOException | WriterException e) {
                 e.printStackTrace();
             }
             list.add(vo);
         });
+        log.info("瀵煎嚭璁惧鍙峰強浜岀淮鐮佽�楁椂锛�"+(new Date().getTime()-start.getTime())+"ms");
+        ExportExcelUtil.downloadExcel(response, fileName,sheetName,list);
+        log.info("瀵煎嚭璁惧鍙峰強浜岀淮鐮佽�楁椂锛�"+(new Date().getTime()-start.getTime())+"ms");
+    }
+    @GetMapping(path="exportDeviceNo")
+    @SsoPowerAop(power = "10200001")
+    @Log("瀵煎嚭璁惧鍙�")
+    public void exportDeviceNo(Long batchId, HttpServletResponse response){
+        Date start = new Date() ;
+        List<Converter> list = new ArrayList<>();
+
+        List<PrDevice> deviceList = sv.selectDeviceByBatchId(batchId) ;
+        // 浣跨敤骞惰娴佹彁楂樻�ц兘
+        deviceList.parallelStream().forEach(device -> {
+            ExcelDeviceNoVo vo = new ExcelDeviceNoVo();
+            vo.deviceNo = device.deviceNo;
+            list.add(vo);
+        });
+        //鏍规嵁batchid鎵惧埌浠诲姟鍚嶇О
+        PrAssemblyPlan plan = sv.selectByBatchId(batchId);
+        String fileNameStr = plan.name +"-"+ fileName;
         log.info("瀵煎嚭璁惧鍙疯�楁椂锛�"+(new Date().getTime()-start.getTime())+"ms");
-        QrCodeUtil.downloadExcel(response, fileName,sheetName,list);
+        ExportExcelUtil.downloadExcel(response, fileNameStr,sheetName,list);
         log.info("瀵煎嚭璁惧鍙疯�楁椂锛�"+(new Date().getTime()-start.getTime())+"ms");
     }
 }

--
Gitblit v1.8.0