Btukfyl

I really hope I don't get shouted down for a vague question, but I'm struggling to find a good answer to this. I'm looking for the most efficient way to check for nested matches within a Laravel blade template.

I'm cool with PHP, but still getting used to using a framework and I'm trying to get off on the right (and most efficient) foot with it.

I have an edit user page, to which my user is assigned permissions. Just like a forum, there are literally hundreds of permissions to pick from.

The edit page is shown, and underneath there is a table of possible permissions with a radio button for yes/no.

@foreach($permissionsAvailable as $permission)

    <tr>

        <td class="hub3Blue hub3FontSmall">{{ $permission->name }}</td>

        <td class="hub3FontSmall">{{ $permission->description }}</td>

        <td>

            <form name="{{$permission->id}}">

                <div class="form-group">

                    <div class="form-check form-check-inline">

                        <input class="form-check-input permissionCheck" type="radio" id="{{$permission->id}}"

                               onclick="sendPermission('{{$permission->id}}','yes')" name="hasPermission">

                        <label class="form-check-label" for="hasPermission">Yes</label>

                    </div>

                    <div class="form-check form-check-inline">

                        <input class="form-check-input permissionCheck" type="radio" id="{{$permission->id}}"

                               onclick="sendPermission('{{$permission->id}}','no')" name="hasPermission">

                        <label class="form-check-label" for="hasPermission">No</label>

                    </div>

                </div>

            </form>

        </td>

    </tr>

@endforeach

There is a jQuery function to update the permission_user table, either adding a permission or removing it. This is fine. What I am trying to achieve is a way of getting all of the yes/no radio buttons checked, or not, but I'm struggling with a "best practice" way of doing it.

I figured the simplest way would be to include a PHP function at the bottom of the page, but this would need to query the database for every iteration to see if the permission was allocated to that user.

The other way I suppose is to bring the permissions table in, in full to the blade template, ie compact it with the other data and then compare against the array data. Speedier I assume, but still doing a lot of work. If I have 100 users, with 100 possible permission, that's [potentially] an array of 10,000 entries.

Some guidance would be really appreciated, guys.

SQL structure/relationship

Table: permission_user

+---------------+------------------+------+-----+---------+----------------+

| Field         | Type             | Null | Key | Default | Extra          |

+---------------+------------------+------+-----+---------+----------------+

| id            | int(10) unsigned | NO   | PRI | NULL    | auto_increment |

| permission_id | int(10) unsigned | NO   | MUL | NULL    |                |

| user_id       | int(10) unsigned | NO   | MUL | NULL    |                |

| created_at    | timestamp        | YES  |     | NULL    |                |

| updated_at    | timestamp        | YES  |     | NULL    |                |

+---------------+------------------+------+-----+---------+----------------+

So as the table of permissions is looped, it needs to check each permission_id to see if it has a row that exists with a corresponding user_id.

check if [row_exists] in permission_user WHERE permission_id = permission_id AND user_id = user_id

... is the best way I can describe it.

I'm aware I may be asking for an efficiency that just doesn't exist.

OK, so I was doing this from the wrong end, which I think shows my novice levels of Laravel/Eloquent use. I should have been getting all of the permissions available on page load in my user controller and then passing that array to my blade template to check.

Get all of my users permissions first in my controller:

$userPermissions= AdminUsersPermissions::where('user_id', $id)->get();

return view('admin.users.edit',compact('user','permissionsAvailable','userPermissions')); 

Then in my blade template:

foreach($userPermissions as $permission)

  {

    $hasPermissions = $permission->permission_id;

  }

Then when I'm looping through the permissions I can say:

$checkedNo = "checked";

$checkedYes = "";

if(in_array({{$permission->id}}, $hasPermissions)

{

  $checkedYes = "checked";

  $checkedNo = ""; 

}

For the form entry:

<div class="form-check form-check-inline">

  <input class="form-check-input permissionCheck" type="radio" id="{{$permission->id}}" onclick="sendPermission('{{$permission->id}}','yes')" name="hasPermission" <?=$checkedYes;?> >

  <label class="form-check-label" for="hasPermission">Yes</label>

</div>

<div class="form-check form-check-inline">

  <input class="form-check-input permissionCheck" type="radio" id="{{$permission->id}}" onclick="sendPermission('{{$permission->id}}','no')" name="hasPermission" <?=$checkedNo;?> >

  <label class="form-check-label" for="hasPermission">No</label>

</div>

Well that's the best I can come up with anyway :/