package org.jeecg.modules.mdc.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
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.lang3.StringUtils;
|
import org.jeecg.modules.mdc.entity.*;
|
import org.jeecg.modules.mdc.mapper.MdcDeviceCalendarMapper;
|
import org.jeecg.modules.mdc.service.*;
|
import org.jeecg.modules.mdc.util.DateUtils;
|
import org.jeecg.modules.mdc.vo.EquipmentCalendarVo;
|
import org.jeecg.modules.mdc.vo.MdcDeviceCalendarQueryVo;
|
import org.jeecg.modules.mdc.vo.MdcDeviceCalendarVo;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.time.ZoneId;
|
import java.time.format.DateTimeFormatter;
|
import java.util.ArrayList;
|
import java.util.Collections;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @Description: 设备工作日历表
|
* @Author: jeecg-boot
|
* @Date: 2023-04-10
|
* @Version: V1.0
|
*/
|
@Service
|
public class MdcDeviceCalendarServiceImpl extends ServiceImpl<MdcDeviceCalendarMapper, MdcDeviceCalendar> implements IMdcDeviceCalendarService {
|
|
@Resource
|
private IMdcEquipmentService mdcEquipmentService;
|
@Resource
|
private IMdcShiftSubService mdcShiftSubService;
|
|
@Resource
|
private IMdcVacationManagementService mdcVacationManagementService;
|
|
@Resource
|
private IMdcEquipmentOvertimeService mdcEquipmentOvertimeService;
|
|
/**
|
* 分页列表查询
|
*/
|
@Override
|
public IPage<MdcDeviceCalendarVo> pageList(String userId, MdcDeviceCalendarQueryVo mdcDeviceCalendarQueryVo, Integer pageNo, Integer pageSize, HttpServletRequest req) {
|
IPage<MdcDeviceCalendarVo> pageData = new Page<>(pageNo, pageSize);
|
List<String> equipmentIds = new ArrayList<>();
|
if (StringUtils.isNotEmpty(mdcDeviceCalendarQueryVo.getParentId()) && StringUtils.isEmpty(mdcDeviceCalendarQueryVo.getEquipmentId())) {
|
if ("2".equals(mdcDeviceCalendarQueryVo.getTypeTree())) {
|
// 部门层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, mdcDeviceCalendarQueryVo.getParentId());
|
} else {
|
// 产线层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, mdcDeviceCalendarQueryVo.getParentId());
|
}
|
} else if (StringUtils.isNotEmpty(mdcDeviceCalendarQueryVo.getEquipmentId())) {
|
// 单台设备信息
|
mdcDeviceCalendarQueryVo.setEquipmentIdList(Collections.singletonList(mdcDeviceCalendarQueryVo.getEquipmentId()));
|
} else {
|
// 查询用户拥有的所有设备信息
|
if ("2".equals(mdcDeviceCalendarQueryVo.getTypeTree())) {
|
//部门层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null);
|
} else {
|
//产线层级
|
equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null);
|
}
|
}
|
if (mdcDeviceCalendarQueryVo.getEquipmentIdList() == null || mdcDeviceCalendarQueryVo.getEquipmentIdList().isEmpty()) {
|
mdcDeviceCalendarQueryVo.setEquipmentIdList(equipmentIds);
|
}
|
|
if (mdcDeviceCalendarQueryVo.getEquipmentIdList() == null || mdcDeviceCalendarQueryVo.getEquipmentIdList().isEmpty()) {
|
return null;
|
}
|
|
return this.baseMapper.pageList(pageData, mdcDeviceCalendarQueryVo);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public boolean saveCalendar(EquipmentCalendarVo calendarVo) {
|
String[] equipmentIdList = calendarVo.getEquipmentId().split(",");
|
List<String> dateList = calendarVo.getDateList();
|
List<MdcShiftSub> mdcShiftSubList = mdcShiftSubService.list(new LambdaQueryWrapper<MdcShiftSub>().eq(MdcShiftSub::getShiftId, calendarVo.getShiftId()).eq(MdcShiftSub::getShiftSubStatus, "1"));
|
List<MdcDeviceCalendar> calendarList = new ArrayList<>();
|
for (String equipmentId : equipmentIdList) {
|
for (String date : dateList) {
|
for (MdcShiftSub mdcShiftSub : mdcShiftSubList) {
|
this.baseMapper.delete(new LambdaQueryWrapper<MdcDeviceCalendar>().eq(MdcDeviceCalendar::getEquipmentId, equipmentId).eq(MdcDeviceCalendar::getEffectiveDate, date));
|
MdcDeviceCalendar mdcDeviceCalendar = new MdcDeviceCalendar();
|
mdcDeviceCalendar.setEffectiveDate(date);
|
mdcDeviceCalendar.setEquipmentId(equipmentId);
|
mdcDeviceCalendar.setShiftId(mdcShiftSub.getShiftId());
|
mdcDeviceCalendar.setShiftSubId(mdcShiftSub.getId());
|
calendarList.add(mdcDeviceCalendar);
|
}
|
}
|
}
|
this.saveBatch(calendarList);
|
return true;
|
}
|
|
/**
|
* 查询班制数据
|
*
|
* @param equipmentId
|
* @param stringDates
|
* @return
|
*/
|
@Override
|
public List<MdcDeviceCalendarVo> listByEquipmentAndDate(String equipmentId, List<String> stringDates) {
|
try {
|
List<MdcDeviceCalendarVo> mdcDeviceCalendarVos = this.baseMapper.listByEquipmentAndDates(equipmentId, stringDates);
|
if (mdcDeviceCalendarVos != null && !mdcDeviceCalendarVos.isEmpty()) {
|
return mdcDeviceCalendarVos;
|
} else {
|
return null;
|
}
|
} catch (Exception e) {
|
return null;
|
}
|
}
|
|
/**
|
* 计算实际班产天数
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
@Override
|
public BigDecimal computeActualWorkDayCount(String equipmentId, String validDate) {
|
validDate = validDate.replaceAll("-", "");
|
List<String> validDateList = this.baseMapper.computeActualWorkDayCount(equipmentId, validDate);
|
return new BigDecimal(validDateList.size());
|
}
|
|
/**
|
* 查询班次分类
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
@Override
|
public List<String> findShiftSort(String equipmentId, String validDate) {
|
validDate = validDate.replaceAll("-", "");
|
return this.baseMapper.findShiftSort(equipmentId, validDate);
|
}
|
|
/**
|
* 计算班次时间
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
@Override
|
public BigDecimal computeShiftTimeCount(String equipmentId, String validDate) {
|
validDate = validDate.replaceAll("-", "");
|
Integer shiftCount = this.baseMapper.computeShiftTimeCount(equipmentId, validDate);
|
return new BigDecimal(shiftCount).multiply(new BigDecimal("8")).multiply(new BigDecimal("60"));
|
}
|
|
/**
|
* 自动生成设备工作日历
|
*/
|
@Override
|
public void generateDeviceCalendar() {
|
// 暂定每天晚上11点执行
|
//查询默认班制
|
List<MdcDeviceCalendarVo> acquiesceShift = this.baseMapper.findAcquiesceShift();
|
// 获取明日日期
|
String localDate = LocalDate.now().plusDays(1).toString();
|
// 获取设备列表
|
List<MdcEquipment> equipmentList = mdcEquipmentService.list();
|
List<MdcDeviceCalendar> result = new ArrayList<>();
|
for (MdcEquipment mdcEquipment : equipmentList) {
|
List<MdcDeviceCalendar> list = super.list(new LambdaQueryWrapper<MdcDeviceCalendar>().eq(MdcDeviceCalendar::getEquipmentId, mdcEquipment.getEquipmentId()).eq(MdcDeviceCalendar::getEffectiveDate, localDate.replaceAll("-", "")));
|
if (list == null || list.isEmpty()) {
|
List<MdcVacationManagement> vacationManagementList = mdcVacationManagementService.list(new LambdaQueryWrapper<MdcVacationManagement>().eq(MdcVacationManagement::getEquipmentId, mdcEquipment.getEquipmentId()).eq(MdcVacationManagement::getVacationDate, localDate));
|
if (vacationManagementList == null || vacationManagementList.isEmpty()) {
|
String effectiveDate = localDate.replaceAll("-", "");
|
for (MdcDeviceCalendarVo mdcDeviceCalendarVo : acquiesceShift) {
|
MdcDeviceCalendar mdcDeviceCalendar = new MdcDeviceCalendar();
|
mdcDeviceCalendar.setEquipmentId(mdcEquipment.getEquipmentId());
|
mdcDeviceCalendar.setEffectiveDate(effectiveDate);
|
mdcDeviceCalendar.setShiftId(mdcDeviceCalendarVo.getShiftId());
|
mdcDeviceCalendar.setShiftSubId(mdcDeviceCalendarVo.getShiftSubId());
|
result.add(mdcDeviceCalendar);
|
}
|
}
|
}
|
}
|
if (!result.isEmpty()) {
|
super.saveBatch(result);
|
}
|
}
|
|
@Override
|
public MdcDeviceCalendar getFirstData(String equipmentId) {
|
return this.baseMapper.getFirstData(equipmentId);
|
}
|
|
@Override
|
public List<MdcDeviceCalendarVo> listByEquipmentIdAndDate(String equipmentId, String date) {
|
List<MdcDeviceCalendarVo> mdcDeviceCalendarVos = this.baseMapper.listByEquipmentAndDate(equipmentId, date);
|
if (mdcDeviceCalendarVos != null && !mdcDeviceCalendarVos.isEmpty()) {
|
for (MdcDeviceCalendarVo mdcDeviceCalendarVo : mdcDeviceCalendarVos) {
|
List<MdcEquipmentOvertime> list = mdcEquipmentOvertimeService.list(new LambdaQueryWrapper<MdcEquipmentOvertime>().eq(MdcEquipmentOvertime::getEquipmentId, mdcDeviceCalendarVo.getEquipmentId()).eq(MdcEquipmentOvertime::getTheDate, mdcDeviceCalendarVo.getEndDate()));
|
if (list != null && !list.isEmpty()) {
|
mdcDeviceCalendarVo.setOvertimeStartTime(list.get(0).getStartTime());
|
mdcDeviceCalendarVo.setOvertimeEndTime(list.get(0).getEndTime());
|
}
|
}
|
}
|
return mdcDeviceCalendarVos;
|
}
|
|
@Override
|
public String findShiftByEquId(String equipmentId) {
|
String result = "";
|
LocalDateTime now = LocalDateTime.now();
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd");
|
String date = now.format(formatter);
|
String format = DateUtils.format(DateUtils.toDate(date, DateUtils.STRDATE), DateUtils.STR_DATE);
|
List<MdcShiftSub> shiftSubList = this.baseMapper.findShiftByEquId(equipmentId, date);
|
if (shiftSubList != null && !shiftSubList.isEmpty()) {
|
for (MdcShiftSub mdcShiftSub : shiftSubList) {
|
LocalDateTime startDate = DateUtils.toDate(format + " " + mdcShiftSub.getStartDate(), DateUtils.STR_DATE_TIME_SMALL).toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
LocalDateTime endDate = DateUtils.toDate(format + " " + mdcShiftSub.getEndDate(), DateUtils.STR_DATE_TIME_SMALL).toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
if ("true".equals(mdcShiftSub.getIsDaySpan())) {
|
endDate = endDate.plusDays(1);
|
}
|
if (now.isAfter(startDate) && now.isBefore(endDate)) {
|
result = mdcShiftSub.getShiftSubName();
|
break;
|
}
|
}
|
}
|
if (StringUtils.isBlank(result)) {
|
LocalDateTime yesterday = now.plusDays(-1);
|
String yes = yesterday.format(formatter);
|
String previous = DateUtils.format(DateUtils.toDate(yes, DateUtils.STRDATE), DateUtils.STR_DATE);
|
List<MdcShiftSub> shiftSubs = this.baseMapper.findShiftByEquId(equipmentId, previous);
|
if (shiftSubs != null && !shiftSubs.isEmpty()) {
|
for (MdcShiftSub mdcShiftSub : shiftSubs) {
|
LocalDateTime startDate = DateUtils.toDate(format + " " + mdcShiftSub.getStartDate(), DateUtils.STR_DATE_TIME_SMALL).toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
LocalDateTime endDate = DateUtils.toDate(format + " " + mdcShiftSub.getEndDate(), DateUtils.STR_DATE_TIME_SMALL).toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime();
|
if ("true".equals(mdcShiftSub.getIsDaySpan())) {
|
endDate = endDate.plusDays(1);
|
}
|
if (now.isAfter(startDate) && now.isBefore(endDate)) {
|
result = mdcShiftSub.getShiftSubName();
|
break;
|
}
|
}
|
}
|
}
|
return result;
|
}
|
|
}
|
