QOF change: use SQL view for student data display

2 files changed, 28 insertions, 1 deletions

diff --git a/ustayml/templates/students/details.html b/ustayml/templates/students/details.html
new file mode 100644
index 0000000..6c28ea4
--- /dev/null
+++ b/ustayml/templates/students/details.html
@@ -0,0 +1,27 @@
+{% extends 'base.html' %}
+
+{% block header %}
+  <h1>{% block title %}Reporte del estudiante{% endblock %}</h1>
+  <span>Reporte generado el {{ date.strftime("%Y-%m-%d") }}</span>
+{% endblock %}
+
+{% block content %}
+  <div class="student-details-container">
+    <div id="information-left">
+      <h3>Información general:</h3>
+      <h3>Información socioeconómica:</h3>
+      <h3>Información académica:</h3>
+    </div>
+    <div id="information-right">
+      <h2>Resultado:</h2>
+      <span class="high-risk">Riesgo de deserción alto</span>
+      <ul>
+        <li>Factor de riesgo: 666</li>
+      </ul>
+      <span>Significancia de variables:</span>
+      <div class="chart">
+        <img src="{{ url_for('static', filename='img/sample-bar_chart.png') }}">
+      </div>
+    </div>
+  </div>
+{% endblock %}
\ No newline at end of file
diff --git a/ustayml/templates/students/index.html b/ustayml/templates/students/index.html
index 6fb5312..050783b 100644
--- a/ustayml/templates/students/index.html
+++ b/ustayml/templates/students/index.html
@@ -79,7 +79,7 @@
     <tbody>
       {% for student in students %}
         <tr>
-          <td>{{ student['pucp_code'] }}</td>
+          <td><a href="{{ url_for('students.details', id=student['id']) }}">{{ student['pucp_code'] }}</a></td>
           <td>{{ student['fullname'] }}</td>
           <td>{{ student['email'] }}</td>
           <td>{{ student['district'] }}</td>