Changeset 26 for lists

Timestamp:

Dec 4, 2008, 12:31:09 PM (16 years ago)

Author:

george

Message:

• Opraveno: Logování správných id položek.
• Upraveno: Částečně zprovozněno vícestupňové zobrazení odkazů.

Location:

lists

Files:

• SystemList.php (modified) (1 diff)
• SystemListItem.php (modified) (2 diffs)

lists/SystemList.php

@@ -17 +17 @@
     PRIMARY KEY  (`Id`)
     ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
+    $Database->query('ALTER TABLE `'.$Parameters['TableName'].'` ADD INDEX ( `ItemId` );');
     //echo($Database->LastQuery);
   }

lists/SystemListItem.php

@@ -3 +3 @@
 class ListSystemListItem
 {
+  function RebuildOrder()
+  {
+    global $Database;
+
+    $Database->query('UPDATE SystemListItem AS Table1 SET Sequence = (SELECT COUNT(*) FROM (SELECT * FROM SystemListItem) AS Table2 WHERE (Table1.ItemId = Table2.ItemId) AND ((Table2.Sequence < Table1.Sequence) OR ((Table1.Sequence = Table2.Sequence) AND (Table2.Id < Table1.Id))))');
+  }
+
   function OnAdd($Parameters)
   {
@@ -16 +23 @@
     $Database->query('ALTER TABLE `'.$DbRow2['TableName'].'` ADD `'.$Parameters['Name'].'` '.$DbRow['DbDataType'].' NOT NULL ;');
     //echo($Database->LastQuery);
+
+    $this->RebuildOrder();
+  }
+
+  function OnEdit($Parameters)
+  {
+    $this->RebuildOrder();
+  }
+
+  function OnDelete($Parameters)
+  {
+    $this->RebuildOrder();
   }
 }