Changeset 23 for lists

Timestamp:

Oct 22, 2008, 12:54:08 PM (16 years ago)

Author:

george

Message:

• Opraveno: Odkazy na konstanty id typů.
• Upraveno: Definice událostí manipulace se seznamy jako třídy a jejich načítání "na přání".

Location:

lists

Files:

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

lists/SystemList.php

@@ -1 +1 @@
 <?php
 
-function ListSystemListOnAdd($Parameters)
+class ListSystemList
 {
-  global $Database;
+  function OnAdd($Parameters)
+  {
+    global $Database;
 
-  $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;');
-  //echo($Database->LastQuery);
-}
+    $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;');
+    //echo($Database->LastQuery);
+  }
 
-function ListSystemListOnEdit($Parameters)
-{
-  global $Database;
+  function ListSystemListOnEdit($Parameters)
+  {
+    global $Database;
 
-  $DbResult = $Database->query('SELECT `TableName` FROM `'.$Parameters['ListTableName'].'` WHERE ItemId='.$Parameters['ItemId'].' ORDER BY `Id` DESC LIMIT 1,1');
-  $DbRow = $DbResult->fetch_assoc();
-  if($DbRow['TableName'] != $Parameters['TableName'])
-    $Database->query('RENAME TABLE `'.$DbRow['TableName'].'` TO `'.$Parameters['TableName'].'`');
+    $DbResult = $Database->query('SELECT `TableName` FROM `'.$Parameters['ListTableName'].'` WHERE ItemId='.$Parameters['ItemId'].' ORDER BY `Id` DESC LIMIT 1,1');
+    $DbRow = $DbResult->fetch_assoc();
+    if($DbRow['TableName'] != $Parameters['TableName'])
+      $Database->query('RENAME TABLE `'.$DbRow['TableName'].'` TO `'.$Parameters['TableName'].'`');
+  }
 }
 

lists/SystemListItem.php

@@ -1 +1 @@
 <?php
 
-function ListSystemListItemOnAdd($Parameters)
+class ListSystemListItem
 {
-  global $Database;
+  function OnAdd($Parameters)
+  {
+    global $Database;
 
-  //print_r($Parameters);
-  $DbResult = $Database->query('SELECT DbDataType FROM SystemType WHERE ItemId='.$Parameters['Type'].' ORDER BY Id DESC LIMIT 1');
-  //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');
-  //echo($Database->LastQuery);
-  $DbRow2 = $DbResult->fetch_assoc();
-  $Database->query('ALTER TABLE `'.$DbRow2['TableName'].'` ADD `'.$Parameters['Name'].'` '.$DbRow['DbDataType'].' NOT NULL ;');
-  //echo($Database->LastQuery);
+    //print_r($Parameters);
+    $DbResult = $Database->query('SELECT DbDataType FROM SystemType WHERE ItemId='.$Parameters['Type'].' ORDER BY Id DESC LIMIT 1');
+    //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');
+    //echo($Database->LastQuery);
+    $DbRow2 = $DbResult->fetch_assoc();
+    $Database->query('ALTER TABLE `'.$DbRow2['TableName'].'` ADD `'.$Parameters['Name'].'` '.$DbRow['DbDataType'].' NOT NULL ;');
+    //echo($Database->LastQuery);
+  }
 }