Changeset 550 for trunk/Modules/FinanceBankAPI/FileImport.php

Timestamp:

Jul 7, 2013, 7:37:48 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Přepracována třída pro import plateb přes Fio API. Nyní se načítají položky přes CSV formát.
• Přidáno: Import z Fio do tabulky FinanceBankImport a odsud pak pokud je nalezen variabilní symbol tak do FinanceOperation.

File:

• trunk/Modules/FinanceBankAPI/FileImport.php (modified) (4 diffs)

trunk/Modules/FinanceBankAPI/FileImport.php

@@ -3 +3 @@
 include_once(dirname(__FILE__).'/../../Common/Global.php');
 
-class FileImport
+class BankImport
 {
   var $Database;
-  var $BankAccountId;
+  var $BankAccount;
   
   function __construct($Database)
@@ -19 +19 @@
   function ImportFile($Content, $Ext)
   {   
+  }
+  
+  function PairOperations()
+  {
+    $DbResult = $this->Database->select('FinanceBankImport', '*', 'FinanceOperation IS NULL');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      if(is_numeric($DbRow['VariableSymbol']))
+      {
+        $DbResult2 = $this->Database->select('Subject', 'Id', 'Id='.$DbRow['VariableSymbol']);
+        if($DbResult2->num_rows == 1)
+        { 
+          $DbRow2 = $DbResult2->fetch_assoc();
+          $DbResult3 = $this->Database->insert('FinanceOperation', array('Subject' => $DbRow2['Id'], 'Cash' => 0, 
+            'Value' => $DbRow['Value'], 'Taxable' => 1, 'BankAccount' => $DbRow['BankAccount'], 'Network' => 1,
+            'Time' => $DbRow['Time'], 'Text' => $DbRow['Description']));
+          $this->Database->update('FinanceBankImport', 'Id='.$DbRow['Id'], array('FinanceOperation' => $this->Database->insert_id));
+        }
+      }
+    }
   }
 }
@@ -45 +65 @@
     if(isset($Import))
     {
-      $Import->BankAccountId = $BankAccount['Id'];
+      $Import->BankAccount = $BankAccount;
       $Output .= $Import->Import();
+      $Import->PairOperations();
     } 
     return($Output);
@@ -100 +121 @@
       else if($Bank['Code'] == '0300') $Import = new ImportPS($this->Database);
       else $Output = $this->SystemMessage('Nepodporované API', 'Pro zvolenou banku není import podporován');
-    $Import->BankAccountId = $BankAccount['Id'];
+    $Import->BankAccount = $BankAccount;
     $Output .= $Import->ImportFile($File->GetContent(), $File->GetExt());