wheredidgogogo

Experience

5,825

0 Best Reply Awards

  • Member Since 3 Years Ago
  • 69 Lessons Completed
  • 0 Favorites

8th October, 2015

wheredidgogogo started a new conversation Route Error Using PUT With Slug In Url • 2 years ago

Hi Guys,

I'm trying to get a put form model to work with a slug in the url. In my routes I have this resource:

''' Route::resource('organisations/{org_id}/admin/roles','Org\RoleController'); '''

Then on my edit form I have created the following:

''' {!! Form::model($role, array('method' => 'put','route' => array('organisations.'.$organisation->id.'.admin.roles.update', $role->id))) !!} '''

I get a route not defined error: Route [organisations.3.admin.roles.update] not defined.

Any suggestions?

3rd October, 2015

wheredidgogogo left a reply on HasManyThrough With Two Pivot Tables • 2 years ago

There was one little bit that I missed - adding the user id in the where statement - now it works :)

public function hasPermission($permission_name) { $result = \DB::table('users') ->join('role_user','users.id','=','role_user.user_id') ->join('roles','role_user.role_id','=','roles.id') ->join('permission_role','roles.id','=','permission_role.role_id') ->join('permissions','permission_role.permission_id','=','permissions.id') ->select('permissions.*')->where('users.id','=',\Auth::user()->id)->where('permissions.name','=',$permission_name)->count();

return $result > 0;

}

wheredidgogogo left a reply on HasManyThrough With Two Pivot Tables • 2 years ago

Here's the solution I came up with. Seems to work, not to sure how elegant it is....

public function hasPermission($permission_name) {

    $result = \DB::table('users')
        ->join('role_user','users.id','=','role_user.user_id')
        ->join('roles','role_user.role_id','=','roles.id')
        ->join('permission_role','roles.id','=','permission_role.role_id')
        ->join('permissions','permission_role.permission_id','=','permissions.id')
        ->select('permissions.*')->where('permissions.name','=',$permission_name)->count();

    if ($result > 0) {
        return true;
    } else {
        return false;
    }

}

wheredidgogogo left a reply on HasManyThrough With Two Pivot Tables • 2 years ago

Hi vpavic

Thanks for your response - I was worried I wasn't going to get a solution (it was very depressing watching all the other questions getting answered!)

I thought about the looping solution, but it didn't seem efficient. I'm hoping to get the result in one line of code.

I'll have a stab at solving it with query builder.

Seems odd that laravel hasn't got a simple solution for this.

wheredidgogogo started a new conversation HasManyThrough With Two Pivot Tables • 2 years ago

This one is starting to fry my brain...

I have five tables:

users roles_users (pivot) roles permissions_roles (pivot) permissions

I can't for the life of me create a query that returns the permissions for a given user.

I can get hasmanythrough to work with just one pivot table and a one-to-one relationship for the second step. But I can't get it to work when there are 2 many-to-many relationships.

Any help would be greatly appreciated :)

Edit Your Profile
Update

Want to change your profile photo? We pull from gravatar.com.