Beispiel #1
0
	def get(self, id, do):
		if id:
			row = db.ct("module", "*", "id="+id)
			if row:
				if do == 'del':
					db.d("module", "id="+id)
					self.redirect("http://"+URL+"/module")
				else:
					self.render(
						'module_edit.html',
						username=self.get_secure_cookie("username"),
						datainfo=db.datainfo(),
						systeminfo=systeminfo(),
						heads=[ 
							{'name':'Module', 'title':'Module list', 'url':'module/'},
							{'name':urlde(row['name']), 'title': '', 'url': ''},
						],
						row=row,
						url=URL,
						urlde=urlde,
						)
			else:
				self.render('404.html')
		else:
			if do == 'add':
				self.render(
					'module_add.html',
					username=self.get_secure_cookie("username"),
					datainfo=db.datainfo(),
					systeminfo=systeminfo(),
					heads=[{'name':'Module', 'title':'Module list', 'url':'module/'},{'name':'Add', 'title':'', 'url':''}],
					url=URL,
					urlde=urlde,
					)
			else:
				mrows = db.cts("module", "*", "1=1 order by id")
				modulen = len(mrows)
				self.render(
					"module.html",
					username=self.get_secure_cookie("username"),
					datainfo=db.datainfo(),
					systeminfo=systeminfo(),
					heads=[{'name':'Module', 'title': '', 'url': ''}],
					url=URL,
					urlde=urlde,
					timede=timede,
					mrows=mrows,
					modulen=modulen,
					)
Beispiel #2
0
	def get(self):
		def gethostn(hostip):
			return db.c("host", "hostip='"+hostip+"'")

		def getname(id):
			return urlde(db.ct("project", "name", "id="+str(id))['name'])
		rows = db.cts("host", "hostip", "online=1")
		row = []
		for x in rows:
			row.append(db.ct("host", "*", "hostip='"+x['hostip']+"' order by id desc limit 1"))
		self.render(
			"online.html",
			heads=[
				{'name':'Online', 'title':'', 'url':''},
			],
			username=self.get_secure_cookie("username"),
			datainfo=db.datainfo(),
			systeminfo=systeminfo(),
			urlde=urlde,
			url=URL,
			timede=timede,
			urljson=urljson,
			getaddr=getaddr,
			row=row,
			getname=getname,
			gethostn=gethostn,
		)
			
Beispiel #3
0
 def get(self, id):
     row = db.ct("host", "*", "id=" + id)
     if row:
         if row['online'] == 1:
             self.render('console.html',
                         username=self.get_secure_cookie("username"),
                         heads=[
                             {
                                 'name': 'console',
                                 'title': '',
                                 'url': ''
                             },
                             {
                                 'name': row['hostip'],
                                 'title': '',
                                 'url': ''
                             },
                         ],
                         datainfo=db.datainfo(),
                         systeminfo=systeminfo(),
                         url=URL,
                         urlde=urlde,
                         hostip=row['hostip'])
         else:
             self.set_header('Content-type', 'text/html;charset=utf-8')
             self.write('(⊙ˍ⊙)')
     else:
         self.write(id)
Beispiel #4
0
	def get(self):
		def getname(id):
			return urlde(db.ct("project","name","id="+id)['name'])
			
		month = time.strftime("%m", time.localtime(time.time()))
		tables = db.cts("host", "projectid,date_format(from_unixtime(addtime),'%%e') as day", "date_format(from_unixtime(addtime),'%%m')='"+month+"'")
		datatable = {}
		for table in tables:
			id = str(table['projectid'])
			if id not in datatable:
				datatable[id] = {}
				i = 1
				while i <= 31:
					datatable[id][i] = 0
					i += 1
			else:
				datatable[id][int(table['day'])] += 1
		x=''
		for data in datatable:
			for day in datatable[data]:
				x = x + '['+str(day)+', '+str(datatable[data][day])+'],'
			x = x[:-1]
			datatable[data] = x
		self.render(
			'home.html',
			username=self.get_secure_cookie("username"),
			datainfo=db.datainfo(),
			systeminfo=systeminfo(),
			heads=[],
			url=URL,
			urlde=urlde,
			datatable=datatable,
			getname = getname,
			)
