package com.ruoyi.system.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.ruoyi.common.core.constant.CacheConstants; import com.ruoyi.common.core.constant.SecurityConstants; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.exception.ServiceException; import com.ruoyi.common.core.utils.StringUtils; import com.ruoyi.common.core.utils.page.BeanUtils; import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.common.core.utils.poi.ExcelUtil; import com.ruoyi.common.core.web.controller.BaseController; import com.ruoyi.common.core.web.domain.AjaxResult; import com.ruoyi.common.core.web.page.PageInfo; import com.ruoyi.common.log.annotation.Log; import com.ruoyi.common.log.enums.BusinessType; import com.ruoyi.common.redis.service.RedisService; import com.ruoyi.common.security.annotation.InnerAuth; import com.ruoyi.common.security.annotation.RequiresPermissions; import com.ruoyi.common.security.utils.SecurityUtils; import com.ruoyi.system.api.domain.SysDept; import com.ruoyi.system.api.domain.SysRole; import com.ruoyi.system.api.domain.SysUser; import com.ruoyi.system.api.feignClient.AuthClient; import com.ruoyi.system.api.model.LoginUser; import com.ruoyi.system.api.validate.InsertGroup; import com.ruoyi.system.api.validate.UpdateGroup; import com.ruoyi.system.domain.SysUserRole; import com.ruoyi.system.domain.dto.ResetPwdDTO; import com.ruoyi.system.domain.dto.SupplierDTO; import com.ruoyi.system.domain.dto.SupplierQuery; import com.ruoyi.system.domain.dto.SysUserDTO; import com.ruoyi.system.domain.dto.SysUserQuery; import com.ruoyi.system.domain.vo.SupplierVO; import com.ruoyi.system.service.ISysConfigService; import com.ruoyi.system.service.ISysDeptService; import com.ruoyi.system.service.ISysPermissionService; import com.ruoyi.system.service.ISysPostService; import com.ruoyi.system.service.ISysRoleService; import com.ruoyi.system.service.ISysUserRoleService; import com.ruoyi.system.service.ISysUserService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; import java.io.IOException; import java.util.Date; import java.util.List; import java.util.Objects; import java.util.Set; import java.util.stream.Collectors; import javax.servlet.http.HttpServletResponse; import org.apache.commons.lang3.ArrayUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; 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.RequestParam; import org.springframework.web.bind.annotation.RestController; import org.springframework.web.multipart.MultipartFile; /** * 用户信息 * * @author ruoyi */ @RestController @RequestMapping("/user") @Api(tags = "用户信息") public class SysUserController extends BaseController { @Autowired private ISysUserService userService; @Autowired private ISysRoleService roleService; @Autowired private ISysDeptService deptService; @Autowired private ISysPostService postService; @Autowired private ISysPermissionService permissionService; @Autowired private ISysConfigService configService; @Autowired private ISysUserRoleService userRoleService; @Autowired private ISysUserRoleService sysUserRoleService; @Autowired private AuthClient authClient; @Autowired private RedisService redisService; /** * 获取用户列表 */ @PostMapping("/list") @ApiOperation("账号管理列表") public AjaxResult list(@Validated @RequestBody SysUserQuery query) { PageInfo pageInfo = new PageInfo<>(query.getPageCurr(), query.getPageSize()); PageInfo page = userService.getList(pageInfo, query.getNickName(), query.getPhonenumber(), query.getStatus()); return AjaxResult.success(page); } /** * 新增用户 */ @Log(title = "账号管理", businessType = BusinessType.INSERT) @PostMapping("/add") @ApiOperation("添加账号") @Transactional(rollbackFor = Exception.class) public AjaxResult add(@Validated(InsertGroup.class) @RequestBody SysUserDTO dto) { SysUser user = BeanUtils.copyBean(dto, SysUser.class); user.setUserId(null); user.setUserType(dto.getIsAuctioneer() == 1 ? "00" : "01"); user.setUserName(user.getPhonenumber()); if(!org.springframework.util.StringUtils.hasLength(user.getNickName())){ user.setNickName(user.getPhonenumber()); } if (StringUtils.isNotEmpty(user.getPhonenumber()) && !userService.checkPhoneUnique(user)) { return error("手机号已开通账号"); } user.setCreateBy(SecurityUtils.getUsername()); user.setPassword(SecurityUtils.encryptPassword("123456")); user.setRoleType(1); int i = userService.insertUser(user); SysUserRole sysUserRole = new SysUserRole(); sysUserRole.setRoleId(dto.getRoleId()); sysUserRole.setUserId(user.getUserId()); int i1 = userRoleService.insertSysUserRole(sysUserRole); return AjaxResult.success(); } /** * 根据用户编号获取详细信息 */ @ApiOperation("账号详情") @GetMapping("/{userId}") public AjaxResult getInfo( @ApiParam(value = "用户ID", required = true) @PathVariable(value = "userId", required = true) Long userId) { userService.checkUserDataScope(userId); AjaxResult ajax = AjaxResult.success(); List roles = roleService.selectRoleAll(); ajax.put("roles", SysUser.isAdmin(userId) ? roles : roles.stream().filter(r -> !r.isAdmin()).collect(Collectors.toList())); ajax.put("posts", postService.selectPostAll()); if (StringUtils.isNotNull(userId)) { SysUser sysUser = userService.selectUserById(userId); ajax.put(AjaxResult.DATA_TAG, sysUser); ajax.put("postIds", postService.selectPostListByUserId(userId)); ajax.put("roleIds", sysUser.getRoles().stream().map(SysRole::getRoleId).collect(Collectors.toList())); } return AjaxResult.success(ajax); } /** * 修改用户 */ @Log(title = "账号管理", businessType = BusinessType.UPDATE) @PutMapping("/update") @ApiOperation("编辑账号") public AjaxResult edit(@Validated(UpdateGroup.class) @RequestBody SysUserDTO dto) { SysUser user = BeanUtils.copyBean(dto, SysUser.class); user.setUserName(user.getPhonenumber()); if(!org.springframework.util.StringUtils.hasLength(user.getNickName())){ user.setNickName(user.getPhonenumber()); } R admin = this.isAdmin(user.getUserId()); Integer data = admin.getData(); if(data == null || data != 1){ SysUserRole one = sysUserRoleService.getOne(new LambdaQueryWrapper().eq(SysUserRole::getUserId, user.getUserId())); one.setRoleId(dto.getRoleId()); sysUserRoleService.updateSysUserRole(one); } userService.checkUserAllowed(user); userService.checkUserDataScope(user.getUserId()); SysUser sysUser = userService.getOne(Wrappers.lambdaQuery(SysUser.class) .eq(SysUser::getPhonenumber, user.getPhonenumber()) .in(SysUser::getUserType, "00", "01", "04") .eq(SysUser::getDelFlag,0) .last("LIMIT 1")); if (StringUtils.isNotEmpty(user.getPhonenumber()) && (Objects.nonNull(sysUser) && !user.getUserId().equals(sysUser.getUserId()) )) { return error("手机号已开通账号"); } user.setUpdateBy(SecurityUtils.getUsername()); if (user.getPassword() != null && !"".equals(user.getPassword())) { user.setPassword(SecurityUtils.encryptPassword(user.getPassword())); user.setPassWordUpdate(new Date()); } if (user.getPhonenumber() != null) { user.setUserName(user.getPhonenumber()); } user.setUserType(dto.getIsAuctioneer() == 1 ? "00" : "01"); user.setPassword(null); user.setUpdateBy(SecurityUtils.getUsername()); user.setUpdateTime(new Date()); return toAjax(userService.updateUser(user)); } /** * 删除用户 */ @Log(title = "账号管理", businessType = BusinessType.DELETE) @DeleteMapping("/{userIds}") @ApiOperation("删除账号") public AjaxResult remove(@PathVariable Long[] userIds) { if (ArrayUtils.contains(userIds, SecurityUtils.getUserId())) { return error("当前用户不能删除"); } return toAjax(userService.deleteUserByIds(userIds)); } @PostMapping("/updStatus/{userId}") @ApiOperation("账号管理--冻结/解冻") public AjaxResult updStatus( @ApiParam(value = "账号ID", required = true) @PathVariable("userId") Long userId) { if (userId == null) { return AjaxResult.error("userId不能为空"); } SysUser sysUser = userService.selectUserById(userId); if (sysUser.getStatus().equals("0")) { sysUser.setStatus("1"); Object tokenObj = redisService.getCacheObject(getUserTokenKey(userId)); if (Objects.nonNull(tokenObj)) { authClient.logout(tokenObj.toString(), SecurityConstants.INNER); } } else { sysUser.setStatus("0"); } return toAjax(userService.updateUser(sysUser)); } private String getUserTokenKey(Long userId) { return CacheConstants.USER_TOKEN_KEY + userId; } @Autowired private ISysUserRoleService iSysUserRoleService; @PostMapping("/getUserList") public R> getUserList(@RequestBody List userIds) { List list = userService.list(new LambdaQueryWrapper().in(SysUser::getUserId, userIds)); return R.ok(list); } @PostMapping("/isAdmin") public R isAdmin(@RequestBody Long userId){ SysUserRole one = sysUserRoleService.getOne(new LambdaQueryWrapper().eq(SysUserRole::getUserId, userId)); Long id =one.getRoleId(); return R.ok(id.intValue()); } @PostMapping("/getSysUser") public R getSysUser(@RequestBody Long userId) { try { SysUser sysUser = userService.selectUserById(userId); return R.ok(sysUser); } catch (Exception e) { e.printStackTrace(); return R.ok(); } } @PostMapping("/updateSysUser") public R updateSysUser(@RequestBody SysUser sysUser) { try { sysUser.setUpdateBy(SecurityUtils.getUsername()); sysUser.setUpdateTime(new Date()); userService.updateUser(sysUser); return R.ok(true); } catch (Exception e) { e.printStackTrace(); return R.ok(); } } @Log(title = "用户管理", businessType = BusinessType.EXPORT) @RequiresPermissions("system:user:export") @PostMapping("/export") public void export(HttpServletResponse response, SysUser user) { List list = userService.selectUserList(user); ExcelUtil util = new ExcelUtil(SysUser.class); util.exportExcel(response, list, "用户数据"); } @PostMapping("/importTemplate") public void importTemplate(HttpServletResponse response) throws IOException { ExcelUtil util = new ExcelUtil(SysUser.class); util.importTemplateExcel(response, "用户数据"); } @Log(title = "用户管理", businessType = BusinessType.IMPORT) @RequiresPermissions("system:user:import") @PostMapping("/importData") public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception { ExcelUtil util = new ExcelUtil(SysUser.class); List userList = util.importExcel(file.getInputStream()); String operName = SecurityUtils.getUsername(); String message = userService.importUser(userList, updateSupport, operName); return success(message); } /** * 获取当前用户信息 */ @InnerAuth @GetMapping("/info/{username}") public R info(@PathVariable("username") String username) { SysUser sysUser = userService.selectUserByUserName(username); if (StringUtils.isNull(sysUser)) { return R.fail("用户名或密码错误"); } LoginUser sysUserVo = new LoginUser(); sysUserVo.setSysUser(sysUser); if (sysUser.getUserType().equals("00")) { // 角色集合 Set roles = permissionService.getRolePermission(sysUser); // 权限集合 Set permissions = permissionService.getMenuPermission(sysUser); sysUserVo.setRoles(roles); sysUserVo.setPermissions(permissions); } return R.ok(sysUserVo); } /** * 注册用户信息 */ @InnerAuth @PostMapping("/register") public R register(@RequestBody SysUser sysUser) { String username = sysUser.getUserName(); if (!("true".equals(configService.selectConfigByKey("sys.account.registerUser")))) { return R.fail("当前系统没有开启注册功能!"); } if (!userService.checkUserNameUnique(sysUser)) { return R.fail("保存用户'" + username + "'失败,注册账号已存在"); } return R.ok(userService.registerUser(sysUser)); } @PostMapping("/registerUser") public R registerUser(@RequestBody SysUser sysUser){ sysUser = userService.registerUser(sysUser); return R.ok(sysUser); } /** * 获取用户信息 * * @return 用户信息 */ @GetMapping("/getInfo") public AjaxResult getInfo() { SysUser user = userService.selectUserById(SecurityUtils.getUserId()); // 角色集合 Set roles = permissionService.getRolePermission(user); // 权限集合 Set permissions = permissionService.getMenuPermission(user); AjaxResult ajax = AjaxResult.success(); ajax.put("user", user); ajax.put("roles", roles); ajax.put("permissions", permissions); return ajax; } /** * 重置密码 */ @ApiOperation("重置密码") @Log(title = "用户管理", businessType = BusinessType.UPDATE) @PostMapping("/resetPwd") public AjaxResult resetPwd(@RequestBody ResetPwdDTO dto) { SysUser user = userService.lambdaQuery().eq(SysUser::getUserId, dto.getUserId()) .in(SysUser::getUserType, "00", "01").one(); if (StringUtils.isNull(user)) { throw new ServiceException("账号不存在"); } userService.checkUserAllowed(user); userService.checkUserDataScope(user.getUserId()); user.setPassword(SecurityUtils.encryptPassword(dto.getPassword())); user.setUpdateBy(SecurityUtils.getUsername()); return toAjax(userService.resetPwd(user)); } /** * 获取当前用户信息 */ @InnerAuth @Log(title = "用户管理", businessType = BusinessType.UPDATE) @PutMapping("/change-password") public R info(@RequestParam("username") String username, @RequestParam("password") String password) { SysUser user = userService.selectUserByUserName(username); user.setPassword(password); user.setUpdateBy(SecurityUtils.getUsername()); int i = userService.updateUser(user); if (i == 1) { return R.ok(); } else { return R.fail(); } } /** * 状态修改 */ @RequiresPermissions("system:user:edit") @Log(title = "用户管理", businessType = BusinessType.UPDATE) @PutMapping("/changeStatus") public AjaxResult changeStatus(@RequestBody SysUser user) { userService.checkUserAllowed(user); userService.checkUserDataScope(user.getUserId()); user.setUpdateBy(SecurityUtils.getUsername()); return toAjax(userService.updateUserStatus(user)); } /** * 根据用户编号获取授权角色 */ @RequiresPermissions("system:user:query") @GetMapping("/authRole/{userId}") public AjaxResult authRole(@PathVariable("userId") Long userId) { AjaxResult ajax = AjaxResult.success(); SysUser user = userService.selectUserById(userId); List roles = roleService.selectRolesByUserId(userId); ajax.put("user", user); ajax.put("roles", SysUser.isAdmin(userId) ? roles : roles.stream().filter(r -> !r.isAdmin()).collect(Collectors.toList())); return ajax; } /** * 用户授权角色 */ @RequiresPermissions("system:user:edit") @Log(title = "用户管理", businessType = BusinessType.GRANT) @PutMapping("/authRole") public AjaxResult insertAuthRole(Long userId, Long[] roleIds) { userService.checkUserDataScope(userId); userService.insertUserAuth(userId, roleIds); return success(); } /** * 获取部门树列表 */ @RequiresPermissions("system:user:list") @GetMapping("/deptTree") public AjaxResult deptTree(SysDept dept) { return success(deptService.selectDeptTreeList(dept)); } @PostMapping("/updateUser") public R updateUser(@RequestBody SysUser sysUser){ return R.ok(userService.updateById(sysUser)); } /** * 通过用户id查询角色对象 * @param userId * @return */ @GetMapping("/queryRoleByUserId/{userId}") public R queryRoleByUserId(@PathVariable("userId") Long userId){ SysUserRole one = sysUserRoleService.getOne(Wrappers.lambdaQuery(SysUserRole.class) .eq(SysUserRole::getUserId, userId) .last("LIMIT 1")); System.out.println("通过用户id查询角色对象"+one); if(Objects.nonNull(one)){ SysRole byId = roleService.getOne(Wrappers.lambdaQuery(SysRole.class) .eq(SysRole::getRoleId,one.getRoleId()) .last("LIMIT 1")); return R.ok(byId); } return R.ok(); } @GetMapping("/queryRoleByRoleId/{roleId}") public R queryRoleByRoleId(@PathVariable("roleId") Long roleId){ return R.ok( roleService.getOne(Wrappers.lambdaQuery(SysRole.class) .eq(SysRole::getRoleId, roleId) .last("LIMIT 1"))); } /** * 通过手机号集合查询用户 * @param phoneList * @return */ @PostMapping("/queryUserByPhoneList") public R> queryUserByPhoneList(@RequestBody List phoneList){ List list = userService.list(Wrappers.lambdaQuery(SysUser.class) .in(SysUser::getPhonenumber, phoneList) .eq(SysUser::getUserType,"01") .eq(SysUser::getDelFlag,0)); return R.ok(list); } @PostMapping("/queryUserByPhoneList1") public R> queryUserByPhoneList1(@RequestBody List phoneList){ List list = userService.list(Wrappers.lambdaQuery(SysUser.class) .in(SysUser::getPhonenumber, phoneList)); return R.ok(list); } /** * 通过手机号查询用户 * @param phone * @return */ @PostMapping("/queryUserByPhone") public R queryUserByPhone(@RequestBody String phone){ SysUser user = userService.getOne(Wrappers.lambdaQuery(SysUser.class) .eq(SysUser::getPhonenumber, phone) .eq(SysUser::getUserType,"01") .eq(SysUser::getStatus,0) .eq(SysUser::getDelFlag,0) .last("LIMIT 1")); return R.ok(user); } @PostMapping("/queryUserByPhone1") public R queryUserByPhone1(@RequestBody String phone) { SysUser user = userService.getOne(Wrappers.lambdaQuery(SysUser.class) .eq(SysUser::getPhonenumber, phone) .eq(SysUser::getDelFlag, 0) .eq(SysUser::getUserType,"01") .last("LIMIT 1")); return R.ok(user); } // @PostMapping("/queryUserByPhone1") // public R queryUserByPhone1(@RequestBody String phone){ // SysUser user = userService.getOne(Wrappers.lambdaQuery(SysUser.class) // .eq(SysUser::getPhonenumber, phone) // .eq(SysUser::get, phone) // .last("LIMIT 1")); // return R.ok(user); // } /** * 通过账号查询用户 * @param userName * @return */ @PostMapping("/queryUserByUserName") public R queryUserByUserName(@RequestBody String userName){ SysUser user = userService.getOne(Wrappers.lambdaQuery(SysUser.class) .eq(SysUser::getUserName, userName) .eq(SysUser::getDelFlag, "0") .last("LIMIT 1")); return R.ok(user); } /** * 获取供应商分页列表 * * @param query 供应商列表查询数据传输对象 * @return PageDTO */ @ApiOperation(value = "获取供应商分页列表", notes = "获取供应商分页列表") @PostMapping("/supplier-page") public R> getSupplierPage(@Validated @RequestBody SupplierQuery query) { return R.ok(userService.getSupplierPage(query)); } /** * 添加/编辑供应商 * * @param dto 供应商数据传输对象 */ @Log(title = "供应商管理", businessType = BusinessType.UPDATE) @ApiOperation(value = "添加/编辑供应商", notes = "添加/编辑供应商") @PostMapping("/save-supplier") public R saveSupplier(@Validated @RequestBody SupplierDTO dto) { userService.saveSupplier(dto); return R.ok(); } /** * 删除供应商 * * @param id 供应商id */ @ApiOperation(value = "删除供应商", notes = "删除供应商") @DeleteMapping("/delete-supplier/{id}") public R deleteSupplier(@PathVariable("id") Long id) { userService.deleteSupplier(id); return R.ok(); } @InnerAuth @PostMapping("/list-by-name") R> getUserListByName(@RequestBody SysUser sysUser) { List list = userService.lambdaQuery() .like(StringUtils.isNotBlank(sysUser.getNickName()), SysUser::getNickName, sysUser.getNickName()) .like(StringUtils.isNotBlank(sysUser.getPhonenumber()), SysUser::getPhonenumber, sysUser.getPhonenumber()) .eq(SysUser::getUserType, "00") .eq(SysUser::getDelFlag, 0).list(); return R.ok(list); } }