@Override
public GwtRpcResponseList<Enrollment> execute(
EventEnrollmentsRpcRequest request, EventContext context) {
if (request.hasRelatedObjects()) {
context.checkPermission(Right.EventAddCourseRelated);
Map<Long, List<Meeting>> conflicts = null;
HashSet<StudentClassEnrollment> enrollments = new HashSet<StudentClassEnrollment>();
for (RelatedObjectInterface related : request.getRelatedObjects()) {
enrollments.addAll(getStudentClassEnrollments(related));
if (request.hasMeetings()) {
conflicts = new HashMap<Long, List<Meeting>>();
for (MeetingInterface meeting : request.getMeetings())
if (meeting.getApprovalStatus() == ApprovalStatus.Approved
|| meeting.getApprovalStatus() == ApprovalStatus.Pending)
computeConflicts(conflicts, meeting, related, request.getEventId());
}
}
return convert(
enrollments,
conflicts,
context.hasPermission(Right.EnrollmentsShowExternalId),
context.hasPermission(Right.CourseRequests),
context.hasPermission(Right.SchedulingAssistant));
} else if (request.hasEventId()) {
org.hibernate.Session hibSession = EventDAO.getInstance().getSession();
Event event = EventDAO.getInstance().get(request.getEventId());
if (event == null) {
if (request.getEventId() < 0) {
Class_ clazz = Class_DAO.getInstance().get(-request.getEventId());
if (clazz != null) {
context.checkPermission(clazz, Right.ClassDetail);
Collection<StudentClassEnrollment> enrollments = clazz.getStudentEnrollments();
if (enrollments == null || enrollments.isEmpty()) return null;
return convert(
enrollments,
null,
context.hasPermission(Right.EnrollmentsShowExternalId),
context.hasPermission(Right.CourseRequests),
context.hasPermission(Right.SchedulingAssistant));
}
}
throw new GwtRpcException(MESSAGES.errorBadEventId());
}
context.checkPermission(event, Right.EventDetail);
Collection<StudentClassEnrollment> enrollments = event.getStudentClassEnrollments();
if (enrollments == null || enrollments.isEmpty()) return null;
if (Event.sEventTypeClass == event.getEventType()) {
return convert(
enrollments,
computeConflicts(
event instanceof ClassEvent
? (ClassEvent) event
: ClassEventDAO.getInstance().get(event.getUniqueId(), hibSession)),
context.hasPermission(Right.EnrollmentsShowExternalId),
context.hasPermission(Right.CourseRequests),
context.hasPermission(Right.SchedulingAssistant));
} else if (Event.sEventTypeFinalExam == event.getEventType()
|| Event.sEventTypeMidtermExam == event.getEventType()) {
return convert(
enrollments,
computeConflicts(
event instanceof ExamEvent
? (ExamEvent) event
: ExamEventDAO.getInstance().get(event.getUniqueId(), hibSession)),
context.hasPermission(Right.EnrollmentsShowExternalId),
context.hasPermission(Right.CourseRequests),
context.hasPermission(Right.SchedulingAssistant));
} else if (Event.sEventTypeCourse == event.getEventType()) {
return convert(
enrollments,
computeConflicts(
event instanceof CourseEvent
? (CourseEvent) event
: CourseEventDAO.getInstance().get(event.getUniqueId(), hibSession)),
context.hasPermission(Right.EnrollmentsShowExternalId),
context.hasPermission(Right.CourseRequests),
context.hasPermission(Right.SchedulingAssistant));
}
}
return null;
}
@Override
public SaveOrApproveEventRpcResponse execute(SaveEventRpcRequest request, EventContext context) {
if (request.getEvent().hasContact()
&& (request.getEvent().getContact().getExternalId() == null
|| !request
.getEvent()
.getContact()
.getExternalId()
.equals(context.getUser().getExternalUserId()))) {
switch (request.getEvent().getType()) {
case Special:
case Course:
case Unavailabile:
context.checkPermission(Right.EventLookupContact);
}
}
if (request.getEvent().getId() == null) { // new even
switch (request.getEvent().getType()) {
case Special:
context.checkPermission(Right.EventAddSpecial);
break;
case Course:
context.checkPermission(Right.EventAddCourseRelated);
break;
case Unavailabile:
context.checkPermission(Right.EventAddUnavailable);
break;
default:
throw context.getException();
}
} else { // existing event
context.checkPermission(request.getEvent().getId(), "Event", Right.EventEdit);
}
// Check main contact email
if (request.getEvent().hasContact() && request.getEvent().getContact().hasEmail()) {
try {
new InternetAddress(request.getEvent().getContact().getEmail(), true);
} catch (AddressException e) {
throw new GwtRpcException(
MESSAGES.badEmailAddress(request.getEvent().getContact().getEmail(), e.getMessage()));
}
}
// Check additional emails
if (request.getEvent().hasEmail()) {
String suffix = ApplicationProperty.EmailDefaultAddressSuffix.value();
for (String address : request.getEvent().getEmail().split("[\n,]")) {
String email = address.trim();
if (email.isEmpty()) continue;
if (suffix != null && email.indexOf('@') < 0) email += suffix;
try {
new InternetAddress(email, true);
} catch (AddressException e) {
throw new GwtRpcException(MESSAGES.badEmailAddress(address, e.getMessage()));
}
}
}
org.hibernate.Session hibSession = SessionDAO.getInstance().getSession();
Transaction tx = hibSession.beginTransaction();
try {
Session session = SessionDAO.getInstance().get(request.getSessionId(), hibSession);
Date now = new Date();
Event event = null;
if (request.getEvent().getId() != null) {
event = EventDAO.getInstance().get(request.getEvent().getId(), hibSession);
} else {
switch (request.getEvent().getType()) {
case Special:
event = new SpecialEvent();
break;
case Course:
event = new CourseEvent();
break;
case Unavailabile:
event = new UnavailableEvent();
break;
default:
throw new GwtRpcException(
MESSAGES.failedSaveEventWrongType(request.getEvent().getType().getName(CONSTANTS)));
}
}
SaveOrApproveEventRpcResponse response = new SaveOrApproveEventRpcResponse();
event.setEventName(request.getEvent().getName());
if (event.getEventName() == null
|| event.getEventName().isEmpty()
&& request.getEvent().getType() == EventType.Unavailabile)
event.setEventName(MESSAGES.unavailableEventDefaultName());
event.setEmail(request.getEvent().getEmail());
if (context.hasPermission(Right.EventSetExpiration) || event.getExpirationDate() != null)
event.setExpirationDate(request.getEvent().getExpirationDate());
event.setSponsoringOrganization(
request.getEvent().hasSponsor()
? SponsoringOrganizationDAO.getInstance()
.get(request.getEvent().getSponsor().getUniqueId())
: null);
if (event instanceof UnavailableEvent) {
} else if (event instanceof SpecialEvent) {
event.setMinCapacity(request.getEvent().getMaxCapacity());
event.setMaxCapacity(request.getEvent().getMaxCapacity());
}
if (event.getAdditionalContacts() == null) {
event.setAdditionalContacts(new HashSet<EventContact>());
}
if (context.hasPermission(Right.EventLookupContact)) {
Set<EventContact> existingContacts =
new HashSet<EventContact>(event.getAdditionalContacts());
event.getAdditionalContacts().clear();
if (request.getEvent().hasAdditionalContacts())
for (ContactInterface c : request.getEvent().getAdditionalContacts()) {
if (c.getExternalId() == null) continue;
EventContact contact = null;
for (EventContact x : existingContacts)
if (c.getExternalId().equals(x.getExternalUniqueId())) {
contact = x;
break;
}
if (contact == null) {
contact =
(EventContact)
hibSession
.createQuery("from EventContact where externalUniqueId = :externalId")
.setString("externalId", c.getExternalId())
.setMaxResults(1)
.uniqueResult();
}
if (contact == null) {
contact = new EventContact();
contact.setExternalUniqueId(c.getExternalId());
contact.setFirstName(c.getFirstName());
contact.setMiddleName(c.getMiddleName());
contact.setLastName(c.getLastName());
contact.setAcademicTitle(c.getAcademicTitle());
contact.setEmailAddress(c.getEmail());
contact.setPhone(c.getPhone());
hibSession.save(contact);
}
event.getAdditionalContacts().add(contact);
}
}
EventContact main = event.getMainContact();
if (main == null
|| main.getExternalUniqueId() == null
|| !main.getExternalUniqueId().equals(request.getEvent().getContact().getExternalId())) {
main =
(EventContact)
hibSession
.createQuery("from EventContact where externalUniqueId = :externalId")
.setString("externalId", request.getEvent().getContact().getExternalId())
.setMaxResults(1)
.uniqueResult();
if (main == null) {
main = new EventContact();
main.setExternalUniqueId(request.getEvent().getContact().getExternalId());
}
}
main.setFirstName(request.getEvent().getContact().getFirstName());
main.setMiddleName(request.getEvent().getContact().getMiddleName());
main.setLastName(request.getEvent().getContact().getLastName());
main.setAcademicTitle(request.getEvent().getContact().getAcademicTitle());
main.setEmailAddress(request.getEvent().getContact().getEmail());
main.setPhone(request.getEvent().getContact().getPhone());
hibSession.saveOrUpdate(main);
event.setMainContact(main);
if (event.getNotes() == null) event.setNotes(new HashSet<EventNote>());
if (event.getMeetings() == null) event.setMeetings(new HashSet<Meeting>());
Set<Meeting> remove = new HashSet<Meeting>(event.getMeetings());
TreeSet<Meeting> createdMeetings = new TreeSet<Meeting>();
Set<Meeting> cancelledMeetings = new TreeSet<Meeting>();
Set<Meeting> updatedMeetings = new TreeSet<Meeting>();
for (MeetingInterface m : request.getEvent().getMeetings()) {
Meeting meeting = null;
if (m.getApprovalStatus() == ApprovalStatus.Deleted) {
if (!context.hasPermission(meeting, Right.EventMeetingDelete)
&& context.hasPermission(meeting, Right.EventMeetingCancel)) {
// Cannot delete, but can cancel --> cancel the meeting instead
m.setApprovalStatus(ApprovalStatus.Cancelled);
} else {
continue;
}
}
if (m.getId() != null)
for (Iterator<Meeting> i = remove.iterator(); i.hasNext(); ) {
Meeting x = i.next();
if (m.getId().equals(x.getUniqueId())) {
meeting = x;
i.remove();
break;
}
}
if (meeting != null) {
if (m.getApprovalStatus().ordinal() != meeting.getApprovalStatus()) {
switch (m.getApprovalStatus()) {
case Cancelled:
switch (meeting.getEvent().getEventType()) {
case Event.sEventTypeFinalExam:
case Event.sEventTypeMidtermExam:
if (!context.hasPermission(meeting, Right.EventMeetingCancelExam))
throw new GwtRpcException(
MESSAGES.failedApproveEventNoRightsToCancel(toString(meeting)));
break;
case Event.sEventTypeClass:
if (!context.hasPermission(meeting, Right.EventMeetingCancelClass))
throw new GwtRpcException(
MESSAGES.failedApproveEventNoRightsToCancel(toString(meeting)));
break;
default:
if (!context.hasPermission(meeting, Right.EventMeetingCancel))
throw new GwtRpcException(
MESSAGES.failedApproveEventNoRightsToCancel(toString(meeting)));
break;
}
meeting.setStatus(Meeting.Status.CANCELLED);
meeting.setApprovalDate(now);
hibSession.update(meeting);
cancelledMeetings.add(meeting);
response.addCancelledMeeting(m);
}
} else {
if (m.getStartOffset()
!= (meeting.getStartOffset() == null ? 0 : meeting.getStartOffset())
|| m.getEndOffset()
!= (meeting.getStopOffset() == null ? 0 : meeting.getStopOffset())) {
if (!context.hasPermission(meeting, Right.EventMeetingEdit))
throw new GwtRpcException(
MESSAGES.failedSaveEventCanNotEditMeeting(toString(meeting)));
meeting.setStartOffset(m.getStartOffset());
meeting.setStopOffset(m.getEndOffset());
hibSession.update(meeting);
response.addUpdatedMeeting(m);
updatedMeetings.add(meeting);
}
}
} else {
response.addCreatedMeeting(m);
meeting = new Meeting();
meeting.setEvent(event);
Location location = null;
if (m.hasLocation()) {
if (m.getLocation().getId() != null)
location = LocationDAO.getInstance().get(m.getLocation().getId(), hibSession);
else if (m.getLocation().getName() != null)
location =
Location.findByName(
hibSession, request.getSessionId(), m.getLocation().getName());
}
if (location == null)
throw new GwtRpcException(MESSAGES.failedSaveEventNoLocation(toString(m)));
meeting.setLocationPermanentId(location.getPermanentId());
meeting.setStatus(Meeting.Status.PENDING);
meeting.setApprovalDate(null);
if (!context.hasPermission(location, Right.EventLocation))
throw new GwtRpcException(MESSAGES.failedSaveEventWrongLocation(m.getLocationName()));
if (request.getEvent().getType() == EventType.Unavailabile
&& !context.hasPermission(location, Right.EventLocationUnavailable))
throw new GwtRpcException(
MESSAGES.failedSaveCannotMakeUnavailable(m.getLocationName()));
if (m.getApprovalStatus() == ApprovalStatus.Approved
&& context.hasPermission(location, Right.EventLocationApprove)) {
meeting.setStatus(Meeting.Status.APPROVED);
meeting.setApprovalDate(now);
}
if (context.isPastOrOutside(m.getMeetingDate()))
throw new GwtRpcException(
MESSAGES.failedSaveEventPastOrOutside(getDateFormat().format(m.getMeetingDate())));
if (!context.hasPermission(location, Right.EventLocationOverbook)) {
List<MeetingConflictInterface> conflicts =
computeConflicts(hibSession, m, event.getUniqueId());
if (!conflicts.isEmpty())
throw new GwtRpcException(
MESSAGES.failedSaveEventConflict(toString(m), toString(conflicts.get(0))));
}
m.setApprovalDate(meeting.getApprovalDate());
m.setApprovalStatus(meeting.getApprovalStatus());
meeting.setStartPeriod(m.getStartSlot());
meeting.setStopPeriod(m.getEndSlot());
meeting.setStartOffset(m.getStartOffset());
meeting.setStopOffset(m.getEndOffset());
meeting.setClassCanOverride(true);
meeting.setMeetingDate(m.getMeetingDate());
event.getMeetings().add(meeting);
createdMeetings.add(meeting);
}
// automatic approval
if (meeting.getApprovalDate() == null) {
switch (request.getEvent().getType()) {
case Unavailabile:
case Class:
case FinalExam:
case MidtermExam:
meeting.setStatus(Meeting.Status.APPROVED);
meeting.setApprovalDate(now);
break;
}
}
}
if (!remove.isEmpty()) {
for (Iterator<Meeting> i = remove.iterator(); i.hasNext(); ) {
Meeting m = i.next();
if (!context.hasPermission(m, Right.EventMeetingDelete)) {
if (m.getStatus() == Status.CANCELLED || m.getStatus() == Status.REJECTED) {
i.remove();
continue;
}
throw new GwtRpcException(MESSAGES.failedSaveEventCanNotDeleteMeeting(toString(m)));
}
MeetingInterface meeting = new MeetingInterface();
meeting.setId(m.getUniqueId());
meeting.setMeetingDate(m.getMeetingDate());
meeting.setDayOfWeek(Constants.getDayOfWeek(m.getMeetingDate()));
meeting.setStartTime(m.getStartTime().getTime());
meeting.setStopTime(m.getStopTime().getTime());
meeting.setDayOfYear(
CalendarUtils.date2dayOfYear(session.getSessionStartYear(), m.getMeetingDate()));
meeting.setStartSlot(m.getStartPeriod());
meeting.setEndSlot(m.getStopPeriod());
meeting.setStartOffset(m.getStartOffset() == null ? 0 : m.getStartOffset());
meeting.setEndOffset(m.getStopOffset() == null ? 0 : m.getStopOffset());
meeting.setPast(context.isPastOrOutside(m.getStartTime()));
meeting.setApprovalDate(m.getApprovalDate());
meeting.setApprovalStatus(m.getApprovalStatus());
if (m.getLocation() != null) {
ResourceInterface location = new ResourceInterface();
location.setType(ResourceType.ROOM);
location.setId(m.getLocation().getUniqueId());
location.setName(m.getLocation().getLabel());
location.setSize(m.getLocation().getCapacity());
location.setRoomType(m.getLocation().getRoomTypeLabel());
location.setBreakTime(m.getLocation().getEffectiveBreakTime());
location.setMessage(m.getLocation().getEventMessage());
location.setIgnoreRoomCheck(m.getLocation().isIgnoreRoomCheck());
meeting.setLocation(location);
}
response.addDeletedMeeting(meeting);
}
event.getMeetings().removeAll(remove);
}
EventInterface.DateFormatter df =
new EventInterface.DateFormatter() {
Formats.Format<Date> dfShort = Formats.getDateFormat(Formats.Pattern.DATE_EVENT_SHORT);
Formats.Format<Date> dfLong = Formats.getDateFormat(Formats.Pattern.DATE_EVENT_LONG);
@Override
public String formatFirstDate(Date date) {
return dfShort.format(date);
}
@Override
public String formatLastDate(Date date) {
return dfLong.format(date);
}
};
FileItem attachment = (FileItem) context.getAttribute(UploadServlet.SESSION_LAST_FILE);
boolean attached = false;
if (response.hasCreatedMeetings()) {
EventNote note = new EventNote();
note.setEvent(event);
note.setNoteType(
event.getUniqueId() == null
? EventNote.sEventNoteTypeCreateEvent
: EventNote.sEventNoteTypeAddMeetings);
note.setTimeStamp(now);
note.setUser(context.getUser().getTrueName());
note.setUserId(context.getUser().getTrueExternalUserId());
if (request.hasMessage()) note.setTextNote(request.getMessage());
note.setMeetings(
EventInterface.toString(response.getCreatedMeetings(), CONSTANTS, "\n", df));
note.setAffectedMeetings(createdMeetings);
event.getNotes().add(note);
NoteInterface n = new NoteInterface();
n.setDate(now);
n.setMeetings(note.getMeetings());
n.setUser(context.getUser().getTrueName());
n.setType(NoteInterface.NoteType.values()[note.getNoteType()]);
n.setNote(note.getTextNote());
if (attachment != null) {
note.setAttachedName(attachment.getName());
note.setAttachedFile(attachment.get());
note.setAttachedContentType(attachment.getContentType());
attached = true;
n.setAttachment(attachment.getName());
}
response.addNote(n);
}
if (response.hasUpdatedMeetings()
|| (!response.hasCreatedMeetings()
&& !response.hasDeletedMeetings()
&& !response.hasCancelledMeetings())) {
EventNote note = new EventNote();
note.setEvent(event);
note.setNoteType(EventNote.sEventNoteTypeEditEvent);
note.setTimeStamp(now);
note.setUser(context.getUser().getTrueName());
note.setUserId(context.getUser().getTrueExternalUserId());
note.setAffectedMeetings(updatedMeetings);
if (request.hasMessage()) note.setTextNote(request.getMessage());
if (response.hasUpdatedMeetings())
note.setMeetings(
EventInterface.toString(response.getUpdatedMeetings(), CONSTANTS, "\n", df));
event.getNotes().add(note);
NoteInterface n = new NoteInterface();
n.setDate(now);
n.setMeetings(note.getMeetings());
n.setUser(context.getUser().getTrueName());
n.setType(NoteInterface.NoteType.values()[note.getNoteType()]);
n.setNote(note.getTextNote());
if (attachment != null && !attached) {
note.setAttachedName(attachment.getName());
note.setAttachedFile(attachment.get());
note.setAttachedContentType(attachment.getContentType());
attached = true;
n.setAttachment(attachment.getName());
}
response.addNote(n);
}
if (response.hasDeletedMeetings()) {
EventNote note = new EventNote();
note.setEvent(event);
note.setNoteType(EventNote.sEventNoteTypeDeletion);
note.setTimeStamp(now);
note.setUser(context.getUser().getTrueName());
note.setUserId(context.getUser().getTrueExternalUserId());
if (request.hasMessage()) note.setTextNote(request.getMessage());
note.setMeetings(
EventInterface.toString(response.getDeletedMeetings(), CONSTANTS, "\n", df));
event.getNotes().add(note);
NoteInterface n = new NoteInterface();
n.setDate(now);
n.setMeetings(note.getMeetings());
n.setUser(context.getUser().getTrueName());
n.setType(NoteInterface.NoteType.values()[note.getNoteType()]);
n.setNote(note.getTextNote());
if (attachment != null && !attached) {
note.setAttachedName(attachment.getName());
note.setAttachedFile(attachment.get());
note.setAttachedContentType(attachment.getContentType());
attached = true;
n.setAttachment(attachment.getName());
}
response.addNote(n);
}
if (response.hasCancelledMeetings()) {
EventNote note = new EventNote();
note.setEvent(event);
note.setNoteType(EventNote.sEventNoteTypeCancel);
note.setTimeStamp(now);
note.setUser(context.getUser().getTrueName());
note.setUserId(context.getUser().getTrueExternalUserId());
note.setAffectedMeetings(cancelledMeetings);
if (request.hasMessage()) note.setTextNote(request.getMessage());
note.setMeetings(
EventInterface.toString(response.getCancelledMeetings(), CONSTANTS, "\n", df));
event.getNotes().add(note);
NoteInterface n = new NoteInterface();
n.setDate(now);
n.setMeetings(note.getMeetings());
n.setUser(context.getUser().getTrueName());
n.setType(NoteInterface.NoteType.values()[note.getNoteType()]);
n.setNote(note.getTextNote());
if (attachment != null && !attached) {
note.setAttachedName(attachment.getName());
note.setAttachedFile(attachment.get());
note.setAttachedContentType(attachment.getContentType());
attached = true;
n.setAttachment(attachment.getName());
}
response.addNote(n);
}
if (request.getEvent().getType() == EventType.Course) {
CourseEvent ce = (CourseEvent) event;
ce.setReqAttendance(request.getEvent().hasRequiredAttendance());
if (ce.getRelatedCourses() == null) ce.setRelatedCourses(new HashSet<RelatedCourseInfo>());
else ce.getRelatedCourses().clear();
if (request.getEvent().hasRelatedObjects())
for (RelatedObjectInterface r : request.getEvent().getRelatedObjects()) {
RelatedCourseInfo related = new RelatedCourseInfo();
related.setEvent(ce);
if (r.getSelection() != null) {
related.setOwnerId(r.getUniqueId());
related.setOwnerType(r.getType().ordinal());
related.setCourse(
CourseOfferingDAO.getInstance().get(r.getSelection()[1], hibSession));
} else {
switch (r.getType()) {
case Course:
related.setOwner(CourseOfferingDAO.getInstance().get(r.getUniqueId()));
break;
case Class:
related.setOwner(Class_DAO.getInstance().get(r.getUniqueId()));
break;
case Config:
related.setOwner(InstrOfferingConfigDAO.getInstance().get(r.getUniqueId()));
break;
case Offering:
related.setOwner(InstructionalOfferingDAO.getInstance().get(r.getUniqueId()));
break;
}
}
ce.getRelatedCourses().add(related);
}
}
if (event.getUniqueId() == null) {
hibSession.save(event);
response.setEvent(
EventDetailBackend.getEventDetail(
SessionDAO.getInstance().get(request.getSessionId(), hibSession), event, context));
} else if (event.getMeetings().isEmpty()) {
response.setEvent(
EventDetailBackend.getEventDetail(
SessionDAO.getInstance().get(request.getSessionId(), hibSession), event, context));
response.getEvent().setId(null);
hibSession.delete(event);
} else {
hibSession.update(event);
response.setEvent(
EventDetailBackend.getEventDetail(
SessionDAO.getInstance().get(request.getSessionId(), hibSession), event, context));
}
tx.commit();
new EventEmail(request, response).send(context);
return response;
} catch (Exception ex) {
tx.rollback();
if (ex instanceof GwtRpcException) throw (GwtRpcException) ex;
throw new GwtRpcException(ex.getMessage(), ex);
}
}
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());
}
}
}