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())