| | |
| | | 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); |
| | |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * 定时修改状态 |
| | | */ |
| | | @Override |
| | | public void cancel() { |
| | | new Thread(new Runnable() { |
| | | @Override |
| | | public void run() { |
| | | List<TCoursePackagePayment> list = packagePaymentService.list(); |
| | | Date now = new Date(); |
| | | List<Long> pays = new ArrayList<>(); |
| | | for (TCoursePackagePayment coursePackagePayment : list) { |
| | | if (now.before(coursePackagePayment.getUseTime())) { |
| | | pays.add(coursePackagePayment.getId()); |
| | | } |
| | | } |
| | | |
| | | List<CoursePackageStudent> coursePackagePaymentId = coursePackageStudentService.list(new QueryWrapper<CoursePackageStudent>().in("coursePackagePaymentId", pays)); |
| | | List<Long> scs = new ArrayList<>(); |
| | | for (CoursePackageStudent coursePackageStudent : coursePackagePaymentId) { |
| | | scs.add(coursePackageStudent.getCoursePackageSchedulingId()); |
| | | } |
| | | coursePackageStudentService.remove(new QueryWrapper<CoursePackageStudent>().in("coursePackagePaymentId", pays)); |
| | | coursePackageSchedulingMapper.delete(new QueryWrapper<CoursePackageScheduling>().in("id", scs)); |
| | | |
| | | |
| | | } |
| | | }).start(); |
| | | } |
| | | |
| | | /** |
| | | * 定时修改状态 |
| | |
| | | * @param coursePackageOrderStudentId |
| | | */ |
| | | @Override |
| | | public void addNewCoursePackageScheduling(Integer coursePackageOrderStudentId, Integer classNumber) { |
| | | public void addNewCoursePackageScheduling(Long coursePackageOrderStudentId, Integer classNumber) { |
| | | CoursePackageOrderStudent coursePackageOrderStudent = coursePackageOrderStudentService.getById(coursePackageOrderStudentId); |
| | | CoursePackageScheduling coursePackageScheduling = this.getOne(new QueryWrapper<CoursePackageScheduling>() |
| | | .eq("appUserId", coursePackageOrderStudent.getAppUserId()) |