X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=opac%2Fopac-detail.pl;h=de61ce3369744b578156b9337342b030c21266dd;hb=4dc238f5990c1cc64ea68c1409dcf7db04711e24;hp=e84af07390a1ba0fdb2f732756106bcb23b11648;hpb=606ecb532aa42562687bf0d05b4d6df6697300d7;p=koha.git diff --git a/opac/opac-detail.pl b/opac/opac-detail.pl index e84af07390..de61ce3369 100755 --- a/opac/opac-detail.pl +++ b/opac/opac-detail.pl @@ -19,17 +19,31 @@ use strict; -require Exporter; + use CGI; use C4::Auth; +use C4::Branch; +use C4::Koha; use C4::Serials; #uses getsubscriptionfrom biblionumber use C4::Output; use C4::Biblio; +use C4::Items; +use C4::Circulation; +use C4::Tags qw(get_tags); +use C4::Dates qw/format_date/; +use C4::XISBN qw(get_xisbns get_biblionumber_from_isbn get_biblio_from_xisbn); use C4::Amazon; use C4::Review; use C4::Serials; use C4::Members; +use C4::XSLT; +BEGIN { + if (C4::Context->preference('BakerTaylorEnabled')) { + require C4::External::BakerTaylor; + import C4::External::BakerTaylor qw(&image_url &link_url); + } +} my $query = new CGI; my ( $template, $borrowernumber, $cookie ) = get_template_and_user( @@ -44,83 +58,164 @@ my ( $template, $borrowernumber, $cookie ) = get_template_and_user( my $biblionumber = $query->param('biblionumber') || $query->param('bib'); $template->param( biblionumber => $biblionumber ); +# XSLT processing of some stuff +if (C4::Context->preference("XSLTDetailsDisplay") ) { + my $newxmlrecord = XSLTParse4Display($biblionumber,C4::Context->config('opachtdocs')."/prog/en/xslt/MARC21slim2OPACDetail.xsl"); + $template->param('XSLTBloc' => $newxmlrecord); +} # change back when ive fixed request.pl -my @items = &GetItemsInfo( $biblionumber, 'opac' ); +my @all_items = &GetItemsInfo( $biblionumber, 'opac' ); +my @items; +@items = @all_items unless C4::Context->preference('hidelostitems'); + +if (C4::Context->preference('hidelostitems')) { + # Hide host items + for my $itm (@all_items) { + push @items, $itm unless $itm->{itemlost}; + } +} my $dat = &GetBiblioData($biblionumber); if (!$dat) { - print $query->redirect("/cgi-bin/koha/koha-tmpl/errors/404.pl"); + print $query->redirect("/cgi-bin/koha/errors/404.pl"); + exit; +} +my $itemtypes = GetItemTypes(); +# imageurl: +my $itemtype = $dat->{'itemtype'}; +if ( $itemtype ) { + $dat->{'imageurl'} = getitemtypeimagelocation( 'opac', $itemtypes->{$itemtype}->{'imageurl'} ); + $dat->{'description'} = $itemtypes->{$itemtype}->{'description'}; } +my $shelflocations =GetKohaAuthorisedValues('items.location',$dat->{'frameworkcode'}); +my $collections = GetKohaAuthorisedValues('items.ccode',$dat->{'frameworkcode'} ); #coping with subscriptions my $subscriptionsnumber = CountSubscriptionFromBiblionumber($biblionumber); -my @subscriptions = - GetSubscriptions( $dat->{title}, $dat->{issn}, $biblionumber ); +my @subscriptions = GetSubscriptions( $dat->{title}, $dat->{issn}, $biblionumber ); my @subs; +$dat->{'serial'}=1 if $subscriptionsnumber; foreach my $subscription (@subscriptions) { my %cell; $cell{subscriptionid} = $subscription->{subscriptionid}; $cell{subscriptionnotes} = $subscription->{notes}; - + $cell{branchcode} = $subscription->{branchcode}; + $cell{hasalert} = $subscription->{hasalert}; #get the three latest serials. $cell{latestserials} = GetLatestSerials( $subscription->{subscriptionid}, 3 ); push @subs, \%cell; } -$dat->{'count'} = @items; +$dat->{'count'} = scalar(@items); -#adding RequestOnOpac filter to allow or not the display of plce reserve button -# FIXME - use me or delete me. -my $RequestOnOpac; -if (C4::Context->preference("RequestOnOpac")) { - $RequestOnOpac = 1; -} +my $biblio_authorised_value_images = C4::Items::get_authorised_value_images( C4::Biblio::get_biblio_authorised_values( $biblionumber ) ); my $norequests = 1; -foreach my $itm (@items) { - $norequests = 0 && $norequests +my $branches = GetBranches(); +my %itemfields; +for my $itm (@items) { + $norequests = 0 if ( (not $itm->{'wthdrawn'} ) - || (not $itm->{'itemlost'} ) - || (not $itm->{'itemnotforloan'} ) - || ($itm->{'itemnumber'} ) ); - $itm->{ $itm->{'publictype'} } = 1; -} + && (not $itm->{'itemlost'} ) + && ($itm->{'itemnotforloan'}<0 || not $itm->{'itemnotforloan'} ) + && (not $itemtypes->{$itm->{'itype'}}->{notforloan} ) + && ($itm->{'itemnumber'} ) ); -$template->param( norequests => $norequests, RequestOnOpac=>$RequestOnOpac ); + $itm->{ $itm->{'publictype'} } = 1; + $itm->{datedue} = format_date($itm->{datedue}); + $itm->{datelastseen} = format_date($itm->{datelastseen}); + + #get collection code description, too + my $ccode= $itm->{'ccode'}; + $itm->{'ccode'} = $collections->{$ccode} if(defined($collections) && exists($collections->{$ccode})); + $itm->{'location_description'} = $shelflocations->{$itm->{'location'} }; + $itm->{'imageurl'} = getitemtypeimagelocation( 'opac', $itemtypes->{ $itm->{itype} }->{'imageurl'} ); + $itm->{'description'} = $itemtypes->{$itemtype}->{'description'}; + foreach (qw(ccode enumchron copynumber itemnotes)) { + $itemfields{$_} = 1 if ($itm->{$_}); + } + + # walk through the item-level authorised values and populate some images + my $item_authorised_value_images = C4::Items::get_authorised_value_images( C4::Items::get_item_authorised_values( $itm->{'itemnumber'} ) ); + # warn( Data::Dumper->Dump( [ $item_authorised_value_images ], [ 'item_authorised_value_images' ] ) ); + + if ( $itm->{'itemlost'} ) { + my $lostimageinfo = List::Util::first { $_->{'category'} eq 'LOST' } @$item_authorised_value_images; + $itm->{'lostimageurl'} = $lostimageinfo->{ 'imageurl' }; + $itm->{'lostimagelabel'} = $lostimageinfo->{ 'label' }; + } + + + my ( $transfertwhen, $transfertfrom, $transfertto ) = GetTransfers($itm->{itemnumber}); + if ( $transfertwhen ne '' ) { + $itm->{transfertwhen} = format_date($transfertwhen); + $itm->{transfertfrom} = $branches->{$transfertfrom}{branchname}; + $itm->{transfertto} = $branches->{$transfertto}{branchname}; + } +} ## get notes and subjects from MARC record - my $dbh = C4::Context->dbh; - my $marcflavour = C4::Context->preference("marcflavour"); - my $record = GetMarcBiblio($biblionumber); - my $marcnotesarray = GetMarcNotes( $record, $marcflavour ); - my $marcauthorsarray = GetMarcAuthors( $record, $marcflavour ); - my $marcsubjctsarray = GetMarcSubjects( $record, $marcflavour ); - my $marcseriesarray = GetMarcSeries($record,$marcflavour); - my $marcurlsarray = GetMarcUrls($record,$marcflavour); +my $dbh = C4::Context->dbh; +my $marcflavour = C4::Context->preference("marcflavour"); +my $record = GetMarcBiblio($biblionumber); +my $marcnotesarray = GetMarcNotes ($record,$marcflavour); +my $marcauthorsarray = GetMarcAuthors ($record,$marcflavour); +my $marcsubjctsarray = GetMarcSubjects($record,$marcflavour); +my $marcseriesarray = GetMarcSeries ($record,$marcflavour); +my $marcurlsarray = GetMarcUrls ($record,$marcflavour); +my $subtitle = C4::Biblio::get_koha_field_from_marc('bibliosubtitle', 'subtitle', $record, ''); $template->param( - MARCNOTES => $marcnotesarray, - MARCSUBJCTS => $marcsubjctsarray, - MARCAUTHORS => $marcauthorsarray, - MARCSERIES => $marcseriesarray, - MARCURLS => $marcurlsarray, + MARCNOTES => $marcnotesarray, + MARCSUBJCTS => $marcsubjctsarray, + MARCAUTHORS => $marcauthorsarray, + MARCSERIES => $marcseriesarray, + MARCURLS => $marcurlsarray, + norequests => $norequests, + RequestOnOpac => C4::Context->preference("RequestOnOpac"), + itemdata_ccode => $itemfields{ccode}, + itemdata_enumchron => $itemfields{enumchron}, + itemdata_copynumber => $itemfields{copynumber}, + itemdata_itemnotes => $itemfields{itemnotes}, + authorised_value_images => $biblio_authorised_value_images, + subtitle => $subtitle, ); -my @results = ( $dat, ); foreach ( keys %{$dat} ) { $template->param( "$_" => $dat->{$_} . "" ); } +# COinS format FIXME: for books Only +my $coins_format; +my $fmt = substr $record->leader(), 6,2; +my $fmts; +$fmts->{'am'} = 'book'; +$coins_format = $fmts->{$fmt}; +$template->param( + ocoins_format => $coins_format, +); + my $reviews = getreviews( $biblionumber, 1 ); +my $loggedincommenter; foreach ( @$reviews ) { - my $borrower_number_review = $_->{borrowernumber}; - my $borrowerData = GetMember($borrower_number_review,'borrowernumber'); + my $borrowerData = GetMember($_->{borrowernumber},'borrowernumber'); # setting some borrower info into this hash $_->{title} = $borrowerData->{'title'}; $_->{surname} = $borrowerData->{'surname'}; $_->{firstname} = $borrowerData->{'firstname'}; + $_->{userid} = $borrowerData->{'userid'}; + $_->{datereviewed} = format_date($_->{datereviewed}); + if ($borrowerData->{'borrowernumber'} eq $borrowernumber) { + $_->{your_comment} = 1; + $loggedincommenter = 1; + } +} + + +if(C4::Context->preference("ISBD")) { + $template->param(ISBD => 1); } $template->param( @@ -129,47 +224,187 @@ $template->param( biblionumber => $biblionumber, subscriptions => \@subs, subscriptionsnumber => $subscriptionsnumber, - reviews => $reviews + reviews => $reviews, + loggedincommenter => $loggedincommenter ); -## Amazon.com stuff -#not used unless preference set -if ( C4::Context->preference("AmazonContent") == 1 ) { - use C4::Amazon; - $dat->{'amazonisbn'} = $dat->{'isbn'}; - $dat->{'amazonisbn'} =~ s|-||g; - - $template->param( amazonisbn => $dat->{amazonisbn} ); +sub isbn_cleanup ($) { + my $isbn=shift; + ($isbn) = $isbn =~ /([\d-]*[X]*)/; + $isbn =~ s/-//g; + if ( + $isbn =~ /\b(\d{13})\b/ or + $isbn =~ /\b(\d{10})\b/ or + $isbn =~ /\b(\d{9}X)\b/i + ) { + return $1; + } + return undef; +} - my $amazon_details = &get_amazon_details( $dat->{amazonisbn} ); +# XISBN Stuff +my $xisbn=$dat->{'isbn'}; +(my $aisbn) = $xisbn =~ /([\d-]*[X]*)/; +$aisbn =~ s/-//g; +$template->param(amazonisbn => $aisbn); # FIXME: so it is OK if the ISBN = 'XXXXX' ? +my ($clean,$clean2); +# these might be overkill, but they are better than the regexp above. +if ($clean = isbn_cleanup($xisbn)){ + $template->param(clean_isbn => $clean); +} - foreach my $result ( @{ $amazon_details->{Details} } ) { - $template->param( item_description => $result->{ProductDescription} ); - $template->param( image => $result->{ImageUrlMedium} ); - $template->param( list_price => $result->{ListPrice} ); - $template->param( amazon_url => $result->{url} ); +if (C4::Context->preference("OPACFRBRizeEditions")==1) { + eval { + $template->param( + xisbn => $xisbn, + XISBNS => get_xisbns($xisbn) + ); + }; + if ($@) { warn "XISBN Failed $@"; } +} +# Amazon.com Stuff +if ( C4::Context->preference("OPACAmazonContent") == 1 ) { + my $similar_products_exist; + my $amazon_details = &get_amazon_details( $xisbn, $record, $marcflavour ); + my $item_attributes = \%{$amazon_details->{Items}->{Item}->{ItemAttributes}}; + my $customer_reviews = \@{$amazon_details->{Items}->{Item}->{CustomerReviews}->{Review}}; + for my $one_review (@$customer_reviews) { + $one_review->{Date} = format_date($one_review->{Date}); } - - my @products; - my @reviews; - for my $details ( @{ $amazon_details->{Details} } ) { - next unless $details->{SimilarProducts}; - for my $product ( @{ $details->{SimilarProducts}->{Product} } ) { - push @products, +{ Product => $product }; + my @similar_products; + for my $similar_product (@{$amazon_details->{Items}->{Item}->{SimilarProducts}->{SimilarProduct}}) { + # do we have any of these isbns in our collection? + my $similar_biblionumbers = get_biblionumber_from_isbn($similar_product->{ASIN}); + # verify that there is at least one similar item + if (scalar(@$similar_biblionumbers)){ + $similar_products_exist++ if ($similar_biblionumbers && $similar_biblionumbers->[0]); + push @similar_products, +{ similar_biblionumbers => $similar_biblionumbers, title => $similar_product->{Title}, ASIN => $similar_product->{ASIN} }; } - next unless $details->{Reviews}; - for my $product ( @{ $details->{Reviews}->{AvgCustomerRating} } ) { - $template->param( rating => $product * 20 ); + } + my $editorial_reviews = \@{$amazon_details->{Items}->{Item}->{EditorialReviews}->{EditorialReview}}; + my $average_rating = $amazon_details->{Items}->{Item}->{CustomerReviews}->{AverageRating}; + $template->param( OPACAmazonSimilarItems => $similar_products_exist ); + $template->param( amazon_average_rating => $average_rating * 20); + $template->param( AMAZON_CUSTOMER_REVIEWS => $customer_reviews ); + $template->param( AMAZON_SIMILAR_PRODUCTS => \@similar_products ); + $template->param( AMAZON_EDITORIAL_REVIEWS => $editorial_reviews ); +} +# Shelf Browser Stuff +if (C4::Context->preference("OPACShelfBrowser")) { + # pick the first itemnumber unless one was selected by the user + my $starting_itemnumber = $query->param('shelfbrowse_itemnumber'); # || $items[0]->{itemnumber}; + $template->param( OpenOPACShelfBrowser => 1) if $starting_itemnumber; + # find the right cn_sort value for this item + my ($starting_cn_sort, $starting_homebranch, $starting_location); + my $sth_get_cn_sort = $dbh->prepare("SELECT cn_sort,homebranch,location from items where itemnumber=?"); + $sth_get_cn_sort->execute($starting_itemnumber); + while (my $result = $sth_get_cn_sort->fetchrow_hashref()) { + $starting_cn_sort = $result->{'cn_sort'}; + $starting_homebranch->{code} = $result->{'homebranch'}; + $starting_homebranch->{description} = $branches->{$result->{'homebranch'}}{branchname}; + $starting_location->{code} = $result->{'location'}; + $starting_location->{description} = GetAuthorisedValueDesc('','', $result->{'location'} ,'','','LOC'); + + } + + ## List of Previous Items + # order by cn_sort, which should include everything we need for ordering purposes (though not + # for limits, those need to be handled separately + my $sth_shelfbrowse_previous = $dbh->prepare(" + SELECT * + FROM items + WHERE + ((cn_sort = ? AND itemnumber < ?) OR cn_sort < ?) AND + homebranch = ? AND location = ? + ORDER BY cn_sort DESC, itemnumber LIMIT 3 + "); + $sth_shelfbrowse_previous->execute($starting_cn_sort, $starting_itemnumber, $starting_cn_sort, $starting_homebranch->{code}, $starting_location->{code}); + my @previous_items; + while (my $this_item = $sth_shelfbrowse_previous->fetchrow_hashref()) { + my $sth_get_biblio = $dbh->prepare("SELECT biblio.*,biblioitems.isbn AS isbn FROM biblio LEFT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber WHERE biblio.biblionumber=?"); + $sth_get_biblio->execute($this_item->{biblionumber}); + while (my $this_biblio = $sth_get_biblio->fetchrow_hashref()) { + $this_item->{'title'} = $this_biblio->{'title'}; + if ($clean2 = isbn_cleanup($this_biblio->{'isbn'})) { + $this_item->{'isbn'} = $clean2; + } else { + $this_item->{'isbn'} = $this_biblio->{'isbn'}; + } } - for my $reviews ( @{ $details->{Reviews}->{CustomerReview} } ) { - push @reviews, - +{ - Summary => $reviews->{Summary}, - Comment => $reviews->{Comment}, - }; + unshift @previous_items, $this_item; + } + + ## List of Next Items; this also intentionally catches the current item + my $sth_shelfbrowse_next = $dbh->prepare(" + SELECT * + FROM items + WHERE + ((cn_sort = ? AND itemnumber >= ?) OR cn_sort > ?) AND + homebranch = ? AND location = ? + ORDER BY cn_sort, itemnumber LIMIT 3 + "); + $sth_shelfbrowse_next->execute($starting_cn_sort, $starting_itemnumber, $starting_cn_sort, $starting_homebranch->{code}, $starting_location->{code}); + my @next_items; + while (my $this_item = $sth_shelfbrowse_next->fetchrow_hashref()) { + my $sth_get_biblio = $dbh->prepare("SELECT biblio.*,biblioitems.isbn AS isbn FROM biblio LEFT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber WHERE biblio.biblionumber=?"); + $sth_get_biblio->execute($this_item->{biblionumber}); + while (my $this_biblio = $sth_get_biblio->fetchrow_hashref()) { + $this_item->{'title'} = $this_biblio->{'title'}; + if ($clean2 = isbn_cleanup($this_biblio->{'isbn'})) { + $this_item->{'isbn'} = $clean2; + } else { + $this_item->{'isbn'} = $this_biblio->{'isbn'}; + } } + push @next_items, $this_item; } - $template->param( SIMILAR_PRODUCTS => \@products ); - $template->param( AMAZONREVIEWS => \@reviews ); + + # alas, these won't auto-vivify, see http://www.perlmonks.org/?node_id=508481 + my $shelfbrowser_next_itemnumber = $next_items[-1]->{itemnumber} if @next_items; + my $shelfbrowser_next_biblionumber = $next_items[-1]->{biblionumber} if @next_items; + + $template->param( + starting_homebranch => $starting_homebranch->{description}, + starting_location => $starting_location->{description}, + starting_itemnumber => $starting_itemnumber, + shelfbrowser_prev_itemnumber => (@previous_items ? $previous_items[0]->{itemnumber} : 0), + shelfbrowser_next_itemnumber => $shelfbrowser_next_itemnumber, + shelfbrowser_prev_biblionumber => (@previous_items ? $previous_items[0]->{biblionumber} : 0), + shelfbrowser_next_biblionumber => $shelfbrowser_next_biblionumber, + PREVIOUS_SHELF_BROWSE => \@previous_items, + NEXT_SHELF_BROWSE => \@next_items, + ); } + +if (C4::Context->preference("BakerTaylorEnabled")) { + $template->param( + BakerTaylorEnabled => 1, + BakerTaylorImageURL => &image_url(), + BakerTaylorLinkURL => &link_url(), + BakerTaylorBookstoreURL => C4::Context->preference('BakerTaylorBookstoreURL'), + ); + my ($bt_user, $bt_pass); + if ($clean and + $bt_user = C4::Context->preference('BakerTaylorUsername') and + $bt_pass = C4::Context->preference('BakerTaylorPassword') ) + { + $template->param( + BakerTaylorContentURL => + sprintf("http://contentcafe2.btol.com/ContentCafeClient/ContentCafe.aspx?UserID=%s&Password=%s&ItemKey=%s&Options=Y", + $bt_user,$bt_pass,$clean) + ); + } +} + +my $tag_quantity; +if (C4::Context->preference('TagsEnabled') and $tag_quantity = C4::Context->preference('TagsShowOnDetail')) { + $template->param( + TagsEnabled => 1, + TagsShowOnDetail => $tag_quantity, + TagsInputOnDetail => C4::Context->preference('TagsInputOnDetail') + ); + $template->param(TagLoop => get_tags({biblionumber=>$biblionumber, approved=>1, + 'sort'=>'-weight', limit=>$tag_quantity})); +} + output_html_with_http_headers $query, $cookie, $template->output;