package org.sxkj.resource.builder;
|
|
import org.springblade.core.tool.utils.StringUtil;
|
import org.springframework.stereotype.Component;
|
import org.sxkj.system.cache.SysCache;
|
import org.sxkj.system.cache.UserCache;
|
import org.sxkj.system.entity.Dept;
|
import org.sxkj.system.entity.User;
|
|
import java.util.List;
|
|
/**
|
* @Description 权限查询构建器
|
* @Author AIX
|
* @Date 2025/9/20 11:28
|
* @Version 1.0
|
*/
|
@Component
|
public class DevicePermissionBuilder {
|
|
/**
|
* 构建设备查询的权限条件
|
*/
|
public String buildDevicePermissionCondition(Long userId, String tableAlias) {
|
if (userId == null) {
|
return "1 = 0"; // 无用户ID，无权限
|
}
|
|
User user = UserCache.getUser(userId);
|
if (user == null || user.getDeptId() == null) {
|
return "1 = 0"; // 用户不存在或无部门，无权限
|
}
|
|
Dept userDept = SysCache.getDept(Long.valueOf(user.getDeptId()));
|
if (userDept == null) {
|
return "1 = 0"; // 部门不存在，无权限
|
}
|
|
StringBuilder condition = new StringBuilder();
|
String alias = tableAlias != null ? tableAlias + "." : "";
|
|
// 规则1：本部门设备，同部门设备
|
List<Long> deptIds = SysCache.getDeptParentIds(userDept.getId());
|
|
// condition.append(alias).append("domain = 3");
|
// condition.append(" and ").append(alias).append("is_deleted = 0");
|
// condition.append(" and ").append(alias).append("dept_id in (");
|
// for (int i = 0; i < deptIds.size(); i++) {
|
// if (i == deptIds.size() - 1) {
|
// condition.append(deptIds.get(i));
|
// continue;
|
// }
|
// condition.append(deptIds.get(i)).append(",");
|
// }
|
// condition.append(")");
|
|
// 规则2：借调设备，同部门设备
|
condition.append(alias).append("device_sn in (")
|
.append("SELECT device_sn FROM manage_device_per_share ms ")
|
.append("WHERE ms.device_sn = ").append(alias).append("device_sn ")
|
.append("AND ms.loan_to_dept_id in (");
|
|
for (int i = 0; i < deptIds.size(); i++) {
|
if (i == deptIds.size() - 1) {
|
condition.append(deptIds.get(i));
|
continue;
|
}
|
condition.append(deptIds.get(i)).append(",");
|
}
|
condition.append(")) ").append(" and ").append(alias).append("hidden_flag = 0 ");
|
|
// 规则3：统一部署机构的行政区划可见性
|
// if (userDept.getDeploymentMode() == 0 && user.getAreaCode() != null) {
|
// condition.append(" OR (")
|
// .append(alias).append("area_code LIKE '").append(HeaderUtils.formatAreaCode(user.getAreaCode())).append("%'")
|
// // 统一部署
|
// .append(" and ").append(alias).append("deployment_mode = 0")
|
// .append(")");
|
// }
|
|
return condition.toString();
|
}
|
|
public String buildDevicePermissionCondition(Long userId, String tableAlias, String sqlStr) {
|
if (userId == null) {
|
return "1 = 0"; // 无用户ID，无权限
|
}
|
|
User user = UserCache.getUser(userId);
|
if (user == null || user.getDeptId() == null) {
|
return "1 = 0"; // 用户不存在或无部门，无权限
|
}
|
|
Dept userDept = SysCache.getDept(Long.valueOf(user.getDeptId()));
|
if (userDept == null) {
|
return "1 = 0"; // 部门不存在，无权限
|
}
|
|
StringBuilder condition = new StringBuilder();
|
String alias = tableAlias != null ? tableAlias + "." : "";
|
|
//部门祖父集合
|
List<Long> deptIds = SysCache.getDeptParentIds(userDept.getId());
|
|
// 借调设备，同部门设备
|
condition.append(alias).append("device_sn in (")
|
.append("SELECT device_sn FROM manage_device_per_share ms ")
|
.append("WHERE ms.device_sn = ").append(alias).append("device_sn ")
|
.append("AND ms.loan_to_dept_id in (");
|
|
for (int i = 0; i < deptIds.size(); i++) {
|
if (i == deptIds.size() - 1) {
|
condition.append(deptIds.get(i));
|
continue;
|
}
|
condition.append(deptIds.get(i)).append(",");
|
}
|
condition.append(")) ").append(" and ").append(alias).append("hidden_flag = 0 ");
|
|
condition.append(" " + sqlStr);
|
|
return condition.toString();
|
}
|
|
/**
|
* 构建数据查询的权限条件
|
*/
|
public String buildDataPermissionCondition(Long userId, String tableAlias) {
|
|
if (userId == null) {
|
return "1 = 0"; // 无用户ID，无权限
|
}
|
|
User user = UserCache.getUser(userId);
|
if (user == null || user.getDeptId() == null) {
|
return "1 = 0"; // 用户不存在或无部门，无权限
|
}
|
|
Dept userDept = SysCache.getDept(Long.valueOf(user.getDeptId()));
|
if (userDept == null) {
|
return "1 = 0"; // 部门不存在，无权限
|
}
|
|
StringBuilder condition = new StringBuilder();
|
String alias = StringUtil.isNotBlank(tableAlias)? tableAlias + "." : "";
|
|
// 根据部门部署模式查询，单独查询只查看本部门数据
|
// List<Long> deptIds = SysCache.getDeptChildIds(userDept.getId());
|
condition.append(alias).append("create_dept in (");
|
condition.append("SELECT id FROM blade_dept ")
|
.append("WHERE id = ").append(alias).append("create_dept ")
|
.append("AND deployment_mode = ").append(userDept.getDeploymentMode());
|
|
condition.append(")");
|
|
return condition.toString();
|
}
|
|
}
|
