| | |
|---|
| | | + "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 BINARY i.reel_no = BINARY b.reel_no " |
|---|
| | | + "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); |
|---|
