Bug 10694: (follow-up) fix various issues
[koha.git] / reports / serials_stats.pl
1 #!/usr/bin/perl
2
3 # Copyright 2009 SARL Biblibre
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;
22 use C4::Auth;
23 use CGI;
24 use C4::Context;
25 use C4::Branch; # GetBranches
26 use C4::Dates qw/format_date/;
27 use C4::Output;
28 use C4::Koha;
29 use C4::Reports;
30 use C4::Serials;
31
32 =head1 serials_out
33
34 plugin that shows a stats on serials
35
36 =head1 DESCRIPTION
37
38 =over 2
39
40 =cut
41
42 my $input      = new CGI;
43 my $templatename   = "reports/serials_stats.tmpl";
44 my $do_it      = $input->param("do_it");
45 my $bookseller = $input->param("bookseller");
46 my $branchcode = $input->param("branchcode");
47 my $expired    = $input->param("expired");
48 my $order      = $input->param("order");
49 my $output     = $input->param("output");
50 my $basename   = $input->param("basename");
51 our $sep       = $input->param("sep") || '';
52 $sep = "\t" if ($sep eq 'tabulation');
53
54 my ($template, $borrowernumber, $cookie)
55         = get_template_and_user({template_name => $templatename,
56                                 query => $input,
57                                 type => "intranet",
58                                 authnotrequired => 0,
59                                 flagsrequired => {reports => '*'},
60                                 debug => 1,
61                                 });
62                                 
63                                 
64                                 
65 my $dbh = C4::Context->dbh;
66
67 if($do_it){
68     my $where = "WHERE 1 ";
69     my @args;
70     # if a specific branchcode was selected
71     if( $branchcode ne '' ){
72         $where .= "AND branchcode = ? ";
73         push @args,$branchcode;
74     }
75     
76     # if a specific bookseller was selected
77     if($bookseller ne ''){
78         $where .= "AND aqbooksellerid = ? ";
79         push @args,$bookseller;
80     }
81
82     my $sth = $dbh->prepare("SELECT * 
83                              FROM subscription 
84                                LEFT JOIN aqbooksellers 
85                                ON (aqbooksellers.id=subscription.aqbooksellerid)
86                                LEFT JOIN biblio
87                                ON (biblio.biblionumber=subscription.biblionumber)
88                                $where
89                             ");
90
91     $sth->execute(@args);
92     
93     ## hash generation of items by branchcode
94     my @datas;
95
96     while(my $row = $sth->fetchrow_hashref){
97         $row->{'enddate'} = GetExpirationDate($row->{'subscriptionid'});
98         $row->{expired} = HasSubscriptionExpired($row->{subscriptionid});
99         push @datas, $row if (
100             $expired
101             or (
102                 not $expired
103                 and (
104                     not $row->{expired}
105                     and not $row->{closed}
106                 )
107             )
108         );
109     }
110
111     if($output eq 'screen'){
112         $template->param(datas => \@datas,
113                          do_it => 1);
114     }else{
115         binmode STDOUT, ':encoding(UTF-8)';
116         print $input->header(-type => 'application/vnd.sun.xml.calc',
117                          -encoding => 'utf-8',
118                              -name => "$basename.csv",
119                        -attachment => "$basename.csv");
120         print "Vendor".$sep;
121         print "Title".$sep;
122         print "Subscription id".$sep;
123         print "Branch".$sep;
124         print "Callnumber".$sep;
125         print "Subscription Begin".$sep;
126         print "Subscription End\n";
127         
128         foreach my $item (@datas){
129             print $item->{name}.$sep;
130             print $item->{title}.$sep;
131             print $item->{subscriptionid}.$sep;
132             print $item->{branchcode}.$sep;
133             print $item->{callnumber}.$sep;
134             print $item->{startdate}.$sep;
135             print $item->{enddate}."\n";
136         }
137         exit;
138     }
139 }else{
140     ## We generate booksellers list
141     my @booksellers;
142     
143     my $sth = $dbh->prepare("SELECT aqbooksellerid, aqbooksellers.name 
144                                 FROM subscription 
145                                   LEFT JOIN aqbooksellers ON (subscription.aqbooksellerid=aqbooksellers.id ) 
146                                 GROUP BY aqbooksellerid");
147     $sth->execute();
148     
149     while(my $row = $sth->fetchrow_hashref){
150         push(@booksellers,$row)
151     }
152
153         my $CGIextChoice=CGI::scrolling_list(
154                                 -name => 'MIME',
155                                 -id => 'MIME',
156                                 -values   => ['CSV'], # FIXME translation
157                                 -size     => 1,
158                                 -multiple => 0 );
159         my $CGIsepChoice=GetDelimiterChoices;
160         $template->param(
161                 CGIextChoice => $CGIextChoice,
162                 CGIsepChoice => $CGIsepChoice,
163         booksellers  => \@booksellers,
164         branches     => GetBranchesLoop(C4::Context->userenv->{'branch'}));
165 }
166
167 output_html_with_http_headers $input, $cookie, $template->output;