public static function getRubricsForSelect($app_id = 0)
{
$sections = [];
$sql = "SELECT s.id, st.title\n FROM " . Rubric::tableName() . " as s\n LEFT JOIN " . RubricTranslate::tableName() . " as st\n ON s.id = st.rubric_id\n WHERE st.language = :lang and s.app_id = :app_id\n \n ";
$models = RubricTranslate::findBySql($sql, [':lang' => Yii::$app->language, ':app_id' => $app_id])->all();
foreach ($models as $model) {
$sections[$model->id] = $model->title;
}
return $sections;
}
