Laravel: Generate unique slug

UniqueSlug.php

/*
 * Does not need to be wrapped in a class, I often have this in my model, 
 * but abstract when used more than once.
 * @soruce: http://chrishayes.ca/blog/code/laravel-4-generating-unique-slugs-elegantly
 */
class UniqueSlug {
  
	public static function generateUniqueSlug($value) {
		$slug = Str::slug($value);
	        $slugs = static::whereRaw("slug REGEXP '^{$slug}(-[0-9]*)?$'");
	        
	        if ($slugs->count() === 0)
	            return $slug;
	
	        // get reverse order and get first
	        $lastSlugNumber = intval(str_replace($slug . '-', '', $slugs->orderBy('slug', 'desc')->first()->slug));
	        return $slug . '-' . ($lastSlugNumber + 1);
	}
  
}