部门树修改

Administrator

2021-12-01 7462ddb848226a79bb9a60ed4e1632f63da4a99e

部门树修改

 src/main/java/org/springblade/modules/system/mapper/DeptMapper.xml

@@ -140,6 +140,64 @@
<!--    </select>    -->

    <!--懒加载获取部门树形结构(包含用户数据)-->
<!--    <select id="lazyTreeUser" resultMap="treeNodeResultMap">-->
<!--        select DISTINCT  * from (-->
<!--                    (SELECT-->
<!--              dept.id,-->
<!--              dept.parent_id,-->
<!--              dept.dept_name AS title,-->
<!--              dept.id AS "value",-->
<!--              dept.id AS "key",-->
<!--                        (-->
<!--                            SELECT-->
<!--                                CASE WHEN count(1) > 0 THEN 1 ELSE 0 END-->
<!--                            FROM-->
<!--                                blade_dept-->
<!--                            WHERE-->
<!--                                parent_id = dept.id and is_deleted = 0-->
<!--                        ) AS "has_children"-->
<!--                    FROM-->
<!--                        blade_dept dept-->
<!--                                        left join-->
<!--                                        sys_information si-->
<!--                                        on-->
<!--                                        si.departmentid = dept.id-->
<!--                    WHERE-->
<!--                        dept.is_deleted = 0-->
<!--                        and si.stats = 2-->
<!--                        and si.departmentid !=1432626178757275649-->
<!--                        and si.departmentid !=1445980335107002370-->
<!--                        and si.departmentid !=1442115701350387714-->
<!--            )-->
<!--            union-->
<!--            (select-->
<!--                bu.id,-->
<!--                bu.dept_id  parent_id,-->
<!--                real_name AS title,-->
<!--                bu.id AS "value",-->
<!--                bu.id AS "key",-->
<!--                0 as "has_children"-->
<!--                from blade_user bu-->
<!--                                left join-->
<!--                                blade_dept bd-->
<!--                                on-->
<!--                                bd.id = bu.dept_id-->
<!--                                left join-->
<!--                                sys_information si-->
<!--                                on-->
<!--                                si.departmentid = bd.id-->
<!--                                where bd.is_deleted = 0-->
<!--                                and bu.is_deleted = 0-->
<!--                                and bu.`status` =1-->
<!--                                and si.stats = 2-->
<!--                                and si.departmentid !=1432626178757275649-->
<!--                                and si.departmentid !=1445980335107002370-->
<!--                                and si.departmentid !=1442115701350387714-->
<!--            )-->
<!--        )c-->
<!--    </select>    -->

    <!--懒加载获取部门树形结构(包含用户数据)-->
    <select id="lazyTreeUser" resultMap="treeNodeResultMap">
        select DISTINCT  * from (
                    (SELECT
@@ -197,6 +255,8 @@
        )c
    </select>

    <!--111-->

    <!--懒加载获取部门树形结构(包含用户数据)-->
<!--    <select id="lazyTreeUser" resultMap="treeNodeResultMap">-->
<!--        select DISTINCT  * from (-->