core_reportbuilder\table\custom_report_table_view Class Reference

Inheritance diagram for core_reportbuilder\table\custom_report_table_view:

Public Member Functions
	download_buttons ()
	Get the html for the download buttons.
	format_row ($row)
	Format each row of returned data, executing defined callbacks for the row and each column.
	get_context ()
	Get the context for the table (that of the report persistent)
	get_default_per_page ()
	Override base implementation, return pagesize as defined in table filterset.
	get_row_cells_html (string $rowid, array $row, ?array $suppresslastrow)
	Override get_row_cells_html to add an extra cell with the toggle button for card view.
	get_sort_columns ()
	Get user preferred sort columns, overriding those of parent.
	get_sql_sort ()
	Override parent method of the same, to ensure that any columns with custom sort fields are accounted for.
	get_total_row_count ()
	Return total row count for report table.
	guess_base_url ()
	Set the base URL of the table to the current page URL.
	has_capability ()
	Check if the user has the capability to access this table.
	out ($pagesize, $useinitialsbar, $downloadhelpbutton='')
	Overriding this method to handle live editing setting.
	print_headers ()
	Override printed headers, to use those of grandparent class.
	print_nothing_to_display ()
	Override print_nothing_to_display to ensure that column headers are always added.
	query_db ($pagesize, $useinitialsbar=true)
	Override parent method of the same, to make use of a recordset and avoid issues with duplicate values in the first column.
	set_report_editing (bool $editing)
	Whether the current report table is being edited, in which case certain actions are not applied to it, e.g.
	start_html ()
	Override start of HTML to remove top pagination.
	wrap_html_finish ()
	Provide additional table debugging during editing.

Static Public Member Functions
static	create (int $reportid, string $download='')
	Return a new instance of the class for given report ID.

Protected Member Functions
	get_active_columns ()
	Get the columns of the custom report, returned instances being valid and available for the user.
	get_table_sql (bool $includesort=true)
	Generate suitable SQL for the table.
	init_sql (string $fields, string $from, array $joins, string $where, array $params, array $groupby=[])
	Initialises table SQL properties.

Protected Attributes
bool	$editing = false
	$editing
string	$groupbysql = ''
	$groupbysql
report	$persistent
	$persistent
datasource	$report
	$report
bool const	REPORT_EDITING = false
	We're pre/viewing the report, not editing it.

Member Function Documentation

create()

static core_reportbuilder\table\custom_report_table::create ( int $reportid, string $download = '' )

staticinherited

Return a new instance of the class for given report ID.

Parameters

int	$reportid
string	$download

Return values

static

download_buttons()

core_reportbuilder\table\custom_report_table_view::download_buttons

(

)

Get the html for the download buttons.

Return values

string

Reimplemented from core_reportbuilder\table\custom_report_table.

format_row()

core_reportbuilder\table\custom_report_table::format_row ( $row )

inherited

Format each row of returned data, executing defined callbacks for the row and each column.

Parameters

array | stdClass

$row

Return values

array

get_active_columns()

core_reportbuilder\table\custom_report_table::get_active_columns ( )

protectedinherited

Get the columns of the custom report, returned instances being valid and available for the user.

Return values

column[]

get_context()

core_reportbuilder\table\base_report_table::get_context ( )

inherited

Get the context for the table (that of the report persistent)

Return values

context

get_default_per_page()

core_reportbuilder\table\custom_report_table_view::get_default_per_page

(

)

Override base implementation, return pagesize as defined in table filterset.

Return values

int

get_row_cells_html()

core_reportbuilder\table\custom_report_table::get_row_cells_html ( string $rowid, array $row, ?array $suppresslastrow )

inherited

Override get_row_cells_html to add an extra cell with the toggle button for card view.

Parameters

string	$rowid
array	$row
array | null	$suppresslastrow

Return values

string

get_sort_columns()

core_reportbuilder\table\custom_report_table::get_sort_columns ( )

inherited

Get user preferred sort columns, overriding those of parent.

If user has no preferences then use report defaults

Return values

array

get_sql_sort()

core_reportbuilder\table\base_report_table::get_sql_sort ( )

inherited

Override parent method of the same, to ensure that any columns with custom sort fields are accounted for.

Because the base table_sql has "special" handling of fullname columns {

See also

table_sql::contains_fullname_columns}, we need to handle that here to ensure that any that are being sorted take priority over reportbuilders own aliases of the same columns. This prevents them appearing multiple times in a query, which SQL Server really doesn't like

Return values

string

get_table_sql()

core_reportbuilder\table\base_report_table::get_table_sql ( bool $includesort = true )

protectedinherited

Generate suitable SQL for the table.

Parameters

bool

$includesort

Return values

string

get_total_row_count()

core_reportbuilder\table\base_report_table::get_total_row_count ( )

inherited

Return total row count for report table.

Note we'd typically use {

See also

query_db} and then read the {

totalrows} property to reduce DB calls, however we can use this method when we specifically don't also need to obtain all data

Return values

int

has_capability()

core_reportbuilder\table\custom_report_table_view::has_capability

(

)

Check if the user has the capability to access this table.

Return values

bool	Return true if capability check passed.

Reimplemented from core_reportbuilder\table\custom_report_table.

init_sql()

core_reportbuilder\table\base_report_table::init_sql ( string $fields, string $from, array $joins, string $where, array $params, array $groupby = [] )

protectedinherited

Initialises table SQL properties.

Parameters

string	$fields
string	$from
array	$joins
string	$where
array	$params
array	$groupby

out()

core_reportbuilder\table\custom_report_table::out ( $pagesize, $useinitialsbar, $downloadhelpbutton = '' )

inherited

Overriding this method to handle live editing setting.

Parameters

int	$pagesize
bool	$useinitialsbar
string	$downloadhelpbutton

print_headers()

core_reportbuilder\table\custom_report_table_view::print_headers

(

)

Override printed headers, to use those of grandparent class.

Reimplemented from core_reportbuilder\table\custom_report_table.

print_nothing_to_display()

core_reportbuilder\table\custom_report_table::print_nothing_to_display ( )

inherited

Override print_nothing_to_display to ensure that column headers are always added.

Reimplemented from core_reportbuilder\table\base_report_table.

query_db()

core_reportbuilder\table\base_report_table::query_db ( $pagesize, $useinitialsbar = true )

inherited

Override parent method of the same, to make use of a recordset and avoid issues with duplicate values in the first column.

Parameters

int	$pagesize
bool	$useinitialsbar

set_report_editing()

core_reportbuilder\table\base_report_table::set_report_editing ( bool $editing )

inherited

Whether the current report table is being edited, in which case certain actions are not applied to it, e.g.

user filtering and sorting. Default class value is false

Parameters

bool

$editing

---

The documentation for this class was generated from the following file:

• reportbuilder/classes/table/custom_report_table_view.php