From ecca9ab70a9a87bcb60977c92fbf81053b8fc1bb Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期三, 04 九月 2024 09:17:55 +0800
Subject: [PATCH] 新增优化
---
ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/service/impl/UserServiceImpl.java | 146 ++++++++++++++++++++++++++++++++++++++----------
1 files changed, 116 insertions(+), 30 deletions(-)
diff --git a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/service/impl/UserServiceImpl.java b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/service/impl/UserServiceImpl.java
index 074d63e..6a0a257 100644
--- a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/service/impl/UserServiceImpl.java
+++ b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/service/impl/UserServiceImpl.java
@@ -1,15 +1,18 @@
package com.ruoyi.admin.service.impl;
+import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.admin.entity.User;
import com.ruoyi.admin.mapper.UserMapper;
import com.ruoyi.admin.request.UserDataCountRequest;
-import com.ruoyi.admin.service.OrderService;
import com.ruoyi.admin.service.UserService;
-import com.ruoyi.admin.service.WithdrawService;
import com.ruoyi.admin.vo.UserDataCountVO;
import com.ruoyi.admin.vo.UserTrendsVO;
import com.ruoyi.common.core.constant.OrderConstants;
+import com.ruoyi.common.core.domain.R;
+import com.ruoyi.order.api.entity.MoneyQueryRequest;
+import com.ruoyi.order.api.feignClient.OrderClient;
+import com.ruoyi.order.api.feignClient.WithdrawClient;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@@ -19,6 +22,7 @@
import java.time.Year;
import java.time.temporal.TemporalAdjusters;
import java.util.ArrayList;
+import java.util.Iterator;
import java.util.List;
/**
@@ -33,25 +37,47 @@
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
@Resource
- private OrderService orderService;
+ private OrderClient orderClient;
@Resource
- private WithdrawService withdrawService;
+ private WithdrawClient withdrawClient;
@Override
public List<UserTrendsVO> userTrends(List<String> city) {
- if (null == city || city.isEmpty()) {
+ List<UserTrendsVO> userTrendsList = baseMapper.userTrends(city);
+ return null == userTrendsList || userTrendsList.isEmpty() ? new ArrayList<>() : userTrendsList;
+ }
+ @Override
+ public List<UserTrendsVO> userTrends1(List<String> city,List<Integer> userIds) {
+ if (userIds.isEmpty()){
return new ArrayList<>();
}
- List<UserTrendsVO> userTrendsList = baseMapper.userTrends(city);
+ List<UserTrendsVO> userTrendsList = baseMapper.userTrends1(city,userIds);
return null == userTrendsList || userTrendsList.isEmpty() ? new ArrayList<>() : userTrendsList;
}
@Override
- public Object userDataCount(UserDataCountRequest userDataCountRequest) {
+ public UserDataCountVO userDataCount(UserDataCountRequest userDataCountRequest) {
List<String> cityList = userDataCountRequest.getCityList();
- List<User> userList = lambdaQuery().eq(User::getIsDelete, 0).list();
+ String type = userDataCountRequest.getCountType();
+ LambdaQueryChainWrapper<User> userWrapper = lambdaQuery().eq(User::getIsDelete, 0).isNotNull(User::getPhone);
+ if (null != cityList && !cityList.isEmpty()) {
+ userWrapper.in(User::getCityCode, cityList);
+ }
+ List<User> userList = userWrapper.list();
+
+ // 判断用户是否在管辖城市内下过订单
+// Iterator<User> iterator = userList.iterator();
+// while (iterator.hasNext()) {
+// User user = iterator.next();
+// Integer userId = user.getId();
+// R<Boolean> r = orderClient.orderByUserId(userId);
+// if (!r.getData()) {
+// iterator.remove(); // 安全地移除元素
+// }
+// }
+
+ Integer userNumber = userList.size();
// 用户总量
- Integer userNumber = null == userList ? 0 : userList.size();
// 计算当前季度时间所包含时间
int currentYear = Year.now().getValue();
// 获取当前月份
@@ -63,35 +89,95 @@
String endDateStr = String.valueOf(endDate);
// 结果数据封装
Long increaseNumber;
- BigDecimal totalMoney;
- BigDecimal withdrawalTotalMoney;
- if (OrderConstants.QUARTER.equals(userDataCountRequest.getCountType())) {
+ // 交易额
+ BigDecimal totalMoney = orderClient.tradeMoney(new MoneyQueryRequest(cityList,userDataCountRequest.getCountType())).getData();
+ BigDecimal withdrawalTotalMoney = withdrawClient.withdrawalTotalMoney(new MoneyQueryRequest(cityList, type))
+ .getData();
+ if (OrderConstants.QUARTER.equals(type)) {
// 用户增长数
- increaseNumber = lambdaQuery().ge(User::getCreateTime, startDateStr).le(User::getCreateTime, endDateStr)
- .in(User::getCity, cityList).eq(User::getIsDelete, 0).count();
- // 用户总交易额
- totalMoney = orderService.totalMoneyByQuarter(startDateStr, endDateStr, cityList);
- // 用户提现总额
- withdrawalTotalMoney = withdrawService.withdrawalTotalMoney(cityList);
- } else if (OrderConstants.YEAR.equals(userDataCountRequest.getCountType())) {
+ LambdaQueryChainWrapper<User> wrapper = lambdaQuery().ge(User::getCreateTime, startDateStr)
+ .le(User::getCreateTime, endDateStr);
+ if (null != cityList && !cityList.isEmpty()) {
+ wrapper.in(User::getCityCode, cityList);
+ }
+ increaseNumber = wrapper.eq(User::getIsDelete, 0).isNotNull(User::getPhone).count();
+ } else if (OrderConstants.YEAR.equals(type)) {
// 用户增长数
increaseNumber = baseMapper.increaseNumberByYear(cityList);
- // 用户总交易额
- totalMoney = orderService.totalMoneyByYear(cityList);
- // 用户提现总额
- withdrawalTotalMoney = withdrawService.withdrawalTotalMoneyByYear(cityList);
- } else if (OrderConstants.MONTH.equals(userDataCountRequest.getCountType())) {
+ } else if (OrderConstants.MONTH.equals(type)) {
// 用户增长数
increaseNumber = baseMapper.increaseNumberByMonth(cityList);
- // 用户总交易额
- totalMoney = orderService.totalMoneyByMonth(cityList);
- // 用户提现总额
- withdrawalTotalMoney = withdrawService.withdrawalTotalMoneyByMonth(cityList);
} else {
// 数量初始化
increaseNumber = 0L;
- totalMoney = BigDecimal.ZERO;
- withdrawalTotalMoney = BigDecimal.ZERO;
+ }
+ // 查询结果判断
+ increaseNumber = null == increaseNumber ? 0L : increaseNumber;
+ totalMoney = null == totalMoney ? BigDecimal.ZERO : totalMoney;
+ withdrawalTotalMoney = null == withdrawalTotalMoney ? BigDecimal.ZERO : withdrawalTotalMoney;
+ return new UserDataCountVO(userNumber, increaseNumber, totalMoney, withdrawalTotalMoney);
+ }
+
+
+ @Override
+ public UserDataCountVO userDataCount1(UserDataCountRequest userDataCountRequest,List<Integer> userIds) {
+ List<String> cityList = userDataCountRequest.getCityList();
+ String type = userDataCountRequest.getCountType();
+ if (userIds.isEmpty()){
+ return new UserDataCountVO(null,null,null,null);
+ }
+
+ LambdaQueryChainWrapper<User> userWrapper = lambdaQuery().eq(User::getIsDelete, 0).isNotNull(User::getPhone).in(!userIds.isEmpty(),User::getId,userIds);
+// if (null != cityList && !cityList.isEmpty()) {
+// userWrapper.in(User::getCityCode, cityList);
+// }
+ List<User> userList = userWrapper.list();
+
+ // 判断用户是否在管辖城市内下过订单
+ Iterator<User> iterator = userList.iterator();
+ while (iterator.hasNext()) {
+ User user = iterator.next();
+ Integer userId = user.getId();
+ R<Boolean> r = orderClient.orderByUserId(userId);
+ if (!r.getData()) {
+ iterator.remove(); // 安全地移除元素
+ }
+ }
+
+ Integer userNumber = userList.size();
+ // 用户总量
+ // 计算当前季度时间所包含时间
+ int currentYear = Year.now().getValue();
+ // 获取当前月份
+ Month currentMonth = LocalDate.now().getMonth();
+ // 计算当前季度的开始时间和结束时间
+ LocalDate startDate = LocalDate.of(currentYear, getStartMonthOfQuarter(currentMonth), 1);
+ LocalDate endDate = startDate.plusMonths(2).with(TemporalAdjusters.lastDayOfMonth());
+ String startDateStr = String.valueOf(startDate);
+ String endDateStr = String.valueOf(endDate);
+ // 结果数据封装
+ Long increaseNumber;
+ // 交易额
+ BigDecimal totalMoney = orderClient.tradeMoney(new MoneyQueryRequest(cityList,userDataCountRequest.getCountType())).getData();
+ BigDecimal withdrawalTotalMoney = withdrawClient.withdrawalTotalMoney(new MoneyQueryRequest(cityList, type))
+ .getData();
+ if (OrderConstants.QUARTER.equals(type)) {
+ // 用户增长数
+ LambdaQueryChainWrapper<User> wrapper = lambdaQuery().ge(User::getCreateTime, startDateStr)
+ .le(User::getCreateTime, endDateStr).in(User::getId,userIds);
+// if (null != cityList && !cityList.isEmpty()) {
+// wrapper.in(User::getCityCode, cityList);
+// }
+ increaseNumber = wrapper.eq(User::getIsDelete, 0).isNotNull(User::getPhone).count();
+ } else if (OrderConstants.YEAR.equals(type)) {
+ // 用户增长数
+ increaseNumber = baseMapper.increaseNumberByYear1(cityList,userIds);
+ } else if (OrderConstants.MONTH.equals(type)) {
+ // 用户增长数
+ increaseNumber = baseMapper.increaseNumberByMonth1(cityList,userIds);
+ } else {
+ // 数量初始化
+ increaseNumber = 0L;
}
// 查询结果判断
increaseNumber = null == increaseNumber ? 0L : increaseNumber;
--
Gitblit v1.7.1