UserServiceImpl.java 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623
  1. package com.om.service.impl;
  2. import cn.hutool.core.bean.BeanUtil;
  3. import cn.hutool.core.collection.ListUtil;
  4. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  5. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  6. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  7. import com.om.constant.RedisConstant;
  8. import com.om.entity.dto.*;
  9. import com.om.entity.po.*;
  10. import com.om.entity.vo.*;
  11. import com.om.exception.BadReqException;
  12. import com.om.exception.BizException;
  13. import com.om.exception.CustomerAuthenticationException;
  14. import com.om.mapper.DeviceMapper;
  15. import com.om.mapper.UserMapper;
  16. import com.om.service.*;
  17. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  18. import com.om.utils.*;
  19. import lombok.extern.slf4j.Slf4j;
  20. import org.apache.commons.lang3.StringUtils;
  21. import org.springframework.data.redis.core.RedisTemplate;
  22. import org.springframework.stereotype.Service;
  23. import org.springframework.transaction.annotation.Transactional;
  24. import org.springframework.util.DigestUtils;
  25. import javax.annotation.Resource;
  26. import javax.servlet.http.HttpServletRequest;
  27. import java.time.LocalDateTime;
  28. import java.util.ArrayList;
  29. import java.util.HashMap;
  30. import java.util.List;
  31. import java.util.Map;
  32. import java.util.concurrent.TimeUnit;
  33. import java.util.stream.Collectors;
  34. /**
  35. * <p>
  36. * 应用用户信息表 服务实现类
  37. * </p>
  38. *
  39. * @author bmmx
  40. * @since 2024-01-29
  41. */
  42. @Service
  43. @Slf4j
  44. public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
  45. @Resource
  46. private JwtUtils jwtUtils;
  47. @Resource
  48. private RedisTemplate redisTemplate;
  49. @Resource
  50. IUserVciService userVciService;
  51. @Resource
  52. UserMapper userMapper;
  53. @Resource
  54. IVciInfoService vciInfoService;
  55. @Resource
  56. HttpServletRequest request;
  57. @Resource
  58. private IClientService clientService;
  59. @Resource
  60. private IDistributorService distributorService;
  61. @Resource
  62. private IDeviceService deviceService;
  63. @Override
  64. @Transactional
  65. public Result login(UserLoginDTO dto) {
  66. //从dto中获取数据
  67. String username = dto.getUsername();
  68. String password = dto.getPassword();
  69. String clientNum = dto.getClientNum();
  70. String deviceSn = dto.getDeviceSn();
  71. Integer type = dto.getType();
  72. String appVersion = dto.getAppVersion();
  73. //判断数据是否为空
  74. if (StringUtils.isBlank(username) || StringUtils.isBlank(password) || StringUtils.isBlank(clientNum) ||
  75. StringUtils.isBlank(deviceSn) || type == null) {
  76. return Result.fail("未获取到数据").result(ResultCode.NO_DATA);
  77. }
  78. //根据用户名查询用户
  79. User user = this.lambdaQuery()
  80. .eq(User::getUsername, username)
  81. .one();
  82. //判断用户是否存在
  83. if (BeanUtil.isEmpty(user)) {
  84. return Result.fail("用户不存在").result(ResultCode.USER_NO_EXIST);
  85. }
  86. //密码加密
  87. try {
  88. password = AesUtil.Encrypt(password);
  89. } catch (Exception e) {
  90. throw new BizException("密码加密出错", ResultCode.PASSWORD_ENCRYPT_ERROR);
  91. }
  92. //判断密码是否正确
  93. if (!StringUtils.equals(password, user.getPassword())) {
  94. return Result.fail("密码错误").result(ResultCode.PASSWORD_ERROR);
  95. }
  96. Client client = clientService.lambdaQuery()
  97. .eq(Client::getNumber, clientNum)
  98. .one();
  99. if (BeanUtil.isEmpty(client)) {
  100. throw new BadReqException("该客户端不存在");
  101. }
  102. // 生成token
  103. Map<String, Object> claims = new HashMap<>();
  104. claims.put("u_id", user.getId());
  105. claims.put("deviceSn", deviceSn);
  106. claims.put("appVersion", appVersion);
  107. claims.put("clientNum", clientNum);
  108. String guid = AesUtil.generateGuid(claims);
  109. //封装vo返回
  110. UserLoginVO userLoginVO = new UserLoginVO();
  111. // 查询 该用户所属的 维修厂
  112. Integer distributorId = user.getDistributorId();//用户所属的维修厂id
  113. Distributor distributor = distributorService.getById(distributorId);
  114. BeanUtil.copyProperties(distributor, userLoginVO);
  115. // 查询用户 所绑定的vci设备
  116. List<UserVci> userVciList = userVciService.lambdaQuery()
  117. .eq(UserVci::getUserId, user.getId())
  118. .list();
  119. if (!BeanUtil.isEmpty(userVciList)) {
  120. List<VciInfoVO> vciInfoVOList = new ArrayList<>();
  121. int defaultCount = 0;
  122. for (UserVci userVci : userVciList) {
  123. VciInfoVO vciInfoVO = new VciInfoVO();
  124. Integer vciInfoId = userVci.getVciInfoId();
  125. VciInfo vciInfo = vciInfoService.getById(vciInfoId);
  126. if (BeanUtil.isEmpty(vciInfo)) {
  127. throw new BadReqException("该VCI设备不存在");
  128. }
  129. if (userVci.getIsDefault() == 1) {
  130. userLoginVO.setVciSn(vciInfo.getVciNum());
  131. defaultCount++;
  132. }
  133. vciInfoVO.setVciNum(vciInfo.getVciNum());
  134. vciInfoVO.setState(String.valueOf(vciInfo.getState()));
  135. vciInfoVO.setPairingPwd(vciInfo.getPairingPwd());
  136. vciInfoVO.setBluetoothAddress(vciInfo.getBluetoothAddress());
  137. vciInfoVO.setIsDefault(String.valueOf(userVci.getIsDefault()));
  138. vciInfoVOList.add(vciInfoVO);
  139. }
  140. userLoginVO.setVciInfoList(vciInfoVOList);
  141. }
  142. //设置userLoginVO
  143. userLoginVO.setUsername(username);
  144. userLoginVO.setPassword(password);
  145. userLoginVO.setGuid(guid);
  146. if (user.getState() == 0) {
  147. return Result.fail("用户被禁用").result(ResultCode.USER_DISABLED);
  148. }
  149. if (type == 1) {
  150. user.setDeviceSn(deviceSn);
  151. userMapper.updateById(user);
  152. Device one = deviceService.lambdaQuery()
  153. .eq(Device::getDeviceSn, deviceSn)
  154. .eq(Device::getUsername, username)
  155. .one();
  156. if (BeanUtil.isEmpty(one)) {
  157. Device device = new Device();
  158. device.setDeviceSn(deviceSn);
  159. device.setUsername(username);
  160. device.setCreateTime(LocalDateTime.now());
  161. device.setClientNum(clientNum);
  162. deviceService.save(device);
  163. }
  164. }
  165. if (StringUtils.isBlank(user.getDeviceSn())) {
  166. return Result.ok(userLoginVO).message("账号尚未激活").result(ResultCode.USER_NO_ACTIVATE);
  167. }
  168. //查询平板设备
  169. Device device = deviceService.lambdaQuery()
  170. .eq(Device::getDeviceSn, dto.getDeviceSn())
  171. .eq(Device::getUsername, username)
  172. .one();
  173. // 绑定 客户端编号 和 设备 序列号 ( 判断type是登录(0)还是激活(1) )
  174. if (BeanUtil.isEmpty(device)) {
  175. return Result.ok(userLoginVO).message("账号尚未激活").result(ResultCode.USER_NO_ACTIVATE);
  176. }
  177. return Result.ok(userLoginVO);
  178. }
  179. @Override
  180. @Transactional
  181. public Result add(UserAddVO user) {
  182. User addUser = new User();
  183. BeanUtil.copyProperties(user, addUser);
  184. String username = user.getUsername();
  185. User one = this.lambdaQuery()
  186. .eq(User::getUsername, username)
  187. .one();
  188. if (BeanUtil.isNotEmpty(one)) {
  189. throw new BadReqException("该用户已存在");
  190. }
  191. if (addUser.getUsername() == null || addUser.getPassword() == null) {
  192. return Result.error();
  193. }
  194. String password = addUser.getPassword();
  195. //密码加密
  196. try {
  197. password = AesUtil.Encrypt(password);
  198. } catch (Exception e) {
  199. throw new BizException("密码加密出错", ResultCode.PASSWORD_ENCRYPT_ERROR);
  200. }
  201. addUser.setPassword(password);
  202. Integer distributorId = user.getDistributorId();
  203. //根据id查询维修厂
  204. if (user.getDistributorId() != null) {
  205. Distributor distributor = distributorService.getById(distributorId);
  206. if (BeanUtil.isEmpty(distributor)) {
  207. throw new BadReqException("该维修厂不存在");
  208. }
  209. addUser.setDistributorName(distributor.getCompany());
  210. }
  211. String deviceSn = user.getDeviceSn();
  212. if (StringUtils.isNotBlank(deviceSn)) {
  213. Device device = new Device();
  214. device.setDeviceSn(deviceSn);
  215. device.setUsername(user.getUsername());
  216. device.setCreateTime(LocalDateTime.now());
  217. deviceService.save(device);
  218. }
  219. this.save(addUser);
  220. if (StringUtils.isNotBlank(user.getVciSn())) {
  221. UserVci userVci = new UserVci();
  222. //根据vciSn查询
  223. VciInfo vciInfo = vciInfoService.lambdaQuery()
  224. .eq(VciInfo::getVciNum, user.getVciSn())
  225. .one();
  226. if (vciInfo == null) {
  227. throw new BadReqException("该VCI设备不存在");
  228. }
  229. userVci.setVciInfoId(vciInfo.getId());
  230. userVci.setUserId(addUser.getId());
  231. userVci.setIsDefault(0);
  232. userVciService.save(userVci);
  233. }
  234. return Result.ok();
  235. }
  236. @Override
  237. @Transactional
  238. public Result delete(Integer id) {
  239. if (id == null) {
  240. return Result.error().message("id不存在");
  241. }
  242. User user = this.getById(id);
  243. if (BeanUtil.isEmpty(user)) {
  244. throw new BadReqException("该客户端账号不存在");
  245. }
  246. //查询 user_vci 表
  247. List<UserVci> userVciList = userVciService.lambdaQuery()
  248. .eq(UserVci::getUserId, user.getId())
  249. .list();
  250. if (!userVciList.isEmpty()) {
  251. List<Integer> userVciIds = userVciList.stream().map(c -> c.getId()).collect(Collectors.toList());
  252. userVciService.removeByIds(userVciIds);
  253. }
  254. //查询 设备表
  255. List<Device> deviceList = deviceService.lambdaQuery()
  256. .eq(Device::getUsername, user.getUsername())
  257. .list();
  258. if (!deviceList.isEmpty()) {
  259. //删除设备
  260. List<Integer> deviceIds = deviceList.stream().map(c -> c.getId()).collect(Collectors.toList());
  261. deviceService.removeByIds(deviceIds);
  262. }
  263. boolean deleteById = this.removeById(id);
  264. if (deleteById == false) {
  265. return Result.error().message("删除失败");
  266. }
  267. return Result.ok();
  268. }
  269. @Override
  270. public Result getListByUserId(Integer userId) {
  271. User user = getById(userId);
  272. LambdaQueryWrapper<UserVci> vciLambdaQueryWrapper = new LambdaQueryWrapper<>();
  273. vciLambdaQueryWrapper.eq(UserVci::getUserId, userId);
  274. List<UserVci> list = userVciService.list(vciLambdaQueryWrapper);
  275. Integer[] vciId = new Integer[list.size()];
  276. String[] vciNum = new String[list.size()];
  277. for (int i = 0; i < list.size(); i++) {
  278. LambdaQueryWrapper<VciInfo> queryWrapper = new LambdaQueryWrapper<>();
  279. queryWrapper.eq(VciInfo::getVciNum, list.get(i).getVciInfoId());
  280. VciInfo vciInfo = vciInfoService.getOne(queryWrapper);
  281. vciId[i] = vciInfo.getId();
  282. vciNum[i] = vciInfo.getVciNum();
  283. }
  284. UserVciNumVO userVciNumVO = new UserVciNumVO();
  285. userVciNumVO.setVciId(vciId);
  286. userVciNumVO.setVciNum(vciNum);
  287. return Result.ok(userVciNumVO);
  288. }
  289. @Override
  290. public Result<UserQueryPageVO> getPageList(UserQueryPageDTO dto) {
  291. Integer pageIndex = dto.getPageIndex();
  292. Integer pageSize = dto.getPageSize();
  293. String searchUsername = dto.getSearchUsername();
  294. String searchPhone = dto.getSearchPhone();
  295. Page<User> page = this.lambdaQuery()
  296. .like(searchUsername != null, User::getUsername, searchUsername)
  297. .like(searchPhone != null, User::getTel, searchPhone)
  298. .orderByDesc(User::getCreateTime)
  299. .page(new Page<>(pageIndex, pageSize));
  300. UserQueryPageVO vo = new UserQueryPageVO();
  301. vo.setCurrent((int) page.getCurrent());
  302. vo.setSize((int) page.getSize());
  303. vo.setPages((int) page.getPages());
  304. vo.setTotal((int) page.getTotal());
  305. if (searchUsername != null || searchPhone != null) {
  306. vo.setSearchCount(true);
  307. }
  308. List<User> records = page.getRecords();
  309. vo.setRecords(records);
  310. return Result.ok(vo);
  311. }
  312. @Override
  313. public Result getByUserId(Integer userId) {
  314. User user = this.getById(userId);
  315. if (user == null) {
  316. return Result.error();
  317. }
  318. return Result.ok(user);
  319. }
  320. @Override
  321. public Result relieve() {
  322. return null;
  323. }
  324. @Override
  325. public Result updateState(Integer id, Integer state) {
  326. User selectUser = getById(id);
  327. if (BeanUtil.isEmpty(selectUser)) {
  328. throw new BadReqException("该用户不存在");
  329. }
  330. selectUser.setState(state);
  331. LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
  332. queryWrapper.eq(User::getId, id);
  333. userMapper.update(selectUser, queryWrapper);
  334. return Result.ok();
  335. }
  336. @Override
  337. public Result updateType(Integer id, Integer type) {
  338. User selectUser = getById(id);
  339. if (BeanUtil.isEmpty(selectUser)) {
  340. throw new BadReqException("该用户不存在");
  341. }
  342. selectUser.setUserType(type);
  343. LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
  344. queryWrapper.eq(User::getId, id);
  345. userMapper.update(selectUser, queryWrapper);
  346. return Result.ok();
  347. }
  348. @Override
  349. public Result updateUserInfo(UserAddVO user) {
  350. Integer userId = user.getId();
  351. User userById = getById(userId);
  352. String password = user.getPassword();
  353. BeanUtil.copyProperties(user, userById);
  354. if (!password.equals(userById.getPassword())){
  355. //密码加密
  356. try {
  357. password = AesUtil.Encrypt(password);
  358. } catch (Exception e) {
  359. throw new BizException("密码加密出错", ResultCode.PASSWORD_ENCRYPT_ERROR);
  360. }
  361. if (!password.equals(userById.getPassword())) {
  362. userById.setPassword(password);
  363. }
  364. }
  365. Integer distributorId = userById.getDistributorId();
  366. //根据id查询维修厂
  367. Distributor distributor = distributorService.getById(distributorId);
  368. if (BeanUtil.isEmpty(distributor)) {
  369. throw new BadReqException("该维修厂不存在");
  370. }
  371. userById.setDistributorName(distributor.getCompany());
  372. if (StringUtils.isNotBlank(user.getVciSn())) {
  373. UserVci userVci = new UserVci();
  374. //根据vciSn查询
  375. VciInfo vciInfo = vciInfoService.lambdaQuery()
  376. .eq(VciInfo::getVciNum, user.getVciSn())
  377. .one();
  378. if (vciInfo == null) {
  379. throw new BadReqException("该VCI设备不存在");
  380. }
  381. //先查询uservci
  382. UserVci one = userVciService.lambdaQuery()
  383. .eq(UserVci::getVciInfoId, vciInfo.getId())
  384. .eq(UserVci::getUserId, userId)
  385. .one();
  386. if (BeanUtil.isEmpty(one)) {
  387. userVci.setVciInfoId(vciInfo.getId());
  388. userVci.setUserId(userId);
  389. userVci.setIsDefault(0);
  390. userVciService.save(userVci);
  391. }
  392. }
  393. this.updateById(userById);
  394. return Result.ok();
  395. }
  396. @Override
  397. public Result password(AppUserUpdatePwdDTO dto) {
  398. if (BeanUtil.isEmpty(dto)) {
  399. return Result.fail("未获取到数据").result(ResultCode.NO_DATA);
  400. }
  401. String guid = dto.getGuid();
  402. GuidDTO guidDTO = AesUtil.getGuidDTOFromGuid(guid);
  403. Integer userId = guidDTO.getUserId();
  404. String username = dto.getUsername();
  405. User user = this.lambdaQuery()
  406. .eq(User::getUsername, username)
  407. .one();
  408. if (user == null) {
  409. return Result.error().message("用户不存在").result(ResultCode.USER_NO_EXIST);
  410. }
  411. try {
  412. user.setPassword(AesUtil.Encrypt(dto.getNewPassword()));
  413. } catch (Exception e) {
  414. return Result.fail("密码加密出错").result(ResultCode.PASSWORD_ENCRYPT_ERROR);
  415. }
  416. this.updateById(user);
  417. return Result.ok();
  418. }
  419. @Override
  420. public Result register(UserLoginDTO userLoginDTO) {
  421. User user = new User();
  422. if (userLoginDTO.getUsername() == null || userLoginDTO.getPassword() == null) {
  423. return Result.error().message("用户名密码为空").result(ResultCode.NO_DATA);
  424. }
  425. if (userLoginDTO.getPassword().equals(userLoginDTO.getRePassword())) {
  426. return Result.error().message("两次密码不一样").result(ResultCode.PASSWORD_ERROR);
  427. }
  428. user.setUsername(userLoginDTO.getUsername());
  429. try {
  430. user.setPassword(AesUtil.Encrypt(userLoginDTO.getPassword()));
  431. } catch (Exception e) {
  432. return Result.error().message("密码加密错误").result(ResultCode.PASSWORD_ENCRYPT_ERROR);
  433. }
  434. boolean save = save(user);
  435. if (!save) {
  436. throw new BizException("数据库操作失败");
  437. }
  438. return Result.ok();
  439. }
  440. @Override
  441. public Result updateUserName(AppBaseDTO dto) {
  442. String guid = dto.getGuid();
  443. GuidDTO guidDTO = AesUtil.getGuidDTOFromGuid(guid);
  444. Integer userId = guidDTO.getUserId();
  445. User user = getById(userId);
  446. if (user == null) {
  447. return Result.error().message("用户不存在").result(ResultCode.USER_NO_EXIST);
  448. }
  449. user.setUsername(dto.getUsername());
  450. LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
  451. queryWrapper.eq(User::getId, userId);
  452. this.update(user, queryWrapper);
  453. return Result.ok();
  454. }
  455. @Override
  456. public Result logout() {
  457. String token = request.getHeader("token");
  458. token = request.getParameter("token");
  459. //从token中获取用户id
  460. Integer uId = jwtUtils.getUserIdFromToken(token);
  461. //判断 用户id 是否为空
  462. if (org.springframework.util.StringUtils.isEmpty(uId)) {
  463. throw new CustomerAuthenticationException("token解析失败");
  464. }
  465. //判断redis中是否存在token信息
  466. String tokenKey = RedisConstant.USER_TOKEN_PREFIX + uId;
  467. redisTemplate.delete(tokenKey);
  468. return Result.ok();
  469. }
  470. @Override
  471. public Result updateVci(AppBaseDTO dto) {
  472. if (BeanUtil.isEmpty(dto)) {
  473. return Result.error().message("参数为空").result(ResultCode.NO_DATA);
  474. }
  475. String guid = dto.getGuid();
  476. GuidDTO guidDTO = AesUtil.getGuidDTOFromGuid(guid);
  477. Integer userId = guidDTO.getUserId();
  478. String vciSn = dto.getVciSn();
  479. VciInfo vciInfo = vciInfoService.lambdaQuery()
  480. .eq(VciInfo::getVciNum, vciSn)
  481. .one();
  482. if (vciInfo == null) {
  483. return Result.error().message("VCI设备不存在").result(ResultCode.SERVICE_HANDLE_ERROR);
  484. }
  485. UserVci userVci = userVciService.lambdaQuery()
  486. .eq(UserVci::getUserId, userId)
  487. .eq(UserVci::getIsDefault, true)
  488. .one();
  489. userVci.setVciInfoId(vciInfo.getId());
  490. LambdaQueryWrapper<VciInfo> queryWrapper = new LambdaQueryWrapper<>();
  491. queryWrapper.eq(VciInfo::getId, vciInfo.getId());
  492. boolean update = vciInfoService.update(vciInfo, queryWrapper);
  493. if (!update) {
  494. throw new BizException("数据库操作失败");
  495. }
  496. return Result.ok();
  497. }
  498. @Override
  499. public Result bindingVci(AppBindVO bindVO) {
  500. if (BeanUtil.isEmpty(bindVO)) {
  501. return Result.error().message("参数为空").result(ResultCode.NO_DATA);
  502. }
  503. Integer userId = bindVO.getUserId();
  504. String vciNum = bindVO.getVciSn();
  505. LambdaQueryWrapper<VciInfo> vciInfoLambdaQueryWrapper = new LambdaQueryWrapper<>();
  506. vciInfoLambdaQueryWrapper.eq(VciInfo::getVciNum, vciNum);
  507. VciInfo vciInfo = vciInfoService.getOne(vciInfoLambdaQueryWrapper);
  508. if (vciInfo == null) {
  509. return Result.error().message("VCI设备不存在").result(ResultCode.SERVICE_HANDLE_ERROR);
  510. }
  511. UserVci userVci = new UserVci();
  512. userVci.setUserId(userId);
  513. userVci.setVciInfoId(vciInfo.getId());
  514. userVciService.save(userVci);
  515. return Result.ok();
  516. }
  517. @Override
  518. public Result<List<VciInfo>> getVciByUserId(Integer userId) {
  519. //根据id查询user
  520. User user = this.getById(userId);
  521. if (BeanUtil.isEmpty(user)) {
  522. throw new BadReqException("该用户不存在");
  523. }
  524. List<UserVci> list = userVciService.lambdaQuery()
  525. .eq(UserVci::getUserId, userId)
  526. .list();
  527. if (list.isEmpty()) {
  528. return Result.ok();
  529. }
  530. return null;
  531. }
  532. }