<form method="POST">
    <h3>Editing: class-wc-order-data-store-cpt.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
/**
 * WC_Order_Data_Store_CPT class file.
 *
 * @package WooCommerce\Classes
 */

use Automattic\WooCommerce\Utilities\OrderUtil;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/**
 * WC Order Data Store: Stored in CPT.
 *
 * @version  3.0.0
 */
class WC_Order_Data_Store_CPT extends Abstract_WC_Order_Data_Store_CPT implements WC_Object_Data_Store_Interface, WC_Order_Data_Store_Interface {

	/**
	 * Data stored in meta keys, but not considered &quot;meta&quot; for an order.
	 *
	 * @since 3.0.0
	 * @var array
	 */
	protected $internal_meta_keys = array(
		'_customer_user',
		'_order_key',
		'_order_currency',
		'_billing_first_name',
		'_billing_last_name',
		'_billing_company',
		'_billing_address_1',
		'_billing_address_2',
		'_billing_city',
		'_billing_state',
		'_billing_postcode',
		'_billing_country',
		'_billing_email',
		'_billing_phone',
		'_shipping_first_name',
		'_shipping_last_name',
		'_shipping_company',
		'_shipping_address_1',
		'_shipping_address_2',
		'_shipping_city',
		'_shipping_state',
		'_shipping_postcode',
		'_shipping_country',
		'_shipping_phone',
		'_completed_date',
		'_paid_date',
		'_edit_lock',
		'_edit_last',
		'_cart_discount',
		'_cart_discount_tax',
		'_order_shipping',
		'_order_shipping_tax',
		'_order_tax',
		'_order_total',
		'_payment_method',
		'_payment_method_title',
		'_transaction_id',
		'_customer_ip_address',
		'_customer_user_agent',
		'_created_via',
		'_order_version',
		'_prices_include_tax',
		'_date_completed',
		'_date_paid',
		'_payment_tokens',
		'_billing_address_index',
		'_shipping_address_index',
		'_recorded_sales',
		'_recorded_coupon_usage_counts',
		'_download_permissions_granted',
		'_order_stock_reduced',
		'_new_order_email_sent',
	);

	/**
	 * Custom setters for props. Add key here if it has corresponding set_ and get_ method present.
	 *
	 * @var string[]
	 */
	protected $internal_data_store_key_getters = array(
		'_download_permissions_granted' =&gt; 'download_permissions_granted',
		'_recorded_sales'               =&gt; 'recorded_sales',
		'_recorded_coupon_usage_counts' =&gt; 'recorded_coupon_usage_counts',
		'_order_stock_reduced'          =&gt; 'order_stock_reduced',
		'_new_order_email_sent'         =&gt; 'new_order_email_sent',
	);

	/**
	 * Method to create a new order in the database.
	 *
	 * @param WC_Order $order Order object.
	 */
	public function create( &amp;$order ) {
		if ( '' === $order-&gt;get_order_key() ) {
			$order-&gt;set_order_key( wc_generate_order_key() );
		}
		parent::create( $order );

		// Do not fire 'woocommerce_new_order' for draft statuses.
		if ( in_array( $order-&gt;get_status( 'edit' ), array( 'auto-draft', 'draft', 'checkout-draft' ), true ) ) {
			return;
		}

		do_action( 'woocommerce_new_order', $order-&gt;get_id(), $order );
	}

	/**
	 * Read order data. Can be overridden by child classes to load other props.
	 *
	 * @param WC_Order $order Order object.
	 * @param object   $post_object Post object.
	 * @since 3.0.0
	 */
	protected function read_order_data( &amp;$order, $post_object ) {
		parent::read_order_data( $order, $post_object );
		$id             = $order-&gt;get_id();
		$date_completed = get_post_meta( $id, '_date_completed', true );
		$date_paid      = get_post_meta( $id, '_date_paid', true );

		if ( ! $date_completed ) {
			$date_completed = get_post_meta( $id, '_completed_date', true );
		}

		if ( ! $date_paid ) {
			$date_paid = get_post_meta( $id, '_paid_date', true );
		}

		$order-&gt;set_props(
			array(
				'order_key'                    =&gt; get_post_meta( $id, '_order_key', true ),
				'customer_id'                  =&gt; get_post_meta( $id, '_customer_user', true ),
				'billing_first_name'           =&gt; get_post_meta( $id, '_billing_first_name', true ),
				'billing_last_name'            =&gt; get_post_meta( $id, '_billing_last_name', true ),
				'billing_company'              =&gt; get_post_meta( $id, '_billing_company', true ),
				'billing_address_1'            =&gt; get_post_meta( $id, '_billing_address_1', true ),
				'billing_address_2'            =&gt; get_post_meta( $id, '_billing_address_2', true ),
				'billing_city'                 =&gt; get_post_meta( $id, '_billing_city', true ),
				'billing_state'                =&gt; get_post_meta( $id, '_billing_state', true ),
				'billing_postcode'             =&gt; get_post_meta( $id, '_billing_postcode', true ),
				'billing_country'              =&gt; get_post_meta( $id, '_billing_country', true ),
				'billing_email'                =&gt; get_post_meta( $id, '_billing_email', true ),
				'billing_phone'                =&gt; get_post_meta( $id, '_billing_phone', true ),
				'shipping_first_name'          =&gt; get_post_meta( $id, '_shipping_first_name', true ),
				'shipping_last_name'           =&gt; get_post_meta( $id, '_shipping_last_name', true ),
				'shipping_company'             =&gt; get_post_meta( $id, '_shipping_company', true ),
				'shipping_address_1'           =&gt; get_post_meta( $id, '_shipping_address_1', true ),
				'shipping_address_2'           =&gt; get_post_meta( $id, '_shipping_address_2', true ),
				'shipping_city'                =&gt; get_post_meta( $id, '_shipping_city', true ),
				'shipping_state'               =&gt; get_post_meta( $id, '_shipping_state', true ),
				'shipping_postcode'            =&gt; get_post_meta( $id, '_shipping_postcode', true ),
				'shipping_country'             =&gt; get_post_meta( $id, '_shipping_country', true ),
				'shipping_phone'               =&gt; get_post_meta( $id, '_shipping_phone', true ),
				'payment_method'               =&gt; get_post_meta( $id, '_payment_method', true ),
				'payment_method_title'         =&gt; get_post_meta( $id, '_payment_method_title', true ),
				'transaction_id'               =&gt; get_post_meta( $id, '_transaction_id', true ),
				'customer_ip_address'          =&gt; get_post_meta( $id, '_customer_ip_address', true ),
				'customer_user_agent'          =&gt; get_post_meta( $id, '_customer_user_agent', true ),
				'created_via'                  =&gt; get_post_meta( $id, '_created_via', true ),
				'date_completed'               =&gt; $date_completed,
				'date_paid'                    =&gt; $date_paid,
				'cart_hash'                    =&gt; get_post_meta( $id, '_cart_hash', true ),
				'customer_note'                =&gt; $post_object-&gt;post_excerpt,

				// Operational data props.
				'order_stock_reduced'          =&gt; get_post_meta( $id, '_order_stock_reduced', true ),
				'download_permissions_granted' =&gt; get_post_meta( $id, '_download_permissions_granted', true ),
				'new_order_email_sent'         =&gt; get_post_meta( $id, '_new_order_email_sent', true ),
				'recorded_sales'               =&gt; wc_string_to_bool( get_post_meta( $id, '_recorded_sales', true ) ),
				'recorded_coupon_usage_counts' =&gt; get_post_meta( $id, '_recorded_coupon_usage_counts', true ),
			)
		);
	}

