/** * Load langs from db * * @return mixed */ private function _loadLangs() { if ($this->_langsLoaded) { return; } /* @var $select Zend_Db_Select */ $select = $this->_dbTable->getAdapter()->select(); $select->from(array('l' => 'translate_language'), array('l.code', 'l.id', 'l.name', 'l.default', 'l.front_enabled')); $stmt = $select->query(); $langs = $stmt->fetchAll(); foreach ($langs as $lang) { self::$_languages[$lang['code']] = array('id' => $lang['id'], 'code' => $lang['code'], 'name' => $lang['name'], 'default' => $lang['default'] == 'yes', 'front_enabled' => $lang['front_enabled'] == 'yes'); //if default lang is not defined use first one as default if ($lang['default'] == 'yes' || !isset($this->_defaultLang)) { $this->_defaultLang = $lang['code']; } } $this->_langsLoaded = true; }
public static function getPagesCountByTemplate($templateName) { $pageDbTable = new Application_Model_DbTable_Page(); return $pageDbTable->getAdapter()->query($pageDbTable->select()->where('template_id="' . $templateName . '"'))->rowCount(); }