def personality_type_report(request):
if (not request.user.groups.filter(name='Instructors')
and not request.user.groups.filter(name='Counselors')):
raise Http403
if request.method == "POST":
form = DateRangeForm(request.POST)
if form.is_valid():
results = PersonalityTypeResult.objects.filter(
date_taken__range=(
datetime.combine(form.cleaned_data['from_date'], time.min),
datetime.combine(form.cleaned_data['to_date'], time.max),
)
)
if results:
if results.count() > settings.REPORT_MAX_ROWS:
results = results[:settings.REPORT_MAX_ROWS]
filename = ('personality_type-%s-%s.xls'
% (form.cleaned_data['from_date'].strftime('%Y%m%d'),
form.cleaned_data['to_date'].strftime('%Y%m%d')))
columns = ('User Index', 'Student Username', 'Date Taken',
'Personality Type', 'First Category Score',
'Second Category Score', 'Third Category Score',
'Fourth Category Score')
rows = []
for result in results:
row = (result.student.id,
result.student.username,
result.date_taken.strftime('%m/%d/%Y'),
result.personality_type,
result.first_category_score,
result.second_category_score,
result.third_category_score,
result.fourth_category_score)
rows.append(row)
return generate_xls_report(filename, 'Personality Type Report', columns, rows)
return direct_to_template(request, 'reports/report_form.html', {
'error': True,
'personality': True,
'max_rows': settings.REPORT_MAX_ROWS,
})
return direct_to_template(request, 'reports/report_form.html', {
'personality': True,
'max_rows': settings.REPORT_MAX_ROWS,
})
def learning_style_report(request):
if (not request.user.groups.filter(name='Instructors')
and not request.user.groups.filter(name='Counselors')):
raise Http403
if request.method == "POST":
form = DateRangeForm(request.POST)
if form.is_valid():
results = LearningStyleResult.objects.filter(
date_taken__range=(
datetime.combine(form.cleaned_data['from_date'], time.min),
datetime.combine(form.cleaned_data['to_date'], time.max),
)
)
if results:
if results.count() > settings.REPORT_MAX_ROWS:
results = results[:settings.REPORT_MAX_ROWS]
filename = ('learning_style-%s-%s.xls'
% (form.cleaned_data['from_date'].strftime('%Y%m%d'),
form.cleaned_data['to_date'].strftime('%Y%m%d')))
columns = ('User Index', 'Student Username', 'Date Taken',
'Learning Style', 'Kinesthetic', 'Visual', 'Auditory')
rows = []
for result in results:
row = (result.student.id,
result.student.username,
result.date_taken.strftime('%m/%d/%Y'),
result.learning_style,
result.kinesthetic_score,
result.visual_score,
result.auditory_score)
rows.append(row)
return generate_xls_report(filename, 'Learning Style Report', columns, rows)
return direct_to_template(request, 'reports/report_form.html', {
'error': True,
'learning': True,
'max_rows': settings.REPORT_MAX_ROWS,
})
return direct_to_template(request, 'reports/report_form.html', {
'learning': True,
'max_rows': settings.REPORT_MAX_ROWS,
})
def visit_report(request):
if (not request.user.groups.filter(name='Instructors')
and not request.user.groups.filter(name='Counselors')):
raise Http403
if request.method == "POST":
form = DateRangeForm(request.POST)
if form.is_valid():
results = Visit.objects.filter(date_submitted__range=(
datetime.combine(form.cleaned_data['from_date'], time.min),
datetime.combine(form.cleaned_data['to_date'], time.max),
))
if results:
if results.count() > settings.REPORT_MAX_ROWS:
results = results[:settings.REPORT_MAX_ROWS]
filename = ('visit-%s-%s.xls' %
(form.cleaned_data['from_date'].strftime('%Y%m%d'),
form.cleaned_data['to_date'].strftime('%Y%m%d')))
columns = ('Visit Index',
'Date Submitted',
'Student ID Number',
'Student First Name',
'Student Last Name',
'Undecided Financial Aid',
'Note',
'Reason',
'Contact Type',
'Campus',
'Counselor Username',
'Counselor First Name',
'Counselor Last Name',
'Department',
'Career Services Outcome',
'After Five',)
rows = []
for result in results:
row = (result.id,
result.date_submitted.strftime('%m/%d/%Y %H:%M'),
result.student.profile.id_number,
result.student.first_name,
result.student.last_name,
'Yes' if result.undecided_financial_aid else 'No',
'Private note.' if result.private else truncate(request, result, result.note, settings.NOTE_MAX_CHARS),
result.reason,
result.contact_type,
result.campus,
result.submitter.username,
result.submitter.first_name,
result.submitter.last_name,
result.department,
result.career_services_outcome,
'Yes' if result.date_submitted.hour > 16 else 'No',)
rows.append(row)
return generate_xls_report(filename,
'Visit Report',
columns,
rows)
return direct_to_template(request, 'reports/report_form.html', {
'error': True,
'visit': True,
'max_rows': settings.REPORT_MAX_ROWS,
})
return direct_to_template(request, 'reports/report_form.html', {
'visit': True,
'max_rows': settings.REPORT_MAX_ROWS,
})