	/**
	 * Method to update an order in the database.
	 *
	 * @param WC_Order $order Order object.
	 */
	public function update( &amp;$order ) {
		// Before updating, ensure date paid is set if missing.
		if ( ! $order-&gt;get_date_paid( 'edit' ) &amp;&amp; version_compare( $order-&gt;get_version( 'edit' ), '3.0', '&lt;' ) &amp;&amp; $order-&gt;has_status( apply_filters( 'woocommerce_payment_complete_order_status', $order-&gt;needs_processing() ? 'processing' : 'completed', $order-&gt;get_id(), $order ) ) ) {
			$order-&gt;set_date_paid( $order-&gt;get_date_created( 'edit' ) );
		}

		// Also grab the current status so we can compare.
		$previous_status = get_post_status( $order-&gt;get_id() );
		// If the order doesn't exist in the DB, we will consider it as new.
		if ( ! $previous_status &amp;&amp; $order-&gt;get_id() === 0 ) {
			$previous_status = 'new';
		}

		// Update the order.
		parent::update( $order );

		$current_status = $order-&gt;get_status( 'edit' );

		// We need to remove the wc- prefix from the status for comparison and proper evaluation of new vs updated orders.
		$previous_status = OrderUtil::remove_status_prefix( $previous_status );
		$current_status  = OrderUtil::remove_status_prefix( $current_status );

		$draft_statuses = array( 'new', 'auto-draft', 'draft', 'checkout-draft' );

		// This hook should be fired only if the new status is not one of draft statuses and the previous status was one of the draft statuses.
		if (
			$current_status !== $previous_status
			&amp;&amp; ! in_array( $current_status, $draft_statuses, true )
			&amp;&amp; in_array( $previous_status, $draft_statuses, true )
		) {
			do_action( 'woocommerce_new_order', $order-&gt;get_id(), $order );  // phpcs:ignore WooCommerce.Commenting.CommentHooks.MissingHookComment
			return;
		}

		do_action( 'woocommerce_update_order', $order-&gt;get_id(), $order );  // phpcs:ignore WooCommerce.Commenting.CommentHooks.MissingHookComment
	}

