# coding=utf-8 from django.db import models from django.utils import timezone from django.conf import settings from utils.exceptions import CustomError from apps.foundation.models import Subject from apps.examination.exampaper.models import ExamPaper, ExamPaperDetail from apps.examination.examquestion.models import ExamQuestion, ExamQuestionOption class Exam(models.Model): FIXED = 1 RANDOM = 2 TYPE_CHOICES = ( (FIXED, u'固定试卷'), (RANDOM, u'随机试卷'), ) TYPE_JSON = [{'id': item[0], 'value': item[1]} for item in TYPE_CHOICES] name = models.CharField(max_length=200, verbose_name=u"名称") subject = models.ForeignKey(Subject, verbose_name=u"科目", on_delete=models.PROTECT, null=True, editable=False) type = models.PositiveSmallIntegerField(choices=TYPE_CHOICES, verbose_name=u"试卷类型", null=True, editable=False) duration = models.IntegerField(verbose_name=u'时长') exam_time = models.DateTimeField(verbose_name=u"考试时间") exam_end_time = models.DateTimeField(verbose_name=u"考试结束时间", null=True, editable=False) exampaper = models.ForeignKey(ExamPaper, verbose_name=u"试卷", on_delete=models.PROTECT, null=True, editable=True) desc = models.TextField(verbose_name=u"备注", null=True, blank=True) examinee_count = models.IntegerField(verbose_name=u'考试人数', default=0, editable=False) create_user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u'添加人', editable=False, on_delete=models.PROTECT) create_time = models.DateTimeField(verbose_name=u"添加时间", default=timezone.now, editable=False) delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False) class Meta: db_table = "exam" ordering = ['-id'] verbose_name = u"考试管理" default_permissions = () @staticmethod def getById(id): instance = Exam.objects.filter(pk=id).first() if not instance: raise CustomError(u'未找到相应的考试') return instance def allocation_exampaper(self, type, exampaper_instance): self.type = type self.subject_id = exampaper_instance.subject_id self.exampaper = exampaper_instance ExamLog.objects.filter(exam=self, delete=False).update(exampaper_id=exampaper_instance.id) def change_examtime(self): ExamLog.objects.filter(exam=self, delete=False).update(exam_time=self.exam_time) def change_examinee(self, new_user_ids): old_user_ids = ExamLog.objects.filter(exam=self, delete=False).values_list('user_id', flat=True) user_adds = [val for val in new_user_ids if val not in old_user_ids] user_deletes = [val for val in old_user_ids if val not in new_user_ids] if user_deletes: self._remove_examinee(user_deletes) if user_adds: self._add_examinee(user_adds) self.examinee_count = ExamLog.objects.filter(exam=self, delete=False).count() def _remove_examinee(self, user_ids): ExamLog.objects.filter(exam=self, user_id__in=user_ids).update(delete=True) def _add_examinee(self, user_ids): data = [] for user_id in user_ids: item = ExamLog( type=ExamLog.FORMAL, exam=self, exampaper=self.exampaper, user_id=user_id, exam_time=self.exam_time ) data.append(item) ExamLog.objects.bulk_create(data) class ExamLog(models.Model): MOCK = 1 FORMAL = 2 TYPE_CHOICES = ( (MOCK, u'模拟考试'), (FORMAL, u'正式考试'), ) TYPE_JSON = [{'id': item[0], 'value': item[1]} for item in TYPE_CHOICES] type = models.PositiveSmallIntegerField(choices=TYPE_CHOICES, verbose_name=u"类型") exam = models.ForeignKey(Exam, verbose_name=u"考试", null=True, blank=True, on_delete=models.PROTECT) exampaper = models.ForeignKey(ExamPaper, verbose_name=u"试卷", null=True, blank=True, on_delete=models.PROTECT) user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u'参加人员', on_delete=models.PROTECT) scores = models.IntegerField(verbose_name=u'分数', null=True, blank=True) rank = models.IntegerField(verbose_name=u'排名', null=True, blank=True) use_time = models.IntegerField(verbose_name=u'用时', null=True, blank=True) exam_time = models.DateTimeField(verbose_name=u"考试时间", null=True, blank=True) submit_time = models.DateTimeField(verbose_name=u"交卷时间", null=True, blank=True) single_answer_scores = models.IntegerField(verbose_name=u'单选题得分', default=0, editable=False) multiple_answer_scores = models.IntegerField(verbose_name=u'多选题得分', default=0, editable=False) fill_answer_scores = models.IntegerField(verbose_name=u'填空题得分', default=0, editable=False) judgment_answer_scores = models.IntegerField(verbose_name=u'判断题得分', default=0, editable=False) discuss_answer_scores = models.IntegerField(verbose_name=u'论述题得分', default=0, editable=False) single_answer_count = models.IntegerField(verbose_name=u'单选题答对数', default=0, editable=False) multiple_answer_count = models.IntegerField(verbose_name=u'多选题答对数', default=0, editable=False) fill_answer_count = models.IntegerField(verbose_name=u'填空题答对数', default=0, editable=False) judgment_answer_count = models.IntegerField(verbose_name=u'判断题答对数', default=0, editable=False) discuss_answer_count = models.IntegerField(verbose_name=u'论述题答对数', default=0, editable=False) delete = models.BooleanField(verbose_name=u'删除', db_column='is_delete', default=False, editable=False) class Meta: db_table = "exam_log" ordering = ['-id'] verbose_name = u"考试记录" default_permissions = () class ExamAnswerLog(models.Model): RIGHT = 1 WRONG = 2 NOTDONE = 3 WAIT_CHECK = 4 STATUS_CHOICES = ( (RIGHT, u'正确'), (WRONG, u'错误'), (NOTDONE, u'未做'), (WAIT_CHECK, u'待评分'), # todo 论述题答题后，状态待确定 ) STATUS_JSON = [{'id': item[0], 'value': item[1]} for item in STATUS_CHOICES] main = models.ForeignKey(ExamLog, verbose_name=u"考试记录", on_delete=models.PROTECT) detail = models.ForeignKey(ExamPaperDetail, verbose_name=u"试卷中试题", on_delete=models.PROTECT) status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'回答状态', default=NOTDONE) discuss_answer = models.TextField(verbose_name=u"论述题答案", null=True, blank=True) discuss_scores = models.TextField(verbose_name=u"论述题得分", default=0) class Meta: db_table = "exam_answer_log" ordering = ['id'] verbose_name = u"考试答题记录" default_permissions = () class ExamAnswerOptionLog(models.Model): main = models.ForeignKey(ExamAnswerLog, verbose_name=u"考试答题记录", on_delete=models.PROTECT) option = models.ForeignKey(ExamQuestionOption, verbose_name=u"选项", on_delete=models.PROTECT) class Meta: db_table = "exam_answer_option_log" ordering = ['id'] verbose_name = u"选择题回答" default_permissions = () class ExamAnswerFillLog(models.Model): main = models.ForeignKey(ExamAnswerLog, verbose_name=u"考试答题记录", on_delete=models.PROTECT) content = models.TextField(verbose_name=u"内容") order = models.IntegerField(verbose_name=u'排序') class Meta: db_table = "exam_answer_fill_log" ordering = ['order', 'id'] verbose_name = u"填空题回答" default_permissions = ()