From c70c9ecf1bee12e85778dc268308c872b95e477f Mon Sep 17 00:00:00 2001
From: lisy <linlangsur163@163.com>
Date: 星期五, 04 八月 2023 16:22:42 +0800
Subject: [PATCH] app端:开始上课中,新增预约接口

---
 cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java |  263 ++++++++++++++++++++++++++++++++++++++++------------
 1 files changed, 202 insertions(+), 61 deletions(-)

diff --git a/cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java b/cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java
index b9be5bb..331c57c 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java
@@ -1,11 +1,16 @@
 package com.dsh.course.controller;
 
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.dsh.course.entity.*;
 import com.dsh.course.feignclient.account.AppUserClient;
+import com.dsh.course.feignclient.account.StudentClient;
 import com.dsh.course.feignclient.account.model.AppUser;
+import com.dsh.course.feignclient.account.model.Student;
 import com.dsh.course.feignclient.model.*;
+import com.dsh.course.feignclient.other.StoreClient;
+import com.dsh.course.feignclient.other.model.Store;
 import com.dsh.course.model.BaseVo;
 import com.dsh.course.model.dto.DiscountJsonDto;
 import com.dsh.course.model.vo.CourseDetailRequest;
@@ -28,11 +33,17 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import java.io.PrintWriter;
 import java.math.BigDecimal;
+import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
+import java.util.Map;
 import java.util.stream.Collectors;
 
 @Api
@@ -63,7 +74,8 @@
     @Autowired
     private TCourseService tcService;
 
-
+    @Resource
+    private StudentClient studentClient;
 
     @Autowired
     private TCoursePackageTypeService coursePackageTypeService;
@@ -74,8 +86,17 @@
     @Autowired
     private CancelledClassesService cancelledClassesService;
 
+    @Resource
+    private CoursePackageStudentService cspsService;
+
+
     @Autowired
-    private AppUserClient appuClient;
+    private PayMoneyUtil payMoneyUtil;
+    @Resource
+    private AppUserClient auClitn;
+
+    @Resource
+    private StoreClient sreClient;
 
     private final SimpleDateFormat format = new SimpleDateFormat("MM-dd HH:mm");
 
@@ -84,11 +105,13 @@
      * @param stuId 学员id
      * @return  课包列表
      */
+    @ResponseBody
     @PostMapping("/base/coursePack/queryPayment")
-    public List<StuCourseResp> getStuCoursePackagePayment(@RequestParam("stuId") Integer stuId,@RequestParam("appUserId") Integer appUserId){
+    public List<StuCourseResp> getStuCoursePackagePayment(@RequestBody Integer stuId){
         List<StuCourseResp> resps = new ArrayList<>();
+        Student student = studentClient.queryStudentById(stuId);
         List<TCoursePackagePayment> byUserId = packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
-                .eq("appUserId",appUserId)
+                .eq("appUserId",student.getAppUserId())
                 .eq("studentId",stuId));
 
         if (byUserId.size() > 0 ){
@@ -100,6 +123,8 @@
                 resp.setTotalCourseNums(tCoursePackagePayment.getTotalClassHours());
                 resp.setResidueNums(tCoursePackagePayment.getLaveClassHours());
                 resp.setDeductionNums(tCoursePackagePayment.getTotalClassHours()-tCoursePackagePayment.getLaveClassHours());
+                String afterDayDate = DateUtil.getAfterDayDate2(tCoursePackage.getInsertTime(),tCoursePackage.getValidDays() + "");
+                resp.setPeriodOfValidity(afterDayDate);
                 resps.add(resp);
             }
         }
@@ -110,21 +135,60 @@
      *
      * 获取发布的 课包列表
      */
+    @ResponseBody
     @PostMapping("/base/coursePack/storeOfCourse")
