Skip to content

Tables

hypha.apply.projects.tables

BaseInvoiceTable

Bases: Table

invoice_number class-attribute instance-attribute 

invoice_number = LinkColumn('funds:projects:invoice-detail', verbose_name=gettext_lazy('Invoice #'), args=[A('project__submission__pk'), A('pk')], attrs={'td': {'class': 'js-title'}, 'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(attrs={'td': {'data-actions': render_invoice_actions, 'class': 'js-actions'}})

requested_at class-attribute instance-attribute 

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

invoice_date class-attribute instance-attribute 

invoice_date = DateColumn(verbose_name=gettext_lazy('Invoice date'))

project class-attribute instance-attribute 

project = Column(verbose_name=gettext_lazy('Project Title'), attrs={'td': {'class': 'max-w-md'}})

Meta

row_attrs class-attribute instance-attribute 
row_attrs = {'onclick': lambda record: f'window.location.href='{reverse('funds:projects:invoice-detail', args=[pk, pk])}'', 'class': 'table-row-link', 'role': 'button', 'tabindex': '0'}

render_requested_at 

render_requested_at(record)
Source code in hypha/apply/projects/tables.py 
58
59
60
61
62
63
def render_requested_at(self, record):
    return format_html(
        "<relative-time datetime='{}' prefix=''>{}</relative-time>",
        record.requested_at.isoformat(),
        record.requested_at.strftime(settings.SHORT_DATETIME_FORMAT),
    )

render_status 

render_status(record)
Source code in hypha/apply/projects/tables.py 
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
def render_status(self, record):
    status = record.status
    status_display = record.get_status_display()

    badge_class = {
        "changes_requested_staff": "badge-warning",
        "payment_failed": "badge-error",
        "paid": "badge-success",
        "declined": "badge-error",
    }

    return format_html(
        "<span class='badge badge-soft whitespace-nowrap {}' data-status='{}'>{}</span>",
        badge_class.get(status, "badge-info"),
        status,
        status_display,
    )

InvoiceDashboardTable

Bases: BaseInvoiceTable

invoice_number class-attribute instance-attribute 

invoice_number = LinkColumn('funds:projects:invoice-detail', verbose_name=gettext_lazy('Invoice #'), args=[A('project__submission__pk'), A('pk')], attrs={'td': {'class': 'js-title'}, 'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(attrs={'td': {'data-actions': render_invoice_actions, 'class': 'js-actions'}})

requested_at class-attribute instance-attribute 

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

invoice_date class-attribute instance-attribute 

invoice_date = DateColumn(verbose_name=gettext_lazy('Invoice date'))

project class-attribute instance-attribute 

project = Column(verbose_name=gettext_lazy('Project Title'), attrs={'td': {'class': 'max-w-md'}})

Meta

Bases: Meta

fields class-attribute instance-attribute 
fields = ['invoice_number', 'requested_at', 'status', 'project']
model class-attribute instance-attribute 
model = Invoice
order_by class-attribute instance-attribute 
order_by = ['-requested_at']
template_name class-attribute instance-attribute 
template_name = 'application_projects/tables/table.html'
attrs class-attribute instance-attribute 
attrs = {'class': 'table invoices-table invoivceDashboardTable'}
orderable class-attribute instance-attribute 
orderable = False
row_attrs class-attribute instance-attribute 
row_attrs = {'onclick': lambda record: f'window.location.href='{reverse('funds:projects:invoice-detail', args=[pk, pk])}'', 'class': 'table-row-link', 'role': 'button', 'tabindex': '0'}

render_project 

render_project(record)
Source code in hypha/apply/projects/tables.py 
98
99
def render_project(self, record):
    return get_project_title(record.project)

render_requested_at 

render_requested_at(record)
Source code in hypha/apply/projects/tables.py 
58
59
60
61
62
63
def render_requested_at(self, record):
    return format_html(
        "<relative-time datetime='{}' prefix=''>{}</relative-time>",
        record.requested_at.isoformat(),
        record.requested_at.strftime(settings.SHORT_DATETIME_FORMAT),
    )

render_status 

render_status(record)
Source code in hypha/apply/projects/tables.py 
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
def render_status(self, record):
    status = record.status
    status_display = record.get_status_display()

    badge_class = {
        "changes_requested_staff": "badge-warning",
        "payment_failed": "badge-error",
        "paid": "badge-success",
        "declined": "badge-error",
    }

    return format_html(
        "<span class='badge badge-soft whitespace-nowrap {}' data-status='{}'>{}</span>",
        badge_class.get(status, "badge-info"),
        status,
        status_display,
    )

FinanceInvoiceTable

Bases: BaseInvoiceTable

vendor_name class-attribute instance-attribute 

vendor_name = Column(verbose_name=gettext_lazy('Vendor Name'), empty_values=())

selected class-attribute instance-attribute 

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

invoice_number class-attribute instance-attribute 

invoice_number = LinkColumn('funds:projects:invoice-detail', verbose_name=gettext_lazy('Invoice #'), args=[A('project__submission__pk'), A('pk')], attrs={'td': {'class': 'js-title'}, 'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(attrs={'td': {'data-actions': render_invoice_actions, 'class': 'js-actions'}})

requested_at class-attribute instance-attribute 

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

invoice_date class-attribute instance-attribute 

invoice_date = DateColumn(verbose_name=gettext_lazy('Invoice date'))

project class-attribute instance-attribute 

project = Column(verbose_name=gettext_lazy('Project Title'), attrs={'td': {'class': 'max-w-md'}})

Meta

Bases: Meta

fields class-attribute instance-attribute 
fields = ['selected', 'invoice_number', 'invoice_date', 'vendor_name', 'status', 'requested_at', 'invoice_amount']
model class-attribute instance-attribute 
model = Invoice
orderable class-attribute instance-attribute 
orderable = True
sequence class-attribute instance-attribute 
sequence = fields
order_by class-attribute instance-attribute 
order_by = ['-requested_at', 'invoice_date']
template_name class-attribute instance-attribute 
template_name = 'application_projects/tables/table.html'
attrs class-attribute instance-attribute 
attrs = {'class': 'table border-x border-b mb-2 invoices-table'}
row_attrs class-attribute instance-attribute 
row_attrs = {'data-record-id': lambda record: id}

render_vendor_name 

render_vendor_name(record)
Source code in hypha/apply/projects/tables.py 
132
133
def render_vendor_name(self, record):
    return record.project.user

render_requested_at 

render_requested_at(record)
Source code in hypha/apply/projects/tables.py 
58
59
60
61
62
63
def render_requested_at(self, record):
    return format_html(
        "<relative-time datetime='{}' prefix=''>{}</relative-time>",
        record.requested_at.isoformat(),
        record.requested_at.strftime(settings.SHORT_DATETIME_FORMAT),
    )

render_status 

render_status(record)
Source code in hypha/apply/projects/tables.py 
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
def render_status(self, record):
    status = record.status
    status_display = record.get_status_display()

    badge_class = {
        "changes_requested_staff": "badge-warning",
        "payment_failed": "badge-error",
        "paid": "badge-success",
        "declined": "badge-error",
    }

    return format_html(
        "<span class='badge badge-soft whitespace-nowrap {}' data-status='{}'>{}</span>",
        badge_class.get(status, "badge-info"),
        status,
        status_display,
    )

AdminInvoiceListTable

Bases: BaseInvoiceTable

project class-attribute instance-attribute 

project = Column(verbose_name=gettext_lazy('Project Name'))

selected class-attribute instance-attribute 

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

invoice_number class-attribute instance-attribute 

invoice_number = LinkColumn('funds:projects:invoice-detail', verbose_name=gettext_lazy('Invoice #'), args=[A('project__submission__pk'), A('pk')], attrs={'td': {'class': 'js-title'}, 'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(attrs={'td': {'data-actions': render_invoice_actions, 'class': 'js-actions'}})

requested_at class-attribute instance-attribute 

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

invoice_date class-attribute instance-attribute 

invoice_date = DateColumn(verbose_name=gettext_lazy('Invoice date'))

Meta

Bases: Meta

fields class-attribute instance-attribute 
fields = ['selected', 'invoice_number', 'invoice_date', 'status', 'requested_at', 'project']
model class-attribute instance-attribute 
model = Invoice
orderable class-attribute instance-attribute 
orderable = True
sequence class-attribute instance-attribute 
sequence = fields
order_by class-attribute instance-attribute 
order_by = ['-requested_at']
template_name class-attribute instance-attribute 
template_name = 'application_projects/tables/table.html'
attrs class-attribute instance-attribute 
attrs = {'class': 'table border-x border-b mb-2 invoices-table'}
row_attrs class-attribute instance-attribute 
row_attrs = {'data-record-id': lambda record: id}

render_project 

render_project(record)
Source code in hypha/apply/projects/tables.py 
168
169
def render_project(self, record):
    return get_project_title(record.project)

render_requested_at 

render_requested_at(record)
Source code in hypha/apply/projects/tables.py 
58
59
60
61
62
63
def render_requested_at(self, record):
    return format_html(
        "<relative-time datetime='{}' prefix=''>{}</relative-time>",
        record.requested_at.isoformat(),
        record.requested_at.strftime(settings.SHORT_DATETIME_FORMAT),
    )

render_status 

render_status(record)
Source code in hypha/apply/projects/tables.py 
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
def render_status(self, record):
    status = record.status
    status_display = record.get_status_display()

    badge_class = {
        "changes_requested_staff": "badge-warning",
        "payment_failed": "badge-error",
        "paid": "badge-success",
        "declined": "badge-error",
    }

    return format_html(
        "<span class='badge badge-soft whitespace-nowrap {}' data-status='{}'>{}</span>",
        badge_class.get(status, "badge-info"),
        status,
        status_display,
    )

BaseProjectsTable

Bases: Table

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:project', args=[A('application_id')], attrs={'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(verbose_name=gettext_lazy('Status'), accessor='get_status_display', order_by=('status',))

fund class-attribute instance-attribute 

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

reporting class-attribute instance-attribute 

reporting = Column(verbose_name=gettext_lazy('Reporting'), accessor='pk')

last_payment_request class-attribute instance-attribute 

last_payment_request = RelativeTimeColumn()

end_date class-attribute instance-attribute 

end_date = RelativeTimeColumn(verbose_name=gettext_lazy('End date'), accessor='proposed_end')

order_reporting 

order_reporting(qs, is_descending)
Source code in hypha/apply/projects/tables.py 
190
191
192
193
194
195
def order_reporting(self, qs, is_descending):
    direction = "-" if is_descending else ""

    qs = qs.order_by(f"{direction}outstanding_reports")

    return qs, True

render_title 

render_title(record)
Source code in hypha/apply/projects/tables.py 
197
198
def render_title(self, record):
    return get_project_title(record)

render_reporting 

render_reporting(record)
Source code in hypha/apply/projects/tables.py 
200
201
202
203
204
205
206
207
208
209
210
211
212
213
def render_reporting(self, record):
    if not hasattr(record, "report_config"):
        return "-"

    if record.report_config.is_up_to_date():
        return "Up to date"

    if record.report_config.has_very_late_reports():
        display = f"<span class='text-red-500 inline-block align-text-bottom me-1'>{heroicon_outline(name='exclamation-triangle', size=20)}</span>"
    else:
        display = ""

    display += f"{record.report_config.outstanding_reports()} outstanding"
    return mark_safe(display)

ProjectsDashboardTable

Bases: BaseProjectsTable

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:project', args=[A('application_id')], attrs={'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(verbose_name=gettext_lazy('Status'), accessor='get_status_display', order_by=('status',))

fund class-attribute instance-attribute 

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

reporting class-attribute instance-attribute 

reporting = Column(verbose_name=gettext_lazy('Reporting'), accessor='pk')

last_payment_request class-attribute instance-attribute 

last_payment_request = RelativeTimeColumn()

end_date class-attribute instance-attribute 

end_date = RelativeTimeColumn(verbose_name=gettext_lazy('End date'), accessor='proposed_end')

Meta

fields class-attribute instance-attribute 
fields = ['title', 'status', 'fund', 'reporting', 'last_payment_request', 'end_date']
model class-attribute instance-attribute 
model = Project
template_name class-attribute instance-attribute 
template_name = 'application_projects/tables/table.html'
orderable class-attribute instance-attribute 
orderable = False
attrs class-attribute instance-attribute 
attrs = {'class': 'table projects-table'}

order_reporting 

order_reporting(qs, is_descending)
Source code in hypha/apply/projects/tables.py 
190
191
192
193
194
195
def order_reporting(self, qs, is_descending):
    direction = "-" if is_descending else ""

    qs = qs.order_by(f"{direction}outstanding_reports")

    return qs, True

render_title 

render_title(record)
Source code in hypha/apply/projects/tables.py 
197
198
def render_title(self, record):
    return get_project_title(record)

render_reporting 

render_reporting(record)
Source code in hypha/apply/projects/tables.py 
200
201
202
203
204
205
206
207
208
209
210
211
212
213
def render_reporting(self, record):
    if not hasattr(record, "report_config"):
        return "-"

    if record.report_config.is_up_to_date():
        return "Up to date"

    if record.report_config.has_very_late_reports():
        display = f"<span class='text-red-500 inline-block align-text-bottom me-1'>{heroicon_outline(name='exclamation-triangle', size=20)}</span>"
    else:
        display = ""

    display += f"{record.report_config.outstanding_reports()} outstanding"
    return mark_safe(display)

ProjectsAssigneeDashboardTable

Bases: BaseProjectsTable

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:project', args=[A('application_id')], attrs={'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(verbose_name=gettext_lazy('Status'), accessor='get_status_display', order_by=('status',))

fund class-attribute instance-attribute 

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

reporting class-attribute instance-attribute 

reporting = Column(verbose_name=gettext_lazy('Reporting'), accessor='pk')

last_payment_request class-attribute instance-attribute 

last_payment_request = RelativeTimeColumn()

end_date class-attribute instance-attribute 

end_date = RelativeTimeColumn(verbose_name=gettext_lazy('End date'), accessor='proposed_end')

Meta

fields class-attribute instance-attribute 
fields = ['title', 'fund', 'lead', 'reporting', 'last_payment_request', 'end_date']
model class-attribute instance-attribute 
model = Project
orderable class-attribute instance-attribute 
orderable = False
exclude class-attribute instance-attribute 
exclude = ['status']
attrs class-attribute instance-attribute 
attrs = {'class': 'table projects-table'}

order_reporting 

order_reporting(qs, is_descending)
Source code in hypha/apply/projects/tables.py 
190
191
192
193
194
195
def order_reporting(self, qs, is_descending):
    direction = "-" if is_descending else ""

    qs = qs.order_by(f"{direction}outstanding_reports")

    return qs, True

render_title 

render_title(record)
Source code in hypha/apply/projects/tables.py 
197
198
def render_title(self, record):
    return get_project_title(record)

render_reporting 

render_reporting(record)
Source code in hypha/apply/projects/tables.py 
200
201
202
203
204
205
206
207
208
209
210
211
212
213
def render_reporting(self, record):
    if not hasattr(record, "report_config"):
        return "-"

    if record.report_config.is_up_to_date():
        return "Up to date"

    if record.report_config.has_very_late_reports():
        display = f"<span class='text-red-500 inline-block align-text-bottom me-1'>{heroicon_outline(name='exclamation-triangle', size=20)}</span>"
    else:
        display = ""

    display += f"{record.report_config.outstanding_reports()} outstanding"
    return mark_safe(display)

PAFForReviewDashboardTable

Bases: Table

date_requested class-attribute instance-attribute 

date_requested = DateColumn(verbose_name=gettext_lazy('Date requested'), accessor='created_at', orderable=True)

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:project', args=[A('application_id')], orderable=False)

status class-attribute instance-attribute 

status = Column(verbose_name=gettext_lazy('Status'), accessor='pk', orderable=False)

fund class-attribute instance-attribute 

fund = Column(verbose_name=gettext_lazy('Fund'), accessor='project__submission__page', orderable=False)

assignee class-attribute instance-attribute 

assignee = Column(verbose_name=gettext_lazy('Assignee'), accessor='user', orderable=False)

Meta

fields class-attribute instance-attribute 
fields = ['date_requested', 'title', 'fund', 'status', 'assignee']
model class-attribute instance-attribute 
model = PAFApprovals
template_name class-attribute instance-attribute 
template_name = 'funds/tables/table.html'
attrs class-attribute instance-attribute 
attrs = {'class': 'table paf-review-table'}

order_date_requested 

order_date_requested(qs, is_descending)
Source code in hypha/apply/projects/tables.py 
276
277
278
279
280
281
def order_date_requested(self, qs, is_descending):
    direction = "-" if is_descending else ""

    qs = qs.order_by(f"{direction}created_at")

    return qs, True

render_status 

render_status(record)
Source code in hypha/apply/projects/tables.py 
283
284
285
286
287
def render_status(self, record):
    if record.user:
        return _("Waiting for approval")
    else:
        return _("Waiting for assignee")

render_title 

render_title(record)
Source code in hypha/apply/projects/tables.py 
289
290
def render_title(self, record):
    return get_project_title(record.project)

ProjectsListTable

Bases: BaseProjectsTable

title class-attribute instance-attribute 

title = LinkColumn('funds:submissions:project', args=[A('application_id')], attrs={'a': {'class': 'link link-hover text-h4 font-semibold break-words line-clamp-2 max-w-md'}})

status class-attribute instance-attribute 

status = Column(verbose_name=gettext_lazy('Status'), accessor='get_status_display', order_by=('status',))

fund class-attribute instance-attribute 

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

reporting class-attribute instance-attribute 

reporting = Column(verbose_name=gettext_lazy('Reporting'), accessor='pk')

last_payment_request class-attribute instance-attribute 

last_payment_request = RelativeTimeColumn()

end_date class-attribute instance-attribute 

end_date = RelativeTimeColumn(verbose_name=gettext_lazy('End date'), accessor='proposed_end')

Meta

fields class-attribute instance-attribute 
fields = ['title', 'status', 'lead', 'fund', 'reporting', 'last_payment_request', 'end_date']
model class-attribute instance-attribute 
model = Project
orderable class-attribute instance-attribute 
orderable = True
order_by class-attribute instance-attribute 
order_by = ('end_date',)
template_name class-attribute instance-attribute 
template_name = 'application_projects/tables/table.html'
attrs class-attribute instance-attribute 
attrs = {'class': 'table projects-table'}

order_reporting 

order_reporting(qs, is_descending)
Source code in hypha/apply/projects/tables.py 
190
191
192
193
194
195
def order_reporting(self, qs, is_descending):
    direction = "-" if is_descending else ""

    qs = qs.order_by(f"{direction}outstanding_reports")

    return qs, True

render_title 

render_title(record)
Source code in hypha/apply/projects/tables.py 
197
198
def render_title(self, record):
    return get_project_title(record)

render_reporting 

render_reporting(record)
Source code in hypha/apply/projects/tables.py 
200
201
202
203
204
205
206
207
208
209
210
211
212
213
def render_reporting(self, record):
    if not hasattr(record, "report_config"):
        return "-"

    if record.report_config.is_up_to_date():
        return "Up to date"

    if record.report_config.has_very_late_reports():
        display = f"<span class='text-red-500 inline-block align-text-bottom me-1'>{heroicon_outline(name='exclamation-triangle', size=20)}</span>"
    else:
        display = ""

    display += f"{record.report_config.outstanding_reports()} outstanding"
    return mark_safe(display)

render_invoice_actions 

render_invoice_actions(table, record)
Source code in hypha/apply/projects/tables.py 
21
22
23
24
def render_invoice_actions(table, record):
    user = table.context["user"]
    actions = get_invoice_possible_transition_for_user(user, invoice=record)
    return json.dumps([str(slugify(action)) for action, _ in actions])