Changeset 17457 for main/waeup.uniben/trunk/src/waeup/uniben/students/utils.py

Timestamp:

26 Jun 2023, 21:30:00 (15 months ago)

Author:

Henrik Bettermann

Message:

Implement new school fee calculation based on civ configuration tables.

File:

• main/waeup.uniben/trunk/src/waeup/uniben/students/utils.py (modified) (7 diffs)

main/waeup.uniben/trunk/src/waeup/uniben/students/utils.py

@@ -17 +17 @@
 ##
 import grok
+import os
+import csv
 from time import time
 from reportlab.platypus import Paragraph, Table
@@ -30 +32 @@
 from kofacustom.nigeria.students.utils import NigeriaStudentsUtils
 from waeup.uniben.interfaces import MessageFactory as _
+
+SCHOOLFEES = dict()
+
+schoolfees_path = os.path.join(
+    os.path.dirname(__file__), 'schoolfees_22.csv')
+reader = csv.DictReader(open(schoolfees_path, 'rb'))
+SCHOOLFEES[22] = {line['code']: {item[0]:item[1] for item in line.items()}
+    for line in reader}
+
+
+schoolfees_path = os.path.join(
+    os.path.dirname(__file__), 'schoolfees_20.csv')
+reader = csv.DictReader(open(schoolfees_path, 'rb'))
+SCHOOLFEES[20] = {line['code']: {item[0]:item[1] for item in line.items()}
+    for line in reader}
+
+
+schoolfees_path = os.path.join(
+    os.path.dirname(__file__), 'schoolfees_17.csv')
+reader = csv.DictReader(open(schoolfees_path, 'rb'))
+SCHOOLFEES[17] = {line['code']: {item[0]:item[1] for item in line.items()}
+    for line in reader}
+
+schoolfees_path = os.path.join(
+    os.path.dirname(__file__), 'schoolfees_12.csv')
+reader = csv.DictReader(open(schoolfees_path, 'rb'))
+SCHOOLFEES[12] = {line['code']: {item[0]:item[1] for item in line.items()}
+    for line in reader}
 
 class CustomStudentsUtils(NigeriaStudentsUtils):
@@ -346 +376 @@
             except (AttributeError, TypeError):
                 return _('Study course data are incomplete.'), None
-            discount_year = 2017
-            if student.is_postgrad:
-                discount_year = 2020
+            try:
+                if student.entry_session < 2017:
+                    schoolfees_dict = SCHOOLFEES[12][p_item]
+                elif student.entry_session < 2020:
+                    schoolfees_dict = SCHOOLFEES[17][p_item]
+                elif student.entry_session < 2022:
+                    schoolfees_dict = SCHOOLFEES[20][p_item]
+                else:
+                    schoolfees_dict = SCHOOLFEES[22][p_item]
+            except KeyError:
+                return _('School fee not yet fixed: p_item = %s' % p_item), None
             if previous_session:
                 # Students can pay for previous sessions in all workflow states.
@@ -355 +393 @@
                 if previous_session == student['studycourse'].entry_session:
                     if student.is_foreigner:
-                        amount = getattr(certificate, 'school_fee_3', 0.0)
+                        amount = schoolfees_dict['initial_foreigner']
                     else:
-                        amount = getattr(certificate, 'school_fee_1', 0.0)
-                        # Old new students get a discount.
-                        if student.entry_session < discount_year \
-                            and certificate.custom_float_1:
-                            amount -= certificate.custom_float_1                        
+                        amount = schoolfees_dict['initial']
                 else:
                     if student.is_foreigner:
-                        amount = getattr(certificate, 'school_fee_4', 0.0)
+                        amount = schoolfees_dict['returning_foreigner']
                     else:
-                        amount = getattr(certificate, 'school_fee_2', 0.0)
-                        # Old returning students get a discount.
-                        if student.entry_session < discount_year \
-                            and certificate.custom_float_2:
-                            amount -= certificate.custom_float_2
+                        amount = schoolfees_dict['returning']
             else:
                 if student.state == CLEARED:
                     if student.is_foreigner:
-                        amount = getattr(certificate, 'school_fee_3', 0.0)
+                        amount = schoolfees_dict['initial_foreigner']
                     else:
-                        amount = getattr(certificate, 'school_fee_1', 0.0)
-                        # Old new students get a discount.
-                        if student.entry_session < discount_year \
-                            and certificate.custom_float_1:
-                            amount -= certificate.custom_float_1                             
+                        amount = schoolfees_dict['initial']
                 elif student.state == PAID and student.is_postgrad:
                     p_session += 1
@@ -386 +412 @@
                     if academic_session == None:
                         return _(u'Session configuration object is not available.'), None
-
-                    # Students are only allowed to pay for the next session
-                    # if current session payment
-                    # has really been made, i.e. payment object exists.
-                    #if not self._paymentMade(
-                    #    student, student.current_session):
-                    #    return _('You have not yet paid your current/active' +
-                    #             ' session. Please use the previous session' +
-                    #             ' payment form first.'), None
-
                     if student.is_foreigner:
-                        amount = getattr(certificate, 'school_fee_4', 0.0)
+                        amount = schoolfees_dict['returning_foreigner']
                     else:
-                        amount = getattr(certificate, 'school_fee_2', 0.0)
-                        # Old returning students might get a discount.
-                        if student.entry_session < discount_year \
-                            and certificate.custom_float_2:
-                            amount -= certificate.custom_float_2
+                        amount = schoolfees_dict['returning']
                 elif student.state == RETURNING:
                     # In case of returning school fee payment the payment session
@@ -423 +435 @@
 
                     if student.is_foreigner:
-                        amount = getattr(certificate, 'school_fee_4', 0.0)
+                        amount = schoolfees_dict['returning_foreigner']
                     else:
-                        amount = getattr(certificate, 'school_fee_2', 0.0)
-                        # Old returning students might get a discount.
-                        if student.entry_session < discount_year \
-                            and certificate.custom_float_2:
-                            amount -= certificate.custom_float_2
+                        amount = schoolfees_dict['returning']
                 # PHARMD school fee amount is fixed and previously paid
                 # installments in current session are deducted.
@@ -438 +446 @@
                     else:
                         amount = 160000.0 - self._pharmdInstallments(student)
+            try:
+                amount = float(amount)
+            except ValueError:
+                return _(u'School fee not yet fixed: p_item = %s' % p_item), None
             # Give 50% school fee discount to staff members.
             if student.is_staff:
                 amount /= 2
+
         else:
             fee_name = category + '_fee'