improved users history - part 1

1 files changed, 214 insertions, 0 deletions

diff --git a/h-source/Application/Controllers/MeetController.php b/h-source/Application/Controllers/MeetController.php
new file mode 100644
index 0000000..d2ccc27
--- /dev/null
+++ b/h-source/Application/Controllers/MeetController.php
@@ -0,0 +1,214 @@
+<?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 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 3 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, 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');
+		
+		$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();
+			
+			$data['hasHardware'] = $hardNumb > 0 ? true : false;
+			$data['hasIssues'] = $issuesNumb > 0 ? true : false;
+			$data['hasMessages'] = $messNumb > 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();
+		}
+
+	}
+	
+}
\ No newline at end of file