/**
* Return an array with the user roles
* @return array
*/
public function getRoles()
{
$sql = 'SELECT name FROM {{%auth_item}} WHERE type = 1 ORDER BY name ASC';
$roles = Categories::findBySql($sql)->asArray()->all();
$array = ['public' => 'Public'];
foreach ($roles as $role) {
$array[ucwords($role['name'])] = ucwords($role['name']);
}
return $array;
}
public function getCategoriesSelect2()
{
$sql = 'SELECT id,name FROM {{%article_categories}} WHERE state = 1';
$categories = Categories::findBySql($sql)->asArray()->all();
$array[0] = \Yii::t('articles', 'No Category');
foreach ($categories as $category) {
$array[$category['id']] = $category['name'];
}
return $array;
}
