@Override
public void renderReport(final Spreadsheet spreadsheet) throws Exception {
spreadsheet.setHeader("Número");
spreadsheet.setHeader("Sexo");
spreadsheet.setHeader("Média");
spreadsheet.setHeader("Média Anual");
spreadsheet.setHeader("Número Inscrições");
spreadsheet.setHeader("Número Aprovações");
spreadsheet.setHeader("Nota de Seriação");
spreadsheet.setHeader("Local de Origem");
final ExecutionYear executionYear = getExecutionYear();
for (final Degree degree : Degree.readNotEmptyDegrees()) {
if (checkDegreeType(getDegreeType(), degree)) {
if (isActive(degree)) {
for (final Registration registration : degree.getRegistrationsSet()) {
if (registration.isRegistered(getExecutionYear())) {
int enrolmentCounter = 0;
int aprovalCounter = 0;
BigDecimal bigDecimal = null;
double totalCredits = 0;
for (final Registration otherRegistration :
registration.getStudent().getRegistrationsSet()) {
if (otherRegistration.getDegree() == registration.getDegree()) {
for (final StudentCurricularPlan studentCurricularPlan :
otherRegistration.getStudentCurricularPlansSet()) {
for (final Enrolment enrolment : studentCurricularPlan.getEnrolmentsSet()) {
final ExecutionSemester executionSemester = enrolment.getExecutionPeriod();
if (executionSemester.getExecutionYear() == executionYear) {
enrolmentCounter++;
if (enrolment.isApproved()) {
aprovalCounter++;
final Grade grade = enrolment.getGrade();
if (grade.isNumeric()) {
final double credits =
enrolment.getEctsCreditsForCurriculum().doubleValue();
totalCredits += credits;
bigDecimal =
bigDecimal == null
? grade.getNumericValue().multiply(new BigDecimal(credits))
: bigDecimal.add(
grade.getNumericValue().multiply(new BigDecimal(credits)));
}
}
}
}
}
}
}
final Row row = spreadsheet.addRow();
row.setCell(registration.getNumber().toString());
row.setCell(registration.getPerson().getGender().toLocalizedString());
row.setCell(registration.getAverage(executionYear));
if (bigDecimal == null) {
row.setCell("");
} else {
row.setCell(
bigDecimal.divide(new BigDecimal(totalCredits), 5, RoundingMode.HALF_UP));
}
row.setCell(Integer.toString(enrolmentCounter));
row.setCell(Integer.toString(aprovalCounter));
row.setCell(
registration.getEntryGrade() != null
? registration.getEntryGrade().toString()
: StringUtils.EMPTY);
Boolean dislocated = null;
if (registration.hasStudentCandidacy()) {
dislocated =
registration.getStudentCandidacy().getDislocatedFromPermanentResidence();
}
final String dislocatedString =
dislocated == null
? ""
: (dislocated.booleanValue() ? "Deslocado" : "Não Deslocado");
row.setCell(dislocatedString);
}
}
}
}
}
}
