|
<html><body><h1>Chyba nahlasena z: . import/upload_bank_file/1 (file: 69, line: 69)</h1><p>FreenetIS verze: 1.1.18</p><p>PHP verze: 5.4.45-0+deb7u4</p><p>Nahlasil: Milos Machek</p><p>Popis: Snaha o nacteni vypisu Fio banky ve formatu csv<br />
|
|
<br />
|
|
prvni radek vypisu je: <br />
|
|
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"</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.08.2016";"10813415524";"12201884576";"0558";"Fio banka, a.s.";"Kolarova, Stepanka";"290";"CZK";"2900177556";"2010";"";"";"Platba prevodem uvnitr banky";"";"69";"290";"CZK";""
|
|
"01.08.2016";"10813707597";"12204532558";"";"MONETA Money Bank, a.s.";" HERMANKOVA MARIE";"150";"CZK";"219169919";"0600";"";"";"Bezhotovostni prijem";" HERMANKOVA MARIE";"71";"150";"CZK";"internet"
|
|
"01.08.2016";"10813874966";"12204638319";"4712";"Ceska sporitelna, a.s.";"Radova Andrea";"150";"CZK";"951600183";"0800";"";"";"Bezhotovostni prijem";"Radova Andrea";"62";"150";"CZK";""
|
|
"01.08.2016";"10813910234";"12204661357";"0138";"Ceska sporitelna, a.s.";"Beran Tomas";"290";"CZK";"1658910013";"0800";"";"";"Bezhotovostni prijem";"Beran Tomas";"31";"290";"CZK";""
|
|
"02.08.2016";"10815154379";"12207438286";"0000";"CSOB, a.s.";"NOVOTNA HANA";"290";"CZK";"110470134";"0300";"";"";"Bezhotovostni prijem";"NOVOTNA HANA";"48";"290";"CZK";""
|
|
"03.08.2016";"10815739110";"12209936976";"4712";"CSOB, a.s.";"KOSLIK VACLAV";"290";"CZK";"128227298";"0300";"";"";"Bezhotovostni prijem";"KOSLIK VACLAV";"45";"290";"CZK";""
|
|
"03.08.2016";"10815811114";"12210194163";"4712";"MONETA Money Bank, a.s.";" HAVLICEK LIBOR";"290";"CZK";"1379911574";"0600";"";"";"Bezhotovostni prijem";" HAVLICEK LIBOR";"52";"290";"CZK";""
|
|
"03.08.2016";"10815811115";"12210194164";"";"MONETA Money Bank, a.s.";" RADOMIR RIMAL";"290";"CZK";"163042897";"0600";"";"";"Bezhotovostni prijem";" RADOMIR RIMAL";"32";"290";"CZK";""
|
|
"04.08.2016";"10816137764";"12211686639";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"300";"CZK";"160987123";"0300";"";"";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"85";"300";"CZK";" posta 128203 02.08.2016 c 6031M 1 CHA E L ABARTOSOVA"
|
|
"04.08.2016";"10816155962";"12211747939";"4712";"CSOB, a.s.";"MACHKOVA RADKA";"300";"CZK";"241717504";"0300";"";"";"Bezhotovostni prijem";"MACHKOVA RADKA";"10";"300";"CZK";"clensky prispevek"
|
|
"05.08.2016";"10816670984";"12213937704";"";"Ceska sporitelna, a.s.";"Nemeckova Vera";"290";"CZK";"1112616023";"0800";"";"";"Bezhotovostni prijem";"Nemeckova Vera";"16";"290";"CZK";""
|
|
"05.08.2016";"10816672617";"12213945643";"";"Ceska sporitelna, a.s.";"Novotny Pavel";"300";"CZK";"2244540133";"0800";"";"";"Bezhotovostni prijem";"Novotny Pavel";"61";"300";"CZK";""
|
|
"05.08.2016";"10816674202";"12213952713";"";"Ceska sporitelna, a.s.";"Kuncova Ruzena";"290";"CZK";"734867113";"0800";"";"";"Bezhotovostni prijem";"Kuncova Ruzena";"68";"290";"CZK";""
|
|
"05.08.2016";"10816677964";"12213970952";"4712";"MONETA Money Bank, a.s.";"CHYTIL JOSEF";"300";"CZK";"150038936";"0600";"";"";"Bezhotovostni prijem";"CHYTIL JOSEF";"26";"300";"CZK";""
|
|
"05.08.2016";"10816677965";"12213970953";"";"MONETA Money Bank, a.s.";" LIBALOVA JITKA";"300";"CZK";"215195423";"0600";"";"4712";"Bezhotovostni prijem";" LIBALOVA JITKA";"77";"300";"CZK";""
|
|
"06.08.2016";"10816976379";"12215516168";"0558";"Fio banka, a.s.";"Vokal, Petr";"150";"CZK";"2300404559";"2010";"";"4712";"Platba prevodem uvnitr banky";"";"39";"150";"CZK";""
|
|
"07.08.2016";"10817259878";"12216599986";"0308";"UniCredit Bank Czech Republic and Slovakia, a.s.";"";"-65340";"CZK";"2700027000";"2700";"Pavezka, Ales";"";"Bezhotovostni platba";"JON";"10109731";"65340";"CZK";""
|
|
"08.08.2016";"10817312354";"12216810173";"4712";"CSOB, a.s.";"NEMEC JAN";"290";"CZK";"241081825";"0300";"";"";"Bezhotovostni prijem";"NEMEC JAN";"36";"290";"CZK";"internet"
|
|
"08.08.2016";"10817343249";"12216927357";"4712";"Fio banka, a.s.";"Lonsky, Vaclav";"290";"CZK";"2800218699";"2010";"";"4712";"Platba prevodem uvnitr banky";"venlon";"70";"290";"CZK";"venlon"
|
|
"08.08.2016";"10817369530";"12217039548";"0000";"Komercni banka a.s.";"ZELINKA OLDRICH";"300";"CZK";"51-7254650267";"0100";"";"0";"Bezhotovostni prijem";"ZELINKA OLDRICH";"41";"300";"CZK";""
|
|
"08.08.2016";"10817369531";"12217039549";"0000";"Komercni banka a.s.";"KOSINA RUDOLF";"290";"CZK";"51-7255030297";"0100";"";"0";"Bezhotovostni prijem";"KOSINA RUDOLF";"18";"290";"CZK";""
|
|
"08.08.2016";"10817407201";"12217176797";"4721";"Ceska sporitelna, a.s.";"Dedkova Ivana";"290";"CZK";"486821043";"0800";"";"";"Bezhotovostni prijem";"Dedkova Ivana";"13";"290";"CZK";""
|
|
"08.08.2016";"10817411850";"12217195966";"4712";"MONETA Money Bank, a.s.";" RADONOVA JIRINA";"290";"CZK";"1273519574";"0600";"";"";"Bezhotovostni prijem";" RADONOVA JIRINA";"14";"290";"CZK";""
|
|
"09.08.2016";"10817732852";"12218808449";"0558";"CSOB, a.s.";"HULKA VACLAV";"900";"CZK";"266817077";"0300";"";"";"Bezhotovostni prijem";"HULKA VACLAV";"83";"900";"CZK";"201468"
|
|
"09.08.2016";"10817735703";"12218820385";"4712";"CSOB, a.s.";"PATACIK MIROSLAV";"290";"CZK";"195951294";"0300";"";"";"Bezhotovostni prijem";"PATACIK MIROSLAV";"73";"290";"CZK";""
|
|
"09.08.2016";"10817735724";"12218820501";"0000";"CSOB, a.s.";"HALTUCHOVA PAVLA";"300";"CZK";"196839376";"0300";"";"";"Bezhotovostni prijem";"HALTUCHOVA PAVLA";"38";"300";"CZK";""
|
|
"10.08.2016";"10818326320";"12221328592";"0000";"CSOB, a.s.";"SYKOROVA JANA";"290";"CZK";"134593040";"0300";"";"";"Bezhotovostni prijem";"SYKOROVA JANA";"1027";"290";"CZK";""
|
|
"10.08.2016";"10818437321";"12221785392";"4712";"Komercni banka a.s.";"PELCOVA DANIELA";"290";"CZK";"9257200287";"0100";"";"0";"Bezhotovostni prijem";"PELCOVA DANIELA";"76";"290";"CZK";""
|
|
"10.08.2016";"10818452485";"12221855184";"";"Ceska sporitelna, a.s.";"HRUBA ALENA";"150";"CZK";"279249013";"0800";"";"";"Bezhotovostni prijem";"HRUBA ALENA";"25";"150";"CZK";""
|
|
"10.08.2016";"10818495325";"12221991167";"4712";"Ceska sporitelna, a.s.";"LOUNKOVA JANA";"290";"CZK";"788937033";"0800";"";"";"Bezhotovostni prijem";"LOUNKOVA JANA";"12";"290";"CZK";""
|
|
"10.08.2016";"10818498026";"12222002382";"4718";"Ceska sporitelna, a.s.";"Novak Milan";"290";"CZK";"1092252153";"0800";"";"";"Bezhotovostni prijem";"Novak Milan";"67";"290";"CZK";""
|
|
"10.08.2016";"10818498815";"12222005726";"4712";"Ceska sporitelna, a.s.";"Kougl Michaela";"900";"CZK";"1200747023";"0800";"";"";"Bezhotovostni prijem";"Kougl Michaela";"17";"900";"CZK";""
|
|
"10.08.2016";"10818499559";"12222008810";"";"Ceska sporitelna, a.s.";"Bulickova Marie";"290";"CZK";"1323252063";"0800";"";"";"Bezhotovostni prijem";"Bulickova Marie";"58";"290";"CZK";""
|
|
"10.08.2016";"10818501189";"12222015572";"";"Ceska sporitelna, a.s.";"Kohout Pavel";"290";"CZK";"1663893123";"0800";"";"";"Bezhotovostni prijem";"Kohout Pavel";"49";"290";"CZK";""
|
|
"10.08.2016";"10818543110";"12222241038";"4712";"Air Bank a.s.";"Irena Radonova";"300";"CZK";"1428003012";"3030";"";"";"Bezhotovostni prijem";"Irena Radonova";"15";"300";"CZK";""
|
|
"11.08.2016";"10818930446";"12223976644";"4712";"CSOB, a.s.";"CISAR LUBOS";"290";"CZK";"100886080";"0300";"";"";"Bezhotovostni prijem";"CISAR LUBOS";"78";"290";"CZK";""
|
|
"11.08.2016";"10818974162";"12224178483";"4712";"MONETA Money Bank, a.s.";"AGD SENICE A.S.";"300";"CZK";"404406584";"0600";"";"";"Bezhotovostni prijem";"AGD SENICE A.S.";"28";"300";"CZK";""
|
|
"11.08.2016";"10819026912";"12224338737";"0308";"Komercni banka a.s.";"JANEBOVA SONA";"150";"CZK";"9252600257";"0100";"";"4712";"Bezhotovostni prijem";"JANEBOVA SONA";"33";"150";"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.49
|
|
[client_version] => 50549
|
|
[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.50-0+deb7u2
|
|
[server_version] => 50550
|
|
[stat] => Uptime: 8236 Threads: 1 Questions: 630589 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.564
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 125000
|
|
[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.49
|
|
[client_version] => 50549
|
|
[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.50-0+deb7u2
|
|
[server_version] => 50550
|
|
[stat] => Uptime: 8236 Threads: 1 Questions: 630590 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.565
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 125000
|
|
[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.08.2016";"10813415524";"12201884576";"0558";"Fio banka, a.s.";"Kolarova, Stepanka";"290";"CZK";"2900177556";"2010";"";"";"Platba prevodem uvnitr banky";"";"69";"290";"CZK";""
|
|
"01.08.2016";"10813707597";"12204532558";"";"MONETA Money Bank, a.s.";" HERMANKOVA MARIE";"150";"CZK";"219169919";"0600";"";"";"Bezhotovostni prijem";" HERMANKOVA MARIE";"71";"150";"CZK";"internet"
|
|
"01.08.2016";"10813874966";"12204638319";"4712";"Ceska sporitelna, a.s.";"Radova Andrea";"150";"CZK";"951600183";"0800";"";"";"Bezhotovostni prijem";"Radova Andrea";"62";"150";"CZK";""
|
|
"01.08.2016";"10813910234";"12204661357";"0138";"Ceska sporitelna, a.s.";"Beran Tomas";"290";"CZK";"1658910013";"0800";"";"";"Bezhotovostni prijem";"Beran Tomas";"31";"290";"CZK";""
|
|
"02.08.2016";"10815154379";"12207438286";"0000";"CSOB, a.s.";"NOVOTNA HANA";"290";"CZK";"110470134";"0300";"";"";"Bezhotovostni prijem";"NOVOTNA HANA";"48";"290";"CZK";""
|
|
"03.08.2016";"10815739110";"12209936976";"4712";"CSOB, a.s.";"KOSLIK VACLAV";"290";"CZK";"128227298";"0300";"";"";"Bezhotovostni prijem";"KOSLIK VACLAV";"45";"290";"CZK";""
|
|
"03.08.2016";"10815811114";"12210194163";"4712";"MONETA Money Bank, a.s.";" HAVLICEK LIBOR";"290";"CZK";"1379911574";"0600";"";"";"Bezhotovostni prijem";" HAVLICEK LIBOR";"52";"290";"CZK";""
|
|
"03.08.2016";"10815811115";"12210194164";"";"MONETA Money Bank, a.s.";" RADOMIR RIMAL";"290";"CZK";"163042897";"0600";"";"";"Bezhotovostni prijem";" RADOMIR RIMAL";"32";"290";"CZK";""
|
|
"04.08.2016";"10816137764";"12211686639";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"300";"CZK";"160987123";"0300";"";"";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"85";"300";"CZK";" posta 128203 02.08.2016 c 6031M 1 CHA E L ABARTOSOVA"
|
|
"04.08.2016";"10816155962";"12211747939";"4712";"CSOB, a.s.";"MACHKOVA RADKA";"300";"CZK";"241717504";"0300";"";"";"Bezhotovostni prijem";"MACHKOVA RADKA";"10";"300";"CZK";"clensky prispevek"
|
|
"05.08.2016";"10816670984";"12213937704";"";"Ceska sporitelna, a.s.";"Nemeckova Vera";"290";"CZK";"1112616023";"0800";"";"";"Bezhotovostni prijem";"Nemeckova Vera";"16";"290";"CZK";""
|
|
"05.08.2016";"10816672617";"12213945643";"";"Ceska sporitelna, a.s.";"Novotny Pavel";"300";"CZK";"2244540133";"0800";"";"";"Bezhotovostni prijem";"Novotny Pavel";"61";"300";"CZK";""
|
|
"05.08.2016";"10816674202";"12213952713";"";"Ceska sporitelna, a.s.";"Kuncova Ruzena";"290";"CZK";"734867113";"0800";"";"";"Bezhotovostni prijem";"Kuncova Ruzena";"68";"290";"CZK";""
|
|
"05.08.2016";"10816677964";"12213970952";"4712";"MONETA Money Bank, a.s.";"CHYTIL JOSEF";"300";"CZK";"150038936";"0600";"";"";"Bezhotovostni prijem";"CHYTIL JOSEF";"26";"300";"CZK";""
|
|
"05.08.2016";"10816677965";"12213970953";"";"MONETA Money Bank, a.s.";" LIBALOVA JITKA";"300";"CZK";"215195423";"0600";"";"4712";"Bezhotovostni prijem";" LIBALOVA JITKA";"77";"300";"CZK";""
|
|
"06.08.2016";"10816976379";"12215516168";"0558";"Fio banka, a.s.";"Vokal, Petr";"150";"CZK";"2300404559";"2010";"";"4712";"Platba prevodem uvnitr banky";"";"39";"150";"CZK";""
|
|
"07.08.2016";"10817259878";"12216599986";"0308";"UniCredit Bank Czech Republic and Slovakia, a.s.";"";"-65340";"CZK";"2700027000";"2700";"Pavezka, Ales";"";"Bezhotovostni platba";"JON";"10109731";"65340";"CZK";""
|
|
"08.08.2016";"10817312354";"12216810173";"4712";"CSOB, a.s.";"NEMEC JAN";"290";"CZK";"241081825";"0300";"";"";"Bezhotovostni prijem";"NEMEC JAN";"36";"290";"CZK";"internet"
|
|
"08.08.2016";"10817343249";"12216927357";"4712";"Fio banka, a.s.";"Lonsky, Vaclav";"290";"CZK";"2800218699";"2010";"";"4712";"Platba prevodem uvnitr banky";"venlon";"70";"290";"CZK";"venlon"
|
|
"08.08.2016";"10817369530";"12217039548";"0000";"Komercni banka a.s.";"ZELINKA OLDRICH";"300";"CZK";"51-7254650267";"0100";"";"0";"Bezhotovostni prijem";"ZELINKA OLDRICH";"41";"300";"CZK";""
|
|
"08.08.2016";"10817369531";"12217039549";"0000";"Komercni banka a.s.";"KOSINA RUDOLF";"290";"CZK";"51-7255030297";"0100";"";"0";"Bezhotovostni prijem";"KOSINA RUDOLF";"18";"290";"CZK";""
|
|
"08.08.2016";"10817407201";"12217176797";"4721";"Ceska sporitelna, a.s.";"Dedkova Ivana";"290";"CZK";"486821043";"0800";"";"";"Bezhotovostni prijem";"Dedkova Ivana";"13";"290";"CZK";""
|
|
"08.08.2016";"10817411850";"12217195966";"4712";"MONETA Money Bank, a.s.";" RADONOVA JIRINA";"290";"CZK";"1273519574";"0600";"";"";"Bezhotovostni prijem";" RADONOVA JIRINA";"14";"290";"CZK";""
|
|
"09.08.2016";"10817732852";"12218808449";"0558";"CSOB, a.s.";"HULKA VACLAV";"900";"CZK";"266817077";"0300";"";"";"Bezhotovostni prijem";"HULKA VACLAV";"83";"900";"CZK";"201468"
|
|
"09.08.2016";"10817735703";"12218820385";"4712";"CSOB, a.s.";"PATACIK MIROSLAV";"290";"CZK";"195951294";"0300";"";"";"Bezhotovostni prijem";"PATACIK MIROSLAV";"73";"290";"CZK";""
|
|
"09.08.2016";"10817735724";"12218820501";"0000";"CSOB, a.s.";"HALTUCHOVA PAVLA";"300";"CZK";"196839376";"0300";"";"";"Bezhotovostni prijem";"HALTUCHOVA PAVLA";"38";"300";"CZK";""
|
|
"10.08.2016";"10818326320";"12221328592";"0000";"CSOB, a.s.";"SYKOROVA JANA";"290";"CZK";"134593040";"0300";"";"";"Bezhotovostni prijem";"SYKOROVA JANA";"1027";"290";"CZK";""
|
|
"10.08.2016";"10818437321";"12221785392";"4712";"Komercni banka a.s.";"PELCOVA DANIELA";"290";"CZK";"9257200287";"0100";"";"0";"Bezhotovostni prijem";"PELCOVA DANIELA";"76";"290";"CZK";""
|
|
"10.08.2016";"10818452485";"12221855184";"";"Ceska sporitelna, a.s.";"HRUBA ALENA";"150";"CZK";"279249013";"0800";"";"";"Bezhotovostni prijem";"HRUBA ALENA";"25";"150";"CZK";""
|
|
"10.08.2016";"10818495325";"12221991167";"4712";"Ceska sporitelna, a.s.";"LOUNKOVA JANA";"290";"CZK";"788937033";"0800";"";"";"Bezhotovostni prijem";"LOUNKOVA JANA";"12";"290";"CZK";""
|
|
"10.08.2016";"10818498026";"12222002382";"4718";"Ceska sporitelna, a.s.";"Novak Milan";"290";"CZK";"1092252153";"0800";"";"";"Bezhotovostni prijem";"Novak Milan";"67";"290";"CZK";""
|
|
"10.08.2016";"10818498815";"12222005726";"4712";"Ceska sporitelna, a.s.";"Kougl Michaela";"900";"CZK";"1200747023";"0800";"";"";"Bezhotovostni prijem";"Kougl Michaela";"17";"900";"CZK";""
|
|
"10.08.2016";"10818499559";"12222008810";"";"Ceska sporitelna, a.s.";"Bulickova Marie";"290";"CZK";"1323252063";"0800";"";"";"Bezhotovostni prijem";"Bulickova Marie";"58";"290";"CZK";""
|
|
"10.08.2016";"10818501189";"12222015572";"";"Ceska sporitelna, a.s.";"Kohout Pavel";"290";"CZK";"1663893123";"0800";"";"";"Bezhotovostni prijem";"Kohout Pavel";"49";"290";"CZK";""
|
|
"10.08.2016";"10818543110";"12222241038";"4712";"Air Bank a.s.";"Irena Radonova";"300";"CZK";"1428003012";"3030";"";"";"Bezhotovostni prijem";"Irena Radonova";"15";"300";"CZK";""
|
|
"11.08.2016";"10818930446";"12223976644";"4712";"CSOB, a.s.";"CISAR LUBOS";"290";"CZK";"100886080";"0300";"";"";"Bezhotovostni prijem";"CISAR LUBOS";"78";"290";"CZK";""
|
|
"11.08.2016";"10818974162";"12224178483";"4712";"MONETA Money Bank, a.s.";"AGD SENICE A.S.";"300";"CZK";"404406584";"0600";"";"";"Bezhotovostni prijem";"AGD SENICE A.S.";"28";"300";"CZK";""
|
|
"11.08.2016";"10819026912";"12224338737";"0308";"Komercni banka a.s.";"JANEBOVA SONA";"150";"CZK";"9252600257";"0100";"";"4712";"Bezhotovostni prijem";"JANEBOVA SONA";"33";"150";"CZK";""
|
|
, upload/Pohytestsrpen.csv, csv )</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.49
|
|
[client_version] => 50549
|
|
[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.50-0+deb7u2
|
|
[server_version] => 50550
|
|
[stat] => Uptime: 8236 Threads: 1 Questions: 630591 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.565
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 125000
|
|
[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.49
|
|
[client_version] => 50549
|
|
[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.50-0+deb7u2
|
|
[server_version] => 50550
|
|
[stat] => Uptime: 8236 Threads: 1 Questions: 630592 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.565
|
|
[sqlstate] => 00000
|
|
[protocol_version] => 10
|
|
[thread_id] => 125000
|
|
[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/Pohytestsrpen.csv, csv )</pre></li>
|
|
<li><strong>application/controllers/import.php [174]:</strong><pre>Import_Controller->import_fio( 1, upload/Pohytestsrpen.csv )</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>
|