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

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

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

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

	/*TODO
	 *
	 *load by sentence/article
	 *	load by CIA version [load current CIA + CIA_history]
	 **/ 
	 
	
	/**
	 * Default constructor
	 */
	public function __construct(MySQL $mysql) {
		$this->mysql = $mysql;
	}

	/**
	 * Load CIA_history by id
	 *
	 * @param id
	 * @return
	 */
	public function load($id) {
		$query = "SELECT * FROM CIA_history WHERE `id`='".$id."'";
		if( $this->mysql->query($query) ) {
			return new CIA_history($this->mysql->fetchArray());
		}else {
			return array();
		}
	}


	/**
	 * Save or update Amendments:
	 */
	public function saveOrUpdate(IModel $cia_history) {
		$query="";
		$recordID=$cia_history->getId();
		if($recordID==NULL)
		{
			$query.="INSERT INTO `CIA_history` SET ";
		}
		else
		{
			$query.="UPDATE `CIA_history` SET ";
		}
		$query .="`cia_id` = '".$this->mysql->escape($cia_history->getCia_id())."', ";
		$query .="`category` = '".$this->mysql->escape($cia_history->getCategory())."', ";
		$query .="`title` = '".$this->mysql->escape($cia_history->getTitle())."', ";
		$query .="`order` = '".$this->mysql->escape($cia_history->getOrder())."', ";
		$query .="`last_change` = '".$this->mysql->escape($cia_history->getLast_Change())."', ";
		$query .="`title2` = '".$this->mysql->escape($cia_history->getTitle2())."', ";
		$query .="`order2` = '".$this->mysql->escape($cia_history->getOrder2())."', ";
		$query .="`article` = '".$this->mysql->escape($cia_history->getArticle())."', ";
		$query .="`article_title` = '".$this->mysql->escape($cia_history->getArticle_title())."', ";
		$query .="`paragraph` = '".$this->mysql->escape($cia_history->getParagraph())."', ";
		$query .="`sentence` = '".$this->mysql->escape($cia_history->getSentence())."', ";
		$query .="`sentence_text` = '".$this->mysql->escape($cia_history->getSentence_text())."', ";
		$query .="`agora_id_start` = '".$this->mysql->escape($cia_history->getAgora_id_start())."', ";
		$query .="`agora_id_end` = '".$this->mysql->escape($cia_history->getAgora_id_end())."'";
		
		if($recordID!=NULL)
		{
			$query.=" where `id` = ".$recordID;
		}
		//echo $query;
		return $this->mysql->query($query);
	}
}
?>