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 |
- |
|
|