## Script (Python) "search_pins"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=REQUEST
##title=
##
# $Id: removeResults.py 1216 2007-01-06 17:40:50Z joachim $
"""
list Students for ClearanceOfficers
"""

request = REQUEST
response = request.RESPONSE

def rwrite(s):
    response.setHeader('Content-type','text/html; charset=ISO-8859-15')
    #response.setHeader('Content-length','%d' % (len(s)))
    #response.setStatus('OK')
    response.write(s)

wftool = context.portal_workflow
mtool = context.portal_membership
member = mtool.getAuthenticatedMember()
roles = member.getRolesInContext(context)
rcat = context.results_import
scat = context.students_catalog
#from Products.zdb import set_trace;set_trace()
if str(member) not in ('admin','joachim'):
    return
rwrite("start <br />")
for m in rcat.uniqueValuesFor('matric_no'):
    #if m.startswith('ART'):
    res_r = rcat(matric_no = m)
    res_s = scat(matric_no = m)
    if res_s and res_s[0].course == 'BARTTHR' and res_s[0].level =="500":
        to_del = []
        for r in res_r:
            to_del.append(r.key)
            
        #zum Testen auskommentiert    
        #for uid in to_del:
            #rcat.deleteRecord(uid)
            
        rwrite(m+" "+res_s[0].course+" "+res_s[0].level + " " + str(len(to_del)) +"<br />")
rwrite("<br />\n Done" )