Beispiel #5
0
    def get(self, projectid, ip, page, do):
        def getname(id):
            return urlde(db.ct("project", "name", "id=" + id)['name'])

        if ip and projectid:
            num = db.c('host',
                       "hostip='" + ip + "' and projectid='" + projectid + "'")
            if num:
                page = str(page and
                           (int(page) - 1 > 0 and
                            (int(page) - 1 < num and int(page) - 1 or 0) or 0)
                           or 0)
                host = db.ct(
                    "host", "*", "hostip = '" + ip + "' and projectid='" +
                    projectid + "' order by id desc limit " + page + ",1")
                if do == 'del':
                    db.d("host", "id=" + str(host['id']))
                    if num == 1:
                        hostlist = json.loads(
                            db.ct("project", "hosts",
                                  "id=" + projectid)['hosts'])
                        hostlist.remove(ip)
                        db.u("project", "hosts='" + json.dumps(hostlist) + "'",
                             "id=" + projectid)
                        self.redirect("http://" + URL + "/project/" +
                                      projectid)
                    self.redirect("http://" + URL + "/host/" + projectid +
                                  "/" + ip)
                else:
                    self.render(
                        "host.html",
                        heads=[
                            {
                                'name': getname(projectid),
                                'title': 'Go to ' + getname(projectid),
                                'url': 'project/' + projectid
                            },
                            {
                                'name': ip,
                                'title': '',
                                'url': ''
                            },
                        ],
                        username=self.get_secure_cookie("username"),
                        datainfo=db.datainfo(),
                        systeminfo=systeminfo(),
                        urlde=urlde,
                        timede=timede,
                        url=URL,
                        urljson=urljson,
                        host=host,
                        num=range(num),
                        page=int(page) + 1,
                    )
            else:
                self.render('404.html')
        else:
            self.render('404.html')
Beispiel #6
0
	def get(self, projectid, ip, page, do):
		def getname(id):
			return urlde(db.ct("project","name","id="+id)['name'])
		if ip and projectid:
			num = db.c('host', "hostip='"+ip+"' and projectid='"+projectid+"'")
			if num:
				page = str(page and (int(page)-1>0 and (int(page)-1<num and int(page)-1 or 0) or 0) or 0)
				host = db.ct(
					"host",
					"*",
					"hostip = '"+ip+"' and projectid='"+projectid+"' order by id desc limit "+page+",1")
				if do == 'del':
					db.d("host", "id="+str(host['id']))
					if num == 1:
						hostlist = json.loads(db.ct("project", "hosts", "id="+projectid)['hosts'])
						hostlist.remove(ip)
						db.u("project", "hosts='"+json.dumps(hostlist)+"'", "id="+projectid)
						self.redirect("http://"+URL+"/project/"+projectid)
					self.redirect("http://"+URL+"/host/"+projectid+"/"+ip)
				else:
					self.render(
						"host.html",
						heads=[
							{'name':getname(projectid), 'title': 'Go to ' + getname(projectid),
								'url': 'project/'+projectid},
						{'name': ip, 'title': '', 'url': ''},
						],
						username=self.get_secure_cookie("username"),
						datainfo=db.datainfo(),
						systeminfo=systeminfo(),
						urlde=urlde,
						timede=timede,
						url=URL,
						urljson=urljson,
						host=host,
						num=range(num),
						page=int(page)+1,
						)
			else:
				self.render('404.html')
		else:
			self.render('404.html')
Beispiel #7
0
	def get(self, id):
		row = db.ct("host", "*", "id="+id)
		if row:
			if row['online'] == 1:
				self.render(
					'console.html',
					username=self.get_secure_cookie("username"),
					heads=[
						{'name': 'console', 'title': '', 'url': ''},
						{'name': row['hostip'], 'title':'', 'url':''},
					],
					datainfo=db.datainfo(),
					systeminfo=systeminfo(),
					url=URL,
					urlde=urlde,
					hostip=row['hostip']
					)
			else:
				self.set_header('Content-type', 'text/html;charset=utf-8')
				self.write('(⊙ˍ⊙)')
		else:
			self.write(id)
Beispiel #8
0
    def get(self):
        def getname(id):
            return urlde(db.ct("project", "name", "id=" + id)['name'])

        month = time.strftime("%m", time.localtime(time.time()))
        tables = db.cts(
            "host",
            "projectid,date_format(from_unixtime(addtime),'%%e') as day",
            "date_format(from_unixtime(addtime),'%%m')='" + month + "'")
        datatable = {}
        for table in tables:
            id = str(table['projectid'])
            if id not in datatable:
                datatable[id] = {}
                i = 1
                while i <= 31:
                    datatable[id][i] = 0
                    i += 1
            else:
                datatable[id][int(table['day'])] += 1
        x = ''
        for data in datatable:
            for day in datatable[data]:
                x = x + '[' + str(day) + ', ' + str(
                    datatable[data][day]) + '],'
            x = x[:-1]
            datatable[data] = x
        self.render(
            'home.html',
            username=self.get_secure_cookie("username"),
            datainfo=db.datainfo(),
            systeminfo=systeminfo(),
            heads=[],
            url=URL,
            urlde=urlde,
            datatable=datatable,
            getname=getname,
        )
