<?php 

// h-source, a web software to build a community of people that want to share their hardware information.
// Copyright (C) 2010  Antonio Gallo (h-source-copyright.txt)
//
// This file is part of h-source
//
// h-source 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.
// 
// h-source 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 h-source.  If not, see <http://www.gnu.org/licenses/>.

if (!defined('EG')) die('Direct access not allowed!');

class MeetController extends BaseController
{
	private $whereArray = array(
		'has_confirmed'	=>	0,
		'deleted'		=>	'no',
	);
	
	public function __construct($model, $controller, $queryString)
	{
		parent::__construct($model, $controller, $queryString);
		
		$this->model('ProfileModel');
		$this->model('UsersModel');
		$this->model('HardwareModel');
		$this->model('IssuesModel');
		$this->model('MessagesModel');
		$this->model('TalkModel');
		
		$argKeys = array(
			'page:forceNat'	=>	1,
		);

		$this->setArgKeys($argKeys);
		
		$data['title'] = 'meet - '.Website::$generalName;
		$this->append($data);
	}
	
	//check if the users exists
	private function userExists($user)
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		
		if (strcmp($clean['user'],'') !== 0)
		{
			$res = $this->m['UsersModel']->db->select('regusers','has_confirmed,deleted,username','username="'.$clean['user'].'" and has_confirmed=0 and deleted="no"');
			
			if (count($res) > 0)
			{
				return true;
			}
		}
		return false;
	}
	
	//public page of the user
	public function user($lang = 'en', $user = '')
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		$data['title'] = "meet ".$clean['user']." - ".Website::$generalName;
		
		$this->shift(2);
		
		if ($this->userExists($clean['user']))
		{
			$this->whereArray['username'] = $clean['user'];
			
			$data['table'] = $this->m['ProfileModel']->select('regusers.e_mail,regusers.username,profile.*')->from('regusers inner join profile')->on('regusers.id_user = profile.created_by')->where($this->whereArray)->send();
			
			$data['meet_username'] = $clean['user'];
						
			$this->append($data);
			$this->load('meet');
			$this->right();
		}

	}

	//contributions menu
	public function contributions($lang = 'en', $user = '')
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		$data['title'] = $clean['user']." contributions - ".Website::$generalName;
		
		$this->shift(2);
		
		if ($this->userExists($clean['user']))
		{
			$clean['id_user'] = (int)$this->m['UsersModel']->getUserId($clean['user']);
			
			$this->whereArray['username'] = $clean['user'];
			
			$data['meet_username'] = $clean['user'];
			
			$hardNumb = $this->m['HardwareModel']->select()->where($this->whereArray)->rowNumber();
			
			$issuesNumb = $this->m['IssuesModel']->select('id_issue')->where(array('created_by'=>$clean['id_user'],'deleted'=>'no'))->rowNumber();
			
			$messNumb = $this->m['MessagesModel']->select('id_mes,messages.id_issue,messages.creation_date')->where(array('created_by'=>$clean['id_user'],'deleted'=>'no'))->rowNumber();
			
			$talkNumb = $this->m['TalkModel']->select('talk.title')->where(array('created_by'=>$clean['id_user'],'deleted'=>'no'))->rowNumber();
			
			$data['hasHardware'] = $hardNumb > 0 ? true : false;
			$data['hasIssues'] = $issuesNumb > 0 ? true : false;
			$data['hasMessages'] = $messNumb > 0 ? true : false;
			$data['hasTalk'] = $talkNumb > 0 ? true : false;
			
			$this->append($data);
			$this->load('contributions');
			$this->right();
		}

	}

	//hardware contributions
	public function hardware($lang = 'en', $user = '')
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		$data['title'] = "hardware contributions - ".Website::$generalName;
		
		$this->shift(2);
		
		if ($this->userExists($clean['user']))
		{
			$this->whereArray['username'] = $clean['user'];
			
			$data['table'] = $this->m['HardwareModel']->select('hardware.*,regusers.username')->where($this->whereArray)->send();
			
			$data['meet_username'] = $clean['user'];

			$this->append($data);
			$this->load('hardware');
			$this->right();
		}

	}

	//issues opened
	public function issues($lang = 'en', $user = '')
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		$data['title'] = "issues submitted - ".Website::$generalName;
		
		$this->shift(2);
		
		if ($this->userExists($clean['user']))
		{
			//load the Pages helper
			$this->helper('Pages','meet/issues/'.$this->lang.'/'.$clean['user'],'page');
		
			$clean['id_user'] = (int)$this->m['UsersModel']->getUserId($clean['user']);

			$this->m['IssuesModel']->select('id_issue')->where(array('created_by'=>$clean['id_user'],'deleted'=>'no'))->orderBy('id_issue desc');
			
			$recordNumber = $this->m['IssuesModel']->rowNumber();
			$page = $this->viewArgs['page'];
			
			$this->m['IssuesModel']->limit = $this->h['Pages']->getLimit($page,$recordNumber,20);
			
			$data['table'] = $this->m['IssuesModel']->select('id_issue,creation_date,title')->send();
			
			$data['pageList'] = $this->h['Pages']->render($page-3,7);
			
			$data['meet_username'] = $clean['user'];

			$this->append($data);
			$this->load('issues');
			$this->right();
		}

	}

	//messages submitted
	public function messages($lang = 'en', $user = '')
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		$data['title'] = "messages submitted - ".Website::$generalName;
		
		$this->shift(2);
		
		if ($this->userExists($clean['user']))
		{
			//load the Pages helper
			$this->helper('Pages','meet/messages/'.$this->lang.'/'.$clean['user'],'page');
			
			$clean['id_user'] = (int)$this->m['UsersModel']->getUserId($clean['user']);

			$this->m['MessagesModel']->from('messages inner join issues')->on('messages.id_issue=issues.id_issue')->select('id_mes,messages.id_issue,messages.creation_date,title')->where(array('created_by'=>$clean['id_user'],'deleted'=>'no'))->orderBy('id_mes desc');
			
			$recordNumber = $this->m['MessagesModel']->rowNumber();
			$page = $this->viewArgs['page'];
			
			$this->m['MessagesModel']->limit = $this->h['Pages']->getLimit($page,$recordNumber,20);
			
			$data['table'] = $this->m['MessagesModel']->send();
			
			$data['meet_username'] = $clean['user'];

			$data['pageList'] = $this->h['Pages']->render($page-3,7);
			
			$this->append($data);
			$this->load('messages');
			$this->right();
		}
	}

	//messages in the talk page
	public function talk($lang = 'en', $user = '')
	{
		$clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : '';
		$data['title'] = "messages submitted - ".Website::$generalName;
		
		$this->shift(2);
		
		if ($this->userExists($clean['user']))
		{
			//load the Pages helper
			$this->helper('Pages','meet/talk/'.$this->lang.'/'.$clean['user'],'page');
			
			$clean['id_user'] = (int)$this->m['UsersModel']->getUserId($clean['user']);

			$this->m['TalkModel']->from('talk inner join hardware')->using('id_hard')->select('talk.title,talk.creation_date,talk.id_hard,talk.id_talk,hardware.type')->where(array('created_by'=>$clean['id_user'],'deleted'=>'no'))->orderBy('id_talk desc');
			
			$recordNumber = $this->m['TalkModel']->rowNumber();
			$page = $this->viewArgs['page'];
			
			$this->m['TalkModel']->limit = $this->h['Pages']->getLimit($page,$recordNumber,20);
			
			$data['table'] = $this->m['TalkModel']->send();
			
			$data['meet_username'] = $clean['user'];

			$data['pageList'] = $this->h['Pages']->render($page-3,7);
			
			$this->append($data);
			$this->load('talk');
			$this->right();
		}
	}
}