-    public List<CourseOfStoreVo> getStuCourseWithStores(){
-        List<CourseOfStoreVo> courseOfStoreVos = tcpService.queryStoreOfCourse();
-        if (courseOfStoreVos.size() > 0){
-            for (CourseOfStoreVo courseOfStoreVo : courseOfStoreVos) {
-                String[] split = courseOfStoreVo.getClassWeeks().split(";");
-                List<Integer> integers = new ArrayList<>();
-                for (String s : split) {
-                    int num = Integer.parseInt(s);
-                    integers.add(num);
+    public List<CourseOfStoreVo> getStuCourseWithStores(@RequestBody WeeksOfCourseRest courseRest){
+        List<CourseOfStoreVo> course = new ArrayList<>();
+        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
+        try {
+            Date parse = simpleDateFormat.parse(courseRest.getTime());
+            List<TCoursePackagePayment> list = packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
+                    .eq("appUserId",courseRest.getAppUserId() )
+                    .eq("studentId",courseRest.getStuId())
+                    .eq("payStatus",2)
+                    .eq("status",1)
+                    .eq("state",1)
+                    .groupBy("coursePackageId"));
+            if (list.size() >  0){
+                for (TCoursePackagePayment tCoursePackagePayment : list) {
+                    CoursePackageStudent packageStudent = cspsService.getOne(new LambdaQueryWrapper<CoursePackageStudent>()
+                            .eq(CoursePackageStudent::getAppUserId, courseRest.getAppUserId())
+                            .eq(CoursePackageStudent::getStudentId,courseRest.getStuId())
+                            .eq(CoursePackageStudent::getCoursePackagePaymentId,tCoursePackagePayment.getId())
+                            .eq(CoursePackageStudent::getCoursePackageId,tCoursePackagePayment.getCoursePackageId()));
+                    if (ToolUtil.isEmpty(packageStudent) || (ToolUtil.isNotEmpty(packageStudent) && packageStudent.getReservationStatus() != 1)){
+//                        没有预约过的/已经取消了的
+                        TCoursePackage tCoursePackage = tcpService.getById(tCoursePackagePayment.getCoursePackageId());
+                        CoursePackagePaymentConfig paymentConfig = icppcService.getOne(new QueryWrapper<CoursePackagePaymentConfig>()
+                                .eq("coursePackageId",tCoursePackage.getId() )
+                                .eq("classHours",tCoursePackagePayment.getClassHours()));
+//                    获取课程有效结束时间,判断 查询的日期parse 是否在有效期范围内
+                        Date expirationDate = DateTimeHelper.getExpirationDate(tCoursePackagePayment.getInsertTime(),tCoursePackage.getValidDays());
+                        System.out.println(expirationDate.after(parse));
+                        String classWeeks = tCoursePackage.getClassWeeks();
+                        System.out.println(StrUtils.dealStrToList(classWeeks).contains(DateTimeHelper.getDayOfWeek(parse)));
+                        if (expirationDate.after(parse) && StrUtils.dealStrToList(classWeeks).contains(DateTimeHelper.getDayOfWeek(parse))){
+                            CourseOfStoreVo storeVo = new CourseOfStoreVo();
+                            storeVo.setCourseId(packageStudent.getId());
+                            storeVo.setCourseName(tCoursePackage.getName());
+                            storeVo.setClassStartTime(tCoursePackage.getClassStartTime());
+                            storeVo.setClassEndTime(tCoursePackage.getClassEndTime());
+                            storeVo.setStoreId(tCoursePackage.getStoreId());
+                            Store store = sreClient.queryStoreById(tCoursePackage.getStoreId());
+                            storeVo.setStoreAddress(store.getAddress());
+                            storeVo.setLat(store.getLat());
+                            storeVo.setLon(store.getLon());
+                            storeVo.setCoursePrice(ToolUtil.isEmpty(paymentConfig.getCashPayment()) ? (double) paymentConfig.getPlayPaiCoin():paymentConfig.getCashPayment());
+                            course.add(storeVo);
+                        }
+                    }
                 }
-                courseOfStoreVo.setClassWeekList(integers);
             }
+            System.out.println(course);
+            return course;
+        } catch (ParseException e) {
+            return null;
         }
-        return tcpService.queryStoreOfCourse();
     }
 
 
@@ -156,13 +220,13 @@
     }
 
     @PostMapping("/base/coursePack/paymentCourse")
-    public List<PurchaseRecordVo> queryCourseDetails(@RequestParam("startTime") Date startTime, @RequestParam("endTime") Date  endTime,@RequestParam("stuId") Integer stuId, @RequestParam("appUserId") Integer appUserId) {
+    public List<PurchaseRecordVo> queryCourseDetails(@RequestBody GetStuSessionList sessionList) {
         List<PurchaseRecordVo> purchaseRecordVos = new ArrayList<>();
 
         List<TCoursePackagePayment> coursePackage = packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
-                .between("insertTime", startTime,endTime)
-                .eq("appUserId",appUserId)
-                .eq("studentId",stuId));
+                .between("insertTime", sessionList.getStartTime(),sessionList.getEndTime())
+                .eq("appUserId",sessionList.getAppUserId())
+                .eq("studentId",sessionList.getStuId()));
         if (coursePackage.size() > 0 ){
             coursePackage.forEach( cspackage -> {
                 PurchaseRecordVo recordVo = new PurchaseRecordVo();
@@ -230,33 +294,9 @@
             if (integers.size() > 0){
                 StringBuilder courWeeks = new StringBuilder("每");
                 for (Integer integer : integers) {
-                    switch (integer){
-                        case 1:
-                            courWeeks.append("周一、");
-                            break;
-                        case 2:
-                            courWeeks.append("周二、");
-                            break;
-                        case 3:
-                            courWeeks.append("周三、");
-                            break;
-                        case 4:
-                            courWeeks.append("周四、");
-                            break;
-                        case 5:
-                            courWeeks.append("周五、");
-                            break;
-                        case 6:
-                            courWeeks.append("周六、");
-                            break;
-                        case 7:
-                            courWeeks.append("周末、");
-                            break;
-                        default:
-                            break;
-                    }
+                    courWeeks.append(integer).append("、");
                 }
-                if (courWeeks.length() > 0 && courWeeks.charAt(courWeeks.length() - 1) == ','){
+                if (courWeeks.length() > 0 && courWeeks.charAt(courWeeks.length() - 1) == '、'){
                     courWeeks.deleteCharAt(courWeeks.length() - 1);
                 }
                 courseVo.setCourseWeek(courWeeks.toString());
@@ -331,18 +371,19 @@
     }
 
     @PostMapping("/base/coursePack/allAmountPayRecordOfUser")
-    public List<TCoursePackagePayment> getAmountPayRecord(@RequestBody Integer appUserId){
+    public List<TCoursePackagePayment> getAmountPayRecord(@RequestBody BillingDataRequestVo billingDataRequestVo){
         return packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
-                .eq("appUserId",appUserId)
+                .eq("appUserId",billingDataRequestVo.getAppUserId())
                 .notIn("payType",3)
                 .eq("payStatus",2)
-                .eq("state",1));
+                .eq("state",1)
+                .between("insertTime",billingDataRequestVo.getMonthStart(),billingDataRequestVo.getMonthEnd()));
     }
 
 
     @ResponseBody
     @PostMapping("/api/course/queryArrangeCourseList")
-    @ApiOperation(value = "获取布置课程列表", tags = {"APP-课程列表"})
+    @ApiOperation(value = "课后练习-获取布置课程列表", tags = {"APP-开始上课"})
     @ApiImplicitParams({
     })
     public ResultUtil<List<BaseVo>> queryArrangePackageType(){
@@ -361,7 +402,7 @@
                 baseVo.setName(coursePackage.getName());
                 list.add(baseVo);
             });
-            return ResultUtil.success();
+            return ResultUtil.success(list);
         }catch (Exception e){
             e.printStackTrace();
             return ResultUtil.runErr();
@@ -374,7 +415,7 @@
      */
     @ResponseBody
     @PostMapping("/api/startCource/afterSourceList")
-    @ApiOperation(value = "课后视频课表", tags = {"APP-开始上课"})
+    @ApiOperation(value = "课后练习-课后视频列表", tags = {"APP-开始上课"})
     @ApiImplicitParams({
             @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
     })
@@ -386,9 +427,12 @@
                 return ResultUtil.tokenErr();
             }
             List<Integer> courseIds = new ArrayList<>();
-            List<TCoursePackagePayment> tCoursePackagePayments = packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
-                    .eq("coursePackageId",search.getCourseTypeId())
-                    .eq("appUserId",appUserId));
+            QueryWrapper<TCoursePackagePayment> queryWrapper = new QueryWrapper<TCoursePackagePayment>().eq("appUserId", appUserId)
+                    .groupBy("coursePackageId");
+            if (ToolUtil.isNotEmpty(search.getCourseTypeId())){
+                queryWrapper.eq("coursePackageId",search.getCourseTypeId());
+            }
+            List<TCoursePackagePayment> tCoursePackagePayments = packagePaymentService.list(queryWrapper);
             if (tCoursePackagePayments.size() > 0 ){
                 courseIds = tCoursePackagePayments.stream().map(TCoursePackagePayment::getCoursePackageId).collect(Collectors.toList());
             }
@@ -403,7 +447,7 @@
      */
     @ResponseBody
     @PostMapping("/api/startCource/afterSourceDetail")
-    @ApiOperation(value = "课后视频详情", tags = {"APP-开始上课"})
+    @ApiOperation(value = "课后练习-课后视频详情", tags = {"APP-开始上课"})
     @ApiImplicitParams({
             @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
     })
@@ -498,7 +542,7 @@
             @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
             @ApiImplicitParam(name = "coursePayId" ,value = "课包记录id",dataType = "long"),
     })
