mescloud/src/main/java/com/jeesite/modules/mes/web/MesDeviceController.java

package com.jeesite.modules.mes.web;

import java.text.SimpleDateFormat;
import java.util.Map;
import java.util.List;
import java.util.Date;
import java.util.Calendar;
import java.util.stream.Collectors;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSON;
import com.jeesite.common.entity.Page;
import com.jeesite.common.lang.ObjectUtils;
import com.jeesite.modules.mes.entity.MesDeviceCate;
import com.jeesite.modules.mes.entity.MesDeviceForm;
import com.jeesite.modules.mes.entity.MesDevicePreventTask;
import com.jeesite.modules.mes.entity.MesDeviceState;
import com.jeesite.modules.mes.entity.MesDeviceUrgency;
import com.jeesite.modules.mes.entity.MesLineProcess;
import com.jeesite.modules.mes.resp.CommonResp;
import com.jeesite.modules.mes.service.MesDeviceCateService;
import com.jeesite.modules.mes.service.MesDevicePreventTaskService;
import com.jeesite.modules.mes.service.MesDeviceStateService;
import com.jeesite.modules.mes.service.MesDeviceUrgencyService;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.jeesite.common.config.Global;
import com.jeesite.common.collect.ListUtils;
import com.jeesite.common.collect.MapUtils;
import com.jeesite.common.lang.StringUtils;
import com.jeesite.common.idgen.IdGen;
import com.jeesite.modules.sys.utils.UserUtils;
import com.jeesite.common.lang.DateUtils;
import com.jeesite.common.utils.excel.ExcelExport;
import com.jeesite.common.utils.excel.annotation.ExcelField.Type;
import org.springframework.web.multipart.MultipartFile;
import com.jeesite.common.web.BaseController;
import com.jeesite.modules.mes.entity.MesDevice;
import com.jeesite.modules.mes.service.MesDeviceService;

/**
 * 设备Controller
 * @author mes
 * @version 2023-07-12
 */
@Controller
@RequestMapping(value = "${adminPath}/mes/mesDevice")
public class MesDeviceController extends BaseController {

	@Autowired
	private MesDeviceService mesDeviceService;

	@Autowired
	private MesDeviceCateService mesDeviceCateService;

	@Autowired
	private MesDevicePreventTaskService mesDevicePreventTaskService;

	@Autowired
	private MesDeviceStateService mesDeviceStateService;

	@Autowired
	private MesDeviceUrgencyService mesDeviceUrgencyService;

	/**
	 * 获取数据
	 */
	@ModelAttribute
	public MesDevice get(String treeCode, boolean isNewRecord) {
		return mesDeviceService.get(treeCode, isNewRecord);
	}

