function bat_type_get_pending_revisions in Booking and Availability Management Tools for Drupal 7

Retrieve a list of revisions with a revision_id greater than the current.

Parameters

int $type_id: The type id to retrieve.

Return value

array An array of revisions (latest first), each containing revision_id, name and bundle.

1 call to bat_type_get_pending_revisions()

bat_type_revisioning_rules_action_publish_latest in modules/bat_unit/bat_unit.rules.inc

Action: publish most recent pending revision.

File

modules/bat_unit/bat_unit.module, line 1504

Code

function bat_type_get_pending_revisions($type_id) {
  $sql = "SELECT r.revision_id, r.name, n.type FROM {bat_types} n INNER JOIN {bat_types_revision} r ON n.type_id = r.type_id WHERE (r.revision_id > n.revision_id AND n.type_id = :type_id) ORDER BY r.revision_id DESC";
  $result = db_query($sql, array(
    ':type_id' => $type_id,
  ));
  $revisions = array();
  foreach ($result as $revision) {
    $revisions[$revision->revision_id] = $revision;
  }
  return $revisions;
}