Add students blueprint using psycopg

1 files changed, 82 insertions, 0 deletions

diff --git a/ustayml/templates/students/index.html b/ustayml/templates/students/index.html
new file mode 100644
index 0000000..74c1847
--- /dev/null
+++ b/ustayml/templates/students/index.html
@@ -0,0 +1,82 @@
+{% extends 'base.html' %}
+
+
+{% block header %}
+  <h1>{% block title %}Estudiantes{% endblock %}</h1>
+  <span>💡TIP: hacer click en un estudiante para ver su detalle</span>
+{% endblock %}
+
+{% block content %}
+  <div class="filters">
+    {# <h3>Filtros</h3> #}
+    <form class="filters-list" method="post">
+      <label for="pucp_unit">Unidad: 
+          <select name="pucp_unit" id="pucp_unit">
+              <option>Mostrar todas</option>
+              <option>Facultad de Ciencias e Ingenieria</option>
+              <option>EEGGCC</option>
+          </select>
+      </label>
+      <label for="semester">Semestre: 
+          <select name="semester" id="semester">
+              <option>Mostrar todos</option>
+              <option>2023-2</option>
+              <option>2023-1</option>
+              <option>2022-2</option>
+              <option>2022-1</option>
+              <option>2021-2</option>
+              <option>2021-1</option>
+              <option>2020-2</option>
+              <option>2020-1</option>
+              <option>2019-2</option>
+              <option>2019-1</option>
+              <option>2018-2</option>
+              <option>2018-1</option>
+              <option>2017-2</option>
+              <option>2017-1</option>
+          </select>
+      </label>
+      <label for="dessertion_risk">Riesgo deserción:
+          <select name="dessertion_risk" id="dessertion_risk">
+              <option>Mostrar todos</option>
+              <option>Alto</option>
+              <option>Medio</option>
+              <option>Bajo</option>
+          </select>
+      </label>
+    </form>
+    <input type="submit" value="Aplicar filtros">
+  </div>
+  <table class="students-table">
+    <thead>
+      <tr>
+        <th>código</th>
+        <th>nombre</th>
+        <th>email</th>
+        <th>distrito</th>
+        <th>asistencia</th>
+        <th>CRAEst</th>
+        <th>PPNE3</th>
+        <th>mérito</th>
+        <th>ciclos est.</th>
+        <th>riesgo est.</th>
+      </tr>
+    </thead>
+    <tbody>
+      {% for student in students %}
+        <tr>
+          <td>{{ student['pucp_code'] }}</td>
+          <td>{{ student['fullname'] }}</td>
+          <td>{{ student['email'] }}</td>
+          <td>{{ student['district'] }}</td>
+          <td>{{ student['current_attendance'] }}</td>
+          <td>{{ student['current_craest'] }}</td>
+          <td>{{ student['current_ppne3'] }}</td>
+          <td>{{ student['current_merit'] }}</td>
+          <td>{{ student['est_study_length'] }}</td>
+          <td>{{ student['est_dessertion_risk'] }}</td>
+        </tr>
+      {% endfor %}
+    </tbody>
+  </table>
+{% endblock %}
\ No newline at end of file