| | |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | public interface MesWmScrapReceiptMapper extends BaseMapperX<MesWmScrapReceiptDO> { |
|---|
| | | @Select("SELECT l.item_id AS itemId, l.batch_id AS batchId, l.batch_code AS batchCode, SUM(l.quantity) AS quantity FROM mes_wm_product_produce p " + |
|---|
| | | "JOIN mes_wm_product_produce_line l ON l.produce_id=p.id AND l.deleted=0 " + |
|---|
| | | "WHERE p.deleted=0 AND p.work_order_id=#{orderId} AND p.status=#{finished} " + |
|---|
| | | "AND l.item_id IS NOT NULL AND l.quantity > 0 GROUP BY l.item_id,l.batch_id,l.batch_code") |
|---|
| | | List<cn.iocoder.yudao.module.mes.controller.admin.wm.scrap.MesWmScrapReceiptController.OutputItem> selectOrderOutputs( |
|---|
| | | @Param("orderId") Long orderId, @Param("finished") Integer finished); |
|---|
| | | default MesWmScrapReceiptDO selectByCode(String code) { |
|---|
| | | return selectOne(MesWmScrapReceiptDO::getCode, code); |
|---|
| | | } |
|---|
