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