<?php

/**

 * List Table API: WP_MS_Sites_List_Table class

 *

 * @package WordPress

 * @subpackage Administration

 * @since 3.1.0

 */

/**

 * Core class used to implement displaying sites in a list table for the network admin.

 *

 * @since 3.1.0

 *

 * @see WP_List_Table

 */

class WP_MS_Sites_List_Table extends WP_List_Table {

	/**

	 * Site status list.

	 *

	 * @since 4.3.0

	 * @var array

	 */

	public $status_list;

	/**

	 * Constructor.

	 *

	 * @since 3.1.0

	 *

	 * @see WP_List_Table::__construct() for more information on default arguments.

	 *

	 * @param array $args An associative array of arguments.

	 */

	public function __construct( $args = array() ) {

		$this->status_list = array(

			'archived' => array( 'site-archived', __( 'Archived' ) ),

			'spam'     => array( 'site-spammed', _x( 'Spam', 'site' ) ),

			'deleted'  => array( 'site-deleted', __( 'Deleted' ) ),

			'mature'   => array( 'site-mature', __( 'Mature' ) ),

		);

		parent::__construct(

			array(

				'plural' => 'sites',

				'screen' => isset( $args['screen'] ) ? $args['screen'] : null,

			)

		);

	}

	/**

	 * @return bool

	 */

	public function ajax_user_can() {

		return current_user_can( 'manage_sites' );

	}

	/**

	 * Prepares the list of sites for display.

	 *

	 * @since 3.1.0

	 *

	 * @global string $mode List table view mode.

	 * @global string $s

	 * @global wpdb   $wpdb WordPress database abstraction object.

	 */

	public function prepare_items() {

		global $mode, $s, $wpdb;

		if ( ! empty( $_REQUEST['mode'] ) ) {

			$mode = 'excerpt' === $_REQUEST['mode'] ? 'excerpt' : 'list';

			set_user_setting( 'sites_list_mode', $mode );

		} else {

			$mode = get_user_setting( 'sites_list_mode', 'list' );

		}

		$per_page = $this->get_items_per_page( 'sites_network_per_page' );

		$pagenum = $this->get_pagenum();

		$s    = isset( $_REQUEST['s'] ) ? wp_unslash( trim( $_REQUEST['s'] ) ) : '';

		$wild = '';

		if ( str_contains( $s, '*' ) ) {

			$wild = '*';

			$s    = trim( $s, '*' );

		}

		/*

		 * If the network is large and a search is not being performed, show only

		 * the latest sites with no paging in order to avoid expensive count queries.

		 */

		if ( ! $s && wp_is_large_network() ) {

			if ( ! isset( $_REQUEST['orderby'] ) ) {

				$_GET['orderby']     = '';

				$_REQUEST['orderby'] = '';

			}

			if ( ! isset( $_REQUEST['order'] ) ) {

				$_GET['order']     = 'DESC';

				$_REQUEST['order'] = 'DESC';

			}

		}

		$args = array(

			'number'     => (int) $per_page,

			'offset'     => (int) ( ( $pagenum - 1 ) * $per_page ),

			'network_id' => get_current_network_id(),

		);

		if ( empty( $s ) ) {

			// Nothing to do.

		} elseif ( preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/', $s )

			|| preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.?$/', $s )

			|| preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.?$/', $s )

			|| preg_match( '/^[0-9]{1,3}\.$/', $s )

		) {

			// IPv4 address.

			$reg_blog_ids = $wpdb->get_col(

				$wpdb->prepare(

					"SELECT blog_id FROM {$wpdb->registration_log} WHERE {$wpdb->registration_log}.IP LIKE %s",

					$wpdb->esc_like( $s ) . ( ! empty( $wild ) ? '%' : '' )

				)

			);

			if ( $reg_blog_ids ) {

				$args['site__in'] = $reg_blog_ids;

			}

		} elseif ( is_numeric( $s ) && empty( $wild ) ) {

			$args['ID'] = $s;

		} else {

			$args['search'] = $s;

			if ( ! is_subdomain_install() ) {

				$args['search_columns'] = array( 'path' );

			}

		}

		$order_by = isset( $_REQUEST['orderby'] ) ? $_REQUEST['orderby'] : '';

		if ( 'registered' === $order_by ) {

			// 'registered' is a valid field name.

		} elseif ( 'lastupdated' === $order_by ) {

			$order_by = 'last_updated';

		} elseif ( 'blogname' === $order_by ) {

			if ( is_subdomain_install() ) {

				$order_by = 'domain';

			} else {

				$order_by = 'path';

			}

		} elseif ( 'blog_id' === $order_by ) {

			$order_by = 'id';

		} elseif ( ! $order_by ) {

			$order_by = false;

		}

		$args['orderby'] = $order_by;

		if ( $order_by ) {

			$args['order'] = ( isset( $_REQUEST['order'] ) && 'DESC' === strtoupper( $_REQUEST['order'] ) ) ? 'DESC' : 'ASC';

		}

		if ( wp_is_large_network() ) {

			$args['no_found_rows'] = true;

		} else {

			$args['no_found_rows'] = false;

		}

		// Take into account the role the user has selected.

		$status = isset( $_REQUEST['status'] ) ? wp_unslash( trim( $_REQUEST['status'] ) ) : '';

		if ( in_array( $status, array( 'public', 'archived', 'mature', 'spam', 'deleted' ), true ) ) {

			$args[ $status ] = 1;

		}

		/**

		 * Filters the arguments for the site query in the sites list table.

		 *

		 * @since 4.6.0

		 *

		 * @param array $args An array of get_sites() arguments.

		 */

		$args = apply_filters( 'ms_sites_list_table_query_args', $args );

		$_sites = get_sites( $args );

		if ( is_array( $_sites ) ) {

			update_site_cache( $_sites );

			$this->items = array_slice( $_sites, 0, $per_page );

		}

		$total_sites = get_sites(

			array_merge(

				$args,

				array(

					'count'  => true,

					'offset' => 0,

					'number' => 0,

				)

			)

		);

		$this->set_pagination_args(

			array(

				'total_items' => $total_sites,

				'per_page'    => $per_page,

			)

		);

	}

