#
# This file is part of Koha.
#
-# Koha is free software; you can redistribute it and/or modify it under the
-# terms of the GNU General Public License as published by the Free Software
-# Foundation; either version 2 of the License, or (at your option) any later
-# version.
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
#
-# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
-# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
-# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along
-# with Koha; if not, write to the Free Software Foundation, Inc.,
-# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
-
-
-use strict;
-#use warnings; FIXME - Bug 2505
-use C4::Koha;
-use CGI;
-use C4::Biblio;
-use C4::Items;
-use C4::Branch;
-use C4::Acquisition;
-use C4::Bookseller qw(GetBookSellerFromId);
-use C4::Output;
-use C4::Auth;
-use C4::Serials;
-use C4::Circulation; # to use itemissues
-use C4::Members; # to use GetMember
-use C4::Search; # enabled_staff_search_views
-use C4::Members qw/GetHideLostItemsPreference/;
-use C4::Reserves qw(GetReservesFromBiblionumber);
-use Koha::DateUtils;
-
-my $query=new CGI;
-
-# FIXME subject is not exported to the template?
-my $subject=$query->param('subject');
-
-# if its a subject we need to use the subject.tmpl
-my ($template, $loggedinuser, $cookie) = get_template_and_user({
- template_name => ($subject? 'catalogue/subject.tmpl':
- 'catalogue/moredetail.tmpl'),
- query => $query,
- type => "intranet",
- authnotrequired => 0,
- flagsrequired => {catalogue => 1},
- });
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+
+use Modern::Perl;
+use C4::Koha qw( GetAuthorisedValues );
+use CGI qw ( -utf8 );
+use HTML::Entities;
+use C4::Biblio qw( GetBiblioData GetFrameworkCode );
+use C4::Acquisition qw( GetOrderFromItemnumber GetBasket GetInvoice );
+use C4::Output qw( output_and_exit output_html_with_http_headers );
+use C4::Auth qw( get_template_and_user );
+use C4::Serials qw( CountSubscriptionFromBiblionumber );
+use C4::Search qw( enabled_staff_search_views z3950_search_args );
+
+use Koha::Acquisition::Booksellers;
+use Koha::AuthorisedValues;
+use Koha::Biblios;
+use Koha::Items;
+use Koha::Patrons;
+
+my $query=CGI->new;
+
+my ($template, $loggedinuser, $cookie) = get_template_and_user(
+ {
+ template_name => 'catalogue/moredetail.tt',
+ query => $query,
+ type => "intranet",
+ flagsrequired => { catalogue => 1 },
+ }
+);
+
+$template->param(
+ updated_exclude_from_local_holds_priority => scalar($query->param('updated_exclude_from_local_holds_priority'))
+);
if($query->cookie("holdfor")){
- my $holdfor_patron = GetMember('borrowernumber' => $query->cookie("holdfor"));
+ my $holdfor_patron = Koha::Patrons->find( $query->cookie("holdfor") );
$template->param(
- holdfor => $query->cookie("holdfor"),
- holdfor_surname => $holdfor_patron->{'surname'},
- holdfor_firstname => $holdfor_patron->{'firstname'},
- holdfor_cardnumber => $holdfor_patron->{'cardnumber'},
+ holdfor => $query->cookie("holdfor"),
+ holdfor_patron => $holdfor_patron,
);
}
-my $hidepatronname = C4::Context->preference("HidePatronName");
+if( $query->cookie("searchToOrder") ){
+ my ( $basketno, $vendorid ) = split( /\//, $query->cookie("searchToOrder") );
+ $template->param(
+ searchtoorder_basketno => $basketno,
+ searchtoorder_vendorid => $vendorid
+ );
+}
# get variables
+my $biblionumber;
+my $itemnumber;
+if( $query->param('itemnumber') && !$query->param('biblionumber') ){
+ $itemnumber = $query->param('itemnumber');
+ my $item = Koha::Items->find( $itemnumber );
+ $biblionumber = $item->biblionumber;
+} else {
+ $biblionumber = $query->param('biblionumber');
+}
-my $biblionumber=$query->param('biblionumber');
+$biblionumber = HTML::Entities::encode($biblionumber);
my $title=$query->param('title');
my $bi=$query->param('bi');
$bi = $biblionumber unless $bi;
-my $itemnumber = $query->param('itemnumber');
+$itemnumber = $query->param('itemnumber');
my $data = &GetBiblioData($biblionumber);
my $dewey = $data->{'dewey'};
my $showallitems = $query->param('showallitems');
# $dewey=~ s/\.$//;
# $data->{'dewey'}=$dewey;
+my $biblio = Koha::Biblios->find( $biblionumber );
+my $record = $biblio ? $biblio->metadata->record : undef;
+
+output_and_exit( $query, $cookie, $template, 'unknown_biblio')
+ unless $biblio && $record;
+
my $fw = GetFrameworkCode($biblionumber);
-my @all_items= GetItemsInfo($biblionumber);
+my $all_items = $biblio->items->search_ordered;
+
my @items;
-for my $itm (@all_items) {
- push @items, $itm unless ( $itm->{itemlost} &&
- GetHideLostItemsPreference($loggedinuser) &&
- !$showallitems &&
- ($itemnumber != $itm->{itemnumber}));
+my $patron = Koha::Patrons->find( $loggedinuser );
+while ( my $item = $all_items->next ) {
+ push @items, $item
+ unless $item->itemlost
+ && $patron->category->hidelostitems
+ && !$showallitems;
}
-my $record=GetMarcBiblio($biblionumber);
-
my $hostrecords;
-# adding items linked via host biblios
-my @hostitems = GetHostItemsInfo($record);
-if (@hostitems){
- $hostrecords =1;
- push (@items,@hostitems);
+my $hostitems = $biblio->host_items;
+if ( $hostitems->count ) {
+ $hostrecords = 1;
+ push @items, $hostitems->as_list;
}
-my $subtitle = GetRecordValue('subtitle', $record, $fw);
-
-my $totalcount=@all_items;
-my $showncount=@items;
+my $totalcount = $all_items->count;
+my $showncount = scalar @items;
my $hiddencount = $totalcount - $showncount;
$data->{'count'}=$totalcount;
$data->{'showncount'}=$showncount;
$data->{'hiddencount'}=$hiddencount; # can be zero
-my $ccodes= GetKohaAuthorisedValues('items.ccode',$fw);
-my $copynumbers = GetKohaAuthorisedValues('items.copynumber',$fw);
-my $itemtypes = GetItemTypes;
+my $ccodes =
+ { map { $_->{authorised_value} => $_->{lib} } Koha::AuthorisedValues->get_descriptions_by_koha_field( { frameworkcode => $fw, kohafield => 'items.ccode' } ) };
+my $copynumbers =
+ { map { $_->{authorised_value} => $_->{lib} } Koha::AuthorisedValues->get_descriptions_by_koha_field( { frameworkcode => $fw, kohafield => 'items.copynumber' } ) };
-$data->{'itemtypename'} = $itemtypes->{$data->{'itemtype'}}->{'description'};
-$data->{'rentalcharge'} = sprintf( "%.2f", $data->{'rentalcharge'} );
+my $itemtypes = { map { $_->{itemtype} => $_ } @{ Koha::ItemTypes->search_with_localization->unblessed } };
+
+$data->{'itemtypename'} = $itemtypes->{ $data->{'itemtype'} }->{'translated_description'}
+ if $data->{itemtype} && exists $itemtypes->{ $data->{itemtype} };
foreach ( keys %{$data} ) {
$template->param( "$_" => defined $data->{$_} ? $data->{$_} : '' );
}
-($itemnumber) and @items = (grep {$_->{'itemnumber'} == $itemnumber} @items);
+if ($itemnumber) {
+ @items = (grep {$_->itemnumber == $itemnumber} @items);
+}
+my @item_data;
foreach my $item (@items){
- $item->{itemlostloop}= GetAuthorisedValues(GetAuthValCode('items.itemlost',$fw),$item->{itemlost}) if GetAuthValCode('items.itemlost',$fw);
- $item->{itemdamagedloop}= GetAuthorisedValues(GetAuthValCode('items.damaged',$fw),$item->{damaged}) if GetAuthValCode('items.damaged',$fw);
- $item->{'collection'} = $ccodes->{ $item->{ccode} } if ($ccodes);
- $item->{'itype'} = $itemtypes->{ $item->{'itype'} }->{'description'};
- $item->{'replacementprice'} = sprintf( "%.2f", $item->{'replacementprice'} );
- if ( defined $item->{'copynumber'} ) {
- $item->{'displaycopy'} = 1;
- if ( defined $copynumbers->{ $item->{'copynumber'} } ) {
- $item->{'copyvol'} = $copynumbers->{ $item->{'copynumber'} }
+
+ my $item_info = $item->unblessed;
+ $item_info->{object} = $item;
+ $item_info->{itype} = $itemtypes->{ $item->itype }->{'translated_description'} if exists $itemtypes->{ $item->itype };
+ $item_info->{effective_itemtype} = $itemtypes->{$item->effective_itemtype};
+ $item_info->{'ccode'} = $ccodes->{ $item->ccode } if $ccodes && $item->ccode && exists $ccodes->{ $item->ccode };
+ if ( defined $item->copynumber ) {
+ $item_info->{'displaycopy'} = 1;
+ if ( defined $copynumbers->{ $item_info->{'copynumber'} } ) {
+ $item_info->{'copyvol'} = $copynumbers->{ $item_info->{'copynumber'} }
}
else {
- $item->{'copyvol'} = $item->{'copynumber'};
+ $item_info->{'copyvol'} = $item_info->{'copynumber'};
}
}
# item has a host number if its biblio number does not match the current bib
- if ($item->{biblionumber} ne $biblionumber){
- $item->{hostbiblionumber} = $item->{biblionumber};
- $item->{hosttitle} = GetBiblioData($item->{biblionumber})->{title};
+ if ($item->biblionumber ne $biblionumber){
+ $item_info->{hostbiblionumber} = $item->biblionumber;
+ $item_info->{hosttitle} = $item->biblio->title;
}
- my $order = GetOrderFromItemnumber( $item->{'itemnumber'} );
- $item->{'ordernumber'} = $order->{'ordernumber'};
- $item->{'basketno'} = $order->{'basketno'};
- $item->{'orderdate'} = $order->{'entrydate'};
- if ($item->{'basketno'}){
- my $basket = GetBasket($item->{'basketno'});
- my $bookseller = GetBookSellerFromId($basket->{'booksellerid'});
- $item->{'vendor'} = $bookseller->{'name'};
+ # FIXME The acquisition code below could be improved using methods from Koha:: objects
+ my $order = GetOrderFromItemnumber( $item->itemnumber );
+ $item_info->{'basketno'} = $order->{'basketno'};
+ $item_info->{'orderdate'} = $order->{'entrydate'};
+ if ($item_info->{'basketno'}){
+ my $basket = GetBasket($item_info->{'basketno'});
+ my $bookseller = Koha::Acquisition::Booksellers->find( $basket->{booksellerid} );
+ $item_info->{'vendor'} = $bookseller->name;
}
- $item->{'invoiceid'} = $order->{'invoiceid'};
- if($item->{invoiceid}) {
- my $invoice = GetInvoice($item->{invoiceid});
- $item->{invoicenumber} = $invoice->{invoicenumber} if $invoice;
+ $item_info->{'invoiceid'} = $order->{'invoiceid'};
+ if($item_info->{invoiceid}) {
+ my $invoice = GetInvoice($item_info->{invoiceid});
+ $item_info->{invoicenumber} = $invoice->{invoicenumber} if $invoice;
}
- $item->{'datereceived'} = $order->{'datereceived'};
+ $item_info->{'datereceived'} = $order->{'datereceived'};
+
+ if ( $item->notforloan
+ || $item->itemtype->notforloan
+ || $item->itemlost
+ || $item->damaged
+ || $item->withdrawn )
+ {
+ $item_info->{status_advisory} = 1;
+ }
+
+ # Add paidfor info
+ if ( $item->itemlost ) {
+ my $accountlines = Koha::Account::Lines->search(
+ {
+ itemnumber => $item->itemnumber,
+ debit_type_code => 'LOST',
+ status => [ undef, { '<>' => 'RETURNED' } ],
+ amountoutstanding => 0
+ },
+ {
+ order_by => { '-desc' => 'date' },
+ rows => 1
+ }
+ );
- if ($item->{notforloantext} or $item->{itemlost} or $item->{damaged} or $item->{withdrawn}) {
- $item->{status_advisory} = 1;
+ if ( my $accountline = $accountlines->next ) {
+ my $payment_offsets = $accountline->debit_offsets(
+ {
+ credit_id => { '!=' => undef }, # it is not the debit itself
+ 'credit.credit_type_code' =>
+ { '!=' => [ 'Writeoff', 'Forgiven' ] },
+ },
+ { join => 'credit', order_by => { '-desc' => 'created_on' } }
+ );
+
+ if ($payment_offsets->count) {
+ my $patron = $accountline->patron;
+ my $payment_offset = $payment_offsets->next;
+ $item_info->{paidfor} = { patron => $patron, created_on => $payment_offset->created_on };
+ }
+ }
}
if (C4::Context->preference("IndependentBranches")) {
#verifying rights
my $userenv = C4::Context->userenv();
- unless (C4::Context->IsSuperLibrarian() or ($userenv->{'branch'} eq $item->{'homebranch'})) {
- $item->{'nomod'}=1;
+ unless (C4::Context->IsSuperLibrarian() or ($userenv->{'branch'} eq $item->homebranch)) {
+ $item_info->{'nomod'}=1;
}
}
- $item->{'homebranchname'} = GetBranchName($item->{'homebranch'});
- $item->{'holdingbranchname'} = GetBranchName($item->{'holdingbranch'});
- if ($item->{'datedue'}) {
- $item->{'issue'}= 1;
- } else {
- $item->{'issue'}= 0;
- }
- unless ($hidepatronname) {
- if ( $item->{'borrowernumber'} ) {
- my $curr_borrower = GetMember('borrowernumber' => $item->{'borrowernumber'} );
- $item->{borrowerfirstname} = $curr_borrower->{'firstname'};
- $item->{borrowersurname} = $curr_borrower->{'surname'};
+ $item_info->{old_issues} = Koha::Old::Checkouts->search(
+ { itemnumber => $item->itemnumber },
+ {
+ order_by => { '-desc' => 'returndate' },
+ limit => 3
}
- }
+ );
+
+ $item_info->{nomod} = !$patron->can_edit_items_from( $item->homebranch );
+ push @item_data, $item_info;
}
+
+my $mss = Koha::MarcSubfieldStructures->search({ frameworkcode => $fw, kohafield => 'items.itemlost', authorised_value => [ -and => {'!=' => undef }, {'!=' => ''}] });
+if ( $mss->count ) {
+ $template->param( itemlostloop => GetAuthorisedValues( $mss->next->authorised_value ) );
+}
+$mss = Koha::MarcSubfieldStructures->search({ frameworkcode => $fw, kohafield => 'items.damaged', authorised_value => [ -and => {'!=' => undef }, {'!=' => ''}] });
+if ( $mss->count ) {
+ $template->param( itemdamagedloop => GetAuthorisedValues( $mss->next->authorised_value ) );
+}
+$mss = Koha::MarcSubfieldStructures->search({ frameworkcode => $fw, kohafield => 'items.withdrawn', authorised_value => [ -and => {'!=' => undef }, {'!=' => ''}] });
+if ( $mss->count ) {
+ $template->param( itemwithdrawnloop => GetAuthorisedValues( $mss->next->authorised_value) );
+}
+
$template->param(count => $data->{'count'},
subscriptionsnumber => $subscriptionsnumber,
subscriptiontitle => $data->{title},
C4::Search::enabled_staff_search_views,
);
+# get biblionumbers stored in the cart
+my @cart_list;
+
+if($query->cookie("intranet_bib_list")){
+ my $cart_list = $query->cookie("intranet_bib_list");
+ @cart_list = split(/\//, $cart_list);
+ if ( grep {$_ eq $biblionumber} @cart_list) {
+ $template->param( incart => 1 );
+ }
+}
+
+my $some_private_shelves = Koha::Virtualshelves->get_some_shelves(
+ {
+ borrowernumber => $loggedinuser,
+ add_allowed => 1,
+ public => 0,
+ }
+);
+my $some_public_shelves = Koha::Virtualshelves->get_some_shelves(
+ {
+ borrowernumber => $loggedinuser,
+ add_allowed => 1,
+ public => 1,
+ }
+);
+
+
+$template->param(
+ add_to_some_private_shelves => $some_private_shelves,
+ add_to_some_public_shelves => $some_public_shelves,
+);
+
$template->param(
- ITEM_DATA => \@items,
+ ITEM_DATA => \@item_data,
moredetailview => 1,
loggedinuser => $loggedinuser,
biblionumber => $biblionumber,
biblioitemnumber => $bi,
itemnumber => $itemnumber,
z3950_search_params => C4::Search::z3950_search_args(GetBiblioData($biblionumber)),
- subtitle => $subtitle,
- hidepatronname => $hidepatronname,
+ biblio => $biblio,
);
$template->param(ONLY_ONE => 1) if ( $itemnumber && $showncount != @items );
$template->{'VARS'}->{'searchid'} = $query->param('searchid');
-
-my ( $holdcount, $holds ) = GetReservesFromBiblionumber($biblionumber,1);
-$template->param( holdcount => $holdcount, holds => $holds );
+my $holds = $biblio->holds;
+$template->param( holdcount => $holds->count );
output_html_with_http_headers $query, $cookie, $template->output;