new trivia functions

4 files changed, 90 insertions, 0 deletions

diff --git a/templates/longest_registered_executives.html b/templates/longest_registered_executives.html
new file mode 100644
index 0000000..281c3fb
--- /dev/null
+++ b/templates/longest_registered_executives.html
@@ -0,0 +1,29 @@
+{% include 'header.html' %}
+
+<h1>Nejdéle registrovaní statutáři:</h1>
+<table class="table table-hover" style="width: auto">
+    <thead class="thead-dark">
+    <tr class="table-info">
+        <th scope="col">#</th>
+        <th scope="col">Jméno a příjmení</th>
+        <th scope="col">Datum narození</th>
+        <th scope="col">Adresa</th>
+        <th scope="col">Ve společnosti</th>
+        <th scope="col">Datum zápisu</th>
+    </tr>
+    </thead>
+    <tbody>
+    {% for i in range (longest_registered_executives_list|length) %}
+    <tr>
+        <th scope = "row">{{ i + 1 }}</th>
+        <td>{% if longest_registered_executives_list[i][0] != "0" %} {{ longest_registered_executives_list[i][0] }} {% endif %}{{ longest_registered_executives_list[i][1] }}</a></td>
+        <td>{{ longest_registered_executives_list[i][2] }}</td>
+        <td>{{ longest_registered_executives_list[i][5] }}</td>
+        <td>{{ longest_registered_executives_list[i][3] }}, IČ: <a href="{{ longest_registered_executives_list[i][4] }}">{{ longest_registered_executives_list[i][4] }}</a></td>
+        <td>{{ longest_registered_executives_list[i][6] }}</td>
+    </tr>
+    {% endfor %}
+    </tbody>
+</table>
+
+{% include 'footer.html' %}
\ No newline at end of file
diff --git a/templates/longest_registered_shareholders.html b/templates/longest_registered_shareholders.html
new file mode 100644
index 0000000..86e572d
--- /dev/null
+++ b/templates/longest_registered_shareholders.html
@@ -0,0 +1,29 @@
+{% include 'header.html' %}
+
+<h1>Nejdéle registrovaní společníci:</h1>
+<table class="table table-hover" style="width: auto">
+    <thead class="thead-dark">
+    <tr class="table-info">
+        <th scope="col">#</th>
+        <th scope="col">Jméno a příjmení</th>
+        <th scope="col">Datum narození</th>
+        <th scope="col">Adresa</th>
+        <th scope="col">Ve společnosti</th>
+        <th scope="col">Datum zápisu</th>
+    </tr>
+    </thead>
+    <tbody>
+    {% for i in range (longest_registered_shareholders_list|length) %}
+    <tr>
+        <th scope = "row">{{ i + 1 }}</th>
+        <td>{% if longest_registered_shareholders_list[i][0] != "0" %} {{ longest_registered_shareholders_list[i][0] }} {% endif %}{{ longest_registered_shareholders_list[i][1] }}</a></td>
+        <td>{{ longest_registered_shareholders_list[i][2] }}</td>
+        <td>{{ longest_registered_shareholders_list[i][5] }}</td>
+        <td>{{ longest_registered_shareholders_list[i][3] }}, IČ: <a href="{{ longest_registered_shareholders_list[i][4] }}">{{ longest_registered_shareholders_list[i][4] }}</a></td>
+        <td>{{ longest_registered_shareholders_list[i][6] }}</td>
+    </tr>
+    {% endfor %}
+    </tbody>
+</table>
+
+{% include 'footer.html' %}
\ No newline at end of file
diff --git a/templates/oldest_shareholders.html b/templates/oldest_shareholders.html
new file mode 100644
index 0000000..02767af
--- /dev/null
+++ b/templates/oldest_shareholders.html
@@ -0,0 +1,29 @@
+{% include 'header.html' %}
+
+<h1>Nejstarší společníci:</h1>
+<table class="table table-hover" style="width: auto">
+    <thead class="thead-dark">
+    <tr class="table-info">
+        <th scope="col">#</th>
+        <th scope="col">Jméno a příjmení</th>
+        <th scope="col">Datum narození</th>
+        <th scope="col">Adresa</th>
+        <th scope="col">Ve společnosti</th>
+        <th scope="col">Datum zápisu</th>
+    </tr>
+    </thead>
+    <tbody>
+    {% for i in range (oldest_shareholders_list|length) %}
+    <tr>
+        <th scope = "row">{{ i + 1 }}</th>
+        <td>{% if oldest_shareholders_list[i][0] != "0" %} {{ oldest_shareholders_list[i][0] }} {% endif %}{{ oldest_shareholders_list[i][1] }}</a></td>
+        <td>{{ oldest_shareholders_list[i][2] }}</td>
+        <td>{{ oldest_shareholders_list[i][5] }}</td>
+        <td>{{ oldest_shareholders_list[i][3] }}, IČ: <a href="{{ oldest_shareholders_list[i][4] }}">{{ oldest_shareholders_list[i][4] }}</a></td>
+        <td>{{ oldest_shareholders_list[i][6] }}</td>
+    </tr>
+    {% endfor %}
+    </tbody>
+</table>
+
+{% include 'footer.html' %}
\ No newline at end of file
diff --git a/templates/trivia.html b/templates/trivia.html
index 43e82ab..bb4e0b5 100644
--- a/templates/trivia.html
+++ b/templates/trivia.html
@@ -11,5 +11,8 @@
 <p><a href="/most_common_business">Seznam nejčastějších předmětů podnikání</a></p>
 <p><a href="/most_common_activity">Seznam nejčastějších předmětů činnosti</a></p>
 <p><a href="/most_common_degree">Seznam nejčastějších titulů</a></p>
+<p><a href="/oldest_shareholders">Seznam nejstarších společníků</a></p>
+<p><a href="/longest_registered_shareholders">Seznam nejdéle registrovaných společníků</a></p>
+<p><a href="/longest_registered_executives">Seznam nejdéle registrovaných statutárů</a></p>
 
 {% include 'footer.html' %}
\ No newline at end of file