class Items extends WP_List_Table {

											public function __construct() {

												parent::__construct( [
													'singular' => __( 'Item', 'bs' ),
													'plural'   => __( 'Items', 'bs' ),
													'ajax'     => false
												] );
										}
									
								

									
										/**
										 * Retrieve items data from the database
										 *
										 * @param int $per_page
										 * @param int $page_number
										 *
										 * @return mixed
										 */
										public static function get_items( $per_page = 5, $page_number = 1 ) {

											global $wpdb;

											$sql = "SELECT * FROM {$wpdb->prefix}items";

											if ( ! empty( $_REQUEST['orderby'] ) ) {
											$sql .= ' ORDER BY ' . esc_sql( $_REQUEST['orderby'] );
											$sql .= ! empty( $_REQUEST['order'] ) ? ' ' . esc_sql( $_REQUEST['order'] ) : ' ASC';
											}

											$sql .= " LIMIT $per_page";

											$sql .= ' OFFSET ' . ( $page_number - 1 ) * $per_page;


											$result = $wpdb->get_results( $sql, 'ARRAY_A' );

											return $result;
										}
									
								

									
										/**
										 * Delete a item record.
										 *
										 * @param int $id item ID
										 */
										public static function delete_item( $id ) {
											global $wpdb;

											$wpdb->delete(
											"{$wpdb->prefix}items",
											[ 'ID' => $id ],
											[ '%d' ]
											);
										}
									
								

									
										/**
										 * Returns the count of records in the database.
										 *
										 * @return null|string
										 */
										public static function record_count() {
											global $wpdb;

											$sql = "SELECT COUNT(*) FROM {$wpdb->prefix}items";

											return $wpdb->get_var( $sql );
										}
									
								

									
										/** Text displayed when no item data is available */
										public function no_items() {
											_e( 'No items avaliable.', 'bs' );
										}
									
								

									
										/**
										 * Method for name column
										 *
										 * @param array $item an array of DB data
										 *
										 * @return string
										 */
										function column_name( $item ) {

											// create a nonce
											$delete_nonce = wp_create_nonce( 'bs_delete_item' );

											$title = '' . $item['name'] . '';

											$actions = [
											'delete' => sprintf( 'Delete', esc_attr( $_REQUEST['page'] ), 'delete', absint( $item['ID'] ), $delete_nonce )
											];

											return $title . $this->row_actions( $actions );
										}
									
								

									
										/**
										 * Render a column when no column specific method exists.
										 *
										 * @param array $item
										 * @param string $column_name
										 *
										 * @return mixed
										 */
										public function column_default( $item, $column_name ) {
											switch ( $column_name ) {
											case 'name':
											case 'manufacturer':
												return $item[ $column_name ];
											default:
												return print_r( $item, true ); //Show the whole array for troubleshooting purposes
											}
										}
									
								

									
										/**
										 * Render the bulk edit checkbox
										 *
										 * @param array $item
										 *
										 * @return string
										 */
										function column_cb( $item ) {
											return sprintf(
											'', $item['ID']
											);
										}
									
								

									
										/**
										 *  Associative array of columns
										 *
										 * @return array
										 */
										function get_columns() {
											$columns = [
											'cb'      => '',
											'name'    => __( 'Name', 'bs' ),
											'manufacturer' => __( 'Manufacturer', 'bs' ),
											'price'    => __( 'Price', 'bs' )
											];

											return $columns;
										}
									
								

									
										/**
										 * Columns to make sortable.
										 *
										 * @return array
										 */
										public function get_sortable_columns() {
											$sortable_columns = array(
											'name' => array( 'name', true ),
											'manufacturer' => array( 'manufacturer', false )
											'price' => array( 'price', false )
											);

											return $sortable_columns;
										}
									
								

									
										/**
										 * Returns an associative array containing the bulk action
										 *
										 * @return array
										 */
										public function get_bulk_actions() {
											$actions = [
											'bulk-delete' => 'Delete'
											];

											return $actions;
										}
									
								

									
										/**
										 * Handles data query and filter, sorting, and pagination.
										 */
										public function prepare_items() {

											$this->_column_headers = $this->get_column_info();

											/** Process bulk action */
											$this->process_bulk_action();

											$per_page     = $this->get_items_per_page( 'items_per_page', 5 );
											$current_page = $this->get_pagenum();
											$total_items  = self::record_count();

											$this->set_pagination_args( [
											'total_items' => $total_items,
											'per_page'    => $per_page
											] );


											$this->items = self::get_items( $per_page, $current_page );
										}
									
								

									
										public function process_bulk_action() {

											// Detect when a bulk action is being triggered...
											if ( 'delete' === $this->current_action() ) {

											// In our file that handles the request, verify the nonce.
											$nonce = esc_attr( $_REQUEST['_wpnonce'] );

											if ( ! wp_verify_nonce( $nonce, 'bs_delete_item' ) ) {
												die( 'Go get a life script kiddies' );
											}
											else {
												self::delete_item( absint( $_GET['item'] ) );

												wp_redirect( esc_url( add_query_arg() ) );
												exit;
											}

											}

											// If the delete bulk action is triggered
											if ( ( isset( $_POST['action'] ) && $_POST['action'] == 'bulk-delete' ) || ( isset( $_POST['action2'] ) && $_POST['action2'] == 'bulk-delete' ) ) {

											$delete_ids = esc_sql( $_POST['bulk-delete'] );

											// loop over the array of record IDs and delete them
											foreach ( $delete_ids as $id ) {
												self::delete_item( $id );

											}

											wp_redirect( esc_url( add_query_arg() ) );
											exit;
											}
										}