def foo_list(request):
result = None
if request.GET:
rows = None
pageNo = None
try:
rows = int(request.GET[PageUtil.JQGRID_ROWS]) # 详细显示的记录，默认对应jqGrid中配置的rowNum
except ValueError:
rows = PageUtil.PAGE_NUM
try:
pageNo = int(request.GET[PageUtil.JQGRID_PAGE])
except ValueError:
pageNo = PageUtil.PAGE_NO
sortname = str(request.GET[PageUtil.JQGRID_SORT_NAME]) # 排序字段
sortorder = str(request.GET[PageUtil.JQGRID_SORT_ORDER]) # 排序方式
if sortorder and sortorder.upper() == "DESC":
sortname = "-" + sortname
foos = Foo.objects.all().order_by(sortname)
pageHelper = PageHelper(foos, rows, pageNo)
result = pageHelper.getPaginatorJson()
return HttpResponse(result, mimetype="application/javascript")
def requirement_list(request):
"""
需求列表查询页面:
GET:进入requirement_list页面
POST:分页查询数据
"""
if request.method == "GET":
return render_to_response("admin/wc/requirement_list.html", context_instance=RequestContext(request))
else:
rows = None
pageNo = None
try:
rows = int(request.POST.get(PageUtil.JQGRID_ROWS)) # 详细显示的记录，默认对应jqGrid中配置的rowNum
except:
rows = PageUtil.PAGE_NUM
try:
pageNo = int(request.POST.get(PageUtil.JQGRID_PAGE))
except:
pageNo = PageUtil.PAGE_NO
try:
sortname = str(request.POST.get(PageUtil.JQGRID_SORT_NAME)) # 排序字段
sortorder = str(request.POST.get(PageUtil.JQGRID_SORT_ORDER)) # 排序方式
if sortorder and sortorder.upper() == "DESC":
sortname = "-" + sortname
except:
sortname = None
# 查询条件
searchDict = {}
for field in Requirement._meta.fields:
if request.POST.get(field.name):
fieldValue = request.POST.get(field.name)
if isinstance(field, DateField) or isinstance(field, DateTimeField):
fieldValue = datetime.datetime.strptime(fieldValue, "%Y-%m-%d")
searchDict[field.name + '__range'] = (
datetime.datetime.combine(fieldValue, datetime.time.min),
datetime.datetime.combine(fieldValue, datetime.time.max))
else:
searchDict[field.name + '__icontains'] = fieldValue
if sortname:
requirements = Requirement.objects.filter(**searchDict).order_by(sortname)
else:
requirements = Requirement.objects.filter(**searchDict)
pageHelper = PageHelper(requirements, rows, pageNo)
result = pageHelper.getPaginatorJson()
return HttpResponse(result, mimetype="application/javascript")