Skip to content

Tables

hypha.apply.funds.tables

User module-attribute 

User = get_user_model()

SubmissionsTable

Bases: Table

Base table for listing submissions, do not include admin data to this table

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title max-w-sm'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "link link-hover text-h4 font-semibold truncate inline-block w-[calc(100%-2rem)] after:content-[''] after:block"}})

submit_time class-attribute instance-attribute 

submit_time = DateColumn(verbose_name=gettext_lazy('Submitted'))

phase class-attribute instance-attribute 

phase = Column(verbose_name=gettext_lazy('Status'), order_by=('status',), attrs={'td': {'data-actions': render_actions, 'class': 'js-actions'}})

stage class-attribute instance-attribute 

stage = Column(verbose_name=gettext_lazy('Type'), order_by=('status',))

fund class-attribute instance-attribute 

fund = Column(verbose_name=gettext_lazy('Fund'), accessor='page')

comments class-attribute instance-attribute 

comments = Column(accessor='comment_count', verbose_name=gettext_lazy('Comments'))

last_update class-attribute instance-attribute 

last_update = DateColumn(accessor='last_update', verbose_name=gettext_lazy('Last updated'))

Meta

model class-attribute instance-attribute 
model = ApplicationSubmission
order_by class-attribute instance-attribute 
order_by = ('-last_update',)
fields class-attribute instance-attribute 
fields = ('title', 'phase', 'stage', 'fund', 'round', 'submit_time', 'last_update')
sequence class-attribute instance-attribute 
sequence = fields + ('comments',)
template_name class-attribute instance-attribute 
template_name = 'funds/tables/table.html'
row_attrs class-attribute instance-attribute 
row_attrs = {'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'table all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')

render_user 

render_user(value)
Source code in hypha/apply/funds/tables.py 
103
104
def render_user(self, value):
    return value.get_full_name()

render_phase 

render_phase(value)
Source code in hypha/apply/funds/tables.py 
106
107
def render_phase(self, value):
    return format_html("<span class='badge badge-outline'>{}</span>", value)

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
109
110
111
112
113
114
115
def order_last_update(self, qs, desc):
    update_order = getattr(F("last_update"), "desc" if desc else "asc")(
        nulls_last=True
    )

    qs = qs.order_by(update_order, "submit_time")
    return qs, True

get_column_class_names 

get_column_class_names(classes_set, bound_column)
Source code in hypha/apply/funds/tables.py 
117
118
119
120
121
122
def get_column_class_names(self, classes_set, bound_column):
    classes_set = super(SubmissionsTable, self).get_column_class_names(
        classes_set, bound_column
    )
    classes_set.add(bound_column.name)
    return classes_set

ReviewerSubmissionsTable

Bases: SubmissionsTable

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title max-w-sm'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "link link-hover text-h4 font-semibold truncate inline-block w-[calc(100%-2rem)] after:content-[''] after:block"}})

submit_time class-attribute instance-attribute 

submit_time = DateColumn(verbose_name=gettext_lazy('Submitted'))

phase class-attribute instance-attribute 

phase = Column(verbose_name=gettext_lazy('Status'), order_by=('status',), attrs={'td': {'data-actions': render_actions, 'class': 'js-actions'}})

stage class-attribute instance-attribute 

stage = Column(verbose_name=gettext_lazy('Type'), order_by=('status',))

fund class-attribute instance-attribute 

fund = Column(verbose_name=gettext_lazy('Fund'), accessor='page')

comments class-attribute instance-attribute 

comments = Column(accessor='comment_count', verbose_name=gettext_lazy('Comments'))

last_update class-attribute instance-attribute 

last_update = DateColumn(accessor='last_update', verbose_name=gettext_lazy('Last updated'))

Meta

Bases: Meta

orderable class-attribute instance-attribute 
orderable = False
model class-attribute instance-attribute 
model = ApplicationSubmission
order_by class-attribute instance-attribute 
order_by = ('-last_update',)
fields class-attribute instance-attribute 
fields = ('title', 'phase', 'stage', 'fund', 'round', 'submit_time', 'last_update')
sequence class-attribute instance-attribute 
sequence = fields + ('comments',)
template_name class-attribute instance-attribute 
template_name = 'funds/tables/table.html'
row_attrs class-attribute instance-attribute 
row_attrs = {'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'table all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')

render_user 

render_user(value)
Source code in hypha/apply/funds/tables.py 
103
104
def render_user(self, value):
    return value.get_full_name()

render_phase 

render_phase(value)
Source code in hypha/apply/funds/tables.py 
106
107
def render_phase(self, value):
    return format_html("<span class='badge badge-outline'>{}</span>", value)

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
109
110
111
112
113
114
115
def order_last_update(self, qs, desc):
    update_order = getattr(F("last_update"), "desc" if desc else "asc")(
        nulls_last=True
    )

    qs = qs.order_by(update_order, "submit_time")
    return qs, True

get_column_class_names 

get_column_class_names(classes_set, bound_column)
Source code in hypha/apply/funds/tables.py 
117
118
119
120
121
122
def get_column_class_names(self, classes_set, bound_column):
    classes_set = super(SubmissionsTable, self).get_column_class_names(
        classes_set, bound_column
    )
    classes_set.add(bound_column.name)
    return classes_set

LabeledCheckboxColumn

Bases: CheckBoxColumn

header property 

header

wrap_with_label 

wrap_with_label(checkbox, for_value)
Source code in hypha/apply/funds/tables.py 
131
132
133
134
135
136
def wrap_with_label(self, checkbox, for_value):
    return format_html(
        '<label for="{}">{}</label>',
        for_value,
        checkbox,
    )

render 

render(value, record, bound_column)
Source code in hypha/apply/funds/tables.py 
143
144
145
def render(self, value, record, bound_column):
    checkbox = super().render(value=value, record=record, bound_column=bound_column)
    return self.wrap_with_label(checkbox, value)

BaseAdminSubmissionsTable

Bases: SubmissionsTable

lead class-attribute instance-attribute 

lead = Column(order_by=('lead__full_name',))

reviews_stats class-attribute instance-attribute 

reviews_stats = TemplateColumn(template_name='funds/tables/column_reviews.html', verbose_name=mark_safe('Reviews<div>Comp. <span class="counts-separator">/</span> Assgn.</div>'), orderable=False)

screening_status class-attribute instance-attribute 

screening_status = Column(verbose_name=gettext_lazy('Screening'), accessor='screening_statuses')

organization_name class-attribute instance-attribute 

organization_name = Column()

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title max-w-sm'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "link link-hover text-h4 font-semibold truncate inline-block w-[calc(100%-2rem)] after:content-[''] after:block"}})

submit_time class-attribute instance-attribute 

submit_time = DateColumn(verbose_name=gettext_lazy('Submitted'))

phase class-attribute instance-attribute 

phase = Column(verbose_name=gettext_lazy('Status'), order_by=('status',), attrs={'td': {'data-actions': render_actions, 'class': 'js-actions'}})

stage class-attribute instance-attribute 

stage = Column(verbose_name=gettext_lazy('Type'), order_by=('status',))

fund class-attribute instance-attribute 

fund = Column(verbose_name=gettext_lazy('Fund'), accessor='page')

comments class-attribute instance-attribute 

comments = Column(accessor='comment_count', verbose_name=gettext_lazy('Comments'))

last_update class-attribute instance-attribute 

last_update = DateColumn(accessor='last_update', verbose_name=gettext_lazy('Last updated'))

Meta

Bases: Meta

fields class-attribute instance-attribute 
fields = ('title', 'phase', 'stage', 'fund', 'round', 'lead', 'submit_time', 'last_update', 'screening_status', 'reviews_stats', 'organization_name')
sequence class-attribute instance-attribute 
sequence = fields + ('comments',)
model class-attribute instance-attribute 
model = ApplicationSubmission
order_by class-attribute instance-attribute 
order_by = ('-last_update',)
template_name class-attribute instance-attribute 
template_name = 'funds/tables/table.html'
row_attrs class-attribute instance-attribute 
row_attrs = {'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'table all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')

render_lead 

render_lead(value)
Source code in hypha/apply/funds/tables.py 
178
179
def render_lead(self, value):
    return format_html("<span>{}</span>", value)

render_screening_status 

render_screening_status(value)
Source code in hypha/apply/funds/tables.py 
181
182
183
184
185
186
187
188
189
190
191
def render_screening_status(self, value):
    try:
        status = value.get()
        classname = "status-yes" if status.yes else "status-no text-red-500"
        return format_html(
            f"<span class='font-medium text-xs {classname}'>{'👍' if status.yes else '👎'} {status.title}</span>"
        )
    except ScreeningStatus.DoesNotExist:
        return format_html(
            "<span class='text-xs text-fg-muted'>{}</span>", "Awaiting"
        )

render_user 

render_user(value)
Source code in hypha/apply/funds/tables.py 
103
104
def render_user(self, value):
    return value.get_full_name()

render_phase 

render_phase(value)
Source code in hypha/apply/funds/tables.py 
106
107
def render_phase(self, value):
    return format_html("<span class='badge badge-outline'>{}</span>", value)

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
109
110
111
112
113
114
115
def order_last_update(self, qs, desc):
    update_order = getattr(F("last_update"), "desc" if desc else "asc")(
        nulls_last=True
    )

    qs = qs.order_by(update_order, "submit_time")
    return qs, True

get_column_class_names 

get_column_class_names(classes_set, bound_column)
Source code in hypha/apply/funds/tables.py 
117
118
119
120
121
122
def get_column_class_names(self, classes_set, bound_column):
    classes_set = super(SubmissionsTable, self).get_column_class_names(
        classes_set, bound_column
    )
    classes_set.add(bound_column.name)
    return classes_set

MultiCheckboxesMixin 

MultiCheckboxesMixin(*args, **kwargs)

Bases: Filter

Source code in hypha/apply/funds/tables.py 
225
226
227
228
229
230
def __init__(self, *args, **kwargs):
    label = kwargs.get("label")
    kwargs.setdefault(
        "widget", MultiCheckboxesWidget(attrs={"data-placeholder": label})
    )
    super().__init__(*args, **kwargs)

MultipleChoiceFilter 

MultipleChoiceFilter(*args, **kwargs)

Bases: MultiCheckboxesMixin, MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
225
226
227
228
229
230
def __init__(self, *args, **kwargs):
    label = kwargs.get("label")
    kwargs.setdefault(
        "widget", MultiCheckboxesWidget(attrs={"data-placeholder": label})
    )
    super().__init__(*args, **kwargs)

ModelMultipleChoiceFilter 

ModelMultipleChoiceFilter(*args, **kwargs)

Bases: MultipleChoiceFilter, ModelMultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
225
226
227
228
229
230
def __init__(self, *args, **kwargs):
    label = kwargs.get("label")
    kwargs.setdefault(
        "widget", MultiCheckboxesWidget(attrs={"data-placeholder": label})
    )
    super().__init__(*args, **kwargs)

StatusMultipleChoiceFilter 

StatusMultipleChoiceFilter(limit_to, *args, **kwargs)

Bases: MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
def __init__(self, limit_to, *args, **kwargs):
    choices = [
        (slugify(name), name)
        for name, statuses in STATUSES.items()
        if not limit_to or self.has_any(statuses, limit_to)
    ]
    self.status_map = {
        slugify(name): list(status) for name, status in STATUSES.items()
    }
    super().__init__(
        *args,
        field_name="status",
        choices=choices,
        label=_("Statuses"),
        **kwargs,
    )

status_map instance-attribute 

status_map = {slugify(name): list(status)for (name, status) in items()}

has_any 

has_any(first, second)
Source code in hypha/apply/funds/tables.py 
261
262
def has_any(self, first, second):
    return any(item in second for item in first)

get_filter_predicate 

get_filter_predicate(v)
Source code in hypha/apply/funds/tables.py 
264
265
def get_filter_predicate(self, v):
    return {f"{self.field_name}__in": self.status_map.get(v, [])}

SubmissionFilter 

SubmissionFilter(*args, exclude=None, limit_statuses=None, **kwargs)

Bases: FilterSet

Source code in hypha/apply/funds/tables.py 
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
def __init__(self, *args, exclude=None, limit_statuses=None, **kwargs):
    if exclude is None:
        exclude = []

    super().__init__(*args, **kwargs)

    self.filters["status"] = StatusMultipleChoiceFilter(limit_to=limit_statuses)
    self.filters["category_options"].extra["choices"] = [
        (option.id, option.value)
        for option in Option.objects.filter(category__filter_on_dashboard=True)
    ]
    self.filters = {
        field: filter
        for field, filter in self.filters.items()
        if field not in exclude
    }

fund class-attribute instance-attribute 

fund = ModelMultipleChoiceFilter(field_name='page', queryset=get_used_funds, label=gettext_lazy('Funds'))

round class-attribute instance-attribute 

round = ModelMultipleChoiceFilter(queryset=get_used_rounds, label=gettext_lazy('Rounds'))

lead class-attribute instance-attribute 

lead = ModelMultipleChoiceFilter(queryset=get_round_leads, label=gettext_lazy('Leads'))

screening_statuses class-attribute instance-attribute 

screening_statuses = ModelMultipleChoiceFilter(queryset=get_screening_statuses, label=gettext_lazy('Screening'), null_label=gettext_lazy('No Status'))

reviewers class-attribute instance-attribute 

reviewers = ModelMultipleChoiceFilter(queryset=get_all_reviewers, label=gettext_lazy('Reviewers'))

category_options class-attribute instance-attribute 

category_options = MultipleChoiceFilter(choices=[], label=gettext_lazy('Category'), method='filter_category_options')

meta_terms class-attribute instance-attribute 

meta_terms = ModelMultipleChoiceFilter(queryset=get_meta_terms, label=gettext_lazy('Tags'))

filters instance-attribute 

filters = {field: _sXxEcfor (field, filter) in items() if field not in exclude}

Meta

model class-attribute instance-attribute 
model = ApplicationSubmission
fields class-attribute instance-attribute 
fields = ('fund', 'round')

filter_category_options 

filter_category_options(queryset, name, value)

Filter submissions based on the category options selected.

In order to do that we need to first get all the category fields used in the submission.

And then use those category fields to filter submissions with their form_data.

Source code in hypha/apply/funds/tables.py 
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
def filter_category_options(self, queryset, name, value):
    """
    Filter submissions based on the category options selected.

    In order to do that we need to first get all the category fields used in the submission.

    And then use those category fields to filter submissions with their form_data.
    """
    query = Q()
    submission_data = queryset.values("form_fields", "form_data").distinct()
    for submission in submission_data:
        for field in submission["form_fields"]:
            if isinstance(field.block, CategoryQuestionBlock):
                try:
                    category_options = category_ids = submission["form_data"][
                        field.id
                    ]
                except KeyError:
                    include_in_filter = False
                else:
                    if isinstance(category_options, str):
                        category_options = [category_options]
                    include_in_filter = set(category_options) & set(value)
                # Check if filter options has any value in category options
                # If yes then those submissions should be filtered in the list
                if include_in_filter:
                    kwargs = {
                        "{0}__{1}".format("form_data", field.id): category_ids
                    }
                    query |= Q(**kwargs)
    return queryset.filter(query)

SubmissionFilterAndSearch 

SubmissionFilterAndSearch(*args, exclude=None, limit_statuses=None, **kwargs)

Bases: SubmissionFilter

Source code in hypha/apply/funds/tables.py 
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
def __init__(self, *args, exclude=None, limit_statuses=None, **kwargs):
    if exclude is None:
        exclude = []

    super().__init__(*args, **kwargs)

    self.filters["status"] = StatusMultipleChoiceFilter(limit_to=limit_statuses)
    self.filters["category_options"].extra["choices"] = [
        (option.id, option.value)
        for option in Option.objects.filter(category__filter_on_dashboard=True)
    ]
    self.filters = {
        field: filter
        for field, filter in self.filters.items()
        if field not in exclude
    }

query class-attribute instance-attribute 

query = CharFilter(method='search_data_and_id', widget=HiddenInput)

archived class-attribute instance-attribute 

archived = BooleanFilter(field_name='is_archive', widget=HiddenInput, method='filter_archived')

fund class-attribute instance-attribute 

fund = ModelMultipleChoiceFilter(field_name='page', queryset=get_used_funds, label=gettext_lazy('Funds'))

round class-attribute instance-attribute 

round = ModelMultipleChoiceFilter(queryset=get_used_rounds, label=gettext_lazy('Rounds'))

lead class-attribute instance-attribute 

lead = ModelMultipleChoiceFilter(queryset=get_round_leads, label=gettext_lazy('Leads'))

screening_statuses class-attribute instance-attribute 

screening_statuses = ModelMultipleChoiceFilter(queryset=get_screening_statuses, label=gettext_lazy('Screening'), null_label=gettext_lazy('No Status'))

reviewers class-attribute instance-attribute 

reviewers = ModelMultipleChoiceFilter(queryset=get_all_reviewers, label=gettext_lazy('Reviewers'))

category_options class-attribute instance-attribute 

category_options = MultipleChoiceFilter(choices=[], label=gettext_lazy('Category'), method='filter_category_options')

meta_terms class-attribute instance-attribute 

meta_terms = ModelMultipleChoiceFilter(queryset=get_meta_terms, label=gettext_lazy('Tags'))

filters instance-attribute 

filters = {field: _AcEYtfor (field, filter) in items() if field not in exclude}

Meta

model class-attribute instance-attribute 
model = ApplicationSubmission
fields class-attribute instance-attribute 
fields = ('fund', 'round')

search_data_and_id 

search_data_and_id(queryset, name, value)
Source code in hypha/apply/funds/tables.py 
345
346
347
348
349
def search_data_and_id(self, queryset, name, value):
    possible_id = re.search("^#(\\d+)$", value.strip())
    if possible_id:
        return queryset.filter(id=possible_id.groups()[0])
    return queryset.filter(search_data__icontains=value)

filter_archived 

filter_archived(queryset, name, value)
Source code in hypha/apply/funds/tables.py 
351
352
353
354
355
def filter_archived(self, queryset, name, value):
    if not value:
        # if value is 0 or None
        queryset = queryset.exclude(is_archive=True)
    return queryset

filter_category_options 

filter_category_options(queryset, name, value)

Filter submissions based on the category options selected.

In order to do that we need to first get all the category fields used in the submission.

And then use those category fields to filter submissions with their form_data.

Source code in hypha/apply/funds/tables.py 
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
def filter_category_options(self, queryset, name, value):
    """
    Filter submissions based on the category options selected.

    In order to do that we need to first get all the category fields used in the submission.

    And then use those category fields to filter submissions with their form_data.
    """
    query = Q()
    submission_data = queryset.values("form_fields", "form_data").distinct()
    for submission in submission_data:
        for field in submission["form_fields"]:
            if isinstance(field.block, CategoryQuestionBlock):
                try:
                    category_options = category_ids = submission["form_data"][
                        field.id
                    ]
                except KeyError:
                    include_in_filter = False
                else:
                    if isinstance(category_options, str):
                        category_options = [category_options]
                    include_in_filter = set(category_options) & set(value)
                # Check if filter options has any value in category options
                # If yes then those submissions should be filtered in the list
                if include_in_filter:
                    kwargs = {
                        "{0}__{1}".format("form_data", field.id): category_ids
                    }
                    query |= Q(**kwargs)
    return queryset.filter(query)

SubmissionDashboardFilter 

SubmissionDashboardFilter(*args, exclude=None, limit_statuses=None, **kwargs)

Bases: FilterSet

Source code in hypha/apply/funds/tables.py 
368
369
370
371
372
373
374
375
376
377
def __init__(self, *args, exclude=None, limit_statuses=None, **kwargs):
    if exclude is None:
        exclude = []
    super().__init__(*args, **kwargs)

    self.filters = {
        field: filter
        for field, filter in self.filters.items()
        if field not in exclude
    }

round class-attribute instance-attribute 

round = ModelMultipleChoiceFilter(queryset=get_used_rounds, label=gettext_lazy('Rounds'))

fund class-attribute instance-attribute 

fund = ModelMultipleChoiceFilter(field_name='page', queryset=get_used_funds, label=gettext_lazy('Funds'))

filters instance-attribute 

filters = {field: _Zr0qWfor (field, filter) in items() if field not in exclude}

Meta

model class-attribute instance-attribute 
model = ApplicationSubmission
fields class-attribute instance-attribute 
fields = ('fund', 'round')

RoundsTable 

RoundsTable(*args, **kwargs)

Bases: Table

Source code in hypha/apply/funds/tables.py 
396
397
398
def __init__(self, *args, **kwargs):
    self.prefix = kwargs.pop("prefix", "rounds")
    super().__init__(*args, **kwargs)

title class-attribute instance-attribute 

title = Column(linkify=lambda record: get_absolute_url(), orderable=True, attrs={'a': {'class': 'link link-hover text-h4 font-semibold'}})

fund class-attribute instance-attribute 

fund = Column(accessor=A('specific__fund'))

lead class-attribute instance-attribute 

lead = Column()

deterrmined class-attribute instance-attribute 

deterrmined = Column(verbose_name=gettext_lazy('Determined'), accessor='progress')

start_date class-attribute instance-attribute 

start_date = RelativeTimeColumn(verbose_name=gettext_lazy('Start'))

end_date class-attribute instance-attribute 

end_date = RelativeTimeColumn(verbose_name=gettext_lazy('End'))

prefix instance-attribute 

prefix = pop('prefix', 'rounds')

Meta

fields class-attribute instance-attribute 
fields = ('title', 'fund', 'lead', 'start_date', 'end_date', 'deterrmined')
attrs class-attribute instance-attribute 
attrs = {'class': 'table'}

render_lead 

render_lead(value)
Source code in hypha/apply/funds/tables.py 
404
405
def render_lead(self, value):
    return format_html("<span>{}</span>", value)

render_deterrmined 

render_deterrmined(record)
Source code in hypha/apply/funds/tables.py 
407
408
def render_deterrmined(self, record):
    return f"{record.progress}%"

order_start_date 

order_start_date(qs, desc)
Source code in hypha/apply/funds/tables.py 
413
414
def order_start_date(self, qs, desc):
    return qs.order_by(self._field_order("start_date", desc)), True

order_end_date 

order_end_date(qs, desc)
Source code in hypha/apply/funds/tables.py 
416
417
def order_end_date(self, qs, desc):
    return qs.order_by(self._field_order("end_date", desc)), True

order_fund 

order_fund(qs, desc)
Source code in hypha/apply/funds/tables.py 
419
420
def order_fund(self, qs, desc):
    return qs.order_by(self._field_order("fund", desc)), True

order_progress 

order_progress(qs, desc)
Source code in hypha/apply/funds/tables.py 
422
423
def order_progress(self, qs, desc):
    return qs.order_by(self._field_order("progress", desc)), True

get_column_class_names 

get_column_class_names(classes_set, bound_column)
Source code in hypha/apply/funds/tables.py 
425
426
427
428
429
430
def get_column_class_names(self, classes_set, bound_column):
    classes_set = super(RoundsTable, self).get_column_class_names(
        classes_set, bound_column
    )
    classes_set.add(bound_column.name)
    return classes_set

ActiveRoundFilter 

ActiveRoundFilter(*args, **kwargs)

Bases: MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
434
435
436
437
438
439
440
def __init__(self, *args, **kwargs):
    super().__init__(
        self,
        *args,
        choices=[("active", "Active"), ("inactive", "Inactive")],
        **kwargs,
    )

filter 

filter(qs, value)
Source code in hypha/apply/funds/tables.py 
442
443
444
445
446
447
448
449
450
def filter(self, qs, value):
    if value is None or len(value) != 1:
        return qs

    value = value[0]
    if value == "active":
        return qs.active()
    else:
        return qs.inactive()

OpenRoundFilter 

OpenRoundFilter(*args, **kwargs)

Bases: MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
454
455
456
457
458
459
460
def __init__(self, *args, **kwargs):
    super().__init__(
        self,
        *args,
        choices=[("open", "Open"), ("closed", "Closed"), ("new", "Not Started")],
        **kwargs,
    )

filter 

filter(qs, value)
Source code in hypha/apply/funds/tables.py 
462
463
464
465
466
467
468
469
470
471
472
def filter(self, qs, value):
    if value is None or len(value) != 1:
        return qs

    value = value[0]
    if value == "closed":
        return qs.closed()
    if value == "new":
        return qs.new()

    return qs.open()

RoundsFilter

Bases: FilterSet

fund class-attribute instance-attribute 

fund = ModelMultipleChoiceFilter(queryset=get_used_funds, label=gettext_lazy('Funds'))

lead class-attribute instance-attribute 

lead = ModelMultipleChoiceFilter(queryset=get_round_leads, label=gettext_lazy('Leads'))

active class-attribute instance-attribute 

active = ActiveRoundFilter(label=gettext_lazy('Active'))

round_state class-attribute instance-attribute 

round_state = OpenRoundFilter(label=gettext_lazy('Open'))

ReviewerLeaderboardFilterForm

Bases: ModelForm

Form to "clean" a list of User objects to their PKs.

The Reviewer Leaderboard table is a list of User objects, however we also want the ability to filter down to N Users (reviewers). Django filter is converting the selected PKs to User objects, however we can't filter a User QuerySet with User objects. So this form converts back to a list of User PKs using the clean_reviewer method.

Meta

fields class-attribute instance-attribute 
fields = ['id']
model class-attribute instance-attribute 
model = User

clean_reviewer 

clean_reviewer()
Source code in hypha/apply/funds/tables.py 
497
498
def clean_reviewer(self):
    return [u.id for u in self.cleaned_data["reviewer"]]

ReviewerLeaderboardFilter

Bases: FilterSet

query class-attribute instance-attribute 

query = CharFilter(field_name='full_name', lookup_expr='icontains', widget=HiddenInput)

reviewer class-attribute instance-attribute 

reviewer = ModelMultipleChoiceFilter(field_name='pk', label=gettext_lazy('Reviewers'), queryset=get_all_reviewers)

funds class-attribute instance-attribute 

funds = ModelMultipleChoiceFilter(field_name='applicationsubmission__page', label=gettext_lazy('Funds'), queryset=get_used_funds)

rounds class-attribute instance-attribute 

rounds = ModelMultipleChoiceFilter(field_name='applicationsubmission__round', label=gettext_lazy('Rounds'), queryset=get_used_rounds)

Meta

fields class-attribute instance-attribute 
fields = ['reviewer', 'funds', 'rounds']
form class-attribute instance-attribute 
form = ReviewerLeaderboardFilterForm
model class-attribute instance-attribute 
model = User

ReviewerLeaderboardTable

Bases: Table

full_name class-attribute instance-attribute 

full_name = LinkColumn('funds:submissions:reviewer_leaderboard_detail', args=[A('pk')], orderable=True, verbose_name=gettext_lazy('Reviewer'), attrs={'a': {'class': 'link link-hover text-h4 font-semibold'}, 'td': {'class': 'title'}})

Meta

model class-attribute instance-attribute 
model = User
fields class-attribute instance-attribute 
fields = ['full_name', 'ninety_days', 'this_year', 'last_year', 'total']
order_by class-attribute instance-attribute 
order_by = ('-ninety_days',)
attrs class-attribute instance-attribute 
attrs = {'class': 'table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No reviews available')

ReviewerLeaderboardDetailTable

Bases: Table

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:reviews:review', text=render_title, args=[A('submission_id'), A('pk')], orderable=True, verbose_name=gettext_lazy('Submission'), attrs={'td': {'class': 'js-title'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': 'link link-hover text-h4 font-semibold truncate inline-block w-[calc(100%-2rem)] after:content-[] after:block'}})

