ezsystems / ezpublish-kernel

     *

     * @return int

     */

    public function countRoleAssignmentsUsingSection($id)

    {

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

        $query->select(

            $query->expr->count(

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

            )

        )->from(

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

        )->where(

            $query->expr->lAnd(

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('limit_identifier', 'ezuser_role'),

                    $query->bindValue('Section', null, \PDO::PARAM_STR)

                ),

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('limit_value', 'ezuser_role'),

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

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * Deletes the Section with $id.

     *

     * @return array

     */

    public function loadObjectStateDataForContent($contentId, $stateGroupId)

    {

        $query = $this->createObjectStateFindQuery();

        $query->innerJoin(

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

            $query->expr->eq(

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

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

            )

        )->where(

            $query->expr->lAnd(

                $query->expr->eq(

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

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

                ),

                $query->expr->eq(

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

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

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * Returns the number of objects which are in this state.