source: main/waeup.futminna/trunk/src/waeup/futminna/interswitch/browser.py @ 9431

Last change on this file since 9431 was 9410, checked in by Henrik Bettermann, 12 years ago

Configure bank account details for maintenance fee payment.
  • Property svn:keywords set to Id
File size: 14.2 KB
Line 
1## $Id: browser.py 9410 2012-10-25 04:10:15Z 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##
18from datetime import datetime
19import httplib
20import urllib
21from xml.dom.minidom import parseString
22import grok
23from zope.component import getUtility
24from waeup.kofa.browser.layout import KofaPage, UtilityView
25from waeup.kofa.accesscodes import create_accesscode
26from waeup.kofa.interfaces import RETURNING, CLEARED, IKofaUtils
27from waeup.kofa.utils.helpers import to_timezone
28from waeup.kofa.students.viewlets import ApprovePaymentActionButton as APABStudent
29from waeup.kofa.applicants.viewlets import ApprovePaymentActionButton as APABApplicant
30from waeup.futminna.students.interfaces import ICustomStudentOnlinePayment
31from waeup.futminna.applicants.interfaces import ICustomApplicantOnlinePayment
32from waeup.futminna.interfaces import MessageFactory as _
33
34PRODUCT_ID = '117'
35SITE_NAME = 'futminna-kofa.waeup.org'
36PROVIDER_ACCT = '0061001000021095'
37PROVIDER_BANK_ID = '89'
38PROVIDER_ITEM_NAME = 'BT Education'
39INSTITUTION_NAME = 'FUTMinna'
40CURRENCY = '566'
41#QUERY_URL = 'https://webpay.interswitchng.com/paydirect/services/TransactionQueryURL.aspx'
42#QUERY_URL = 'https://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryURL.aspx'
43POST_ACTION = 'https://webpay.interswitchng.com/paydirect/webpay/pay.aspx'
44#POST_ACTION = 'https://testwebpay.interswitchng.com/test_paydirect/webpay/pay.aspx'
45
46HOST = 'webpay.interswitchng.com'
47#HOST = 'testwebpay.interswitchng.com'
48URL = '/paydirect/services/TransactionQueryWs.asmx'
49#URL = '/test_paydirect/services/TransactionQueryWs.asmx'
50httplib.HTTPConnection.debuglevel = 0
51
52
53def SOAP_post(soap_action,xml):
54    """Handles making the SOAP request.
55
56    Further reading:
57    http://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryWs.asmx?op=getTransactionData
58    """
59    h = httplib.HTTPConnection(HOST)
60    headers={
61        'Host':HOST,
62        'Content-Type':'text/xml; charset=utf-8',
63        'Content-Length':len(xml),
64        'SOAPAction':'"%s"' % soap_action,
65    }
66    h.request('POST', URL, body=xml,headers=headers)
67    r = h.getresponse()
68    d = r.read()
69    if r.status!=200:
70        raise ValueError('Error connecting: %s, %s' % (r.status, r.reason))
71    return d
72
73def get_SOAP_response(product_id, transref):
74    xml="""\
75<?xml version="1.0" encoding="utf-8"?>
76<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
77  <soap:Body>
78    <getTransactionData xmlns="http://tempuri.org/">
79      <product_id>%s</product_id>
80      <trans_ref>%s</trans_ref>
81    </getTransactionData>
82  </soap:Body>
83</soap:Envelope>""" % (product_id, transref)
84    result_xml=SOAP_post("http://tempuri.org/getTransactionData",xml)
85    doc=parseString(result_xml)
86    response=doc.getElementsByTagName('getTransactionDataResult')[0].firstChild.data
87    return response
88
89def query_interswitch(payment):
90    sr = get_SOAP_response(PRODUCT_ID, payment.p_id)
91    wlist = sr.split(':')
92    if len(wlist) != 7:
93        msg = _('Invalid callback: ${a}', mapping = {'a': sr})
94        log = 'invalid callback for payment %s: %s' % (payment.p_id, sr)
95        return False, msg, log
96    payment.r_code = wlist[0]
97    payment.r_desc = wlist[1]
98    payment.r_amount_approved = float(wlist[2]) / 100
99    payment.r_card_num = wlist[3]
100    payment.r_pay_reference = wlist[5]
101    payment.r_company = u'interswitch'
102    if payment.r_code != '00':
103        msg = _('Unsuccessful callback: ${a}', mapping = {'a': sr})
104        log = 'unsuccessful callback for payment %s: %s' % (payment.p_id, sr)
105        payment.p_state = 'failed'
106        return False, msg, log
107    if payment.r_amount_approved != payment.amount_auth:
108        msg = _('Callback amount does not match.')
109        log = 'wrong callback for payment %s: %s' % (payment.p_id, sr)
110        payment.p_state = 'failed'
111        return False, msg, log
112    if wlist[4] != payment.p_id:
113        msg = _('Callback transaction id does not match.')
114        log = 'wrong callback for payment %s: %s' % (payment.p_id, sr)
115        payment.p_state = 'failed'
116        return False, msg, log
117    payment.p_state = 'paid'
118    payment.payment_date = datetime.utcnow()
119    msg = _('Successful callback received')
120    log = 'valid callback for payment %s: %s' % (payment.p_id, sr)
121    return True, msg, log
122
123class InterswitchActionButtonStudent(APABStudent):
124    grok.order(1)
125    grok.context(ICustomStudentOnlinePayment)
126    grok.require('waeup.payStudent')
127    icon = 'actionicon_pay.png'
128    text = _('CollegePAY')
129    target = 'goto_interswitch'
130
131    @property
132    def target_url(self):
133        if self.context.p_state != 'unpaid':
134            return ''
135        return self.view.url(self.view.context, self.target)
136
137class InterswitchRequestWebserviceActionButtonStudent(APABStudent):
138    grok.order(2)
139    grok.context(ICustomStudentOnlinePayment)
140    grok.require('waeup.payStudent')
141    icon = 'actionicon_call.png'
142    text = _('Requery CollegePAY')
143    target = 'request_webservice'
144
145class InterswitchPageStudent(KofaPage):
146    """ View which sends a POST request to the Interswitch
147    CollegePAY payment gateway.
148    """
149    grok.context(ICustomStudentOnlinePayment)
150    grok.name('goto_interswitch')
151    grok.template('student_goto_interswitch')
152    grok.require('waeup.payStudent')
153    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
154    submit_button = _('Submit')
155    action = POST_ACTION
156    site_name = SITE_NAME
157    currency = CURRENCY
158    pay_item_id = ''
159    product_id = PRODUCT_ID
160
161    def update(self):
162        #if self.context.p_state != 'unpaid':
163        if self.context.p_state == 'paid':
164            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
165            self.redirect(self.url(self.context, '@@index'))
166            return
167
168        student = self.student = self.context.student
169        certificate = getattr(student['studycourse'],'certificate',None)
170        self.amount_auth = 100 * self.context.amount_auth
171        xmldict = {}
172        if certificate is not None:
173            xmldict['department'] = certificate.__parent__.__parent__.code
174            xmldict['faculty'] = certificate.__parent__.__parent__.__parent__.code
175        else:
176            xmldict['department'] = None
177            xmldict['faculty'] = None
178        self.category = getUtility(IKofaUtils).PAYMENT_CATEGORIES[self.context.p_category]
179        tz = getUtility(IKofaUtils).tzinfo
180        self.local_date_time = to_timezone(
181            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
182        self.site_redirect_url = self.url(self.context, 'request_webservice')
183        # Provider data
184        xmldict['detail_ref'] = self.context.p_id
185        xmldict['provider_acct'] = PROVIDER_ACCT
186        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
187        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
188        provider_amt = 1500
189        xmldict['provider_amt'] = 100 * provider_amt
190
191        # Institution data
192        studycourse = student['studycourse']
193        xmldict['institution_acct'] = ''
194        xmldict['institution_bank_id'] = ''
195        xmldict['institution_acct'] = '000000000000'
196        xmldict['institution_bank_id'] = '00'
197       
198        if self.context.p_category == 'schoolfee':
199            xmldict['institution_amt'] = 100 * (
200                self.context.amount_auth - provider_amt - 300)
201            if self.context.student.current_mode in ('pg_ft'):
202                self.pay_item_id = "11703"
203            elif self.context.student.state == CLEARED and \
204                self.context.student.current_level == 100:
205                self.pay_item_id = "11700"
206            elif self.context.student.state == CLEARED and \
207                self.context.student.current_level == 200:
208                self.pay_item_id = "11701"
209            elif self.context.student.state == CLEARED and \
210                self.context.student.current_level == 300:
211                self.pay_item_id = "11702"
212            elif self.context.student.state == RETURNING and \
213                self.context.student.current_level in (100,110):
214                self.pay_item_id = "11701"
215            elif self.context.student.state == RETURNING and \
216                self.context.student.current_level in (200,210):
217                self.pay_item_id = "11702"
218            elif self.context.student.state == RETURNING and \
219                self.context.student.current_level in (300,310):
220                self.pay_item_id = "11703"
221            elif self.context.student.state == RETURNING and \
222                self.context.student.current_level in (400,410,500,510,600):
223                self.pay_item_id = "11704"
224
225            if self.context.student.current_mode == 'jm_ft':
226                xmldict['institution_acct'] = "000000000000"
227                xmldict['institution_bank_id'] = '00'
228            elif self.context.student.current_mode == 'pg_ft':
229                xmldict['institution_acct'] = "2522040000134"
230                xmldict['institution_bank_id'] = '8'
231            elif self.context.student.state == CLEARED and \
232                self.context.student.current_level == 100:
233                xmldict['institution_acct'] = "0030001000017110"
234                xmldict['institution_bank_id'] = '89'
235            elif self.context.student.state == CLEARED and \
236                self.context.student.current_level == 200:
237                xmldict['institution_acct'] = "0591201005146"
238                xmldict['institution_bank_id'] = '101'
239            elif self.context.student.state == CLEARED and \
240                self.context.student.current_level == 300:
241                xmldict['institution_acct'] = "6013803345"
242                xmldict['institution_bank_id'] = '117'
243            elif self.context.student.state == RETURNING and \
244                self.context.student.current_level in (100,110):
245                xmldict['institution_acct'] = "0591201005146"
246                xmldict['institution_bank_id'] = '101'
247            elif self.context.student.current_level in (200,210):
248                xmldict['institution_acct'] = "6013803345"
249                xmldict['institution_bank_id'] = '117'
250            elif self.context.student.current_level in (300,310):
251                xmldict['institution_acct'] = "2522040000134"
252                xmldict['institution_bank_id'] = '8'
253            #Change of acct from UBA to GTBank
254            elif self.context.student.current_level in (400,410,500,510,600):
255                xmldict['institution_acct'] = "3713516838111"
256                xmldict['institution_bank_id'] = '10'
257
258        elif self.context.p_category == 'clearance':
259            xmldict['institution_amt'] = 100 * (
260                self.context.amount_auth - 300)
261            xmldict['institution_acct'] = "1750005063"
262            xmldict['institution_bank_id'] = '120'
263            self.pay_item_id = "11706"
264
265        elif 'maintenance' in self.context.p_category:
266            xmldict['institution_amt'] = 100 * (
267                self.context.amount_auth - 300)
268            xmldict['institution_acct'] = "2018856637"
269            xmldict['institution_bank_id'] = '8'
270            self.pay_item_id = "11705"
271
272        xmldict['institution_name'] = INSTITUTION_NAME
273        # Interswitch amount is not part of the xml data
274
275        if self.context.p_category == 'schoolfee':
276            xmltext = """<payment_item_detail>
277<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
278<item_detail item_id="1" item_name="School Fee" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
279<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" />
280</item_details>
281</payment_item_detail>""" % xmldict
282
283        elif self.context.p_category == 'clearance':
284            xmltext = """<payment_item_detail>
285<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
286<item_detail item_id="1" item_name="Acceptance Fee" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
287</item_details>
288</payment_item_detail>""" % xmldict
289
290        elif 'maintenance' in self.context.p_category:
291            xmltext = """<payment_item_detail>
292<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
293<item_detail item_id="1" item_name="Hostel Maintenance Fee" item_amt="%(institution_amt)d" bank_id="%(institution_bank_id)s" acct_num="%(institution_acct)s" />
294</item_details>
295</payment_item_detail>""" % xmldict
296
297
298        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
299        return
300
301class InterswitchPaymentRequestWebservicePageStudent(UtilityView, grok.View):
302    """ Request webservice view for the CollegePAY gateway
303    """
304    grok.context(ICustomStudentOnlinePayment)
305    grok.name('request_webservice')
306    grok.require('waeup.payStudent')
307
308    def update(self):
309        ob_class = self.__implemented__.__name__
310        if self.context.p_state == 'paid':
311            self.flash(_('This ticket has already been paid.'))
312            return
313        student = self.context.student
314        success, msg, log = query_interswitch(self.context)
315        student.writeLogMessage(self, log)
316        if not success:
317            self.flash(msg)
318            return
319        success, msg, log = self.context.doAfterStudentPayment()
320        if log is not None:
321            student.writeLogMessage(self, log)
322        self.flash(msg)
323        return
324
325    def render(self):
326        self.redirect(self.url(self.context, '@@index'))
327        return
Note: See TracBrowser for help on using the repository browser.