Changeset 550 for trunk/Modules/FinanceBankAPI/ImportFio.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/ImportFio.php (modified) (1 diff)

trunk/Modules/FinanceBankAPI/ImportFio.php

@@ -3 +3 @@
 include('FioAPI.php');
  
-class ImportFio extends FileImport
+class ImportFio extends BankImport
 {
   function Import()
-  {
-    $DbResult = $this->Database->select('FinanceBankAccount', '*', 'Id='.$this->BankAccountId);    
-    $BankAccount = $DbResult->fetch_assoc();
-    
+  {   
     $Fio = new FioAPI();
-    $Fio->Token = $BankAccount['LoginName'];
-    $Records = $Fio->Import(time() - 3600 * 24 * 31 * 2, time());
-    foreach($Records as $Record)
+    $Fio->Token = $this->BankAccount['LoginName'];
+    if($this->BankAccount['LastImportDate'] == '') $PeriodStart = time();
+      else $PeriodStart = MysqlDateToTime($this->BankAccount['LastImportDate']);
+    $PeriodEnd = time();
+    $Records = $Fio->Import($PeriodStart, $PeriodEnd);
+    print_r($Records);
+    //die();
+    $Output = '<table>';
+      //$Output .= '<tr>';
+      //$Output .= '<td>Jméno účtu: '.$Records['AccountName'].'</td>';
+        //$Output .= '<td>Číslo účtu: '.$Records['AccountNumber'].'</td>';
+        //$Output .= '<td>Ke dni '.date('j.n.Y', $Records['DateStart']).' je stav účtu '.$Records['OpeningBalance'].' Kč</td>';
+        //$Output .= '<td>Ke dni '.date('j.n.Y', $Records['DateEnd']).' je stav účtu '.$Records['ClosingBalance'].' Kč</td>';
+        //$Output .= '<td>Suma příjmů: '.$Records['CreditValue'].' Kč</td>';
+        //$Output .= '<td>Suma výdajů: '.$Records['DebitValue'].' Kč</td>';     
+      //$Output .= '</tr>';
+    foreach($Records['Items'] as $Record)
     {
-      echo('<tr>');
-      if($Record['Type'] == GPC_TYPE_REPORT)
-      {
-        echo('<td>Jméno účtu: '.$Record['AccountName'].'</td>');
-        echo('<td>Číslo účtu: '.$Record['AccountNumber'].'</td>');
-        echo('<td>Ke dni '.date('j.n.Y', $Record['OldBalanceDate']).' je stav účtu '.$Record['OldBalanceValue'].' Kč</td>');
-        echo('<td>Ke dni '.date('j.n.Y', $Record['Date']).' je stav účtu '.$Record['NewBalanceValue'].' Kč</td>');
-        echo('<td>Suma příjmů: '.$Record['CreditValue'].' Kč</td>');
-        echo('<td>Suma výdajů: '.$Record['DebitValue'].' Kč</td>');     
-      } else
-      if($Record['Type'] == GPC_TYPE_ITEM)
-      {
-        $this->Database->insert('FinanceBankImport', array('Time' => TimeToMysqlDate($Record['DueDate']),
-          'BankAccount' => $this->BankAccount, 'Value' => $Record['Value'], 
+      $DbResult = $this->Database->select('FinanceBankImport', 'ID', 'Identification='.$Record['ID']);
+      if($DbResult->num_rows == 0)
+      {      
+      $Output .= '<tr>';
+        $this->Database->insert('FinanceBankImport', array('Time' => TimeToMysqlDate($Record['Date']),
+          'BankAccount' => $this->BankAccount['Id'], 'Value' => $Record['Value'], 
           'SpecificSymbol' => $Record['SpecificSymbol'], 'VariableSymbol' => $Record['VariableSymbol'],
-          'ConstantSymbol' => $Record['ConstantSymbol'], 'Currency' => $this->Currency,
-          ));
-        echo('<td>'.$Record['OffsetAccount'].'</td>');
-        echo('<td>'.$Record['BankCode'].'</td>');
-        echo('<td>'.$Record['ClientName'].'</td>');
+          'ConstantSymbol' => $Record['ConstantSymbol'], 'Currency' => $this->BankAccount['Currency'],
+          'Identification' => $Record['ID'], 'AccountNumber' => $Record['OffsetAccount'],
+          'BankCode' => $Record['BankCode'], 'Description' => $Record['Type'], 'OffsetAccountName' => $Record['UserIdent']));
+      $Output .= '<td>'.$Record['OffsetAccount'].'</td>';
+      $Output .= '<td>'.$Record['BankCode'].'</td>';
+      $Output .= '<td>'.$Record['UserIdent'].'</td>';
+      $Output .= '</tr>';
       }
     }
+    $Output .= '</table>';   
+    $this->Database->Update('FinanceBankAccount', 'Id='.$this->BankAccount['Id'], array('LastImportDate' => TimeToMysqlDate($PeriodEnd)));
+    return($Output);
   }
 }