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

Show more of this group Show more artifacts with this name
Show all versions of kuafu-permission Show documentation
Kuafu
There is a newer version: 2.0.0
package com.yuweix.kuafu.permission.mapper;


import com.yuweix.kuafu.dao.PersistUtil;
import com.yuweix.kuafu.permission.model.SysAdmin;
import com.yuweix.kuafu.permission.model.SysAdminRoleRel;
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 SysAdminMapper extends BaseMapper {
	@SelectProvider(type = Provider.class, method = "findAdminByAccountNo")
	SysAdmin findAdminByAccountNo(@Param("accountNo")String accountNo);
	
	@SelectProvider(type = Provider.class, method = "hasPermission")
	boolean hasPermission(@Param("adminId")long adminId, @Param("permissionId")long permissionId);

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

	@SelectProvider(type = Provider.class, method = "findCountByRoleId")
	int findCountByRoleId(@Param("roleId")long roleId, @Param("keywords")String keywords);

	@SelectProvider(type = Provider.class, method = "findListByRoleId")
	List findListByRoleId(@Param("roleId")long roleId, @Param("keywords")String keywords
			, @Param("pageNo")Integer pageNo, @Param("pageSize")Integer pageSize);
	
	
	class Provider extends AbstractProvider {
		public String findAdminByAccountNo(Map param) {
			StringBuilder builder = new StringBuilder("");
			builder.append("  select ").append(PersistUtil.getAllColumnSql(SysAdmin.class))
					.append(" from ").append(PersistUtil.getTableName(SysAdmin.class))
					.append(" where account_no = #{accountNo} ");
			return builder.toString();
		}
		
		public String hasPermission(Map param) {
			StringBuilder builder = new StringBuilder("");
			builder.append("  select count(a.id) > 0 ")
					.append(" from ").append(PersistUtil.getTableName(SysAdminRoleRel.class)).append(" a ")
					.append(" inner join ").append(PersistUtil.getTableName(SysRolePermissionRel.class)).append(" b on a.admin_id = #{adminId} and a.role_id = b.role_id and b.perm_id = #{permissionId} ");
			return builder.toString();
		}

		public String queryPermissionIdListByAdminId(Map param) {
			StringBuilder builder = new StringBuilder("");
			builder.append("  select distinct b.perm_id ")
					.append(" from ").append(PersistUtil.getTableName(SysAdminRoleRel.class)).append(" a ")
					.append(" inner join ").append(PersistUtil.getTableName(SysRolePermissionRel.class)).append(" b on a.admin_id = #{adminId} and a.role_id = b.role_id ");
			return builder.toString();
		}

		public String findCountByRoleId(Map param) {
			String keywords = (String) param.get("keywords");

			StringBuilder builder = new StringBuilder("");
			builder.append(" select count(distinct b.id) as cnt ");
			builder.append(" from ").append(PersistUtil.getTableName(SysAdminRoleRel.class)).append(" a ");
			builder.append(" inner join ").append(PersistUtil.getTableName(SysAdmin.class)).append(" b on a.admin_id = b.id ");
			builder.append(" where a.role_id = #{roleId} ");
			if (keywords != null && !"".equals(keywords.trim())) {
				param.put("keywords", "%" + keywords.trim() + "%");
				builder.append(" and (b.account_no like #{keywords} or b.real_name like #{keywords}) ");
			}
			return builder.toString();
		}

		public String findListByRoleId(Map param) {
			String keywords = (String) param.get("keywords");
			Integer pageNo = (Integer) param.get("pageNo");
			Integer pageSize = (Integer) param.get("pageSize");

			StringBuilder builder = new StringBuilder("");
			builder.append(" select distinct ").append(PersistUtil.getAllColumnSql(SysAdmin.class, "b"));
			builder.append(" from ").append(PersistUtil.getTableName(SysAdminRoleRel.class)).append(" a ");
			builder.append(" inner join ").append(PersistUtil.getTableName(SysAdmin.class)).append(" b on a.admin_id = b.id ");
			builder.append(" where a.role_id = #{roleId} ");
			if (keywords != null && !"".equals(keywords.trim())) {
				param.put("keywords", "%" + keywords.trim() + "%");
				builder.append(" and (b.account_no like #{keywords} or b.real_name like #{keywords}) ");
			}
			if (pageNo != null && pageSize != null) {
				builder.append(" limit ").append((pageNo - 1) * pageSize).append(", ").append(pageSize);
			}
			return builder.toString();
		}
	}
}