	/**
	 * Helper method that updates all the post meta for an order based on its settings in the WC_Order class.
	 *
	 * @param WC_Order $order Order object.
	 * @since 3.0.0
	 */
	protected function update_post_meta( &amp;$order ) {
		$updated_props     = array();
		$id                = $order-&gt;get_id();
		$meta_key_to_props = array(
			'_order_key'                    =&gt; 'order_key',
			'_customer_user'                =&gt; 'customer_id',
			'_payment_method'               =&gt; 'payment_method',
			'_payment_method_title'         =&gt; 'payment_method_title',
			'_transaction_id'               =&gt; 'transaction_id',
			'_customer_ip_address'          =&gt; 'customer_ip_address',
			'_customer_user_agent'          =&gt; 'customer_user_agent',
			'_created_via'                  =&gt; 'created_via',
			'_date_completed'               =&gt; 'date_completed',
			'_date_paid'                    =&gt; 'date_paid',
			'_cart_hash'                    =&gt; 'cart_hash',
			'_download_permissions_granted' =&gt; 'download_permissions_granted',
			'_recorded_sales'               =&gt; 'recorded_sales',
			'_recorded_coupon_usage_counts' =&gt; 'recorded_coupon_usage_counts',
			'_new_order_email_sent'         =&gt; 'new_order_email_sent',
			'_order_stock_reduced'          =&gt; 'order_stock_reduced',
		);

		$props_to_update = $this-&gt;get_props_to_update( $order, $meta_key_to_props );

		foreach ( $props_to_update as $meta_key =&gt; $prop ) {
			$value = $order-&gt;{&quot;get_$prop&quot;}( 'edit' );
			$value = is_string( $value ) ? wp_slash( $value ) : $value;
			switch ( $prop ) {
				case 'date_paid':
				case 'date_completed':
					$value = ! is_null( $value ) ? $value-&gt;getTimestamp() : '';
					break;
				case 'download_permissions_granted':
				case 'recorded_sales':
				case 'recorded_coupon_usage_counts':
				case 'order_stock_reduced':
					if ( is_null( $value ) || '' === $value ) {
						break;
					}
					$value = is_bool( $value ) ? wc_bool_to_string( $value ) : $value;
					break;
				case 'new_order_email_sent':
					if ( is_null( $value ) || '' === $value ) {
						break;
					}
					$value = is_bool( $value ) ? wc_bool_to_string( $value ) : $value;
					$value = 'yes' === $value ? 'true' : 'false'; // For backward compatibility, we store as true/false in DB.
					break;
			}

			// We want to persist internal data store keys as 'yes' or 'no' if they are boolean to maintain compatibility.
			if ( is_bool( $value ) &amp;&amp; in_array( $prop, array_values( $this-&gt;internal_data_store_key_getters ), true ) ) {
				$value = wc_bool_to_string( $value );
			}

			$updated = $this-&gt;update_or_delete_post_meta( $order, $meta_key, $value );

			if ( $updated ) {
				$updated_props[] = $prop;
			}
		}

		$address_props = array(
			'billing'  =&gt; array(
				'_billing_first_name' =&gt; 'billing_first_name',
				'_billing_last_name'  =&gt; 'billing_last_name',
				'_billing_company'    =&gt; 'billing_company',
				'_billing_address_1'  =&gt; 'billing_address_1',
				'_billing_address_2'  =&gt; 'billing_address_2',
				'_billing_city'       =&gt; 'billing_city',
				'_billing_state'      =&gt; 'billing_state',
				'_billing_postcode'   =&gt; 'billing_postcode',
				'_billing_country'    =&gt; 'billing_country',
				'_billing_email'      =&gt; 'billing_email',
				'_billing_phone'      =&gt; 'billing_phone',
			),
			'shipping' =&gt; array(
				'_shipping_first_name' =&gt; 'shipping_first_name',
				'_shipping_last_name'  =&gt; 'shipping_last_name',
				'_shipping_company'    =&gt; 'shipping_company',
				'_shipping_address_1'  =&gt; 'shipping_address_1',
				'_shipping_address_2'  =&gt; 'shipping_address_2',
				'_shipping_city'       =&gt; 'shipping_city',
				'_shipping_state'      =&gt; 'shipping_state',
				'_shipping_postcode'   =&gt; 'shipping_postcode',
				'_shipping_country'    =&gt; 'shipping_country',
				'_shipping_phone'      =&gt; 'shipping_phone',
			),
		);

		foreach ( $address_props as $props_key =&gt; $props ) {
			$props_to_update = $this-&gt;get_props_to_update( $order, $props );
			foreach ( $props_to_update as $meta_key =&gt; $prop ) {
				$value   = $order-&gt;{&quot;get_$prop&quot;}( 'edit' );
				$value   = is_string( $value ) ? wp_slash( $value ) : $value;
				$updated = $this-&gt;update_or_delete_post_meta( $order, $meta_key, $value );

				if ( $updated ) {
					$updated_props[] = $prop;
					$updated_props[] = $props_key;
				}
			}
		}

		parent::update_post_meta( $order );

		// If address changed, store concatenated version to make searches faster.
		if ( in_array( 'billing', $updated_props, true ) || ! metadata_exists( 'post', $id, '_billing_address_index' ) ) {
			update_post_meta( $id, '_billing_address_index', implode( ' ', $order-&gt;get_address( 'billing' ) ) );
		}
		if ( in_array( 'shipping', $updated_props, true ) || ! metadata_exists( 'post', $id, '_shipping_address_index' ) ) {
			update_post_meta( $id, '_shipping_address_index', implode( ' ', $order-&gt;get_address( 'shipping' ) ) );
		}

		// Legacy date handling. @todo remove in 4.0.
		if ( in_array( 'date_paid', $updated_props, true ) ) {
			$value = $order-&gt;get_date_paid( 'edit' );
			// In 2.6.x date_paid was stored as _paid_date in local mysql format.
			update_post_meta( $id, '_paid_date', ! is_null( $value ) ? $value-&gt;date( 'Y-m-d H:i:s' ) : '' );
		}

		if ( in_array( 'date_completed', $updated_props, true ) ) {
			$value = $order-&gt;get_date_completed( 'edit' );
			// In 2.6.x date_completed was stored as _completed_date in local mysql format.
			update_post_meta( $id, '_completed_date', ! is_null( $value ) ? $value-&gt;date( 'Y-m-d H:i:s' ) : '' );
		}

		// If customer changed, update any downloadable permissions.
		if ( in_array( 'customer_id', $updated_props, true ) || in_array( 'billing_email', $updated_props, true ) ) {
			$data_store = WC_Data_Store::load( 'customer-download' );
			$data_store-&gt;update_user_by_order_id( $id, $order-&gt;get_customer_id(), $order-&gt;get_billing_email() );
		}

		// Mark user account as active.
		if ( in_array( 'customer_id', $updated_props, true ) ) {
			wc_update_user_last_active( $order-&gt;get_customer_id() );
		}

		do_action( 'woocommerce_order_object_updated_props', $order, $updated_props );
	}

	/**
	 * Excerpt for post.
	 *
	 * @param  WC_Order $order Order object.
	 * @return string
	 */
	protected function get_post_excerpt( $order ) {
		return $order-&gt;get_customer_note();
	}

	/**
	 * Get order key.
	 *
	 * @since 4.3.0
	 * @param WC_order $order Order object.
	 * @return string
	 */
	protected function get_order_key( $order ) {
		if ( '' !== $order-&gt;get_order_key() ) {
			return $order-&gt;get_order_key();
		}

		return parent::get_order_key( $order );
	}

	/**
	 * Get amount already refunded.
	 *
	 * @param  WC_Order $order Order object.
	 * @return float
	 */
	public function get_total_refunded( $order ) {
		global $wpdb;

		$total = $wpdb-&gt;get_var(
			$wpdb-&gt;prepare(
				&quot;SELECT SUM( postmeta.meta_value )
				FROM $wpdb-&gt;postmeta AS postmeta
				INNER JOIN $wpdb-&gt;posts AS posts ON ( posts.post_type = 'shop_order_refund' AND posts.post_parent = %d )
				WHERE postmeta.meta_key = '_refund_amount'
				AND postmeta.post_id = posts.ID&quot;,
				$order-&gt;get_id()
			)
		);

		return floatval( $total );
	}

