def add(request):
"""加载添加页面"""
teacher = Model('teacher')
subject = Model('subject')
list1 = teacher.findAll()
list2 = subject.findAll()
context = {"teacher": list1, 'subject': list2}
return render(request, "myadmin/teaching/add.html", context)
def index(request):
data = request.session['teacher']
mod = Model('faculty')
title = mod.findAll()
for faculty in title:
if data['faculty'] == faculty['no']:
data['faculty'] = faculty['name']
data.pop('password')
return render(request, "web/teacher/index.html", {'data': data})
def edit(request, uid):
"""加载编辑信息页面"""
mod = Model('teacher')
ob = mod.find(no=uid)
mod = Model('faculty')
title = mod.findAll()
if ob is not None:
context = {"user": ob, 'typelist': title}
return render(request, "myadmin/users/edit.html", context)
else:
context = {"info": "没有找到要修改的信息！"}
return render(request, "myadmin/info.html", context)
def teaching(request):
"""课程安排"""
data = request.session['teacher']
uid = data.get('no')
subject = Model('subject')
teaching = Model('teaching')
list2 = subject.findAll()
list3 = teaching.find("'" + uid + "'")
umod = []
for teaching in list3:
dir = {}
for subject in list2:
if teaching.get('subject') == subject.get('no'):
dir.update({
'no': subject.get('no'),
'name': subject.get('name'),
'score': subject.get('score')
})
break
dir.update({'class': teaching.get('class')})
umod.append(dir)
# 执行分页处理
pIndex = int(request.GET.get("p", 1))
page = Paginator(umod, 4) # 以50条每页创建分页对象
maxpages = page.num_pages # 最大页数
# 判断页数是否越界
if pIndex > maxpages:
pIndex = maxpages
if pIndex < 1:
pIndex = 1
list2 = page.page(pIndex) # 当前页数据
# 获取页面列表信息
if maxpages < 5:
plist = page.page_range # 页码数列表
else:
if pIndex <= 3:
plist = range(1, 6)
elif pIndex >= maxpages - 3:
plist = range(maxpages - 4, maxpages + 1)
else:
plist = range(pIndex - 2, pIndex + 3)
context = {
"list": list2,
'plist': plist,
'pIndex': pIndex,
'maxpages': maxpages
}
return render(request, "web/teacher/class.html", context)
def index(request):
"""浏览信息"""
mod = Model('subject')
umod = mod.findAll()
mywhere = []
# 获取、判断并封装关keyword键搜索
kw = request.GET.get("keyword", None)
if kw:
# 查询账户中只要含有关键字的都可以
list = []
for vo in umod:
if vo['no'].find(kw) >= 0 or vo['name'].find(kw) >= 0:
list.append(vo)
mywhere.append("keyword=" + kw)
else:
list = umod
# 获取、判断并封装学分score搜索条件
score = request.GET.get('score', '')
if score != '':
temp = []
for vo in list:
if vo['score'] == float(score):
temp.append(vo)
mywhere.append("score=" + kw)
list = temp
# 执行分页处理
pIndex = int(request.GET.get("p", 1))
page = Paginator(list, 4) # 以50条每页创建分页对象
maxpages = page.num_pages # 最大页数
# 判断页数是否越界
if pIndex > maxpages:
pIndex = maxpages
if pIndex < 1:
pIndex = 1
list2 = page.page(pIndex) # 当前页数据
# 获取页面列表信息
if maxpages < 5:
plist = page.page_range # 页码数列表
else:
if pIndex <= 3:
plist = range(1, 6)
elif pIndex >= maxpages - 3:
plist = range(maxpages - 4, maxpages + 1)
else:
plist = range(pIndex - 2, pIndex + 3)
context = {"list": list2, 'plist': plist, 'pIndex': pIndex, 'maxpages': maxpages, 'mywhere': mywhere}
return render(request, "myadmin/subject/index.html", context)
def index(request):
"""管理后台首页"""
umod = Model('teacher')
mode2 = Model('faculty')
faculty = mode2.findAll()
list = []
for vo in faculty:
dir = {}
num = umod.count('faculty', vo['no'])[0]['num']
if num > 0:
dir.update({'faculty': vo['name'], 'num': num})
list.append(dir)
context = {'list': list}
return render(request, "myadmin/index.html", context)
def edit(request, uid):
"""加载编辑信息页面"""
mod = Model('teaching')
ob = mod.find(no=uid)
teacher = Model('teacher')
subject = Model('subject')
list1 = teacher.find(no=uid)
list2 = subject.findAll()
ob[0].update({'teacher': list1[0].get('name')})
print(ob)
print(list2)
if ob is not None:
context = {"teaching": ob, 'subject': list2}
return render(request, "myadmin/teaching/edit.html", context)
else:
context = {"info": "没有找到要修改的信息！"}
return render(request, "myadmin/info.html", context)
def index(request):
"""浏览信息"""
teacher = Model('teacher')
subject = Model('subject')
teaching = Model('teaching')
list1 = teacher.findAll()
list2 = subject.findAll()
list3 = teaching.findAll()
umod = []
mywhere = []
for teaching in list3:
dir = {}
for subject in list2:
for teacher in list1:
if teaching.get('no') == teacher.get('no'):
dir.update({
'tno': teaching.get('no'),
'tname': teacher.get('name')
})
break
if teaching.get('subject') == subject.get('no'):
dir.update({
'sno': subject.get('no'),
'sname': subject.get('name')
})
break
dir.update({'class': teaching.get('class')})
umod.append(dir)
# 获取、判断并封装关keyword键搜索
kw = request.GET.get("keyword", None)
if kw:
# 查询账户中只要含有关键字的都可以
list = []
for vo in umod:
if vo['tno'].find(kw) >= 0 or vo['tname'].find(kw) >= 0:
list.append(vo)
mywhere.append("keyword=" + kw)
else:
list = umod
# 获取、判断并封装学院faculty搜索条件
subject = request.GET.get('subject', '')
if subject != '':
temp = []
for vo in list:
if vo['sno'].find(subject) >= 0 or vo['sname'].find(subject) >= 0:
temp.append(vo)
mywhere.append("subject=" + subject)
list = temp
# 获取、判断并封装教室class搜索条件
classroom = request.GET.get('class', '')
if classroom != '':
temp = []
for vo in list:
if vo['class'].find(classroom) >= 0:
temp.append(vo)
mywhere.append("class=" + kw)
list = temp
# 执行分页处理
pIndex = int(request.GET.get("p", 1))
page = Paginator(list, 4) # 以50条每页创建分页对象
maxpages = page.num_pages # 最大页数
# 判断页数是否越界
if pIndex > maxpages:
pIndex = maxpages
if pIndex < 1:
pIndex = 1
list2 = page.page(pIndex) # 当前页数据
# 获取页面列表信息
if maxpages < 5:
plist = page.page_range # 页码数列表
else:
if pIndex <= 3:
plist = range(1, 6)
elif pIndex >= maxpages - 3:
plist = range(maxpages - 4, maxpages + 1)
else:
plist = range(pIndex - 2, pIndex + 3)
context = {
"list": list2,
'plist': plist,
'pIndex': pIndex,
'maxpages': maxpages,
'mywhere': mywhere
}
return render(request, "myadmin/teaching/index.html", context)
def index(request):
"""浏览信息"""
# sql ='select teacher.no,teacher.faculty,teacher.name,teacher.age,teacher.' \
# 'sex,teacher.position,teacher.degree,phone,faculty.name fa_name from teacher, ' \
# 'faculty where teacher.faculty=faculty.no'
teacher = Model('teacher')
mode2 = Model('faculty')
list1 = teacher.findAll()
faculty = mode2.findAll()
umod = []
mywhere = []
sss = {'name': 1}
# 1、消除教师的密码信息，2、把教师中的学院no更新为学院name
for teaching in list1:
dir = {}
for vo in faculty:
if teaching.get('faculty') == vo.get('no'):
dir.update({
'no': teaching.get('no'),
'name': teaching.get('name'),
'fa_name': vo.get('name'),
'sex': teaching.get('sex'),
'age': teaching.get('age'),
'position': teaching.get('position'),
'degree': teaching.get('degree'),
'phone': teaching.get('phone')
})
break
umod.append(dir)
# 获取、判断并封装关keyword键搜索
kw = request.GET.get("keyword", None)
if kw:
# 查询账户中只要含有关键字的都可以
list = []
for vo in umod:
if vo['no'].find(kw) >= 0 or vo['name'].find(kw) >= 0:
list.append(vo)
mywhere.append("keyword=" + kw)
else:
list = umod
# 获取、判断并封装学院faculty搜索条件
facu = request.GET.get('faculty', '')
if facu != '':
temp = []
for vo in list:
if vo['fa_name'] == facu:
temp.append(vo)
mywhere.append("faculty=" + facu)
list = temp
# 获取、判断并封装职位faculty搜索条件
position = request.GET.get('position', '')
if position != '':
temp = []
for vo in list:
if vo['position'] == position:
temp.append(vo)
mywhere.append("position=" + position)
list = temp
# 获取、判断并封装学历degree搜索条件
degree = request.GET.get('degree', '')
if degree != '':
temp = []
for vo in list:
if vo['degree'] == degree:
temp.append(vo)
mywhere.append("degree=" + degree)
list = temp
# 执行分页处理
pIndex = int(request.GET.get("p", 1))
page = Paginator(list, 4) # 以4条每页创建分页对象
maxpages = page.num_pages # 最大页数
# 判断页数是否越界
if pIndex > maxpages:
pIndex = maxpages
if pIndex < 1:
pIndex = 1
list2 = page.page(pIndex) # 当前页数据
# 获取页面列表信息
if maxpages < 5:
plist = page.page_range # 页码数列表
else:
if pIndex <= 3:
plist = range(1, 6)
elif pIndex >= maxpages - 3:
plist = range(maxpages - 4, maxpages + 1)
else:
plist = range(pIndex - 2, pIndex + 3)
context = {
"userslist": list2,
'plist': plist,
'pIndex': pIndex,
'maxpages': maxpages,
'faculty': faculty,
'mywhere': mywhere
}
return render(request, "myadmin/users/index.html", context)
def add(request):
"""加载添加页面"""
mod = Model('faculty')
title = mod.findAll()
context = {'typelist': title}
return render(request, "myadmin/users/add.html", context)
