data_list.py
# -*- coding: utf-8 -*-
# Create your views here.
import time
from django.contrib.auth import authenticate, login, logout
from django.template import RequestContext,loader
from django.shortcuts import render_to_response,get_object_or_404
from django.http import HttpResponse,HttpResponseRedirect
from django.db.models import Q
from django.core.paginator import Paginator
def UnixTime(day=0, FORMAT="%Y-%m-%d %H:%M:%S"):
return time.strftime(FORMAT, time.localtime(time.time()-86400*day))
def timestamp(day=0):
t = UnixTime(day)
return int(time.mktime(time.strptime(t,'%Y-%m-%d %H:%M:%S')))
def stime_change_time(t):
return time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(float(t)))
def time_change_stime(t):
return int(time.mktime(time.strptime(t,'%Y-%m-%d %H:%M:%S')))
class AutoVivification(dict):
"""Implementation of perl's autovivification feature."""
def __getitem__(self, item):
try:
return dict.__getitem__(self, item)
except KeyError:
value = self[item] = type(self)()
return value
def keyWorld_Search(queryset, request, search_fields):
''' 根据search_fields来查询 '''
SearchKey = request.REQUEST.get('search')
outputQ = None
kwargs = {}
for t_field in search_fields:
keywords = request.REQUEST.get(t_field)
if keywords:
kwargs[t_field] = keywords
if SearchKey:
kwargz = {t_field + "__icontains": SearchKey}
outputQ = outputQ | Q(**kwargz) if outputQ else Q(**kwargz)
if len(kwargs) >= 1:
return queryset.filter( **kwargs )
elif outputQ:
return queryset.filter(outputQ).distinct()
else:
return queryset
def get_datatables_records(request, queryset, search_fields, template_name, extra_context={}):
'''
该函数实现了分页功能!
queryset 一个Sql对象
template_name 模板文件
extra_context 包含参数等信息
'''
status = request.GET.get('status', '0')
# 分组功能
member=request.GET.get("member", 'null')
if member != 'null' and member:
_ids=[]
for ids in member.split(','):
_ids.append(int(ids))
queryset=queryset.filter(id__in=_ids)
gname=request.GET.get("gname", 'null')
after_range_num = 5
bevor_range_num = 4
if status == '1':
queryset_status=queryset.filter(status__in=['1'])
elif status == '2':
queryset_status=queryset.filter(status__in=['2'])
else:
queryset_status=queryset
input_order=request.GET.get("inputOrder", 'null')
_input_order='null'
if input_order != 'null':
_order=input_order.split('|')
if _order[1] == "desc":
queryset_desc=queryset_status.order_by(_order[0])
elif _order[1] == "asc":
queryset_desc=queryset_status.order_by('-%s' % _order[0])
else:
queryset_desc=queryset_status
_input_order=_order[1]
else:
queryset_desc=queryset_status
_queryset = keyWorld_Search(queryset_desc, request, search_fields)
try:
page = int(request.GET.get("page",1))
if page < 1:
page = 1
except ValueError:
page = 1
if extra_context.has_key('pagesize'):
pagesize=extra_context['pagesize']
else:
pagesize=20
pagesize = request.GET.get('pagesize', pagesize)
paginator = Paginator(_queryset, int(pagesize))
try:
object_result = paginator.page(page)
except:
#except(EmptyPage,InvalidPage,PageNotAnInteger):
object_result = paginator.page(1)
if page >= after_range_num:
page_range = paginator.page_range[page-after_range_num:page+bevor_range_num]
else:
page_range = paginator.page_range[0:int(page)+bevor_range_num]
context = {
'object_result':object_result,
'request':request,
'gname':gname,
'queryset':_queryset,
'page_range':page_range,
'pagesize':pagesize,
'page':page,
'input_orders':_input_order,
'status':status
}
''' 附加extra_context到context '''
context.update(extra_context)
vt = loader.get_template(template_name)
return HttpResponse(vt.render(RequestContext(request,context)))
def blog_index(request, template_name):
''' 文章列表 '''
if request.user.username:
queryset = article.objects.all().order_by('-id')
else:
queryset = article.objects.filter(access=1).order_by('-id')
search_fields = ['pid__name']
_category = category.objects.exclude(pid=0)
return get_datatables_records(
request,
queryset,
search_fields,
template_name,
extra_context={
'category':_category,
'pagesize':10
})<!-- <ul class="pager"> -->
<ul class="pagination">
{% if object_result.has_previous %}
{% if search %}
<li><a href="?page={{ object_result.previous_page_number }}&pagesize={{ pagesize }}&search={{ search }}">← Previous</a> </li>
{% else %}
<li><a href="?page={{ object_result.previous_page_number }}&pagesize={{ pagesize }}">← Previous</a> </li>
{% endif %}
{% else %}
<li class="disabled"><a href="#">← Previous</a> </li>
{% endif %}
<!-- <li class="active"><a href="#">1</a></li>-->
{% for p in page_range %}
{% ifequal p object_result.number %}
<li class="active"><a href="?page={{p}}&pagesize={{ pagesize }}" title="第{{p}}页">{{p}}</a></li>
{% else %}
{% if search %}
<li><a href="?page={{p}}&pagesize={{ pagesize }}&search={{ search }}" title="第{{p}}页">{{p}}</a></li>
{% else %}
<li><a href="?page={{p}}&pagesize={{ pagesize }}" title="第{{p}}页">{{p}}</a></li>
{% endif %}
{% endifequal %}
{% endfor %}
{% if object_result.has_next %}
{% if search %}
<li><a href="?page={{ object_result.next_page_number }}&pagesize={{ pagesize }}&search={{ search }}" title="下一页">Next →</a> </li>
{% else %}
<li><a href="?page={{ object_result.next_page_number }}&pagesize={{ pagesize }}" title="下一页">Next →</a> </li>
{% endif %}
{% else %}
<li class="disabled"><a href="#" title="下一页">Next →</a> </li>
{% endif %}
</ul>
{% for node in object_result.object_list %}
{{ node.id }}
{% endfor %}
还没有评论，沙发等你来抢