Context navigation

source: main/waeup.kofa/trunk/src/waeup/kofa/students/utils.py @ 16207

Last change on this file since 16207 was 16159, checked in by Henrik Bettermann, 4 years ago
Paint watermark first to make it transparent.
Property svn:keywords set to `Id`
File size: 53.0 KB

Line
1	## $Id: utils.py 16159 2020-07-10 06:11:44Z 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	##
18	"""General helper functions and utilities for the students section.
19	"""
20	import grok
21	import textwrap
22	from copy import deepcopy
23	from cgi import escape
24	from time import time
25	from cStringIO import StringIO
26	from PyPDF2 import PdfFileMerger, PdfFileReader, PdfFileWriter
27	from reportlab.lib import colors
28	from reportlab.lib.units import cm
29	from reportlab.lib.pagesizes import A4
30	from reportlab.lib.styles import getSampleStyleSheet
31	from reportlab.platypus import Paragraph, Image, Table, Spacer
32	from reportlab.platypus.doctemplate import LayoutError
33	from reportlab.platypus.flowables import PageBreak
34	from zope.event import notify
35	from zope.schema.interfaces import ConstraintNotSatisfied
36	from zope.component import getUtility, createObject, queryUtility
37	from zope.catalog.interfaces import ICatalog
38	from zope.formlib.form import setUpEditWidgets
39	from zope.i18n import translate
40	from waeup.kofa.interfaces import (
41	IExtFileStore, IKofaUtils, RETURNING, PAID, CLEARED, GRADUATED,
42	academic_sessions_vocab, IFileStoreNameChooser)
43	from waeup.kofa.interfaces import MessageFactory as _
44	from waeup.kofa.students.interfaces import IStudentsUtils
45	from waeup.kofa.students.workflow import ADMITTED
46	from waeup.kofa.students.vocabularies import StudyLevelSource, MatNumNotInSource
47	from waeup.kofa.browser.pdf import (
48	ENTRY1_STYLE, format_html, NOTE_STYLE, HEADING_STYLE,
49	get_signature_tables, get_qrcode)
50	from waeup.kofa.browser.interfaces import IPDFCreator
51	from waeup.kofa.utils.helpers import to_timezone
52
53	SLIP_STYLE = [
54	('VALIGN',(0,0),(-1,-1),'TOP'),
55	#('FONT', (0,0), (-1,-1), 'Helvetica', 11),
56	]
57
58	CONTENT_STYLE = [
59	('VALIGN',(0,0),(-1,-1),'TOP'),
60	#('FONT', (0,0), (-1,-1), 'Helvetica', 8),
61	#('TEXTCOLOR',(0,0),(-1,0),colors.white),
62	#('BACKGROUND',(0,0),(-1,0),colors.black),
63	('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),
64	('BOX', (0,0), (-1,-1), 1, colors.black),
65	]
66
67	FONT_SIZE = 10
68	FONT_COLOR = 'black'
69
70	def trans(text, lang):
71	# shortcut
72	return translate(text, 'waeup.kofa', target_language=lang)
73
74	def formatted_text(text, color=FONT_COLOR, lang='en'):
75	"""Turn `text`, `color` and `size` into an HTML snippet.
76
77	The snippet is suitable for use with reportlab and generating PDFs.
78	Wraps the `text` into a ``<font>`` tag with passed attributes.
79
80	Also non-strings are converted. Raw strings are expected to be
81	utf-8 encoded (usually the case for widgets etc.).
82
83	Finally, a br tag is added if widgets contain div tags
84	which are not supported by reportlab.
85
86	The returned snippet is unicode type.
87	"""
88	if not isinstance(text, unicode):
89	if isinstance(text, basestring):
90	text = text.decode('utf-8')
91	else:
92	text = unicode(text)
93	if text == 'None':
94	text = ''
95	# Very long matriculation numbers need to be wrapped
96	if text.find(' ') == -1 and len(text.split('/')) > 6:
97	text = '/'.join(text.split('/')[:5]) + \
98	'/ ' + '/'.join(text.split('/')[5:])
99	# Mainly for boolean values we need our customized
100	# localisation of the zope domain
101	text = translate(text, 'zope', target_language=lang)
102	text = text.replace('</div>', '<br /></div>')
103	tag1 = u'<font color="%s">' % (color)
104	return tag1 + u'%s</font>' % text
105
106	def generate_student_id():
107	students = grok.getSite()['students']
108	new_id = students.unique_student_id
109	return new_id
110
111	def set_up_widgets(view, ignore_request=False):
112	view.adapters = {}
113	view.widgets = setUpEditWidgets(
114	view.form_fields, view.prefix, view.context, view.request,
115	adapters=view.adapters, for_display=True,
116	ignore_request=ignore_request
117	)
118
119	def render_student_data(studentview, context, omit_fields=(),
120	lang='en', slipname=None, no_passport=False):
121	"""Render student table for an existing frame.
122	"""
123	width, height = A4
124	set_up_widgets(studentview, ignore_request=True)
125	data_left = []
126	data_middle = []
127	style = getSampleStyleSheet()
128	img = getUtility(IExtFileStore).getFileByContext(
129	studentview.context, attr='passport.jpg')
130	if img is None:
131	from waeup.kofa.browser import DEFAULT_PASSPORT_IMAGE_PATH
132	img = open(DEFAULT_PASSPORT_IMAGE_PATH, 'rb')
133	doc_img = Image(img.name, width=4cm, height=4cm, kind='bound')
134	data_left.append([doc_img])
135	#data.append([Spacer(1, 12)])
136
137	f_label = trans(_('Name:'), lang)
138	f_label = Paragraph(f_label, ENTRY1_STYLE)
139	f_text = formatted_text(studentview.context.display_fullname)
140	f_text = Paragraph(f_text, ENTRY1_STYLE)
141	data_middle.append([f_label,f_text])
142
143	for widget in studentview.widgets:
144	if 'name' in widget.name:
145	continue
146	f_label = translate(
147	widget.label.strip(), 'waeup.kofa',
148	target_language=lang)
149	f_label = Paragraph('%s:' % f_label, ENTRY1_STYLE)
150	f_text = formatted_text(widget(), lang=lang)
151	f_text = Paragraph(f_text, ENTRY1_STYLE)
152	data_middle.append([f_label,f_text])
153	if not 'date_of_birth' in omit_fields:
154	f_label = trans(_('Date of Birth:'), lang)
155	f_label = Paragraph(f_label, ENTRY1_STYLE)
156	date_of_birth = studentview.context.date_of_birth
157	tz = getUtility(IKofaUtils).tzinfo
158	date_of_birth = to_timezone(date_of_birth, tz)
159	if date_of_birth is not None:
160	date_of_birth = date_of_birth.strftime("%d/%m/%Y")
161	f_text = formatted_text(date_of_birth)
162	f_text = Paragraph(f_text, ENTRY1_STYLE)
163	data_middle.append([f_label,f_text])
164	if getattr(studentview.context, 'certcode', None):
165	if not 'certificate' in omit_fields:
166	f_label = trans(_('Study Course:'), lang)
167	f_label = Paragraph(f_label, ENTRY1_STYLE)
168	f_text = formatted_text(
169	studentview.context['studycourse'].certificate.longtitle)
170	f_text = Paragraph(f_text, ENTRY1_STYLE)
171	data_middle.append([f_label,f_text])
172	if not 'department' in omit_fields:
173	f_label = trans(_('Department:'), lang)
174	f_label = Paragraph(f_label, ENTRY1_STYLE)
175	f_text = formatted_text(
176	studentview.context[
177	'studycourse'].certificate.__parent__.__parent__.longtitle,
178	)
179	f_text = Paragraph(f_text, ENTRY1_STYLE)
180	data_middle.append([f_label,f_text])
181	if not 'faculty' in omit_fields:
182	f_label = trans(_('Faculty:'), lang)
183	f_label = Paragraph(f_label, ENTRY1_STYLE)
184	f_text = formatted_text(
185	studentview.context[
186	'studycourse'].certificate.__parent__.__parent__.__parent__.longtitle,
187	)
188	f_text = Paragraph(f_text, ENTRY1_STYLE)
189	data_middle.append([f_label,f_text])
190	if not 'current_mode' in omit_fields:
191	studymodes_dict = getUtility(IKofaUtils).STUDY_MODES_DICT
192	sm = studymodes_dict[studentview.context.current_mode]
193	f_label = trans(_('Study Mode:'), lang)
194	f_label = Paragraph(f_label, ENTRY1_STYLE)
195	f_text = formatted_text(sm)
196	f_text = Paragraph(f_text, ENTRY1_STYLE)
197	data_middle.append([f_label,f_text])
198	if not 'entry_session' in omit_fields:
199	f_label = trans(_('Entry Session:'), lang)
200	f_label = Paragraph(f_label, ENTRY1_STYLE)
201	entry_session = studentview.context.entry_session
202	try:
203	entry_session = academic_sessions_vocab.getTerm(
204	entry_session).title
205	except LookupError:
206	entry_session = _('void')
207	f_text = formatted_text(entry_session)
208	f_text = Paragraph(f_text, ENTRY1_STYLE)
209	data_middle.append([f_label,f_text])
210	# Requested by Uniben, does not really make sense
211	if not 'current_level' in omit_fields:
212	f_label = trans(_('Current Level:'), lang)
213	f_label = Paragraph(f_label, ENTRY1_STYLE)
214	current_level = studentview.context['studycourse'].current_level
215	studylevelsource = StudyLevelSource().factory
216	current_level = studylevelsource.getTitle(
217	studentview.context, current_level)
218	f_text = formatted_text(current_level)
219	f_text = Paragraph(f_text, ENTRY1_STYLE)
220	data_middle.append([f_label,f_text])
221
222	if no_passport:
223	table = Table(data_middle,style=SLIP_STYLE)
224	table.hAlign = 'LEFT'
225	return table
226
227	# append QR code to the right
228	if slipname:
229	url = studentview.url(context, slipname)
230	data_right = [[get_qrcode(url, width=70.0)]]
231	table_right = Table(data_right,style=SLIP_STYLE)
232	else:
233	table_right = None
234
235	table_left = Table(data_left,style=SLIP_STYLE)
236	table_middle = Table(data_middle,style=SLIP_STYLE, colWidths=[5cm, 5cm])
237	table = Table([[table_left, table_middle, table_right],],style=SLIP_STYLE)
238	return table
239
240	def render_table_data(tableheader, tabledata, lang='en'):
241	"""Render children table for an existing frame.
242	"""
243	data = []
244	#data.append([Spacer(1, 12)])
245	line = []
246	style = getSampleStyleSheet()
247	for element in tableheader:
248	field = '<strong>%s</strong>' % formatted_text(element[0], lang=lang)
249	field = Paragraph(field, style["Normal"])
250	line.append(field)
251	data.append(line)
252	for ticket in tabledata:
253	line = []
254	for element in tableheader:
255	field = formatted_text(getattr(ticket,element[1],u' '))
256	field = Paragraph(field, style["Normal"])
257	line.append(field)
258	data.append(line)
259	table = Table(data,colWidths=[
260	element[2]*cm for element in tableheader], style=CONTENT_STYLE)
261	return table
262
263	def render_transcript_data(view, tableheader, levels_data, lang='en'):
264	"""Render children table for an existing frame.
265	"""
266	data = []
267	style = getSampleStyleSheet()
268	format_float = getUtility(IKofaUtils).format_float
269	for level in levels_data:
270	level_obj = level['level']
271	tickets = level['tickets_1'] + level['tickets_2'] + level['tickets_3']
272	headerline = []
273	tabledata = []
274	if 'evel' in view.level_dict.get('ticket.level', str(level_obj.level)):
275	subheader = '%s %s, %s' % (
276	trans(_('Session'), lang),
277	view.session_dict[level_obj.level_session],
278	view.level_dict.get('ticket.level', str(level_obj.level)))
279	else:
280	subheader = '%s %s, %s %s' % (
281	trans(_('Session'), lang),
282	view.session_dict[level_obj.level_session],
283	trans(_('Level'), lang),
284	view.level_dict.get(level_obj.level, str(level_obj.level)))
285	data.append(Paragraph(subheader, HEADING_STYLE))
286	for element in tableheader:
287	field = '<strong>%s</strong>' % formatted_text(element[0])
288	field = Paragraph(field, style["Normal"])
289	headerline.append(field)
290	tabledata.append(headerline)
291	for ticket in tickets:
292	ticketline = []
293	for element in tableheader:
294	field = formatted_text(getattr(ticket,element[1],u' '))
295	field = Paragraph(field, style["Normal"])
296	ticketline.append(field)
297	tabledata.append(ticketline)
298	table = Table(tabledata,colWidths=[
299	element[2]*cm for element in tableheader], style=CONTENT_STYLE)
300	data.append(table)
301	sgpa = format_float(level['sgpa'], 2)
302	sgpa = '%s: %s' % (trans('Sessional GPA (rectified)', lang), sgpa)
303	#sgpa = '%s: %.2f' % (trans('Sessional GPA (rectified)', lang), level['sgpa'])
304	data.append(Paragraph(sgpa, style["Normal"]))
305	if getattr(level_obj, 'transcript_remark', None):
306	remark = '%s: %s' % (
307	trans('Transcript Remark', lang),
308	getattr(level_obj, 'transcript_remark'))
309	data.append(Paragraph(remark, style["Normal"]))
310	return data
311
312	def docs_as_flowables(view, lang='en'):
313	"""Create reportlab flowables out of scanned docs.
314	"""
315	# XXX: fix circular import problem
316	from waeup.kofa.browser.fileviewlets import FileManager
317	from waeup.kofa.browser import DEFAULT_IMAGE_PATH
318	style = getSampleStyleSheet()
319	data = []
320
321	# Collect viewlets
322	fm = FileManager(view.context, view.request, view)
323	fm.update()
324	if fm.viewlets:
325	sc_translation = trans(_('Scanned Documents'), lang)
326	data.append(Paragraph(sc_translation, HEADING_STYLE))
327	# Insert list of scanned documents
328	table_data = []
329	for viewlet in fm.viewlets:
330	if viewlet.file_exists:
331	# Show viewlet only if file exists
332	f_label = Paragraph(trans(viewlet.label, lang), ENTRY1_STYLE)
333	img_path = getattr(getUtility(IExtFileStore).getFileByContext(
334	view.context, attr=viewlet.download_name), 'name', None)
335	#f_text = Paragraph(trans(_('(not provided)'),lang), ENTRY1_STYLE)
336	if img_path is None:
337	pass
338	elif not img_path[-4:] in ('.jpg', '.JPG'):
339	# reportlab requires jpg images, I think.
340	f_text = Paragraph('%s (not displayable)' % (
341	viewlet.title,), ENTRY1_STYLE)
342	else:
343	f_text = Image(img_path, width=2cm, height=1cm, kind='bound')
344	table_data.append([f_label, f_text])
345	if table_data:
346	# safety belt; empty tables lead to problems.
347	data.append(Table(table_data, style=SLIP_STYLE))
348	return data
349
350	class StudentsUtils(grok.GlobalUtility):
351	"""A collection of methods subject to customization.
352	"""
353	grok.implements(IStudentsUtils)
354
355	def getReturningData(self, student):
356	""" Define what happens after school fee payment
357	depending on the student's senate verdict.
358	In the base configuration current level is always increased
359	by 100 no matter which verdict has been assigned.
360	"""
361	new_level = student['studycourse'].current_level + 100
362	new_session = student['studycourse'].current_session + 1
363	return new_session, new_level
364
365	def setReturningData(self, student):
366	""" Define what happens after school fee payment
367	depending on the student's senate verdict.
368	This method folllows the same algorithm as `getReturningData` but
369	it also sets the new values.
370	"""
371	new_session, new_level = self.getReturningData(student)
372	try:
373	student['studycourse'].current_level = new_level
374	except ConstraintNotSatisfied:
375	# Do not change level if level exceeds the
376	# certificate's end_level.
377	pass
378	student['studycourse'].current_session = new_session
379	verdict = student['studycourse'].current_verdict
380	student['studycourse'].current_verdict = '0'
381	student['studycourse'].previous_verdict = verdict
382	return
383
384	def _getSessionConfiguration(self, session):
385	try:
386	return grok.getSite()['configuration'][str(session)]
387	except KeyError:
388	return None
389
390	def _isPaymentDisabled(self, p_session, category, student):
391	academic_session = self._getSessionConfiguration(p_session)
392	if category == 'schoolfee' and \
393	'sf_all' in academic_session.payment_disabled:
394	return True
395	return False
396
397	def samePaymentMade(self, student, category, p_item, p_session):
398	for key in student['payments'].keys():
399	ticket = student['payments'][key]
400	if ticket.p_state == 'paid' and\
401	ticket.p_category == category and \
402	ticket.p_item != 'Balance' and \
403	ticket.p_item == p_item and \
404	ticket.p_session == p_session:
405	return True
406	return False
407
408	def setPaymentDetails(self, category, student,
409	previous_session=None, previous_level=None, combi=[]):
410	"""Create a payment ticket and set the payment data of a
411	student for the payment category specified.
412	"""
413	p_item = u''
414	amount = 0.0
415	if previous_session:
416	if previous_session < student['studycourse'].entry_session:
417	return _('The previous session must not fall below '
418	'your entry session.'), None
419	if category == 'schoolfee':
420	# School fee is always paid for the following session
421	if previous_session > student['studycourse'].current_session:
422	return _('This is not a previous session.'), None
423	else:
424	if previous_session > student['studycourse'].current_session - 1:
425	return _('This is not a previous session.'), None
426	p_session = previous_session
427	p_level = previous_level
428	p_current = False
429	else:
430	p_session = student['studycourse'].current_session
431	p_level = student['studycourse'].current_level
432	p_current = True
433	academic_session = self._getSessionConfiguration(p_session)
434	if academic_session == None:
435	return _(u'Session configuration object is not available.'), None
436	# Determine fee.
437	if category == 'schoolfee':
438	try:
439	certificate = student['studycourse'].certificate
440	p_item = certificate.code
441	except (AttributeError, TypeError):
442	return _('Study course data are incomplete.'), None
443	if previous_session:
444	# Students can pay for previous sessions in all
445	# workflow states. Fresh students are excluded by the
446	# update method of the PreviousPaymentAddFormPage.
447	if previous_level == 100:
448	amount = getattr(certificate, 'school_fee_1', 0.0)
449	else:
450	amount = getattr(certificate, 'school_fee_2', 0.0)
451	else:
452	if student.state == CLEARED:
453	amount = getattr(certificate, 'school_fee_1', 0.0)
454	elif student.state == RETURNING:
455	# In case of returning school fee payment the
456	# payment session and level contain the values of
457	# the session the student has paid for. Payment
458	# session is always next session.
459	p_session, p_level = self.getReturningData(student)
460	academic_session = self._getSessionConfiguration(p_session)
461	if academic_session == None:
462	return _(
463	u'Session configuration object is not available.'
464	), None
465	amount = getattr(certificate, 'school_fee_2', 0.0)
466	elif student.is_postgrad and student.state == PAID:
467	# Returning postgraduate students also pay for the
468	# next session but their level always remains the
469	# same.
470	p_session += 1
471	academic_session = self._getSessionConfiguration(p_session)
472	if academic_session == None:
473	return _(
474	u'Session configuration object is not available.'
475	), None
476	amount = getattr(certificate, 'school_fee_2', 0.0)
477	elif category == 'clearance':
478	try:
479	p_item = student['studycourse'].certificate.code
480	except (AttributeError, TypeError):
481	return _('Study course data are incomplete.'), None
482	amount = academic_session.clearance_fee
483	elif category == 'bed_allocation':
484	p_item = self.getAccommodationDetails(student)['bt']
485	amount = academic_session.booking_fee
486	elif category == 'hostel_maintenance':
487	amount = 0.0
488	bedticket = student['accommodation'].get(
489	str(student.current_session), None)
490	if bedticket is not None and bedticket.bed is not None:
491	p_item = bedticket.bed_coordinates
492	if bedticket.bed.__parent__.maint_fee > 0:
493	amount = bedticket.bed.__parent__.maint_fee
494	else:
495	# fallback
496	amount = academic_session.maint_fee
497	else:
498	return _(u'No bed allocated.'), None
499	elif category == 'combi' and combi:
500	categories = getUtility(IKofaUtils).COMBI_PAYMENT_CATEGORIES
501	for cat in combi:
502	fee_name = cat + '_fee'
503	cat_amount = getattr(academic_session, fee_name, 0.0)
504	if not cat_amount:
505	return _('%s undefined.' % categories[cat]), None
506	amount += cat_amount
507	p_item += u'%s + ' % categories[cat]
508	p_item = p_item.strip(' + ')
509	else:
510	fee_name = category + '_fee'
511	amount = getattr(academic_session, fee_name, 0.0)
512	if amount in (0.0, None):
513	return _('Amount could not be determined.'), None
514	if self.samePaymentMade(student, category, p_item, p_session):
515	return _('This type of payment has already been made.'), None
516	if self._isPaymentDisabled(p_session, category, student):
517	return _('This category of payments has been disabled.'), None
518	payment = createObject(u'waeup.StudentOnlinePayment')
519	timestamp = ("%d" % int(time()*10000))[1:]
520	payment.p_id = "p%s" % timestamp
521	payment.p_category = category
522	payment.p_item = p_item
523	payment.p_session = p_session
524	payment.p_level = p_level
525	payment.p_current = p_current
526	payment.amount_auth = amount
527	payment.p_combi = combi
528	return None, payment
529
530	def setBalanceDetails(self, category, student,
531	balance_session, balance_level, balance_amount):
532	"""Create a balance payment ticket and set the payment data
533	as selected by the student.
534	"""
535	p_item = u'Balance'
536	p_session = balance_session
537	p_level = balance_level
538	p_current = False
539	amount = balance_amount
540	academic_session = self._getSessionConfiguration(p_session)
541	if academic_session == None:
542	return _(u'Session configuration object is not available.'), None
543	if amount in (0.0, None) or amount < 0:
544	return _('Amount must be greater than 0.'), None
545	payment = createObject(u'waeup.StudentOnlinePayment')
546	timestamp = ("%d" % int(time()*10000))[1:]
547	payment.p_id = "p%s" % timestamp
548	payment.p_category = category
549	payment.p_item = p_item
550	payment.p_session = p_session
551	payment.p_level = p_level
552	payment.p_current = p_current
553	payment.amount_auth = amount
554	return None, payment
555
556	def increaseMatricInteger(self, student):
557	"""Increase counter for matric numbers.
558	This counter can be a centrally stored attribute or an attribute of
559	faculties, departments or certificates. In the base package the counter
560	is as an attribute of the site configuration container.
561	"""
562	grok.getSite()['configuration'].next_matric_integer += 1
563	return
564
565	def constructMatricNumber(self, student):
566	"""Fetch the matric number counter which fits the student and
567	construct the new matric number of the student.
568	In the base package the counter is returned which is as an attribute
569	of the site configuration container.
570	"""
571	next_integer = grok.getSite()['configuration'].next_matric_integer
572	if next_integer == 0:
573	return _('Matriculation number cannot be set.'), None
574	return None, unicode(next_integer)
575
576	def setMatricNumber(self, student):
577	"""Set matriculation number of student. If the student's matric number
578	is unset a new matric number is
579	constructed according to the matriculation number construction rules
580	defined in the `constructMatricNumber` method. The new matric number is
581	set, the students catalog updated. The corresponding matric number
582	counter is increased by one.
583
584	This method is tested but not used in the base package. It can
585	be used in custom packages by adding respective views
586	and by customizing `increaseMatricInteger` and `constructMatricNumber`
587	according to the university's matriculation number construction rules.
588
589	The method can be disabled by setting the counter to zero.
590	"""
591	if student.matric_number is not None:
592	return _('Matriculation number already set.'), None
593	if student.certcode is None:
594	return _('No certificate assigned.'), None
595	error, matric_number = self.constructMatricNumber(student)
596	if error:
597	return error, None
598	try:
599	student.matric_number = matric_number
600	except MatNumNotInSource:
601	return _('Matriculation number %s exists.' % matric_number), None
602	notify(grok.ObjectModifiedEvent(student))
603	self.increaseMatricInteger(student)
604	return None, matric_number
605
606	def getAccommodationDetails(self, student):
607	"""Determine the accommodation data of a student.
608	"""
609	d = {}
610	d['error'] = u''
611	hostels = grok.getSite()['hostels']
612	d['booking_session'] = hostels.accommodation_session
613	d['allowed_states'] = hostels.accommodation_states
614	d['startdate'] = hostels.startdate
615	d['enddate'] = hostels.enddate
616	d['expired'] = hostels.expired
617	# Determine bed type
618	studycourse = student['studycourse']
619	certificate = getattr(studycourse,'certificate',None)
620	entry_session = studycourse.entry_session
621	current_level = studycourse.current_level
622	if None in (entry_session, current_level, certificate):
623	return d
624	end_level = certificate.end_level
625	if current_level == 10:
626	bt = 'pr'
627	elif entry_session == grok.getSite()['hostels'].accommodation_session:
628	bt = 'fr'
629	elif current_level >= end_level:
630	bt = 'fi'
631	else:
632	bt = 're'
633	if student.sex == 'f':
634	sex = 'female'
635	else:
636	sex = 'male'
637	special_handling = 'regular'
638	d['bt'] = u'%s_%s_%s' % (special_handling,sex,bt)
639	return d
640
641	def checkAccommodationRequirements(self, student, acc_details):
642	if acc_details.get('expired', False):
643	startdate = acc_details.get('startdate')
644	enddate = acc_details.get('enddate')
645	if startdate and enddate:
646	tz = getUtility(IKofaUtils).tzinfo
647	startdate = to_timezone(
648	startdate, tz).strftime("%d/%m/%Y %H:%M:%S")
649	enddate = to_timezone(
650	enddate, tz).strftime("%d/%m/%Y %H:%M:%S")
651	return _("Outside booking period: ${a} - ${b}",
652	mapping = {'a': startdate, 'b': enddate})
653	else:
654	return _("Outside booking period.")
655	if not acc_details.get('bt'):
656	return _("Your data are incomplete.")
657	if not student.state in acc_details['allowed_states']:
658	return _("You are in the wrong registration state.")
659	if student['studycourse'].current_session != acc_details[
660	'booking_session']:
661	return _('Your current session does not '
662	'match accommodation session.')
663	bsession = str(acc_details['booking_session'])
664	if bsession in student['accommodation'].keys() \
665	and not 'booking expired' in \
666	student['accommodation'][bsession].bed_coordinates:
667	return _('You already booked a bed space in '
668	'current accommodation session.')
669	return
670
671	def selectBed(self, available_beds):
672	"""Select a bed from a filtered list of available beds.
673	In the base configuration beds are sorted by the sort id
674	of the hostel and the bed number. The first bed found in
675	this sorted list is taken.
676	"""
677	sorted_beds = sorted(available_beds,
678	key=lambda bed: 1000 * bed.__parent__.sort_id + bed.bed_number)
679	return sorted_beds[0]
680
681	def GPABoundaries(self, faccode=None, depcode=None, certcode=None):
682	return ((1, 'Fail'),
683	(1.5, 'Pass'),
684	(2.4, '3rd Class'),
685	(3.5, '2nd Class Lower'),
686	(4.5, '2nd Class Upper'),
687	(5, '1st Class'))
688
689	def getClassFromCGPA(self, gpa, student):
690	"""Determine the class of degree. In some custom packages
691	this class depends on e.g. the entry session of the student. In the
692	base package, it does not.
693	"""
694	if gpa < self.GPABoundaries()[0][0]:
695	return 0, self.GPABoundaries()[0][1]
696	if gpa < self.GPABoundaries()[1][0]:
697	return 1, self.GPABoundaries()[1][1]
698	if gpa < self.GPABoundaries()[2][0]:
699	return 2, self.GPABoundaries()[2][1]
700	if gpa < self.GPABoundaries()[3][0]:
701	return 3, self.GPABoundaries()[3][1]
702	if gpa < self.GPABoundaries()[4][0]:
703	return 4, self.GPABoundaries()[4][1]
704	if gpa <= self.GPABoundaries()[5][0]:
705	return 5, self.GPABoundaries()[5][1]
706	return
707
708	def getDegreeClassNumber(self, level_obj):
709	"""Get degree class number (used for SessionResultsPresentation
710	reports).
711	"""
712	if level_obj.gpa_params[1] == 0:
713	# No credits weighted
714	return 6
715	return self.getClassFromCGPA(
716	level_obj.cumulative_params[0], level_obj.student)[0]
717
718	def _saveTranscriptPDF(self, student, transcript):
719	"""Create a transcript PDF file and store it in student folder.
720	"""
721	file_store = getUtility(IExtFileStore)
722	file_id = IFileStoreNameChooser(student).chooseName(
723	attr="final_transcript.pdf")
724	file_store.createFile(file_id, StringIO(transcript))
725	return
726
727	def warnCreditsOOR(self, studylevel, course=None):
728	"""Return message if credits are out of range. In the base
729	package only maximum credits is set.
730	"""
731	if course and studylevel.total_credits + course.credits > 50:
732	return _('Maximum credits exceeded.')
733	elif studylevel.total_credits > 50:
734	return _('Maximum credits exceeded.')
735	return
736
737	def warnCourseAlreadyPassed(self, studylevel, course):
738	"""Return message if course has already been passed at
739	previous levels.
740	"""
741	for slevel in studylevel.__parent__.values():
742	for cticket in slevel.values():
743	if cticket.code == course.code \
744	and cticket.total_score >= cticket.passmark:
745	return _('Course has already been passed at previous level.')
746	return False
747
748	def getBedCoordinates(self, bedticket):
749	"""Return descriptive bed coordinates.
750	This method can be used to customize the `display_coordinates`
751	property method in order to display a
752	customary description of the bed space.
753	"""
754	return bedticket.bed_coordinates
755
756	def clearance_disabled_message(self, student):
757	"""Render message if clearance is disabled.
758	"""
759	try:
760	session_config = grok.getSite()[
761	'configuration'][str(student.current_session)]
762	except KeyError:
763	return _('Session configuration object is not available.')
764	if not session_config.clearance_enabled:
765	return _('Clearance is disabled for this session.')
766	return None
767
768	def getPDFCreator(self, context):
769	"""Get a pdf creator suitable for `context`.
770	The default implementation always returns the default creator.
771	"""
772	return getUtility(IPDFCreator)
773
774	def renderPDF(self, view, filename='slip.pdf', student=None,
775	studentview=None,
776	tableheader=[], tabledata=[],
777	note=None, signatures=None, sigs_in_footer=(),
778	show_scans=True, topMargin=1.5,
779	omit_fields=()):
780	"""Render pdf slips for various pages (also some pages
781	in the applicants module).
782	"""
783	portal_language = getUtility(IKofaUtils).PORTAL_LANGUAGE
784	# XXX: tell what the different parameters mean
785	style = getSampleStyleSheet()
786	creator = self.getPDFCreator(student)
787	data = []
788	doc_title = view.label
789	author = '%s (%s)' % (view.request.principal.title,
790	view.request.principal.id)
791	footer_text = view.label.split('\n')
792	if len(footer_text) > 2:
793	# We can add a department in first line, second line is used
794	footer_text = footer_text[1]
795	else:
796	# Only the first line is used for the footer
797	footer_text = footer_text[0]
798	if getattr(student, 'student_id', None) is not None:
799	footer_text = "%s - %s - " % (student.student_id, footer_text)
800
801	# Insert student data table
802	if student is not None:
803	if view.form_fields:
804	bd_translation = trans(_('Base Data'), portal_language)
805	data.append(Paragraph(bd_translation, HEADING_STYLE))
806	data.append(render_student_data(
807	studentview, view.context, omit_fields, lang=portal_language,
808	slipname=filename))
809
810	# Insert widgets
811	if view.form_fields:
812	data.append(Paragraph(view.title, HEADING_STYLE))
813	separators = getattr(self, 'SEPARATORS_DICT', {})
814	table = creator.getWidgetsTable(
815	view.form_fields, view.context, None, lang=portal_language,
816	separators=separators)
817	data.append(table)
818
819	# Insert scanned docs
820	if show_scans:
821	data.extend(docs_as_flowables(view, portal_language))
822
823	# Insert history
824	if filename == 'clearance_slip.pdf':
825	hist_translation = trans(_('Workflow History'), portal_language)
826	data.append(Paragraph(hist_translation, HEADING_STYLE))
827	data.extend(creator.fromStringList(student.history.messages))
828
829	# Insert content tables (optionally on second page)
830	if hasattr(view, 'tabletitle'):
831	for i in range(len(view.tabletitle)):
832	if tabledata[i] and tableheader[i]:
833	tabletitle = view.tabletitle[i]
834	if tabletitle.startswith('_PB_'):
835	data.append(PageBreak())
836	tabletitle = view.tabletitle[i].strip('_PB_')
837	#data.append(Spacer(1, 20))
838	data.append(Paragraph(tabletitle, HEADING_STYLE))
839	data.append(Spacer(1, 8))
840	contenttable = render_table_data(tableheader[i],tabledata[i])
841	data.append(contenttable)
842
843	# Insert signatures
844	# XXX: We are using only sigs_in_footer in waeup.kofa, so we
845	# do not have a test for the following lines.
846	if signatures and not sigs_in_footer:
847	data.append(Spacer(1, 20))
848	# Render one signature table per signature to
849	# get date and signature in line.
850	for signature in signatures:
851	signaturetables = get_signature_tables(signature)
852	data.append(signaturetables[0])
853
854	view.response.setHeader(
855	'Content-Type', 'application/pdf')
856	try:
857	pdf_stream = creator.create_pdf(
858	data, None, doc_title, author=author, footer=footer_text,
859	note=note, sigs_in_footer=sigs_in_footer, topMargin=topMargin)
860	except IOError:
861	view.flash('Error in image file.')
862	return view.redirect(view.url(view.context))
863	except LayoutError, err:
864	view.flash(
865	'PDF file could not be created. Reportlab error message: %s'
866	% escape(err.message),
867	type="danger")
868	return view.redirect(view.url(view.context))
869	return pdf_stream
870
871	def _admissionText(self, student, portal_language):
872	inst_name = grok.getSite()['configuration'].name
873	text = trans(_(
874	'This is to inform you that you have been provisionally'
875	' admitted into ${a} as follows:', mapping = {'a': inst_name}),
876	portal_language)
877	return text
878
879	def renderPDFAdmissionLetter(self, view, student=None, omit_fields=(),
880	pre_text=None, post_text=None,
881	topMargin = 1.5,
882	letterhead_path=None,
883	mergefiles=None, watermark=None):
884	"""Render pdf admission letter.
885	"""
886	if student is None:
887	return
888	style = getSampleStyleSheet()
889	if letterhead_path:
890	creator = getUtility(IPDFCreator, name='letter')
891	else:
892	creator = self.getPDFCreator(student)
893	portal_language = getUtility(IKofaUtils).PORTAL_LANGUAGE
894	data = []
895	doc_title = view.label
896	author = '%s (%s)' % (view.request.principal.title,
897	view.request.principal.id)
898	footer_text = view.label.split('\n')
899	if len(footer_text) > 2:
900	# We can add a department in first line
901	footer_text = footer_text[1]
902	else:
903	# Only the first line is used for the footer
904	footer_text = footer_text[0]
905	if getattr(student, 'student_id', None) is not None:
906	footer_text = "%s - %s - " % (student.student_id, footer_text)
907
908	# Text before student data
909	if pre_text is None:
910	html = format_html(self._admissionText(student, portal_language))
911	else:
912	html = format_html(pre_text)
913	if html:
914	data.append(Paragraph(html, NOTE_STYLE))
915	data.append(Spacer(1, 20))
916
917	# Student data
918	data.append(render_student_data(view, student,
919	omit_fields, lang=portal_language,
920	slipname='admission_slip.pdf'))
921
922	# Text after student data
923	data.append(Spacer(1, 20))
924	if post_text is None:
925	datelist = student.history.messages[0].split()[0].split('-')
926	creation_date = u'%s/%s/%s' % (datelist[2], datelist[1], datelist[0])
927	post_text = trans(_(
928	'Your Kofa student record was created on ${a}.',
929	mapping = {'a': creation_date}),
930	portal_language)
931	#html = format_html(post_text)
932	#data.append(Paragraph(html, NOTE_STYLE))
933
934	# Create pdf stream
935	view.response.setHeader(
936	'Content-Type', 'application/pdf')
937	pdf_stream = creator.create_pdf(
938	data, None, doc_title, author=author, footer=footer_text,
939	note=post_text, topMargin=topMargin,
940	letterhead_path=letterhead_path)
941	if mergefiles:
942	merger = PdfFileMerger()
943	merger.append(StringIO(pdf_stream))
944	for file in mergefiles:
945	if watermark:
946	# Pass through all pages of each file
947	# and merge with watermark page. Paint
948	# watermark first to make it transparent.
949	marked_file = PdfFileWriter()
950	orig_file = PdfFileReader(file)
951	num_pages = orig_file.getNumPages()
952	for num in range(num_pages):
953	watermark_file = PdfFileReader(watermark)
954	page = watermark_file.getPage(0)
955	page.mergePage(orig_file.getPage(num))
956	marked_file.addPage(page)
957	# Save into a file-like object
958	tmp1 = StringIO()
959	marked_file.write(tmp1)
960	# Append the file-like object
961	merger.append(tmp1)
962	else:
963	# Just append the file object
964	merger.append(file)
965	# Save into a file-like object
966	tmp2 = StringIO()
967	merger.write(tmp2)
968	return tmp2.getvalue()
969	return pdf_stream
970
971	def renderPDFTranscript(self, view, filename='transcript.pdf',
972	student=None,
973	studentview=None,
974	note=None,
975	signatures=(),
976	sigs_in_footer=(),
977	digital_sigs=(),
978	show_scans=True, topMargin=1.5,
979	omit_fields=(),
980	tableheader=None,
981	no_passport=False,
982	save_file=False):
983	"""Render pdf slip of a transcripts.
984	"""
985	portal_language = getUtility(IKofaUtils).PORTAL_LANGUAGE
986	# XXX: tell what the different parameters mean
987	style = getSampleStyleSheet()
988	creator = self.getPDFCreator(student)
989	data = []
990	doc_title = view.label
991	author = '%s (%s)' % (view.request.principal.title,
992	view.request.principal.id)
993	footer_text = view.label.split('\n')
994	if len(footer_text) > 2:
995	# We can add a department in first line
996	footer_text = footer_text[1]
997	else:
998	# Only the first line is used for the footer
999	footer_text = footer_text[0]
1000	if getattr(student, 'student_id', None) is not None:
1001	footer_text = "%s - %s - " % (student.student_id, footer_text)
1002
1003	# Insert student data table
1004	if student is not None:
1005	#bd_translation = trans(_('Base Data'), portal_language)
1006	#data.append(Paragraph(bd_translation, HEADING_STYLE))
1007	data.append(render_student_data(
1008	studentview, view.context,
1009	omit_fields, lang=portal_language,
1010	slipname=filename,
1011	no_passport=no_passport))
1012
1013	transcript_data = view.context.getTranscriptData()
1014	levels_data = transcript_data[0]
1015
1016	contextdata = []
1017	f_label = trans(_('Course of Study:'), portal_language)
1018	f_label = Paragraph(f_label, ENTRY1_STYLE)
1019	f_text = formatted_text(view.context.certificate.longtitle)
1020	f_text = Paragraph(f_text, ENTRY1_STYLE)
1021	contextdata.append([f_label,f_text])
1022
1023	f_label = trans(_('Faculty:'), portal_language)
1024	f_label = Paragraph(f_label, ENTRY1_STYLE)
1025	f_text = formatted_text(
1026	view.context.certificate.__parent__.__parent__.__parent__.longtitle)
1027	f_text = Paragraph(f_text, ENTRY1_STYLE)
1028	contextdata.append([f_label,f_text])
1029
1030	f_label = trans(_('Department:'), portal_language)
1031	f_label = Paragraph(f_label, ENTRY1_STYLE)
1032	f_text = formatted_text(
1033	view.context.certificate.__parent__.__parent__.longtitle)
1034	f_text = Paragraph(f_text, ENTRY1_STYLE)
1035	contextdata.append([f_label,f_text])
1036
1037	f_label = trans(_('Entry Session:'), portal_language)
1038	f_label = Paragraph(f_label, ENTRY1_STYLE)
1039	f_text = formatted_text(
1040	view.session_dict.get(view.context.entry_session))
1041	f_text = Paragraph(f_text, ENTRY1_STYLE)
1042	contextdata.append([f_label,f_text])
1043
1044	f_label = trans(_('Entry Mode:'), portal_language)
1045	f_label = Paragraph(f_label, ENTRY1_STYLE)
1046	f_text = formatted_text(view.studymode_dict.get(
1047	view.context.entry_mode))
1048	f_text = Paragraph(f_text, ENTRY1_STYLE)
1049	contextdata.append([f_label,f_text])
1050
1051	f_label = trans(_('Cumulative GPA:'), portal_language)
1052	f_label = Paragraph(f_label, ENTRY1_STYLE)
1053	format_float = getUtility(IKofaUtils).format_float
1054	cgpa = format_float(transcript_data[1], 3)
1055	if student.state == GRADUATED:
1056	f_text = formatted_text('%s (%s)' % (
1057	cgpa, self.getClassFromCGPA(transcript_data[1], student)[1]))
1058	else:
1059	f_text = formatted_text('%s' % cgpa)
1060	f_text = Paragraph(f_text, ENTRY1_STYLE)
1061	contextdata.append([f_label,f_text])
1062
1063	contexttable = Table(contextdata,style=SLIP_STYLE)
1064	data.append(contexttable)
1065
1066	transcripttables = render_transcript_data(
1067	view, tableheader, levels_data, lang=portal_language)
1068	data.extend(transcripttables)
1069
1070	# Insert signatures
1071	# XXX: We are using only sigs_in_footer in waeup.kofa, so we
1072	# do not have a test for the following lines.
1073	if signatures and not sigs_in_footer:
1074	data.append(Spacer(1, 20))
1075	# Render one signature table per signature to
1076	# get date and signature in line.
1077	for signature in signatures:
1078	signaturetables = get_signature_tables(signature)
1079	data.append(signaturetables[0])
1080
1081	# Insert digital signatures
1082	if digital_sigs:
1083	data.append(Spacer(1, 20))
1084	sigs = digital_sigs.split('\n')
1085	for sig in sigs:
1086	data.append(Paragraph(sig, NOTE_STYLE))
1087
1088	view.response.setHeader(
1089	'Content-Type', 'application/pdf')
1090	try:
1091	pdf_stream = creator.create_pdf(
1092	data, None, doc_title, author=author, footer=footer_text,
1093	note=note, sigs_in_footer=sigs_in_footer, topMargin=topMargin)
1094	except IOError:
1095	view.flash(_('Error in image file.'))
1096	return view.redirect(view.url(view.context))
1097	if save_file:
1098	self._saveTranscriptPDF(student, pdf_stream)
1099	return
1100	return pdf_stream
1101
1102	def renderPDFCourseticketsOverview(
1103	self, view, name, session, data, lecturers, orientation,
1104	title_length, note):
1105	"""Render pdf slip of course tickets for a lecturer.
1106	"""
1107	filename = '%s_%s_%s_%s.pdf' % (
1108	name, view.context.code, session, view.request.principal.id)
1109	try:
1110	session = academic_sessions_vocab.getTerm(session).title
1111	except LookupError:
1112	session = _('void')
1113	creator = getUtility(IPDFCreator, name=orientation)
1114	style = getSampleStyleSheet()
1115	pdf_data = []
1116	pdf_data += [Paragraph(
1117	translate(_('<b>Lecturer(s): ${a}</b>',
1118	mapping = {'a':lecturers})), style["Normal"]),]
1119	pdf_data += [Paragraph(
1120	translate(_('<b>Credits: ${a}</b>',
1121	mapping = {'a':view.context.credits})), style["Normal"]),]
1122	# Not used in base package.
1123	if data[1]:
1124	pdf_data += [Paragraph(
1125	translate(_('<b>${a}</b>',
1126	mapping = {'a':data[1][0]})), style["Normal"]),]
1127	pdf_data += [Paragraph(
1128	translate(_('<b>${a}</b>',
1129	mapping = {'a':data[1][1]})), style["Normal"]),]
1130	pdf_data += [Paragraph(
1131	translate(_('<b>Total Students: ${a}</b>',
1132	mapping = {'a':data[1][2]})), style["Normal"]),]
1133	pdf_data += [Paragraph(
1134	translate(_('<b>Total Pass: ${a} (${b}%)</b>',
1135	mapping = {'a':data[1][3],'b':data[1][4]})), style["Normal"]),]
1136	pdf_data += [Paragraph(
1137	translate(_('<b>Total Fail: ${a} (${b}%)</b>',
1138	mapping = {'a':data[1][5],'b':data[1][6]})), style["Normal"]),]
1139	grade_stats = []
1140	for item in sorted(data[1][7].items()):
1141	grade_stats.append(('%s=%s' % (item[0], item[1])))
1142	grade_stats_string = ', '.join(grade_stats)
1143	pdf_data += [Paragraph(
1144	translate(_('<b>${a}</b>',
1145	mapping = {'a':grade_stats_string})), style["Normal"]),]
1146	pdf_data.append(Spacer(1, 20))
1147	colWidths = [None] * len(data[0][0])
1148	pdf_data += [Table(data[0], colWidths=colWidths, style=CONTENT_STYLE,
1149	repeatRows=1)]
1150	# Process title if too long
1151	title = " ".join(view.context.title.split())
1152	ct = textwrap.fill(title, title_length)
1153	ft = "" # title
1154	#if len(textwrap.wrap(title, title_length)) > 1:
1155	# ft = textwrap.wrap(title, title_length)[0] + ' ...'
1156	doc_title = translate(_('${a} (${b})\nAcademic Session ${d}',
1157	mapping = {'a':ct,
1158	'b':view.context.code,
1159	'd':session}))
1160	if name == 'attendance':
1161	doc_title += '\n' + translate(_('Attendance Sheet'))
1162	if name == 'coursetickets':
1163	doc_title += '\n' + translate(_('Course Tickets Overview'))
1164	#footer_title = translate(_('${a} (${b}) - ${d}',
1165	# mapping = {'a':ft,
1166	# 'b':view.context.code,
1167	# 'd':session}))
1168	footer_title = translate(_('${b} - ${d}',
1169	mapping = {'b':view.context.code,
1170	'd':session}))
1171	author = '%s (%s)' % (view.request.principal.title,
1172	view.request.principal.id)
1173	view.response.setHeader(
1174	'Content-Type', 'application/pdf')
1175	view.response.setHeader(
1176	'Content-Disposition:', 'attachment; filename="%s' % filename)
1177	pdf_stream = creator.create_pdf(
1178	pdf_data, None, doc_title, author, footer_title + ' -', note
1179	)
1180	return pdf_stream
1181
1182	def updateCourseTickets(self, course):
1183	"""Udate course tickets if course attributes were changed.
1184	"""
1185	current_academic_session = grok.getSite()[
1186	'configuration'].current_academic_session
1187	if not current_academic_session:
1188	return
1189	cat = queryUtility(ICatalog, name='coursetickets_catalog')
1190	coursetickets = cat.searchResults(
1191	code=(course.code, course.code),
1192	session=(current_academic_session,current_academic_session))
1193	number = 0
1194	ob_class = self.__implemented__.__name__.replace('waeup.kofa.', '')
1195	for ticket in coursetickets:
1196	if ticket.credits == course.credits:
1197	continue
1198	if ticket.student.current_session != current_academic_session:
1199	continue
1200	if ticket.student.state not in (PAID,):
1201	continue
1202	number += 1
1203	ticket.student.__parent__.logger.info(
1204	'%s - %s %s/%s credits updated (%s->%s)' % (
1205	ob_class, ticket.student.student_id,
1206	ticket.level, ticket.code, course.credits,
1207	ticket.credits))
1208	ticket.credits = course.credits
1209	return number
1210
1211	#: A dictionary which maps widget names to headlines. The headline
1212	#: is rendered in forms and on pdf slips above the respective
1213	#: display or input widget. There are no separating headlines
1214	#: in the base package.
1215	SEPARATORS_DICT = {}
1216
1217	#: A tuple containing names of file upload viewlets which are not shown
1218	#: on the `StudentClearanceManageFormPage`. Nothing is being skipped
1219	#: in the base package. This attribute makes only sense, if intermediate
1220	#: custom packages are being used, like we do for all Nigerian portals.
1221	SKIP_UPLOAD_VIEWLETS = ()
1222
1223	#: A tuple containing the names of registration states in which changing of
1224	#: passport pictures is allowed.
1225	PORTRAIT_CHANGE_STATES = (ADMITTED,)
1226
1227	#: A tuple containing all exporter names referring to students or
1228	#: subobjects thereof.
1229	STUDENT_EXPORTER_NAMES = (
1230	'students',
1231	'studentstudycourses',
1232	'studentstudylevels',
1233	'coursetickets',
1234	'studentpayments',
1235	'bedtickets',
1236	'trimmed',
1237	'outstandingcourses',
1238	'unpaidpayments',
1239	'sfpaymentsoverview',
1240	'sessionpaymentsoverview',
1241	'studylevelsoverview',
1242	'combocard',
1243	'bursary',
1244	'accommodationpayments',
1245	'transcriptdata',
1246	'trimmedpayments',
1247	)
1248
1249	#: A tuple containing all exporter names needed for backing
1250	#: up student data
1251	STUDENT_BACKUP_EXPORTER_NAMES = ('students', 'studentstudycourses',
1252	'studentstudylevels', 'coursetickets',
1253	'studentpayments', 'bedtickets')
1254
1255	# Maximum size of upload files in kB
1256	MAX_KB = 250
1257
1258	#: A prefix used when generating new student ids. Each student id will
1259	#: start with this string. The default is 'K' for Kofa.
1260	STUDENT_ID_PREFIX = u'K'

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

Download in other formats: