package cn.iocoder.yudao.module.mes.dal.mysql.wm.scrap;
|
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.framework.common.pojo.PageParam;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.scrap.MesWmScrapReceiptDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import java.time.LocalDateTime;
|
import java.util.List;
|
import java.util.Map;
|
|
@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);
|
}
|
@Select("SELECT COUNT(*) FROM mes_wm_scrap_receipt r JOIN mes_wm_transaction t " +
|
"ON t.id = r.transaction_id AND t.deleted = 0 " +
|
"WHERE r.deleted = 0 AND t.material_stock_id = #{stockId}")
|
long countByStockId(@Param("stockId") Long stockId);
|
default PageResult<MesWmScrapReceiptDO> selectReceiptPage(PageParam page, Long workOrderId) {
|
return selectPage(page, new LambdaQueryWrapperX<MesWmScrapReceiptDO>()
|
.eqIfPresent(MesWmScrapReceiptDO::getWorkOrderId, workOrderId)
|
.orderByDesc(MesWmScrapReceiptDO::getId));
|
}
|
@Select("SELECT work_order_id AS workOrderId, work_order_code AS workOrderCode, item_id AS itemId, " +
|
"SUM(quantity) AS quantity FROM mes_wm_scrap_receipt " +
|
"WHERE deleted = 0 AND receipt_time >= #{start} AND receipt_time < #{end} " +
|
"GROUP BY work_order_id, work_order_code, item_id ORDER BY work_order_code, item_id")
|
List<Map<String, Object>> summarize(@Param("start") LocalDateTime start, @Param("end") LocalDateTime end);
|
}
|
