<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Help PLEASE with grandtotal / userData !!!</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>OlegK on Help PLEASE with grandtotal / userData !!!</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata#p24638</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata#p24638</guid>
        	        	<description><![CDATA[<p>You use&#160;userData&#160;in wrong format frarting with the property name (userData&#160;instead of&#160;userdata) and using additional array (the []). Look at&#160;<a href="http://stackoverflow.com/questions/3848815/how-to-read-userdata-in-jqgrid/3849513#3849513" target="_blank">the answer</a>&#160;and&#160;<a href="http://stackoverflow.com/questions/3128837/json-and-jqgrid-what-is-userdata/3128934#3128934" target="_blank">this one</a>.</p>
<p>Best regards<br />Oleg&#160;</p>
]]></description>
        	        	<pubDate>Fri, 16 Sep 2011 10:45:00 +0300</pubDate>
        </item>
        <item>
        	<title>slykiwi on Help PLEASE with grandtotal / userData !!!</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata#p24637</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata#p24637</guid>
        	        	<description><![CDATA[<p>Anyone.....anyone at all??? Hello!!</p>
</p>
<p>I was thinking it was due to my serialized JSON name:value returned which in the example above is <span style="color: #ff0000;">"userData":[["BuysNo",5.0]]</span></p>
</p>
<p><span style="color: #ff0000;"><span style="color: #000000;">I have now altered my array so I&#39;m returning this </span></span><span style="color: #ff0000;">"userData":[{"BUYSNO":100.0}]</span><span style="color: #ff0000;"><span style="color: #ff0000;">&#160;</span> <span style="color: #000000;">but I am still having no luck.</span><br /></span></p>
]]></description>
        	        	<pubDate>Fri, 16 Sep 2011 07:08:19 +0300</pubDate>
        </item>
        <item>
        	<title>slykiwi on Help PLEASE with grandtotal / userData !!!</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata#p24618</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/help-please-with-grandtotal-userdata#p24618</guid>
        	        	<description><![CDATA[<p>Hi,</p>
</p>
<p>I am new to jquery and jqGrid.&#160; I am using jqGrid with Coldfusion 8 is the grid is displaying my data and summary footer totals perfectly.&#160; What I cant figure out is how to get the grand totals in the bottom footer.&#160;</p>
</p>
<p>Here is my script:</p>
<p><span style="color: #000000;">&#60;script type="text/javascript"&#62;<br />&#160;&#160; &#160;$("document").ready(function() {<br />&#160;&#160; &#160;var lastsel2<br />&#160;&#160; &#160;&#160;&#160; &#160;jQuery("#list2").jqGrid({<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;url:&#39;cfc/contacts.cfc?method=getContacts&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;mtype : "post",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;editurl: "saveddata.cfm",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;width:"auto",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;height:"auto",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;datatype: "json",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;colNames:[&#39;WEEK NO.&#39;,&#39;DAY&#39;,&#39;DATE&#39;, &#39;BUYS VALUE&#39;,&#39;BuysNo&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;colModel:[<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;weekNum&#39;,index:&#39;weekNum&#39;, sortable: false, width:80 },<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;dayName&#39;,index:&#39;dayName&#39;, sortable: false, width:80 }, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;TransDate&#39;,index:&#39;TransDate&#39;, sortable: false, width:80},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;Buys&#39;,index:&#39;Buys&#39;, sortable: false, width:100, editable: true, summaryType:&#39;sum&#39;, formatter:&#39;currency&#39;, formatoptions:{decimalSeparator:".", thousandsSeparator: ",", decimalPlaces: 2, prefix: "$ "}, align:"right"},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;BuysNo&#39;,index:&#39;BuysNo&#39;, sortable: false, width:100, editable: true, summaryType:&#39;sum&#39;, align:"right"}<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;rowNum:31,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;//rowList:[10,20,30],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;pager: &#39;#pager2&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;sortname: &#39;TransDate&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;viewrecords: true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;sortorder: "asc",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;caption:"BROWNS PLAINS: MARGINS DETAILS",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;grouping:true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupingView : { <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupField : [&#39;weekNum&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupDataSorted : true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupSummary : [true],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupCollapse : true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;showSummaryOnHide: true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupText : [&#39;&#60;b&#62; Week # {0} ({1} days)&#60;/b&#62;&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupColumnShow : [false] //Hides the grouping column<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;<span style="color: #ff0000;">footerrow: true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;userDataOnFooter: true,</span><br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;onSelectRow: function(id){<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160; if(id &#38;&#38; id!==lastsel2){<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;jQuery(&#39;#list2&#39;).restoreRow(lastsel2);<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;jQuery(&#39;#list2&#39;).editRow(id,true);<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;lastsel2=id;<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160; }<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;}<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;})<br />&#160;&#160; &#160;&#160;&#160;&#160; });&#160;&#160; &#160;<br />&#60;/script&#62;</span></p>
</p>
<p><span style="color: #ff0000;"><span style="color: #000000;">And here is my CF code that creates the userData array before I SerializeJSON it:</span></span></p>
<p><span style="color: #ff0000;"><em><br /></em></span></p>
<p><span style="color: #000000;">&#160;&#160;&#160; &#60;cfset tmp.userData = arraynew(2)&#62;<br />&#160;&#160;&#160; &#60;cfset tmp.userData[1][1] = &#39;BuysNo&#39;&#62;<br />&#160;&#160;&#160; &#60;cfset tmp.userData[1][2] = 5&#62;</span></p>
</p>
<p><span style="color: #ff0000;"><span style="color: #000000;">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:</span></span></p>
<p><span style="color: #ff0000;"><span style="color: #000000;"><br /></span></span></p>
<p>{"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,<span style="color: #ff0000;">"userData":[["BuysNo",5.0]]</span>,"records":31}</p>
</p>
<p><span style="color: #ff0000;"><span style="color: #000000;">Can someone please tell me what I am doing wrong and why the grand total will not display ???</span></span></p>
</p>
<p><span style="color: #ff0000;"><span style="color: #000000;">Thanks,</span></span></p>
</p>
<p><span style="color: #ff0000;"><span style="color: #000000;">Aaron<br /></span></span></p>
]]></description>
        	        	<pubDate>Thu, 15 Sep 2011 08:14:08 +0300</pubDate>
        </item>
</channel>
</rss>