添加时间筛选

zhanghua

2025-07-16 c4c1c6cf89781eb06dc02b677a8954fdb2666c43

添加时间筛选

 ycl-platform/src/main/java/com/ycl/OSSImageMove.java

@@ -89,7 +89,7 @@
                InputStream inputStream = conn.getInputStream();// 通过输入流获取图片数据

                if (inputStream != null) {
                    String picData = ossService.uploadImages(inputStream, ".png", 0);
                    String picData = ossService.uploadImages(inputStream, "png", 0);
                    backUrl.append(picData);
                }
            } catch (IOException e) {

 ycl-platform/src/main/java/com/ycl/PlatformApplication.java

@@ -44,11 +44,13 @@
                "127.0.0.1",
                env.getProperty("server.port"));

        try {
            new AppDemo().start();
        } catch (Exception e) {
            log.info("执行大华报警程序出错：", e.getMessage());
        }

        ////////////////////////////////外网服务屏蔽内容////////////////////////////////
//        try {
//            new AppDemo().start();
//        } catch (Exception e) {
//            log.info("执行大华报警程序出错：", e.getMessage());
//        }

//        try {
//            // 启动时，保存上下文，并保存为静态

 ycl-platform/src/main/java/com/ycl/controller/TestController.java

@@ -9,12 +9,33 @@
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import java.util.Map;

@Api(tags = "系统管理-测试")
@RestController
@RequestMapping("/api/unauthorized/external/event")
//@RequestMapping("/api/unauthorized/external/event")
@RequestMapping("/API/FMDeviceService")
public class TestController {


    @PostMapping("/Push")
    public String push(@RequestBody Map map) {
        System.out.println("FMDeviceService/Push");
        return "";
    }

    @PostMapping("/HeartBeat")
    public String heartBeat(@RequestBody Map map) {
        System.out.println("FMDeviceService/HeartBeat");

//        return "{\n" +
//                "\"req\": \"reqid\",\n" +
//                "\"cmd\": \"OpenDoor\"\n" +
//                "}\n";
        return "";
    }


    @ApiOperation("添加")
    @PostMapping("/add")
    public String add(@RequestBody EventAddParamDto book) {

 ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java

@@ -562,14 +562,16 @@
    @ApiOperation("工单统计")
    public CommonResult getWorkOrder(@RequestParam Integer currentPage,
                                     @RequestParam Integer pageSize,
                                     @RequestParam(required = false) String keyword) {
        return CommonResult.success(baseCaseService.getWorkOrder(currentPage, pageSize, keyword));
                                     @RequestParam(required = false) String keyword,
                                     @RequestParam(required = false) String startTime,
                                     @RequestParam(required = false) String endTime) {
        return CommonResult.success(baseCaseService.getWorkOrder(currentPage, pageSize, keyword, startTime, endTime));
    }

    @PostMapping("/work_order/export")
    @ApiOperation("工单统计-导出")
    public void getWorkOrderExport(HttpServletResponse response, QueryForViolationParam param) {
        String sheetName = "工单数据";
        EasyExcelUtils.export(response, sheetName, WorkOrderVO.class, baseCaseService.getWorkOrderList(param.getKeyword()));
        EasyExcelUtils.export(response, sheetName, WorkOrderVO.class, baseCaseService.getWorkOrderList(param.getKeyword(), param.getStartTime(), param.getEndTime()));
    }
}

 ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java

@@ -68,5 +68,5 @@

    Long selectOnTimeCaseRecentlyMonthCount();

    IPage<WorkOrderVO> getWorkOrder(IPage<WorkOrderVO> page, String keyword);
    IPage<WorkOrderVO> getWorkOrder(IPage<WorkOrderVO> page, @Param("keyword") String keyword, @Param("startTime") String startTime, @Param("endTime") String endTime);
}

 ycl-platform/src/main/java/com/ycl/service/caseHandler/IBaseCaseService.java

@@ -94,7 +94,7 @@

    Map<String, Object> statistics();

    IPage<WorkOrderVO> getWorkOrder(Integer current, Integer pageSize, String keyword);
    IPage<WorkOrderVO> getWorkOrder(Integer current, Integer pageSize, String keyword, String startTime, String endTime);

    List<WorkOrderVO> getWorkOrderList(String keyword);
    List<WorkOrderVO> getWorkOrderList(String keyword, String startTime, String endTime);
}

 ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java

