'checkbox', '#title' => t('Limit to one or more queues (recommended)'), '#default_value'=> $this->options['limit'], ); $options = array(); $queues = nodequeue_load_queues(nodequeue_get_all_qids(NULL)); foreach ($queues as $queue) { $options[$queue->name] = $queue->title; } $form['names'] = array( '#prefix' => '

', '#suffix' => '

', '#type' => 'checkboxes', '#title' => t('Queues'), '#options' => $options, '#default_value' => $this->options['names'], '#process' => array('expand_checkboxes', 'views_process_dependency'), '#dependency' => array('edit-options-limit' => array(TRUE)), ); } /** * Called to implement a relationship in a query. */ function query() { // Figure out what base table this relationship brings to the party. $join = new views_join(); $join->definition = array( 'table' => 'nodequeue_nodes', 'field' => 'nid', 'left_table' => 'node', 'left_field' => 'nid', ); if (!empty($this->options['required'])) { $join->definition['type'] = 'INNER'; } if (!empty($this->options['limit'])) { $qids = array(); $map = nodequeue_get_qid_map(); foreach($map as $name => $qid) { if (isset($this->options['names'][$name]) ) { $qids[] = $qid; } } $join->definition['extra'] = array(array( 'field' => 'qid', 'value' => $qids, )); } $join->construct(); $alias = $join->definition['table'] . '_' . $join->definition['left_table']; $this->alias = $this->query->add_relationship($alias, $join, 'nodequeue_nodes', $this->relationship); } }