Changeset 28 for lists

Timestamp:

Dec 8, 2008, 11:06:23 AM (16 years ago)

Author:

george

Message:

• Upraveno: Systém ukládání dat do databáze přepracován na jednodušší. Původní záměr počítal s verzováním položek seznamů čímž se komplikovaly SQL dotazy. Systém sledování změn bude později řešen přes tabulku Audit.
• Odebráno: Sloupce tabulek Author, ItemId, CreationTime, DeletionTime, ValidtTimeFrom a ValidTimeTo.

Location:

lists

Files:

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

lists/SystemList.php

@@ -9 +9 @@
     $Database->query('CREATE TABLE IF NOT EXISTS `'.$Parameters['TableName'].'` (
     `Id` int(11) NOT NULL auto_increment,
-    `ItemId` int(11) NOT NULL,
-    `Author` int(11) NOT NULL,
-    `ValidTimeFrom` datetime default NULL,
-    `ValidTimeTo` datetime default NULL,
-    `CreationTime` datetime default NULL,
-    `DeletionTime` datetime default NULL,
     PRIMARY KEY  (`Id`)
     ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
-    $Database->query('ALTER TABLE `'.$Parameters['TableName'].'` ADD INDEX ( `ItemId` );');
     //echo($Database->LastQuery);
   }
@@ -25 +18 @@
     global $Database;
 
-    $DbResult = $Database->query('SELECT `TableName` FROM `'.$Parameters['ListTableName'].'` WHERE ItemId='.$Parameters['ItemId'].' ORDER BY `Id` DESC LIMIT 1,1');
+    $DbResult = $Database->query('SELECT `TableName` FROM `'.$Parameters['ListTableName'].'` WHERE Id='.$Parameters['Id']);
     $DbRow = $DbResult->fetch_assoc();
     if($DbRow['TableName'] != $Parameters['TableName'])
       $Database->query('RENAME TABLE `'.$DbRow['TableName'].'` TO `'.$Parameters['TableName'].'`');
   }
+
+  function ApplySQLToItems($SQL)
+  {
+    global $Database;
+
+    $DbResult = $Database->query('SELECT `TableName` FROM `SystemList`');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Database->query(str_replace('`TableName`', '`'.$DbRow['TableName'].'`', $SQL));
+    }
+  }
 }
 

lists/SystemListItem.php

@@ -7 +7 @@
     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))))');
+    $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))))');
   }
 
@@ -15 +15 @@
 
     //print_r($Parameters);
-    $DbResult = $Database->query('SELECT DbDataType FROM SystemType WHERE ItemId='.$Parameters['Type'].' ORDER BY Id DESC LIMIT 1');
+    $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 ItemId='.$Parameters[$Parameters['Column']].' ORDER BY Id DESC LIMIT 1');
+    $DbResult = $Database->query('SELECT TableName FROM SystemList WHERE Id='.$Parameters[$Parameters['Column']]);
     //echo($Database->LastQuery);
     $DbRow2 = $DbResult->fetch_assoc();

lists/include.php

@@ -5 +5 @@
 include('lists/SystemListItem.php');
 
-define('ListSystemLogId', 20);
+define('ListSystemLogId', 59);
 
 ?>