Pasted

/**
 * Triggers EU VAT Assistant's collection of VAT data for past orders, in a specific range of order IDs.
 *
 * HOW TO USE THIS CODE
 * 1. Add the code to the bottom of your theme's functions.php file (see https://www.skyverge.com/blog/add-custom-code-to-wordpress/).
 * 2. Open the EU VAT Assistant settings page, by going to WooCommerce > EU VAT Assistant.
 * 3. Change the URL of the page, by adding the following arguments to it:
 *  - process_vat_past_orders=1
 *  - from_order_id = <ID OF THE FIRST ORDER TO PROCESS>
 *  - to_order_id = <ID OF THE LAST ORDER TO PROCESS>
 * Example: https://example.org/wp-admin/admin.php?page=wc_aelia_eu_vat_assistant&process_vat_past_orders=1&from_order_id=123&to_order_id=567
 * 4. Load the new URL. The EU VAT Assistant will process past orders, and print out the list of the order IDS
 *    it processed. The output will be "raw" (i.e. not very aesthetically pleasing, as its purpose is just 
 *    debugging).
 *
 * GPL DISCLAIMER
 * Because this code program is free of charge, there is no warranty for it, to the extent permitted by applicable law.
 * Except when otherwise stated in writing the copyright holders and/or other parties provide the program "as is"
 * without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of
 * merchantability and fitness for a particular purpose. The entire risk as to the quality and performance of the program
 * is with you. should the program prove defective, you assume the cost of all necessary servicing, repair or correction.
 *
 * Need a consultation, or assistance to customise this code? Find us on Codeable: https://aelia.co/hire_us
 */
add_action('admin_init', function() {
    if(!@$_GET['process_vat_past_orders']) {
        return;
    }
 
    if(!@$_GET['from_order_id']) {
      return;
    }
 
    if(!@$_GET['to_order_id']) {
      return;
    }
 
    // Get the minimum and maximum order ID to process
    $min_order_id = $_GET['from_order_id']);
    $max_order_id = $_GET['to_order_id'];
 
    global $wpdb;
    $SQL = "
        SELECT
            P.ID
        FROM {$wpdb->posts} P
        WHERE
            (P.post_type = 'shop_order') AND
            (P.ID BETWEEN {$min_order_id} AND {$max_order_id})
        ORDER BY
            P.ID
    ";
    // Get the list of order IDs to process
    $orders = $wpdb->get_results($SQL);
 
    // Extract the IDs from the list of objects returned
    // by the WPDB query
    $orders = wp_list_pluck($orders, 'ID');
 
    foreach($orders as $order_id) {
        // Display the order being processed. That can be used in case the
        // processing times out, to resume the processing
        echo "PROCESSING ORDER ID: {$order_id}<br>";
 
        // Load the order
        $order = new \Aelia\WC\EU_VAT_Assistant\Order($order_id);
        if(!is_object($order)) {
            continue;
        }
 
        // Update the order meta, as the EU VAT Assistant would do
        $order->update_meta_data('vat_number', '');
        $order->update_meta_data('_vat_country', $order->get_billing_country());
        $order->update_meta_data('_vat_number_validated', 'no-number');
        $order->update_meta_data('vies_response', array());
        $order->update_meta_data('vies_consultation_number', 'Not returned');
        $order->update_meta_data('_customer_location_self_certified', 'no');
        $order->save();
 
        // Generate and store details about order VAT
        $order->update_vat_data();
        // Save EU VAT compliance evidence
        $order->store_vat_evidence();
    }
});