From 66db1d15cf5d4b51a346a42b66f0505bd7f31ce0 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 03 一月 2024 15:23:47 +0800
Subject: [PATCH] 解压
---
src/main/java/com/whyc/service/SoftwareService.java | 101 ++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 80 insertions(+), 21 deletions(-)
diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java
index 8da3d19..255be48 100644
--- a/src/main/java/com/whyc/service/SoftwareService.java
+++ b/src/main/java/com/whyc/service/SoftwareService.java
@@ -108,18 +108,20 @@
Cell cell = sheet.getRow(8 + i).getCell(2);
cell.setCellType(Cell.CELL_TYPE_STRING);
String stringCellValue = cell.getStringCellValue();
- int length = stringCellValue.length();
- if(length == 9){
- stringCellValue = "0"+stringCellValue;
- }else if(length < 9){
- int centerZeroNum = 10 - length -1;
- StringBuilder centerZeroStr = new StringBuilder();
- for (int j = 0; j < centerZeroNum; j++) {
- centerZeroStr.append("0");
+ if(!stringCellValue.equals("")) {
+ int length = stringCellValue.length();
+ if (length == 9) {
+ stringCellValue = "0" + stringCellValue;
+ } else if (length < 9) {
+ int centerZeroNum = 10 - length - 1;
+ StringBuilder centerZeroStr = new StringBuilder();
+ for (int j = 0; j < centerZeroNum; j++) {
+ centerZeroStr.append("0");
+ }
+ String strFront = stringCellValue.substring(0, 3);
+ String strBehind = stringCellValue.substring(3);
+ stringCellValue = "0" + strFront + centerZeroStr + strBehind;
}
- String strFront = stringCellValue.substring(0, 3);
- String strBehind = stringCellValue.substring(3);
- stringCellValue = "0"+strFront+centerZeroStr+strBehind;
}
software.setApplyMaterialCode(stringCellValue);
software.setApplyModel(sheet.getRow(8+i).getCell(4).getStringCellValue());
@@ -133,9 +135,9 @@
}
//鏌ヨ杞欢鍒楄〃鐨勪俊鎭�
- public Response getAllSoftware(String fileName,String applyMaterialCode,String applyModel,String owner, String boardNumber,int pageCurr, int pageSize) {
+ public Response getAllSoftware(Integer lockFlag, String fileName, String applyMaterialCode, String applyModel, String owner, String boardNumber, int pageCurr, int pageSize) {
PageHelper.startPage(pageCurr,pageSize);
- List list=mapper.getFileUrl(fileName,applyMaterialCode,applyModel,owner,boardNumber);
+ List list=mapper.getFileUrl(lockFlag,fileName,applyMaterialCode,applyModel,owner,boardNumber);
PageInfo pageInfo=new PageInfo(list);
return new Response().setII(1,list.size()>0,pageInfo,"杞欢淇℃伅杩斿洖");
}
@@ -156,10 +158,12 @@
wrapper.eq("id",id);
wrapper.last("limit 1");
Software software=mapper.selectOne(wrapper);
+
+ String filename=software.getFileUrl().substring(software.getFileUrl().lastIndexOf("\\")+1);
try {
// 杞爜闃叉涔辩爜
//resp.addHeader("Content-Disposition", "attachment;filename=" + new String(softwareName.getBytes("UTF-8"), "ISO8859-1"));
- resp.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode ( software.getFileName()+".zip", "utf-8"));
+ resp.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode (filename, "utf-8"));
OutputStream out = resp.getOutputStream();
FileInputStream in = new FileInputStream(fileDirName+File.separator+software.getFileUrl());
int len=0;
@@ -176,13 +180,12 @@
e.printStackTrace();
}
//璁板綍鏃ュ織
- DocUser docUser= ActionUtil.getUser();
- String operationDetail="鍏蜂綋杞欢鍚嶇О涓�:"+software.getFileName();
- String opreationMsg="鎵ц浜嗚蒋浠朵笅杞芥搷浣�";
- String terminalIp=req.getRemoteAddr();
- logService.recordOperationLog(docUser.getId(),docUser.getName(), UserOperation.TYPE_DOWNLOAD.getType(),new Date(),terminalIp,opreationMsg,operationDetail);
+ logService.recordOperationLogDownLoad(ActionUtil.getUser().getId(),ActionUtil.getUser().getName(), UserOperation.TYPE_DOWNLOAD_SOFWARE.getType(),new Date(),req.getRemoteAddr()
+ ,filename,fileDirName+File.separator+software.getFileUrl(),"",String.valueOf(id),software.getVersion());
+
}
+ @Transactional
public Response upload(MultipartFile file1, MultipartFile file2, String fontUpdateTime, List<Software> softwareList) throws IOException {
String file1Name = file1.getOriginalFilename();
String file2Name = file2.getOriginalFilename();
@@ -215,10 +218,27 @@
software1.setFileUrl(softwareHttpUrl+File.separator+file1Name);
software1.setExcelUrl(softwareHttpUrl+File.separator+file2Name);
software1.setCreateTime(date);
+ //閿佸畾-涓撲緵娴嬭瘯浜哄憳鎵嶈兘瑙ｉ攣
+ software1.setLockFlag(-1);
}
+ /* 鍙栨秷鑷姩閿佸畾鍘熸潵鐗堟湰,鍥犱负鏂扮増鏈渶瑕佽繘琛屾祴璇曟墠鑳戒娇鐢�
+ //閿佸畾鍘熸潵鐨勬墍鏈夌増鏈�:鏍规嵁鐗堝彿鍜岃蒋浠剁被鍨�
+ List<String> materialCodeList = softwareList.stream().map(Software::getApplyMaterialCode).collect(Collectors.toList());
+ lockByBoardNumberAndTypeAndMaterialCode(software.getBoardNumber(),software.getType(),materialCodeList);*/
//鍐欏叆鏁版嵁搴�
insertBatch(softwareList);
return new Response().set(1,true,"涓婁紶瀹屾垚");
+ }
+
+ private void lockByBoardNumberAndTypeAndMaterialCode(String boardNumber, String type, List<String> materialCodeList) {
+ UpdateWrapper<Software> update = Wrappers.update();
+ update.set("lock_flag",1)
+ .set("local_reason","杞欢鐗堟湰鍗囩骇")
+ .eq("board_number",boardNumber)
+ .eq("type",type)
+ .ne("lock_flag",-1)
+ .in("apply_material_code",materialCodeList);
+ mapper.update(null,update);
}
private Software getByFilename(String fileName) {
@@ -250,23 +270,62 @@
UpdateWrapper<Software> update = Wrappers.update();
update.eq("file_name",softwareDB.getFileName());
mapper.delete(update);
+ String fontUpdateTime = softwareDB.getFontUpdateTime();
softwareList.forEach(software2 -> {
software2.setFileUrl(softwareDB.getFileUrl());
software2.setExcelUrl(softwareHttpUrl + File.separator + originalFilename);
software2.setCreateTime(new Date());
+ software2.setLockFlag(-1);
+ software2.setFontUpdateTime(fontUpdateTime);
});
mapper.insertBatchSomeColumn(softwareList);
return new Response().set(1,true,"鏇存柊瀹屾垚");
}
}
- //鏍规嵁杞欢id淇敼杞欢閿佸畾鐘舵��
- public Response updateSoftwareLock(String fileUrl,int lockFlag,String localReason) {
+
+ /**
+ * 鏍规嵁杞欢鍞竴鍊煎瓧娈典慨鏀硅蒋浠堕攣瀹氱姸鎬�,杩欓噷閫夊彇fileUrl
+ *
+ * @param fileUrl
+ * @param lockFlagNow
+ * @param lockFlag
+ * @param localReason
+ * @return
+ */
+ public Response updateSoftwareLock(String fileUrl, int lockFlagNow, int lockFlag, String localReason) {
+ String userName = ActionUtil.getUser().getName();
+ if(lockFlag ==0){
+ //鍙湁鏉庢鍗庢墠鑳借В閿� 寰呮祴璇曢攣瀹氱殑杞欢
+ QueryWrapper<Software> query = Wrappers.query();
+ query.eq("file_url",fileUrl);
+ List<Software> softwareListInDB = mapper.selectList(query);
+ Software softwareInDB = softwareListInDB.get(0);
+ if(softwareInDB.getLockFlag() == -1){
+ //if(!userName.equals("鏉庢鍗�")){
+ // return new Response().set(1,false,"鏃犳潈闄愯В閿� 寰呮祴璇曠殑杞欢");
+ //}else{
+ //閿佸畾鍘熸潵鐨勬墍鏈夌増鏈�:鏍规嵁鐗堝彿鍜岃蒋浠剁被鍨�,鎺掗櫎寰呮祴璇曠増鏈�
+ List<String> materialCodeList = softwareListInDB.stream().map(Software::getApplyMaterialCode).collect(Collectors.toList());
+ lockByBoardNumberAndTypeAndMaterialCode(softwareInDB.getBoardNumber(),softwareInDB.getType(),materialCodeList);
+
+ //}
+ }
+ }
UpdateWrapper uwrapper=new UpdateWrapper();
uwrapper.set("lock_flag",lockFlag);
uwrapper.set("local_reason",localReason);
uwrapper.eq("file_url",fileUrl);
+ uwrapper.eq("lock_flag",lockFlagNow);
int flag=mapper.update(null,uwrapper);
return new Response().set(1,flag>0,"閿佸畾/瑙ｉ攣鎴愬姛");
}
+ //鏍规嵁杞欢鍚嶇О瀹炵幇杞欢鍒犻櫎
+ public Response deleteSoftware(String fileName,String version) {
+ UpdateWrapper wrapper=new UpdateWrapper();
+ wrapper.eq("file_name",fileName);
+ wrapper.eq("version",version);
+ int flag=mapper.delete(wrapper);
+ return new Response().set(1,flag>0,"浠秈d瀹炵幇杞欢鍒犻櫎");
+ }
}
--
Gitblit v1.9.1