Changeset 10646 for main/waeup.kofa/trunk/src/waeup/kofa/browser/pages.py

Timestamp:

24 Sep 2013, 12:39:44 (11 years ago)

Author:

Henrik Bettermann

Message:

Implement page to find students in faculties.

File:

• main/waeup.kofa/trunk/src/waeup/kofa/browser/pages.py (modified) (3 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/browser/pages.py

@@ -26 +26 @@
 from datetime import datetime, timedelta
 from urllib import urlencode
+from hurry.query import Eq, Text
+from hurry.query.query import Query
 from zope import schema
 from zope.i18n import translate
@@ -72 +74 @@
 
 from waeup.kofa.students.export import EXPORTER_NAMES as STUDENT_EXPORTERS
+from waeup.kofa.students.catalog import StudentQueryResultItem
 
 FORBIDDEN_CHARACTERS = (160,)
@@ -1850 +1853 @@
         return del_local_roles(self,3,**data)
 
+class FindStudentsPage(KofaPage):
+    """Search students in faculty.
+    """
+    grok.context(IFaculty)
+    grok.name('find_students')
+    grok.require('waeup.showStudents')
+    grok.template('findstudentspage')
+    label = _('Find students')
+    search_button = _('Find student')
+    pnav = 1
+
+    def _find_students(self,query=None, searchtype=None, view=None):
+        hitlist = []
+        if searchtype in ('fullname',):
+            results = Query().searchResults(
+                Text(('students_catalog', searchtype), query) &
+                Eq(('students_catalog', 'faccode'), self.context.code)
+                )
+        else:
+            results = Query().searchResults(
+                Eq(('students_catalog', searchtype), query) &
+                Eq(('students_catalog', 'faccode'), self.context.code)
+                )
+        for result in results:
+            hitlist.append(StudentQueryResultItem(result, view=view))
+        return hitlist
+
+    def update(self, *args, **kw):
+        datatable.need()
+        form = self.request.form
+        self.hitlist = []
+        if 'searchterm' in form and form['searchterm']:
+            self.searchterm = form['searchterm']
+            self.searchtype = form['searchtype']
+        elif 'old_searchterm' in form:
+            self.searchterm = form['old_searchterm']
+            self.searchtype = form['old_searchtype']
+        else:
+            if 'search' in form:
+                self.flash(_('Empty search string'))
+            return
+        self.hitlist = self._find_students(query=self.searchterm,
+            searchtype=self.searchtype, view=self)
+        if not self.hitlist:
+            self.flash(_('No student found.'))
+        return
+
 class DepartmentAddFormPage(KofaAddFormPage):
     """Add a department to a faculty.