一.简介
- # 组合搜索
- # 技术方向:自动化,测试,运维,前端
- # 分类:Python Linux JavaScript OpenStack Node.js GO
- # 级别:初级 中级 高级 骨灰级
有4张表:
Direction(技术方向标),Classification(技术分类表),Level(难度级别表),Video(视频表)
它们的关系是:
Direction与Classification多对多关系
Video与Classification,Level是一对多关系
最终要实现的结果如下图:
二.models代码
class Direction(models.Model): """ 技术方向:自动化,测试,运维,前端 """ name = models.CharField(verbose_name='名称', max_length=32) classification = models.ManyToManyField('Classification') class Meta: # 重命名表名,不要自动添加的app名 db_table = 'Direction' verbose_name_plural = '方向(视频方向)' def __str__(self): return self.name class Classification(models.Model): """ 分类:Python Linux JavaScript OpenStack Node.js GO """ name = models.CharField(verbose_name='名称', max_length=32) class Meta: db_table = 'Classification' verbose_name_plural = '分类(视频分类)' def __str__(self): return self.name class Level(models.Model): title = models.CharField(max_length=32) class Meta: db_table = 'Level' verbose_name_plural = '难度级别' def __str__(self): return self.title class Video(models.Model): status_choice = ( (1, '下线'), (2, '上线'), ) status = models.IntegerField(verbose_name='状态', choices=status_choice, default=1) level = models.ForeignKey(Level) classification = models.ForeignKey('Classification', null=True, blank=True) weight = models.IntegerField(verbose_name='权重(按从大到小排列)', default=0) 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/') img = models.CharField(verbose_name='图片', max_length=32) href = models.CharField(verbose_name='视频地址', max_length=256) create_date = models.DateTimeField(auto_now_add=True) class Meta: db_table = 'Video' verbose_name_plural = '视频' def __str__(self): return self.title
三.url路由代码
urlpatterns=[ url(r'^admin',admin.site.urls), #利用的是有名分组的方法,分别获取不同的id url(r'^video-("htmlcode">def video(request,*args,**kwargs): condition = {} for k, v in kwargs.items(): temp = int(v) kwargs[k] = temp print(kwargs) # ("htmlcode"><!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> <style> .condition a { display: inline-block; padding: 5px 8px; border: 1px solid #dddddd; } .condition a.active { background-color: coral; color: white; } </style> </head> <body> <div class="condition"> <h1>筛选</h1> <div> {% if kwargs.direction_id == 0 %} {#反向解析#} <a href="{% url " rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" video" direction_id=0 classification_id=kwargs.classification_id level_id=kwargs.level_id %}" class="active">全部</a> {% else %} <a href="{% url " rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" video" direction_id=0 classification_id=kwargs.classification_id level_id=kwargs.level_id %}">全部</a> {% endif %} {% for item in direction_list %} {% if item.id == kwargs.direction_id %} <a href="{% url " rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" video" direction_id=item.id classification_id=kwargs.classification_id level_id=kwargs.level_id %}" class="active">{{ item.name }}</a> {% else %} <a href="{% url " rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" video" direction_id=item.id classification_id=kwargs.classification_id level_id=kwargs.level_id %}">{{ item.name }}</a> {% endif %} {% endfor %} </div> <div> {% if kwargs.classification_id == 0 %} <a href="/video-{{ kwargs.direction_id }}-0-{{ kwargs.level_id }}.html" rel="external nofollow" rel="external nofollow" class="active">全部</a> {% else %} <a href="/video-{{ kwargs.direction_id }}-0-{{ kwargs.level_id }}.html" rel="external nofollow" rel="external nofollow" >全部</a> {% endif %} {% for item in class_list %} {% if item.id == kwargs.classification_id %} <a href="/video-{{ kwargs.direction_id }}-{{ item.id }}-{{ kwargs.level_id }}.html" rel="external nofollow" rel="external nofollow" class="active">{{ item.name }}</a> {% else %} <a href="/video-{{ kwargs.direction_id }}-{{ item.id }}-{{ kwargs.level_id }}.html" rel="external nofollow" rel="external nofollow" >{{ item.name }}</a> {% endif %} {% endfor %} </div> <div> {% if kwargs.level_id == 0 %} <a href="/video-{{ kwargs.direction_id }}-{{ kwargs.classification_id }}-0.html" rel="external nofollow" rel="external nofollow" class="active">全部</a> {% else %} <a href="/video-{{ kwargs.direction_id }}-{{ kwargs.classification_id }}-0.html" rel="external nofollow" rel="external nofollow" >全部</a> {% endif %} {% for item in level_list %} {% if item.id == kwargs.level_id %} <a href="/video-{{ kwargs.direction_id }}-{{ kwargs.classification_id }}-{{ item.id }}.html" rel="external nofollow" rel="external nofollow" class="active">{{ item.title }}</a> {% else %} <a href="/video-{{ kwargs.direction_id }}-{{ kwargs.classification_id }}-{{ item.id }}.html" rel="external nofollow" rel="external nofollow" >{{ item.title }}</a> {% endif %} {% endfor %} </div> </div> <div> <h1>结果</h1> {% for row in video_list %} <div>{{ row.title }}</div> {% endfor %} </div> </body> </html>以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。
最新资源
- 群星《新说唱2024 第12期 (下)》[FLAC/分轨][50
- 李常超 (Lao乾妈)《天生江湖》[320K/MP3][168.8
- 李常超 (Lao乾妈)《天生江湖》[FLAC/分轨][633.
- 群星《雨果发烧碟二十》UPMAGCD2024[WAV+CUE]
- 刘德丽《赤的疑惑》限量1:1黄金母盘直刻[低速原
- 柏菲·珞叔作品集《金色大厅2》限量开盘母带ORMC
- Gareth.T《sad songs(Explicit)》[320K/MP3][29
- Gareth.T《sad songs(Explicit)》[FLAC/分轨][1
- 证声音乐图书馆《海风摇曳·盛夏爵士曲》[320K/M
- 龚玥《金装龚玥HQCD》头版限量[WAV分轨]