public function getSelect() { $select = parent::getSelect(); $select->limit($this->_getSetting('entryLimit')); $select->order('id', 'DESC'); return $select; }
public function getSelect() { $select = parent::getSelect(); $dateColumn = Kwc_Abstract::getSetting($this->getData()->parent->componentClass, 'dateColumn'); $select = $this->_getDateSelect($select, $dateColumn); return $select; }
public function getSelect($overrideValues = array()) { $ret = parent::getSelect($overrideValues); if ($this->getRow()->component) { $ret->whereEquals('component', $this->getRow()->component); } return $ret; }
public function getSelect() { $select = parent::getSelect(); if (!$select) { return $select; } $select->whereEquals('BrowseNode', $this->getData()->row->node_id); return $select; }
public function getSelect() { $class = $this->getData()->parent->parent->componentClass; $childReference = Kwc_Abstract::hasSetting($class, 'childReferenceName') ? Kwc_Abstract::getSetting($class, 'childReferenceName') : 'Categories'; $select = parent::getSelect(); $s = new Kwf_Model_Select(); $s->whereEquals('category_id', $this->getData()->parent->id); $select->where(new Kwf_Model_Select_Expr_Child_Contains($childReference, $s)); return $select; }
public function getSelect() { $ret = parent::getSelect(); if (!$ret) { return null; } $ret->where('IF(ISNULL(end_date), start_date, end_date) < NOW()'); $ret->order('start_date', 'DESC'); return $ret; }
public function getSelect() { $ret = parent::getSelect(); $categoryDirectory = $this->getItemDirectory()->getComponent(); $refData = Kwc_Directories_Category_Detail_List_Component::getTableReferenceData(Kwc_Abstract::getSetting(get_class($categoryDirectory), 'categoryToItemModelName'), 'Category'); $ret->join($refData['tableName'], "{$refData['refTableName']}.{$refData['refItemColumn']} = " . "{$refData['tableName']}.{$refData['itemColumn']}", array()); $refDataItem = Kwc_Directories_Category_Detail_List_Component::getTableReferenceData(Kwc_Abstract::getSetting(get_class($categoryDirectory), 'categoryToItemModelName'), 'Item'); $ret->where($refDataItem['tableName'] . '.' . $refDataItem['itemColumn'] . ' = ?', $this->_getItemDetail()->row->id); return $ret; }
public function getSelect() { $select = parent::getSelect(); if (!$select) { return null; } if ($this->_getSetting('limit')) { $select->limit($this->_getSetting('limit')); } return $select; }
public function getSelect() { $ret = parent::getSelect(); $tagIds = $this->_getTagIds(); if (!$tagIds) { return null; } $ret->join('kwc_components_to_tags', "kwc_components_to_tags.component_id = CONCAT('news_', kwc_news.id)", array()); $ret->where('kwc_components_to_tags.tag_id IN (' . implode(',', $tagIds) . ')'); $ret->group('kwc_news.id'); //eigene seite nicht anzeigen $ret->where('kwc_components_to_tags.component_id != ?', $this->getData()->getPage()->dbId); return $ret; }
public function getSelect() { if (!$this->getRow()->category_id) { throw new Kwf_Exception_Client(trlKwf('No category selected.')); } $model = Kwf_Model_Abstract::getInstance(Kwc_Abstract::getSetting($this->_getSetting('categoryComponentClass'), 'categoryToItemModelName')); $itemIds = array(); $s = $model->select()->whereEquals('category_id', $this->getRow()->getParentRow('Category')->getRecursiveIds()); foreach ($model->getRows($s) as $row) { $itemIds[] = $row->item_id; } $select = parent::getSelect(); $select->whereEquals('id', array_unique($itemIds)); $select->order('date', 'DESC'); $select->order('priority', 'DESC'); return $select; }
public function getSelect() { $select = parent::getSelect(); if (!$select) { return null; } $s = new Kwf_Component_Select(); $s->whereGenerator('categories'); $tableName = Kwc_Abstract::getSetting($this->getItemDirectory()->getChildComponent($s)->componentClass, 'categoryToItemModelName'); $refData = Kwc_Directories_Category_Detail_List_Component::getTableReferenceData($tableName, 'Item'); $select->join($refData['tableName'], $refData['tableName'] . '.' . $refData['itemColumn'] . '=' . $refData['refTableName'] . '.' . $refData['refItemColumn'], array()); $ids = $this->getCategoryIds(); if (!$ids) { return null; } $select->where($refData['tableName'] . '.category_id IN (' . implode(',', $ids) . ')'); return $select; }
public function getSelect() { $ret = parent::getSelect(); $ret->order('nickname'); return $ret; }
public function getSelect() { $ret = parent::getSelect(); $ret->limit(5); return $ret; }
public function getSelect() { $ret = parent::getSelect(); $ret->whereEquals('parent_id', $this->getData()->parent->row->id); return $ret; }