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'])