package com.platform.service.impl; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.map.MapUtil; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.github.pagehelper.PageHelper; import com.google.common.collect.Lists; import com.google.common.collect.Maps; import com.google.common.collect.Sets; import com.platform.exception.BusinessException; import com.platform.mapper.UserMapper; import com.platform.model.dto.CaseDTO; import com.platform.model.dto.UserDTO; import com.platform.model.entity.ExcelDataEntity; import com.platform.model.entity.UserAccountEntity; import com.platform.model.entity.UserEntity; import com.platform.model.entity.UserRelationEntity; import com.platform.model.vo.AssociationVO; import com.platform.model.vo.EveryoneVO; import com.platform.model.vo.ExcelDataVO; import com.platform.model.vo.UserVO; import com.platform.service.ExcelDataService; import com.platform.service.UserAccountService; import com.platform.service.UserRelationService; import com.platform.service.UserService; import com.platform.utils.DozerUtils; import com.platform.utils.IdCardUtils; import org.checkerframework.checker.nullness.qual.Nullable; import org.jetbrains.annotations.NotNull; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.ObjectUtils; import javax.annotation.Resource; import java.util.*; @Service public class UserServiceImpl extends ServiceImpl implements UserService { @Resource private UserAccountService userAccountService; @Resource private UserRelationService userRelationService; @Resource private ExcelDataService excelDataService; @Override public UserVO getDetail(UserDTO userDTO) { UserEntity userEntity = baseMapper.selectOne(new LambdaQueryWrapper() .eq(UserEntity::getUserName, userDTO.getUserName()).eq(UserEntity::getCaseId, userDTO.getCaseId())); if (ObjectUtils.isEmpty(userEntity)) { return account(userDTO); } else { return personnel(userDTO, userEntity); } } private UserVO account(UserDTO userDTO) { UserVO userVO = new UserVO(); userVO.setUserName(userDTO.getUserName()); userVO.setCaseId(userDTO.getCaseId()); //本人账号数量 HashSet account = Sets.newHashSet(); //查询关联资金 List financialTransactions = excelDataService.queryAccountTemporary(userDTO); Map> detailsFunds = Maps.newHashMap(); for (AssociationVO financialTransaction : financialTransactions) { if ("出账".equals(financialTransaction.getDirection())) { if (detailsFunds.containsKey(financialTransaction.getPayeeName())) { financialTransaction.setRelationDesc(detailsFunds.get(financialTransaction.getPayeeName()).size() + "、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); detailsFunds.get(financialTransaction.getPayeeName()).add(financialTransaction); account.add(financialTransaction.getPayUserName()); } else { List list = new ArrayList<>(); financialTransaction.setRelationDesc("1、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); list.add(financialTransaction); detailsFunds.put(financialTransaction.getPayeeName(), list); account.add(financialTransaction.getPayUserName()); } } else if ("入账".equals(financialTransaction.getDirection())) { if (detailsFunds.containsKey(financialTransaction.getPayUserName())) { financialTransaction.setRelationDesc(detailsFunds.get(financialTransaction.getPayUserName()).size() + "、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); detailsFunds.get(financialTransaction.getPayUserName()).add(financialTransaction); account.add(financialTransaction.getPayeeName()); } else { List list = new ArrayList<>(); financialTransaction.setRelationDesc("1、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); list.add(financialTransaction); detailsFunds.put(financialTransaction.getPayeeName(), list); account.add(financialTransaction.getPayeeName()); } } } //关联人员数量 userVO.setHeadcount(detailsFunds.size()); //关联交易次数 int quantity = 0; for (AssociationVO financialTransaction : financialTransactions) { quantity += financialTransaction.getNum(); } userVO.setQuantity(quantity); //本人账户数量 userVO.setAccountNum(account.size()); //明细 userVO.setDetailsFunds(detailsFunds); return userVO; } @NotNull private UserVO personnel(UserDTO userDTO, UserEntity userEntity) { UserVO userVO = DozerUtils.convertBean(userEntity, UserVO.class); if (userVO != null) { //查看用户账户列表 List userAccountEntityList = userAccountService.queryListByUserName(userDTO.getUserName()); userVO.setUserAccountList(userAccountEntityList); } List relationShipList = userRelationService.list(new LambdaQueryWrapper() .eq(UserRelationEntity::getUserName, userEntity.getUserName()).eq(UserRelationEntity::getCaseId, userDTO.getCaseId())); if (!ObjectUtils.isEmpty(relationShipList)) { userVO.setRelationShipList(relationShipList); } //本人账号数量 HashSet account = Sets.newHashSet(); //查询关联资金 List financialTransactions = excelDataService.selectFinancialTransactions(userDTO); Map> detailsFunds = Maps.newHashMap(); for (AssociationVO financialTransaction : financialTransactions) { if ("出账".equals(financialTransaction.getDirection())) { if (detailsFunds.containsKey(financialTransaction.getPayeeName())) { financialTransaction.setRelationDesc(detailsFunds.get(financialTransaction.getPayeeName()).size() + "、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); detailsFunds.get(financialTransaction.getPayeeName()).add(financialTransaction); account.add(financialTransaction.getPayUserName()); } else { List list = new ArrayList<>(); financialTransaction.setRelationDesc("1、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); list.add(financialTransaction); detailsFunds.put(financialTransaction.getPayeeName(), list); account.add(financialTransaction.getPayUserName()); } } else if ("入账".equals(financialTransaction.getDirection())) { if (detailsFunds.containsKey(financialTransaction.getPayUserName())) { financialTransaction.setRelationDesc(detailsFunds.get(financialTransaction.getPayUserName()).size() + "、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); detailsFunds.get(financialTransaction.getPayUserName()).add(financialTransaction); account.add(financialTransaction.getPayeeName()); } else { List list = new ArrayList<>(); financialTransaction.setRelationDesc("1、" + financialTransaction.getStartTime() + "-" + financialTransaction.getEndTime() + financialTransaction.getPayeeName() + "->" + financialTransaction.getPayUserName() + "," + financialTransaction.getTotalAmount() + ",交易" + financialTransaction.getNum() + "次"); list.add(financialTransaction); detailsFunds.put(financialTransaction.getPayeeName(), list); account.add(financialTransaction.getPayeeName()); } } } //关联人员数量 userVO.setHeadcount(detailsFunds.size()); //关联交易次数 int quantity = 0; for (AssociationVO financialTransaction : financialTransactions) { quantity += financialTransaction.getNum(); } userVO.setQuantity(quantity); //本人账户数量 userVO.setAccountNum(account.size()); //明细 userVO.setDetailsFunds(detailsFunds); return userVO; } @Override public boolean updateUser(UserDTO userDTO) { List relationShipList = userDTO.getRelationShipList(); if (!ObjectUtils.isEmpty(relationShipList)) { userRelationService.saveOrUpdateBatch(relationShipList); } updateById(userDTO); //先删除账户信息 userAccountService.deleteByUserName(userDTO.getUserName()); //保存新的账户信息 List userAccountEntityList = userDTO.getUserAccountList(); if (CollUtil.isNotEmpty(userAccountEntityList)) { userAccountEntityList.forEach(userAccountEntity -> userAccountEntity.setUserName(userDTO.getUserName())); userAccountService.updateBatchById(userAccountEntityList); } return Boolean.TRUE; } @Override @Transactional public Boolean add(UserDTO userDTO) { try { //解析身份证号 Map idCardInfo = IdCardUtils.parseIdCardInfo(userDTO.getIdCard()); if (MapUtil.isNotEmpty(idCardInfo)) { userDTO.setAge(Integer.parseInt(idCardInfo.get("age"))); userDTO.setSex(idCardInfo.get("sex")); userDTO.setIdCard(idCardInfo.get("idCard")); userDTO.setIdType("身份证"); } userDTO.setUserName(userDTO.getUserName() + userDTO.getIdCard()); userDTO.setType("1"); return save(userDTO); } catch (Exception e) { throw new BusinessException("用户" + userDTO.getUserName() + "已经存在"); } } @Override public List cashFlow(UserDTO userDTO) { List excelDataList = excelDataService.cashFlow(userDTO); for (ExcelDataEntity excelDataEntity : excelDataList) { if ("出账".equals(excelDataEntity.getDirection())) { excelDataEntity.setSelfAccount(excelDataEntity.getPayAccount()); excelDataEntity.setAssociationAccount(excelDataEntity.getPayeeAccount()); } else if ("入账".equals(excelDataEntity.getDirection())) { excelDataEntity.setSelfAccount(excelDataEntity.getPayeeAccount()); excelDataEntity.setAssociationAccount(excelDataEntity.getPayAccount()); } } return excelDataList; } @Override public EveryoneVO relationPage(UserDTO userDTO) { EveryoneVO everyoneVO = new EveryoneVO(); UserEntity oneself = getOne(new LambdaQueryWrapper() .eq(UserEntity::getUserName, userDTO.getUserName()).eq(UserEntity::getCaseId, userDTO.getCaseId()), false); // UserEntity other = getOne(new LambdaQueryWrapper() // .eq(UserEntity::getUserName, userDTO.getOtherName()).eq(UserEntity::getCaseId, userDTO.getCaseId()), false); // if (ObjectUtils.isEmpty(oneself) || ObjectUtils.isEmpty(other)) { // throw new BusinessException("用户不存在"); // } //标题 everyoneVO.setTitle(userDTO.getUserName() + "," + userDTO.getOtherName()); //查询关系 List userRelation = userRelationService.bothSides(userDTO.getUserName(), userDTO.getOtherName()); //指认关系 if (!ObjectUtils.isEmpty(userRelation)) { everyoneVO.setRelation(userRelation); } //查询账户 List oneselfAccountList = userAccountService.queryUserAccountList(userDTO.getUserName()); List otherAccountList = userAccountService.queryUserAccountList(userDTO.getOtherName()); PageHelper.startPage(userDTO.getPageNum(), userDTO.getPageSize()); if (!ObjectUtils.isEmpty(oneselfAccountList) && !ObjectUtils.isEmpty(otherAccountList)) { List details = excelDataService.relationPage(oneselfAccountList, otherAccountList); everyoneVO.setDetails(details); } PageHelper.clearPage(); return everyoneVO; } @Override @Transactional public Boolean delete(String userName) { excelDataService.remove(new LambdaQueryWrapper().eq(ExcelDataEntity::getPayUserName, userName)); excelDataService.remove(new LambdaQueryWrapper().eq(ExcelDataEntity::getPayeeName, userName)); //删除关系 userRelationService.remove(new LambdaQueryWrapper().eq(UserRelationEntity::getUserName, userName)); userRelationService.remove(new LambdaQueryWrapper().eq(UserRelationEntity::getOtherName, userName)); //删除账户 userAccountService.deleteByUserName(userName); return remove(new LambdaQueryWrapper().eq(UserEntity::getUserName, userName)); } @Override public UserEntity getByUserName(String newName, int caseId) { return baseMapper.selectOne(new LambdaQueryWrapper() .eq(UserEntity::getUserName, newName) .eq(UserEntity::getCaseId, caseId) ); } @Override public List queryListByCaseId(Integer id) { List userEntityList = baseMapper.selectList(new LambdaQueryWrapper() .eq(UserEntity::getCaseId, id) .eq(UserEntity::getType, 1)); Set userNameList = new HashSet<>(); userEntityList.forEach(userEntity -> userNameList.add(userEntity.getUserName())); return new ArrayList<>(userNameList); } @Override @Transactional public Boolean relationSaveOrUpdate(List userRelationList) { //添加连线 List excelDataList = Lists.newArrayList(); for (UserRelationEntity userRelation : userRelationList) { ExcelDataEntity excelDataEntity = new ExcelDataEntity(); excelDataEntity.setPayUserName(userRelation.getUserName()); excelDataEntity.setPayeeName(userRelation.getOtherName()); excelDataEntity.setCaseId(Integer.parseInt(userRelation.getCaseId())); excelDataEntity.setUseFlag(true); excelDataEntity.setUserFlag(true); excelDataList.add(excelDataEntity); } excelDataService.saveBatch(excelDataList); return userRelationService.saveOrUpdateBatch(userRelationList); } @Override public List queryUserLabel(List userNameList, Integer id) { if (CollUtil.isEmpty(userNameList)) { return Lists.newArrayList(); } return baseMapper.queryUserLabel(userNameList, id); } @Override public void saveUserBatch(List userList) { baseMapper.saveUserBatch(userList); } @Override public List queryList(CaseDTO caseDTO) { return baseMapper.queryList(caseDTO); } }