automatewoo/admin/reports/opt-ins.php

<?php

namespace AutomateWoo;

defined( 'ABSPATH' ) || exit;

/**
 * @class Report_Optins
 */
class Report_Optins extends Admin_List_Table {

	/**
	 * List Table slug
	 *
	 * @var string
	 */
	public $name = 'opt-ins';

	/**
	 * Enable searching in list table.
	 *
	 * @var bool
	 */
	public $enable_search = true;

	/**
	 * Default constructor
	 */
	public function __construct() {
		parent::__construct(
			[
				'singular' => Options::optin_enabled() ? __( 'Opt-in', 'automatewoo' ) : __( 'Opt-out', 'automatewoo' ),
				'plural'   => Options::optin_enabled() ? __( 'Opt-ins', 'automatewoo' ) : __( 'Opt-outs', 'automatewoo' ),
				'ajax'     => false,
			]
		);
		$this->search_button_text = __( 'Search by email', 'automatewoo' );
	}

	/**
	 * @param Customer $customer
	 * @return string
	 */
	public function column_cb( $customer ) {
		return '<input type="checkbox" name="customer_ids[]" value="' . absint( $customer->get_id() ) . '" />';
	}

	/**
	 * @param Customer $customer
	 * @param mixed    $column_name
	 * @return string
	 */
	public function column_default( $customer, $column_name ) {
		switch ( $column_name ) {
			case 'email':
				return Format::customer( $customer );

			case 'time':
				return $this->format_date( Options::optin_enabled() ? $customer->get_date_subscribed() : $customer->get_date_unsubscribed() );
		}
	}

	/**
	 * Get columns for the list table.
	 *
	 * @return array
	 */
	public function get_columns() {
		$columns = [
			'cb'    => '<input type="checkbox" />',
			'email' => __( 'Customer', 'automatewoo' ),
			'time'  => __( 'Date', 'automatewoo' ),
		];

		return $columns;
	}

	/**
	 * Retrieve the bulk actions
	 */
	public function get_bulk_actions() {
		$actions = [];

		if ( Options::optin_enabled() ) {
			$actions['bulk_optout'] = __( 'Set as opted-out', 'automatewoo' );
		} else {
			$actions['bulk_optin'] = __( 'Set as opted-in', 'automatewoo' );
		}

		return $actions;
	}

	/**
	 * Prepare items for display.
	 *
	 * @return void
	 */
	public function prepare_items() {
		$this->_column_headers = [ $this->get_columns(), [], $this->get_sortable_columns() ];
		$current_page          = absint( $this->get_pagenum() );
		$per_page              = $this->get_items_per_page( 'automatewoo_optins_per_page' );

		$this->get_items( $current_page, $per_page );

		$this->set_pagination_args(
			[
				'total_items' => $this->max_items,
				'per_page'    => $per_page,
				'total_pages' => ceil( $this->max_items / $per_page ),
			]
		);
	}

	/**
	 * Fetch list of items from DB.
	 *
	 * @param string $current_page
	 * @param int    $per_page
	 */
	public function get_items( $current_page, $per_page ) {
		$query = new Customer_Query();

		if ( Options::optin_enabled() ) {
			$query->where( 'subscribed', true );
			$query->set_ordering( 'subscribed_date' );
		} else {
			$query->where( 'unsubscribed', true );
			$query->set_ordering( 'unsubscribed_date' );
		}

		$has_no_valid_search_matches = false;

		if ( ! empty( $_GET['s'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification
			$search        = trim( strtolower( Clean::string( $_GET['s'] ) ) ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput, WordPress.Security.NonceVerification
			$search_wheres = [];

			$guest_query = new Guest_Query();
			$guest_query->where( 'email', "%$search%", 'LIKE' );
			$guest_ids = $guest_query->get_results_as_ids();

			if ( $guest_ids ) {
				$search_wheres[] = [
					'column'  => 'guest_id',
					'value'   => $guest_ids,
					'compare' => 'IN',
				];
			}

			$user_query = new \WP_User_Query(
				[
					'search'         => '*' . esc_attr( $search ) . '*',
					'search_columns' => [ 'user_email' ],
					'fields'         => 'ID',
				]
			);

			$user_ids = $user_query->get_results();

			if ( $user_ids ) {
				$search_wheres[] = [
					'column'  => 'user_id',
					'value'   => $user_ids,
					'compare' => 'IN',
				];
			}

			if ( $search_wheres ) {
				$query->where[] = $search_wheres;
			} else {
				$has_no_valid_search_matches = true;
			}
		}

		$query->set_calc_found_rows( true );
		$query->set_limit( $per_page );
		$query->set_page( $current_page );

		// if there are no valid search matches there are no matching customers
		if ( $has_no_valid_search_matches === false ) {
			$results         = $query->get_results();
			$this->items     = $results;
			$this->max_items = $query->found_rows;
		}
	}
}