summaryrefslogtreecommitdiffstats
path: root/application/models/EventMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventMapper.php')
-rwxr-xr-xapplication/models/EventMapper.php57
1 files changed, 54 insertions, 3 deletions
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index af0b7b2..8d05754 100755
--- a/application/models/EventMapper.php
+++ b/application/models/EventMapper.php
@@ -184,7 +184,7 @@ class Application_Model_EventMapper
return array_diff($vv1,$vv2);
}
- public function getCategoryCount($poolID) {
+ public function getCategoryBarCount($poolID) {
$db = Zend_Db_Table::getDefaultAdapter();
$select = $this->getDbTable()->select()
@@ -192,9 +192,60 @@ class Application_Model_EventMapper
->from(array('pce' => 'poolctrl_event'),
array('count' => 'COUNT(*)', 'category' => 'pcec.title'))
->join(array('pcec' => 'poolctrl_eventcategory'),
- 'pce.category = pcec.eventcategoryID')
+ 'pce.category = pcec.eventcategoryID',
+ array())
->where('pce.pbs_poolID = ?', $poolID)
- ->group('pce.category');
+ ->group('pce.category')
+ ->order('pce.category ASC');
+
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $ret = null;
+
+ foreach ($result as $r) {
+ $ret[] = array((int)$r[0], $r[1]);
+ }
+
+ return array($ret);
+ }
+
+ public function getCategoryPieCount($poolID) {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('category' => 'pcec.title', 'count' => 'COUNT(*)'))
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID)
+ ->group('pce.category')
+ ->order('pce.category ASC');
+
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $ret = null;
+
+ foreach ($result as $r) {
+ $ret[] = array($r[0], (int)$r[1]);
+ }
+
+ return array($ret);
+ }
+
+ public function getRunningCount($poolID) {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('count' => 'COUNT(*)', 'category' => 'pcec.title'))
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID')
+ ->where('pce.pbs_poolID = ?', $poolID)
+ ->group('pce.category')
+ ->order('pce.category ASC');
$stmt = $db->query($select);
$result = $stmt->fetchAll(PDO::FETCH_NUM);