Pasted

/**
 * Aelia EU VAT Assistant for WooCommerce - Update VAT data for existing orders.
 * This code loops through existing orders and calls the EU VAT Assistant functions
 * that update the VAT data stored against each one.
 *
 * HOW TO USE THIS CODE
 * Add the code to the bottom of your theme's functions.php file (see https://www.skyverge.com/blog/add-custom-code-to-wordpress/).
 *
 * The script accepts the following URL arguments:
 * - update_order_vat_data=1. This argument triggers the processing of orders.
 * - start_date=YYMMDD. The script will take orders created on or after this date.
 * - end_date=YYMMDD. The script will take orders created BEFORE this date.
 * - debug=1. If specified, the script will print out debug information.
 *
 * 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
 *
 * @author Aelia
 */
add_action('admin_init', function() {
    if(!is_admin() || empty($_GET['update_order_vat_data']) || !current_user_can('manage_woocommerce')) {
        return;
    }
 
    global $wpdb;
 
    // Start date
    if(isset($_GET['start_date'])) {
        $start_date = $_GET['start_date'];
    }
    else {
        // Take the 1st of January of current year as the default start date
        $start_date = date('Y0101');
    }
 
    // End date
    if(isset($_GET['end_date'])) {
        $end_date = $_GET['end_date'];
    }
    else {
        // Take tomorrow as the default end date
        $default_end_date = new DateTime('tomorrow');
        $end_date = $default_end_date->format('Ymd');
    }
 
    $px = $wpdb->prefix;
    $SQL = "
        SELECT
            ORDERS.ID AS order_id
        FROM
            {$px}posts AS ORDERS
        WHERE
            (ORDERS.post_type IN ('shop_order')) AND
            (ORDERS.post_status IN ('wc-processing', 'wc-completed')) AND
            (ORDERS.post_date >= '$start_date') AND
            (ORDERS.post_date < '$end_date')
    ";
 
    // Debug
    if(isset($_GET['debug'])) {
        var_dump($SQL);
    }
    // Fetch the orders to process
    $dataset = $wpdb->get_results($SQL);
 
    if(isset($_GET['debug'])) {
        var_dump($SQL, $dataset);
    }
 
    foreach($dataset as $entry) {
        $order = new \Aelia\WC\EU_VAT_Assistant\Order($entry->order_id);
        // Generate and store details about order VAT
        $order->update_vat_data();
        // Save EU VAT compliance evidence
        //$order->store_vat_evidence();
    }
});