def users():
#获取所有用户的信息
_users, _errors = user.get_info()
#print _users
#获取当前用户的信息
_user, _error = user.get_info(_id=session.get('id').get('id'))
#print _user
return render_template('users.html', users=_users, curuser=_user)
def custom_logs():
sql = request.form.get('sql','select * from logs limit 10;')
_result,_error = user.get_info(_sql=sql)
if _result:
return render_template("customlogs.html",result=_result,sql=sql)
else:
return render_template("customlogs.html",result=_result,sql=sql,error=_error)
def finder_user():
username = request.form.get('username','')
users,_error = user.get_info(username=username)
if users:
return render_template('users.html',users = users)
flash("Sorry，没有查到相关数据!")
return render_template('users.html')
def users():
#获取所有用户的信息
_users, _errors = user.get_info()
return render_template(
'users.html',
users=_users,
username=session.get('user').get('username')) #加载渲染users.html模板
def login():
username = request.form.get('username', '') #接收用户提交的数据
password = request.form.get('password', '')
#print request.form['username']
#print "username is %s" %username
_users, _error = user.get_info(username=username)
if _users:
_id = _users[0]['id']
age = _users[0]['age']
else:
_id = ''
#希望把ID加进去作为session绑定，后面根据id修改对应用户的密码！
#需要验证用户名密码是否正确
if user.validate_login(username, password): #判断用户登录是否合法
session['user'] = {
'username': username
} #设置session,绑定用户身份信息，和用户名绑定，类似办银行卡
session['id'] = {'id': _id}
session['age'] = {'age': age}
session['password'] = {'password': password}
flash("登陆成功！") #flask的消息闪现，一次生成一个， 通过函数get_flashed_messages()获取
print session #打印session信息，用于查看，理解session
return redirect('/users/#') #跳转到url展示用户页面
else:
#登录失败
return render_template('login.html',
username=username,
error='用户名或密码错误')
def modify_password():
_id = session.get('id').get('id')
print "id is %s" % _id
_users, _error = user.get_info(_id=_id)
if _users:
_username = _users[0]['username']
_password = _users[0]['password']
_age = _users[0]['age']
return render_template('passwd_modify.html', username=_username)
def modify_user():
_id = request.args.get('id', '')
_users,_error = user.get_info(_id=_id)
if _users:
_username = _users[0]['username']
_password =_users[0]['password']
_age = _users[0]['age']
else:
_error = '用户不存在'
return render_template('user_modify.html',_error=_error,_id=_id,password=_password, age=_age, username=_username)
def delete_user():
_id = request.args.get('id')
_user,_error = user.get_info(_id=_id)
if _user is None:
_error = '用户信息不存在'
else:
username = _user[0]['username']
user.delete_user(_id)
flash("%s删除成功" %username)
return redirect('/users/')
def custom_logs():
sql = request.form.get('sql', 'select * from logs limit 10;')
print "sql is %s" % sql
_result, _error = user.get_info(_sql=sql)
if not sql:
return redirect('/user/customlogs/')
if _result:
return render_template("customlogs.html", result=_result, sql=sql)
else:
return render_template("customlogs.html",
result=_result,
sql=sql,
error=_error)
def delete_user():
_id = request.args.get('id')
_user, _error = user.get_info(_id=_id)
if _user is None:
_error = '用户信息不存在'
else:
username = _user[0]['username']
_session_username = session['user']['username']
if user.check_is_admin(_session_username):
user.delete_user(_id)
flash("%s删除成功" % username)
else:
flash('权限不够，只有管理员才能删除用户信息！')
return redirect('/users/')
def logs():
count = request.form.get('count',10)
count = int(count) if str(count).isdigit() else 10
logs,_error = user.get_info(_count=count)
return render_template("logs.html",logs=logs)
