1、定义表格
<div style="float:left;width:25%">
<table id="munu-table" class="layui-table" lay-filter="munu-table"></table>
</div>
2、表格js实现tree
<script>
layui.use(['form','table', 'treetable'], function () {
var $ = layui.jquery;
var table = layui.table;
var treeTable = layui.treetable;
form = layui.form,
// 渲染表格
layer.load(2);
treeTable.render({
treeColIndex: 1,//设置下拉箭头在第在几列
treeSpid: 1,//最上级的父级id (-1是根目录)
treeIdName: 'deptId',//id字段的名称(自己的id)
treePidName: 'parentId',//pid字段的名称(父亲的id)
elem: '#munu-table',//表格的id
url: '/core/confidentialityagency/listAll',
page: false,
cols: [
[
{type: 'numbers'},
{field: 'deptName', minWidth: 200, title: '机构'}
]
],
done: function () {
layer.closeAll('loading');
}
});
//点击实现
table.on('row(munu-table)', function (obj) {
alert("机构ID:"+obj.data.deptId);
console.log(obj.data.deptId); //得到当前行数据
///根据行Id加载机构数据及人员数据。
});
});
</script>
3、后台实现查询
@RequestMapping("/confidentialityagency/listAll")
@ResponseBody
public JsonResult getDeptTress() {
QueryWrapper<SysDept> queryWrapper=new QueryWrapper<>();
queryWrapper.lambda().ne(SysDept::getParentId, "-1");//除去根目录,(treeSpid: 1,//最上级的父级id (-1是根目录))
List<SysDept> list = sysDeptMapper.selectList(queryWrapper);
return JsonResult.success("查看成功", list);
}
效果如下