use of fi.otavanopisto.pyramus.dao.courses.CourseStudentDAO in project pyramus by otavanopisto.
the class ListStudentProjectsJSONRequestController method process.
public void process(JSONRequestContext requestContext) {
CourseDAO courseDAO = DAOFactory.getInstance().getCourseDAO();
StudentProjectDAO studentProjectDAO = DAOFactory.getInstance().getStudentProjectDAO();
ProjectDAO projectDAO = DAOFactory.getInstance().getProjectDAO();
CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
TransferCreditDAO transferCreditDAO = DAOFactory.getInstance().getTransferCreditDAO();
CourseAssessmentDAO courseAssessmentDAO = DAOFactory.getInstance().getCourseAssessmentDAO();
ProjectAssessmentDAO projectAssessmentDAO = DAOFactory.getInstance().getProjectAssessmentDAO();
Long projectId = requestContext.getLong("project");
Project project = projectDAO.findById(projectId);
Integer page = requestContext.getInteger("page");
page = page != null ? page : 0;
Integer maxResults = requestContext.getInteger("maxResults");
maxResults = maxResults != null ? maxResults : 25;
int firstResult = page * maxResults;
long numStudentProjectsTotal = studentProjectDAO.countByProject(project);
int numPages = (int) Math.ceil((double) numStudentProjectsTotal / maxResults);
List<StudentProject> studentProjectsByProjectPage = studentProjectDAO.listByProject(project, firstResult, maxResults);
int resultsCount = studentProjectsByProjectPage.size();
JSONArray studentProjectsJSON = new JSONArray();
for (StudentProject sp : studentProjectsByProjectPage) {
StudentProjectBean bean = beanify(sp, courseDAO, courseStudentDAO, transferCreditDAO, courseAssessmentDAO, projectAssessmentDAO);
JSONObject spJSON = new JSONObject();
JSONArray spDates = new JSONArray();
StringBuilder gradeText = new StringBuilder();
for (ProjectAssessment assessment : bean.getAssessments()) {
spDates.add(assessment.getDate().getTime());
if (gradeText.length() > 0)
gradeText.append(", ");
if (assessment.getGrade() != null)
gradeText.append(assessment.getGrade().getName());
else
gradeText.append("-");
}
spJSON.put("personId", bean.getStudentProject().getStudent().getPerson().getId());
spJSON.put("studentProjectId", bean.getStudentProject().getId());
spJSON.put("studentName", bean.getStudentProject().getStudent().getLastName() + ", " + bean.getStudentProject().getStudent().getFirstName());
spJSON.put("studyProgrammeName", bean.getStudentProject().getStudent().getStudyProgramme().getName());
spJSON.put("optionality", bean.getStudentProject().getOptionality());
spJSON.put("dates", spDates);
spJSON.put("grade", gradeText.toString());
spJSON.put("passedMandatory", bean.getPassedMandatoryModuleCount() + "/" + bean.getMandatoryModuleCount());
spJSON.put("passedOptional", bean.getPassedOptionalModuleCount() + "/" + bean.getOptionalModuleCount());
studentProjectsJSON.add(spJSON);
}
String statusMessage;
Locale locale = requestContext.getRequest().getLocale();
if (studentProjectsByProjectPage.size() > 0) {
statusMessage = Messages.getInstance().getText(locale, "projects.viewProject.studentProjects.searchStatus", new Object[] { firstResult + 1, firstResult + resultsCount, numStudentProjectsTotal });
} else {
statusMessage = Messages.getInstance().getText(locale, "projects.viewProject.studentProjects.searchStatusNoMatches");
}
requestContext.addResponseParameter("studentProjects", studentProjectsJSON);
requestContext.addResponseParameter("page", page);
requestContext.addResponseParameter("pages", numPages);
requestContext.addResponseParameter("statusMessage", statusMessage);
}
use of fi.otavanopisto.pyramus.dao.courses.CourseStudentDAO in project pyramus by otavanopisto.
the class CourseStudentAPI method findIdByCourseAndStudent.
public Long findIdByCourseAndStudent(Long courseId, Long studentId) throws InvalidScriptException {
CourseDAO courseDAO = DAOFactory.getInstance().getCourseDAO();
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
Course course = courseDAO.findById(courseId);
if (course == null) {
throw new InvalidScriptException("Course #" + courseId + " not found.");
}
Student student = studentDAO.findById(studentId);
if (student == null) {
throw new InvalidScriptException("Student #" + studentId + " not found.");
}
CourseStudent courseStudent = courseStudentDAO.findByCourseAndStudent(course, student);
return courseStudent != null ? courseStudent.getId() : null;
}
use of fi.otavanopisto.pyramus.dao.courses.CourseStudentDAO in project pyramus by otavanopisto.
the class CourseStudentAPI method create.
public Long create(Long courseId, Long studentId) throws InvalidScriptException {
CourseDAO courseDAO = DAOFactory.getInstance().getCourseDAO();
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
Defaults defaults = DAOFactory.getInstance().getDefaultsDAO().getDefaults();
Course course = courseDAO.findById(courseId);
if (course == null) {
throw new InvalidScriptException("Course #" + courseId + " not found.");
}
Student student = studentDAO.findById(studentId);
if (student == null) {
throw new InvalidScriptException("Student #" + studentId + " not found.");
}
Room room = null;
BigDecimal lodgingFee = null;
Currency lodgingFeeCurrency = null;
BigDecimal reservationFee = null;
Currency reservationFeeCurrency = null;
String organization = null;
String additionalInfo = null;
try {
return courseStudentDAO.create(course, student, defaults.getInitialCourseEnrolmentType(), defaults.getInitialCourseParticipationType(), new Date(), false, CourseOptionality.OPTIONAL, null, organization, additionalInfo, room, lodgingFee, lodgingFeeCurrency, reservationFee, reservationFeeCurrency, Boolean.FALSE).getId();
} catch (DuplicateCourseStudentException dcse) {
throw new InvalidScriptException("Student #" + studentId + " has an already existing coursestudent.");
}
}
use of fi.otavanopisto.pyramus.dao.courses.CourseStudentDAO in project pyramus by otavanopisto.
the class EditStudentProjectViewController method process.
/**
* Processes the page request by including the corresponding JSP page to the response.
*
* @param pageRequestContext Page request context
*/
public void process(PageRequestContext pageRequestContext) {
StaffMemberDAO userDAO = DAOFactory.getInstance().getStaffMemberDAO();
StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
StudentProjectDAO studentProjectDAO = DAOFactory.getInstance().getStudentProjectDAO();
StudentProjectModuleDAO studentProjectModuleDAO = DAOFactory.getInstance().getStudentProjectModuleDAO();
GradingScaleDAO gradingScaleDAO = DAOFactory.getInstance().getGradingScaleDAO();
ProjectAssessmentDAO projectAssessmentDAO = DAOFactory.getInstance().getProjectAssessmentDAO();
AcademicTermDAO academicTermDAO = DAOFactory.getInstance().getAcademicTermDAO();
EducationalTimeUnitDAO educationalTimeUnitDAO = DAOFactory.getInstance().getEducationalTimeUnitDAO();
CreditLinkDAO creditLinkDAO = DAOFactory.getInstance().getCreditLinkDAO();
CourseAssessmentDAO courseAssessmentDAO = DAOFactory.getInstance().getCourseAssessmentDAO();
TransferCreditDAO transferCreditDAO = DAOFactory.getInstance().getTransferCreditDAO();
Long studentProjectId = pageRequestContext.getLong("studentproject");
List<GradingScale> gradingScales = gradingScaleDAO.listUnarchived();
StudentProject studentProject = studentProjectDAO.findById(studentProjectId);
List<StudentProjectModule> studentProjectModules = studentProjectModuleDAO.listByStudentProject(studentProject);
List<CourseStudent> courseStudents = courseStudentDAO.listByStudent(studentProject.getStudent());
List<CourseAssessment> allStudentCourseAssessments = courseAssessmentDAO.listByStudent(studentProject.getStudent());
List<TransferCredit> allStudentTransferCredits = transferCreditDAO.listByStudent(studentProject.getStudent());
List<CreditLink> allStudentCreditLinks = creditLinkDAO.listByStudent(studentProject.getStudent());
JSONArray studentProjectModulesJSON = new JSONArray();
JSONArray courseStudentsJSON = new JSONArray();
for (CreditLink creditLink : allStudentCreditLinks) {
switch(creditLink.getCredit().getCreditType()) {
case CourseAssessment:
allStudentCourseAssessments.add((CourseAssessment) creditLink.getCredit());
break;
case TransferCredit:
allStudentTransferCredits.add((TransferCredit) creditLink.getCredit());
break;
}
}
Collections.sort(studentProjectModules, new Comparator<StudentProjectModule>() {
@Override
public int compare(StudentProjectModule o1, StudentProjectModule o2) {
return o1.getModule().getName().compareTo(o2.getModule().getName());
}
});
for (StudentProjectModule studentProjectModule : studentProjectModules) {
JSONArray moduleCourseStudents = new JSONArray();
JSONArray moduleCredits = new JSONArray();
boolean hasPassingGrade = false;
List<CourseStudent> projectCourseCourseStudents = courseStudentDAO.listByModuleAndStudent(studentProjectModule.getModule(), studentProject.getStudent());
for (CourseStudent courseStudent : projectCourseCourseStudents) {
JSONObject courseStudentJson = new JSONObject();
courseStudentJson.put("courseStudentParticipationType", courseStudent.getParticipationType().getName());
// courseStudents.remove(courseStudent);
moduleCourseStudents.add(courseStudentJson);
}
for (CourseAssessment assessment : allStudentCourseAssessments) {
if (assessment.getCourseStudent().getCourse().getModule().getId().equals(studentProjectModule.getModule().getId())) {
if (assessment.getGrade() != null) {
JSONObject courseAssessment = new JSONObject();
courseAssessment.put("creditType", assessment.getCreditType().toString());
courseAssessment.put("courseName", assessment.getCourseStudent().getCourse().getName());
courseAssessment.put("gradeName", assessment.getGrade().getName());
moduleCredits.add(courseAssessment);
hasPassingGrade = hasPassingGrade || assessment.getGrade().getPassingGrade();
}
}
}
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())) {
if (tc.getGrade() != null) {
JSONObject transferCredit = new JSONObject();
transferCredit.put("creditType", tc.getCreditType().toString());
transferCredit.put("courseName", tc.getCourseName());
transferCredit.put("gradeName", tc.getGrade().getName());
moduleCredits.add(transferCredit);
hasPassingGrade = hasPassingGrade || tc.getGrade().getPassingGrade();
}
}
}
}
}
JSONObject obj = new JSONObject();
obj.put("projectModuleId", studentProjectModule.getId().toString());
obj.put("projectModuleOptionality", studentProjectModule.getOptionality().toString());
obj.put("projectModuleAcademicTermId", studentProjectModule.getAcademicTerm() != null ? studentProjectModule.getAcademicTerm().getId().toString() : "");
obj.put("projectModuleHasPassingGrade", hasPassingGrade ? "1" : "0");
obj.put("moduleId", studentProjectModule.getModule().getId());
obj.put("moduleName", studentProjectModule.getModule().getName());
obj.put("moduleCourseStudents", moduleCourseStudents);
obj.put("moduleCredits", moduleCredits);
studentProjectModulesJSON.add(obj);
}
List<Student> students = studentDAO.listByPerson(studentProject.getStudent().getPerson());
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;
}
});
List<EducationalTimeUnit> educationalTimeUnits = educationalTimeUnitDAO.listUnarchived();
Collections.sort(educationalTimeUnits, new StringAttributeComparator("getName"));
List<AcademicTerm> academicTerms = academicTermDAO.listUnarchived();
Collections.sort(academicTerms, new Comparator<AcademicTerm>() {
public int compare(AcademicTerm o1, AcademicTerm o2) {
return o1.getStartDate() == null ? -1 : o2.getStartDate() == null ? 1 : o1.getStartDate().compareTo(o2.getStartDate());
}
});
List<ProjectAssessment> assessments = projectAssessmentDAO.listByProjectAndArchived(studentProject, Boolean.FALSE);
Collections.sort(assessments, new Comparator<ProjectAssessment>() {
@Override
public int compare(ProjectAssessment o1, ProjectAssessment o2) {
return o2.getDate().compareTo(o1.getDate());
}
});
Collections.sort(courseStudents, new Comparator<CourseStudent>() {
@Override
public int compare(CourseStudent o1, CourseStudent o2) {
return o1.getCourse().getName().compareTo(o2.getCourse().getName());
}
});
for (CourseStudent courseStudent : courseStudents) {
CourseAssessment courseAssessment = courseAssessmentDAO.findLatestByCourseStudentAndArchived(courseStudent, Boolean.FALSE);
Grade grade = courseAssessment != null ? courseAssessment.getGrade() : null;
JSONObject obj = new JSONObject();
String courseName = courseStudent.getCourse().getName();
if (!StringUtils.isEmpty(courseStudent.getCourse().getNameExtension()))
courseName = courseName + " (" + courseStudent.getCourse().getNameExtension() + ")";
obj.put("courseName", courseName);
if (courseStudent.getParticipationType() != null) {
obj.put("participationType", courseStudent.getParticipationType().getName());
}
if (courseStudent.getCourse().getBeginDate() != null) {
obj.put("courseBeginDate", courseStudent.getCourse().getBeginDate().getTime());
}
if (courseStudent.getCourse().getEndDate() != null) {
obj.put("courseEndDate", courseStudent.getCourse().getEndDate().getTime());
}
obj.put("gradeName", grade != null ? grade.getName() : "");
if (courseStudent.getOptionality() != null) {
obj.put("optionality", courseStudent.getOptionality().toString());
}
obj.put("moduleId", courseStudent.getCourse().getModule().getId().toString());
obj.put("courseId", courseStudent.getCourse().getId().toString());
obj.put("courseStudentId", courseStudent.getId().toString());
courseStudentsJSON.add(obj);
}
Map<Long, String> verbalAssessments = new HashMap<>();
for (ProjectAssessment pAss : assessments) {
// Shortened descriptions
String description = pAss.getVerbalAssessment();
if (description != null) {
description = StringEscapeUtils.unescapeHtml(description.replaceAll("\\<.*?>", ""));
description = description.replaceAll("\\n", "");
verbalAssessments.put(pAss.getId(), description);
}
}
/* Tags */
StringBuilder tagsBuilder = new StringBuilder();
Iterator<Tag> tagIterator = studentProject.getTags().iterator();
while (tagIterator.hasNext()) {
Tag tag = tagIterator.next();
tagsBuilder.append(tag.getText());
if (tagIterator.hasNext())
tagsBuilder.append(' ');
}
pageRequestContext.getRequest().setAttribute("projectAssessments", assessments);
pageRequestContext.getRequest().setAttribute("verbalAssessments", verbalAssessments);
pageRequestContext.getRequest().setAttribute("studentProject", studentProject);
pageRequestContext.getRequest().setAttribute("students", students);
pageRequestContext.getRequest().setAttribute("optionalStudiesLengthTimeUnits", educationalTimeUnits);
pageRequestContext.getRequest().setAttribute("academicTerms", academicTerms);
pageRequestContext.getRequest().setAttribute("users", userDAO.listAll());
pageRequestContext.getRequest().setAttribute("gradingScales", gradingScales);
pageRequestContext.getRequest().setAttribute("tags", tagsBuilder.toString());
setJsDataVariable(pageRequestContext, "studentProjectModules", studentProjectModulesJSON.toString());
setJsDataVariable(pageRequestContext, "courseStudents", courseStudentsJSON.toString());
pageRequestContext.setIncludeJSP("/templates/projects/editstudentproject.jsp");
}
use of fi.otavanopisto.pyramus.dao.courses.CourseStudentDAO in project pyramus by otavanopisto.
the class CourseAssessmentViewController method process.
/**
* Processes the page request by including the corresponding JSP page to the response.
*
* @param pageRequestContext Page request context
*/
public void process(PageRequestContext pageRequestContext) {
CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
CourseAssessmentDAO courseAssessmentDAO = DAOFactory.getInstance().getCourseAssessmentDAO();
GradingScaleDAO gradingScaleDAO = DAOFactory.getInstance().getGradingScaleDAO();
Long courseStudentId = pageRequestContext.getLong("courseStudentId");
CourseStudent courseStudent = courseStudentDAO.findById(courseStudentId);
CourseAssessment assessment = courseAssessmentDAO.findLatestByCourseStudentAndArchived(courseStudent, Boolean.FALSE);
List<GradingScale> gradingScales = gradingScaleDAO.listUnarchived();
pageRequestContext.getRequest().setAttribute("courseStudent", courseStudent);
pageRequestContext.getRequest().setAttribute("assessment", assessment);
pageRequestContext.getRequest().setAttribute("gradingScales", gradingScales);
pageRequestContext.setIncludeJSP("/templates/grading/courseassessment.jsp");
}
Aggregations