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)
