| | |
| | | |
| | | private String cnName; |
| | | |
| | | private Integer type; |
| | | |
| | | private Integer pid; |
| | | |
| | | private Integer level; |
| | |
| | | this.cnName = cnName; |
| | | } |
| | | |
| | | public Integer getType() { |
| | | return type; |
| | | } |
| | | |
| | | public void setType(Integer type) { |
| | | this.type = type; |
| | | } |
| | | |
| | | public Integer getPid() { |
| | | return pid; |
| | | } |
| | |
| | | <mapper namespace="com.moon.server.mapper.sys.RoleResMapper"> |
| | | <select id="selectResByRole" resultType="com.moon.server.entity.sys.RoleResEntity"> |
| | | with rs as (select id, resid from lf.sys_role_res where roleid = #{roleid}) |
| | | select (select id from rs b where b.resid = a.id) "id", a.id "resid", a.cn_name, a.pid, a.level, a.sort |
| | | select (select id from rs b where b.resid = a.id) "id", a.id "resid", a.cn_name, a.type, a.pid, a.level, a.sort |
| | | from lf.sys_res a; |
| | | </select> |
| | | |