Automattic\WooCommerce\Admin\API\Reports\Customers

DataStore::update_registered_customer │ public static │ WC 1.0

Update the database with customer data.

Method of the class: DataStore{}

Returns

Int|true|false|null. Number or rows modified or false on failure.

Usage

$result = DataStore::update_registered_customer( $user_id );

$user_id(int) (required)

WP User ID to update customer data for.

DataStore::update_registered_customer() DataStore::update registered customer code ^{WC 10.6.2}

public static function update_registered_customer( $user_id ) {
	global $wpdb;

	$customer = new \WC_Customer( $user_id );

	if ( ! self::is_valid_customer( $user_id ) ) {
		return false;
	}

	$first_name = $customer->get_first_name();
	$last_name  = $customer->get_last_name();

	if ( empty( $first_name ) ) {
		$first_name = $customer->get_billing_first_name();
	}
	if ( empty( $last_name ) ) {
		$last_name = $customer->get_billing_last_name();
	}

	$last_active = $customer->get_meta( 'wc_last_active', true, 'edit' );
	$data        = array(
		'user_id'          => $user_id,
		'username'         => $customer->get_username( 'edit' ),
		'first_name'       => $first_name,
		'last_name'        => $last_name,
		'email'            => $customer->get_email( 'edit' ),
		'city'             => $customer->get_billing_city( 'edit' ),
		'state'            => $customer->get_billing_state( 'edit' ),
		'postcode'         => $customer->get_billing_postcode( 'edit' ),
		'country'          => $customer->get_billing_country( 'edit' ),
		'date_registered'  => $customer->get_date_created( 'edit' ) ? $customer->get_date_created( 'edit' )->date( TimeInterval::$sql_datetime_format ) : null,
		'date_last_active' => $last_active ? gmdate( 'Y-m-d H:i:s', $last_active ) : null,
	);
	$format      = array(
		'%d',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
		'%s',
	);

	$customer_id = self::get_customer_id_by_user_id( $user_id );

	if ( $customer_id ) {
		// Preserve customer_id for existing user_id.
		$data['customer_id'] = $customer_id;
		$format[]            = '%d';
	}

	$results = $wpdb->replace( self::get_db_table_name(), $data, $format );

	/**
	 * Fires when customser's reports are updated.
	 *
	 * @param int $customer_id Customer ID.
	 * @since 4.0.0
	 */
	do_action( 'woocommerce_analytics_update_customer', $customer_id );

	ReportsCache::invalidate();

	return $results;
}