When I create a Group such as "Office" or "Trainer" and Members are Assigned as Office Group Members I see no way to get finer control of Permissions in AppGini.
In my pre-existing projects which I am trying to duplicate in AppGini the system that worked quite well was to have a Master Users table.
- The Primary Key numeric value of the Users table contained in a column called "trainerid", or "ownerid" is the Master reference value and field name in common in all tables used to mark a record as "belonging" to trainer 39,27,56.. etc.
In those pre-existing projects the program I used asked me to specify which table would be used as the USERS table to refer to for logins and permissions and it asked for me to choose the Field that contained the value to be associated with Users on login. - Trainer Sam Carpenter's trainerid value is 36.
The project Admin has 14 business records that she wants to assign to Sam.
She updates all of those Parent table records by putting 39 into the trainerid column field of those 14 records in the business_info table.
When the Admin assigns trainers to the Trainers Group with set permissions about each table she marks each table as being dependent on "Ownership"
Trainer Sam Carpenter logs in and gets the tables and permissions that the Admin specified when she added the Trainers Group
IN MY PROJECTS (built before I bought AppGini) at this point each trainer will only see the specific records in each table that have that trainer's trainerid value in the trainerid column. That is OWNERSHIP.
In those projects built with another program
When Trainers create new records in Detail Tables borrowing information from the Parent business info table the new records are marked with the trainerid value as the logged in Trainer who is generating or modifying Child/Detail records.
If this Is the case I am faced with a big problem because I must come up with a coding workaround.
If there is no way with existing AppGini functions to pre-assign specific records to each trainer in every table then it disqualifies AppGini from use in my cases.
I know specific mods then would have to be added to hooks with hard coded lookups since there is no Admin panel function to build or modify user permissions to this extent.
If my assumption now is correct do you have suggestions about adding coding to the hooks available at login to help achieve this function?
Thank you, thank you.
