function nodequeue_load_subqueues_by_queue in Nodequeue 6.2

Same name and namespace in other branches

1. 5.2 nodequeue.module \nodequeue_load_subqueues_by_queue()
2. 7.3 nodequeue.module \nodequeue_load_subqueues_by_queue()
3. 7.2 nodequeue.module \nodequeue_load_subqueues_by_queue()

Load the entire set of subqueues for a queue.

This will load the entire set of subqueues for a given queue (and can respect the pager, if desired). It does NOT cache the subqueues like nodequeue_load_subqueues does, so beware of this mixed caching.

Parameters

$qids: A $qid or array of $qids

$page_size: If non-zero, use the pager_query and limit the page-size to the parameter.

35 calls to nodequeue_load_subqueues_by_queue()

NodequeueAdministerTestCase::testNodequeueAddNode in tests/nodequeue.test

NodequeueAdministerTestCase::testNodequeueQueueOperations in tests/nodequeue.test

NodequeueAdministerTestCase::testNodequeueViewSubqueue in tests/nodequeue.test

NodequeueApacheSolrUnitTest::testNodequeueApacheSolrModifyQuery in tests/nodequeue.test

NodequeueAPIAccessUnitTest::testNodequeueQueueAccess in tests/nodequeue.test

... See full list

File

./nodequeue.module, line 816

Maintains queues of nodes in arbitrary order.

Code

function nodequeue_load_subqueues_by_queue($qids, $page_size = 0) {
  if (is_numeric($qids)) {
    $qids = array(
      $qids,
    );
  }
  if (empty($qids)) {
    return array();
  }
  $query = "SELECT s.*, (SELECT count(*) FROM {nodequeue_nodes} n WHERE n.sqid = s.sqid) AS count FROM {nodequeue_subqueue} s WHERE s.qid IN (" . db_placeholders($qids, 'int') . ")";
  if ($page_size) {
    $result = pager_query($query, $page_size, 0, $qids);
  }
  else {
    $result = db_query($query, $qids);
  }
  $subqueues = array();
  while ($subqueue = db_fetch_object($result)) {
    $subqueues[$subqueue->sqid] = $subqueue;
  }
  return $subqueues;
}