package net.sourceforge.fenixedu.domain.inquiries;

import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.Collections;
import java.util.HashMap;
import java.util.Map;

import net.sourceforge.fenixedu.dataTransferObject.inquiries.UploadStudentInquiriesTeachingResultsBean;
import net.sourceforge.fenixedu.domain.ExecutionCourse;
import net.sourceforge.fenixedu.domain.ExecutionDegree;
import net.sourceforge.fenixedu.domain.Professorship;
import net.sourceforge.fenixedu.domain.RootDomainObject;
import net.sourceforge.fenixedu.domain.ShiftType;
import net.sourceforge.fenixedu.domain.Teacher;
import net.sourceforge.fenixedu.domain.exceptions.DomainException;

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

import pt.ist.fenixWebFramework.services.Service;

public class StudentInquiriesTeachingResult extends StudentInquiriesTeachingResult_Base {

    transient private Map<String, String> valuesMap = null;

    public StudentInquiriesTeachingResult() {
	super();
	setRootDomainObject(RootDomainObject.getInstance());
    }

    private Double getValueForPresentation(Double value) {
	// TODO: ugly hack, refactor
	if (value == null) {
	    return Double.valueOf(0);
	}
	BigDecimal round = new BigDecimal(value);
	// @Linkare(author = "Paulo Zenida", comments =
	// "Prevented the violation of a Useless operation on imutable")
	round = round.setScale(2, RoundingMode.HALF_EVEN);
	return round.doubleValue();
    }

    public Double getAverage_P6_1ForPresentation() {
	return getValueForPresentation(super.getAverage_P6_1());
    }

