From 19272c7c88f5df7fbba47f120efe440b5a472315 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Sat, 30 Oct 2010 16:17:50 +0000 Subject: improved users history - part 1 --- .../Application/Controllers/MeetController.php | 214 +++++++++++++++++++++ .../Application/Controllers/UsersController.php | 63 ------ h-source/Application/Include/myFunctions.php | 23 +-- h-source/Application/Models/UsersModel.php | 16 ++ h-source/Application/Views/Issues/view.php | 3 +- h-source/Application/Views/Meet/contributions.php | 56 ++++++ h-source/Application/Views/Meet/hardware.php | 50 +++++ h-source/Application/Views/Meet/issues.php | 55 ++++++ h-source/Application/Views/Meet/meet.php | 89 +++++++++ h-source/Application/Views/Meet/messages.php | 54 ++++++ h-source/Application/Views/My/panel.php | 2 +- h-source/Application/Views/Users/contributions.php | 50 ----- h-source/Application/Views/Users/meet.php | 89 --------- h-source/Config/Route.php | 7 +- h-source/Public/Css/website.css | 9 + 15 files changed, 552 insertions(+), 228 deletions(-) create mode 100644 h-source/Application/Controllers/MeetController.php create mode 100644 h-source/Application/Views/Meet/contributions.php create mode 100644 h-source/Application/Views/Meet/hardware.php create mode 100644 h-source/Application/Views/Meet/issues.php create mode 100644 h-source/Application/Views/Meet/meet.php create mode 100644 h-source/Application/Views/Meet/messages.php delete mode 100644 h-source/Application/Views/Users/contributions.php delete mode 100644 h-source/Application/Views/Users/meet.php 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 @@ +. + +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 diff --git a/h-source/Application/Controllers/UsersController.php b/h-source/Application/Controllers/UsersController.php index db30483..cfa5170 100644 --- a/h-source/Application/Controllers/UsersController.php +++ b/h-source/Application/Controllers/UsersController.php @@ -361,68 +361,5 @@ class UsersController extends BaseController $this->redirect('users/login/'.$this->lang,0); } } - - public function meet($lang = 'en', $user = '') - { - $clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : ''; - $data['title'] = "meet ".$clean['user']." - ".Website::$generalName; - - if (strcmp($clean['user'],'') !== 0) - { - $this->shift(2); - - $res = $this->m['UsersModel']->db->select('regusers','has_confirmed,deleted,username','username="'.$clean['user'].'" and has_confirmed=0 and deleted="no"'); -// echo $this->m['UsersModel']->getQuery(); - if (count($res) > 0) - { - $whereArray = array( - 'username' => $clean['user'], - 'has_confirmed' => 0, - 'deleted' => 'no' - ); - - $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($whereArray)->send(); - - // echo $this->m['HardwareModel']->getQuery(); - - $data['meet_username'] = $res[0]['regusers']['username']; - - $this->append($data); - $this->load('meet'); - $this->right(); - } - } - } - - public function contributions($lang = 'en', $user = '') - { - $clean['user'] = ctype_alnum($user) ? sanitizeAll($user) : ''; - $data['title'] = $clean['user']." contributions - ".Website::$generalName; - - if (strcmp($clean['user'],'') !== 0) - { - $this->shift(2); - - $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) - { - $whereArray = array( - 'username' => $clean['user'], - 'has_confirmed' => 0, - 'deleted' => 'no' - ); - - $data['table'] = $this->m['HardwareModel']->select('hardware.*,regusers.username')->where($whereArray)->send(); - // echo $this->m['HardwareModel']->getQuery(); - - $data['meet_username'] = $res[0]['regusers']['username']; - - $this->append($data); - $this->load('contributions'); - $this->right(); - } - } - } } \ No newline at end of file diff --git a/h-source/Application/Include/myFunctions.php b/h-source/Application/Include/myFunctions.php index b72be6c..b95cc61 100644 --- a/h-source/Application/Include/myFunctions.php +++ b/h-source/Application/Include/myFunctions.php @@ -85,27 +85,6 @@ function getOrderByClause($string) } -// function isEqual($str1, $str2) -// { -// // $str1 = str_replace("\n",'',$str1); -// // $str1 = str_replace("\r",null,$str1); -// // $str2 = str_replace("\n",'',$str1); -// // $str2 = str_replace("\r",null,$str1); -// -// return (strcmp($str1,$str2) === 0) ? true : false; -// } -// -// function getNewKeys($array,$ovalue) -// { -// $res = array(); -// for ($i = 0; $i < count($array); $i++) -// { -// if (isEqual($array[$i],$ovalue)) $res[] = $i; -// // if (strcmp($keys[$i],$ovalue) === 0) $res[] = $i; -// } -// return $res; -// } - function diff($old, $new){ $maxlen = 0; foreach($old as $oindex => $ovalue){ @@ -168,7 +147,7 @@ function getLinkToUser($user) } else { - return "$user"; + return "$user"; } } diff --git a/h-source/Application/Models/UsersModel.php b/h-source/Application/Models/UsersModel.php index c425079..7a221cd 100755 --- a/h-source/Application/Models/UsersModel.php +++ b/h-source/Application/Models/UsersModel.php @@ -86,6 +86,22 @@ class UsersModel extends Model_Map } } + //get the user id from the username + public function getUserId($username) + { + $clean['username'] = ctype_alnum($username) ? sanitizeAll($username) : ''; + + $users = $this->select('id_user')->where(array('username'=>$clean['username'],'has_confirmed'=>0,'deleted'=>'no'))->send(); + if (count($users) > 0) + { + return $users[0]['regusers']['id_user']; + } + else + { + return 0; + } + } + public function insert() { //create the token diff --git a/h-source/Application/Views/Issues/view.php b/h-source/Application/Views/Issues/view.php index ef5e39c..d15b3ce 100644 --- a/h-source/Application/Views/Issues/view.php +++ b/h-source/Application/Views/Issues/view.php @@ -98,7 +98,8 @@ -
+ +
getUser($row['messages']['created_by']);?>: diff --git a/h-source/Application/Views/Meet/contributions.php b/h-source/Application/Views/Meet/contributions.php new file mode 100644 index 0000000..f679c71 --- /dev/null +++ b/h-source/Application/Views/Meet/contributions.php @@ -0,0 +1,56 @@ + + +. +?> + +
+ +
+ ">Home » ">meet » contributions +
+ +
+ contributions of +
+ +
+ + + +
+ ">hardware inserted/updated by +
+ + + + +
+ viewStatus;?>">issues opened by +
+ + + + +
+ viewStatus;?>">messages submitted by +
+ + +
+ +
\ No newline at end of file diff --git a/h-source/Application/Views/Meet/hardware.php b/h-source/Application/Views/Meet/hardware.php new file mode 100644 index 0000000..6cb2212 --- /dev/null +++ b/h-source/Application/Views/Meet/hardware.php @@ -0,0 +1,50 @@ + + +. +?> + +
+ +
+ ">Home » ">meet » ">contributions » hardware contributions +
+ +
+ hardware contributions of +
+ +
+ +
+ +
+ + "> +
+ +
+ +
+ +
\ No newline at end of file diff --git a/h-source/Application/Views/Meet/issues.php b/h-source/Application/Views/Meet/issues.php new file mode 100644 index 0000000..c1315e1 --- /dev/null +++ b/h-source/Application/Views/Meet/issues.php @@ -0,0 +1,55 @@ + + +. +?> + +
+ +
+ ">Home » ">meet » ">contributions » issues opened +
+ +
+ issues opened by +
+ +
+ +
+ +
+ + + baseUrl."/issues/view/$lang/$i_id'>".$i_title." at ".smartDate($i_date);?> +
+ +
+ +
+ +
+ : +
+ +
\ No newline at end of file diff --git a/h-source/Application/Views/Meet/meet.php b/h-source/Application/Views/Meet/meet.php new file mode 100644 index 0000000..35e106c --- /dev/null +++ b/h-source/Application/Views/Meet/meet.php @@ -0,0 +1,89 @@ + + +. +?> + +
+ +
+ ">Home » meet +
+ +
+ Public profile of . See all "> contributions +
+ + +
+ +
+
Username:
+
+ + +
+
My website:
+
+ + + +
+
My real name is:
+
+ + + +
+
My e-mail address:
+
+ + + +
+
I'm from:
+
+ + + +
+
Birthdate:
+
+ + + +
+
My favourite distro is:
+
+ + + +
+
Projects I'm working on:
+
+ + + +
+
My description:
+
+ + +
+ + +
\ No newline at end of file diff --git a/h-source/Application/Views/Meet/messages.php b/h-source/Application/Views/Meet/messages.php new file mode 100644 index 0000000..6b4085f --- /dev/null +++ b/h-source/Application/Views/Meet/messages.php @@ -0,0 +1,54 @@ + + +. +?> + +
+ +
+ ">Home » ">meet » ">contributions » messages submitted +
+ +
+ messages submitted by +
+ +
+ +
+ +
+ + + baseUrl."/issues/view/$lang/$i_id#message-$m_id'>".smartDate($m_date)."";?> submitted to the issue +
+ +
+ +
+ +
+ : +
+
\ No newline at end of file diff --git a/h-source/Application/Views/My/panel.php b/h-source/Application/Views/My/panel.php index d03d274..1052462 100644 --- a/h-source/Application/Views/My/panel.php +++ b/h-source/Application/Views/My/panel.php @@ -25,7 +25,7 @@
    -
  • Watch your public profile
    • +
  • Watch your public profile
  • Edit your profile
  • Change the e-mail address
  • Change the password
    • diff --git a/h-source/Application/Views/Users/contributions.php b/h-source/Application/Views/Users/contributions.php deleted file mode 100644 index 2d5995a..0000000 --- a/h-source/Application/Views/Users/contributions.php +++ /dev/null @@ -1,50 +0,0 @@ - - -. -?> - -
    - -
    - ">Home » ">meet » contributions -
    - -
    - contributions of -
    - -
    - -
    - -
    - - "> -
    - -
    - -
    - -
    \ No newline at end of file diff --git a/h-source/Application/Views/Users/meet.php b/h-source/Application/Views/Users/meet.php deleted file mode 100644 index ee0c708..0000000 --- a/h-source/Application/Views/Users/meet.php +++ /dev/null @@ -1,89 +0,0 @@ - - -. -?> - -
    - -
    - ">Home » meet -
    - -
    - Public profile of . See all "> contributions -
    - - -
    - -
    -
    Username:
    -
    - - -
    -
    My website:
    -
    - - - -
    -
    My real name is:
    -
    - - - -
    -
    My e-mail address:
    -
    - - - -
    -
    I'm from:
    -
    - - - -
    -
    Birthdate:
    -
    - - - -
    -
    My favourite distro is:
    -
    - - - -
    -
    Projects I'm working on:
    -
    - - - -
    -
    My description:
    -
    - - -
    - - -
    \ No newline at end of file diff --git a/h-source/Config/Route.php b/h-source/Config/Route.php index fd31718..b26caab 100644 --- a/h-source/Config/Route.php +++ b/h-source/Config/Route.php @@ -41,8 +41,11 @@ class Route 'users,change', 'users,forgot', 'users,notice', - 'users,meet', - 'users,contributions', + 'meet,user', + 'meet,contributions', + 'meet,hardware', + 'meet,issues', + 'meet,messages', 'wifi,catalogue', 'wifi,view', 'wifi,history', diff --git a/h-source/Public/Css/website.css b/h-source/Public/Css/website.css index 04e3c97..9809448 100755 --- a/h-source/Public/Css/website.css +++ b/h-source/Public/Css/website.css @@ -1436,4 +1436,13 @@ ins border:1px solid #6495ED; padding:5px; font:normal 14px/1.5 sans-serif,arial,Verdana; +} + +.user_hardware_pages +{ + margin:10px 5px; + padding:10px; + background:#F1D8D8; +/* border-bottom:1px solid #D26262; */ +/* border-top:1px solid #D26262; */ } \ No newline at end of file -- cgit v1.2.3