i'm trying to use :

but  I cant seem to get the userdata value from json data

for example   i wish to change tamount in the demo to cur_amount.. in my apps...

& next question instead of using the toolbar menthod, can userDataOnFooter be style with css also..  cause i wanted it to stand out from other data... example would be nice..

tq

It is a simple - from where comes this

$responce->userdata['cur_amount'] = $amttot;
$responce->userdata['int_reference'] = 'Totals:';

Then try to recalculate $amttot for the entry column.

Best Regards

Tony

or is it inside somewhere else.. which part of my php??

.. or can u show me some sample.. the problem also persist when i try "true scrolling row".. or am i doing it wrongly.. ??

sorry for asking too muchh..

In userdata you should put the total calculations and not per page. Change your server side script to do this

Best Regards

Tony

I manage to get the footerrow data working.. but my problems is i can only view the total for the active grid.. meaning:

currently i hv six(6) pages of data.. and each page will only show the total for each page…

how can i show the GRAND total for the whole six page to be viewed as the total in every page??

which part of the code should i edit...

this is the constructing json data code..

$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    
    $amttot += $row[cur_amount];

    
    $responce->rows[$i]['id']=$row[int_claimdetailid];
    $responce->rows[$i]['cell']=array($row[int_claimdetailid],$row[txt_item],$row[int_claimid],$row[dt_date],$row[int_reference],$row[cur_amount],$row[int_siteid],$row[int_accid]);
    $i++;
}
$responce->userdata['cur_amount'] = $amttot;
$responce->userdata['int_reference'] = 'Totals:';

help please anyone…

newbie..

Thank You very much !!!!
Now I have my grid with the total at the footerrow !!

Really, Thank You a lot !!!

Andrea

http://gyazo.com/d5bf7889b1fb673e9c83d7541407cb4c.png

Here you can view what my grid looks like and it should give you a good idea on what to do next with the information I gave you which is specific to my grid =)

Enjoy!

Where is the value for $piesum;

Just test this way:

Regards

Tony

<script type="text/javascript">
jQuery(document).ready(function(){
  jQuery("#list").jqGrid({
    url:'example.php',
    datatype: 'json',
    mtype: 'GET',
    colNames: ['cod - desc', 'pie', 'p.v. ie', 'fattura vendita', 'p', 'i', 'data fattura', 'note'],
    colModel :[
      {name:'cod', index:'cod', sortable: false, resizable: false},
      {name:'pie', index:'pie', sortable: false, resizable: false},
      {name:'pvie', index:'pvie', sortable: false, resizable: false},
      {name:'fattura_vendita', index:'fattura_vendita', sortable: true, resizable: false},
      {name:'p', index:'p', sortable: false, resizable: false},
      {name:'v', index:'v', sortable: false, resizable: false},
      {name:'data_fattura', index:'data_fattura', sortable: true, resizable: false},
      {name:'note', index:'note', sortable: false, resizable: false}
    ],

    footerrow: true,
    userDataOnFooter: true,
    pager: '#pager',
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'data_fattura',
    sortorder: 'desc',
    viewrecords: true,
    autowidth: true,
    height: '100%',
    caption: 'La mia tabella'
  });
});
jQuery("#list").footerData('set',{cod:'Total',pie:sum});
</script>

and this is the file example.php:

<?php
//include the information needed for the connection to MySQL data base server.
// we store here username, database and password
include("_conn.db.inc.php");
 
// to the url parameter are added 4 parameters as described in colModel
// we should get these parameters to construct the needed query
// Since we specify in the options of the grid that we will use a GET method
// we should use the appropriate command to obtain the parameters.
// In our case this is $_GET. If we specify that we want to use post
// we should use $_POST. Maybe the better way is to use $_REQUEST, which
// contain both the GET and POST variables. For more information refer to php documentation.
// Get the requested page. By default grid sets this to 1.
$page = $_GET['page'];
 
// get how many rows we want to have into the grid - rowNum parameter in the grid
$limit = $_GET['rows'];
 
// get index row - i.e. user click to sort. At first time sortname parameter -
// after that the index from colModel
$sidx = $_GET['sidx'];
 
