<?php
/**
 * Copyright 2009, 2010 AEGEE-Europe
 *
 * This file is part of AEGEE-Europe Online Membership System.
 *
 * AEGEE-Europe Online Membership System 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 Online Membership System 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 Online Membership System.  If not, see
 * <http://www.gnu.org/licenses/>.
 */

/**
 * Access Database Access Object. This class provides functionality to
 * load and save accesses
 */

require_once(FILESYSTEMROOTPATH."include/classes/IDao.php");

class AccessDao implements IDao {
	/** MySQL object */
	private $mysql;

	/**
	 * Default constructor
	 */
	public function __construct(MySQL $mysql) {
		$this->mysql = $mysql;
	}

	/**
	 * Load all accesses
	 *
	 * @return array with accesses
	 */
	public function loadAll() {
		$query = "SELECT role, access FROM accessroles ORDER BY access";
		if( $this->mysql->query($query) ) {
			$ret = array();
			while( $row = $this->mysql->fetchArray() ) {
				$ret[ $row['role'] ] = intval($row['access']);
			}
			return $ret;
		}else {
			return array();
		}
	}

	/**
	 * Load all accesses that require a smaller or equal access level than the parameter
	 *
	 * @param int access: the access to be compared
	 * @return array with accesses that require a smaller or equal access level than the parameter
	 */
	public function loadStructural($access) {
		$query = "SELECT role, access
							FROM accessroles
							WHERE access<='".$access."'
							ORDER BY access";
		if( $this->mysql->query($query) ) {
			$ret = array();
			while( $row = $this->mysql->fetchArray() ) {
				$ret[strtoupper($row['role'])] = intval($row['access']);
			}
			return $ret;
		}else {
			return array();
		}
	}

	/**
	 * Load all accesses that have been assigned to the requested group
	 *
	 * @param string access: the group to look for
	 * @return array with accesses that have been assigned to the requested group
	 */
	public function loadNonStructural($group, $allbodies) {
		$query = "SELECT r.role, r.access, c.allbodies
							FROM accessroles r
							INNER JOIN accesscustom c ON c.role=r.role
							WHERE `group`=LOWER('".$group."') AND `allbodies`='".$allbodies."'
							ORDER BY access";
		if( $this->mysql->query($query) ) {
			$ret = array();
			while( $row = $this->mysql->fetchArray() ) {
				$ret[strtoupper($row['role'])] = intval($row['access']);
			}
			return $ret;
		}else {
			return array();
		}
	}
	
	public function load($page) {
		
	}
	
	public function saveOrUpdate(IModel $access) {
		
	}
	
	
}
?>