|
<html><body><h1>Chyba nahlasena z: . import/upload_bank_file/1 (file: 69, line: 69)</h1><p>FreenetIS verze: 1.1.19</p><p>PHP verze: 5.4.45-0+deb7u6</p><p>Nahlasil: Lukas Machek</p><p>Popis: Upgradoval jsem freenetis na verzi 1.1.19 a opet nam nefunguje import v CSV z bankovniho uctu.</p><h2>Neznama chyba</h2><p>9</p><p class="message">iconv(): Detected an illegal character in input string</p><p class="detail">Chyba se vyskytla na <strong>radku 69</strong> souboru <strong>application/libraries/importers/Csv_Fio_Bank_Statement_File_Importer.php</strong>.</p><div><ul class="backtrace"><li><strong>application/libraries/importers/Csv_Fio_Bank_Statement_File_Importer.php [69]:</strong><pre>iconv( cp1250, UTF-8, "Datum";"ID operace";"ID pokynu";"KS";"Nazev banky";"Nazev protiuctu";"Objem";"Mena";"Protiucet";"Kod banky";"Zadal";"SS";"Typ";"Poznamka";"VS";"Upresneni - objem";"Upresneni - mena";"Zprava pro prijemce"
|
|
"01.01.2017";"13872339029";"15454425226";"";"Fio banka, a.s.";"Kolarova, Stepanka";"290";"CZK";"2900177556";"2010";"";"";"Platba prevodem uvnitr banky";"";"";"290";"CZK";""
|
|
"01.01.2017";"13873316433";"15458590667";"";"mBank S.A., organizacni slozka";"";"-15918";"CZK";"670100-2208608735";"6210";"Machek, Lukas";"";"Bezhotovostni platba";"technik nakup materialu";"2016000028";"15918";"CZK";""
|
|
"02.01.2017";"13873438807";"15459579944";"4712";"Ceska sporitelna, a.s.";"Volejnikova Blanka";"900";"CZK";"200940013";"0800";"";"";"Bezhotovostni prijem";"Volejnikova Blanka";"56";"900";"CZK";""
|
|
"02.01.2017";"13873440285";"15459591218";"4712";"Ceska sporitelna, a.s.";"Radova Andrea";"150";"CZK";"951600183";"0800";"";"";"Bezhotovostni prijem";"Radova Andrea";"62";"150";"CZK";""
|
|
"02.01.2017";"13873443932";"15459620054";"0138";"Ceska sporitelna, a.s.";"Beran Tomas";"150";"CZK";"1658910013";"0800";"";"";"Bezhotovostni prijem";"Beran Tomas";"31";"150";"CZK";""
|
|
"02.01.2017";"13873454154";"15459697207";"";"MONETA Money Bank, a.s.";" HERMANKOVA MARIE";"150";"CZK";"219169919";"0600";"";"";"Bezhotovostni prijem";" HERMANKOVA MARIE";"71";"150";"CZK";"internet"
|
|
"03.01.2017";"13873879725";"15461896589";"0000";"CSOB, a.s.";"NOVOTNA HANA";"290";"CZK";"110470134";"0300";"";"";"Bezhotovostni prijem";"NOVOTNA HANA";"48";"290";"CZK";""
|
|
"03.01.2017";"13873879976";"15461897854";"4712";"CSOB, a.s.";"KOSLIK VACLAV";"290";"CZK";"128227298";"0300";"";"";"Bezhotovostni prijem";"KOSLIK VACLAV";"45";"290";"CZK";""
|
|
"03.01.2017";"13873967544";"15462237856";"4712";"MONETA Money Bank, a.s.";" HAVLICEK LIBOR";"290";"CZK";"1379911574";"0600";"";"";"Bezhotovostni prijem";" HAVLICEK LIBOR";"52";"290";"CZK";""
|
|
"03.01.2017";"13873967545";"15462237857";"";"MONETA Money Bank, a.s.";" RADOMIR RIMAL";"290";"CZK";"163042897";"0600";"";"";"Bezhotovostni prijem";" RADOMIR RIMAL";"32";"290";"CZK";""
|
|
"04.01.2017";"13874362721";"15464021241";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"300";"CZK";"160987123";"0300";"";"0";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"85";"300";"CZK";" posta 128203 02.01.2017 c 3021MI*AELABARTOSOVA"
|
|
"04.01.2017";"13874390401";"15464134533";"4712";"CSOB, a.s.";"MACHKOVA RADKA";"300";"CZK";"241717504";"0300";"";"";"Bezhotovostni prijem";"MACHKOVA RADKA";"10";"300";"CZK";"clensky prispevek"
|
|
"05.01.2017";"13874935072";"15466499746";"";"Ceska sporitelna, a.s.";"Nemeckova Vera";"290";"CZK";"1112616023";"0800";"";"";"Bezhotovostni prijem";"Nemeckova Vera";"16";"290";"CZK";""
|
|
"05.01.2017";"13874937178";"15466509357";"";"Ceska sporitelna, a.s.";"Novotny Pavel";"300";"CZK";"2244540133";"0800";"";"";"Bezhotovostni prijem";"Novotny Pavel";"61";"300";"CZK";""
|
|
"05.01.2017";"13874938658";"15466517196";"";"Ceska sporitelna, a.s.";"Kuncova Ruzena";"290";"CZK";"734867113";"0800";"";"";"Bezhotovostni prijem";"Kuncova Ruzena";"68";"290";"CZK";""
|
|
"05.01.2017";"13874948178";"15466565811";"";"MONETA Money Bank, a.s.";" LIBALOVA JITKA";"300";"CZK";"215195423";"0600";"";"4712";"Bezhotovostni prijem";" LIBALOVA JITKA";"77";"300";"CZK";""
|
|
"06.01.2017";"13875328119";"15468360313";"4712";"CSOB, a.s.";"NEMEC JAN";"290";"CZK";"241081825";"0300";"";"";"Bezhotovostni prijem";"NEMEC JAN";"36";"290";"CZK";"internet"
|
|
"06.01.2017";"13875353957";"15468461617";"0558";"Fio banka, a.s.";"Vokal, Petr";"150";"CZK";"2300404559";"2010";"";"4712";"Platba prevodem uvnitr banky";"";"39";"150";"CZK";""
|
|
"06.01.2017";"13875425615";"15468738558";"4721";"Ceska sporitelna, a.s.";"Dedkova Ivana";"290";"CZK";"486821043";"0800";"";"";"Bezhotovostni prijem";"Dedkova Ivana";"13";"290";"CZK";""
|
|
"08.01.2017";"13875929683";"15471040534";"4712";"Fio banka, a.s.";"Lonsky, Vaclav";"290";"CZK";"2800218699";"2010";"";"4712";"Platba prevodem uvnitr banky";"venlon";"70";"290";"CZK";"venlon"
|
|
"09.01.2017";"13876207328";"15472115111";"0000";"Komercni banka a.s.";"ZELINKA OLDRICH";"300";"CZK";"51-7254650267";"0100";"";"0";"Bezhotovostni prijem";"ZELINKA OLDRICH";"41";"300";"CZK";""
|
|
"09.01.2017";"13876207330";"15472115112";"0000";"Komercni banka a.s.";"KOSINA RUDOLF";"290";"CZK";"51-7255030297";"0100";"";"0";"Bezhotovostni prijem";"KOSINA RUDOLF";"18";"290";"CZK";""
|
|
"09.01.2017";"13876246374";"15472347857";"4712";"MONETA Money Bank, a.s.";" RADONOVA JIRINA";"290";"CZK";"1273519574";"0600";"";"";"Bezhotovostni prijem";" RADONOVA JIRINA";"14";"290";"CZK";""
|
|
"10.01.2017";"13876682180";"15474300939";"0000";"CSOB, a.s.";"SYKOROVA JANA";"290";"CZK";"134593040";"0300";"";"";"Bezhotovostni prijem";"SYKOROVA JANA";"1027";"290";"CZK";""
|
|
"10.01.2017";"13876683349";"15474314117";"4712";"CSOB, a.s.";"PATACIK MIROSLAV";"290";"CZK";"195951294";"0300";"";"";"Bezhotovostni prijem";"PATACIK MIROSLAV";"73";"290";"CZK";""
|
|
"10.01.2017";"13876683369";"15474314313";"0000";"CSOB, a.s.";"HALTUCHOVA PAVLA";"300";"CZK";"196839376";"0300";"";"";"Bezhotovostni prijem";"HALTUCHOVA PAVLA";"38";"300";"CZK";""
|
|
"10.01.2017";"13876719412";"15474663118";"4712";"Ceska sporitelna, a.s.";"Kroupa Bohuslav";"1800";"CZK";"361526163";"0800";"";"";"Bezhotovostni prijem";"Kroupa Bohuslav";"35";"1800";"CZK";"Kroupa Patek 1-6"
|
|
"10.01.2017";"13876771835";"15474861446";"4712";"Komercni banka a.s.";"PELCOVA DANIELA";"290";"CZK";"9257200287";"0100";"";"0";"Bezhotovostni prijem";"PELCOVA DANIELA";"76";"290";"CZK";""
|
|
"10.01.2017";"13876799432";"15474958089";"";"Ceska sporitelna, a.s.";"HRUBA ALENA";"150";"CZK";"279249013";"0800";"";"";"Bezhotovostni prijem";"HRUBA ALENA";"25";"150";"CZK";""
|
|
"10.01.2017";"13876800389";"15474963106";"";"Ceska sporitelna, a.s.";"BERANOVA JAROSLAVA";"290";"CZK";"373465193";"0800";"";"";"Bezhotovostni prijem";"BERANOVA JAROSLAVA";"31";"290";"CZK";"internet Beranova Jaroslava"
|
|
"10.01.2017";"13876800693";"15474964765";"4712";"Ceska sporitelna, a.s.";"LOUNKOVA JANA";"290";"CZK";"788937033";"0800";"";"";"Bezhotovostni prijem";"LOUNKOVA JANA";"12";"290";"CZK";""
|
|
"10.01.2017";"13876804432";"15474983239";"";"Ceska sporitelna, a.s.";"Kohout Pavel";"290";"CZK";"1663893123";"0800";"";"";"Bezhotovostni prijem";"Kohout Pavel";"49";"290";"CZK";""
|
|
"10.01.2017";"13876805739";"15474989708";"4718";"Ceska sporitelna, a.s.";"Novak Milan";"290";"CZK";"1092252153";"0800";"";"";"Bezhotovostni prijem";"Novak Milan";"67";"290";"CZK";""
|
|
"10.01.2017";"13876847923";"15475136075";"";"Ceska sporitelna, a.s.";"Bulickova Marie";"290";"CZK";"1323252063";"0800";"";"";"Bezhotovostni prijem";"Bulickova Marie";"58";"290";"CZK";""
|
|
"10.01.2017";"13876892455";"15475412545";"4712";"Air Bank a.s.";"Irena Radonova";"300";"CZK";"1428003012";"3030";"";"";"Bezhotovostni prijem";"Irena Radonova";"15";"300";"CZK";""
|
|
"10.01.2017";"13876963316";"15475733730";"4712";"MONETA Money Bank, a.s.";"AGD SENICE A.S.";"300";"CZK";"404406584";"0600";"";"";"Bezhotovostni prijem";"AGD SENICE A.S.";"28";"300";"CZK";""
|
|
"11.01.2017";"13877388657";"15477610570";"4712";"CSOB, a.s.";"CISAR LUBOS";"290";"CZK";"100886080";"0300";"";"";"Bezhotovostni prijem";"CISAR LUBOS";"78";"290";"CZK";""
|
|
"11.01.2017";"13877493085";"15478004760";"0308";"Komercni banka a.s.";"JANEBOVA SONA";"150";"CZK";"9252600257";"0100";"";"4712";"Bezhotovostni prijem";"JANEBOVA SONA";"33";"150";"CZK";""
|
|
"13.01.2017";"13878645976";"15483279971";"";"CSOB, a.s.";"VRANY PAVEL";"400";"CZK";"167084226";"0300";"";"";"Bezhotovostni prijem";"VRANY PAVEL";"89";"400";"CZK";"VRANY PAVEL ADSL PODEBRADY ROMANKA2500190436 / 2010"
|
|
"13.01.2017";"13878726326";"15483650954";"0000";"Komercni banka a.s.";"CHYTIL PETR";"300";"CZK";"51-7260120297";"0100";"";"0";"Bezhotovostni prijem";"CHYTIL PETR";"47";"300";"CZK";"PELASE"
|
|
"13.01.2017";"13878733842";"15483682084";"0000";"Komercni banka a.s.";"BATEK ONDREJ";"400";"CZK";"107-9892980227";"0100";"";"0";"Bezhotovostni prijem";"BATEK ONDREJ";"91";"400";"CZK";""
|
|
"15.01.2017";"13879504024";"15486961330";"0558";"Fio banka, a.s.";"Lonska, Vendula";"290";"CZK";"2200652029";"2010";"";"";"Platba prevodem uvnitr banky";"Internet Lonska V.";"30";"290";"CZK";"Internet Lonska V."
|
|
"16.01.2017";"13879909558";"15488772353";"0000";"Komercni banka a.s.";"VASIOVA PAVLA";"300";"CZK";"107-2209310287";"0100";"";"0";"Bezhotovostni prijem";"VASIOVA PAVLA";"74";"300";"CZK";""
|
|
"16.01.2017";"13879965096";"15488933065";"";"Ceska sporitelna, a.s.";"Radechovsky Jiri";"290";"CZK";"344396133";"0800";"";"";"Bezhotovostni prijem";"Radechovsky Jiri";"59";"290";"CZK";"Platba PeLaSe internet"
|
|
"16.01.2017";"13879981857";"15489031101";"";"Ceska sporitelna, a.s.";"Koudelka Jiri";"290";"CZK";"693577143";"0800";"";"";"Bezhotovostni prijem";"Koudelka Jiri";"21";"290";"CZK";""
|
|
"16.01.2017";"13879988631";"15489057446";"4712";"Ceska sporitelna, a.s.";"Lounek Miroslav";"290";"CZK";"908572113";"0800";"";"";"Bezhotovostni prijem";"Lounek Miroslav";"22";"290";"CZK";"platba od mirase za net"
|
|
"16.01.2017";"13879996083";"15489086813";"4712";"Ceska sporitelna, a.s.";"Dvorakova Daniela";"290";"CZK";"1081999083";"0800";"";"";"Bezhotovostni prijem";"Dvorakova Daniela";"81";"290";"CZK";"Dvorak - PeLaSe"
|
|
"16.01.2017";"13880033613";"15489317052";"4712";"MONETA Money Bank, a.s.";"CHYTIL JOSEF";"300";"CZK";"150038936";"0600";"";"";"Bezhotovostni prijem";"CHYTIL JOSEF";"26";"300";"CZK";""
|
|
"16.01.2017";"13880033614";"15489317053";"0308";"MONETA Money Bank, a.s.";" BERAN JOSEF";"300";"CZK";"609-404537584";"0600";"";"";"Bezhotovostni prijem";" BERAN JOSEF";"51";"300";"CZK";"internet"
|
|
"16.01.2017";"13880033615";"15489317055";"";"MONETA Money Bank, a.s.";" BULDROVA ALENA";"290";"CZK";"1361316574";"0600";"";"";"Bezhotovostni prijem";" BULDROVA ALENA";"82";"290";"CZK";""
|
|
"16.01.2017";"13880033616";"15489317056";"";"MONETA Money Bank, a.s.";" KAFKOVA LENKA";"400";"CZK";"205185651";"0600";"";"";"Bezhotovostni prijem";" KAFKOVA LENKA";"46";"400";"CZK";""
|
|
"16.01.2017";"13880033617";"15489317058";"";"MONETA Money Bank, a.s.";" POPOVSKA RUZENA";"290";"CZK";"183079195";"0600";"";"";"Bezhotovostni prijem";" POPOVSKA RUZENA";"79";"290";"CZK";""
|
|
"16.01.2017";"13880183572";"15490152568";"";"Ceska sporitelna, a.s.";"Buckovska Sofie";"290";"CZK";"1804853193";"0800";"";"";"Bezhotovostni prijem";"Buckovska Sofie";"24";"290";"CZK";""
|
|
"17.01.2017";"13880617153";"15492117445";"";"CSOB, a.s.";"MIROSLAV MANDOUS";"290";"CZK";"246048549";"0300";"";"";"Bezhotovostni prijem";"MIROSLAV MANDOUS";"75";"290";"CZK";""
|
|
"17.01.2017";"13880622459";"15492208995";"0558";"CSOB, a.s.";"KOHOUTOVA IVANA";"290";"CZK";"101416881";"0300";"";"";"Bezhotovostni prijem";"KOHOUTOVA IVANA";"86";"290";"CZK";""
|
|
"17.01.2017";"13880638050";"15492272328";"";"CSOB, a.s.";"SUCHANEK MAREK";"300";"CZK";"267367127";"0300";"";"";"Bezhotovostni prijem";"SUCHANEK MAREK";"66";"300";"CZK";""
|
|
"17.01.2017";"13880655157";"15492353269";"4712";"UniCredit Bank Czech Republic and Slovakia, a.s.";"JAROSLAVA HOSKOVA";"290";"CZK";"2111118924";"2700";"";"";"Bezhotovostni prijem";"JAROSLAVA HOSKOVA";"72";"290";"CZK";""
|
|
"17.01.2017";"13880763791";"15492779323";"0308";"MONETA Money Bank, a.s.";" PAVEZKA ALES";"150";"CZK";"219349506";"0600";"";"";"Bezhotovostni prijem";" PAVEZKA ALES";"20";"150";"CZK";"pelase"
|
|
"17.01.2017";"13880768320";"15492798246";"";"Ceska sporitelna, a.s.";"Stastny Miroslav";"290";"CZK";"937581043";"0800";"";"";"Bezhotovostni prijem";"Stastny Miroslav";"29";"290";"CZK";""
|
|
"18.01.2017";"13881381080";"15495448278";"0000";"CSOB, a.s.";"RIHA JAN";"290";"CZK";"217631241";"0300";"";"";"Bezhotovostni prijem";"RIHA JAN";"37";"290";"CZK";""
|
|
"19.01.2017";"13882065347";"15498427099";"0308";"Ceska sporitelna, a.s.";"Nozicka Ladislav";"300";"CZK";"1135645193";"0800";"";"";"Bezhotovostni prijem";"Nozicka Ladislav";"57";"300";"CZK";""
|
|
"20.01.2017";"13882527455";"15500457101";"";"Fio banka, a.s.";"Vokal, Petr";"400";"CZK";"2300404559";"2010";"";"";"Platba prevodem uvnitr banky";"";"90";"400";"CZK";""
|
|
"20.01.2017";"13882649305";"15500985291";"4712";"Ceska sporitelna, a.s.";"Lounek Rostislav";"290";"CZK";"857904033";"0800";"";"";"Bezhotovostni prijem";"Lounek Rostislav";"23";"290";"CZK";""
|
|
"20.01.2017";"13883005794";"15502685097";"";"Sberbank CZ, a.s.";"";"-4307";"CZK";"4200140487";"6800";"Machek, Lukas";"";"Bezhotovostni platba";"";"3701323";"4307";"CZK";""
|
|
"23.01.2017";"13883570996";"15504903130";"4712";"Ceska sporitelna, a.s.";"Stastna Vera";"290";"CZK";"2742768093";"0800";"";"";"Bezhotovostni prijem";"Stastna Vera";"50";"290";"CZK";""
|
|
"24.01.2017";"13883998376";"15506987678";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"1000";"CZK";"160987123";"0300";"";"";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"64";"1000";"CZK";" posta 106652 20.01.2017 c 2014*JIJ IRFINTERNET 2016"
|
|
"25.01.2017";"13884713436";"15509994384";"4712";"Komercni banka a.s.";"LUKACIK LUDEK";"1000";"CZK";"27-3252330237";"0100";"";"0";"Bezhotovostni prijem";"LUKACIK LUDEK";"53";"1000";"CZK";"INTERNET SENICE LUKACIK INTERNET SENICE LUKACIK"
|
|
"25.01.2017";"13884730287";"15510083511";"";"Ceska sporitelna, a.s.";"JEZEK ZDENEK";"290";"CZK";"939660183";"0800";"";"";"Bezhotovostni prijem";"JEZEK ZDENEK";"65";"290";"CZK";""
|
|
"25.01.2017";"13884730441";"15510084253";"";"Ceska sporitelna, a.s.";"Pestova Eva";"290";"CZK";"1019050133";"0800";"";"";"Bezhotovostni prijem";"Pestova Eva";"92";"290";"CZK";""
|
|
"26.01.2017";"13885253994";"15497792546";"0308";"CSOB, a.s.";"";"-704";"CZK";"217077033";"0300";"";"";"Inkaso";"vodafone";"0483911695";"704";"CZK";""
|
|
"30.01.2017";"13886423307";"15517851620";"4712";"Ceska sporitelna, a.s.";"Hanousek Vit";"300";"CZK";"2811085123";"0800";"";"";"Bezhotovostni prijem";"Hanousek Vit";"80";"300";"CZK";""
|
|
"31.01.2017";"13887166761";"15521221646";"4712";"Fio banka, a.s.";"Safrankova, Katerina";"900";"CZK";"2500457882";"2010";"";"";"Platba prevodem uvnitr banky";"";"34";"900";"CZK";""
|
|
)</pre></li>
|
|
<li><strong>application/libraries/Bank_Statement_File_Importer.php [238]:</strong><pre>Csv_Fio_Bank_Statement_File_Importer->check_file_data_format( )</pre></li>
|
|
<li><strong>application/libraries/Bank_Statement_File_Importer.php [193]:</strong><pre>Bank_Statement_File_Importer::import_loaded( Bank_account_Model Object
|
|
(
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => member
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
[0] => accounts
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 1
|
|
[name] => Fio
|
|
[member_id] => 1
|
|
[account_nr] => 2500190436
|
|
[bank_nr] => 2010
|
|
[type] => 1
|
|
[settings] => {"enable_download_statements_automatically":null,"api_token":null}
|
|
[IBAN] => CZ1520100000002500190436
|
|
[SWIFT] => FIOBCZPPXXX
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => bank_account
|
|
[object_plural:protected] => bank_accounts
|
|
[table_name:protected] => bank_accounts
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[name] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
)
|
|
|
|
[member_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[account_nr] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
[null] => 1
|
|
)
|
|
|
|
[bank_nr] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 20
|
|
[null] => 1
|
|
)
|
|
|
|
[type] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[settings] => Array
|
|
(
|
|
[type] => string
|
|
[null] => 1
|
|
)
|
|
|
|
[IBAN] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
[null] => 1
|
|
)
|
|
|
|
[SWIFT] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
[null] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysqli
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysqli_Driver Object
|
|
(
|
|
[link:protected] => mysqli Object
|
|
(
|
|
[affected_rows] => 1
|
|
[client_info] => 5.5.53
|
|
[client_version] => 50553
|
|
[connect_errno] => 0
|
|
[connect_error] =>
|
|
[errno] => 0
|
|
[error] =>
|
|
[error_list] => Array
|
|
(
|
|
)
|
|
|
|
[field_count] => 9
|
|
[host_info] => Localhost via UNIX socket
|
|
[info] =>
|
|
[insert_id] => 0
|
|
[server_info] => 5.5.53-0+deb7u1
|
|
[server_version] => 50553
|
|
[stat] => Uptime: 699707 Threads: 1 Questions: 53640028 Slow queries: 7 Opens: 384 Flush tables: 1 Open tables: 369 Queries per second avg: 76.660
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 10635684
|
|
[warning_count] => 0
|
|
)
|
|
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysqli
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[statements:protected] => Array
|
|
(
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => mysqli Object
|
|
(
|
|
[affected_rows] => -1
|
|
[client_info] => 5.5.53
|
|
[client_version] => 50553
|
|
[connect_errno] => 0
|
|
[connect_error] =>
|
|
[errno] => 0
|
|
[error] =>
|
|
[error_list] => Array
|
|
(
|
|
)
|
|
|
|
[field_count] => 9
|
|
[host_info] => Localhost via UNIX socket
|
|
[info] =>
|
|
[insert_id] => 0
|
|
[server_info] => 5.5.53-0+deb7u1
|
|
[server_version] => 50553
|
|
[stat] => Uptime: 699707 Threads: 1 Questions: 53640029 Slow queries: 7 Opens: 384 Flush tables: 1 Open tables: 369 Queries per second avg: 76.660
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 10635684
|
|
[warning_count] => 0
|
|
)
|
|
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] => SELECT `bank_accounts`.*
|
|
FROM (`bank_accounts`)
|
|
WHERE `bank_accounts`.`id` = '1'
|
|
ORDER BY `bank_accounts`.`id` ASC
|
|
LIMIT 0, 1
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] =>
|
|
[update] =>
|
|
[delete] =>
|
|
)
|
|
|
|
)
|
|
, "Datum";"ID operace";"ID pokynu";"KS";"Nazev banky";"Nazev protiuctu";"Objem";"Mena";"Protiucet";"Kod banky";"Zadal";"SS";"Typ";"Poznamka";"VS";"Upresneni - objem";"Upresneni - mena";"Zprava pro prijemce"
|
|
"01.01.2017";"13872339029";"15454425226";"";"Fio banka, a.s.";"Kolarova, Stepanka";"290";"CZK";"2900177556";"2010";"";"";"Platba prevodem uvnitr banky";"";"";"290";"CZK";""
|
|
"01.01.2017";"13873316433";"15458590667";"";"mBank S.A., organizacni slozka";"";"-15918";"CZK";"670100-2208608735";"6210";"Machek, Lukas";"";"Bezhotovostni platba";"technik nakup materialu";"2016000028";"15918";"CZK";""
|
|
"02.01.2017";"13873438807";"15459579944";"4712";"Ceska sporitelna, a.s.";"Volejnikova Blanka";"900";"CZK";"200940013";"0800";"";"";"Bezhotovostni prijem";"Volejnikova Blanka";"56";"900";"CZK";""
|
|
"02.01.2017";"13873440285";"15459591218";"4712";"Ceska sporitelna, a.s.";"Radova Andrea";"150";"CZK";"951600183";"0800";"";"";"Bezhotovostni prijem";"Radova Andrea";"62";"150";"CZK";""
|
|
"02.01.2017";"13873443932";"15459620054";"0138";"Ceska sporitelna, a.s.";"Beran Tomas";"150";"CZK";"1658910013";"0800";"";"";"Bezhotovostni prijem";"Beran Tomas";"31";"150";"CZK";""
|
|
"02.01.2017";"13873454154";"15459697207";"";"MONETA Money Bank, a.s.";" HERMANKOVA MARIE";"150";"CZK";"219169919";"0600";"";"";"Bezhotovostni prijem";" HERMANKOVA MARIE";"71";"150";"CZK";"internet"
|
|
"03.01.2017";"13873879725";"15461896589";"0000";"CSOB, a.s.";"NOVOTNA HANA";"290";"CZK";"110470134";"0300";"";"";"Bezhotovostni prijem";"NOVOTNA HANA";"48";"290";"CZK";""
|
|
"03.01.2017";"13873879976";"15461897854";"4712";"CSOB, a.s.";"KOSLIK VACLAV";"290";"CZK";"128227298";"0300";"";"";"Bezhotovostni prijem";"KOSLIK VACLAV";"45";"290";"CZK";""
|
|
"03.01.2017";"13873967544";"15462237856";"4712";"MONETA Money Bank, a.s.";" HAVLICEK LIBOR";"290";"CZK";"1379911574";"0600";"";"";"Bezhotovostni prijem";" HAVLICEK LIBOR";"52";"290";"CZK";""
|
|
"03.01.2017";"13873967545";"15462237857";"";"MONETA Money Bank, a.s.";" RADOMIR RIMAL";"290";"CZK";"163042897";"0600";"";"";"Bezhotovostni prijem";" RADOMIR RIMAL";"32";"290";"CZK";""
|
|
"04.01.2017";"13874362721";"15464021241";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"300";"CZK";"160987123";"0300";"";"0";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"85";"300";"CZK";" posta 128203 02.01.2017 c 3021MI*AELABARTOSOVA"
|
|
"04.01.2017";"13874390401";"15464134533";"4712";"CSOB, a.s.";"MACHKOVA RADKA";"300";"CZK";"241717504";"0300";"";"";"Bezhotovostni prijem";"MACHKOVA RADKA";"10";"300";"CZK";"clensky prispevek"
|
|
"05.01.2017";"13874935072";"15466499746";"";"Ceska sporitelna, a.s.";"Nemeckova Vera";"290";"CZK";"1112616023";"0800";"";"";"Bezhotovostni prijem";"Nemeckova Vera";"16";"290";"CZK";""
|
|
"05.01.2017";"13874937178";"15466509357";"";"Ceska sporitelna, a.s.";"Novotny Pavel";"300";"CZK";"2244540133";"0800";"";"";"Bezhotovostni prijem";"Novotny Pavel";"61";"300";"CZK";""
|
|
"05.01.2017";"13874938658";"15466517196";"";"Ceska sporitelna, a.s.";"Kuncova Ruzena";"290";"CZK";"734867113";"0800";"";"";"Bezhotovostni prijem";"Kuncova Ruzena";"68";"290";"CZK";""
|
|
"05.01.2017";"13874948178";"15466565811";"";"MONETA Money Bank, a.s.";" LIBALOVA JITKA";"300";"CZK";"215195423";"0600";"";"4712";"Bezhotovostni prijem";" LIBALOVA JITKA";"77";"300";"CZK";""
|
|
"06.01.2017";"13875328119";"15468360313";"4712";"CSOB, a.s.";"NEMEC JAN";"290";"CZK";"241081825";"0300";"";"";"Bezhotovostni prijem";"NEMEC JAN";"36";"290";"CZK";"internet"
|
|
"06.01.2017";"13875353957";"15468461617";"0558";"Fio banka, a.s.";"Vokal, Petr";"150";"CZK";"2300404559";"2010";"";"4712";"Platba prevodem uvnitr banky";"";"39";"150";"CZK";""
|
|
"06.01.2017";"13875425615";"15468738558";"4721";"Ceska sporitelna, a.s.";"Dedkova Ivana";"290";"CZK";"486821043";"0800";"";"";"Bezhotovostni prijem";"Dedkova Ivana";"13";"290";"CZK";""
|
|
"08.01.2017";"13875929683";"15471040534";"4712";"Fio banka, a.s.";"Lonsky, Vaclav";"290";"CZK";"2800218699";"2010";"";"4712";"Platba prevodem uvnitr banky";"venlon";"70";"290";"CZK";"venlon"
|
|
"09.01.2017";"13876207328";"15472115111";"0000";"Komercni banka a.s.";"ZELINKA OLDRICH";"300";"CZK";"51-7254650267";"0100";"";"0";"Bezhotovostni prijem";"ZELINKA OLDRICH";"41";"300";"CZK";""
|
|
"09.01.2017";"13876207330";"15472115112";"0000";"Komercni banka a.s.";"KOSINA RUDOLF";"290";"CZK";"51-7255030297";"0100";"";"0";"Bezhotovostni prijem";"KOSINA RUDOLF";"18";"290";"CZK";""
|
|
"09.01.2017";"13876246374";"15472347857";"4712";"MONETA Money Bank, a.s.";" RADONOVA JIRINA";"290";"CZK";"1273519574";"0600";"";"";"Bezhotovostni prijem";" RADONOVA JIRINA";"14";"290";"CZK";""
|
|
"10.01.2017";"13876682180";"15474300939";"0000";"CSOB, a.s.";"SYKOROVA JANA";"290";"CZK";"134593040";"0300";"";"";"Bezhotovostni prijem";"SYKOROVA JANA";"1027";"290";"CZK";""
|
|
"10.01.2017";"13876683349";"15474314117";"4712";"CSOB, a.s.";"PATACIK MIROSLAV";"290";"CZK";"195951294";"0300";"";"";"Bezhotovostni prijem";"PATACIK MIROSLAV";"73";"290";"CZK";""
|
|
"10.01.2017";"13876683369";"15474314313";"0000";"CSOB, a.s.";"HALTUCHOVA PAVLA";"300";"CZK";"196839376";"0300";"";"";"Bezhotovostni prijem";"HALTUCHOVA PAVLA";"38";"300";"CZK";""
|
|
"10.01.2017";"13876719412";"15474663118";"4712";"Ceska sporitelna, a.s.";"Kroupa Bohuslav";"1800";"CZK";"361526163";"0800";"";"";"Bezhotovostni prijem";"Kroupa Bohuslav";"35";"1800";"CZK";"Kroupa Patek 1-6"
|
|
"10.01.2017";"13876771835";"15474861446";"4712";"Komercni banka a.s.";"PELCOVA DANIELA";"290";"CZK";"9257200287";"0100";"";"0";"Bezhotovostni prijem";"PELCOVA DANIELA";"76";"290";"CZK";""
|
|
"10.01.2017";"13876799432";"15474958089";"";"Ceska sporitelna, a.s.";"HRUBA ALENA";"150";"CZK";"279249013";"0800";"";"";"Bezhotovostni prijem";"HRUBA ALENA";"25";"150";"CZK";""
|
|
"10.01.2017";"13876800389";"15474963106";"";"Ceska sporitelna, a.s.";"BERANOVA JAROSLAVA";"290";"CZK";"373465193";"0800";"";"";"Bezhotovostni prijem";"BERANOVA JAROSLAVA";"31";"290";"CZK";"internet Beranova Jaroslava"
|
|
"10.01.2017";"13876800693";"15474964765";"4712";"Ceska sporitelna, a.s.";"LOUNKOVA JANA";"290";"CZK";"788937033";"0800";"";"";"Bezhotovostni prijem";"LOUNKOVA JANA";"12";"290";"CZK";""
|
|
"10.01.2017";"13876804432";"15474983239";"";"Ceska sporitelna, a.s.";"Kohout Pavel";"290";"CZK";"1663893123";"0800";"";"";"Bezhotovostni prijem";"Kohout Pavel";"49";"290";"CZK";""
|
|
"10.01.2017";"13876805739";"15474989708";"4718";"Ceska sporitelna, a.s.";"Novak Milan";"290";"CZK";"1092252153";"0800";"";"";"Bezhotovostni prijem";"Novak Milan";"67";"290";"CZK";""
|
|
"10.01.2017";"13876847923";"15475136075";"";"Ceska sporitelna, a.s.";"Bulickova Marie";"290";"CZK";"1323252063";"0800";"";"";"Bezhotovostni prijem";"Bulickova Marie";"58";"290";"CZK";""
|
|
"10.01.2017";"13876892455";"15475412545";"4712";"Air Bank a.s.";"Irena Radonova";"300";"CZK";"1428003012";"3030";"";"";"Bezhotovostni prijem";"Irena Radonova";"15";"300";"CZK";""
|
|
"10.01.2017";"13876963316";"15475733730";"4712";"MONETA Money Bank, a.s.";"AGD SENICE A.S.";"300";"CZK";"404406584";"0600";"";"";"Bezhotovostni prijem";"AGD SENICE A.S.";"28";"300";"CZK";""
|
|
"11.01.2017";"13877388657";"15477610570";"4712";"CSOB, a.s.";"CISAR LUBOS";"290";"CZK";"100886080";"0300";"";"";"Bezhotovostni prijem";"CISAR LUBOS";"78";"290";"CZK";""
|
|
"11.01.2017";"13877493085";"15478004760";"0308";"Komercni banka a.s.";"JANEBOVA SONA";"150";"CZK";"9252600257";"0100";"";"4712";"Bezhotovostni prijem";"JANEBOVA SONA";"33";"150";"CZK";""
|
|
"13.01.2017";"13878645976";"15483279971";"";"CSOB, a.s.";"VRANY PAVEL";"400";"CZK";"167084226";"0300";"";"";"Bezhotovostni prijem";"VRANY PAVEL";"89";"400";"CZK";"VRANY PAVEL ADSL PODEBRADY ROMANKA2500190436 / 2010"
|
|
"13.01.2017";"13878726326";"15483650954";"0000";"Komercni banka a.s.";"CHYTIL PETR";"300";"CZK";"51-7260120297";"0100";"";"0";"Bezhotovostni prijem";"CHYTIL PETR";"47";"300";"CZK";"PELASE"
|
|
"13.01.2017";"13878733842";"15483682084";"0000";"Komercni banka a.s.";"BATEK ONDREJ";"400";"CZK";"107-9892980227";"0100";"";"0";"Bezhotovostni prijem";"BATEK ONDREJ";"91";"400";"CZK";""
|
|
"15.01.2017";"13879504024";"15486961330";"0558";"Fio banka, a.s.";"Lonska, Vendula";"290";"CZK";"2200652029";"2010";"";"";"Platba prevodem uvnitr banky";"Internet Lonska V.";"30";"290";"CZK";"Internet Lonska V."
|
|
"16.01.2017";"13879909558";"15488772353";"0000";"Komercni banka a.s.";"VASIOVA PAVLA";"300";"CZK";"107-2209310287";"0100";"";"0";"Bezhotovostni prijem";"VASIOVA PAVLA";"74";"300";"CZK";""
|
|
"16.01.2017";"13879965096";"15488933065";"";"Ceska sporitelna, a.s.";"Radechovsky Jiri";"290";"CZK";"344396133";"0800";"";"";"Bezhotovostni prijem";"Radechovsky Jiri";"59";"290";"CZK";"Platba PeLaSe internet"
|
|
"16.01.2017";"13879981857";"15489031101";"";"Ceska sporitelna, a.s.";"Koudelka Jiri";"290";"CZK";"693577143";"0800";"";"";"Bezhotovostni prijem";"Koudelka Jiri";"21";"290";"CZK";""
|
|
"16.01.2017";"13879988631";"15489057446";"4712";"Ceska sporitelna, a.s.";"Lounek Miroslav";"290";"CZK";"908572113";"0800";"";"";"Bezhotovostni prijem";"Lounek Miroslav";"22";"290";"CZK";"platba od mirase za net"
|
|
"16.01.2017";"13879996083";"15489086813";"4712";"Ceska sporitelna, a.s.";"Dvorakova Daniela";"290";"CZK";"1081999083";"0800";"";"";"Bezhotovostni prijem";"Dvorakova Daniela";"81";"290";"CZK";"Dvorak - PeLaSe"
|
|
"16.01.2017";"13880033613";"15489317052";"4712";"MONETA Money Bank, a.s.";"CHYTIL JOSEF";"300";"CZK";"150038936";"0600";"";"";"Bezhotovostni prijem";"CHYTIL JOSEF";"26";"300";"CZK";""
|
|
"16.01.2017";"13880033614";"15489317053";"0308";"MONETA Money Bank, a.s.";" BERAN JOSEF";"300";"CZK";"609-404537584";"0600";"";"";"Bezhotovostni prijem";" BERAN JOSEF";"51";"300";"CZK";"internet"
|
|
"16.01.2017";"13880033615";"15489317055";"";"MONETA Money Bank, a.s.";" BULDROVA ALENA";"290";"CZK";"1361316574";"0600";"";"";"Bezhotovostni prijem";" BULDROVA ALENA";"82";"290";"CZK";""
|
|
"16.01.2017";"13880033616";"15489317056";"";"MONETA Money Bank, a.s.";" KAFKOVA LENKA";"400";"CZK";"205185651";"0600";"";"";"Bezhotovostni prijem";" KAFKOVA LENKA";"46";"400";"CZK";""
|
|
"16.01.2017";"13880033617";"15489317058";"";"MONETA Money Bank, a.s.";" POPOVSKA RUZENA";"290";"CZK";"183079195";"0600";"";"";"Bezhotovostni prijem";" POPOVSKA RUZENA";"79";"290";"CZK";""
|
|
"16.01.2017";"13880183572";"15490152568";"";"Ceska sporitelna, a.s.";"Buckovska Sofie";"290";"CZK";"1804853193";"0800";"";"";"Bezhotovostni prijem";"Buckovska Sofie";"24";"290";"CZK";""
|
|
"17.01.2017";"13880617153";"15492117445";"";"CSOB, a.s.";"MIROSLAV MANDOUS";"290";"CZK";"246048549";"0300";"";"";"Bezhotovostni prijem";"MIROSLAV MANDOUS";"75";"290";"CZK";""
|
|
"17.01.2017";"13880622459";"15492208995";"0558";"CSOB, a.s.";"KOHOUTOVA IVANA";"290";"CZK";"101416881";"0300";"";"";"Bezhotovostni prijem";"KOHOUTOVA IVANA";"86";"290";"CZK";""
|
|
"17.01.2017";"13880638050";"15492272328";"";"CSOB, a.s.";"SUCHANEK MAREK";"300";"CZK";"267367127";"0300";"";"";"Bezhotovostni prijem";"SUCHANEK MAREK";"66";"300";"CZK";""
|
|
"17.01.2017";"13880655157";"15492353269";"4712";"UniCredit Bank Czech Republic and Slovakia, a.s.";"JAROSLAVA HOSKOVA";"290";"CZK";"2111118924";"2700";"";"";"Bezhotovostni prijem";"JAROSLAVA HOSKOVA";"72";"290";"CZK";""
|
|
"17.01.2017";"13880763791";"15492779323";"0308";"MONETA Money Bank, a.s.";" PAVEZKA ALES";"150";"CZK";"219349506";"0600";"";"";"Bezhotovostni prijem";" PAVEZKA ALES";"20";"150";"CZK";"pelase"
|
|
"17.01.2017";"13880768320";"15492798246";"";"Ceska sporitelna, a.s.";"Stastny Miroslav";"290";"CZK";"937581043";"0800";"";"";"Bezhotovostni prijem";"Stastny Miroslav";"29";"290";"CZK";""
|
|
"18.01.2017";"13881381080";"15495448278";"0000";"CSOB, a.s.";"RIHA JAN";"290";"CZK";"217631241";"0300";"";"";"Bezhotovostni prijem";"RIHA JAN";"37";"290";"CZK";""
|
|
"19.01.2017";"13882065347";"15498427099";"0308";"Ceska sporitelna, a.s.";"Nozicka Ladislav";"300";"CZK";"1135645193";"0800";"";"";"Bezhotovostni prijem";"Nozicka Ladislav";"57";"300";"CZK";""
|
|
"20.01.2017";"13882527455";"15500457101";"";"Fio banka, a.s.";"Vokal, Petr";"400";"CZK";"2300404559";"2010";"";"";"Platba prevodem uvnitr banky";"";"90";"400";"CZK";""
|
|
"20.01.2017";"13882649305";"15500985291";"4712";"Ceska sporitelna, a.s.";"Lounek Rostislav";"290";"CZK";"857904033";"0800";"";"";"Bezhotovostni prijem";"Lounek Rostislav";"23";"290";"CZK";""
|
|
"20.01.2017";"13883005794";"15502685097";"";"Sberbank CZ, a.s.";"";"-4307";"CZK";"4200140487";"6800";"Machek, Lukas";"";"Bezhotovostni platba";"";"3701323";"4307";"CZK";""
|
|
"23.01.2017";"13883570996";"15504903130";"4712";"Ceska sporitelna, a.s.";"Stastna Vera";"290";"CZK";"2742768093";"0800";"";"";"Bezhotovostni prijem";"Stastna Vera";"50";"290";"CZK";""
|
|
"24.01.2017";"13883998376";"15506987678";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"1000";"CZK";"160987123";"0300";"";"";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"64";"1000";"CZK";" posta 106652 20.01.2017 c 2014*JIJ IRFINTERNET 2016"
|
|
"25.01.2017";"13884713436";"15509994384";"4712";"Komercni banka a.s.";"LUKACIK LUDEK";"1000";"CZK";"27-3252330237";"0100";"";"0";"Bezhotovostni prijem";"LUKACIK LUDEK";"53";"1000";"CZK";"INTERNET SENICE LUKACIK INTERNET SENICE LUKACIK"
|
|
"25.01.2017";"13884730287";"15510083511";"";"Ceska sporitelna, a.s.";"JEZEK ZDENEK";"290";"CZK";"939660183";"0800";"";"";"Bezhotovostni prijem";"JEZEK ZDENEK";"65";"290";"CZK";""
|
|
"25.01.2017";"13884730441";"15510084253";"";"Ceska sporitelna, a.s.";"Pestova Eva";"290";"CZK";"1019050133";"0800";"";"";"Bezhotovostni prijem";"Pestova Eva";"92";"290";"CZK";""
|
|
"26.01.2017";"13885253994";"15497792546";"0308";"CSOB, a.s.";"";"-704";"CZK";"217077033";"0300";"";"";"Inkaso";"vodafone";"0483911695";"704";"CZK";""
|
|
"30.01.2017";"13886423307";"15517851620";"4712";"Ceska sporitelna, a.s.";"Hanousek Vit";"300";"CZK";"2811085123";"0800";"";"";"Bezhotovostni prijem";"Hanousek Vit";"80";"300";"CZK";""
|
|
"31.01.2017";"13887166761";"15521221646";"4712";"Fio banka, a.s.";"Safrankova, Katerina";"900";"CZK";"2500457882";"2010";"";"";"Platba prevodem uvnitr banky";"";"34";"900";"CZK";""
|
|
, upload/01-2017 1.csv, csv, 1 )</pre></li>
|
|
<li><strong>application/controllers/import.php [235]:</strong><pre>Bank_Statement_File_Importer::import( Bank_account_Model Object
|
|
(
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => member
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
[0] => accounts
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 1
|
|
[name] => Fio
|
|
[member_id] => 1
|
|
[account_nr] => 2500190436
|
|
[bank_nr] => 2010
|
|
[type] => 1
|
|
[settings] => {"enable_download_statements_automatically":null,"api_token":null}
|
|
[IBAN] => CZ1520100000002500190436
|
|
[SWIFT] => FIOBCZPPXXX
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => bank_account
|
|
[object_plural:protected] => bank_accounts
|
|
[table_name:protected] => bank_accounts
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[name] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
)
|
|
|
|
[member_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[account_nr] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
[null] => 1
|
|
)
|
|
|
|
[bank_nr] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 20
|
|
[null] => 1
|
|
)
|
|
|
|
[type] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[settings] => Array
|
|
(
|
|
[type] => string
|
|
[null] => 1
|
|
)
|
|
|
|
[IBAN] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
[null] => 1
|
|
)
|
|
|
|
[SWIFT] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 254
|
|
[null] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysqli
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysqli_Driver Object
|
|
(
|
|
[link:protected] => mysqli Object
|
|
(
|
|
[affected_rows] => -1
|
|
[client_info] => 5.5.53
|
|
[client_version] => 50553
|
|
[connect_errno] => 0
|
|
[connect_error] =>
|
|
[errno] => 0
|
|
[error] =>
|
|
[error_list] => Array
|
|
(
|
|
)
|
|
|
|
[field_count] => 9
|
|
[host_info] => Localhost via UNIX socket
|
|
[info] =>
|
|
[insert_id] => 0
|
|
[server_info] => 5.5.53-0+deb7u1
|
|
[server_version] => 50553
|
|
[stat] => Uptime: 699707 Threads: 1 Questions: 53640030 Slow queries: 7 Opens: 384 Flush tables: 1 Open tables: 369 Queries per second avg: 76.660
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 10635684
|
|
[warning_count] => 0
|
|
)
|
|
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysqli
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[statements:protected] => Array
|
|
(
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => mysqli Object
|
|
(
|
|
[affected_rows] => -1
|
|
[client_info] => 5.5.53
|
|
[client_version] => 50553
|
|
[connect_errno] => 0
|
|
[connect_error] =>
|
|
[errno] => 0
|
|
[error] =>
|
|
[error_list] => Array
|
|
(
|
|
)
|
|
|
|
[field_count] => 9
|
|
[host_info] => Localhost via UNIX socket
|
|
[info] =>
|
|
[insert_id] => 0
|
|
[server_info] => 5.5.53-0+deb7u1
|
|
[server_version] => 50553
|
|
[stat] => Uptime: 699707 Threads: 1 Questions: 53640031 Slow queries: 7 Opens: 384 Flush tables: 1 Open tables: 369 Queries per second avg: 76.660
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 10635684
|
|
[warning_count] => 0
|
|
)
|
|
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] => SELECT `bank_accounts`.*
|
|
FROM (`bank_accounts`)
|
|
WHERE `bank_accounts`.`id` = '1'
|
|
ORDER BY `bank_accounts`.`id` ASC
|
|
LIMIT 0, 1
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] =>
|
|
[update] =>
|
|
[delete] =>
|
|
)
|
|
|
|
)
|
|
, upload/01-2017 1.csv, csv, 1 )</pre></li>
|
|
<li><strong>application/controllers/import.php [174]:</strong><pre>Import_Controller->import_fio( 1, upload/01-2017 1.csv, 1 )</pre></li>
|
|
<li><strong>system/core/Kohana.php [350]:</strong><pre>Import_Controller->upload_bank_file( 1 )</pre></li>
|
|
<li><pre>Kohana::instance( )</pre></li>
|
|
<li><strong>system/core/Event.php [217]:</strong><pre>call_user_func( Array
|
|
(
|
|
[0] => Kohana
|
|
[1] => instance
|
|
)
|
|
)</pre></li>
|
|
<li><strong>system/core/Bootstrap.php [55]:</strong><pre>Event::run( system.execute )</pre></li>
|
|
<li><strong>index.php [112]:</strong><pre>require( system/core/Bootstrap.php )</pre></li></ul></div></body></html>
|