Context navigation

source: main/waeup.uniben/trunk/src/waeup/uniben/students/utils.py @ 17912

Last change on this file since 17912 was 17912, checked in by Henrik Bettermann, 2 months ago
Increase limit for students with current_verdict R.
Property svn:keywords set to `Id`
File size: 38.0 KB

Rev	Line
[7419]	1	## $Id: utils.py 17912 2024-09-04 11:18:27Z 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	##
[11773]	18	import grok
[17457]	19	import os
	20	import csv
[8598]	21	from time import time
[16108]	22	from reportlab.platypus import Paragraph, Table
[9459]	23	from zope.component import createObject, getUtility
[16106]	24	from reportlab.lib.styles import getSampleStyleSheet
[16108]	25	from waeup.kofa.browser.pdf import ENTRY1_STYLE
[16359]	26	from waeup.kofa.interfaces import (IKofaUtils, ADMITTED, CLEARANCE,
[16445]	27	CLEARED, REQUESTED, RETURNING, PAID, REGISTERED, VALIDATED, GRADUATED)
[13251]	28	from waeup.kofa.utils.helpers import to_timezone
[16108]	29	from waeup.kofa.students.utils import (
	30	trans, render_student_data, formatted_text, render_transcript_data,
	31	SLIP_STYLE)
[8821]	32	from kofacustom.nigeria.students.utils import NigeriaStudentsUtils
[8020]	33	from waeup.uniben.interfaces import MessageFactory as _
[6902]	34
[17457]	35	SCHOOLFEES = dict()
	36
	37	schoolfees_path = os.path.join(
[17707]	38	os.path.dirname(__file__), 'schoolfees_23.csv')
	39	reader = csv.DictReader(open(schoolfees_path, 'rb'))
	40	SCHOOLFEES[23] = {line['code']: {item[0]:item[1] for item in line.items()}
	41	for line in reader}
	42
	43	schoolfees_path = os.path.join(
[17457]	44	os.path.dirname(__file__), 'schoolfees_22.csv')
	45	reader = csv.DictReader(open(schoolfees_path, 'rb'))
	46	SCHOOLFEES[22] = {line['code']: {item[0]:item[1] for item in line.items()}
	47	for line in reader}
	48
	49
	50	schoolfees_path = os.path.join(
	51	os.path.dirname(__file__), 'schoolfees_20.csv')
	52	reader = csv.DictReader(open(schoolfees_path, 'rb'))
	53	SCHOOLFEES[20] = {line['code']: {item[0]:item[1] for item in line.items()}
	54	for line in reader}
	55
	56
	57	schoolfees_path = os.path.join(
	58	os.path.dirname(__file__), 'schoolfees_17.csv')
	59	reader = csv.DictReader(open(schoolfees_path, 'rb'))
	60	SCHOOLFEES[17] = {line['code']: {item[0]:item[1] for item in line.items()}
	61	for line in reader}
	62
	63	schoolfees_path = os.path.join(
	64	os.path.dirname(__file__), 'schoolfees_12.csv')
	65	reader = csv.DictReader(open(schoolfees_path, 'rb'))
	66	SCHOOLFEES[12] = {line['code']: {item[0]:item[1] for item in line.items()}
	67	for line in reader}
	68
[8821]	69	class CustomStudentsUtils(NigeriaStudentsUtils):
[7151]	70	"""A collection of customized methods.
	71
	72	"""
	73
[16382]	74	SEPARATORS_DICT = {
	75	'form.fst_sit_fname': _(u'First Sitting Record'),
	76	'form.scd_sit_fname': _(u'Second Sitting Record'),
	77	'form.alr_fname': _(u'Advanced Level Record'),
	78	'form.hq_type': _(u'Higher Education Record'),
	79	'form.hq2_type': _(u'Second Higher Education Record'),
	80	'form.nysc_year': _(u'NYSC Information'),
	81	'form.employer': _(u'Employment History'),
	82	'form.former_matric': _(u'Former Student'),
	83	'form.fever': _(u'History of Symptoms'),
	84	'form.asthma': _(u'Medical History'),
	85	'form.lagos_abuja': _(u'Travel History'),
	86	'form.company_suspected': _(u'History of Contact/Infection'),
[17255]	87	'form.genotype': _(u'TISHIP Registration Form Data'),
[16382]	88	}
	89
[8270]	90	def getReturningData(self, student):
	91	""" This method defines what happens after school fee payment
[8319]	92	of returning students depending on the student's senate verdict.
[8270]	93	"""
[8319]	94	prev_level = student['studycourse'].current_level
	95	cur_verdict = student['studycourse'].current_verdict
[16714]	96	if cur_verdict == 'N' and prev_level in (100, 200):
[15482]	97	new_level = prev_level
[17536]	98	elif cur_verdict in ('A','B','M','N','Z',):
[8319]	99	# Successful student
	100	new_level = divmod(int(prev_level),100)[0]*100 + 100
