Table::get_columns() - Code Metrics - Inspection of "Composer/Namespace integration" - nirjharlo/wp-plugin-framework - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( b04223...d66bb9 )

by Nirjhar
created 2021-02-20 14:17 UTC
Table::get_columns() A

↳ Parent: Table
Complexity

Conditions	1
Paths	1
Size

Total Lines	11
Code Lines	7
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	7
nc	1
nop	0
dl	0
loc	11
rs	10
c	0
b	0
f	0
<?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' );

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

	final class Table extends WP_List_Table {
filter:
    dependency_paths: ["lib/*"]


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

			parent::__construct( [
				'singular' => __( 'Name', 'textdomain' ),
				'singular' => /** @scrutinizer ignore-call */ __( 'Name', 'textdomain' ),
				'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'] );
				$sql .= ' ORDER BY ' . /** @scrutinizer ignore-call */ esc_sql( $_REQUEST['orderby'] );
				$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' );
   _e( 'No Items Added yet.', 'textDomain' );
		}


		/**
		 * 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
filter:
    dependency_paths: ["lib/*"]
		 */
		public function column_name( $item ) {

			$delete_nonce = wp_create_nonce( 'delete_url' );
			$delete_nonce = /** @scrutinizer ignore-call */ wp_create_nonce( 'delete_url' );
			$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' ) )
					'delete' => sprintf( '<a href="?page=%s&action=%s&instruction=%s&_wpnonce=%s">%s</a>', esc_attr( $_REQUEST['page'] ), 'delete', absint( $item['ID'] ), $delete_nonce, /** @scrutinizer ignore-call */ __( 'Delete', 'textdomain' ) )
					);

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

		}


		/**
		 * 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 );

			}
		}


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

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

		}


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

			$columns = array(
							'cb'		=> '<input type="checkbox" />',
							'name'	=> __( 'Name', 'textdomain' ),
							'name'	=> /** @scrutinizer ignore-call */ __( 'Name', 'textdomain' ),
							'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();


			/** 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->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'] );
				$nonce = /** @scrutinizer ignore-call */ esc_attr( $_REQUEST['_wpnonce'] );

				if ( ! wp_verify_nonce( $nonce, 'delete_url' ) ) {
				if ( ! /** @scrutinizer ignore-call */ wp_verify_nonce( $nonce, 'delete_url' ) ) {
					die( 'Go get a live script kiddies' );

				} else {
					self::delete_url( absint( $_GET['instruction'] ) ); //Remember the instruction param from column_name method
					self::delete_url( /** @scrutinizer ignore-call */ absint( $_GET['instruction'] ) ); //Remember the instruction param from column_name method
				}
			}

			//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'] );
					$delete_ids = /** @scrutinizer ignore-call */ esc_sql( $_POST['bulk-select'] );
					foreach ( $delete_ids as $id ) {
						self::delete_url( $id );
					}
				}
			}
		}
	}
} ?>


nirjharlo / wp-plugin-framework

Push — master ( b04223...d66bb9 )

Table::get_columns() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
