## Script (Python) "getSchoolFeePrefix"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=
##title=
##
# $Id:getMaintenancePrefix.py 486 2006-09-06 10:09:39Z joachim $
"""
return the Prefix for Schoolfee
"""

if context.portal_membership.isAnonymousUser():
    return None

try:
    from Products.zdb import set_trace
except:
    def set_trace():
        pass
import logging
logger = logging.getLogger('Skins.getSchoolFeePrefix')

student_id = context.getStudentId()
student_record = context.students_catalog(id=student_id)[0]
res = context.portal_catalog(portal_type="Certificate",
                                     id = student_record.course)


if not res:
    logger.info('%s, certificate %s not found' % (student_id,course))
    prefix = "--"
else:
    prefix = res[0].getObject().getContent().school_fee_code
    if not prefix or prefix == 'none':
        prefix = res[0].getPath().split('/')[-4]
    if student_record.review_state == 'cleared_and_validated':
        prefix = prefix + 'NEW'
return prefix