package com.zioinfo.mes.lotserial.mapper;

import com.zioinfo.mes.lotserial.MesLotSerial;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface LotSerialMapper {
    List<MesLotSerial> findAll(@Param("itemCode") String itemCode,
                               @Param("status") String status,
                               @Param("keyword") String keyword);
    MesLotSerial findById(@Param("id") Long id);
    MesLotSerial findByLot(@Param("lotNo") String lotNo);
    int insert(MesLotSerial l);
    int updateStatus(@Param("id") Long id, @Param("status") String status);
    /** 유효기간 임박(days 이내) LOT. */
    List<MesLotSerial> findExpiringSoon(@Param("days") int days);
}
