per row inserts
[koha.git] / serials / serials-collection.pl
1 #!/usr/bin/perl
2
3 # Copyright 2000-2002 Katipo Communications
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 with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA  02111-1307 USA
19
20 # $Id$
21
22 use strict;
23 use CGI;
24 use C4::Auth;
25 use C4::Koha;
26 use C4::Date;
27 use C4::Serials;
28 use C4::Letters;
29 use C4::Output;
30 use C4::Interface::CGI::Output;
31 use C4::Context;
32
33
34 my $query = new CGI;
35 my $op = $query->param('op');
36 my $dbh = C4::Context->dbh;
37
38 my $sth;
39 # my $id;
40 my ($template, $loggedinuser, $cookie);
41 ($template, $loggedinuser, $cookie)
42   = get_template_and_user({template_name => "serials/serials-collection.tmpl",
43                             query => $query,
44                             type => "intranet",
45                             authnotrequired => 0,
46                             flagsrequired => {serials => 1},
47                             debug => 1,
48                             });
49 my $biblionumber = $query->param('biblionumber');
50 my @subscriptionid = $query->param('subscriptionid');
51
52 my $subscriptiondescs ;
53 my $subscriptions;
54 if (@subscriptionid){
55    my @subscriptioninformation=();
56    foreach my $subscriptionid (@subscriptionid){
57     my $subs= GetSubscription($subscriptionid);
58     $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
59     $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
60     $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
61     ##these are display information
62     $subs->{ "periodicity" . $subs->{periodicity} } = 1;
63     $subs->{ "numberpattern" . $subs->{numberpattern} } = 1;
64     $subs->{ "status" . $subs->{'status'} } = 1;
65     $subs->{startdate}     = format_date( $subs->{startdate} );
66     $subs->{histstartdate} = format_date( $subs->{histstartdate} );
67     if ( $subs->{enddate} eq '0000-00-00' ) {
68         $subs->{enddate} = '';
69     }
70     else {
71         $subs->{enddate} = format_date( $subs->{enddate} );
72     }
73     $subs->{'abouttoexpire'}=abouttoexpire($subs->{'subscriptionid'});
74     $subs->{'subscriptionexpired'}=HasSubscriptionExpired($subs->{'subscriptionid'});
75     push @$subscriptiondescs,$subs;
76     my $tmpsubscription= GetFullSubscription($subscriptionid);
77     @subscriptioninformation=(@$tmpsubscription,@subscriptioninformation);
78   }
79   $subscriptions=PrepareSerialsData(\@subscriptioninformation);
80 } else {
81   $subscriptiondescs = GetSubscriptionsFromBiblionumber($biblionumber) ;
82   my $subscriptioninformation = GetFullSubscriptionsFromBiblionumber($biblionumber);
83   $subscriptions=PrepareSerialsData($subscriptioninformation);
84 }
85
86 my $title = $subscriptiondescs->[0]{bibliotitle};
87 my $yearmax=($subscriptions->[0]{year} eq "manage" && scalar(@$subscriptions)>1)? $subscriptions->[1]{year} :$subscriptions->[0]{year};
88 my $yearmin=$subscriptions->[scalar(@$subscriptions)-1]{year};
89 my $subscriptionidlist="";
90 foreach my $subscription (@$subscriptiondescs){
91   $subscriptionidlist.=$subscription->{'subscriptionid'}."," ;
92   $biblionumber = $subscription->{'bibnum'} unless ($biblionumber);
93 }
94
95 # warn "title : $title yearmax : $yearmax nombre d'elements dans le tableau :".scalar(@$subscriptions);
96 #  use Data::Dumper; warn Dumper($subscriptions);
97 chop $subscriptionidlist;
98 $template->param(
99           onesubscription => (scalar(@$subscriptiondescs)==1),
100           subscriptionidlist => $subscriptionidlist,
101           biblionumber => $biblionumber,
102           subscriptions => $subscriptiondescs,
103           years => $subscriptions,
104           yearmin => $yearmin,
105           yearmax =>$yearmax,
106           bibliotitle => $title,
107           suggestion => C4::Context->preference("suggestion"),
108           virtualshelves => C4::Context->preference("virtualshelves"),
109           subscr=>$query->param('subscriptionid'),
110           );
111
112 output_html_with_http_headers $query, $cookie, $template->output;