SysUserController.java 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674
  1. package com.xunmei.system.controller;
  2. import cn.hutool.core.util.ObjectUtil;
  3. import com.alibaba.excel.EasyExcel;
  4. import com.alibaba.excel.context.AnalysisContext;
  5. import com.alibaba.excel.event.AnalysisEventListener;
  6. import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
  7. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  8. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  9. import com.xunmei.common.core.domain.R;
  10. import com.xunmei.common.core.domain.message.domain.CoreAnnouncementNotificationToRole;
  11. import com.xunmei.common.core.utils.DateUtils;
  12. import com.xunmei.common.core.utils.StringUtils;
  13. import com.xunmei.common.core.vo.IdNameVo;
  14. import com.xunmei.common.core.web.controller.BaseController;
  15. import com.xunmei.common.core.web.domain.AjaxResult;
  16. import com.xunmei.common.core.web.page.TableDataInfo;
  17. import com.xunmei.common.log.annotation.Log;
  18. import com.xunmei.common.log.enums.BusinessType;
  19. import com.xunmei.common.security.annotation.InnerAuth;
  20. import com.xunmei.common.security.annotation.RequiresPermissions;
  21. import com.xunmei.common.security.utils.SaltHelper;
  22. import com.xunmei.common.security.utils.SecurityUtils;
  23. import com.xunmei.system.api.domain.*;
  24. import com.xunmei.system.api.model.LoginUser;
  25. import com.xunmei.system.domain.SysUserRole;
  26. import com.xunmei.system.domain.vo.SysUserListVo;
  27. import com.xunmei.system.domain.vo.UserRoleVo;
  28. import com.xunmei.system.api.dto.SysPlanOrgDTO;
  29. import com.xunmei.system.mapper.SysOrgMapper;
  30. import com.xunmei.system.service.*;
  31. import com.xunmei.system.util.UserExport;
  32. import io.swagger.annotations.ApiOperation;
  33. import org.apache.commons.lang3.ArrayUtils;
  34. import org.springframework.beans.BeanUtils;
  35. import org.springframework.beans.factory.annotation.Autowired;
  36. import org.springframework.transaction.annotation.Transactional;
  37. import org.springframework.validation.annotation.Validated;
  38. import org.springframework.web.bind.annotation.*;
  39. import org.springframework.web.multipart.MultipartFile;
  40. import javax.servlet.http.HttpServletResponse;
  41. import java.io.File;
  42. import java.io.IOException;
  43. import java.net.URLEncoder;
  44. import java.util.*;
  45. import java.util.concurrent.atomic.AtomicInteger;
  46. import java.util.stream.Collectors;
  47. /**
  48. * 用户信息
  49. *
  50. * @author xunmei
  51. */
  52. @RestController
  53. @RequestMapping("/user")
  54. public class SysUserController extends BaseController {
  55. @Autowired
  56. private ISysUserService userService;
  57. @Autowired
  58. private ISysRoleService roleService;
  59. @Autowired
  60. private ISysDeptService deptService;
  61. @Autowired
  62. private ISysPostService postService;
  63. @Autowired
  64. private ISysPermissionService permissionService;
  65. @Autowired
  66. private ISysConfigService configService;
  67. @Autowired
  68. private ISysUserRoleService sysUserRoleService;
  69. @Autowired
  70. private ISysUserInformationService sysUserInformationService;
  71. @Autowired
  72. private SysOrgMapper orgMapper;
  73. /**
  74. * 获取用户列表
  75. */
  76. @RequiresPermissions("system:user:list")
  77. @GetMapping("/list")
  78. public AjaxResult list(SysUser user) {
  79. AjaxResult ajax = AjaxResult.success();
  80. com.xunmei.common.core.web.page.TableDataInfo<com.xunmei.system.api.domain.SysUser> sysUserTableDataInfo = userService.selectUserList(user);
  81. ajax.put("data", sysUserTableDataInfo);
  82. boolean admin = false;
  83. SysUser sysUser = userService.selectUserById(SecurityUtils.getUserId());
  84. if (null != sysUser && "Y".equals(sysUser.getIsManage())) {
  85. admin = true;
  86. }
  87. ajax.put("check", admin);
  88. String orgName="福建农信";
  89. if (null!=user.getOrgId()){
  90. SysOrg sysOrg = orgMapper.selectSysOrgById(user.getOrgId());
  91. orgName=sysOrg.getShortName();
  92. }
  93. ajax.put("orgName",orgName);
  94. return ajax;
  95. }
  96. /**
  97. * 获取用户列表
  98. */
  99. @RequiresPermissions("system:user:list")
  100. @GetMapping("/userselector/list")
  101. public AjaxResult userSelectorList(SysUser user) {
  102. TableDataInfo<SysUser> sysUserTableDataInfo = userService.userSelectorList(user);
  103. return success(sysUserTableDataInfo);
  104. }
  105. @RequiresPermissions("system:user:list")
  106. @GetMapping("/dictionlist")
  107. public R<List<SysUser>> list2(SysUser user) {
  108. try {
  109. if (ObjectUtil.isEmpty(user.getOrgId())) {
  110. user.setOrgId(SecurityUtils.getLoginUser().getOrgId());
  111. }
  112. return R.ok(userService.selectSyncUserList(user));
  113. } catch (Exception e) {
  114. return R.fail(e.getMessage());
  115. }
  116. }
  117. // @RequiresPermissions("system:user:list")
  118. @GetMapping("/userListData")
  119. public R<List<SysUser>> userListData(SysUser user) {
  120. if (ObjectUtil.isEmpty(user.getOrgId())) {
  121. user.setOrgId(SecurityUtils.getLoginUser().getOrgId());
  122. }
  123. return R.ok(userService.selectUserListData(user));
  124. }
  125. /**
  126. * 获取当前用户信息
  127. */
  128. @InnerAuth
  129. @GetMapping("/info/{username}")
  130. public R<LoginUser> info(@PathVariable("username") String username) {
  131. SysUser sysUser = userService.selectUserByUserName(username);
  132. if (StringUtils.isNull(sysUser)) {
  133. return R.fail("用户名或密码错误");
  134. }
  135. //获取当前用户的角色数据。
  136. List<SysRole> sysRoles = roleService.selectRolesByUserId(sysUser.getId());
  137. sysUser.setRoles(sysRoles);
  138. // 角色集合
  139. Set<String> roles = permissionService.getRolePermission(sysUser);
  140. // 权限集合
  141. Set<String> permissions = permissionService.getMenuPermission(sysUser);
  142. LoginUser sysUserVo = new LoginUser();
  143. sysUserVo.setOrgId(sysUser.getOrgId());
  144. sysUserVo.setName(sysUser.getName());
  145. sysUserVo.setSysUser(sysUser);
  146. sysUserVo.setRoles(roles);
  147. sysUserVo.setPermissions(permissions);
  148. return R.ok(sysUserVo);
  149. }
  150. /**
  151. * 注册用户信息
  152. */
  153. @InnerAuth
  154. @PostMapping("/register")
  155. public R<Boolean> register(@RequestBody SysUser sysUser) {
  156. String username = sysUser.getUsername();
  157. if (!("true".equals(configService.selectConfigByKey("sys.account.registerUser")))) {
  158. return R.fail("当前系统没有开启注册功能!");
  159. }
  160. if (!userService.checkUserNameUnique(sysUser)) {
  161. return R.fail("保存用户'" + username + "'失败,注册账号已存在");
  162. }
  163. return R.ok(userService.registerUser(sysUser));
  164. }
  165. /**
  166. * 获取用户信息
  167. *
  168. * @return 用户信息
  169. */
  170. @GetMapping("getInfo")
  171. public AjaxResult getInfo() {
  172. SysUser user = userService.selectUserById(SecurityUtils.getUserId());
  173. SysOrg org = orgMapper.selectOne(new LambdaQueryWrapper<SysOrg>()
  174. .eq(SysOrg::getId, user.getOrgId())
  175. .select(SysOrg::getType, SysOrg::getShortName));
  176. if (ObjectUtil.isNotEmpty(org)) {
  177. user.setOrgType(org.getType());
  178. user.setOrgShortName(org.getShortName());
  179. }
  180. // 角色集合
  181. Set<String> roles = permissionService.getRolePermission(user);
  182. // 权限集合
  183. Set<String> permissions = permissionService.getMenuPermission(user);
  184. List<UserRoleVo> userRoleVos = sysUserRoleService.selectUserRoleVoList(user.getId());
  185. AjaxResult ajax = AjaxResult.success();
  186. ajax.put("user", user);
  187. ajax.put("roles", roles);
  188. //用户角色信息
  189. ajax.put("roleList", userRoleVos);
  190. ajax.put("permissions", permissions);
  191. return ajax;
  192. }
  193. /**
  194. * 根据用户编号获取详细信息
  195. */
  196. @RequiresPermissions("system:user:query")
  197. @GetMapping(value = {"/", "/{userId}"})
  198. public AjaxResult getInfo(@PathVariable(value = "userId", required = false) Long userId) {
  199. userService.checkUserDataScope(userId);
  200. AjaxResult ajax = AjaxResult.success();
  201. List<SysRole> roles = roleService.selectRoleAll();
  202. ajax.put("roles", roles);
  203. ajax.put("posts", null);
  204. if (StringUtils.isNotNull(userId)) {
  205. SysUserInformation informationByUserId = sysUserInformationService.getInformationByUserId(userId);
  206. if (null == informationByUserId) {
  207. informationByUserId = new SysUserInformation();
  208. }
  209. SysUser sysUser = userService.selectUserById(userId);
  210. sysUser.setOrgId(sysUser.getOriginalOrgId());
  211. List<SysUserRole> userRoles = sysUserRoleService.list(new QueryWrapper<SysUserRole>().eq("user_id", userId));
  212. sysUser.setRoles(roles);
  213. String sex = "-";
  214. String status = "禁用";
  215. if (null != sysUser) {
  216. if (null != sysUser.getGender()) {
  217. if (sysUser.getGender().equals("1")) {
  218. sex = "女";
  219. } else {
  220. sex = "男";
  221. }
  222. }
  223. if (sysUser.getIsLock().equals("0")) {
  224. status = "启用";
  225. }
  226. }
  227. ajax.put(AjaxResult.DATA_TAG, sysUser);
  228. ajax.put("information", informationByUserId);
  229. ajax.put("postIds", null);
  230. ajax.put("roleIds", userRoles.stream().map(SysUserRole::getRoleId).collect(Collectors.toList()));
  231. ajax.put("roleName", roleService.getRoleName(userId));
  232. ajax.put("sex", sex);
  233. ajax.put("status", status);
  234. ajax.put("source", sysUser.getSource());
  235. }
  236. return ajax;
  237. }
  238. /**
  239. * 新增用户
  240. */
  241. @RequiresPermissions("system:user:add")
  242. @Log(title = "用户管理", businessType = BusinessType.INSERT)
  243. @PostMapping
  244. @Transactional(rollbackFor = Exception.class)
  245. public AjaxResult add(@Validated @RequestBody SysUser user) {
  246. if (!userService.checkUserNameUnique(user)) {
  247. return error("新增用户'" + user.getUsername() + "'失败,账号已存在");
  248. } else if (StringUtils.isNotEmpty(user.getPhone()) && !userService.checkPhoneUnique(user)) {
  249. return error("新增用户'" + user.getUsername() + "'失败,手机号码已存在");
  250. }
  251. user.setCreateBy(SecurityUtils.getUsername());
  252. user.setSource(0);
  253. user.setCreateTime(new Date());
  254. //isp的加密方式
  255. final String salt = SaltHelper.salt();
  256. user.setSalt(salt);
  257. user.setPassword(SaltHelper.exec(user.getPassword(), salt));
  258. user.setOriginalOrgId(user.getOrgId());
  259. userService.insertUser(user);
  260. return AjaxResult.success();
  261. }
  262. @GetMapping("/selectrolesByOrgId")
  263. public AjaxResult selectrolesByOrgId(Long orgId) {
  264. return AjaxResult.success(userService.selectrolesByOrgId(orgId));
  265. }
  266. /**
  267. * 修改用户
  268. */
  269. @RequiresPermissions("system:user:edit")
  270. @Log(title = "用户管理", businessType = BusinessType.UPDATE)
  271. @PutMapping
  272. public AjaxResult edit(@Validated @RequestBody SysUser user) {
  273. userService.checkUserAllowed(user);
  274. userService.checkUserDataScope(user.getId());
  275. if (!userService.checkUserNameUnique(user)) {
  276. return error("修改用户'" + user.getUsername() + "'失败,账号已存在");
  277. } else if (StringUtils.isNotEmpty(user.getPhone()) && !userService.checkPhoneUnique(user)) {
  278. return error("修改用户'" + user.getUsername() + "'失败,手机号码已存在");
  279. }
  280. if (user.getRoleIds() != null && user.getRoleIds().length > 0) {
  281. sysUserRoleService.remove(new QueryWrapper<SysUserRole>().eq("user_id", user.getId()));
  282. for (Long roleId :
  283. user.getRoleIds()) {
  284. SysUserRole sysUserRole = new SysUserRole();
  285. sysUserRole.setUserId(user.getId());
  286. sysUserRole.setRoleId(roleId);
  287. sysUserRole.setCreateTime(new Date());
  288. sysUserRoleService.insertSysUserRole(sysUserRole);
  289. }
  290. }
  291. user.setOriginalOrgId(user.getOrgId());
  292. user.setUpdateBy(SecurityUtils.getUsername());
  293. return toAjax(userService.updateUser(user));
  294. }
  295. /**
  296. * 删除用户
  297. */
  298. @RequiresPermissions("system:user:remove")
  299. @Log(title = "用户管理", businessType = BusinessType.DELETE)
  300. @DeleteMapping("/{userIds}")
  301. public AjaxResult remove(@PathVariable Long[] userIds) {
  302. if (ArrayUtils.contains(userIds, SecurityUtils.getUserId())) {
  303. return error("当前用户不能删除");
  304. }
  305. return toAjax(userService.deleteUserByIds(userIds));
  306. }
  307. /**
  308. * 重置密码
  309. */
  310. @RequiresPermissions("system:user:edit")
  311. @Log(title = "用户管理", businessType = BusinessType.UPDATE)
  312. @PutMapping("/resetPwd")
  313. public AjaxResult resetPwd(@RequestBody SysUser user) {
  314. userService.checkUserAllowed(user);
  315. userService.checkUserDataScope(user.getId());
  316. final String salt = SaltHelper.salt();
  317. user.setSalt(salt);
  318. // user.setPassword(SaltHelper.exec(user.getPassword(), userService.selectUserById(user.getId()).getSalt()));
  319. user.setPassword(SaltHelper.exec(user.getPassword(), salt));
  320. user.setUpdateBy(SecurityUtils.getUsername());
  321. return toAjax(userService.resetPwd(user));
  322. }
  323. /**
  324. * 状态修改
  325. */
  326. @RequiresPermissions("system:user:edit")
  327. @Log(title = "用户管理", businessType = BusinessType.UPDATE)
  328. @PutMapping("/changeStatus")
  329. public AjaxResult changeStatus(@RequestBody SysUser user) {
  330. userService.checkUserAllowed(user);
  331. userService.checkUserDataScope(user.getId());
  332. user.setUpdateBy(SecurityUtils.getUsername());
  333. return toAjax(userService.updateUserStatus(user));
  334. }
  335. /**
  336. * 根据用户编号获取授权角色
  337. */
  338. @RequiresPermissions("system:user:query")
  339. @GetMapping("/authRole/{userId}")
  340. public AjaxResult authRole(@PathVariable("userId") Long userId) {
  341. AjaxResult ajax = AjaxResult.success();
  342. SysUser user = userService.selectUserById(userId);
  343. List<SysRole> roles = roleService.selectRolesByUserId(userId);
  344. List<SysUserRole> userRoles = sysUserRoleService.selectSysUserRoleListByUserId(userId);
  345. ajax.put("user", user);
  346. ajax.put("roles", roles);
  347. ajax.put("userRoles", userRoles);
  348. return ajax;
  349. }
  350. /**
  351. * 用户授权角色
  352. */
  353. @RequiresPermissions("system:user:edit")
  354. @Log(title = "用户管理", businessType = BusinessType.GRANT)
  355. @PutMapping("/authRole")
  356. public AjaxResult insertAuthRole(Long userId, Long[] roleIds) {
  357. userService.checkUserDataScope(userId);
  358. userService.insertUserAuth(userId, roleIds);
  359. return success();
  360. }
  361. /**
  362. * 获取用户列表
  363. */
  364. @InnerAuth
  365. @PostMapping("/sync/list")
  366. public R<List<SysUser>> syncUserList(@RequestBody SysUser user) {
  367. try {
  368. return R.ok(userService.selectSyncUserList(user));
  369. } catch (Exception e) {
  370. return R.fail(e.getMessage());
  371. }
  372. }
  373. @InnerAuth
  374. @GetMapping("/getUserById")
  375. public SysUser getUserById(Long id) {
  376. return userService.selectUserById(id);
  377. }
  378. /**
  379. * 查询机构列表
  380. */
  381. @ApiOperation(value = "批量保存同步用户数据")
  382. @InnerAuth
  383. @PostMapping("/sync/batch")
  384. public R<Boolean> batchSaveSyncSysOrgs(@RequestBody List<SysUser> sysUserList) {
  385. userService.batchSaveOrUpdate(sysUserList);
  386. return R.ok(true);
  387. }
  388. /**
  389. * 查询机构列表
  390. */
  391. @ApiOperation(value = "记录用户最后一次登录")
  392. @InnerAuth
  393. @PostMapping("/userLoginInfo")
  394. public R<Boolean> userLoginInfo(Long id, Date loginTime, String loginIp) {
  395. SysUser sysUser = userService.selectUserById(id);
  396. sysUser.setLastIp(loginIp);
  397. if (null == loginTime) {
  398. loginTime = DateUtils.getNowDate();
  399. }
  400. sysUser.setLastTime(loginTime);
  401. userService.saveOrUpdate(sysUser);
  402. return R.ok(true);
  403. }
  404. @ApiOperation(value = "根据机构id查询用户")
  405. @GetMapping("/getByOrgId/{orgId}")
  406. public R<List<SysUserListVo>> getByOrgId(@PathVariable Long orgId) {
  407. List<SysUserListVo> sysUsers = userService.selectUserByOrgId(orgId);
  408. return R.ok(sysUsers);
  409. }
  410. @InnerAuth
  411. @PostMapping("/allUserList")
  412. public List<SysUser> allUserList() {
  413. return userService.list();
  414. }
  415. @ApiOperation(value = "通过角色获取用户")
  416. @InnerAuth
  417. @PostMapping("/userListByRole")
  418. public List<SysUser> userLoginInfo(@RequestBody List<CoreAnnouncementNotificationToRole> notificationToRoles) {
  419. return userService.selectUserListByRole(notificationToRoles);
  420. }
  421. @GetMapping("/selectAllUser")
  422. public AjaxResult selectAllUser(@PathVariable(value = "userName", required = false) String userName) {
  423. return success(userService.selectAllUser(userName));
  424. }
  425. @ApiOperation(value = "通过角色和机构获取用户")
  426. @InnerAuth
  427. @PostMapping("/userListByRoleAndOrg")
  428. public List<SysUser> userListByRoleAndOrg(@RequestBody SysPlanOrgDTO sysRoleOrgDTO) {
  429. return userService.selectUserListByRoleAndOrg(sysRoleOrgDTO);
  430. }
  431. /**
  432. * 获取用户的角色id及名称
  433. *
  434. * @param
  435. * @return
  436. */
  437. @ApiOperation(value = "获取用户的角色id及名称")
  438. @InnerAuth
  439. @GetMapping("/getroleinfoofuser")
  440. public List<IdNameVo> getRoleInfoOfUser(@RequestParam Long userId) {
  441. List<UserRoleVo> vos = sysUserRoleService.selectUserRoleVoList(userId);
  442. return vos.stream().map(v -> {
  443. IdNameVo vo = new IdNameVo();
  444. vo.setId(v.getRoleId());
  445. vo.setName(v.getRoleName());
  446. return vo;
  447. }).collect(Collectors.toList());
  448. }
  449. /**
  450. * 导出用户数据
  451. */
  452. @RequiresPermissions("system:user:export")
  453. @PostMapping("/export")
  454. public void export(SysUser user, HttpServletResponse response) {
  455. List<UserExport> list = null;
  456. Set<String> excludeColumnFiledNames = new HashSet<String>();
  457. //如果导出模板
  458. if (user.getTemplate() != null && user.getTemplate()) {
  459. excludeColumnFiledNames.add("lastIp");
  460. excludeColumnFiledNames.add("lastTime");
  461. list = new ArrayList<>();
  462. } else {
  463. list = userService.down(user);
  464. if (ObjectUtil.isEmpty(list)) {
  465. throw new RuntimeException("导出数据为空!");
  466. }
  467. AtomicInteger xh = new AtomicInteger();
  468. xh.getAndIncrement();
  469. list.forEach(e -> {
  470. if (e.getIsManager() == null) {
  471. e.setIsManager("N");
  472. }
  473. e.setXh(String.valueOf(xh.getAndIncrement()));
  474. });
  475. if (list.size() > 10000) {
  476. throw new RuntimeException("导出数据量过大(单次导出限量10000条数据),请填写条件分批导出");
  477. }
  478. }
  479. try {
  480. // 设置响应头
  481. response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("用户数据", "utf-8"));
  482. response.setContentType("application/octet-stream;charset=UTF-8");
  483. response.setCharacterEncoding("utf-8");
  484. // 数据导出
  485. EasyExcel.write(response.getOutputStream(), UserExport.class).excludeColumnFiledNames(excludeColumnFiledNames)
  486. .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).sheet("用户数据").doWrite(list);
  487. } catch (Exception e) {
  488. // 重置response
  489. response.reset();
  490. response.setContentType("application/json");
  491. response.setCharacterEncoding("utf-8");
  492. }
  493. }
  494. /**
  495. * 导出管理人员数据
  496. */
  497. @RequiresPermissions("system:user:exportManager")
  498. @PostMapping("/exportManager")
  499. public void exportManager(SysUser user, HttpServletResponse response) {
  500. List<UserExport> list = userService.down(user);
  501. if (ObjectUtil.isEmpty(list)) {
  502. throw new RuntimeException("导出数据为空!");
  503. }
  504. list = list.stream().filter(e -> "Y".equals(e.getIsManager())).collect(Collectors.toList());
  505. AtomicInteger xh = new AtomicInteger();
  506. xh.getAndIncrement();
  507. list.forEach(e -> {
  508. if (e.getIsManager() == null) {
  509. e.setIsManager("N");
  510. }
  511. e.setXh(String.valueOf(xh.getAndIncrement()));
  512. });
  513. if (list.size() > 10000) {
  514. throw new RuntimeException("导出数据量过大(单次导出限量10000条数据),请填写条件分批导出");
  515. }
  516. try {
  517. // 设置响应头
  518. response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("用户数据", "utf-8"));
  519. response.setContentType("application/octet-stream;charset=UTF-8");
  520. response.setCharacterEncoding("utf-8");
  521. // 数据导出
  522. EasyExcel.write(response.getOutputStream(), UserExport.class)
  523. .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).sheet("用户数据").doWrite(list);
  524. } catch (Exception e) {
  525. // 重置response
  526. response.reset();
  527. response.setContentType("application/json");
  528. response.setCharacterEncoding("utf-8");
  529. }
  530. }
  531. /**
  532. * 导入
  533. */
  534. @RequiresPermissions("system:user:import")
  535. @ResponseBody
  536. @PostMapping("/importData")
  537. @Transactional(rollbackFor = {RuntimeException.class, Exception.class})
  538. public AjaxResult importData(MultipartFile file, boolean updateSupport) {
  539. List<UserExport> list = new ArrayList<>();
  540. // 读取excel
  541. EasyExcel.read(multipartFileToFile(file), UserExport.class, new AnalysisEventListener<UserExport>() {
  542. // 每解析一行数据,该方法会被调用一次
  543. @Override
  544. public void invoke(UserExport user, AnalysisContext analysisContext) {
  545. // System.out.println("解析数据为:" + user.toString());
  546. if (user.getName() != null) {
  547. list.add(user);
  548. }
  549. }
  550. // 全部解析完成被调用
  551. @Override
  552. public void doAfterAllAnalysed(AnalysisContext analysisContext) {
  553. // System.out.println("解析完成...");
  554. List<String> names = list.stream().map(UserExport::getName).collect(Collectors.toList());
  555. List<String> exist = userService.selectCountByNames(names);
  556. if (exist.size() > 0) {
  557. throw new RuntimeException("用户" + exist + "已存在");
  558. }
  559. // 将解析的数据保存到数据库
  560. for (UserExport u : list) {
  561. //构建基础user对象
  562. SysUser user = new SysUser();
  563. BeanUtils.copyProperties(u, user);
  564. user.setDeleted(0);
  565. user.setIsLock("启用".equals(u.getIsLock()) ? "1" : "0");
  566. SysOrg org = orgMapper.selectOne(new LambdaQueryWrapper<SysOrg>().eq(SysOrg::getShortName, u.getOrgName()).eq(SysOrg::getDeleted, 0));
  567. if (org == null) {
  568. throw new RuntimeException("机构" + u.getOrgName() + "不存在");
  569. }
  570. user.setOrgName(org.getName());
  571. user.setOrgPath(org.getPath());
  572. user.setOrgId(org.getId());
  573. user.setOrgType(org.getType());
  574. user.setCreateBy(SecurityUtils.getUsername());
  575. user.setSource(0);
  576. user.setCreateTime(new Date());
  577. //isp的加密方式
  578. final String salt = SaltHelper.salt();
  579. user.setSalt(salt);
  580. user.setPassword(SaltHelper.exec("Admin1234", salt));
  581. user.setOriginalOrgId(user.getOrgId());
  582. userService.insertUser(user);
  583. //构建用户角色关联关系
  584. String[] roleNames = user.getRoleNames().split(",");
  585. List<SysRole> roles = roleService.list(new LambdaQueryWrapper<SysRole>().in(SysRole::getRoleName, roleNames));
  586. if (roles.size() != roleNames.length) {
  587. throw new RuntimeException("角色" + Arrays.toString(roleNames) + "存在异常");
  588. }
  589. for (SysRole r :
  590. roles) {
  591. SysUserRole sysUserRole = new SysUserRole();
  592. sysUserRole.setUserId(user.getId());
  593. sysUserRole.setRoleId(r.getId());
  594. sysUserRoleService.insertSysUserRole(sysUserRole);
  595. }
  596. }
  597. }
  598. }).sheet().doRead();
  599. return success("导入成功!");
  600. }
  601. /***
  602. * 功能描述:
  603. * MultipartFile 转 File
  604. * @return: java.io.File
  605. */
  606. public static File multipartFileToFile(MultipartFile multipartFile) {
  607. // 获取文件名
  608. String fileName = multipartFile.getOriginalFilename();
  609. // 获取文件后缀
  610. assert fileName != null;
  611. String suffix = fileName.substring(fileName.lastIndexOf("."));
  612. // 若需要防止临时文件重复,需要在文件名后加上UUID
  613. try {
  614. File file = File.createTempFile(fileName.substring(0, fileName.lastIndexOf(".")) + UUID.randomUUID(), suffix);
  615. multipartFile.transferTo(file);
  616. return file;
  617. } catch (IOException e) {
  618. e.printStackTrace();
  619. }
  620. return null;
  621. }
  622. }