input = new CKInput();
//Set parent defaults
parent::__construct(array(
'singular' => 'accordeonmenuck', //singular name of the listed records
'plural' => 'accordeonmenucks', //plural name of the listed records
'ajax' => false //does this table support ajax?
));
}
/* * ******************************************************
* Added by Cedric KEIFLIN to get Data from the DB
* ******************************************************* */
function get_data() {
global $wpdb, $_wp_column_headers;
$screen = get_current_screen();
// -- Preparing your query --
$query = "SELECT * FROM " . $wpdb->prefix . "accordeonmenuck_styles";
// -- Ordering parameters --
//Parameters that are going to be used to order the result
$orderby = $this->input->get('orderby', 'ASC');
$order = $this->input->get('order', '');
if (!empty($orderby) & !empty($order)) {
$query.=' ORDER BY ' . $orderby . ' ' . $order;
}
// -- Pagination parameters --
//Number of elements in your table?
$totalitems = $wpdb->query($query); //return the total number of affected rows
//How many to display per page?
$perpage = 10;
//Which page is this?
$paged = $this->input->get('paged', '');
//Page Number
if (empty($paged) || !is_numeric($paged) || $paged <= 0) {
$paged = 1;
}
//How many pages do we have in total?
$totalpages = ceil($totalitems / $perpage);
//adjust the query to take pagination into account
if (!empty($paged) && !empty($perpage)) {
$offset = ($paged - 1) * $perpage;
$query.=' LIMIT ' . (int) $offset . ',' . (int) $perpage;
}
// -- Register the pagination --
$this->set_pagination_args(array(
"total_items" => $totalitems,
"total_pages" => $totalpages,
"per_page" => $perpage,
));
//The pagination links are automatically built according to those parameters
// -- Register the Columns --
$columns = $this->get_columns();
$_wp_column_headers[$screen->id] = $columns;
// -- Fetch the items --
// $this->items = $wpdb->get_results($query);
return $wpdb->get_results($query, OBJECT);
}
/** * ***********************************************************************
* Recommended. This method is called when the parent class can't find a method
* specifically build for a given column. Generally, it's recommended to include
* one method for each column you want to render, keeping your package class
* neat and organized. For example, if the class needs to process a column
* named 'title', it would first see if a method named $this->column_title()
* exists - if it does, that method will be used. If it doesn't, this one will
* be used. Generally, you should try to use custom column methods as much as
* possible.
*
* Since we have defined a column_title() method later on, this method doesn't
* need to concern itself with any column with a name of 'title'. Instead, it
* needs to handle everything else.
*
* For more detailed insight into how columns are handled, take a look at
* WP_List_Table::single_row_columns()
*
* @param array $item A singular item (one full row's worth of data)
* @param array $column_name The name/slug of the column to be processed
* @return string Text or HTML to be placed inside the column
* ************************************************************************ */
function column_default($item, $column_name) {
switch ($column_name) {
case 'name' :
return '' . $item->name . '';
// case 'mobilemenu' :
// return '[accordeonmenuck id=' . $item->id . ']';
default :
return $item->$column_name;
case 'debug' :
return print_r($item, true); //Show the whole array for troubleshooting purposes
}
}
/** * ***********************************************************************
* REQUIRED if displaying checkboxes or using bulk actions! The 'cb' column
* is given special treatment when columns are processed. It ALWAYS needs to
* have it's own method.
*
* @see WP_List_Table::::single_row_columns()
* @param array $item A singular item (one full row's worth of data)
* @return string Text to be placed inside the column
(movie title only)
* ************************************************************************ */
function column_cb($item) {
return sprintf(
'',
/* $1%s */ $this->_args['singular'], //Let's simply repurpose the table's singular label
/* $2%s */ $item->id //The value of the checkbox should be the record's id
);
}
/** * ***********************************************************************
* REQUIRED! This method dictates the table's columns and titles. This should
* return an array where the key is the column slug (and class) and the value
* is the column's title text. If you need a checkbox for bulk actions, refer
* to the $columns array below.
*
* The 'cb' column is treated differently than the rest. If including a checkbox
* column in your table you must create a column_cb() method. If you don't need
* bulk actions or checkboxes, simply leave the 'cb' entry out of your array.
*
* @see WP_List_Table::::single_row_columns()
* @return array An associative array containing column information: 'slugs'=>'Visible Titles'
* ************************************************************************ */
function get_columns() {
return $columns = array(
'cb' => '', //Render a checkbox instead of text
'name' => __('Name'),
// 'mobilemenu' => __('Mobilemenu'),
'id' => __('ID')
);
}
/** * ***********************************************************************
* Optional. If you want one or more columns to be sortable (ASC/DESC toggle),
* you will need to register it here. This should return an array where the
* key is the column that needs to be sortable, and the value is db column to
* sort by. Often, the key and value will be the same, but this is not always
* the case (as the value is a column name from the database, not the list table).
*
* This method merely defines which columns should be sortable and makes them
* clickable - it does not handle the actual sorting. You still need to detect
* the ORDERBY and ORDER querystring variables within prepare_items() and sort
* your data accordingly (usually by modifying your query).
*
* @return array An associative array containing all the columns that should be sortable: 'slugs'=>array('data_values',bool)
* ************************************************************************ */
function get_sortable_columns() {
return $sortable = array(
'id' => array('ID', false),
'name' => array('name', false)
// 'post_status' => array('post_status', false)
);
}
/** * ***********************************************************************
* Optional. If you need to include bulk actions in your list table, this is
* the place to define them. Bulk actions are an associative array in the format
* 'slug'=>'Visible Title'
*
* If this method returns an empty value, no bulk action will be rendered. If
* you specify any bulk actions, the bulk actions box will be rendered with
* the table automatically on display().
*
* Also note that list tables are not automatically wrapped in