	/**
	 * Get the total tax refunded.
	 *
	 * @param  WC_Order $order Order object.
	 * @return float
	 */
	public function get_total_tax_refunded( $order ) {
		global $wpdb;

		$total = $wpdb-&gt;get_var(
			$wpdb-&gt;prepare(
				&quot;SELECT SUM( order_itemmeta.meta_value )
				FROM {$wpdb-&gt;prefix}woocommerce_order_itemmeta AS order_itemmeta
				INNER JOIN $wpdb-&gt;posts AS posts ON ( posts.post_type = 'shop_order_refund' AND posts.post_parent = %d )
				INNER JOIN {$wpdb-&gt;prefix}woocommerce_order_items AS order_items ON ( order_items.order_id = posts.ID AND order_items.order_item_type = 'tax' )
				WHERE order_itemmeta.order_item_id = order_items.order_item_id
				AND order_itemmeta.meta_key IN ('tax_amount', 'shipping_tax_amount')&quot;,
				$order-&gt;get_id()
			)
		) ?? 0;

		return abs( $total );
	}

	/**
	 * Get the total shipping refunded.
	 *
	 * @param  WC_Order $order Order object.
	 * @return float
	 */
	public function get_total_shipping_refunded( $order ) {
		global $wpdb;

		$total = $wpdb-&gt;get_var(
			$wpdb-&gt;prepare(
				&quot;SELECT SUM( order_itemmeta.meta_value )
				FROM {$wpdb-&gt;prefix}woocommerce_order_itemmeta AS order_itemmeta
				INNER JOIN $wpdb-&gt;posts AS posts ON ( posts.post_type = 'shop_order_refund' AND posts.post_parent = %d )
				INNER JOIN {$wpdb-&gt;prefix}woocommerce_order_items AS order_items ON ( order_items.order_id = posts.ID AND order_items.order_item_type = 'shipping' )
				WHERE order_itemmeta.order_item_id = order_items.order_item_id
				AND order_itemmeta.meta_key IN ('cost')&quot;,
				$order-&gt;get_id()
			)
		) ?? 0;

		return abs( $total );
	}

	/**
	 * Finds an Order ID based on an order key.
	 *
	 * @param string $order_key An order key has generated by.
	 * @return int The ID of an order, or 0 if the order could not be found
	 */
	public function get_order_id_by_order_key( $order_key ) {
		global $wpdb;
		return $wpdb-&gt;get_var( $wpdb-&gt;prepare( &quot;SELECT post_id FROM {$wpdb-&gt;prefix}postmeta WHERE meta_key = '_order_key' AND meta_value = %s&quot;, $order_key ) );
	}

	/**
	 * Return count of orders with a specific status.
	 *
	 * @param  string $status Order status. Function wc_get_order_statuses() returns a list of valid statuses.
	 * @return int
	 */
	public function get_order_count( $status ) {
		global $wpdb;
		return absint( $wpdb-&gt;get_var( $wpdb-&gt;prepare( &quot;SELECT COUNT( * ) FROM {$wpdb-&gt;posts} WHERE post_type = 'shop_order' AND post_status = %s&quot;, $status ) ) );
	}

	/**
	 * Get all orders matching the passed in args.
	 *
	 * @deprecated 3.1.0 - Use wc_get_orders instead.
	 * @see    wc_get_orders()
	 *
	 * @param  array $args List of args passed to wc_get_orders().
	 *
	 * @return array|object
	 */
	public function get_orders( $args = array() ) {
		wc_deprecated_function( 'WC_Order_Data_Store_CPT::get_orders', '3.1.0', 'Use wc_get_orders instead.' );
		return wc_get_orders( $args );
	}

	/**
	 * Generate meta query for wc_get_orders.
	 *
	 * @param  array  $values List of customers ids or emails.
	 * @param  string $relation 'or' or 'and' relation used to build the WP meta_query.
	 * @return array
	 */
	private function get_orders_generate_customer_meta_query( $values, $relation = 'or' ) {
		$meta_query = array(
			'relation'        =&gt; strtoupper( $relation ),
			'customer_emails' =&gt; array(
				'key'     =&gt; '_billing_email',
				'value'   =&gt; array(),
				'compare' =&gt; 'IN',
			),
			'customer_ids'    =&gt; array(
				'key'     =&gt; '_customer_user',
				'value'   =&gt; array(),
				'compare' =&gt; 'IN',
			),
		);
		foreach ( $values as $value ) {
			if ( is_array( $value ) ) {
				$query_part = $this-&gt;get_orders_generate_customer_meta_query( $value, 'and' );
				if ( is_wp_error( $query_part ) ) {
					return $query_part;
				}
				$meta_query[] = $query_part;
			} elseif ( is_email( $value ) ) {
				$meta_query['customer_emails']['value'][] = sanitize_email( $value );
			} elseif ( is_numeric( $value ) ) {
				$meta_query['customer_ids']['value'][] = strval( absint( $value ) );
			} else {
				return new WP_Error( 'woocommerce_query_invalid', __( 'Invalid customer query.', 'woocommerce' ), $values );
			}
		}

		if ( empty( $meta_query['customer_emails']['value'] ) ) {
			unset( $meta_query['customer_emails'] );
			unset( $meta_query['relation'] );
		}

		if ( empty( $meta_query['customer_ids']['value'] ) ) {
			unset( $meta_query['customer_ids'] );
			unset( $meta_query['relation'] );
		}

		return $meta_query;
	}

	/**
	 * Get unpaid orders after a certain date,
	 *
	 * @param  int $date Timestamp.
	 * @return array
	 */
	public function get_unpaid_orders( $date ) {
		global $wpdb;

		$unpaid_orders = $wpdb-&gt;get_col(
			$wpdb-&gt;prepare(
			// @codingStandardsIgnoreStart
				&quot;SELECT posts.ID
				FROM {$wpdb-&gt;posts} AS posts
				WHERE   posts.post_type   IN ('&quot; . implode( &quot;','&quot;, wc_get_order_types() ) . &quot;')
				AND     posts.post_status = 'wc-pending'
				AND     posts.post_modified &lt; %s&quot;,
				// @codingStandardsIgnoreEnd
				gmdate( 'Y-m-d H:i:s', absint( $date ) )
			)
		);

		return $unpaid_orders;
	}

