<?php
	/**
	 * Copyright 2005 Wim van Ravesteijn
	 *
	 * This file is part of AEGEE-Europe Photo Page.
	 *
	 * AEGEE-Europe Photo Page 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 Photo Page 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 Photo Page.  If not, see
	 * <http://www.gnu.org/licenses/>.
	 */
	include("./include/include.php");
	page_header();

	if( isset($_GET['reset']) ) {
		// Reset session vars for this page
		$_SESSION['event_start']=NULL;
		$_SESSION['event_count']=NULL;
		$_SESSION['event_event']=NULL;
		$_SESSION['event_sort']=NULL;
	}

	$_SESSION['book_select']=$_SERVER['PHP_SELF'];

	// Set initial value
	if( !isset($_SESSION['event_total']) || $_SESSION['event_total']<1 ) $_SESSION['event_total']=99999;

	// See if we should limit to one event only
	if( ( isset($_GET['event']) OR isset($_GET['body']) ) AND isset($_GET['limit']) ) $_SESSION['event_limit']=true;
	// See if we should limit to one body only
	if( strlen(get_var("body"))>0 ) $_SESSION['event_body']=strtolower(get_var("body"));

	// Get event
	if( strlen(get_var("event"))>0 ) $_SESSION['event_event']=strtolower(get_var("event"));

	if( strlen(get_var("sort"))>0 ) $_SESSION['event_start']=0;  // Reset if people choose menu item

	if( strlen(get_var("event"))>0 AND !isset($_SESSION['event_sort']) ) {
		// Person enters the site for a specific event
		$query="SELECT `event`.`eventcode` AS `eventcode`
						FROM `event`, `book`
						WHERE `event`.`eventcode`=`book`.`eventcode` AND ";
		if( $_SESSION['event_limit'] AND !isset($_SESSION['event_body']) ) {
			$query.="`event`.`eventcode`='".addslashes($_SESSION['event_event'])."' ";
		}else {
			$query.="(`book`.`photocount`>0 OR `event`.`eventcode`='".addslashes($_SESSION['event_event'])."') ";
		}
		if( isset($_SESSION['event_body']) )
			$query.="AND (`event`.`bodycode`='".addslashes($_SESSION['event_body'])."' OR `event`.`bodycode2`='".addslashes($_SESSION['event_body'])."') ";
		$query.="GROUP BY `eventcode`
						ORDER BY `event`.`datestart` DESC, `event`.`dateend` DESC, `event`.`title`";
		if( @mysql_num_rows( $res=doquery($query) )>0 ) {
			debug("number of events found: ".mysql_num_rows($res));
			$_SESSION['event_start']=0;
			while( $row=mysql_fetch_array( $res ) ) {
				if( strtolower($row['eventcode'])==$_SESSION['event_event'] ) break;
				$_SESSION['event_start']++;
			}
			if( $_SESSION['event_start']>=mysql_num_rows($res) ) $_SESSION['event_start']=0;
		}
		debug("start=".$_SESSION['event_start']);
	}
	
	// Get the sort order
	if( strlen(get_var("sort"))>0 ) $_SESSION['event_sort']=get_var("sort");
	if( !isset($_SESSION['event_sort']) ) {
		$_SESSION['event_sort'] = "date";
	}
	switch( $_SESSION['event_sort'] ) {
		case "title":
			$mysql_order="ORDER BY `title`, `datestart`, `dateend`";
			break;
		default:
			$_SESSION['event_sort']="date";
			$mysql_order="ORDER BY `datestart` DESC, `dateend` DESC, `title`";
	}
	
	// Get count
	if( get_int("count")>0 ) $_SESSION['event_count']=get_int("count");
	if( !isset($_SESSION['event_count']) || $_SESSION['event_count']<1 ) $_SESSION['event_count']=$MAXLIST;
	// Get start
	if( strlen(get_var("start"))>0 ) $_SESSION['event_start']=get_int("start");
	if( !isset($_SESSION['event_start']) || $_SESSION['event_start']<=0 ) $_SESSION['event_start']=0;
	// Limit
	$mysql_limit="LIMIT ".$_SESSION['event_count']." OFFSET ".$_SESSION['event_start'];
	
	echoln("All events with photos sorted by ".$_SESSION['event_sort']);
	$query="SELECT `event`.`eventcode` AS `eventcode`, `event`.`datestart` AS `datestart`, `event`.`dateend` AS `dateend`,
						`event`.`title` AS `title`, `event`.`location` AS `location`, COUNT(`book`.`id`) AS `books`, MIN(`book`.`id`) AS `book`,
						SUM(`book`.`photocount`) AS `photocount`, `event`.`documentid` AS `documentid`
					FROM `event`, `book`
					WHERE `event`.`eventcode`=`book`.`eventcode` AND ";
	if( isset($_SESSION['event_limit']) && $_SESSION['event_limit'] AND !isset($_SESSION['event_body']) ) {
		$query.="`event`.`eventcode`='".addslashes(isset($_SESSION['event_event']) ? $_SESSION['event_event'] : "")."' ";
	}else {
		$query.="(`book`.`photocount`>0 OR (`event`.`eventcode`='".addslashes(isset($_SESSION['event_event']) ? $_SESSION['event_event'] : "")."' AND (`book`.`photocount`>0 OR `book`.`uid`=0))) ";
	}
	if( isset($_SESSION['event_body']) )
		$query.="AND (`event`.`bodycode`='".addslashes($_SESSION['event_body'])."' OR `event`.`bodycode2`='".addslashes($_SESSION['event_body'])."') ";
	$query.="GROUP BY `eventcode`
	$mysql_order $mysql_limit";
	if( @mysql_num_rows( $res=doquery($query) )>0 ) {
		if( mysql_num_rows($res)<$_SESSION['event_count'] ) {
			// We reached the end of the list
			$_SESSION['event_total']=$_SESSION['event_start']+mysql_num_rows($res);
		}
		// Previous-next button
		$butprevnext="<p>";
		if( $_SESSION['event_start']>0 ) {
			$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?start=".($_SESSION['event_start']-$_SESSION['event_count'])."\">";
			$butprevnext.="<img src=\"".layout_img("previous.gif")."\" border=\"0\" alt=\"Previous page\"></a>";
		}
		$butprevnext.="&nbsp;";
		if( $_SESSION['event_total']>=($_SESSION['event_start']+$_SESSION['event_count']) ) {
			$butprevnext.="<a href=\"".$_SERVER['PHP_SELF']."?start=".($_SESSION['event_start']+$_SESSION['event_count'])."\">";
			$butprevnext.="<img src=\"".layout_img("next.gif")."\" border=\"0\" alt=\"Next page\"></a>";
		}
		echoln($butprevnext);
		echoln("<p><table>");
		echoln("  <tr>");
		echoln("    <th>Start</th>");
		echoln("    <th>End</th>");
		echoln("    <th>Title</th>");
		echoln("    <th>Location</th>");
		echoln("    <th>Books</th>");
		echoln("    <th>Photos</th>");
		echoln("    <th>&nbsp;</th>");
		echoln("  </tr>");
		$i=0;
		while( $row=mysql_fetch_array($res) ) {
			$i++;
			if( ($i%2)==1 ) echoln("  <tr class=\"odd\">");
			else echoln("  <tr class=\"even\">");
			echoln("    <td class=\"small\"><a name=\"".strtolower($row['eventcode'])."\"></a>".substr(get_date($row['datestart']), 0, 5)."</td>");
			echoln("    <td class=\"small\">".get_date($row['dateend'])."</td>");
			if( $row['books']==1 AND $row['photocount']==0 ) { echoln("    <td>".$row['title']."</td>"); $row['books']=0; }
			elseif( $row['books']==1 ) echoln("    <td><a href=\"./photo.php?book=".$row['book']."&amp;size=thumb\">".$row['title']."</a></td>");
			else echoln("    <td><a href=\"".$_SERVER['PHP_SELF']."?event=".strtolower($row['eventcode'])."#".strtolower($row['eventcode'])."\">".$row['title']."</a></td>");
			echoln("    <td class=\"small\">".$row['location']."</td>");
			if( isset($_SESSION['event_event']) && strtolower($row['eventcode'])==$_SESSION['event_event'] ) {
				echoln("    <td align=\"right\">".max(0, $row['books']-1)."</td>");
			}else {
				echoln("    <td align=\"right\">".$row['books']."</td>");
			}
			echoln("    <td align=\"right\">".$row['photocount']."</td>");
			echoln("    <td class=\"small\">");
			#echoln("      <a href=\"./addbook.php?add&amp;event=".strtolower($row['eventcode'])."&amp;login\">add photos</a> &nbsp;");
			if( strlen($el=get_eventlink($row['eventcode'], $row['documentid']))>0 ) echoln("      ".$el."info</a>");
			echoln("    </td>");
			echoln("  </tr>");
			if( isset($_SESSION['event_event']) && strtolower($row['eventcode'])==$_SESSION['event_event'] ) {
				if( ($i%2)==1 ) echoln("  <tr class=\"odd\">");
				else echoln("  <tr class=\"even\">");
				echoln("    <td>&nbsp;</td>");
				echoln("    <td colspan=\"6\">&nbsp;");
				$query2="SELECT `book`.`id` AS `book`, `book`.`photocount` AS `photocount`, `book`.`title` AS `title`,
									 `user`.`name` AS `owner`
								 FROM `book`, `user`
								 WHERE `book`.`uid`=`user`.`uid` AND `book`.`eventcode`='".addslashes($_SESSION['event_event'])."' AND
								 	 `book`.`photocount`>0
								 ORDER BY `title`, `name`";
				if( @mysql_num_rows( $res2=doquery($query2) )>0 ) {
					echoln("      <p><table>");
					echoln("        <tr>");
					echoln("          <th>Title</th>");
					echoln("          <th>Owner</th>");
					echoln("          <th>Photos</th>");
					echoln("        </tr>");
					$j=0;
					while( $row2=mysql_fetch_array($res2) ) {
						$j++;
						if( ($j%2)==1 ) echoln("        <tr class=\"odd\">");
						else echoln("        <tr class=\"even\">");
						echoln("          <td><a href=\"./photo.php?book=".$row2['book']."&amp;size=thumb\">".$row2['title']."</a></td>");
						echoln("          <td class=\"small\">".$row2['owner']."</td>");
						echoln("          <td align=\"right\">".$row2['photocount']."</td>");
						echoln("        </tr>");
					}
					echoln("      </table><p>&nbsp;");
				}else {
					echoln("      <p class=\"big\">No photos found<p>&nbsp;");
				}
				echoln("    </td>");
				echoln("  </tr>");
			}
		}
		echoln("</table>");
		echoln($butprevnext);
	}else {
		$butprevnext.="<p><a href=\"".$_SERVER['PHP_SELF']."?start=".($_SESSION['event_start']-$_SESSION['event_count'])."\">";
		$butprevnext.="<img src=\"".layout_img("previous.gif")."\" border=\"0\"></a>";
		echoln($butprevnext);
		echoln("<p class=\"big\">No events found</p>");
		echoln($butprevnext);
	}
	
	page_footer();
?>