Changeset 10244

Timestamp:

09/10/2020 12:21:24 AM (5 years ago)

Author:

iandunn

Message:

Official Events: Store WordCamp UTC offset.

This is needed for the Events Widget to display events in the user's timezone. We're already storing it for meetups, and it was recently added to the WordCamp.org API as well.

See ​https://github.com/WordPress/wordcamp.org/issues/567
See #4480
See ​#core51330

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/official-wordpress-events/official-wordpress-events.php (modified) (4 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/official-wordpress-events/official-wordpress-events.php

@@ -332 +332 @@
                 foreach ( $wordcamp as $field => $value ) {
                     switch ( $field ) {
+                        // This is the local time, not a true Unix timestamp.
                         case 'Start Date (YYYY-mm-dd)':
                             $value = absint( $value );
@@ -344 +345 @@
                             break;
 
+                        // This is the local time, not a true Unix timestamp.
                         case 'End Date (YYYY-mm-dd)':
                             $event['end_timestamp'] = absint( $value );
@@ -392 +394 @@
                 if ( $event['start_timestamp'] && empty( $event['end_timestamp'] ) ) {
                     $event['end_timestamp'] = $event['start_timestamp'];
+                }
+
+                if ( $wordcamp->{'Event Timezone'} && $event['start_timestamp'] ) {
+                    $wordcamp_timezone = new DateTimeZone( $wordcamp->{'Event Timezone'} );
+
+                    $wordcamp_datetime = new DateTime(
+                        '@' . $event['start_timestamp'],
+                        $wordcamp_timezone
+                    );
+
+                    $event['utc_offset'] = $wordcamp_timezone->getOffset( $wordcamp_datetime );
                 }
 
@@ -569 +582 @@
             }
 
+            /*
+             * Convert to local time, because the `date_utc` column in `wporg_events` is misnomed and actually
+             * expects the _local_ time.
+             */
             $start_timestamp = ( $meetup['time'] / 1000 ) + ( $meetup['utc_offset'] / 1000 ); // convert to seconds
             $latitude        = ! empty( $meetup['venue']['lat'] ) ? $meetup['venue']['lat'] : $meetup['group']['lat'];