+ return attachment_download(attachment)
+
+
+@login_required
+def assignment_list(request):
+ expert = request.user
+ assignments = expert.stage2_assignments.all()
+ if not assignments:
+ return HttpResponseForbidden('Not allowed')
+ for assignment in assignments:
+ assignment.marked_count = assignment.available_answers(expert, marked=True).count()
+ assignment.to_mark_count = assignment.available_answers(expert).count()
+ assignment.supervisor = expert in assignment.supervisors.all()
+ assignment.arbiter_count = assignment.needing_arbiter().count()
+
+ non_empty_assignments = [ass for ass in assignments if ass.marked_count > 0 or ass.to_mark_count > 0]
+ if len(non_empty_assignments) == 1 and non_empty_assignments[0].to_mark_count > 0:
+ return HttpResponseRedirect(reverse('stage2_answer_list', args=[non_empty_assignments[0].id]))
+ return render(request, 'stage2/assignment_list.html', {'assignments': assignments})
+
+
+def available_answers(assignment, expert, sent_forms=None, marked=False):
+ if marked:
+ answers = assignment.available_answers(expert, marked=True)
+ else:
+ answers = assignment.available_answers(expert).order_by('participant__last_name')
+ answers = answers.prefetch_related('attachment_set')
+ if sent_forms:
+ sent_answer_id, mark_forms = sent_forms
+ else:
+ sent_answer_id = mark_forms = None
+ for answer in answers:
+ attachments = answer.attachment_set.all()
+ attachments_by_file_no = {attachment.file_no: attachment for attachment in attachments}
+ answer.attachments = [
+ (desc, attachments_by_file_no.get(i))
+ for (i, (desc, ext)) in enumerate(assignment.file_descriptions, 1)]
+ if answer.id == sent_answer_id:
+ answer.forms = mark_forms
+ else:
+ answer.forms = []
+ for criterion in assignment.markcriterion_set.all():
+ answer.forms.append(MarkForm(
+ answer=answer,
+ criterion=criterion,
+ instance=answer.mark_set.filter(expert=expert, criterion=criterion).first(),
+ prefix='mark%s-%s' % (answer.id, criterion.id)))
+ return answers
+
+
+@login_required
+def answer_list(request, assignment_id, marked=False):
+ assignment = get_object_or_404(Assignment, id=assignment_id)
+ expert = request.user
+ if expert not in assignment.experts.all():
+ return HttpResponseForbidden('Not allowed')
+ if request.POST:
+ # ugly :/
+ answer_id = None
+ for post_key, value in request.POST.iteritems():
+ if post_key.endswith('answer_id'):
+ answer_id = int(value)
+ answer = get_object_or_404(Answer, id=answer_id)
+
+ if answer not in assignment.available_answers(expert, marked=marked):
+ return HttpResponseForbidden('Not allowed')
+ if answer.assignment.is_active():
+ return HttpResponseForbidden('Not allowed')
+ all_valid, forms = get_mark_forms(answer, request)
+ if all_valid:
+ if marked:
+ return HttpResponseRedirect(reverse('stage2_marked_answers', args=[answer.assignment_id]))
+ else:
+ return HttpResponseRedirect(reverse('stage2_answer_list', args=[answer.assignment_id]))
+ else:
+ sent_forms = answer_id, forms
+ else:
+ sent_forms = None
+ answers = available_answers(assignment, expert, sent_forms=sent_forms, marked=marked)
+ return render(request, 'stage2/answer_list.html', {
+ 'answers': answers,
+ 'assignment': assignment,
+ 'field_counts': assignment.field_counts(answers) if not marked else None,
+ 'supervisor': expert in assignment.supervisors.all(),
+ 'marked': marked
+ })
+
+
+def get_mark_forms(answer, request):
+ all_valid = True
+ created_marks = []
+ forms = []
+ for criterion in answer.assignment.markcriterion_set.all():
+ mark, created = Mark.objects.get_or_create(
+ answer=answer, criterion=criterion, expert=request.user, defaults={'points': 0})
+ if created:
+ created_marks.append(mark)
+ form = MarkForm(
+ data=request.POST, answer=answer, criterion=criterion, instance=mark,
+ prefix='mark%s-%s' % (answer.id, criterion.id))
+ if form.is_valid():
+ form.save()
+ else:
+ all_valid = False
+ forms.append(form)
+ if not all_valid:
+ for mark in created_marks:
+ mark.delete()
+ return all_valid, forms
+
+
+@login_required
+def expert_download(request, attachment_id):
+ attachment = get_object_or_404(Attachment, id=attachment_id)
+ return attachment_download(attachment)
+
+
+def write_row(row, writer):
+ writer.writerow([unicode(item).encode('utf-8') for item in row])
+
+
+@login_required
+def csv_results(request):
+ import csv
+ response = HttpResponse(content_type='text/csv')
+ writer = csv.writer(response)
+ assignments = Assignment.objects.all()
+ participants = Participant.objects.filter(complete_set=True)
+ headers = [u'imię', u'nazwisko', u'szkoła', u'adres szkoły']
+ assignments_experts = []
+ for assignment in assignments:
+ for expert in assignment.experts.filter(mark__answer__assignment=assignment).distinct():
+ assignments_experts.append((assignment, expert))
+ headers.append(u'%s %s' % (assignment.title, expert.last_name))
+ for assignment in assignments:
+ headers.append(u'%s - średnia' % assignment.title.encode('utf-8'))
+ headers.append(u'ostateczny wynik')
+ write_row(headers, writer)
+ for participant in participants:
+ row = [
+ participant.first_name,
+ participant.last_name,
+ participant.contact.body['school'],
+ participant.contact.body['school_address'],
+ ]
+ for assignment, expert in assignments_experts:
+ marks = expert.mark_set.filter(answer__assignment=assignment, answer__participant=participant)
+ if marks:
+ row.append(sum(mark.points for mark in marks))
+ else:
+ row.append('')
+ for assignment in assignments:
+ row.append('%.2f' % participant.answer_set.get(assignment=assignment).score())
+ row.append('%.2f' % participant.score())
+ write_row(row, writer)
+ response['Content-Disposition'] = 'attachment; filename="wyniki.csv"'
+ return response
+
+
+@login_required
+def csv_details(request, assignment_id):
+ import csv
+ response = HttpResponse(content_type='text/csv')
+ writer = csv.writer(response)
+ assignment = get_object_or_404(Assignment, id=assignment_id)
+ criteria = tuple(assignment.markcriterion_set.all())
+ expert_headers = (u"ekspert",) + criteria
+ headers = (u"imię", u"nazwisko", u"numer", u"wynik") + expert_headers * 2
+ write_row(headers, writer)
+
+ for a in assignment.answer_set.filter(participant__complete_set=True).order_by('participant__last_name'):
+ row = (
+ a.participant.first_name,
+ a.participant.last_name,
+ str(a.participant.id),
+ '%.2f' % a.score(),
+ )
+ experts = a.mark_set.values_list('expert__username', flat=True).order_by().distinct()
+ for expert in experts:
+ row += (expert,)
+ marks = a.mark_set.filter(expert__username=expert).order_by('criterion__order')
+ row += tuple(marks.values_list('points', flat=True))
+ write_row(row, writer)
+ response['Content-Disposition'] = 'attachment; filename="%s.csv"' % assignment.title