package org.jeecg.modules.mdc.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.apache.commons.lang.StringUtils; import org.apache.shiro.SecurityUtils; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.modules.mdc.dto.EquipmentElectricStatisticalDto; import org.jeecg.modules.mdc.entity.EquipmentElectricStatistical; import org.jeecg.modules.mdc.mapper.EquipmentElectricStatisticalMapper; import org.jeecg.modules.mdc.service.IEquipmentElectricStatisticalService; import org.jeecg.modules.mdc.service.IMdcEquipmentService; import org.jeecg.modules.mdc.util.DateUtils; import org.jeecg.modules.mdc.vo.EquipmentElectricStatisticalVo; import org.jeecgframework.poi.excel.def.NormalExcelConstants; import org.jeecgframework.poi.excel.entity.ExportParams; import org.jeecgframework.poi.excel.view.JeecgEntityExcelView; import org.springframework.stereotype.Service; import org.springframework.web.servlet.ModelAndView; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import java.util.ArrayList; import java.util.Collections; import java.util.Date; import java.util.List; /** * @Description: 设备电流统计 * @Author: jeecg-boot * @Date: 2024-07-16 * @Version: V1.0 */ @Service public class EquipmentElectricStatisticalServiceImpl extends ServiceImpl implements IEquipmentElectricStatisticalService { @Resource private IMdcEquipmentService mdcEquipmentService; @Override public IPage pageList(String userId, Page page, EquipmentElectricStatisticalVo equipmentElectricStatisticalVo, HttpServletRequest req) { List equipmentIds = new ArrayList<>(); if (StringUtils.isNotEmpty(equipmentElectricStatisticalVo.getParentId()) && StringUtils.isEmpty(equipmentElectricStatisticalVo.getEquipmentId())) { if ("2".equals(equipmentElectricStatisticalVo.getTypeTree())) { //部门层级 equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, equipmentElectricStatisticalVo.getParentId()); } else { //产线层级 equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, equipmentElectricStatisticalVo.getParentId()); } } else if (StringUtils.isNotEmpty(equipmentElectricStatisticalVo.getEquipmentId())) { //单台设备信息 equipmentElectricStatisticalVo.setEquipmentIdList(Collections.singletonList(equipmentElectricStatisticalVo.getEquipmentId())); } else { //查询用户拥有的所有设备信息 if ("2".equals(equipmentElectricStatisticalVo.getTypeTree())) { //部门层级 equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null); } else { //产线层级 equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null); } } if (equipmentElectricStatisticalVo.getEquipmentIdList() == null || equipmentElectricStatisticalVo.getEquipmentIdList().isEmpty()) { equipmentElectricStatisticalVo.setEquipmentIdList(equipmentIds); } if (equipmentElectricStatisticalVo.getEquipmentIdList() == null || equipmentElectricStatisticalVo.getEquipmentIdList().isEmpty()) { return null; } return this.baseMapper.pageList(page, equipmentElectricStatisticalVo); } @Override public ModelAndView exportXls(String userId, EquipmentElectricStatisticalVo equipmentElectricStatisticalVo) { List equipmentIds = new ArrayList<>(); if (StringUtils.isNotEmpty(equipmentElectricStatisticalVo.getParentId()) && StringUtils.isEmpty(equipmentElectricStatisticalVo.getEquipmentId())) { if ("2".equals(equipmentElectricStatisticalVo.getTypeTree())) { //部门层级 equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, equipmentElectricStatisticalVo.getParentId()); } else { //产线层级 equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, equipmentElectricStatisticalVo.getParentId()); } } else if (StringUtils.isNotEmpty(equipmentElectricStatisticalVo.getEquipmentId())) { //单台设备信息 equipmentElectricStatisticalVo.setEquipmentIdList(Collections.singletonList(equipmentElectricStatisticalVo.getEquipmentId())); } else { //查询用户拥有的所有设备信息 if ("2".equals(equipmentElectricStatisticalVo.getTypeTree())) { //部门层级 equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null); } else { //产线层级 equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null); } } if (equipmentElectricStatisticalVo.getEquipmentIdList() == null || equipmentElectricStatisticalVo.getEquipmentIdList().isEmpty()) { equipmentElectricStatisticalVo.setEquipmentIdList(equipmentIds); } if (equipmentElectricStatisticalVo.getEquipmentIdList() == null || equipmentElectricStatisticalVo.getEquipmentIdList().isEmpty()) { return null; } // Step.2 AutoPoi 导出Excel ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); List equipmentElectricStatisticals = this.baseMapper.list(equipmentElectricStatisticalVo); // 导出文件名称 mv.addObject(NormalExcelConstants.FILE_NAME, "设备电流统计列表"); mv.addObject(NormalExcelConstants.CLASS, EquipmentElectricStatistical.class); //获取当前登录用户 //update-begin---author:wangshuai ---date:20211227 for:[JTC-116]导出人写死了------------ LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("设备电流统计列表数据", "导出人:" + user.getRealname(), "设备电流统计")); //update-end---author:wangshuai ---date:20211227 for:[JTC-116]导出人写死了------------ mv.addObject(NormalExcelConstants.DATA_LIST, equipmentElectricStatisticals); return mv; } /** * 电流负载对比 * * @param userId * @param equipmentElectricStatisticalVo * @return */ @Override public List getElectricValue(String userId, EquipmentElectricStatisticalVo equipmentElectricStatisticalVo) { List equipmentElectricStatisticals = this.baseMapper.getElectricValue(equipmentElectricStatisticalVo); if (equipmentElectricStatisticals != null && !equipmentElectricStatisticals.isEmpty()) { for (EquipmentElectricStatisticalDto equipmentElectricStatistical : equipmentElectricStatisticals) { equipmentElectricStatistical.setDayDate(DateUtils.format(equipmentElectricStatistical.getCreatedate(), DateUtils.STR_DATE)); } } return equipmentElectricStatisticals; } /** * 根据设备id获取最新一条数据 * * @param equipmentId * @return */ @Override public Date getMaxDate(String equipmentId) { return this.baseMapper.getMaxDate(equipmentId); } }