package com.casic.missiles.mapper.sys;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.poi.ss.formula.functions.T;

@Mapper
public interface PrintFileRegisterMapper {


    @Select(" SELECT minio_file_name " +
            " FROM  ${tableName}  " +
            " WHERE id =#{id}" +
            " AND  is_del=0  ")
    String getSignFileSealById(@Param("id")Long id, @Param("tableName")String tableName);

    @Select(" SELECT minio_file_name " +
            " FROM  ${tableName}  " +
            " WHERE template_name =#{name}" +
            " AND  is_del=0 " +
            " limit 1 ")
    String   getFileNameByName(@Param("name")String name,@Param("tableName")String tableName);
    @Select(" SELECT minio_file_name " +
            " FROM  system_sign  " +
            " WHERE sign_user_id =#{signUserId}  " +
            " AND  is_del=0" +
            " limit 1")
    String getSignFileNameById(@Param("signUserId")Long signUserId);
}
