source: WAeUP_SRP/trunk/skins/waeup_student/create_level.py @ 4008

Last change on this file since 4008 was 3650, checked in by Henrik Bettermann, 16 years ago

catch missing passmark in course
  • Property svn:keywords set to Id
File size: 7.3 KB
Line 
1##parameters=
2# $Id: create_level.py 3650 2008-08-29 06:17:34Z henrik $
3"""
4process the Application Form
5return html renderer + psm
6"""
7request = context.REQUEST
8import DateTime,logging
9try:
10    from Products.zdb import set_trace
11except:
12    def set_trace():
13        pass
14from Products.AdvancedQuery import Eq, Between, Le,In
15try:
16    aq_portal = context.portal_catalog.evalAdvancedQuery
17except:
18    aq_portal = context.portal_catalog_real.evalAdvancedQuery
19aq_courses = context.courses_catalog.evalAdvancedQuery
20aq_results = context.course_results.evalAdvancedQuery
21
22current = DateTime.DateTime()
23request = context.REQUEST
24response = request.RESPONSE
25redirect = response.redirect
26logger = logging.getLogger('Skins.create_level')
27# mtool = context.portal_membership
28# member = mtool.getAuthenticatedMember()
29# member_id = str(member)
30# requested_id = context.getStudentId()
31# #set_trace()
32# create_level =  request.form.get('create_level',None)
33# if not create_level or not requested_id or\
34#    (not context.isStaff() and member_id != requested_id):
35#     logger.info('%s tried to access %s' % (member_id,requested_id))
36#     return redirect("%s/srp_anonymous_view" % context.portal_url())
37# student_id = context.getStudentId()
38info = context.waeup_tool.getAccessInfo(context)
39student_id = info['student_id']
40if student_id is None:
41    return None
42
43#lt = context.portal_layouts
44#wt = context.waeup_tool
45student = context.students_catalog.getRecordByKey(student_id)
46cert_id = student.course
47current_level = student.level
48current_session = student.session
49in_progress =  request.get('in_progress','not started')
50if aq_results(Eq('student_id',student_id) & Eq('level_id',current_level)):
51    logger.info('%s tried to create already existing level %s' % (student.id,current_level))
52    return
53
54logger.info('%s started to create level %s' % (student.id,current_level))
55
56if context.hasObject(current_level):
57    #level = getattr(context,"%s" % current_level)
58    return response.redirect("%s/%s" % (context.absolute_url(),current_level))
59else:
60    context.invokeFactory('StudentStudyLevel',"%s" % current_level)
61    level = getattr(context,"%s" % current_level)
62    context.portal_workflow.doActionFor(level,'open')
63    level.getContent().edit(mapping={'session': current_session})
64    #context.portal_workflow.doActionFor(level,'close_for_edit')
65level_id = level.getId()
66session_id = context.getLevelSession(level.getContent(),student_id,level_id)
67results = []
68records = []
69if student.matric_no:
70    results = context.results_import(matric_no = student.matric_no)
71l = []
72
73#level_nr,dummy = divmod(int(current_level),100)
74# fetch session courses from the certificate
75res = context.portal_catalog(portal_type="Certificate", id = cert_id)
76if res:
77    cert = res[0]
78    path = cert.getPath()
79    #academics_level = 100 * level_nr
80    if int(current_level) > 0:
81        academics_level = 100 * (int(current_level)/100)
82    else:
83        academics_level = '000'
84    query = Eq("path","%s/%s" % (path,academics_level)) &\
85            Eq('portal_type','CertificateCourse')
86    courses = aq_portal(query)
87    for c in courses:
88        course_id = "%s" % c.getId
89        if course_id in l:
90            # don't add twice
91            continue
92        l += course_id,
93        d = context.getCourseInfo(c.getId)
94        d['carry_over'] = False
95        d['core_or_elective'] = getattr(c.getObject().getContent(),'core_or_elective')
96        d['course_id'] = course_id
97        d['student_id'] = student_id = context.getStudentId()
98        d['level_id'] = level_id
99        d['session_id'] = session_id
100        records.append(d)
101# fetch carry_over courses from results_import
102if student.session in ('6', '06') and results:
103    carry_overs = results
104    for co in carry_overs:
105        course_id = co.CosCode
106        if course_id in l:
107            # don't add twice
108            continue
109        # if level.hasObject(course_id):    #already created
110        #     continue
111        carry_over = False
112        query = Eq('code',co.CosCode)
113        c_res = aq_courses(query)
114        if not c_res:
115            #logger.info('%s", course %s not found in courses_catalog' % (student.id,co.CosCode))
116            continue
117        course_cat_entry = c_res[0]
118        passmark = getattr(course_cat_entry,'passmark',None)
119        if not passmark or not co.Score:
120            carry_over = co.GRADE in ('D','E','F')
121        else:
122            try:
123                score = int(co.Score)
124            except:
125                # logger.info('%s, course %s has invalid score %s"' % (student.id,
126                #                                                     course_id,
127                #                                                     co.Score))
128                continue
129            if int(c_res[0].passmark) <= score:
130                continue
131            carry_over = True
132        if not carry_over:
133            continue
134        l += course_id,
135        d = context.getCourseInfo(co.CosCode)
136        d['course_id'] = course_id
137        d['carry_over'] = carry_over
138        d['code'] = course_id
139        d['student_id'] = student_id
140        d['level_id'] = level_id
141        d['session_id'] = session_id
142        records.append(d)
143# fetch carry_over courses from the course_results catalog
144else:
145    res = aq_results(Eq('student_id',student_id),
146                             sortSpecs=('level_id',))
147    for result in res:
148        course_id = result.code
149        if course_id in l:
150            continue
151        query = Eq('code',course_id)
152        c_res = aq_courses(query)
153        if not c_res:
154            #logger.info('%s", course %s not found in courses_catalog' % (student.id,result.CosCode))
155            continue
156        course_cat_entry = c_res[0]
157        #passmark = getattr(course_cat_entry,'passmark',None)
158        try:
159            score = int(result.score)
160        except:
161            #logger.info('%s, course_result %s has invalid score"' % (student.id,
162            #                                                     course_id,
163            #                                                     result.score))
164            continue
165        try:
166            passmark = int(c_res[0].passmark)
167        except:
168            logger.info('%s, course %s has invalid passmark %s"' % (student.id,
169                                                                 course_id,
170                                                                 c_res[0].passmark))
171            continue           
172        if int(c_res[0].passmark) <= score:
173            continue
174        l += course_id,
175        d = context.getCourseInfo(course_id)
176        d['course_id'] = course_id
177        d['carry_over'] = True
178        d['code'] = course_id
179        d['student_id'] = student_id
180        d['level_id'] = level_id
181        d['session_id'] = session_id
182        records.append(d)
183
184if records:
185    existing_uids = context.course_results.addMultipleRecords(records)
186    if existing_uids:
187        logger.info('%s level %s %s existing keys' % (student.id,
188                                                      current_level,
189                                                     ",".join(existing_uids)))
190
191logger.info('%s finished to create level %s' % (student.id,current_level))
192
193return response.redirect("%s/%s" % (context.absolute_url(),current_level))
Note: See TracBrowser for help on using the repository browser.