	/**
	 * Search order data for a term and return ids.
	 *
	 * @param  string $term Searched term.
	 * @return array of ids
	 */
	public function search_orders( $term ) {
		global $wpdb;

		/**
		 * Searches on meta data can be slow - this lets you choose what fields to search.
		 * 3.0.0 added _billing_address and _shipping_address meta which contains all address data to make this faster.
		 * This however won't work on older orders unless updated, so search a few others (expand this using the filter if needed).
		 *
		 * @var array
		 */
		$search_fields = array_map(
			'wc_clean',
			apply_filters(
				'woocommerce_shop_order_search_fields',
				array(
					'_billing_address_index',
					'_shipping_address_index',
					'_billing_last_name',
					'_billing_email',
					'_billing_phone',
				)
			)
		);
		$order_ids     = array();

		if ( is_numeric( $term ) ) {
			$order_ids[] = absint( $term );
		}

		if ( ! empty( $search_fields ) ) {
			$order_ids = array_unique(
				array_merge(
					$order_ids,
					$wpdb-&gt;get_col(
						$wpdb-&gt;prepare(
							&quot;SELECT DISTINCT p1.post_id FROM {$wpdb-&gt;postmeta} p1 WHERE p1.meta_value LIKE %s AND p1.meta_key IN ('&quot; . implode( &quot;','&quot;, array_map( 'esc_sql', $search_fields ) ) . &quot;')&quot;, // @codingStandardsIgnoreLine
							'%' . $wpdb-&gt;esc_like( wc_clean( $term ) ) . '%'
						)
					),
					$wpdb-&gt;get_col(
						$wpdb-&gt;prepare(
							&quot;SELECT order_id
							FROM {$wpdb-&gt;prefix}woocommerce_order_items as order_items
							WHERE order_item_name LIKE %s&quot;,
							'%' . $wpdb-&gt;esc_like( wc_clean( $term ) ) . '%'
						)
					),
					$wpdb-&gt;get_col(
						$wpdb-&gt;prepare(
							&quot;SELECT DISTINCT os.order_id FROM {$wpdb-&gt;prefix}wc_order_stats os
							INNER JOIN {$wpdb-&gt;prefix}wc_customer_lookup cl ON os.customer_id = cl.customer_id
							INNER JOIN {$wpdb-&gt;usermeta} um ON cl.user_id = um.user_id
							WHERE (um.meta_key = 'billing_phone' OR um.meta_key = 'shipping_phone')
							AND um.meta_value = %s&quot;,
							wc_clean( $term )
						)
					)
				)
			);
		}

		return apply_filters( 'woocommerce_shop_order_search_results', $order_ids, $term, $search_fields );
	}

	/**
	 * Gets information about whether permissions were generated yet.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @return bool
	 */
	public function get_download_permissions_granted( $order ) {
		$order_id = WC_Order_Factory::get_order_id( $order );
		return wc_string_to_bool( get_post_meta( $order_id, '_download_permissions_granted', true ) );
	}

	/**
	 * Stores information about whether permissions were generated yet.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_download_permissions_granted( $order, $set ) {
		if ( $order instanceof WC_Order ) {
			$order-&gt;set_download_permissions_granted( $set );
		}
		$order_id = WC_Order_Factory::get_order_id( $order );
		update_post_meta( $order_id, '_download_permissions_granted', wc_bool_to_string( $set ) );
	}

	/**
	 * Gets information about whether sales were recorded.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @return bool
	 */
	public function get_recorded_sales( $order ) {
		$order_id = WC_Order_Factory::get_order_id( $order );
		return wc_string_to_bool( get_post_meta( $order_id, '_recorded_sales', true ) );
	}

	/**
	 * Stores information about whether sales were recorded.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_recorded_sales( $order, $set ) {
		if ( $order instanceof WC_Order ) {
			$order-&gt;set_recorded_sales( $set );
		}
		$order_id = WC_Order_Factory::get_order_id( $order );
		update_post_meta( $order_id, '_recorded_sales', wc_bool_to_string( $set ) );
	}

	/**
	 * Gets information about whether coupon counts were updated.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @return bool
	 */
	public function get_recorded_coupon_usage_counts( $order ) {
		$order_id = WC_Order_Factory::get_order_id( $order );
		return wc_string_to_bool( get_post_meta( $order_id, '_recorded_coupon_usage_counts', true ) );
	}

	/**
	 * Stores information about whether coupon counts were updated.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_recorded_coupon_usage_counts( $order, $set ) {
		if ( $order instanceof WC_Order ) {
			$order-&gt;set_recorded_coupon_usage_counts( $set );
		}
		$order_id = WC_Order_Factory::get_order_id( $order );
		update_post_meta( $order_id, '_recorded_coupon_usage_counts', wc_bool_to_string( $set ) );
	}

	/**
	 * Whether email have been sent for this order.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 *
	 * @return bool               Whether email is sent.
	 */
	public function get_email_sent( $order ) {
		$order_id = WC_Order_Factory::get_order_id( $order );
		return wc_string_to_bool( get_post_meta( $order_id, '_new_order_email_sent', true ) );
	}

	/**
	 * Whether email have been sent for this order.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 *
	 * @return bool               Whether email is sent.
	 */
	public function get_new_order_email_sent( $order ) {
		return $this-&gt;get_email_sent( $order );
	}

	/**
	 * Stores information about whether email was sent.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_email_sent( $order, $set ) {
		if ( $order instanceof WC_Order ) {
			$order-&gt;set_new_order_email_sent( $set );
		}
		$order_id = WC_Order_Factory::get_order_id( $order );
		$value    = wc_bool_to_string( $set );
		$value    = 'yes' === $value ? 'true' : 'false'; // For backward compat, we store this as true|false string.
		update_post_meta( $order_id, '_new_order_email_sent', $value );
	}

	/**
	 * Stores information about whether email was sent.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_new_order_email_sent( $order, $set ) {
		$this-&gt;set_email_sent( $order, $set );
	}

	/**
	 * Return array of coupon_code =&gt; meta_key for coupon which have usage limit and have tentative keys.
	 * Pass $coupon_id if key for only one of the coupon is needed.
	 *
	 * @param WC_Order $order     Order object.
	 * @param int      $coupon_id If passed, will return held key for that coupon.
	 *
	 * @return array|string Key value pair for coupon code and meta key name. If $coupon_id is passed, returns meta_key for only that coupon.
	 */
	public function get_coupon_held_keys( $order, $coupon_id = null ) {
		$held_keys = $order-&gt;get_meta( '_coupon_held_keys' );
		if ( $coupon_id ) {
			return isset( $held_keys[ $coupon_id ] ) ? $held_keys[ $coupon_id ] : null;
		}
		return $held_keys;
	}

