Context navigation

source: WAeUP_SRP/trunk/Students.py @ 709

Last change on this file since 709 was 708, checked in by joachim, 18 years ago
should fix error traceback when accessing pins on server.
Property svn:keywords set to `Id`
File size: 29.6 KB

Rev	Line
[57]	1	#-- mode: python; mode: fold --
[200]	2	# $Id: Students.py 708 2006-10-16 16:05:00Z joachim $
[708]	3	from string import Template
[45]	4	from Globals import InitializeClass
	5	from AccessControl import ClassSecurityInfo
[164]	6	from AccessControl.SecurityManagement import newSecurityManager
[429]	7	from zExceptions import BadRequest
[502]	8	from Products.ZCatalog.ZCatalog import ZCatalog
[47]	9	from Products.CMFCore.utils import UniqueObject, getToolByName
[45]	10	from Products.CMFCore.permissions import View
	11	from Products.CMFCore.permissions import ModifyPortalContent
[154]	12	from Products.CPSCore.CPSBase import CPSBase_adder, CPSBaseFolder
	13	#from Products.CPSCore.CPSBase import CPSBaseDocument as BaseDocument
	14	from Products.CPSDocument.CPSDocument import CPSDocument
	15	from Products.CPSCore.CPSBase import CPSBaseBTreeFolder as BaseBTreeFolder
[164]	16	from Products.CPSCore.CPSMembershipTool import CPSUnrestrictedUser
[361]	17	from Products.WAeUP_SRP.Academics import makeCertificateCode
[362]	18	import logging
	19	import csv,re
	20	import Globals
	21	p_home = Globals.package_home(globals())
	22	i_home = Globals.INSTANCE_HOME
[398]	23	MAX_TRANS = 1000
[154]	24
[511]	25	def generateStudentId(letter):
[422]	26	import random
[423]	27	r = random
[511]	28	if letter not in ('ABCDEFGIHKLMNOPQRSTUVWXY'):
	29	letter= r.choice('ABCDEFGHKLMNPQRSTUVWXY')
	30	return "%c%d" % (letter,r.randint(99999,1000000))
	31	#return "%c%d" % (r.choice('ABCDEFGHKLMNPQRSTUVWXY'),r.randint(99999,1000000))
[422]	32
[502]	33	def getStudentByRegNo(self,reg_no):
	34	"""search student by JAMB Reg No and return StudentFolder"""
	35	search = ZCatalog.searchResults(self.portal_catalog,{'meta_type': 'StudentApplication',
[606]	36	'SearchableText': reg_no,
[502]	37	})
	38	if len(search) < 1:
	39	return None
	40	return search[0].getObject().aq_parent
	41
[361]	42	class StudentsFolder(CPSDocument): ###(
	43	"""
	44	WAeUP container for the various WAeUP containers data
	45	"""
[362]	46	meta_type = 'StudentsFolder'
[361]	47	portal_type = meta_type
	48	security = ClassSecurityInfo()
[154]	49
[361]	50	security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsFromCSV")###(
	51	def loadFullTimeStudentsFromCSV(self):
	52	"""load Fulltime Studentdata from CSV values"""
[398]	53	import transaction
[708]	54	import random
[398]	55	tr_count = 0
[361]	56	name = 'short_full_time'
	57	no_import = False
[395]	58	if not no_import:
	59	no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
	60	no_import.write('"MatricNo","EntryRegNo","CurrentSession","StudentLevel","fullname","FirstName","MiddleName","Lastname","FormerSurname","Sex","Nationality","State","LGA","PermanentAddress","PermanentAddressCity","CampusAddress","PhoneNumber","Emailaddress","Mode","CourseMajor","Faculty","Dept"\n')
[361]	61	logger = logging.getLogger('%s_import' % name)
	62	logger.info('Start loading from %s.csv' % name)
