def headers(self):
column_names = [c.prop_name for c in self.columns]
headers = DataTablesHeader(*self.columns)
# by default, sort by name, otherwise we fall back to the case_name hidden column
if "case_name" in column_names[1:]:
headers.custom_sort = [[column_names[1:].index("case_name") + 1, 'asc']]
elif "name" in column_names:
headers.custom_sort = [[column_names.index("name"), 'asc']]
else:
headers.custom_sort = [[0, 'asc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Username"),
prop_name='username.exact',
sql_col='user_dim__username'),
DataTablesColumn(_("Last Submission"),
prop_name='reporting_metadata.last_submissions.submission_date',
alt_prop_name='reporting_metadata.last_submission_for_user.submission_date',
sql_col='last_form_submission_date'),
DataTablesColumn(_("Last Sync"),
prop_name='reporting_metadata.last_syncs.sync_date',
alt_prop_name='reporting_metadata.last_sync_for_user.sync_date',
sql_col='last_sync_log_date'),
DataTablesColumn(_("Application"),
help_text=_("The name of the application from the user's last request."),
sortable=False),
DataTablesColumn(_("Application Version"),
help_text=_("The application version from the user's last request."),
prop_name='reporting_metadata.last_builds.build_version',
alt_prop_name='reporting_metadata.last_build_for_user.build_version',
sql_col='last_form_app_build_version'),
DataTablesColumn(_("CommCare Version"),
help_text=_("""The CommCare version from the user's last request"""),
prop_name='reporting_metadata.last_submissions.commcare_version',
alt_prop_name='reporting_metadata.last_submission_for_user.commcare_version',
sql_col='last_form_app_commcare_version'),
)
headers.custom_sort = [[1, 'desc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Sync Date"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("# of Cases"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Sync Duration"), sort_type=DTSortType.NUMERIC),
)
headers.custom_sort = [[0, 'desc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn('Select <a href="#" class="select-all btn btn-mini btn-inverse">all</a> <a href="#" class="select-none btn btn-mini btn-warning">none</a>', sortable=False, span=2),
DataTablesColumn("Case Name", span=3),
DataTablesColumn("Case Type", span=2),
DataTablesColumn("Owner", span=2),
DataTablesColumn("Last Modified", span=3, sort_type=DTSortType.NUMERIC)
)
headers.custom_sort = [[1, 'asc']]
return headers
def headers(self):
header = DataTablesHeader(
DataTablesColumn(_("Timestamp")),
DataTablesColumn(_("User Name")),
DataTablesColumn(_("Phone Number")),
DataTablesColumn(_("Direction")),
DataTablesColumn(_("Message")),
)
header.custom_sort = [[0, 'desc']]
return header
def headers(self):
header = DataTablesHeader(
DataTablesColumn('Date'),
DataTablesColumn('User'),
DataTablesColumn('Phone number'),
DataTablesColumn('Direction'),
DataTablesColumn('Text')
)
header.custom_sort = [[0, 'desc']]
return header
def headers(self):
if self.subreport_slug is None:
raise ValueError("Cannot render this report. A subreport_slug is required.")
header = DataTablesHeader(DataTablesColumn(_("FLW Name")))
for col in self.adm_report.columns:
sort_type = DTSortType.NUMERIC if hasattr(col, 'returns_numerical') and col.returns_numerical else None
help_text = _(col.description) if col.description else None
header.add_column(DataTablesColumn(_(col.name), sort_type=sort_type, help_text=help_text))
header.custom_sort = self.adm_report.default_sort_params
return header
def headers(self):
cols = [
DataTablesColumn(_("Message Text")),
DataTablesColumn(_("Risk Profile")),
]
for case in self.interactive_participants:
header_text = case.get_case_property("name_and_pid")
cols.append(DataTablesColumn(header_text))
header = DataTablesHeader(*cols)
header.custom_sort = [[1, "asc"]]
return header
def headers(self):
headers = DataTablesHeader(DataTablesColumn(_("View Form"), sortable=False),
DataTablesColumn(_("Username"), prop_name="username"),
DataTablesColumn(_("Submit Time"), prop_name="received_on"),
DataTablesColumn(_("Form Type"), sortable=False),
DataTablesColumn(_("Error Type"), sortable=False),
DataTablesColumn(_("Error Message"), sortable=False))
if self.support_toggle_enabled:
headers.add_column(DataTablesColumn(_("Re-process Form")))
headers.custom_sort = [[2, "desc"]]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Sync Date"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("# of Cases"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Sync Duration"), sort_type=DTSortType.NUMERIC)
)
if self.show_extra_columns:
headers.add_column(DataTablesColumn(_("Sync Log")))
headers.custom_sort = [[0, 'desc']]
return headers
def headers(self):
header = DataTablesHeader(
DataTablesColumn(_("Date")),
DataTablesColumn(_("Content"), sortable=False),
DataTablesColumn(_("Type"), sortable=False),
DataTablesColumn(_("Recipient"), sortable=False),
DataTablesColumn(_("Status"), sortable=False),
DataTablesColumn(_("Detail"), sortable=False),
)
header.custom_sort = [[0, "desc"]]
return header
def headers(self):
header = DataTablesHeader(
DataTablesColumn(_('Date')),
DataTablesColumn(_('Content'), sortable=False),
DataTablesColumn(_('Type'), sortable=False),
DataTablesColumn(_('Recipient'), sortable=False),
DataTablesColumn(_('Status'), sortable=False),
DataTablesColumn(_('Detail'), sortable=False),
)
header.custom_sort = [[0, 'desc']]
return header
def headers(self):
headers = DataTablesHeader(
DataTablesColumn("Name", span=3),
DataTablesColumn("Organization", span=2),
DataTablesColumn("Category", span=2),
DataTablesColumn("Copies", span=2),
DataTablesColumn("License", span=2),
DataTablesColumn("Last Modified", span=3, sort_type=DTSortType.NUMERIC)
)
headers.custom_sort = [[1, 'asc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Case Type"), prop_name="type.exact"),
DataTablesColumn(_("Name"), prop_name="name.exact"),
DataTablesColumn(_("Owner"), prop_name="owner_display", sortable=False),
DataTablesColumn(_("Created Date"), prop_name="opened_on"),
DataTablesColumn(_("Created By"), prop_name="opened_by_display", sortable=False),
DataTablesColumn(_("Modified Date"), prop_name="modified_on"),
DataTablesColumn(_("Status"), prop_name="get_status_display", sortable=False)
)
headers.custom_sort = [[5, 'desc']]
return headers
def headers(self):
header = DataTablesHeader(
DataTablesColumn(_("Participant ID")),
DataTablesColumn(_("Study Arm")),
DataTablesColumn(_("Originator")),
DataTablesColumn(_("Timestamp")),
DataTablesColumn(_("Message Text")),
DataTablesColumn(_("Message ID")),
DataTablesColumn(_("Direction")),
)
header.custom_sort = [[1, "asc"],[0, "asc"],[3, "asc"]]
return header
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Username")),
DataTablesColumn(_("Last Submission"),
sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Last Sync"),
sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Application (Deployed Version)"),
help_text=_("""Displays application version of the last submitted form;
The currently deployed version may be different."""))
)
headers.custom_sort = [[1, 'desc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Case Type"), prop_name="type.exact"),
DataTablesColumn(_("Name"), prop_name="name.exact"),
DataTablesColumn(_("Owner"),
prop_name="owner_display",
sortable=False),
DataTablesColumn(_("Created Date"), prop_name="opened_on"),
DataTablesColumn(_("Created By"),
prop_name="opened_by_display",
sortable=False),
DataTablesColumn(_("Modified Date"), prop_name="modified_on"),
DataTablesColumn(_("Status"),
prop_name="get_status_display",
sortable=False))
headers.custom_sort = [[5, 'desc']]
return headers
def headers(self):
cols = [
DataTablesColumn(_("PID")),
DataTablesColumn(_("Name")),
DataTablesColumn(_("Arm")),
DataTablesColumn(_("Week 1")),
DataTablesColumn(_("Week 2")),
DataTablesColumn(_("Week 3")),
DataTablesColumn(_("Week 4")),
DataTablesColumn(_("Week 5")),
DataTablesColumn(_("Week 6")),
DataTablesColumn(_("Week 7")),
DataTablesColumn(_("Week 8")),
]
header = DataTablesHeader(*cols)
header.custom_sort = [[0, "asc"]]
return header
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Sync Date"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("# of Cases"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Sync Duration"), sort_type=DTSortType.NUMERIC)
)
if self.show_extra_columns:
headers.add_column(DataTablesColumn(_("Sync Log")))
headers.add_column(DataTablesColumn(_("Sync Log Type")))
headers.add_column(DataTablesColumn(_("Previous Sync Log")))
headers.add_column(DataTablesColumn(_("Error Info")))
headers.add_column(DataTablesColumn(_("State Hash")))
headers.add_column(DataTablesColumn(_("Last Submitted")))
headers.add_column(DataTablesColumn(_("Last Cached")))
headers.custom_sort = [[0, 'desc']]
return headers
def headers(self):
cols = [
DataTablesColumn(_("PID")),
DataTablesColumn(_("Name")),
DataTablesColumn(_("Arm")),
DataTablesColumn(_("Week 1")),
DataTablesColumn(_("Week 2")),
DataTablesColumn(_("Week 3")),
DataTablesColumn(_("Week 4")),
DataTablesColumn(_("Week 5")),
DataTablesColumn(_("Week 6")),
DataTablesColumn(_("Week 7")),
DataTablesColumn(_("Week 8")),
]
header = DataTablesHeader(*cols)
header.custom_sort = [[0, "asc"]]
return header
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Sync Date"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("# of Cases"), sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Sync Duration"), sort_type=DTSortType.NUMERIC)
)
if self.show_extra_columns:
headers.add_column(DataTablesColumn(_("Sync Log")))
headers.add_column(DataTablesColumn(_("Sync Log Type")))
headers.add_column(DataTablesColumn(_("Previous Sync Log")))
headers.add_column(DataTablesColumn(_("Error Info")))
headers.add_column(DataTablesColumn(_("State Hash")))
headers.add_column(DataTablesColumn(_("Last Submitted")))
headers.add_column(DataTablesColumn(_("Last Cached")))
headers.custom_sort = [[0, 'desc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Username"),
prop_name='username.exact',
sql_col='user_dim__username'),
DataTablesColumn(
_("Last Submission"),
prop_name='reporting_metadata.last_submissions.submission_date',
alt_prop_name=
'reporting_metadata.last_submission_for_user.submission_date',
sql_col='last_form_submission_date'),
DataTablesColumn(
_("Last Sync"),
prop_name='reporting_metadata.last_syncs.sync_date',
alt_prop_name='reporting_metadata.last_sync_for_user.sync_date',
sql_col='last_sync_log_date'),
DataTablesColumn(
_("Application"),
help_text=_(
"The name of the application from the user's last request."
),
sortable=False),
DataTablesColumn(
_("Application Version"),
help_text=_(
"The application version from the user's last request."),
prop_name='reporting_metadata.last_builds.build_version',
alt_prop_name=
'reporting_metadata.last_build_for_user.build_version',
sql_col='last_form_app_build_version'),
DataTablesColumn(
_("CommCare Version"),
help_text=_(
"""The CommCare version from the user's last request"""),
prop_name=
'reporting_metadata.last_submissions.commcare_version',
alt_prop_name=
'reporting_metadata.last_submission_for_user.commcare_version',
sql_col='last_form_app_commcare_version'),
)
headers.custom_sort = [[1, 'desc']]
return headers
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Username")),
DataTablesColumn(_("Last Submission"),
sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Last Sync"),
sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("Application"),
help_text=_("Displays application of last submitted form")),
DataTablesColumn(_("Application Version"),
help_text=_("""Displays application version of the last submitted form;
The currently deployed version may be different."""),
sort_type=DTSortType.NUMERIC),
DataTablesColumn(_("CommCare Version"),
help_text=_("""Displays CommCare version the user last submitted with;
The currently deployed version may be different."""),
sort_type=DTSortType.NUMERIC),
)
headers.custom_sort = [[1, 'desc']]
return headers
def headers(self):
header_list = [
DataTablesColumn(_("Timestamp")),
DataTablesColumn(_("User Name")),
DataTablesColumn(_("Phone Number")),
DataTablesColumn(_("Direction")),
DataTablesColumn(_("Form")),
DataTablesColumn(_("View Submission")),
DataTablesColumn(_("Answered")),
DataTablesColumn(_("Duration")),
DataTablesColumn(_("Error")),
DataTablesColumn(_("Error Message")),
]
if self.request.couch_user.is_previewer():
header_list.append(DataTablesColumn(_("Gateway - Session Id")))
header = DataTablesHeader(*header_list)
header.custom_sort = [[0, 'desc']]
return header
def headers(self):
header_list = [
DataTablesColumn(_("Timestamp")),
DataTablesColumn(_("User Name")),
DataTablesColumn(_("Phone Number")),
DataTablesColumn(_("Direction")),
DataTablesColumn(_("Form")),
DataTablesColumn(_("View Submission")),
DataTablesColumn(_("Answered")),
DataTablesColumn(_("Duration")),
DataTablesColumn(_("Error")),
DataTablesColumn(_("Error Message")),
]
if self.request.couch_user.is_previewer():
header_list.append(DataTablesColumn(_("Gateway - Session Id")))
header = DataTablesHeader(*header_list)
header.custom_sort = [[0, 'desc']]
return header
def headers(self):
headers = DataTablesHeader(
DataTablesColumn(_("Username"), prop_name='username.exact'),
DataTablesColumn(
_("Last Submission"),
prop_name='reporting_metadata.last_submissions.submission_date',
alt_prop_name=
'reporting_metadata.last_submission_for_user.submission_date'),
DataTablesColumn(
_("Last Sync"),
prop_name='reporting_metadata.last_syncs.sync_date',
alt_prop_name='reporting_metadata.last_sync_for_user.sync_date'
),
DataTablesColumn(
_("Application"),
help_text=_("Displays application of last submitted form"),
sortable=False),
DataTablesColumn(
_("Application Version"),
help_text=_(
"Displays application version of the user's last sync."),
prop_name='reporting_metadata.last_builds.build_version',
alt_prop_name=
'reporting_metadata.last_build_for_user.build_version'),
DataTablesColumn(
_("CommCare Version"),
help_text=_(
"""Displays CommCare version the user last submitted with;
The currently deployed version may be different."""
),
prop_name=
'reporting_metadata.last_submissions.commcare_version',
alt_prop_name=
'reporting_metadata.last_submission_for_user.commcare_version'
),
)
headers.custom_sort = [[1, 'desc']]
return headers
def headers(self):
header = DataTablesHeader(*self.columns)
header.custom_sort = [[0, 'desc']]
return header
