library/Bank/Account/Report/Kb.php

   1 <?php
   2
   3 class Bank_Account_Report_Kb extends Bank_Account_Report_Abstract
   4 {
   5         public function importReport( $file )
   6         {
   7                 $data = $this -> parseReport( $file );
   8                 var_dump($data);
   9         }
  10
  11         public function parseReport( $file )
  12         {
  13                 $out = Array();
  14                 $f = file_get_contents($file);
  15                 $lines = Explode("\n", $f);
  16
  17                 $data = Array();
  18                 $in_block = false;
  19                 $line_cnt = 0;
  20                 foreach ($lines as $line)
  21                 {
  22                         $line = rtrim($line);
  23                         if ($line == '')
  24                         { continue; }
  25
  26                         if ( preg_match(";^_+\$;", $line) )
  27                         {
  28                                 if ($in_block)
  29                                 {
  30                                         $out[] = $data;
  31                                 }
  32                                 $in_block = false;
  33                                 $data = Array();
  34                                 $line_cnt = 0;
  35                                 continue;
  36                         }
  37
  38                         $line_cnt++;
  39
  40                         if (($line_cnt == 1) && preg_match(';^((([0-9]+)-)?([0-9]+))?/([0-9]+);', $line, $M))
  41                         {
  42                                 $in_block = true;
  43                                 $data['predcisli']  = $M[3];
  44                                 $data['cislo_uctu'] = $M[4];
  45                                 $data['banka']      = $M[5];
  46
  47                                 $data['vs'] = SPrintF("%010d", (int) Trim(substr($line, 31, 10)) );
  48
  49                                 preg_match(';([+-])?([0-9]+),([0-9]+) ([A-Z]{3});i', SubStr($line, 41, 29), $C);
  50
  51                                 if ($C[1] == '')
  52                                 {
  53                                         $zn = -1;
  54                                 } else {
  55                                         $zn = ($C[1] == '-' ? -1 : 1);
  56                                 }
  57                                 $data['castka'] = ((float) (((int) $C[2]) + (((int) $C[3]) / 100))) * $zn;
  58
  59                                 $data['datum_prijeti'] = strtotime( substr($line, 70, 10) );
  60                                 $data['datum_prijeti_x'] = Date('Y-m-d', $data['datum_prijeti']);
  61                         }
  62
  63                         if ($line_cnt == 2)
  64                         {
  65                                 $data['typ'] = Trim(substr($line, 0, 31));
  66
  67                                 $data['ks'] = SPrintF("%04d", (int) Trim(substr($line, 31, 4)) );
  68                                 $data['datum_splatnosti'] = strtotime( substr($line, 70, 10) );
  69                         }
  70
  71                         if ($line_cnt == 3)
  72                         {
  73                                 $data['id'] = Trim(substr($line, 0, 31));
  74
  75                                 $data['ss'] = SPrintF("%010d", (int) Trim(substr($line, 31, 10)) );
  76                                 $data['datum_zauctovani'] = strtotime( substr($line, 70, 10) );
  77                         }
  78
  79                         if ($line_cnt == 4)
  80                         {
  81                                 $data['popis_prikazce'] = Trim( substr( $line, 31, 49 ) );
  82                         }
  83
  84                         if ($line_cnt == 5)
  85                         {
  86                                 $data['popis_prijemce'] = Trim( substr( $line, 31, 49 ) );
  87                         }
  88
  89                         if ($line_cnt > 5)
  90                         {
  91                                 $data['popis_system'] = isset($data['popis_system']) ? $data['popis_system'] : '';
  92                                 $data['popis_system'] .= ($data['popis_system'] != "" ? "\n" : "").Trim( substr( $line, 31, 49 ) );
  93                         }
  94                 }
  95
  96                 return $out;
  97         }
  98 };