package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.Identity;

public interface IdentityMapper extends BaseMapper<Identity> {
//    @Select("select id," +
//            "num," +
//            "month_value," +
//            "year_value," +
//            "type," +
//            "remark " +
//            " from mes_sys_identity t1 where t1.type = #{type}")
//    public MesSysIdentity findIdentityByType(@Param("type")String type);


    @Select("select id," +
            "num," +
            "month_value," +
            "year_value," +
            "type," +
            "remark " +
            " from mom_sys_identity t1 where t1.type = #{type} and t1.year_value = #{yearValue} and t1.month_value =#{monthValue}")
    public Identity findIdentityByType(@Param("type") String type, @Param("yearValue") String yearValue, @Param("monthValue") String monthValue);
}