<?php
	/**
	 * Copyright 2000, 2001, 2002 Philipp von Klitzing
	 * Copyright 2003, 2004, 2005, 2006, 2007, 2008, 2009 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/>.
	 */
	require_once("./include/include.php");
	require_once("./include/IExport.php");
	
	$exports = array();
	$dir = dirname($_SERVER["SCRIPT_FILENAME"])."/Exports/*.php";
	if( is_dir(dirname($dir)) ) {
		foreach( glob($dir) as $file ) {
			if( is_file($file) ) {
				$className = basename($file, ".php");
				require_once($file);
				$exports[$className] = new $className;
			}
		}
	}else {
		debug(dirname($dir)." does not exist, failed loading exports");
	}
	
	$colSeparators = array();
	$colSeparators['semicolon'] = ";";
	$colSeparators['comma'] = ",";
	if( isset( $_POST['columnSeparator']) && array_key_exists($_POST['columnSeparator'], $colSeparators) ) {
		$_SESSION['export_columnSeparator'] = $_POST['columnSeparator'];
	}elseif( !isset($_SESSION['export_columnSeparator']) ) {
		$_SESSION['export_columnSeparator'] = array_keys($colSeparators)[0];
	}
	
	$textDelimiters = array();
	$textDelimiters['DoubleQuote'] = "\"";
	$textDelimiters['SingleQuote'] = "'";
	$textDelimiters['None'] = "";
	if( isset( $_POST['textDelimiter']) && array_key_exists($_POST['textDelimiter'], $textDelimiters) ) {
		$_SESSION['export_textDelimiter'] = $_POST['textDelimiter'];
	}elseif( !isset($_SESSION['export_textDelimiter']) ) {
		$_SESSION['export_textDelimiter'] = array_keys($textDelimiters)[0];
	}

	$error = NULL;
	if( $_SERVER['REQUEST_METHOD'] == "POST" ) {
		if( isset($_POST['export']) && array_key_exists($_POST['export'], $exports) && $exports[ $_POST['export'] ]->hasAccess() ) {
			admin_header(true, true);
			$exportClass = $exports[ $_POST['export'] ];
			$separator = $colSeparators[ $_SESSION['export_columnSeparator'] ];
			$textDelimiter = $textDelimiters[ $_SESSION['export_textDelimiter'] ];
			$data = "";
			$columns = array();
			foreach($exportClass->getHeaders() as $headerName => $headerValue) {
				$columns[] = $headerName;
				if( strlen($textDelimiter) > 0 ) {
					$data .= $textDelimiter . str_replace($textDelimiter, $textDelimiter.$textDelimiter, $headerValue) . $textDelimiter . $separator;
				}else {
					$data .= $headerValue . $separator;
				}
			}
			$data = substr($data, 0, -1) . "\n";
			foreach($exportClass->getData() as $row) {
				foreach($columns as $column) {
					if( !isset($row[$column]) ) {
						$data .= $separator;
					}elseif( is_numeric($row[$column]) || strlen($textDelimiter) == 0 ) {
						$data .= $row[$column] . $separator;
					}else {
						$data .= $textDelimiter . str_replace($textDelimiter, $textDelimiter.$textDelimiter, $row[$column]) . $textDelimiter . $separator;
					}
				}
				$data = substr($data, 0, -1) . "\n";
			}
			header("Last-Modified: " . gmdate("D, d M Y H:i ") . " GMT");
			header('Pragma: no-cache');
			header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
			header("Content-length: ".strlen($data));
			header("Content-disposition: attachment; filename=\"".$_POST['export'].".csv\"");
			header("Content-type: application/octet-stream");
			header("Content-Transfer-Encoding: binary");
			header('Pragma: public');
			echo $data;
			admin_footer(true, true);
		}else {
			$error = "Unknown export selected, or you don't have access.";
		}
	}
	if( $_SERVER['REQUEST_METHOD'] == "GET" || $error != NULL ) {
		admin_header();
		if( $error != NULL ) {
			echoln("<span class=\"error\">" . $error . "</span><p />");
		}
		echoln("<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\">");
		foreach( $exports as $exportName => $exportClass ) {
			if( $exportClass->hasAccess() ) {
				echoln("<input type=\"radio\" name=\"export\" id=\"Export" . $exportName . "\" value=\"" . $exportName . "\" />");
				echoln("<label for=\"Export" . $exportName . "\">" . $exportClass->getDisplayName() . "</label><br />");
				echoln("<span class=\"appl_comment\">" . $exportClass->getDescription() . "<br/> </span><br />");
			}
		}
		echoln("<p />");
		echoln("Column separator: ");
		echoln("<select name=\"columnSeparator\">");
		foreach( $colSeparators as $name => $value ) {
			echoln("<option value=\"" . $name . "\"");
			if( $_SESSION['export_columnSeparator'] == $name ) echoln(" selected=\"selected\"");
			echoln(">" . $value . "</option>");
		}
		echoln("</select>");
		echoln("<br/>Text delimiter: ");
		echoln("<select name=\"textDelimiter\">");
		foreach( $textDelimiters as $name => $value ) {
			echoln("<option value=\"" . $name . "\"");
			if( $_SESSION['export_textDelimiter'] == $name ) echoln(" selected=\"selected\"");
			echoln(">" . $value . "</option>");
		}
		echoln("</select>");
		echoln("<p /><input type=\"submit\" value=\"Download\">");
		echoln("</form>");
		admin_footer();
	}
?>