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'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "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 = {'class': make_row_class, 'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': '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 
119
120
def render_user(self, value):
    return value.get_full_name()

render_phase 

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

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
125
126
127
128
129
130
131
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 
133
134
135
136
137
138
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'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "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

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 = {'class': make_row_class, 'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')
orderable class-attribute instance-attribute 
orderable = False

render_user 

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

render_phase 

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

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
125
126
127
128
129
130
131
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 
133
134
135
136
137
138
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 
147
148
149
150
151
152
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 
159
160
161
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

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "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'))

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()

Meta

Bases: Meta

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 = {'class': make_row_class, 'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')
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')

render_user 

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

render_phase 

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

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
125
126
127
128
129
130
131
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 
133
134
135
136
137
138
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

render_lead 

render_lead(value)
Source code in hypha/apply/funds/tables.py 
194
195
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 
197
198
199
200
201
202
203
204
205
206
207
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"
        )

AdminSubmissionsTable

Bases: BaseAdminSubmissionsTable

Adds admin only columns to the submissions table

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "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'))

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()

selected class-attribute instance-attribute 

selected = LabeledCheckboxColumn(accessor=A('pk'), attrs={'input': {'class': 'js-batch-select'}, 'th__input': {'class': 'js-batch-select-all'}})

Meta

Bases: Meta

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 = {'class': make_row_class, 'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')
fields class-attribute instance-attribute 
fields = ('selected', *fields)
sequence class-attribute instance-attribute 
sequence = fields

render_user 

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

render_phase 

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

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
125
126
127
128
129
130
131
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 
133
134
135
136
137
138
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

render_lead 

render_lead(value)
Source code in hypha/apply/funds/tables.py 
194
195
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 
197
198
199
200
201
202
203
204
205
206
207
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"
        )

SummarySubmissionsTable

Bases: BaseAdminSubmissionsTable

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "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'))

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()

Meta

Bases: 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', 'lead', 'submit_time', 'last_update', 'screening_status', 'reviews_stats', 'organization_name')
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 = {'class': make_row_class, 'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')
orderable class-attribute instance-attribute 
orderable = False

render_user 

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

render_phase 

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

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
125
126
127
128
129
130
131
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 
133
134
135
136
137
138
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

render_lead 

render_lead(value)
Source code in hypha/apply/funds/tables.py 
194
195
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 
197
198
199
200
201
202
203
204
205
206
207
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"
        )

SummarySubmissionsTableWithRole

Bases: BaseAdminSubmissionsTable

Adds Role Assigned to the 'Waiting for My Review' table

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:detail', text=render_title, args=[A('pk')], orderable=True, attrs={'td': {'class': 'js-title'}, 'a': {'data-tippy-content': lambda record: render_title(record), 'data-tippy-placement': 'top', 'class': "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'))

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()

role_icon class-attribute instance-attribute 

role_icon = Column(verbose_name=gettext_lazy('Role'))

Meta

Bases: 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', 'lead', 'submit_time', 'last_update', 'screening_status', 'reviews_stats', 'organization_name')
template_name class-attribute instance-attribute 
template_name = 'funds/tables/table.html'
row_attrs class-attribute instance-attribute 
row_attrs = {'class': make_row_class, 'data-record-id': lambda record: id, 'data-archived': lambda record: is_archive}
attrs class-attribute instance-attribute 
attrs = {'class': 'all-submissions-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No submissions available')
sequence class-attribute instance-attribute 
sequence = fields + ('role_icon', 'comments')
orderable class-attribute instance-attribute 
orderable = False

render_user 

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

render_phase 

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

order_last_update 

order_last_update(qs, desc)
Source code in hypha/apply/funds/tables.py 
125
126
127
128
129
130
131
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 
133
134
135
136
137
138
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

render_lead 

render_lead(value)
Source code in hypha/apply/funds/tables.py 
194
195
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 
197
198
199
200
201
202
203
204
205
206
207
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_role_icon 

