| | |
| | | int count1 = coursePackageStudentService.count(new QueryWrapper<CoursePackageStudent>().eq("coursePackageSchedulingId", id).eq("reservationStatus", 1)); |
| | | int count2 = coursePackageStudentService.count(new QueryWrapper<CoursePackageStudent>().eq("coursePackageSchedulingId", id).eq("reservationStatus", 0)); |
| | | |
| | | CoursePackageScheduling coursePackageScheduling = coursePackageSchedulingMapper.selectById(id); |
| | | |
| | | map.put("registered", count2); |
| | | map.put("actualArrival", count1); |
| | | map.put("nonArrival", count - count1); |
| | | List<CoursePackageScheduling> coursePackageSchedulings = coursePackageSchedulingMapper.selectList(new QueryWrapper<CoursePackageScheduling>().eq("classDate", coursePackageScheduling.getClassDate()).eq("coursePackageId", coursePackageScheduling.getCoursePackageId())); |
| | | List<Long> scs = new ArrayList<>(); |
| | | for (CoursePackageScheduling packageScheduling : coursePackageSchedulings) { |
| | | scs.add(packageScheduling.getId()); |
| | | } |
| | | int res = coursePackageStudentService.count(new QueryWrapper<CoursePackageStudent>().in("coursePackageSchedulingId", scs).eq("signInOrNot", 2)); |
| | | int act = coursePackageStudentService.count(new QueryWrapper<CoursePackageStudent>().in("coursePackageSchedulingId", scs).eq("signInOrNot", 1)); |
| | | int nonArrival = coursePackageStudentService.count(new QueryWrapper<CoursePackageStudent>().in("coursePackageSchedulingId", scs).eq("signInOrNot", 0)); |
| | | |
| | | map.put("registered", res); |
| | | map.put("actualArrival", act); |
| | | map.put("nonArrival",nonArrival); |
| | | // Integer totalClassHours = (Integer) map.get("totalClassHours"); |
| | | // Integer laveClassHours = (Integer) map.get("laveClassHours"); |
| | | // map.put("already",totalClassHours-laveClassHours); |