Page 1 of 2

Members in Multiple Groups

Posted: 2013-05-31 14:03
by MsMetaP
I would like to be able to assign members to more than one group. I have several people who have overlapping functions and trying to set up all these groups for them is crazy hard. Defining the groups is easy, but some people need to belong to more than one. Any possibility?

I do know about the "set special permissions" but this is tedious when you have to do it for many people. Thanks!

Re: Members in Multiple Groups

Posted: 2013-06-04 00:38
by a.gneady
I have this feature on my to-do list for future releases. Stay tuned!

Re: Members in Multiple Groups

Posted: 2013-11-15 21:41
by bobwhitleyjr
Any updates on when this is going to be available?

Re: Members in Multiple Groups

Posted: 2013-11-17 23:18
by a.gneady
Sorry not yet unfortunately ... I'll start planning the features of the next release within a week or so by scanning through the suggestions in the forum and seeing which ones are most asked for .. I think this one is among the most-requested so it could be implemented in the next release.

Re: Members in Multiple Groups

Posted: 2014-04-01 18:46
by bobwhitleyjr
Any updates on adding the multiple group membership?

Re: Members in Multiple Groups

Posted: 2014-04-05 08:53
by a.gneady
Sorry, not yet. Will try to add it in the next release if time permits.

Re: Members in Multiple Groups

Posted: 2014-04-06 11:01
by Geeman
In my humble opinion, multi group membership [access control] would be a huge step forward towards leveraging the power of AppGini (out of the box) in a corporate/enterprise environment. As would enabling integration with wordpress (or other CMS).

I'd be happy to pay an additional premium for a 'pro' version for the above enhancements :D

Re: Members in Multiple Groups

Posted: 2014-04-06 16:12
by a.gneady
Thanks for the feedback, Geeman. I'm indeed considering an enterprise version with several advanced features including, besides multiple group memberships, activity logs, support for master/slave databases, and other advanced features. No date has been set yet, but hopefully before the end of this year.

Re: Members in Multiple Groups

Posted: 2014-04-07 11:17
by dssc
Well, if it encourages Ahmed to push on with AppGini development I, too, would be prepared to pay for a Pro version. My top wants are (1) field level security; (2) multiple group memberships and (3) to see published a short book on commonly used script commands for Hooks so that in-betweens like me can do more with the programme.

Re: Members in Multiple Groups

Posted: 2014-04-07 21:19
by KSan
+1 for a Pro version. I'd be more than happy to pay for continued development of AppGini.

Not trying to be negative here as I full well know how challenging it is to be a one-man-do-it-all outfit. I appreciate all that Ahmad has enabled us to do with AppGini and at such a modest cost. But, the sooner the better for all these most requested features.

I wish Ahmad would partner with others and expedite the delivery of new versions.

Re: Members in Multiple Groups

Posted: 2014-04-10 12:30
by lakshmi
Hello,

I am currently using appgini, this is the wonderful application to work with, if you can add multigroup membership, field level security and integration with any cms would be greatly helpful for the users of appgini to develop enterprise application. We would be more than happy to pay for this features.

Thanks a lot.

Re: Members in Multiple Groups

Posted: 2014-04-14 06:07
by a.gneady
Thank you all for this awesome feedback ... I'll sure work on adding these features, maybe to an "enterprise edition", or some other flashy name ;)

Re: Members in Multiple Groups

Posted: 2014-04-14 06:48
by dssc
That's great, Ahmed. But please don't feel that we are just leaning on you for these features. I get the impression that people here really want the product (and you) to be even more successful. So work with the community. I'm sure there are those who can assist directly and indirectly. Tell us what you need.

Re: Members in Multiple Groups

Posted: 2014-04-15 20:16
by a.gneady
I'm sure there are those who can assist directly and indirectly. Tell us what you need.
Yep ... I'm sure of that as well ... Actually, I'm currently working on an add-ons framework for AppGini applications to make it easy to add additional functionality to applications without having to modify their code -- It's much more flexible than the current hooks implementation. Once I finish the framework, I'll publish its technical documentation for anyone who's interested in developing add-ons ... Maybe this could start some small market place for add-ons.

Re: Members in Multiple Groups

Posted: 2014-04-16 14:45
by KSan
Great idea & development. Way to go!!! Thank you very much for your continued investment in AppGini.

Re: Members in Multiple Groups

