summaryrefslogtreecommitdiffstats
path: root/application/models/EventreportMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventreportMapper.php')
-rwxr-xr-xapplication/models/EventreportMapper.php8
1 files 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',