source: main/waeup.uniben/trunk/src/waeup/uniben/interswitch/browser.py @ 9467

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

New bank details and bank account assignment.

  • Property svn:keywords set to Id
File size: 19.1 KB
RevLine 
[7894]1## $Id: browser.py 9460 2012-10-29 21:09:42Z 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
[7898]19import httplib
20import urllib
21from xml.dom.minidom import parseString
[7894]22import grok
[8281]23from zope.component import getUtility
[7894]24from waeup.kofa.browser.layout import KofaPage, UtilityView
25from waeup.kofa.accesscodes import create_accesscode
[8281]26from waeup.kofa.interfaces import RETURNING, IKofaUtils
27from waeup.kofa.utils.helpers import to_timezone
[8421]28from waeup.kofa.students.viewlets import ApprovePaymentActionButton as APABStudent
29from waeup.kofa.applicants.viewlets import ApprovePaymentActionButton as APABApplicant
[8263]30from waeup.uniben.students.interfaces import ICustomStudentOnlinePayment
31from waeup.uniben.applicants.interfaces import ICustomApplicantOnlinePayment
[8020]32from waeup.uniben.interfaces import MessageFactory as _
[7894]33
34PRODUCT_ID = '57'
[8263]35SITE_NAME = 'uniben-kofa.waeup.org'
[8424]36PROVIDER_ACCT = '1010764827'
37PROVIDER_BANK_ID = '117'
[8263]38PROVIDER_ITEM_NAME = 'BT Education'
39INSTITUTION_NAME = 'Uniben'
[7894]40CURRENCY = '566'
[8401]41#QUERY_URL = 'https://webpay.interswitchng.com/paydirect/services/TransactionQueryURL.aspx'
[8293]42#QUERY_URL = 'https://testwebpay.interswitchng.com/test_paydirect/services/TransactionQueryURL.aspx'
[8385]43POST_ACTION = 'https://webpay.interswitchng.com/paydirect/webpay/pay.aspx'
[8293]44#POST_ACTION = 'https://testwebpay.interswitchng.com/test_paydirect/webpay/pay.aspx'
[7894]45
[8293]46HOST = 'webpay.interswitchng.com'
47#HOST = 'testwebpay.interswitchng.com'
48URL = '/paydirect/services/TransactionQueryWs.asmx'
49#URL = '/test_paydirect/services/TransactionQueryWs.asmx'
[7898]50httplib.HTTPConnection.debuglevel = 0
51
[8256]52
[7898]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
[8430]89def query_interswitch(payment):
[8256]90    sr = get_SOAP_response(PRODUCT_ID, payment.p_id)
91    wlist = sr.split(':')
92    if len(wlist) != 7:
[8430]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
[8256]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]
[8955]101    payment.r_company = u'interswitch'
[8256]102    if payment.r_code != '00':
[8430]103        msg = _('Unsuccessful callback: ${a}', mapping = {'a': sr})
[9443]104        log = 'unsuccessful callback for %s payment %s: %s' % (
105            payment.p_category, payment.p_id, sr)
[8256]106        payment.p_state = 'failed'
[8430]107        return False, msg, log
[8263]108    if payment.r_amount_approved != payment.amount_auth:
[8430]109        msg = _('Callback amount does not match.')
[9443]110        log = 'wrong callback for %s payment %s: %s' % (
111            payment.p_category, payment.p_id, sr)
[8256]112        payment.p_state = 'failed'
[8430]113        return False, msg, log
[8256]114    if wlist[4] != payment.p_id:
[8430]115        msg = _('Callback transaction id does not match.')
[9443]116        log = 'wrong callback for %s payment %s: %s' % (
117            payment.p_category, payment.p_id, sr)
[8256]118        payment.p_state = 'failed'
[8430]119        return False, msg, log
[8256]120    payment.p_state = 'paid'
[8433]121    payment.payment_date = datetime.utcnow()
[8430]122    msg = _('Successful callback received')
[9435]123    log = 'valid callback for %s payment %s: %s' % (
124        payment.p_category, payment.p_id, sr)
[8430]125    return True, msg, log
[8256]126
[8421]127class InterswitchActionButtonStudent(APABStudent):
[8259]128    grok.order(1)
[8255]129    grok.context(ICustomStudentOnlinePayment)
[8430]130    grok.require('waeup.payStudent')
[7894]131    icon = 'actionicon_pay.png'
132    text = _('CollegePAY')
133    target = 'goto_interswitch'
134
135    @property
136    def target_url(self):
137        if self.context.p_state != 'unpaid':
138            return ''
139        return self.view.url(self.view.context, self.target)
140
[8421]141class InterswitchActionButtonApplicant(APABApplicant):
[8259]142    grok.order(1)
[8256]143    grok.context(ICustomApplicantOnlinePayment)
[8430]144    grok.require('waeup.payApplicant')
[8256]145    icon = 'actionicon_pay.png'
146    text = _('CollegePAY')
147    target = 'goto_interswitch'
148
149    @property
150    def target_url(self):
151        if self.context.p_state != 'unpaid':
152            return ''
153        return self.view.url(self.view.context, self.target)
154
155# Deprecated
[8259]156#class InterswitchRequestCallbackActionButtonStudent(RCABStudent):
157#    grok.order(3)
158#    grok.context(ICustomStudentOnlinePayment)
159#    icon = 'actionicon_call.png'
160#    text = _('Request CollegePAY callback')
[7894]161
[8259]162#    def target_url(self):
163#        if self.context.p_state == 'paid':
164#            return ''
165#        site_redirect_url = self.view.url(self.view.context, 'isw_callback')
166#        args = {
167#            'transRef':self.context.p_id,
168#            'prodID':PRODUCT_ID,
169#            'redirectURL':site_redirect_url}
170#        return QUERY_URL + '?%s' % urllib.urlencode(args)
[7894]171
[7919]172# Alternative preferred solution
[8421]173class InterswitchRequestWebserviceActionButtonStudent(APABStudent):
[8259]174    grok.order(2)
[8255]175    grok.context(ICustomStudentOnlinePayment)
[8430]176    grok.require('waeup.payStudent')
[7919]177    icon = 'actionicon_call.png'
[8421]178    text = _('Requery CollegePAY')
[7919]179    target = 'request_webservice'
180
[8421]181class InterswitchRequestWebserviceActionButtonApplicant(APABApplicant):
[8259]182    grok.order(2)
[8256]183    grok.context(ICustomApplicantOnlinePayment)
[8430]184    grok.require('waeup.payApplicant')
[8256]185    icon = 'actionicon_call.png'
[8421]186    text = _('Requery CollegePAY')
[8256]187    target = 'request_webservice'
[7919]188
[8256]189
190class InterswitchPageStudent(KofaPage):
[7894]191    """ View which sends a POST request to the Interswitch
192    CollegePAY payment gateway.
193    """
[8255]194    grok.context(ICustomStudentOnlinePayment)
[7894]195    grok.name('goto_interswitch')
[8256]196    grok.template('student_goto_interswitch')
[7894]197    grok.require('waeup.payStudent')
198    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
199    submit_button = _('Submit')
200    action = POST_ACTION
201    site_name = SITE_NAME
202    currency = CURRENCY
203    product_id = PRODUCT_ID
204
205    def update(self):
[8256]206        #if self.context.p_state != 'unpaid':
207        if self.context.p_state == 'paid':
[7894]208            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
209            self.redirect(self.url(self.context, '@@index'))
210            return
[8256]211
[8741]212        student = self.student = self.context.student
213        certificate = getattr(student['studycourse'],'certificate',None)
[8276]214        self.amount_auth = 100 * self.context.amount_auth
[7894]215        xmldict = {}
216        if certificate is not None:
217            xmldict['department'] = certificate.__parent__.__parent__.code
218            xmldict['faculty'] = certificate.__parent__.__parent__.__parent__.code
219        else:
220            xmldict['department'] = None
221            xmldict['faculty'] = None
[9407]222        self.category = getUtility(IKofaUtils).PAYMENT_CATEGORIES[self.context.p_category]
[8281]223        tz = getUtility(IKofaUtils).tzinfo
224        self.local_date_time = to_timezone(
225            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
[8256]226        self.site_redirect_url = self.url(self.context, 'request_webservice')
[8263]227        # Provider data
228        xmldict['detail_ref'] = self.context.p_id
229        xmldict['provider_acct'] = PROVIDER_ACCT
230        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
231        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
232        # Institution data
[9385]233        xmldict['institution_acct'] = '000000000000'
234        xmldict['institution_bank_id'] = '00'
[9384]235        xmldict['institution_amt'] = '0.0'
236        if self.context.p_category == 'schoolfee':
[9460]237            provider_amt = 1500
[9384]238            if student.current_mode.endswith('_ft'):
[9389]239                self.pay_item_id = '5700'
[9460]240                if student.current_mode in ('ug_ft','de_ft','ct_ft','ume_ft'):
241                    xmldict['institution_acct'] = '2017506430'
242                    xmldict['institution_bank_id'] = '8'
243                elif student.current_mode in ('dp_ft'):
244                    xmldict['institution_acct'] = '9201805071'
245                    xmldict['institution_bank_id'] = '17'
246                elif student.current_mode in ('pg_ft'):
247                    xmldict['institution_acct'] = '5330832799'
[9384]248                    xmldict['institution_bank_id'] = '51'
249            elif student.current_mode.endswith('_pt'):
[9389]250                self.pay_item_id = '5701'
[9460]251                if student.current_mode in ('ug_pt','de_pt','ct_pt'):
252                    xmldict['institution_acct'] = '0122009929'
[9384]253                    xmldict['institution_bank_id'] = '16'
[9460]254                elif student.current_mode in ('dp_pt'):
255                    xmldict['institution_acct'] = '9201805071'
256                    xmldict['institution_bank_id'] = '17'
257                elif student.current_mode in ('pg_pt'):
258                    xmldict['institution_acct'] = '0031716047'
259                    xmldict['institution_bank_id'] = '10'
[9384]260        elif self.context.p_category == 'clearance':
[9389]261            self.pay_item_id = '5702'
[9384]262            provider_amt = 1500
263            xmldict['institution_bank_id'] = '7'
264            xmldict['institution_acct'] = '1003475516'
265
266        xmldict['provider_amt'] = 100 * provider_amt
267        xmldict['institution_item_name'] = self.category
[8263]268        xmldict['institution_name'] = INSTITUTION_NAME
[9384]269        xmldict['institution_amt'] = 100 * (
270            self.context.amount_auth - provider_amt - 150)
[8263]271        # Interswitch amount is not part of the xml data
272        xmltext = """<payment_item_detail>
273<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s" department="%(department)s" faculty="%(faculty)s">
274<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" />
275<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" />
276</item_details>
277</payment_item_detail>""" % xmldict
278        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
[7894]279        return
280
[8263]281class InterswitchPageApplicant(KofaPage):
[8256]282    """ View which sends a POST request to the Interswitch
283    CollegePAY payment gateway.
284    """
285    grok.context(ICustomApplicantOnlinePayment)
286    grok.require('waeup.payApplicant')
287    grok.template('applicant_goto_interswitch')
[8263]288    grok.name('goto_interswitch')
289    label = _('Submit data to CollegePAY (Interswitch Payment Gateway)')
290    submit_button = _('Submit')
291    action = POST_ACTION
292    site_name = SITE_NAME
293    currency = CURRENCY
[8274]294    pay_item_id = '5703'
[8263]295    product_id = PRODUCT_ID
[8256]296
297    def update(self):
[8263]298        if self.context.p_state != 'unpaid':
299            self.flash(_("Payment ticket can't be re-send to CollegePAY."))
300            self.redirect(self.url(self.context, '@@index'))
301            return
[8829]302        if self.context.__parent__.__parent__.expired \
303            and self.context.__parent__.__parent__.strict_deadline:
[8694]304            self.flash(_("Payment ticket can't be send to CollegePAY. "
305                         "Application period has expired."))
306            self.redirect(self.url(self.context, '@@index'))
307            return
[8256]308        self.applicant = self.context.__parent__
[8276]309        self.amount_auth = 100 * self.context.amount_auth
[8256]310        xmldict = {}
[9407]311        self.category = getUtility(IKofaUtils).PAYMENT_CATEGORIES[self.context.p_category]
[8281]312        tz = getUtility(IKofaUtils).tzinfo
313        self.local_date_time = to_timezone(
314            self.context.creation_date, tz).strftime("%Y-%m-%d %H:%M:%S %Z")
[8256]315        self.site_redirect_url = self.url(self.context, 'request_webservice')
[8545]316        if self.applicant.applicant_id.startswith('pg'):
317            provider_amt = 400
[8568]318            xmldict['institution_acct'] = '0031716030'
319            xmldict['institution_bank_id'] = '10'
[8545]320        else:
321            provider_amt = 250
[8568]322            xmldict['institution_acct'] = '6220032503'
323            xmldict['institution_bank_id'] = '51'
[8263]324        xmldict['detail_ref'] = self.context.p_id
[8545]325        xmldict['provider_amt'] = 100 * provider_amt
[8263]326        xmldict['provider_acct'] = PROVIDER_ACCT
327        xmldict['provider_bank_id'] = PROVIDER_BANK_ID
328        xmldict['provider_item_name'] = PROVIDER_ITEM_NAME
[8545]329        xmldict['institution_amt'] = 100 * (self.context.amount_auth - provider_amt - 150)
[8263]330        xmldict['institution_item_name'] = self.context.p_category
331        xmldict['institution_name'] = INSTITUTION_NAME
332        # Interswitch amount is not part of the xml data
333        xmltext = """<payment_item_detail>
334<item_details detail_ref="%(detail_ref)s" college="%(institution_name)s">
335<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" />
336<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" />
337</item_details>
338</payment_item_detail>""" % xmldict
339        self.xml_data = """<input type="hidden" name="xml_data" value='%s'  />""" % xmltext
[8256]340        return
341
342# Deprecated
[8263]343#class InterswitchPaymentCallbackPageStudent(UtilityView, grok.View):
344#    """ Callback view for the CollegePAY gateway
345#    """
346#    grok.context(ICustomStudentOnlinePayment)
347#    grok.name('isw_callback')
348#    grok.require('waeup.payStudent')
[7894]349
350    # This view is not yet working for offline querying transactions
351    # since the query string differs from the query string sent after
352    # posting transactions. This Interswitch bug must be removed first.
353    # Alternatively, we could use the webservice only and replace
354    # the RequestCallbackActionButton by a RequestWebserviceActionButton
355
[8263]356#    def update(self):
357#        if self.context.p_state == 'paid':
358#            self.flash(_('This ticket has already been paid.'))
359#            return
[8741]360#        student = self.context.student
[8263]361#        query = self.request.form
362#        write_log_message(self,'callback received: %s' % query)
363#        self.context.r_card_num = query.get('cardNum', None)
364#        self.context.r_code = query.get('resp', None)
365#        self.context.r_pay_reference  = query.get('payRef', None)
366#        self.context.r_amount_approved = float(query.get('apprAmt', '0.0')) / 100
367#        self.context.r_desc = query.get('desc', None)
368#        if self.context.r_code != '00':
369#            self.flash(_('Unsuccessful callback: ${a}',
370#                mapping = {'a': query.get('desc', _('Incomplete query string.'))}))
371#            write_log_message(self,'unsuccessful callback: %s' % self.context.p_id)
372#            self.context.p_state = 'failed'
373#            return
374#        if self.context.r_amount_approved != payment.amount_auth:
375#            self.flash(_('Wrong amount'))
376#            write_log_message(
377#                self,'successful but wrong amount: %s' % self.context.p_id)
378#            self.context.p_state = 'failed'
379#            return
380#        try:
381#            validation_list = get_SOAP_response(
382#                PRODUCT_ID, self.context.p_id).split(':')
[7934]383            # Validation does not make sense yet since the query string
[7970]384            # formats are conflicting. We are only printing the validation
385            # string, nothing else.
[8263]386#            print 'WARNING: Webservice validation is not yet implemented'
387#            print 'validation list: %s' % validation_list
388#        except:
389#            print 'Connection to webservice failed.'
[7970]390        # Add webservice validation here
[8263]391#        write_log_message(self,'valid callback: %s' % self.context.p_id)
392#        self.context.p_state = 'paid'
[8433]393#        self.context.payment_date = datetime.utcnow()
[8263]394#        actions_after_student_payment(student, self.context, self)
395#        return
[7970]396
[8263]397#    def render(self):
398#        self.redirect(self.url(self.context, '@@index'))
399#        return
[7894]400
[8256]401# Alternative solution, replaces InterswitchPaymentCallbackPage
402class InterswitchPaymentRequestWebservicePageStudent(UtilityView, grok.View):
[7919]403    """ Request webservice view for the CollegePAY gateway
404    """
[8255]405    grok.context(ICustomStudentOnlinePayment)
[7919]406    grok.name('request_webservice')
407    grok.require('waeup.payStudent')
408
409    def update(self):
[8430]410        ob_class = self.__implemented__.__name__
[7919]411        if self.context.p_state == 'paid':
412            self.flash(_('This ticket has already been paid.'))
413            return
[8741]414        student = self.context.student
[8430]415        success, msg, log = query_interswitch(self.context)
[8741]416        student.writeLogMessage(self, log)
[8430]417        if not success:
418            self.flash(msg)
419            return
420        success, msg, log = self.context.doAfterStudentPayment()
421        if log is not None:
[8741]422            student.writeLogMessage(self, log)
[8430]423        self.flash(msg)
[8256]424        return
[7919]425
[8256]426    def render(self):
427        self.redirect(self.url(self.context, '@@index'))
428        return
[7926]429
[8256]430class InterswitchPaymentRequestWebservicePageApplicant(UtilityView, grok.View):
431    """ Request webservice view for the CollegePAY gateway
432    """
433    grok.context(ICustomApplicantOnlinePayment)
434    grok.name('request_webservice')
435    grok.require('waeup.payApplicant')
[7919]436
[8256]437    def update(self):
438        if self.context.p_state == 'paid':
439            self.flash(_('This ticket has already been paid.'))
[7919]440            return
[8256]441        applicant = self.context.__parent__
[8430]442        success, msg, log = query_interswitch(self.context)
[8743]443        applicant.writeLogMessage(self, log)
[8430]444        if not success:
445            self.flash(msg)
446            return
447        success, msg, log = self.context.doAfterApplicantPayment()
448        if log is not None:
[8743]449            applicant.writeLogMessage(self, log)
[8430]450        self.flash(msg)
[7919]451        return
452
453    def render(self):
454        self.redirect(self.url(self.context, '@@index'))
[9081]455        return
Note: See TracBrowser for help on using the repository browser.