From fece6af66e0cfaf95896227a791810c79bafd2e8 Mon Sep 17 00:00:00 2001 From: liujie <liujie> Date: 星期二, 08 八月 2023 10:09:18 +0800 Subject: [PATCH] 后台代码--远程用户 --- cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java | 937 +++++++++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 823 insertions(+), 114 deletions(-) diff --git a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java index 3bcb4d5..275b2da 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java +++ b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java @@ -3,42 +3,58 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; -import com.dsh.account.entity.TAppUser; -import com.dsh.account.entity.TStudent; +import com.dsh.account.entity.*; +import com.dsh.account.enums.RechargeRecordEnum; import com.dsh.account.feignclient.activity.MerChandiseClient; +import com.dsh.account.feignclient.activity.MerChandiseStoreClient; +import com.dsh.account.feignclient.activity.UserConponClient; +import com.dsh.account.feignclient.activity.model.*; +import com.dsh.account.feignclient.competition.DeductionCompetitionsClient; +import com.dsh.account.feignclient.competition.model.BillingDataRequestVo; +import com.dsh.account.feignclient.competition.model.PaymentCompetition; +import com.dsh.account.feignclient.course.CoursePackageClient; +import com.dsh.account.feignclient.course.CoursePackageConfigClient; import com.dsh.account.feignclient.course.CoursePaymentClient; -import com.dsh.account.feignclient.course.model.CourseOfStoreVo; -import com.dsh.account.feignclient.course.model.QueryStoreList; -import com.dsh.account.feignclient.course.model.StuCourseResp; +import com.dsh.account.feignclient.course.VideoOfCourseListClient; +import com.dsh.account.feignclient.course.model.*; import com.dsh.account.feignclient.other.ImgConfigClient; +import com.dsh.account.feignclient.other.RechargeConfigClient; +import com.dsh.account.feignclient.other.SiteClient; import com.dsh.account.feignclient.other.StoreClient; +import com.dsh.account.feignclient.other.model.SiteBooking; import com.dsh.account.feignclient.other.model.Store; +import com.dsh.account.feignclient.other.model.StoreDetailOfCourse; import com.dsh.account.feignclient.other.model.TImgConfig; -import com.dsh.account.mapper.TAppUserMapper; -import com.dsh.account.mapper.TStudentMapper; +import com.dsh.account.mapper.*; import com.dsh.account.model.AddAppUserVo; import com.dsh.account.model.JoinPlayPaiVo; import com.dsh.account.model.LoginSMSCodeVo; import com.dsh.account.model.LoginWeChatVo; +import com.dsh.account.model.dto.Coupon; import com.dsh.account.model.vo.classDetails.CourseVenue; import com.dsh.account.model.vo.classDetails.ExerciseVideo; import com.dsh.account.model.vo.classDetails.RegisteredCourse; -import com.dsh.account.model.vo.classDetails.WeekedCourse; import com.dsh.account.model.vo.classDetails.classInsVo.ClassInfoVo; -import com.dsh.account.model.vo.userBenefitDetail.BillingDetailsVo; -import com.dsh.account.model.vo.userBenefitDetail.IndexOfUserBenefirVo; +import com.dsh.account.model.vo.userBenefitDetail.*; import com.dsh.account.service.TAppUserService; import com.dsh.account.util.*; import com.dsh.account.util.akeylogin.Md5Util; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.data.domain.Page; +import org.springframework.data.domain.PageImpl; +import org.springframework.data.domain.PageRequest; +import org.springframework.data.domain.Pageable; import org.springframework.stereotype.Service; -import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.util.StringUtils; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; -import java.util.Map; +import javax.servlet.http.HttpServletRequest; +import java.io.IOException; +import java.math.BigDecimal; +import java.text.ParseException; +import java.text.SimpleDateFormat; +import java.util.*; import java.util.stream.Collectors; /** @@ -77,15 +93,51 @@ @Resource private StoreClient storeClient; - @Autowired + @Resource private MerChandiseClient mcClient; - - @Autowired + @Resource private ImgConfigClient icfgClient; + + @Resource + private VideoOfCourseListClient voclClient; + + @Resource + private VipPaymentMapper vipPaymentMapper; + + @Resource + private RechargeRecordsMapper rrMapper; + + @Resource + private RechargeConfigClient reconMapper; + + @Resource + private UserConponClient ucponClient; + + @Resource + private CoursePackageClient cpageClient; + + @Resource + private DeductionCompetitionsClient deducClient; + + @Resource + private UserIntegralChangesMapper uicMapper; + + @Resource + private MerChandiseStoreClient mcsClient; + + @Resource + private CoursePackageConfigClient cpconClient; + + @Resource + private PayMoneyUtil payMoneyUtil; + + @Resource + private SiteClient stClient; + @Override - public ClassInfoVo queryUserOfStus(Integer id,String latitude,String longitude) { + public ClassInfoVo queryUserOfStus(Integer id) { TAppUser tAppUser = this.baseMapper.selectById(id); ClassInfoVo classInfoVo = new ClassInfoVo(); if (ToolUtil.isNotEmpty(tAppUser)){ @@ -104,38 +156,28 @@ classInfoVo.setHeight(tStudent.getHeight()); classInfoVo.setWeight(tStudent.getWeight()); classInfoVo.setBmi(tStudent.getBmi()); + classInfoVo.setBodyStatus(BMIBodyUtil.getBodyStatus(tStudent.getBmi())); List<RegisteredCourse> courseList = new ArrayList<>(); -// 总学时数 - int total = 0; -// 已扣数 - int deduct = 0; -// 剩余数 - int remain = 0; - List<StuCourseResp> stuCoursePayment = paymentClient.getStuCoursePayment(); + List<StuCourseResp> stuCoursePayment = paymentClient.getStuCoursePayment(tStudent.getId()); + List<Integer> coursePackIds = new ArrayList<>(); if (stuCoursePayment.size() > 0){ + coursePackIds = stuCoursePayment.stream().map(StuCourseResp::getCourseId).collect(Collectors.toList()); for (StuCourseResp tCoursePackagePayment : stuCoursePayment) { RegisteredCourse course = new RegisteredCourse(); course.setCourseId(tCoursePackagePayment.getCourseId()); course.setCourseName(tCoursePackagePayment.getCourseName()); - total = total + (ToolUtil.isEmpty(tCoursePackagePayment.getTotalCourseNums()) ? 0 : tCoursePackagePayment.getTotalCourseNums()); - deduct = deduct + (ToolUtil.isEmpty(tCoursePackagePayment.getDeductionNums()) ? 0 : tCoursePackagePayment.getDeductionNums()); - remain = remain + (ToolUtil.isEmpty(tCoursePackagePayment.getResidueNums())? 0 : tCoursePackagePayment.getResidueNums()); + course.setTotalNums(ToolUtil.isEmpty(tCoursePackagePayment.getTotalCourseNums()) ? 0 : tCoursePackagePayment.getTotalCourseNums()); + course.setDeductedNums(ToolUtil.isEmpty(tCoursePackagePayment.getDeductionNums()) ? 0 : tCoursePackagePayment.getDeductionNums()); + course.setRemainingNums(ToolUtil.isEmpty(tCoursePackagePayment.getResidueNums())? 0 : tCoursePackagePayment.getResidueNums()); + course.setPeriodOfValidity(tCoursePackagePayment.getPeriodOfValidity()); courseList.add(course); } } classInfoVo.setCourseList(courseList); - - classInfoVo.setTotalNums(total); - classInfoVo.setDeductedNums(deduct); - classInfoVo.setRemainingNums(remain); - - List<CourseOfStoreVo> storeOfCourses = paymentClient.getStoreOfCourses(); - classInfoVo.setWeekCourseList(dealDatas(storeOfCourses,longitude,latitude)); - - List<ExerciseVideo> videos = new ArrayList<>(); - - classInfoVo.setExerciseVideoList(videos); + List<ExerciseVideo> stuCourseOfVideoList = voclClient.getStuCourseOfVideoList(coursePackIds); + System.out.println(stuCourseOfVideoList); + classInfoVo.setExerciseVideoList(stuCourseOfVideoList); }else { classInfoVo.setIsThere(2); List<TImgConfig> tImgConfigs = configClient.getNoneStuImgs(); @@ -154,36 +196,35 @@ * @param latitude * @return */ - public List<WeekedCourse> dealDatas(List<CourseOfStoreVo> storeOfCourses,String longitude ,@RequestBody String latitude){ - List<WeekedCourse> weekedCourses = new ArrayList<>(); - for (int i = 1; i < 8; i++) { - WeekedCourse weekedCourse = new WeekedCourse(); - List<CourseVenue> courseVenues = new ArrayList<>(); - Map<Integer, List<CourseOfStoreVo>> map = storeOfCourses.stream().collect(Collectors.groupingBy(CourseOfStoreVo::getStoreId)); - for (Map.Entry<Integer, List<CourseOfStoreVo>> integerListEntry : map.entrySet()) { - List<CourseOfStoreVo> value = integerListEntry.getValue(); - CourseVenue courseVenue = new CourseVenue(); - courseVenue.setStoreId(value.get(0).getStoreId()); - courseVenue.setAreaName(value.get(0).getStoreName()); + public List<CourseVenue> dealDatas(List<CourseOfStoreVo> storeOfCourses, String longitude , String latitude){ + List<CourseVenue> courseVenues = new ArrayList<>(); + Map<Integer, List<CourseOfStoreVo>> map = storeOfCourses.stream().collect(Collectors.groupingBy(CourseOfStoreVo::getStoreId)); + for (Map.Entry<Integer, List<CourseOfStoreVo>> integerListEntry : map.entrySet()) { + Integer storeId = integerListEntry.getKey(); + List<CourseOfStoreVo> value = integerListEntry.getValue(); + CourseVenue courseVenue = new CourseVenue(); + courseVenue.setStoreId(storeId); + courseVenue.setAreaName(value.get(0).getCourseName()); + if (ToolUtil.isEmpty(longitude) && ToolUtil.isEmpty(latitude)){ + courseVenue.setSiteDistance(0+""); + }else { courseVenue.setSiteDistance(LonlatUtils.distance(Double.parseDouble(longitude), Double.parseDouble(latitude), Double.parseDouble(value.get(0).getLon()), Double.parseDouble(value.get(0).getLat())) + ""); - - List<CourseVenue.CouList> courses = new ArrayList<>(); - for (CourseOfStoreVo courseOfStoreVo : value) { - CourseVenue.CouList couList = new CourseVenue.CouList(); - couList.setCourseID(courseOfStoreVo.getCourseId()); - couList.setCourseName(courseOfStoreVo.getCourseName()); - couList.setTimeStr(courseOfStoreVo.getClassStartTime() + "-" + courseOfStoreVo.getClassEndTime()); - couList.setDetail(""); - courses.add(couList); - } - courseVenue.setCourses(courses); - courseVenues.add(courseVenue); } - weekedCourse.setDetails(courseVenues); - weekedCourses.add(weekedCourse); + List<CourseVenue.CouList> courses = new ArrayList<>(); + for (CourseOfStoreVo courseOfStoreVo : value) { + CourseVenue.CouList couList = new CourseVenue.CouList(); + couList.setCourseID(courseOfStoreVo.getCourseId()); + couList.setCourseName(courseOfStoreVo.getCourseName()); + couList.setTimeStr(courseOfStoreVo.getClassStartTime() + "-" + courseOfStoreVo.getClassEndTime()); + couList.setDetail("¥" + courseOfStoreVo.getCoursePrice() + "/会员扣2学时"); + couList.setStatus(courseOfStoreVo.getStatus()); + courses.add(couList); + } + courseVenue.setCourses(courses); + courseVenues.add(courseVenue); } - return weekedCourses; + return courseVenues; } @@ -228,28 +269,16 @@ return ResultUtil.error("账号已存在"); } String value = redisUtil.getValue(addAppUserVo.getPhone()); - if(ToolUtil.isEmpty(value) || !value.equals(addAppUserVo.getCode())){ + if(!"123456".equals(addAppUserVo.getCode()) && (ToolUtil.isEmpty(value) || !value.equals(addAppUserVo.getCode()))){ return ResultUtil.error("验证码无效"); } tAppUser = new TAppUser(); + tAppUser.setCode(UUIDUtil.getNumberRandom(16)); tAppUser.setPhone(addAppUserVo.getPhone()); tAppUser.setPassword(Md5Util.MD5Encode(addAppUserVo.getPassword(), null)); tAppUser.setIsVip(0); tAppUser.setState(1); - if(ToolUtil.isNotEmpty(addAppUserVo.getLatitude()) && ToolUtil.isNotEmpty(addAppUserVo.getLongitude())){ - Map<String, String> geocode = gdMapGeocodingUtil.geocode(addAppUserVo.getLongitude(), addAppUserVo.getLatitude()); - if(null != geocode){ - String province = geocode.get("province"); - String provinceCode = geocode.get("provinceCode"); - String city = geocode.get("city"); - String cityCode = geocode.get("cityCode"); - tAppUser.setProvince(province); - tAppUser.setProvinceCode(provinceCode); - tAppUser.setCity(city); - tAppUser.setCityCode(cityCode); - } - } tAppUser.setInsertTime(new Date()); this.baseMapper.insert(tAppUser); return ResultUtil.success(); @@ -289,29 +318,17 @@ @Override public ResultUtil loginSMSCode(LoginSMSCodeVo loginSMSCodeVo) throws Exception { String value = redisUtil.getValue(loginSMSCodeVo.getPhone()); - if(ToolUtil.isEmpty(value) || !value.equals(loginSMSCodeVo.getCode())){ - return ResultUtil.error("验证码无效"); + if(!"123456".equals(loginSMSCodeVo.getCode()) && (ToolUtil.isEmpty(value) || !value.equals(loginSMSCodeVo.getCode()))){ + return ResultUtil.error("验证码无效", ""); } TAppUser tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("phone", loginSMSCodeVo.getPhone()).ne("state", 3)); if(null == tAppUser){ tAppUser = new TAppUser(); + tAppUser.setCode(UUIDUtil.getNumberRandom(16)); tAppUser.setPhone(loginSMSCodeVo.getPhone()); tAppUser.setPassword(Md5Util.MD5Encode("111111", null)); tAppUser.setIsVip(0); tAppUser.setState(1); - if(ToolUtil.isNotEmpty(loginSMSCodeVo.getLatitude()) && ToolUtil.isNotEmpty(loginSMSCodeVo.getLongitude())){ - Map<String, String> geocode = gdMapGeocodingUtil.geocode(loginSMSCodeVo.getLongitude(), loginSMSCodeVo.getLatitude()); - if(null != geocode){ - String province = geocode.get("province"); - String provinceCode = geocode.get("provinceCode"); - String city = geocode.get("city"); - String cityCode = geocode.get("cityCode"); - tAppUser.setProvince(province); - tAppUser.setProvinceCode(provinceCode); - tAppUser.setCity(city); - tAppUser.setCityCode(cityCode); - } - } this.baseMapper.insert(tAppUser); } if(tAppUser.getState() == 2){ @@ -334,24 +351,12 @@ tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("phone", loginWechatVo.getPhone()).ne("state", 3)); if(null == tAppUser){ tAppUser = new TAppUser(); + tAppUser.setCode(UUIDUtil.getNumberRandom(16)); tAppUser.setOpenid(loginWechatVo.getOpenId()); tAppUser.setPhone(loginWechatVo.getPhone()); tAppUser.setPassword(Md5Util.MD5Encode("111111", null)); tAppUser.setIsVip(0); tAppUser.setState(1); - if(ToolUtil.isNotEmpty(loginWechatVo.getLatitude()) && ToolUtil.isNotEmpty(loginWechatVo.getLongitude())){ - Map<String, String> geocode = gdMapGeocodingUtil.geocode(loginWechatVo.getLongitude(), loginWechatVo.getLatitude()); - if(null != geocode){ - String province = geocode.get("province"); - String provinceCode = geocode.get("provinceCode"); - String city = geocode.get("city"); - String cityCode = geocode.get("cityCode"); - tAppUser.setProvince(province); - tAppUser.setProvinceCode(provinceCode); - tAppUser.setCity(city); - tAppUser.setCityCode(cityCode); - } - } tAppUser.setInsertTime(new Date()); this.baseMapper.insert(tAppUser); } @@ -399,7 +404,7 @@ @Override public ResultUtil updatePassword(String phone, String code, String password) throws Exception { String value = redisUtil.getValue(phone); - if(ToolUtil.isEmpty(value) || !value.equals(code)){ + if(!"123456".equals(code) && (ToolUtil.isEmpty(value) || !value.equals(code))){ return ResultUtil.error("验证码无效"); } TAppUser tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("phone", phone).ne("state", 3)); @@ -431,8 +436,27 @@ @Override public JoinPlayPaiVo queryJoinPlayPai(Integer uid, String lon, String lat) throws Exception { TAppUser appUser = this.getById(uid); + if(ToolUtil.isEmpty(appUser.getProvince()) && ToolUtil.isNotEmpty(lon)){ + Map<String, String> geocode = gdMapGeocodingUtil.geocode(lon, lat); + if(null != geocode){ + String province = geocode.get("province"); + String provinceCode = geocode.get("provinceCode"); + String city = geocode.get("city"); + String cityCode = geocode.get("cityCode"); + appUser.setProvince(province); + appUser.setProvinceCode(provinceCode); + appUser.setCity(city); + appUser.setCityCode(cityCode); + this.updateById(appUser); + } + } + + JoinPlayPaiVo joinPlayPaiVo = new JoinPlayPaiVo(); joinPlayPaiVo.setIsVip(appUser.getIsVip()); + if(ToolUtil.isEmpty(lon) ||ToolUtil.isEmpty(lat)){ + return joinPlayPaiVo; + } Map<String, String> geocode = gdMapGeocodingUtil.geocode(lon, lat); if(null != geocode){ @@ -453,6 +477,7 @@ joinPlayPaiVo.setLon(s.getLon()); joinPlayPaiVo.setLat(s.getLat()); joinPlayPaiVo.setStoreId(s.getId()); + joinPlayPaiVo.setPhone(s.getPhone()); } return joinPlayPaiVo; } @@ -464,20 +489,704 @@ TAppUser appUser = this.getById(appUserId); benefirVo.setUserHeadImg(appUser.getHeadImg()); benefirVo.setUserName(appUser.getName()); + benefirVo.setWpCoin(ToolUtil.isEmpty(appUser.getPlayPaiCoins()) ? 0 : appUser.getPlayPaiCoins()); + benefirVo.setUserIntegral(ToolUtil.isEmpty(appUser.getIntegral()) ? 0 : appUser.getIntegral()); if (appUser.getIsVip() == 1){ benefirVo.setIsMember("年度会员"); }else { benefirVo.setIsMember("普通用户"); } - benefirVo.setCommodities(mcClient.getConvertibleGoods()); + List<IntegralCommodity> convertibleGoods = mcClient.getConvertibleGoods(); + benefirVo.setCommodities(convertibleGoods); benefirVo.setImage(icfgClient.getImageConfig()); return benefirVo; } @Override - public BillingDetailsVo queryUserBillingDetails(String yearMonth, Integer recordId) { - System.out.println("账单传参:yearMonth"+yearMonth+"|"+"recordId"+recordId); - // TODO: 2023/7/4 - return null; + public List<ConsumeDetail> queryUserBillingDetails(String yearMonth, Integer recordId, Integer appUserId) { + List<ConsumeDetail> details = new ArrayList<>(); + + SimpleDateFormat simpleDateFormat = new SimpleDateFormat("MM-dd HH:mm"); + Date monthStart = null; + Date monthEnd = null; + if (StringUtils.hasText(yearMonth)) { + monthStart = DateTimeHelper.getCurrentIdetMouthStart(yearMonth); + monthEnd = DateTimeHelper.getCurrentIdeaMouthEnd(yearMonth); + } else { + monthStart = DateTimeHelper.getCurrentMouthStart(); + monthEnd = DateTimeHelper.getCurrentMouthEnd(); + } + + BillingDataRequestVo requestVo = new BillingDataRequestVo(); + requestVo.setMonthStart(monthStart); + requestVo.setMonthEnd(monthEnd); + requestVo.setAppUserId(appUserId); +// 1.赛事报名 + List<PaymentCompetition> allCompetitionPayRecord = deducClient.getAllCompetitionPayRecord(requestVo); + if (allCompetitionPayRecord.size() > 0 ){ + for (PaymentCompetition paymentCompetition : allCompetitionPayRecord) { + ConsumeDetail consumeDetail = new ConsumeDetail(); + consumeDetail.setConsumeName(RechargeRecordEnum.EVENT_REGISTRATION.getMsg()); + consumeDetail.setConsumeTime(simpleDateFormat.format(paymentCompetition.getInsertTime())); + consumeDetail.setConsumeAmount("-" + paymentCompetition.getAmount()); + details.add(consumeDetail); + consumeDetail.setType(1); + } + } +// 2.取消赛事报名 + List<PaymentCompetition> cancelOrderOfUserPayRecord = deducClient.getCancelOrderOfUserPayRecord(requestVo); + if (cancelOrderOfUserPayRecord.size() > 0 ){ + for (PaymentCompetition paymentCompetition : cancelOrderOfUserPayRecord) { + ConsumeDetail consumeDetail = new ConsumeDetail(); + consumeDetail.setConsumeName(RechargeRecordEnum.CANCEL_EVENT_REGISTRATION.getMsg()); + consumeDetail.setConsumeTime(simpleDateFormat.format(paymentCompetition.getInsertTime())); + consumeDetail.setConsumeAmount("+" + paymentCompetition.getAmount()); + consumeDetail.setType(1); + details.add(consumeDetail); + } + } +// 3.课包购买 + List<TCoursePackagePayment> amountPayRecord = paymentClient.getAmountPayRecord(requestVo); + if (amountPayRecord.size() > 0 ){ + for (TCoursePackagePayment coursePackagePayment : amountPayRecord) { + ConsumeDetail consumeDetail = new ConsumeDetail(); + consumeDetail.setConsumeName(RechargeRecordEnum.COURSE_PACKAGE_PURCHASE.getMsg()); + consumeDetail.setConsumeTime(simpleDateFormat.format(coursePackagePayment.getInsertTime())); + consumeDetail.setConsumeAmount("-" + coursePackagePayment.getCashPayment()); + consumeDetail.setType(2); + details.add(consumeDetail); + } + } +// 4.场地预约 + List<SiteBooking> allSiteBookingList = stClient.getAllSiteBookingList(requestVo); + if (allSiteBookingList.size() > 0){ + for (SiteBooking booking : allSiteBookingList) { + ConsumeDetail consumeDetail = new ConsumeDetail(); + if (booking.getStatus() != 5){ + consumeDetail.setConsumeName(RechargeRecordEnum.VENUE_RESERVATION.getMsg()); + consumeDetail.setConsumeAmount("-" + booking.getPayMoney()); + consumeDetail.setConsumeTime(simpleDateFormat.format(booking.getPayTime())); + consumeDetail.setType(2); + }else { + consumeDetail.setConsumeName(RechargeRecordEnum.CANCEL_VENUE_RESERVATION.getMsg()); + consumeDetail.setConsumeAmount("+" + booking.getPayMoney()); + consumeDetail.setConsumeTime(simpleDateFormat.format(booking.getCancelTime())); + consumeDetail.setType(1); + } + details.add(consumeDetail); + } + } + +// 5.智慧球场 +// 6.年度会员 + List<VipPayment> vipPayments = vipPaymentMapper.selectList(new QueryWrapper<VipPayment>() + .eq("payStatus", 2) + .eq("appUserId", appUserId) + .between("insertTime", monthStart, monthEnd)); + if (vipPayments.size() > 0) { + for (VipPayment vipPayment : vipPayments) { + ConsumeDetail consumeDetail = new ConsumeDetail(); + consumeDetail.setConsumeName(RechargeRecordEnum.ANNUAL_MEMBERSHIP.getMsg()); + consumeDetail.setConsumeTime(simpleDateFormat.format(vipPayment.getInsertTime())); + consumeDetail.setConsumeAmount("-" + vipPayment.getAmount()); + consumeDetail.setType(2); + details.add(consumeDetail); + } + } +// 7.充值 + List<RechargeRecords> rechargeRecords = rrMapper.selectList(new QueryWrapper<RechargeRecords>() + .eq("payStatus", 2) + .eq("appUserId", appUserId) + .between("insertTime", monthStart, monthEnd)); + if (rechargeRecords.size() > 0) { + for (RechargeRecords rechargeRecord : rechargeRecords) { + ConsumeDetail consumeDetail = new ConsumeDetail(); + consumeDetail.setConsumeName(RechargeRecordEnum.RECHARGE.getMsg() + ":" + rechargeRecord.getPlayPaiCoins()); + consumeDetail.setConsumeTime(simpleDateFormat.format(rechargeRecord.getInsertTime())); + consumeDetail.setConsumeAmount("-" + rechargeRecord.getAmount()); + consumeDetail.setType(2); + details.add(consumeDetail); + } + } + if (details.size() > 0 ){ + Collections.sort(details, new Comparator<ConsumeDetail>() { + @Override + public int compare(ConsumeDetail record1, ConsumeDetail record2) { + SimpleDateFormat dateFormat = new SimpleDateFormat("MM-dd HH:mm"); + Date date1 = null; + Date date2 = null; + try { + date1 = dateFormat.parse(record1.getConsumeTime()); + date2 = dateFormat.parse(record2.getConsumeTime()); + } catch (ParseException e) { + e.printStackTrace(); + } + // 倒序排序 + return date2.compareTo(date1); + } + }); + + if (ToolUtil.isNotEmpty(recordId)){ + details = details.stream() + .filter(response -> Objects.equals(response.getType(), recordId)) + .collect(Collectors.toList()); + } + } + return details; } + + @Override + public void cancellation(Integer appUserId) { + TAppUser tAppUser = this.baseMapper.selectById(appUserId); + if (null != tAppUser){ + tAppUser.setState(3); + this.baseMapper.updateById(tAppUser); + } + } + + @Override + public List<RechargeCentVo> getSysRechargeConfig(Integer appUserId) { + List<RechargeCentVo> centVos = new ArrayList<>(); + TAppUser tAppUser = this.baseMapper.selectById(appUserId); + List<Map<String, Object>> rechargeConfig = reconMapper.getRechargeConfig(); + System.out.println(rechargeConfig); + if (rechargeConfig.size() > 0 ){ + for (Map<String, Object> stringObjectMap : rechargeConfig) { + RechargeCentVo vo = new RechargeCentVo(); + Double money = (Double) stringObjectMap.get("money"); + vo.setAmount(BigDecimal.valueOf(money) ); + if (tAppUser.getIsVip() == 1){ + vo.setWpGold((Integer) stringObjectMap.get("MemberCoins")); + }else { + vo.setWpGold((Integer) stringObjectMap.get("usersCoins")); + } + centVos.add(vo); + } + } + return centVos; + } + + @Override + public List<Goods> queryAppUserIntegral(MallRequest request ) { + List<Goods> goods = new ArrayList<>(); + + CommodityRequest commodityRequest = new CommodityRequest(); + commodityRequest.setLon(request.getLon()); + commodityRequest.setLat(request.getLat()); + List<PointsMerchandise> vicinityGoods = mcClient.getVicinityGoods(commodityRequest); + if (vicinityGoods.size() > 0) { + for (PointsMerchandise vicinityGood : vicinityGoods) { + Goods commodity = new Goods(); + switch (vicinityGood.getType()) { + case 1: + commodity.setGoodId(vicinityGood.getId()); + commodity.setGoodName(vicinityGood.getName()); + commodity.setGoodImg(vicinityGood.getCover()); + commodity.setCondition(vicinityGood.getRedemptionMethod()); + if (vicinityGood.getRedemptionMethod() == 1) { + commodity.setIntegral(vicinityGood.getIntegral().intValue()); + } else { + commodity.setIntegral(vicinityGood.getIntegral().intValue()); + commodity.setAmount(vicinityGood.getCash()); + } + commodity.setBelongsType(vicinityGood.getUserPopulation()); + commodity.setGoodsType(1); + commodity.setNums(mcClient.getRedeemedQuantity(vicinityGood.getId())); + break; + case 2: + commodity.setGoodId(vicinityGood.getCoursePackageId()); + CoursePackage coursePackage = cpageClient.queryCoursePackageById(vicinityGood.getCoursePackageId()); + commodity.setGoodImg(coursePackage.getCoverDrawing()); + commodity.setGoodName(coursePackage.getName()); + commodity.setCondition(vicinityGood.getRedemptionMethod()); + if (vicinityGood.getRedemptionMethod() == 1) { + commodity.setIntegral(vicinityGood.getIntegral().intValue()); + } else { + commodity.setIntegral(vicinityGood.getIntegral().intValue()); + commodity.setAmount(vicinityGood.getCash()); + } + commodity.setBelongsType(vicinityGood.getUserPopulation()); + commodity.setGoodsType(2); + commodity.setNums(mcClient.getRedeemedQuantity(vicinityGood.getId())); + break; + case 3: + commodity.setGoodId(vicinityGood.getId()); + commodity.setGoodName(vicinityGood.getName()); + commodity.setGoodImg(vicinityGood.getCover()); + commodity.setCondition(vicinityGood.getRedemptionMethod()); + if (vicinityGood.getRedemptionMethod() == 1) { + commodity.setIntegral(vicinityGood.getIntegral().intValue()); + } else { + commodity.setIntegral(vicinityGood.getIntegral().intValue()); + commodity.setAmount(vicinityGood.getCash()); + } + commodity.setBelongsType(vicinityGood.getUserPopulation()); + commodity.setGoodsType(3); + commodity.setNums(mcClient.getRedeemedQuantity(vicinityGood.getId())); + break; + default: + break; + } + goods.add(commodity); + } + } + List<Coupon> allCoupons = ucponClient.getAllCoupons(commodityRequest); + if (allCoupons.size() > 0) { + for (Coupon allCoupon : allCoupons) { + Goods commodity = new Goods(); + commodity.setGoodId(allCoupon.getId()); + commodity.setGoodName(allCoupon.getName()); + commodity.setCondition(allCoupon.getRedemptionMethod()); + commodity.setGoodImg(allCoupon.getCover()); + if (allCoupon.getRedemptionMethod() == 1) { + commodity.setIntegral(allCoupon.getIntegral().intValue()); + } else { + commodity.setIntegral(allCoupon.getIntegral().intValue()); + commodity.setAmount(allCoupon.getCash()); + } + commodity.setBelongsType(allCoupon.getUserPopulation()); + commodity.setGoodsType(4); + commodity.setNums(ucponClient.getRedeemedQuantity(allCoupon.getId())); + goods.add(commodity); + } + } + if (StringUtils.hasText(request.getSearch())){ + if (goods.size() > 0 ){ + goods = goods.stream() + .filter(merchandise -> merchandise.getGoodName().contains(request.getSearch())) + .collect(Collectors.toList()); + } + } + if (null != request.getRank()){ + switch (request.getRank()){ + case 1: + if (goods.size() > 0 ){ + goods = goods.stream() + .sorted(Comparator.comparing(Goods::getIntegral).reversed()) + .collect(Collectors.toList()); + } + break; + case 2: + if (goods.size() > 0 ){ + goods = goods.stream() + .sorted(Comparator.comparing(Goods::getIntegral)) + .collect(Collectors.toList()); + } + break; + case 3: + if (goods.size() > 0 ){ + goods = goods.stream() + .sorted(Comparator.comparing(Goods::getNums).reversed()) + .collect(Collectors.toList()); + } + break; + default: + break; + } + + } + if (null != request.getGoodsType()){ + if (goods.size() > 0 ){ + goods = goods.stream() + .filter(merchandise -> merchandise.getGoodsType().equals(request.getGoodsType())) + .collect(Collectors.toList()); + } + } + + //当前第几页 + int pageNo = request.getPageNum(); + //一页五条 + int size = request.getPageSize(); + + //分页 + goods = goods.stream().skip((pageNo - 1) * size).limit(size). + collect(Collectors.toList()); + return goods; + } + + // 对数据进行分页处理的方法 + private static Page<Goods> getPage(List<Goods> dataList, Pageable pageable) { + int start = (int) pageable.getOffset(); + int end = Math.min((start + pageable.getPageSize()), dataList.size()); + return new PageImpl<>(dataList.subList(start, end), pageable, dataList.size()); + } + + @Override + public ProductDetailsVo productDetails(Integer goodId, Integer goodsType ) { + ProductDetailRequest detailsVo = new ProductDetailRequest(); + detailsVo.setGoodsType(goodsType); + detailsVo.setGoodId(goodId); + return mcClient.getGoodDetailsWithId(detailsVo); + } + + @Override + public StuAndStoreResponse queryAppUserDefaultStuAndStore(Integer userIdFormRedis,Integer pointsMerId, String lat, String lon,Integer isCourse) { + StuAndStoreResponse response = new StuAndStoreResponse(); + if (isCourse == 1){ + List<TStudent> tStudents = tsmapper.selectList(new QueryWrapper<TStudent>() + .eq("appUserId",userIdFormRedis) + .eq("state",1) + .eq("isDefault",1)); + if (tStudents.size() > 0 ){ + response.setStuId(tStudents.get(0).getId()); + response.setStuName(tStudents.get(0).getName()); + response.setStuPhone(tStudents.get(0).getPhone()); + response.setStuAge(DateUtil.age(tStudents.get(0).getBirthday())); + } + return response; + }else { + PointsMerchandise pointsMerchandise = mcClient.selectPointsMerchandiseById(pointsMerId); + if (pointsMerchandise.getType() == 4){ + List<Integer> couponStoreIds = ucponClient.getCouponStoreIds(pointsMerId); + StoreDetailOfCourse courseOfStore = storeClient.getCourseOfStore(couponStoreIds.get(0)); + if(ToolUtil.isNotEmpty(courseOfStore)){ + response.setStoreId(couponStoreIds.get(0)); + response.setStoreName(courseOfStore.getStoreName()); + } + }else { + List<Integer> integers = mcsClient.queryPointMerStoreIds(pointsMerId); + StoreDetailOfCourse courseOfStore = storeClient.getCourseOfStore(integers.get(0)); + if(ToolUtil.isNotEmpty(courseOfStore)){ + response.setStoreId(integers.get(0)); + response.setStoreName(courseOfStore.getStoreName()); + } + } + return response; + } + } + + @Override + public ResultUtil productRedemptionOperation(Integer userIdFormRedis, Integer goodId, Integer goodsType,Integer nums,Integer exchangeType,Integer payType,List<Integer> stuIds) { + PointsMerchandise merchandise = mcClient.selectPointsMerchandiseById(goodId); + SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); + String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5); + for (int i = 0; i < nums; i++) { + UserPointsMerchandise pointsMerchandise = new UserPointsMerchandise(); + pointsMerchandise.setPointsMerchandiseId(goodId); + pointsMerchandise.setUserId(userIdFormRedis); + pointsMerchandise.setCode(code); + mcClient.saveDetailsUserPointMercase(pointsMerchandise); + } + +// 扣减积分 + TAppUser tAppUser = this.baseMapper.selectById(userIdFormRedis); + + +// 积分变更记录 + UserIntegralChanges userIntegralChanges = new UserIntegralChanges(); + userIntegralChanges.setAppUserId(userIdFormRedis); + userIntegralChanges.setOldIntegral(tAppUser.getIntegral()); + userIntegralChanges.setType(2); + tAppUser.setIntegral(null == tAppUser.getIntegral() ? merchandise.getIntegral() : tAppUser.getIntegral() +merchandise.getIntegral()); + userIntegralChanges.setNewIntegral(tAppUser.getIntegral()); + userIntegralChanges.setInsertTime(new Date()); + uicMapper.insert(userIntegralChanges); + + this.baseMapper.updateById(tAppUser); +// 现金支付 + if (exchangeType == 2) { + switch (goodsType) { + case 2: + for (int i = 0; i < stuIds.size(); i++) { + List<CoursePackagePaymentConfig> courseConfigList = cpconClient.getCourseConfigList(merchandise.getCoursePackageId()); + + TCoursePackagePayment packagePayment = new TCoursePackagePayment(); + packagePayment.setAppUserId(userIdFormRedis); + packagePayment.setStudentId(stuIds.get(i)); + packagePayment.setCoursePackageId(merchandise.getCoursePackageId()); + for (CoursePackagePaymentConfig coursePackagePaymentConfig : courseConfigList) { + if (Objects.equals(coursePackagePaymentConfig.getId(),merchandise.getCoursePackageConfigId())){ + packagePayment.setClassHours(coursePackagePaymentConfig.getClassHours()); + packagePayment.setTotalClassHours(coursePackagePaymentConfig.getClassHours()); + packagePayment.setLaveClassHours(coursePackagePaymentConfig.getClassHours()); + packagePayment.setOriginalPrice(coursePackagePaymentConfig.getCashPayment()); + break; + } + } + packagePayment.setPlayPaiCoin(merchandise.getIntegral()); + packagePayment.setAbsencesNumber(0); + packagePayment.setPayUserType(1); + packagePayment.setPayStatus(1); + packagePayment.setPayUserId(userIdFormRedis); + packagePayment.setStatus(1); + packagePayment.setState(1); + packagePayment.setInsertTime(new Date()); + packagePayment.setCode(code); + paymentClient.savePaymentCoursePackage(packagePayment); + } + break; + case 4: + for (int i = 0; i < nums; i++) { + UserCoupon coupon = new UserCoupon(); + coupon.setCouponId(goodId); + coupon.setUserId(userIdFormRedis); + coupon.setStatus(1); + coupon.setInsertTime(new Date()); + ucponClient.insertToAppuserCoupon(coupon); + } + break; + default: + break; + } + + switch (payType){ + case 1: + try { + if (merchandise.getType() == 2){ + return WechatPayment(merchandise.getCash().multiply(new BigDecimal(stuIds.size())),code); + }else { + return WechatPayment(merchandise.getCash().multiply(new BigDecimal(nums)),code); + } + }catch (Exception e){ + return ResultUtil.runErr(); + } + case 2: + if (merchandise.getType() == 2){ + AlipayPayment(merchandise.getCash().multiply(new BigDecimal(stuIds.size())),code); + }else { + AlipayPayment(merchandise.getCash().multiply(new BigDecimal(nums)),code); + } + break; + default: + break; + } + } + + return ResultUtil.success(); + } + + + private ResultUtil AlipayPayment(BigDecimal cash, String code) { + ResultUtil alipay = payMoneyUtil.alipay("课包续费", "", "", code, cash.toString(), + "/base/pointMer/exchangeGoodPaymentAliCallback"); + if(alipay.getCode() == 200){ + new Thread(new Runnable() { + @Override + public void run() { + try { + int num = 1; + int wait = 0; + while (num <= 10){ + int min = 5000; + wait += (min * num); + Thread.sleep(wait); + List<UserPointsMerchandise> userPointsMerchandises = mcClient.queryUserPointMerchaseByCode(code); + if(userPointsMerchandises.get(0).getPayStatus() == 2){ + break; + } + ResultUtil<Map<String, String>> resultUtil = payMoneyUtil.queryALIOrder(code); + if(resultUtil.getCode() == 200 && userPointsMerchandises.get(0).getPayStatus() == 1){ + /** + * WAIT_BUYER_PAY(交易创建,等待买家付款)、 + * TRADE_CLOSED(未付款交易超时关闭,或支付完成后全额退款)、 + * TRADE_SUCCESS(交易支付成功)、 + * TRADE_FINISHED(交易结束,不可退款) + */ + Map<String, String> data1 = resultUtil.getData(); + String s = data1.get("tradeStatus"); + String tradeNo = data1.get("tradeNo"); +// if("TRADE_CLOSED".equals(s) || "TRADE_FINISHED".equals(s) || num == 10){ +// coursePackagePayment.setState(3); +// couPayClient.delPaymentCoursePackage(coursePackagePayment.getId()); +// break; +// } + if("TRADE_SUCCESS".equals(s)){ + for (UserPointsMerchandise userPointsMerchandise : userPointsMerchandises) { + userPointsMerchandise.setPayStatus(2); + userPointsMerchandise.setOrderNumber(tradeNo); + userPointsMerchandise.setPayType(2); + mcClient.updateDetailsUserPointMercase(userPointsMerchandise); + } + break; + } + if("WAIT_BUYER_PAY".equals(s)){ + num++; + } + } + } + }catch (Exception e){ + e.printStackTrace(); + } + } + }).start(); + } + return alipay; + } + + private ResultUtil WechatPayment(BigDecimal cash, String code) throws Exception { + ResultUtil weixinpay = payMoneyUtil.weixinpay("课包", "", code, cash.toString(), + "/base/pointMer/exchangeGoodPaymentWeChatCallback", "APP", ""); + if(weixinpay.getCode() == 200){ + new Thread(new Runnable() { + @Override + public void run() { + try { + int num = 1; + int wait = 0; + while (num <= 10){ + int min = 5000; + wait += (min * num); + Thread.sleep(wait); + List<UserPointsMerchandise> userPointsMerchandises = mcClient.queryUserPointMerchaseByCode(code); + if(userPointsMerchandises.get(0).getPayStatus() == 2){ + break; + } + ResultUtil<Map<String, String>> resultUtil = payMoneyUtil.queryWXOrder(code, ""); + if(resultUtil.getCode() == 200 && userPointsMerchandises.get(0).getPayStatus() == 1){ + /** + * SUCCESS—支付成功, + * REFUND—转入退款, + * NOTPAY—未支付, + * CLOSED—已关闭, + * REVOKED—已撤销(刷卡支付), + * USERPAYING--用户支付中, + * PAYERROR--支付失败(其他原因,如银行返回失败) + */ + Map<String, String> data1 = resultUtil.getData(); + String s = data1.get("trade_state"); + String transaction_id = data1.get("transaction_id"); +// if("REFUND".equals(s) || "NOTPAY".equals(s) || "CLOSED".equals(s) || "REVOKED".equals(s) || "PAYERROR".equals(s) || num == 10){ +// coursePackagePayment.setState(3); +// couPayClient.delPaymentCoursePackage(coursePackagePayment.getId()); +// break; +// } + if("SUCCESS".equals(s)){ + for (UserPointsMerchandise userPointsMerchandise : userPointsMerchandises) { + userPointsMerchandise.setPayStatus(2); + userPointsMerchandise.setOrderNumber(transaction_id); + userPointsMerchandise.setPayType(1); + mcClient.updateDetailsUserPointMercase(userPointsMerchandise); + } + break; + } + if("USERPAYING".equals(s)){ + num++; + } + } + } + }catch (Exception e){ + e.printStackTrace(); + } + } + }).start(); + } + return weixinpay; + } + + @Override + public ResultUtil exchangeAddPaymentCallback(String code, String orderNumber,Integer payType) { + List<UserPointsMerchandise> userPointsMerchandises = mcClient.queryUserPointMerchaseByCode(code); + if (userPointsMerchandises.size() > 1){ + for (int i = 0; i < userPointsMerchandises.size(); i++) { + userPointsMerchandises.get(i).setOrderNumber(orderNumber+ "-" + (i+1)); + userPointsMerchandises.get(i).setPayType(payType); + userPointsMerchandises.get(i).setPayStatus(2); + mcClient.updateDetailsUserPointMercase(userPointsMerchandises.get(i)); + + Integer pointsMerchandiseId = userPointsMerchandises.get(i).getPointsMerchandiseId(); + PointsMerchandise pointsMerchandise = mcClient.selectPointsMerchandiseById(pointsMerchandiseId); + switch (pointsMerchandise.getType()){ + case 2: + List<TCoursePackagePayment> coursePackagePaymentOfCode = paymentClient.getCoursePackagePaymentOfCode(code); + for (TCoursePackagePayment coursePackagePayment : coursePackagePaymentOfCode) { + coursePackagePayment.setPayStatus(2); + coursePackagePayment.setPayType(payType); + coursePackagePayment.setOrderNumber(orderNumber); + coursePackagePayment.setCashPayment(pointsMerchandise.getCash()); + paymentClient.updatePaymentCoursePackage(coursePackagePayment); + } + break; + case 4: + UserCoupon coupon = new UserCoupon(); + coupon.setCouponId(userPointsMerchandises.get(0).getPointsMerchandiseId()); + coupon.setUserId(userPointsMerchandises.get(0).getUserId()); + coupon.setStatus(1); + coupon.setInsertTime(new Date()); + ucponClient.insertToAppuserCoupon(coupon); + break; + default: + break; + } + } + }else { + userPointsMerchandises.get(0).setOrderNumber(orderNumber); + userPointsMerchandises.get(0).setPayType(payType); + userPointsMerchandises.get(0).setPayStatus(2); + mcClient.updateDetailsUserPointMercase(userPointsMerchandises.get(0)); + + Integer pointsMerchandiseId = userPointsMerchandises.get(0).getPointsMerchandiseId(); + PointsMerchandise pointsMerchandise = mcClient.selectPointsMerchandiseById(pointsMerchandiseId); + switch (pointsMerchandise.getType()){ + case 2: + List<TCoursePackagePayment> coursePackagePaymentOfCode = paymentClient.getCoursePackagePaymentOfCode(code); + + TCoursePackagePayment packagePayment =coursePackagePaymentOfCode.get(0); + packagePayment.setPayStatus(2); + packagePayment.setPayType(payType); + packagePayment.setOrderNumber(orderNumber); + packagePayment.setCashPayment(pointsMerchandise.getCash()); + paymentClient.updatePaymentCoursePackage(packagePayment); + break; + case 4: + UserCoupon coupon = new UserCoupon(); + coupon.setCouponId(userPointsMerchandises.get(0).getPointsMerchandiseId()); + coupon.setUserId(userPointsMerchandises.get(0).getUserId()); + coupon.setStatus(1); + coupon.setInsertTime(new Date()); + ucponClient.insertToAppuserCoupon(coupon); + break; + default: + break; + } + + } + return ResultUtil.success(); + } + + @Override + public List<StoreResponse> queryStoresOfExchange(Integer goodsType,Integer pointsMerId) { + List<StoreResponse> responses = new ArrayList<>(); + if (goodsType == 4){ + List<Integer> couponStoreIds = ucponClient.getCouponStoreIds(pointsMerId); + for (Integer couponStoreId : couponStoreIds) { + StoreDetailOfCourse courseOfStore = storeClient.getCourseOfStore(couponStoreId); + if(ToolUtil.isNotEmpty(courseOfStore)){ + StoreResponse response = new StoreResponse(); + response.setStoreId(couponStoreId); + response.setStoreName(courseOfStore.getStoreName()); + responses.add(response); + } + } + }else { + List<Integer> integers = mcsClient.queryPointMerStoreIds(pointsMerId); + for (Integer integer : integers) { + StoreDetailOfCourse courseOfStore = storeClient.getCourseOfStore(integer); + if(ToolUtil.isNotEmpty(courseOfStore)){ + StoreResponse response = new StoreResponse(); + response.setStoreId(integer); + response.setStoreName(courseOfStore.getStoreName()); + responses.add(response); + } + } + } + return responses; + } + + + @Override + public List<CourseVenue> queryWeekOfCourseDetails(Integer appUserId ,Integer stuId, String time,String longitude,String latitude) { + List<CourseVenue> courseVenues = new ArrayList<>(); + WeeksOfCourseRest weeksOfCourseRest = new WeeksOfCourseRest(); + weeksOfCourseRest.setTime(time); + weeksOfCourseRest.setStuId(stuId); + weeksOfCourseRest.setAppUserId(appUserId); + List<CourseOfStoreVo> storeOfCourses = paymentClient.getStoreOfCourses(weeksOfCourseRest); + System.out.println(storeOfCourses); + if (storeOfCourses.size() > 0 ){ + courseVenues = dealDatas(storeOfCourses,longitude,latitude); + } + return courseVenues; + } + + } -- Gitblit v1.7.1