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.SerialNumberMap;

public interface SerialNumberMapMapper extends BaseMapper<SerialNumberMap> {
    @Select("select id," +
            "function_name," +
            "begin_symbol," +
            "enterprise_code," +
            "year_format," +
            "month_format," +
            "day_format," +
            "type," +
            "identity_id" +
            " from mom_serial_number_map t1 where t1.type = #{type}")
    public SerialNumberMap getByType(@Param("type") String type);

    @Select("<script> select F_GET_SEQ_ID(#{type}) </script>")
    public String getNum(@Param("type") String type);

    boolean  updateBatchByEnterpriseCode(@Param("enterpriseCode") String enterpriseCode);
}