调查问卷表结构设计及具体实现⼀、表结构设计from django.db import models# Create your models here.class UserInfo(models.Model):'''员⼯表'''username = models.CharField(max_length=64,verbose_name="⽤户名")password = models.CharField(max_length=32,verbose_name="⽤户密码")def__str__(self):return ernameclass Meta:verbose_name_plural="员⼯表"class ClassList(models.Model):'''班级表'''title = models.CharField(max_length=32,verbose_name="班级名")def__str__(self):return self.titleclass Meta:verbose_name_plural = "班级表"class Student(models.Model):'''学⽣表'''name = models.CharField(max_length=32,verbose_name="学⽣姓名")password = models.CharField(max_length=32,verbose_name="学⽣密码")cls = models.ForeignKey(to="ClassList",verbose_name="所属班级")def__str__(self):return class Meta:verbose_name_plural = "学⽣表"class Questionnaire(models.Model):'''问卷表'''title = models.CharField(max_length=32,verbose_name="问卷名")cls = models.ForeignKey(to="ClassList",verbose_name="问卷班级")create_user = models.ForeignKey(to="UserInfo",verbose_name="创建问卷的⽤户")def__str__(self):return self.titleclass Meta:verbose_name_plural = "问卷表"class Questions(models.Model):'''问卷问题表'''caption = models.CharField(max_length=32,verbose_name="问题题⽬")type_choices = ((1,"打分"),(2,"单选"),(3,"评价"))question_type = models.IntegerField(choices=type_choices,verbose_name="问题类型")questionnaire = models.ForeignKey(to="Questionnaire",verbose_name="所属问卷",default=1)def__str__(self):return self.captionclass Meta:verbose_name_plural = "问卷问题表"class Answer(models.Model):'''问卷回答表'''#谁什么时候对那个问题作答了student = models.ForeignKey(to="Student",verbose_name="所属学⽣")queston = models.ForeignKey(to="Questions",verbose_name="所属问题")option = models.ForeignKey(to="Option",null=True,blank=True)val = models.IntegerField(null=True,blank=True,verbose_name="数字答案")content = models.CharField(max_length=255,null=True,blank=True,verbose_name="⽂本答案")def__str__(self):return self.contentclass Meta:verbose_name_plural = "问卷回答表"class Option(models.Model):'''问卷单选题的选项表'''name = models.CharField(max_length=32,verbose_name="选项名")score = models.IntegerField(verbose_name="选项对应的分值")question = models.ForeignKey(to="Questions",verbose_name="所属问题")def__str__(self):return str(self.score)class Meta:verbose_name_plural = "问卷单选题的选项表"⼆、具体实现urls.py1from django.conf.urls import url2from django.contrib import admin3from app01 import views4 urlpatterns = [5 url(r'^admin/', admin.site.urls),6 url(r'^index/$', views.index),7 url(r'^questionedit/(\d+)/$', views.questionedit),8 url(r'^questionedit2/(\d+)/$', views.questionedit2),9 url(r'^questionsave/(\d+)/$', views.questionsave),10 url(r'^student_login/$', views.student_login),11 url(r'^score/(\d+)/(\d+)/$', views.score),12 ]urls.pyviews.py1from django.core.validators import RegexValidator2from django.db.models.aggregates import Count3from django.forms.forms import Form4from django.http.response import JsonResponse5from django.shortcuts import render, HttpResponse,redirect6from app01 import models7from django.forms import ModelForm,fields,widgets8import json9from django.core.exceptions import ValidationError10from django.core.validators import RegexValidator11# Create your views here.12def index(request):13 Questionnaire_obj = models.Questionnaire.objects.all()14#查询问卷所属的班级的学⽣个数15for naire in Questionnaire_obj:16 naire.part_num = models.Answer.objects.filter(queston__in=naire.questions_set.all()).values_list('student_id').distinct().count() 17print(naire.part_num)18return render(request,"index.html",{"Questionnaire_obj":Questionnaire_obj})1920class QuestionForm(ModelForm):21class Meta:22 model = models.Questions23 fields = ["caption","question_type"]2425 error_messages = {26"caption":{"required":"不能为空"}27 }28 widgets ={29"caption":widgets.Textarea(attrs={"class": "question","rows":0,"cols":0})30 }3132class OptionModelForm(ModelForm):33class Meta:34 model = models.Option35 fields = ["name","score"]3637def questionedit(request,nid):38# ⽅式⼀：39# #查询当前问卷的所有的问题40# que_list = models.Questions.objects.filter(questionnaire_id=nid).all()41# question_list = []42# if not que_list:43# '''新建的问题，还没有创建问题'''44# form = QuestionForm()45# question_list.append(form)46# return render(request,"questionedit.html",{"question_list":question_list})47# else:48# '''已经创建了问题的'''49# for que in que_list:50# print(que,"que===")51# form = QuestionForm(instance=que)52# question_list.append(form)53# return render(request,"questionedit.html",{"question_list":question_list})5455# ⽅式⼆：56#查询当前问卷的所有的问题57# def inner():58# que_list = models.Questions.objects.filter(questionnaire_id=nid).all()59# if not que_list:60# '''新建的问题，还没有创建问题'''61# form = QuestionForm()62# yield form63# else:64# '''已经创建了问题的'''65# for que in que_list:66# form = QuestionForm(instance=que)67# yield form68# return render(request,"questionedit.html",{"form":inner()})697071# ⽅式三，yield返回的时候吧form作为⼀个字典的key返回72# def inner():73# que_list = models.Questions.objects.filter(questionnaire_id=nid).all()74# if not que_list:75# '''新建的问题，还没有创建问题'''76# form = QuestionForm()77# yield {"form":form,"obj":None}78# else:79# '''已经创建了问题的'''80# for que in que_list:81# print(que)82# form = QuestionForm(instance=que)83# temp = {"form":form,"obj":que,"option_class":"hide","options":None}84# if que.question_type == 2:85# '''如果选项类型是单选的时候'''86# temp["option_class"] = ""87# #如果是单选的时候让显⽰所有的选项88# question_option_list =[]89# option_list = models.Option.objects.filter(question=que)90# for obj in option_list:91# vm = OptionModelForm(instance=obj)92# question_option_list.append(vm)93# print(question_option_list,"pppppppppppppp")94# temp["options"] = question_option_list95# yield temp96# return render(request, "questionedit.html", {"form": inner()})9798# ⽅式四99def inner():100 que_list = models.Questions.objects.filter(questionnaire_id=nid).all()101if not que_list:102'''新建的问题，还没有创建问题'''103 form = QuestionForm()104yield {"form":form,"obj":None,'option_class':"hide","options":None}105else:106'''已经创建了问题的'''107for que in que_list:108print(que)109 form = QuestionForm(instance=que)110 temp = {"form":form,"obj":que,"option_class":"hide","options":None}111if que.question_type == 2:112'''如果选项类型是单选的时候'''113 temp["option_class"] = ""114#如果是单选的时候让显⽰所有的选项115def inner_loop(quee):116 option_list = models.Option.objects.filter(question=quee)117for v in option_list:118yield {"form":OptionModelForm(instance=v),"obj":v}119 temp["options"] = inner_loop(que)120yield temp121return render(request, "questionedit.html", {"form": inner(),"nid":nid})122123def questionedit2(request,nid):124def inner():125 que_list = models.Questions.objects.filter(questionnaire_id=nid).all()126if not que_list:127'''新建的问题，还没有创建问题'''128 form = QuestionForm()129yield {"form": form, "obj": None, 'option_class': "hide", "options": None}130else:131'''已经创建了问题的'''132for que in que_list:133print(que)134 form = QuestionForm(instance=que)135 temp = {"form": form, "obj": que, "option_class": "hide", "options": None}136if que.question_type == 2:137'''如果选项类型是单选的时候'''138 temp["option_class"] = ""139140# 如果是单选的时候让显⽰所有的选项141def inner_loop(quee):142 option_list = models.Option.objects.filter(question=quee)143for v in option_list:144yield {"form": OptionModelForm(instance=v), "obj": v}145146 temp["options"] = inner_loop(que)147yield temp148return render(request,"questionedit.html",{"form":inner()})149150151def questionsave(request,nid):152 ret = {"status":True,"msg":None,"data":None}153try:154if request.is_ajax():155#得到新提交的数据156 data=request.body.decode("utf8")157 post_data_list = json.loads(data)158#找到所有的问题列表159 question_list = models.Questions.objects.filter(questionnaire_id=nid)160#找到⽤户提交的所有的问题id161 post_id_list = [i.get("id") for i in post_data_list if i.get("id")]162# print(post_id_list,"post_id_list") #['1', '2', '1', '2', '1', '2', '1', '2'] post_id_list163#找到数据库中的所有的问题id164 question_id_list = [i.id for i in question_list]165# print(question_id_list,"question_id_list") #[1, 2] question_id_list166#数据库中的那些id需要删除(数据库⾥有前端没有的数据删除)167 del_id_list = set(question_id_list).difference(post_id_list)168169#循环ajax发过来的那些问题列表，170for item in post_data_list:171#item就是⽤户传进来的每个问题172 caption = item.get("caption")173 type_id = item.get("type_id")174 qid = item.get("id")175 options = item.get("options")176if not qid in question_id_list:177#如果前端传进来的id不在数据库⾥⾯，就说明要新增178 new_question_obj = models.Questions.objects.create(caption=caption,question_type=type_id,questionnaire_id=nid) 179if type_id==2:180for op in options:181 name = op.get("name")182 score = op.get("score")183 models.Option.objects.create(name=name,score=score,question=new_question_obj)184else:185#否则说明是要更新186 models.Questions.objects.filter(id=qid).update(caption=caption,question_type=type_id,questionnaire_id=qid)187if not options:188#如果没有options就把数据库的options记录给删除了189 models.Option.objects.filter(id=nid).delete()190else:191#如果有先删除原来的后创建新传进来的192 models.Option.objects.filter(id=nid).delete()193for op in options:194 name = op.get("name")195 score = op.get("score")196 models.Option.objects.create(name=name,score=score,question_id=qid)197 models.Questions.objects.filter(id__in=del_id_list).delete()198except Exception as e:199 ret['msg'] = str(e)200 ret["status"] = False201return JsonResponse(ret)202203204class StudentForm(ModelForm):205# password = fields.CharField(max_length=8, validators=[RegexValidator("\d+", "密码只能是数字")],206# error_messages={"max_length":"8"}207# )208# 这⾥如果写上password，下⾯也有了，就会把下⾯的给覆盖了209class Meta:210 model=models.Student211 fields=["name","password"]212213 error_messages ={214"name":{"required":"⽤户名不能为空"},215"password":{"required":"密码不能为空","max_length":"密码长度不能⼤于8位"},216 },217 widgets = {218"password": widgets.PasswordInput(attrs={'placeholder': 'password', 'class': 'form-control'}),219"name": widgets.TextInput(attrs={'placeholder': 'username', 'class': 'form-control'})220 }221222223def student_login(request):224# obj = models.Student.objects.all().first()225# print(obj.id,)226if request.method=="GET":227 form = StudentForm()228else:229print("============")230 form = StudentForm(data=request.POST)231if form.is_valid():232print("======",form.cleaned_data)233 user = models.Student.objects.filter(**form.cleaned_data).first()234if user:235 request.session["id"] =user.id236 request.session["user"] =237 class_id = request.session.get("class_id")238 qn_id = request.session.get("qn_id")239# if class_id==None or qn_id==None:240# return redirect("/index/")241return redirect('/score/%s/%s'%(class_id,qn_id))242else:243return render(request,"student_login.html",{"form":form})244return render(request, "student_login.html", {"form": form})245246247def func(val):248#参数要有，Form⽤正则匹配的时候不⽤加括号，⾃⼰就会执⾏这个函数，去验证249if len(val)<15:250raise ValidationError("字数不能⼩于15字")251252def score(request,class_id,qn_id):253# print(class_id,qn_id)254 student_id = request.session.get("id")255print(student_id,"student_id")256 request.session["class_id"] = class_id257 request.session["qn_id"] = qn_id258if not student_id:259return redirect("/student_login/")260#查看当前⽤户是否是要评论的班级的学⽣261262 stu1 = models.Student.objects.filter(cls=class_id,id=student_id).count()263print("stu1",stu1)264if not stu1:265return HttpResponse("你还不是这个班的学⽣呢，你⽆权访问我们这次问卷")266267#当前学⽣是否已经评论过当前问卷268 stu2 = models.Answer.objects.filter(student_id=student_id,queston__questionnaire_id=qn_id).count()269# print(stu2)270if stu2:271return HttpResponse("你已经答过了，感谢你的参与。
