source: main/kofacustom.dspg/trunk/src/kofacustom/dspg/interswitch/browser.py @ 15077

Last change on this file since 15077 was 15076, checked in by Henrik Bettermann, 7 years ago

Change bank account for pt application.
  • Property svn:keywords set to Id
File size: 20.5 KB
Line 
1## $Id: browser.py 15076 2018-07-03 06:02:40Z 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 kofacustom.nigeria.interswitch.browser import (
22    InterswitchPaymentRequestWebservicePageApplicant,
23    InterswitchPaymentRequestWebservicePageStudent,
24    InterswitchPaymentVerifyWebservicePageApplicant,
25    InterswitchPaymentVerifyWebservicePageStudent,
26    InterswitchPageStudent, InterswitchPageApplicant,
27    )
28from kofacustom.dspg.students.interfaces import ICustomStudentOnlinePayment
29from kofacustom.dspg.applicants.interfaces import ICustomApplicantOnlinePayment
30from kofacustom.dspg.interfaces import MessageFactory as _
31
32PRODUCT_ID = '7269' # must be provided by Interswitch
33SITE_NAME = 'dspg.waeup.org'
34PROVIDER_ACCT = '2028964403'
35PROVIDER_BANK_ID = '8'
36PROVIDER_ITEM_NAME = 'BT Education'
37INSTITUTION_NAME = 'Delta State Polytechnic Ogwashi-Uku'
38CURRENCY = '566'
39GATEWAY_AMT = 250.0
40MAC = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
41
42POST_ACTION = 'https://webpay.interswitchng.com/paydirect/pay'
43#POST_ACTION = 'https://sandbox.interswitchng.com/webpay/pay'
44HOST = 'webpay.interswitchng.com'
45#HOST = 'sandbox.interswitchng.com'
46URL = '/paydirect/api/v1/gettransaction.json'
47#URL = '/webpay/api/v1/gettransaction.json'
48
49httplib.HTTPSConnection.debuglevel = 0
50HTTPS = True
51
52SPECIAL_PAYMENT_PARAMS = {
53
54    'carryover1': ('101', 500.0, '1012808851', '117'),
55    'carryover5': ('101', 500.0, '1012808851', '117'),
56    'carryover6': ('101', 500.0, '1012808851', '117'),
57    'carryover7': ('101', 500.0, '1012808851', '117'),
58    'carryover8': ('101', 500.0, '1012808851', '117'),
59    'carryover9': ('101', 500.0, '1012808851', '117'),
60    'carryover10': ('101', 500.0, '1012808851', '117'),
61    'carryover11': ('101', 500.0, '1012808851', '117'),
62    'carryover12': ('101', 500.0, '1012808851', '117'),
63    'balance': ('101', 500.0, '1012808851', '117'),
64
65    'certificate': ('111', 500.0, '1012808851', '117'),
66    'state_result': ('112', 500.0, '1012808851', '117'),
67    'transcript_local': ('113', 500.0, '1012808851', '117'),
68    'transcript_foreign': ('114', 500.0, '1012808851', '117'),
69    'ver_result': ('115', 500.0, '1012808851', '117'),
70    'change_course': ('116', 500.0, '1012808851', '117'),
71    'change_inst': ('117', 500.0, '1012808851', '117'),
72    'jamb_reject': ('118', 500.0, '1012808851', '117'),
73    'cert_of_cert': ('119', 500.0, '1012808851', '117'),
74    'ref_let': ('120', 500.0, '1012808851', '117'),
75    'proc_cert': ('121', 500.0, '1012808851', '117'),
76    'loss_idcard': ('122', 9.0, '1012808851', '117'),
77    'loss_examcard': ('123', 4.5, '1012808851', '117'),
78    'loss_result': ('124', 500.0, '1012808851', '117'),
79    'loss_receipt': ('125', 500.0, '1012808851', '117'),
80    'loss_clearance': ('126', 500.0, '1012808851', '117'),
81    'conv_brochure': ('127', 500.0, '1012808851', '117'),
82    'hnd_certificate': ('128', 500.0, '1012808851', '117'),
83    'hnd_state_result': ('129', 500.0, '1012808851', '117'),
84    'hnd_transcript_local': ('130', 500.0, '1012808851', '117'),
85    'hnd_transcript_foreign': ('131', 500.0, '1012808851', '117'),
86    'staff_loss_idcard': ('132', 9.0, '1012808851', '117'),
87    'hnd_conv_brochure': ('133', 500.0, '1012808851', '117'),
88    'pgd_state_result': ('134', 500.0, '1012808851', '117'),
89    'pgd_conv_brochure': ('135', 500.0, '1012808851', '117'),
90    'pgd_certificate': ('136', 500.0, '1012808851', '117'),
91    'log_book': ('137', 4.5, '1012808851', '117'),
92    'pgd_transcript_foreign': ('138', 500.0, '1012808851', '117'),
93    'pgd_transcript_local': ('139', 500.0, '1012808851', '117'),
94    'jamb_regularization': ('140', 500.0, '1012808851', '117'),
95    'utme_registration': ('142', 9.0, '1012808851', '117'),
96    'utme_cbt': ('143', 9.0, '1012808851', '117'),
97    'nysc_id_card': ('144', 9.0, '1012808851', '117'),
98    'ijmb_result': ('147', 500.0, '1012808851', '117'),
99    }
100
101
102# Not yet readily configured. Bank account numbers are
103# contradictory. pay_item_ids are not yet assigned.
104
105class CustomInterswitchPageStudent(InterswitchPageStudent):
106    """ View which sends a POST request to the Interswitch
107    CollegePAY payment gateway.
108    """
109    grok.context(ICustomStudentOnlinePayment)
110    action = POST_ACTION
111    site_name = SITE_NAME
112    currency = CURRENCY
113    product_id = PRODUCT_ID
114    mac = MAC
115    pay_item_id = '000'
116
117    def update(self):
118        error = self.init_update()
119        if error:
120            self.flash(error, type='danger')
121            self.redirect(self.url(self.context, '@@index'))
122            return
123        student = self.student
124        xmldict = self.xmldict
125        # Provider data
126        xmldict['detail_ref'] = self.context.p_id
127        xmldict['provider_acct'] = PROVIDER_ACCT
128        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
129        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
130        # Institution data
131        xmldict['institution_acct'] = '00000000'
132        xmldict['institution_bank_id'] = '00'
133        xmldict['institution_amt'] = '0.0'
134        provider_amt = 0.0
135        tech_fee = 0.0
136        if self.context.p_category.startswith('schoolfee'):
137            self.pay_item_id = '102'
138            provider_amt = 2800.0
139            tech_fee = 1200.0
140            if student.faccode == 'SPAT':
141                xmldict['institution_acct'] = '1012808851'
142                xmldict['institution_bank_id'] = '117'
143            elif student.current_mode in ('nd_ft', 'hnd_ft'):
144                xmldict['institution_acct'] = '0010761873'
145                xmldict['institution_bank_id'] = '11'
146        elif self.context.p_category == 'clearance':
147            self.pay_item_id = '103'
148            provider_amt = 500.0
149            if student.faccode == 'SPAT':
150                xmldict['institution_acct'] = '1012808851'
151                xmldict['institution_bank_id'] = '117'
152            elif student.current_mode == 'nd_ft':
153                xmldict['institution_acct'] = '2004402644'
154                xmldict['institution_bank_id'] = '8'
155        elif self.context.p_category == 'gown':
156            self.pay_item_id = '102' # We use school fee item id.
157            xmldict['institution_acct'] = '2006612782'
158            xmldict['institution_bank_id'] = '8'
159        elif self.context.p_category == 'sports':
160            self.pay_item_id = '110'
161            xmldict['institution_acct'] = '6060300688'
162            xmldict['institution_bank_id'] = '51'
163        elif self.context.p_category == 'siwes':
164            self.pay_item_id = '111'
165            xmldict['institution_acct'] = '1001174679'
166            xmldict['institution_bank_id'] = '123'
167        elif self.context.p_category == 'eed_1':
168            self.pay_item_id = '112'
169            xmldict['institution_acct'] = '0039782431'
170            xmldict['institution_bank_id'] = '11'
171        elif self.context.p_category == 'eed_2':
172            self.pay_item_id = '116'
173            xmldict['institution_acct'] = '0039782431'
174            xmldict['institution_bank_id'] = '11'
175        elif self.context.p_category == 'olevel_results_1':
176            self.pay_item_id = '113'
177            xmldict['institution_acct'] = '2015327204'
178            xmldict['institution_bank_id'] = '8'
179        elif self.context.p_category == 'olevel_results_2':
180            self.pay_item_id = '115'
181            xmldict['institution_acct'] = '2015327204'
182            xmldict['institution_bank_id'] = '8'
183        elif self.context.p_category in SPECIAL_PAYMENT_PARAMS.keys():
184            self.pay_item_id = SPECIAL_PAYMENT_PARAMS[self.context.p_category][0]
185            provider_amt = SPECIAL_PAYMENT_PARAMS[self.context.p_category][1]
186            xmldict['institution_acct'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][2]
187            xmldict['institution_bank_id'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][3]
188        xmldict['provider_amt'] = 100 * provider_amt
189        xmldict['tech_fee'] = 100 * tech_fee
190        xmldict['institution_item_name'] = self.context.category
191        xmldict['institution_name'] = INSTITUTION_NAME
192        xmldict['institution_amt'] = institution_amt = 100 * (
193            self.context.amount_auth - provider_amt - tech_fee - GATEWAY_AMT)
194
195        if provider_amt == 0:
196            xmltext = """<payment_item_detail>
197<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
198<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" />
199</item_details>
200</payment_item_detail>""" % xmldict
201        elif tech_fee == 0:
202            xmltext = """<payment_item_detail>
203<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
204<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" />
205<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" />
206</item_details>
207</payment_item_detail>""" % xmldict
208        else:
209            xmltext = """<payment_item_detail>
210<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
211<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" />
212<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" />
213<item_detail item_id="3" item_name="Technology Fee" item_amt="%(tech_fee)d" bank_id="307" acct_num="5100189030" />
214</item_details>
215</payment_item_detail>""" % xmldict
216
217        # isouaba: All certificates in SPAT are part time thus any payments
218        # coming from those certificates (Application, Acceptance, school fees
219        # etc) 40% should be split to keystone account.
220        if student.faccode == 'SPAT':
221            xmldict['institution_amt_2'] = 0.4 * institution_amt
222            xmldict['institution_amt_1'] = 0.6 * institution_amt
223            if provider_amt == 0:
224                xmltext = """<payment_item_detail>
225<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
226<item_detail item_id="1" item_name="%(institution_item_name)s 1" item_amt="%(institution_amt_1)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
227<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
228</item_details>
229</payment_item_detail>""" % xmldict
230            elif tech_fee == 0:
231                xmltext = """<payment_item_detail>
232<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
233<item_detail item_id="1" item_name="%(institution_item_name)s 1" item_amt="%(institution_amt_1)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
234<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
235<item_detail item_id="3" item_name="%(provider_item_name)s" item_amt="%(provider_amt)d" bank_id="%(provider_bank_id)s" acct_num="%(provider_acct)s" />
236</item_details>
237</payment_item_detail>""" % xmldict
238            else:
239                xmltext = """<payment_item_detail>
240<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
241<item_detail item_id="1" item_name="%(institution_item_name)s 1" item_amt="%(institution_amt_1)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
242<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
243<item_detail item_id="3" item_name="%(provider_item_name)s" item_amt="%(provider_amt)d" bank_id="%(provider_bank_id)s" acct_num="%(provider_acct)s" />
244<item_detail item_id="4" item_name="Technology Fee" item_amt="%(tech_fee)d" bank_id="307" acct_num="5100189030" />
245</item_details>
246</payment_item_detail>""" % xmldict
247        # dep_sug payments are treated completely separately. The following lines
248        # override the configuration above.
249        if self.context.p_category == 'dep_sug':
250            self.pay_item_id = '102' # We use school fee item id
251            # amount_auth is being ignored. However, the sum of all split payments
252            # must coincide with the amount_auth configured in students/utils.py
253            xmldict['amt1'] = 100 * 1000
254            xmldict['amt2'] = 100 * 500
255            xmldict['amt3'] = 100 * 900
256            xmldict['amt4'] = 100 * 500
257
258            xmltext = """<payment_item_detail>
259<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
260<item_detail item_id="1" item_name="SUG" item_amt="%(amt1)d" bank_id="11" acct_num="0038079930" />
261<item_detail item_id="2" item_name="Students Welfare" item_amt="%(amt2)d" bank_id="11" acct_num="0037892949" />
262<item_detail item_id="3" item_name="Anti-Cult Book" item_amt="%(amt3)d" bank_id="11" acct_num="0037892949" />
263<item_detail item_id="4" item_name="NADESSTU" item_amt="%(amt4)d" bank_id="11" acct_num="0036375968" />
264</item_details>
265</payment_item_detail>""" % xmldict
266
267#            if student.faccode == 'SPAT':
268#                xmltext = """<payment_item_detail>
269#<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
270#<item_detail item_id="1" item_name="Students Welfare" item_amt="%(amt2)d" bank_id="11" acct_num="0037892949" />
271#<item_detail item_id="2" item_name="Anti-Cult Book" item_amt="%(amt3)d" bank_id="11" acct_num="0037892949" />
272#</item_details>
273#</payment_item_detail>""" % xmldict
274
275        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
276        self.context.provider_amt = provider_amt
277        self.context.gateway_amt = GATEWAY_AMT
278        hashargs = (
279            self.context.p_id +
280            PRODUCT_ID +
281            self.pay_item_id +
282            str(int(self.amount_auth)) +
283            self.site_redirect_url +
284            self.mac)
285        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
286        return
287
288class CustomInterswitchPageApplicant(InterswitchPageApplicant):
289    """ View which sends a POST request to the Interswitch
290    CollegePAY payment gateway.
291    """
292    grok.context(ICustomApplicantOnlinePayment)
293    action = POST_ACTION
294    site_name = SITE_NAME
295    currency = CURRENCY
296    pay_item_id = '101' # must be provided by Interswitch
297    product_id = PRODUCT_ID
298    mac = MAC
299
300    def update(self):
301        error = self.init_update()
302        if error:
303            self.flash(error, type='danger')
304            self.redirect(self.url(self.context, '@@index'))
305            return
306        xmldict = {}
307        provider_amt = 500.0
308        gateway_amt = GATEWAY_AMT
309        xmldict['institution_acct'] = '00000000'
310        xmldict['institution_bank_id'] = '00'
311        if self.applicant.__parent__.application_category in ('ndft', 'hndft'):
312            xmldict['institution_acct'] = '0010761873'
313            xmldict['institution_bank_id'] = '11'
314        elif self.applicant.__parent__.application_category in (
315            'ndpt', 'hndpt', 'ndwe', 'hndwe'):
316            xmldict['institution_acct'] = '5210039869'
317            xmldict['institution_bank_id'] = '51'
318        elif self.applicant.applicant_id.startswith('special'):
319            if self.context.p_category in SPECIAL_PAYMENT_PARAMS.keys():
320                self.pay_item_id = SPECIAL_PAYMENT_PARAMS[self.context.p_category][0]
321                provider_amt = SPECIAL_PAYMENT_PARAMS[self.context.p_category][1]
322                xmldict['institution_acct'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][2]
323                xmldict['institution_bank_id'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][3]
324        if self.pay_item_id in ('122', '123', '132', '137', '141',
325                                '142', '143', '144', '146', '147',):
326                gateway_amt = round(0.015 * self.context.amount_auth, 2)
327        xmldict['detail_ref'] = self.context.p_id
328        xmldict['provider_amt'] = 100 * provider_amt
329        xmldict['provider_acct'] = PROVIDER_ACCT
330        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
331        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
332        xmldict['institution_amt'] = institution_amt = 100 * (
333            self.context.amount_auth - provider_amt - gateway_amt)
334        xmldict['institution_item_name'] = self.context.category
335        xmldict['institution_name'] = INSTITUTION_NAME
336        xmltext = """<payment_item_detail>
337<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
338<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" />
339<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" />
340</item_details>
341</payment_item_detail>""" % xmldict
342
343        # isouaba: All certificates in SPAT are part time thus any payments
344        # coming from those certificates (Application, Acceptance, school fees
345        # etc) 40% should be split to keystone account.
346        if self.applicant.__parent__.application_category in (
347            'ndpt', 'hndpt', 'ndwe', 'hndwe'):
348            xmldict['institution_amt_2'] = 0.4 * institution_amt
349            xmldict['institution_amt_1'] = 0.6 * institution_amt
350            xmltext = """<payment_item_detail>
351<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
352<item_detail item_id="1" item_name="%(institution_item_name)s 1" item_amt="%(institution_amt_1)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
353<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
354<item_detail item_id="3" item_name="%(provider_item_name)s" item_amt="%(provider_amt)d" bank_id="%(provider_bank_id)s" acct_num="%(provider_acct)s" />
355</item_details>
356</payment_item_detail>""" % xmldict
357
358        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
359        self.context.provider_amt = provider_amt
360        self.context.gateway_amt = GATEWAY_AMT
361
362        hashargs = (
363            self.context.p_id +
364            PRODUCT_ID +
365            self.pay_item_id +
366            str(int(self.amount_auth)) +
367            self.site_redirect_url +
368            self.mac)
369        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
370        return
371
372class CustomInterswitchPaymentRequestWebservicePageStudent(
373    InterswitchPaymentRequestWebservicePageStudent):
374    """Request webservice view for the CollegePAY gateway
375    """
376    grok.context(ICustomStudentOnlinePayment)
377    product_id = PRODUCT_ID
378    gateway_host = HOST
379    gateway_url = URL
380    mac = MAC
381
382class CustomInterswitchPaymentVerifyWebservicePageStudent(
383    InterswitchPaymentVerifyWebservicePageStudent):
384    """Payment verify view for the CollegePAY gateway
385    """
386    grok.context(ICustomStudentOnlinePayment)
387    product_id = PRODUCT_ID
388    gateway_host = HOST
389    gateway_url = URL
390    mac = MAC
391
392class CustomInterswitchPaymentRequestWebservicePageApplicant(
393    InterswitchPaymentRequestWebservicePageApplicant):
394    """Request webservice view for the CollegePAY gateway
395    """
396    grok.context(ICustomApplicantOnlinePayment)
397    product_id = PRODUCT_ID
398    gateway_host = HOST
399    gateway_url = URL
400    mac = MAC
401
402class CustomInterswitchPaymentVerifyWebservicePageApplicant(
403    InterswitchPaymentVerifyWebservicePageApplicant):
404    """Payment verify view for the CollegePAY gateway
405    """
406    grok.context(ICustomApplicantOnlinePayment)
407    product_id = PRODUCT_ID
408    gateway_host = HOST
409    gateway_url = URL
410    mac = MAC
Note: See TracBrowser for help on using the repository browser.