<?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/>.
	 */

	/* 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($positionId) {
		global $setup;
		$position = $GLOBALS['DB']->fetchRow("candidatepost", $positionId);
		if( $position != NULL ) {
			$places = $position['places'];
			$deadline = $position['deadline'];
			if( $deadline != "auto" ) {
				return $deadline; // Nothing else to look for
			}else {
				if( is_before_ex("CandidateStart") || is_after("CandidateEndReal") ) return "closed";
				if( is_before("CandidateDeadline") ) return "open";
				$queryBuilder = new QueryBuilder($GLOBALS['DB'], "candidates");
				$queryBuilder->addField(new DBMethodCount("id"), "count");
				$queryBuilder->addField("approved");
				$queryBuilder->addWhereEquals("position", $positionId);
				$queryBuilder->addWhereNotEquals("approved", "no");
				if( !$setup['CloseWhenEnoughCandidates'] ) {
					$queryBuilder->addWhereSmallerEquals("created", get_sql_date($setup['CandidateDeadline']).":59");
				}
				$queryBuilder->addGroup("approved");
				if( $GLOBALS['DB']->select($queryBuilder->toQuery()) > 0 ) {
					$approved = 0;
					$pending = 0;
					while( $candidatures = $GLOBALS['DB']->fetchAssoc() ) {
						if( $candidatures['approved']=="yes" ) $approved = $candidatures['count'];
						if( $candidatures['approved']=="pending" ) $pending = $candidatures['count'];
					}
					if( $approved >= ($places + $setup['CandidateAdditionalRequired']) ) return "closed";
					elseif( ($approved + $pending) >= ($places + $setup['CandidateAdditionalRequired']) ) return "temporallyclosed";
					else return "open";
				}else {
					return "open"; // No candidates yet
				}
			}
		}else {
			// Couldn't find position
			return "closed";
		}
	}
?>