【CRM客户关系管理】13.为结果添加搜索功能，搜索后能对其进行过滤

### 搜索功能  #### 视图中创建搜索函数 在djadmin应用下的视图中创建`get_search_result(request, queryset, admin_class)`函数 ```python def get_search_result(request, queryset, admin_class): """搜索""" keyword = request.GET.get('_kw', '') if keyword: from django.db.models import Q q = Q() q.connector = 'OR' for search_field in admin_class.search_fields: q.children.append(("{}__contains".format(search_field), keyword)) print(q) # (OR: contact__contains, consultant__name__contains) queryset = queryset.filter(q) return queryset, keyword ``` #### 详情视图中增加搜索函数 ```python @login_required def table_detail(request, app_name, model_name): """取出指定model里的数据返回到前端""" # 拿到admin_class后，通过它获取model admin_class = site.enable_admins[app_name][model_name] # print(admin_class) # 执行djadmin.py定义的注册模型类 queryset = admin_class.model.objects.all() # print(queryset) # 进行过滤 queryset, filter_conditions = get_filter_result(request, queryset) # 将过滤字典保存到全局注册类中 admin_class.filter_conditions = filter_conditions # 搜索 queryset, keyword = get_search_result(request, queryset, admin_class) admin_class.search_keyword = keyword # 将搜索字符串保存到全局类中 # 排序，返回排序的结果和排序的字段字典 queryset, current_order_field = get_order_result(request, queryset, admin_class) # print(current_order_field) # {'consult_content': '4'} # 如果有排序，保存排序的值，用于模板中在分页模块显示 if current_order_field.values(): current_order_value = list(current_order_field.values())[0] else: current_order_value = '' # 查询集结果分页 paginator = Paginator(queryset, 10) # Show 10 contacts per page page = request.GET.get('page') try: queryset = paginator.get_page(page) except PageNotAnInteger: queryset = paginator.get_page(1) except EmptyPage: queryset = paginator.get_page(paginator.num_pages) return render(request, 'djadmin/table_detail.html', locals()) ``` #### 模板中的搜索框 在djadmin应用下的templates/djadmin/base.html修改搜索框参数 ```html <form class="navbar-form navbar-right"> <input name="_kw" type="text" class="form-control" placeholder="Search..." value="{{ keyword }}"> </form> ```  当用户搜索后会根据注册模型中的`search_fields`列表进行搜索，然后返回搜索后的结果，并把关键字显示在搜索框中 ### 过滤和搜索组合 #### 搜索过滤后的结果 直接修改base.html模板，在搜索的表单中增加过滤的隐藏表单 ```html <form class="navbar-form navbar-right"> <input name="_kw" type="text" class="form-control" placeholder="Search..." value="{{ keyword }}"> {% for k, v in admin_class.filter_conditions.items %} <input type="hidden" name="{{ k }}" value="{{ v }}"> {% endfor %} </form> ```   ### 增加过滤字段提示 修改模板标签`build_option_filter(filter_field, admin_class)`过滤表单部分，增加`<label>{}：</label>`标签 ```python @register.simple_tag def build_option_filter(filter_field, admin_class): select = "<label>{}：</label><select name='{}' class='form-control'>".format(filter_field, filter_field) # 获取列中的字段对象 filter_field_obj = admin_class.model._meta.get_field(filter_field) try: for choice in filter_field_obj.get_choices(): # choice[0]为选项的值，choice[1]为选中的可见内容 # 获取过滤字典中的值，并在模板中呈选中状态 selected = '' if filter_field in admin_class.filter_conditions: # 如果当前值被选中 if str(choice[0]) == admin_class.filter_conditions.get(filter_field): selected = 'selected' option = "<option value='{}' {}>{}</option>".format(choice[0], selected, choice[1]) select += option except AttributeError as e: # 对时间使用单独的select select = "<label>{}：</label><select class='form-control' name='{}__gte'>".format(filter_field, filter_field) # print(filter_field_obj.get_internal_type()) # 这儿得到的结果是：DateField if filter_field_obj.get_internal_type() in ('DateField', 'DateTimeField'): import datetime now_time = datetime.datetime.now() filter_time_list = [ ('', '所有时间'), (now_time, '今天'), (now_time - datetime.timedelta(7), '7天内'), # 往前7天 (now_time.replace(day=1), '本月'), # 本月内 (now_time - datetime.timedelta(90), '三个月内'), (now_time.replace(month=1, day=1), '本年'), ] for dt in filter_time_list: # 如果选择的时间值不为空，则进行时间格式化 time_to_str = '' if not dt[0] else dt[0].strftime('%Y-%m-%d') # 需要将时间格式化成：YYYY-MM-DD # 修改name后，过滤时间的参数变成了created_time__gte=2018-11-03，所以下方的选中，需要进行修改 # 设置选中 selected = '' if filter_field + '__gte' in admin_class.filter_conditions: # 如果当前值被选中 if time_to_str == admin_class.filter_conditions.get(filter_field + '__gte'): selected = 'selected' option = "<option value='{}' {}>{}</option>".format(time_to_str, selected, dt[1]) select += option select += "</select>" return mark_safe(select) ``` 

明人不说暗话 领红包就是支持！！！ 来都来了，再到页面底部看下呗~ ↓ ↓ ↓

本文地址： http://blog.starmeow.cn/detail/a3c65c2974270fd093ee8a9bf8ae7d0b/

很赞哦！ (0)