<?php
namespace Advently\Calendar;

defined( 'ABSPATH' ) || exit;

/**
 * The page that shows the calendar: chosen in the settings, created in one
 * click, or found by its shortcode/block when none is chosen yet.
 */
final class Page {

	/**
	 * Id of the calendar page, or 0 when there is none.
	 */
	public static function id( array $config ): int {
		$id = (int) $config['page_id'];
		if ( $id && 'publish' === get_post_status( $id ) ) {
			return $id;
		}
		return self::find();
	}

	public static function url( array $config ): string {
		$id = self::id( $config );
		return $id ? (string) get_permalink( $id ) : '';
	}

	/**
	 * Creates a published page holding the calendar block and returns its id (0 on failure).
	 */
	public static function create(): int {
		$id = wp_insert_post(
			[
				'post_type'    => 'page',
				'post_status'  => 'publish',
				'post_title'   => __( 'Advent calendar', 'advently' ),
				'post_content' => '<!-- wp:advently/calendar {"title":""} /-->',
			],
			true
		);
		return is_wp_error( $id ) ? 0 : (int) $id;
	}

	/**
	 * The newest published page that already holds the shortcode or the block.
	 */
	private static function find(): int {
		global $wpdb;
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- rare lookup (admin, emails), no API searches post content.
		return (int) $wpdb->get_var(
			$wpdb->prepare(
				"SELECT ID FROM {$wpdb->posts} WHERE post_type = 'page' AND post_status = 'publish' AND ( post_content LIKE %s OR post_content LIKE %s ) ORDER BY post_date DESC LIMIT 1",
				'%' . $wpdb->esc_like( '[advently' ) . '%',
				'%' . $wpdb->esc_like( '<!-- wp:advently/calendar' ) . '%'
			)
		);
	}
}