source: main/waeup.aaue/trunk/src/waeup/aaue/interswitch/browser.py @ 13649

Last change on this file since 13649 was 13644, checked in by Henrik Bettermann, 9 years ago

Change pay item id for regular school fee payments, see ticket #166.
  • Property svn:keywords set to Id
File size: 21.8 KB
Line 
1## $Id: browser.py 13644 2016-01-27 06:35:08Z henrik $
2##
3## Copyright (C) 2012 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##
18import httplib
19import hashlib
20import grok
21from zope.interface import Interface
22from zope.component import queryAdapter
23from waeup.kofa.interfaces import CLEARED
24from kofacustom.nigeria.interswitch.browser import (
25    InterswitchPaymentRequestWebservicePageStudent,
26    InterswitchPaymentRequestWebservicePageApplicant,
27    InterswitchPaymentVerifyWebservicePageApplicant,
28    InterswitchPaymentVerifyWebservicePageStudent,
29    InterswitchPageStudent, InterswitchPageApplicant,
30    )
31from waeup.aaue.students.interfaces import ICustomStudentOnlinePayment
32from waeup.aaue.applicants.interfaces import ICustomApplicantOnlinePayment
33from waeup.aaue.interfaces import MessageFactory as _
34
35PRODUCT_ID_PT = '5040'
36PRODUCT_ID_REGULAR = '5845'
37SITE_NAME = 'aaue.waeup.org'
38PROVIDER_ACCT = '2022866811'
39PROVIDER_BANK_ID = '8'
40PROVIDER_ITEM_NAME = 'BT Education'
41INSTITUTION_NAME = 'AAU Ekpoma'
42CURRENCY = '566'
43GATEWAY_AMT = 250.0
44POST_ACTION = 'https://webpay.interswitchng.com/paydirect/pay'
45
46HOST = 'webpay.interswitchng.com'
47URL = '/paydirect/api/v1/gettransaction.json'
48HTTPS = True
49MAC_REGULAR = '9718FA00B0F5070B388A9896ADCED9B2FB02D30F71E12E68BDADC63F6852A3496FF97D8A0F9DA9F753B911A49BB09BB87B55FD02046BD325C74C46C0123CF023'
50MAC_PT = '74424F1DFECD6058F153148255CDD55E16724B4F380ADB2C63C5D1D7A5675759010C8153DCB930AAF2D38903CBF7CE32B8A6BA2C16BBC46721DF2E3F3E4548E3'
51
52httplib.HTTPSConnection.debuglevel = 0
53
54
55def gateway_net_amt(fee):
56    if fee > GATEWAY_AMT:
57        return fee - GATEWAY_AMT
58    return 0.0
59
60def contr_agreement_applicant(applicant):
61    if applicant.__parent__.code[:2] in ('fp', 'pt'):
62        return 'first'
63    return 'second'
64
65def contr_agreement_student(student):
66    if student.current_mode == 'found' or student.current_mode.endswith('_pt'):
67        return 'first'
68    return 'second'
69
70class CustomInterswitchPageApplicant(InterswitchPageApplicant):
71    """ View which sends a POST request to the Interswitch
72    CollegePAY payment gateway.
73
74    So far only PT application has been configured.
75    """
76    grok.context(ICustomApplicantOnlinePayment)
77    action = POST_ACTION
78    site_name = SITE_NAME
79    currency = CURRENCY
80
81    def update(self):
82
83        error = self.init_update()
84        if error:
85            self.flash(error, type='danger')
86            self.redirect(self.url(self.context, '@@index'))
87            return
88        if contr_agreement_applicant(self.context.__parent__) == 'first':
89            self.product_id = PRODUCT_ID_PT
90            self.pay_item_id = '101'
91            self.mac = MAC_PT
92        else:
93            self.product_id = PRODUCT_ID_REGULAR
94            self.pay_item_id = '109'
95            self.mac = MAC_REGULAR
96        xmldict = {}
97        provider_amt = 1000.0
98        xmldict['institution_acct'] = '1010835352'
99        xmldict['institution_bank_id'] = '117'
100        xmldict['detail_ref'] = self.context.p_id
101        xmldict['provider_amt'] = 100 * provider_amt
102        xmldict['provider_acct'] = PROVIDER_ACCT
103        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
104        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
105        xmldict['institution_amt'] = 100 * (
106            self.context.amount_auth - provider_amt - GATEWAY_AMT)
107        xmldict['institution_item_name'] = self.category
108        xmldict['institution_name'] = INSTITUTION_NAME
109        # Interswitch amount is not part of the xml data
110        xmltext = """<payment_item_detail>
111<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
112<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
113<item_detail item_id="2" item_name="%(provider_item_name)s" item_amt="%(provider_amt)d" bank_id="%(provider_bank_id)s" acct_num="%(provider_acct)s" />
114</item_details>
115</payment_item_detail>""" % xmldict
116        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
117        self.context.provider_amt = provider_amt
118        self.context.gateway_amt = GATEWAY_AMT
119
120        hashargs = (
121            self.context.p_id +
122            self.product_id +
123            self.pay_item_id +
124            str(int(self.amount_auth)) +
125            self.site_redirect_url +
126            self.mac)
127        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
128
129        return
130
131class CustomInterswitchPageStudent(InterswitchPageStudent):
132    """ View which sends a POST request to the Interswitch
133    CollegePAY payment gateway.
134    """
135    grok.context(ICustomStudentOnlinePayment)
136    action = POST_ACTION
137    site_name = SITE_NAME
138    currency = CURRENCY
139    #pay_item_id = '101'
140
141    def update(self):
142        error = self.init_update()
143
144        ######################################
145        #error = 'Sorry, Interswitch payments are temporarily disabled.'
146        ######################################
147
148        if error:
149            self.flash(error, type='danger')
150            self.redirect(self.url(self.context, '@@index'))
151            return
152
153        student = self.student
154        p_session = self.context.p_session
155        try:
156            academic_session = grok.getSite()['configuration'][str(p_session)]
157        except KeyError:
158            self.flash(_(u'Session configuration object is not available.'),
159                       type='danger')
160            self.redirect(self.url(self.context, '@@index'))
161            return
162        if contr_agreement_student(student) == 'first':
163            self.product_id = PRODUCT_ID_PT
164            self.mac = MAC_PT
165        else:
166            self.product_id = PRODUCT_ID_REGULAR
167            self.mac = MAC_REGULAR
168
169        # To guarantee that cleared students pay both acceptance fee
170        # and school fees, the page can only be accessed
171        # for school fee payments if acceptance/clearance fee has
172        # been successfully queried/paid beforehand. This
173        # requirement applies to students in state 'cleared' and
174        # entry_session greater than 2013 only.
175        if self.context.p_category.startswith('schoolfee') and \
176            student.state == CLEARED and \
177            student.entry_session > 2012:
178            acceptance_fee_paid = False
179            for ticket in student['payments'].values():
180                if ticket.p_state == 'paid' and \
181                    ticket.p_category.startswith('clearance'):
182                    acceptance_fee_paid = True
183                    break
184            if not acceptance_fee_paid:
185                self.flash(
186                    _('Please pay acceptance fee first.'), type="danger")
187                self.redirect(self.url(self.context, '@@index'))
188                return
189
190        xmldict = self.xmldict
191        xmltext = ""
192        # Provider data
193        xmldict['detail_ref'] = self.context.p_id
194        xmldict['provider_acct'] = PROVIDER_ACCT
195        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
196        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
197        xmldict['institution_item_name'] = self.category
198        xmldict['institution_name'] = INSTITUTION_NAME
199        provider_amt = 0.0
200
201        # Schoolfee
202        if self.context.p_category.startswith('schoolfee'):
203            if contr_agreement_student(student) == 'first':
204                # First agreement
205                provider_amt = 1900.0
206                joint_venture_amt = 1100.0
207                aaue_share_amt = 1000.0
208                student_union_due_amt = gateway_net_amt(
209                    academic_session.union_fee)
210                student_welfare_assurance_amt = gateway_net_amt(
211                    academic_session.welfare_fee)
212                xmldict['institution_bank_id'] = '7'
213                xmldict['institution_acct'] = '1014847058'
214                if student.current_mode == 'found':
215                    self.pay_item_id = '103'
216                else:
217                    self.pay_item_id = '105'
218            else:
219                # Second agreement
220                provider_amt = 1500.0
221                joint_venture_amt = 1000.0
222                aaue_share_amt = 1500.0
223                student_union_due_amt = gateway_net_amt(
224                    academic_session.union_fee)
225                student_welfare_assurance_amt = gateway_net_amt(
226                    academic_session.welfare_fee)
227                xmldict['institution_bank_id'] = '117'
228                xmldict['institution_acct'] = '1010827641'
229                self.pay_item_id = '107'
230                if student.is_postgrad:
231                    xmldict['institution_bank_id'] = '51'
232                    xmldict['institution_acct'] = '5210006575'
233                    self.pay_item_id = '111'
234
235            xmldict['provider_amt'] = 100 * provider_amt
236            xmldict['joint_venture_amt'] = 100 * joint_venture_amt
237            xmldict['aaue_share_amt'] = 100 * aaue_share_amt
238            if self.context.p_category in ('schoolfee_incl', 'schoolfee_1'):
239                # Schoolfee including additional fees
240                xmldict['student_union_due_amt'] = 100 * student_union_due_amt
241                xmldict['student_welfare_assurance_amt'] = 100 * student_welfare_assurance_amt
242                xmldict['institution_amt'] = 100 * (
243                    gateway_net_amt(self.context.amount_auth)
244                    - provider_amt
245                    - joint_venture_amt
246                    - aaue_share_amt
247                    - student_union_due_amt
248                    - student_welfare_assurance_amt)
249                xmltext = """<payment_item_detail>
250<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
251<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
252<item_detail item_id="2" item_name="%(provider_item_name)s" item_amt="%(provider_amt)d" bank_id="%(provider_bank_id)s" acct_num="%(provider_acct)s" />
253<item_detail item_id="3" item_name="Joint Venture" item_amt="%(joint_venture_amt)d" bank_id="51" acct_num="5060023759" />
254<item_detail item_id="4" item_name="AAUE Share" item_amt="%(aaue_share_amt)d" bank_id="51" acct_num="5060020947" />
255<item_detail item_id="5" item_name="Student Union" item_amt="%(student_union_due_amt)d" bank_id="123" acct_num="1006360118" />
256<item_detail item_id="6" item_name="Student Welfare Assurance" item_amt="%(student_welfare_assurance_amt)d" bank_id="31" acct_num="1006407792" />
257</item_details>
258</payment_item_detail>""" % xmldict
259            else:
260                # Schoolfee without additional fees
261                xmldict['institution_amt'] = 100 * (
262                    gateway_net_amt(self.context.amount_auth)
263                    - provider_amt
264                    - joint_venture_amt
265                    - aaue_share_amt)
266                xmltext = """<payment_item_detail>
267<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
268<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
269<item_detail item_id="2" item_name="%(provider_item_name)s" item_amt="%(provider_amt)d" bank_id="%(provider_bank_id)s" acct_num="%(provider_acct)s" />
270<item_detail item_id="3" item_name="Joint Venture" item_amt="%(joint_venture_amt)d" bank_id="51" acct_num="5060023759" />
271<item_detail item_id="4" item_name="AAUE Share" item_amt="%(aaue_share_amt)d" bank_id="51" acct_num="5060020947" />
272</item_details>
273</payment_item_detail>""" % xmldict
274
275
276        # Clearance
277        elif self.context.p_category.startswith('clearance'):
278            if contr_agreement_student(student) == 'first':
279                # First agreement
280                if student.current_mode == 'found':
281                    self.pay_item_id = '102'
282                else:
283                    self.pay_item_id = '104'
284                xmldict['institution_acct'] = '1014066976'
285                xmldict['institution_bank_id'] = '117'
286            else:
287                # Second agreement
288                self.pay_item_id = '102'
289                xmldict['institution_acct'] = '1010827641'
290                xmldict['institution_bank_id'] = '117'
291                if student.is_postgrad:
292                    xmldict['institution_bank_id'] = '51'
293                    xmldict['institution_acct'] = '5210006575'
294                    self.pay_item_id = '110'
295
296            if self.context.p_category.endswith('_incl'):
297                # Clearance including additional fees
298                gown_fee_amt = gateway_net_amt(academic_session.matric_gown_fee)
299                aaue_lf_fee_amt = gateway_net_amt(academic_session.lapel_fee)
300                xmldict['gown_fee_amt'] = 100 * gown_fee_amt
301                xmldict['aaue_lf_fee_amt'] = 100 * aaue_lf_fee_amt
302                xmldict['institution_amt'] = 100 * (
303                    gateway_net_amt(self.context.amount_auth)
304                    - gown_fee_amt
305                    - aaue_lf_fee_amt)
306                xmltext = """<payment_item_detail>
307<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
308<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
309<item_detail item_id="2" item_name="Matriculation Gown Fee" item_amt="%(gown_fee_amt)d" bank_id="51" acct_num="5060020947" />
310<item_detail item_id="3" item_name="AAU File-Lapel Fee" item_amt="%(aaue_lf_fee_amt)d" bank_id="51" acct_num="4010660109" />
311</item_details>
312</payment_item_detail>""" % xmldict
313
314            else:
315                # Clearance without additional fees
316                xmldict['institution_amt'] = 100 * (
317                    gateway_net_amt(self.context.amount_auth))
318                xmltext = """<payment_item_detail>
319<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
320<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
321</item_details>
322</payment_item_detail>""" % xmldict
323
324        # Union Dues
325        elif self.context.p_category == 'union':
326            self.pay_item_id = '103'
327            xmldict['institution_acct'] = '1006360118'
328            xmldict['institution_bank_id'] = '123'
329            xmldict['institution_amt'] = 100 * (
330                gateway_net_amt(self.context.amount_auth))
331            xmltext = """<payment_item_detail>
332<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
333<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
334</item_details>
335</payment_item_detail>""" % xmldict
336
337        # Lapel/File
338        elif self.context.p_category == 'lapel':
339            self.pay_item_id = '104'
340            xmldict['institution_acct'] = '4010660109'
341            xmldict['institution_bank_id'] = '51'
342            xmldict['institution_amt'] = 100 * (
343                gateway_net_amt(self.context.amount_auth))
344            xmltext = """<payment_item_detail>
345<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
346<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
347</item_details>
348</payment_item_detail>""" % xmldict
349
350        # Welfare Assurance
351        elif self.context.p_category == 'welfare':
352            self.pay_item_id = '105'
353            xmldict['institution_acct'] = '1006407792'
354            xmldict['institution_bank_id'] = '123'
355            xmldict['institution_amt'] = 100 * (
356                gateway_net_amt(self.context.amount_auth))
357            xmltext = """<payment_item_detail>
358<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
359<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
360</item_details>
361</payment_item_detail>""" % xmldict
362
363        # Matric Gown
364        elif self.context.p_category == 'matric_gown':
365            self.pay_item_id = '106'
366            xmldict['institution_acct'] = '5060023429'
367            xmldict['institution_bank_id'] = '51'
368            xmldict['institution_amt'] = 100 * (
369                gateway_net_amt(self.context.amount_auth))
370            xmltext = """<payment_item_detail>
371<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
372<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
373</item_details>
374</payment_item_detail>""" % xmldict
375
376        # Concessional
377        elif self.context.p_category == 'concessional':
378            self.pay_item_id = '107'
379            xmldict['institution_acct'] = '1010835352'
380            xmldict['institution_bank_id'] = '117'
381            xmldict['institution_amt'] = 100 * (
382                gateway_net_amt(self.context.amount_auth))
383            xmltext = """<payment_item_detail>
384<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
385<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
386</item_details>
387</payment_item_detail>""" % xmldict
388
389        # Hostel Maintenance
390        elif self.context.p_category == 'hostel_maintenance':
391            self.pay_item_id = '109'
392            xmldict['institution_acct'] = '1006406795'
393            xmldict['institution_bank_id'] = '123'
394            xmldict['institution_amt'] = 100 * (
395                gateway_net_amt(self.context.amount_auth))
396            xmltext = """<payment_item_detail>
397<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
398<item_detail item_id="1" item_name="%(institution_item_name)s" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
399</item_details>
400</payment_item_detail>""" % xmldict
401
402        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
403        self.context.provider_amt = provider_amt
404        self.context.gateway_amt = self.amount_auth - gateway_net_amt(
405            self.amount_auth)
406        hashargs = (
407            self.context.p_id +
408            self.product_id +
409            self.pay_item_id +
410            str(int(self.amount_auth)) +
411            self.site_redirect_url +
412            self.mac)
413        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
414        return
415
416
417class CustomInterswitchPaymentRequestWebservicePageApplicant(
418    InterswitchPaymentRequestWebservicePageApplicant):
419    """Request webservice view for the CollegePAY gateway
420    """
421    grok.context(ICustomApplicantOnlinePayment)
422    gateway_host = HOST
423    gateway_url = URL
424    https = HTTPS
425
426    @property
427    def mac(self):
428        if contr_agreement_applicant(self.context.__parent__) == 'first':
429            return MAC_PT
430        return MAC_REGULAR
431
432    @property
433    def product_id(self):
434        if contr_agreement_applicant(self.context.__parent__) == 'first':
435            return PRODUCT_ID_PT
436        return PRODUCT_ID_REGULAR
437
438class CustomInterswitchPaymentVerifyWebservicePageApplicant(
439    InterswitchPaymentVerifyWebservicePageApplicant):
440    """Payment verify view for the CollegePAY gateway
441    """
442    grok.context(ICustomApplicantOnlinePayment)
443    gateway_host = HOST
444    gateway_url = URL
445    https = HTTPS
446
447    @property
448    def mac(self):
449        if contr_agreement_applicant(self.context.__parent__) == 'first':
450            return MAC_PT
451        return MAC_REGULAR
452
453    @property
454    def product_id(self):
455        if contr_agreement_applicant(self.context.__parent__) == 'first':
456            return PRODUCT_ID_PT
457        return PRODUCT_ID_REGULAR
458
459class CustomInterswitchPaymentRequestWebservicePageStudent(
460    InterswitchPaymentRequestWebservicePageStudent):
461    """Request webservice view for the CollegePAY gateway
462    """
463    grok.context(ICustomStudentOnlinePayment)
464    gateway_host = HOST
465    gateway_url = URL
466    https = HTTPS
467
468    @property
469    def mac(self):
470        if contr_agreement_student(self.context.student) == 'first':
471            return MAC_PT
472        return MAC_REGULAR
473
474    @property
475    def product_id(self):
476        if contr_agreement_student(self.context.student) == 'first':
477            return PRODUCT_ID_PT
478        return PRODUCT_ID_REGULAR
479
480class CustomInterswitchPaymentVerifyWebservicePageStudent(
481    InterswitchPaymentVerifyWebservicePageStudent):
482    """Payment verify view for the CollegePAY gateway
483    """
484    grok.context(ICustomStudentOnlinePayment)
485    gateway_host = HOST
486    gateway_url = URL
487    https = HTTPS
488
489    @property
490    def mac(self):
491        if contr_agreement_student(self.context.student) == 'first':
492            return MAC_PT
493        return MAC_REGULAR
494
495    @property
496    def product_id(self):
497        if contr_agreement_student(self.context.student) == 'first':
498            return PRODUCT_ID_PT
499        return PRODUCT_ID_REGULAR
Note: See TracBrowser for help on using the repository browser.