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

Timestamp:

Mar 12, 2013, 10:58:10 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Akce pro import plateb přes API nebo ze souboru z tabulky "Bankovní účty" ze správy dat.
• Přidáno: Prozatím zkoušení importu z Fio a Poštovní spořitelny.

File:

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

trunk/Modules/FinanceBankAPI/FileImport.php

@@ -3 +3 @@
 include_once(dirname(__FILE__).'/../../Common/Global.php');
 
-class PageFileImport extends Page
+class FileImport
 {
-  var $FullTitle = 'Import plateb';
-  var $ShortTitle = 'Import plateb';
+  var $Database;
+  var $BankAccountId;
+  
+  function __construct($Database)
+  {
+    $this->Database = &$Database;
+  }
+     
+  function Import()
+  {
+  }
+  
+  function ImportFile($Content, $Ext)
+  {   
+  }
+}
+
+class PageImportAPI extends Page
+{
+  var $FullTitle = 'Import plateb přes API';
+  var $ShortTitle = 'Import plateb přes API';
+
+  function Show()
+  {   
+    if(!$this->System->Modules['User']->CheckPermission('Finance', 'SubjectList')) return('Nemáte oprávnění');
+    
+    $DbResult = $this->Database->select('FinanceBankAccount', '*', 'Id='.$_GET['id']);
+    $BankAccount = $DbResult->fetch_assoc();
+    
+    $DbResult = $this->Database->select('FinanceBank', '*', 'Id='.$BankAccount['Bank']);
+    $Bank = $DbResult->fetch_assoc();
+    $Output .= 'Účet: '.$BankAccount['Number'].'/'.$Bank['Code'].' ('.$Bank['Name'].')';
+    
+    if($Bank['Code'] == '2010') $Import = new ImportFio($this->Database);
+      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'];
+    $Output .= $Import->Import();
+   
+    return($Output);
+  }
+}
+  
+class PageImportFile extends Page
+{
+  var $FullTitle = 'Import plateb ze souboru';
+  var $ShortTitle = 'Import plateb ze souboru';
 
   function Show()
@@ -23 +68 @@
   function ShowForm()
   {
-    $FormImport = new Form('ImportBankFile');
-    $FormImport->OnSubmit = '?Operation=prepare';
-    $Output = $FormImport->ShowEditForm();
+    $Form = new Form($this->System->FormManager);
+    $Form->SetClass('ImportBankFile');
+    $Form->OnSubmit = '?Operation=prepare';
+    $Form->Values['BankAccount'] = $_GET['id'];
+    $Output = $Form->ShowEditForm();
     return($Output);
   }
@@ -31 +78 @@
   function Prepare()
   {   
-    $FormImport = new Form('ImportBankFile');
-    $FormImport->LoadValuesFromForm();
-    $Output = $FormImport->ShowEditForm();
+    $Form = new Form($this->System->FormManager);
+    $Form->SetClass('ImportBankFile');
+    $Form->LoadValuesFromForm();
+    $File = $Form->Values['File'];
+    $Output = $File->Name.'<br/>';
+    $Output .= $File->GetFullName().'<br/>';
+
+    $DbResult = $this->Database->select('FinanceBankAccount', '*', 'Id='.$Form->Values['BankAccount']);
+    $BankAccount = $DbResult->fetch_assoc();
     
-    $Finance = $this->System->Modules['Finance'];
-    $Output = $FormImport->Values['File'];
-    return($Output);
+    $DbResult = $this->Database->select('FinanceBank', '*', 'Id='.$BankAccount['Bank']);
+    $Bank = $DbResult->fetch_assoc();
+    $Output .= 'Účet: '.$BankAccount['Number'].'/'.$Bank['Code'].' ('.$Bank['Name'].')';
     
-    $Data =  $FormImport->Values['File'];
-    foreach($Data as $Key => $Value)
-    {
-      $Value = str_replace('\"', '"', $Value);
-      $Data[$Key] = str_getcsv($Value, ',', '"', "\\");
-      //print_r($Data[$Key]);
-      foreach($Data[$Key] as $Key2 => $Value2)
-      {
-        if(substr($Data[$Key][$Key2], 0, 2) == '\"')
-          $Data[$Key][$Key2] = substr($Data[$Key][$Key2], 2, -2); 
-      }
-    }
-    $Header = array(
-      0 => 'datum zaúčtování',         
-      1 => 'částka',
-      2 => 'měna',
-      3 => 'zůstatek',
-      4 => 'konstantní symbol',
-      5 => 'variabilní symbol',
-      6 => 'specifický symbol',
-      7 => 'označení operace',
-      8 => 'název protiúčtu',
-      9 => 'protiúčet',
-      10 => 'poznámka',
-      11 => '',
-    );
-    //print_r($Header);
-    //print_r($Data[0]);
-    //print_r($_POST['Source']);
-    //print_r($Data);
-  
-    if($Header != $Data[0]) $Output = 'Nekompatibilní struktura CSV';
-    else 
-    {
-      array_shift($Data);
-      $Automatic = '';
-      $Manual = '';
-      $Output = '<form action="?Operation=insert" method="post">';
-      $I = 0;
-      foreach($Data as $Key => $Value)
-      {
-        if(count($Value) <= 1) continue;
-        if($Value[9] == '') $Value[5] = 128; // Žádný účet => Poštovní spořitelna
-        $Time = explode('.', $Value[0]);
-        $Time = $Time[2].'-'.$Time[1].'-'.$Time[0];
-        $Money = $Value[1];
-        if(is_numeric($Value[5]))
-        {
-          $Subject = $Value[5] * 1;
-          $DbResult = $this->Database->query('SELECT Id FROM Subject WHERE Id='.$this->Database->real_escape_string($Subject));
-          if($DbResult->num_rows == 0) $Subject = '? ('.($Value[5] * 1).')';
-        } else
-        {
-          $Subject = '? ('.$Value[5].')';
-        }
-        if(!is_numeric($Subject)) 
-        {
-          $Mode = 'Ručně';
-          $Style = 'style="background-color: LightPink;" ';
-        } else 
-        {
-          $Mode = 'Automaticky';
-          $Style = '';
-        }
-    
-        if($Money < 0) $Text = 'Platba převodem';
-          else $Text = 'Přijatá platba';
-        $Automatic .= '<tr>'.
-            //'<td>'.$Mode.'</td>'.
-            '<td><input type="text" name="Date'.$I.'" value="'.$Time.'"/></td>'.
-            '<td><input type="text" '.$Style.'name="Subject'.$I.'" value="'.$Subject.'"/></td>'.
-            '<td>'.$Value[8].'</td>'.
-            '<td><input type="text" name="Money'.$I.'" value="'.$Money.'"/></td>'.
-            '<td><input type="text" name="Text'.$I.'" value="'.$Text.'"/></td>'.
-            '<td><input type="text" name="Taxable'.$I.'" value="1"/></td>'.
-            '<td><input type="text" name="Network'.$I.'" value="1"/></td>'.
-            '</tr><tr><td colspan="7">'.implode(', ', $Value).'</td></tr>'; 
-        $I++;
-      }
-      $Output .= '<table class="WideTable">'.
-        '<tr>'.
-        //'<th>Zpracování</th>'.
-        '<th>Datum</th><th>Var. symbol</th><th>Protiúčet</th><th>Částka [Kč]</th><th>Text</th><th>Zdanitelné</th><th>Síť</th></tr>';
-      $Output .= $Automatic.'</table>';
-      $Output .= '<input type="hidden" name="ItemCount" value="'.$I.'"/>'; 
-      $Output .= '<input type="submit" value="Zpracovat"/></form>';      
-    }
+    if($Bank['Code'] == '2010') $Import = new ImportFio($this->Database);
+      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'];
+    $Output .= $Import->ImportFile($File->GetContent(), $File->GetExt());
+   
     return($Output);
   }