<?php

/**
 * @file
 * Install, update and uninstall functions for the date_api module.
 */

/**
 * Helper function for setting Date variables.
 */
function date_api_set_variables() {
  // Set absolute minimum and maximum year for dates on this site.
  // There is actually no maximum and minimum year in PHP 5, but a date with
  // a year less than 0 would result in negative ISO and DATETIME dates,
  // like -1250-01-01T00:00:00, which probably won't make sense or work
  // correctly anywhere.
  // The odd construct of using variable_get() instead of variable_set()
  // is so we don't accidentally write over an existing value. If
  // no value is set, variable_get() will set it.
  variable_get('date_max_year', 4000);
  variable_get('date_min_year', 1);
  variable_get('date_php_min_year', 1901);

  // Set an API version in a way that other modules can test for compatibility.
  variable_set('date_api_version', '7.2');
}

/**
 * Implements hook_requirements().
 */
function date_api_requirements($phase) {
  $requirements = array();

  if ($phase == 'runtime') {
    $t = get_t();
    module_load_include('module', 'date_api');
    $messages = date_api_status();
    $error_messages = !empty($messages['errors']) ? $messages['errors'] : array();
    $success_messages = !empty($messages['success']) ? $messages['success'] : array();

    if (!empty($error_messages)) {
      $requirements['date'] = array(
        'title' => $t('Date API'),
        'value' => $t('Missing system date settings'),
        'description' => implode(' ', array_merge($error_messages, $success_messages)),
        'severity' => REQUIREMENT_ERROR,
      );
    }
    else {
      $requirements['date'] = array(
        'title' => $t('Date API'),
        'value' => $t('System date settings'),
        'description' => implode(' ', $success_messages),
      );
    }
  }
  return $requirements;
}

/**
 * Implements hook_install().
 */
function date_api_install() {
  // Only set the message if Drupal itself is already installed.
  if (variable_get('install_task') == 'done') {
    // Ensure translations don't break at install time.
    $t = get_t();

    // date_api_set_variables can install date_timezone. The
    // date_timezone_install() function does a module_enable('date_api'). This
    // means that date_api_enable() can be called before date_api_install()
    // finishes! So the date_api schema needs to be installed before this line!
    date_api_set_variables();

    $message = $t('The Date API requires that you set up the <a href="@regional_settings">site timezone and first day of week settings</a> and the <a href="@regional_date_time">date format settings</a> to function correctly.', array('@regional_settings' => url('admin/config/regional/settings'), '@regional_date_time' => url('admin/config/regional/date-time')));
    drupal_set_message(filter_xss_admin($message), 'warning');
  }
}

/**
 * Implements hook_enable().
 */
function date_api_enable() {
  date_api_set_variables();
}

/**
 * Implements hook_uninstall().
 */
function date_api_uninstall() {
  cache_clear_all('date_timezone_identifiers_list', 'cache');
  $variables = array(
    'date_api_version',
    'date_min_year',
    'date_max_year',
    'date_php_min_year',
    'date_db_tz_support',
    'date_api_use_iso8601',
    );
  foreach ($variables as $variable) {
    variable_del($variable);
  }

  if (db_table_exists('views_display')) {
    $displays = array(
      'date_nav',
    );
    db_query("DELETE FROM {views_display} WHERE display_plugin IN ('" . implode("','", $displays) . "')");
    db_query("DELETE FROM {cache_views}");
  }
}

/**
 * Implements hook_update_last_removed().
 */
function date_api_update_last_removed() {
  return 6005;
}

/**
 * Move old date format data to new date format tables, and delete the old
 * tables. Insert only values that don't already exist in the new tables, in
 * case new version of those custom values have already been created.
 */
function date_api_update_7000() {
  // Move format data from the old 'date_format_types' table to the new
  // 'date_format_type' table.
  if (db_table_exists('date_format_types')) {
    // Find all the custom entries in the D6 table.
    $result = db_select('date_format_types', 'old')
      ->fields('old', array('type', 'title', 'locked'))
      ->condition('locked', 0)
      ->execute()
      ->fetchAll(PDO::FETCH_ASSOC);

    // Iterate over all the old values.
    foreach ($result as $row) {
      // See if this value already exists in the new table
      // (it might have been added manually before this update got run).
      $count = db_select('date_format_type', 'new')
        ->condition('type', $row['type'])
        ->countQuery()
        ->execute()
        ->fetchField();

      // If the value is missing, insert it.
      // Do nothing if it already exists, assume the value in the
      // new table trumps the old values.
      if (empty($count)) {
        db_insert('date_format_type')
          ->fields(array(
            'type' => $row['type'],
            'title' => $row['title'],
            'locked' => $row['locked'],
          ))
          ->execute();
      }
    }

    // Drop the old table.
    db_drop_table('date_format_types');

  }

  // Move format data from the old 'date_formats' table (which was renamed to
  // 'd6_date_formats') to the new 'date_formats' table.
  if (db_table_exists('d6_date_formats')) {
    // Find all the custom entries in the D6 table.
    $result = db_select('d6_date_formats', 'old')
      ->fields('old', array('format', 'type', 'locked'))
      ->condition('type', 'custom')
      ->execute()
      ->fetchAll(PDO::FETCH_ASSOC);

    // Iterate over all the old values.
    foreach ($result as $row) {
      // See if this value already exists in the new table (it might have been
      // added manually before this update got run).
      $count = db_select('date_formats', 'new')
        ->condition('format', $row['format'])
        ->condition('type', $row['type'])
        ->countQuery()
        ->execute()
        ->fetchField();

      // If the value is missing, insert it. Do nothing if it already exists,
      // assume the value in the new table trumps the old values.
      if (empty($count)) {
        db_insert('date_formats')
          ->fields(array(
            'format' => $row['format'],
            'type' => $row['type'],
            'locked' => $row['locked'],
          ))
          ->execute();
      }
    }

    // Drop the old table.
    db_drop_table('d6_date_formats');
  }

  // Move format data from the old 'date_format_locale' table (which was renamed
  // to 'd6_date_format_locale') to the new 'date_format_locale' table.
  if (db_table_exists('d6_date_format_locale')) {
    // Find all the custom entries in the D6 table.
    $result = db_select('d6_date_format_locale', 'old')
      ->fields('old', array('format', 'type', 'language'))
      ->condition('type', 'custom')
      ->execute()
      ->fetchAll(PDO::FETCH_ASSOC);

    // Iterate over all the old values.
    foreach ($result as $row) {
      // See if this value already exists in the new table (it might have been
      // added manually before this update got run).
      $count = db_select('date_format_locale', 'new')
        ->condition('format', $row['format'])
        ->condition('type', $row['type'])
        ->condition('language', $row['language'])
        ->countQuery()
        ->execute()
        ->fetchField();

      // If the value is missing, insert it.
      // Do nothing if it already exists, assume the value in the
      // new table trumps the old values.
      if (empty($count)) {
        db_insert('date_format_locale')
          ->fields(array(
            'format' => $row['format'],
            'type' => $row['type'],
            'language' => $row['language'],
          ))
          ->execute();
      }
    }

    // Drop the old table.
    db_drop_table('d6_date_format_locale');
  }
}


/**
 * Drop D6 timezone_name field on {users} after upgrading to D7.
 */
function date_api_update_7001() {
  if (db_field_exists('users', 'timezone_name')) {
    db_drop_field('users', 'timezone_name');
  }
}