	/**
	 * Return array of coupon_code =&gt; meta_key for coupon which have usage limit per customer and have tentative keys.
	 *
	 * @param WC_Order $order Order object.
	 * @param int      $coupon_id If passed, will return held key for that coupon.
	 *
	 * @return mixed
	 */
	public function get_coupon_held_keys_for_users( $order, $coupon_id = null ) {
		$held_keys_for_user = $order-&gt;get_meta( '_coupon_held_keys_for_users' );
		if ( $coupon_id ) {
			return isset( $held_keys_for_user[ $coupon_id ] ) ? $held_keys_for_user[ $coupon_id ] : null;
		}
		return $held_keys_for_user;
	}

	/**
	 * Add/Update list of meta keys that are currently being used by this order to hold a coupon.
	 * This is used to figure out what all meta entries we should delete when order is cancelled/completed.
	 *
	 * @param WC_Order $order              Order object.
	 * @param array    $held_keys          Array of coupon_code =&gt; meta_key.
	 * @param array    $held_keys_for_user Array of coupon_code =&gt; meta_key for held coupon for user.
	 *
	 * @return mixed
	 */
	public function set_coupon_held_keys( $order, $held_keys, $held_keys_for_user ) {
		if ( is_array( $held_keys ) &amp;&amp; 0 &lt; count( $held_keys ) ) {
			$order-&gt;update_meta_data( '_coupon_held_keys', $held_keys );
		}
		if ( is_array( $held_keys_for_user ) &amp;&amp; 0 &lt; count( $held_keys_for_user ) ) {
			$order-&gt;update_meta_data( '_coupon_held_keys_for_users', $held_keys_for_user );
		}
	}

	/**
	 * Release all coupons held by this order.
	 *
	 * @param WC_Order $order Current order object.
	 * @param bool     $save  Whether to delete keys from DB right away. Could be useful to pass `false` if you are building a bulk request.
	 */
	public function release_held_coupons( $order, $save = true ) {
		$coupon_held_keys = $this-&gt;get_coupon_held_keys( $order );
		if ( is_array( $coupon_held_keys ) ) {
			foreach ( $coupon_held_keys as $coupon_id =&gt; $meta_key ) {
				delete_post_meta( $coupon_id, $meta_key );
			}
		}
		$order-&gt;delete_meta_data( '_coupon_held_keys' );

		$coupon_held_keys_for_users = $this-&gt;get_coupon_held_keys_for_users( $order );
		if ( is_array( $coupon_held_keys_for_users ) ) {
			foreach ( $coupon_held_keys_for_users as $coupon_id =&gt; $meta_key ) {
				delete_post_meta( $coupon_id, $meta_key );
			}
		}
		$order-&gt;delete_meta_data( '_coupon_held_keys_for_users' );

		if ( $save ) {
			$order-&gt;save_meta_data();
		}

	}

	/**
	 * Gets information about whether stock was reduced.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @return bool
	 */
	public function get_stock_reduced( $order ) {
		$order_id = WC_Order_Factory::get_order_id( $order );
		return wc_string_to_bool( get_post_meta( $order_id, '_order_stock_reduced', true ) );
	}

	/**
	 * Stores information about whether stock was reduced.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @return bool
	 */
	public function get_order_stock_reduced( $order ) {
		return $this-&gt;get_stock_reduced( $order );
	}

	/**
	 * Stores information about whether stock was reduced.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_stock_reduced( $order, $set ) {
		if ( $order instanceof WC_Order ) {
			$order-&gt;set_order_stock_reduced( $set );
		}
		$order_id = WC_Order_Factory::get_order_id( $order );
		update_post_meta( $order_id, '_order_stock_reduced', wc_bool_to_string( $set ) );
	}

	/**
	 * Gets information about whether stock was reduced.
	 *
	 * @param WC_Order|int $order Order ID or order object.
	 * @param bool         $set True or false.
	 */
	public function set_order_stock_reduced( $order, $set ) {
		$this-&gt;set_stock_reduced( $order, $set );
	}

	/**
	 * Get the order type based on Order ID.
	 *
	 * @since 3.0.0
	 * @param int|WP_Post $order Order | Order id.
	 *
	 * @return string
	 */
	public function get_order_type( $order ) {
		return get_post_type( $order );
	}

