From 5592de9cf80aa78486775a72a6224973c93146da Mon Sep 17 00:00:00 2001
From: liujie <liujie>
Date: 星期二, 08 八月 2023 17:25:37 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 cloud-server-account/src/main/java/com/dsh/account/model/BillingRequest.java                                |   21 +
 cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java                     |    7 
 cloud-server-competition/src/main/java/com/dsh/competition/service/IPaymentCompetitionService.java          |    6 
 cloud-server-other/src/main/java/com/dsh/other/feignclient/SiteClient.java                                  |    3 
 cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackagePaymentController.java             |   18 +
 cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml                               |   13 +
 cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java                               |   22 -
 cloud-server-other/src/main/java/com/dsh/other/model/BillingRequestOfType.java                              |   24 ++
 cloud-server-course/src/main/java/com/dsh/course/model/BillingRequestVo.java                                |   17 +
 cloud-server-course/src/main/java/com/dsh/course/model/BillingRequest.java                                  |   21 +
 cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java                             |    5 
 cloud-server-competition/src/main/java/com/dsh/competition/mapper/PaymentCompetitionMapper.java             |   10 
 cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestVo.java                              |   16 +
 cloud-server-course/src/main/java/com/dsh/course/service/TCoursePackagePaymentService.java                  |    3 
 cloud-server-course/src/main/java/com/dsh/course/feignclient/CoursePaymentClient.java                       |    3 
 cloud-server-course/src/main/java/com/dsh/course/feignclient/model/BillingDataRequestVo.java                |    4 
 cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequestVo.java          |   16 +
 cloud-server-account/src/main/java/com/dsh/account/controller/UseBenefitsController.java                    |   10 
 cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java                    |    7 
 cloud-server-activity/src/main/java/com/dsh/activity/feignclient/MerChandiseClient.java                     |    3 
 cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml                             |   24 ++
 cloud-server-other/src/main/java/com/dsh/other/controller/StoredValueConfigController.java                  |    1 
 cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestOfType.java                          |   24 ++
 cloud-server-activity/src/main/java/com/dsh/activity/model/PointMerchandiseVo.java                          |   18 +
 cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/model/PointMerchandiseVo.java       |   17 +
 cloud-server-activity/src/main/java/com/dsh/activity/controller/PointMercharsController.java                |   12 
 cloud-server-account/src/main/java/com/dsh/account/model/vo/userBenefitDetail/GoodsExchangeVo.java          |   36 +++
 cloud-server-account/src/main/java/com/dsh/account/feignclient/course/CoursePaymentClient.java              |    4 
 cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequest.java            |   20 +
 cloud-server-account/src/main/java/com/dsh/account/feignclient/other/SiteClient.java                        |    4 
 cloud-server-other/src/main/java/com/dsh/other/feignclient/model/BillingDataRequestVo.java                  |    4 
 cloud-server-account/src/main/java/com/dsh/account/model/RequestOfTypeVo.java                               |   15 +
 cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml                                          |   13 +
 cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java                    |   88 ++++----
 cloud-server-competition/src/main/java/com/dsh/competition/feignclient/DeductionCompetitionsClient.java     |    6 
 cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackagePaymentServiceImpl.java         |    6 
 cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/MerChandiseClient.java              |    2 
 cloud-server-management/src/main/webapp/static/modular/system/tCoupon/TCouponInfo.js                        |   16 +
 cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java                                |    5 
 cloud-server-account/src/main/java/com/dsh/account/entity/UserIntegralChanges.java                          |   10 
 cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/model/BillingDataRequestVo.java  |    4 
 cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java  |   11 +
 cloud-server-account/src/main/java/com/dsh/account/service/impl/RechargeRecordsServiceImpl.java             |    2 
 cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingDataRequestVo.java      |    4 
 cloud-server-account/src/main/java/com/dsh/account/service/TAppUserService.java                             |    2 
 cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/DeductionCompetitionsClient.java |    6 
 cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java            |   39 +-
 cloud-server-other/src/main/java/com/dsh/other/model/RequestOfTypeVo.java                                   |   15 +
 48 files changed, 508 insertions(+), 129 deletions(-)

