From 031c781b881ba66b09451c52aa24477a010b5750 Mon Sep 17 00:00:00 2001 From: zt916916 <1903964620@qq.com> Date: 星期三, 19 三月 2025 16:28:13 +0800 Subject: [PATCH] 重点设备能耗日月年 --- zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/MonthlyKeyEquipmentController.java | 104 +++++++++++++++------------------- zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/DailyKeyEquipmenteController.java | 14 ++-- zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/YearKeyEquipmentController.java | 11 +-- 3 files changed, 59 insertions(+), 70 deletions(-) diff --git a/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/DailyKeyEquipmenteController.java b/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/DailyKeyEquipmenteController.java index 07dbc79..ac287f6 100644 --- a/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/DailyKeyEquipmenteController.java +++ b/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/DailyKeyEquipmenteController.java @@ -3,7 +3,6 @@ import com.zhitan.basicdata.domain.FacilityArchives; import com.zhitan.common.core.controller.BaseController; import com.zhitan.common.core.domain.AjaxResult; -import com.zhitan.common.core.page.TableDataInfo; import com.zhitan.keyequipment.domain.DailyKeyEquipment; import com.zhitan.keyequipment.service.IDailyKeyEquipmentService; import com.zhitan.model.domain.EnergyIndex; @@ -43,14 +42,14 @@ @GetMapping("/list") @ApiOperation(value = "閲嶇偣璁惧鑳借�楀垎鏋愶紙鏃ワ級鍒楄〃") - public TableDataInfo list(DataItem dataItem) throws ParseException { + public AjaxResult list(DataItem dataItem) throws ParseException { List<ModelNode> nodeId = modelNodeService.getModelNodeByModelCode(dataItem.getIndexCode()); if(CollectionUtils.isEmpty(nodeId)){ - return getDataTable(new ArrayList<>()); + return success(new ArrayList<>()); } List<EnergyIndex> energyList = modelNodeService.getSettingIndex(nodeId.get(0).getNodeId()); if(CollectionUtils.isEmpty(energyList)){ - return getDataTable(new ArrayList<>()); + return success(new ArrayList<>()); } List<String> indexIds = energyList.stream().map(EnergyIndex::getIndexId).collect(Collectors.toList()); List<DailyKeyEquipment> dataList=new ArrayList<>(); @@ -74,9 +73,10 @@ dataList.add(report); i++; }; - startPage(); + List<DailyKeyEquipment> list = dailykeyEquipment.getdailyKeyEquipmentList(indexIds, dataList,dataItem.getBeginTime(),dataItem.getEndTime(), dataItem.getTimeType(),dataItem.getEnergyType()); - return getDataTable(list); + + return success(list); } @GetMapping("/listChart") @@ -93,7 +93,7 @@ } /*鎵�鏈夎澶�*/ @GetMapping("/getFacilityArchives") - @ApiOperation(value = "鏌ヨ鎵�鏈夎澶囧垪琛�") + @ApiOperation(value = "鏌ヨ閲嶇偣璁惧鍒楄〃") public AjaxResult getFacilityArchives() { try { List<FacilityArchives> list=dailykeyEquipment.getFacilityArchives(); diff --git a/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/MonthlyKeyEquipmentController.java b/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/MonthlyKeyEquipmentController.java index 7cb93ba..11164fc 100644 --- a/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/MonthlyKeyEquipmentController.java +++ b/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/MonthlyKeyEquipmentController.java @@ -1,7 +1,6 @@ package com.zhitan.web.controller.keyequipment; -import com.github.pagehelper.PageInfo; import com.zhitan.common.core.controller.BaseController; import com.zhitan.common.core.domain.AjaxResult; import com.zhitan.keyequipment.domain.MonthlyKeyEquipment; @@ -25,14 +24,14 @@ import java.util.stream.Collectors; /** - *閲嶇偣璁惧鑳借�楃粺璁� 鏈� + * 閲嶇偣璁惧鑳借�楃粺璁� 鏈� * * @author sys * @date 2021-01-11 */ @RestController @RequestMapping("/keyEquipment/MonthlyKeyEquipment") -@Api(value = "閲嶇偣璁惧鑳借�楃粺璁★紙鏈堬級",tags = {"璁惧鍗曡�楀垎鏋�"}) +@Api(value = "閲嶇偣璁惧鑳借�楃粺璁★紙鏈堬級", tags = {"璁惧鍗曡�楀垎鏋�"}) public class MonthlyKeyEquipmentController extends BaseController { @Autowired @@ -42,59 +41,49 @@ @GetMapping("/list") @ApiOperation(value = "閲嶇偣璁惧鑳借�楃粺璁★紙鏈堬級鍒楄〃") - public AjaxResult list(DataItem dataItem) { - try { - List<MonthlyKeyEquipment> dataList=new ArrayList<>(); + public AjaxResult list(DataItem dataItem) throws ParseException { + List<MonthlyKeyEquipment> dataList = new ArrayList<>(); - Map tableColumn =new HashMap<>();//琛ㄦ暟鎹� - DateFormat df = new SimpleDateFormat("yyyy-MM"); - SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - String aa= df.format(dataItem.getDataTime()); - String bb=""; - int i = 1; - String beginTime=aa+"-01 00:00:00"; - dataItem.setBeginTime(sf.parse(beginTime)); - String endTime=aa+"-"+Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length()-2))+" 00:00:00"; - dataItem.setEndTime(sf.parse(endTime)); - while (i <= Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length()-2))) { - if(i>9){ - bb=aa+"-"+i+" 00:00:00"; - }else{ - bb=aa+"-0"+i+" 00:00:00"; - } - MonthlyKeyEquipment report=new MonthlyKeyEquipment(); - report.setDataTime(sf.parse(bb)); - report.setValue("value"+i); - dataList.add(report); - tableColumn.put("value"+i,String.valueOf(i)+"鏃�"); - i++; + Map tableColumn = new HashMap<>();//琛ㄦ暟鎹� + DateFormat df = new SimpleDateFormat("yyyy-MM"); + SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String aa = df.format(dataItem.getDataTime()); + String bb = ""; + int i = 1; + String beginTime = aa + "-01 00:00:00"; + dataItem.setBeginTime(sf.parse(beginTime)); + String endTime = aa + "-" + Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length() - 2)) + " 00:00:00"; + dataItem.setEndTime(sf.parse(endTime)); + while (i <= Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length() - 2))) { + if (i > 9) { + bb = aa + "-" + i + " 00:00:00"; + } else { + bb = aa + "-0" + i + " 00:00:00"; } - List<Map> table=new ArrayList<>(); - MonthlyKeyEquipment reportList =new MonthlyKeyEquipment(); - table.add(tableColumn); - reportList.setTablehead(table); - List<ModelNode> nodeId = modelNodeService.getModelNodeByModelCode(dataItem.getIndexCode()); - if(CollectionUtils.isEmpty(nodeId)){ - return AjaxResult.success(reportList); - } - List<EnergyIndex> energyList = modelNodeService.getSettingIndex(nodeId.get(0).getNodeId()); - if(CollectionUtils.isEmpty(energyList)){ - return AjaxResult.success(reportList); - } - List<String> indexIds = energyList.stream().map(EnergyIndex::getIndexId).collect(Collectors.toList()); - - startPage(); - List<MonthlyKeyEquipment> list = monthlyKeyEquipmentService.getMonthlyKeyEquipmentList(indexIds, dataList,dataItem.getBeginTime(),dataItem.getEndTime(), dataItem.getTimeType(),dataItem.getEnergyType()); - int count=Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length()-2)); - list.forEach(monthlyReport -> monthlyReport.setCount(count)); - reportList.setTabledata(list); - reportList.setTotal(new PageInfo(list).getTotal()); - - return AjaxResult.success(reportList); - } catch (Exception ex) { - logger.error("鑾峰彇鍑洪敊锛�", ex); - return AjaxResult.error("鑾峰彇鍑洪敊!"); + MonthlyKeyEquipment report = new MonthlyKeyEquipment(); + report.setDataTime(sf.parse(bb)); + report.setValue("value" + i); + dataList.add(report); + tableColumn.put("value" + i, String.valueOf(i) + "鏃�"); + i++; } + List<Map> table = new ArrayList<>(); + MonthlyKeyEquipment reportList = new MonthlyKeyEquipment(); + table.add(tableColumn); + reportList.setTablehead(table); + List<ModelNode> nodeId = modelNodeService.getModelNodeByModelCode(dataItem.getIndexCode()); + if (CollectionUtils.isEmpty(nodeId)) { + return success(new ArrayList<>()); + } + List<EnergyIndex> energyList = modelNodeService.getSettingIndex(nodeId.get(0).getNodeId()); + if (CollectionUtils.isEmpty(energyList)) { + return success(new ArrayList<>()); + } + List<String> indexIds = energyList.stream().map(EnergyIndex::getIndexId).collect(Collectors.toList()); + + List<MonthlyKeyEquipment> list = monthlyKeyEquipmentService.getMonthlyKeyEquipmentList(indexIds, dataList, dataItem.getBeginTime(), dataItem.getEndTime(), dataItem.getTimeType(), dataItem.getEnergyType()); + + return success(list); } @GetMapping("/listChart") @@ -102,14 +91,15 @@ public AjaxResult listChart(DataItem dataItem) throws ParseException { DateFormat df = new SimpleDateFormat("yyyy-MM"); SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - String aa= df.format(dataItem.getDataTime()); - String beginTime=aa+"-01 00:00:00"; + String aa = df.format(dataItem.getDataTime()); + String beginTime = aa + "-01 00:00:00"; dataItem.setBeginTime(sf.parse(beginTime)); - String endTime=aa+"-"+Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length()-2))+" 00:00:00"; + String endTime = aa + "-" + Integer.valueOf(getLastDayOfMonth(aa).substring(getLastDayOfMonth(aa).length() - 2)) + " 00:00:00"; dataItem.setEndTime(sf.parse(endTime)); - List<MonthlyKeyEquipment> list = monthlyKeyEquipmentService.getListChart(dataItem.getIndexId(),dataItem.getBeginTime(),dataItem.getEndTime(), dataItem.getTimeType(),dataItem.getEnergyType()); + List<MonthlyKeyEquipment> list = monthlyKeyEquipmentService.getListChart(dataItem.getIndexId(), dataItem.getBeginTime(), dataItem.getEndTime(), dataItem.getTimeType(), dataItem.getEnergyType()); return AjaxResult.success(list); } + public static String getLastDayOfMonth(String yearMonth) { int year = Integer.parseInt(yearMonth.split("-")[0]); //骞� int month = Integer.parseInt(yearMonth.split("-")[1]); //鏈� diff --git a/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/YearKeyEquipmentController.java b/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/YearKeyEquipmentController.java index 4b1b56b..4d24ed4 100644 --- a/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/YearKeyEquipmentController.java +++ b/zhitan-admin/src/main/java/com/zhitan/web/controller/keyequipment/YearKeyEquipmentController.java @@ -3,7 +3,6 @@ import cn.hutool.core.date.DateUtil; import com.zhitan.common.core.controller.BaseController; import com.zhitan.common.core.domain.AjaxResult; -import com.zhitan.common.core.page.TableDataInfo; import com.zhitan.keyequipment.domain.YearKeyEquipment; import com.zhitan.keyequipment.service.IYearKeyEquipmentService; import com.zhitan.model.domain.EnergyIndex; @@ -43,14 +42,14 @@ @GetMapping("/list") @ApiOperation(value = "閲嶇偣璁惧鑳借�楃粺璁★紙骞达級鍒楄〃") - public TableDataInfo list(DataItem dataItem) throws ParseException { + public AjaxResult list(DataItem dataItem) throws ParseException { List<ModelNode> nodeId = modelNodeService.getModelNodeByModelCode(dataItem.getIndexCode()); if(CollectionUtils.isEmpty(nodeId)){ - return getDataTable(new ArrayList<>()); + return success(new ArrayList<>()); } List<EnergyIndex> energyList = modelNodeService.getSettingIndex(nodeId.get(0).getNodeId()); if(CollectionUtils.isEmpty(energyList)){ - return getDataTable(new ArrayList<>()); + return success(new ArrayList<>()); } List<String> indexIds = energyList.stream().map(EnergyIndex::getIndexId).collect(Collectors.toList()); List<YearKeyEquipment> dataList=new ArrayList<>(); @@ -75,9 +74,9 @@ dataList.add(report); i++; } - startPage(); + List<YearKeyEquipment> list = yearKeyEquipmentService.getYearKeyEquipmentList(indexIds, dataList,dataItem.getBeginTime(),dataItem.getEndTime(), dataItem.getTimeType(),dataItem.getEnergyType()); - return getDataTable(list); + return success(list); } @GetMapping("/listChart") -- Gitblit v1.9.3