book_shit.php

<?php

/**
 * Book Manager Service.
 */
class BookManager {

  /**
   * Constructs a BookManager object.
   */
  public function __construct(BookStorageInterface $book_storage, EntityManager $entity_manager, TranslationInterface $translation, ConfigFactory $config_factory) {
    $this->bookStorage = $book_storage;
    $this->entityManager = $entity_manager;
    $this->translation =  $translation;
    $this->configFactory = $config_factory;
  }

  /**
   * Loads Books Array.
   */
  protected function loadBooks() {
    $this->books = array();

    $book_links = $this->bookStorage->findAll();
    if (!empty($book_links)) {
      $nodes = $this->entityManager->getStorageController('node')->loadMultiple($nids);

      foreach ($book_links as $link) {
        $nid = $link['nid'];
        if (isset($nodes[$nid]) && $nodes[$nid]->status) {
          $link['href'] = $link['link_path'];
          $link['options'] = unserialize($link['options']);
          $link['title'] = $nodes[$nid]->label();
          $link['type'] = $nodes[$nid]->bundle();
          $this->books[$link['bid']] = $link;
        }
      }
    }
  }
}

class DatabaseBookStorage implements BookStorageInterface {

  /**
   * Constructs a BookManager object.
   */
  public function __construct(Connection $connection) {
    $this->connection = $connection;
  }

  function findAll() {
    $nids = $this->connection->query("SELECT DISTINCT(bid) FROM {book}")->fetchCol();

    $book_links = array();
    if ($nids) {
      $query = $this->connection->select('book', 'b', array('fetch' => \PDO::FETCH_ASSOC));
      $query->join('menu_links', 'ml', 'b.mlid = ml.mlid');
      $query->fields('b');
      $query->fields('ml');
      $query->condition('b.nid', $nids);
      $query->orderBy('ml.weight');
      $query->orderBy('ml.link_title');
      $query->addTag('node_access');
      $query->addMetaData('base_table', 'book');
      $book_links = $query->execute();
    }

    return $book_links;
  }
}