Changeset 17640 for main/waeup.kofa/trunk/src/waeup/kofa/students

Timestamp:

13 Nov 2023, 08:46:45 (14 months ago)

Author:

Henrik Bettermann

Message:

Get set of selected students also from list of payment ids.

Location:

main/waeup.kofa/trunk/src/waeup/kofa/students

Files:

• browser_templates/exportselected.pt (modified) (2 diffs)
• export.py (modified) (2 diffs)
• tests/test_export.py (modified) (1 diff)

main/waeup.kofa/trunk/src/waeup/kofa/students/browser_templates/exportselected.pt

@@ -1 +1 @@
 <p i18n:translate="">
   Here you can export student data for a small subset of students by entering
-  a list of student ids or matric numbers.
+  a list of student ids, matric numbers or ids of payments made by students.
   The values must be separated by whitespaces or commas.
   You can also copy and paste parts of Excel or Calc columns.
@@ -18 +18 @@
   <br />
   <label for="mode" i18n:translate="">
-    Student Ids or Matric Numbers
+    Student Ids, Matric Numbers or Payment Ids
   </label>
   <input name="students" type="text" class="form-control" id="students"

main/waeup.kofa/trunk/src/waeup/kofa/students/export.py

@@ -23 +23 @@
 from datetime import datetime, timedelta
 from zope.component import getUtility
+from zope.catalog.interfaces import ICatalog
 from waeup.kofa.interfaces import (
     IExtFileStore, IFileStoreNameChooser, IKofaUtils)
@@ -302 +303 @@
                 if result:
                     student = result[0]
-                else:
-                    continue
-            students.append(student)
+            if student is None:
+                # try p_id (requested by AAUE)
+                cat = getUtility(ICatalog, name='payments_catalog')
+                results = list(cat.searchResults(p_id=(id, id)))
+                if results:
+                    # Check if payer is a student
+                    student = getattr(results[0], 'student')
+            if student is not None:
+                students.append(student)
         return students
 

main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_export.py

@@ -525 +525 @@
         return
 
+    def test_export_selected_pid(self):
+        # we can export a filtered set of students (filtered by session/level)
+        self.setup_student(self.student)
+        self.app['students'].addStudent(self.student)
+        notify(grok.ObjectModifiedEvent(self.student))
+        exporter = StudentStudyCourseExporter()
+        exporter.export_selected(
+            self.app, self.outfile, selected=[self.payment.p_id])
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'certificate,current_level,current_session,current_verdict,'
+            'entry_mode,entry_session,previous_verdict,student_id,previous\r\n'
+
+            'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n'
+            )
+        return
+
 class PreviousStudyCourseExporterTests(StudentImportExportSetup):