public function __construct() { /* * Need to implement these features .Roles,Resources and Access */ /* * Roles * */ $db = Zend_Db_Table::getDefaultAdapter(); $roles = $db->fetchAll("select grantname from ob_grant"); foreach ($roles as $role) { $this->addRole(new Zend_Acl_Role($role['grantname'])); } // Eg. admin, manager /* * Resources * */ $db = Zend_Db_Table::getDefaultAdapter(); $resources = $db->fetchAll("select submodule_description from ob_submodule"); foreach ($resources as $resources) { $this->add(new Zend_Acl_Resource($resources['submodule_description'])); } // folder name management----> /* * Access * */ $rolenames = new App_Model_Users(); $db = Zend_Db_Table::getDefaultAdapter(); $access = $db->fetchAll("SELECT B.grant_id,\n \t\t B.submodule_id,\n \t\t C.activity_id\n \t\t FROM\n \t\t ob_grantactivites B,\n \t\t ob_subactivity C\n \t\t where\n \t\t C.activity_id = B.activity_id"); //edit,view,___, foreach ($access as $access) { if ($access["activity_id"]) { $this->allow($rolenames->getRoleName($access["grant_id"]), $rolenames->getResourceName($access["submodule_id"]), 1); } else { $this->deny($rolenames->getRoleName($access["grant_id"]), $rolenames->getResourceName($access["submodule_id"]), 0); } } }