render('header', [ 'main_navigation' => $this->retrieveNavigation('main'), 'hidden_navigation' => $this->retrieveHiddenNavigation() ]); } private function retrieveHiddenNavigation() { $data = Navigation::find() ->where(['is_active' => 1, 'in_submenu' => 1]); $webPage = \Yii::$app->request->get('webPage'); if($webPage == 'partnjor' || $webPage == 'partner' || \Yii::$app->controller->id == 'partner') { $data = $data->andWhere(['partner_page' => 1]); } $data = $data->orderBy(['order_index' => SORT_ASC])->parseAll('id, page_id, url, url_authorised, order_index', [ 'name' => 'ts_en_name', ])->all(); return $data; } private function retrieveNavigation($menu_type) { $data = Navigation::find() ->where(['is_active' => 1, 'menu_type' => $menu_type]) ->andWhere(['IS', 'in_submenu', null]) ->andWhere(['IS', 'home_conn', null]); $webPage = \Yii::$app->request->get('webPage'); if($webPage == 'partnjor' || $webPage == 'partner' || \Yii::$app->controller->id == 'partner') { $data = $data->andWhere(['partner_page' => 1]); } $data = $data->orderBy(['order_index' => SORT_ASC])->parseAll('id, page_id, url, order_index', [ 'name' => 'ts_en_name', ])->all(); return $data; } }