From f88cfa02e36752e4acad7adc4b045155e8e50f21 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期五, 08 十二月 2023 09:16:29 +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/service/impl/TCoursePackagePaymentServiceImpl.java |  312 +++++++++++++++++++++++++++++++++------------------
 1 files changed, 202 insertions(+), 110 deletions(-)

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 3f681cd..25b9b3e 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
@@ -18,10 +18,8 @@
 import com.dsh.course.feignclient.account.AppUserClient;
 import com.dsh.course.feignclient.account.CoachClient;
 import com.dsh.course.feignclient.account.StudentClient;
-import com.dsh.course.feignclient.account.model.AppUser;
-import com.dsh.course.feignclient.account.model.Coach;
-import com.dsh.course.feignclient.account.model.Student;
-import com.dsh.course.feignclient.account.model.TCourseInfoRecord;
+import com.dsh.course.feignclient.account.UserIntegralChangesClient;
+import com.dsh.course.feignclient.account.model.*;
 import com.dsh.course.feignclient.activity.BenefitVideoClient;
 import com.dsh.course.feignclient.activity.CouponClient;
 import com.dsh.course.feignclient.activity.model.BenefitsVideos;
@@ -118,9 +116,11 @@
     @Autowired
     private ICoursePackageSchedulingService coursePackageSchedulingService;
 
-
     @Autowired
     private RestTemplate internalRestTemplate;
+
+    @Resource
+    private UserIntegralChangesClient userIntegralChangesClient;
 
 
     @Override
@@ -130,13 +130,8 @@
 
     @Override
     public int changeState(CoursePackagePayDTO dto) {
-        List<String> ids = dto.getIds();
-        List<Long> list = new ArrayList<>();
-        for (String id : ids) {
-            long value = Long.parseLong(id);
-            list.add(value);
-        }
-        return cpConfigMapper.changeState(list, dto.getPayUserName(), dto.getUserId());
+
+        return cpConfigMapper.changeState(Long.valueOf(dto.getIds()), dto.getPayUserName(), dto.getUserId());
     }
 
     @Override
