package cn.iocoder.yudao.module.mes.dal.mysql.wm.productsales; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productsales.MesWmProductSalesShipmentDO; import org.apache.ibatis.annotations.Mapper; import java.util.List; import java.util.Collection; @Mapper public interface MesWmProductSalesShipmentMapper extends BaseMapperX { default List selectBySalesId(Long salesId) { return selectList(new LambdaQueryWrapperX() .eq(MesWmProductSalesShipmentDO::getSalesId, salesId) .orderByAsc(MesWmProductSalesShipmentDO::getId)); } default List selectCompletedBySalesIds(Collection salesIds) { if (salesIds.isEmpty()) return List.of(); return selectList(new LambdaQueryWrapperX() .in(MesWmProductSalesShipmentDO::getSalesId, salesIds).eq(MesWmProductSalesShipmentDO::getStatus, 30)); } default MesWmProductSalesShipmentDO selectActive(Long salesId) { return selectOne(new LambdaQueryWrapperX() .eq(MesWmProductSalesShipmentDO::getSalesId, salesId) .in(MesWmProductSalesShipmentDO::getStatus, 10, 20) .orderByDesc(MesWmProductSalesShipmentDO::getId).last("LIMIT 1")); } }