datagrid.yml

datagrid:
    users-grid:
        extended_entity_name: %oro_user.entity.class%
        options:
            entityHint: users
            entity_pagination: true
        acl_resource: oro_user_user_view
        source:
            type: orm
            query:
                select:
                    - u.id
                    - u.username
                    - u.email
                    - u.firstName
                    - u.lastName
                    - u.createdAt
                    - u.updatedAt
                    - u.enabled
                from:
                    - { table: %oro_user.entity.class%, alias: u }

        inline_editing:
            enable: true
        columns:
            firstName:
                label:         oro.user.first_name.label
            lastName:
                label:         oro.user.last_name.label
            email:
                label:         oro.user.email.label
            username:
                label:         oro.user.username.label
            enabled:
                label:         oro.user.enabled.label
                frontend_type: select
                inline_editing:
                    editor:
                        view_options:
                            key_type: 'boolean'
                choices:
                   - Inactive
                   - Active
            createdAt:
                label:         oro.ui.created_at
                frontend_type: datetime
            updatedAt:
                label:         oro.ui.updated_at
                frontend_type: datetime

        properties:
            id: ~
            update_link:
                type: url
                route: oro_user_update
                params:
                    - id
            view_link:
                type: url
                route: oro_user_view
                params:
                    - id
            delete_link:
                type: url
                route: oro_api_delete_user
                params:
                    - id
            config_link:
                type: url
                route: oro_user_config
                params:
                    - id
        sorters:
            columns:
                username:
                    data_name: u.username
                email:
                    data_name: u.email
                firstName:
                    data_name: u.firstName
                lastName:
                    data_name: u.lastName
                createdAt:
                    data_name: u.createdAt
                updatedAt:
                    data_name: u.updatedAt
                enabled:
                    data_name: u.enabled
            default:
                username: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        filters:
            columns:
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Inactive
                                1: Active
                createdAt:
                    type: datetime
                    data_name: u.createdAt
                updatedAt:
                    type: datetime
                    data_name: u.updatedAt

        actions:
            view:
                type:          navigate
                label:         oro.grid.action.view
                link:          view_link
                icon:          eye-open
                acl_resource:  oro_user_user_view
                rowAction:     true
            update:
                type:          navigate
                label:         oro.grid.action.update
                link:          update_link
                icon:          edit
                acl_resource:  oro_user_user_update
            config:
                type:          navigate
                label:         oro.user.user_configuration.grid.action.config
                link:          config_link
                icon:          cog
                acl_resource:  oro_user_user_config
            delete:
                type:          delete
                label:         oro.grid.action.delete
                link:          delete_link
                icon:          trash
                acl_resource:  oro_user_user_delete
        action_configuration: ['@oro_user.datagrid.action_checker', checkActions]

    groups-grid:
        extended_entity_name: %oro_user.group.entity.class%
        options:
            entityHint: groups
            entity_pagination: true
        acl_resource: oro_user_group_view
        source:
            type: orm
            query:
                select:
                    - g.id
                    - g.name
                from:
                    - { table: %oro_user.group.entity.class%, alias: g }
        columns:
            name:
                label: oro.user.group.name.label

        properties:
            id: ~
            update_link:
                type: url
                route: oro_user_group_update
                params:
                    - id

            delete_link:
                type: url
                route: oro_api_delete_group
                params:
                    - id

        actions:
            update:
                type:          navigate
                label:         oro.grid.action.update
                link:          update_link
                icon:          edit
                acl_resource:  oro_user_group_update
                rowAction:     true
            delete:
                type:          delete
                label:         oro.grid.action.delete
                link:          delete_link
                icon:          trash
                acl_resource:  oro_user_group_delete

        sorters:
            columns:
                name:
                    data_name: g.name
            default:
                name: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        filters:
            columns:
                name:
                    type: string
                    data_name: g.name

    roles-grid:
        extended_entity_name: %oro_user.role.entity.class%
        options:
            entityHint: roles
            entity_pagination: true
        acl_resource: oro_user_role_view
        source:
            type: orm
            skip_acl_apply: true
            query:
                select:
                    - r
                    - r.id
                    - r.role
                    - r.label
                from:
                    - { table: %oro_user.role.entity.class%, alias: r }
                where:
                    and:
                        - r.role <> '%oro_user.entity.class%::ROLE_ANONYMOUS'
        columns:
            label:
                label: oro.user.role.label.label

        properties:
            id: ~
            view_link:
                type:   url
                route:  oro_user_role_view
                params:
                    - id
            update_link:
                type: url
                route: oro_user_role_update
                params:
                    - id
            delete_link:
                type: url
                route: oro_api_delete_role
                params:
                    - id
        actions:
            view:
                type:          navigate
                label:         oro.grid.action.view
                link:          view_link
                icon:          eye-open
                rowAction:     true
            update:
                type:          navigate
                label:         oro.grid.action.update
                link:          update_link
                icon:          edit
                acl_resource:  oro_user_role_update
            delete:
                type:          delete
                label:         oro.grid.action.delete
                link:          delete_link
                icon:          trash
                acl_resource:  oro_user_role_delete

        action_configuration: "@oro_user.role.datagrid_helper->getActionConfigurationClosure"

        sorters:
            columns:
                label:
                    data_name: r.label
            default:
                label: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        filters:
            columns:
                label:
                    type: string
                    data_name: r.label

    user-relation-grid:
        source:
            type: orm
            query:
                select:
                    - u.id
                    - u.username
                    - u.email
                    - u.firstName
                    - u.lastName
                    - u.enabled
                from:
                    - { table: OroUserBundle:User, alias: u }

        columns: []

        properties:
            id: ~

        sorters:
            columns:
                username:
                    data_name: u.username
                email:
                    data_name: u.email
                firstName:
                    data_name: u.firstName
                lastName:
                    data_name: u.lastName
            default:
                id: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        filters: []

    role-view-users-grid:
        extends: user-relation-grid
        acl_resource: oro_user_role_view
        source:
            query:
                join:
                    left:
                        - { join: u.roles, alias: r }
                where:
                    and:
                      - r.id = :role_id
            bind_parameters:
                -
                    name: role_id
                    default: null
        columns:
            firstName:
                label: oro.user.first_name.label
            lastName:
                label: oro.user.last_name.label
            email:
                label: oro.user.email.label
            username:
                label: oro.user.username.label
            enabled:
                label: oro.user.enabled.label
                frontend_type: select
                choices:
                   - Disabled
                   - Enabled
        filters:
            columns:
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Disabled
                                1: Enabled
        sorters:
            multiple_sorting: true
            default:
                lastName: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

    role-users-grid:
        extends: user-relation-grid
        acl_resource: oro_user_role_update
        source:
            query:
                select:
                    - >
                      (CASE WHEN (:role_id IS NOT NULL) THEN
                        CASE WHEN (:role_id MEMBER OF u.roles OR u.id IN (:data_in)) AND u.id NOT IN (:data_not_in)
                        THEN true ELSE false END
                      ELSE
                        CASE WHEN u.id IN (:data_in) AND u.id NOT IN (:data_not_in)
                        THEN true ELSE false END
                      END) as has_role
            bind_parameters:
                -
                    name: role_id
                    default: null
        columns:
            has_role:
                label: oro.user.role.has_role.label
                editable: true
                frontend_type: boolean
            firstName:
                label: oro.user.first_name.label
            lastName:
                label: oro.user.last_name.label
            email:
                label: oro.user.email.label
            username:
                label: oro.user.username.label
            enabled:
                label:         oro.user.enabled.label
                frontend_type: select
                choices:
                   - Inactive
                   - Active
        filters:
            columns:
                has_role:
                    type: boolean
                    data_name: has_role
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Inactive
                                1: Active
        sorters:
            multiple_sorting: true
            columns:
                has_role:
                    data_name: has_role

            default:
                has_role: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC
                lastName: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        options:
            rowSelection:
                dataField: id
                columnName: has_role
                selectors:
                    included: '#roleAppendUsers'
                    excluded: '#roleRemoveUsers'

    role-permission-grid:
            acl_resource: oro_user_role_update
            source:
                type: role-permission-provider
            columns:
                entity:
                    label: "Entity"
                    data_name: entity
                    frontend_type: string
                    translatable: true
                permissions:
                    label: "Permissions"
                    data_name: permissions
                    frontend_type: action-permissions
                identity:
                    data_name: identity
                    frontend_type: string
                    renderable: false
                group:
                    data_name: group
                    frontend_type: string
                    renderable: false
                fields:
                    data_name: fields
                    frontend_type: array
                    renderable: false
            filters: ~
            sorters: ~
            options:
                requireJSModules:
                    - orouser/js/datagrid/roles-datagrid-builder
                toolbarOptions:
                    placement:
                        top: false
                        bottom: false

    group-users-grid:
        extends: user-relation-grid

        source:
            query:
                select:
                    - >
                      (CASE WHEN (:group_id IS NOT NULL) THEN
                        CASE WHEN (:group_id MEMBER OF u.groups OR u.id IN (:data_in)) AND u.id NOT IN (:data_not_in)
                        THEN true ELSE false END
                      ELSE
                        CASE WHEN u.id IN (:data_in) AND u.id NOT IN (:data_not_in)
                        THEN true ELSE false END
                      END) as has_group
            bind_parameters:
                -
                    name: group_id
                    default: null
        columns:
            has_group:
                label: oro.user.group.has_group.label
                editable: true
                frontend_type: boolean
            firstName:
                label: oro.user.first_name.label
            lastName:
                label: oro.user.last_name.label
            email:
                label: oro.user.email.label
            username:
                label: oro.user.username.label
            enabled:
                label:         oro.user.enabled.label
                frontend_type: select
                choices:
                   - Inactive
                   - Active
        filters:
            columns:
                has_group:
                    type: boolean
                    data_name: has_group
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Inactive
                                1: Active
        sorters:
            multiple_sorting: true
            columns:
                has_group:
                    data_name: has_group
            default:
                has_group: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC
                lastName: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        options:
            rowSelection:
                dataField: id
                columnName: has_group
                selectors:
                    included: '#groupAppendUsers'
                    excluded: '#groupRemoveUsers'

    users-select-grid:
        extended_entity_name: %oro_user.entity.class%
        options:
            entityHint: users
        acl_resource: oro_user_user_view
        source:
            type: orm
            query:
                select:
                    - u.id
                    - u.username
                    - u.email
                    - u.firstName
                    - u.lastName
                    - u.enabled
                from:
                    - { table: %oro_user.entity.class%, alias: u }
        columns:
            firstName:
                label: oro.user.first_name.label
            lastName:
                label: oro.user.last_name.label
            email:
                label: oro.user.email.label
            username:
                label: oro.user.username.label
            enabled:
                label: oro.user.enabled.label
                frontend_type: select
                choices:
                   - Inactive
                   - Active

        properties:
            id: ~
        sorters:
            columns:
                username:
                    data_name: u.username
                email:
                    data_name: u.email
                firstName:
                    data_name: u.firstName
                lastName:
                    data_name: u.lastName
                enabled:
                    data_name: u.enabled
            default:
                username: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC
        filters:
            columns:
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Inactive
                                1: Active

    owner-users-select-grid:
        extended_entity_name: %oro_user.entity.class%
        options:
            entityHint: users
        source:
            type: orm
            skip_acl_apply: true
            query:
                select:
                    - u.id
                    - u.email
                    - u.username
                    - u.firstName
                    - u.lastName
                    - u.enabled
                from:
                    - { table: %oro_user.entity.class%, alias: u }
                where:
                    and:
                        - u.enabled=true
        columns:
            firstName:
                label: oro.user.first_name.label
            lastName:
                label: oro.user.last_name.label
            email:
                label: oro.user.email.label
            username:
                label: oro.user.username.label
            enabled:
                label: oro.user.enabled.label
                frontend_type: select
                choices:
                   - Inactive
                   - Active
        properties:
            id: ~
        sorters:
            columns:
                firstName:
                    data_name: u.firstName
                lastName:
                    data_name: u.lastName
                email:
                    data_name: u.email
                username:
                    data_name: u.username
                enabled:
                    data_name: u.enabled
            default:
                username: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC
        filters:
            columns:
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Inactive
                                1: Active

    users-select-grid-exclude-owner:
        extends: users-select-grid
        source:
            query:
                where:
                    and:
                        - u.id != @oro_security.security_facade->getLoggedUserId

    users-for-context-grid:
        extended_entity_name: %oro_user.entity.class%
        options:
            entityHint: users
            entity_pagination: true
            toolbarOptions:
                pageSize:
                    default_per_page: 10
            routerEnabled: false
        acl_resource: oro_user_user_view
        source:
            type: orm
            query:
                select:
                    - u.id
                    - u.username
                    - u.email
                    - u.firstName
                    - u.lastName
                    - u.enabled
                from:
                    - { table: %oro_user.entity.class%, alias: u }
                where:
                    and:
                        - u.id != @oro_security.security_facade->getLoggedUserId
        columns:
            id:
                label:         oro.user.id.label
            firstName:
                label:         oro.user.first_name.label
            lastName:
                label:         oro.user.last_name.label
            email:
                label:         oro.user.email.label
            username:
                label:         oro.user.username.label
            enabled:
                label:         oro.user.enabled.label
                frontend_type: select
                choices:
                   - Inactive
                   - Active
        sorters:
            columns:
                firstName:
                    data_name: u.firstName
                lastName:
                    data_name: u.lastName
                email:
                    data_name: u.email
                username:
                    data_name: u.username
                enabled:
                    data_name: u.enabled
            default:
                username: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC

        filters:
            columns:
                firstName:
                    type: string
                    data_name: u.firstName
                lastName:
                    type: string
                    data_name: u.lastName
                email:
                    type: string
                    data_name: u.email
                username:
                    type: string
                    data_name: u.username
                enabled:
                    type: boolean
                    data_name: u.enabled
                    options:
                        field_options:
                            choices:
                                2: Inactive
                                1: Active