public function getRevisionDbInfo($siteId, $name, $revisionId)
    {
        /** @var \Doctrine\ORM\QueryBuilder $queryBuilder */
        $queryBuilder = $this->_em->createQueryBuilder()
            ->select(
                'container,'
                . 'publishedRevision.revisionId,'
                . 'revision,'
                . 'pluginWrappers,'
                . 'pluginInstances'
            )
            ->from(\Rcm\Entity\Container::class, 'container')
            ->leftJoin('container.publishedRevision', 'publishedRevision')
            ->leftJoin('container.site', 'site')
            ->leftJoin('container.revisions', 'revision')
            ->leftJoin('revision.pluginWrappers', 'pluginWrappers')
            ->leftJoin('pluginWrappers.instance', 'pluginInstances')
            ->where('site.siteId = :siteId')
            ->andWhere('container.name = :containerName')
            ->andWhere('revision.revisionId = :revisionId')
            ->orderBy('pluginWrappers.renderOrder', 'ASC')
            ->setParameter('siteId', $siteId)
            ->setParameter('containerName', $name)
            ->setParameter('revisionId', $revisionId);

        $getData = $queryBuilder->getQuery()->getSingleResult(
            Query::HYDRATE_ARRAY
        );

        $result = null;

        if (!empty($getData)) {
            $result = $getData[0];
            $result['revision'] = $result['revisions'][$revisionId];
            unset($result['revisions'], $getData);
        }

        return $result;
    }
public function getRevisionDbInfo($siteId, $name, $revisionId)
    {
        /** @var \Doctrine\ORM\QueryBuilder $queryBuilder */
        $queryBuilder = $this->_em->createQueryBuilder()
            ->select(
                'container,'
                . 'publishedRevision.revisionId,'
                . 'revision,'
                . 'pluginWrappers,'
                . 'pluginInstances'
            )
            ->from(\Rcm\Entity\Container::class, 'container')
            ->leftJoin('container.publishedRevision', 'publishedRevision')
            ->leftJoin('container.site', 'site')
            ->leftJoin('container.revisions', 'revision')
            ->leftJoin('revision.pluginWrappers', 'pluginWrappers')
            ->leftJoin('pluginWrappers.instance', 'pluginInstances')
            ->where('site.siteId = :siteId')
            ->andWhere('container.name = :containerName')
            ->andWhere('revision.revisionId = :revisionId')
            ->orderBy('pluginWrappers.renderOrder', 'ASC')
            ->setParameter('siteId', $siteId)
            ->setParameter('containerName', $name)
            ->setParameter('revisionId', $revisionId);

        $getData = $queryBuilder->getQuery()->getSingleResult(
            Query::HYDRATE_ARRAY
        );

        $result = null;

        if (!empty($getData)) {
            $result = $getData[0];
            $result['revision'] = $result['revisions'][$revisionId];
            unset($result['revisions'], $getData);
        }

        return $result;
    }
public function getRevisionDbInfo ( $ siteId , $ name , $ revisionId ) { /** @var \Doctrine\ORM\QueryBuilder $queryBuilder */ $ queryBuilder = $ this -> _em -> createQueryBuilder ( ) -> select ( 'container,' . 'publishedRevision.revisionId,' . 'revision,' . 'pluginWrappers,' . 'pluginInstances' ) -> from ( \ Rcm \ Entity \ Container :: class , 'container' ) -> leftJoin ( 'container.publishedRevision' , 'publishedRevision' ) -> leftJoin ( 'container.site' , 'site' ) -> leftJoin ( 'container.revisions' , 'revision' ) -> leftJoin ( 'revision.pluginWrappers' , 'pluginWrappers' ) -> leftJoin ( 'pluginWrappers.instance' , 'pluginInstances' ) -> where ( 'site.siteId = :siteId' ) -> andWhere ( 'container.name = :containerName' ) -> andWhere ( 'revision.revisionId = :revisionId' ) -> orderBy ( 'pluginWrappers.renderOrder' , 'ASC' ) -> setParameter ( 'siteId' , $ siteId ) -> setParameter ( 'containerName' , $ name ) -> setParameter ( 'revisionId' , $ revisionId ) ; $ getData = $ queryBuilder -> getQuery ( ) -> getSingleResult ( Query :: HYDRATE_ARRAY ) ; $ result = null ; if ( ! empty ( $ getData ) ) { $ result = $ getData [ 0 ] ; $ result [ 'revision' ] = $ result [ 'revisions' ] [ $ revisionId ] ; unset ( $ result [ 'revisions' ] , $ getData ) ; } return $ result ; }
Get Revision DB Info

@param integer $siteId     Site Id
@param string  $name       Page Name
@param string  $revisionId Revision Id

@return null|array Database Result Set
Get Revision DB Info