| | |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDateTime; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | ); |
| | | //修改灯杆任务绑定关系表 |
| | | for (LightTaskPoleRelation bean : lightTaskPoleRelationList) { |
| | | LightTaskPoleRelation one = lightTaskPoleRelationService.getOne(Wrappers.lambdaQuery(LightTaskPoleRelation.class).eq(LightTaskPoleRelation::getPoleId, bean.getPoleId())); |
| | | |
| | | //成功才修改,失败不变 |
| | | if (bean.getIssueStatus() == 0) { |
| | | |
| | | LightTaskPoleRelation one = lightTaskPoleRelationService.getOne(Wrappers.lambdaQuery(LightTaskPoleRelation.class).eq(LightTaskPoleRelation::getPoleId, bean.getPoleId())); |
| | | if (one != null) { |
| | | one.setTaskId(newLightTask.getTaskId()); |
| | | lightTaskPoleRelationService.updateById(one); |
| | | } else { |
| | | lightTaskPoleRelationService.save(bean); |
| | | } |
| | | } else { |
| | | if (one == null) { |
| | | lightTaskPoleRelationService.save(bean); |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | //计算功率及能耗 |
| | | /** |
| | | * 计算功率及能耗 |
| | | */ |
| | | public void energy() { |
| | | List<LightTask> lightTasks = list(Wrappers.lambdaQuery(LightTask.class)); |
| | | for (LightTask lightTask : lightTasks) { |
| | |
| | | LocalDateTime now = LocalDateTime.now(); |
| | | LocalDateTime yesterday = now.minusDays(1); |
| | | |
| | | |
| | | LightEnergyData lightEnergyData = new LightEnergyData(); |
| | | lightEnergyData.setTaskId(lightTask.getTaskId()); |
| | | lightEnergyData.setYtdTime(yesterday); |
| | | lightEnergyData.setYtdTime(yesterday.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))); |
| | | lightEnergyData.setEnergySaving(energySaving); |
| | | lightEnergyData.setEnergy(energy); |
| | | lightEnergyData.setUserId(lightTask.getUserId()); |
| | | lightEnergyData.setClientId(lightTask.getClientId()); |
| | | |
| | | //保存能耗数据到数据库 |
| | | lightEnergyDataService.save(lightEnergyData); |
| | | |
| | | System.out.println(lightEnergyData + "---------------"); |
| | | //ID 任务id |
| | | } |