def userinfo():
if not session:
return redirect('/login/')
info = {k: v[0] for k, v in dict(request.args).items()}
if info:
users = getone('user', filed, info)
else:
users = getone('user', filed, session)
return render_template('userinfo.html', users=users['msg'])
def getuser():
if not session:
return redirect("/login/")
data = {k: v[0] for k, v in dict(request.args).items()}
result = db.getone('user', field, data)
result = result["msg"]
return json.dumps(result)
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())
login_info['password'] = hashlib.md5(login_info['password'] +
salt).hexdigest()
name = login_info["name"]
userlists = getone(name)
print userlists
if not login_info.get("name", None) or not login_info.get(
"password", None):
errmsg = "username and password can not be empty"
return json.dumps({'code': '1', 'errmsg': errmsg})
#把数据库中所有的name拿出来存为一个list
if login_info["name"] not in [
n.values()[0] for n in get_userlist(["name"])
]:
namelist = [n.values()[0] for n in get_userlist(["name"])]
print namelist
print login_info["name"]
errmsg = "username not exist"
return json.dumps({'code': '1', 'errmsg': errmsg})
if login_info["password"] != checkuser(login_info["name"]):
errmsg = "password is error"
return json.dumps({'code': '1', 'errmsg': errmsg})
if int(userlists['status']) == 1:
return json.dumps({'code': '1', 'errmsg': "账户被锁定"})
#判断session中的用户名与表单里面的用户名是否相同
session['name'] = login_info['name']
return json.dumps({'code': '0', 'result': "login sucess"})
def userinfo():
if not session:
return redirect("/login/")
data = {"username": session["username"]}
result = db.getone('user', field, data)
result = result["msg"]
# return json.dumps(result)
return render_template("userinfo.html", result=result)
def userinfo():
if not session:
return redirect('/login/')
data = {'name': session['name']}
result = getone('users', field, data)
if result['code'] == 0:
result = result['msg']
return render_template('userinfo.html', user=result)
def userinfo():
if not session.get('name'):
return redirect('/login')
user_items = ["id", "name", "name_cn", "email", "mobile", "role", "status"]
username = session.get("name")
if username == session.get('name'):
users = getone(username)
return render_template("userinfo.html", users=users, username=username)
def jobdetail():
if not session.get('username', None):
return redirect("/login/")
data = {k: v[0] for k, v in dict(request.args).items()}
result = db.getone("ops_jobs", jobs_field, data)
print result
if not result:
result = {"code": 1, "msg": "信息查询失败"}
return json.dumps(result)
def selectone():
if not session:
return redirect('/login/')
data = {k: v[0] for k, v in dict(request.args).items()}
result = getone('user', filed, data)
if result['code'] == 0:
res = result['msg']
return json.dumps(res)
return json.dumps(result)
def update():
if request.method == "GET":
uid = request.args.get("id")
userinfo = getone(uid)
return render_template("modfiy.html", user=userinfo)
if request.method == "POST":
userinfo = dict((k, v[0]) for k, v in dict(request.form).items())
print userinfo
modfiy(userinfo)
return redirect("/")
def update():
if request.method == "GET":
uid = request.args.get("id")
userinfo = getone(uid)
return render_template("modfiy.html",user=userinfo)
if request.method == "POST":
userinfo = dict((k,v[0]) for k,v in dict(request.form).items())
print userinfo
modfiy(userinfo)
return redirect("/")
def userinfo():
if not session.get('name'):
return redirect('/login')
username = session.get("name")
if username == session.get('name'):
fields = ['id', 'name', 'name_cn', 'mobile', 'email', 'role', 'status']
result = db.getone(fields, username)
print result
users = dict((k, result[i]) for i, k in enumerate(fields))
return render_template("userinfo.html", users=users, username=username)
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 cabinet():
if not session or session["role"] == 1:
return redirect("/login/")
result = db.getlist('cabinet', cabinet_field)
result = result["msg"]
for i in result:
idc_data = {'id': i['idc_id']}
idc_result = db.getone('idc', idc_field, idc_data)
idc_result = idc_result['msg']
i['idc_id'] = idc_result['name_cn']
return render_template("cabinet.html", result=result)
def reg():
if request.method == "POST":
field = ['id', 'username', 'password', 'role']
data = {k: v[0] for k, v in dict(request.form).items()}
result = db.getone('user', field, data)
if result['code'] == 0:
return render_template("reg.html", errmsg="用户名已被使用")
else:
field = ['username', 'password', 'role']
result = db.insert('user', field, data)
return redirect("/login/")
return render_template("reg.html")
def addidc():
if request.method == "POST":
idc_field = ['id', 'name', 'name_cn', 'address', 'adminer', 'phone']
data = {k: v[0] for k, v in dict(request.form).items()}
result = db.getone('idc', idc_field, data)
if result['code'] == 0:
return json.dumps("机房名已被使用")
else:
idc_field = ['name', 'name_cn', 'address', 'adminer', 'phone']
result = db.insert('idc', idc_field, data)
return json.dumps(result)
return render_template("idc.html")
def serverupdate():
if request.method == 'GET':
userid = request.args.get('id')
data={'id':userid}
field = ['id','hostname','lan_ip','wan_ip','cabinet_id','op','phone']
ret = getone('server',field,data)['msg']
else:
data = {k:v[0] for k,v in dict(request.form).items()}
field = ['hostname','lan_ip','wan_ip','cabinet_id','op','phone']
result = updateuser('server',field,data)
return json.dumps(result)
return render_template('server/serverupdate.html',server=ret)
def idcupdate():
if request.method == 'GET':
userid = request.args.get('id')
data = {'id': userid}
field = ['id', 'name', 'name_cn', 'address', 'adminer', 'phone']
ret = getone('idc', field, data)['msg']
else:
data = {k: v[0] for k, v in dict(request.form).items()}
field = ['name', 'name_cn', 'address', 'adminer', 'phone']
result = updateuser('idc', field, data)
return json.dumps(result)
return render_template('idc/idcupdate.html', idc=ret)
def updateidc():
if not session:
return redirect('/login/')
if request.method == 'GET':
info = {k: v[0] for k, v in dict(request.args).items()}
res = getone('idc', filed1, info)
if res['code'] == 0:
return json.dumps(res['msg'])
return json.dumps(res)
info = {k: v[0] for k, v in dict(request.form).items()}
res = update('idc', filed1, info)
return json.dumps(res)
def jobdetail():
if not session:
return redirect('/login/')
data = {k: v[0] for k, v in dict(request.args).items()}
#print data
result = getone('ops_jobs', filed, data)
#print result
#result = {'code':0,'msg':res['msg']['apply_desc']}
result['msg']['apply_date'] = str(result['msg']['apply_date'])
result['msg']['deal_time'] = str(result['msg']['deal_time'])
print result
return json.dumps(result)
def update():
if request.method == "GET":
uid = request.args.get("id")
userinfo = getone(uid)
return render_template("update.html",user=userinfo)
if request.method == "POST":
userinfo = dict((k,v[0]) for k,v in dict(request.form).items())
if not userinfo["password"]:
userinfo.pop("password")
print userinfo
modfiy(userinfo)
return redirect("/userlist")
def index():
#判断用户是否登录，如果没有登录就跳转到登录页
if not session.get('name'):
return redirect('/login')
user_items=["id","name","name_cn","email","mobile","role","status"]
username=session.get("name")
if username == "admin":
userlist=get_userlist(user_items)
return render_template("userlist.html",users=userlist,username=username)
else:
users=getone(username)
print users
return render_template("userinfo.html",users=users,username=username)
def update_oneself():
if request.method == 'GET':
userid = request.args.get('id')
data = {'id': userid}
field = ['id', 'name', 'name_cn', 'email', 'mobile']
result = getone('users', field, data)
return json.dumps(result['msg'])
else:
data = {k: v[0] for k, v in dict(request.form).items()}
field = ['name', 'name_cn', 'email', 'mobile']
result = updateuser('users', field, data)
return json.dumps(result)
return render_template('update.html')
def chpwdoneself():
if not session:
return redirect('/login/')
passwd = {k: v[0] for k, v in dict(request.form).items()}
data = {'name': session['name']}
field = ['id', 'name', 'password']
result = getone('users', field, data)
if result['msg']['password'] == passwd['oldpasswd']:
result['msg']['password'] = passwd['newpasswd']
field = ['password']
result = updateuser('users', field, data=result['msg'])
else:
result = {'code': 1, 'msg': u"旧密码不正确请重新输入!"}
return json.dumps(result)
def index():
#判断用户是否登录，如果没有登录就跳转到登录页
if not session.get('name'):
return redirect('/login')
user_items = ["id", "name", "name_cn", "email", "mobile", "role", "status"]
username = session.get("name")
if username == "admin":
userlist = get_userlist(user_items)
return render_template("userlist.html",
users=userlist,
username=username)
else:
users = getone(username)
print users
return render_template("userinfo.html", users=users, username=username)
def cabinetupdate():
if not session:
return redirect("/login/")
if request.method == "GET":
idc = db.getlist('idc', idc_field)
idc = idc["msg"]
data = {k: v[0] for k, v in dict(request.args).items()}
result = db.getone('cabinet', cabinet_field, data)
result = result["msg"]
return render_template("cabinetupdate.html", result=result, idc=idc)
elif request.method == "POST":
data = {k: v[0] for k, v in dict(request.form).items()}
print data
result = db.updata('cabinet', data)
return json.dumps(result)
def updatepassword():
if not session:
return redirect('/login/')
info = {k: v[0] for k, v in dict(request.form).items()}
users = getone('user', filed, session)
if info['oldpasswd'] == users['msg']['password']:
file = ['id', 'password']
data = {}
data['password'] = info['newpasswd']
data['id'] = session['id']
result = update('user', file, data)
return json.dumps(result)
else:
result = {'errmsg': 'password is error'}
return json.dumps(result)
def login():
if request.method == 'POST':
info = {k: v[0] for k, v in dict(request.form).items()}
result = getone('user', filed, info)
if result['code'] == 0:
if result['msg']['password'] == info['password']:
session['username'] = info['username']
session['role'] = result['msg']['role']
session['id'] = result['msg']['id']
return json.dumps(result)
else:
result = {'errmsg': 'passwd is error'}
return json.dumps(result)
else:
return json.dumps(result)
return render_template('login.html')
def cabinetupdate():
if request.method == 'GET':
userid = request.args.get('id')
data = {'id': userid}
field = ['id', 'name', 'idc_id', 'u_num', 'power']
ret = getone('cabinet', field, data)['msg']
idc_field = ['id', 'name']
idcs = listall('idc', idc_field)['msg']
else:
data = {k: v[0] for k, v in dict(request.form).items()}
field = ['name', 'idc_id', 'u_num', 'power']
result = updateuser('cabinet', field, data)
return json.dumps(result)
return render_template('cabinet/cabinetupdate.html',
cabinet=ret,
idcs=idcs)
def chpwdoneself():
if not session:
return redirect("/login/")
if request.method == "POST":
data = {k: v[0] for k, v in dict(request.form).items()}
user = {}
user["id"] = data["id"]
result = db.getone('user', field, user)
result = result['msg']
if data['oldpasswd'] == result['password']:
user["password"] = data["newpasswd"]
result = db.updata('user', user)
return json.dumps(result)
else:
result = {'errmsg': "原密码错误"}
return json.dumps(result)
def cabinetadd():
if not session or session["role"] == 1:
return redirect("/login/")
result = db.getlist('idc', idc_field)
idc_id = result["msg"]
if request.method == "POST":
cabinet_field = ['id', 'name', 'idc_id', 'u_num', 'power']
data = {k: v[0] for k, v in dict(request.form).items()}
result = db.getone('cabinet', cabinet_field, data)
if result['code'] == 0:
return json.dumps("机柜名已被使用")
else:
cabinet_field = ['name', 'idc_id', 'u_num', 'power']
result = db.insert('cabinet', cabinet_field, data)
return json.dumps(result)
return render_template("cabinetadd.html", idc_id=idc_id)
def login():
if request.method == 'POST':
data = {k: v[0] for k, v in dict(request.form).items()}
result = db.getone('user', field, data)
if result["code"] == 0:
if result['msg']["password"] == data["password"]:
session["username"] = data["username"]
session["role"] = result['msg']["role"]
data = result
utils.WriteLog("app模块", info_filename).info(
"%s用户登录系统" % session["username"])
return json.dumps(data)
else:
data['errmsg'] = "密码错误"
return json.dumps(data)
else:
data['errmsg'] = "用户名错误"
return json.dumps(data)
return render_template("login.html")
def login():
if request.method == 'POST':
data = {k: v[0] for k, v in dict(request.form).items()}
field = ['name', 'password', 'role', 'status']
result = getone('users', field, data)
if result['code'] == 0:
if result['msg']['password'] == data['password']:
WriteLog("login").info("%s login success" % data['name'])
session['name'] = data['name']
session['role'] = result['msg']['role']
return json.dumps(result)
else:
result['code'] = 1
result['msg'] = '密码错误!'
return json.dumps(result)
else:
result['msg'] = "用户名不存在!"
return json.dumps(result)
return render_template('login.html')
import db
a = db.open('dg-new.db')
db.updurls(a)
while db.getone(a):
pass
errmsg = 'must have id'
return render_template('update.html',result=errmsg)
fields = ['id', 'name', 'name_cn', 'email', 'mobile']
'''
try:
sql = 'select %s from users where id = %s ' % (','.join(fields),id)
cur.execute(sql)
res = cur.fetchone()
user = dict((k,res[i]) for i,k in enumerate(fields))
return render_template('update.html', user = user)
except:
errmsg = 'get on failed'
print traceback.print_exc()
return render_template('update.html',result = errmsg)
'''
user = getone(id)
return render_template('update.html', user = user)
@app.route('/')
@app.route('/login',methods=['GET','POST'])
def login():
if request.method == 'POST':
data = dict((k,v[0]) for k,v in dict(request.form).items())
# data = {k:v[0] for k,v in dict(request.form).items()}
print data.get('name')
if not data.get('name',None) or not data.get('password',None):
errmsg = 'name or password not null'
return render_template('login.html',result = errmsg)
fields = ['name','password']
