def organisation_directory(request): """REST view for the update directory.""" page = request.rsr_page all_organisations = Organisation.objects.all() if not page else page.partners() # Filter updates based on query parameters filter_, text_filter = _create_filters_query(request) organisations = ( all_organisations.filter(filter_).distinct() if filter_ is not None else all_organisations ) organisations_text_filtered = ( organisations.filter(text_filter) if text_filter is not None else organisations ) if organisations_text_filtered.exists(): organisations = organisations_text_filtered # Get the relevant data for typeaheads based on filtered organisations (minus # text filtering, if no organisations were found) locations = [ {'id': choice[0], 'name': choice[1]} for choice in location_choices(organisations) ] count = organisations_text_filtered.count() display_organisations = get_qs_elements_for_page(organisations_text_filtered, request, count) # Get related objects of page at once response = { 'project_count': organisations_text_filtered.count(), 'projects': OrganisationDirectorySerializer(display_organisations, many=True).data, 'location': locations, 'page_size_default': settings.PROJECT_DIRECTORY_PAGE_SIZES[0], } return Response(response)
def organisation_directory(request): """REST view for the update directory.""" page = request.rsr_page all_organisations = Organisation.objects.all() if not page else _page_organisations(page) # Filter updates based on query parameters filter_, text_filter = _create_filters_query(request) organisations = ( all_organisations.filter(filter_).distinct() if filter_ is not None else all_organisations ) organisations_text_filtered = ( organisations.filter(text_filter) if text_filter is not None else organisations ) if organisations_text_filtered.exists(): organisations = organisations_text_filtered # Get the relevant data for typeaheads based on filtered organisations (minus # text filtering, if no organisations were found) locations = [ {'id': choice[0], 'name': choice[1]} for choice in location_choices(organisations) ] display_organisations = get_qs_elements_for_page(organisations_text_filtered, request) # Get related objects of page at once response = { 'project_count': organisations_text_filtered.count(), 'projects': OrganisationDirectorySerializer(display_organisations, many=True).data, 'location': locations, } return Response(response)
def update_directory(request): """REST view for the update directory.""" # Fetch updates based on whether we are on Akvo site or RSR main site page = request.rsr_page all_updates = _all_updates() if not page else page.updates() # Filter updates based on query parameters filter_, text_filter = _create_filters_query(request) updates = all_updates.filter( filter_).distinct() if filter_ is not None else all_updates updates_text_filtered = updates.filter( text_filter) if text_filter is not None else updates if updates_text_filtered.exists(): updates = updates_text_filtered # Get the relevant data for typeaheads based on filtered updates (minus # text filtering, if no updates were found) locations = [{ 'id': choice[0], 'name': choice[1] } for choice in location_choices(updates)] project_ids = updates.values_list('project__id', flat=True) projects = Project.objects.filter(id__in=project_ids) organisations = projects.all_partners().values('id', 'name', 'long_name') # FIXME: Currently only vocabulary 2 is supported (as was the case with # static filters). This could be extended to other vocabularies, in future. valid_sectors = dict(codelist_choices(SECTOR_CATEGORY)) sectors = projects.sectors().filter( vocabulary='2', sector_code__in=valid_sectors).values('sector_code').distinct() count = updates_text_filtered.count() display_updates = get_qs_elements_for_page(updates_text_filtered, request, count) display_updates = display_updates.select_related( 'project', 'project__primary_location', 'project__primary_organisation', 'user', ).prefetch_related('project__partners', 'project__sectors', 'locations', 'locations__country') response = { 'project_count': count, 'projects': ProjectUpdateDirectorySerializer(display_updates, many=True).data, 'organisation': TypeaheadOrganisationSerializer(organisations, many=True).data, 'location': locations, 'sector': TypeaheadSectorSerializer(sectors, many=True).data, 'page_size_default': settings.PROJECT_DIRECTORY_PAGE_SIZES[0], } return Response(response)
def update_directory(request): """REST view for the update directory.""" # Fetch updates based on whether we are on Akvo site or RSR main site page = request.rsr_page all_updates = _all_updates() if not page else _page_updates(page) # Filter updates based on query parameters filter_, text_filter = _create_filters_query(request) updates = all_updates.filter(filter_).distinct() if filter_ is not None else all_updates updates_text_filtered = updates.filter(text_filter) if text_filter is not None else updates if updates_text_filtered.exists(): updates = updates_text_filtered # Get the relevant data for typeaheads based on filtered updates (minus # text filtering, if no updates were found) locations = [ {'id': choice[0], 'name': choice[1]} for choice in location_choices(updates) ] project_ids = updates.values_list('project__id', flat=True) projects = Project.objects.filter(id__in=project_ids) organisations = projects.all_partners().values('id', 'name', 'long_name') # FIXME: Currently only vocabulary 2 is supported (as was the case with # static filters). This could be extended to other vocabularies, in future. valid_sectors = dict(codelist_choices(SECTOR_CATEGORY)) sectors = projects.sectors().filter( vocabulary='2', sector_code__in=valid_sectors ).values('sector_code').distinct() display_updates = get_qs_elements_for_page(updates_text_filtered, request) count = updates_text_filtered.count() display_updates = display_updates.select_related( 'project', 'project__primary_location', 'project__primary_organisation', 'user', ).prefetch_related( 'project__partners', 'project__sectors', 'locations', 'locations__country' ) response = { 'project_count': count, 'projects': ProjectUpdateDirectorySerializer(display_updates, many=True).data, 'organisation': TypeaheadOrganisationSerializer(organisations, many=True).data, 'location': locations, 'sector': TypeaheadSectorSerializer(sectors, many=True).data, 'page_size_default': settings.PROJECT_DIRECTORY_PAGE_SIZES[0], } return Response(response)
def project_directory(request): """Return the values for various project filters. Based on the current filters, it returns new options for all the (other) filters. This is used to generate dynamic filters. """ # Fetch projects based on whether we are an Akvo site or RSR main site page = request.rsr_page projects = page.projects() if page else Project.objects.all().public().published() # Exclude projects which don't have an image or a title # FIXME: This happens silently and may be confusing? projects = projects.exclude(Q(title='') | Q(current_image='')) # Filter projects based on query parameters filter_, text_filter = _create_filters_query(request) projects = projects.filter(filter_).distinct() if filter_ is not None else projects # NOTE: The text filter is handled differently/separately from the other filters. # The text filter allows users to enter free form text, which could result in no # projects being found for the given text. Other fields only allow selecting from # a list of options, and for every combination that is shown to users and # selectable by them, at least one project exists. # When no projects are returned for a given search string, if the text search is # not handled separately, the options for all the other filters are empty, and # this causes the filters to get cleared automatically. This is very weird UX. projects_text_filtered = ( projects.filter(text_filter) if text_filter is not None else projects ) if projects_text_filtered.exists(): projects = projects_text_filtered # Pre-fetch related fields to make things faster projects = projects.select_related( 'primary_location', 'primary_organisation', ).prefetch_related( 'locations', 'locations__country', 'recipient_countries', 'recipient_countries__country', ) # Get the relevant data for typeaheads based on filtered projects (minus # text filtering, if no projects were found) cached_locations, _ = get_cached_data(request, 'locations', None, None) if cached_locations is None: cached_locations = [ {'id': choice[0], 'name': choice[1]} for choice in location_choices(projects) ] set_cached_data(request, 'locations', cached_locations) organisations = projects.all_partners().values('id', 'name', 'long_name') # FIXME: Currently only vocabulary 2 is supported (as was the case with # static filters). This could be extended to other vocabularies, in future. valid_sectors = dict(codelist_choices(SECTOR_CATEGORY)) sectors = projects.sectors().filter( vocabulary='2', sector_code__in=valid_sectors ).values('sector_code').distinct() # NOTE: We use projects_text_filtered for displaying projects count = projects_text_filtered.count() display_projects = get_qs_elements_for_page(projects_text_filtered, request).select_related( 'primary_organisation' ) # NOTE: We use the _get_cached_data function to individually cache small # bits of data to avoid the response from never getting saved in the cache, # because the response is larger than the max size of data that can be # saved in the cache. cached_projects, showing_cached_projects = get_cached_data( request, 'projects', display_projects, ProjectDirectorySerializer ) cached_organisations, _ = get_cached_data( request, 'organisations', organisations, TypeaheadOrganisationSerializer ) response = { 'project_count': count, 'projects': cached_projects, 'showing_cached_projects': showing_cached_projects, 'organisation': cached_organisations, 'sector': TypeaheadSectorSerializer(sectors, many=True).data, 'location': cached_locations, 'page_size_default': settings.PROJECT_DIRECTORY_PAGE_SIZES[0], } return Response(response)
def project_directory(request): """Return the values for various project filters. Based on the current filters, it returns new options for all the (other) filters. This is used to generate dynamic filters. """ # Fetch projects based on whether we are an Akvo site or RSR main site page = request.rsr_page projects = page.projects() if page else Project.objects.all().public( ).published() # Exclude projects which don't have an image or a title # FIXME: This happens silently and may be confusing? projects = projects.exclude(Q(title='') | Q(current_image='')) # Filter projects based on query parameters filter_, text_filter = _create_filters_query(request) projects = projects.filter( filter_).distinct() if filter_ is not None else projects # NOTE: The text filter is handled differently/separately from the other filters. # The text filter allows users to enter free form text, which could result in no # projects being found for the given text. Other fields only allow selecting from # a list of options, and for every combination that is shown to users and # selectable by them, at least one project exists. # When no projects are returned for a given search string, if the text search is # not handled separately, the options for all the other filters are empty, and # this causes the filters to get cleared automatically. This is very weird UX. projects_text_filtered = (projects.filter(text_filter) if text_filter is not None else projects) if projects_text_filtered.exists(): projects = projects_text_filtered # Pre-fetch related fields to make things faster projects = projects.select_related( 'primary_location', 'primary_organisation', ).prefetch_related( 'locations', 'locations__country', 'recipient_countries', 'recipient_countries__country', ) # Get the relevant data for typeaheads based on filtered projects (minus # text filtering, if no projects were found) cached_locations, _ = get_cached_data(request, 'locations', None, None) if cached_locations is None: cached_locations = [{ 'id': choice[0], 'name': choice[1] } for choice in location_choices(projects)] set_cached_data(request, 'locations', cached_locations) organisations = projects.all_partners().values('id', 'name', 'long_name') # FIXME: Currently only vocabulary 2 is supported (as was the case with # static filters). This could be extended to other vocabularies, in future. valid_sectors = dict(codelist_choices(SECTOR_CATEGORY)) sectors = projects.sectors().filter( vocabulary='2', sector_code__in=valid_sectors).values('sector_code').distinct() # NOTE: We use projects_text_filtered for displaying projects count = projects_text_filtered.count() display_projects = get_qs_elements_for_page( projects_text_filtered, request).select_related('primary_organisation') # NOTE: We use the _get_cached_data function to individually cache small # bits of data to avoid the response from never getting saved in the cache, # because the response is larger than the max size of data that can be # saved in the cache. cached_projects, showing_cached_projects = get_cached_data( request, 'projects', display_projects, ProjectDirectorySerializer) cached_organisations, _ = get_cached_data(request, 'organisations', organisations, TypeaheadOrganisationSerializer) response = { 'project_count': count, 'projects': cached_projects, 'showing_cached_projects': showing_cached_projects, 'organisation': cached_organisations, 'sector': TypeaheadSectorSerializer(sectors, many=True).data, 'location': cached_locations, 'page_size_default': settings.PROJECT_DIRECTORY_PAGE_SIZES[0], } return Response(response)