source: trunk/finance/import.php@ 325

<?php
include('../global.php');

class FinanceImportPayment extends Page
{
  var $FullTitle = 'Import plateb';
  var $ShortTitle = 'Import plateb';

  function Show()
  {
    if(!$this->System->Modules['User']->CheckPermission('Finance', 'SubjectList')) return('Nemáte oprávnění');
    if(array_key_exists('Operation', $_GET))
    {
      if($_GET['Operation'] == 'prepare') return($this->Prepare());
      else if($_GET['Operation'] == 'insert') return($this->Insert());
      else echo('Neplatná akce');
    } else
    {
      $Output = 'Vložte CSV data z SYLK exportu české spořitelny';
      $Output .= '<form action="?Operation=prepare" method="post">';
      $Output .= '<textarea name="Source" cols="80" rows="20"></textarea><br/>';
      $Output .= '<input type="submit" value="Analyzovat"/>';
      $Output .= '</form>';
      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 Prepare()
  {   
    $Finance = $this->System->Modules['Finance'];
    $Data = explode("\n", $_POST['Source']);
    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
        if(is_numeric($Value[5]))
        {
          $Time = explode('.', $Value[0]);
          $Time = $Time[2].'-'.$Time[1].'-'.$Time[0];
          $Money = $Value[1];
          $Subject = $Value[5] * 1;
          $Automatic .= '<tr>'.
            '<td>Automaticky</td>'.
            '<td><input type="text" name="Date'.$I.'" value="'.$Time.'"/></td>'.
            '<td><input type="text" 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="Vklad"/></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>'; 
        } else
        {
          $Time = explode('.', $Value[0]);
          $Time = $Time[2].'-'.$Time[1].'-'.$Time[0];
          $Money = $Value[1];
          $Subject = '?';
          $Automatic .= '<tr>'.
            '<td>Ručně</td>'.
            '<td><input type="text" name="Date'.$I.'" value="'.$Time.'"/></td>'.
            '<td><input type="text" 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="Vklad"/></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>';      
    }
    return($Output);
  }
  
  function Insert()
  {
    $Finance = $this->System->Modules['Finance'];
    $Output = '';
    
    for($I = 0; $I < $_POST['ItemCount']; $I++)
    {
      if($_POST['Money'.$I] < 0) $DocumentLine = 4;
        else $DocumentLine = 3;
      $this->InsertMoney($_POST['Subject'.$I], $_POST['Money'.$I], 0, $_POST['Taxable'.$I], $_POST['Date'.$I], $_POST['Text'.$I], $DocumentLine);
      $Output .= $I.', ';
      $this->System->Modules['Log']->NewRecord('Finance', 'NewPaymentInserted');
    }
    return($Output);
  }
}

$System->AddModule(new FinanceImportPayment());
$System->Modules['FinanceImportPayment']->GetOutput();

?>