/**
* Copyright © 2002 Instituto Superior Técnico
*
* This file is part of FenixEdu Academic.
*
* FenixEdu Academic 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 Academic 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 Academic. If not, see <http://www.gnu.org/licenses/>.
*/
package org.fenixedu.academic.ui.struts.action.administrativeOffice.student.candidacy.registrations;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Set;
import org.apache.commons.lang.StringUtils;
import org.fenixedu.academic.domain.Degree;
import org.fenixedu.academic.domain.ExecutionYear;
import org.fenixedu.academic.domain.Person;
import org.fenixedu.academic.domain.candidacy.StudentCandidacy;
import org.fenixedu.academic.domain.contacts.EmailAddress;
import org.fenixedu.academic.domain.organizationalStructure.Unit;
import org.fenixedu.academic.util.Bundle;
import org.fenixedu.bennu.core.i18n.BundleUtil;
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 RegisteredDegreeCandidaciesWithApplyForResidence {
private final RegisteredDegreeCandidaciesSelectionBean bean;
public RegisteredDegreeCandidaciesWithApplyForResidence(
RegisteredDegreeCandidaciesSelectionBean registeredDegreeCandidaciesSelectionBean) {
this.bean = registeredDegreeCandidaciesSelectionBean;
}
public List<StudentCandidacy> search(Set<Degree> allowedDegrees) {
final List<StudentCandidacy> degreeCandidacies = this.bean.search(allowedDegrees);
final List<StudentCandidacy> result = new ArrayList<StudentCandidacy>();
for (StudentCandidacy studentCandidacy : degreeCandidacies) {
if ((studentCandidacy.getApplyForResidence() != null && studentCandidacy.getApplyForResidence())
|| !StringUtils.isEmpty(studentCandidacy.getNotesAboutResidenceAppliance())) {
result.add(studentCandidacy);
}
}
Collections.sort(result, RegisteredDegreeCandidaciesSelectionBean.DEGREE_CANDIDACIES_COMPARATOR);
return result;
}
public Spreadsheet export(Set<Degree> allowedDegrees) {
final Spreadsheet spreadsheet = new Spreadsheet("Candidatura a Residencia");
addHeaders(spreadsheet);
for (final StudentCandidacy candidacy : search(allowedDegrees)) {
addRow(spreadsheet, candidacy);
}
return spreadsheet;
}
public String getFilename() {
return new LocalDate().toString("dd-MM-yyyy") + ".Candidatos.Residencia.xls";
}
private void addHeaders(Spreadsheet spreadsheet) {
spreadsheet.setHeader("Data de Matricula");
spreadsheet.setHeader("Curso");
spreadsheet.setHeader("Nº de Aluno");
spreadsheet.setHeader("Nome");
spreadsheet.setHeader("Nota de Seriacao");
spreadsheet.setHeader("Localidade");
spreadsheet.setHeader("Concelho");
spreadsheet.setHeader("Distrito");
spreadsheet.setHeader("Email " + Unit.getInstitutionAcronym());
spreadsheet.setHeader("Email pessoal");
spreadsheet.setHeader("Telefone");
spreadsheet.setHeader("Telemovel");
spreadsheet.setHeader("Candidatou-se");
spreadsheet.setHeader("Nota sobre Candidatura");
}
private void addRow(Spreadsheet spreadsheet, StudentCandidacy candidacy) {
final Person person = candidacy.getPerson();
final Row row = spreadsheet.addRow();
row.setCell(candidacy.getActiveCandidacySituation().getSituationDate().toString("dd/MM/yyyy HH:mm"));
row.setCell(candidacy.getExecutionDegree().getDegree().getNameFor(ExecutionYear.readCurrentExecutionYear()).getContent());
row.setCell(candidacy.getRegistration().getStudent().getNumber());
row.setCell(person.getName());
row.setCell(getEntryGrade(candidacy));
row.setCell(person.getArea());
row.setCell(person.getDistrictSubdivisionOfResidence());
row.setCell(person.getDistrictOfResidence());
row.setCell(person.getInstitutionalEmailAddressValue());
row.setCell(getPersonalEmailAddress(person));
row.setCell(getPhone(person));
row.setCell(getMobilePhone(person));
row.setCell(BundleUtil.getString(Bundle.ACADEMIC, candidacy.getApplyForResidence() ? "label.yes" : "label.no"));
row.setCell(candidacy.getNotesAboutResidenceAppliance().replaceAll("\n", " ").replaceAll("\r", " "));
}
private BigDecimal getEntryGrade(final StudentCandidacy candidacy) {
return new BigDecimal(candidacy.getEntryGrade().doubleValue()).setScale(2, BigDecimal.ROUND_HALF_EVEN);
}
private String getPersonalEmailAddress(final Person person) {
for (final EmailAddress email : person.getEmailAddresses()) {
if (email.isPersonalType() && email.hasValue()) {
return email.getValue();
}
}
return "";
}
private String getPhone(final Person person) {
return person.hasDefaultPhone() && person.getDefaultPhone().hasNumber() ? person.getDefaultPhone().getNumber() : "";
}
private String getMobilePhone(final Person person) {
return person.hasDefaultMobilePhone() && person.getDefaultMobilePhone().hasNumber() ? person.getDefaultMobilePhone()
.getNumber() : "";
}
}