def filter_candidates(request):
"""
Some default filtering for company/microsite. This function will
be changing with solr docs update and filtering addition.
"""
candidates = []
company_id = request.REQUEST.get('company')
try:
company = Company.objects.get(id=company_id)
except Company.DoesNotExist:
raise Http404
authorized_microsites, buids = get_company_microsites(company)
requested_microsite = request.REQUEST.get('microsite', company.name)
# the url value for 'All' in the select box is company name
# which then gets replaced with all microsite urls for that company
site_name = ''
if requested_microsite != company.name:
if requested_microsite.find('//') == -1:
requested_microsite = '//' + requested_microsite
active_microsites = authorized_microsites.filter(
domain__contains=requested_microsite)
else:
active_microsites = authorized_microsites
site_name = company.name
if not site_name:
try:
site_name = active_microsites[0]
except IndexError:
site_name = ''
q_list = [Q(url__contains=ms) for ms in active_microsites]
# All searches saved on the employer's company microsites
candidate_searches = SavedSearch.objects.select_related('user')
# Specific microsite searches saved between two dates
candidate_searches = candidate_searches.filter(reduce(
operator.or_, q_list)).exclude(
user__opt_in_employers=False).order_by('-created_on')
for search in candidate_searches:
candidates.append(search.user)
return list(set(candidates))
def dashboard(request, template="mydashboard/mydashboard.html",
extra_context=None):
"""
Returns a list of candidates who created a saved search for one of the
microsites within the company microsite list or with the company name like
jobs.jobs/company_name/careers for example between the given (optional)
dates
Inputs:
:company: company.id that is associated with request.user
Returns:
:render_to_response: renders template with context dict
"""
if hasattr(mail, 'outbox'):
solr = settings.TEST_SOLR_INSTANCE
else:
solr = settings.SOLR
company = get_company(request)
if not company:
raise Http404
user_solr = Solr(solr['current'])
facet_solr = Solr(solr['current'])
# Add join only if we're using facets, not if we're simply searching.
query_params = {'search', 'company'}
if not query_params.issuperset({q_key for q_key in request.GET.keys()
if q_key not in ['querystring_key',
'date_end', 'date_start',
'page']}):
user_solr = user_solr.add_join(from_field='ProfileUnits_user_id',
to_field='User_id')
facet_solr = facet_solr.add_join(from_field='User_id',
to_field='ProfileUnits_user_id')
facet_solr = facet_solr.rows_to_fetch(0)
authorized_microsites, buids = get_company_microsites(company)
admins = CompanyUser.objects.filter(company=company.id)
# Removes main user from admin list to display other admins
admins = admins.exclude(user=request.user)
requested_microsite = request.REQUEST.get('microsite', '')
requested_date_button = request.REQUEST.get('date_button', False)
candidates_page = request.REQUEST.get('page', 1)
# the url value for 'All' in the select box is company name
# which then gets replaced with all microsite urls for that company
site_name = ''
if requested_microsite != '':
active_microsites = authorized_microsites.filter(
domain__startswith=requested_microsite)
user_solr, facet_solr = filter_by_domain(requested_microsite,
user_solr, facet_solr)
else:
active_microsites = authorized_microsites
site_name = company.name
if not site_name:
try:
site_name = active_microsites[0]
except IndexError:
site_name = ''
active_microsites = set(active_microsites)
rng, date_start, date_end, date_display = filter_by_date(request)
user_solr = user_solr.add_filter_query(rng)
facet_solr = facet_solr.add_query(rng)
if request.GET.get('search', False):
user_solr = user_solr.add_query("%s" % request.GET['search'])
facet_solr = facet_solr.add_query("%s" % request.GET['search'])
user_solr, facet_solr = filter_by_microsite(company, user_solr, facet_solr)
(user_solr, facet_solr, filters) = apply_facets_and_filters(
request, user_solr, facet_solr)
solr_results = user_solr.rows_to_fetch(100).search()
# List of dashboard widgets to display.
dashboard_widgets = ["home_views", "search_views", "job_views",
"apply_clicks", "candidates", "search",
"applied_filters", "filters"]
# Date button highlighting
if 'today' in request.REQUEST:
requested_date_button = 'today'
elif 'seven_days' in request.REQUEST:
requested_date_button = 'seven_days'
elif 'thirty_days' in request.REQUEST:
requested_date_button = 'thirty_days'
url = request.build_absolute_uri()
facets = parse_facets(facet_solr.search(), request)
context = {
'admin_you': request.user,
'applied_filters': filters,
'candidates_page': candidates_page,
'company_admins': admins,
'company_id': company.id,
'company_microsites': authorized_microsites,
'company_name': company.name,
'dashboard_widgets': dashboard_widgets,
'date_button': requested_date_button,
'date_display': date_display,
'date_end': date_end,
'date_start': date_start,
'date_submit_url': url,
'facets': facets,
'site_name': site_name,
'view_name': 'Company Dashboard',
}
results = solr_results.docs
facet_var_map = {
'home': 'home',
'listing': 'job_view',
'results': 'search',
'redirect': 'apply',
}
analytics_solr = Solr(solr['current']).add_facet_field(
'page_category')
if requested_microsite:
analytics_solr = analytics_solr.add_query('domain:%s' %
requested_microsite)
else:
analytics_solr = analytics_solr.add_query('company_id:%d' % company.pk)
rng = filter_by_date(request, field='view_date')[0]
analytics_solr = analytics_solr.add_filter_query(rng)
all_results = analytics_solr.rows_to_fetch(0).search()
analytics_facets = all_results.facets.get('facet_fields', {}).get(
'page_category', [])
facet_dict = sequence_to_dict(analytics_facets)
for key in facet_dict.keys():
context_key = 'total_%s' % facet_var_map.get(key, '')
context[context_key] = facet_dict[key]
analytics_solr = analytics_solr.add_filter_query('User_id:[* TO *]')
analytics_solr = analytics_solr.add_facet_field('domain')
auth_results = analytics_solr.search()
analytics_facet_list = auth_results.facets.get(
'facet_fields', {}).get('domain', [])
analytics_facets = sequence_to_dict(analytics_facet_list)
analytics_facets = [domain for domain in analytics_facets.items()
if domain[0] in active_microsites]
results += auth_results.docs
candidates = dict_to_object(results)
domains = [get_domain(c.SavedSearch_feed) for c in candidates
if hasattr(c, 'SavedSearch_feed')]
search_facets = [(domain, domains.count(domain)) for domain in set(domains)]
domain_facets = {}
for domain, group in groupby(analytics_facets + search_facets,
key=lambda x: x[0]):
domain_facets[domain] = sum(item[1] for item in group)
candidate_list = sorted(candidates,
key=lambda y: y.SavedSearch_created_on
if hasattr(y, 'SavedSearch_created_on')
else y.view_date,
reverse=True)
context['domain_facets'] = domain_facets
context['candidates'] = candidate_list
context['total_candidates'] = len([x for x in groupby(
candidate_list, key=lambda y: y.User_id)])
if extra_context is not None:
context.update(extra_context)
return render_to_response(template, context,
context_instance=RequestContext(request))
