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