com.yuweix.kuafu.permission.mapper.SysRolePermissionRelMapper Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of kuafu-spring-boot-starter Show documentation

Kuafu

There is a newer version: 2.0.0

Show newest version

package com.yuweix.kuafu.permission.mapper;


import com.yuweix.kuafu.dao.PersistUtil;
import com.yuweix.kuafu.permission.model.SysRolePermissionRel;
import com.yuweix.kuafu.dao.mybatis.BaseMapper;
import com.yuweix.kuafu.dao.mybatis.provider.AbstractProvider;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.List;
import java.util.Map;


/**
 * @author yuwei
 */
public interface SysRolePermissionRelMapper extends BaseMapper {
	@SelectProvider(type = Provider.class, method = "queryByRoleIdAndPermId")
	SysRolePermissionRel queryByRoleIdAndPermId(@Param("roleId")long roleId, @Param("permId")long permId);

	@SelectProvider(type = Provider.class, method = "queryListByRoleId")
	List queryListByRoleId(@Param("roleId")long roleId);

	@SelectProvider(type = Provider.class, method = "queryPermIdListByRoleId")
	List queryPermIdListByRoleId(@Param("roleId")long roleId);
	
	class Provider extends AbstractProvider {
		public String queryByRoleIdAndPermId(Map param) {
			StringBuilder builder = new StringBuilder("");
			builder.append("  select ").append(PersistUtil.getAllColumnSql(SysRolePermissionRel.class))
					.append(" from ").append(PersistUtil.getTableName(SysRolePermissionRel.class))
					.append(" where role_id = #{roleId} and perm_id = #{permId} ");
			return builder.toString();
		}

		public String queryListByRoleId(Map param) {
			StringBuilder builder = new StringBuilder("");
			builder.append("  select ").append(PersistUtil.getAllColumnSql(SysRolePermissionRel.class))
					.append(" from ").append(PersistUtil.getTableName(SysRolePermissionRel.class))
					.append(" where role_id = #{roleId} ");
			return builder.toString();
		}

		public String queryPermIdListByRoleId(Map param) {
			StringBuilder builder = new StringBuilder("");
			builder.append("  select perm_id ")
					.append(" from ").append(PersistUtil.getTableName(SysRolePermissionRel.class))
					.append(" where role_id = #{roleId} ");
			return builder.toString();
		}
	}
}