Changeset 636 for trunk/Modules/Finance/MonthlyOverall.php

Timestamp:

Jan 21, 2014, 12:02:53 AM (11 years ago)

Author:

chronos

Message:

• Upraveno: Tabulka měsíčních přehledů přepracována s použitím obecných tříd. Nyní podporuje řazení a stránkování. Celkové součty byly odebrány.

File:

• trunk/Modules/Finance/MonthlyOverall.php (modified) (2 diffs)

trunk/Modules/Finance/MonthlyOverall.php

@@ -11 +11 @@
     global $MonthNames;
 
-    $Output = '<table class="WideTable"><tr><th>Rok</th><th>Měsíc</th><th>Internet [Kč]</th><th>Účastníků</th><th>Správa [Kč/účastníka]</th><th>Správa [Kč]</th><th>Spotřeba [Kč/kWh]</th><th>Spotřeba [Kč]</th><th>Obrat [Kč]</th><th>Průměrná cena [Kč/účastníka]</th><th align="center">Investice [Kč]</th></tr>';
+    $Output = ''; 
+    $Query = 'SELECT *, YEAR(`Date`) AS `Year`, MONTH(`Date`) AS `Month`, ROUND(`TotalPaid` / `MemberCount`) AS `PaidPerCustomer` FROM `FinanceMonthlyOverall`';
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `T`');
+    $DbRow = $DbResult->fetch_row();
+    $Paging = new Paging();    
+    $Paging->TotalCount = $DbRow[0];
+    $Table = new VisualTable();
+    $Table->SetColumns(array(
+      array('Name' => 'Year', 'Title' => 'Rok'),
+      array('Name' => 'Month', 'Title' => 'Měsíc'),
+      array('Name' => 'Money', 'Title' => 'Internet [Kč]'),
+      array('Name' => 'MemberCount', 'Title' => 'Zákazníků'),
+      array('Name' => 'Administration', 'Title' => 'Správa [Kč/zákazníka]'),
+      array('Name' => 'AdministrationTotal', 'Title' => 'Správa [Kč]'),
+      array('Name' => 'kWh', 'Title' => 'Spotřeba [Kč/kWh]'),
+      array('Name' => 'ConsumptionTotal', 'Title' => 'Spotřeba [Kč]'),
+      array('Name' => 'TotalPaid', 'Title' => 'Obrat [Kč]'),
+      array('Name' => 'PaidPerCustomer', 'Title' => 'Průměrná cena [Kč/účastníka]'),
+      array('Name' => 'Investment', 'Title' => 'Investice [Kč]'),      
+    ));
+    $Output .= $Paging->Show();     
+        
+          $Table->GetOrderHeader();
+        
     $Total = array('Money' => 0, 'AdministrationTotal' => 0, 'ConsumptionTotal' => 0, 'TotalPaid' => 0, 'Investment' => 0);
-    $DbResult = $this->Database->select('FinanceMonthlyOverall', '*', '1 ORDER BY Date DESC');
+    $DbResult = $this->Database->query($Query.' WHERE 1 '.$Table->OrderSQL.' '.$Paging->SQLLimit);
     while($Month = $DbResult->fetch_array())
     {
-      $DateParts = explode('-', $Month['Date']);
-      $Output .= '<tr><td>'.$DateParts[0].'</td><td align="center">'.$MonthNames[$DateParts[1] * 1].'</td><td align="center">'.$Month['Money'].'</td><td align="center">'.$Month['MemberCount'].'</td><td align="center">'.$Month['Administration'].'</td><td align="center">'.$Month['AdministrationTotal'].'</td><td align="center">'.$Month['kWh'].'</td><td align="center">'.$Month['ConsumptionTotal'].'</td><td align="center">'.$Month['TotalPaid'].'</td><td align="center">'.round($Month['TotalPaid'] / $Month['MemberCount']).'</td><td align="center">'.$Month['Investment'].'</td></tr>';
+      $Table->Table->Cells[] = array($Month['Year'], $MonthNames[$Month['Month']],
+        $Month['Money'], $Month['MemberCount'], $Month['Administration'],
+        $Month['AdministrationTotal'], $Month['kWh'], $Month['ConsumptionTotal'],
+        $Month['TotalPaid'], $Month['PaidPerCustomer'], 
+        $Month['Investment']);
 
       $Total['Money'] += $Month['Money'];
@@ -26 +52 @@
       //if($DateParts[1] == '01') echo('<tr><td style="font-size: 4;" colspan="10">&nbsp;</td></tr>');
     }
-    $Output .= '<tr><th colspan="2">Celkem</th><th>'.$Total['Money'].'</th><th>&nbsp;</th><th>&nbsp;</th><th>'.$Total['AdministrationTotal'].'</th><th>&nbsp;</th><th>'.$Total['ConsumptionTotal'].'</th><th>'.$Total['TotalPaid'].'</th><th>&nbsp;</th><th>'.$Total['Investment'].'</th>';
-    $Output .= '</table>';
+    //$Table->Table->Cells[] = array('Celkem', '', $Total['Money'], '', '', $Total['AdministrationTotal'], 
+    //  '', $Total['ConsumptionTotal'], $Total['TotalPaid'], '', $Total['Investment']);
+    $Output .= $Table->Show();
+    $Output .= $Paging->Show();    
+   
     return($Output);
   }