Detailing the three latest issues on OPAC for serials
[koha_gimpoz] / opac / opac-detail.pl
1 #!/usr/bin/perl
2 use strict;
3 require Exporter;
4 use CGI;
5 use C4::Search;
6 use C4::Auth;
7 use C4::Bull; #uses getsubscriptionfrom biblionumber
8 use C4::Interface::CGI::Output;
9 use HTML::Template;
10 use C4::Biblio;
11 use C4::SearchMarc;
12 use C4::Amazon;
13 my $query=new CGI;
14 my ($template, $borrowernumber, $cookie) 
15     = get_template_and_user({template_name => "opac-detail.tmpl",
16                              query => $query,
17                              type => "opac",
18                              authnotrequired => 1,
19                              flagsrequired => {borrow => 1},
20                              });
21
22 my $biblionumber=$query->param('bib');
23 $template->param(biblionumber => $biblionumber);
24
25
26 # change back when ive fixed request.pl
27 my @items                                 = &ItemInfo(undef, $biblionumber, 'opac');
28 my $dat                                   = &bibdata($biblionumber);
29 my ($authorcount, $addauthor)             = &addauthor($biblionumber);
30 my ($webbiblioitemcount, @webbiblioitems) = &getwebbiblioitems($biblionumber);
31 my ($websitecount, @websites)             = &getwebsites($biblionumber);
32
33 $dat->{'count'}=@items;
34
35 $dat->{'additional'}=$addauthor->[0]->{'author'};
36 for (my $i = 1; $i < $authorcount; $i++) {
37         $dat->{'additional'} .= " ; " . $addauthor->[$i]->{'author'};
38 } # for
39
40 my $norequests = 1;
41 foreach my $itm (@items) {
42     $norequests = 0 unless $itm->{'notforloan'};
43     $itm->{$itm->{'publictype'}} = 1;
44 }
45
46 $template->param(norequests => $norequests);
47
48   ## get notes and subjects from MARC record
49 my $marc = C4::Context->preference("marc");
50 if ($marc eq "yes") {
51         my $dbh = C4::Context->dbh;
52         my $bibid = &MARCfind_MARCbibid_from_oldbiblionumber($dbh,$biblionumber);
53         my $marcflavour = C4::Context->preference("marcflavour");
54         my $marcnotesarray = &getMARCnotes($dbh,$bibid,$marcflavour);
55         my $marcsubjctsarray = &getMARCsubjects($dbh,$bibid,$marcflavour);
56
57         $template->param(MARCNOTES => $marcnotesarray);
58         $template->param(MARCSUBJCTS => $marcsubjctsarray);
59 }
60
61 my @results = ($dat,);
62
63 my $resultsarray=\@results;
64 my $itemsarray=\@items;
65 my $webarray=\@webbiblioitems;
66 my $sitearray=\@websites;
67
68 #coping with subscriptions
69 my $subscriptionsnumber = getsubscriptionfrombiblionumber($biblionumber);
70 my @subscriptions = getsubscriptions($dat->{title},$dat->{issn},$biblionumber);
71 my @subs;
72 foreach my $subscription (@subscriptions){
73         warn "subsid :".$subscription->{subscriptionid};
74         my %cell;
75         $cell{subscriptionid}= $subscription->{subscriptionid};
76         $cell{subscriptionnotes}= $subscription->{notes};
77         #get the three latest serials.
78         $cell{latestserials}=getlatestserials($subscription->{subscriptionid},3);
79         push @subs, \%cell;
80 }
81
82 $template->param(BIBLIO_RESULTS => $resultsarray,
83                                 ITEM_RESULTS => $itemsarray,
84                                 WEB_RESULTS => $webarray,
85                                 SITE_RESULTS => $sitearray,
86                                 subscriptionsnumber => $subscriptionsnumber,
87                                 subscriptions => \@subs,
88                              LibraryName => C4::Context->preference("LibraryName"),
89                                 suggestion => C4::Context->preference("suggestion"),
90                                 virtualshelves => C4::Context->preference("virtualshelves"),
91 );
92   ## Amazon.com stuff
93 =head
94 my $isbn=$dat->{'isbn'};
95 my $amazon_details = &get_amazon_details($isbn);
96 foreach my $result (@{$amazon_details->{Details}}){
97         $template->param(item_description => $result->{ProductDescription});
98         $template->param(image => $result->{ImageUrlMedium});
99         $template->param(list_price => $result->{ListPrice});
100         $template->param(amazon_url => $result->{url});
101                                 }
102
103 my @products;
104 my @reviews;
105 for my $details( @{ $amazon_details->{ Details } } ) {
106         next unless $details->{ SimilarProducts };
107         for my $product ( @{ $details->{ SimilarProducts }->{ Product } } ) {
108                 push @products, +{ Product => $product };
109         }
110         next unless $details->{ Reviews };
111         for my $product ( @{ $details->{ Reviews }->{ AvgCustomerRating } } ) {
112                 $template->param(rating => $product);
113         }
114         for my $reviews ( @{ $details->{ Reviews }->{ CustomerReview } } ) {
115                 push @reviews, +{ Summary => $reviews->{ Summary }, Comment => $reviews->{ Comment }, };
116         }
117 }
118 $template->param( SIMILAR_PRODUCTS => \@products );
119 $template->param( REVIEWS => \@reviews );
120   ## End of Amazon Stuff
121 =cut
122 output_html_with_http_headers $query, $cookie, $template->output;
123
124 #output_html_with_http_headers $query, $cookie, $template->output;
125