| 1 | ## Script (Python) "search_pins" |
|---|
| 2 | ##bind container=container |
|---|
| 3 | ##bind context=context |
|---|
| 4 | ##bind namespace= |
|---|
| 5 | ##bind script=script |
|---|
| 6 | ##bind subpath=traverse_subpath |
|---|
| 7 | ##parameters= |
|---|
| 8 | ##title= |
|---|
| 9 | ## |
|---|
| 10 | # $Id: fixLevelFromResults.py 1409 2007-02-12 08:50:49Z henrik $ |
|---|
| 11 | """ |
|---|
| 12 | list Students for ClearanceOfficers |
|---|
| 13 | """ |
|---|
| 14 | |
|---|
| 15 | request = context.REQUEST |
|---|
| 16 | session = request.SESSION |
|---|
| 17 | response = request.RESPONSE |
|---|
| 18 | setheader = request.RESPONSE.setHeader |
|---|
| 19 | |
|---|
| 20 | def rwrite(s): |
|---|
| 21 | response.setHeader('Content-type','text/html; charset=ISO-8859-15') |
|---|
| 22 | response.write(s) |
|---|
| 23 | |
|---|
| 24 | wftool = context.portal_workflow |
|---|
| 25 | mtool = context.portal_membership |
|---|
| 26 | member = mtool.getAuthenticatedMember() |
|---|
| 27 | roles = member.getRolesInContext(context) |
|---|
| 28 | retcat = context.returning_import |
|---|
| 29 | rcat = context.results_import |
|---|
| 30 | scat = context.students_catalog |
|---|
| 31 | from Products.AdvancedQuery import Eq, Between, Le,In |
|---|
| 32 | aq_students = context.students_catalog.evalAdvancedQuery |
|---|
| 33 | students = context.portal_url.getPortalObject().campus.students |
|---|
| 34 | |
|---|
| 35 | |
|---|
| 36 | if str(member) not in ('admin','joachim'): |
|---|
| 37 | return |
|---|
| 38 | count = 0 |
|---|
| 39 | line_count = 0 |
|---|
| 40 | lines = [] |
|---|
| 41 | #from Products.zdb import set_trace;set_trace() |
|---|
| 42 | res = scat() |
|---|
| 43 | for sbrain in res: |
|---|
| 44 | if str(sbrain.level) == '100': |
|---|
| 45 | ec = "new" |
|---|
| 46 | else: |
|---|
| 47 | ec = "nor" |
|---|
| 48 | erg = context.results_import(matric_no=sbrain.matric_no) |
|---|
| 49 | if erg and erg[0].Level: |
|---|
| 50 | #lc = "N" |
|---|
| 51 | level_res = erg[0].Level |
|---|
| 52 | everdict = erg[0].Verdict |
|---|
| 53 | level_cc = context.getLevelFromResultsCosCode(erg) |
|---|
| 54 | #if level_cc == 0: |
|---|
| 55 | #lc = "-" |
|---|
| 56 | #if "%d00" % level_cc != level_res: |
|---|
| 57 | lc = 100*level_cc - int(level_res) |
|---|
| 58 | verdict,elegible = context.getVerdict(everdict) |
|---|
| 59 | if elegible: |
|---|
| 60 | #lc = "S" |
|---|
| 61 | level = "%d00" % (level_cc + 1) |
|---|
| 62 | #context.students_catalog.modifyRecord(id = sbrain.id, |
|---|
| 63 | # level="", |
|---|
| 64 | # verdict = "") |
|---|
| 65 | while True: |
|---|
| 66 | student = getattr(students,sbrain.id,None) |
|---|
| 67 | ec = "nos" |
|---|
| 68 | if student is None: |
|---|
| 69 | break |
|---|
| 70 | ec = "nyr" |
|---|
| 71 | study_course = getattr(student,"study_course", None) |
|---|
| 72 | if study_course is None: |
|---|
| 73 | break |
|---|
| 74 | #study_course.getContent().edit(mapping = {'current_level':level, |
|---|
| 75 | # 'current_verdict':verdict}) |
|---|
| 76 | #context.students_catalog.modifyRecord(id = sbrain.id, |
|---|
| 77 | # level=level, |
|---|
| 78 | # verdict=verdict) |
|---|
| 79 | ec = "reg" |
|---|
| 80 | break |
|---|
| 81 | |
|---|
| 82 | #rwrite(ec +"--"+ sbrain.id +"--"+ sbrain.matric_no +"--"+ old_level +"--"+ level +"<br />") |
|---|
| 83 | s = '"%s","%s","%s","%s","%s","%s","%s","%s"' % (str(lc),ec, |
|---|
| 84 | sbrain.id, |
|---|
| 85 | sbrain.matric_no, |
|---|
| 86 | level_res, |
|---|
| 87 | level_cc, |
|---|
| 88 | everdict, |
|---|
| 89 | verdict) |
|---|
| 90 | #lines.append(s) |
|---|
| 91 | else: |
|---|
| 92 | #rwrite(ec +"--"+ sbrain.id +"--"+ sbrain.matric_no + "<br />") |
|---|
| 93 | s = '"","%s","%s","%s","",""' % (ec,sbrain.id,sbrain.matric_no) |
|---|
| 94 | #lines.append(s) |
|---|
| 95 | |
|---|
| 96 | rwrite("%s<br />" %s) |
|---|
| 97 | # count += 1 |
|---|
| 98 | # if count > 60: |
|---|
| 99 | # line_count += 1 |
|---|
| 100 | # rwrite("<br />\n%3d " % line_count) |
|---|
| 101 | # count = 0 |
|---|
| 102 | |
|---|
| 103 | rwrite("<br />\n Done" ) |
|---|
| 104 | |
|---|
| 105 | ##setheader('Content-type','text/semicolon-seperated-values') |
|---|
| 106 | ##setheader('Content-Disposition:', 'attachment; filename="fixLevelExport.csv"') |
|---|
| 107 | ##setheader('Expires', 'Mon, 26 Jul 1997 05:00:00GMT') # Date in the past |
|---|
| 108 | ##setheader('Cache-Control', 'no-store, no-cache,must-revalidate') # HTTP/1.1 |
|---|
| 109 | ##setheader('Cache-Control', 'post-check=0,pre-check=0') |
|---|
| 110 | ##setheader('Pragma', 'no-cache') # HTTP/1.0 |
|---|
| 111 | ##return '\n'.join(lines) |
|---|
| 112 | |
|---|
