Changeset 28 for database_list.php

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.

File:

• database_list.php (modified) (1 diff)

database_list.php

@@ -7 +7 @@
   function AddItem($TableId, $Values)
   {
-    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
+    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE Id='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
     $TableName = $DbRow['TableName'];
 
-    $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
-    $Values['CreationTime'] = 'NOW()';
-    $Values['ValidTimeFrom'] = 'NOW()';
-    $DbResult = $this->Database->select($TableName, 'MAX(ItemId)');
-    $DbRow = $DbResult->fetch_row();
-    $AutoincrementId = $DbRow[0];
-    $Values['ItemId'] = $AutoincrementId + 1; 
     $this->Database->insert($TableName, $Values);
-    return($Values['ItemId']);
+    return($this->Database->insert_id);
   }
 
   function DeleteItem($TableId, $ItemId)
   {
-    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
+    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE Id='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
     $TableName = $DbRow['TableName'];
-
-    $DbResult = $this->Database->select($TableName, 'Id', 'ItemId='.$ItemId.' ORDER BY Id DESC LIMIT 1');
-    $DbRow = $DbResult->fetch_assoc();
-    $this->Database->update($TableName, 'Id='.$DbRow['Id'], array('DeletionTime' => 'NOW()'));
+    $this->Database->delete($TableName, 'Id='.$ItemId, array('DeletionTime' => 'NOW()'));
   }
 
   function EditItem($TableId, $Values, $ItemId)
   {
-    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
+    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE Id='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
     $TableName = $DbRow['TableName'];
     $this->DeleteItem($TableId, $ItemId);
-    $Values['ItemId'] = $ItemId;
-    $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
-    $Values['CreationTime'] = 'NOW()';
-    $Values['ValidTimeFrom'] = 'NOW()';
-    $this->Database->insert($TableName, $Values);
+    $Values['Id'] = $ItemId;
+    $this->Database->replace($TableName, $Values);
   }
 }