def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if not input.iid.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") if not input: raise web.seeother('/idclist') if input.action == 'mi': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") idc = models.getOneIDC(input.iid) city_list = models.getCityInfo() return render.modify_idc(idc[0], city_list) elif input.action == 'vi': idc = models.getOneIDC(input.iid) city_list = models.getCityInfo() return render.view_idc(idc[0], city_list) elif input.action == 'di': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") models.delIDC(input.iid) raise web.seeother('/idclist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') idc_info_list = [] all_idc_list = models.getIDCInfo() cid_to_city = base.cidToCity() #[iid,city,idcname,hostcountbyidc,hztime,contact,fun], one_count = [] for i in all_idc_list: city = base.getCity(i.city) host_count = models.getHostCountByIDC(i.iid) one_count.append(i.iid) one_count.append(city) one_count.append(i.idcname) one_count.append(host_count) one_count.append(i.hztime) one_count.append(i.contact) idc_info_list.append(one_count) one_count = [] if web.ctx.session.privilege == 0: return render.idc_list(idc_info_list) else: return render.idc_list_admin(idc_info_list)
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if not input.cid.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") if not input: raise web.seeother('/citylist') if input.action == 'mc': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") city_info = models.getOneCity(input.cid) return render.modify_city(city_info[0]) elif input.action == 'vc': city_info = models.getOneCity(input.cid) return render.view_city(city_info[0]) elif input.action == 'dc': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") models.delCity(input.cid) raise web.seeother('/citylist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if not input.pid.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") if not input: raise web.seeother('/projectlist') if input.action == 'mp': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") project_info = models.getOneProject(input.pid) return render.modify_project(project_info) elif input.action == 'vp': project_info = models.getOneProject(input.pid) return render.view_project(project_info) elif input.action == 'dp': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") models.delProject(input.pid) raise web.seeother('/projectlist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') if not web.input(): raise web.seeother('/main') action = web.input().action hid = web.input().hid if not hid.isdigit(): return base.code("<script language='javascript'>alert('参数错误');window.history.back(-1);</script>") host = models.getOneHost(hid) if action == 'mh': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() return render.modify_host(city,project,idc,status,host[0]) elif action == 'vh': city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() return render.view_host(city,project,idc,status,host[0]) elif action == 'dh': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") models.delHost(hid) raise web.seeother('/main') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): # do $:f.render() in the template if not logged(): #f = self.register_form() return render.register(None, None) else: raise web.seeother('/')
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if not input.cid.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") if not input: raise web.seeother('/citylist') if input.action == 'mc': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") city_info = models.getOneCity(input.cid) return render.modify_city(city_info[0]) elif input.action == 'vc': city_info = models.getOneCity(input.cid) return render.view_city(city_info[0]) elif input.action == 'dc': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") # Save to history c = models.getOneCity(input.cid)[0] content = "INSERT INTO city VALUE (%s, '%s', '%s')" % (c['cid'], c['city'], c['other']) description = u"<b>城市:</b>"+ c['city'] delman = web.ctx.session.username deltime = int(time.time()) models.addHistory(content,description,delman,deltime) models.delCity(input.cid) raise web.seeother('/citylist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") history = models.getHistory() history = list(history) for h in history: ltime = time.localtime(int(h['deltime'])) deltime = time.strftime("%Y-%m-%d %H:%M:%S",ltime) h['deltime'] = deltime input = web.input(action=None,hid=None) if not input.action: return render.history(history) else: # Remove history if input.action == 'dh': models.delOneHistory(input.hid) raise web.seeother('/history') # Resotre history elif input.action == 'rh': if models.restoreHistory(input.hid): models.delOneHistory(input.hid) return base.code("<script language='javascript'>alert('恢复成功 !');window.location.href='/history'; </script>") else: return base.code("<script language='javascript'>alert('恢复失败,此记录可能已存在,请检查!');window.history.back(-1);</script>") else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问!');window.history.back(-1);</script>") else: return render.add_city()
def GET(self): if not base.logged(): raise web.seeother('/') if web.ctx.session.privilege != 2: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问!');window.history.back(-1);</script>") else: return render.register()
def GET(self): if not base.logged(): raise web.seeother('/') conf = models.getConfig() sys_overview = models.getSysOverView() status_overview = models.getStatusOverView() return render.index(conf,sys_overview,status_overview)
def GET(self): if not base.logged(): raise web.seeother('/') city = models.getCityInfo() if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问!');window.history.back(-1);</script>") else: return render.add_idc(city)
def GET(self): if not base.logged(): raise web.seeother('/') city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问!');window.history.back(-1);</script>") else: return render.add_host(city,project, idc, status)
def GET(self): if not base.logged(): raise web.seeother('/') if self.input.action=='ms': server=models.getServerInfo(self.id) for server_info in server: pass return render.mserver(server_info) elif self.input.action=='ds': models.delServerInfo(self.id) raise web.seeother('/aserver') else: pass
def GET(self): if not base.logged(): raise web.seeother('/') else: input = web.input(project=None,idc=None,hc=None,page=None) if not input.project.isdigit() or not input.hc.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") project = int(input.project) # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows hostcount = int(input.hc) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if input.page: if not input.project.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") page = int(input.page) else: page = 1 offset = pagesize * (page - 1) # offset pagerows = models.getPageByProject(project, offset, pagesize) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['statusid'] = h['status'] h['status'] = base.getStatus(h['status']) newhosts.append(h) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/projectlisthost?project=%d&hc=%d&page=%d'>下一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (project,hostcount,page+1,project,hostcount,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/projectlisthost?project=%d&hc=%d&page=%d'>上一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (project,hostcount,page-1,project,hostcount,page,pages,hostcount) else: page_nav = u"<a href='/projectlisthost?project=%d&hc=%d&page=%d'>下一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=%d'>上一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=1'>首页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (project,hostcount,page+1,project,hostcount,page-1,project,hostcount,project,hostcount,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.project_host_list(newhosts,pages,page,page_nav) else: return render.project_host_list_admin(newhosts,pages,page,page_nav)
def GET(self): if not base.logged(): raise web.seeother('/') user_list = models.getUserInfo() #username,privi,phone,email,logintime,loginip for user_info in user_list: if user_info['lastlogin'] != '': ltime = time.localtime(int(user_info['lastlogin'])) lastlogin = time.strftime("%Y-%m-%d %H:%M:%S",ltime) else: lastlogin = '' user_info['lastlogin'] = lastlogin return render.muser(user_info)
def GET(self): if not base.logged(): raise web.seeother('/') else: # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows hostcount = models.allHosts() # host_count para = web.input(page=None,action=None) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if para.page: if not para.page.isdigit(): return base.code("<script language='javascript'>alert('参数错误');window.history.back(-1);</script>") page = int(para.page) else: page = 1 offset = pagesize * (page - 1) # offset if para.action: pagerows = models.getPageByLastModify(offset, pagesize) else: pagerows = models.getPage(offset, pagesize) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['statusid'] = h['status'] h['status'] = base.getStatus(h['status']) newhosts.append(h) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/main?page=%d'>下一页</a> | <a href='/main?page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (page+1,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/main?page=%d'>上一页</a> | <a href='/main?page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (page-1, page, pages,hostcount) else: page_nav = u"<a href='/main?page=%d'>下一页</a> | <a href='/main?page=%d'>上一页</a> | <a href='/main?page=1'>首页</a> | <a href='/main?page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (page+1,page-1,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.main(newhosts,pages,page,page_nav) else: return render.main_admin(newhosts,pages,page,page_nav)
def GET(self): if not base.logged(): raise web.seeother('/') else: # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows hostcount = models.allHosts() # host_count para = web.input(page=None,action=None) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if para.page: if not para.page.isdigit(): return base.code("<script language='javascript'>alert('参数错误');window.history.back(-1);</script>") page = int(para.page) else: page = 1 offset = pagesize * (page - 1) # offset if para.action: pagerows = models.getPageByLastModify(offset, pagesize) else: pagerows = models.getPage(offset, pagesize) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['status'] = base.getStatus(h['status']) newhosts.append(h) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/main?page=%d'>下一页</a> | <a href='/main?page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (page+1,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/main?page=%d'>上一页</a> | <a href='/main?page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (page-1, page, pages,hostcount) else: page_nav = u"<a href='/main?page=%d'>下一页</a> | <a href='/main?page=%d'>上一页</a> | <a href='/main?page=1'>首页</a> | <a href='/main?page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (page+1,page-1,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.main(newhosts,pages,page,page_nav) else: return render.main_admin(newhosts,pages,page,page_nav)
def GET(self): if not base.logged(): raise web.seeother('/') else: input = web.input(project=None,idc=None,hc=None,page=None) if not input.project.isdigit() or not input.hc.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") project = int(input.project) # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows hostcount = int(input.hc) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if input.page: if not input.project.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") page = int(input.page) else: page = 1 offset = pagesize * (page - 1) # offset pagerows = models.getPageByProject(project, offset, pagesize) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['status'] = base.getStatus(h['status']) newhosts.append(h) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/projectlisthost?project=%d&hc=%d&page=%d'>下一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (project,hostcount,page+1,project,hostcount,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/projectlisthost?project=%d&hc=%d&page=%d'>上一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (project,hostcount,page-1,project,hostcount,page,pages,hostcount) else: page_nav = u"<a href='/projectlisthost?project=%d&hc=%d&page=%d'>下一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=%d'>上一页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=1'>首页</a> | <a href='/projectlisthost?project=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (project,hostcount,page+1,project,hostcount,page-1,project,hostcount,project,hostcount,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.project_host_list(newhosts,pages,page,page_nav) else: return render.project_host_list_admin(newhosts,pages,page,page_nav)
def GET(self): if not base.logged(): raise web.seeother('/') if not web.input(): raise web.seeother('/main') action = web.input().action hid = web.input().hid if not hid.isdigit(): return base.code("<script language='javascript'>alert('参数错误');window.history.back(-1);</script>") host = models.getOneHost(hid) if action == 'mh': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() return render.modify_host(city,project,idc,status,host[0]) elif action == 'vh': city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() host_list = list(host) t = host_list[0]['modifytime'] ltime = time.localtime(int(t)) modifytime = time.strftime("%Y-%m-%d %H:%M:%S",ltime) host_list[0]['modifytime'] = modifytime return render.view_host(city,project,idc,status,host_list[0]) elif action == 'dh': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") # Save to history h = models.getOneHost(hid)[0] content = "INSERT INTO hosts VALUES (%s,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % (h['hid'],h['hostname'],h['city'],h['project'],h['idc'],h['port'],h['addr1_ip'],h['addr1_netmask'],h['addr1_gateway'],h['addr1_line'],h['addr2_ip'],h['addr2_netmask'],h['addr2_gateway'],h['addr2_line'],h['addr3_ip'],h['addr3_netmask'],h['addr3_gateway'],h['addr3_gateway'],h['memory'],h['cpu'],h['disk'],h['buytime'],h['servicetime'],h['hardwareinfo'],h['bandwidth'],h['uses'],h['status'],h['company'],h['os'],h['other'],h['jointime'],h['modifytime'],h['modifyman']) description = u"<b>主机标识:</b>%s<br><b>地址:</b>%s/%s/%s<br><b>用途:</b>%s" % (h['hostname'],h['addr1_ip'],h['addr2_ip'],h['addr3_ip'],h['uses']) delman = web.ctx.session.username deltime = int(time.time()) models.addHistory(content,description,delman,deltime) models.delHost(hid) return base.code("<script language='javascript'>location.replace(document.referrer)</script>") else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') else: input = web.input(cid=None,iid=None,hc=None,page=None) cid = int(input.cid) iid = int(input.iid) # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows hostcount = int(input.hc) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if input.page: page = int(input.page) else: page = 1 offset = pagesize * (page - 1) # offset pagerows = models.getPageByIDC(iid,offset,pagesize) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['statusid'] = h['status'] h['status'] = base.getStatus(h['status']) newhosts.append(h) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>下一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (cid,iid,hostcount,page+1,cid,iid,hostcount,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>上一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (cid,iid,hostcount,page-1,cid,iid,hostcount,page,pages,hostcount) else: page_nav = u"<a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>下一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>上一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=1'>首页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (cid,iid,hostcount,page+1,cid,iid,hostcount,page-1,cid,iid,hostcount,cid,iid,hostcount,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.city_idc_host_list(newhosts,pages,page,page_nav) else: return render.city_idc_host_list_admin(newhosts,pages,page,page_nav)
def GET(self): if not base.logged(): raise web.seeother('/') if not web.input(): raise web.seeother('/main') action = web.input().action hid = web.input().hid if not hid.isdigit(): return base.code("<script language='javascript'>alert('参数错误');window.history.back(-1);</script>") host = models.getOneHost(hid) if action == 'mh': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() return render.modify_host(city,project,idc,status,host[0]) elif action == 'vh': city = models.getCityInfo() project = models.getProjectInfo() idc = models.getIDCInfo() status = models.getStatusInfo() host_list = list(host) t = host_list[0]['modifytime'] ltime = time.localtime(int(t)) modifytime = time.strftime("%Y-%m-%d %H:%M:%S",ltime) host_list[0]['modifytime'] = modifytime return render.view_host(city,project,idc,status,host_list[0]) elif action == 'dh': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") # Save to history h = models.getOneHost(hid)[0] content = "INSERT INTO hosts VALUES (%s,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % (h['hid'],h['hostname'],h['city'],h['project'],h['idc'],h['port'],h['addr1_ip'],h['addr1_netmask'],h['addr1_gateway'],h['addr1_line'],h['addr2_ip'],h['addr2_netmask'],h['addr2_gateway'],h['addr2_line'],h['addr3_ip'],h['addr3_netmask'],h['addr3_gateway'],h['addr3_gateway'],h['memory'],h['cpu'],h['disk'],h['buytime'],h['servicetime'],h['hardwareinfo'],h['bandwidth'],h['uses'],h['status'],h['company'],h['os'],h['other'],h['jointime'],h['modifytime'],h['modifyman']) description = u"<b>主机标识:</b>%s<br><b>地址:</b>%s/%s/%s<br><b>用途:</b>%s" % (h['hostname'],h['addr1_ip'],h['addr2_ip'],h['addr3_ip'],h['uses']) delman = web.ctx.session.username deltime = int(time.time()) models.addHistory(content,description,delman,deltime) models.delHost(hid) raise web.seeother('/main') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self,page=1): if not base.logged(): raise web.seeother('/') else: page = int(page) perpage = 10 offset = (page-1) * perpage todos = db.select(tb, order='finished asc, id asc',offset=offset,limit=perpage) postcount = db.query('select count(*) as count from todo')[0] pages = postcount.count / perpage if postcount.count % perpage > 0: pages += 1 if page > pages: raise web.seeother('/main') else: return render.index(config=config,todos=todos,pages=pages)
def GET(self,p='1'): if not base.logged(): raise web.seeother('/') p=int(p) input = web.input() if input: p=int(input.p.strip()) server_list = models.getServerList(p) server_list_info=[] for i in server_list: server_list_info.append(i) page_list=models.get_page(p) page_list_info=[] for j in page_list: page_list_info.append(j) return render.aserver(server_list_info,page_list_info)
def GET(self): if not base.logged(): raise web.seeother('/') else: input = web.input(cid=None,iid=None,hc=None,page=None) cid = int(input.cid) iid = int(input.iid) # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows hostcount = int(input.hc) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if input.page: page = int(input.page) else: page = 1 offset = pagesize * (page - 1) # offset pagerows = models.getPageByIDC(iid,offset,pagesize) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['status'] = base.getStatus(h['status']) newhosts.append(h) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>下一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (cid,iid,hostcount,page+1,cid,iid,hostcount,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>上一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (cid,iid,hostcount,page-1,cid,iid,hostcount,page,pages,hostcount) else: page_nav = u"<a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>下一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>上一页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=1'>首页</a> | <a href='/cihl?cid=%d&iid=%d&hc=%d&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (cid,iid,hostcount,page+1,cid,iid,hostcount,page-1,cid,iid,hostcount,cid,iid,hostcount,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.city_idc_host_list(newhosts,pages,page,page_nav) else: return render.city_idc_host_list_admin(newhosts,pages,page,page_nav)
def GET(self): if not base.logged(): raise web.seeother('/') user_list = models.getUserList() #username,privi,phone,email,logintime,loginip user_info_list = [] for u in user_list: if u['lastlogin'] != '': ltime = time.localtime(int(u['lastlogin'])) lastlogin = time.strftime("%Y-%m-%d %H:%M:%S",ltime) else: lastlogin = '' u['lastlogin'] = lastlogin user_info_list.append(u) if web.ctx.session.privilege == 2: return render.user_list_admin(user_info_list) else: return render.user_list(user_info_list)
def GET(self): if not base.logged(): raise web.seeother('/') city_host_count = [] city_list = models.getCityInfo(); #return city_list[0] one_count = [] for c in city_list: host_count = models.getHostCountByCity(c.cid) idc_count = models.getIDCCountByCity(c.cid) one_count.append(c.cid) one_count.append(c.city) one_count.append(idc_count) one_count.append(host_count) city_host_count.append(one_count) one_count = [] if web.ctx.session.privilege == 0: return render.city_list(city_host_count) else: return render.city_list_admin(city_host_count)
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if input.action == "vu": user_info = models.getUserInfoByUID(input.uid) return render.view_user(user_info) elif input.action == "mu": if web.ctx.session.privilege == 2: user_info = models.getUserInfoByUID(input.uid) return render.modify_user_admin(user_info) else: user_info = models.getUserInfoByUID(web.ctx.session.uid) return render.modify_user(user_info) elif input.action == 'du': if web.ctx.session.privilege != 2: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") models.delUserByUID(input.uid) raise web.seeother('/userlist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') project_info_list = [] all_project_list = models.getProjectInfo(); one_count = [] #[pid,project,idc,hostcount] for p in all_project_list: host_count = models.getHostCountByProject(p.pid) idc_count = models.getIDCCountByProject(p.pid) one_count.append(p.pid) one_count.append(p.project) one_count.append(idc_count) one_count.append(host_count) project_info_list.append(one_count) one_count = [] if web.ctx.session.privilege == 0: return render.project_list(project_info_list) else: return render.project_list_admin(project_info_list)
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if not input.iid.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") if not input: raise web.seeother('/idclist') if input.action == 'mi': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") idc = models.getOneIDC(input.iid) city_list = models.getCityInfo() return render.modify_idc(idc[0], city_list) elif input.action == 'vi': idc = models.getOneIDC(input.iid) city_list = models.getCityInfo() return render.view_idc(idc[0], city_list) elif input.action == 'di': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") # Save to history i = models.getOneIDC(input.iid)[0] content = "INSERT INTO idc VALUE (%s,%s,'%s','%s',%s,'%s')" % (i['iid'], i['city'],i['idcname'],i['contact'],i['hztime'], i['other']) description = u"<b>IDC:</b>%s<br><b>备注:</b>%s" % (i['idcname'],i['other']) delman = web.ctx.session.username deltime = int(time.time()) models.addHistory(content,description,delman,deltime) models.delIDC(input.iid) raise web.seeother('/idclist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input() if not input.pid.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") if not input: raise web.seeother('/projectlist') if input.action == 'mp': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") project_info = models.getOneProject(input.pid) return render.modify_project(project_info) elif input.action == 'vp': project_info = models.getOneProject(input.pid) return render.view_project(project_info) elif input.action == 'dp': if web.ctx.session.privilege == 0: return base.code("<script language='javascript'>alert('您没有足够的权限,决绝访问 !');window.history.back(-1);</script>") # Save to history p = models.getOneProject(input.pid) content = "INSERT INTO project VALUE (%s, '%s', '%s')" % (p['pid'], p['project'], p['other']) description = u"<b>项目:</b>"+ p['project'] delman = web.ctx.session.username deltime = int(time.time()) models.addHistory(content,description,delman,deltime) models.delProject(input.pid) raise web.seeother('/projectlist') else: return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>")
def GET(self): if not base.logged(): raise web.seeother('/') if not web.input(): raise web.seeother('/projectlist') if not web.input().project.isdigit(): return base.code("<script language='javascript'>alert('参数错误 !');window.history.back(-1);</script>") pid = int(web.input().project) idc_dict = models.getIDCInfoByProject(pid) projects_dict = base.pidToProject() # Get idc list by project id project_idc_list = [] #{pid,iid,idcname,hostcount by pid and iid} one_idc_dict = {} for i in idc_dict: iid = i['idc'] idc_info = models.getOneIDC(iid) if not idc_info: idc_info.idcname = 'Unknown' else: idc_info = idc_info[0] hostcount = models.getHostCountByPidAndIid(pid,iid) one_idc_dict['pid'] = pid one_idc_dict['iid'] = iid one_idc_dict['idcname'] = idc_info.idcname one_idc_dict['hostcount'] = hostcount project_idc_list.append(one_idc_dict) one_idc_dict = {} return render.project_idc_list(project_idc_list, projects_dict[pid])
def GET(self,page=1,statustype='ban'): if not base.logged(): raise web.seeother('/') else: page = int(page) perpage = 10 current_page = page page_status = statustype offset = (page-1) * perpage if statustype == 'fail' : todos = db.select(tb, where="action='unban' and status = 1",order='time asc, id asc',offset=offset,limit=perpage,vars=locals()) sql = 'select * from atta where action="unban" and status = 1' else: todos = db.select(tb, where='action=$statustype and status = 0',order='time asc, id asc',offset=offset,limit=perpage,vars=locals()) sql = 'select * from atta where action="%s" and status = 0' % statustype postcount = len(db.query(sql)) pages = postcount / perpage print page,pages,postcount if postcount % perpage > 0: pages += 1 if page > pages: raise web.seeother('/main') else: return render.index(config=config,todos=todos,pages=pages,current_page=current_page,statustype=statustype,page_status=page_status)
def GET(self): if not base.logged(): raise web.seeother('/') if not web.input(): raise web.seeother('/projectlist') cid = int(web.input().city) idc_dict = models.getIDCInfoByCity(cid) citys_dict = base.cidToCity() city_idc_list = [] #{cid,iid,idcname,hostcount by cid and iid} one_idc_dict = {} for i in idc_dict: hostcount = models.getHostCountByCidAndIid(cid,i.iid) one_idc_dict['cid'] = cid one_idc_dict['iid'] = i.iid one_idc_dict['idcname'] = i.idcname one_idc_dict['hostcount'] = hostcount city_idc_list.append(one_idc_dict) one_idc_dict = {} return render.city_idc_list(city_idc_list, citys_dict[cid])
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input(page=None) # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows input.word = input.word.replace("'","\\'") if input.ops == '1': hostcount = models.getHostCountBySearch('hostname',input.word) elif input.ops == '2': hostcount = models.getHostCountBySearchIp(input.word) elif input.ops == '5': hostcount = models.getHostCountBySearch('port',input.word) elif input.ops == '6': hostcount = models.getHostCountBySearch('status',input.word) elif input.ops == '7': hostcount = models.getHostCountBySearch('bandwidth',input.word) elif input.ops == '8': hostcount = models.getHostCountBySearch('uses',input.word) elif input.ops == '9': hostcount = models.getHostCountBySearch('os',input.word) elif input.ops == '10': hostcount = models.getHostCountBySearch('company',input.word) elif input.ops == '11': hostcount = models.getHostCountBySearch('hardwareinfo',input.word) elif input.ops == '12': hostcount = models.getHostCountBySearch('other',input.word) elif input.ops == '13': hostcount = models.getHostCountBySearch('modifyman',input.word) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if input.page: page = int(input.page) else: page = 1 offset = pagesize * (page - 1) # offset if input.ops == '1': pagerows = models.getPageBySearch('hostname',input.word,str(offset),str(pagesize)) elif input.ops == '2': pagerows = models.getPageBySearchIp(input.word,str(offset),str(pagesize)) elif input.ops == '5': pagerows = models.getPageBySearch('port',input.word,str(offset),str(pagesize)) elif input.ops == '6': pagerows = models.getPageBySearch('status',input.word,str(offset),str(pagesize)) elif input.ops == '7': pagerows = models.getPageBySearch('bandwidth',input.word,str(offset),str(pagesize)) elif input.ops == '8': pagerows = models.getPageBySearch('uses',input.word,str(offset),str(pagesize)) elif input.ops == '9': pagerows = models.getPageBySearch('os',input.word,str(offset),str(pagesize)) elif input.ops == '10': pagerows = models.getPageBySearch('company',input.word,str(offset),str(pagesize)) elif input.ops == '11': pagerows = models.getPageBySearch('hardwareinfo',input.word,str(offset),str(pagesize)) elif input.ops == '12': pagerows = models.getPageBySearch('other',input.word,str(offset),str(pagesize)) elif input.ops == '13': pagerows = models.getPageBySearch('modifyman',input.word,str(offset),str(pagesize)) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['status'] = base.getStatus(h['status']) newhosts.append(h) ops = int(input.ops) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/search?ops=%d&word=%s&page=%d'>下一页</a> | <a href='/search?ops=%d&word=%s&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (ops,input.word,page+1,ops,input.word,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/search?ops=%d&word=%s&page=%d'>上一页</a> | <a href='/search?ops=%d&word=%s&page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (ops,input.word,page-1,ops,input.word,page,pages,hostcount) else: page_nav = u"<a href='/search?ops=%d&word=%s&page=%d'>下一页</a> | <a href='/search?ops=%d&word=%s&page=%d'>上一页</a> | <a href='/search?ops=%d&word=%s&page=1'>首页</a> | <a href='/search?ops=%d&word=%s&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (ops,input.word,page+1,ops,input.word,page-1,ops,input.word,ops,input.word,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.main(newhosts,pages,page,page_nav) else: return render.main_admin(newhosts,pages,page,page_nav) if input.ops == '1': result = models.searchHostName(input.content) return result
def GET(self): if not base.logged(): raise web.seeother('/') if web.ctx.session.privilege != 2: return base.code("<script language='javascript'>alert('您没有足够的权限,拒绝访问 !');window.history.back(-1);</script>") all_hosts = models.getAllHosts() new_hosts=[] for h in all_hosts: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['status'] = base.getStatus(h['status']) new_hosts.append(h) # Export host data wbk = xlwt.Workbook(encoding='utf-8') style = xlwt.XFStyle() style2 = xlwt.XFStyle() font = xlwt.Font() font2 = xlwt.Font() font2.bold = True font.name = 'SimSum' style.alignment.wrap=1 style.font = font style2.font = font2 sheet = wbk.add_sheet('hosts') # Define excel header names sheet.write(0,0,'主机标识', style2) sheet.write(0,1,'所属项目', style2) sheet.write(0,2,'所在城市', style2) sheet.write(0,3,'所在IDC', style2) sheet.write(0,4,'地址一', style2) sheet.write(0,5,'地址二', style2) sheet.write(0,6,'地址三', style2) sheet.write(0,7,'登录端口', style2) sheet.write(0,8,'所属公司', style2) sheet.write(0,9,'带宽', style2) sheet.write(0,10,'用途', style2) sheet.write(0,11,'状态', style2) sheet.write(0,12,'操作系统', style2) sheet.write(0,13,'内存(GB)', style2) sheet.write(0,14,'CPU(核心)', style2) sheet.write(0,15,'磁盘(GB)', style2) sheet.write(0,16,'购买时间', style2) sheet.write(0,17,'质保时间', style2) sheet.write(0,18,'硬件详细信息', style2) sheet.write(0,19,'备注', style2) # Start export row = 1 for i in new_hosts: sheet.write(row,0,i['hostname']) sheet.write(row,1,i['project']) sheet.write(row,2,i['city']) sheet.write(row,3,i['idc']) sheet.col(4).width = 0x0d00 + 3000 sheet.col(5).width = 0x0d00 + 3000 sheet.col(6).width = 0x0d00 + 3000 sheet.write(row,4,'IP:'+i['addr1_ip']+'\nNETMASK:'+i['addr1_netmask']+'\nGATEWAY:'+i['addr1_gateway']+'\nLINE:'+i['addr1_line'], style) sheet.write(row,5,'IP:'+i['addr2_ip']+'\nNETMASK:'+i['addr2_netmask']+'\nGATEWAY:'+i['addr2_gateway']+'\nLINE:'+i['addr2_line'], style) sheet.write(row,6,'IP:'+i['addr3_ip']+'\nNETMASK:'+i['addr3_netmask']+'\nGATEWAY:'+i['addr3_gateway']+'\nLINE:'+i['addr3_line'], style) sheet.write(row,7,i['port']) sheet.write(row,8,i['company']) sheet.write(row,9,i['bandwidth']) sheet.write(row,10,i['uses']) sheet.write(row,11,i['status']) sheet.write(row,12,i['os']) sheet.write(row,13,i['memory']) sheet.write(row,14,i['cpu']) sheet.write(row,15,i['disk']) sheet.write(row,16,i['buytime']) sheet.write(row,17,i['servicetime']) sheet.write(row,18,i['hardwareinfo']) sheet.write(row,19,i['other']) row += 1 wbk.save('download/hosts.xls') file = 'hosts.xls' return base.DownLoad(file)
def GET(self): if not base.logged(): raise web.seeother('/') input = web.input(page=None) # Paging sysconf = models.getConfig() pagesize = sysconf['page'] # page_per_rows input.word = input.word.replace("'","\\'") if input.ops == '1': hostcount = models.getHostCountBySearch('hostname',input.word) elif input.ops == '2': hostcount = models.getHostCountBySearchIp(input.word) elif input.ops == '5': hostcount = models.getHostCountBySearch('port',input.word) elif input.ops == '6': hostcount = models.getHostCountBySearch('status',input.word) elif input.ops == '7': hostcount = models.getHostCountBySearch('bandwidth',input.word) elif input.ops == '8': hostcount = models.getHostCountBySearch('uses',input.word) elif input.ops == '9': hostcount = models.getHostCountBySearch('os',input.word) elif input.ops == '10': hostcount = models.getHostCountBySearch('company',input.word) elif input.ops == '11': hostcount = models.getHostCountBySearch('hardwareinfo',input.word) elif input.ops == '12': hostcount = models.getHostCountBySearch('other',input.word) elif input.ops == '13': hostcount = models.getHostCountBySearch('modifyman',input.word) pages = int(hostcount / pagesize) # page_count if (hostcount % pagesize): pages += 1 #page_count if input.page: page = int(input.page) else: page = 1 offset = pagesize * (page - 1) # offset if input.ops == '1': pagerows = models.getPageBySearch('hostname',input.word,str(offset),str(pagesize)) elif input.ops == '2': pagerows = models.getPageBySearchIp(input.word,str(offset),str(pagesize)) elif input.ops == '5': pagerows = models.getPageBySearch('port',input.word,str(offset),str(pagesize)) elif input.ops == '6': pagerows = models.getPageBySearch('status',input.word,str(offset),str(pagesize)) elif input.ops == '7': pagerows = models.getPageBySearch('bandwidth',input.word,str(offset),str(pagesize)) elif input.ops == '8': pagerows = models.getPageBySearch('uses',input.word,str(offset),str(pagesize)) elif input.ops == '9': pagerows = models.getPageBySearch('os',input.word,str(offset),str(pagesize)) elif input.ops == '10': pagerows = models.getPageBySearch('company',input.word,str(offset),str(pagesize)) elif input.ops == '11': pagerows = models.getPageBySearch('hardwareinfo',input.word,str(offset),str(pagesize)) elif input.ops == '12': pagerows = models.getPageBySearch('other',input.word,str(offset),str(pagesize)) elif input.ops == '13': pagerows = models.getPageBySearch('modifyman',input.word,str(offset),str(pagesize)) newhosts=[] for h in pagerows: h['project'] = base.getProject(h['project']) h['city'] = base.getCity(h['city']) h['idc'] = base.getIDC(h['idc']) h['statusid'] = h['status'] h['status'] = base.getStatus(h['status']) newhosts.append(h) ops = int(input.ops) #page Nav if hostcount <= pagesize: page_nav = u"共 <b>%s</b> 条记录" % (hostcount) elif page == 1: page_nav = u"<a href='/search?ops=%d&word=%s&page=%d'>下一页</a> | <a href='/search?ops=%d&word=%s&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (ops,input.word,page+1,ops,input.word,pages,page,pages,hostcount) elif page == pages: page_nav = u"<a href='/search?ops=%d&word=%s&page=%d'>上一页</a> | <a href='/search?ops=%d&word=%s&page=1'>首页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (ops,input.word,page-1,ops,input.word,page,pages,hostcount) else: page_nav = u"<a href='/search?ops=%d&word=%s&page=%d'>下一页</a> | <a href='/search?ops=%d&word=%s&page=%d'>上一页</a> | <a href='/search?ops=%d&word=%s&page=1'>首页</a> | <a href='/search?ops=%d&word=%s&page=%d'>尾页</a> | (%d / %d) , 共 <b>%d</b> 条记录" % (ops,input.word,page+1,ops,input.word,page-1,ops,input.word,ops,input.word,pages,page,pages,hostcount) if web.ctx.session.privilege == 0: return render.main(newhosts,pages,page,page_nav) else: return render.main_admin(newhosts,pages,page,page_nav) if input.ops == '1': result = models.searchHostName(input.content) return result
def GET(self): """Login page""" if not logged(): return render.login("") else: raise web.seeother('/')
def GET(self): if base.logged(): raise web.seeother('/main') else: return render.login()
def GET(self): if base.logged(): raise web.seeother('/main') else: return render_plain.login("Welcome")