From 4a61e9c1689b8f9825b00368630d631558fb9bf7 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Wed, 24 Sep 2014 17:16:48 +0200
Subject: [PATCH] Bug 12988: Update table footer with the visible rows -
 budgets

On the budget list view, the total was not updated.
With this patch, the footer (totals) will be updated on filtering rows.

Test plan:
To test with both CurrencyFormat pref values.
1/ Go on the budget list view
2/ Verify the totals are correct.
3/ Filter the table using the filter input and verify the totals are
updated with the rows shown
4/ Hide/Show inactive budgets and verify the totals are still corrects.

Signed-off-by: Paola Rossi <paola.rossi@cineca.it>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Works as described.

Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
---
 .../prog/en/modules/admin/aqbudgets.tt        | 23 ++++++++++++-------
 1 file changed, 15 insertions(+), 8 deletions(-)

diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/aqbudgets.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/aqbudgets.tt
index b97d0d8b7d..5da1b50bec 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/aqbudgets.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/aqbudgets.tt
@@ -153,6 +153,8 @@ var MSG_PARENT_BENEATH_BUDGET = "- " + _("New budget-parent is beneath budget")
 //<![CDATA[
     //
     $(document).ready(function() {
+
+
         var oTable = $("#budgeth").dataTable($.extend(true, {}, dataTablesDefaults, {
             "fnDrawCallback": function ( oSettings ) {
                 if ( oSettings.aiDisplay.length == 0 )
@@ -180,6 +182,10 @@ var MSG_PARENT_BENEATH_BUDGET = "- " + _("New budget-parent is beneath budget")
                     }
                 }
             },
+            "footerCallback": function ( row, data, start, end, display ) {
+                var api = this.api(), data;
+                footer_column_sum( api, [ 4, 6, 8, 10 ], 2 );
+            },
             "aoColumnDefs": [
                 { "bVisible": false, "aTargets": [ 0, 1 ] },
                 { "bSortable": false, "aTargets": ["_all"] }
@@ -214,6 +220,7 @@ var MSG_PARENT_BENEATH_BUDGET = "- " + _("New budget-parent is beneath budget")
           });
           $("#hide_inactive").click();
         [% END %]
+        oTable.fnAddFilters("filter", 750);
 
         $("#filterbutton").click(function() {
             $("#fundfilters").slideToggle(0);
@@ -321,35 +328,35 @@ var MSG_PARENT_BENEATH_BUDGET = "- " + _("New budget-parent is beneath budget")
       [% IF budget.budget_parent_id %]
         <span class="child_fund_amount">[% budget.budget_amount | $Price %]</span>
       [% ELSE %]
-        [% budget.budget_amount | $Price %]
+        <span class="total_amount">[% budget.budget_amount | $Price %]</span>
       [% END %]
     </td>
     <td class="data">
       [% IF budget.budget_parent_id %]
         <span class="child_fund_amount">[% budget.budget_ordered | $Price %]</span>
       [% ELSE %]
-        [% budget.budget_ordered | $Price %]
+        <span class="total_amount">[% budget.budget_ordered | $Price %]</span>
       [% END %]
     </td>
     <td class="data">
       [% IF budget.budget_parent_id %]
         <span class="child_fund_amount">[% budget.total_ordered | $Price %]</span>
       [% ELSE %]
-        [% budget.total_ordered | $Price %]
+        <span class="total_amount">[% budget.total_ordered | $Price %]</span>
       [% END %]
     </td>
     <td class="data">
       [% IF budget.budget_parent_id %]
         <span class="child_fund_amount">[% budget.budget_spent | $Price %]</span>
       [% ELSE %]
-        [% budget.budget_spent | $Price %]
+        <span class="total_amount">[% budget.budget_spent | $Price %]</span>
       [% END %]
     </td>
     <td class="data">
       [% IF budget.budget_parent_id %]
         <span class="child_fund_amount">[% budget.total_spent | $Price %]</span>
       [% ELSE %]
-        [% budget.total_spent | $Price %]
+        <span class="total_amount">[% budget.total_spent | $Price %]</span>
       [% END %]
     </td>
 
@@ -365,11 +372,11 @@ var MSG_PARENT_BENEATH_BUDGET = "- " + _("New budget-parent is beneath budget")
             [% END %]
          [% ELSE %]
             [% IF (value > 0) %]
-                <span style="color: green;">
+                <span class="total_amount" style="color: green;">
             [% ELSIF (value < 0) %]
-                <span style="color: red;">
+                <span class="total_amount" style="color: red;">
             [% ELSE %]
-                <span>
+                <span class="totalamount">
             [% END %]
         [% END %]
             [% value | $Price %]
-- 
2.39.5