	/**

	 */

	public function no_items() {

		_e( 'No sites found.' );

	}

	/**

	 * Gets links to filter sites by status.

	 *

	 * @since 5.3.0

	 *

	 * @return array

	 */

	protected function get_views() {

		$counts = wp_count_sites();

		$statuses = array(

			/* translators: %s: Number of sites. */

			'all'      => _nx_noop(

				'All <span class="count">(%s)</span>',

				'All <span class="count">(%s)</span>',

				'sites'

			),

			/* translators: %s: Number of sites. */

			'public'   => _n_noop(

				'Public <span class="count">(%s)</span>',

				'Public <span class="count">(%s)</span>'

			),

			/* translators: %s: Number of sites. */

			'archived' => _n_noop(

				'Archived <span class="count">(%s)</span>',

				'Archived <span class="count">(%s)</span>'

			),

			/* translators: %s: Number of sites. */

			'mature'   => _n_noop(

				'Mature <span class="count">(%s)</span>',

				'Mature <span class="count">(%s)</span>'

			),

			/* translators: %s: Number of sites. */

			'spam'     => _nx_noop(

				'Spam <span class="count">(%s)</span>',

				'Spam <span class="count">(%s)</span>',

				'sites'

			),

			/* translators: %s: Number of sites. */

			'deleted'  => _n_noop(

				'Deleted <span class="count">(%s)</span>',

				'Deleted <span class="count">(%s)</span>'

			),

		);

		$view_links       = array();

		$requested_status = isset( $_REQUEST['status'] ) ? wp_unslash( trim( $_REQUEST['status'] ) ) : '';

		$url              = 'sites.php';

		foreach ( $statuses as $status => $label_count ) {

			if ( (int) $counts[ $status ] > 0 ) {

				$label = sprintf(

					translate_nooped_plural( $label_count, $counts[ $status ] ),

					number_format_i18n( $counts[ $status ] )

				);

				$full_url = 'all' === $status ? $url : add_query_arg( 'status', $status, $url );

				$view_links[ $status ] = array(

					'url'     => esc_url( $full_url ),

					'label'   => $label,

					'current' => $requested_status === $status || ( '' === $requested_status && 'all' === $status ),

				);

			}

		}

		return $this->get_views_links( $view_links );

	}

