Django框架基础知识10-内置分页系统
from django.shortcuts import render, redirect, reverse
from datetime import datetime
# Create your views here.
from django.http import HttpResponse, JsonResponse
from django.template.loader import get_template
from teacher.models import Student, StudentDetail, Grade
from crm.settings import UPLOAD_ROOT
from django.db.models import Q
from django.core.paginator import Paginator
def index(request):
students = Student.objects.all()
arg = {
'_meta': 'asdfadsfa'
}
format_str = '%Y-%m-%d %H:%M:%S'
return render(request, 'teacher/index.html', context={
'students': students,
'format_str': format_str,
'arg': arg
})
def login(request):
# url = reverse('teacher:detail', kwargs={'pk': 12})
# return redirect(url) # 硬编码
if request.method == 'POST':
username = request.POST.get('username', '')
password = request.POST.get('password', '')
if username == 'qixiang' and password == '123456':
return redirect(reverse('teacher:index'))
return render(request, 'teacher/login.html')
def detail(request, pk):
# pk 一般是个id 是整数 primary key
return HttpResponse('学生id为%s的详情页' % pk)
def students(request):
section = '学生列表'
# 获取查询参数
search = request.GET.get('search', '').strip()
if search:
if search.isdigit():
# 是qq,或者电话号码
sts = Student.objects.filter(Q(qq=search)|Q(phone=search), is_deleted=False).order_by('-e_time')
else:
# 说明是姓名
sts = Student.objects.filter(name__contains=search, is_deleted=False).order_by('-e_time')
else:
sts = Student.objects.filter(is_deleted=False).order_by('-e_time')
# 当前页码
page = request.GET.get('page', 1)
page = int(page)
# 每页显示多少数据
per_page = request.GET.get('per_page', 10)
per_page = int(per_page)
paginator = Paginator(sts, per_page) #将查询对象进行分页
sts = paginator.get_page(page) # 当前页的数据
return render(request, 'teacher/students.html', context={
'students': sts,
'section': section,
'search': search,
'per_page': per_page,
'page': page,
})
def students_api(request):
sex = request.GET.get('sex')
sex = int(sex)
students = Student.objects.values('name', 'age', 'sex', 'phone').filter(sex=sex)
students = list(students)
res = {'data': students}
return JsonResponse(res)