source: trunk/Modules/FinanceBankAPI/FileImport.php@ 502

<?php

include_once(dirname(__FILE__).'/../../Common/Global.php');

class FileImport
{
  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()
  {
    $Output = '';
    if(!$this->System->Modules['User']->CheckPermission('Finance', 'SubjectList')) return('Nemáte oprávnění');
    if(array_key_exists('Operation', $_GET))
    {
      if($_GET['Operation'] == 'prepare') $Output .= $this->Prepare();
      else if($_GET['Operation'] == 'insert') $Output .= $this->Insert();
      else $Output .= 'Neplatná akce';
    } else $Output .= $this->ShowForm();
    return($Output);
  }
  
  function ShowForm()
  {
    $Form = new Form($this->System->FormManager);
    $Form->SetClass('ImportBankFile');
    $Form->OnSubmit = '?Operation=prepare';
    $Form->Values['BankAccount'] = $_GET['id'];
    $Output = $Form->ShowEditForm();
    return($Output);
  }
  
  function Prepare()
  {   
    $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();
    
    $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->ImportFile($File->GetContent(), $File->GetExt());
   
    return($Output);
  }
  
  function InsertMoney($Subject, $Value, $Cash, $Taxable, $Time, $Text, $DocumentLine)
  {

    $BillCode = $this->System->Modules['Finance']->GetNextDocumentLineNumber($DocumentLine);
    $this->Database->insert('FinanceOperation', array('Text' => $Text, 'Subject' => $Subject, 'Cash' => $Cash, 'Value' => $Value, 'Time' => TimeToMysqlDateTime($Time), 'Taxable' => $Taxable, 'BillCode' => $BillCode));
  }

  function Insert()
  {
    $Finance = $this->System->Modules['Finance'];
    $Output = '';
    
    for($I = $_POST['ItemCount'] - 1; $I >= 0 ; $I--)
    {
      if($_POST['Money'.$I] < 0) $DocumentLine = 4;
        else $DocumentLine = 3;
      $Date = explode('-', $_POST['Date'.$I]);
      $Date = mktime(0, 0, 0, $Date[1], $Date[2], $Date[0]);
      $this->InsertMoney($_POST['Subject'.$I], $_POST['Money'.$I], 0, $_POST['Taxable'.$I], $Date, $_POST['Text'.$I], $DocumentLine);
      $Output .= $I.', ';
      $this->System->Modules['Log']->NewRecord('Finance', 'NewPaymentInserted');
    }
    return($Output);
  }
}

?>