Changeset 687 for trunk/Modules/IS/IS.php

Timestamp:

Sep 7, 2014, 12:28:06 PM (10 years ago)

Author:

chronos

Message:

• Upraveno: Vylepšení čitelnosti záznamu změn v IS do tabulky Log.

File:

• trunk/Modules/IS/IS.php (modified) (4 diffs)

trunk/Modules/IS/IS.php

@@ -123 +123 @@
   }
 
+  function LogChange($Form, $Action, $NewId, $OldId)
+  {
+        $Values = $Form->Definition['Table'].' (Id: '.$OldId.' => '.$NewId.'):'."\n";
+        // Compare old values loaded from database with new values in Form variable
+        $NewValues = $Form->Values;
+        if($OldId != 0)
+        {
+          $FormOld = new Form($this->System->FormManager);
+          $FormOld->SetClass($Form->Definition['Table']);
+          $FormOld->LoadValuesFromDatabase($OldId);
+                $OldValues = $FormOld->Values;
+                // Keep only changes values
+          foreach($NewValues as $Index => $Value)
+          {
+                if($OldValues[$Index] != $NewValues[$Index])
+                {
+                $Values .= $Index.': '.$FormOld->GetValue($Index);
+                if($NewId != 0) $Values .= ' => '.$Form->GetValue($Index);
+                $Values .= "\n";
+                }
+        }
+        } else {
+                foreach($NewValues as $Index => $Value)
+                {
+                        $Values .= $Index.': '.$Form->GetValue($Index)."\n";
+                }
+        }
+        $this->System->ModuleManager->Modules['Log']->NewRecord('IS', $Action, $Values);
+  }
+
   function ShowEdit($Table, $Id)
   {
@@ -139 +169 @@
         try {
           $Form->Validate();
+          $this->LogChange($Form, 'Edit', $Id, $Id);
           $Form->SaveValuesToDatabase($Id);
-          $Values = $Table.': '.str_replace('=>', '=', str_replace('array', '', var_export($Form->Values, true)));
-          $this->System->ModuleManager->Modules['Log']->NewRecord('IS', 'Edit', $Values);
           $Output .= $this->SystemMessage('Úprava položky', 'Položka upravena');
           $Output .= $this->ShowView($Table, $Id);
@@ -190 +219 @@
         $DbRow = $DbResult->fetch_assoc();
         try {
+        $Form = new Form($this->System->FormManager);
+        $Form->SetClass($Table);
+        $this->LogChange($Form, 'Delete', 0, $Id);
         $this->Database->delete($Table, '`Id`='.$Id);
-        $Values = $Table.': '.str_replace('=>', '=', str_replace('array', '', var_export($DbRow, true)));
-        $this->System->ModuleManager->Modules['Log']->NewRecord('IS', 'Delete', $Values);
         $Output .= $this->SystemMessage('Smazání položky', 'Položka odstraněna');
       } catch (Exception $E)
@@ -227 +257 @@
           $Form->SaveValuesToDatabase(0);
           $Id = $this->Database->insert_id;
-          $Values = $Table.': '.str_replace('=>', '=', str_replace('array', '', var_export($Form->Values, true)));
-          $this->System->ModuleManager->Modules['Log']->NewRecord('IS', 'Add', $Values);
+          $this->LogChange($Form, 'Add', $Id, 0);
           $Output .= $this->SystemMessage('Přidání položky', 'Nová položka vytvořena');
           $Output .= $this->ShowView($Table, $Id, $_GET['a'] == 'addsub');