class Schema_Map_Indexable_Repository implements Schema_Map_Repository_Interface {
/**
* The indexable repository.
*
* @var Indexable_Repository
*/
private $indexable_repository;
/**
* Schema_Map_Indexable_Repository constructor.
*
* @param Indexable_Repository $indexable_repository The indexable repository.
*/
public function __construct( Indexable_Repository $indexable_repository ) {
$this->indexable_repository = $indexable_repository;
}
/**
* Gets the indexable count per post type.
*
* @param array<string> $post_types The post types to get the indexable count for.
*
* @return Indexable_Count_Collection The indexable count per post type.
*/
public function get_indexable_count_per_post_type( array $post_types ): Indexable_Count_Collection {
$post_type_counts = new Indexable_Count_Collection();
$indexable_raw_value = $this->indexable_repository->query()
->select_expr( 'object_sub_type,count(object_sub_type) as count' )
->where_in( 'object_sub_type', $post_types )
->where_in( 'object_type', [ 'post', 'page' ] )
->where( 'post_status', 'publish' )
->where_raw( '( is_public IS NULL OR is_public = 1 )' )
->group_by( [ 'object_type', 'object_sub_type' ] )
->find_array();
if ( empty( $indexable_raw_value ) ) {
return $post_type_counts;
}
foreach ( $indexable_raw_value as $indexable ) {
$post_type_counts->add_indexable_count( new Indexable_Count( $indexable['object_sub_type'], (int) $indexable['count'] ) );
}
return $post_type_counts;
}
/**
* Gets the indexable count for a single post type.
*
* @param string $post_type The post type to get the indexable count for.
*
* @return Indexable_Count The indexable count for the post type.
*/
public function get_indexable_count_for_post_type( string $post_type ): Indexable_Count {
$indexable_raw_value = $this->indexable_repository->query()
->select_expr( 'object_sub_type,count(object_sub_type) as count' )
->where( 'object_sub_type', $post_type )
->where( 'post_status', 'publish' )
->where_in( 'object_type', [ 'post', 'page' ] )
->where_raw( '( is_public IS NULL OR is_public = 1 )' )
->find_one();
if ( empty( $indexable_raw_value ) ) {
return new Indexable_Count( $post_type, 0 );
}
return new Indexable_Count( $indexable_raw_value->object_sub_type, (int) $indexable_raw_value->count );
}
/**
* Get lastmod timestamp for a post type and page range
*
* Returns the latest post_modified_gmt timestamp for posts in the given range.
* Used for schemamap index to enable selective updates.
*
* @param string $post_type Post type slug.
* @param int $page Page number (1-indexed).
* @param int $per_page Items per page.
* @return string ISO 8601 timestamp (e.g., "2025-10-21T14:23:17Z").
*/
public function get_lastmod_for_post_type( string $post_type, int $page, int $per_page ): string {
global $wpdb;
$fallback = \gmdate( 'Y-m-d\TH:i:s\Z' );
try {
$offset = ( ( $page - 1 ) * $per_page );
$indexable_table = Model::get_table_name( 'Indexable' );
// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Reason: There is no unescaped user input.
// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery
$lastmod = $wpdb->get_var(
$wpdb->prepare(
"
SELECT MAX(object_last_modified)
FROM (
SELECT indexable_table.object_last_modified
FROM {$indexable_table} indexable_table
WHERE object_sub_type = %s
AND post_status = 'publish'
AND ( is_public IS NULL OR is_public = 1 )
ORDER BY ID
LIMIT %d OFFSET %d
)AS posts_range
",
$post_type,
$per_page,
$offset,
),
);
// Convert to ISO 8601 format or use current time if no posts.
if ( $lastmod && ! empty( $lastmod ) ) {
return \gmdate( 'Y-m-d\TH:i:s\Z', \strtotime( $lastmod ) );
}
return $fallback;
} catch ( Exception $e ) {
return $fallback;
}
}
}