By steve.neill on

I'm fairly new to using Drupal so please forgive me if this is something simple I'm just not getting.

I've installed the Scheduler and Calendar modules. I'm now trying to create a calendar month view that shows content waiting to be published.

The problem is the scheduler 'publish_on' and 'publish_off' date fields are nowhere to be seen in the "Date Field(s)" section. I'm using these fields to show the node title on the date when the content either goes live or expires.

I would have thought Drupal can do this basic type of stuff -- please don't disappoint me! I've looked at creating relationships between tables etc, but to no avail.

Do I need to write hook code to get around this issue? If so, does anyone have any suggestions (examples to base it off?)

Thanks,

Steve

⋅ Categories: Drupal 6.x

Comments

steve.neill’s picture

steve.neill commented

Finally figured it out.

Here's the solution - hopefully someone else may find it useful...

In scheduler.module, add the following function:

function scheduler_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 'scheduler.publish_on':
    case 'scheduler.unpublish_on':
      return $values;
  }
}
vm’s picture

vm commented

This might be a nice addition to the scheduler module itself. Please consider creating a patch file and uploading it to an issue over in the issue queue for scheduler.