Yoast\WP\SEO\Repositories

Indexable_Cleanup_Repository::clean_indexables_for_authors_without_archive() │ public │ Yoast 1.0

Cleans up any indexables that belong to users that have their author archives disabled.

Метод класса: Indexable_Cleanup_Repository{}

Хуков нет.

Возвращает

true|false|int. The number of deleted rows, false if the query fails.

Использование

$Indexable_Cleanup_Repository = new Indexable_Cleanup_Repository();
$Indexable_Cleanup_Repository->clean_indexables_for_authors_without_archive( $limit );
$limit(int) (обязательный)
The limit we'll apply to the queries.

Код Indexable_Cleanup_Repository::clean_indexables_for_authors_without_archive() Yoast 24.0

yoast/src/repositories/indexable-cleanup-repository.php 
public function clean_indexables_for_authors_without_archive( $limit ) {
	global $wpdb;

	$indexable_table           = Model::get_table_name( 'Indexable' );
	$author_archive_post_types = $this->author_archive->get_author_archive_post_types();
	$viewable_post_stati       = \array_filter( \get_post_stati(), 'is_post_status_viewable' );

	// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Reason: Too hard to fix.
	// phpcs:disable WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber -- Reason: we're passing an array instead.
	$delete_query = $wpdb->prepare(
		"DELETE FROM $indexable_table
			WHERE object_type = 'user'
			AND object_id NOT IN (
				SELECT DISTINCT post_author
				FROM $wpdb->posts
				WHERE post_type IN ( " . \implode( ', ', \array_fill( 0, \count( $author_archive_post_types ), '%s' ) ) . ' )
				AND post_status IN ( ' . \implode( ', ', \array_fill( 0, \count( $viewable_post_stati ), '%s' ) ) . ' )
			) LIMIT %d',
		\array_merge( $author_archive_post_types, $viewable_post_stati, [ $limit ] )
	);
	// phpcs:enable

	// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: No relevant caches.
	// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- Reason: Most performant way.
	// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared -- Reason: Is it prepared already.
	return $wpdb->query( $delete_query );
	// phpcs:enable
}