<?php
/**
 * Copyright 2014 Wim van Ravesteijn
 *
 * This file is part of AEGEE-Europe Statutory Event Applications.
 *
 * AEGEE-Europe Statutory Event Applications is free software: you can
 * redistribute it and/or modify it under the terms of the GNU General
 * Public License as published by the Free Software Foundation, either
 * version 3 of the License, or (at your option) any later version.
 *
 * AEGEE-Europe Statutory Event Applications 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with AEGEE-Europe Statutory Event Applications.  If not, see
 * <http://www.gnu.org/licenses/>.
 */
class Motivation implements IExport {
	public function getDisplayName() {
		return "Motivation and extra questions of applicants";
	}
	
	public function hasAccess() {
		return in_array("application_viewdetail", $_SESSION['sess_functions']) && in_array("applicationfield_optionview", $_SESSION['sess_functions']);
	}

	public function getHeaders() {
		global $setup;
		
		$columns = array();
		$columns['GivenName'] = "Given name";
		$columns['Surname'] = "Surname";
		$columns['Body'] = "Body";
		if( $setup['ApplShowMotivation'] ) {
			$columns['Motivation'] = "Motivation";
		}
		$query = "SELECT `id`, `question` FROM `appl_extraquestions` ORDER BY `order`";
		if( @mysql_num_rows( $res=doquery($query) )>0 ) {
			while( $row = mysql_fetch_assoc($res) ) {
				$columns['ExtraQuestion_' . $row['id']] = $row['question'];
			}
		}
		
		return $columns;
	}
	
	public function getData() {
		$data = array();
		
		if( @mysql_num_rows( $res=doquery($this->getDataQuery()) )>0 ) {
			while( $row = mysql_fetch_assoc($res) ) {
				$data[] = $row;
			}
		}
		
		return $data;
	}
	
	private function getDataQuery() {
		$query = "SELECT `persons`.`FirstName` AS `GivenName`, `persons`.`LastName` AS `Surname`";
		$query .= ", `ab_bodies`.`BodyName` AS `Body`";
		if( $setup['ApplShowMotivation'] ) {
			$query .= ", `persons`.`Motivation` AS `Motivation`";
		}
		$joins = " LEFT JOIN `ab_bodies` ON `ab_bodies`.`BodyCode` = `persons`.`BodyCode`";
		$queryExtraQuestions = "SELECT `id`, `question` FROM `appl_extraquestions` ORDER BY `order`";
		if( @mysql_num_rows( $res=doquery($queryExtraQuestions) )>0 ) {
			while( $row = mysql_fetch_assoc($res) ) {
				$query .= ", `ExtraAnswer_" . $row['id'] . "`.`answer` AS `ExtraQuestion_" . $row['id'] . "`";
				$joins .= " LEFT JOIN `appl_extraanswers` AS `ExtraAnswer_" . $row['id'] . "` ON `ExtraAnswer_" . $row['id'] . "`.`appl_id` = `persons`.`PersonID` AND `ExtraAnswer_" . $row['id'] . "`.`question_id` = " . $row['id'];
			}
		}
		$query .= " FROM `persons`";
		$query .= $joins;
		$query .= " ORDER BY `ab_bodies`.`BodyCategoryOrder`, `ab_bodies`.`BodyNameAscii`, `persons`.`FirstName`, `persons`.`LastName`";
		return $query;
	}
}
?>