Skip to content

Instantly share code, notes, and snippets.

@reachkamrul
Last active January 6, 2023 06:17
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save reachkamrul/11e6e60d4aa113abe81586367cc27b77 to your computer and use it in GitHub Desktop.
Save reachkamrul/11e6e60d4aa113abe81586367cc27b77 to your computer and use it in GitHub Desktop.
// Math summation on columns
var myClasses= "column_one, column_two, column_three"; //give your columns key, you can use multiple by using comma
var totalText = "Total: "; // you can change the 'Total' text here
if(!$table.find('tfoot').length){
jQuery("<tfoot></tfoot>").appendTo($table);
}
function getSum(classes)
{
var sum = 0;
var index = 0;
$table.find("."+classes+"").each(function() {
var val = $.trim( $(this).text() );
if ( val ) {
val = parseFloat( val.replace( /^$/, "" ) );
sum += !isNaN( val ) ? val : 0;
}
});
index += jQuery("."+classes+"").index()+1;
return [sum, index];
}
getSum();
function renderTfoot(){
var counts = $table.find(".footable-header th").length;
var num = parseInt(counts);
var container = $("<tr class='final_result' />");
var notThis = [];
jQuery('.footable-header th').each(function(){
if(jQuery(this).css('display') == 'none'){
var index = parseInt(jQuery(this).index(),10) + 1;
notThis.push(index);
}
})
for(var i = 1; i <= num; i++) {
if ($.inArray(i, notThis) != -1)
{
i;
}
else{
$('<td />', {
id: "id" + i,
name: "name" + i
}).appendTo(container);}
}
$('tfoot').prepend(container);
}
function setSumAmount() {
var substr = myClasses.split(',');
$.each(substr , function(index, val) {
var singleClass = "ninja_clmn_nm_"+val.trim();
$table.find('tfoot .final_result td#id'+getSum(singleClass)[1]+'').html(totalText + getSum(singleClass)[0] );
function responisveChanges(){
if(jQuery('th.'+singleClass).css('display') == 'none'){
$table.find('tfoot .final_result td:nth-child('+getSum(singleClass)[1]+')').hide();
}
else{
$table.find('tfoot .final_result td:nth-child('+getSum(singleClass)[1]+')').show();
}
}
responisveChanges();
jQuery(window).on('resize', function(){
responisveChanges();
});
});
}
setSumAmount(renderTfoot(), getSum());
$table.on('after.ft.filtering', function() {
setSumAmount();
});
$table.on('after.ft.paging', function() {
setSumAmount();
});
@bluepixeldesign147
Copy link

Hi, great code i'm using it for Ninja Table Press Pro, Is there a way i can change the code slightly to calculate the column using time ie using multiples of 60 to show total time calculation?

@masamavi
Copy link

masamavi commented Jan 6, 2023

Hi, any advice on how to limit the decimal numbers, please?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment