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

Last change on this file since 16326 was 16299, checked in by Henrik Bettermann, 4 years ago

Implement bulk emailing.

  • Property svn:keywords set to Id
File size: 13.8 KB
RevLine 
[7358]1## $Id: utils.py 16299 2020-11-04 17:52:22Z 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##
[7819]18"""General helper utilities for Kofa.
[7358]19"""
20import grok
[11815]21import psutil
[7365]22import string
[8181]23import pytz
[15476]24import decimal
[9866]25from copy import deepcopy
[8181]26from random import SystemRandom as r
[7734]27from zope.i18n import translate
[7819]28from waeup.kofa.interfaces import IKofaUtils
[7811]29from waeup.kofa.interfaces import MessageFactory as _
30from waeup.kofa.smtp import send_mail as send_mail_internally
[7969]31from waeup.kofa.utils.helpers import get_sorted_preferred
[13617]32from waeup.kofa.utils.degrees import DEGREES_DICT
[7358]33
[11814]34
35def send_mail(from_name, from_addr,
36              rcpt_name, rcpt_addr,
[16299]37              subject, body, config,
38              cc=None, bcc=None):
[7811]39    """Wrapper for the real SMTP functionality in :mod:`waeup.kofa.smtp`.
[7382]40
[7471]41    Merely here to stay compatible with lots of calls to this place.
[7400]42    """
[7471]43    mail_id = send_mail_internally(
44        from_name, from_addr, rcpt_name, rcpt_addr,
[16299]45        subject, body, config, cc, bcc)
[7399]46    return True
47
[11814]48
[7874]49#: A list of phone prefixes (order num, country, prefix).
50#: Items with same order num will be sorted alphabetically.
51#: The lower the order num, the higher the precedence.
52INT_PHONE_PREFIXES = [
53    (99, _('Germany'), '49'),
[11814]54    (1, _('Nigeria'), '234'),
[7874]55    (99, _('U.S.'), '1'),
56    ]
57
[11814]58
59def sorted_phone_prefixes(data=INT_PHONE_PREFIXES, request=None):
[7874]60    """Sorted tuples of phone prefixes.
61
62    Ordered as shown above and formatted for use in select boxes.
63
64    If request is given, we'll try to translate all country names in
65    order to sort alphabetically correctly.
66
67    XXX: This is a function (and not a constant) as different
68    languages might give different orders. This is not tested yet.
69
70    XXX: If we really want to use alphabetic ordering here, we might
71    think about caching results of translations.
72    """
73    if request is not None:
74        data = [
75            (x, translate(y, context=request), z)
76            for x, y, z in data]
77    return tuple([
[11814]78        ('%s (+%s)' % (x[1], x[2]), '+%s' % x[2])
[7874]79        for x in sorted(data)
80        ])
81
[11814]82
[7831]83class KofaUtils(grok.GlobalUtility):
[7678]84    """A collection of parameters and methods subject to customization.
[7358]85    """
[7831]86    grok.implements(IKofaUtils)
[13132]87
88    #: This the only place where we define the portal language
89    #: which is used for the translation of system messages
90    #: (e.g. object histories) pdf slips.
[7744]91    PORTAL_LANGUAGE = 'en'
[7358]92
[13617]93    DEGREES_DICT = DEGREES_DICT
94
[7701]95    PREFERRED_LANGUAGES_DICT = {
[11814]96        'en': (1, u'English'),
97        'fr': (2, u'Français'),
98        'de': (3, u'Deutsch'),
99        'ha': (4, u'Hausa'),
100        'yo': (5, u'Yoruba'),
101        'ig': (6, u'Igbo'),
[7701]102        }
103
[7874]104    #: A function to return
105    @classmethod
106    def sorted_phone_prefixes(cls, data=INT_PHONE_PREFIXES, request=None):
107        return sorted_phone_prefixes(data, request)
[7871]108
[7841]109    EXAM_SUBJECTS_DICT = {
[7843]110        'math': 'Mathematics',
111        'computer_science': 'Computer Science',
[7841]112        }
[7836]113
[7917]114    #: Exam grades. The tuple is sorted as it should be displayed in
115    #: select boxes.
116    EXAM_GRADES = (
117        ('A', 'Best'),
118        ('B', 'Better'),
119        ('C', 'Good'),
120        )
[7836]121
[7841]122    INST_TYPES_DICT = {
[8084]123        'none': '',
[7681]124        'faculty': 'Faculty of',
125        'department': 'Department of',
126        'school': 'School of',
127        'office': 'Office for',
128        'centre': 'Centre for',
129        'institute': 'Institute of',
130        'school_for': 'School for',
[8084]131        'college': 'College of',
[10302]132        'directorate': 'Directorate of',
[7681]133        }
134
[7841]135    STUDY_MODES_DICT = {
[9131]136        'transfer': 'Transfer',
[7843]137        'ug_ft': 'Undergraduate Full-Time',
138        'ug_pt': 'Undergraduate Part-Time',
[7993]139        'pg_ft': 'Postgraduate Full-Time',
140        'pg_pt': 'Postgraduate Part-Time',
[7681]141        }
142
[11451]143    DISABLE_PAYMENT_GROUP_DICT = {
144        'sf_all': 'School Fee - All Students',
145        }
146
[7841]147    APP_CATS_DICT = {
[7843]148        'basic': 'Basic Application',
[7681]149        'no': 'no application',
150        'pg': 'Postgraduate',
151        'sandwich': 'Sandwich',
152        'cest': 'Part-Time, Diploma, Certificate'
153        }
154
[7841]155    SEMESTER_DICT = {
[10437]156        1: '1st Semester',
157        2: '2nd Semester',
[7681]158        3: 'Combined',
159        9: 'N/A'
160        }
161
[14638]162    COURSE_CATEGORY_DICT = {
163        }
164
[9400]165    SPECIAL_HANDLING_DICT = {
166        'regular': 'Regular Hostel',
167        'blocked': 'Blocked Hostel',
[10831]168        'pg': 'Postgraduate Hostel'
[9400]169        }
170
[10831]171    SPECIAL_APP_DICT = {
172        'transcript': 'Transcript Fee Payment',
[11575]173        'clearance': 'Acceptance Fee',
[10831]174        }
175
[9405]176    PAYMENT_CATEGORIES = {
177        'schoolfee': 'School Fee',
178        'clearance': 'Acceptance Fee',
179        'bed_allocation': 'Bed Allocation Fee',
180        'hostel_maintenance': 'Hostel Maintenance Fee',
181        'transfer': 'Transfer Fee',
182        'gown': 'Gown Hire Fee',
[9866]183        'application': 'Application Fee',
[15553]184        'app_balance': 'Application Fee Balance',
[10449]185        'transcript': 'Transcript Fee',
[15664]186        'late_registration': 'Late Course Registration Fee',
[15685]187        'combi': 'Combi Payment',
[9405]188        }
189
[15432]190    def selectable_payment_categories(self, student):
191        return self.PAYMENT_CATEGORIES
[9730]192
[15432]193    PREVIOUS_PAYMENT_CATEGORIES = deepcopy(PAYMENT_CATEGORIES)
[9862]194
[12564]195    REPORTABLE_PAYMENT_CATEGORIES = {
196        'schoolfee': 'School Fee',
197        'clearance': 'Acceptance Fee',
198        'hostel_maintenance': 'Hostel Maintenance Fee',
199        'gown': 'Gown Hire Fee',
200        }
201
[9868]202    BALANCE_PAYMENT_CATEGORIES = {
[9867]203        'schoolfee': 'School Fee',
204        }
[9864]205
[15664]206    COMBI_PAYMENT_CATEGORIES = {
207        'gown': 'Gown Hire Fee',
208        'transcript': 'Transcript Fee',
209        'late_registration': 'Late Course Registration Fee',
210        }
211
[9649]212    MODE_GROUPS = {
[11814]213        'All': ('all',),
214        'Undergraduate Full-Time': ('ug_ft',),
215        'Undergraduate Part-Time': ('ug_pt',),
216        'Postgraduate Full-Time': ('pg_ft',),
217        'Postgraduate Part-Time': ('pg_pt',),
[9649]218        }
219
[13125]220    VERDICTS_DICT = {
221        '0': _('(not yet)'),
222        'A': 'Successful student',
223        'B': 'Student with carryover courses',
224        'C': 'Student on probation',
225        }
226
[11800]227    #: Set positive number for allowed max, negative for required min
228    #: avail.
229    #: Use integer for bytes value, float for percent
230    #: value. `cpu-load`, of course, accepts float values only.
231    #: `swap-mem` = Swap Memory, `virt-mem` = Virtual Memory,
[11969]232    #: `cpu-load` = CPU load in percent.
[11800]233    SYSTEM_MAX_LOAD = {
234        'swap-mem': None,
235        'virt-mem': None,
236        'cpu-load': 100.0,
237        }
238
[15430]239    #: Maximum number of files listed in `finished` subfolder
240    MAX_FILES = 100
241
[15833]242    #: Maximum size in Bytes of passport images in the applicants and
243    #: students section
244    MAX_PASSPORT_SIZE = 50 * 1024
245
[15609]246    #: Temporary passwords and parents password validity period
247    TEMP_PASSWORD_MINUTES = 10
248
[11814]249    def sendContactForm(self, from_name, from_addr, rcpt_name, rcpt_addr,
[16299]250                        from_username, usertype, portal, body, subject,
251                        bcc_to=None):
[7358]252        """Send an email with data provided by forms.
253        """
254        config = grok.getSite()['configuration']
[16213]255        text = _(u"""${e}
[7358]256
[16213]257---
258${a} (id: ${b})
259${d}
[7734]260""")
[11814]261        text = _(text, mapping={
262            'a': from_name,
263            'b': from_username,
264            'c': usertype,
265            'd': portal,
266            'e': body})
[7811]267        body = translate(text, 'waeup.kofa',
[7734]268            target_language=self.PORTAL_LANGUAGE)
[8436]269        if not (from_addr and rcpt_addr):
270            return False
[7400]271        return send_mail(
[11814]272            from_name, from_addr, rcpt_name, rcpt_addr,
[16299]273            subject, body, config, None, bcc_to)
[7359]274
[15964]275    def getUsers(self):
276        users = sorted(
277            grok.getSite()['users'].items(), key=lambda x: x[1].title)
278        for key, val in users:
279            yield(dict(name=key, val="%s (%s)" % (val.title, val.name)))
280
[8181]281    @property
282    def tzinfo(self):
[13124]283        """Time zone of the university.
284        """
[8181]285        # For Nigeria: pytz.timezone('Africa/Lagos')
[9543]286        # For Germany: pytz.timezone('Europe/Berlin')
[8181]287        return pytz.utc
288
[11814]289    def fullname(self, firstname, lastname, middlename=None):
[13124]290        """Construct fullname.
[7477]291        """
[7359]292        # We do not necessarily have the middlename attribute
293        if middlename:
[8603]294            name = '%s %s %s' % (firstname, middlename, lastname)
[7359]295        else:
[8603]296            name = '%s %s' % (firstname, lastname)
[13492]297        if '<' in name:
298            return 'XXX'
[11814]299        return string.capwords(
300            name.replace('-', ' - ')).replace(' - ', '-')
[7365]301
[15287]302    def genPassword(self, length=4, chars=string.letters + string.digits):
[7477]303        """Generate a random password.
304        """
[15287]305        return ''.join([
306            r().choice(string.uppercase) +
307            r().choice(string.lowercase) +
308            r().choice(string.digits) for i in range(length)])
[7365]309
[8853]310    def sendCredentials(self, user, password=None, url_info=None, msg=None):
[13124]311        """Send credentials as email. Input is the user for which credentials
312        are sent and the password. Method returns True or False to indicate
313        successful operation.
[7365]314        """
[7819]315        subject = 'Your Kofa credentials'
[7734]316        text = _(u"""Dear ${a},
[7365]317
[7734]318${b}
[7365]319Student Registration and Information Portal of
[7734]320${c}.
[7365]321
[7734]322Your user name: ${d}
323Your password: ${e}
[8853]324${f}
[7365]325
326Please remember your user name and keep
327your password secret!
328
[7382]329Please also note that passwords are case-sensitive.
330
[7365]331Regards
[7734]332""")
[7399]333        config = grok.getSite()['configuration']
334        from_name = config.name_admin
[7402]335        from_addr = config.email_admin
[7407]336        rcpt_name = user.title
337        rcpt_addr = user.email
[11814]338        text = _(text, mapping={
339            'a': rcpt_name,
340            'b': msg,
341            'c': config.name,
342            'd': user.name,
343            'e': password,
344            'f': url_info})
[7734]345
[7811]346        body = translate(text, 'waeup.kofa',
[7734]347            target_language=self.PORTAL_LANGUAGE)
[7399]348        return send_mail(
[11814]349            from_name, from_addr, rcpt_name, rcpt_addr,
350            subject, body, config)
[9987]351
[14014]352    def inviteReferee(self, referee, applicant, url_info=None):
353        """Send invitation email to referee.
354        """
355        config = grok.getSite()['configuration']
356        subject = 'Request for referee report from %s' % config.name
357        text = _(u"""Dear ${a},
358
[14040]359The candidate with Id ${b} and name ${c} applied to
360the ${d} to study ${e} for the ${f} session.
361The candidate has listed you as referee. You are thus required to kindly use
362the link below to provide your referral remarks on or before
363${g}.
[14014]364
[14040]365${h}
366
367Thank You
368
369The Secretary
370Post Graduate School
371${d}
[14014]372""")
373        from_name = config.name_admin
374        from_addr = config.email_admin
375        rcpt_name = referee.name
376        rcpt_addr = referee.email
[14040]377        session = '%s/%s' % (
378            applicant.__parent__.year, applicant.__parent__.year+1)
[14014]379        text = _(text, mapping={
380            'a': rcpt_name,
[14040]381            'b': applicant.applicant_id,
382            'c': applicant.display_fullname,
383            'd': config.name,
384            'e': applicant.course1.title,
385            'f': session,
386            'g': applicant.__parent__.enddate,
387            'h': url_info,
388            })
[14014]389
390        body = translate(text, 'waeup.kofa',
391            target_language=self.PORTAL_LANGUAGE)
392        return send_mail(
393            from_name, from_addr, rcpt_name, rcpt_addr,
394            subject, body, config)
395
[9987]396    def getPaymentItem(self, payment):
[13124]397        """Return payment item. This method can be used to customize the
398        `display_item` property attribute, e.g. in order to hide bed coordinates
399        if maintenance fee is not paid.
[9987]400        """
401        return payment.p_item
[11815]402
403    def expensive_actions_allowed(self, type=None, request=None):
404        """Tell, whether expensive actions are currently allowed.
405        Check system load/health (or other external circumstances) and
406        locally set values to see, whether expensive actions should be
407        allowed (`True`) or better avoided (`False`).
408        Use this to allow or forbid exports, report generations, or
409        similar actions.
410        """
411        max_values = self.SYSTEM_MAX_LOAD
[11816]412        for (key, func) in (
413            ('swap-mem', psutil.swap_memory),
[11818]414            ('virt-mem', psutil.virtual_memory),
[11816]415            ):
416            max_val = max_values.get(key, None)
417            if max_val is None:
418                continue
419            mem_val = func()
[11815]420            if isinstance(max_val, float):
[11816]421                # percents
[11821]422                if max_val < 0.0:
423                    max_val = 100.0 + max_val
[11816]424                if mem_val.percent > max_val:
[11815]425                    return False
426            else:
[11816]427                # number of bytes
[11821]428                if max_val < 0:
429                    max_val = mem_val.total + max_val
[11816]430                if mem_val.used > max_val:
[11815]431                    return False
432        return True
[13198]433
434    def export_disabled_message(self):
435        export_disabled_message = grok.getSite()[
436            'configuration'].export_disabled_message
437        if export_disabled_message:
438            return export_disabled_message
[14473]439        return None
440
441    def format_float(self, value, prec):
[15476]442        # >>> 4.6 * 100
443        # 459.99999999999994
444        value = decimal.Decimal(str(value))
[14473]445        # cut floating point value
446        value = int(pow(10, prec)*value) / (1.0*pow(10, prec))
447        return '{:{width}.{prec}f}'.format(value, width=0, prec=prec)
Note: See TracBrowser for help on using the repository browser.