From 7e312fda9048ef171ff146acf6c8c679d123d357 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期五, 04 八月 2023 15:17:48 +0800
Subject: [PATCH] 后台代码

---
 cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java |  212 +++++++++++++++++++++++++++++++++++++---------------
 1 files changed, 151 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..25393f0 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
@@ -4,8 +4,12 @@
 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 +32,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 +73,8 @@
     @Autowired
     private TCourseService tcService;
 
-
+    @Resource
+    private StudentClient studentClient;
 
     @Autowired
     private TCoursePackageTypeService coursePackageTypeService;
@@ -75,7 +86,12 @@
     private CancelledClassesService cancelledClassesService;
 
     @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 +100,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 +118,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 +130,52 @@
      *
      * 获取发布的 课包列表
      */
+    @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) {
+                    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(tCoursePackage.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 +207,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 +281,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 +358,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 +389,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 +402,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 +414,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 +434,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 +529,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 +563,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 +721,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 +736,7 @@
             packagePaymentService.updateById(packagePayment);
 
             appUser.setPlayPaiCoins(appUser.getPlayPaiCoins()-paymentConfig.getPlayPaiCoin());
-            appuClient.updateAppUser(appUser);
+            auClitn.updateAppUser(appUser);
         } catch (Exception e) {
             return 4;
         }
@@ -683,10 +766,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 +782,12 @@
                 .eq("coursePackageId",coursePackageId));
     }
 
+
+
+    @PostMapping("/base/coursePack/getCoursePackagePaymentOfCode")
+    public List<TCoursePackagePayment> getCoursePackagePaymentOfCode(@RequestBody String code){
+        return packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
+                .eq("code",code));
+    }
+
 }

--
Gitblit v1.7.1