Changeset 167 for www/finance/manage.php

Timestamp:

Mar 24, 2009, 11:44:03 AM (16 years ago)

Author:

george

Message:

• Přidáno: Stránka pro rozeslání emailů s počátečními hesly.
• Upraveno: Konfigurační skripty pro nastavení síťových zařízení se systémem RouterOS doplněny o podporu zápisu konfigurace do více samostatných zařízení. Změna se týká konfigurace DHCP serveru a sledování net_watch.
• Opraveno: Některé nefunkční odkazy na hlavní stránce.
• Upraveno: Tabulka finance_operations nově převedena na tabulky FinanceOperation a FinanceClaimsLiabilities. Upraveny související stránky.

File:

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

www/finance/manage.php

@@ -381 +381 @@
   function ConvertData()
   {
-        $Output = '';
-        $this->Database->query('TRUNCATE TABLE FinanceOperation');
+    $Finance = $this->System->Modules['Finance'];
+          $Output = '';
+          $this->Database->query('TRUNCATE TABLE FinanceOperation');
+          $this->Database->query('TRUNCATE TABLE FinanceClaimsLiabilities');
 
     // Move time of device price transformation 
@@ -388 +390 @@
 
     // 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 .= '.';
-        }
+          $DbResult = $this->Database->query('SELECT * FROM finance_operations WHERE finance_operations.date >= "2007-12-01" AND (Source = '.$Finance->ExternalSubject.')');
+          while($DbRow = $DbResult->fetch_assoc())
+          {
+            $this->Database->insert('FinanceOperation', array('Id' => $DbRow['id'], 'Subject' => $DbRow['Destination'], 'Cash' => $DbRow['cash'], 'Value' => abs($DbRow['money']), 'Time' => $DbRow['date'], 'BillCode' => $DbRow['BillCode'], 'Taxable' => $DbRow['Taxable'], 'Text' => $DbRow['comment'], 'Bill' => $DbRow['bill_id']));
+            $Output .= '.';
+          }
+          $DbResult = $this->Database->query('SELECT * FROM finance_operations WHERE finance_operations.date >= "2007-12-01" AND (Destination = '.$Finance->ExternalSubject.')');
+          while($DbRow = $DbResult->fetch_assoc())
+          {
+            $this->Database->insert('FinanceOperation', array('Id' => $DbRow['id'], 'Subject' => $DbRow['Source'], 'Cash' => $DbRow['cash'], 'Value' => -abs($DbRow['money']), 'Time' => $DbRow['date'], 'BillCode' => $DbRow['BillCode'], 'Taxable' => $DbRow['Taxable'], 'Text' => $DbRow['comment'], 'Bill' => $DbRow['bill_id']));
+            $Output .= '.';
+          }
+
+    // Transform old invoices
+          $DbResult = $this->Database->query('SELECT * FROM finance_operations WHERE finance_operations.date >= "2007-12-01" AND (Source = '.$Finance->MainSubject.')');
+          while($DbRow = $DbResult->fetch_assoc())
+          {
+            $this->Database->insert('FinanceClaimsLiabilities', array('Id' => $DbRow['id'], 'Subject' => $DbRow['Destination'], 'Value' => -abs($DbRow['money']), 'TimeCreation' => $DbRow['date'], 'BillCode' => $DbRow['BillCode'], 'Text' => $DbRow['comment'], 'Bill' => $DbRow['bill_id']));
+            $Output .= 'FV '.$DbRow['comment'].'<br />';
+          }
+          $DbResult = $this->Database->query('SELECT * FROM finance_operations WHERE finance_operations.date >= "2007-12-01" AND (Destination = '.$Finance->MainSubject.')');
+          while($DbRow = $DbResult->fetch_assoc())
+          {
+            $this->Database->insert('FinanceClaimsLiabilities', array('Id' => $DbRow['id'], 'Subject' => $DbRow['Source'], 'Value' => abs($DbRow['money']), 'TimeCreation' => $DbRow['date'], 'BillCode' => $DbRow['BillCode'], 'Text' => $DbRow['comment'], 'Bill' => $DbRow['bill_id']));
+            $Output .= 'FP '.$DbRow['comment'].'<br />';
+          }
 
     // Transfer finance before era
@@ -402 +424 @@
       $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 .= '#';
+            $DbRow2['date'] = TimeToMysqlDateTime(mktime(0, 0, 0, 12, 1, 2007));
+            if($DbRow2['money'] > 0)
+            {
+                    $Comment = 'Přijatá záloha (z období před daňovou evidencí)';
+            $this->Database->insert('FinanceOperation', array('Subject' => $Subject['Id'], 'Cash' => 0, 'Value' => abs($DbRow2['money']), 'Time' => $DbRow2['date'], 'Taxable' => 1, 'Text' => $Comment));
+} else
+            {
+                    $Comment = 'Připojení k síti (z období před daňovou evidencí)';
+            $this->Database->insert('FinanceClaimsLiabilities', array('Subject' => $Subject['Id'], 'Value' => abs($DbRow2['money']), 'TimeCreation' => $DbRow2['date'], 'Text' => $Comment));
+            }
+            $Output .= '#';
     }