package cn.iocoder.yudao.module.mes.dal.mysql.wm.stockwarning; 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.module.mes.controller.admin.wm.stockwarning.vo.MesWmStockWarningRulePageReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stockwarning.MesWmStockWarningRuleDO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.math.BigDecimal; import java.util.Collection; import java.util.List; /** * MES 库存预警规则 Mapper */ @Mapper public interface MesWmStockWarningRuleMapper extends BaseMapperX { default PageResult selectPage(MesWmStockWarningRulePageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .eqIfPresent(MesWmStockWarningRuleDO::getItemId, reqVO.getItemId()) .eqIfPresent(MesWmStockWarningRuleDO::getWarehouseId, reqVO.getWarehouseId()) .eqIfPresent(MesWmStockWarningRuleDO::getEnabled, reqVO.getEnabled()) .orderByDesc(MesWmStockWarningRuleDO::getId)); } default List selectListByItemIds(Collection itemIds) { return selectList(new LambdaQueryWrapperX() .in(MesWmStockWarningRuleDO::getItemId, itemIds) .eq(MesWmStockWarningRuleDO::getEnabled, true)); } /** * 按物料 + 仓库汇总现有库存数量 */ @Select("") List selectStockQuantitySumList(@Param("itemIds") Collection itemIds); /** * 物料 + 仓库维度的库存汇总 */ class StockQuantitySum { private Long itemId; private Long warehouseId; private BigDecimal quantity; public Long getItemId() { return itemId; } public void setItemId(Long itemId) { this.itemId = itemId; } public Long getWarehouseId() { return warehouseId; } public void setWarehouseId(Long warehouseId) { this.warehouseId = warehouseId; } public BigDecimal getQuantity() { return quantity; } public void setQuantity(BigDecimal quantity) { this.quantity = quantity; } } }