From fe5b3c41aa898fa7491a7ec9bce28c5e1c5b542d Mon Sep 17 00:00:00 2001
From: adityacp
Date: Fri, 6 Nov 2020 18:21:48 +0530
Subject: Statistics app for video tracking

---
 stats/templates/view_lesson_tracking.html | 69 +++++++++++++++++++++++++++++++
 1 file changed, 69 insertions(+)
 create mode 100644 stats/templates/view_lesson_tracking.html

(limited to 'stats/templates/view_lesson_tracking.html')

diff --git a/stats/templates/view_lesson_tracking.html b/stats/templates/view_lesson_tracking.html
new file mode 100644
index 0000000..fd87d70
--- /dev/null
+++ b/stats/templates/view_lesson_tracking.html
@@ -0,0 +1,69 @@
+{% extends "manage.html" %}
+
+{% block title %} Lesson Views {% endblock %}
+{% block script %}
+<script type="text/javascript">
+    function get_time_in_seconds(time) {
+        var time = time.split(":");
+        var hh = parseInt(time[0]);
+        var mm = parseInt(time[1]);
+        var ss = parseInt(time[2]);
+        return hh * 3600 + mm * 60 + ss;
+    }
+
+    $(document).ready(function() {
+        $('#stats-table tr').each(function() {
+            var td = $(this).find("td");
+            var elapsed = td.eq(4).html();
+            var duration = td.eq(5).html();
+            var input = td.eq(6).find("input");
+            if (elapsed != undefined && duration != undefined) {
+                percent = (get_time_in_seconds(elapsed) / get_time_in_seconds(duration)) * 100;
+                input.val(Math.round(percent));
+            }
+        });
+    });
+</script>
+{% endblock %}
+{% block content %}
+<div class="container">
+    {% with objects.object_list as trackings %}
+    <center>
+        <h3>Statistics for {% with trackings|first as entry %} {{entry.lesson}} {% endwith %}</h3>
+    </center>
+    <a class="btn btn-primary" href="{% url 'yaksh:lesson_statistics' course_id lesson_id %}">
+        <i class="fa fa-arrow-left"></i>&nbsp;Back
+    </a>
+    <br><br>
+    {% include "yaksh/paginator.html" %}
+    <br>
+    <h4><strong>{{total}} student(s) viewed this lesson</strong></h4>
+    <table class="table table-responsive" id="stats-table">
+        <tr>
+            <th>Sr No.</th>
+            <th>Student Name</th>
+            <th>Last access on</th>
+            <th>Started on</th>
+            <th>Current Time</th>
+            <th>Video Duration</th>
+            <th>Percentage watched</th>
+        </tr>
+        {% for track in trackings %}
+            <tr>
+                <td>{{ forloop.counter0|add:objects.start_index }}</td>
+                <td>{{track.user.get_full_name}}</td>
+                <td>{{track.last_access_time}}</td>
+                <td>{{track.creation_time}}</td>
+                <td>{{track.current_time}}</td>
+                <td>{{track.video_duration}}</td>
+                <td>
+                    <input type="text" class="form-control" readonly="">
+                </td>
+            </tr>
+        {% endfor %}
+    </table>
+    {% endwith %}
+    <br>
+    {% include "yaksh/paginator.html" %}
+</div>
+{% endblock %}
\ No newline at end of file
-- 
cgit 


From 7419b67b1928f30824a332d36afcdfddebaf2479 Mon Sep 17 00:00:00 2001
From: adityacp
Date: Sat, 7 Nov 2020 12:09:22 +0530
Subject: Add table sorter

---
 stats/templates/view_lesson_tracking.html | 34 ++++++++++++++++---------------
 1 file changed, 18 insertions(+), 16 deletions(-)

(limited to 'stats/templates/view_lesson_tracking.html')

diff --git a/stats/templates/view_lesson_tracking.html b/stats/templates/view_lesson_tracking.html
index fd87d70..fa891e3 100644
--- a/stats/templates/view_lesson_tracking.html
+++ b/stats/templates/view_lesson_tracking.html
@@ -1,7 +1,9 @@
 {% extends "manage.html" %}
