Changeset 24 for database_list.php

Timestamp:

Oct 27, 2008, 5:10:59 PM (16 years ago)

Author:

george

Message:

• Upraveno: Odkazy na seznamy pomocí ItemId namísto jmen tabulek.
• Přidáno: Potvrzovací dialog při mazání položek.

File:

• database_list.php (modified) (2 diffs)

database_list.php

@@ -5 +5 @@
   var $Dependencies = array('Log', 'User');
 
-  function AddItem($TableName, $Values)
+  function AddItem($TableId, $Values)
   {
+    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
+    $DbRow = $DbResult->fetch_assoc();
+    $TableName = $DbRow['TableName'];
+
     $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
     $Values['CreationTime'] = 'NOW()';
@@ -18 +22 @@
   }
 
-  function DeleteItem($TableName, $Id)
+  function DeleteItem($TableId, $ItemId)
   {
-    $DbResult = $this->Database->select($TableName, 'Id', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
+    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
+    $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()'));
   }
 
-  function EditItem($TableName, $Values, $Id)
+  function EditItem($TableId, $Values, $ItemId)
   {
-    $this->DeleteItem($TableName, $Id);
-    $Values['ItemId'] = $Id;
+    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
+    $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()';