[17536]	101	elif cur_verdict in ('C', 'L',):
[8319]	102	# Student on probation
	103	new_level = int(prev_level) + 10
	104	else:
	105	# Student is somehow in an undefined state.
	106	# Level has to be set manually.
	107	new_level = prev_level
[8270]	108	new_session = student['studycourse'].current_session + 1
	109	return new_session, new_level
	110
[17743]	111	ACCOMMODATION_SPAN = 5
[13251]	112
[13248]	113	def checkAccommodationRequirements(self, student, acc_details):
	114	if acc_details.get('expired', False):
	115	startdate = acc_details.get('startdate')
	116	enddate = acc_details.get('enddate')
	117	if startdate and enddate:
	118	tz = getUtility(IKofaUtils).tzinfo
	119	startdate = to_timezone(
	120	startdate, tz).strftime("%d/%m/%Y %H:%M:%S")
	121	enddate = to_timezone(
	122	enddate, tz).strftime("%d/%m/%Y %H:%M:%S")
	123	return _("Outside booking period: ${a} - ${b}",
	124	mapping = {'a': startdate, 'b': enddate})
	125	else:
	126	return _("Outside booking period.")
[13777]	127	if not student.is_postgrad and student.current_mode != 'ug_ft':
[13446]	128	return _("Only undergraduate full-time students are eligible to book accommodation.")
[13283]	129	bt = acc_details.get('bt')
	130	if not bt:
[13248]	131	return _("Your data are incomplete.")
	132	if not student.state in acc_details['allowed_states']:
	133	return _("You are in the wrong registration state.")
[17255]	134	#if student['studycourse'].current_session != acc_details[
	135	# 'booking_session']:
	136	# return _('Your current session does not '
	137	# 'match accommodation session.')
	138	if acc_details['booking_session'] - student[
	139	'studycourse'].current_session > self.ACCOMMODATION_SPAN:
	140	return _('Your current session does not allow ' + \
	141	'to book accommodation.')
[13283]	142	stage = bt.split('_')[2]
[13777]	143	if not student.is_postgrad and stage != 'fr' and not student[
[14328]	144	'studycourse'].previous_verdict in (
[15392]	145	'A', 'B', 'F', 'J', 'L', 'M', 'C', 'Z'):
[13283]	146	return _("Your are not eligible to book accommodation.")
[15307]	147	bsession = str(acc_details['booking_session'])
	148	if bsession in student['accommodation'].keys() \
	149	and not 'booking expired' in \
	150	student['accommodation'][bsession].bed_coordinates:
[13248]	151	return _('You already booked a bed space in '
	152	'current accommodation session.')
	153	return
[13244]	154
[13295]	155	def getAccommodationDetails(self, student):
	156	"""Determine the accommodation data of a student.
	157	"""
	158	d = {}
	159	d['error'] = u''
	160	hostels = grok.getSite()['hostels']
	161	d['booking_session'] = hostels.accommodation_session
	162	d['allowed_states'] = hostels.accommodation_states
	163	d['startdate'] = hostels.startdate
	164	d['enddate'] = hostels.enddate
	165	d['expired'] = hostels.expired
	166	# Determine bed type
	167	studycourse = student['studycourse']
	168	certificate = getattr(studycourse,'certificate',None)
	169	entry_session = studycourse.entry_session
	170	current_level = studycourse.current_level
	171	if None in (entry_session, current_level, certificate):
	172	return d
	173	if student.sex == 'f':
	174	sex = 'female'
	175	else:
	176	sex = 'male'
[13777]	177	if student.is_postgrad:
	178	bt = 'all'
	179	special_handling = 'pg'
	180	else:
	181	end_level = certificate.end_level
	182	if current_level == 10:
	183	bt = 'pr'
	184	elif entry_session == grok.getSite()['hostels'].accommodation_session:
	185	bt = 'fr'
	186	elif current_level >= end_level:
	187	bt = 'fi'
	188	else:
	189	bt = 're'
	190	special_handling = 'regular'
[15354]	191	desired_hostel = student['accommodation'].desired_hostel
	192	if student.faccode in ('MED', 'DEN') and (
	193	not desired_hostel or desired_hostel.startswith('clinical')):
[13777]	194	special_handling = 'clinical'
	195	elif student.certcode in ('BARTMAS', 'BARTTHR', 'BARTFAA',
[17324]	196	'BAEDFAA', 'BSCEDECHED', 'BAFAA',
[17603]	197	'BARTMUS', 'BSCEDECHED', 'BEDECHEDU'):
[13777]	198	special_handling = 'ekenwan'
[13295]	199	d['bt'] = u'%s_%s_%s' % (special_handling,sex,bt)
	200	return d
	201
[9520]	202	def _paymentMade(self, student, session):
	203	if len(student['payments']):
	204	for ticket in student['payments'].values():
	205	if ticket.p_state == 'paid' and \
	206	ticket.p_category == 'schoolfee' and \
	207	ticket.p_session == session:
	208	return True
	209	return False
	210
