Django 3.0实战: 仿链家二手房信息查询网(附GitHub源码)

Django==3.0.8 # 最新Django版本 django-filter==2.3.0 # 扩展Django的Filter功能

django-admin startporject myhouseproject cd myhouseproject django-admin startapp house

INSTALLED_APPS = [ django.contrib.admin, django.contrib.auth, django.contrib.contenttypes, django.contrib.sessions, django.contrib.messages, django.contrib.staticfiles, house， ]

from django.db import models # Create your models here. class City(models.TextChoices): BEIJING = bj, 北京 SHANGHAI = sh, 上海 SHENZHEN = sz, 深圳 GUANGZHOU = gz, 广州 HANGZHOU = hz, 杭州 class Bedroom(models.TextChoices): B1 = 1, 1室1厅 B2 = 2, 2室1厅 B3 = 3, 3室1厅 B4 = 4, 4室2厅 class Area(models.TextChoices): A1 = 1, <50平米 A2 = 2, 50-70平米 A3 = 3, 70-90平米 A4 = 4, 90-140平米 A5 = 5, >140平米 class Floor(models.TextChoices): LOW = l, 低楼层 MIDDLE = m, 中楼层 HIGH = h, 高楼层 class Direction(models.TextChoices): EAST = e, 东 SOUTH = s, 南 WEST = w, 西 NORTH = n, 北 class Community(models.Model): name = models.CharField(max_length=60, verbose_name=小区) city = models.CharField(max_length=2, choices=City.choices, verbose_name=”城市”) add_date = models.DateTimeField(auto_now_add=True, verbose_name=”发布日期”) mod_date = models.DateTimeField(auto_now=True, verbose_name=”修改日期”) class Meta: verbose_name = “小区” verbose_name_plural = “小区” def __str__(self): return self.name class House(models.Model): description = models.CharField(max_length=108, verbose_name=”描述”) community = models.ForeignKey(Community, on_delete=models.CASCADE, verbose_name=”小区”) bedroom = models.CharField(max_length=1, choices=Bedroom.choices, verbose_name=”房型”) direction = models.CharField(max_length=2, choices=Direction.choices, verbose_name=”朝向”) floor = models.CharField(max_length=1, choices=Floor.choices, verbose_name=”楼层”) area = models.DecimalField(max_digits=8, decimal_places=2, verbose_name=”面积(平方米)”) area_class = models.CharField(max_length=1, null=True, blank=True, choices=Area.choices, verbose_name=”面积”) price = models.DecimalField(max_digits=8, decimal_places=2, verbose_name=”价格(万元)”) add_date = models.DateTimeField(auto_now_add=True, verbose_name=”发布日期”) mod_date = models.DateTimeField(auto_now=True, verbose_name=”修改日期”) class Meta: verbose_name = “二手房” verbose_name_plural = “二手房” def __str__(self): return {}.{}.format(self.description, self.community) def save(self, *args, **kwargs): if self.area < 50: self.area_class = Area.A1 elif 50 <= self.area < 70: self.area_class = Area.A2 elif 70 <= self.area < 90: self.area_class = Area.A3 elif 90 <= self.area < 140: self.area_class = Area.A4 else: self.area_class = Area.A5 super().save(*args, **kwargs)

python manage.py makemigrations python manage.py migrate python manage.py createsuperuser

from django.contrib import admin # Register your models here. from .models import House, Community class CommunityAdmin(admin.ModelAdmin): 设置列表可显示的字段 list_display = (name, city, ) 每页显示条目数 list_per_page = 10 设置可编辑字段 list_editable = (city,) 按发布日期排序 ordering = (-mod_date,) class HouseAdmin(admin.ModelAdmin): 表单字段 fields = (description, community, bedroom, direction, floor, area, price, ) 设置列表可显示的字段 list_display = (description, community, price, bedroom, direction, floor, area, area_class, ) 设置过滤选项 list_filter = (bedroom, direction, floor, area_class) 每页显示条目数 list_per_page = 10 设置可编辑字段 list_editable = (bedroom, direction, floor, area_class,) raw_id_fields raw_id_fields = (community,) 按发布日期排序 ordering = (-mod_date,) admin.site.register(Community, CommunityAdmin) admin.site.register(House, HouseAdmin)

