Changeset 900 for trunk/Modules/Portal

Timestamp:

Feb 17, 2021, 5:15:29 PM (4 years ago)

Author:

chronos

Message:

• Modified: Insert sample data action partially implemented.

File:

• trunk/Modules/Portal/Portal.php (modified) (2 diffs)

trunk/Modules/Portal/Portal.php

@@ -17 +17 @@
   }
 
-  function DoInstall(): void
-  {
-   /* $this->Database->query("INSERT INTO `PanelColumn` (`Id`, `Width`) VALUES
-    (1, ''),
-    (2, ''),
-    (3, '70%');");
-    $this->Database->query("INSERT INTO `Panel` (`Id`, `Module`, `Parameters`, `Order`, `PanelColumn`) VALUES
-    (1, 'ActionGroup', 1, 2, 1),
-    (2, 'ActionGroup', 4, 1, 2),
-    (3, 'ActionGroup', 5, 2, 2),
-    (4, 'ActionGroup', 6, 3, 2),
-    (5, 'ActionGroup', 2, 4, 2),
-    (6, 'ActionGroup', 3, 5, 2),
-    (7, 'NewsGroupList', '', 2, 3),
-    (8, 'Webcam', '', 3, 1),
-    (9, 'UserOptions', '', 1, 3),
-    (10, 'ActionGroup', 9, 1, 1),
-    (11, 'Meteo', '', 4, 1);");*/
+  function DoInsertSampleData(): void
+  {
+    $ActionGroup1 = $this->Database->insert('ActionGroup', array('Name' => 'Síť'));
+    $ActionGroup2 = $this->Database->insert('ActionGroup', array('Name' => 'Místní organizace'));
+    $ActionGroup3 = $this->Database->insert('ActionGroup', array('Name' => 'Stránky občanů'));
+    $ActionGroup4 = $this->Database->insert('ActionGroup', array('Name' => 'Vyhledávání'));
+    $ActionGroup5 = $this->Database->insert('ActionGroup', array('Name' => 'Užitečné'));
+    $ActionGroup6 = $this->Database->insert('ActionGroup', array('Name' => 'Zábava'));
+    $ActionGroup7 = $this->Database->insert('ActionGroup', array('Name' => 'Hostované stránky'));
+    $ActionGroup8 = $this->Database->insert('ActionGroup', array('Name' => 'Prodej počítačů'));
+    $ActionGroup9 = $this->Database->insert('ActionGroup', array('Name' => 'Různé'));
+
+    $PanelColumn1 = $this->Database->insert('PanelColumn', array('Width' => ''));
+    $PanelColumn2 = $this->Database->insert('PanelColumn', array('Width' => ''));
+    $PanelColumn3 = $this->Database->insert('PanelColumn', array('Width' => '70%'));
+
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup1, 'Order' => 2, 'PanelColumn' => $PanelColumn1));
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup4, 'Order' => 1, 'PanelColumn' => $PanelColumn2));
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup5, 'Order' => 2, 'PanelColumn' => $PanelColumn2));
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup6, 'Order' => 3, 'PanelColumn' => $PanelColumn2));
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup2, 'Order' => 4, 'PanelColumn' => $PanelColumn2));
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup3, 'Order' => 5, 'PanelColumn' => $PanelColumn2));
+    $this->Database->insert('Panel', array('Module' => 'NewsGroupList', 'Parameters' => '', 'Order' => 2, 'PanelColumn' => $PanelColumn3));
+    $this->Database->insert('Panel', array('Module' => 'Webcam', 'Parameters' => '', 'Order' => 3, 'PanelColumn' => $PanelColumn1));
+    $this->Database->insert('Panel', array('Module' => 'UserOptions', 'Parameters' => '', 'Order' => 1, 'PanelColumn' => $PanelColumn3));
+    $this->Database->insert('Panel', array('Module' => 'ActionGroup', 'Parameters' => $ActionGroup9, 'Order' => 1, 'PanelColumn' => $PanelColumn1));
+    $this->Database->insert('Panel', array('Module' => 'Meteo', 'Parameters' => '', 'Order' => 4, 'PanelColumn' => $PanelColumn1));
   }
 
@@ -297 +306 @@
     $Output = '';
     $DbResult = $this->Database->query('SELECT * FROM `ActionGroup`');
+    $ActionGroups = array();
     while ($DbRow = $DbResult->fetch_assoc())
       $ActionGroups[$DbRow['Id']] = $DbRow;