package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.PredictiveWorkPlanParameter;
import org.jeecg.modules.eam.model.ParameterVo;

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

//预测性维护方案 触发条件参数
public interface PredictiveWorkPlanParameterMapper extends BaseMapper<PredictiveWorkPlanParameter> {

    public List<PredictiveWorkPlanParameter> listPredictiveWorkPlanParameter(@Param("params") Map<String, Object> params);

    public IPage<Map<String, Object>> pagePredictiveWorkPlanParameter(IPage<Map> pageData, @Param("params") Map<String, Object> params);

    public List<PredictiveWorkPlanParameter> listParameter(@Param("predictiveWorkPlanId") String predictiveWorkPlanId);


    public ParameterVo findParameterInfo(@Param("saveTableName") String saveTableName, @Param("lowerLimitValue") float lowerLimitValue,
                                         @Param("upperLimitValue") float upperLimitValue, @Param("parameterCode") String parameterCode);


    @Select("<script> ${sql} </script>")
    @InterceptorIgnore(tenantLine = "1")
    ParameterVo findCommonParameterInfo(@Param("sql") String sql);
}