package com.casic.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.casic.config.dto.RoleDto;
import com.casic.model.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author cz
 */

@Mapper
public interface UsersMapper extends BaseMapper<User> {

    @Select(" SELECT  id,name " +
            " FROM  sys_role  " +
            " where  name like '%达州%' " +
            " AND DEL_FLAG=0 ")
    List<RoleDto> getRolesByName();

    @Select("SELECT ID " +
            "FROM SYS_DEPT " +
            "WHERE SIMPLE_NAME LIKE  '%达州%'" +
            "AND DEL_FLAG=0  " +
            "LIMIT  1 ")
     Long getDeptIdByName();
}