Changeset 29 for lists

Timestamp:

Dec 9, 2008, 1:24:32 PM (16 years ago)

Author:

george

Message:

• Upraveno: Hledání položek v seznamu dle zadaného filtru.

File:

• lists/SystemListItem.php (modified) (3 diffs)

lists/SystemListItem.php

@@ -3 +3 @@
 class ListSystemListItem
 {
-  function RebuildOrder()
+  function RebuildOrder($List)
   {
     global $Database;
 
-    $Database->query('UPDATE SystemListItem AS Table1 SET Sequence = (SELECT COUNT(*) FROM (SELECT * FROM SystemListItem) AS Table2 WHERE ((Table2.Sequence < Table1.Sequence) OR ((Table1.Sequence = Table2.Sequence) AND (Table2.Id < Table1.Id))))');
+    $Database->query('SET @I = 0;');
+    $Database->query('UPDATE `SystemListItem` SET `Sequence` = (@I := @I + 1) WHERE `List`='.$List.' ORDER BY `Sequence`;');
   }
 
@@ -15 +16 @@
 
     //print_r($Parameters);
-    $DbResult = $Database->query('SELECT DbDataType FROM SystemType WHERE Id='.$Parameters['Type']);
+    $DbResult = $Database->query('SELECT `DbDataType` FROM `SystemType` WHERE Id='.$Parameters['Type']);
     //echo($Database->LastQuery);
     $DbRow = $DbResult->fetch_assoc();
-    $DbResult = $Database->query('SELECT TableName FROM SystemList WHERE Id='.$Parameters[$Parameters['Column']]);
+    $DbResult = $Database->query('SELECT `TableName` FROM `SystemList` WHERE Id='.$Parameters[$Parameters['Column']]);
     //echo($Database->LastQuery);
     $DbRow2 = $DbResult->fetch_assoc();
@@ -24 +25 @@
     //echo($Database->LastQuery);
 
-    $this->RebuildOrder();
+    $this->RebuildOrder($Parameters['List']);
   }
 
   function OnEdit($Parameters)
   {
-    $this->RebuildOrder();
+    $this->RebuildOrder($Parameters['List']);
   }
 
   function OnDelete($Parameters)
   {
-    $this->RebuildOrder();
+    $this->RebuildOrder($Parameters['List']);
   }
 }