def add_user():
if request.method == "GET":
return render_template("adduser.html")
if request.method == "POST":
data = dict((k,v[0]) for k,v in dict(request.form).items())
print data
print [ n.values() for n in userlist(["name"]) ]
if data["name"] in [ n.values()[0] for n in userlist(["name"]) ]:
errmsg = "username is exist"
rdata = json.dumps({"tag":0,"msg":errmsg})
return rdata
if not data["name"] or not data["password"] or not data["role"]:
errmsg = "username or password or role not null"
rdata = json.dumps({"tag":0,"msg":errmsg})
return rdata
if data["password"] != data["re_password"]:
errmsg = "The two passwords you typed do not match"
rdata = json.dumps({"tag":0,"msg":errmsg})
return rdata
fields = ["name","name_cn","password","mobile","email","role","status"]
values = [ '%s'%data[x] for x in fields]
userdic = dict([(k,values[i]) for i,k in enumerate(fields)])
adduser(userdic)
rdata = json.dumps({"tag":1})
return rdata
def login():
if request.method == "GET":
return render_template("login.html")
if request.method == "POST":
login_info = dict((k, v[0]) for k, v in dict(request.form).items())
if not login_info["name"] or not login_info["password"]:
errmsg = "username or password or role not null"
data = json.dumps({"tag": 0, "msg": errmsg})
return data
if login_info["name"] not in [
n.values()[0] for n in userlist(["name"])
]:
errmsg = "user is not exist"
data = json.dumps({"tag": 0, "msg": errmsg})
return data
if login_info["password"] != checkuser({'name': login_info["name"]}):
errmsg = "password error"
data = json.dumps({"tag": 0, "msg": errmsg})
return data
else:
u_role = [
u['role'] for u in userlist(["name", "role"])
if u['name'] == login_info["name"]
][0]
session["username"] = login_info["name"]
session["role"] = u_role
data = json.dumps({"tag": 1})
return data
def userlist():
if session.get('role')=='admin':
return render_template('userlist.html',users = db.userlist(),username = session.get('name'))
elif session.get('role')=='user':
return render_template('userone.html',user = db.userlist(session.get('name')),username = session.get('name'))
else:
return redirect('/')
def userlist():
if session.get('role') == 'admin':
return render_template('userlist.html',
users=db.userlist(),
username=session.get('name'))
elif session.get('role') == 'user':
return render_template('userone.html',
user=db.userlist(session.get('name')),
username=session.get('name'))
else:
return redirect('/')
def index():
fields = ["id","name","name_cn","mobile","email","role","status"]
username = session.get("username")
u_role = session.get("role")
if u_role == "admin":
data = userlist(fields)
return render_template("index.html",users = data, username=username)
else:
uid = [ u['id'] for u in userlist(['id','name']) if u['name'] == username ][0]
data = getone(uid)
return render_template("self.html",users = data, username=username)
def userlist():
if not session.get('name'):
return render_template('login.html')
role = session.get('role')
if role == 'admin':
users = db.userlist()
return render_template("userlist.html", users=users, role=role)
else:
user = db.userlist(session.get('name'))
info = 'you are not admin'
return render_template("userself.html",
user=user,
role=role,
info=info)
def add():
if not session.get('name'):
return redirect('/login')
if request.method == 'GET':
return render_template('add.html', info=session)
if request.method == 'POST':
l = []
data = dict((k, v[0]) for k, v in dict(request.form).items())
for i in db.userlist():
l.append(i['name'])
if not data['name']:
return json.dumps({'code': 1, 'errmsg': 'name can not be null'})
elif not data['name_cn']:
return json.dumps({
'code': 1,
'errmsg': 'chinese name can not be null'
})
elif not data['password']:
return json.dumps({
'code': 1,
'errmsg': 'password can not be null'
})
elif data['name'] not in l:
conditions = ["%s='%s'" % (k, v) for k, v in data.items()]
db.useradd(conditions)
return json.dumps({'code': 0, 'result': 'add user success'})
return json.dumps({'code': 1, 'errmsg': 'username is exist'})
def userself():
if not session.get('name'):
return render_template('login.html')
role = session.get('role')
name = session.get('name')
user = db.userlist(session.get('name'))
return render_template("userself.html", user=user, role=role)
def modpwd():
if not session.get('name'):
return redirect('/login')
data = dict(request.form)
if 'password' in data.keys():
if not data['password'][0] or not data['newpassword'][0] or not data[
'renewpassword'][0]:
errmsg = 'password can not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
else:
if not data['newpassword'][0] or not data['renewpassword'][0]:
errmsg = 'password can not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
if data['newpassword'][0] != data['renewpassword'][0]:
errmsg = 'The two passwords you entered do not match'
return json.dumps({'code': '1', 'errmsg': errmsg})
try:
condition = [
"%s='%s'" % ('password', v[0]) for k, v in data.items()
if k == 'newpassword'
]
sesname = session.get('name')
if session.get('role') == 'admin':
db.update(condition, data['id'][0])
return json.dumps({'code': '0', 'result': 'modify completed!'})
else:
if data['password'][0] == db.userlist(sesname)['password']:
db.update(condition, data['id'][0])
return json.dumps({'code': '0', 'result': 'modify completed!'})
return json.dumps({'code': '1', 'errmsg': 'wrong old password'})
except:
errmsg = "modify failed"
return json.dumps({'code': '1', 'errmsg': errmsg})
def add_user():
if request.method == "GET":
return render_template("adduser.html")
if request.method == "POST":
data = dict((k,v[0]) for k,v in dict(request.form).items())
print data
print [ n.values() for n in userlist(["name"]) ]
def index():
if request.method=='GET':
return render_template('login.html')
else:
name = request.form.get('name')
password = request.form.get('password')
d = {}
for i in db.userlist():
d[i['name']] = i['password']
if name=='admin' and d[name]==password:
return render_template('userlist.html',users = db.userlist())
elif name in d and d[name]==password:
return render_template('userone.html',user = db.userlist(name))
else:
return render_template('error.html')
def modpwd_msg():
name = request.args.get('name')
user = db.userlist(name)
if session.get('role') == 'admin':
return json.dumps({'code': 0, 'result': user})
else:
return json.dumps({'code': 2, 'result': user})
def index():
if request.method == 'GET':
return render_template('login.html')
else:
name = request.form.get('name')
password = request.form.get('password')
d = {}
for i in db.userlist():
d[i['name']] = i['password']
if name == 'admin' and d[name] == password:
return render_template('userlist.html', users=db.userlist())
elif name in d and d[name] == password:
return render_template('userone.html', user=db.userlist(name))
else:
return render_template('error.html')
def delete():
if session.get('role') != 'admin':
return redirect('/')
id = request.args.get('id')
db.deluser(id)
return render_template('userlist.html',
users=db.userlist(),
username=session.get('name'))
def userlist():
if session.get('role') == 'admin':
users = db.userlist()
return json.dumps({
'code': 0,
'result': users,
'name': session.get('name')
})
elif session.get('role') == 'user':
user = db.userlist(session.get('name'))
return json.dumps({
'code': 1,
'result': user,
'name': session.get('name')
})
else:
return redirect('/')
def update():
if request.method=='GET':
id = request.args.get('id')
return render_template('update.html',user = db.update_list(id))
else:
data = dict(request.form)
conditions = [ "%s='%s'" % (k,v[0]) for k,v in data.items()]
db.update(conditions,data['id'][0])
return render_template('userlist.html',users = db.userlist())
def modpwd():
if not session.get('name'):
return redirect('/')
if request.method == 'GET':
sesname = session.get('name')
name = request.args.get('name')
if not name:
name = sesname
return render_template('modpwd.html', username=sesname, name=name)
else:
data = dict(request.form)
if data['newpassword'][0] != data['renewpassword'][0]:
errmsg = 'The two passwords you entered do not match'
return json.dumps({'code': '1', 'errmsg': errmsg})
if not data['password'][0] or not data['newpassword'][0] or not data[
'renewpassword'][0]:
errmsg = 'password can not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
try:
condition = [
"%s='%s'" % ('password', v[0]) for k, v in data.items()
if k == 'newpassword'
]
sesname = session.get('name')
print db.userlist(sesname)
if session.get('role') == 'admin':
db.update(condition, data['id'][0])
return json.dumps({'code': '0', 'result': 'modify completed!'})
elif session.get('role') == 'user':
if data['password'][0] == db.userlist(sesname)['password']:
return json.dumps({
'code': '0',
'result': 'modify completed!'
})
return json.dumps({
'code': '1',
'errmsg': 'wrong old password'
})
else:
return redirect('/')
except:
errmsg = "modify failed"
return json.dumps({'code': '1', 'errmsg': errmsg})
def update():
if request.method == 'GET':
id = request.args.get('id')
return render_template('update.html', user=db.update_list(id))
else:
data = dict(request.form)
conditions = ["%s='%s'" % (k, v[0]) for k, v in data.items()]
db.update(conditions, data['id'][0])
return render_template('userlist.html', users=db.userlist())
def login():
if request.method == "GET":
return render_template("login.html")
if request.method == "POST":
login_info = dict((k,v[0]) for k,v in dict(request.form).items())
if not login_info["name"] or not login_info["password"]:
errmsg = "username or password or role not null"
data = json.dumps({"tag":0,"msg":errmsg})
return data
if login_info["name"] not in [ n.values()[0] for n in userlist(["name"]) ]:
errmsg = "user is not exist"
data = json.dumps({"tag":0,"msg":errmsg})
return data
if login_info["password"] != checkuser({'name':login_info["name"]}):
errmsg = "password error"
data = json.dumps({"tag":0,"msg":errmsg})
return data
else:
u_role = [ u['role'] for u in userlist(["name","role"]) if u['name'] == login_info["name"] ][0]
session["username"] = login_info["name"]
session["role"] = u_role
data = json.dumps({"tag":1})
return data
def modify_pwd_all():
if request.method == 'GET':
id = request.args.get('id')
return render_template('modify_pwd_all.html',user = db.update_list(id))
else:
data = dict(request.form)
if data['newpassword'][0] != data['renewpassword'][0]:
errmsg = 'The two passwords you typed do not match'
return render_template('modify_pwd_all.html',result = errmsg)
try:
condition = [ "%s='%s'" % ('password',v[0]) for k,v in data.items() if k == 'newpassword']
db.update(condition,data['id'][0])
return render_template('userlist.html',users = db.userlist())
except:
errmsg = "modify failed"
return render_template('modify_pwd_all.html',result = errmsg)
def login():
if request.method == "GET":
return render_template("login.html")
if request.method == "POST":
login_info = dict((k,v[0]) for k,v in dict(request.form).items())
if not login_info["name"] or not login_info["password"]:
errmsg = "username or password or role not null"
return render_template("login.html",result=errmsg)
if login_info["name"] not in [ n.values()[0] for n in userlist(["name"]) ]:
errmsg = "user is not exist"
return render_template("login.html",result=errmsg)
if login_info["password"] != checkuser(login_info["name"]):
errmsg = "password error"
return render_template("login.html",result=errmsg)
else:
session["username"] = login_info["name"]
return redirect("/")
def index():
if request.method == 'GET':
return render_template('login.html')
else:
name = request.form.get('name')
password = request.form.get('password')
d = {}
for i in db.userlist():
d[i['name']] = [i['password'], i['role']]
if name in d and d[name][0] == password:
session['name'] = name
session['role'] = d[name][1]
return json.dumps({'code': '0', 'result': 'login success'})
elif not name or not password:
errmsg = 'name or password not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
else:
errmsg = 'name or password wrong'
return json.dumps({'code': '1', 'errmsg': errmsg})
def modify_pwd_all():
if request.method == 'GET':
id = request.args.get('id')
return render_template('modify_pwd_all.html', user=db.update_list(id))
else:
data = dict(request.form)
if data['newpassword'][0] != data['renewpassword'][0]:
errmsg = 'The two passwords you typed do not match'
return render_template('modify_pwd_all.html', result=errmsg)
try:
condition = [
"%s='%s'" % ('password', v[0]) for k, v in data.items()
if k == 'newpassword'
]
db.update(condition, data['id'][0])
return render_template('userlist.html', users=db.userlist())
except:
errmsg = "modify failed"
return render_template('modify_pwd_all.html', result=errmsg)
def index():
if request.method=='GET':
return render_template('login.html')
else:
name = request.form.get('name')
password = request.form.get('password')
d = {}
for i in db.userlist():
d[i['name']] = [i['password'],i['role']]
if name in d and d[name][0]==password:
session['name']=name
session['role']=d[name][1]
return json.dumps({'code':'0','result':'login success'})
elif not name or not password:
errmsg = 'name or password not be null'
return json.dumps({'code':'1','errmsg':errmsg})
else:
errmsg = 'name or password wrong'
return json.dumps({'code':'1','errmsg':errmsg})
def login():
if request.method == "GET":
return render_template("login.html")
if request.method == "POST":
login_info = dict((k, v[0]) for k, v in dict(request.form).items())
if not login_info["name"] or not login_info["password"]:
errmsg = "username or password or role not null"
return render_template("login.html", result=errmsg)
if login_info["name"] not in [
n.values()[0] for n in userlist(["name"])
]:
errmsg = "user is not exist"
return render_template("login.html", result=errmsg)
if login_info["password"] != checkuser(login_info["name"]):
errmsg = "password error"
return render_template("login.html", result=errmsg)
else:
session["username"] = login_info["name"]
return redirect("/")
def add_user():
if request.method == "GET":
return render_template("adduser.html")
if request.method == "POST":
data = dict((k,v[0]) for k,v in dict(request.form).items())
print data
if data["name"] in [ n.values() for n in userlist(["name"]) ]:
errmsg = "username is exist"
return render_template("adduser.html",msg=errmsg)
if not data["name"] or not data["password"] or not data["role"]:
errmsg = "username or password or role not null"
return render_template("adduser.html",msg=errmsg)
if data["password"] != data["re_password"]:
errmsg = "The two passwords you typed do not match"
print session.get("username")
return render_template("adduser.html",msg=errmsg)
fields = ["name","name_cn","password","mobile","email","role","status"]
values = [ '%s'%data[x] for x in fields]
userdic = dict([(k,values[i]) for i,k in enumerate(fields)])
adduser(userdic)
return redirect("/")
def index():
fields = ["id","name","name_cn","mobile","email","role","status"]
data = userlist(fields)
username = session.get("username")
return render_template("index.html",users = data, username=username)
def delete():
if session.get('role') != 'admin':
return redirect('/')
id = request.args.get('id')
db.deluser(id)
return render_template('userlist.html',users = db.userlist(),username = session.get('name'))
def index():
fields = ["id", "name", "name_cn", "mobile", "email", "role", "status"]
data = userlist(fields)
username = session.get("username")
return render_template("index.html", users=data, username=username)
def user_list():
fields = ["id","name","name_cn","mobile","email","role","status"]
data = userlist(fields)
return render_template("userlist.html",users = data)
return render_template("index.html",users = data, username=username)
else:
uid = [ u['id'] for u in userlist(['id','name']) if u['name'] == username ][0]
data = getone(uid)
return render_template("self.html",users = data, username=username)
@app.route("/adduser",methods=["GET","POST"])
@login_required
def add_user():
if request.method == "GET":
return render_template("adduser.html")
if request.method == "POST":
data = dict((k,v[0]) for k,v in dict(request.form).items())
print data
print [ n.values() for n in userlist(["name"]) ]
if data["name"] in [ n.values()[0] for n in userlist(["name"]) ]:
errmsg = "username is exist"
rdata = json.dumps({"tag":0,"msg":errmsg})
return rdata
if not data["name"] or not data["password"] or not data["role"]:
errmsg = "username or password or role not null"
rdata = json.dumps({"tag":0,"msg":errmsg})
return rdata
if data["password"] != data["re_password"]:
errmsg = "The two passwords you typed do not match"
rdata = json.dumps({"tag":0,"msg":errmsg})
return rdata
fields = ["name","name_cn","password","mobile","email","role","status"]
values = [ '%s'%data[x] for x in fields]
userdic = dict([(k,values[i]) for i,k in enumerate(fields)])
def delete():
id = request.args.get('id')
db.deluser(id)
return render_template('userlist.html', users=db.userlist())
def listone():
name = request.form.get('name')
return render_template('listone.html', user=db.userlist(name))
def listone():
name = request.form.get('name')
return render_template('listone.html',user = db.userlist(name))
def delete():
id = request.args.get('id')
db.deluser(id)
return render_template('userlist.html',users = db.userlist())
