<h2>File Contents: /home/planet5/.trash/wordpress-seo-premium/classes/premium-prominent-words-unindexed-post-query.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/wordpress-seo-premium/classes/premium-prominent-words-unindexed-post-query.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * WPSEO Premium plugin file.
 *
 * @package WPSEO\Premium
 */

/**
 * Represents the unindexed posts.
 */
class WPSEO_Premium_Prominent_Words_Unindexed_Post_Query {

	/**
	 * List containing unindexed posts totals per post type.
	 *
	 * @var array
	 */
	protected $totals = [];

	/**
	 * Returns the total amount of posts.
	 *
	 * @since 4.6.0
	 *
	 * @param int $limit The offset for the query.
	 *
	 * @return bool True when the limit has been exceeded.
	 */
	public function exceeds_limit( $limit ) {
		$unindexed_post_ids = $this-&gt;get_unindexed_post_ids( $this-&gt;get_post_types(), ( $limit + 1 ) );
		return count( $unindexed_post_ids ) &gt; $limit;
	}

	/**
	 * Returns the total unindexed posts for given post type.
	 *
	 * @since 4.6.0
	 *
	 * @param string $post_type The posttype to fetch.
	 *
	 * @return int The total amount of unindexed posts.
	 */
	public function get_total( $post_type ) {
		if ( ! array_key_exists( $post_type, $this-&gt;totals ) ) {
			$totals = $this-&gt;get_totals( $this-&gt;get_post_types() );

			foreach ( $totals as $total_post_type =&gt; $total ) {
				$this-&gt;totals[ $total_post_type ] = $total;
			}
		}

		if ( ! array_key_exists( $post_type, $this-&gt;totals ) ) {
			$this-&gt;totals[ $post_type ] = 0;
		}

		return $this-&gt;totals[ $post_type ];
	}

	/**
	 * Returns the totals for each posttype by counting them.
	 *
	 * @since 4.6.0
	 *
	 * @param array $post_types The posttype to limit the resultset for.
	 *
	 * @return array Array with the totals for the requested posttypes.
	 */
	public function get_totals( $post_types ) {
		global $wpdb;

		if ( $post_types === [] ) {
			return $post_types;
		}

		$replacements = [
			WPSEO_Premium_Prominent_Words_Versioning::POST_META_NAME,
			WPSEO_Premium_Prominent_Words_Versioning::get_version_number(),
		];
		$replacements = array_merge( $replacements, $post_types );

		$results = $wpdb-&gt;get_results(
			$wpdb-&gt;prepare(
				&#039;
				SELECT COUNT( ID ) as total, post_type
				FROM &#039; . $wpdb-&gt;posts . &#039;
				WHERE ID NOT IN( SELECT post_id FROM &#039; . $wpdb-&gt;postmeta . &#039; WHERE meta_key = %s AND meta_value = %s )
					AND post_status IN( &quot;future&quot;, &quot;draft&quot;, &quot;pending&quot;, &quot;private&quot;, &quot;publish&quot; )
					AND post_type IN( &#039; . implode( &#039;,&#039;, array_fill( 0, count( $post_types ), &#039;%s&#039; ) ) . &#039; )
				GROUP BY post_type
				&#039;,
				$replacements
			)
		);

		$totals = [];

		foreach ( $results as $result ) {
			$totals[ $this-&gt;determine_rest_endpoint_for_post_type( $result-&gt;post_type ) ] = (int) $result-&gt;total;
		}

		return $totals;
	}

	/**
	 * Determines the REST endpoint for the given post type.
	 *
	 * @param string $post_type The post type to determine the endpoint for.
	 *
	 * @return string The endpoint. Returns empty string if post type doesn&#039;t exist.
	 */
	protected function determine_rest_endpoint_for_post_type( $post_type ) {
		$post_type_object = get_post_type_object( $post_type );

		if ( is_null( $post_type_object ) ) {
			return &#039;&#039;;
		}

		if ( isset( $post_type_object-&gt;rest_base ) &amp;&amp; ! empty( $post_type_object-&gt;rest_base ) ) {
			return $post_type_object-&gt;rest_base;
		}

		return $post_type_object-&gt;name;
	}

	/**
	 * Returns the array with supported posttypes.
	 *
	 * @return array The supported posttypes.
	 */
	protected function get_post_types() {
		$prominent_words_support = new WPSEO_Premium_Prominent_Words_Support();

		return array_filter( $prominent_words_support-&gt;get_supported_post_types(), [ &#039;WPSEO_Post_Type&#039;, &#039;is_rest_enabled&#039; ] );
	}

	/**
	 * Gets the Post IDs of un-indexed objects.
	 *
	 * @param array|string $post_types The post type(s) to fetch.
	 * @param int          $limit      Limit the number of results.
	 *
	 * @return int[] Post IDs found which are un-indexed.
	 */
	public function get_unindexed_post_ids( $post_types, $limit ) {
		global $wpdb;

		if ( is_string( $post_types ) ) {
			$post_types = (array) $post_types;
		}

		if ( $post_types === [] ) {
			return $post_types;
		}

		$replacements   = [
			WPSEO_Premium_Prominent_Words_Versioning::POST_META_NAME,
			WPSEO_Premium_Prominent_Words_Versioning::get_version_number(),
		];
		$replacements   = array_merge( $replacements, $post_types );
		$replacements[] = $limit;

		$results = $wpdb-&gt;get_results(
			$wpdb-&gt;prepare(
				&#039;
				SELECT ID
				FROM &#039; . $wpdb-&gt;posts . &#039;
				WHERE ID NOT IN( SELECT post_id FROM &#039; . $wpdb-&gt;postmeta . &#039; WHERE meta_key = %s AND meta_value = %s )
					AND post_status IN( &quot;future&quot;, &quot;draft&quot;, &quot;pending&quot;, &quot;private&quot;, &quot;publish&quot; )
					AND post_type IN( &#039; . implode( &#039;,&#039;, array_fill( 0, count( $post_types ), &#039;%s&#039; ) ) . &#039; )
				LIMIT %d&#039;,
				$replacements
			),
			ARRAY_A
		);

		// Make sure we return a list of IDs.
		$results = wp_list_pluck( $results, &#039;ID&#039; );

		return $results;
	}

	/**
	 * Returns the array with supported post statuses.
	 *
	 * @return string[] The supported post statuses.
	 */
	public function get_supported_post_statuses() {
		return [ &#039;future&#039;, &#039;draft&#039;, &#039;pending&#039;, &#039;private&#039;, &#039;publish&#039; ];
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Fwordpress-seo-premium%2Fclasses'>⬅ Back to Directory</a>