From d18793ad0f8c58ad82fc11fe891eef9f6d81e061 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 3 Mar 2015 03:16:53 -0800 Subject: [PATCH] Bug 6427 [QA Followup] - Fix accounts table default sorting --- members/account.pl | 12 +++++++++--- 1 files changed, 9 insertions(+), 3 deletions(-) diff --git a/members/account.pl b/members/account.pl index 5092491..6aa995b 100755 --- a/members/account.pl +++ b/members/account.pl @@ -49,7 +49,7 @@ my $borrowernumber = $cgi->param('borrowernumber'); my $borrower = GetMember( 'borrowernumber' => $borrowernumber ); -my $schema = Koha::Database->new()->schema(); +my $schema = Koha::Database->new()->schema(); my %params; $params{-not} = { amount_outstanding => '0' } unless $show_all; @@ -58,7 +58,10 @@ my @debits = $schema->resultset('AccountDebit')->search( 'me.borrowernumber' => $borrowernumber, %params, }, - { prefetch => { account_offsets => 'credit' } } + { + prefetch => { account_offsets => 'credit' }, + order_by => { -desc => 'me.created_on' } + } ); %params = (); @@ -68,7 +71,10 @@ my @credits = $schema->resultset('AccountCredit')->search( 'me.borrowernumber' => $borrowernumber, %params, }, - { prefetch => { account_offsets => 'debit' } } + { + prefetch => { account_offsets => 'debit' }, + order_by => { -desc => 'me.created_on' } + } ); $template->param( -- 1.7.2.5