From 35d72e26dc2b3159021636dc1e540da0a8735b4e Mon Sep 17 00:00:00 2001
From: liujie <liujie>
Date: 星期日, 08 十月 2023 15:48:53 +0800
Subject: [PATCH] update后台

---
 cloud-server-activity/src/main/java/com/dsh/activity/controller/PointMercharsController.java |   75 +++++++++++++++++++++++++++++++++++--
 1 files changed, 71 insertions(+), 4 deletions(-)

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 830286d..f85e7b7 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
@@ -15,6 +15,7 @@
 import com.dsh.activity.model.CoachChangeStateVO;
 import com.dsh.activity.model.PointMerchandiseIncomeVo;
 import com.dsh.activity.model.PointMerchandiseVo;
+import com.dsh.activity.model.QueryDataFee;
 import com.dsh.activity.model.request.*;
 import com.dsh.activity.model.response.GoodsInfoOneVo;
 import com.dsh.activity.model.response.StoreVos;
@@ -75,6 +76,11 @@
 
     @Resource
     private CouponCityService ccityService;
+
+
+    @Resource
+    private PointsMerchandiseCityService pmdsCityService;
+
     @Autowired
     private UserPointsMerchandiseService userPointsMerchandiseService;
 
@@ -147,9 +153,6 @@
     public List<PointMerchandiseIncomeVo> getAmount(){
         return  userPointsMerchandiseService.getAmount();
     }
-
-    @Resource
-    private PointsMerchandiseCityService pmdsCityService;
 
 
     @ResponseBody
@@ -623,7 +626,6 @@
 
 
 
-
     public int dealTimeStatus(String startTime, String endTime){
         LocalDate now = LocalDate.now();
         LocalDate start = LocalDate.parse(startTime);
@@ -1016,4 +1018,69 @@
 
     }
 
+
+    @PostMapping("/base/pointMerchars/queryFee")
+    @ResponseBody
+    public HashMap<String, Object> queryFee(@RequestBody QueryDataFee queryDataFee){
+        HashMap<String, Object> map = new HashMap<>();
+        String data = queryDataFee.getData();
+        List<Integer> ids = queryDataFee.getIds();
+        if(ids.size()==0){
+            ids.add(-1);
+        }
+        List<PointsMerchandise> list1 = pmdsService.list(new LambdaQueryWrapper<PointsMerchandise>().eq(PointsMerchandise::getRedemptionMethod, 3));
+        LambdaQueryWrapper<UserPointsMerchandise> vipPaymentLambdaQueryWrapper = new LambdaQueryWrapper<>();
+        if(ToolUtil.isNotEmpty(data)){
+            String stime = data.split(" - ")[0]+" 00:00:00";
+            String etime = data.split(" - ")[1]+" 23:59:59";
+            vipPaymentLambdaQueryWrapper.between(UserPointsMerchandise::getInsertTime,stime,etime);
+        }
+        vipPaymentLambdaQueryWrapper.in(UserPointsMerchandise::getUserId,ids);
+        List<Integer> collect = list1.stream().map(PointsMerchandise::getId).collect(Collectors.toList());
+        if(collect.size()==0){
+            collect.add(-1);
+        }
+        vipPaymentLambdaQueryWrapper.in(UserPointsMerchandise::getPointsMerchandiseId,collect);
+        vipPaymentLambdaQueryWrapper.eq(UserPointsMerchandise::getPayStatus,2);
+        ArrayList<Integer> objects = new ArrayList<>();
+        List<UserPointsMerchandise> list = upmseService.list(vipPaymentLambdaQueryWrapper);
+
+        double a =0;
+        double d =0;
+        double m =0;
+        double j =0;
+        double y =0;
+        for (UserPointsMerchandise userPointsMerchandise : list) {
+            for (PointsMerchandise pointsMerchandise : list1) {
+                if(pointsMerchandise.getId()==userPointsMerchandise.getPointsMerchandiseId()){
+                    a += pointsMerchandise.getCash().doubleValue();
+                }
+                if(pointsMerchandise.getType()==3){
+                    if(pointsMerchandise.getCardType()==1){
+                        d += pointsMerchandise.getCash().doubleValue();
+                    }
+                    if(pointsMerchandise.getCardType()==2){
+                        m += pointsMerchandise.getCash().doubleValue();
+                    }
+                    if(pointsMerchandise.getCardType()==3){
+                        j += pointsMerchandise.getCash().doubleValue();
+                    }
+                    if(pointsMerchandise.getCardType()==4){
+                        y += pointsMerchandise.getCash().doubleValue();
+                    }
+                }
+            }
+
+        }
+
+        map.put("all",a);
+        map.put("day",d);
+        map.put("month",m);
+        map.put("quarter",j);
+        map.put("year",y);
+        return map;
+
+
+    }
+
 }

--
Gitblit v1.7.1