From dfb7c31b6591f9bb53182b3023f0be1d496a7d1a Mon Sep 17 00:00:00 2001
From: lisy <linlangsur163@163.com>
Date: 星期一, 14 八月 2023 13:54:32 +0800
Subject: [PATCH] 管理后台:添加优惠券和积分商品的优化

---
 cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java |  103 +++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 87 insertions(+), 16 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 fc65518..a5bbd2e 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
@@ -3,6 +3,7 @@
 
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.dsh.course.entity.*;
 import com.dsh.course.feignclient.account.AppUserClient;
 import com.dsh.course.feignclient.account.StudentClient;
@@ -12,6 +13,10 @@
 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.QueryRegistrationRecord;
+import com.dsh.course.model.QueryWalkInStudentList;
+import com.dsh.course.model.BillingRequest;
+import com.dsh.course.model.BillingRequestVo;
 import com.dsh.course.model.dto.DiscountJsonDto;
 import com.dsh.course.model.vo.CourseDetailRequest;
 import com.dsh.course.model.vo.RegisterCourseVo;
@@ -363,22 +368,36 @@
     }
 
     @PostMapping("/base/coursePack/allPaymentCourseList")
-    public List<TCoursePackagePayment> getAppuserCourseList(@RequestBody Integer appUserId){
-        return packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
-                .eq("appUserId",appUserId)
-                .eq("payType",3)
-                .eq("payStatus",2)
-                .eq("state",1));
+    @ResponseBody
+    public List<CouponPaymentVo> getAppuserCourseList(@RequestBody Integer appUserId){
+        List<CouponPaymentVo> paymentVos = new ArrayList<>();
+        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("MM-dd HH:mm");
+        List<TCoursePackagePayment> list = packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
+                .eq("appUserId", appUserId)
+                .eq("payType", 3)
+                .eq("payStatus", 2)
+                .eq("state", 1));
+        if (list.size() > 0 ){
+            for (TCoursePackagePayment tCoursePackagePayment : list) {
+                CouponPaymentVo couponPaymentVo = new CouponPaymentVo();
+                couponPaymentVo.setTime(simpleDateFormat.format(tCoursePackagePayment.getInsertTime()));
+                couponPaymentVo.setAmount( tCoursePackagePayment.getPlayPaiCoin());
+                paymentVos.add(couponPaymentVo);
+            }
+        }
+        return paymentVos;
     }
 
+
+    @ResponseBody
     @PostMapping("/base/coursePack/allAmountPayRecordOfUser")
-    public List<TCoursePackagePayment> getAmountPayRecord(@RequestBody BillingDataRequestVo billingDataRequestVo){
-        return packagePaymentService.list(new QueryWrapper<TCoursePackagePayment>()
-                .eq("appUserId",billingDataRequestVo.getAppUserId())
-                .notIn("payType",3)
-                .eq("payStatus",2)
-                .eq("state",1)
-                .between("insertTime",billingDataRequestVo.getMonthStart(),billingDataRequestVo.getMonthEnd()));
+    public BillingRequestVo getAmountPayRecord(@RequestBody BillingDataRequestVo billingDataRequestVo){
+        BillingRequestVo requestVo = new BillingRequestVo();
+        List<BillingRequest> billingRequests = packagePaymentService.queryAmountDatas(billingDataRequestVo.getAppUserId(), billingDataRequestVo.getMonthStart(), billingDataRequestVo.getMonthEnd());
+        if (billingRequests.size() >0){
+            requestVo.setRequests(billingRequests);
+        }
+        return requestVo;
     }
 
 
@@ -775,6 +794,7 @@
 
     @PostMapping("/base/coursePack/savePaymentCoursePackage")
     public boolean savePaymentCoursePackage(@RequestBody TCoursePackagePayment packagePayment){
+        packagePayment.setInsertTime(new Date());
         return packagePaymentService.save(packagePayment);
     }
 
@@ -805,6 +825,56 @@
     }
 
 
