Bug 13069 - (follow-up) Enable sort by title to ignore articles
[koha.git] / members / routing-lists.pl
1 #!/usr/bin/perl
2
3 # Copyright 2012 Prosentient Systems
4 #
5 # This file is part of Koha.
6 #
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
10 # version.
11 #
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15 #
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
20 use strict;
21 #use warnings; FIXME - Bug 2505
22 use CGI qw ( -utf8 );
23 use C4::Output;
24 use C4::Auth qw/:DEFAULT get_session/;
25 use C4::Branch; # GetBranches
26 use C4::Members;
27 use C4::Members::Attributes qw(GetBorrowerAttributes);
28 use C4::Context;
29 use C4::Serials;
30 use CGI::Session;
31
32 my $query = new CGI;
33
34 my $sessionID = $query->cookie("CGISESSID") ;
35 my $session = get_session($sessionID);
36
37 # branch are now defined by the userenv
38 # but first we have to check if someone has tried to change them
39
40 my $branch = $query->param('branch');
41 if ($branch){
42     # update our session so the userenv is updated
43     $session->param('branch', $branch);
44     $session->param('branchname', GetBranchName($branch));
45 }
46
47 my ( $template, $loggedinuser, $cookie ) = get_template_and_user (
48     {
49         template_name   => 'members/routing-lists.tt',
50         query           => $query,
51         type            => "intranet",
52         authnotrequired => 0,
53         flagsrequired   => { circulate => 'circulate_remaining_permissions' },
54     }
55 );
56
57 my $branches = GetBranches();
58
59 my $findborrower = $query->param('findborrower');
60 $findborrower =~ s|,| |g;
61
62 my $borrowernumber = $query->param('borrowernumber');
63
64 $branch  = C4::Context->userenv->{'branch'};
65
66 # get the borrower information.....
67 my $borrower;
68 if ($borrowernumber) {
69     $borrower = GetMemberDetails( $borrowernumber, 0 );
70 }
71
72
73 ##################################################################################
74 # BUILD HTML
75 # I'm trying to show the title of subscriptions where the borrowernumber is attached via a routing list
76
77 if ($borrowernumber) {
78 # new op dev
79   my $count;
80   my @borrowerSubscriptions;
81   ($count, @borrowerSubscriptions) = GetSubscriptionsFromBorrower($borrowernumber );
82   my @subscripLoop;
83
84     foreach my $num_res (@borrowerSubscriptions) {
85         my %getSubscrip;
86         $getSubscrip{subscriptionid}    = $num_res->{'subscriptionid'};
87         $getSubscrip{title}                     = $num_res->{'title'};
88         $getSubscrip{borrowernumber}            = $num_res->{'borrowernumber'};
89         push( @subscripLoop, \%getSubscrip );
90     }
91
92     $template->param(
93         countSubscrip => scalar @subscripLoop,
94         subscripLoop  => \@subscripLoop,
95         routinglistview => 1
96     );
97
98     $template->param( adultborrower => 1 ) if ( $borrower->{'category_type'} eq 'A' );
99 }
100
101 ##################################################################################
102
103
104 # Computes full borrower address
105 my $roadtype = C4::Koha::GetAuthorisedValueByCode( 'ROADTYPE', $borrower->{streettype} );
106 my $address = $borrower->{'streetnumber'} . " $roadtype " . $borrower->{'address'};
107
108 $template->param(
109
110     findborrower      => $findborrower,
111     borrower          => $borrower,
112     borrowernumber    => $borrowernumber,
113     branch            => $branch,
114     branchname        => GetBranchName($borrower->{'branchcode'}),
115     title             => $borrower->{'title'},
116     initials          => $borrower->{'initials'},
117     firstname         => $borrower->{'firstname'},
118     surname           => $borrower->{'surname'},
119     othernames        => $borrower->{'othernames'},
120     categorycode      => $borrower->{'categorycode'},
121     categoryname      => $borrower->{description},
122     address           => $address,
123     address2          => $borrower->{'address2'},
124     phone             => $borrower->{'phone'},
125     phonepro          => $borrower->{'phonepro'},
126     mobile            => $borrower->{'mobile'},
127     email             => $borrower->{'email'},
128     emailpro          => $borrower->{'emailpro'},
129     borrowernotes     => $borrower->{'borrowernotes'},
130     city              => $borrower->{'city'},
131     state             => $borrower->{'state'},
132     zipcode           => $borrower->{'zipcode'},
133     country           => $borrower->{'country'},
134     cardnumber        => $borrower->{'cardnumber'},
135     RoutingSerials => C4::Context->preference('RoutingSerials'),
136 );
137
138 if (C4::Context->preference('ExtendedPatronAttributes')) {
139     my $attributes = GetBorrowerAttributes($borrowernumber);
140     $template->param(
141         ExtendedPatronAttributes => 1,
142         extendedattributes => $attributes
143     );
144 }
145
146 my ($picture, $dberror) = GetPatronImage($borrower->{'borrowernumber'});
147 $template->param( picture => 1 ) if $picture;
148
149 output_html_with_http_headers $query, $cookie, $template->output;