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

Last change on this file since 13898 was 13898, checked in by Henrik Bettermann, 8 years ago

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