基于python的毕业设计WebRTC的视频会议系统.zip

from datetime import datetime from flask import Blueprint, render_template, jsonify, request, redirect, url_for from flask_login import login_required, current_user from exts import db from user import user_add, info_add, user_get, info_exist, info_get, info_modify, user_exist, user_modify import json bp_usr = Blueprint(name='usrman', import_name='usrman') @bp_usr.route('/') @login_required def users(): return render_template('users.html') @bp_usr.route('/getusers/<string:type>') @login_required def getusers(type='all'): if type == 'all': sql = '''select * from user,user_info where user.id=user_info.id''' elif type == 'users': sql = '''select * from user,user_info where user.id=user_info.id and user.type=2''' userslist = db.session.execute(sql).fetchall() db.session.close() usersdict = [dict(zip(result.keys(), result)) for result in userslist] for user in usersdict: user['faceb64'] = user['faceb64'].decode() birth = user['birthdate'] now = datetime.now() user['age'] = now.year - birth.year user['birthdatestr'] = birth.strftime('%Y-%m-%d') username = request.args.get('key[username]') usersearh = [] if username is not None: for user in usersdict: if username in user['username']: usersearh.append(user) else: usersearh = usersdict response = { 'code': 0, 'msg': "success", 'count': len(usersearh), 'data': usersearh } return jsonify(response) @bp_usr.route('/getusersnoinfo') @login_required def getusersnoinfo(): sql = '''select * from user where user.id not in ( select id from user_info)''' userslist = db.session.execute(sql).fetchall() db.session.close() usersdict = [dict(zip(result.keys(), result)) for result in userslist] for user in usersdict: user['faceb64'] = user['faceb64'].decode() username = request.args.get('key[username]') usersearh = [] if username is not None: for user in usersdict: if username in user['username']: usersearh.append(user) else: usersearh = usersdict response = { 'code': 0, 'msg': "success", 'count': len(usersearh), 'data': usersearh } return jsonify(response) @bp_usr.route('/add', methods=['POST', 'GET']) @login_required def adduser(): if request.method == 'GET': if current_user.type == 0: # 管理员可添加用户 return render_template('adduser.html') else: return '无操作权限' elif request.method == 'POST': psw = request.form.get('psw', default='123456') username = request.form.get('username') type = request.form.get('type') gender = request.form.get('gender') birthdate = request.form.get('birthdate') birthdate = datetime.strptime(birthdate, '%Y-%m-%d') nickname = request.form.get('nickname') faceb64 = request.form.get('faceb64') id = user_add(username, type, psw, faceb64) info_add(id, gender, birthdate, nickname) return f'添加成功！' @bp_usr.route('/addinfo', methods=['POST', 'GET']) @login_required def addinfo(): if request.method == 'GET': id = current_user.id if info_exist(id): return render_template('infoexist.html') else: return render_template('addinfo.html', id=id) elif request.method == 'POST': id = request.form.get('id') if current_user.type != 0 and id != current_user.id: return '权限不足！' gender = request.form.get('gender') birthdate = request.form.get('birthdate') birthdate = datetime.strptime(birthdate, '%Y-%m-%d') nickname = request.form.get('nickname') info_add(id, gender, birthdate, nickname) return '录入成功！' @bp_usr.route('/modifyinfo', methods=['POST', 'GET']) @login_required def modifyinfo(): if request.method == 'GET': id = current_user.id if not info_exist(id): return render_template('infonotexist.html') else: user_info = info_get(id) return render_template('infomodify.html', info=user_info) elif request.method == 'POST': id = current_user.id nickname = request.form.get('nickname') psw = request.form.get('password') gender = request.form.get('gender') birthdate = request.form.get('birthdate') birthdate = datetime.strptime(birthdate, '%Y-%m-%d') info_modify(id, gender, birthdate, nickname) if psw != '': user_modify(id, psw) return '修改成功！' @bp_usr.route('/modifyinfoof', methods=['POST', 'GET']) @login_required def modifyinfoof(): if request.method == 'GET': if current_user.type != 0: error = { 'message': '权限不足', 'next': '/users/modifyinfo' } return render_template('error.html', error=error) else: return render_template('infomodifyof.html') elif request.method == 'POST': id = request.form.get('id') if not user_exist(id): response = { 'code': -1, 'message': '用户不存在' } elif user_get(id).type < current_user.type: response = { 'code': 0, 'message': '权限不足!' } else: response = { 'code': 1, 'message': '验证通过' } return response @bp_usr.route('/modifyinfoof/<int:id>', methods=['POST', 'GET']) @login_required def modifyinfoofid(id): if request.method == 'GET': if not user_exist(id): error = { 'message': '用户不存在！', 'next': '/users/modifyinfoof' } return render_template('error.html', error=error) elif current_user.type != 0: error = { 'message': '权限不足！', 'next': '/users/modifyinfo' } return render_template('error.html', error=error) else: user_info = info_get(id) return render_template('infomodify.html', info=user_info) elif request.method == 'POST': psw = request.form.get('password') gender = request.form.get('gender') birthdate = request.form.get('birthdate') birthdate = datetime.strptime(birthdate, '%Y-%m-%d') nickname = request.form.get('nickname') info_modify(id, gender, birthdate, nickname) if psw != '': user_modify(id, psw) return '修改成功！' @bp_usr.route('/addinfoof', methods=['POST', 'GET']) @login_required def addinfoof(): if request.method == 'GET': if current_user.type > 1: id = current_user.id return render_template('addinfo.html', id=id) else: return render_template('addinfoof.html') @bp_usr.route('/addinfoof/<int:id>', methods=['POST', 'GET']) @login_required def addinfoofid(id): if request.method == 'GET': if not user_exist(id): error = { 'message': '用户不存在！', 'next': '/users/modifyinfoof' } return render_template('error.html', error=error) elif current_user.type > 1: error = { 'message': '权限不足，您仅可录入自己信息！', 'next': '/users/addinfo' } return render_template('error.html', error=error) elif user_get(id).type < current_user.type: error = { 'message': '权限不足，您仅可录入权限小于自己的信息！', 'next': '/users/addinfoof' }