function BookOutlineStorage::getBookMenuTree

File

core/modules/book/src/BookOutlineStorage.php, line 99

Class

BookOutlineStorage

Defines a storage class for books outline.

Namespace

Code

public function getBookMenuTree($bid, $parameters, $min_depth, $max_depth) {
  $query = $this->connection
    ->select('book');
  $query->fields('book');
  for ($i = 1; $i <= $max_depth; $i++) {
    $query->orderBy('p' . $i, 'ASC');
  }
  $query->condition('bid', $bid);
  if (!empty($parameters['expanded'])) {
    $query->condition('pid', $parameters['expanded'], 'IN');
  }
  if ($min_depth != 1) {
    $query->condition('depth', $min_depth, '>=');
  }
  if (isset($parameters['max_depth'])) {
    $query->condition('depth', $parameters['max_depth'], '<=');
  }
  // Add custom query conditions, if any were passed.
  if (isset($parameters['conditions'])) {
    foreach ($parameters['conditions'] as $column => $value) {
      $query->condition($column, $value);
    }
  }
  return $query->execute();
}