/**
* Get all existing slugs that are similar to the given slug.
*
* @param string $slug
* @param Model $model
*
* @return Illuminate\Support\Collection
*/
protected function getExistingSlugs($slug, Model $model)
{
$separator = array_get($this->config, 'slug_separator');
$query = $model->newQuery()->join($model->page->getTable(), $model->page->getTable() . '.' . $model->page->getKeyName(), '=', $model->getQualifiedPageColumnKey())->where($model->page->getScopedConditions())->where($model->page->getParentColumnName(), $model->page->parent_id)->where($model->getLangColumnKey(), $model->{$model->getLangColumnKey()})->where(function (Builder $q) use($slug, $separator, $model) {
$q->where($model->getSlugColumnKey(), '=', $slug)->orWhere($model->getSlugColumnKey(), 'LIKE', $slug . $separator . '%');
});
$list = $query->select([$model->getSlugColumnKey()])->get();
return $list->pluck([$model->getSlugColumnKey()]);
}