[13566]	211	def _isPaymentDisabled(self, p_session, category, student):
	212	academic_session = self._getSessionConfiguration(p_session)
[14688]	213	if category == 'schoolfee':
	214	if 'sf_all' in academic_session.payment_disabled:
	215	return True
[16516]	216	if student.state == RETURNING and \
	217	'sf_return' in academic_session.payment_disabled:
	218	return True
[14688]	219	if student.current_mode == 'found' and \
	220	'sf_found' in academic_session.payment_disabled:
	221	return True
	222	if student.is_postgrad:
	223	if 'sf_pg' in academic_session.payment_disabled:
	224	return True
	225	return False
	226	if student.current_mode.endswith('ft') and \
	227	'sf_ft' in academic_session.payment_disabled:
	228	return True
	229	if student.current_mode.endswith('pt') and \
	230	'sf_pt' in academic_session.payment_disabled:
	231	return True
	232	if student.current_mode.startswith('dp') and \
	233	'sf_dp' in academic_session.payment_disabled:
	234	return True
	235	if student.current_mode.endswith('sw') and \
	236	'sf_sw' in academic_session.payment_disabled:
	237	return True
[13566]	238	if category == 'hostel_maintenance' and \
	239	'maint_all' in academic_session.payment_disabled:
	240	return True
[16025]	241	if category == 'clearance':
	242	if 'cl_all' in academic_session.payment_disabled:
	243	return True
	244	if student.is_jupeb and \
	245	'cl_jupeb' in academic_session.payment_disabled:
	246	return True
[16374]	247	if not student.is_jupeb and \
	248	'cl_allexj' in academic_session.payment_disabled:
	249	return True
[13566]	250	return False
	251
[13251]	252	#def _hostelApplicationPaymentMade(self, student, session):
	253	# if len(student['payments']):
	254	# for ticket in student['payments'].values():
	255	# if ticket.p_state == 'paid' and \
	256	# ticket.p_category == 'hostel_application' and \
	257	# ticket.p_session == session:
	258	# return True
	259	# return False
[12566]	260
[14960]	261	def _pharmdInstallments(self, student):
	262	installments = 0.0
	263	if len(student['payments']):
	264	for ticket in student['payments'].values():
	265	if ticket.p_state == 'paid' and \
	266	ticket.p_category.startswith('pharmd') and \
	267	ticket.p_session == student.current_session:
	268	installments += ticket.amount_auth
	269	return installments
	270
[15320]	271	def samePaymentMade(self, student, category, p_item, p_session):
[15447]	272	if category in ('bed_allocation', 'transcript'):
[15320]	273	return False
	274	for key in student['payments'].keys():
	275	ticket = student['payments'][key]
	276	if ticket.p_state == 'paid' and\
	277	ticket.p_category == category and \
	278	ticket.p_item == p_item and \
	279	ticket.p_session == p_session:
	280	return True
	281	return False
	282
