Changeset 8 for branches/2/user.php

Timestamp:

May 9, 2008, 10:39:00 AM (17 years ago)

Author:

george

Message:

Přidáno: Oprávnění pro čtení a zápis k rolím a operacím.
Přidáno: Zobrazení matice oprávnění.
Přidáno: Uživatelské menu s proměnným obsahem podle role uživatele.
Upraveno: Rozdělení importu na import z mangosu a import ze staré databáze.

File:

• branches/2/user.php (modified) (5 diffs)

branches/2/user.php

@@ -16 +16 @@
 class User extends Module
 {
-  var $Roles = array('Člen', 'Uživatel', 'Administrator');
+  var $Roles = array();
   var $User = array();
+  var $DefaultRole = 2;
   
   function Check()
   {
     $SID = session_id();
+
     // Lookup user record
     $Query = $this->Database->select('UserOnline', '*', 'SessionId="'.$SID.'"');
@@ -28 +30 @@
       // Refresh time of last access
       $this->Database->update('UserOnline', 'SessionId="'.$SID.'"', array('Time' => 'NOW()'));
-    } else $this->Database->insert('UserOnline', array('SessionId' => $SID, 'User' => 0, 'Time' => 'NOW()', 'IpAddress' => (gethostbyaddr(GetRemoteAddress()).' '.GetRemoteAddress())));  
+    } else $this->Database->insert('UserOnline', array('SessionId' => $SID, 'User' => 1, 'Time' => 'NOW()', 'IpAddress' => (gethostbyaddr(GetRemoteAddress()).' '.GetRemoteAddress())));  
 
     // Odeber neaktivní uživatele
@@ -38 +40 @@
     if($Row['User'] != 0) 
     {
-      $Query = $this->Database->select('User', '*', "Id='".$Row['User']."'");
+      $Query = $this->Database->select('User', '*', "Id=".$Row['User']."");
       $this->User = $Query->fetch_array();
       $Result = USER_LOGGED;
     } else {
-      $this->User = array('FullName' => 'Návštěvník', 'Id' => 0, 'Name' => 'Anonym');
+      $Query = $this->Database->select('User', '*', "Id=1");
+      $this->User = $Query->fetch_array();
       $Result = USER_NOT_LOGGED;
     }
+    $this->LoadPermission($this->User['Role']);
+
+    // Role and permission
+    $this->LoadRoles();
+    
   }
 
@@ -59 +67 @@
       else 
       {
-        $this->Database->insert('User', array('Name' => addslashes($Nick), 'FullName' => addslashes($FullName), 'Password' => addslashes($Password), 'Email' => htmlspecialchars($Email), 'Permission' => 1));
+        $this->Database->insert('User', array('Name' => addslashes($Nick), 'FullName' => addslashes($FullName), 'Password' => addslashes($Password), 'Email' => htmlspecialchars($Email), 'Role' => $this->DefaultRole));
         $Result = USER_REGISTRATED;
       }
@@ -89 +97 @@
   {
     $SID = session_id();
-    $this->Database->update('UserOnline', 'SessionId="'.$SID.'"', array('User' => 0));
+    $this->Database->update('UserOnline', 'SessionId="'.$SID.'"', array('User' => 1));
     return(USER_LOGGED_OUT);
+  }
+
+  function LoadRoles()
+  {
+    $this->Roles = array();
+    $DbResult = $this->Database->select('UserRole', '*');
+    while($DbRow = $DbResult->fetch_array())
+      $this->Roles[] = $DbRow;
+  }
+
+  function LoadPermission($Role)
+  {
+    $this->User['Permission'] = array();
+    $DbResult = $this->Database->query('SELECT `UserRolePermission`.*, `PermissionOperation`.`Description` FROM `UserRolePermission` JOIN `PermissionOperation` ON `PermissionOperation`.`Id` = `UserRolePermission`.`Operation` WHERE `UserRolePermission`.`Role` = '.$Role);
+    if($DbResult->num_rows > 0)
+    while($DbRow = $DbResult->fetch_array())
+      $this->User['Permission'][$DbRow['Operation']] = $DbRow;
+  }
+
+  function PermissionMatrix()
+  {
+    $Result = array();
+    $DbResult = $this->Database->query('SELECT `UserRolePermission`.*, `PermissionOperation`.`Description`, `UserRole`.`Title` FROM `UserRolePermission` LEFT JOIN `PermissionOperation` ON `PermissionOperation`.`Id` = `UserRolePermission`.`Operation` LEFT JOIN `UserRole` ON `UserRole`.`Id` = `UserRolePermission`.`Role`');
+    while($DbRow = $DbResult->fetch_array())
+    {
+      $Value = '';
+      if($DbRow['Read']) $Value .= 'R';
+      if($DbRow['Write']) $Value .= 'W';
+      $Result[$DbRow['Description']][$DbRow['Title']] = $Value;
+    }   
+    return($Result);
   }
 }