source: main/waeup.aaue/trunk/src/waeup/aaue/students/utils.py @ 17455

Last change on this file since 17455 was 17455, checked in by Henrik Bettermann, 15 months ago

Use correct filenames.
  • Property svn:keywords set to Id
File size: 26.2 KB
Line 
1## $Id: utils.py 17455 2023-06-25 17:08:23Z henrik $
2##
3## Copyright (C) 2011 Uli Fouquet & Henrik Bettermann
4## This program is free software; you can redistribute it and/or modify
5## it under the terms of the GNU General Public License as published by
6## the Free Software Foundation; either version 2 of the License, or
7## (at your option) any later version.
8##
9## This program is distributed in the hope that it will be useful,
10## but WITHOUT ANY WARRANTY; without even the implied warranty of
11## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12## GNU General Public License for more details.
13##
14## You should have received a copy of the GNU General Public License
15## along with this program; if not, write to the Free Software
16## Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
17##
18import grok
19import os
20import csv
21from time import time
22from zope.component import createObject, queryUtility
23from zope.catalog.interfaces import ICatalog
24from waeup.kofa.interfaces import (
25    ADMITTED, CLEARANCE, REQUESTED, CLEARED, RETURNING, PAID,
26    REGISTERED, VALIDATED, academic_sessions_vocab)
27from kofacustom.nigeria.students.utils import NigeriaStudentsUtils
28from waeup.kofa.accesscodes import create_accesscode
29from waeup.kofa.students.utils import trans
30from waeup.aaue.interfaces import MessageFactory as _
31
32MINIMUM_UNITS_THRESHOLD = 15
33
34SCHOOLFEES = dict()
35SFEECHANGES = (12, 13, 14, 15, 20, 21, 22)
36
37for year in SFEECHANGES:
38    schoolfees_path = os.path.join(
39        os.path.dirname(__file__), 'schoolfees_%s.csv' %year)
40    reader = csv.DictReader(open(schoolfees_path, 'rb'))
41    SCHOOLFEES[year] = {item['code']:(item['tuition'], item.values()) for item in reader}
42
43acceptancefees_path = os.path.join(
44    os.path.dirname(__file__), 'acceptancefees.csv')
45reader = csv.DictReader(open(acceptancefees_path, 'rb'))
46ACCEPTANCEFEES = {item['code']:(item['acceptance'], item.values()) for item in reader}
47
48class CustomStudentsUtils(NigeriaStudentsUtils):
49    """A collection of customized methods.
50
51    """
52
53    # PORTRAIT_CHANGE_STATES = (ADMITTED, CLEARANCE, REQUESTED, CLEARED)
54
55    def allowPortraitChange(self, student):
56        if student.is_fresh:
57            return True
58        return False
59
60    def GPABoundaries(self, faccode=None, depcode=None,
61                            certcode=None, student=None):
62        if student and student.current_mode.startswith('dp'):
63            return ((1.5, 'IRNS / NER / NYV'),
64                    (2.4, 'Pass'),
65                    (3.5, 'Merit'),
66                    (4.5, 'Credit'),
67                    (5, 'Distinction'))
68        elif student:
69            return ((1, 'FRNS / NER / NYV'),
70                    (1.5, 'Pass'),
71                    (2.4, '3rd Class Honours'),
72                    (3.5, '2nd Class Honours Lower Division'),
73                    (4.5, '2nd Class Honours Upper Division'),
74                    (5, '1st Class Honours'))
75        # Session Results Presentations depend on certificate
76        results = None
77        if certcode:
78            cat = queryUtility(ICatalog, name='certificates_catalog')
79            results = list(
80                cat.searchResults(code=(certcode, certcode)))
81        if results and results[0].study_mode.startswith('dp'):
82            return ((1.5, 'IRNS / NER / NYV'),
83                    (2.4, 'Pass'),
84                    (3.5, 'Merit'),
85                    (4.5, 'Credit'),
86                    (5, 'Distinction'))
87        else:
88            return ((1, 'FRNS / NER / NYV'),
89                    (1.5, 'Pass'),
90                    (2.4, '3rd Class Honours'),
91                    (3.5, '2nd Class Honours Lower Division'),
92                    (4.5, '2nd Class Honours Upper Division'),
93                    (5, '1st Class Honours'))
94
95    def getClassFromCGPA(self, gpa, student):
96        gpa_boundaries = self.GPABoundaries(student=student)
97
98        try:
99            certificate = getattr(student['studycourse'],'certificate',None)
100            end_level = getattr(certificate, 'end_level', None)
101            final_level = max([studylevel.level for studylevel in student['studycourse'].values()])
102            if end_level and final_level >= end_level:
103                dummy, repeat = divmod(final_level, 100)
104                if gpa <= 5.1 and repeat == 20:
105                    # Irrespective of the CGPA of a student, if the He/She has
106                    # 3rd Extension, such student will be graduated with a "Pass".
107                    return 1, gpa_boundaries[1][1]
108        except ValueError:
109            pass
110
111        if gpa < gpa_boundaries[0][0]:
112            # FRNS / Fail
113            return 0, gpa_boundaries[0][1]
114        if student.entry_session < 2013 or \
115            student.current_mode.startswith('dp'):
116            if gpa < gpa_boundaries[1][0]:
117                # Pass
118                return 1, gpa_boundaries[1][1]
119        else:
120            if gpa < gpa_boundaries[1][0]:
121                # FRNS
122                # Pass degree has been phased out in 2013 for non-diploma
123                # students
124                return 0, gpa_boundaries[0][1]
125        if gpa < gpa_boundaries[2][0]:
126            # 3rd / Merit
127            return 2, gpa_boundaries[2][1]
128        if gpa < gpa_boundaries[3][0]:
129            # 2nd L / Credit
130            return 3, gpa_boundaries[3][1]
131        if gpa < gpa_boundaries[4][0]:
132            # 2nd U / Distinction
133            return 4, gpa_boundaries[4][1]
134        if gpa <= gpa_boundaries[5][0]:
135            # 1st
136            return 5, gpa_boundaries[5][1]
137        return
138
139    def getDegreeClassNumber(self, level_obj):
140        """Get degree class number (used for SessionResultsPresentation
141        reports).
142        """
143        certificate = getattr(level_obj.__parent__,'certificate', None)
144        end_level = getattr(certificate, 'end_level', None)
145        if level_obj.level_verdict in ('FRNS', 'NER', 'NYV'):
146            return 0
147        if end_level and level_obj.level >= end_level:
148            if level_obj.level > end_level:
149                # spill-over level
150                if level_obj.gpa_params[1] == 0:
151                    # no credits taken
152                    return 0
153            elif level_obj.gpa_params[1] < MINIMUM_UNITS_THRESHOLD:
154                # credits taken below limit
155                return 0
156            failed_courses = level_obj.passed_params[4]
157            not_taken_courses = level_obj.passed_params[5]
158            if '_m' in failed_courses:
159                return 0
160            if len(not_taken_courses) \
161                and not not_taken_courses == 'Nil':
162                return 0
163        elif level_obj.gpa_params[1] < MINIMUM_UNITS_THRESHOLD:
164            # credits taken below limit
165            return 0
166        # use gpa_boundaries above
167        return self.getClassFromCGPA(
168            level_obj.cumulative_params[0], level_obj.student)[0]
169
170    def increaseMatricInteger(self, student):
171        """Increase counter for matric numbers.
172        This counter can be a centrally stored attribute or an attribute of
173        faculties, departments or certificates. In the base package the counter
174        is as an attribute of the site configuration container.
175        """
176        if student.current_mode in ('ug_pt', 'de_pt', 'ug_dsh', 'de_dsh'):
177            grok.getSite()['configuration'].next_matric_integer += 1
178            return
179        elif student.is_postgrad:
180            grok.getSite()['configuration'].next_matric_integer_3 += 1
181            return
182        elif student.current_mode in ('dp_ft',):
183            grok.getSite()['configuration'].next_matric_integer_4 += 1
184            return
185        grok.getSite()['configuration'].next_matric_integer_2 += 1
186        return
187
188    def _concessionalPaymentMade(self, student):
189        if len(student['payments']):
190            for ticket in student['payments'].values():
191                if ticket.p_state == 'paid' and \
192                    ticket.p_category == 'concessional':
193                    return True
194        return False
195
196    def constructMatricNumber(self, student):
197        faccode = student.faccode
198        depcode = student.depcode
199        certcode = student.certcode
200        degree = getattr(
201            getattr(student.get('studycourse', None), 'certificate', None),
202                'degree', None)
203        year = unicode(student.entry_session)[2:]
204        if not student.state in (PAID, ) or not student.is_fresh or \
205            student.current_mode in ('found', 'ijmbe'):
206            return _('Matriculation number cannot be set.'), None
207        #if student.current_mode not in ('mug_ft', 'mde_ft') and \
208        #    not self._concessionalPaymentMade(student):
209        #    return _('Matriculation number cannot be set.'), None
210        if student.is_postgrad:
211            next_integer = grok.getSite()['configuration'].next_matric_integer_3
212            if not degree or next_integer == 0:
213                return _('Matriculation number cannot be set.'), None
214            if student.faccode in ('IOE'):
215                return None, "AAU/SPS/%s/%s/%s/%05d" % (
216                    faccode, year, degree, next_integer)
217            return None, "AAU/SPS/%s/%s/%s/%s/%05d" % (
218                faccode, depcode, year, degree, next_integer)
219        if student.current_mode in ('ug_dsh', 'de_dsh'):
220            next_integer = grok.getSite()['configuration'].next_matric_integer
221            if next_integer == 0:
222                return _('Matriculation number cannot be set.'), None
223            return None, "DSH/%s/%s/%s/%05d" % (
224                faccode, depcode, year, next_integer)
225        if student.current_mode in ('ug_pt', 'de_pt'):
226            next_integer = grok.getSite()['configuration'].next_matric_integer
227            if next_integer == 0:
228                return _('Matriculation number cannot be set.'), None
229            return None, "PTP/%s/%s/%s/%05d" % (
230                faccode, depcode, year, next_integer)
231        if student.current_mode in ('dp_ft',):
232            next_integer = grok.getSite()['configuration'].next_matric_integer_4
233            if next_integer == 0:
234                return _('Matriculation number cannot be set.'), None
235            return None, "IOE/DIP/%s/%05d" % (year, next_integer)
236        next_integer = grok.getSite()['configuration'].next_matric_integer_2
237        if next_integer == 0:
238            return _('Matriculation number cannot be set.'), None
239        if student.faccode in ('FBM', 'FCS', 'FMLS'):
240            return None, "CMS/%s/%s/%s/%05d" % (
241                faccode, depcode, year, next_integer)
242        return None, "%s/%s/%s/%05d" % (faccode, depcode, year, next_integer)
243
244    def getReturningData(self, student):
245        """ This method defines what happens after school fee payment
246        of returning students depending on the student's senate verdict.
247        """
248        prev_level = student['studycourse'].current_level
249        cur_verdict = student['studycourse'].current_verdict
250        if cur_verdict in ('A','B','L','M','N','Z',):
251            # Successful student
252            new_level = divmod(int(prev_level),100)[0]*100 + 100
253        elif cur_verdict == 'C':
254            # Student on probation
255            new_level = int(prev_level) + 10
256        else:
257            # Student is somehow in an undefined state.
258            # Level has to be set manually.
259            new_level = prev_level
260        new_session = student['studycourse'].current_session + 1
261        return new_session, new_level
262
263    def _isPaymentDisabled(self, p_session, category, student):
264        academic_session = self._getSessionConfiguration(p_session)
265        if category.startswith('schoolfee'):
266            if 'sf_all' in academic_session.payment_disabled:
267                return True
268            if 'sf_pg' in academic_session.payment_disabled and \
269                student.is_postgrad:
270                return True
271            if 'sf_ug_pt' in academic_session.payment_disabled and \
272                student.current_mode in ('ug_pt', 'de_pt'):
273                return True
274            if 'sf_found' in academic_session.payment_disabled and \
275                student.current_mode == 'found':
276                return True
277        if category.startswith('clearance') and \
278            'cl_regular' in academic_session.payment_disabled and \
279            student.current_mode in ('ug_ft', 'de_ft', 'mug_ft', 'mde_ft'):
280            return True
281        if category == 'hostel_maintenance' and \
282            'maint_all' in academic_session.payment_disabled:
283            return True
284        return False
285
286    def setPaymentDetails(self, category, student,
287            previous_session=None, previous_level=None, combi=[]):
288        """Create Payment object and set the payment data of a student for
289        the payment category specified.
290
291        """
292        details = {}
293        p_item = u''
294        amount = 0.0
295        error = u''
296        if previous_session:
297            if previous_session < student['studycourse'].entry_session:
298                return _('The previous session must not fall below '
299                         'your entry session.'), None
300            if category == 'schoolfee':
301                # School fee is always paid for the following session
302                if previous_session > student['studycourse'].current_session:
303                    return _('This is not a previous session.'), None
304            else:
305                if previous_session > student['studycourse'].current_session - 1:
306                    return _('This is not a previous session.'), None
307            p_session = previous_session
308            p_level = previous_level
309            p_current = False
310        else:
311            p_session = student['studycourse'].current_session
312            p_level = student['studycourse'].current_level
313            p_current = True
314        academic_session = self._getSessionConfiguration(p_session)
315        if academic_session == None:
316            return _(u'Session configuration object is not available.'), None
317        # Determine fee.
318        if category == 'transfer':
319            amount = academic_session.transfer_fee
320        elif category == 'transcript_local':
321            amount = academic_session.transcript_fee_local
322        elif category == 'transcript_inter':
323            amount = academic_session.transcript_fee_inter
324        elif category == 'bed_allocation':
325            acco_details = self.getAccommodationDetails(student)
326            p_session = acco_details['booking_session']
327            p_item = acco_details['bt']
328            amount = academic_session.booking_fee
329        elif category == 'hostel_maintenance':
330            amount = 0.0
331            booking_session = grok.getSite()['hostels'].accommodation_session
332            bedticket = student['accommodation'].get(str(booking_session), None)
333            if bedticket is not None and bedticket.bed is not None:
334                p_session = booking_session
335                p_item = bedticket.display_coordinates
336                if bedticket.bed.__parent__.maint_fee > 0:
337                    amount = bedticket.bed.__parent__.maint_fee
338                else:
339                    # fallback
340                    amount = academic_session.maint_fee
341            else:
342                return _(u'No bed allocated.'), None
343        elif student.current_mode == 'found' and category not in (
344            'schoolfee', 'clearance', 'late_registration'):
345            return _('Not allowed.'), None
346        elif category.startswith('clearance'):
347            if student.state not in (ADMITTED, CLEARANCE, REQUESTED, CLEARED):
348                return _(u'Acceptance Fee payments not allowed.'), None
349            try:
350                certificate = student['studycourse'].certificate
351                p_item = certificate.code
352            except (AttributeError, TypeError):
353                return _('Study course data are incomplete.'), None
354            if student.current_mode in (
355                'ug_ft', 'ug_pt', 'de_ft', 'de_pt',
356                'transfer', 'mug_ft', 'mde_ft') \
357                and category != 'clearance_incl':
358                    return _("Additional fees must be included."), None
359            elif student.current_mode == 'special_pg_ft':
360                if category != 'clearance':
361                    return _("No additional fees required."), None
362            try:
363                acceptancefees = ACCEPTANCEFEES[student.certcode]
364            except KeyError:
365                return _('Acceptance fees not yet fixed.'), None
366            if category == 'clearance_incl':
367                for item in acceptancefees[1]:
368                    try:
369                        amount += int(item)
370                    except:
371                        pass
372            else:
373                amount = float(acceptancefees[0])
374        elif category == 'late_registration':
375            if student.is_postgrad:
376                amount = academic_session.late_pg_registration_fee
377            else:
378                amount = academic_session.late_registration_fee
379        elif category == 'ict':
380            if student.is_fresh:
381                amount = 2200
382            else:
383                amount = 1200
384        elif category.startswith('schoolfee'):
385            try:
386                certificate = student['studycourse'].certificate
387                p_item = certificate.code
388            except (AttributeError, TypeError):
389                return _('Study course data are incomplete.'), None
390            try:
391                if student.entry_session < 2013:
392                    schoolfees = SCHOOLFEES[12][student.certcode]
393                elif student.entry_session < 2014:
394                    schoolfees = SCHOOLFEES[13][student.certcode]
395                elif student.entry_session < 2015:
396                    schoolfees = SCHOOLFEES[14][student.certcode]
397                elif student.entry_session < 2020:
398                    schoolfees = SCHOOLFEES[15][student.certcode]
399                elif student.entry_session < 2021:
400                    schoolfees = SCHOOLFEES[20][student.certcode]
401                elif student.entry_session < 2022:
402                    schoolfees = SCHOOLFEES[21][student.certcode]
403                else:
404                    schoolfees = SCHOOLFEES[22][student.certcode]
405            except KeyError:
406                return _('School fees not yet fixed.'), None
407            if student.is_postgrad and category != 'schoolfee':
408                return _("No additional fees required."), None
409            if not previous_session and student.current_mode in (
410                'ug_ft', 'ug_pt', 'de_ft', 'de_pt',
411                'transfer', 'mug_ft', 'mde_ft') \
412                and not category in (
413                'schoolfee_incl', 'schoolfee_1', 'schoolfee_2'):
414                    return _("You must choose a payment which includes "
415                             "additional fees."), None
416            if category in ('schoolfee_1', 'schoolfee_2'):
417                if student.current_mode == 'ug_pt':
418                    return _("Part-time students are not allowed "
419                             "to pay by instalments."), None
420                if student.entry_session < 2015:
421                    return _("You are not allowed "
422                             "to pay by instalments."), None
423            additional = 0.0
424            for item in schoolfees[1]:
425                try:
426                    additional += int(item)
427                except:
428                    pass
429            amount = float(schoolfees[0])
430            additional -= amount
431            if previous_session:
432                # Students can pay for previous sessions in all
433                # workflow states.  Fresh students are excluded by the
434                # update method of the PreviousPaymentAddFormPage.
435                pass
436            elif student.state == CLEARED:
437                # Cut school fee by 50%
438                if category in ('schoolfee_1', 'schoolfee_2') and amount:
439                    amount /= 2
440            elif student.state == RETURNING and category != 'schoolfee_2':
441                if not student.father_name:
442                    return _("Personal data form is not properly filled."), None
443                # In case of returning school fee payment the payment session
444                # and level contain the values of the session the student
445                # has paid for.
446                p_session, p_level = self.getReturningData(student)
447                try:
448                    academic_session = grok.getSite()[
449                        'configuration'][str(p_session)]
450                except KeyError:
451                    return _(u'Session configuration object is not available.'), None
452                # Cut school fee by 50%
453                if category == 'schoolfee_1' and amount:
454                    amount /= 2
455            elif category == 'schoolfee_2' and amount:
456                amount /= 2
457            else:
458                return _('Wrong state.'), None
459            if amount in (0.0, None):
460                return _(u'Amount could not be determined.'), None
461            # Add additional fees
462            if category in ('schoolfee_incl', 'schoolfee_1'):
463                amount += additional
464            # Add non-indigenous fee and session specific penalty fees
465            if student.is_postgrad:
466                amount += academic_session.penalty_pg
467                if student.lga and not student.lga.startswith('edo'):
468                    amount += 20000.0
469            else:
470                amount += academic_session.penalty_ug
471        elif not student.is_postgrad:
472            fee_name = category + '_fee'
473            amount = getattr(academic_session, fee_name, 0.0)
474        if amount in (0.0, None):
475            return _(u'Amount could not be determined.'), None
476        # Create ticket.
477        for key in student['payments'].keys():
478            ticket = student['payments'][key]
479            if ticket.p_state == 'paid' and\
480               ticket.p_category == category and \
481               not ticket.p_category.startswith('transcript') and \
482               ticket.p_item == p_item and \
483               ticket.p_session == p_session:
484                  return _('This type of payment has already been made.'), None
485            # Additional condition in AAUE
486            if category in ('schoolfee', 'schoolfee_incl', 'schoolfee_1'):
487                if ticket.p_state == 'paid' and \
488                   ticket.p_category in ('schoolfee',
489                                         'schoolfee_incl',
490                                         'schoolfee_1') and \
491                   ticket.p_item == p_item and \
492                   ticket.p_session == p_session:
493                      return _(
494                          'Another school fee payment for this '
495                          'session has already been made.'), None
496
497        if self._isPaymentDisabled(p_session, category, student):
498            return _('This category of payments has been disabled.'), None
499        payment = createObject(u'waeup.StudentOnlinePayment')
500        timestamp = ("%d" % int(time()*10000))[1:]
501        payment.p_id = "p%s" % timestamp
502        payment.p_category = category
503        payment.p_item = p_item
504        payment.p_session = p_session
505        payment.p_level = p_level
506        payment.p_current = p_current
507        payment.amount_auth = amount
508        return None, payment
509
510    def _admissionText(self, student, portal_language):
511        inst_name = grok.getSite()['configuration'].name
512        entry_session = student['studycourse'].entry_session
513        entry_session = academic_sessions_vocab.getTerm(entry_session).title
514        text = trans(_(
515            'This is to inform you that you have been offered provisional'
516            ' admission into ${a} for the ${b} academic session as follows:',
517            mapping = {'a': inst_name, 'b': entry_session}),
518            portal_language)
519        return text
520
521    def warnCreditsOOR(self, studylevel, course=None):
522        studycourse = studylevel.__parent__
523        certificate = getattr(studycourse,'certificate', None)
524        current_level = studycourse.current_level
525        if None in (current_level, certificate):
526            return
527        end_level = certificate.end_level
528        if current_level >= end_level:
529            limit = 52
530        else:
531            limit = 48
532        if course and studylevel.total_credits + course.credits > limit:
533            return  _('Maximum credits exceeded.')
534        elif studylevel.total_credits > limit:
535            return _('Maximum credits exceeded.')
536        return
537
538    def getBedCoordinates(self, bedticket):
539        """Return descriptive bed coordinates.
540        This method can be used to customize the `display_coordinates`
541        property method in order to  display a
542        customary description of the bed space.
543        """
544        bc = bedticket.bed_coordinates.split(',')
545        if len(bc) == 4:
546            return bc[0]
547        return bedticket.bed_coordinates
548
549    def getAccommodationDetails(self, student):
550        """Determine the accommodation data of a student.
551        """
552        d = {}
553        d['error'] = u''
554        hostels = grok.getSite()['hostels']
555        d['booking_session'] = hostels.accommodation_session
556        d['allowed_states'] = hostels.accommodation_states
557        d['startdate'] = hostels.startdate
558        d['enddate'] = hostels.enddate
559        d['expired'] = hostels.expired
560        # Determine bed type
561        bt = 'all'
562        if student.sex == 'f':
563            sex = 'female'
564        else:
565            sex = 'male'
566        special_handling = 'regular'
567        d['bt'] = u'%s_%s_%s' % (special_handling,sex,bt)
568        return d
569
570    def checkAccommodationRequirements(self, student, acc_details):
571        msg = super(CustomStudentsUtils, self).checkAccommodationRequirements(
572            student, acc_details)
573        if msg:
574            return msg
575        if student.current_mode not in ('ug_ft', 'de_ft', 'mug_ft', 'mde_ft'):
576            return _('You are not eligible to book accommodation.')
577        return
578
579    # AAUE prefix
580    STUDENT_ID_PREFIX = u'E'
581
582    STUDENT_EXPORTER_NAMES = (
583            'students',
584            'studentstudycourses',
585            'studentstudycourses_1',
586            'studentstudylevels',
587            #'studentstudylevels_1',
588            'coursetickets',
589            #'coursetickets_1',
590            'studentpayments',
591            'bedtickets',
592            'unpaidpayments',
593            'sfpaymentsoverview',
594            'studylevelsoverview',
595            'combocard',
596            'bursary',
597            'levelreportdata',
598            'outstandingcourses',
599            'sessionpaymentsoverview',
600            'accommodationpayments',
601            'transcriptdata',
602            'trimmedpayments',
603            'trimmed',
604            'outstandingcourses_2'
605            )
606
607    # Maximum size of upload files in kB
608    MAX_KB = 500
Note: See TracBrowser for help on using the repository browser.