I need to Implement some functionality, which allow to grant access to only specific orders from Reports module for users from differend security groups.
I've got two ProductGroup:
ProductGroup1 with ID=10 and
ProductGroup2 with ID=11.
in this groups I've got some products and their variations, so their data looks like that:
Name | ID | ParentID
Prod1 | 12 |10
Prod2 | 13 | 10
Prod3 | 14 | 11
Prod4 | 15 | 11
I've got also two Security groups, and I want to grant access for first one only to orders from ProductGroup1 , and the second one only to orders from ProductGroup2.
Is this possible to do something like that, and if answer for that is YES, my second questions is : how could I do that and where would be the best place to put some code to get this functionality?
PS: Sorry for my english skill ;/ I hope somebody will understand what I mean :)