private function getDefaultLang($field = false)
{
if ($this->_lang === null) {
$this->_lang = Lang::findActive();
}
if ($field) {
return $this->_lang[$field];
}
return $this->_lang;
}
/**
* @todo use AR or queryCommand? NavItem::find()->leftJoin('cms_nav_item_module', 'nav_item_type_id=cms_nav_item_module.id')->where(['nav_item_type' => 2, 'cms_nav_item_module.module_name' => $moduleName])->asArray()->one()
*
* @param unknown $moduleName
*
* @return unknown
*/
public static function findNavItem($moduleName)
{
if (isset(self::$_navItemModules[$moduleName])) {
return self::$_navItemModules[$moduleName];
}
// current active lang:
$default = Lang::findActive();
$query = Yii::$app->db->createCommand('SELECT i.* FROM cms_nav_item as i LEFT JOIN (cms_nav_item_module as m) ON (i.nav_item_type_id=m.id) WHERE i.nav_item_type=2 AND i.lang_id=:lang_id AND m.module_name=:module')->bindValues([':module' => $moduleName, ':lang_id' => $default['id']])->queryOne();
self::$_navItemModules[$moduleName] = $query;
return $query;
}