Meta

model class-attribute instance-attribute 
model = Review
fields class-attribute instance-attribute 
fields = ['title', 'recommendation', 'created_at']
order_by class-attribute instance-attribute 
order_by = ('-created_at',)
attrs class-attribute instance-attribute 
attrs = {'class': 'table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No reviews available')

StaffAssignmentsTable

Bases: Table

full_name class-attribute instance-attribute 

full_name = Column(linkify=render_reviewer_link, orderable=True, verbose_name=gettext_lazy('Staff'), attrs={'td': {'class': 'title'}})

Meta

model class-attribute instance-attribute 
model = User
fields class-attribute instance-attribute 
fields = ['full_name']
attrs class-attribute instance-attribute 
attrs = {'class': 'table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No staff available')

render_actions 

render_actions(table, record)
Source code in hypha/apply/funds/tables.py 
30
31
32
33
def render_actions(table, record):
    user = table.context["user"]
    actions = record.get_actions_for_user(user)
    return json.dumps([slugify(action) for _, action in actions])

render_title 

render_title(record)
Source code in hypha/apply/funds/tables.py 
36
37
38
39
40
41
def render_title(record):
    try:
        title = record.title_text_display
    except AttributeError:
        title = record.submission.title_text_display
    return title

render_reviewer_link(record)
Source code in hypha/apply/funds/tables.py 
44
45
def render_reviewer_link(record):
    return f"{reverse('funds:submissions:list')}?reviewers={record.id}"