-    public ResultUtil<CourseDetailsResponse> getRegisteredData( Integer coursePayId){
+    public ResultUtil<CourseDetailsResponse> getRegisteredData(Long coursePayId){
         try {
             Integer appUserId = tokenUtil.getUserIdFormRedis();
             if(null == appUserId){
@@ -532,6 +576,58 @@
         }
 
     }
+
+
+
+    /**
+     * 课包续课支付宝支付回调接口
+     */
+    @PostMapping("/base/coursePackage/alipayRegisteredCoursesCallback")
+    public void alipayCallback(HttpServletRequest request, HttpServletResponse response){
+        try {
+            Map<String, String> map = payMoneyUtil.alipayCallback(request);
+            if(null != map){
+                String out_trade_no = map.get("out_trade_no");
+                String transaction_id = map.get("transaction_id");
+                ResultUtil resultUtil = packagePaymentService.insertVipPaymentCallback(out_trade_no, transaction_id);
+                if(resultUtil.getCode() == 200){
+                    PrintWriter out = response.getWriter();
+                    out.write("success");
+                    out.flush();
+                    out.close();
+                }
+            }
+        }catch (Exception e){
+            e.printStackTrace();
+        }
+    }
+
+
+    /**
+     * 课包续课微信支付回调接口
+     */
+    @PostMapping("/base/coursePackage/wechatRegisteredCoursesCallback")
+    public void weChatCallback(HttpServletRequest request, HttpServletResponse response){
+        try {
+            Map<String, String> map = payMoneyUtil.weixinpayCallback(request);
+            if(null != map){
+                String out_trade_no = map.get("out_trade_no");
+                String transaction_id = map.get("transaction_id");
+                String result = map.get("result");
+                ResultUtil resultUtil = packagePaymentService.insertVipPaymentCallback(out_trade_no, transaction_id);
+                if(resultUtil.getCode() == 200){
+                    PrintWriter out = response.getWriter();
+                    out.write(result);
+                    out.flush();
+                    out.close();
+                }
+            }
+        }catch (Exception e){
+            e.printStackTrace();
+        }
+    }
+
+
 
 
     /**
@@ -638,7 +734,7 @@
                 return 2;
             }
             CoursePackagePaymentConfig paymentConfig = icppcService.getById(coursePackage.getCoursePayConfigId());
-            AppUser appUser = appuClient.queryAppUser(userIdFormRedis);
+            AppUser appUser = auClitn.queryAppUser(userIdFormRedis);
             if (appUser.getPlayPaiCoins() < paymentConfig.getPlayPaiCoin()){
                 return 3;
             }
@@ -653,7 +749,7 @@
             packagePaymentService.updateById(packagePayment);
 
             appUser.setPlayPaiCoins(appUser.getPlayPaiCoins()-paymentConfig.getPlayPaiCoin());
-            appuClient.updateAppUser(appUser);
+            auClitn.updateAppUser(appUser);
         } catch (Exception e) {
             return 4;
         }
@@ -683,10 +779,9 @@
 
 
     @PostMapping("/base/coursePack/obtainStudentClassDetails")
-    public List<RecordAppoint> obtainStudentClassDetailsData(@RequestBody Integer stuId){
+    public List<RecordAppoint> obtainStudentClassDetailsData(@RequestBody WeeksOfCourseRest stuId){
         try {
-            Integer appUserId = tokenUtil.getUserIdFormRedis();
-            return packagePaymentService.obtainStuClassDetails(stuId,appUserId);
+            return packagePaymentService.obtainStuClassDetails(stuId.getStuId(),stuId.getAppUserId());
         }catch (Exception e){
             e.printStackTrace();
             throw new RuntimeException();
@@ -700,4 +795,50 @@
                 .eq("coursePackageId",coursePackageId));
     }
 
+
+
+    @PostMapping("/base/coursePack/getCoursePackagePaymentOfCode")
+    public List<TCoursePackagePayment> getCoursePackagePaymentOfCode(@RequestBody String code){
+        return packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
+                .eq("code",code));
+    }
+
+
+
+    /**
+     * 上课主页-预约操作
+     */
+    @ResponseBody
+    @PostMapping("/api/startCource/reverse")
+    @ApiOperation(value = "上课主页-预约操作", tags = {"APP-开始上课"})
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
+            @ApiImplicitParam(value = "上课记录id", name = "coursePackId", required = true, dataType = "String"),
+            @ApiImplicitParam(value = "时间 yyyy-MM-dd", name = "time", required = true, dataType = "String"),
+            @ApiImplicitParam(value = "学员id", name = "time", required = true, dataType = "int"),
+    })
+    public ResultUtil reverse(String courseID,String time,Integer stuId){
+        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
+        try {
+            Integer appUserId = tokenUtil.getUserIdFormRedis();
+            if(null == appUserId){
+                return ResultUtil.tokenErr();
+            }
+            CoursePackageStudent coursePackageStudent = cspsService.getOne(new LambdaQueryWrapper<CoursePackageStudent>()
+                    .eq(CoursePackageStudent::getId,courseID)
+                    .eq(CoursePackageStudent::getAppUserId,appUserId)
+                    .eq(CoursePackageStudent::getStudentId,stuId));
+            if (ToolUtil.isEmpty(coursePackageStudent)){
+                ResultUtil.error("该用户未购买该课包");
+            }
+            coursePackageStudent.setReservationStatus(1);
+            coursePackageStudent.setInsertTime(simpleDateFormat.parse(time));
+            cspsService.updateById(coursePackageStudent);
+
+            return ResultUtil.success();
+        }catch (Exception e){
+            return ResultUtil.runErr();
+        }
+    }
+
 }

--
Gitblit v1.7.1