基于Django的图书借阅管理系统.rar

import time from django.http import HttpResponseRedirect from django.shortcuts import render, redirect from django.core import paginator # Create your views here. from Book.models import Student, Book, UserBookInfo def index(request): return render(request,"index.html") def register(request): return render(request,"register.html") def toRegister(request): # 接收学生注册信息 num=request.POST["num"] psd=request.POST["psd"] name=request.POST["name"] phone=request.POST["phone"] s=Student.objects.filter(number=num) if not s: # 将注册信息添加至数据库中 Student.objects.create(number=num,psd=psd,name=name,phone=phone) # 回到登录页面 return redirect(index) else: return render(request,"registerError.html") # 保存登录信息 student=[] def toLogin(request): # 接收学生的登录信息，并将登录成功的学生信息临时存储 num=request.POST["num"] psd=request.POST["psd"] # 根据登录信息查询数据库该学生是否存在 global student student=Student.objects.filter(number=num,psd=psd) # 如果能查询到数据，则进入主页 if student: return redirect(bookList) else: return render(request,"loginError.html") def bookList(request): try: ym=request.GET["ym"] except: ym=1 # 将所有图书信息查询出来 bookList = Book.objects.all().values() p=paginator.Paginator(bookList,16) page=p.get_page(ym) bookList=page.object_list yms=p.page_range for b in bookList: b["image"] = "img/" + str(b["image"]) return render(request, "home.html", {"student": student[0], "bookList": bookList,"page":page,"yms":yms}) def seach(request): info=request.POST["seach"] # 进行模糊查询 bookList=Book.objects.filter(bookName__contains=info).values() try: ym = request.GET["ym"] except: ym = 1 p = paginator.Paginator(bookList, 16) page = p.get_page(ym) bookList = page.object_list yms = p.page_range for b in bookList: b["image"] = "img/" + str(b["image"]) return render(request, "home.html", {"student": student[0], "bookList": bookList, "page": page, "yms": yms}) def bookInfo(request): id=request.GET["bookid"] # 根据id获得该对应的图书信息 book=Book.objects.get(id=id) book.image="img/"+str(book.image) # 根据当前登录的学生的学号和图书id查询借阅记录表的借阅状态 infos=UserBookInfo.objects.filter(number=student[0].number,bookId=id) # 如果未查询到，则状态为0，表示未借阅,1表示已借阅，2表示已归还 state= infos[0].state if infos else 0 return render(request,"bookInfo.html",{"student":student[0],"book":book,"state":state}) def addUserBookInfo(request): id=request.GET["bookid"] # 根据当前登录的学生的学号和图书id查询借阅记录表的借阅状态 infos = UserBookInfo.objects.filter(number=student[0].id, bookId=id) # 如果未查询到，则状态为0，表示未借阅,1表示已借阅，2表示已归还 state = infos[0].state if infos else 0 # 获得当前实时时间 year=time.strftime("%Y",time.localtime()) month=time.strftime("%m",time.localtime()) day=time.strftime("%d",time.localtime()) hour=time.strftime("%H",time.localtime()) minute=time.strftime("%M",time.localtime()) second=time.strftime("%S",time.localtime()) dt=f"{year}年{month}月{day}日 {hour}:{minute}:{second}" if state == 0: # 表示该学生没有借阅过该书籍,则添加借阅记录 UserBookInfo.objects.create(number=student[0].number,bookId=id,startDate=dt,endDate="",state=1) elif state == 2: # 表示该学生借阅过该书籍，并且也归还了 UserBookInfo.objects.create(number=student[0].number, bookId=id, startDate=dt, endDate="", state=1) return HttpResponseRedirect("/bookInfo/?bookid="+id) def MyJY(request): # 从借阅信息表中查询当前学生借阅的所有书籍信息，根据状态为1的借阅状态 jList=UserBookInfo.objects.filter(number=student[0].number,state=1).values() if jList: for j in jList: book=Book.objects.get(id=j["bookId"]) j["image"]="img/"+str(book.image) j["bookName"]=book.bookName j["bookAddress"]=book.bookAddress return render(request,"myJYInfo.html",{"jList":jList,"student":student[0]}) def updateJYInfo(request): id=request.GET["id"] # 根据借阅信息id归还图书，修改借阅信息表的借阅状态为2 info=UserBookInfo.objects.filter(id=id) # 获得当前实时时间 year = time.strftime("%Y", time.localtime()) month = time.strftime("%m", time.localtime()) day = time.strftime("%d", time.localtime()) hour = time.strftime("%H", time.localtime()) minute = time.strftime("%M", time.localtime()) second = time.strftime("%S", time.localtime()) dt = f"{year}年{month}月{day}日 {hour}:{minute}:{second}" info.update(state=2,endDate=dt) return redirect(MyJY) def hisInfo(request): jList = UserBookInfo.objects.filter(number=student[0].number, state=2).values() if jList: for j in jList: book = Book.objects.get(id=j["bookId"]) j["image"] = "img/" + str(book.image) j["bookName"] = book.bookName j["bookAddress"] = book.bookAddress return render(request, "hisInfo.html", {"jList": jList,"student":student[0]}) def deleteBookInfo(request): id=request.GET["id"] # 根据借阅信息id，删除该借阅记录 info=UserBookInfo.objects.filter(id=id) info.delete() return redirect(hisInfo)