Changeset 738 for trunk/Modules/Finance/UserState.php

Timestamp:

Apr 14, 2015, 10:20:16 PM (9 years ago)

Author:

chronos

Message:

• Removed: Spaces on end of line.
• Modified: Tabs converted to spaces.

File:

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

trunk/Modules/Finance/UserState.php

@@ -9 +9 @@
   function ShowFinanceOperation($Subject)
   {
-        $UserOperationTableQuery = '((SELECT `Text`, `Time`, (`Value`*`Direction`) AS `Value`, `File`, `BillCode`, NULL AS `PeriodFrom`, NULL AS `PeriodTo` '.
-          'FROM `FinanceOperation` WHERE (`Subject`='.$Subject['Id'].')) UNION ALL '.
-                '(SELECT (SELECT GROUP_CONCAT(`Description` SEPARATOR ",") FROM `FinanceInvoiceItem` WHERE `FinanceInvoice`=`FinanceInvoice`.`Id`) AS `Text`, '.
-                '`Time`, -(`Value`*`Direction`) AS `Value`, `File`, `BillCode`, `PeriodFrom`, `PeriodTo` FROM `FinanceInvoice` WHERE (`Subject`='.$Subject['Id'].')))';
+    $UserOperationTableQuery = '((SELECT `Text`, `Time`, (`Value`*`Direction`) AS `Value`, `File`, `BillCode`, NULL AS `PeriodFrom`, NULL AS `PeriodTo` '.
+      'FROM `FinanceOperation` WHERE (`Subject`='.$Subject['Id'].')) UNION ALL '.
+      '(SELECT (SELECT GROUP_CONCAT(`Description` SEPARATOR ",") FROM `FinanceInvoiceItem` WHERE `FinanceInvoice`=`FinanceInvoice`.`Id`) AS `Text`, '.
+      '`Time`, -(`Value`*`Direction`) AS `Value`, `File`, `BillCode`, `PeriodFrom`, `PeriodTo` FROM `FinanceInvoice` WHERE (`Subject`='.$Subject['Id'].')))';
 
     $Output = '<div style="text-align:center">Výpis finančních operací</div>';
-        $DbResult = $this->Database->query('SELECT COUNT(*) FROM '.$UserOperationTableQuery.' AS `T1`');
-        $DbRow = $DbResult->fetch_row();
-        $PageList = GetPageList($DbRow[0]);
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM '.$UserOperationTableQuery.' AS `T1`');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
 
-        $Output .= $PageList['Output'];
-        $Output .= '<table class="WideTable" style="font-size: small;">';
+    $Output .= $PageList['Output'];
+    $Output .= '<table class="WideTable" style="font-size: small;">';
 
-        $TableColumns = array(
-                        array('Name' => 'Time', 'Title' => 'Datum'),
-                        array('Name' => 'Text', 'Title' => 'Popis'),
-                        array('Name' => 'Value', 'Title' => 'Změna [Kč]'),
-                        array('Name' => 'State', 'Title' => 'Zůstatek [Kč]'),
-                        array('Name' => 'PeriodFrom', 'Title' => 'Období'),
-                        array('Name' => 'BillCode', 'Title' => 'Doklad'),
-        );
-        $Order = GetOrderTableHeader($TableColumns, 'Time', 1);
-        $Output .= $Order['Output'];
+    $TableColumns = array(
+        array('Name' => 'Time', 'Title' => 'Datum'),
+        array('Name' => 'Text', 'Title' => 'Popis'),
+        array('Name' => 'Value', 'Title' => 'Změna [Kč]'),
+        array('Name' => 'State', 'Title' => 'Zůstatek [Kč]'),
+        array('Name' => 'PeriodFrom', 'Title' => 'Období'),
+        array('Name' => 'BillCode', 'Title' => 'Doklad'),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Time', 1);
+    $Output .= $Order['Output'];
 
-        $StateQuery = 'SELECT SUM(`T2`.`Value`) FROM '.$UserOperationTableQuery.
-          ' AS `T2` WHERE `T2`.`Time` <= `T1`.`Time` ';
-        $Query = 'SELECT *, ('.$StateQuery.') AS `State` FROM '.$UserOperationTableQuery.' AS `T1` '.$Order['SQL'].$PageList['SQLLimit'];
+    $StateQuery = 'SELECT SUM(`T2`.`Value`) FROM '.$UserOperationTableQuery.
+      ' AS `T2` WHERE `T2`.`Time` <= `T1`.`Time` ';
+    $Query = 'SELECT *, ('.$StateQuery.') AS `State` FROM '.$UserOperationTableQuery.' AS `T1` '.$Order['SQL'].$PageList['SQLLimit'];
 
-        $DbResult = $this->Database->query($Query);
+    $DbResult = $this->Database->query($Query);
     $SumValue = 0;
-        while($Row = $DbResult->fetch_assoc())
-        {
-                $Row['State'] = round($Row['State'], 2);
-                if($Row['State'] > 0) $Row['State'] = '<span style="color:green;">'.$Row['State'].'</span>';
-                if($Row['State'] < 0) $Row['State'] = '<span style="color:red;">'.$Row['State'].'</span>';
-                if($Row['Value'] == -0) $Row['Value'] = 0;
-                if($Row['Value'] > 0) $Row['Value'] = '+'.$Row['Value'];
-                if($Row['BillCode'] == '') $Row['BillCode'] = 'PDF';
-                if($Row['File'] > 0) $Invoice = '<a href="'.$this->System->Link('/file?id='.$Row['File']).'">'.$Row['BillCode'].'</a>';
-                else $Invoice = NotBlank($Row['BillCode']);
-                if($Row['PeriodFrom'] != '') $Period = HumanDate($Row['PeriodFrom']).' - '.HumanDate($Row['PeriodTo']);
-                else $Period = '&nbsp;';
-                $Output .= '<tr><td style="text-align: right;">'.HumanDate($Row['Time']).'</td>'.
-                                '<td style="text-align: left;">'.$Row['Text'].'</td>'.
-                                '<td style="text-align: right;">'.round($Row['Value'], 2).'</td>'.
-                                '<td style="text-align: right;">'.$Row['State'].'</td>'.
-                                '<td>'.$Period.'</td>'.
-                                '<td>'.$Invoice.'</td></tr>';
-                $SumValue = $SumValue + $Row['Value'];
-        }
-        $Output .= '</table>';
-        $Output .= $PageList['Output'];
-        return($Output);
+    while($Row = $DbResult->fetch_assoc())
+    {
+      $Row['State'] = round($Row['State'], 2);
+      if($Row['State'] > 0) $Row['State'] = '<span style="color:green;">'.$Row['State'].'</span>';
+      if($Row['State'] < 0) $Row['State'] = '<span style="color:red;">'.$Row['State'].'</span>';
+      if($Row['Value'] == -0) $Row['Value'] = 0;
+      if($Row['Value'] > 0) $Row['Value'] = '+'.$Row['Value'];
+      if($Row['BillCode'] == '') $Row['BillCode'] = 'PDF';
+      if($Row['File'] > 0) $Invoice = '<a href="'.$this->System->Link('/file?id='.$Row['File']).'">'.$Row['BillCode'].'</a>';
+      else $Invoice = NotBlank($Row['BillCode']);
+      if($Row['PeriodFrom'] != '') $Period = HumanDate($Row['PeriodFrom']).' - '.HumanDate($Row['PeriodTo']);
+      else $Period = '&nbsp;';
+      $Output .= '<tr><td style="text-align: right;">'.HumanDate($Row['Time']).'</td>'.
+          '<td style="text-align: left;">'.$Row['Text'].'</td>'.
+          '<td style="text-align: right;">'.round($Row['Value'], 2).'</td>'.
+          '<td style="text-align: right;">'.$Row['State'].'</td>'.
+          '<td>'.$Period.'</td>'.
+          '<td>'.$Invoice.'</td></tr>';
+      $SumValue = $SumValue + $Row['Value'];
+    }
+    $Output .= '</table>';
+    $Output .= $PageList['Output'];
+    return($Output);
   }
 
@@ -85 +85 @@
       } else return($this->SystemMessage('Chyba', 'Nejste zákazníkem'));
     }
