package com.ltkj.web.controller.system;
|
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.IOException;
|
import java.io.InputStreamReader;
|
import java.nio.charset.StandardCharsets;
|
import java.nio.file.Files;
|
import java.nio.file.Paths;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import javax.servlet.http.HttpServletResponse;
|
|
import cn.hutool.core.util.IdUtil;
|
import cn.hutool.core.util.RandomUtil;
|
import com.ltkj.db.DataSourceConfig;
|
import com.ltkj.db.DataSourceContextHolder;
|
import com.ltkj.hosp.domain.DictHosp;
|
import com.ltkj.hosp.service.IDictHospService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.core.io.ClassPathResource;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.util.FileCopyUtils;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.DeleteMapping;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.PathVariable;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.PutMapping;
|
import org.springframework.web.bind.annotation.RequestBody;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
import com.ltkj.common.annotation.Log;
|
import com.ltkj.common.constant.UserConstants;
|
import com.ltkj.common.core.controller.BaseController;
|
import com.ltkj.common.core.domain.AjaxResult;
|
import com.ltkj.common.core.domain.entity.SysDept;
|
import com.ltkj.common.core.domain.entity.SysRole;
|
import com.ltkj.common.core.domain.entity.SysUser;
|
import com.ltkj.common.core.domain.model.LoginUser;
|
import com.ltkj.common.core.page.TableDataInfo;
|
import com.ltkj.common.enums.BusinessType;
|
import com.ltkj.common.utils.StringUtils;
|
import com.ltkj.common.utils.poi.ExcelUtil;
|
import com.ltkj.framework.web.service.SysPermissionService;
|
import com.ltkj.framework.web.service.TokenService;
|
import com.ltkj.system.domain.SysUserRole;
|
import com.ltkj.system.service.ISysDeptService;
|
import com.ltkj.system.service.ISysRoleService;
|
import com.ltkj.system.service.ISysUserService;
|
|
/**
|
* 角色信息
|
*
|
* @author ltkj
|
*/
|
@RestController
|
@RequestMapping("/system/role")
|
public class SysRoleController extends BaseController {
|
@Autowired
|
private ISysRoleService roleService;
|
|
@Autowired
|
private TokenService tokenService;
|
|
@Autowired
|
private SysPermissionService permissionService;
|
|
@Autowired
|
private ISysUserService userService;
|
|
@Autowired
|
private ISysDeptService deptService;
|
@Autowired
|
private JdbcTemplate jdbcTemplate;
|
@Autowired
|
private IDictHospService dictHospService;
|
|
@Value("${config.path}")
|
private String path;
|
|
// @PreAuthorize("@ss.hasPermi('system:role:list')")
|
@GetMapping("/list")
|
public TableDataInfo list(SysRole role) {
|
startPage();
|
List<SysRole> list = roleService.selectRoleList(role);
|
return getDataTable(list);
|
}
|
|
@Log(title = "角色管理", businessType = BusinessType.EXPORT)
|
// @PreAuthorize("@ss.hasPermi('system:role:export')")
|
@PostMapping("/export")
|
public void export(HttpServletResponse response, SysRole role) {
|
List<SysRole> list = roleService.selectRoleList(role);
|
ExcelUtil<SysRole> util = new ExcelUtil<SysRole>(SysRole.class);
|
util.exportExcel(response, list, "角色数据");
|
}
|
|
/**
|
* 根据角色编号获取详细信息
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:query')")
|
@GetMapping(value = "/{roleId}")
|
public AjaxResult getInfo(@PathVariable Long roleId) {
|
roleService.checkRoleDataScope(roleId);
|
return success(roleService.selectRoleById(roleId));
|
}
|
|
/**
|
* 新增角色
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:add')")
|
@Log(title = "角色管理", businessType = BusinessType.INSERT)
|
@PostMapping
|
public AjaxResult add(@Validated @RequestBody SysRole role) {
|
if (UserConstants.NOT_UNIQUE.equals(roleService.checkRoleNameUnique(role))) {
|
return error("新增角色'" + role.getRoleName() + "'失败，角色名称已存在");
|
} else if (UserConstants.NOT_UNIQUE.equals(roleService.checkRoleKeyUnique(role))) {
|
return error("新增角色'" + role.getRoleName() + "'失败，角色权限已存在");
|
}
|
role.setCreateBy(getUsername());
|
return toAjax(roleService.insertRole(role));
|
|
}
|
|
/**
|
* 修改保存角色
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:edit')")
|
@Log(title = "角色管理", businessType = BusinessType.UPDATE)
|
@PutMapping
|
public AjaxResult edit(@Validated @RequestBody SysRole role) {
|
roleService.checkRoleAllowed(role);
|
roleService.checkRoleDataScope(role.getRoleId());
|
if (UserConstants.NOT_UNIQUE.equals(roleService.checkRoleNameUnique(role))) {
|
return error("修改角色'" + role.getRoleName() + "'失败，角色名称已存在");
|
} else if (UserConstants.NOT_UNIQUE.equals(roleService.checkRoleKeyUnique(role))) {
|
return error("修改角色'" + role.getRoleName() + "'失败，角色权限已存在");
|
}
|
role.setUpdateBy(getUsername());
|
|
if (roleService.updateRole(role) > 0) {
|
// 更新缓存用户权限
|
LoginUser loginUser = getLoginUser();
|
if (StringUtils.isNotNull(loginUser.getUser()) && !loginUser.getUser().isAdmin()) {
|
loginUser.setPermissions(permissionService.getMenuPermission(loginUser.getUser()));
|
loginUser.setUser(userService.selectUserByUserName(loginUser.getUser().getUserName()));
|
tokenService.setLoginUser(loginUser);
|
}
|
return success();
|
}
|
return error("修改角色'" + role.getRoleName() + "'失败，请联系管理员");
|
}
|
|
/**
|
* 修改保存数据权限
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:edit')")
|
@Log(title = "角色管理", businessType = BusinessType.UPDATE)
|
@PutMapping("/dataScope")
|
public AjaxResult dataScope(@RequestBody SysRole role) {
|
roleService.checkRoleAllowed(role);
|
roleService.checkRoleDataScope(role.getRoleId());
|
return toAjax(roleService.authDataScope(role));
|
}
|
|
/**
|
* 状态修改
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:edit')")
|
@Log(title = "角色管理", businessType = BusinessType.UPDATE)
|
@PutMapping("/changeStatus")
|
public AjaxResult changeStatus(@RequestBody SysRole role) {
|
roleService.checkRoleAllowed(role);
|
roleService.checkRoleDataScope(role.getRoleId());
|
role.setUpdateBy(getUsername());
|
return toAjax(roleService.updateRoleStatus(role));
|
}
|
|
/**
|
* 删除角色
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:remove')")
|
@Log(title = "角色管理", businessType = BusinessType.DELETE)
|
@DeleteMapping("/{roleIds}")
|
public AjaxResult remove(@PathVariable Long[] roleIds) {
|
return toAjax(roleService.deleteRoleByIds(roleIds));
|
}
|
|
/**
|
* 获取角色选择框列表
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:query')")
|
@GetMapping("/optionselect")
|
public AjaxResult optionselect() {
|
return success(roleService.selectRoleAll());
|
}
|
|
/**
|
* 查询已分配用户角色列表
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:list')")
|
@GetMapping("/authUser/allocatedList")
|
public TableDataInfo allocatedList(SysUser user) {
|
startPage();
|
List<SysUser> list = userService.selectAllocatedList(user);
|
for (SysUser sysUser : list) {
|
SysDept dept = deptService.getById(sysUser.getDeptId());
|
sysUser.setDept(dept);
|
}
|
return getDataTable(list);
|
}
|
|
/**
|
* 查询未分配用户角色列表
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:list')")
|
@GetMapping("/authUser/unallocatedList")
|
public TableDataInfo unallocatedList(SysUser user) {
|
startPage();
|
List<SysUser> list = userService.selectUnallocatedList(user);
|
for (SysUser sysUser : list) {
|
SysDept dept = deptService.getById(sysUser.getDeptId());
|
sysUser.setDept(dept);
|
}
|
return getDataTable(list);
|
}
|
|
/**
|
* 取消授权用户
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:edit')")
|
@Log(title = "角色管理", businessType = BusinessType.GRANT)
|
@PutMapping("/authUser/cancel")
|
public AjaxResult cancelAuthUser(@RequestBody SysUserRole userRole) {
|
return toAjax(roleService.deleteAuthUser(userRole));
|
}
|
|
/**
|
* 批量取消授权用户
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:edit')")
|
@Log(title = "角色管理", businessType = BusinessType.GRANT)
|
@PutMapping("/authUser/cancelAll")
|
public AjaxResult cancelAuthUserAll(Long roleId, Long[] userIds) {
|
return toAjax(roleService.deleteAuthUsers(roleId, userIds));
|
}
|
|
/**
|
* 批量选择用户授权
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:edit')")
|
@Log(title = "角色管理", businessType = BusinessType.GRANT)
|
@PutMapping("/authUser/selectAll")
|
public AjaxResult selectAuthUserAll(Long roleId, Long[] userIds) {
|
roleService.checkRoleDataScope(roleId);
|
return toAjax(roleService.insertAuthUsers(roleId, userIds));
|
}
|
|
/**
|
* 获取对应角色部门树列表
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:role:query')")
|
@GetMapping(value = "/deptTree/{roleId}")
|
public AjaxResult deptTree(@PathVariable("roleId") Long roleId) {
|
AjaxResult ajax = AjaxResult.success();
|
ajax.put("checkedKeys", deptService.selectDeptListByRoleId(roleId));
|
ajax.put("depts", deptService.selectDeptTreeList(new SysDept()));
|
return ajax;
|
}
|
|
@Autowired
|
private DataSourceConfig dataSourceConfig;
|
|
/**
|
* 从库批量执行sql
|
* 读取本地sql文件
|
* @return
|
*/
|
@GetMapping("/execUpdateSql")
|
public AjaxResult execUpdateSql() {
|
DataSourceContextHolder.setDataSourceKey("default");
|
List<DictHosp> list = dictHospService.list();
|
List<Map<String, Object>> resultList = new ArrayList<>();
|
for (DictHosp dictHosp : list) {
|
String dbName = dictHosp.getDbname();
|
Map<String, Object> dbResult = new HashMap<>();
|
dbResult.put("database", dbName);
|
List<String> successList = new ArrayList<>();
|
List<String> errorList = new ArrayList<>();
|
try {
|
InputStreamReader reader = new InputStreamReader(Files.newInputStream(Paths.get(path + File.separator + "update.sql")), StandardCharsets.UTF_8);
|
String sqlContent = FileCopyUtils.copyToString(reader);
|
String[] sqlStatements = sqlContent.split("\\|-\\|");
|
for (String sql : sqlStatements) {
|
sql = sql.trim();
|
if (!sql.isEmpty()) {
|
// INSERT INTO `api_config` (`id`, `api_url`, `api_method`, `tab_name`, `is_response`, `primary_keys`, `remark`, `result_code_key`, `result_data_key`, `type`) VALUES (${id}, '${dbName}', '${randowmStr}', '${randowmStr}', 1, 'ResultData', '1.pas 检查申请信息作废', 'ResultCode', 'ResultData', 'pacs');
|
// sql = sql.replace("${dbName}",dbName).replace("${id}", IdUtil.getSnowflake().nextIdStr()).replace("${randowmStr}", RandomUtil.randomString(10));
|
try {
|
dataSourceConfig.addDataSource(dbName);
|
DataSourceContextHolder.setDataSourceKey(dbName);
|
jdbcTemplate.execute(sql);
|
successList.add(sql);
|
} catch (Exception e) {
|
errorList.add(sql + " -> ERROR: " + e.getMessage());
|
}
|
}
|
}
|
} catch (IOException e) {
|
return AjaxResult.error("读取SQL文件失败：" + e.getMessage());
|
}
|
dbResult.put("successSQL", successList);
|
dbResult.put("failedSQL", errorList);
|
resultList.add(dbResult);
|
}
|
DataSourceContextHolder.clear();
|
return AjaxResult.success(resultList);
|
}
|
|
}
|
