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