Laravel Call to undefined method Illuminate\Database\Eloquent\Builder::privilege()

Question

I would like to display privileges('name') instead of idPrivilege in the user collection. I have tried to add a relationship and use it in an Eloquent call but I'm getting an error.

User model

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    use Notifiable;

    protected $table = 'users';

    protected $primaryKey = 'idUser';

    protected $fillable = [
        'name', 'email',
    ];

    protected $hidden = [
        'password', 'updated_at',
    ];

    public function privilege()
    {
        return $this->hasOne(Privilege::class, 'idPrivilege', 'idPrivilege');
    }
}

Privilege model

namespace App;

use Illuminate\Database\Eloquent\Model;

class Privilege extends Model
{
    protected $table = 'privileges';

    protected $primaryKey = 'idPrivilege';

    protected $fillable = [
        'name',
    ];

    protected $hidden = [
        'updated_at', 
    ];

    public function user()
    {
        return $this->belongsTo(User::class, 'idPrivilege', 'idPrivilege');
    }
}

UserController

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\User;

class UserController extends Controller
{
    public function relationTest()
    {
        return User::where('idUser', 1)->privilege()->get();
    }
}

I'm getting the below error when I use with('privilege') to my User collection is added privilege collection.

Call to undefined method Illuminate\Database\Eloquent\Builder::privilege().

Please can you show what you're expected output is?

Rwd
– Rwd

2019-05-05 14:54:12 +00:00
Commented May 5, 2019 at 14:54 — Rwd
– Rwd, Commented May 5, 2019 at 14:54
in answer below i show the output i expect

Martin
– Martin

2019-05-05 15:17:40 +00:00
Commented May 5, 2019 at 15:17 — Martin
– Martin, Commented May 5, 2019 at 15:17

nakov · Accepted Answer · 2019-05-05 14:37:14Z

0

where returns a Builder instance on which a privilege method does not exist, so you can simply use it as such:

return User::find(1)->privilege()->get();;

-- EDIT

User::find(1)->with(['privilege' => function($query) { 
   $query->select('name');
}])->get();

edited May 5, 2019 at 14:37

answered May 5, 2019 at 14:21

nakov

14.4k14 gold badges74 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Martin Over a year ago

It returns : [ { "idPrivilege": 1, "name": "user", "created_at": "2019-05-04 12:56:55" } ] and yes i have user in db with idPrivilege (1)

nakov Over a year ago

and what do you expect to be returned? That's the privilege object in json format.

Martin Over a year ago

User object with replaced idPrivilege to privilege (name of idPrivilege), { "idUser": 1, "name": "Martin", "email": "[email protected]", "idPrivilege": 1, "created_at": "2019-05-04 12:11:43" } => { "idUser": 1, "name": "Martin", "email": "[email protected]", "privilege": "user", "created_at": "2019-05-04 12:11:43" }

Martin · Accepted Answer · 2019-05-05 15:00:09Z

0

I can achieve it by using resource:

$user = User::where('idUser', 1)->with('privilege')->first();
return UserResource::make($user);

Inside UserResource:

public function toArray($request)
{
    return [
        'idUser' => $this->idUser,
        'name' => $this->name,
        'email' => $this->email,
        'privilege' => $this->privilege['name'],
        'createdAt' => $this->created_at,
    ];
}

but was hoping there is simplier method of getting that.

output:

{
"data": {
"idUser": 1,
"name": "Martin",
"email": "[email protected]",
"privilege": "user",
"createdAt": "2019-05-05T01:11:43.000000Z"
}
}

answered May 5, 2019 at 15:00

Martin

761 silver badge7 bronze badges

Collectives™ on Stack Overflow

Laravel Call to undefined method Illuminate\Database\Eloquent\Builder::privilege()

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related