Groups: store registration questions in GatherPress's form schema meta - #2234

<?php
/**
 * One-off: move Groups registration questions and answers from the legacy
 * `wporg_groups_rsvp_questions` / `wporg_groups_rsvp_answers` meta onto
 * GatherPress's `gatherpress_rsvp_form_schemas` / `gatherpress_custom_*`.
 *
 * Usage: wp eval-file migrate-rsvp-questions.php [dry-run]
 *
 * Walks every site on the network. Safe to re-run: legacy meta is deleted once
 * moved, and anything already stored under the new keys is never overwritten.
 */

$dry_run = in_array( 'dry-run', $args ?? array(), true );
$totals  = array( 'events' => 0, 'answers' => 0 );

foreach ( get_sites( array( 'number' => 0, 'fields' => 'ids' ) ) as $site_id ) {
	switch_to_blog( $site_id );
	global $wpdb;

	$events = $wpdb->get_col( "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = 'wporg_groups_rsvp_questions'" );
	$rsvps  = $wpdb->get_col( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key = 'wporg_groups_rsvp_answers'" );

	if ( ! $events && ! $rsvps ) {
		restore_current_blog();
		continue;
	}

	foreach ( $events as $event_id ) {
		$event_id  = (int) $event_id;
		$questions = get_post_meta( $event_id, 'wporg_groups_rsvp_questions', true );
		$schemas   = get_post_meta( $event_id, 'gatherpress_rsvp_form_schemas', true );
		$schemas   = is_array( $schemas ) ? $schemas : array();

		if ( ! $dry_run ) {
			if ( is_array( $questions ) && $questions && ! isset( $schemas['wporg_groups'] ) ) {
				$fields = array();

				foreach ( $questions as $question ) {
					$fields[ $question['id'] ] = array(
						'name'        => $question['id'],
						'type'        => 'text',
						'required'    => (bool) $question['required'],
						'label'       => $question['label'],
						'placeholder' => '',
					);
				}

				$schemas['wporg_groups'] = array(
					'fields' => $fields,
					'hash'   => wp_hash( (string) wp_json_encode( $fields ) ),
				);

				update_post_meta( $event_id, 'gatherpress_rsvp_form_schemas', $schemas );
			}

			delete_post_meta( $event_id, 'wporg_groups_rsvp_questions' );
		}

		++$totals['events'];
	}

	foreach ( $rsvps as $comment_id ) {
		$comment_id = (int) $comment_id;
		$answers    = get_comment_meta( $comment_id, 'wporg_groups_rsvp_answers', true );

		if ( ! $dry_run ) {
			foreach ( is_array( $answers ) ? $answers : array() as $id => $answer ) {
				$key = 'gatherpress_custom_' . $id;

				if ( '' === get_comment_meta( $comment_id, $key, true ) ) {
					update_comment_meta( $comment_id, $key, $answer );
				}
			}

			delete_comment_meta( $comment_id, 'wporg_groups_rsvp_answers' );
		}

		++$totals['answers'];
	}

	WP_CLI::log( sprintf( '%s: %d events, %d RSVPs with answers', home_url( '/' ), count( $events ), count( $rsvps ) ) );
	restore_current_blog();
}

WP_CLI::success( sprintf( '%s%d events, %d RSVPs with answers.', $dry_run ? '[dry run] ' : '', $totals['events'], $totals['answers'] ) );