Geocode providers.

geocode-providers.php

<?php

define( 'WP_USE_THEMES', false );

require './wp-blog-header.php';

$query = new WP_Query(
	array(
		'post_type' => 'provider',
		'nopaging'  => true,
	)
);

$number = 0;

if ( $query->have_posts() ) {
	while ( $query->have_posts() ) {
		$query->the_post();

		$post_id = get_the_ID();

		$address = get_post_meta( $post_id, '_pronamic_google_maps_address', true );

		echo $post_id, ' - ', get_the_title(), ' - ', $address, '<br />';

		if ( empty( $address ) ) {
			$street      = get_post_meta( $post_id, 'coopdichtbij_provider_address', true );
			$postal_code = get_post_meta( $post_id, 'coopdichtbij_provider_postal_code', true );
			$city        = get_post_meta( $post_id, 'coopdichtbij_provider_city', true );

			$address .= $street . "\r\n";
			$address .= $postal_code . ' ' . $city;

			$address = trim( $address );

			echo 'Address: ', $address, '<br />';

			if ( ! empty( $address ) ) {
				update_post_meta( $post_id, '_pronamic_google_maps_address', $address );

				$number++;
			}
		}

		$active         = get_post_meta( $post_id, '_pronamic_google_maps_active', true );
		$geocode_status = get_post_meta( $post_id, '_pronamic_google_maps_geocode_status', true );

		if ( empty( $active ) && 'OK' === $geocode_status ) {
			update_post_meta( $post_id, '_pronamic_google_maps_active', 'true' );
		}
	}
}

echo '<br />';

echo 'Number: ', $number;