filter and extra column in confirmation admin

[edumed.git] / wtem / models.py

diff --git a/wtem/models.py b/wtem/models.py
index f745aeb..5a7e221 100644 (file)
--- a/wtem/models.py
+++ b/wtem/models.py
@@ -4,6 +4,10 @@ import string
 import os
 import json
 
+from datetime import datetime
+
+import pytz as pytz
+from django.conf import settings
 from django.core.validators import validate_email
 from django.db import models
 from django.contrib.auth.models import User
@@ -23,6 +27,12 @@ f.close()
 
 DEBUG_KEY = 'smerfetka159'
 
+tz = pytz.timezone(settings.TIME_ZONE)
+
+
+def get_exercise_by_id(exercise_id):
+    return [e for e in exercises if str(e['id']) == str(exercise_id)][0]
+
 
 def make_key(length):
     return ''.join(
@@ -30,6 +40,37 @@ def make_key(length):
         for i in range(length))
 
 
+def tuple2dt(time_tuple):
+    return tz.localize(datetime(*time_tuple))
+
+
+class CompetitionState(models.Model):
+    """singleton"""
+    BEFORE = 'before'
+    DURING = 'during'
+    AFTER = 'after'
+    STATE_CHOICES = (
+        (BEFORE, u'przed rozpoczęciem'),
+        (DURING, u'w trakcie'),
+        (AFTER, u'po zakończeniu'),
+    )
+    state = models.CharField(choices=STATE_CHOICES, max_length=16)
+
+    start = tuple2dt(settings.OLIMPIADA_START)
+    end = tuple2dt(settings.OLIMPIADA_END)
+
+    @classmethod
+    def get_state(cls):
+        now = timezone.now()
+        if now < cls.start:
+            return cls.BEFORE
+        elif now < cls.end:
+            return cls.DURING
+        else:
+            return cls.AFTER
+        # return cls.objects.get().state
+
+
 class Submission(models.Model):
     contact = models.ForeignKey(Contact, null=True)
     key = models.CharField(max_length=30, unique=True)
@@ -41,6 +82,7 @@ class Submission(models.Model):
     marks = JSONField(default={})
     examiners = models.ManyToManyField(User, null=True, blank=True)
     end_time = models.CharField(max_length=5, null=True, blank=True)
+    random_seed = models.IntegerField()
 
     def __unicode__(self):
         return ', '.join((self.last_name, self.first_name, self.email))
@@ -59,12 +101,32 @@ class Submission(models.Model):
             key=key if key else Submission.generate_key(),
             first_name=first_name,
             last_name=last_name,
-            email=email
+            email=email,
+            random_seed=random.randint(-2147483648, 2147483647)
         )
 
         submission.save()
         return submission
 
+    def competition_link(self):
+        return reverse('form_single', kwargs={'submission_id': self.id, 'key': self.key})
+
+    def get_answers(self):
+        return json.loads(self.answers) if self.answers else {}
+
+    def shuffled_exercise_ids(self):
+        exercise_ids = [e['id'] for e in exercises]
+        seeded_random = random.Random(self.random_seed)
+        seeded_random.shuffle(exercise_ids)
+        return exercise_ids
+
+    def current_exercise(self):
+        answers = self.get_answers()
+        for i, id in enumerate(self.shuffled_exercise_ids(), 1):
+            if str(id) not in answers:
+                return i, get_exercise_by_id(id)
+        return None, None
+
     def get_mark(self, user_id, exercise_id):
         mark = None
         user_id = str(user_id)
@@ -92,8 +154,7 @@ class Submission(models.Model):
         return marks
 
     def get_final_exercise_mark(self, exercise_id):
-        # exercise = exercises[int(exercise_id)-1]
-        exercise = [e for e in exercises if str(e['id']) == str(exercise_id)][0]
+        exercise = get_exercise_by_id(exercise_id)
         if exercise_checked_manually(exercise):
             marks_by_examiner = self.get_exercise_marks_by_examiner(exercise_id)
             if len(marks_by_examiner):
@@ -196,7 +257,7 @@ class Confirmation(models.Model):
     confirmed = models.BooleanField(default=False)
 
     class Meta:
-        ordering = ['email']
+        ordering = ['contact__contact']
 
     @classmethod
     def create(cls, first_name, last_name, email, contact=None, key=None):
@@ -217,6 +278,9 @@ class Confirmation(models.Model):
     def readable_contact(self):
         return '%s <%s>' % (self.contact.body.get('przewodniczacy'), self.contact.contact)
 
+    def school_phone(self):
+        return '%s, tel. %s' % (self.contact.body.get('school'), self.contact.body.get('school_phone'))
+
     def age(self):
         return timezone.now() - self.contact.created_at