Forum


08:14

15/09/2011

Hi,
I am new to jquery and jqGrid. I am using jqGrid with Coldfusion 8 is the grid is displaying my data and summary footer totals perfectly. What I cant figure out is how to get the grand totals in the bottom footer.
Here is my script:
<script type="text/javascript">
$("document").ready(function() {
var lastsel2
jQuery("#list2").jqGrid({
url:'cfc/contacts.cfc?method=getContacts',
mtype : "post",
editurl: "saveddata.cfm",
width:"auto",
height:"auto",
datatype: "json",
colNames:['WEEK NO.','DAY','DATE', 'BUYS VALUE','BuysNo'],
colModel:[
{name:'weekNum',index:'weekNum', sortable: false, width:80 },
{name:'dayName',index:'dayName', sortable: false, width:80 },
{name:'TransDate',index:'TransDate', sortable: false, width:80},
{name:'Buys',index:'Buys', sortable: false, width:100, editable: true, summaryType:'sum', formatter:'currency', formatoptions:{decimalSeparator:".", thousandsSeparator: ",", decimalPlaces: 2, prefix: "$ "}, align:"right"},
{name:'BuysNo',index:'BuysNo', sortable: false, width:100, editable: true, summaryType:'sum', align:"right"}
],
rowNum:31,
//rowList:[10,20,30],
pager: '#pager2',
sortname: 'TransDate',
viewrecords: true,
sortorder: "asc",
caption:"BROWNS PLAINS: MARGINS DETAILS",
grouping:true,
groupingView : {
groupField : ['weekNum'],
groupDataSorted : true,
groupSummary : [true],
groupCollapse : true,
showSummaryOnHide: true,
groupText : ['<b> Week # {0} ({1} days)</b>'],
groupColumnShow : [false] //Hides the grouping column
},
footerrow: true,
userDataOnFooter: true,
onSelectRow: function(id){
if(id && id!==lastsel2){
jQuery('#list2').restoreRow(lastsel2);
jQuery('#list2').editRow(id,true);
lastsel2=id;
}
}
})
});
</script>
And here is my CF code that creates the userData array before I SerializeJSON it:
<cfset tmp.userData = arraynew(2)>
<cfset tmp.userData[1][1] = 'BuysNo'>
<cfset tmp.userData[1][2] = 5>
When I dump theSerialized JSON data on the grid page I get this (you can see the userData array at the very end after my grid data:
{"rows":[{"ID":"August, 01 2011 00:00:00","cell":[32,"Monday","1 August",334.5000,6]},{"ID":"August, 02 2011 00:00:00","cell":[32,"Tuesday","2 August",157.0000,6]},{"ID":"August, 03 2011 00:00:00","cell":[32,"Wednesday","3 August",225.0000,5]},{"ID":"August, 04 2011 00:00:00","cell":[32,"Thursday","4 August",120.5000,2]},{"ID":"August, 05 2011 00:00:00","cell":[32,"Friday","5 August",4154.7700,6]},{"ID":"August, 06 2011 00:00:00","cell":[32,"Saturday","6 August",0.0000,0]},{"ID":"August, 07 2011 00:00:00","cell":[33,"Sunday","7 August",0.0000,0]},{"ID":"August, 08 2011 00:00:00","cell":[33,"Monday","8 August",50.0000,4]},{"ID":"August, 09 2011 00:00:00","cell":[33,"Tuesday","9 August",766.8000,2]},{"ID":"August, 10 2011 00:00:00","cell":[33,"Wednesday","10 August",860.0000,7]},{"ID":"August, 11 2011 00:00:00","cell":[33,"Thursday","11 August",70.0000,3]},{"ID":"August, 12 2011 00:00:00","cell":[33,"Friday","12 August",139.0000,5]},{"ID":"August, 13 2011 00:00:00","cell":[33,"Saturday","13 August",0.0000,0]},{"ID":"August, 14 2011 00:00:00","cell":[34,"Sunday","14 August",0.0000,0]},{"ID":"August, 15 2011 00:00:00","cell":[34,"Monday","15 August",472.0000,10]},{"ID":"August, 16 2011 00:00:00","cell":[34,"Tuesday","16 August",207.5000,3]},{"ID":"August, 17 2011 00:00:00","cell":[34,"Wednesday","17 August",0.0000,0]},{"ID":"August, 18 2011 00:00:00","cell":[34,"Thursday","18 August",135.0000,2]},{"ID":"August, 19 2011 00:00:00","cell":[34,"Friday","19 August",383.5000,3]},{"ID":"August, 20 2011 00:00:00","cell":[34,"Saturday","20 August",0.0000,0]},{"ID":"August, 21 2011 00:00:00","cell":[35,"Sunday","21 August",0.0000,0]},{"ID":"August, 22 2011 00:00:00","cell":[35,"Monday","22 August",665.0000,5]},{"ID":"August, 23 2011 00:00:00","cell":[35,"Tuesday","23 August",300.0000,4]},{"ID":"August, 24 2011 00:00:00","cell":[35,"Wednesday","24 August",1195.0000,5]},{"ID":"August, 25 2011 00:00:00","cell":[35,"Thursday","25 August",780.0000,3]},{"ID":"August, 26 2011 00:00:00","cell":[35,"Friday","26 August",674.0000,4]},{"ID":"August, 27 2011 00:00:00","cell":[35,"Saturday","27 August",10.0000,1]},{"ID":"August, 28 2011 00:00:00","cell":[36,"Sunday","28 August",0.0000,0]},{"ID":"August, 29 2011 00:00:00","cell":[36,"Monday","29 August",267.0000,5]},{"ID":"August, 30 2011 00:00:00","cell":[36,"Tuesday","30 August",274.0000,5]},{"ID":"August, 31 2011 00:00:00","cell":[36,"Wednesday","31 August",109.0000,7]}],"page":1.0,"total":4.0,"userData":[["BuysNo",5.0]],"records":31}
Can someone please tell me what I am doing wrong and why the grand total will not display ???
Thanks,
Aaron
10:45

10/08/2009

You use userData in wrong format frarting with the property name (userData instead of userdata) and using additional array (the []). Look at the answer and this one.
Best regards
Oleg
Most Users Ever Online: 715
Currently Online:
58 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66