How to refresh datagrid select field

This topic contains 5 replies, has 3 voices, and was last updated by berbass 6 years, 10 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

Creator
Topic

January 23, 2017 at 8:13 am #36433

scivray

Participant

Hi,
I got the following datagrid :

    grid-produit-partList:
        source:
            type: orm
            query:  
                select: 
                    - l.id as id
                    - l.sku as sku
                    - p.id as part
                    - l.value as value
                from: 
                    - { table: CLNomenclatureBundle:LignePartList, alias:  l }
                join: 
                    left:
                        - { join: l.part, alias:  p }
                where:
                    and:
                        - l.sku = :param
            bind_parameters:
                param: sku
        columns:
            id:
                label: 'cl.nomenclature.produit.grid-produit-partList.columns.id'
                renderable: false
                align: left
            sku:
                label: "cl.nomenclature.produit.grid-produit-partList.columns.sku"
                frontend_type: integer
                align: left
                renderable: false
            part:
                label: "cl.nomenclature.produit.grid-produit-partList.columns.part"
                frontend_type: select
                align: left
                choices: "@cl_nomenclature.repository.part->getChoices"
                inline_editing:
                    enable: true
                    editor:
                        view: oroform/js/app/views/editor/select-editor-view
            value:
                label: "cl.nomenclature.produit.grid-produit-partList.columns.value"
                frontend_type: string
                align: left
                inline_editing:
                    enable: true
        filters:
            columns:
                sku:
                    type:      number
                    label:     "cl.nomenclature.produit.grid-produit-partList.filters.sku"
                    data_name: sku
                part:
                    type:      choice
                    label:     "cl.nomenclature.produit.grid-produit-partList.filters.part"
                    data_name: part
                    options:
                        field_options:
                            choices: "@cl_nomenclature.repository.part->getChoices"
                value:
                    type:      string
                    label:     "cl.nomenclature.produit.grid-produit-partList.filters.value"
                    data_name: value
        sorters:
            columns:
                sku:
                    data_name: sku
                part:
                    data_name: part
                value:
                    data_name: value 
        properties:
            lignePartList_add_link:
                type:   url
                route:  cl_nomenclature.produit.part_list.addLigne
                params: 
                    - sku
                    - id
            lignePartList_delete_link:
                type:   url
                route:  cl_nomenclature.produit.part_list.removeLigne
                params: 
                    - sku
                    - id
        actions:
            add:
                type:       navigate
                label:      "cl.nomenclature.produit.grid-produit-partList.action.add"
                link:       lignePartList_add_link
                icon:       plus-sign
            delete:
                type:       navigate
                label:      "cl.nomenclature.produit.grid-produit-partList.action.delete"
                link:       lignePartList_delete_link
                icon:       remove

        inline_editing:
            enable: true
            entity_name: CL\Bundle\NomenclatureBundle\Entity\LignePartList
            behaviour: enable_selected
            plugin: orodatagrid/js/app/plugins/grid/inline-editing-plugin
            default_editors: orodatagrid/js/inline-editing/default-editors
            save_api_accessor:
                route: cl_nomenclature.produit.part_list.update
                http_method: PATCH

100

101

102

103

grid-produit-partList:

source:

type: orm

query:

select:

- l.id as id

- l.sku as sku

- p.id as part

- l.value as value

from:

- { table: CLNomenclatureBundle:LignePartList, alias: l }

join:

left:

- { join: l.part, alias: p }

where:

and:

- l.sku = :param

bind_parameters:

param: sku

columns:

id:

label: 'cl.nomenclature.produit.grid-produit-partList.columns.id'

renderable: false

align: left

sku:

label: "cl.nomenclature.produit.grid-produit-partList.columns.sku"

frontend_type: integer

align: left

renderable: false

part:

label: "cl.nomenclature.produit.grid-produit-partList.columns.part"

frontend_type: select

align: left

choices: "@cl_nomenclature.repository.part->getChoices"

inline_editing:

enable: true

editor:

view: oroform/js/app/views/editor/select-editor-view

value:

label: "cl.nomenclature.produit.grid-produit-partList.columns.value"

frontend_type: string

align: left

inline_editing:

enable: true

filters:

columns:

sku:

type: number

label: "cl.nomenclature.produit.grid-produit-partList.filters.sku"

data_name: sku

part:

type: choice

