Django Admin 中内联模型的分页器
我有一个简单的Django模型，里面有一个传感器和这个传感器的具体数值。每个光照计（Pyranometer）的数值非常多，超过了3万条。请问有没有办法按照特定的日期来分页显示PyranometerValues，或者在管理后台的内嵌视图中应用分页功能呢？
class Pyranometer(models.Model):
name = models.CharField(max_length=75)
class PyranometerValues(models.Model):
timestamp = models.DateTimeField()
value = models.DecimalField(max_digits=10,decimal_places=6)
sensor = models.ForeignKey('Pyranometer')
7 个回答
3
无论你用的是哪个版本的Django，请按照以下步骤操作：
- 找到这个文件：
python3.7/site-packages/django/contrib/admin/templates/admin/edit_inline/tabular.html，然后把它复制到你的app/templates/admin/edit_inline/anyname.html里。
在 anyname.html 文件中，找到 </table> 和 </fieldset> 之间的地方，添加以下内容：
<style>
.dark {
/*background-color: #417690;*/
background-color: #FFFFFF;
border: none;
color: #666;
padding: 5px 10px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 12px;
margin: 4px 2px;
cursor: pointer;
}
.light {
background-color: #008CBA;
border: none;
color: white;
padding: 5px 10px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 12px;
margin: 4px 2px;
cursor: pointer;
}
</style>
<div>
{% with inline_admin_formset.formset.page as page_obj %}
<p class="paginator">
{% if page_obj.previous_page_number > 1 %}
<a href="?page={{ page_obj.previous_page_number|add:'-1' }}">{% trans 'previous' %}</a>
{% endif %}
{% if page_obj.number|add:"-5" > 0 %}
<a href="?page=0">1</a>
{% endif %}
{% if page_obj.number|add:"-5" > 1 %}
<span>…</span>
{% endif %}
{% for page_num in page_obj.paginator.page_range %}
{% if page_obj.number == page_num %}
<span class="dark">{{ page_num|add:"-1" }}</span>
{% else %}
{% if page_num > page_obj.number|add:"-5" and page_num < page_obj.number|add:"5" %}
<a class="light" style="color:white" href="?page={{ page_num|add:'-1' }}">{{ page_num|add:"-1" }}</a>
{% endif %}
{% endif %}
{% endfor %}
{% if page_obj.number|add:"5" < page_obj.paginator.num_pages %}
<span>…</span>
{% endif %}
{% if page_obj.number|add:"4" < page_obj.paginator.num_pages %}
<a href="?page={{ page_obj.paginator.num_pages }}">{{ page_obj.paginator.num_pages }}</a>
{% endif %}
{% if page_obj.next_page_number < page_obj.paginator.num_pages|add:'1' %}
<a href="?page={{ page_obj.next_page_number|add:'-1' }}">{% trans 'next' %}</a>
{% endif %}
<span class='dark'>{{ page_obj.paginator.count }} Queries</span>
</p>
{% endwith %}
</div>
2. 接下来，打开你的 admin.py 文件：
from django.contrib.admin.views.main import ChangeList
from django.core.paginator import EmptyPage, InvalidPage, Paginator
class InlineChangeList(object):
can_show_all = True
multi_page = True
get_query_string = ChangeList.__dict__['get_query_string']
def __init__(self, request, page_num, paginator):
self.show_all = 'all' in request.GET
self.page_num = page_num
self.paginator = paginator
self.result_count = paginator.count
self.params = dict(request.GET.items())
class MyInline(admin.TabularInline):
per_page = 10
template = 'admin/edit_inline/anyname.html'
model = Mymodel
extra = 0
can_delete = False
def get_formset(self, request, obj=None, **kwargs):
formset_class = super(MyInline, self).get_formset(
request, obj, **kwargs)
class PaginationFormSet(formset_class):
def __init__(self, *args, **kwargs):
super(PaginationFormSet, self).__init__(*args, **kwargs)
qs = self.queryset
paginator = Paginator(qs, self.per_page)
try:
page_num = int(request.GET.get('page', ['0'])[0])
except ValueError:
page_num = 0
try:
page = paginator.page(page_num + 1)
except (EmptyPage, InvalidPage):
page = paginator.page(paginator.num_pages)
self.page = page
self.cl = InlineChangeList(request, page_num, paginator)
self.paginator = paginator
if self.cl.show_all:
self._queryset = qs
else:
self._queryset = page.object_list
PaginationFormSet.per_page = self.per_page
return PaginationFormSet
8
如果有人需要这个，我找到了一种不错的实现方式（虽然被称为“有点黑科技”）来做分页的 TabularInline 子类，具体可以在这个评论中看到，评论是关于django-suit 的一个问题。
对于 Django 1.6，这需要修改模板并且要继承这个 PaginationInline 类：
from django.contrib import admin
from django.contrib.admin.views.main import ChangeList
from django.core.paginator import EmptyPage, InvalidPage, Paginator
class InlineChangeList(object):
can_show_all = True
multi_page = True
get_query_string = ChangeList.__dict__['get_query_string']
def __init__(self, request, page_num, paginator):
self.show_all = 'all' in request.GET
self.page_num = page_num
self.paginator = paginator
self.result_count = paginator.count
self.params = dict(request.GET.items())
class PaginationInline(admin.TabularInline):
template = 'admin/edit_inline/tabular_paginated.html'
per_page = 20
def get_formset(self, request, obj=None, **kwargs):
formset_class = super(PaginationInline, self).get_formset(
request, obj, **kwargs)
class PaginationFormSet(formset_class):
def __init__(self, *args, **kwargs):
super(PaginationFormSet, self).__init__(*args, **kwargs)
qs = self.queryset
paginator = Paginator(qs, self.per_page)
try:
page_num = int(request.GET.get('p', '0'))
except ValueError:
page_num = 0
try:
page = paginator.page(page_num + 1)
except (EmptyPage, InvalidPage):
page = paginator.page(paginator.num_pages)
self.cl = InlineChangeList(request, page_num, paginator)
self.paginator = paginator
if self.cl.show_all:
self._queryset = qs
else:
self._queryset = page.object_list
PaginationFormSet.per_page = self.per_page
return PaginationFormSet
2
你有没有看过raw_id_fields这个属性？我觉得这个对你可能会很有帮助。