Club Drupal

<?php

/**

 * @file

 * Update scripts for the Date All Day module.

 */

/**

 * Change old "all day" values.

 *

 * Old data was stored with values with the time set to "00:00:00" whereas new

 * data is stored with the time set to "23:59:59" (the minutes value varies

 * depending upon the field's "increment" value), while keeping the same date.

 *

 * @todo Run this through a sandbox.

 */

function date_all_day_update_7200() {

  // Get all fields provided by the Data module. This is used instead of the

  // usual field_read_fields() because we want to select three different field

  // types, whereas the API only supports one at a time.

  $field_names = db_select('field_config', 'f')

    ->fields('f', array('field_name'))

    ->condition('f.type', array('datetime', 'date', 'datestamp'), 'IN')

    ->execute()

    ->fetchCol();

  // Keep track of the fields that were processed.

  $fields_processed = array();

  // Loop over each of the fields that was found.

  foreach ($field_names as $field_name) {

    // Get the full specs of this base field.

    $field = field_read_field($field_name);

    // Loop over each instance of this field.

    $params = array(

      'field_name' => $field_name,

    );

    foreach (field_read_instances($params) as $instance) {

      if (!empty($instance['widget']['settings']['display_all_day'])) {

        $fields_processed[] = $field_name;

        // If this field has a "to" date, the column to change is the "value2"

        // column, otherwise just change the primary column.

        if (!empty($field['settings']['todate'])) {

          $field_to_change = $field_name . '_value2';

        }

        else {

          $field_to_change = $field_name . '_value';

        }

        // Manually fix each record.

        $records = db_select('field_data_' . $field_name, 'f')

          ->fields('f')

          ->condition('f.entity_type', $instance['entity_type'])

          ->condition('f.bundle', $instance['bundle'])

          ->condition('f.' . $field_to_change, '%:00:00', 'LIKE')

          ->execute();

        // The value that the widget is set to increment by. This is stored in

        // minutes.

        $increment = 1;

        if (isset($instance['widget']['settings']['increment'])) {

          $increment = $instance['widget']['settings']['increment'];

        }

        foreach ($records as $record) {

          // Extract the value and convert it to a timestamp.

          $end_date_value = $record->{$field_to_change};

          $date = strtotime($end_date_value);

          // The old time was stored with the value of midnight the day before

          // the date that was intended, e.g. if the date was 2020-10-17 the

          // time was stored as 0:00:00 thus the saved value "2020-10-17

          // 00:00:00". This needs to be converted to 1 second before midnight

          // on *that* day, i.e. "2020-10-17 23:59:59".

          // @see hook_date_combo_validate_date_end_alter()

          // @see date_all_day_date_combo_validate_date_start_alter()

          $date += 23 * 60 * 60; // 23 hours.

          $date += (60 - $increment) * 60; // 60 minutes - $increment, e.g. 59.

          $date += 59; // 59 seconds.

          // Reformat the date using an appropriate format for storing in the

          // database.

          $date = date(DATE_FORMAT_DATETIME, $date);

          // Update the record.

          db_update('field_data_' . $field_name)

            ->fields(array(

              $field_to_change => $date,

            ))

            ->condition('entity_type', $record->entity_type)

            ->condition('bundle', $record->bundle)

            ->condition('deleted', $record->deleted)

            ->condition('revision_id', $record->revision_id)

            ->condition('language', $record->language)

            ->condition('delta', $record->delta)

            ->execute();

          // Clear the caches for this entity.

          entity_get_controller($record->entity_type)->resetCache(array($record->entity_id));

        }

      }

    }

  }

  // If any data was converted clear the site's caches.

  if ($fields_processed) {

    drupal_flush_all_caches();

  }

  return t('Processed %fields.', array('%fields' => implode(', ', $fields_processed)));

}