package cn.iocoder.yudao.module.wms.dal.mysql.md.item;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.MPJLambdaWrapperX;
|
import cn.iocoder.yudao.module.wms.controller.admin.md.item.vo.sku.WmsItemSkuPageReqVO;
|
import cn.iocoder.yudao.module.wms.dal.dataobject.md.item.WmsItemDO;
|
import cn.iocoder.yudao.module.wms.dal.dataobject.md.item.WmsItemSkuDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.Collection;
|
import java.util.Collections;
|
import java.util.List;
|
|
/**
|
* WMS 商品 SKU Mapper
|
*
|
* @author 芋道源码
|
*/
|
@Mapper
|
public interface WmsItemSkuMapper extends BaseMapperX<WmsItemSkuDO> {
|
|
/**
|
* 按 SKU 维度分页查询，支持商品 / 品牌 / 分类多表联查筛选。
|
*
|
* 使用 {@link MPJLambdaWrapperX} 替代 lite 的手写 XML JOIN（见 lite
|
* {@code ItemSkuMapper.selectByBo}），范式参照本模块 {@code WmsInventoryMapper.selectPage}。
|
*/
|
default PageResult<WmsItemSkuDO> selectPage(WmsItemSkuPageReqVO reqVO) {
|
MPJLambdaWrapperX<WmsItemSkuDO> query = new MPJLambdaWrapperX<WmsItemSkuDO>()
|
.selectAll(WmsItemSkuDO.class)
|
.innerJoin(WmsItemDO.class, WmsItemDO::getId, WmsItemSkuDO::getItemId)
|
.likeIfPresent(WmsItemDO::getCode, reqVO.getItemCode())
|
.likeIfPresent(WmsItemDO::getName, reqVO.getItemName())
|
.eqIfPresent(WmsItemDO::getCategoryId, reqVO.getCategoryId())
|
.eqIfPresent(WmsItemDO::getBrandId, reqVO.getBrandId())
|
.likeIfPresent(WmsItemSkuDO::getCode, reqVO.getCode())
|
.likeIfPresent(WmsItemSkuDO::getName, reqVO.getName())
|
.likeIfPresent(WmsItemSkuDO::getBarCode, reqVO.getBarCode())
|
.orderByDesc(WmsItemSkuDO::getId);
|
return selectJoinPage(reqVO, WmsItemSkuDO.class, query);
|
}
|
|
default List<WmsItemSkuDO> selectListByItemId(Long itemId) {
|
return selectList(new LambdaQueryWrapperX<WmsItemSkuDO>()
|
.eq(WmsItemSkuDO::getItemId, itemId)
|
.orderByAsc(WmsItemSkuDO::getId));
|
}
|
|
default List<WmsItemSkuDO> selectListByItemIds(Collection<Long> itemIds) {
|
if (CollUtil.isEmpty(itemIds)) {
|
return Collections.emptyList();
|
}
|
return selectList(new LambdaQueryWrapperX<WmsItemSkuDO>()
|
.inIfPresent(WmsItemSkuDO::getItemId, itemIds)
|
.orderByAsc(WmsItemSkuDO::getId));
|
}
|
|
default List<WmsItemSkuDO> selectList(Collection<Long> itemIds, String code, String name) {
|
if (itemIds != null && CollUtil.isEmpty(itemIds)) {
|
return Collections.emptyList();
|
}
|
return selectList(new LambdaQueryWrapperX<WmsItemSkuDO>()
|
.inIfPresent(WmsItemSkuDO::getItemId, itemIds)
|
.likeIfPresent(WmsItemSkuDO::getCode, code)
|
.likeIfPresent(WmsItemSkuDO::getName, name)
|
.orderByAsc(WmsItemSkuDO::getId));
|
}
|
|
default void deleteByItemId(Long itemId) {
|
delete(WmsItemSkuDO::getItemId, itemId);
|
}
|
|
}
|
