NirjharLo\WP_Plugin_Framework\Lib\Table

Complexity

Total Complexity

27

Size/Duplication

Total Lines	252
Duplicated Lines	0 %

Importance

Changes	1
Bugs	1	Features	0

13 Methods

Rating	Name	Duplication	Size	Complexity
A	get_sortable_columns()	0	9	1
A	__construct()	0	6	1
A	get_bulk_actions()	0	5	1
A	no_items()	0	3	1
A	column_cb()	0	3	1
A	get_Table()	0	23	4
A	delete_url()	0	5	1
A	column_name()	0	11	1
A	column_default()	0	16	5
A	record_count()	0	12	2
A	get_columns()	0	11	1
B	process_bulk_action()	0	21	7
A	prepare_items()	0	21	1

<?php
namespace NirjharLo\WP_Plugin_Framework\Lib;

/**
 * Implimentation of WordPress inbuilt functions for creating an extension of a default table class.
 *
 * $my_plugin_name_table = new PLUGIN_TABLE();
 * $my_plugin_name_table->prepare_items();
 * $my_plugin_name_table->display();
 *
 * @author     Nirjhar Lo
 * @package    wp-plugin-framework
 */
if ( ! class_exists( 'Table' ) ) {

	if ( ! class_exists( 'WP_List_Table' ) ) {
    	require_once( ABSPATH . 'wp-admin/includes/screen.php' );

The constant NirjharLo\WP_Plugin_Framework\Lib\ABSPATH was not found. Maybe you did not declare it correctly or list all dependencies?

    	require_once( ABSPATH . 'wp-admin/includes/class-wp-list-table.php' );
	}

	final class Table extends WP_List_Table {

The type NirjharLo\WP_Plugin_Framework\Lib\WP_List_Table was not found. Maybe you did not declare it correctly or list all dependencies?

		/**
		 * Instantiate the table
		 *
		 * @return Void
		 */
		public function __construct() {

			parent::__construct( [
				'singular' => __( 'Name', 'textdomain' ),

The function __ was not found. Maybe you did not declare it correctly or list all dependencies?

				'plural'   => __( 'Names', 'textdomain' ),
				'ajax'     => false,
			] );
		}


		/**
		 * Fetch the data using custom named method function
		 *
		 * @return Array
		 */
		public static function get_Table( $per_page = 5, $page_number = 1 ) {

			global $wpdb;

			//Take pivotal from URL
			$link = ( isset( $_GET['link'] ) ? $_GET['link'] : 'link' );

			//Build the db query base
			$sql = "SELECT * FROM {$wpdb->prefix}wordpress_table";
			$sql .= " QUERIES with $link'";

			//Set filters in the query using $_REQUEST
			if ( ! empty( $_REQUEST['orderby'] ) ) {
				$sql .= ' ORDER BY ' . esc_sql( $_REQUEST['orderby'] );

The function esc_sql was not found. Maybe you did not declare it correctly or list all dependencies?

				$sql .= ! empty( $_REQUEST['order'] ) ? ' ' . esc_sql( $_REQUEST['order'] ) : ' ASC';
			}
			$sql .= " LIMIT $per_page";
			$sql .= ' OFFSET ' . ( $page_number - 1 ) * $per_page;

			//get the data from database
			$result = $wpdb->get_results( $sql, 'ARRAY_A' );

			return $result;
		}


		/**
		 * Delete individual data
		 *
		 * @return Void
		 */
		public static function delete_url( $id ) {

			global $wpdb;

			$wpdb->delete( "{$wpdb->prefix}wordpress_table", array( 'ID' => $id ), array( '%s' ) );
		}


		/**
		 * If there is no data to show
		 *
		 * @return String
		 */
		public function no_items() {

			_e( 'No Items Added yet.', 'textDomain' );

The function _e was not found. Maybe you did not declare it correctly or list all dependencies?

		}


		/**
		 * How many rows are present there
		 *
		 * @return Int
		 */
		public static function record_count() {

			global $wpdb;

			//Take pivotal from URL
			$link = ( isset( $_GET['link'] ) ? $_GET['link'] : 'link' );

			//Build the db query base
			$sql = "SELECT COUNT(*) FROM {$wpdb->prefix}wordpress_table";
			$sql .= " QUERIES with $link'";

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


		/**
		 * Display columns content
		 *
		 * @return Html

The type NirjharLo\WP_Plugin_Framework\Lib\Html was not found. Maybe you did not declare it correctly or list all dependencies?

		 */
		public function column_name( $item ) {

			$delete_nonce = wp_create_nonce( 'delete_url' );

The function wp_create_nonce was not found. Maybe you did not declare it correctly or list all dependencies?

			$title = sprintf( '<strong>%s</strong>', $item['item_name'] );

			//Change the page instruction where you want to show it
			$actions = array(
					'delete' => sprintf( '<a href="?page=%s&action=%s&instruction=%s&_wpnonce=%s">%s</a>', esc_attr( $_REQUEST['page'] ), 'delete', absint( $item['ID'] ), $delete_nonce, __( 'Delete', 'textdomain' ) )

The function absint was not found. Maybe you did not declare it correctly or list all dependencies?

The function esc_attr was not found. Maybe you did not declare it correctly or list all dependencies?

The function __ was not found. Maybe you did not declare it correctly or list all dependencies?

					);

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

The expression return $title . $this->row_actions($actions) returns the type string which is incompatible with the documented return type NirjharLo\WP_Plugin_Framework\Lib\Html.

		}


		/**
		 * set coulmns name
		 *
		 * @return Html
		 */
		public function column_default( $item, $column_name ) {

			switch ( $column_name ) {

				case 'name':
					//This is the first column
					return $this->column_name( $item );
				case 'caseOne':
				case 'caseTwo':
				case 'caseThree':
					return $item[ $column_name ];

				default:

					//Show the whole array for troubleshooting purposes
					return print_r( $item, true );

The expression return print_r($item, true) returns the type string|true which is incompatible with the documented return type NirjharLo\WP_Plugin_Framework\Lib\Html.

			}
		}


		/**
		 * Set checkboxes to delete
		 *
		 * @return Html
		 */
		public function column_cb( $item ) {

			return sprintf( '<input type="checkbox" name="bulk-select[]" value="%s" />', $item['ID'] );

The expression return sprintf('<input type="checkbox" name="bulk-select[]" value="%s" />', $item['ID']) returns the type string which is incompatible with the documented return type NirjharLo\WP_Plugin_Framework\Lib\Html.

		}


		/**
		 * Columns callback
		 *
		 * @return Array
		 */
		public function get_columns() {

			$columns = array(
							'cb'		=> '<input type="checkbox" />',
							'name'	=> __( 'Name', 'textdomain' ),

The function __ was not found. Maybe you did not declare it correctly or list all dependencies?

							'caseOne'	=> __( 'Case One', 'textdomain' ),
							'caseTwo'	=> __( 'Case Two', 'textdomain' ),
							'caseThree'	=> __( 'Case Three', 'textdomain' ),
						);

			return $columns;
		}


		/**
		 * Decide columns to be sortable by array input
		 *
		 * @return Array
		 */
		public function get_sortable_columns() {

			$sortable_columns = array(
				'name' => array( 'name', true ),
				'caseOne' => array( 'caseOne', false ),
				'caseTwo' => array( 'caseTwo', false ),
			);

			return $sortable_columns;
		}


		/**
		 * Determine bulk actions in the table dropdown
		 *
		 * @return Array
		 */
		public function get_bulk_actions() {

			$actions = array( 'bulk-delete' => 'Delete'	);

			return $actions;
		}


		/**
		 * Prapare the display variables for screen options
		 *
		 * @return Void
		 */
		public function prepare_items() {

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

The property _column_headers does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

			/** Process bulk action */
			$this->process_bulk_action();
			$per_page     = $this->get_items_per_page( 'option_name_per_page', 5 );
			$current_page = $this->get_pagenum();
			$total_items  = self::record_count();
			$this->_column_headers = [
    			$this->get_columns(),
    			[], // hidden columns
    			$this->get_sortable_columns(),
    			$this->get_primary_column_name(),
			];
			$this->set_pagination_args( array(
				'total_items' => $total_items,
				'per_page'    => $per_page,
			) );

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


		/**
		 * Process bulk action
		 *
		 * @return Void
		 */
		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'] );

The function esc_attr was not found. Maybe you did not declare it correctly or list all dependencies?

				if ( ! wp_verify_nonce( $nonce, 'delete_url' ) ) {

The function wp_verify_nonce was not found. Maybe you did not declare it correctly or list all dependencies?

					die( 'Go get a live script kiddies' );

Using exit here is not recommended.

				} else {
					self::delete_url( absint( $_GET['instruction'] ) ); //Remember the instruction param from column_name method

The function absint was not found. Maybe you did not declare it correctly or list all dependencies?

				}
			}

			//If the delete bulk action is triggered
			if ( isset( $_POST['action'] ) ) {
				if ( ( isset( $_POST['action'] ) && $_POST['action'] == 'bulk-delete' ) ) {
					$delete_ids = esc_sql( $_POST['bulk-select'] );

The function esc_sql was not found. Maybe you did not declare it correctly or list all dependencies?

					foreach ( $delete_ids as $id ) {
						self::delete_url( $id );
					}
				}
			}
		}
	}
} ?>

It is not recommended to use PHP's closing tag ?> in files other than templates.