com.addplus.server.security.service.mapper.SysMenuCommonMapper Maven / Gradle / Ivy
The newest version!
package com.addplus.server.security.service.mapper;
import com.addplus.server.core.model.authority.data.SysMenuCommon;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface SysMenuCommonMapper extends BaseMapper {
@Select("SELECT\n" +
" id,\n" +
" NAME,\n" +
" m_desc,\n" +
" url,\n" +
" sort,\n" +
" is_deleted,\n" +
" gmt_create,\n" +
" gmt_modified,\n" +
" module,\n" +
" filter,\n" +
" modify_user \n" +
"FROM\n" +
" sys_menu_common \n" +
"WHERE\n" +
" is_deleted = 0 \n" +
" AND module = #{module} ORDER BY sort DESC")
List getMenuCommonByModule(@Param("module") String module);
}