// sorting order - at first time sortorder
$sord = $_GET['sord'];
 
// if we not pass at first time index use the first column for the index or what you want
if(!$sidx) $sidx =1;
 
// calculate the number of rows for the query. We need this for paging the result
$sql="SELECT COUNT(*) AS count FROM articoli";
$result = mysql_query($sql,$db) or die(mysql_error());
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];
 
// calculate the total pages for the query
if( $count > 0 && $limit > 0) {
              $total_pages = ceil($count/$limit);
} else {
              $total_pages = 0;
}
 
// if for some reasons the requested page is greater than the total
// set the requested page to total page
if ($page > $total_pages) $page=$total_pages;
 
// calculate the starting position of the rows
$start = $limit*$page - $limit;
 
// if for some reasons start position is negative set it to 0
// typical case is that the user type 0 for the requested page
if($start <0) $start = 0;
 
// the actual query for the grid data
$SQL = "SELECT * , date_format(data_fattura, '%d-%m-%Y') AS data_fattura_l FROM articoli ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn't execute query.".mysql_error());
 
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$responce->userdata['pie'] = $piesum;
$i=0;

while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $responce->rows[$i]['id']=$row[id];
    $responce->rows[$i]['cell']=array("$row[codice] - $row[descrizione]",
                                      $row[prezzoie],
                                      $row[prezzoiev],
                                      $row[fattura_vendita],
                                      $row[id_pagato],
                                      $row[id_incassato],
                                      $row[data_fattura_l],
                                      $row[note]);
    $i++;
}
echo json_encode($responce);
?>

but the total isn't print...
Where is the error?

Thanks for all !

Andrea

use like below

jQuery(”#list”).footerData('set',{cod:'Total',pie:sum});  -- where sum is a variable holding the total

<?php

....

...

// the actual query for the grid data
$SQL = "SELECT * , date_format(data_fattura, '%d-%m-%Y') AS data_fattura_l FROM articoli ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn't execute query.".mysql_error());
 
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$responce->userdata['pie'] = $piesum;
$i=0;

while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $responce->rows[$i]['id']=$row[id];
    $responce->rows[$i]['cell']=array("$row[codice] - $row[descrizione]",
                                      $row[prezzoie],
                                      $row[prezzoiev],
                                      $row[fattura_vendita],
                                      $row[id_pagato],
                                      $row[id_incassato],
                                      $row[data_fattura_l],
                                      $row[note]);
    $i++;
}
echo json_encode($responce);

?>

It doesn't work... sorry but I'm a news user can you explain me?

thanks a lot!

Andrea

$responce->userdata['pie'] = $piesum;

json_encode($responce);

jQuery(document).ready(function(){
  jQuery("#list").jqGrid({
    url:'example.php',
    datatype: 'json',
    mtype: 'GET',
    colNames: ['cod', 'pie', 'p.v. ie', 'fattura vendita', 'p', 'i', 'data fattura', 'note'],
    colModel :[
      {name:'cod', index:'cod', sortable: false, resizable: false},
      {name:'pie', index:'pie', sortable: false, resizable: false},
      {name:'pvie', index:'pvie', sortable: false, resizable: false},
      {name:'fattura_vendita', index:'fattura_vendita', sortable: true, resizable: false},
      {name:'p', index:'p', sortable: false, resizable: false},
      {name:'v', index:'v', sortable: false, resizable: false},
      {name:'data_fattura', index:'data_fattura', sortable: true, resizable: false},
      {name:'note', index:'note', sortable: false, resizable: false}
    ],
    footerrow: true,
    userDataOnFooter: true,
    pager: '#pager',
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'data_fattura',
    sortorder: 'desc',
    viewrecords: true,
    autowidth: true,
    height: '100%',
    caption: 'La mia tabella'
  });
});

I want to have the SUM of the column "pie": the word "total" at the footer of "cod" column, and the SUM of "pie" at the footer of "pie" column

How i have to use the method footerData ??

jQuery("#list").jqGrid('footerData', set, ........);

Sorry for my english and thank You every one for help!!

Andrea