PDA

View Full Version : How to get the count of coulmns checkbox clicked in grid filter? And..hide few coulum



kislay.kishore
8 May 2012, 1:25 AM
Hi,
I have a scenario, in which on default load I should only allow 3 coulumn to be displayed out of, lets say 7 coulmns. However, when I click on the header to select the coulmns it should allow me to view all 7 coulmns but allow to select only 3 coulumns, any of 3 of 7.


Can anyone help, how to go about this?
Thanks!

vietits
8 May 2012, 2:36 AM
Try this:


Ext.onReady(function() {


Ext.define('Company', {
extend: 'Ext.data.Model',
fields: [
{name: 'company'},
{name: 'price', type: 'float', convert: null, defaultValue: undefined},
{name: 'change', type: 'float', convert: null, defaultValue: undefined},
{name: 'pctChange', type: 'float', convert: null, defaultValue: undefined},
{name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia', defaultValue: undefined}
],
idProperty: 'company'
});


// sample static data for the store
var myData = [
['3m Co', 71.72, 0.02, 0.03, '9/1 12:00am'],
['Alcoa Inc', 29.01, 0.42, 1.47, '9/1 12:00am'],
['Altria Group Inc', 83.81, 0.28, 0.34, '9/1 12:00am'],
['American Express Company', 52.55, 0.01, 0.02, '9/1 12:00am'],
['American International Group, Inc.', 64.13, 0.31, 0.49, '9/1 12:00am'],
['AT&T Inc.', 31.61, -0.48, -1.54, '9/1 12:00am'],
['Boeing Co.', 75.43, 0.53, 0.71, '9/1 12:00am'],
['Caterpillar Inc.', 67.27, 0.92, 1.39, '9/1 12:00am'],
['Citigroup, Inc.', 49.37, 0.02, 0.04, '9/1 12:00am'],
['E.I. du Pont de Nemours and Company', 40.48, 0.51, 1.28, '9/1 12:00am'],
['Exxon Mobil Corp', 68.1, -0.43, -0.64, '9/1 12:00am'],
['General Electric Company', 34.14, -0.08, -0.23, '9/1 12:00am'],
['General Motors Corporation', 30.27, 1.09, 3.74, '9/1 12:00am'],
['Hewlett-Packard Co.', 36.53, -0.03, -0.08, '9/1 12:00am'],
['Honeywell Intl Inc', 38.77, 0.05, 0.13, '9/1 12:00am'],
['Intel Corporation', 19.88, 0.31, 1.58, '9/1 12:00am'],
['International Business Machines', 81.41, 0.44, 0.54, '9/1 12:00am'],
['Johnson & Johnson', 64.72, 0.06, 0.09, '9/1 12:00am'],
['JP Morgan & Chase & Co', 45.73, 0.07, 0.15, '9/1 12:00am'],
['McDonald\'s Corporation', 36.76, 0.86, 2.40, '9/1 12:00am'],
['Merck & Co., Inc.', 40.96, 0.41, 1.01, '9/1 12:00am'],
['Microsoft Corporation', 25.84, 0.14, 0.54, '9/1 12:00am'],
['Pfizer Inc', 27.96, 0.4, 1.45, '9/1 12:00am'],
['The Coca-Cola Company', 45.07, 0.26, 0.58, '9/1 12:00am'],
['The Home Depot, Inc.', 34.64, 0.35, 1.02, '9/1 12:00am'],
['The Procter & Gamble Company', 61.91, 0.01, 0.02, '9/1 12:00am'],
['United Technologies Corporation', 63.26, 0.55, 0.88, '9/1 12:00am'],
['Verizon Communications', 35.57, 0.39, 1.11, '9/1 12:00am'],
['Wal-Mart Stores, Inc.', 45.45, 0.73, 1.63, '9/1 12:00am']
];


// create the data store
var store = Ext.create('Ext.data.Store', {
model: 'Company',
data: myData
});


// create the Grid
var grid = Ext.create('Ext.grid.Panel', {
store: store,
stateful: true,
collapsible: true,
multiSelect: true,
stateId: 'stateGrid',
height: 350,
width: 600,
title: 'Array Grid',
renderTo: 'grid-example',
viewConfig: {
stripeRows: true,
enableTextSelection: true
},
columns: {
onColumnCheckChange: function(checkItem, checked) {
var count = 0;
if(checked){
var items = checkItem.parentMenu.items;
items.each(function(item){
if(item.checked) count++;
if(count > 3 ) return false;
});
if(count > 3){
checkItem.setChecked(false);
}
}
if(!checked || count < 4){
var header = Ext.getCmp(checkItem.headerId);
header[checked ? 'show' : 'hide']();
}
},
items: [{
text : 'Company',
flex : 1,
sortable : false,
dataIndex: 'company'
},{
text : 'Price',
width : 75,
sortable : true,
renderer : 'usMoney',
dataIndex: 'price'
},{
text : 'Change',
width : 75,
sortable : true,
dataIndex: 'change',
hidden : true
},{
text : '% Change',
width : 75,
sortable : true,
dataIndex: 'pctChange',
hidden : true
},{
text : 'Last Updated',
width : 85,
sortable : true,
renderer : Ext.util.Format.dateRenderer('m/d/Y'),
dataIndex: 'lastChange'
}]
}
});
});

kislay.kishore
9 May 2012, 12:27 AM
Thanks for your reply! Will try this code.

kislay.kishore
9 May 2012, 1:34 AM
Hi!

I tried on extJs4 and it worked fine. Thanks again!

However, it does not work on extJs2.3. I need to make it work on extjs2.3.

Further, I tried to look into the docs for "onColumnCheckChange", both in extjs4 and extjs2.x. However, coudnt find anything related in either of them. Please advise.

vietits
9 May 2012, 4:35 PM
Yes, this is a hack applied for Ext 4 only.

kislay.kishore
9 May 2012, 11:17 PM
After doing some more analysis on ext-all-debug for extjs 2.3, I found the code responsible for handling the click on header's context menu is as below. It goes to "default" section when I check a menu item to select a column.


// private
handleHdMenuClick : function(item){
var index = this.hdCtxIndex;
var cm = this.cm, ds = this.ds;
switch(item.id){
case "asc":
ds.sort(cm.getDataIndex(index), "ASC");
break;
case "desc":
ds.sort(cm.getDataIndex(index), "DESC");
break;
default:

//alert("I m here!!");
index = cm.getIndexById(item.id.substr(4));
if(index != -1){
if(item.checked && cm.getColumnsBy(this.isHideableColumn, this).length <= 1){
this.onDenyColumnHide();
return false;
}
cm.setHidden(index, item.checked);
}
}
return true;
},



Can I do some changes here, to get problem solved? I tried few things..but didnt get success..

kislay.kishore
14 May 2012, 3:48 AM
Can anyone help with this please?

kislay.kishore
23 Aug 2012, 5:20 AM
changed the code in the defualt section :



default:
index = cm.getIndexById(item.id.substr(4));
if(index != -1){
//start
var checkedFlag = false;
var itemText = item.text ;
var count = 0;
var items = this.colMenu.items;
items.each(function(item){

if(item.checked){

count++;

if(itemText == item.text){
checkedFlag = true;
}

}



});
if(count >= 3 && checkedFlag == false ){
item.setChecked(false, true);
alert("You Have reached the maximum selections, 3 columns. Please deselect and select again.");
return false;
}

else if(count <= 3 && checkedFlag == true){

if(item.checked && cm.getColumnsBy(this.isHideableColumn, this).length <= 1){
this.onDenyColumnHide();
return false;
}
cm.setHidden(index, item.checked);

}else{

if(item.checked && cm.getColumnsBy(this.isHideableColumn, this).length <= 1){
this.onDenyColumnHide();
return false;
}
cm.setHidden(index, item.checked);
}
//end




After doing some more analysis on ext-all-debug for extjs 2.3, I found the code responsible for handling the click on header's context menu is as below. It goes to "default" section when I check a menu item to select a column.


// private
handleHdMenuClick : function(item){
var index = this.hdCtxIndex;
var cm = this.cm, ds = this.ds;
switch(item.id){
case "asc":
ds.sort(cm.getDataIndex(index), "ASC");
break;
case "desc":
ds.sort(cm.getDataIndex(index), "DESC");
break;
default:

//alert("I m here!!");
index = cm.getIndexById(item.id.substr(4));
if(index != -1){
if(item.checked && cm.getColumnsBy(this.isHideableColumn, this).length <= 1){
this.onDenyColumnHide();
return false;
}
cm.setHidden(index, item.checked);
}
}
return true;
},



Can I do some changes here, to get problem solved? I tried few things..but didnt get success..