<?php

/*
	
	This class handles all tasks regarding vacancy-items

*/

require_once DOCUMENT_ROOT.'app/models/m_page.php';


class Vacancypage extends Page
{
	/**
	*
	*	@var array Category data
	*/
	private $_data = array('id'=>'', 'title'=>'', 'description'=>'', 'date'=>'');
	
	/**
	*
	*	@var int Since this is an extention we need to hardcode the pageId
	*/
	private $_pageId = 4;
	
	/**
	*
	* Constructor
	*/
	public function __construct()
	{
		// Storage Session
		$this->dataSession = new DataSession('data_to_store',$this->_data);	
		
		// Name of the databasetable
		$this->tableName = 'page_vacatures_items';
	
		// database handler
		$this->dbh = new DatabaseHandler();
		$this->dbh->setTableName($this->tableName);

        // lang
        global $template;
        $this->lang = $template->lang;
	}
	
	/**
	* This functions graps data from the database ands returns this in an array
	* If an array of ids is passed trough only those rows from that list of ids will be returned, otherwise all rows wil be returned
	*
	* @access public
	* @param array(optional)
	* @return array
	*/
	public function get($ids = NULL)
	{
		// tell the database handler what data to get switch date with timest
		$getData = array('id'=>'', 'title'=>'', 'description'=>'', 'timest'=>'');
		$this->dbh->setData($getData);
		
		$data = array();
		if( ! empty($ids))
		{
			// grap categories from specified ids
			$data = array();
			foreach($ids as $id)
			{
				$this->dbh->addRule('id',$id);
				$data[] = $this->dbh->select();
			}
		}
		else
		{ 
			// grap all categories
			$this->dbh->setActiveOnly(TRUE, $this->_pageId);
			$this->dbh->setScope(0,$this->maxItems);
			$data = $this->dbh->select();
		}
		
		return $data;
	}
	
	/**
	* Puts data into the session data_to_store
	*
	* @access public
	* @param int
	* @return null
	*/
	public function setStorageData($id)
	{
		if( ! empty($id) && is_numeric($id))
		{
			$tempdata = $this->get(array($id));
			$data = $tempdata[0];
			
			foreach(array_keys($_SESSION['data_to_store']) as $key)
			{
				if($key == 'date')
				{
					//timest to date conversion
                    $date = $data[$key] = date('m/d/Y',$data['timest']);
					$_SESSION['data_to_store'][$key] = $date;
				}
				if(isset($data[$key]))
				{
					$_SESSION['data_to_store'][$key] = $data[$key];
				}
			}
		}
	}
	
	/**
	* Save data in the datasession
	* Validate and store a item in the database
	* Id an id is set, the storage needs to be updated, else a new row is inserted
	*
	* @access public
	* @param array
	* @return boolean
	*/
	public function store($id = NULL)
	{
		// data obtained by post
		$this->_data = $this->dataSession->savePost();
							

		if( ! empty($this->_data))
		{
			if($this->validate($id))
			{	
			
				// date becomes timest - check if ! empty data, else get timest by time().
				if( ! empty($this->_data['date']))
				{
                    $temp = explode('/',$this->_data['date']);
                    $month = $temp[0];
                    $day = $temp[1];
					$year = $temp[2];
					if( ! empty($day) && ! empty($month) && ! empty($year))
					{
						$this->_data['timest'] = mktime(12,0,0, $month, $day, $year);
					}
				}
				else
				{
					$this->_data['timest'] = time();
				}
				unset($this->_data['date']);
				
				if($id == NULL)
				{
					// No id is set => Insert
					
					// order - get highest order from the table and add 1
					$orderData = array('itemOrder'=>'');
					$orderDbh = new DatabaseHandler();
					$orderDbh->setTableName($this->tableName);
					$orderDbh->setData($orderData);
					$orderDbh->setActiveOnly(TRUE, $this->_pageId);
					$orderDbh->setOrder('itemOrder','DESC');
					$orderDbh->setScope(0,1);
					if($result = $orderDbh->select())
					{	
						$highestOrder = $result['itemOrder'];
						
						$this->_data['itemOrder'] = $highestOrder + 1;
					}
					else
					{
						$this->_data['itemOrder'] = 1;
					}
					
					// insert data
					$this->dbh->setData($this->_data);
					
					if($insertId = $this->dbh->insert())
					{	
						$activeDb = new DatabaseHandler();
						$activeDb->setTableName('kms_active');
						$activeDb->setData(array('itemId'=>$insertId,'pageId'=>$this->_pageId,'active'=>1,'lastUpdate'=>time()));
						if($activeDb->insert())
						{
							$this->dataSession->clear();
							return $insertId;
						}
					}
					else
					{
                        $this->errors[] = $this->lang['general_something_went_wrong'];
					}
				}
				else
				{
						
					// Id is set => Update
					$this->dbh->setData($this->_data);
					$this->dbh->addRule('id',$id);
					if($this->dbh->update())
					{
						$this->dataSession->clear();
						return TRUE;
					}
				}
			}
		}
		return FALSE;
	}
	
	/**
	* Validates item
	* Save errors if these appear
	* 
	* @access private
	* @param
	* @return boolean
	*/
	private function validate($id=NULL)
	{
		$required = array();
		$title = $required[] = $this->_data['title'];
		$description = $required[] = $this->_data['description'];
		
		// check for empty fields
		foreach($required as $value)
		{
			if(empty($value))
			{
                $errors[] = $this->lang['form_complete_all_fields'];
			}	
		}
		
		
		// check unique values (only insert)
		$titleDbh = new DatabaseHandler();
		$titleDbh->setTableName($this->tableName);
		$titleDbh->setData(array('title'=>''));	
		$titleDbh->addRule('title', $title);	
		if( $id != NULL)
		{
			$titleDbh->addRule('id', $id, ' AND NOT ');	
		}
		if($titleDbh->select())
		{
            $errors[] = $this->lang['form_choose_unique_title'];
		}
	
		// check if valid
		
		if(isset($errors))
		{	
			$this->errors = $errors;
			return FALSE;
		}
		else
		{

			return TRUE;
		}
	}
}