GptTeamAccountServiceImpl.java 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  1. package com.cyksj.service.chatgpt.impl;
  2. import cn.hutool.core.collection.CollUtil;
  3. import cn.hutool.core.util.StrUtil;
  4. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  5. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  6. import com.cyksj.common.exception.BusinessRuntimeException;
  7. import com.cyksj.mapper.GptTeamAccountMapper;
  8. import com.cyksj.model.entity.GptTeamAccount;
  9. import com.cyksj.service.chatgpt.GptTeamAccountService;
  10. import com.ejlchina.searcher.BeanSearcher;
  11. import com.ejlchina.searcher.SearchResult;
  12. import com.ejlchina.searcher.util.MapUtils;
  13. import lombok.RequiredArgsConstructor;
  14. import lombok.extern.slf4j.Slf4j;
  15. import org.springframework.stereotype.Service;
  16. import org.springframework.transaction.annotation.Transactional;
  17. import javax.servlet.http.HttpServletRequest;
  18. import java.util.ArrayList;
  19. import java.util.HashSet;
  20. import java.util.List;
  21. import java.util.Set;
  22. /**
  23. * GPT Team账号 Service实现
  24. */
  25. @Slf4j
  26. @Service
  27. @RequiredArgsConstructor
  28. public class GptTeamAccountServiceImpl extends ServiceImpl<GptTeamAccountMapper, GptTeamAccount> implements GptTeamAccountService {
  29. private final BeanSearcher beanSearcher;
  30. private final HttpServletRequest request;
  31. @Override
  32. public SearchResult<GptTeamAccount> getPage() {
  33. return beanSearcher.search(GptTeamAccount.class, MapUtils.flatBuilder(request.getParameterMap())
  34. .orderBy(GptTeamAccount::getId).desc()
  35. .build());
  36. }
  37. @Override
  38. @Transactional(rollbackFor = Exception.class)
  39. public void addAccount(GptTeamAccount account) {
  40. // 验证token唯一性
  41. if (StrUtil.isNotBlank(account.getToken())) {
  42. Integer count = baseMapper.selectCount(Wrappers.lambdaQuery(GptTeamAccount.class)
  43. .eq(GptTeamAccount::getToken, account.getToken()));
  44. if (count > 0) {
  45. throw BusinessRuntimeException.getInstance("Token已存在");
  46. }
  47. }
  48. // 验证账号唯一性
  49. if (StrUtil.isNotBlank(account.getAccount())) {
  50. Integer count = baseMapper.selectCount(Wrappers.lambdaQuery(GptTeamAccount.class)
  51. .eq(GptTeamAccount::getAccount, account.getAccount()));
  52. if (count > 0) {
  53. throw BusinessRuntimeException.getInstance("账号已存在");
  54. }
  55. }
  56. this.save(account);
  57. }
  58. @Override
  59. @Transactional(rollbackFor = Exception.class)
  60. public void updateAccount(GptTeamAccount account) {
  61. if (account.getId() == null) {
  62. throw BusinessRuntimeException.getInstance("ID不能为空");
  63. }
  64. // 验证token唯一性
  65. if (StrUtil.isNotBlank(account.getToken())) {
  66. Integer count = baseMapper.selectCount(Wrappers.lambdaQuery(GptTeamAccount.class)
  67. .eq(GptTeamAccount::getToken, account.getToken())
  68. .ne(GptTeamAccount::getId, account.getId()));
  69. if (count > 0) {
  70. throw BusinessRuntimeException.getInstance("Token已存在");
  71. }
  72. }
  73. // 验证账号唯一性
  74. if (StrUtil.isNotBlank(account.getAccount())) {
  75. Integer count = baseMapper.selectCount(Wrappers.lambdaQuery(GptTeamAccount.class)
  76. .eq(GptTeamAccount::getAccount, account.getAccount())
  77. .ne(GptTeamAccount::getId, account.getId()));
  78. if (count > 0) {
  79. throw BusinessRuntimeException.getInstance("账号已存在");
  80. }
  81. }
  82. this.updateById(account);
  83. }
  84. @Override
  85. @Transactional(rollbackFor = Exception.class)
  86. public void deleteAccount(Long id) {
  87. if (id == null) {
  88. throw BusinessRuntimeException.getInstance("ID不能为空");
  89. }
  90. this.removeById(id);
  91. }
  92. @Override
  93. @Transactional(rollbackFor = Exception.class)
  94. public void batchImport(List<String> tokens) {
  95. if (CollUtil.isEmpty(tokens)) {
  96. throw BusinessRuntimeException.getInstance("导入数据不能为空");
  97. }
  98. // 去重
  99. Set<String> tokenSet = new HashSet<>(tokens);
  100. // 过滤空白token
  101. tokenSet.removeIf(StrUtil::isBlank);
  102. if (tokenSet.isEmpty()) {
  103. throw BusinessRuntimeException.getInstance("有效token为空");
  104. }
  105. // 查询已存在的token
  106. List<GptTeamAccount> existingAccounts = baseMapper.selectList(
  107. Wrappers.lambdaQuery(GptTeamAccount.class)
  108. .in(GptTeamAccount::getToken, tokenSet)
  109. );
  110. Set<String> existingTokens = new HashSet<>();
  111. for (GptTeamAccount account : existingAccounts) {
  112. existingTokens.add(account.getToken());
  113. }
  114. // 准备新增的账号列表
  115. List<GptTeamAccount> newAccounts = new ArrayList<>();
  116. int skipCount = 0;
  117. for (String token : tokenSet) {
  118. if (existingTokens.contains(token)) {
  119. skipCount++;
  120. continue;
  121. }
  122. GptTeamAccount account = new GptTeamAccount();
  123. account.setToken(token);
  124. account.setStatus(true); // 默认启用
  125. newAccounts.add(account);
  126. }
  127. // 批量保存
  128. if (CollUtil.isNotEmpty(newAccounts)) {
  129. this.saveBatch(newAccounts);
  130. }
  131. }
  132. }