Beispiel #9
0
    def get(self, id, do):
        def gethostn(hostip):
            return db.c("host", "hostip='" + hostip + "'")

        def getmcustom(code):
            code = urlde(code)
            s = re.findall("({set\..*})", code)
            return s

        if id:
            row = db.ct("project", "*", "id=" + id)
            if row:
                if do == "del":
                    db.d("project", "id=" + id)
                    self.redirect("http://" + URL + "/project")
                elif do == "edit":
                    modules = db.cts("module", "*", "1=1")
                    pmodules = json.loads(urlde(db.ct("project", "module", "id=" + id)["module"]))
                    self.render(
                        "project_edit.html",
                        heads=[
                            {"name": "Project", "title": "Project list", "url": "project"},
                            {"name": urlde(row["name"]), "title": urlde(row["name"]) + "view", "url": "project/" + id},
                        ],
                        username=self.get_secure_cookie("username"),
                        datainfo=db.datainfo(),
                        systeminfo=systeminfo(),
                        urlde=urlde,
                        getmcustom=getmcustom,
                        row=row,
                        url=URL,
                        modules=modules,
                        pmodules=pmodules,
                    )
                else:
                    x = []
                    hosts = []
                    hostlist = json.loads(db.ct("project", "hosts", "id=" + id)["hosts"])
                    hostn = 0
                    if hostlist:
                        for i in hostlist:
                            x.append(
                                db.ct(
                                    "host", "id", "hostip='" + i + "' and projectid=" + id + " order by id desc limit 1"
                                )["id"]
                            )
                        x.sort(reverse=True)
                        hostn = len(x)
                        for i in x:
                            hosts.append(
                                db.ct("host", "hostip,information,online,addtime,projectid,id", "id=" + str(i))
                            )
                    self.render(
                        "project_select.html",
                        heads=[
                            {"name": "Project", "title": "Project list", "url": "project"},
                            {"name": urlde(row["name"]), "title": "", "url": ""},
                        ],
                        username=self.get_secure_cookie("username"),
                        datainfo=db.datainfo(),
                        systeminfo=systeminfo(),
                        urlde=urlde,
                        hostn=hostn,
                        hosts=hosts,
                        gethostn=gethostn,
                        url=URL,
                        timede=timede,
                        urljson=urljson,
                        getaddr=getaddr,
                    )
            else:
                self.render("404.html")
        else:
            if do == "add":
                modules = db.cts("module", "*", "1=1")
                self.render(
                    "project_add.html",
                    heads=[
                        {"name": "Project", "title": "Project list", "url": "project"},
                        {"name": "Add", "title": "", "url": ""},
                    ],
                    username=self.get_secure_cookie("username"),
                    datainfo=db.datainfo(),
                    systeminfo=systeminfo(),
                    url=URL,
                    urlde=urlde,
                    modules=modules,
                    getmcustom=getmcustom,
                )
            else:
                prows = db.cts("project", "*", "1=1 order by id")  # 所有的project
                hrown = {}  # host数目
                hrowno = {}  # host online 数目
                if prows:
                    for i in prows:
                        hrown[i["id"]] = db.c("host", "projectid=" + str(i["id"]))
                        hrowno[i["id"]] = db.c("host", "projectid=" + str(i["id"]) + " and online=1")
                self.render(
                    "project.html",
                    heads=[{"name": "Project", "title": "", "url": ""}],
                    prows=prows,
                    prown=len(prows),
                    hrown=hrown,
                    hrowno=hrowno,
                    username=self.get_secure_cookie("username"),
                    datainfo=db.datainfo(),
                    systeminfo=systeminfo(),
                    url=URL,
                    urlde=urlde,
                    timede=timede,
                )
