source: WAeUP_SRP/trunk/WAeUPTool.py @ 1353

Last change on this file since 1353 was 1319, checked in by joachim, 18 years ago

A profiles/default/vocabularies/student_transfer_types.xml
A profiles/default/layouts/student_transfer.xml
M profiles/default/vocabularies.xml
M profiles/default/layouts.xml
AM skins/waeup_student/request_transfer.py
AM skins/waeup_student/request_transfer_form.pt
for request transfer
M profiles/default/students_catalog.xml
entry_mode index (in zmi)
M Students.py
fixEntryModeForReturning + fixAllEntryModeForReturning
M WAeUPTool.py
makeStudent fixed
  • Property svn:keywords set to Id
File size: 14.4 KB
RevLine 
[197]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 1319 2007-01-18 23:09:04Z joachim $
[1174]20"""The WAeUP Tool Box.
[197]21"""
22
23from AccessControl import ClassSecurityInfo
[828]24from Acquisition import aq_inner
25from Acquisition import aq_parent
26from Globals import DTMLFile
27from Globals import InitializeClass
28from OFS.SimpleItem import SimpleItem
[197]29
[828]30from Products.CMFCore.ActionProviderBase import ActionProviderBase
31from Products.CMFCore.permissions import View
32from Products.ZCatalog.ZCatalog import ZCatalog
33from Products.CMFCore.permissions import ModifyPortalContent
[197]34from Products.CMFCore.utils import UniqueObject
[1194]35from Products.CMFCore.URLTool import URLTool
[1151]36from Students import makeCertificateCode
[1285]37from Globals import package_home,INSTANCE_HOME
38p_home = package_home(globals())
39i_home = INSTANCE_HOME
40import logging,os
[1170]41import transaction
[197]42
[1151]43
[1171]44
45
[828]46class WAeUPTool(UniqueObject, SimpleItem, ActionProviderBase):
[197]47    """WAeUP tool"""
48
[828]49    id = 'waeup_tool'
[197]50    meta_type = 'WAeUP Tool'
[828]51    _actions = ()
[197]52
53    security = ClassSecurityInfo()
[828]54    security.declareObjectProtected(View)
[197]55
[828]56    manage_options = ( ActionProviderBase.manage_options
57                     + SimpleItem.manage_options
58                     )
59
[1174]60
[1151]61    def generateStudentId(self,letter): ###(
62        import random
63        r = random
[1194]64        ##if letter not in ('ABCDEFGIHKLMNOPQRSTUVWXY'):
65        if letter == '?':
[1151]66            letter= r.choice('ABCDEFGHKLMNPQRSTUVWXY')
67        sid = "%c%d" % (letter,r.randint(99999,1000000))
[1194]68##        students = self.portal_url.getPortalObject().campus.students
69##        while hasattr(students, sid):
70##            sid = "%c%d" % (letter,r.randint(99999,1000000))
71        while self.students_catalog(id = sid):
[1151]72            sid = "%c%d" % (letter,r.randint(99999,1000000))
73        return sid
74    ###)
[828]75
[1261]76    security.declareProtected(ModifyPortalContent,'getCredential') ###(
[1250]77    def getCredential(self,student_id):
78        "return a student password"
79        student_entry = getattr(self.portal_directories.students,student_id,None)
80        if student_entry is None:
81            return None
[1263]82        return getattr(student_entry,"password","not set")
[1261]83    ###)
[1250]84
[1285]85    security.declarePublic('loadStudentFoto') ###(
86    def loadStudentFoto(self,student):
87        "return a student passport picture"
88        app_doc = student.application.getContent()
89        clear = student.clearance
90        clear_doc = clear.getContent()
91        matric_no = clear_doc.matric_no.upper()
[1286]92        picture1 ="%s/import/pictures_returning/%s.jpg" % (i_home,matric_no)
93        picture2 ="%s/import/pictures_returning/%s.JPG" % (i_home,matric_no)
[1285]94        #import pdb;pdb.set_trace()
[1286]95        if os.path.exists(picture1):
96            file = open(picture1)
97        elif os.path.exists(picture2):
[1287]98            file = open(picture2)
[1286]99        else:
[1287]100            return "passport picture not found %s" % picture1
[1286]101
[1285]102        outfile = file.read()
103        app_doc.manage_addFile('passport',
104                               file=outfile,
105                               title="%s.jpg" % matric_no)
[1286]106        return "successfully loaded passport picture"
[1285]107    ###)
108
109
[1170]110    security.declareProtected(ModifyPortalContent,'createOne') ###(
[1194]111    def createOne(self,students_folder,student_brain,letter,commit=False):
112        sid = self.waeup_tool.generateStudentId(letter)
[1170]113        students_folder.invokeFactory('Student', sid)
114        student = getattr(students_folder,sid)
115        self.portal_workflow.doActionFor(student,'return')
116        student.manage_setLocalRoles(sid, ['Owner',])
117        matric_no = student_brain.matric_no
118        jamb_reg_no = student_brain.Entryregno
119        self.students_catalog.addRecord(id = sid,
120                                           matric_no = matric_no,
121                                           jamb_reg_no = jamb_reg_no,
122                                           sex = student_brain.Sex == "F",
123                                           name = "%s %s %s" % (student_brain.Firstname,
124                                                                student_brain.Middlename,
125                                                                student_brain.Lastname)
126                                        )
127        if commit:
128            transaction.commit()
129        return sid,jamb_reg_no
130    ###)
131
[1151]132    security.declarePublic('getCertificateBrain') ###(
133    def getCertificateBrain(self,cert_id):
134        "do it"
135        res = ZCatalog.searchResults(self.portal_catalog,
136                                {'portal_type':"Certificate",
137                                      'id': cert_id})
138        if res:
139            return res[0]
140        return None
141    ###)
[1160]142
[1151]143    security.declarePublic('findStudentByMatricelNo') ###(
144    def findStudentByMatricelNo(self,matric_no):
145        "do it"
146        res = ZCatalog.searchResults(self.portal_catalog,
147                                {'portal_type':"StudentClearance",
148                                 'SearchableText': matric_no})
149        if res:
150            return res[0]
151        return None
152    ###)
153
154    security.declarePublic('makeStudentMember') ###(
155    def makeStudentMember(self,sid,password='uNsEt'):
156        """make the student a member"""
157        membership = self.portal_membership
158        membership.addMember(sid,
159                             password ,
160                             roles=('Member',
161                                     'Student',
162                                     ),
163                             domains='',
164                             properties = {'memberareaCreationFlag': False,
165                                           'homeless': True},)
166        member = membership.getMemberById(sid)
167        self.portal_registration.afterAdd(member, sid, password, None)
[1261]168        #self.manage_setLocalRoles(sid, ['Owner',])
[1151]169    ###)
[1160]170
[1151]171    security.declarePublic('makeStudentData') ###(
[1158]172    def makeStudentData(self,student_id,email=None,phone_nr=None):
[1151]173        "create Datastructure for a returning Student"
174        #import pdb;pdb.set_trace()
175        logger = logging.getLogger('Student.CreateData')
176        students_folder = self.portal_url.getPortalObject().campus.students
177        res = self.students_catalog(id=student_id)
178        if res:
179            st = res[0]
180        res = self.returning_import(matric_no = st.matric_no)
181        if res:
[1160]182            student = res[0]
[1158]183        logger.info('"%s", "creating Datastructure"' % student_id)
[1171]184        #student should not be allowed to perform this transition
[1174]185        #wftool = self.portal_workflow
186        #wftool.doActionFor(student,'return')
[1151]187        certcode_org = student.Coursemajorcode
188        certcode = makeCertificateCode(certcode_org)
189        certificate_brain = self.getCertificateBrain(certcode)
190        if not certificate_brain:
191            em = 'Certificate %s org-code %s not found\n' % (certcode, certcode_org)
192            logger.info(em)
193        level = student.Level
[1250]194        validlevel = False
[1151]195        try:
[1255]196            il = int(level) + 100
197            level = "%s" % il
[1250]198            validlevel = True
[1151]199        except:
200            em = '"%(matric_no)s","invalid Level","%(Level)s"' % student
201            logger.info(em)
[1250]202        if not validlevel:
203            erg = self.results_import(matric_no = student.matric_no)
204            level = 'xxx'
205            if erg:
206                level = erg[0].Level
207            try:
[1255]208                il = int(level) + 100
209                level = "%s" % il
[1250]210                em = '"%s","fixed Level from results_import","%s"' % (student.matric_no,erg[0].Level)
211                logger.info(em)
212                validlevel = True
213            except:
214                em = '"%s","invalid Level in results_import","%s"' % (student.matric_no,erg[0].Level)
215                logger.info(em)
[1151]216        matric_no = student.matric_no
217        sid = student_id
218        student_obj = getattr(students_folder,sid)
219        student_obj.invokeFactory('StudentApplication','application')
220        application = student_obj.application
[1169]221        self.portal_workflow.doActionFor(application,'open',dest_container=application)
[1151]222        da = {'Title': 'Application Data'}
223        student_obj.invokeFactory('StudentPersonal','personal')
224        da['jamb_reg_no'] = student.Entryregno
225        da['entry_mode'] = student.Mode_of_Entry
226        personal = student_obj.personal
227        self.portal_workflow.doActionFor(personal,'open',dest_container=personal)
228        dp = {'Title': 'Personal Data'}
229        student_obj.invokeFactory('StudentClearance','clearance')
230        clearance = student_obj.clearance
[1169]231        self.portal_workflow.doActionFor(clearance,'open',dest_container=clearance)
[1151]232        dc = {'Title': 'Clearance/Eligibility Record'}
233        dc['matric_no'] = matric_no
234        state = student.State
235        lga = student.LGA
236        if state and lga:
237            lga =  state + ' / ' + lga
238        else:
239            lga = "None"
[1174]240        da['jamb_lga'] = dc['lga'] = lga
[1173]241        da['app_email'] = dp['email'] = email
242        da['app_mobile'] = dp['phone'] = phone_nr
[1174]243        da['jamb_firstname'] = dp['firstname'] = student.Firstname
244        da['jamb_middlename'] = dp['middlename'] = student.Middlename
245        da['jamb_lastname'] = dp['lastname'] = student.Lastname
246        da['jamb_sex'] = student.Sex
[1151]247        dp['sex'] = student.Sex == 'F'
248        dp['perm_address'] = student.Permanent_Address
249        application.getContent().edit(mapping=da)
[1169]250        self.portal_workflow.doActionFor(application,'close',dest_container=application)
[1151]251        personal.getContent().edit(mapping=dp)
252        clearance.getContent().edit(mapping=dc)
[1169]253        self.portal_workflow.doActionFor(clearance,'close',dest_container=clearance)
[1158]254        catd = {}
255        catd['id'] = sid
256        catd['entry_mode']= da['entry_mode']
257        catd['matric_no'] = matric_no
[1171]258        catd['jamb_reg_no'] = da['jamb_reg_no']
259        catd['name'] = "%(firstname)s %(middlename)s %(lastname)s" % dp
260        catd['sex'] = dp['sex']
261        catd['level'] = level
[1158]262        if certificate_brain:
263            cpath = certificate_brain.getPath().split('/')
[1171]264            catd['faculty'] = cpath[-4]
265            catd['department'] = cpath[-3]
[1158]266            catd['course'] = certcode
267        self.students_catalog.modifyRecord(**catd)
[1151]268        #
269        # Study Course
270        #
271        student_obj.invokeFactory('StudentStudyCourse','study_course')
272        studycourse = student_obj.study_course
273        self.portal_workflow.doActionFor(studycourse,'open',dest_container=studycourse)
274        dsc = {}
275        dsc['study_course'] = certcode
276        studycourse.getContent().edit(mapping=dsc)
277        #
278        # Level
279        #
[1198]280##        l = getattr(studycourse,level,None)
281##        if l is None:
282##            studycourse.invokeFactory('StudentStudyLevel', level)
283##            l = getattr(studycourse, level)
284##            self.portal_workflow.doActionFor(l,'open',dest_container=l)
285##            l.getContent().edit(mapping={'Title': "Level %s" % level})
[1194]286###)
[1160]287
[1194]288    security.declarePublic('makeStudentLevel') ###(
289    def makeStudentLevel(self,student_id):
290        "create the StudyLevel for a returning Student"
291        #import pdb;pdb.set_trace()
292        logger = logging.getLogger('Student.CreateLevel')
293        students_folder = self.portal_url.getPortalObject().campus.students
294        res = self.students_catalog(id=student_id)
295        if res:
296            st = res[0]
297        course = st.course
298        matric_no = st.matric_no
299        level = st.level
300        res = self.results_import(matric_no = matric_no)
301        if res:
302            results = res
303        logger.info('"%s", "creating Level", "%s"' % (student_id,level))
304        #
305        # Level
306        #
307        student_obj = getattr(self.portal_url.getPortalObject().campus.students,student_id)
308        studycourse = getattr(student_obj,"study_course",None)
309        self.portal_workflow.doActionFor(studycourse,'close_for_edit',dest_container=studycourse)
310        l = getattr(studycourse,level,None)
311        if l is None:
312            studycourse.invokeFactory('StudentStudyLevel', level)
313            l = getattr(studycourse, level)
314            self.portal_workflow.doActionFor(l,'open',dest_container=l)
315            l.getContent().edit(mapping={'Title': "Level %s" % level})
316        ###)
317
[1151]318    security.declarePublic('getAccommodationInfo') ###(
[828]319    def getAccommodationInfo(self,bed):
320        """return Accommodation Info"""
321        info = {}
322        hall,block,room,letter = bed.split('_')
323        res = ZCatalog.searchResults(self.portal_catalog,portal_type="AccoHall",id=hall)
324        if res and len(res) == 1:
325            hall_brain = res[0]
326            hall_doc = hall_brain.getObject().getContent()
327        else:
328            return info
329        info['hall_title'] = hall_brain.Title
330        info['maintenance_code'] = hall_doc.maintenance_code
331        res = ZCatalog.searchResults(self.portal_catalog,portal_type="ScratchCardBatch")
332        batch_doc = None
333        for brain in res:
334            if brain.id.startswith(info['maintenance_code']):
335                batch_doc = brain.getObject().getContent()
336                break
337        if batch_doc is None:
338            info['maintenance_fee'] = None
339        else:
340            info['maintenance_fee'] = batch_doc.cost
341        return info
[1151]342    ###)
[828]343
[1151]344    security.declareProtected(ModifyPortalContent,'deleteAllCourses') ###(
345    def deleteAllCourses(self,department="All"):
346        ''' delete the courses'''
347        pm = self.portal_membership
348        member = pm.getAuthenticatedMember()
[1160]349
[1151]350        if str(member) not in ("henrik","joachim"):
351            return "not possible"
352        if department == "All":
353            res = self.portal_catalog({'meta_type': 'Department'})
354        if len(res) < 1:
355            return "No Departments found"
[1160]356
[1151]357        deleted = []
358        for dep in res:
359            cf = dep.getObject().courses
360            if cf:
361                cf.manage_delObjects(ids=cf.objectIds())
362                deleted.append("deleted Courses in %s" % dep.getId)
363        return "\r".join(deleted)
[1160]364    ###)
[1151]365
[1160]366
[828]367InitializeClass(WAeUPTool)
Note: See TracBrowser for help on using the repository browser.