@@ -157,70 +152,110 @@
 
     @Override
     public List<Map<String, Object>> getStudentTotal(StudentQeryDto studentQeryDto) {
-        List<Map<String, Object>> studentTotal = this.baseMapper.getStudentTotal(studentQeryDto);
+//        String cityCode = studentQeryDto.getCityCode();
+//        String start = studentQeryDto.getStart();
+//        String end = studentQeryDto.getEnd();
+//        //获取用户数据
+//        List<Integer> appUserIds = null;
+//        if(ToolUtil.isNotEmpty(cityCode)){
+//            List<AppUser> appUsers = appuClient.queryAppUserByCityCode(cityCode);
+//            if(appUsers.size() > 0){
+//                appUserIds = appUsers.stream().map(AppUser::getId).collect(Collectors.toList());
+//            }
+//        }
+//        QueryWrapper<CoursePackageStudent> status = new QueryWrapper<CoursePackageStudent>().eq("payStatus", 2).eq("status", 1);
+//        if(null != appUserIds){
+//            status.in("appUserId", appUserIds);
+//        }
+//        List<Map<String, Object>> maps = this.baseMapper.getStudentTotal(appUserIds, studentQeryDto.getStart(), studentQeryDto.getEnd());
+//        List<Map<String, Object>> list = new ArrayList<>();
+//        for (Map<String, Object> objectMap : maps) {
+//            Integer studentId = Integer.valueOf(objectMap.get("studentId").toString());
+//            Integer appUserId = Integer.valueOf(objectMap.get("appUserId").toString());
+//            Integer coursePackageId = Integer.valueOf(objectMap.get("coursePackageId").toString());
+//            Integer number = Integer.valueOf(objectMap.get("number").toString());
+//            Map<String, Object> map = new HashMap<>();
+//            Student student = studentClient.queryStudentById(studentId);
+//            map.put("studentName", student.getName());
+//            AppUser appUser = appuClient.queryAppUser(appUserId);
+//            map.put("province", appUser.getProvince());
+//            map.put("provinceCode", appUser.getProvinceCode());
+//            map.put("city", appUser.getCity());
+//            map.put("cityCode", appUser.getCityCode());
+//            TCoursePackage coursePackage = coursePackageService.getById(coursePackageId);
+//            map.put("courseName", coursePackage.getName());
+//            map.put("totalClassHours", number);
+//            map.put("cashPayment", coursePackageOrder.getCashPayment());
+//            map.put("hasHours", )
+//
+//
+//        }
 
-        for (Map<String, Object> student : studentTotal) {
-            Integer appUserId = (Integer) student.get("appUserId");
-            AppUser appUser = appuClient.queryAppUser(appUserId);
-            student.put("province", appUser.getProvince());
-            student.put("provinceCode", appUser.getProvinceCode());
 
-            student.put("city", appUser.getCity());
-            student.put("cityCode", appUser.getCityCode());
-
-            Student studentId = studentClient.queryStudentById((Integer) student.get("studentId"));
-            student.put("studentName", studentId.getName());
-            BigDecimal cashPayment = (BigDecimal) student.get("cashPayment");
-            BigDecimal totalClassHours = (BigDecimal) student.get("totalClassHours");
-            BigDecimal hasHours = (BigDecimal) student.get("hasHours");
-            if (cashPayment == null) {
-                continue;
-            }
-            if (totalClassHours.compareTo(BigDecimal.ZERO) == 0) {
-                totalClassHours = totalClassHours.add(new BigDecimal("1"));
-            }
-            BigDecimal hasPayment = cashPayment.divide(totalClassHours, 2, RoundingMode.HALF_UP)
-                    .multiply(hasHours).setScale(2, RoundingMode.HALF_UP);
-            student.put("hasPayment", hasPayment);
-        }
-
-        if (studentQeryDto.getCityCode() != null && studentQeryDto.getCityCode() != "") {
-            String value = studentQeryDto.getCityCode();
-            boolean allZeros = value.substring(value.length() - 4).endsWith("0000");
-            System.out.println(allZeros); // Output: true
-            if (allZeros) {
-                Iterator<Map<String, Object>> iterator = studentTotal.iterator();
-                while (iterator.hasNext()) {
-                    Map<String, Object> student = iterator.next();
-                    String cityCode = (String) student.get("provinceCode");
-                    if (!cityCode.equals(studentQeryDto.getCityCode())) {
-                        iterator.remove(); // Remove the element from the list
-                    }
-                }
-            } else {
-                Iterator<Map<String, Object>> iterator = studentTotal.iterator();
-                while (iterator.hasNext()) {
-                    Map<String, Object> student = iterator.next();
-                    String cityCode = (String) student.get("cityCode");
-                    if (!cityCode.equals(studentQeryDto.getCityCode())) {
-                        iterator.remove(); // Remove the element from the list
-                    }
-                }
-            }
-        }
-
-        if (studentQeryDto.getStudentName() != null && studentQeryDto.getStudentName() != "") {
-            List<Map<String, Object>> totallike = new ArrayList<>();
-            for (Map<String, Object> student : studentTotal) {
-                String studentName = (String) student.get("studentName");
-                if (studentName.contains(studentQeryDto.getStudentName())) {
-                    totallike.add(student);
-                }
-
-            }
-            return totallike;
-        }
-        return studentTotal;
+//        List<Map<String, Object>> studentTotal = this.baseMapper.getStudentTotal(studentQeryDto);
+//        for (Map<String, Object> student : studentTotal) {
+//            Integer appUserId = (Integer) student.get("appUserId");
+//            AppUser appUser = appuClient.queryAppUser(appUserId);
+//            student.put("province", appUser.getProvince());
+//            student.put("provinceCode", appUser.getProvinceCode());
+//
+//            student.put("city", appUser.getCity());
+//            student.put("cityCode", appUser.getCityCode());
+//
+//            Student studentId = studentClient.queryStudentById((Integer) student.get("studentId"));
+//            student.put("studentName", studentId.getName());
+//            BigDecimal cashPayment = (BigDecimal) student.get("cashPayment");
+//            BigDecimal totalClassHours = (BigDecimal) student.get("totalClassHours");
+//            BigDecimal hasHours = (BigDecimal) student.get("hasHours");
+//            if (cashPayment == null) {
+//                continue;
+//            }
+//            if (totalClassHours.compareTo(BigDecimal.ZERO) == 0) {
+//                totalClassHours = totalClassHours.add(new BigDecimal("1"));
+//            }
+//            BigDecimal hasPayment = cashPayment.divide(totalClassHours, 2, RoundingMode.HALF_UP)
+//                    .multiply(hasHours).setScale(2, RoundingMode.HALF_UP);
+//            student.put("hasPayment", hasPayment);
+//        }
+//
+//        if (studentQeryDto.getCityCode() != null && studentQeryDto.getCityCode() != "") {
+//            String value = studentQeryDto.getCityCode();
+//            boolean allZeros = value.substring(value.length() - 4).endsWith("0000");
+//            System.out.println(allZeros); // Output: true
+//            if (allZeros) {
+//                Iterator<Map<String, Object>> iterator = studentTotal.iterator();
+//                while (iterator.hasNext()) {
+//                    Map<String, Object> student = iterator.next();
+//                    String cityCode = (String) student.get("provinceCode");
+//                    if (!cityCode.equals(studentQeryDto.getCityCode())) {
+//                        iterator.remove(); // Remove the element from the list
+//                    }
+//                }
+//            } else {
+//                Iterator<Map<String, Object>> iterator = studentTotal.iterator();
+//                while (iterator.hasNext()) {
+//                    Map<String, Object> student = iterator.next();
+//                    String cityCode = (String) student.get("cityCode");
+//                    if (!cityCode.equals(studentQeryDto.getCityCode())) {
+//                        iterator.remove(); // Remove the element from the list
+//                    }
+//                }
+//            }
+//        }
+//
+//        if (studentQeryDto.getStudentName() != null && studentQeryDto.getStudentName() != "") {
+//            List<Map<String, Object>> totallike = new ArrayList<>();
+//            for (Map<String, Object> student : studentTotal) {
+//                String studentName = (String) student.get("studentName");
+//                if (studentName.contains(studentQeryDto.getStudentName())) {
+//                    totallike.add(student);
+//                }
+//
+//            }
+//            return totallike;
+//        }
+//        return studentTotal;
+        return null;
     }
 
     @Override
