Author Topic: Filter in use  (Read 2054 times)

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Filter in use
« on: November 06, 2017, 06:41:01 pm »
I would like to execute some css modifications on column title cell when filter is in use for that column...how can I do this?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Filter in use
« Reply #1 on: November 07, 2017, 01:14:09 pm »
filter event can be used to add/remove css class to the filtered columns.

Code: [Select]
filter: function(evt, ui){
var grid = this;
this.getColModel().forEach(function(column){
var cls = (column.filter && column.filter.value !=null)? "red": "";
var $cell = grid.getCellHeader({dataIndx: column.dataIndx});
$cell[cls? 'addClass':'removeClass']("red");
column.cls = cls;

});
},


Add css rules to that class.
Code: [Select]
.pq-grid-col.red{
color: red;
}
« Last Edit: November 07, 2017, 03:12:15 pm by paramquery »

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Re: Filter in use
« Reply #2 on: November 08, 2017, 02:40:01 am »
Thanks, seems though like:

Code: [Select]
var cls = (column.filter && column.filter.value != null)? "red": "";
will trigger on multiselect filters even though no filters are set...
« Last Edit: November 08, 2017, 02:42:30 am by queensgambit9 »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Filter in use
« Reply #3 on: November 09, 2017, 10:28:35 pm »
This function seems bit lengthy but it does the job.

Code: [Select]
function hightlightFilters(){
var grid = this;
grid.getColModel().forEach(function(column){
var filter = column.filter, add = false;
if(filter){
var condition = filter.condition,
        value = filter.value,
        value2 = filter.value2;

if(condition == "range"){
if(value.length) add = true;
}
else if(condition == "between"){
if (value!=null || value2 != null) add = true;
}
else if(value != null){
add = true;
}
}

var $cell = grid.getCellHeader({dataIndx: column.dataIndx});
$cell[add? 'addClass':'removeClass']("red");
column.cls = add? "red": "";
});
}


call the above function from beforeFilter event.

Code: [Select]
beforeFilter: function(evt, ui){
setTimeout( hightlightFilters.bind(this) );
},
« Last Edit: November 09, 2017, 10:32:23 pm by paramquery »