From c66d31a27637ccbb783d0c97fd7c68a9cec67170 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期三, 05 七月 2023 09:59:35 +0800
Subject: [PATCH] sop接口更新
---
src/main/java/com/whyc/service/SOPService.java | 24 +++++++++++++++++++++++-
1 files changed, 23 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/service/SOPService.java b/src/main/java/com/whyc/service/SOPService.java
index 1a0a9e7..11c44d8 100644
--- a/src/main/java/com/whyc/service/SOPService.java
+++ b/src/main/java/com/whyc/service/SOPService.java
@@ -1,5 +1,8 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.dto.SopDto;
@@ -54,7 +57,7 @@
Sheet sheet = workbook.getSheetAt(0);
int lastRowNum = sheet.getLastRowNum();
//鏂囦欢鍚�
- sop.setFileName(sheet.getRow(2).getCell(2).getStringCellValue());
+ sop.setFileName(sheet.getRow(2).getCell(2).getStringCellValue().trim());
//涓嬮潰鐨剅ow鏄姩鎬佺殑,鍥犱负鏂囦欢绫诲瀷鐨勮鏁版槸鍔ㄦ�佹嫇灞曠殑
//閿氱偣:鏂囦欢鐗堟湰
int fileVersionIndex = 0;
@@ -303,6 +306,17 @@
@Transactional
public Response add(SOP sop,MultipartFile multipartFile) throws IOException {
+ //鏄惁瀛樺湪鏃х増鏈�,瀛樺湪鍒欐妸鎵�鏈夋棫鐗堟湰鐘舵�佹洿鏂颁负0
+ QueryWrapper<SOP> query = Wrappers.query();
+ query.eq("file_name",sop.getFileName()).eq("status",1);
+ List<SOP> sopListExists = mapper.selectList(query);
+ if(sopListExists.size()>0){
+ for (SOP sopExists : sopListExists) {
+ sopExists.setStatus(0);
+ mapper.updateById(sopExists);
+ }
+ }
+
List<SOPProduct> sopProductList = sop.getSopProductList();
String originalFilename = multipartFile.getOriginalFilename();
String[] fileNameSplit = originalFilename.split("\\.");
@@ -312,6 +326,7 @@
//String fileUrlTemp = sop.getFileUrl();
//fileUrlTemp = fileUrlTemp.replace("sop_submit", "sop");
sop.setFileUrl(fileUrlTemp);
+ sop.setStatus(1);
mapper.insert(sop);
if(sopProductList.size()>0) {
sopProductList.forEach(product -> product.setSopId(sop.getId()));
@@ -399,4 +414,11 @@
}
return new Response().setII(1,"鏇存柊sop璇存槑瀹屾垚");
}
+
+ public Response updateStatusById(int id, int status) {
+ UpdateWrapper<SOP> update = Wrappers.update();
+ update.set("status",status).eq("id",id);
+ mapper.update(null,update);
+ return new Response().setII(1,"璁剧疆瀹屾垚");
+ }
}
--
Gitblit v1.9.1