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 static function getSettings($param = null)
{
$ret = parent::getSettings($param);
$ret['useDirectorySelect'] = false;
$ret['generators']['child']['component']['view'] = 'Kwc_Directories_AjaxViewMultipleDirectories_View_Component';
return $ret;
}
public static function getSettings($param = null)
{
$ret = parent::getSettings($param);
$ret['generators']['detail'] = array('class' => 'Kwf_Component_Generator_Table', 'component' => 'Kwc_Directories_Item_Detail_Component');
$ret['generators']['child']['component']['view'] = 'Kwc_Directories_List_View_Component';
$ret['useDirectorySelect'] = false;
return $ret;
}
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()
{
$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()
{
$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()
{
$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 static function getSettings($param = null)
{
$ret = parent::getSettings($param);
$ret['generators']['child']['component']['view'] = 'Kwc_Blog_Box_LastPosts_View_Component';
return $ret;
}
public static function getSettings()
{
$ret = parent::getSettings();
return $ret;
}
public static function getSettings()
{
$ret = parent::getSettings();
$ret['generators']['child']['component']['view'] = 'Kwf_Component_Cache_Directory_Root_List_View_Component';
return $ret;
}
public static function getSettings($param = null)
{
$ret = parent::getSettings($param);
return $ret;
}
public function getSelect()
{
$ret = parent::getSelect();
$ret->whereEquals('parent_id', $this->getData()->parent->row->id);
return $ret;
}
public function getSelect()
{
$ret = parent::getSelect();
$ret->order('nickname');
return $ret;
}
public function getSelect()
{
$ret = parent::getSelect();
$ret->limit(5);
return $ret;
}
public static function getSettings($param = null)
{
$ret = parent::getSettings($param);
$ret['generators']['child']['component']['view'] = 'Kwc_Directories_AjaxViewTwoOnOnePage_View_Component';
return $ret;
}
