- Timestamp:
- 28 Aug 2026, 21:50:22 (3 months ago)
- Location:
- main/kofacustom.unidel/trunk/src/kofacustom/unidel
- Files:
-
- 1 added
- 9 edited
-
interfaces.py (modified) (2 diffs)
-
locales/en/LC_MESSAGES/waeup.kofa.po (modified) (1 diff)
-
students/batching.py (modified) (1 diff)
-
students/browser.py (modified) (9 diffs)
-
students/browser_templates/editscorespage.pt (added)
-
students/export.py (modified) (1 diff)
-
students/interfaces.py (modified) (3 diffs)
-
students/reports/level_report.py (modified) (3 diffs)
-
students/tests/test_browser.py (modified) (4 diffs)
-
utils/utils.py (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
main/kofacustom.unidel/trunk/src/kofacustom/unidel/interfaces.py
r18282 r18313 21 21 from zc.sourcefactory.basic import BasicSourceFactory 22 22 from waeup.kofa.interfaces import (SimpleKofaVocabulary, 23 ISessionConfiguration, academic_sessions_vocab) 23 ISessionConfiguration, academic_sessions_vocab, 24 ContextualDictSourceFactoryBase) 24 25 25 26 _ = MessageFactory = zope.i18nmessageid.MessageFactory('kofacustom.unidel') 27 28 class EnableScoreEditingGroupSource(ContextualDictSourceFactoryBase): 29 """A source for filtering groups of students 30 """ 31 DICT_NAME = 'ENABLE_SCORE_EDITING_GROUP_DICT' 26 32 27 33 class ICustomSessionConfiguration(ISessionConfiguration): … … 190 196 default = 0.0, 191 197 required = False, 198 ) 199 200 score_editing_enabled = schema.List( 201 title = _(u'Score editing enabled'), 202 value_type = schema.Choice( 203 source = EnableScoreEditingGroupSource(), 204 ), 205 required = False, 206 defaultFactory=list, 192 207 ) 193 208 -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/locales/en/LC_MESSAGES/waeup.kofa.po
r18305 r18313 28 28 msgid "Custom Float 1 (not used)" 29 29 msgstr "Minimum Graduation Credit Units" 30 31 msgid "Remark" 32 msgstr "Remark / Class of Degree (Grad.)" -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/batching.py
r17025 r18313 68 68 'level_session', 'outstanding', 'course_category', 69 69 'title', 'credits', 'passmark', 'semester', 'ticket_session', 70 ' unlock_score', 'previous'70 'imported_ts', 'unlock_score', 'previous' 71 71 ] + self.additional_fields 72 72 return sorted(fields) -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser.py
r18301 r18313 17 17 ## 18 18 import grok 19 import csv 20 import textwrap 21 from cStringIO import StringIO 19 22 from zope.i18n import translate 20 23 from zope.schema.interfaces import ConstraintNotSatisfied 21 from zope.component import getUtility 24 from zope.component import getUtility, queryUtility 25 from zope.catalog.interfaces import ICatalog 22 26 from zope.security import checkPermission 23 27 from zope.formlib.textwidgets import BytesDisplayWidget 24 28 from hurry.workflow.interfaces import IWorkflowInfo 25 from waeup.kofa.interfaces import REQUESTED, IExtFileStore, IKofaUtils 29 from waeup.kofa.interfaces import ( 30 REQUESTED, IExtFileStore, IKofaUtils, academic_sessions_vocab) 26 31 from waeup.kofa.widgets.datewidget import FriendlyDatetimeDisplayWidget 27 32 from waeup.kofa.browser.layout import KofaEditFormPage … … 30 35 CLEARANCE, REQUESTED, RETURNING, CLEARED, REGISTERED, VALIDATED, 31 36 GRADUATED, TRANSREQ, TRANSVAL, TRANSREL, FORBIDDEN_POSTGRAD_TRANS) 32 from waeup.kofa.students.browser import (33 StudyLevelEditFormPage, StudyLevelDisplayFormPage, StudyLevelManageFormPage,34 StudentBasePDFFormPage, ExportPDFCourseRegistrationSlip,35 CourseTicketDisplayFormPage, CourseTicketManageFormPage,36 StudentTriggerTransitionFormPage,37 ExportPDFAdmissionSlip,38 ExportAttendanceSlip,39 ExportPDFTranscriptSlip,40 PaymentsManageFormPage, msave, emit_lock_message)41 37 from waeup.kofa.students.interfaces import IStudentsUtils, ICourseTicket, IStudentBase 42 38 from waeup.kofa.students.workflow import FORBIDDEN_POSTGRAD_TRANS 39 from waeup.kofa.students.browser import ( 40 StartClearancePage, 41 StudentBasePDFFormPage, 42 CourseTicketAddFormPage, 43 StudyLevelDisplayFormPage, 44 StudyLevelManageFormPage, 45 StudyLevelEditFormPage, 46 ExportPDFTranscriptSlip, 47 ExportPDFAdmissionSlip, 48 StudentFilesUploadPage, 49 PaymentsManageFormPage, 50 CourseTicketDisplayFormPage, 51 CourseTicketManageFormPage, 52 EditScoresPage, 53 ExportPDFScoresSlip, 54 StudyCourseTranscriptPage, 55 DownloadScoresView, 56 StudentRequestPasswordPage, 57 StudyCourseManageFormPage, 58 UnregisterCoursesView, 59 addCourseTicket, 60 AddStudyLevelFormPage, 61 ExportPDFCourseRegistrationSlip, 62 ExportAttendanceSlip, 63 emit_lock_message,) 43 64 from kofacustom.nigeria.students.browser import ( 44 65 NigeriaOnlinePaymentDisplayFormPage, … … 66 87 from kofacustom.unidel.interfaces import MessageFactory as _ 67 88 89 90 def translated_values(view): 91 """Translate course ticket attribute values to be displayed on 92 studylevel pages. 93 """ 94 lang = view.request.cookies.get('kofa.language') 95 for value in view.context.values(): 96 value._p_activate() 97 value_dict = dict([i for i in value.__dict__.items()]) 98 value_dict['url'] = view.url(value) 99 value_dict['removable_by_student'] = value.removable_by_student 100 value_dict['mandatory'] = translate(str(value.mandatory), 'zope', 101 target_language=lang) 102 value_dict['carry_over'] = translate(str(value.carry_over), 'zope', 103 target_language=lang) 104 value_dict['outstanding'] = translate(str(value.outstanding), 'zope', 105 target_language=lang) 106 value_dict['automatic'] = translate(str(value.automatic), 'zope', 107 target_language=lang) 108 value_dict['grade'] = value.grade 109 value_dict['weight'] = value.weight 110 value_dict['course_category'] = value.course_category 111 value_dict['total_score'] = value.total_score 112 semester_dict = getUtility(IKofaUtils).SEMESTER_DICT 113 value_dict['semester'] = semester_dict[ 114 value.semester].replace('mester', 'm.') 115 # Unidel specific 116 value_dict['formatted_total_score'] = value.total_score 117 if getattr(value, 'imported_ts', None): 118 value_dict['formatted_total_score'] = "<strong>%s</strong>" % value.imported_ts 119 yield value_dict 120 68 121 class CustomStudentBaseDisplayFormPage(NigeriaStudentBaseDisplayFormPage): 69 122 """ Page to display student base data … … 235 288 form_fields['payment_date'].custom_widget = FriendlyDatetimeDisplayWidget('le') 236 289 290 class CustomStudyCourseManageFormPage(StudyCourseManageFormPage): 291 """ Page to edit the student study course data 292 """ 293 grok.context(ICustomStudentStudyCourse) 294 295 @property 296 def form_fields(self): 297 if self.context.is_postgrad: 298 form_fields = grok.AutoFields(ICustomStudentStudyCourse).omit( 299 'previous_verdict') 300 else: 301 form_fields = grok.AutoFields(ICustomStudentStudyCourse) 302 form_fields['imported_cgpa'].for_display = True 303 return form_fields 304 237 305 class CustomStudyLevelDisplayFormPage(StudyLevelDisplayFormPage): 238 306 """ Page to display student study levels … … 242 310 243 311 form_fields = grok.AutoFields(ICustomStudentStudyLevel).omit( 244 'level', )312 'level','imported_gpa', 'imported_cgpa') 245 313 form_fields[ 246 314 'validation_date'].custom_widget = FriendlyDatetimeDisplayWidget('le') … … 254 322 'validation_date', 'validated_by', 'total_credits', 'gpa', 'level', 255 323 'total_credits_s1', 'total_credits_s2') 324 form_fields['imported_gpa'].for_display = True 325 form_fields['imported_cgpa'].for_display = True 256 326 257 327 class CustomExportPDFCourseRegistrationSlip(ExportPDFCourseRegistrationSlip): … … 267 337 'password', 'suspended', 'phone', 'date_of_birth', 268 338 'adm_code', 'sex', 'suspended_comment', 'current_level', 269 'flash_notice' )339 'flash_notice', 'imported_gpa', 'imported_cgpa',) 270 340 271 341 def _signatures(self): … … 348 418 form_fields['carry_over'].for_display = True 349 419 form_fields['ticket_session'].for_display = True 420 form_fields['imported_ts'].for_display = True 350 421 351 422 … … 519 590 return 520 591 return pdfstream 592 593 class CustomEditScoresPage(EditScoresPage): 594 """Page that filters and lists students. 595 """ 596 grok.template('editscorespage') 597 598 def _searchCatalog(self, session): 599 cat = queryUtility(ICatalog, name='coursetickets_catalog') 600 coursetickets = cat.searchResults( 601 session=(session, session), 602 code=(self.context.code, self.context.code) 603 ) 604 try: 605 score_editing_enabled = grok.getSite()[ 606 'configuration'][str(session)].score_editing_enabled 607 except KeyError: 608 return [] 609 coursetickets_list = [courseticket for courseticket in coursetickets 610 if courseticket.student.current_mode in score_editing_enabled] 611 return coursetickets_list 612 613 def _extract_uploadfile(self, uploadfile): 614 """Get a mapping of student-ids to scores. 615 616 The mapping is constructed by reading contents from `uploadfile`. 617 618 We expect uploadfile to be a regular CSV file with columns 619 ``student_id``, ``score``, ``imported_ts`` 620 and ``ca`` (other cols are ignored). 621 """ 622 result = dict() 623 data = StringIO(uploadfile.read()) # ensure we have something seekable 624 reader = csv.DictReader(data) 625 for row in reader: 626 if not ('student_id' in row and 'score' in row and 'ca' in row and 627 'imported_ts' in row): 628 continue 629 result[row['student_id']] = ( 630 row['score'], row['ca'], row['imported_ts']) 631 return result 632 633 def _update_scores(self, form): 634 ob_class = self.__implemented__.__name__.replace('waeup.kofa.', '') 635 error = '' 636 if 'UPDATE_FILE' in form: 637 if form['uploadfile']: 638 try: 639 formvals = self._extract_uploadfile(form['uploadfile']) 640 except: 641 self.flash( 642 _('Uploaded file contains illegal data. Ignored'), 643 type="danger") 644 return False 645 else: 646 self.flash( 647 _('No file provided.'), type="danger") 648 return False 649 else: 650 formvals = dict(zip(form['sids'], zip( 651 form['scores'], form['cas'], form['imported_ts']))) 652 for ticket in self.editable_tickets: 653 ticket_error = False 654 score = ticket.score 655 ca = ticket.ca 656 imported_ts = ticket.imported_ts 657 sid = ticket.student.student_id 658 if sid not in formvals: 659 continue 660 if formvals[sid][0] == '': 661 score = None 662 if formvals[sid][1] == '': 663 ca = None 664 if formvals[sid][2] == '': 665 imported_ts = None 666 try: 667 if formvals[sid][0]: 668 score = int(formvals[sid][0]) 669 if formvals[sid][1]: 670 ca = int(formvals[sid][1]) 671 if formvals[sid][2]: 672 imported_ts = int(formvals[sid][2]) 673 except ValueError: 674 error += '%s, ' % ticket.student.display_fullname 675 ticket_error = True 676 if score and ca and not ticket_error and score + ca > 100: 677 error += '%s, ' % ticket.student.display_fullname 678 ticket_error = True 679 if not ticket_error and ticket.score != score: 680 try: 681 ticket.score = score 682 except TooBig: 683 error += '%s, ' % ticket.student.display_fullname 684 ticket_error = True 685 pass 686 ticket.student.__parent__.logger.info( 687 '%s - %s %s/%s score updated (%s)' % 688 (ob_class, ticket.student.student_id, 689 ticket.level, ticket.code, score)) 690 if not ticket_error and ticket.ca != ca: 691 try: 692 ticket.ca = ca 693 except TooBig: 694 error += '%s, ' % ticket.student.display_fullname 695 pass 696 ticket.student.__parent__.logger.info( 697 '%s - %s %s/%s ca updated (%s)' % 698 (ob_class, ticket.student.student_id, 699 ticket.level, ticket.code, ca)) 700 if not ticket_error and ticket.imported_ts != imported_ts: 701 try: 702 ticket.imported_ts = imported_ts 703 except TooBig: 704 error += '%s, ' % ticket.student.display_fullname 705 pass 706 ticket.student.__parent__.logger.info( 707 '%s - %s %s/%s imported_ts updated (%s)' % 708 (ob_class, ticket.student.student_id, 709 ticket.level, ticket.code, imported_ts)) 710 if error: 711 self.flash(_('Error: Score(s), CA(s) and Imported TS(s) of %s have not be updated. ' 712 % error.strip(', ')), type="danger") 713 return True 714 715 class CustomExportPDFScoresSlip(ExportPDFScoresSlip): 716 """Deliver a PDF slip of course tickets for a lecturer. 717 """ 718 719 note = u'\nUpgraded scores are with asterisks.' 720 721 def data(self, session): 722 #site = grok.getSite() 723 cat = queryUtility(ICatalog, name='coursetickets_catalog') 724 coursetickets = cat.searchResults( 725 session=(session, session), 726 code=(self.context.code, self.context.code) 727 ) 728 # Apply filter 729 try: 730 score_editing_enabled = grok.getSite()[ 731 'configuration'][str(session)].score_editing_enabled 732 if checkPermission('waeup.manageAcademics', self.context): 733 score_editing_enabled = True 734 coursetickets_filtered = [courseticket 735 for courseticket in coursetickets 736 if (checkPermission('waeup.manageAcademics', self.context) 737 or (courseticket.student.current_mode in 738 score_editing_enabled)) 739 and courseticket.total_score is not None 740 and courseticket.__parent__.__parent__.is_current] 741 except KeyError: 742 coursetickets_filtered = coursetickets 743 # In AAUE only editable tickets can be printed (deactivated on 02/10/19) 744 #editable_tickets = [ 745 # ticket for ticket in coursetickets_filtered 746 # if ticket.editable_by_lecturer] 747 header = [[_(''), 748 _('Student Id'), 749 _('Matric No.'), 750 #_('Reg. No.'), 751 #_('Fullname'), 752 #_('Status'), 753 #_('Course of\nStudies'), 754 _('Department'), 755 _('Level'), 756 _(' CA '), 757 _('Exam\nScore'), 758 _('Total '), 759 _('Grade'), 760 ],] 761 sorted_tickets = sorted(coursetickets_filtered, # editable_tickets, 762 key=lambda ticket: str(ticket.student.depcode) 763 + str(ticket.student.faccode) 764 + str(ticket.student.matric_number) 765 ) 766 no = 1 767 tickets = [] 768 passed = 0 769 failed = 0 770 with_ca = False 771 grade_stats = {'A':0, 'B':0, 'C':0, 'D':0, 'E':0, 'F':0, } 772 for ticket in sorted_tickets: 773 if ticket.ca > 0: 774 with_ca = True 775 total = ticket.total_score 776 if getattr(ticket, 'imported_ts', None): 777 total = "**%s**" % ticket.imported_ts 778 grade = ticket._getGradeWeightFromScore[0] 779 if grade in grade_stats.keys(): 780 grade_stats[grade] += 1 781 if grade in ('F', '-'): 782 failed += 1 783 else: 784 passed += 1 785 fullname = textwrap.fill(ticket.student.display_fullname, 30) 786 #deptitle = site['faculties'][ticket.student.faccode][ 787 # ticket.student.depcode].longtitle 788 row = [str(no), 789 ticket.student.student_id, 790 ticket.student.matric_number, 791 #ticket.student.reg_number, 792 #fullname, 793 #ticket.student.translated_state, 794 #ticket.student.certcode, 795 str(ticket.student.faccode) + ' / ' + str(ticket.student.depcode), 796 ticket.level, 797 ticket.ca, 798 ticket.score, 799 total, 800 grade, 801 ] 802 tickets.append(row) 803 no += 1 804 total = passed + failed 805 passed_perc = 0 806 failed_perc = 0 807 if total: 808 passed_perc = round(100.0 * passed / total) 809 failed_perc = round(100.0 * failed / total) 810 dep = self.context.__parent__.__parent__.longtitle 811 fac = self.context.__parent__.__parent__.__parent__.longtitle 812 # remove CA column if not necessary 813 if not with_ca: 814 header = [[_(''), 815 _('Student Id'), 816 _('Matric No.'), 817 #_('Reg. No.'), 818 #_('Fullname'), 819 #_('Status'), 820 #_('Course of\nStudies'), 821 _('Department'), 822 _('Level'), 823 #_(' CA '), 824 _('Exam\nScore'), 825 _('Total '), 826 _('Grade'), 827 ],] 828 for ticket in tickets: 829 del(ticket[5]) 830 return header + tickets, [ 831 dep, fac, total, passed, passed_perc, failed, failed_perc, grade_stats] 832 833 def render(self): 834 session = grok.getSite()['configuration'].current_academic_session 835 lecturers = [i['user_title'] for i in self.getUsersWithLocalRoles() 836 if i['local_role'] == 'waeup.local.Lecturer'] 837 lecturers = sorted(lecturers) 838 lecturers = ', '.join(lecturers) 839 students_utils = getUtility(IStudentsUtils) 840 # only orientation is different 841 return students_utils.renderPDFCourseticketsOverview( 842 self, 'coursetickets', 843 session, self.data(session), lecturers, '', 45, self.note) -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py
r18068 r18313 98 98 """ 99 99 100 fields = ('matric_number', 'student_id', 'display_fullname', 101 'faccode', 'certcode', 'state', 102 'level', 'code', 'level_session', 'score') 100 fields = ('matric_number', 'student_id','display_fullname', 101 'depcode', 'faccode', 'certcode', 'state', 102 'level', 'code', 'level_session', 'ca', 'score', 103 'total_score', 'grade', 'imported_ts') 104 103 105 104 106 def mangle_value(self, value, name, context=None): -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/interfaces.py
r18297 r18313 116 116 """ 117 117 118 imported_cgpa = schema.Float( 119 title = _(u'Imported Cumulative GPA'), 120 required = False, 121 ) 122 118 123 class ICustomStudentStudyLevel(INigeriaStudentStudyLevel): 119 124 """A container for course tickets. … … 135 140 required = False, 136 141 ) 142 143 imported_gpa = schema.Float( 144 title = _(u'Imported Level GPA'), 145 required = False, 146 ) 147 148 imported_cgpa = schema.Float( 149 title = _(u'Imported Cumulative GPA'), 150 required = False, 151 ) 152 137 153 138 154 class ICustomStudentOnlinePayment(ICustomOnlinePayment): … … 178 194 ) 179 195 196 imported_ts = schema.Int( 197 title = _(u'Imported Total Score'), 198 default = None, 199 required = False, 200 missing_value = None, 201 max = 100, 202 ) 203 180 204 ICustomCourseTicket['score'].order = INigeriaCourseTicket['score'].order 181 205 ICustomCourseTicket['ca'].order = ICustomCourseTicket['score'].order -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/reports/level_report.py
r18312 r18313 62 62 TTR('Cum. Credits Required'), 63 63 TTR('CGPA'), 64 TTR('Remark '))64 TTR('Remark / Class of Degree (Grad.)')) 65 65 table = [col_names] 66 66 sn = 1 … … 85 85 """ 86 86 """ 87 88 title = 'Summary of Results' 87 89 88 90 def _get_students(self, faccode, depcode, certcode, session, level): … … 217 219 """ 218 220 219 title = ' Level Report(Graduating Students only)'221 title = 'Summary of Results (Graduating Students only)' 220 222 221 223 @property -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_browser.py
r17906 r18313 19 19 import shutil 20 20 import tempfile 21 import grok 21 22 from StringIO import StringIO 22 23 from hurry.workflow.interfaces import IWorkflowState, IWorkflowInfo … … 24 25 from zope.securitypolicy.interfaces import IPrincipalRoleManager 25 26 from zope.component.hooks import setSite, clearSite 26 from zope.component import getUtility, createObject 27 from zope.component import getUtility, createObject, queryUtility 27 28 from zope.interface import verify 28 29 from zope.event import notify 30 from zope.catalog.interfaces import ICatalog 29 31 from waeup.kofa.authentication import LocalRoleSetEvent 30 32 from waeup.kofa.app import University … … 40 42 from kofacustom.unidel.testing import FunctionalLayer 41 43 44 UPLOAD_CSV_TEMPLATE = ( 45 'matric_number,student_id,display_fullname,level,code,level_session,' 46 'score,ca,imported_ts\r\n' 47 '234,D1000000,Anna Tester,100,COURSE1,2004,%s,%s,%s\r\n') 42 48 43 49 class StudentsContainerUITests(StudentsFullSetup): … … 122 128 open(path, 'wb').write(self.browser.contents) 123 129 print "Sample PDF attendance.pdf written to %s" % path 130 131 class OfficerUITests(StudentsFullSetup): 132 # Tests for Student class views and pages 133 134 layer = FunctionalLayer 135 136 def setUp(self): 137 super(OfficerUITests, self).setUp() 138 self.app['faculties']['fac1']['dep1'].certificates[ 139 'CERT1']['COURSE1_100'].course_category = 'C' 140 141 def login_as_lecturer(self): 142 self.app['users'].addUser('mrslecturer', 'mrslecturerSecret1') 143 self.app['users']['mrslecturer'].email = 'mrslecturer@foo.ng' 144 self.app['users']['mrslecturer'].title = u'Mercedes Benz' 145 # Add course ticket 146 studylevel = createObject(u'waeup.StudentStudyLevel') 147 studylevel.level = 100 148 studylevel.level_session = 2004 149 self.student['studycourse'].addStudentStudyLevel( 150 self.certificate, studylevel) 151 # Assign local Lecturer role for a certificate. 152 course = self.app['faculties']['fac1']['dep1'].courses['COURSE1'] 153 prmlocal = IPrincipalRoleManager(course) 154 prmlocal.assignRoleToPrincipal('waeup.local.Lecturer', 'mrslecturer') 155 notify(LocalRoleSetEvent( 156 course, 'waeup.local.Lecturer', 'mrslecturer', granted=True)) 157 # Login as lecturer. 158 self.browser.open(self.login_path) 159 self.browser.getControl(name="form.login").value = 'mrslecturer' 160 self.browser.getControl( 161 name="form.password").value = 'mrslecturerSecret1' 162 self.browser.getControl("Login").click() 163 # Store reused urls/paths 164 self.course_url = ( 165 'http://localhost/app/faculties/fac1/dep1/courses/COURSE1') 166 self.edit_scores_url = '%s/edit_scores' % self.course_url 167 self.edit_prev_scores_url = '%s/edit_prev_scores' % self.course_url 168 # Set standard parameters 169 self.app['configuration'].current_academic_session = 2004 170 self.app['faculties']['fac1']['dep1'].score_editing_disabled = False 171 IWorkflowState(self.student).setState(VALIDATED) 172 173 174 def test_gpa_calculation(self): 175 studylevel = createObject(u'waeup.StudentStudyLevel') 176 studylevel.level = 100 177 studylevel.level_session = 2005 178 self.student['studycourse'].entry_mode = 'ug_ft' 179 self.student['studycourse'].addStudentStudyLevel( 180 self.certificate, studylevel) 181 # First course has been added automatically. 182 # Set score. 183 studylevel['COURSE1'].score = 35 184 studylevel['COURSE1'].ca = 20 185 # GPA is 3.0. 186 self.assertEqual(studylevel.gpa_params[0], 3.0) 187 courseticket = createObject('waeup.CourseTicket') 188 courseticket.code = 'ANYCODE' 189 courseticket.title = u'Any TITLE' 190 courseticket.credits = 13 191 courseticket.score = 44 192 courseticket.ca = 22 193 courseticket.semester = 1 194 courseticket.dcode = u'ANYDCODE' 195 courseticket.fcode = u'ANYFCODE' 196 studylevel['COURSE2'] = courseticket 197 # total credits 198 self.assertEqual(self.student['studycourse']['100'].gpa_params[1], 23) 199 # weigheted credits = 3 * 10 + 4 * 13 200 self.assertEqual(self.student['studycourse']['100'].gpa_params[2], 82.0) 201 # sgpa = 82 / 23 202 self.assertEqual( 203 self.student['studycourse']['100'].gpa_params[0], 3.5652173913043477) 204 # imported gpa values override calculated values 205 studylevel.imported_gpa = 4.3 206 studylevel.imported_cgpa = 5.4 207 self.assertEqual(self.student['studycourse']['100'].gpa_params[0], 4.3) 208 self.assertEqual( 209 self.student['studycourse']['100'].cumulative_params[0], 5.4) 210 self.assertEqual(self.student['studycourse']['100'].gpa, '4.30') 211 self.student['studycourse'].imported_cgpa = 6.6 212 self.assertEqual( 213 self.student['studycourse'].getTranscriptData()[1], 6.6) 214 return 215 216 def test_scores_csv_upload_available(self): 217 # lecturers can upload a CSV file to set values. 218 self.login_as_lecturer() 219 # set value to change from 220 self.student['studycourse']['100']['COURSE1'].score = 55 221 self.app['configuration']['2004'].score_editing_enabled = ['ug_ft'] 222 self.browser.open(self.edit_scores_url) 223 upload_ctrl = self.browser.getControl(name='uploadfile:file') 224 upload_file = StringIO(UPLOAD_CSV_TEMPLATE % ('65','52','77')) 225 upload_ctrl.add_file(upload_file, 'text/csv', 'myscores.csv') 226 self.browser.getControl("Update editable scores from").click() 227 self.assertTrue('Anna Tester have not be updated' in self.browser.contents) 228 # values have not been changed 229 self.assertEqual( 230 self.student['studycourse']['100']['COURSE1'].score, 55) 231 self.assertEqual( 232 self.student['studycourse']['100']['COURSE1'].ca, None) 233 self.assertEqual( 234 self.student['studycourse']['100']['COURSE1'].imported_ts, None) 235 self.browser.open(self.edit_scores_url) 236 upload_ctrl = self.browser.getControl(name='uploadfile:file') 237 upload_file = StringIO(UPLOAD_CSV_TEMPLATE % ('65','22','77')) 238 upload_ctrl.add_file(upload_file, 'text/csv', 'myscores.csv') 239 self.browser.getControl("Update editable scores from").click() 240 # values changed 241 self.assertEqual( 242 self.student['studycourse']['100']['COURSE1'].score, 65) 243 self.assertEqual( 244 self.student['studycourse']['100']['COURSE1'].ca, 22) 245 self.assertEqual( 246 self.student['studycourse']['100']['COURSE1'].imported_ts, 77) 247 248 def test_lecturers_can_download_course_tickets(self): 249 # A course ticket slip can be downloaded 250 self.login_as_lecturer() 251 self.course.title = (u'Lorem ipsum dolor sit amet, consectetur ' 252 u'adipisici elit, sed eiusmod tempor incidunt') 253 self.student['studycourse']['100']['COURSE1'].score = 55 254 self.student['studycourse']['100']['COURSE1'].ca = 11 255 self.student.matric_number = u'CMS/FBM/NSG/16/28838' 256 self.app['configuration']['2004'].score_editing_enabled = ['ug_ft'] 257 pdf_url = '%s/coursetickets.pdf' % self.course_url 258 self.browser.open(pdf_url) 259 self.assertEqual(self.browser.headers['Status'], '200 Ok') 260 self.assertEqual( 261 self.browser.headers['Content-Type'], 'application/pdf') 262 path = os.path.join(samples_dir(), 'coursetickets.pdf') 263 open(path, 'wb').write(self.browser.contents) 264 print "Sample PDF coursetickets.pdf written to %s" % path 265 # The CA column is not shown if CA is not used 266 self.student['studycourse']['100']['COURSE1'].ca = 0 267 self.browser.open(pdf_url) 268 path = os.path.join(samples_dir(), 'coursetickets_wo_ca.pdf') 269 open(path, 'wb').write(self.browser.contents) 270 print "Sample PDF coursetickets_wo_ca.pdf written to %s" % path 271 272 def test_lecturers_do_only_see_selected_students(self): 273 # A course ticket slip can be downloaded 274 self.login_as_lecturer() 275 self.student['studycourse']['100']['COURSE1'].score = 55 276 self.student['studycourse']['100']['COURSE1'].ca = 11 277 self.browser.open(self.edit_scores_url) 278 self.assertTrue('No student found' in self.browser.contents) 279 pdf_url = '%s/coursetickets.pdf' % self.course_url 280 self.browser.open(pdf_url) 281 self.assertEqual(self.browser.headers['Status'], '200 Ok') 282 self.assertEqual( 283 self.browser.headers['Content-Type'], 'application/pdf') 284 path = os.path.join(samples_dir(), 'coursetickets_filtered.pdf') 285 open(path, 'wb').write(self.browser.contents) 286 print "Sample PDF coursetickets_filtered.pdf written to %s" % path 287 self.app['configuration']['2004'].score_editing_enabled = ['ug_ft'] 288 self.browser.open(self.edit_scores_url) 289 self.assertFalse('No student found' in self.browser.contents) 290 self.assertTrue('Anna Tester' in self.browser.contents) 291 292 def test_lecturers_can_download_attendance_sheet(self): 293 # A course ticket slip can be downloaded 294 self.course.title = (u'Lorem ipsum dolor sit amet, consectetur adipisici, ' 295 u'sed eiusmod tempor incidunt ut labore et dolore') 296 self.student.firstname = u'Emmanuella Woyengifigha Mercy Onosemudiana' 297 self.student.lastname = u'OYAKEMIEGBEGHA' 298 self.student.matric_number = u'CMS/FBM/NSG/17/38186' 299 self.login_as_lecturer() 300 pdf_url = '%s/attendance.pdf' % self.course_url 301 self.browser.open(pdf_url) 302 self.assertEqual(self.browser.headers['Status'], '200 Ok') 303 self.assertEqual( 304 self.browser.headers['Content-Type'], 'application/pdf') 305 path = os.path.join(samples_dir(), 'attendance.pdf') 306 open(path, 'wb').write(self.browser.contents) 307 print "Sample PDF attendance.pdf written to %s" % path -
main/kofacustom.unidel/trunk/src/kofacustom/unidel/utils/utils.py
r18289 r18313 125 125 } 126 126 127 ENABLE_SCORE_EDITING_GROUP_DICT = STUDY_MODES_DICT 128 127 129 APP_CATS_DICT = { 128 130 'basic': 'UAS, PUTME, PCE, PRENCE',
Note: See TracChangeset for help on using the changeset viewer.
