blame | history | patch | commit | commitdiff | ignore whitespace
cjl
2023-12-14 6992aaf0587c09f7c511c1afd12e1519d91363d3 
 screen-api/src/main/java/com/moral/api/controller/MonitorPointController.java


@@ -1,34 +1,32 @@


package com.moral.api.controller;




import com.moral.api.dto.MonitoringStationDTO;


import com.moral.api.dto.MonitoringStationDTOResult;


import com.moral.api.entity.MonitorPoint;


import com.moral.api.pojo.form.device.MonitorPointQueryForm;


import com.moral.api.pojo.vo.monitorPoint.MonitorPointsVO;


import com.moral.api.service.HistoryFiveMinutelyService;


import com.moral.api.service.MonitorPointService;


import com.moral.api.utils.EasyExcelUtils;


import com.moral.api.utils.NoModelWriteData;


import com.moral.constant.ResponseCodeEnum;


import com.moral.constant.ResultMessage;


import com.moral.util.WebUtils;




import io.swagger.annotations.Api;


import io.swagger.annotations.ApiImplicitParam;


import io.swagger.annotations.ApiImplicitParams;


import io.swagger.annotations.ApiOperation;


import io.swagger.annotations.*;


import lombok.extern.slf4j.Slf4j;


import org.apache.commons.collections4.CollectionUtils;


import org.apache.commons.lang3.StringUtils;


import org.apache.poi.ss.formula.functions.T;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.web.bind.annotation.CrossOrigin;


import org.springframework.web.bind.annotation.GetMapping;


import org.springframework.web.bind.annotation.PostMapping;


import org.springframework.web.bind.annotation.RequestBody;


import org.springframework.web.bind.annotation.RequestMapping;


import org.springframework.web.bind.annotation.RestController;


import org.springframework.web.bind.annotation.*;




import java.util.ArrayList;


import java.util.Arrays;


import java.util.List;


import java.util.Map;


import java.math.BigDecimal;


import java.util.*;


import java.util.stream.Collectors;




import javax.servlet.http.HttpServletRequest;


import javax.servlet.http.HttpServletResponse;




/**


 * @ClassName DeviceController


@@ -60,7 +58,22 @@


        List<MonitorPoint> monitorPoints = monitorPointService.queryByOrgIdAndRegionCode(form);




        //转换前端参数


        MonitorPointsVO vo = MonitorPointsVO.convert(monitorPoints);


        MonitorPointsVO vo = MonitorPointsVO.convert(monitorPoints,false);




        return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), vo);


    }




    @GetMapping("queryMonitorPointsState")


    public ResultMessage queryMonitorPointsState(MonitorPointQueryForm form) {


        //判断是否缺少参数


        if (!form.valid())


            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(),


                    ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());


        //处理查询业务


        List<MonitorPoint> monitorPoints = monitorPointService.queryByOrgIdAndRegionCode(form);




        //转换前端参数


        MonitorPointsVO vo = MonitorPointsVO.convert(monitorPoints,true);




        return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), vo);


    }


@@ -96,12 +109,40 @@


        if (!params.containsKey("monitorPointIds")) {


            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());


        }


        String[] monitorPointIds = params.remove("monitorPointIds").toString().split(",");


        if (monitorPointIds.length >3){


        String monitorPoint = params.remove("monitorPointIds").toString();


        /*if(monitorPoint.contains("")){




        }*/


        params.put("monitorPointList", monitorPoint);


        String[] monitorPointIds = monitorPoint.split(",");


        if (monitorPointIds.length > 3) {


            return ResultMessage.ok();


        }




        params.put("monitorPointIds", monitorPointIds);


        List<Object> response = historyFiveMinutelyService.getAreaWindData(params);


        return ResultMessage.ok(response);


    }


    @GetMapping("getWindDataCenter")


    @ApiOperation(value = "获取风场中心数据", notes = "获取风场中心数据")


    @ApiImplicitParams(value = {


            @ApiImplicitParam(name = "token", value = "token", required = true, paramType = "header", dataType = "String"),


            @ApiImplicitParam(name = "monitorPointIds", value = "站点id", required = true, paramType = "query", dataType = "String")


    })


    public ResultMessage getWindDataCenter(HttpServletRequest request) {


        Map<String, Object> params = WebUtils.getParametersStartingWith(request, null);


        if (!params.containsKey("monitorPointIds")) {


            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());


        }


        String monitorPoint = params.remove("monitorPointIds").toString();


        params.put("monitorPointList", monitorPoint);


        String[] monitorPointIds = monitorPoint.split(",");


        if (monitorPointIds.length > 3) {


            return ResultMessage.ok();


        }




        params.put("monitorPointIds", monitorPointIds);


        List<Object> response = historyFiveMinutelyService.getAreaWindDataCenter(params);


        return ResultMessage.ok(response);


    }




