SysUserServiceImpl.java 56 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400
  1. package com.ydtech.modules.admin.service.impl;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  4. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  5. import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
  6. import com.baomidou.mybatisplus.core.metadata.IPage;
  7. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  8. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  9. import com.ydtech.constants.SysConstants;
  10. import com.ydtech.core.page.HttpResult;
  11. import com.ydtech.core.page.PageResult;
  12. import com.ydtech.exception.SystemException;
  13. import com.ydtech.modules.admin.constants.QuMarks;
  14. import com.ydtech.modules.admin.constants.RoleConstants;
  15. import com.ydtech.modules.admin.dao.SysUserMapper;
  16. import com.ydtech.modules.admin.model.*;
  17. import com.ydtech.modules.admin.model.dto.QuTeamNumDto;
  18. import com.ydtech.modules.admin.model.dto.QuUserNumDto;
  19. import com.ydtech.modules.admin.model.dto.SysUserDto;
  20. import com.ydtech.modules.admin.model.po.SysUserIsDial;
  21. import com.ydtech.modules.admin.model.po.SysUserTreeShowLevel;
  22. import com.ydtech.modules.admin.model.vo.*;
  23. import com.ydtech.modules.admin.service.*;
  24. import com.ydtech.modules.base.controller.BaseController;
  25. import com.ydtech.modules.base.model.dto.PageDto;
  26. import com.ydtech.modules.base.model.vo.PageVo;
  27. import com.ydtech.modules.esm.model.EsmUserImage;
  28. import com.ydtech.modules.esm.model.EsmUserReferrer;
  29. import com.ydtech.modules.esm.model.vo.EsmUserImageVo;
  30. import com.ydtech.modules.esm.service.EsmUserImageService;
  31. import com.ydtech.modules.esm.service.EsmUserReferrerService;
  32. import com.ydtech.security.utils.PasswordUtils;
  33. import com.ydtech.utils.StringUtils;
  34. import com.ydtech.utils.idgen.IdGenerate;
  35. import org.springframework.beans.factory.annotation.Autowired;
  36. import org.springframework.stereotype.Service;
  37. import org.springframework.transaction.annotation.Transactional;
  38. import java.math.BigDecimal;
  39. import java.util.*;
  40. import java.util.stream.Collectors;
  41. @Service
  42. public class SysUserServiceImpl extends ServiceImpl<SysUserMapper, SysUser> implements SysUserService {
  43. @Autowired
  44. private SysMenuService sysMenuService;
  45. @Autowired
  46. private SysRoleMenuService sysRoleMenuService;
  47. @Autowired
  48. private SysDeptService sysDeptService;
  49. @Autowired
  50. private SysUserMapper sysUserMapper;
  51. @Autowired
  52. private SysUserRoleService sysUserRoleService;
  53. @Autowired
  54. private EsmUserReferrerService esmUserReferrerService;
  55. @Autowired
  56. private SysUserInfoService sysUserInfoService;
  57. @Autowired
  58. private EsmUserImageService esmUserImageService;
  59. @Autowired
  60. private SysAreaService sysAreaService;
  61. @Autowired
  62. private SysUserTreeShowLevelService sysUserTreeShowLevelService;
  63. @Autowired
  64. private SysUserIsDialService sysUserIsDialService;
  65. @Override
  66. public IPage<SysUserBaseVO> findUserList(PageDto<SysUserDto> pageDto) {
  67. PageVo<SysUserBaseVO> pageVo = new PageVo();
  68. Page page = new Page(pageDto.getPageNum(), pageDto.getPageSize());
  69. pageVo.setPageNum(pageDto.getPageNum());
  70. pageVo.setPageSize(pageDto.getPageSize());
  71. SysUserDto sysUserVO = JSONObject.parseObject(JSONObject.toJSONString(pageDto.getDto()), SysUserDto.class);
  72. if (sysUserVO.getAgentFlag() == null) {
  73. throw new SystemException("必传标识未传递");
  74. }
  75. IPage<SysUserBaseVO> userList = sysUserMapper.findUserList(page, sysUserVO);
  76. return userList;
  77. }
  78. @Override
  79. public IPage<SysUserBaseVO> findBackUserList(PageDto<SysUserDto> pageDto) {
  80. PageVo<SysUserBaseVO> pageVo = new PageVo();
  81. Page page = new Page(pageDto.getPageNum(), pageDto.getPageSize());
  82. pageVo.setPageNum(pageDto.getPageNum());
  83. pageVo.setPageSize(pageDto.getPageSize());
  84. SysUserDto sysUserVO = JSONObject.parseObject(JSONObject.toJSONString(pageDto.getDto()), SysUserDto.class);
  85. if (sysUserVO.getAgentFlag() == null) {
  86. throw new SystemException("必传标识未传递");
  87. }
  88. return sysUserMapper.findBackUserList(page, sysUserVO);
  89. }
  90. @Override
  91. public IPage<QuTeamNum> quTeamNum(QuTeamNumDto quTeamNumDto) {
  92. //判断必传标识是否为空
  93. if (quTeamNumDto.getTeamOrUserFlag() == null) {
  94. throw new SystemException("必传参数未传");
  95. }
  96. //判断是要查询用户还是团队
  97. if ("1".equals(quTeamNumDto.getTeamOrUserFlag())) {
  98. List<QuTeamNum> dept = sysUserMapper.getDept(quTeamNumDto);
  99. return getQuTeamNumIPage(quTeamNumDto, dept);
  100. } else if ("2".equals(quTeamNumDto.getTeamOrUserFlag())) {
  101. List<QuTeamNum> dept = sysUserMapper.getUser(quTeamNumDto);
  102. return getQuTeamNumIPage(quTeamNumDto, dept);
  103. }
  104. throw new SystemException("参数错误");
  105. }
  106. @Override
  107. public IPage<QuTeamNum> getQuTeamByCompany(QuTeamNumDto quTeamNumDto) {
  108. List<QuTeamNum> deptByCompany = sysUserMapper.getDeptByCompany(quTeamNumDto);
  109. IPage<QuTeamNum> page = new Page<>(quTeamNumDto.getPageNo(), quTeamNumDto.getPageSize());
  110. page.setRecords(deptByCompany);
  111. page.setTotal(deptByCompany.size());
  112. return page;
  113. }
  114. private IPage<QuTeamNum> getQuTeamNumIPage(QuTeamNumDto quTeamNumDto, List<QuTeamNum> dept) {
  115. Map<String, List<QuTeamNum>> collect = new HashMap<>();
  116. int flag;
  117. if (quTeamNumDto.getTeamOrUserFlag().equals("1")) {
  118. collect = dept.stream()
  119. .collect(Collectors.groupingBy(QuTeamNum::getDeptId));
  120. flag = 1;
  121. } else if ("2".equals(quTeamNumDto.getTeamOrUserFlag())) {
  122. collect = dept.stream()
  123. .collect(Collectors.groupingBy(QuTeamNum::getUserId));
  124. flag = 2;
  125. } else {
  126. flag = 0;
  127. }
  128. List<QuTeamNum> quTeamNums = new ArrayList<>();
  129. collect.forEach((k, v) -> {
  130. QuTeamNum teamNum = new QuTeamNum();
  131. teamNum.setHasInsuredNum("0");
  132. teamNum.setSubmitNum("0");
  133. teamNum.setSyPremiumSum("0");
  134. teamNum.setJqPremiumSum("0");
  135. teamNum.setTaxaMountSum("0");
  136. teamNum.setTotalSumpremium("0");
  137. teamNum.setQuoteNum("0");
  138. if (!v.isEmpty()) {
  139. v.forEach(quTeamNum -> {
  140. if (quTeamNum.getOrderStatus() != null) {
  141. if (quTeamNum.getOrderStatus().equals("3")) {
  142. if (quTeamNum.getJqPremiumSum() == null) {
  143. quTeamNum.setJqPremiumSum("0");
  144. }
  145. if (quTeamNum.getSyPremiumSum() == null) {
  146. quTeamNum.setSyPremiumSum("0");
  147. }
  148. //添加总额
  149. teamNum.setTotalSumpremium(String.valueOf(new BigDecimal(teamNum.getTotalSumpremium())
  150. .add(new BigDecimal(quTeamNum.getSyPremiumSum())).add(new BigDecimal(quTeamNum.getJqPremiumSum()))));
  151. teamNum.setSyPremiumSum(String.valueOf(new BigDecimal(teamNum.getSyPremiumSum()).add(new BigDecimal(quTeamNum.getSyPremiumSum()))));
  152. teamNum.setJqPremiumSum(String.valueOf(new BigDecimal(teamNum.getJqPremiumSum()).add(new BigDecimal(quTeamNum.getJqPremiumSum()))));
  153. teamNum.setQuoteNum(String.valueOf(new BigDecimal(teamNum.getQuoteNum()).add(new BigDecimal(quTeamNum.getCount()))));
  154. teamNum.setHasInsuredNum(String.valueOf(new BigDecimal(teamNum.getHasInsuredNum()).add(new BigDecimal(quTeamNum.getCount()))));
  155. teamNum.setTaxaMountSum(String.valueOf(new BigDecimal(quTeamNum.getTaxaMountSum())));
  156. }
  157. if (quTeamNum.getOrderStatus().equals("2")) {
  158. teamNum.setSubmitNum(String.valueOf(new BigDecimal(teamNum.getSubmitNum()).add(new BigDecimal(quTeamNum.getCount()))));
  159. teamNum.setQuoteNum(String.valueOf(new BigDecimal(teamNum.getQuoteNum()).add(new BigDecimal(quTeamNum.getCount()))));
  160. }
  161. if (quTeamNum.getOrderStatus().equals("1")) {
  162. teamNum.setQuoteNum(String.valueOf(new BigDecimal(teamNum.getQuoteNum()).add(new BigDecimal(quTeamNum.getCount()))));
  163. teamNum.setSubmitNum(String.valueOf(new BigDecimal(teamNum.getSubmitNum()).add(new BigDecimal(quTeamNum.getCount()))));
  164. }
  165. }
  166. });
  167. }
  168. if (flag == 1) {
  169. teamNum.setDeptId(v.get(0).getDeptId());
  170. teamNum.setDeptName(v.get(0).getDeptName());
  171. } else if (flag == 2) {
  172. teamNum.setUserId(v.get(0).getUserId());
  173. teamNum.setUserName(v.get(0).getUserName());
  174. }
  175. quTeamNums.add(teamNum);
  176. });
  177. List<QuTeamNum> collect1 =
  178. quTeamNums.stream().skip((quTeamNumDto.getPageNo() - 1) * quTeamNumDto.getPageSize()).limit(quTeamNumDto.getPageSize()).
  179. collect(Collectors.toList());
  180. IPage<QuTeamNum> page = new Page<>(quTeamNumDto.getPageNo(), quTeamNumDto.getPageSize());
  181. page.setRecords(collect1);
  182. page.setTotal(quTeamNums.size());
  183. return page;
  184. }
  185. @Override
  186. public SysUser findByUsername(String username) {
  187. SysUser sysUser = null;
  188. if (StringUtils.isNotEmpty(username)) {
  189. sysUser = getById(username);
  190. }
  191. return sysUser;
  192. }
  193. @Override
  194. public SysUser findByPhone(String phone) {
  195. SysUser sysUser = null;
  196. LambdaQueryWrapper<SysUser> lqw = new LambdaQueryWrapper<>();
  197. lqw.eq(StringUtils.isNotEmpty(phone), SysUser::getMobile, phone);
  198. List<SysUser> lst = list(lqw);
  199. if (lst.size() > 0) {
  200. sysUser = lst.get(0);
  201. }
  202. return sysUser;
  203. }
  204. @Override
  205. public Set<String> findPermissions(SysUser sysUser) {
  206. Set<String> perms = new HashSet<>();
  207. String sql = "";
  208. List<String> lsPerms = null;
  209. if (sysUser.getId().equalsIgnoreCase("admin")) {
  210. LambdaQueryWrapper<SysMenu> lqw = new LambdaQueryWrapper<>();
  211. lqw.isNotNull(SysMenu::getPerms);
  212. lqw.select(SysMenu::getPerms);
  213. lsPerms = sysMenuService.listObjs(lqw, id -> id.toString());
  214. } else {
  215. List<SysMenu> sysMenuList = sysRoleMenuService.gainMenuIds(sysUser.getId());
  216. lsPerms =
  217. sysMenuList.stream().filter(a -> StringUtils.isNotEmpty(a.getPerms())).map(SysMenu::getPerms).collect(Collectors.toList());
  218. }
  219. if (lsPerms != null && lsPerms.size() > 0) {
  220. for (String perm : lsPerms) {
  221. if (!StringUtils.isNullOrEmpty(perm)) {
  222. perms.add(perm);
  223. }
  224. }
  225. }
  226. return perms;
  227. }
  228. // @Override
  229. // public Set<String> findPermissions(SysUser sysUser) {
  230. // Set<String> perms = new HashSet<>();
  231. // String sql = "";
  232. // JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
  233. // List<String> lsPerms = null;
  234. //
  235. // if (sysUser.getId().equalsIgnoreCase("admin")) {
  236. // sql = "SELECT perms FROM sys_menu WHERE perms IS NOT NULL AND perms <> ''";
  237. //
  238. // lsPerms = jdbcTemplate.queryForList(sql, String.class);
  239. // } else {
  240. // sql = "SELECT perms FROM sys_menu sm WHERE sm.id IN ( " +
  241. // "SELECT menu_id FROM sys_role_menu srm, sys_user_role sur ,sys_user su " +
  242. // "WHERE srm.role_id=sur.role_id " +
  243. // "AND sur.user_id=su.id AND su.id=?) " +
  244. // "AND perms IS NOT NULL AND perms <> ''"
  245. // ;
  246. //
  247. // lsPerms = jdbcTemplate.queryForList(sql, String.class, sysUser.getId());
  248. // }
  249. //
  250. // if (lsPerms != null && lsPerms.size() > 0) {
  251. // for (String perm : lsPerms) {
  252. // if (!StringUtils.isNullOrEmpty(perm)) {
  253. // perms.add(perm);
  254. // }
  255. // }
  256. // }
  257. //
  258. // return perms;
  259. // }
  260. @Override
  261. public List<SysUserRole> findUserRoles(Long userId) {
  262. return null;
  263. }
  264. @Override
  265. public PageResult selectPagingCustom(int pageNumber, int pageSize, String name, String deptCode) {
  266. return null;
  267. }
  268. /**
  269. * 获取用户列表
  270. *
  271. * @param page 分页信息
  272. * @param sysUser 查询条件
  273. * @param containsSubDept 是否汉堡下级机构
  274. * @return
  275. */
  276. @Override
  277. public IPage<SysUser> selectUserPage(Page page, SysUser sysUser, String containsSubDept) {
  278. IPage<SysUser> sysUserIPage = baseMapper.selectUserPage(page, sysUser, containsSubDept);
  279. List<SysUser> records = sysUserIPage.getRecords();
  280. if (records != null && records.size() > 0) {
  281. List<String> ids = records.stream().map(SysUser::getId).collect(Collectors.toList());
  282. LambdaQueryWrapper<SysUserTreeShowLevel> wrapper = new LambdaQueryWrapper<>();
  283. wrapper.in(SysUserTreeShowLevel::getUserId, ids);
  284. List<SysUserTreeShowLevel> list = sysUserTreeShowLevelService.list(wrapper);
  285. for (SysUser record : records) {
  286. for (SysUserTreeShowLevel showLevel : list) {
  287. if (record.getId().equals(showLevel.getUserId())) {
  288. record.setShowLevel(showLevel.getShowLevel());
  289. }
  290. }
  291. }
  292. LambdaQueryWrapper<SysUserIsDial> isWrapper = new LambdaQueryWrapper<>();
  293. isWrapper.in(SysUserIsDial::getUserId, ids);
  294. List<SysUserIsDial> isDialList = sysUserIsDialService.list(isWrapper);
  295. for (SysUser record : records) {
  296. for (SysUserIsDial isDial : isDialList) {
  297. if (record.getId().equals(isDial.getUserId())) {
  298. record.setIsDial(isDial.getIsDial());
  299. record.setDialUserName(isDial.getDialUserName());
  300. record.setDialPassWord(isDial.getDialPassWord());
  301. }
  302. }
  303. }
  304. }
  305. return sysUserIPage;
  306. }
  307. @Override
  308. public void findSysUseresmUserInternalVORoles(PageResult pageResult) {
  309. }
  310. @Override
  311. public Integer deleteFlag(List<SysUser> lsSysUser) {
  312. List<String> ids = lsSysUser.stream().map(SysUser::getId).collect(Collectors.toList());
  313. LambdaUpdateWrapper<SysUser> lqw = new LambdaUpdateWrapper<>();
  314. lqw.set(SysUser::getStatus, "0");
  315. lqw.in(SysUser::getId, ids);
  316. return update(lqw) == true ? ids.size() : 0;
  317. }
  318. @Override
  319. public SysUser findById(String id) {
  320. if (!StringUtils.isNullOrEmpty(id)) {
  321. return getById(id);
  322. }
  323. return null;
  324. }
  325. @Override
  326. public SysUser findByUserId(String userId) {
  327. SysUser sysUser = null;
  328. if (!StringUtils.isNullOrEmpty(userId)) {
  329. sysUser = getById(userId);
  330. }
  331. return sysUser;
  332. }
  333. @Override
  334. public SysUserVO gainUserInternal(String userId) {
  335. return super.baseMapper.gainInternalUser(userId);
  336. }
  337. @Override
  338. public SysUserVO gainUserInternalByDeptId(String deptId) {
  339. return super.baseMapper.gainInternalUserByDeptId(deptId);
  340. }
  341. @Override
  342. public List<SysUserVO> findByReferrerId(String deptId) {
  343. return super.baseMapper.findByReferrerId(deptId);
  344. }
  345. @Override
  346. public List<SysUserVO> findListByDeptId(SysUser sysUser) {
  347. return super.baseMapper.findListByDeptId(sysUser);
  348. }
  349. @Override
  350. public PageVo gainUserPage(PageDto pageDto) {
  351. PageVo<SysUserBaseVO> pageVo = new PageVo();
  352. Page page = new Page(pageDto.getPageNum(), pageDto.getPageSize());
  353. pageVo.setPageNum(pageDto.getPageNum());
  354. pageVo.setPageSize(pageDto.getPageSize());
  355. SysUserDto sysUserVO = JSONObject.parseObject(JSONObject.toJSONString(pageDto.getDto()), SysUserDto.class);
  356. Page<SysUserBaseVO> sysUserBaseVOIPage = super.baseMapper.gainUserBaseInfo(page, sysUserVO);
  357. pageVo.setContent(sysUserBaseVOIPage.getRecords());
  358. pageVo.setTotalPages((int) sysUserBaseVOIPage.getPages());
  359. pageVo.setTotalSize((int) sysUserBaseVOIPage.getTotal());
  360. return pageVo;
  361. }
  362. @Override
  363. public String gainNextUserId(String deptId) {
  364. int noCount = 3;//顺序号是几位的
  365. String nextPK;
  366. QueryWrapper<SysUser> lq = new QueryWrapper<>();
  367. lq.select(" MAX(id) as id ");
  368. lq.eq("dept_id", deptId);
  369. // lq.likeRight("id", deptId);
  370. SysUser userMaxId = getOne(lq);
  371. String maxId = "";
  372. if (null != userMaxId) maxId = userMaxId.getId();
  373. if (StringUtils.isNullOrEmpty(maxId)) {
  374. nextPK = deptId + "001";
  375. } else {
  376. nextPK = IdGenerate.nextCode(maxId, noCount);
  377. }
  378. return nextPK;
  379. }
  380. @Override
  381. public SysUserInternalVO gainUserSynthesisInfo(String userId) {
  382. SysUserInternalVO vo = new SysUserInternalVO();
  383. SysUser sysUser = getById(userId);
  384. // EsmUserInternal sysUserInternal = esmUserInternalService.selectByPk(userId);
  385. String pDeptId = sysUser.getDeptId();
  386. if (pDeptId.indexOf("D") > 1) {
  387. pDeptId = sysUser.getDeptId().substring(0, pDeptId.indexOf("D"));
  388. }
  389. SysDept sysDept = sysDeptService.getById(pDeptId);
  390. vo.setSysUser(sysUser);
  391. vo.setSysDept(sysDept);
  392. // vo.setSysUserInternal(sysUserInternal);
  393. return vo;
  394. }
  395. @Override
  396. public String findMaxId(String deptId) {
  397. QueryWrapper<SysUser> qw = new QueryWrapper<>();
  398. qw.select("IFNULL(MAX(id),0) maxId");
  399. qw.eq("dept_id", deptId);
  400. Map<String, Object> m = getMap(qw);
  401. String maxId = m.get("maxId").toString();
  402. return maxId;
  403. }
  404. @Override
  405. public boolean check(String userId, Integer approvalStatus, String approvalOpinion) {
  406. SysUser user = getById(userId);
  407. // user.setApprovalStatus(approvalStatus);
  408. user.setApprovalOpinion(approvalOpinion);
  409. return updateById(user);
  410. }
  411. @Override
  412. public SysUserBaseVO selectUserById(String userId) {
  413. return sysUserMapper.selectUserById(userId);
  414. }
  415. @Override
  416. @Transactional
  417. public boolean saveUser(SysUser sysUser) {
  418. // 判断用户id是否存在
  419. if (StringUtils.isNullOrEmpty(sysUser.getId())) {
  420. sysUser.setId(gainNextUserId(sysUser.getDeptId()));
  421. sysUser.setMobile(sysUser.getMobile());
  422. }
  423. // 角色信息
  424. SysUserRole sur = new SysUserRole();
  425. sur.setUserId(sysUser.getId());
  426. sur.setRoleId(StringUtils.toLong(sysUser.getRoleId()));
  427. // 删除角色
  428. sysUserRoleService.deleteByUserId(sysUser.getId());
  429. // 删除推荐人
  430. esmUserReferrerService.deldeleteByReferrerId(sysUser.getId());
  431. // 构建推荐人信息
  432. EsmUserReferrer eur = new EsmUserReferrer();
  433. eur.setId(sysUser.getId());
  434. eur.setReferrerId(sysUser.getReferrerId());//推荐人
  435. eur.setReferrerName(sysUser.getReferrerName());
  436. // 新增或跟新用户表
  437. save(sysUser);
  438. // 保存推荐人
  439. esmUserReferrerService.save(eur);
  440. // 保存角色
  441. sysUserRoleService.save(sur);
  442. return true;
  443. }
  444. @Override
  445. @Transactional
  446. public HttpResult saveUserInfo(SysUser2Vo sysUserVo) {
  447. SysUser sysUser = sysUserVo.getSysUser();
  448. // 手机号
  449. List<SysUser> mobileList = lambdaQuery().eq(SysUser::getMobile, sysUser.getMobile()).list();
  450. if (!mobileList.isEmpty()) {
  451. throw new SystemException("手机号已经注册请跟换手机号。");
  452. }
  453. // 身份证号
  454. List<SysUser> identityList = lambdaQuery().eq(SysUser::getIdentity, sysUser.getIdentity()).list();
  455. if (!identityList.isEmpty()) {
  456. throw new SystemException("身份证号已经注册请跟换身份证号。");
  457. }
  458. //处理密码
  459. if (StringUtils.isNotEmpty(sysUser.getPassword())) {
  460. String salt = PasswordUtils.getSalt();
  461. String pwd = PasswordUtils.encode(sysUser.getPassword(), salt);
  462. sysUser.setPassword(pwd);
  463. sysUser.setSalt(salt);
  464. } else {
  465. return HttpResult.error("密码不能为空");
  466. }
  467. if ("19".equals(sysUser.getRoleId())) {//19 出单员 校验机构和业务员机构是否一致
  468. return checkChuDanUser(sysUser);
  469. }
  470. String userId = gainNextUserId(sysUser.getDeptId());
  471. if (RoleConstants.R22.getCode().equals(sysUser.getRoleId())) {//22 后线人员
  472. if (!SysConstants.isAdministration(userId)) {
  473. throw new SystemException("后线人员只能公司部门中");
  474. }
  475. }
  476. sysUser.setId(userId);
  477. save(sysUser);
  478. //角色配置
  479. SysUserRole userRole = new SysUserRole();
  480. userRole.setUserId(sysUser.getId());
  481. userRole.setRoleId(StringUtils.toLong(sysUser.getRoleId()));
  482. sysUserRoleService.save(userRole);
  483. if (StringUtils.isNotEmpty(sysUser.getReferrerId())) {
  484. //推荐人
  485. esmUserReferrerService.addReferrer(sysUser.getReferrerId(), userId);
  486. } else if ("20".equals(sysUser.getRoleId()) || "21".equals(sysUser.getRoleId())) {
  487. //如果是 团队长或代码人 并且没有推荐人 则默认推荐人为自己
  488. esmUserReferrerService.addReferrer(sysUser.getId(), userId);
  489. }
  490. // EsmUserReferrer eur = new EsmUserReferrer();
  491. // eur.setId(sysUser.getId());
  492. // eur.setReferrerName(sysUser.getReferrerName());
  493. // eur.setReferrerId(sysUser.getReferrerId());
  494. // eur.setLevel(1);
  495. //
  496. // esmUserReferrerService.save(eur);
  497. SysUserInfo userInfo = sysUserVo.getSysUserInfo();
  498. if (userInfo != null) {
  499. userInfo.setId(sysUser.getId());
  500. }
  501. // userInfo.setId(sysUser.getId());
  502. sysUserInfoService.save(userInfo);
  503. List<EsmUserImageVo> esmUserImageVo = sysUserVo.getEsmUserImageVo();
  504. List<EsmUserImage> esmUserImages = esmUserImageVo.stream().map(x -> new EsmUserImage(x, userId)).collect(Collectors.toList());
  505. esmUserImageService.saveBatch(esmUserImages);
  506. return HttpResult.ok("新增成功");
  507. }
  508. /**
  509. * 新增修改出单员
  510. *
  511. * @param sysUser
  512. * @return
  513. */
  514. HttpResult checkChuDanUser(SysUser sysUser) {
  515. if (StringUtils.isEmpty(sysUser.getReferrerId())) {
  516. return HttpResult.error("业务员工号不能为空");
  517. }
  518. //归属业务员和出单员部门必须一致
  519. SysUser user = getById(sysUser.getReferrerId());
  520. if (user == null || !user.getDeptId().equals(sysUser.getDeptId())) {
  521. return HttpResult.error("出单员机构必须和归属业务员机构一致");
  522. }
  523. sysUser.setOperatorCode(sysUser.getReferrerId());
  524. if (StringUtils.isEmpty(sysUser.getId())) {
  525. String userId = gainNextUserId(sysUser.getDeptId());
  526. sysUser.setId(userId);
  527. save(sysUser);
  528. //角色配置
  529. SysUserRole userRole = new SysUserRole();
  530. userRole.setUserId(sysUser.getId());
  531. userRole.setRoleId(StringUtils.toLong(sysUser.getRoleId()));
  532. sysUserRoleService.save(userRole);
  533. } else {
  534. updateById(sysUser);
  535. }
  536. return HttpResult.ok("操作成功");
  537. }
  538. @Override
  539. @Transactional
  540. public HttpResult updateUserInfo(String userId, SysUser2Vo sysUserVo) {
  541. SysUser sysUser = sysUserVo.getSysUser();
  542. //修改用户不能修改密码
  543. if (StringUtils.isNotEmpty(sysUser.getPassword())) {
  544. String salt = PasswordUtils.getSalt();
  545. String pwd = PasswordUtils.encode(sysUser.getPassword(), salt);
  546. sysUser.setPassword(pwd);
  547. sysUser.setSalt(salt);
  548. } else {
  549. return HttpResult.error("密码不能为空");
  550. }
  551. //删除状态必须有离司时间
  552. if (StringUtils.isNotEmpty(sysUser.getStatus().toString())) {
  553. if (sysUser.getStatus() == 0 && sysUser.getLogoutTime() == null && !sysUser.getRoleId().equals("19")) {
  554. return HttpResult.error("删除状态,离职时间必填");
  555. }
  556. } else {
  557. return HttpResult.error("状态不能为空");
  558. }
  559. SysUser sysUser_org = findByUserId(sysUser.getId());
  560. sysUser.setPassword(sysUser_org.getPassword());
  561. sysUser.setSalt(sysUser_org.getSalt());
  562. if ("19".equals(sysUser.getRoleId())) {//19 出单员 校验机构和业务员机构是否一致
  563. return checkChuDanUser(sysUser);
  564. }
  565. updateById(sysUser);
  566. //角色配置
  567. SysUserRole sysUserRole = sysUserRoleService.selectByUserId(userId);
  568. sysUserRole.setRoleId(StringUtils.toLong(sysUser.getRoleId()));
  569. sysUserRole.setLastUpdateBy(sysUser.getCreateBy());
  570. sysUserRole.setLastUpdateTime(new Date());
  571. sysUserRoleService.updateById(sysUserRole);
  572. if (StringUtils.isNotEmpty(sysUser.getReferrerId())) {
  573. //推荐人
  574. esmUserReferrerService.addReferrer(sysUser.getReferrerId(), userId);
  575. }
  576. //用户详情信息
  577. SysUserInfo sysUserInfo = sysUserVo.getSysUserInfo();
  578. sysUserInfo.setId(userId);
  579. if (null == sysUserInfo.getRemark()) {
  580. sysUserInfo.setRemark("");
  581. }
  582. sysUserInfoService.saveOrUpdate(sysUserInfo);
  583. // 影像资料
  584. LambdaQueryWrapper<EsmUserImage> wrapper = new LambdaQueryWrapper<>();
  585. wrapper.eq(EsmUserImage::getUserId, userId);
  586. esmUserImageService.remove(wrapper);
  587. List<EsmUserImageVo> esmUserImageVo = sysUserVo.getEsmUserImageVo();
  588. List<EsmUserImage> esmUserImages = esmUserImageVo.stream().map(x -> new EsmUserImage(x, userId)).collect(Collectors.toList());
  589. esmUserImageService.saveBatch(esmUserImages);
  590. return HttpResult.ok("修改成功");
  591. }
  592. @Override
  593. public List<SysUser> findAllAgentRoleUser(String userId, String roleId) {
  594. return super.baseMapper.findAllAgentRoleUser(userId, roleId);
  595. }
  596. @Override
  597. public int getDeptLevel(SysUser2Vo sysUser2Vo) {
  598. //获取机构层级
  599. SysUser sysUser = sysUser2Vo.getSysUser();
  600. String deptId = sysUser.getDeptId();
  601. int level = 0;
  602. //1 2 3 4 5级 M 6级 D
  603. if (deptId.length() > 8) {
  604. String substring = deptId.substring(8);
  605. return substring.length() / 3 + 4;
  606. } else {
  607. level = deptId.length() / 2;
  608. }
  609. return level;
  610. }
  611. /**
  612. * 根据机构代码,查询所有人员
  613. *
  614. * @param deptId
  615. * @return
  616. */
  617. @Override
  618. public List<SysUser> findUserList(String deptId) {
  619. LambdaQueryWrapper<SysUser> lqw = new LambdaQueryWrapper<>();
  620. lqw.eq(SysUser::getStatus, "1");
  621. lqw.eq(SysUser::getDeptId, deptId);
  622. return list(lqw);
  623. }
  624. /**
  625. * 查找组织结构树,返回所有层级的用户列表,其中每个用户包含其直接下级用户。
  626. * 该方法首先根据当前用户获取其在组织结构展示中的级别,然后根据这个级别查询或构建相应的组织结构树。
  627. *
  628. * @return 返回组织结构树形式的用户列表,每个用户对象可能包含一个子用户列表。
  629. */
  630. @Override
  631. public List<SysUser> findTree() {
  632. // 获取当前登录用户
  633. SysUser user = BaseController.getUser();
  634. String userId = user.getId();
  635. // 根据当前用户ID查询其在组织结构展示中的级别
  636. LambdaQueryWrapper<SysUserTreeShowLevel> lambdaQueryWrapper = new LambdaQueryWrapper<>();
  637. lambdaQueryWrapper.eq(SysUserTreeShowLevel::getUserId, userId);
  638. SysUserTreeShowLevel treeShowLevel = sysUserTreeShowLevelService.getOne(lambdaQueryWrapper);
  639. //如果当前用户未配置树展示等级,则默认为查询本级及以下
  640. if (Objects.isNull(treeShowLevel)) {
  641. treeShowLevel = new SysUserTreeShowLevel();
  642. treeShowLevel.setShowLevel("subordinate");
  643. }
  644. //获取领导字段不为空的人的ID
  645. List<SysUser> users = lambdaQuery().isNotNull(SysUser::getLeaderId).list();
  646. if (users == null || users.size() == 0) {
  647. return new ArrayList<>();
  648. }
  649. List<SysUser> topUsers = new ArrayList<>(); //存放1级用户,即没有直接上级的用户
  650. // 获取可能作为顶层节点的用户ID列表
  651. List<String> topUserId = users.stream().map(SysUser::getLeaderId).collect(Collectors.toList());
  652. List<SysUser> list2 = lambdaQuery().in(SysUser::getId, topUserId).list();
  653. List<String> strings = list2.stream().map(SysUser::getId).collect(Collectors.toList());
  654. // 根据组织结构展示级别,筛选顶层节点并构建组织结构树
  655. switch (treeShowLevel.getShowLevel()) {
  656. case "all": // 展示所有级别的用户
  657. // 从查询结果中筛选出没有上级的人员,作为组织结构树的顶层节点
  658. for (SysUser sysUser : list2) {
  659. if (Objects.isNull(sysUser.getLeaderId())) {
  660. topUsers.add(sysUser);
  661. }
  662. }
  663. // 递归构建用户树结构
  664. buildUserTree(topUsers, users);
  665. break;
  666. case "same": // 只展示当前用户
  667. // for (String ids : strings) {
  668. // if (ids.equals(userId)) {
  669. topUsers.add(user);
  670. // }
  671. // }
  672. break;
  673. case "subordinate": // 只展示当前用户及下属
  674. // for (String ids : strings) {
  675. // if (ids.equals(userId)) {
  676. topUsers.add(user);
  677. // }
  678. // }
  679. // 递归构建用户树结构
  680. buildUserTree(topUsers, users);
  681. break;
  682. }
  683. return topUsers;
  684. }
  685. /**
  686. * 根据部门ID查询后台用户列表。
  687. *
  688. * @param deptId 部门ID,用于筛选指定部门的用户。
  689. * @return 返回一个SysUser类型的列表,包含指定部门的所有后台用户。
  690. */
  691. @Override
  692. public List<SysUser> findBackListByDeptId(String deptId) {
  693. return baseMapper.findBackListByDeptId(deptId);
  694. }
  695. /**
  696. * 查询用户订单数量进行区域统计信息
  697. *
  698. * @param quUserNumDto 包含查询条件和分页信息的数据传输对象
  699. * @return IPage<QuUserNum> 返回用户数量统计信息的分页对象
  700. */
  701. @Override
  702. public IPage<QuUserNum> quUserNum(QuUserNumDto quUserNumDto) {
  703. //获取所有用户
  704. List<SysUser> users = list();
  705. // 根据用户ID查询一级下屬
  706. LambdaQueryWrapper<SysUser> queryWrapper = new LambdaQueryWrapper<>();
  707. queryWrapper.eq(SysUser::getId, quUserNumDto.getUserId());
  708. List<SysUser> usersLevel1 = list(queryWrapper);
  709. //递归获取1级下属下所有的下属ID
  710. List<String> strIds = new ArrayList<>();
  711. findChildren(usersLevel1, users, strIds);
  712. // 根据区域编码和级别查询符合条件的区域
  713. LambdaQueryWrapper<SysArea> wrapper = new LambdaQueryWrapper<>();
  714. if (quUserNumDto.getAreaCode() != null && !"".equals(quUserNumDto.getAreaCode())) {
  715. String area = quUserNumDto.getAreaCode();
  716. switch (quUserNumDto.getLevel()) {
  717. case "1": { // 省级查询逻辑
  718. quUserNumDto.setGrouping(4);
  719. String prefix = area.substring(0, 2);
  720. strIds.removeIf(id -> !id.contains("99" + prefix));
  721. quUserNumDto.setLevel("2");
  722. wrapper.eq(SysArea::getLevel, "2");
  723. wrapper.likeRight(SysArea::getAreaCode, prefix);
  724. break;
  725. }
  726. case "2": { // 市级查询逻辑
  727. quUserNumDto.setGrouping(6);
  728. String prefix = area.substring(0, 4);
  729. strIds.removeIf(id -> !id.contains("99" + prefix));
  730. quUserNumDto.setLevel("3");
  731. wrapper.eq(SysArea::getLevel, "3");
  732. wrapper.likeRight(SysArea::getAreaCode, prefix);
  733. break;
  734. }
  735. case "3": { // 区县级查询逻辑
  736. quUserNumDto.setGrouping(6);
  737. String prefix = area.substring(0, 6);
  738. strIds.removeIf(id -> !id.contains("99" + prefix));
  739. quUserNumDto.setLevel("3");
  740. wrapper.eq(SysArea::getLevel, "3");
  741. wrapper.likeRight(SysArea::getAreaCode, prefix);
  742. break;
  743. }
  744. }
  745. } else { // 默认查询省级区域
  746. quUserNumDto.setGrouping(2);
  747. quUserNumDto.setLevel("1");
  748. wrapper.eq(SysArea::getLevel, "1");
  749. }
  750. //遍历匹配区域名称
  751. List<SysArea> areaList = sysAreaService.list(wrapper);
  752. List<QuUserNum> quUserNums = new ArrayList<>();
  753. // 如果没有查询到用户ID,则直接返回空的分页对象
  754. if (strIds.size() != 0) {
  755. // 根据查询条件获取用户数量统计信息
  756. quUserNumDto.setUserIds(strIds);
  757. List<QuUserNum> userNums = sysUserMapper.getUserNum(quUserNumDto);
  758. // 获取地区主订单待核保订单数量
  759. List<QuUserNum> mainWaitAuditSums = sysUserMapper.getMainWaitAuditSum(quUserNumDto);
  760. // 获取地区主订单已核保待缴费订单数量
  761. List<QuUserNum> mainWaitPaySums = sysUserMapper.getMainWaitPaySum(quUserNumDto);
  762. // 获取地区主订单已承包订单数量
  763. List<QuUserNum> mainAcceptInsuranceSums = sysUserMapper.getMainAcceptInsuranceSum(quUserNumDto);
  764. // 根据区域名称匹配用户数量统计信息,并构造最终返回的结果列表
  765. for (QuUserNum quUserNum : userNums) {
  766. for (SysArea sysArea : areaList) {
  767. if (!Objects.isNull(sysArea.getAreaCode())) {
  768. // 匹配区域名称
  769. String substring = sysArea.getAreaCode().substring(0, quUserNumDto.getGrouping());
  770. if (quUserNum.getAreaCode().equals(substring)) {
  771. quUserNum.setAreaName(sysArea.getAreaCname());
  772. }
  773. }
  774. }
  775. for (QuUserNum mainWaitAuditSum : mainWaitAuditSums) {
  776. if (quUserNum.getAreaCode().equals(mainWaitAuditSum.getAreaCode())) {
  777. quUserNum.setMainWaitAuditSum(mainWaitAuditSum.getMainWaitAuditSum());
  778. }
  779. }
  780. for (QuUserNum mainWaitPaySum : mainWaitPaySums) {
  781. if (quUserNum.getAreaCode().equals(mainWaitPaySum.getAreaCode())) {
  782. quUserNum.setMainWaitPaySum(mainWaitPaySum.getMainWaitPaySum());
  783. }
  784. }
  785. for (QuUserNum mainAcceptInsuranceSum : mainAcceptInsuranceSums) {
  786. if (quUserNum.getAreaCode().equals(mainAcceptInsuranceSum.getAreaCode())) {
  787. quUserNum.setMainAcceptInsuranceSum(mainAcceptInsuranceSum.getMainAcceptInsuranceSum());
  788. }
  789. }
  790. if (quUserNum.getAreaName() != null){
  791. quUserNums.add(quUserNum);
  792. }
  793. // quUserNums.add(quUserNum);
  794. }
  795. }
  796. // 为每个区域生成未匹配到的统计信息
  797. for (SysArea sysArea : areaList) {
  798. if (exists(quUserNums, sysArea)) {
  799. QuUserNum userNum = new QuUserNum();
  800. // 设置未匹配到的区域的默认统计信
  801. userNum.setAreaName(sysArea.getAreaCname());
  802. quUserNums.add(userNum);
  803. }
  804. }
  805. List<QuUserNum> paginate = paginate(quUserNums, quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  806. // 构造返回的分页对象
  807. IPage<QuUserNum> recordsPage = new Page<>(quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  808. recordsPage.setRecords(paginate);
  809. recordsPage.setTotal(quUserNums.size());
  810. return recordsPage;
  811. }
  812. /**
  813. * 查询用户订单数量进行区域统计详细信息
  814. *
  815. * @param quUserNumDto 包含查询条件和分页信息的数据传输对象
  816. * @return IPage<QuUserNum> 返回用户数量统计信息的分页对象
  817. */
  818. @Override
  819. public IPage<QuUserNum> getQuUserByCompany(QuUserNumDto quUserNumDto) {
  820. //查询单个用户的详情时不需要区域code
  821. if (!quUserNumDto.getQuMarks().equals(QuMarks.USER_COMPANY_MARK.getCode())) {
  822. // 获取系统中的所有用户
  823. List<SysUser> users = list();
  824. // 创建查询包装器,用于查询指定用户ID的用
  825. LambdaQueryWrapper<SysUser> queryWrapper = new LambdaQueryWrapper<>();
  826. queryWrapper.eq(SysUser::getId, quUserNumDto.getUserId());
  827. // 查询指定用户ID的用户,即第一级下属
  828. List<SysUser> usersLevel1 = list(queryWrapper);
  829. // 用于存储所有下属的ID
  830. List<String> strIds = new ArrayList<>();
  831. // 递归获取第一级下属及其所有下属的ID
  832. findChildren(usersLevel1, users, strIds);
  833. // 如果未指定区域码,返回空分页对
  834. if (Objects.isNull(quUserNumDto.getAreaCode())) {
  835. return new Page<>();
  836. }
  837. // 根据区域码筛选有效的下属ID
  838. strIds.removeIf(id -> !id.contains("99" + quUserNumDto.getAreaCode()));
  839. // 如果筛选后没有有效的下属ID,返回空分页对象
  840. if (strIds.size() == 0) {
  841. return new Page<>();
  842. }
  843. // 设置查询条件中的用户ID列表
  844. quUserNumDto.setUserIds(strIds);
  845. } else {
  846. // 设置查询条件中的用户ID列表
  847. quUserNumDto.setUserIds(Collections.singletonList(quUserNumDto.getUserId()));
  848. }
  849. List<QuUserNum> deptByCompany = agentOrChannelByMark(quUserNumDto);
  850. List<QuUserNum> paginate = paginate(deptByCompany, quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  851. // 创建并设置分页信息
  852. IPage<QuUserNum> page = new Page<>(quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  853. page.setRecords(paginate);
  854. page.setTotal(deptByCompany.size());
  855. return page;
  856. }
  857. /**
  858. * 手动对 QuUserNum 列表进行分页
  859. *
  860. * @param quUserNums 原始 QuUserNum 数据列表
  861. * @param pageNum 期望获取的页码(从 1 开始)
  862. * @param pageSize 每页包含的 QuUserNum 数量
  863. * @return 对应页码的 QuUserNum 子列表,若输入参数无效则返回空列表
  864. */
  865. public List<QuUserNum> paginate(List<QuUserNum> quUserNums, int pageNum, int pageSize) {
  866. if (quUserNums == null || quUserNums.isEmpty() || pageNum < 1 || pageSize < 1) {
  867. return Collections.emptyList();
  868. }
  869. int startIndex = (pageNum - 1) * pageSize;
  870. int endIndex = Math.min(startIndex + pageSize, quUserNums.size());
  871. return quUserNums.subList(startIndex, endIndex);
  872. }
  873. private void findChildren(List<SysUser> SysUsers, List<SysUser> users, List<String> strIds) {
  874. for (SysUser sysUser : SysUsers) {
  875. List<SysUser> children = new ArrayList<>();
  876. for (SysUser user : users) {
  877. if (sysUser.getId() != null && sysUser.getId().equals(user.getLeaderId())) {
  878. if (!exists(children, user)) {
  879. children.add(user);
  880. strIds.add(user.getId());
  881. }
  882. }
  883. }
  884. sysUser.setChildren(children);
  885. // children.sort((o1, o2) -> o1.getOrderNum().compareTo(o2.getOrderNum()));
  886. findChildren(children, users, strIds);
  887. }
  888. }
  889. private boolean exists(List<QuUserNum> quUserNums, SysArea sysArea) {
  890. boolean exist = true;
  891. for (QuUserNum quUserNum1 : quUserNums) {
  892. if (sysArea.getAreaCname().equals(quUserNum1.getAreaName())) {
  893. exist = false;
  894. break;
  895. }
  896. }
  897. return exist;
  898. }
  899. private boolean exists(List<SysUser> sysUsers, SysUser sysUser) {
  900. boolean exist = false;
  901. for (SysUser user : sysUsers) {
  902. if (user.getId().equals(sysUser.getId())) {
  903. exist = true;
  904. }
  905. }
  906. return exist;
  907. }
  908. private void buildUserTree(List<SysUser> topUsers, List<SysUser> users) {
  909. for (SysUser user : topUsers) {
  910. List<SysUser> children = new ArrayList<>();
  911. for (SysUser childUser : users) {
  912. if (user.getId().equals(childUser.getLeaderId()) && !childUser.getId().contains("M")) {
  913. children.add(childUser);
  914. // 递归查找下一级
  915. buildUserTree(children, users);
  916. }
  917. }
  918. user.setChildren(children);
  919. }
  920. }
  921. /**
  922. * @version
  923. * @author: hxl
  924. * @Date: 2024/4/16 15:51
  925. * @Description: 获取待客录入的可选业务员
  926. * 查询
  927. */
  928. @Override
  929. public List<SysUserBaseVO> getAllUsersByHospitality(SysUserVOExt sysUserVOExt) {
  930. if (StringUtils.isNotEmpty(sysUserVOExt.getUserId()) || StringUtils.isNotEmpty(sysUserVOExt.getIdentity()) ||
  931. StringUtils.isNotEmpty(sysUserVOExt.getMobile()) || StringUtils.isNotEmpty(sysUserVOExt.getName())) {
  932. return super.baseMapper.getAllUsersByHospitality(sysUserVOExt);
  933. }
  934. return new ArrayList<SysUserBaseVO>();
  935. }
  936. /**
  937. * @version
  938. * @author: hxl
  939. * @Date: 2024/4/18 16:14
  940. * @Description: 获取客服人员列表数据
  941. */
  942. @Override
  943. public List<SysUserBaseVO> getCustomerUsers() {
  944. return super.baseMapper.getCustomerUsers(new SysUserVOExt());
  945. }
  946. @Override
  947. public IPage<QuUserNum> quAgentAreaAdmin(QuUserNumDto quUserNumDto) {
  948. //获取所有代理人用户
  949. List<SysUserBaseVO> agentUsers = baseMapper.getAgentUserIdsByAreaIds();
  950. List<String> strIds = agentUsers.stream().map(SysUserBaseVO::getUserId).collect(Collectors.toList());
  951. // 根据区域编码和级别查询符合条件的区域
  952. LambdaQueryWrapper<SysArea> wrapper = new LambdaQueryWrapper<>();
  953. if (strIds.size() != 0) {
  954. if (quUserNumDto.getAreaCode() != null && !"".equals(quUserNumDto.getAreaCode())) {
  955. String area = quUserNumDto.getAreaCode();
  956. switch (quUserNumDto.getLevel()) {
  957. case "1": { // 省级查询逻辑
  958. quUserNumDto.setGrouping(4);
  959. String prefix = area.substring(0, 2);
  960. strIds.removeIf(id -> !id.contains("99" + prefix));
  961. quUserNumDto.setLevel("2");
  962. wrapper.eq(SysArea::getLevel, "2");
  963. wrapper.likeRight(SysArea::getAreaCode, prefix);
  964. break;
  965. }
  966. case "2": { // 市级查询逻辑
  967. quUserNumDto.setGrouping(6);
  968. String prefix = area.substring(0, 4);
  969. strIds.removeIf(id -> !id.contains("99" + prefix));
  970. quUserNumDto.setLevel("3");
  971. wrapper.eq(SysArea::getLevel, "3");
  972. wrapper.likeRight(SysArea::getAreaCode, prefix);
  973. break;
  974. }
  975. case "3": { // 区县级查询逻辑
  976. quUserNumDto.setGrouping(6);
  977. String prefix = area.substring(0, 6);
  978. strIds.removeIf(id -> !id.contains("99" + prefix));
  979. quUserNumDto.setLevel("3");
  980. wrapper.eq(SysArea::getLevel, "3");
  981. wrapper.likeRight(SysArea::getAreaCode, prefix);
  982. break;
  983. }
  984. }
  985. } else { // 默认查询省级区域
  986. quUserNumDto.setGrouping(2);
  987. quUserNumDto.setLevel("1");
  988. wrapper.eq(SysArea::getLevel, "1");
  989. }
  990. }
  991. //遍历匹配区域名称
  992. List<SysArea> areaList = sysAreaService.list(wrapper);
  993. List<QuUserNum> quUserNums = new ArrayList<>();
  994. // 如果没有查询到用户ID,则直接返回空的分页对象
  995. if (strIds.size() != 0) {
  996. // 根据查询条件获取用户数量统计信息
  997. quUserNumDto.setUserIds(strIds);
  998. List<QuUserNum> userNums = sysUserMapper.getUserNum(quUserNumDto);
  999. // 获取地区主订单待核保订单数量
  1000. List<QuUserNum> mainWaitAuditSums = sysUserMapper.getMainWaitAuditSum(quUserNumDto);
  1001. // 获取地区主订单已核保待缴费订单数量
  1002. List<QuUserNum> mainWaitPaySums = sysUserMapper.getMainWaitPaySum(quUserNumDto);
  1003. // 获取地区主订单已承包订单数量
  1004. List<QuUserNum> mainAcceptInsuranceSums = sysUserMapper.getMainAcceptInsuranceSum(quUserNumDto);
  1005. // 根据区域名称匹配用户数量统计信息,并构造最终返回的结果列表
  1006. for (QuUserNum quUserNum : userNums) {
  1007. for (SysArea sysArea : areaList) {
  1008. if (!Objects.isNull(sysArea.getAreaCode())) {
  1009. // 匹配区域名称
  1010. String substring = sysArea.getAreaCode().substring(0, quUserNumDto.getGrouping());
  1011. if (quUserNum.getAreaCode().equals(substring)) {
  1012. quUserNum.setAreaName(sysArea.getAreaCname());
  1013. }
  1014. }
  1015. }
  1016. for (QuUserNum mainWaitAuditSum : mainWaitAuditSums) {
  1017. if (quUserNum.getAreaCode().equals(mainWaitAuditSum.getAreaCode())) {
  1018. quUserNum.setMainWaitAuditSum(mainWaitAuditSum.getMainWaitAuditSum());
  1019. }
  1020. }
  1021. for (QuUserNum mainWaitPaySum : mainWaitPaySums) {
  1022. if (quUserNum.getAreaCode().equals(mainWaitPaySum.getAreaCode())) {
  1023. quUserNum.setMainWaitPaySum(mainWaitPaySum.getMainWaitPaySum());
  1024. }
  1025. }
  1026. for (QuUserNum mainAcceptInsuranceSum : mainAcceptInsuranceSums) {
  1027. if (quUserNum.getAreaCode().equals(mainAcceptInsuranceSum.getAreaCode())) {
  1028. quUserNum.setMainAcceptInsuranceSum(mainAcceptInsuranceSum.getMainAcceptInsuranceSum());
  1029. }
  1030. }
  1031. quUserNums.add(quUserNum);
  1032. }
  1033. }
  1034. // 为每个区域生成未匹配到的统计信息
  1035. for (SysArea sysArea : areaList) {
  1036. if (exists(quUserNums, sysArea)) {
  1037. QuUserNum userNum = new QuUserNum();
  1038. // 设置未匹配到的区域的默认统计信
  1039. userNum.setAreaName(sysArea.getAreaCname());
  1040. quUserNums.add(userNum);
  1041. }
  1042. }
  1043. List<QuUserNum> paginate = paginate(quUserNums, quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  1044. // 构造返回的分页对象
  1045. IPage<QuUserNum> recordsPage = new Page<>(quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  1046. recordsPage.setRecords(paginate);
  1047. recordsPage.setTotal(quUserNums.size());
  1048. return recordsPage;
  1049. }
  1050. @Override
  1051. public IPage<QuUserNum> quAgentAreaAdminDetail(QuUserNumDto quUserNumDto) {
  1052. //查询单个用户的详情时不需要区域code
  1053. if (!quUserNumDto.getQuMarks().equals(QuMarks.USER_COMPANY_MARK.getCode())) {
  1054. //获取所有代理人用户
  1055. List<SysUserBaseVO> agentUsers = baseMapper.getAgentUserIdsByAreaIds();
  1056. List<String> strIds = agentUsers.stream().map(SysUserBaseVO::getUserId).collect(Collectors.toList());
  1057. // 如果未指定区域码,返回空分页对
  1058. if (Objects.isNull(quUserNumDto.getAreaCode())) {
  1059. return new Page<>();
  1060. }
  1061. // 根据区域码筛选有效的下属ID
  1062. strIds.removeIf(id -> !id.contains("99" + quUserNumDto.getAreaCode()));
  1063. // 如果筛选后没有有效的下属ID,返回空分页对象
  1064. if (strIds.size() == 0) {
  1065. return new Page<>();
  1066. }
  1067. // 设置查询条件中的用户ID列表
  1068. quUserNumDto.setUserIds(strIds);
  1069. } else {
  1070. // 设置查询条件中的用户ID列表
  1071. quUserNumDto.setUserIds(Collections.singletonList(quUserNumDto.getUserId()));
  1072. }
  1073. List<QuUserNum> deptByCompany = agentOrChannelByMark(quUserNumDto);
  1074. List<QuUserNum> paginate = paginate(deptByCompany, quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  1075. // 创建并设置分页信息
  1076. IPage<QuUserNum> page = new Page<>(quUserNumDto.getPageNum(), quUserNumDto.getPageSize());
  1077. page.setRecords(paginate);
  1078. page.setTotal(deptByCompany.size());
  1079. return page;
  1080. }
  1081. public List<QuUserNum> agentOrChannelByMark(QuUserNumDto quUserNumDto) {
  1082. List<QuUserNum> deptByCompany = new ArrayList<>();
  1083. if (quUserNumDto.getQuMarks().equals(QuMarks.COMPANY_MARK.getCode())) {
  1084. // 根据公司和用户ID列表查询用户数量统计信息
  1085. deptByCompany = sysUserMapper.getUserByCompany(quUserNumDto);
  1086. // 获取公司主订单待核保订单数量
  1087. List<QuUserNum> mainWaitAuditSums = sysUserMapper.getComMainWaitAuditSum(quUserNumDto);
  1088. // 获取公司主订单已核保待缴费订单数量
  1089. List<QuUserNum> mainWaitPaySums = sysUserMapper.getComMainWaitPaySum(quUserNumDto);
  1090. // 获取公司主订单已承包订单数量
  1091. List<QuUserNum> mainAcceptInsuranceSums = sysUserMapper.getComMainAcceptInsuranceSum(quUserNumDto);
  1092. for (QuUserNum quUserNum : deptByCompany) {
  1093. for (QuUserNum mainWaitAuditSum : mainWaitAuditSums) {
  1094. if (quUserNum.getCompanyId().equals(mainWaitAuditSum.getCompanyId())) {
  1095. quUserNum.setMainWaitAuditSum(mainWaitAuditSum.getMainWaitAuditSum());
  1096. }
  1097. }
  1098. for (QuUserNum mainWaitPaySum : mainWaitPaySums) {
  1099. if (quUserNum.getCompanyId().equals(mainWaitPaySum.getCompanyId())) {
  1100. quUserNum.setMainWaitPaySum(mainWaitPaySum.getMainWaitPaySum());
  1101. }
  1102. }
  1103. for (QuUserNum mainAcceptInsuranceSum : mainAcceptInsuranceSums) {
  1104. if (quUserNum.getCompanyId().equals(mainAcceptInsuranceSum.getCompanyId())) {
  1105. quUserNum.setMainAcceptInsuranceSum(mainAcceptInsuranceSum.getMainAcceptInsuranceSum());
  1106. }
  1107. }
  1108. }
  1109. } else if (quUserNumDto.getQuMarks().equals(QuMarks.USER_MARK.getCode())) {
  1110. // 根据公司和用户ID列表查询用户数量统计信息
  1111. deptByCompany = sysUserMapper.getUserDetail(quUserNumDto);
  1112. // 获取用户主订单待核保订单数量
  1113. List<QuUserNum> mainWaitAuditSums = sysUserMapper.getUserMainWaitAuditSum(quUserNumDto);
  1114. // 获取用户主订单已核保待缴费订单数量
  1115. List<QuUserNum> mainWaitPaySums = sysUserMapper.getUserMainWaitPaySum(quUserNumDto);
  1116. // 获取用户主订单已承包订单数量
  1117. List<QuUserNum> mainAcceptInsuranceSums = sysUserMapper.getUserMainAcceptInsuranceSum(quUserNumDto);
  1118. for (QuUserNum quUserNum : deptByCompany) {
  1119. for (QuUserNum mainWaitAuditSum : mainWaitAuditSums) {
  1120. if (quUserNum.getUserId().equals(mainWaitAuditSum.getUserId())) {
  1121. quUserNum.setMainWaitAuditSum(mainWaitAuditSum.getMainWaitAuditSum());
  1122. }
  1123. }
  1124. for (QuUserNum mainWaitPaySum : mainWaitPaySums) {
  1125. if (quUserNum.getUserId().equals(mainWaitPaySum.getUserId())) {
  1126. quUserNum.setMainWaitPaySum(mainWaitPaySum.getMainWaitPaySum());
  1127. }
  1128. }
  1129. for (QuUserNum mainAcceptInsuranceSum : mainAcceptInsuranceSums) {
  1130. if (quUserNum.getUserId().equals(mainAcceptInsuranceSum.getUserId())) {
  1131. quUserNum.setMainAcceptInsuranceSum(mainAcceptInsuranceSum.getMainAcceptInsuranceSum());
  1132. }
  1133. }
  1134. }
  1135. } else if (quUserNumDto.getQuMarks().equals(QuMarks.USER_COMPANY_MARK.getCode())) {
  1136. // 根据公司和用户ID列表查询用户数量统计信息
  1137. deptByCompany = sysUserMapper.getUserByCompany(quUserNumDto);
  1138. // 获取公司主订单待核保订单数量
  1139. List<QuUserNum> mainWaitAuditSums = sysUserMapper.getComMainWaitAuditSum(quUserNumDto);
  1140. // 获取公司主订单已核保待缴费订单数量
  1141. List<QuUserNum> mainWaitPaySums = sysUserMapper.getComMainWaitPaySum(quUserNumDto);
  1142. // 获取公司主订单已承包订单数量
  1143. List<QuUserNum> mainAcceptInsuranceSums = sysUserMapper.getComMainAcceptInsuranceSum(quUserNumDto);
  1144. for (QuUserNum quUserNum : deptByCompany) {
  1145. for (QuUserNum mainWaitAuditSum : mainWaitAuditSums) {
  1146. if (quUserNum.getCompanyId().equals(mainWaitAuditSum.getCompanyId())) {
  1147. quUserNum.setMainWaitAuditSum(mainWaitAuditSum.getMainWaitAuditSum());
  1148. }
  1149. }
  1150. for (QuUserNum mainWaitPaySum : mainWaitPaySums) {
  1151. if (quUserNum.getCompanyId().equals(mainWaitPaySum.getCompanyId())) {
  1152. quUserNum.setMainWaitPaySum(mainWaitPaySum.getMainWaitPaySum());
  1153. }
  1154. }
  1155. for (QuUserNum mainAcceptInsuranceSum : mainAcceptInsuranceSums) {
  1156. if (quUserNum.getCompanyId().equals(mainAcceptInsuranceSum.getCompanyId())) {
  1157. quUserNum.setMainAcceptInsuranceSum(mainAcceptInsuranceSum.getMainAcceptInsuranceSum());
  1158. }
  1159. }
  1160. }
  1161. }
  1162. return deptByCompany;
  1163. }
  1164. /**
  1165. * @version
  1166. * @author: hxl
  1167. * @Date: 2024/4/29 16:01
  1168. * @Description: 查询当前登陆人管理的渠道人 即领导人为当前登陆人的用户需要递归查询
  1169. */
  1170. public List<String> getUserIdsByLeaderId(String userId) {
  1171. // 获取系统中的所有用户
  1172. LambdaQueryWrapper<SysUser> queryWrapper = new LambdaQueryWrapper<>();
  1173. queryWrapper.eq(SysUser::getStatus, 1);
  1174. List<SysUser> allUsers = this.getBaseMapper().selectList(queryWrapper);
  1175. // 查询指定用户ID管理的用户,即第一级下属
  1176. queryWrapper.eq(SysUser::getId, userId);
  1177. List<SysUser> leadUsers = this.getBaseMapper().selectList(queryWrapper);
  1178. // 用于存储所有下属的ID
  1179. List<String> strIds = new ArrayList<>();
  1180. // 递归获取第一级下属及其所有下属的ID
  1181. findChildren(leadUsers, allUsers, strIds);
  1182. return strIds;
  1183. }
  1184. /**
  1185. * @version
  1186. * @author: hxl
  1187. * @Date: 2024/5/7 10:45
  1188. * @Description: 通过部门id和角色id查询是否存在团队长
  1189. */
  1190. @Override
  1191. public int getCountByDeptAndRoleId(SysUser sysUserVo) {
  1192. return sysUserMapper.getCountByDeptAndRoleId(sysUserVo);
  1193. }
  1194. /**
  1195. * @version
  1196. * @author: hxl
  1197. * @Date: 2024/5/7 11:44
  1198. * @Description: 查询该部门的团队长
  1199. */
  1200. @Override
  1201. public String findTDZUserIdByDeptId(String deptId) {
  1202. return sysUserMapper.findTDZUserIdByDeptId(deptId);
  1203. }
  1204. }