/**
* {@inheritdoc}
*/
protected function getPageBy(SiteInterface $site = null, $fieldName, $value)
{
if ('id' === $fieldName) {
$fieldName = 'pageId';
$id = $value;
} else {
$id = null;
}
if (null === $id || !$site || $site && !isset($this->pages[$site->getId()][$id])) {
$parameters = array($fieldName => $value);
if ($site) {
$parameters['site'] = $site;
}
$snapshot = $this->snapshotManager->findEnableSnapshot($parameters);
if (!$snapshot) {
throw new PageNotFoundException();
}
$page = new SnapshotPageProxy($this->snapshotManager, $this->transformer, $snapshot);
$site = $page->getSite();
if ($page) {
$this->loadBlocks($page);
$id = $page->getId();
$this->pages[$site->getId()][$id] = $page;
}
}
return $this->pages[$site->getId()][$id];
}
/**
* {@inheritdoc}
*/
public function getChildren(PageInterface $parent)
{
if (!isset($this->children[$parent->getId()])) {
$date = new \Datetime();
$parameters = array('publicationDateStart' => $date, 'publicationDateEnd' => $date, 'parentId' => $parent->getId());
$manager = $this->registry->getManagerForClass($this->snapshotManager->getClass());
if (!$manager instanceof EntityManagerInterface) {
throw new \RuntimeException('Invalid entity manager type');
}
$snapshots = $manager->createQueryBuilder()->select('s')->from($this->snapshotManager->getClass(), 's')->where('s.parentId = :parentId and s.enabled = 1')->andWhere('s.publicationDateStart <= :publicationDateStart AND ( s.publicationDateEnd IS NULL OR s.publicationDateEnd >= :publicationDateEnd )')->orderBy('s.position')->setParameters($parameters)->getQuery()->execute();
$pages = array();
foreach ($snapshots as $snapshot) {
$page = new SnapshotPageProxy($this->snapshotManager, $this, $snapshot);
$pages[$page->getId()] = $page;
}
$this->children[$parent->getId()] = new \Doctrine\Common\Collections\ArrayCollection($pages);
}
return $this->children[$parent->getId()];
}
/**
* Get children
*
* @param \Sonata\PageBundle\Model\PageInterface $parent
* @return Collection
*/
public function getChildren(PageInterface $parent)
{
if (!isset($this->children[$parent->getId()])) {
$date = new \Datetime();
$parameters = array('publicationDateStart' => $date, 'publicationDateEnd' => $date, 'parentId' => $parent->getId());
$snapshots = $this->entityManager->createQueryBuilder()->select('s')->from('Application\\Sonata\\PageBundle\\Entity\\Snapshot', 's')->where('s.parentId = :parentId and s.enabled = 1')->andWhere('s.publicationDateStart <= :publicationDateStart AND ( s.publicationDateEnd IS NULL OR s.publicationDateEnd >= :publicationDateEnd )')->orderBy('s.position')->setParameters($parameters)->getQuery()->execute();
$pages = array();
foreach ($snapshots as $snapshot) {
$page = new SnapshotPageProxy($this, $snapshot);
$pages[$page->getId()] = $page;
}
$this->children[$parent->getId()] = new \Doctrine\Common\Collections\ArrayCollection($pages);
}
return $this->children[$parent->getId()];
}
/**
* {@inheritdoc}
*/
public function getChildren(PageInterface $parent)
{
if (!isset($this->children[$parent->getId()])) {
$date = new \Datetime();
$parameters = array('publicationDateStart' => $date, 'publicationDateEnd' => $date, 'parentId' => $parent->getId());
$manager = $this->registry->getManagerForClass($this->snapshotManager->getClass());
if (!$manager instanceof EntityManagerInterface) {
throw new \RuntimeException('Invalid entity manager type');
}
$snapshots_query = $manager->createQueryBuilder()->select('s')->from($this->snapshotManager->getClass(), 's')->where('s.parentId = :parentId and s.enabled = 1')->andWhere('s.publicationDateStart <= :publicationDateStart AND ( s.publicationDateEnd IS NULL OR s.publicationDateEnd >= :publicationDateEnd )')->orderBy('s.position')->setParameters($parameters)->getQuery();
$snapshots_query->setHint(\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER, 'Gedmo\\Translatable\\Query\\TreeWalker\\TranslationWalker');
$snapshots_query->setHint(\Gedmo\Translatable\TranslatableListener::HINT_TRANSLATABLE_LOCALE, $parent->getSite()->getLocale());
$snapshots = $snapshots_query->execute();
$pages = array();
foreach ($snapshots as $snapshot) {
$page = new SnapshotPageProxy($this->snapshotManager, $this, $snapshot);
$pages[$page->getId()] = $page;
}
$this->children[$parent->getId()] = new \Doctrine\Common\Collections\ArrayCollection($pages);
}
return $this->children[$parent->getId()];
}
