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

Last change on this file since 17488 was 17481, checked in by Henrik Bettermann, 17 months ago

Fix previous session schollfve payments.
  • Property svn:keywords set to Id
File size: 26.3 KB
Line 
1## $Id: utils.py 17481 2023-07-11 09:43:01Z 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               # Cut school fee by 50%
436                if category in ('schoolfee_1', 'schoolfee_2') and amount:
437                    amount /= 2
438                pass
439            elif student.state == CLEARED:
440                # Cut school fee by 50%
441                if category in ('schoolfee_1', 'schoolfee_2') and amount:
442                    amount /= 2
443            elif student.state == RETURNING and category != 'schoolfee_2':
444                if not student.father_name:
445                    return _("Personal data form is not properly filled."), None
446                # In case of returning school fee payment the payment session
447                # and level contain the values of the session the student
448                # has paid for.
449                p_session, p_level = self.getReturningData(student)
450                try:
451                    academic_session = grok.getSite()[
452                        'configuration'][str(p_session)]
453                except KeyError:
454                    return _(u'Session configuration object is not available.'), None
455                # Cut school fee by 50%
456                if category == 'schoolfee_1' and amount:
457                    amount /= 2
458            elif category == 'schoolfee_2' and amount:
459                amount /= 2
460            else:
461                return _('Wrong state.'), None
462            if amount in (0.0, None):
463                return _(u'Amount could not be determined.'), None
464            # Add additional fees
465            if category in ('schoolfee_incl', 'schoolfee_1'):
466                amount += additional
467            # Add non-indigenous fee and session specific penalty fees
468            if student.is_postgrad:
469                amount += academic_session.penalty_pg
470                if student.lga and not student.lga.startswith('edo'):
471                    amount += 20000.0
472            else:
473                amount += academic_session.penalty_ug
474        elif not student.is_postgrad:
475            fee_name = category + '_fee'
476            amount = getattr(academic_session, fee_name, 0.0)
477        if amount in (0.0, None):
478            return _(u'Amount could not be determined.'), None
479        # Create ticket.
480        for key in student['payments'].keys():
481            ticket = student['payments'][key]
482            if ticket.p_state == 'paid' and\
483               ticket.p_category == category and \
484               not ticket.p_category.startswith('transcript') and \
485               ticket.p_item == p_item and \
486               ticket.p_session == p_session:
487                  return _('This type of payment has already been made.'), None
488            # Additional condition in AAUE
489            if category in ('schoolfee', 'schoolfee_incl', 'schoolfee_1'):
490                if ticket.p_state == 'paid' and \
491                   ticket.p_category in ('schoolfee',
492                                         'schoolfee_incl',
493                                         'schoolfee_1') and \
494                   ticket.p_item == p_item and \
495                   ticket.p_session == p_session:
496                      return _(
497                          'Another school fee payment for this '
498                          'session has already been made.'), None
499
500        if self._isPaymentDisabled(p_session, category, student):
501            return _('This category of payments has been disabled.'), None
502        payment = createObject(u'waeup.StudentOnlinePayment')
503        timestamp = ("%d" % int(time()*10000))[1:]
504        payment.p_id = "p%s" % timestamp
505        payment.p_category = category
506        payment.p_item = p_item
507        payment.p_session = p_session
508        payment.p_level = p_level
509        payment.p_current = p_current
510        payment.amount_auth = amount
511        return None, payment
512
513    def _admissionText(self, student, portal_language):
514        inst_name = grok.getSite()['configuration'].name
515        entry_session = student['studycourse'].entry_session
516        entry_session = academic_sessions_vocab.getTerm(entry_session).title
517        text = trans(_(
518            'This is to inform you that you have been offered provisional'
519            ' admission into ${a} for the ${b} academic session as follows:',
520            mapping = {'a': inst_name, 'b': entry_session}),
521            portal_language)
522        return text
523
524    def warnCreditsOOR(self, studylevel, course=None):
525        studycourse = studylevel.__parent__
526        certificate = getattr(studycourse,'certificate', None)
527        current_level = studycourse.current_level
528        if None in (current_level, certificate):
529            return
530        end_level = certificate.end_level
531        if current_level >= end_level:
532            limit = 52
533        else:
534            limit = 48
535        if course and studylevel.total_credits + course.credits > limit:
536            return  _('Maximum credits exceeded.')
537        elif studylevel.total_credits > limit:
538            return _('Maximum credits exceeded.')
539        return
540
541    def getBedCoordinates(self, bedticket):
542        """Return descriptive bed coordinates.
543        This method can be used to customize the `display_coordinates`
544        property method in order to  display a
545        customary description of the bed space.
546        """
547        bc = bedticket.bed_coordinates.split(',')
548        if len(bc) == 4:
549            return bc[0]
550        return bedticket.bed_coordinates
551
552    def getAccommodationDetails(self, student):
553        """Determine the accommodation data of a student.
554        """
555        d = {}
556        d['error'] = u''
557        hostels = grok.getSite()['hostels']
558        d['booking_session'] = hostels.accommodation_session
559        d['allowed_states'] = hostels.accommodation_states
560        d['startdate'] = hostels.startdate
561        d['enddate'] = hostels.enddate
562        d['expired'] = hostels.expired
563        # Determine bed type
564        bt = 'all'
565        if student.sex == 'f':
566            sex = 'female'
567        else:
568            sex = 'male'
569        special_handling = 'regular'
570        d['bt'] = u'%s_%s_%s' % (special_handling,sex,bt)
571        return d
572
573    def checkAccommodationRequirements(self, student, acc_details):
574        msg = super(CustomStudentsUtils, self).checkAccommodationRequirements(
575            student, acc_details)
576        if msg:
577            return msg
578        if student.current_mode not in ('ug_ft', 'de_ft', 'mug_ft', 'mde_ft'):
579            return _('You are not eligible to book accommodation.')
580        return
581
582    # AAUE prefix
583    STUDENT_ID_PREFIX = u'E'
584
585    STUDENT_EXPORTER_NAMES = (
586            'students',
587            'studentstudycourses',
588            'studentstudycourses_1',
589            'studentstudylevels',
590            #'studentstudylevels_1',
591            'coursetickets',
592            #'coursetickets_1',
593            'studentpayments',
594            'bedtickets',
595            'unpaidpayments',
596            'sfpaymentsoverview',
597            'studylevelsoverview',
598            'combocard',
599            'bursary',
600            'levelreportdata',
601            'outstandingcourses',
602            'sessionpaymentsoverview',
603            'accommodationpayments',
604            'transcriptdata',
605            'trimmedpayments',
606            'trimmed',
607            'outstandingcourses_2'
608            )
609
610    # Maximum size of upload files in kB
611    MAX_KB = 500
Note: See TracBrowser for help on using the repository browser.