<?php
/**
 * Uninstall SoftPulse Builder.
 *
 * Default: kuch nahi mitta — pages ka design, templates, forms, submissions aur settings
 * sab mehfooz (dobara install karte hi sab wapas). Sab kuch mitana ho to pehle
 * SoftPulse Builder > Settings > "Delete all SoftPulse Builder data" tick karein.
 *
 * Pages/posts kabhi nahi mitaye jate (user ka content) — sirf plugin ka apna data.
 *
 * @package Buildvex_Plugin
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

global $wpdb;

$buildvex_settings = get_option( 'buildvex_settings', array() );
if ( empty( $buildvex_settings['delete_data'] ) ) {
	return;
}

// Options.
foreach ( array( 'buildvex_settings', 'buildvex_db_version', 'buildvex_legacy_migrated', 'buildvex_flush_rewrite' ) as $buildvex_option ) {
	delete_option( $buildvex_option );
}

// Custom table (fixed name — koi user input nahi).
$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i', $wpdb->prefix . 'buildvex_form_submissions' ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery

// Plugin ke apne post types (templates, forms). Landing pages user content hain — rakhe jate hain.
foreach ( array( 'buildvex_template', 'buildvex_form' ) as $buildvex_type ) {
	$buildvex_ids = get_posts(
		array(
			'post_type'   => $buildvex_type,
			'post_status' => 'any',
			'numberposts' => -1,
			'fields'      => 'ids',
		)
	);
	foreach ( $buildvex_ids as $buildvex_id ) {
		wp_delete_post( $buildvex_id, true );
	}
}

// Builder meta.
delete_post_meta_by_key( '_buildvex_data' );
delete_post_meta_by_key( '_buildvex_page_settings' );

// Transients (AI / form rate limits, AI test result).
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery
	$wpdb->prepare(
		"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
		$wpdb->esc_like( '_transient_buildvex_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_buildvex_' ) . '%'
	)
);