get_used_rounds 

get_used_rounds(request)
Source code in hypha/apply/funds/tables.py 
194
195
def get_used_rounds(request):
    return Round.objects.filter(submissions__isnull=False).distinct()

get_used_funds 

get_used_funds(request)
Source code in hypha/apply/funds/tables.py 
198
199
200
def get_used_funds(request):
    # Use page to pick up on both Labs and Funds
    return Page.objects.filter(applicationsubmission__isnull=False).distinct()

get_round_leads 

get_round_leads(request)
Source code in hypha/apply/funds/tables.py 
203
204
def get_round_leads(request):
    return User.objects.filter(submission_lead__isnull=False).distinct()

get_screening_statuses 

get_screening_statuses(request)
Source code in hypha/apply/funds/tables.py 
207
208
209
210
211
212
def get_screening_statuses(request):
    return ScreeningStatus.objects.filter(
        id__in=ApplicationSubmission.objects.all()
        .values("screening_statuses__id")
        .distinct("screening_statuses__id")
    )

get_meta_terms 

get_meta_terms(request)
Source code in hypha/apply/funds/tables.py 
215
216
217
218
219
220
221
def get_meta_terms(request):
    return MetaTerm.objects.filter(
        filter_on_dashboard=True,
        id__in=ApplicationSubmission.objects.all()
        .values("meta_terms__id")
        .distinct("meta_terms__id"),
    )