树形表格

树形表格采用layui的treetable实现，继承自普通表格，在原有表格基础上添加一定配置即可。

配置treegrid=1

            
<body id="sys_resource"   treegrid="1" ></body>

表达式返回树形结构的数据

                    StringBuilder sql=new StringBuilder();
        sql.append("
        SELECT
        RESOURCE_ID ID ,  PARENT_RESOURCE_ID PARENT_ID ,RESOURCE_NAME NAME,
        RESOURCE_NAME, RESOURCE_URL, RESOURCE_ICON,DISPLAY_ORDER FROM T_SYS_RESOURCE A WHERE DELETE_FLAG = 0
        ");
        return treeSearch(sql,"RESOURCE_NAME","ID","PARENT_RESOURCE_ID","0");

append_foot配置补充按钮等代码



<div id="append_foot">
<script type="text/html" id="TPL-treeTable-demo">
    <div class="layui-btn-container">
        <button class="layui-btn" lay-event="addRoot">新增</button>
    </div>
</script>
<script type="text/html" id="TPL-treeTable-demo-tools">
    <div class="layui-btn-container">
        <a class=" layui-btn" lay-event="addChild">新增子资源</a>
    </div>
</script>
<script>
    layui.use(function(){
        var treeTable = layui.treeTable;
        treeTable.on("toolbar(TPL-treeTable-demo)", function (obj) {
            if (obj.event === "addRoot") {
                openModel("/topezadmin/form/form-sys_resource?PID=0","添加");
            }
        });
        treeTable.on('tool(treetable)', function (obj) {
            var trData = obj.data;
            if ( obj.event === "addChild") {
                openModel("/topezadmin/form/form-sys_resource?PID="+trData.ID,"添加");
            }
        });
    })
</script>
</div>

url访问

/topezadmin/list/tree-${code}