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)