Posted: 2014-05-11 14:33
by ebrief
+1 for Pro version. I will help beta test if you want feedback.
With 15 years as an open-source software engineer, Ahmed your AppGini program is the best. I purchased my copy in February 24, 2013. It was a solid PHP code generator and database setup program from the beginning. But, you gave us an easy way to build attractive websites and web apps for a smart phone when you introduced bootstrap templates. Rock Star move!

I also could use a group assigned to a user that has access to a list of groups.

Once again, thank you for your wisdom in creating this awesome application and clean php code generation software.

- Stafford Shealy

Re: Members in Multiple Groups

Posted: 2017-06-05 10:07
by uow513
Hello Ahmed,

Any update on multiple group feature?

Regards

Re: Members in Multiple Groups

Posted: 2017-06-26 19:36
by facos79
sarebbe ottimo

Re: Members in Multiple Groups

Posted: 2017-08-13 20:47
by patsd102
Anyone ideas on this?

Re: Members in Multiple Groups

Posted: 2017-11-19 21:19
by vaalonv
Any update on this.. I need it badly for some of my application in enterprise level. I've already bought Appgini but if this feature is add i will donate and participate on helping this beautiful and great platform on development.

Re: Members in Multiple Groups

Posted: 2017-11-22 17:18
by a.gneady
Well ... seems this thread is getting revived with fresh interest :) We're currently working hard to release AppGini 5.70 ... Once we do so, we'll start planning some enterprise add-on features including the above requested ones as well as SSO/LDAP integration. Stay tuned!

Re: Members in Multiple Groups

Posted: 2018-05-17 20:54
by facos79
What's new about this feature for multiple groups?

Re: Members in Multiple Groups

Posted: 2018-05-19 12:09
by a.gneady
It's planned for AppGini 5.80 later this year. Stay tuned.

Re: Members in Multiple Groups

Posted: 2018-09-17 23:38
by sandy3269
Hi Ahmad,

I've been keeping abreast of this feature myself and have an application launch that would benefit from this. The multiple group or LDAP (better) thing would be a game changer for me. Being semi retired, I create lots of small applications for small - medium businesses but if you enabled LDAP out of the box, my corporate contacts would fall in line quickly.

Fingers are crossed. :D :D :D

Re: Members in Multiple Groups

Posted: 2018-10-31 11:55
by jsetzer
patsd102 wrote:
2017-08-13 20:47
Anyone ideas on this?
Just a crazy :cry: idea which came into my mind recently:
  1. Create a table and form for assigning a member to multiple groups (membership_user_groups) with columns id, memberID, groupID. You should create a unique contstraint on the database table with columns memberID and groupID.
  2. You need to create views on the database to read all members (for example 'view_members') and groups (for example 'view_groups') and tables 'view_members' and 'view_groups' within your AppGini project having identical column definitions as the views have. This has been discussed elsewhere on this forum.
  3. Use your new form to assign groups to members, for example assign groups 1, 3 and 4 to member "User1".
  4. On save, get the assigned groupIDs (distinct, sorted), which are [1, 3, 4], and build a unique name from the IDs like "grp_1+3+4" using PHP. Caution: column membership_groups.name is VarChar[20] only.
  5. Insert a new group named "grp_1+3+4" into membership_groups table (if not already exists) using SQL in PHP.
  6. Assign the member "User 1" to the new group (if not already assigned) using SQL in PHP.
  7. Read the permissions of all groups [1, 3, 4], merge the permissions per table and insert the merged permissions per table into the membership_grouppermissions table for group "grp-1+3+4" using SQL in PHP.
That's it. Should work (without having tested it).

Member-Group-Assignment
If there is a second user, let's say "User2" who will be assigned to the same groups 1, 3 and 4, the merged group "grp_1+3+4" already exists. In this case just assign "User2" to group "grp_1+3+4" and that's it.


Merging
Merging the group permissions is not a trivial task. It will become complicated if there are conflicts like this one:
  • insert is allowed for group 1
  • insert is denied for group 3
There you will have to decide about permission-priorities (Allow > Deny or Deny > Allow).

It will be even more complicated for merging Read, Update and Delete permissions because there may be conflicts between No-, User-, Group-, All-permissions. That depends on your requirements and implementation is up to you.

There will be a couple of situations to consider. For example after modification of group-permissions, the merged permissions have to be updated, too. I think it would be useful to have an "update-merged-group-permissions" script to automatically do those changes on the database whenever you need to.


As said before, I did not implement it, yet, because I do not need it up to now. But as far as I know AppGini, this should work. I have already done dynamic group-creation and member-assignment via PHP and SQL commands. It's not trivial, but you can do.

I hope this helps someone until multi-group-assignment will be a built-in feature.

Regards,
Jan