组合搜索
没有多对多的情况
1 <!DOCTYPE html> 2 <html lang="en"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>学习视频列表</title> 6 <style> 7 .dd a{ 8 display: inline-block; 9 padding: 5px 8px; 10 margin: 0 2px; 11 border: solid 1px; 12 } 13 .dd a.active{ 14 background-color: antiquewhite; 15 color: white; 16 } 17 </style> 18 </head> 19 <body> 20 <div> 21 <h4>筛选条件</h4> 22 <div class="dd"> 23 <div> 24 {% if kw.vclass_id == 0 %} 25 <a class="active" href="/video/study-0-{{ kw.vl_id }}-{{ kw.status }}/">全部</a> 26 {% else %} 27 <a href="/video/study-0-{{ kw.vl_id }}-{{ kw.status }}/">全部</a> 28 {% endif %} 29 30 {% for foo in class_list %} 31 {% if foo.id == kw.vclass_id %} 32 33 <a class="active" href="/video/study-{{ foo.id }}-{{ kw.vl_id }}-{{ kw.status }}/">{{ foo.name }}</a> 34 {% else %} 35 36 <a href="/video/study-{{ foo.id }}-{{ kw.vl_id }}-{{ kw.status }}/">{{ foo.name }}</a> 37 {% endif %} 38 39 {% endfor %} 40 </div> 41 <br> 42 <div> 43 {% if kw.vl_id == 0 %} 44 <a class="active" href="/video/study-{{ kw.vclass_id }}-0-{{ kw.status }}/">全部</a> 45 {% else %} 46 <a href="/video/study-{{ kw.vclass_id }}-0-{{ kw.status }}/">全部</a> 47 {% endif %} 48 49 {% for level in level_list %} 50 {% if level.id == kw.vl_id %} 51 <a class="active" href="/video/study-{{ kw.vclass_id }}-{{ level.id }}-{{ kw.status }}/">{{ level.name }}</a> 52 {% else %} 53 <a href="/video/study-{{ kw.vclass_id }}-{{ level.id }}-{{ kw.status }}/">{{ level.name }}</a> 54 {% endif %} 55 56 {% endfor %} 57 58 </div> 59 <br> 60 <div> 61 {% if kw.status == 0 %} 62 <a class="active" href="/video/study-{{ kw.vclass_id }}-{{ kw.vl_id }}-0/">全部</a> 63 {% else %} 64 <a href="/video/study-{{ kw.vclass_id }}-{{ kw.vl_id }}-0/">全部</a> 65 {% endif %} 66 67 {% for status in status_dict %} 68 {% if status.id == kw.status %} 69 <a class="active" href="/video/study-{{ kw.vclass_id }}-{{ kw.vl_id }}-{{ status.id }}/">{{ status.name }}</a> 70 {% else %} 71 <a href="/video/study-{{ kw.vclass_id }}-{{ kw.vl_id }}-{{ status.id }}/">{{ status.name }}</a> 72 {% endif %} 73 74 {% endfor %} 75 76 </div> 77 </div> 78 </div> 79 <div> 80 <h4>筛选结果</h4> 81 {% for video in video_list %} 82 <li>{{ video.name }}</li> 83 {% endfor %} 84 85 </div> 86 </body> 87 </html>
1 from django.shortcuts import render,HttpResponse,redirect 2 from django.views import View 3 from app01 import models 4 class Study(View): 5 def get(self,request,*args,**kwargs): 6 # print('aaaaaa',args) 7 # print('kkkk',kwargs) 8 condition_dict={} 9 for k,v in kwargs.items(): 10 kwargs[k]=int(v) 11 #过滤筛选条件 12 if int(v): 13 condition_dict[k]=int(v) 14 print(condition_dict) 15 class_list=models.Classfication.objects.all() 16 level_list=models.Level.objects.all() 17 status_list=models.Video.status_choice 18 status_dict=map(lambda x:{'id':x[0],'name':x[1]},status_list) 19 video_list=models.Video.objects.filter(**condition_dict) 20 return render(request,'study/get_list_study.html',{'class_list':class_list,'level_list':level_list,'kw':kwargs,'status_dict':status_dict,'video_list':video_list})
1 from app01.views.study import Study 2 from django.urls import path,include 3 4 urlpatterns = [ 5 path('study-<int:vclass_id>-<int:vl_id>-<int:status>/',Study.as_view()), 6 ]
有一个多对多的情况
1 <!DOCTYPE html> 2 <html lang="en"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>学习视频列表</title> 6 <style> 7 .dd a{ 8 display: inline-block; 9 padding: 5px 8px; 10 margin: 0 2px; 11 border: solid 1px; 12 } 13 .dd a.active{ 14 background-color: antiquewhite; 15 color: white; 16 } 17 </style> 18 </head> 19 <body> 20 <div> 21 <h4>筛选条件</h4> 22 <div class="dd"> 23 <div> 24 {% if kwargs.dir_id == 0 %} 25 <a class="active" href="/video/sm-0-{{ kwargs.vclass_id }}-{{ kwargs.status }}/">全部</a> 26 {% else %} 27 <a href="/video/sm-0-{{ kwargs.vclass_id }}-{{ kwargs.status }}/">全部</a> 28 {% endif %} 29 {% for foo in direct_list %} 30 {% if foo.id == kwargs.dir_id %} 31 <a class="active" href="/video/sm-{{ foo.id }}-{{ kwargs.vclass_id }}-{{ kwargs.status }}/">{{ foo.name }}</a> 32 {% else %} 33 <a href="/video/sm-{{ foo.id }}-{{ kwargs.vclass_id }}-{{ kwargs.status }}/">{{ foo.name }}</a> 34 {% endif %} 35 {% endfor %} 36 37 </div> 38 <br> 39 <div> 40 {% if kwargs.vclass_id == 0 %} 41 <a class="active" href="/video/sm-{{ kwargs.dir_id }}-0-{{ kwargs.status }}/">全部</a> 42 {% else %} 43 <a href="/video/sm-{{ kwargs.dir_id }}-0-{{ kwargs.status }}/">全部</a> 44 {% endif %} 45 {% for class in class_list %} 46 {% if class.id == kwargs.vclass_id %} 47 <a class="active" href="/video/sm-{{ kwargs.dir_id }}-{{ class.id }}-{{ kwargs.status }}">{{ class.name }}</a> 48 {% else %} 49 <a href="/video/sm-{{ kwargs.dir_id }}-{{ class.id }}-{{ kwargs.status }}">{{ class.name }}</a> 50 {% endif %} 51 52 {% endfor %} 53 54 </div> 55 <br> 56 <div> 57 {% if kwargs.status == 0 %} 58 <a class="active" href="/video/sm-{{ kwargs.dir_id }}-{{ kwargs.vclass_id }}-0/">全部</a> 59 {% else %} 60 <a href="/video/sm-{{ kwargs.dir_id }}-{{ kwargs.vclass_id }}-0/">全部</a> 61 {% endif %} 62 {% for status in status_list %} 63 {% if status.id == kwargs.status %} 64 <a class="active" href="/video/sm-{{ kwargs.dir_id }}-{{ kwargs.vclass_id }}-{{ status.id }}">{{ status.name }}</a> 65 {% else %} 66 <a href="/video/sm-{{ kwargs.dir_id }}-{{ kwargs.vclass_id }}-{{ status.id }}">{{ status.name }}</a> 67 {% endif %} 68 69 {% endfor %} 70 71 </div> 72 </div> 73 </div> 74 <div> 75 {% for video in video_list %} 76 <li>{{ video.name }}</li> 77 {% endfor %} 78 79 </div> 80 </body> 81 </html>
1 from django.shortcuts import render,HttpResponse,redirect 2 from django.views import View 3 from app01 import models 4 class Study(View): 5 def get(self,request,*args,**kwargs): 6 # print('aaaaaa',args) 7 # print('kkkk',kwargs) 8 condition_dict={} 9 for k,v in kwargs.items(): 10 kwargs[k]=int(v) 11 #过滤筛选条件 12 if int(v): 13 condition_dict[k]=int(v) 14 print(condition_dict) 15 class_list=models.Classfication.objects.all() 16 level_list=models.Level.objects.all() 17 status_list=models.Video.status_choice 18 status_dict=map(lambda x:{'id':x[0],'name':x[1]},status_list) 19 video_list=models.Video.objects.filter(**condition_dict) 20 return render(request,'study/get_list_study.html',{'class_list':class_list,'level_list':level_list,'kw':kwargs,'status_dict':status_dict,'video_list':video_list}) 21 22 class StudyMulity(View): 23 def get(self,request,*args,**kwargs): 24 #获取参数, 25 dir_id = int(kwargs['dir_id']) 26 vclass_id=int(kwargs['vclass_id']) 27 status=int(kwargs['status']) 28 #条件字典 29 condiction={} 30 #检索 方向 列表 31 direct_list = models.Direction.objects.all() 32 #构建video 的查询条件 33 if dir_id==0: 34 ##检索 分类 列表 35 class_list=models.Classfication.objects.all() 36 if vclass_id==0: 37 pass 38 else: 39 condiction['vclass_id']=vclass_id 40 else: 41 direct_obj=models.Direction.objects.filter(id=dir_id).first() 42 #检索分类列表 43 class_list=direct_obj.cla.all() 44 class_id=direct_obj.cla.all().values_list('id') 45 class_id_list=list(zip(*class_id))[0] if class_id else [] 46 if vclass_id==0: 47 condiction['vclass_id__in']=class_id_list 48 else: 49 if vclass_id in class_id_list: 50 condiction['vclass_id']=vclass_id 51 else: 52 #kwargs 中的 vclass_id 不在 direct 方向的 条件检索类表中 置为 0 53 kwargs['vclass_id']=0 54 condiction['vclass_id__in'] = class_id_list 55 if status==0: 56 pass 57 else: 58 condiction['status']=status 59 # 检索 上线状态 列表 60 status_list=map(lambda x:{'id':x[0],'name':x[1]},models.Video.status_choice) 61 video_list=models.Video.objects.filter(**condiction) 62 return render(request,'study/get_list_multy_study.html',{'direct_list':direct_list,'class_list':class_list,'status_list':status_list,'video_list':video_list,'kwargs':kwargs})
1 from app01.views.study import Study,StudyMulity 2 from django.urls import path,include 3 4 urlpatterns = [ 5 path('study-<int:vclass_id>-<int:vl_id>-<int:status>/',Study.as_view()), 6 path('sm-<int:dir_id>-<int:vclass_id>-<int:status>/',StudyMulity.as_view()), 7 ]
1 from django.db import models 2 3 # Create your models here. 4 class Level(models.Model): 5 ''' 6 难度等级表 7 ''' 8 name=models.CharField(max_length=32,verbose_name='难度级别') 9 class Meta: 10 verbose_name_plural='难度' 11 db_table='Level' 12 def __str__(self): 13 return self.name 14 class Classfication(models.Model): 15 ''' 16 视频类比表 17 ''' 18 name=models.CharField(max_length=32,verbose_name='视频类别') 19 dir=models.ManyToManyField(to='Direction',related_name='cla') 20 class Meta: 21 verbose_name_plural='视频类别' 22 db_table='Classfication' 23 def __str__(self): 24 return self.name 25 class Direction(models.Model): 26 ''' 27 视频方向表 28 ''' 29 name=models.CharField(max_length=32,verbose_name='视频方向') 30 class Meta: 31 verbose_name_plural='视频方向' 32 db_table='Direction' 33 def __str__(self): 34 return self.name 35 class Video(models.Model): 36 status_choice=( 37 (1,'下线'), 38 (2,'上线') 39 ) 40 status=models.IntegerField(choices=status_choice,default=1,verbose_name='上线状态') 41 name=models.CharField(max_length=32,verbose_name='视频名称') 42 vl=models.ForeignKey(to='Level',related_name='vi',on_delete=True) 43 vimg=models.CharField(max_length=64,verbose_name='图片') 44 vhttp=models.CharField(max_length=256,verbose_name='视频地址') 45 vclass=models.ForeignKey(to='Classfication',related_name='cv',blank=True,null=True,on_delete=True) 46 weight=models.IntegerField(default=0,verbose_name='权重(按从大到小排列)') 47 summary=models.CharField(max_length=256,blank=True,null=True,verbose_name='视频介绍') 48 create_time=models.DateTimeField(auto_now_add=True) 49 50 class Meta: 51 verbose_name_plural='视频表' 52 db_table='Video' 53 def __str__(self): 54 return self.name
瀑布流
1 <!DOCTYPE html> 2 <html lang="en"> 3 <head> 4 <meta charset="UTF-8"> 5 <title>美女图片</title> 6 <style> 7 .img-body{ 8 width:1500px; 9 margin: 0 auto; 10 } 11 .item{ 12 float: left; 13 width: 25%; 14 15 } 16 .item img{ 17 width: 100%; 18 } 19 </style> 20 </head> 21 <body> 22 <div class="img-body"> 23 <div class="item"></div> 24 <div class="item"></div> 25 <div class="item"></div> 26 <div class="item"></div> 27 </div> 28 <script src="/static/js/jquery-3.1.1.js"></script> 29 <script> 30 $(function () { 31 var obj = new ScrollImg(); 32 obj.fetchImg(); 33 obj.scrollEvent(); 34 35 }); 36 function ScrollImg() { 37 this.NID = 0; 38 this.LASTPOSITION = -1; 39 this.fetchImg = function () { 40 var that = this; 41 $.ajax({ 42 url: '/video/img/', 43 type: 'post', 44 data: {nid: that.NID}, 45 dataType: 'JSON', 46 success: function (arg) { 47 var img_list = arg.data; 48 $.each(img_list, function (index, v) { 49 var eqv = (index + that.LASTPOSITION + 1) % 4; 50 console.log(eqv); 51 var tag = document.createElement('img'); 52 tag.src = '/' + v.src; 53 $('.img-body').children().eq(eqv).append(tag); 54 if (index + 1 == img_list.length) { 55 that.LASTPOSITION = eqv; 56 //that.NID = v.id; 57 } 58 }) 59 60 } 61 62 }) 63 }; 64 this.scrollEvent = function () { 65 var that = this; 66 $(window).scroll(function () { 67 68 var scrollTop = $(window).scrollTop(); 69 var winHeight = $(window).height(); 70 var docHeight = $(document).height(); 71 if (scrollTop + 10+winHeight >= docHeight) { 72 that.fetchImg(); 73 } 74 }) 75 } 76 77 } 78 79 </script> 80 </body> 81 </html>
1 from django.shortcuts import render,HttpResponse,redirect 2 from django.views import View 3 from app01 import models 4 import json 5 class MyImg(View): 6 def get(self,request): 7 return render(request,'study/get_img.html') 8 def post(self,request): 9 img_list=list(models.Img.objects.values('id','src','name')) 10 response_dict={'status':True,'data':img_list} 11 return HttpResponse(json.dumps(response_dict))
1 from django.db import models 2 class Img(models.Model): 3 src=models.ImageField(upload_to='static/img/',verbose_name='图片地址') 4 name=models.CharField(max_length=32,verbose_name='图片名') 5 title=models.CharField(max_length=255,verbose_name='简介') 6 class Meta: 7 verbose_name_plural='图片' 8 db_table='Img' 9 def __str__(self): 10 return self.name