';
if (count($this->form_actions) > 0)
{
$html .= '';
$params = $this->get_sortable_table_param_string().'&'.$this->get_additional_url_paramstring();
$html .= '';
}
}
echo $html;
}
/**
* Get the HTML-code with the navigational buttons to browse through the
* data-pages.
*/
public function get_navigation_html () {
$pager = $this->get_pager();
$pager_links = $pager->getLinks();
$showed_items = $pager->getOffsetByPageId();
$nav = $pager_links['first'].' '.$pager_links['back'];
$nav .= ' '.$pager->getCurrentPageId().' / '.$pager->numPages().' ';
$nav .= $pager_links['next'].' '.$pager_links['last'];
return $nav;
}
/**
* Get the HTML-code with the data-table.
*/
public function get_table_html () {
$pager = $this->get_pager();
$val = $pager->getOffsetByPageId();
$offset = $pager->getOffsetByPageId();
$from = $offset[0] - 1;
$table_data = $this->get_table_data($from);
if (is_array($table_data))
{
foreach ($table_data as $index => $row)
{
$row = $this->filter_data($row);
$this->addRow($row);
}
}
$this->altRowAttributes(0, array ('class' => 'row_odd'), array ('class' => 'row_even'), true);
foreach ($this->th_attributes as $column => $attributes)
{
$this->setCellAttributes(0, $column, $attributes);
}
foreach ($this->td_attributes as $column => $attributes)
{
$this->setColAttributes($column, $attributes);
}
return $this->toHTML();
}
/**
* Get the HTML-code wich represents a form to select how many items a page
* should contain.
*/
public function get_page_select_form () {
$total_number_of_items = $this->get_total_number_of_items();
if ($total_number_of_items <= $this->default_items_per_page)
{
return '';
}
$result[] = '';
$result = implode("\n", $result);
return $result;
}
/**
* Get the table title.
*/
public function get_table_title () {
$pager = $this->get_pager();
$showed_items = $pager->getOffsetByPageId();
return $showed_items[0].' - '.$showed_items[1].' / '.$this->get_total_number_of_items();
}
/**
* Set the header-label
* @param int $column The column number
* @param string $label The label
* @param boolean $sortable Is the table sortable by this column? (defatult
* = true)
* @param string $th_attributes Additional attributes for the th-tag of the
* table header
* @param string $td_attributes Additional attributes for the td-tags of the
* column
*/
public function set_header ($column, $label, $sortable = true, $th_attributes = null, $td_attributes = null) {
$param['direction'] = 'ASC';
if ($this->column == $column && $this->direction == 'ASC') {
$param['direction'] = 'DESC';
}
$param['page_nr'] = $this->page_nr;
$param['per_page'] = $this->per_page;
$param['column'] = $column;
if ($sortable) {
$link = ''.$label.'';
if ($this->column == $column)
{
$link .= $this->direction == 'ASC' ? ' ↓' : ' ↑';
}
}
else
{
$link = $label;
}
$this->setHeaderContents(0, $column, $link);
if (!is_null($td_attributes))
{
$this->td_attributes[$column] = $td_attributes;
}
if (!is_null($th_attributes))
{
$this->th_attributes[$column] = $th_attributes;
}
}
/**
* Get the parameter-string with additional parameters to use in the URLs
* generated by this SortableTable
*/
public function get_additional_url_paramstring () {
$param_string_parts = array ();
if(is_array($this->additional_parameters) && count($this->additional_parameters)>0)
{
foreach ($this->additional_parameters as $key => $value)
{
$param_string_parts[] = urlencode($key).'='.urlencode($value);
}
}
$result = implode('&', $param_string_parts);
foreach($this->other_tables as $index => $tablename) {
$param = array();
if( isset($_GET[$tablename.'_direction'])) {
//$param[$tablename.'_direction'] = $_GET[$tablename.'_direction'];
$my_get_direction = $_GET[$tablename.'_direction'];
if(!in_array($my_get_direction ,array('ASC','DESC'))){
$param[$tablename.'_direction'] = 'ASC';
} else {
$param[$tablename.'_direction'] = $my_get_direction;
}
}
if( isset($_GET[$tablename.'_page_nr']))
$param[$tablename.'_page_nr'] = intval($_GET[$tablename.'_page_nr']);
if( isset($_GET[$tablename.'_per_page']))
$param[$tablename.'_per_page'] = intval($_GET[$tablename.'_per_page']);
if( isset($_GET[$tablename.'_column']))
$param[$tablename.'_column'] = intval($_GET[$tablename.'_column']);
$param_string_parts = array ();
foreach ($param as $key => $value) {
$param_string_parts[] = urlencode($key).'='.urlencode($value);
}
if(count($param_string_parts) > 0)
$result .= '&'.implode('&', $param_string_parts);
}
return $result;
}
/**
* Get the parameter-string with the SortableTable-related parameters to use
* in URLs
*/
public function get_sortable_table_param_string () {
$param[$this->param_prefix.'direction'] = $this->direction;
$param[$this->param_prefix.'page_nr'] = $this->page_nr;
$param[$this->param_prefix.'per_page'] = $this->per_page;
$param[$this->param_prefix.'column'] = $this->column;
$param_string_parts = array ();
foreach ($param as $key => $value) {
$param_string_parts[] = urlencode($key).'='.urlencode($value);
}
$res = implode('&', $param_string_parts);
return $res;
}
/**
* Add a filter to a column. If another filter was allready defined for the
* given column, it will be overwritten.
* @param int $column The number of the column
* @param string $function The name of the filter-function. This should be a
* function wich requires 1 parameter and returns the filtered value.
*/
public function set_column_filter ($column, $function) {
$this->column_filters[$column] = $function;
}
/**
* Define a list of actions which can be performed on the table-date.
* If you define a list of actions, the first column of the table will be
* converted into checkboxes.
* @param array $actions A list of actions. The key is the name of the
* action. The value is the label to show in the select-box
* @param string $checkbox_name The name of the generated checkboxes. The
* value of the checkbox will be the value of the first column.
*/
public function set_form_actions ($actions, $checkbox_name = 'id') {
$this->form_actions = $actions;
$this->checkbox_name = $checkbox_name;
}
/**
* Define a list of additional parameters to use in the generated URLs
* @param array $parameters
*/
public function set_additional_parameters ($parameters) {
$this->additional_parameters = $parameters;
}
/**
* Set other tables on the same page.
* If you have other sortable tables on the page displaying this sortable
* tables, you can define those other tables with this function. If you
* don't define the other tables, there sorting and pagination will return
* to their default state when sorting this table.
* @param array $tablenames An array of table names.
*/
public function set_other_tables ($tablenames) {
$this->other_tables = $tablenames;
}
/**
* Transform all data in a table-row, using the filters defined by the
* function set_column_filter(...) defined elsewhere in this class.
* If you've defined actions, the first element of the given row will be
* converted into a checkbox
* @param array $row A row from the table.
*/
public function filter_data ($row) {
$url_params = $this->get_sortable_table_param_string().'&'.$this->get_additional_url_paramstring();
foreach ($this->column_filters as $column => $function)
{
$row[$column] = call_user_func($function, $row[$column], $url_params, $row);
}
if (count($this->form_actions) > 0) {
if (strlen($row[0]) > 0) {
$row[0] = 'param_prefix.'selectall'])) {
$row[0] .= ' checked="checked"';
}
$row[0] .= '/>';
}
}
foreach ($row as $index => $value) {
if (strlen($row[$index]) == 0)
{
$row[$index] = '-';
}
}
return $row;
}
/**
* Get the total number of items. This function calls the function given as
* 2nd argument in the constructor of a SortableTable. Make sure your
* function has the same parameters as defined here.
*/
public function get_total_number_of_items () {
if ($this->total_number_of_items == -1 && !is_null($this->get_total_number_function)) {
$this->total_number_of_items = call_user_func($this->get_total_number_function);
}
return $this->total_number_of_items;
}
/**
* Get the data to display. This function calls the function given as
* 2nd argument in the constructor of a SortableTable. Make sure your
* function has the same parameters as defined here.
* @param int $from Index of the first item to return.
* @param int $per_page The number of items to return
* @param int $column The number of the column on which the data should be
* sorted
* @param string $direction In which order should the data be sorted (ASC
* or DESC)
*/
public function get_table_data ($from = null, $per_page = null, $column = null, $direction = null) {
if (!is_null($this->get_data_function))
{
return call_user_func($this->get_data_function, $from, $this->per_page, $this->column, $this->direction);
}
return array ();
}
}
/**
* Sortable table which can be used for data available in an array
*/
class SortableTableFromArray extends SortableTable {
/**
* The array containing all data for this table
*/
public $table_data;
/**
* Constructor
* @param array $table_data
* @param int $default_column
* @param int $default_items_per_page
*/
public function __construct ($table_data, $default_column = 1, $default_items_per_page = 20, $tablename = 'tablename') {
parent :: __construct ($tablename, null, null, $default_column, $default_items_per_page);
$this->table_data = $table_data;
}
/**
* Get table data to show on current page
* @see SortableTable#get_table_data
*/
public function get_table_data ($from = 1) {
$content = TableSort :: sort_table($this->table_data, $this->column, $this->direction == 'ASC' ? SORT_ASC : SORT_DESC);
return array_slice($content, $from, $this->per_page);
}
/**
* Get total number of items
* @see SortableTable#get_total_number_of_items
*/
public function get_total_number_of_items() {
return count($this->table_data);
}
}
/**
* Sortable table which can be used for data available in an array
*
* Is a variation of SortableTableFromArray because we add 2 new arrays $column_show and $column_order
* $column_show is an array that lets us decide which are going to be the columns to show
* $column_order is an array that lets us decide the ordering of the columns
* i.e: $column_header=array('a','b','c','d','e'); $column_order=array(1,2,5,4,5);
* These means that the 3th column (letter "c") will be sort like the order we use in the 5th column
*/
class SortableTableFromArrayConfig extends SortableTable {
/**
* The array containing the columns that will be show i.e $column_show=array('1','0','0'); we will show only the 1st column
*/
private $column_show;
/**
*The array containing the real sort column $column_order=array('1''4','3','4'); The 2nd column will be order like the 4th column
*/
private $column_order;
/**
* The array containing all data for this table
*/
private $table_data;
/**
* Constructor
* @param array $table_data All the information of the table
* @param int $default_column Default column that will be use in the sorts functions
* @param int $default_items_per_page quantity of pages that we are going to see
* @param int $tablename Name of the table
* @param array $column_show An array with binary values 1: we show the column 2: we don't show it
* @param array $column_order An array of integers that let us decide how the columns are going to be sort.
*/
public function __construct ($table_data, $default_column = 1, $default_items_per_page = 20, $tablename = 'tablename',$column_show=null,$column_order=null,$direction='ASC') {
$this->column_show=$column_show;
$this->column_order=$column_order;
parent :: __construct ($tablename, null, null, $default_column, $default_items_per_page,$direction);
$this->table_data = $table_data;
}
/**
* Get table data to show on current page
* @see SortableTable#get_table_data
*/
public function get_table_data($from = 1) {
$content = TableSort :: sort_table_config($this->table_data, $this->column, $this->direction == 'ASC' ? SORT_ASC : SORT_DESC ,$this->column_show, $this->column_order);
return array_slice($content, $from, $this->per_page);
}
/**
* Get total number of items
* @see SortableTable#get_total_number_of_items
*/
public function get_total_number_of_items () {
return count($this->table_data);
}
}
?>