@Override public Boolean execute(OnlineSectioningServer server, OnlineSectioningHelper helper) { StudentSectioningStatus status = (hasStatus() ? (StudentSectioningStatus) helper .getHibSession() .createQuery("from StudentSectioningStatus where reference = :ref") .setString("ref", getStatus()) .uniqueResult() : null); for (Long studentId : getStudentIds()) { Lock lock = server.lockStudent(studentId, null, name()); try { XStudent student = server.getStudent(studentId); helper.beginTransaction(); try { Student dbStudent = StudentDAO.getInstance().get(studentId, helper.getHibSession()); if (student != null && dbStudent != null) { OnlineSectioningLog.Action.Builder action = helper.addAction(this, server.getAcademicSession()); action.setStudent( OnlineSectioningLog.Entity.newBuilder() .setUniqueId(student.getStudentId()) .setExternalId(student.getExternalId()) .setName(student.getName())); if (status != null) { action.addOther( OnlineSectioningLog.Entity.newBuilder() .setUniqueId(status.getUniqueId()) .setName(status.getLabel()) .setExternalId(status.getReference()) .setType(OnlineSectioningLog.Entity.EntityType.OTHER)); } student.setStatus(getStatus()); dbStudent.setSectioningStatus(status); helper.getHibSession().saveOrUpdate(dbStudent); server.update(student, false); } helper.commitTransaction(); } catch (Exception e) { helper.rollbackTransaction(); if (e instanceof SectioningException) throw (SectioningException) e; throw new SectioningException(MSG.exceptionUnknown(e.getMessage()), e); } } finally { lock.release(); } } return true; }
@Override public Boolean execute(OnlineSectioningServer server, OnlineSectioningHelper helper) { for (Long offeringId : getOfferingIds()) { helper .getAction() .addOther( OnlineSectioningLog.Entity.newBuilder() .setUniqueId(offeringId) .setType(OnlineSectioningLog.Entity.EntityType.OFFERING)); List<Long> studentIds = (List<Long>) helper .getHibSession() .createQuery( "select distinct cr.courseDemand.student.uniqueId from CourseRequest cr " + "where cr.courseOffering.instructionalOffering.uniqueId = :offeringId") .setLong("offeringId", offeringId) .list(); studentIds.addAll( helper .getHibSession() .createQuery( "select distinct e.student.uniqueId from StudentClassEnrollment e " + "where e.courseOffering.instructionalOffering.uniqueId = :offeringId and e.courseRequest is null") .setLong("offeringId", offeringId) .list()); /* List<Long> studentIds = (List<Long>)helper.getHibSession().createQuery( "select distinct s.uniqueId from Student s " + "left outer join s.classEnrollments e " + "left outer join s.courseDemands d left outer join d.courseRequests r left outer join r.courseOffering co " + "where e.courseOffering.instructionalOffering.uniqueId = :offeringId or " + "co.instructionalOffering.uniqueId = :offeringId").setLong("offeringId", offeringId).list(); */ Lock lock = server.lockOffering(offeringId, studentIds, name()); try { helper.beginTransaction(); try { reloadOffering(server, helper, offeringId); helper.commitTransaction(); } catch (Exception e) { helper.rollbackTransaction(); if (e instanceof SectioningException) throw (SectioningException) e; throw new SectioningException(MSG.exceptionUnknown(e.getMessage()), e); } } finally { lock.release(); } } return true; }
private OnlineSectioningLog.Entity currentUser(SessionContext context) { UserContext user = context.getUser(); UniTimePrincipal principal = (UniTimePrincipal) context.getAttribute("user"); if (user != null) { return OnlineSectioningLog.Entity.newBuilder() .setExternalId(user.getExternalUserId()) .setName(user.getName() == null ? user.getUsername() : user.getName()) .setType( context.hasPermission(Right.StudentSchedulingAdvisor) ? OnlineSectioningLog.Entity.EntityType.MANAGER : OnlineSectioningLog.Entity.EntityType.STUDENT) .build(); } else if (principal != null) { return OnlineSectioningLog.Entity.newBuilder() .setExternalId(principal.getExternalId()) .setName(principal.getName()) .setType(OnlineSectioningLog.Entity.EntityType.STUDENT) .build(); } else { return null; } }
public void reloadOffering( final OnlineSectioningServer server, OnlineSectioningHelper helper, Long offeringId) { // Load new students Map<Long, org.unitime.timetable.model.Student> newStudents = new HashMap<Long, org.unitime.timetable.model.Student>(); /* for (org.unitime.timetable.model.Student student : (List<org.unitime.timetable.model.Student>)helper.getHibSession().createQuery( "select s from Student s " + "left join fetch s.courseDemands as cd " + "left join fetch cd.courseRequests as cr " + "left join fetch cr.courseOffering as co " + "left join fetch cr.classWaitLists as cwl " + "left join fetch s.classEnrollments as e " + "left join fetch s.academicAreaClassifications as a " + "left join fetch s.posMajors as mj " + "left join fetch s.waitlists as w " + "left join fetch s.groups as g " + "where s.uniqueId in (select xe.student.uniqueId from StudentClassEnrollment xe where xe.courseOffering.instructionalOffering.uniqueId = :offeringId) " + "or s.uniqueId in (select xr.courseDemand.student.uniqueId from CourseRequest xr where xr.courseOffering.instructionalOffering.uniqueId = :offeringId)" ).setLong("offeringId", offeringId).list()) { newStudents.put(student.getUniqueId(), student); } */ for (org.unitime.timetable.model.Student student : (List<org.unitime.timetable.model.Student>) helper .getHibSession() .createQuery( "select distinct s from Student s " + "left join s.courseDemands as cd " + "left join cd.courseRequests as cr " + "left join fetch s.classEnrollments as e " + "left join fetch s.academicAreaClassifications as a " + "left join fetch s.posMajors as mj " + "left join fetch s.waitlists as w " + "left join fetch s.groups as g " + "where cr.courseOffering.instructionalOffering.uniqueId = :offeringId") .setLong("offeringId", offeringId) .list()) { newStudents.put(student.getUniqueId(), student); } for (org.unitime.timetable.model.Student student : (List<org.unitime.timetable.model.Student>) helper .getHibSession() .createQuery( "select distinct s from Student s " + "left join fetch s.courseDemands as cd " + "left join fetch cd.courseRequests as cr " + "left join fetch cr.courseOffering as co " + "left join fetch cr.classWaitLists as cwl " + "left join fetch s.classEnrollments as e " + "left join fetch s.academicAreaClassifications as a " + "left join fetch s.posMajors as mj " + "left join fetch s.waitlists as w " + "left join fetch s.groups as g " + "where e.courseOffering.instructionalOffering.uniqueId = :offeringId and e.courseRequest is null") .setLong("offeringId", offeringId) .list()) { newStudents.put(student.getUniqueId(), student); } // Persist expected spaces if needed if (server.needPersistExpectedSpaces(offeringId)) PersistExpectedSpacesAction.persistExpectedSpaces(offeringId, false, server, helper); // Existing offering XOffering oldOffering = server.getOffering(offeringId); XEnrollments oldEnrollments = server.getEnrollments(offeringId); // New offering XOffering newOffering = null; InstructionalOffering io = InstructionalOfferingDAO.getInstance().get(offeringId, helper.getHibSession()); List<XDistribution> distributions = new ArrayList<XDistribution>(); if (io != null) { // Load linked sections and ignore student conflict constraints List<DistributionPref> distPrefs = helper .getHibSession() .createQuery( "select distinct p from DistributionPref p inner join p.distributionObjects o, Department d, " + "Class_ c inner join c.schedulingSubpart.instrOfferingConfig.instructionalOffering io " + "where p.distributionType.reference in (:ref1, :ref2) and d.session.uniqueId = :sessionId " + "and io.uniqueId = :offeringId and (o.prefGroup = c or o.prefGroup = c.schedulingSubpart) " + "and p.owner = d and p.prefLevel.prefProlog = :pref") .setString("ref1", GroupConstraint.ConstraintType.LINKED_SECTIONS.reference()) .setString("ref2", IgnoreStudentConflictsConstraint.REFERENCE) .setString("pref", PreferenceLevel.sRequired) .setLong("sessionId", server.getAcademicSession().getUniqueId()) .setLong("offeringId", offeringId) .list(); if (!distPrefs.isEmpty()) { for (DistributionPref pref : distPrefs) { int variant = 0; for (Collection<Class_> sections : ReloadAllData.getSections(pref)) { XDistributionType type = XDistributionType.IngoreConflicts; if (GroupConstraint.ConstraintType.LINKED_SECTIONS .reference() .equals(pref.getDistributionType().getReference())) type = XDistributionType.LinkedSections; XDistribution distribution = new XDistribution(type, pref.getUniqueId(), variant++, sections); distributions.add(distribution); } } } newOffering = ReloadAllData.loadOffering(io, distributions, server, helper); if (newOffering != null) server.update(newOffering); else if (oldOffering != null) server.remove(oldOffering); // Load sectioning info List<Object[]> infos = helper .getHibSession() .createQuery( "select i.clazz.uniqueId, i.nbrExpectedStudents from SectioningInfo i where i.clazz.schedulingSubpart.instrOfferingConfig.instructionalOffering.uniqueId = :offeringId") .setLong("offeringId", offeringId) .list(); XExpectations expectations = new XExpectations(offeringId); for (Object[] info : infos) { Long sectionId = (Long) info[0]; Double expected = (Double) info[1]; expectations.setExpectedSpace(sectionId, expected); } server.update(expectations); } else if (oldOffering != null) { server.remove(oldOffering); } List<XStudent[]> students = new ArrayList<XStudent[]>(); if (oldEnrollments != null) { Set<Long> checked = new HashSet<Long>(); for (XRequest old : oldEnrollments.getRequests()) { if (!checked.add(old.getStudentId())) continue; XStudent oldStudent = server.getStudent(old.getStudentId()); org.unitime.timetable.model.Student student = newStudents.get(oldStudent.getStudentId()); if (student == null) student = StudentDAO.getInstance().get(oldStudent.getStudentId(), helper.getHibSession()); XStudent newStudent = (student == null ? null : ReloadAllData.loadStudent(student, null, server, helper)); if (newStudent != null) server.update(newStudent, true); else server.remove(oldStudent); students.add(new XStudent[] {oldStudent, newStudent}); newStudents.remove(oldStudent.getStudentId()); } } for (org.unitime.timetable.model.Student student : newStudents.values()) { XStudent oldStudent = server.getStudent(student.getUniqueId()); XStudent newStudent = ReloadAllData.loadStudent(student, null, server, helper); if (newStudent != null) server.update(newStudent, true); else if (oldStudent != null) server.remove(oldStudent); students.add(new XStudent[] {oldStudent, newStudent}); } if (!server.getAcademicSession().isSectioningEnabled()) return; if (!CustomStudentEnrollmentHolder.isAllowWaitListing()) return; if (newOffering == null && oldOffering == null) return; Set<SectioningRequest> queue = new TreeSet<SectioningRequest>(); Set<XCourseId> courseIds = new HashSet<XCourseId>(); if (newOffering != null) courseIds.addAll(newOffering.getCourses()); if (oldOffering != null) courseIds.addAll(oldOffering.getCourses()); for (XCourseId course : courseIds) { for (XStudent[] student : students) { if (student[0] == null && student[1] == null) continue; XEnrollment oldEnrollment = null; XCourseRequest oldRequest = null; if (student[0] != null) { for (XRequest r : student[0].getRequests()) if (r instanceof XCourseRequest) { XCourseRequest cr = (XCourseRequest) r; for (XCourseId c : cr.getCourseIds()) { if (c.equals(course)) { oldRequest = cr; if (cr.getEnrollment() != null && offeringId.equals(cr.getEnrollment().getOfferingId())) oldEnrollment = cr.getEnrollment(); break; } } } } XCourseRequest newRequest = null; XEnrollment newEnrollment = null; if (student[1] != null) { for (XRequest r : student[1].getRequests()) if (r instanceof XCourseRequest) { XCourseRequest cr = (XCourseRequest) r; for (XCourseId c : cr.getCourseIds()) if (c.equals(course)) { newRequest = cr; if (cr.getEnrollment() != null && offeringId.equals(cr.getEnrollment().getOfferingId())) newEnrollment = cr.getEnrollment(); break; } } } if (oldRequest == null && newRequest == null) continue; OnlineSectioningLog.Action.Builder action = helper.addAction(this, server.getAcademicSession()); action.setStudent( OnlineSectioningLog.Entity.newBuilder() .setUniqueId( student[0] == null ? student[1].getStudentId() : student[0].getStudentId()) .setExternalId( student[0] == null ? student[1].getExternalId() : student[0].getExternalId())); action.addOther( OnlineSectioningLog.Entity.newBuilder() .setUniqueId(offeringId) .setName(newOffering == null ? oldOffering.getName() : newOffering.getName()) .setType(OnlineSectioningLog.Entity.EntityType.OFFERING)); action.addOther( OnlineSectioningLog.Entity.newBuilder() .setUniqueId(course.getCourseId()) .setName(course.getCourseName()) .setType(OnlineSectioningLog.Entity.EntityType.COURSE)); if (oldEnrollment != null) { OnlineSectioningLog.Enrollment.Builder enrollment = OnlineSectioningLog.Enrollment.newBuilder(); enrollment.setType(OnlineSectioningLog.Enrollment.EnrollmentType.PREVIOUS); for (Long sectionId : oldEnrollment.getSectionIds()) enrollment.addSection( OnlineSectioningHelper.toProto(oldOffering.getSection(sectionId), oldEnrollment)); action.addEnrollment(enrollment); if (newRequest == null) action.addRequest(OnlineSectioningHelper.toProto(oldRequest)); } if (newRequest == null) { // nothing to re-assign if (oldEnrollment != null && CustomStudentEnrollmentHolder.hasProvider()) { // there was a drop try { CustomStudentEnrollmentHolder.getProvider() .resection( server, helper, new SectioningRequest(newOffering, newRequest, student[1], action) .setOldOffering(oldOffering) .setOldStudent(student[0]) .setOldRequest(oldRequest) .setLastEnrollment(oldEnrollment), null); } catch (Exception ex) { action.setResult(OnlineSectioningLog.Action.ResultType.FAILURE); action.addMessage( OnlineSectioningLog.Message.newBuilder() .setLevel(OnlineSectioningLog.Message.Level.FATAL) .setText(ex.getMessage() == null ? "null" : ex.getMessage())); helper.error("Unable to resection student: " + ex.getMessage(), ex); } } action.setEndTime(System.currentTimeMillis()); server.execute( server .createAction(NotifyStudentAction.class) .forStudent( student[0] == null ? student[1].getStudentId() : student[0].getStudentId()) .oldEnrollment(oldOffering, course, oldEnrollment), helper.getUser()); continue; } else { action.addRequest(OnlineSectioningHelper.toProto(newRequest)); } if (oldEnrollment == null && newEnrollment == null) { if (student[1].canAssign(newRequest) && isWaitListed(student[1], newRequest, server, helper)) queue.add( new SectioningRequest(newOffering, newRequest, student[1], action) .setOldOffering(oldOffering) .setOldRequest(oldRequest) .setOldStudent(student[0])); continue; } if (newEnrollment != null) { // new enrollment is valid and / or has all the same times if (check( newOffering, course, distributions, student[1], newEnrollment, server)) { // || isSame(oldEnrollment, newEnrollment)) { OnlineSectioningLog.Enrollment.Builder enrollment = OnlineSectioningLog.Enrollment.newBuilder(); enrollment.setType(OnlineSectioningLog.Enrollment.EnrollmentType.STORED); for (XSection assignment : newOffering.getSections(newEnrollment)) enrollment.addSection(OnlineSectioningHelper.toProto(assignment, newEnrollment)); action.addEnrollment(enrollment); // there may have been a change if (CustomStudentEnrollmentHolder.hasProvider()) { try { CustomStudentEnrollmentHolder.getProvider() .resection( server, helper, new SectioningRequest(newOffering, newRequest, student[1], action) .setOldOffering(oldOffering) .setOldStudent(student[0]) .setOldRequest(oldRequest) .setLastEnrollment(oldEnrollment), newEnrollment); } catch (Exception ex) { action.setResult(OnlineSectioningLog.Action.ResultType.FAILURE); action.addMessage( OnlineSectioningLog.Message.newBuilder() .setLevel(OnlineSectioningLog.Message.Level.FATAL) .setText(ex.getMessage() == null ? "null" : ex.getMessage())); helper.error("Unable to resection student: " + ex.getMessage(), ex); } } action.setEndTime(System.currentTimeMillis()); if (!isVerySame( newEnrollment.getCourseId(), newOffering.getSections(newEnrollment), oldOffering.getSections(oldEnrollment))) server.execute( server .createAction(NotifyStudentAction.class) .forStudent( student[0] == null ? student[1].getStudentId() : student[0].getStudentId()) .oldEnrollment(oldOffering, course, oldEnrollment), helper.getUser()); continue; } } newRequest = server.assign(newRequest, null); queue.add( new SectioningRequest(newOffering, newRequest, student[1], action) .setOldOffering(oldOffering) .setOldRequest(oldRequest) .setOldStudent(student[0]) .setLastEnrollment(oldEnrollment) .setNewEnrollment(newEnrollment)); } } if (!queue.isEmpty()) { DataProperties properties = new DataProperties(); ResectioningWeights w = new ResectioningWeights(properties); DistanceConflict dc = new DistanceConflict(server.getDistanceMetric(), properties); TimeOverlapsCounter toc = new TimeOverlapsCounter(null, properties); Date ts = new Date(); for (SectioningRequest r : queue) { helper.debug( "Resectioning " + r.getRequest() + " (was " + (r.getLastEnrollment() == null ? "not assigned" : r.getLastEnrollment().getSectionIds()) + ")"); long c0 = OnlineSectioningHelper.getCpuTime(); XEnrollment e = r.resection(server, w, dc, toc); if (e != null) { e.setTimeStamp(ts); OnlineSectioningLog.Enrollment.Builder enrollment = OnlineSectioningLog.Enrollment.newBuilder(); enrollment.setType(OnlineSectioningLog.Enrollment.EnrollmentType.STORED); for (Long sectionId : e.getSectionIds()) enrollment.addSection( OnlineSectioningHelper.toProto(newOffering.getSection(sectionId), e)); r.getAction().addEnrollment(enrollment); } if (CustomStudentEnrollmentHolder.hasProvider()) { try { e = CustomStudentEnrollmentHolder.getProvider().resection(server, helper, r, e); } catch (Exception ex) { r.getAction().setResult(OnlineSectioningLog.Action.ResultType.FAILURE); r.getAction() .addMessage( OnlineSectioningLog.Message.newBuilder() .setLevel(OnlineSectioningLog.Message.Level.FATAL) .setText(ex.getMessage() == null ? "null" : ex.getMessage())); helper.error("Unable to resection student: " + ex.getMessage(), ex); if (r.getNewEnrollment() != null) server.assign(r.getRequest(), r.getNewEnrollment()); continue; } } if (e == null && r.getLastEnrollment() == null) { // remained unassigned continue; } if (e != null) { r.setRequest(server.assign(r.getRequest(), e)); } helper.debug("New: " + (e == null ? "not assigned" : e.getSectionIds())); org.unitime.timetable.model.Student student = StudentDAO.getInstance().get(r.getRequest().getStudentId(), helper.getHibSession()); Map<Long, StudentClassEnrollment> enrollmentMap = new HashMap<Long, StudentClassEnrollment>(); String approvedBy = null; Date approvedDate = null; for (Iterator<StudentClassEnrollment> i = student.getClassEnrollments().iterator(); i.hasNext(); ) { StudentClassEnrollment enrl = i.next(); if ((enrl.getCourseRequest() != null && enrl.getCourseRequest() .getCourseDemand() .getUniqueId() .equals(r.getRequest().getRequestId())) || (enrl.getCourseOffering() != null && enrl.getCourseOffering() .getUniqueId() .equals(r.getCourseId().getCourseId()))) { helper.debug("Deleting " + enrl.getClazz().getClassLabel()); enrollmentMap.put(enrl.getClazz().getUniqueId(), enrl); if (approvedBy == null && enrl.getApprovedBy() != null) { approvedBy = enrl.getApprovedBy(); approvedDate = enrl.getApprovedDate(); } enrl.getClazz().getStudentEnrollments().remove(enrl); helper.getHibSession().delete(enrl); i.remove(); } } CourseDemand cd = null; demands: for (CourseDemand x : student.getCourseDemands()) for (org.unitime.timetable.model.CourseRequest q : x.getCourseRequests()) if (q.getCourseOffering().getInstructionalOffering().getUniqueId().equals(offeringId)) { cd = x; break demands; } if (r.getRequest().getEnrollment() != null) { // save enrollment org.unitime.timetable.model.CourseRequest cr = null; CourseOffering co = null; if (co == null) for (CourseOffering x : io.getCourseOfferings()) if (x.getUniqueId().equals(r.getRequest().getEnrollment().getCourseId())) co = x; for (Long sectionId : r.getRequest().getEnrollment().getSectionIds()) { Class_ clazz = Class_DAO.getInstance().get(sectionId, helper.getHibSession()); if (cd != null && cr == null) { for (org.unitime.timetable.model.CourseRequest x : cd.getCourseRequests()) if (x.getCourseOffering() .getInstructionalOffering() .getUniqueId() .equals(offeringId)) { cr = x; break; } } if (co == null) co = clazz .getSchedulingSubpart() .getInstrOfferingConfig() .getInstructionalOffering() .getControllingCourseOffering(); StudentClassEnrollment enrl = new StudentClassEnrollment(); enrl.setClazz(clazz); clazz.getStudentEnrollments().add(enrl); enrl.setCourseOffering(co); enrl.setCourseRequest(cr); StudentClassEnrollment old = enrollmentMap.get(sectionId); enrl.setTimestamp(old != null ? old.getTimestamp() : ts); enrl.setChangedBy( old != null ? old.getChangedBy() : helper.getUser() == null ? StudentClassEnrollment.SystemChange.SYSTEM.toString() : helper.getUser().getExternalId()); enrl.setStudent(student); enrl.setApprovedBy(approvedBy); enrl.setApprovedDate(approvedDate); student.getClassEnrollments().add(enrl); /* if (cr != null) { if (cr.getClassEnrollments() == null) cr.setClassEnrollments(new HashSet<StudentClassEnrollment>()); cr.getClassEnrollments().add(enrl); } */ helper.debug("Adding " + enrl.getClazz().getClassLabel()); } } else if (!r.getRequest().isAlternative()) { // wait-list if (cd != null && !cd.isWaitlist()) { cd.setWaitlist(true); helper.getHibSession().saveOrUpdate(cd); } if (!r.getRequest().isWaitlist()) r.setRequest(server.waitlist(r.getRequest(), true)); } helper.getHibSession().save(student); EnrollStudent.updateSpace( server, r.getRequest().getEnrollment() == null ? null : SectioningRequest.convert( r.getStudent(), r.getRequest(), server, newOffering, r.getRequest().getEnrollment()), r.getLastEnrollment() == null ? null : SectioningRequest.convert( r.getOldStudent(), r.getOldRequest(), server, oldOffering, r.getLastEnrollment()), newOffering, oldOffering); server.persistExpectedSpaces(offeringId); server.execute( server .createAction(NotifyStudentAction.class) .forStudent(r.getRequest().getStudentId()) .oldEnrollment(oldOffering, r.getCourseId(), r.getLastEnrollment()), helper.getUser()); r.getAction() .setResult( e == null ? OnlineSectioningLog.Action.ResultType.NULL : OnlineSectioningLog.Action.ResultType.SUCCESS); r.getAction().setCpuTime(OnlineSectioningHelper.getCpuTime() - c0); r.getAction().setEndTime(System.currentTimeMillis()); } } }