I am using the following Menu Manager http://codecanyon.ne...r-system/637633 to create a dynamic menu for an application.
The menu contains a parent, child and grandchild (or parents, children, grandchildren)
Here is an example:
Home User Profile WLM | --> Faculty Dashboard | --> Dashboard Settings | --> Send Faculty Email | | --> Exam Schedule | --> Add/Edit Exam Time | --> View Exam Schedule
When the user logs in to the application, I would like a specific menu to be displayed depending on the user's role/group (Admin gets all menu items and has full access).
I have researched various ways to get the user's permissions (sessions, arrays, query the DB each time the user clicks a page, etc.) but I want to avoid unnecessary overhead but allow users to see their menus (and not be able to access other pages).
For example, let's say I have a user who has the role of "Leader" and I want to give the user/role/group access to the following page only: WLM --> Faculty Dashboard --> Send Faculty Email (as shown above).
I was thinking of several DB tables (User, Group/Role, Resources/Pages, Permissions), however, how would I go about getting only the specific menu items for the user/group?
The challenge is the Menu Manager stores the menu items (parent, child, grandchild) in one database table (please see the attached screenshot).
Is there a way to easily go through the table for this? OR should I not use the menu manager and try a different approach?
Any help/feedback would be greatly appreciated.
Edited by jenkins, 10 February 2013 - 01:12 PM.