def v_completedexp(request):
stuid = utils.getCookie(request, "stuid")
if (stuid is None) or stuid == "":
return getloginResponse(request)
stuname = utils.getCookie(request, "stuname")
page = utils.getParam(request, "page")
if (page is None) or page == "":
page = 1
else:
page = int(page)
count = TeachingService.getCountPageByStu(stuid, CONSTANTS.TEACHING_IS_STOP)
countpage = 0
i = 0
if count > 0:
if count % 10 > 0:
i = 1
countpage = count / 10 + i
teachingRunList = TeachingService.getTeachingByStu(stuid, CONSTANTS.TEACHING_IS_STOP, page)
experimentList = ExperimentService.getAllExperiment()
# 获取用于菜单的实验列表
experimentMenuList = []
for experiment in experimentList:
experimentTemp = experiment.copy()
experimentName = experimentTemp["name"]
if len(experimentName) > 8:
experimentName = experimentName[0:10] + "..."
experimentTemp["name"] = experimentName
experimentMenuList.append(experimentTemp)
teachingCount = getTeachingCount(stuid)
return render(request, "completedexp.html",
{"teachingList": teachingRunList, "countpage": countpage, "experimentMenuList": experimentMenuList,
"experimentList": experimentList, "teachingCount": teachingCount, "stuname": stuname})
def v_studentmanagement(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
issuperadmin = utils.getCookie(request, "issuperadmin")
adminname = utils.getCookie(request, "adminname")
stunum = utils.getParam(request, "searchnum")
name = utils.getParam(request, "searchname")
page = utils.getParam(request, "page")
if (page is None) or page == "":
page = 1
else:
page = int(page)
if (stunum == "" or stunum is None) and (name == "" or name is None):
count = StudentService.getCountStudent()
countpage = 0
i = 0
if count > 0:
if count % 10 > 0:
i = 1
countpage = count / 10 + i
studentList = StudentService.getAllStudent(page)
else:
count = StudentService.getCountStudentByNameAndNumber(name, stunum)
countpage = 0
i = 0
if count > 0:
if count % 10 > 0:
i = 1
countpage = count / 10 + i
studentList = StudentService.getManyStudentByNameAndNumber(
name, stunum, page)
for student in studentList:
filterinfo = FilterInfoService.getFilterInfoById(student.filterinfoid)
student.registyear = filterinfo.registyear
student.major = filterinfo.major
student.classname = filterinfo.classname
param = "?"
if stunum != "":
param = param + "searchnum=" + stunum
if name != "":
if param != "?":
param = param + "&"
param = param + "searchname=" + name
if param == "?":
param = ""
return render(
request, "studentmanagement.html", {
"studentList": studentList,
"stunum": stunum,
"searchname": name,
"adminname": adminname,
"countpage": countpage,
"issuperadmin": issuperadmin
})
def expoperation(request, id):
stuid = utils.getCookie(request, "stuid")
if (stuid is None) or stuid == "":
return getloginResponse(request)
stuname = utils.getCookie(request, "stuname")
stunumber = StudentService.getStudentById(stuid).number
if id == '1':
return render(request, "experiment/experiment1/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '2':
return render(request, "experiment/experiment2/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '3':
return render(request, "experiment/experiment3/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '4':
return render(request, "experiment/experiment4/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '5':
return render(request, "experiment/experiment5/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '6':
return render(request, "experiment/experiment6/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '7':
return render(request, "experiment/experiment7/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '8':
return render(request, "experiment/experiment8/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '9':
return render(request, "experiment/experiment9/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
elif id == '10':
return render(request, "experiment/experiment10/expoperation.html", {
"stuname": stuname,
"stunumber": stunumber
})
def image_draw(request):
stuid = utils.getCookie(request, "stuid")
if (stuid is None) or stuid == "":
return getloginResponse(request)
stuname = utils.getCookie(request, "stuname")
stunumber = StudentService.getStudentById(stuid).number
return render(request, "experiment/image_draw.html", {
"stuname": stuname,
"stunumber": stunumber
})
def v_approval(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
return getloginResponse(request)
teachingid = utils.getParam(request, "teachingid")
teachername = utils.getCookie(request, "teachername")
reportList = ReportService.getReportByTeachingid(int(teachingid))
return render(request, "approval.html", {
"reportList": reportList,
"teachername": teachername
})
def v_adminmanagement(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
issuperadmin = utils.getCookie(request, "issuperadmin")
if issuperadmin != "1" or issuperadmin is None:
return getloginResponse(request)
adminList = AdminService.getAllAdmin()
return render(request, "adminmanagement.html", {
"issuperadmin": issuperadmin,
"adminList": adminList
})
def setBasicInformation(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
filterInfoList = FilterInfoService.getFilterInfoList(None)
issuperadmin = utils.getCookie(request, "issuperadmin")
adminname = utils.getCookie(request, "adminname")
return render(
request, "set_basic_information.html", {
"filterInfoList": filterInfoList,
"issuperadmin": issuperadmin,
"adminname": adminname
})
def uploadData(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teachingid = utils.getParam(request, "teachingid")
file = request.FILES.get('file', None)
if file is None:
return HttpResponse(
"<script>if(confirm('上传的文件为空')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
filename = file.name
filesuffix = os.path.splitext(filename)[1]
if filesuffix != ".xsl" and filesuffix != ".xlsx":
return HttpResponse(
"<script>if(confirm('实验数据必须为excel')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
filename = str(uuid.uuid1()) + filesuffix
fp = open(os.path.join(CONSTANTS.DATAURL_PRE, filename), 'wb+')
for chunk in file.chunks(): # 分块写入文件
fp.write(chunk)
fp.close()
TeachingService.uploadData(teachingid, filename)
return HttpResponse(
"<script>if(confirm('上传成功')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
def uploadVideo(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
experimentid = utils.getParam(request, "experimentid")
file = request.FILES.get('file', None)
name = utils.getParam(request, "name")
if experimentid == "":
responseReturn = Response(-1, "请选择实验！")
return HttpResponse(responseReturn.__str__())
if file is None:
responseReturn = Response(-1, "上传文件为空！")
return HttpResponse(responseReturn.__str__())
filename = file.name
filesuffix = os.path.splitext(filename)[1]
if filesuffix != ".mp4" and filesuffix != ".rmvb":
responseReturn = Response(-1, "视屏格式应为MP4、rmvb！")
return HttpResponse(responseReturn.__str__())
filename = str(uuid.uuid1()) + filesuffix
fp = open(os.path.join(CONSTANTS.EXPERIMENTVIDEOURL_PRE, filename), 'wb+')
for chunk in file.chunks(): # 分块写入文件
fp.write(chunk)
fp.close()
videoid = VideoService.saveVideo(name, filename, experimentid)
if videoid is None:
responseReturn = Response(-1, "上传失败，请重试！")
return HttpResponse(responseReturn.__str__())
video = {"id": videoid, "name": name, "url": filename}
responseReturn = Response(None, None)
responseReturn.setRes(json.dumps(video))
return HttpResponse(responseReturn.__str__())
def updateExperimentTemplate(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
experimentid = utils.getParam(request, "experimentid")
file = request.FILES.get('file', None)
if file is None:
return HttpResponse(
"<script>if(confirm('上传的文件为空')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
filename = file.name
filesuffix = os.path.splitext(filename)[1]
if filesuffix != ".doc" and filesuffix != ".docx":
return HttpResponse(
"<script>if(confirm('模板必须为word格式')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
filename = str(uuid.uuid1()) + filesuffix
fp = open(os.path.join(CONSTANTS.TEMPLATEURL_PRE, filename), 'wb+')
for chunk in file.chunks(): # 分块写入文件
fp.write(chunk)
fp.close()
templateid = TemplateService.addTemplate(experimentid, filename)
ExperimentService.updateExperimentTamplate(experimentid, templateid)
return HttpResponse(
"<script>if(confirm('上传成功')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
def delFilterInfo(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
filterid = utils.getParam(request, "filterid")
if filterid == "" or filterid is None:
responseReturn = Response(-1, "请选择一个班级")
return HttpResponse(responseReturn.__str__())
filterinfo = FilterInfoService.getFilterInfoById(filterid)
if filterinfo is None:
responseReturn = Response(-1, "此班级不存在~")
return HttpResponse(responseReturn.__str__())
count = StudentService.getCountStudentByFilterInfo(filterid)
if count > 0:
responseReturn = Response(-1, "该班级下还有同学，不能删除哦~")
return HttpResponse(responseReturn.__str__())
filterdelinfo = FilterInfoService.delFilterInfo(filterid)
if filterdelinfo is None:
responseReturn = Response(-1, "删除失败，请重试！")
return HttpResponse(responseReturn.__str__())
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def addFilterInfo(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
registyear = utils.getParam(request, "registyear")
major = utils.getParam(request, "major")
classname = utils.getParam(request, "classname")
if registyear is None or registyear == "":
responseReturn = Response(-1, "请输入入学年份~")
return HttpResponse(responseReturn.__str__())
if major is None or major == "":
responseReturn = Response(-1, "请输入专业~")
return HttpResponse(responseReturn.__str__())
if classname is None or classname == "":
responseReturn = Response(-1, "请输入班级~")
return HttpResponse(responseReturn.__str__())
filterinfo = FilterInfoService.getFilterInfo(registyear, major, classname)
if filterinfo is None:
filterinfoid = FilterInfoService.addFilterInfo(registyear, major,
classname)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
else:
responseReturn = Response(-1, "已有此班级，请重新输入~")
return HttpResponse(responseReturn.__str__())
def getStudentByFilterInfoId(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
filterid = utils.getParam(request, "filterid")
if (filterid == "" or filterid is None):
responseReturn = Response(-1, "请选择班级！")
return HttpResponse(responseReturn.__str__())
filterinfo = FilterInfoService.getFilterInfoById(filterid)
if filterinfo is None:
responseReturn = Response(-1, "班级不存在！")
return HttpResponse(responseReturn.__str__())
studentList = StudentService.getStudentListByFilterInfo(filterid)
if studentList is None:
responseReturn = Response(-1, "此班级没有学生！")
return HttpResponse(responseReturn.__str__())
studentDictList = []
for student in studentList:
dict = model_to_dict(student)
del dict["isdelete"]
del dict["createtime"]
del dict["updatetime"]
dict["registyear"] = filterinfo.registyear
dict["major"] = filterinfo.major
dict["classname"] = filterinfo.classname
studentDictList.append(dict)
studentDictListStr = json.dumps(studentDictList, ensure_ascii=False)
responseReturn = Response(None, None)
responseReturn.setRes(studentDictListStr)
return HttpResponse(responseReturn.__str__())
def getListTemplate(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
type = utils.getParam(request, "type")
if type is None or type == "":
responseReturn = Response("-1", "！")
return HttpResponse(responseReturn.__str__())
templateaddr = ""
filename = ""
if type == CONSTANTS.ADD_USER_TYPE_STUDENT:
templateaddr = CONSTANTS.ADDUSERTEMPLATEURL_PRE + "student.xlsx"
filename = "学生名单模板"
elif type == CONSTANTS.ADD_USER_TYPE_TEACHER:
templateaddr = CONSTANTS.ADDUSERTEMPLATEURL_PRE + "teacher.xlsx"
filename = "教师名单模板"
elif type == CONSTANTS.ADD_USER_TYPE_ADMIN:
templateaddr = CONSTANTS.ADDUSERTEMPLATEURL_PRE + "admin.xlsx"
filename = "管理员名单模板"
if os.path.exists(templateaddr) != True:
return HttpResponse("未找到文件")
file = open(templateaddr, "rb")
response = FileResponse(file)
response['Content-Type'] = 'application/octet-stream'
response['Content-Disposition'] = 'attachment;filename="%s"' % (
urlquote(filename + '.xlsx'))
return response
def deleteTeachingByid(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teachingid = utils.getParam(request, "teachingid")
TeachingService.deleteTeachingByid(teachingid)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def resetTeacherPwd(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teacherid = utils.getParam(request, "teacherid")
TeacherService.resetPassword(teacherid)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def deleteStudentByid(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
stuid = utils.getParam(request, "studentid")
StudentService.deleteStudent(stuid)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def v_teachermanagement(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
issuperadmin = utils.getCookie(request, "issuperadmin")
teachernum = utils.getParam(request, "searchnum")
teachername = utils.getParam(request, "searchname")
adminname = utils.getCookie(request, "adminname")
page = utils.getParam(request, "page")
if (page is None) or page == "":
page = 1
else:
page = int(page)
if (teachernum == "" or teachernum is None) and (teachername == ""
or teachername is None):
count = TeacherService.getCountTeacher(None, None)
countpage = 0
i = 0
if count > 0:
if count % 10 > 0:
i = 1
countpage = count / 10 + i
teacherList = TeacherService.getTeacherByPage(None, None, page)
else:
count = TeacherService.getCountTeacher(teachername, teachernum)
countpage = 0
i = 0
if count > 0:
if count % 10 > 0:
i = 1
countpage = count / 10 + i
teacherList = TeacherService.getTeacherByPage(teachername, teachernum,
page)
return render(
request, "teachermanagement.html", {
"teacherList": teacherList,
"issuperadmin": issuperadmin,
"stunum": teachernum,
"countpage": countpage,
"searchname": teachername,
"adminname": adminname
})
def v_allexperiment(request):
stuid = utils.getCookie(request, "stuid")
if (stuid is None) or stuid == "":
return getloginResponse(request)
stuname = utils.getCookie(request, "stuname")
teachingCount = getTeachingCount(stuid)
experimentList = ExperimentService.getAllExperiment()
# 获取用于菜单的实验列表
experimentMenuList = []
for experiment in experimentList:
experimentTemp = experiment.copy()
experimentName = experimentTemp["name"]
if len(experimentName) > 8:
experimentName = experimentName[0:10] + "..."
experimentTemp["name"] = experimentName
experimentMenuList.append(experimentTemp)
return render(request, "allexp.html", {"experimentList": experimentList, "experimentMenuList": experimentMenuList,
"teachingCount": teachingCount, "stuname": stuname})
def updateTeachingDeadline(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teachingid = utils.getParam(request, "teachingid")
deadlinestr = utils.getParam(request, "deadline") + " 00:00:00"
deadline = datetime.datetime.strptime(deadlinestr, "%Y-%m-%d %H:%M:%S")
TeachingService.updateTeachingDeadlineById(teachingid, deadline)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def deleteAdminByid(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
issuperadmin = utils.getCookie(request, "issuperadmin")
if issuperadmin != "1" or issuperadmin is None:
responseReturn = Response("-1", "您不是超级管理员，没有删除管理员的权限！")
return HttpResponse(responseReturn.__str__())
deleteadminid = utils.getParam(request, "adminid")
deleteAdmin = AdminService.getAdminById(deleteadminid)
count = TeachingService.getCountByTea(deleteAdmin.teacherid)
if count > 0:
responseReturn = Response("-1", "该教师下有未删除的实验教学")
return HttpResponse(responseReturn.__str__())
admin = AdminService.deleteAmin(deleteadminid)
if admin is None:
responseReturn = Response("-1", "删除失败！")
return HttpResponse(responseReturn.__str__())
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def deleteTeacherByid(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teacherid = utils.getParam(request, "teacherid")
count = TeachingService.getCountByTea(teacherid)
if count > 0:
responseReturn = Response("-1", "该教师下有未删除的实验教学")
return HttpResponse(responseReturn.__str__())
TeacherService.deleteTeacher(teacherid)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def v_adduser(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
issuperadmin = utils.getCookie(request, "issuperadmin")
adminname = utils.getCookie(request, "adminname")
filterInfoList = FilterInfoService.getFilterInfoList(None)
filterInfoDictList = []
for filterinfo in filterInfoList:
dict = model_to_dict(filterinfo)
del dict["isdelete"]
del dict["createtime"]
del dict["updatetime"]
filterInfoDictList.append(dict)
filterInfoListstr = json.dumps(filterInfoDictList, ensure_ascii=False)
return render(
request, "adduser.html", {
"issuperadmin": issuperadmin,
"adminname": adminname,
"filterInfoList": filterInfoList,
"filterInfoListstr": filterInfoListstr
})
def addBatchAdmin(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
return getloginResponse(request)
file = request.FILES.get('file', None)
if file is None:
return HttpResponse(
"<script>if(confirm('请选择你要上传的管理员名单！')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
adminfilename = file.name
adminlistfilesuffix = os.path.splitext(adminfilename)[1]
if adminlistfilesuffix != ".xsl" and adminlistfilesuffix != ".xlsx":
return HttpResponse(
"<script>if(confirm('管理员名单必须为excel格式！')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
adminfilename = str(uuid.uuid1()) + adminlistfilesuffix
fp = open(os.path.join(CONSTANTS.STUDENTLISTURL_PRE + adminfilename),
'wb+')
for chunk in file.chunks(): # 分块写入文件
fp.write(chunk)
fp.close()
adminlist = getAdminListByExcel(adminfilename)
for admin in adminlist:
teacher = TeacherService.getTeacherByNumber(admin["number"])
teachername = admin["name"]
teachernum = admin["number"]
if teacher is None:
teacherid = TeacherService.addTeacher(teachername, teachernum)
teacher = TeacherService.getTeacherById(teacherid)
if teacher.name != admin["name"]:
return HttpResponse(
"<script>if(confirm('教师姓名" + admin["name"] + "与教师编号" +
admin["number"] +
"不符，请确认!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
adminobj = AdminService.getAdminByTeacherId(teacher.id)
if adminobj is not None:
return HttpResponse(
"<script>if(confirm('此教师" + admin["number"] +
"已经设置过管理员!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
adminid = AdminService.addAdmin(teacher.id)
return HttpResponse(
"<script>if(confirm('添加成功！')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>"
)
def v_addexp(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
return getloginResponse(request)
teachername = utils.getCookie(request, "teachername")
teachingCount = getTeachingCount(teacherid)
experimentList = ExperimentService.getAllExperiment()
# 获取用于菜单的实验列表
experimentMenuList = []
for experiment in experimentList:
experimentTemp = experiment.copy()
experimentName = experimentTemp["name"]
if len(experimentName) > 8:
experimentName = experimentName[0:10] + "..."
experimentTemp["name"] = experimentName
experimentMenuList.append(experimentTemp)
filterInfoList = FilterInfoService.getFilterInfoList(None)
filterInfoDictList = []
for filterinfo in filterInfoList:
dict = model_to_dict(filterinfo)
del dict["isdelete"]
del dict["createtime"]
del dict["updatetime"]
filterInfoDictList.append(dict)
filterInfoListstr = json.dumps(filterInfoDictList, ensure_ascii=False)
response = render(
request, "addexp.html", {
"teachingCount": teachingCount,
"experimentList": experimentList,
"experimentMenuList": experimentMenuList,
"teachername": teachername,
"filterInfoListstr": filterInfoListstr
})
return response
def scoreReport(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
reportid = utils.getParam(request, "reportid")
scorestr = utils.getParam(request, "score")
if scorestr == "" or scorestr == "0":
responseReturn = Response(-1, "打分异常")
response = HttpResponse(responseReturn.__str__())
return response
score = int(scorestr)
ReportService.scoreReport(reportid, score)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def updateTeachingVideo(request):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teachingid = utils.getParam(request, "teachingid")
videos = utils.getParam(request, "videos")
if teachingid == "" or teachingid is None:
responseReturn = Response(-1, "操作有误，请重试")
return HttpResponse(responseReturn.__str__())
if videos == "" or videos is None:
responseReturn = Response(-1, "更换的视频不能为空")
return HttpResponse(responseReturn.__str__())
TeachingService.updateTeachingVideoById(teachingid, videos)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def addTeacher(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
teachernum = utils.getParam(request, "teachernum")
teachername = utils.getParam(request, "teachername")
if (teachername == "" or teachernum == ""):
responseReturn = Response("-1", "填写的信息不能为空！")
return HttpResponse(responseReturn.__str__())
teacher = TeacherService.getTeacherByNumber(teachernum)
if teacher is not None:
responseReturn = Response("-1", "此教师已经存在！")
return HttpResponse(responseReturn.__str__())
TeacherService.addTeacher(teachername, teachernum)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def addStudent(request):
adminid = utils.getCookie(request, "adminid")
if adminid == "" or adminid is None:
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
studentnum = utils.getParam(request, "studentnum")
studentname = utils.getParam(request, "studentname")
filterinfoid = utils.getParam(request, "filterinfoid")
if (studentname == "" or studentnum == "" or filterinfoid == ""):
responseReturn = Response("-1", "填写的信息不能为空！")
return HttpResponse(responseReturn.__str__())
student = StudentService.getStudentByNum(studentnum)
if student is not None:
responseReturn = Response("-1", "此学生已经存在！")
return HttpResponse(responseReturn.__str__())
StudentService.addStudent(studentname, studentnum, filterinfoid)
responseReturn = Response(None, None)
return HttpResponse(responseReturn.__str__())
def getStudentListByExcel(filename):
teacherid = utils.getCookie(request, "teacherid")
if (teacherid is None) or teacherid == "":
responseReturn = Response(-2, "请登录")
return HttpResponse(responseReturn.__str__())
studentlist = []
book = xlrd.open_workbook(CONSTANTS.STUDENTLISTURL_PRE + filename)
sheet0 = book.sheet_by_index(0)
nrows = sheet0.nrows # 获取行总数
for i in range(nrows):
if i == 0:
continue
row_data = sheet0.row_values(i)
student = {
"name": sheet0.cell_value(i, 0),
"number": str(int(sheet0.cell_value(i, 1))),
}
studentlist.append(student)
return studentlist
