summaryrefslogtreecommitdiffstats
path: root/application/models/EventMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventMapper.php')
-rwxr-xr-xapplication/models/EventMapper.php256
1 files changed, 192 insertions, 64 deletions
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index 2fc4b71..0995a2d 100755
--- a/application/models/EventMapper.php
+++ b/application/models/EventMapper.php
@@ -187,101 +187,229 @@ class Application_Model_EventMapper
public function getCategoryBarCount($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'),
+ if($poolID != 'all'){
+ $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',
- array())
- ->where('pce.pbs_poolID = ?', $poolID)
- ->group('pce.category')
- ->order('pce.category ASC');
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID)
+ ->group('pce.category')
+ ->order('pce.category ASC');}
+ else {
+ $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',
+ array())
+ ->group('pce.category')
+ ->order('pce.category ASC');
+ }
- $stmt = $db->query($select);
- $result = $stmt->fetchAll(PDO::FETCH_NUM);
- $ret = null;
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $ret = null;
- foreach ($result as $r) {
- $ret[] = array((int)$r[0], $r[1]);
- }
+ foreach ($result as $r) {
+ $ret[] = array((int)$r[0], $r[1]);
+ }
- return array($ret);
+ 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'),
+ if($poolID != 'all'){
+ $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');}
+ else {
+ $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');
+ array())
+ ->group('pce.category')
+ ->order('pce.category ASC');
+ }
- $stmt = $db->query($select);
- $result = $stmt->fetchAll(PDO::FETCH_NUM);
- $ret = null;
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $ret = null;
- foreach ($result as $r) {
- $ret[] = array($r[0], (int)$r[1]);
- }
+ foreach ($result as $r) {
+ $ret[] = array($r[0], (int)$r[1]);
+ }
- return array($ret);
+ return array($ret);
}
public function getRunningBarCount($poolID) {
$db = Zend_Db_Table::getDefaultAdapter();
- $select = $this->getDbTable()->select()
- ->setIntegrityCheck(false)
- ->from(array('pce' => 'poolctrl_event'),
- array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=0,1,0))')
- )
- ->join(array('pcec' => 'poolctrl_eventcategory'),
+ if($poolID != 'all'){
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=0,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID);}
+ else {
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=0,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',
- array())
- ->where('pce.pbs_poolID = ?', $poolID);
+ array());
+ }
- $stmt = $db->query($select);
- $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
- foreach ($result as $r) {
- $ret1 = array((int)$r[0],'Event over');
- $ret2 = array((int)$r[1],'Event not over');
- $return[] = array($ret1,$ret2);
- }
+ foreach ($result as $r) {
+ $ret1 = array((int)$r[0],'Event over');
+ $ret2 = array((int)$r[1],'Event not over');
+ $return[] = array($ret1,$ret2);
+ }
- return $return;
+ return $return;
}
public function getRunningPieCount($poolID) {
$db = Zend_Db_Table::getDefaultAdapter();
- $select = $this->getDbTable()->select()
- ->setIntegrityCheck(false)
- ->from(array('pce' => 'poolctrl_event'),
- array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=0,1,0))')
- )
- ->join(array('pcec' => 'poolctrl_eventcategory'),
+ if($poolID != 'all'){
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=0,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID);}
+ else {
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=0,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',
- array())
- ->where('pce.pbs_poolID = ?', $poolID);
+ array());
+ }
- $stmt = $db->query($select);
- $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
- foreach ($result as $r) {
- $ret1 = array('running0', (int)$r[0]);
- $ret2 = array('running1', (int)$r[1]);
- $return[] = array($ret1,$ret2);
- }
+ foreach ($result as $r) {
+ $ret1 = array('Event over', (int)$r[0]);
+ $ret2 = array('Event not over', (int)$r[1]);
+ $return[] = array($ret1,$ret2);
+ }
+
+ return $return;
+ }
+
+ public function getTypeBarCount($poolID) {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ if($poolID != 'all'){
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('other' => 'SUM(IF(pce.repeat=0 AND pce.immediate=0,1,0))',
+ 'repeat' => 'SUM(IF(pce.repeat=1 AND pce.immediate=0,1,0))',
+ 'immediate' => 'SUM(IF(pce.repeat=0 AND pce.immediate=1,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID);}
+ else {
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('other' => 'SUM(IF(pce.repeat=0 AND pce.immediate=0,1,0))',
+ 'repeat' => 'SUM(IF(pce.repeat=1 AND pce.immediate=0,1,0))',
+ 'immediate' => 'SUM(IF(pce.repeat=0 AND pce.immediate=1,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array());
+ }
+
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
+
+ foreach ($result as $r) {
+ $ret1 = array((int)$r[0], 'other');
+ $ret2 = array((int)$r[1], 'repeat');
+ $ret3 = array((int)$r[2], 'immediate');
+ $return[] = array($ret1,$ret2,$ret3);
+ }
+
+ return $return;
+ }
+
+ public function getTypePieCount($poolID) {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ if($poolID != 'all'){
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('other' => 'SUM(IF(pce.repeat=0 AND pce.immediate=0,1,0))',
+ 'repeat' => 'SUM(IF(pce.repeat=1 AND pce.immediate=0,1,0))',
+ 'immediate' => 'SUM(IF(pce.repeat=0 AND pce.immediate=1,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID);}
+ else {
+ $select = $this->getDbTable()->select()
+ ->setIntegrityCheck(false)
+ ->from(array('pce' => 'poolctrl_event'),
+ array('other' => 'SUM(IF(pce.repeat=0 AND pce.immediate=0,1,0))',
+ 'repeat' => 'SUM(IF(pce.repeat=1 AND pce.immediate=0,1,0))',
+ 'immediate' => 'SUM(IF(pce.repeat=0 AND pce.immediate=1,1,0))')
+ )
+ ->join(array('pcec' => 'poolctrl_eventcategory'),
+ 'pce.category = pcec.eventcategoryID',
+ array());
+ }
+
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_NUM);
+
+ foreach ($result as $r) {
+ $ret1 = array('other', (int)$r[0]);
+ $ret2 = array('repeat', (int)$r[1]);
+ $ret3 = array('immediate', (int)$r[2]);
+ $return[] = array($ret1,$ret2,$ret3);
+ }
- return $return;
+ return $return;
}
} \ No newline at end of file