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<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++;
|
}
|
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")
|
@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<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]); //月
|
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());
|
}
|
}
|
