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

Application Design Notes

Don’t be afraid to write your own code, but be absolutely sure you need to Don't reinvent the wheel Learn more about your libraries and take full advantage  Date time calculation is hard ( leap second ,  leap year ), use trusted library  js-joda ,  momentJs ,  joda (java) Simple is better than perfect (nearly) every time If you can deliver a sub-optimal solution (that solves the problem but has known limitation) in a week instead of a full featured one in a month DO, IT Simple system are Easy to reason about  Easy to debug Easy to refactor Easy to learn Simple doesn't mean you skip good engineering, but you can use duct tape. Build things the right way from the start, refactoring is hard and expensive Security Manage and store passwords securely Telemetry Common retrofitting "grunt work" Internationalization + localization Web Content Accessibility Factoring and styling HTML UI Adding unit test to an existing codebase LOG LOG LOG Log, but do it right We spend lot of t

How to store user password at server!!!

Trick is, you should never store user password… never ever. Now the real question is, then how to authenticate and authorize the user with password. And answer is when user enter the password, we should encrypt the password and store the hints. So next time when user enter the password we follow the same process and compare hints, if both hints are same then password is matched, else it is wrong password. Next question will be, what kind of hints, and how to generate these hints. In simple term hints are the obfuscated and fragmented form of user password. And very important part is hints generation process, which have to be collision resistant , means there will be very less possibility to find the data which generate same hints (like Cryptographic hashing functions ). Below is the simple checklist of password hashing and storing, which you should always keep in mind. PS You're Probably Storing Passwords Incorrectly Storing Passwords - done rig