/* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.core.secure.constant; import org.springblade.core.tool.utils.StringUtil; /** * 权限校验常量 * * @author Chill */ public interface PermissionConstant { /** * 获取角色所有的权限编号 * * @param size 数量 * @return string */ static String permissionAllStatement(int size) { return "select scope_path as path from blade_scope_api where id in (select scope_id from blade_role_scope where scope_category = 2 and role_id in (" + buildHolder(size) + "))"; } /** * 获取角色指定的权限编号 * * @param size 数量 * @return string */ static String permissionStatement(int size) { return "select resource_code as code from blade_scope_api where resource_code = ? and id in (select scope_id from blade_role_scope where scope_category = 2 and role_id in (" + buildHolder(size) + "))"; } /** * 获取Sql占位符 * * @param size 数量 * @return String */ static String buildHolder(int size) { StringBuilder builder = StringUtil.builder(); for (int i = 0; i < size; i++) { builder.append("?,"); } return StringUtil.removeSuffix(builder.toString(), ","); } }