ezsystems / ezpublish-kernel

     * @param mixed $contentId

     * @param mixed $roleId

     */

    public function removeRole($contentId, $roleId)

    {

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

        $query

            ->deleteFrom($this->handler->quoteTable('ezuser_role'))

            ->where(

                $query->expr->lAnd(

                    $query->expr->eq(

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

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

                    ),

                    $query->expr->eq(

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

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

                    )

                )

            );

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

    }

    /**

     * Remove role from user or user group, by assignment ID.

     *

     * @return array

     */

    public function updateRole(RoleUpdateStruct $role)

    {

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

        $query

            ->update($this->handler->quoteTable('ezrole'))

            ->set(

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

                $query->bindValue($role->identifier)

            )->where(

                $query->expr->eq(

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

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

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        // Commented due to EZP-24698: Role update leads to NotFoundException

        // Should be fixed with PDO::MYSQL_ATTR_FOUND_ROWS instead

        /*if ($statement->rowCount() < 1) {

            throw new NotFoundException('role', $role->id);

        }*/

    }

    /**

     * Delete the specified role (draft).

     * @param int $oldStateId

     * @param int $newStateId

     */

    public function updateObjectStateLinks($oldStateId, $newStateId)

    {

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

        $query->update(

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

        )->set(

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

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Deletes object state links identified by $stateId.

     * @param mixed $stateId

     * @param int $priority

     */

    public function updateObjectStatePriority($stateId, $priority)

    {

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

        $query->update(

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

        )->set(

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

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Creates a generalized query for fetching object state(s).

     * @param int $sectionId

     * @param int $contentId

     */

    public function assignSectionToContent($sectionId, $contentId)

    {

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

        $query->update(

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

        )->set(

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

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

}

     * @param mixed $typeId

     * @param int $status

     */

    public function deleteFieldDefinitionsForType($typeId, $status)

    {

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

        $q->deleteFrom(

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

        )->where(

            $q->expr->lAnd(

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                )

            )

        );

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

    }

    /**

     * Deletes a Type completely.

     * @param mixed $typeId

     * @param int $status

     */

    public function deleteType($typeId, $status)

    {

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

        $q->deleteFrom(

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

        )->where(

            $q->expr->lAnd(

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                )

            )

        );

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

    }

    /**

     * Deletes all group assignments for a Type.

     * @param mixed $typeId

     * @param int $status

     */

    public function deleteGroupAssignmentsForType($typeId, $status)

    {

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

        $q->deleteFrom(

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

        )->where(

            $q->expr->lAnd(

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                )

            )

        );

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

    }

    /**

     * Publishes the Type with $typeId from $sourceVersion to $targetVersion,

     *

     * @return int[]

     */

    public function getContentIdsByContentTypeId($contentTypeId)

    {

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

        $query

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

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

            ->where(

                $query->expr->eq(

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

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

                )

            );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(PDO::FETCH_COLUMN);

    }

    /**

     * Load name data for set of content id's and corresponding version number.

     *

     * @return int[]

     */

    public function listVersionNumbers($contentId)

    {

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

        $query->selectDistinct(

            $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 $statement->fetchAll(\PDO::FETCH_COLUMN);

    }

    /**

     * Returns last version number for content identified by $contentId.

     *

     * @return int[]

     */

    public function getAllLocationIds($contentId)

    {

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

        $query->select(

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

        )->from(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * Returns all field IDs of $contentId grouped by their type.