java/PlayPai.git

			@@ -13,8 +13,12 @@
			import com.dsh.course.feignclient.other.StoreClient;
			import com.dsh.course.feignclient.other.model.Store;
			import com.dsh.course.mapper.*;
			import com.dsh.course.model.DeductionClassHour;
			import com.dsh.course.model.DeductionClassHourList;
			import com.dsh.course.service.CourseCounsumService;
			import com.dsh.course.service.ICoursePackageOrderStudentService;
			import com.dsh.course.service.ICoursePackageSchedulingService;
			import com.dsh.course.service.TCoursePackageService;
			import com.dsh.course.util.DateTimeHelper;
			import com.dsh.course.util.DateUtil;
			import com.dsh.course.util.ToolUtil;
			@@ -44,11 +48,20 @@
			@Autowired
			private ICoursePackageSchedulingService coursePackageSchedulingService;

			@Autowired
			private CourseCounsumService courseCounsumService;

			@Resource
			private TCoursePackageMapper tcpmapper;

			@Resource
			private StoreClient stoClient;

			@Autowired
			private TCoursePackageService coursePackageService;

			@Resource
			private CoursePackageStudentMapper coursePackageStudentMapper;



			@@ -69,7 +82,6 @@
			List<CoursePackageScheduling> list = coursePackageSchedulingService.list(new QueryWrapper<CoursePackageScheduling>()
			.eq("appUserId", appUserId)
			.eq("studentId", stuId)
			// .lt("classDate", sdf.format(calendar.getTime()))
			.orderByAsc("classDate")
			);
			List<Long> ids = list.stream().map(CoursePackageScheduling::getId).collect(Collectors.toList());
			@@ -77,8 +89,6 @@
			SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy.MM.dd");
			SimpleDateFormat format = new SimpleDateFormat("yyyy.MM.dd HH:mm");
			if (list.size() > 0) {

			// int pageNum = 1; // 页码
			int pageSize = 10; // 每页记录数
			Page<CoursePackageStudent> page = new Page<>(pageNum, pageSize);
			IPage<CoursePackageStudent> coursePackageStudentPage = cpsMapper.selectPage(page, new QueryWrapper<CoursePackageStudent>()
			@@ -115,12 +125,12 @@
			}


			CoursePackageScheduling byId = coursePackageSchedulingService.getById(coursePackageStudent.getCoursePackageSchedulingId());
			if (byId == null) {
			CoursePackageScheduling coursePackageScheduling = coursePackageSchedulingService.getById(coursePackageStudent.getCoursePackageSchedulingId());
			if (coursePackageScheduling == null) {
			continue;
			}
			String dateString1 = sdf.format(byId.getClassDate());
			String dateString2 = sdf.format(byId.getEndDate());
			String dateString1 = sdf.format(coursePackageScheduling.getClassDate());
			String dateString2 = sdf.format(coursePackageScheduling.getEndDate());


			recordVo.setTimeFrame(dateString1 + "-" + dateString2.substring(11));
			@@ -132,73 +142,45 @@
			String[] split = classWeeks.split(";");
			List<String> integerList = Arrays.asList(split);
			String weekOfDate = DateTimeHelper.getWeekOfDate(new Date());
			// if (integerList.contains(weekOfDate)) {
			String dat = simpleDateFormat.format(byId.getClassDate()) + " " + dateString1.substring(11);
			String ed = simpleDateFormat.format(byId.getEndDate()) + " " + dateString2.substring(11);
			String dat = simpleDateFormat.format(coursePackageScheduling.getClassDate()) + " " + dateString1.substring(11);
			String ed = simpleDateFormat.format(coursePackageScheduling.getEndDate()) + " " + dateString2.substring(11);

			Date start = null;
			Date end = null;
			try {
			start = format.parse(dat);
			end = format.parse(ed);
			} catch (ParseException e) {
			throw new RuntimeException(e);
			}
			Date start = null;
			Date end = null;
			try {
			start = format.parse(dat);
			end = format.parse(ed);
			} catch (ParseException e) {
			throw new RuntimeException(e);
			}

			CancelledClasses cancelledClasses = cacMapper.selectOne(new QueryWrapper<CancelledClasses>()
			.eq("coursePackageSchedulingId", byId.getId()).last("limit 1"));
			// else {
			// Date now = new Date();
			// if (now.after(byId.getClassDate()) && now.before(byId.getEndDate())) {
			// recordVo.setStatus(2);
			// } else {
			// recordVo.setStatus(3);
			//
			// }
			// }
			.eq("coursePackageSchedulingId", coursePackageScheduling.getId()).last("limit 1"));

			//已取消
			if (byId.getStatus() == 4) {
			recordVo.setStatus(4);
			} else if (coursePackageStudent.getSignInOrNot() == 2) {
			//已请假
			recordVo.setStatus(5);
			}else if (ToolUtil.isNotEmpty(cancelledClasses)) {

			if (new Date().after(start)&&new Date().before(end)){
			recordVo.setStatus(2);
			}
			//待上课
			if (start.after(new Date())) {
			recordVo.setStatus(1);
			}
			//已取消
			if (coursePackageScheduling.getStatus() == 4) {
			recordVo.setStatus(4);
			}
			//已请假
			if (coursePackageStudent.getSignInOrNot() == 2) {
			recordVo.setStatus(5);
			}
			//已完成
			if (ToolUtil.isNotEmpty(cancelledClasses)) {
			recordVo.setStatus(3);
			// 消课到课状态0 旷课
			if (coursePackageStudent.getSignInOrNot() == 0) {
			recordVo.setStatus(6);
			}

			}else if (new Date().after(start)&&new Date().before(end)){
			recordVo.setStatus(2);
			}else if (start.after(new Date())) {
			//待上课
			recordVo.setStatus(1);
			}
			else {
			// CancelledClasses cancelledClasses = cacMapper.selectOne(new QueryWrapper<CancelledClasses>()
			// .eq("coursePackageSchedulingId", byId.getId()).last("limit 1"));
			// if (ToolUtil.isNotEmpty(cancelledClasses)) {
			// recordVo.setStatus(3);
			// // 消课到课状态0 旷课
			// if (coursePackageStudent.getSignInOrNot() == 0) {
			// recordVo.setStatus(6);
			// }
			//
			// } else {
			// Date now = new Date();
			// if (now.after(byId.getClassDate()) && now.before(byId.getEndDate())) {
			// recordVo.setStatus(2);
			// } else {
			// recordVo.setStatus(3);
			//
			// }
			// }
			}
			// } else {
			// recordVo.setStatus(1);
			// }
			}
			recordVoList.add(recordVo);
			}

			@@ -213,7 +195,7 @@


			public List<Integer> getIds(Integer siteId) {
			HttpRequest httpRequest = HttpRequest.get("https://try.daowepark.com/v7/user_api/general/get_space_area?space_id=" + siteId);
			HttpRequest httpRequest = HttpRequest.get("https://port.daowepark.com/v7/user_api/general/get_space_area?space_id=" + siteId);
			HttpResponse execute = httpRequest.execute();
			String body = execute.body();
			JSONObject jsonObject = JSONObject.parseObject(body);
			@@ -229,4 +211,270 @@
			return ids;

			}


			/**
			* 扣除学员课时
			* @param deductionClassHourList
			* @return
			*/
			@Override
			public DeductionClassHourList deductionClassHour(DeductionClassHourList deductionClassHourList) {
			try {
			List<DeductionClassHour> list = deductionClassHourList.getDeductionClassHourList();
			for (DeductionClassHour deductionClassHour : list) {
			CoursePackageOrderStudent coursePackageOrderStudent = this.getById(deductionClassHour.getId());
			Integer laveClassHours = coursePackageOrderStudent.getLaveClassHours();
			coursePackageOrderStudent.setLaveClassHours(coursePackageOrderStudent.getLaveClassHours() - deductionClassHour.getClassHour());

			//计算需要删除几个排课记录
			TCoursePackage coursePackage = coursePackageService.getById(coursePackageOrderStudent.getCoursePackageId());
			Integer codeTime = coursePackage.getCodeTime();
			//未上的排课数据
			List<CoursePackageScheduling> packageSchedulings = coursePackageSchedulingService.list(new QueryWrapper<CoursePackageScheduling>().eq("studentId", coursePackageOrderStudent.getStudentId())
			.eq("type", 1).eq("coursePackageId", coursePackageOrderStudent.getCoursePackageId()).eq("status", 1).orderByDesc("classDate"));
			//已经排课的总课时
			int classHour = packageSchedulings.size() * codeTime;
			//未排课的课时
			int notClass = laveClassHours - classHour;

			/**
			* 1、查询剩余已经排课的数据
			* 2、判断剩余课时- 未上排课 = 可扣减 -->是否满足扣减
			* --->满足扣减，直接减去剩余课时
			* --->不满足扣减，需要计算出删除的排课节数（注意每节消耗的课时数），然后减去剩余课时
			*/

			//判断是否需要删除排课数据
			if(notClass < deductionClassHour.getClassHour()){
			//计算需要删除的排课数量
			int clss = deductionClassHour.getClassHour() - notClass;
			int n = clss % codeTime;
			int num = clss / codeTime;
			//不整除的情况，需要多删除一节排课，回加差额课时。
			if(n != 0){
			num += 1;
			}
			//删除已排的课程
			List<CoursePackageScheduling> coursePackageSchedulings = packageSchedulings.subList(0, num);
			List<Long> collect = coursePackageSchedulings.stream().map(CoursePackageScheduling::getId).collect(Collectors.toList());
			if(collect.size() > 0){
			coursePackageSchedulingService.removeByIds(collect);
			coursePackageStudentMapper.delete(new QueryWrapper<CoursePackageStudent>().in("coursePackageSchedulingId", collect));
			}
			deductionClassHour.setScheduledCourses(num);
			}else{
			deductionClassHour.setScheduledCourses(0);
			}
			this.updateById(coursePackageOrderStudent);

			CourseCounsum courseCounsum = new CourseCounsum();
			courseCounsum.setPaymentId(coursePackageOrderStudent.getId());
			courseCounsum.setChangeType(0);
			courseCounsum.setNum(deductionClassHour.getClassHour());
			courseCounsum.setInsertTime(new Date());
			courseCounsum.setReason("社区世界杯报名");
			courseCounsum.setAppUserId(coursePackageOrderStudent.getAppUserId());
			courseCounsumService.save(courseCounsum);
			}
			return deductionClassHourList;
			}catch (Exception e){
			e.printStackTrace();
			}
			return null;
			}


			/**
			* 回退课时和回退排课数据
			* @param deductionClassHourList
			*/
			@Override
			public void backspaceClassHour(DeductionClassHourList deductionClassHourList) {
			List<DeductionClassHour> list = deductionClassHourList.getDeductionClassHourList();
			for (DeductionClassHour deductionClassHour : list) {
			CoursePackageOrderStudent coursePackageOrderStudent = this.getById(deductionClassHour.getId());
			Integer laveClassHours = coursePackageOrderStudent.getLaveClassHours();
			coursePackageOrderStudent.setLaveClassHours(coursePackageOrderStudent.getLaveClassHours() + deductionClassHour.getClassHour());
			this.updateById(coursePackageOrderStudent);

			CourseCounsum courseCounsum = new CourseCounsum();
			courseCounsum.setPaymentId(coursePackageOrderStudent.getId());
			courseCounsum.setChangeType(1);
			courseCounsum.setNum(deductionClassHour.getClassHour());
			courseCounsum.setInsertTime(new Date());
			courseCounsum.setReason("取消社区世界杯报名");
			courseCounsum.setAppUserId(coursePackageOrderStudent.getAppUserId());
			courseCounsumService.save(courseCounsum);


			//需要排课的节数
			Integer scheduledCourses = deductionClassHour.getScheduledCourses();
			if(scheduledCourses > 0){
			TCoursePackage coursePackage = coursePackageService.getById(coursePackageOrderStudent.getCoursePackageId());
			Integer codeTime = coursePackage.getCodeTime();
			CoursePackageScheduling one = coursePackageSchedulingService.getOne(new QueryWrapper<CoursePackageScheduling>().eq("studentId", coursePackageOrderStudent.getStudentId())
			.eq("type", 1).eq("coursePackageId", coursePackageOrderStudent.getCoursePackageId()).eq("status", 1)
			.orderByDesc("classDate").last(" limit 0, 1"));

			//上课星期
			String classWeeks = coursePackage.getClassWeeks();
			List<Integer> week = week(classWeeks);
			//新排课的开始日期
			Calendar start = Calendar.getInstance();
			String classStartTime = coursePackage.getClassStartTime();
			String classEndTime = coursePackage.getClassEndTime();
			String[] split = classStartTime.split(",");
			String[] split1 = classEndTime.split(",");
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			//计算剩余课时最大排课节数
			int num = laveClassHours / codeTime;
			//比较除哪个最小以哪个来确定排课节数
			num = num > scheduledCourses ? scheduledCourses : num;

			//先检查当前是都还有需要排课的
			if(null != one){
			Date classDate = one.getClassDate();

			Calendar calendar = Calendar.getInstance();
			calendar.setTime(classDate);
			String s = sdf.format(calendar.getTime());

			for (int j = 0; j < split.length; j++) {
			Date parse = null;
			Date parse1 = null;
			try {
			parse = format.parse(s + " " + split[j]);
			parse1 = format.parse(s + " " + split1[j]);
			} catch (ParseException e) {
			throw new RuntimeException(e);
			}
			if(classDate.getTime() >= parse.getTime()){
			continue;
			}

			//开始组装排课数据
			CoursePackageScheduling packageScheduling = new CoursePackageScheduling();
			packageScheduling.setType(1);
			packageScheduling.setAppUserId(coursePackageOrderStudent.getAppUserId());
			packageScheduling.setStudentId(coursePackageOrderStudent.getStudentId());
			packageScheduling.setCoursePackageId(coursePackage.getId());
			packageScheduling.setClassDate(parse);
			packageScheduling.setEndDate(parse1);
			packageScheduling.setStatus(1);
			coursePackageSchedulingService.save(packageScheduling);

			CoursePackageStudent student1 = new CoursePackageStudent();
			student1.setAppUserId(coursePackageOrderStudent.getAppUserId());
			student1.setStudentId(coursePackageOrderStudent.getStudentId());
			student1.setCoursePackageId(coursePackage.getId());
			student1.setCoursePackagePaymentId(coursePackageOrderStudent.getId());
			student1.setCoursePackageSchedulingId(packageScheduling.getId());
			student1.setSignInOrNot(1);
			student1.setReservationStatus(1);
			student1.setInsertTime(new Date());
			student1.setType(1);
			coursePackageStudentMapper.insert(student1);

			num--;
			if(num <= 0){
			return;
			}
			}

			calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + 1);
			start = calendar;
			}

			if(num <= 0){
			return;
			}

			//继续排后面的数据
			while (true) {
			String s = sdf.format(start.getTime());

			//判断当天是否在排课星期内
			int day = start.get(Calendar.DAY_OF_WEEK);
			day = day - 1 == 0 ? 7 : day - 1;
			if (!week.contains(day)) {
			start.set(Calendar.DAY_OF_YEAR, start.get(Calendar.DAY_OF_YEAR) + 1);
			continue;
			}

			for (int j = 0; j < split.length; j++) {
			//开始组装排课数据
			CoursePackageScheduling packageScheduling = new CoursePackageScheduling();
			packageScheduling.setType(1);
			packageScheduling.setAppUserId(coursePackageOrderStudent.getAppUserId());
			packageScheduling.setStudentId(coursePackageOrderStudent.getStudentId());
			packageScheduling.setCoursePackageId(coursePackage.getId());
			try {
			Date parse = format.parse(s + " " + split[j]);
			Date parse1 = format.parse(s + " " + split1[j]);
			packageScheduling.setClassDate(parse);
			packageScheduling.setEndDate(parse1);
			packageScheduling.setStatus(1);
			coursePackageSchedulingService.save(packageScheduling);

			CoursePackageStudent student1 = new CoursePackageStudent();
			student1.setAppUserId(coursePackageOrderStudent.getAppUserId());
			student1.setStudentId(coursePackageOrderStudent.getStudentId());
			student1.setCoursePackageId(coursePackage.getId());
			student1.setCoursePackagePaymentId(coursePackageOrderStudent.getId());
			student1.setCoursePackageSchedulingId(packageScheduling.getId());
			student1.setSignInOrNot(1);
			student1.setReservationStatus(1);
			student1.setInsertTime(new Date());
			student1.setType(1);
			coursePackageStudentMapper.insert(student1);
			} catch (Exception e) {
			e.printStackTrace();
			}
			num--;
			if(num <= 0){
			return;
			}
			}
			start.set(Calendar.DAY_OF_YEAR, start.get(Calendar.DAY_OF_YEAR) + 1);
			}
			}

			}

			}



			private List<Integer> week(String week) {
			String[] split = week.split(";");
			ArrayList<Integer> integers = new ArrayList<>();
			for (String s : split) {
			switch (s) {
			case "周一":
			integers.add(1);
			break;
			case "周二":
			integers.add(2);
			break;
			case "周三":
			integers.add(3);
			break;
			case "周四":
			integers.add(4);
			break;
			case "周五":
			integers.add(5);
			break;
			case "周六":
			integers.add(6);
			break;
			case "周日":
			integers.add(7);
			break;
			}
			}
			return integers;
			}
			}