-        
+
     // Load customer info
     $DbResult = $this->Database->query('SELECT * FROM `Member` WHERE `Id`='.$CustomerId);
     if($DbResult->num_rows == 1)
     {
-        $Customer = $DbResult->fetch_assoc();      
+      $Customer = $DbResult->fetch_assoc();
     } else return($this->SystemMessage('Položka nenalezena', 'Zákazník nenalezen'));
-    
-    
+
+
     // Load subject info
     $DbResult = $this->Database->query('SELECT * FROM `Subject` WHERE `Id`='.$Customer['Subject']);
     if($DbResult->num_rows == 1)
-    {    
-      $Subject = $DbResult->fetch_assoc();      
+    {
+      $Subject = $DbResult->fetch_assoc();
     } else return($this->SystemMessage('Položka nenalezena', 'Subjekt nenalezen'));
-    
-    
-    $Output = '<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">';        
+
+
+    $Output = '<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">';
 
     // Account state
@@ -120 +120 @@
 
     $DbResult = $this->Database->query('SELECT FinanceBankAccount.*, CONCAT(FinanceBankAccount.Number, "/", FinanceBank.Code) AS NumberFull FROM FinanceBankAccount '.
-                'JOIN FinanceBank ON FinanceBank.Id=FinanceBankAccount.Bank '.
-                'WHERE (FinanceBankAccount.`Subject`='.$this->System->Config['Finance']['MainSubjectId'].') AND (FinanceBankAccount.`Use`=1)');
+        'JOIN FinanceBank ON FinanceBank.Id=FinanceBankAccount.Bank '.
+        'WHERE (FinanceBankAccount.`Subject`='.$this->System->Config['Finance']['MainSubjectId'].') AND (FinanceBankAccount.`Use`=1)');
     $SubjectFromAccount = $DbResult->fetch_assoc();
     $Account = $SubjectFromAccount['NumberFull'];
@@ -138 +138 @@
     while($DbRow = $DbResult->fetch_assoc())
     {
-            $Output .= '<tr><td>'.$DbRow['Name'].'</td><td>'.$DbRow['Price'].'</td></tr>';
+      $Output .= '<tr><td>'.$DbRow['Name'].'</td><td>'.$DbRow['Price'].'</td></tr>';
       $Total += $DbRow['Price'];
     }