diff --git a/cloud-server-account/src/main/java/com/dsh/account/controller/UseBenefitsController.java b/cloud-server-account/src/main/java/com/dsh/account/controller/UseBenefitsController.java
index d6606e0..4b9dd2a 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/controller/UseBenefitsController.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/controller/UseBenefitsController.java
@@ -360,20 +360,14 @@
     @ApiOperation(value = "积分商城-商品兑换", tags = {"APP-使用福利"})
     @ApiImplicitParams({
             @ApiImplicitParam(name = "Authorization", value = "Bearer +token", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
-            @ApiImplicitParam(value = "商品id", name = "goodId", required = true, dataType = "int"),
-            @ApiImplicitParam(value = "商品类型 1实物 2课包 3门票 4优惠券", name = "goodsType", required = true, dataType = "int"),
-            @ApiImplicitParam(value = "兑换数量", name = "nums", required = false, dataType = "int"),
-            @ApiImplicitParam(value = "兑换方式(1=积分,2=积分+现金)", name = "exchangeType", required = true, dataType = "int"),
-            @ApiImplicitParam(value = "现金支付方式(1=微信 2=支付宝)", name = "payType", required = false, dataType = "int"),
-            @ApiImplicitParam(value = "学员id列表", name = "stuIds", required = false),
     })
-    public ResultUtil productRedemptionOperation(Integer goodId, Integer goodsType,Integer nums,Integer exchangeType,Integer payType,List<Integer> stuIds){
+    public ResultUtil productRedemptionOperation(GoodsExchangeVo exchangeType){
         try {
             Integer userIdFormRedis = tokenUtil.getUserIdFormRedis();
             if(null == userIdFormRedis){
                 return ResultUtil.tokenErr();
             }
-            return tauService.productRedemptionOperation(userIdFormRedis,goodId,goodsType,nums,exchangeType,payType,stuIds);
+            return tauService.productRedemptionOperation(userIdFormRedis,exchangeType);
         }catch (Exception e){
             return ResultUtil.runErr();
         }
diff --git a/cloud-server-account/src/main/java/com/dsh/account/entity/UserIntegralChanges.java b/cloud-server-account/src/main/java/com/dsh/account/entity/UserIntegralChanges.java
index 305748a..6e91161 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/entity/UserIntegralChanges.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/entity/UserIntegralChanges.java
@@ -32,8 +32,8 @@
     /**
      * 主键
      */
-    @TableId(value = "id", type = IdType.AUTO)
-    private Integer id;
+    @TableId(value = "id", type = IdType.NONE)
+    private Long id;
     /**
      * 用户id
      */
@@ -64,7 +64,11 @@
      */
     @TableField("insertTime")
     private Date insertTime;
-
+    /**
+     * 变动类型(1增加 2扣除)
+     */
+    @TableField("category")
+    private Integer category;
 
     @Override
     protected Serializable pkVal() {
diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/MerChandiseClient.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/MerChandiseClient.java
index b7e381a..ebc2f3f 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/MerChandiseClient.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/MerChandiseClient.java
@@ -19,7 +19,7 @@
 
 
     @PostMapping("/base/pointMerchars/getCommoditys")
-    public List<PointsMerchandise> getVicinityGoods(@RequestBody CommodityRequest request);
+    PointMerchandiseVo getVicinityGoods(@RequestBody CommodityRequest request);
 
     @PostMapping("/base/pointMerchars/getRedeemedNums")
     public int getRedeemedQuantity(@RequestBody Integer goodId);
diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/model/PointMerchandiseVo.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/model/PointMerchandiseVo.java
new file mode 100644
index 0000000..c2d3c3e
--- /dev/null
+++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/activity/model/PointMerchandiseVo.java
@@ -0,0 +1,17 @@
+package com.dsh.account.feignclient.activity.model;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class PointMerchandiseVo {
+
+
+    List<PointsMerchandise> merchandises;
+
+}
diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/DeductionCompetitionsClient.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/DeductionCompetitionsClient.java
index d9c28e7..cf89650 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/DeductionCompetitionsClient.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/DeductionCompetitionsClient.java
@@ -5,6 +5,8 @@
 import com.dsh.account.feignclient.competition.model.GetStuSourseList;
 import com.dsh.account.feignclient.competition.model.PaymentCompetition;
 import com.dsh.account.feignclient.competition.model.PurchaseRecordVo;
+import com.dsh.account.model.BillingRequest;
+import com.dsh.account.model.BillingRequestVo;
 import org.springframework.cloud.openfeign.FeignClient;
 import org.springframework.web.bind.annotation.PostMapping;
 import org.springframework.web.bind.annotation.RequestBody;
@@ -17,10 +19,10 @@
     List<PurchaseRecordVo> getStuSourseList(@RequestBody GetStuSourseList getStuSourseList);
 
     @PostMapping("/base/competition/getPayedCompetitions")
-    List<PaymentCompetition> getAllCompetitionPayRecord(@RequestBody BillingDataRequestVo requestVo);
+    BillingRequestVo getAllCompetitionPayRecord(@RequestBody BillingDataRequestVo requestVo);
 
     @PostMapping("/base/competition/getCancelOrderOfUserPay")
-    public List<PaymentCompetition> getCancelOrderOfUserPayRecord(@RequestBody BillingDataRequestVo appUserId);
+    BillingRequestVo getCancelOrderOfUserPayRecord(@RequestBody BillingDataRequestVo appUserId);
 
     @PostMapping("/base/competition/getPlayPaiFGoldPayRecord")
     List<PaymentCompetition> getPlayPaiFGoldPayRecord(@RequestBody Integer appUserId);
diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/model/BillingDataRequestVo.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/model/BillingDataRequestVo.java
index f63861f..3514fee 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/model/BillingDataRequestVo.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/competition/model/BillingDataRequestVo.java
@@ -10,10 +10,10 @@
 public class BillingDataRequestVo {
 
     @ApiModelProperty(value = "开始时间")
-    private Date monthStart = null;
+    private String monthStart = null;
 
     @ApiModelProperty(value = "结束时间时间")
-    private Date monthEnd = null;
+    private String monthEnd = null;
 
     @ApiModelProperty(value = "用户id")
     private Integer appUserId;
diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/course/CoursePaymentClient.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/course/CoursePaymentClient.java
index a0a75a8..61a8c62 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/feignclient/course/CoursePaymentClient.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/course/CoursePaymentClient.java
@@ -2,6 +2,8 @@
 
 import com.dsh.account.feignclient.competition.model.BillingDataRequestVo;
 import com.dsh.account.feignclient.course.model.*;
+import com.dsh.account.model.BillingRequest;
+import com.dsh.account.model.BillingRequestVo;
 import org.springframework.cloud.openfeign.FeignClient;
 import org.springframework.web.bind.annotation.PostMapping;
 import org.springframework.web.bind.annotation.RequestBody;
@@ -51,7 +53,7 @@
     public boolean savePaymentCoursePackage(@RequestBody TCoursePackagePayment packagePayment);
 
     @PostMapping("/base/coursePack/allAmountPayRecordOfUser")
-    public List<TCoursePackagePayment> getAmountPayRecord(@RequestBody BillingDataRequestVo appUserId);
+    BillingRequestVo getAmountPayRecord(@RequestBody BillingDataRequestVo appUserId);
 
     @PostMapping("/base/coursePack/obtainStudentClassDetails")
     List<RecordAppoint> obtainStudentClassDetailsData(@RequestBody WeeksOfCourseRest stuId);
diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/SiteClient.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/SiteClient.java
index 7f5e8ff..2a99333 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/SiteClient.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/SiteClient.java
@@ -2,6 +2,8 @@
 
 import com.dsh.account.feignclient.competition.model.BillingDataRequestVo;
 import com.dsh.account.feignclient.other.model.SiteBooking;
+import com.dsh.account.model.BillingRequestOfType;
+import com.dsh.account.model.RequestOfTypeVo;
 import com.dsh.account.model.vo.exploreDetail.SiteVo;
 import org.springframework.cloud.openfeign.FeignClient;
 import org.springframework.web.bind.annotation.PostMapping;
@@ -14,7 +16,7 @@
 public interface SiteClient {
 
     @PostMapping("/base/site/queryPaymentSiteDetail")
-    List<SiteBooking> getAllSiteBookingList(@RequestBody BillingDataRequestVo appUserId);
+    RequestOfTypeVo getAllSiteBookingList(@RequestBody BillingDataRequestVo appUserId);
 
 
     @PostMapping("/base/site/queryPlaypaiGoldSiteDetail")
diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequest.java b/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequest.java
new file mode 100644
index 0000000..53edee7
--- /dev/null
+++ b/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequest.java
@@ -0,0 +1,21 @@
+package com.dsh.account.model;
+
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequest {
+
+    /**
+     * MM-dd HH:mm
+     */
+    private String time;
+    /**
+     * 金额
+     */
+    private double amount;
+}
diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestOfType.java b/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestOfType.java
new file mode 100644
index 0000000..b09eb24
--- /dev/null
+++ b/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestOfType.java
@@ -0,0 +1,24 @@
+package com.dsh.account.model;
+
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequestOfType {
+    /**
+     *
+     */
+    private Integer status;
+    /**
+     * MM-dd HH:mm
+     */
+    private String time;
+    /**
+     * 金额
+     */
+    private double amount;
+}
diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestVo.java b/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestVo.java
new file mode 100644
index 0000000..85ac049
--- /dev/null
+++ b/cloud-server-account/src/main/java/com/dsh/account/model/BillingRequestVo.java
@@ -0,0 +1,16 @@
+package com.dsh.account.model;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequestVo {
+
+    List<BillingRequest> requests;
+
+}
diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/RequestOfTypeVo.java b/cloud-server-account/src/main/java/com/dsh/account/model/RequestOfTypeVo.java
new file mode 100644
index 0000000..7808bdd
--- /dev/null
+++ b/cloud-server-account/src/main/java/com/dsh/account/model/RequestOfTypeVo.java
@@ -0,0 +1,15 @@
+package com.dsh.account.model;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class RequestOfTypeVo {
+
+    List<BillingRequestOfType> request;
+}
diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/vo/userBenefitDetail/GoodsExchangeVo.java b/cloud-server-account/src/main/java/com/dsh/account/model/vo/userBenefitDetail/GoodsExchangeVo.java
new file mode 100644
index 0000000..7ddbb11
--- /dev/null
+++ b/cloud-server-account/src/main/java/com/dsh/account/model/vo/userBenefitDetail/GoodsExchangeVo.java
@@ -0,0 +1,36 @@
+package com.dsh.account.model.vo.userBenefitDetail;
+
+
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class GoodsExchangeVo {
+    @ApiModelProperty(value = "商品id",required = true)
+    Integer goodId;
+
+    @ApiModelProperty(value = "商品类型 1实物 2课包 3门票 4优惠券",required = true)
+    Integer goodsType;
+
+    @ApiModelProperty(value = "兑换数量",required = false)
+    Integer nums;
+
+    @ApiModelProperty(value = "兑换方式(1=积分,2=积分+现金 3=现金)",required = true)
+    Integer exchangeType;
+
+    @ApiModelProperty(value = "现金支付方式(1=微信 2=支付宝)",required = false)
+    Integer payType;
+
+    @ApiModelProperty(value = "学员id列表",required = false)
+    List<Integer> stuIds;
+
+    @ApiModelProperty(value = "门店id列表",required = false)
+    List<Integer> storeIds;
+}
diff --git a/cloud-server-account/src/main/java/com/dsh/account/service/TAppUserService.java b/cloud-server-account/src/main/java/com/dsh/account/service/TAppUserService.java
index 1b00a83..215daa3 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/service/TAppUserService.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/service/TAppUserService.java
@@ -128,7 +128,7 @@
 
     StuAndStoreResponse queryAppUserDefaultStuAndStore(Integer userIdFormRedis ,Integer pointsMerId, String lat, String lon,Integer isCourse);
 
-    ResultUtil productRedemptionOperation(Integer userIdFormRedis, Integer goodId, Integer goodsType,Integer nums,Integer exchangeType,Integer payType,List<Integer> stuIds);
+    ResultUtil productRedemptionOperation(Integer userIdFormRedis, GoodsExchangeVo exchangeVo);
 
     ResultUtil exchangeAddPaymentCallback(String code, String orderNumber,Integer payType);
 
diff --git a/cloud-server-account/src/main/java/com/dsh/account/service/impl/RechargeRecordsServiceImpl.java b/cloud-server-account/src/main/java/com/dsh/account/service/impl/RechargeRecordsServiceImpl.java
index f387614..a56044c 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/service/impl/RechargeRecordsServiceImpl.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/service/impl/RechargeRecordsServiceImpl.java
@@ -183,7 +183,7 @@
         BigDecimal amount = BigDecimal.ZERO;
         if (rechargeConfig.size() > 0){
             for (Map<String, Object> stringObjectMap : rechargeConfig) {
-                Long o = (Long) stringObjectMap.get("money");
+                double o = (double) stringObjectMap.get("money");
                 if (BigDecimal.valueOf(o).compareTo(request.getAmount()) == 0) {
                     amount = BigDecimal.valueOf(o);
                     rechargeRecords.setAmount(BigDecimal.valueOf(o));
diff --git a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java
index 275b2da..e87e6fd 100644
--- a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java
+++ b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java
@@ -26,10 +26,7 @@
 import com.dsh.account.feignclient.other.model.StoreDetailOfCourse;
 import com.dsh.account.feignclient.other.model.TImgConfig;
 import com.dsh.account.mapper.*;
-import com.dsh.account.model.AddAppUserVo;
-import com.dsh.account.model.JoinPlayPaiVo;
-import com.dsh.account.model.LoginSMSCodeVo;
-import com.dsh.account.model.LoginWeChatVo;
+import com.dsh.account.model.*;
 import com.dsh.account.model.dto.Coupon;
 import com.dsh.account.model.vo.classDetails.CourseVenue;
 import com.dsh.account.model.vo.classDetails.ExerciseVideo;
@@ -507,6 +504,7 @@
         List<ConsumeDetail> details = new ArrayList<>();
 
         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("MM-dd HH:mm");
+        SimpleDateFormat result = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
         Date monthStart = null;
         Date monthEnd = null;
         if (StringUtils.hasText(yearMonth)) {
@@ -518,59 +516,59 @@
         }
 
         BillingDataRequestVo requestVo = new BillingDataRequestVo();
-        requestVo.setMonthStart(monthStart);
-        requestVo.setMonthEnd(monthEnd);
+        requestVo.setMonthStart(result.format(monthStart));
+        requestVo.setMonthEnd(result.format(monthEnd));
         requestVo.setAppUserId(appUserId);
 //            1.赛事报名
-        List<PaymentCompetition> allCompetitionPayRecord = deducClient.getAllCompetitionPayRecord(requestVo);
-        if (allCompetitionPayRecord.size() > 0 ){
-            for (PaymentCompetition paymentCompetition : allCompetitionPayRecord) {
+        BillingRequestVo allCompetitionPayRecord = deducClient.getAllCompetitionPayRecord(requestVo);
+        if (ToolUtil.isNotEmpty(allCompetitionPayRecord.getRequests())){
+            for (BillingRequest paymentCompetition : allCompetitionPayRecord.getRequests()) {
                 ConsumeDetail consumeDetail = new ConsumeDetail();
                 consumeDetail.setConsumeName(RechargeRecordEnum.EVENT_REGISTRATION.getMsg());
-                consumeDetail.setConsumeTime(simpleDateFormat.format(paymentCompetition.getInsertTime()));
+                consumeDetail.setConsumeTime(paymentCompetition.getTime());
                 consumeDetail.setConsumeAmount("-" + paymentCompetition.getAmount());
                 details.add(consumeDetail);
                 consumeDetail.setType(1);
             }
         }
 //            2.取消赛事报名
-        List<PaymentCompetition> cancelOrderOfUserPayRecord = deducClient.getCancelOrderOfUserPayRecord(requestVo);
-        if (cancelOrderOfUserPayRecord.size() > 0 ){
-            for (PaymentCompetition paymentCompetition : cancelOrderOfUserPayRecord) {
+        BillingRequestVo cancelOrderOfUserPayRecord = deducClient.getCancelOrderOfUserPayRecord(requestVo);
+        if (ToolUtil.isNotEmpty(cancelOrderOfUserPayRecord.getRequests())){
+            for (BillingRequest paymentCompetition : cancelOrderOfUserPayRecord.getRequests()) {
                 ConsumeDetail consumeDetail = new ConsumeDetail();
                 consumeDetail.setConsumeName(RechargeRecordEnum.CANCEL_EVENT_REGISTRATION.getMsg());
-                consumeDetail.setConsumeTime(simpleDateFormat.format(paymentCompetition.getInsertTime()));
+                consumeDetail.setConsumeTime(paymentCompetition.getTime());
                 consumeDetail.setConsumeAmount("+" + paymentCompetition.getAmount());
                 consumeDetail.setType(1);
                 details.add(consumeDetail);
             }
         }
 //            3.课包购买
-        List<TCoursePackagePayment> amountPayRecord = paymentClient.getAmountPayRecord(requestVo);
-        if (amountPayRecord.size() > 0 ){
-            for (TCoursePackagePayment coursePackagePayment : amountPayRecord) {
+        BillingRequestVo amountPayRecord = paymentClient.getAmountPayRecord(requestVo);
+        if (ToolUtil.isNotEmpty(amountPayRecord.getRequests())){
+            for (BillingRequest coursePackagePayment : amountPayRecord.getRequests()) {
                 ConsumeDetail consumeDetail = new ConsumeDetail();
                 consumeDetail.setConsumeName(RechargeRecordEnum.COURSE_PACKAGE_PURCHASE.getMsg());
-                consumeDetail.setConsumeTime(simpleDateFormat.format(coursePackagePayment.getInsertTime()));
-                consumeDetail.setConsumeAmount("-" + coursePackagePayment.getCashPayment());
+                consumeDetail.setConsumeTime(coursePackagePayment.getTime());
+                consumeDetail.setConsumeAmount("-" + coursePackagePayment.getAmount());
                 consumeDetail.setType(2);
                 details.add(consumeDetail);
             }
         }
 //            4.场地预约
-        List<SiteBooking> allSiteBookingList = stClient.getAllSiteBookingList(requestVo);
-        if (allSiteBookingList.size() >  0){
-            for (SiteBooking booking : allSiteBookingList) {
+        RequestOfTypeVo allSiteBookingList = stClient.getAllSiteBookingList(requestVo);
+        if (ToolUtil.isNotEmpty(allSiteBookingList.getRequest())){
+            for (BillingRequestOfType booking : allSiteBookingList.getRequest()) {
                 ConsumeDetail consumeDetail = new ConsumeDetail();
                 if (booking.getStatus() != 5){
                     consumeDetail.setConsumeName(RechargeRecordEnum.VENUE_RESERVATION.getMsg());
-                    consumeDetail.setConsumeAmount("-" + booking.getPayMoney());
-                    consumeDetail.setConsumeTime(simpleDateFormat.format(booking.getPayTime()));
+                    consumeDetail.setConsumeAmount("-" + booking.getAmount());
+                    consumeDetail.setConsumeTime(booking.getTime());
                     consumeDetail.setType(2);
                 }else {
                     consumeDetail.setConsumeName(RechargeRecordEnum.CANCEL_VENUE_RESERVATION.getMsg());
-                    consumeDetail.setConsumeAmount("+" + booking.getPayMoney());
-                    consumeDetail.setConsumeTime(simpleDateFormat.format(booking.getCancelTime()));
+                    consumeDetail.setConsumeAmount("+" + booking.getAmount());
+                    consumeDetail.setConsumeTime(booking.getTime());
                     consumeDetail.setType(1);
                 }
                 details.add(consumeDetail);
@@ -673,9 +671,9 @@
         CommodityRequest commodityRequest = new CommodityRequest();
         commodityRequest.setLon(request.getLon());
         commodityRequest.setLat(request.getLat());
-        List<PointsMerchandise> vicinityGoods = mcClient.getVicinityGoods(commodityRequest);
-        if (vicinityGoods.size() > 0) {
-            for (PointsMerchandise vicinityGood : vicinityGoods) {
+        PointMerchandiseVo vicinityGoods = mcClient.getVicinityGoods(commodityRequest);
+        if (ToolUtil.isNotEmpty(vicinityGoods.getMerchandises())) {
+            for (PointsMerchandise vicinityGood : vicinityGoods.getMerchandises()) {
                 Goods commodity = new Goods();
                 switch (vicinityGood.getType()) {
                     case 1:
@@ -856,13 +854,15 @@
     }
 
     @Override
-    public ResultUtil productRedemptionOperation(Integer userIdFormRedis, Integer goodId, Integer goodsType,Integer nums,Integer exchangeType,Integer payType,List<Integer> stuIds) {
-        PointsMerchandise merchandise = mcClient.selectPointsMerchandiseById(goodId);
+    public ResultUtil productRedemptionOperation(Integer userIdFormRedis, GoodsExchangeVo exchangeType) {
+        System.out.println("exchangeType:--->");
+        System.out.println(exchangeType);
+        PointsMerchandise merchandise = mcClient.selectPointsMerchandiseById(exchangeType.getGoodId());
         SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");
         String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5);
-        for (int i = 0; i < nums; i++) {
+        for (int i = 0; i < exchangeType.getNums(); i++) {
             UserPointsMerchandise pointsMerchandise = new UserPointsMerchandise();
-            pointsMerchandise.setPointsMerchandiseId(goodId);
+            pointsMerchandise.setPointsMerchandiseId(exchangeType.getGoodId());
             pointsMerchandise.setUserId(userIdFormRedis);
             pointsMerchandise.setCode(code);
             mcClient.saveDetailsUserPointMercase(pointsMerchandise);
@@ -884,15 +884,15 @@
 
         this.baseMapper.updateById(tAppUser);
 //        现金支付
-        if (exchangeType == 2) {
-            switch (goodsType) {
+        if (exchangeType.getExchangeType() == 2 || exchangeType.getExchangeType() == 3) {
+            switch (exchangeType.getGoodsType()) {
                 case 2:
-                    for (int i = 0; i < stuIds.size(); i++) {
+                    for (int i = 0; i < exchangeType.getStuIds().size(); i++) {
                         List<CoursePackagePaymentConfig> courseConfigList = cpconClient.getCourseConfigList(merchandise.getCoursePackageId());
 
                         TCoursePackagePayment packagePayment = new TCoursePackagePayment();
                         packagePayment.setAppUserId(userIdFormRedis);
-                        packagePayment.setStudentId(stuIds.get(i));
+                        packagePayment.setStudentId(exchangeType.getStuIds().get(i));
                         packagePayment.setCoursePackageId(merchandise.getCoursePackageId());
                         for (CoursePackagePaymentConfig coursePackagePaymentConfig : courseConfigList) {
                             if (Objects.equals(coursePackagePaymentConfig.getId(),merchandise.getCoursePackageConfigId())){
@@ -916,9 +916,9 @@
                     }
                     break;
                 case 4:
-                    for (int i = 0; i < nums; i++) {
+                    for (int i = 0; i < exchangeType.getNums(); i++) {
                         UserCoupon coupon = new UserCoupon();
-                        coupon.setCouponId(goodId);
+                        coupon.setCouponId(exchangeType.getGoodId());
                         coupon.setUserId(userIdFormRedis);
                         coupon.setStatus(1);
                         coupon.setInsertTime(new Date());
@@ -929,22 +929,22 @@
                     break;
             }
 
-            switch (payType){
+            switch (exchangeType.getPayType()){
                 case 1:
                     try {
                         if (merchandise.getType() == 2){
-                            return WechatPayment(merchandise.getCash().multiply(new BigDecimal(stuIds.size())),code);
+                            return WechatPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getStuIds().size())),code);
                         }else {
-                            return WechatPayment(merchandise.getCash().multiply(new BigDecimal(nums)),code);
+                            return WechatPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getNums())),code);
                         }
                     }catch (Exception e){
                         return ResultUtil.runErr();
                     }
                 case 2:
                     if (merchandise.getType() == 2){
-                        AlipayPayment(merchandise.getCash().multiply(new BigDecimal(stuIds.size())),code);
+                        AlipayPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getStuIds().size())),code);
                     }else {
-                        AlipayPayment(merchandise.getCash().multiply(new BigDecimal(nums)),code);
+                        AlipayPayment(merchandise.getCash().multiply(new BigDecimal(exchangeType.getNums())),code);
                     }
                     break;
                 default:
diff --git a/cloud-server-activity/src/main/java/com/dsh/activity/controller/PointMercharsController.java b/cloud-server-activity/src/main/java/com/dsh/activity/controller/PointMercharsController.java
index b6e5926..92e4c4f 100644
--- a/cloud-server-activity/src/main/java/com/dsh/activity/controller/PointMercharsController.java
+++ b/cloud-server-activity/src/main/java/com/dsh/activity/controller/PointMercharsController.java
@@ -11,6 +11,7 @@
 import com.dsh.activity.feignclient.model.*;
 import com.dsh.activity.feignclient.other.StoreClient;
 import com.dsh.activity.feignclient.other.model.StoreDetailOfCourse;
+import com.dsh.activity.model.PointMerchandiseVo;
 import com.dsh.activity.model.request.CommodityRequest;
 import com.dsh.activity.service.*;
 import com.dsh.activity.util.GDMapGeocodingUtil;
@@ -90,13 +91,15 @@
     }
 
 
+    @ResponseBody
     @PostMapping("/base/pointMerchars/getCommoditys")
-    public List<PointsMerchandise> getVicinityGoods(@RequestBody CommodityRequest request){
+    public PointMerchandiseVo getVicinityGoods(@RequestBody CommodityRequest request){
+        PointMerchandiseVo pointMerchandiseVo = new PointMerchandiseVo();
         List<PointsMerchandise> list =  new ArrayList<>();
         String provinceCode = "";
         String cityCode = "";
         if (ToolUtil.isEmpty(request.getLon()) && ToolUtil.isEmpty(request.getLat())){
-            return list;
+            return pointMerchandiseVo;
         }
         try {
             Map<String, String> geocode = gdMapGeocodingUtil.geocode(request.getLon(), request.getLat());
@@ -116,8 +119,9 @@
                     iterator.remove(); // 移除符合条件的商品
                 }
             }
+            pointMerchandiseVo.setMerchandises(list);
         }
-        return list;
+        return pointMerchandiseVo;
     }
 
     @PostMapping("/base/pointMerchars/getRedeemedNums")
@@ -222,6 +226,7 @@
                 detailsVo.setRedeemedNum(count);
                 detailsVo.setResidueNum(merchandise.getQuantityIssued()-count);
                 detailsVo.setPerLimit(merchandise.getPickUpQuantity());
+                detailsVo.setExchangeType(merchandise.getRedemptionMethod());
                 if (merchandise.getRedemptionMethod() == 1){
                     detailsVo.setIntegral(merchandise.getIntegral());
                 }else {
@@ -271,6 +276,7 @@
                 detailsVo.setRedeemedNum(couponNums);
                 detailsVo.setResidueNum(coupon.getQuantityIssued()-couponNums);
                 detailsVo.setPerLimit(coupon.getPickUpQuantity());
+                detailsVo.setExchangeType(merchandise.getRedemptionMethod());
                 if (merchandise.getRedemptionMethod() == 1){
                     detailsVo.setIntegral(merchandise.getIntegral());
                 }else {
diff --git a/cloud-server-activity/src/main/java/com/dsh/activity/feignclient/MerChandiseClient.java b/cloud-server-activity/src/main/java/com/dsh/activity/feignclient/MerChandiseClient.java
index 2ffb151..6d4533e 100644
--- a/cloud-server-activity/src/main/java/com/dsh/activity/feignclient/MerChandiseClient.java
+++ b/cloud-server-activity/src/main/java/com/dsh/activity/feignclient/MerChandiseClient.java
@@ -17,9 +17,6 @@
     @PostMapping("/base/pointMerchars/convertGoods")
     public List<IntegralCommodity> getConvertibleGoods();
 
-    @PostMapping("/base/pointMerchars/getCommoditys")
-    public List<PointsMerchandise> getVicinityGoods(@RequestBody CommodityRequest request);
-
     @PostMapping("/base/pointMerchars/getRedeemedNums")
     public int getRedeemedQuantity(@RequestBody Integer goodId);
 
diff --git a/cloud-server-activity/src/main/java/com/dsh/activity/model/PointMerchandiseVo.java b/cloud-server-activity/src/main/java/com/dsh/activity/model/PointMerchandiseVo.java
new file mode 100644
index 0000000..4386110
--- /dev/null
+++ b/cloud-server-activity/src/main/java/com/dsh/activity/model/PointMerchandiseVo.java
@@ -0,0 +1,18 @@
+package com.dsh.activity.model;
+
+import com.dsh.activity.entity.PointsMerchandise;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class PointMerchandiseVo {
+
+
+    List<PointsMerchandise> merchandises;
+
+}
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java b/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java
index 4a2c398..e82c819 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/controller/CompetitionController.java
@@ -75,29 +75,30 @@
     private AppUserClient appUserClient;
 
 
+    @ResponseBody
     @PostMapping("/base/competition/getPayedCompetitions")
-    public List<PaymentCompetition> getAllCompetitionPayRecord(@RequestBody BillingDataRequestVo requestVo){
-        List<Integer> integers = new ArrayList<>();
-        integers.add(1);
-        integers.add(2);
-        return paymentCompetitionService.list(new QueryWrapper<PaymentCompetition>()
-                .in("payType",integers)
-                .eq("appUserId",requestVo.getAppUserId())
-                .eq("payStatus",2)
-                .between("payTime",requestVo.getMonthStart(),requestVo.getMonthEnd()));
+    public BillingRequestVo getAllCompetitionPayRecord(@RequestBody BillingDataRequestVo requestVo){
+        BillingRequestVo billingRequestVo = new BillingRequestVo();
+        List<BillingRequest> integers = new ArrayList<>();
+        integers = paymentCompetitionService.queryDatas(requestVo.getAppUserId(),requestVo.getMonthStart(),requestVo.getMonthEnd());
+        System.out.println(integers);
+        if (integers.size() > 0 ){
+            billingRequestVo.setRequests(integers);
+        }
+        return billingRequestVo;
     }
 
-
+    @ResponseBody
     @PostMapping("/base/competition/getCancelOrderOfUserPay")
-    public List<PaymentCompetition> getCancelOrderOfUserPayRecord(@RequestBody BillingDataRequestVo requestVo){
-        List<Integer> integers = new ArrayList<>();
-        integers.add(1);
-        integers.add(2);
-        return paymentCompetitionService.list(new QueryWrapper<PaymentCompetition>()
-                .in("payType",integers)
-                .eq("appUserId",requestVo.getAppUserId())
-                .eq("payStatus",3)
-                .between("refundTime",requestVo.getMonthStart(),requestVo.getMonthEnd()));
+    public BillingRequestVo getCancelOrderOfUserPayRecord(@RequestBody BillingDataRequestVo requestVo){
+        BillingRequestVo billingRequestVo = new BillingRequestVo();
+        List<BillingRequest> integers = new ArrayList<>();
+        integers = paymentCompetitionService.queryCancelDatas(requestVo.getAppUserId(),requestVo.getMonthStart(),requestVo.getMonthEnd());
+        System.out.println(integers);
+        if (integers.size() > 0 ){
+            billingRequestVo.setRequests(integers);
+        }
+        return billingRequestVo;
     }
 
 
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/DeductionCompetitionsClient.java b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/DeductionCompetitionsClient.java
index 566a010..7e58aea 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/DeductionCompetitionsClient.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/DeductionCompetitionsClient.java
@@ -3,6 +3,7 @@
 
 import com.dsh.competition.entity.PaymentCompetition;
 import com.dsh.competition.feignclient.model.BillingDataRequestVo;
+import com.dsh.competition.feignclient.model.BillingRequest;
 import com.dsh.competition.feignclient.model.GetStuSourseList;
 import com.dsh.competition.feignclient.model.PurchaseRecordVo;
 import org.springframework.cloud.openfeign.FeignClient;
@@ -17,11 +18,6 @@
     @PostMapping("/base/competition/getCompetitionsDetails")
     public List<PurchaseRecordVo> getStuSourseList(@RequestBody GetStuSourseList sourseList);
 
-    @PostMapping("/base/competition/getPayedCompetitions")
-    List<PaymentCompetition> getAllCompetitionPayRecord(@RequestBody BillingDataRequestVo requestVo);
-
-    @PostMapping("/base/competition/getCancelOrderOfUserPay")
-    public List<PaymentCompetition> getCancelOrderOfUserPayRecord(@RequestBody BillingDataRequestVo requestVo);
 
     @PostMapping("/base/competition/getPlayPaiFGoldPayRecord")
     List<PaymentCompetition> getPlayPaiFGoldPayRecord(@RequestBody Integer appUserId);
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingDataRequestVo.java b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingDataRequestVo.java
index 40c2b5c..fb574da 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingDataRequestVo.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingDataRequestVo.java
@@ -10,10 +10,10 @@
 public class BillingDataRequestVo {
 
     @ApiModelProperty(value = "开始时间")
-    private Date monthStart = null;
+    private String monthStart = null;
 
     @ApiModelProperty(value = "结束时间时间")
-    private Date monthEnd = null;
+    private String monthEnd = null;
 
     @ApiModelProperty(value = "用户id")
     private Integer appUserId;
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequest.java b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequest.java
new file mode 100644
index 0000000..fa729ec
--- /dev/null
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequest.java
@@ -0,0 +1,20 @@
+package com.dsh.competition.feignclient.model;
+
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequest {
+    /**
+     * MM-dd HH:mm
+     */
+    private String time;
+    /**
+     * 金额
+     */
+    private double amount;
+}
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequestVo.java b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequestVo.java
new file mode 100644
index 0000000..3fe5b67
--- /dev/null
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/model/BillingRequestVo.java
@@ -0,0 +1,16 @@
+package com.dsh.competition.feignclient.model;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequestVo {
+
+    List<BillingRequest> requests;
+
+}
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/mapper/PaymentCompetitionMapper.java b/cloud-server-competition/src/main/java/com/dsh/competition/mapper/PaymentCompetitionMapper.java
index 35c7a0e..bbed075 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/mapper/PaymentCompetitionMapper.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/mapper/PaymentCompetitionMapper.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dsh.competition.entity.PaymentCompetition;
+import com.dsh.competition.feignclient.model.BillingRequest;
 import com.dsh.competition.model.CompetitionListVo;
 import org.apache.ibatis.annotations.Param;
 
@@ -24,4 +25,13 @@
      */
     List<CompetitionListVo> queryMyCompetitionList(@Param("uid") Integer uid, @Param("type") Integer type,
                                                    @Param("pageSize") Integer pageSize, @Param("pageNo") Integer pageNo);
+
+    List<BillingRequest> queryDatas(@Param("appUserId") Integer appUserId,
+                                    @Param("monthStart")String monthStart,
+                                    @Param("monthEnd")String monthEnd);
+
+    List<BillingRequest> queryCancelDatas(@Param("appUserId") Integer appUserId,
+                                          @Param("monthStart")String monthStart,
+                                          @Param("monthEnd")String monthEnd);
+
 }
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/service/IPaymentCompetitionService.java b/cloud-server-competition/src/main/java/com/dsh/competition/service/IPaymentCompetitionService.java
index ee07f46..b10b08c 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/service/IPaymentCompetitionService.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/service/IPaymentCompetitionService.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.dsh.competition.entity.PaymentCompetition;
+import com.dsh.competition.feignclient.model.BillingRequest;
 import com.dsh.competition.model.CompetitionInfo;
 import com.dsh.competition.model.CompetitionListVo;
 import com.dsh.competition.util.ResultUtil;
@@ -43,4 +44,9 @@
      * @throws Exception
      */
     ResultUtil cancelMyCompetition(Long id) throws Exception;
+
+    List<BillingRequest> queryDatas(Integer appUserId, String monthStart, String monthEnd);
+
+    List<BillingRequest> queryCancelDatas(Integer appUserId, String monthStart, String monthEnd);
+
 }
diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java
index 7a8211f..fbde07c 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java
@@ -12,6 +12,7 @@
 import com.dsh.competition.feignclient.account.model.Student;
 import com.dsh.competition.feignclient.course.CoursePackagePaymentClient;
 import com.dsh.competition.feignclient.course.model.PaymentDeductionClassHour;
+import com.dsh.competition.feignclient.model.BillingRequest;
 import com.dsh.competition.feignclient.other.StoreClient;
 import com.dsh.competition.feignclient.other.model.Store;
 import com.dsh.competition.mapper.PaymentCompetitionMapper;
@@ -232,4 +233,14 @@
         }
         return ResultUtil.success();
     }
+
+    @Override
+    public List<BillingRequest> queryDatas(Integer appUserId, String monthStart, String monthEnd) {
+        return this.baseMapper.queryDatas(appUserId,monthStart,monthEnd);
+    }
+
+    @Override
+    public List<BillingRequest> queryCancelDatas(Integer appUserId, String monthStart, String monthEnd) {
+        return this.baseMapper.queryCancelDatas(appUserId,monthStart,monthEnd);
+    }
 }
diff --git a/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml b/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml
index 77d15a2..5084701 100644
--- a/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml
+++ b/cloud-server-competition/src/main/resources/mapper/PaymentCompetitionMapper.xml
@@ -33,4 +33,28 @@
         </if>
         order by a.insertTime desc limit #{pageNo}, #{pageSize}
     </select>
+    <select id="queryDatas" resultType="com.dsh.competition.feignclient.model.BillingRequest">
+        SELECT DATE_FORMAT(insertTime, '%m-%d %H:%i')as `time`,
+        amount
+        from t_payment_competition
+        where  payStatus = 2 and payType = 1 and payType = 2
+        <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd">
+            and DATE_FORMAT(payTime, '%Y-%m-%d %H:%i:%s') between #{monthStart} and #{monthEnd}
+        </if>
+        <if test="null != appUserId and '' != appUserId ">
+            and appUserId = #{appUserId}
+        </if>
+    </select>
+    <select id="queryCancelDatas" resultType="com.dsh.competition.feignclient.model.BillingRequest">
+        SELECT DATE_FORMAT(insertTime, '%m-%d %H:%i')as `time`,
+        amount
+        from t_payment_competition
+        where  payStatus = 3 and payType = 1 and payType = 2
+        <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd">
+            and DATE_FORMAT(refundTime, '%Y-%m-%d %H:%i:%s') between #{monthStart} and #{monthEnd}
+        </if>
+        <if test="null != appUserId and '' != appUserId ">
+            and appUserId = #{appUserId}
+        </if>
+    </select>
 </mapper>
\ No newline at end of file
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 8470385..498e942 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
@@ -12,6 +12,8 @@
 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.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;
@@ -383,14 +385,16 @@
         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;
     }
 
 
diff --git a/cloud-server-course/src/main/java/com/dsh/course/feignclient/CoursePaymentClient.java b/cloud-server-course/src/main/java/com/dsh/course/feignclient/CoursePaymentClient.java
index a8aeaae..5d8cbb7 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/feignclient/CoursePaymentClient.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/feignclient/CoursePaymentClient.java
@@ -55,9 +55,6 @@
     @PostMapping("/base/coursePack/savePaymentCoursePackage")
     public boolean savePaymentCoursePackage(@RequestBody TCoursePackagePayment packagePayment);
 
-    @PostMapping("/base/coursePack/allAmountPayRecordOfUser")
-    public List<TCoursePackagePayment> getAmountPayRecord(@RequestBody BillingDataRequestVo appUserId);
-
     @PostMapping("/base/coursePack/obtainStudentClassDetails")
     List<RecordAppoint> obtainStudentClassDetailsData(@RequestBody Integer stuId);
 
diff --git a/cloud-server-course/src/main/java/com/dsh/course/feignclient/model/BillingDataRequestVo.java b/cloud-server-course/src/main/java/com/dsh/course/feignclient/model/BillingDataRequestVo.java
index c58c74e..e4f3802 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/feignclient/model/BillingDataRequestVo.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/feignclient/model/BillingDataRequestVo.java
@@ -10,10 +10,10 @@
 public class BillingDataRequestVo {
 
     @ApiModelProperty(value = "开始时间")
-    private Date monthStart = null;
+    private String monthStart = null;
 
     @ApiModelProperty(value = "结束时间时间")
-    private Date monthEnd = null;
+    private String monthEnd = null;
 
     @ApiModelProperty(value = "用户id")
     private Integer appUserId;
diff --git a/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java b/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java
index ad694c5..51ea004 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java
@@ -2,7 +2,10 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dsh.course.entity.TCoursePackagePayment;
+import com.dsh.course.model.BillingRequest;
 import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
 
 /**
  * <p>
@@ -25,4 +28,8 @@
 
     TCoursePackagePayment getCoursePackagePaymentByCode(@Param("code") String code);
 
+    List<BillingRequest> billingDataRequestVo(@Param("appUserId")Integer appUserId,
+                                              @Param("monthStart")String monthStart,
+                                              @Param("monthEnd")String monthEnd);
+
 }
diff --git a/cloud-server-course/src/main/java/com/dsh/course/model/BillingRequest.java b/cloud-server-course/src/main/java/com/dsh/course/model/BillingRequest.java
new file mode 100644
index 0000000..bf66e7e
--- /dev/null
+++ b/cloud-server-course/src/main/java/com/dsh/course/model/BillingRequest.java
@@ -0,0 +1,21 @@
+package com.dsh.course.model;
+
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequest {
+
+    /**
+     * MM-dd HH:mm
+     */
+    private String time;
+    /**
+     * 金额
+     */
+    private double amount;
+}
diff --git a/cloud-server-course/src/main/java/com/dsh/course/model/BillingRequestVo.java b/cloud-server-course/src/main/java/com/dsh/course/model/BillingRequestVo.java
new file mode 100644
index 0000000..f2ebf86
--- /dev/null
+++ b/cloud-server-course/src/main/java/com/dsh/course/model/BillingRequestVo.java
@@ -0,0 +1,17 @@
+package com.dsh.course.model;
+
+import com.dsh.course.model.BillingRequest;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequestVo {
+
+    List<BillingRequest> requests;
+
+}
diff --git a/cloud-server-course/src/main/java/com/dsh/course/service/TCoursePackagePaymentService.java b/cloud-server-course/src/main/java/com/dsh/course/service/TCoursePackagePaymentService.java
index 13ebdf2..f08e76e 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/service/TCoursePackagePaymentService.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/service/TCoursePackagePaymentService.java
@@ -3,6 +3,7 @@
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.dsh.course.entity.TCoursePackagePayment;
 import com.dsh.course.feignclient.model.RecordAppoint;
+import com.dsh.course.model.BillingRequest;
 import com.dsh.course.model.vo.RegisterCourseVo;
 import com.dsh.course.model.vo.request.ClasspaymentRequest;
 import com.dsh.course.model.vo.request.CourseOfAfterRequest;
@@ -88,4 +89,6 @@
 
     ResultUtil insertVipPaymentCallback(String code, String orderNumber);
 
+    List<BillingRequest> queryAmountDatas(Integer appUserId, String monthStart, String monthEnd);
+
 }
diff --git a/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackagePaymentServiceImpl.java b/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackagePaymentServiceImpl.java
index 6e19834..a8eb953 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackagePaymentServiceImpl.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackagePaymentServiceImpl.java
@@ -19,6 +19,7 @@
 import com.dsh.course.feignclient.other.StoreClient;
 import com.dsh.course.feignclient.other.model.Store;
 import com.dsh.course.mapper.*;
+import com.dsh.course.model.BillingRequest;
 import com.dsh.course.model.dto.DiscountJsonDto;
 import com.dsh.course.model.vo.RegisterCourseVo;
 import com.dsh.course.model.vo.request.ClasspaymentRequest;
@@ -632,5 +633,10 @@
         return ResultUtil.success();
     }
 
+    @Override
+    public List<BillingRequest> queryAmountDatas(Integer appUserId, String monthStart, String monthEnd) {
+        return this.baseMapper.billingDataRequestVo(appUserId,monthStart,monthEnd);
+    }
+
 
 }
diff --git a/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml b/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml
index 6df7fb4..8a19f50 100644
--- a/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml
+++ b/cloud-server-course/src/main/resources/mapper/TCoursePackagePaymentMapper.xml
@@ -42,4 +42,17 @@
         and `code` = #{code}
     </if>
     </select>
+
+    <select id="billingDataRequestVo" resultType="com.dsh.course.model.BillingRequest">
+        SELECT DATE_FORMAT(payTime, '%m-%d %H:%i')as `time`,
+        amount
+        from t_course_package_payment
+        where  payStatus = 2 and state = 1 and payType = 3
+        <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd">
+            and DATE_FORMAT(insertTime, '%Y-%m-%d %H:%i:%s') between #{monthStart} and #{monthEnd}
+        </if>
+        <if test="null != appUserId and '' != appUserId ">
+            and appUserId = #{appUserId}
+        </if>
+    </select>
 </mapper>
diff --git a/cloud-server-management/src/main/webapp/static/modular/system/tCoupon/TCouponInfo.js b/cloud-server-management/src/main/webapp/static/modular/system/tCoupon/TCouponInfo.js
index 8ca29c6..687001d 100644
--- a/cloud-server-management/src/main/webapp/static/modular/system/tCoupon/TCouponInfo.js
+++ b/cloud-server-management/src/main/webapp/static/modular/system/tCoupon/TCouponInfo.js
@@ -237,16 +237,13 @@
     //获取所有的值
     var subArr= this.storeIds;
     $(".timeClass").each(function () {
-        subArr.push({
-            id:$(this).find("input[name*='id']").val(),
-        })
+        subArr.push($(this).find("input[name*='id']").val());
     });
-    console.log(subArr);
     var str = '';
     for(var i in arrays){
         var b = true;
         for(var j in subArr){
-            if(arr[i].id == subArr[j]){
+            if(arrays[i].id === Number(subArr[j])){
                 b = false;
                 break
             }
@@ -259,10 +256,19 @@
         }
     }
     $("#coun").append(str);
+    console.log('storeIds',this.storeIds)
 }
 
 function deleteSub(e) {
+    console.log(e);
+    var row = $(e).closest('tr');
+    var idValue = row.find('#id').val();
+    var index = this.storeIds.indexOf(idValue.toString());
+    if (index !== -1) {
+        this.storeIds.splice(index, 1);
+    }
     $(e).parent().parent().remove();
+    console.log('storeIds',this.storeIds)
 }
 
 
diff --git a/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java b/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java
index b0f032d..f05c175 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java
@@ -363,19 +363,15 @@
      * @param requestVo
      * @return
      */
+    @ResponseBody
     @PostMapping("/base/site/queryPaymentSiteDetail")
-    public List<SiteBooking> getAllSiteBookingList(@RequestBody BillingDataRequestVo requestVo){
-        ArrayList<Integer> integers = new ArrayList<>();
-        integers.add(1);
-        integers.add(2);
-        integers.add(3);
-        integers.add(4);
-        integers.add(5);
-        return siteBookingService.list(new QueryWrapper<SiteBooking>()
-                .in("status",integers)
-                .ne("payType",3)
-                .eq("appUserId",requestVo.getAppUserId())
-                .between("payTime",requestVo.getMonthStart(),requestVo.getMonthEnd()));
+    public RequestOfTypeVo getAllSiteBookingList(@RequestBody BillingDataRequestVo requestVo){
+        RequestOfTypeVo typeVo = new RequestOfTypeVo();
+        List<BillingRequestOfType> billingRequestOfTypes = siteBookingService.queryDatas(requestVo.getAppUserId(), requestVo.getMonthStart(), requestVo.getMonthEnd());
+        if (billingRequestOfTypes.size() > 0 ){
+            typeVo.setRequest(billingRequestOfTypes);
+        }
+        return typeVo;
     }
 
     /**
@@ -383,6 +379,7 @@
      * @param appUserId
      * @return
      */
+    @ResponseBody
     @PostMapping("/base/site/queryPlaypaiGoldSiteDetail")
     public List<SiteBooking> wanpaiGoldSiteBookingList(@RequestBody Integer appUserId){
         ArrayList<Integer> integers = new ArrayList<>();
@@ -398,6 +395,7 @@
     }
 
 
+    @ResponseBody
     @PostMapping("/base/site/getNewAddSiteList")
     public List<SiteVo> getAppUserSiteList(){
         List<SiteVo> siteVos = new ArrayList<>();
diff --git a/cloud-server-other/src/main/java/com/dsh/other/controller/StoredValueConfigController.java b/cloud-server-other/src/main/java/com/dsh/other/controller/StoredValueConfigController.java
index 3ac028f..b232622 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/controller/StoredValueConfigController.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/controller/StoredValueConfigController.java
@@ -34,7 +34,6 @@
     private StoredValueConfigService svconfigService;
 
     @ResponseBody
-
     @PostMapping("/base/stored/getRechargeArrange")
     public List<Map<String,Object>> getRechargeConfig(){
         List<Map<String,Object>> responses = new ArrayList<>();
diff --git a/cloud-server-other/src/main/java/com/dsh/other/feignclient/SiteClient.java b/cloud-server-other/src/main/java/com/dsh/other/feignclient/SiteClient.java
index e71c1a3..95020b1 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/feignclient/SiteClient.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/feignclient/SiteClient.java
@@ -3,6 +3,7 @@
 import com.dsh.other.entity.SiteBooking;
 import com.dsh.other.feignclient.model.BillingDataRequestVo;
 import com.dsh.other.feignclient.model.SiteVo;
+import com.dsh.other.model.BillingRequestOfType;
 import org.springframework.cloud.openfeign.FeignClient;
 import org.springframework.web.bind.annotation.PostMapping;
 import org.springframework.web.bind.annotation.RequestBody;
@@ -14,7 +15,7 @@
 public interface SiteClient {
 
     @PostMapping("/base/site/queryPaymentSiteDetail")
-    List<SiteBooking> getAllSiteBookingList(@RequestBody BillingDataRequestVo requestVo);
+    List<BillingRequestOfType> getAllSiteBookingList(@RequestBody BillingDataRequestVo requestVo);
 
     @PostMapping("/base/site/queryPlaypaiGoldSiteDetail")
     List<SiteBooking> wanpaiGoldSiteBookingList(@RequestBody Integer appUserId);
diff --git a/cloud-server-other/src/main/java/com/dsh/other/feignclient/model/BillingDataRequestVo.java b/cloud-server-other/src/main/java/com/dsh/other/feignclient/model/BillingDataRequestVo.java
index 9e324e4..3553d19 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/feignclient/model/BillingDataRequestVo.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/feignclient/model/BillingDataRequestVo.java
@@ -10,10 +10,10 @@
 public class BillingDataRequestVo {
 
     @ApiModelProperty(value = "开始时间")
-    private Date monthStart = null;
+    private String monthStart = null;
 
     @ApiModelProperty(value = "结束时间时间")
-    private Date monthEnd = null;
+    private String monthEnd = null;
 
     @ApiModelProperty(value = "用户id")
     private Integer appUserId;
diff --git a/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java
index 2f59a66..72a48c6 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java
@@ -2,10 +2,15 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dsh.other.entity.SiteBooking;
+import com.dsh.other.model.BillingRequestOfType;
+
+import java.util.List;
 
 /**
  * @author zhibing.pu
  * @date 2023/7/13 16:48
  */
 public interface SiteBookingMapper extends BaseMapper<SiteBooking> {
+    List<BillingRequestOfType> queryDatas(Integer appUserId, String monthStart, String monthEnd);
+
 }
diff --git a/cloud-server-other/src/main/java/com/dsh/other/model/BillingRequestOfType.java b/cloud-server-other/src/main/java/com/dsh/other/model/BillingRequestOfType.java
new file mode 100644
index 0000000..371aab1
--- /dev/null
+++ b/cloud-server-other/src/main/java/com/dsh/other/model/BillingRequestOfType.java
@@ -0,0 +1,24 @@
+package com.dsh.other.model;
+
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class BillingRequestOfType {
+    /**
+     *
+     */
+    private Integer status;
+    /**
+     * MM-dd HH:mm
+     */
+    private String time;
+    /**
+     * 金额
+     */
+    private double amount;
+}
diff --git a/cloud-server-other/src/main/java/com/dsh/other/model/RequestOfTypeVo.java b/cloud-server-other/src/main/java/com/dsh/other/model/RequestOfTypeVo.java
new file mode 100644
index 0000000..409cce5
--- /dev/null
+++ b/cloud-server-other/src/main/java/com/dsh/other/model/RequestOfTypeVo.java
@@ -0,0 +1,15 @@
+package com.dsh.other.model;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.util.List;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class RequestOfTypeVo {
+
+    List<BillingRequestOfType> request;
+}
diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java b/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java
index 06e5ccf..04e54e6 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java
@@ -2,10 +2,15 @@
 
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.dsh.other.entity.SiteBooking;
+import com.dsh.other.model.BillingRequestOfType;
+
+import java.util.List;
 
 /**
  * @author zhibing.pu
  * @date 2023/7/13 16:49
  */
 public interface ISiteBookingService extends IService<SiteBooking> {
+    List<BillingRequestOfType> queryDatas(Integer appUserId, String monthStart, String monthEnd);
+
 }
diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java
index 89dd15a..f3f4788 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java
@@ -3,8 +3,11 @@
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.dsh.other.entity.SiteBooking;
 import com.dsh.other.mapper.SiteBookingMapper;
+import com.dsh.other.model.BillingRequestOfType;
 import com.dsh.other.service.ISiteBookingService;
 import org.springframework.stereotype.Service;
+
+import java.util.List;
 
 /**
  * @author zhibing.pu
@@ -12,4 +15,8 @@
  */
 @Service
 public class SiteBookingServiceImpl extends ServiceImpl<SiteBookingMapper, SiteBooking> implements ISiteBookingService {
+    @Override
+    public List<BillingRequestOfType> queryDatas(Integer appUserId, String monthStart, String monthEnd) {
+        return this.baseMapper.queryDatas(appUserId,monthStart,monthEnd);
+    }
 }
diff --git a/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml b/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml
index 5a70fc4..6244d3e 100644
--- a/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml
+++ b/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml
@@ -3,4 +3,17 @@
 <mapper namespace="com.dsh.other.mapper.SiteBookingMapper">
 
 
+    <select id="queryDatas" resultType="com.dsh.other.model.BillingRequestOfType">
+        SELECT DATE_FORMAT(insertTime, '%m-%d %H:%i')as `time`,
+        payMoney as amount,
+        `status`
+        from t_site_booking
+        where  payType != 3 and status != 0
+        <if test="null != monthStart and '' != monthStart and null != monthEnd and '' != monthEnd">
+            and DATE_FORMAT(payTime, '%Y-%m-%d %H:%i:%s') between #{monthStart} and #{monthEnd}
+        </if>
+        <if test="null != appUserId and '' != appUserId ">
+            and appUserId = #{appUserId}
+        </if>
+    </select>
 </mapper>

--
Gitblit v1.7.1