## Script (Python) "getPaymentsFolderInfo"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=
##title=
##
# $Id: getPaymentsFolderInfo.py 2480 2007-10-30 15:23:25Z joachim $
"""
Info for the PaymentsFolder
"""
from Products.AdvancedQuery import Eq, Between, Le,In

mtool = context.portal_membership
wftool = context.portal_workflow
member = mtool.getAuthenticatedMember()
payments_catalog = context.payments_catalog
aq_payments = payments_catalog.evalAdvancedQuery
if mtool.isAnonymousUser():
    return None
try:
    from Products.zdb import set_trace
except:
    def set_trace():
        pass


#import logging
#logger = logging.getLogger('Skins.getPaymentsFolderInfo')
def cmp_id(a,b):
    s1 = "%(id)s" % a
    s2 = "%(id)s" % b
    if s1 == s2:
        return 0
    if s1 > s2:
        return 1
    return -1

import DateTime
request = context.REQUEST
#students = context.portal_url.getPortalObject().campus.students
student_id = context.getStudentId()
if student_id is None:
    return context.REQUEST.RESPONSE.redirect("%s/srp_anonymous_view" % context.portal_url())
#student = getattr(students,student_id)
student_record = context.students_catalog.getRecordByKey(student_id)
#context['updatePayments']()

info = {}
is_so = info['is_so'] = context.isSectionOfficer()
is_student = info['is_student'] = context.isStudent()
info['student_name'] = student_record.name
info['query_url'] = "https://webpay.interswitchng.com/paydirect/services/TransactionQueryURL.aspx"
review_state = info['review_state'] = student_record.review_state
parttime = student_record.mode and student_record.mode.endswith('_pt')
fulltime = student_record.mode and student_record.mode.endswith('_ft')


session = student_record.session
next_info = context.getNextInfo(student_record)
info['next_session'] = next_info['next_session_id']
info['next_session_str'] = next_info['next_session_str']
info['payment_method'] = ""
info['reasons'] = next_info['reasons']

if review_state == 'cleared_and_validated':
    info['payment_method'] = "online_payment"


elif review_state == 'returning' and info['next_session'] != session:
    info['payment_method'] = "online_payment"
info['prod_id'] = '83'

info['student_name'] = student_record.name
payments_path = "%s/campus/students/%s/payments" % (context.portal_url(),student_id)
payments = []
payment_records = aq_payments(Eq('student_id',student_id) & Eq('session_id',student_record.session))
vocabularies = context.portal_vocabularies
paid_fees = []
for payment in payment_records:
    if payment.status == "paid":
        paid_fees += "%s_%s" % (payment.category,payment.session_id),
#info['pf'] = paid_fees
for payment in payment_records:
    row = {}
    row['id'] = payment.key
    row['title'] = "%s for Session %s, Naira %s, %s" % (vocabularies.payment_categories.get(payment.category),
                                                        vocabularies.sessions.get(payment.session_id),
                                                        payment.amount,
                                                        payment.date.strftime("%d/%m/%y %H:%M:%S"))
    url = row['url'] = "%s/p%s" % (payments_path,payment.order_id[6:])
    row['is_requeryable'] = "%s_%s" % (payment.category,payment.session_id) not in paid_fees or str(member) in ('admin',)
    row['is_approvable'] = is_so and row['is_requeryable']
    row['resp_desc'] = payment.resp_desc or 'Payment Process Interrupted'
    row['trans_ref'] = payment.order_id
    if row['is_requeryable']:
        row['callback_url'] = "%(url)s/interswitch_cb" % row
        href = '%(query_url)s' % info
        href += '?transRef=%(trans_ref)s' % row
        href += '&prodID=%(prod_id)s' % info
        href += '&redirectURL=%(callback_url)s' % row
        row['href'] = href
    if payment.status == 'paid':
        row['confirmed'] = 'active'
    else:
        row['confirmed'] = 'unsuccessful'
    row['is_editable'] = is_so and (row['confirmed'] == 'active')
    payments.append(row)
