| | |
| | | import com.alibaba.fastjson.JSON; |
| | | import com.alibaba.fastjson.JSONArray; |
| | | 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.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | |
| | | */ |
| | | @Service |
| | | public class TCoursePackageServiceImpl extends ServiceImpl<TCoursePackageMapper, TCoursePackage> implements TCoursePackageService { |
| | | |
| | | 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";//支付宝支付公钥 |
| | | |
| | | |
| | | |
| | | @Resource |
| | | private StoreClient storeClient; |
| | |
| | | @Override |
| | | public List<CoursePackageListVo> queryCourseList(Integer uid, CoursePackageList coursePackageList) throws Exception { |
| | | AppUser appUser = appUserClient.queryAppUser(uid); |
| | | // Map<String, String> geocode = gdMapGeocodingUtil.geocode(coursePackageList.getLon(), coursePackageList.getLat()); |
| | | // String provinceCode = geocode.get("provinceCode"); |
| | | // String cityCode = geocode.get("cityCode"); |
| | | // QueryWrapper<TCoursePackage> wrapper = new QueryWrapper<TCoursePackage>().in("status", Arrays.asList(1, 2)) |
| | | // .eq("auditStatus", 2).eq("state", 1).eq("provinceCode", provinceCode).eq("cityCode", cityCode); |
| | | |
| | | QueryWrapper<TCoursePackage> wrapper = new QueryWrapper<TCoursePackage>().in("status", Arrays.asList(1, 2)) |
| | | .eq("auditStatus", 2).eq("state", 1); |
| | | if (null != coursePackageList.getCoursePackageTypeId()) { |
| | |
| | | List<TCoursePackage> list1 = this.list(wrapper.last(" order by sort desc, insertTime desc")); |
| | | Date currentTime = new Date(); |
| | | |
| | | // Filter the list based on the conditions |
| | | List<TCoursePackage> list = list1.stream() |
| | | .filter(coursePackage -> coursePackage.getType() != 2 || currentTime.before(coursePackage.getEndTime())) |
| | | .collect(Collectors.toList()); |
| | |
| | | } |
| | | coursePackageListVo.setPaymentPrice(paymentPrice); |
| | | |
| | | double vipPrice1 = coursePackageListVo.getVipPrice(); |
| | | double originalPrice1 = coursePackageListVo.getOriginalPrice(); |
| | | double paymentPrice1 = coursePackageListVo.getPaymentPrice(); |
| | | |
| | | // double minPrice = Math.min(vipPrice1, Math.min(originalPrice1, paymentPrice1)); |
| | | // double maxPrice = Math.max(vipPrice1, Math.max(originalPrice1, paymentPrice1)); |
| | | // coursePackageListVo.setPaymentPrice(minPrice); |
| | | // coursePackageListVo.setOriginalPrice(maxPrice); |
| | | // System.out.println("Minimum price: " + minPrice); |
| | | |
| | | |
| | | // } |
| | | // else{ |
| | | // List<TCoursePackageDiscount> list2 = coursePackageDiscountService.list(new QueryWrapper<TCoursePackageDiscount>().eq("coursePackagePaymentConfigId", coursePackagePaymentConfig.getId()) |
| | | // .eq("type", 1).eq("auditStatus", 2).eq("status",1)); |
| | | // Double vipPrice = coursePackagePaymentConfig.getCashPayment(); |
| | | // for (TCoursePackageDiscount coursePackageDiscount : list2) { |
| | | // Double num1 = JSON.parseObject(coursePackageDiscount.getContent()).getDouble("discountMember"); |
| | | // if(vipPrice.compareTo(num1) > 0){ |
| | | // vipPrice = num1; |
| | | // } |
| | | // } |
| | | // coursePackageListVo.setPaymentPrice(vipPrice); |
| | | // coursePackageListVo.setOriginalPrice(coursePackagePaymentConfig.getCashPayment()); |
| | | // } |
| | | |
| | | if (coursePackageListVo.getPaymentPrice() < coursePackageListVo.getVipPrice()) { |
| | | coursePackageListVo.setOriginalPrice(coursePackagePaymentConfig.getCashPayment()); |
| | | // coursePackageListVo.setVipPrice(null); |
| | | } |
| | | |
| | | if (appUser.getIsVip() == 1) { |
| | |
| | | CoursePackagePaymentConfig coursePackagePaymentConfig = coursePackagePaymentConfigService.getById(paymentCourseVo.getCoursePackagePaymentConfigId()); |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); |
| | | String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5); |
| | | //生成支付订单 |
| | | CoursePackageOrder coursePackageOrder = new CoursePackageOrder(); |
| | | coursePackageOrder.setCode(code); |
| | | coursePackageOrder.setAppUserId(uid); |
| | | coursePackageOrder.setStudentIds(paymentCourseVo.getStudentIds()); |
| | | coursePackageOrder.setCoursePackageId(paymentCourseVo.getId()); |
| | | coursePackageOrder.setPayType(paymentCourseVo.getPayType()); |
| | | coursePackageOrder.setClassHours(coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrder.setOriginalPrice(paymentCourseVo.getPrice()); |
| | | coursePackageOrder.setUserCouponId(paymentCourseVo.getCouponId()); |
| | | coursePackageOrder.setCashPayment(new BigDecimal(paymentPrice)); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(1); |
| | | coursePackageOrder.setPayUserId(uid); |
| | | coursePackageOrder.setState(1); |
| | | coursePackageOrder.setInsertTime(new Date()); |
| | | coursePackageOrderService.save(coursePackageOrder); |
| | | Long orderId = paymentCourseVo.getOrderId(); |
| | | if(null == orderId){ |
| | | //生成支付订单 |
| | | CoursePackageOrder coursePackageOrder = new CoursePackageOrder(); |
| | | coursePackageOrder.setCode(code); |
| | | coursePackageOrder.setAppUserId(uid); |
| | | coursePackageOrder.setStudentIds(paymentCourseVo.getStudentIds()); |
| | | coursePackageOrder.setCoursePackageId(paymentCourseVo.getId()); |
| | | coursePackageOrder.setPayType(paymentCourseVo.getPayType()); |
| | | coursePackageOrder.setClassHours(coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrder.setOriginalPrice(paymentCourseVo.getPrice()); |
| | | coursePackageOrder.setUserCouponId(paymentCourseVo.getCouponId()); |
| | | coursePackageOrder.setCashPayment(new BigDecimal(paymentPrice)); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(1); |
| | | coursePackageOrder.setPayUserId(uid); |
| | | coursePackageOrder.setStatus(1); |
| | | coursePackageOrder.setState(1); |
| | | coursePackageOrder.setInsertTime(new Date()); |
| | | coursePackageOrderService.save(coursePackageOrder); |
| | | orderId = coursePackageOrder.getId(); |
| | | }else{ |
| | | CoursePackageOrder coursePackageOrder = coursePackageOrderService.getById(orderId); |
| | | code = coursePackageOrder.getCode(); |
| | | coursePackageOrder.setPayType(1); |
| | | coursePackageOrder.setAppUserId(null); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayUserId(uid); |
| | | coursePackageOrderService.updateById(coursePackageOrder); |
| | | } |
| | | |
| | | ResultUtil weixinpay = payMoneyUtil.weixinpay("购买课程", coursePackagePaymentConfig.getId().toString(), code, paymentPrice.toString(), "/base/course/weChatPaymentCourseCallback", "APP", ""); |
| | | if (weixinpay.getCode() == 200) { |
| | | String finalCode = code; |
| | | new Thread(new Runnable() { |
| | | @Override |
| | | public void run() { |
| | |
| | | wait += (min * num); |
| | | Thread.sleep(wait); |
| | | CoursePackageOrder coursePackageOrder1 = coursePackageOrderService.getOne(new QueryWrapper<CoursePackageOrder>() |
| | | .eq("code", code).eq("state", 1)); |
| | | .eq("code", finalCode).eq("state", 1)); |
| | | if (coursePackageOrder1.getPayStatus() == 2) { |
| | | break; |
| | | } |
| | | ResultUtil<Map<String, String>> resultUtil = payMoneyUtil.queryWXOrder(code, ""); |
| | | ResultUtil<Map<String, String>> resultUtil = payMoneyUtil.queryWXOrder(finalCode, ""); |
| | | if (resultUtil.getCode() == 200 && coursePackageOrder1.getPayStatus() == 1) { |
| | | /** |
| | | * SUCCESS—支付成功, |
| | |
| | | return weixinpay; |
| | | } |
| | | |
| | | |
| | | private String smid = "2088330203191220";//平台支付宝商户号 |
| | | /** |
| | | * 课程支付宝支付 |
| | | * |
| | |
| | | CoursePackagePaymentConfig coursePackagePaymentConfig = coursePackagePaymentConfigService.getById(paymentCourseVo.getCoursePackagePaymentConfigId()); |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); |
| | | String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5); |
| | | String smid1=""; |
| | | //生成支付订单 |
| | | CoursePackageOrder coursePackageOrder = new CoursePackageOrder(); |
| | | coursePackageOrder.setCode(code); |
| | | coursePackageOrder.setAppUserId(uid); |
| | | coursePackageOrder.setStudentIds(paymentCourseVo.getStudentIds()); |
| | | coursePackageOrder.setCoursePackageId(paymentCourseVo.getId()); |
| | | coursePackageOrder.setPayType(paymentCourseVo.getPayType()); |
| | | coursePackageOrder.setClassHours(coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrder.setOriginalPrice(paymentCourseVo.getPrice()); |
| | | coursePackageOrder.setUserCouponId(paymentCourseVo.getCouponId()); |
| | | coursePackageOrder.setCashPayment(new BigDecimal(paymentPrice)); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(1); |
| | | coursePackageOrder.setPayUserId(uid); |
| | | coursePackageOrder.setState(1); |
| | | coursePackageOrder.setInsertTime(new Date()); |
| | | coursePackageOrderService.save(coursePackageOrder); |
| | | |
| | | ResultUtil alipay = payMoneyUtil.alipay("购买课程", "购买课程", coursePackagePaymentConfig.getId().toString(), code, paymentPrice.toString(), "/base/course/aliPaymentCourseCallback"); |
| | | if (paymentCourseVo.getOrderId()==null){ |
| | | CoursePackageOrder coursePackageOrder = new CoursePackageOrder(); |
| | | coursePackageOrder.setCode(code); |
| | | coursePackageOrder.setAppUserId(uid); |
| | | coursePackageOrder.setStudentIds(paymentCourseVo.getStudentIds()); |
| | | coursePackageOrder.setCoursePackageId(paymentCourseVo.getId()); |
| | | coursePackageOrder.setPayType(paymentCourseVo.getPayType()); |
| | | coursePackageOrder.setClassHours(coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrder.setOriginalPrice(paymentCourseVo.getPrice()); |
| | | coursePackageOrder.setUserCouponId(paymentCourseVo.getCouponId()); |
| | | coursePackageOrder.setCashPayment(new BigDecimal(paymentPrice)); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(1); |
| | | coursePackageOrder.setPayUserId(uid); |
| | | coursePackageOrder.setStatus(1); |
| | | coursePackageOrder.setState(1); |
| | | coursePackageOrder.setInsertTime(new Date()); |
| | | coursePackageOrderService.save(coursePackageOrder); |
| | | }else { |
| | | CoursePackageOrder coursePackageOrder = coursePackageOrderService.getById(paymentCourseVo.getOrderId()); |
| | | code = coursePackageOrder.getCode(); |
| | | coursePackageOrder.setPayType(2); |
| | | coursePackageOrder.setAppUserId(null); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayUserId(uid); |
| | | coursePackageOrderService.updateById(coursePackageOrder); |
| | | } |
| | | // 判断这个课包属于哪个门店 属于哪个运营商 根据运营商 id 获取对应的商户号 |
| | | Integer coursePackageId = paymentCourseVo.getId(); |
| | | TCoursePackage byId = coursePackageService.getById(coursePackageId); |
| | | Store store = storeClient.queryStoreById(byId.getStoreId()); |
| | | if (store.getOperatorId() == null){ |
| | | smid1 = smid; |
| | | }else{ |
| | | if (store.getOperatorId()==0){ |
| | | smid1 = smid; |
| | | }else{ |
| | | smid1 = storeClient.getSMIDByOperatorId(store.getOperatorId()); |
| | | } |
| | | } |
| | | ResultUtil alipay = payMoneyUtil.alipay(smid1,"购买课程", "购买课程", |
| | | coursePackagePaymentConfig.getId().toString(), |
| | | code, paymentPrice.toString(), "/base/course/aliPaymentCourseCallback"); |
| | | if (alipay.getCode() == 200) { |
| | | String finalCode = code; |
| | | new Thread(new Runnable() { |
| | | @Override |
| | | public void run() { |
| | | try { |
| | | Thread.sleep(1000); |
| | | |
| | | int num = 1; |
| | | int wait = 0; |
| | | while (num <= 10) { |
| | |
| | | wait += (min * num); |
| | | Thread.sleep(wait); |
| | | CoursePackageOrder coursePackageOrder1 = coursePackageOrderService.getOne(new QueryWrapper<CoursePackageOrder>() |
| | | .eq("code", code).eq("state", 1)); |
| | | .eq("code", finalCode).eq("state", 1)); |
| | | if (coursePackageOrder1.getPayStatus() == 2) { |
| | | break; |
| | | } |
| | | AlipayTradeQueryResponse alipayTradeQueryResponse = payMoneyUtil.queryALIOrder(code); |
| | | AlipayTradeQueryResponse alipayTradeQueryResponse = payMoneyUtil.queryALIOrder(finalCode); |
| | | if (null != alipayTradeQueryResponse) { |
| | | /** |
| | | * WAIT_BUYER_PAY(交易创建,等待买家付款)、 |
| | |
| | | coursePackageOrder1.setAppUserId(null); |
| | | coursePackageOrderService.updateById(coursePackageOrder1); |
| | | addCoursePackageOrderStudent(coursePackageOrder1.getId(), coursePackagePaymentConfig); |
| | | break; |
| | | moneyOut(tradeNo,tradeNo,finalCode); |
| | | // 根据课程id 查询这个课程属于哪个门店 属于哪个运营商 |
| | | Integer id = paymentCourseVo.getId(); |
| | | TCoursePackage byId = coursePackageService.getById(id); |
| | | Integer storeId = byId.getStoreId(); |
| | | Store store = storeClient.queryStoreById(storeId); |
| | | Integer operatorId = store.getOperatorId(); |
| | | if (operatorId==null){ |
| | | String smid ="2088330203191220"; |
| | | // 说明是平台的 不走分账 |
| | | // payMoneyUtil.confirm(smid,finalCode,tradeNo,paymentPrice.toString()); |
| | | payMoneyUtil.confirm1(smid,finalCode,tradeNo,paymentPrice.toString()); |
| | | break; |
| | | }else if (operatorId==0){ |
| | | String smid ="2088330203191220"; |
| | | // 说明是平台的 |
| | | payMoneyUtil.confirm1(smid,finalCode,tradeNo,paymentPrice.toString()); |
| | | break; |
| | | }else{ |
| | | // 当前课程不属于门店 查询这个课程属于哪个门店 属于哪个运营商 |
| | | String smidByOperatorId = storeClient.getSMIDByOperatorId(operatorId); |
| | | payMoneyUtil.confirm(smidByOperatorId,finalCode,tradeNo,paymentPrice.toString()); |
| | | // 分账处理 |
| | | extracted(store, coursePackageOrder1, tradeNo); |
| | | break; |
| | | } |
| | | } |
| | | if ("WAIT_BUYER_PAY".equals(s)) { |
| | | num++; |
| | |
| | | }).start(); |
| | | } |
| | | return alipay; |
| | | } |
| | | |
| | | private void extracted(Store store, CoursePackageOrder coursePackageOrder1, String tradeNo) throws Exception { |
| | | // 分账 |
| | | AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do", |
| | | "2021004105665036", |
| | | "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==", |
| | | "json", "GBK", |
| | | "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmu8n/4yTHWbn7VOrNc9OsLtDL1bEQ8gC1dHkj8Wy5z0mkaOsjJRIG/28ze12M0V8jdCKuuDr5Z1OPKiqf+XO3ypguEh+mYUVMBM/cZodDFQfTY1TKLWjvQCuaqlA+QUTCK6f7T7stsgyQ1o9Jj0rXZDz6PM4QHSTzjrLIBaeqM5WIBvH+fy/X+QG5Utd+/UT0kc0JyvuKhZ65yVUd/C9VcwJJAPliRsAQNrqYterwAJ9zvw9tF11wj9W0XgJ8Ccu4x3gR1vrlLRJJo/OA97RmxPQ+5hSacWQZCUd1dwiBq+YCrKVHGTj14izRHXrLc0yBlRXo7tBOIqcy3IsvKVthQIDAQAB", |
| | | "RSA2"); |
| | | AlipayTradeOrderSettleRequest request = new AlipayTradeOrderSettleRequest(); |
| | | String randomCode = UUIDUtil.getRandomCode(16); |
| | | String proportionByOperatorId = storeClient.getProportionByOperatorId(store.getOperatorId()); |
| | | // 支付宝分账比例 |
| | | String s1 = proportionByOperatorId.split(",")[1]; |
| | | double i = Double.parseDouble(s1); |
| | | double v = i * 0.01; |
| | | BigDecimal bigDecimal1 = new BigDecimal(String.valueOf(v)); |
| | | BigDecimal cashPayment = coursePackageOrder1.getCashPayment(); |
| | | // 分账金额 |
| | | BigDecimal bigDecimal2 = cashPayment.multiply(bigDecimal1).setScale(2, RoundingMode.DOWN); |
| | | request.setBizContent("{" + |
| | | " \"out_request_no\":\"" + randomCode + "\"," + |
| | | " \"trade_no\":\"" + tradeNo + "\"," + |
| | | " \"royalty_parameters\":[" + |
| | | " {" + |
| | | " \"royalty_type\":\"transfer\"," + |
| | | " \"trans_out\":\"" + storeClient.getSMIDByOperatorId(store.getOperatorId()) + "\"," + |
| | | " \"trans_out_type\":\"userId\"," + |
| | | " \"trans_in_type\":\"userId\"," + |
| | | " \"trans_in\":\"" + smid + "\"," + |
| | | " \"amount\":" + bigDecimal2 + "," + |
| | | " \"desc\":\"平台服务费\"," + |
| | | " \"royalty_scene\":\"平台服务费\"," + |
| | | " }" + |
| | | " ]," + |
| | | " \"extend_params\":{" + |
| | | " \"royalty_finish\":\"true\"" + |
| | | " }," + |
| | | " \"royalty_mode\":\"async\"" + |
| | | "}"); |
| | | AlipayTradeOrderSettleResponse response = alipayClient.execute(request); |
| | | if (response.isSuccess()) { |
| | | System.out.println("调用成功"); |
| | | } else { |
| | | System.out.println("调用失败"); |
| | | } |
| | | } |
| | | //分账 |
| | | public void moneyOut(String outNum, String tradeNo,String code) 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> 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("调用失败"); |
| | | // } |
| | | |
| | | |
| | | |
| | | // |
| | | CoursePackageOrder one = coursePackageOrderService.getOne(new QueryWrapper<CoursePackageOrder>().eq("code", code)); |
| | | TCoursePackage coursePackage = coursePackageService.getById(one.getCoursePackageId()); |
| | | OperatorUser operatorUser = storeClient.queryByStoreId(coursePackage.getStoreId()); |
| | | if (operatorUser!=null) { |
| | | if(one.getPayType()==2){ |
| | | |
| | | OpenApiRoyaltyDetailInfoPojo op = new OpenApiRoyaltyDetailInfoPojo(); |
| | | op.setTransOutType("loginName"); |
| | | op.setTransOut("happysports@weparklife.com"); |
| | | op.setTransInType("userId"); |
| | | // op.setTransInType("loginName"); |
| | | // op.setTransIn("19522115070"); |
| | | op.setTransIn(operatorUser.getAlipayNum()); |
| | | op.setAmountPercentage(Long.valueOf(operatorUser.getAlipayProportion())); |
| | | |
| | | List<OpenApiRoyaltyDetailInfoPojo> 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("调用失败"); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | |
| | | CoursePackagePaymentConfig coursePackagePaymentConfig = coursePackagePaymentConfigService.getById(paymentCourseVo.getCoursePackagePaymentConfigId()); |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); |
| | | String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5); |
| | | //生成支付订单 |
| | | CoursePackageOrder coursePackageOrder = new CoursePackageOrder(); |
| | | coursePackageOrder.setCode(code); |
| | | coursePackageOrder.setAppUserId(appUser.getId()); |
| | | coursePackageOrder.setStudentIds(paymentCourseVo.getStudentIds()); |
| | | coursePackageOrder.setCoursePackageId(paymentCourseVo.getId()); |
| | | coursePackageOrder.setPayType(paymentCourseVo.getPayType()); |
| | | coursePackageOrder.setClassHours(coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrder.setOriginalPrice(paymentCourseVo.getPrice()); |
| | | coursePackageOrder.setUserCouponId(paymentCourseVo.getCouponId()); |
| | | coursePackageOrder.setCashPayment(new BigDecimal(paymentPrice)); |
| | | coursePackageOrder.setPlayPaiCoin(paymentCourseVo.getPrice().intValue()); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(2); |
| | | coursePackageOrder.setPayUserId(appUser.getId()); |
| | | coursePackageOrder.setState(1); |
| | | coursePackageOrder.setInsertTime(new Date()); |
| | | coursePackageOrderService.save(coursePackageOrder); |
| | | Long orderId = paymentCourseVo.getOrderId(); |
| | | if(null == orderId){ |
| | | //生成支付订单 |
| | | CoursePackageOrder coursePackageOrder = new CoursePackageOrder(); |
| | | coursePackageOrder.setCode(code); |
| | | coursePackageOrder.setAppUserId(appUser.getId()); |
| | | coursePackageOrder.setStudentIds(paymentCourseVo.getStudentIds()); |
| | | coursePackageOrder.setCoursePackageId(paymentCourseVo.getId()); |
| | | coursePackageOrder.setPayType(paymentCourseVo.getPayType()); |
| | | coursePackageOrder.setClassHours(coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrder.setOriginalPrice(paymentCourseVo.getPrice()); |
| | | coursePackageOrder.setUserCouponId(paymentCourseVo.getCouponId()); |
| | | coursePackageOrder.setCashPayment(new BigDecimal(paymentPrice)); |
| | | coursePackageOrder.setPlayPaiCoin(paymentCourseVo.getPrice().intValue()); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(2); |
| | | coursePackageOrder.setPayUserId(appUser.getId()); |
| | | coursePackageOrder.setStatus(1); |
| | | coursePackageOrder.setState(1); |
| | | coursePackageOrder.setInsertTime(new Date()); |
| | | coursePackageOrderService.save(coursePackageOrder); |
| | | orderId = coursePackageOrder.getId(); |
| | | }else{ |
| | | CoursePackageOrder coursePackageOrder = coursePackageOrderService.getById(orderId); |
| | | coursePackageOrder.setPayType(3); |
| | | coursePackageOrder.setAppUserId(null); |
| | | coursePackageOrder.setPayUserId(appUser.getId()); |
| | | coursePackageOrder.setPayUserType(1); |
| | | coursePackageOrder.setPayStatus(2); |
| | | coursePackageOrderService.updateById(coursePackageOrder); |
| | | } |
| | | |
| | | addCoursePackageOrderStudent(coursePackageOrder.getId(), coursePackagePaymentConfig); |
| | | addCoursePackageOrderStudent(orderId, coursePackagePaymentConfig); |
| | | return ResultUtil.success(); |
| | | } |
| | | |
| | |
| | | * @return |
| | | */ |
| | | @Override |
| | | public ResultUtil paymentCourseCallback(String code, String trade_no, String attach) { |
| | | public ResultUtil paymentCourseCallback(String code, String trade_no, String attach) throws AlipayApiException { |
| | | CoursePackageOrder coursePackageOrder1 = coursePackageOrderService.getOne(new QueryWrapper<CoursePackageOrder>() |
| | | .eq("code", code).eq("state", 1)); |
| | | if (coursePackageOrder1.getPayStatus() == 2) { |
| | |
| | | |
| | | CoursePackagePaymentConfig coursePackagePaymentConfig = coursePackagePaymentConfigService.getById(attach); |
| | | addCoursePackageOrderStudent(coursePackageOrder1.getId(), coursePackagePaymentConfig); |
| | | moneyOut(trade_no,trade_no,code); |
| | | return ResultUtil.success(); |
| | | } |
| | | |
| | |
| | | * |
| | | * @param coursePackagePaymentConfig |
| | | */ |
| | | @Override |
| | | public void addCoursePackageOrderStudent(Long coursePackageOrderId, CoursePackagePaymentConfig coursePackagePaymentConfig) { |
| | | CoursePackageOrder coursePackageOrder = coursePackageOrderService.getById(coursePackageOrderId); |
| | | // 发放优惠券 |
| | |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + validDays); |
| | | coursePackageOrderStudent.setUseTime(calendar.getTime()); |
| | | coursePackageOrderStudentService.saveOrUpdate(coursePackageOrderStudent); |
| | | |
| | | //更新学员课时有效期 |
| | | if(null == student.getValidity()){ |
| | | student.setValidity(calendar.getTime()); |
| | |
| | | |
| | | //开始排课 |
| | | addPackageStudent(coursePackage, coursePackageOrder.getAppUserId(), Integer.valueOf(id), coursePackageOrderStudent, student.getValidity()); |
| | | |
| | | //课时记录 |
| | | CourseCounsum courseCounsum = new CourseCounsum(); |
| | | courseCounsum.setPaymentId(coursePackageOrderStudent.getId()); |
| | |
| | | courseCounsum1.setAppUserId(coursePackageOrder.getAppUserId()); |
| | | courseCounsumService.save(courseCounsum1); |
| | | } |
| | | |
| | | |
| | | } else { |
| | | Date useTime = coursePackageOrderStudent.getUseTime(); |
| | | coursePackageOrderStudent.setTotalClassHours(coursePackageOrderStudent.getTotalClassHours() + coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrderStudent.setLaveClassHours(coursePackageOrderStudent.getLaveClassHours() + coursePackagePaymentConfig.getClassHours()); |
| | | coursePackageOrderStudent.setStatus(1); |
| | | coursePackageOrderStudent.setInsertTime(new Date()); |
| | | Integer validDays = coursePackage.getValidDays(); |
| | | Calendar calendar = Calendar.getInstance(); |
| | | calendar.setTime(useTime.compareTo(new Date()) < 0 ? new Date() : useTime); |
| | |
| | | courseCounsum1.setAppUserId(coursePackageOrder.getAppUserId()); |
| | | courseCounsumService.save(courseCounsum1); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | if(coursePackage.getType() == 2){ |
| | | addPackageStudent(coursePackage, coursePackageOrder.getAppUserId(), Integer.valueOf(id), null, null); |
| | |
| | | //上课星期 |
| | | String classWeeks = tCoursePackage.getClassWeeks(); |
| | | List<Integer> week = week(classWeeks); |
| | | CoursePackageScheduling one = coursePackageSchedulingService.getOne(new QueryWrapper<CoursePackageScheduling>() |
| | | .eq("studentId", sId) |
| | | .eq("coursePackageId", tCoursePackage.getId()) |
| | | .eq("status", 1) |
| | | .orderByDesc("classDate") |
| | | .last(" limit 0, 1") |
| | | ); |
| | | if(null != one){ |
| | | //先检测是否需要继续进行排课 |
| | | Calendar calendar1 = Calendar.getInstance(); |
| | | calendar1.setTime(one.getClassDate()); |
| | | int day_week1 = calendar1.get(Calendar.DAY_OF_WEEK); |
| | | day_week1 = day_week1 - 1 == 0 ? 7 : day_week1 - 1; |
| | | int week_of_month = calendar1.get(Calendar.WEEK_OF_MONTH); |
| | | |
| | | Calendar calendar2 = Calendar.getInstance(); |
| | | calendar2.setTime(new Date()); |
| | | int week_of_month1 = calendar2.get(Calendar.WEEK_OF_MONTH); |
| | | |
| | | //最后一次的排课时间不在本周,且是一周的最后一天。(如果是本周则表明已经课时用完了) |
| | | if(week.get(week.size() - 1).equals(day_week1) && week_of_month != week_of_month1){ |
| | | return; |
| | | } |
| | | } |
| | | |
| | | //上课时段 |
| | | String[] split = tCoursePackage.getClassStartTime().split(","); |
| | | String[] split1 = tCoursePackage.getClassEndTime().split(","); |
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); |
| | | SimpleDateFormat format1 = new SimpleDateFormat("yyyy-MM-dd HH:mm"); |
| | | |
| | | |
| | | //剩余课时 |
| | | Integer laveClassHours = coursePackageOrderStudent.getLaveClassHours(); |
| | |
| | | continue; |
| | | } |
| | | |
| | | |
| | | //大于有效期不进行排课 |
| | | if (calendar.getTimeInMillis() >= validity.getTime()) { |
| | | break; |
| | | } |
| | | |
| | | //检查是否有体验购课 |
| | | int count = coursePackageSchedulingService.count(new QueryWrapper<CoursePackageScheduling>() |
| | | .eq("type", 3) |
| | | .eq("appUserId", userId) |
| | | .eq("studentId", sId) |
| | | .eq("coursePackageId", tCoursePackage.getId()) |
| | | .eq("status", 1) |
| | | .eq("DATE_FORMAT(classDate, '%Y-%m-%d')", format.format(time)) |
| | | ); |
| | | //有体验购课,不进行排课 |
| | | if(count != 0){ |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | continue; |
| | | } |
| | | |
| | | for (int j = 0; j < split.length; j++) { |
| | | //剩余数量不足以排课 |
| | | if (laveClassHours.compareTo(codeTime) < 0) { |
| | |
| | | |
| | | |
| | | /** |
| | | * 课时有效期更新后-更新历史排课数据 |
| | | * 课时有效期更新后-更新历史排课数据(因有效期限制的排课数据,还有剩余课时) |
| | | * @param student |
| | | */ |
| | | public void addOldPackageStudent(Student student){ |
| | |
| | | ); |
| | | |
| | | Calendar calendar = Calendar.getInstance(); |
| | | //上课星期 |
| | | String classWeeks = coursePackage.getClassWeeks(); |
| | | List<Integer> week = week(classWeeks); |
| | | |
| | | Integer laveClassHours = coursePackageOrderStudent.getLaveClassHours(); |
| | | Integer codeTime = coursePackage.getCodeTime(); |
| | | String classStartTime = coursePackage.getClassStartTime(); |
| | | String classEndTime = coursePackage.getClassEndTime(); |
| | | String[] split = classStartTime.split(","); |
| | | String[] split1 = classEndTime.split(","); |
| | | |
| | | if(null == one){ |
| | | calendar.setTime(new Date()); |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | calendar.set(Calendar.HOUR_OF_DAY, 0); |
| | | calendar.set(Calendar.MINUTE, 0); |
| | | calendar.set(Calendar.SECOND, 0); |
| | | }else{ |
| | | Integer laveClassHours = coursePackageOrderStudent.getLaveClassHours(); |
| | | Integer codeTime = coursePackage.getCodeTime(); |
| | | String classStartTime = coursePackage.getClassStartTime(); |
| | | String classEndTime = coursePackage.getClassEndTime(); |
| | | String format = sdf1.format(one.getClassDate()); |
| | | String time = format.substring(format.indexOf(" ") + 1); |
| | | String[] split = classStartTime.split(","); |
| | | String[] split1 = classEndTime.split(","); |
| | | int n = Arrays.asList(split).indexOf(time); |
| | | if(n != split.length - 1){ |
| | | calendar.setTime(one.getClassDate()); |
| | |
| | | } |
| | | |
| | | }else{ |
| | | calendar.setTime(one.getClassDate()); |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | calendar.set(Calendar.HOUR_OF_DAY, 0); |
| | | calendar.set(Calendar.MINUTE, 0); |
| | | calendar.set(Calendar.SECOND, 0); |
| | | int day_week1 = calendar.get(Calendar.DAY_OF_WEEK); |
| | | //先检测是否需要继续进行排课 |
| | | Calendar calendar1 = Calendar.getInstance(); |
| | | calendar1.setTime(one.getClassDate()); |
| | | int day_week1 = calendar1.get(Calendar.DAY_OF_WEEK); |
| | | day_week1 = day_week1 - 1 == 0 ? 7 : day_week1 - 1; |
| | | int num = 8 - day_week1 + 7; |
| | | int week_of_month = calendar1.get(Calendar.WEEK_OF_MONTH); |
| | | |
| | | //上课星期 |
| | | String classWeeks = coursePackage.getClassWeeks(); |
| | | List<Integer> week = week(classWeeks); |
| | | Calendar calendar2 = Calendar.getInstance(); |
| | | calendar2.setTime(new Date()); |
| | | int week_of_month1 = calendar2.get(Calendar.WEEK_OF_MONTH); |
| | | |
| | | for (int i = 0; i < num; i++) { |
| | | Date time1 = calendar.getTime(); |
| | | |
| | | //判断当天是否在排课星期内 |
| | | int day = calendar.get(Calendar.DAY_OF_WEEK); |
| | | day = day - 1 == 0 ? 7 : day - 1; |
| | | if (!week.contains(day)) { |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | continue; |
| | | } |
| | | |
| | | //大于有效期不进行排课 |
| | | if (calendar.getTimeInMillis() >= validity.getTime()) { |
| | | break; |
| | | } |
| | | for (int j = 0; j < split.length; j++) { |
| | | //剩余数量不足以排课 |
| | | if (laveClassHours.compareTo(codeTime) < 0) { |
| | | break; |
| | | } |
| | | |
| | | laveClassHours -= codeTime; |
| | | |
| | | CoursePackageScheduling packageScheduling = new CoursePackageScheduling(); |
| | | packageScheduling.setType(coursePackage.getType()); |
| | | packageScheduling.setAppUserId(coursePackageOrderStudent.getAppUserId()); |
| | | packageScheduling.setStudentId(coursePackageOrderStudent.getStudentId()); |
| | | packageScheduling.setCoursePackageId(coursePackage.getId()); |
| | | try { |
| | | Date parse = sdf.parse(sdf1.format(time1) + " " + split[j]); |
| | | Date parse1 = sdf.parse(sdf1.format(time1) + " " + split1[j]); |
| | | packageScheduling.setClassDate(parse); |
| | | packageScheduling.setEndDate(parse1); |
| | | }catch (Exception e){ |
| | | e.printStackTrace(); |
| | | } |
| | | packageScheduling.setStatus(1); |
| | | coursePackageSchedulingService.save(packageScheduling); |
| | | CoursePackageStudent student1 = new CoursePackageStudent(); |
| | | student1.setAppUserId(coursePackageOrderStudent.getAppUserId()); |
| | | student1.setStudentId(coursePackageOrderStudent.getStudentId()); |
| | | student1.setCoursePackageId(coursePackage.getId()); |
| | | student1.setCoursePackagePaymentId(coursePackageOrderStudent.getId()); |
| | | student1.setCoursePackageSchedulingId(packageScheduling.getId()); |
| | | student1.setSignInOrNot(1); |
| | | student1.setReservationStatus(1); |
| | | student1.setInsertTime(new Date()); |
| | | coursePackageStudentMapper.insert(student1); |
| | | } |
| | | //增加日期,用于判断 |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | //最后一次的排课时间不在本周,且是一周的最后一天。(如果是本周则表明已经课时用完了) |
| | | if(week.get(week.size() - 1).equals(day_week1) && week_of_month != week_of_month1){ |
| | | break; |
| | | } |
| | | } |
| | | |
| | | calendar.setTime(one.getClassDate()); |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | calendar.set(Calendar.HOUR_OF_DAY, 0); |
| | | calendar.set(Calendar.MINUTE, 0); |
| | | calendar.set(Calendar.SECOND, 0); |
| | | } |
| | | |
| | | int day_week = calendar.get(Calendar.DAY_OF_WEEK); |
| | | day_week = day_week - 1 == 0 ? 7 : day_week - 1; |
| | | int num = 8 - day_week + 7; |
| | | for (int i = 0; i < num; i++) { |
| | | Date time1 = calendar.getTime(); |
| | | |
| | | //判断当天是否在排课星期内 |
| | | int day = calendar.get(Calendar.DAY_OF_WEEK); |
| | | day = day - 1 == 0 ? 7 : day - 1; |
| | | if (!week.contains(day)) { |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | continue; |
| | | } |
| | | |
| | | //大于有效期不进行排课 |
| | | if (calendar.getTimeInMillis() >= validity.getTime()) { |
| | | break; |
| | | } |
| | | for (int j = 0; j < split.length; j++) { |
| | | //剩余数量不足以排课 |
| | | if (laveClassHours.compareTo(codeTime) < 0) { |
| | | break; |
| | | } |
| | | |
| | | laveClassHours -= codeTime; |
| | | |
| | | CoursePackageScheduling packageScheduling = new CoursePackageScheduling(); |
| | | packageScheduling.setType(coursePackage.getType()); |
| | | packageScheduling.setAppUserId(coursePackageOrderStudent.getAppUserId()); |
| | | packageScheduling.setStudentId(coursePackageOrderStudent.getStudentId()); |
| | | packageScheduling.setCoursePackageId(coursePackage.getId()); |
| | | try { |
| | | Date parse = sdf1.parse(sdf.format(time1) + " " + split[j]); |
| | | Date parse1 = sdf1.parse(sdf.format(time1) + " " + split1[j]); |
| | | packageScheduling.setClassDate(parse); |
| | | packageScheduling.setEndDate(parse1); |
| | | }catch (Exception e){ |
| | | e.printStackTrace(); |
| | | } |
| | | packageScheduling.setStatus(1); |
| | | coursePackageSchedulingService.save(packageScheduling); |
| | | CoursePackageStudent student1 = new CoursePackageStudent(); |
| | | student1.setAppUserId(coursePackageOrderStudent.getAppUserId()); |
| | | student1.setStudentId(coursePackageOrderStudent.getStudentId()); |
| | | student1.setCoursePackageId(coursePackage.getId()); |
| | | student1.setCoursePackagePaymentId(coursePackageOrderStudent.getId()); |
| | | student1.setCoursePackageSchedulingId(packageScheduling.getId()); |
| | | student1.setSignInOrNot(1); |
| | | student1.setReservationStatus(1); |
| | | student1.setInsertTime(new Date()); |
| | | coursePackageStudentMapper.insert(student1); |
| | | } |
| | | //增加日期,用于判断 |
| | | calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1); |
| | | } |
| | | } |
| | | } |
| | |
| | | @Override |
| | | public Integer addCoursePackage(TCoursePackage coursePackage) { |
| | | try { |
| | | |
| | | coursePackage.setInsertTime(new Date()); |
| | | this.baseMapper.insert(coursePackage); |
| | | |
| | | if (coursePackage.getClassStartTime() != null && coursePackage.getClassStartTime() != "") { |
| | | //生成排课数据 |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); |
| | |
| | | } |
| | | |
| | | |
| | | @Autowired |
| | | private ICoursePackageOrderStudentService orderStudentService; |
| | | /** |
| | | * 修改数据 |
| | | * |
| | |
| | | */ |
| | | @Override |
| | | public void updateCoursePackageById(TCoursePackage coursePackage) { |
| | | try { |
| | | List<CoursePackageStudent> coursePackageStudents = coursePackageStudentService.list(new QueryWrapper<CoursePackageStudent>().eq("coursePackageId", coursePackage.getId())); |
| | | List<Long> collect = coursePackageStudents.stream().map(CoursePackageStudent::getCoursePackageSchedulingId).collect(Collectors.toList()); |
| | | // try { |
| | | // List<CoursePackageStudent> coursePackageStudents = coursePackageStudentService.list(new QueryWrapper<CoursePackageStudent>().eq("coursePackageId", coursePackage.getId())); |
| | | // List<Long> collect = coursePackageStudents.stream().map(CoursePackageStudent::getCoursePackageSchedulingId).collect(Collectors.toList()); |
| | | // |
| | | // QueryWrapper<CoursePackageScheduling> coursePackageSchedulingQueryWrapper = new QueryWrapper<CoursePackageScheduling>().eq("coursePackageId", coursePackage.getId()); |
| | | // if (collect.size() > 0) { |
| | | // coursePackageSchedulingQueryWrapper.notIn("id", collect); |
| | | // } |
| | | // coursePackageSchedulingService.remove(coursePackageSchedulingQueryWrapper); |
| | | // int coursePackageId = orderStudentService.count(new QueryWrapper<CoursePackageOrderStudent>().eq("coursePackageId", coursePackage.getId())); |
| | | // if (coursePackageId>0) { |
| | | this.baseMapper.updateById(coursePackage); |
| | | |
| | | QueryWrapper<CoursePackageScheduling> coursePackageSchedulingQueryWrapper = new QueryWrapper<CoursePackageScheduling>().eq("coursePackageId", coursePackage.getId()); |
| | | if (collect.size() > 0) { |
| | | coursePackageSchedulingQueryWrapper.notIn("id", collect); |
| | | } |
| | | coursePackageSchedulingService.remove(coursePackageSchedulingQueryWrapper); |
| | | |
| | | this.baseMapper.updateById(coursePackage); |
| | | |
| | | //生成排课数据 |
| | | Date date = null; |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); |
| | | SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | CoursePackageScheduling coursePackageScheduling = coursePackageSchedulingService.getOne(new QueryWrapper<CoursePackageScheduling>().eq("coursePackageId", coursePackage.getId()).last(" and classDate > now() order by classDate desc limit 0, 1")); |
| | | if (null != coursePackageScheduling) { |
| | | date = sdf1.parse(sdf.format(coursePackageScheduling.getClassDate()) + " 00:00:00"); |
| | | } else { |
| | | date = sdf1.parse(sdf.format(new Date()) + " 00:00:00"); |
| | | } |
| | | List<String> list = Arrays.asList(coursePackage.getClassWeeks().split(";")); |
| | | String classStartTime = coursePackage.getClassStartTime(); |
| | | String[] split = classStartTime.split(":"); |
| | | String classEndTime = coursePackage.getClassEndTime(); |
| | | String[] split1 = classEndTime.split(":"); |
| | | Calendar s = Calendar.getInstance(); |
| | | s.setTime(date); |
| | | s.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + 1); |
| | | |
| | | Calendar e = Calendar.getInstance(); |
| | | e.setTime(date); |
| | | if (null != coursePackageScheduling) { |
| | | long time = sdf1.parse(sdf.format(new Date()) + " 00:00:00").getTime(); |
| | | int d = Long.valueOf(14L - ((s.getTimeInMillis() - time) / 86400000L)).intValue(); |
| | | e.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + d); |
| | | } else { |
| | | e.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + 14); |
| | | } |
| | | long timeInMillis = e.getTimeInMillis(); |
| | | |
| | | while (true) { |
| | | int w = s.get(Calendar.DAY_OF_WEEK); |
| | | WeekEnum weekEnum = WeekEnum.getWeekEnum(w); |
| | | if (list.contains(weekEnum.getChineseName())) { |
| | | Calendar classDate = Calendar.getInstance(); |
| | | classDate.setTime(s.getTime()); |
| | | classDate.set(Calendar.HOUR_OF_DAY, Integer.valueOf(split[0])); |
| | | classDate.set(Calendar.MINUTE, Integer.valueOf(split[1])); |
| | | classDate.set(Calendar.SECOND, 0); |
| | | |
| | | Calendar endDate = Calendar.getInstance(); |
| | | endDate.setTime(s.getTime()); |
| | | endDate.set(Calendar.HOUR_OF_DAY, Integer.valueOf(split1[0])); |
| | | endDate.set(Calendar.MINUTE, Integer.valueOf(split1[1])); |
| | | endDate.set(Calendar.SECOND, 0); |
| | | |
| | | CoursePackageScheduling coursePackageScheduling1 = new CoursePackageScheduling(); |
| | | coursePackageScheduling1.setCoursePackageId(coursePackage.getId()); |
| | | coursePackageScheduling1.setClassDate(classDate.getTime()); |
| | | coursePackageScheduling1.setEndDate(endDate.getTime()); |
| | | coursePackageScheduling1.setStatus(1); |
| | | coursePackageSchedulingService.save(coursePackageScheduling1); |
| | | } |
| | | s.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + 1); |
| | | if (s.getTimeInMillis() > timeInMillis) { |
| | | break; |
| | | } |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | //生成排课数据 |
| | | // Date date = null; |
| | | // SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); |
| | | // SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | // CoursePackageScheduling coursePackageScheduling = coursePackageSchedulingService.getOne(new QueryWrapper<CoursePackageScheduling>().eq("coursePackageId", coursePackage.getId()).last(" and classDate > now() order by classDate desc limit 0, 1")); |
| | | // if (null != coursePackageScheduling) { |
| | | // date = sdf1.parse(sdf.format(coursePackageScheduling.getClassDate()) + " 00:00:00"); |
| | | // } else { |
| | | // date = sdf1.parse(sdf.format(new Date()) + " 00:00:00"); |
| | | // } |
| | | // List<String> list = Arrays.asList(coursePackage.getClassWeeks().split(";")); |
| | | // String classStartTime = coursePackage.getClassStartTime(); |
| | | // String[] split = classStartTime.split(":"); |
| | | // String classEndTime = coursePackage.getClassEndTime(); |
| | | // String[] split1 = classEndTime.split(":"); |
| | | // Calendar s = Calendar.getInstance(); |
| | | // s.setTime(date); |
| | | // s.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + 1); |
| | | // |
| | | // Calendar e = Calendar.getInstance(); |
| | | // e.setTime(date); |
| | | // if (null != coursePackageScheduling) { |
| | | // long time = sdf1.parse(sdf.format(new Date()) + " 00:00:00").getTime(); |
| | | // int d = Long.valueOf(14L - ((s.getTimeInMillis() - time) / 86400000L)).intValue(); |
| | | // e.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + d); |
| | | // } else { |
| | | // e.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + 14); |
| | | // } |
| | | // long timeInMillis = e.getTimeInMillis(); |
| | | // |
| | | // while (true) { |
| | | // int w = s.get(Calendar.DAY_OF_WEEK); |
| | | // WeekEnum weekEnum = WeekEnum.getWeekEnum(w); |
| | | // if (list.contains(weekEnum.getChineseName())) { |
| | | // Calendar classDate = Calendar.getInstance(); |
| | | // classDate.setTime(s.getTime()); |
| | | // classDate.set(Calendar.HOUR_OF_DAY, Integer.valueOf(split[0])); |
| | | // classDate.set(Calendar.MINUTE, Integer.valueOf(split[1])); |
| | | // classDate.set(Calendar.SECOND, 0); |
| | | // |
| | | // Calendar endDate = Calendar.getInstance(); |
| | | // endDate.setTime(s.getTime()); |
| | | // endDate.set(Calendar.HOUR_OF_DAY, Integer.valueOf(split1[0])); |
| | | // endDate.set(Calendar.MINUTE, Integer.valueOf(split1[1])); |
| | | // endDate.set(Calendar.SECOND, 0); |
| | | // |
| | | // CoursePackageScheduling coursePackageScheduling1 = new CoursePackageScheduling(); |
| | | // coursePackageScheduling1.setCoursePackageId(coursePackage.getId()); |
| | | // coursePackageScheduling1.setClassDate(classDate.getTime()); |
| | | // coursePackageScheduling1.setEndDate(endDate.getTime()); |
| | | // coursePackageScheduling1.setStatus(1); |
| | | // coursePackageSchedulingService.save(coursePackageScheduling1); |
| | | // } |
| | | // s.set(Calendar.DAY_OF_YEAR, s.get(Calendar.DAY_OF_YEAR) + 1); |
| | | // if (s.getTimeInMillis() > timeInMillis) { |
| | | // break; |
| | | // } |
| | | // } |
| | | // } |
| | | // } catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | // } |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 获取课包审核列表 |
| | | * |