net.sourceforge.fenixedu.domain.reports.GraduationReportFile.java Source code

Introduction

Here is the source code for net.sourceforge.fenixedu.domain.reports.GraduationReportFile.java

Source

/**
 * Copyright  2002 Instituto Superior Tcnico
 *
 * This file is part of FenixEdu Core.
 *
 * FenixEdu Core is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * FenixEdu Core is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with FenixEdu Core.  If not, see <http://www.gnu.org/licenses/>.
 */
package net.sourceforge.fenixedu.domain.reports;

import java.util.Collections;
import java.util.Set;

import net.sourceforge.fenixedu.domain.ExecutionYear;
import net.sourceforge.fenixedu.domain.Person;
import net.sourceforge.fenixedu.domain.SchoolLevelType;
import net.sourceforge.fenixedu.domain.contacts.PhysicalAddress;
import net.sourceforge.fenixedu.domain.student.Registration;
import net.sourceforge.fenixedu.domain.student.curriculum.ConclusionProcess;
import net.sourceforge.fenixedu.domain.student.curriculum.CycleConclusionProcess;

import org.apache.commons.lang.StringUtils;
import org.joda.time.LocalDate;

import pt.utl.ist.fenix.tools.util.excel.Spreadsheet;
import pt.utl.ist.fenix.tools.util.excel.Spreadsheet.Row;

public class GraduationReportFile extends GraduationReportFile_Base {

    public GraduationReportFile() {
        super();
    }

    @Override
    public String getJobName() {
        return "Listagem de diplomados";
    }

    @Override
    protected String getPrefix() {
        return "diplomados";
    }

    @Override
    public void renderReport(Spreadsheet spreadsheet) {
        spreadsheet.setHeader("nmero aluno");
        spreadsheet.setHeader("nome");
        setDegreeHeaders(spreadsheet);
        spreadsheet.setHeader("ciclo");
        spreadsheet.setHeader("Nota Concluso Secundrio");
        spreadsheet.setHeader("Nota Seriao");
        spreadsheet.setHeader("ano de ingresso");
        spreadsheet.setHeader("ano lectivo concluso");
        spreadsheet.setHeader("data concluso");
        spreadsheet.setHeader("nmero de anos para concluso");
        spreadsheet.setHeader("mdia final");
        spreadsheet.setHeader("morada");
        spreadsheet.setHeader("cdigo postal");
        spreadsheet.setHeader("cidade");
        spreadsheet.setHeader("pas");
        spreadsheet.setHeader("telefone");
        spreadsheet.setHeader("telemovel");
        spreadsheet.setHeader("email");
        spreadsheet.setHeader("sexo");
        spreadsheet.setHeader("data nascimento");

        final Set<ExecutionYear> toInspectSet = getExecutionYear() == null
                ? getRootDomainObject().getExecutionYearsSet()
                : Collections.singleton(getExecutionYear());

        for (final ExecutionYear toInspect : toInspectSet) {
            for (final ConclusionProcess conclusionProcess : toInspect.getConclusionProcessesConcludedSet()) {
                if (checkDegreeType(getDegreeType(), conclusionProcess)) {
                    reportGraduate(spreadsheet, conclusionProcess);
                }
            }
        }
    }

    private void reportGraduate(final Spreadsheet sheet, final ConclusionProcess conclusionProcess) {
        final Row row = sheet.addRow();

        final Registration registration = conclusionProcess.getRegistration();
        final ExecutionYear ingression = conclusionProcess.getIngressionYear();
        final ExecutionYear conclusion = conclusionProcess.getConclusionYear();
        final LocalDate conclusionDate = conclusionProcess.getConclusionDate();

        row.setCell(registration.getNumber());
        row.setCell(registration.getName());
        setDegreeCells(row, registration.getDegree());
        if (conclusionProcess.isCycleConclusionProcess()) {
            row.setCell(((CycleConclusionProcess) conclusionProcess).getCycleType().getDescription());
        } else {
            row.setCell(StringUtils.EMPTY);
        }
        row.setCell(registration.getPrecedentDegreeConclusionGrade(SchoolLevelType.SECOND_CYCLE_BASIC_SCHOOL));
        row.setCell(
                registration.getEntryGrade() != null ? registration.getEntryGrade().toString() : StringUtils.EMPTY);
        row.setCell(ingression.getYear());
        row.setCell(conclusion == null ? StringUtils.EMPTY : conclusion.getYear());
        row.setCell(conclusionDate == null ? StringUtils.EMPTY : conclusionDate.toString("yyyy-MM-dd"));
        row.setCell(conclusion == null ? StringUtils.EMPTY
                : String.valueOf(ingression.getDistanceInCivilYears(conclusion) + 1));
        row.setCell(conclusionProcess.getFinalAverage());

        setPersonCells(registration, row);
    }

    private void setPersonCells(final Registration registration, final Row row) {
        final Person person = registration.getPerson();

        final PhysicalAddress defaultPhysicalAddress = person.getDefaultPhysicalAddress();

        if (defaultPhysicalAddress != null) {
            row.setCell(defaultPhysicalAddress.getAddress());
            row.setCell(defaultPhysicalAddress.getPostalCode());
            row.setCell(defaultPhysicalAddress.getArea());
            row.setCell(defaultPhysicalAddress.getCountryOfResidence() == null ? StringUtils.EMPTY
                    : defaultPhysicalAddress.getCountryOfResidence().getName());
        } else {
            row.setCell(StringUtils.EMPTY);
            row.setCell(StringUtils.EMPTY);
            row.setCell(StringUtils.EMPTY);
            row.setCell(StringUtils.EMPTY);
        }

        row.setCell(person.getDefaultPhoneNumber());
        row.setCell(person.getDefaultMobilePhoneNumber());
        row.setCell(person.getInstitutionalOrDefaultEmailAddressValue());
        row.setCell(person.getGender().toLocalizedString());
        row.setCell(person.getDateOfBirthYearMonthDay() != null
                ? person.getDateOfBirthYearMonthDay().toString("yyyy-MM-dd")
                : StringUtils.EMPTY);
    }
}