View | Details | Raw Unified | Return to bug 6427
Collapse All | Expand All

(-)a/members/account.pl (-4 / +9 lines)
Lines 49-55 my $borrowernumber = $cgi->param('borrowernumber'); Link Here
49
49
50
my $borrower = GetMember( 'borrowernumber' => $borrowernumber );
50
my $borrower = GetMember( 'borrowernumber' => $borrowernumber );
51
51
52
my $schema =  Koha::Database->new()->schema();
52
my $schema = Koha::Database->new()->schema();
53
53
54
my %params;
54
my %params;
55
$params{-not} = { amount_outstanding => '0' } unless $show_all;
55
$params{-not} = { amount_outstanding => '0' } unless $show_all;
Lines 58-64 my @debits = $schema->resultset('AccountDebit')->search( Link Here
58
        'me.borrowernumber' => $borrowernumber,
58
        'me.borrowernumber' => $borrowernumber,
59
        %params,
59
        %params,
60
    },
60
    },
61
    { prefetch            => { account_offsets => 'credit' } }
61
    {
62
        prefetch => { account_offsets => 'credit' },
63
        order_by => { -desc           => 'me.created_on' }
64
    }
62
);
65
);
63
66
64
%params = ();
67
%params = ();
Lines 68-74 my @credits = $schema->resultset('AccountCredit')->search( Link Here
68
        'me.borrowernumber' => $borrowernumber,
71
        'me.borrowernumber' => $borrowernumber,
69
        %params,
72
        %params,
70
    },
73
    },
71
    { prefetch            => { account_offsets => 'debit' } }
74
    {
75
        prefetch => { account_offsets => 'debit' },
76
        order_by => { -desc           => 'me.created_on' }
77
    }
72
);
78
);
73
79
74
$template->param(
80
$template->param(
75
- 

Return to bug 6427