package org.jeecg.modules.mdc.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import org.jeecg.modules.mdc.constant.MdcConstant;
|
import org.jeecg.modules.mdc.entity.MdcEquipment;
|
import org.jeecg.modules.mdc.entity.MdcOverallEquipmentEfficiency;
|
import org.jeecg.modules.mdc.entity.MdcStandardProcessDuration;
|
import org.jeecg.modules.mdc.mapper.MdcOverallEquipmentEfficiencyMapper;
|
import org.jeecg.modules.mdc.service.*;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.time.YearMonth;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
* @author: LiuS
|
* @create: 2023-10-18 09:25
|
*/
|
@Service
|
public class MdcOverallEquipmentEfficiencyServiceImpl extends ServiceImpl<MdcOverallEquipmentEfficiencyMapper, MdcOverallEquipmentEfficiency> implements IMdcOverallEquipmentEfficiencyService {
|
|
@Resource
|
private IMdcEquipmentService mdcEquipmentService;
|
|
@Resource
|
private IMdcEquipmentOvertimeService mdcEquipmentOvertimeService;
|
|
@Resource
|
private IMdcDeviceCalendarService mdcDeviceCalendarService;
|
|
@Resource
|
private IMdcNoplanCloseService mdcNoplanCloseService;
|
|
@Resource
|
private IMdcPlanCloseService mdcPlanCloseService;
|
|
@Resource
|
private IMdcPassRateService mdcPassRateService;
|
|
@Resource
|
private IMdcStandardProcessDurationService mdcStandardProcessDurationService;
|
|
@Resource
|
private IMdcEquipmentStatisticalShiftInfoService mdcEquipmentStatisticalShiftInfoService;
|
|
/**
|
* 计算设备综合效率OEE
|
*/
|
@Override
|
public void runningOverallEquipmentEfficiency() {
|
/*
|
OEE = 时间开动率 × 性能开动率 × 合格品率
|
时间开动率 = （负荷时间 - 非计划停机时间） / 负荷时间 × 100%
|
性能开动率 = 净开动时间 / 开动时间 × 100%
|
合格品率 = 加工数量 - 不合格数量 / 加工数量
|
负荷时间 = 日历工作时间 - 计划停机时间
|
非计划停机时间 = 负荷时间 - 主轴运转时间
|
工作日历时间 = 日历时间 - 法定假日 - 双休日 + 加班时间
|
净开动时间 = 标准加工时间 × 加工数量
|
*/
|
List<MdcOverallEquipmentEfficiency> result = new ArrayList<>();
|
// 获取有效日期 格式 yyyy-MM
|
String validDate = YearMonth.now().minusMonths(1).toString();
|
// 获取设备列表
|
List<MdcEquipment> equipmentList = mdcEquipmentService.list();
|
for (MdcEquipment mdcEquipment : equipmentList) {
|
String equipmentId = mdcEquipment.getEquipmentId();
|
// 查询班次分类
|
List<String> shiftSubIdList = mdcDeviceCalendarService.findShiftSort(equipmentId, validDate);
|
// 故障停机时长统计(分钟)
|
BigDecimal breakdownDownDuration = mdcNoplanCloseService.findNoplanTimeDuration(equipmentId, validDate, MdcConstant.BREAKDOWN_DOWN);
|
// 换型调试时长统计(分钟)
|
BigDecimal conversionDebugDuration = mdcNoplanCloseService.findNoplanTimeDuration(equipmentId, validDate, MdcConstant.CONVERSION_DEBUG);
|
// 物料短缺时长统计(分钟)
|
BigDecimal materialShortageDuration = mdcNoplanCloseService.findNoplanTimeDuration(equipmentId, validDate, MdcConstant.MATERIAL_SHORTAGE);
|
// 计划等任务时长统计(分钟)
|
BigDecimal plannedTaskDuration = mdcNoplanCloseService.findNoplanTimeDuration(equipmentId, validDate, MdcConstant.PLANNED_TASK);
|
// 检验时长统计(分钟)
|
BigDecimal inspectDuration = mdcNoplanCloseService.findNoplanTimeDuration(equipmentId, validDate, MdcConstant.INSPECT);
|
// 其他时长统计(分钟)
|
BigDecimal otherDuration = mdcNoplanCloseService.findNoplanTimeDuration(equipmentId, validDate, MdcConstant.OTHER);
|
// 计划保养时长统计(分钟)
|
BigDecimal plannedMaintenanceDuration = new BigDecimal("0");
|
// 会议/培训时长统计(分钟)
|
BigDecimal conferenceTrainingDuration = new BigDecimal("0");
|
// 其它休息时长统计(分钟)
|
BigDecimal otherRestDuration = new BigDecimal("0");
|
if (shiftSubIdList != null && !shiftSubIdList.isEmpty()) {
|
for (String shiftSubId : shiftSubIdList) {
|
MdcOverallEquipmentEfficiency mdcOverallEquipmentEfficiency = new MdcOverallEquipmentEfficiency();
|
// 时间开动率计算
|
mdcOverallEquipmentEfficiency.setEquipmentId(equipmentId);
|
mdcOverallEquipmentEfficiency.setEquipmentName(mdcEquipment.getEquipmentName());
|
mdcOverallEquipmentEfficiency.setEquipmentModel(mdcEquipment.getEquipmentModel());
|
mdcOverallEquipmentEfficiency.setValidDate(validDate);
|
// 班次 班次时间
|
mdcOverallEquipmentEfficiency.setShiftSubId(shiftSubId);
|
BigDecimal shiftTimeCount = mdcDeviceCalendarService.computeShiftTimeCount(shiftSubId, equipmentId, validDate);
|
mdcOverallEquipmentEfficiency.setShiftTimeCount(shiftTimeCount);
|
// 计算加班时间
|
BigDecimal overtime = mdcEquipmentOvertimeService.computeOvertime(shiftSubId, equipmentId, validDate);
|
mdcOverallEquipmentEfficiency.setOvertime(overtime);
|
// 计算实际班产天数
|
BigDecimal actualWorkDayCount = mdcDeviceCalendarService.computeActualWorkDayCount(shiftSubId, equipmentId, validDate);
|
mdcOverallEquipmentEfficiency.setActualWorkDayCount(actualWorkDayCount);
|
// 月度实际班产总时间(分钟)
|
mdcOverallEquipmentEfficiency.setMonthActualWorkDayTimeCount(mdcOverallEquipmentEfficiency.getShiftTimeCount().add(overtime));
|
// 故障停机时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setBreakdownDownDuration(breakdownDownDuration);
|
// 换型调试时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setConversionDebugDuration(conversionDebugDuration);
|
// 物料短缺时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setMaterialShortageDuration(materialShortageDuration);
|
// 计划等任务时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setPlannedTaskDuration(plannedTaskDuration);
|
// 检验时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setInspectDuration(inspectDuration);
|
// 其他时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setOtherDuration(otherDuration);
|
// 计划保养时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setPlannedMaintenanceDuration(plannedMaintenanceDuration);
|
// 会议/培训时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setConferenceTrainingDuration(conferenceTrainingDuration);
|
// 其它休息时长统计(分钟)
|
mdcOverallEquipmentEfficiency.setOtherRestDuration(otherRestDuration);
|
/*
|
负荷时间(小时) = 工作日历时间 - 计划停机时间
|
工作日历时间 = 日历时间 - 法定假日 - 双休日 + 加班时间
|
计划停机时间 = 计划保养时长 + 会议/培训时长 + 会议/培训时长
|
*/
|
// mdcOverallEquipmentEfficiency.getShiftTimeCount() - plannedMaintenanceDuration - conferenceTrainingDuration - otherRestDuration
|
// 负荷时间(分钟)
|
BigDecimal loadTime = mdcOverallEquipmentEfficiency.getShiftTimeCount().subtract(plannedMaintenanceDuration).subtract(conferenceTrainingDuration).subtract(otherRestDuration);
|
mdcOverallEquipmentEfficiency.setLoadTime(loadTime.divide(new BigDecimal("60"), 1, RoundingMode.HALF_UP));
|
// 时间开动率
|
BigDecimal timeActuationRate = BigDecimal.ZERO;
|
if (loadTime.compareTo(BigDecimal.ZERO) == 0) {
|
mdcOverallEquipmentEfficiency.setTimeActuationRate(BigDecimal.ZERO);
|
} else {
|
timeActuationRate = (loadTime.subtract(breakdownDownDuration).subtract(conversionDebugDuration).subtract(materialShortageDuration).subtract(plannedTaskDuration).subtract(inspectDuration).subtract(otherDuration)).divide(loadTime, 4, RoundingMode.HALF_UP);
|
mdcOverallEquipmentEfficiency.setTimeActuationRate(timeActuationRate);
|
}
|
// 加工零件数(件) processQuantity
|
BigDecimal processQuantity = mdcPassRateService.findProcessQuantity(equipmentId, validDate);
|
mdcOverallEquipmentEfficiency.setProcessQuantity(processQuantity);
|
// 标准加工时间(分钟)
|
MdcStandardProcessDuration mdcStandardProcessDuration = mdcStandardProcessDurationService.getOne(new LambdaQueryWrapper<MdcStandardProcessDuration>().eq(MdcStandardProcessDuration::getEquipmentId, equipmentId));
|
if (mdcStandardProcessDuration != null) {
|
mdcOverallEquipmentEfficiency.setStandardProcessDuration(new BigDecimal(mdcStandardProcessDuration.getDuration()).multiply(processQuantity));
|
} else {
|
mdcOverallEquipmentEfficiency.setStandardProcessDuration(BigDecimal.ZERO);
|
}
|
|
// 性能开动率 = 主轴运行时间/负荷时间
|
// 查询主轴运行时间(分钟)
|
BigDecimal spindleRunDuration = mdcEquipmentStatisticalShiftInfoService.findSpindleRunDuration(equipmentId, validDate, shiftSubId);
|
if (spindleRunDuration.compareTo(BigDecimal.ZERO) != 0) {
|
mdcOverallEquipmentEfficiency.setPerformanceRate(spindleRunDuration.divide(loadTime, 4, RoundingMode.HALF_UP));
|
} else {
|
mdcOverallEquipmentEfficiency.setPerformanceRate(BigDecimal.ZERO);
|
}
|
// 废品数 unqualifiedQuantity
|
BigDecimal unqualifiedQuantity = mdcPassRateService.findUnqualifiedQuantity(equipmentId, validDate);
|
mdcOverallEquipmentEfficiency.setUnqualifiedQuantity(unqualifiedQuantity);
|
// 合格率
|
if (processQuantity.compareTo(BigDecimal.ZERO) == 0) {
|
mdcOverallEquipmentEfficiency.setPassRate(BigDecimal.ONE);
|
} else {
|
mdcOverallEquipmentEfficiency.setPassRate((processQuantity.subtract(unqualifiedQuantity)).divide(processQuantity, 4, RoundingMode.HALF_UP));
|
}
|
// 设备综合效率 = 时间开动率 × 性能开动率 × 合格品率
|
mdcOverallEquipmentEfficiency.setOverallEquipmentEfficiency(timeActuationRate.multiply(mdcOverallEquipmentEfficiency.getPerformanceRate()).multiply(mdcOverallEquipmentEfficiency.getPassRate()));
|
if (mdcOverallEquipmentEfficiency.getOverallEquipmentEfficiency().compareTo(BigDecimal.ZERO) == 0) {
|
mdcOverallEquipmentEfficiency.setOverallEquipmentEfficiency(BigDecimal.ONE);
|
}
|
result.add(mdcOverallEquipmentEfficiency);
|
}
|
}
|
}
|
super.saveBatch(result);
|
}
|
}
|
