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