## Script (Python) "search_pins"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=
##title=
##
# $Id: ti_188_resolve.py 1680 2007-04-11 13:49:34Z joachim $
"""
resolve ticket #188
"""

request = context.REQUEST
session = request.SESSION
response = request.RESPONSE
setheader = request.RESPONSE.setHeader

def getObject(outer,object):
    if outer and outer.hasObject(object):
        return getattr(outer,object)
    return None

def rwrite(s):
    response.setHeader('Content-type','text/html; charset=ISO-8859-15')
    response.write("%s<br>\n\r" % s)

wftool = context.portal_workflow
mtool = context.portal_membership
member = mtool.getAuthenticatedMember()
roles = member.getRolesInContext(context)
retcat = context.returning_import
rcat = context.results_import
scat = context.students_catalog
from Products.AdvancedQuery import Eq, Between, Le,In
aq_students = context.students_catalog.evalAdvancedQuery
students = context.portal_url.getPortalObject().campus.students


if str(member) not in ('admin','joachim'):
    return
count = 0
ok_count = 0
nyl_count = 0
wrong_count = 0
cr_count = 0
res = scat()
for sbrain in res:
    if str(sbrain.level) == '100':
        ec = "new"
    else:
        ec = "nor"
    erg = context.results_import(matric_no=sbrain.matric_no)
    if erg and erg[0].Level:
        level_res = erg[0].Level
        everdict = erg[0].Verdict
        level_cc = context.getLevelFromResultsCosCode(erg)
        #if level_cc == 0:
            #lc = "-"
        lc = "%s00" % level_cc
        verdict,elegible = context.getVerdict(everdict)
        if elegible:
            continue
        dict = context.getFormattedStudentEntry(sbrain)
        dict['level_res'] = lc 
        count += 1
        dict['count'] = count
        code = 'xxx'
        comment = ""
        if sbrain.level == '':
            code = 'nyl'
            nyl_count += 1
        elif sbrain.level != lc:
            code = 'nok'
            wrong_count += 1
            student = getObject(students,sbrain.id)
            study_course = getObject(student,'study_course')
            level = getObject(study_course,sbrain.level)
            if level is not None:
                code = 'nok_cr'
                cr_count += 1
                comment = "%(level)s deleted" % dict 
                ##study_course.manage_delObjects((sbrain.level,))
            comment = comment + " level in students_catalog modified to %s" % lc
            ##context.students_catalog.modifyRecord(id = sbrain.id,level=lc,)
        else:
            ok_count += 1
            code = 'ok'
        dict['nyl_count'] = nyl_count
        dict['ok_count'] = ok_count
        dict['cr_count'] = cr_count
        dict['wrong_count'] = wrong_count
        dict['code'] = code
        dict['comment'] = comment
        rwrite('"%(count)d:%(ok_count)d:%(nyl_count)d:%(wrong_count)d:%(cr_count)d","%(code)s","%(id)s","%(name)s","%(level)s","%(level_res)s","%(comment)s"' % dict)

rwrite("total: %(count)d<br> correct: %(ok_count)d<br> level == '': %(nyl_count)d<br> wrong: %(wrong_count)d<br> level created: %(cr_count)d" % dict )