public function actionIndex() { $searchModel = new PostSearch(); $dataProvider = $searchModel->search(Yii::$app->request->get()); $postStatuses = Post::getStatusArray(); $users = []; return $this->render('index', ['dataProvider' => $dataProvider, 'searchModel' => $searchModel, 'postStatuses' => $postStatuses, 'users' => $users]); }
public static function getPostByAlias($alias) { if ($alias) { $sql = "SELECT p.id, pt.full_text, pt.title, pt.meta_title,\n pt.meta_descriptions, pt.meta_keywords, pt.preview_text\n FROM " . Post::tableName() . " as p\n LEFT JOIN " . PostTranslate::tableName() . " as pt\n ON p.id = pt.post_id\n WHERE pt.language = :lang\n AND p.alias = :alias AND p.app_id =:app_id "; return PostTranslate::findBySql($sql, [':lang' => Yii::$app->language, ':alias' => $alias, ':app_id' => \Yii::$app->getModule('cms')->app_id])->one(); $serch = new PostSearch(); $serch->search([]); } return false; }