<?php
declare(strict_types=1);

namespace WebCalendar\WP\Database;

defined( 'ABSPATH' ) || exit;

/**
 * Everything keyed to an event id that core's event delete leaves behind.
 *
 * PdoEventRepository::delete() removes the entry, its participants and its
 * recurrence rows, nothing else, and new events take the id MAX(cal_id)+1.
 * So whatever a deleted top-id event leaves here is inherited by the next
 * event anyone creates: an open RSVP registration with the old capacity, the
 * old guests, and pending confirmations that book their guest onto the
 * stranger's event and mail the guest's details to its creator. Every event
 * delete path calls purge() after the event itself is gone.
 */
final class EventSideData {

	/**
	 * Tables holding per-event rows by cal_id, outside core's delete.
	 *
	 * TecImporter deletes inside its own PDO transaction and uses this list
	 * directly, so the two cannot drift.
	 */
	public const TABLES = array(
		'webcal_entry_categories',
		'webcal_reminders',
		'webcal_site_extras',
		'webcal_import_data',
		'webcal_ticket_type',
		'webcal_ticket_order',
		'webcal_attendee',
		'webcal_rsvp_pending',
	);

	/**
	 * Remove one deleted event's rows and options.
	 */
	public static function purge( int $cal_id ): void {
		global $wpdb;

		foreach ( self::TABLES as $table ) {
			// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Plugin tables; nothing to cache on delete.
			$wpdb->delete( $wpdb->prefix . $table, array( 'cal_id' => $cal_id ), array( '%d' ) );
		}

		self::purge_options( $cal_id );
	}

	/**
	 * Remove the per-event options (attachments and featured image).
	 */
	public static function purge_options( int $cal_id ): void {
		delete_option( 'webcal_attachments_' . $cal_id );
		delete_option( 'webcal_featured_image_' . $cal_id );
	}

	/**
	 * Purge every event a calendar owns. Call it before deleting them in
	 * bulk (EventRepository::deleteByCreator), while the ids can still be
	 * listed.
	 */
	public static function purge_creator( string $login ): void {
		global $wpdb;

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Ids of rows about to be deleted.
		$ids = $wpdb->get_col( $wpdb->prepare( 'SELECT cal_id FROM %i WHERE cal_create_by = %s', $wpdb->prefix . 'webcal_entry', $login ) );

		foreach ( $ids as $id ) {
			self::purge( (int) $id );
		}
	}
}