summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBjörn Geiger2011-10-28 14:57:06 +0200
committerBjörn Geiger2011-10-28 14:57:06 +0200
commitb150d8799d47f3df684a724514700b9a667e1646 (patch)
tree8afb962a6e3e0f7871d17f491ad8c77d6e4da063
parentStatistics (diff)
downloadpoolctrl-b150d8799d47f3df684a724514700b9a667e1646.tar.gz
poolctrl-b150d8799d47f3df684a724514700b9a667e1646.tar.xz
poolctrl-b150d8799d47f3df684a724514700b9a667e1646.zip
Statistics
-rwxr-xr-xapplication/models/EventMapper.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index d4f6b5c..d906297 100755
--- a/application/models/EventMapper.php
+++ b/application/models/EventMapper.php
@@ -267,7 +267,7 @@ class Application_Model_EventMapper
$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=1,0,1))')
+ array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,1,0))')
)
->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',
@@ -277,7 +277,7 @@ class Application_Model_EventMapper
$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=1,0,1))')
+ array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=1,1,0))')
)
->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',
@@ -303,7 +303,7 @@ class Application_Model_EventMapper
$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=1,0,1))')
+ array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,1,0))')
)
->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',
@@ -313,7 +313,7 @@ class Application_Model_EventMapper
$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=1,0,1))')
+ array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=1,1,0))')
)
->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',