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

Timestamp:

Jul 3, 2015, 11:36:07 PM (9 years ago)

Author:

chronos

Message:

• Modified: Changed Direction column of FinanceOperation and Invoices to more general ValueSign.
• FinanceOperationGroup and InvoiceGroup tables introduced and operations and invoices are now linked directly

to group id instead of DocumentLine.

File:

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

trunk/Modules/IS/IS.php

@@ -101 +101 @@
     $Output .= 'Registrovaných zařízení: '.$DbRow['0'].'<br/>';
 
-    $DbResult = $this->Database->select('FinanceOperation', 'SUM(`Value` * `Direction`)', '1');
+    $DbResult = $this->Database->select('FinanceOperation', 'SUM(`Value` * `ValueSign`)', '1');
     $DbRow = $DbResult->fetch_row();
     $Output .= 'Stav placení: '.$DbRow['0'].'<br/>';
@@ -423 +423 @@
     {
       if($TypeFilter != '') $TypeFilter .= ' AND ';
-      $TypeFilter .= '('.$ItemIndex.' = "'.$FormItem['Default'].'")';
+      $TypeFilter .= '(`'.$ItemIndex.'` = "'.$FormItem['Default'].'")';
     }
     if($TypeFilter != '')