label: "cl.nomenclature.produit.grid-produit-partList.filters.part"

data_name: part

options:

field_options:

choices: "@cl_nomenclature.repository.part->getChoices"

value:

type: string

label: "cl.nomenclature.produit.grid-produit-partList.filters.value"

data_name: value

sorters:

columns:

sku:

data_name: sku

part:

data_name: part

value:

data_name: value

properties:

lignePartList_add_link:

type: url

route: cl_nomenclature.produit.part_list.addLigne

params:

- sku

- id

lignePartList_delete_link:

type: url

route: cl_nomenclature.produit.part_list.removeLigne

params:

- sku

- id

actions:

add:

type: navigate

label: "cl.nomenclature.produit.grid-produit-partList.action.add"

link: lignePartList_add_link

icon: plus-sign

delete:

type: navigate

label: "cl.nomenclature.produit.grid-produit-partList.action.delete"

link: lignePartList_delete_link

icon: remove

inline_editing:

enable: true

entity_name: CL\Bundle\NomenclatureBundle\Entity\LignePartList

behaviour: enable_selected

plugin: orodatagrid/js/app/plugins/grid/inline-editing-plugin

default_editors: orodatagrid/js/inline-editing/default-editors

save_api_accessor:

route: cl_nomenclature.produit.part_list.update

http_method: PATCH

One column (named part) is a select based on one entity nammed Part.

In a index.html.twig, I show the datagrid and I have a button with custom modal and Ajax to add a new value in my Part entity.

I’m trying to add some js code to perform a refresh of the datagrid after creating a new value for my Part entity. I can see the datagrid refreshing but the select values are still the same and the select doesn’t show my new value.

I’ve tried :

mediator.trigger('datagrid:doReset:grid-produit-partList');

1	mediator.trigger('datagrid:doReset:grid-produit-partList');

but it doesn’t show my new value for the select.

Any idea of how to refresh my select values in the datagrid ?
Thank you.

Creator
Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author
Replies

January 31, 2017 at 9:46 am #36434

Mike Kudelya

Participant

Try to use ‘datagrid:doRefresh:<gridName>’ event.

February 1, 2017 at 12:26 am #36435

scivray

Participant

Hi,
‘datagrid:doRefresh:<gridName>’ or ‘datagrid:doReset:<gridName>’ don’t show my ajax added new Part entity.
I was thinking that maybe there is some cache somewhere that send cached values and prevents from getting new values.

I’ve also tried :
– after ajax creation of new Part entity, I empty the div containing the grid
– send the whole datagrid generate by the following twig in another ajax

{% import 'OroDataGridBundle::macros.html.twig' as dataGrid %}
{% spaceless %}
<div class="widget-content">
    {% block widget_content %}
    <div class="flash-messages">
        <div class="flash-messages-frame">
            <div class="flash-messages-holder"></div>
        </div>
    </div>
        {{ oro_widget_render({
            'widgetType': 'block',
            'url': path('oro_datagrid_widget', {gridName: 'grid-produit-partList', params: {'sku': sku} } ),
            'alias': 'grid-produit-partList',
            'params' : {'enableViews': false}
        }) }}
    {% endblock %}
</div>
{% endspaceless %}

{% import 'OroDataGridBundle::macros.html.twig' as dataGrid %}

{% spaceless %}

{% block widget_content %}

</div>

{{ oro_widget_render({

'widgetType': 'block',

'url': path('oro_datagrid_widget', {gridName: 'grid-produit-partList', params: {'sku': sku} } ),

'alias': 'grid-produit-partList',

'params' : {'enableViews': false}

}) }}

{% endblock %}

</div>

{% endspaceless %}

– set the previously empty div containing the grid with the received html data

but the new grid didn’t show :/

February 7, 2017 at 1:27 am #36436

Mike Kudelya

Participant

Unfortunately i didn’t find quick solution. I have created ticket to the team where we will investigate the issue.
Thank you for your patience.

February 7, 2017 at 1:30 am #36437

scivray

Participant

Hi,
Thank you

June 1, 2017 at 9:36 pm #36438

berbass

Participant

Hello guys,
is there any update on this issue? I an exactly in the same situation.

Thanks.

Author
Replies

Viewing 5 replies - 1 through 5 (of 5 total)

The forum ‘OroPlatform – How do I? Questions’ is closed to new topics and replies.

OroPlatform Forums