| | |
| | | // String name1 = jsonObject1.getString("name"); |
| | | // JSONObject meta1 = jsonObject1.getJSONObject("meta"); |
| | | // String menu_name1 = meta1.getString("title"); |
| | | // String showLink1 = meta1.getString("showLink"); |
| | | // Boolean showLink1 = meta1.getBoolean("showLink"); |
| | | // SysMenu sysMenu1 = new SysMenu(); |
| | | // sysMenu1.setParentId(sysMenu.getMenuId()); |
| | | // sysMenu1.setMenuName(menu_name1); |
| | |
| | | // sysMenu1.setComponent(component); |
| | | // sysMenu1.setRoleType(5); |
| | | // sysMenu1.setMenuType("C"); |
| | | // sysMenu1.setRouterName(name1); |
| | | // if(showLink1){ |
| | | // sysMenu1.setVisible("0"); |
| | | // }else{ |
| | | // sysMenu1.setVisible("1"); |
| | | // } |
| | | // sysMenuService.insertMenu(sysMenu1); |
| | | // JSONArray children2 = jsonObject1.getJSONArray("children"); |
| | | // if(!CollectionUtils.isEmpty(children2)){ |
| | |
| | | /** 角色类型 1=平台 2=分公司 3=业务员 4=供应商 5=诊所端 6=仓库员 */ |
| | | @TableField(value = "role_type") |
| | | private Integer roleType; |
| | | |
| | | /** 路由名称 */ |
| | | @TableField(value = "router_name") |
| | | private String routerName; |
| | | /** 子菜单 */ |
| | | private List<SysMenu> children = new ArrayList<SysMenu>(); |
| | | |
| | |
| | | this.icon = icon; |
| | | } |
| | | |
| | | public String getRouterName() { |
| | | return routerName; |
| | | } |
| | | |
| | | public void setRouterName(String routerName) { |
| | | this.routerName = routerName; |
| | | } |
| | | |
| | | public List<SysMenu> getChildren() |
| | | { |
| | | return children; |
| | |
| | | |
| | | <sql id="selectMenuVo"> |
| | | select menu_id, menu_name, parent_id, order_num, path, component, `query`, is_frame, is_cache, menu_type, visible, |
| | | status, ifnull(perms,'') as perms, icon, create_time ,role_type |
| | | status, ifnull(perms,'') as perms, icon, create_time ,role_type,router_name |
| | | from sys_menu |
| | | </sql> |
| | | |
| | |
| | | |
| | | <select id="selectMenuTreeAll" resultMap="SysMenuResult"> |
| | | select distinct m.menu_id, m.parent_id, m.menu_name, m.path, m.component, m.`query`, m.visible, m.status, ifnull(m.perms,'') as perms, |
| | | m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time, m.role_type |
| | | m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time, m.role_type, m.router_name |
| | | from sys_menu m where m.menu_type in ('M', 'C') and m.status = 0 |
| | | order by m.parent_id, m.order_num |
| | | </select> |
| | | |
| | | <select id="selectMenuListByUserId" parameterType="com.ruoyi.common.core.domain.entity.SysMenu" resultMap="SysMenuResult"> |
| | | select distinct m.menu_id, m.parent_id, m.menu_name, m.path, m.component, m.`query`, m.visible, m.status, ifnull(m.perms,'') as perms, |
| | | m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time, m.role_type |
| | | m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time, m.role_type, m.router_name |
| | | from sys_menu m |
| | | left join sys_role_menu rm on m.menu_id = rm.menu_id |
| | | left join sys_user_role ur on rm.role_id = ur.role_id |
| | |
| | | |
| | | <select id="selectMenuTreeByUserId" parameterType="Long" resultMap="SysMenuResult"> |
| | | select distinct m.menu_id, m.parent_id, m.menu_name, m.path, m.component, m.`query`, m.visible, m.status, ifnull(m.perms,'') as perms, |
| | | m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time, m.role_type |
| | | m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time, m.role_type, m.router_name |
| | | from sys_menu m |
| | | left join sys_role_menu rm on m.menu_id = rm.menu_id |
| | | left join sys_user_role ur on rm.role_id = ur.role_id |
| | |
| | | <select id="selectListByRoleId" resultType="com.ruoyi.common.core.domain.entity.SysMenu"> |
| | | select sm.menu_id AS menuId, sm.menu_name AS menuName, sm.parent_id AS parentId, sm.order_num AS orderNum, sm.`path` AS path, sm.component AS component, |
| | | sm.`query` AS query, sm.is_frame AS isFrame,sm.is_cache AS isCache, sm.menu_type AS menuType, sm.visible AS visible, sm.status AS status, |
| | | ifnull(sm.perms,'') as perms, sm.icon AS icon, sm.create_time AS createTime,, sm.role_type |
| | | ifnull(sm.perms,'') as perms, sm.icon AS icon, sm.create_time AS createTime, sm.role_type, sm.router_name |
| | | from sys_role_menu srm |
| | | left join sys_menu sm on srm.menu_id = sm.menu_id |
| | | WHERE srm.role_id = #{roleId} |
| | |
| | | IFNULL( perms, '' ) AS perms, |
| | | icon AS icon, |
| | | create_time AS createTime, |
| | | role_type AS roleType |
| | | role_type AS roleType, |
| | | router_name AS routerName |
| | | from sys_menu where menu_id in |
| | | <foreach collection="menusId" close=")" index="index" item="id" open="(" separator=","> |
| | | #{id} |
| | |
| | | IFNULL( perms, '' ) AS perms, |
| | | icon AS icon, |
| | | create_time AS createTime, |
| | | role_type AS roleType |
| | | role_type AS roleType, |
| | | router_name AS routerName |
| | | from sys_menu |
| | | </select> |
| | | |
| | |
| | | <if test="remark != null and remark != ''">remark,</if> |
| | | <if test="createBy != null and createBy != ''">create_by,</if> |
| | | <if test="roleType != null">role_type,</if> |
| | | <if test="routerName != null">router_name,</if> |
| | | create_time |
| | | )values( |
| | | <if test="menuId != null and menuId != 0">#{menuId},</if> |
| | |
| | | <if test="remark != null and remark != ''">#{remark},</if> |
| | | <if test="createBy != null and createBy != ''">#{createBy},</if> |
| | | <if test="roleType != null">#{roleType},</if> |
| | | <if test="routerName != null">#{routerName},</if> |
| | | sysdate() |
| | | ) |
| | | </insert> |