From 53e7558400dcacecdce70e39ebfe1727740f9296 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期六, 25 十一月 2023 17:20:06 +0800
Subject: [PATCH] 重写课包支付和排课逻辑
---
cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java | 224 ++++++++++++++++++++++++++-----------------------------
1 files changed, 107 insertions(+), 117 deletions(-)
diff --git a/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java b/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java
index 4a96f2c..154f99b 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java
@@ -69,28 +69,29 @@
*/
@RequestMapping("/base/course/changeState")
@ResponseBody
- public Object changeState(@RequestBody CourseChangeStateDTO dto){
+ public Object changeState(@RequestBody CourseChangeStateDTO dto) {
return courseService.changeState(dto);
}
/**
* 通过课程ids获取课程
+ *
* @return
*/
@RequestMapping("/base/course/getCourseByCourseIds")
- public List<TQueryBenefitsVideosVO> getCourseByCourseIds(@RequestBody TQueryBenefitsVideosDTO query){
+ public List<TQueryBenefitsVideosVO> getCourseByCourseIds(@RequestBody TQueryBenefitsVideosDTO query) {
return courseService.getCourseByCourseIds(query);
}
@PostMapping("/base/course/queryList")
- public List<ExerciseVideo> queryStuCourseAfterVideos(@RequestBody List<Integer> courseIds){
+ public List<ExerciseVideo> queryStuCourseAfterVideos(@RequestBody List<Integer> courseIds) {
List<ExerciseVideo> videos = new ArrayList<>();
List<TCourse> list = courseService.list(new QueryWrapper<TCourse>()
.in("id", courseIds)
- .eq("state",1));
- if (list.size() > 0){
- list.forEach( vs ->{
+ .eq("state", 1));
+ if (list.size() > 0) {
+ list.forEach(vs -> {
ExerciseVideo video = new ExerciseVideo();
video.setVideoUrl(vs.getCourseVideo());
video.setVideoName(vs.getName());
@@ -107,7 +108,7 @@
@ApiOperation(value = "获取课程类型列表", tags = {"APP-课程列表"})
@ApiImplicitParams({
})
- public ResultUtil<List<BaseVo>> queryCoursePackageType(){
+ public ResultUtil<List<BaseVo>> queryCoursePackageType() {
try {
List<TCoursePackageType> coursePackageTypes = coursePackageTypeService.list(new QueryWrapper<TCoursePackageType>().eq("state", 1));
List<BaseVo> list = new ArrayList<>();
@@ -117,13 +118,11 @@
list.add(baseVo);
});
return ResultUtil.success(list);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
-
@ResponseBody
@@ -132,15 +131,15 @@
@ApiImplicitParams({
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....")
})
- public ResultUtil<List<CoursePackageListVo>> queryCourseList(CoursePackageList coursePackageList){
+ public ResultUtil<List<CoursePackageListVo>> queryCourseList(CoursePackageList coursePackageList) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
List<CoursePackageListVo> coursePackageListVos = coursePackageService.queryCourseList(uid, coursePackageList);
return ResultUtil.success(coursePackageListVos);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
@@ -153,17 +152,15 @@
@ApiImplicitParams({
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....")
})
- public ResultUtil<List<CoursePackageListVo>> queryCourseListOne(CoursePackageList coursePackageList){
+ public ResultUtil<List<CoursePackageListVo>> queryCourseListOne(CoursePackageList coursePackageList) {
try {
- List<CoursePackageListVo> coursePackageListVos = coursePackageService.queryCourseListOne( coursePackageList);
+ List<CoursePackageListVo> coursePackageListVos = coursePackageService.queryCourseListOne(coursePackageList);
return ResultUtil.success(coursePackageListVos);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
-
@ResponseBody
@@ -175,21 +172,19 @@
@ApiImplicitParam(value = "纬度", name = "lat", dataType = "string", required = false),
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....")
})
- public ResultUtil<CoursePackageInfo> queryCourseInfo(Integer id, String lon, String lat,Long payId){
+ public ResultUtil<CoursePackageInfo> queryCourseInfo(Integer id, String lon, String lat, Long payId) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
CoursePackageInfo coursePackageInfo = coursePackageService.queryCourseInfo(uid, id, lon, lat);
return ResultUtil.success(coursePackageInfo);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
}
-
-
@ResponseBody
@@ -198,18 +193,18 @@
@ApiImplicitParams({
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....")
})
- public synchronized ResultUtil paymentCourse(PaymentCourseVo paymentCourseVo){
+ public synchronized ResultUtil paymentCourse(PaymentCourseVo paymentCourseVo) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
Long couponId = paymentCourseVo.getCouponId();
- if(couponId==null || couponId==0){
+ if (couponId == null || couponId == 0) {
paymentCourseVo.setCouponId(null);
}
return coursePackageService.paymentCourse(uid, paymentCourseVo);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
@@ -222,14 +217,14 @@
@ApiImplicitParams({
@ApiImplicitParam(name = "Authorization", value = "用户token（Bearer +token）", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9.....")
})
- public ResultUtil paymentCourseCouponList(Integer coursePackagePaymentConfigId){
+ public ResultUtil paymentCourseCouponList(Integer coursePackagePaymentConfigId) {
try {
Integer uid = tokenUtil.getUserIdFormRedis();
- if(null == uid){
+ if (null == uid) {
return ResultUtil.tokenErr();
}
return coursePackageService.paymentCourseCouponList(uid, coursePackagePaymentConfigId);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return ResultUtil.runErr();
}
@@ -237,34 +232,30 @@
/**
* 购买课程微信支付回调
+ *
* @param request
* @param response
*/
@ResponseBody
@PostMapping("/base/course/weChatPaymentCourseCallback")
- public void weChatPaymentCourseCallback(HttpServletRequest request, HttpServletResponse response){
+ public void weChatPaymentCourseCallback(HttpServletRequest request, HttpServletResponse response) {
try {
Map<String, String> map = payMoneyUtil.weixinpayCallback(request);
- if(null != map){
+ if (null != map) {
String code = map.get("out_trade_no");
String transaction_id = map.get("transaction_id");
+ String attach = map.get("attach");
String result = map.get("result");
- List<TCoursePackagePayment> list = coursePackagePaymentService.list(new QueryWrapper<TCoursePackagePayment>().eq("state", 1).eq("code", code).eq("payType", 1));
- TCoursePackagePayment one = list.get(0);
- if(one.getPayStatus() == 1){
- for (TCoursePackagePayment coursePackagePayment : list) {
- coursePackagePayment.setPayStatus(2);
- coursePackagePayment.setOrderNumber(transaction_id);
- }
- coursePackagePaymentService.updateBatchById(list);
+ ResultUtil resultUtil = coursePackageService.paymentCourseCallback(code, transaction_id, attach);
+ if (resultUtil.getCode() == 200) {
+ PrintWriter out = response.getWriter();
+ out.write(result);
+ out.flush();
+ out.close();
}
- PrintWriter out = response.getWriter();
- out.write(result);
- out.flush();
- out.close();
}
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
}
}
@@ -272,59 +263,45 @@
/**
* 购买课程支付宝回调
+ *
* @param request
* @param response
*/
@ResponseBody
@PostMapping("/base/course/aliPaymentCourseCallback")
- public void aliPaymentCourseCallback(HttpServletRequest request, HttpServletResponse response){
+ public void aliPaymentCourseCallback(HttpServletRequest request, HttpServletResponse response) {
try {
- System.err.println("=====支付宝回调=======");
Map<String, String> map = payMoneyUtil.alipayCallback(request);
- if(null != map){
+ if (null != map) {
String code = map.get("out_trade_no");
String trade_no = map.get("trade_no");
-
- List<TCoursePackagePayment> list = coursePackagePaymentService.list(new QueryWrapper<TCoursePackagePayment>().eq("state", 1).eq("code", code).eq("payType", 2));
- TCoursePackagePayment one = list.get(0);
- if(one.getPayStatus() == 1){
- for (TCoursePackagePayment coursePackagePayment : list) {
- coursePackagePayment.setPayStatus(1);
- coursePackagePayment.setOrderNumber(trade_no);
- coursePackagePayment.setAppUserId(null);
- }
- coursePackagePaymentService.updateBatchById(list);
+ String passback_params = map.get("passback_params");
+ ResultUtil resultUtil = coursePackageService.paymentCourseCallback(code, trade_no, passback_params);
+ if (resultUtil.getCode() == 200) {
+ PrintWriter out = response.getWriter();
+ out.write("success");
+ out.flush();
+ out.close();
}
- PrintWriter out = response.getWriter();
- out.write("success");
- out.flush();
- out.close();
}
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
}
}
- //分账
- public void moneyOut(){
-
-
-
- }
-
-
/**
* 根据id获取课程数据
+ *
* @param id
* @return
*/
@ResponseBody
@PostMapping("/course/queryCourseById")
- public TCourse queryCourseById(@RequestBody Integer id){
+ public TCourse queryCourseById(@RequestBody Integer id) {
try {
return courseService.getById(id);
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return null;
}
@@ -333,15 +310,16 @@
/**
* 根据名称获取数据
+ *
* @param name
* @return
*/
@ResponseBody
@PostMapping("/course/queryCourseByName")
- public List<TCourse> queryCourseByName(@RequestBody String name){
+ public List<TCourse> queryCourseByName(@RequestBody String name) {
try {
return courseService.list(new QueryWrapper<TCourse>().like("name", name).eq("state", 1));
- }catch (Exception e){
+ } catch (Exception e) {
e.printStackTrace();
return null;
}
@@ -349,13 +327,13 @@
@PostMapping("/course/getPageageType")
- public List<Map<String, Object>> getPageageType(){
+ public List<Map<String, Object>> getPageageType() {
List<TCoursePackageType> list = coursePackageTypeService.list(new LambdaQueryWrapper<TCoursePackageType>().eq(TCoursePackageType::getState, 1));
ArrayList<Map<String, Object>> objects = new ArrayList<>();
for (TCoursePackageType tCoursePackageType : list) {
HashMap<String, Object> map = new HashMap<>();
- map.put("id",tCoursePackageType.getId());
- map.put("name",tCoursePackageType.getName());
+ map.put("id", tCoursePackageType.getId());
+ map.put("name", tCoursePackageType.getName());
objects.add(map);
}
return objects;
@@ -364,12 +342,13 @@
/**
* 获取课程管理列表数据
+ *
* @param queryCourseList
* @return
*/
@ResponseBody
@PostMapping("/course/queryCourseLists")
- public Page<Map<String, Object>> queryCourseLists(@RequestBody QueryCourseList queryCourseList){
+ public Page<Map<String, Object>> queryCourseLists(@RequestBody QueryCourseList queryCourseList) {
Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage(queryCourseList.getLimit(), queryCourseList.getOffset(), queryCourseList.getSort(), queryCourseList.getOrder());
Page<Map<String, Object>> mapPage = page.setRecords(courseService.queryCourseList(page, queryCourseList));
return mapPage;
@@ -378,11 +357,12 @@
/**
* 添加课程
+ *
* @param course
*/
@ResponseBody
@PostMapping("/course/addCourse")
- public void addCourse(@RequestBody TCourse course){
+ public void addCourse(@RequestBody TCourse course) {
course.setState(1);
course.setInsertTime(new Date());
courseService.save(course);
@@ -391,24 +371,26 @@
/**
* 编辑数据
+ *
* @param course
*/
@ResponseBody
@PostMapping("/course/editCourse")
- public void editCourse(@RequestBody TCourse course){
+ public void editCourse(@RequestBody TCourse course) {
courseService.updateById(course);
}
/**
* 删除数据
+ *
* @param id
*/
@ResponseBody
@PostMapping("/course/delCourseById")
- public void delCourseById(@RequestBody Integer id){
+ public void delCourseById(@RequestBody Integer id) {
TCourse course = courseService.getById(id);
- if(null != course){
+ if (null != course) {
course.setState(3);
courseService.updateById(course);
}
@@ -417,13 +399,14 @@
/**
* 编辑数据状态
+ *
* @param editCourseState
*/
@ResponseBody
@PostMapping("/course/editCourseState")
- public void editCourseState(@RequestBody EditCourseState editCourseState){
+ public void editCourseState(@RequestBody EditCourseState editCourseState) {
TCourse course = courseService.getById(editCourseState.getId());
- if(null != course){
+ if (null != course) {
course.setState(editCourseState.getState());
courseService.updateById(course);
}
@@ -432,18 +415,19 @@
/**
* 根据类型获取数据
+ *
* @param type
* @return
*/
@ResponseBody
@PostMapping("/course/queryCourseByType")
- public List<TCourse> queryCourseByType(@RequestBody Integer type){
+ public List<TCourse> queryCourseByType(@RequestBody Integer type) {
return courseService.list(new QueryWrapper<TCourse>().eq("type", type).eq("state", 1));
}
@PostMapping("/course/queryPackageById")
- public List<String> queryPackageById(@RequestBody Integer coursePackageId){
+ public List<String> queryPackageById(@RequestBody Integer coursePackageId) {
ArrayList<String> strings = new ArrayList<>();
TCoursePackage byId = coursePackageService.getById(coursePackageId);
Integer coursePackageTypeId = byId.getCoursePackageTypeId();
@@ -453,28 +437,31 @@
return strings;
}
+
// 获取课包商品的价格配置
@PostMapping("/course/getHoursByPackageId")
@ResponseBody
- public List<CoursePackagePaymentConfig> getHoursByPackageId(@RequestBody Integer coursePackageId1){
+ public List<CoursePackagePaymentConfig> getHoursByPackageId(@RequestBody Integer coursePackageId1) {
List<CoursePackagePaymentConfig> coursePackageId = coursePackagePaymentConfigService.list(new QueryWrapper<CoursePackagePaymentConfig>()
.eq("coursePackageId", coursePackageId1));
return coursePackageId;
}
+
@PostMapping("/course/getHours")
- public List<Integer> getHours(@RequestBody Integer coursePackageId1){
+ public List<Integer> getHours(@RequestBody Integer coursePackageId1) {
return coursePackageService.getHours(coursePackageId1);
}
@PostMapping("/course/queryByDiscountId")
- public TCoursePackage queryByDiscountId(@RequestBody Integer id){
+ public TCoursePackage queryByDiscountId(@RequestBody Integer id) {
TCoursePackageDiscount byId = discountService.getById(id);
TCoursePackage byId1 = coursePackageService.getById(byId.getCoursePackageId());
return byId1;
}
+
@ResponseBody
@PostMapping("/course/queryByDiscountId1")
- public TCoursePackage queryByDiscountId1(@RequestBody Integer id){
+ public TCoursePackage queryByDiscountId1(@RequestBody Integer id) {
TCoursePackageDiscount byId = discountService.getById(id);
TCoursePackage byId1 = coursePackageService.getById(byId.getCoursePackageId());
return byId1;
@@ -482,32 +469,33 @@
@PostMapping("/course/queryDiscountById")
- public Integer queryDiscountById(@RequestBody Integer id){
+ public Integer queryDiscountById(@RequestBody Integer id) {
TCoursePackageDiscount byId = discountService.getById(id);
return byId.getAuditStatus();
}
+
@PostMapping("/course/queryDiscountList")
- public List<DiscountList> queryDiscountList(@RequestBody QueryDiscountList queryDiscountList){
+ public List<DiscountList> queryDiscountList(@RequestBody QueryDiscountList queryDiscountList) {
return discountService.queryDiscountList(queryDiscountList);
}
@PostMapping("/course/queryDiscountListAudit")
- public List<DiscountList> queryDiscountListAudit(@RequestBody QueryDiscountList queryDiscountList){
+ public List<DiscountList> queryDiscountListAudit(@RequestBody QueryDiscountList queryDiscountList) {
return discountService.queryDiscountListAudit(queryDiscountList);
}
@PostMapping("/course/updateState")
- public Boolean updateState( @RequestBody DiscountUpdateState discountUpdateState){
+ public Boolean updateState(@RequestBody DiscountUpdateState discountUpdateState) {
TCoursePackageDiscount byId = discountService.getById(discountUpdateState.getId());
List<TCoursePackageDiscount> list = discountService.list(new LambdaQueryWrapper<TCoursePackageDiscount>().eq(TCoursePackageDiscount::getCoursePackageId, byId.getCoursePackageId()));
- list.forEach(e->e.setStatus(discountUpdateState.getStatus()));
+ list.forEach(e -> e.setStatus(discountUpdateState.getStatus()));
return discountService.updateBatchById(list);
}
@PostMapping("/course/auditDiscount")
- public Boolean auditDiscount( @RequestBody AuditDiscount auditDiscount){
+ public Boolean auditDiscount(@RequestBody AuditDiscount auditDiscount) {
List<TCoursePackageDiscount> list = discountService.list(new LambdaQueryWrapper<TCoursePackageDiscount>()
.eq(TCoursePackageDiscount::getCoursePackageId, auditDiscount.getId()));
@@ -518,11 +506,13 @@
return discountService.updateBatchById(list);
}
+
@Autowired
private ICoursePackagePaymentConfigService packagePaymentConfigService;
+
@PostMapping("/course/times")
- public List<SelectDto> times(@RequestBody Integer oneId){
- List<CoursePackagePaymentConfig> list = packagePaymentConfigService.list(new QueryWrapper<CoursePackagePaymentConfig>().eq("coursePackageId",oneId));
+ public List<SelectDto> times(@RequestBody Integer oneId) {
+ List<CoursePackagePaymentConfig> list = packagePaymentConfigService.list(new QueryWrapper<CoursePackagePaymentConfig>().eq("coursePackageId", oneId));
List<SelectDto> integerList = new ArrayList<>();
for (CoursePackagePaymentConfig coursePackagePaymentConfig : list) {
// integerList.add(coursePackagePaymentConfig.getClassHours());
@@ -537,32 +527,32 @@
}
@PostMapping("/course/queryFee")
- public HashMap<String, Object> queryFee(@RequestBody QueryDataFee queryDataFee){
+ public HashMap<String, Object> queryFee(@RequestBody QueryDataFee queryDataFee) {
HashMap<String, Object> map = new HashMap<>();
String data = queryDataFee.getData();
List<Integer> ids = queryDataFee.getIds();
- if(ids.size()==0){
+ if (ids.size() == 0) {
ids.add(-1);
}
LambdaQueryWrapper<TCoursePackagePayment> wrapper = new LambdaQueryWrapper<>();
- if(ToolUtil.isNotEmpty(data)){
- String stime = data.split(" - ")[0]+" 00:00:00";
- String etime = data.split(" - ")[1]+" 23:59:59";
- wrapper.between(TCoursePackagePayment::getInsertTime,stime,etime);
+ if (ToolUtil.isNotEmpty(data)) {
+ String stime = data.split(" - ")[0] + " 00:00:00";
+ String etime = data.split(" - ")[1] + " 23:59:59";
+ wrapper.between(TCoursePackagePayment::getInsertTime, stime, etime);
}
- wrapper.in(TCoursePackagePayment::getAppUserId,ids);
- wrapper.eq(TCoursePackagePayment::getPayStatus,2);
+ wrapper.in(TCoursePackagePayment::getAppUserId, ids);
+ wrapper.eq(TCoursePackagePayment::getPayStatus, 2);
ArrayList<Integer> objects = new ArrayList<>();
objects.add(1);
objects.add(2);
objects.add(5);
objects.add(6);
- wrapper.in(TCoursePackagePayment::getPayType,objects);
+ wrapper.in(TCoursePackagePayment::getPayType, objects);
List<TCoursePackagePayment> list = coursePackagePaymentService.list(wrapper);
double v = list.stream().map(TCoursePackagePayment::getCashPayment).reduce(BigDecimal.ZERO, BigDecimal::add).doubleValue();
List<Integer> collect = list.stream().map(TCoursePackagePayment::getCoursePackageId).collect(Collectors.toList());
- if(collect.size()==0){
+ if (collect.size() == 0) {
collect.add(-1);
}
//
@@ -572,7 +562,7 @@
for (TCoursePackagePayment tCoursePackagePayment : list) {
for (TCoursePackage tCoursePackage : list2) {
- if(tCoursePackagePayment.getCoursePackageId().equals(tCoursePackage.getId())){
+ if (tCoursePackagePayment.getCoursePackageId().equals(tCoursePackage.getId())) {
tCoursePackagePayment.setType(tCoursePackage.getCoursePackageTypeId());
}
}
@@ -582,20 +572,20 @@
for (TCoursePackageType tCoursePackageType : list1) {
HashMap<String, Object> objectObjectHashMap = new HashMap<>();
- objectObjectHashMap.put("name",tCoursePackageType.getName());
- double a= 0;
+ objectObjectHashMap.put("name", tCoursePackageType.getName());
+ double a = 0;
for (TCoursePackagePayment tCoursePackagePayment : list) {
- if(tCoursePackagePayment.getType().equals(tCoursePackageType.getId())){
- a += tCoursePackagePayment.getCashPayment().doubleValue();
+ if (tCoursePackagePayment.getType().equals(tCoursePackageType.getId())) {
+ a += tCoursePackagePayment.getCashPayment().doubleValue();
}
}
- objectObjectHashMap.put("value",a);
+ objectObjectHashMap.put("value", a);
hashMaps.add(objectObjectHashMap);
}
HashMap<String, Object> map1 = new HashMap<>();
- map1.put("fee",v);
- map1.put("data",hashMaps);
+ map1.put("fee", v);
+ map1.put("data", hashMaps);
return map1;
}
--
Gitblit v1.7.1