@@ -670,7 +670,7 @@
    }

    @Override
    public IPage<WorkOrderVO> getWorkOrder(Integer pageIndex, Integer pageSize, String keyword) {
    public IPage<WorkOrderVO> getWorkOrder(Integer pageIndex, Integer pageSize, String keyword, String startTime, String endTime) {
        if (pageIndex == null) {
            pageIndex = 1;
        }
@@ -678,13 +678,13 @@
            pageSize = 20;
        }
        IPage<WorkOrderVO> page = new Page<>(pageIndex, pageSize);
        return baseCaseMapper.getWorkOrder(page, keyword);
        return baseCaseMapper.getWorkOrder(page, keyword, startTime, endTime);
    }

    @Override
    public List<WorkOrderVO> getWorkOrderList(String keyword) {
    public List<WorkOrderVO> getWorkOrderList(String keyword, String startTime, String endTime) {
        IPage<WorkOrderVO> page = new Page<>(1, 5000);
        IPage<WorkOrderVO> page1 = baseCaseMapper.getWorkOrder(page, keyword);
        IPage<WorkOrderVO> page1 = baseCaseMapper.getWorkOrder(page, keyword, startTime, endTime);
        return page1.getRecords();
    }
}

 ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/ViolationsServiceImpl.java

@@ -229,7 +229,7 @@
    private String saveOSS(String hkUrl) {
        InputStream inputStream = getImageStream(hkUrl);
        if (inputStream != null) {
            String picData = ossService.uploadImages(inputStream, ".png",0);
            String picData = ossService.uploadImages(inputStream, "png",0);
            return picData;
        } else return "";
    }

 ycl-platform/src/main/java/com/ycl/service/video/impl/VideoAlarmReportServiceImpl.java

@@ -182,6 +182,7 @@
//                    e.printStackTrace();
                }
            }
            if (!StringUtils.isEmpty(picData)) {
            List<VideoAlarmReport> videoAlarmReports = new ArrayList<>();

            List<AlarmDataParam> alarmData = alarmParam.getAlarmData();
@@ -219,6 +220,7 @@
            }
        }
    }
    }

    @Override
    public void saveFromHK(HKAlarmParam alarmParam) {

 ycl-platform/src/main/java/com/ycl/task/SynchronizeDHAlarm.java

@@ -44,7 +44,7 @@

    @Autowired
    private IImageResourcesService imageService;

    ////////////////////////////////外网服务屏蔽内容////////////////////////////////
    @Scheduled(cron = "0 */1 * * * ?")
    @Transactional(rollbackFor = Exception.class)
    public void scheduledTask() {
@@ -82,7 +82,7 @@
        }
    }


    ////////////////////////////////外网服务屏蔽内容////////////////////////////////
    @Scheduled(cron = "0 0 0 * * ?")
//    @Transactional(rollbackFor = Exception.class)
    public void deleteAlarmTask() {

 ycl-platform/src/main/java/com/ycl/task/SynchronizeHKVideo.java

@@ -27,6 +27,7 @@
    @Autowired
    private VideoUtil videoUtil;

    ////////////////////////////////外网服务屏蔽内容////////////////////////////////
    //    @Scheduled(cron = "0 */5 * * * ?")   // 每5分钟执行
    @Scheduled(cron = "0 0 1 * * ?")
    @Transactional(rollbackFor = Exception.class)

 ycl-platform/src/main/java/com/ycl/vo/casePool/WorkOrderVO.java

@@ -5,15 +5,15 @@


public class WorkOrderVO {
    @ExcelProperty(value = "姓名", index = 1)
    @ExcelProperty(value = "姓名", index = 0)
    private String name;
    @ExcelProperty(value = "任务总数", index = 2)
    @ExcelProperty(value = "任务总数", index = 1)
    private Integer taskCount;
    @ExcelProperty(value = "已完成数量", index = 3)
    @ExcelProperty(value = "已完成数量", index = 2)
    private Integer finishCount;
    @ExcelProperty(value = "未完成数量", index = 4)
    @ExcelProperty(value = "未完成数量", index = 3)
    private Integer notFinishCount;
    @ExcelProperty(value = "完成率", index = 5)
    @ExcelProperty(value = "完成率", index = 4)
    private Double finishRadio;

    public String getName() {

 ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml

@@ -486,6 +486,10 @@
                <if test="keyword !=''and keyword!=null">
                    and a.username  like concat('%', #{keyword},'%')
                </if>
        <if test="startTime !=''and startTime!=null and endTime!=''and endTime!=null">
            and bc.create_time BETWEEN #{startTime}
            AND #{endTime}
        </if>
                 GROUP BY a.username  ,bc.id
             ) tmp
        GROUP BY username