| | |
| | | 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 芋道源码 |
| | | * @author 超级管理员 |
| | | */ |
| | | @Mapper |
| | | public interface MesWmProductSalesDetailMapper extends BaseMapperX<MesWmProductSalesDetailDO> { |
| | | |
| | | /** 只认可该订单已完成出库、且明确关联销售明细的实际拣货批次。 */ |
| | | @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<MesWmProductSalesDetailDO> selectListByLineId(Long lineId) { |
| | | return selectList(MesWmProductSalesDetailDO::getLineId, lineId); |
| | | } |