Question

I set up 2 models Article and Taxonomy. Taxonomy is an MPTTModel Subclass.

除一件事外,所有工作都受到罚款: 如果我选择一个没有相关条款的母子的话,就不会展示与儿童节点相关的文章。

因此,我正试图将我的习俗过滤器编码,但我却坐在盘点过滤器上。我如何过滤这一问询,以显示与儿童相关的所有文章。

class TaxonomyFilter(SimpleListFilter):
    """
    Return incremented taxonomy list. Filtering by parent node display all children.
    """
    title = ( Index )
    parameter_name =  node_id 

    def lookups(self, request, model_admin):
        taxos = Taxonomy.objects.all()
        leafs = []
        for taxo in taxos:
            leafs.append((taxo.id,(taxo.name)))

        return leafs


    def queryset(self,request,queryset):
        """
        Filter list by displaying children if parent node has any.
        """
        if self.value():
            return queryset.filter()  
        else:
            return queryset

Answer 1

Juli: 这在水平上下了两点,但问题不及解决(而不是3)的问题。

def queryset(self, request, queryset):
    """
    Filter list by displaying children if parent node has any.
    """
    t = Taxonomy.objects.get(pk=self.value())

    return queryset.filter(taxonomy__lft__gte=t.lft, taxonomy__rght__lte=t.rght)

Answer 2

不能确定回答我们自己的问题,但对于在此面临同样问题的任何人来说,“工作证据,而不是子弹证据”是 s。

    def queryset(self,request,queryset):
    """
    Filter list by displaying children if parent node has any.
    """
    descendants = Taxonomy.objects.get(pk=self.value()).get_descendants(include_self=True)

    descendant_list = []
    for descendant in descendants:
        descendant_list.append(descendant.id)

    return queryset.filter(taxonomy__in=descendant_list)

Answer 3

With django-mptt there are some cases where the query as described by craigds might not work, as the left and right leaf attributes are not unique in any way. To avoid false matches you can use the tree_id field that comes with django-mptt:

t = Taxonomy.objects.get(pk=self.value())

return queryset.filter(
    taxonomy__tree_id=t.tree_id,
    taxonomy__lft__gte=t.lft,
    taxonomy__rght__lte=t.rght
)

友情链接