use of fi.otavanopisto.pyramus.dao.base.PersonDAO in project pyramus by otavanopisto.
the class ManageStudentContactEntriesViewController method process.
/**
* Processes the page request.
*
* In parameters
* - person
*
* Page parameters
* - person - Person object
* - contactEntries - List of StudentContactLogEntry objects
*
* @param pageRequestContext pageRequestContext
*/
public void process(PageRequestContext pageRequestContext) {
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
StudentContactLogEntryDAO logEntryDAO = DAOFactory.getInstance().getStudentContactLogEntryDAO();
StudentContactLogEntryCommentDAO entryCommentDAO = DAOFactory.getInstance().getStudentContactLogEntryCommentDAO();
Long personId = pageRequestContext.getLong("person");
Person person = personDAO.findById(personId);
pageRequestContext.getRequest().setAttribute("person", person);
List<Student> students = studentDAO.listByPerson(person);
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
*/
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)) ? o1.getStudyStartDate().compareTo(o2.getStudyStartDate()) : 0;
} else
return o1class < o2class ? -1 : o1class == o2class ? 0 : 1;
}
});
Map<Long, List<StudentContactLogEntry>> contactEntries = new HashMap<>();
final Map<Long, List<StudentContactLogEntryComment>> contactEntryComments = new HashMap<>();
for (int i = 0; i < students.size(); i++) {
Student student = students.get(i);
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);
}
// Now we can sort entries based on date of entry and/or dates of the comments on the entry
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;
}
});
contactEntries.put(student.getId(), listStudentContactEntries);
}
pageRequestContext.getRequest().setAttribute("students", students);
pageRequestContext.getRequest().setAttribute("contactEntries", contactEntries);
pageRequestContext.getRequest().setAttribute("contactEntryComments", contactEntryComments);
pageRequestContext.setIncludeJSP("/templates/students/managestudentcontactentries.jsp");
}
use of fi.otavanopisto.pyramus.dao.base.PersonDAO in project pyramus by otavanopisto.
the class DebugDataViewController method process.
public void process(PageRequestContext requestContext) {
StaffMemberDAO userDAO = DAOFactory.getInstance().getStaffMemberDAO();
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
CourseDAO courseDAO = DAOFactory.getInstance().getCourseDAO();
ModuleDAO moduleDAO = DAOFactory.getInstance().getModuleDAO();
ProjectDAO projectDAO = DAOFactory.getInstance().getProjectDAO();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
CourseStateDAO courseStateDAO = DAOFactory.getInstance().getCourseStateDAO();
ResourceCategoryDAO resourceCategoryDAO = DAOFactory.getInstance().getResourceCategoryDAO();
MaterialResourceDAO materialResourceDAO = DAOFactory.getInstance().getMaterialResourceDAO();
EducationalTimeUnitDAO educationalTimeUnitDAO = DAOFactory.getInstance().getEducationalTimeUnitDAO();
OrganizationDAO organizationDAO = DAOFactory.getInstance().getOrganizationDAO();
String type = requestContext.getRequest().getParameter("type");
int count = Integer.parseInt(requestContext.getRequest().getParameter("count"));
int start = 1;
String s = requestContext.getRequest().getParameter("start");
if (!StringUtils.isBlank(s)) {
start = Integer.parseInt(s);
}
User user = userDAO.findById(requestContext.getLoggedUserId());
if ("module".equals(type)) {
for (int i = start; i < (start + count); i++) {
EducationalTimeUnit etu = educationalTimeUnitDAO.findById(new Long(1));
moduleDAO.create("Moduli " + i, null, null, new Double(10), etu, "KuvaustekstiƤ modulille " + i, null, user);
}
} else if ("course".equals(type)) {
for (int i = start; i < (start + count); i++) {
EducationalTimeUnit etu = educationalTimeUnitDAO.findById(new Long(1));
CourseState courseState = courseStateDAO.findById(new Long(1));
Organization organization = organizationDAO.findById(1L);
courseDAO.create(moduleDAO.findById(new Long(1)), organization, "Kurssi " + i, "", courseState, null, null, null, null, null, new Double(10), etu, null, null, null, null, null, null, "KuvaustekstiƤ kurssille " + i, null, null, null, null, user);
}
} else if ("resource".equals(type)) {
for (int i = start; i < (start + count); i++) {
ResourceCategory resourceCategory = resourceCategoryDAO.findById(new Long(1));
materialResourceDAO.create("Materiaaliresurssi " + i, resourceCategory, new Double(500));
}
} else if ("project".equals(type)) {
for (int i = start; i < (start + count); i++) {
EducationalTimeUnit etu = educationalTimeUnitDAO.findById(new Long(1));
projectDAO.create("Projekti " + i, "KuvaustekstiƤ projektille " + i, new Double(10), etu, user);
}
} else if ("student".equals(type)) {
for (int i = start; i < (start + count); i++) {
Person person = personDAO.create(new Date(), "030310-123R", Sex.MALE, null, Boolean.FALSE);
studentDAO.create(person, "Etunimi " + i, "Sukunimi " + i, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, false);
}
}
}
use of fi.otavanopisto.pyramus.dao.base.PersonDAO in project pyramus by otavanopisto.
the class CreateStudentViewController method process.
public void process(PageRequestContext pageRequestContext) {
StudentActivityTypeDAO studentActivityTypeDAO = DAOFactory.getInstance().getStudentActivityTypeDAO();
StudentEducationalLevelDAO studentEducationalLevelDAO = DAOFactory.getInstance().getStudentEducationalLevelDAO();
StudentExaminationTypeDAO studentExaminationTypeDAO = DAOFactory.getInstance().getStudentExaminationTypeDAO();
StudentStudyEndReasonDAO studyEndReasonDAO = DAOFactory.getInstance().getStudentStudyEndReasonDAO();
UserVariableKeyDAO variableKeyDAO = DAOFactory.getInstance().getUserVariableKeyDAO();
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();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
StaffMemberDAO staffMemberDAO = DAOFactory.getInstance().getStaffMemberDAO();
CurriculumDAO curriculumDAO = DAOFactory.getInstance().getCurriculumDAO();
User loggedUser = staffMemberDAO.findById(pageRequestContext.getLoggedUserId());
Long personId = pageRequestContext.getLong("personId");
if (personId != null) {
Person person = personDAO.findById(personId);
StaffMember staffMember = staffMemberDAO.findByPerson(person);
pageRequestContext.getRequest().setAttribute("person", person);
pageRequestContext.getRequest().setAttribute("staffMember", staffMember);
String emails = new JSONArrayExtractor("defaultAddress", "contactType", "address").extractString(staffMember.getContactInfo().getEmails());
String addresses = new JSONArrayExtractor("defaultAddress", "name", "contactType", "streetAddress", "postalCode", "city", "country").extractString(staffMember.getContactInfo().getAddresses());
String phones = new JSONArrayExtractor("defaultNumber", "contactType", "number").extractString(staffMember.getContactInfo().getPhoneNumbers());
setJsDataVariable(pageRequestContext, "createstudent_emails", emails);
setJsDataVariable(pageRequestContext, "createstudent_addresses", addresses);
setJsDataVariable(pageRequestContext, "createstudent_phones", phones);
}
List<StudyProgramme> studyProgrammes = UserUtils.canAccessAllOrganizations(loggedUser) ? studyProgrammeDAO.listUnarchived() : studyProgrammeDAO.listByOrganization(loggedUser.getOrganization(), Archived.UNARCHIVED);
Collections.sort(studyProgrammes, new StringAttributeComparator("getName"));
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"));
List<UserVariableKey> userVariableKeys = variableKeyDAO.listByUserEditable(Boolean.TRUE);
Collections.sort(userVariableKeys, new StringAttributeComparator("getVariableName"));
List<Curriculum> curriculums = curriculumDAO.listUnarchived();
Collections.sort(curriculums, new StringAttributeComparator("getName"));
String jsonContactTypes = new JSONArrayExtractor("name", "id").extractString(contactTypes);
String jsonVariableKeys = new JSONArrayExtractor("variableKey", "variableName", "variableType").extractString(userVariableKeys);
setJsDataVariable(pageRequestContext, "contactTypes", jsonContactTypes);
setJsDataVariable(pageRequestContext, "variableKeys", jsonVariableKeys);
pageRequestContext.getRequest().setAttribute("schools", schools);
pageRequestContext.getRequest().setAttribute("activityTypes", studentActivityTypeDAO.listUnarchived());
pageRequestContext.getRequest().setAttribute("contactURLTypes", contactURLTypes);
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("studyProgrammes", studyProgrammes);
pageRequestContext.getRequest().setAttribute("curriculums", curriculums);
pageRequestContext.getRequest().setAttribute("studyEndReasons", studyEndReasonDAO.listByParentReason(null));
pageRequestContext.getRequest().setAttribute("variableKeys", userVariableKeys);
pageRequestContext.setIncludeJSP("/templates/students/createstudent.jsp");
}
use of fi.otavanopisto.pyramus.dao.base.PersonDAO in project pyramus by otavanopisto.
the class EditStudentJSONRequestController method checkAccess.
@Override
protected boolean checkAccess(RequestContext requestContext) {
UserDAO userDAO = DAOFactory.getInstance().getUserDAO();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
Long loggedUserId = requestContext.getLoggedUserId();
User user = userDAO.findById(loggedUserId);
if (!Permissions.instance().hasEnvironmentPermission(user, PyramusViewPermissions.EDIT_STUDENT)) {
return false;
} else {
if (UserUtils.canAccessAllOrganizations(user)) {
return true;
} else {
Long personId = requestContext.getLong("personId");
Person person = personDAO.findById(personId);
for (Student student : person.getStudents()) {
if (UserUtils.isMemberOf(user, student.getOrganization())) {
// Having one common organization is enough - though the view may not allow editing all
return true;
}
}
return false;
}
}
}
use of fi.otavanopisto.pyramus.dao.base.PersonDAO in project pyramus by otavanopisto.
the class EditStudentJSONRequestController method process.
public void process(JSONRequestContext requestContext) {
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
PersonDAO personDAO = DAOFactory.getInstance().getPersonDAO();
StudentActivityTypeDAO activityTypeDAO = DAOFactory.getInstance().getStudentActivityTypeDAO();
StudentExaminationTypeDAO examinationTypeDAO = DAOFactory.getInstance().getStudentExaminationTypeDAO();
StudentEducationalLevelDAO educationalLevelDAO = DAOFactory.getInstance().getStudentEducationalLevelDAO();
StudentStudyEndReasonDAO studyEndReasonDAO = DAOFactory.getInstance().getStudentStudyEndReasonDAO();
UserVariableDAO userVariableDAO = DAOFactory.getInstance().getUserVariableDAO();
LanguageDAO languageDAO = DAOFactory.getInstance().getLanguageDAO();
MunicipalityDAO municipalityDAO = DAOFactory.getInstance().getMunicipalityDAO();
NationalityDAO nationalityDAO = DAOFactory.getInstance().getNationalityDAO();
SchoolDAO schoolDAO = DAOFactory.getInstance().getSchoolDAO();
AddressDAO addressDAO = DAOFactory.getInstance().getAddressDAO();
ContactInfoDAO contactInfoDAO = DAOFactory.getInstance().getContactInfoDAO();
EmailDAO emailDAO = DAOFactory.getInstance().getEmailDAO();
PhoneNumberDAO phoneNumberDAO = DAOFactory.getInstance().getPhoneNumberDAO();
TagDAO tagDAO = DAOFactory.getInstance().getTagDAO();
ContactTypeDAO contactTypeDAO = DAOFactory.getInstance().getContactTypeDAO();
UserIdentificationDAO userIdentificationDAO = DAOFactory.getInstance().getUserIdentificationDAO();
UserDAO userDAO = DAOFactory.getInstance().getUserDAO();
CurriculumDAO curriculumDAO = DAOFactory.getInstance().getCurriculumDAO();
StudentLodgingPeriodDAO lodgingPeriodDAO = DAOFactory.getInstance().getStudentLodgingPeriodDAO();
PersonVariableDAO personVariableDAO = DAOFactory.getInstance().getPersonVariableDAO();
StudentStudyPeriodDAO studentStudyPeriodDAO = DAOFactory.getInstance().getStudentStudyPeriodDAO();
StaffMemberDAO staffMemberDAO = DAOFactory.getInstance().getStaffMemberDAO();
User loggedUser = userDAO.findById(requestContext.getLoggedUserId());
Long personId = NumberUtils.createLong(requestContext.getRequest().getParameter("personId"));
Person person = personDAO.findById(personId);
Date birthday = requestContext.getDate("birthday");
String ssecId = requestContext.getString("ssecId");
Sex sex = (Sex) requestContext.getEnum("gender", Sex.class);
String basicInfo = requestContext.getString("basicInfo");
Long version = requestContext.getLong("version");
Boolean secureInfo = requestContext.getBoolean("secureInfo");
String username = requestContext.getString("username");
String password = requestContext.getString("password1");
String password2 = requestContext.getString("password2");
if (UserUtils.allowEditCredentials(loggedUser, person)) {
if (!person.getVersion().equals(version)) {
throw new StaleObjectStateException(Person.class.getName(), person.getId());
}
boolean usernameBlank = StringUtils.isBlank(username);
boolean passwordBlank = StringUtils.isBlank(password);
UserIdentification userIdentification = userIdentificationDAO.findByAuthSourceAndPerson("internal", person);
if (usernameBlank && passwordBlank) {
// #1108: Existing credential deletion
if (userIdentification != null && NumberUtils.isNumber(userIdentification.getExternalId())) {
InternalAuthDAO internalAuthDAO = DAOFactory.getInstance().getInternalAuthDAO();
InternalAuth internalAuth = internalAuthDAO.findById(new Long(userIdentification.getExternalId()));
if (internalAuth != null) {
internalAuthDAO.delete(internalAuth);
}
userIdentificationDAO.delete(userIdentification);
}
} else if (!usernameBlank || !passwordBlank) {
if (!passwordBlank && !password.equals(password2)) {
throw new SmvcRuntimeException(PyramusStatusCode.PASSWORD_MISMATCH, "Passwords don't match");
}
// #921: Check username
InternalAuthDAO internalAuthDAO = DAOFactory.getInstance().getInternalAuthDAO();
InternalAuth internalAuth = internalAuthDAO.findByUsername(username);
if (internalAuth != null) {
userIdentification = userIdentificationDAO.findByAuthSourceAndExternalId("internal", internalAuth.getId().toString());
if (userIdentification != null && !person.getId().equals(userIdentification.getPerson().getId())) {
throw new RuntimeException(Messages.getInstance().getText(requestContext.getRequest().getLocale(), "generic.errors.usernameInUse"));
}
} else if (!usernameBlank && passwordBlank) {
throw new RuntimeException(Messages.getInstance().getText(requestContext.getRequest().getLocale(), "generic.errors.nopassword"));
}
// 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 = userIdentificationDAO.findByAuthSourceAndPerson(internalAuthenticationProvider.getName(), person);
if (internalAuthenticationProvider.canUpdateCredentials()) {
if (userIdentification == null) {
String externalId = internalAuthenticationProvider.createCredentials(username, password);
userIdentificationDAO.create(person, internalAuthenticationProvider.getName(), externalId);
} else {
if ("-1".equals(userIdentification.getExternalId())) {
String externalId = internalAuthenticationProvider.createCredentials(username, password);
userIdentificationDAO.updateExternalId(userIdentification, externalId);
} else {
if (!StringUtils.isBlank(username))
internalAuthenticationProvider.updateUsername(userIdentification.getExternalId(), username);
if (!StringUtils.isBlank(password))
internalAuthenticationProvider.updatePassword(userIdentification.getExternalId(), password);
}
}
}
}
}
}
}
// Abstract student
personDAO.update(person, birthday, ssecId, sex, basicInfo, secureInfo);
// Person Variables
Integer personVariableCount = requestContext.getInteger("personVariablesTable.rowCount");
if (personVariableCount != null) {
for (int i = 0; i < personVariableCount; i++) {
String colPrefix = "personVariablesTable." + i;
Long edited = requestContext.getLong(colPrefix + ".edited");
if (Objects.equals(new Long(1), edited)) {
String variableKey = requestContext.getString(colPrefix + ".key");
String variableValue = requestContext.getString(colPrefix + ".value");
personVariableDAO.setPersonVariable(person, variableKey, variableValue);
}
}
}
List<Student> students = UserUtils.canAccessAllOrganizations(loggedUser) ? studentDAO.listByPerson(person) : studentDAO.listByPersonAndOrganization(person, loggedUser.getOrganization());
for (Student student : students) {
int rowCount = requestContext.getInteger("emailTable." + student.getId() + ".rowCount");
for (int i = 0; i < rowCount; i++) {
String colPrefix = "emailTable." + student.getId() + "." + i;
String email = StringUtils.trim(requestContext.getString(colPrefix + ".email"));
if (StringUtils.isNotBlank(email)) {
ContactType contactType = contactTypeDAO.findById(requestContext.getLong(colPrefix + ".contactTypeId"));
if (!UserUtils.isAllowedEmail(email, contactType, person.getId()))
throw new RuntimeException(Messages.getInstance().getText(requestContext.getRequest().getLocale(), "generic.errors.emailInUse"));
}
}
}
for (Student student : students) {
Long studentVersion = requestContext.getLong("studentVersion." + student.getId());
if (!student.getVersion().equals(studentVersion))
throw new StaleObjectStateException(Student.class.getName(), student.getId());
String firstName = StringUtils.trim(requestContext.getString("firstName." + student.getId()));
String lastName = StringUtils.trim(requestContext.getString("lastName." + student.getId()));
String nickname = StringUtils.trim(requestContext.getString("nickname." + student.getId()));
String additionalInfo = requestContext.getString("additionalInfo." + student.getId());
String additionalContactInfo = requestContext.getString("otherContactInfo." + student.getId());
String education = requestContext.getString("education." + student.getId());
Double previousStudies = requestContext.getDouble("previousStudies." + student.getId());
Date studyTimeEnd = requestContext.getDate("studyTimeEnd." + student.getId());
Date studyStartDate = requestContext.getDate("studyStartDate." + student.getId());
Date studyEndDate = requestContext.getDate("studyEndDate." + student.getId());
String studyEndText = requestContext.getString("studyEndText." + student.getId());
String tagsText = requestContext.getString("tags." + student.getId());
StudentFunding funding = (StudentFunding) requestContext.getEnum("funding." + student.getId(), StudentFunding.class);
Set<Tag> tagEntities = new HashSet<>();
if (!StringUtils.isBlank(tagsText)) {
List<String> tags = Arrays.asList(tagsText.split("[\\ ,]"));
for (String tag : tags) {
if (!StringUtils.isBlank(tag)) {
Tag tagEntity = tagDAO.findByText(tag.trim());
if (tagEntity == null)
tagEntity = tagDAO.create(tag);
tagEntities.add(tagEntity);
}
}
}
Long entityId = requestContext.getLong("language." + student.getId());
Language language = entityId == null ? null : languageDAO.findById(entityId);
entityId = requestContext.getLong("activityType." + student.getId());
StudentActivityType activityType = entityId == null ? null : activityTypeDAO.findById(entityId);
entityId = requestContext.getLong("examinationType." + student.getId());
StudentExaminationType examinationType = entityId == null ? null : examinationTypeDAO.findById(entityId);
entityId = requestContext.getLong("educationalLevel." + student.getId());
StudentEducationalLevel educationalLevel = entityId == null ? null : educationalLevelDAO.findById(entityId);
entityId = requestContext.getLong("nationality." + student.getId());
Nationality nationality = entityId == null ? null : nationalityDAO.findById(entityId);
entityId = requestContext.getLong("municipality." + student.getId());
Municipality municipality = entityId == null ? null : municipalityDAO.findById(entityId);
entityId = requestContext.getLong("school." + student.getId());
School school = entityId != null && entityId > 0 ? schoolDAO.findById(entityId) : null;
entityId = requestContext.getLong("studyEndReason." + student.getId());
StudentStudyEndReason studyEndReason = entityId == null ? null : studyEndReasonDAO.findById(entityId);
entityId = requestContext.getLong("curriculum." + student.getId());
Curriculum curriculum = entityId == null ? null : curriculumDAO.findById(entityId);
entityId = requestContext.getLong("studyApprover." + student.getId());
StaffMember approver = entityId == null ? null : staffMemberDAO.findById(entityId);
Integer variableCount = requestContext.getInteger("variablesTable." + student.getId() + ".rowCount");
if (variableCount != null) {
for (int i = 0; i < variableCount; i++) {
String colPrefix = "variablesTable." + student.getId() + "." + i;
Long edited = requestContext.getLong(colPrefix + ".edited");
if (Objects.equals(new Long(1), edited)) {
String variableKey = requestContext.getString(colPrefix + ".key");
String variableValue = requestContext.getString(colPrefix + ".value");
userVariableDAO.setUserVariable(student, variableKey, variableValue);
}
}
}
Integer lodgingPeriodsCount = requestContext.getInteger("lodgingPeriodsTable." + student.getId() + ".rowCount");
if (lodgingPeriodsCount != null) {
Set<Long> remainingIds = new HashSet<>();
for (int i = 0; i < lodgingPeriodsCount; i++) {
String colPrefix = "lodgingPeriodsTable." + student.getId() + "." + i;
Long id = requestContext.getLong(colPrefix + ".id");
Date begin = requestContext.getDate(colPrefix + ".begin");
Date end = requestContext.getDate(colPrefix + ".end");
if (id == -1 && begin != null) {
StudentLodgingPeriod lodgingPeriod = lodgingPeriodDAO.create(student, begin, end);
remainingIds.add(lodgingPeriod.getId());
} else if (id > 0) {
StudentLodgingPeriod lodgingPeriod = lodgingPeriodDAO.findById(id);
remainingIds.add(id);
if (begin != null) {
if (lodgingPeriod != null) {
lodgingPeriodDAO.update(lodgingPeriod, begin, end);
}
}
}
}
List<StudentLodgingPeriod> periods = lodgingPeriodDAO.listByStudent(student);
periods.removeIf(period -> remainingIds.contains(period.getId()));
periods.forEach(period -> lodgingPeriodDAO.delete(period));
}
Integer studyPeriodsCount = requestContext.getInteger("studentStudyPeriodsTable." + student.getId() + ".rowCount");
if (studyPeriodsCount != null) {
Set<Long> remainingIds = new HashSet<>();
for (int i = 0; i < studyPeriodsCount; i++) {
String colPrefix = "studentStudyPeriodsTable." + student.getId() + "." + i;
Long id = requestContext.getLong(colPrefix + ".id");
StudentStudyPeriodType periodType = (StudentStudyPeriodType) requestContext.getEnum(colPrefix + ".type", StudentStudyPeriodType.class);
Date begin = requestContext.getDate(colPrefix + ".begin");
// Null out the end date when period type allows only begin dates
Date end = !StudentStudyPeriodType.BEGINDATE_ONLY.contains(periodType) ? requestContext.getDate(colPrefix + ".end") : null;
if (id == -1 && begin != null) {
StudentStudyPeriod studyPeriod = studentStudyPeriodDAO.create(student, begin, end, periodType);
remainingIds.add(studyPeriod.getId());
} else if (id > 0) {
StudentStudyPeriod studyPeriod = studentStudyPeriodDAO.findById(id);
remainingIds.add(id);
if (begin != null) {
if (studyPeriod != null) {
studentStudyPeriodDAO.update(studyPeriod, begin, end, periodType);
}
}
}
}
List<StudentStudyPeriod> periods = studentStudyPeriodDAO.listByStudent(student);
periods.removeIf(period -> remainingIds.contains(period.getId()));
periods.forEach(period -> studentStudyPeriodDAO.delete(period));
}
boolean studiesEnded = student.getStudyEndDate() == null && studyEndDate != null;
// Student
studentDAO.update(student, firstName, lastName, nickname, additionalInfo, studyTimeEnd, activityType, examinationType, educationalLevel, education, nationality, municipality, language, school, curriculum, previousStudies, studyStartDate, studyEndDate, studyEndReason, studyEndText);
studentDAO.updateApprover(student, approver);
studentDAO.updateFunding(student, funding);
// Tags
studentDAO.setStudentTags(student, tagEntities);
// Contact info
contactInfoDAO.update(student.getContactInfo(), additionalContactInfo);
// Student addresses
Set<Long> existingAddresses = new HashSet<>();
int rowCount = requestContext.getInteger("addressTable." + student.getId() + ".rowCount");
for (int i = 0; i < rowCount; i++) {
String colPrefix = "addressTable." + student.getId() + "." + i;
Long addressId = requestContext.getLong(colPrefix + ".addressId");
Boolean defaultAddress = requestContext.getBoolean(colPrefix + ".defaultAddress");
ContactType contactType = contactTypeDAO.findById(requestContext.getLong(colPrefix + ".contactTypeId"));
String name = requestContext.getString(colPrefix + ".name");
String street = requestContext.getString(colPrefix + ".street");
String postal = requestContext.getString(colPrefix + ".postal");
String city = requestContext.getString(colPrefix + ".city");
String country = requestContext.getString(colPrefix + ".country");
boolean hasAddress = name != null || street != null || postal != null || city != null || country != null;
if (addressId == -1 && hasAddress) {
Address address = addressDAO.create(student.getContactInfo(), contactType, name, street, postal, city, country, defaultAddress);
existingAddresses.add(address.getId());
} else if (addressId > 0) {
Address address = addressDAO.findById(addressId);
if (hasAddress) {
existingAddresses.add(addressId);
addressDAO.update(address, defaultAddress, contactType, name, street, postal, city, country);
}
}
}
List<Address> addresses = student.getContactInfo().getAddresses();
for (int i = addresses.size() - 1; i >= 0; i--) {
Address address = addresses.get(i);
if (!existingAddresses.contains(address.getId())) {
addressDAO.delete(address);
}
}
// Email addresses
Set<Long> existingEmails = new HashSet<>();
rowCount = requestContext.getInteger("emailTable." + student.getId() + ".rowCount");
for (int i = 0; i < rowCount; i++) {
String colPrefix = "emailTable." + student.getId() + "." + i;
Boolean defaultAddress = requestContext.getBoolean(colPrefix + ".defaultAddress");
ContactType contactType = contactTypeDAO.findById(requestContext.getLong(colPrefix + ".contactTypeId"));
String email = StringUtils.trim(requestContext.getString(colPrefix + ".email"));
if (StringUtils.isNotBlank(email)) {
Long emailId = requestContext.getLong(colPrefix + ".emailId");
if (emailId == -1) {
emailId = emailDAO.create(student.getContactInfo(), contactType, defaultAddress, email).getId();
} else {
emailDAO.update(emailDAO.findById(emailId), contactType, defaultAddress, email);
}
existingEmails.add(emailId);
}
}
List<Email> emails = student.getContactInfo().getEmails();
for (int i = emails.size() - 1; i >= 0; i--) {
Email email = emails.get(i);
if (!existingEmails.contains(email.getId())) {
emailDAO.delete(email);
}
}
// Phone numbers
Set<Long> existingPhoneNumbers = new HashSet<>();
rowCount = requestContext.getInteger("phoneTable." + student.getId() + ".rowCount");
for (int i = 0; i < rowCount; i++) {
String colPrefix = "phoneTable." + student.getId() + "." + i;
Boolean defaultNumber = requestContext.getBoolean(colPrefix + ".defaultNumber");
ContactType contactType = contactTypeDAO.findById(requestContext.getLong(colPrefix + ".contactTypeId"));
String number = requestContext.getString(colPrefix + ".phone");
Long phoneId = requestContext.getLong(colPrefix + ".phoneId");
if (phoneId == -1 && number != null) {
phoneId = phoneNumberDAO.create(student.getContactInfo(), contactType, defaultNumber, number).getId();
existingPhoneNumbers.add(phoneId);
} else if (phoneId > 0 && number != null) {
phoneNumberDAO.update(phoneNumberDAO.findById(phoneId), contactType, defaultNumber, number);
existingPhoneNumbers.add(phoneId);
}
}
List<PhoneNumber> phoneNumbers = student.getContactInfo().getPhoneNumbers();
for (int i = phoneNumbers.size() - 1; i >= 0; i--) {
PhoneNumber phoneNumber = phoneNumbers.get(i);
if (!existingPhoneNumbers.contains(phoneNumber.getId())) {
phoneNumberDAO.delete(phoneNumber);
}
}
Long studyProgrammeId = student.getStudyProgramme() != null ? student.getStudyProgramme().getId() : null;
// #4226: Remove applications of nettipk/nettilukio students when their studies end
if (studiesEnded && studyProgrammeId != null && (studyProgrammeId == 6L || studyProgrammeId == 7L)) {
ApplicationDAO applicationDAO = DAOFactory.getInstance().getApplicationDAO();
Application application = applicationDAO.findByStudent(student);
if (application != null) {
ApplicationUtils.deleteApplication(application);
}
}
}
// Contact information of a student won't be reflected to Person
// used when searching students, so a manual re-index is needed
person = personDAO.findById(person.getId());
personDAO.forceReindex(person);
requestContext.setRedirectURL(requestContext.getReferer(true));
}
Aggregations