时间戳更新,25年8月底
修改导出数据接口参数字段
增加任务记录查询条件
| | |
| | | @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()); |
| | |
| | | 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}, '%') |
| | |
| | | @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 { |