I am using PB 12.5.2 I want to implement Access Control List. ie appliction user or user group has right for CRUD if he has the permission he can able to perform the operation. I created acl, user_permission and group_permission table.
CREATE TABLE `acl` (
`acl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`company_id` int(10) unsigned NOT NULL,
`module_name` varchar(50) NOT NULL, //Menu Option
`module_type` char(1) NOT NULL, //Master, Report, Transaction, Stock
`table_name` varchar(50) NULL, //table name in case of report set it null
`trade` varchar(30) NOT NULL DEFAULT 'Retail',
PRIMARY KEY (`acl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
her for each menu option I created a row in acl table. I managed the pb_add, pb_delete, pb_save button by writing a set_permission_wf() inside my base_w its working fine.
Now I want to hide the menu options, I don't want to hard code the it also Its multi-lingual it contain 2 more menu and some vertical that I am managing from acl.trade column.
How do I iterate menu options, toolbar without hard coding.
Is there any why I can set multiple menu relations with acl row?