From 3b22586890425c8b8e555bce649649228b26c02b Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Sun, 29 Oct 2023 14:28:43 -0500
Subject: Add students blueprint using psycopg

---
 ustayml/templates/auth/login.html     |  2 +-
 ustayml/templates/base.html           |  6 +++
 ustayml/templates/blog/create.html    |  2 +-
 ustayml/templates/students/index.html | 82 +++++++++++++++++++++++++++++++++++
 4 files changed, 90 insertions(+), 2 deletions(-)
 create mode 100644 ustayml/templates/students/index.html

(limited to 'ustayml/templates')

diff --git a/ustayml/templates/auth/login.html b/ustayml/templates/auth/login.html
index b7dd5dc..45acd7f 100644
--- a/ustayml/templates/auth/login.html
+++ b/ustayml/templates/auth/login.html
@@ -5,7 +5,7 @@
 {% endblock %}
 
 {% block content %}
-  <form method="post">
+  <form class="simple-form" method="post">
     <label for="username">Username</label>
     <input name="username" id="username" required>
     <label for="password">Password</label>
diff --git a/ustayml/templates/base.html b/ustayml/templates/base.html
index 1b2c384..b8d243c 100644
--- a/ustayml/templates/base.html
+++ b/ustayml/templates/base.html
@@ -4,6 +4,12 @@
 <link rel="shortcut icon" href="{{ url_for('static', filename='favicon.ico') }}">
 <nav>
   <h1><a href="{{ url_for('index') }}">u-stayML</a></h1>
+  <ul>
+    <li><a href="{{ url_for('students.index') }}">Dashboard</a></li>
+    <li><a href="{{ url_for('students.index') }}">Estudiantes</a></li>
+    <li><a href="#">Historial</a>       </li>
+    <li><a href="#">Cargar datos</a>    </li>
+  </ul>
   <ul>
     {% if g.user %}
       <li><span>{{ g.user['username'] }}</span>
diff --git a/ustayml/templates/blog/create.html b/ustayml/templates/blog/create.html
index 88e31e4..9132641 100644
--- a/ustayml/templates/blog/create.html
+++ b/ustayml/templates/blog/create.html
@@ -10,6 +10,6 @@
     <input name="title" id="title" value="{{ request.form['title'] }}" required>
     <label for="body">Body</label>
     <textarea name="body" id="body">{{ request.form['body'] }}</textarea>
-    <input type="submit" value="Save">
+    <input type="submit" value="Aplicar">
   </form>
 {% endblock %}
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
-- 
cgit v1.2.3