def createTeam():
if session.get("id") is None:
return redirect("/user/login")
name = session.get("name")
if request.method == "GET":
return render_template('student_templates/createTeam.html', name=name)
else:
name = request.form.get("name")
userId = session.get("id")
course = CourseAndStudent.query.filter(
CourseAndStudent.studentId == userId).first()
with db.auto_commit():
team = Team()
team.courseId = course.CourseId
team.TeamName = name
team.isFinish = 0
db.session.add(team)
team = Team.query.filter(
Team.courseId == course.CourseId).order_by(
Team.TeamNumber.desc()).first()
member = Member()
member.studentId = userId
member.teamId = team.TeamNumber
member.votenum = 0
db.session.add(member)
return redirect('/student/display')
def byStudent():
if session.get("id") is None:
return redirect("/user/login")
name=session.get("name")
courseId=request.args.get("courseId")
studentList=CourseAndStudent.query.filter_by(CourseId=courseId).all()
list=[]
for i in studentList:
student=Student.query.filter_by(id=i.studentId).first()
if student is not None:
list.append(student)
#每组的人数
totalNum=Course.query.filter_by(CourseId=courseId).first().numofmember
#组的数量
# teamNum=len(list)/totalNum+1
# print(teamNum)
#
# if teamNum==1:
# list2=[]
# list2.append(list)
# pass
# else:
from random import shuffle
shuffle(list) # 重排序
list2 = []
for i in range(0, len(list), totalNum):
list2.append(list[i:i + totalNum])
result=[]
for i in list2:
dict1 = dict()
nameTeam=random.randint(100,1000)
dict1["name"]=str(nameTeam)
dict1["value"]=i
print(i)
result.append(dict1)
with db.auto_commit():
team = Team()
team.TeamName=str(nameTeam)
team.courseId=courseId
# 数据库的insert操作
db.session.add(team)
team=Team.query.filter(Team.courseId==courseId).filter(Team.TeamName==nameTeam).first()
with db.auto_commit():
for x in i:
member=Member()
member.teamId=team.TeamNumber
member.studentId=x.id
db.session.add(member)
Course.query.filter(Course.CourseId == courseId).update({"teamType": 2})
db.session.commit()
return render_template("teacher_templates/displaygroup.html",name=name,courseId=courseId,result=result)
