From 7808456a1e50af2dbd67488278eac85a558bd8f9 Mon Sep 17 00:00:00 2001
From: 44323 <443237572@qq.com>
Date: 星期日, 08 十月 2023 17:05:36 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/PlayPai

---
 cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java |   71 +++++++++++++++++++++++++++++++++--
 1 files changed, 67 insertions(+), 4 deletions(-)

diff --git a/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java b/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java
index 337f37d..fa41b2b 100644
--- a/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java
+++ b/cloud-server-course/src/main/java/com/dsh/course/controller/CourseController.java
@@ -18,10 +18,7 @@
 import com.dsh.course.service.TCoursePackageService;
 import com.dsh.course.service.TCoursePackageTypeService;
 import com.dsh.course.service.TCourseService;
-import com.dsh.course.util.PageFactory;
-import com.dsh.course.util.PayMoneyUtil;
-import com.dsh.course.util.ResultUtil;
-import com.dsh.course.util.TokenUtil;
+import com.dsh.course.util.*;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
@@ -35,10 +32,12 @@
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 import java.io.PrintWriter;
+import java.math.BigDecimal;
 import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
+import java.util.stream.Collectors;
 
 @Api
 @CrossOrigin
@@ -451,4 +450,68 @@
     public String getHours(@RequestBody Integer coursePackageId1){
         return coursePackageService.getHours(coursePackageId1);
     }
+
+    @PostMapping("/course/queryFee")
+    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);
+        }
+
+        LambdaQueryWrapper<TCoursePackagePayment> wrapper = new LambdaQueryWrapper<>();
+        if(ToolUtil.isNotEmpty(data)){
+            String stime = data.split(" - ")[0]+" 00:00:00";
+            String etime = data.split(" - ")[1]+" 23:59:59";
+            wrapper.between(TCoursePackagePayment::getInsertTime,stime,etime);
+        }
+        wrapper.in(TCoursePackagePayment::getAppUserId,ids);
+        wrapper.eq(TCoursePackagePayment::getPayStatus,2);
+        ArrayList<Integer> objects = new ArrayList<>();
+        objects.add(1);
+        objects.add(2);
+        objects.add(5);
+        objects.add(6);
+        wrapper.in(TCoursePackagePayment::getPayType,objects);
+        List<TCoursePackagePayment> list = coursePackagePaymentService.list(wrapper);
+        double v = list.stream().map(TCoursePackagePayment::getCashPayment).reduce(BigDecimal.ZERO, BigDecimal::add).doubleValue();
+        List<Integer> collect = list.stream().map(TCoursePackagePayment::getCoursePackageId).collect(Collectors.toList());
+        if(collect.size()==0){
+            collect.add(-1);
+        }
+        //
+        List<TCoursePackage> list2 = coursePackageService.list(new LambdaQueryWrapper<TCoursePackage>().in(TCoursePackage::getId, collect));
+        // 课类型
+        List<TCoursePackageType> list1 = coursePackageTypeService.list();
+
+        for (TCoursePackagePayment tCoursePackagePayment : list) {
+            for (TCoursePackage tCoursePackage : list2) {
+                if(tCoursePackagePayment.getCoursePackageId().equals(tCoursePackage.getId())){
+                    tCoursePackagePayment.setType(tCoursePackage.getCoursePackageTypeId());
+                }
+            }
+        }
+
+        ArrayList<HashMap<String, Object>> hashMaps = new ArrayList<>();
+
+        for (TCoursePackageType tCoursePackageType : list1) {
+            HashMap<String, Object> objectObjectHashMap = new HashMap<>();
+            objectObjectHashMap.put("name",tCoursePackageType.getName());
+            double a= 0;
+            for (TCoursePackagePayment tCoursePackagePayment : list) {
+                if(tCoursePackagePayment.getType().equals(tCoursePackageType.getId())){
+                   a += tCoursePackagePayment.getCashPayment().doubleValue();
+                }
+            }
+            objectObjectHashMap.put("value",a);
+            hashMaps.add(objectObjectHashMap);
+        }
+
+        HashMap<String, Object> map1 = new HashMap<>();
+        map1.put("fee",v);
+        map1.put("data",hashMaps);
+
+        return map1;
+    }
 }

--
Gitblit v1.7.1