render_role_icon(value)
Source code in hypha/apply/funds/tables.py 
240
241
242
243
244
245
246
247
def render_role_icon(self, value):
    if value:
        image = CustomImage.objects.filter(id=value).first()
        if image:
            filter_spec = "fill-20x20"
            return generate_image_tag(image, filter_spec)

    return ""

Select2CheckboxWidgetMixin 

Select2CheckboxWidgetMixin(*args, **kwargs)

Bases: Filter

Source code in hypha/apply/funds/tables.py 
310
311
312
313
314
315
def __init__(self, *args, **kwargs):
    label = kwargs.get("label")
    kwargs.setdefault(
        "widget", Select2MultiCheckboxesWidget(attrs={"data-placeholder": label})
    )
    super().__init__(*args, **kwargs)

Select2MultipleChoiceFilter 

Select2MultipleChoiceFilter(*args, **kwargs)

Bases: Select2CheckboxWidgetMixin, MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
310
311
312
313
314
315
def __init__(self, *args, **kwargs):
    label = kwargs.get("label")
    kwargs.setdefault(
        "widget", Select2MultiCheckboxesWidget(attrs={"data-placeholder": label})
    )
    super().__init__(*args, **kwargs)

Select2ModelMultipleChoiceFilter 

Select2ModelMultipleChoiceFilter(*args, **kwargs)

Bases: Select2MultipleChoiceFilter, ModelMultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
310
311
312
313
314
315
def __init__(self, *args, **kwargs):
    label = kwargs.get("label")
    kwargs.setdefault(
        "widget", Select2MultiCheckboxesWidget(attrs={"data-placeholder": label})
    )
    super().__init__(*args, **kwargs)

StatusMultipleChoiceFilter 

StatusMultipleChoiceFilter(limit_to, *args, **kwargs)

Bases: Select2MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
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 
348
349
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 
351
352
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 
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
def __init__(self, *args, exclude=None, limit_statuses=None, **kwargs):
    if exclude is None:
        exclude = []

    qs = kwargs.get("queryset")

    archived = kwargs.pop("archived") if "archived" in kwargs.keys() else None
    if archived is not None:
        archived = int(archived) if archived else None

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

    reviewers_qs = get_reviewers_from_dataset(
        dataset=qs.exclude(reviewers__isnull=True)
    )
    if archived is not None and archived == 0:
        reviewers_qs = get_reviewers_from_dataset(
            dataset=qs.filter(is_archive=archived).exclude(reviewers__isnull=True)
        )
        qs = qs.filter(is_archive=archived)

    self.filters["fund"].queryset = get_used_funds_from_dataset(dataset=qs)
    self.filters["round"].queryset = get_used_rounds_from_dataset(dataset=qs)
    self.filters["lead"].queryset = get_round_leads_from_dataset(dataset=qs)
    self.filters[
        "screening_statuses"
    ].queryset = get_screening_statuses_from_dataset(dataset=qs)
    self.filters["reviewers"].queryset = reviewers_qs
    self.filters["meta_terms"].queryset = get_meta_terms_from_dataset(dataset=qs)

    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 = Select2ModelMultipleChoiceFilter(field_name='page', queryset=get_used_funds, label=gettext_lazy('Funds'))

round class-attribute instance-attribute 

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

lead class-attribute instance-attribute 

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

screening_statuses class-attribute instance-attribute 

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

reviewers class-attribute instance-attribute 

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

category_options class-attribute instance-attribute 

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

meta_terms class-attribute instance-attribute 

meta_terms = Select2ModelMultipleChoiceFilter(queryset=get_meta_terms, label=gettext_lazy('Terms'))

filters instance-attribute 

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

Meta

