ezsystems / ezpublish-kernel

     *

     * @return array

     */

    public function getBasicNodeData($nodeId)

    {

        $query = $this->handler->createSelectQuery();

        $query

            ->select('*')

            ->from($this->handler->quoteTable('ezcontentobject_tree'))

            ->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('node_id'),

                    $query->bindValue($nodeId)

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        if ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {

            return $row;

        }

        throw new NotFound('location', $nodeId);

    }

    /**

     * Returns an array with basic node data.

     *

     * @return array

     */

    public function getBasicNodeDataByRemoteId($remoteId)

    {

        $query = $this->handler->createSelectQuery();

        $query

            ->select('*')

            ->from($this->handler->quoteTable('ezcontentobject_tree'))

            ->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('remote_id'),

                    $query->bindValue($remoteId)

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        if ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {

            return $row;

        }

        throw new NotFound('location', $remoteId);

    }

    /**

     * Loads data for all Locations for $contentId, optionally only in the

     *

     * @return array

     */

    public function loadTrashByLocation($locationId)

    {

        $query = $this->handler->createSelectQuery();

        $query

            ->select('*')

            ->from($this->handler->quoteTable('ezcontentobject_trash'))

            ->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('node_id'),

                    $query->bindValue($locationId)

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        if ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {

            return $row;

        }

        throw new NotFound('trash', $locationId);

    }

    /**

     * Loads trash data specified by content ID.

     *

     * @return array

     */

    public function loadTrashByContent($contentId)

    {

        $query = $this->handler->createSelectQuery();

        $query

            ->select('*')

            ->from($this->handler->quoteTable('ezcontentobject_trash'))

            ->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('contentobject_id'),

                    $query->bindValue($contentId)

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        $rows = $statement->fetchAll(\PDO::FETCH_ASSOC);

        return $rows;

    }

    /**

     * List trashed items.

     *

     * @return array(int=>array(string=>mixed)) Data rows.

     */

    public function loadTypeDataByIdentifier($identifier, $status)

    {

        $q = $this->getLoadTypeQuery();

        $q->where(

            $q->expr->lAnd(

                $q->expr->eq(

                    $this->dbHandler->quoteColumn('identifier', 'ezcontentclass'),

                    $q->bindValue($identifier)

                ),

                $q->expr->eq(

                    $this->dbHandler->quoteColumn('version', 'ezcontentclass'),

                    $q->bindValue($status)

                )

            )

        );

        $stmt = $q->prepare();

        $stmt->execute();

        return $stmt->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads an array with data about the type referred to by $remoteId in

     *

     * @return array(int=>array(string=>mixed)) Data rows.

     */

    public function loadTypeDataByRemoteId($remoteId, $status)

    {

        $q = $this->getLoadTypeQuery();

        $q->where(

            $q->expr->lAnd(

                $q->expr->eq(

                    $this->dbHandler->quoteColumn('remote_id', 'ezcontentclass'),

                    $q->bindValue($remoteId)

                ),

                $q->expr->eq(

                    $this->dbHandler->quoteColumn('version', 'ezcontentclass'),

                    $q->bindValue($status)

                )

            )

        );

        $stmt = $q->prepare();

        $stmt->execute();

        return $stmt->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Returns a basic query to retrieve Type data.