def eserver_list(request):
if get_current_admin_id(request) == Admin.objects.get(name='admin').id:
pt = eserver.objects.all()
else:
pt = eserver.objects.filter(
eproject__eproject_admin__admin_id=get_current_admin_id(request))
##分页
query_string = request.META.get('QUERY_STRING', '')
# 搜索功能
host = request.GET.get('host', '')
epname = request.GET.get('epname', '')
if epname:
try:
temp = eproject.objects.get(pname=epname)
pt = temp.eserver_set.all()
except eproject.DoesNoeExist:
pass
elif len(host) > 0:
pt = eserver.objects.filter(host__contains=host).order_by('-id')
else:
page_objects = pages(pt, request, 5) ##分页
page_objects = pages(pt, request, 5) ##分页
pname = eproject.objects.all()
return render_to_response('eproject/eserver_list.html', locals())
def operation_log_list(request):
import datetime
admin_name = request.GET.get('admin_name', '').strip()
privilege_name = request.GET.get('privilege_name', '').strip()
begin_date = request.GET.get('begin_date', '').strip()
end_date = request.GET.get('end_date', '').strip()
privilege_group_id = request.GET.get('privilege_group_id', '')
objects = OperationLog.objects.all().order_by('-id')
if admin_name:
objects = OperationLog.objects.filter(admin_name__contains=admin_name)
if privilege_name:
objects = objects.filter(
privilege__privilege_name__contains=privilege_name)
if begin_date:
objects = objects.filter(create_at__gte=begin_date)
if end_date:
print end_date, type(end_date)
tt = end_date.split('-')
t2 = datetime.datetime(int(tt[0]), int(tt[1]), int(tt[2]))
t3 = t2 + datetime.timedelta(1)
objects = objects.filter(create_at__lte=t3)
objects.order_by('-id')
page_objects = pages(objects, request)
privilege_groups = PrivilegeGroup.objects.all()
return render_to_response('account/operation_log_list.html', locals())
def eprivs_list(request):
pt = eprivs.objects.all().order_by('-id')
##分页
query_string = request.META.get('QUERY_STRING', '')
# # 搜索功能
username = request.GET.get('username', '')
if username:
pt = eprivs.objects.filter(dname__contains=username)
page_objects = pages(pt, request, 5) ##分页
return render_to_response('eproject/eprivs_list.html', locals())
def module_list(request):
query_string = request.META.get('QUERY_STRING', '')
module_name = request.GET.get('module_name', '').strip()
objects = Module.objects.all().order_by('-id')
if module_name:
objects = Module.objects.filter(module_name__contains=module_name).order_by('-id')
page_objects = pages(objects, request)
return render_to_response('account/module_list.html', locals())
def eproject_list(request):
pt=eproject.objects.all()
##分页
query_string = request.META.get('QUERY_STRING', '')
# 搜索功能
pname = request.GET.get('pname', '')
if len(pname) > 0:
pt = eproject.objects.filter(pname__contains=pname).order_by('-id')
page_objects = pages(pt, request, 5) ##分页
return render_to_response('eproject/eproject_list.html', locals())
def privilege_group_list(request):
query_string = request.META.get('QUERY_STRING', '')
group_name = request.GET.get('group_name', '').strip()
objects = PrivilegeGroup.objects.all().order_by('-id')
if group_name:
objects = PrivilegeGroup.objects.filter(group_name__contains=group_name)
objects.order_by('-id')
page_objects = pages(objects, request)
return render_to_response('account/privilege_group_list.html', locals())
def eproject_list(request):
if get_current_admin_id(request) == Admin.objects.get(name='admin').id:
pt = eproject.objects.all()
else:
pt = eproject.objects.filter(
eproject_admin__admin_id=get_current_admin_id(request))
##分页
query_string = request.META.get('QUERY_STRING', '')
# 搜索功能
pname = request.GET.get('pname', '')
if len(pname) > 0:
pt = eproject.objects.filter(pname__contains=pname).order_by('-id')
page_objects = pages(pt, request, 10) ##分页
return render_to_response('eproject/eproject_list.html', locals())
def etable_list(request):
# 搜索功能
tbname = request.GET.get('tbname', '')
dbname = request.GET.get('dbname', '')
if len(dbname) > 0 and len(tbname) == 0:
hts=history_tab_sum.objects.filter(dbname=dbname)
elif len(dbname) == 0 and len(tbname) > 0:
hts = history_tab_sum.objects.filter(tbname__contains=tbname)
elif len(dbname) > 0 and len(tbname) > 0:
hts = history_tab_sum.objects.filter(dbname=dbname,tbname__contains=tbname)
else:
hts = history_tab_sum.objects.all().order_by('dbname','tbname')
page_objects = pages(hts, request, 10) ##分页
ed=edatabase.objects.all()
return render_to_response('serman/etable_list.html', locals())
def role_list(request):
query_string = request.META.get('QUERY_STRING', '')
role_name = request.GET.get('role_name', '').strip()
role_group_id = request.GET.get('role_group_id', '')
objects = Role.objects.all().order_by('-id')
if role_name:
objects = Role.objects.filter(role_name__contains=role_name)
if role_group_id:
objects = objects.filter(role_group_id=role_group_id)
objects.order_by('-id')
page_objects = pages(objects, request)
return render_to_response('account/role_list.html', locals())
def edatabase_list(request):
if get_current_admin_id(request) == Admin.objects.get(name='admin').id:
pt = edatabase.objects.all()
else:
pt = edatabase.objects.filter(
eserver__eproject__eproject_admin__admin_id=get_current_admin_id(
request))
##分页
query_string = request.META.get('QUERY_STRING', '')
host = request.GET.get('host', '')
if host:
pt = edatabase.objects.filter(eserver__host=host).order_by('id')
page_objects = pages(pt, request, 10) ##分页
# pname=eproject.objects.all()
return render_to_response('eproject/edatabase_list.html', locals())
def admin_list(request):
query_string = request.META.get('QUERY_STRING', '')
name = request.GET.get('name', '').strip()
email = request.GET.get('email', '').strip()
role_id = request.GET.get('role_id', '')
objects = Admin.objects.all().order_by('-id')
if role_id and name and email:
print 111
objects = Admin.objects.filter(role_id=role_id).filter(
name__contains=name).filter(email__contains=email)
if role_id and name and not email:
print 222
objects = Admin.objects.filter(role_id=role_id).filter(
name__contains=name)
if role_id and email and not name:
print 333
objects = Admin.objects.filter(role_id=role_id).filter(
email__contains=email)
if name and email and not role_id:
print 444
objects = Admin.objects.filter(name__contains=name).filter(
email__contains=email)
if name and not role_id and not email:
print 55
objects = Admin.objects.filter(name__contains=name)
if role_id and not email and not name:
print 666
objects = objects.filter(role_id=role_id)
if email and not role_id and not name:
print 777
objects = Admin.objects.filter(email__contains=email)
objects.order_by('-id')
page_objects = pages(objects, request)
roles = Role.objects.all()
current_role_id = get_current_role_id(request)
return render_to_response('account/admin_list.html', locals())
if not bycol:
bycol='ts_max'
print '666666666666666',phostname,database,begin_date,end_date,bycol
###组合判断
if len(phostname) > 0 and len(database)==0:
pt = global_query_review_history.objects.filter(hostname_max=phostname,ts_min__gte=begin_date, ts_max__lte=end_date).order_by('-%s' % bycol)
elif len(database) > 0 and len(phostname)==0 :
pt = global_query_review_history.objects.filter(db_max__contains=database,ts_min__gte=begin_date, ts_max__lte=end_date).order_by('-%s' % bycol)
elif len(database) > 0 and len(phostname)>0:
pt = global_query_review_history.objects.filter(db_max__contains=database,hostname_max=phostname,ts_min__gte=begin_date, ts_max__lte=end_date).order_by('-%s' % bycol) ##分页
else:
pt = global_query_review_history.objects.filter(ts_min__gte=begin_date, ts_max__lte=end_date).order_by('-%s' % bycol)
page_objects = pages(pt, request, 10) ##分页
ese=eserver.objects.all()
return render_to_response('serman/ptslow_list.html', locals())
def etable_list(request):
# 搜索功能
tbname = request.GET.get('tbname', '')
dbname = request.GET.get('dbname', '')
if len(dbname) > 0 and len(tbname) == 0:
hts=history_tab_sum.objects.filter(dbname=dbname)
elif len(dbname) == 0 and len(tbname) > 0:
hts = history_tab_sum.objects.filter(tbname__contains=tbname)
elif len(dbname) > 0 and len(tbname) > 0:
hts = history_tab_sum.objects.filter(dbname=dbname,tbname__contains=tbname)
else:
hts = history_tab_sum.objects.all().order_by('dbname','tbname')
def eprivs_list(request):
pt = eprivs_eserver.objects.all().order_by('-id')
##分页
query_string = request.META.get('QUERY_STRING', '')
page_objects = pages(pt, request, 5) ##分页
return render_to_response('eproject/eprivs_list.html', locals())
