if org_id: root_org_id = int(org_id) tree_select_org_id = root_org_id #每页显示数量 # orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist,e1: return HttpResponse("机构不存在或者已经被删除!") else: children_org_queryset = Organization.objects.filter(link__startswith=parent_org.link) #print user_user,user_name,user_addr user_list = User.objects.filter(org__in=children_org_queryset,user__contains=user_user) onePageresults = getPage(user_list,numPerPage,pageNum) paginator = onePageresults.paginator result_user_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list':result_user_list, 'totalCount':totalCount, 'numPerPage':numPerPage, 'currentPage':currentPage,
tree_select_org_id = root_org_id #每页显示数量 # orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist, e1: return HttpResponse("机构不存在或者已经被删除!") else: children_org_queryset = Organization.objects.filter( link__startswith=parent_org.link) #print user_user,user_name,user_addr user_list = User.objects.filter(org__in=children_org_queryset, user__contains=user_user) onePageresults = getPage(user_list, numPerPage, pageNum) paginator = onePageresults.paginator result_user_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list': result_user_list, 'totalCount': totalCount, 'numPerPage': numPerPage, 'currentPage': currentPage,
memo__icontains=archive_memo) if archive_attr and archive_attr != "-1": archive_queryset = archive_queryset.filter(attr=archive_attr) # print archive_type if archive_type and archive_type != "-1": archive_queryset = archive_queryset.filter(type=archive_type) if begin_time: archive_queryset = archive_queryset.filter(rectime__gte=begin_time) if end_time: archive_queryset = archive_queryset.filter(rectime__lte=end_time) if archive_operator: archive_queryset = archive_queryset.filter( operator__contains=archive_operator) onePageresults = getPage(archive_queryset, numPerPage, pageNum) paginator = onePageresults.paginator result_archive_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list': result_archive_list, 'totalCount': totalCount, 'numPerPage': numPerPage, 'currentPage': currentPage,
) if client_clientid: archive_queryset = archive_queryset.filter(client__clientid__icontains=client_clientid) archive_queryset = archive_queryset.filter(memo__icontains=archive_memo) if archive_attr and archive_attr!="-1": archive_queryset = archive_queryset.filter(attr=archive_attr) # print archive_type if archive_type and archive_type!="-1": archive_queryset = archive_queryset.filter(type=archive_type) if begin_time: archive_queryset = archive_queryset.filter(rectime__gte=begin_time) if end_time: archive_queryset = archive_queryset.filter(rectime__lte=end_time) if archive_operator: archive_queryset = archive_queryset.filter(operator__contains=archive_operator) onePageresults = getPage(archive_queryset,numPerPage,pageNum) paginator = onePageresults.paginator result_archive_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list':result_archive_list, 'totalCount':totalCount, 'numPerPage':numPerPage, 'currentPage':currentPage,
#每页显示数量 # orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist,e1: return HttpResponse("机构不存在或者已经被删除!") else: children_org_queryset = Organization.objects.filter(link__startswith=parent_org.link) #print children_org_queryset.count() terminal_list = Terminal.objects.filter(org__in=children_org_queryset,user__contains=terminal_user,employee__contains=terminal_employee,address__contains=terminal_addr) onePageresults = getPage(terminal_list,numPerPage,pageNum) paginator = onePageresults.paginator result_terminal_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list':result_terminal_list, 'totalCount':totalCount, 'numPerPage':numPerPage, 'currentPage':currentPage,
root_org_id = int(org_id) tree_select_org_id = root_org_id #每页显示数量 # orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist,e1: return HttpResponse("机构不存在或者已经被删除!") else: # children_org_queryset = Organization.objects.filter(link__startswith=parent_org.link) # #print user_user,user_name,user_addr # user_list = User.objects.filter(org__in=children_org_queryset,user__contains=user_user) all_result,avg_,sum_ = manager_statistic_search(parent_org=parent_org,begin_time=begin_time,end_time=end_time) onePageresults = getPage(all_result,numPerPage,pageNum) paginator = onePageresults.paginator object_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list':object_list, 'totalCount':totalCount, 'numPerPage':numPerPage, 'currentPage':currentPage,
# orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist, e1: return HttpResponse("机构不存在或者已经被删除!") else: # children_org_queryset = Organization.objects.filter(link__startswith=parent_org.link) # #print user_user,user_name,user_addr # user_list = User.objects.filter(org__in=children_org_queryset,user__contains=user_user) all_result, avg_, sum_ = manager_statistic_search( parent_org=parent_org, begin_time=begin_time, end_time=end_time) onePageresults = getPage(all_result, numPerPage, pageNum) paginator = onePageresults.paginator object_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list': object_list, 'totalCount': totalCount, 'numPerPage': numPerPage, 'currentPage': currentPage,
# org_id = obj_id # org = Organization.objects.get(id=org_id) # children_org_set = Organization.objects.filter(link__startswith=org.link) # term_set = Terminal.objects.filter(org__in=children_org_set) term_set= [] elif type=="3": terminal_id = obj_id term_set = Terminal.objects.filter(id=terminal_id) else: return Http404() client_list = Client.objects.filter(Q(name__contains=client_name) | Q(pinyin__contains=client_name), Q(phone1__contains=client_phone) | Q(phone2__contains=client_phone)|Q(phone3__contains=client_phone), term__in=term_set, clientid__contains=client_clientid,sid__contains=client_sid,corp__contains=client_corp) onePageresults = getPage(client_list,numPerPage,pageNum) paginator = onePageresults.paginator result_client_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list':result_client_list, 'totalCount':totalCount, 'numPerPage':numPerPage, 'currentPage':currentPage,
else: org_id = request.GET.get("org_id","") if org_id: root_org_id = int(org_id) tree_select_org_id = root_org_id #每页显示数量 # orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist,e1: return HttpResponse("机构不存在或者已经被删除!") else: org_list = Organization.objects.filter(link__startswith=parent_org.link,name__contains=org_name,phone__contains=org_phone,address__contains=org_addr,org_sid__contains=org_sid).order_by("id") onePageresults = getPage(org_list,numPerPage,pageNum) paginator = onePageresults.paginator result_org_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list':result_org_list, 'totalCount':totalCount, 'numPerPage':numPerPage, 'currentPage':currentPage,
#每页显示数量 # orderField = request.POST.get("orderField","") # orderDirection = request.POST.get("orderDirection","") # pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist, e1: return HttpResponse("机构不存在或者已经被删除!") else: org_list = Organization.objects.filter( link__startswith=parent_org.link, name__contains=org_name, phone__contains=org_phone, address__contains=org_addr, org_sid__contains=org_sid).order_by("id") onePageresults = getPage(org_list, numPerPage, pageNum) paginator = onePageresults.paginator result_org_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list': result_org_list, 'totalCount': totalCount, 'numPerPage': numPerPage, 'currentPage': currentPage,
# pageNum = request.POST.get("","") try: parent_org = Organization.objects.get(pk=root_org_id) except Organization.DoesNotExist, e1: return HttpResponse("机构不存在或者已经被删除!") else: children_org_queryset = Organization.objects.filter( link__startswith=parent_org.link) #print children_org_queryset.count() terminal_list = Terminal.objects.filter( org__in=children_org_queryset, user__contains=terminal_user, employee__contains=terminal_employee, address__contains=terminal_addr) onePageresults = getPage(terminal_list, numPerPage, pageNum) paginator = onePageresults.paginator result_terminal_list = onePageresults.object_list #要显示的记录 totalCount = paginator.count #总数量 numPerPage = paginator.per_page #每页显示的数量 pageCount = paginator.num_pages currentPage = pageNum #当前页 pageNumShown = 5 #显示页标个数 context = Context({ 'obj_list': result_terminal_list, 'totalCount': totalCount, 'numPerPage': numPerPage, 'currentPage': currentPage,