Ignore:
Timestamp:
28 Aug 2026, 21:50:22 (3 months ago)
Author:
Henrik Bettermann
Message:

Implement the import of total score and gpas.

Location:
main/kofacustom.unidel/trunk/src/kofacustom/unidel
Files:
1 added
9 edited

Legend:

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

    r18282 r18313  
    2121from zc.sourcefactory.basic import BasicSourceFactory
    2222from waeup.kofa.interfaces import (SimpleKofaVocabulary,
    23     ISessionConfiguration, academic_sessions_vocab)
     23    ISessionConfiguration, academic_sessions_vocab,
     24    ContextualDictSourceFactoryBase)
    2425
    2526_ = MessageFactory = zope.i18nmessageid.MessageFactory('kofacustom.unidel')
     27
     28class EnableScoreEditingGroupSource(ContextualDictSourceFactoryBase):
     29    """A source for filtering groups of students
     30    """
     31    DICT_NAME = 'ENABLE_SCORE_EDITING_GROUP_DICT'
    2632
    2733class ICustomSessionConfiguration(ISessionConfiguration):
    … …  
    190196        default = 0.0,
    191197        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,
    192207        )
    193208
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/locales/en/LC_MESSAGES/waeup.kofa.po

    r18305 r18313  
    2828msgid "Custom Float 1 (not used)"
    2929msgstr "Minimum Graduation Credit Units"
     30
     31msgid "Remark"
     32msgstr "Remark / Class of Degree (Grad.)"
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/batching.py

    r17025 r18313  
    6868            'level_session', 'outstanding', 'course_category',
    6969            'title', 'credits', 'passmark', 'semester', 'ticket_session',
    70             'unlock_score', 'previous'
     70            'imported_ts', 'unlock_score', 'previous'
    7171            ] + self.additional_fields
    7272        return sorted(fields)
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser.py

    r18301 r18313  
    1717##
    1818import grok
     19import csv
     20import textwrap
     21from cStringIO import StringIO
    1922from zope.i18n import translate
    2023from zope.schema.interfaces import ConstraintNotSatisfied
    21 from zope.component import getUtility
     24from zope.component import getUtility, queryUtility
     25from zope.catalog.interfaces import ICatalog
    2226from zope.security import checkPermission
    2327from zope.formlib.textwidgets import BytesDisplayWidget
    2428from hurry.workflow.interfaces import IWorkflowInfo
    25 from waeup.kofa.interfaces import REQUESTED, IExtFileStore, IKofaUtils
     29from waeup.kofa.interfaces import (
     30    REQUESTED, IExtFileStore, IKofaUtils, academic_sessions_vocab)
    2631from waeup.kofa.widgets.datewidget import FriendlyDatetimeDisplayWidget
    2732from waeup.kofa.browser.layout import KofaEditFormPage
    … …  
    3035    CLEARANCE, REQUESTED, RETURNING, CLEARED, REGISTERED, VALIDATED,
    3136    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)
    4137from waeup.kofa.students.interfaces import IStudentsUtils, ICourseTicket, IStudentBase
    4238from waeup.kofa.students.workflow import FORBIDDEN_POSTGRAD_TRANS
     39from 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,)
    4364from kofacustom.nigeria.students.browser import (
    4465    NigeriaOnlinePaymentDisplayFormPage,
    … …  
    6687from kofacustom.unidel.interfaces import MessageFactory as _
    6788
     89
     90def 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
    68121class CustomStudentBaseDisplayFormPage(NigeriaStudentBaseDisplayFormPage):
    69122    """ Page to display student base data
    … …  
    235288    form_fields['payment_date'].custom_widget = FriendlyDatetimeDisplayWidget('le')
    236289
     290class 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
    237305class CustomStudyLevelDisplayFormPage(StudyLevelDisplayFormPage):
    238306    """ Page to display student study levels
    … …  
    242310
    243311    form_fields = grok.AutoFields(ICustomStudentStudyLevel).omit(
    244         'level',)
     312        'level','imported_gpa', 'imported_cgpa')
    245313    form_fields[
    246314        'validation_date'].custom_widget = FriendlyDatetimeDisplayWidget('le')
    … …  
    254322        'validation_date', 'validated_by', 'total_credits', 'gpa', 'level',
    255323        'total_credits_s1', 'total_credits_s2')
     324    form_fields['imported_gpa'].for_display = True
     325    form_fields['imported_cgpa'].for_display = True
    256326
    257327class CustomExportPDFCourseRegistrationSlip(ExportPDFCourseRegistrationSlip):
    … …  
    267337        'password', 'suspended', 'phone', 'date_of_birth',
    268338        'adm_code', 'sex', 'suspended_comment', 'current_level',
    269         'flash_notice')
     339        'flash_notice', 'imported_gpa', 'imported_cgpa',)
    270340
    271341    def _signatures(self):
    … …  
    348418    form_fields['carry_over'].for_display = True
    349419    form_fields['ticket_session'].for_display = True
     420    form_fields['imported_ts'].for_display = True
    350421
    351422
    … …  
    519590            return
    520591        return pdfstream
     592
     593class 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
     715class 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  
    9898    """
    9999
    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
    103105
    104106    def mangle_value(self, value, name, context=None):
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/interfaces.py

    r18297 r18313  
    116116    """
    117117
     118    imported_cgpa = schema.Float(
     119        title = _(u'Imported Cumulative GPA'),
     120        required = False,
     121        )
     122
    118123class ICustomStudentStudyLevel(INigeriaStudentStudyLevel):
    119124    """A container for course tickets.
    … …  
    135140        required = False,
    136141        )
     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
    137153
    138154class ICustomStudentOnlinePayment(ICustomOnlinePayment):
    … …  
    178194        )
    179195
     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
    180204ICustomCourseTicket['score'].order = INigeriaCourseTicket['score'].order
    181205ICustomCourseTicket['ca'].order = ICustomCourseTicket['score'].order
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/reports/level_report.py

    r18312 r18313  
    6262            TTR('Cum. Credits Required'),
    6363            TTR('CGPA'),
    64             TTR('Remark'))
     64            TTR('Remark / Class of Degree (Grad.)'))
    6565    table = [col_names]
    6666    sn = 1
    … …  
    8585    """
    8686    """
     87
     88    title = 'Summary of Results'
    8789
    8890    def _get_students(self, faccode, depcode, certcode, session, level):
    … …  
    217219    """
    218220
    219     title = 'Level Report (Graduating Students only)'
     221    title = 'Summary of Results (Graduating Students only)'
    220222
    221223    @property
  • main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_browser.py

    r17906 r18313  
    1919import shutil
    2020import tempfile
     21import grok
    2122from StringIO import StringIO
    2223from hurry.workflow.interfaces import IWorkflowState, IWorkflowInfo
    … …  
    2425from zope.securitypolicy.interfaces import IPrincipalRoleManager
    2526from zope.component.hooks import setSite, clearSite
    26 from zope.component import getUtility, createObject
     27from zope.component import getUtility, createObject, queryUtility
    2728from zope.interface import verify
    2829from zope.event import notify
     30from zope.catalog.interfaces import ICatalog
    2931from waeup.kofa.authentication import LocalRoleSetEvent
    3032from waeup.kofa.app import University
    … …  
    4042from kofacustom.unidel.testing import FunctionalLayer
    4143
     44UPLOAD_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')
    4248
    4349class StudentsContainerUITests(StudentsFullSetup):
    … …  
    122128        open(path, 'wb').write(self.browser.contents)
    123129        print "Sample PDF attendance.pdf written to %s" % path
     130
     131class 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  
    125125        }
    126126
     127    ENABLE_SCORE_EDITING_GROUP_DICT = STUDY_MODES_DICT
     128
    127129    APP_CATS_DICT = {
    128130        'basic': 'UAS, PUTME, PCE, PRENCE',
Note: See TracChangeset for help on using the changeset viewer.