在Djang中进行多字段搜索

2024-03-28 09:32:33 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试创建一个搜索页面,该页面使用与不同数据段对应的三个字段来搜索模型对象。下面是我的代码:

在模型.py在

class Schedules(models.Model):
    course_name = models.CharField(max_length=128, choices=COURSE_NAME_CHOICES, default='a-plus')
    start_date = models.DateField(auto_now=False, auto_now_add=False, default=datetime.date.today)
    instructor = models.CharField(max_length=128, choices=INSTRUCTOR_CHOICES, default='adewale')

在视图.py在

^{pr2}$

搜索_日程表.html在

{% block main_content %}
    <form method="post" action="">
        {% csrf_token %}
        <label for="course_name_search">Course Name:</label>
        <input type="text" name="course_name_search" id="course_name_search">

        <label for="start_date_search">Start Date:</label>
        <input type="datetime" name="start_date_search" id="start_date_search">

        <label for="instructor_search">Instructor:</label>
        <input type="text" name="instructor_search" id="instructor_search"><br>
        <input type="submit" name="submit">
    </form>
    <div id="result_panel">
        {% if table %}
            {% render_table table %}
        {% else %}
            {% if no_results %}
                No results returned for <q>{{ no_results }}</q>
            {% else %}
                Please enter a search
            {% endif %}
        {% endif %}
{% endblock %}

由于某些原因,如果我在“课程名称”字段或“讲师”字段中键入,则搜索将有效,但如果我键入多个字段,则搜索将不起作用。由于某些原因,无论我如何键入日期,“开始日期”字段都不会起作用。有人能帮我正确地键入代码吗?谢谢您。在


Tags: nameiddefaultforinputsearchdate键入
2条回答

您可以尝试向下搜索筛选方法,以最小化if语句:

course_name_search = request.POST.get('course_name_search', None)
start_date_search = request.POST.get('start_date_search', None)
instructor_search = request.POST.get('instructor_search', None)

queryset = Schedules.objects.all()

if course_name_search:
    queryset = queryset.filter(course_name__icontains=course_name_search)
if start_date_search:
    queryset = queryset.filter(start_date=start_date_search)
if instructor_search:
    queryset = queryset.filter(instructor__icontains=instructor_search)

# if none of the search params were filled in then return none
if not course_name_search and not start_date_search and not instructor_search:
    queryset = Schedules.objects.none()

但是这里有一些警告,以及一些帮助您解决开始日期问题的方法,因为您是直接读取POST数据,所以在查询之前,您需要将您的start_date_搜索转换为实际日期。在

另一件对你有帮助的事情是最好使用GET而不是POST,然后你可以在模板中读取它来填充你现在填充到“no_results”中的所选值。在

如果有用的话试试这个。在

def search_Schedule(request):
context_dict = {}
if request.method == 'POST':
    query1 = request.POST.get('course_name_search',None)
    query2 = request.POST.get('start_date_search',None)
    query3 = request.POST.get('instructor_search',None)
    if query1:
        results = Schedules.objects.filter(course_name__icontains=query1)
        if query2:
            results = results.filter(start_time=datetime.datetime.strptime(query2, "%d%m%Y").date())
            if query3:
                results = results.filter(instructor__icontains=query3)
                table = ScheduleTable(results)
                if results.count():
                    context_dict['table'] = table
                else:
                    context_dict['no_results'] = query1 + ", " + query2 + ", and " + query3
            else:
                table = ScheduleTable(results)
                if results.count():
                    context_dict['table'] = table
                else:
                    context_dict['no_results'] = query1 + " and " + query2
        elif query3:
            results = results.filter(instructor__icontains=query3)   #changed this filter condition
            table = ScheduleTable(results)
            if results.count():
                context_dict['table'] = table
            else:
                context_dict['no_results'] = query1 + " and " + query3
        else:
            table = ScheduleTable(results)
            if results.count():
                context_dict['table'] = table
            else:
                context_dict['no_results'] = query1
    elif query2:
        results = Schedules.objects.filter(start_time=datetime.datetime.strptime(query2, "%d%m%Y").date())
        if query3:
            results = results.filter(instructor__icontains=query3)
            table = ScheduleTable(results)
            if results.count():
                context_dict['table'] = table
            else:
                context_dict['no_results'] = query2 + " and " + query3
        else:
            table = ScheduleTable(results)
            if results.count():
                context_dict['table'] = table
            else:
                context_dict['no_results'] = query2
    elif query3:
        results = Schedules.objects.filter(instructor__icontains=query3)
        table = ScheduleTable(results)
        if results.count():
            context_dict['table'] = table
        else:
            context_dict['no_results'] = query3
return render(request, "schedule/search_schedule.html", context_dict)

相关问题 更多 >