Grid Search Plugin

[jsakalos]

You cannot have one instance of a grid (or any other component) simultaneously displayed in two different places.

[chinnapandu]

Creating two different grid panel instances for showing the grid in different places is the only solution

[juferoto]

My problem is that plugin work very well of mode local but it's using mode remote not working

var dsBase = new Ext.data.Store({
        reader: new Ext.data.JsonReader({
        root: 'respuesta',
        totalProperty: 'total',
        id:'numError',
        fields:
        [
            {name: 'numError', mapping: 'numError'},
            {name: 'descriPro', mapping: 'descriPro'},
            {name: 'numLis', mapping: 'numLis'},
            {name: 'numSol', mapping: 'numSol'}
        ]
        }),
        proxy: new Ext.data.HttpProxy({
        url: '<?echo URL_APIS?>base/Error'
        }),
        remoteSort: true
    });
    
    var expansion = new Ext.grid.RowExpander({
        tpl : new Ext.Template(
        '<br /><table border="1" cellpadding=4 cellspacing=0><tr>',
        '<td width="34%"><p>&nbsp;</p><p align="l"><b>Descripci&oacute;n del Problema:</b></p><p>&nbsp;</p></td>',
        '<td width="66%"><p>&nbsp;</p><p align="justify">{descriPro}</p><p>&nbsp;</p></td>',
        '</tr></table>'
        )
    });
    
    var colModelErr = new Ext.grid.ColumnModel([
        expansion,
        {id:'numErr', header: "Número del Problema", width: 52, sortable: true, dataIndex: 'numError', renderer:function(val){ return ('# '+val) }},
        {header: "Descripción del Problema", width: 210, sortable: true, dataIndex: 'descriPro', renderer:function(val){ return (val+'...') }},
        {header: "Número de Soluciones", width: 55, sortable: true, dataIndex: 'numSol', renderer:function(val){ return (val+' Sol.') }}
    ]);
    
    var buscarErr = new Ext.ux.grid.Search({
        mode:'remote', 
        position:top,
        width:260,
        autoFocus:true,
                showSelectAll:true
    })

    var panelResul = new Ext.grid.GridPanel({
        id: 'buscaInfo',
        border:false,
        stateful:false,
        title:'Resultados de la Busqueda',
        bodyStyle:{ background: '#ffffff' },
        height: 447,
        hidden: false,
        autoScroll:true,
        ds: dsBase,
        cm: colModelErr,
        sm: new Ext.grid.RowSelectionModel({ singleSelect: true }),
        enableColLock:false,
        clicksToEdit:1,
        viewConfig:
        {
          forceFit:true
        },
        tbar: [
        {
              text: 'Ver Soluciones',
              id:'Solucion',
              tooltip: 'Opción para ver las soluciones de un error en específico',
              handler: function()
              {
                realizar(this.id);
              },
            iconCls:'libreta'
        },'-',{
              text: 'Ver PDF',
              id:'PDF',
              tooltip: 'Opción para ver el pdf de un error específico',
              handler: function()
              {
                realizar(this.id);
              },
              iconCls:'pdf'
        }
        ],
        bbar: new Ext.PagingToolbar({
        store: dsBase,
        pageSize: 1,
        displayInfo: true,
        displayMsg: 'Resultados {0} - {1} of {2}',
        emptyMsg: "Ningun resultado disponible"
        }),
        plugins:
        [
          buscarErr, expansion
        ]
    });
    
    dsBase.load({params:{start:0, limit:1}});

 public function executeError()
  {
      $conexion = Propel::getConnection();
      $resulDatosTotal  = $conexion->executeQuery('select count(*) from apis_error');
      $resulDatosTotal->next();
      $numeroDatosTotal = $resulDatosTotal->getInt("count");
      $consulta = 'SELECT * FROM apis_error';
      $inicio = (integer) ($this->getRequestParameter('start'));
      $fin = (integer) ($this->getRequestParameter('limit'));
      $limite = $consulta." LIMIT ".$fin." OFFSET ".$inicio;
      $sentencia = $conexion->prepareStatement($limite);
      $result = $sentencia->executeQuery();
      $pos = 0;
      $datos;
      while($result->next())
      {
      $datos[$pos]['numError'] = $result->get("no_error");
      $datos[$pos]['descriPro']  = $result->get("descrip_prob");
      $datos[$pos]['numLis']  = $result->get("no_listado");
      $sentencia = $conexion->prepareStatement("select count(*) from apis_listado_asignado where no_listado_as = '".$datos[$pos]['numLis']."'");
      $resultCone = $sentencia->executeQuery();
      $resultCone->next();
      $datos[$pos]['numSol']  = $resultCone->getInt("count");
      $pos++;
      }
      $conversion = json_encode($datos);
      return $this->renderText('({"total":"'.$numeroDatosTotal.'","respuesta":'.$conversion.'})');
  
  } 

Please, help me

[jsakalos]

I'd suspect the server side code as long as the plugin sends query and fields variables.

[juferoto]

I'd suspect the server side code as long as the plugin sends query and fields variables.

How can i make?

[jsakalos]

There is an example server side code at http://gridsearch.extjs.eu/

[stefanorg]

Hi saky,
first of all i want to thank you for your work thanks to that i've learned a lot about developing with ext. THANKS

There is a version 3.x of this plugin?

[jsakalos]

The current version works OOTB in Ext 3.0. I've tested just briefly so if you have any issues post back.

[stefanorg]

ok it works but i've some issue with the alignment, the search field is always on the right after or before the status info:

i've this code:

 Ext.apply(this,{
                store:jsonStore
                ,columns: this.columns
                ,sm:  sm
                ,bbar: new Ext.PagingToolbar({
                        pageSize:this.defPageSize
                        ,displayInfo:true
                        ,store:jsonStore
                })
                ,loadMask:{
                        msg:this.loadingWaitMsg
                        ,removeMask:true
                        ,store:jsonStore
                }
                ,plugins:new Ext.ux.grid.Search({
                                iconCls:'icon-zoom'
                                ,position:'bottom'
                                ,readonlyIndexes:['company']
                                ,disableIndexes:['email']
                                ,minChars:2
                                ,autoFocus:true
                                //,align:'rigth'
                        })
        });

i can't be able to put the search field after the refresh button of the paging toolbar, i'm doing something wrong with the configuration?

The current version works OOTB in Ext 3.0. I've tested just briefly so if you have any issues post back.

[jsakalos]

Yes, it behaves different between 2.x and 3.x. No idea why (yet).