def userlist():
role = session.get('role')
if role == 1:
users = utils.list('user', fields)
return render_template("userlist.html", users=users, role=role)
else:
user = utils.list('users', fields, session.get('id'))
return render_template("userself.html", user=user, role=role)
def cabinet():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
idcs = list('idc', idc_fields)['msg']
cabinets = list('cabinet', field)['msg']
for cab in cabinets:
for items in idcs:
if cab['idc_id'] == items['id']:
cab['idc_id'] = items['name']
return render_template('cabinet.html', msg=msg, cabinet=cabinets)
def server():
if not session:
return redirect('/')
util.WriteLog("server",
"/tmp/info.log").info("server:%s" % session['username'])
data = utils.list(server_table, server_field)
cab_data = utils.list(cab_table, cab_field)
for c in cab_data['msg']:
for s in data['msg']:
if c['id'] == s['cabinet_id']:
s['cabinet_id'] = c['name']
result = data['msg']
return render_template("server.html", res=session, result=result)
def cabinet():
if not session:
return redirect('/')
util.WriteLog("cabinet",
"/tmp/info.log").info("cabinet:%s" % session['username'])
data = utils.list(cab_table, cab_field)
idc_data = utils.list(idc_table, idc_field)
for i in idc_data['msg']:
for c in data['msg']:
if i['id'] == c['idc_id']:
c['idc_id'] = i['cn_name']
result = data['msg']
return render_template("cabinet.html", res=session, result=result)
def serveradd():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
if request.method=='GET':
idc = list('idc',idc_fields)
cabinet = list('cabinet',cabinet_fields)
return render_template('serveradd.html',msg=msg,idc=idc['msg'],cabinet=cabinet['msg'])
if request.method=='POST':
server = {k:v[0] for k,v in dict(request.form).items()}
result = insert_sql('server',server_field,server)
if result['code'] == 0:
result ={'code':0, 'msg':"success"}
return json.dumps(result)
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 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 jobhistory():
if not session:
return redirect("/login")
if request.method=='GET':
job_field = ['id','apply_name','handle_name','apply_type','apply_desc','handle_desc','status','created','modified']
users=utils.list('job',job_field)
return render_template('jobhistory.html',msg=users['msg'],user=session['username'],role=session['role'])
def idc():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
result = list('idc', fields)
return render_template('idc.html', msg=msg, idc=result['msg'])
def userlist():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
field = ["id","username","name_cn","password","mobile","email","role","status"]
result = list('user',field)
return render_template('userlist.html',msg=msg,result=result['msg'])
def userlist():
if not session:
return redirect('/login/')
result = list('user', field)
if result['code'] == 0:
result = result['msg']
return render_template("userlist.html", result=result)
def jobhistory():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
if request.method=='GET':
job = list('job',field)
return render_template('jobhistory.html',msg=msg,joblist=job['msg'])
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 ansible():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
if request.method == 'GET':
server = list('server', server_fields)
return render_template('ansible.html', msg=msg, server=server['msg'])
if request.method == 'POST':
cmdmsg = {k: v[0] for k, v in dict(request.args).items()}
#记录日志写入文件
cmd_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
cmd_history = "Time: %s User: %s Host: %s Cmd: %s \n" % (
cmd_time, msg['username'], cmdmsg['pattern'], cmdmsg['cmd'])
with open("/tmp/ansible.log", 'a') as ansible_log:
ansible_log.write(cmd_history)
ansible_log.close
ansiblecmd = ansiblecommand(cmdmsg['cmd'], cmdmsg['pattern'])
pattern = cmdmsg['pattern']
result = ansiblecmd['contacted'][pattern]['stdout']
if result:
ansible_cmd = "host: %s | CMD: %s | success >> \n" % (
cmdmsg['pattern'], cmdmsg['cmd'])
ansible_msg = ansible_cmd + result
results = ansible_msg.replace('\n', '<br>')
return json.dumps(results)
def cabinet():
if not session:
return redirect('/')
data = utils.list(cab_table, cab_field)
print data
result = data['msg']
return render_template("cabinet.html", res=session, result=result)
def update_msg():
id = request.args.get('id')
user = utils.list('user', fields, id)
if session.get('role') == 1:
return json.dumps({'code': 0, 'result': user})
else:
return json.dumps({'code': 2, 'result': user})
def userlist():
if not session:
return redirect("/login")
else:
users = utils.list('user', filed)
users1 = json.dumps({'code': 0, 'users': users})
if users['code'] == 0:
return render_template('userlist.html', msg=users['msg'])
def serverupdate():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
if request.method=='GET':
id = request.args.get('id')
data={'id':id}
server = getone('server',data,server_fields)
idc = list('idc',idc_fields)
cabinet = list('cabinet',cabinet_fields)
print server
return render_template('serverupdate.html',msg=msg,idc=idc['msg'],cabinet=cabinet['msg'],server_list=server['msg'])
if request.method=='POST':
server = {k:v[0] for k,v in dict(request.form).items()}
result = _update('server',server_fields,server)
if result['code'] == 0:
return json.dumps(result)
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 hosts():
if 'username' not in session:
return redirect('/login/')
field = ['id', 'ip', 'username']
result = list('host', field)
if result['code'] == 0:
return render_template('hosts.html', msg=result['msg'])
return render_template('hosts.html')
def server():
if not session:
return redirect("/login")
users=utils.list('server',server_filed)
users1=json.dumps({'code':0,'users':users})
if users['code'] == 0:
return render_template('server.html',msg=users['msg'],user=session['username'],role=session['role'])
else:
return render_template('server.html',user=session['username'],role=session['role'])
def vpnlist():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
data=msg['username']
field = ["id","name","term","used","create_date","expire_date","owner","status"]
result = list(table_name,field,data)
print result
return render_template('vpnlist.html',msg=msg,result=result['msg'])
def vpnadmin():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
#data为None获取所有vpn列表数据
data=None
field = ["id","name","term","used","create_date","expire_date","owner","status"]
result = list(table_name,field,data)
return render_template('vpnadmin.html',msg=msg,result=result['msg'])
def server():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
idc = list('idc', idc_fields)
cabinet = list('cabinet', cabinet_fields)
server = list('server', server_fields)
idcs = idc['msg']
cabinets = cabinet['msg']
servers = server['msg']
for cab in servers:
for items in cabinets:
if cab['cabinet'] == items['id']:
cab['cabinet'] = items['name']
for cac in idcs:
if cab['idc'] == cac['id']:
cab['idc'] = cac['name']
return render_template('server.html', msg=msg, server_list=server['msg'])
def userlist():
if 'username' not in session:
return redirect('/login/')
if session['role'] == 1:
field = ['id', 'username', 'role']
result = list('user', field)
if result['code'] == 0:
return render_template('user-list.html', msg=result['msg'])
else:
return u"抱歉 你是普通用户没有该选项卡的权限!!!"
def joblist():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
if request.method=='GET':
jobs = []
result = list('job',field)
results = result['msg']
for x in results:
if x['status'] < 2:
jobs.append(x)
return render_template('joblist.html',msg=msg,joblist=jobs)
def vmlist():
if 'username' not in session:
return redirect('/login/')
msg = sessionmsg()
data = msg['username']
field = [
"id", "hostname", "system", "term", "cpu", "mem", "disk", "project",
"used", "ip", "mask", "gateway", "create_date", "expire_date", "owner",
"status"
]
result = list(table_name, field, data)
return render_template('vmlist.html', msg=msg, result=result['msg'])
def login():
if request.method=='POST':
user_dict={k:v[0] for k,v in dict(request.form).items()}
user=utils.get_name(User,user_list,user_dict['username'])
if user and user_dict['password'] in user :
res=dict(zip(User,user))
result=utils.list(User,user_list)
return render_template("list.html",result=result,res=res)
else:
result={'code':1,'msg':'username or password is error'}
return render_template("login.html",result=result)
result={}
return render_template("login.html",result=result)
def serveradd():
if not session:
return redirect("/login")
if session['role']==0:
if request.method == 'POST':
user_info_dict=dict(request.form)
user_data={ k:v[0] for k,v in user_info_dict.items() }
res=utils.insert('server',insert_server_filed,user_data)
return json.dumps(res)
else:
users=utils.list('cabinet',cabinet_filed)
return render_template('serveradd.html',id=session['id'],user=session['username'],user_cn=session['name'],email=session['email'],phone=session['phone'],role=session['role'],msg=users['msg'])
else:
return render_template('index.html',id=session['id'],user=session['username'],user_cn=session['name'],email=session['email'],phone=session['phone'],role=session['role'])
def userlist():
if session:
result = utils.list(table, field)
print result['msg']
print session
if result['code'] == 0:
return render_template('userlist.html',
res=session,
result=result['msg'])
else:
result = {'code': 1, 'msg': 'username or password is error'}
return render_template("login.html", result=result)
else:
return redirect("/login/")
