[L5] Need help with Roles and Premissons

You'd probably want a pivot table with attributes, or a pivot model, to represent a relationship between a user and a course. That solves the first issue of granting access to a course for a specific user. Then you'd have some middleware that checks if the current user has access to the course/lesson they're trying to access.

Then you may also want another to represent their progress. Though that could probably be managed with the same pivot table/pivot model.

I think you could manage it with a table structure for your pivot table something like this:

$table->integer('user_id');
$table->integer('course_id');
$table->integer('progress')->unsigned()->nullable();

user_id and course_id are obvious. The progress field could simply represent the highest lesson number they are able to access.

The admin, after grading a test would hit a button or something to update 'progress' to the next value, on successful pass of the test.

This would work if for each course you have lessons numbered logically 1-10, for example. So by default, when a user is granted access to a course, you could set 'progess' to 1, indicating that they have access to lesson 1, and its associated test. After they take that test, and pass, progress would be updated to 2, and so on.

Looking at your post again, I see you have some other conditions for allowing access to tests, but the same general approach would probably work out just fine I think.

Thanks, really good approach. hmm, but one more question. Access to test for lesson is given after you submit that you are finished studying, and then Admin gives access to Lesson Test.

While Member is doing test he cannot access that Lesson material.

Crazy it is so difficult. :D

Maybe there could be lessons_progress as you told, but also test_status

0 - > No access to test

1 - > Access to test and no access to lesson

2 - > Access to test and lesson after Admin accepts Test.

You can use middleware for that as well. You can check if the user is has finished studying and set something in the database for that. Let's say that you have a table with these fields:

id
title
description
studyingDone
testsDone

Then you can easily check if the user has finished something or not and it is easy to assign for the admin ;)

Note: This is just bad naming, I'm a bit tired :P

Crazy it is so difficult.

Only as difficult as you make it for yourself. ;)

Just think through the steps logically. How do you need to track each piece, and how do you want to store that?

All of it could be managed with a single pivot table with attributes, and then middleware can enforce access to things outside of what they have access to as defined in that table.
The values in that pivot table can also be leveraged to determine what to show users on list pages too.

For now I have Courses -> Lessons relationship If I make Relationship between Users and Courses

Will I be able to access User-> Lessons or User->Courses->Lessons?

Like to print out All user finished lessons.

And the same with Lessons Tests if I make such relation ship. Will I be able to print out All Course Tests?

what could be best relationships between all Models?

User->Course->Lesson->Test

@roulendz you might want to take a look at this middleware for an idea.