def updatacab(): if session.get('name',None): redirect('/login') if request.method == 'POST': data = dict(request.form) fields = ['name','idc_id','u_num','power'] table = 'cabinet' condition = [ "%s='%s'" % (k,v[0]) for k,v in data.items() ] try: db.update(condition, data['id'][0], table) return json.dumps({'code':0, 'result': 'add cabinet success'}) except: print traceback.print_exc() return json.dumps({'code':1,'errmsg':'update cabinet error'}) else: id = request.args.get('id') print id fields = ['id','name','idc_id','u_num','power'] table = 'cabinet' try: result = db.selectId(fields,id,table) cabinet = dict((k,result[i]) for i,k in enumerate(fields)) table_idc = 'idc' fields_idc = ['id','name'] result = db.selectAll(fields_idc,table_idc) print result idcs = [ dict((k,row[i]) for i,k in enumerate(fields_idc)) for row in result ] return render_template('cabinet/updatecabinet.html',info = session, cabinet = cabinet, idcs = idcs) except: print traceback.print_exc() return json.dumps({'code':1, 'result':'select cabinetinfo failed'})
def updateidc(): table = 'idc' if not session.get('name', None): return redirect('/login') if request.method == "POST": data = dict(request.form) print data print data['id'][0] condition = ["%s='%s'" % (k, v[0]) for k, v in data.items()] # pdb.set_trace() print condition try: db.update(condition, data['id'][0], table) return json.dumps({'code': 0, 'result': 'update idc success'}) except: print traceback.print_exc() return json.dumps({'code': 1, 'result': 'update idc failed'}) else: id = request.args.get('id') print id fields = ['id', 'name', 'name_cn', 'address', 'adminer', 'phone'] try: res = db.selectId(fields, id, table) idc = dict((k, res[i]) for i, k in enumerate(fields)) print idc return json.dumps({'code': 0, 'result': idc}) except: print traceback.print_exc() return json.dumps({'code': 1, 'result': 'select idcinfo failed'})
def update(): table = 'users' if not session.get('name',None): return redirect('/login') if request.method == "POST": data = dict(request.form) data['password'][0] = hashlib.md5(data['password'][0]+salt).hexdigest() print data condition = [ "%s='%s'" % (k,v[0]) for k,v in data.items() ] print condition try: db.update(condition, data['id'][0], table) return json.dumps({'code':0,'result':'update user success'}) except: print traceback.print_exc() return json.dumps({'code':1,'result':'update user failed'}) else: id = request.args.get('id') fields = ['id', 'name', 'name_cn', 'email', 'mobile'] try: res = db.selectId(fields,id,table) user = dict((k,res[i]) for i,k in enumerate(fields)) return json.dumps({'code':0, 'result':user}) except: print traceback.print_exc() return json.dumps({'code':1, 'result':'select userinfo failed'})
def chpwdoneself(): if not session.get('name',None): return redirect('/login') if request.method == "POST": data = dict((k,v[0]) for k ,v in dict(request.form).items()) fields = ['password'] id = data['id'] password = db.selectId(fields,id,'users') print data print password if data["oldpasswd"] != password[0]: return json.dumps({"code":1,"errmsg":"password is error"}) try: db.updatepwd(data['newpasswd'],id) return json.dumps({'code':0, 'result':'update password success'}) except: print traceback.print_exc() return json.dumps({'code':1, 'errmsg':'update password failed'})
def updateuser(): table = 'users' if not session.get('name', None): return redirect('/login') if request.method == "POST": data = dict(request.form) print data condition = ["%s='%s'" % (k, v[0]) for k, v in data.items()] print condition db.update(condition, data['id'][0], table) return json.dumps({'code': 0, 'result': 'update user success'}) else: id = request.args.get('uid') print id fields = ['id', 'name', 'name_cn', 'email', 'mobile'] res = db.selectId(fields, id, table) user = dict((k, res[i]) for i, k in enumerate(fields)) return json.dumps(user)
def updateidc(): table = 'idclist' if not session.get('name',None): return redirect('/login') if request.method == "POST": data = dict(request.form) print data condition = [ "%s='%s'" % (k,v[0]) for k,v in data.items() ] print condition db.update(condition, data['id'][0], table) return json.dumps({'code':0,'result':'update idc success'}) else: id = request.args.get('uid') print id fields = ["id","name","cabinets","hosts","contacts","telephone","remarks"] res = db.selectId(fields,id,table) idc = dict((k,res[i]) for i,k in enumerate(fields)) return json.dumps(idc)