    public Double getStandardDeviation_P6_1ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P6_1());
    }

    public Double getP6_1_greater_3ForPresentation() {
	return getValueForPresentation(super.getP6_1_greater_3());
    }

    public Double getPerc_P6_1_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_1());
    }

    public Double getPerc_P6_1_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_2());
    }

    public Double getPerc_P6_1_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_3());
    }

    public Double getPerc_P6_1_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_4());
    }

    public Double getPerc_P6_1_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_5());
    }

    public Double getPerc_P6_1_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_6());
    }

    public Double getPerc_P6_1_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_7());
    }

    public Double getP6_1_1_aForPresentation() {
	return getValueForPresentation(super.getP6_1_1_a());
    }

    public Double getP6_1_1_bForPresentation() {
	return getValueForPresentation(super.getP6_1_1_b());
    }

    public Double getP6_1_1_cForPresentation() {
	return getValueForPresentation(super.getP6_1_1_c());
    }

    public Double getP6_1_1_dForPresentation() {
	return getValueForPresentation(super.getP6_1_1_d());
    }

    public Double getP6_1_1_eForPresentation() {
	return getValueForPresentation(super.getP6_1_1_e());
    }

    public Double getPerc_P6_1_aForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_a());
    }

    public Double getPerc_P6_1_bForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_b());
    }

    public Double getPerc_P6_1_cForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_c());
    }

    public Double getPerc_P6_1_dForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_d());
    }

    public Double getPerc_P6_1_eForPresentation() {
	return getValueForPresentation(super.getPerc_P6_1_e());
    }

    public Double getAverage_P6_2ForPresentation() {
	return getValueForPresentation(super.getAverage_P6_2());
    }

    public Double getStandardDeviation_P6_2ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P6_2());
    }

    public Double getPerc_P6_2_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_1());
    }

    public Double getPerc_P6_2_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_2());
    }

    public Double getPerc_P6_2_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_3());
    }

    public Double getPerc_P6_2_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_4());
    }

    public Double getPerc_P6_2_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_5());
    }

    public Double getPerc_P6_2_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_6());
    }

    public Double getPerc_P6_2_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_7());
    }

    public Double getPerc_P6_2_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_8());
    }

    public Double getPerc_P6_2_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_2_9());
    }

    public Double getAverage_P6_3ForPresentation() {
	return getValueForPresentation(super.getAverage_P6_3());
    }

    public Double getStandardDeviation_P6_3ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P6_3());
    }

    public Double getPerc_P6_3_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_1());
    }

    public Double getPerc_P6_3_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_2());
    }

    public Double getPerc_P6_3_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_3());
    }

    public Double getPerc_P6_3_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_4());
    }

    public Double getPerc_P6_3_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_5());
    }

    public Double getPerc_P6_3_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_6());
    }

    public Double getPerc_P6_3_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_7());
    }

    public Double getPerc_P6_3_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_8());
    }

    public Double getPerc_P6_3_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P6_3_9());
    }

    public Double getAverage_P7_1ForPresentation() {
	return getValueForPresentation(super.getAverage_P7_1());
    }

    public Double getStandardDeviation_P7_1ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P7_1());
    }

    public Double getPerc_P7_1_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_1());
    }

    public Double getPerc_P7_1_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_2());
    }

    public Double getPerc_P7_1_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_3());
    }

    public Double getPerc_P7_1_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_4());
    }

    public Double getPerc_P7_1_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_5());
    }

    public Double getPerc_P7_1_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_6());
    }

    public Double getPerc_P7_1_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_7());
    }

    public Double getPerc_P7_1_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_8());
    }

    public Double getPerc_P7_1_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_1_9());
    }

    public Double getAverage_P7_2ForPresentation() {
	return getValueForPresentation(super.getAverage_P7_2());
    }

    public Double getStandardDeviation_P7_2ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P7_2());
    }

    public Double getPerc_P7_2_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_1());
    }

    public Double getPerc_P7_2_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_2());
    }

    public Double getPerc_P7_2_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_3());
    }

    public Double getPerc_P7_2_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_4());
    }

    public Double getPerc_P7_2_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_5());
    }

    public Double getPerc_P7_2_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_6());
    }

    public Double getPerc_P7_2_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_7());
    }

    public Double getPerc_P7_2_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_8());
    }

    public Double getPerc_P7_2_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_2_9());
    }

    public Double getAverage_P7_3ForPresentation() {
	return getValueForPresentation(super.getAverage_P7_3());
    }

    public Double getStandardDeviation_P7_3ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P7_3());
    }

    public Double getPerc_P7_3_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_1());
    }

    public Double getPerc_P7_3_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_2());
    }

    public Double getPerc_P7_3_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_3());
    }

    public Double getPerc_P7_3_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_4());
    }

    public Double getPerc_P7_3_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_5());
    }

    public Double getPerc_P7_3_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_6());
    }

    public Double getPerc_P7_3_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_7());
    }

    public Double getPerc_P7_3_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_8());
    }

    public Double getPerc_P7_3_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_3_9());
    }

    public Double getAverage_P7_4ForPresentation() {
	return getValueForPresentation(super.getAverage_P7_4());
    }

    public Double getStandardDeviation_P7_4ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P7_4());
    }

    public Double getPerc_P7_4_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_1());
    }

    public Double getPerc_P7_4_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_2());
    }

    public Double getPerc_P7_4_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_3());
    }

    public Double getPerc_P7_4_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_4());
    }

    public Double getPerc_P7_4_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_5());
    }

    public Double getPerc_P7_4_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_6());
    }

    public Double getPerc_P7_4_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_7());
    }

    public Double getPerc_P7_4_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_8());
    }

    public Double getPerc_P7_4_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P7_4_9());
    }

    public Double getAverage_P8_1ForPresentation() {
	return getValueForPresentation(super.getAverage_P8_1());
    }

    public Double getStandardDeviation_P8_1ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P8_1());
    }

    public Double getPerc_P8_1_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_1());
    }

    public Double getPerc_P8_1_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_2());
    }

    public Double getPerc_P8_1_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_3());
    }

    public Double getPerc_P8_1_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_4());
    }

    public Double getPerc_P8_1_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_5());
    }

    public Double getPerc_P8_1_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_6());
    }

    public Double getPerc_P8_1_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_7());
    }

    public Double getPerc_P8_1_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_8());
    }

    public Double getPerc_P8_1_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_1_9());
    }

    public Double getAverage_P8_2ForPresentation() {
	return getValueForPresentation(super.getAverage_P8_2());
    }

    public Double getStandardDeviation_P8_2ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P8_2());
    }

    public Double getPerc_P8_2_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_1());
    }

    public Double getPerc_P8_2_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_2());
    }

    public Double getPerc_P8_2_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_3());
    }

    public Double getPerc_P8_2_4ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_4());
    }

    public Double getPerc_P8_2_5ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_5());
    }

    public Double getPerc_P8_2_6ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_6());
    }

    public Double getPerc_P8_2_7ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_7());
    }

    public Double getPerc_P8_2_8ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_8());
    }

    public Double getPerc_P8_2_9ForPresentation() {
	return getValueForPresentation(super.getPerc_P8_2_9());
    }

    public Double getAverage_P9ForPresentation() {
	return getValueForPresentation(super.getAverage_P9());
    }

    public Double getStandardDeviation_P9ForPresentation() {
	return getValueForPresentation(super.getStandardDeviation_P9());
    }

    public Double getPerc_P9_1ForPresentation() {
	return getValueForPresentation(super.getPerc_P9_1());
    }

    public Double getPerc_P9_2ForPresentation() {
	return getValueForPresentation(super.getPerc_P9_2());
    }

    public Double getPerc_P9_3ForPresentation() {
	return getValueForPresentation(super.getPerc_P9_3());
    }

    public Map<String, String> getValuesMap() {
	if (this.valuesMap == null) {
	    synchronized (this) {
		if (this.valuesMap == null) {
		    Map<String, String> tmpMap = new HashMap<String, String>();
		    if (!StringUtils.isEmpty(getHeaders()) && !StringUtils.isEmpty(getRawValues())) {
			String[] headers = getHeaders().split("\t");
			String[] values = getRawValues().split("\t");
			for (int i = 0; i < values.length; i++) {
			    tmpMap.put(headers[i], values[i]);
			}
		    }
		    this.valuesMap = Collections.unmodifiableMap(tmpMap);
		}
	    }
	}
	return valuesMap;
    }

    private static int getHeaderIndex(String headerToFind, String[] headersSplitted) {
	for (int i = 0; i < headersSplitted.length; i++) {
	    if (headerToFind.equals(headersSplitted[i])) {
		return i;
	    }
	}
	throw new DomainException("error.StudentInquiriesTeachingResult.headerNotFound", headerToFind);
    }

    private static Boolean fieldToBoolean(String field) {
	return !StringUtils.isEmpty(field) && (field.equalsIgnoreCase("true") || field.equals("1"));
    }

    public boolean isUnsatisfactory() {
	return getUnsatisfactoryResultsAssiduity() || getUnsatisfactoryResultsPedagogicalCapacity()
		|| getUnsatisfactoryResultsPresencialLearning() || getUnsatisfactoryResultsStudentInteraction();
    }

    public boolean isExcellent() {
	return getExcellentResultsAssiduity() || getExcellentResultsPedagogicalCapacity()
		|| getExcellentResultsPresencialLearning() || getExcellentResultsStudentInteraction();
    }

    @Override
    public Boolean getUnsatisfactoryResultsAssiduity() {
	return super.getUnsatisfactoryResultsAssiduity() != null && super.getUnsatisfactoryResultsAssiduity();
    }

    @Override
    public Boolean getUnsatisfactoryResultsAuditable() {
	return super.getUnsatisfactoryResultsAuditable() != null && super.getUnsatisfactoryResultsAuditable();
    }

    @Override
    public Boolean getUnsatisfactoryResultsPedagogicalCapacity() {
	return super.getUnsatisfactoryResultsPedagogicalCapacity() != null && super.getUnsatisfactoryResultsPedagogicalCapacity();
    }

    @Override
    public Boolean getUnsatisfactoryResultsPresencialLearning() {
	return super.getUnsatisfactoryResultsPresencialLearning() != null && super.getUnsatisfactoryResultsPresencialLearning();
    }

    @Override
    public Boolean getUnsatisfactoryResultsStudentInteraction() {
	return super.getUnsatisfactoryResultsStudentInteraction() != null && super.getUnsatisfactoryResultsStudentInteraction();
    }

    @Override
    public Boolean getInternalDegreeDisclosure() {
	return super.getInternalDegreeDisclosure() != null && super.getInternalDegreeDisclosure();
    }

    public Boolean getExcellentResultsAssiduity() {
	return fieldToBoolean(getValuesMap().get("Res_excelentes_assiduidade"));
    }

    public Boolean getExcellentResultsPedagogicalCapacity() {
	return fieldToBoolean(getValuesMap().get("Res_excelentes_cap_pedag"));
    }

    public Boolean getExcellentResultsPresencialLearning() {
	return fieldToBoolean(getValuesMap().get("Res_excelentes_prov_aprend_pres"));
    }

    public Boolean getExcellentResultsStudentInteraction() {
	return fieldToBoolean(getValuesMap().get("Res_excelentes_int_alunos"));
    }

    @Override
    public Boolean getPublicDegreeDisclosure() {
	if (super.getPublicDegreeDisclosure() != null) {
	    return super.getPublicDegreeDisclosure();
	}
	return getValuesMap().containsKey("Repres_doc_curso_UC_publica") ? fieldToBoolean(getValuesMap().get(
		"Repres_doc_curso_UC_publica")) : false;
    }

    @Service
    public static void importResults(String headers, String values, UploadStudentInquiriesTeachingResultsBean resultsBean) {

	String[] headersSplitted = headers.split("\t");

	int executionCourseHeaderIndex = getHeaderIndex(resultsBean.getKeyExecutionCourseHeader(), headersSplitted);
	int executionDegreeHeaderIndex = getHeaderIndex(resultsBean.getKeyExecutionDegreeHeader(), headersSplitted);
	int teacherHeaderIndex = getHeaderIndex(resultsBean.getKeyTeacherHeader(), headersSplitted);
	int shiftTypeHeaderIndex = getHeaderIndex(resultsBean.getShiftTypeHeader(), headersSplitted);

	int unsatisfactoryResultsAssiduityIndex = getHeaderIndex(resultsBean.getUnsatisfactoryResultsAssiduityHeader(),
		headersSplitted);
	int unsatisfactoryResultsPedagogicalCapacityIndex = getHeaderIndex(resultsBean
		.getUnsatisfactoryResultsPedagogicalCapacityHeader(), headersSplitted);
	int unsatisfactoryResultsPresencialLearningIndex = getHeaderIndex(resultsBean
		.getUnsatisfactoryResultsPresencialLearningHeader(), headersSplitted);
	int unsatisfactoryResultsStudentInteractionIndex = getHeaderIndex(resultsBean
		.getUnsatisfactoryResultsStudentInteractionHeader(), headersSplitted);
	int internalDegreeDisclosureIndex = getHeaderIndex(resultsBean.getInternalDegreeDisclosureHeader(), headersSplitted);

	for (String row : values.split("\n")) {
	    String[] columns = row.split("\t");

	    ExecutionCourse executionCourse = RootDomainObject.getInstance().readExecutionCourseByOID(
		    Integer.valueOf(columns[executionCourseHeaderIndex]));
	    if (executionCourse == null) {
		throw new DomainException("error.StudentInquiriesCourseResult.executionCourseNotFound",
			columns[executionCourseHeaderIndex]);
	    }

	    ExecutionDegree executionDegree = RootDomainObject.getInstance().readExecutionDegreeByOID(
		    Integer.valueOf(columns[executionDegreeHeaderIndex]));
	    if (executionDegree == null) {
		throw new DomainException("error.StudentInquiriesCourseResult.executionDegreeNotFound",
			columns[executionDegreeHeaderIndex]);
	    }

	    Teacher teacher = RootDomainObject.getInstance().readTeacherByOID(Integer.valueOf(columns[teacherHeaderIndex]));
	    if (teacher == null) {
		throw new DomainException("error.StudentInquiriesCourseResult.teacherNotFound", columns[teacherHeaderIndex]);
	    }

	    Professorship professorship = teacher.getProfessorshipByExecutionCourse(executionCourse);
	    if (professorship == null) {
		throw new DomainException("error.StudentInquiriesCourseResult.professorshipNotFound",
			columns[teacherHeaderIndex], columns[executionCourseHeaderIndex]);
	    }

	    final ShiftType shiftType = ShiftType.valueOf(columns[shiftTypeHeaderIndex]);
	    StudentInquiriesTeachingResult studentInquiriesTeachingResult = professorship.getStudentInquiriesTeachingResult(
		    executionDegree, shiftType);

	    if (studentInquiriesTeachingResult == null) {
		studentInquiriesTeachingResult = new StudentInquiriesTeachingResult();
		studentInquiriesTeachingResult.setShiftType(shiftType);
		studentInquiriesTeachingResult.setExecutionDegree(executionDegree);
		studentInquiriesTeachingResult.setProfessorship(professorship);
	    }

	    studentInquiriesTeachingResult.setRawValues(row);
	    studentInquiriesTeachingResult.setHeaders(headers);
	    studentInquiriesTeachingResult.setUploadDateTime(new DateTime());
	    studentInquiriesTeachingResult.setResultsDate(resultsBean.getResultsDate());

	    studentInquiriesTeachingResult
		    .setUnsatisfactoryResultsAssiduity(fieldToBoolean(columns[unsatisfactoryResultsAssiduityIndex]));
	    studentInquiriesTeachingResult
		    .setUnsatisfactoryResultsPedagogicalCapacity(fieldToBoolean(columns[unsatisfactoryResultsPedagogicalCapacityIndex]));
	    studentInquiriesTeachingResult
		    .setUnsatisfactoryResultsPresencialLearning(fieldToBoolean(columns[unsatisfactoryResultsPresencialLearningIndex]));
	    studentInquiriesTeachingResult
		    .setUnsatisfactoryResultsStudentInteraction(fieldToBoolean(columns[unsatisfactoryResultsStudentInteractionIndex]));
	    studentInquiriesTeachingResult.setInternalDegreeDisclosure(fieldToBoolean(columns[internalDegreeDisclosureIndex]));
	    studentInquiriesTeachingResult.valuesMap = null;

	}

    }

}