function auto_expire_views_tables in Auto Expire 5

File

./auto_expire.module, line 464

Code

function auto_expire_views_tables() {
  $tables['auto_expire'] = array(
    'name' => 'auto_expire',
    'join' => array(
      'left' => array(
        'table' => 'node',
        'field' => 'nid',
      ),
      'right' => array(
        'field' => 'nid',
      ),
    ),
    'fields' => array(
      'expire' => array(
        'name' => t('Auto Expire: Expiration Date'),
        'sortable' => TRUE,
        'handler' => views_handler_field_dates(),
        'help' => t('Date the node will expire'),
        'option' => 'integer',
      ),
      'warned' => array(
        'name' => t('Auto Expire: Warning Sent?'),
        'help' => t('Has the warning already been sent?'),
        'field' => 'warned',
        'option' => 'integer',
      ),
    ),
    'filters' => array(
      'expire' => array(
        'field' => 'expire',
        'name' => t('Auto Expire: Expiration Date'),
        'help' => t('Date the node will expire. This filter allows nodes to be filtered by their expiration date. The "Value" can either be a date in the format: CCYY-MM-DD HH:MM:SS or the word "now" to use the current time. You may enter a positive or negative number in the "Option" field that will represent the amount of seconds that will be added or substracted to the time; this is most useful when combined with "now". If you have the jscalendar module from jstools installed, you can use a popup date picker here.'),
        'operator' => 'views_handler_operator_gtlt',
        'value' => views_handler_filter_date_value_form(),
        'option' => 'string',
        'handler' => 'views_handler_filter_timestamp',
      ),
      'warned' => array(
        'name' => t('Auto Expire: Warning Sent?'),
        'help' => t('Has the warning already been sent?'),
        'field' => 'warned',
        'operator' => 'views_handler_operator_eqneq',
      ),
    ),
    'sorts' => array(
      'expire' => array(
        'name' => t('Auto Expire: Date'),
        'help' => t('Sort by date'),
        'handler' => 'views_handler_sort_date',
        'option' => views_handler_sort_date_options(),
      ),
    ),
  );
  return $tables;
}