Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

namespace Yoast\WP\SEO\Actions\Indexing;

[2] Fix | Delete

[3] Fix | Delete

use wpdb;

[4] Fix | Delete

use Yoast\WP\Lib\Model;

[5] Fix | Delete

use Yoast\WP\SEO\Helpers\Post_Helper;

[6] Fix | Delete

use Yoast\WP\SEO\Helpers\Post_Type_Helper;

[7] Fix | Delete

use Yoast\WP\SEO\Models\Indexable;

[8] Fix | Delete

use Yoast\WP\SEO\Repositories\Indexable_Repository;

[9] Fix | Delete

use Yoast\WP\SEO\Values\Indexables\Indexable_Builder_Versions;

[10] Fix | Delete

[11] Fix | Delete

/**

[12] Fix | Delete

* Reindexing action for post indexables.

[13] Fix | Delete

[14] Fix | Delete

class Indexable_Post_Indexation_Action extends Abstract_Indexing_Action {

[15] Fix | Delete

[16] Fix | Delete

/**

[17] Fix | Delete

* The transient cache key.

[18] Fix | Delete

[19] Fix | Delete

* @var string

[20] Fix | Delete

[21] Fix | Delete

public const UNINDEXED_COUNT_TRANSIENT = 'wpseo_total_unindexed_posts';

[22] Fix | Delete

[23] Fix | Delete

/**

[24] Fix | Delete

* The transient cache key for limited counts.

[25] Fix | Delete

[26] Fix | Delete

* @var string

[27] Fix | Delete

[28] Fix | Delete

public const UNINDEXED_LIMITED_COUNT_TRANSIENT = self::UNINDEXED_COUNT_TRANSIENT . '_limited';

[29] Fix | Delete

[30] Fix | Delete

/**

[31] Fix | Delete

* The post type helper.

[32] Fix | Delete

[33] Fix | Delete

* @var Post_Type_Helper

[34] Fix | Delete

[35] Fix | Delete

protected $post_type_helper;

[36] Fix | Delete

[37] Fix | Delete

/**

[38] Fix | Delete

* The post helper.

[39] Fix | Delete

[40] Fix | Delete

* @var Post_Helper

[41] Fix | Delete

[42] Fix | Delete

protected $post_helper;

[43] Fix | Delete

[44] Fix | Delete

/**

[45] Fix | Delete

* The indexable repository.

[46] Fix | Delete

[47] Fix | Delete

* @var Indexable_Repository

[48] Fix | Delete

[49] Fix | Delete

protected $repository;

[50] Fix | Delete

[51] Fix | Delete

/**

[52] Fix | Delete

* The WordPress database instance.

[53] Fix | Delete

[54] Fix | Delete

* @var wpdb

[55] Fix | Delete

[56] Fix | Delete

protected $wpdb;

[57] Fix | Delete

[58] Fix | Delete

/**

[59] Fix | Delete

* The latest version of Post Indexables.

[60] Fix | Delete

[61] Fix | Delete

* @var int

[62] Fix | Delete

[63] Fix | Delete

protected $version;

[64] Fix | Delete

[65] Fix | Delete

/**

[66] Fix | Delete

* Indexable_Post_Indexing_Action constructor

[67] Fix | Delete

[68] Fix | Delete

* @param Post_Type_Helper $post_type_helper The post type helper.

[69] Fix | Delete

* @param Indexable_Repository $repository The indexable repository.

[70] Fix | Delete

* @param wpdb $wpdb The WordPress database instance.

[71] Fix | Delete

* @param Indexable_Builder_Versions $builder_versions The latest versions for each Indexable type.

[72] Fix | Delete

* @param Post_Helper $post_helper The post helper.

[73] Fix | Delete

[74] Fix | Delete

public function __construct(

[75] Fix | Delete

Post_Type_Helper $post_type_helper,

[76] Fix | Delete

Indexable_Repository $repository,

[77] Fix | Delete

wpdb $wpdb,

[78] Fix | Delete

Indexable_Builder_Versions $builder_versions,

[79] Fix | Delete

Post_Helper $post_helper

[80] Fix | Delete

) {

[81] Fix | Delete

$this->post_type_helper = $post_type_helper;

[82] Fix | Delete

$this->repository = $repository;

[83] Fix | Delete

$this->wpdb = $wpdb;

[84] Fix | Delete

$this->version = $builder_versions->get_latest_version_for_type( 'post' );

[85] Fix | Delete

$this->post_helper = $post_helper;

[86] Fix | Delete

}

[87] Fix | Delete

[88] Fix | Delete

/**

[89] Fix | Delete

* Creates indexables for unindexed posts.

[90] Fix | Delete

[91] Fix | Delete

* @return Indexable[] The created indexables.

[92] Fix | Delete

[93] Fix | Delete

public function index() {

[94] Fix | Delete

$query = $this->get_select_query( $this->get_limit() );

[95] Fix | Delete

[96] Fix | Delete

// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Function get_select_query returns a prepared query.

[97] Fix | Delete

$post_ids = $this->wpdb->get_col( $query );

[98] Fix | Delete

[99] Fix | Delete

$indexables = [];

[100] Fix | Delete

foreach ( $post_ids as $post_id ) {

[101] Fix | Delete

$indexables[] = $this->repository->find_by_id_and_type( (int) $post_id, 'post' );

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

if ( \count( $indexables ) > 0 ) {

[105] Fix | Delete

\delete_transient( static::UNINDEXED_COUNT_TRANSIENT );

[106] Fix | Delete

\delete_transient( static::UNINDEXED_LIMITED_COUNT_TRANSIENT );

[107] Fix | Delete

}

[108] Fix | Delete

[109] Fix | Delete

return $indexables;

[110] Fix | Delete

}

[111] Fix | Delete

[112] Fix | Delete

/**

[113] Fix | Delete

* Returns the number of posts that will be indexed in a single indexing pass.

[114] Fix | Delete

[115] Fix | Delete

* @return int The limit.

[116] Fix | Delete

[117] Fix | Delete

public function get_limit() {

[118] Fix | Delete

/**

[119] Fix | Delete

* Filter 'wpseo_post_indexation_limit' - Allow filtering the amount of posts indexed during each indexing pass.

[120] Fix | Delete

[121] Fix | Delete

* @param int $limit The maximum number of posts indexed.

[122] Fix | Delete

[123] Fix | Delete

$limit = \apply_filters( 'wpseo_post_indexation_limit', 25 );

[124] Fix | Delete

[125] Fix | Delete

if ( ! \is_int( $limit ) || $limit < 1 ) {

[126] Fix | Delete

$limit = 25;

[127] Fix | Delete

}

[128] Fix | Delete

[129] Fix | Delete

return $limit;

[130] Fix | Delete

}

[131] Fix | Delete

[132] Fix | Delete

/**

[133] Fix | Delete

* Builds a query for counting the number of unindexed posts.

[134] Fix | Delete

[135] Fix | Delete

* @return string The prepared query string.

[136] Fix | Delete

[137] Fix | Delete

protected function get_count_query() {

[138] Fix | Delete

$indexable_table = Model::get_table_name( 'Indexable' );

[139] Fix | Delete

[140] Fix | Delete

$post_types = $this->post_type_helper->get_indexable_post_types();

[141] Fix | Delete

$excluded_post_statuses = $this->post_helper->get_excluded_post_statuses();

[142] Fix | Delete

$replacements = \array_merge(

[143] Fix | Delete

$post_types,

[144] Fix | Delete

$excluded_post_statuses

[145] Fix | Delete

);

[146] Fix | Delete

[147] Fix | Delete

$replacements[] = $this->version;

[148] Fix | Delete

[149] Fix | Delete

// Warning: If this query is changed, makes sure to update the query in get_select_query as well.

[150] Fix | Delete

// @phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber

[151] Fix | Delete

return $this->wpdb->prepare(

[152] Fix | Delete

[153] Fix | Delete

SELECT COUNT(P.ID)

[154] Fix | Delete

FROM {$this->wpdb->posts} AS P

[155] Fix | Delete

WHERE P.post_type IN (" . \implode( ', ', \array_fill( 0, \count( $post_types ), '%s' ) ) . ')

[156] Fix | Delete

AND P.post_status NOT IN (' . \implode( ', ', \array_fill( 0, \count( $excluded_post_statuses ), '%s' ) ) . ")

[157] Fix | Delete

AND P.ID not in (

[158] Fix | Delete

SELECT I.object_id from $indexable_table as I

[159] Fix | Delete

WHERE I.object_type = 'post'

[160] Fix | Delete

AND I.version = %d )",

[161] Fix | Delete

$replacements

[162] Fix | Delete

);

[163] Fix | Delete

}

[164] Fix | Delete

[165] Fix | Delete

/**

[166] Fix | Delete

* Builds a query for selecting the ID's of unindexed posts.

[167] Fix | Delete

[168] Fix | Delete

* @param bool $limit The maximum number of post IDs to return.

[169] Fix | Delete

[170] Fix | Delete

* @return string The prepared query string.

[171] Fix | Delete

[172] Fix | Delete

protected function get_select_query( $limit = false ) {

[173] Fix | Delete

$indexable_table = Model::get_table_name( 'Indexable' );

[174] Fix | Delete

[175] Fix | Delete

$post_types = $this->post_type_helper->get_indexable_post_types();

[176] Fix | Delete

$excluded_post_statuses = $this->post_helper->get_excluded_post_statuses();

[177] Fix | Delete

$replacements = \array_merge(

[178] Fix | Delete

$post_types,

[179] Fix | Delete

$excluded_post_statuses

[180] Fix | Delete

);

[181] Fix | Delete

$replacements[] = $this->version;

[182] Fix | Delete

[183] Fix | Delete

$limit_query = '';

[184] Fix | Delete

if ( $limit ) {

[185] Fix | Delete

$limit_query = 'LIMIT %d';

[186] Fix | Delete

$replacements[] = $limit;

[187] Fix | Delete

}

[188] Fix | Delete

[189] Fix | Delete

// Warning: If this query is changed, makes sure to update the query in get_count_query as well.

[190] Fix | Delete

// @phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber

[191] Fix | Delete

return $this->wpdb->prepare(

[192] Fix | Delete

[193] Fix | Delete

SELECT P.ID

[194] Fix | Delete

FROM {$this->wpdb->posts} AS P

[195] Fix | Delete

WHERE P.post_type IN (" . \implode( ', ', \array_fill( 0, \count( $post_types ), '%s' ) ) . ')

[196] Fix | Delete

AND P.post_status NOT IN (' . \implode( ', ', \array_fill( 0, \count( $excluded_post_statuses ), '%s' ) ) . ")

[197] Fix | Delete

AND P.ID not in (

[198] Fix | Delete

SELECT I.object_id from $indexable_table as I

[199] Fix | Delete

WHERE I.object_type = 'post'

[200] Fix | Delete

AND I.version = %d )

[201] Fix | Delete

$limit_query",

[202] Fix | Delete

$replacements

[203] Fix | Delete

);

[204] Fix | Delete

}

[205] Fix | Delete

}

[206] Fix | Delete

[207] Fix | Delete