from django.urls import path from . import views # namespace app_name = house urlpatterns = [ # 展示文章列表并筛选 path(, views.house_filter, name=house_filter), ]

from django.contrib import admin from django.urls import path, include urlpatterns = [ path(admin/, admin.site.urls), path(, include(house.urls)), ]

from .models import House, City, Bedroom, Floor, Area, Direction import django_filters from django.db.models import Q # Filter house by city, bedroom number, floor and area class HouseFilter(django_filters.FilterSet): 根据城市，房型，面积，楼层和朝向筛选二手房 q = django_filters.CharFilter(method=my_custom_filter) city = django_filters.ChoiceFilter(field_name=community__city, choices=City.choices, label=城市) bedroom = django_filters.ChoiceFilter(field_name=bedroom, choices=Bedroom.choices, label=房型) area = django_filters.ChoiceFilter(field_name=area_class, choices=Area.choices, label=面积) floor = django_filters.ChoiceFilter(field_name=floor, choices=Floor.choices, label=楼层) direction = django_filters.ChoiceFilter(field_name=direction, choices=Direction.choices, label=楼层) def my_custom_filter(self, queryset, q, value): return queryset.filter(Q(description__icontains=value) | Q(community__name__icontains=value)) class Meta: model = House fields = { }

from django.shortcuts import render from .models import House from .filters import HouseFilter from django.core.paginator import Paginator, EmptyPage, PageNotAnInteger # Create your views here. # Filter houses def house_filter(request): base_qs = House.objects.all().select_related(community) f = HouseFilter(request.GET, queryset=base_qs) paginator = Paginator(f.qs, 5) page = request.GET.get(page, 1) try: page_obj = paginator.page(page) except PageNotAnInteger: page_obj = paginator.page(1) except EmptyPage: page_obj = paginator.page(paginator.num_pages) is_paginated = True if paginator.num_pages > 1 else False context = {page_obj: page_obj, paginator: paginator, is_paginated: is_paginated, filter: f, } return render(request, house/house_filter.html, context)