[17606]	283	def setCDLPaymentDetails(self, category, student,
	284	previous_session, previous_level, combi):
	285	"""Create Payment object and set the payment data of a CDL student for
	286	the payment category specified.
	287	"""
	288	p_item = u''
	289	amount = 0.0
	290	if previous_session:
	291	if previous_session < student['studycourse'].entry_session:
	292	return _('The previous session must not fall below '
	293	'your entry session.'), None
	294	if category == 'schoolfee':
	295	# School fee is always paid for the following session
	296	if previous_session > student['studycourse'].current_session:
	297	return _('This is not a previous session.'), None
	298	else:
	299	if previous_session > student['studycourse'].current_session - 1:
	300	return _('This is not a previous session.'), None
	301	p_session = previous_session
	302	p_level = previous_level
	303	p_current = False
	304	else:
	305	p_session = student['studycourse'].current_session
	306	p_level = student['studycourse'].current_level
	307	p_current = True
	308	academic_session = self._getSessionConfiguration(p_session)
	309	if academic_session == None:
	310	return _(u'Session configuration object is not available.'), None
	311	# Determine fee.
	312	if category == 'schoolfee':
	313	try:
	314	certificate = student['studycourse'].certificate
	315	p_item = certificate.code
	316	except (AttributeError, TypeError):
	317	return _('Study course data are incomplete.'), None
	318	if previous_session:
	319	# Students can pay for previous sessions in all
	320	# workflow states. Fresh students are excluded by the
	321	# update method of the PreviousPaymentAddFormPage.
	322	if previous_level == 100:
	323	amount = getattr(certificate, 'school_fee_1', 0.0)
	324	else:
	325	amount = getattr(certificate, 'school_fee_2', 0.0)
	326	else:
	327	if student.state == CLEARED:
	328	amount = getattr(certificate, 'school_fee_1', 0.0)
	329	elif student.state == RETURNING:
	330	# In case of returning school fee payment the
	331	# payment session and level contain the values of
	332	# the session the student has paid for. Payment
	333	# session is always next session.
	334	p_session, p_level = self.getReturningData(student)
	335	academic_session = self._getSessionConfiguration(p_session)
	336	if academic_session == None:
	337	return _(
	338	u'Session configuration object is not available.'
	339	), None
	340	amount = getattr(certificate, 'school_fee_2', 0.0)
	341	elif student.is_postgrad and student.state == PAID:
	342	# Returning postgraduate students also pay for the
	343	# next session but their level always remains the
	344	# same.
	345	p_session += 1
	346	academic_session = self._getSessionConfiguration(p_session)
	347	if academic_session == None:
	348	return _(
	349	u'Session configuration object is not available.'
	350	), None
	351	amount = getattr(certificate, 'school_fee_2', 0.0)
	352	elif category == 'clearance':
	353	try:
	354	p_item = student['studycourse'].certificate.code
	355	except (AttributeError, TypeError):
	356	return _('Study course data are incomplete.'), None
	357	amount = academic_session.clearance_fee
	358	elif category == 'combi' and combi:
	359	categories = getUtility(IKofaUtils).COMBI_PAYMENT_CATEGORIES
	360	for cat in combi:
	361	fee_name = cat + '_fee'
	362	cat_amount = getattr(academic_session, fee_name, 0.0)
	363	if not cat_amount:
	364	return _('%s undefined.' % categories[cat]), None
	365	amount += cat_amount
	366	p_item += u'%s + ' % categories[cat]
	367	p_item = p_item.strip(' + ')
	368	else:
	369	fee_name = category + '_fee'
	370	amount = getattr(academic_session, fee_name, 0.0)
	371	if amount in (0.0, None):
	372	return _('Amount could not be determined.'), None
	373	if self.samePaymentMade(student, category, p_item, p_session):
	374	return _('This type of payment has already been made.'), None
	375	if self._isPaymentDisabled(p_session, category, student):
	376	return _('This category of payments has been disabled.'), None
	377	payment = createObject(u'waeup.StudentOnlinePayment')
	378	timestamp = ("%d" % int(time()*10000))[1:]
	379	payment.p_id = "p%s" % timestamp
	380	payment.p_category = category
	381	payment.p_item = p_item
	382	payment.p_session = p_session
	383	payment.p_level = p_level
	384	payment.p_current = p_current
	385	payment.amount_auth = amount
	386	payment.p_combi = combi
	387	return None, payment
	388
	389
[9152]	390	def setPaymentDetails(self, category, student,
[15666]	391	previous_session, previous_level, combi):
[8598]	392	"""Create Payment object and set the payment data of a student for
	393	the payment category specified.
	394
	395	"""
[17606]	396	if grok.getSite().__name__ == 'uniben-cdl':
	397	return self.setCDLPaymentDetails(category, student,
	398	previous_session, previous_level, combi)
[8598]	399	p_item = u''
	400	amount = 0.0
[9152]	401	if previous_session:
[9520]	402	if previous_session < student['studycourse'].entry_session:
	403	return _('The previous session must not fall below '
	404	'your entry session.'), None
	405	if category == 'schoolfee':
	406	# School fee is always paid for the following session
	407	if previous_session > student['studycourse'].current_session:
	408	return _('This is not a previous session.'), None
	409	else:
	410	if previous_session > student['studycourse'].current_session - 1:
	411	return _('This is not a previous session.'), None
[9152]	412	p_session = previous_session
	413	p_level = previous_level
	414	p_current = False
	415	else:
	416	p_session = student['studycourse'].current_session
	417	p_level = student['studycourse'].current_level
	418	p_current = True
[9520]	419	academic_session = self._getSessionConfiguration(p_session)
	420	if academic_session == None:
[8598]	421	return _(u'Session configuration object is not available.'), None
[8676]	422	# Determine fee.
[16873]	423	if category.startswith('pharmd') \
[14960]	424	and student.current_mode == 'special_ft':
	425	amount = 80000.0
[16780]	426	elif category == 'plag_test':
	427	amount = 2500.0
	428	if student.is_postgrad:
	429	amount = 5000.0
[15108]	430	#elif category == 'develop' and student.is_postgrad:
	431	# amount = academic_session.development_fee
[13251]	432	elif category == 'bed_allocation':
[17236]	433	acco_details = self.getAccommodationDetails(student)
	434	p_session = acco_details['booking_session']
	435	p_item = acco_details['bt']
[15268]	436	desired_hostel = student['accommodation'].desired_hostel
[15314]	437	if not desired_hostel:
	438	return _(u'Select your favoured hostel first.'), None
	439	if desired_hostel and desired_hostel != 'no':
[15268]	440	p_item = u'%s (%s)' % (p_item, desired_hostel)
[13251]	441	amount = academic_session.booking_fee
[15002]	442	if student.is_postgrad:
	443	amount += 500