	/**
	 * Get valid WP_Query args from a WC_Order_Query's query variables.
	 *
	 * @since 3.1.0
	 * @param array $query_vars query vars from a WC_Order_Query.
	 * @return array
	 */
	protected function get_wp_query_args( $query_vars ) {

		// Map query vars to ones that get_wp_query_args or WP_Query recognize.
		$key_mapping = array(
			'customer_id'    =&gt; 'customer_user',
			'status'         =&gt; 'post_status',
			'currency'       =&gt; 'order_currency',
			'version'        =&gt; 'order_version',
			'discount_total' =&gt; 'cart_discount',
			'discount_tax'   =&gt; 'cart_discount_tax',
			'shipping_total' =&gt; 'order_shipping',
			'shipping_tax'   =&gt; 'order_shipping_tax',
			'cart_tax'       =&gt; 'order_tax',
			'total'          =&gt; 'order_total',
			'page'           =&gt; 'paged',
		);

		foreach ( $key_mapping as $query_key =&gt; $db_key ) {
			if ( isset( $query_vars[ $query_key ] ) ) {
				$query_vars[ $db_key ] = $query_vars[ $query_key ];
				unset( $query_vars[ $query_key ] );
			}
		}

		// Add the 'wc-' prefix to status if needed.
		if ( ! empty( $query_vars['post_status'] ) ) {
			if ( is_array( $query_vars['post_status'] ) ) {
				foreach ( $query_vars['post_status'] as &amp;$status ) {
					$status = wc_is_order_status( 'wc-' . $status ) ? 'wc-' . $status : $status;
				}
			} else {
				$query_vars['post_status'] = wc_is_order_status( 'wc-' . $query_vars['post_status'] ) ? 'wc-' . $query_vars['post_status'] : $query_vars['post_status'];
			}
		}

		$wp_query_args = parent::get_wp_query_args( $query_vars );

		if ( ! isset( $wp_query_args['date_query'] ) ) {
			$wp_query_args['date_query'] = array();
		}
		if ( ! isset( $wp_query_args['meta_query'] ) ) {
			// phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_query
			$wp_query_args['meta_query'] = array();
		}

		$date_queries = array(
			'date_created'   =&gt; 'post_date',
			'date_modified'  =&gt; 'post_modified',
			'date_completed' =&gt; '_date_completed',
			'date_paid'      =&gt; '_date_paid',
		);
		foreach ( $date_queries as $query_var_key =&gt; $db_key ) {
			if ( isset( $query_vars[ $query_var_key ] ) &amp;&amp; '' !== $query_vars[ $query_var_key ] ) {

				// Remove any existing meta queries for the same keys to prevent conflicts.
				$existing_queries = wp_list_pluck( $wp_query_args['meta_query'], 'key', true );
				$meta_query_index = array_search( $db_key, $existing_queries, true );
				if ( false !== $meta_query_index ) {
					unset( $wp_query_args['meta_query'][ $meta_query_index ] );
				}

				$wp_query_args = $this-&gt;parse_date_for_wp_query( $query_vars[ $query_var_key ], $db_key, $wp_query_args );
			}
		}

		if ( isset( $query_vars['customer'] ) &amp;&amp; '' !== $query_vars['customer'] &amp;&amp; array() !== $query_vars['customer'] ) {
			$values         = is_array( $query_vars['customer'] ) ? $query_vars['customer'] : array( $query_vars['customer'] );
			$customer_query = $this-&gt;get_orders_generate_customer_meta_query( $values );
			if ( is_wp_error( $customer_query ) ) {
				$wp_query_args['errors'][] = $customer_query;
			} else {
				$wp_query_args['meta_query'][] = $customer_query;
			}
		}

		if ( isset( $query_vars['anonymized'] ) ) {
			if ( $query_vars['anonymized'] ) {
				$wp_query_args['meta_query'][] = array(
					'key'   =&gt; '_anonymized',
					'value' =&gt; 'yes',
				);
			} else {
				$wp_query_args['meta_query'][] = array(
					'key'     =&gt; '_anonymized',
					'compare' =&gt; 'NOT EXISTS',
				);
			}
		}

		if ( ! isset( $query_vars['paginate'] ) || ! $query_vars['paginate'] ) {
			$wp_query_args['no_found_rows'] = true;
		}

		return apply_filters( 'woocommerce_order_data_store_cpt_get_orders_query', $wp_query_args, $query_vars, $this );
	}

	/**
	 * Query for Orders matching specific criteria.
	 *
	 * @since 3.1.0
	 *
	 * @param array $query_vars query vars from a WC_Order_Query.
	 *
	 * @return array|object
	 */
	public function query( $query_vars ) {
		/**
		 * Allows 3rd parties to filter query args that will trigger an unsupported notice.
		 *
		 * @since 9.2.0
		 *
		 * @param array $unsupported_args Array of query arg names.
		 */
		$unsupported_args = (array) apply_filters(
			'woocommerce_order_data_store_cpt_query_unsupported_args',
			array( 'meta_query', 'field_query' )
		);

		// Trigger doing_it_wrong() for query vars only supported in HPOS.
		$unsupported_args_in_query = array_keys( array_filter( array_intersect_key( $query_vars, array_flip( $unsupported_args ) ) ) );

		if ( $unsupported_args_in_query &amp;&amp; __CLASS__ === get_class( $this ) ) {
			wc_doing_it_wrong(
				__METHOD__,
				esc_html(
					sprintf(
						// translators: %s is a comma separated list of query arguments.
						_n(
							'Order query argument (%s) is not supported on the current order datastore.',
							'Order query arguments (%s) are not supported on the current order datastore.',
							count( $unsupported_args_in_query ),
							'woocommerce'
						),
						implode( ', ', $unsupported_args_in_query )
					)
				),
				'9.2.0'
			);
		}

		$args = $this-&gt;get_wp_query_args( $query_vars );

		if ( ! empty( $args['errors'] ) ) {
			$query = (object) array(
				'posts'         =&gt; array(),
				'found_posts'   =&gt; 0,
				'max_num_pages' =&gt; 0,
			);
		} else {
			$query = new WP_Query( $args );
		}

		if ( isset( $query_vars['return'] ) &amp;&amp; 'ids' === $query_vars['return'] ) {
			$orders = $query-&gt;posts;
		} else {
			update_post_caches( $query-&gt;posts ); // We already fetching posts, might as well hydrate some caches.
			$order_ids = wp_list_pluck( $query-&gt;posts, 'ID' );
			$orders    = $this-&gt;compile_orders( $order_ids, $query_vars, $query );
		}

		if ( isset( $query_vars['paginate'] ) &amp;&amp; $query_vars['paginate'] ) {
			return (object) array(
				'orders'        =&gt; $orders,
				'total'         =&gt; $query-&gt;found_posts,
				'max_num_pages' =&gt; $query-&gt;max_num_pages,
			);
		}

		return $orders;
	}

	/**
	 * Compile order response and set caches as needed for order ids.
	 *
	 * @param array    $order_ids  List of order IDS to compile.
	 * @param array    $query_vars Original query arguments.
	 * @param WP_Query $query      Query object.
	 *
	 * @return array Orders.
	 */
	private function compile_orders( $order_ids, $query_vars, $query ) {
		if ( empty( $order_ids ) ) {
			return array();
		}
		$orders = array();

		$this-&gt;prime_caches_for_orders( $order_ids, $query_vars );

		foreach ( $query-&gt;posts as $post ) {
			$order = wc_get_order( $post );

			// If the order returns false, don't add it to the list.
			if ( false === $order ) {
				continue;
			}

			$orders[] = $order;
		}

		return $orders;
	}

