source: WAeUP_SRP/trunk/WAeUPTool.py @ 1251

Last change on this file since 1251 was 1250, checked in by joachim, 18 years ago

set the level from results, also getCredential return the student_pw, fixLevel fixes existing levels
  • Property svn:keywords set to Id
File size: 13.2 KB
Line 
1#-*- mode: python; mode: fold -*-
2# (C) Copyright 2005 The WAeUP group  <http://www.waeup.org>
3# Author: Joachim Schmitz (js@aixtraware.de)
4#
5# This program is free software; you can redistribute it and/or modify
6# it under the terms of the GNU General Public License version 2 as published
7# by the Free Software Foundation.
8#
9# This program is distributed in the hope that it will be useful,
10# but WITHOUT ANY WARRANTY; without even the implied warranty of
11# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12# GNU General Public License for more details.
13#
14# You should have received a copy of the GNU General Public License
15# along with this program; if not, write to the Free Software
16# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
17# 02111-1307, USA.
18#
19# $Id: WAeUPTool.py 1250 2007-01-09 17:19:20Z joachim $
20"""The WAeUP Tool Box.
21"""
22
23from AccessControl import ClassSecurityInfo
24from Acquisition import aq_inner
25from Acquisition import aq_parent
26from Globals import DTMLFile
27from Globals import InitializeClass
28from OFS.SimpleItem import SimpleItem
29
30from Products.CMFCore.ActionProviderBase import ActionProviderBase
31from Products.CMFCore.permissions import View
32from Products.ZCatalog.ZCatalog import ZCatalog
33from Products.CMFCore.permissions import ModifyPortalContent
34from Products.CMFCore.utils import UniqueObject
35from Products.CMFCore.URLTool import URLTool
36from Students import makeCertificateCode
37import logging
38import transaction
39
40
41
42
43class WAeUPTool(UniqueObject, SimpleItem, ActionProviderBase):
44    """WAeUP tool"""
45
46    id = 'waeup_tool'
47    meta_type = 'WAeUP Tool'
48    _actions = ()
49
50    security = ClassSecurityInfo()
51    security.declareObjectProtected(View)
52
53    manage_options = ( ActionProviderBase.manage_options
54                     + SimpleItem.manage_options
55                     )
56
57
58    def generateStudentId(self,letter): ###(
59        import random
60        r = random
61        ##if letter not in ('ABCDEFGIHKLMNOPQRSTUVWXY'):
62        if letter == '?':
63            letter= r.choice('ABCDEFGHKLMNPQRSTUVWXY')
64        sid = "%c%d" % (letter,r.randint(99999,1000000))
65##        students = self.portal_url.getPortalObject().campus.students
66##        while hasattr(students, sid):
67##            sid = "%c%d" % (letter,r.randint(99999,1000000))
68        while self.students_catalog(id = sid):
69            sid = "%c%d" % (letter,r.randint(99999,1000000))
70        return sid
71    ###)
72
73    security.declareProtected(ModifyPortalContent,'getCredential')
74    def getCredential(self,student_id):
75        "return a student password"
76        student_entry = getattr(self.portal_directories.students,student_id,None)
77        if student_entry is None:
78            return None
79        else:
80            return student_entry.password
81
82    security.declareProtected(ModifyPortalContent,'createOne') ###(
83    def createOne(self,students_folder,student_brain,letter,commit=False):
84        sid = self.waeup_tool.generateStudentId(letter)
85        students_folder.invokeFactory('Student', sid)
86        student = getattr(students_folder,sid)
87        self.portal_workflow.doActionFor(student,'return')
88        student.manage_setLocalRoles(sid, ['Owner',])
89        matric_no = student_brain.matric_no
90        jamb_reg_no = student_brain.Entryregno
91        self.students_catalog.addRecord(id = sid,
92                                           matric_no = matric_no,
93                                           jamb_reg_no = jamb_reg_no,
94                                           sex = student_brain.Sex == "F",
95                                           name = "%s %s %s" % (student_brain.Firstname,
96                                                                student_brain.Middlename,
97                                                                student_brain.Lastname)
98                                        )
99        if commit:
100            transaction.commit()
101        return sid,jamb_reg_no
102    ###)
103
104    security.declarePublic('getCertificateBrain') ###(
105    def getCertificateBrain(self,cert_id):
106        "do it"
107        res = ZCatalog.searchResults(self.portal_catalog,
108                                {'portal_type':"Certificate",
109                                      'id': cert_id})
110        if res:
111            return res[0]
112        return None
113    ###)
114
115    security.declarePublic('findStudentByMatricelNo') ###(
116    def findStudentByMatricelNo(self,matric_no):
117        "do it"
118        res = ZCatalog.searchResults(self.portal_catalog,
119                                {'portal_type':"StudentClearance",
120                                 'SearchableText': matric_no})
121        if res:
122            return res[0]
123        return None
124    ###)
125
126    security.declarePublic('makeStudentMember') ###(
127    def makeStudentMember(self,sid,password='uNsEt'):
128        """make the student a member"""
129        membership = self.portal_membership
130        membership.addMember(sid,
131                             password ,
132                             roles=('Member',
133                                     'Student',
134                                     ),
135                             domains='',
136                             properties = {'memberareaCreationFlag': False,
137                                           'homeless': True},)
138        member = membership.getMemberById(sid)
139        self.portal_registration.afterAdd(member, sid, password, None)
140        self.manage_setLocalRoles(sid, ['Owner',])
141    ###)
142
143    security.declarePublic('makeStudentData') ###(
144    def makeStudentData(self,student_id,email=None,phone_nr=None):
145        "create Datastructure for a returning Student"
146        #import pdb;pdb.set_trace()
147        logger = logging.getLogger('Student.CreateData')
148        students_folder = self.portal_url.getPortalObject().campus.students
149        res = self.students_catalog(id=student_id)
150        if res:
151            st = res[0]
152        res = self.returning_import(matric_no = st.matric_no)
153        if res:
154            student = res[0]
155        logger.info('"%s", "creating Datastructure"' % student_id)
156
157        #student should not be allowed to perform this transition
158        #wftool = self.portal_workflow
159        #wftool.doActionFor(student,'return')
160
161        certcode_org = student.Coursemajorcode
162        certcode = makeCertificateCode(certcode_org)
163        certificate_brain = self.getCertificateBrain(certcode)
164        if not certificate_brain:
165            em = 'Certificate %s org-code %s not found\n' % (certcode, certcode_org)
166            logger.info(em)
167        level = student.Level
168        validlevel = False
169        try:
170            int(level)
171            validlevel = True
172        except:
173            em = '"%(matric_no)s","invalid Level","%(Level)s"' % student
174            logger.info(em)
175        if not validlevel:
176            erg = self.results_import(matric_no = student.matric_no)
177            level = 'xxx'
178            if erg:
179                level = erg[0].Level
180            try:
181                int(level)
182                em = '"%s","fixed Level from results_import","%s"' % (student.matric_no,erg[0].Level)
183                logger.info(em)
184                validlevel = True
185            except:
186                em = '"%s","invalid Level in results_import","%s"' % (student.matric_no,erg[0].Level)
187                logger.info(em)
188        matric_no = student.matric_no
189        sid = student_id
190        student_obj = getattr(students_folder,sid)
191        student_obj.invokeFactory('StudentApplication','application')
192        application = student_obj.application
193        self.portal_workflow.doActionFor(application,'open',dest_container=application)
194        da = {'Title': 'Application Data'}
195        student_obj.invokeFactory('StudentPersonal','personal')
196        da['jamb_reg_no'] = student.Entryregno
197        da['entry_mode'] = student.Mode_of_Entry
198        personal = student_obj.personal
199        self.portal_workflow.doActionFor(personal,'open',dest_container=personal)
200        dp = {'Title': 'Personal Data'}
201        student_obj.invokeFactory('StudentClearance','clearance')
202        clearance = student_obj.clearance
203        self.portal_workflow.doActionFor(clearance,'open',dest_container=clearance)
204        dc = {'Title': 'Clearance/Eligibility Record'}
205        dc['matric_no'] = matric_no
206        state = student.State
207        lga = student.LGA
208        if state and lga:
209            lga =  state + ' / ' + lga
210        else:
211            lga = "None"
212        da['jamb_lga'] = dc['lga'] = lga
213        da['app_email'] = dp['email'] = email
214        da['app_mobile'] = dp['phone'] = phone_nr
215        da['jamb_firstname'] = dp['firstname'] = student.Firstname
216        da['jamb_middlename'] = dp['middlename'] = student.Middlename
217        da['jamb_lastname'] = dp['lastname'] = student.Lastname
218        da['jamb_sex'] = student.Sex
219        dp['sex'] = student.Sex == 'F'
220        dp['perm_address'] = student.Permanent_Address
221        application.getContent().edit(mapping=da)
222        self.portal_workflow.doActionFor(application,'close',dest_container=application)
223        personal.getContent().edit(mapping=dp)
224        clearance.getContent().edit(mapping=dc)
225        self.portal_workflow.doActionFor(clearance,'close',dest_container=clearance)
226        catd = {}
227        catd['id'] = sid
228        catd['entry_mode']= da['entry_mode']
229        catd['matric_no'] = matric_no
230        catd['jamb_reg_no'] = da['jamb_reg_no']
231        catd['name'] = "%(firstname)s %(middlename)s %(lastname)s" % dp
232        catd['sex'] = dp['sex']
233        catd['level'] = level
234        if certificate_brain:
235            cpath = certificate_brain.getPath().split('/')
236            catd['faculty'] = cpath[-4]
237            catd['department'] = cpath[-3]
238            catd['course'] = certcode
239        self.students_catalog.modifyRecord(**catd)
240        #
241        # Study Course
242        #
243        student_obj.invokeFactory('StudentStudyCourse','study_course')
244        studycourse = student_obj.study_course
245        self.portal_workflow.doActionFor(studycourse,'open',dest_container=studycourse)
246        dsc = {}
247        dsc['study_course'] = certcode
248        studycourse.getContent().edit(mapping=dsc)
249        #
250        # Level
251        #
252##        l = getattr(studycourse,level,None)
253##        if l is None:
254##            studycourse.invokeFactory('StudentStudyLevel', level)
255##            l = getattr(studycourse, level)
256##            self.portal_workflow.doActionFor(l,'open',dest_container=l)
257##            l.getContent().edit(mapping={'Title': "Level %s" % level})
258###)
259
260    security.declarePublic('makeStudentLevel') ###(
261    def makeStudentLevel(self,student_id):
262        "create the StudyLevel for a returning Student"
263        #import pdb;pdb.set_trace()
264        logger = logging.getLogger('Student.CreateLevel')
265        students_folder = self.portal_url.getPortalObject().campus.students
266        res = self.students_catalog(id=student_id)
267        if res:
268            st = res[0]
269        course = st.course
270        matric_no = st.matric_no
271        level = st.level
272        res = self.results_import(matric_no = matric_no)
273        if res:
274            results = res
275        logger.info('"%s", "creating Level", "%s"' % (student_id,level))
276        #
277        # Level
278        #
279        student_obj = getattr(self.portal_url.getPortalObject().campus.students,student_id)
280        studycourse = getattr(student_obj,"study_course",None)
281        self.portal_workflow.doActionFor(studycourse,'close_for_edit',dest_container=studycourse)
282        l = getattr(studycourse,level,None)
283        if l is None:
284            studycourse.invokeFactory('StudentStudyLevel', level)
285            l = getattr(studycourse, level)
286            self.portal_workflow.doActionFor(l,'open',dest_container=l)
287            l.getContent().edit(mapping={'Title': "Level %s" % level})
288        ###)
289
290    security.declarePublic('getAccommodationInfo') ###(
291    def getAccommodationInfo(self,bed):
292        """return Accommodation Info"""
293        info = {}
294        hall,block,room,letter = bed.split('_')
295        res = ZCatalog.searchResults(self.portal_catalog,portal_type="AccoHall",id=hall)
296        if res and len(res) == 1:
297            hall_brain = res[0]
298            hall_doc = hall_brain.getObject().getContent()
299        else:
300            return info
301        info['hall_title'] = hall_brain.Title
302        info['maintenance_code'] = hall_doc.maintenance_code
303        res = ZCatalog.searchResults(self.portal_catalog,portal_type="ScratchCardBatch")
304        batch_doc = None
305        for brain in res:
306            if brain.id.startswith(info['maintenance_code']):
307                batch_doc = brain.getObject().getContent()
308                break
309        if batch_doc is None:
310            info['maintenance_fee'] = None
311        else:
312            info['maintenance_fee'] = batch_doc.cost
313        return info
314    ###)
315
316    security.declareProtected(ModifyPortalContent,'deleteAllCourses') ###(
317    def deleteAllCourses(self,department="All"):
318        ''' delete the courses'''
319        pm = self.portal_membership
320        member = pm.getAuthenticatedMember()
321
322        if str(member) not in ("henrik","joachim"):
323            return "not possible"
324        if department == "All":
325            res = self.portal_catalog({'meta_type': 'Department'})
326        if len(res) < 1:
327            return "No Departments found"
328
329        deleted = []
330        for dep in res:
331            cf = dep.getObject().courses
332            if cf:
333                cf.manage_delObjects(ids=cf.objectIds())
334                deleted.append("deleted Courses in %s" % dep.getId)
335        return "\r".join(deleted)
336    ###)
337
338
339InitializeClass(WAeUPTool)
Note: See TracBrowser for help on using the repository browser.