<?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/>.
	 */
	function is_sendreminder() {
		global $setup;
		return (get_sql_date($setup['EventDateAppEnd'])<=date("Y-m-d") OR get_sql_date($setup['EventDatePartTypeFix'])==date("Y-m-d", strtotime("+3 days"))) AND get_sql_date($setup['EventDatePartTypeFix'])>=date("Y-m-d");
	}

	/* is_before($deadline)
	 * Function that tells if it is still before or on a certain deadline
	 * @param: deadline: the key in $setup[] to check against
	 * @return: return true if it is before or on deadline, false if after deadline
	 */
	function is_before($deadline) {
		global $setup;
		if( strlen($setup[$deadline])==10 AND get_sql_date($setup[$deadline])>=date("Y-m-d") ) return true;
		elseif( strlen($setup[$deadline])==16 AND get_sql_date($setup[$deadline])>=date("Y-m-d H:i") ) return true;
		else return false;
	}

	/* is_before_ex($deadline)
	 * Function that tells if it is still before a certain deadline (exclusive)
	 * @param: deadline: the key in $setup[] to check against
	 * @return: return true if it is before deadline, false if on or after deadline
	 */
	function is_before_ex($deadline) {
		global $setup;
		if( strlen($setup[$deadline])==10 AND get_sql_date($setup[$deadline])>date("Y-m-d") ) return true;
		elseif( strlen($setup[$deadline])==16 AND get_sql_date($setup[$deadline])>date("Y-m-d H:i") ) return true;
		else return false;
	}

	function is_after($deadline) {
		global $setup;
		if( strlen($setup[$deadline])==10 AND get_sql_date($setup[$deadline])<=date("Y-m-d") ) return true;
		elseif( strlen($setup[$deadline])==16 AND get_sql_date($setup[$deadline])<=date("Y-m-d H:i") ) return true;
		else return false;
	}

	function is_after_ex($deadline) {
		global $setup;
		if( strlen($setup[$deadline])==10 AND get_sql_date($setup[$deadline])<date("Y-m-d") ) return true;
		elseif( strlen($setup[$deadline])==16 AND get_sql_date($setup[$deadline])<date("Y-m-d H:i") ) return true;
		else return false;
	}

	function is_after_in($deadline) {
		global $setup;
		if( strlen($setup[$deadline])==10 AND get_sql_date($setup[$deadline])<=date("Y-m-d") ) return true;
		elseif( strlen($setup[$deadline])==16 AND get_sql_date($setup[$deadline])<=date("Y-m-d H:i") ) return true;
		else return false;
	}

	/*
	 * Return the status for candidating for a position
	 *
	 * @param position position for which to request status
	 * @return string 'open', 'closed', 'temporallyclosed'
	 */
	function candidate_status($position) {
		global $setup;
		if( is_before("CandidateStart") OR is_after("CandidateEndReal") ) return "closed";
		$query = "SELECT `places`, `deadline` FROM `candidatepost` WHERE `id`=".addslashes($position);
		if( @mysql_num_rows( $res=doquery($query) )==1 ) {
			$row = mysql_fetch_array($res);
			$places = $row['places'];
			$deadline = $row['deadline'];
			if( $deadline!="auto" ) return $deadline; // Nothing else to look for
			if( is_before("CandidateDeadline") ) return "open";
			$query = "SELECT COUNT(`id`) AS `count`, `Approved` FROM `candidates` WHERE `Position`=".addslashes($position)." AND `Approved`!='no' ";
			if( !$setup['CloseWhenEnoughCandidates'] )
				$query .= "AND `Created`<='".addslashes(get_sql_date($setup['CandidateDeadline']).":59")."' ";
			$query .= "GROUP BY `Approved`";
			if( @mysql_num_rows( $res=doquery($query) )>0 ) {
				$approved = 0;
				$pending = 0;
				while( $row = mysql_fetch_array($res) ) {
					if( $row['Approved']=="yes" ) $approved = $row['count'];
					if( $row['Approved']=="pending" ) $pending = $row['count'];
				}
				if( $approved>=$places ) return "closed";
				elseif( ($approved+$pending)>=$places ) return "temporallyclosed";
				else return "open";
			}else {
				return "open"; // No candidates yet
			}
		}else {
			// Couldn't find position
			return "closed";
		}
	}
?>