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

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

All certificates in SPAT are part time thus any payments coming from those certificates (Application, Acceptance, school fees etc) 40% should be split to keystone account.
  • Property svn:keywords set to Id
File size: 16.5 KB
RevLine 
[10765]1## $Id: browser.py 14889 2017-11-06 08:11:13Z 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
[12479]19import hashlib
[10765]20import grok
21from kofacustom.nigeria.interswitch.browser import (
22    InterswitchPaymentRequestWebservicePageApplicant,
[11638]23    InterswitchPaymentRequestWebservicePageStudent,
[13587]24    InterswitchPaymentVerifyWebservicePageApplicant,
25    InterswitchPaymentVerifyWebservicePageStudent,
[11638]26    InterswitchPageStudent, InterswitchPageApplicant,
[10765]27    )
[14716]28from kofacustom.dspg.students.interfaces import ICustomStudentOnlinePayment
29from kofacustom.dspg.applicants.interfaces import ICustomApplicantOnlinePayment
30from kofacustom.dspg.interfaces import MessageFactory as _
[10765]31
[14726]32PRODUCT_ID = '7269' # must be provided by Interswitch
[14749]33SITE_NAME = 'dspg.waeup.org'
[14879]34PROVIDER_ACCT = '2028964403'
35PROVIDER_BANK_ID = '8'
[10765]36PROVIDER_ITEM_NAME = 'BT Education'
[14722]37INSTITUTION_NAME = 'Delta State Polytechnic Ogwashi-Uku'
[10765]38CURRENCY = '566'
[14727]39GATEWAY_AMT = 250.0
[10765]40
[14726]41POST_ACTION = 'https://webpay.interswitchng.com/paydirect/pay'
42#POST_ACTION = 'https://sandbox.interswitchng.com/webpay/pay'
43HOST = 'webpay.interswitchng.com'
44#HOST = 'sandbox.interswitchng.com'
45URL = '/paydirect/api/v1/gettransaction.json'
46#URL = '/webpay/api/v1/gettransaction.json'
[14276]47
[12479]48httplib.HTTPSConnection.debuglevel = 0
49HTTPS = True
[10765]50
[14859]51SPECIAL_PAYMENT_PARAMS = {
[14864]52
53    'carryover1': ('101', 500.0, '1012808851', '117'),
54    'carryover5': ('101', 500.0, '1012808851', '117'),
55    'carryover6': ('101', 500.0, '1012808851', '117'),
56    'carryover7': ('101', 500.0, '1012808851', '117'),
57    'carryover8': ('101', 500.0, '1012808851', '117'),
58    'carryover9': ('101', 500.0, '1012808851', '117'),
59    'carryover10': ('101', 500.0, '1012808851', '117'),
[14868]60    'carryover11': ('101', 500.0, '1012808851', '117'),
61    'carryover12': ('101', 500.0, '1012808851', '117'),
[14869]62    'balance': ('101', 500.0, '1012808851', '117'),
[14864]63
[14859]64    'certificate': ('111', 500.0, '1012808851', '117'),
65    'state_result': ('112', 500.0, '1012808851', '117'),
66    'transcript_local': ('113', 500.0, '1012808851', '117'),
67    'transcript_foreign': ('114', 500.0, '1012808851', '117'),
68    'ver_result': ('115', 500.0, '1012808851', '117'),
69    'change_course': ('116', 500.0, '1012808851', '117'),
70    'change_inst': ('117', 500.0, '1012808851', '117'),
71    'jamb_reject': ('118', 500.0, '1012808851', '117'),
72    'cert_of_cert': ('119', 500.0, '1012808851', '117'),
73    'ref_let': ('120', 500.0, '1012808851', '117'),
74    'proc_cert': ('121', 500.0, '1012808851', '117'),
75    'loss_idcard': ('122', 9.0, '1012808851', '117'),
76    'loss_examcard': ('123', 4.5, '1012808851', '117'),
77    'loss_result': ('124', 500.0, '1012808851', '117'),
78    'loss_receipt': ('125', 500.0, '1012808851', '117'),
79    'loss_clearance': ('126', 500.0, '1012808851', '117'),
80    'conv_brochure': ('127', 500.0, '1012808851', '117'),
81    'hnd_certificate': ('128', 500.0, '1012808851', '117'),
82    'hnd_state_result': ('129', 500.0, '1012808851', '117'),
83    'hnd_transcript_local': ('130', 500.0, '1012808851', '117'),
84    'hnd_transcript_foreign': ('131', 500.0, '1012808851', '117'),
85    'staff_loss_idcard': ('132', 9.0, '1012808851', '117'),
86    'hnd_conv_brochure': ('133', 500.0, '1012808851', '117'),
87    'pgd_state_result': ('134', 500.0, '1012808851', '117'),
88    'pgd_conv_brochure': ('135', 500.0, '1012808851', '117'),
89    'pgd_certificate': ('136', 500.0, '1012808851', '117'),
90    'log_book': ('137', 4.5, '1012808851', '117'),
91    'pgd_transcript_foreign': ('138', 500.0, '1012808851', '117'),
92    'pgd_transcript_local': ('139', 500.0, '1012808851', '117'),
93    'jamb_regularization': ('140', 500.0, '1012808851', '117'),
94    'utme_registration': ('142', 9.0, '1012808851', '117'),
95    'utme_cbt': ('143', 9.0, '1012808851', '117'),
96    'nysc_id_card': ('144', 9.0, '1012808851', '117'),
97    'ijmb_result': ('147', 500.0, '1012808851', '117'),
98    }
99
[14862]100
[14875]101# Not yet readily configured. Bank account numbers are
[14862]102# contradictory. pay_item_ids are not yet assigned.
103
[11638]104class CustomInterswitchPageStudent(InterswitchPageStudent):
[10765]105    """ View which sends a POST request to the Interswitch
106    CollegePAY payment gateway.
107    """
108    grok.context(ICustomStudentOnlinePayment)
109    action = POST_ACTION
110    site_name = SITE_NAME
111    currency = CURRENCY
112    product_id = PRODUCT_ID
[14875]113    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
114    pay_item_id = '000'
[10765]115
116    def update(self):
[12979]117        error = self.init_update()
118        if error:
119            self.flash(error, type='danger')
120            self.redirect(self.url(self.context, '@@index'))
121            return
[11647]122        student = self.student
123        xmldict = self.xmldict
[10765]124        # Provider data
125        xmldict['detail_ref'] = self.context.p_id
126        xmldict['provider_acct'] = PROVIDER_ACCT
127        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
128        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
129        # Institution data
[14875]130        xmldict['institution_acct'] = '00000000'
131        xmldict['institution_bank_id'] = '00'
[10765]132        xmldict['institution_amt'] = '0.0'
[14875]133        provider_amt = 0.0
[14862]134        if self.context.p_category.startswith('schoolfee'):
135            self.pay_item_id = '102'
[14875]136            provider_amt = 2800.0
[14889]137            if student.faccode == 'SPAT':
138                xmldict['institution_acct'] = '1012808851'
[14875]139                xmldict['institution_bank_id'] = '117'
[14889]140            elif student.current_mode in ('nd_ft', 'hnd_ft'):
[14875]141                xmldict['institution_acct'] = '0026235493'
142                xmldict['institution_bank_id'] = '31'
[14862]143        elif self.context.p_category == 'clearance':
144            self.pay_item_id = '103'
[14875]145            provider_amt = 500.0
[14889]146            if student.faccode == 'SPAT':
147                xmldict['institution_acct'] = '1012808851'
[14875]148                xmldict['institution_bank_id'] = '117'
[14889]149            elif student.current_mode == 'nd_ft':
[14875]150                xmldict['institution_acct'] = '2004402644'
151                xmldict['institution_bank_id'] = '8'
[14862]152        elif self.context.p_category in SPECIAL_PAYMENT_PARAMS.keys():
153            self.pay_item_id = SPECIAL_PAYMENT_PARAMS[self.context.p_category][0]
154            provider_amt = SPECIAL_PAYMENT_PARAMS[self.context.p_category][1]
155            xmldict['institution_acct'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][2]
156            xmldict['institution_bank_id'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][3]
[10765]157        xmldict['provider_amt'] = 100 * provider_amt
[12511]158        xmldict['institution_item_name'] = self.context.category
[10765]159        xmldict['institution_name'] = INSTITUTION_NAME
[14889]160        xmldict['institution_amt'] = institution_amt = 100 * (
[10765]161            self.context.amount_auth - provider_amt - GATEWAY_AMT)
162        if provider_amt == 0:
163            xmltext = """<payment_item_detail>
164<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
165<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" />
166</item_details>
167</payment_item_detail>""" % xmldict
168        else:
169            xmltext = """<payment_item_detail>
170<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
171<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" />
172<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" />
173</item_details>
174</payment_item_detail>""" % xmldict
[14889]175
176        # isouaba: All certificates in SPAT are part time thus any payments
177        # coming from those certificates (Application, Acceptance, school fees
178        # etc) 40% should be split to keystone account.
179        if student.faccode == 'SPAT':
180            xmldict['institution_amt_2'] = 0.4 * institution_amt
181            xmldict['institution_amt_1'] = 0.6 * institution_amt
182            if provider_amt == 0:
183                xmltext = """<payment_item_detail>
184<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
185<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" />
186<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
187</item_details>
188</payment_item_detail>""" % xmldict
189            else:
190                xmltext = """<payment_item_detail>
191<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
192<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" />
193<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
194<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" />
195</item_details>
196</payment_item_detail>""" % xmldict
197
[10765]198        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
199        self.context.provider_amt = provider_amt
200        self.context.gateway_amt = GATEWAY_AMT
[12479]201
202        hashargs = (
203            self.context.p_id +
204            PRODUCT_ID +
205            self.pay_item_id +
206            str(int(self.amount_auth)) +
207            self.site_redirect_url +
208            self.mac)
209        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
[10765]210        return
211
[11638]212class CustomInterswitchPageApplicant(InterswitchPageApplicant):
[10765]213    """ View which sends a POST request to the Interswitch
214    CollegePAY payment gateway.
215    """
216    grok.context(ICustomApplicantOnlinePayment)
217    action = POST_ACTION
218    site_name = SITE_NAME
219    currency = CURRENCY
[14729]220    pay_item_id = '101' # must be provided by Interswitch
[10765]221    product_id = PRODUCT_ID
[14730]222    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
[10765]223
224    def update(self):
[12979]225        error = self.init_update()
226        if error:
227            self.flash(error, type='danger')
228            self.redirect(self.url(self.context, '@@index'))
229            return
[10765]230        xmldict = {}
[14731]231        provider_amt = 500.0
[14859]232        gateway_amt = GATEWAY_AMT
[14810]233        xmldict['institution_acct'] = '00000000'
234        xmldict['institution_bank_id'] = '00'
235        if self.applicant.__parent__.application_category in ('ndft', 'hndft'):
236            xmldict['institution_acct'] = '0010761873'
[14815]237            xmldict['institution_bank_id'] = '11'
[14810]238        elif self.applicant.__parent__.application_category in (
239            'ndpt', 'hndpt', 'ndwe', 'hndwe'):
240            xmldict['institution_acct'] = '1015220292'
241            xmldict['institution_bank_id'] = '117'
[14859]242        elif self.applicant.applicant_id.startswith('special'):
243            if self.context.p_category in SPECIAL_PAYMENT_PARAMS.keys():
244                self.pay_item_id = SPECIAL_PAYMENT_PARAMS[self.context.p_category][0]
245                provider_amt = SPECIAL_PAYMENT_PARAMS[self.context.p_category][1]
246                xmldict['institution_acct'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][2]
247                xmldict['institution_bank_id'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][3]
248        if self.pay_item_id in ('122', '123', '132', '137', '141',
249                                '142', '143', '144', '146', '147',):
250                gateway_amt = round(0.015 * self.context.amount_auth, 2)
[10765]251        xmldict['detail_ref'] = self.context.p_id
252        xmldict['provider_amt'] = 100 * provider_amt
253        xmldict['provider_acct'] = PROVIDER_ACCT
254        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
255        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
[14889]256        xmldict['institution_amt'] = institution_amt = 100 * (
257            self.context.amount_auth - provider_amt - gateway_amt)
[12511]258        xmldict['institution_item_name'] = self.context.category
[10765]259        xmldict['institution_name'] = INSTITUTION_NAME
260        xmltext = """<payment_item_detail>
261<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
262<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" />
263<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" />
264</item_details>
265</payment_item_detail>""" % xmldict
[14889]266
267        # isouaba: All certificates in SPAT are part time thus any payments
268        # coming from those certificates (Application, Acceptance, school fees
269        # etc) 40% should be split to keystone account.
270        if self.applicant.__parent__.application_category in (
271            'ndpt', 'hndpt', 'ndwe', 'hndwe'):
272            xmldict['institution_amt_2'] = 0.4 * institution_amt
273            xmldict['institution_amt_1'] = 0.6 * institution_amt
274            xmltext = """<payment_item_detail>
275<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
276<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" />
277<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
278<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" />
279</item_details>
280</payment_item_detail>""" % xmldict
281
[10765]282        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
283        self.context.provider_amt = provider_amt
284        self.context.gateway_amt = GATEWAY_AMT
[12479]285
286        hashargs = (
287            self.context.p_id +
288            PRODUCT_ID +
289            self.pay_item_id +
290            str(int(self.amount_auth)) +
291            self.site_redirect_url +
292            self.mac)
293        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
[10765]294        return
295
[11638]296class CustomInterswitchPaymentRequestWebservicePageStudent(
[10765]297    InterswitchPaymentRequestWebservicePageStudent):
[13587]298    """Request webservice view for the CollegePAY gateway
[10765]299    """
300    grok.context(ICustomStudentOnlinePayment)
301    product_id = PRODUCT_ID
302    gateway_host = HOST
303    gateway_url = URL
[14875]304    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
[10765]305
[13587]306class CustomInterswitchPaymentVerifyWebservicePageStudent(
307    InterswitchPaymentVerifyWebservicePageStudent):
308    """Payment verify view for the CollegePAY gateway
309    """
310    grok.context(ICustomStudentOnlinePayment)
311    product_id = PRODUCT_ID
312    gateway_host = HOST
313    gateway_url = URL
[14875]314    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
[13587]315
[11638]316class CustomInterswitchPaymentRequestWebservicePageApplicant(
[10765]317    InterswitchPaymentRequestWebservicePageApplicant):
[13587]318    """Request webservice view for the CollegePAY gateway
[10765]319    """
320    grok.context(ICustomApplicantOnlinePayment)
321    product_id = PRODUCT_ID
322    gateway_host = HOST
[12479]323    gateway_url = URL
[14730]324    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
[13587]325
326class CustomInterswitchPaymentVerifyWebservicePageApplicant(
327    InterswitchPaymentVerifyWebservicePageApplicant):
328    """Payment verify view for the CollegePAY gateway
329    """
330    grok.context(ICustomApplicantOnlinePayment)
331    product_id = PRODUCT_ID
332    gateway_host = HOST
[14722]333    gateway_url = URL
[14730]334    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
Note: See TracBrowser for help on using the repository browser.