archiveManager/src/main/java/com/ruoyi/mapper/DocumentMaterialsMapper.java
@@ -66,4 +66,9 @@ @Select("select if(count(*) < max(page_number), false, true) as res from document_materials where record_id=#{recordId}") boolean isPageNumberLegal(@Param("recordId") int recordId); //拿到除其它材料之外的全部数据的个数 @Select("select count(*) FROM document_materials where file_style!='其他材料' and record_id=#{recordId}") int getCount(@Param("recordId") int recordId); } archiveManager/src/main/java/com/ruoyi/service/IDocumentMaterialsService.java
@@ -91,4 +91,7 @@ //判断pageNumber是否连续 public boolean isPageNumberIslegal(Integer recordId); //拿到对应的案卷材料个数 public int getFileCount(Integer recordId); } archiveManager/src/main/java/com/ruoyi/service/impl/DocumentMaterialsServiceImpl.java
@@ -329,4 +329,9 @@ public boolean isPageNumberIslegal(Integer recordId) { return this.baseMapper.isPageNumberLegal(recordId); } @Override public int getFileCount(Integer recordId) { return this.baseMapper.getCount(recordId); } } ruoyi-admin/src/main/java/com/ruoyi/web/controller/archive/DocumentMaterialsController.java
@@ -9,6 +9,7 @@ import java.nio.file.Path; import java.nio.file.Paths; import java.util.Collections; import java.util.HashMap; import java.util.List; import javax.imageio.ImageIO; import javax.servlet.http.HttpServletResponse; @@ -73,7 +74,22 @@ { boolean res = documentMaterialsService.isPageNumberIslegal(recordId); return AjaxResult.success(res); int cnt = documentMaterialsService.getFileCount(recordId); HashMap<String, Object> data = new HashMap<>(); data.put("res",res); data.put("total",cnt); return AjaxResult.success(data); } /** * 拿到除了其它类型材料的个数 */ @PreAuthorize("@ss.hasPermi('system:materials:list')") @GetMapping("/getFileCount/{recordId}") public AjaxResult getFileCount(@PathVariable("recordId") Integer recordId) { int cnt = documentMaterialsService.getFileCount(recordId); return AjaxResult.success(cnt); } /** * 查询【文件材料综合信息】列表