Guriddo » Topic: How do I update the summaryrow after inline editing?

How do I update the summaryrow after inline editing?

Guriddo
inline edit, summary
How do I update the summaryrow after inline editing?

Tagged: inline edit, summary

This topic has 5 replies, 2 voices, and was last updated 9 years ago by guriddo.support.

Creator

Topic

October 18, 2016 at 1:33 pm #125603

bogdanm

Participant

I’m using a grid with inline editing as in the example at http://www.guriddo.net/demo/demos/jqgrid/editing_data/inlinecustom/default.php

Here’s my code:

$grid->setGridOptions(array(
    "hoverrows"=>false,
    "footerrow"=>true,
    "userDataOnFooter"=>true
));

$summaryrows = array("col1"=>array("col1"=>"SUM"), "col2"=>array("col2"=>"SUM"));

onselrow = <<< ONSELROW
function(rowid, selected)
{
    if(rowid && rowid !== lastSelection) {
        $("#grid").jqGrid('restoreRow', lastSelection);
        $("#grid").jqGrid('editRow', rowid, true);
        lastSelection = rowid;
    }
}
ONSELROW;

$grid->setGridEvent('ondblClickRow', $onselrow);

$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

$grid->setGridOptions(array(

"hoverrows"=>false,

"footerrow"=>true,

"userDataOnFooter"=>true

));

$summaryrows = array("col1"=>array("col1"=>"SUM"), "col2"=>array("col2"=>"SUM"));

onselrow = <<< ONSELROW

function(rowid, selected)

{

if(rowid && rowid !== lastSelection) {

$("#grid").jqGrid('restoreRow', lastSelection);

$("#grid").jqGrid('editRow', rowid, true);

lastSelection = rowid;

}

ONSELROW;

$grid->setGridEvent('ondblClickRow', $onselrow);

$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

I have set it to the ‘ondblClickRow’ event instead of ‘onSelectRow’ and it works OK, except the sums in the summaryrow are not updated after cells are edited. I need to do a manual refresh to see correct sums.
Is there a way to automatically update the sums or trigger a grid refresh after editing inline?

This topic was modified 9 years ago by bogdanm.

Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

October 19, 2016 at 11:40 am #125606

guriddo.support

Participant

Hello,

There are a lot of solutions. The easy stable way without to write a lot of code is to reload the grid (trigger(‘reloadGrid’) ) after the save is done.

For this purpose you can use the aftresavefunc in editRow method. Please look into the docs here

Kind Regards

Will

Guriddo Support Team

October 19, 2016 at 2:29 pm #125608

bogdanm

Participant

OK, you mean something like this?

$refresh = <<< REFRESH
function refreshAfterEdit() {
    jQuery("#grid").jqGrid('editRow', aftersavefunc: function(){
        jQuery("#grid").trigger("reloadGrid");
    });

};
REFRESH;

$refresh = <<< REFRESH

function refreshAfterEdit() {

jQuery("#grid").jqGrid('editRow', aftersavefunc: function(){

jQuery("#grid").trigger("reloadGrid");

});

};

REFRESH;

Do I need to use setNavEvent to run this function?
I’m sorry my javascript skills are zero 🙁

October 20, 2016 at 9:26 am #125610

guriddo.support

Participant

Hello,

The syntax is correct, but you will need to put it in dblSelect Row

$grid->setGridOptions(array(
    "hoverrows"=>false,
    "footerrow"=>true,
    "userDataOnFooter"=>true
));

$summaryrows = array("col1"=>array("col1"=>"SUM"), "col2"=>array("col2"=>"SUM"));

onselrow = <<< ONSELROW
function(rowid, selected)
{
    if(rowid && rowid !== lastSelection) {
        $("#grid").jqGrid('restoreRow', lastSelection);
        $("#grid").jqGrid('editRow', rowid, { aftersavefunc : function() {
           setTimeout( function() { $("#grid").trigger("reloadGrid"); }, 10);
        });
        lastSelection = rowid;
    }
}
ONSELROW;

$grid->setGridEvent('ondblClickRow', $onselrow);

$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

$grid->setGridOptions(array(

"hoverrows"=>false,

"footerrow"=>true,

"userDataOnFooter"=>true

));

$summaryrows = array("col1"=>array("col1"=>"SUM"), "col2"=>array("col2"=>"SUM"));

onselrow = <<< ONSELROW

function(rowid, selected)

{

if(rowid && rowid !== lastSelection) {

$("#grid").jqGrid('restoreRow', lastSelection);

$("#grid").jqGrid('editRow', rowid, { aftersavefunc : function() {

setTimeout( function() { $("#grid").trigger("reloadGrid"); }, 10);

});

lastSelection = rowid;

}

ONSELROW;

$grid->setGridEvent('ondblClickRow', $onselrow);

$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

Regards,
Will

Guriddo Support Team

October 20, 2016 at 1:05 pm #125611

bogdanm

Participant

I tried the code above and I think it’s missing something. When I double-click on a row the editing starts but there’s no way to end it (either by a save or by a cancel). The buttons for ‘save row’ and ‘cancel row editing’ do not become active, and pressing Enter does not do anything.

October 20, 2016 at 4:26 pm #125612

guriddo.support

Participant

Hello,

Sorry for the mistake.

If you use editor like NetBeans you can easy see the error.

a ” } ” is missing, Try this:

onselrow = <<< ONSELROW
function(rowid, selected)
{
    if(rowid && rowid !== lastSelection) {
        $("#grid").jqGrid('restoreRow', lastSelection);
        $("#grid").jqGrid('editRow', rowid, { aftersavefunc : function() {
           setTimeout( function() { $("#grid").trigger("reloadGrid"); }, 10); }
        });
        lastSelection = rowid;
    }
}
ONSELROW;

onselrow = <<< ONSELROW

function(rowid, selected)

{

if(rowid && rowid !== lastSelection) {

$("#grid").jqGrid('restoreRow', lastSelection);

$("#grid").jqGrid('editRow', rowid, { aftersavefunc : function() {

setTimeout( function() { $("#grid").trigger("reloadGrid"); }, 10); }

});

lastSelection = rowid;

}

ONSELROW;

Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

How do I update the summaryrow after inline editing?

Search Forum

Recent Replies

Forum Statistics

UserOnline