'item', //singular name of the listed records
'plural' => 'items', //plural name of the listed records
'ajax' => false //does this table support ajax?
) );
}
function getAllRecords(){
global $wpdb;
global $table_admin_menu;
$adminMenuList = $wpdb->get_results("SELECT * FROM ".$table_admin_menu ." ORDER BY id desc");
$i=0;
foreach ( $adminMenuList as $adminMenu ) {
$adminMenuArray[$i]['id'] = $adminMenu->id;
$adminMenuArray[$i]['page_title'] = $adminMenu->page_title;
$adminMenuArray[$i]['menu_title'] = $adminMenu->menu_title;
$adminMenuArray[$i]['admin_menu_created_date'] = $adminMenu->admin_menu_created_date;
$i++;
}
return $adminMenuArray;
}
function column_default($item, $column_name){
switch($column_name){
case 'id':
case 'page_title':
case 'menu_title':
case 'admin_menu_created_date':
return $item[$column_name];
default:
return print_r($item,true); //Show the whole array for troubleshooting purposes
}
}
function column_title($item){
//Build row actions
$actions = array(
'edit' => sprintf(
'Edit','admin-menu-listing','edit',$item['id']
),
'delete' => sprintf(
'Delete','admin-menu-listing','delete',$item['id']
),
);
//Return the cattitle contents
return sprintf('%1$s %2$s',
/*$1%s*/ $item['id'],
/*$3%s*/ $this->row_actions($actions)
);
}
function column_cb($item){
return sprintf(
'',
/*$1%s*/ $this->_args['singular'], //Let's simply repurpose the table's singular label ("movie")
/*$2%s*/ $item['id'] //The value of the checkbox should be the record's id
);
}
function get_columns(){
$columns = array(
'cb' => '', //Render a checkbox instead of text
'title' => 'Id',
'page_title' => 'Page Title',
'menu_title' => 'Menu Title',
'admin_menu_created_date' => 'Created Date',
);
return $columns;
}
function get_sortable_columns() {
$sortable_columns = array(
'id' => array('id',false)
);
return $sortable_columns;
}
function get_bulk_actions() {
$actions = array(
'delete' => 'Delete'
);
return $actions;
}
function process_bulk_action() {
if( 'delete'===$this->current_action() ) {
wp_die('Items deleted (or they would be if we had items to delete)!');
}
}
function prepare_items() {
global $wpdb; //This is used only if making any database queries
/**
* First, lets decide how many records per page to show
*/
$per_page = 10;
$example_data = $this->getAllRecords();
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
$this->process_bulk_action();
$data = $this->getAllRecords();
function usort_reorder($a,$b){
$orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : 'id'; //If no sort, default to title
$order = (!empty($_REQUEST['order'])) ? $_REQUEST['order'] : 'desc'; //If no order, default to asc
$result = strcmp($a[$orderby], $b[$orderby]); //Determine sort order
return ($order==='desc') ? $result : -$result; //Send final sort direction to usort
}
@usort($data, 'usort_reorder');
$current_page = $this->get_pagenum();
$total_items = count($data);
$data = @array_slice($data,(($current_page-1)*$per_page),$per_page);
$this->items = $data;
$this->set_pagination_args( array(
'total_items' => $total_items, //WE have to calculate the total number of items
'per_page' => $per_page, //WE have to determine how many items to show on a page
'total_pages' => ceil($total_items/$per_page) //WE have to calculate the total number of pages
) );
}
}
$menu = new AMC_List_Table();
$menu->prepare_items();
?>