Guriddo » Topic: Multiselect Summary

Multiselect Summary

Guriddo
multiselect summary
Multiselect Summary

Tagged: multiselect summary

This topic has 4 replies, 2 voices, and was last updated 10 years, 2 months ago by guriddo.support.

Creator

Topic
March 28, 2016 at 9:59 am #125035

ariadrianto
Participant

Hi All,

Please help me with multiselect summary demo. What I mean, when I select with multiselect, some column summarize on footer.

Maybe if we see the demo : http://www.guriddo.net/demo/demos/jqgrid/selection/multiselect/default.php

I’d like to sum on Freight and place it on footer only when selected.

Thank you,

Ari
Creator

Topic

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

Author

Replies

March 29, 2016 at 11:00 am #125036

guriddo.support

Participant

Hello,

Basically a onSelectRow can be used. On this event you should grab the selected ids and loop to find the sum of the selected item of freigt.

Below is a working code (of the same example). You can optimize the code very weel. It is just idea how this can be realized.


...
$grid-&gt;setGridOptions(array(
    &quot;rowNum&quot;=&gt;10,
    &quot;sortname&quot;=&gt;&quot;OrderID&quot;,
    &quot;rowList&quot;=&gt;array(10,20,30),
    &quot;footerrow&quot;=&gt;true,
    &quot;multiselect&quot;=&gt;true));

$onselect = &lt;&lt;&lt; ONSELECT
function(rowid, selected) {
	var sar = $(this).jqGrid(&#039;getGridParam&#039;, &#039;selarrrow&#039;);
	function sumCols(arr, grid, sumCol) { // sumCol is the index of Freight
		var j, len = arr.length, sum = 0, v;
		for(j=0; j&lt; len; j++) {
			v = parseFloat( $(&quot;#&quot;+arr[j],grid).find(&#039;td:eq(&#039;+sumCol+&#039;)&#039;).html());
			if(v != null) {
				sum += v;
			}
		}
		return sum;
	}
	var pdata=[];
	pdata[&#039;Freight&#039;] = sumCols( sar, this, 4 );
	if(!isNaN(pdata[&#039;Freight&#039;])){
		$(this).jqGrid(&#039;footerData&#039;, &#039;set&#039;, pdata, true);
	}
}
ONSELECT;

$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $onselect);
...

...

$grid->setGridOptions(array(

"rowNum"=>10,

"sortname"=>"OrderID",

"rowList"=>array(10,20,30),

"footerrow"=>true,

"multiselect"=>true));

$onselect = <<< ONSELECT

function(rowid, selected) {

var sar = $(this).jqGrid('getGridParam', 'selarrrow');

function sumCols(arr, grid, sumCol) { // sumCol is the index of Freight

var j, len = arr.length, sum = 0, v;

for(j=0; j< len; j++) {

v = parseFloat( $("#"+arr[j],grid).find('td:eq('+sumCol+')').html());

if(v != null) {

sum += v;

}

return sum;

}

var pdata=[];

pdata['Freight'] = sumCols( sar, this, 4 );

if(!isNaN(pdata['Freight'])){

$(this).jqGrid('footerData', 'set', pdata, true);

}

ONSELECT;

$grid->setGridEvent('onSelectRow', $onselect);

...

Please let us know if this resolved your problem.

Thank you

Kind Regards,
Will

This reply was modified 10 years, 2 months ago by guriddo.support.

Guriddo Support Team

April 1, 2016 at 7:54 am #125052

ariadrianto

Participant

Hi,

Thanks for the answer…

I don’t know why, but it’s not working … I modify like this :



$selectorder = &lt;&lt;&lt;ORDER
function(rowid, selected)
{
if(rowid != null) {
var gridrow = jQuery(&quot;#grid&quot;).jqGrid(&#039;getRowData&#039;,rowid);

sar = jQuery(&#039;#grid&#039;).jqGrid(&#039;getGridParam&#039;,&#039;selarrrow&#039;);

totFreight += parseFloat(gridrow.Freight);

var pdata=[];
pdata[&#039;Freight&#039;] = totFreight;
if(!isNaN(pdata[&#039;Freight&#039;])){
$(this).jqGrid(&#039;footerData&#039;, &#039;set&#039;, pdata, true);
}
}

}
ORDER;
$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $selectorder);

$selectorder = <<<ORDER

function(rowid, selected)

{

if(rowid != null) {

var gridrow = jQuery("#grid").jqGrid('getRowData',rowid);

sar = jQuery('#grid').jqGrid('getGridParam','selarrrow');

totFreight += parseFloat(gridrow.Freight);

var pdata=[];

pdata['Freight'] = totFreight;

if(!isNaN(pdata['Freight'])){

$(this).jqGrid('footerData', 'set', pdata, true);

}

ORDER;

$grid->setGridEvent('onSelectRow', $selectorder);

It’s working now. But Thank you very much…

Ari

April 1, 2016 at 8:05 am #125053

ariadrianto

Participant

sorry.. my mistaken…

I should delete this row :

sar = jQuery(‘#grid’).jqGrid(‘getGridParam’,’selarrrow’);

This reply was modified 10 years, 2 months ago by ariadrianto. Reason: wrong copy paste source

April 2, 2016 at 9:41 am #125059

guriddo.support

Participant

Hello,

Glad to hear that it is working as per your requirements.

Kind Regards,

Will

Guriddo Support Team

Author

Replies

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

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Multiselect Summary

Search Forum

Recent Replies

Forum Statistics

UserOnline