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']