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,