def rightgiveuser(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nRightuserid = req.GET['userid']
userinfo = Right.getrightusers(nRightuserid)
data = Right.getallright(nRightuserid)
return render_to_response('right/right-giveuser.html', {'data': data, 'datas': userinfo})
else:
nUserid = req.session["sess_userid"]
nRightidList = req.POST.get('rightsid')
nRightuserName= req.POST.get('username')
print nRightuserName
nRightuserId = User.getUserIdbyUsername(nRightuserName)
print "nRightuserId="
print nRightuserId
Right.userrightupdate(nRightuserId,nRightidList)
return HttpResponseRedirect('/user/userlist/')
def rightupdate(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nRightid = req.GET['rightsid']
rightinfo = Right.rightbeforeupdate(nRightid)
datalist = Right.rightbeforeadd()
return render_to_response('right/right-update.html', {'data': datalist, 'datas': rightinfo})
else:
nUserid = req.session["sess_userid"]
nRightid = req.GET['rightsid']
nRightname = req.POST.get('rightname')
nMenuid = req.POST.get('menuid')
nAction = req.POST.get('action')
nStatus = int(req.POST.get('status'))
Right.rightupdate(nRightname, nAction, nStatus, nMenuid, nRightid)
return HttpResponseRedirect('/right/rightlist/')
def rightdelete(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nRightid = req.GET['rightsid']
Right.rightdelete(nRightid)
return HttpResponseRedirect('/right/rightlist/')
def rightlist(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nRightuserid = 0
userinfo = Right.getrightusers(nRightuserid)
userlen = len(userinfo)
datalist = Right.rightlist()
return render_to_response('right/right-list.html', {'data': datalist, 'datas': userlen})
def userupdate(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nNewUserid = req.GET['userid']
datalist = User.userbeforeupdate(nNewUserid)
return render_to_response('user/user-update.html',
{'data': datalist})
else:
nNewUserid = req.POST.get('olduserid')
nLoginname = req.POST.get('loginname')
nLoginpwdold = req.POST.get('oldpwd')
if req.POST.get('loginpwd') == '':
nLoginpwd = nLoginpwdold
else:
nLoginpwd = req.POST.get('loginpwd')
nUsername = req.POST.get('username')
nUseremail = req.POST.get('useremail')
nUsermobile = req.POST.get('usermobile')
nUserdepartment = req.POST.get('userdepartment')
nUserrole = req.POST.get('userrole')
nStatus = req.POST.get('status')
User.userupdate(nLoginname, nLoginpwd, nUsername, nUseremail,
nUsermobile, nUserdepartment, nUserrole,
nStatus, nNewUserid)
return HttpResponseRedirect('/user/userlist/')
def useradd(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
return render_to_response('user/user-add.html')
else:
nUserid = req.session["sess_userid"]
nLoginname = req.POST.get('loginname')
nLoginpwd = req.POST.get('loginpwd')
nUsername = req.POST.get('username')
nUseremail = req.POST.get('useremail')
nUsermobile = req.POST.get('usermobile')
nUserrole = int(req.POST.get('userrole'))
nUserdepartment = req.POST.get('userdepartment')
nStatus = int(req.POST.get('status'))
User.useradd(nLoginname, nLoginpwd, nUsername, nUseremail,
nUsermobile, nUserrole, nUserdepartment, nStatus)
return HttpResponseRedirect('/user/userlist/')
def menuupdate(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nMenuid = req.GET['menuid']
menuinfo = Memu.menubeforeupdate(nMenuid)
datalist = Memu.menubeforeadd()
return render_to_response('menu/menu-update.html', {
'data': datalist,
'datas': menuinfo
})
else:
nMenuid = req.POST.get('menuid')
nMenuname = req.POST.get('menuname')
nParentid = req.POST.get('parentid')
nAction = req.POST.get('action')
nStyletype = req.POST.get('styletype')
nStatus = int(req.POST.get('status'))
nOrdersort = int(req.POST.get('ordersort'))
Memu.menuupdate(nMenuid, nMenuname, nParentid, nAction,
nStyletype, nStatus, nOrdersort)
return HttpResponseRedirect('/menu/menulist/')
def sqlcontentupdate(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nTaskid = req.GET['taskid']
datalist = MysqlIncedata.sqlcontentinfo(nTaskid)
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
mysqllist = MysqlIncedata.mysqllist(nUserRole, nRightUserid)
return render_to_response('mysqlincedata/mysql-sqlcontentupdate.html', {'data': datalist ,'mysqldata': mysqllist})
else:
nTaskid = req.POST.get('taskid')
nDbid = req.POST.get('dbid')
nSqlcontent = req.POST.get('sqlcontent')
MysqlIncedata.sqlcontentupdate(nTaskid, nDbid, nSqlcontent)
return HttpResponseRedirect('/mysql/tobeexecutemysqltask/')
def sqlauditingadd(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
datalist = MysqlIncedata.mysqllist(nUserRole, nRightUserid)
return render_to_response(
'mysqlsqladvisor/mysql-sqlauditingadd.html',
{'data': datalist})
else:
nUserid = req.session["sess_userid"]
nDbid = req.POST.get('dbid')
nSqlcontent = req.POST.get('sqlcontent')
MysqlAdvisor.sqladvisor(nDbid, nSqlcontent, nUserid)
return HttpResponseRedirect('/mysqlindex/sqlauditinglist/')
def mysqlgraphinfo(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nDbid = int(req.GET['dbid'])
nEndtime = datetime.datetime.now().strftime(
"%Y-%m-%d %H:%M:%S")
nBegintime = time.strftime(
"%Y-%m-%d %H:%M:%S",
time.localtime(time.time() - 24 * 60 * 60))
datalist = Mmonitor.mysqllist()
dataredisinfo = Mmonitor.mysqlinfo(nDbid)
datamysqlqps = Mmonitor.mysqldatagrephqps(
nDbid, nBegintime, nEndtime)
datagrephvieprocessllist = Mmonitor.datagrephvieprocessllist(
nDbid, nBegintime, nEndtime)
return render_to_response(
'monitor/mysql-graph-info.html', {
'data': datalist,
'datas': datamysqlqps,
'num5': nBegintime,
'num6': nEndtime,
'datamen': datagrephviewmen,
'dataprocesslist': datagrephvieprocessllist
})
else:
nDbid = req.POST.get('dbid')
nEndtime = req.POST.get('endtime')
nBegintime = req.POST.get('begintime')
datalist = MysqlIncedata.mysqllist()
datamysqlqps = MysqlIncedata.mysqlinfo(nDbid)
datagrephviewmen = Mmonitor.mysqldatagrephqps(
nDbid, nBegintime, nEndtime)
datagrephvieprocessllist = Mmonitor.datagrephvieprocessllist(
nDbid, nBegintime, nEndtime)
return render_to_response(
'monitor/mysql-graph-info.html', {
'data': datalist,
'datas': datamysqlqps,
'num5': nBegintime,
'num6': nEndtime,
'datamen': datagrephviewmen,
'dataprocesslist': datagrephvieprocessllist
})
def serveruselist(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
datalist = Server.serveruselist()
return render_to_response('server/server-use-list.html',
{'data': datalist})
def servergetinfo(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nServerid = req.GET['serverid']
ServerInfo.servergetinfo(nServerid)
return HttpResponseRedirect('/server/serverlist/')
def sqlcheckresult(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nTaskid = req.GET['taskid']
datalist = MysqlIncedata.sqlcheckresult(nTaskid)
return render_to_response('mysqlincedata/mysql-sqlcheckresult.html', {'data': datalist})
def mysqlmonitorlist(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
datalist = Mmonitor.mysqllist()
return render_to_response('monitor/mysql-monitor-list.html',
{'data': datalist})
def sqltaskdelete(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nTaskid = req.GET['taskid']
MysqlIncedata.sqltaskdelete(nTaskid)
return HttpResponseRedirect("/mysql/tobeexecutemysqltask/")
def mysqllist(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
datalist = MysqlIncedata.mysqllist(nUserRole, nRightUserid)
rowdata = MysqlIncedata.gettastnum(nUserRole, nRightUserid)
return render_to_response('mysqlincedata/mysql-list.html', {'data': datalist, 'nums': rowdata})
def tobeexecutemysqltask(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
datalist = MysqlIncedata.tobeexecutemysqltask(nUserRole, nRightUserid)
return render_to_response('mysqlincedata/mysql-tobeexecute.html', {'data': datalist})
def menudelete(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nUserid = req.session["sess_userid"]
nMenuid = req.GET['menuid']
Memu.menudelete(nMenuid)
return HttpResponseRedirect('/menu/menulist/')
def mysqlbackuplist(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
datalist = MysqlBackup.mysqlbackuplist(nUserRole, nRightUserid)
return render_to_response('mysqlbackup/mysql-backuplist.html',
{'data': datalist})
def sqladvisorinfo(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nUserRole = req.session["sess_userrole"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
nAid = req.GET['id']
datalist = MysqlAdvisor.mysqladvisorinfo(nAid)
return render_to_response(
'mysqlsqladvisor/mysql-sqladvisorinfo.html',
{'data': datalist})
def serverupdate(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
nServerid = req.GET['serverid']
serverinfo = Server.serverbeforeupdate(nServerid)
datalist = Server.serveruselist()
datainfo = Server.servergrouplist()
print datalist
return render_to_response('server/server-update.html', {
'datas': serverinfo,
'info': datainfo,
'data': datalist
})
else:
nServerid = req.GET['serverid']
nServername = req.POST.get('servername')
nServersourceid = req.POST.get('serversourceid')
nServergroupid = req.POST.get('servergroupid')
nServertype = req.POST.get('servertype')
nServeruseid = req.POST.get('serveruseid')
nOuternet = req.POST.get('outernet')
nInnernet = req.POST.get('innernet')
nUseouterinner = req.POST.get('useouterinner')
nServerloginuser = req.POST.get('serverloginuser')
nServerloginpwd = req.POST.get('serverloginpwd')
nSshport = req.POST.get('sshport')
nHostname = req.POST.get('hostname')
nCpunum = req.POST.get('cpunum')
nMemorynum = req.POST.get('memorynum')
nSystemname = req.POST.get('systemname')
Server.serverupdate(nServerid, nServername, nServersourceid,
nServergroupid, nServertype, nServeruseid,
nOuternet, nInnernet, nUseouterinner,
nServerloginuser, nServerloginpwd,
nSshport)
return HttpResponseRedirect('/server/serverlist/')
def servergroupupdate(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
print nHaveRight
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
return render_to_response('server/server-group-add.html')
else:
nServerGroupName = req.POST.get('servergroupname')
Server.servergroupadd(nServerGroupName)
return HttpResponseRedirect('/server/servergrouplist/')
def sqlresultselect(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
datalist = ''
return render_to_response('mysqlincedata/mysql-resultselect.html', {'data': datalist})
else:
nContentinfo = req.POST.get('contentinfo')
nSelectDate = req.POST.get('selecttime')
print nContentinfo,nSelectDate
datalist = MysqlIncedata.sqlresultselect(nContentinfo, nSelectDate)
return render_to_response('mysqlincedata/mysql-resultselect.html', {'data': datalist, 'num1':nSelectDate, 'num2':nContentinfo})
def serveradd(req):
if not req.session.get("sess_userid", False):
return HttpResponseRedirect("/login/")
else:
nUrldata = req.path
nRightUserid = req.session["sess_userid"]
nHaveRight = Right.userrightcheck(nRightUserid, nUrldata)
print nHaveRight
if nHaveRight[0]["num"] == 0:
return HttpResponseRedirect("/noright/")
else:
if req.method == 'GET':
datalist = Server.serveruselist()
datainfo = Server.servergrouplist()
return render_to_response('server/server-add.html', {
'data': datalist,
'info': datainfo
})
else:
nServername = req.POST.get('servername')
nServersourceid = int(req.POST.get('serversourceid'))
nServertype = int(req.POST.get('servertype'))
nServergroupid = int(req.POST.get('servergroupid'))
nServeruseid = int(req.POST.get('serveruseid'))
nOuternet = req.POST.get('outernet')
nInnernet = req.POST.get('innernet')
nUseouterinner = req.POST.get('useouterinner')
nServerloginuser = req.POST.get('serverloginuser')
nServerloginpwd = req.POST.get('serverloginpwd')
nSshport = req.POST.get('sshport')
Server.serveradd(nServername, nServersourceid, nServertype,
nServergroupid, nServeruseid, nOuternet,
nInnernet, nUseouterinner, nServerloginuser,
nServerloginpwd, nSshport)
return HttpResponseRedirect('/server/serverlist/')
def left(req):
nRightuserid = req.session["sess_userid"]
nRightuserrole = req.session["sess_userrole"]
datalist = Right.leftmenuright(nRightuserid,nRightuserrole)
return render_to_response('left.html', {'data': datalist})