package com.zioinfo.mes.oee.mapper;

import com.zioinfo.mes.oee.MesOeeRecord;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

@Mapper
public interface OeeMapper {
    List<MesOeeRecord> findAll(@Param("equipmentCode") String equipmentCode, @Param("limit") int limit);
    MesOeeRecord findById(@Param("id") Long id);
    int insert(MesOeeRecord r);
    /** 비가동 코드별 집계. */
    List<Map<String, Object>> downtimePareto(@Param("days") int days);
}
