package cn.iocoder.yudao.module.mes.dal.mysql.wm.productsales; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productsales.MesWmProductSalesDetailDO; import org.apache.ibatis.annotations.Mapper; import java.util.List; import java.util.Collection; /** * MES 销售出库明细 Mapper * * @author 超级管理员 */ @Mapper public interface MesWmProductSalesDetailMapper extends BaseMapperX { default List selectBySalesIdsAndBagIds(Collection salesIds, Collection bagIds) { if (salesIds.isEmpty() || bagIds.isEmpty()) return List.of(); return selectList(new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper() .in(MesWmProductSalesDetailDO::getSalesId, salesIds) .in(MesWmProductSalesDetailDO::getBagCodeId, bagIds)); } default List selectByBagIds(Collection bagIds) { if (bagIds.isEmpty()) return List.of(); return selectList(new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper() .in(MesWmProductSalesDetailDO::getBagCodeId, bagIds)); } // 仅未取消且尚未完成的出库单占用袋码。旧整托明细也参与重叠判断。 @org.apache.ibatis.annotations.Select(""" SELECT d.* FROM mes_wm_product_sales_detail d JOIN mes_wm_product_sales s ON s.id = d.sales_id LEFT JOIN mes_wm_product_sales_shipment sh ON sh.id = d.shipment_id AND sh.deleted = 0 WHERE d.deleted = 0 AND s.deleted = 0 AND s.status IN (2, 10, 3) AND (d.shipment_id IS NULL OR sh.status IN (10, 20)) AND d.batch_code = #{batchCode} """) List selectPickingByBatchCode(String batchCode); @org.apache.ibatis.annotations.Select(""" SELECT d.* FROM mes_wm_product_sales_detail d JOIN mes_wm_product_sales s ON s.id = d.sales_id LEFT JOIN mes_wm_product_sales_shipment sh ON sh.id = d.shipment_id AND sh.deleted = 0 WHERE d.deleted = 0 AND s.deleted = 0 AND s.status IN (2, 10, 3) AND (d.shipment_id IS NULL OR sh.status IN (10, 20)) AND d.batch_code = #{batchCode} FOR UPDATE """) List selectPickingByBatchCodeForUpdate(String batchCode); default List selectListByLineId(Long lineId) { return selectList(MesWmProductSalesDetailDO::getLineId, lineId); } default void unassignShipment(Long shipmentId) { update(null, new com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper() .eq(MesWmProductSalesDetailDO::getShipmentId, shipmentId) .set(MesWmProductSalesDetailDO::getShipmentId, null)); } default List selectListBySalesId(Long salesId) { return selectList(MesWmProductSalesDetailDO::getSalesId, salesId); } default MesWmProductSalesDetailDO selectBySalesIdAndBagCodeId(Long salesId, Long bagCodeId) { return selectOne(new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper() .eq(MesWmProductSalesDetailDO::getSalesId, salesId) .eq(MesWmProductSalesDetailDO::getBagCodeId, bagCodeId)); } default MesWmProductSalesDetailDO selectBySalesIdAndPalletCodeId(Long salesId, Long palletCodeId) { return selectOne(new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper() .eq(MesWmProductSalesDetailDO::getSalesId, salesId) .eq(MesWmProductSalesDetailDO::getPalletCodeId, palletCodeId).orderByAsc(MesWmProductSalesDetailDO::getId).last("LIMIT 1")); } default void deleteByLineId(Long lineId) { delete(MesWmProductSalesDetailDO::getLineId, lineId); } default void deleteBySalesId(Long salesId) { delete(MesWmProductSalesDetailDO::getSalesId, salesId); } /** * 根据袋码编号查询最近的出库明细(供窜货稽查反查出库去向) */ default MesWmProductSalesDetailDO selectLatestByBagCodeId(Long bagCodeId) { return selectOne(new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper() .eq(MesWmProductSalesDetailDO::getBagCodeId, bagCodeId) .orderByDesc(MesWmProductSalesDetailDO::getId) .last("LIMIT 1")); } /** * 根据托盘码编号查询最近的出库明细(供窜货稽查反查出库去向) */ default MesWmProductSalesDetailDO selectLatestByPalletCodeId(Long palletCodeId) { return selectOne(new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper() .eq(MesWmProductSalesDetailDO::getPalletCodeId, palletCodeId) .orderByDesc(MesWmProductSalesDetailDO::getId) .last("LIMIT 1")); } }