Datagrid Footer Rows not updating on last item delete from Datagrid [SOLVED]

[mcenal]

I've got a complicated datagrid based upon the edit grid.  The data loads from json via a database and shows up on the page.  When the json returns an empty value on page load '[]' it shows up correctly as the datagrid with no footer rows.  However if I add a record and then delete one, not only does the footer rows remain visible but also does not update its value.

I'm trying to get the datagrid to do one of the following:
reload the datagrid correctly and show properly
give me a count of the rows in the datagrid so I can find out if it is zero and kick the user over to a different page.

Code:

function destroyItem(){
	var row = $('#dg').datagrid('getSelected');
	if (row){
		$.messager.confirm('Confirm','Are you sure you want to remove this row?',function(r){
			if (r){
				var index = $('#dg').datagrid('getRowIndex',row);
				jqab = $.post('destroy_row.php',{idhz_timesheets:row.idhz_timesheets},function(){
					$('#dg').datagrid('deleteRow',index);
				});
				jqab.always(function(){
					getHours($('#userid').val());
				});
			}
                           //This is the line that is misbehaving.
			$('#dg').datagrid('reload'); 
		});
		
	}
	
}

Here's the json that is returned from the datagrid load with 1 record.  It will load [] if it is empty.

Code:

{"total":1,"rows":[{"idhz_timesheets":"211","user":"Test User","joblevel":"Foreman","isForeman":"1","isJourneyman":"0","isApprentice":"0","taskcode":"0100-Site","hours":"7.00","date":"2014-05-01","comments":"7"}],"footer":[ {},{"taskcode":"Foreman Hours :","hours":"7.00"},{"taskcode":"Journeyman Hours:","hours":"0.00"},{"taskcode":"Apprentice Hours :","hours":"0.00"},{"taskcode":"Total Hours :","hours":"7.00"}]}

[stworthy]

Notice that you are calling 'reload' method to load the datagrid. The json data returned from your server contains 'footer', this will cause the appearance of footer rows. To display only body rows, you need to remove the 'footer' from your json data.

[mcenal]

Ahh, but as I said in my post, the json returns [] which is an empty json if that last line has been deleted.  Still it doesn't delete correctly. 

Could it be my reload is called too early?  Or is the return value of [] invalid?

Or is it something deeper?

[stworthy]

When calling 'reload' method, all the data will be reloaded using the new json data returned from your server. You must make sure that the server can return correct data, including body rows and footer rows.

[mcenal]

I've tested it and from every angle it looks like the json returned is in fact [] which should empty out the datagrid but the footer rows are not updating correctly when an empty dataset is returned.  Yet, when there is no footer (on page load with empty dataset) it hides the footer rows correctly.

I basically used the code directly from the CRUD datagrid with row editing capabilities and footer rows turned on. 

[stworthy]

Please refer to this example http://jsfiddle.net/DA3kU/

[mcenal]

Okay, so the empty JSON return has to be more than just [].

See example for what I was doing.

The third case was the one that I am currently doing.  I'll switch it over to the 4th case as that seems to work correctly.

http://jsfiddle.net/DA3kU/8/

Code:

//case 3
var data3 = [];
//case 4
var data4 = {total:0,rows:[],footer:[]};

update:  Nope.  Not working right.  Darn it.

I'm trying to add the code to another case but the deletion function isn't working right.

Code:

$('btn5').click(function(){
	var row = $('#dg').datagrid('getSelected');
	var index = $('#dg').datagrid('getRowIndex',row);
	$('#dg').datagrid('deleteRow',index)	
});

See example http://jsfiddle.net/DA3kU/11/

[mcenal]

Finally found a solution that actually works.

This line deletes the entire datagrid so if it is supposed to be empty it will actually empty out.  A bit overkill but it does actually work.

Code:

$('#dg').datagrid('loadData',[]);

This line is the one I've been looking for.  It will also do the same to empty out the footer.  Also a bit overkill but again it does actually work.

Code:

$('#dg').datagrid('reloadFooter',[]);