By sankatha on

Hi everyone,

I have developed a custom node type and it has a field named ticket_end_date which is actually a UNIX timestamp in the database. What I actually needed to do is use this as a date argument in the calendar view so I can have a calendar with the ticket_end_date displaying init. I have implemented hook_views_data() as described in VIEWS 2 documentation. Unfortunately when I try to add a Date argument in the calendar view I cannot see my custom field listed under the Date fields. Any solution or suggestion for this other than using a CCK field ? Can I make a custom node UNIX timestamp field aware to Drupal as a valid Calendar Date Argument ?

Cheers

⋅ Categories: Drupal 6.x

Comments

sankatha’s picture

sankatha commented

After Googling and waiting a whole day until 11PM in the office finally found the solution. Anyway will write it down here so may be it will be beneficial for somebody. Well actually all you have to do it implement the following two hooks in Date API

/**
 * Telling the date api to inlcude the node_marcomms_ticket to be
 * inluded in the date arguments
 */
 function <your module name>_date_api_tables() {
    return array('<your db table name>');
}

/**
 * Implementation of hook_date_api_fields().
 * on behalf of core fields.
 *
 * All modules that create custom fields that use the
 * 'views_handler_field_date' handler can provide
 * additional information here about the type of
 * date they create so the date can be used by
 * the Date API views date argument and date filter.
 */
function <your module name>_date_api_fields($field) {
  $values = array(
    // The type of date: DATE_UNIX, DATE_ISO, DATE_DATETIME.
    'sql_type' => DATE_UNIX,
    // Timezone handling options: 'none', 'site', 'date', 'utc'.
    'tz_handling' => 'site',
    // Needed only for dates that use 'date' tz_handling.
    'timezone_field' => '',
    // Needed only for dates that use 'date' tz_handling.
    'offset_field' => '',
    // Array of "table.field" values for related fields that should be
    // loaded automatically in the Views SQL.
    'related_fields' => array(),
    // Granularity of this date field's db data.
    'granularity' => array('year', 'month', 'day', 'hour', 'minute', 'second'),
  );

  switch ($field) {
    case '<db table name>.<db column name>':
    return $values;
  }
}

NOTE: I am using a UNIX time stamp to store the date fields

tmetzger’s picture

tmetzger commented

Wow this is very close to what I'm trying to solve - basically I need to get multi-day events displaying as such in the calendar, but right now the view is putting in the end date separately instead if I include it.

Do you have end-dates displaying correctly sankatha?

Tom