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

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

Configure FCEOkene student school fee data.
  • Property svn:keywords set to Id
File size: 14.7 KB
Line 
1## $Id: browser.py 9129 2012-08-30 11:16:57Z 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.kofa.payments.interfaces import payment_categories
31from waeup.fceokene.students.interfaces import ICustomStudentOnlinePayment
32from waeup.fceokene.applicants.interfaces import ICustomApplicantOnlinePayment
33from waeup.fceokene.interfaces import MessageFactory as _
34
35PRODUCT_ID = '83'
36SITE_NAME = 'fceokene-kofa.waeup.org'
37PROVIDER_ACCT = '0026781725'
38PROVIDER_BANK_ID = '31'
39PROVIDER_ITEM_NAME = 'BT Education'
40INSTITUTION_NAME = 'FCEOkene'
41CURRENCY = '566'
42#QUERY_URL = 'https://webpay.interswitchng.com/paydirect/services/TransactionQueryURL.aspx'
43#QUERY_URL = 'https://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryURL.aspx'
44POST_ACTION = 'https://webpay.interswitchng.com/paydirect/webpay/pay.aspx'
45#POST_ACTION = 'https://testwebpay.interswitchng.com/test_paydirect/webpay/pay.aspx'
46
47HOST = 'webpay.interswitchng.com'
48#HOST = 'testwebpay.interswitchng.com'
49URL = '/paydirect/services/TransactionQueryWs.asmx'
50#URL = '/test_paydirect/services/TransactionQueryWs.asmx'
51httplib.HTTPConnection.debuglevel = 0
52
53
54def SOAP_post(soap_action,xml):
55    """Handles making the SOAP request.
56
57    Further reading:
58    http://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryWs.asmx?op=getTransactionData
59    """
60    h = httplib.HTTPConnection(HOST)
61    headers={
62        'Host':HOST,
63        'Content-Type':'text/xml; charset=utf-8',
64        'Content-Length':len(xml),
65        'SOAPAction':'"%s"' % soap_action,
66    }
67    h.request('POST', URL, body=xml,headers=headers)
68    r = h.getresponse()
69    d = r.read()
70    if r.status!=200:
71        raise ValueError('Error connecting: %s, %s' % (r.status, r.reason))
72    return d
73
74def get_SOAP_response(product_id, transref):
75    xml="""\
76<?xml version="1.0" encoding="utf-8"?>
77<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/">
78  <soap:Body>
79    <getTransactionData xmlns="http://tempuri.org/">
80      <product_id>%s</product_id>
81      <trans_ref>%s</trans_ref>
82    </getTransactionData>
83  </soap:Body>
84</soap:Envelope>""" % (product_id, transref)
85    result_xml=SOAP_post("http://tempuri.org/getTransactionData",xml)
86    doc=parseString(result_xml)
87    response=doc.getElementsByTagName('getTransactionDataResult')[0].firstChild.data
88    return response
89
90def query_interswitch(payment):
91    sr = get_SOAP_response(PRODUCT_ID, payment.p_id)
92    wlist = sr.split(':')
93    if len(wlist) != 7:
94        msg = _('Invalid callback: ${a}', mapping = {'a': sr})
95        log = 'invalid callback for payment %s: %s' % (payment.p_id, sr)
96        return False, msg, log
97    payment.r_code = wlist[0]
98    payment.r_desc = wlist[1]
99    payment.r_amount_approved = float(wlist[2]) / 100
100    payment.r_card_num = wlist[3]
101    payment.r_pay_reference = wlist[5]
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 InterswitchActionButtonApplicant(APABApplicant):
138    grok.order(1)
139    grok.context(ICustomApplicantOnlinePayment)
140    grok.require('waeup.payApplicant')
141    icon = 'actionicon_pay.png'
142    text = _('CollegePAY')
143    target = 'goto_interswitch'
144
145    @property
146    def target_url(self):
147        if self.context.p_state != 'unpaid':
148            return ''
149        return self.view.url(self.view.context, self.target)
150
151class InterswitchRequestWebserviceActionButtonStudent(APABStudent):
152    grok.order(2)
153    grok.context(ICustomStudentOnlinePayment)
154    grok.require('waeup.payStudent')
155    icon = 'actionicon_call.png'
156    text = _('Requery CollegePAY')
157    target = 'request_webservice'
158
159class InterswitchRequestWebserviceActionButtonApplicant(APABApplicant):
160    grok.order(2)
161    grok.context(ICustomApplicantOnlinePayment)
162    grok.require('waeup.payApplicant')
163    icon = 'actionicon_call.png'
164    text = _('Requery CollegePAY')
165    target = 'request_webservice'
166
167class InterswitchPageStudent(KofaPage):
168    """ View which sends a POST request to the Interswitch
169    CollegePAY payment gateway.
170    """
171    grok.context(ICustomStudentOnlinePayment)
172    grok.name('goto_interswitch')
173    grok.template('student_goto_interswitch')
174    grok.require('waeup.payStudent')
175    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
176    submit_button = _('Submit')
177    action = POST_ACTION
178    site_name = SITE_NAME
179    currency = CURRENCY
180    pay_item_id = '8302'
181    product_id = PRODUCT_ID
182
183    def update(self):
184        #if self.context.p_state != 'unpaid':
185        if self.context.p_state == 'paid':
186            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
187            self.redirect(self.url(self.context, '@@index'))
188            return
189
190        student = self.student = self.context.student
191        certificate = getattr(student['studycourse'],'certificate',None)
192        self.amount_auth = 100 * self.context.amount_auth
193        xmldict = {}
194        if certificate is not None:
195            xmldict['department'] = certificate.__parent__.__parent__.code
196            xmldict['faculty'] = certificate.__parent__.__parent__.__parent__.code
197        else:
198            xmldict['department'] = None
199            xmldict['faculty'] = None
200        self.category = payment_categories.getTermByToken(
201            self.context.p_category).title
202        tz = getUtility(IKofaUtils).tzinfo
203        self.local_date_time = to_timezone(
204            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
205        self.site_redirect_url = self.url(self.context, 'request_webservice')
206        # Provider data
207        xmldict['detail_ref'] = self.context.p_id
208        xmldict['provider_acct'] = PROVIDER_ACCT
209        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
210        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
211        xmldict['provider_amt'] = 100 * 500
212        # Institution data
213        studycourse = student['studycourse']
214        if student.current_mode in ('ug_sw','prence',):
215            xmldict['institution_acct'] = "6216801025"
216            xmldict['institution_bank_id'] = '117'
217        elif student.current_mode in ('ug_ft',) and \
218            student['studycourse'].current_verdict == 'O':
219            xmldict['institution_acct'] = "6216801025"
220            xmldict['institution_bank_id'] = '117'
221        elif student.current_mode in ('ug_ft',):
222            xmldict['institution_acct'] = "6216801033"
223            xmldict['institution_bank_id'] = '117'
224        elif student.current_mode in ('pd_ft',):
225            xmldict['institution_acct'] = "6216801025"
226            xmldict['institution_bank_id'] = '117'
227        else:
228            xmldict['fceokene_acct'] = "0000000000000"
229            xmldict['institution_bank_id'] = '0'
230        xmldict['fceokene_split'] = 100 * 1400
231        xmldict['institution_amt'] = 100 * (
232            self.context.amount_auth - 500 - 150 - 1400)
233        xmldict['institution_item_name'] = self.context.p_category
234        xmldict['institution_name'] = INSTITUTION_NAME
235        # Interswitch amount is not part of the xml data
236        xmltext = """<payment_item_detail>
237<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
238<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" />
239<item_detail item_id="2" item_name="FCEOkene Split" item_amt="%(fceokene_split)s" bank_id="117" acct_num="6216801058" />
240<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" />
241</item_details>
242</payment_item_detail>""" % xmldict
243        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
244        return
245
246class InterswitchPageApplicant(KofaPage):
247    """ View which sends a POST request to the Interswitch
248    CollegePAY payment gateway.
249    """
250    grok.context(ICustomApplicantOnlinePayment)
251    grok.require('waeup.payApplicant')
252    grok.template('applicant_goto_interswitch')
253    grok.name('goto_interswitch')
254    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
255    submit_button = _('Submit')
256    action = POST_ACTION
257    site_name = SITE_NAME
258    currency = CURRENCY
259    pay_item_id = '8303'
260    product_id = PRODUCT_ID
261
262    def update(self):
263        if self.context.p_state != 'unpaid':
264            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
265            self.redirect(self.url(self.context, '@@index'))
266            return
267        if self.context.__parent__.__parent__.expired \
268            and self.context.__parent__.__parent__.strict_deadline:
269            self.flash(_("Payment ticket can't be send to CollegePAY. "
270                         "Application period has expired."))
271            self.redirect(self.url(self.context, '@@index'))
272            return
273        self.applicant = self.context.__parent__
274        self.amount_auth = 100 * self.context.amount_auth
275        xmldict = {}
276        self.category = payment_categories.getTermByToken(
277            self.context.p_category).title
278        tz = getUtility(IKofaUtils).tzinfo
279        self.local_date_time = to_timezone(
280            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
281        self.site_redirect_url = self.url(self.context, 'request_webservice')
282        xmldict['detail_ref'] = self.context.p_id
283        # Provider data
284        xmldict['provider_amt'] = 100 * 500
285        xmldict['provider_acct'] = PROVIDER_ACCT
286        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
287        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
288        # Institution data
289        xmldict['institution_amt'] = 100 * (self.context.amount_auth - 500 - 150)
290        xmldict['institution_acct'] = '1012445289'
291        xmldict['institution_bank_id'] = '117'
292        xmldict['institution_item_name'] = self.context.p_category
293        xmldict['institution_name'] = INSTITUTION_NAME
294        # Interswitch amount is not part of the xml data
295        xmltext = """<payment_item_detail>
296<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
297<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" />
298<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" />
299</item_details>
300</payment_item_detail>""" % xmldict
301        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
302        return
303
304
305class InterswitchPaymentRequestWebservicePageStudent(UtilityView, grok.View):
306    """ Request webservice view for the CollegePAY gateway
307    """
308    grok.context(ICustomStudentOnlinePayment)
309    grok.name('request_webservice')
310    grok.require('waeup.payStudent')
311
312    def update(self):
313        ob_class = self.__implemented__.__name__
314        if self.context.p_state == 'paid':
315            self.flash(_('This ticket has already been paid.'))
316            return
317        student = self.context.student
318        success, msg, log = query_interswitch(self.context)
319        student.writeLogMessage(self, log)
320        if not success:
321            self.flash(msg)
322            return
323        success, msg, log = self.context.doAfterStudentPayment()
324        if log is not None:
325            student.writeLogMessage(self, log)
326        self.flash(msg)
327        return
328
329    def render(self):
330        self.redirect(self.url(self.context, '@@index'))
331        return
332
333class InterswitchPaymentRequestWebservicePageApplicant(UtilityView, grok.View):
334    """ Request webservice view for the CollegePAY gateway
335    """
336    grok.context(ICustomApplicantOnlinePayment)
337    grok.name('request_webservice')
338    grok.require('waeup.payApplicant')
339
340    def update(self):
341        if self.context.p_state == 'paid':
342            self.flash(_('This ticket has already been paid.'))
343            return
344        applicant = self.context.__parent__
345        success, msg, log = query_interswitch(self.context)
346        applicant.writeLogMessage(self, log)
347        if not success:
348            self.flash(msg)
349            return
350        success, msg, log = self.context.doAfterApplicantPayment()
351        if log is not None:
352            applicant.writeLogMessage(self, log)
353        self.flash(msg)
354        return
355
356    def render(self):
357        self.redirect(self.url(self.context, '@@index'))
358        return
Note: See TracBrowser for help on using the repository browser.