aboutsummaryrefslogtreecommitdiff
path: root/h-source/Application/Controllers/SpecialController.php
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2012-05-28 15:28:35 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2012-05-28 15:28:35 +0000
commit054086b33dad4c4f7089cf2ebf0f52eed1d7a023 (patch)
treed78d83a895e239b3495e9ac52ecee0107b2a2f61 /h-source/Application/Controllers/SpecialController.php
parent7097598d5576ba5e9391b43f26bfc037c08d61c3 (diff)
administrators can now view the actions of a single user in a compact format
Diffstat (limited to 'h-source/Application/Controllers/SpecialController.php')
-rw-r--r--h-source/Application/Controllers/SpecialController.php17
1 files changed, 11 insertions, 6 deletions
diff --git a/h-source/Application/Controllers/SpecialController.php b/h-source/Application/Controllers/SpecialController.php
index 9298ad3..a118211 100644
--- a/h-source/Application/Controllers/SpecialController.php
+++ b/h-source/Application/Controllers/SpecialController.php
@@ -33,7 +33,9 @@ class SpecialController extends BaseController
$data['title'] = gtext('last modifications').' - '.Website::$generalName;
$this->append($data);
- $this->setArgKeys(array('page:forceNat'=>1));
+ Params::$nullQueryValue = 'undef';
+
+ $this->setArgKeys(array('page:forceNat'=>1,'username:sanitizeAll'=>'undef'));
}
protected function last($lang = 'en',$action = 'modifications')
@@ -78,11 +80,12 @@ class SpecialController extends BaseController
break;
}
-
+ $whereClauseArray['username'] = $this->viewArgs['username'];
+
$this->helper('Pages','special/'.$this->action.'/'.$this->lang,'page');
-
- $this->m['HistoryModel']->clear()->select()->where($whereClauseArray)->orderBy('id_history desc');
-
+
+ $this->m['HistoryModel']->clear()->left('regusers')->on('history.created_by=regusers.id_user')->select("history.*,regusers.username")->where($whereClauseArray)->orderBy('id_history desc');
+
$recordNumber = $this->m['HistoryModel']->rowNumber();
$page = $this->viewArgs['page'];
@@ -90,6 +93,8 @@ class SpecialController extends BaseController
$data['table'] = $this->m['HistoryModel']->send();
+// echo $this->m['HistoryModel']->getQuery();
+
$data['pageList'] = $this->h['Pages']->render($page-5,11);
$this->append($data);
@@ -120,7 +125,7 @@ class SpecialController extends BaseController
$this->m['HistoryModel']->limit = $this->h['Pages']->getLimit($page,$recordNumber,30);
$data['table'] = $this->m['HistoryModel']->send();
-
+
$data['pageList'] = $this->h['Pages']->render($page-5,11);
$this->append($data);