model class-attribute instance-attribute 
model = ApplicationSubmission
fields class-attribute instance-attribute 
fields = ('status', '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 
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
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 
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
def __init__(self, *args, exclude=None, limit_statuses=None, **kwargs):
    if exclude is None:
        exclude = []

    qs = kwargs.get("queryset")

    archived = kwargs.pop("archived") if "archived" in kwargs.keys() else None
    if archived is not None:
        archived = int(archived) if archived else None

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

    reviewers_qs = get_reviewers_from_dataset(
        dataset=qs.exclude(reviewers__isnull=True)
    )
    if archived is not None and archived == 0:
        reviewers_qs = get_reviewers_from_dataset(
            dataset=qs.filter(is_archive=archived).exclude(reviewers__isnull=True)
        )
        qs = qs.filter(is_archive=archived)

    self.filters["fund"].queryset = get_used_funds_from_dataset(dataset=qs)
    self.filters["round"].queryset = get_used_rounds_from_dataset(dataset=qs)
    self.filters["lead"].queryset = get_round_leads_from_dataset(dataset=qs)
    self.filters[
        "screening_statuses"
    ].queryset = get_screening_statuses_from_dataset(dataset=qs)
    self.filters["reviewers"].queryset = reviewers_qs
    self.filters["meta_terms"].queryset = get_meta_terms_from_dataset(dataset=qs)

    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 = Select2ModelMultipleChoiceFilter(field_name='page', queryset=get_used_funds, label=gettext_lazy('Funds'))

round class-attribute instance-attribute 

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

lead class-attribute instance-attribute 

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

screening_statuses class-attribute instance-attribute 

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

reviewers class-attribute instance-attribute 

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

category_options class-attribute instance-attribute 

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

meta_terms class-attribute instance-attribute 

meta_terms = Select2ModelMultipleChoiceFilter(queryset=get_meta_terms, label=gettext_lazy('Terms'))

filters instance-attribute 

filters = {field: _TFBrNfor (field, filter) in 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')

Meta

model class-attribute instance-attribute 
model = ApplicationSubmission
fields class-attribute instance-attribute 
fields = ('status', '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 
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
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)

search_data_and_id 

search_data_and_id(queryset, name, value)
Source code in hypha/apply/funds/tables.py 
460
461
462
463
464
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 
466
467
468
469
470
def filter_archived(self, queryset, name, value):
    if not value:
        # if value is 0 or None
        queryset = queryset.exclude(is_archive=True)
    return queryset

SubmissionDashboardFilter 

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

Bases: FilterSet

Source code in hypha/apply/funds/tables.py 
485
486
487
488
489
490
491
492
493
494
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 = Select2ModelMultipleChoiceFilter(queryset=get_used_rounds, label=gettext_lazy('Rounds'))

fund class-attribute instance-attribute 

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

filters instance-attribute 

filters = {field: _PpJ0Mfor (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')

SubmissionReviewerFilterAndSearch 

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

Bases: SubmissionDashboardFilter

Source code in hypha/apply/funds/tables.py 
485
486
487
488
489
490
491
492
493
494
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 = Select2ModelMultipleChoiceFilter(queryset=get_used_rounds, label=gettext_lazy('Rounds'))

fund class-attribute instance-attribute 

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

filters instance-attribute 

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

query class-attribute instance-attribute 

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

Meta

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

RoundsTable

Bases: Table

title class-attribute instance-attribute 

title = Column(linkify=lambda record: get_absolute_url(), orderable=True)

fund class-attribute instance-attribute 

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

lead class-attribute instance-attribute 

lead = Column()

start_date class-attribute instance-attribute 

start_date = Column()

end_date class-attribute instance-attribute 

end_date = Column()

progress class-attribute instance-attribute 

progress = Column(verbose_name=gettext_lazy('Determined'))

Meta

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

render_lead 

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

render_progress 

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

order_start_date 

order_start_date(qs, desc)
Source code in hypha/apply/funds/tables.py 
527
528
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 
530
531
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 
533
534
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 
536
537
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 
539
540
541
542
543
544
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: Select2MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
548
549
550
551
552
553
554
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 
556
557
558
559
560
561
562
563
564
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: Select2MultipleChoiceFilter

Source code in hypha/apply/funds/tables.py 
568
569
570
571
572
573
574
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 
576
577
578
579
580
581
582
583
584
585
586
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 = Select2ModelMultipleChoiceFilter(queryset=get_used_funds, label=gettext_lazy('Funds'))

lead class-attribute instance-attribute 

lead = Select2ModelMultipleChoiceFilter(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 
611
612
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 = Select2ModelMultipleChoiceFilter(field_name='pk', label=gettext_lazy('Reviewers'), queryset=get_all_reviewers)

funds class-attribute instance-attribute 

funds = Select2ModelMultipleChoiceFilter(field_name='submission__page', label=gettext_lazy('Funds'), queryset=get_used_funds)

rounds class-attribute instance-attribute 

rounds = Select2ModelMultipleChoiceFilter(field_name='submission__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={'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': 'all-reviews-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': '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': 'all-reviews-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': 'all-reviews-table'}
empty_text class-attribute instance-attribute 
empty_text = gettext_lazy('No staff available')

review_filter_for_user 

review_filter_for_user(user)
Source code in hypha/apply/funds/tables.py 
31
32
33
34
def review_filter_for_user(user):
    review_states = set(get_review_active_statuses(user))
    statuses = [name for name, status in STATUSES.items() if review_states & status]
    return [slugify(status) for status in statuses]

make_row_class 

make_row_class(record)
Source code in hypha/apply/funds/tables.py 
37
38
39
40
41
42
def make_row_class(record):
    css_class = (
        "submission-meta__row" if record.next else "all-submissions-table__parent"
    )
    css_class += "" if record.active else " is-inactive"
    return css_class

render_actions 

render_actions(table, record)
Source code in hypha/apply/funds/tables.py 
45
46
47
48
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 
51
52
53
54
55
56
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 
59
60
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 
250
251
def get_used_rounds(request):
    return Round.objects.filter(submissions__isnull=False).distinct()

get_used_rounds_from_dataset 

get_used_rounds_from_dataset(dataset)
Source code in hypha/apply/funds/tables.py 
254
255
def get_used_rounds_from_dataset(dataset):
    return Round.objects.filter(id__in=dataset.values("round")).distinct()

get_used_funds 

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

get_used_funds_from_dataset 

get_used_funds_from_dataset(dataset)
Source code in hypha/apply/funds/tables.py 
263
264
def get_used_funds_from_dataset(dataset):
    return Page.objects.filter(id__in=dataset.values("page")).distinct()

get_round_leads 

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

get_round_leads_from_dataset 

get_round_leads_from_dataset(dataset)
Source code in hypha/apply/funds/tables.py 
271
272
def get_round_leads_from_dataset(dataset):
    return User.objects.filter(id__in=dataset.values("lead")).distinct()

get_reviewers_from_dataset 

get_reviewers_from_dataset(dataset)

All assigned reviewers, not including Staff and Admin because we want a list of reviewers only

Source code in hypha/apply/funds/tables.py 
275
276
277
def get_reviewers_from_dataset(dataset):
    """All assigned reviewers, not including Staff and Admin because we want a list of reviewers only"""
    return User.objects.filter(id__in=dataset.values("reviewers")).distinct()

get_screening_statuses 

get_screening_statuses(request)
Source code in hypha/apply/funds/tables.py 
280
281
282
283
284
285
def get_screening_statuses(request):
    return ScreeningStatus.objects.filter(
        id__in=ApplicationSubmission.objects.all()
        .values("screening_statuses__id")
        .distinct("screening_statuses__id")
    )

get_screening_statuses_from_dataset 

get_screening_statuses_from_dataset(dataset)
Source code in hypha/apply/funds/tables.py 
288
289
290
291
def get_screening_statuses_from_dataset(dataset):
    return ScreeningStatus.objects.filter(
        id__in=dataset.values("screening_statuses__id")
    ).distinct()

get_meta_terms 

get_meta_terms(request)
Source code in hypha/apply/funds/tables.py 
294
295
296
297
298
299
300
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"),
    )

get_meta_terms_from_dataset 

get_meta_terms_from_dataset(dataset)
Source code in hypha/apply/funds/tables.py 
303
304
305
306
def get_meta_terms_from_dataset(dataset):
    return MetaTerm.objects.filter(
        filter_on_dashboard=True, id__in=dataset.values("meta_terms__id")
    ).distinct()