package com.iailab.module.data.api.controller; import com.iailab.framework.common.pojo.CommonResult; import com.iailab.framework.common.util.date.DateUtils; import com.iailab.module.data.api.dto.IndexQueryDTO; import com.iailab.module.data.api.dto.echarts.BarLineDTO; import com.iailab.module.data.api.dto.echarts.SeriesItem; import com.iailab.module.data.api.dto.ApiPointValueQueryDTO; import com.iailab.module.data.point.collection.PointCollector; import com.iailab.module.data.point.common.PointDataTypeEnum; import com.iailab.module.data.point.dto.DaPointDTO; import com.iailab.module.data.point.service.DaPointService; import com.iailab.module.data.point.service.DaPointValueService; import com.iailab.module.data.influxdb.pojo.InfluxPointValuePOJO; import com.iailab.module.data.influxdb.service.InfluxDBService; import com.iailab.module.data.api.dto.DeviceValueDTO; import com.iailab.module.data.api.utils.ApiSecurityUtils; import io.swagger.v3.oas.annotations.Operation; import io.swagger.v3.oas.annotations.tags.Tag; import lombok.extern.slf4j.Slf4j; import javax.annotation.Resource; import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import javax.annotation.security.PermitAll; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.math.BigDecimal; import java.util.*; import java.util.stream.Collectors; import static com.iailab.framework.common.pojo.CommonResult.success; /** * @author PanZhibao * @Description * @createTime 2023年05月02日 10:58:00 */ @Slf4j @RestController @RequestMapping("/api/data") @Tag(name = "数据") public class ApiDataController { @Resource private DaPointService daPointService; @Resource private ApiSecurityUtils apiSecurityUtils; @Resource private DaPointValueService daPointValueService; @Resource private InfluxDBService influxDBService; @Resource private PointCollector pointCollector; @PermitAll @PostMapping("/point/history") @Operation(summary = "point历史数据") public CommonResult>>> pointHistory(HttpServletResponse response, HttpServletRequest request, @RequestBody ApiPointValueQueryDTO queryDto) { try { apiSecurityUtils.validate(request); Map>> data = new HashMap<>(); if (CollectionUtils.isEmpty(queryDto.getPointNos())) { return success(data); } if (queryDto.getStart() == null) { queryDto.setStart(new Date()); } if (queryDto.getEnd() == null) { queryDto.setEnd(new Date()); } Map params = new HashMap<>(1); params.put("pointNos", queryDto.getPointNos()); List pointList = daPointService.list(params); if (CollectionUtils.isEmpty(pointList)) { return success(data); } List influxParams = pointList.stream().map(item -> { InfluxPointValuePOJO pojo = new InfluxPointValuePOJO(); pojo.setPoint(item.getPointNo()); pojo.setType(item.getDataType()); return pojo; }).collect(Collectors.toList()); data = influxDBService.queryPointsValues(influxParams, queryDto.getStart(), queryDto.getEnd()); return success(data); } catch (Exception ex) { return new CommonResult>>>().setMsg(ex.getMessage()); } } @PostMapping("/point/current") @Operation(summary = "point当前实时数据") public CommonResult> pointCurrent(HttpServletResponse response, HttpServletRequest request, @RequestBody List pointNos) { try { // apiSecurityUtils.validate(request); Map data = pointCollector.getCurrentValue(pointNos); return success(data); } catch (Exception ex) { return new CommonResult>().setMsg(ex.getMessage()); } } @PostMapping("/point/chart") public CommonResult pointChart(@RequestBody IndexQueryDTO dto) { BarLineDTO CommonResult = new BarLineDTO(); try { List legend = new ArrayList<>(); List series = new ArrayList<>(); String endDateStr = dto.getEndDate() == null ? DateUtils.format(new Date(), "yyyy-MM-dd HH:mm:ss") : DateUtils.format(dto.getEndDate(), "yyyy-MM-dd HH:mm:ss"); Date endDate = DateUtils.parse(endDateStr, "yyyy-MM-dd HH:mm"); Date startDate = dto.getStartDate() == null ? DateUtils.addDateHours(endDate, -2) : dto.getStartDate(); List categories = DateUtils.getTimeScale(startDate, endDate, dto.getGranularity() == null ? 10 : dto.getGranularity()); if (CollectionUtils.isEmpty(dto.getCodes())) { return new CommonResult().setData(CommonResult); } List pointList = new ArrayList<>(); dto.getCodes().forEach(item -> { pointList.add(daPointService.getByNo(item)); }); pointList.forEach(item -> { legend.add(item.getPointName()); SeriesItem seriesItem = new SeriesItem(); seriesItem.setName(item.getPointName()); InfluxPointValuePOJO pojo = new InfluxPointValuePOJO(); pojo.setPoint(item.getPointNo()); pojo.setType(item.getDataType()); List> list = influxDBService.queryPointValues(pojo, startDate, endDate); List sData = list.stream().map(dataItem -> { Object[] valueArray = new Object[]{dataItem.get("time"), getFormatValue(item.getDataType(), dataItem.get("value"))}; return valueArray; }).collect(Collectors.toList()); seriesItem.setData(sData); series.add(seriesItem); }); CommonResult.setLegend(legend); CommonResult.setCategories(categories); CommonResult.setSeries(series); } catch (Exception ex) { ex.printStackTrace(); } return new CommonResult().setData(CommonResult); } private Object getFormatValue(String dataType, Object value) { if (!PointDataTypeEnum.BOOLEAN.getCode().equals(dataType)) { BigDecimal decValue = new BigDecimal(value.toString()); if (PointDataTypeEnum.FLOAT.getCode().equals(dataType)) { return decValue.setScale(2, BigDecimal.ROUND_HALF_UP); } else if (PointDataTypeEnum.INT.getCode().equals(dataType)) { decValue = decValue.setScale(0, BigDecimal.ROUND_HALF_UP); } } return value; } @PostMapping("/pointRelation/history") @Operation(summary = "pointRelation历史数据") public CommonResult>>> pointRelationHistory(HttpServletResponse response, HttpServletRequest request, @RequestBody ApiPointValueQueryDTO queryDto) { try { Map>> data = new HashMap<>(); if (CollectionUtils.isEmpty(queryDto.getPointNos())) { return success(data); } if (queryDto.getStart() == null) { queryDto.setStart(new Date()); } if (queryDto.getEnd() == null) { queryDto.setEnd(new Date()); } data = daPointValueService.getHistoryList(queryDto); if (CollectionUtils.isEmpty(data)) { return success(data); } return success(data); } catch (Exception ex) { return new CommonResult>>>().setMsg(ex.getMessage()); } } @GetMapping("/device-value") public List getDeviceValue(@RequestParam Map params) { List CommonResult = new ArrayList<>(); if (params.get("pointNos") == null) { return CommonResult; } List pointNos = Arrays.asList(params.get("pointNos").toString().split(",")); Map data = pointCollector.getCurrentValue(pointNos); if (!CollectionUtils.isEmpty(data)) { data.forEach((k, v) -> { DeviceValueDTO dto = new DeviceValueDTO(); dto.setDataId(k); dto.setValue(new BigDecimal(v.toString())); CommonResult.add(dto); }); } return CommonResult; } }