Skip to main content

JavaScript [ExtJs3]: Loading complex data in EditorGridPanel with Dynamic Combo Box

Grid is always an important widget of any project and many time we find a situation where we have to render the complex data in grid panel.
And another use-case of dynamic combo box where the combo data comes with the record.

To handle a complex object we have to define a new data type.
Ext.data.Types.COMPLEXDATA = {
 convert: function(v){
  v.toString = function(){
   return v.display;
  };
  return v;
 },
 sortType: Ext.data.SortTypes.none,
 type: 'complexdata'
};

This extended class will take care of dynamic combo box loading. It’s a plugin class so after creating the object we have to add this to “plugins” property of grid panel.
Ext.ux.ComplexDataColumn = Ext.extend(Ext.grid.Column, {
 dataField: 'options',
 displayField: 'display',
 valueField: 'id',
 
    constructor: function (c) {        
        c.editor = this.buildComboEditor();
        Ext.ux.ComplexDataColumn.superclass.constructor.call(this, c);
    }, 
 
 init: function(grid){
  grid.on('beforeedit', function(e){  
   this.editor.store.loadData(e.record.get(this.dataField));
  }, this);
 },
 
 buildComboEditor: function(){
  return new Ext.form.ComboBox({
   typeAhead: true,
   triggerAction: 'all',
   lazyRender:true,
   mode: 'local',
   store: new Ext.data.JsonStore({
    fields: [this.displayField, this.valueField],
    data: []
   }),
   displayField: this.displayField
  });
 }
});

Complex data which we want to load in our EditorGridPanel
var myData = [
 ['3m Co', 71.72, 0.02,  0.03,  
  {id: 1, display: 'option11'}, 
  [ 
   {id:1, display: 'option11'},
   {id:2, display: 'option12'},
   {id:3, display: 'option13'}
  ]
 ],
 ['Alcoa Inc', 29.01, 0.42,  1.47,  
  {id: 1, display: 'option21'}, 
  [
   {id:1, display: 'option21'},
   {id:2, display: 'option22'},
   {id:3, display: 'option23'}
  ]
 ],
 ['Altria Group Inc', 83.81, 0.28,  0.34,  
  {id: 1, display: 'option31'}, 
  [
   {id:1, display: 'option31'},
   {id:2, display: 'option32'},
   {id:3, display: 'option33'}
  ]
 ],
 ['American Express Company', 52.55, 0.01,  0.02,  
  {id: 1, display: 'option41'}, 
  [
   {id:1, display: 'option41'},
   {id:2, display: 'option42'},
   {id:3, display: 'option43'}
  ]
 ],
 ['American International Group, Inc.', 64.13, 0.31,  0.49,  
  {id: 1, display: 'option51'}, 
  [
   {id:1, display: 'option51'},
   {id:2, display: 'option52'},
   {id:3, display: 'option53'}
  ]
 ],
 ['AT&T Inc.', 31.61, -0.48, -1.54, 
  {id: 1, display: 'option61'}, 
  [
   {id:1, display: 'option61'},
   {id:2, display: 'option62'},
   {id:3, display: 'option63'}
  ]
 ],
 ['Boeing Co.', 75.43, 0.53,  0.71,  
  {id: 1, display: 'option71'}, 
  [
   {id:1, display: 'option71'},
   {id:2, display: 'option72'},
   {id:3, display: 'option73'}
  ]
 ],
 ['Caterpillar Inc.', 67.27, 0.92,  1.39,  
  {id: 1, display: 'option81'}, 
  [
   {id:1, display: 'option81'},
   {id:2, display: 'option82'},
   {id:3, display: 'option83'}
  ]
 ],
 ['Citigroup, Inc.', 49.37, 0.02,  0.04,  
  {id: 1, display: 'option91'}, 
  [
   {id:1, display: 'option91'},
   {id:2, display: 'option92'},
   {id:3, display: 'option93'}
  ]
 ]
];


Define the store for the grid and define the respective data type. Here we will assign the custom type to complex data field
//Define a store for grid 
var store = new Ext.data.ArrayStore({
 fields: [
    {name: 'company'},
    {name: 'price',      type: 'float'},
    {name: 'change',     type: 'float'},
    {name: 'pctChange',  type: 'float'},
    {name: 'complexData',type: Ext.data.Types.COMPLEXDATA},
    {name: 'options'}
 ]
});

Editor grid panel
//create column for complex data
var complexColumn = new Ext.ux.ComplexDataColumn({
 header   : 'Complex Data', 
 width    : 85, 
 sortable : true, 
 dataIndex: 'complexData'
});

// create the Grid
var grid = new Ext.grid.EditorGridPanel({
 store: store,
 plugins: [complexColumn],
 columns: [
  {id:'company', header: 'Company', width: 160, sortable: true, dataIndex: 'company'},
  {header: 'Price', width: 75, sortable: true, dataIndex: 'price'},
  {header: 'Change', width: 75, sortable: true, dataIndex: 'change'},
  {header: '% Change', width: 75, sortable: true, dataIndex: 'pctChange'},
  complexColumn
  
 ],
 stripeRows: true,
 autoExpandColumn: 'company',
 height: 350,
 width: 600,
 title: 'Array Grid',
 clicksToEdit: 1
});

Comments

Popular posts from this blog

ERROR: Ignored call to 'alert()'. The document is sandboxed, and the 'allow-modals' keyword is not set.

Recently I found this issue while writing code snippet in "JSFiddle". And after searching, found this was happening because of new feature added in "Chrome 46+". But at the same time Chrome doesn't have support for "allow-modals" property in "sandbox" attribute.

Chromium issue for above behavior:
https://codereview.chromium.org/1126253007

To make it work you have to add "allow-scripts allow-modals" in "sandbox" attribute, and use "window.alert" instead of "alert".



<!-- Sandbox frame will execute javascript and show modal dialogs --> <iframe sandbox="allow-scripts allow-modals" src="iframe.html"> </iframe>


Feature added: Block modal dialog inside a sandboxed iframe.
Link: https://www.chromestatus.com/feature/4747009953103872

Feature working Demo page:
https://googlechrome.github.io/samples/block-modal-dialogs-sandboxed-iframe/index.html



JavaScript [ExtJs3]: EditorGridPanel Read-Only (dynamically)

Many time we face the scenerio where we have to make the editor grid read-only dynamically.


Ext.override(Ext.ux.grid.CheckColumn, { editable: true, onMouseDown: function (e, t) { if (Ext.fly(t).hasClass(this.createId())) { e.stopEvent(); var me = this, grid = me.grid, view = grid.getView(), index = view.findRowIndex(t), colindex = view.findCellIndex(t), record = grid.store.getAt(index); if (!grid.isReadOnly && grid.colModel.isCellEditable(colindex, index)) { record.set(me.dataIndex, !record.data[me.dataIndex]); } } } }); var grid = new Ext.grid.EditorGridPanel({ ... isReadOnly: true, //set to flag to make check column readonly ... }); //to make other column readonly grid.on('beforeedit', function () { return false; });

JavaScript [ExtJs3]: Total “Record” count in filtered store

There is two way to get record count from the Store
store.getTotalCount() This function depend on server response value. For accuracy of the value, property shell if return by the server.

Property name for the diff. reader:
totalProperty for JsonReader, totalRecords for XmlReaderstore.getCount() Will return you the number of record from the store.
Or if you have filter on the store, it will give you the number of filtered record.
But if you want to get the total number of record regardless filtering, Then it will be like this

var totalRecords = store.snapshot ? store.snapshot.length : store.getCount();
“snapshot” is the variable in “Store” which hold the actual data in case if you have applied a filter.