Expand sentry users table

Question

I expanded Sentry users table with few columns, but in this case I need help for city_id column. I did it in Laravel migrations. Now I need to make relationship between Sentry users and cities table.

I try to expand Sentry user Model and add belongsTo, but I cannot use it from Sentry::findUserById() like Sentry::findUserById()->with('city')

How can I expand Sentry user model with relationship to another table/model?

score 0 · Answer 1 · answered Jul 18 '14 at 06:06

0

class User extends Eloquent {
    public function city() {
        return $this->hasOne('City', 'id', 'city_id');
    }
}

Then you should be able to do something like this in your controller

$city = User::find($id)->city->name;

Or in your view you can do

{{ $user->city->name }}

answered Jul 18 '14 at 06:06

Nathan

184
2
6

I used Sentry not Laravel default User model – Kolesar Jul 18 '14 at 06:08
well then in the Sentry model add the method and instead of the query I gave you use $city = Sentry::findUserById($id)->city->name; – Nathan Jul 18 '14 at 06:14

Expand sentry users table

1 Answers1