From d8c8530752a3f19f082560f767b04471b2dd1085 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期三, 21 八月 2024 14:20:06 +0800
Subject: [PATCH] get product by orderId

---
 pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/product/ProductCtrl.java |  124 ++++++++++++++++++++++++----------------
 1 files changed, 74 insertions(+), 50 deletions(-)

diff --git a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/product/ProductCtrl.java b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/product/ProductCtrl.java
index f2e651e..e09023d 100644
--- a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/product/ProductCtrl.java
+++ b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/product/ProductCtrl.java
@@ -1,18 +1,22 @@
 package com.dy.pmsPlatform.product;
 
-import com.alibaba.fastjson2.JSON;
+import com.alibaba.excel.converters.Converter;
 import com.dy.common.aop.SsoPowerAop;
 import com.dy.common.webUtil.BaseResponse;
 import com.dy.common.webUtil.BaseResponseUtils;
 import com.dy.common.webUtil.QueryResultVo;
 import com.dy.pmsGlobal.aop.Log;
 import com.dy.pmsGlobal.pojoPlt.PltProduct;
+import com.dy.pmsGlobal.util.QrCodeUtil;
+import com.google.zxing.WriterException;
+import jakarta.servlet.http.HttpServletResponse;
 import jakarta.validation.Valid;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.validation.BindingResult;
 import org.springframework.web.bind.annotation.*;
 
+import java.io.IOException;
+import java.util.ArrayList;
 import java.util.List;
 import java.util.Objects;
 
@@ -32,31 +36,21 @@
         this.proSv = proSv;
     }
 
-
+    private static final String fileName = "浜у搧淇℃伅" ;
+    private static final String sheetName = "浜у搧淇℃伅" ;
 
     /**
      * 淇濆瓨浜у搧淇℃伅
      * @param pro
-     * @param bindingResult
      * @return
      */
     @PostMapping(path="save")
     @SsoPowerAop(power = "10300001")
     @Log("淇濆瓨浜у搧淇℃伅")