-
+{% load static %}
 {% block title %} Lesson Views {% endblock %}
 {% block script %}
+<script type="text/javascript" src="{% static 'yaksh/js/jquery.tablesorter.min.js' %}">
+</script>
 <script type="text/javascript">
     function get_time_in_seconds(time) {
         var time = time.split(":");
@@ -12,14 +14,14 @@
     }
 
     $(document).ready(function() {
+        $("#stats-table").tablesorter({});
         $('#stats-table tr').each(function() {
             var td = $(this).find("td");
             var elapsed = td.eq(4).html();
             var duration = td.eq(5).html();
-            var input = td.eq(6).find("input");
-            if (elapsed != undefined && duration != undefined) {
+            if (elapsed != undefined || duration != undefined) {
                 percent = (get_time_in_seconds(elapsed) / get_time_in_seconds(duration)) * 100;
-                input.val(Math.round(percent));
+                td.eq(6).html(Math.round(percent));
             }
         });
     });
@@ -39,15 +41,17 @@
     <br>
     <h4><strong>{{total}} student(s) viewed this lesson</strong></h4>
     <table class="table table-responsive" id="stats-table">
-        <tr>
-            <th>Sr No.</th>
-            <th>Student Name</th>
-            <th>Last access on</th>
-            <th>Started on</th>
-            <th>Current Time</th>
-            <th>Video Duration</th>
-            <th>Percentage watched</th>
-        </tr>
+        <thead>
+            <tr>
+                <th>Sr No.</th>
+                <th>Student Name&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Last access on&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Started on&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Current Time&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Video Duration&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Percentage watched&nbsp;<i class="fa fa-sort"></i></th>
+            </tr>
+        </thead>
         {% for track in trackings %}
             <tr>
                 <td>{{ forloop.counter0|add:objects.start_index }}</td>
@@ -56,9 +60,7 @@
                 <td>{{track.creation_time}}</td>
                 <td>{{track.current_time}}</td>
                 <td>{{track.video_duration}}</td>
-                <td>
-                    <input type="text" class="form-control" readonly="">
-                </td>
+                <td></td>
             </tr>
         {% endfor %}
     </table>
-- 
cgit 


From d09ff51b6c957137e705fee73f1808c6333eed7f Mon Sep 17 00:00:00 2001
From: adityacp
Date: Sat, 7 Nov 2020 18:54:15 +0530
Subject: Add additional model to store last access for lesson

---
 stats/templates/view_lesson_tracking.html | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'stats/templates/view_lesson_tracking.html')

diff --git a/stats/templates/view_lesson_tracking.html b/stats/templates/view_lesson_tracking.html
index fa891e3..7962410 100644
--- a/stats/templates/view_lesson_tracking.html
+++ b/stats/templates/view_lesson_tracking.html
@@ -47,20 +47,24 @@
                 <th>Student Name&nbsp;<i class="fa fa-sort"></i></th>
                 <th>Last access on&nbsp;<i class="fa fa-sort"></i></th>
                 <th>Started on&nbsp;<i class="fa fa-sort"></i></th>
-                <th>Current Time&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Current Duration&nbsp;<i class="fa fa-sort"></i></th>
                 <th>Video Duration&nbsp;<i class="fa fa-sort"></i></th>
                 <th>Percentage watched&nbsp;<i class="fa fa-sort"></i></th>
+                <th>Total visits&nbsp;<i class="fa fa-sort"></i></th>
             </tr>
         </thead>
         {% for track in trackings %}
             <tr>
                 <td>{{ forloop.counter0|add:objects.start_index }}</td>
                 <td>{{track.user.get_full_name}}</td>
-                <td>{{track.last_access_time}}</td>
+                {% with track.get_last_access_time_and_vists as time_and_visits %}
+                <td>{{time_and_visits.0}}</td>
                 <td>{{track.creation_time}}</td>
                 <td>{{track.current_time}}</td>
                 <td>{{track.video_duration}}</td>
                 <td></td>
+                <td>{{time_and_visits.1}}</td>
+                {% endwith %}
             </tr>
         {% endfor %}
     </table>
-- 
cgit