+    /**
+     * 获取课包报名信息列表
+     * @param queryRegistrationRecord
+     * @return
+     */
+    @ResponseBody
+    @PostMapping("/coursePackagePayment/queryRegistrationRecord")
+    public Page<Map<String, Object>> queryRegistrationRecord(@RequestBody QueryRegistrationRecord queryRegistrationRecord){
+        Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage(queryRegistrationRecord.getLimit(), queryRegistrationRecord.getOffset(), queryRegistrationRecord.getSort(), queryRegistrationRecord.getOrder());
+        Page<Map<String, Object>> mapPage = page.setRecords(packagePaymentService.queryRegistrationRecord(page, queryRegistrationRecord));
+        return mapPage;
+    }
+
+
+    /**
+     * 获取未预约排课学员列表
+     * @param queryWalkInStudentList
+     * @return
+     */
+    @ResponseBody
+    @PostMapping("/coursePackagePayment/queryWalkInStudentList")
+    public Page<Map<String, Object>> queryWalkInStudentList(@RequestBody QueryWalkInStudentList queryWalkInStudentList){
+        Page<Map<String, Object>> page = new PageFactory<Map<String, Object>>().defaultPage(queryWalkInStudentList.getLimit(), queryWalkInStudentList.getOffset(), queryWalkInStudentList.getSort(), queryWalkInStudentList.getOrder());
+        Page<Map<String, Object>> mapPage = page.setRecords(packagePaymentService.queryWalkInStudentList(page, queryWalkInStudentList));
+        return mapPage;
+    }
+
+
+    /**
+     * 根据id获取数据
+     * @param id
+     * @return
+     */
+    @ResponseBody
+    @PostMapping("/coursePackagePayment/queryCoursePackagePaymentById")
+    public TCoursePackagePayment queryCoursePackagePaymentById(@RequestBody Long id){
+        return packagePaymentService.getById(id);
+    }
+
+
+    /**
+     * 修改数据
+     * @param coursePackagePayment
+     */
+    @ResponseBody
+    @PostMapping("/coursePackagePayment/editCoursePackagePayment")
+    public void editCoursePackagePayment(TCoursePackagePayment coursePackagePayment){
+        packagePaymentService.updateById(coursePackagePayment);
+    }
+
 
     /**
      * 上课主页-预约操作
@@ -816,7 +886,7 @@
             @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
             @ApiImplicitParam(value = "课包id", name = "courseID", required = true, dataType = "String"),
             @ApiImplicitParam(value = "时间 yyyy-MM-dd", name = "time", required = true, dataType = "String"),
-            @ApiImplicitParam(value = "学员id", name = "time", required = true, dataType = "int"),
+            @ApiImplicitParam(value = "学员id", name = "stuId", required = true, dataType = "int"),
     })
     public ResultUtil reverse(String courseID,String time,Integer stuId){
         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
@@ -826,13 +896,13 @@
                 return ResultUtil.tokenErr();
             }
             TCoursePackagePayment packagePayment = packagePaymentService.getOne(new LambdaQueryWrapper<TCoursePackagePayment>()
-                    .eq(TCoursePackagePayment::getId,courseID )
+                    .eq(TCoursePackagePayment::getCoursePackageId,courseID )
                     .eq(TCoursePackagePayment::getAppUserId,appUserId)
                     .eq(TCoursePackagePayment::getStudentId,stuId)
             );
 
             if (ToolUtil.isEmpty(packagePayment)){
-                ResultUtil.error("该用户未购买该课包");
+                return ResultUtil.error("该用户未购买该课包");
             }
             CoursePackageStudent coursePackageStudent = cspsService.getOne(new LambdaQueryWrapper<CoursePackageStudent>()
                     .eq(CoursePackageStudent::getCoursePackageId,packagePayment.getCoursePackageId())
@@ -846,6 +916,7 @@
                 coursePackageStudent.setInsertTime(simpleDateFormat.parse(time));
                 cspsService.updateById(coursePackageStudent);
             }else {
+                coursePackageStudent = new CoursePackageStudent();
                 coursePackageStudent.setAppUserId(appUserId);
                 coursePackageStudent.setStudentId(stuId);
                 coursePackageStudent.setCoursePackageId(packagePayment.getCoursePackageId());

--
Gitblit v1.7.1