Changeset 340 for trunk/finance/finance.php

Timestamp:

Jan 16, 2012, 9:59:18 PM (13 years ago)

Author:

chronos

Message:

• Přidáno: Moduk pro správu projektů.
• Některé staré moduly přesunuty do podsložky Modules.

File:

• trunk/finance/finance.php (modified) (5 diffs)

trunk/finance/finance.php

@@ -1 +1 @@
 <?php
 
-class Finance extends Module
+class Finance extends OldModule
 {
   var $kWh;
@@ -108 +108 @@
     $this->BaseTariffPrice = $Row['BaseTariffPrice'];
 
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Member');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Member`');
     $Row = $DbResult->fetch_row();
     $this->InternetUsers = $Row[0];
     
     $this->SpravaUsers = $this->InternetUsers;
-    $DbResult = $this->Database->query('SELECT SUM(consumption) FROM network_segments');
+    $DbResult = $this->Database->query('SELECT SUM(`consumption`) FROM `network_segments`');
     $TotalConsumption = $DbResult->fetch_array();
     $this->TotalConsumption = $TotalConsumption[0];
@@ -135 +135 @@
     {
       // Get latest year
-      $DbResult = $this->Database->select('FinanceYear', '*', '1 ORDER BY Year DESC LIMIT 1');
+      $DbResult = $this->Database->select('FinanceYear', '*', '1 ORDER BY `Year` DESC LIMIT 1');
     } else $DbResult = $this->Database->select('FinanceYear', '*', 'Id='.$FinanceYear);
     $FinanceYear = $DbResult->fetch_assoc();
     
-    $DbResult = $this->Database->query('SELECT Shortcut, Id FROM DocumentLine WHERE Id='.$Id);
+    $DbResult = $this->Database->query('SELECT `Shortcut`, `Id` FROM `DocumentLine` WHERE `Id`='.$Id);
     $DocumentLine = $DbResult->fetch_assoc();
     
-    $DbResult = $this->Database->query('SELECT * FROM DocumentLineSequence WHERE DocumentLine='.$Id.' AND FinanceYear='.$FinanceYear['Id']);
+    $DbResult = $this->Database->query('SELECT * FROM `DocumentLineSequence` WHERE (`DocumentLine`='.$Id.') AND (`FinanceYear`='.$FinanceYear['Id'].')');
     $Sequence = $DbResult->fetch_assoc();
     
@@ -150 +150 @@
     } else $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'];
         
-    $this->Database->query('UPDATE DocumentLineSequence SET NextNumber = NextNumber + 1 WHERE DocumentLine='.$Id.' AND FinanceYear='.$FinanceYear['Id']);
+    $this->Database->query('UPDATE `DocumentLineSequence` SET `NextNumber` = `NextNumber` + 1 WHERE (`DocumentLine`='.$Id.') AND (`FinanceYear`='.$FinanceYear['Id'].')');
     return($Result);
   }
@@ -157 +157 @@
   {
     $Output = 'Aktualizuji finance členů...<br />';
-    $this->Database->query('TRUNCATE TABLE MemberPayment');
-    $DbResult = $this->Database->query('SELECT * FROM Member');
+    $this->Database->query('TRUNCATE TABLE `MemberPayment`');
+    $DbResult = $this->Database->query('SELECT * FROM `Member`');
     while($Member = $DbResult->fetch_assoc())
     {