这里使用layui渲染的导航
实体类
dept.java
private int id; //id
private String dept_name; //部门名称
private int pid; //上级部门id
private int sort_num; //排序值
private int create_id; //创建人
private String create_time; //创建时间
private int modify_id; //修改人
private String modify_time; //最后修改时间
private int is_del; // 是否删除 0 未删除 1 已删除
private int status; //status
private String remark; //remark
private List<Dept> deptChild = new ArrayList<>(); //部门迭代
DeptMapper.java
List<Dept> selectDeptForJsonMenu();
DeptMapper.xml
<resultMap type="com.ys.entity.Dept" id="deptFirst">
<result column="id" property="id" javaType="java.lang.Integer" />
<result column="dept_name" property="dept_name" javaType="java.lang.String" />
<result column="sort_num" property="sort_num" javaType="java.lang.Integer" />
<result column="create_time" property="create_time" javaType="java.lang.String" />
<result column="modify_id" property="modify_id" javaType="java.lang.Integer" />
<result column="modify_time" property="modify_time" javaType="java.lang.String" />
<result column="is_del" property="is_del" javaType="java.lang.Integer" />
<result column="status" property="status" javaType="java.lang.Integer" />
<result column="remark" property="remark" javaType="java.lang.String" />
<collection column="id" property="deptChild" javaType="java.util.ArrayList" select="selectDeptForJsonMenuChild"/>
</resultMap>
<!-- 查询部门菜单树 -->
<select id="selectDeptForJsonMenu" resultMap="deptFirst">
SELECT * FROM sys_dept WHERE pid = 0 AND is_del = 0 ORDER BY sort_num
</select>
<select id="selectDeptForJsonMenuChild" resultMap="deptFirst" parameterType="java.lang.Integer">
select * FROM sys_dept where pid = #{id} AND is_del = 0 ORDER BY sort_num
</select>
DeptService.java
public List<Dept> selectDeptForJsonMenu(){
return mapper.selectDeptForJsonMenu();
}
DeptController.java
@RequestMapping(value = "selectDeptForJsonMenu",method={RequestMethod.GET,RequestMethod.POST})
@ResponseBody
public List<Dept> selectDeptForJsonMenu(){
return service.selectDeptForJsonMenu();
}
html 引入layui.js,layui.css 并加载element模块.
<div id="leftMenu">
</div>
$(function(){
$.ajax({
method:'post',
url:getPath+"dept/selectDeptForJsonMenu",
dataType:'json',
success:function(data){
if(data.length > 0){
var showlist = $('<ul class="layui-nav layui-nav-tree"></ul>');
showall(data, showlist);
$("#leftMenu").html(showlist);
}else{
$('#leftMenu').html('<span class="layui-btn layui-btn-primary" id="add">添加</span>') ;
}
}
});
//json为json数据
//parent为最终html拼接内容
function showall(json, parent) {
for (var i in json) {
//有子节点 遍历
if (json[i].deptChild.length > 0) {
//创建li
var li = $('<li class="layui-nav-item layui-nav-itemed"></li>');
$(li).append('<a href="javascript:;" rel="external nofollow" rel="external nofollow" >'+json[i].dept_name+'</a>');
$(li).append('<ul class="layui-nav-child"></ul>').appendTo(parent);
//将UL选中 回调
showall(json[i].deptChild, $(li).children().eq(1));
}
//无子级
else {
$('<li></li>').append('<a href="javascript:;" rel="external nofollow" rel="external nofollow" >'+json[i].dept_name+'</a>').appendTo(parent);
}
}
}
});
总结
以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作具有一定的参考学习价值,谢谢大家对社区的支持。如果你想了解更多相关内容请查看下面相关链接
|