wheredidgogogo

wheredidgogogo

Member Since 3 Years Ago

Experience Points 5,925
Experience
Level
Lessons Completed 67
Lessons
Completed
Best Reply Awards 0
Best Answer
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • Chatty Cathy Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

08 Oct
3 years ago

wheredidgogogo started a new conversation Route Error Using PUT With Slug In Url

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?

03 Oct
3 years ago

wheredidgogogo left a reply on HasManyThrough With Two Pivot Tables

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

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

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

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 :)