1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| @Select("Select #{role} role,id,name,parentId,action,displayed,ordered From Menu Where parentId = #{id} and displayed is true and id in (select menu from menu_role where role in (1,#{role})) order by ordered asc")
@Results(value = {
@Result(property = "id", column = "id"),
@Result(property = "name", column = "name"),
@Result(property = "action", column = "action"),
@Result(property = "displayed", column = "displayed"),
@Result(property = "ordered", column = "ordered"),
//@Result(property = "menu", javaType = com.laplace.mvc.model.Menu.class, column = "parentId",one=@One(select = "MenuMapper.findById")),
@Result(property = "menu", javaType = com.laplace.mvc.model.Menu.class, column = "parentId",one=@One(select = "findById")),
@Result(property = "menus", javaType = Set.class, column="{id=id,role=role}", many=@Many(select = "findByParentByRole")) //{id=id,TypeRole=TypeRole}
})
public Menu findByParentByRole(int id,int role);
@Select("Select #{role} role,id,name,parentId,action,displayed,ordered From Menu Where parentId is null and displayed is true and id in (select menu from menu_role where role in (1,#{role})) order by ordered asc")
@Results(value = {
@Result(property = "id", column = "id"),
@Result(property = "name", column = "name"),
@Result(property = "action", column = "action"),
@Result(property = "displayed", column = "displayed"),
@Result(property = "ordered", column = "ordered"),
//@Result(property = "menu", javaType = com.laplace.mvc.model.Menu.class, column = "parentId",one=@One(select = "MenuMapper.findById")),
@Result(property = "menu", javaType = com.laplace.mvc.model.Menu.class, column = "parentId",one=@One(select = "findById")),
@Result(property = "menus", javaType = Set.class, column="{id=id,role=role}", many=@Many(select = "findByParentByRole"))//{id=id,TypeRole=TypeRole}
})
public List<Menu> findByRole(int role); |
Partager