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

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

Add tech fee xml data to SPAT school fee payments.
  • Property svn:keywords set to Id
File size: 19.9 KB
Line 
1## $Id: browser.py 14964 2018-03-08 20:42: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
40
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'
47
48httplib.HTTPSConnection.debuglevel = 0
49HTTPS = True
50
51SPECIAL_PAYMENT_PARAMS = {
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'),
60    'carryover11': ('101', 500.0, '1012808851', '117'),
61    'carryover12': ('101', 500.0, '1012808851', '117'),
62    'balance': ('101', 500.0, '1012808851', '117'),
63
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
100
101# Not yet readily configured. Bank account numbers are
102# contradictory. pay_item_ids are not yet assigned.
103
104class CustomInterswitchPageStudent(InterswitchPageStudent):
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
113    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
114    pay_item_id = '000'
115
116    def update(self):
117        error = self.init_update()
118        if error:
119            self.flash(error, type='danger')
120            self.redirect(self.url(self.context, '@@index'))
121            return
122        student = self.student
123        xmldict = self.xmldict
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
130        xmldict['institution_acct'] = '00000000'
131        xmldict['institution_bank_id'] = '00'
132        xmldict['institution_amt'] = '0.0'
133        provider_amt = 0.0
134        tech_fee = 0.0
135        if self.context.p_category.startswith('schoolfee'):
136            self.pay_item_id = '102'
137            provider_amt = 2800.0
138            tech_fee = 1200.0
139            if student.faccode == 'SPAT':
140                xmldict['institution_acct'] = '1012808851'
141                xmldict['institution_bank_id'] = '117'
142            elif student.current_mode in ('nd_ft', 'hnd_ft'):
143                xmldict['institution_acct'] = '0010761873'
144                xmldict['institution_bank_id'] = '11'
145        elif self.context.p_category == 'clearance':
146            self.pay_item_id = '103'
147            provider_amt = 500.0
148            if student.faccode == 'SPAT':
149                xmldict['institution_acct'] = '1012808851'
150                xmldict['institution_bank_id'] = '117'
151            elif student.current_mode == 'nd_ft':
152                xmldict['institution_acct'] = '2004402644'
153                xmldict['institution_bank_id'] = '8'
154        elif self.context.p_category == 'gown':
155            self.pay_item_id = '102' # We use school fee item id.
156            xmldict['institution_acct'] = '2006612782'
157            xmldict['institution_bank_id'] = '8'
158        elif self.context.p_category in SPECIAL_PAYMENT_PARAMS.keys():
159            self.pay_item_id = SPECIAL_PAYMENT_PARAMS[self.context.p_category][0]
160            provider_amt = SPECIAL_PAYMENT_PARAMS[self.context.p_category][1]
161            xmldict['institution_acct'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][2]
162            xmldict['institution_bank_id'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][3]
163        xmldict['provider_amt'] = 100 * provider_amt
164        xmldict['tech_fee'] = 100 * tech_fee
165        xmldict['institution_item_name'] = self.context.category
166        xmldict['institution_name'] = INSTITUTION_NAME
167        xmldict['institution_amt'] = institution_amt = 100 * (
168            self.context.amount_auth - provider_amt - tech_fee - GATEWAY_AMT)
169
170        if provider_amt == 0:
171            xmltext = """<payment_item_detail>
172<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
173<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" />
174</item_details>
175</payment_item_detail>""" % xmldict
176        elif tech_fee == 0:
177            xmltext = """<payment_item_detail>
178<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
179<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" />
180<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" />
181</item_details>
182</payment_item_detail>""" % xmldict
183        else:
184            xmltext = """<payment_item_detail>
185<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
186<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" />
187<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" />
188<item_detail item_id="3" item_name="Technology Fee" item_amt="%(tech_fee)d" bank_id="307" acct_num="5100189030" />
189</item_details>
190</payment_item_detail>""" % xmldict
191
192        # isouaba: All certificates in SPAT are part time thus any payments
193        # coming from those certificates (Application, Acceptance, school fees
194        # etc) 40% should be split to keystone account.
195        if student.faccode == 'SPAT':
196            xmldict['institution_amt_2'] = 0.4 * institution_amt
197            xmldict['institution_amt_1'] = 0.6 * institution_amt
198            if provider_amt == 0:
199                xmltext = """<payment_item_detail>
200<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
201<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" />
202<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
203</item_details>
204</payment_item_detail>""" % xmldict
205            elif tech_fee == 0:
206                xmltext = """<payment_item_detail>
207<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
208<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" />
209<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
210<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" />
211</item_details>
212</payment_item_detail>""" % xmldict
213            else:
214                xmltext = """<payment_item_detail>
215<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
216<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" />
217<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
218<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" />
219<item_detail item_id="4" item_name="Technology Fee" item_amt="%(tech_fee)d" bank_id="307" acct_num="5100189030" />
220</item_details>
221</payment_item_detail>""" % xmldict
222        # dep_sug payments are treated completely separately. The following lines
223        # override the configuration above.
224        if self.context.p_category == 'dep_sug':
225            self.pay_item_id = '102' # We use school fee item id
226            # amount_auth is being ignored. However, the sum of all split payments
227            # must coincide with the amount_auth configured in students/utils.py
228            xmldict['amt1'] = 100 * 1000
229            xmldict['amt2'] = 100 * 500
230            xmldict['amt3'] = 100 * 900
231            xmldict['amt4'] = 100 * 500
232
233            xmltext = """<payment_item_detail>
234<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
235<item_detail item_id="1" item_name="SUG" item_amt="%(amt1)d" bank_id="11" acct_num="0038079930" />
236<item_detail item_id="2" item_name="Students Welfare" item_amt="%(amt2)d" bank_id="11" acct_num="0037892949" />
237<item_detail item_id="3" item_name="Anti-Cult Book" item_amt="%(amt3)d" bank_id="11" acct_num="0037892949" />
238<item_detail item_id="4" item_name="NADESSTU" item_amt="%(amt4)d" bank_id="11" acct_num="0036375968" />
239</item_details>
240</payment_item_detail>""" % xmldict
241
242#            if student.faccode == 'SPAT':
243#                xmltext = """<payment_item_detail>
244#<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
245#<item_detail item_id="1" item_name="Students Welfare" item_amt="%(amt2)d" bank_id="11" acct_num="0037892949" />
246#<item_detail item_id="2" item_name="Anti-Cult Book" item_amt="%(amt3)d" bank_id="11" acct_num="0037892949" />
247#</item_details>
248#</payment_item_detail>""" % xmldict
249
250        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
251        self.context.provider_amt = provider_amt
252        self.context.gateway_amt = GATEWAY_AMT
253        hashargs = (
254            self.context.p_id +
255            PRODUCT_ID +
256            self.pay_item_id +
257            str(int(self.amount_auth)) +
258            self.site_redirect_url +
259            self.mac)
260        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
261        return
262
263class CustomInterswitchPageApplicant(InterswitchPageApplicant):
264    """ View which sends a POST request to the Interswitch
265    CollegePAY payment gateway.
266    """
267    grok.context(ICustomApplicantOnlinePayment)
268    action = POST_ACTION
269    site_name = SITE_NAME
270    currency = CURRENCY
271    pay_item_id = '101' # must be provided by Interswitch
272    product_id = PRODUCT_ID
273    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
274
275    def update(self):
276        error = self.init_update()
277        if error:
278            self.flash(error, type='danger')
279            self.redirect(self.url(self.context, '@@index'))
280            return
281        xmldict = {}
282        provider_amt = 500.0
283        gateway_amt = GATEWAY_AMT
284        xmldict['institution_acct'] = '00000000'
285        xmldict['institution_bank_id'] = '00'
286        if self.applicant.__parent__.application_category in ('ndft', 'hndft'):
287            xmldict['institution_acct'] = '0010761873'
288            xmldict['institution_bank_id'] = '11'
289        elif self.applicant.__parent__.application_category in (
290            'ndpt', 'hndpt', 'ndwe', 'hndwe'):
291            xmldict['institution_acct'] = '1015220292'
292            xmldict['institution_bank_id'] = '117'
293        elif self.applicant.applicant_id.startswith('special'):
294            if self.context.p_category in SPECIAL_PAYMENT_PARAMS.keys():
295                self.pay_item_id = SPECIAL_PAYMENT_PARAMS[self.context.p_category][0]
296                provider_amt = SPECIAL_PAYMENT_PARAMS[self.context.p_category][1]
297                xmldict['institution_acct'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][2]
298                xmldict['institution_bank_id'] = SPECIAL_PAYMENT_PARAMS[self.context.p_category][3]
299        if self.pay_item_id in ('122', '123', '132', '137', '141',
300                                '142', '143', '144', '146', '147',):
301                gateway_amt = round(0.015 * self.context.amount_auth, 2)
302        xmldict['detail_ref'] = self.context.p_id
303        xmldict['provider_amt'] = 100 * provider_amt
304        xmldict['provider_acct'] = PROVIDER_ACCT
305        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
306        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
307        xmldict['institution_amt'] = institution_amt = 100 * (
308            self.context.amount_auth - provider_amt - gateway_amt)
309        xmldict['institution_item_name'] = self.context.category
310        xmldict['institution_name'] = INSTITUTION_NAME
311        xmltext = """<payment_item_detail>
312<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
313<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" />
314<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" />
315</item_details>
316</payment_item_detail>""" % xmldict
317
318        # isouaba: All certificates in SPAT are part time thus any payments
319        # coming from those certificates (Application, Acceptance, school fees
320        # etc) 40% should be split to keystone account.
321        if self.applicant.__parent__.application_category in (
322            'ndpt', 'hndpt', 'ndwe', 'hndwe'):
323            xmldict['institution_amt_2'] = 0.4 * institution_amt
324            xmldict['institution_amt_1'] = 0.6 * institution_amt
325            xmltext = """<payment_item_detail>
326<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
327<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" />
328<item_detail item_id="2" item_name="%(institution_item_name)s 2" item_amt="%(institution_amt_2)d" bank_id="123" acct_num="1002883141" />
329<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" />
330</item_details>
331</payment_item_detail>""" % xmldict
332
333        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
334        self.context.provider_amt = provider_amt
335        self.context.gateway_amt = GATEWAY_AMT
336
337        hashargs = (
338            self.context.p_id +
339            PRODUCT_ID +
340            self.pay_item_id +
341            str(int(self.amount_auth)) +
342            self.site_redirect_url +
343            self.mac)
344        self.hashvalue = hashlib.sha512(hashargs).hexdigest()
345        return
346
347class CustomInterswitchPaymentRequestWebservicePageStudent(
348    InterswitchPaymentRequestWebservicePageStudent):
349    """Request webservice view for the CollegePAY gateway
350    """
351    grok.context(ICustomStudentOnlinePayment)
352    product_id = PRODUCT_ID
353    gateway_host = HOST
354    gateway_url = URL
355    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
356
357class CustomInterswitchPaymentVerifyWebservicePageStudent(
358    InterswitchPaymentVerifyWebservicePageStudent):
359    """Payment verify view for the CollegePAY gateway
360    """
361    grok.context(ICustomStudentOnlinePayment)
362    product_id = PRODUCT_ID
363    gateway_host = HOST
364    gateway_url = URL
365    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
366
367class CustomInterswitchPaymentRequestWebservicePageApplicant(
368    InterswitchPaymentRequestWebservicePageApplicant):
369    """Request webservice view for the CollegePAY gateway
370    """
371    grok.context(ICustomApplicantOnlinePayment)
372    product_id = PRODUCT_ID
373    gateway_host = HOST
374    gateway_url = URL
375    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
376
377class CustomInterswitchPaymentVerifyWebservicePageApplicant(
378    InterswitchPaymentVerifyWebservicePageApplicant):
379    """Payment verify view for the CollegePAY gateway
380    """
381    grok.context(ICustomApplicantOnlinePayment)
382    product_id = PRODUCT_ID
383    gateway_host = HOST
384    gateway_url = URL
385    mac = 'D43ED93B7A307B152C7111D04E1F384428057CD1E75428D3A4C5631C28ACB9C8C822A88CA76DEDC5F9A520CF4BFDB2824FF8B207AAFC667DF3CBB13685B66627'
Note: See TracBrowser for help on using the repository browser.