From b64d67ef01e81a857046f19dd556b4e4f0695e1c Mon Sep 17 00:00:00 2001 From: liujie <liujie> Date: 星期三, 02 八月 2023 16:41:51 +0800 Subject: [PATCH] 后台代码 门店管理 --- cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java | 1148 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 1,133 insertions(+), 15 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 e401e8d..ebc7574 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 @@ -1,21 +1,60 @@ package com.dsh.account.service.impl; -import com.baomidou.mybatisplus.mapper.EntityWrapper; -import com.dsh.account.mapper.TStudentMapper; + +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +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.*; 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.service.TAppUserService; -import com.dsh.account.entity.TAppUser; -import com.dsh.account.entity.TStudent; -import com.dsh.account.mapper.TAppUserMapper; +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.classInsVo.ClassInfoVo; -import com.baomidou.mybatisplus.service.impl.ServiceImpl; -import com.dsh.account.util.ToolUtil; +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.util.StringUtils; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; -import java.util.List; +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; /** * <p> @@ -28,22 +67,111 @@ @Service public class TAppUserServiceImpl extends ServiceImpl<TAppUserMapper, TAppUser> implements TAppUserService { - @Autowired + + @Resource private TStudentMapper tsmapper; @Resource private ImgConfigClient configClient; + @Autowired + private ALiSendSms aLiSendSms; + + @Autowired + private RedisUtil redisUtil; + + @Autowired + private GDMapGeocodingUtil gdMapGeocodingUtil; + + @Autowired + private JwtTokenUtil jwtTokenUtil; + + @Resource + private CoursePaymentClient paymentClient; + + @Resource + private StoreClient storeClient; + + @Resource + private MerChandiseClient mcClient; + + @Resource + private ImgConfigClient icfgClient; + + @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) { TAppUser tAppUser = this.baseMapper.selectById(id); + ClassInfoVo classInfoVo = new ClassInfoVo(); if (ToolUtil.isNotEmpty(tAppUser)){ - List<TStudent> tStudents = tsmapper.selectList(new EntityWrapper<TStudent>() + List<TStudent> tStudents = tsmapper.selectList(new QueryWrapper<TStudent>() .eq("appUserId",tAppUser.getId()) - .eq("state",1)); - ClassInfoVo classInfoVo = new ClassInfoVo(); - if (null != tStudents){ + .eq("state",1) + .eq("isDefault",1)); + if (tStudents.size() > 0 ){ + TStudent tStudent = tStudents.get(0); + classInfoVo.setStuId(tStudent.getId()); + classInfoVo.setIsThere(1); + classInfoVo.setStuImg(tStudent.getHeadImg()); + classInfoVo.setStuSex(tStudent.getSex()); + classInfoVo.setStuAge(DateUtil.age(tStudent.getBirthday())); + classInfoVo.setStuName(tStudent.getName()); + classInfoVo.setHeight(tStudent.getHeight()); + classInfoVo.setWeight(tStudent.getWeight()); + classInfoVo.setBmi(tStudent.getBmi()); + classInfoVo.setBodyStatus(BMIBodyUtil.getBodyStatus(tStudent.getBmi())); + List<RegisteredCourse> courseList = new ArrayList<>(); + List<StuCourseResp> stuCoursePayment = paymentClient.getStuCoursePayment(tStudent.getId()); + if (stuCoursePayment.size() > 0){ + for (StuCourseResp tCoursePackagePayment : stuCoursePayment) { + RegisteredCourse course = new RegisteredCourse(); + course.setCourseId(tCoursePackagePayment.getCourseId()); + course.setCourseName(tCoursePackagePayment.getCourseName()); + 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); + + List<ExerciseVideo> videos = new ArrayList<>(); + + classInfoVo.setExerciseVideoList(videos); }else { classInfoVo.setIsThere(2); List<TImgConfig> tImgConfigs = configClient.getNoneStuImgs(); @@ -52,6 +180,996 @@ } } } - return null; + return classInfoVo; } + + /** + * 处理数据 + * @param storeOfCourses + * @param longitude + * @param latitude + * @return + */ + 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()); + 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("¥" + courseOfStoreVo.getCoursePrice() + "/会员扣2学时"); + courses.add(couList); + } + courseVenue.setCourses(courses); + courseVenues.add(courseVenue); + } + return courseVenues; + } + + + /** + * 获取短信验证码 + * @param type 1:登录,2:注册,3:修改密码,4:忘记密码 + * @param phone + * @return + * @throws Exception + */ + @Override + public ResultUtil getSMSCode(Integer type, String phone) throws Exception { + if(type == 2){ + TAppUser tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("phone", phone).ne("state", 3)); + if(null != tAppUser){ + return ResultUtil.error("账号已存在"); + } + } + String numberRandom = UUIDUtil.getNumberRandom(6); + String templateCode = ""; + if(type == 1 || type == 2){ + templateCode = "SMS_161275250"; + } + if(type == 3 || type == 4){ + templateCode = "SMS_160960014"; + } + aLiSendSms.sendSms(phone, templateCode, "{\"code\":\"" + numberRandom + "\"}"); + redisUtil.setStrValue(phone, numberRandom, 300); + return ResultUtil.success(); + } + + + /** + * 注册用户 + * @return + * @throws Exception + */ + @Override + public ResultUtil addAppUser(AddAppUserVo addAppUserVo) throws Exception { + TAppUser tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("phone", addAppUserVo.getPhone()).ne("state", 3)); + if(null != tAppUser){ + return ResultUtil.error("账号已存在"); + } + String value = redisUtil.getValue(addAppUserVo.getPhone()); + 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); + tAppUser.setInsertTime(new Date()); + this.baseMapper.insert(tAppUser); + return ResultUtil.success(); + } + + + /** + * 账号密码登录 + * @param phone + * @param password + * @return + * @throws Exception + */ + @Override + public ResultUtil loginPassword(String phone, String password) throws Exception { + TAppUser tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("phone", phone).ne("state", 3)); + if(null == tAppUser){ + return ResultUtil.error("请先注册", ""); + } + if(tAppUser.getState() == 2){ + return ResultUtil.error("您的账号已被冻结", ""); + } + password = Md5Util.MD5Encode(password, null); + if(!tAppUser.getPassword().equals(password)){ + return ResultUtil.error("账号密码错误", ""); + } + String token = getToken(tAppUser); + return ResultUtil.success(token); + } + + + /** + * 验证码登录 + * @return + * @throws Exception + */ + @Override + public ResultUtil loginSMSCode(LoginSMSCodeVo loginSMSCodeVo) throws Exception { + String value = redisUtil.getValue(loginSMSCodeVo.getPhone()); + 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); + this.baseMapper.insert(tAppUser); + } + if(tAppUser.getState() == 2){ + return ResultUtil.error("您的账号已被冻结", ""); + } + String token = getToken(tAppUser); + return ResultUtil.success(token); + } + + + /** + * 微信登录 + * @return + * @throws Exception + */ + @Override + public ResultUtil loginWechat(LoginWeChatVo loginWechatVo) throws Exception { + TAppUser tAppUser = this.baseMapper.selectOne(new QueryWrapper<TAppUser>().eq("openid", loginWechatVo.getOpenId()).ne("state", 3)); + if(null == tAppUser){ + 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); + tAppUser.setInsertTime(new Date()); + this.baseMapper.insert(tAppUser); + } + } + if(tAppUser.getState() == 2){ + return ResultUtil.error("您的账号已被冻结", ""); + } + + if(ToolUtil.isNotEmpty(tAppUser.getOpenid())){ + tAppUser.setOpenid(loginWechatVo.getOpenId()); + } + if(ToolUtil.isNotEmpty(tAppUser.getPhone())){ + tAppUser.setPhone(loginWechatVo.getPhone()); + } + this.updateById(tAppUser); + + String token = getToken(tAppUser); + return ResultUtil.success(token); + } + + + /** + * 获取JWT token和存储个人信息 + * @param appUser + * @return + */ + private String getToken(TAppUser appUser){ + String randomKey = jwtTokenUtil.getRandomKey(); + String token = jwtTokenUtil.generateToken(appUser.getId().toString(), randomKey); + redisUtil.setStrValue(token.substring(token.length() - 32), String.valueOf(appUser.getId()), 7 * 24 * 60 * 60); + redisUtil.setStrValue("USER_" + appUser.getPhone(), token.substring(token.length() - 32)); + redisUtil.setStrValue("USER_" + appUser.getId(), token); + return token; + } + + + /** + * 修改密码 + * @param phone + * @param code + * @param password + * @return + * @throws Exception + */ + @Override + public ResultUtil updatePassword(String phone, String code, String password) throws Exception { + String value = redisUtil.getValue(phone); + 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)); + if(tAppUser.getState() == 2){ + return ResultUtil.error("您的账号已被冻结", ""); + } + tAppUser.setPassword(Md5Util.MD5Encode(password, null)); + this.updateById(tAppUser); + return ResultUtil.success(); + } + + + /** + * 定时任务修改到期会员的状态 + */ + @Override + public void membershipEnd() { + this.baseMapper.membershipEnd(); + } + + + /** + * 获取加入玩湃首页数据 + * @param lon + * @param lat + * @return + * @throws Exception + */ + @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){ + String provinceCode = geocode.get("provinceCode"); + String cityCode = geocode.get("cityCode"); + List<Store> stores = storeClient.queryStoreList(new QueryStoreList(provinceCode, cityCode)); + Store s = null; + Double d = 0D; + for (Store store : stores) { + Map<String, Double> distance = GeodesyUtil.getDistance(lon + "," + lat, store.getLon() + "," + store.getLat()); + Double wgs84 = distance.get("WGS84"); + if(s == null || d.compareTo(wgs84) < 0){ + s = store; + d = wgs84; + } + } + joinPlayPaiVo.setName(s.getName()); + joinPlayPaiVo.setLon(s.getLon()); + joinPlayPaiVo.setLat(s.getLat()); + joinPlayPaiVo.setStoreId(s.getId()); + joinPlayPaiVo.setPhone(s.getPhone()); + } + return joinPlayPaiVo; + } + + @Override + public IndexOfUserBenefirVo queryBenefitDetails(Integer appUserId) { + IndexOfUserBenefirVo benefirVo = new IndexOfUserBenefirVo(); + + TAppUser appUser = this.getById(appUserId); + benefirVo.setUserHeadImg(appUser.getHeadImg()); + benefirVo.setUserName(appUser.getName()); + if (appUser.getIsVip() == 1){ + benefirVo.setIsMember("年度会员"); + }else { + benefirVo.setIsMember("普通用户"); + } + List<IntegralCommodity> convertibleGoods = mcClient.getConvertibleGoods(); + benefirVo.setCommodities(convertibleGoods); + benefirVo.setImage(icfgClient.getImageConfig()); + return benefirVo; + } + + @Override + 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(); + if (rechargeConfig.size() > 0 ){ + for (Map<String, Object> stringObjectMap : rechargeConfig) { + RechargeCentVo vo = new RechargeCentVo(); + vo.setChargeId((Integer) stringObjectMap.get("money")); + vo.setAmount(""+stringObjectMap.get("money")); + if (tAppUser.getIsVip() == 1){ + vo.setWpGold(stringObjectMap.get("MemberCoins")+""); + }else { + vo.setWpGold(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())){ + goods = goods.stream() + .filter(merchandise -> merchandise.getGoodName().contains(request.getSearch())) + .collect(Collectors.toList()); + } + if (null != request.getRank()){ + switch (request.getRank()){ + case 1: + goods = goods.stream() + .sorted(Comparator.comparing(Goods::getIntegral).reversed()) + .collect(Collectors.toList()); + break; + case 2: + goods = goods.stream() + .sorted(Comparator.comparing(Goods::getIntegral)) + .collect(Collectors.toList()); + break; + case 3: + goods = goods.stream() + .sorted(Comparator.comparing(Goods::getNums).reversed()) + .collect(Collectors.toList()); + break; + default: + break; + } + + } + if (null != request.getGoodsType()){ + goods = goods.stream() + .filter(merchandise -> merchandise.getGoodsType().equals(request.getGoodsType())) + .collect(Collectors.toList()); + } + Pageable pageable = PageRequest.of(request.getPageNum() - 1, request.getPageSize()); + Page<Goods> page = getPage(goods, pageable); + return page.getContent(); + } + + // 对数据进行分页处理的方法 + 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 ResultUtil uploadAppUserHeadImg(Integer appUserId, MultipartFile file, HttpServletRequest request) { + try { + String filePath = OssUploadUtil.ossUpload(request,file); + TAppUser tAppUser = this.baseMapper.selectById(appUserId); + tAppUser.setHeadImg(filePath); + this.baseMapper.updateById(tAppUser); + } catch (IOException e) { + ResultUtil.error("头像上传失败!"); + } + + return ResultUtil.success(); + } + + @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); + if (storeOfCourses.size() > 0 ){ + courseVenues = dealDatas(storeOfCourses,longitude,latitude); + } + return courseVenues; + } + + } -- Gitblit v1.7.1