ezsystems / ezpublish-kernel

     * @param string $name

     * @param string $identifier

     */

    public function updateSection($id, $name, $identifier)

    {

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

        $query->update(

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

        )->set(

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

            $query->bindValue($name)

        )->set(

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

            $query->bindValue($identifier)

        )->where(

            $query->expr->eq(

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

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

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Loads data for section with $id.

     *

     * @return int

     */

    public function countContentObjectsInSection($id)

    {

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

        $query->select(

            $query->alias(

                $query->expr->count(

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

                ),

                'content_count'

            )

        )->from(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return (int)$statement->fetchColumn();

    }

    /**

     * Counts the number of role policies using section with $id in their limitations.

     *

     * @return int

     */

    public function countTypesInGroup($groupId)

    {

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

        $q->select(

            $q->alias(

                $q->expr->count(

                    $this->dbHandler->quoteColumn('contentclass_id')

                ),

                'count'

            )

        )->from(

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

        )->where(

            $q->expr->eq(

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

                $q->bindValue($groupId, null, \PDO::PARAM_INT)

            )

        );

        $stmt = $q->prepare();

        $stmt->execute();

        return (int)$stmt->fetchColumn();

    }

    /**

     * Returns the number of Groups the type is assigned to.

     *

     * @return int

     */

    public function countInstancesOfType($typeId)

    {

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

        $q->select(

            $q->alias(

                $q->expr->count(

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

                ),

                'count'

            )

        )->from(

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

        )->where(

            $q->expr->eq(

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

                $q->bindValue($typeId, null, \PDO::PARAM_INT)

            )

        );

        $stmt = $q->prepare();

        $stmt->execute();

        return (int)$stmt->fetchColumn();

    }

    /**

     * Deletes all field definitions of a Type.

     *

     * @return int

     */

    public function getLastVersionNumber($contentId)

    {

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

        $query->select(

            $query->expr->max($this->dbHandler->quoteColumn('version'))

        )->from(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return (int)$statement->fetchColumn();

    }

    /**

     * Returns all IDs for locations that refer to $contentId.