package com.dsh.account.service.impl; import com.alibaba.fastjson.JSONObject; import com.alipay.api.AlipayApiException; import com.alipay.api.AlipayClient; import com.alipay.api.DefaultAlipayClient; import com.alipay.api.domain.AlipayTradeOrderSettleModel; import com.alipay.api.domain.OpenApiRoyaltyDetailInfoPojo; import com.alipay.api.domain.RoyaltyDetailInfos; import com.alipay.api.request.AlipayTradeOrderSettleRequest; import com.alipay.api.request.AlipayTradeRoyaltyRelationBindRequest; import com.alipay.api.response.AlipayTradeOrderSettleResponse; import com.alipay.api.response.AlipayTradeQueryResponse; import com.alipay.api.response.AlipayTradeRoyaltyRelationBindResponse; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.dsh.account.dto.BindDto; import com.dsh.account.dto.SelectDto; import com.dsh.account.dto.UpdateInfoDto; import com.dsh.account.dto.UserInfoQueryDTO; import com.dsh.account.entity.*; import com.dsh.account.enums.RechargeRecordEnum; import com.dsh.account.feignclient.activity.IntroduceRewardsClient; 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.competition.model.PurchaseRecordVo; 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.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.*; import com.dsh.account.model.*; import com.dsh.account.model.dto.Coupon; import com.dsh.account.model.query.appUserQuery.QueryAppUser; import com.dsh.account.model.vo.DetailsListVo; import com.dsh.account.model.vo.QueryAppUserVO; 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.dsh.account.model.vo.userBenefitDetail.*; import com.dsh.account.service.TAppGiftService; import com.dsh.account.service.TAppUserService; import com.dsh.account.util.*; import com.dsh.account.util.akeylogin.Md5Util; import com.dsh.account.vo.GroupCityInfoVO; import com.dsh.account.vo.entity.DayData; import com.dsh.account.vo.entity.MonthData; import com.dsh.account.vo.entity.WeekData; import com.dsh.account.vo.entity.YearData; 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.transaction.annotation.Transactional; import org.springframework.util.StringUtils; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import java.io.IOException; import java.math.BigDecimal; import java.text.ParseException; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.util.*; import java.util.stream.Collectors; /** *

* 用户信息 服务实现类 *

* * @author administrator * @since 2023-06-14 */ @Service public class TAppUserServiceImpl extends ServiceImpl implements TAppUserService { @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 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; @Autowired private TAppUserMapper appUserMapper; @Autowired private TAppGiftService appGiftService; @Autowired private IntroduceRewardsClient introduceRewardsClient; private String aliAppid = "2021004105665036";//支付宝appid private String appPrivateKey = "MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCi5i9nW/hGLJ3A06cZxTQdviFC7THpdSihoTYGLr9q006hu0V26ecBMY/o4w5bvIX0Ok/yofmZsVcCJpAPvbXL/uqVrIjnRRxXiaeBFThlxoBUTdunvbUSDYfzlEhJr5NvUKI6H6lz2niXlQGx4qy8Hau4ccWit9kM8jwUvsBVQoFgJA+xrjMvooA7YLopQtpOD+UJr5thApTSf1xrnr1W12yolTLEH15JmNV372cqXrYUuqnY0QsaPtxeqJUGAOcGdVLllQ7easEznP8DFBvDdHATcmp2SHNQDUEWN6MCVPbMgY06NQVqAXxqjTAYSVh+6TRu6bofPmpYC3TZB003AgMBAAECggEBAJAcR2+PA3NBYUYHeFrqBRMS8uX8ZR19kjZ7IgoSLTFaQsP9opRylPSPXhrPVBKAE5leRQAHn4MCSlESwHvMfxo7KFjFTFAc6dffZZpipYQUOc9bGampwJh58/3e/pyBgVMG6J23CPf/HJQtNFSkjd/V9+ayb/9l2dUEL3bC0fAZ/dbx8HsxdLw8wn3fLlWLj68hOMqa2deCZe3JdSVsPbeWqkh56FFsMLug0Nd+Ar4TgRl9/jnhXF0JWiD0LmPUYLhboY7EfUBzN4w1iYbDi1P+3zvoOYsiVKAXox9GMhQ2VzOO2UcSTuizSza2e98mGpabl/GpKmCz+RDFjtkX6eECgYEA2MyCij65eO3aGIm3FUe93DULRBYTfX8qJQSJq2WOWA3mmQlEW6L3O2B5/lG2h+8WmN6iLEs9eHpgycGYp7vAqgrANEn16ACVcuyx0scFtrZfZ+kmHMzFfiUWxJjVYk/6YngsGVBLdw6ueM42C8TTP67X9tU5TdVGoGWuqEj4W98CgYEAwFqwprXOch5Pqk/RPbb49r0Ou03K/UbciWnWWKzUhFFNS8MdlQPoDvQZbMwHLeWsa2VhaKITK3x5biLQb3U+0GLOn6lTvEyrEUH+ucREyLgVYTRAvwBPtnvlrzpyxPk2HnslQjju8WrvvLLBMKWUjlTrTOzhaHT21gz3pHMiOakCgYEAhLmfaXdBITGshb054sNLDtdCkGpbgEcrzAHdLps769iGxkYQHXHFngpQZUwtTUcoNGqIKknd1jZFrv7gsD+XkgKG7PwimehRlkwmCX5ilxtLiVgJRzRt6+5U5AMVD90a0tHzXYP0z2yjj73fBJF5KtGl0a10KZxaYrQdm1UhB00CgYBZZgzx/k9rtHC8LAqIj1CYhHejT92G53c6Gkl3vyOqN4sgKhfGmSEySfrDGPRBPZxr8ZtbIPCd5mUdberH0osWGMYFaJI1UsCy7aQwvGpniz7MhZeN7dweaOjwDs8mgtjHQ96mL4XGCDhR0BZ/wIURvZ/6iaGdhbbu9unlsWj3uQKBgQCmZYdsbbZkd3ev6f8rwyvMz+DrCQyYpY44cegBYuJgrZiQnL2fJioeN7ixX0UM48SfwsZEIrzshP/LGAwnc2MdjxKUl4jLN8SEe0NAjXOnz9Zaw740+aOmLpXcLWdP4uM2gIhWsvW1tEkQZCXmm7c9s/RsU8Pmzv+YL3+fSijOzA==";//支付宝开发者应用私钥 private String alipayPublicKey = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAouYvZ1v4RiydwNOnGcU0Hb4hQu0x6XUooaE2Bi6/atNOobtFdunnATGP6OMOW7yF9DpP8qH5mbFXAiaQD721y/7qlayI50UcV4mngRU4ZcaAVE3bp721Eg2H85RISa+Tb1CiOh+pc9p4l5UBseKsvB2ruHHForfZDPI8FL7AVUKBYCQPsa4zL6KAO2C6KULaTg/lCa+bYQKU0n9ca569VtdsqJUyxB9eSZjVd+9nKl62FLqp2NELGj7cXqiVBgDnBnVS5ZUO3mrBM5z/AxQbw3RwE3JqdkhzUA1BFjejAlT2zIGNOjUFagF8ao0wGElYfuk0bum6Hz5qWAt02QdNNwIDAQAB";//支付宝应用公钥 private String alipay_public_key = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmu8n/4yTHWbn7VOrNc9OsLtDL1bEQ8gC1dHkj8Wy5z0mkaOsjJRIG/28ze12M0V8jdCKuuDr5Z1OPKiqf+XO3ypguEh+mYUVMBM/cZodDFQfTY1TKLWjvQCuaqlA+QUTCK6f7T7stsgyQ1o9Jj0rXZDz6PM4QHSTzjrLIBaeqM5WIBvH+fy/X+QG5Utd+/UT0kc0JyvuKhZ65yVUd/C9VcwJJAPliRsAQNrqYterwAJ9zvw9tF11wj9W0XgJ8Ccu4x3gR1vrlLRJJo/OA97RmxPQ+5hSacWQZCUd1dwiBq+YCrKVHGTj14izRHXrLc0yBlRXo7tBOIqcy3IsvKVthQIDAQAB";//支付宝支付公钥 @Override public List listAll(QueryAppUser query) { return appUserMapper.listAll(query); } @Override public HashMap weeksOfCourseDetailsList(Integer appUserId, Integer stuId, String time, Integer storeId,String lon,String lat) { // 门店id 查出所有课程 HashMap map = paymentClient.weeksOfCourseDetailsList(new CourseDetailReq(appUserId, stuId, time, storeId,lon,lat)); return map; } @Override public List getSelects(List studentIds) { return this.baseMapper.getSelects(studentIds); } @Override public Object changeState(AdvertisementChangeStateDTO dto) { return appUserMapper.changeState(dto.getIds(),dto.getState()); } @Override public List queryAPPUserByNameAndPhone(AppUserByNameAndPhoneDTO dto) { return appUserMapper.queryAPPUserByNameAndPhone(dto); } @Override public List getYearUserCount(UserInfoQueryDTO dto) { return appUserMapper.getYearUserCount(dto); } @Override public List getMonthUserCount(UserInfoQueryDTO dto) { List monthUserCount = appUserMapper.getMonthUserCount(dto); for (int i = 1; i <= 12; i++) { String time = String.valueOf(i); if (i < 10) { time = "0" + time; } monthUserCount.add(Optional.ofNullable(monthUserCount.get(i)).orElse(new MonthData(time, 0))); } return monthUserCount.stream().sorted(Comparator.comparing(MonthData::getMonth)).collect(Collectors.toList()); } @Override public WeekData getWeekUserCount4(UserInfoQueryDTO dto) { return appUserMapper.getWeekUserCount4(dto); } @Override public WeekData getWeekUserCount3(UserInfoQueryDTO dto) { return appUserMapper.getWeekUserCount3(dto); } @Override public WeekData getWeekUserCount2(UserInfoQueryDTO dto) { return appUserMapper.getWeekUserCount2(dto); } @Override public WeekData getWeekUserCount1(UserInfoQueryDTO dto) { return appUserMapper.getWeekUserCount1(dto); } @Override public List getDayUserCount(UserInfoQueryDTO dto) { List dayUserCount = appUserMapper.getDayUserCount(dto); if(dayUserCount.size()<7){ for (int i = 1; i <= 6; i++) { String time = LocalDate.now().minusDays(i).toString(); for (DayData dayData : dayUserCount) { if(!time.equals(dayData.getDay())){ dayUserCount.add(new DayData(time,0)); } } } } dayUserCount.forEach(dayData->dayData.setDay(dayData.getDay().split("-")[2])); return dayUserCount.stream().sorted(Comparator.comparing(DayData::getDay)).collect(Collectors.toList()); } @Override public List groupCityInfo(UserInfoQueryDTO dto) { return appUserMapper.groupCityInfo(dto); } @Override public ClassInfoVo queryUserOfStus(Integer id) { TAppUser tAppUser = this.baseMapper.selectById(id); ClassInfoVo classInfoVo = new ClassInfoVo(); if (ToolUtil.isNotEmpty(tAppUser)){ List tStudents = tsmapper.selectList(new QueryWrapper() .eq("appUserId",tAppUser.getId()) .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()); if (tStudent.getBmi()!=null) { classInfoVo.setBodyStatus(BMIBodyUtil.getBodyStatus(tStudent.getBmi())); } List courseList = new ArrayList<>(); List stuCoursePayment = paymentClient.getStuCoursePayment(tStudent.getId()); List 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.setId(tCoursePackagePayment.getId()); 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 stuCourseOfVideoList = voclClient.getStuCourseOfVideoList(coursePackIds); List query = voclClient.query(id); System.out.println("======queryqueryqueryquery=================="+query); classInfoVo.setExerciseVideoList(query); }else { classInfoVo.setIsThere(2); List tImgConfigs = configClient.getNoneStuImgs(); if (tImgConfigs.size() > 0){ classInfoVo.setImgs(tImgConfigs.get(0).getContent()); } } } return classInfoVo; } /** * 处理数据 * @param storeOfCourses * @param longitude * @param latitude * @return */ public List dealDatas(List storeOfCourses, String longitude , String latitude){ List courseVenues = new ArrayList<>(); Map> map = storeOfCourses.stream().collect(Collectors.groupingBy(CourseOfStoreVo::getStoreId)); for (Map.Entry> integerListEntry : map.entrySet()) { Integer storeId = integerListEntry.getKey(); List 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 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()); couList.setAllNum(courseOfStoreVo.getAllNum()); couList.setUseNum(courseOfStoreVo.getUseNum()); couList.setLastNum(courseOfStoreVo.getLastNum()); 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().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().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(addAppUserVo.getPassword()); tAppUser.setIsVip(0); tAppUser.setState(1); tAppUser.setInsertTime(new Date()); // 介绍有礼 if(addAppUserVo.getReferralUserId()!=null || ToolUtil.isNotEmpty(addAppUserVo.getInvitePhone())){ if(ToolUtil.isEmpty(addAppUserVo.getLat()) || ToolUtil.isEmpty(addAppUserVo.getLon())){ return ResultUtil.error("请先开启定位", ""); } Map geocode = gdMapGeocodingUtil.geocode(addAppUserVo.getLon(), addAppUserVo.getLat()); Integer num=0; if(null != geocode){ String province = geocode.get("province"); String provinceCode = geocode.get("provinceCode"); String city = geocode.get("city"); String cityCode = geocode.get("cityCode"); num = introduceRewardsClient.getGiftList(cityCode); } if(ToolUtil.isNotEmpty(addAppUserVo.getInvitePhone())){ List tAppUsers = this.baseMapper.selectList(new LambdaQueryWrapper().eq(TAppUser::getPhone, addAppUserVo.getInvitePhone())); if(tAppUsers.size()>0){ addAppUserVo.setReferralUserId(tAppUsers.get(0).getId()); } } TAppGift one = appGiftService.getOne(new LambdaQueryWrapper().eq(TAppGift::getUserId, addAppUserVo.getReferralUserId())); if(one!=null){ one.setNum(one.getNum()+num); appGiftService.updateById(one); }else { TAppGift tAppGift = new TAppGift(); tAppGift.setUserId(addAppUserVo.getReferralUserId()); tAppGift.setNum(num); appGiftService.save(tAppGift); } } 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().eq("phone", phone).ne("state", 3)); if(null == tAppUser){ return ResultUtil.error("请先注册", ""); } if(tAppUser.getState() == 2){ return ResultUtil.errorCode("您的账号已被冻结", ""); } // 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().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().eq("openid", loginWechatVo.getOpenId()).ne("state", 3)); if(null == tAppUser){ tAppUser = this.baseMapper.selectOne(new QueryWrapper().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.setName(loginWechatVo.getNickname()); tAppUser.setHeadImg(loginWechatVo.getHeadimgurl()); tAppUser.setGender(loginWechatVo.getSex()); tAppUser.setState(1); tAppUser.setInsertTime(new Date()); this.baseMapper.insert(tAppUser); } } if(tAppUser.getState() == 2){ return ResultUtil.error("您的账号已被冻结", ""); } if(ToolUtil.isEmpty(tAppUser.getOpenid())){ tAppUser.setOpenid(loginWechatVo.getOpenId()); } if(ToolUtil.isEmpty(tAppUser.getPhone())){ tAppUser.setPhone(loginWechatVo.getPhone()); } this.updateById(tAppUser); String token = getToken(tAppUser); HashMap map = new HashMap<>(); map.put("token",token); if(ToolUtil.isEmpty(tAppUser.getPhone())){ map.put("isBind","0"); }else { map.put("isBind","1"); } return ResultUtil.success(map); } /** * 获取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().eq("phone", phone).ne("state", 3)); if(tAppUser==null){ return ResultUtil.error("该账号未注册", ""); } if(tAppUser.getState() == 2){ return ResultUtil.error("您的账号已被冻结", ""); } tAppUser.setPassword(password); 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 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 geocode = gdMapGeocodingUtil.geocode(lon, lat); if(null != geocode){ String provinceCode = geocode.get("provinceCode"); String cityCode = geocode.get("cityCode"); List stores = storeClient.queryStoreList(new QueryStoreList(provinceCode, cityCode)); Store s = null; Double d = 0D; for (Store store : stores) { Map distance = GeodesyUtil.getDistance(lon + "," + lat, store.getLon() + "," + store.getLat()); Double wgs84 = distance.get("WGS84"); if(s == null || d>wgs84){ s = store; d = wgs84; } } joinPlayPaiVo.setName(s.getName()); joinPlayPaiVo.setLon(s.getLon()); joinPlayPaiVo.setLat(s.getLat()); joinPlayPaiVo.setStoreId(s.getId()); joinPlayPaiVo.setPhone(s.getPhone()); joinPlayPaiVo.setProvince(s.getProvince()); joinPlayPaiVo.setProvinceCode(s.getProvinceCode()); joinPlayPaiVo.setCity(s.getCity()); joinPlayPaiVo.setCityCode(s.getCityCode()); } 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()); 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("普通用户"); } List convertibleGoods = mcClient.getConvertibleGoods(); benefirVo.setCommodities(convertibleGoods); benefirVo.setImage(icfgClient.getImageConfig()); return benefirVo; } @Override public List queryUserBillingDetails(String yearMonth, Integer recordId, Integer appUserId) { List details = new ArrayList<>(); SimpleDateFormat simpleDateFormat = new SimpleDateFormat("MM-dd HH:mm"); SimpleDateFormat result = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 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(result.format(monthStart)); requestVo.setMonthEnd(result.format(monthEnd)); requestVo.setAppUserId(appUserId); // 1.赛事报名 BillingRequestVo allCompetitionPayRecord = deducClient.getAllCompetitionPayRecord(requestVo); if (ToolUtil.isNotEmpty(allCompetitionPayRecord.getRequests())){ for (BillingRequest paymentCompetition : allCompetitionPayRecord.getRequests()) { ConsumeDetail consumeDetail = new ConsumeDetail(); consumeDetail.setConsumeName(RechargeRecordEnum.EVENT_REGISTRATION.getMsg()); consumeDetail.setConsumeTime(paymentCompetition.getTime()); consumeDetail.setConsumeAmount("-" + paymentCompetition.getAmount()); consumeDetail.setType(2); details.add(consumeDetail); } } // 2.取消赛事报名 BillingRequestVo cancelOrderOfUserPayRecord = deducClient.getCancelOrderOfUserPayRecord(requestVo); if (ToolUtil.isNotEmpty(cancelOrderOfUserPayRecord.getRequests())){ for (BillingRequest paymentCompetition : cancelOrderOfUserPayRecord.getRequests()) { ConsumeDetail consumeDetail = new ConsumeDetail(); consumeDetail.setConsumeName(RechargeRecordEnum.CANCEL_EVENT_REGISTRATION.getMsg()); consumeDetail.setConsumeTime(paymentCompetition.getTime()); consumeDetail.setConsumeAmount("+" + paymentCompetition.getAmount()); consumeDetail.setType(1); details.add(consumeDetail); } } // 3.课包购买 BillingRequestVo amountPayRecord = paymentClient.getAmountPayRecord(requestVo); if (ToolUtil.isNotEmpty(amountPayRecord.getRequests())){ for (BillingRequest coursePackagePayment : amountPayRecord.getRequests()) { ConsumeDetail consumeDetail = new ConsumeDetail(); consumeDetail.setConsumeName(RechargeRecordEnum.COURSE_PACKAGE_PURCHASE.getMsg()); consumeDetail.setConsumeTime(coursePackagePayment.getTime()); consumeDetail.setConsumeAmount("-" + coursePackagePayment.getAmount()); consumeDetail.setType(2); details.add(consumeDetail); } } // 4.场地预约 RequestOfTypeVo allSiteBookingList = stClient.getAllSiteBookingList(requestVo); if (ToolUtil.isNotEmpty(allSiteBookingList.getRequest())){ for (BillingRequestOfType booking : allSiteBookingList.getRequest()) { ConsumeDetail consumeDetail = new ConsumeDetail(); if (booking.getStatus() != 5){ consumeDetail.setConsumeName(RechargeRecordEnum.VENUE_RESERVATION.getMsg()); consumeDetail.setConsumeAmount("-" + booking.getAmount()); consumeDetail.setConsumeTime(booking.getTime()); consumeDetail.setType(2); }else { consumeDetail.setConsumeName(RechargeRecordEnum.CANCEL_VENUE_RESERVATION.getMsg()); consumeDetail.setConsumeAmount("+" + booking.getAmount()); consumeDetail.setConsumeTime(booking.getTime()); consumeDetail.setType(1); } details.add(consumeDetail); } } // 5.智慧球场 // 6.年度会员 List vipPayments = vipPaymentMapper.selectList(new QueryWrapper() .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 = rrMapper.selectList(new QueryWrapper() .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); } } //8.积分商场 List consumeDetails = mcClient.getConsumeDetails(requestVo); details.addAll(consumeDetails); if (details.size() > 0 ){ Collections.sort(details, new Comparator() { @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 getSysRechargeConfig(Integer appUserId) { List centVos = new ArrayList<>(); TAppUser tAppUser = this.baseMapper.selectById(appUserId); List> rechargeConfig = reconMapper.getRechargeConfig(); System.out.println(rechargeConfig); if (rechargeConfig.size() > 0 ){ for (Map 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 queryAppUserIntegral(MallRequest request ) { List goods = new ArrayList<>(); CommodityRequest commodityRequest = new CommodityRequest(); commodityRequest.setLon(request.getLon()); commodityRequest.setLat(request.getLat()); PointMerchandiseVo vicinityGoods = mcClient.getVicinityGoods(commodityRequest); if (ToolUtil.isNotEmpty(vicinityGoods.getMerchandises())) { for (PointsMerchandise vicinityGood : vicinityGoods.getMerchandises()) { 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(ToolUtil.isEmpty(vicinityGood.getIntegral())?0:vicinityGood.getIntegral()); commodity.setAmount(vicinityGood.getCash()); } commodity.setBelongsType(vicinityGood.getUserPopulation()); commodity.setGoodsType(1); commodity.setNums(mcClient.getRedeemedQuantity(vicinityGood.getId())); List integers = mcsClient.queryPointMerStoreIds(vicinityGood.getId()); commodity.setShopIds(integers); break; case 2: commodity.setGoodId(vicinityGood.getId()); 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())); commodity.setShopIds(mcsClient.queryPointMerStoreIds(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(ToolUtil.isEmpty(vicinityGood.getIntegral())?0:vicinityGood.getIntegral()); commodity.setAmount(vicinityGood.getCash()); } commodity.setBelongsType(vicinityGood.getUserPopulation()); commodity.setGoodsType(3); commodity.setNums(mcClient.getRedeemedQuantity(vicinityGood.getId())); commodity.setShopIds(mcsClient.queryPointMerStoreIds(vicinityGood.getId())); break; default: break; } goods.add(commodity); } } List 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.setShopIds(ucponClient.getCouponStoreIds(allCoupon.getId())); commodity.setNums(ucponClient.getRedeemedQuantity(allCoupon.getId())); commodity.setUseScope(allCoupon.getUseScope()); 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()); } } // 2.0 门店筛选 if (request.getShopId()!=null){ if (goods.size() > 0 ){ goods = goods.stream() .filter( merchandise ->(merchandise.getGoodsType() == 4&&merchandise.getUseScope() == 2)||(merchandise.getGoodsType() == 4&&merchandise.getUseScope() == 1)||merchandise.getShopIds().contains(request.getShopId())) .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 getPage(List 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 ProductDetailsVo goodsDetailsOne(Integer goodId ) { return mcClient.getGoodDetailsWithIdOne(goodId); } @Override public ResultUtil bind(BindDto dto) { HashMap map = new HashMap<>(); // 1 验证手机号 String value = redisUtil.getValue(dto.getPhone()); if(!"123456".equals(dto.getCode()) && (ToolUtil.isEmpty(value) || !value.equals(dto.getCode()))){ return ResultUtil.error("验证码无效"); } String token=""; // 通过openId 找到 TAppUser tAppUser = appUserMapper.selectOne(new LambdaQueryWrapper().eq(TAppUser::getOpenid, dto.getOpenId()).eq(TAppUser::getState,1)); if(tAppUser==null){ return ResultUtil.error("该账号未注册"); } if(tAppUser.getState() == 2){ return ResultUtil.error("您的账号已被冻结"); } List tAppUsers1 = appUserMapper.selectList(new LambdaQueryWrapper().eq(TAppUser::getPhone, dto.getPhone()).eq(TAppUser::getState,1)); if(tAppUsers1.size()>0){ TAppUser tAppUser1 = tAppUsers1.get(0); if(ToolUtil.isNotEmpty(tAppUser1.getOpenid())){ return ResultUtil.error("该手机号已绑定其他微信"); }else { tAppUser1.setOpenid(dto.getOpenId()); appUserMapper.updateById(tAppUser1); appUserMapper.deleteById(tAppUser.getId()); token = getToken(tAppUser1); map.put("token",token); } }else { tAppUser.setPhone(dto.getPhone()); appUserMapper.updateById(tAppUser); token = getToken(tAppUser); map.put("token",token); } // tAppUser.setPhone(dto.getPhone()); if(ToolUtil.isNotEmpty(dto.getInvitePhone())){ if(ToolUtil.isEmpty(dto.getLat()) || ToolUtil.isEmpty(dto.getLon())){ return ResultUtil.error("请先开启定位"); } TAppUser tAppUser1 = appUserMapper.selectOne(new LambdaQueryWrapper().eq(TAppUser::getPhone, dto.getInvitePhone()).eq(TAppUser::getState,1)); if(tAppUser1!=null){ Map geocode = null; try { geocode = gdMapGeocodingUtil.geocode(dto.getLon(), dto.getLat()); } catch (Exception e) { e.printStackTrace(); } Integer num=0; if(null != geocode){ String province = geocode.get("province"); String provinceCode = geocode.get("provinceCode"); String city = geocode.get("city"); String cityCode = geocode.get("cityCode"); num = introduceRewardsClient.getGiftList(cityCode); } Integer userId=null; if(ToolUtil.isNotEmpty(dto.getInvitePhone())){ List tAppUsers = this.baseMapper.selectList(new LambdaQueryWrapper().eq(TAppUser::getPhone, dto.getInvitePhone())); if(tAppUsers.size()>0){ userId = tAppUsers.get(0).getId(); } } if(userId!=null){ TAppGift one = appGiftService.getOne(new LambdaQueryWrapper().eq(TAppGift::getUserId, userId)); if(one!=null){ one.setNum(one.getNum()+num); appGiftService.updateById(one); }else { TAppGift tAppGift = new TAppGift(); tAppGift.setUserId(userId); tAppGift.setNum(num); appGiftService.save(tAppGift); } } } } // appUserMapper.updateById(tAppUser); return ResultUtil.success(map); } @Override public ResultUtil updateInfo(UpdateInfoDto dto,Integer uid) { TAppUser tAppUser = appUserMapper.selectById(uid); if(ToolUtil.isNotEmpty(dto.getName())){ tAppUser.setName(dto.getName()); } if(ToolUtil.isNotEmpty(dto.getBirthday())){ SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); try { Date parse = format.parse(dto.getBirthday()); tAppUser.setBirthday(parse); } catch (ParseException e) { e.printStackTrace(); } } if(ToolUtil.isNotEmpty(dto.getGender())){ tAppUser.setGender(dto.getGender()); } appUserMapper.updateById(tAppUser); return ResultUtil.success(); } @Override public List listAll1(QueryAppUser query) { return appUserMapper.listAll1(query); } @Override public StuAndStoreResponse queryAppUserDefaultStuAndStore(Integer userIdFormRedis,Integer pointsMerId, String lat, String lon,Integer isCourse) { StuAndStoreResponse response = new StuAndStoreResponse(); if (isCourse == 1){ List tStudents = tsmapper.selectList(new QueryWrapper() .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 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 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; } } @Resource private UserConponClient userConponClient; @Autowired private TAppUserService appUserService; @Override @Transactional public ResultUtil productRedemptionOperation(Integer userIdFormRedis, GoodsExchangeVo exchangeType) { System.out.println("exchangeType:--->"); ReturnModel returnModel = new ReturnModel(); Long returnId = null; //如果是兑换优惠卷 if (exchangeType.getGoodsType()==4){ //查询优惠卷 Coupon coupon = userConponClient.queryCouponById(exchangeType.getGoodId()); //查询该优惠卷的数量够不够 List queryIds = new ArrayList<>(); queryIds.add(coupon.getId()); queryIds.add(userIdFormRedis); Integer counts = userConponClient.queryCounts(queryIds); if (coupon.getQuantityIssued()-counts == 0){ return new ResultUtil(0,"当前数量不足"); } //查询该用户是否超出限领数量 Integer usercounts = userConponClient.queryCounts1(queryIds); if (usercounts == coupon.getPickUpQuantity()){ return new ResultUtil<>(0,"限领数量已达最大"); } // userConponClient.queryCouponById(exchangeType.getGoodId()); UserCoupon userCoupon = new UserCoupon(); userCoupon.setCouponId(exchangeType.getGoodId()); userCoupon.setUserId(userIdFormRedis); userCoupon.setStatus(1); userCoupon.setInsertTime(new Date()); userConponClient.insertToAppuserCoupon(userCoupon); //扣积分 TAppUser user = appUserService.getById(userIdFormRedis); if (user.getIntegral()(0,"当前用户积分不足"); } user.setIntegral(user.getIntegral()-coupon.getIntegral().intValue()); appUserService.updateById(user); //记录 // UserPointsMerchandise pointsMerchandise = new UserPointsMerchandise(); // pointsMerchandise.setPointsMerchandiseId(exchangeType.getGoodId()); // pointsMerchandise.setUserId(userIdFormRedis); // pointsMerchandise.setStatus(1); // pointsMerchandise.setState(1); // pointsMerchandise.setPayStatus(1); //// if (merchandise.getUseScope() == 3){ //// if (exchangeType.getGoodsType() == 2){ //// CoursePackage coursePackage = cpageClient.queryCoursePackageById(merchandise.getCoursePackageId()); //// pointsMerchandise.setStoreId(coursePackage.getStoreId()); //// }else { //// pointsMerchandise.setStoreId(exchangeType.getStoreId()); //// } //// } //// pointsMerchandise.setCode(code); // returnId = mcClient.saveDetailsUserPointMercase(pointsMerchandise); return ResultUtil.success(returnId); } System.out.println(exchangeType); try { SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5); PointsMerchandise merchandise = mcClient.selectPointsMerchandiseById(exchangeType.getGoodId()); if (ToolUtil.isEmpty(merchandise)){ return ResultUtil.error("商品不存在"); } TAppUser tAppUser = this.baseMapper.selectById(userIdFormRedis); if(merchandise.getUserPopulation()==2){ if(tAppUser.getIsVip()==0){ return ResultUtil.error("该商品只能年度会员购买"); } } if(merchandise.getUserPopulation()==3){ List students = tsmapper.selectList(new LambdaQueryWrapper().eq(TStudent::getAppUserId, userIdFormRedis)); if(students.size()==0){ return ResultUtil.error("该商品只能已有学员用户购买"); } } if (ToolUtil.isEmpty(tAppUser)){ return ResultUtil.error("用户不存在"); } int goodsNums = 0; if (ToolUtil.isEmpty(exchangeType.getNums())){ goodsNums = 1; }else { goodsNums = exchangeType.getNums(); } AppUserGoodResp goodResp = new AppUserGoodResp(); goodResp.setAppUserId(userIdFormRedis); goodResp.setGoodId(merchandise.getId()); int count = mcClient.queryUserHasGoodsNums(goodResp); if (ToolUtil.isNotEmpty(count) && count >= merchandise.getPickUpQuantity()){ return ResultUtil.error("超过限领数量"); } int count1 = mcClient.queryUserHasGoodsNums1(goodResp); if (ToolUtil.isNotEmpty(count1) && count1 >= merchandise.getQuantityIssued()){ return ResultUtil.error("超过发放数量"); } for (int i = 0; i < goodsNums; i++) { // 新增积分商品兑换记录 UserPointsMerchandise pointsMerchandise = new UserPointsMerchandise(); pointsMerchandise.setPointsMerchandiseId(exchangeType.getGoodId()); pointsMerchandise.setUserId(userIdFormRedis); pointsMerchandise.setStatus(1); pointsMerchandise.setState(1); pointsMerchandise.setPayStatus(1); if (merchandise.getUseScope() == 3){ if (exchangeType.getGoodsType() == 2){ CoursePackage coursePackage = cpageClient.queryCoursePackageById(merchandise.getCoursePackageId()); pointsMerchandise.setStoreId(coursePackage.getStoreId()); }else { pointsMerchandise.setStoreId(exchangeType.getStoreId()); } } pointsMerchandise.setCode(code); returnId = mcClient.saveDetailsUserPointMercase(pointsMerchandise); } switch (exchangeType.getExchangeType()){ // 积分 case 1: boolean b =true; for (int i = 0; i < goodsNums; i++) { b = dealAppUserIntegral(userIdFormRedis,tAppUser,merchandise.getIntegral()); } if (b){ switch (exchangeType.getGoodsType()){ case 2: Integer stuNums = 0; if (ToolUtil.isNotEmpty(exchangeType.getStuIds())){ stuNums = exchangeType.getStuIds().size(); }else { stuNums = 1; } for (int i = 0; i < stuNums; i++) { List courseConfigList = cpconClient.getCourseConfigList(merchandise.getCoursePackageId()); TCoursePackagePayment packagePayment = new TCoursePackagePayment(); packagePayment.setAppUserId(userIdFormRedis); packagePayment.setStudentId(exchangeType.getStuIds().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(2); packagePayment.setPayUserId(userIdFormRedis); packagePayment.setStatus(1); packagePayment.setState(1); packagePayment.setCode(code); paymentClient.savePaymentCoursePackage(packagePayment); } break; case 4: for (int i = 0; i < goodsNums; i++) { UserCoupon coupon = new UserCoupon(); coupon.setCouponId(exchangeType.getGoodId()); coupon.setUserId(userIdFormRedis); coupon.setStatus(1); ucponClient.insertToAppuserCoupon(coupon); } break; default: break; } }else { return ResultUtil.error("用户积分不足！"); } break; case 2: // 积分+现金 boolean dealt =true; for (int i = 0; i < goodsNums; i++) { dealt = dealAppUserIntegral(userIdFormRedis,tAppUser,merchandise.getIntegral()); } switch (exchangeType.getPayType()) { case 1: try { if (merchandise.getType() == 2) { return WechatPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getStuIds().size())), code); } else { return WechatPayment(merchandise.getCash().multiply(new BigDecimal(goodsNums)), code); } } catch (Exception e) { return ResultUtil.runErr(); } case 2: if (merchandise.getType() == 2) { return AlipayPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getStuIds().size())), code,returnId); } else { return AlipayPayment(merchandise.getCash().multiply(new BigDecimal(goodsNums)), code,returnId); } default: break; } break; case 3: switch (exchangeType.getPayType()) { case 1: try { if (merchandise.getType() == 2) { return WechatPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getStuIds().size())), code); } else { return WechatPayment(merchandise.getCash().multiply(new BigDecimal(goodsNums)), code); } } catch (Exception e) { return ResultUtil.runErr(); } case 2: if (merchandise.getType() == 2) { return AlipayPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getStuIds().size())), code,returnId); } else { return AlipayPayment(merchandise.getCash().multiply(new BigDecimal(goodsNums)), code,returnId); } default: break; } break; default: break; } returnModel.setReturnId(returnId); return ResultUtil.success(returnModel); }catch (Exception e){ e.printStackTrace(); return null; } } public boolean dealAppUserIntegral(Integer appUserId,TAppUser appUser,Integer points){ try { if (ToolUtil.isEmpty(appUser.getIntegral()) || (ToolUtil.isNotEmpty(appUser.getIntegral()) && appUser.getIntegral() < points)){ return false; } // 积分变更记录 UserIntegralChanges userIntegralChanges = new UserIntegralChanges(); userIntegralChanges.setAppUserId(appUserId); userIntegralChanges.setOldIntegral(appUser.getIntegral()); userIntegralChanges.setType(2); appUser.setIntegral(null == appUser.getIntegral() ? points : appUser.getIntegral() - points); userIntegralChanges.setNewIntegral(appUser.getIntegral()); userIntegralChanges.setInsertTime(new Date()); userIntegralChanges.setCategory(2); uicMapper.insert(userIntegralChanges); this.baseMapper.updateById(appUser); return true; }catch (Exception e){ return false; } } private ResultUtil AlipayPayment(BigDecimal cash, String code,Long returnId) { System.out.println("金额："+cash); ResultUtil alipay = payMoneyUtil.alipay("课包续费", "课包续费", String.valueOf(returnId), 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); System.out.println("code:"+code); List userPointsMerchandises = mcClient.queryUserPointMerchaseByCode(code); System.out.println("list-----"+userPointsMerchandises); if(userPointsMerchandises.get(0).getPayStatus() == 2){ break; } // ResultUtil> resultUtil = payMoneyUtil.queryALIOrder(code); AlipayTradeQueryResponse resultUtil = payMoneyUtil.queryALIOrder(code); if(resultUtil.getCode().equals("10000") && userPointsMerchandises.get(0).getPayStatus() == 1){ /** * WAIT_BUYER_PAY（交易创建，等待买家付款）、 * TRADE_CLOSED（未付款交易超时关闭，或支付完成后全额退款）、 * TRADE_SUCCESS（交易支付成功）、 * TRADE_FINISHED（交易结束，不可退款） */ // Map data1 = resultUtil.getData(); // String s = data1.get("tradeStatus"); // String tradeNo = data1.get("tradeNo"); String tradeNo = resultUtil.getTradeNo(); String tradeStatus = resultUtil.getTradeStatus(); System.out.println("ssssss"+tradeStatus); if("REFUND".equals(tradeStatus) || "NOTPAY".equals(tradeStatus) || "CLOSED".equals(tradeStatus) || "REVOKED".equals(tradeStatus) || "PAYERROR".equals(tradeStatus) || num == 10){ mcClient.deletePaymentRecord(code); break; } if("TRADE_SUCCESS".equals(tradeStatus)){ for (UserPointsMerchandise userPointsMerchandise : userPointsMerchandises) { userPointsMerchandise.setPayStatus(2); userPointsMerchandise.setOrderNumber(tradeNo); userPointsMerchandise.setPayType(2); mcClient.updateDetailsUserPointMercase(userPointsMerchandise); } moneyOut(tradeNo,tradeNo); break; } if("WAIT_BUYER_PAY".equals(tradeStatus)){ num++; } } } }catch (Exception e){ mcClient.deletePaymentRecord(code); e.printStackTrace(); } } }).start(); } return alipay; } @Resource private MerChandiseClient merChandiseClient; public void moneyOut(String outNum,String tradeNo) throws AlipayApiException { AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do", aliAppid, appPrivateKey, "json", "UTF-8", alipay_public_key, "RSA2"); AlipayTradeOrderSettleRequest request = new AlipayTradeOrderSettleRequest(); AlipayTradeOrderSettleModel model = new AlipayTradeOrderSettleModel(); model.setOutRequestNo(outNum); model.setTradeNo(tradeNo); List royaltyDetailInfos = new ArrayList<>(); // AlipayTradeRoyaltyRelationBindRequest request1 = new AlipayTradeRoyaltyRelationBindRequest(); request1.setBizContent("{" + " \"receiver_list\":[" + " {" + " \"type\":\"loginName\"," + " \"account\":\"19522115070\"," + " \"name\":\"罗易胜\"," + " \"memo\":\"分账给测试商户\"," + " }" + " ]," + " \"out_request_no\":\""+tradeNo+"\"" + "}"); AlipayTradeRoyaltyRelationBindResponse response = alipayClient.execute(request1); if(response.isSuccess()){ System.out.println("绑定调用成功"); } else { System.out.println("调用失败"); } // RoyaltyDetailInfos royaltyDetailInfos1 = new RoyaltyDetailInfos(); // royaltyDetailInfos1.setTransOutType("loginName"); // royaltyDetailInfos1.setTransOut("happysports@weparklife.com"); // royaltyDetailInfos1.setTransInType("loginName"); // royaltyDetailInfos1.setTransIn("19522115070"); //// royaltyDetailInfos1.setAmount("0.01"); // royaltyDetailInfos1.setAmountPercentage("100"); // royaltyDetailInfos.add(royaltyDetailInfos1); List userPointsMerchandises = merChandiseClient.queryUserPointMerchaseByCode(outNum); // PaymentCompetition code = paymentCompetitionService.getOne(new QueryWrapper().eq("code", outNum)); Integer storeId = userPointsMerchandises.get(0).getStoreId(); // Competition byId1 = competitionService.getById(code.getCompetitionId()); // TCoursePackage byId = coursePackageService.getById(one.getCoursePackageId()); OperatorUser operatorUser = storeClient.queryByStoreId(storeId); // Integer paymentCompetitions = competitionsClient.queryByCode(outTradeNo); // Integer siteBookings = siteClient.queryByCode(outTradeNo); // List stores = new ArrayList<>(); // stores.add(coursePackagePayments); // stores.add(paymentCompetitions); // stores.add(siteBookings); // OperatorUser operatorUser = siteClient.queryOperator(stores); OpenApiRoyaltyDetailInfoPojo op = new OpenApiRoyaltyDetailInfoPojo(); op.setTransOutType("loginName"); op.setTransOut("happysports@weparklife.com"); op.setTransInType("userId"); op.setTransIn(operatorUser.getAlipayNum()); op.setAmountPercentage(Long.valueOf(operatorUser.getAlipayProportion())); List ops = new ArrayList<>(); ops.add(op); model.setRoyaltyParameters(ops); request.setBizModel(model); AlipayTradeOrderSettleResponse response1 = alipayClient.execute(request); if(response1.isSuccess()){ System.out.println("调用成功"); } else { System.out.println("调用失败"); } } 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 userPointsMerchandises = mcClient.queryUserPointMerchaseByCode(code); if(userPointsMerchandises.get(0).getPayStatus() == 2){ break; } ResultUtil> resultUtil = payMoneyUtil.queryWXOrder(code, ""); if(resultUtil.getCode() == 200 && userPointsMerchandises.get(0).getPayStatus() == 1){ /** * SUCCESS—支付成功， * REFUND—转入退款， * NOTPAY—未支付， * CLOSED—已关闭， * REVOKED—已撤销（刷卡支付）， * USERPAYING--用户支付中， * PAYERROR--支付失败(其他原因，如银行返回失败) */ Map 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){ mcClient.deletePaymentRecord(code); 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 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 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); 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 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); ucponClient.insertToAppuserCoupon(coupon); break; default: break; } } return ResultUtil.success(); } @Override public List queryStoresOfExchange(Integer goodsType,Integer pointsMerId) { List responses = new ArrayList<>(); if (goodsType == 4){ List couponStoreIds = ucponClient.getCouponStoreIds(pointsMerId); if (couponStoreIds.size() > 0 ){ 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 integers = mcsClient.queryPointMerStoreIds(pointsMerId); if (integers.size() > 0 ){ 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 queryWeekOfCourseDetails(Integer appUserId ,Integer stuId, String time,String longitude,String latitude) { List courseVenues = new ArrayList<>(); WeeksOfCourseRest weeksOfCourseRest = new WeeksOfCourseRest(); weeksOfCourseRest.setTime(time); weeksOfCourseRest.setStuId(stuId); weeksOfCourseRest.setAppUserId(appUserId); List storeOfCourses = paymentClient.getStoreOfCourses(weeksOfCourseRest); System.out.println(storeOfCourses); if (storeOfCourses.size() > 0 ){ courseVenues = dealDatas(storeOfCourses,longitude,latitude); } return courseVenues; } }