| | |
| | | |
| | | private Integer id; |
| | | |
| | | private Integer pid; |
| | | |
| | | private Integer orderNum; |
| | | |
| | | private String cnName; |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public Integer getPid() { |
| | | return pid; |
| | | } |
| | | |
| | | public void setPid(Integer pid) { |
| | | this.pid = pid; |
| | | } |
| | | |
| | | public Integer getOrderNum() { |
| | | return orderNum; |
| | | } |
| | |
| | | </select> |
| | | |
| | | <select id="selectPermsEntity" resultType="com.lf.server.entity.all.PermsAuthEntity"> |
| | | select distinct e.id,e.order_num,e.cn_name,e.en_name,f.name,e.perms,f.tag |
| | | select distinct e.id,e.pid,e.order_num,e.cn_name,e.en_name,f.name,e.perms,f.tag |
| | | from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid |
| | | inner join lf.sys_role_menu_auth c on b.roleid = c.roleid |
| | | inner join lf.sys_menu_auth d on c.menu_auth_id = d.id |