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 org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.util.List; /** * MES 销售出库明细 Mapper * * @author 超级管理员 */ @Mapper public interface MesWmProductSalesDetailMapper extends BaseMapperX { /** 只认可该订单已完成出库、且明确关联销售明细的实际拣货批次。 */ @Select("SELECT COUNT(*) FROM mes_wm_product_sales_detail d " + "JOIN mes_wm_product_sales s ON s.id = d.sales_id AND s.deleted = 0 " + "JOIN mes_wm_product_sales_line l ON l.id = d.line_id AND l.sales_id = s.id AND l.deleted = 0 " + "JOIN erp_sale_order_items i ON i.id = l.sale_order_item_id AND i.order_id = s.sale_order_id AND i.deleted = 0 " + "JOIN mes_wm_batch b ON b.id = d.batch_id AND b.deleted = 0 AND b.item_id = d.item_id " + "WHERE d.deleted = 0 AND s.sale_order_id = #{orderId} AND s.status = #{finishedStatus} " + "AND d.item_id = #{itemId} AND l.item_id = #{itemId} AND i.product_id = #{itemId} " + "AND CAST(i.reel_no AS BINARY) = CAST(b.reel_no AS BINARY) " + "AND d.batch_id = #{batchId}") Long countFinishedSaleBatch(@Param("orderId") Long orderId, @Param("itemId") Long itemId, @Param("batchId") Long batchId, @Param("finishedStatus") Integer finishedStatus); default List selectListByLineId(Long lineId) { return selectList(MesWmProductSalesDetailDO::getLineId, lineId); } default List selectListBySalesId(Long salesId) { return selectList(MesWmProductSalesDetailDO::getSalesId, salesId); } default void deleteByLineId(Long lineId) { delete(MesWmProductSalesDetailDO::getLineId, lineId); } default void deleteBySalesId(Long salesId) { delete(MesWmProductSalesDetailDO::getSalesId, salesId); } }