summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBjörn Geiger2011-10-28 14:58:27 +0200
committerBjörn Geiger2011-10-28 14:58:27 +0200
commit1c06214f0109b8c152edab2ca6e76f580fe7cc9f (patch)
treee271aff58576a93563bf236772cc8d285207db36
parentStatistics (diff)
downloadpoolctrl-1c06214f0109b8c152edab2ca6e76f580fe7cc9f.tar.gz
poolctrl-1c06214f0109b8c152edab2ca6e76f580fe7cc9f.tar.xz
poolctrl-1c06214f0109b8c152edab2ca6e76f580fe7cc9f.zip
minor
-rwxr-xr-xapplication/layouts/default.phtml2
-rwxr-xr-xapplication/models/EventMapper.php8
2 files changed, 5 insertions, 5 deletions
diff --git a/application/layouts/default.phtml b/application/layouts/default.phtml
index 1c861dc..c8d0793 100755
--- a/application/layouts/default.phtml
+++ b/application/layouts/default.phtml
@@ -58,7 +58,7 @@ echo $this->headScript()."\n";
<li id='statisticsTree'>
<ul class='navTreeLevel1'>
<li class='navTreeItem'><a href='/statistics/category'>Category</a></li>
- <li class='navTreeItem'><a href='/statistics/running'>Running</a></li>
+ <!-- li class='navTreeItem'><a href='/statistics/running'>Running</a></li> -->
<li class='navTreeItem'><a href='/statistics/success'>Success</a></li>
<li class='navTreeItem'><a href='/statistics/type'>Type</a></li>
</ul>
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index d906297..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=1,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',
@@ -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,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',
@@ -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,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=1,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',