summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBjörn Geiger2011-10-28 14:56:05 +0200
committerBjörn Geiger2011-10-28 14:56:05 +0200
commit17ab349143baaeaf804afe936c0e14203f19ff55 (patch)
tree426ea6f89cae4a9a5ebd551132e9ab7707d4bc2c
parentStatistics (diff)
downloadpoolctrl-17ab349143baaeaf804afe936c0e14203f19ff55.tar.gz
poolctrl-17ab349143baaeaf804afe936c0e14203f19ff55.tar.xz
poolctrl-17ab349143baaeaf804afe936c0e14203f19ff55.zip
Statistics
-rwxr-xr-xapplication/models/EventMapper.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index 274cc34..d4f6b5c 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=0,1,0))')
+ array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,0,1))')
)
->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=0,1,0))')
+ array('count1' => 'SUM(IF(pce.running=1,1,0))', 'count0' => 'SUM(IF(pce.running=1,0,1))')
)
->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=0,1,0))')
+ array('over' => 'SUM(IF(pce.running=1,1,0))', 'not_over' => 'SUM(IF(pce.running=1,0,1))')
)
->join(array('pcec' => 'poolctrl_eventcategory'),
'pce.category = pcec.eventcategoryID',