Changeset 107 for devel/www/temp/transform.php

Timestamp:

Sep 14, 2008, 5:54:37 PM (16 years ago)

Author:

george

Message:

• Přidáno: Skripty pro import aktualit ze stránek zdechov.cz.
• Upraveno: Doplněno generování oprávnění v prvotním transformačním skriptu.
• Upraveno: Názvy položek oprávnění.

File:

• devel/www/temp/transform.php (modified) (2 diffs)

devel/www/temp/transform.php

@@ -129 +129 @@
     $Output = '';
 
-    // Init User table from users
+    // Clear previous content
+    $this->Database->query('TRUNCATE TABLE PermissionOperation');
+    $this->Database->query('TRUNCATE TABLE PermissionGroup');
+    $this->Database->query('TRUNCATE TABLE PermissionGroupAssignment');
+    $this->Database->query('TRUNCATE TABLE PermissionUserAssignment');
     $this->Database->query('TRUNCATE TABLE User');
     $this->Database->query('TRUNCATE TABLE Subject');
 
+    // Init permission groups
+    $this->Database->insert('PermissionGroup', array('Description' => 'Ostatní'));
+    $PermissionGroupOthers = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroup', array('Description' => 'Členové sítě'));
+    $PermissionGroupMembers = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupMembers, 'GroupOrOperation' => $PermissionGroupOthers, 'Type' => 'Group'));
+echo($this->Database->LastQuery);
+    $this->Database->insert('PermissionGroup', array('Description' => 'Zástupci za domácnost'));
+    $PermissionGroupSubjects = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupSubjects, 'GroupOrOperation' => $PermissionGroupMembers, 'Type' => 'Group'));
+$this->Database->insert('PermissionGroup', array('Description' => 'Správci sítě'));
+    $PermissionGroupNetworkAdmins = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $PermissionGroupSubjects, 'Type' => 'Group'));
+    $this->Database->insert('PermissionGroup', array('Description' => 'Systémoví administrátoři'));
+    $PermissionGroupAdmin = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupAdmin, 'GroupOrOperation' => $PermissionGroupNetworkAdmins, 'Type' => 'Group'));
+
+    // Init permission operations
+    $this->Database->insert('PermissionOperation', array('Module' => 'News', 'Operation' => 'Display', 'Item' => 'Item'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $DbResult = $this->Database->select('news_category', 'id, permission');
+    while($DbRow = $DbResult->fetch_array())
+    {
+      $this->Database->insert('PermissionOperation', array('Module' => 'News', 'Operation' => 'Insert', 'Item' => 'Group', 'ItemId' => $DbRow['id']));
+      $OperationIdInsert = $this->Database->insert_id;
+      $this->Database->insert('PermissionOperation', array('Module' => 'News', 'Operation' => 'Display', 'Item' => 'Group', 'ItemId' => $DbRow['id']));
+      $OperationIdDisplay = $this->Database->insert_id;
+      $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationIdDisplay, 'Type' => 'Operation'));
+      if($DbRow['permission'] == 1)
+      {
+        $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOoperation' => $OperationIdInsert, 'Type' => 'Operation'));
+      } else
+      {
+        $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationIdInsert, 'Type' => 'Operation'));
+      }
+    }
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Chat', 'Operation' => 'Display'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Share', 'Operation' => 'Display'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupMembers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Finance', 'Operation' => 'DisplaySubjectState'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupSubjects, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'EatingPlace', 'Operation' => 'Edit'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupMembers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Finance', 'Operation' => 'Manage'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Network', 'Operation' => 'Edit'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Finance', 'Operation' => 'SubjectList'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Log', 'Operation' => 'Show'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    // Init User table from users
     $DbResult = $this->Database->select('users', '*');
     while($DbRow = $DbResult->fetch_array())
     {
       $this->Database->insert('User', array('Id' => $DbRow['id'], 'Name' => $DbRow['nick'], 'FirstName' => $DbRow['first_name'], 'SecondName' => $DbRow['second_name'], 'PhoneNumber' => $DbRow['phone'], 'Password' => substr(sha1(strtoupper($DbRow['nick'])), 0, 7), 'ICQ' => $DbRow['icq'], 'Email' => $DbRow['email'], 'Locked' => 0));
+      $UserId = $this->Database->insert_id;
+      if($DbRow['id'] == 1) 
+      {
+        $this->Database->insert('PermissionUserAssignment', array('User' => $UserId, 'GroupOrOperation' => $PermissionGroupAdmin, 'Type' => 'Group'));
+      } else
       if($DbRow['role'] == 2)
       {
         $this->Database->insert('Subject', array('Id' => $DbRow['id'], 'Name' => $DbRow['subject_name'], 'AddressStreet' => $DbRow['street'], 'AddressTown' => $DbRow['town'], 'AddressPSC' => $DbRow['psc'], 'IC' => $DbRow['ico'], 'DIC' => $DbRow['dic'], 'FamilyMemberCount' => $DbRow['family'], 'MapPositionX' => $DbRow['PositionX'], 'MapPositionY' => $DbRow['PositionY'], 'NetworkSegment' => $DbRow['network_segment'], 'InternetTariffCurrentMonth' => $DbRow['inet_tarif_now'], 'InternetTariffNextMonth' => $DbRow['inet_tarif_next'], 'MembershipDate' => $DbRow['membership_date']));
-      }
+        $this->Database->insert('PermissionUserAssignment', array('User' => $UserId, 'GroupOrOperation' => $PermissionGroupSubjects, 'Type' => 'Group'));
+      } else
+        $this->Database->insert('PermissionUserAssignment', array('User' => $UserId, 'GroupOrOperation' => $PermissionGroupMembers, 'Type' => 'Group'));
     }
 
+    // Insert anonymous user
     $this->Database->insert('User', array('Name' => 'Anonym', 'Password' => 'dsafafdfadfs', 'Locked' => 0));
-    $Output .=  $this->Database->insert_id;
-
+    $Output .=  'Anonymní uživatel: '.$this->Database->insert_id.'</ br>';
+    $AnonymousUserId = $this->Database->insert_id;
+    $this->Database->insert('PermissionUserAssignment', array('User' => $AnonymousUserId, 'GroupOrOperation' => $PermissionGroupOthers, 'Type' => 'Group'));
+
+    // Init subjects open time
     $this->SubjectOpenTime();
 
@@ -151 +238 @@
     //$this->Database->query('TRUNCATE TABLE ChatHistory');
     //$this->Database->query('INSERT INTO ChatHistory (SELECT id as Id, nick as Nick, text as Text, time as Time, color as Color, roomname as RoomName, roomtype as RoomType, "" as Host FROM `sunrisechat_history`)');
+
+
     return($Output);
   }