def cabinet():
if not session:
return redirect('/login/')
cab = utils.getall('cabinet', field)['msg']
idcs = utils.getall('idc', idc_field)['msg']
idc = {'%s' % idc['id']: idc['sr'] for idc in idcs}
for n in cab:
if n['sr_id'] in idc:
n['sr_id'] = idc[n['sr_id']]
return render_template('cabinet.html', result=cab, info=session)
def vpnadd1():
if 'username' not in session:
return redirect('/login/')
#获取当前用户列表,传入前端select添加vpn模态框
if request.method=='GET':
field = "username"
result = getall('user',field)
print "result:"
print result
return json.dumps(result['msg'])
#添加vpn
if request.method=='POST':
status = 0
create_date = "1900-01-01"
expire_date = "1900-01-01"
field = ["name","term","used","create_date","expire_date","owner","status"]
data= {k:v[0] for k,v in dict(request.form).items()}
data.update(create_date=create_date,expire_date=expire_date,status=status)
#检查user表账号是否存在
username=['username']
data_check = {'username':data['owner']}
result = check('user',username,data_check)
if result['code'] == 1:
result ={'code':1, 'msg':data['owner'] + "申请人账号不存在"}
return json.dumps(result)
#添加vpn数据
try:
result = insert_sql(table_name,field,data)
if result['code'] == 0:
result ={'code':0, 'msg':data['name'] + "账号添加成功"}
except:
result ={'code':1, 'msg':data['name'] + "账号已存在"}
return json.dumps(result)
def userlist():
if not session:
return redirect('/login/')
else:
result = utils.getall("user", field)
return render_template('userlist.html',
result=result['msg'],
info=session)
def serveradd():
cab = ['id','cr','sr_id','u_num','power']
field = ['hostname','lan_ip','wan_ip','cabinet_id','op','phone']
if not session:
return redirect('/login/')
if request.method=='POST':
data = {k:v[0] for k,v in dict(request.form).items()}
print data
result = utils.regist('server',field,data)
return json.dumps(result)
res = utils.getall('cabinet',cab)
return render_template('serveradd.html',info=session,res=res['msg'])
def addcn():
field = ['cr', 'sr_id', 'u_num', 'power']
if not session:
return redirect('/login/')
if request.method == 'POST':
data = {k: v[0] for k, v in dict(request.form).items()}
print data
result = utils.regist('cabinet', field, data)
return json.dumps(result)
res = utils.getall('idc', idc_field)
print res['msg']
return render_template('addcn.html', info=session, res=res['msg'])
def vmadd1():
if 'username' not in session:
return redirect('/login/')
#获取当前用户列表,传入前端select添加vpn模态框
if request.method == 'GET':
field = "username"
result = getall('user', field)
print "result:"
print result
return json.dumps(result['msg'])
#添加vm
if request.method == 'POST':
status = 0
create_date = "1900-01-01"
expire_date = "1900-01-01"
form_result = request.form.to_dict()
data = vmappend(form_result)
field = [
"hostname", "system", "term", "cpu", "mem", "disk", "project",
"used", "ip", "mask", "gateway", "create_date", "expire_date",
"owner", "status"
]
data.update(create_date=create_date,
expire_date=expire_date,
status=status)
#检查user表账号是否存在
username = ['username']
data_check = {'username': data['owner']}
result = check('user', username, data_check)
if result['code'] == 1:
result = {'code': 1, 'msg': data['owner'] + "申请人账号不存在"}
return json.dumps(result)
#添加vm数据
try:
result = insert_sql(table_name, field, data)
if result['code'] == 0:
result = {'code': 0, 'msg': data['hostname'] + "添加成功"}
except:
result = {'code': 1, 'msg': data['hostname'] + "添加失败"}
return json.dumps(result)
def joblist():
if not session:
return redirect('/login/')
where = {'status': ['0', '1']}
res = utils.getall('ops_jobs', field)
return render_template('joblist.html', info=session, result=res['msg'])
def idc():
if not session:
return redirect('/login/')
res = utils.getall("idc", field)
return render_template('idc.html', res=res['msg'], info=session)
def service():
if not session:
return redirect('/login/')
res = utils.getall('server',field)
return render_template('server.html',info=session,result=res['msg'])
