use of fi.otavanopisto.pyramus.dao.users.PersonVariableKeyDAO in project pyramus by otavanopisto.
the class EditStudentViewController method process.
public void process(PageRequestContext pageRequestContext) {
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
StudentActivityTypeDAO studentActivityTypeDAO = DAOFactory.getInstance().getStudentActivityTypeDAO();
StudentEducationalLevelDAO studentEducationalLevelDAO = DAOFactory.getInstance().getStudentEducationalLevelDAO();
StudentExaminationTypeDAO studentExaminationTypeDAO = DAOFactory.getInstance().getStudentExaminationTypeDAO();
StudentStudyEndReasonDAO studyEndReasonDAO = DAOFactory.getInstance().getStudentStudyEndReasonDAO();
UserVariableKeyDAO userVariableKeyDAO = DAOFactory.getInstance().getUserVariableKeyDAO();
UserVariableDAO userVariableDAO = DAOFactory.getInstance().getUserVariableDAO();
StudyProgrammeDAO studyProgrammeDAO = DAOFactory.getInstance().getStudyProgrammeDAO();
MunicipalityDAO municipalityDAO = DAOFactory.getInstance().getMunicipalityDAO();
NationalityDAO nationalityDAO = DAOFactory.getInstance().getNationalityDAO();
SchoolDAO schoolDAO = DAOFactory.getInstance().getSchoolDAO();
LanguageDAO languageDAO = DAOFactory.getInstance().getLanguageDAO();
ContactTypeDAO contactTypeDAO = DAOFactory.getInstance().getContactTypeDAO();
ContactURLTypeDAO contactURLTypeDAO = DAOFactory.getInstance().getContactURLTypeDAO();
CreditLinkDAO creditLinkDAO = DAOFactory.getInstance().getCreditLinkDAO();
CourseAssessmentDAO courseAssessmentDAO = DAOFactory.getInstance().getCourseAssessmentDAO();
TransferCreditDAO transferCreditDAO = DAOFactory.getInstance().getTransferCreditDAO();
UserIdentificationDAO userIdentificationDAO = DAOFactory.getInstance().getUserIdentificationDAO();
UserDAO userDAO = DAOFactory.getInstance().getUserDAO();
CurriculumDAO curriculumDAO = DAOFactory.getInstance().getCurriculumDAO();
StudentLodgingPeriodDAO studentLodgingPeriodDAO = DAOFactory.getInstance().getStudentLodgingPeriodDAO();
PersonVariableKeyDAO personVariableKeyDAO = DAOFactory.getInstance().getPersonVariableKeyDAO();
PersonVariableDAO personVariableDAO = DAOFactory.getInstance().getPersonVariableDAO();
StudentStudyPeriodDAO studentStudyPeriodDAO = DAOFactory.getInstance().getStudentStudyPeriodDAO();
StaffMemberDAO staffMemberDAO = DAOFactory.getInstance().getStaffMemberDAO();
Locale locale = pageRequestContext.getRequest().getLocale();
User loggedUser = userDAO.findById(pageRequestContext.getLoggedUserId());
Long personId = pageRequestContext.getLong("person");
Person person = personDAO.findById(personId);
List<Student> students = UserUtils.canAccessAllOrganizations(loggedUser) ? studentDAO.listByPerson(person) : studentDAO.listByPersonAndOrganization(person, loggedUser.getOrganization());
Collections.sort(students, new Comparator<Student>() {
@Override
public int compare(Student o1, Student o2) {
/**
* Ordering study programmes as follows
* 1. studies that have start date but no end date (ongoing)
* 2. studies that have no start nor end date
* 3. studies that have ended
* 4. studies that are archived
* 5. other
*/
int o1class = (o1.getArchived()) ? 4 : (o1.getStudyStartDate() != null && o1.getStudyEndDate() == null) ? 1 : (o1.getStudyStartDate() == null && o1.getStudyEndDate() == null) ? 2 : (o1.getStudyEndDate() != null) ? 3 : 5;
int o2class = (o2.getArchived()) ? 4 : (o2.getStudyStartDate() != null && o2.getStudyEndDate() == null) ? 1 : (o2.getStudyStartDate() == null && o2.getStudyEndDate() == null) ? 2 : (o2.getStudyEndDate() != null) ? 3 : 5;
if (o1class == o2class) {
// classes are the same, we try to do last comparison from the start dates
return ((o1.getStudyStartDate() != null) && (o2.getStudyStartDate() != null)) ? o2.getStudyStartDate().compareTo(o1.getStudyStartDate()) : 0;
} else
return o1class < o2class ? -1 : o1class == o2class ? 0 : 1;
}
});
Map<Long, String> studentTags = new HashMap<>();
Map<Long, Boolean> studentHasCredits = new HashMap<>();
List<UserVariableKey> userVariableKeys = userVariableKeyDAO.listByUserEditable(Boolean.TRUE);
Collections.sort(userVariableKeys, new StringAttributeComparator("getVariableName"));
JSONObject studentLodgingPeriods = new JSONObject();
JSONObject studentStudyPeriodsJSON = new JSONObject();
for (Student student : students) {
StringBuilder tagsBuilder = new StringBuilder();
Iterator<Tag> tagIterator = student.getTags().iterator();
while (tagIterator.hasNext()) {
Tag tag = tagIterator.next();
tagsBuilder.append(tag.getText());
if (tagIterator.hasNext())
tagsBuilder.append(' ');
}
studentTags.put(student.getId(), tagsBuilder.toString());
studentHasCredits.put(student.getId(), creditLinkDAO.countByStudent(student) + courseAssessmentDAO.countByStudent(student) + transferCreditDAO.countByStudent(student) > 0);
JSONArray variables = new JSONArray();
for (UserVariableKey userVariableKey : userVariableKeys) {
UserVariable userVariable = userVariableDAO.findByUserAndVariableKey(student, userVariableKey);
JSONObject variable = new JSONObject();
variable.put("type", userVariableKey.getVariableType());
variable.put("name", userVariableKey.getVariableName());
variable.put("key", userVariableKey.getVariableKey());
variable.put("value", userVariable != null ? userVariable.getValue() : "");
variables.add(variable);
}
setJsDataVariable(pageRequestContext, "variables." + student.getId(), variables.toString());
List<StudentLodgingPeriod> studentLodgingPeriodEntities = studentLodgingPeriodDAO.listByStudent(student);
studentLodgingPeriodEntities.sort(Comparator.comparing(StudentLodgingPeriod::getBegin, Comparator.nullsLast(Comparator.naturalOrder())));
JSONArray lodgingPeriods = new JSONArray();
for (StudentLodgingPeriod period : studentLodgingPeriodEntities) {
JSONObject periodJSON = new JSONObject();
periodJSON.put("id", period.getId());
periodJSON.put("begin", period.getBegin() != null ? period.getBegin().getTime() : null);
periodJSON.put("end", period.getEnd() != null ? period.getEnd().getTime() : null);
lodgingPeriods.add(periodJSON);
}
if (!lodgingPeriods.isEmpty()) {
studentLodgingPeriods.put(student.getId(), lodgingPeriods);
}
List<StudentStudyPeriod> studyPeriods = studentStudyPeriodDAO.listByStudent(student);
studyPeriods.sort(Comparator.comparing(StudentStudyPeriod::getBegin, Comparator.nullsLast(Comparator.naturalOrder())));
JSONArray studyPeriodsJSON = new JSONArray();
for (StudentStudyPeriod studyPeriod : studyPeriods) {
JSONObject periodJSON = new JSONObject();
periodJSON.put("id", studyPeriod.getId());
periodJSON.put("begin", studyPeriod.getBegin() != null ? studyPeriod.getBegin().getTime() : null);
periodJSON.put("end", studyPeriod.getEnd() != null ? studyPeriod.getEnd().getTime() : null);
periodJSON.put("type", studyPeriod.getPeriodType());
studyPeriodsJSON.add(periodJSON);
}
if (!studyPeriodsJSON.isEmpty()) {
studentStudyPeriodsJSON.put(student.getId(), studyPeriodsJSON);
}
}
setJsDataVariable(pageRequestContext, "studentLodgingPeriods", studentLodgingPeriods.toString());
setJsDataVariable(pageRequestContext, "studentStudyPeriods", studentStudyPeriodsJSON.toString());
List<PersonVariableKey> personVariableKeys = personVariableKeyDAO.listUserEditablePersonVariableKeys();
Collections.sort(personVariableKeys, new StringAttributeComparator("getVariableName"));
JSONArray personVariablesJSON = new JSONArray();
for (PersonVariableKey personVariableKey : personVariableKeys) {
PersonVariable personVariable = personVariableDAO.findByPersonAndVariableKey(person, personVariableKey);
JSONObject personVariableJSON = new JSONObject();
personVariableJSON.put("type", personVariableKey.getVariableType());
personVariableJSON.put("name", personVariableKey.getVariableName());
personVariableJSON.put("key", personVariableKey.getVariableKey());
personVariableJSON.put("value", personVariable != null ? personVariable.getValue() : "");
personVariablesJSON.add(personVariableJSON);
}
setJsDataVariable(pageRequestContext, "personVariables", personVariablesJSON.toString());
List<Nationality> nationalities = nationalityDAO.listUnarchived();
Collections.sort(nationalities, new StringAttributeComparator("getName"));
List<Municipality> municipalities = municipalityDAO.listUnarchived();
Collections.sort(municipalities, new StringAttributeComparator("getName"));
List<Language> languages = languageDAO.listUnarchived();
Collections.sort(languages, new StringAttributeComparator("getName"));
List<School> schools = schoolDAO.listUnarchived();
Collections.sort(schools, new StringAttributeComparator("getName"));
List<ContactURLType> contactURLTypes = contactURLTypeDAO.listUnarchived();
Collections.sort(contactURLTypes, new StringAttributeComparator("getName"));
List<ContactType> contactTypes = contactTypeDAO.listUnarchived();
Collections.sort(contactTypes, new StringAttributeComparator("getName"));
String username = "";
boolean hasInternalAuthenticationStrategies = AuthenticationProviderVault.getInstance().hasInternalStrategies();
if (UserUtils.allowEditCredentials(loggedUser, person)) {
if (hasInternalAuthenticationStrategies) {
// TODO: Support for multiple internal authentication providers
List<InternalAuthenticationProvider> internalAuthenticationProviders = AuthenticationProviderVault.getInstance().getInternalAuthenticationProviders();
if (internalAuthenticationProviders.size() == 1) {
InternalAuthenticationProvider internalAuthenticationProvider = internalAuthenticationProviders.get(0);
if (internalAuthenticationProvider != null) {
UserIdentification userIdentification = userIdentificationDAO.findByAuthSourceAndPerson(internalAuthenticationProvider.getName(), person);
if (internalAuthenticationProvider.canUpdateCredentials()) {
if (userIdentification != null) {
username = internalAuthenticationProvider.getUsername(userIdentification.getExternalId());
}
}
}
}
}
}
JSONArray studentStudyPeriodTypesJSON = new JSONArray();
for (StudentStudyPeriodType studentStudyPeriodType : StudentStudyPeriodType.values()) {
JSONObject studyPeriodType = new JSONObject();
studyPeriodType.put("id", studentStudyPeriodType.toString());
studyPeriodType.put("displayName", Messages.getInstance().getText(locale, String.format("generic.studentStudyPeriods.%s", studentStudyPeriodType)));
studyPeriodType.put("beginOnly", StudentStudyPeriodType.BEGINDATE_ONLY.contains(studentStudyPeriodType));
studentStudyPeriodTypesJSON.add(studyPeriodType);
}
setJsDataVariable(pageRequestContext, "studentStudyPeriodTypes", studentStudyPeriodTypesJSON.toString());
List<Curriculum> curriculums = curriculumDAO.listUnarchived();
Collections.sort(curriculums, new StringAttributeComparator("getName"));
List<StudyProgramme> studyProgrammes = UserUtils.canAccessAllOrganizations(loggedUser) ? studyProgrammeDAO.listUnarchived() : studyProgrammeDAO.listByOrganization(loggedUser.getOrganization(), Archived.UNARCHIVED);
Collections.sort(studyProgrammes, new StringAttributeComparator("getName"));
List<StaffMember> studyApprovers = staffMemberDAO.listByProperty(StaffMemberProperties.STUDY_APPROVER.getKey(), "1");
// Add study approvers to the list that have been used before so the selections can be persisted
List<StaffMember> selectedStudyApprovers = students.stream().map(student -> student.getStudyApprover()).filter(Objects::nonNull).collect(Collectors.toList());
for (StaffMember selectedStudyApprover : selectedStudyApprovers) {
Long selectedStudyApproverId = selectedStudyApprover.getId();
boolean isSelectedInList = studyApprovers.stream().map(StaffMember::getId).anyMatch(selectedStudyApproverId::equals);
if (!isSelectedInList) {
studyApprovers.add(selectedStudyApprover);
}
}
studyApprovers.sort(Comparator.comparing(StaffMember::getLastName).thenComparing(StaffMember::getFirstName));
readUserVariablePresets(pageRequestContext);
pageRequestContext.getRequest().setAttribute("tags", studentTags);
pageRequestContext.getRequest().setAttribute("person", person);
pageRequestContext.getRequest().setAttribute("students", students);
pageRequestContext.getRequest().setAttribute("activityTypes", studentActivityTypeDAO.listUnarchived());
pageRequestContext.getRequest().setAttribute("contactURLTypes", contactURLTypes);
pageRequestContext.getRequest().setAttribute("contactTypes", contactTypes);
pageRequestContext.getRequest().setAttribute("examinationTypes", studentExaminationTypeDAO.listUnarchived());
pageRequestContext.getRequest().setAttribute("educationalLevels", studentEducationalLevelDAO.listUnarchived());
pageRequestContext.getRequest().setAttribute("nationalities", nationalities);
pageRequestContext.getRequest().setAttribute("municipalities", municipalities);
pageRequestContext.getRequest().setAttribute("languages", languages);
pageRequestContext.getRequest().setAttribute("schools", schools);
pageRequestContext.getRequest().setAttribute("studyProgrammes", studyProgrammes);
pageRequestContext.getRequest().setAttribute("curriculums", curriculums);
pageRequestContext.getRequest().setAttribute("studyEndReasons", studyEndReasonDAO.listByParentReason(null));
pageRequestContext.getRequest().setAttribute("variableKeys", userVariableKeys);
pageRequestContext.getRequest().setAttribute("personVariableKeys", personVariableKeys);
pageRequestContext.getRequest().setAttribute("studentHasCredits", studentHasCredits);
pageRequestContext.getRequest().setAttribute("hasInternalAuthenticationStrategies", hasInternalAuthenticationStrategies);
pageRequestContext.getRequest().setAttribute("username", username);
pageRequestContext.getRequest().setAttribute("allowEditCredentials", UserUtils.allowEditCredentials(loggedUser, person));
pageRequestContext.getRequest().setAttribute("studyApprovers", studyApprovers);
pageRequestContext.setIncludeJSP("/templates/students/editstudent.jsp");
}
use of fi.otavanopisto.pyramus.dao.users.PersonVariableKeyDAO in project pyramus by otavanopisto.
the class ViewStudentViewController method process.
/**
* Processes the page request.
*
* In parameters
* - student
* - person
*
* Page parameters
* - student - Student object
* - nationalities - List of Nationality objects
* - municipalities - List of Municipality objects
* - languages - List of Language objects
* - studentCourses - List of CourseStudent objects
* - studentContactEntries - List of StudentContactLogEntry objects
*
* @param pageRequestContext pageRequestContext
*/
public void process(PageRequestContext pageRequestContext) {
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
StudentImageDAO imageDAO = DAOFactory.getInstance().getStudentImageDAO();
StudentContactLogEntryDAO logEntryDAO = DAOFactory.getInstance().getStudentContactLogEntryDAO();
StudentContactLogEntryCommentDAO entryCommentDAO = DAOFactory.getInstance().getStudentContactLogEntryCommentDAO();
StudentGroupDAO studentGroupDAO = DAOFactory.getInstance().getStudentGroupDAO();
CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
StudentProjectDAO studentProjectDAO = DAOFactory.getInstance().getStudentProjectDAO();
CourseAssessmentDAO courseAssessmentDAO = DAOFactory.getInstance().getCourseAssessmentDAO();
TransferCreditDAO transferCreditDAO = DAOFactory.getInstance().getTransferCreditDAO();
ProjectAssessmentDAO projectAssessmentDAO = DAOFactory.getInstance().getProjectAssessmentDAO();
CreditLinkDAO creditLinkDAO = DAOFactory.getInstance().getCreditLinkDAO();
StudentFileDAO studentFileDAO = DAOFactory.getInstance().getStudentFileDAO();
ReportDAO reportDAO = DAOFactory.getInstance().getReportDAO();
CourseAssessmentRequestDAO courseAssessmentRequestDAO = DAOFactory.getInstance().getCourseAssessmentRequestDAO();
StaffMemberDAO staffMemberDAO = DAOFactory.getInstance().getStaffMemberDAO();
CurriculumDAO curriculumDAO = DAOFactory.getInstance().getCurriculumDAO();
UserVariableDAO userVariableDAO = DAOFactory.getInstance().getUserVariableDAO();
StudentLodgingPeriodDAO studentLodgingPeriodDAO = DAOFactory.getInstance().getStudentLodgingPeriodDAO();
PersonVariableDAO personVariableDAO = DAOFactory.getInstance().getPersonVariableDAO();
PersonVariableKeyDAO personVariableKeyDAO = DAOFactory.getInstance().getPersonVariableKeyDAO();
StudentStudyPeriodDAO studentStudyPeriodDAO = DAOFactory.getInstance().getStudentStudyPeriodDAO();
MatriculationExamEnrollmentDAO matriculationExamEnrollmentDAO = DAOFactory.getInstance().getMatriculationExamEnrollmentDAO();
Long loggedUserId = pageRequestContext.getLoggedUserId();
StaffMember loggedUser = staffMemberDAO.findById(loggedUserId);
Long personId = pageRequestContext.getLong("person");
Person person = personDAO.findById(personId);
pageRequestContext.getRequest().setAttribute("person", person);
StaffMember staffMember = staffMemberDAO.findByPerson(person);
pageRequestContext.getRequest().setAttribute("staffMember", staffMember);
List<Student> students = UserUtils.canAccessAllOrganizations(loggedUser) ? studentDAO.listByPerson(person) : studentDAO.listByPersonAndOrganization(person, loggedUser.getOrganization());
Collections.sort(students, new Comparator<Student>() {
@Override
public int compare(Student o1, Student o2) {
/**
* Ordering study programmes as follows
* 1. studies that have start date but no end date (ongoing)
* 2. studies that have no start nor end date
* 3. studies that have ended
* 4. studies that are archived
* 5. other
*/
int o1class = (o1.getArchived()) ? 4 : (o1.getStudyStartDate() != null && o1.getStudyEndDate() == null) ? 1 : (o1.getStudyStartDate() == null && o1.getStudyEndDate() == null) ? 2 : (o1.getStudyEndDate() != null) ? 3 : 5;
int o2class = (o2.getArchived()) ? 4 : (o2.getStudyStartDate() != null && o2.getStudyEndDate() == null) ? 1 : (o2.getStudyStartDate() == null && o2.getStudyEndDate() == null) ? 2 : (o2.getStudyEndDate() != null) ? 3 : 5;
if (o1class == o2class) {
// classes are the same, we try to do last comparison from the start dates
return ((o1.getStudyStartDate() != null) && (o2.getStudyStartDate() != null)) ? o2.getStudyStartDate().compareTo(o1.getStudyStartDate()) : 0;
} else
return o1class < o2class ? -1 : o1class == o2class ? 0 : 1;
}
});
Map<Long, Boolean> studentHasImage = new HashMap<>();
Map<Long, List<CourseStudent>> courseStudents = new HashMap<>();
Map<Long, List<StudentContactLogEntry>> contactEntries = new HashMap<>();
Map<Long, List<TransferCredit>> transferCredits = new HashMap<>();
Map<Long, List<CourseAssessment>> courseAssessments = new HashMap<>();
Map<Long, CourseAssessmentRequest> courseAssessmentRequests = new HashMap<>();
Map<Long, List<StudentGroup>> studentGroups = new HashMap<>();
Map<Long, List<StudentProjectBean>> studentProjects = new HashMap<>();
Map<Long, CourseAssessment> courseAssessmentsByCourseStudent = new HashMap<>();
// StudentProject.id -> List of module beans
Map<Long, List<StudentProjectModuleBean>> studentProjectModules = new HashMap<>();
final Map<Long, List<StudentContactLogEntryComment>> contactEntryComments = new HashMap<>();
Map<Long, List<StudentLodgingPeriod>> studentLodgingPeriods = new HashMap<>();
Map<Long, List<StudentStudyPeriod>> studentStudyPeriods = new HashMap<>();
Map<Long, StudentTOR> subjectCredits = new HashMap<>();
Map<Long, List<MatriculationExamEnrollment>> studentMatriculationEnrollments = new HashMap<>();
JSONObject linkedCourseAssessments = new JSONObject();
JSONObject linkedTransferCredits = new JSONObject();
JSONObject studentFiles = new JSONObject();
JSONObject studentVariablesJSON = new JSONObject();
JSONArray studentReportsJSON = new JSONArray();
JSONArray curriculumsJSON = new JSONArray();
JSONObject studentAssessmentsJSON = new JSONObject();
List<Report> studentReports = reportDAO.listByContextType(ReportContextType.Student);
Collections.sort(studentReports, new StringAttributeComparator("getName"));
for (Report report : studentReports) {
JSONObject obj = new JSONObject();
obj.put("id", report.getId().toString());
obj.put("name", report.getName());
studentReportsJSON.add(obj);
}
/* PersonVariables */
List<PersonVariableKey> personVariableKeys = personVariableKeyDAO.listUserEditablePersonVariableKeys();
Collections.sort(personVariableKeys, new StringAttributeComparator("getVariableName"));
JSONArray personVariablesJSON = new JSONArray();
for (PersonVariableKey personVariableKey : personVariableKeys) {
PersonVariable personVariable = personVariableDAO.findByPersonAndVariableKey(person, personVariableKey);
JSONObject personVariableJSON = new JSONObject();
personVariableJSON.put("type", personVariableKey.getVariableType());
personVariableJSON.put("name", personVariableKey.getVariableName());
personVariableJSON.put("key", personVariableKey.getVariableKey());
personVariableJSON.put("value", personVariable != null ? personVariable.getValue() : "");
personVariablesJSON.add(personVariableJSON);
}
setJsDataVariable(pageRequestContext, "personVariables", personVariablesJSON.toString());
/* Curriculums */
List<Curriculum> curriculums = curriculumDAO.listUnarchived();
for (Curriculum curriculum : curriculums) {
JSONObject obj = new JSONObject();
obj.put("id", curriculum.getId().toString());
obj.put("name", curriculum.getName());
curriculumsJSON.add(obj);
}
for (Student student : students) {
/**
* Fetch courses this student is part of and sort the courses by course name
*/
List<CourseStudent> courseStudentsByStudent = courseStudentDAO.listByStudent(student);
Collections.sort(courseStudentsByStudent, new Comparator<CourseStudent>() {
private String getCourseAssessmentCompareStr(CourseStudent courseStudent) {
String result = "";
if (courseStudent != null)
if (courseStudent.getCourse() != null)
result = courseStudent.getCourse().getName();
return result;
}
@Override
public int compare(CourseStudent o1, CourseStudent o2) {
String s1 = getCourseAssessmentCompareStr(o1);
String s2 = getCourseAssessmentCompareStr(o2);
return s1.compareToIgnoreCase(s2);
}
});
for (CourseStudent courseStudent : courseStudentsByStudent) {
List<CourseAssessmentRequest> courseAssessmentRequestsByCourseStudent = courseAssessmentRequestDAO.listByCourseStudent(courseStudent);
Collections.sort(courseAssessmentRequestsByCourseStudent, new Comparator<CourseAssessmentRequest>() {
@Override
public int compare(CourseAssessmentRequest o1, CourseAssessmentRequest o2) {
return o2.getCreated().compareTo(o1.getCreated());
}
});
if (!courseAssessmentRequestsByCourseStudent.isEmpty()) {
courseAssessmentRequests.put(courseStudent.getId(), courseAssessmentRequestsByCourseStudent.get(0));
}
}
/**
* Contact log entries
*/
List<StudentContactLogEntry> listStudentContactEntries = logEntryDAO.listByStudent(student);
for (int j = 0; j < listStudentContactEntries.size(); j++) {
StudentContactLogEntry entry = listStudentContactEntries.get(j);
List<StudentContactLogEntryComment> listComments = entryCommentDAO.listByEntry(entry);
Collections.sort(listComments, new Comparator<StudentContactLogEntryComment>() {
public int compare(StudentContactLogEntryComment o1, StudentContactLogEntryComment o2) {
Date d1 = o1.getCommentDate();
Date d2 = o2.getCommentDate();
int val = d1 == null ? d2 == null ? 0 : 1 : d2 == null ? -1 : d1.compareTo(d2);
if (val == 0)
return o1.getId().compareTo(o2.getId());
else
return val;
}
});
contactEntryComments.put(entry.getId(), listComments);
}
// And then sort the entries by latest date of entry or its comments
Collections.sort(listStudentContactEntries, new Comparator<StudentContactLogEntry>() {
private Date getDateForEntry(StudentContactLogEntry entry) {
Date d = entry.getEntryDate();
List<StudentContactLogEntryComment> comments = contactEntryComments.get(entry.getId());
for (int i = 0; i < comments.size(); i++) {
StudentContactLogEntryComment comment = comments.get(i);
if (d == null) {
d = comment.getCommentDate();
} else {
if (d.before(comment.getCommentDate()))
d = comment.getCommentDate();
}
}
return d;
}
public int compare(StudentContactLogEntry o1, StudentContactLogEntry o2) {
Date d1 = getDateForEntry(o1);
Date d2 = getDateForEntry(o2);
int val = d1 == null ? d2 == null ? 0 : 1 : d2 == null ? -1 : d2.compareTo(d1);
if (val == 0)
return o2.getId().compareTo(o1.getId());
else
return val;
}
});
/**
* Students Course Assessments, sorted by course name
*/
List<CourseAssessment> courseAssessmentsByStudent = courseAssessmentDAO.listByStudent(student);
for (CourseAssessment courseAssessment : courseAssessmentsByStudent) {
Long courseStudentId = courseAssessment.getCourseStudent().getId();
courseAssessmentsByCourseStudent.put(courseStudentId, courseAssessment);
}
Collections.sort(courseAssessmentsByStudent, new Comparator<CourseAssessment>() {
private String getCourseAssessmentCompareStr(CourseAssessment courseAssessment) {
String result = "";
if (courseAssessment != null)
if (courseAssessment.getCourseStudent() != null)
if (courseAssessment.getCourseStudent().getCourse() != null)
result = courseAssessment.getCourseStudent().getCourse().getName();
return result;
}
@Override
public int compare(CourseAssessment o1, CourseAssessment o2) {
String s1 = getCourseAssessmentCompareStr(o1);
String s2 = getCourseAssessmentCompareStr(o2);
return s1.compareToIgnoreCase(s2);
}
});
JSONArray jsonCourseStudentAssessments = new JSONArray();
for (CourseStudent courseStudent : courseStudentsByStudent) {
List<CourseAssessment> courseAssessmentList = courseAssessmentsByStudent.stream().filter(courseAssessment -> Objects.equals(courseStudent.getId(), courseAssessment.getCourseStudent().getId())).collect(Collectors.toList());
if (CollectionUtils.isNotEmpty(courseAssessmentList) && courseStudent.getCourse() != null) {
Course course = courseStudent.getCourse();
JSONObject obj = new JSONObject();
obj.put("courseStudentId", courseStudent.getId());
obj.put("courseName", course.getName());
obj.put("subjectName", getSubjectText(course.getSubject(), pageRequestContext.getRequest().getLocale()));
JSONArray jsonCurriculums = new JSONArray();
for (Curriculum curriculum : course.getCurriculums()) {
JSONObject curobj = new JSONObject();
curobj.put("name", curriculum.getName());
jsonCurriculums.add(curobj);
}
obj.put("curriculums", jsonCurriculums);
if (course.getCourseLength() != null) {
EducationalLength courseLength = course.getCourseLength();
obj.put("courseLength", courseLength.getUnits().toString());
if (courseLength.getUnit() != null) {
obj.put("courseLengthUnitName", courseLength.getUnit().getName());
}
}
JSONArray jsonCourseAssessments = new JSONArray();
for (CourseAssessment ass : courseAssessmentList) {
JSONObject assobj = new JSONObject();
assobj.put("timestamp", ass.getDate() != null ? ass.getDate().getTime() : null);
assobj.put("gradeName", ass.getGrade() != null ? ass.getGrade().getName() : null);
assobj.put("gradingScaleName", (ass.getGrade() != null && ass.getGrade().getGradingScale() != null) ? ass.getGrade().getGradingScale().getName() : null);
assobj.put("assessorName", ass.getAssessor() != null ? ass.getAssessor().getFullName() : null);
jsonCourseAssessments.add(assobj);
}
obj.put("assessments", jsonCourseAssessments);
jsonCourseStudentAssessments.add(obj);
}
}
studentAssessmentsJSON.put(student.getId(), jsonCourseStudentAssessments);
/**
* Fetching and sorting of Transfer Credits
*/
List<TransferCredit> transferCreditsByStudent = transferCreditDAO.listByStudent(student);
Collections.sort(transferCreditsByStudent, new Comparator<TransferCredit>() {
private String getCourseAssessmentCompareStr(TransferCredit tCredit) {
String result = "";
if (tCredit != null)
result = tCredit.getCourseName();
return result;
}
@Override
public int compare(TransferCredit o1, TransferCredit o2) {
String s1 = getCourseAssessmentCompareStr(o1);
String s2 = getCourseAssessmentCompareStr(o2);
return s1.compareToIgnoreCase(s2);
}
});
/**
* Linked CourseAssessments
*/
List<CreditLink> linkedCourseAssessmentByStudent = creditLinkDAO.listByStudentAndType(student, CreditType.CourseAssessment);
Collections.sort(linkedCourseAssessmentByStudent, new Comparator<CreditLink>() {
private String getCourseAssessmentCompareStr(CourseAssessment courseAssessment) {
String result = "";
if (courseAssessment != null)
if (courseAssessment.getCourseStudent() != null)
if (courseAssessment.getCourseStudent().getCourse() != null)
result = courseAssessment.getCourseStudent().getCourse().getName();
return result;
}
@Override
public int compare(CreditLink o1, CreditLink o2) {
String s1 = getCourseAssessmentCompareStr((CourseAssessment) o1.getCredit());
String s2 = getCourseAssessmentCompareStr((CourseAssessment) o2.getCredit());
return s1.compareToIgnoreCase(s2);
}
});
JSONArray arr = new JSONArray();
for (CreditLink linkedCourseAssessment : linkedCourseAssessmentByStudent) {
CourseAssessment courseAssessment = (CourseAssessment) linkedCourseAssessment.getCredit();
String subjectName = getSubjectText(courseAssessment.getCourseStudent().getCourse().getSubject(), pageRequestContext.getRequest().getLocale());
JSONObject obj = new JSONObject();
obj.put("creditLinkId", linkedCourseAssessment.getId().toString());
obj.put("courseStudentId", courseAssessment.getCourseStudent().getId().toString());
obj.put("courseName", courseAssessment.getCourseStudent().getCourse().getName());
obj.put("subjectName", subjectName);
obj.put("creditDate", courseAssessment.getDate().getTime());
obj.put("courseLength", courseAssessment.getCourseStudent().getCourse().getCourseLength().getUnits().toString());
obj.put("courseLengthUnitName", courseAssessment.getCourseStudent().getCourse().getCourseLength().getUnit().getName());
obj.put("gradeName", courseAssessment.getGrade() != null ? courseAssessment.getGrade().getName() : null);
obj.put("gradingScaleName", courseAssessment.getGrade() != null ? courseAssessment.getGrade().getGradingScale().getName() : null);
obj.put("assessingUserName", courseAssessment.getAssessor().getFullName());
JSONArray courseCurriculums = new JSONArray();
if (CollectionUtils.isNotEmpty(courseAssessment.getCourseStudent().getCourse().getCurriculums())) {
for (Curriculum curriculum : courseAssessment.getCourseStudent().getCourse().getCurriculums()) {
JSONObject courseCurriculum = new JSONObject();
courseCurriculum.put("curriculumId", curriculum.getId());
courseCurriculum.put("curriculumName", curriculum.getName());
courseCurriculums.add(courseCurriculum);
}
}
obj.put("curriculums", courseCurriculums);
arr.add(obj);
}
if (!arr.isEmpty())
linkedCourseAssessments.put(student.getId(), arr);
/**
* Linked TransferCredits
*/
List<CreditLink> linkedTransferCreditsByStudent = creditLinkDAO.listByStudentAndType(student, CreditType.TransferCredit);
Collections.sort(linkedTransferCreditsByStudent, new Comparator<CreditLink>() {
private String getCourseAssessmentCompareStr(TransferCredit tCredit) {
String result = "";
if (tCredit != null)
result = tCredit.getCourseName();
return result;
}
@Override
public int compare(CreditLink o1, CreditLink o2) {
String s1 = getCourseAssessmentCompareStr((TransferCredit) o1.getCredit());
String s2 = getCourseAssessmentCompareStr((TransferCredit) o2.getCredit());
return s1.compareToIgnoreCase(s2);
}
});
arr = new JSONArray();
for (CreditLink linkedTransferCredit : linkedTransferCreditsByStudent) {
TransferCredit transferCredit = (TransferCredit) linkedTransferCredit.getCredit();
String subjectName = getSubjectText(transferCredit.getSubject(), pageRequestContext.getRequest().getLocale());
JSONObject obj = new JSONObject();
obj.put("creditLinkId", linkedTransferCredit.getId().toString());
obj.put("transferCreditId", transferCredit.getId().toString());
obj.put("courseName", transferCredit.getCourseName());
obj.put("subjectName", subjectName);
obj.put("creditDate", transferCredit.getDate().getTime());
obj.put("courseLength", transferCredit.getCourseLength().getUnits().toString());
obj.put("courseLengthUnitName", transferCredit.getCourseLength().getUnit().getName());
obj.put("gradeName", transferCredit.getGrade() != null ? transferCredit.getGrade().getName() : null);
obj.put("gradingScaleName", transferCredit.getGrade() != null ? transferCredit.getGrade().getGradingScale().getName() : null);
obj.put("assessingUserName", transferCredit.getAssessor().getFullName());
if (transferCredit.getCurriculum() != null) {
Curriculum curriculum = transferCredit.getCurriculum();
obj.put("curriculumId", curriculum.getId());
obj.put("curriculumName", curriculum.getName());
}
arr.add(obj);
}
if (!arr.isEmpty())
linkedTransferCredits.put(student.getId(), arr);
/**
* Project beans setup
*/
List<StudentProject> studentsStudentProjects = studentProjectDAO.listByStudent(student);
List<StudentProjectBean> studentProjectBeans = new ArrayList<>();
for (StudentProject studentProject : studentsStudentProjects) {
int mandatoryModuleCount = 0;
int optionalModuleCount = 0;
int passedMandatoryModuleCount = 0;
int passedOptionalModuleCount = 0;
List<StudentProjectModuleBean> studentProjectModuleBeans = new ArrayList<>();
/**
* Go through project modules to
* a) count mandatory/optional modules
* b) count mandatory/optional modules that have passing grade on them
* c) create beans to be passed to jsp
*/
List<CourseAssessment> allStudentCourseAssessments = courseAssessmentDAO.listByStudent(student);
List<TransferCredit> allStudentTransferCredits = transferCreditDAO.listByStudent(student);
List<CreditLink> allStudentCreditLinks = creditLinkDAO.listByStudent(student);
for (CreditLink creditLink : allStudentCreditLinks) {
switch(creditLink.getCredit().getCreditType()) {
case CourseAssessment:
allStudentCourseAssessments.add(((CourseAssessment) creditLink.getCredit()));
break;
case TransferCredit:
allStudentTransferCredits.add(((TransferCredit) creditLink.getCredit()));
break;
case ProjectAssessment:
break;
}
}
for (StudentProjectModule studentProjectModule : studentProject.getStudentProjectModules()) {
boolean hasPassingGrade = false;
List<CourseStudent> projectCourseCourseStudentList = new ArrayList<>();
List<TransferCredit> projectCourseTransferCreditList = new ArrayList<>();
for (CourseAssessment assessment : allStudentCourseAssessments) {
if (assessment.getCourseStudent().getCourse().getModule().getId().equals(studentProjectModule.getModule().getId())) {
projectCourseCourseStudentList.add(assessment.getCourseStudent());
if (assessment.getGrade() != null && assessment.getGrade().getPassingGrade())
hasPassingGrade = true;
}
}
if ((studentProjectModule.getModule().getCourseNumber() != null) && (studentProjectModule.getModule().getCourseNumber() != -1) && (studentProjectModule.getModule().getSubject() != null)) {
for (TransferCredit tc : allStudentTransferCredits) {
if ((tc.getCourseNumber() != null) && (tc.getCourseNumber() != -1) && (tc.getSubject() != null)) {
if (tc.getCourseNumber().equals(studentProjectModule.getModule().getCourseNumber()) && tc.getSubject().equals(studentProjectModule.getModule().getSubject())) {
projectCourseTransferCreditList.add(tc);
if (tc.getGrade() != null && tc.getGrade().getPassingGrade())
hasPassingGrade = true;
}
}
}
}
if (studentProjectModule.getOptionality() == CourseOptionality.MANDATORY) {
mandatoryModuleCount++;
if (hasPassingGrade)
passedMandatoryModuleCount++;
} else if (studentProjectModule.getOptionality() == CourseOptionality.OPTIONAL) {
optionalModuleCount++;
if (hasPassingGrade)
passedOptionalModuleCount++;
}
StudentProjectModuleBean moduleBean = new StudentProjectModuleBean(studentProjectModule, hasPassingGrade, projectCourseCourseStudentList, projectCourseTransferCreditList);
studentProjectModuleBeans.add(moduleBean);
}
// Add ModuleBeans to response
studentProjectModules.put(studentProject.getId(), studentProjectModuleBeans);
List<ProjectAssessment> projectAssessments = projectAssessmentDAO.listByProjectAndArchived(studentProject, Boolean.FALSE);
Collections.sort(projectAssessments, new Comparator<ProjectAssessment>() {
@Override
public int compare(ProjectAssessment o1, ProjectAssessment o2) {
return o2.getDate().compareTo(o1.getDate());
}
});
StudentProjectBean bean = new StudentProjectBean(studentProject, mandatoryModuleCount, optionalModuleCount, passedMandatoryModuleCount, passedOptionalModuleCount, projectAssessments);
studentProjectBeans.add(bean);
}
List<StudentFile> files = studentFileDAO.listByStudent(student);
Collections.sort(files, new StringAttributeComparator("getName", true));
arr = new JSONArray();
for (StudentFile file : files) {
JSONObject obj = new JSONObject();
obj.put("id", file.getId());
obj.put("name", file.getName());
obj.put("fileTypeName", file.getFileType() != null ? file.getFileType().getName() : "");
obj.put("created", file.getCreated().getTime());
obj.put("lastModified", file.getLastModified().getTime());
arr.add(obj);
}
if (!arr.isEmpty())
studentFiles.put(student.getId(), arr);
JSONArray variables = new JSONArray();
for (UserVariable userVariable : userVariableDAO.listByUserAndUserEditable(student, true)) {
JSONObject variable = new JSONObject();
variable.put("type", userVariable.getKey().getVariableType());
variable.put("name", userVariable.getKey().getVariableName());
variable.put("key", userVariable.getKey().getVariableKey());
variable.put("value", userVariable.getValue() != null ? userVariable.getValue() : "");
variables.add(variable);
}
if (!variables.isEmpty())
studentVariablesJSON.put(student.getId(), variables);
// Student Image
studentHasImage.put(student.getId(), imageDAO.findStudentHasImage(student));
List<StudentLodgingPeriod> studentLodgingPeriodEntities = studentLodgingPeriodDAO.listByStudent(student);
studentLodgingPeriodEntities.sort(Comparator.comparing(StudentLodgingPeriod::getBegin, Comparator.nullsLast(Comparator.naturalOrder())));
List<StudentStudyPeriod> studentStudyPeriodEntities = studentStudyPeriodDAO.listByStudent(student);
studentStudyPeriodEntities.sort(Comparator.comparing(StudentStudyPeriod::getBegin, Comparator.nullsLast(Comparator.naturalOrder())));
courseStudents.put(student.getId(), courseStudentsByStudent);
courseAssessments.put(student.getId(), courseAssessmentsByStudent);
contactEntries.put(student.getId(), listStudentContactEntries);
transferCredits.put(student.getId(), transferCreditsByStudent);
studentGroups.put(student.getId(), studentGroupDAO.listByStudent(student, null, null, false));
studentProjects.put(student.getId(), studentProjectBeans);
studentLodgingPeriods.put(student.getId(), studentLodgingPeriodEntities);
studentStudyPeriods.put(student.getId(), studentStudyPeriodEntities);
studentMatriculationEnrollments.put(student.getId(), matriculationExamEnrollmentDAO.listByStudent(student));
try {
StudentTOR tor = StudentTORController.constructStudentTOR(student);
subjectCredits.put(student.getId(), tor);
} catch (Exception ex) {
logger.log(Level.SEVERE, String.format("Failed to construct TOR for student %d", student.getId()), ex);
}
}
ObjectMapper mapper = new ObjectMapper();
StringWriter writer = new StringWriter();
mapper.setDateFormat(new SimpleDateFormat("yyyy-MM-dd"));
try {
mapper.writeValue(writer, subjectCredits);
String requestStr = writer.toString();
setJsDataVariable(pageRequestContext, "subjectCredits", requestStr);
} catch (JsonGenerationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (JsonMappingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
setJsDataVariable(pageRequestContext, "studentAssessments", studentAssessmentsJSON.toString());
setJsDataVariable(pageRequestContext, "linkedCourseAssessments", linkedCourseAssessments.toString());
setJsDataVariable(pageRequestContext, "linkedTransferCredits", linkedTransferCredits.toString());
setJsDataVariable(pageRequestContext, "studentFiles", studentFiles.toString());
setJsDataVariable(pageRequestContext, "studentReports", studentReportsJSON.toString());
setJsDataVariable(pageRequestContext, "curriculums", curriculumsJSON.toString());
setJsDataVariable(pageRequestContext, "studentVariables", studentVariablesJSON.toString());
pageRequestContext.getRequest().setAttribute("students", students);
pageRequestContext.getRequest().setAttribute("courses", courseStudents);
pageRequestContext.getRequest().setAttribute("contactEntries", contactEntries);
pageRequestContext.getRequest().setAttribute("contactEntryComments", contactEntryComments);
pageRequestContext.getRequest().setAttribute("transferCredits", transferCredits);
pageRequestContext.getRequest().setAttribute("courseAssessments", courseAssessments);
pageRequestContext.getRequest().setAttribute("studentGroups", studentGroups);
pageRequestContext.getRequest().setAttribute("studentProjects", studentProjects);
pageRequestContext.getRequest().setAttribute("studentProjectModules", studentProjectModules);
pageRequestContext.getRequest().setAttribute("courseAssessmentsByCourseStudent", courseAssessmentsByCourseStudent);
pageRequestContext.getRequest().setAttribute("studentHasImage", studentHasImage);
pageRequestContext.getRequest().setAttribute("courseAssessmentRequests", courseAssessmentRequests);
pageRequestContext.getRequest().setAttribute("studentLodgingPeriods", studentLodgingPeriods);
pageRequestContext.getRequest().setAttribute("studentStudyPeriods", studentStudyPeriods);
pageRequestContext.getRequest().setAttribute("studentMatriculationEnrollments", studentMatriculationEnrollments);
pageRequestContext.getRequest().setAttribute("hasPersonVariables", CollectionUtils.isNotEmpty(personVariableKeys));
pageRequestContext.setIncludeJSP("/templates/students/viewstudent.jsp");
}
Aggregations