how to get the sum of a field called amount currently visible on the list view

Question

Hi All,

I want to get the sum of the a field called amount to be visible on the top of the list view as Total

These should only be for the records which are visible on the sugar.

For example

there is an option to load more record at the bottom on the list view,when we click on it we get the other records and the sum of their amount has also to get calculated and placed on the list view.

Can any one please give a start up for this

Regards Tevfik Tümer

Sidhu

sidhu sidhu · Accepted Answer

Hi All, Finally had some luck In /custom/modules/Ver/clients/base/views/list-headerpane/list-headerpane.php copied from parent files added the following in the fields array array( 'name' => 'total',//added by me ), Then custom/modules/Ver/clients/base/views/recordlist/recordlist.js added ({ extendsFrom: 'RecordlistView', initialize: function (options) { app.view.invokeParent(this, {type: 'view', name: 'recordlist', method: 'initialize', args:[options]}); this.on('render', this._setRowFields, this); }, _setRowFields:function() { var count=0; var accArray = new Array(); $('input[type=checkbox]:visible').each(function() { count++; var acc=$(this).closest('tr').attr('name'); if(acc != null) { acc=acc.split("_"); accArray.push(acc[2]); } }); $.ajax({ url: "updateSum.php", async:false, type:"POST", data:{accArray:accArray}, success: function (data) { //console.log('sum is '+data); $('[data-fieldname="total"]').html("Total:R "+data+""); }, }); }, }) And the job is done Regards Sidhu