From dc2d4a83820f9ab2d58915133fc19ac83c36c43e Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期六, 03 九月 2022 09:49:11 +0800
Subject: [PATCH] 物料提交更新
---
src/main/java/com/whyc/controller/MaterialController.java | 111 -------------------------------------------------------
1 files changed, 1 insertions(+), 110 deletions(-)
diff --git a/src/main/java/com/whyc/controller/MaterialController.java b/src/main/java/com/whyc/controller/MaterialController.java
index ecd5d62..9a37651 100644
--- a/src/main/java/com/whyc/controller/MaterialController.java
+++ b/src/main/java/com/whyc/controller/MaterialController.java
@@ -1,28 +1,16 @@
package com.whyc.controller;
import com.whyc.dto.Response;
-import com.whyc.pojo.DocUser;
import com.whyc.pojo.Material;
-import com.whyc.pojo.MaterialApproving;
import com.whyc.service.MaterialService;
-import com.whyc.util.ActionUtil;
-import com.whyc.util.CommonUtil;
-import com.whyc.util.FileUtil;
-import com.whyc.util.Zip4jUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
-import org.apache.poi.ss.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
-import java.io.File;
import java.io.IOException;
-import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.LinkedList;
import java.util.List;
@Api(tags = "鐗╂枡绠＄悊")
@@ -63,103 +51,6 @@
@PostMapping("zipParse")
@ApiOperation("zip瑙ｆ瀽")
public Response zipParse(MultipartFile file) throws IOException, InvalidFormatException {
- List<MaterialApproving> list = new LinkedList<>();
- Response response = new Response();
- //妫�鏌ユ槸鍚︿负zip
- boolean isZip = Zip4jUtil.checkZipFileParam(file);
- if(!isZip){
- return response.set(1,false,"涓婁紶鐨勬枃浠舵牸寮忎笉鏄痾ip");
- }
- //zip瀛樺偍璺緞:doc_file/material_submit/${username}/{dateFormat}/${timeStamp}
- String rootFile = CommonUtil.getRootFile();
- DocUser user = ActionUtil.getUser();
- String dateFormat = new SimpleDateFormat("YYYY-MM").format(new Date());
- long timeStamp = System.currentTimeMillis();
- String filePath = rootFile + File.separator + "material_submit" + File.separator + user.getName() + File.separator + dateFormat+ File.separator + timeStamp;
- File parentFile = new File(filePath);
- String originalFilename = file.getOriginalFilename();
- File zipFile = new File(filePath+File.separator+ originalFilename);
- if(!zipFile.exists()){
- zipFile.mkdirs();
- }
- file.transferTo(zipFile);
- //瑙ｅ帇鏂囦欢澶�
- Zip4jUtil.unPackZip(zipFile,null,filePath);
- //閬嶅巻瑙ｅ帇鍚庣殑鏂囦欢澶硅矾寰�,瑙ｆ瀽excel
- System.out.println(filePath);
- List<String> fileList = new ArrayList<>();
- fileList = FileUtil.getStaticFilePath(parentFile,fileList);
- for (int i = 0; i < fileList.size(); i++) {
- String fileTempUrl = fileList.get(i);
- //鏌ヨ鍒皒ls鏁版嵁
- if(fileTempUrl.contains(".xls")){
- File fileTemp = new File(fileTempUrl);
- Workbook workbook = null;
- workbook = WorkbookFactory.create(fileTemp);
- List<? extends PictureData> allPictures = workbook.getAllPictures();
- //鍙栫涓�涓猻heet琛�
- Sheet sheet = workbook.getSheetAt(0);
- int lastRowNum = sheet.getLastRowNum();
- //鍙栫涓夎,骞朵互绗笁琛屽紑濮�
- Row rowTemp = sheet.getRow(1);
- short lastCellNum = rowTemp.getLastCellNum();
- //鍏堝崟鐙幏鍙栦骇鍝佸瀷鍙峰拰鐗堟湰鍙�/鍒嗙被
- Row row = sheet.getRow(1);
- String type = row.getCell(1).getStringCellValue();
-
- Row row2 = sheet.getRow(2);
- String productModel = row2.getCell(5).getStringCellValue();
- Row row3 = sheet.getRow(3);
- String productVersion = row3.getCell(5).getStringCellValue();
- for (int l = 8; l < lastRowNum-1; l++) {
- Cell cellTemp = sheet.getRow(l).getCell(1);
- cellTemp.setCellType(Cell.CELL_TYPE_STRING);
- if(cellTemp.getStringCellValue().equals("")){
- break;
- }
- MaterialApproving approving = new MaterialApproving();
- approving.setCreateDate(new Date());
-
- for (int m = 2; m < lastCellNum; m++) {
- row = sheet.getRow(l);
- Cell cell = row.getCell(m);
- String cellValue = null;
- int cellValueInt = 0;
- Double cellValueDouble = null;
- if(m == 3){
- //cellValueDouble = cell.getNumericCellValue();
- //DecimalFormat decimalFormat = new DecimalFormat("0");
- //cellValue = decimalFormat.format(cellValueDouble);
- cell.setCellType(Cell.CELL_TYPE_STRING);
- cellValue = cell.getStringCellValue();
- }
- else if(m ==7){
- cellValueDouble = cell.getNumericCellValue();
- }
- else {
- cellValue = cell.getStringCellValue();
- }
-
- switch (m){
- case 2:{approving.setCategory(cellValue);}break;
- case 3:{approving.setSubCode(cellValue);}break;
- case 4:{approving.setSubName(cellValue);}break;
- case 5:{approving.setSubModel(cellValue);}break;
- case 6:{approving.setUnit(cellValue);}break;
- case 7:{approving.setQuantity(cellValueDouble.intValue());}break;
- case 8:{approving.setProducer(cellValue);}break;
- case 9:{approving.setNotes(cellValue);}break;
- }
- }
- list.add(approving);
- }
- }
- }
- for (MaterialApproving MaterialApproving : list) {
- if(MaterialApproving.getSubName()==null ||MaterialApproving.getSubName().equals("")){
- return response.set(1,false,"鎷掔粷瑙ｆ瀽,excel鏂囦欢涓褰曞寘鍚悕绉颁负绌虹殑璁板綍");
- }
- }
- return response.setII(1,true,list,filePath);
+ return service.zipParse(file);
}
}
--
Gitblit v1.9.1