[13251]	444	elif category == 'hostel_maintenance':
	445	amount = 0.0
[17236]	446	booking_session = grok.getSite()['hostels'].accommodation_session
	447	bedticket = student['accommodation'].get(str(booking_session), None)
[13500]	448	if bedticket is not None and bedticket.bed is not None:
[13251]	449	p_item = bedticket.bed_coordinates
[17236]	450	p_session = booking_session
[13251]	451	if bedticket.bed.__parent__.maint_fee > 0:
	452	amount = bedticket.bed.__parent__.maint_fee
	453	else:
	454	# fallback
	455	amount = academic_session.maint_fee
	456	else:
[13508]	457	return _(u'No bed allocated.'), None
[13251]	458	#elif category == 'hostel_application':
	459	# amount = 1000.0
	460	#elif category.startswith('tempmaint'):
	461	# if not self._hostelApplicationPaymentMade(
	462	# student, student.current_session):
	463	# return _(
	464	# 'You have not yet paid the hostel application fee.'), None
	465	# if category == 'tempmaint_1':
	466	# amount = 8150.0
	467	# elif category == 'tempmaint_2':
	468	# amount = 12650.0
	469	# elif category == 'tempmaint_3':
	470	# amount = 9650.0
[7151]	471	elif category == 'clearance':
[9796]	472	p_item = student.certcode
	473	if p_item is None:
[8598]	474	return _('Study course data are incomplete.'), None
[17606]	475	if student.is_jupeb:
[14897]	476	amount = 50000.0
	477	elif student.faccode.startswith('FCETA'):
[13869]	478	# ASABA and AKOKA
[14932]	479	amount = 35000.0
[17112]	480	elif student.depcode == 'DMIC':
	481	amount = 70000.0
[17361]	482	elif student.faccode in ('BMS', 'MED', 'DEN') \
	483	and not student.is_postgrad:
[14897]	484	amount = 80000.0
[15574]	485	elif student.faccode == 'DCOEM':
	486	return _('Acceptance fee payment not necessary.'), None
[11479]	487	else:
[14897]	488	amount = 60000.0
[7151]	489	elif category == 'schoolfee':
[8598]	490	try:
	491	certificate = student['studycourse'].certificate
	492	p_item = certificate.code
	493	except (AttributeError, TypeError):
	494	return _('Study course data are incomplete.'), None
[17457]	495	try:
	496	if student.entry_session < 2017:
	497	schoolfees_dict = SCHOOLFEES[12][p_item]
	498	elif student.entry_session < 2020:
	499	schoolfees_dict = SCHOOLFEES[17][p_item]
	500	elif student.entry_session < 2022:
	501	schoolfees_dict = SCHOOLFEES[20][p_item]
[17707]	502	elif student.entry_session < 2023:
	503	schoolfees_dict = SCHOOLFEES[22][p_item]
[17457]	504	else:
[17707]	505	schoolfees_dict = SCHOOLFEES[23][p_item]
[17457]	506	except KeyError:
	507	return _('School fee not yet fixed: p_item = %s' % p_item), None
[9152]	508	if previous_session:
[9520]	509	# Students can pay for previous sessions in all workflow states.
	510	# Fresh students are excluded by the update method of the
	511	# PreviousPaymentAddFormPage.
[9157]	512	if previous_session == student['studycourse'].entry_session:
[9152]	513	if student.is_foreigner:
[17457]	514	amount = schoolfees_dict['initial_foreigner']
[9152]	515	else:
[17457]	516	amount = schoolfees_dict['initial']
[9006]	517	else:
[9152]	518	if student.is_foreigner:
[17457]	519	amount = schoolfees_dict['returning_foreigner']
[9152]	520	else:
[17457]	521	amount = schoolfees_dict['returning']
[9152]	522	else:
	523	if student.state == CLEARED:
	524	if student.is_foreigner:
[17457]	525	amount = schoolfees_dict['initial_foreigner']
[9152]	526	else:
[17457]	527	amount = schoolfees_dict['initial']
[14858]	528	elif student.state == PAID and student.is_postgrad:
[9513]	529	p_session += 1
[9520]	530	academic_session = self._getSessionConfiguration(p_session)
	531	if academic_session == None:
[9513]	532	return _(u'Session configuration object is not available.'), None
	533	if student.is_foreigner:
[17457]	534	amount = schoolfees_dict['returning_foreigner']
[9513]	535	else:
[17457]	536	amount = schoolfees_dict['returning']
[9152]	537	elif student.state == RETURNING:
	538	# In case of returning school fee payment the payment session
	539	# and level contain the values of the session the student
	540	# has paid for.
	541	p_session, p_level = self.getReturningData(student)
[9520]	542	academic_session = self._getSessionConfiguration(p_session)
	543	if academic_session == None:
