From 6f372b9d09a4b3519a3966a62d58d95805d261c2 Mon Sep 17 00:00:00 2001 From: huliguo <2023611923@qq.com> Date: 星期四, 29 五月 2025 22:49:48 +0800 Subject: [PATCH] 下载字段status --- guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TaskDetailServiceImpl.java | 2 +- guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/ITaskDetailService.java | 2 +- guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TaskDetailMapper.java | 2 +- guns-admin/src/main/java/com/stylefeng/guns/modular/api/PatrolTaskController.java | 15 ++++++++++++--- guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TaskDetailMapper.xml | 7 +++++-- 5 files changed, 20 insertions(+), 8 deletions(-) diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/api/PatrolTaskController.java b/guns-admin/src/main/java/com/stylefeng/guns/modular/api/PatrolTaskController.java index e69e289..afd407f 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/api/PatrolTaskController.java +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/api/PatrolTaskController.java @@ -27,6 +27,7 @@ import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.*; +import java.util.stream.Collectors; /** * @author zhibing.pu @@ -218,17 +219,25 @@ @ApiOperation(value = "下载任务记录数据", tags = {"任务记录"}) @ApiImplicitParams({ @ApiImplicitParam(value = "列表数据id,多个逗号分隔", name = "ids", dataType = "String"), - @ApiImplicitParam(value = "状态(1=待执行,2=进行中,3=成功,4=失败)", name = "status", dataType = "int"), + @ApiImplicitParam(value = "状态(1=待执行,2=进行中,3=成功,4=失败)", name = "statuss", dataType = "String"), @ApiImplicitParam(value = "规则编号", name = "code", dataType = "String"), @ApiImplicitParam(value = "系统审核状态(1=未执行,2=正常,3=异常)", name = "sysStatus", dataType = "int"), }) - public void downloadTaskRecord(String ids, String code, Integer status,Integer sysStatus, HttpServletResponse response){ + public void downloadTaskRecord(String ids, String code, String statuss,Integer sysStatus, HttpServletResponse response){ List<String> id = null; if(ToolUtil.isNotEmpty(ids)){ String[] split = ids.split(","); id = Arrays.asList(split); } - taskDetailService.downloadTaskRecord(id, code, status,sysStatus, response); + List<Integer> statusList=null; + if(ToolUtil.isNotEmpty(statuss)){ + String[] split = ids.split(","); + statusList = Arrays.stream(split) + .map(Integer::parseInt) + .collect(Collectors.toList()); + + } + taskDetailService.downloadTaskRecord(id, code, statusList,sysStatus, response); } diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TaskDetailMapper.java b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TaskDetailMapper.java index 325c875..e14f4b7 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TaskDetailMapper.java +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/TaskDetailMapper.java @@ -42,5 +42,5 @@ * @param status * @return */ - List<Map<String, Object>> getDownloadTaskRecord(@Param("ids") List<String> ids, @Param("code") String code, @Param("status") Integer status,@Param("sysStatus") Integer sysStatus); + List<Map<String, Object>> getDownloadTaskRecord(@Param("ids") List<String> ids, @Param("code") String code, @Param("status") List<Integer> status,@Param("sysStatus") Integer sysStatus); } diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TaskDetailMapper.xml b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TaskDetailMapper.xml index 39d15ba..ded1057 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TaskDetailMapper.xml +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TaskDetailMapper.xml @@ -114,8 +114,11 @@ <if test="null != code and '' != code"> and b.code like CONCAT('%', #{code}, '%') </if> - <if test="null != status"> - and b.status = #{status} + <if test="null != status and status.size() > 0"> + and b.status in + <foreach collection="status" item="item" index="index" open="(" separator="," close=")"> + #{item} + </foreach> </if> <if test="null != sysStatus"> and d.sys_status = #{sysStatus} diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/ITaskDetailService.java b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/ITaskDetailService.java index 22f1608..038a3b9 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/ITaskDetailService.java +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/ITaskDetailService.java @@ -77,6 +77,6 @@ * @param status * @param response */ - void downloadTaskRecord(List<String> ids, String code, Integer status,Integer sysStatus, HttpServletResponse response); + void downloadTaskRecord(List<String> ids, String code,List<Integer> status,Integer sysStatus, HttpServletResponse response); } diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TaskDetailServiceImpl.java b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TaskDetailServiceImpl.java index 98702f1..5ac589e 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TaskDetailServiceImpl.java +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TaskDetailServiceImpl.java @@ -299,7 +299,7 @@ * @param response */ @Override - public void downloadTaskRecord(List<String> ids, String code, Integer status,Integer sysStatus, HttpServletResponse response) { + public void downloadTaskRecord(List<String> ids, String code, List<Integer> status,Integer sysStatus, HttpServletResponse response) { List<Map<String, Object>> mapList = this.baseMapper.getDownloadTaskRecord(ids, code, status,sysStatus); try { HSSFWorkbook hssfWorkbook = new HSSFWorkbook(); -- Gitblit v1.7.1