<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="io.dataease.base.mapper.ext.ExtSysMenuMapper">

    <resultMap id="simpleNode" type="io.dataease.controller.sys.request.SimpleTreeNode">
        <id property="id" column="id" javaType="java.lang.Long" />
        <result property="pid" column="pid" javaType="java.lang.Long"/>
    </resultMap>

    <select id="allNodes" resultMap="simpleNode">
        select menu_id as id, pid from sys_menu where hidden != 1
    </select>


    <select id="nodesByExample" parameterType="io.dataease.base.mapper.ext.query.GridExample" resultMap="simpleNode">
        select menu_id as id, pid from sys_menu
        <include refid="io.dataease.base.mapper.ext.query.GridSql.gridCondition" />
        and hidden != 1
    </select>


</mapper>
