package com.zioinfo.mes.tracking;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface TrackingMapper {
    /** 산출 LOT → 생산실적(작업지시/품목). */
    Map<String, Object> findProductionByLot(@Param("lotNo") String lotNo);

    /** 작업지시에서 투입(CONSUME)된 자재 트랜잭션. */
    List<Map<String, Object>> findConsumedByWo(@Param("woNo") String woNo);

    /** 자재 LOT 가 CONSUME 된 작업지시(ref_no) 목록. */
    List<Map<String, Object>> findWoConsumingLot(@Param("lotNo") String lotNo);

    /** 작업지시가 산출(PRODUCE)한 LOT 목록. */
    List<Map<String, Object>> findProducedLotsByWo(@Param("woNo") String woNo);
}
