package org.dromara.eims.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import org.dromara.common.core.utils.MapstructUtils; import org.dromara.common.core.utils.StringUtils; import org.dromara.common.mybatis.core.page.TableDataInfo; import org.dromara.common.mybatis.core.page.PageQuery; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; import org.dromara.eims.domain.bo.EimsInventoryDetailBo; import org.dromara.eims.domain.vo.EimsInventoryDetailVo; import org.dromara.eims.domain.EimsInventoryDetail; import org.dromara.eims.mapper.EimsInventoryDetailMapper; import org.dromara.eims.service.IEimsInventoryDetailService; import java.util.List; import java.util.Map; import java.util.Collection; /** * 盘点明细Service业务层处理 * * @author zhuguifei * @date 2025-02-06 */ @RequiredArgsConstructor @Service public class EimsInventoryDetailServiceImpl implements IEimsInventoryDetailService { private final EimsInventoryDetailMapper baseMapper; /** * 查询盘点明细 * * @param id 主键 * @return 盘点明细 */ @Override public EimsInventoryDetailVo queryById(Long id) { return baseMapper.selectVoById(id); } /** * 分页查询盘点明细列表-多表查询 * * @param bo 查询条件 * @param pageQuery 分页参数 * @return 盘点明细分页列表 */ @Override public TableDataInfo queryPageListCustom(EimsInventoryDetailBo bo, PageQuery pageQuery) { //TODO 特殊处理-多表同字段导致问题 String orderByColumn = pageQuery.getOrderByColumn(); if (StringUtils.isNotEmpty(orderByColumn) && orderByColumn.contains("status")) { pageQuery.setOrderByColumn(orderByColumn.replace("status", "a.status")); } Page page = baseMapper.selectInventoryDetailList(pageQuery.build(), buildQueryWrapper(bo)); return TableDataInfo.build(page); } /** * 查询符合条件的盘点明细列表 * * @param bo 查询条件 * @return 盘点明细列表 */ @Override public List queryList(EimsInventoryDetailBo bo) { QueryWrapper qw = buildQueryWrapper(bo); return baseMapper.selectVoList(qw); } private QueryWrapper buildQueryWrapper(EimsInventoryDetailBo bo) { Map params = bo.getParams(); QueryWrapper qw = Wrappers.query(); qw.eq(bo.getInventoryId() != null, "a.inventory_id", bo.getInventoryId()); qw.eq(bo.getEquId() != null, "a.equ_id", bo.getEquId()); qw.eq(StringUtils.isNotBlank(bo.getStatus()), "a.status", bo.getStatus()); qw.like(StringUtils.isNotBlank(bo.getEquName()), "c.equ_name", bo.getEquName()); return qw; } /** * 新增盘点明细 * * @param bo 盘点明细 * @return 是否新增成功 */ @Override public Boolean insertByBo(EimsInventoryDetailBo bo) { EimsInventoryDetail add = MapstructUtils.convert(bo, EimsInventoryDetail.class); validEntityBeforeSave(add); boolean flag = baseMapper.insert(add) > 0; if (flag) { bo.setId(add.getId()); } return flag; } /** * 修改盘点明细 * * @param bo 盘点明细 * @return 是否修改成功 */ @Override public Boolean updateByBo(EimsInventoryDetailBo bo) { EimsInventoryDetail update = MapstructUtils.convert(bo, EimsInventoryDetail.class); validEntityBeforeSave(update); return baseMapper.updateById(update) > 0; } /** * 保存前的数据校验 */ private void validEntityBeforeSave(EimsInventoryDetail entity) { //TODO 做一些数据校验,如唯一约束 } /** * 校验并批量删除盘点明细信息 * * @param ids 待删除的主键集合 * @param isValid 是否进行有效性校验 * @return 是否删除成功 */ @Override public Boolean deleteWithValidByIds(Collection ids, Boolean isValid) { if (isValid) { //TODO 做一些业务上的校验,判断是否需要校验 } return baseMapper.deleteByIds(ids) > 0; } }