- Timestamp:
- 29 Sep 2026, 07:31:22 (8 weeks ago)
- 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 18 18 """Exporters for student related stuff. 19 19 """ 20 import grok 20 21 from waeup.kofa.students.export import DataForLecturerExporter 22 23 from zope.component import getUtility, createObject 24 25 from waeup.kofa.students.export import (get_levels, 26 DataForLecturerExporter, StudentExporterBase,) 27 28 from waeup.kofa.utils.batching import ExporterBase 29 21 30 from kofacustom.unidel.students.interfaces import ( 22 31 ICustomStudent, … … 32 41 NigeriaStudentPaymentExporter) 33 42 from waeup.kofa.utils.helpers import iface_names 43 44 45 def 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 34 108 35 109 class CustomStudentExporter(NigeriaStudentExporter): … … 121 195 value, name, context=context) 122 196 197 class 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 8 8 from kofacustom.unidel.utils.utils import CustomKofaUtils 9 9 from kofacustom.unidel.students.export import ( 10 CustomStudentExporter, CustomStudentPaymentExporter) 10 CustomStudentExporter, CustomStudentPaymentExporter, 11 OutstandingCourses2Exporter) 11 12 from kofacustom.unidel.testing import FunctionalLayer 12 13 … … 113 114 ) 114 115 return 116 117 class 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 33 33 return True 34 34 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 35 65 36 66 class CustomStudentsUtils(NigeriaStudentsUtils):
Note: See TracChangeset for help on using the changeset viewer.
