修改历史数据查询的sql语句

zmc

2023-11-23 555fb0758022cec5c88e98ee989d0287bdc0052d

 src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java

@@ -100,21 +100,24 @@
        PageBean pageBean =  fugitiveDustService.getExceptionData2(page,pageSize,siteName,exceptionType,beginTime,endTime,street,dutyCompany);
        return Result.success(pageBean);
    }
//根据某段时间内某个异常类型查询对应的店铺名称和设备编号
@GetMapping("/sitenamecode")
public Result getExceptionSitenameAndCode(String exceptionType,String beginTime, String endTime,String [] street,String [] dutyCompany,String siteName){
    List<DustExceptionData> list = fugitiveDustService.getExceptionSitenameAndCode(exceptionType,beginTime,endTime,street,dutyCompany,siteName);
    return Result.success(list);
}

    //根据某段时间内某个异常类型,地址，运维商，点位名称  ，查询对应的店铺名称和设备编号
    @GetMapping("/sitenamecode")
    public Result getExceptionSitenameAndCode(String exceptionType,String beginTime, String endTime,String [] street,String [] dutyCompany,String siteName){
        List<DustExceptionData> list = fugitiveDustService.getExceptionSitenameAndCode(exceptionType,beginTime,endTime,street,dutyCompany,siteName);
        return Result.success(list);
    }


    //   根据时间返回该异常类型的个数

    //   根据时间,地址，运维商，点位名称，返回该异常类型的个数
    @GetMapping("/exceptionnum")
    public Result exceptionNum(String exceptionType,String beginTime,String endTime,String [] street,String [] dutyCompany,String siteName){
        Integer list = fugitiveDustService.exceptionNum( exceptionType, beginTime, endTime,street,dutyCompany,siteName);
        return Result.success(list);
    }


//    查询历史数据 不分页
@GetMapping("/history")
public Result conditonQueryHistoryData(String siteName,String beginTime, String endTime ){