- Timestamp:
- 27 Aug 2026, 07:34:00 (3 months ago)
- Location:
- main/kofacustom.unidel/trunk/src/kofacustom/unidel/students
- Files:
-
- 6 added
- 4 edited
-
reports/level_report.py (modified) (3 diffs)
-
reports/tests (added)
-
reports/tests/._test_level_report.py (added)
-
reports/tests/__init__.py (added)
-
reports/tests/__init__.pyc (added)
-
reports/tests/test_level_report.py (added)
-
reports/tests/test_level_report.pyc (added)
-
studylevel.py (modified) (3 diffs)
-
tests/test_export.py (modified) (1 diff)
-
utils.py (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/reports/level_report.py
r18302 r18307 18 18 19 19 import grok 20 import textwrap 20 21 from zope.interface import implementer, Interface, Attribute 22 from zope.component import queryUtility, getUtility 23 from zope.i18n import translate 24 from zope.catalog.interfaces import ICatalog 25 26 from reportlab.lib import colors 27 from reportlab.lib.styles import getSampleStyleSheet 28 from reportlab.lib.units import cm 29 from reportlab.platypus import Paragraph, Table, Spacer 30 from reportlab.platypus.flowables import Flowable 31 32 from waeup.kofa.reports import IReport, IReportGenerator 33 from waeup.kofa.reports import Report 34 from waeup.kofa.browser.interfaces import IPDFCreator 35 from waeup.kofa.browser.pdf import SMALL_PARA_STYLE 36 from waeup.kofa.interfaces import ( 37 IKofaUtils, GRADUATED, 38 academic_sessions_vocab, registration_states_vocab) 39 21 40 from waeup.kofa.students.reports.level_report import ( 22 41 LevelReport, LevelReportGenerator, 23 42 ILevelReport, LevelReportGeneratorPage, 24 LevelReportPDFView) 25 43 LevelReportPDFView, 44 TABLE_STYLE, 45 TTR) 46 47 STYLE = getSampleStyleSheet() 48 49 50 def tbl_data_to_table(data): 51 result = [] 52 col_names = ( 53 'S/N', 54 'Matric No.', 55 'Student Name', 56 TTR('Total Credits Taken'), 57 TTR('Total Credits Passed'), 58 TTR('GPA'), 59 'Courses Failed', 60 'Outstanding Courses', 61 TTR('Cum. Credits Taken'), 62 TTR('Cum. Credits Passed'), 63 TTR('Cum. Credits Required'), 64 TTR('CGPA'), 65 TTR('Remark')) 66 table = [col_names] 67 sn = 1 68 for line in data: 69 # Underline mandatory (core) courses 70 failed_courses = Paragraph( 71 line[5].replace( 72 'm_', '<u>').replace('_m', '</u>'), SMALL_PARA_STYLE) 73 line = line[:5] + (failed_courses,) + line[6:] 74 # Superscript in remarks (needed by AAUE) 75 remark = Paragraph( 76 line[10].replace( 77 's_', '<super>').replace('_s', '</super>'), SMALL_PARA_STYLE) 78 line = line[:10] + (remark,) 79 line = (sn,) + line 80 table.append(line) 81 sn += 1 82 return table 26 83 27 84 # Level Report for graduating students only … … 37 94 """ 38 95 39 # title = 'Summary of Results'40 96 title = 'Level Report (Graduating Students only)' 41 97 42 98 @property 43 99 def right_footer(self): 44 return self.title + ' (Graduating Students)- %s -' % self.session100 return self.title + ' - %s -' % self.session 45 101 46 102 def _excluded(self, level_obj): … … 52 108 if final_level > level_obj.level: 53 109 return True 54 #if level_obj.remark not in ( 55 # 'Pass', '3s_rd_s', '2s_2_s', '2s_1_s', '1s_st_s', 56 # 'Merit', 'Credit', 'Distinction'): 57 # return True 58 #return False 110 if level_obj.remark not in ( 111 'Pass', '3s_rd_s', '2s_2_s', '2s_1_s', '1s_st_s', 112 'Merit', 'Credit', 'Distinction'): 113 return True 114 return False 115 116 def _get_students(self, faccode, depcode, certcode, session, level): 117 """Get students in a certain department, studying a certain programmen 118 who registered courses in a certain session at a certain level. 119 120 Returns a list of student data tuples. 121 """ 122 site = grok.getSite() 123 cat = queryUtility(ICatalog, name="students_catalog") 124 if certcode == 'all': 125 certcode = None 126 result = cat.searchResults( 127 depcode = (depcode, depcode), faccode = (faccode, faccode), 128 certcode = (certcode, certcode) 129 ) 130 table = [] 131 format_float = getUtility(IKofaUtils).format_float 132 for stud in result: 133 if not stud['studycourse'].has_key(str(level)): 134 continue 135 if stud.state == GRADUATED: 136 continue 137 level_obj = stud['studycourse'][str(level)] 138 if level_obj.level_session != session: 139 continue 140 if self._excluded(level_obj): 141 continue 142 passed_params = level_obj.passed_params 143 failed_courses = textwrap.fill(passed_params[4], 35) 144 not_taken_courses = textwrap.fill(passed_params[5], 17) 145 fullname = textwrap.fill(stud.display_fullname, 29) 146 remark = getattr(level_obj, 'remark', '') 147 cert = stud['studycourse'].certificate 148 end_level = getattr(cert, 'end_level', None) 149 tcrg = getattr(cert, 'custom_float_1', None) 150 credits_counted = level_obj.gpa_params[1] 151 credits_passed = passed_params[2] 152 level_gpa = format_float(level_obj.gpa_params[0], 2) 153 cum_credits_taken = level_obj.cumulative_params[1] 154 cum_credits_passed = level_obj.cumulative_params[4] 155 if end_level and level >= end_level: 156 cgpa = format_float(level_obj.cumulative_params[0], 2) 157 else: 158 cgpa = format_float(level_obj.cumulative_params[0], 3) 159 if remark in ('FRNS', 'NER', 'NYV'): 160 cgpa = '' 161 if remark in ('NER', 'NYV'): 162 # hide all data (requestd by AAUE, Nigeria) 163 credits_counted = '' 164 credits_passed = '' 165 level_gpa = '' 166 failed_courses = '' 167 not_taken_courses = '' 168 cum_credits_taken = '' 169 cum_credits_passed = '' 170 line = ( 171 stud.matric_number, 172 fullname, 173 credits_counted, 174 credits_passed, 175 level_gpa, 176 failed_courses, 177 not_taken_courses, 178 cum_credits_taken, 179 cum_credits_passed, 180 tcrg, 181 cgpa, 182 remark, 183 ) 184 table.append(line) 185 return sorted(table, key=lambda value:value[0]) 186 187 def create_pdf(self, job_id): 188 creator = getUtility(IPDFCreator, name=self.pdfcreator) 189 table_data = tbl_data_to_table(self.data) 190 #col_widths = [3.5*cm] * len(self.data[0]) 191 col_widths = [1*cm, 4*cm, 5*cm, 0.8*cm, 0.8*cm, 1*cm, 192 5.2*cm, 3*cm, 0.8*cm, 0.8*cm, 0.8*cm, 1*cm, 2*cm] 193 pdf_data = [Paragraph('<b>%s - Report %s</b>' 194 % (self.creation_dt_string, job_id), 195 STYLE["Normal"]), 196 Spacer(1, 12),] 197 pdf_data += [Paragraph( 198 translate( 199 '${a}<br />${b}<br />${c}<br />' 200 'Session: ${d}<br />Level: ${e}', 201 mapping = {'a':self.certtitle, 202 'b':self.deptitle, 203 'c':self.factitle, 204 'd':self.session, 205 'e':self.level, 206 }), 207 STYLE["Normal"]), 208 Spacer(1, 12),] 209 pdf_data += [ 210 Table(table_data, style=TABLE_STYLE, colWidths=col_widths)] 211 212 pdf_data.append(Spacer(1, 40)) 213 if self.signatures: 214 signaturetables = get_signature_tables( 215 self.signatures, landscape=True) 216 pdf_data.append(signaturetables[0]) 217 218 pdf = creator.create_pdf( 219 pdf_data, None, self.title, self.author, 220 self.right_footer, note = self.note 221 ) 222 return pdf 223 59 224 60 225 class GradLevelReportGenerator(LevelReportGenerator): -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/studylevel.py
r18235 r18307 21 21 """ 22 22 import grok 23 import decimal 23 24 from zope.component.interfaces import IFactory 24 25 from zope.interface import implementedBy … … 30 31 from kofacustom.unidel.students.interfaces import ( 31 32 ICustomStudentStudyLevel, ICustomCourseTicket) 33 from kofacustom.unidel.students.utils import MINIMUM_UNITS_THRESHOLD 32 34 33 35 … … 91 93 total_credits, credits_passed) 92 94 95 @property 96 def passed_params(self): 97 """Determine the number and credits of passed and failed courses. 98 This method is used for level reports. 99 """ 100 passed = failed = 0 101 courses_failed = '' 102 credits_failed = 0 103 credits_passed = 0 104 courses_not_taken = '' 105 courses_passed = '' 106 for ticket in self.values(): 107 if ticket.total_score is not None: 108 if ticket.total_score < ticket.passmark: 109 failed += 1 110 credits_failed += ticket.credits 111 if ticket.mandatory or ticket.course_category == 'C': 112 courses_failed += 'm_%s_m ' % ticket.code 113 else: 114 courses_failed += '%s ' % ticket.code 115 else: 116 passed += 1 117 credits_passed += ticket.credits 118 courses_passed += '%s ' % ticket.code 119 else: 120 courses_not_taken += '%s ' % ticket.code 121 if not len(courses_failed): 122 courses_failed = 'Nil' 123 if not len(courses_not_taken): 124 courses_not_taken = 'Nil' 125 return (passed, failed, credits_passed, 126 credits_failed, courses_failed, 127 courses_not_taken, courses_passed) 128 129 # only AAUE and Unidel 130 @property 131 def remark(self): 132 certificate = getattr(self.__parent__,'certificate',None) 133 end_level = getattr(certificate, 'end_level', None) 134 study_mode = getattr(certificate, 'study_mode', None) 135 tcrg = getattr(certificate, 'custom_float_1', None) 136 value = decimal.Decimal(str(self.cumulative_params[0])) 137 cgpa = round(value,2) 138 #cgpa = self.cumulative_params[0] 139 is_dp = False 140 if study_mode and study_mode.startswith('dp'): 141 is_dp = True 142 failed_limit = 1.5 143 if self.student.entry_session < 2013: 144 failed_limit = 1.0 145 # final level student remark 146 if end_level and self.level >= end_level: 147 if self.level > end_level: 148 # spill-over level 149 if self.gpa_params[1] == 0: 150 # no credits taken 151 return 'NER' 152 elif self.cumulative_params[4] < tcrg: 153 return 'FRNS' 154 if self.level_verdict in ('FRNS', 'NER', 'NYV'): 155 return self.level_verdict 156 if '_m' in self.passed_params[4]: 157 return 'FRNS' 158 if not self.cumulative_params[0]: 159 return 'FRNS' 160 if len(self.passed_params[5]) \ 161 and not self.passed_params[5] == 'Nil': 162 return 'FRNS' 163 if self.cumulative_params[1] < 60: 164 return 'FRNS' 165 if cgpa < failed_limit: 166 return 'Fail' 167 dummy, repeat = divmod(self.level, 100) 168 if cgpa < 5.1 and repeat == 20: 169 # Irrespective of the CGPA of a student, if the He/She has 170 # 3rd Extension, such student will be graduated with a "Pass". 171 return 'Pass' 172 if cgpa < 1.5: 173 if is_dp: 174 return 'Fail' 175 return 'Pass' 176 if cgpa < 2.4: 177 if is_dp: 178 return 'Pass' 179 return '3s_rd_s' 180 if cgpa < 3.5: 181 if is_dp: 182 return 'Merit' 183 return '2s_2_s' 184 if cgpa < 4.5: 185 if is_dp: 186 return 'Credit' 187 return '2s_1_s' 188 if cgpa < 5.1: 189 if is_dp: 190 return 'Distinction' 191 return '1s_st_s' 192 return 'N/A' 193 # returning student remark 194 if self.level_verdict in ('FRNS', 'NER', 'NYV'): 195 return 'Probation' 196 if self.level_verdict == 'D': 197 return 'Withdrawn' 198 if self.gpa_params[1] == 0: 199 # no credits taken 200 return 'NER' 201 if self.gpa_params[1] < MINIMUM_UNITS_THRESHOLD: 202 # credits taken below limit 203 return 'Probation' 204 if cgpa < failed_limit: 205 return 'Probation' 206 if cgpa < 5.1: 207 return 'Proceed' 208 return 'N/A' 209 93 210 CustomStudentStudyLevel = attrs_to_fields( 94 211 CustomStudentStudyLevel, omit=['total_credits', 'gpa', -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_export.py
r18242 r18307 47 47 result = open(self.outfile, 'rb').read() 48 48 self.assertMatches( 49 'adm_code,alr_date,alr_fname,alr_no,alr_results,' 50 'clr_code,date_of_birth,def_adm,disabled,email,email2,emp2_end,' 51 'emp2_position,emp2_reason,emp2_start,emp_end,emp_position,' 52 'emp_reason,emp_start,employer,employer2,' 53 'final_clearance_date,finally_cleared_by,' 54 'financial_clearance_date,financially_cleared_by,' 55 'firstname,flash_notice,former_matric,' 56 'fst_sit_date,fst_sit_fname,fst_sit_no,fst_sit_results,' 57 'fst_sit_type,hq2_degree,hq2_disc,hq2_matric_no,hq2_school,' 58 'hq2_session,hq2_type,hq_degree,hq_disc,hq_fname,hq_matric_no,' 59 'hq_school,hq_session,hq_type,is_staff,lastname,lga,' 60 'marit_stat,matric_number,middlename,nationality,' 61 'next_kin_address,next_kin_name,next_kin_phone,next_kin_relation,' 62 'nysc_lga,nysc_location,nysc_year,officer_comment,parents_email,' 63 'password_updated,perm_address,personal_updated,phone,' 64 'physical_clearance_date,provisionally_cleared,reg_number,' 65 'religion,scd_sit_date,scd_sit_fname,scd_sit_no,' 66 'scd_sit_results,scd_sit_type,sex,student_id,' 67 'suspended,suspended_comment,password,state,history,certcode,is_postgrad,' 68 'current_level,current_session\r\nmy adm code,,,,' 49 'adm_code,alr_date,alr_fname,alr_no,alr_results,clr_code,date_of_birth,' 50 'def_adm,disabled,email,email2,emp2_end,emp2_position,emp2_reason,emp2_start,' 51 'emp_end,emp_position,emp_reason,emp_start,employer,employer2,' 52 'final_clearance_date,finally_cleared_by,financial_clearance_date,' 53 'financially_cleared_by,firstname,flash_notice,former_matric,' 54 'fst_epin,fst_serial_no,fst_sit_date,fst_sit_fname,fst_sit_no,' 55 'fst_sit_results,fst_sit_type,hq2_degree,hq2_disc,hq2_matric_no,' 56 'hq2_school,hq2_session,hq2_type,hq_degree,hq_disc,hq_fname,' 57 'hq_matric_no,hq_school,hq_session,hq_type,is_staff,lastname,' 58 'lga,marit_stat,matric_number,middlename,nationality,next_kin_address,' 59 'next_kin_name,next_kin_phone,next_kin_relation,nin,nysc_lga,' 60 'nysc_location,nysc_year,officer_comment,parents_email,password_updated,' 61 'perm_address,personal_updated,phone,physical_clearance_date,' 62 'provisionally_cleared,reg_number,religion,scd_epin,scd_serial_no,' 63 'scd_sit_date,scd_sit_fname,scd_sit_no,scd_sit_results,scd_sit_type,' 64 'sex,student_id,suspended,suspended_comment,password,state,history,' 65 'certcode,is_postgrad,current_level,current_session\r\nmy adm code,,,,' 69 66 '"[(\'printing_craft_practice\', \'A1\')]",my clr code,1981-02-04#,,,' 70 'anna@sample.com,,,,,,,,,,,,,,,,Anna,,,,,, "[(\'printing_craft_practice\', \'A1\')]"'71 ',,,,,,,,,,,,,,,,Tester,,,234,M.,NG,,,,,,,,,,, '72 '"Studentroad 21\nLagos 123456\n",,+234-123-12345#,,,123,,,,, '67 'anna@sample.com,,,,,,,,,,,,,,,,Anna,,,,,,,,"[(\'printing_craft_practice\', \'A1\')]"' 68 ',,,,,,,,,,,,,,,,Tester,,,234,M.,NG,,,,,,,,,,,,' 69 '"Studentroad 21\nLagos 123456\n",,+234-123-12345#,,,123,,,,,,,' 73 70 '"[(\'printing_craft_practice\', \'A1\')]",,f,A111111,0,,,created,' 74 71 '[u\'2012-11-06 13:16:41 WAT - Record created by system\'],' -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/utils.py
r18287 r18307 23 23 from kofacustom.nigeria.students.utils import NigeriaStudentsUtils 24 24 from kofacustom.unidel.interfaces import MessageFactory as _ 25 26 MINIMUM_UNITS_THRESHOLD = 15 25 27 26 28 def local(student): … … 351 353 return d 352 354 353 def GPABoundaries(self, faccode=None, depcode=None, certcode=None): 354 return ((0.995, 'Fail'), 355 (1.495, 'Pass'), 356 (2.495, '3rd Class'), 357 (3.495, '2nd Class Lower'), 358 (4.495, '2nd Class Upper'), 359 (5, '1st Class')) 355 #def GPABoundaries(self, faccode=None, depcode=None, certcode=None): 356 # return ((0.995, 'Fail'), 357 # (1.495, 'Pass'), 358 # (2.495, '3rd Class'), 359 # (3.495, '2nd Class Lower'), 360 # (4.495, '2nd Class Upper'), 361 # (5, '1st Class')) 362 363 def GPABoundaries(self, faccode=None, depcode=None, 364 certcode=None, student=None): 365 if student and student.current_mode.startswith('dp'): 366 return ((1.5, 'IRNS / NER / NYV'), 367 (2.4, 'Pass'), 368 (3.5, 'Merit'), 369 (4.5, 'Credit'), 370 (5, 'Distinction')) 371 elif student: 372 return ((1, 'FRNS / NER / NYV'), 373 (1.5, 'Pass'), 374 (2.4, '3rd Class Honours'), 375 (3.5, '2nd Class Honours Lower Division'), 376 (4.5, '2nd Class Honours Upper Division'), 377 (5, '1st Class Honours')) 378 # Session Results Presentations depend on certificate 379 results = None 380 if certcode: 381 cat = queryUtility(ICatalog, name='certificates_catalog') 382 results = list( 383 cat.searchResults(code=(certcode, certcode))) 384 if results and results[0].study_mode.startswith('dp'): 385 return ((1.5, 'IRNS / NER / NYV'), 386 (2.4, 'Pass'), 387 (3.5, 'Merit'), 388 (4.5, 'Credit'), 389 (5, 'Distinction')) 390 else: 391 return ((1, 'FRNS / NER / NYV'), 392 (1.5, 'Pass'), 393 (2.4, '3rd Class Honours'), 394 (3.5, '2nd Class Honours Lower Division'), 395 (4.5, '2nd Class Honours Upper Division'), 396 (5, '1st Class Honours')) 360 397 361 398 def getClassFromCGPA(self, gpa, student): 362 """Determine the class of degree. In some custom packages 363 this class depends on e.g. the entry session of the student. In the 364 base package, it does not. 399 gpa_boundaries = self.GPABoundaries(student=student) 400 401 try: 402 certificate = getattr(student['studycourse'],'certificate',None) 403 end_level = getattr(certificate, 'end_level', None) 404 final_level = max([studylevel.level for studylevel in student['studycourse'].values()]) 405 if end_level and final_level >= end_level: 406 dummy, repeat = divmod(final_level, 100) 407 if gpa <= 5.1 and repeat == 20: 408 # Irrespective of the CGPA of a student, if the He/She has 409 # 3rd Extension, such student will be graduated with a "Pass". 410 return 1, gpa_boundaries[1][1] 411 except ValueError: 412 pass 413 value = decimal.Decimal(str(gpa)) 414 gpa = round(value,2) 415 if gpa < gpa_boundaries[0][0]: 416 # FRNS / Fail 417 return 0, gpa_boundaries[0][1] 418 if student.entry_session < 2013 or \ 419 student.current_mode.startswith('dp'): 420 if gpa < gpa_boundaries[1][0]: 421 # Pass 422 return 1, gpa_boundaries[1][1] 423 else: 424 if gpa < gpa_boundaries[1][0]: 425 # FRNS 426 # Pass degree has been phased out in 2013 for non-diploma 427 # students 428 return 0, gpa_boundaries[0][1] 429 if gpa < gpa_boundaries[2][0]: 430 # 3rd / Merit 431 return 2, gpa_boundaries[2][1] 432 if gpa < gpa_boundaries[3][0]: 433 # 2nd L / Credit 434 return 3, gpa_boundaries[3][1] 435 if gpa < gpa_boundaries[4][0]: 436 # 2nd U / Distinction 437 return 4, gpa_boundaries[4][1] 438 if gpa <= gpa_boundaries[5][0]: 439 # 1st 440 return 5, gpa_boundaries[5][1] 441 return 442 443 def getDegreeClassNumber(self, level_obj): 444 """Get degree class number (used for SessionResultsPresentation 445 reports). 365 446 """ 366 if gpa < self.GPABoundaries()[0][0]: 367 return 0, self.GPABoundaries()[0][1] 368 if gpa < self.GPABoundaries()[1][0]: 369 return 1, self.GPABoundaries()[1][1] 370 if gpa < self.GPABoundaries()[2][0]: 371 return 2, self.GPABoundaries()[2][1] 372 if gpa < self.GPABoundaries()[3][0]: 373 return 3, self.GPABoundaries()[3][1] 374 if gpa < self.GPABoundaries()[4][0]: 375 return 4, self.GPABoundaries()[4][1] 376 if gpa <= self.GPABoundaries()[5][0]: 377 return 5, self.GPABoundaries()[5][1] 378 return 447 certificate = getattr(level_obj.__parent__,'certificate', None) 448 end_level = getattr(certificate, 'end_level', None) 449 if level_obj.level_verdict in ('FRNS', 'NER', 'NYV'): 450 return 0 451 if end_level and level_obj.level >= end_level: 452 if level_obj.level > end_level: 453 # spill-over level 454 if level_obj.gpa_params[1] == 0: 455 # no credits taken 456 return 0 457 elif level_obj.gpa_params[1] < MINIMUM_UNITS_THRESHOLD: 458 # credits taken below limit 459 return 0 460 failed_courses = level_obj.passed_params[4] 461 not_taken_courses = level_obj.passed_params[5] 462 if '_m' in failed_courses: 463 return 0 464 if len(not_taken_courses) \ 465 and not not_taken_courses == 'Nil': 466 return 0 467 elif level_obj.gpa_params[1] < MINIMUM_UNITS_THRESHOLD: 468 # credits taken below limit 469 return 0 470 # use gpa_boundaries above 471 return self.getClassFromCGPA( 472 level_obj.cumulative_params[0], level_obj.student)[0] 473 474 475 #def getClassFromCGPA(self, gpa, student): 476 # """Determine the class of degree. In some custom packages 477 # this class depends on e.g. the entry session of the student. In the 478 # base package, it does not. 479 # """ 480 # if gpa < self.GPABoundaries()[0][0]: 481 # return 0, self.GPABoundaries()[0][1] 482 # if gpa < self.GPABoundaries()[1][0]: 483 # return 1, self.GPABoundaries()[1][1] 484 # if gpa < self.GPABoundaries()[2][0]: 485 # return 2, self.GPABoundaries()[2][1] 486 # if gpa < self.GPABoundaries()[3][0]: 487 # return 3, self.GPABoundaries()[3][1] 488 # if gpa < self.GPABoundaries()[4][0]: 489 # return 4, self.GPABoundaries()[4][1] 490 # if gpa <= self.GPABoundaries()[5][0]: 491 # return 5, self.GPABoundaries()[5][1] 492 # return
Note: See TracChangeset for help on using the changeset viewer.