	/**

	 * @return array

	 */

	protected function get_bulk_actions() {

		$actions = array();

		if ( current_user_can( 'delete_sites' ) ) {

			$actions['delete'] = __( 'Delete' );

		}

		$actions['spam']    = _x( 'Mark as spam', 'site' );

		$actions['notspam'] = _x( 'Not spam', 'site' );

		return $actions;

	}

	/**

	 * @global string $mode List table view mode.

	 *

	 * @param string $which The location of the pagination nav markup: Either 'top' or 'bottom'.

	 */

	protected function pagination( $which ) {

		global $mode;

		parent::pagination( $which );

		if ( 'top' === $which ) {

			$this->view_switcher( $mode );

		}

	}

	/**

	 * Displays extra controls between bulk actions and pagination.

	 *

	 * @since 5.3.0

	 *

	 * @param string $which The location of the extra table nav markup: Either 'top' or 'bottom'.

	 */

	protected function extra_tablenav( $which ) {

		?>

		<div class="alignleft actions">

		<?php

		if ( 'top' === $which ) {

			ob_start();

			/**

			 * Fires before the Filter button on the MS sites list table.

			 *

			 * @since 5.3.0

			 *

			 * @param string $which The location of the extra table nav markup: Either 'top' or 'bottom'.

			 */

			do_action( 'restrict_manage_sites', $which );

			$output = ob_get_clean();

			if ( ! empty( $output ) ) {

				echo $output;

				submit_button( __( 'Filter' ), '', 'filter_action', false, array( 'id' => 'site-query-submit' ) );

			}

		}

		?>

		</div>

		<?php

		/**

		 * Fires immediately following the closing "actions" div in the tablenav for the

		 * MS sites list table.

		 *

		 * @since 5.3.0

		 *

		 * @param string $which The location of the extra table nav markup: Either 'top' or 'bottom'.

		 */

		do_action( 'manage_sites_extra_tablenav', $which );

	}

	/**

	 * @return string[] Array of column titles keyed by their column name.

	 */

	public function get_columns() {

		$sites_columns = array(

			'cb'          => '<input type="checkbox" />',

			'blogname'    => __( 'URL' ),

			'lastupdated' => __( 'Last Updated' ),

			'registered'  => _x( 'Registered', 'site' ),

			'users'       => __( 'Users' ),

		);

		if ( has_filter( 'wpmublogsaction' ) ) {

			$sites_columns['plugins'] = __( 'Actions' );

		}

		/**

		 * Filters the displayed site columns in Sites list table.

		 *

		 * @since MU (3.0.0)

		 *

		 * @param string[] $sites_columns An array of displayed site columns. Default 'cb',

		 *                               'blogname', 'lastupdated', 'registered', 'users'.

		 */

		return apply_filters( 'wpmu_blogs_columns', $sites_columns );

	}

	/**

	 * @return array

	 */

	protected function get_sortable_columns() {

		if ( is_subdomain_install() ) {

			$blogname_abbr         = __( 'Domain' );

			$blogname_orderby_text = __( 'Table ordered by Site Domain Name.' );

		} else {

			$blogname_abbr         = __( 'Path' );

			$blogname_orderby_text = __( 'Table ordered by Site Path.' );

		}

		return array(

			'blogname'    => array( 'blogname', false, $blogname_abbr, $blogname_orderby_text ),

			'lastupdated' => array( 'lastupdated', true, __( 'Last Updated' ), __( 'Table ordered by Last Updated.' ) ),

			'registered'  => array( 'blog_id', true, _x( 'Registered', 'site' ), __( 'Table ordered by Site Registered Date.' ), 'desc' ),