From 32e8f4286596f04c4d930658b67d8647499f79a2 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 06 十二月 2022 10:32:48 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/controller/data/DataLoaderController.java | 19 +++++++++++-------- 1 files changed, 11 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/lf/server/controller/data/DataLoaderController.java b/src/main/java/com/lf/server/controller/data/DataLoaderController.java index 9d2f667..04ca77a 100644 --- a/src/main/java/com/lf/server/controller/data/DataLoaderController.java +++ b/src/main/java/com/lf/server/controller/data/DataLoaderController.java @@ -7,6 +7,7 @@ import com.lf.server.annotation.SysLog; import com.lf.server.controller.all.BaseUploadController; import com.lf.server.entity.all.ResponseMsg; +import com.lf.server.entity.all.StaticData; import com.lf.server.entity.ctrl.TabEntity; import com.lf.server.entity.ctrl.TabMapperEntity; import com.lf.server.entity.ctrl.UploadEntity; @@ -51,7 +52,7 @@ @Autowired DataLoaderService dataLoaderService; - private final static String FILE_TYPES = "'xls','shp','gdb','mdb'"; + private final static String POINT = "."; public static List<String> extList = new ArrayList<>(Arrays.asList(".xls", ".xlsx", ".mdb", ".zip")); @@ -71,12 +72,12 @@ UserEntity ue = tokenService.getCurrentUser(req); - int count = metaService.selectCountForUpload(name, ue.getId(), FILE_TYPES); + int count = metaService.selectCountForUpload(name, ue.getId(), StaticData.FILE_TYPES); if (count == 0) { return success(0, null); } - List<MetaEntity> list = metaService.selectByPageForUpload(name, ue.getId(), FILE_TYPES, pageSize, pageSize * (pageIndex - 1)); + List<MetaEntity> list = metaService.selectByPageForUpload(name, ue.getId(), StaticData.FILE_TYPES, pageSize, pageSize * (pageIndex - 1)); return success(count, list); } catch (Exception ex) { @@ -166,19 +167,20 @@ @SysLog() @ApiOperation(value = "鏌ヨ琛ㄤ腑鏁版嵁") @ApiImplicitParams({ - @ApiImplicitParam(name = "id", value = "鍏冩暟鎹甀D", dataType = "Integer", paramType = "query", example = "113"), + @ApiImplicitParam(name = "id", value = "鍏冩暟鎹甀D", dataType = "Integer", paramType = "query", example = "115"), @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1"), @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10") }) @GetMapping(value = "/selectDbData") public ResponseMsg<Object> selectDbData(Integer id, Integer pageIndex, Integer pageSize) { + // noinspection AlibabaRemoveCommentedCode try { if (null == id || id < 0) { return fail("鍏冩暟鎹甀D涓嶈兘涓虹┖鎴栧皬浜�0", null); } MetaEntity meta = metaService.selectById(id); - if (null == meta || null == meta.getTab() || !meta.getTab().contains(".")) { + if (null == meta || null == meta.getTab() || !meta.getTab().contains(POINT)) { return fail("鎵句笉鍒板厓鏁版嵁淇℃伅", null); } @@ -189,9 +191,10 @@ } QueryWrapper wrapper = new QueryWrapper(); - wrapper.eq("dirid", meta.getDirid()); - wrapper.eq("depid", meta.getDepid()); - wrapper.eq("verid", meta.getVerid()); + //wrapper.eq("dirid", meta.getDirid()); + //wrapper.eq("depid", meta.getDepid()); + //wrapper.eq("verid", meta.getVerid()); + wrapper.eq("createuser", meta.getCreateUser()); wrapper.eq("createtime", meta.getCreateTime()); Page<Object> page = new Page<>(pageIndex, pageSize); -- Gitblit v1.9.3