From 17ab349143baaeaf804afe936c0e14203f19ff55 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Fri, 28 Oct 2011 14:56:05 +0200 Subject: Statistics --- application/models/EventMapper.php | 6 +++--- 1 file 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', -- cgit v1.2.3-55-g7522