django-尊龙凯时

import django_filters
#这个q可以支持表查询，单下划线获取表字段，双下划线获取关联表，
from django.db.models import q
#引入自己的模型
from app.item.models import itemcategory
#自定义的过滤类，需要继承django_filter.rest_framework中的filterset类
class itemcategoryfilter(django_filters.rest_framework.filterset):
  filter_category = django_filters.numberfilter(method='category_filter', label='filter_category')
  #django_filters.numberfilter类似，modelform中字段类型的控制
  #其中method指向自己定义的过滤函数，label用于标识在测试api界面中的过滤界面字段，filter_category控制查询字段
  def category_filter(self, queryset, name, value):
    #这里用到多级联表查询
    return queryset.filter(q(category_id=value)|q(category__parent_id=value)|q(category__parent__parent_id=value)|q(category__parent__parent__parent_id=value))
  class meta:
    model = itemcategory
    fields = []

class itemslistbycategory(generics.listcreateapiview):
  '''
    根据category编号获取相关模型no。
    请求中请带有参数category
    @:require param: category
    such as: get /itemslistbycategory/?filter_category=2
  '''
  from django_filters.rest_framework import djangofilterbackend
  from app.item.filters import itemcategoryfilter
  queryset = itemcategory.objects.all()
  serializer_class = itemcategoryserializer
  pagination_class = commonpagination
  # 在这里哦
  filter_backends = (djangofilterbackend,)
  filter_class =itemcategoryfilter
  permission_classes = (readonly,)

class alertfilter(django_filters.rest_framework.filterset):
  
   .......
  to_bearer_service = django_filters.rest_framework.charfilter(method='to_bearer_service_filter', label='bearer_service')
  class meta:
    model = alert
    fields = [......, 'to_bearer_service']
  @staticmethod  # 如果想获取请求信息可以去掉这个静态方法的装饰器，为什么要加静态方法装饰器我也不清楚
  def to_bearer_service_filter(queryset, name, value):
    q_id = q()
    for i in value.split(","):
      if i == "0":
        q_id.add(q(**{'to_bearer_service':none}), q.or)
      else:
        q_id.add(q(**{'to_bearer_service_id': int(i)}), q.or)
    queryset = queryset.filter(q_id)
    return queryset
 
 
  def to_bearer_service_filter(self, queryset, name, value):
    q_id = q()
    for i in value.split(","):
      if i == "0":
        q_id.add(q(**{'to_bearer_service':none}), q.or)
      else:
        q_id.add(q(**{'to_bearer_service_id': int(i)}), q.or)
    queryset = queryset.filter(q_id)
    return queryset