package org.jeecg.modules.eam.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.SysFileName;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.eam.model.DepartVo;
import org.jeecg.modules.eam.vo.SysFileNameVo;

/**
 * @Description: 文件名称管理
 * @Author: jeecg-boot
 * @Date:   2023-11-03
 * @Version: V1.0
 */
public interface SysFileNameMapper extends BaseMapper<SysFileName> {


    /**
     * 通过单据类型获取单据编码
     * qsw 2023-11-3
     */
    @Select("select t1.id as receipts,t1.id as maintenanceOrderUda3,t1.num as receiptsNum,t2.item_text as receiptsName,t1.num as receiptsNum2,t2.item_text as receiptsName2 from sys_file_name t1 left join (SELECT * FROM v_sys_dict WHERE dict_code = 'sys_file_name') t2 on t2.item_value = t1.name where t1.version_status = '2' and t1.name =#{name}")
    List<SysFileNameVo> getSysFileName(@Param("name")String name);

}