from django.db import models
from django.db.models.signals import post_save
from django.dispatch import receiver
+from django.utils.html import format_html
from django.utils.translation import ugettext_lazy as _
from django.utils import timezone
from jsonfield import JSONField
return self.title
def available_answers(self, expert):
- answers = self.answer_set.exclude(mark__expert=expert).filter(participant__complete_set=True)
- if expert not in self.supervisors.all():
+ answers = self.answer_set.exclude(mark__expert=expert)
+ assigned_to_expert = self.answer_set.filter(experts=expert).exists()
+ is_supervisor = expert in self.supervisors.all()
+ is_arbiter = expert in self.arbiters.all()
+ if assigned_to_expert:
+ expert_answers = answers.filter(experts=expert)
+ if expert_answers or not is_arbiter:
+ answers = expert_answers
+ answers = answers.extra(where=[
+ "field_values::text ~ ': *\"[^\"]+\"' "
+ "OR EXISTS (SELECT id FROM stage2_attachment WHERE answer_id = stage2_answer.id) "
+ "OR EXISTS (SELECT id FROM stage2_fieldoption WHERE answer_id = stage2_answer.id)"])
+ if not is_supervisor:
answers = answers.exclude(complete=True)
- if expert in self.arbiters.all():
+ if not is_supervisor or not self.is_active():
+ answers = answers.filter(participant__complete_set=True)
+ if is_arbiter:
answers = answers.filter(need_arbiter=True)
return answers
+ def field_counts(self, answers):
+ for field_desc in self.field_descriptions:
+ field_name, params = field_desc
+ if params['type'] == 'options':
+ field_count = FieldOption.objects.filter(answer__in=list(answers), set__name=params['option_set']).count()
+ else: # text, link
+ field_count = sum(1 for answer in answers if answer.field_values.get(field_name))
+ yield field_name, field_count
+
def is_active(self):
return self.deadline >= timezone.now()
participant = models.ForeignKey(Participant)
assignment = models.ForeignKey(Assignment)
field_values = JSONField(_('field values'), default={})
+ experts = models.ManyToManyField(
+ settings.AUTH_USER_MODEL, verbose_name=_('experts'), related_name='stage2_assigned_answers')
# useful redundancy
complete = models.BooleanField(default=False)
need_arbiter = models.BooleanField(default=False)
class Meta:
unique_together = ['participant', 'assignment']
+ def fields(self):
+ for field_desc in self.assignment.field_descriptions:
+ field_name, params = field_desc
+ if params['type'] == 'options':
+ option = self.fieldoption_set.filter(set__name=params['option_set'])
+ value = option.get().value if option else '--------'
+ else: # text, link
+ value = self.field_values.get(field_name, '')
+ if params['type'] == 'link':
+ value = format_html(u'<a href="{url}">{url}</a>', url=value)
+ yield field_name, value
+
def update_complete(self):
marks = self.mark_set.all()
if len(marks) < 2:
return None
return self.mark_set.aggregate(avg=models.Avg('points'))['avg']
+ # unrelated to `complete' attribute, but whatever
+ def is_complete(self):
+ file_count = len(self.assignment.file_descriptions)
+ field_count = len(self.assignment.field_descriptions)
+ if self.attachment_set.count() < file_count:
+ return False
+ if self.fieldoption_set.count() + sum(1 for k, v in self.field_values.iteritems() if v) < field_count:
+ return False
+ return True
+
class FieldOptionSet(models.Model):
name = models.CharField(verbose_name=_('nazwa'), max_length=32, db_index=True)