<link rel="stylesheet" type="text/css" href="/plugins/jquery-treetable-master/css/jquery.treetable.css">

<link rel="stylesheet" type="text/css"

      href="/plugins/jquery-treetable-master/css/jquery.treetable.theme.default.css">

    <div class="box-body table-responsive no-padding">

                    <table id="treetable">

                        <thead>

                        <tr>

                            <th width="80px">部门名称</th>

                            <th>规章制度</th>

                            <th width="120px">操作</th>

                            <th width="120px">操作</th>

                        </tr>

                        </thead>

                        <tbody>

                        <#list treeDept as o>

                            <#if o.parentId == '' || o.parentId == null>

                                <tr data-tt-id="${(o.id)!}">

                                    <td><span class='folder'/>${o.deptName}</td>

                                    <td>${o.deptDesc}</td>

                                    <td>

                                        <#if permissions?seq_contains('editDept')>

                                            <a class="btn btn-primary btn-xs" href="/system/dept/edit/${(o.id)!}"> <i

                                                    class="fa fa-pencil-square-o"></i> 编辑</a>

                                            <#else>-

                                        </#if>

                                    </td>

                                    <td>

                                        <#if permissions?seq_contains('deleteDept')>

                                            <a class="btn btn-danger btn-xs"

                                               onclick="del('${(o.parentIds)!}')"

                                            ><i class="fa fa-times"></i> 删除</a>

                                            <#else>-

                                        </#if>

                                    </td>

                                </tr>

                                <#else>

                                    <tr data-tt-id="${(o.id)!}" data-tt-parent-id="${(o.parentId)!}">

                                        <td><span class='folder'/>${o.deptName}</td>

                                        <td>${o.deptDesc}</td>

                                        <td>

                                            <#if permissions?seq_contains('editDept')>

                                                <a class="btn btn-primary btn-xs" href="/system/dept/edit/${(o.id)!}">

                                                    <i

                                                            class="fa fa-pencil-square-o"></i> 编辑</a>

                                                <#else>-

                                            </#if>

                                        </td>

                                        <td>

                                            <#if permissions?seq_contains('deleteDept')>

                                                <a class="btn btn-danger btn-xs"

                                                   onclick="del('${(o.parentIds)!}')"

                                                ><i class="fa fa-times"></i> 删除</a>

                                                <#else>-

                                            </#if>

                                        </td>

                                    </tr>

                            </#if>

                        </#list>

                        </tbody>

                        <!--t-->

                    </table>

                </div>

<script src="/plugins/jquery-treetable-master/jquery.treetable.js"></script>

<script>

    function del(parentIds) {

        if (confirm("您确定要删除该条记录吗")) {

            $.ajax({

                type: "POST",

                url: "/system/dept/delete",

                data: {parentIds: parentIds}, // 省级别

                dataType: 'json',

                success: function (data) {

                    alert(data.msg);

                    if (data.code == 0) {

                        window.location.href = "/system/dept/list/1"

                    }

                    debugger

                }, error: function () {

                    alert("错了");

                }

            });

        }

    }

</script>

<script>

    $("#treetable").treetable({

        expandable: true,// 展示

        initialState: "expanded",//默认打开所有节点

        stringCollapse: '关闭',

        stringExpand: '展开',

        onNodeExpand: function () {// 分支展开后的回调函数

            var node = this;        //判断当前节点是否已经拥有子节点

            var childSize = $("#treetable").find("[data-tt-parent-id='" + node.id + "']").length;

            if (childSize > 0) {

                return;

            }

            var data = "pageId=" + node.id;         // Render loader/spinner while loading 加载时渲染

            $.ajax({

                loading: false, sync: false,// Must be false, otherwise loadBranch happens after showChildren?

//                    url: context + "/document/loadChild.json",

                data: data,

                success: function (result) {

                    if (0 == result.code) {

                        if (!com.isNull(result.body)) {

                            if (0 == eval(result.body['chilPages']).length) {//不存在子节点

                                var $tr = $("#treetable").find("[data-tt-id='" + node.id + "']");

                                $tr.attr("data-tt-branch", "false");// data-tt-branch 标记当前节点是否是分支节点，在树被初始化的时候生效

                                $tr.find("span.indenter").html("");// 移除展开图标

                                return;

                            }

                            var rows = this.getnereateHtml(result.body['chilPages']);

                            $("#treetable").treetable("loadBranch", node, rows);// 插入子节点

                            $("#treetable").treetable("expandNode", node.id);// 展开子节点

                        }

                    } else {

                        alert(result.tip);

                    }

                }

            });

        }

    });

</script>

    /**

     * 执行新增

     */

    @Permission("addDept")

    @Log("保存部门")

    @RequestMapping("/doSave")

    public String doSave(SysDept dept) {

        if (StringUtils.isNotBlank(dept.getId())) { //编辑

            sysDeptService.doUpdate(dept);

        } else { //新增

            dept.setId(CommonUtil.UUID());

            int recond = sysDeptService.doSave(dept);

        }

        return redirectTo("/system/dept/list/1");

    }

    @Override

    public int doSave(SysDept dept) {

        String id = dept.getId();

        String parentIds = dept.getParentIds();

        parentIds += "/" + id;

        dept.setParentIds(parentIds);

        int record = baseMapper.add(dept);

        return record;

    }

    @Override

    public int doUpdate(SysDept dept) {

        String id = dept.getId();

        String parentIds = dept.getParentIds();

        parentIds += "/" + id;

        dept.setParentIds(parentIds);

        int record = baseMapper.doUpdate(dept);

        return record;

    }

   <select id="selectDeptList" resultMap="BaseResultMap">

        SELECT id,deptName,deptDesc,parentId, parentName,parentIds,sorts

        FROM sys_dept

        where delFlag=0

        <if test="dept!=null and dept.deptName != null and dept.deptName != ''">

            and deptName like concat('%',#{dept.deptName},'%')

        </if>

        <if test="dept!=null and dept.parentIds != null and dept.parentIds != ''">

            and parentIds like concat('%',#{dept.parentIds},'%')

        </if>

        ORDER BY

        parentIds

    </select>

<insert id="add"

            parameterType="com.vacomall.entity.SysDept">

        INSERT INTO sys_dept (

              id,

              deptName,

              deptDesc,

              parentId,

              parentName,

              sorts,

              deptCode,

              parentIds

            )

            VALUES

              (

                #{id,jdbcType=VARCHAR},

                #{deptName,jdbcType=VARCHAR},

                #{deptDesc,jdbcType=VARCHAR},

                #{parentId,jdbcType=VARCHAR},

                #{parentName,jdbcType=VARCHAR},

                #{sorts,jdbcType=TINYINT},

                #{deptCode,jdbcType=VARCHAR},

                #{parentIds,jdbcType=VARCHAR}

              )

    </insert>

    <update id="doUpdate" parameterType="com.vacomall.entity.SysDept">

        update sys_dept

        set

         deptName = #{deptName,jdbcType=VARCHAR},

        deptDesc = #{deptDesc,jdbcType=VARCHAR},

        parentId = #{parentId,jdbcType=VARCHAR},

        parentName = #{parentName,jdbcType=VARCHAR},

        parentIds = #{parentIds,jdbcType=VARCHAR},

        sorts = #{sorts,jdbcType=TINYINT},

        deptCode = #{deptCode,jdbcType=VARCHAR}

        where id = #{id,jdbcType=VARCHAR}

    </update>