# for payment_id,payment in context.objectItems():
#     row = {}
#     row['id'] = payment_id
#     row['title'] = payment.Title()
#     url = row['url'] = payment.absolute_url()
#     payment_doc = payment.getContent()
#     row['type'] = payment_doc.portal_type
#     review_state = row['review_state'] = wftool.getInfoFor(payment,'review_state',None)
#     if payment_doc.type_description.startswith('School Fee'):
#         row['is_approvable'] = is_so and (review_state == "opened") and info['review_state'] == 'cleared_and_validated'
#     else:
#         row['is_approvable'] = is_so and (review_state == "opened")
#     row['is_requeryable'] = False
#     #set_trace()
#     row['resp_desc'] = getattr(payment_doc,'resp_desc','no response')
#     row['trans_ref'] = getattr(payment_doc,'order_id','')
#     if payment_doc.type_description.startswith('School Fee'):
#         if (review_state == 'opened' and info['review_state'] in ('cleared_and_validated',) and \
#             hasattr(payment_doc, 'order_id') and not payment_doc.resp_code) or str(member) in ('admin',):
#             row['is_requeryable'] = True
#             row['callback_url'] = "%(url)s/interswitch_cb" % row
#             href = '%(query_url)s' % info
#             href += '?transRef=%(trans_ref)s' % row
#             href += '&prodID=%(prod_id)s' % info
#             href += '&redirectURL=%(callback_url)s' % row
#             row['href'] = href
#     elif payment_doc.type_description.startswith('Hostel'):
#         if (review_state == 'opened' and \
#             hasattr(payment_doc, 'order_id') and not payment_doc.resp_code) or str(member) in ('admin','delejason','isouaba'):
#             row['is_requeryable'] = True
#             row['callback_url'] = "%(url)s/interswitch_acco_cb" % row
#             href = '%(query_url)s' % info
#             href += '?transRef=%(trans_ref)s' % row
#             href += '&prodID=%(prod_id)s' % info
#             href += '&redirectURL=%(callback_url)s' % row
#             row['href'] = href
#     if (review_state == "closed") and payment_doc.resp_code in ('SC','00','AP','IP',):
#         row['confirmed'] = 'active'
#     else:
#         row['confirmed'] = 'unsuccessful'
#     row['is_editable'] = is_so and (row['confirmed'] == 'active')
#     payments.append(row)
# payments_path = "%s/campus/students/%s/payments" % (context.portal_url.getPortalPath(),student_id)
# sos = context.portal_catalog(container_path=payments_path)
# info['is_so'] = is_so

# for so in sos:
#     row = {}
#     row['id'] = so.getId
#     row['title'] = so.Title
#     url = row['url'] = "%s/%s" % (payments_path,so.getId)
#     so_doc = context.restrictedTraverse(url,default=None).getContent()
#     row['type'] = so.portal_type
#     review_state = row['review_state'] = so.review_state
#     if so_doc.type_description.startswith('School Fee'):
#         row['is_approvable'] = is_so and (review_state == "opened") and info['review_state'] in ('cleared_and_validated','returning')
#     else:
#         row['is_approvable'] = False    # is_so and (review_state == "opened")
#     row['is_requeryable'] = False
#     #set_trace()
#     row['resp_desc'] = getattr(so_doc,'resp_desc','no response')
#     row['trans_ref'] = getattr(so_doc,'order_id','')
#     if so_doc.type_description.startswith('School Fee'):
#         if (review_state == 'opened' and info['review_state'] in ('cleared_and_validated','returning') and \
#                                   hasattr(so_doc, 'order_id') and not so_doc.resp_code) or str(member) in ('admin','delejason','isouaba'):
#             row['is_requeryable'] = True
#             row['callback_url'] = "%s/payments/%s/interswitch_cb" % (student.absolute_url(),
#                                                             so.getId)
#             href = '%(query_url)s' % info
#             href += '?transRef=%(trans_ref)s' % row
#             href += '&prodID=%(prod_id)s' % info
#             href += '&redirectURL=%(callback_url)s' % row
#             row['href'] = href
#     elif so_doc.type_description.startswith('Hostel'):
#         if (review_state == 'opened' and \
#                                   hasattr(so_doc, 'order_id') and not so_doc.resp_code) or str(member) in ('admin','delejason','isouaba'):
#             row['is_requeryable'] = True
#             row['callback_url'] = "%s/payments/%s/interswitch_acco_cb" % (student.absolute_url(),
#                                                             so.getId)
#             href = '%(query_url)s' % info
#             href += '?transRef=%(trans_ref)s' % row
#             href += '&prodID=%(prod_id)s' % info
#             href += '&redirectURL=%(callback_url)s' % row
#             row['href'] = href
#     if (review_state == "closed") and so_doc.resp_code in ('SC','00','AP','IP',):
#         row['confirmed'] = 'active'
#     else:
#         row['confirmed'] = 'unsuccessful'
#     row['is_editable'] = is_so and (row['confirmed'] == 'active')
#     payments.append(row)

payments.sort(cmp_id)
info['payments'] = payments
return info