1 # -*- coding: utf-8 -*-
 
   7 from django.core.validators import validate_email
 
   8 from django.db import models
 
   9 from django.contrib.auth.models import User
 
  10 from django.core.exceptions import ValidationError
 
  11 from django.core.mail import send_mail
 
  12 from django.core.urlresolvers import reverse
 
  13 from django.template.loader import render_to_string
 
  14 from django.utils.translation import ugettext as _
 
  15 from jsonfield import JSONField
 
  17 from contact.models import Contact
 
  19 f = file(os.path.dirname(__file__) + '/fixtures/exercises.json')
 
  20 exercises = json.loads(f.read())
 
  23 DEBUG_KEY = 'smerfetka159'
 
  28         random.choice(string.ascii_uppercase + string.ascii_lowercase + string.digits)
 
  29         for i in range(length))
 
  32 class Submission(models.Model):
 
  33     contact = models.ForeignKey(Contact, null=True)
 
  34     key = models.CharField(max_length=30, unique=True)
 
  35     first_name = models.CharField(max_length=100)
 
  36     last_name = models.CharField(max_length=100)
 
  37     email = models.EmailField(max_length=100, unique=True)
 
  38     answers = models.CharField(max_length=65536, null=True, blank=True)
 
  39     key_sent = models.BooleanField(default=False)
 
  40     marks = JSONField(default={})
 
  41     examiners = models.ManyToManyField(User, null=True, blank=True)
 
  42     end_time = models.CharField(max_length=5, null=True, blank=True)
 
  44     def __unicode__(self):
 
  45         return ', '.join((self.last_name, self.first_name, self.email))
 
  48     def generate_key(cls):
 
  50         while not key or key in [record['key'] for record in cls.objects.values('key')]:
 
  55     def create(cls, first_name, last_name, email, key=None, contact=None):
 
  58             key=key if key else Submission.generate_key(),
 
  59             first_name=first_name,
 
  67     def get_mark(self, user_id, exercise_id):
 
  69         user_id = str(user_id)
 
  70         exercise_id = str(exercise_id)
 
  71         if self.marks and user_id in self.marks:
 
  72             mark = self.marks[user_id].get(exercise_id, None)
 
  75     def set_mark(self, user_id, exercise_id, mark):
 
  76         user_id = str(user_id)
 
  77         exercise_id = str(exercise_id)
 
  81         self.marks.setdefault(user_id, {})[exercise_id] = mark
 
  83             del self.marks[user_id][exercise_id]
 
  85     def get_exercise_marks_by_examiner(self, exercise_id):
 
  87         for examiner_id, examiner_marks in self.marks.items():
 
  88             mark = examiner_marks.get(exercise_id, None)
 
  90                 marks[examiner_id] = mark
 
  93     def get_final_exercise_mark(self, exercise_id):
 
  94         # exercise = exercises[int(exercise_id)-1]
 
  95         exercise = [e for e in exercises if str(e['id']) == str(exercise_id)][0]
 
  96         if exercise_checked_manually(exercise):
 
  97             marks_by_examiner = self.get_exercise_marks_by_examiner(exercise_id)
 
  98             if len(marks_by_examiner):
 
  99                 return sum(map(float, marks_by_examiner.values())) / float(len(marks_by_examiner))
 
 105             answer = json.loads(self.answers)[exercise_id]['closed_part']
 
 107             if t == 'edumed_uporzadkuj':
 
 108                 return exercise['points'] if map(int, answer) == exercise['answer'] else 0
 
 109             if t == 'edumed_przyporzadkuj':
 
 111                 for bucket_id, items in answer.items():
 
 112                     for item_id in items:
 
 114                         if exercise.get('answer_mode', None) == 'possible_buckets_for_item':
 
 115                             is_correct = int(bucket_id) in exercise['answer'].get(item_id)
 
 117                             is_correct = int(item_id) in exercise['answer'].get(bucket_id, [])
 
 119                             toret += exercise['points_per_hit']
 
 121             if t == 'edumed_wybor':
 
 122                 if len(exercise['answer']) == 1:
 
 123                     if len(answer) and int(answer[0]) == exercise['answer'][0]:
 
 124                         return exercise['points']
 
 129                     if exercise.get('answer_mode', None) == 'all_or_nothing':
 
 130                         toret = exercise['points'] if map(int, answer) == exercise['answer'] else 0
 
 132                         for answer_id in map(int, answer):
 
 133                             if answer_id in exercise['answer']:
 
 134                                 toret += exercise['points_per_hit']
 
 136             if t == 'edumed_prawdafalsz':
 
 138                 for idx, statement in enumerate(exercise['statements']):
 
 139                     if statement[1] == 'ignore':
 
 141                     if answer[idx] == 'true':
 
 143                     elif answer[idx] == 'false':
 
 147                     if given == statement[1]:
 
 148                         toret += exercise['points_per_hit']
 
 150             raise NotImplementedError
 
 153     def final_result(self):
 
 155         # for exercise_id in map(str,range(1, len(exercises) + 1)):
 
 156         for exercise_id in [str(x['id']) for x in exercises]:
 
 157             mark = self.get_final_exercise_mark(exercise_id)
 
 163     def final_result_as_string(self):
 
 164         return ('%.2f' % self.final_result).rstrip('0').rstrip('.')
 
 167 class Attachment(models.Model):
 
 168     submission = models.ForeignKey(Submission)
 
 169     exercise_id = models.IntegerField()
 
 170     tag = models.CharField(max_length=128, null=True, blank=True)
 
 171     file = models.FileField(upload_to='wtem/attachment')
 
 174 class Assignment(models.Model):
 
 175     user = models.ForeignKey(User, unique=True)
 
 176     exercises = JSONField()
 
 179         if not isinstance(self.exercises, list):
 
 180             raise ValidationError(_('Assigned exercises must be declared in a list format'))
 
 181         # for exercise in self.exercises:
 
 182         #     if not isinstance(exercise, int) or exercise < 1:
 
 183         #         raise ValidationError(_('Invalid exercise id: %s' % exercise))
 
 185     def __unicode__(self):
 
 186         return self.user.username + ': ' + ','.join(map(str, self.exercises))
 
 189 class Confirmation(models.Model):
 
 190     first_name = models.CharField(max_length=100)
 
 191     last_name = models.CharField(max_length=100)
 
 192     email = models.EmailField(max_length=100, unique=True)
 
 193     contact = models.ForeignKey(Contact, null=True)
 
 194     key = models.CharField(max_length=30)
 
 195     confirmed = models.BooleanField(default=False)
 
 201     def create(cls, first_name, last_name, email, contact=None, key=None):
 
 204             key=key if key else make_key(30),
 
 205             first_name=first_name,
 
 213     def absolute_url(self):
 
 214         return reverse('student_confirmation', args=(self.id, self.key))
 
 216     def readable_contact(self):
 
 217         return '%s <%s>' % (self.contact.body.get('przewodniczacy'), self.contact.contact)
 
 220         mail_subject = render_to_string('contact/olimpiada/student_mail_subject.html').strip()
 
 221         mail_body = render_to_string(
 
 222             'contact/olimpiada/student_mail_body.html', {'confirmation': self})
 
 224             validate_email(self.email)
 
 225         except ValidationError:
 
 228             send_mail(mail_subject, mail_body, 'olimpiada@nowoczesnapolska.org.pl', [self.email],
 
 232 def exercise_checked_manually(exercise):
 
 233     return (exercise['type'] in ('open', 'file_upload')) or 'open_part' in exercise