def search_all(request):
# 根据关键词搜索地方美食
content = {}
isMobile = dmb.process_request(request)
keywords = ''
if 'keywords' in request.GET:
keywords = request.GET['keywords'].strip()
content['keywords'] = keywords
comm = Common()
ip = comm.get_client_ip(request)
if request.user.is_anonymous():
words = Words.objects.create(keywords=keywords, ip=ip)
else:
words = Words.objects.create(keywords=keywords,
ip=ip,
user=request.user)
words.save()
if keywords:
kbs = Article.objects.filter(title__contains=keywords)
#kbs = Article.objects.all()
kbs.extra(select={
'strength': 'count_read+count_good+count_reply+count_confirm'
},
order_by=('strength'))
else:
kbs = ''
content['kbs'] = kbs
content['rootmedia'] = settings.MEDIA_URL
provinces = Area.objects.filter(level=1)
content['provinces'] = provinces
content['page_title'] = u'搜索美食'
if isMobile:
return render(request, 'search/m_search.html', content)
else:
return render(request, 'search/search.html', content)
from django.db.models import Q
import re
from mobile.detectmobilebrowsermiddleware import DetectMobileBrowser
from basedatas.bd_comm import Common
from comment.models import Comment
from area.models import Area
from kb.models import Article, Kb_Recommend
from data.models import DataPlace, CoveredRate
#validate email format
EMAIL_REGEX = re.compile(r'[^@]+@[^@]+\.[^@]+')
dmb = DetectMobileBrowser()
comm = Common()
def index(request):
isMble = dmb.process_request(request)
context = {}
user = request.user
next_url = request.GET.get('next')
kbs = Kb_Recommend.objects.filter(type_homepage_kb=1).order_by('-date')
kb_one = Kb_Recommend.objects.filter(
type_homepage_slice=1).order_by('-date')[0]
week_kbs = Kb_Recommend.objects.filter(type_block=1)
provinces = Area.objects.filter(Q(level=1) | Q(name=u'北京市'))
total_city = Area.objects.filter(level=2).count()
def foods_inplace(placeid, request):
"""
根据地名搜索各地的美食，
如果搜索的是县级，且县级没有搜到，则搜索上一级的市级
如果搜索的是市级，且市级没有搜到，则搜索上一级的省级
"""
content = {}
try:
area = Area.objects.get(pk=placeid)
comm = Common()
ip = comm.get_client_ip(request)
if request.user.is_anonymous():
words = Words.objects.create(area=area, ip=ip)
else:
words = Words.objects.create(area=area, ip=ip, user=request.user)
words.save()
content['area'] = area
if area.level == 2: # 市：搜索该市的所有美食，包括县。
foodslocation = FoodLocation.objects.filter(
Q(area=area) | Q(area__parent_id=area.id))
elif area.level == 3:
foodslocation = FoodLocation.objects.filter(area=area)
elif area.level == 1:
cities_under = Area.objects.filter(parent_id=area.id)
foodslocation = []
for city_under in cities_under:
foodslocation_item = FoodLocation.objects.filter(
Q(area=city_under) | Q(area__parent_id=city_under.id))
if len(foodslocation_item) > 0:
foodslocation += foodslocation_item
if area.level == 2 or area.level == 1:
kbids = []
new_foodslocation = []
for foodlocation in foodslocation:
if foodlocation.kb.id not in kbids:
kbids.append(foodlocation.kb.id)
new_foodslocation.append(foodlocation)
foodslocation = new_foodslocation
content['foodslocation'] = foodslocation
if len(foodslocation) == 0:
# 在当地没有搜索出来记录，应该提示给用户，并搜索上一级地方的美食
# 如县级没有搜出来，就搜市级； 市级没有搜出来，就搜省级
content['status'] = 1 # 1 代表原来的搜索条件没有搜到记录
elif len(foodslocation) < 13:
# 搜索出来不到13个记录，为了丰富内容，还应该继续搜索推荐内容
content['status'] = 2 # 2 代表搜到了记录，但是但是记录比较少
if area.level == 3: # 当前为县级
# 查找了市级的记录
city_locations = FoodLocation.objects.filter(
area__id=area.parent_id)
# 查找了省级级的记录
city = Area.objects.get(pk=area.parent_id) # 市
province = Area.objects.get(pk=city.parent_id) # 省
province_locations = FoodLocation.objects.filter(
area__id=city.parent_id)
cities = Area.objects.filter(parent_id=city.parent_id) # 同级市
counties = Area.objects.filter(parent_id=area.parent_id) # 同级县
content['city'] = city
content['cities'] = cities
content['counties'] = counties
content['province'] = province
content['city_locations'] = city_locations
content['province_locations'] = province_locations
elif area.level == 2: # 当前为市级
# 查找了市级的记录
province = Area.objects.get(pk=area.parent_id) # 省
# province_locations = FoodLocation.objects.filter(area__id = province.id)
cities_under = Area.objects.filter(parent_id=area.parent_id)
province_locations = []
for city_under in cities_under:
foodslocation_item = FoodLocation.objects.filter(
Q(area=city_under) | Q(area__parent_id=city_under.id))
if len(foodslocation_item) > 0:
province_locations += foodslocation_item
kbids = []
new_foodslocation = []
for foodlocation in province_locations:
if foodlocation.kb.id not in kbids:
kbids.append(foodlocation.kb.id)
new_foodslocation.append(foodlocation)
province_locations = new_foodslocation
cities = Area.objects.filter(parent_id=area.parent_id) # 同级县
content['city'] = area
content['cities'] = cities
content['province'] = province
content['province_locations'] = province_locations
else: # 省级
cities = Area.objects.filter(parent_id=area.id) # 该省级所有的市
content['province'] = area
content['cities'] = cities
return content
except Area.DoesNotExist:
raise Http404
