<?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/>.
	 */
	include("./include/Appl.php");
	include("./include/Persons.php");

	class ListView {
		private $title;
		private $sort;
		private $showButtons;
		private $sqlwhere;
		private $urlargs;
		private $maxlist;
		private $printable;
		private $fields;

		public function __construct($title, $defaultsort="", $showButtons=true, $sqlwhere="", $sqlwhereuseselection=true, $urlargs="", $maxlist=0, $printable=false) {
			global $setup;
			$this->title = $title;
			if( isset($_GET['sort']) AND preg_match("/^[a-zA-Z0-9_]+$/", $_GET['sort']) ) {
				$this->sort = $_GET['sort'];
			}elseif( preg_match("/^[a-zA-Z0-9_]+$/", $defaultsort) ) {
				$this->sort = $defaultsort;
			}else {
				debug("Invalid or no default sort provided");
				$this->sort = "";
			}
			$this->showButtons = $showButtons;
			if( strlen($sqlwhere)==0 ) {
				if( $sqlwhereuseselection )
					$this->sqlwhere = $_SESSION['sess_sel'];
				else
					$this->sqlwhere = "1";
			}else {
				if( $sqlwhereuseselection )
					$this->sqlwhere = $_SESSION['sess_sel'] . " AND " . $sqlwhere;
				else
					$this->sqlwhere = $sqlwhere;
			}
			if( strlen($urlargs)>0 )
				$this->urlargs = $urlargs."&amp;";
			else
				$this->urlargs = "";
			if( $maxlist>0 )
				$this->maxlist = $maxlist;
			else
				$this->maxlist = $setup['MaxList'];
			$this->printable = $printable;
			$this->fields = array();
		}
		
		public function __destruct() {
		}

		public function addfield($name) {
			if( preg_match("/^[a-zA-Z0-9_]+$/", $name) ) {
				$class = "";
				if( substr($name, 0, 14) == "ExtraQuestion_" ) {
					$extraQuestionId = substr($name, 14);
					$filename = "ExtraQuestion";
				}else {
					$filename = $name;
				}
				if( $file = glob( dirname($_SERVER["SCRIPT_FILENAME"])."/include/PersonsFields/???".$filename.".php" ) AND count($file)==1 AND is_readable($file[0]) ) {
					$class = "Persons".$filename;
				}elseif( $file = glob( dirname($_SERVER["SCRIPT_FILENAME"])."/include/ApplFields/???".$filename.".php" ) AND count($file)==1 AND is_readable($file[0]) ) {
					$class = "Appl".$filename;
				}else {
					debug("Didn't add ".$name.", cannot find related file");
					return false;
				}
				if( $class!="" ) {
					include_once( $file[0] );
					if( $filename == "ExtraQuestion" ) {
						$query = "SELECT `question`, `maxlength` FROM `appl_extraquestions` WHERE `id` = " . $extraQuestionId;
						if( @mysql_num_rows( $res=doquery($query) )>0 ) {
							$row = mysql_fetch_assoc($res);
							$classref = new ApplExtraQuestion(0, $extraQuestionId, $row['question'], $row['maxlength']);
						}
					}else {
						$classref = new $class(0);
					}
					if( $classref->get_access(false)!=Appl::ACCESS_NO ) {
						$this->fields[$name]['class'] = $class;
						$this->fields[$name]['classref'] = $classref;
						$this->fields[$name]['printname'] = $classref->get_print_name();
						$this->fields[$name]['printnameshort'] = $classref->get_print_name_short();
						$this->fields[$name]['sql_columnname'] = $classref->sql_columnname();
						return true;
					}else {
						debug("Didn't add ".$name.", access denied");
						return false;
					}
				}
			}else {
				// invalid name
				debug("Didn't add ".$name.", invalid name");
				return false;
			}
		}

		public function display() {
			if( !isset($_GET['start']) ) {
				$_GET['start'] = 0;
				$_REQUEST['start'] = 0;
			}
			$title = $this->title;
			if( array_key_exists($this->sort, $this->fields) ) $title .= " ordered by ".$this->fields[$this->sort]['printname'];
			echoln("<h1>".$title."</h1>");

			$query = "SELECT COUNT(`id`) AS `tot_rows` FROM `applications` WHERE ".$this->sqlwhere;
			if( @mysql_num_rows( $res=doquery($query) )!=1 ) {
				echoln("<p><span class=\"error\">Failed selecting row count.</span></p>");
			}else {
				$row = mysql_fetch_array($res);
				$tot_rows = $row['tot_rows'];
				if( $tot_rows>$this->maxlist AND !$this->printable ) {
					// There are more entries to show than fit on one page, split in pages
					$page_text = "Page";
					for($i=0; $i<($tot_rows/$this->maxlist); $i++) {
						if( $_GET['start']==($i*$this->maxlist) ) {
							$page_text .= " &nbsp;<b>".($i+1)."</b>";
						}else {
							$page_text .= " &nbsp;<a href=\"?".$this->urlargs.($this->sort=="" ? "" : "sort=".$this->sort."&amp;")."start=".($i*$this->maxlist)."\">".($i+1)."</a>";
						}
					}
					if( $_REQUEST['start']==-1 ) {
						$page_text .= " &nbsp; <b>all rows</b>";
					}else {
						$page_text.=" &nbsp; <a href=\"?".$this->urlargs.($this->sort=="" ? "" : "sort=".$this->sort."&amp;")."start=-1\">all rows</a>";
					}
					echoln("<p>".$page_text."</p>");
				}

				if( $_GET['start']==-1 OR $this->printable ) {
					$sqllimit = "0";
					if( $tot_rows>0 ) echoln("<p>Showing all rows (".$tot_rows." total).</p>");
				}else {
					$start = get_int("start");
					if( $start<0 ) $start = false;
					if( $start>=$tot_rows ) $start = max(0, $tot_rows - $this->maxlist);
					$sqllimit = $start . ", " . $this->maxlist;
					if( $tot_rows>0 ) echoln("<p>Showing rows ".($start+1)." - ".min( ($start+$this->maxlist), $tot_rows )." (".$tot_rows." total).</p>");
				}

				$fields = array_keys($this->fields);

				$joins = "";
				$query = "SELECT `applications`.`id`, `applications`.`BodyCode`";
				for( $i=0; $i<count($fields); $i++ ) {
					if( $this->fields[ $fields[$i] ]['sql_columnname']!=false ) {
						$query .= ", ".$this->fields[ $fields[$i] ]['sql_columnname'];
					}
					if( substr($fields[$i], 0, 14) == "ExtraQuestion_" ) {
						$joins .= " LEFT JOIN `appl_extraanswers` AS `" . $fields[$i] . "` ON `" . $fields[$i] . "`.`appl_id` = `applications`.`id` AND `" . $fields[$i] . "`.`question_id` = " . addslashes(substr($fields[$i], 14));
					}
				}
				$query .= " FROM `applications`";
				$query .= $joins;
				if( in_array($this->sort, array("BodyCode")) ) $query .= " LEFT JOIN `ab_bodies` USING (`BodyCode`)";
				if( in_array($this->sort, array("Nationality", "CountryCode")) ) $query .= " LEFT JOIN `countrycodes` ON `applications`.`".$this->sort."`=`countrycodes`.`Code`";
				$query .= " WHERE ".$this->sqlwhere;
				if( in_array($this->sort, array("BodyCode")) ) $query .= " ORDER BY `ab_bodies`.`BodyCategoryOrder`, `ab_bodies`.`BodyNameAscii`, `applications`.`FirstName`, `applications`.`LastName`";
				elseif( in_array($this->sort, array("Nationality", "CountryCode")) ) $query .= " ORDER BY `countrycodes`.`Name`, `applications`.`FirstName`, `applications`.`LastName`";
				elseif( in_array($this->sort, array("DateBirthNoYear")) ) $query .= " ORDER BY MID(`applications`.`DateBirth`,6,5)";
				else $query .= " ORDER BY ".($this->sort=="" ? "" : "`".$this->sort."`, ")."`applications`.`FirstName`, `applications`.`LastName`";
				if( $sqllimit!=false ) $query .= " LIMIT ".$sqllimit;

				if( @mysql_num_rows( $res=doquery($query) )<1 ) {
					echoln("<p><i>Empty selection, no matching entries found.</i></p>");
				}else {
					echoln("<table" . ($this->printable ? " border=\"1\"" : "") . ">");
					echoln("  <tr>");
					if( $this->showButtons ) echoln("    <th>&nbsp;</th>");
					for( $i=0; $i<count($fields); $i++ ) {
						echoln("    <th><a href=\"?".$this->urlargs."sort=".$fields[$i]."\">" . $this->fields[ $fields[$i] ]['printnameshort'] . "</a></th>");
					}
					echoln("  </tr>");
					$r=0;
					while( $row=mysql_fetch_array($res) ) {
						$r++;
						echoln("  <tr" . ( $this->printable ? "" : " class=\"" . (($r%2)==1 ? "odd" : "even") . "\"" ) . ">");
						if( $this->showButtons ) {
							echoln("    <td align=\"center\" nowrap=\"nowrap\">");
							echoln("      <a href=\"javascript:openPopup('./ajaxViewAll.php?id=".$row["id"]."');\"><img src=\"./image/info.gif\" border=\"0\" width=\"15\" height=\"15\" alt=\"Show all data\" title=\"Show all data\" /></a>");
							if( in_array("application_register", $_SESSION['sess_functions']) )
								echoln("      <a href=\"./register.php?bodycode=".$row["BodyCode"]."&amp;applicationID=".$row["id"]."\"><img src=\"./image/arrived.gif\" border=\"0\" width=\"15\" height=\"15\" alt=\"Register participant\" title=\"Register participant\" /></a>");
							if( in_array("application_edit", $_SESSION['sess_functions']) )
								echoln("      <a href=\"javascript:var w = window.open('./editappl.php?id=".$row["id"]."', null, 'height=600, width=700, status=no, toolbar=no, menubar=no, location=no, resizable=no, scrollbars=yes');\">edit</a>");
							echoln("    </td>");
						}
						for( $i=0; $i<count($fields); $i++ ) {
							$title = $this->fields[ $fields[$i] ]['classref']->displaytitle($row[ $fields[$i] ]);
							if( $title!="" ) {
								$title = " title=\"".$title."\"";
							}
							echoln("    <td" . $this->fields[ $fields[$i] ]['classref']->displayoptions($row['id']) . $title .">".($this->printable ? $this->fields[ $fields[$i] ]['classref']->displaytext($row[ $fields[$i] ], $row['id'], $row) : $this->fields[ $fields[$i] ]['classref']->display($row[ $fields[$i] ], $row['id'], $row))."</td>");
						}
						echoln("  </tr>");
					}
					echoln("</table>");
					if( $tot_rows>$this->maxlist AND !$this->printable ) {
						echoln("<p>".$page_text."</p>");
					}
				}
			}
		}
	}
?>