ezsystems / ezpublish-kernel

     *

     * @return array

     */

    public function load($contentId, $version, array $translations = null)

    {

        $query = $this->queryBuilder->createFindQuery($translations);

        $query->where(

            $query->expr->lAnd(

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('id', 'ezcontentobject'),

                    $query->bindValue($contentId)

                ),

                $query->expr->eq(

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

                    $query->bindValue($version)

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * {@inheritdoc}

     *

     * @return int

     */

    public function getContentCount($stateId)

    {

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

        $query->select(

            $query->alias($query->expr->count('*'), 'count')

        )->from(

            $this->dbHandler->quoteTable('ezcobj_state_link')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('contentobject_state_id'),

                $query->bindValue($stateId, null, \PDO::PARAM_INT)

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        $count = $statement->fetchColumn();

        return $count !== null ? (int)$count : 0;

    }

    /**

     * Updates the object state priority to provided value.

     *

     * @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.