[9152]	544	return _(u'Session configuration object is not available.'), None
[9570]	545
[9520]	546	# Students are only allowed to pay for the next session
	547	# if current session payment has really been made,
	548	# i.e. payment object exists and is paid.
[9570]	549	#if not self._paymentMade(
	550	# student, student.current_session):
	551	# return _('You have not yet paid your current/active' +
	552	# ' session. Please use the previous session' +
	553	# ' payment form first.'), None
	554
[9152]	555	if student.is_foreigner:
[17457]	556	amount = schoolfees_dict['returning_foreigner']
[9152]	557	else:
[17457]	558	amount = schoolfees_dict['returning']
[14960]	559	# PHARMD school fee amount is fixed and previously paid
	560	# installments in current session are deducted.
[15363]	561	if student.current_mode == 'special_ft' \
	562	and student.state in (RETURNING, CLEARED):
	563	if student.is_foreigner:
	564	amount = 260000.0 - self._pharmdInstallments(student)
	565	else:
	566	amount = 160000.0 - self._pharmdInstallments(student)
[17457]	567	try:
	568	amount = float(amount)
	569	except ValueError:
	570	return _(u'School fee not yet fixed: p_item = %s' % p_item), None
[9006]	571	# Give 50% school fee discount to staff members.
	572	if student.is_staff:
	573	amount /= 2
[17457]	574
[16873]	575	else:
	576	fee_name = category + '_fee'
	577	amount = getattr(academic_session, fee_name, 0.0)
[8598]	578	if amount in (0.0, None):
[9520]	579	return _('Amount could not be determined.'), None
[8676]	580	# Add session specific penalty fee.
	581	if category == 'schoolfee' and student.is_postgrad:
	582	amount += academic_session.penalty_pg
[15108]	583	amount += academic_session.development_fee
[13757]	584	elif category == 'schoolfee' and student.current_mode == ('ug_ft'):
[13756]	585	amount += academic_session.penalty_ug_ft
[13757]	586	elif category == 'schoolfee' and student.current_mode == ('ug_pt'):
[13756]	587	amount += academic_session.penalty_ug_pt
[13998]	588	elif category == 'schoolfee' and student.current_mode == ('ug_sw'):
	589	amount += academic_session.penalty_sw
[14717]	590	elif category == 'schoolfee' and student.current_mode in (
	591	'dp_ft', 'dp_pt'):
	592	amount += academic_session.penalty_dp
[9727]	593	if category.startswith('tempmaint'):
	594	p_item = getUtility(IKofaUtils).PAYMENT_CATEGORIES[category]
	595	p_item = unicode(p_item)
	596	# Now we change the category because tempmaint payments
[12566]	597	# will be obsolete when Uniben returns to Kofa bed allocation.
[9727]	598	category = 'hostel_maintenance'
[8676]	599	# Create ticket.
[15320]	600	if self.samePaymentMade(student, category, p_item, p_session):
[11644]	601	return _('This type of payment has already been made.'), None
[11459]	602	if self._isPaymentDisabled(p_session, category, student):
[13814]	603	return _('This category of payments has been disabled.'), None
[8715]	604	payment = createObject(u'waeup.StudentOnlinePayment')
[8950]	605	timestamp = ("%d" % int(time()*10000))[1:]
[8598]	606	payment.p_id = "p%s" % timestamp
	607	payment.p_category = category
	608	payment.p_item = p_item
	609	payment.p_session = p_session
	610	payment.p_level = p_level
[9152]	611	payment.p_current = p_current
[8598]	612	payment.amount_auth = amount
	613	return None, payment
[7621]	614
[14588]	615	def warnCreditsOOR(self, studylevel, course=None):
[9831]	616	studycourse = studylevel.__parent__
	617	certificate = getattr(studycourse,'certificate', None)
	618	current_level = studycourse.current_level
	619	if None in (current_level, certificate):
[14588]	620	return
[16438]	621	if studylevel.__parent__.previous_verdict == 'R':
	622	return
[9831]	623	end_level = certificate.end_level
[15840]	624	if studylevel.student.faccode in (
	625	'MED', 'DEN', 'BMS') and studylevel.level == 200:
	626	limit = 61
	627	elif current_level >= end_level:
[17912]	628	if studycourse.current_verdict == 'R':
	629	limit = 999
	630	else:
	631	limit = 51
[14588]	632	else:
	633	limit = 50
	634	if course and studylevel.total_credits + course.credits > limit:
	635	return _('Maximum credits exceeded.')
	636	elif studylevel.total_credits > limit:
	637	return _('Maximum credits exceeded.')
	638	return
[9831]	639
[16406]	640	def warnCourseAlreadyPassed(self, studylevel, course):
	641	"""Return message if course has already been passed at
	642	previous levels.
	643	"""
[16413]	644
	645	# med: we may need to put this matter on hold and allow
	646	# all the students to register.
	647	return False
	648