@@ -130,7 +171,7 @@


     */


    @PostMapping("getHourlyDataExcel")


    public ResultMessage getHourlyDataExcel(@RequestBody Map<String, Object> params) {


        if (!params.containsKey("macs") || !params.containsKey("sensors") || !params.containsKey("startTime") || !params.containsKey("endTime")) {


        if (!params.containsKey("macs") || !params.containsKey("sensors") || !params.containsKey("times") || !params.containsKey("type")) {


            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());


        }


        List<Map<String, Object>> resList = monitorPointService.getHourlyDataDataV3(params);


@@ -138,4 +179,86 @@


    }






    @PostMapping("getHourlyDataExcelNew")


    public ResultMessage getHourlyDataExcelNew(@RequestBody Map<String, Object> params) {


        if (!params.containsKey("macs") || !params.containsKey("sensors") || !params.containsKey("times") || !params.containsKey("type")) {


            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());


        }


        List<Map<String, Object>> resList = monitorPointService.getHourlyDataDataV3Excel(params);


        return ResultMessage.ok(resList);


    }




    @PostMapping("/exlOut")


    @ApiImplicitParams(value = {


            @ApiImplicitParam(name = "token", value = "token", required = true, paramType = "header", dataType = "String")


    })


    public void exlOut(HttpServletResponse response,@RequestBody Map<String, Object> params) {


        //导出字段集合


        // List<ExcelHeader> excelHeaders = Arrays.asList(new ExcelHeader("phone", "手机号"), new ExcelHeader("sexStr", "性别"));


       /* Map<String, Object> params = new HashMap<>();


        params.put("macs", Arrays.asList("p5dnd7a0245446", "p5dnd7a0745450"));


        params.put("sensors", "a34004,a34002");


        params.put("type", "hours");


        params.put("times", Arrays.asList("2023-07-01 00", "2023-07-02 00"));*/


        if (!params.containsKey("macs") || !params.containsKey("sensors") || !params.containsKey("times") || !params.containsKey("type")) {


            return;


        }


        //数据集合


        List<Map<String, Object>> resList = monitorPointService.getHourlyDataDataV3Excel(params);


        if (CollectionUtils.isEmpty(resList)) {


            return;


        }


        Map<String, Object> map = resList.get(0);


        List<String> list = new ArrayList<>();


        for (String key : map.keySet()) {


            list.add(key);


        }


        String[] s2 = new String[list.size()];


        list.toArray(s2);


        NoModelWriteData d = new NoModelWriteData();


        d.setFileName("数据导出");


        d.setHeadMap(s2);


        d.setDataStrMap(s2);


        d.setDataList(resList);


        try {


            EasyExcelUtils easyExcelUtils = new EasyExcelUtils();


            easyExcelUtils.noModleWrite(d, response);


        } catch (Exception e) {


            int i = 0;


        }




    }


    @PostMapping("listMonitoring")


    public ResultMessage listMonitoring(@RequestBody Map<String, Object> params) {




        /*@RequestParam @ApiParam(value = "mac",name = "mac号") List<String> mac,


        @RequestParam @ApiParam(value = "startTime",name = "开始时间") String startTime,


        @RequestParam @ApiParam(value = "reportType",name = "type") int reportType,


        @RequestParam @ApiParam(value = "endTime",name = "结束时间") String endTime*/


        List<MonitoringStationDTO> resList = monitorPointService.listMonitoringStationDTO(params,Integer.parseInt(params.get("reportType").toString()),params.get("startTime").toString(),params.get("endTime").toString());


        /*List<MonitoringStationDTOResult> list = new ArrayList<>();


        for(MonitoringStationDTO m : resList){


            MonitoringStationDTOResult result = new MonitoringStationDTOResult();


            result.setName(m.getName());


            result.setMac(m.getMac());


            result.setPM25(m.getPM25().compareTo(BigDecimal.ZERO)==0?"-":m.getPM25().toString());


            result.setPM25Num(m.getPM25Num()==0?"-":String.valueOf(m.getPM25Num()));


            result.setO3(m.getO3().compareTo(BigDecimal.ZERO)==0?"-":m.getO3().toString());


            result.setO3Num(m.getO3Num()==0?"-":String.valueOf(m.getO3Num()));


            result.setTovc(m.getTovc().compareTo(BigDecimal.ZERO)==0?"-":m.getTovc().toString());


            result.setTOVCNum(m.getTOVCNum()==0?"-":String.valueOf(m.getTOVCNum()));


            result.setComposite(m.getComposite().compareTo(BigDecimal.ZERO)==0?"-":m.getComposite().toString());


            result.setCompositeNum(m.getCompositeNum()==0?"-":String.valueOf(m.getCompositeNum()));


            result.setSO2(m.getSO2().compareTo(BigDecimal.ZERO)==0?"-":m.getSO2().toString());


            result.setSO2Num(m.getSO2Num()==0?"-":String.valueOf(m.getSO2Num()));


            result.setNO2(m.getNO2().compareTo(BigDecimal.ZERO)==0?"-":m.getNO2().toString());


            result.setNO2Num(m.getNO2Num()==0?"-":String.valueOf(m.getNO2Num()));


            result.setPM10(m.getPM10().compareTo(BigDecimal.ZERO)==0?"-":m.getPM10().toString());


            result.setPM10Num(m.getPM10Num()==0?"-":String.valueOf(m.getPM10Num()));


            result.setCO(m.getCO().compareTo(BigDecimal.ZERO)==0?"-":m.getCO().toString());


            result.setCONum(m.getCONum()==0?"-":String.valueOf(m.getCONum()));


            list.add(result);


        }*/


        return ResultMessage.ok(resList);


    }


}