[708]	63	pwlist = []
	64	pwlist.append('"student_id","firstname","middlename","lastname","matric_no","jamb_reg_no","access_code"')
	65	pwl_template = Template('"$student_id","$firstname","$middlename","$lastname","$matric_no","$jamb_reg_no","$access_code"')
[361]	66	students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
	67	try:
	68	students = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
	69	except:
	70	logger.error('Error reading %s.csv' % name)
	71	return
[422]	72	l = self.portal_catalog({'meta_type': "StudentClearance",})
	73	matrics = []
[361]	74	for s in l:
[422]	75	matrics.append(s.getObject().getContent().matric_no)
[423]	76	print matrics
[361]	77	l = self.portal_catalog({'meta_type': "Certificate"})
	78	certs = {}
	79	for c in l:
[362]	80	certs[c.id] = c.getObject()
[361]	81	for student in students:
[393]	82	logger.info('processing "%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
[361]	83	sid = student.get('MatricNo')
[396]	84	if sid == "":
	85	em = 'Empty MatricNo\n'
	86	logger.info(em)
	87	no_import.write(em)
	88	no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
	89	continue
[361]	90	certcode = makeCertificateCode(student.get('CourseMajor'))
	91	if certcode not in certs.keys():
[393]	92	em = 'Certificate with ID %s %s not found\n' % (certcode, student.get('CourseMajor'))
[361]	93	logger.info(em)
[393]	94	no_import.write(em)
	95	no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
[361]	96	continue
[395]	97	level = student.get('StudentLevel')
[426]	98	try:
[395]	99	int(level)
	100	except:
	101	em = 'Student with ID %(MatricNo)s StudentLevel is empty\n' % student
	102	logger.info(em)
	103	no_import.write(em)
	104	no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
	105	continue
[422]	106	matric_no = student.get('MatricNo')
	107	if matric_no not in matrics:
	108	matrics.append(matric_no)
[708]	109	sid = generateStudentId(student.get('Lastname')[0])
[361]	110	#self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
[426]	111	logger.info('%(tr_count)s: Creating Student with ID %(sid)s Matric_no %(matric_no)s ' % vars())
[429]	112	not_created = True
	113	while not_created:
	114	try:
	115	students_folder.invokeFactory('Student', sid)
	116	not_created = False
	117	except BadRequest:
	118	sid = generateStudentId()
	119	logger.info('%(tr_count)s: Creating Student with ID %(sid)s Matric_no %(matric_no)s ' % vars())
[361]	120	s = getattr(self,sid)
[708]	121	access_code = "%d" % random.randint(1000000000,9999999999)
[603]	122	self.portal_registration.addMember(sid,
[708]	123	access_code ,
[502]	124	roles=('Member',
	125	'Student',))
[708]	126	pwl_dict = {'student_id': sid,'access_code':access_code}
[472]	127	s.invokeFactory('StudentApplication','application')
	128	da = {'Title': 'Application Data'}
[361]	129	s.invokeFactory('StudentPersonal','personal')
[446]	130	da['jamb_reg_no'] = student.get('EntryRegNo')
[362]	131	sp = s.personal
[708]	132	dp = {'Title': 'Personal Data'}
[422]	133	s.invokeFactory('StudentClearance','clearance')
[427]	134	sc = s.clearance
[422]	135	dc = {'Title': 'Clearance Data'}
	136	dc['matric_no'] = matric_no
[472]	137	lga = student.get('State') + ' / ' + student.get('LGA')
[427]	138	dc['lga'] = lga
[422]	139	dc['nationality'] = student.get('Nationality')
	140	dc['email'] = student.get('Emailaddress')
[708]	141	dp['firstname'] = student.get('FirstName')
	142	dp['middlename'] = student.get('MiddleName')
	143	dp['lastname'] = student.get('Lastname')
	144	dp['former_surname'] = student.get('FormerSurname')
	145	dp['sex'] = student.get('Sex') == 'F'
	146	dp['perm_address'] = student.get('PermanentAddress')
	147	dp['perm_city'] = student.get('PermanentAddressCity')
	148	dp['campus_address'] = student.get('CampusAddress')
	149	dp['phone'] = student.get('PhoneNumber')
[472]	150	s.application.getContent().edit(mapping=da)
[708]	151	sp.getContent().edit(mapping=dp)
[422]	152	sc.getContent().edit(mapping=dc)
[362]	153	#
	154	# Study Course
	155	#
	156	s.invokeFactory('StudentStudyCourse','study_course')
	157	sc = s.study_course
[708]	158	dsc = {}
	159	dsc['study_course'] = certcode
[454]	160	css = student.get('CurrentSession') or '2004-2005'
	161	cs = int(css.split('-')[0]) - 2000
	162	cl = int(student.get('StudentLevel'))/100
[708]	163	dsc['entry_session'] = "200%s" % (cs - cl)
	164	dsc['clr_ac_pin'] = access_code
	165	sc.getContent().edit(mapping=dsc)
[364]	166	#
	167	# Level
	168	#
	169	l = getattr(sc,level,None)
	170	if l is None:
	171	#self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
	172	logger.info('Creating Level %(StudentLevel)s for %(fullname)s' % student)
[454]	173	sc.invokeFactory('StudentStudyLevel', level)
[364]	174	l = getattr(sc, level)
	175	certificate = certs[certcode]
	176	cert_level = getattr(certificate,level,None)
	177	if cert_level is None:
	178	logger.info('Level %(level)s not in %(certcode)s' % vars())
	179	l.getContent().edit(mapping={'Title': "Level %s" % level})
[708]	180	## l.invokeFactory('StudentSemester','first')
	181	## l.invokeFactory('StudentSemester','second')
	182	## first_s = getattr(l,'first')
	183	## first_s.getContent().edit(mapping={'Title': 'First Semester'})
	184	## second_s = getattr(l,'second')
	185	## second_s.getContent().edit(mapping={'Title': 'Second Semester'})
[361]	186	else:
[393]	187	em = 'Student with ID %(MatricNo)s %(fullname)s already exists\n' % student
[361]	188	logger.info(em)
[393]	189	no_import.write(em)
	190	no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
[398]	191	if tr_count > MAX_TRANS:
[422]	192	transaction.commit()
	193	em = 'Transaction commited\n' % student
[398]	194	logger.info(em)
	195	tr_count = 0
	196	tr_count += 1
[708]	197	pwl_dict.update(dc)
	198	pwl_dict.update(da)
	199	pwl_dict.update(dp)
	200	pwlist.append(pwl_template.substitute(pwl_dict))
[423]	201	return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
[361]	202	###)
[382]	203
[398]	204	security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsResultsFromCSV") ###(
[396]	205	def loadFullTimeStudentsResultsFromCSV(self):
	206	"""load Fulltime Studentdata from CSV values"""
	207	#return
[398]	208	import transaction
	209	tr_count = 0
	210	name = 'short_full_time_results_2004_2005'
[396]	211	no_import = False
	212	if not no_import:
	213	no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
	214	no_import.write('"Matnumber","CosCode","Ansbook","CosStuatus","Session","Mat_Cos","Score","CarryLevel","Grade","Weight","Semster","Verdict","Level","id","GPA"\n')
	215	logger = logging.getLogger('%s_import' % name)
	216	logger.info('Start loading from %s.csv' % name)
	217	students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
	218	try:
	219	results = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
	220	except:
	221	logger.error('Error reading %s.csv' % name)
	222	return
[398]	223	l = self.portal_catalog({'meta_type': "Course"})
	224	courses = {}
	225	for c in l:
	226	courses[c.id] = c.getObject()
[396]	227	for result in results:
	228	sid = result.get('Matnumber')
[452]	229	res = self.portal_catalog({'meta_type': "StudentClearance",
	230	'matric_no': sid })
	231	if not res:
[398]	232	em = 'Student with ID %(Matnumber)s not found\n' % result
[396]	233	logger.info(em)
	234	no_import.write(em)
[398]	235	no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
[396]	236	continue
[452]	237	sf = res[0].getObject().aq_parent
[454]	238	result['StudentId'] = sf.getId()
[398]	239	course = result.get('CosCode')
	240	if course not in courses.keys():
	241	em = 'Course with ID %(CosCode)s not found\n' % result
[396]	242	logger.info(em)
	243	no_import.write(em)
[398]	244	no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
[396]	245	continue
[398]	246	level = result.get('Level')
[426]	247	try:
[396]	248	int(level)
	249	except:
[398]	250	em = 'Result for result with ID %(Matnumber)s Course %(CosCode)s Level is empty\n' % result
[396]	251	logger.info(em)
	252	no_import.write(em)
[398]	253	no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
[396]	254	continue
	255	sc = getattr(sf,'study_course')
	256	l = getattr(sc,level,None)
	257	if l is None:
	258	#self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
[454]	259	logger.info('Creating Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
	260	sc.invokeFactory('StudentStudyLevel', level)
[396]	261	l = getattr(sc, level)
[464]	262	l.invokeFactory('StudentSemester','first')
	263	l.invokeFactory('StudentSemester','second')
[396]	264	first_s = getattr(l,'first')
	265	first_s.getContent().edit(mapping={'Title': 'First Semester'})
	266	second_s = getattr(l,'second')
	267	second_s.getContent().edit(mapping={'Title': 'Second Semester'})
[454]	268	snr = result.get('Semster')
[396]	269	semester = getattr(l,'first')
[398]	270	if snr == "2":
[396]	271	semester = getattr(l,'second')
[464]	272	logger.info('Creating StudentCourseResult %(CosCode)s in Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
	273	semester.invokeFactory('StudentCourseResult',course)
[398]	274	ct = getattr(semester,course)
	275	d = {}
[454]	276	dlev = {}
[398]	277	d['ansbook'] = result.get('Ansbook')
	278	d['status'] = result.get('CosStuatus')
	279	d['score'] = result.get('Score')
[454]	280	dlev['session'] = result.get('Session')
	281	dlev['carry_level'] = result.get('CarryLevel')
[398]	282	d['grade'] = result.get('Grade')
[454]	283	#d['weight'] = result.get('Weight')
	284	dlev['verdict'] = result.get('Verdict')
	285	#d['import_id'] = result.get('id')
	286	#gpa = result.get('GPA').replace(',','.')
	287	#d['gpa'] = float(gpa)
[398]	288	ct.getContent().edit(mapping = d)
[454]	289	l.getContent().edit(mapping = dlev)
[398]	290	if tr_count > MAX_TRANS:
	291	transaction.commit()
	292	tr_count = 0
	293	tr_count += 1
[681]	294	return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
[426]	295
[398]	296	###)
[396]	297
[457]	298	security.declareProtected(ModifyPortalContent,"loadJAMBFromCSV")###(
	299	def loadJAMBFromCSV(self):
	300	"""load JAMB data from CSV values"""
	301	#return
	302	students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
	303	import transaction
	304	tr_count = 0
[572]	305	name = 'SampleJAMBDataII'
[511]	306	wftool = self.portal_workflow
[457]	307	no_import = False
	308	if not no_import:
	309	no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
	310	no_import.write('REG-NO,NAME,SEX,STATE,LGA,ENG-SCORE,SUBJ1,SUBJ1-SCORE,SUBJ2,SUBJ2-SCORE,SUBJ3,SUBJ3-SCORE,AGGREGATE,UNIV1,FACULTY1,COURSE1,UNIV2,FACULTY2,COURSE2')
	311	logger = logging.getLogger('%s_import' % name)
	312	logger.info('Start loading from %s.csv' % name)
	313	try:
	314	result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
	315	except:
	316	logger.error('Error reading %s.csv' % name)
	317	return
	318	for jamb in result:
	319	logger.info('processing %(REG-NO)s,%(NAME)s,%(SEX)s,%(STATE)s,%(LGA)s,%(ENG-SCORE)s,%(SUBJ1)s,%(SUBJ1-SCORE)s,%(SUBJ2)s,%(SUBJ2-SCORE)s,%(SUBJ3)s,%(SUBJ3-SCORE)s,%(AGGREGATE)s,%(UNIV1)s,%(FACULTY1)s,%(COURSE1)s,%(UNIV2)s,%(FACULTY2)s,%(COURSE2)s\n' % jamb)
	320	jamb_reg_no = jamb.get('REG-NO')
[472]	321	res = self.portal_catalog({'meta_type': "StudentApplication",
[457]	322	'jamb_reg_no': jamb_reg_no })
	323	if res:
	324	em = 'Student with REG-NO %(REG-NO)s already exists\n' % jamb
	325	logger.info(em)
	326	no_import.write(em)
	327	no_import.write('%(REG-NO)s,%(NAME)s,%(SEX)s,%(STATE)s,%(LGA)s,%(ENG-SCORE)s,%(SUBJ1)s,%(SUBJ1-SCORE)s,%(SUBJ2)s,%(SUBJ2-SCORE)s,%(SUBJ3)s,%(SUBJ3-SCORE)s,%(AGGREGATE)s,%(UNIV1)s,%(FACULTY1)s,%(COURSE1)s,%(UNIV2)s,%(FACULTY2)s,%(COURSE2)s\n' % jamb)
	328	continue
[511]	329	jamb_name = jamb.get("NAME")
[584]	330	jamb_name.replace('>','')
[511]	331	names = jamb_name.split()
	332	letter = names[-1][0].upper()
	333	sid = generateStudentId(letter)
[457]	334	#self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
	335	not_created = True
	336	while not_created:
	337	try:
	338	students_folder.invokeFactory('Student', sid)
	339	not_created = False
	340	except BadRequest:
[511]	341	sid = generateStudentId(letter)
[457]	342	logger.info('%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
[511]	343	student = getattr(self,sid)
[519]	344	student.manage_setLocalRoles(sid, ['Owner',])
[511]	345	student.invokeFactory('StudentApplication','application')
[472]	346	da = {'Title': 'Application Data'}
[457]	347	da["jamb_reg_no"] = jamb.get("REG-NO")
[511]	348	da["jamb_lastname"] = jamb_name
[457]	349	da["jamb_sex"] = jamb.get("SEX")
	350	da["jamb_state"] = jamb.get("STATE")
	351	da["jamb_lga"] = jamb.get("LGA")
	352	da["jamb_score"] = jamb.get("AGGREGATE")
	353	da["jamb_first_cos"] = jamb.get("COURSE1")
	354	da["jamb_second_cos"] = jamb.get("COURSE2")
	355	da["jamb_first_uni"] = jamb.get("UNIV1")
	356	da["jamb_second_uni"] = jamb.get("UNIV2")
[511]	357	app = student.application
	358	app_doc = app.getContent()
	359	app_doc.edit(mapping=da)
[658]	360	#wftool.doActionFor(app,'open',dest_container=app)
[511]	361	app.manage_setLocalRoles(sid, ['Owner',])
	362	student.getContent().createSubObjects()
[457]	363	return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
	364	###)
[426]	365
[472]	366
[511]	367	security.declareProtected(View,"fixOwnership")
	368	def fixOwnership(self):
	369	"""fix Ownership"""
	370	for s in self.portal_catalog(meta_type = 'Student'):
	371	student = s.getObject()
	372	sid = s.getId
	373	import pdb;pdb.set_trace()
	374	student.application.manage_setLocalRoles(sid, ['Owner',])
	375	student.personal.manage_setLocalRoles(sid, ['Owner',])
[603]	376
[364]	377	security.declareProtected(View,"Title")
	378	def Title(self):
	379	"""compose title"""
[382]	380	return "Student Section"
[361]	381
	382	InitializeClass(StudentsFolder)
	383
	384	def addStudentsFolder(container, id, REQUEST=None, **kw):
	385	"""Add a Student."""
	386	ob = StudentsFolder(id, **kw)
	387	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	388	###)
	389
[57]	390	class Student(CPSDocument): ###(
	391	"""
[154]	392	WAeUP Student container for the various student data
[57]	393	"""
	394	meta_type = 'Student'
	395	portal_type = meta_type
	396	security = ClassSecurityInfo()
[154]	397
[152]	398	security.declareProtected(View,"Title")
	399	def Title(self):
	400	"""compose title"""
[153]	401	reg_nr = self.getId()[1:]
[362]	402	data = getattr(self,'personal',None)
[152]	403	if data:
	404	content = data.getContent()
	405	return "%s %s" % (content.firstname,content.lastname)
[472]	406	data = getattr(self,'application',None)
[464]	407	if data:
	408	content = data.getContent()
	409	return "%s" % (content.jamb_lastname)
[152]	410	return self.title
[154]	411
[511]	412	security.declarePrivate('makeStudentMember') ###(
	413	def makeStudentMember(self,sid,password='uNsEt'):
	414	"""make the student a member"""
	415	membership = self.portal_membership
[603]	416	membership.addMember(sid,
[511]	417	password ,
	418	roles=('Member',
	419	'Student',
[522]	420	),
[511]	421	domains='',
[522]	422	properties = {'memberareaCreationFlag': False,},)
[511]	423	member = membership.getMemberById(sid)
	424	self.portal_registration.afterAdd(member, sid, password, None)
	425	self.manage_setLocalRoles(sid, ['Owner',])
	426
	427	###)
	428
	429	security.declareProtected(View,'createSubObjects') ###(
	430	def createSubObjects(self):
	431	"""make the student a member"""
	432	dp = {'Title': 'Personal Data'}
[512]	433	app_doc = self.application.getContent()
	434	names = app_doc.jamb_lastname.split()
[511]	435	if len(names) == 3:
	436	dp['firstname'] = names[0].capitalize()
	437	dp['middlename'] = names[1].capitalize()
	438	dp['lastname'] = names[2].capitalize()
	439	elif len(names) == 2:
	440	dp['firstname'] = names[0].capitalize()
	441	dp['lastname'] = names[1].capitalize()
	442	else:
	443	dp['lastname'] = app_doc.jamb_lastname
[512]	444	dp['sex'] = app_doc.jamb_sex == 'F'
	445	dp['lga'] = "%s/%s" % (app_doc.jamb_state,app_doc.jamb_lga )
[511]	446	proxy = self.aq_parent
	447	proxy.invokeFactory('StudentPersonal','personal')
	448	per = proxy.personal
	449	per_doc = per.getContent()
[512]	450	per_doc.edit(mapping = dp)
[511]	451	per.manage_setLocalRoles(self.getId(), ['Owner',])
[603]	452	#self.portal_workflow.doActionFor(per,'open',dest_container=per)
	453
[511]	454	###)
	455
[57]	456	InitializeClass(Student)
	457
	458	def addStudent(container, id, REQUEST=None, **kw):
	459	"""Add a Student."""
	460	ob = Student(id, **kw)
	461	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	462
	463	###)
[91]	464
[639]	465	class StudentAccommodation(CPSDocument): ###(
	466	"""
	467	WAeUP Student container for the various student data
	468	"""
	469	meta_type = 'StudentAccommodation'
	470	portal_type = meta_type
	471	security = ClassSecurityInfo()
	472
	473	security.declareProtected(View,"Title")
	474	def Title(self):
	475	"""compose title"""
	476	content = self.getContent()
	477	#return "Accommodation Data for %s %s" % (content.firstname,content.lastname)
	478	return "Accommodation Data for Session %s" % content.session
	479
	480
	481	InitializeClass(StudentAccommodation)
	482
	483	def addStudentAccommodation(container, id, REQUEST=None, **kw):
	484	"""Add a Students personal data."""
	485	ob = StudentAccommodation(id, **kw)
	486	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	487
	488	###)
	489
[89]	490	class StudentPersonal(CPSDocument): ###(
	491	"""
[154]	492	WAeUP Student container for the various student data
[89]	493	"""
	494	meta_type = 'StudentPersonal'
	495	portal_type = meta_type
	496	security = ClassSecurityInfo()
[152]	497
	498	security.declareProtected(View,"Title")
	499	def Title(self):
	500	"""compose title"""
	501	content = self.getContent()
[364]	502	#return "Personal Data for %s %s" % (content.firstname,content.lastname)
	503	return "Personal Data"
[152]	504
[154]	505
[89]	506	InitializeClass(StudentPersonal)
	507
	508	def addStudentPersonal(container, id, REQUEST=None, **kw):
	509	"""Add a Students personal data."""
	510	ob = StudentPersonal(id, **kw)
	511	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	512
	513	###)
	514
[423]	515	class StudentClearance(CPSDocument): ###(
	516	"""
	517	WAeUP Student container for the various student data
	518	"""
	519	meta_type = 'StudentClearance'
	520	portal_type = meta_type
	521	security = ClassSecurityInfo()
	522
	523	security.declareProtected(View,"Title")
	524	def Title(self):
	525	"""compose title"""
	526	content = self.getContent()
	527	#return "Clearance Data for %s %s" % (content.firstname,content.lastname)
	528	return "Clearance Data"
	529
	530
	531	InitializeClass(StudentClearance)
	532
	533	def addStudentClearance(container, id, REQUEST=None, **kw):
	534	"""Add a Students personal data."""
	535	ob = StudentClearance(id, **kw)
	536	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	537
	538	###)
	539
[454]	540	class StudentStudyLevel(CPSDocument): ###(
	541	"""
	542	WAeUP Student container for the various student data
	543	"""
	544	meta_type = 'StudentStudyLevel'
	545	portal_type = meta_type
	546	security = ClassSecurityInfo()
	547
	548	security.declareProtected(View,"Title")
	549	def Title(self):
	550	"""compose title"""
	551	return "Level %s" % self.aq_parent.getId()
	552
	553	security.declareProtected(View,"gpa")
	554	def gpa(self):
	555	"""calculate the gpa"""
	556	sum = 0
	557	course_count = 0
	558	for semester in ('first','second'):
	559	sf=getattr(self,semester)
	560	for sc in sf.objectValues():
	561	result = sc.getContent()
	562	res = self.portal_catalog({'meta_type': 'Course',
	563	'id': sc.aq_parent.id})
	564	if len(res) != 1:
	565	continue
	566	course = res[0].getObject().getContent()
	567	sum += course.credits * ['F','E','D','C','B','A'].index(result.grade)
	568	course_count += 1
	569	if course_count:
	570	return sum/course_count
	571	return 0.0
[472]	572
[454]	573	InitializeClass(StudentStudyLevel)
	574
	575	def addStudentStudyLevel(container, id, REQUEST=None, **kw):
	576	"""Add a Students personal data."""
	577	ob = StudentStudyLevel(id, **kw)
	578	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	579
	580	###)
	581
[362]	582	class StudentStudyCourse(CPSDocument): ###(
	583	"""
	584	WAeUP Student container for the various student data
	585	"""
	586	meta_type = 'StudentStudyCourse'
	587	portal_type = meta_type
	588	security = ClassSecurityInfo()
	589
[364]	590	security.declareProtected(View,"Title")
	591	def Title(self):
	592	"""compose title"""
	593	content = self.getContent()
[453]	594	return "Study Course"
[362]	595
	596
	597	InitializeClass(StudentStudyCourse)
	598
	599	def addStudentStudyCourse(container, id, REQUEST=None, **kw):
	600	"""Add a Students personal data."""
	601	ob = StudentStudyCourse(id, **kw)
	602	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	603
	604	###)
	605
[472]	606	class StudentApplication(CPSDocument): ###(
[179]	607	"""
	608	WAeUP Student container for the various student data
	609	"""
[472]	610	meta_type = 'StudentApplication'
[179]	611	portal_type = meta_type
	612	security = ClassSecurityInfo()
	613
[181]	614	security.declareProtected(View,"Title")
	615	def Title(self):
	616	"""compose title"""
[472]	617	return "Application Data"
[179]	618
[181]	619
[472]	620	InitializeClass(StudentApplication)
[179]	621
[472]	622	def addStudentApplication(container, id, REQUEST=None, **kw):
[179]	623	"""Add a Students eligibility data."""
[472]	624	ob = StudentApplication(id, **kw)
[179]	625	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	626
	627	###)
[181]	628
[565]	629	##class StudentSemester(CPSDocument): ###(
	630	## """
	631	## WAeUP StudentSemester containing the courses and students
	632	## """
	633	## meta_type = 'StudentSemester'
	634	## portal_type = meta_type
	635	## security = ClassSecurityInfo()
	636	##
	637	##InitializeClass(StudentSemester)
	638	##
	639	##def addStudentSemester(container, id, REQUEST=None, **kw):
	640	## """Add a StudentSemester."""
	641	## ob = StudentSemester(id, **kw)
	642	## return CPSBase_adder(container, ob, REQUEST=REQUEST)
	643	##
	644	#####)
[464]	645
[581]	646	class Semester(CPSDocument): ###(
	647	"""
	648	WAeUP Semester containing the courses and students
	649	"""
	650	meta_type = 'Semester'
	651	portal_type = meta_type
	652	security = ClassSecurityInfo()
[464]	653
[581]	654	InitializeClass(Semester)
	655
	656	def addSemester(container, id, REQUEST=None, **kw):
	657	"""Add a Semester."""
	658	ob = Semester(id, **kw)
	659	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	660
[584]	661	###)
[581]	662
[464]	663	class StudentCourseResult(CPSDocument): ###(
[89]	664	"""
[464]	665	WAeUP StudentCourseResult
[89]	666	"""
[464]	667	meta_type = 'StudentCourseResult'
[89]	668	portal_type = meta_type
	669	security = ClassSecurityInfo()
[472]	670
[454]	671	def getCourseEntry(self,cid):
[464]	672	res = self.portal_catalog({'meta_type': "StudentCourse",
[454]	673	'id': cid})
	674	if res:
	675	return res[-1]
	676	else:
	677	return None
[154]	678
[454]	679	security.declareProtected(View,"Title")
	680	def Title(self):
	681	"""compose title"""
	682	cid = self.getId()
	683	ce = self.getCourseEntry(cid)
	684	if ce:
	685	return "%s" % ce.Title
	686	return "No course with id %s" % cid
[152]	687
[464]	688	InitializeClass(StudentCourseResult)
[454]	689
[464]	690	def addStudentCourseResult(container, id, REQUEST=None, **kw):
	691	"""Add a StudentCourseResult."""
	692	ob = StudentCourseResult(id, **kw)
[89]	693	return CPSBase_adder(container, ob, REQUEST=REQUEST)
[139]	694	###)
	695
[579]	696	# Backward Compatibility StudyLevel
	697
	698	from Products.WAeUP_SRP.Academics import StudyLevel
	699
	700	from Products.WAeUP_SRP.Academics import addStudyLevel
	701

Note: See TracBrowser for help on using the repository browser.

Download in other formats: