## 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)

res_to_del = ('ART0206832', 
    'ART0206156',
    'ART0206812',
    'ART0206841',
    'ART0206813',
    'ART0206816',
    'ART0206614',
    'ART0206817',
    'ART0206830',
    'ART0205970',
    'ART0206158',
    'ART0206811',
    'ART0206815',
    'ART0301351',
    'ART0301319',
    'ART0301310',
    'ART0308340',
    'ART0206157',
    'ART0206833',
    'ART0206831',
    'ART0206964',
    'ART0206838',
    'ART0206821',
    'ART0206844',
    'ART0206828',
    'ART0206820',
    'ART0206842',
    'ART0206834',
    'ART0206839',
    'ART0206819',
    'ART0206825',
    'ART0206818',
    'ART0206840',
    'ART0206836',
    'ART0206829')


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")
#for m in rcat.uniqueValuesFor('matric_no'):
for m in res_to_del:
    #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)
        rwrite(m+" "+r.Level +"  " + r.CosCode + "<br />")
    for uid in to_del:
        rcat.deleteRecord(uid)
rwrite("Done")