[16406]	649	previous_verdict = studylevel.__parent__.previous_verdict
	650	if previous_verdict in ('C', 'M'):
	651	return False
	652	for slevel in studylevel.__parent__.values():
	653	for cticket in slevel.values():
	654	if cticket.code == course.code \
	655	and cticket.total_score >= cticket.passmark:
	656	return _('Course has already been passed at previous level.')
	657	return False
	658
[11773]	659	def clearance_disabled_message(self, student):
	660	if student.is_postgrad:
	661	return None
	662	try:
	663	session_config = grok.getSite()[
	664	'configuration'][str(student.current_session)]
	665	except KeyError:
	666	return _('Session configuration object is not available.')
	667	if not session_config.clearance_enabled:
	668	return _('Clearance is disabled for this session.')
	669	return None
	670
[16100]	671	def renderPDFTranscript(self, view, filename='transcript.pdf',
	672	student=None,
	673	studentview=None,
	674	note=None,
	675	signatures=(),
	676	sigs_in_footer=(),
	677	digital_sigs=(),
	678	show_scans=True, topMargin=1.5,
	679	omit_fields=(),
	680	tableheader=None,
	681	no_passport=False,
	682	save_file=False):
	683	"""Render pdf slip of a transcripts.
	684	"""
	685	portal_language = getUtility(IKofaUtils).PORTAL_LANGUAGE
	686	# XXX: tell what the different parameters mean
	687	style = getSampleStyleSheet()
	688	creator = self.getPDFCreator(student)
	689	data = []
	690	doc_title = view.label
	691	author = '%s (%s)' % (view.request.principal.title,
	692	view.request.principal.id)
	693	footer_text = view.label.split('\n')
	694	if len(footer_text) > 2:
	695	# We can add a department in first line
	696	footer_text = footer_text[1]
	697	else:
	698	# Only the first line is used for the footer
	699	footer_text = footer_text[0]
	700	if getattr(student, 'student_id', None) is not None:
	701	footer_text = "%s - %s - " % (student.student_id, footer_text)
	702
	703	# Insert student data table
	704	if student is not None:
	705	#bd_translation = trans(_('Base Data'), portal_language)
	706	#data.append(Paragraph(bd_translation, HEADING_STYLE))
	707	data.append(render_student_data(
	708	studentview, view.context,
	709	omit_fields, lang=portal_language,
	710	slipname=filename,
	711	no_passport=no_passport))
	712
	713	transcript_data = view.context.getTranscriptData()
	714	levels_data = transcript_data[0]
	715
	716	contextdata = []
	717	f_label = trans(_('Course of Study:'), portal_language)
	718	f_label = Paragraph(f_label, ENTRY1_STYLE)
	719	f_text = formatted_text(view.context.certificate.longtitle)
	720	f_text = Paragraph(f_text, ENTRY1_STYLE)
	721	contextdata.append([f_label,f_text])
	722
	723	f_label = trans(_('Faculty:'), portal_language)
	724	f_label = Paragraph(f_label, ENTRY1_STYLE)
	725	f_text = formatted_text(
	726	view.context.certificate.__parent__.__parent__.__parent__.longtitle)
	727	f_text = Paragraph(f_text, ENTRY1_STYLE)
	728	contextdata.append([f_label,f_text])
	729
	730	f_label = trans(_('Department:'), portal_language)
	731	f_label = Paragraph(f_label, ENTRY1_STYLE)
	732	f_text = formatted_text(
	733	view.context.certificate.__parent__.__parent__.longtitle)
	734	f_text = Paragraph(f_text, ENTRY1_STYLE)
	735	contextdata.append([f_label,f_text])
	736
	737	f_label = trans(_('Entry Session:'), portal_language)
	738	f_label = Paragraph(f_label, ENTRY1_STYLE)
	739	f_text = formatted_text(
	740	view.session_dict.get(view.context.entry_session))
	741	f_text = Paragraph(f_text, ENTRY1_STYLE)
	742	contextdata.append([f_label,f_text])
	743
	744	f_label = trans(_('Final Session:'), portal_language)
	745	f_label = Paragraph(f_label, ENTRY1_STYLE)
	746	f_text = formatted_text(
	747	view.session_dict.get(view.context.current_session))
	748	f_text = Paragraph(f_text, ENTRY1_STYLE)
	749	contextdata.append([f_label,f_text])
	750
	751	f_label = trans(_('Entry Mode:'), portal_language)
	752	f_label = Paragraph(f_label, ENTRY1_STYLE)
	753	f_text = formatted_text(view.studymode_dict.get(
	754	view.context.entry_mode))
	755	f_text = Paragraph(f_text, ENTRY1_STYLE)
	756	contextdata.append([f_label,f_text])
	757
	758	f_label = trans(_('Final Verdict:'), portal_language)
	759	f_label = Paragraph(f_label, ENTRY1_STYLE)
	760	f_text = formatted_text(view.studymode_dict.get(
	761	view.context.current_verdict))
	762	f_text = Paragraph(f_text, ENTRY1_STYLE)
	763	contextdata.append([f_label,f_text])
	764
	765	f_label = trans(_('Cumulative GPA:'), portal_language)
	766	f_label = Paragraph(f_label, ENTRY1_STYLE)
	767	format_float = getUtility(IKofaUtils).format_float
	768	cgpa = format_float(transcript_data[1], 3)
	769	if student.state == GRADUATED:
	770	f_text = formatted_text('%s (%s)' % (
	771	cgpa, self.getClassFromCGPA(transcript_data[1], student)[1]))
	772	else:
	773	f_text = formatted_text('%s' % cgpa)
