How to load the DropDown in Jqgrid

Question

How to load the DropDown in Jqgrid

Navigation

#1 by (3 votes)
#2 by (1 votes)

5

I have tried different ways to load dropdown from my DB to jqgrid but I really do not get it, the idea is to show the dropwdown and set the selected that I bring it from my DB . Attachment captures:

In charge should load my dropdown , but does not do it if you bring the data from my DB to fill this dropdown :

To fill in the grid, bring the following data :

My code is as follows:

 var combobox_personal = $.ajax({
        url:'/listadoPersonal',
        async:false,
        success:function(data, result){
            if(!result){alert('erro ar cargar');}
        }
    }).responseText;

   var sac_id=1;
   var csrftoken = getCookie('csrftoken');
    $("#grid_plan_accion").jqGrid({

        url:'/selectPlanAccion',
        postData: {
            csrfmiddlewaretoken : csrftoken, 
            id_sac: sac_id,
        },
        datatype: 'json',
        colNames: ['DETALLE<', 'PLAZO', 'RESPONSABLE', '<span class="badge bg-green">ACCIONES</span>'],
        colModel: [
                { label: 'detalle_plan_accion', name: 'detalle_plan_accion', width: 170, sorttype: "string", editable: true, edittype:"text"},
                { label: 'plazo_plan_accion ', name: 'plazo_plan_accion', width: 40, sorttype: "string", editable: true, edittype: 'text' },
                {name:'responsable_plan_accion_id',index:'responsable_plan_accion_id', width:100, editable:true, edittype: "select", formatter:'select',editoptions: { value: combobox_personal} }, 
                { name: "Acciones", formatter: buttonEliminarFormatter, width: 90, align:'center', search: false, 
                    sortable: false, hidedlg: true, resizable: false, editable: false, viewable: false
                }
        ],
        rowNum: 10,
        width:800,
        height: 200,
        //data:'mydata',
        caption:'PLAN DE ACCION',
        shrinkToFit: true,
        pager: '#pager_plan_accion',
        cellEdit: false,
        cellsubmit: 'clientArray',
        editurl: "clientArray",
    });

I do not know what the error is maybe a suggestion ...

javascript jqgrid

asked by Diego Avila 06.07.2018 в 22:21

source

2 answers

3

you just have to change:

editoptions: {value: combobox_personal}
editoptions: {value:JSON.parse(combobox_personal)}

answered by 23.11.2018 в 15:50

Can you draw rectangles of Riemann sums with Python 3? Can you operate with decimals in Bash?

score 1 · Accepted Answer

I will base my answer on when I used jqgrid some time ago, and for that time they had specific formats for the creation of select option:

Your variable combobox_personal should have the following format:

Chain type:

combobox_personal = "1:Diego Avila; 2:Julia Pazmino; 3:Vinicio Coello"

or

Type json:

combobox_personal = { 1:'Diego Avila', 2:'Julia Pazmino', 3:'Vinicio Coello' }

Also verify that when you do editoptions: { value: combobox_personal } and combobox_personal is filled with the information.

When you make the call to '/listadoPersonal' you can format the value that the query brings or return it with some of those formats in the query.

For example (assuming that combobox_personal is a json, if not, parse it):

var combobox_personal = [{ nombre:'Diego Avila', id:1}, {nombre:'Julia Pazmino', id:2}, {nombre:'Vinicio Coello', id:3 }];

var arr_personal = [];

for(var i in combobox_personal) {
    arr_personal.push(combobox_personal[i].id + ":" + combobox_personal[i].nombre);
}

combobox_personal = arr_personal.join("; ");

console.log(combobox_personal);