@@ -326,7 +361,6 @@
     @Override
     public CourseOfVideoResponse queryVideoDetails(CourseWithDetailsRequest detailsRequest, Integer appUserId) {
         CourseOfVideoResponse response = new CourseOfVideoResponse();
-//        BenefitsVideos videosWithIds = bfvoClient.getVideosWithIds(detailsRequest.getVideoId());
         TCourse byId = courseService.getById(detailsRequest.getVideoId());
         TCoursePackage coursePackage = tcpmapper.selectById(detailsRequest.getCoursePackageId());
         CoursePackageScheduling byId1 = new CoursePackageScheduling();
@@ -373,6 +407,17 @@
             userVideoDetails.setState(2);
             userVideoDetails.setUpdateTime(new Date());
             uvdmapper.updateById(userVideoDetails);
+
+            CoursePackageScheduling coursePackageScheduling = coursePackageSchedulingService.getById(detailsRequest.getScId());
+            //添加积分
+            AppUser appUser = appuClient.queryAppUser(coursePackageScheduling.getAppUserId());
+            appUser.setIntegral((null == appUser.getIntegral() ? 0 : appUser.getIntegral()) + (null == coursePackageScheduling.getIntegral() ? 0 : coursePackageScheduling.getIntegral()));
+            appuClient.updateAppUser(appUser);
+            SaveUserIntegralChangesVo vo = new SaveUserIntegralChangesVo();
+            vo.setAppUserId(coursePackageScheduling.getAppUserId());
+            vo.setIntegral(coursePackageScheduling.getIntegral());
+            vo.setType(4);
+            userIntegralChangesClient.saveUserIntegralChanges(vo);
             return "SUCCESS";
         }
         return "ERROR";
