public function getSelect() { $select = parent::getSelect(); $select->where('publish_date <= CURDATE()'); $select->order('publish_date', 'DESC'); return $select; }
public function getSelect() { $select = parent::getSelect(); $select->where('publish_date <= CURDATE()'); if (Kwc_Abstract::getSetting($this->_getSetting('masterComponentClass'), 'enableExpireDate')) { $select->where('expiry_date >= CURDATE() OR ISNULL(expiry_date)'); } $select->order('publish_date', 'DESC'); return $select; }
public function getSelect() { $ret = parent::getSelect(); $ret->order('start_date', 'ASC'); return $ret; }