From 637db8220d34627f779c830fc8e486573aeeb245 Mon Sep 17 00:00:00 2001
From: Yoan Le Clanche <yoanl@pilotsystems.net>
Date: Fri, 17 Jul 2020 15:51:43 +0200
Subject: [PATCH] Add field to filters scripts by author name

---
 teleforma/exam/templates/exam/scripts.html | 2 ++
 teleforma/exam/views.py                    | 6 ++++++
 2 files changed, 8 insertions(+)

diff --git a/teleforma/exam/templates/exam/scripts.html b/teleforma/exam/templates/exam/scripts.html
index 1b618252..e03e3510 100644
--- a/teleforma/exam/templates/exam/scripts.html
+++ b/teleforma/exam/templates/exam/scripts.html
@@ -100,6 +100,8 @@
        <option value="1" {% if platform_only == '1' %}selected="selected"{% endif %}>Oui</option>
        <option value="0" {% if platform_only == '0' %}selected="selected"{% endif %}>Non</option>
     </select>
+    <label for="student_name">Etudiant</label>
+    <input name="student_name" id="student_name" placeholder="nom, mail ou identifiant de l'étudiant" value="{{student_name}}" />
     <input type="submit" value="Filtrer"/>
 </form>
 {% endif %}
diff --git a/teleforma/exam/views.py b/teleforma/exam/views.py
index 82e0b624..46a7bbf9 100755
--- a/teleforma/exam/views.py
+++ b/teleforma/exam/views.py
@@ -86,6 +86,7 @@ class ScriptsListMixinView(ScriptMixinView):
             context['courses_list'] = [(str(course.id), course.title) for course in courses]
             context['course_selected'] = self.request.GET.get('course')
             context['platform_only'] = self.request.GET.get('platform_only')
+            context['student_name'] = self.request.GET.get('student_name') or ''
         return context
 
 class ScriptView(ScriptMixinView, CourseAccessMixin, UpdateView):
@@ -153,6 +154,7 @@ class ScriptsView(ScriptsListMixinView, ListView):
         session = self.request.GET.get('session')
         course = self.request.GET.get('course')
         platform_only = self.request.GET.get('platform_only')
+        student_name = self.request.GET.get('student_name')
         if type:
             QT &= Q(type__id=int(type))
         if session:
@@ -163,6 +165,10 @@ class ScriptsView(ScriptsListMixinView, ListView):
             QT &= Q(corrector__id=int(corrector))
         if platform_only:
             QT &= Q(author__student__platform_only = int(platform_only))
+        if student_name:
+            QT &= Q(author__student__user__first_name__icontains=student_name) | Q(author__student__user__last_name__icontains=student_name) | Q(author__student__user__email=student_name) | Q(author__student__user__username=student_name)
+            
+
         return QT
 
     def get_base_queryset(self):
-- 
2.39.5