summaryrefslogtreecommitdiffstats
path: root/application/models/EventcategoryMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventcategoryMapper.php')
-rwxr-xr-xapplication/models/EventcategoryMapper.php40
1 files changed, 26 insertions, 14 deletions
diff --git a/application/models/EventcategoryMapper.php b/application/models/EventcategoryMapper.php
index f481140..f1a5996 100755
--- a/application/models/EventcategoryMapper.php
+++ b/application/models/EventcategoryMapper.php
@@ -155,23 +155,35 @@ class Application_Model_EventcategoryMapper
public function getCategoryColor($poolID) {
$db = Zend_Db_Table::getDefaultAdapter();
- $select = $this->getDbTable()->select()
- ->distinct()
- ->setIntegrityCheck(false)
- ->from(array('pcec' => 'poolctrl_eventcategory'),
- array('color' => 'pcec.color'))
- ->join(array('pce' => 'poolctrl_event'),
+ if($poolID != 'all'){
+ $select = $this->getDbTable()->select()
+ ->distinct()
+ ->setIntegrityCheck(false)
+ ->from(array('pcec' => 'poolctrl_eventcategory'),
+ array('color' => 'pcec.color'))
+ ->join(array('pce' => 'poolctrl_event'),
+ 'pce.category = pcec.eventcategoryID',
+ array())
+ ->where('pce.pbs_poolID = ?', $poolID)
+ ->group('pce.category')
+ ->order('eventcategoryID ASC');}
+ else {
+ $select = $this->getDbTable()->select()
+ ->distinct()
+ ->setIntegrityCheck(false)
+ ->from(array('pcec' => 'poolctrl_eventcategory'),
+ array('color' => 'pcec.color'))
+ ->join(array('pce' => 'poolctrl_event'),
'pce.category = pcec.eventcategoryID',
- array())
- ->where('pce.pbs_poolID = ?', $poolID)
- ->group('pce.category')
- ->order('eventcategoryID ASC')
- ;
+ array())
+ ->group('pce.category')
+ ->order('eventcategoryID ASC');
+ }
- $stmt = $db->query($select);
- $result = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
- return $result;
+ return $result;
}
} \ No newline at end of file