def index():
'''
运维闲置资源管理
:return:
'''
# 此模块的管理员角色名称
isadmin = IsAdmin(['系统管理员', '运维闲置资产管理市分'])
#print(isadmin)
if isGetMethod():
return render_template("yunwei/xianzhi.html", isadmin=isadmin)
from autodb.models.yunwei import xianzhi
zcbh = getargs('zcbh')
#按资产编号进行查询
vsql = "p for p in xianzhi if True "
if zcbh:
vsql += " and p.zcbh=='{0}'".format(zcbh)
if not isadmin:
#不是管理员加限制
vsql += " and p.creatorid=='{0}'".format(g.user.get_id())
data = select(vsql).order_by(desc(xianzhi.guid))
return getGridData(entity=xianzhi, data=data)
def index() :
'''
运维闲置资源管理
:return:
'''
# 此模块的管理员角色名称
isadmin = IsAdmin(['系统管理员', '运维闲置资产管理市分'])
#print(isadmin)
if isGetMethod() :
return render_template("yunwei/xianzhi.html", isadmin = isadmin)
from autodb.models.yunwei import xianzhi
zcbh = getargs('zcbh')
#按资产编号进行查询
vsql = "p for p in xianzhi if True "
if zcbh :
vsql += " and p.zcbh=='{0}'".format(zcbh)
if not isadmin:
#不是管理员加限制
vsql+=" and p.creatorid=='{0}'".format(g.user.get_id())
data = select(vsql).order_by(desc(xianzhi.guid))
return getGridData(entity = xianzhi, data = data)
def sqllistdata():
from autodb.models.sqllist import sqllist
data = select(p for p in sqllist if p.user_code == g.user.user_code)
return getGridData(entity=sqllist, data=data)
def wizlistdata():
pageIndex = int(getargs("pageIndex", 0))
pageSize = int(getargs("pageSize", 0))
total = select(count(p.guid) for p in invite_list).first()
data = select(p for p in invite_list).order_by(desc(invite_list.opdate)).limit(pageSize, pageSize * pageIndex)
return getGridData(invite_list, total, data)
def sqllistdata():
from autodb.models.sqllist import sqllist
data = select(p for p in sqllist if p.user_code == g.user.user_code)
return getGridData(entity=sqllist, data=data)
def sqlresult():
'''
获取sqlresult数据
'''
sguid = getargs("sguid")
from autodb.models.sqlresult import sqlresult
data = select(p for p in sqlresult if p.sguid == sguid).order_by(desc(sqlresult.guid))
return getGridData(sqlresult, data=data)
def sqlresult():
'''
获取sqlresult数据
'''
sguid = getargs("sguid")
from autodb.models.sqlresult import sqlresult
data = select(p for p in sqlresult
if p.sguid == sguid).order_by(desc(sqlresult.guid))
return getGridData(sqlresult, data=data)
def proxyresult():
'''
获取proxyresult数据
'''
pageIndex = int(getargs("pageIndex", 0))
pageSize = int(getargs("pageSize", 0))
total = select(count(p.guid) for p in proxy_list ).first()
data = select(p for p in proxy_list ) \
.order_by(desc(proxy_list.state))\
.order_by(desc(proxy_list.opdate))\
.limit(pageSize,
pageIndex)
return getGridData(proxy_list, total, data)
def proxyresult():
'''
获取proxyresult数据
'''
pageIndex = int(getargs("pageIndex", 0))
pageSize = int(getargs("pageSize", 0))
total = select(count(p.guid) for p in proxy_list).first()
data = select(p for p in proxy_list ) \
.order_by(desc(proxy_list.state))\
.order_by(desc(proxy_list.opdate))\
.limit(pageSize,
pageIndex)
return getGridData(proxy_list, total, data)
def wizresult():
'''
获取sqlresult数据
'''
pageIndex = int(getargs("pageIndex", 0))
pageSize = int(getargs("pageSize", 0))
invite_code = getargs("invite_code")
total = select(count(p.guid) for p in wiz_user if p.invite_code == invite_code).first()
data = select(p for p in wiz_user if p.invite_code == invite_code).order_by(desc(wiz_user.opdate)).limit(pageSize,
pageSize
*
pageIndex)
return getGridData(wiz_user, total, data)
# coding: utf-8
def wizdata():
invite_code=flaskhelper.getargs('invite_code')
total =1
data = select(p for p in wiz_user if p.regcode== invite_code)
return getGridData(wiz_user, total, data)