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

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

Show more information on PDFCourseticketsOverview.
  • Property svn:keywords set to Id
File size: 43.6 KB
Line 
1## $Id: utils.py 14151 2016-09-02 09:46:35Z 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 (also some pages
726        in the applicants module).
727        """
728        portal_language = getUtility(IKofaUtils).PORTAL_LANGUAGE
729        # XXX: tell what the different parameters mean
730        style = getSampleStyleSheet()
731        creator = self.getPDFCreator(student)
732        data = []
733        doc_title = view.label
734        author = '%s (%s)' % (view.request.principal.title,
735                              view.request.principal.id)
736        footer_text = view.label.split('\n')
737        if len(footer_text) > 1:
738            # We can add a department in first line, second line is used
739            footer_text = footer_text[1]
740        else:
741            # Only the first line is used for the footer
742            footer_text = footer_text[0]
743        if getattr(student, 'student_id', None) is not None:
744            footer_text = "%s - %s - " % (student.student_id, footer_text)
745
746        # Insert student data table
747        if student is not None:
748            bd_translation = trans(_('Base Data'), portal_language)
749            data.append(Paragraph(bd_translation, HEADING_STYLE))
750            data.append(render_student_data(
751                studentview, view.context, omit_fields, lang=portal_language,
752                slipname=filename))
753
754        # Insert widgets
755        if view.form_fields:
756            data.append(Paragraph(view.title, HEADING_STYLE))
757            separators = getattr(self, 'SEPARATORS_DICT', {})
758            table = creator.getWidgetsTable(
759                view.form_fields, view.context, None, lang=portal_language,
760                separators=separators)
761            data.append(table)
762
763        # Insert scanned docs
764        if show_scans:
765            data.extend(docs_as_flowables(view, portal_language))
766
767        # Insert history
768        if filename.startswith('clearance'):
769            hist_translation = trans(_('Workflow History'), portal_language)
770            data.append(Paragraph(hist_translation, HEADING_STYLE))
771            data.extend(creator.fromStringList(student.history.messages))
772
773        # Insert content tables (optionally on second page)
774        if hasattr(view, 'tabletitle'):
775            for i in range(len(view.tabletitle)):
776                if tabledata[i] and tableheader[i]:
777                    #data.append(PageBreak())
778                    #data.append(Spacer(1, 20))
779                    data.append(Paragraph(view.tabletitle[i], HEADING_STYLE))
780                    data.append(Spacer(1, 8))
781                    contenttable = render_table_data(tableheader[i],tabledata[i])
782                    data.append(contenttable)
783
784        # Insert signatures
785        # XXX: We are using only sigs_in_footer in waeup.kofa, so we
786        # do not have a test for the following lines.
787        if signatures and not sigs_in_footer:
788            data.append(Spacer(1, 20))
789            # Render one signature table per signature to
790            # get date and signature in line.
791            for signature in signatures:
792                signaturetables = get_signature_tables(signature)
793                data.append(signaturetables[0])
794
795        view.response.setHeader(
796            'Content-Type', 'application/pdf')
797        try:
798            pdf_stream = creator.create_pdf(
799                data, None, doc_title, author=author, footer=footer_text,
800                note=note, sigs_in_footer=sigs_in_footer, topMargin=topMargin)
801        except IOError:
802            view.flash('Error in image file.')
803            return view.redirect(view.url(view.context))
804        return pdf_stream
805
806    gpa_boundaries = ((1, 'Fail'),
807                      (1.5, 'Pass'),
808                      (2.4, '3rd Class'),
809                      (3.5, '2nd Class Lower'),
810                      (4.5, '2nd Class Upper'),
811                      (5, '1st Class'))
812
813    def getClassFromCGPA(self, gpa):
814        if gpa < self.gpa_boundaries[0][0]:
815            return 0, self.gpa_boundaries[0][1]
816        if gpa < self.gpa_boundaries[1][0]:
817            return 1, self.gpa_boundaries[1][1]
818        if gpa < self.gpa_boundaries[2][0]:
819            return 2, self.gpa_boundaries[2][1]
820        if gpa < self.gpa_boundaries[3][0]:
821            return 3, self.gpa_boundaries[3][1]
822        if gpa < self.gpa_boundaries[4][0]:
823            return 4, self.gpa_boundaries[4][1]
824        if gpa <= self.gpa_boundaries[5][0]:
825            return 5, self.gpa_boundaries[5][1]
826        return 'N/A'
827
828    def renderPDFTranscript(self, view, filename='transcript.pdf',
829                  student=None,
830                  studentview=None,
831                  note=None, signatures=None, sigs_in_footer=(),
832                  show_scans=True, topMargin=1.5,
833                  omit_fields=(),
834                  tableheader=None):
835        """Render pdf slips for transcripts.
836        """
837        portal_language = getUtility(IKofaUtils).PORTAL_LANGUAGE
838        # XXX: tell what the different parameters mean
839        style = getSampleStyleSheet()
840        creator = self.getPDFCreator(student)
841        data = []
842        doc_title = view.label
843        author = '%s (%s)' % (view.request.principal.title,
844                              view.request.principal.id)
845        footer_text = view.label.split('\n')
846        if len(footer_text) > 2:
847            # We can add a department in first line
848            footer_text = footer_text[1]
849        else:
850            # Only the first line is used for the footer
851            footer_text = footer_text[0]
852        if getattr(student, 'student_id', None) is not None:
853            footer_text = "%s - %s - " % (student.student_id, footer_text)
854
855        # Insert student data table
856        if student is not None:
857            #bd_translation = trans(_('Base Data'), portal_language)
858            #data.append(Paragraph(bd_translation, HEADING_STYLE))
859            data.append(render_student_data(
860                studentview, view.context,
861                omit_fields, lang=portal_language,
862                slipname=filename))
863
864        transcript_data = view.context.getTranscriptData()
865        levels_data = transcript_data[0]
866        gpa = transcript_data[1]
867
868        contextdata = []
869        f_label = trans(_('Course of Study:'), portal_language)
870        f_label = Paragraph(f_label, ENTRY1_STYLE)
871        f_text = formatted_text(view.context.certificate.longtitle)
872        f_text = Paragraph(f_text, ENTRY1_STYLE)
873        contextdata.append([f_label,f_text])
874
875        f_label = trans(_('Faculty:'), portal_language)
876        f_label = Paragraph(f_label, ENTRY1_STYLE)
877        f_text = formatted_text(
878            view.context.certificate.__parent__.__parent__.__parent__.longtitle)
879        f_text = Paragraph(f_text, ENTRY1_STYLE)
880        contextdata.append([f_label,f_text])
881
882        f_label = trans(_('Department:'), portal_language)
883        f_label = Paragraph(f_label, ENTRY1_STYLE)
884        f_text = formatted_text(
885            view.context.certificate.__parent__.__parent__.longtitle)
886        f_text = Paragraph(f_text, ENTRY1_STYLE)
887        contextdata.append([f_label,f_text])
888
889        f_label = trans(_('Entry Session:'), portal_language)
890        f_label = Paragraph(f_label, ENTRY1_STYLE)
891        f_text = formatted_text(
892            view.session_dict.get(view.context.entry_session))
893        f_text = Paragraph(f_text, ENTRY1_STYLE)
894        contextdata.append([f_label,f_text])
895
896        f_label = trans(_('Entry Mode:'), portal_language)
897        f_label = Paragraph(f_label, ENTRY1_STYLE)
898        f_text = formatted_text(view.studymode_dict.get(
899            view.context.entry_mode))
900        f_text = Paragraph(f_text, ENTRY1_STYLE)
901        contextdata.append([f_label,f_text])
902
903        f_label = trans(_('Cumulative GPA:'), portal_language)
904        f_label = Paragraph(f_label, ENTRY1_STYLE)
905        f_text = formatted_text('%s (%s)' % (gpa, self.getClassFromCGPA(gpa)[1]))
906        f_text = Paragraph(f_text, ENTRY1_STYLE)
907        contextdata.append([f_label,f_text])
908
909        contexttable = Table(contextdata,style=SLIP_STYLE)
910        data.append(contexttable)
911
912        transcripttables = render_transcript_data(
913            view, tableheader, levels_data, lang=portal_language)
914        data.extend(transcripttables)
915
916        # Insert signatures
917        # XXX: We are using only sigs_in_footer in waeup.kofa, so we
918        # do not have a test for the following lines.
919        if signatures and not sigs_in_footer:
920            data.append(Spacer(1, 20))
921            # Render one signature table per signature to
922            # get date and signature in line.
923            for signature in signatures:
924                signaturetables = get_signature_tables(signature)
925                data.append(signaturetables[0])
926
927        view.response.setHeader(
928            'Content-Type', 'application/pdf')
929        try:
930            pdf_stream = creator.create_pdf(
931                data, None, doc_title, author=author, footer=footer_text,
932                note=note, sigs_in_footer=sigs_in_footer, topMargin=topMargin)
933        except IOError:
934            view.flash(_('Error in image file.'))
935            return view.redirect(view.url(view.context))
936        return pdf_stream
937
938    def renderPDFCourseticketsOverview(
939            self, view, session, table_data, lecturers):
940        filename = 'coursetickets_%s_%s_%s.pdf' % (
941            view.context.code, session, view.request.principal.id)
942        session = academic_sessions_vocab.getTerm(session).title
943        creator = getUtility(IPDFCreator, name='landscape')
944        style = getSampleStyleSheet()
945        pdf_data = [Paragraph(
946            translate(_('<b>Lecturer(s): ${a}</b>',
947                      mapping = {'a':lecturers})), style["Normal"]),]
948        pdf_data += [Paragraph(
949            translate(_('<b>Credits: ${a}</b>',
950                      mapping = {'a':view.context.credits})), style["Normal"]),]
951        pdf_data.append(Spacer(1, 20))
952        pdf_data += [Table(table_data, style=CONTENT_STYLE)]
953        doc_title = translate(_('${a} (${b}) - Academic Session ${d}',
954            mapping = {'a':view.context.title,
955                       'b':view.context.code,
956                       'd':session}))
957        author = '%s (%s)' % (view.request.principal.title,
958                              view.request.principal.id)
959        view.response.setHeader(
960            'Content-Type', 'application/pdf')
961        view.response.setHeader(
962            'Content-Disposition:', 'attachment; filename="%s' % filename)
963        pdf_stream = creator.create_pdf(
964            pdf_data, None, doc_title, author, doc_title + ' -'
965            )
966        return pdf_stream
967
968    def maxCredits(self, studylevel):
969        """Return maximum credits.
970        At some universities maximum credits is not constant, it
971        depends on the student's study level. Set `maxCredits` None or 0
972        in order to deactivate the limitation.
973        """
974        return 50
975
976    def maxCreditsExceeded(self, studylevel, course):
977        max_credits = self.maxCredits(studylevel)
978        if max_credits and \
979            studylevel.total_credits + course.credits > max_credits:
980            return max_credits
981        return 0
982
983    def getBedCoordinates(self, bedticket):
984        """Return descriptive bed coordinates.
985        This method can be used to customize the `display_coordinates`
986        property method in order to  display a
987        customary description of the bed space.
988        """
989        return bedticket.bed_coordinates
990
991    def clearance_disabled_message(self, student):
992        try:
993            session_config = grok.getSite()[
994                'configuration'][str(student.current_session)]
995        except KeyError:
996            return _('Session configuration object is not available.')
997        if not session_config.clearance_enabled:
998            return _('Clearance is disabled for this session.')
999        return None
1000
1001    #: A dictionary which maps widget names to headlines. The headline
1002    #: is rendered in forms and on pdf slips above the respective
1003    #: display or input widget. There are no separating headlines
1004    #: in the base package.
1005    SEPARATORS_DICT = {}
1006
1007    #: A tuple containing names of file upload viewlets which are not shown
1008    #: on the `StudentClearanceManageFormPage`. Nothing is being skipped
1009    #: in the base package. This attribute makes only sense, if intermediate
1010    #: custom packages are being used, like we do for all Nigerian portals.
1011    SKIP_UPLOAD_VIEWLETS = ()
1012
1013    #: A tuple containing the names of registration states in which changing of
1014    #: passport pictures is allowed.
1015    PORTRAIT_CHANGE_STATES = (ADMITTED,)
1016
1017    #: A tuple containing all exporter names referring to students or
1018    #: subobjects thereof.
1019    STUDENT_EXPORTER_NAMES = ('students', 'studentstudycourses',
1020            'studentstudylevels', 'coursetickets',
1021            'studentpayments', 'studentunpaidpayments',
1022            'bedtickets', 'paymentsoverview',
1023            'studylevelsoverview', 'combocard', 'bursary')
1024
1025    #: A tuple containing all exporter names needed for backing
1026    #: up student data
1027    STUDENT_BACKUP_EXPORTER_NAMES = ('students', 'studentstudycourses',
1028            'studentstudylevels', 'coursetickets',
1029            'studentpayments', 'bedtickets')
1030
1031    #: A prefix used when generating new student ids. Each student id will
1032    #: start with this string. The default is 'K' for Kofa.
1033    STUDENT_ID_PREFIX = u'K'
Note: See TracBrowser for help on using the repository browser.