xuhy
2023-06-14 17f18c3d56a70327874aa7dda0adfa2f5e3dafce
management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TAppUserServiceImpl.java
@@ -2,21 +2,31 @@
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.stylefeng.guns.core.util.DateUtil;
import com.stylefeng.guns.modular.system.controller.resp.TAppUserResp;
import com.stylefeng.guns.modular.system.dao.TCouponMapper;
import com.stylefeng.guns.modular.system.dao.TOrderMapper;
import com.stylefeng.guns.modular.system.dao.TUserToCouponMapper;
import com.stylefeng.guns.modular.system.enums.CouponStatusEnum;
import com.stylefeng.guns.modular.system.enums.OrderStateEnum;
import com.stylefeng.guns.modular.system.enums.StatusEnum;
import com.stylefeng.guns.modular.system.model.TAppUser;
import com.stylefeng.guns.modular.system.dao.TAppUserMapper;
import com.stylefeng.guns.modular.system.model.TCoupon;
import com.stylefeng.guns.modular.system.model.TOrder;
import com.stylefeng.guns.modular.system.model.TUserToCoupon;
import com.stylefeng.guns.modular.system.service.ITAppUserService;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import org.apache.poi.hdf.extractor.TC;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.ui.Model;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;
import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.*;
import java.util.stream.Collectors;
/**
@@ -34,6 +44,10 @@
    private TAppUserMapper tAppUserMapper;
    @Autowired
    private TCouponMapper tCouponMapper;
    @Autowired
    private TOrderMapper tOrderMapper;
    @Autowired
    private TUserToCouponMapper tUserToCouponMapper;
    @Override
    public void detail(Integer tAppUserId, Model model) {
@@ -44,15 +58,90 @@
        model.addAttribute("id",tAppUser.getId());
        model.addAttribute("nickname",tAppUser.getNickname());
        model.addAttribute("remark",tAppUser.getRemark());
        model.addAttribute("createTime",tAppUser.getCreateTime());
        model.addAttribute("accountBalance",tAppUser.getAccountBalance());
        model.addAttribute("createTime",DateUtil.formatDate(tAppUser.getCreateTime()));
        //  todo 客户渠道
        model.addAttribute("customerChannel","");
        // 消费信息:优惠券数据
        List<TCoupon> tCoupons = tCouponMapper.selectList(new EntityWrapper<TCoupon>().eq("user_id", tAppUserId));
        List<TCoupon> notUsedList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.NOT_USED.getCode())).collect(Collectors.toList());
        List<TCoupon> usedList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.USED.getCode())).collect(Collectors.toList());
        List<TCoupon> expiredList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.EXPIRED.getCode())).collect(Collectors.toList());
        model.addAttribute("notUsedCount",notUsedList.size());
        model.addAttribute("usedCount",usedList.size());
        model.addAttribute("expiredCount",expiredList.size());
//        List<TCoupon> tCoupons = tCouponMapper.selectList(new EntityWrapper<TCoupon>().eq("user_id", tAppUserId));
//        List<TCoupon> notUsedList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.NOT_USED.getCode())).collect(Collectors.toList());
//        List<TCoupon> usedList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.USED.getCode())).collect(Collectors.toList());
//        List<TCoupon> expiredList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.EXPIRED.getCode())).collect(Collectors.toList());
        // 查询全部未删除优惠券
        List<TCoupon> tCoupons = tCouponMapper.selectList(new EntityWrapper<TCoupon>()
                .eq("status", true));
        List<Integer> couponIds = tCoupons.stream().map(TCoupon::getId).collect(Collectors.toList());
        List<TUserToCoupon> tUserToCoupons;
        if(CollectionUtils.isEmpty(couponIds)){
            tUserToCoupons = new ArrayList<>();
        }else {
            // 查询当前用户优惠券数量
            tUserToCoupons = tUserToCouponMapper.selectList(new EntityWrapper<TUserToCoupon>().eq("userId", tAppUser.getId())
                    .in("couponId",couponIds));
        }
        int couponTotal = tUserToCoupons.stream().mapToInt(TUserToCoupon::getCouponTotal).sum();
        int validCount = tUserToCoupons.stream().mapToInt(TUserToCoupon::getValidCount).sum();
        int expireCount = tUserToCoupons.stream().mapToInt(TUserToCoupon::getExpireCount).sum();
        model.addAttribute("couponSum",couponTotal);
        model.addAttribute("notUsedCount",validCount);
        model.addAttribute("usedCount",couponTotal-validCount-expireCount);
        model.addAttribute("expiredCount",expireCount);
        // 查询订单数据
        List<TOrder> orders = tOrderMapper.selectList(new EntityWrapper<TOrder>().eq("userId", tAppUserId).orderBy(true,"createTime",false));
        if(!CollectionUtils.isEmpty(orders)){
            // 下单次数
            model.addAttribute("numberOfOrder",orders.size());
            // 取消次数
            List<TOrder> collect = orders.stream().filter(order->Objects.nonNull(order.getState()))
                    .filter(order -> OrderStateEnum.CANCELED.getCode() == order.getState()).collect(Collectors.toList());
            model.addAttribute("canceledNumber",collect.size());
            // 获取已支付订单
            List<TOrder> payOrder = orders.stream().filter(order -> order.getState().equals(OrderStateEnum.WAIT_EVALUATED.getCode())
                    || order.getState().equals(OrderStateEnum.FINISH.getCode())).collect(Collectors.toList());
            if(CollectionUtils.isEmpty(payOrder)){
                // 最近消费时间
                model.addAttribute("latelyTime","");
                // 最近消费金额
                model.addAttribute("latelyPrice","");
            }else {
                TOrder tOrder = payOrder.get(0);
                // 最近消费时间
                model.addAttribute("latelyTime",DateUtil.formatDate(tOrder.getPayTime()));
                // 最近消费金额
                model.addAttribute("latelyPrice",tOrder.getPayMoney());
            }
            // 总消费次数
            List<TOrder> collect1 = orders.stream().filter(order->Objects.nonNull(order.getState()))
                    .filter(order -> OrderStateEnum.WAIT_EVALUATED.getCode() == order.getState() ||
                    OrderStateEnum.FINISH.getCode() == order.getState()).collect(Collectors.toList());
            if(!CollectionUtils.isEmpty(collect1)){
                model.addAttribute("consumeSum",collect1.size());
                // 总消费金额
                collect1.stream().map(TOrder::getPayMoney).reduce(BigDecimal::add)
                        .ifPresent(consumePrice -> model.addAttribute("consumePrice", consumePrice));
            }else {
                // 总消费次数
                model.addAttribute("consumeSum",0);
                // 总消费金额
                model.addAttribute("consumePrice", 0);
            }
        }else {
            // 下单次数
            model.addAttribute("numberOfOrder",0);
            // 取消次数
            model.addAttribute("canceledNumber",0);
            // 最近消费时间
            model.addAttribute("latelyTime","");
            // 最近消费金额
            model.addAttribute("latelyPrice",0);
            // 总消费次数
            model.addAttribute("consumeSum",0);
            // 总消费金额
            model.addAttribute("consumePrice", 0);
        }
    }
    @Override
@@ -73,8 +162,8 @@
        // 开始,结束时间
        if(StringUtils.hasLength(createTime)){
            String[] split = createTime.split(" - ");
            Date startTime = DateUtil.getDate_str4(split[0]);
            Date endTime = DateUtil.getDate_str4(split[1]);
            Date startTime = DateUtil.getDate_str3(split[0]+" 00:00:00");
            Date endTime = DateUtil.getDate_str3(split[1]+" 23:59:59");
            wrapper.between("createtime",startTime,endTime);
        }
//        if(Objects.nonNull(startTime) && Objects.nonNull(endTime)){
@@ -84,6 +173,43 @@
        if(Objects.nonNull(status)){
            wrapper.eq("status",status);
        }
        wrapper.ne("status", StatusEnum.DELETE.getCode());
        return wrapper;
    }
    @Override
    public List<TAppUserResp> getTAppUserResp(List<TAppUser> tAppUsers) {
        List<TAppUserResp> tAppUserRespList = new ArrayList<>(tAppUsers.size());
        for (TAppUser tAppUser : tAppUsers) {
            TAppUserResp tAppUserResp = new TAppUserResp();
            BeanUtils.copyProperties(tAppUser,tAppUserResp);
            // 查询当前用户优惠券数量
            List<TUserToCoupon> tUserToCoupons = tUserToCouponMapper.selectList(new EntityWrapper<TUserToCoupon>().eq("userId", tAppUser.getId()));
            int couponTotal = tUserToCoupons.stream().mapToInt(TUserToCoupon::getCouponTotal).sum();
            int validCount = tUserToCoupons.stream().mapToInt(TUserToCoupon::getValidCount).sum();
//            List<TCoupon> tCoupons = tCouponService.selectList(new EntityWrapper<TCoupon>().eq("user_id", tAppUser.getId()));
//            List<TCoupon> notUsedList = tCoupons.stream().filter(coupon -> coupon.getCouponStatus().equals(CouponStatusEnum.NOT_USED.getCode())).collect(Collectors.toList());
            tAppUserResp.setCouponSum(couponTotal);
            tAppUserResp.setNotUsedCount(validCount);
            List<TOrder> orders = tOrderMapper.selectList(new EntityWrapper<TOrder>().eq("userId", tAppUser.getId()).orderBy(true,"createTime",false));
            if(!CollectionUtils.isEmpty(orders)){
                // 最后一次消费时间
                tAppUserResp.setLastConsumptionTime(orders.get(0).getCreateTime());
                List<TOrder> collect1 = orders.stream().filter(order->Objects.nonNull(order.getState()))
                        .filter(order -> OrderStateEnum.WAIT_EVALUATED.getCode() == order.getState() ||
                                OrderStateEnum.FINISH.getCode() == order.getState()).collect(Collectors.toList());
                if(!CollectionUtils.isEmpty(collect1)) {
                    tAppUserResp.setConsumeSum(collect1.size());
                    // 总消费金额
                    collect1.stream().map(TOrder::getPayMoney).reduce(BigDecimal::add)
                            .ifPresent(tAppUserResp::setConsumePrice);
                }
            }
            tAppUserRespList.add(tAppUserResp);
        }
        return tAppUserRespList;
    }
}