Changeset 436

Timestamp:

Oct 12, 2012, 11:37:49 AM (12 years ago)

Author:

chronos

Message:

• P5idáno: Tabulky Zboží a sklady v Správě dat.

Location:

trunk

Files:

• form_classes.php (modified) (2 diffs)
• is/index.php (modified) (7 diffs)
• sql/updates/436.sql (added)

trunk/form_classes.php

@@ -2 +2 @@
 
 $FormClasses = array(
+  'Product' => array(
+    'Title' => 'Zboží',
+    'Table' => 'Product',
+    'DefaultSortColumn' => 'Name',
+    'Items' => array(
+      'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
+      'Price' => array('Type' => 'Integer', 'Caption' => 'Cena', 'Default' => '0'),
+      'Count' => array('Type' => 'Integer', 'Caption' => 'Počet', 'Default' => ''),
+      'Date' => array('Type' => 'Date', 'Caption' => 'Datum', 'Default' => ''),
+      'Segment' => array('Type' => 'TNetworkSegment', 'Caption' => 'Úsek', 'Default' => ''),
+      'Used' => array('Type' => 'Boolean', 'Caption' => 'Použito', 'Default' => '0'),
+      'Info' => array('Type' => 'Text', 'Caption' => 'Informace', 'Default' => ''),
+      'User' => array('Type' => 'TMember', 'Caption' => 'Uživatel', 'Default' => ''),
+      'Consumption' => array('Type' => 'Integer', 'Caption' => 'Spotřeba', 'Default' => ''),
+      'DeviceId' => array('Type' => 'String', 'Caption' => 'Označení', 'Default' => ''),
+      'DeprecatedPrice' => array('Type' => 'Float', 'Caption' => 'Odpisová cena', 'Default' => ''),
+      'StockCard' => array('Type' => 'TStockCard', 'Caption' => 'Zboží', 'Default' => ''),
+    ),
+  ),
+  'Stock' => array(
+    'Title' => 'Sklady',
+    'Table' => 'Stock',
+    'DefaultSortColumn' => 'Name',
+    'Items' => array(
+      'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
+    ),
+  ),
   'FinanceBillingPeriod' => array(
     'Title' => 'Platební období',
@@ -504 +531 @@
     'Filter' => '1',
   ),
+  'TStockCard' => array(
+    'Type' => 'Reference',
+    'Table' => 'StockCard',
+    'Id' => 'Id',
+    'Name' => 'Name',
+    'Filter' => '1',
+  ),
 );
 

trunk/is/index.php

@@ -34 +34 @@
     
     if($_SESSION['Action'] == 'list') $Output .= $this->ShowList($_SESSION['Table']);
-    else if($_SESSION['Action'] == 'edit') $Output .= $this->ShowEdit();
-    else if($_SESSION['Action'] == 'add') $Output .= $this->ShowAdd();
-    else if($_SESSION['Action'] == 'view') $Output .= $this->ShowView();
-    else if($_SESSION['Action'] == 'delete') $Output .= $this->ShowDelete();
+    else if($_SESSION['Action'] == 'edit') $Output .= $this->ShowEdit($_SESSION['Table'], $_SESSION['Id']);
+    else if($_SESSION['Action'] == 'add') $Output .= $this->ShowAdd($_SESSION['Table']);
+    else if($_SESSION['Action'] == 'view') $Output .= $this->ShowView($_SESSION['Table'], $_SESSION['Id']);
+    else if($_SESSION['Action'] == 'delete') $Output .= $this->ShowDelete($_SESSION['Table'], $_SESSION['Id']);
     $Output .= '</td></tr></table>';
     
@@ -43 +43 @@
   }
   
-  function ShowEdit()
+  function ShowEdit($Table, $Id)
   {
     $Output = '';
@@ -50 +50 @@
       if($_GET['o'] == 'save')
       {
-        $Form = new Form($_SESSION['Table']);
+        $Form = new Form($Table);
         $Form->LoadValuesFromForm();
-        $Form->SaveValuesToDatabase($_SESSION['Id']);
+        $Form->SaveValuesToDatabase($Id);
         $Output .= $this->SystemMessage('Úprava položky', 'Položka upravena');
         $_SESSION['Action'] = 'view';
-        $Output .= $this->ShowView();   
+        $Output .= $this->ShowView($Table, $Id);   
       }
     } else 
     {
-      $Form = new Form($_SESSION['Table']);
-      $Form->LoadValuesFromDatabase($_SESSION['Id']);
+      $Form = new Form($Table);
+      $Form->LoadValuesFromDatabase($Id);
       $Form->OnSubmit = '?a=edit&amp;o=save';
       $Output .= $Form->ShowEditForm();
@@ -75 +75 @@
   }
   
-  function ShowDelete()
+  function ShowDelete($Table, $Id)
   {
     $Output = '';
-    $this->Database->delete($_SESSION['Table'], 'Id='.$_SESSION['Id']);
+    $this->Database->delete($Table, 'Id='.$Id);
     $Output .= $this->SystemMessage('Odstranění položky', 'Položka odstraněna');
     $_SESSION['Action'] = 'list';
-    $Output .= $this->ShowList();   
-    return($Output);
-  }
-  
-  function ShowAdd()
+    $Output .= $this->ShowList($Table);   
+    return($Output);
+  }
+  
+  function ShowAdd($Table)
   {
     $Output = '';
@@ -92 +92 @@
       if($_GET['o'] == 'save')
       {
-        $Form = new Form($_SESSION['Table']);
+        $Form = new Form($Table);
         $Form->LoadValuesFromForm();
         $Form->SaveValuesToDatabase(0);
         $Output .= $this->SystemMessage('Přidání položky', 'Nová položka vytvořena');
         $_SESSION['Action'] = 'view';
-        $_SESSION['Id'] = $this->Database->insert_id;
-        $Output .= $this->ShowView();   
+        $Id = $this->Database->insert_id;
+        $_SESSION['Id'] = $Id;
+        $this->Database->update($Table, 'Id='.$Id, 
+          array('UserCreate' => $this->System->Modules['User']->User['Id'], 
+          'TimeCreate' => 'NOW()'));
+        $Output .= $this->ShowView($Table, $Id);   
       }
     } else 
     {
-      $Form = new Form($_SESSION['Table']);
+      $Form = new Form($Table);
       $Form->OnSubmit = '?a=add&amp;o=save';
       $Output .= $Form->ShowEditForm();
@@ -113 +117 @@
   }
   
-  function ShowView()
+  function ShowView($Table, $Id)
   {
     global $FormTypes;
     
-    $Form = new Form($_SESSION['Table']);
-    $Form->LoadValuesFromDatabase($_SESSION['Id']);
+    $Form = new Form($Table);
+    $Form->LoadValuesFromDatabase($Id);
     $Form->OnSubmit = '?a=view';
     $Output = $Form->ShowViewForm();
@@ -135 +139 @@
     {
       $Output .= '<div style="text-align: center;">'.$Form->Definition['Title'].'</div>';
-      $Output .= $this->ShowList($FormTypes[$Item['Type']]['Table'], '`'.$FormTypes[$Item['Type']]['Ref'].'`='.$_SESSION['Id']).'<br/>';
+      $Output .= $this->ShowList($FormTypes[$Item['Type']]['Table'], '`'.$FormTypes[$Item['Type']]['Ref'].'`='.$Id).'<br/>';
     }    
     return($Output);