Django模版语言自定义标签-实现前端关联组合过滤查询-白红宇

Django模版语言自定义标签-实现前端关联组合过滤查询

阅读量：6295 次

发布时间：2019-06-22

本文共 6046 字，大约阅读时间需要 20 分钟。

前端关联组合过滤查询

实现效果如图：

models.py 创建表代码

from django.db import models# Create your models here.class Level(models.Model):    name = models.CharField(max_length=32)    def __str__(self):        return self.name# 方向class Direction(models.Model):    name = models.CharField(max_length=32)    d_2_c = models.ManyToManyField('Category')    def __str__(self):        return self.name# 类型class Category(models.Model):    name = models.CharField(max_length=32)    def __str__(self):        return self.name# #反向# models.Category.objects.filter(Direction__id =id)# # 正向# models.Direction.objects.filter(id = id).d_2_c.all()class Video(models.Model):    lv = models.ForeignKey(Level)    cg = models.ForeignKey(Category)    title = models.CharField(verbose_name='标题', max_length=32)    summary = models.CharField(verbose_name='简介', max_length=32)    img = models.ImageField(verbose_name='图片', upload_to='./static/images/Video/')    href = models.CharField(verbose_name='视频地址', max_length=256)    create_date = models.DateTimeField(auto_now_add=True)    def __str__(self):        return self.title

urls.py路由分发代码

from django.conf.urls import urlfrom django.contrib import adminfrom app01 import viewsurlpatterns = [    url(r'^admin/', admin.site.urls),    url(r'^video-(?P
    
     \d+)-(?P
     
      \d+)-(?P
      
       \d+).html',views.video,name='vvv2'),]

views.py视图函数代码

from django.shortcuts import renderfrom app01 import models# Create your views here.def video(request,*args,**kwargs):    # 0-0-0.html    # 0-1-0.html    # 1-0-0.html    # 1-1-0.html [1,2,3,4]    # 2-1-0.html [2,3,4]    dr_id = kwargs.get('dr_id')    cg_id = kwargs.get('cg_id')    lv_id = kwargs.get('lv_id')    condition = {}    drection_list = models.Direction.objects.all()    level_list = models.Level.objects.all()    if dr_id == "0":        # 未选择方向        category_list = models.Category.objects.all()        if cg_id == '0':            # 未选择分类            pass        else:            # 选择分类            # models.Video.objects.filter(cg_id=cg_id)            condition['cg_id'] = cg_id    else:        # 选择了方向        category_list = models.Category.objects.filter(direction=dr_id)        temp = category_list.values_list('id')        cg_id_list = list(zip(*temp))[0]        if cg_id == '0':            # 未选择分类            condition['cg_id__in'] = cg_id_list        else:            # 选择了分类            if int(cg_id) in cg_id_list:                condition['cg_id'] = cg_id            else:                condition['cg_id__in'] = cg_id_list                kwargs['cg_id'] = '0'    if lv_id == '0':        pass    else:        condition['lv_id'] = lv_id    result = models.Video.objects.filter(**condition)    print(result)    return render(request, 'video.html', {        'drection_list': drection_list,        'level_list': level_list,        'category_list': category_list,        'arg_dict': kwargs,        'result':result,    })

自定义标签 templatetags xx.py代码

#!/usr/bin/env python# -*- coding: utf-8 -*-# @Date    : 2017/2/6# @Author  : Jesson # @Blog    : http://www.cnblogs.com/hellojesson/#from django import templatefrom django.utils.safestring import mark_saferegister = template.Library()# 方向@register.simple_tagdef dr_tag(obj,arg_dict):    """    生成A标签    :param obj:    :param arg_dict:    :return:    """    from django.urls import reverse    url = reverse('vvv2', kwargs={'dr_id': obj.id, 'cg_id': arg_dict.get('cg_id'), 'lv_id': arg_dict.get('lv_id')})    if str(obj.id) == arg_dict.get('dr_id'):        # 获取当前URL        tag = "" %(url,obj.name)        return mark_safe(tag)    else:        tag = "" % (url, obj.name)        return mark_safe(tag)# 类别@register.simple_tagdef cg_tag(obj,arg_dict):    from django.urls import reverse    url = reverse('vvv2', kwargs={'dr_id': arg_dict.get('dr_id'), 'cg_id': obj.id, 'lv_id': arg_dict.get('lv_id')})    if str(obj.id) == arg_dict.get('cg_id'):        # 获取当前URL        tag = "" %(url,obj.name)        return mark_safe(tag)    else:        tag = "" % (url, obj.name)        return mark_safe(tag)# 难度级别@register.simple_tagdef lv_tag(obj,arg_dict):    from django.urls import reverse    url = reverse('vvv2', kwargs={'dr_id': arg_dict.get('dr_id'), 'cg_id': arg_dict.get('cg_id'), 'lv_id': obj.id})    if str(obj.id) == arg_dict.get('lv_id'):        # 获取当前URL        tag = "" %(url,obj.name)        return mark_safe(tag)    else:        tag = "" % (url, obj.name)        return mark_safe(tag)# 全部显示@register.simple_tagdef total_tag_2(arg_dict,key):    from django.urls import reverse    if key == 'dr_id':        url = reverse('vvv2', kwargs={'dr_id': 0, 'cg_id': arg_dict.get('cg_id'), 'lv_id': arg_dict.get('lv_id')})    elif key == 'cg_id':        url = reverse('vvv2', kwargs={'dr_id': arg_dict.get('dr_id'), 'cg_id': 0, 'lv_id': arg_dict.get('lv_id')})    elif key == 'lv_id':        url = reverse('vvv2', kwargs={'dr_id': arg_dict.get('dr_id'), 'cg_id': arg_dict.get('cg_id'), 'lv_id': 0})    else:        url = ''    if arg_dict.get(key) == '0':        tag = "" % (url,)    else:        tag = "" % (url,)    return mark_safe(tag)

前端video.html 代码

{% load xx %}    
        Title        筛选条件
    
            
                 
      方向：            {% total_tag_2 arg_dict 'dr_id' %}            {% for item in drection_list %}                
                      {% dr_tag item arg_dict %}            {% endfor %}        
     
        
                 
      分类：            {% total_tag_2 arg_dict 'cg_id' %}            {% for item in category_list %}                {% cg_tag item arg_dict %}            {% endfor %}        
     
        
                 
      难度：            {% total_tag_2 arg_dict 'lv_id' %}            {% for item in level_list %}                {% lv_tag item arg_dict %}            {% endfor %}        
     
    
    
    查询结果
    
    
             {% for row in result %}            
                     
                      
      {
   { row.title }}
                
      {
   { row.summary }}
            
     
        {% endfor %}