| | |
| | | public class PermsAuthEntity implements Serializable { |
| | | private static final long serialVersionUID = -8948994757253139554L; |
| | | |
| | | private Integer id; |
| | | |
| | | private Integer orderNum; |
| | | |
| | | private String cnName; |
| | | |
| | | private String enName; |
| | | |
| | | private String name; |
| | | |
| | |
| | | |
| | | public PermsAuthEntity() { |
| | | |
| | | } |
| | | |
| | | public Integer getId() { |
| | | return id; |
| | | } |
| | | |
| | | public void setId(Integer id) { |
| | | this.id = id; |
| | | } |
| | | |
| | | public Integer getOrderNum() { |
| | |
| | | this.cnName = cnName; |
| | | } |
| | | |
| | | public String getEnName() { |
| | | return enName; |
| | | } |
| | | |
| | | public void setEnName(String enName) { |
| | | this.enName = enName; |
| | | } |
| | | |
| | | public String getName() { |
| | | return name; |
| | | } |
| | |
| | | </select> |
| | | |
| | | <select id="selectPermsEntity" resultType="com.lf.server.entity.all.PermsAuthEntity"> |
| | | select distinct e.order_num,e.cn_name,f.name,e.perms,f.tag |
| | | select distinct e.id,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 |