<?php
/**
 * Uninstall: remove the settings, the secret, the message log and the links to chats.
 *
 * @package Orderchirp
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

global $wpdb;

$orderchirp_settings = get_option( 'orderchirp_settings' );
if ( is_array( $orderchirp_settings ) && ! empty( $orderchirp_settings['bot_token'] ) ) {
	wp_remote_post(
		'https://api.telegram.org/bot' . $orderchirp_settings['bot_token'] . '/deleteWebhook',
		array( 'timeout' => 5 )
	);
}

foreach ( array( 'orderchirp_settings', 'orderchirp_secret', 'orderchirp_db_version', 'orderchirp_poll_offset', 'orderchirp_owner_invite' ) as $orderchirp_option ) {
	delete_option( $orderchirp_option );
}

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.SchemaChange,WordPress.DB.DirectDatabaseQuery.NoCaching -- removing our own table.
$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i', $wpdb->prefix . 'orderchirp_log' ) );

delete_metadata( 'user', 0, 'orderchirp_tg_chat', '', true );
delete_metadata( 'post', 0, '_orderchirp_tg_chat', '', true );
delete_metadata( 'post', 0, '_orderchirp_owner_alerted', '', true );
$orderchirp_hpos_meta = $wpdb->prefix . 'wc_orders_meta';
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- one-off clean-up of our own meta keys.
if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $orderchirp_hpos_meta ) ) === $orderchirp_hpos_meta ) {
	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- one-off clean-up of our own meta keys.
	$wpdb->query( $wpdb->prepare( 'DELETE FROM %i WHERE meta_key IN (%s, %s)', $orderchirp_hpos_meta, '_orderchirp_tg_chat', '_orderchirp_owner_alerted' ) );
}

if ( function_exists( 'as_unschedule_all_actions' ) ) {
	as_unschedule_all_actions( '', array(), 'orderchirp' );
}