Changeset 12514

Timestamp:

24 Jan 2015, 13:26:53 (10 years ago)

Author:

Henrik Bettermann

Message:

Add temporary view which helps to find students with faked payment tickets.

This view is untested.

File:

• main/waeup.uniben/trunk/src/waeup/uniben/browser/pages.py (modified) (1 diff)

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

@@ -17 +17 @@
 ##
 import grok
+from zope.component import getUtility
+from zope.catalog.interfaces import ICatalog
 from waeup.kofa.browser.pages import (
     SessionConfigurationAddFormPage, SessionConfigurationManageFormPage,
     LoginPage, CertificatePage, CertificateManageFormPage)
 from waeup.kofa.university.interfaces import ICertificate
+from waeup.kofa.interfaces import IUniversity
 from waeup.uniben.interfaces import (
     ICustomSessionConfiguration, ICustomSessionConfigurationAdd)
+
+
+class ShowDuplicatePayments(grok.View):
+    """List (in plain text format) payment ids which have been
+    imported several times for different students.
+    """
+
+    grok.context(IUniversity)
+    grok.name('replicated_payments')
+    grok.require('waeup.managePortal')
+
+    def search_replicated_payments(self):
+        cat = getUtility(ICatalog, name='payments_catalog')
+        all = list(cat.searchResults(p_id=(None, None)))
+        output = ''
+        hitlist = []
+        for item in all:
+            if not getattr(item,'student', None) or item.p_id in hitlist:
+                continue
+            replicates = cat.searchResults(p_id=(item.p_id, item.p_id))
+            if len(replicates) > 1:
+                hitlist.append(item.p_id)
+                replicates_line = ''
+                for p in replicates:
+                    student = getattr(p,'student', None)
+                    if student is not None:
+                        replicates_line += '%s (%s),' % (
+                            student.student_id,
+                            student.matric_number)
+                output += "%s,%s\n" % (item.p_id, replicates_line)
+        return output
+
+    def render(self):
+        return self.search_replicated_payments()
+
 
 class CustomSessionConfigurationAddFormPage(SessionConfigurationAddFormPage):