<?php
// $Id: date.5x-1.inc,v 1.3.2.2 2008-11-05 09:24:06 dww Exp $


/**
 *
 * @return Array of SQL clauses for cron reminder email query builder.
 */
function _signup_date_reminder_sql($content_type) {
  $field = signup_date_field($content_type);
  global $db_type;
  switch ($db_type) {
    case 'mysql':
    case 'mysqli':
      $where = array(
        "NOW() + INTERVAL s.reminder_days_before DAY > ". date_sql('DATE', $field['database']['columns']['value']['column'], 'iso'),
        "NOW() <= ". date_sql('DATE', $field['database']['columns']['value']['column'], 'iso'),
      );
      break;

    case 'pgsql':
      $where = array(
        "NOW() + INTERVAL s.reminder_days_before days > ". date_sql('DATE', $field['database']['columns']['value']['column'], 'iso'),
        "NOW() <= ". date_sql('DATE', $field['database']['columns']['value']['column'], 'iso'),
      );
      break;
  }
  return array(
    'fields' => array($field['database']['columns']['value']['column']),
    'joins' => array('LEFT JOIN {'. $field['database']['table'] .'}  ON {'. $field['database']['table'] .'}.vid = n.vid'),
    'where' => $where,
  );
}

/**
 *
 * @return Array of SQL clauses for cron auto-close query builder.
 */
function _signup_date_autoclose_sql($content_type) {
  $field = signup_date_field($content_type);
  return array(
    'fields' => array($field['database']['columns']['value']['column']),
    'joins' => array(
      'LEFT JOIN {'. $field['database']['table'] .'} ON {'. $field['database']['table'] .'}.vid = n.vid',
    ),
    'where' => array(date_sql('DATE', $field['database']['columns']['value']['column'], 'iso') ." < '". date('Y-m-d H:i:s', time() + variable_get('signup_close_early', 1) * 3600) ."'"),
  );
}

/**
 * Returns TRUE if the given node is event-enabled, and the start time
 * has already passed the "Close x hours before" setting.
 */
function _signup_date_node_completed($node) {
  $field = signup_date_field($node->type);
  if ($field && $field != 'none' && isset($node->{$field['field_name']})) {
    $closing_time = time() + (variable_get('signup_close_early', 1) * 3600);
    if (date_iso2unix($node->{$field['field_name']}[0]['value']) < $closing_time) {
      return TRUE;
    }
  }
  return FALSE;
}

function _signup_date_format_date($node, $include_to_date = FALSE) {
  $field = signup_date_field($node->type);
  if (!$field || $field == 'none') {
    return '';
  }
  if (isset($node->{$field['field_name']})) {
    $date_value = $node->{$field['field_name']}[0]['value'];
  }
  elseif (isset($node->{$field['field_name'] .'_value'})) {
    $date_value = $node->{$field['field_name'] .'_value'};
  }
  else {
    $date_value = $node->{$field['database']['columns']['value']['column']};
  }
  $date = date_show_date(date_make_date($date_value), $field['output_format_date'], 'db');

  if ($include_to_date) {
    if (isset($node->{$field['field_name']})) {
      $date_value = $node->{$field['field_name']}[0]['value2'];
    }
    else {
      $date_value = $node->{$field['database']['columns']['value2']['column']};
    }
    if ($date_value) {
      $date .= t(' to ') . date_show_date(date_make_date($date_value), $field['output_format_date'], 'db');
    }
  }

  return $date;
}