-    public BaseResponse<PltProduct> save(@RequestBody @Valid PltProduct pro,
-                                         BindingResult bindingResult){
+    public BaseResponse<PltProduct> save(@RequestBody @Valid PltProduct pro){
         pro.id = null;
-        int count;
-        try {
-            if (bindingResult != null && bindingResult.hasErrors()) {
-                return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
-            }
-            pro.setDeleted(false);
-            count = proSv.save(pro);
-        }catch (Exception e){
-            log.error("淇濆瓨浜у搧寮傚父", e);
-            return BaseResponseUtils.buildException(e.getMessage());
-        }
+        pro.setDeleted(false);
+        int count = proSv.save(pro);
         if (count <= 0) {
             return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�");
         } else {
@@ -68,23 +62,13 @@
     /**
      * 鏇存柊浜у搧淇℃伅
      * @param pro
-     * @param bindingResult
      * @return
      */
     @PostMapping(path="update")
     @SsoPowerAop(power = "10300001")
     @Log("鏇存柊浜у搧淇℃伅")
-    public BaseResponse<PltProduct> update(@RequestBody @Valid PltProduct pro,BindingResult bindingResult){
-        int count;
-        try {
-            if (bindingResult != null && bindingResult.hasErrors()) {
-                return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
-            }
-            count = proSv.update(pro);
-        }catch (Exception e){
-            log.error("鏇存柊浜у搧寮傚父", e);
-            return BaseResponseUtils.buildException(e.getMessage());
-        }
+    public BaseResponse<PltProduct> update(@RequestBody @Valid PltProduct pro){
+        int count = proSv.update(pro);
         if (count <= 0) {
             return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�");
         } else {
@@ -100,12 +84,12 @@
     @GetMapping(path="delete")
     @SsoPowerAop(power = "10300001")
     @Log("鍒犻櫎浜у搧淇℃伅")
-    public BaseResponse<PltProduct> delete(String id){
-        try {
-            return BaseResponseUtils.buildSuccess(proSv.delete(Long.parseLong(id)));
-        }catch (Exception e){
-            log.error("鍒犻櫎浜у搧寮傚父", e);
-            return BaseResponseUtils.buildException(e.getMessage());
+    public BaseResponse<Boolean> delete(String id){
+        int count = proSv.delete(Long.parseLong(id));
+        if (count <= 0) {
+            return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�");
+        } else {
+            return BaseResponseUtils.buildSuccess(true);
         }
     }
 
@@ -118,14 +102,9 @@
     @SsoPowerAop(power = "10300000") //鐧诲綍涓庢潈闄愬悓鏃堕獙璇�
     @Log("鏍规嵁ID鏌ヨ浜у搧淇℃伅")
     public BaseResponse<PltProduct> one(String id){
-        try{
-            PltProduct pro=proSv.selectById(id);
+        PltProduct pro=proSv.selectById(id);
 
-            return BaseResponseUtils.buildSuccess(JSON.toJSON(pro));
-        }catch (Exception e){
-            log.error("鏌ヨ浜у搧寮傚父", e);
-            return BaseResponseUtils.buildException(e.getMessage());
-        }
+        return BaseResponseUtils.buildSuccess(pro);
     }
 
     /**
@@ -135,14 +114,59 @@
      */
     @PostMapping(path="some")
     @SsoPowerAop(power = "10300000")
-    @Log("鏌ヨ浜у搧淇℃伅")
+    @Log("鍒嗛〉鏌ヨ浜у搧淇℃伅")
     public BaseResponse<QueryResultVo<List<PltProduct>>> some(@RequestBody QueryVo vo){
-        try {
-            QueryResultVo<List<PltProduct>> list = proSv.selectSome(vo) ;
-            return BaseResponseUtils.buildSuccess(list);
-        }catch (Exception e){
-            log.error("鏌ヨ浜у搧寮傚父", e);
-            return BaseResponseUtils.buildException(e.getMessage());
-        }
+        QueryResultVo<List<PltProduct>> list = proSv.selectSome(vo);
+        return BaseResponseUtils.buildSuccess(list);
     }
+
+    /**
+     * 鏌ヨ鎵�鏈変骇鍝�
+     * @return
+     */
+    @GetMapping(path="all")
+    @SsoPowerAop(power = "10300000")
+    @Log("鏌ヨ鎵�鏈変骇鍝�")
+    public BaseResponse<List<PltProduct>> all(){
+        QueryVo vo = new QueryVo();
+        return BaseResponseUtils.buildSuccess(proSv.selectAll(vo));
+    }
+    /**
+     * 鍙牴鎹畂rderId鏌ヨ浜у搧
+     * @return
+     */
+    @GetMapping(path="selectByOrderId")
+    @SsoPowerAop(power = "10300000")
+    @Log("鍙牴鎹畂rderId鏌ヨ浜у搧")
+    public BaseResponse<List<PltProduct>> selectByOrderId(Long orderId){
+        return BaseResponseUtils.buildSuccess(proSv.selectByOrderId(orderId));
+    }
+
+
+    @PostMapping(path="export")
+    @SsoPowerAop(power = "10300001")
+    @Log("瀵煎嚭浜у搧淇℃伅")
+    public void export(@RequestBody QueryVo queryVo, HttpServletResponse response){
+        List<Converter> list = new ArrayList<>() ;
+
+        List<PltProduct> porList = proSv.selectAll(queryVo);
+        // 浣跨敤骞惰娴佹彁楂樻�ц兘
+        porList.parallelStream().forEach(pro -> {
+            ExcelVo vo = new ExcelVo();
+            vo.name = pro.name;
+            vo.type = pro.type;
+            vo.code = pro.code;
+            try {
+                vo.qrCode = QrCodeUtil.genQrCode(pro.code);
+            } catch (IOException e) {
+                e.printStackTrace();
+            } catch (WriterException e) {
+                e.printStackTrace();
+            }
+            list.add(vo);
+        });
+        QrCodeUtil.downloadExcel(response, fileName,sheetName,list);
+    }
+
+
 }

--
Gitblit v1.8.0