/* * 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.datascope.handler; import lombok.RequiredArgsConstructor; import org.springblade.core.cache.utils.CacheUtil; import org.springblade.core.datascope.constant.DataScopeConstant; import org.springblade.core.datascope.model.DataScopeModel; import org.springblade.core.tool.utils.CollectionUtil; import org.springblade.core.tool.utils.Func; import org.springblade.core.tool.utils.StringPool; import org.springblade.core.tool.utils.StringUtil; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import java.util.ArrayList; import java.util.Collections; import java.util.List; import static org.springblade.core.cache.constant.CacheConstant.SYS_CACHE; /** * BladeScopeModelHandler * * @author Chill */ @RequiredArgsConstructor public class BladeScopeModelHandler implements ScopeModelHandler { private static final String SCOPE_CACHE_CODE = "dataScope:code:"; private static final String SCOPE_CACHE_CLASS = "dataScope:class:"; private static final String DEPT_CACHE_ANCESTORS = "dept:ancestors:"; private static final DataScopeModel SEARCHED_DATA_SCOPE_MODEL = new DataScopeModel(Boolean.TRUE); private final JdbcTemplate jdbcTemplate; /** * 获取数据权限 * * @param mapperId 数据权限mapperId * @param roleId 用户角色集合 * @return DataScopeModel */ @Override public DataScopeModel getDataScopeByMapper(String mapperId, String roleId) { List args = new ArrayList<>(Collections.singletonList(mapperId)); List roleIds = Func.toLongList(roleId); args.addAll(roleIds); // 增加searched字段防止未配置的参数重复读库导致缓存击穿 // 后续若有新增配置则会清空缓存重新加载 DataScopeModel dataScope = CacheUtil.get(SYS_CACHE, SCOPE_CACHE_CLASS, mapperId + StringPool.COLON + roleId, DataScopeModel.class, Boolean.FALSE); if (dataScope == null || !dataScope.getSearched()) { List list = jdbcTemplate.query(DataScopeConstant.dataByMapper(roleIds.size()), args.toArray(), new BeanPropertyRowMapper<>(DataScopeModel.class)); if (CollectionUtil.isNotEmpty(list)) { dataScope = list.iterator().next(); dataScope.setSearched(Boolean.TRUE); } else { dataScope = SEARCHED_DATA_SCOPE_MODEL; } CacheUtil.put(SYS_CACHE, SCOPE_CACHE_CLASS, mapperId + StringPool.COLON + roleId, dataScope, Boolean.FALSE); } return StringUtil.isNotBlank(dataScope.getResourceCode()) ? dataScope : null; } /** * 获取数据权限 * * @param code 数据权限资源编号 * @return DataScopeModel */ @Override public DataScopeModel getDataScopeByCode(String code) { DataScopeModel dataScope = CacheUtil.get(SYS_CACHE, SCOPE_CACHE_CODE, code, DataScopeModel.class, Boolean.FALSE); // 增加searched字段防止未配置的参数重复读库导致缓存击穿 // 后续若有新增配置则会清空缓存重新加载 if (dataScope == null || !dataScope.getSearched()) { List list = jdbcTemplate.query(DataScopeConstant.DATA_BY_CODE, new Object[]{code}, new BeanPropertyRowMapper<>(DataScopeModel.class)); if (CollectionUtil.isNotEmpty(list)) { dataScope = list.iterator().next(); dataScope.setSearched(Boolean.TRUE); } else { dataScope = SEARCHED_DATA_SCOPE_MODEL; } CacheUtil.put(SYS_CACHE, SCOPE_CACHE_CODE, code, dataScope, Boolean.FALSE); } return StringUtil.isNotBlank(dataScope.getResourceCode()) ? dataScope : null; } /** * 获取部门子级 * * @param deptId 部门id * @return deptIds */ @Override public List getDeptAncestors(Long deptId) { List ancestors = CacheUtil.get(SYS_CACHE, DEPT_CACHE_ANCESTORS, deptId, List.class); if (CollectionUtil.isEmpty(ancestors)) { ancestors = jdbcTemplate.queryForList(DataScopeConstant.DATA_BY_DEPT, new Object[]{deptId}, Long.class); CacheUtil.put(SYS_CACHE, DEPT_CACHE_ANCESTORS, deptId, ancestors); } return ancestors; } }