Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Help PLEASE with grandtotal / userData !!!
15/09/2011
08:14
Avatar
slykiwi
Australia
Member
Members
Forum Posts: 10
Member Since:
15/09/2011
sp_UserOfflineSmall Offline

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

16/09/2011
07:08
Avatar
slykiwi
Australia
Member
Members
Forum Posts: 10
Member Since:
15/09/2011
sp_UserOfflineSmall Offline

Anyone.....anyone at all??? Hello!!

I was thinking it was due to my serialized JSON name:value returned which in the example above is "userData":[["BuysNo",5.0]]

I have now altered my array so I'm returning this "userData":[{"BUYSNO":100.0}]  but I am still having no luck.

16/09/2011
10:45
Avatar
OlegK
Germany
Member
Members
Forum Posts: 1255
Member Since:
10/08/2009
sp_UserOfflineSmall Offline

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 

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information