3 # This file is part of Koha
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 2 of the License, or (at your option) any later
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.
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.
21 script used to create a routing list for a serial subscription
22 In this instance it is in fact a setting up of a list of reserves for the item
23 where the hierarchical order can be changed on the fly and a routing list can be
45 my $subscriptionid = $query->param('subscriptionid');
46 my $serialseq = $query->param('serialseq');
47 my $routingid = $query->param('routingid');
48 my $borrowernumber = $query->param('borrowernumber');
49 my $notes = $query->param('notes');
50 my $op = $query->param('op') || q{};
51 my $date_selected = $query->param('date_selected');
52 $date_selected ||= q{};
53 my $dbh = C4::Context->dbh;
56 delroutingmember($routingid,$subscriptionid);
60 addroutingmember($borrowernumber,$subscriptionid);
63 my $sth = $dbh->prepare('UPDATE serial SET routingnotes = ? WHERE subscriptionid = ?');
64 $sth->execute($notes,$subscriptionid);
65 my $urldate = URI::Escape::uri_escape_utf8($date_selected);
66 print $query->redirect("routing-preview.pl?subscriptionid=$subscriptionid&issue=$urldate");
69 my @routinglist = getroutinglist($subscriptionid);
70 my $subs = GetSubscription($subscriptionid);
71 my ($count,@serials) = GetSerials($subscriptionid);
72 my $serialdates = GetLatestSerials($subscriptionid,$count);
75 foreach my $dateseq (@{$serialdates}) {
77 $d->{publisheddate} = $dateseq->{publisheddate};
78 $d->{serialseq} = $dateseq->{serialseq};
79 $d->{serialid} = $dateseq->{serialid};
80 if($date_selected eq $dateseq->{serialid}){
81 $d->{selected} = ' selected';
88 my ($template, $loggedinuser, $cookie)
89 = get_template_and_user({template_name => 'serials/routing.tt',
93 flagsrequired => {serials => 'routing'},
98 for my $routing ( @routinglist ) {
99 my $member=GetMember('borrowernumber' => $routing->{borrowernumber});
100 $member->{location} = $member->{branchcode};
101 if ($member->{firstname} ) {
102 $member->{name} = $member->{firstname} . q| |;
105 $member->{name} = q{};
107 if ($member->{surname} ) {
108 $member->{name} .= $member->{surname};
110 $member->{routingid}=$routing->{routingid} || q{};
111 $member->{ranking} = $routing->{ranking} || q{};
113 push(@{$member_loop}, $member);
117 title => $subs->{bibliotitle},
118 subscriptionid => $subscriptionid,
119 memberloop => $member_loop,
122 routingnotes => $serials[0]->{'routingnotes'},
123 hasRouting => check_routing($subscriptionid),
124 (uc(C4::Context->preference("marcflavour"))) => 1
128 output_html_with_http_headers $query, $cookie, $template->output;