[17498]	774	if not transcript_data[1]:
	775	f_text = formatted_text('No results yet!')
[16100]	776	f_text = Paragraph(f_text, ENTRY1_STYLE)
	777	contextdata.append([f_label,f_text])
	778
	779	contexttable = Table(contextdata,style=SLIP_STYLE)
	780	data.append(contexttable)
	781
[17498]	782	if transcript_data[1]:
	783	transcripttables = render_transcript_data(
	784	view, tableheader, levels_data, lang=portal_language)
	785	data.extend(transcripttables)
[16100]	786
	787	# Insert signatures
	788	# XXX: We are using only sigs_in_footer in waeup.kofa, so we
	789	# do not have a test for the following lines.
	790	if signatures and not sigs_in_footer:
	791	data.append(Spacer(1, 20))
	792	# Render one signature table per signature to
	793	# get date and signature in line.
	794	for signature in signatures:
	795	signaturetables = get_signature_tables(signature)
	796	data.append(signaturetables[0])
	797
	798	# Insert digital signatures
	799	if digital_sigs:
	800	data.append(Spacer(1, 20))
	801	sigs = digital_sigs.split('\n')
	802	for sig in sigs:
	803	data.append(Paragraph(sig, NOTE_STYLE))
	804
	805	view.response.setHeader(
	806	'Content-Type', 'application/pdf')
	807	try:
	808	pdf_stream = creator.create_pdf(
	809	data, None, doc_title, author=author, footer=footer_text,
[16906]	810	note=note, sigs_in_footer=sigs_in_footer, topMargin=topMargin,
	811	view=view)
[16100]	812	except IOError:
	813	view.flash(_('Error in image file.'))
	814	return view.redirect(view.url(view.context))
	815	if save_file:
	816	self._saveTranscriptPDF(student, pdf_stream)
	817	return
	818	return pdf_stream
	819
[14038]	820	#: A tuple containing the names of registration states in which changing of
	821	#: passport pictures is allowed.
[17814]	822	PORTRAIT_CHANGE_STATES = (CLEARANCE, ADMITTED, REQUESTED)
[14038]	823
[17807]	824	def allowPortraitChange(self, student):
	825	"""Check if student is allowed to change the portrait file.
	826	"""
	827	if student.is_jupeb:
	828	return False
	829	if student.state not in self.PORTRAIT_CHANGE_STATES:
	830	return False
	831	return True
	832
[16611]	833	#: A tuple containing the names of registration states in which changing of
	834	#: scanned signatures is allowed.
[16620]	835	SIGNATURE_CHANGE_STATES = (CLEARED, RETURNING, PAID, REGISTERED, VALIDATED, )
[16611]	836
[17870]	837	def final_clearance_enabled(self, student):
[17875]	838	studycourse = student['studycourse']
	839	certificate = getattr(studycourse,'certificate',None)
	840	current_level = studycourse.current_level
	841	if None in (current_level, certificate):
	842	return False
	843	if student.is_postgrad:
	844	return True
	845	end_level = certificate.end_level
	846	if current_level >= end_level:
	847	return True
	848	return False
[17870]	849
[8441]	850	# Uniben prefix
[17145]	851	@property
	852	def STUDENT_ID_PREFIX(self):
	853	if grok.getSite().__name__ == 'uniben-cdl':
	854	return u'C'
	855	return u'B'
[15980]	856
	857	STUDENT_EXPORTER_NAMES = (
	858	'students',
	859	'studentstudycourses',
[16840]	860	'studentstudycourses_1',
[15980]	861	'studentstudylevels',
[16840]	862	#'studentstudylevels_1',
[15980]	863	'coursetickets',
[16840]	864	#'coursetickets_1',
[15980]	865	'studentpayments',
	866	'bedtickets',
	867	'trimmed',
	868	'outstandingcourses',
	869	'unpaidpayments',
	870	'sfpaymentsoverview',
	871	'sessionpaymentsoverview',
	872	'studylevelsoverview',
	873	'combocard',
	874	'bursary',
	875	'accommodationpayments',
	876	'transcriptdata',
	877	'trimmedpayments',
[16390]	878	'medicalhistory',
[17396]	879	'nysc',
[15980]	880	)

Note: See TracBrowser for help on using the repository browser.

Download in other formats: