I would like a similar method in this package, and I don't know if it exists.

[osquelsantisteban]

I would like a similar method in this package, and I don't know if it exists. Where it receives a search parameter if it exists and is like a like and not a where.

// $this->buscar   text to Search

//! get_roles
    public function get_roles(){

        $roles = Role::all();
        $rolSearch = [];
        if($this->buscar){
            foreach($roles as $rol){
                if(Str::contains(Str::upper($rol->getAttribute('name')), Str::upper($this->buscar)))
                {
                    $rolSearch[] = $rol;
                }
            }
        }
        else
            return $roles;

        return $rolSearch;
    }

[fredsal]

mamma mia, spaghetti
that's the worst code i've seen in some time

use early return, use collection native methods

[osquelsantisteban]

Sorry i forgot, scopeBuscar , but this work ok, this whereHas is the one that doesn't work

->whereHas('roles',function($query) use ($buscar){ $query->where('name', 'like', '%' . ((string) $buscar) . '%'); })

/*  Model User   */
class User extends Authenticatable
{
    use HasApiTokens;
    use HasFactory;
    use HasProfilePhoto;
    use Notifiable;
    use TwoFactorAuthenticatable;
    use HasRoles;
     ...

    /* Scope Buscar */
    public function scopeBuscar( $query, $buscar){
        if($buscar == '') return;

        return $query
        ->orwhere('id', 'like', "%{$buscar}%")
        ->orwhere('email', 'like', "%{$buscar}%")
        ->orwhere('name', '=', "{$buscar}")
        ->orwhereIn('ueb_id', function($query) use ($buscar){
                $query->select('id')->from('uebs')->where('nombre','like',"%{$buscar}%")->get();
        })
        ;
    }



     /*  Controller  */

    //! get_usuarios
    public function get_usuarios(){

        $buscar = $this->buscar;
        $usuarios = User::buscar($this->buscar)
            ->with('ueb','roles')
            ->whereHas('roles',function($query) use ($buscar){
                $query->where('name', 'like', '%' . ((string) $buscar) . '%');
            })
            ->orderBy($this->sort,$this->direction)
            ->paginate($this->cantidad);
        return $usuarios;
    }

[fredsal]

You should also learn the basics of sql, you can't ask every two lines of code
Also, use google for the exception you get, up I'm sure you have ambiguity issues

[systemsolutionweb]

I'm sure you have ambiguity issues

+1

[osquelsantisteban]

I solved

public function scopeBuscar( $query, $buscar){
        if($buscar == '') return;

        return $query
        ->orwhere('id', 'like', "%{$buscar}%")
        ->orwhere('email', 'like', "%{$buscar}%")
        ->orwhere('name', '=', "{$buscar}")
        ->orwhereIn('ueb_id', function($query) use ($buscar){
                $query->select('id')->from('uebs')->where('nombre','like',"%{$buscar}%")->get();
        })
        ->when($buscar, function($q,$buscar){
            //Filter Role
            $rolesSearch = Role::where('name', 'like', '%' . ((string) $buscar) . '%')
                ->get()
                ->pluck('name');

            //Filter User by Role
                return User::role($rolesSearch);
        })
        ;
    }

[erikn69]

If it is fixed, mark as answered