def update():
if not session:
return redirect('/')
if request.method=="POST":
user_dict={k:v[0] for k,v in dict(request.form).items()}
print user_dict
if user_dict.has_key('oldpasswd'):
username=session['username']
data1={}
data1['username']=username
field=['id','username','name','password','phone','email','role','status']
result=utils.get_one(table,field,data1)
if user_dict['oldpasswd']==result['msg']['password']:
info={}
field=['id','password']
info['id']=result['msg']['id']
info['password']=user_dict['newpasswd']
util.WriteLog("update_psswd","/tmp/info.log").info("update_passwd:%s"%session['username'])
data=utils.update(table,field,info)
return json.dumps(data)
else:
result={'code':1,'msg':'oldpasswd is error'}
util.WriteLog('update_passwd','/tmp/error.log').error("update_password:%s"%session['username'])
return json.dumps(result)
else:
field=[]
util.WriteLog("update","/tmp/info.log").info("update:%s"%session['username'])
data=utils.update(table,field,user_dict)
return json.dumps(data)
def login():
if request.method == "POST":
data = {k: v[0] for k, v in dict(request.form).items()}
print "login-data"
print data
util.WriteLog('[用户开始登录echo post-data]').info(data)
result = getone('user', field, data)
util.WriteLog('[用户登录echo result]').info(result)
print result
if result['code'] == 0:
if result['msg']['password'] == data['password']:
session['username'] = data['username']
session['role'] = result['msg']['role']
session['id'] = result['msg']['id']
print session
if session['role'] == 0:
return redirect('/userlist/')
else:
return redirect('/')
else:
result['errmsg'] = "user is exist, password is wrong"
else:
result['errmsg'] = "user is not exist"
return render_template("login.html", result=result)
return render_template("login.html")
def select(table,data):
sql='select %s from %s'%(data,table)
try:
cur.execute(sql)
result=cur.fetchall()
util.WriteLog("sql","/tmp/info.log").info("select:%s"%sql)
except:
util.WriteLog('db',"/tmp/info.log").error("Except:%s error:%s"%(sql,traceback.format_exc()))
return result
def insert(table,field,data):
sql="insert into %s (%s) values(%s)"%(table,','.join(field),','.join(['"%s"'% data[x] for x in field]))
try:
res=cur.execute(sql)
util.WriteLog("sql","/tmp/info.log").info("insert:%s"%sql)
result ={'code':0,'msg':'insert ok'}
except:
result={'code':1,'msg':'insert fail'}
util.WriteLog("db","/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc()))
return result
def update(table,field,data):
conditions=['%s="%s"'%(k,data[k])for k in data]
sql="update %s set %s where id=%s"%(table,','.join(conditions),data['id'])
try:
util.WriteLog("sql","/tmp/info.log").info("update:%s"%sql)
cur.execute(sql)
result={'code':0,'msg':'ok'}
except:
result={'code':1,'msg':'update fail'}
util.WriteLog('db',"/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc()))
return result
def delete(table,uid):
sql="delete from %s where id =%s"%(table,uid)
print sql
try:
util.WriteLog("sql","/tmp/info.log").info("delete:%s"%sql)
cur.execute(sql)
result ={'code':0,'msg':'ok'}
except:
result={'code':1,'msg':'delete fail'}
util.WriteLog("db","/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc()))
return result
def addserver():
if request.method == "POST":
data = { k:v[0] for k,v in dict(request.form).items()}
print "模态窗添加server的信息"
print data
util.WriteLog('[模态窗添加server信息]').info(data)
field = ['name','ip','idc_id','cabinet','os','core_num','mem','disk']
result = insert('server',field,data)
print "添加server写完数据库返回的的用户信息"
print result
util.WriteLog('[管理员添加server完成返回]').info(result)
return json.dumps(result)
def reg():
if request.method == "POST":
data = {k: v[0] for k, v in dict(request.form).items()}
print "模态窗添加用户的用户信息"
print data
util.WriteLog('[模态窗添加用户的用户信息]').info(data)
field = ['username', 'password', 'email', 'phone', 'role']
result = insert('user', field, data)
print "添加用户写完数据库返回的的用户信息"
print result
util.WriteLog('[管理员添加用户完成返回]').info(result)
return json.dumps(result)
def list(table,field):
sql="select * from %s"%table
try:
cur.execute(sql)
res=cur.fetchall()
util.WriteLog("sql","/tmp/info.log").info("getlist:%s"%sql)
user=[{k:row[i] for i,k in enumerate(field)}for row in res]
result={'code':0,'msg':user}
except:
result={'code':1,'msg':'data is null'}
util.WriteLog('db',"/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc()))
return result
def reg():
if request.method=='POST':
user_dict={k:v[0] for k,v in dict(request.form).items()}
field=['username','name','password','phone','email','role','status']
res=utils.get_one(table,field,user_dict)
if res['code']==0:
result=utils.insert(table,field,user_dict)
util.WriteLog("register","/tmp/info.log").info("register:%s"%user_dict["username"])
return json.dumps(result)
else:
result={'code':1,'msg':'register username is already exists'}
util.WriteLog("register","/tmp/error.log").info("register:%s"%result['msg'])
return json.dumps(result)
return render_template('reg.html')
def delete(table,uid):
sql = "delete from %s where id = %s" % (table,uid)
print "删除用户sql"
print sql
res = cur.execute(sql)
if res:
result = {'code':0,'msg':'delete ok'}
util.WriteLog('[删除用户]').info('成功成功成功')
else:
util.WriteLog('[删除用户]').info('失败失败失败')
result = {'code':1,'msg':'delete false'}
print "util_delete_result"
print result['msg']
return result
def add():
if not session:
return redirect("/")
if request.method=="POST":
user_dict={k:v[0] for k,v in dict(request.form).items()}
field=['username','name','password','phone','email','role','status']
result=utils.insert(table,field,user_dict)
if result['code']==0:
util.WriteLog("insert","/tmp/info.log").info("inster:%s"%session['username'])
data=result
return json.dumps(data)
else:
util.WriteLog("insert_error","/tmp/error.log").info("inster_error:%s"%session['username'])
data={'code':1,'msg':'insert is error'}
return json.dumps(data)
def get_one(table,field,data):
if data.has_key("username"):
sql='select * from %s where username="******"'%(table,data['username'])
else:
sql='select * from %s where id="%s"'%(table,data['id'])
try:
cur.execute(sql)
res=cur.fetchone()
util.WriteLog("sql","/tmp/info.log").info("getone:%s"%sql)
user={k:res[i] for i,k in enumerate(field)}
result={'code':0,'msg':user}
except:
result={'code':1,'msg':'data is null'}
util.WriteLog('db',"/tmp/error.log").error("Except:%s error:%s"%(sql,traceback.format_exc()))
return result
def server():
if not session:
return redirect('/')
util.WriteLog("server").info("server:%s" % session['username'])
data = utils.list(server_table, server_field)
result = data['msg']
return render_template("server.html", res=session, result=result)
def upinfos():
if not session:
return redirect("/login")
if request.method == 'POST':
data = {k: v[0] for k, v in dict(request.form).iteritems()}
print "upinfo-post-data"
print data
if data.has_key('newpasswd'):
data = {'id': data['id'], 'password': data['newpasswd']}
print data
result = update('user', field, data)
util.WriteLog('[自己修改密码完成返回]').info(result)
return json.dumps(result)
result = update('user', field, data)
util.WriteLog('[自己更新个人资料完成返回]').info(result)
return json.dumps(result)
def modity():
if not session:
return redirect("/login")
if request.method == 'POST':
data = dict(request.form)
print "data11111"
print data
data = {k: v[0] for k, v in data.items()}
print "data2222"
print data
result = update('user', field, data)
if result['code'] == 0:
util.WriteLog('[管理员更新用户资料]').info(result)
return redirect("/userlist/")
else:
return render_template('update.html', result=result)
else:
uid = request.args.get('id', '')
data = {'id': uid}
print "-----------------------管理员更新，get请求过来的form值"
print data
result = getone('user', field, data)
print "-----------------------管理员更新完result"
print result
return render_template('update.html', result=result['msg'])
def delete(table, uid):
sql = "delete from %s where id =%s" % (table, uid)
print sql
util.WriteLog("sql").info("delete:%s" % sql)
cur.execute(sql)
result = {'code': 0, 'msg': 'ok'}
return result
def admlist():
sql_list = "select * from user;"
cur.execute(sql_list)
list = cur.fetchall()
user_list = [dict((k, v[i]) for i, k in enumerate(field)) for v in list]
util.WriteLog('sql').info('SELECT : %s' % sql_list)
return user_list
def idc():
if not session:
return redirect("/")
util.WriteLog("idc", "/tmp/info.log").info("idc:%s" % session['username'])
data = utils.list(idc_table, idc_field)
result = data['msg']
return render_template("idc.html", res=session, result=result)
def delete():
if not session:
return redirect('/')
uid=request.args.get('id')
util.WriteLog("delete","/tmp/info.log").info("delete:%s"%session['username'])
data=utils.delete(table,uid)
return json.dumps(data)
def userlist():
if not session:
return redirect('/')
util.WriteLog("list","/tmp/info.log").info("list:%s"%session['username'])
result=utils.list(table,field)
if result['code']==0:
return render_template('userlist.html',res=session,result=result['msg'])
def server_delete():
if not session:
return redirect('/')
uid = request.args.get('id')
util.WriteLog("server_delete").info("server_delete:%s" %
session['username'])
data = utils.delete(server_table, uid)
return json.dumps(data)
def idc_update():
if not session:
return redirect('/')
if request.method == 'POST':
user_dict = {k: v[0] for k, v in dict(request.form).items()}
util.WriteLog("idc_update").info("idc_update:%s" % session['username'])
data = utils.update(idc_table, idc_field, user_dict)
return json.dumps(data)
def user():
if not session:
return redirect("/")
username=session['username']
user_dict={'username':username}
util.WriteLog("getone","/tmp/info.log").info('get_one:%s'%session['username'])
result=utils.get_one(table,field,user_dict)
return render_template('list.html',res=session,result=result['msg'])
def cabinet():
if not session:
return redirect('/')
util.WriteLog("cabinet").info("cabinet:%s" % session['username'])
data = utils.list(cab_table, cab_field)
print data
result = data['msg']
return render_template("cabinet.html", res=session, result=result)
def update(table, filed, data):
conditions = ['%s="%s"' % (k, data[k]) for k in data]
sql = "update %s set %s where id=%s" % (table, ','.join(conditions),
data['id'])
util.WriteLog("sql").info("update:%s" % sql)
cur.execute(sql)
result = {'code': 0, 'msg': 'ok'}
return result
def getone(name):
sql = "select * from user where username = '******';" % name
cur.execute(sql)
list = cur.fetchone()
col_list = ['id', 'username', 'password', 'role', 'email', 'phone']
user_list = dict((k, list[i]) for i, k in enumerate(col_list))
util.WriteLog('getone').info('getoneinfo : %s' % user_list)
return user_list
def cabinet_update():
if not session:
return redirect('/')
if request.method == 'POST':
user_dict = {k: v[0] for k, v in dict(request.form).items()}
util.WriteLog("cabinet_update", "/tmp/info.log").info(
"cabinet_update:%s" % session['username'])
data = utils.update(cab_table, cab_field, user_dict)
return json.dumps(data)
def insert(table, field, data):
sql = "insert into %s (%s) values (%s)" % (
table, ','.join(field), ','.join(['"%s"' % data[x] for x in field]))
util.WriteLog("sql").info("insert:%s" % sql)
res = cur.execute(sql)
if res:
result = {'code': 0, 'msg': 'insert ok'}
else:
result = {'code': 1, 'msg': 'insert fail'}
return result
def login():
if request.method=='POST':
user_dict={k:v[0] for k,v in dict(request.form).items()}
user=utils.get_one(table,field,user_dict)
if user['code']==0 and user_dict['password']==user['msg']['password']:
if user['msg']['status']==0:
session['username']=user_dict['username']
session['role']=user['msg']['role']
util.WriteLog("login","/tmp/info.log").info('login:%s'%session['username'])
return json.dumps(user)
else:
data={'code':1,'msg':'username is locking'}
util.WriteLog("login_error","/tmp/error.log").error('login_error:%s'%data['msg'])
return json.dump(data)
else:
data={'code':1,'msg':'username or password is error'}
util.WriteLog("login_error","/tmp/error.log").error('login_error:%s'%data['msg'])
return json.dumps(data)
return render_template("login.html")
