From c40d7f65624a6f158ec734d2007d7bf8d3b744f4 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期三, 07 九月 2022 11:32:54 +0800
Subject: [PATCH] 软件excel解析
---
src/main/java/com/whyc/controller/MaterialController.java | 49 +++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 45 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/whyc/controller/MaterialController.java b/src/main/java/com/whyc/controller/MaterialController.java
index 493682c..60f87cb 100644
--- a/src/main/java/com/whyc/controller/MaterialController.java
+++ b/src/main/java/com/whyc/controller/MaterialController.java
@@ -1,14 +1,18 @@
package com.whyc.controller;
import com.whyc.dto.Response;
+import com.whyc.pojo.Material;
import com.whyc.service.MaterialService;
+import com.whyc.util.ActionUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
+import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RequestParam;
-import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
+
+import java.io.IOException;
+import java.util.List;
@Api(tags = "鐗╂枡绠＄悊")
@RestController
@@ -39,4 +43,41 @@
return service.getMaterialLimit(subCode,subName,subModel,pageCurr,pageSize);
}
+ @PostMapping
+ @ApiOperation(value = "鏂板",notes = "瑙ｆ瀽杩斿洖鐨勭粷瀵硅矾寰�,闇�瑕佸洖浼犲埌瀛楁fileUrl")
+ public Response add(@RequestBody List<Material> materialList){
+ return service.add(materialList);
+ }
+
+ @PostMapping("zipParse")
+ @ApiOperation("zip瑙ｆ瀽")
+ public Response zipParse(MultipartFile file) throws IOException, InvalidFormatException {
+ return service.zipParse(file);
+ }
+
+ @ApiOperation(value = "鏍规嵁鐗╂枡id鏌ヨ杩斿洖闄勪欢鏂囦欢澶逛笅鎵�鏈夌殑鏂囦欢鍒楄〃",notes = "9.3淇敼鍚庝娇鐢�")
+ @GetMapping("getAttachByMaterialId")
+ public Response getAttachByMaterialId(@RequestParam int materialId){
+ return service.getAttachByMaterialId(materialId);
+ }
+
+ @ApiOperation(value = "鏍规嵁鐗╂枡鍨嬪彿锛�'-','_'涔嬪墠鐨勯儴鍒嗭級鏌ヨ鐗╂枡鐨勫巻鍙茬増鏈�",notes = "9.3淇敼鍚庝娇鐢�")
+ @GetMapping("getMaterialVersion")
+ public Response getMaterialVersion(@RequestParam String subModel){
+ return service.getMaterialVersion(subModel);
+ }
+
+ @ApiOperation(value = "鏍规嵁鐗╂枡id鏌ヨ鐗╂枡淇℃伅",notes = "9.3淇敼鍚庝娇鐢�")
+ @GetMapping("getMaterialById")
+ public Response getMaterialById(@RequestParam int materialId){
+ return service.getMaterialById(materialId);
+ }
+
+ /**鐗╂枡id-鐗╂枡缂栫爜-鐗╂枡鍨嬪彿*/
+ @ApiOperation(value = "杩藉姞闄勪欢",notes = "materialStr涓簀son瀛楃涓�,鍖呭惈id,subCode,subModel")
+ @PostMapping("attachment")
+ public Response addAttachment(@RequestParam MultipartFile multipartFile,@RequestParam String materialStr) throws IOException {
+ Material material = ActionUtil.getGson().fromJson(materialStr, Material.class);
+ return service.addAttachment(multipartFile,material);
+ }
}
--
Gitblit v1.9.1