Print Page - Filter Datagrid

Title: Filter Datagrid
Post by: NortT on December 20, 2017, 03:02:01 AM

Hello, I tried to use filter with my datagrid and I have got an error:

Code:

jquery.easyui.min.js:10816 Uncaught TypeError: $.fn.datagrid.methods[_7cc] is not a function
    at m.fn.init.$.fn.datagrid (jquery.easyui.min.js:10816)
    at HTMLDocument.<anonymous> ((index):35)
    at j (jquery.min.js:2)
    at Object.fireWith [as resolveWith] (jquery.min.js:2)
    at Function.ready (jquery.min.js:2)
    at HTMLDocument.J (jquery.min.js:2)

How can I solve this problem?

I tried to use this source codehttps://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=DataGrid%20Filter%20Row (https://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=DataGrid%20Filter%20Row) but it doesn't work in my browser.

The 35th string is

Code:

dg.datagrid('enableFilter', [{

Title: Re: Filter Datagrid
Post by: jarry on December 20, 2017, 06:48:51 AM

Please download the filter extension from https://www.jeasyui.com/extension/datagrid_filter.php

Title: Re: Filter Datagrid
Post by: NortT on December 20, 2017, 07:50:10 PM

Hi Jarry, it works, thank you!

Title: Re: Filter Datagrid
Post by: NortT on December 20, 2017, 08:45:45 PM

Hi again!
The filter works fine but I can't get all the rows from the datagrid. In total I have about 2500 rows, if I apply the filter, I can get rows appeared after I filtered the table, but I can't get all the rows. I use the following code to get the rows:

Code:

var data = $('#productTable').datagrid('getData');

Is it possible to get all the rows?

For example, I need to get the total sum in the specified column, I do it like this:

Code:

function getAllRows(){
	var data = $('#productTable').datagrid('getData');
	return data.firstRows;		
}

	var rows = getAllRows();
	var sum = 0.0;
	for(var i=0; i<rows.length; i++){
		sum += parseFloat(rows[i]['total']);
	}

The other problem is that if I need to edit a row, I recieve inside the onDblClickRow:function(index, target) index which is == 1300 for example, but I have 100 rows after I applied a filter, consequently, if I try to get editors of this row in the onBeginEdit

Code:

onBeginEdit:function(rowIndex) {
     var editors = $(this).datagrid('getEditors', rowIndex);
}

I have an error, because there is no such a row with the specified index in the table.

P.S. I use view: scrollview with my datagrid.

EasyUI Forum

General Category => EasyUI for jQuery => Topic started by: NortT on December 20, 2017, 03:02:01 AM