function _signup_event_admin_sql in Signup 7

Same name and namespace in other branches

1. 5.2 includes/event.5x-1.inc \_signup_event_admin_sql()
2. 5.2 includes/event.5x-2.inc \_signup_event_admin_sql()
3. 6.2 includes/event.6x-2.inc \_signup_event_admin_sql()
4. 6 includes/event.6x-2.inc \_signup_event_admin_sql()

Return value

Array of SQL clauses for admin overview page query builder.

File

includes/event.6x-2.inc, line 49

Code

function _signup_event_admin_sql($content_type = NULL) {

  // Since all event node types store their event data in the same table, we
  // need to make sure we only JOIN on this table once.  It doesn't matter
  // which node type we use to add this JOIN.
  static $did_event_join = FALSE;
  if ($did_event_join) {
    return array();
  }
  $did_event_join = TRUE;
  return array(
    'fields' => array(
      event_select(),
      'e.timezone',
    ),
    'group_by' => array(
      'event_start',
      'e.timezone',
    ),
    'joins' => array(
      event_join('n', 'LEFT'),
    ),
  );
}