def student_transfers_data(request, userid):
"""
AJAX request for transfer data, etc. (queries SIMS directly)
"""
student = get_object_or_404(Person, find_userid_or_emplid(userid))
try:
data = transfer_data(student.emplid)
except SIMSProblem as e:
data = {'error': str(e)}
response = HttpResponse(content_type='application/json;charset=utf-8')
json.dump(data, response, indent=1)
return response
def student_transfers_data(request, userid):
"""
AJAX request for transfer data, etc. (queries SIMS directly)
"""
student = get_object_or_404(Person, find_userid_or_emplid(userid))
try:
data = transfer_data(student.emplid)
except SIMSProblem as e:
data = {'error': str(e)}
response = HttpResponse(content_type='application/json;charset=utf-8')
json.dump(data, response, indent=1)
return response
def student_transfers_download(request, userid):
student = get_object_or_404(Person, find_userid_or_emplid(userid))
try:
data = transfer_data(student.emplid)
except SIMSProblem as e:
data = {'error': str(e)}
response = HttpResponse(content_type='text/csv')
response[
'Content-Disposition'] = 'inline; filename="%s-%s-transfers.csv"' % (
userid, datetime.datetime.now().strftime('%Y%m%d'))
writer = csv.writer(response)
writer.writerow(['Employee ID', 'Last Name', 'First Name'])
writer.writerow([student.emplid, student.last_name, student.first_name])
writer.writerow([])
writer.writerow([
'Description', 'School Subject', 'Course Number',
'Transfer Equivalency Group', 'Transfer Status', 'Subject',
'Catalogue Number', 'Transfer Grade Input', 'Transfer Official Grade',
'External Grade Input', 'External Official Grade', 'Units Transferred'
])
if 'transfers' in data:
for trns in data['transfers']:
descr = trns.get('descr') or ''
school_subject = trns.get('school_subject') or ''
crse_nbr = trns.get('crse_nbr') or ''
trsnf_equivlncy_grp = trns.get('trsnf_equivlncy_grp') or ''
transfr_stat = trns.get('transfr_stat') or ''
subject = trns.get('subject') or ''
catalog_nbr = trns.get('catalog_nbr') or ''
tcd_grade_input = trns.get('tcd_grade_input') or ''
tcd_grade_off = trns.get('tcd_grade_off') or ''
ec_grade_input = trns.get('ec_grade_input') or ''
ec_grade_off = trns.get('ec_grade_off') or ''
unt_trnsfr = trns.get('unt_trnsfr') or 0
writer.writerow([
descr, school_subject, crse_nbr, trsnf_equivlncy_grp,
transfr_stat, subject, catalog_nbr, tcd_grade_input,
tcd_grade_off, ec_grade_input, ec_grade_off, unt_trnsfr
])
return response
def student_transfers_download(request, userid):
student = get_object_or_404(Person, find_userid_or_emplid(userid))
try:
data = transfer_data(student.emplid)
except SIMSProblem as e:
data = {'error': str(e)}
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'inline; filename="%s-%s-transfers.csv"' % (userid,
datetime.datetime.now().strftime('%Y%m%d'))
writer = csv.writer(response)
writer.writerow(['Employee ID', 'Last Name', 'First Name'])
writer.writerow([student.emplid, student.last_name, student.first_name])
writer.writerow([])
writer.writerow(['Description', 'School Subject', 'Course Number', 'Transfer Equivalency Group', 'Transfer Status',
'Subject', 'Catalogue Number', 'Transfer Grade Input', 'Transfer Official Grade',
'External Grade Input', 'External Official Grade', 'Units Transferred'])
if 'transfers' in data:
for trns in data['transfers']:
descr = trns.get('descr') or ''
school_subject = trns.get('school_subject') or ''
crse_nbr = trns.get('crse_nbr') or ''
trsnf_equivlncy_grp = trns.get('trsnf_equivlncy_grp') or ''
transfr_stat = trns.get('transfr_stat') or ''
subject = trns.get('subject') or ''
catalog_nbr = trns.get('catalog_nbr') or ''
tcd_grade_input = trns.get('tcd_grade_input') or ''
tcd_grade_off = trns.get('tcd_grade_off') or ''
ec_grade_input = trns.get('ec_grade_input') or ''
ec_grade_off = trns.get('ec_grade_off') or ''
unt_trnsfr = trns.get('unt_trnsfr') or 0
writer.writerow([descr, school_subject, crse_nbr, trsnf_equivlncy_grp, transfr_stat, subject, catalog_nbr,
tcd_grade_input, tcd_grade_off, ec_grade_input, ec_grade_off, unt_trnsfr])
return response