SlugService

<?php

namespace App\Services;

use DB;

class SlugService
{
    public static function create($title, $table, $id = 0)
    {
        $slug     = str_slug($title);
        $allSlugs = static::getRelatedSlugs($slug, $table, $id);
        if (!$allSlugs->contains('slug', $slug)) {
            return $slug;
        }
        for ($i = 1; $i <= 10; $i++) {
            $newSlug = $slug . '-' . $i;
            if (!$allSlugs->contains('slug', $newSlug)) {
                return $newSlug;
            }
        }
        throw new \Exception('Can not create a unique slug');
    }
    protected static function getRelatedSlugs($slug, $table, $id = 0)
    {
        return DB::table($table)
            ->select('slug')
            ->where('slug', 'like', $slug . '%')
            ->where('id', '<>', $id)
            ->get();
    }
}