jQWidgets Forums

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • in reply to: Update data grid and columns Update data grid and columns #15973

    maxenz
    Member

    thanks man it works great.

    Please include this property in the api page.. i got crazy trying to do this.

    in reply to: Update data grid and columns Update data grid and columns #15966

    maxenz
    Member
    var columnas = [];	
    var sourceIncidentes, cellsRendererGrado, cellsRendererZona,dataAdapter;
    $('#jqxbutton').jqxButton({ width:100, height:100, theme: 'ui-redmond' });
    $("#jqxMenu").jqxMenu({ width: 800, theme: 'ui-redmond', height: 30});
    $("#jqxpanel").jqxPanel({ width: 800, height: 30, theme: 'ui-redmond'});
    var opcionesIncidentes = [
    "Incidentes en Curso",
    "Incidentes Pendientes",
    "Programados",
    ];
    $("#jqxdropdownlist").jqxDropDownList({ source: opcionesIncidentes, animationType:'fade', theme:'ui-redmond',dropDownHeight:'75px', selectedIndex: 0, width: '160px', height: '30px' });
    /* CONFIGURACION GRILLA INCIDENTES */
    cellsRendererGrado = function (row, columnfield, value, defaulthtml, columnproperties) {
    var data = $('#grdIncidentes').jqxGrid('getrowdata',row);
    var color = "#" + data["ColorGrado"];
    return '<span style=" padding-left:5px; padding-right:26px; padding-top:5px; padding-bottom:5px; float: ' + columnproperties.cellsalign + '; background-color:'+color+';">' + value + '</span>';
    }
    cellsRendererZona = function (row, columnfield, value, defaulthtml, columnproperties) {
    var data = $('#grdIncidentes').jqxGrid('getrowdata',row);
    var color = "#" + data["ColorZona"];
    return '<span style=" padding-left:5px; padding-right:26px; padding-top:5px; padding-bottom:5px; float: ' + columnproperties.cellsalign + '; background-color:'+color+';">' + value + '</span>';
    }
    setIncidentesActuales(0);
    dataAdapter = new $.jqx.dataAdapter(sourceIncidentes);
    $("#grdIncidentes").jqxGrid({
    showfilterrow: true,
    width: 800,
    height:400,
    pagesize:12,
    pagesizeoptions: ['10','12','20'],
    columnsresize: true,
    altrows: true,
    pageable: true,
    filterable: true,
    sortable: true,
    columns: columnas,
    source: dataAdapter,
    theme: 'ui-redmond',
    });
    /**********************************************************************************************************************************************/
    /* CONFIGURACION GRILLA MOVILES */
    var sourceMoviles ={
    datatype: "json",
    datafields: [{ name: 'Movil' },{ name: 'Situacion'}, {name: 'ColorMovil'}, {name: 'ColorSituacion'},{name: 'Localidad'}],
    url: 'qryMoviles.php'
    };
    var gridDataAdapter = new $.jqx.dataAdapter(sourceMoviles);
    var cellsRendererMovil = function (row, columnfield, value, defaulthtml, columnproperties) {
    var data = $('#grdMoviles').jqxGrid('getrowdata',row);
    var color = "#" + data["ColorMovil"];
    return '<span style=" padding-left:5px; padding-right:26px; padding-top:5px; padding-bottom:5px; float: ' + columnproperties.cellsalign + '; background-color:'+color+';">' + value + '</span>';
    }
    var cellsRendererSituacion = function (row, columnfield, value, defaulthtml, columnproperties) {
    var data = $('#grdMoviles').jqxGrid('getrowdata',row);
    var color = "#" + data["ColorSituacion"];
    return '<span style=" padding-left:5px; padding-right:26px; padding-top:5px; padding-bottom:5px; float: ' + columnproperties.cellsalign + '; background-color:'+color+';">' + value + '</span>';
    }
    $("#grdMoviles").jqxGrid({
    showfilterrow: true,
    width: 140,
    height:400,
    columnsresize: true,
    filterable: true,
    sortable: true,
    source: gridDataAdapter,
    theme: 'ui-redmond',
    columns: [{ text: 'Mov', datafield: 'Movil', width: 40, cellsrenderer: cellsRendererMovil },{ text: 'Sit', datafield: 'Situacion', width: 40, cellsrenderer: cellsRendererSituacion},{text: 'Loc', width:60, datafield: 'Localidad'},{ text: 'ColorMovil', hidden:true, datafield: 'ColorMovil', width: 40 },{ text: 'ColorSituacion', datafield: 'ColorSituacion', hidden:true, width: 130}]
    });
    /**********************************************************************************************************************************************/
    function refreshDataInc(opt) {
    if (opt == 0) {
    setIncidentesActuales();
    } else {
    setMoviles();
    }
    $('#grdIncidentes').jqxGrid({ columns : columnas });
    dataAdapter = new $.jqx.dataAdapter(sourceIncidentes);
    $('#grdIncidentes').jqxGrid({ source : dataAdapter });
    }
    function setIncidentesActuales() {
    sourceIncidentes ={
    datatype: "json",
    datafields: [{ name: 'ID' },{ name: 'Grado' },{ name: 'NroIncidente'}, {name: 'Domicilio'}, {name: 'Sintomas'},{name: 'Localidad'},{name: 'SexoEdad'},{name: 'ColorGrado'},{name: 'ColorZona'},{name: 'Cliente'},{name: 'Movil'}, {name: 'HorLlam'}, {name: 'Despacho'}, {name: 'Salida'}, {name: 'Atencion'}, {name: 'Paciente'}],
    url: 'data.php?opt=0'
    };
    columnas = [{ text: 'ID', datafield: 'ID', width: 30 },{ text: 'Cod', datafield: 'Grado', width: 40, cellsrenderer: cellsRendererGrado },{text: 'Entidad', width:60, datafield: 'Cliente'},{ text: 'Inc', datafield: 'NroIncidente', width: 40 },{ text: 'Domicilio', datafield: 'Domicilio', width: 130 },{ text: 'Sintomas', datafield: 'Sintomas', width: 120 },{ text: 'Loc', datafield: 'Localidad', width: 40, cellsrenderer: cellsRendererZona },{ text: 'SE', datafield: 'SexoEdad', width: 40 },{text: 'ColGr', datafield: 'ColorGrado', hidden:true},{text: 'ColZona', datafield: 'ColorZona', hidden:true},{ text: 'Mov', datafield: 'Movil', width: 35 },{ text: 'Llam', datafield: 'HorLlam', width: 40 },{ text: 'Dsp', datafield: 'Despacho', width: 40 },{ text: 'Sal', datafield: 'Salida', width: 40 }, { text: 'Ate', datafield: 'Atencion', width: 40 },{ text: 'Paciente', datafield: 'Paciente', width: 135 }];
    }
    function setIncidentesProgramados() {
    sourceIncidentes ={
    datatype: "json",
    datafields: [{ name: 'ID' },{ name: 'Grado' },{ name: 'Traslado'}, {name: 'HoraLlegada'}, {name: 'Domicilio'},{name: 'Localidad'},{name: 'Sintomas'},{name: 'ColorGrado'},{name: 'ColorZona'},{name: 'Cliente'},{name: 'Movil'}, {name: 'SexoEdad'}, {name: 'Referencia'}, {name: 'Paciente'},{name : 'Fecha'}],
    url: 'data.php?opt=1'
    };
    columnas = [{ text: 'ID', datafield: 'ID', width: 30 },{ text: 'Cod', datafield: 'Grado', width: 40, cellsrenderer: cellsRendererGrado },{text: 'Entidad', width:60, datafield: 'Cliente'},{ text: 'Nro', datafield: 'Traslado', width: 40 },{ text: 'Domicilio', datafield: 'Domicilio', width: 130 },{ text: 'Sintomas', datafield: 'Sintomas', width: 120 },{ text: 'Loc', datafield: 'Localidad', width: 40, cellsrenderer: cellsRendererZona },{ text: 'SE', datafield: 'SexoEdad', width: 40 },{text: 'ColGr', datafield: 'ColorGrado', hidden:true},{text: 'ColZona', datafield: 'ColorZona',hidden:true},{ text: 'Mov', datafield: 'Movil', width: 35 },{text: 'Fecha', datafield: 'Fecha', width: 70 },{ text: 'Lleg', datafield: 'HoraLlegada', width: 40 },{ text: 'Paciente', datafield: 'Paciente', width: 200 }];
    }
    function setMoviles() {
    sourceIncidentes ={
    datatype: "json",
    datafields: [{ name: 'Movil' },{ name: 'Situacion'}, {name: 'ColorMovil'}, {name: 'ColorSituacion'},{name: 'Localidad'}],
    url: 'qryMoviles.php'
    };
    columnas = [{ text: 'Mov', datafield: 'Movil', width: 40 },{ text: 'Sit', datafield: 'Situacion', width: 40},{text: 'Loc', width:60, datafield: 'Localidad'},{ text: 'ColorMovil', hidden:true, datafield: 'ColorMovil', width: 40 },{ text: 'ColorSituacion', datafield: 'ColorSituacion', hidden:true, width: 130}]
    }
    $('#jqxdropdownlist').on('select', function (event) {
    var args = event.args;
    if (args) {
    var index = args.index;
    refreshDataInc(index);
    }
    });
    });

    when i change the state of my dropdownlist, first time it works fine. But when i want to return to my “predeterminated” columns and data, the columns aren’t “recreated”. Doing some alerts i’m seeing thats data returns well, but i dont know the issue about the columns.. thanks

Viewing 2 posts - 1 through 2 (of 2 total)