aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat
-rw-r--r--justice_main.py5
-rw-r--r--templates/extract-actual.html258
-rw-r--r--templates/extract.html463
-rw-r--r--todolist.html3
4 files changed, 231 insertions, 498 deletions
diff --git a/justice_main.py b/justice_main.py
index 7ce7103..2558bbf 100644
--- a/justice_main.py
+++ b/justice_main.py
@@ -189,6 +189,7 @@ def find_spolecnik(c, ICO, elem2, conn, primary_sql_key, element):
spol_ico = str(get_prop(elem, "osoba/ico"))
regCislo = str(get_prop(elem, "osoba/regCislo"))
text_spolecnik = str(get_prop(elem, "hodnotaUdaje/textZaOsobu/value"))
+ # TODO Fix - make reference to type of person - some foreign persons have no ico or regCo, so they are assigned a number for a natural person
if spol_ico == "0" and regCislo == "0":
# I probably do not need the primary sql key
spolecnik_fo_id = find_fyzicka_osoba(c, ICO, elem, conn, primary_sql_key, element)
@@ -1103,7 +1104,7 @@ def delete_archive(file):
purge_DB()
-# parse_to_DB("data/as-full-ceske_budejovice-2021.xml")
+parse_to_DB("data/as-full-plzen-2021.xml")
# parse_to_DB("data/sro-full-ceske_budejovice-2021.xml")
# parse_to_DB("sro-actual-praha-2020.xml")
@@ -1112,6 +1113,6 @@ def do_both():
general_update("down")
general_update("db_update")
-do_both()
+# do_both()
# cProfile.run('general_update("db_update")') \ No newline at end of file
diff --git a/templates/extract-actual.html b/templates/extract-actual.html
index 0d0ee90..0539de9 100644
--- a/templates/extract-actual.html
+++ b/templates/extract-actual.html
@@ -11,77 +11,72 @@
{% for i in range (row.predmet_podnikani|length) %}
{% if row.predmet_podnikani[i].vymaz_datum == 0 %}
{% set predmety_podnikani_notes = predmety_podnikani_notes.append(row.predmet_podnikani[i].predmet_podnikani.predmet_podnikani) %}
- {% endif %}
+ {% endif %}
{% endfor %}
{% set predmety_cinnosti_notes = [] %}
{% for i in range (row.predmet_cinnosti|length) %}
{% if row.predmet_cinnosti[i].vymaz_datum == 0 %}
{% set predmety_cinnosti_notes = predmety_cinnosti_notes.append(row.predmet_cinnosti[i].predmet_cinnosti.predmet_cinnosti) %}
- {% endif %}
+ {% endif %}
{% endfor %}
{% set zakladni_kapital_notes = [] %}
{% for i in range (row.zakladni_kapital|length) %}
{% if row.zakladni_kapital[i].vymaz_datum == 0 %}
{% set zakladni_kapital_notes = zakladni_kapital_notes.append(row.zakladni_kapital[i]) %}
- {% endif %}
+ {% endif %}
+{% endfor %}
+
+{% set sole_shareholder_notes = [] %}
+{% for i in range (row.jediny_akcionar|length) %}
+ {% if row.jediny_akcionar[i].vymaz_datum == 0 %}
+ {% set sole_shareholder_notes = sole_shareholder_notes.append(row.jediny_akcionar[i]) %}
+ {% endif %}
+{% endfor %}
+
+{% set shares_notes = [] %}
+{% for i in range (row.akcie|length) %}
+ {% if row.akcie[i].vymaz_datum == 0 %}
+ {% set shares_notes = shares_notes.append(row.akcie[i]) %}
+ {% endif %}
+{% endfor %}
+
+{% set prokurist_notes = [] %}
+{% for i in range (row.prokurista|length) %}
+ {% if row.prokurista[i].vymaz_datum == 0 %}
+ {% set prokurist_notes = prokurist_notes.append(row.prokurista[i]) %}
+ {% endif %}
+{% endfor %}
+
+{% set prokurist_common_text_notes = [] %}
+{% for i in range (row.prokura_common_text|length) %}
+ {% if row.prokura_common_text[i].vymaz_datum == 0 %}
+ {% set prokurist_common_text_notes = prokurist_common_text_notes.append(row.prokura_common_text[i]) %}
+ {% endif %}
{% endfor %}
{% set ostatni_skutecnosti_notes = [] %}
{% for i in range (row.ostatni_skutecnosti|length) %}
{% if row.ostatni_skutecnosti[i].vymaz_datum == 0 %}
{% set ostatni_skutecnosti_notes = ostatni_skutecnosti_notes.append(row.ostatni_skutecnosti[i]) %}
- {% endif %}
+ {% endif %}
{% endfor %}
{% set insolvency_notes = [] %}
{% for i in range (row.insolvence|length) %}
{% if row.insolvence[i].vymaz_datum == 0 %}
{% set insolvency_notes = insolvency_notes.append(row.insolvence[i].insolvency_event) %}
- {% endif %}
+ {% endif %}
{% endfor %}
{% set konkurz_notes = [] %}
{% for i in range (row.konkurz|length) %}
{% if row.konkurz[i].vymaz_datum == 0 %}
{% set konkurz_notes = konkurz_notes.append(row.konkurz[i].konkurz_event) %}
- {% endif %}
+ {% endif %}
{% endfor %}
-{% set zapis_split = row.zapis.split("-") %}
-{% if zapis_split[1] == "01" %}
- {% set mesic = "ledna" %}
-{% elif zapis_split[1] == "02" %}
- {% set mesic = "února" %}
-{% elif zapis_split[1] == "03" %}
- {% set mesic = "března" %}
-{% elif zapis_split[1] == "04" %}
- {% set mesic = "dubna" %}
-{% elif zapis_split[1] == "05" %}
- {% set mesic = "května" %}
-{% elif zapis_split[1] == "06" %}
- {% set mesic = "června" %}
-{% elif zapis_split[1] == "07" %}
- {% set mesic = "července" %}
-{% elif zapis_split[1] == "08" %}
- {% set mesic = "srpna" %}
-{% elif zapis_split[1] == "09" %}
- {% set mesic = "září" %}
-{% elif zapis_split[1] == "10" %}
- {% set mesic = "října" %}
-{% elif zapis_split[1] == "11" %}
- {% set mesic = "listopadu" %}
-{% elif zapis_split[1] == "12" %}
- {% set mesic = "prosince" %}
-{% endif %}
-
-{% if zapis_split[2][0] == "0" %}
- {% set den = zapis_split[2][1] %}
-{% else %}
- {% set den = zapis_split[2] %}
-{% endif %}
-
{% if row.soud == "MSPH" %}
{% set soud = "Městského soudu v Praze" %}
{% elif row.soud == "KSCB" %}
@@ -122,13 +117,17 @@
<h2>{{ row.nazev }}, {{ row.soudni_zapis[i].oddil }} {{ row.soudni_zapis[i].vlozka }} vedená u {{ row.soudni_zapis[i].soud }}</h2>
{% endif %}
{% endfor %}
-<p><a href="/">Zpět na vyhledání.</a></p>
+<p><a href="/">Zpět na vyhledání</a></p>
<table class= "table" style="width: 100%">
+ <!-- Display registration date -->
<tr>
<td style="width:15%">Datum vzniku a zápisu:</td>
- <td style="width:85%">{{den}}. {{mesic}} {{zapis_split[0]}}</td>
+ <td style="width:85%">{{row.zapis}}</td>
</tr>
+ <!-- END Display registration date -->
+
+ <!-- Display court registration -->
<tr>
<td>Spisová značka:</td>
{% for i in range (row.soudni_zapis|length) %}
@@ -137,6 +136,9 @@
{% endif %}
{% endfor %}
</tr>
+ <!-- END Display court registrations -->
+
+ <!-- Display business names -->
<tr>
<td>Obchodní firma:</td>
{% for i in range (row.obchodni_firma|length) %}
@@ -145,19 +147,38 @@
{% endif %}
{% endfor %}
</tr>
+ <!-- END Display business names -->
+
+ <!-- Display registered office -->
<tr>
- <td>Sídlo:</td>
- <td>{{ row.sidlo }}</td>
+ <td>Sídlo:{{ row.sidlo_text[0]}}</td>
+ {% for i in range (row.sidlo_text|length) %}
+ {% if row.sidlo_text[i].vymaz_datum == 0 %}
+ <td>{{ row.sidlo_text[i].sidlo_text.adresa_text }}</td>
+ {% endif %}
+ {% endfor %}
</tr>
+ <!-- END Display registered office -->
+
+ <!-- Display ICO -->
<tr>
<td>Identifikační číslo:</td>
<td>{{ ico_buffer|join("") }}{{ row.ico }}</td>
</tr>
+ <!-- END Display ICO -->
+
+ <!-- Display legal form -->
<tr>
<td>Právní forma:</td>
- <td>{{ row.pravni_forma[0].pravni_forma }}</td>
+ {% for i in range (row.pravni_forma_text|length) %}
+ {% if row.pravni_forma_text[i].vymaz_datum == 0 %}
+ <td>{{ row.pravni_forma_text[i].pravni_forma_text.pravni_forma }}</td>
+ {% endif %}
+ {% endfor %}
</tr>
+ <!-- END Display legal form -->
+ <!-- Display registered capital -->
{% if zakladni_kapital_notes|length > 0 %}
<tr>
{% if zakladni_kapital_notes[0].vklad_typ == "KORUNY" %}
@@ -189,79 +210,150 @@
<td>{{ underlne_style_open|safe }} {{ vklad_typ_description }} {{ vklad_typ_symbol }} {% if splaceni_typ_description != "0" %} <br> Splaceno: {{ splaceni_typ_description }} {{ splaceni_typ_symbol }} {% endif %} {{ underlne_style_close|safe }}</td>
</tr>
{% endif %}
-
+ <!-- END Display registered capital -->
+
+ <!-- Display area of business -->
{% if predmety_podnikani_notes|length > 0 %}
+ {% for i in range (predmety_podnikani_notes|length) %}
<tr>
- <td>Předmět podnikání:</td>
- <td>{{ predmety_podnikani_notes[0] }}</td>
- </tr>
- {% for i in range (1, predmety_podnikani_notes|length) %}
- <tr>
- <td></td>
+ <td>{% if i == 0%}Předmět podnikání:{% endif %}</td>
<td>{{ predmety_podnikani_notes[i] }}</td>
</tr>
{% endfor %}
{% endif %}
+ <!-- END Display area of business -->
+ <!-- Display areas of activities -->
{% if predmety_cinnosti_notes|length > 0 %}
+ {% for i in range (predmety_cinnosti_notes|length) %}
<tr>
- <td>Předmět činnosti:</td>
- <td>{{ predmety_cinnosti_notes[0] }}</td>
- </tr>
- {% for i in range (1, predmety_cinnosti_notes|length) %}
- <tr>
- <td></td>
+ <td>{% if i == 0%}Předmět činnosti:{% endif %}</td>
<td>{{ predmety_cinnosti_notes[i] }}</td>
</tr>
{% endfor %}
{% endif %}
+ <!-- END Display areas of activities -->
+
+ <!-- Display statutory bodies -->
+ <!-- END Display statutory bodies -->
- {% if insolvency_notes|length > 0 %}
+ <!-- Display supervisory board-->
+ <!-- END Display supervisory board-->
+
+ <!-- Display prokurist -->
+ {% if prokurist_notes|length > 0 %}
+ {% for i in range (prokurist_notes|length) %}
+ <tr>
+ <td>{% if i == 0%}Prokura:{% endif %}</td>
+ <td>{{ prokurist_notes[i].jmeno.jmeno }} {{ prokurist_notes[i].jmeno.prijmeni }}{% if prokurist_notes[i].jmeno.datum_naroz != "" %}, nar. {{ prokurist_notes[i].jmeno.datum_naroz }}{% endif %}<br>
+ {{ prokurist_notes[i].adresa.adresa_text }}{% if prokurist_notes[i].text_prokurista != "0" %}<br>{{ prokurist_notes[i].text_prokurista }}{% endif %}</td>
+ </tr>
+ {% endfor %}
+ {% if prokurist_common_text_notes|length > 0 %}
<tr>
- <td>Údaje o insolvencích:</td>
- <td>{{ insolvency_notes[0] }}</td>
<td></td>
- </tr>
- {% for i in range (1, insolvency_notes|length) %}
+ <td>{{ prokurist_common_text_notes.prokura_text }}</td>
+ </tr>
+ {% endif %}
+ {% endif %}
+ <!-- END Display prokurist -->
+
+ <!-- Display sole shareholder -->
+ {% if sole_shareholder_notes|length > 0 %}
+ {% for i in range (sole_shareholder_notes|length) %}
<tr>
- <td></td>
+ <td>{% if i == 0%}Jediný akcionář:{% endif %}</td>
+ <td>{% if sole_shareholder_notes[i].akcionar_po_id == None %} {{ sole_shareholder_notes[i].jmeno.jmeno }} {{ sole_shareholder_notes[i].jmeno.prijmeni }}{% if sole_shareholder_notes[i].jmeno.datum_naroz != "" %}, nar. {{ sole_shareholder_notes[i].jmeno.datum_naroz }}{% endif %} {% endif %}
+ {% if sole_shareholder_notes[i].akcionar_fo_id == None %} {{ sole_shareholder_notes[i].oznaceni_po.nazev }}{% if sole_shareholder_notes[i].oznaceni_po.reg_cislo != 0 %}, reg č. {{ sole_shareholder_notes[i].oznaceni_po.reg_cislo }}{% endif %}{% if sole_shareholder_notes[i].oznaceni_po.ico != 0 %}, IČ {{ sole_shareholder_notes[i].oznaceni_po.ico }}{% endif %} {% endif %}
+ <br>{{sole_shareholder_notes[i].adresa.adresa_text}}</td>
+ </tr>
+ {% endfor %}
+ {% endif %}
+ <!-- END Display sole shareholder -->
+
+ <!-- Display shareholders -->
+ <!-- END Display shareholders -->
+
+ <!-- Display shares -->
+ {% if shares_notes|length > 0 %}
+ {% for i in range (shares_notes|length) %}
+ <tr>
+ <td>{% if i == 0%}Akcie:{% endif %}</td>
+ {% if shares_notes[i].akcie_podoba == "LISTINNA" %}
+ {% set akcie_podoba_description = "v listinné podobě" %}
+ {% elif shares_notes[i].akcie_podoba == "ZAKNIHOVANA" %}
+ {% set akcie_podoba_description = "v zaknihované podobě" %}
+ {% elif shares_notes[i].akcie_podoba == "IMOBILIZOVANA" %}
+ {% set akcie_podoba_description = "v imobilizované podobě" %}
+ {% else %}
+ {% set akcie_podoba_description = "" %}
+ {% endif %}
+
+ {% if shares_notes[i].akcie_typ == "KMENOVE_NA_JMENO" %}
+ {% set akcie_typ_description = "kmenové akcie na jméno" %}
+ {% elif shares_notes[i].akcie_typ == "KMENOVE_NA_MAJITELE" %}
+ {% set akcie_typ_description = "kmenové akcie na majitele" %}
+ {% elif shares_notes[i].akcie_typ == "KUSOVE_NA_JMENO" %}
+ {% set akcie_typ_description = "kusové akcie" %}
+ {% elif shares_notes[i].akcie_typ == "NA_JMENO" %}
+ {% set akcie_typ_description = "akcie na jméno" %}
+ {% elif shares_notes[i].akcie_typ == "NA_MAJITELE" %}
+ {% set akcie_typ_description = "akcie na majitele" %}
+ {% elif shares_notes[i].akcie_typ == "PRIORITNI_NA_JMENO" %}
+ {% set akcie_typ_description = "prioritní akcie na jméno" %}
+ {% elif shares_notes[i].akcie_typ == "ZAMESTNANECKE_NA_JMENO" %}
+ {% set akcie_typ_description = "zaměstnanecké akcie na jméno" %}
+ {% elif shares_notes[i].akcie_typ == "ZVLASTNI_PRAVA" %}
+ {% set akcie_typ_description = "akcie se zvláštními právy" %}
+ {% else %}
+ {% set akcie_typ_description = "" %}
+ {% endif %}
+
+ {% if shares_notes[i].akcie_hodnota_typ == "KORUNY" %}
+ {% set akcie_hodnota_typ_symbol = "Kč" %}
+ {% elif shares_notes[i].akcie_hodnota_typ == "EURA" %}
+ {% set akcie_hodnota_typ_symbol = "euro" %}
+ {% else %}
+ {% set akcie_hodnota_typ_symbol = "" %}
+ {% endif %}
+ <td>{{ shares_notes[i].akcie_pocet }} ks {{ akcie_typ_description }} {{ akcie_podoba_description }} ve jmenovité hodnotě {{ shares_notes[i].akcie_hodnota_value }} {{ akcie_hodnota_typ_symbol }} {% if shares_notes[i].akcie_text != "0" %} <br> {{ shares_notes[i].akcie_text }} {% endif %}</td>
+ </tr>
+ {% endfor %}
+ {% endif %}
+ <!-- END Display shares -->
+
+ <!-- Insolvency Events -->
+ {% if insolvency_notes|length > 0 %}
+ {% for i in range (insolvency_notes|length) %}
+ <tr>
+ <td>{% if i == 0%}Údaje o insolvencích:{% endif %}</td>
<td>{{ insolvency_notes[i] }}</td>
- <td></td>
</tr>
{% endfor %}
{% endif %}
+ <!-- END Insolvency Events -->
+ <!-- Konkurz Events -->
{% if konkurz_notes|length > 0 %}
- <tr>
- <td>Údaje o konkurzech:</td>
- <td>{{ konkurz_notes[0] }}</td>
- <td></td>
- </tr>
- {% for i in range (1, konkurz_notes|length) %}
+ {% for i in range (konkurz_notes|length) %}
<tr>
- <td></td>
+ <td>{% if i == 0%}Údaje o konkurzech:{% endif %}</td>
<td>{{ konkurz_notes[i] }}</td>
- <td></td>
</tr>
{% endfor %}
{% endif %}
+ <!-- END Konkurz Events -->
-
-
- {% if ostatni_skutecnosti_notes|length > 0 %}
- <tr>
- <td>Ostatní skutečnosti:</td>
- <td>{{ ostatni_skutecnosti_notes[0].ostatni_skutecnost }}</td>
- <td></td>
- </tr>
- {% for i in range (1, ostatni_skutecnosti_notes|length) %}
+ <!-- Ostatni skutecnosti -->
+ {% if ostatni_skutecnosti_notes|length > 0 %}
+ {% for i in range (ostatni_skutecnosti_notes|length) %}
<tr>
- <td></td>
+ <td>{% if i == 0%}Ostatní skutečnosti:{% endif %}</td>
<td>{{ ostatni_skutecnosti_notes[i].ostatni_skutecnost }}</td>
- <td></td>
</tr>
{% endfor %}
{% endif %}
+ <!-- END Ostatni skutecnosti -->
</table>
diff --git a/templates/extract.html b/templates/extract.html
index 68e384e..65e700f 100644
--- a/templates/extract.html
+++ b/templates/extract.html
@@ -2,8 +2,6 @@
{% for row in results %}
-
-
<!-- DO I NEED THIS HERE? -->
{% if insolvency_notes|length > 0 %}
{% set table_style = "table table-danger" %}
@@ -33,14 +31,17 @@
{% endif %}
{% endfor %}
-<p><a href="/">Zpět na vyhledání.</a></p>
+<p><a href="/">Zpět na vyhledání</a></p>
<table class= "table" style="width: 100%">
+ <!-- Display registration date -->
<tr>
<td style="width:15%">Datum vzniku a zápisu:</td>
<td style="width:60%">{{row.zapis}}</td>
<td style="width:25%"></td>
</tr>
+ <!-- END Display registration date -->
+
<!-- Display court registration -->
{% if row.soudni_zapis|length > 0 %}
{% for i in range (row.soudni_zapis|length) %}
@@ -96,7 +97,6 @@
</tr>
{% endfor %}
{% endif %}
-
<!-- END Display registered office -->
<!-- Display ICO -->
@@ -212,121 +212,7 @@
<!-- Display statutory bodies -->
{% if row.statutarni_organ_text|length > 0 %}
- <tr>
- <td>{{ row.statutarni_organ_text[0].statutarni_organ_text.statutarni_organ_text }}:</td>
- {% if row.statutarni_organ_text[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].zapis_datum }} {% if row.statutarni_organ_text[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
-
- <!-- Insert board members -->
- {% if row.statutarni_organ_text[0].clenove|length > 0 %}
- <tr>
- <td style = padding-left:2em>{% if row.statutarni_organ_text[0].clenove[0].funkce != "0" %} {{ row.statutarni_organ_text[0].clenove[0].funkce }} {% endif %}</td>
- {% if row.statutarni_organ_text[0].clenove[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[0].clenove[0].jmeno.jmeno }} {{ row.statutarni_organ_text[0].clenove[0].jmeno.prijmeni }}{% if row.statutarni_organ_text[0].clenove[0].jmeno.datum_naroz != "" %}, nar. {{ row.statutarni_organ_text[0].clenove[0].jmeno.datum_naroz }} {% endif %} <br>
- {{ row.statutarni_organ_text[0].clenove[0].adresa.adresa_text }}
- {% if row.statutarni_organ_text[0].clenove[0].funkce_od != 0 %}<br>Den vzniku funkce: {{ row.statutarni_organ_text[0].clenove[0].funkce_od}}{% endif %}
- {% if row.statutarni_organ_text[0].clenove[0].funkce_do != 0 %}<br>Den zániku funkce: {{ row.statutarni_organ_text[0].clenove[0].funkce_do}}{% endif %}
- {% if row.statutarni_organ_text[0].clenove[0].clenstvi_od != 0 %}<br>Den vzniku členství: {{ row.statutarni_organ_text[0].clenove[0].clenstvi_od}}{% endif %}
- {% if row.statutarni_organ_text[0].clenove[0].clenstvi_do != 0 %}<br>Den zániku členství: {{ row.statutarni_organ_text[0].clenove[0].clenstvi_do}}{% endif %}
- {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].clenove[0].zapis_datum }} {% if row.statutarni_organ_text[0].clenove[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].clenove[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.statutarni_organ_text[0].clenove|length) %}
- <tr>
- <td style = padding-left:2em>{% if row.statutarni_organ_text[0].clenove[i].funkce != "0" %} {{ row.statutarni_organ_text[0].clenove[i].funkce }} {% endif %}</td>
- {% if row.statutarni_organ_text[0].clenove[i].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[0].clenove[i].jmeno.jmeno }} {{ row.statutarni_organ_text[0].clenove[i].jmeno.prijmeni }}{% if row.statutarni_organ_text[0].clenove[i].jmeno.datum_naroz != "" %}, nar. {{ row.statutarni_organ_text[0].clenove[i].jmeno.datum_naroz }}{% endif %} <br>
- {{ row.statutarni_organ_text[0].clenove[i].adresa.adresa_text }}
- {% if row.statutarni_organ_text[0].clenove[i].funkce_od != 0 %}<br>Den vzniku funkce: {{ row.statutarni_organ_text[0].clenove[i].funkce_od}}{% endif %}
- {% if row.statutarni_organ_text[0].clenove[i].funkce_do != 0 %}<br>Den zániku funkce: {{ row.statutarni_organ_text[0].clenove[i].funkce_do}}{% endif %}
- {% if row.statutarni_organ_text[0].clenove[i].clenstvi_od != 0 %}<br>Den vzniku členství: {{ row.statutarni_organ_text[0].clenove[i].clenstvi_od}}{% endif %}
- {% if row.statutarni_organ_text[0].clenove[i].clenstvi_do != 0 %}<br>Den zániku členství: {{ row.statutarni_organ_text[0].clenove[i].clenstvi_do}}{% endif %}
- {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].clenove[i].zapis_datum }} {% if row.statutarni_organ_text[0].clenove[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].clenove[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% endfor %}
- {% endif %}
- <!-- End insert of board members -->
-
- {% if row.statutarni_organ_text[0].pocet_clenu|length > 0 %}
- <tr>
- <td style = padding-left:2em>Počet členů orgánů:</td>
- {% if row.statutarni_organ_text[0].pocet_clenu[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[0].pocet_clenu[0].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].pocet_clenu[0].zapis_datum }} {% if row.statutarni_organ_text[0].pocet_clenu[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].pocet_clenu[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.statutarni_organ_text[0].pocet_clenu|length) %}
- <tr>
- <td></td>
- {% if row.statutarni_organ_text[0].pocet_clenu[i].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[0].pocet_clenu[i].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].pocet_clenu[i].zapis_datum }} {% if row.statutarni_organ_text[0].pocet_clenu[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].pocet_clenu[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% endfor %}
- {% endif %}
-
- {% if row.statutarni_organ_text[0].zpusoby_jednani|length > 0 %}
- <tr>
- <td style = padding-left:2em>Způsob jednání:</td>
- {% if row.statutarni_organ_text[0].zpusoby_jednani[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[0].zpusoby_jednani[0].zpusob_jednani.zpusob_jednani_text }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].zpusoby_jednani[0].zapis_datum }} {% if row.statutarni_organ_text[0].zpusoby_jednani[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].zpusoby_jednani[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.statutarni_organ_text[0].zpusoby_jednani|length) %}
- <tr>
- <td></td>
- {% if row.statutarni_organ_text[0].zpusoby_jednani[i].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[0].zpusoby_jednani[i].zpusob_jednani.zpusob_jednani_text }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[0].zpusoby_jednani[i].zapis_datum }} {% if row.statutarni_organ_text[0].zpusoby_jednani[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[0].zpusoby_jednani[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% endfor %}
- {% endif %}
-
- {% for i in range (1, row.statutarni_organ_text|length) %}
+ {% for i in range (row.statutarni_organ_text|length) %}
<tr>
<td>{{ row.statutarni_organ_text[i].statutarni_organ_text.statutarni_organ_text }}:</td>
{% if row.statutarni_organ_text[i].vymaz_datum != 0 %}
@@ -342,25 +228,7 @@
<!-- Insert Board Members -->
{% if row.statutarni_organ_text[i].clenove|length > 0 %}
- <tr>
- <td style = padding-left:2em>{% if row.statutarni_organ_text[i].clenove[0].funkce != "0" %} {{ row.statutarni_organ_text[i].clenove[0].funkce }} {% endif %}</td>
- {% if row.statutarni_organ_text[i].clenove[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[i].clenove[0].jmeno.jmeno }} {{ row.statutarni_organ_text[i].clenove[0].jmeno.prijmeni }}{% if row.statutarni_organ_text[i].clenove[0].jmeno.datum_naroz != "" %}, nar. {{ row.statutarni_organ_text[i].clenove[0].jmeno.datum_naroz }}{% endif %} <br>
- {{ row.statutarni_organ_text[i].clenove[0].adresa.adresa_text }}
- {% if row.statutarni_organ_text[i].clenove[0].funkce_od != 0 %}<br>Den vzniku funkce: {{ row.statutarni_organ_text[i].clenove[0].funkce_od}}{% endif %}
- {% if row.statutarni_organ_text[i].clenove[0].funkce_do != 0 %}<br>Den zániku funkce: {{ row.statutarni_organ_text[i].clenove[0].funkce_do}}{% endif %}
- {% if row.statutarni_organ_text[i].clenove[0].clenstvi_od != 0 %}<br>Den vzniku členství: {{ row.statutarni_organ_text[i].clenove[0].clenstvi_od}}{% endif %}
- {% if row.statutarni_organ_text[i].clenove[0].clenstvi_do != 0 %}<br>Den zániku členství: {{ row.statutarni_organ_text[i].clenove[0].clenstvi_do}}{% endif %}
- {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[i].clenove[0].zapis_datum }} {% if row.statutarni_organ_text[i].clenove[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[i].clenove[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for j in range (1, row.statutarni_organ_text[i].clenove|length) %}
+ {% for j in range (row.statutarni_organ_text[i].clenove|length) %}
<tr>
<td style = padding-left:2em>{% if row.statutarni_organ_text[i].clenove[j].funkce != "0" %} {{ row.statutarni_organ_text[i].clenove[j].funkce }} {% endif %}</td>
{% if row.statutarni_organ_text[i].clenove[j].vymaz_datum != 0 %}
@@ -383,23 +251,11 @@
{% endif %}
<!-- End Insert of Board Members -->
-
+ <!-- Insert Number of Members -->
{% if row.statutarni_organ_text[i].pocet_clenu|length > 0 %}
+ {% for j in range (row.statutarni_organ_text[i].pocet_clenu|length) %}
<tr>
- <td style = padding-left:2em>Počet členů orgánů:</td>
- {% if row.statutarni_organ_text[i].pocet_clenu[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[i].pocet_clenu[0].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[i].pocet_clenu[0].zapis_datum }} {% if row.statutarni_organ_text[i].pocet_clenu[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[i].pocet_clenu[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for j in range (1, row.statutarni_organ_text[i].pocet_clenu|length) %}
- <tr>
- <td></td>
+ <td style = padding-left:2em>{% if j == 0%}Počet členů orgánů:{% endif %}</td>
{% if row.statutarni_organ_text[i].pocet_clenu[j].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -412,24 +268,13 @@
</tr>
{% endfor %}
{% endif %}
+ <!-- END Insert Number of Members -->
-
+ <!-- Display method of representation -->
{% if row.statutarni_organ_text[i].zpusoby_jednani|length > 0 %}
+ {% for j in range (row.statutarni_organ_text[i].zpusoby_jednani|length) %}
<tr>
- <td style = padding-left:2em>Způsob jednání:</td>
- {% if row.statutarni_organ_text[i].zpusoby_jednani[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.statutarni_organ_text[i].zpusoby_jednani[0].zpusob_jednani.zpusob_jednani_text }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.statutarni_organ_text[i].zpusoby_jednani[0].zapis_datum }} {% if row.statutarni_organ_text[i].zpusoby_jednani[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.statutarni_organ_text[i].zpusoby_jednani[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for j in range (1, row.statutarni_organ_text[i].zpusoby_jednani|length) %}
- <tr>
- <td></td>
+ <td style = padding-left:2em>{% if j == 0%}Způsob jednání:{% endif %}</td>
{% if row.statutarni_organ_text[i].zpusoby_jednani[j].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -442,103 +287,15 @@
</tr>
{% endfor %}
{% endif %}
+ <!-- END Display method of representation -->
{% endfor %}
{% endif %}
-<!-- END Display statutory bodies -->
+ <!-- END Display statutory bodies -->
-<!--SUPERVISORY BOARD BEGINNING-->
+ <!--Display supervisory board-->
{% if row.dozorci_rada_text|length > 0 %}
- <tr>
- <td>Dozorčí rada:</td>
- {% if row.dozorci_rada_text[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[0].zapis_datum }} {% if row.dozorci_rada_text[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
-
- <!-- Insert supervisory board members -->
- {% if row.dozorci_rada_text[0].clenove|length > 0 %}
- <tr>
- <td style = padding-left:2em>{% if row.dozorci_rada_text[0].clenove[0].funkce != "0" %} {{ row.dozorci_rada_text[0].clenove[0].funkce }} {% endif %}</td>
- {% if row.dozorci_rada_text[0].clenove[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[0].clenove[0].jmeno.jmeno }} {{ row.dozorci_rada_text[0].clenove[0].jmeno.prijmeni }}{% if row.dozorci_rada_text[0].clenove[0].jmeno.datum_naroz != "" %}, nar. {{ row.dozorci_rada_text[0].clenove[0].jmeno.datum_naroz }} {% endif %} <br>
- {{ row.dozorci_rada_text[0].clenove[0].adresa.adresa_text }}
- {% if row.dozorci_rada_text[0].clenove[0].funkce_od != 0 %}<br>Den vzniku funkce: {{ row.dozorci_rada_text[0].clenove[0].funkce_od}}{% endif %}
- {% if row.dozorci_rada_text[0].clenove[0].funkce_do != 0 %}<br>Den zániku funkce: {{ row.dozorci_rada_text[0].clenove[0].funkce_do}}{% endif %}
- {% if row.dozorci_rada_text[0].clenove[0].clenstvi_od != 0 %}<br>Den vzniku členství: {{ row.dozorci_rada_text[0].clenove[0].clenstvi_od}}{% endif %}
- {% if row.dozorci_rada_text[0].clenove[0].clenstvi_do != 0 %}<br>Den zániku členství: {{ row.dozorci_rada_text[0].clenove[0].clenstvi_do}}{% endif %}
- {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[0].clenove[0].zapis_datum }} {% if row.dozorci_rada_text[0].clenove[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[0].clenove[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.dozorci_rada_text[0].clenove|length) %}
- <tr>
- <td style = padding-left:2em>{% if row.dozorci_rada_text[0].clenove[i].funkce != "0" %} {{ row.dozorci_rada_text[0].clenove[i].funkce }} {% endif %}</td>
- {% if row.dozorci_rada_text[0].clenove[i].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[0].clenove[i].jmeno.jmeno }} {{ row.dozorci_rada_text[0].clenove[i].jmeno.prijmeni }}{% if row.dozorci_rada_text[0].clenove[i].jmeno.datum_naroz != "" %}, nar. {{ row.dozorci_rada_text[0].clenove[i].jmeno.datum_naroz }}{% endif %} <br>
- {{ row.dozorci_rada_text[0].clenove[i].adresa.adresa_text }}
- {% if row.dozorci_rada_text[0].clenove[i].funkce_od != 0 %}<br>Den vzniku funkce: {{ row.dozorci_rada_text[0].clenove[i].funkce_od}}{% endif %}
- {% if row.dozorci_rada_text[0].clenove[i].funkce_do != 0 %}<br>Den zániku funkce: {{ row.dozorci_rada_text[0].clenove[i].funkce_do}}{% endif %}
- {% if row.dozorci_rada_text[0].clenove[i].clenstvi_od != 0 %}<br>Den vzniku členství: {{ row.dozorci_rada_text[0].clenove[i].clenstvi_od}}{% endif %}
- {% if row.dozorci_rada_text[0].clenove[i].clenstvi_do != 0 %}<br>Den zániku členství: {{ row.dozorci_rada_text[0].clenove[i].clenstvi_do}}{% endif %}
- {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[0].clenove[i].zapis_datum }} {% if row.dozorci_rada_text[0].clenove[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[0].clenove[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% endfor %}
- {% endif %}
- <!-- Insert supervisory board members END -->
-
- <!-- Insert number of supervisory board members -->
- {% if row.dozorci_rada_text[0].pocet_clenu|length > 0 %}
- <tr>
- <td style = padding-left:2em>Počet členů orgánů:</td>
- {% if row.dozorci_rada_text[0].pocet_clenu[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[0].pocet_clenu[0].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[0].pocet_clenu[0].zapis_datum }} {% if row.dozorci_rada_text[0].pocet_clenu[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[0].pocet_clenu[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.dozorci_rada_text[0].pocet_clenu|length) %}
- <tr>
- <td></td>
- {% if row.dozorci_rada_text[0].pocet_clenu[i].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[0].pocet_clenu[i].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[0].pocet_clenu[i].zapis_datum }} {% if row.dozorci_rada_text[0].pocet_clenu[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[0].pocet_clenu[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% endfor %}
- {% endif %}
-<!-- Insert number of supervisory board members -->
-
-<!--Alternative if there are more records for supervisory board-->
-
- {% for i in range (1, row.dozorci_rada_text|length) %}
+ {% for i in range (row.dozorci_rada_text|length) %}
<tr>
<td>Dozorčí rada:</td>
{% if row.dozorci_rada_text[i].vymaz_datum != 0 %}
@@ -552,27 +309,9 @@
<td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[i].zapis_datum }} {% if row.dozorci_rada_text[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
</tr>
- <!-- Insert Supervisory Board Members -->
+ <!-- Display Supervisory Board Members -->
{% if row.dozorci_rada_text[i].clenove|length > 0 %}
- <tr>
- <td style = padding-left:2em>{% if row.dozorci_rada_text[i].clenove[0].funkce != "0" %} {{ row.dozorci_rada_text[i].clenove[0].funkce }} {% endif %}</td>
- {% if row.dozorci_rada_text[i].clenove[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[i].clenove[0].jmeno.jmeno }} {{ row.dozorci_rada_text[i].clenove[0].jmeno.prijmeni }}{% if row.dozorci_rada_text[i].clenove[0].jmeno.datum_naroz != "" %}, nar. {{ row.dozorci_rada_text[i].clenove[0].jmeno.datum_naroz }}{% endif %} <br>
- {{ row.dozorci_rada_text[i].clenove[0].adresa.adresa_text }}
- {% if row.dozorci_rada_text[i].clenove[0].funkce_od != 0 %}<br>Den vzniku funkce: {{ row.dozorci_rada_text[i].clenove[0].funkce_od}}{% endif %}
- {% if row.dozorci_rada_text[i].clenove[0].funkce_do != 0 %}<br>Den zániku funkce: {{ row.dozorci_rada_text[i].clenove[0].funkce_do}}{% endif %}
- {% if row.dozorci_rada_text[i].clenove[0].clenstvi_od != 0 %}<br>Den vzniku členství: {{ row.dozorci_rada_text[i].clenove[0].clenstvi_od}}{% endif %}
- {% if row.dozorci_rada_text[i].clenove[0].clenstvi_do != 0 %}<br>Den zániku členství: {{ row.dozorci_rada_text[i].clenove[0].clenstvi_do}}{% endif %}
- {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[i].clenove[0].zapis_datum }} {% if row.dozorci_rada_text[i].clenove[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[i].clenove[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for j in range (1, row.dozorci_rada_text[i].clenove|length) %}
+ {% for j in range (row.dozorci_rada_text[i].clenove|length) %}
<tr>
<td style = padding-left:2em>{% if row.dozorci_rada_text[i].clenove[j].funkce != "0" %} {{ row.dozorci_rada_text[i].clenove[j].funkce }} {% endif %}</td>
{% if row.dozorci_rada_text[i].clenove[j].vymaz_datum != 0 %}
@@ -593,25 +332,13 @@
</tr>
{% endfor %}
{% endif %}
- <!-- End Insert of Board Members -->
-
+ <!-- End Display Supervisory Board Members -->
+ <!-- Display Number of Supervisory Board Members -->
{% if row.dozorci_rada_text[i].pocet_clenu|length > 0 %}
+ {% for j in range (row.dozorci_rada_text[i].pocet_clenu|length) %}
<tr>
- <td style = padding-left:2em>Počet členů orgánů:</td>
- {% if row.dozorci_rada_text[i].pocet_clenu[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[i].pocet_clenu[0].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[i].pocet_clenu[0].zapis_datum }} {% if row.dozorci_rada_text[i].pocet_clenu[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[i].pocet_clenu[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for j in range (1, row.dozorci_rada_text[i].pocet_clenu|length) %}
- <tr>
- <td></td>
+ <td style = padding-left:2em>{% if j == 0%}Počet členů:{% endif %}</td>
{% if row.dozorci_rada_text[i].pocet_clenu[j].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -621,18 +348,17 @@
{% endif %}
<td>{{ underlne_style_open|safe }} {{ row.dozorci_rada_text[i].pocet_clenu[j].pocet_clenu_value }} {{ underlne_style_close|safe }}</td>
<td>{{ underlne_style_open|safe }} Zapsáno: {{ row.dozorci_rada_text[i].pocet_clenu[j].zapis_datum }} {% if row.dozorci_rada_text[i].pocet_clenu[j].vymaz_datum != 0 %} <br> Vymazáno: {{ row.dozorci_rada_text[i].pocet_clenu[j].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
+ </tr>
+ <!-- END Display Number of Supervisory Board Members -->
{% endfor %}
{% endif %}
{% endfor %}
{% endif %}
-<!--Alternative if there are more records for supervisory board END-->
+ <!--END Display supervisory board-->
-<!--SUPERVISORY BOARD END-->
-
-<!-- BEGINNING OF PROKURISTA -->
+ <!-- Display prokurist -->
{% if row.prokurista|length > 0 %}
<tr>
<td>Prokura:</td>
@@ -671,9 +397,9 @@
{% endfor %}
<!-- End of a common text for prokura -->
{% endif %}
-<!--PROKURISTA END-->
+ <!-- END Display prokurist -->
-<!-- BEGINNING OF JEDINY AKCIONAR -->
+ <!-- Display sole shareholder -->
{% if row.jediny_akcionar|length > 0 %}
<tr>
<td>Jediný akcionář:</td>
@@ -691,17 +417,15 @@
{% set underlne_style_close = "" %}
{% endif %}
<td>{{ underlne_style_open|safe }} {% if row.jediny_akcionar[i].akcionar_po_id == None %} {{ row.jediny_akcionar[i].jmeno.jmeno }} {{ row.jediny_akcionar[i].jmeno.prijmeni }}{% if row.jediny_akcionar[i].jmeno.datum_naroz != "" %}, nar. {{ row.jediny_akcionar[i].jmeno.datum_naroz }}{% endif %} {% endif %}
- {% if row.jediny_akcionar[i].akcionar_fo_id == None %} {{ row.jediny_akcionar[i].oznaceni_po.nazev }}{% if row.jediny_akcionar[i].oznaceni_po.reg_cislo == 0 %}, IČ {{ row.jediny_akcionar[i].oznaceni_po.ico }}{% endif %}{% if row.jediny_akcionar[i].oznaceni_po.ico == 0 %}, reg č. {{ row.jediny_akcionar[i].oznaceni_po.reg_cislo }}{% endif %} {% endif %}
+ {% if row.jediny_akcionar[i].akcionar_fo_id == None %} {{ row.jediny_akcionar[i].oznaceni_po.nazev }}{% if row.jediny_akcionar[i].oznaceni_po.reg_cislo != 0 %}, reg č. {{ row.jediny_akcionar[i].oznaceni_po.reg_cislo }}{% endif %}{% if row.jediny_akcionar[i].oznaceni_po.ico != 0 %}, IČ {{ row.jediny_akcionar[i].oznaceni_po.ico }}{% endif %} {% endif %}
<br>{{row.jediny_akcionar[i].adresa.adresa_text}} {{ underlne_style_close|safe }}</td>
<td>{{ underlne_style_open|safe }} Zapsáno: {{ row.jediny_akcionar[i].zapis_datum }} {% if row.jediny_akcionar[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.jediny_akcionar[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
</tr>
{% endfor %}
{% endif %}
+ <!-- END Display sole shareholder -->
-<!-- JEDINY AKCIONAR END -->
-
-
-<!-- BEGINNING OF SPOLECNIK -->
+ <!-- Display shareholders -->
{% if row.spolecnici|length > 0 %}
<tr>
<td>Společníci:</td>
@@ -719,7 +443,7 @@
{% set underlne_style_close = "" %}
{% endif %}
<td>{{ underlne_style_open|safe }} {% if row.spolecnici[i].spolecnik_po_id == None %} {{ row.spolecnici[i].jmeno.jmeno }} {{ row.spolecnici[i].jmeno.prijmeni }}{% if row.spolecnici[i].jmeno.datum_naroz != "" %}, nar. {{ row.spolecnici[i].jmeno.datum_naroz }}{% endif %} {% endif %}
- {% if row.spolecnici[i].spolecnik_fo_id == None %} {{ row.spolecnici[i].oznaceni_po.nazev }}{% if row.spolecnici[i].oznaceni_po.reg_cislo == 0 %}, IČ {{ row.spolecnici[i].oznaceni_po.ico }}{% endif %}{% if row.spolecnici[i].oznaceni_po.ico == 0 %}, reg č. {{ row.spolecnici[i].oznaceni_po.reg_cislo }}{% endif %} {% endif %}
+ {% if row.spolecnici[i].spolecnik_fo_id == None %} {{ row.spolecnici[i].oznaceni_po.nazev }} {% if row.spolecnici[i].oznaceni_po.reg_cislo == 0 %}, IČ {{ row.spolecnici[i].oznaceni_po.ico }}{% endif %}{% if row.spolecnici[i].oznaceni_po.ico == 0 %}, reg č. {{ row.spolecnici[i].oznaceni_po.reg_cislo }}{% endif %} {% endif %}
<br>{{row.spolecnici[i].adresa.adresa_text}} {{ underlne_style_close|safe }}</td>
<td>{{ underlne_style_open|safe }} Zapsáno: {{ row.spolecnici[i].zapis_datum }} {% if row.spolecnici[i].vymaz_datum != 0 %} <br> Vymazáno: {{ row.spolecnici[i].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
<!-- Insert individual ownership interests -->
@@ -777,69 +501,13 @@
</tr>
{% endfor %}
{% endif %}
-<!-- END OF SPOLECNIK -->
+ <!-- END Display shareholders -->
+ <!-- Display shares -->
{% if row.akcie|length > 0 %}
+ {% for i in range (row.akcie|length) %}
<tr>
- <td>Akcie:</td>
- {% if row.akcie[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
-
- {% if row.akcie[0].akcie_podoba == "LISTINNA" %}
- {% set akcie_podoba_description = "v listinné podobě" %}
- {% elif row.akcie[0].akcie_podoba == "ZAKNIHOVANA" %}
- {% set akcie_podoba_description = "v zaknihované podobě" %}
- {% elif row.akcie[0].akcie_podoba == "IMOBILIZOVANA" %}
- {% set akcie_podoba_description = "v imobilizované podobě" %}
- {% else %}
- {% set akcie_podoba_description = "" %}
- {% endif %}
-
- {% if row.akcie[0].akcie_typ == "KMENOVE_NA_JMENO" %}
- {% set akcie_typ_description = "kmenové akcie na jméno" %}
- {% elif row.akcie[0].akcie_typ == "KMENOVE_NA_MAJITELE" %}
- {% set akcie_typ_description = "kmenové akcie na majitele" %}
- {% elif row.akcie[0].akcie_typ == "KUSOVE_NA_JMENO" %}
- {% set akcie_typ_description = "kusové akcie" %}
- {% elif row.akcie[0].akcie_typ == "NA_JMENO" %}
- {% set akcie_typ_description = "akcie na jméno" %}
- {% elif row.akcie[0].akcie_typ == "NA_MAJITELE" %}
- {% set akcie_typ_description = "akcie na majitele" %}
- {% elif row.akcie[0].akcie_typ == "PRIORITNI_NA_JMENO" %}
- {% set akcie_typ_description = "prioritní akcie na jméno" %}
- {% elif row.akcie[0].akcie_typ == "PRIORITNI_NA_MAJITELE" %}
- {% set akcie_typ_description = "prioritní akcie na majitele" %}
- {% elif row.akcie[0].akcie_typ == "ZAMESTNANECKE_NA_JMENO" %}
- {% set akcie_typ_description = "zaměstnanecké akcie na jméno" %}
- {% elif row.akcie[0].akcie_typ == "ZVLASTNI_PRAVA" %}
- {% set akcie_typ_description = "akcie se zvláštními právy" %}
- {% elif row.akcie[0].akcie_typ == "HROMANDA" %}
- {% set akcie_typ_description = "hromadná akcie" %}
- {% elif row.akcie[0].akcie_typ == "NA_JMENO_A_MAJITELE" %}
- {% set akcie_typ_description = "akcie na jméno a majitele" %}
- {% else %}
- {% set akcie_typ_description = "" %}
- {% endif %}
-
- {% if row.akcie[0].akcie_hodnota_typ == "KORUNY" %}
- {% set akcie_hodnota_typ_symbol = "Kč" %}
- {% elif row.akcie[0].akcie_hodnota_typ == "EURA" %}
- {% set akcie_hodnota_typ_symbol = "euro" %}
- {% else %}
- {% set akcie_hodnota_typ_symbol = "" %}
- {% endif %}
-
- <td>{{ underlne_style_open|safe }} {{ row.akcie[0].akcie_pocet }} ks {{ akcie_typ_description }} {{ akcie_podoba_description }} ve jmenovité hodnotě {{ row.akcie[0].akcie_hodnota_value }} {{ akcie_hodnota_typ_symbol }} {% if row.akcie[0].akcie_text != "0" %} <br> {{ row.akcie[0].akcie_text }} {% endif %} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.akcie[0].zapis_datum }} {% if row.akcie[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.akcie[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.akcie|length) %}
- <tr>
- <td></td>
+ <td>{% if i == 0%}Akcie:{% endif %}</td>
{% if row.akcie[i].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -891,23 +559,13 @@
</tr>
{% endfor %}
{% endif %}
+ <!-- END Display shares -->
+ <!-- Description of insolvency event -->
{% if row.insolvence|length > 0 %}
+ {% for i in range (row.insolvence|length) %}
<tr>
- <td>Údaje o insolvencích:</td>
- {% if row.insolvence[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.insolvence[0].insolvency_event }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.insolvence[0].zapis_datum }} {% if row.insolvence[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.insolvence[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.insolvence|length) %}
- <tr>
- <td></td>
+ <td>{% if i == 0%}Údaje o insolvencích:{% endif %}</td>
{% if row.insolvence[i].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -920,23 +578,13 @@
</tr>
{% endfor %}
{% endif %}
+ <!-- END Description of insolvency event -->
+<!-- Description of bankruptcy event -->
{% if row.konkurz|length > 0 %}
+ {% for i in range (row.konkurz|length) %}
<tr>
- <td>Údaje o konkurzech:</td>
- {% if row.konkurz[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.konkurz[0].konkurz_event }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.konkurz[0].zapis_datum }} {% if row.konkurz[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.konkurz[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.konkurz|length) %}
- <tr>
- <td></td>
+ <td>{% if i == 0%}Údaje o konkurzech:{% endif %}</td>
{% if row.konkurz[i].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -949,24 +597,13 @@
</tr>
{% endfor %}
{% endif %}
+<!-- END Description of bankruptcy event -->
-
+<!-- Insert other information -->
{% if row.ostatni_skutecnosti|length > 0 %}
+ {% for i in range (row.ostatni_skutecnosti|length) %}
<tr>
- <td>Ostatní skutečnosti:</td>
- {% if row.ostatni_skutecnosti[0].vymaz_datum != 0 %}
- {% set underlne_style_open = undedrline_open_deleted %}
- {% set underlne_style_close = undedrline_closed_deleted %}
- {% else %}
- {% set underlne_style_open = "" %}
- {% set underlne_style_close = "" %}
- {% endif %}
- <td>{{ underlne_style_open|safe }} {{ row.ostatni_skutecnosti[0].ostatni_skutecnost }} {{ underlne_style_close|safe }}</td>
- <td>{{ underlne_style_open|safe }} Zapsáno: {{ row.ostatni_skutecnosti[0].zapis_datum }} {% if row.ostatni_skutecnosti[0].vymaz_datum != 0 %} <br> Vymazáno: {{ row.ostatni_skutecnosti[0].vymaz_datum }} {% endif %} {{ underlne_style_close|safe }}</td>
- </tr>
- {% for i in range (1, row.ostatni_skutecnosti|length) %}
- <tr>
- <td></td>
+ <td>{% if i == 0%}Ostatní skutečnosti:{% endif %}</td>
{% if row.ostatni_skutecnosti[i].vymaz_datum != 0 %}
{% set underlne_style_open = undedrline_open_deleted %}
{% set underlne_style_close = undedrline_closed_deleted %}
@@ -979,7 +616,7 @@
</tr>
{% endfor %}
{% endif %}
-
+<!-- END Insert other information -->
</table>
{% endfor %}
diff --git a/todolist.html b/todolist.html
index 81dec8f..cf10315 100644
--- a/todolist.html
+++ b/todolist.html
@@ -1,6 +1,8 @@
<ol>
<li>Remove excessive repetition in the extract.</li>
<li>Update the code of actual extract to make it work again.</li>
+ <li>Fix how I determine whether a person is a natural person when storing the data about the shareholders.</li>
+ <li>Some companies do not show the current address (for instance Ostrovká teplárna).</li>
<li>Update the search results to always show the current data.</li>
<li>Update the search results to show only current insolvency events.</li>
<li>Change how the address is stored.</li>
@@ -13,5 +15,6 @@
<li>Refactor excessive duplications in the main code.</li>
<li>Break down the main files to smaller ones?</li>
<li>Add some other minor data to the databases - especially those relating to non-profit companies.</li>
+ <li>Check how to make diacritics work in searches.</li>
<li>Write some documentation :)</li>
</ol> \ No newline at end of file
generated by cgit (git 2.34.1) at 2024-09-20 01:07:10 +0000