package org.jeecg.modules.eam.service.impl;
|
|
import cn.hutool.core.collection.CollectionUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
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 com.fasterxml.jackson.core.JsonProcessingException;
|
import com.fasterxml.jackson.databind.ObjectMapper;
|
import org.apache.commons.lang3.StringUtils;
|
import org.apache.shiro.SecurityUtils;
|
import org.jeecg.common.api.vo.FileUploadResult;
|
import org.jeecg.common.constant.CommonConstant;
|
import org.jeecg.common.exception.JeecgBootException;
|
import org.jeecg.common.system.vo.LoginUser;
|
import org.jeecg.modules.eam.constant.MaintenanceStandardStatusEnum;
|
import org.jeecg.modules.eam.entity.EamMaintenanceStandard;
|
import org.jeecg.modules.eam.entity.EamMaintenanceStandardDetail;
|
import org.jeecg.modules.eam.mapper.EamMaintenanceStandardMapper;
|
import org.jeecg.modules.eam.request.EamMaintenanceStandardRequest;
|
import org.jeecg.modules.eam.service.IEamMaintenanceStandardDetailService;
|
import org.jeecg.modules.eam.service.IEamMaintenanceStandardService;
|
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.ArrayList;
|
import java.util.Arrays;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
/**
|
* @Description: 保养标准
|
* @Author: jeecg-boot
|
* @Date: 2025-03-26
|
* @Version: V1.0
|
*/
|
@Service
|
public class EamMaintenanceStandardServiceImpl extends ServiceImpl<EamMaintenanceStandardMapper, EamMaintenanceStandard> implements IEamMaintenanceStandardService {
|
|
@Resource
|
private EamMaintenanceStandardMapper eamMaintenanceStandardMapper;
|
|
@Autowired
|
private IEamMaintenanceStandardDetailService eamMaintenanceStandardDetailService;
|
|
@Override
|
public IPage<EamMaintenanceStandard> queryPageList(Page<EamMaintenanceStandard> page, EamMaintenanceStandard eamMaintenanceStandard) {
|
QueryWrapper<EamMaintenanceStandard> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("ems.del_flag", CommonConstant.DEL_FLAG_0);
|
//用户数据权限
|
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(eamMaintenanceStandard != null) {
|
//编码 模糊查询
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getStandardCode())) {
|
queryWrapper.like("ems.standard_code", eamMaintenanceStandard.getStandardCode());
|
}
|
//名称 模糊查询
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getStandardName())) {
|
queryWrapper.like("ems.standard_name", eamMaintenanceStandard.getStandardCode());
|
}
|
//设备
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getEquipmentId())) {
|
queryWrapper.eq("ems.equipment_id", eamMaintenanceStandard.getEquipmentId());
|
}
|
//保养分类
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getMaintenanceCategory())) {
|
queryWrapper.eq("ems.maintenance_category", eamMaintenanceStandard.getMaintenanceCategory());
|
}
|
//保养分类
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getStandardStatus())) {
|
queryWrapper.eq("ems.standard_status", eamMaintenanceStandard.getStandardStatus());
|
}
|
//设备编码
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getEquipmentCode())) {
|
queryWrapper.like("e.equipment_code", eamMaintenanceStandard.getEquipmentCode());
|
}
|
//设备名称
|
if(StringUtils.isNotBlank(eamMaintenanceStandard.getEquipmentName())) {
|
queryWrapper.like("e.equipment_name", eamMaintenanceStandard.getEquipmentName());
|
}
|
}
|
queryWrapper.orderByDesc("ems.create_time");
|
return eamMaintenanceStandardMapper.queryPageList(page, queryWrapper);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public boolean addMaintenanceStandard(EamMaintenanceStandardRequest standardRequest) {
|
EamMaintenanceStandard entity = new EamMaintenanceStandard();
|
entity.setStandardCode(standardRequest.getStandardCode());
|
entity.setStandardName(standardRequest.getStandardName());
|
entity.setMaintenanceCategory(standardRequest.getMaintenanceCategory());
|
entity.setMaintenancePeriod(standardRequest.getMaintenancePeriod());
|
entity.setInitialDate(standardRequest.getInitialDate());
|
entity.setFileCode(standardRequest.getFileCode());
|
entity.setStandardStatus(MaintenanceStandardStatusEnum.NORMAL.name());
|
//版本递增
|
entity.setStandardVersion(CommonConstant.OPERATE_TYPE_1);
|
//设备处理
|
entity.setEquipmentId(standardRequest.getEquipmentId());
|
//删除标记
|
entity.setDelFlag(CommonConstant.DEL_FLAG_0);
|
//重复性校验
|
EamMaintenanceStandard exist = checkDuplicate(entity.getEquipmentId(), entity.getMaintenanceCategory());
|
if(exist != null){
|
throw new JeecgBootException("设备标准已存在，不能重复添加！");
|
}
|
//处理附件
|
if(CollectionUtil.isNotEmpty(standardRequest.getFileList())) {
|
FileUploadResult fileUploadResult = standardRequest.getFileList().get(0);
|
ObjectMapper mapper = new ObjectMapper();
|
try {
|
String referenceFile = mapper.writeValueAsString(fileUploadResult);
|
entity.setReferenceFile(referenceFile);
|
} catch (JsonProcessingException e) {
|
log.error("JSON转换失败：" + e.getMessage(), e);
|
}
|
}
|
eamMaintenanceStandardMapper.insert(entity);
|
//处理明细数据
|
if(CollectionUtil.isNotEmpty(standardRequest.getTableDetailList())) {
|
standardRequest.getTableDetailList().forEach(tableDetail -> {
|
tableDetail.setStandardId(entity.getId());
|
});
|
eamMaintenanceStandardDetailService.saveBatch(standardRequest.getTableDetailList());
|
}
|
return true;
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public boolean editMaintenanceStandard(EamMaintenanceStandardRequest standardRequest) {
|
EamMaintenanceStandard entity = eamMaintenanceStandardMapper.selectById(standardRequest.getId());
|
if(entity == null){
|
throw new JeecgBootException("编辑的数据已删除，请刷新重试！");
|
}
|
entity.setStandardName(standardRequest.getStandardName());
|
entity.setMaintenancePeriod(standardRequest.getMaintenancePeriod());
|
entity.setFileCode(standardRequest.getFileCode());
|
//处理附件
|
if(CollectionUtil.isNotEmpty(standardRequest.getFileList())) {
|
FileUploadResult fileUploadResult = standardRequest.getFileList().get(0);
|
ObjectMapper mapper = new ObjectMapper();
|
try {
|
String referenceFile = mapper.writeValueAsString(fileUploadResult);
|
entity.setReferenceFile(referenceFile);
|
} catch (JsonProcessingException e) {
|
log.error("JSON转换失败：" + e.getMessage(), e);
|
}
|
}else {
|
entity.setReferenceFile(null);
|
}
|
eamMaintenanceStandardMapper.updateById(entity);
|
//处理详情
|
if(CollectionUtil.isNotEmpty(standardRequest.getTableDetailList())) {
|
List<EamMaintenanceStandardDetail> addList = new ArrayList<>();
|
List<EamMaintenanceStandardDetail> updateList = new ArrayList<>();
|
standardRequest.getTableDetailList().forEach(tableDetail -> {
|
tableDetail.setStandardId(entity.getId());
|
if(tableDetail.getId() == null){
|
addList.add(tableDetail);
|
}else {
|
updateList.add(tableDetail);
|
}
|
});
|
if(CollectionUtil.isNotEmpty(addList)){
|
eamMaintenanceStandardDetailService.saveBatch(addList);
|
}
|
if(CollectionUtil.isNotEmpty(updateList)){
|
eamMaintenanceStandardDetailService.updateBatchById(updateList);
|
}
|
}
|
if(CollectionUtil.isNotEmpty(standardRequest.getRemoveDetailList())) {
|
List<String> ids = standardRequest.getRemoveDetailList().stream().map(EamMaintenanceStandardDetail::getId).collect(Collectors.toList());
|
eamMaintenanceStandardDetailService.removeBatchByIds(ids);
|
}
|
return true;
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public boolean upgradeMaintenanceStandard(EamMaintenanceStandardRequest standardRequest) {
|
EamMaintenanceStandard entity = eamMaintenanceStandardMapper.selectById(standardRequest.getId());
|
if(entity == null){
|
throw new JeecgBootException("编辑的数据已删除，请刷新重试！");
|
}
|
entity.setStandardStatus(MaintenanceStandardStatusEnum.ABOLISH.name());
|
//原来的作废
|
eamMaintenanceStandardMapper.updateById(entity);
|
|
//新增一个版本
|
EamMaintenanceStandard newEntity = new EamMaintenanceStandard();
|
newEntity.setStandardCode(standardRequest.getStandardCode());
|
newEntity.setStandardName(standardRequest.getStandardName());
|
newEntity.setMaintenanceCategory(standardRequest.getMaintenanceCategory());
|
newEntity.setMaintenancePeriod(standardRequest.getMaintenancePeriod());
|
newEntity.setInitialDate(standardRequest.getInitialDate());
|
newEntity.setFileCode(standardRequest.getFileCode());
|
newEntity.setStandardStatus(MaintenanceStandardStatusEnum.NORMAL.name());
|
//版本递增
|
newEntity.setStandardVersion(entity.getStandardVersion() + 1);
|
//设备处理
|
newEntity.setEquipmentId(standardRequest.getEquipmentId());
|
//删除标记
|
newEntity.setDelFlag(CommonConstant.DEL_FLAG_0);
|
//重复性校验
|
EamMaintenanceStandard exist = checkDuplicate(newEntity.getEquipmentId(), newEntity.getMaintenanceCategory());
|
if(exist != null){
|
throw new JeecgBootException("设备标准已存在，不能重复添加！");
|
}
|
//处理附件
|
if(CollectionUtil.isNotEmpty(standardRequest.getFileList())) {
|
FileUploadResult fileUploadResult = standardRequest.getFileList().get(0);
|
ObjectMapper mapper = new ObjectMapper();
|
try {
|
String referenceFile = mapper.writeValueAsString(fileUploadResult);
|
newEntity.setReferenceFile(referenceFile);
|
} catch (JsonProcessingException e) {
|
log.error("JSON转换失败：" + e.getMessage(), e);
|
}
|
}
|
eamMaintenanceStandardMapper.insert(newEntity);
|
//处理明细数据
|
if(CollectionUtil.isNotEmpty(standardRequest.getTableDetailList())) {
|
standardRequest.getTableDetailList().forEach(tableDetail -> {
|
tableDetail.setId(null);
|
tableDetail.setCreateBy(null);
|
tableDetail.setUpdateBy(null);
|
tableDetail.setCreateTime(null);
|
tableDetail.setUpdateTime(null);
|
tableDetail.setStandardId(newEntity.getId());
|
});
|
eamMaintenanceStandardDetailService.saveBatch(standardRequest.getTableDetailList());
|
}
|
return true;
|
}
|
|
@Override
|
public EamMaintenanceStandard checkDuplicate(String equipmentId, String maintenanceCategory) {
|
LambdaQueryWrapper<EamMaintenanceStandard> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.eq(EamMaintenanceStandard::getEquipmentId, equipmentId);
|
queryWrapper.eq(EamMaintenanceStandard::getMaintenanceCategory, maintenanceCategory);
|
queryWrapper.eq(EamMaintenanceStandard::getDelFlag, CommonConstant.DEL_FLAG_0);
|
queryWrapper.eq(EamMaintenanceStandard::getStandardStatus, MaintenanceStandardStatusEnum.NORMAL.name());
|
queryWrapper.orderByDesc(EamMaintenanceStandard::getStandardVersion);
|
|
List<EamMaintenanceStandard> list = eamMaintenanceStandardMapper.selectList(queryWrapper);
|
if(CollectionUtil.isEmpty(list)) {
|
return null;
|
}
|
return list.get(0);
|
}
|
|
/**
|
* 查询标准列表-前端展示该用户拥有的标准
|
* @param keyword 设备编号
|
* @param maintenanceCategory 保养类型
|
* @return
|
*/
|
@Override
|
public List<EamMaintenanceStandard> queryListByKeywordAndCategory(String keyword, String equipmentId, Integer pageSize, String maintenanceCategory){
|
Page<EamMaintenanceStandard> page = new Page<EamMaintenanceStandard>(1, pageSize);
|
EamMaintenanceStandard query = new EamMaintenanceStandard();
|
query.setEquipmentId(equipmentId);
|
query.setEquipmentCode(keyword);
|
query.setEquipmentName(keyword);
|
query.setMaintenanceCategory(maintenanceCategory);
|
query.setStandardStatus(MaintenanceStandardStatusEnum.NORMAL.name());
|
IPage<EamMaintenanceStandard> pageData = this.queryPageList(page, query);
|
return pageData.getRecords();
|
}
|
|
@Override
|
public List<EamMaintenanceStandard> queryListByCategory(String maintenanceCategory) {
|
LambdaQueryWrapper<EamMaintenanceStandard> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.eq(EamMaintenanceStandard::getDelFlag, CommonConstant.DEL_FLAG_0);
|
queryWrapper.eq(EamMaintenanceStandard::getMaintenanceCategory, maintenanceCategory);
|
queryWrapper.eq(EamMaintenanceStandard::getStandardStatus, MaintenanceStandardStatusEnum.NORMAL.name());
|
return eamMaintenanceStandardMapper.selectList(queryWrapper);
|
}
|
}
|
