public function toExcelAction() { $this->filename = 'StaticTexts.xlsx'; $this->tables = array('Static_Texts' => array('ST_Identifier', 'ST_Desc_backend', 'ST_Value', 'ST_LangID')); $this->fields = array('ST_LangID' => array('width' => '', 'label' => ''), 'ST_Desc_backend' => array('width' => '', 'label' => ''), 'ST_Value' => array('width' => '', 'label' => '')); $this->filters = array(); $staticText = new StaticTexts(); $this->select = $staticText->select()->where('Static_Texts.ST_Editable = ?', 1)->where('Static_Texts.ST_Type = ?', 'client'); parent::toExcelAction(); }
public static function getClientStaticText($identifier, $lang = null) { if (is_null($lang)) { $lang = Zend_Registry::get('languageID'); } $staticText = new StaticTexts(); $select = $staticText->select()->where("ST_Identifier = ?", $identifier)->where("ST_LangID = ?", $lang); //die($select); return $staticText->fetchRow($select); }