t('Link this field to queue arrange page'), '#type' => 'checkbox', '#default_value' => !empty($this->options['link_to_taxonomy']), ); $form['limit'] = array( '#type' => 'checkbox', '#title' => t('Limit to queues'), '#default_value' => $this->options['limit'], ); $options = array(); $queues = nodequeue_load_queues(nodequeue_get_all_qids()); foreach ($queues as $queue) { $options[$queue->qid] = $queue->title; } $form['qids'] = array( '#prefix' => '

', '#suffix' => '

', '#type' => 'checkboxes', '#title' => t('Queues'), '#options' => $options, '#default_value' => $this->options['qids'], '#states' => array( 'visible' => array( ':input[name="options[limit]"]' => array('checked' => TRUE) ), ), ); } function pre_render($values) { $nids = array(); foreach ($values as $result) { $nids[] = $result->{$this->field_alias}; } if ($nids) { $queue = ''; if (!empty($this->options['limit']) && !empty($this->options['qids'])) { $queue = " AND nn.qid IN (" . implode(', ', array_keys(array_filter($this->options['qids']))) . ")"; } $result = db_query("SELECT nn.nid, nn.qid, nq.title FROM {nodequeue_nodes} nn INNER JOIN {nodequeue_queue} nq ON nq.qid = nn.qid WHERE nn.nid IN (" . implode(', ', $nids) . ")$queue ORDER BY nq.title"); foreach ($result as $queue) { if (empty($this->options['link_to_queue'])) { $this->items[$queue->nid][$queue->qid] = check_plain($queue->title); } else { $this->items[$queue->nid][$queue->qid] = l($queue->title, "admin/structure/nodequeue/$queue->qid"); } } } } }