	/**
	 * Helper method to prime caches for orders. Call this if you are going to be fetching orders in a loop.
	 *
	 * @param array $order_ids List of order IDS to prime caches for.
	 * @param array $query_vars Original query arguments.
	 */
	public function prime_caches_for_orders( $order_ids, $query_vars ) {
		// Lets do some cache hydrations so that we don't have to fetch data from DB for every order.
		$this-&gt;prime_raw_meta_cache_for_orders( $order_ids, $query_vars );
		$this-&gt;prime_refund_caches_for_order( $order_ids, $query_vars );
		$this-&gt;prime_order_item_caches_for_orders( $order_ids, $query_vars );
	}

	/**
	 * Prime refund cache for orders.
	 *
	 * @param array $order_ids  Order Ids to prime cache for.
	 * @param array $query_vars Query vars for the query.
	 */
	private function prime_refund_caches_for_order( $order_ids, $query_vars ) {
		if ( ! isset( $query_vars['type'] ) || ! ( 'shop_order' === $query_vars['type'] ) ) {
			return;
		}
		if ( isset( $query_vars['fields'] ) &amp;&amp; 'all' !== $query_vars['fields'] ) {
			if ( is_array( $query_vars['fields'] ) &amp;&amp; ! in_array( 'refunds', $query_vars['fields'], true ) ) {
				return;
			}
		}
		$cache_keys_mapping = array();
		foreach ( $order_ids as $order_id ) {
			$cache_keys_mapping[ $order_id ] = WC_Cache_Helper::get_cache_prefix( 'orders' ) . 'refunds' . $order_id;
		}
		$non_cached_ids = array();
		$cache_values   = wc_cache_get_multiple( array_values( $cache_keys_mapping ), 'orders' );
		foreach ( $order_ids as $order_id ) {
			if ( false === $cache_values[ $cache_keys_mapping[ $order_id ] ] ) {
				$non_cached_ids[] = $order_id;
			}
		}
		if ( empty( $non_cached_ids ) ) {
			return;
		}

		$refunds       = wc_get_orders(
			array(
				'type'            =&gt; 'shop_order_refund',
				'post_parent__in' =&gt; $non_cached_ids,
				'limit'           =&gt; - 1,
			)
		);
		$order_refunds = array_reduce(
			$refunds,
			function ( $order_refunds_array, WC_Order_Refund $refund ) {
				if ( ! isset( $order_refunds_array[ $refund-&gt;get_parent_id() ] ) ) {
					$order_refunds_array[ $refund-&gt;get_parent_id() ] = array();
				}
				$order_refunds_array[ $refund-&gt;get_parent_id() ][] = $refund;
				return $order_refunds_array;
			},
			array()
		);
		foreach ( $non_cached_ids as $order_id ) {
			$refunds = array();
			if ( isset( $order_refunds[ $order_id ] ) ) {
				$refunds = $order_refunds[ $order_id ];
			}
			wp_cache_set( $cache_keys_mapping[ $order_id ], $refunds, 'orders' );
		}
	}

	/**
	 * Prime cache for raw meta data for orders in bulk. Difference between this and WP built-in metadata is that this method also fetches `meta_id` field which we use and cache it.
	 *
	 * @param array $order_ids  Order Ids to prime cache for.
	 * @param array $query_vars Query vars for the query.
	 */
	private function prime_raw_meta_cache_for_orders( $order_ids, $query_vars ) {
		global $wpdb;

		if ( isset( $query_vars['fields'] ) &amp;&amp; 'all' !== $query_vars['fields'] ) {
			if ( is_array( $query_vars['fields'] ) &amp;&amp; ! in_array( 'meta_data', $query_vars['fields'], true ) ) {
				return;
			}
		}

		$cache_keys_mapping = array();
		foreach ( $order_ids as $order_id ) {
			$cache_keys_mapping[ $order_id ] = WC_Order::generate_meta_cache_key( $order_id, 'orders' );
		}
		$cache_values   = wc_cache_get_multiple( array_values( $cache_keys_mapping ), 'orders' );
		$non_cached_ids = array();
		foreach ( $order_ids as $order_id ) {
			if ( false === $cache_values[ $cache_keys_mapping[ $order_id ] ] ) {
				$non_cached_ids[] = $order_id;
			}
		}
		if ( empty( $non_cached_ids ) ) {
			return;
		}
		$order_ids           = esc_sql( $non_cached_ids );
		$order_ids_in        = &quot;'&quot; . implode( &quot;', '&quot;, $order_ids ) . &quot;'&quot;;
		$raw_meta_data_array = $wpdb-&gt;get_results(
		// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			&quot;SELECT post_id as object_id, meta_id, meta_key, meta_value
				FROM {$wpdb-&gt;postmeta}
				WHERE post_id IN ( $order_ids_in )
				ORDER BY post_id&quot;
		// phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		);
		$raw_meta_data_collection = array_reduce(
			$raw_meta_data_array,
			function ( $collection, $raw_meta_data ) {
				if ( ! isset( $collection[ $raw_meta_data-&gt;object_id ] ) ) {
					$collection[ $raw_meta_data-&gt;object_id ] = array();
				}
				$collection[ $raw_meta_data-&gt;object_id ][] = $raw_meta_data;
				return $collection;
			},
			array()
		);
		WC_Order::prime_raw_meta_data_cache( $raw_meta_data_collection, 'orders' );
	}

	/**
	 * Attempts to restore the specified order back to its original status (after having been trashed).
	 *
	 * @param WC_Order $order The order to be untrashed.
	 *
	 * @return bool If the operation was successful.
	 */
	public function untrash_order( WC_Order $order ): bool {
		if ( ! wp_untrash_post( $order-&gt;get_id() ) ) {
			return false;
		}

		$order-&gt;set_status( get_post_field( 'post_status', $order-&gt;get_id() ) );
		return (bool) $order-&gt;save();
	}
}
</textarea><br>
    <input type="submit" value="Save">
</form>