package com.zhitan.web.controller.keyequipment; import com.zhitan.common.core.controller.BaseController; import com.zhitan.common.core.domain.AjaxResult; import com.zhitan.keyequipment.domain.MonthlyKeyEquipment; import com.zhitan.keyequipment.service.IMonthlyKeyEquipmentService; import com.zhitan.model.domain.EnergyIndex; import com.zhitan.model.domain.ModelNode; import com.zhitan.model.service.IModelNodeService; import com.zhitan.realtimedata.domain.DataItem; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.apache.commons.collections4.CollectionUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; import java.util.stream.Collectors; /** * 重点设备能耗统计 月 * * @author sys * @date 2021-01-11 */ @RestController @RequestMapping("/keyEquipment/MonthlyKeyEquipment") @Api(value = "重点设备能耗统计(月)", tags = {"设备单耗分析"}) public class MonthlyKeyEquipmentController extends BaseController { @Autowired private IModelNodeService modelNodeService; @Autowired private IMonthlyKeyEquipmentService monthlyKeyEquipmentService; @GetMapping("/list") @ApiOperation(value = "重点设备能耗统计(月)列表") public AjaxResult list(DataItem dataItem) throws ParseException { List 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++; } List table = new ArrayList<>(); MonthlyKeyEquipment reportList = new MonthlyKeyEquipment(); table.add(tableColumn); reportList.setTablehead(table); List nodeId = modelNodeService.getModelNodeByModelCode(dataItem.getIndexCode()); if (CollectionUtils.isEmpty(nodeId)) { return success(new ArrayList<>()); } List energyList = modelNodeService.getSettingIndex(nodeId.get(0).getNodeId()); if (CollectionUtils.isEmpty(energyList)) { return success(new ArrayList<>()); } List indexIds = energyList.stream().map(EnergyIndex::getIndexId).collect(Collectors.toList()); List list = monthlyKeyEquipmentService.getMonthlyKeyEquipmentList(indexIds, dataList, dataItem.getBeginTime(), dataItem.getEndTime(), dataItem.getTimeType(), dataItem.getEnergyType()); return success(list); } @GetMapping("/listChart") @ApiOperation(value = "重点设备能耗统计(月)图表") 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"; 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)); List 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]); //月 Calendar cal = Calendar.getInstance(); // 设置年份 cal.set(Calendar.YEAR, year); // 设置月份 // cal.set(Calendar.MONTH, month - 1); cal.set(Calendar.MONTH, month); //设置当前月的上一个月 // 获取某月最大天数 //int lastDay = cal.getActualMaximum(Calendar.DATE); int lastDay = cal.getMinimum(Calendar.DATE); //获取月份中的最小值,即第一天 // 设置日历中月份的最大天数 //cal.set(Calendar.DAY_OF_MONTH, lastDay); cal.set(Calendar.DAY_OF_MONTH, lastDay - 1); //上月的第一天减去1就是当月的最后一天 // 格式化日期 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); return sdf.format(cal.getTime()); } }