source: main/waeup.fceokene/trunk/src/waeup/fceokene/interswitch/browser.py @ 9406

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

The payment_categories vocab does no longer exist. We have a dict in KofaUtils? instead.
  • Property svn:keywords set to Id
File size: 14.6 KB
Line 
1## $Id: browser.py 9406 2012-10-24 21:58:51Z 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, 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.fceokene.students.interfaces import ICustomStudentOnlinePayment
31from waeup.fceokene.applicants.interfaces import ICustomApplicantOnlinePayment
32from waeup.fceokene.interfaces import MessageFactory as _
33
34PRODUCT_ID = '83'
35SITE_NAME = 'fceokene-kofa.waeup.org'
36PROVIDER_ACCT = '0026781725'
37PROVIDER_BANK_ID = '31'
38PROVIDER_ITEM_NAME = 'BT Education'
39INSTITUTION_NAME = 'FCEOkene'
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    if payment.r_code != '00':
102        msg = _('Unsuccessful callback: ${a}', mapping = {'a': sr})
103        log = 'unsuccessful callback for payment %s: %s' % (payment.p_id, sr)
104        payment.p_state = 'failed'
105        return False, msg, log
106    if payment.r_amount_approved != payment.amount_auth:
107        msg = _('Callback amount does not match.')
108        log = 'wrong callback for payment %s: %s' % (payment.p_id, sr)
109        payment.p_state = 'failed'
110        return False, msg, log
111    if wlist[4] != payment.p_id:
112        msg = _('Callback transaction id does not match.')
113        log = 'wrong callback for payment %s: %s' % (payment.p_id, sr)
114        payment.p_state = 'failed'
115        return False, msg, log
116    payment.p_state = 'paid'
117    payment.payment_date = datetime.utcnow()
118    msg = _('Successful callback received')
119    log = 'valid callback for payment %s: %s' % (payment.p_id, sr)
120    return True, msg, log
121
122class InterswitchActionButtonStudent(APABStudent):
123    grok.order(1)
124    grok.context(ICustomStudentOnlinePayment)
125    grok.require('waeup.payStudent')
126    icon = 'actionicon_pay.png'
127    text = _('CollegePAY')
128    target = 'goto_interswitch'
129
130    @property
131    def target_url(self):
132        if self.context.p_state != 'unpaid':
133            return ''
134        return self.view.url(self.view.context, self.target)
135
136class InterswitchActionButtonApplicant(APABApplicant):
137    grok.order(1)
138    grok.context(ICustomApplicantOnlinePayment)
139    grok.require('waeup.payApplicant')
140    icon = 'actionicon_pay.png'
141    text = _('CollegePAY')
142    target = 'goto_interswitch'
143
144    @property
145    def target_url(self):
146        if self.context.p_state != 'unpaid':
147            return ''
148        return self.view.url(self.view.context, self.target)
149
150class InterswitchRequestWebserviceActionButtonStudent(APABStudent):
151    grok.order(2)
152    grok.context(ICustomStudentOnlinePayment)
153    grok.require('waeup.payStudent')
154    icon = 'actionicon_call.png'
155    text = _('Requery CollegePAY')
156    target = 'request_webservice'
157
158class InterswitchRequestWebserviceActionButtonApplicant(APABApplicant):
159    grok.order(2)
160    grok.context(ICustomApplicantOnlinePayment)
161    grok.require('waeup.payApplicant')
162    icon = 'actionicon_call.png'
163    text = _('Requery CollegePAY')
164    target = 'request_webservice'
165
166class InterswitchPageStudent(KofaPage):
167    """ View which sends a POST request to the Interswitch
168    CollegePAY payment gateway.
169    """
170    grok.context(ICustomStudentOnlinePayment)
171    grok.name('goto_interswitch')
172    grok.template('student_goto_interswitch')
173    grok.require('waeup.payStudent')
174    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
175    submit_button = _('Submit')
176    action = POST_ACTION
177    site_name = SITE_NAME
178    currency = CURRENCY
179    pay_item_id = '8302'
180    product_id = PRODUCT_ID
181
182    def update(self):
183        #if self.context.p_state != 'unpaid':
184        if self.context.p_state == 'paid':
185            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
186            self.redirect(self.url(self.context, '@@index'))
187            return
188
189        student = self.student = self.context.student
190        certificate = getattr(student['studycourse'],'certificate',None)
191        self.amount_auth = 100 * self.context.amount_auth
192        xmldict = {}
193        if certificate is not None:
194            xmldict['department'] = certificate.__parent__.__parent__.code
195            xmldict['faculty'] = certificate.__parent__.__parent__.__parent__.code
196        else:
197            xmldict['department'] = None
198            xmldict['faculty'] = None
199        self.category = getUtility(IKofaUtils).PAYMENT_CATEGORIES[self.context.p_category]
200        tz = getUtility(IKofaUtils).tzinfo
201        self.local_date_time = to_timezone(
202            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
203        self.site_redirect_url = self.url(self.context, 'request_webservice')
204        # Provider data
205        xmldict['detail_ref'] = self.context.p_id
206        xmldict['provider_acct'] = PROVIDER_ACCT
207        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
208        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
209        xmldict['provider_amt'] = 100 * 500
210        # Institution data
211        studycourse = student['studycourse']
212        if student.current_mode in ('ug_sw','prence',):
213            xmldict['institution_acct'] = "6216801025"
214            xmldict['institution_bank_id'] = '117'
215        elif student.current_mode in ('ug_ft',) and \
216            student['studycourse'].current_verdict == 'O':
217            xmldict['institution_acct'] = "6216801025"
218            xmldict['institution_bank_id'] = '117'
219        elif student.current_mode in ('ug_ft',):
220            xmldict['institution_acct'] = "6216801033"
221            xmldict['institution_bank_id'] = '117'
222        elif student.current_mode in ('pd_ft',):
223            xmldict['institution_acct'] = "6216801025"
224            xmldict['institution_bank_id'] = '117'
225        else:
226            xmldict['fceokene_acct'] = "0000000000000"
227            xmldict['institution_bank_id'] = '0'
228        xmldict['fceokene_split'] = 100 * 1400
229        xmldict['institution_amt'] = 100 * (
230            self.context.amount_auth - 500 - 150 - 1400)
231        xmldict['institution_item_name'] = self.context.p_category
232        xmldict['institution_name'] = INSTITUTION_NAME
233        # Interswitch amount is not part of the xml data
234        xmltext = """<payment_item_detail>
235<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
236<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" />
237<item_detail item_id="2" item_name="FCEOkene Split" item_amt="%(fceokene_split)s" bank_id="117" acct_num="6216801058" />
238<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" />
239</item_details>
240</payment_item_detail>""" % xmldict
241        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
242        return
243
244class InterswitchPageApplicant(KofaPage):
245    """ View which sends a POST request to the Interswitch
246    CollegePAY payment gateway.
247    """
248    grok.context(ICustomApplicantOnlinePayment)
249    grok.require('waeup.payApplicant')
250    grok.template('applicant_goto_interswitch')
251    grok.name('goto_interswitch')
252    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
253    submit_button = _('Submit')
254    action = POST_ACTION
255    site_name = SITE_NAME
256    currency = CURRENCY
257    pay_item_id = '8303'
258    product_id = PRODUCT_ID
259
260    def update(self):
261        if self.context.p_state != 'unpaid':
262            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
263            self.redirect(self.url(self.context, '@@index'))
264            return
265        if self.context.__parent__.__parent__.expired \
266            and self.context.__parent__.__parent__.strict_deadline:
267            self.flash(_("Payment ticket can't be send to CollegePAY. "
268                         "Application period has expired."))
269            self.redirect(self.url(self.context, '@@index'))
270            return
271        self.applicant = self.context.__parent__
272        self.amount_auth = 100 * self.context.amount_auth
273        xmldict = {}
274        self.category = getUtility(IKofaUtils).PAYMENT_CATEGORIES[self.context.p_category]
275        tz = getUtility(IKofaUtils).tzinfo
276        self.local_date_time = to_timezone(
277            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
278        self.site_redirect_url = self.url(self.context, 'request_webservice')
279        xmldict['detail_ref'] = self.context.p_id
280        # Provider data
281        xmldict['provider_amt'] = 100 * 500
282        xmldict['provider_acct'] = PROVIDER_ACCT
283        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
284        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
285        # Institution data
286        xmldict['institution_amt'] = 100 * (self.context.amount_auth - 500 - 150)
287        xmldict['institution_acct'] = '1012445289'
288        xmldict['institution_bank_id'] = '117'
289        xmldict['institution_item_name'] = self.context.p_category
290        xmldict['institution_name'] = INSTITUTION_NAME
291        # Interswitch amount is not part of the xml data
292        xmltext = """<payment_item_detail>
293<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
294<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" />
295<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" />
296</item_details>
297</payment_item_detail>""" % xmldict
298        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
299        return
300
301
302class InterswitchPaymentRequestWebservicePageStudent(UtilityView, grok.View):
303    """ Request webservice view for the CollegePAY gateway
304    """
305    grok.context(ICustomStudentOnlinePayment)
306    grok.name('request_webservice')
307    grok.require('waeup.payStudent')
308
309    def update(self):
310        ob_class = self.__implemented__.__name__
311        if self.context.p_state == 'paid':
312            self.flash(_('This ticket has already been paid.'))
313            return
314        student = self.context.student
315        success, msg, log = query_interswitch(self.context)
316        student.writeLogMessage(self, log)
317        if not success:
318            self.flash(msg)
319            return
320        success, msg, log = self.context.doAfterStudentPayment()
321        if log is not None:
322            student.writeLogMessage(self, log)
323        self.flash(msg)
324        return
325
326    def render(self):
327        self.redirect(self.url(self.context, '@@index'))
328        return
329
330class InterswitchPaymentRequestWebservicePageApplicant(UtilityView, grok.View):
331    """ Request webservice view for the CollegePAY gateway
332    """
333    grok.context(ICustomApplicantOnlinePayment)
334    grok.name('request_webservice')
335    grok.require('waeup.payApplicant')
336
337    def update(self):
338        if self.context.p_state == 'paid':
339            self.flash(_('This ticket has already been paid.'))
340            return
341        applicant = self.context.__parent__
342        success, msg, log = query_interswitch(self.context)
343        applicant.writeLogMessage(self, log)
344        if not success:
345            self.flash(msg)
346            return
347        success, msg, log = self.context.doAfterApplicantPayment()
348        if log is not None:
349            applicant.writeLogMessage(self, log)
350        self.flash(msg)
351        return
352
353    def render(self):
354        self.redirect(self.url(self.context, '@@index'))
355        return
Note: See TracBrowser for help on using the repository browser.