基于python的高校学生学业预警系统源码数据库.zip

import time from django.shortcuts import render from .models import UserTable, Student from django.http import JsonResponse, HttpResponseRedirect from django.core.paginator import Paginator # from utils.mypage import Pagination def register(request): """ 注册账号 :return: """ try: name = request.POST.get('username') passwd = request.POST.get('password') phone = request.POST.get('phone') user = UserTable.objects.filter(name=name) if user: return JsonResponse({'message': '用户已存在,请直接登录'}, status=403) UserTable.objects.create( name=name, password=passwd, phone=phone, role=2, description='无' ) response_data = {'message': '注册成功'} return JsonResponse(response_data) except Exception as e: print(e) return JsonResponse({'message': '注册失败'}, status=401) def add_student(request): """ 注册账号 :return: """ try: name = request.POST.get('username') number = request.POST.get('number') phone = request.POST.get('phone') gaokao_score = request.POST.get('gaokao_score') enrollment_year = request.POST.get('enrollment_year') zhuanye = request.POST.get('zhuanye') status = request.POST.get('status') score = request.POST.get('score') xueqi = request.POST.get('xueqi') user = Student.objects.filter(number=number) print(number,name,phone,gaokao_score,zhuanye,enrollment_year) if user: return JsonResponse({'message': '学生已存在,请直接登录'}, status=403) Student.objects.create( name=name, number=number, gaokao_score=gaokao_score, enrollment_year=enrollment_year, zhuanye=zhuanye, status=status, score=score, phone=phone, xueqi=xueqi, ) response_data = {'message': '注册成功'} return JsonResponse(response_data) except Exception as e: print(e) return JsonResponse({'message': '注册失败'}, status=401) def get_user(request): """ 获取用户列表信息 | 模糊查询 :param request: :return: """ keyword = request.GET.get('name') page = request.GET.get("page", '') limit = request.GET.get("limit", '') role_id = request.GET.get('position', '') response_data = {} response_data['code'] = 0 response_data['msg'] = '' data = [] if keyword is None: results = UserTable.objects.all() paginator = Paginator(results, limit) results = paginator.page(page) if results: for user in results: record = { "id": user.id, "name": user.name, "password": user.password, "phone": user.phone, "role": user.role, 'create_time': user.create_time.strftime('%Y-%m-%d %H:%m:%S'), "desc": user.description, } data.append(record) response_data['count'] = len(results) response_data['data'] = data else: users_all = UserTable.objects.filter(name__contains=keyword).all() paginator = Paginator(users_all, limit) results = paginator.page(page) if results: for user in results: record = { "id": user.id, "name": user.name, "password": user.password, "role": user.role, "phone": user.phone, 'create_time': user.create_time.strftime('%Y-%m-%d %H:%m:%S'), "desc": user.description, } data.append(record) response_data['count'] = len(users_all) response_data['data'] = data return JsonResponse(response_data) def user(request): """ 跳转用户页面 """ username = request.session['username'] role_id = request.session['role'] user_id = request.session['user_id'] return render(request, 'user.html', locals()) def student(request): """ 跳转用户页面 """ username = request.session['username'] role_id = request.session['role'] user_id = request.session['user_id'] return render(request, 'student.html', locals()) def password(request): username = request.session['username'] role_id = request.session['role'] user_id = request.session['user_id'] return render(request,'modify_password.html',locals()) def login_check(request): """ 登录校验 """ response_data = {} name = request.GET.get('username') password = request.GET.get('password') user = UserTable.objects.filter(name=name, password=password).first() info = {} if user: # 将用户名存入session中 request.session["username"] = user.name request.session["role"] = user.role request.session["user_id"] = user.id response_data['message'] = '登录成功' return JsonResponse(response_data, status=201) else: return JsonResponse({'message': '用户名或者密码不正确'}, status=401) def student_login(request): """ 登录校验 """ response_data = {} number = request.GET.get('number') password = request.GET.get('password') print(number,password) user = Student.objects.filter(number=number, password=password).first() info = {} if user: # 将用户名存入session中 request.session["username"] = user.name request.session["role"] = 2 request.session["user_id"] = user.id response_data['message'] = '登录成功' return JsonResponse(response_data, status=201) else: return JsonResponse({'message': '用户名或者密码不正确'}, status=401) def edit_user(request): """ 修改用户 """ response_data = {} user_id = request.POST.get('id') username = request.POST.get('username') phone = request.POST.get('phone') UserTable.objects.filter(id=user_id).update( name=username, phone=phone) response_data['msg'] = 'success' return JsonResponse(response_data, status=201) def del_user(request): """ 删除用户 """ user_id = request.POST.get('id') result = UserTable.objects.filter(id=user_id).first() try: if not result: response_data = {'error': '删除用户信息失败！', 'message': '找不到id为%s的用户' % user_id} return JsonResponse(response_data, status=403) result.delete() response_data = {'message': '删除成功！'} return JsonResponse(response_data, status=201) except Exception as e: response_data = {'message': '删除失败！'} return JsonResponse(response_data, status=403) def change_password(request): """ 修改密码 """ if request.session['role'] == 3: user_obj = UserTable.objects.filter(name=request.session["username"]).first() else: user_obj = Student.objects.filter(id=request.session['user_id']).first() if user_obj.password == request.POST.get('changePassword'): # 修改的密码与原密码重复不予修改 return JsonResponse({"msg": "修改密码与原密码重复"}), 406 else: # 不重复，予以修改 if request.session['role'] == 3: UserTable.objects.filter(name=request.session["username"]).update( password=request.POS