Changeset 645 for trunk/Modules/Finance

Timestamp:

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

Author:

chronos

Message:

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

Location:

trunk/Modules/Finance

Files:

• Finance.php (modified) (4 diffs)
• Manage.php (modified) (2 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));

trunk/Modules/Finance/Manage.php

@@ -151 +151 @@
         $InvoiceItems = array();
         $MonthlyTotal = 0;
-        $DbResult2 = $this->Database->query('SELECT Service.*, FinanceVAT.Value AS VAT '.
-          'FROM ServiceCustomerRel LEFT JOIN Service '.
-          'ON Service.Id=ServiceCustomerRel.Service '.
-          'LEFT JOIN FinanceVAT ON FinanceVAT.Id=Service.VAT '.
-          'WHERE (ServiceCustomerRel.Customer='.
-          $Member['Id'].') AND (ServiceCustomerRel.Action IS NULL) ');
+        $DbResult2 = $this->Database->query('SELECT `Service`.* '.
+          'FROM `ServiceCustomerRel` LEFT JOIN `Service` '.
+          'ON `Service`.`Id`=`ServiceCustomerRel`.`Service` '.
+          'WHERE (`ServiceCustomerRel`.`Customer`='.
+          $Member['Id'].') AND (`ServiceCustomerRel`.`Action` IS NULL) ');
         while($Service = $DbResult2->fetch_assoc())
         {
           $InvoiceItems[] = array('Description' => $Service['Name'], 'Price' => $Service['Price'],
-            'Quantity' => $Period['MonthCount'], 'VAT' => $Service['VAT']);
+            'Quantity' => $Period['MonthCount'], 'VAT' => $this->System->Modules['Finance']->GetVATByType($Service['VAT']));
           $MonthlyTotal += $Service['Price'];
         }
@@ -166 +165 @@
         {
           $InvoiceItems[] = array('Description' => 'Spotřeba energie', 'Price' => -$Member['MonthlyPlus'],
-            'Quantity' => $Period['MonthCount'], 'VAT' => 2);
+            'Quantity' => $Period['MonthCount'], 'VAT' => $this->System->Modules['Finance']->GetVATByType(VAT_TYPE_BASE));
           $MonthlyTotal -= $Member['MonthlyPlus'];
         }