Automattic\WooCommerce\Admin\API\Reports\Orders\Stats

DataStore::add_fulfillment_status_column │ public static │ WC 1.0

Add fulfillment_status column to wc_order_stats table.

Method of the class: DataStore{}

No Hooks.

Returns

true|false|String. True on success, error message string on failure.

Usage

$result = DataStore::add_fulfillment_status_column();

DataStore::add_fulfillment_status_column() DataStore::add fulfillment status column code ^{WC 10.4.3}

public static function add_fulfillment_status_column() {
	if ( self::has_fulfillment_status_column() ) {
		return true;
	}

	global $wpdb;

	$result = $wpdb->query(
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		"ALTER TABLE {$wpdb->prefix}wc_order_stats
		ADD COLUMN fulfillment_status VARCHAR(50) DEFAULT NULL,
		ADD INDEX fulfillment_status (fulfillment_status)"
	);

	if ( false === $result ) {
		return $wpdb->last_error ? $wpdb->last_error : __( 'Unknown database error occurred while adding fulfillment_status column.', 'woocommerce' );
	}

	// Update the option to indicate that the column has been added.
	update_option( self::OPTION_ORDER_STATS_TABLE_HAS_COLUMN_ORDER_FULFILLMENT_STATUS, 'yes', false );

	return true;
}