Changeset 645 for trunk/Modules/Finance/Finance.php

Timestamp:

Mar 25, 2014, 12:38:20 AM (11 years ago)

Author:

chronos

Message:

• Přidáno: Typ sazby DPH jako samostatná tabulka.

File:

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

trunk/Modules/Finance/Finance.php

@@ -18 +18 @@
 define('DOC_LINE_ACCOUNT_IN', 3);
 define('DOC_LINE_ACCOUNT_OUT', 4);
+define('VAT_TYPE_BASE', 2);
 
 
@@ -292 +293 @@
     return($Output);
   }
+  
+  function GetVATByType($TypeId)
+  {
+        $Time = time();
+        $DbResult = $this->Database->select('FinanceVAT', 'Value', '(Type='.$TypeId.
+      ') AND (ValidFrom <= "'.TimeToMysqlDate($Time).'") AND ((ValidTo >= "'.
+      TimeToMysqlDate($Time).'") OR (ValidTo IS NULL)) LIMIT 1');
+    $Row = $DbResult->fetch_array();
+    return($Row[0]);
+  }
 }
 
@@ -383 +394 @@
         'Quantity' => array('Type' => 'Integer', 'Caption' => 'Množství', 'Default' => '1'),
         'VAT' => array('Type' => 'Integer', 'Caption' => 'Daň', 'Default' => '21', 'Suffix' => '%'),
+        'Total' => array('Type' => 'Integer', 'Caption' => 'Celkem', 'Default' => '', 'Suffix' => 'Kč', 
+          'ReadOnly' => true, 'SQL' => '`Price` * `Quantity`'),
       ),
     ));
@@ -459 +472 @@
       ),
     ));
+    $this->System->FormManager->RegisterClass('FinanceVAT', array(
+      'Title' => 'Sazby DPH',
+      'Table' => 'FinanceVAT',
+      'Items' => array(
+        'Type' => array('Type' => 'TFinanceVATType', 'Caption' => 'Typ', 'Default' => ''),
+        'ValidFrom' => array('Type' => 'Date', 'Caption' => 'Platnost od', 'Default' => ''),
+        'ValidTo' => array('Type' => 'Date', 'Caption' => 'Platnost do', 'Default' => '', 'Null' => true),
+        'Value' => array('Type' => 'Integer', 'Caption' => 'Hodnota', 'Default' => '', 'Suffix' => '%'),
+      ),
+    ));
+    $this->System->FormManager->RegisterClass('FinanceVATType', array(
+      'Title' => 'Sazby DPH',
+      'Table' => 'FinanceVATType',
+      'Items' => array(
+        'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''),
+      ),
+    ));
 
     $this->System->AddModule(new Bill($this->System));