<?php
defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

global $wpdb;

$rt_wa_admin_role = get_role( 'administrator' );
if ( $rt_wa_admin_role ) {
	$rt_wa_admin_role->remove_cap( 'zaaed_manage_leads' );
}

$rt_wa_uninstall_tables = array(
	$wpdb->prefix . 'rt_wa_visitors',
	$wpdb->prefix . 'rt_wa_sessions',
	$wpdb->prefix . 'rt_wa_events',
	$wpdb->prefix . 'rt_wa_api_keys',
	$wpdb->prefix . 'rt_wa_page_views',
	$wpdb->prefix . 'rt_wa_leads',
	$wpdb->prefix . 'rt_wa_lead_status_history',
	$wpdb->prefix . 'rt_wa_utm_links',
);

foreach ( $rt_wa_uninstall_tables as $rt_wa_uninstall_table ) {
	$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i', $rt_wa_uninstall_table ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange
}

$rt_wa_uninstall_options = array(
	'rt_wa_enable_tracking',
	'rt_wa_cookie_lifetime',
	'rt_wa_session_timeout',
	'rt_wa_ignore_logged_in',
	'rt_wa_ignore_admin',
	'rt_wa_excluded_pages',
	'rt_wa_whatsapp_link_patterns',
	'rt_wa_excluded_roles',
	'rt_wa_debug_mode',
	'rt_wa_integration_meta_enable',
	'rt_wa_integration_meta_pixel_id',
	'rt_wa_integration_meta_event_name',
	'rt_wa_integration_ga4_enable',
	'rt_wa_integration_ga4_id',
	'rt_wa_integration_gtm_enable',
	'rt_wa_integration_gtm_id',
	'rt_wa_integration_tiktok_pixel_id',
	'rt_wa_integration_linkedin_insight_id',
	'rt_wa_integration_snapchat_pixel_id',
	'rt_wa_integration_pinterest_tag_id',
	'rt_wa_integration_twitter_pixel_id',
	'rt_wa_integration_google_ads_id',
	'rt_wa_integration_bing_uet_id',
	'rt_wa_integration_clarity_project_id',
	'rt_wa_integration_reddit_pixel_id',
	'rt_wa_integration_quora_pixel_id',
	'rt_wa_integration_yandex_metrika_id',
	'rt_wa_integration_hubspot_id',
	'rt_wa_integration_hotjar_id',
	'rt_wa_privacy_consent_enable',
	'rt_wa_privacy_gdpr_mode',
	'rt_wa_privacy_mask_ip',
	'rt_wa_privacy_retention_days',
	'rt_wa_privacy_policy_template',
	'rt_wa_api_rate_limit',
	'rt_wa_lead_auto_create',
	'rt_wa_lead_currency',
	'rt_wa_utm_default_enable',
	'rt_wa_utm_default_source',
	'rt_wa_utm_default_medium',
	'rt_wa_utm_default_campaign',
	'rt_wa_utm_default_term',
	'rt_wa_utm_default_content',
	'rt_wa_db_version',
	'rt_wa_audience',
	'rt_wa_caps_registered',
	'rt_wa_mig_leads_offset',
	'rt_wa_mig_events_offset',
	'rt_wa_mig_utm_offset',
);

foreach ( $rt_wa_uninstall_options as $rt_wa_uninstall_option ) {
	delete_option( $rt_wa_uninstall_option );
}

delete_transient( 'rt_wa_dashboard_stats' );
delete_transient( 'rt_wa_analytics_data' );

$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$wpdb->prepare(
		'DELETE FROM %i WHERE option_name LIKE %s OR option_name LIKE %s',
		$wpdb->options,
		$wpdb->esc_like( '_transient_rt_wa_rate_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_rt_wa_rate_' ) . '%'
	)
);
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$wpdb->prepare(
		'DELETE FROM %i WHERE option_name LIKE %s OR option_name LIKE %s',
		$wpdb->options,
		$wpdb->esc_like( '_transient_rt_wa_search_rate_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_rt_wa_search_rate_' ) . '%'
	)
);
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$wpdb->prepare(
		'DELETE FROM %i WHERE option_name LIKE %s OR option_name LIKE %s',
		$wpdb->options,
		$wpdb->esc_like( '_transient_rt_wa_track_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_rt_wa_track_' ) . '%'
	)
);
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$wpdb->prepare(
		'DELETE FROM %i WHERE option_name LIKE %s OR option_name LIKE %s',
		$wpdb->options,
		$wpdb->esc_like( '_transient_rt_wa_key_rate_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_rt_wa_key_rate_' ) . '%'
	)
);
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$wpdb->prepare(
		'DELETE FROM %i WHERE option_name LIKE %s OR option_name LIKE %s',
		$wpdb->options,
		$wpdb->esc_like( '_transient_rt_wa_new_api_key_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_rt_wa_new_api_key_' ) . '%'
	)
);