Context navigation

source: WAeUP_SRP/trunk/Students.py @ 4638

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

store ids when removing students and check for removed ids when csdding new students

WAeUPTable alraedy contains methods for position ind course calculation

Property svn:keywords set to Id

File size: 35.7 KB

Rev	Line
[57]	1	#-- mode: python; mode: fold --
[200]	2	# $Id: Students.py 4302 2009-06-17 13:53:22Z henrik $
[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
[2125]	18
[1649]	19	from Products.AdvancedQuery import Eq, Between, Le,In
[1820]	20	import DateTime
[362]	21	import logging
[971]	22	import csv,re,os
[362]	23	import Globals
	24	p_home = Globals.package_home(globals())
	25	i_home = Globals.INSTANCE_HOME
[981]	26	MAX_TRANS = 1000
[1599]	27	from urllib import urlencode
	28
[966]	29	import DateTime
[1801]	30	#import PIL.Image
[971]	31	from StringIO import StringIO
[154]	32
[958]	33	def makeCertificateCode(code): ###(
	34	code = code.replace('.','')
	35	code = code.replace('(','')
	36	code = code.replace(')','')
	37	code = code.replace('/','')
	38	code = code.replace(' ','')
	39	code = code.replace('_','')
	40	return code
	41
	42	###)
	43
[1939]	44	def response_write(response,s): ###(
[1599]	45	response.setHeader('Content-type','text/html; charset=ISO-8859-15')
	46	while s.find('<') > -1:
	47	s = s.replace('<','<')
	48	while s.find('>') > -1:
	49	#from pdb import set_trace;set_trace()
	50	s = s.replace('>','>')
	51	response.write("%s<br>\n" % s)
	52
[1939]	53	###)
	54
[958]	55	def getInt(s): ###(
[723]	56	try:
	57	return int(s)
	58	except:
	59	return 0
[422]	60
[725]	61	def getFloat(s):
	62	try:
	63	return float(s)
	64	except:
	65	return 0.0
	66
[958]	67	###)
	68
[714]	69	def getStudentByRegNo(self,reg_no): ###(
[502]	70	"""search student by JAMB Reg No and return StudentFolder"""
[1969]	71	res = self.students_catalog(jamb_reg_no = reg_no.upper())
[1902]	72	if len(res) == 1:
	73	return getattr(self.portal_url.getPortalObject().campus.students,res[0].id)
	74	else:
[502]	75	return None
[1902]	76	# don't search in portal_catalog
	77	# search = ZCatalog.searchResults(self.portal_catalog_real,{'meta_type': 'StudentApplication',
	78	# 'SearchableText': reg_no,
	79	# })
	80	# if len(search) < 1:
	81	# return None
	82	# return search[0].getObject().aq_parent
[502]	83
[714]	84	###)
	85
[1939]	86	def checkJambNo(jnr): ###(
[1111]	87	try:
	88	if len(jnr) != 10:
	89	return False
	90	except:
	91	return False
	92	try:
	93	int(jnr[:8])
	94	return True
	95	except:
	96	return False
[1119]	97
[1939]	98	###)
	99
[2125]	100	def formatLGA(lga,voc=None):
	101	if voc is not None:
	102	if voc.has_key(lga):
	103	state,lga = voc[lga].split(' / ')
	104	elif lga.find(' / ') > -1:
	105	state,lga = lga.split(' / ')
	106	else:
	107	state,lga = "",lga
	108	return state.upper(),lga.upper()
[1939]	109
[361]	110	class StudentsFolder(CPSDocument): ###(
	111	"""
	112	WAeUP container for the various WAeUP containers data
	113	"""
[362]	114	meta_type = 'StudentsFolder'
[361]	115	portal_type = meta_type
	116	security = ClassSecurityInfo()
[154]	117
[1799]	118
[1820]	119	security.declareProtected(ModifyPortalContent,"transferStudents")###(
	120	def transferStudents(self,filename):
	121	"""
	122	load Interfaculty transferStudents Studentdata from CSV values.
	123	"""
	124	import transaction
	125	import random
	126	current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
	127	pm = self.portal_membership
	128	member = pm.getAuthenticatedMember()
	129	logger = logging.getLogger('Students.StudentsFolder.transferStudents')
	130	#students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
	131	students_folder = self.portal_url.getPortalObject().campus.students
	132	csv_fields = ('old_matric_no',
	133	'matric_no',
	134	'study_course',
	135	'current_mode',
	136	'current_level',
	137	)
	138	tr_count = 0
	139	total = 0
	140	total_imported = 0
	141	total_not_imported = 0
	142	imported = []
	143	not_imported = []
	144	certs = {}
	145	try:
	146	results = csv.DictReader(open("%s/import/%s.csv" % (i_home,filename),"rb"))
	147	except:
	148	logger.error('Error reading %s.csv' % filename)
	149	return
	150	start = True
	151	for result in results:
	152	total += 1
	153	if start:
	154	start = False
	155	logger.info('%s starts import from %s.csv' % (member,filename))
	156	import_keys = [k for k in result.keys() if not k.startswith('ignore')]
	157	diff2schema = set(import_keys).difference(set(csv_fields))
	158	if diff2schema:
	159	em = "not ignorable key(s) %s found in heading" % diff2schema
	160	return em
	161	s = ','.join(['"%s"' % fn for fn in import_keys])
	162	open("%s/import/%s_not_imported%s.csv" % (i_home,filename,current),"a").write(s + ',"Error"'+ '\n')
	163	s = '"id",' + s
	164	open("%s/import/%s_imported%s.csv" % (i_home,filename,current),"a").write(s + '\n')
	165	format = ','.join(['"%%(%s)s"' % fn for fn in import_keys])
	166	format_error = format + ',"%(Error)s"'
	167	format = '"%(id)s",'+ format
	168	old_matric_no = result.get('old_matric_no')
	169	res = self.students_catalog(matric_no = old_matric_no)
	170	result['id'] = "None"
	171	if not res:
[1834]	172	em = 'Student with matric_no %s not found' % old_matric_no
[1820]	173	logger.info(em)
[1834]	174	result['Error'] = "Student does not exist"
[1820]	175	not_imported.append(format_error % result)
	176	total_not_imported += 1
	177	continue
[3164]	178	student_record = res[0]
	179	if getattr(student_record,'review_state','') in ('courses_registered','courses_validated'):
[3146]	180	em = 'already registered course list'
[3164]	181	logger.info('%s (%s) %s' % (student_record.id, old_matric_no, em))
[3146]	182	result['Error'] = em
	183	not_imported.append( format_error % result)
	184	total_not_imported += 1
[3164]	185	continue
	186	student_object = getattr(students_folder,student_record.id)
	187	result['id'] = student_record.id
[1820]	188	cert_id = makeCertificateCode(result.get('study_course'))
	189	if cert_id not in certs.keys():
	190	res = self.portal_catalog(meta_type = "Certificate",id = cert_id)
	191	if not res:
[1834]	192	em = 'No certificate with ID %s \n' % cert_id
[1820]	193	logger.info(em)
	194	result['Error'] = "No Certificate %s" % cert_id
	195	not_imported.append( format_error % result)
	196	total_not_imported += 1
	197	continue
	198	cert = res[0]
	199	cert_path = cert.getPath().split('/')
	200	certificate = certs[cert_id] = {'faculty': cert_path[-4],
	201	'department': cert_path[-3]}
	202	cert_doc = certs[cert_id]
	203	clearance = getattr(student_object,'clearance',None)
	204	if clearance is None:
	205	em = 'Student has no clearance object'
[3164]	206	logger.info('%s (%s) %s' % (student_record.id, old_matric_no, em))
[1820]	207	result['Error'] = em
	208	not_imported.append( format_error % result)
	209	total_not_imported += 1
	210	continue
	211	clearance_doc = clearance.getContent()
	212	study_course = student_object.study_course
	213	study_course_doc = study_course.getContent()
	214	old_study_course = study_course_doc.study_course
	215	old_current_level = study_course_doc.current_level
	216	current_level = result.get('current_level',None)
[1834]	217	new_study_course = result.get('study_course',None)
[1820]	218	try:
	219	icl = int(current_level)
	220	except:
	221	em = 'Invalid new level %s' % current_level
	222	logger.info(em)
	223	result['Error'] = em
	224	not_imported.append( format_error % result)
	225	total_not_imported += 1
	226	continue
[2662]	227	try:
[2912]	228	icl = int(old_current_level)
[2662]	229	if icl == int(old_current_level) and old_study_course == new_study_course:
	230	em = 'Already transferred'
[3164]	231	logger.info('%s (%s) %s' % (student_record.id, old_matric_no, em))
[2662]	232	result['Error'] = em
	233	not_imported.append( format_error % result)
	234	total_not_imported += 1
	235	continue
	236	except:
	237	pass
[3146]	238
[1820]	239	#from pdb import set_trace; set_trace()
	240	cd = {}
	241	matric_no_history = getattr(clearance_doc,'matric_no_history',[])
	242	if not matric_no_history:
	243	matric_no_history = []
	244	matric_no_history.append(old_matric_no)
	245	cd['matric_no_history'] = matric_no_history
	246	cd['matric_no'] = result.get('matric_no')
	247	clearance_doc.edit(mapping = cd)
	248	dsc = {}
	249	study_course_history = getattr(study_course_doc,'study_course_history',[])
	250	if not study_course_history:
	251	study_course_history = []
	252	study_course_history.append(old_study_course)
	253	dsc['study_course_history'] = study_course_history
[1834]	254	dsc['study_course'] = new_study_course
[1820]	255	dsc['current_level'] = current_level
	256	dsc['current_mode'] = result.get('current_mode')
	257	study_course_doc.edit(mapping=dsc)
	258	imported.append( format % result)
	259	tr_count += 1
	260	total_imported += 1
	261	if tr_count > 1000:
	262	if len(not_imported) > 0:
	263	open("%s/import/%s_not_imported%s.csv" % (i_home,filename,current),"a").write(
	264	'\n'.join(not_imported) + '\n')
	265	not_imported = []
	266	if len(imported) > 0:
	267	open("%s/import/%s_imported%s.csv" % (i_home,filename,current),"a").write(
	268	'\n'.join(imported) + '\n')
	269	imported = []
	270	em = '%d transactions committed\n' % (tr_count)
	271	transaction.commit()
	272	regs = []
	273	logger.info(em)
	274	tr_count = 0
	275	if len(imported) > 0:
	276	open("%s/import/%s_imported%s.csv" % (i_home,filename,current),"a").write(
	277	'\n'.join(imported))
	278	if len(not_imported) > 0:
	279	open("%s/import/%s_not_imported%s.csv" % (i_home,filename,current),"a").write(
	280	'\n'.join(not_imported))
	281	em = "Imported: %d, not imported: %d of total %d" % (total_imported,total_not_imported,total)
	282	logger.info(em)
	283	return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
	284	###)
	285
[3453]	286	security.declareProtected(ModifyPortalContent,"exportStudents")###(
	287	def exportStudents(self):
	288	"""export Studentsdata to a file"""
	289	member = self.portal_membership.getAuthenticatedMember()
	290	logger = logging.getLogger('Students.exportStudents')
	291	current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
	292	students_folder = self.portal_url.getPortalObject().campus.students
	293	export_file = "%s/export/students_%s.csv" % (i_home,current)
[1146]	294
[3453]	295	from Products.AdvancedQuery import Eq, Between, Le,In,MatchRegexp
[3454]	296	#aq_students = self.students_catalog.evalAdvancedQuery
[3453]	297	toexport = {'students_catalog': ("id",
	298	"matric_no",
	299	"jamb_reg_no",
	300	"name",
	301	#"review_state",
	302	#"entry_session",
	303	#"session",
	304	#"entry_mode",
	305	#"mode",
	306	#"verdict",
	307	#"sex",
	308	#"email",
	309	#"phone",
	310	#"faculty",
	311	#"department",
	312	#"course",
	313	#"level",
	314	),
	315	#'personal': ('firstname',
	316	# 'middlename',
	317	# 'lastname',
	318	# 'perm_address',
	319	# ),
	320	'clearance': (#'state', # is not an attribute of clearance but is needed for splitting lga
	321	#'lga',
	322	'birthday',
	323	)
	324	}
	325	res_list = []
	326	lines = []
	327	fields = []
	328	with_lga = False
	329	for k in toexport.keys():
	330	for f in toexport[k]:
	331	if f == 'lga' :
	332	with_lga = True
	333	fields.append(f)
	334	headline = ','.join(fields).replace('level','current_level')
	335	open(export_file,"a").write(headline +'\n')
	336	format = '"%(' + ')s","%('.join(fields) + ')s"'
	337	#query = In('review_state',('cleared_and_validated',
	338	# 'clearance_requested',
	339	# 'school_fee_paid',
	340	# 'courses_registered',
	341	# 'courses_validated'))
	342	#query = In('review_state',('clearance_requested'))
	343	#students = aq_students(query)
[3454]	344	students = self.students_catalog()
[3453]	345	nr2export = len(students)
	346	logger.info('%s starts exportStudents, %s student records to export' % (member,nr2export))
	347	chunk = 1000
	348	total = 0
	349	start = DateTime.DateTime().timeTime()
	350	start_chunk = DateTime.DateTime().timeTime()
	351	for student in students:
	352	not_all = False
	353	d = self.getFormattedStudentEntry(student)
	354	student_obj = getattr(students_folder,student.id)
	355	for k in toexport.keys()[1:]:
	356	try:
	357	object = getattr(student_obj,k)
	358	object_doc = object.getContent()
	359	except:
	360	logger.info('%s %s record not found' % (student.id,k))
	361	not_all = True
	362	continue
	363	for f in toexport[k]:
	364	d[f] = getattr(object_doc,f,'')
	365	if not_all:
	366	continue
	367	if with_lga:
	368	d['state'],d['lga'] = formatLGA(d['lga'],voc = self.portal_vocabularies.local_gov_areas)
	369	lines.append(format % d)
	370	total += 1
	371	if total and not total % chunk or total == len(students):
	372	open(export_file,"a").write('\n'.join(lines) +'\n')
	373	anz = len(lines)
	374	logger.info("wrote %(anz)d total written %(total)d" % vars())
	375	end_chunk = DateTime.DateTime().timeTime()
	376	duration = end_chunk-start_chunk
	377	per_record = duration/anz
	378	till_now = end_chunk - start
	379	avarage_per_record = till_now/total
	380	estimated_end = DateTime.DateTime(start + avarage_per_record * nr2export)
	381	estimated_end = estimated_end.strftime("%H:%M:%S")
	382	logger.info('%(duration)4.1f, %(per_record)4.3f,end %(estimated_end)s' % vars())
	383	start_chunk = DateTime.DateTime().timeTime()
	384	lines = []
	385	end = DateTime.DateTime().timeTime()
	386	logger.info('total time %6.2f m' % ((end-start)/60))
	387	filename, extension = os.path.splitext(export_file)
	388	from subprocess import call
	389	msg = "wrote %(total)d records to %(export_file)s" % vars()
	390	try:
	391	retcode = call('gzip %s' % (export_file),shell=True)
	392	if retcode == 0:
	393	msg = "wrote %(total)d records to %(export_file)s.gz" % vars()
	394	except OSError, e:
	395	retcode = -99
	396	logger.info("zip failed with %s" % e)
	397	logger.info(msg)
	398	args = {'portal_status_message': msg}
	399	url = self.REQUEST.get('URL2')
	400	return self.REQUEST.RESPONSE.redirect(url)
	401	###)
	402
[1970]	403	security.declareProtected(ModifyPortalContent,"dumpStudentsCatalog")###(
	404	def dumpStudentsCatalog(self):
	405	"""dump all data in students_catalog to a csv"""
	406	member = self.portal_membership.getAuthenticatedMember()
	407	logger = logging.getLogger('Students.dumpStudentsCatalog')
	408	current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
	409	export_file = "%s/export/students_catalog_%s.csv" % (i_home,current)
	410	res_list = []
	411	lines = []
	412	fields = []
	413	for f in self.students_catalog.schema():
	414	fields.append(f)
[2083]	415	fields.append('state')
[1970]	416	headline = ','.join(fields)
[2128]	417	#open(export_file,"a").write(headline +'\n')
	418	out = open(export_file,"wb")
	419	out.write(headline +'\n')
	420	out.close()
	421	out = open(export_file,"a")
	422	csv_writer = csv.DictWriter(out,fields,)
[1970]	423	format = '"%(' + ')s","%('.join(fields) + ')s"'
	424	students = self.students_catalog()
	425	nr2export = len(students)
[2012]	426	logger.info('%s starts dumpStudentsCatalog, %s student records to export' % (member,nr2export))
[1970]	427	chunk = 2000
	428	total = 0
	429	start = DateTime.DateTime().timeTime()
	430	start_chunk = DateTime.DateTime().timeTime()
	431	for student in students:
	432	not_all = False
	433	d = self.getFormattedStudentEntry(student)
[2125]	434	d['state'],d['lga'] = formatLGA(d['lga'],voc = self.portal_vocabularies.local_gov_areas)
[2128]	435	#lines.append(format % d)
	436	lines.append(d)
[1970]	437	total += 1
	438	if total and not total % chunk or total == len(students):
[2128]	439	#open(export_file,"a").write('\n'.join(lines) +'\n')
	440	csv_writer.writerows(lines)
[1970]	441	anz = len(lines)
	442	logger.info("wrote %(anz)d total written %(total)d" % vars())
	443	end_chunk = DateTime.DateTime().timeTime()
	444	duration = end_chunk-start_chunk
	445	per_record = duration/anz
	446	till_now = end_chunk - start
	447	avarage_per_record = till_now/total
	448	estimated_end = DateTime.DateTime(start + avarage_per_record * nr2export)
	449	estimated_end = estimated_end.strftime("%H:%M:%S")
	450	logger.info('%(duration)4.1f, %(per_record)4.3f,end %(estimated_end)s' % vars())
	451	start_chunk = DateTime.DateTime().timeTime()
	452	lines = []
	453	end = DateTime.DateTime().timeTime()
	454	logger.info('total time %6.2f m' % ((end-start)/60))
	455	filename, extension = os.path.splitext(export_file)
	456	from subprocess import call
	457	msg = "wrote %(total)d records to %(export_file)s" % vars()
	458	try:
	459	retcode = call('gzip %s' % (export_file),shell=True)
	460	if retcode == 0:
	461	msg = "wrote %(total)d records to %(export_file)s.gz" % vars()
	462	except OSError, e:
	463	retcode = -99
	464	logger.info("zip failed with %s" % e)
	465	logger.info(msg)
	466	args = {'portal_status_message': msg}
	467	#url = self.REQUEST.get('URL1') + '?' + urlencode(args)
	468	url = self.REQUEST.get('URL2')
	469	return self.REQUEST.RESPONSE.redirect(url)
	470	###)
	471
	472
[1146]	473	security.declareProtected(ModifyPortalContent,"importResults")###(
	474	def importResults(self):
[1151]	475	"""load Returning Students Results from CSV"""
[1146]	476	import transaction
	477	import random
	478	#from pdb import set_trace
	479	wftool = self.portal_workflow
	480	current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
[1802]	481	#students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
	482	students_folder = self.portal_url.getPortalObject().campus.students
[1146]	483	tr_count = 1
[2072]	484	total = 0
[1146]	485	#name = 'pume_results'
	486	name = 'Results'
	487	table = self.results_import
	488	no_import = []
	489	imported = []
[1571]	490	logger = logging.getLogger('Students.StudentsFolder.importResults')
[1146]	491	try:
	492	results = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
	493	except:
	494	logger.error('Error reading %s.csv' % name)
	495	return
[2071]	496
[1146]	497	l = self.portal_catalog({'meta_type': "Course"})
	498	courses = [f.getId for f in l]
	499	start = True
	500	res = table()
	501	regs = []
	502	if len(res) > 0:
	503	regs = [s.key for s in res]
	504	no_course = []
	505	no_course_list = []
	506	course_count = 0
	507	for result in results:
	508	if start:
	509	start = False
[1571]	510	logger.info('Start loading from %s.csv' % name)
[1321]	511	s = ','.join(['"%s"' % fn for fn in result.keys()])
[1146]	512	imported.append(s)
	513	no_import.append('%s,"Error"' % s)
	514	format = ','.join(['"%%(%s)s"' % fn for fn in result.keys()])
	515	format_error = format + ',"%(Error)s"'
	516	no_certificate = "no certificate %s" % format
	517	course_id = result.get('CosCode')
[1448]	518	if not course_id:
	519	course_id = 'N/A'
	520	result['CosCode'] = course_id
[1168]	521	matric_no = result.get('matric_no').upper()
	522	result['matric_no'] = matric_no
	523	key = matric_no+course_id
	524	if matric_no == '':
[1252]	525	result['Error'] = "Empty matric_no"
[1146]	526	no_import.append( format_error % result)
	527	continue
[1168]	528	if key in regs or self.results_import(key = key):
[1252]	529	result['Error'] = "Duplicate"
[1146]	530	no_import.append( format_error % result)
	531	continue
	532	if course_id not in courses:
	533	if course_id not in no_course:
	534	course_count +=1
	535	no_course.append(course_id)
	536	no_course_list.append('"%s"' % course_id)
	537	#result['Error'] = "No Course"
	538	#logger.info(format_error % result)
[1829]	539
[1816]	540	result['key'] = key
	541	try:
	542	table.addRecord(**result)
	543	except ValueError:
	544	#import pdb;pdb.set_trace()
	545	result['Error'] = "Duplicate"
	546	no_import.append( format_error % result)
	547	continue
[1829]	548
[1146]	549	regs.append(key)
	550	imported.append(format % result)
	551	tr_count += 1
	552	if tr_count > 1000:
	553	if len(no_import) > 0:
	554	open("%s/import/%s_not_imported%s.csv" % (i_home,name,current),"a").write(
[1151]	555	'\n'.join(no_import)+'\n')
[1146]	556	no_import = []
	557	open("%s/import/%simported%s.csv" % (i_home,name,current),"a").write(
[1151]	558	'\n'.join(imported) + '\n')
[1146]	559	imported = []
	560	if no_course_list:
	561	open("%s/import/%sno_courses%s.csv" % (i_home,name,current),"a").write(
[1151]	562	'\n'.join(no_course_list) + '\n')
[1146]	563	no_course_list = []
	564	transaction.commit()
[1168]	565	regs = []
[2072]	566	total += tr_count
[2080]	567	em = '%d transactions totally comitted, %s courses not found ' % (total,course_count)
	568	logger.info(em)
[2072]	569	tr_count = 0
[1146]	570	open("%s/import/%simported%s.csv" % (i_home,name,current),"a").write(
	571	'\n'.join(imported))
	572	open("%s/import/%s_not_imported%s.csv" % (i_home,name,current),"a").write(
	573	'\n'.join(no_import))
	574	if no_course_list:
	575	open("%s/import/%sno_courses%s.csv" % (i_home,name,current),"a").write(
	576	'\n'.join(no_course_list))
[2072]	577	em = '%d transactions totally committed, %s courses not found ' % (total,course_count)
[1393]	578	logger.info(em)
[1146]	579	return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
	580	###)
	581
[1065]	582
[2654]	583
[1594]	584	security.declareProtected(View,"fixOwnership") ###(
[511]	585	def fixOwnership(self):
	586	"""fix Ownership"""
	587	for s in self.portal_catalog(meta_type = 'Student'):
	588	student = s.getObject()
	589	sid = s.getId
	590	import pdb;pdb.set_trace()
	591	student.application.manage_setLocalRoles(sid, ['Owner',])
	592	student.personal.manage_setLocalRoles(sid, ['Owner',])
[1594]	593	###)
[603]	594
[1594]	595	security.declareProtected(View,"Title") ###(
[364]	596	def Title(self):
	597	"""compose title"""
[382]	598	return "Student Section"
[1594]	599	###)
[361]	600
[4302]	601	#def generateStudentId(self,letter,students = None): ###(
	602	# import random
	603	# r = random
	604	# if students is None:
	605	# students = self.portal_url.getPortalObject().campus.students
	606	# if letter not in ('ABCDEFGIHKLMNOPQRSTUVWXY'):
	607	# letter= r.choice('ABCDEFGHKLMNPQRSTUVWXY')
	608	# sid = "%c%d" % (letter,r.randint(99999,1000000))
	609	# while hasattr(students, sid):
	610	# sid = "%c%d" % (letter,r.randint(99999,1000000))
	611	# return sid
	612	# #return "%c%d" % (r.choice('ABCDEFGHKLMNPQRSTUVWXY'),r.randint(99999,1000000))
	613	####)
[714]	614
[361]	615	InitializeClass(StudentsFolder)
	616
[1594]	617	def addStudentsFolder(container, id, REQUEST=None, **kw): ###(
[361]	618	"""Add a Student."""
	619	ob = StudentsFolder(id, **kw)
	620	return CPSBase_adder(container, ob, REQUEST=REQUEST)
[1594]	621	###)
	622
[361]	623	###)
	624
[57]	625	class Student(CPSDocument): ###(
	626	"""
[154]	627	WAeUP Student container for the various student data
[57]	628	"""
	629	meta_type = 'Student'
	630	portal_type = meta_type
	631	security = ClassSecurityInfo()
[154]	632
[3447]	633	# security.declareProtected(View,"Title")
	634	# def Title(self):
	635	# """compose title"""
	636	# reg_nr = self.getId()[1:]
	637	# data = getattr(self,'personal',None)
	638	# if data:
	639	# content = data.getContent()
	640	# return "%s %s %s" % (content.firstname,content.middlename,content.lastname)
	641	# data = getattr(self,'application',None)
	642	# if data:
	643	# content = data.getContent()
	644	# return "%s" % (content.jamb_lastname)
	645	# return self.title
[154]	646
[511]	647	security.declarePrivate('makeStudentMember') ###(
	648	def makeStudentMember(self,sid,password='uNsEt'):
	649	"""make the student a member"""
	650	membership = self.portal_membership
[603]	651	membership.addMember(sid,
[511]	652	password ,
	653	roles=('Member',
	654	'Student',
[522]	655	),
[511]	656	domains='',
[904]	657	properties = {'memberareaCreationFlag': False,
	658	'homeless': True},)
[511]	659	member = membership.getMemberById(sid)
	660	self.portal_registration.afterAdd(member, sid, password, None)
	661	self.manage_setLocalRoles(sid, ['Owner',])
	662
	663	###)
	664
[764]	665	security.declareProtected(View,'createSubObjects') ###(
	666	def createSubObjects(self):
	667	"""make the student a member"""
[3481]	668	#dp = {'Title': 'Personal Data'}
[764]	669	app_doc = self.application.getContent()
	670	names = app_doc.jamb_lastname.split()
	671	if len(names) == 3:
	672	dp['firstname'] = names[0].capitalize()
	673	dp['middlename'] = names[1].capitalize()
	674	dp['lastname'] = names[2].capitalize()
	675	elif len(names) == 2:
	676	dp['firstname'] = names[0].capitalize()
	677	dp['lastname'] = names[1].capitalize()
	678	else:
	679	dp['lastname'] = app_doc.jamb_lastname
	680	dp['sex'] = app_doc.jamb_sex == 'F'
	681	dp['lga'] = "%s/%s" % (app_doc.jamb_state,app_doc.jamb_lga )
	682	proxy = self.aq_parent
	683	proxy.invokeFactory('StudentPersonal','personal')
	684	per = proxy.personal
	685	per_doc = per.getContent()
	686	per_doc.edit(mapping = dp)
[927]	687	per.manage_setLocalRoles(proxy.getId(), ['Owner',])
[764]	688	#self.portal_workflow.doActionFor(per,'open',dest_container=per)
[603]	689
[511]	690	###)
	691
[57]	692	InitializeClass(Student)
	693
	694	def addStudent(container, id, REQUEST=None, **kw):
	695	"""Add a Student."""
	696	ob = Student(id, **kw)
	697	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	698
	699	###)
[91]	700
[639]	701	class StudentAccommodation(CPSDocument): ###(
	702	"""
	703	WAeUP Student container for the various student data
	704	"""
	705	meta_type = 'StudentAccommodation'
	706	portal_type = meta_type
	707	security = ClassSecurityInfo()
	708
[3473]	709	# security.declareProtected(View,"Title")
	710	# def Title(self):
	711	# """compose title"""
	712	# content = self.getContent()
	713	# session_id = content.session
	714	# try:
	715	# y = int(session_id[-2:])
	716	# except:
	717	# return "Accommodation Data for Session %s" % session_id
	718	# session_str = self.portal_vocabularies.sessions.get(y)
	719	# #return "Accommodation Data for %s %s" % (content.firstname,content.lastname)
	720	# return "Accommodation Data for Session %s" % session_str
[639]	721
	722
	723	InitializeClass(StudentAccommodation)
	724
	725	def addStudentAccommodation(container, id, REQUEST=None, **kw):
	726	"""Add a Students personal data."""
	727	ob = StudentAccommodation(id, **kw)
	728	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	729
	730	###)
	731
[89]	732	class StudentPersonal(CPSDocument): ###(
	733	"""
[154]	734	WAeUP Student container for the various student data
[89]	735	"""
	736	meta_type = 'StudentPersonal'
	737	portal_type = meta_type
	738	security = ClassSecurityInfo()
[152]	739
[3473]	740	# security.declareProtected(View,"Title")
	741	# def Title(self):
	742	# """compose title"""
	743	# #content = self.getContent()
	744	# #return "Personal Data for %s %s" % (content.firstname,content.lastname)
	745	# return "Personal Data"
[152]	746
[154]	747
[89]	748	InitializeClass(StudentPersonal)
	749
	750	def addStudentPersonal(container, id, REQUEST=None, **kw):
	751	"""Add a Students personal data."""
	752	ob = StudentPersonal(id, **kw)
	753	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	754
	755	###)
	756
[423]	757	class StudentClearance(CPSDocument): ###(
	758	"""
	759	WAeUP Student container for the various student data
	760	"""
	761	meta_type = 'StudentClearance'
	762	portal_type = meta_type
	763	security = ClassSecurityInfo()
	764
[3473]	765	# security.declareProtected(View,"Title")
	766	# def Title(self):
	767	# """compose title"""
	768	# #content = self.getContent()
	769	# #return "Clearance/Eligibility Record for %s %s" % (content.firstname,content.lastname)
	770	# return "Clearance/Eligibility Record"
[423]	771
	772
	773	InitializeClass(StudentClearance)
	774
	775	def addStudentClearance(container, id, REQUEST=None, **kw):
	776	"""Add a Students personal data."""
	777	ob = StudentClearance(id, **kw)
	778	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	779
	780	###)
	781
[454]	782	class StudentStudyLevel(CPSDocument): ###(
	783	"""
	784	WAeUP Student container for the various student data
	785	"""
	786	meta_type = 'StudentStudyLevel'
	787	portal_type = meta_type
	788	security = ClassSecurityInfo()
	789
[3473]	790	# security.declareProtected(View,"Title")
	791	# def Title(self):
	792	# """compose title"""
	793	# return self.portal_vocabularies.student_levels.get(self.aq_parent.getId())
	794	# #return "Level %s" % self.aq_parent.getId()
[454]	795
[1700]	796	def create_course_results(self,cert_id,current_level): ###(
[1649]	797	"create all courses in a level"
	798	aq_portal = self.portal_catalog.evalAdvancedQuery
	799	res = self.portal_catalog(portal_type="Certificate", id = cert_id)
	800	l = []
	801	import transaction
	802	if res:
	803	cert = res[0]
	804	path = cert.getPath()
	805	query = Eq("path","%s/%s" % (path,current_level)) &\
	806	Eq('portal_type','CertificateCourse')
	807	courses = aq_portal(query)
	808	#from pdb import set_trace;set_trace()
	809	self_proxy = self.aq_parent
	810	for c in courses:
	811	d = self.getCourseInfo(c.getId)
	812	cr_id = self_proxy.invokeFactory('StudentCourseResult',c.getId)
	813	course_result = getattr(self_proxy,cr_id)
	814	self.portal_workflow.doActionFor(course_result,'open')
	815	d['core_or_elective'] = getattr(c.getObject().getContent(),'core_or_elective')
	816	course_result.getContent().edit(mapping=d)
[1820]	817	#transaction.commit()
[1700]	818	###)
[472]	819
[454]	820	InitializeClass(StudentStudyLevel)
	821
	822	def addStudentStudyLevel(container, id, REQUEST=None, **kw):
	823	"""Add a Students personal data."""
	824	ob = StudentStudyLevel(id, **kw)
	825	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	826
	827	###)
	828
[362]	829	class StudentStudyCourse(CPSDocument): ###(
	830	"""
	831	WAeUP Student container for the various student data
	832	"""
	833	meta_type = 'StudentStudyCourse'
	834	portal_type = meta_type
	835	security = ClassSecurityInfo()
	836
[3473]	837	# security.declareProtected(View,"Title")
	838	# def Title(self):
	839	# """compose title"""
	840	# #content = self.getContent()
	841	# return "Study Course"
[362]	842
	843
	844	InitializeClass(StudentStudyCourse)
	845
	846	def addStudentStudyCourse(container, id, REQUEST=None, **kw):
	847	"""Add a Students personal data."""
	848	ob = StudentStudyCourse(id, **kw)
	849	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	850
	851	###)
	852
[472]	853	class StudentApplication(CPSDocument): ###(
[179]	854	"""
	855	WAeUP Student container for the various student data
	856	"""
[472]	857	meta_type = 'StudentApplication'
[179]	858	portal_type = meta_type
	859	security = ClassSecurityInfo()
	860
[3473]	861	# security.declareProtected(View,"Title")
	862	# def Title(self):
	863	# """compose title"""
	864	# return "Application Data"
[179]	865
[181]	866
[472]	867	InitializeClass(StudentApplication)
[179]	868
[472]	869	def addStudentApplication(container, id, REQUEST=None, **kw):
[179]	870	"""Add a Students eligibility data."""
[472]	871	ob = StudentApplication(id, **kw)
[179]	872	return CPSBase_adder(container, ob, REQUEST=REQUEST)
[763]	873	###)
[179]	874
[758]	875
[464]	876	class StudentCourseResult(CPSDocument): ###(
[89]	877	"""
[464]	878	WAeUP StudentCourseResult
[89]	879	"""
[464]	880	meta_type = 'StudentCourseResult'
[89]	881	portal_type = meta_type
	882	security = ClassSecurityInfo()
[472]	883
[454]	884	def getCourseEntry(self,cid):
[723]	885	res = self.portal_catalog({'meta_type': "Course",
[454]	886	'id': cid})
	887	if res:
	888	return res[-1]
	889	else:
	890	return None
[154]	891
[3473]	892	# security.declareProtected(View,"Title")
	893	# def Title(self):
	894	# """compose title"""
	895	# cid = self.aq_parent.getId()
	896	# ce = self.getCourseEntry(cid)
	897	# if ce:
	898	# return "%s" % ce.Title
	899	# return "No course with id %s" % cid
[3481]	900
[464]	901	InitializeClass(StudentCourseResult)
[454]	902
[464]	903	def addStudentCourseResult(container, id, REQUEST=None, **kw):
	904	"""Add a StudentCourseResult."""
	905	ob = StudentCourseResult(id, **kw)
[89]	906	return CPSBase_adder(container, ob, REQUEST=REQUEST)
[139]	907	###)
	908
[3682]	909
[2912]	910	class StudentPume(CPSDocument): ###(
	911	"""
	912	WAeUP Student container for the various student data
	913	"""
	914	meta_type = 'StudentPume'
	915	portal_type = meta_type
	916	security = ClassSecurityInfo()
	917
[3473]	918	# security.declareProtected(View,"Title")
	919	# def Title(self):
	920	# """compose title"""
	921	# return "PUME Results"
[2912]	922
	923
	924	InitializeClass(StudentPume)
	925
	926	def addStudentPume(container, id, REQUEST=None, **kw):
	927	"""Add a Students PUME data."""
	928	ob = StudentPume(id, **kw)
	929	return CPSBase_adder(container, ob, REQUEST=REQUEST)
[3682]	930	###)
[2912]	931
	932
[3682]	933	class StudentPastoralReport(CPSDocument): ###(
	934	"""
	935	Student Pastoral Report
	936	"""
	937	meta_type = 'StudentPastoralReport'
	938	portal_type = meta_type
	939	security = ClassSecurityInfo()
[2912]	940
[3682]	941	InitializeClass(StudentPastoralReport)
	942
	943	def addStudentPastoralReport(container, id, REQUEST=None, **kw):
	944	"""Add a Student Pastoral Report."""
	945	ob = StudentPastoralReport(id, **kw)
	946	return CPSBase_adder(container, ob, REQUEST=REQUEST)
	947	###)
	948
[579]	949	# Backward Compatibility StudyLevel
	950
	951	from Products.WAeUP_SRP.Academics import StudyLevel
	952
	953	from Products.WAeUP_SRP.Academics import addStudyLevel
	954

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

Download in other formats: