aboutsummaryrefslogtreecommitdiff
path: root/h-source/Application/Controllers/MeetController.php
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2010-10-30 16:17:50 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2010-10-30 16:17:50 +0000
commit19272c7c88f5df7fbba47f120efe440b5a472315 (patch)
treef083c49d68644ca2aea0175c886e94de4e6eb18c /h-source/Application/Controllers/MeetController.php
parent4641de870cfa9c5d4c41a94328a8fb1f4adfdc78 (diff)
improved users history - part 1
Diffstat (limited to 'h-source/Application/Controllers/MeetController.php')
-rw-r--r--h-source/Application/Controllers/MeetController.php214
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