From 4ec6b4b2f09d573d303940d453187c21e407e6ee Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 06 四月 2023 12:28:04 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/data/upload/UploadController.java | 199 +++++++++++++++++++++++++------------------------
1 files changed, 100 insertions(+), 99 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/data/upload/UploadController.java b/src/main/java/com/lf/server/controller/data/upload/UploadController.java
index 3d29d1f..0b41714 100644
--- a/src/main/java/com/lf/server/controller/data/upload/UploadController.java
+++ b/src/main/java/com/lf/server/controller/data/upload/UploadController.java
@@ -2,15 +2,15 @@
import com.lf.server.annotation.SysLog;
import com.lf.server.entity.all.ResponseMsg;
-import com.lf.server.entity.ctrl.TabMapperEntity;
-import com.lf.server.entity.ctrl.UploadEntity;
+import com.lf.server.entity.ctrl.KeyValueEntity;
+import com.lf.server.entity.data.DirEntity;
import com.lf.server.entity.data.MetaEntity;
import com.lf.server.entity.data.MetaFileEntity;
+import com.lf.server.entity.data.VerEntity;
import com.lf.server.entity.sys.UserEntity;
-import com.lf.server.helper.WebHelper;
-import com.lf.server.service.all.BaseUploadService;
-import com.lf.server.service.data.DataLoaderService;
-import com.lf.server.service.data.DataUploadService;
+import com.lf.server.helper.StringHelper;
+import com.lf.server.service.all.UploadAttachService;
+import com.lf.server.service.data.UploadService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
@@ -20,8 +20,6 @@
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
-import java.util.ArrayList;
-import java.util.Arrays;
import java.util.List;
/**
@@ -30,29 +28,25 @@
*/
@Api(tags = "鏁版嵁绠＄悊\\鏁版嵁涓婁紶")
@RestController
-@RequestMapping("/dataLoader")
+@RequestMapping("/dataUpload")
public class UploadController extends QueryController {
@Autowired
- protected DataLoaderService dataLoaderService;
+ UploadService uploadService;
@Autowired
- protected BaseUploadService baseUploadService;
-
- @Autowired
- protected DataUploadService dataUploadService;
-
- private final static List<String> EXT_LIST = new ArrayList<>(Arrays.asList(".xls", ".xlsx", ".mdb", ".zip"));
+ UploadAttachService uploadAttachService;
@SysLog()
@ApiOperation(value = "鏌ヨ璺緞")
@GetMapping(value = "/selectPath")
public ResponseMsg<String> selectPath() {
try {
- String pathName = baseUploadService.selectPath();
+ String pathName = uploadService.selectPath();
return success(pathName);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ log.error(ex.getMessage(), ex);
+ return fail(ex, null);
}
}
@@ -65,14 +59,61 @@
@PostMapping(value = "/uploadFiles")
public ResponseMsg<Object> uploadFiles(String path, HttpServletRequest req, HttpServletResponse res) {
try {
- List<MetaFileEntity> list = baseUploadService.uploadData(null, path, req, res);
+ List<MetaFileEntity> list = uploadService.uploadData(null, path, false, req, res);
if (null == list || list.isEmpty()) {
return fail("娌℃湁鎵惧埌涓婁紶鏂囦欢", null);
}
+ uploadService.copePath(list);
+
return success(list);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
+ }
+ }
+
+ /**
+ * 鎺ユ敹鏁扮粍1锛欯RequestParam(value = "ids")List<Integer> ids
+ * &ids=1209&ids=1180&ids=1387
+ * 鎺ユ敹鏁版嵁2锛欼nteger[] ids
+ * formData.append("ids", 1209); formData.append("ids", 1180); formData.append("ids", 1387);
+ */
+ @SysLog()
+ @ApiOperation(value = "涓婁紶Excel闄勪欢")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "path", value = "璺緞", dataType = "String", paramType = "query"),
+ @ApiImplicitParam(name = "ids", value = "鍏冩暟鎹泦鍚�", dataType = "Integer", allowMultiple = true, paramType = "query")
+ })
+ @ResponseBody
+ @PostMapping(value = "/uploadXlsAnnex")
+ public ResponseMsg<Object> uploadXlsAnnex(String path, Integer[] ids, HttpServletRequest req, HttpServletResponse res) {
+ try {
+ UserEntity ue = tokenService.getCurrentUser(req);
+ if (ue == null) {
+ return fail("鐢ㄦ埛鏈櫥褰�", null);
+ }
+ if (null == ids || ids.length == 0) {
+ return fail("鎵句笉鍒板厓鏁版嵁鐨処D闆嗗悎");
+ }
+
+ List<MetaEntity> ms = metaService.selectXlsAnnex(ids, UploadAttachService.getTabs());
+ if (null == ms || ms.isEmpty()) {
+ return fail("鎵句笉鍒拌涓婁紶闄勪欢鐨勫厓鏁版嵁");
+ }
+
+ List<MetaFileEntity> list = uploadService.uploadData(null, path, false, req, res);
+ if (null == list || list.isEmpty()) {
+ return fail("娌℃湁鎵惧埌涓婁紶鏂囦欢", null);
+ }
+
+ List<KeyValueEntity> rs = uploadAttachService.uploadXlsAnnex(ue, ms, list, path);
+ if (null == rs || rs.size() == 0) {
+ return fail("娌℃湁瑕佹洿鏂扮殑鍏冩暟鎹�");
+ }
+
+ return success(rs);
+ } catch (Exception ex) {
+ return fail(ex, null);
}
}
@@ -82,13 +123,13 @@
@ApiImplicitParam(name = "path", value = "璺緞", dataType = "String", paramType = "query")
})
@GetMapping(value = "/selectFiles")
- public ResponseMsg<List<MetaEntity>> selectFiles(String path) {
+ public ResponseMsg<List<MetaFileEntity>> selectFiles(String path) {
try {
- List<MetaEntity> list = baseUploadService.selectFiles(path, EXT_LIST);
+ List<MetaFileEntity> list = uploadService.selectFiles(path);
return success(list);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
}
}
@@ -99,7 +140,7 @@
})
@ResponseBody
@PostMapping(value = "/deleteFiles")
- public ResponseMsg<Object> deleteFiles(@RequestBody List<MetaEntity> list, HttpServletRequest req) {
+ public ResponseMsg<Object> deleteFiles(@RequestBody List<MetaFileEntity> list, HttpServletRequest req) {
try {
UserEntity ue = tokenService.getCurrentUser(req);
if (ue == null) {
@@ -109,118 +150,78 @@
return fail("娌℃湁鎵惧埌鏂囦欢", null);
}
- int rows = baseUploadService.deleteFiles(list);
+ int rows = uploadService.deleteFiles(list);
return success("鎴愬姛", rows);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
}
}
@SysLog()
@ApiOperation(value = "鏌ヨ鏄犲皠")
@ApiImplicitParams({
- @ApiImplicitParam(name = "path", value = "璺緞", dataType = "String", paramType = "query")
+ @ApiImplicitParam(name = "path", value = "璺緞", dataType = "String", paramType = "query", example = "20230110010101"),
+ @ApiImplicitParam(name = "dirid", value = "鐩綍ID", dataType = "Integer", paramType = "query", example = "163"),
+ @ApiImplicitParam(name = "verid", value = "鐗堟湰ID", dataType = "Integer", paramType = "query", example = "0"),
+ @ApiImplicitParam(name = "epsgCode", value = "鍧愭爣缂栫爜", dataType = "String", paramType = "query", example = "EPSG:4490")
})
@GetMapping(value = "/selectMappers")
- public ResponseMsg<List<TabMapperEntity>> selectMappers(String path) {
+ public ResponseMsg<Object> selectMappers(String path, Integer dirid, Integer verid, String epsgCode, HttpServletRequest req) {
try {
- List<TabMapperEntity> list = dataLoaderService.selectMappers(path);
+ if (StringHelper.isEmpty(path) || StringHelper.isEmpty(epsgCode) || null == dirid || null == verid) {
+ return fail("璺緞銆佺洰褰旾D銆佺増鏈琁D鍜屽潗鏍囩紪鐮佷笉鑳戒负绌�");
+ }
+ if (1 > uploadService.selectCount4Coord(epsgCode)) {
+ return fail("鍧愭爣缂栫爜" + epsgCode + "涓嶅瓨鍦�");
+ }
+ DirEntity dir = dirService.selectDir(dirid);
+ if (null == dir) {
+ return fail("鐩綍ID=" + dirid + "涓嶅瓨鍦�");
+ }
+ VerEntity ver = verService.selectVersion(verid);
+ if (null == ver) {
+ return fail("鐗堟湰ID=" + verid + "涓嶅瓨鍦�");
+ }
+
+ UserEntity ue = tokenService.getCurrentUser(req);
+ List<MetaFileEntity> list = uploadService.selectMappers(ue, path, dir, ver, epsgCode);
return success(list);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
- }
- }
-
- @SysLog()
- @ApiOperation(value = "鏌ヨ鏂囦欢")
- @ApiImplicitParams({
- @ApiImplicitParam(name = "path", value = "璺緞", dataType = "String", paramType = "query")
- })
- @GetMapping(value = "/selectFiles2")
- public ResponseMsg<List<MetaEntity>> selectFiles2(String path) {
- try {
- List<MetaEntity> list = baseUploadService.selectFiles(path, null);
-
- return success(list);
- } catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
}
}
@SysLog()
@ApiOperation(value = "鎻掑叆鏂囦欢")
@ApiImplicitParams({
- @ApiImplicitParam(name = "entity", value = "涓婁紶瀹炰綋绫�", dataType = "UploadEntity", paramType = "body")
+ @ApiImplicitParam(name = "list", value = "鍏冩暟鎹枃浠堕泦鍚�", dataType = "MetaFileEntity", paramType = "body")
})
@ResponseBody
@PostMapping(value = "/insertFiles")
- public ResponseMsg<Object> insertFiles(@RequestBody UploadEntity entity, HttpServletRequest req) {
+ public ResponseMsg<Object> insertFiles(@RequestBody List<MetaFileEntity> list, HttpServletRequest req) {
try {
UserEntity ue = tokenService.getCurrentUser(req);
- if (ue == null) {
+ if (null == ue) {
return fail("鐢ㄦ埛鏈櫥褰�", null);
}
- if (null == entity || null == entity.getMetaEntity()) {
- return fail("鍏冩暟鎹俊鎭负绌�", null);
+ if (null == list || list.isEmpty()) {
+ return fail("鍏冩暟鎹枃浠堕泦鍚堜负绌�", null);
}
- if (null == entity.getFileEntities() || entity.getFileEntities().isEmpty()) {
- return fail("娌℃湁鎵惧埌涓婁紶鏂囦欢", null);
- }
+ uploadService.insertFiles(ue, list, req);
- MetaEntity me = entity.getMetaEntity();
- me.setCreateTime(WebHelper.getCurrentTimestamp());
- // me.setBatch(StringHelper.YMDHMS_FORMAT.format(new Date(me.getCreateTime().getTime())))
- me.setCreateUser(ue.getId());
-
- int rows = dataUploadService.insertFiles(me, entity.getFileEntities());
-
- return success("鎴愬姛", rows);
+ return success("鎴愬姛", list);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
- }
- }
-
- @SysLog()
- @ApiOperation(value = "鎻掑叆鏂囦欢")
- @ApiImplicitParams({
- @ApiImplicitParam(name = "entity", value = "涓婁紶瀹炰綋绫�", dataType = "UploadEntity", paramType = "body")
- })
- @ResponseBody
- @PostMapping(value = "/insertFiles2")
- public ResponseMsg<Object> insertFiles2(@RequestBody UploadEntity entity, HttpServletRequest req) {
- try {
- UserEntity ue = tokenService.getCurrentUser(req);
- if (ue == null) {
- return fail("鐢ㄦ埛鏈櫥褰�", null);
- }
- if (null == entity || null == entity.getMetaEntity()) {
- return fail("鍏冩暟鎹俊鎭负绌�", null);
- }
-
- if (null == entity.getFileEntities() || entity.getFileEntities().isEmpty()) {
- return fail("娌℃湁鎵惧埌涓婁紶鏂囦欢", null);
- }
-
- MetaEntity me = entity.getMetaEntity();
- me.setCreateTime(WebHelper.getCurrentTimestamp());
- // me.setBatch(StringHelper.YMDHMS_FORMAT.format(new Date(me.getCreateTime().getTime())))
- me.setCreateUser(ue.getId());
-
- dataLoaderService.insertFiles(me, entity.getFileEntities(), entity.getTabEntities());
-
- return success("鎴愬姛", entity.getTabEntities());
- } catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
}
}
@SysLog()
@ApiOperation(value = "鍒犻櫎鍏冩暟鎹�")
@ApiImplicitParams({
- @ApiImplicitParam(name = "ids", value = "ID鏁扮粍", dataType = "Integer", paramType = "query", example = "1,2")
+ @ApiImplicitParam(name = "ids", value = "ID鏁扮粍", dataType = "Integer", paramType = "query", allowMultiple = true, example = "1")
})
@GetMapping(value = "/deleteMetas")
public ResponseMsg<Integer> deleteMetas(@RequestParam List<Integer> ids) {
@@ -233,7 +234,7 @@
return success(count);
} catch (Exception ex) {
- return fail(ex.getMessage(), -1);
+ return fail(ex, -1);
}
}
}
--
Gitblit v1.9.3