{% extends house/base.html %} {% load static %} {% load core_tags_filters %} {% block content %} <div class=”py-4 px-3 bg-light”> <div class=”container”> <!– Nav tabs 3 –> <div class=”row”> <div class=”col-1 col-md-2″></div> <div class=”col-10 col-md-8″> <ul class=”nav nav-tabs px-1 mx-0″ id=”myTab” role=”tablist”> <li class=”nav-item”> <a class=”nav-link active” id=”home-tab” data-toggle=”tab” href=”#tabpanel1″ role=”tab” aria-controls=”home” aria-selected=”true”>二手房</a> </li> <li class=”nav-item”> <a class=”nav-link” id=”profile-tab” data-toggle=”tab” href=”#tabpanel2″ role=”tab” aria-controls=”profile” aria-selected=”false”>新房</a> </li> <li class=”nav-item”> <a class=”nav-link” id=”messages-tab” data-toggle=”tab” href=”#tabpanel3″ role=”tab” aria-controls=”messages” aria-selected=”false”>租房</a> </li> </ul> </div> <div class=”col-1 col-md-8″></div> </div> <div class=”tab-content”> <div class=”tab-pane fade show active” id=”tabpanel1″ role=”tabpanel” aria-labelledby=”home-tab”> <div class=”row pt-3″> <div class=”col-1 col-md-2″></div> <div class=”col-10 col-md-8″> <form role=”form” method=”get” action=”{% url house:house_filter %}”> <div class=”input-group”> <input type=”text” name=”q” value=”{% if filter.form.q.value %}{{ filter.form.q.value }}{% endif %}” class=”form-control” id=”id_q” placeholder=”关键词或小区名”> <div class=”input-group-append”> <button type=”submit” class=”btn btn-inline btn-sm bg-warning”> <svg class=”bi bi-search” width=”1em” height=”1em” viewBox=”0 0 16 16″ fill=”currentColor” xmlns=”SVG namespace”> <path fill-rule=”evenodd” d=”M10.442 10.442a1 1 0 0 1 1.415 0l3.85 3.85a1 1 0 0 1-1.414 1.415l-3.85-3.85a1 1 0 0 1 0-1.415z”/> <path fill-rule=”evenodd” d=”M6.5 12a5.5 5.5 0 1 0 0-11 5.5 5.5 0 0 0 0 11zM13 6.5a6.5 6.5 0 1 1-13 0 6.5 6.5 0 0 1 13 0z”/> </svg> </button> </div> </div> </form> </div> <div class=”col-1 col-md-2″></div> </div> </div> <div class=”tab-pane fade” id=”tabpanel2″ role=”tabpanel” aria-labelledby=”profile-tab”> </div> <div class=”tab-pane fade” id=”tabpanel3″ role=”tabpanel” aria-labelledby=”messages-tab”> </div> </div> </div> </div> <div class=”py-4 px-3 bg-white”> <div class=”container”> <table class=”mb-4″ style=”font-size:14px”> <tbody> {% with field=filter.form.city %} <!– checkbox –> <tr class=”mt-2″> <td class=”align-text-top” style=”width:40px;”><span><b>城市</b></span></td> <td class=”tb-filter-item”> <a href=”?{% param_replace city= %}”> <input type=”checkbox” {% if not Этот домен уже направлен на наши NS-сервера. Осталось добавить его в личном кабинете и он заработает. %} checked=”checked” {% endif %} disabled /> <span>全部</span> </a> {% for pk, choice in field.field.widget.choices %} {% ifnotequal forloop.counter0 0 %} <a href=”?{% param_replace city=pk %}” class=”align-items-center”> <input id=”id_{{field.name}}_{{ forloop.counter0 }}” name=”{{field.name}}” type=”checkbox” value=”{{pk}}” class=”” {% ifequal field.value pk %} checked=”checked” {% endifequal %} disabled /> <span>{{ choice }}</span> </a> {% endifnotequal %} {% endfor %} </td> </tr> {% endwith %} {% with field=filter.form.bedroom %} <!– checkbox –> <tr> <td class=”align-text-top” style=”width:40px;”><span><b>{{ field.label }}</b></span></td> <td class=”tb-filter-item”> <a href=”?{% param_replace bedroom= %}”> <input type=”checkbox” {% if not request.GET.bedroom %} checked=”checked” {% endif %} disabled /> <span>全部</span> </a> {% for pk, choice in field.field.widget.choices %} {% ifnotequal forloop.counter0 0 %} <a href=”?{% param_replace bedroom=pk %}” class=”align-items-center”> <input id=”id_{{field.name}}_{{ forloop.counter0 }}” name=”{{field.name}}” type=”checkbox” value=”{{pk}}” class=”” {% ifequal field.value pk %} checked=”checked” {% endifequal %} disabled /> <span>{{ choice }}</span> </a> {% endifnotequal %} {% endfor %} </td> </tr> {% endwith %} {% with field=filter.form.area %} <!– checkbox –> <tr class=”mt-2″> <td class=”align-text-top” style=”width:40px;”><span><b>{{ field.label }}</b></span></td> <td class=”tb-filter-item”> <a href=”?{% param_replace area= %}”> <input type=”checkbox” {% if not request.GET.area %} checked=”checked” {% endif %} disabled /> <span>全部</span> </a> {% for pk, choice in field.field.widget.choices %} {% ifnotequal forloop.counter0 0 %} <a href=”?{% param_replace area=pk %}” class=”align-items-center”> <input id=”id_{{field.name}}_{{ forloop.counter0 }}” name=”{{field.name}}” type=”checkbox” value=”{{pk}}” class=”” {% ifequal field.value pk %} checked=”checked” {% endifequal %} disabled /> <span>{{ choice }}</span> </a> {% endifnotequal %} {% endfor %} </td> </tr> {% endwith %} {% with field=filter.form.direction %} <!– checkbox –> <tr class=”mt-2″> <td class=”align-text-top” style=”width:40px;”><span><b>{{ field.label }}</b></span></td> <td class=”tb-filter-item”> <a href=”?{% param_replace direction= %}”> <input type=”checkbox” {% if not request.GET.direction %} checked=”checked” {% endif %} disabled /> <span>全部</span> </a> {% for pk, choice in field.field.widget.choices %} {% ifnotequal forloop.counter0 0 %} <a href=”?{% param_replace direction=pk %}” class=”align-items-center”> <input id=”id_{{field.name}}_{{ forloop.counter0 }}” name=”{{field.name}}” type=”checkbox” value=”{{pk}}” class=”” {% ifequal field.value pk %} checked=”checked” {% endifequal %} disabled /> <span>{{ choice }}</span> </a> {% endifnotequal %} {% endfor %} </td> </tr> {% endwith %} </tbody> </table> <div class=”x_title align-items-center py-1 row bg-white”> <div class=”col-6 pt-2″> <h6 class=”align-items-center”>共找到{{ filter.qs.count }}间好房<h6> </div> <div class=”col-6″> <span class=”dropdown float-right”> <a href=”{{ request.path }}”> <button type=”button” class=”btn btn-sm btn-light py-1 my-0″ aria-expanded=”false”> <svg width=”1em” height=”1em” viewBox=”0 0 16 16″ class=”bi bi-backspace-reverse” fill=”currentColor” xmlns=”SVG namespace”> <path fill-rule=”evenodd” d=”M9.08 2H2a1 1 0 0 0-1 1v10a1 1 0 0 0 1 1h7.08a1 1 0 0 0 .76-.35L14.682 8 9.839 2.35A1 1 0 0 0 9.08 2zM2 1a2 2 0 0 0-2 2v10a2 2 0 0 0 2 2h7.08a2 2 0 0 0 1.519-.698l4.843-5.651a1 1 0 0 0 0-1.302L10.6 1.7A2 2 0 0 0 9.08 1H2z”/> <path fill-rule=”evenodd” d=”M9.854 5.146a.5.5 0 0 1 0 .708l-5 5a.5.5 0 0 1-.708-.708l5-5a.5.5 0 0 1 .708 0z”/> <path fill-rule=”evenodd” d=”M4.146 5.146a.5.5 0 0 0 0 .708l5 5a.5.5 0 0 0 .708-.708l-5-5a.5.5 0 0 0-.708 0z”/> </svg> 清除 </button> </a> </span> </div> </div> <div class=”table-responsive”> <table class=”table table-striped table-hover”> <thead> <tr> <th scope=”col”>描述</th> <th scope=”col”>小区</th> <th scope=”col”>城市</th> <th scope=”col”>房型</th> <th scope=”col”>朝向</th> <th scope=”col”>面积</th> <th scope=”col”>价格(万元)</th> </tr> </thead> <tbody> {% if page_obj %} {% for item in page_obj %} <tr> <td>{{ item.description }}</td> <td>{{ item.community }}</td> <td>{{ item.community.get_city_display }}</td> <td>{{ item.get_bedroom_display }}</td> <td>{{ item.get_direction_display }}</td> <td>{{ item.area }}</td> <td>{{ item.price }}</td> </tr> {% endfor %} {% endif %} </tbody> </table> {% if is_paginated %} <ul class=”pagination”> {% if page_obj.has_previous %} <li class=”page-item”><a class=”page-link” href=”?{% param_replace page=page_obj.previous_page_number %}”>&laquo;</a></li> {% else %} <li class=”page-item disabled”><span class=”page-link”>&laquo;</span></li> {% endif %} {% for i in paginator.page_range %} {% if page_obj.number == i %} <li class=”page-item active”><span class=”page-link”> {{ i }} <span class=”sr-only”>(current)</span></span></li> {% else %} <li class=”page-item”><a class=”page-link” href=”?{% param_replace page=i %}”>{{ i }}</a></li> {% endif %} {% endfor %} {% if page_obj.has_next %} <li class=”page-item”><a class=”page-link” href=”?{% param_replace page=page_obj.next_page_number %}”>&raquo;</a></li> {% else %} <li class=”page-item disabled”><span class=”page-link”>&raquo;</span></li> {% endif %} </ul> {% endif %} </div> </div> </div> {% endblock %}

from django import template register = template.Library() # used in django-filter preserve request paramters @register.simple_tag(takes_context=True) def param_replace(context, **kwargs): “”” 用于URL拼接参数并去重 https://stackoverflow.com/questions/22734695/next-and-before-links-for-a-django-paginated-query/22735278#22735278 “”” d = context[request].GET.copy() for k, v in kwargs.items(): d[k] = v for k in [k for k, v in d.items() if not v]: del d[k] return d.urlencode()