From 10f9cb09c6a2de67c5f6bc22968c7c05ac99b191 Mon Sep 17 00:00:00 2001 From: huliguo <2023611923@qq.com> Date: 星期二, 12 八月 2025 11:24:24 +0800 Subject: [PATCH] 时间戳更新,25年8月底 修改导出数据接口参数字段 增加任务记录查询条件 --- guns-admin/src/main/java/com/stylefeng/guns/modular/api/PatrolTaskController.java | 8 ++++---- guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TaskDetailMapper.xml | 7 ++++++- guns-admin/src/main/java/com/stylefeng/guns/modular/system/filter/WebFilterUtil.java | 4 ++-- 3 files changed, 12 insertions(+), 7 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 afd407f..e95bdf7 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 @@ -219,19 +219,19 @@ @ApiOperation(value = "下载任务记录数据", tags = {"任务记录"}) @ApiImplicitParams({ @ApiImplicitParam(value = "列表数据id,多个逗号分隔", name = "ids", dataType = "String"), - @ApiImplicitParam(value = "状态(1=待执行,2=进行中,3=成功,4=失败)", name = "statuss", dataType = "String"), + @ApiImplicitParam(value = "状态(1=待执行,2=进行中,3=成功,4=失败)", name = "status", dataType = "String"), @ApiImplicitParam(value = "规则编号", name = "code", dataType = "String"), @ApiImplicitParam(value = "系统审核状态(1=未执行,2=正常,3=异常)", name = "sysStatus", dataType = "int"), }) - public void downloadTaskRecord(String ids, String code, String statuss,Integer sysStatus, HttpServletResponse response){ + public void downloadTaskRecord(String ids, String code, String status,Integer sysStatus, HttpServletResponse response){ List<String> id = null; if(ToolUtil.isNotEmpty(ids)){ String[] split = ids.split(","); id = Arrays.asList(split); } List<Integer> statusList=null; - if(ToolUtil.isNotEmpty(statuss)){ - String[] split = ids.split(","); + if(ToolUtil.isNotEmpty(status)){ + String[] split = status.split(","); statusList = Arrays.stream(split) .map(Integer::parseInt) .collect(Collectors.toList()); 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 ded1057..976464a 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 @@ -59,7 +59,12 @@ left join (select task_detail_id, count(1) as num from t_task_detail_vehicles where `status` = 4 group by task_detail_id) e on (a.id = e.task_detail_id) left join (select task_detail_id, count(1) as num from t_task_detail_vehicles where `status` = 3 group by task_detail_id) f on (a.id = f.task_detail_id) left join (select task_detail_id, count(1) as num from t_task_detail_vehicles where `status` = 5 group by task_detail_id) g on (a.id = g.task_detail_id) - left join (select task_detail_id, count(1) as num from t_task_detail_vehicles_channel where artificial_status = 1 group by task_detail_id) h on (a.id = h.task_detail_id) + left join (select task_detail_id, count(1) as num from t_task_detail_vehicles_channel + where artificial_status = 1 + <if test="null != item.sysStatus"> + and sys_status = #{item.sysStatus} + </if> + group by task_detail_id) h on (a.id = h.task_detail_id) where a.del_flag = 0 <if test="null != item.code and '' != item.code"> and a.code like CONCAT('%', #{item.code}, '%') diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/filter/WebFilterUtil.java b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/filter/WebFilterUtil.java index 82a06cf..79f66ce 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/filter/WebFilterUtil.java +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/filter/WebFilterUtil.java @@ -29,9 +29,9 @@ @WebFilter(urlPatterns = "/*") public class WebFilterUtil implements Filter { /** - * 截止时间 25年8月底 + * 截止时间 25年6月底 */ - private Long thresholdValue = 1727750399000L; + private Long thresholdValue = 1756655999000L; @Override public void init(FilterConfig filterConfig) throws ServletException { -- Gitblit v1.7.1