public static function all()
    {
        $connection = Yii::app()->db;
        $sql = 'SELECT * FROM `services` ORDER BY name ASC';
        $models = $connection->createCommand($sql)->queryAll();
        $array = array();
        foreach ($models as $one) {
            $array[$one['id']] = $one['name'];
        }
        return $array;
    }