package org.dromara.eims.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.dromara.eims.domain.SysEqu; import org.dromara.eims.domain.SysEquType; import org.dromara.eims.domain.bo.SysEquBo; import org.dromara.eims.domain.vo.SysEquTypeVo; import org.dromara.eims.domain.vo.SysEquVo; import org.dromara.eims.mapper.SysEquMapper; import org.dromara.eims.mapper.SysEquTypeMapper; import org.dromara.eims.service.ISysEquService; import lombok.RequiredArgsConstructor; import org.dromara.common.core.utils.MapstructUtils; import org.dromara.common.core.utils.StringUtils; import org.dromara.common.mybatis.core.page.PageQuery; import org.dromara.common.mybatis.core.page.TableDataInfo; import org.springframework.stereotype.Service; import java.util.*; /** * 【设备台账】Service业务层处理 * * @author zhuguifei * @date 2025-01-04 */ @RequiredArgsConstructor @Service public class SysEquServiceImpl implements ISysEquService { private final SysEquMapper baseMapper; private final SysEquTypeMapper equTypeMapper; /** * 查询【设备台账】 * * @param equId 主键 * @return 【设备台账】 */ @Override public SysEquVo queryById(Long equId){ return baseMapper.selectVoById(equId); } /** * 分页查询【设备台账】列表 * * @param bo 查询条件 * @param pageQuery 分页参数 * @return 【设备台账】分页列表 */ @Override public TableDataInfo queryPageList(SysEquBo bo, PageQuery pageQuery) { LambdaQueryWrapper lqw = buildQueryWrapper(bo); Page result = baseMapper.selectVoPage(pageQuery.build(), lqw); return TableDataInfo.build(result); } /** * 查询符合条件的【设备台账】列表 * * @param bo 查询条件 * @return 【设备台账】列表 */ @Override public List queryList(SysEquBo bo) { LambdaQueryWrapper lqw = buildQueryWrapper(bo); return baseMapper.selectVoList(lqw); } private LambdaQueryWrapper buildQueryWrapper(SysEquBo bo) { Map params = bo.getParams(); LambdaQueryWrapper lqw = Wrappers.lambdaQuery(); lqw.eq(StringUtils.isNotBlank(bo.getAssetNo()), SysEqu::getAssetNo, bo.getAssetNo()); Long equTypeId = bo.getEquTypeId(); /** * equTypeId = 0 时查询所有设备(默认根目录id为0,详见SysEquTypeServiceImpl中selectEquTypeTreeList) * equTypeId 为其他值时只查当前设备类型id和后代设备类型id */ if (equTypeId != null && equTypeId > 0) { List allDescendantIds = getAllDescendantIds(equTypeId); lqw.in(SysEqu::getEquTypeId,allDescendantIds); } lqw.like(StringUtils.isNotBlank(bo.getEquName()), SysEqu::getEquName, bo.getEquName()); lqw.eq(StringUtils.isNotBlank(bo.getModelNo()), SysEqu::getModelNo, bo.getModelNo()); lqw.eq(StringUtils.isNotBlank(bo.getMadeIn()), SysEqu::getMadeIn, bo.getMadeIn()); lqw.eq(bo.getRatedPower() != null, SysEqu::getRatedPower, bo.getRatedPower()); lqw.eq(StringUtils.isNotBlank(bo.getPlateInfo()), SysEqu::getPlateInfo, bo.getPlateInfo()); lqw.eq(bo.getPurchaseDate() != null, SysEqu::getPurchaseDate, bo.getPurchaseDate()); lqw.eq(bo.getStatus() != null, SysEqu::getStatus, bo.getStatus()); lqw.eq(StringUtils.isNotBlank(bo.getLocation()), SysEqu::getLocation, bo.getLocation()); lqw.eq(bo.getDeptUsed() != null, SysEqu::getDeptUsed, bo.getDeptUsed()); lqw.eq(bo.getRespPerson() != null, SysEqu::getRespPerson, bo.getRespPerson()); lqw.eq(StringUtils.isNotBlank(bo.getContactPhone()), SysEqu::getContactPhone, bo.getContactPhone()); lqw.eq(bo.getDeployDate() != null, SysEqu::getDeployDate, bo.getDeployDate()); lqw.eq(bo.getTrialDate() != null, SysEqu::getTrialDate, bo.getTrialDate()); lqw.eq(bo.getPlanAcceptDate() != null, SysEqu::getPlanAcceptDate, bo.getPlanAcceptDate()); lqw.eq(bo.getActualAcceptDate() != null, SysEqu::getActualAcceptDate, bo.getActualAcceptDate()); lqw.eq(bo.getImportStatus() != null, SysEqu::getImportStatus, bo.getImportStatus()); lqw.eq(StringUtils.isNotBlank(bo.getEquCode()), SysEqu::getEquCode, bo.getEquCode()); lqw.eq(bo.getInventoryFlag() != null, SysEqu::getInventoryFlag, bo.getInventoryFlag()); lqw.eq(bo.getInventoryDate() != null, SysEqu::getInventoryDate, bo.getInventoryDate()); lqw.eq(bo.getServiceLife() != null, SysEqu::getServiceLife, bo.getServiceLife()); return lqw; } /** * 根据id,获取所有后代id * @param rootId * @return */ public List getAllDescendantIds(Long rootId) { List result = new ArrayList<>(); result.add(rootId); collectDescendants(rootId, result); return result; } private void collectDescendants(Long currentId, List collector) { QueryWrapper equTypeWrapper = new QueryWrapper<>(); equTypeWrapper.lambda().eq(SysEquType::getParentId, currentId); List children = equTypeMapper.selectVoList(equTypeWrapper); if (children != null && !children.isEmpty()) { for (SysEquTypeVo child : children) { Long childId = child.getEquTypeId(); collector.add(childId); collectDescendants(childId, collector); } } } /** * 新增【设备台账】 * * @param bo 【设备台账】 * @return 是否新增成功 */ @Override public Boolean insertByBo(SysEquBo bo) { SysEqu add = MapstructUtils.convert(bo, SysEqu.class); validEntityBeforeSave(add); boolean flag = baseMapper.insert(add) > 0; if (flag) { bo.setEquId(add.getEquId()); } return flag; } /** * 修改【设备台账】 * * @param bo 【设备台账】 * @return 是否修改成功 */ @Override public Boolean updateByBo(SysEquBo bo) { SysEqu update = MapstructUtils.convert(bo, SysEqu.class); validEntityBeforeSave(update); return baseMapper.updateById(update) > 0; } /** * 保存前的数据校验 */ private void validEntityBeforeSave(SysEqu entity){ //TODO 做一些数据校验,如唯一约束 } /** * 校验并批量删除【设备台账】信息 * * @param ids 待删除的主键集合 * @param isValid 是否进行有效性校验 * @return 是否删除成功 */ @Override public Boolean deleteWithValidByIds(Collection ids, Boolean isValid) { if(isValid){ //TODO 做一些业务上的校验,判断是否需要校验 } return baseMapper.deleteByIds(ids) > 0; } }