UserController.java 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425
  1. package com.xjrsoft.module.organization.controller;
  2. import cn.dev33.satoken.annotation.SaCheckPermission;
  3. import cn.dev33.satoken.secure.BCrypt;
  4. import cn.dev33.satoken.secure.SaSecureUtil;
  5. import cn.dev33.satoken.session.SaSession;
  6. import cn.dev33.satoken.stp.StpUtil;
  7. import cn.hutool.core.bean.BeanUtil;
  8. import cn.hutool.core.lang.TypeReference;
  9. import cn.hutool.core.util.ObjectUtil;
  10. import cn.hutool.core.util.StrUtil;
  11. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  12. import com.baomidou.mybatisplus.core.metadata.IPage;
  13. import com.baomidou.mybatisplus.core.toolkit.StringPool;
  14. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  15. import com.github.yulichang.toolkit.MPJWrappers;
  16. import com.github.yulichang.wrapper.MPJLambdaWrapper;
  17. import com.xjrsoft.common.constant.GlobalConstant;
  18. import com.xjrsoft.common.enums.EnabledMark;
  19. import com.xjrsoft.common.enums.RoleEnum;
  20. import com.xjrsoft.common.exception.MyException;
  21. import com.xjrsoft.common.model.result.R;
  22. import com.xjrsoft.common.page.ConventPage;
  23. import com.xjrsoft.common.page.PageOutput;
  24. import com.xjrsoft.common.sms.SmsCtcc;
  25. import com.xjrsoft.common.utils.RedisUtil;
  26. import com.xjrsoft.common.utils.VoToColumnUtil;
  27. import com.xjrsoft.config.CommonPropertiesConfig;
  28. import com.xjrsoft.module.organization.dto.*;
  29. import com.xjrsoft.module.organization.entity.*;
  30. import com.xjrsoft.module.organization.service.*;
  31. import com.xjrsoft.module.organization.vo.*;
  32. import com.xjrsoft.module.oss.factory.OssFactory;
  33. import com.xjrsoft.module.student.entity.BaseClass;
  34. import com.xjrsoft.module.student.entity.BaseStudent;
  35. import com.xjrsoft.module.student.entity.BaseStudentSchoolRoll;
  36. import com.xjrsoft.module.student.entity.BaseStudentUser;
  37. import com.xjrsoft.module.student.service.IBaseClassService;
  38. import com.xjrsoft.module.student.vo.BaseStudentClassVo;
  39. import io.swagger.annotations.Api;
  40. import io.swagger.annotations.ApiOperation;
  41. import lombok.AllArgsConstructor;
  42. import org.springframework.web.bind.annotation.*;
  43. import org.springframework.web.multipart.MultipartFile;
  44. import javax.validation.Valid;
  45. import java.util.ArrayList;
  46. import java.util.List;
  47. import java.util.Objects;
  48. import java.util.concurrent.CompletableFuture;
  49. import java.util.stream.Collectors;
  50. /**
  51. * <p>
  52. * 用户 前端控制器
  53. * </p>
  54. *
  55. * @author tzx
  56. * @since 2022-03-02
  57. */
  58. @RestController
  59. @RequestMapping(GlobalConstant.ORGANIZATION_MODULE_PREFIX + "/user")
  60. @Api(value = GlobalConstant.ORGANIZATION_MODULE_PREFIX + "/user", tags = "用户")
  61. @AllArgsConstructor
  62. public class UserController {
  63. private final IUserService userService;
  64. private final IDepartmentService departmentService;
  65. private final IPostService postService;
  66. private final IRoleService roleService;
  67. private final IUserRoleRelationService userRoleRelationService;
  68. private final IUserDeptRelationService userDeptRelationService;
  69. private final IUserPostRelationService userPostRelationService;
  70. private final CommonPropertiesConfig propertiesConfig;
  71. private final RedisUtil redisUtil;
  72. private final SmsCtcc smsCtcc;
  73. private final IUserStudentService userStudentService;
  74. private final IBaseClassService baseClassService;
  75. @GetMapping(value = "/list")
  76. @ApiOperation(value = "用户列表(不分页)")
  77. public R list(String keyword) {
  78. List<User> list = userService.list(Wrappers.lambdaQuery(User.class)
  79. .like(StrUtil.isNotBlank(keyword), User::getUserName, keyword)
  80. .like(StrUtil.isNotBlank(keyword), User::getCode, keyword)
  81. .like(StrUtil.isNotBlank(keyword), User::getName, keyword)
  82. .like(StrUtil.isNotBlank(keyword), User::getMobile, keyword)
  83. .select(User.class, x -> VoToColumnUtil.fieldsToColumns(UserListVo.class).contains(x.getProperty())));
  84. List<UserListVo> userListVos = BeanUtil.copyToList(list, UserListVo.class);
  85. return R.ok(userListVos);
  86. }
  87. @GetMapping(value = "/page")
  88. @ApiOperation(value = "用户列表(分页)")
  89. public R page(UserPageDto dto) {
  90. List<Long> deptIds = new ArrayList<>();
  91. if (ObjectUtil.isNotNull(dto.getDepartmentId())){
  92. List<Department> list = redisUtil.get(GlobalConstant.DEP_CACHE_KEY,new TypeReference<List<Department>>() {
  93. });
  94. //当前部门的层级
  95. String hierarchy = list.stream().filter(x -> x.getId().equals(dto.getDepartmentId())).findFirst().orElse(new Department()).getHierarchy();
  96. if (StrUtil.isNotBlank(hierarchy)){
  97. //层级里面包含当前部门层级的就是它的子集,如1-1,下面包含了1-1、1-1-2这种
  98. deptIds = list.stream().filter(x -> StrUtil.isNotBlank(x.getHierarchy())&&x.getHierarchy().contains(hierarchy)).map(Department::getId).collect(Collectors.toList());
  99. }else {
  100. //如果不存在层级就查询自己的数据
  101. deptIds.add(dto.getDepartmentId());
  102. }
  103. }
  104. //因为多表关联 会有多个表都使用了id字段, 所以必须专门指定主表的Id
  105. if (ObjectUtil.isNotNull(dto.getDepartmentId())){//不为空联合查询
  106. IPage<UserPageVo> page = userService.selectJoinListPage(ConventPage.getPage(dto), UserPageVo.class,
  107. MPJWrappers.<User>lambdaJoin()
  108. .distinct()
  109. .like(StrUtil.isNotBlank(dto.getKeyword()), User::getName, dto.getKeyword())
  110. .or(StrUtil.isNotBlank(dto.getKeyword()), x -> x.like(StrUtil.isNotBlank(dto.getKeyword()), User::getCode, dto.getKeyword()))
  111. .in(ObjectUtil.isNotNull(dto.getDepartmentId()), UserDeptRelation::getDeptId, deptIds)
  112. .like(StrUtil.isNotBlank(dto.getUserName()), User::getUserName, dto.getUserName())
  113. .like(StrUtil.isNotBlank(dto.getCode()), User::getCode, dto.getCode())
  114. .like(StrUtil.isNotBlank(dto.getName()), User::getName, dto.getName())
  115. .like(StrUtil.isNotBlank(dto.getMobile()), User::getMobile, dto.getMobile())
  116. .orderByDesc(User::getCreateDate)
  117. .select(User::getId)
  118. .select(User.class, x -> VoToColumnUtil.fieldsToColumns(UserPageVo.class).contains(x.getProperty()))
  119. .leftJoin(UserDeptRelation.class, UserDeptRelation::getUserId, User::getId));
  120. PageOutput<UserPageVo> pageOutput = ConventPage.getPageOutput(page);
  121. return R.ok(pageOutput);
  122. }else {
  123. LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
  124. queryWrapper.like(StrUtil.isNotBlank(dto.getKeyword()), User::getName, dto.getKeyword())
  125. .or(StrUtil.isNotBlank(dto.getKeyword()), x -> x.like(StrUtil.isNotBlank(dto.getKeyword()), User::getCode, dto.getKeyword()))
  126. .like(StrUtil.isNotBlank(dto.getUserName()), User::getUserName, dto.getUserName())
  127. .like(StrUtil.isNotBlank(dto.getCode()), User::getCode, dto.getCode())
  128. .like(StrUtil.isNotBlank(dto.getName()), User::getName, dto.getName())
  129. .like(StrUtil.isNotBlank(dto.getMobile()), User::getMobile, dto.getMobile())
  130. .orderByDesc(User::getCreateDate)
  131. .select(User.class, x -> VoToColumnUtil.fieldsToColumns(UserPageVo.class).contains(x.getProperty()));
  132. IPage<User> page = userService.page(ConventPage.getPage(dto),queryWrapper);
  133. PageOutput<UserPageVo> pageOutput = ConventPage.getPageOutput(page, UserPageVo.class);
  134. return R.ok(pageOutput);
  135. }
  136. }
  137. @GetMapping(value = "/info")
  138. @ApiOperation(value = "根据id查询用户信息")
  139. public R info(@RequestParam Long id) {
  140. User user = userService.getById(id);
  141. if (user == null) {
  142. R.error("找不到此用户!");
  143. }
  144. return R.ok(BeanUtil.toBean(user, UserVo.class));
  145. }
  146. @PostMapping
  147. @ApiOperation(value = "新增用户")
  148. public R add(@Valid @RequestBody AddUserDto dto) {
  149. return R.ok(userService.add(dto));
  150. }
  151. @PutMapping
  152. @ApiOperation(value = "修改用户 不能修改用户名")
  153. public R update(@Valid @RequestBody UpdateUserDto dto) {
  154. return R.ok(userService.update(dto));
  155. }
  156. @GetMapping(value = "/current/info")
  157. @ApiOperation(value = "当前登录用户信息")
  158. public R info() {
  159. SaSession tokenSession = StpUtil.getTokenSession();
  160. User user = tokenSession.get(GlobalConstant.LOGIN_USER_INFO_KEY, new User());
  161. List<Long> roleIds = userRoleRelationService.list(Wrappers.lambdaQuery(UserRoleRelation.class)
  162. .eq(UserRoleRelation::getUserId, user.getId().toString()))
  163. .stream().map(UserRoleRelation::getRoleId).collect(Collectors.toList());
  164. List<Long> deptIds = userDeptRelationService.list(Wrappers.lambdaQuery(UserDeptRelation.class)
  165. .eq(UserDeptRelation::getUserId, user.getId().toString()))
  166. .stream().map(UserDeptRelation::getDeptId).collect(Collectors.toList());
  167. List<Long> postIds = userPostRelationService.list(Wrappers.lambdaQuery(UserPostRelation.class)
  168. .eq(UserPostRelation::getUserId, user.getId().toString()))
  169. .stream().map(UserPostRelation::getPostId).collect(Collectors.toList());
  170. UserInfoVo vo = BeanUtil.toBean(user, UserInfoVo.class);
  171. if (roleIds.size() > 0) {
  172. List<Role> list = roleService.list(Wrappers.lambdaQuery(Role.class).in(Role::getId, roleIds));
  173. List<UserRoleVo> userRoleVoList = BeanUtil.copyToList(list, UserRoleVo.class);
  174. vo.setRoles(userRoleVoList);
  175. }
  176. if (deptIds.size() > 0) {
  177. List<Department> list = departmentService.list(Wrappers.lambdaQuery(Department.class).in(Department::getId, deptIds));
  178. List<UserDeptVo> userDeptVoList = BeanUtil.copyToList(list, UserDeptVo.class);
  179. vo.setDepartments(userDeptVoList);
  180. }
  181. if (postIds.size() > 0) {
  182. List<Post> list = postService.list(Wrappers.lambdaQuery(Post.class).in(Post::getId, postIds));
  183. List<UserPostVo> userPostVoList = BeanUtil.copyToList(list, UserPostVo.class);
  184. vo.setPosts(userPostVoList);
  185. }
  186. // 家长
  187. List<UserStudentVo> list = baseClassService.getStudents(user.getId());
  188. if (list != null) {
  189. vo.setStudents(list);
  190. }
  191. // 学生
  192. UserStudentVo userStudentVo = baseClassService.getClassInfo(user.getId());
  193. if (userStudentVo != null) {
  194. vo.setClassId(userStudentVo.getClassId());
  195. vo.setClassName(userStudentVo.getClassName());
  196. }
  197. return R.ok(vo);
  198. }
  199. @PutMapping("/update/info")
  200. @ApiOperation(value = "登陆人修改自己得用户信息")
  201. public R updateInfo(@RequestBody @Valid UpdateInfoDto dto) {
  202. User updateUserInfo = BeanUtil.toBean(dto, User.class);
  203. updateUserInfo.setId(StpUtil.getLoginIdAsLong());
  204. CompletableFuture.runAsync(() -> {
  205. List<User> list = userService.list();
  206. redisUtil.set(GlobalConstant.USER_CACHE_KEY, list);
  207. });
  208. return R.ok(userService.updateById(updateUserInfo));
  209. }
  210. @PutMapping("/update/password")
  211. @ApiOperation(value = "当前登录用户修改本人密码")
  212. public R updatePassword(@RequestBody @Valid UpdatePasswordDto dto) {
  213. User user = userService.getById(StpUtil.getLoginIdAsLong());
  214. // if (!StrUtil.equals(SaSecureUtil.md5BySalt(dto.getOldPassword(), GlobalConstant.SECRET_KEY), user.getPassword())) {
  215. // return R.error("当前密码填写错误!");
  216. // }
  217. if (!BCrypt.checkpw(dto.getOldPassword(), user.getPassword())) {
  218. return R.error("当前密码填写错误!");
  219. }
  220. if (!StrUtil.equals(dto.getNewPassword(), dto.getConfirmPassword())) {
  221. return R.error("2次密码输入不一致!");
  222. }
  223. User updateUser = new User();
  224. updateUser.setId(StpUtil.getLoginIdAsLong());
  225. // updateUser.setPassword(SaSecureUtil.md5BySalt(dto.getNewPassword(), GlobalConstant.SECRET_KEY));
  226. updateUser.setPassword(BCrypt.hashpw(dto.getNewPassword(), BCrypt.gensalt()));
  227. return R.ok(userService.updateById(updateUser));
  228. }
  229. @PostMapping("/update/avatar")
  230. @ApiOperation(value = "当前登录用户修改头像")
  231. public R uploadAvatar(@RequestParam("file") MultipartFile file) throws Exception {
  232. if (file.isEmpty()) {
  233. throw new MyException("上传文件不能为空");
  234. }
  235. //上传文件
  236. String suffix = Objects.requireNonNull(file.getOriginalFilename()).substring(file.getOriginalFilename().lastIndexOf(StringPool.DOT));
  237. String url = Objects.requireNonNull(OssFactory.build()).uploadSuffix(file.getBytes(), suffix);
  238. User updateUser = new User();
  239. updateUser.setId(StpUtil.getLoginIdAsLong());
  240. updateUser.setAvatar(url);
  241. userService.updateById(updateUser);
  242. SaSession tokenSession = StpUtil.getTokenSession();
  243. User user = tokenSession.get(GlobalConstant.LOGIN_USER_INFO_KEY, new User());
  244. user.setAvatar(url);
  245. tokenSession.set(GlobalConstant.LOGIN_USER_INFO_KEY, user);
  246. return R.ok(url);
  247. }
  248. @DeleteMapping
  249. @ApiOperation(value = "删除用户(可批量)")
  250. public R delete(@RequestBody List<Long> ids) {
  251. if (ids.contains(GlobalConstant.SUPER_ADMIN_USER_ID)) {
  252. R.error("管理员账户不能删除!");
  253. }
  254. if (ids.contains(StpUtil.getLoginIdAsLong())) {
  255. R.error("当前登录账户不能删除!");
  256. }
  257. //删除时需要同时删除用户部门关联表和用户角色关联表和用户岗位关系表数据。
  258. return R.ok(userService.deleteBatch(ids));
  259. }
  260. @GetMapping("/info/multi")
  261. @ApiOperation(value = "批量获取用户信息")
  262. public R usersInfo(@RequestParam String ids) {
  263. return R.ok(userService.getUsersInfo(ids));
  264. }
  265. @GetMapping("/enabled")
  266. @ApiOperation(value = "启用/禁用用户")
  267. public R enabled(@RequestParam Long id) {
  268. User user = userService.getOne(Wrappers.<User>query().lambda().select(User::getEnabledMark).eq(User::getId, id), false);
  269. if (user != null) {
  270. User updateUser = new User();
  271. updateUser.setId(id);
  272. updateUser.setEnabledMark(user.getEnabledMark() == EnabledMark.ENABLED.getCode() ? EnabledMark.DISABLED.getCode() : EnabledMark.ENABLED.getCode());
  273. return R.ok(userService.updateById(updateUser));
  274. }
  275. CompletableFuture.runAsync(() -> {
  276. List<User> list = userService.list();
  277. redisUtil.set(GlobalConstant.USER_CACHE_KEY, list);
  278. });
  279. return R.error("该用户不存在!");
  280. }
  281. @PutMapping("/reset-password")
  282. @ApiOperation(value = "重置密码")
  283. public R resetPassword(@RequestBody ResetPasswordDto dto) {
  284. User user = new User();
  285. user.setId(dto.getId());
  286. // user.setPassword(DigestUtil.md5Hex(propertiesConfig.getDefaultPassword()));
  287. // user.setPassword(SaSecureUtil.md5BySalt(propertiesConfig.getDefaultPassword(), GlobalConstant.SECRET_KEY));
  288. user.setPassword(BCrypt.hashpw(propertiesConfig.getDefaultPassword(), BCrypt.gensalt()));
  289. CompletableFuture.runAsync(() -> {
  290. List<User> list = userService.list();
  291. redisUtil.set(GlobalConstant.USER_CACHE_KEY, list);
  292. });
  293. return R.ok(userService.updateById(user));
  294. }
  295. @PostMapping("/bind-openid")
  296. @ApiOperation(value = "绑定微信")
  297. public R bindOpenid(@RequestBody BindOpenidDto dto) {
  298. User user = userService.getOne(Wrappers.<User>query().lambda().select(User::getId, User::getOpenId).eq(User::getId, dto.getId()), false);
  299. if (user != null) {
  300. if (StrUtil.isNotBlank(user.getOpenId())) {
  301. return R.error("该用户已经绑定微信!");
  302. }
  303. User updateUser = new User();
  304. updateUser.setId(dto.getId());
  305. updateUser.setOpenId(dto.getOpenid());
  306. return R.ok(userService.updateById(updateUser));
  307. }
  308. return R.error("该用户不存在!");
  309. }
  310. @GetMapping("/unbind-openid")
  311. @ApiOperation(value = "取消绑定微信")
  312. public R unbindOpenid(@RequestParam Long id) {
  313. User updateUser = new User();
  314. updateUser.setId(id);
  315. updateUser.setOpenId("");
  316. return R.ok(userService.updateById(updateUser));
  317. }
  318. @PostMapping("/register")
  319. @ApiOperation(value = "家长注册")
  320. public R register(@Valid @RequestBody RegisterDto dto) {
  321. // 验证验证码
  322. if (!smsCtcc.captchaVerify(dto.getMobile(), dto.getSmsCode())) {
  323. return R.error("验证码不正确!");
  324. }
  325. // 赋值家长角色
  326. dto.setPostId(RoleEnum.PARENT.getCode());
  327. return R.ok(userService.add(dto));
  328. }
  329. @PostMapping("/bind-student")
  330. @ApiOperation(value = "绑定学生")
  331. public R bindStudent(@Valid @RequestBody UserStudentBindDto dto) {
  332. User user = userService.getOne(Wrappers.<User>query().lambda()
  333. .eq(User::getName, dto.getName())
  334. .eq(User::getCredentialNumber, dto.getIdCard()));
  335. UserStudentAddDto userStudentAddDto = new UserStudentAddDto();
  336. if (user == null) {
  337. return R.error("学生不存在!");
  338. }
  339. userStudentAddDto.setUserId(dto.getUserId());
  340. userStudentAddDto.setStudentId(user.getId());
  341. return R.ok(userStudentService.add(userStudentAddDto));
  342. }
  343. @DeleteMapping("/unbind-student")
  344. @ApiOperation(value = "解绑学生")
  345. public R unBindStudent(@Valid @RequestBody UserStudentDeleteDto dto) {
  346. return R.ok(userStudentService.delete(dto));
  347. }
  348. @GetMapping("/student")
  349. @ApiOperation(value = "获取绑定学生")
  350. public R unBindStudent(@Valid @RequestParam Long id) {
  351. return R.ok(baseClassService.getStudents(id));
  352. }
  353. }