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; }