I designed a website pretty much around users and user permissions with DBVA-PHP Edition
What im trying to do seems like it should work… I created a permission via this script
<?
include "config.php";
$user = UsersDAO::loadUsersByORMID(1);
echo $user . "<hr>";
$permType = Permision_typesDAO::createPermision_types();
$permType->setDescription('modules');
Permision_typesDAO::save($permType);
echo $permType . "<hr>";
$cperm = PermissionDAO::createPermission();
$cperm->setPermision_typespermissiontype($permType);
$cperm->setDescription('news');
PermissionDAO::save($cperm);
echo $cperm . "<hr>";
$perms = User_permissionsDAO::createUser_permissions();
$perms->setPermission($cperm);
$perms->setUser($user);
User_permissionsDAO::save($perms);
echo $perms . "<hr>";
echo $user . "<hr>";
?>
Then when I want to get a users User_permissions, i should be able to load the user and then type $user->getPermissions();
However that doesnt work so i tried a different method, load all User_Permissions and compare user objects.
$userperms = User_permissionsDAO::listUser_permissionsByQuery(null,null);
foreach($userperms as $line)
{
print $line;
}
Gives me a
User_permissions[user_permissionid=1 user=null permission=null created=0 created_by=0 updated=0 updated_by=0 deleted=0 deleted_by=0 ]User_permissions[user_permissionid=2 user=null permission=null created=0 created_by=0 updated=0 updated_by=0 deleted=0 deleted_by=0 ]
And in my database, I can see, userid = 1;
If anyone wants me to attach the ERD let me know.