<?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="com.xingxi.mq.server.system.mapper.SysDeptVoMapper">

    <resultMap type="SysDept" id="SysDeptResult">
        <result property="deptId"    column="dept_id"    />
        <result property="parentId"    column="parent_id"    />
        <result property="ancestors"    column="ancestors"    />
        <result property="deptName"    column="dept_name"    />
        <result property="deptType"    column="deptType"    />
        <result property="orderNum"    column="order_num"    />
        <result property="leader"    column="leader"    />
        <result property="phone"    column="phone"    />
        <result property="email"    column="email"    />
        <result property="status"    column="status"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createUser"    column="create_user"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateUser"    column="update_user"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectSysDept">
        select
            s.dept_id,
            s.parent_id,
            s.ancestors,
            s.dept_name,
            s.deptType,
            s.order_num,
            s.leader,
            s.phone,
            s.email,
            s.status,
            s.del_flag,
            s.create_user,
            s.create_time,
            s.update_user,
            s.update_time
        from sys_dept s
    </sql>

    <select id="selectParentDeptByDeptId" parameterType="Long" resultMap="SysDeptResult">
        <include refid="selectSysDept"/>
        where s.dept_id = (select parent_id from sys_dept where dept_id = #{deptId})
    </select>

</mapper>
