From 1e5fdb6b8ec38bb867b2c7813f19afb67e0091b0 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Fri, 28 Oct 2011 13:47:29 +0200 Subject: Statistics korrigiert --- application/models/EventreportMapper.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/application/models/EventreportMapper.php b/application/models/EventreportMapper.php index 89c1124..b785f4a 100755 --- a/application/models/EventreportMapper.php +++ b/application/models/EventreportMapper.php @@ -171,7 +171,7 @@ class Application_Model_EventreportMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pcr' => 'poolctrl_eventreport'), - array('count1' => 'SUM(IF(pcr.result="successful",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') + array('count1' => 'SUM(IF(pcr.result="succeeded",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') ) ->join(array('pce' => 'poolctrl_event'), 'pce.eventID = pcr.eventID', @@ -181,7 +181,7 @@ class Application_Model_EventreportMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pcr' => 'poolctrl_eventreport'), - array('count1' => 'SUM(IF(pcr.result="successful",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') + array('count1' => 'SUM(IF(pcr.result="succeeded",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') ) ->join(array('pce' => 'poolctrl_event'), 'pce.eventID = pcr.eventID', @@ -207,7 +207,7 @@ class Application_Model_EventreportMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pcr' => 'poolctrl_eventreport'), - array('count1' => 'SUM(IF(pcr.result="successful",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') + array('count1' => 'SUM(IF(pcr.result="succeeded",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') ) ->join(array('pce' => 'poolctrl_event'), 'pce.eventID = pcr.eventID', @@ -217,7 +217,7 @@ class Application_Model_EventreportMapper $select = $this->getDbTable()->select() ->setIntegrityCheck(false) ->from(array('pcr' => 'poolctrl_eventreport'), - array('count1' => 'SUM(IF(pcr.result="successful",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') + array('count1' => 'SUM(IF(pcr.result="succeeded",1,0))', 'count0' => 'SUM(IF(pcr.result="failed",1,0))') ) ->join(array('pce' => 'poolctrl_event'), 'pce.eventID = pcr.eventID', -- cgit v1.2.3-55-g7522