@@ -515,19 +560,22 @@
     public CourseDetailsResponse queryRegisteredCourseDetails(Long coursePayId, Integer appUserId, String lon, String lat) {
         AppUser appUser = appuClient.queryAppUser(appUserId);
         CourseDetailsResponse response = new CourseDetailsResponse();
-        CoursePackageOrderStudent coursePackageOrderStudent = coursePackageOrderStudentService.getById(coursePayId);
-        CoursePackageOrder coursePackageOrder = coursePackageOrderService.getOne(new QueryWrapper<CoursePackageOrder>()
-                .eq("appUserId", coursePackageOrderStudent.getAppUserId())
-                .eq("coursePackageId", coursePackageOrderStudent.getCoursePackageId())
-                .eq("payStatus", 2)
-                .eq("state", 1)
-                .like("studentIds", coursePackageOrderStudent.getStudentId())
-                .orderByDesc("insertTime")
-                .last(" limit 0, 1")
-        );
+        CoursePackageOrder coursePackageOrder = coursePackageOrderService.getById(coursePayId);
+        if (coursePackageOrder==null){
+//             student = coursePackageStudentService.getById(coursePayId);
+            CoursePackageOrderStudent student = coursePackageOrderStudentService.getById(coursePayId);
+
+            coursePackageOrder = coursePackageOrderService.getOne(new QueryWrapper<CoursePackageOrder>().eq("appUserId", student.getAppUserId()).like("studentIds", student.getStudentId()).eq("coursePackageId", student.getCoursePackageId()).orderByDesc("insertTime").last("limit 1"));
+
+        }
+        response.setOrinPrice(coursePackageOrder.getOriginalPrice());
 
 
         response.setChooseHours(coursePackageOrder.getClassHours());
+        response.setStuIds(coursePackageOrder.getStudentIds().split(","));
+        response.setPayType(coursePackageOrder.getPayType());
+        response.setPayPrice(coursePackageOrder.getCashPayment());
+        response.setCoinPrice(coursePackageOrder.getPlayPaiCoin());
 
         if (null != coursePackageOrder) {
             TCoursePackage coursePackage = tcpmapper.selectById(coursePackageOrder.getCoursePackageId());
@@ -536,6 +584,7 @@
             }
             Store store = storeClient.queryStoreById(coursePackage.getStoreId());
             response.setStoreName(store.getName());
+            response.setStoreAddress(store.getAddress());
 
             if (ToolUtil.isNotEmpty(lon) && ToolUtil.isNotEmpty(lat)) {
                 Map<String, Double> distance = GeodesyUtil.getDistance(lon + "," + lat, store.getLon() + "," + store.getLat());
@@ -572,6 +621,16 @@
             response.setIntroduceDrawing(coursePackage.getIntroduceDrawing());
 
             Integer payType = coursePackageOrder.getPayType();
+            if(null == payType){
+                CoursePackagePaymentConfig config = coursePackagePaymentConfigService.list(new QueryWrapper<CoursePackagePaymentConfig>().eq("coursePackageId", coursePackage.getId()).orderByAsc("classHours")).get(0);
+                if (ToolUtil.isNotEmpty(config.getCashPayment()) && config.getCashPayment() > 0 && ToolUtil.isNotEmpty(config.getPlayPaiCoin()) && config.getPlayPaiCoin() > 0) {
+                    payType = 3;
+                } else if (ToolUtil.isNotEmpty(config.getCashPayment()) && config.getCashPayment() > 0) {
+                    payType = 1;
+                } else if (ToolUtil.isNotEmpty(config.getPlayPaiCoin()) && config.getPlayPaiCoin() > 0) {
+                    payType = 2;
+                }
+            }
             BigDecimal cashPayment = coursePackageOrder.getCashPayment();
             double cashPaymentValue = 0.0;
             if (cashPayment != null) {
@@ -598,12 +657,14 @@
 
             switch (payType) {
                 case 1:
-                case 2:
+                case 3:
                     response.setAmount(cashPaymentValue);
                     response.setVipAmount(discountMember);
                     break;
-                case 3:
-                    response.setWpGold(playPaiCoin);
+                case 2:
+                    if (playPaiCoin!=null) {
+                        response.setWpGold(playPaiCoin);
+                    }
                     break;
             }
 
@@ -721,16 +782,16 @@
                     TCoursePackageDiscount discount = coursePackageDiscountService.getOne(new QueryWrapper<TCoursePackageDiscount>().eq("coursePackagePaymentConfigId", coursePackagePaymentConfig.getId())
                             .eq("type", 2).eq("auditStatus", 2));
 
-                    Double continuingMember = JSON.parseObject(discount.getContent()).getDouble("continuingUser");
-                    Double vipcontinuingMember = JSON.parseObject(discount.getContent()).getDouble("continuingMember");
-
-
-                    if (coursePackagePaymentConfigVo.getPaymentPrice() > continuingMember) {
-                        coursePackagePaymentConfigVo.setPaymentPrice(continuingMember);
-                    }
-                    if (coursePackagePaymentConfigVo.getVipPrice() > vipcontinuingMember) {
-                        coursePackagePaymentConfigVo.setVipPrice(vipcontinuingMember);
-                    }
+//                    Double continuingMember = JSON.parseObject(discount.getContent()).getDouble("continuingUser");
+//                    Double vipcontinuingMember = JSON.parseObject(discount.getContent()).getDouble("continuingMember");
+//
+//
+//                    if (coursePackagePaymentConfigVo.getPaymentPrice() > continuingMember) {
+//                        coursePackagePaymentConfigVo.setPaymentPrice(continuingMember);
+//                    }
+//                    if (coursePackagePaymentConfigVo.getVipPrice() > vipcontinuingMember) {
+//                        coursePackagePaymentConfigVo.setVipPrice(vipcontinuingMember);
+//                    }
 
 
                     if (coursePackagePaymentConfigVo.getPaymentPrice() < coursePackagePaymentConfigVo.getVipPrice()) {
@@ -1203,6 +1264,7 @@
     @Override
     public List<Map<String, Object>> queryRegistrationRecord(Page<Map<String, Object>> page, QueryRegistrationRecord queryRegistrationRecord) {
         Integer coursePackageId = queryRegistrationRecord.getCoursePackageId();
+        TCoursePackage coursePackage = coursePackageService.getById(coursePackageId);
         String userName = queryRegistrationRecord.getUserName();
         List<Integer> userIds = null;
         List<Integer> studentIds = null;
@@ -1219,12 +1281,27 @@
                 studentIds = students.stream().map(Student::getId).collect(Collectors.toList());
             }
         }
-        List<Map<String, Object>> list = this.baseMapper.queryRegistrationRecord(page, coursePackageId, userIds, studentIds);
+
+        List<Map<String, Object>> list = new ArrayList<>();
+
+        if (coursePackage.getType()==1){
+      list = this.baseMapper.queryRegistrationRecord(page, coursePackageId, userIds, studentIds);
+        }else {
+            list = this.baseMapper.queryRegistrationRecord1(page, coursePackageId, userIds, studentIds);
+        }
+
+        list.addAll(this.baseMapper.queryRegistrationRecord3(coursePackageId,userIds,studentIds));
         for (Map<String, Object> map : list) {
+
 
             Long id = Long.valueOf(map.get("id").toString());
             Integer appUserId = Integer.valueOf(map.get("appUserId").toString());
-            Integer studentId = Integer.valueOf(map.get("studentId").toString());
+            Integer studentId = 0;
+            if (coursePackage.getType()==1) {
+                studentId = Integer.valueOf(map.get("studentId").toString());
+            }else {
+                studentId = Integer.valueOf(map.get("studentIds").toString().split(",")[0]);
+            }
 
             TAppUser appUser = appuClient.queryAppUser1(appUserId);
             map.put("userName", null != appUser ? appUser.getName() : "");
@@ -1233,6 +1310,11 @@
             map.put("studentName", null != student ? student.getName() : "");
             Integer integer = cpsMapper.selectCount(new QueryWrapper<CoursePackageStudent>().eq("appUserId", appUserId)
                     .eq("studentId", studentId).eq("coursePackagePaymentId", id).eq("signInOrNot", 2));
+
+            int count = coursePackageStudentService.count(new QueryWrapper<CoursePackageStudent>().eq("coursePackageId", coursePackageId).eq("studentId", studentId).eq("signInOrNot",2));
+
+            map.put("absencesNumber", count);
+
             map.put("already", integer);
         }
         return list;
@@ -1416,8 +1498,7 @@
             return ResultUtil.error("当前课包课时数不足");
         }
         TCoursePackage coursePackage = coursePackageService.getById(coursePackageOrderStudent.getCoursePackageId());
-        coursePackageOrderStudent.setLaveClassHours(coursePackageOrderStudent.getLaveClassHours() - req.getNum());
-        coursePackageOrderStudentService.updateById(coursePackageOrderStudent);
+        TCoursePackage coursePackage1 = coursePackageService.getById(req.getCourseId());
         //判断剩余课时是否已经全部进行排课,如果排课需要删除已经排好的记录
         List<CoursePackageScheduling> list1 = coursePackageSchedulingService.list(new QueryWrapper<CoursePackageScheduling>()
                 .eq("studentId", coursePackageOrderStudent.getStudentId()).eq("status", 1)
@@ -1425,9 +1506,19 @@
         //已经排课但没有使用的课时数量
         int number = list1.size() * coursePackage.getNeedNum();
         Integer laveClassHours1 = coursePackageOrderStudent.getLaveClassHours();
+        laveClassHours1 -= number;
+        //需要购买使用的课时数
+        Integer num = req.getNum();
         //需要删除多余的排课记录
-        if(number > laveClassHours1){
-            int n = number - laveClassHours1;
+        if(num.compareTo(laveClassHours1) > 0){
+            //课时数差额
+            int number1 = num - laveClassHours1;
+            double o = number1 % coursePackage.getNeedNum();
+            int l = 0;
+            if(0 != o){
+                l = 1;
+            }
+            int n = Double.valueOf(number1 / coursePackage.getNeedNum()).intValue() + l;
             for (int i = 0; i < n; i++) {
                 CoursePackageScheduling coursePackageScheduling = list1.get(i);
                 coursePackageSchedulingService.getBaseMapper().deleteById(coursePackageScheduling.getId());
@@ -1438,9 +1529,9 @@
         }
 
 
-        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
-        String classStartTime = coursePackage.getClassStartTime();
-        String classEndTime = coursePackage.getClassEndTime();
+        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+        String classStartTime = coursePackage1.getClassStartTime();
+        String classEndTime = coursePackage1.getClassEndTime();
         String[] split5 = classStartTime.split(",");
         String[] split6 = classEndTime.split(",");
         List<String> time = req.getTime();
@@ -1450,7 +1541,7 @@
                 coursePackageScheduling.setType(3);
                 coursePackageScheduling.setAppUserId(userId);
                 coursePackageScheduling.setStudentId(req.getStuId());
-                coursePackageScheduling.setCoursePackageId(coursePackage.getId());
+                coursePackageScheduling.setCoursePackageId(req.getCourseId());
                 try {
                     Date parse = format.parse(s + " " + split5[i]);
                     Date parse1 = format.parse(s + " " + split6[i]);
@@ -1462,7 +1553,7 @@
                     CoursePackageStudent student1 = new CoursePackageStudent();
                     student1.setAppUserId(userId);
                     student1.setStudentId(req.getStuId());
-                    student1.setCoursePackageId(coursePackage.getId());
+                    student1.setCoursePackageId(req.getCourseId());
                     student1.setCoursePackagePaymentId(coursePackageOrderStudent.getId());
                     student1.setCoursePackageSchedulingId(coursePackageScheduling.getId());
                     student1.setSignInOrNot(1);
@@ -1477,7 +1568,8 @@
             }
         }
 
-
+        coursePackageOrderStudent.setLaveClassHours(coursePackageOrderStudent.getLaveClassHours() - req.getNum());
+        coursePackageOrderStudentService.updateById(coursePackageOrderStudent);
 
 
         CourseCounsum courseCounsum = new CourseCounsum();

--
Gitblit v1.7.1