Changeset 18340


Ignore:
Timestamp:
29 Sep 2026, 07:31:22 (8 weeks ago)
Author:
Henrik Bettermann
Message:

Add OutstandingCourses2Exporter. Not yet tested.

Location:
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py

    r18313 r18340  
    1818"""Exporters for student related stuff.
    1919"""
     20import grok
    2021from waeup.kofa.students.export import DataForLecturerExporter
     22
     23from zope.component import getUtility, createObject
     24
     25from waeup.kofa.students.export import (get_levels,
     26    DataForLecturerExporter, StudentExporterBase,)
     27
     28from waeup.kofa.utils.batching import ExporterBase
     29
    2130from kofacustom.unidel.students.interfaces import (
    2231    ICustomStudent,
    … …  
    3241    NigeriaStudentPaymentExporter)
    3342from waeup.kofa.utils.helpers import iface_names
     43
     44
     45def get_tickets_for_ict(students, previous=0, **kw):
     46    """
     47    """
     48    tickets = list()
     49    #code = kw.get('code', None)
     50    level = kw.get('level', None)
     51    session = kw.get('session', None)
     52    ct_level = kw.get('ct_level', None)
     53    ct_session = kw.get('ct_session', None)
     54    ct_semester = kw.get('ct_semester', None)
     55    for level_obj in get_levels(students, previous, **kw):
     56        allticketcodes = list()
     57        for ticket in level_obj.values():
     58            if ct_level not in ('all', None):
     59                if level_obj.level in (10, 999, 1000, None)  \
     60                    and int(ct_level) != level_obj.level:
     61                    continue
     62                if level_obj.level not in range(
     63                    int(ct_level), int(ct_level)+100, 10):
     64                    continue
     65            if ct_session not in ('all', None) and \
     66                int(ct_session) != level_obj.level_session:
     67                continue
     68            if ct_semester not in ('all', None) and \
     69                int(ct_semester) != ticket.semester:
     70                continue
     71            if ticket.total_score is not None:
     72                if ticket.total_score < ticket.passmark:
     73                    remark = 'failed'
     74                else:
     75                    remark = 'passed'
     76            else:
     77                remark = 'nottaken'
     78            ticket.remark = remark
     79            ticket.stdnt = level_obj.student
     80            tickets.append(ticket)
     81            allticketcodes.append(ticket.code)
     82        # collect missed tickets for each study level
     83        certificate = getattr(
     84            level_obj.student.get('studycourse', None), 'certificate', None)
     85        if certificate:
     86            for certcourse in certificate.values():
     87                if certcourse.level != level_obj.level:
     88                    continue
     89                if certcourse.getCourseCode() not in allticketcodes:
     90                    ticket = createObject(u'waeup.CourseTicket')
     91                    ticket.code = certcourse.getCourseCode()
     92                    ticket.remark = 'missed'
     93                    ticket.course_category = certcourse.course_category
     94                    ticket.stdnt = level_obj.student
     95                    tickets.append(ticket)
     96    # Remove failed or missed tickets if they have been passed later
     97    obsolete = list()
     98    for student in students:
     99        all_tickets = [i for i in tickets if student == i.stdnt]
     100        passed_tickets = [i for i in all_tickets if i.remark == 'passed']
     101        for passed_ticket in passed_tickets:
     102            for ticket in all_tickets:
     103                 if ticket.code == passed_ticket.code: # remove passed ticket too
     104                    obsolete.append(ticket)
     105    for ticket in set(obsolete):
     106        tickets.remove(ticket)
     107    return tickets
    34108
    35109class CustomStudentExporter(NigeriaStudentExporter):
    … …  
    121195            value, name, context=context)
    122196
     197class OutstandingCourses2Exporter(grok.GlobalUtility, StudentExporterBase):
     198    """
     199    """
     200    grok.name('outstandingcourses_2')
     201
     202    title = u'Outstanding Courses V2'
     203
     204    fields = ('student_id', 'matric_number', 'certcode', 'display_fullname',
     205              'code', 'course_category', 'remark')
     206
     207    def filter_func(self, x, **kw):
     208        return get_tickets_for_ict(x, **kw)
     209
     210    def mangle_value(self, value, name, context=None):
     211        """The mangler determines the student's id and fullname.
     212        """
     213        if context is not None:
     214            student = context.student
     215            if not student:
     216                student = getattr(context, 'stdnt', None)
     217            if name in ('student_id', 'display_fullname', 'matric_number',
     218                'certcode') and student is not None:
     219                value = getattr(student, name, None)
     220        return ExporterBase().mangle_value(value, name, context=context)
     221
     222
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_export.py

    r18307 r18340  
    88from kofacustom.unidel.utils.utils import CustomKofaUtils
    99from kofacustom.unidel.students.export import (
    10     CustomStudentExporter, CustomStudentPaymentExporter)
     10    CustomStudentExporter, CustomStudentPaymentExporter,
     11    OutstandingCourses2Exporter)
    1112from kofacustom.unidel.testing import FunctionalLayer
    1213
    … …  
    113114            )
    114115        return
     116
     117class OutstandingCourses2ExporterTest(StudentImportExportSetup):
     118
     119    layer = FunctionalLayer
     120
     121    def setUp(self):
     122        super(OutstandingCourses2ExporterTest, self).setUp()
     123        self.setup_for_export()
     124        return
     125
     126    def test_export_all(self):
     127        # we can really export all course tickets
     128        # set values we can expect in export file
     129        self.setup_student(self.student)
     130        self.student['studycourse']['100']['CRS1'].course_category = 'C'
     131        exporter = OutstandingCourses2Exporter()
     132        exporter.export_all(self.app, self.outfile)
     133        result = open(self.outfile, 'rb').read()
     134        self.assertEqual(
     135            result,
     136            'student_id,matric_number,certcode,display_fullname,code,'
     137            'course_category,remark\r\n'
     138            'A111111,234,CERT1,"TESTER, Anna M.",CRS1,C,nottaken\r\n'
     139            )
     140        return
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/utils.py

    r18311 r18340  
    3333        return True
    3434    return False
     35
     36    #: A tuple containing all exporter names referring to students or
     37    #: subobjects thereof.
     38    STUDENT_EXPORTER_NAMES = (
     39            'students',
     40            'studentstudycourses',
     41            'studentstudycourses_1',
     42            #'studentstudycourses_2',
     43            'studentstudylevels',
     44            #'studentstudylevels_1',
     45            #'studentstudylevels_2',
     46            'coursetickets',
     47            #'coursetickets_1',
     48            #'coursetickets_2',
     49            'studentpayments',
     50            'bedtickets',
     51            'trimmed',
     52            'outstandingcourses',
     53            'unpaidpayments',
     54            'sfpaymentsoverview',
     55            'sessionpaymentsoverview',
     56            'studylevelsoverview',
     57            'combocard',
     58            'bursary',
     59            'accommodationpayments',
     60            'transcriptdata',
     61            'trimmedpayments',
     62            'outstandingcourses_2'
     63            )
     64
    3565
    3666class CustomStudentsUtils(NigeriaStudentsUtils):
Note: See TracChangeset for help on using the changeset viewer.