| | |
| | | |
| | | import cn.hutool.core.util.NumberUtil; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.iailab.framework.common.exception.ErrorCode; |
| | | import com.iailab.framework.common.exception.enums.GlobalErrorCodeConstants; |
| | | import com.iailab.framework.common.pojo.CommonResult; |
| | | import com.iailab.framework.common.pojo.PageResult; |
| | | import com.iailab.framework.common.util.date.DateUtils; |
| | | import com.iailab.framework.common.util.object.BeanUtils; |
| | | import com.iailab.framework.common.util.object.ConvertUtils; |
| | | import com.iailab.framework.tenant.core.context.TenantContextHolder; |
| | | import com.iailab.module.ansteel.api.dto.*; |
| | | import com.iailab.module.ansteel.api.vo.PowerCapacitorHisPageReqVO; |
| | | import com.iailab.module.ansteel.api.vo.PowerMaxDemandMainPageReqVO; |
| | | import com.iailab.module.ansteel.common.utils.DecimalUtil; |
| | | import com.iailab.module.ansteel.job.dto.ScheduleJobDTO; |
| | | import com.iailab.module.ansteel.job.entity.ScheduleJobEntity; |
| | | import com.iailab.module.ansteel.job.service.ScheduleJobService; |
| | | import com.iailab.module.ansteel.job.vo.ScheduleJobReqVO; |
| | | import com.iailab.module.ansteel.power.entity.*; |
| | | import com.iailab.module.ansteel.power.service.*; |
| | | import com.iailab.module.data.api.point.DataPointApi; |
| | |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.validation.annotation.Validated; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | import static com.iailab.framework.common.pojo.CommonResult.error; |
| | | import static com.iailab.framework.common.pojo.CommonResult.success; |
| | | |
| | | /** |
| | |
| | | |
| | | @Autowired |
| | | private PowerVoltageStatusService powerVoltageStatusService; |
| | | |
| | | @Autowired |
| | | private PowerMaxdemandMainService powerMaxDemandMainService; |
| | | |
| | | @Autowired |
| | | private PowerMaxdemandDetService powerMaxdemandDetService; |
| | | |
| | | public static final String VALUE = "value"; |
| | | |
| | | public static final String TIME = "time"; |
| | | |
| | | @GetMapping("/net-factor/list") |
| | | @Operation(summary = "功率因数-电网拓扑") |
| | |
| | | @GetMapping("/capacitor-status/list") |
| | | @Operation(summary = "功率因数-电容器投退状态") |
| | | public CommonResult<List<PowerCapacitorStatusDTO>> getPowerCapacitorStatusList(@RequestParam Map<String, Object> params) { |
| | | List<PowerCapacitorStatusDTO> result = new ArrayList<>(); |
| | | List<PowerCapacitorStatusEntity> list = powerCapacitorStatusService.list(params); |
| | | return success(ConvertUtils.sourceToTarget(list, PowerCapacitorStatusDTO.class)); |
| | | for (PowerCapacitorStatusEntity entity : list) { |
| | | PowerCapacitorStatusDTO dto = new PowerCapacitorStatusDTO(); |
| | | dto.setId(entity.getId()); |
| | | dto.setName(entity.getName()); |
| | | dto.setRemark(entity.getRemark()); |
| | | dto.setMainCount(DecimalUtil.toBigDecimal(entity.getMainCount()).intValue()); |
| | | dto.setChildCount(DecimalUtil.toBigDecimal(entity.getChildCount()).intValue()); |
| | | int onCount = 0; |
| | | Map<String, Object> params1 = new HashMap<>(); |
| | | params1.put("statusId", entity.getId()); |
| | | List<PowerCapacitorDetEntity> detList = powerCapacitorDetService.list(params1); |
| | | if (CollectionUtils.isEmpty(detList)) { |
| | | dto.setOnCount(onCount); |
| | | continue; |
| | | } |
| | | List<String> points = new ArrayList<>(); |
| | | Map<String, Object> pointsRealValue = new HashMap<>(); |
| | | for (PowerCapacitorDetEntity det : detList) { |
| | | if (StringUtils.isNotBlank(det.getPointNo())) { |
| | | points.add(det.getPointNo()); |
| | | } |
| | | } |
| | | if (!CollectionUtils.isEmpty(points)) { |
| | | pointsRealValue = dataPointApi.queryPointsRealValue(points); |
| | | } |
| | | for (PowerCapacitorDetEntity det : detList) { |
| | | if (StringUtils.isBlank(det.getId())) { |
| | | continue; |
| | | } |
| | | Object obj = pointsRealValue.get(det.getPointNo()); |
| | | if (obj == null) { |
| | | continue; |
| | | } |
| | | BigDecimal pv = new BigDecimal(obj.toString()); |
| | | if (pv.compareTo(BigDecimal.ZERO) <= 0) { |
| | | continue; |
| | | } |
| | | onCount ++; |
| | | } |
| | | dto.setOnCount(onCount); |
| | | result.add(dto); |
| | | } |
| | | return success(result); |
| | | } |
| | | |
| | | @GetMapping("/capacitor-det/list") |
| | |
| | | public CommonResult<List<PowerCapacitorDetDTO>> getPowerCapacitorDetList(@RequestParam Map<String, Object> params) { |
| | | List<PowerCapacitorDetEntity> list = powerCapacitorDetService.list(params); |
| | | log.info("list.size=" + list.size()); |
| | | List<String> points = list.stream().map(item -> { |
| | | return item.getPointNo(); |
| | | }).collect(Collectors.toList()); |
| | | List<String> points = new ArrayList<>(); |
| | | Map<String, Object> pointsRealValue = new HashMap<>(); |
| | | for (PowerCapacitorDetEntity det : list) { |
| | | if (StringUtils.isNotBlank(det.getPointNo())) { |
| | | points.add(det.getPointNo()); |
| | | } |
| | | } |
| | | if (!CollectionUtils.isEmpty(points)) { |
| | | pointsRealValue = dataPointApi.queryPointsRealValue(points); |
| | | } |
| | |
| | | @GetMapping("/capacitor-his/list") |
| | | @Operation(summary = "功率因数-电容器投退历史") |
| | | public CommonResult<List<PowerCapacitorHisDTO>> getPowerCapacitorHisList(@RequestParam Map<String, Object> params) { |
| | | List<PowerCapacitorHisEntity> list = powerCapacitorHisService.list(params); |
| | | String statusId = (String) params.get("statusId"); |
| | | if (StringUtils.isBlank(statusId)) { |
| | | return success(new ArrayList<>()); |
| | | } |
| | | |
| | | List<PowerCapacitorDetEntity> detList = powerCapacitorDetService.list(statusId); |
| | | List<String> detIds = detList.stream().map(PowerCapacitorDetEntity::getId).collect(Collectors.toList()); |
| | | List<PowerCapacitorHisEntity> list = powerCapacitorHisService.list(detIds); |
| | | return success(ConvertUtils.sourceToTarget(list, PowerCapacitorHisDTO.class)); |
| | | } |
| | | |
| | | @PostMapping("/capacitor-his/page") |
| | | @Operation(summary = "功率因数-电容器投退历史(分页)") |
| | | public CommonResult<PageResult<PowerCapacitorHisDTO>> getPowerCapacitorHisPage(@RequestParam PowerCapacitorHisPageReqVO reqVO) { |
| | | if (StringUtils.isBlank(reqVO.getStatusId())) { |
| | | return error(GlobalErrorCodeConstants.BAD_REQUEST); |
| | | } |
| | | |
| | | List<PowerCapacitorDetEntity> detList = powerCapacitorDetService.list(reqVO.getStatusId()); |
| | | List<String> detIds = detList.stream().map(PowerCapacitorDetEntity::getId).collect(Collectors.toList()); |
| | | reqVO.setDetIdList(detIds); |
| | | |
| | | PageResult<PowerCapacitorHisEntity> data = powerCapacitorHisService.page(reqVO); |
| | | return success(BeanUtils.toBean(data, PowerCapacitorHisDTO.class)); |
| | | } |
| | | |
| | | @GetMapping("/control-main/list") |
| | | @Operation(summary = "功率因数-管控变电站列表") |
| | | @Operation(summary = "功率因数-管控变电站列表(已废弃)") |
| | | public CommonResult<List<PowerControlMainDTO>> getPowerControlMainList(@RequestParam Map<String, Object> params) { |
| | | List<PowerControlMainEntity> list = powerControlMainService.list(params); |
| | | return success(ConvertUtils.sourceToTarget(list, PowerControlMainDTO.class)); |
| | | } |
| | | |
| | | @PostMapping("/control-main/update") |
| | | @Operation(summary = "功率因数-管控变电站修改上下限") |
| | | @Operation(summary = "功率因数-管控变电站修改上下限(已废弃)") |
| | | public CommonResult<Boolean> updatePowerControlMain(@RequestBody PowerControlMainDTO dto) { |
| | | if (StringUtils.isBlank(dto.getId())) { |
| | | return CommonResult.error(GlobalErrorCodeConstants.BAD_REQUEST); |
| | |
| | | } |
| | | |
| | | @GetMapping("/control-det/list") |
| | | @Operation(summary = "功率因数-管控功率因数详情") |
| | | @Operation(summary = "功率因数-管控功率因数详情(已废弃)") |
| | | public CommonResult<List<PowerControlDetDTO>> getPowerControlDetList(@RequestParam Map<String, Object> params) { |
| | | List<PowerControlDetDTO> result = new ArrayList<>(); |
| | | String name = (String) params.get("name"); |
| | |
| | | result = ConvertUtils.sourceToTarget(list, PowerControlDetDTO.class); |
| | | |
| | | result.forEach(item -> { |
| | | // 设置随机数据,0.8左右 |
| | | Random rand = new Random(); |
| | | int min = 700; |
| | | int max = 900; |
| | | int randomNumber = rand.nextInt(max - min + 1) + min; |
| | | BigDecimal rv = new BigDecimal(randomNumber * 0.001).setScale(4, BigDecimal.ROUND_HALF_UP); |
| | | /*BigDecimal rv = new BigDecimal(randomNumber * 0.001).setScale(4, BigDecimal.ROUND_HALF_UP); |
| | | item.setValue(rv); |
| | | if (item.getLimitL() != null && rv.compareTo(item.getLimitL()) < 0) { |
| | | item.setStatus(1); |
| | | } else { |
| | | item.setStatus(0); |
| | | } |
| | | }*/ |
| | | }); |
| | | return success(result); |
| | | } |
| | |
| | | @GetMapping("/demand/list") |
| | | @Operation(summary = "负荷移植-月最大需量,实测需量,有功功率") |
| | | public CommonResult<List<PowerDemandDTO>> getPowerDemandList(@RequestParam Map<String, Object> params) { |
| | | log.info("负荷移植-月最大需量,实测需量,有功功率"); |
| | | List<PowerDemandDTO> result = new ArrayList<>(); |
| | | List<PowerDemandEntity> list = powerDemandService.list(params); |
| | | List<PowerDemandDTO> result = ConvertUtils.sourceToTarget(list, PowerDemandDTO.class); |
| | | if (CollectionUtils.isEmpty(result)) { |
| | | if (CollectionUtils.isEmpty(list)) { |
| | | log.info("list.size=" + list.size()); |
| | | return success(result); |
| | | } |
| | | Calendar calendar = Calendar.getInstance(); |
| | | calendar.set(Calendar.DAY_OF_MONTH, 1); |
| | | calendar.set(Calendar.HOUR_OF_DAY, 0); |
| | | calendar.set(Calendar.MINUTE, 0); |
| | | calendar.set(Calendar.SECOND, 0); |
| | | calendar.set(Calendar.MILLISECOND, 0); |
| | | calendar.set(Calendar.DAY_OF_MONTH, 1); |
| | | Date start = calendar.getTime(); |
| | | Date end = new Date(); |
| | | |
| | | for (PowerDemandDTO dto : result) { |
| | | for (PowerDemandEntity entity : list) { |
| | | PowerDemandDTO demandDTO = new PowerDemandDTO(); |
| | | demandDTO.setId(entity.getId()); |
| | | demandDTO.setCode(entity.getCode()); |
| | | demandDTO.setName(entity.getName()); |
| | | |
| | | List<String> points = new ArrayList<>(); |
| | | if (StringUtils.isNotBlank(dto.getCurDemand())) { |
| | | points.add(dto.getCurDemand()); |
| | | if (StringUtils.isNotBlank(entity.getCurDemand())) { |
| | | points.add(entity.getCurDemand()); |
| | | } |
| | | if (StringUtils.isNotBlank(dto.getActivePower())) { |
| | | points.add(dto.getActivePower()); |
| | | if (StringUtils.isNotBlank(entity.getActivePower())) { |
| | | points.add(entity.getActivePower()); |
| | | } |
| | | if (!CollectionUtils.isEmpty(points)) { |
| | | Map<String, Object> pointsRealValue = dataPointApi.queryPointsRealValue(points); |
| | | if (pointsRealValue.get(dto.getCurDemand()) != null) { |
| | | dto.setCurDemand(pointsRealValue.get(dto.getCurDemand()).toString()); |
| | | if (pointsRealValue.get(entity.getCurDemand()) != null) { |
| | | demandDTO.setCurDemand(new BigDecimal(pointsRealValue.get(entity.getCurDemand()).toString())); |
| | | } |
| | | if (pointsRealValue.get(dto.getActivePower()) != null) { |
| | | dto.setActivePower(pointsRealValue.get(dto.getActivePower()).toString()); |
| | | if (pointsRealValue.get(entity.getActivePower()) != null) { |
| | | demandDTO.setActivePower(new BigDecimal(pointsRealValue.get(entity.getActivePower()).toString())); |
| | | } |
| | | } |
| | | |
| | | if (!StringUtils.isEmpty(dto.getMaxDemand())) { |
| | | Date start = calendar.getTime(); |
| | | if (!StringUtils.isEmpty(entity.getMaxDemand())) { |
| | | ApiPointValueQueryDTO apiPointValueQueryDTO = new ApiPointValueQueryDTO(); |
| | | apiPointValueQueryDTO.setStart(start); |
| | | apiPointValueQueryDTO.setPointNo(dto.getMaxDemand()); |
| | | Map<String, Object> maxValue = dataPointApi.queryPointMaxValue(apiPointValueQueryDTO); |
| | | apiPointValueQueryDTO.setEnd(end); |
| | | apiPointValueQueryDTO.setPointNo(entity.getMaxDemand()); |
| | | Map<String, Object> maxValue = dataPointApi.queryPointMaxTimeValue(apiPointValueQueryDTO); |
| | | if (maxValue != null) { |
| | | dto.setMaxDemand(maxValue.get(dto.getMaxDemand()) == null ? "" : maxValue.get(dto.getMaxDemand()).toString()); |
| | | demandDTO.setMaxDemand(new BigDecimal(maxValue.get(VALUE).toString())); |
| | | demandDTO.setOccurTime(DateUtils.parse( maxValue.get(TIME).toString(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); |
| | | } |
| | | |
| | | } |
| | | result.add(demandDTO); |
| | | } |
| | | return success(result); |
| | | } |
| | |
| | | } |
| | | |
| | | @PostMapping("/demand-query/list") |
| | | @Operation(summary = "负荷移植-功率因数查询") |
| | | public CommonResult<List<PowerNetDropdownDTO>> getDemandDropdownList(@RequestBody PowerDemandQueryDTO queryDto) { |
| | | List<PowerNetDropdownDTO> result = new ArrayList<>(); |
| | | @Operation(summary = "负荷移植-需量值查询") |
| | | public CommonResult<List<PowerDemandQueryRespDTO>> getDemandQueryList(@RequestBody PowerDemandQueryDTO queryDto) { |
| | | List<PowerDemandQueryRespDTO> result = new ArrayList<>(); |
| | | if (StringUtils.isBlank(queryDto.getCode())) { |
| | | log.info("code isBlank"); |
| | | } |
| | | log.info("code=" + queryDto.getCode()); |
| | | if (StringUtils.isBlank(queryDto.getNodeCode())) { |
| | | log.info("NodeCode isBlank"); |
| | | return success(result); |
| | | } |
| | | PowerDemandEntity entity = powerDemandService.getByCode(queryDto.getCode()); |
| | | if (entity == null) { |
| | | log.info("PowerDemandEntity is null"); |
| | | return success(result); |
| | | } |
| | | Calendar calendar = Calendar.getInstance(); |
| | | calendar.set(Calendar.MILLISECOND, 0); |
| | | calendar.set(Calendar.SECOND, 0); |
| | | Date startTime = queryDto.getStartTime(); |
| | | Date endTime = queryDto.getEndTime(); |
| | | if (endTime == null) { |
| | | endTime = calendar.getTime(); |
| | | } |
| | | if (startTime == null) { |
| | | calendar.add(Calendar.DAY_OF_YEAR, -1); |
| | | startTime = calendar.getTime(); |
| | | } |
| | | |
| | | Map<String, Object> params0 = new HashMap<>(); |
| | | params0.put("groupName", entity.getName()); |
| | | List<PowerNetDropdownEntity> list = powerNetDropdownService.list(params0); |
| | | List<String> points = list.stream().map(item -> { |
| | | return item.getCurCos(); |
| | | }).collect(Collectors.toList()); |
| | | if (queryDto.getCurCos() == null) { |
| | | log.info("查询当前值"); |
| | | Map<String, Object> pointsRealValue = new HashMap<>(); |
| | | if (!CollectionUtils.isEmpty(points)) { |
| | | pointsRealValue = dataPointApi.queryPointsRealValue(points); |
| | | List<PowerNetDropdownEntity> dropdownList = powerNetDropdownService.list(params0); |
| | | List<String> pointNos = new ArrayList<>(); |
| | | Map<String, String> demandPointMap = new HashMap<>(); |
| | | for (PowerNetDropdownEntity netDropdown : dropdownList) { |
| | | demandPointMap.put(netDropdown.getNodeCode(), netDropdown.getExt1()); |
| | | if (StringUtils.isNotBlank(netDropdown.getExt1())) { |
| | | pointNos.add(netDropdown.getExt1()); |
| | | } |
| | | for (PowerNetDropdownEntity netDropdown : list) { |
| | | PowerNetDropdownDTO dto = ConvertUtils.sourceToTarget(netDropdown, PowerNetDropdownDTO.class); |
| | | BigDecimal curCos = BigDecimal.ZERO; |
| | | if (pointsRealValue.get(netDropdown.getCurCos()) != null) { |
| | | curCos = new BigDecimal(pointsRealValue.get(netDropdown.getCurCos()).toString()); |
| | | } |
| | | dto.setCurCos(curCos); |
| | | result.add(dto); |
| | | } |
| | | } else { |
| | | log.info("查询历史值"); |
| | | String nodeCode = queryDto.getNodeCode(); |
| | | if (StringUtils.isBlank(nodeCode)) { |
| | | log.info("nodeCode isBlank"); |
| | | return success(result); |
| | | } |
| | | PowerNetDropdownEntity powerNetDropdownEntity = powerNetDropdownService.getByNodeCode(nodeCode); |
| | | if (powerNetDropdownEntity == null) { |
| | | log.info("PowerNetDropdownEntity is null"); |
| | | return success(result); |
| | | } |
| | | ApiPointsValueQueryDTO valueQueryDTO = new ApiPointsValueQueryDTO(); |
| | | valueQueryDTO.setPointNos(points); |
| | | Calendar calendar = Calendar.getInstance(); |
| | | calendar.set(Calendar.MILLISECOND, 0); |
| | | calendar.set(Calendar.SECOND, 0); |
| | | Date startTime = queryDto.getStartTime(); |
| | | Date endTime = queryDto.getEndTime(); |
| | | if (endTime == null) { |
| | | endTime = calendar.getTime(); |
| | | } |
| | | if (startTime == null) { |
| | | calendar.add(Calendar.DAY_OF_YEAR, -1); |
| | | startTime = calendar.getTime(); |
| | | } |
| | | valueQueryDTO.setStart(startTime); |
| | | valueQueryDTO.setEnd(endTime); |
| | | Map<String, List<Map<String, Object>>> pointsHisValues = dataPointApi.queryPointsHistoryValue(valueQueryDTO); |
| | | if (CollectionUtils.isEmpty(pointsHisValues)) { |
| | | log.info("pointsHisValues is null"); |
| | | return success(result); |
| | | } |
| | | |
| | | ApiPointValueQueryDTO pointValueQueryDTO = new ApiPointValueQueryDTO(); |
| | | pointValueQueryDTO.setStart(startTime); |
| | | pointValueQueryDTO.setEnd(endTime); |
| | | pointValueQueryDTO.setPointNo(powerNetDropdownEntity.getCurCos()); |
| | | List<ApiPointValueDTO> hisValue = dataPointApi.queryPointHistoryValue(pointValueQueryDTO); |
| | | if (CollectionUtils.isEmpty(hisValue)) { |
| | | log.info("hisValue is null"); |
| | | } |
| | | ApiPointValueDTO curValue = null; |
| | | Collections.reverse(hisValue); |
| | | for (ApiPointValueDTO valueDTO : hisValue) { |
| | | } |
| | | for(PowerNetDropdownEntity netDropdown : dropdownList) { |
| | | PowerDemandQueryRespDTO dto = ConvertUtils.sourceToTarget(netDropdown, PowerDemandQueryRespDTO.class); |
| | | dto.setCurDemand(null); |
| | | result.add(dto); |
| | | } |
| | | if (queryDto.getCurDemand() == null) { |
| | | log.info("查询值为空,显示空白"); |
| | | return success(result); |
| | | } |
| | | ApiPointValueQueryDTO queryCodeValue = new ApiPointValueQueryDTO(); |
| | | queryCodeValue.setStart(startTime); |
| | | queryCodeValue.setEnd(endTime); |
| | | queryCodeValue.setPointNo(entity.getCurDemand()); |
| | | List<ApiPointValueDTO> codeValueList = dataPointApi.queryPointHistoryValue(queryCodeValue); |
| | | if (CollectionUtils.isEmpty(codeValueList)) { |
| | | return success(result); |
| | | } |
| | | ApiPointValueDTO curValue = new ApiPointValueDTO(); |
| | | for (ApiPointValueDTO valueDTO : codeValueList) { |
| | | if (Math.abs(queryDto.getCurDemand().doubleValue() - valueDTO.getV()) <= 0.0001) { |
| | | log.info("curValue is find"); |
| | | curValue = valueDTO; |
| | | if ((queryDto.getCurCos().doubleValue() - valueDTO.getV()) <= 0.0001) { |
| | | break; |
| | | } |
| | | break; |
| | | } |
| | | if (curValue == null) { |
| | | log.info("curValue is null"); |
| | | return success(result); |
| | | } |
| | | log.info("curValue=" + curValue); |
| | | for (PowerNetDropdownEntity netDropdown : list) { |
| | | PowerNetDropdownDTO dto = ConvertUtils.sourceToTarget(netDropdown, PowerNetDropdownDTO.class); |
| | | } |
| | | log.info("curValue={}", curValue); |
| | | if (curValue.getT() == null) { |
| | | log.info("curValue is not find"); |
| | | return success(result); |
| | | } |
| | | |
| | | if (CollectionUtils.isEmpty(pointsHisValues.get(netDropdown.getCurCos()))) { |
| | | continue; |
| | | } |
| | | Map<String, BigDecimal> pointValueMap = new HashMap<>(); |
| | | pointsHisValues.get(netDropdown.getCurCos()).forEach(item -> { |
| | | pointValueMap.put(item.get("time").toString(), DecimalUtil.toBigDecimal(item.get("value"))); |
| | | |
| | | }); |
| | | dto.setCurCos(pointValueMap.get(DateUtils.format(curValue.getT(),DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND))); |
| | | result.add(dto); |
| | | Calendar calendar1 = Calendar.getInstance(); |
| | | calendar1.setTime(curValue.getT()); |
| | | ApiPointsValueQueryDTO valueQueryDTO = new ApiPointsValueQueryDTO(); |
| | | valueQueryDTO.setPointNos(pointNos); |
| | | valueQueryDTO.setEnd(calendar1.getTime()); |
| | | calendar1.add(Calendar.MINUTE, -1); |
| | | valueQueryDTO.setStart(calendar1.getTime()); |
| | | Map<String, List<Map<String, Object>>> pointsHisValues = dataPointApi.queryPointsHistoryValue(valueQueryDTO); |
| | | if (CollectionUtils.isEmpty(pointsHisValues)) { |
| | | log.info("pointsHisValues is null"); |
| | | return success(result); |
| | | } |
| | | for(PowerDemandQueryRespDTO respDTO : result) { |
| | | if (StringUtils.isBlank(demandPointMap.get(respDTO.getNodeCode()))) { |
| | | continue; |
| | | } |
| | | List<Map<String, Object>> hisList = pointsHisValues.get(demandPointMap.get(respDTO.getNodeCode())); |
| | | if (CollectionUtils.isEmpty(hisList)) { |
| | | continue; |
| | | } |
| | | Map<String, Object> valueMap = hisList.get(hisList.size() - 1); |
| | | respDTO.setDataTime(DateUtils.parse(valueMap.get("time").toString(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); |
| | | respDTO.setCurDemand( DecimalUtil.toBigDecimal(valueMap.get("value"))); |
| | | } |
| | | return success(result); |
| | | } |
| | |
| | | start = calendar.getTime(); |
| | | apiPointValueQueryDTO.setStart(start); |
| | | apiPointValueQueryDTO.setEnd(new Date()); |
| | | List<ApiPointValueDTO> monthChartData = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO); |
| | | List<Double> monthValues = new ArrayList<>(); |
| | | if (CollectionUtils.isEmpty(monthChartData)) { |
| | | monthValues = monthChartData.stream().map(item -> item.getV()).collect(Collectors.toList()); |
| | | result.setMax(monthValues.stream().max(Double::compareTo).get()); |
| | | result.setMin(monthValues.stream().min(Double::compareTo).get()); |
| | | Map<String, Object> maxV = dataPointApi.queryPointMaxValueRange(apiPointValueQueryDTO); |
| | | Map<String, Object> minV = dataPointApi.queryPointMaxValueRange(apiPointValueQueryDTO); |
| | | if (maxV != null && maxV.containsKey(pointNo)) { |
| | | result.setMax(new BigDecimal(maxV.get(pointNo).toString())); |
| | | } |
| | | if (minV != null && minV.containsKey(pointNo)) { |
| | | result.setMin(new BigDecimal(minV.get(pointNo).toString())); |
| | | } |
| | | return success(result); |
| | | } |
| | |
| | | apiPointValueQueryDTO1.setStart(start1); |
| | | apiPointValueQueryDTO1.setEnd(new Date()); |
| | | apiPointValueQueryDTO1.setPointNo(pointNo); |
| | | List<ApiPointValueDTO> monthChartData = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO1); |
| | | if (!CollectionUtils.isEmpty(monthChartData)) { |
| | | List<Double> monthValues = monthChartData.stream().map(item -> item.getV()).collect(Collectors.toList()); |
| | | powerHistoryDTO.setMax(monthValues.stream().max(Double::compareTo).get()); |
| | | powerHistoryDTO.setMin(monthValues.stream().min(Double::compareTo).get()); |
| | | Map<String, Object> maxV = dataPointApi.queryPointMaxValueRange(apiPointValueQueryDTO1); |
| | | Map<String, Object> minV = dataPointApi.queryPointMaxValueRange(apiPointValueQueryDTO1); |
| | | if (maxV != null && maxV.containsKey(pointNo)) { |
| | | powerHistoryDTO.setMax(new BigDecimal(maxV.get(pointNo).toString())); |
| | | } |
| | | |
| | | if (minV != null && minV.containsKey(pointNo)) { |
| | | powerHistoryDTO.setMin(new BigDecimal(minV.get(pointNo).toString())); |
| | | } |
| | | result.put(nodeCode, powerHistoryDTO); |
| | | } |
| | | return success(result); |
| | |
| | | |
| | | @PostMapping("/demand/history-list") |
| | | @Operation(summary = "负荷移植-实测需量有功功率历史(多code)") |
| | | public CommonResult<LinkedHashMap<String, List<Object[]>>> getPowerDemandHistoryList(@RequestBody PowerDemandHisReqDTO dto) { |
| | | public CommonResult<LinkedHashMap<String, PowerHistoryDTO>> getPowerDemandHistoryList(@RequestBody PowerDemandHisReqDTO dto) { |
| | | log.info("请求参数: {}", JSONObject.toJSONString(dto)); |
| | | LinkedHashMap<String, List<Object[]>> result = new LinkedHashMap<>(); |
| | | LinkedHashMap<String, PowerHistoryDTO> result = new LinkedHashMap<>(); |
| | | |
| | | // 参数校验 |
| | | if (CollectionUtils.isEmpty(dto.getCodeList())) { |
| | |
| | | startTime = cal.getTime(); |
| | | } |
| | | |
| | | Calendar calendar1 = Calendar.getInstance(); |
| | | calendar1.set(Calendar.DAY_OF_MONTH, 1); |
| | | calendar1.set(Calendar.HOUR_OF_DAY, 0); |
| | | calendar1.set(Calendar.MINUTE, 0); |
| | | calendar1.set(Calendar.SECOND, 0); |
| | | calendar1.set(Calendar.MILLISECOND, 0); |
| | | Date start1 = calendar1.getTime(); |
| | | |
| | | for (String code : dto.getCodeList()) { |
| | | PowerNetFactorQuery powerNetFactorQuery = null; |
| | | PowerHistoryDTO powerHistoryDTO = new PowerHistoryDTO(); |
| | | PowerNetFactorQuery powerNetFactorQuery = new PowerNetFactorQuery(); |
| | | PowerDemandEntity powerDemandEntity = powerDemandService.getByCode(code); |
| | | PowerNetDropdownEntity powerNetDropdownEntity = powerNetDropdownService.getByNodeCode(code); |
| | | if (powerDemandEntity != null) { |
| | |
| | | }) |
| | | .collect(Collectors.toList()); |
| | | |
| | | result.put(code, dataList); |
| | | powerHistoryDTO.setDataList(dataList); |
| | | |
| | | //查询月最大最小值 |
| | | ApiPointValueQueryDTO apiPointValueQueryDTO1 = new ApiPointValueQueryDTO(); |
| | | apiPointValueQueryDTO1.setStart(start1); |
| | | apiPointValueQueryDTO1.setEnd(new Date()); |
| | | apiPointValueQueryDTO1.setPointNo(pointNo); |
| | | Map<String, Object> maxV = dataPointApi.queryPointMaxValueRange(apiPointValueQueryDTO1); |
| | | Map<String, Object> minV = dataPointApi.queryPointMaxValueRange(apiPointValueQueryDTO1); |
| | | if (maxV != null && maxV.containsKey(pointNo)) { |
| | | powerHistoryDTO.setMax(new BigDecimal(maxV.get(pointNo).toString())); |
| | | } |
| | | if (minV != null && minV.containsKey(pointNo)) { |
| | | powerHistoryDTO.setMin(new BigDecimal(minV.get(pointNo).toString())); |
| | | } |
| | | |
| | | result.put(code, powerHistoryDTO); |
| | | } |
| | | |
| | | return success(result); |
| | |
| | | } |
| | | return success(result); |
| | | } |
| | | |
| | | @PostMapping("/power-maxdemand/page") |
| | | @Operation(summary = "负荷移植-最大需量发生记录分页") |
| | | public CommonResult<PageResult<PowerMaxDemandMainDTO>> getPowerMaxDemandMainPage(@RequestBody PowerMaxDemandMainPageReqVO reqVO) { |
| | | if (StringUtils.isBlank(reqVO.getCode())) { |
| | | log.info("code is blank"); |
| | | return error(GlobalErrorCodeConstants.BAD_REQUEST); |
| | | } |
| | | PageResult<PowerMaxdemandMainEntity> page = powerMaxDemandMainService.page(reqVO); |
| | | PageResult<PowerMaxDemandMainDTO> result = BeanUtils.toBean(page, PowerMaxDemandMainDTO.class); |
| | | result.getList().forEach(dto0 -> { |
| | | List<PowerMaxdemandDetEntity> detList0 = powerMaxdemandDetService.selectListByRelId(dto0.getId(), dto0.getOccurTime()); |
| | | dto0.setChildren(ConvertUtils.sourceToTarget(detList0, PowerMaxdemandDetDTO.class)); |
| | | if (!CollectionUtils.isEmpty(dto0.getChildren())) { |
| | | dto0.getChildren().forEach(dto1 -> { |
| | | List<PowerMaxdemandDetEntity> detList1 = powerMaxdemandDetService.selectListByRelId(dto1.getId(), dto1.getOccurTime()); |
| | | dto1.setChildren(ConvertUtils.sourceToTarget(detList1, PowerMaxdemandDetDTO.class)); |
| | | }); |
| | | } |
| | | }); |
| | | return success(result); |
| | | } |
| | | |
| | | @PostMapping("/power-maxdemand/det-list") |
| | | @Operation(summary = "负荷移植-最大需量发生记录详情") |
| | | public CommonResult<List<PowerMaxdemandDetDTO>> getPowerMaxDemandDetList(@RequestParam Map<String, Object> params) { |
| | | String relId = (String) params.get("relId"); |
| | | if (StringUtils.isBlank(relId)) { |
| | | return error(GlobalErrorCodeConstants.BAD_REQUEST); |
| | | } |
| | | List<PowerMaxdemandDetEntity> list = powerMaxdemandDetService.selectListByRelId(relId); |
| | | return success(ConvertUtils.sourceToTarget(list, PowerMaxdemandDetDTO.class)); |
| | | } |
| | | } |