Using old_issues table
[koha.git] / opac / opac-serial-issues.pl
blob8fabccabc93315194ebad2aef76933b6785389b3
1 #!/usr/bin/perl
3 # Copyright 2000-2002 Katipo Communications
5 # This file is part of Koha.
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.
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.
16 # You should have received a copy of the GNU General Public License along with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA 02111-1307 USA
21 use strict;
22 use CGI;
23 use C4::Auth;
24 use C4::Koha;
25 use C4::Dates;
26 use C4::Serials;
27 use C4::Letters;
28 use C4::Output;
29 use C4::Context;
32 my $query = new CGI;
33 my $op = $query->param('op');
34 my $dbh = C4::Context->dbh;
35 my $selectview = $query->param('selectview');
36 $selectview = C4::Context->preference("SubscriptionHistory") unless $selectview;
38 my $sth;
40 # my $id;
41 my ( $template, $loggedinuser, $cookie );
42 my $biblionumber = $query->param('biblionumber');
43 if ( $selectview eq "full" ) {
44 ( $template, $loggedinuser, $cookie ) = get_template_and_user(
46 template_name => "opac-full-serial-issues.tmpl",
47 query => $query,
48 type => "opac",
49 authnotrequired => 1,
50 debug => 1,
53 my $subscriptions = GetFullSubscriptionsFromBiblionumber($biblionumber);
54 my $subscriptioninformation=PrepareSerialsData($subscriptions);
55 # now, check is there is an alert subscription for one of the subscriptions
56 foreach (@$subscriptions) {
57 if (getalert($loggedinuser,'issue',$_->{subscriptionid})) {
58 $_->{hasalert} = 1;
62 my $title = $subscriptions->[0]{bibliotitle};
63 my $yearmin = $subscriptions->[0]{year};
64 my $yearmax = $subscriptions->[ scalar(@$subscriptions) - 1 ]{year};
67 # replace CR by <br> in librarian note
68 # $subscription->{opacnote} =~ s/\n/\<br\/\>/g;
70 $template->param(
71 biblionumber => $query->param('biblionumber'),
72 years => $subscriptioninformation,
73 yearmin => $yearmin,
74 yearmax => $yearmax,
75 bibliotitle => $title,
76 suggestion => C4::Context->preference("suggestion"),
77 virtualshelves => C4::Context->preference("virtualshelves"),
81 else {
82 ( $template, $loggedinuser, $cookie ) = get_template_and_user(
84 template_name => "opac-serial-issues.tmpl",
85 query => $query,
86 type => "opac",
87 authnotrequired => 1,
88 debug => 1,
92 my $subscriptions = GetSubscriptionsFromBiblionumber($biblionumber);
93 # now, check is there is an alert subscription for one of the subscriptions
94 foreach (@$subscriptions) {
95 my $subscription = getalert($loggedinuser,'issue',$_->{subscriptionid});
96 if (@$subscription[0]) {
97 warn ">>>>>>>>> has alert : loggedinuser / ".$_->{subscriptionid};
98 $_->{hasalert} = 1;
102 # replace CR by <br> in librarian note
103 # $subscription->{opacnote} =~ s/\n/\<br\/\>/g;
105 $template->param(
106 biblionumber => $query->param('biblionumber'),
107 subscription_LOOP => $subscriptions,
110 output_html_with_http_headers $query, $cookie, $template->output;