<?php
/**
 * Copyright 2016 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 Fee implements IExport {
	public function getDisplayName() {
		return "Fee per local";
	}
	
	public function getDescription() {
		return "This export contains all bodies.";
	}
	
	public function hasAccess() {
		return in_array("export_fee", $_SESSION['sess_functions']);
	}
	
	/**
	 * Get an array with the column headers. The keys should match with the keys in getData()
	 */
	public function getHeaders() {
		$columns = array();
		$columns['BodyCode'] = "Code";
		$columns['BodyName'] = "Body";
		$columns['CurrencyLocal'] = "Local currency";
		$columns['FeeLocal'] = "Membership fee (local currency)";
		$columns['FeeEuro'] = "Membership fee (€)";
		$columns['Count'] = "Count";
		
		return $columns;
	}
	
	public function getData() {
		$data = array();
		
		if( @mysql_num_rows( $res=doquery($this->getDataQuery()) )>0 ) {
			while( $row = mysql_fetch_assoc($res) ) {
				$row['CurrencyLocal'] = html_entity_decode($row['CurrencyLocal']);
				$data[] = $row;
			}
		}
		
		return $data;
	}
	
	private function getDataQuery() {
		$query = "SELECT `ab_bodies`.`BodyCode`, `ab_bodies`.`BodyName`, ";
		$query .= "  IF(`currencies`.`ISO_2`='EU', '', `currencies`.`short`) AS `CurrencyLocal`, ";
		$query .= "  IF(`currencies`.`ISO_2`='EU', '', `memberlist`.`Fee`) AS `FeeLocal`, ";
		$query .= "  ROUND(`currencies`.`rate`*`memberlist`.`Fee`, 2) AS `FeeEuro`, ";
		$query .= "  COUNT(*) AS `Count` ";
		$query .= "FROM `memberlist` ";
		$query .= "INNER JOIN `ab_bodies` ON `ab_bodies`.`BodyCode` = `memberlist`.`BodyCode` ";
		$query .= "INNER JOIN `currencies` ON `currencies`.`id` = `ab_bodies`.`MemberFeeCurrencyId` ";
		$query .= "GROUP BY `ab_bodies`.`BodyName`, `memberlist`.`Fee` ";
		$query .= "ORDER BY `ab_bodies`.`BodyName`, `memberlist`.`Fee`";
		return $query;
	}
}
?>