package org.jeecg.modules.eam.service.impl;
|
|
import cn.hutool.core.collection.CollectionUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
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.apache.shiro.SecurityUtils;
|
import org.jeecg.common.constant.CommonConstant;
|
import org.jeecg.common.constant.DataBaseConstant;
|
import org.jeecg.common.system.vo.LoginUser;
|
import org.jeecg.common.util.oConvertUtils;
|
import org.jeecg.modules.eam.constant.MaintenanceStatusEnum;
|
import org.jeecg.modules.eam.constant.OrderCreationMethodEnum;
|
import org.jeecg.modules.eam.entity.EamEquipment;
|
import org.jeecg.modules.eam.entity.EamWeekMaintenanceOrder;
|
import org.jeecg.modules.eam.mapper.EamWeekMaintenanceOrderMapper;
|
import org.jeecg.modules.eam.request.EamWeekMaintenanceQuery;
|
import org.jeecg.modules.eam.request.EamWeekMaintenanceRequest;
|
import org.jeecg.modules.eam.service.IEamWeekMaintenanceOrderDetailService;
|
import org.jeecg.modules.eam.service.IEamWeekMaintenanceOrderService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.annotation.Resource;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @Description: 周保工单
|
* @Author: jeecg-boot
|
* @Date: 2025-04-02
|
* @Version: V1.0
|
*/
|
@Service
|
public class EamWeekMaintenanceOrderServiceImpl extends ServiceImpl<EamWeekMaintenanceOrderMapper, EamWeekMaintenanceOrder> implements IEamWeekMaintenanceOrderService {
|
|
@Resource
|
private EamWeekMaintenanceOrderMapper eamWeekMaintenanceOrderMapper;
|
|
@Autowired
|
private IEamWeekMaintenanceOrderDetailService eamWeekMaintenanceOrderDetailService;
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public boolean addWeekMaintenance(EamWeekMaintenanceRequest request) {
|
EamWeekMaintenanceOrder order = new EamWeekMaintenanceOrder();
|
order.setOrderNum(request.getOrderNum());
|
order.setEquipmentId(request.getEquipmentId());
|
order.setStandardId(request.getStandardId());
|
order.setMaintenanceDate(request.getMaintenanceDate());
|
order.setOperator(request.getOperator());
|
order.setRemark(request.getRemark());
|
//状态初始化
|
order.setMaintenanceStatus(MaintenanceStatusEnum.WAIT_MAINTENANCE.name());
|
order.setCreationMethod(OrderCreationMethodEnum.MANUAL.name());
|
//删除标记
|
order.setDelFlag(CommonConstant.DEL_FLAG_0);
|
eamWeekMaintenanceOrderMapper.insert(order);
|
//处理明细数据
|
if(CollectionUtil.isNotEmpty(request.getTableDetailList())) {
|
request.getTableDetailList().forEach(tableDetail -> {
|
tableDetail.setId(null);
|
tableDetail.setOrderId(order.getId());
|
});
|
eamWeekMaintenanceOrderDetailService.saveBatch(request.getTableDetailList());
|
}
|
return true;
|
}
|
|
@Override
|
public IPage<EamWeekMaintenanceOrder> queryPageList(Page<EamWeekMaintenanceOrder> page, EamWeekMaintenanceQuery query) {
|
QueryWrapper<EamWeekMaintenanceOrder> queryWrapper = new QueryWrapper<>();
|
//用户数据权限
|
LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();
|
if (sysUser == null) {
|
return page;
|
}
|
if (StringUtils.isNotBlank(sysUser.getEquipmentIds())) {
|
//选择了设备，根据设备id过滤设备
|
List<String> equipArr = Arrays.asList(sysUser.getEquipmentIds().split(","));
|
queryWrapper.in("e.equipment_code", equipArr);
|
} else {
|
//没有选择设备，根据车间过滤设备
|
queryWrapper.exists("select 1 from mdc_user_production t where t.user_id={0} and t.pro_id=e.org_id ", sysUser.getId());
|
}
|
//查询条件过滤
|
if (query != null) {
|
if (StringUtils.isNotBlank(query.getEquipmentId())) {
|
queryWrapper.eq("wmo.equipment_id", query.getEquipmentId());
|
}
|
if (StringUtils.isNotBlank(query.getOrderNum())) {
|
queryWrapper.like("wmo.order_num", query.getOrderNum());
|
}
|
if (StringUtils.isNotBlank(query.getMaintenanceStatus())) {
|
queryWrapper.eq("wmo.maintenance_status", query.getMaintenanceStatus());
|
}
|
if (query.getMaintenanceDateBegin() != null && query.getMaintenanceDateEnd() != null) {
|
queryWrapper.between("wmo.maintenance_date", query.getMaintenanceDateBegin(), query.getMaintenanceDateEnd());
|
}
|
//排序
|
if (StringUtils.isNotBlank(query.getColumn()) && StringUtils.isNotBlank(query.getOrder())) {
|
String column = query.getColumn();
|
if (column.endsWith(CommonConstant.DICT_TEXT_SUFFIX)) {
|
column = column.substring(0, column.lastIndexOf(CommonConstant.DICT_TEXT_SUFFIX));
|
}
|
if (DataBaseConstant.SQL_ASC.equalsIgnoreCase(query.getOrder())) {
|
queryWrapper.orderByAsc("wmo." + oConvertUtils.camelToUnderline(column));
|
} else {
|
queryWrapper.orderByDesc("wmo." + oConvertUtils.camelToUnderline(column));
|
}
|
} else {
|
queryWrapper.orderByDesc("wmo.create_time");
|
}
|
} else {
|
queryWrapper.orderByDesc("wmo.create_time");
|
}
|
|
return eamWeekMaintenanceOrderMapper.queryPageList(page, queryWrapper);
|
}
|
}
|
