From af8b0ddeeb5fc71f5099e6be44dc9d3064a3b243 Mon Sep 17 00:00:00 2001
From: 刘小明 <liuxm_a@163.com>
Date: 星期四, 29 八月 2024 16:49:59 +0800
Subject: [PATCH] 优化查询全部工站(id以string格式传给前端)
---
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..67e1afd 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="getProduct")
+ @SsoPowerAop(power = "10300000")
+ @Log("鍙牴鎹畂rderId鏌ヨ浜у搧")
+ public BaseResponse<List<PltProduct>> getProduct(Long orderId){
+ return BaseResponseUtils.buildSuccess(proSv.getProduct(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