From fae2db5e86b4e15ee0336739925328e88d25021a Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期六, 06 五月 2023 16:39:29 +0800 Subject: [PATCH] BUG修改 --- management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TAgentServiceImpl.java | 112 ++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 92 insertions(+), 20 deletions(-) diff --git a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TAgentServiceImpl.java b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TAgentServiceImpl.java index 79bbc1d..3a4712f 100644 --- a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TAgentServiceImpl.java +++ b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TAgentServiceImpl.java @@ -7,6 +7,7 @@ import com.stylefeng.guns.modular.system.dao.*; import com.stylefeng.guns.modular.system.enums.OrderStateEnum; import com.stylefeng.guns.modular.system.enums.PayStatusEnum; +import com.stylefeng.guns.modular.system.enums.StatusEnum; import com.stylefeng.guns.modular.system.enums.UserTypeEnum; import com.stylefeng.guns.modular.system.model.*; import com.stylefeng.guns.modular.system.service.ITAgentService; @@ -20,6 +21,7 @@ import java.math.BigDecimal; import java.text.SimpleDateFormat; +import java.time.LocalDate; import java.util.*; import java.util.stream.Collectors; @@ -49,6 +51,8 @@ @Autowired private TRechargeRecordMapper tRechargeRecordMapper; + @Autowired + private TUserToCouponMapper tUserToCouponMapper; @Override public EntityWrapper<TAgent> getAgentWrapper(String principal, String principalPhone, String createTime) { @@ -72,6 +76,8 @@ if(Objects.requireNonNull(ShiroKit.getUser()).getRoleType() == 3){ wrapper.eq("id",ShiroKit.getUser().getObjectId()); } + wrapper.ne("status", StatusEnum.DELETE.getCode()); + wrapper.orderBy("createTime",false); return wrapper; } @@ -87,6 +93,7 @@ model.addAttribute("principal",tAgent.getPrincipal()); model.addAttribute("principalPhone",tAgent.getPrincipalPhone()); model.addAttribute("email",tAgent.getEmail()); + model.addAttribute("serviceCalls",tAgent.getServiceCalls()); model.addAttribute("area",tAgent.getProvinceName()+tAgent.getCityName()); // 订单信息 // 订单总量 @@ -101,18 +108,32 @@ && Objects.nonNull(order.getCouponId()) && order.getAgentId().equals(tAgent.getId())).collect(Collectors.toList()); model.addAttribute("usedCoupon",usedCoupon.size()); // 已使用优惠券金额求和,已使用优惠券id - List<Integer> usedCouponId = usedCoupon.stream().map(TOrder::getCouponId).collect(Collectors.toList()); - // 查询已使用优惠券金额求和 - List<TCoupon> tCoupons1 = tCouponMapper.selectList(new EntityWrapper<TCoupon>().in("id", usedCouponId)); - if(CollectionUtils.isEmpty(tCoupons1)){ - model.addAttribute("couponPriceSum", BigDecimal.ZERO); - }else { - tCoupons1.stream().map(TCoupon::getCouponPreferentialAmount).reduce(BigDecimal::add).ifPresent(bigDecimal -> model.addAttribute("couponPriceSum", bigDecimal)); - } +// List<Integer> usedCouponId = usedCoupon.stream().map(TOrder::getCouponId).collect(Collectors.toList()); +// if(CollectionUtils.isEmpty(usedCouponId)){ +// // 如果优惠券为空 +// model.addAttribute("couponPriceSum", BigDecimal.ZERO); +// }else { +// // 查询已使用优惠券金额求和 +// List<TCoupon> tCoupons1 = tCouponMapper.selectList(new EntityWrapper<TCoupon>().in("id", usedCouponId)); +// if(CollectionUtils.isEmpty(tCoupons1)){ +// model.addAttribute("couponPriceSum", BigDecimal.ZERO); +// }else { +// tCoupons1.stream().map(TCoupon::getCouponPreferentialAmount).reduce(BigDecimal::add).ifPresent(bigDecimal -> model.addAttribute("couponPriceSum", bigDecimal)); +// } +// } // 优惠券信息 // 过滤代理商发放的优惠券 - List<TCoupon> tCoupons = tCouponMapper.selectList(new EntityWrapper<TCoupon>()); - model.addAttribute("issuedCoupon",tCoupons.size()); + List<TUserToCoupon> tUserToCoupons = tUserToCouponMapper.selectList(new EntityWrapper<TUserToCoupon>().eq("objectId",tAgent.getId()) + .eq("roleType",3)); + BigDecimal couponPriceSum = BigDecimal.ZERO; + for (TUserToCoupon userToCoupon : tUserToCoupons) { + TCoupon tCoupons1 = tCouponMapper.selectById(userToCoupon.getCouponId()); + couponPriceSum = couponPriceSum.add(tCoupons1.getCouponPreferentialAmount().multiply(new BigDecimal(userToCoupon.getCouponTotal()))); + } + model.addAttribute("couponPriceSum", couponPriceSum); + // 过滤代理商发放的优惠券 + int sum = tUserToCoupons.stream().mapToInt(TUserToCoupon::getCouponTotal).sum(); + model.addAttribute("issuedCoupon",sum); // 司机信息 // 司机数 List<TDriver> drivers = tDriverMapper.selectList(new EntityWrapper<TDriver>().eq("agentId", tAgent.getId())); @@ -135,6 +156,8 @@ List<TOrder> tOrders = tOrderMapper.selectList(new EntityWrapper<TOrder>()); // 查询优惠券 List<TCoupon> tCoupons = tCouponMapper.selectList(new EntityWrapper<TCoupon>()); + // 用户 + List<TUserToCoupon> tUserToCoupons = tUserToCouponMapper.selectList(new EntityWrapper<TUserToCoupon>()); // 查询司机信息 List<TDriver> tDrivers = tDriverMapper.selectList(new EntityWrapper<TDriver>()); @@ -148,27 +171,42 @@ if(!CollectionUtils.isEmpty(tOrders)){ // 订单总量 - List<TOrder> orderList = tOrders.stream().filter(order -> order.getAgentId().equals(tAgent.getId())).collect(Collectors.toList()); + List<TOrder> orderList = tOrders.stream().filter(order -> tAgent.getId().equals(order.getAgentId())).collect(Collectors.toList()); tAgentResp.setOrderSum(orderList.size()); // 过滤已完成和待评价订单,且支付金额在14元以上 List<TOrder> orders = tOrders.stream().filter(order -> (order.getState().equals(OrderStateEnum.FINISH.getCode()) || order.getState().equals(OrderStateEnum.WAIT_EVALUATED.getCode())) - && 0 < order.getPayMoney().compareTo(new BigDecimal("14")) && order.getAgentId().equals(tAgent.getId())).collect(Collectors.toList()); + && 0 < order.getPayMoney().compareTo(new BigDecimal("14")) && tAgent.getId().equals(order.getAgentId())).collect(Collectors.toList()); tAgentResp.setValidOrder(orders.size()); // 过滤已使用优惠券 List<TOrder> usedCoupon = tOrders.stream().filter(order -> (order.getState().equals(OrderStateEnum.FINISH.getCode()) || order.getState().equals(OrderStateEnum.WAIT_EVALUATED.getCode())) - && Objects.nonNull(order.getCouponId()) && order.getAgentId().equals(tAgent.getId())).collect(Collectors.toList()); + && Objects.nonNull(order.getCouponId()) && tAgent.getId().equals(order.getAgentId())).collect(Collectors.toList()); tAgentResp.setUsedCoupon(usedCoupon.size()); // 已使用优惠券金额求和,已使用优惠券id - List<Integer> usedCouponId = usedCoupon.stream().map(TOrder::getCouponId).collect(Collectors.toList()); - // 查询已使用优惠券金额求和 - List<TCoupon> tCoupons1 = tCouponMapper.selectList(new EntityWrapper<TCoupon>().in("id", usedCouponId)); - tCoupons1.stream().map(TCoupon::getCouponPreferentialAmount).reduce(BigDecimal::add).ifPresent(tAgentResp::setCouponPriceSum); +// List<Integer> usedCouponId = usedCoupon.stream().map(TOrder::getCouponId).collect(Collectors.toList()); +// if(CollectionUtils.isEmpty(usedCouponId)){ +// tAgentResp.setCouponPriceSum(BigDecimal.ZERO); +// }else { +// // 查询已使用优惠券金额求和 +// BigDecimal couponPriceSum = BigDecimal.ZERO; +// for (Integer id : usedCouponId) { +// TCoupon tCoupons1 = tCouponMapper.selectById(id); +// couponPriceSum = couponPriceSum.add(tCoupons1.getCouponPreferentialAmount()); +// } +// tAgentResp.setCouponPriceSum(couponPriceSum); +// } } - if(!CollectionUtils.isEmpty(tCoupons)){ + if(!CollectionUtils.isEmpty(tUserToCoupons)){ // 过滤代理商发放的优惠券 - List<TCoupon> coupons = tCoupons.stream().filter(coupon -> coupon.getAgentId().equals(tAgent.getId())).collect(Collectors.toList()); - tAgentResp.setIssuedCoupon(coupons.size()); + List<TUserToCoupon> userToCoupons = tUserToCoupons.stream().filter(coupon -> tAgent.getId().equals(coupon.getObjectId()) && coupon.getRoleType() == 3).collect(Collectors.toList()); + int sum = userToCoupons.stream().mapToInt(TUserToCoupon::getCouponTotal).sum(); + tAgentResp.setIssuedCoupon(sum); + BigDecimal couponPriceSum = BigDecimal.ZERO; + for (TUserToCoupon userToCoupon : userToCoupons) { + TCoupon tCoupons1 = tCouponMapper.selectById(userToCoupon.getCouponId()); + couponPriceSum = couponPriceSum.add(tCoupons1.getCouponPreferentialAmount().multiply(new BigDecimal(userToCoupon.getCouponTotal()))); + } + tAgentResp.setCouponPriceSum(couponPriceSum); } if(!CollectionUtils.isEmpty(tDrivers)){ @@ -187,4 +225,38 @@ } return tAgentRespList; } + + @Override + public void getDataStatistics(Integer agentId, Model model,Map<String, Object> map) { + // 代理商总数 + Integer agentTotal = tAgentMapper.selectCount(new EntityWrapper<TAgent>() + .eq("id", agentId)); + // 代理商最近一个月新增数量 + LocalDate now = LocalDate.now(); + LocalDate localDate = now.plusMonths(1); + Integer agentMonthTotal = tAgentMapper.selectCount(new EntityWrapper<TAgent>() + .eq("id", agentId) + .between("createTime", localDate, now)); + model.addAttribute("agentTotal",agentTotal); + model.addAttribute("agentMonthTotal",agentMonthTotal); + map.put("agentTotal",agentTotal); + map.put("agentMonthTotal",agentMonthTotal); + } + + @Override + public void getDataStatisticsByIds(List<Integer> ids, Model model, Map<String, Object> map) { + // 代理商总数 + Integer agentTotal = tAgentMapper.selectCount(new EntityWrapper<TAgent>() + .in("id", ids)); + // 代理商最近一个月新增数量 + LocalDate now = LocalDate.now(); + LocalDate localDate = now.plusMonths(1); + Integer agentMonthTotal = tAgentMapper.selectCount(new EntityWrapper<TAgent>() + .in("id", ids) + .between("createTime", localDate, now)); + model.addAttribute("agentTotal",agentTotal); + model.addAttribute("agentMonthTotal",agentMonthTotal); + map.put("agentTotal",agentTotal); + map.put("agentMonthTotal",agentMonthTotal); + } } -- Gitblit v1.7.1