source: main/waeup.custom/trunk/src/waeup/custom/interswitch/browser.py @ 7929

Last change on this file since 7929 was 7928, checked in by Henrik Bettermann, 13 years ago

All fees must be float not int.
  • Property svn:keywords set to Id
File size: 11.8 KB
Line 
1## $Id: browser.py 7928 2012-03-20 14:37:35Z 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 waeup.kofa.browser.layout import KofaPage, UtilityView
24from waeup.kofa.accesscodes import create_accesscode
25from waeup.kofa.students.interfaces import IStudentOnlinePayment
26from waeup.kofa.students.browser import write_log_message
27from waeup.kofa.students.viewlets import RequestCallbackActionButton
28from waeup.custom.utils.utils import actions_after_payment
29from waeup.custom.interfaces import MessageFactory as _
30
31PRODUCT_ID = '57'
32SITE_NAME = 'xyz.waeup.org'
33PROVIDER_ACCT = '2345'
34PROVIDER_BANK_ID = '8'
35PROVIDER_ITEM_NAME = 'Kofa Provider Fee'
36INSTITUTION_ACCT = '1234'
37INSTITUTION_BANK_ID = '9'
38INSTITUTION_NAME = 'Sample University'
39CURRENCY = '566'
40PAY_ITEM_ID = '5700'
41QUERY_URL =   'https://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryURL.aspx'
42POST_ACTION = 'https://testwebpay.interswitchng.com/test_paydirect/webpay/pay.aspx'
43
44HOST = 'testwebpay.interswitchng.com'
45URL = '/test_paydirect/services/TransactionQueryWs.asmx'
46httplib.HTTPConnection.debuglevel = 0
47
48def SOAP_post(soap_action,xml):
49    """Handles making the SOAP request.
50
51    Further reading:
52    http://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryWs.asmx?op=getTransactionData
53    """
54    h = httplib.HTTPConnection(HOST)
55    headers={
56        'Host':HOST,
57        'Content-Type':'text/xml; charset=utf-8',
58        'Content-Length':len(xml),
59        'SOAPAction':'"%s"' % soap_action,
60    }
61    h.request('POST', URL, body=xml,headers=headers)
62    r = h.getresponse()
63    d = r.read()
64    if r.status!=200:
65        raise ValueError('Error connecting: %s, %s' % (r.status, r.reason))
66    return d
67
68def get_SOAP_response(product_id, transref):
69    xml="""\
70<?xml version="1.0" encoding="utf-8"?>
71<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/">
72  <soap:Body>
73    <getTransactionData xmlns="http://tempuri.org/">
74      <product_id>%s</product_id>
75      <trans_ref>%s</trans_ref>
76    </getTransactionData>
77  </soap:Body>
78</soap:Envelope>""" % (product_id, transref)
79    result_xml=SOAP_post("http://tempuri.org/getTransactionData",xml)
80    doc=parseString(result_xml)
81    response=doc.getElementsByTagName('getTransactionDataResult')[0].firstChild.data
82    return response
83
84class InterswitchActionButton(RequestCallbackActionButton):
85    grok.order(2)
86    icon = 'actionicon_pay.png'
87    text = _('CollegePAY')
88    target = 'goto_interswitch'
89
90    @property
91    def target_url(self):
92        if self.context.p_state != 'unpaid':
93            return ''
94        return self.view.url(self.view.context, self.target)
95
96class InterswitchRequestCallbackActionButton(RequestCallbackActionButton):
97    grok.order(3)
98    icon = 'actionicon_call.png'
99    text = _('Request CollegePAY callback')
100
101    def target_url(self):
102        if self.context.p_state == 'paid':
103            return ''
104        site_redirect_url = self.view.url(self.view.context, 'callback')
105        args = {
106            'transRef':self.context.p_id,
107            'prodID':PRODUCT_ID,
108            'redirectURL':site_redirect_url}
109        return QUERY_URL + '?%s' % urllib.urlencode(args)
110
111# Alternative preferred solution
112class InterswitchRequestWebserviceActionButton(RequestCallbackActionButton):
113    grok.order(4)
114    icon = 'actionicon_call.png'
115    text = _('Request CollegePAY webservice')
116    target = 'request_webservice'
117
118
119class InterswitchPage(KofaPage):
120    """ View which sends a POST request to the Interswitch
121    CollegePAY payment gateway.
122    """
123    grok.context(IStudentOnlinePayment)
124    grok.name('goto_interswitch')
125    grok.template('goto_interswitch')
126    grok.require('waeup.payStudent')
127    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
128    submit_button = _('Submit')
129    action = POST_ACTION
130    site_name = SITE_NAME
131    currency = CURRENCY
132    pay_item_id = PAY_ITEM_ID
133    product_id = PRODUCT_ID
134
135    def update(self):
136        if self.context.p_state != 'unpaid':
137            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
138            self.redirect(self.url(self.context, '@@index'))
139            return
140        self.student = self.context.getStudent()
141        self.amount = (self.context.amount_auth + self.context.surcharge_1 +
142            self.context.surcharge_2 + self.context.surcharge_3)
143        self.amount_100 = 100 * self.amount
144        self.local_date_time = str(self.context.creation_date)
145        self.site_redirect_url = self.url(self.context, 'callback')
146        certificate = getattr(self.student['studycourse'],'certificate',None)
147        xmldict = {}
148        if certificate is not None:
149            xmldict['department'] = certificate.__parent__.__parent__.code
150            xmldict['faculty'] = certificate.__parent__.__parent__.__parent__.code
151        else:
152            xmldict['department'] = None
153            xmldict['faculty'] = None
154        xmldict['detail_ref'] = self.context.p_id
155        xmldict['provider_amt'] = 100 * self.context.surcharge_1
156        xmldict['provider_acct'] = PROVIDER_ACCT
157        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
158        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
159        xmldict['institution_amt'] = 100 * self.context.amount_auth
160        xmldict['institution_acct'] = INSTITUTION_ACCT
161        xmldict['institution_bank_id'] = INSTITUTION_BANK_ID
162        xmldict['institution_item_name'] = self.context.p_category
163        xmldict['institution_name'] = INSTITUTION_NAME
164        # Interswitch amount is not part of the xml data
165        xmltext = """<payment_item_detail>
166<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
167<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" />
168<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" />
169</item_details>
170</payment_item_detail>""" % xmldict
171        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
172        return
173
174class InterswitchPaymentCallbackPage(UtilityView, grok.View):
175    """ Callback view for the CollegePAY gateway
176    """
177    grok.context(IStudentOnlinePayment)
178    grok.name('callback')
179    grok.require('waeup.payStudent')
180
181    # This view is not yet working for offline querying transactions
182    # since the query string differs from the query string sent after
183    # posting transactions. This Interswitch bug must be removed first.
184    # Alternatively, we could use the webservice only and replace
185    # the RequestCallbackActionButton by a RequestWebserviceActionButton
186
187    def update(self):
188        if self.context.p_state == 'paid':
189            self.flash(_('This ticket has already been paid.'))
190            return
191        student = self.context.getStudent()
192        query = self.request.form
193        # Should be logged instead of printed
194        write_log_message(self,'callback received: %s' % query)
195
196        self.context.r_card_num = query.get('cardNum', None)
197        self.context.r_code = query.get('resp', None)
198        self.context.r_pay_reference  = query.get('payRef', None)
199        self.context.r_amount_approved = float(query.get('apprAmt', '0.0')) / 100
200        self.context.r_desc = query.get('desc', None)
201
202        if self.context.r_code != '00':
203            self.flash(_('Unsuccessful callback: ${a}',
204                mapping = {'a': query.get('desc', _('Incomplete query string.'))}))
205            write_log_message(self,'unsuccessful callback: %s' % self.context.p_id)
206            self.context.p_state = 'failed'
207            return
208
209        total_amount_auth = (
210            self.context.amount_auth
211            + self.context.surcharge_1
212            + self.context.surcharge_2)
213
214        if self.context.r_amount_approved != total_amount_auth:
215            self.flash(_('Wrong amount'))
216            write_log_message(self,'successful but wrong amount: %s' % self.context.p_id)
217            self.context.p_state = 'failed'
218            return
219
220        # Add webservice validation
221        validation_list = get_SOAP_response(
222            PRODUCT_ID, self.context.p_id).split(':')
223        # Validation does not make sense yet since the query string
224        # formats are conflicting.
225        print validation_list
226
227        write_log_message(self,'valid callback: %s' % self.context.p_id)
228        self.context.p_state = 'paid'
229        self.context.payment_date = datetime.now()
230
231        actions_after_payment(student, self.context, self)
232
233        return
234
235    def render(self):
236        self.redirect(self.url(self.context, '@@index'))
237        return
238
239# Alternative solution, replaces OnlinePaymentCallbackPage
240class InterswitchPaymentRequestWebservicePage(UtilityView, grok.View):
241    """ Request webservice view for the CollegePAY gateway
242    """
243    grok.context(IStudentOnlinePayment)
244    grok.name('request_webservice')
245    grok.require('waeup.payStudent')
246
247    def update(self):
248        if self.context.p_state == 'paid':
249            self.flash(_('This ticket has already been paid.'))
250            return
251        student = self.context.getStudent()
252        sr = get_SOAP_response(PRODUCT_ID, self.context.p_id)
253        write_log_message(self,'callback received: %s' % sr)
254        wlist = sr.split(':')
255        if len(wlist) != 7:
256            self.flash(_('Invalid callback: ${a}',
257                mapping = {'a': wlist}))
258            write_log_message(self,'invalid callback: %s' % self.context.p_id)
259            return
260        self.context.r_code = wlist[0]
261        self.context.r_desc = wlist[1]
262        self.context.r_amount_approved = float(wlist[2]) / 100
263        self.context.r_card_num = wlist[3]
264        self.context.r_pay_reference = wlist[5]
265       
266        if self.context.r_code != '00':
267            self.flash(_('Unsuccessful callback: ${a}',
268                mapping = {'a': wlist[1]}))
269            write_log_message(self,'unsuccessful callback: %s' % self.context.p_id)
270            self.context.p_state = 'failed'
271            return
272
273        total_amount_auth = (
274            self.context.amount_auth
275            + self.context.surcharge_1
276            + self.context.surcharge_2)
277
278        if self.context.r_amount_approved != total_amount_auth:
279            self.flash(_('Wrong amount'))
280            write_log_message(self,'successful callback but wrong amount: %s' % self.context.p_id)
281            self.context.p_state = 'failed'
282            return
283
284        if wlist[4] != self.context.p_id:
285            self.flash(_('Wrong transaction id'))
286            write_log_message(self,'successful callback but wrong transaction id: %s' % self.context.p_id)
287            self.context.p_state = 'failed'
288            return
289
290        write_log_message(self,'successful callback: %s' % self.context.p_id)
291
292        self.context.p_state = 'paid'
293        self.context.payment_date = datetime.now()
294
295        actions_after_payment(student, self.context, self)
296
297        return
298
299    def render(self):
300        self.redirect(self.url(self.context, '@@index'))
301        return
Note: See TracBrowser for help on using the repository browser.