Beispiel #10
0
    def get(self, id, do):
        def gethostn(hostip):
            return db.c("host", "hostip='" + hostip + "'")

        def getmcustom(code):
            code = urlde(code)
            s = re.findall("({set\..*})", code)
            return s

        if id:
            row = db.ct("project", "*", "id=" + id)
            if row:
                if do == 'del':
                    db.d("project", "id=" + id)
                    self.redirect("http://" + URL + "/project")
                elif do == 'edit':
                    modules = db.cts("module", "*", "1=1")
                    pmodules = json.loads(
                        urlde(
                            db.ct("project", "module", "id=" + id)['module']))
                    self.render(
                        "project_edit.html",
                        heads=[
                            {
                                'name': 'Project',
                                'title': 'Project list',
                                'url': 'project'
                            },
                            {
                                'name': urlde(row['name']),
                                'title': urlde(row['name']) + 'view',
                                'url': 'project/' + id
                            },
                        ],
                        username=self.get_secure_cookie("username"),
                        datainfo=db.datainfo(),
                        systeminfo=systeminfo(),
                        urlde=urlde,
                        getmcustom=getmcustom,
                        row=row,
                        url=URL,
                        modules=modules,
                        pmodules=pmodules,
                    )
                else:
                    x = []
                    hosts = []
                    hostlist = json.loads(
                        db.ct("project", "hosts", "id=" + id)['hosts'])
                    hostn = 0
                    if hostlist:
                        for i in hostlist:
                            x.append(
                                db.ct(
                                    "host", "id",
                                    "hostip='" + i + "' and projectid=" + id +
                                    " order by id desc limit 1")['id'])
                        x.sort(reverse=True)
                        hostn = len(x)
                        for i in x:
                            hosts.append(
                                db.ct(
                                    "host",
                                    "hostip,information,online,addtime,projectid,id",
                                    "id=" + str(i)))
                    self.render(
                        "project_select.html",
                        heads=[
                            {
                                'name': 'Project',
                                'title': 'Project list',
                                'url': 'project'
                            },
                            {
                                'name': urlde(row['name']),
                                'title': '',
                                'url': ''
                            },
                        ],
                        username=self.get_secure_cookie("username"),
                        datainfo=db.datainfo(),
                        systeminfo=systeminfo(),
                        urlde=urlde,
                        hostn=hostn,
                        hosts=hosts,
                        gethostn=gethostn,
                        url=URL,
                        timede=timede,
                        urljson=urljson,
                        getaddr=getaddr,
                    )
            else:
                self.render('404.html')
        else:
            if do == 'add':
                modules = db.cts("module", "*", "1=1")
                self.render(
                    "project_add.html",
                    heads=[
                        {
                            'name': 'Project',
                            'title': 'Project list',
                            'url': 'project'
                        },
                        {
                            'name': 'Add',
                            'title': '',
                            'url': ''
                        },
                    ],
                    username=self.get_secure_cookie("username"),
                    datainfo=db.datainfo(),
                    systeminfo=systeminfo(),
                    url=URL,
                    urlde=urlde,
                    modules=modules,
                    getmcustom=getmcustom,
                )
            else:
                prows = db.cts("project", "*", "1=1 order by id")  #所有的project
                hrown = {}  #host数目
                hrowno = {}  #host online 数目
                if prows:
                    for i in prows:
                        hrown[i['id']] = db.c("host",
                                              "projectid=" + str(i['id']))
                        hrowno[i['id']] = db.c(
                            "host",
                            "projectid=" + str(i['id']) + " and online=1")
                self.render(
                    "project.html",
                    heads=[{
                        'name': 'Project',
                        'title': '',
                        'url': ''
                    }],
                    prows=prows,
                    prown=len(prows),
                    hrown=hrown,
                    hrowno=hrowno,
                    username=self.get_secure_cookie("username"),
                    datainfo=db.datainfo(),
                    systeminfo=systeminfo(),
                    url=URL,
                    urlde=urlde,
                    timede=timede,
                )
Beispiel #11
0
 def get(self, id, do):
     if id:
         row = db.ct("module", "*", "id=" + id)
         if row:
             if do == 'del':
                 db.d("module", "id=" + id)
                 self.redirect("http://" + URL + "/module")
             else:
                 self.render(
                     'module_edit.html',
                     username=self.get_secure_cookie("username"),
                     datainfo=db.datainfo(),
                     systeminfo=systeminfo(),
                     heads=[
                         {
                             'name': 'Module',
                             'title': 'Module list',
                             'url': 'module/'
                         },
                         {
                             'name': urlde(row['name']),
                             'title': '',
                             'url': ''
                         },
                     ],
                     row=row,
                     url=URL,
                     urlde=urlde,
                 )
         else:
             self.render('404.html')
     else:
         if do == 'add':
             self.render(
                 'module_add.html',
                 username=self.get_secure_cookie("username"),
                 datainfo=db.datainfo(),
                 systeminfo=systeminfo(),
                 heads=[{
                     'name': 'Module',
                     'title': 'Module list',
                     'url': 'module/'
                 }, {
                     'name': 'Add',
                     'title': '',
                     'url': ''
                 }],
                 url=URL,
                 urlde=urlde,
             )
         else:
             mrows = db.cts("module", "*", "1=1 order by id")
             modulen = len(mrows)
             self.render(
                 "module.html",
                 username=self.get_secure_cookie("username"),
                 datainfo=db.datainfo(),
                 systeminfo=systeminfo(),
                 heads=[{
                     'name': 'Module',
                     'title': '',
                     'url': ''
                 }],
                 url=URL,
                 urlde=urlde,
                 timede=timede,
                 mrows=mrows,
                 modulen=modulen,
             )