def attendance_student(request, id, all_years=False, order_by="Date", include_private_notes=False):
""" Attendance report on particular student """
from ecwsp.sis.template_report import TemplateReport
report = TemplateReport(request.user)
student = Student.objects.get(id=id)
if all_years:
attendances = StudentAttendance.objects.filter(student=student)
else:
active_year = SchoolYear.objects.get(active_year=True)
active_year_dates = (active_year.start_date, active_year.end_date)
attendances = StudentAttendance.objects.filter(student=student, date__range=active_year_dates)
if order_by == "Status": attendances = attendances.order_by('status')
report.data['attendances'] = []
for attn in attendances:
if include_private_notes:
notes = unicode(attn.notes) + " " + unicode(attn.private_notes)
else:
notes = unicode(attn.notes)
attendance = Struct()
attendance.date = attn.date
attendance.status = attn.status
attendance.notes = notes
report.data['attendances'].append(attendance)
# data['attendances'] = attendances
report.data['student'] = student
report.data['student_year'] = student.year
template = Template.objects.get_or_create(name="Student Attendance Report")[0]
template = template.get_template_path(request)
report.filename = unicode(student) + "_Attendance"
return report.pod_save(template)
def download_student_results(self, test, format, template):
""" Make appy based report showing results for each student """
data = get_default_data()
test_instances = test.testinstance_set.all()
benchmarks = Benchmark.objects.filter(question__test=test)
for benchmark in benchmarks:
benchmark.points_possible = test.question_set.filter(benchmarks=benchmark).aggregate(Sum('point_value'))['point_value__sum']
for test_instance in test_instances:
benchmark_instances = []
for benchmark in benchmarks:
benchmark_instance = Struct()
benchmark_instance.benchmark = benchmark
benchmark_instance.points_possible = benchmark.points_possible
benchmark_instance.points_earned = test_instance.answerinstance_set.filter(question__benchmarks=benchmark).aggregate(Sum('points_earned'))['points_earned__sum']
benchmark_instances.append(benchmark_instance)
test_instance.benchmarks = benchmark_instances
test_instance.incorrects = test_instance.answerinstance_set.filter(points_earned__lt=F('points_possible'))
for incorrect in test_instance.incorrects:
try:
incorrect.right_answer = incorrect.question.answer_set.order_by('point_value').reverse()[0]
except:
incorrect.right_answer = "No correct answer"
data['test'] = test
data['tests'] = test_instances
filename = 'Student Results for ' + unicode(test)
return pod_save(filename, "." + str(format), data, template)
def attendance_student(id, all_years=False, order_by="Date", include_private_notes=False, type="odt"):
""" Attendance report on particular student """
from ecwsp.sis.report import get_default_data, pod_save
student = Student.objects.get(id=id)
if all_years:
attendances = StudentAttendance.objects.filter(student=student)
else:
active_year = SchoolYear.objects.get(active_year=True)
active_year_dates = (active_year.start_date, active_year.end_date)
attendances = StudentAttendance.objects.filter(student=student, date__range=active_year_dates)
if order_by == "Status": attendances = attendances.order_by('status')
data = get_default_data()
data['attendances'] = []
for attn in attendances:
if include_private_notes:
notes = unicode(attn.notes) + " " + unicode(attn.private_notes)
else:
notes = unicode(attn.notes)
attendance = Struct()
attendance.date = attn.date
attendance.status = attn.status
attendance.notes = notes
data['attendances'].append(attendance)
# data['attendances'] = attendances
data['student'] = student
data['student_year'] = student.year
template = Template.objects.get_or_create(name="Student Attendance Report")[0]
filename = unicode(student) + "_Attendance"
return pod_save(filename, "." + str(type), data, template.file.path)
def attendance_student(request, id, all_years=False, order_by="Date", include_private_notes=False):
""" Attendance report on particular student """
from ecwsp.sis.template_report import TemplateReport
report = TemplateReport(request.user)
student = Student.objects.get(id=id)
if all_years:
attendances = StudentAttendance.objects.filter(student=student)
else:
active_year = SchoolYear.objects.get(active_year=True)
active_year_dates = (active_year.start_date, active_year.end_date)
attendances = StudentAttendance.objects.filter(student=student, date__range=active_year_dates)
if order_by == "Status": attendances = attendances.order_by('status')
report.data['attendances'] = []
for attn in attendances:
if include_private_notes:
notes = unicode(attn.notes) + " " + unicode(attn.private_notes)
else:
notes = unicode(attn.notes)
attendance = Struct()
attendance.date = attn.date
attendance.status = attn.status
attendance.notes = notes
report.data['attendances'].append(attendance)
# data['attendances'] = attendances
report.data['student'] = student
report.data['students'] = [student]
report.data['student_year'] = student.year
template = Template.objects.get_or_create(name="Student Attendance Report")[0]
template = template.get_template_path(request)
report.filename = unicode(student) + "_Attendance"
return report.pod_save(template)
def attendance_student(id, all_years=False, order_by="Date", include_private_notes=False, type="odt"):
""" Attendance report on particular student """
from ecwsp.sis.report import get_default_data, pod_save
student = Student.objects.get(id=id)
if all_years:
attendances = StudentAttendance.objects.filter(student=student)
else:
active_year = SchoolYear.objects.get(active_year=True)
active_year_dates = (active_year.start_date, active_year.end_date)
attendances = StudentAttendance.objects.filter(student=student, date__range=active_year_dates)
if order_by == "Status": attendances = attendances.order_by('status')
data = get_default_data()
data['attendances'] = []
for attn in attendances:
if include_private_notes:
notes = unicode(attn.notes) + " " + unicode(attn.private_notes)
else:
notes = unicode(attn.notes)
attendance = Struct()
attendance.date = attn.date
attendance.status = attn.status
attendance.notes = notes
data['attendances'].append(attendance)
# data['attendances'] = attendances
data['student'] = student
data['student_year'] = student.year
template = Template.objects.get_or_create(name="Student Attendance Report")[0]
filename = unicode(student) + "_Attendance"
return pod_save(filename, "." + str(type), data, template.file.path)
def download_student_results(self, test, format, template, cohorts=None):
""" Make appy based report showing results for each student """
report = TemplateReport()
report.file_format = format
if cohorts:
test_instances = test.active_testinstance_set.filter(
student__cohort__in=cohorts).distinct()
else:
test_instances = test.active_testinstance_set.all()
benchmarks = Benchmark.objects.filter(question__test=test).distinct()
for benchmark in benchmarks:
benchmark.points_possible = test.question_set.filter(
benchmarks=benchmark).aggregate(
Sum('point_value'))['point_value__sum']
# aggregate() may return None, which will raise a TypeError upon attempting arithmetic
if benchmark.points_possible is None:
benchmark.points_possible = 0
for test_instance in test_instances:
benchmark_instances = []
for benchmark in benchmarks:
benchmark_instance = Struct()
benchmark_instance.benchmark = benchmark
benchmark_instance.points_possible = benchmark.points_possible
benchmark_instance.answers = test_instance.answerinstance_set.filter(
question__benchmarks=benchmark)
benchmark_instance.points_earned = benchmark_instance.answers.aggregate(
Sum('points_earned'))['points_earned__sum']
# aggregate() may return None, which will raise a TypeError upon attempting arithmetic
if benchmark_instance.points_earned is None:
benchmark_instance.points_earned = 0
benchmark_instance.questions = ''
for answer in benchmark_instance.answers.all():
benchmark_instance.questions += '{}, '.format(
answer.question.get_order_start_one)
benchmark_instance.questions = benchmark_instance.questions[:
-2]
benchmark_instances.append(benchmark_instance)
test_instance.benchmarks = benchmark_instances
test_instance.incorrects = test_instance.answerinstance_set.filter(
points_earned__lt=F('points_possible'))
for incorrect in test_instance.incorrects:
incorrect.benchmarks = ''
for benchmark in incorrect.question.benchmarks.all():
incorrect.benchmarks += '{}, '.format(benchmark.number)
incorrect.benchmarks = incorrect.benchmarks[:-2]
try:
incorrect.right_answer = incorrect.question.answer_set.order_by(
'point_value').reverse()[0]
except:
incorrect.right_answer = "No correct answer"
report.data['test'] = test
report.data['tests'] = test_instances
report.filename = 'Student Results for ' + unicode(test)
return report.pod_save(template)
def download_student_results(self, test, format, template, cohorts=None):
""" Make appy based report showing results for each student """
report = TemplateReport()
report.file_format = format
if cohorts:
test_instances = test.active_testinstance_set.filter(student__cohort__in=cohorts).distinct()
else:
test_instances = test.active_testinstance_set.all()
benchmarks = Benchmark.objects.filter(question__test=test).distinct()
for benchmark in benchmarks:
benchmark.points_possible = test.question_set.filter(benchmarks=benchmark).aggregate(Sum('point_value'))['point_value__sum']
# aggregate() may return None, which will raise a TypeError upon attempting arithmetic
if benchmark.points_possible is None:
benchmark.points_possible = 0
for test_instance in test_instances:
benchmark_instances = []
for benchmark in benchmarks:
benchmark_instance = Struct()
benchmark_instance.benchmark = benchmark
benchmark_instance.points_possible = benchmark.points_possible
benchmark_instance.answers = test_instance.answerinstance_set.filter(question__benchmarks=benchmark)
benchmark_instance.points_earned = benchmark_instance.answers.aggregate(Sum('points_earned'))['points_earned__sum']
# aggregate() may return None, which will raise a TypeError upon attempting arithmetic
if benchmark_instance.points_earned is None:
benchmark_instance.points_earned = 0
benchmark_instance.questions = ''
for answer in benchmark_instance.answers.all():
benchmark_instance.questions += '{}, '.format(answer.question.get_order_start_one)
benchmark_instance.questions = benchmark_instance.questions[:-2]
benchmark_instances.append(benchmark_instance)
test_instance.benchmarks = benchmark_instances
test_instance.incorrects = test_instance.answerinstance_set.filter(points_earned__lt=F('points_possible'))
for incorrect in test_instance.incorrects:
incorrect.benchmarks = ''
for benchmark in incorrect.question.benchmarks.all():
incorrect.benchmarks += '{}, '.format(benchmark.number)
incorrect.benchmarks = incorrect.benchmarks[:-2]
try:
incorrect.right_answer = incorrect.question.answer_set.order_by('point_value').reverse()[0]
except:
incorrect.right_answer = "No correct answer"
report.data['test'] = test
report.data['tests'] = test_instances
report.filename = 'Student Results for ' + unicode(test)
return report.pod_save(template)
def download_student_results(self, test, format, template):
""" Make appy based report showing results for each student """
report = TemplateReport()
report.file_format = format
test_instances = test.active_testinstance_set.all()
benchmarks = Benchmark.objects.filter(question__test=test).distinct()
for benchmark in benchmarks:
benchmark.points_possible = test.question_set.filter(benchmarks=benchmark).aggregate(Sum("point_value"))[
"point_value__sum"
]
for test_instance in test_instances:
benchmark_instances = []
for benchmark in benchmarks:
benchmark_instance = Struct()
benchmark_instance.benchmark = benchmark
benchmark_instance.points_possible = benchmark.points_possible
benchmark_instance.answers = test_instance.answerinstance_set.filter(question__benchmarks=benchmark)
benchmark_instance.points_earned = benchmark_instance.answers.aggregate(Sum("points_earned"))[
"points_earned__sum"
]
benchmark_instance.questions = ""
for answer in benchmark_instance.answers.all():
benchmark_instance.questions += "{}, ".format(answer.question.get_order_start_one)
benchmark_instance.questions = benchmark_instance.questions[:-2]
benchmark_instances.append(benchmark_instance)
test_instance.benchmarks = benchmark_instances
test_instance.incorrects = test_instance.answerinstance_set.filter(points_earned__lt=F("points_possible"))
for incorrect in test_instance.incorrects:
incorrect.benchmarks = ""
for benchmark in incorrect.question.benchmarks.all():
incorrect.benchmarks += "{}, ".format(benchmark.number)
incorrect.benchmarks = incorrect.benchmarks[:-2]
try:
incorrect.right_answer = incorrect.question.answer_set.order_by("point_value").reverse()[0]
except:
incorrect.right_answer = "No correct answer"
report.data["test"] = test
report.data["tests"] = test_instances
report.filename = "Student Results for " + unicode(test)
return report.pod_save(template)