/**
* 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();
}
