members/summary-print.pl

   1 #!/usr/bin/perl
   2
   3 # This file is part of Koha.
   4 #
   5 # Koha is free software; you can redistribute it and/or modify it under the
   6 # terms of the GNU General Public License as published by the Free Software
   7 # Foundation; either version 3 of the License, or (at your option) any later
   8 # version.
   9 #
  10 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  11 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  12 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  13 #
  14 # You should have received a copy of the GNU General Public License along
  15 # with Koha; if not, write to the Free Software Foundation, Inc.,
  16 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  17
  18 use Modern::Perl;
  19
  20 use CGI;
  21
  22 use C4::Auth;
  23 use C4::Output;
  24 use C4::Members;
  25 use C4::Koha qw( getitemtypeinfo );
  26 use C4::Circulation qw( GetIssuingCharges );
  27 use C4::Reserves;
  28 use C4::Items;
  29 use Koha::Holds;
  30
  31 my $input          = CGI->new;
  32 my $borrowernumber = $input->param('borrowernumber');
  33
  34 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
  35     {
  36         template_name   => "members/moremember-print.tt",
  37         query           => $input,
  38         type            => "intranet",
  39         authnotrequired => 0,
  40         flagsrequired   => { circulate => "circulate_remaining_permissions" },
  41         debug           => 1,
  42     }
  43 );
  44
  45 my $data = GetMember( 'borrowernumber' => $borrowernumber );
  46
  47 my ( $total, $accts, $numaccts ) = GetMemberAccountRecords($borrowernumber);
  48 foreach my $accountline (@$accts) {
  49     $accountline->{amount} = sprintf( '%.2f', $accountline->{amount} )
  50         if ( $accountline->{amount} ) ;
  51     $accountline->{amountoutstanding} = sprintf( '%.2f', $accountline->{amountoutstanding} )
  52         if ( $accountline->{amountoutstanding} );
  53
  54     if (   $accountline->{accounttype} ne 'F'
  55         && $accountline->{accounttype} ne 'FU' )
  56     {
  57         $accountline->{printtitle} = 1;
  58     }
  59 }
  60
  61 our $totalprice = 0;
  62 my $total_format = '';
  63 $total_format = sprintf( "%.2f", $total ) if ($total);
  64
  65 my $holds_rs = Koha::Holds->search(
  66     { borrowernumber => $borrowernumber },
  67 );
  68
  69 $template->param(
  70     %$data,
  71
  72     borrowernumber => $borrowernumber,
  73
  74     accounts => $accts,
  75     totaldue => $total_format,
  76
  77     issues     => build_issue_data( GetPendingIssues($borrowernumber) ),
  78     totalprice => $totalprice,
  79
  80     reserves => build_reserve_data( $holds_rs ),
  81 );
  82
  83 output_html_with_http_headers $input, $cookie, $template->output;
  84
  85 sub build_issue_data {
  86     my $issues = shift;
  87
  88     my $return = [];
  89
  90     my $today = DateTime->now( time_zone => C4::Context->tz );
  91     $today->truncate( to => 'day' );
  92
  93     foreach my $issue ( @{$issues} ) {
  94
  95         my %row = %{$issue};
  96         $totalprice += $issue->{replacementprice}
  97             if ( $issue->{replacementprice} );
  98
  99         #find the charge for an item
 100         my ( $charge, $itemtype ) =
 101           GetIssuingCharges( $issue->{itemnumber}, $borrowernumber );
 102
 103         my $itemtypeinfo = getitemtypeinfo($itemtype);
 104         $row{'itemtype_description'} = $itemtypeinfo->{description};
 105
 106         $row{'charge'} = sprintf( "%.2f", $charge );
 107
 108         $row{date_due} = $row{date_due_sql};
 109
 110         push( @{$return}, \%row );
 111     }
 112
 113     @{$return} = sort { $a->{date_due} eq $b->{date_due} } @{$return};
 114
 115     return $return;
 116
 117 }
 118
 119 sub build_reserve_data {
 120     my $reserves = shift;
 121
 122     my $return = [];
 123
 124     my $today = DateTime->now( time_zone => C4::Context->tz );
 125     $today->truncate( to => 'day' );
 126
 127     while ( my $reserve = $reserves->next() ) {
 128
 129         my $row = {
 130             title          => $reserve->biblio()->title(),
 131             author         => $reserve->biblio()->author(),
 132             reservedate    => $reserve->reservedate(),
 133             expirationdate => $reserve->expirationdate(),
 134             waiting_at     => $reserve->branch()->branchname(),
 135         };
 136
 137         push( @{$return}, $row );
 138     }
 139
 140     @{$return} = sort { $a->{reservedate} <=> $b->{reservedate} } @{$return};
 141
 142     return $return;
 143 }