Changeset 165 for www/finance/manage.php

Timestamp:

Mar 5, 2009, 10:16:12 PM (16 years ago)

Author:

george

Message:

• Upraveno: Tabulky FinanceCashFlow a FinanceClaimAndLiabilities sloučeny do tabulky FinanceOperation využívající zaznamenávání toku financí dle subjektů.

File:

• www/finance/manage.php (modified) (5 diffs)

www/finance/manage.php

@@ -47 +47 @@
       case 'NewInvoiceForm':
         $Output = $this->ShowNewInvoiceForm();
+        break;
+      case 'ConvertData':
+        $Output = $this->ConvertData();
         break;
       default:
@@ -56 +59 @@
         $Output .= '<a href="?Operation=ConvertPDFToFile">Převést data z databáze do souborů</a><br />';
         $Output .= '<a href="?Operation=Bills">Správa dokladů</a><br />';
+        $Output .= '<a href="?Operation=ConvertData">Převést tabulky</a><br />';
                 $Output .= '<a href="prepocet.php">Přepočet financí</a><br />';
                 $Output .= '<a href="clenove.php">Seznam subjektů</a><br />';
@@ -356 +360 @@
   {
     $DbResult = $this->Database->query('SELECT * FROM FinanceBills');
-    while($Bill = $DbResult->fetch_array())
+    while($Bill = $DbResult->fetch_assoc())
     {
       file_put_contents('doklady/doklad_'.$Bill['id'].'.pdf', $Bill['pdf']);
@@ -365 +369 @@
   function CheckPDFFiles()
   {
-    global $Database, $InvoiceGenerator;
+    global $InvoiceGenerator;
 
     $DbResult = $this->Database->query('SELECT * FROM FinanceBills');
-    while($Bill = $DbResult->fetch_array())
+    while($Bill = $DbResult->fetch_assoc())
     {
       file_put_contents('doklady2/doklad-'.$Bill['id'].'.pdf', file_get_contents('doklady/doklad-'.$Bill['id'].'.pdf'));
@@ -375 +379 @@
   }
 
+  function ConvertData()
+  {
+        $Output = '';
+        $this->Database->query('TRUNCATE TABLE FinanceOperation');
+
+    // Move time of device price transformation 
+    $this->Database->query('UPDATE finance_operations SET date="2007-11-30" WHERE comment = "Jednorázový poplatek za společné zařízení"');
+
+    // Transform old operations
+        $DbResult = $this->Database->query('SELECT * FROM finance_operations WHERE finance_operations.date >= "2007-12-01"');
+        while($DbRow = $DbResult->fetch_assoc())
+        {
+          $this->Database->insert('FinanceOperation', array('Id' => $DbRow['id'], 'SourceSubject' => $DbRow['Source'], 'DestinationSubject' => $DbRow['Destination'], 'Value' => abs($DbRow['money']), 'Time' => $DbRow['date'], 'BillCode' => $DbRow['BillCode'], 'Taxable' => $DbRow['Taxable'], 'Text' => $DbRow['comment'], 'Bill' => $DbRow['bill_id']));
+          $Output .= '.';
+        }
+
+    // Transfer finance before era
+    $DbResult = $this->Database->query('SELECT * FROM Subject');
+    while($Subject = $DbResult->fetch_assoc())
+    {
+      $DbResult2 = $this->Database->query('SELECT SUM(money) as money FROM finance_operations WHERE user='.$Subject['Id'].' AND date < "2007-12-01"');
+      $DbRow2 = $DbResult2->fetch_assoc();
+
+          if($DbRow2['money'] > 0)
+          {
+        $DestinationSubject = $Subject['Id'];
+                $SourceSubject = 96;
+                $Comment = 'Přijatá záloha (z období před daňovou evidencí)';
+          } else
+          {
+                $DestinationSubject = 71;
+                $SourceSubject = $Subject['Id'];
+                $Comment = 'Připojení k síti (z období před daňovou evidencí)';
+          }
+          $DbRow2['date'] = TimeToMysqlDateTime(mktime(0, 0, 0, 12, 1, 2007));
+          $this->Database->insert('FinanceOperation', array('SourceSubject' => $SourceSubject, 'DestinationSubject' => $DestinationSubject, 'Value' => abs($DbRow2['money']), 'Time' => $DbRow2['date'], 'Taxable' => 1, 'Text' => $Comment));
+          $Output .= '#';
+    }
+
+        return($Output);
+  }
 }