<?php
/**
 * Runs when the plugin is deleted from the Plugins screen: removes the placement setting, every
 * product's quantity settings and any import preview still waiting.
 *
 * @package LayoutFoundryQuantities
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

delete_option( 'lfqty_auto_place' );

// Product settings. delete_post_meta_by_key() runs a prepared query in WordPress core.
foreach ( array( 'enabled', 'product', 'units', 'tile_size', 'pieces_per_pack', 'coverage', 'joint', 'pattern', 'allowance', 'roll_width', 'roll_length', 'pattern_repeat', 'match', 'spread_rate', 'coats', 'tin_size', 'joist_spacing', 'panel_width', 'post_width', 'density', 'bag_size' ) as $lfqty_key ) {
	delete_post_meta_by_key( '_lfqty_' . $lfqty_key );
}

// Import previews and messages are transients that expire within an hour; remove any left.
global $wpdb;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- one-off clean-up on uninstall.
$lfqty_rows = $wpdb->get_col(
	$wpdb->prepare(
		"SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
		$wpdb->esc_like( '_transient_lfqty_preview_' ) . '%',
		$wpdb->esc_like( '_transient_lfqty_error_' ) . '%'
	)
);
foreach ( $lfqty_rows as $lfqty_option ) {
	delete_transient( substr( $lfqty_option, strlen( '_transient_' ) ) );
}