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