django-Q模糊查询 

 1 def search(request):
 2     """搜索的视图"""
 3     center_name = request.GET.get("q_center_name")
 4     device_name = request.GET.get('q_device_name')
 5     device_system = request.GET.get('q_device_system')
 6     device_factory = request.GET.get('q_device_factory')
 7     device_system_version = request.GET.get('q_device_system_version')
 8     device_asset_num = request.GET.get('q_device_asset_number')
 9     device_phone_num = request.GET.get('q_device_phone_number')
10     device_recipient = request.GET.get('q_device_recipient')
11     device_user = request.GET.get('q_device_user')
12     devices_dic["center_name"] = center_name
13     devices_dic["device_name"] = device_name
14     devices_dic["device_system"] = device_system
15     devices_dic["device_factory"] = device_factory
16     devices_dic["device_system_version"] = device_system_version
17     devices_dic["device_asset_number"] = device_asset_num
18     devices_dic["device_phone_number"] = device_phone_num
19     devices_dic["device_recipient"] = device_recipient
20     devices_dic["device_user"] = device_user
21 
22     if devices_dic.values() is None:
23         # return redirect("/paginator_view")
24         return redirect("/devices_list")
25     else:
26         query = Q(device_name__contains=devices_dic["device_name"]) & Q(
27             device_system__contains=devices_dic["device_system"]) & Q(
28             device_factory__contains=devices_dic["device_factory"]) & Q(
29             device_system_version__contains=devices_dic["device_system_version"]) & Q(
30             device_asset_num__contains=devices_dic["device_asset_number"]) & Q(
31             device_phone_num__contains=devices_dic["device_phone_number"]) & Q(
32             device_recipient__contains=devices_dic["device_recipient"]) & Q(
33             device_user__contains=devices_dic["device_user"]) & Q(
34             center_name__contains=devices_dic["center_name"])
35 
36 
37         devices_sets = DeviceInfo.objects.filter(query)
38  
39         content={"devices":devices_sets,"devices_dic":devices_dic}
40         return render(request, 'phone/devices_list.html',content)
Q查询

 

参考文章：

https://www.cnblogs.com/huchong/p/8027962.html

posted on 2021-09-21 15:03  cherry_ning  阅读(59)  评论(0)    收藏  举报

导航