	/**
	 * 管理主页
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "index")
	public String index(MesDevice mesDevice, Model model) {
		model.addAttribute("mesDevice", mesDevice);
		return "modules/mes/mesDeviceIndex";
	}
	
	/**
	 * 查询列表
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = {"list", ""})
	public String list(MesDevice mesDevice, MesDeviceCate mesDeviceCate, Model model) {
		model.addAttribute("mesDevice", mesDevice);
		model.addAttribute("mesDeviceCate", mesDeviceCateService.findList(mesDeviceCate));
		return "modules/mes/mesDeviceList";
	}
	
	/**
	 * 查询列表数据
	 */
//	@RequiresPermissions("mes:mesDevice:view")
//	@RequestMapping(value = "listData")
//	@ResponseBody
//	public List<MesDevice> listData(MesDevice mesDevice) {
//		if (StringUtils.isBlank(mesDevice.getParentCode())) {
//			mesDevice.setParentCode(MesDevice.ROOT_CODE);
//		}
//		if (StringUtils.isNotBlank(mesDevice.getRemark())){
//			mesDevice.setParentCode(null);
//		}
//		if (StringUtils.isNotBlank(mesDevice.getTreeName())){
//			mesDevice.setParentCode(null);
//		}
//		if (StringUtils.isNotBlank(mesDevice.getSn())){
//			mesDevice.setParentCode(null);
//		}
//		if (StringUtils.isNotBlank(mesDevice.getIp())){
//			mesDevice.setParentCode(null);
//		}
//		List<MesDevice> list = mesDeviceService.findList(mesDevice);
//		for (MesDevice i:list){
//			mesDevice.setTreeCode(i.getParentCode());
//			MesDevice parent = mesDeviceService.findByInfo(mesDevice);
//			if(parent==null){
//				i.setParentSn("");
//			}else {
//				i.setParentSn(parent.getSn());
//			}
//		}
//
//		return list;
//	}

	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "listData")
	@ResponseBody
	public Page<MesDevice> listData(MesDevice mesDevice, HttpServletRequest request, HttpServletResponse response) {
//		System.out.println(request.getParameterMap());
		mesDevice.setPage(new Page<>(request, response));
		Page<MesDevice> page = mesDeviceService.findPage(mesDevice);
		return page;
	}

	/**
	 * 查看编辑表单
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "form")
	public String form(MesDevice mesDevice,MesDeviceCate mesDeviceCate, Model model) {
		// 创建并初始化下一个节点信息
		mesDevice = createNextNode(mesDevice);

		logger.info(JSON.toJSONString(mesDevice));
		model.addAttribute("mesDevice", mesDevice);
		model.addAttribute("mesDeviceCate", mesDeviceCateService.findList(mesDeviceCate));
		return "modules/mes/mesDeviceForm";
	}
	/**
	 * 详情
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "detail")
	public String detail(MesDevice mesDevice,MesDeviceCate mesDeviceCate, Model model) {
		// 创建并初始化下一个节点信息
		mesDevice.setTreeCode(mesDevice.getParentCode());
		MesDevice parent = mesDeviceService.findByInfo(mesDevice);
		if(parent==null){
			mesDevice.setParentSn("");
		}else {
			mesDevice.setParentSn(parent.getSn());
		}
		mesDevice = createNextNode(mesDevice);

		model.addAttribute("mesDevice", mesDevice);
		model.addAttribute("mesDeviceCate", mesDeviceCateService.findList(mesDeviceCate));
		return "modules/mes/mesDeviceDetail";
	}
	/**
	 * 创建并初始化下一个节点信息，如：排序号、默认值
	 */
	@RequiresPermissions("mes:mesDevice:edit")
	@RequestMapping(value = "createNextNode")
	@ResponseBody
	public MesDevice createNextNode(MesDevice mesDevice) {
		if (StringUtils.isNotBlank(mesDevice.getParentCode())){
			mesDevice.setParent(mesDeviceService.get(mesDevice.getParentCode()));
		}
		if (mesDevice.getIsNewRecord()) {
			MesDevice where = new MesDevice();
			where.setParentCode(mesDevice.getParentCode());
			MesDevice last = mesDeviceService.getLastByParentCode(where);
			// 获取到下级最后一个节点
			if (last != null){
				mesDevice.setTreeSort(last.getTreeSort() + 30);
				mesDevice.setTreeCode(IdGen.nextCode(last.getTreeCode()));
			}else if (mesDevice.getParent() != null){
				mesDevice.setTreeCode(mesDevice.getParent().getTreeCode() + "001");
			}
		}
		// 以下设置表单默认数据
		if (mesDevice.getTreeSort() == null){
			mesDevice.setTreeSort(MesDevice.DEFAULT_TREE_SORT);
		}
		return mesDevice;
	}

	/**
	 * 保存数据
	 */
	@RequiresPermissions("mes:mesDevice:edit")
	@PostMapping(value = "save")
	@ResponseBody
	public String save(@Validated MesDevice mesDevice) {
		logger.info(JSON.toJSONString(mesDevice));
		MesDevice mesDevice1 = new MesDevice();
		mesDevice1.setDeviceCode(mesDevice.getDeviceCode());
		MesDevice info = mesDeviceService.getByEntity(mesDevice1);
		if (info!=null){
			return renderResult(Global.FALSE, text("保存失败，设备编码已存在！"));
		}
		mesDeviceService.save(mesDevice);
		return renderResult(Global.TRUE, text("保存设备成功！"));
	}

	/**
	 * 导出数据
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "exportData")
	public void exportData(MesDevice mesDevice, HttpServletResponse response) {
		List<MesDevice> list = mesDeviceService.findList(mesDevice);
		String fileName = "设备" + DateUtils.getDate("yyyyMMddHHmmss") + ".xlsx";
		try(ExcelExport ee = new ExcelExport("设备", MesDevice.class)){
			ee.setDataList(list).write(response, fileName);
		}
	}

	/**
	 * 下载模板
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "importTemplate")
	public void importTemplate(HttpServletResponse response) {
		MesDevice mesDevice = new MesDevice();
		List<MesDevice> list = ListUtils.newArrayList(mesDevice);
		String fileName = "设备模板.xlsx";
		try(ExcelExport ee = new ExcelExport("设备", MesDevice.class, Type.IMPORT)){
			ee.setDataList(list).write(response, fileName);
		}
	}

	/**
	 * 导入数据
	 */
	@ResponseBody
	@RequiresPermissions("mes:mesDevice:edit")
	@PostMapping(value = "importData")
	public String importData(MultipartFile file) {
		try {
			String message = mesDeviceService.importData(file);
			return renderResult(Global.TRUE, "posfull:"+message);
		} catch (Exception ex) {
			return renderResult(Global.FALSE, "posfull:"+ex.getMessage());
		}
	}
	
	/**
	 * 停用数据
	 */
	@RequiresPermissions("mes:mesDevice:edit")
	@RequestMapping(value = "disable")
	@ResponseBody
	public String disable(MesDevice mesDevice) {
		MesDevice where = new MesDevice();
		where.setStatus(MesDevice.STATUS_NORMAL);
		where.setParentCodes("," + mesDevice.getId() + ",");
		long count = mesDeviceService.findCount(where);
		if (count > 0) {
			return renderResult(Global.FALSE, text("该设备包含未停用的子设备！"));
		}
		mesDevice.setStatus(MesDevice.STATUS_DISABLE);
		mesDeviceService.updateStatus(mesDevice);
		return renderResult(Global.TRUE, text("停用设备成功"));
	}
	
	/**
	 * 启用数据
	 */
	@RequiresPermissions("mes:mesDevice:edit")
	@RequestMapping(value = "enable")
	@ResponseBody
	public String enable(MesDevice mesDevice) {
		mesDevice.setStatus(MesDevice.STATUS_NORMAL);
		mesDeviceService.updateStatus(mesDevice);
		return renderResult(Global.TRUE, text("启用设备成功"));
	}
	
	/**
	 * 删除数据
	 */
	@RequiresPermissions("mes:mesDevice:edit")
	@RequestMapping(value = "delete")
	@ResponseBody
	public String delete(MesDevice mesDevice) {
		mesDeviceService.delete(mesDevice);
		return renderResult(Global.TRUE, text("删除设备成功！"));
	}
	
	/**
	 * 获取树结构数据
	 * @param excludeCode 排除的Code
	 * @param parentCode 设置父级编码返回一级
	 * @param isShowCode 是否显示编码（true or 1：显示在左侧；2：显示在右侧；false or null：不显示）
	 * @return
	 */
	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "treeData")
	@ResponseBody
	public List<Map<String, Object>> treeData(String excludeCode, String parentCode, String isShowCode) {
		List<Map<String, Object>> mapList = ListUtils.newArrayList();
		MesDevice where = new MesDevice();
		where.setStatus(MesDevice.STATUS_NORMAL);
		if (StringUtils.isNotBlank(parentCode)){
			where.setParentCode(parentCode);
		}
		List<MesDevice> list = mesDeviceService.findList(where);
		for (int i=0; i<list.size(); i++){
			MesDevice e = list.get(i);
			// 过滤非正常的数据
			if (!MesDevice.STATUS_NORMAL.equals(e.getStatus())){
				continue;
			}
			// 过滤被排除的编码（包括所有子级）
			if (StringUtils.isNotBlank(excludeCode)){
				if (e.getId().equals(excludeCode)){
					continue;
				}
				if (e.getParentCodes().contains("," + excludeCode + ",")){
					continue;
				}
			}
			Map<String, Object> map = MapUtils.newHashMap();
			map.put("id", e.getId());
			map.put("pId", e.getParentCode());
			map.put("name", StringUtils.getTreeNodeName(isShowCode, e.getTreeCode(), e.getTreeName()));
			map.put("isParent", !e.getIsTreeLeaf());
			mapList.add(map);
		}
		return mapList;
	}

	/**
	 * 修复表结构相关数据
	 */
	@RequiresPermissions("mes:mesDevice:edit")
	@RequestMapping(value = "fixTreeData")
	@ResponseBody
	public String fixTreeData(MesDevice mesDevice){
		if (!UserUtils.getUser().isAdmin()){
			return renderResult(Global.FALSE, "操作失败，只有管理员才能进行修复！");
		}
		mesDeviceService.fixTreeData();
		return renderResult(Global.TRUE, "数据修复成功");
	}

	/**
	 * api列表数据
	 */
	@RequestMapping(value = "getList")
	@ResponseBody
	public CommonResp getList(MesDevice mesDevice) {
		List<MesDevice> list = mesDeviceService.findList(mesDevice);
		CommonResp<List<MesDevice>> resp = new CommonResp<>();
		resp.setData(list);
		return resp;
	}

	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "qrcode")
	public String qrcode(MesDevice mesDevice, Model model) {
		model.addAttribute("mesDevice", mesDevice);
		return "modules/mes/mesDeviceQrcode";
	}

	@RequestMapping(value = "infoBySn")
	@ResponseBody
	public CommonResp infoBySn(MesDevice mesDevice) {
		CommonResp<MesDevice> resp = new CommonResp<>();
		MesDevice info = mesDeviceService.findInfoBySn(mesDevice.getSn());
		if(ObjectUtils.isEmpty(info)){
			resp.setResult("false");
			resp.setMessage("设备不存在");
			return resp;
		}

		resp.setData(info);
		return resp;
	}

	@RequiresPermissions("mes:mesDevice:view")
	@RequestMapping(value = "map")
	public String map(MesDevice mesDevice, Model model) {
		model.addAttribute("mesDevice", mesDevice);
		return "modules/mes/equipment/equipment_map";
	}

	@RequestMapping(value = "oeeScreen")
	public String oeeScreen(Model model) {
		return "modules/mes/mesDeviceOeeScreen";
	}

	@RequestMapping(value = "screen5Data")
	@ResponseBody
	public CommonResp<Map<String, Object>> screen5Data() {
		CommonResp<Map<String, Object>> resp = new CommonResp<>();
		Map<String, Object> data = MapUtils.newHashMap();
		Date now = new Date();
		Date weekStart = DateUtils.addDays(now, -7);

		data.put("deviceCount", mesDeviceService.findList(new MesDevice()).size());

		MesDevicePreventTask preventQuery = new MesDevicePreventTask();
		preventQuery.setStartDate_gte(weekStart);
		preventQuery.setStartDate_lte(now);
		List<MesDevicePreventTask> preventList = mesDevicePreventTaskService.findList(preventQuery);
		data.put("preventiveCount", preventList.size());

		List<Map<String, Object>> preventiveStatus = ListUtils.newArrayList();
		long pending = preventList.stream().filter(p -> "0".equals(p.getState())).count();
		long processing = preventList.stream().filter(p -> "1".equals(p.getState())).count();
		long completed = preventList.stream().filter(p -> "2".equals(p.getState())).count();
		long unfinished = preventList.stream().filter(p -> "3".equals(p.getState())).count();

		Map<String, Object> pendingMap = MapUtils.newHashMap();
		pendingMap.put("name", "未开始");
		pendingMap.put("value", pending);
		preventiveStatus.add(pendingMap);

		Map<String, Object> processingMap = MapUtils.newHashMap();
		processingMap.put("name", "进行中");
		processingMap.put("value", processing);
		preventiveStatus.add(processingMap);

		Map<String, Object> completedMap = MapUtils.newHashMap();
		completedMap.put("name", "已完成");
		completedMap.put("value", completed);
		preventiveStatus.add(completedMap);

		Map<String, Object> unfinishedMap = MapUtils.newHashMap();
		unfinishedMap.put("name", "未完成");
		unfinishedMap.put("value", unfinished);
		preventiveStatus.add(unfinishedMap);

		data.put("preventiveStatus", preventiveStatus);
		data.put("preventiveList", preventList.stream().limit(10).collect(Collectors.toList()));

		MesDeviceUrgency urgencyQuery = new MesDeviceUrgency();
		urgencyQuery.setStartDate_gte(weekStart);
		urgencyQuery.setStartDate_lte(now);
		List<MesDeviceUrgency> urgencyList = mesDeviceUrgencyService.findList(urgencyQuery);
		data.put("urgencyCount", urgencyList.size());

		List<Map<String, Object>> urgencyStatus = ListUtils.newArrayList();
		long urgencyPending = urgencyList.stream().filter(u -> "0".equals(u.getState())).count();
		long urgencyCompleted = urgencyList.stream().filter(u -> "1".equals(u.getState())).count();

		Map<String, Object> urgencyPendingMap = MapUtils.newHashMap();
		urgencyPendingMap.put("name", "维修中");
		urgencyPendingMap.put("value", urgencyPending);
		urgencyPendingMap.put("color", "#ff9800");
		urgencyStatus.add(urgencyPendingMap);

		Map<String, Object> urgencyCompletedMap = MapUtils.newHashMap();
		urgencyCompletedMap.put("name", "已完成");
		urgencyCompletedMap.put("value", urgencyCompleted);
		urgencyCompletedMap.put("color", "#00d5d8");
		urgencyStatus.add(urgencyCompletedMap);

		data.put("urgencyStatus", urgencyStatus);

		Map<String, Long> contentCount = urgencyList.stream()
				.filter(u -> StringUtils.isNotBlank(u.getContent()))
				.collect(Collectors.groupingBy(u -> u.getContent(), Collectors.counting()));
		List<Map<String, Object>> urgencyContent = ListUtils.newArrayList();
		contentCount.entrySet().stream()
				.sorted((a, b) -> Long.compare(b.getValue(), a.getValue()))
				.limit(6)
				.forEach(e -> {
					Map<String, Object> contentMap = MapUtils.newHashMap();
					contentMap.put("name", e.getKey());
					contentMap.put("value", e.getValue());
					urgencyContent.add(contentMap);
				});
		data.put("urgencyContent", urgencyContent);
		data.put("urgencyList", urgencyList.stream().limit(10).collect(Collectors.toList()));
		data.put("weekStart", DateUtils.formatDate(weekStart, "yyyy-MM-dd HH:mm:ss"));
		data.put("weekEnd", DateUtils.formatDate(now, "yyyy-MM-dd HH:mm:ss"));

		resp.setData(data);
		resp.setResult(Global.TRUE);
		return resp;
	}

	@RequestMapping(value = "oeeScreenData")
	@ResponseBody
	public CommonResp<Map<String, Object>> oeeScreenData() {
		CommonResp<Map<String, Object>> resp = new CommonResp<>();
		Map<String, Object> data = MapUtils.newHashMap();
		Date now = new Date();
		Calendar calendar = Calendar.getInstance();
		calendar.set(Calendar.HOUR_OF_DAY, 0);
		calendar.set(Calendar.MINUTE, 0);
		calendar.set(Calendar.SECOND, 0);
		calendar.set(Calendar.MILLISECOND, 0);
		Date todayStart = calendar.getTime();
		long elapsedSeconds = Math.max(1L, (now.getTime() - todayStart.getTime()) / 1000);

		List<MesDevice> devices = mesDeviceService.findList(new MesDevice());
		List<Map<String, Object>> deviceCards = ListUtils.newArrayList();
		List<Map<String, Object>> ranking = ListUtils.newArrayList();
		long runningCount = 0;
		long faultCount = 0;
		long maintenanceCount = 0;
		long alarmCount = 0;
		long offlineCount = 0;
		long unknownCount = 0;
		long totalRunningSeconds = 0;

		for (int i = 0; i < devices.size(); i++) {
			MesDevice device = devices.get(i);
			MesDeviceState latestQuery = new MesDeviceState();
			latestQuery.setDeviceSn(device.getSn());
			MesDeviceState latestState = StringUtils.isBlank(device.getSn()) ? null : mesDeviceStateService.findInfo(latestQuery);
			String state = latestState != null && StringUtils.isNotBlank(latestState.getState()) ? latestState.getState() : device.getWorkStatus();
			String statusCode = getDeviceScreenStatus(device, state);
			if ("running".equals(statusCode)) {
				runningCount++;
			} else if ("fault".equals(statusCode)) {
				faultCount++;
			} else if ("maintenance".equals(statusCode)) {
				maintenanceCount++;
			} else if ("alarm".equals(statusCode)) {
				alarmCount++;
			} else if ("offline".equals(statusCode)) {
				offlineCount++;
			} else {
				unknownCount++;
			}

			MesDeviceState stateQuery = new MesDeviceState();
			stateQuery.setDeviceSn(device.getSn());
			stateQuery.setStartDate_gte(todayStart);
			stateQuery.setStartDate_lte(now);
			List<MesDeviceState> stateList = StringUtils.isBlank(device.getSn()) ? ListUtils.newArrayList() : mesDeviceStateService.findList(stateQuery);
			long runningSeconds = getRunningSeconds(stateList, todayStart, now);
			if (isRunningState(state) && latestState != null && latestState.getStartDate() != null && latestState.getStartDate().before(todayStart)) {
				runningSeconds = elapsedSeconds;
			}
			if (runningSeconds <= 0 && isRunningState(state)) {
				runningSeconds = getRunningSecondsFromWorkTime(device.getWorkTime(), todayStart, now);
			}
			totalRunningSeconds += runningSeconds;
			double openRate = Math.min(100D, runningSeconds * 100D / elapsedSeconds);

			Map<String, Object> card = MapUtils.newHashMap();
			card.put("name", getText(device.getTreeName(), getText(device.getSn(), "-")));
			card.put("sn", getText(device.getSn(), "-"));
			card.put("deviceCode", getText(device.getDeviceCode(), "-"));
			card.put("lineSn", getText(device.getLineSn(), "-"));
			card.put("imagePath", getFirstImagePath(device.getImagePath()));
			card.put("statusCode", statusCode);
			card.put("statusName", getDeviceScreenStatusName(statusCode));
			card.put("stateName", getDeviceStateName(state));
			card.put("openRate", Math.round(openRate * 10D) / 10D);
			card.put("openMinutes", Math.round(runningSeconds / 60D));
			card.put("lastReportTime", latestState != null && latestState.getStartDate() != null ? DateUtils.formatDate(latestState.getStartDate(), "HH:mm:ss") : "-");
			card.put("lastReportDate", latestState != null && latestState.getStartDate() != null ? DateUtils.formatDate(latestState.getStartDate(), "yyyy-MM-dd HH:mm:ss") : "-");
			card.put("imageIndex", i % 8 + 1);
			deviceCards.add(card);

			Map<String, Object> rankItem = MapUtils.newHashMap();
			rankItem.put("name", card.get("name"));
			rankItem.put("sn", card.get("sn"));
			rankItem.put("openRate", card.get("openRate"));
			ranking.add(rankItem);
		}

		ranking.sort((a, b) -> Double.compare(Double.valueOf(String.valueOf(b.get("openRate"))), Double.valueOf(String.valueOf(a.get("openRate")))));
		if (ranking.size() > 10) {
			ranking = ranking.subList(0, 10);
		}

		List<Map<String, Object>> statusList = ListUtils.newArrayList();
		addStatusItem(statusList, "运行", runningCount, "#35f2c2");
		addStatusItem(statusList, "故障", faultCount, "#ff5f6d");
		addStatusItem(statusList, "维修", maintenanceCount, "#ffc857");
		addStatusItem(statusList, "报警", alarmCount, "#ff8a3d");
		addStatusItem(statusList, "离线", offlineCount, "#7d8da8");
		addStatusItem(statusList, "未知", unknownCount, "#49a7ff");

		double avgOpenRate = devices.isEmpty() ? 0D : totalRunningSeconds * 100D / (elapsedSeconds * devices.size());
		data.put("deviceTotal", devices.size());
		data.put("runningCount", runningCount);
		data.put("faultCount", faultCount);
		data.put("offlineCount", offlineCount);
		data.put("avgOpenRate", Math.round(avgOpenRate * 10D) / 10D);
		data.put("statusList", statusList);
		data.put("ranking", ranking);
		data.put("devices", deviceCards);
		data.put("statDate", DateUtils.formatDate(now, "yyyy-MM-dd"));
		data.put("statTime", DateUtils.formatDate(now, "HH:mm:ss"));
		data.put("dataNote", "当前系统缺少计划产量、良品数、理想节拍，页面展示的是基于设备状态记录计算的开动率。");
		resp.setData(data);
		resp.setResult(Global.TRUE);
		return resp;
	}

	private long getRunningSeconds(List<MesDeviceState> stateList, Date todayStart, Date now) {
		long runningSeconds = 0L;
		for (MesDeviceState state : stateList) {
			if (!isRunningState(state.getState()) || state.getStartDate() == null) {
				continue;
			}
			Date start = state.getStartDate().before(todayStart) ? todayStart : state.getStartDate();
			Date end = state.getEndDate();
			if (end == null && state.getInterval() != null) {
				end = new Date(state.getStartDate().getTime() + state.getInterval() * 1000L);
			}
			if (end == null || end.after(now)) {
				end = now;
			}
			if (end.after(start)) {
				runningSeconds += (end.getTime() - start.getTime()) / 1000;
			}
		}
		return runningSeconds;
	}

	private long getRunningSecondsFromWorkTime(String workTime, Date todayStart, Date now) {
		if (StringUtils.isBlank(workTime)) {
			return 0L;
		}
		Date start = parseWorkTime(workTime);
		if (start == null) {
			return 0L;
		}
		if (start.before(todayStart)) {
			start = todayStart;
		}
		if (!now.after(start)) {
			return 0L;
		}
		return (now.getTime() - start.getTime()) / 1000;
	}

	private Date parseWorkTime(String workTime) {
		String[] patterns = {"yyyy-MM-dd HH:mm:ss", "yyyy-MM-dd HH:mm", "yyyy/MM/dd HH:mm:ss", "yyyy/MM/dd HH:mm"};
		for (String pattern : patterns) {
			try {
				return new SimpleDateFormat(pattern).parse(workTime);
			} catch (Exception ignored) {
			}
		}
		return null;
	}

	private boolean isRunningState(String state) {
		return "1".equals(state) || "2".equals(state);
	}

	private String getDeviceScreenStatus(MesDevice device, String state) {
		if (device.getOnline() != null && device.getOnline() == 1) {
			return "offline";
		}
		if ("3".equals(state)) {
			return "fault";
		}
		if ("4".equals(state)) {
			return "maintenance";
		}
		if ("5".equals(state) || "6".equals(state)) {
			return "alarm";
		}
		if (isRunningState(state)) {
			return "running";
		}
		return "unknown";
	}

	private String getDeviceScreenStatusName(String statusCode) {
		if ("running".equals(statusCode)) {
			return "运行";
		}
		if ("fault".equals(statusCode)) {
			return "故障";
		}
		if ("maintenance".equals(statusCode)) {
			return "维修";
		}
		if ("alarm".equals(statusCode)) {
			return "报警";
		}
		if ("offline".equals(statusCode)) {
			return "离线";
		}
		return "未知";
	}

	private String getDeviceStateName(String state) {
		if ("1".equals(state)) {
			return "正常";
		}
		if ("2".equals(state)) {
			return "手动";
		}
		if ("3".equals(state)) {
			return "故障";
		}
		if ("4".equals(state)) {
			return "维修";
		}
		if ("5".equals(state)) {
			return "质量报警";
		}
		if ("6".equals(state)) {
			return "物流堵料";
		}
		return "未知";
	}

	private void addStatusItem(List<Map<String, Object>> list, String name, long value, String color) {
		Map<String, Object> item = MapUtils.newHashMap();
		item.put("name", name);
		item.put("value", value);
		item.put("color", color);
		list.add(item);
	}

	private String getText(String value, String defaultValue) {
		return StringUtils.isBlank(value) ? defaultValue : value;
	}

	private String getFirstImagePath(String imagePath) {
		if (StringUtils.isBlank(imagePath)) {
			return "";
		}
		String[] paths = imagePath.split("\\|");
		for (String path : paths) {
			if (StringUtils.isNotBlank(path)) {
				return path;
			}
		}
		return "";
	}

}