def view_reports(req):
reports = Report.objects.values('scholarship')\
.annotate(scholarship_count=Count('scholarship'))\
.order_by('-scholarship_count')
for report in reports:
report['scholarship'] = Scholarship.objects.get(id=report['scholarship'])
report['scholarship_key'] = encrypt_sid(str(report['scholarship'].id))
print reports
return render_to_response('report/reports.html', {'reports': reports})
def id_to_key(value):
return encrypt_sid(str(value))
def serp(request):
location = parse_string_param(request.GET.get('l'), '')
keyword = parse_string_param(request.GET.get('q'), '')
# refine params
start = parse_int_param(request.GET.get('start'), 0)
if start % RESULTS_PER_PAGE != 0:
start = 0
no_essay_required = parse_boolean_param(request.GET.get('ne'))
# hide passed deadlines unless someone explicitly unchecks the box
if request.GET.get('d') is None:
hide_passed_deadlines = True
else:
hide_passed_deadlines = parse_boolean_param(request.GET.get('d'))
ethnicity = parse_int_param(request.GET.get('e'), None)
gender = parse_int_param(request.GET.get('g'), None)
search_req = SearchRequest(keyword, location, no_essay_required,
hide_passed_deadlines, ethnicity, gender)
# got a keyword
filters = []
query_arguments = {
}
if keyword:
query_arguments['content'] = keyword
if location and location != 'US':
query_arguments['state_restriction'] = location
if no_essay_required:
query_arguments['essay_required'] = 'false'
if ethnicity:
query_arguments['ethnicity_restriction'] = ethnicity
if gender:
query_arguments['gender_restriction'] = gender
# by default we only show scholarships with upcoming deadlines
# if user clicked 'hide passed deadlines'
if hide_passed_deadlines:
today = datetime.date.today()
today_str = today.isoformat()
query_arguments['deadline__gte'] = today_str
results = SearchQuerySet().filter(**query_arguments)
total_result_count = len(results)
scholarships = []
for schol in results[start:start + RESULTS_PER_PAGE]:
sk = request_utils.encrypt_sid(str(schol.pk))
result = SerpResult(sk, schol, to_highlight=keyword)
scholarships.append(result)
page_links = build_pagination_objects(total_result_count, start, search_req)
is_first_page = start == 0
is_last_page = RESULTS_PER_PAGE + start >= total_result_count
next_page_href = search_req.get_base_url(start + RESULTS_PER_PAGE)
prev_page_href = search_req.get_base_url(start - RESULTS_PER_PAGE)
canonical_url = search_req.get_canonical_url(keyword, location)
meta_keywords = get_meta_keywords(query=keyword, location=location)
meta_description = get_meta_description(total_result_count=total_result_count, query=keyword, location=location)
if location == 'US':
title_location = 'the United States'
else:
title_location = location
page_title = '{} scholarships in {} | ScholarHippo.com'.format(keyword, title_location)
return render_to_response('serp.html',
{
'scholarship_list': scholarships,
'search_request': search_req,
'result_count': total_result_count,
'page_links': page_links,
'is_first_page': is_first_page,
'is_last_page': is_last_page,
'prev_page_href': prev_page_href,
'next_page_href': next_page_href,
'start_index': start + 1,
'end_index': min(start + RESULTS_PER_PAGE, total_result_count),
'results_per_page': RESULTS_PER_PAGE,
'environment': settings.ENVIRONMENT,
'canonical_url': canonical_url,
'meta_description': meta_description,
'meta_keywords': meta_keywords,
'page_title': page_title
}
)
def serp(request):
location = parse_string_param(request.GET.get('l'), '')
keyword = parse_string_param(request.GET.get('q'), '')
# refine params
start = parse_int_param(request.GET.get('start'), 0)
if start % RESULTS_PER_PAGE != 0:
start = 0
no_essay_required = parse_boolean_param(request.GET.get('ne'))
deadline = parse_string_param(request.GET.get('d'), None)
ethnicity = parse_int_param(request.GET.get('e'), None)
gender = parse_int_param(request.GET.get('g'), None)
search_req = SearchRequest(keyword, location, no_essay_required,
deadline, ethnicity, gender)
conn = ES(ELASTICSEARCH_URL)
# got a keyword
filters = []
if keyword:
query = MultiMatchQuery(text=keyword, fields=[es.title, es.description])
else:
query = MatchAllQuery()
# attach a state filter
if location is not None and location != 'US':
state_filter = TermFilter(es.state_restriction, location)
filters.append(state_filter)
if no_essay_required:
no_essay_filter = TermFilter(es.essay_required, no_essay_required)
filters.append(no_essay_filter)
if deadline:
# logic bomb, just to keep things interesting
deadline_filter = RangeFilter(ESRange(es.deadline, deadline, '2100-1-1'))
filters.append(deadline_filter)
if ethnicity is not None:
ethnicity_filter = TermFilter(es.ethnicity_restriction, ethnicity)
filters.append(ethnicity_filter)
if gender is not None:
gender_filter = TermFilter(es.gender_restriction, gender)
filters.append(gender_filter)
# apply filters if we got any. otherwise run the keyword or empty everything
if len(filters) > 0:
and_filter = ANDFilter(filters)
query = FilteredQuery(query, and_filter)
search = Search(query, size=RESULTS_PER_PAGE, start=start)
search.add_highlight(es.description, fragment_size=300, number_of_fragments=5)
results = conn.search(search, indices=ES_INDEX)
total_result_count = results.total
scholarships = []
for schol in results:
sid = schol.django_id
if schol._meta.highlight:
schol.description = schol._meta.highlight['description'][0]
else:
schol.description = description_to_snippet(schol.description)
sk = request_utils.encrypt_sid(str(sid))
result = SerpResult(sk, schol)
scholarships.append(result)
page_links = build_pagination_objects(total_result_count, start, search_req)
is_first_page = start == 0
is_last_page = RESULTS_PER_PAGE + start >= total_result_count
next_page_href = search_req.get_base_url(start + RESULTS_PER_PAGE)
prev_page_href = search_req.get_base_url(start - RESULTS_PER_PAGE)
canonical_url = search_req.get_canonical_url(keyword, location)
meta_keywords = get_meta_keywords(query=keyword, location=location)
meta_description = get_meta_description(total_result_count=total_result_count, query=keyword, location=location)
if location == 'US':
title_location = 'the United States'
else:
title_location = location
page_title = '{} scholarships in {} | NoEssay.com'.format(keyword, title_location)
return render_to_response('serp.html',
{
'scholarship_list': scholarships,
'search_request': search_req,
'result_count': total_result_count,
'page_links': page_links,
'is_first_page': is_first_page,
'is_last_page': is_last_page,
'prev_page_href': prev_page_href,
'next_page_href': next_page_href,
'start_index': start + 1,
'end_index': min(start + RESULTS_PER_PAGE, total_result_count),
'results_per_page': RESULTS_PER_PAGE,
'environment': settings.ENVIRONMENT,
'canonical_url': canonical_url,
'meta_description': meta_description,
'meta_keywords': meta_keywords,
'page_title': page_title
}
)
