<?php

/**
* Access level
*
* Save/Edit/Delete/Retreive information for access levels from the database
*
* @author	Thomas Hambach - thomas@rdlt.com
* @website	www.clancommandcenter.com
* @package	ClanCommandCenter
*
* Copyright (C) 2007  ClanCommandCenter
*
* This program 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 2
* of the License, or (at your option) any later version.
* 
* This program 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 this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
* 
*/

class AccessLevel extends ModuleHelper implements ModuleInterface
{

	/**
	 * Columns we are allowed to modify
	 *
	 * @var array
	 */
	protected $columns 		= array('id','name','description','superadmin');
	
	/**
	 * MySQL table
	 *
	 * @var string
	 */
	protected $table		= 'accesslevels';
	
	/**
	 * Primary key in our MySQL table
	 *
	 * @var string
	 */
	protected $primaryKey 	= 'id';
	
	/**
	 * Contains our permissions for this access level
	 *
	 * @var bool
	 */
	private $permissions	= false;

	/**
	 * Get the permissions for this access level
	 *
	 * @return array Array of permissions
	 */
	public function getPermissions()
	{

		if(!$this->permissions)
		{
			
			global $database;

			$query = "SELECT 	b.name as module,
								a.module as moduleid,
								a.view,
								a.comment,
								a.moderatecomment,
								a.add,
								a.modify,
								a.admin 
								FROM `modules` b
								LEFT JOIN `access` a
									on a.module=b.id and accesslevel=" . $this->id . " 
								WHERE b.active='Y' 
								ORDER BY b.name ASC";
			$results = $database->getrows($query);
			if(is_array($results))
			{
				foreach($results as $result)
				{
					$this->permissions[$result['module']] = $result;
				}
			}

		}
		
		return $this->permissions;

	}

	/**
	 * Save the permissions
	 *
	 * @param array $permissions
	 * @return bool true
	 */
	public function savePermissions(array $permissions)
	{

		global $database;

		$database->query('DELETE FROM access WHERE accesslevel=' . (int) $this->id);

		foreach($permissions as $permission)
		{
			$permission['accesslevel'] = (int) $this->id;
			$database->insert('access',$permission);
		}

		return true;

	}

}