3 # Copyright 2007 LibLime, Inc.
4 # Parts Copyright Biblibre 2010
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 use vars qw(@ISA @EXPORT);
40 get_hostitemnumbers_of
46 PrepareItemrecordDisplay
59 use List::MoreUtils qw(any);
61 use DateTime::Format::MySQL;
62 use Data::Dumper; # used as part of logging item record changes, not just for
63 # debugging; so please don't remove this
65 use Koha::AuthorisedValues;
66 use Koha::DateUtils qw(dt_from_string);
69 use Koha::Biblioitems;
72 use Koha::SearchEngine;
73 use Koha::SearchEngine::Indexer;
74 use Koha::SearchEngine::Search;
79 C4::Items - item management functions
83 This module contains an API for manipulating item
84 records in Koha, and is used by cataloguing, circulation,
85 acquisitions, and serials management.
87 # FIXME This POD is not up-to-date
88 A Koha item record is stored in two places: the
89 items table and embedded in a MARC tag in the XML
90 version of the associated bib record in C<biblioitems.marcxml>.
91 This is done to allow the item information to be readily
92 indexed (e.g., by Zebra), but means that each item
93 modification transaction must keep the items table
94 and the MARC XML in sync at all times.
96 The items table will be considered authoritative. In other
97 words, if there is ever a discrepancy between the items
98 table and the MARC XML, the items table should be considered
101 =head1 HISTORICAL NOTE
103 Most of the functions in C<C4::Items> were originally in
104 the C<C4::Biblio> module.
106 =head1 CORE EXPORTED FUNCTIONS
108 The following functions are meant for use by users
115 CartToShelf($itemnumber);
117 Set the current shelving location of the item record
118 to its stored permanent shelving location. This is
119 primarily used to indicate when an item whose current
120 location is a special processing ('PROC') or shelving cart
121 ('CART') location is back in the stacks.
126 my ( $itemnumber ) = @_;
128 unless ( $itemnumber ) {
129 croak "FAILED CartToShelf() - no itemnumber supplied";
132 my $item = Koha::Items->find($itemnumber);
133 if ( $item->location eq 'CART' ) {
134 $item->location($item->permanent_location)->store;
138 =head2 AddItemFromMarc
140 my ($biblionumber, $biblioitemnumber, $itemnumber)
141 = AddItemFromMarc($source_item_marc, $biblionumber[, $params]);
143 Given a MARC::Record object containing an embedded item
144 record and a biblionumber, create a new item record.
146 The final optional parameter, C<$params>, expected to contain
147 'skip_record_index' key, which relayed down to Koha::Item/store,
148 there it prevents calling of index_records,
149 which takes most of the time in batch adds/deletes: index_records
150 to be called later in C<additem.pl> after the whole loop.
153 skip_record_index => 1|0
157 sub AddItemFromMarc {
158 my $source_item_marc = shift;
159 my $biblionumber = shift;
160 my $params = @_ ? shift : {};
162 my $dbh = C4::Context->dbh;
164 # parse item hash from MARC
165 my $frameworkcode = C4::Biblio::GetFrameworkCode($biblionumber);
166 my ( $itemtag, $itemsubfield ) = C4::Biblio::GetMarcFromKohaField( "items.itemnumber" );
168 my $localitemmarc = MARC::Record->new;
169 $localitemmarc->append_fields( $source_item_marc->field($itemtag) );
171 my $item_values = C4::Biblio::TransformMarcToKoha( $localitemmarc, $frameworkcode, 'items' );
172 my $unlinked_item_subfields = _get_unlinked_item_subfields( $localitemmarc, $frameworkcode );
173 $item_values->{more_subfields_xml} = _get_unlinked_subfields_xml($unlinked_item_subfields);
174 $item_values->{biblionumber} = $biblionumber;
175 $item_values->{cn_source} = delete $item_values->{'items.cn_source'}; # Because of C4::Biblio::_disambiguate
176 $item_values->{cn_sort} = delete $item_values->{'items.cn_sort'}; # Because of C4::Biblio::_disambiguate
177 my $item = Koha::Item->new( $item_values )->store({ skip_record_index => $params->{skip_record_index} });
178 return ( $item->biblionumber, $item->biblioitemnumber, $item->itemnumber );
181 =head2 AddItemBatchFromMarc
183 ($itemnumber_ref, $error_ref) = AddItemBatchFromMarc($record,
184 $biblionumber, $biblioitemnumber, $frameworkcode);
186 Efficiently create item records from a MARC biblio record with
187 embedded item fields. This routine is suitable for batch jobs.
189 This API assumes that the bib record has already been
190 saved to the C<biblio> and C<biblioitems> tables. It does
191 not expect that C<biblio_metadata.metadata> is populated, but it
192 will do so via a call to ModBibiloMarc.
194 The goal of this API is to have a similar effect to using AddBiblio
195 and AddItems in succession, but without inefficient repeated
196 parsing of the MARC XML bib record.
198 This function returns an arrayref of new itemsnumbers and an arrayref of item
199 errors encountered during the processing. Each entry in the errors
200 list is a hashref containing the following keys:
206 Sequence number of original item tag in the MARC record.
210 Item barcode, provide to assist in the construction of
211 useful error messages.
215 Code representing the error condition. Can be 'duplicate_barcode',
216 'invalid_homebranch', or 'invalid_holdingbranch'.
218 =item error_information
220 Additional information appropriate to the error condition.
226 sub AddItemBatchFromMarc {
227 my ($record, $biblionumber, $biblioitemnumber, $frameworkcode) = @_;
228 my @itemnumbers = ();
230 my $dbh = C4::Context->dbh;
232 # We modify the record, so lets work on a clone so we don't change the
234 $record = $record->clone();
235 # loop through the item tags and start creating items
236 my @bad_item_fields = ();
237 my ($itemtag, $itemsubfield) = C4::Biblio::GetMarcFromKohaField( "items.itemnumber" );
238 my $item_sequence_num = 0;
239 ITEMFIELD: foreach my $item_field ($record->field($itemtag)) {
240 $item_sequence_num++;
241 # we take the item field and stick it into a new
242 # MARC record -- this is required so far because (FIXME)
243 # TransformMarcToKoha requires a MARC::Record, not a MARC::Field
244 # and there is no TransformMarcFieldToKoha
245 my $temp_item_marc = MARC::Record->new();
246 $temp_item_marc->append_fields($item_field);
248 # add biblionumber and biblioitemnumber
249 my $item = TransformMarcToKoha( $temp_item_marc, $frameworkcode, 'items' );
250 my $unlinked_item_subfields = _get_unlinked_item_subfields($temp_item_marc, $frameworkcode);
251 $item->{'more_subfields_xml'} = _get_unlinked_subfields_xml($unlinked_item_subfields);
252 $item->{'biblionumber'} = $biblionumber;
253 $item->{'biblioitemnumber'} = $biblioitemnumber;
254 $item->{cn_source} = delete $item->{'items.cn_source'}; # Because of C4::Biblio::_disambiguate
255 $item->{cn_sort} = delete $item->{'items.cn_sort'}; # Because of C4::Biblio::_disambiguate
257 # check for duplicate barcode
258 my %item_errors = CheckItemPreSave($item);
260 push @errors, _repack_item_errors($item_sequence_num, $item, \%item_errors);
261 push @bad_item_fields, $item_field;
265 my $item_object = Koha::Item->new($item)->store;
266 push @itemnumbers, $item_object->itemnumber; # FIXME not checking error
268 logaction("CATALOGUING", "ADD", $item_object->itemnumber, "item") if C4::Context->preference("CataloguingLog");
270 my $new_item_marc = _marc_from_item_hash($item_object->unblessed, $frameworkcode, $unlinked_item_subfields);
271 $item_field->replace_with($new_item_marc->field($itemtag));
274 # remove any MARC item fields for rejected items
275 foreach my $item_field (@bad_item_fields) {
276 $record->delete_field($item_field);
279 return (\@itemnumbers, \@errors);
282 =head2 ModItemFromMarc
284 my $item = ModItemFromMarc($item_marc, $biblionumber, $itemnumber[, $params]);
286 The final optional parameter, C<$params>, expected to contain
287 'skip_record_index' key, which relayed down to Koha::Item/store,
288 there it prevents calling of index_records,
289 which takes most of the time in batch adds/deletes: index_records better
290 to be called later in C<additem.pl> after the whole loop.
293 skip_record_index => 1|0
297 sub ModItemFromMarc {
298 my ( $item_marc, $biblionumber, $itemnumber, $params ) = @_;
300 my $frameworkcode = C4::Biblio::GetFrameworkCode($biblionumber);
301 my ( $itemtag, $itemsubfield ) = C4::Biblio::GetMarcFromKohaField( "items.itemnumber" );
303 my $localitemmarc = MARC::Record->new;
304 $localitemmarc->append_fields( $item_marc->field($itemtag) );
305 my $item_object = Koha::Items->find($itemnumber);
306 my $item = TransformMarcToKoha( $localitemmarc, $frameworkcode, 'items' );
308 # Retrieving the values for the fields that are not linked
309 my @mapped_fields = Koha::MarcSubfieldStructures->search(
311 frameworkcode => $frameworkcode,
312 kohafield => { -like => "items.%" }
314 )->get_column('kohafield');
315 for my $c ( $item_object->_result->result_source->columns ) {
316 next if grep { "items.$c" eq $_ } @mapped_fields;
317 $item->{$c} = $item_object->$c;
320 $item->{cn_source} = delete $item->{'items.cn_source'}; # Because of C4::Biblio::_disambiguate
321 $item->{cn_sort} = delete $item->{'items.cn_sort'}; # Because of C4::Biblio::_disambiguate
322 $item->{itemnumber} = $itemnumber;
323 $item->{biblionumber} = $biblionumber;
324 $item_object = $item_object->set_or_blank($item);
325 my $unlinked_item_subfields = _get_unlinked_item_subfields( $localitemmarc, $frameworkcode );
326 $item_object->more_subfields_xml(_get_unlinked_subfields_xml($unlinked_item_subfields));
327 $item_object->store({ skip_record_index => $params->{skip_record_index} });
329 return $item_object->unblessed;
332 =head2 ModItemTransfer
334 ModItemTransfer($itemnumber, $frombranch, $tobranch, $trigger, [$params]);
336 Marks an item as being transferred from one branch to another and records the trigger.
338 The last optional parameter allows for passing skip_record_index through to the items store call.
342 sub ModItemTransfer {
343 my ( $itemnumber, $frombranch, $tobranch, $trigger, $params ) = @_;
345 my $dbh = C4::Context->dbh;
346 my $item = Koha::Items->find( $itemnumber );
348 # Remove the 'shelving cart' location status if it is being used.
349 CartToShelf( $itemnumber ) if $item->location && $item->location eq 'CART' && ( !$item->permanent_location || $item->permanent_location ne 'CART' );
351 $dbh->do("UPDATE branchtransfers SET datearrived = NOW(), comments = ? WHERE itemnumber = ? AND datearrived IS NULL", undef, "Canceled, new transfer from $frombranch to $tobranch created", $itemnumber);
353 #new entry in branchtransfers....
354 my $sth = $dbh->prepare(
355 "INSERT INTO branchtransfers (itemnumber, frombranch, datesent, tobranch, reason)
356 VALUES (?, ?, NOW(), ?, ?)");
357 $sth->execute($itemnumber, $frombranch, $tobranch, $trigger);
359 # FIXME we are fetching the item twice in the 2 next statements!
360 Koha::Items->find($itemnumber)->holdingbranch($frombranch)->store({ log_action => 0, skip_record_index => $params->{skip_record_index} });
361 ModDateLastSeen($itemnumber, undef, { skip_record_index => $params->{skip_record_index} });
365 =head2 ModDateLastSeen
367 ModDateLastSeen( $itemnumber, $leave_item_lost, $params );
369 Mark item as seen. Is called when an item is issued, returned or manually marked during inventory/stocktaking.
370 C<$itemnumber> is the item number
371 C<$leave_item_lost> determines if a lost item will be found or remain lost
373 The last optional parameter allows for passing skip_record_index through to the items store call.
377 sub ModDateLastSeen {
378 my ( $itemnumber, $leave_item_lost, $params ) = @_;
380 my $today = output_pref({ dt => dt_from_string, dateformat => 'iso', dateonly => 1 });
382 my $item = Koha::Items->find($itemnumber);
383 $item->datelastseen($today);
384 $item->itemlost(0) unless $leave_item_lost;
385 $item->store({ log_action => 0, skip_record_index => $params->{skip_record_index} });
388 =head2 CheckItemPreSave
390 my $item_ref = TransformMarcToKoha($marc, 'items');
392 my %errors = CheckItemPreSave($item_ref);
393 if (exists $errors{'duplicate_barcode'}) {
394 print "item has duplicate barcode: ", $errors{'duplicate_barcode'}, "\n";
395 } elsif (exists $errors{'invalid_homebranch'}) {
396 print "item has invalid home branch: ", $errors{'invalid_homebranch'}, "\n";
397 } elsif (exists $errors{'invalid_holdingbranch'}) {
398 print "item has invalid holding branch: ", $errors{'invalid_holdingbranch'}, "\n";
403 Given a hashref containing item fields, determine if it can be
404 inserted or updated in the database. Specifically, checks for
405 database integrity issues, and returns a hash containing any
406 of the following keys, if applicable.
410 =item duplicate_barcode
412 Barcode, if it duplicates one already found in the database.
414 =item invalid_homebranch
416 Home branch, if not defined in branches table.
418 =item invalid_holdingbranch
420 Holding branch, if not defined in branches table.
424 This function does NOT implement any policy-related checks,
425 e.g., whether current operator is allowed to save an
426 item that has a given branch code.
430 sub CheckItemPreSave {
431 my $item_ref = shift;
435 # check for duplicate barcode
436 if (exists $item_ref->{'barcode'} and defined $item_ref->{'barcode'}) {
437 my $existing_item= Koha::Items->find({barcode => $item_ref->{'barcode'}});
438 if ($existing_item) {
439 if (!exists $item_ref->{'itemnumber'} # new item
440 or $item_ref->{'itemnumber'} != $existing_item->itemnumber) { # existing item
441 $errors{'duplicate_barcode'} = $item_ref->{'barcode'};
446 # check for valid home branch
447 if (exists $item_ref->{'homebranch'} and defined $item_ref->{'homebranch'}) {
448 my $home_library = Koha::Libraries->find( $item_ref->{homebranch} );
449 unless (defined $home_library) {
450 $errors{'invalid_homebranch'} = $item_ref->{'homebranch'};
454 # check for valid holding branch
455 if (exists $item_ref->{'holdingbranch'} and defined $item_ref->{'holdingbranch'}) {
456 my $holding_library = Koha::Libraries->find( $item_ref->{holdingbranch} );
457 unless (defined $holding_library) {
458 $errors{'invalid_holdingbranch'} = $item_ref->{'holdingbranch'};
466 =head1 EXPORTED SPECIAL ACCESSOR FUNCTIONS
468 The following functions provide various ways of
469 getting an item record, a set of item records, or
470 lists of authorized values for certain item fields.
474 =head2 GetItemsForInventory
476 ($itemlist, $iTotalRecords) = GetItemsForInventory( {
477 minlocation => $minlocation,
478 maxlocation => $maxlocation,
479 location => $location,
480 itemtype => $itemtype,
481 ignoreissued => $ignoreissued,
482 datelastseen => $datelastseen,
483 branchcode => $branchcode,
487 statushash => $statushash,
490 Retrieve a list of title/authors/barcode/callnumber, for biblio inventory.
492 The sub returns a reference to a list of hashes, each containing
493 itemnumber, author, title, barcode, item callnumber, and date last
494 seen. It is ordered by callnumber then title.
496 The required minlocation & maxlocation parameters are used to specify a range of item callnumbers
497 the datelastseen can be used to specify that you want to see items not seen since a past date only.
498 offset & size can be used to retrieve only a part of the whole listing (defaut behaviour)
499 $statushash requires a hashref that has the authorized values fieldname (intems.notforloan, etc...) as keys, and an arrayref of statuscodes we are searching for as values.
501 $iTotalRecords is the number of rows that would have been returned without the $offset, $size limit clause
505 sub GetItemsForInventory {
506 my ( $parameters ) = @_;
507 my $minlocation = $parameters->{'minlocation'} // '';
508 my $maxlocation = $parameters->{'maxlocation'} // '';
509 my $class_source = $parameters->{'class_source'} // C4::Context->preference('DefaultClassificationSource');
510 my $location = $parameters->{'location'} // '';
511 my $itemtype = $parameters->{'itemtype'} // '';
512 my $ignoreissued = $parameters->{'ignoreissued'} // '';
513 my $datelastseen = $parameters->{'datelastseen'} // '';
514 my $branchcode = $parameters->{'branchcode'} // '';
515 my $branch = $parameters->{'branch'} // '';
516 my $offset = $parameters->{'offset'} // '';
517 my $size = $parameters->{'size'} // '';
518 my $statushash = $parameters->{'statushash'} // '';
519 my $ignore_waiting_holds = $parameters->{'ignore_waiting_holds'} // '';
521 my $dbh = C4::Context->dbh;
522 my ( @bind_params, @where_strings );
524 my $min_cnsort = GetClassSort($class_source,undef,$minlocation);
525 my $max_cnsort = GetClassSort($class_source,undef,$maxlocation);
527 my $select_columns = q{
528 SELECT DISTINCT(items.itemnumber), barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, withdrawn, stocknumber, items.cn_sort
530 my $select_count = q{SELECT COUNT(DISTINCT(items.itemnumber))};
533 LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber
534 LEFT JOIN biblioitems on items.biblionumber = biblioitems.biblionumber
537 for my $authvfield (keys %$statushash){
538 if ( scalar @{$statushash->{$authvfield}} > 0 ){
539 my $joinedvals = join ',', @{$statushash->{$authvfield}};
540 push @where_strings, "$authvfield in (" . $joinedvals . ")";
546 push @where_strings, 'items.cn_sort >= ?';
547 push @bind_params, $min_cnsort;
551 push @where_strings, 'items.cn_sort <= ?';
552 push @bind_params, $max_cnsort;
556 $datelastseen = output_pref({ str => $datelastseen, dateformat => 'iso', dateonly => 1 });
557 push @where_strings, '(datelastseen < ? OR datelastseen IS NULL)';
558 push @bind_params, $datelastseen;
562 push @where_strings, 'items.location = ?';
563 push @bind_params, $location;
567 if($branch eq "homebranch"){
568 push @where_strings, 'items.homebranch = ?';
570 push @where_strings, 'items.holdingbranch = ?';
572 push @bind_params, $branchcode;
576 push @where_strings, 'biblioitems.itemtype = ?';
577 push @bind_params, $itemtype;
580 if ( $ignoreissued) {
581 $query .= "LEFT JOIN issues ON items.itemnumber = issues.itemnumber ";
582 push @where_strings, 'issues.date_due IS NULL';
585 if ( $ignore_waiting_holds ) {
586 $query .= "LEFT JOIN reserves ON items.itemnumber = reserves.itemnumber ";
587 push( @where_strings, q{(reserves.found != 'W' OR reserves.found IS NULL)} );
590 if ( @where_strings ) {
592 $query .= join ' AND ', @where_strings;
594 my $count_query = $select_count . $query;
595 $query .= ' ORDER BY items.cn_sort, itemcallnumber, title';
596 $query .= " LIMIT $offset, $size" if ($offset and $size);
597 $query = $select_columns . $query;
598 my $sth = $dbh->prepare($query);
599 $sth->execute( @bind_params );
602 my $tmpresults = $sth->fetchall_arrayref({});
603 $sth = $dbh->prepare( $count_query );
604 $sth->execute( @bind_params );
605 my ($iTotalRecords) = $sth->fetchrow_array();
607 my @avs = Koha::AuthorisedValues->search(
608 { 'marc_subfield_structures.kohafield' => { '>' => '' },
609 'me.authorised_value' => { '>' => '' },
611 { join => { category => 'marc_subfield_structures' },
612 distinct => ['marc_subfield_structures.kohafield, me.category, frameworkcode, me.authorised_value'],
613 '+select' => [ 'marc_subfield_structures.kohafield', 'marc_subfield_structures.frameworkcode', 'me.authorised_value', 'me.lib' ],
614 '+as' => [ 'kohafield', 'frameworkcode', 'authorised_value', 'lib' ],
618 my $avmapping = { map { $_->get_column('kohafield') . ',' . $_->get_column('frameworkcode') . ',' . $_->get_column('authorised_value') => $_->get_column('lib') } @avs };
620 foreach my $row (@$tmpresults) {
623 foreach (keys %$row) {
626 $avmapping->{ "items.$_," . $row->{'frameworkcode'} . "," . ( $row->{$_} // q{} ) }
629 $row->{$_} = $avmapping->{"items.$_,".$row->{'frameworkcode'}.",".$row->{$_}};
635 return (\@results, $iTotalRecords);
640 @results = GetItemsInfo($biblionumber);
642 Returns information about items with the given biblionumber.
644 C<GetItemsInfo> returns a list of references-to-hash. Each element
645 contains a number of keys. Most of them are attributes from the
646 C<biblio>, C<biblioitems>, C<items>, and C<itemtypes> tables in the
647 Koha database. Other keys include:
651 =item C<$data-E<gt>{branchname}>
653 The name (not the code) of the branch to which the book belongs.
655 =item C<$data-E<gt>{datelastseen}>
657 This is simply C<items.datelastseen>, except that while the date is
658 stored in YYYY-MM-DD format in the database, here it is converted to
659 DD/MM/YYYY format. A NULL date is returned as C<//>.
661 =item C<$data-E<gt>{datedue}>
663 =item C<$data-E<gt>{class}>
665 This is the concatenation of C<biblioitems.classification>, the book's
666 Dewey code, and C<biblioitems.subclass>.
668 =item C<$data-E<gt>{ocount}>
670 I think this is the number of copies of the book available.
672 =item C<$data-E<gt>{order}>
674 If this is set, it is set to C<One Order>.
681 my ( $biblionumber ) = @_;
682 my $dbh = C4::Context->dbh;
683 require C4::Languages;
684 my $language = C4::Languages::getlanguage();
690 biblioitems.itemtype,
693 biblioitems.publicationyear,
694 biblioitems.publishercode,
695 biblioitems.volumedate,
696 biblioitems.volumedesc,
699 items.notforloan as itemnotforloan,
700 issues.borrowernumber,
701 issues.date_due as datedue,
702 issues.onsite_checkout,
703 borrowers.cardnumber,
706 borrowers.branchcode as bcode,
708 serial.publisheddate,
709 itemtypes.description,
710 COALESCE( localization.translation, itemtypes.description ) AS translated_description,
711 itemtypes.notforloan as notforloan_per_itemtype,
715 holding.opac_info as holding_branch_opac_info,
716 home.opac_info as home_branch_opac_info,
717 IF(tmp_holdsqueue.itemnumber,1,0) AS has_pending_hold
719 LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode
720 LEFT JOIN branches AS home ON items.homebranch=home.branchcode
721 LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
722 LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
723 LEFT JOIN issues USING (itemnumber)
724 LEFT JOIN borrowers USING (borrowernumber)
725 LEFT JOIN serialitems USING (itemnumber)
726 LEFT JOIN serial USING (serialid)
727 LEFT JOIN itemtypes ON itemtypes.itemtype = "
728 . (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype');
730 LEFT JOIN tmp_holdsqueue USING (itemnumber)
731 LEFT JOIN localization ON itemtypes.itemtype = localization.code
732 AND localization.entity = 'itemtypes'
733 AND localization.lang = ?
736 $query .= " WHERE items.biblionumber = ? ORDER BY home.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ;
737 my $sth = $dbh->prepare($query);
738 $sth->execute($language, $biblionumber);
743 my $userenv = C4::Context->userenv;
744 my $want_not_same_branch = C4::Context->preference("IndependentBranches") && !C4::Context->IsSuperLibrarian();
745 while ( my $data = $sth->fetchrow_hashref ) {
746 if ( $data->{borrowernumber} && $want_not_same_branch) {
747 $data->{'NOTSAMEBRANCH'} = $data->{'bcode'} ne $userenv->{branch};
750 $serial ||= $data->{'serial'};
753 # get notforloan complete status if applicable
754 $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $data->{frameworkcode}, kohafield => 'items.notforloan', authorised_value => $data->{itemnotforloan} });
755 $data->{notforloanvalue} = $descriptions->{lib} // '';
756 $data->{notforloanvalueopac} = $descriptions->{opac_description} // '';
758 # get restricted status and description if applicable
759 $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $data->{frameworkcode}, kohafield => 'items.restricted', authorised_value => $data->{restricted} });
760 $data->{restrictedvalue} = $descriptions->{lib} // '';
761 $data->{restrictedvalueopac} = $descriptions->{opac_description} // '';
763 # my stack procedures
764 $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $data->{frameworkcode}, kohafield => 'items.stack', authorised_value => $data->{stack} });
765 $data->{stack} = $descriptions->{lib} // '';
767 # Find the last 3 people who borrowed this item.
768 my $sth2 = $dbh->prepare("SELECT * FROM old_issues,borrowers
770 AND old_issues.borrowernumber = borrowers.borrowernumber
771 ORDER BY returndate DESC
773 $sth2->execute($data->{'itemnumber'});
775 while (my $data2 = $sth2->fetchrow_hashref()) {
776 $data->{"timestamp$ii"} = $data2->{'timestamp'} if $data2->{'timestamp'};
777 $data->{"card$ii"} = $data2->{'cardnumber'} if $data2->{'cardnumber'};
778 $data->{"borrower$ii"} = $data2->{'borrowernumber'} if $data2->{'borrowernumber'};
782 $results[$i] = $data;
787 ? sort { ($b->{'publisheddate'} || $b->{'enumchron'}) cmp ($a->{'publisheddate'} || $a->{'enumchron'}) } @results
791 =head2 GetItemsLocationInfo
793 my @itemlocinfo = GetItemsLocationInfo($biblionumber);
795 Returns the branch names, shelving location and itemcallnumber for each item attached to the biblio in question
797 C<GetItemsInfo> returns a list of references-to-hash. Data returned:
801 =item C<$data-E<gt>{homebranch}>
803 Branch Name of the item's homebranch
805 =item C<$data-E<gt>{holdingbranch}>
807 Branch Name of the item's holdingbranch
809 =item C<$data-E<gt>{location}>
811 Item's shelving location code
813 =item C<$data-E<gt>{location_intranet}>
815 The intranet description for the Shelving Location as set in authorised_values 'LOC'
817 =item C<$data-E<gt>{location_opac}>
819 The OPAC description for the Shelving Location as set in authorised_values 'LOC'. Falls back to intranet description if no OPAC
822 =item C<$data-E<gt>{itemcallnumber}>
824 Item's itemcallnumber
826 =item C<$data-E<gt>{cn_sort}>
828 Item's call number normalized for sorting
834 sub GetItemsLocationInfo {
835 my $biblionumber = shift;
838 my $dbh = C4::Context->dbh;
839 my $query = "SELECT a.branchname as homebranch, b.branchname as holdingbranch,
840 location, itemcallnumber, cn_sort
841 FROM items, branches as a, branches as b
842 WHERE homebranch = a.branchcode AND holdingbranch = b.branchcode
844 ORDER BY cn_sort ASC";
845 my $sth = $dbh->prepare($query);
846 $sth->execute($biblionumber);
848 while ( my $data = $sth->fetchrow_hashref ) {
849 my $av = Koha::AuthorisedValues->search({ category => 'LOC', authorised_value => $data->{location} });
850 $av = $av->count ? $av->next : undef;
851 $data->{location_intranet} = $av ? $av->lib : '';
852 $data->{location_opac} = $av ? $av->opac_description : '';
853 push @results, $data;
858 =head2 GetHostItemsInfo
860 $hostiteminfo = GetHostItemsInfo($hostfield);
861 Returns the iteminfo for items linked to records via a host field
865 sub GetHostItemsInfo {
869 if( !C4::Context->preference('EasyAnalyticalRecords') ) {
870 return @returnitemsInfo;
874 if( C4::Context->preference('marcflavour') eq 'MARC21' ||
875 C4::Context->preference('marcflavour') eq 'NORMARC') {
876 @fields = $record->field('773');
877 } elsif( C4::Context->preference('marcflavour') eq 'UNIMARC') {
878 @fields = $record->field('461');
881 foreach my $hostfield ( @fields ) {
882 my $hostbiblionumber = $hostfield->subfield("0");
883 my $linkeditemnumber = $hostfield->subfield("9");
884 my @hostitemInfos = GetItemsInfo($hostbiblionumber);
885 foreach my $hostitemInfo (@hostitemInfos) {
886 if( $hostitemInfo->{itemnumber} eq $linkeditemnumber ) {
887 push @returnitemsInfo, $hostitemInfo;
892 return @returnitemsInfo;
895 =head2 get_hostitemnumbers_of
897 my @itemnumbers_of = get_hostitemnumbers_of($biblionumber);
899 Given a biblionumber, return the list of corresponding itemnumbers that are linked to it via host fields
901 Return a reference on a hash where key is a biblionumber and values are
902 references on array of itemnumbers.
907 sub get_hostitemnumbers_of {
908 my ($biblionumber) = @_;
910 if( !C4::Context->preference('EasyAnalyticalRecords') ) {
914 my $marcrecord = C4::Biblio::GetMarcBiblio({ biblionumber => $biblionumber });
915 return unless $marcrecord;
917 my ( @returnhostitemnumbers, $tag, $biblio_s, $item_s );
919 my $marcflavor = C4::Context->preference('marcflavour');
920 if ( $marcflavor eq 'MARC21' || $marcflavor eq 'NORMARC' ) {
925 elsif ( $marcflavor eq 'UNIMARC' ) {
931 foreach my $hostfield ( $marcrecord->field($tag) ) {
932 my $hostbiblionumber = $hostfield->subfield($biblio_s);
933 next unless $hostbiblionumber; # have tag, don't have $biblio_s subfield
934 my $linkeditemnumber = $hostfield->subfield($item_s);
935 if ( ! $linkeditemnumber ) {
936 warn "ERROR biblionumber $biblionumber has 773^0, but doesn't have 9";
939 my $is_from_biblio = Koha::Items->search({ itemnumber => $linkeditemnumber, biblionumber => $hostbiblionumber });
940 push @returnhostitemnumbers, $linkeditemnumber
944 return @returnhostitemnumbers;
947 =head2 GetHiddenItemnumbers
949 my @itemnumbers_to_hide = GetHiddenItemnumbers({ items => \@items, borcat => $category });
951 Given a list of items it checks which should be hidden from the OPAC given
952 the current configuration. Returns a list of itemnumbers corresponding to
953 those that should be hidden. Optionally takes a borcat parameter for certain borrower types
958 sub GetHiddenItemnumbers {
960 my $items = $params->{items};
961 if (my $exceptions = C4::Context->preference('OpacHiddenItemsExceptions') and $params->{'borcat'}){
962 foreach my $except (split(/\|/, $exceptions)){
963 if ($params->{'borcat'} eq $except){
964 return; # we don't hide anything for this borrower category
970 my $yaml = C4::Context->preference('OpacHiddenItems');
971 return () if (! $yaml =~ /\S/ );
972 $yaml = "$yaml\n\n"; # YAML is anal on ending \n. Surplus does not hurt
975 $hidingrules = YAML::Load($yaml);
978 warn "Unable to parse OpacHiddenItems syspref : $@";
981 my $dbh = C4::Context->dbh;
984 foreach my $item (@$items) {
987 foreach my $field (keys %$hidingrules) {
989 if (exists $item->{$field}) {
990 $val = $item->{$field};
993 my $query = "SELECT $field from items where itemnumber = ?";
994 $val = $dbh->selectrow_array($query, undef, $item->{'itemnumber'});
996 $val = '' unless defined $val;
998 # If the results matches the values in the yaml file
999 if (any { $val eq $_ } @{$hidingrules->{$field}}) {
1001 # We add the itemnumber to the list
1002 push @resultitems, $item->{'itemnumber'};
1004 # If at least one rule matched for an item, no need to test the others
1009 return @resultitems;
1012 =head1 LIMITED USE FUNCTIONS
1014 The following functions, while part of the public API,
1015 are not exported. This is generally because they are
1016 meant to be used by only one script for a specific
1017 purpose, and should not be used in any other context
1018 without careful thought.
1024 my $item_marc = GetMarcItem($biblionumber, $itemnumber);
1026 Returns MARC::Record of the item passed in parameter.
1027 This function is meant for use only in C<cataloguing/additem.pl>,
1028 where it is needed to support that script's MARC-like
1034 my ( $biblionumber, $itemnumber ) = @_;
1036 # GetMarcItem has been revised so that it does the following:
1037 # 1. Gets the item information from the items table.
1038 # 2. Converts it to a MARC field for storage in the bib record.
1040 # The previous behavior was:
1041 # 1. Get the bib record.
1042 # 2. Return the MARC tag corresponding to the item record.
1044 # The difference is that one treats the items row as authoritative,
1045 # while the other treats the MARC representation as authoritative
1046 # under certain circumstances.
1048 my $item = Koha::Items->find($itemnumber) or return;
1050 # Tack on 'items.' prefix to column names so that C4::Biblio::TransformKohaToMarc will work.
1051 # Also, don't emit a subfield if the underlying field is blank.
1053 return Item2Marc($item->unblessed, $biblionumber);
1057 my ($itemrecord,$biblionumber)=@_;
1060 defined($itemrecord->{$_}) && $itemrecord->{$_} ne '' ? ("items.$_" => $itemrecord->{$_}) : ()
1061 } keys %{ $itemrecord }
1063 my $framework = C4::Biblio::GetFrameworkCode( $biblionumber );
1064 my $itemmarc = C4::Biblio::TransformKohaToMarc( $mungeditem, { framework => $framework } );
1065 my ( $itemtag, $itemsubfield ) = C4::Biblio::GetMarcFromKohaField(
1066 "items.itemnumber", $framework,
1069 my $unlinked_item_subfields = _parse_unlinked_item_subfields_from_xml($mungeditem->{'items.more_subfields_xml'});
1070 if (defined $unlinked_item_subfields and $#$unlinked_item_subfields > -1) {
1071 foreach my $field ($itemmarc->field($itemtag)){
1072 $field->add_subfields(@$unlinked_item_subfields);
1078 =head1 PRIVATE FUNCTIONS AND VARIABLES
1080 The following functions are not meant to be called
1081 directly, but are documented in order to explain
1082 the inner workings of C<C4::Items>.
1086 =head2 MoveItemFromBiblio
1088 MoveItemFromBiblio($itenumber, $frombiblio, $tobiblio);
1090 Moves an item from a biblio to another
1092 Returns undef if the move failed or the biblionumber of the destination record otherwise
1096 sub MoveItemFromBiblio {
1097 my ($itemnumber, $frombiblio, $tobiblio) = @_;
1098 my $dbh = C4::Context->dbh;
1099 my ( $tobiblioitem ) = $dbh->selectrow_array(q|
1100 SELECT biblioitemnumber
1102 WHERE biblionumber = ?
1103 |, undef, $tobiblio );
1104 my $return = $dbh->do(q|
1106 SET biblioitemnumber = ?,
1108 WHERE itemnumber = ?
1109 AND biblionumber = ?
1110 |, undef, $tobiblioitem, $tobiblio, $itemnumber, $frombiblio );
1112 my $indexer = Koha::SearchEngine::Indexer->new({ index => $Koha::SearchEngine::BIBLIOS_INDEX });
1113 $indexer->index_records( $tobiblio, "specialUpdate", "biblioserver" );
1114 $indexer->index_records( $frombiblio, "specialUpdate", "biblioserver" );
1115 # Checking if the item we want to move is in an order
1116 require C4::Acquisition;
1117 my $order = C4::Acquisition::GetOrderFromItemnumber($itemnumber);
1119 # Replacing the biblionumber within the order if necessary
1120 $order->{'biblionumber'} = $tobiblio;
1121 C4::Acquisition::ModOrder($order);
1124 # Update reserves, hold_fill_targets, tmp_holdsqueue and linktracker tables
1125 for my $table_name ( qw( reserves hold_fill_targets tmp_holdsqueue linktracker ) ) {
1128 SET biblionumber = ?
1129 WHERE itemnumber = ?
1130 |, undef, $tobiblio, $itemnumber );
1137 =head2 _marc_from_item_hash
1139 my $item_marc = _marc_from_item_hash($item, $frameworkcode[, $unlinked_item_subfields]);
1141 Given an item hash representing a complete item record,
1142 create a C<MARC::Record> object containing an embedded
1143 tag representing that item.
1145 The third, optional parameter C<$unlinked_item_subfields> is
1146 an arrayref of subfields (not mapped to C<items> fields per the
1147 framework) to be added to the MARC representation
1152 sub _marc_from_item_hash {
1154 my $frameworkcode = shift;
1155 my $unlinked_item_subfields;
1157 $unlinked_item_subfields = shift;
1160 # Tack on 'items.' prefix to column names so lookup from MARC frameworks will work
1161 # Also, don't emit a subfield if the underlying field is blank.
1162 my $mungeditem = { map { (defined($item->{$_}) and $item->{$_} ne '') ?
1163 (/^items\./ ? ($_ => $item->{$_}) : ("items.$_" => $item->{$_}))
1164 : () } keys %{ $item } };
1166 my $item_marc = MARC::Record->new();
1167 foreach my $item_field ( keys %{$mungeditem} ) {
1168 my ( $tag, $subfield ) = C4::Biblio::GetMarcFromKohaField( $item_field );
1169 next unless defined $tag and defined $subfield; # skip if not mapped to MARC field
1170 my @values = split(/\s?\|\s?/, $mungeditem->{$item_field}, -1);
1171 foreach my $value (@values){
1172 if ( my $field = $item_marc->field($tag) ) {
1173 $field->add_subfields( $subfield => $value );
1175 my $add_subfields = [];
1176 if (defined $unlinked_item_subfields and ref($unlinked_item_subfields) eq 'ARRAY' and $#$unlinked_item_subfields > -1) {
1177 $add_subfields = $unlinked_item_subfields;
1179 $item_marc->add_fields( $tag, " ", " ", $subfield => $value, @$add_subfields );
1187 =head2 _repack_item_errors
1189 Add an error message hash generated by C<CheckItemPreSave>
1190 to a list of errors.
1194 sub _repack_item_errors {
1195 my $item_sequence_num = shift;
1196 my $item_ref = shift;
1197 my $error_ref = shift;
1199 my @repacked_errors = ();
1201 foreach my $error_code (sort keys %{ $error_ref }) {
1202 my $repacked_error = {};
1203 $repacked_error->{'item_sequence'} = $item_sequence_num;
1204 $repacked_error->{'item_barcode'} = exists($item_ref->{'barcode'}) ? $item_ref->{'barcode'} : '';
1205 $repacked_error->{'error_code'} = $error_code;
1206 $repacked_error->{'error_information'} = $error_ref->{$error_code};
1207 push @repacked_errors, $repacked_error;
1210 return @repacked_errors;
1213 =head2 _get_unlinked_item_subfields
1215 my $unlinked_item_subfields = _get_unlinked_item_subfields($original_item_marc, $frameworkcode);
1219 sub _get_unlinked_item_subfields {
1220 my $original_item_marc = shift;
1221 my $frameworkcode = shift;
1223 my $marcstructure = C4::Biblio::GetMarcStructure(1, $frameworkcode, { unsafe => 1 });
1225 # assume that this record has only one field, and that that
1226 # field contains only the item information
1228 my @fields = $original_item_marc->fields();
1229 if ($#fields > -1) {
1230 my $field = $fields[0];
1231 my $tag = $field->tag();
1232 foreach my $subfield ($field->subfields()) {
1233 if (defined $subfield->[1] and
1234 $subfield->[1] ne '' and
1235 !$marcstructure->{$tag}->{$subfield->[0]}->{'kohafield'}) {
1236 push @$subfields, $subfield->[0] => $subfield->[1];
1243 =head2 _get_unlinked_subfields_xml
1245 my $unlinked_subfields_xml = _get_unlinked_subfields_xml($unlinked_item_subfields);
1249 sub _get_unlinked_subfields_xml {
1250 my $unlinked_item_subfields = shift;
1253 if (defined $unlinked_item_subfields and ref($unlinked_item_subfields) eq 'ARRAY' and $#$unlinked_item_subfields > -1) {
1254 my $marc = MARC::Record->new();
1255 # use of tag 999 is arbitrary, and doesn't need to match the item tag
1256 # used in the framework
1257 $marc->append_fields(MARC::Field->new('999', ' ', ' ', @$unlinked_item_subfields));
1258 $marc->encoding("UTF-8");
1259 $xml = $marc->as_xml("USMARC");
1265 =head2 _parse_unlinked_item_subfields_from_xml
1267 my $unlinked_item_subfields = _parse_unlinked_item_subfields_from_xml($whole_item->{'more_subfields_xml'}):
1271 sub _parse_unlinked_item_subfields_from_xml {
1273 require C4::Charset;
1274 return unless defined $xml and $xml ne "";
1275 my $marc = MARC::Record->new_from_xml(C4::Charset::StripNonXmlChars($xml),'UTF-8');
1276 my $unlinked_subfields = [];
1277 my @fields = $marc->fields();
1278 if ($#fields > -1) {
1279 foreach my $subfield ($fields[0]->subfields()) {
1280 push @$unlinked_subfields, $subfield->[0] => $subfield->[1];
1283 return $unlinked_subfields;
1286 =head2 GetAnalyticsCount
1288 $count= &GetAnalyticsCount($itemnumber)
1290 counts Usage of itemnumber in Analytical bibliorecords.
1294 sub GetAnalyticsCount {
1295 my ($itemnumber) = @_;
1297 ### ZOOM search here
1299 $query= "hi=".$itemnumber;
1300 my $searcher = Koha::SearchEngine::Search->new({index => $Koha::SearchEngine::BIBLIOS_INDEX});
1301 my ($err,$res,$result) = $searcher->simple_search_compat($query,0,10);
1305 sub _SearchItems_build_where_fragment {
1308 my $dbh = C4::Context->dbh;
1311 if (exists($filter->{conjunction})) {
1312 my (@where_strs, @where_args);
1313 foreach my $f (@{ $filter->{filters} }) {
1314 my $fragment = _SearchItems_build_where_fragment($f);
1316 push @where_strs, $fragment->{str};
1317 push @where_args, @{ $fragment->{args} };
1322 $where_str = '(' . join (' ' . $filter->{conjunction} . ' ', @where_strs) . ')';
1325 args => \@where_args,
1329 my @columns = Koha::Database->new()->schema()->resultset('Item')->result_source->columns;
1330 push @columns, Koha::Database->new()->schema()->resultset('Biblio')->result_source->columns;
1331 push @columns, Koha::Database->new()->schema()->resultset('Biblioitem')->result_source->columns;
1332 my @operators = qw(= != > < >= <= like);
1333 push @operators, 'not like';
1334 my $field = $filter->{field} // q{};
1335 if ( (0 < grep { $_ eq $field } @columns) or (substr($field, 0, 5) eq 'marc:') ) {
1336 my $op = $filter->{operator};
1337 my $query = $filter->{query};
1338 my $ifnull = $filter->{ifnull};
1340 if (!$op or (0 == grep { $_ eq $op } @operators)) {
1341 $op = '='; # default operator
1345 if ($field =~ /^marc:(\d{3})(?:\$(\w))?$/) {
1347 my $marcsubfield = $2;
1348 my ($kohafield) = $dbh->selectrow_array(q|
1349 SELECT kohafield FROM marc_subfield_structure
1350 WHERE tagfield=? AND tagsubfield=? AND frameworkcode=''
1351 |, undef, $marcfield, $marcsubfield);
1354 $column = $kohafield;
1356 # MARC field is not linked to a DB field so we need to use
1357 # ExtractValue on marcxml from biblio_metadata or
1358 # items.more_subfields_xml, depending on the MARC field.
1361 my ($itemfield) = C4::Biblio::GetMarcFromKohaField('items.itemnumber');
1362 if ($marcfield eq $itemfield) {
1363 $sqlfield = 'more_subfields_xml';
1364 $xpath = '//record/datafield/subfield[@code="' . $marcsubfield . '"]';
1366 $sqlfield = 'metadata'; # From biblio_metadata
1367 if ($marcfield < 10) {
1368 $xpath = "//record/controlfield[\@tag=\"$marcfield\"]";
1370 $xpath = "//record/datafield[\@tag=\"$marcfield\"]/subfield[\@code=\"$marcsubfield\"]";
1373 $column = "ExtractValue($sqlfield, '$xpath')";
1379 if ( defined $ifnull ) {
1380 $column = "COALESCE($column, ?)";
1383 if (ref $query eq 'ARRAY') {
1386 } elsif ($op eq '!=') {
1390 str => "$column $op (" . join (',', ('?') x @$query) . ")",
1395 str => "$column $op ?",
1400 if ( defined $ifnull ) {
1401 unshift @{ $where_fragment->{args} }, $ifnull;
1406 return $where_fragment;
1411 my ($items, $total) = SearchItems($filter, $params);
1413 Perform a search among items
1415 $filter is a reference to a hash which can be a filter, or a combination of filters.
1417 A filter has the following keys:
1421 =item * field: the name of a SQL column in table items
1423 =item * query: the value to search in this column
1425 =item * operator: comparison operator. Can be one of = != > < >= <= like 'not like'
1429 A combination of filters hash the following keys:
1433 =item * conjunction: 'AND' or 'OR'
1435 =item * filters: array ref of filters
1439 $params is a reference to a hash that can contain the following parameters:
1443 =item * rows: Number of items to return. 0 returns everything (default: 0)
1445 =item * page: Page to return (return items from (page-1)*rows to (page*rows)-1)
1448 =item * sortby: A SQL column name in items table to sort on
1450 =item * sortorder: 'ASC' or 'DESC'
1457 my ($filter, $params) = @_;
1461 return unless ref $filter eq 'HASH';
1462 return unless ref $params eq 'HASH';
1464 # Default parameters
1465 $params->{rows} ||= 0;
1466 $params->{page} ||= 1;
1467 $params->{sortby} ||= 'itemnumber';
1468 $params->{sortorder} ||= 'ASC';
1470 my ($where_str, @where_args);
1471 my $where_fragment = _SearchItems_build_where_fragment($filter);
1472 if ($where_fragment) {
1473 $where_str = $where_fragment->{str};
1474 @where_args = @{ $where_fragment->{args} };
1477 my $dbh = C4::Context->dbh;
1479 SELECT SQL_CALC_FOUND_ROWS items.*
1481 LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
1482 LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
1483 LEFT JOIN biblio_metadata ON biblio_metadata.biblionumber = biblio.biblionumber
1486 if (defined $where_str and $where_str ne '') {
1487 $query .= qq{ AND $where_str };
1490 $query .= q{ AND biblio_metadata.format = 'marcxml' AND biblio_metadata.schema = ? };
1491 push @where_args, C4::Context->preference('marcflavour');
1493 my @columns = Koha::Database->new()->schema()->resultset('Item')->result_source->columns;
1494 push @columns, Koha::Database->new()->schema()->resultset('Biblio')->result_source->columns;
1495 push @columns, Koha::Database->new()->schema()->resultset('Biblioitem')->result_source->columns;
1496 my $sortby = (0 < grep {$params->{sortby} eq $_} @columns)
1497 ? $params->{sortby} : 'itemnumber';
1498 my $sortorder = (uc($params->{sortorder}) eq 'ASC') ? 'ASC' : 'DESC';
1499 $query .= qq{ ORDER BY $sortby $sortorder };
1501 my $rows = $params->{rows};
1504 my $offset = $rows * ($params->{page}-1);
1505 $query .= qq { LIMIT ?, ? };
1506 push @limit_args, $offset, $rows;
1509 my $sth = $dbh->prepare($query);
1510 my $rv = $sth->execute(@where_args, @limit_args);
1512 return unless ($rv);
1513 my ($total_rows) = $dbh->selectrow_array(q{ SELECT FOUND_ROWS() });
1515 return ($sth->fetchall_arrayref({}), $total_rows);
1519 =head1 OTHER FUNCTIONS
1523 ($indicators, $value) = _find_value($tag, $subfield, $record,$encoding);
1525 Find the given $subfield in the given $tag in the given
1526 MARC::Record $record. If the subfield is found, returns
1527 the (indicators, value) pair; otherwise, (undef, undef) is
1531 Such a function is used in addbiblio AND additem and serial-edit and maybe could be used in Authorities.
1532 I suggest we export it from this module.
1537 my ( $tagfield, $insubfield, $record, $encoding ) = @_;
1540 if ( $tagfield < 10 ) {
1541 if ( $record->field($tagfield) ) {
1542 push @result, $record->field($tagfield)->data();
1547 foreach my $field ( $record->field($tagfield) ) {
1548 my @subfields = $field->subfields();
1549 foreach my $subfield (@subfields) {
1550 if ( @$subfield[0] eq $insubfield ) {
1551 push @result, @$subfield[1];
1552 $indicator = $field->indicator(1) . $field->indicator(2);
1557 return ( $indicator, @result );
1561 =head2 PrepareItemrecordDisplay
1563 PrepareItemrecordDisplay($itemrecord,$bibnum,$itemumber,$frameworkcode);
1565 Returns a hash with all the fields for Display a given item data in a template
1567 The $frameworkcode returns the item for the given frameworkcode, ONLY if bibnum is not provided
1571 sub PrepareItemrecordDisplay {
1573 my ( $bibnum, $itemnum, $defaultvalues, $frameworkcode ) = @_;
1575 my $dbh = C4::Context->dbh;
1576 $frameworkcode = C4::Biblio::GetFrameworkCode($bibnum) if $bibnum;
1577 my ( $itemtagfield, $itemtagsubfield ) = C4::Biblio::GetMarcFromKohaField( "items.itemnumber" );
1579 # Note: $tagslib obtained from GetMarcStructure() in 'unsafe' mode is
1580 # a shared data structure. No plugin (including custom ones) should change
1581 # its contents. See also GetMarcStructure.
1582 my $tagslib = GetMarcStructure( 1, $frameworkcode, { unsafe => 1 } );
1584 # return nothing if we don't have found an existing framework.
1585 return q{} unless $tagslib;
1588 $itemrecord = C4::Items::GetMarcItem( $bibnum, $itemnum );
1592 my $branch_limit = C4::Context->userenv ? C4::Context->userenv->{"branch"} : "";
1594 SELECT authorised_value,lib FROM authorised_values
1597 LEFT JOIN authorised_values_branches ON ( id = av_id )
1602 $query .= qq{ AND ( branchcode = ? OR branchcode IS NULL )} if $branch_limit;
1603 $query .= qq{ ORDER BY lib};
1604 my $authorised_values_sth = $dbh->prepare( $query );
1605 foreach my $tag ( sort keys %{$tagslib} ) {
1608 # loop through each subfield
1610 foreach my $subfield ( sort keys %{ $tagslib->{$tag} } ) {
1611 next if IsMarcStructureInternal($tagslib->{$tag}{$subfield});
1612 next unless ( $tagslib->{$tag}->{$subfield}->{'tab'} );
1613 next if ( $tagslib->{$tag}->{$subfield}->{'tab'} ne "10" );
1615 $subfield_data{tag} = $tag;
1616 $subfield_data{subfield} = $subfield;
1617 $subfield_data{countsubfield} = $cntsubf++;
1618 $subfield_data{kohafield} = $tagslib->{$tag}->{$subfield}->{'kohafield'};
1619 $subfield_data{id} = "tag_".$tag."_subfield_".$subfield."_".int(rand(1000000));
1621 # $subfield_data{marc_lib}=$tagslib->{$tag}->{$subfield}->{lib};
1622 $subfield_data{marc_lib} = $tagslib->{$tag}->{$subfield}->{lib};
1623 $subfield_data{mandatory} = $tagslib->{$tag}->{$subfield}->{mandatory};
1624 $subfield_data{repeatable} = $tagslib->{$tag}->{$subfield}->{repeatable};
1625 $subfield_data{hidden} = "display:none"
1626 if ( ( $tagslib->{$tag}->{$subfield}->{hidden} > 4 )
1627 || ( $tagslib->{$tag}->{$subfield}->{hidden} < -4 ) );
1628 my ( $x, $defaultvalue );
1630 ( $x, $defaultvalue ) = _find_value( $tag, $subfield, $itemrecord );
1632 $defaultvalue = $tagslib->{$tag}->{$subfield}->{defaultvalue} unless $defaultvalue;
1633 if ( !defined $defaultvalue ) {
1634 $defaultvalue = q||;
1636 $defaultvalue =~ s/"/"/g;
1637 # get today date & replace <<YYYY>>, <<MM>>, <<DD>> if provided in the default value
1638 my $today_dt = dt_from_string;
1639 my $year = $today_dt->strftime('%Y');
1640 my $shortyear = $today_dt->strftime('%y');
1641 my $month = $today_dt->strftime('%m');
1642 my $day = $today_dt->strftime('%d');
1643 $defaultvalue =~ s/<<YYYY>>/$year/g;
1644 $defaultvalue =~ s/<<YY>>/$shortyear/g;
1645 $defaultvalue =~ s/<<MM>>/$month/g;
1646 $defaultvalue =~ s/<<DD>>/$day/g;
1648 # And <<USER>> with surname (?)
1650 ( C4::Context->userenv
1651 ? C4::Context->userenv->{'surname'}
1652 : "superlibrarian" );
1653 $defaultvalue =~ s/<<USER>>/$username/g;
1656 my $maxlength = $tagslib->{$tag}->{$subfield}->{maxlength};
1658 # search for itemcallnumber if applicable
1659 if ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.itemcallnumber'
1660 && C4::Context->preference('itemcallnumber') && $itemrecord) {
1661 foreach my $itemcn_pref (split(/,/,C4::Context->preference('itemcallnumber'))){
1662 my $CNtag = substr( $itemcn_pref, 0, 3 );
1663 next unless my $field = $itemrecord->field($CNtag);
1664 my $CNsubfields = substr( $itemcn_pref, 3 );
1665 $defaultvalue = $field->as_string( $CNsubfields, ' ');
1666 last if $defaultvalue;
1669 if ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.itemcallnumber'
1671 && $defaultvalues->{'callnumber'} ) {
1672 if( $itemrecord and $defaultvalues and not $itemrecord->subfield($tag,$subfield) ){
1673 # if the item record exists, only use default value if the item has no callnumber
1674 $defaultvalue = $defaultvalues->{callnumber};
1675 } elsif ( !$itemrecord and $defaultvalues ) {
1676 # if the item record *doesn't* exists, always use the default value
1677 $defaultvalue = $defaultvalues->{callnumber};
1680 if ( ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.holdingbranch' || $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.homebranch' )
1682 && $defaultvalues->{'branchcode'} ) {
1683 if ( $itemrecord and $defaultvalues and not $itemrecord->subfield($tag,$subfield) ) {
1684 $defaultvalue = $defaultvalues->{branchcode};
1687 if ( ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.location' )
1689 && $defaultvalues->{'location'} ) {
1691 if ( $itemrecord and $defaultvalues and not $itemrecord->subfield($tag,$subfield) ) {
1692 # if the item record exists, only use default value if the item has no locationr
1693 $defaultvalue = $defaultvalues->{location};
1694 } elsif ( !$itemrecord and $defaultvalues ) {
1695 # if the item record *doesn't* exists, always use the default value
1696 $defaultvalue = $defaultvalues->{location};
1699 if ( $tagslib->{$tag}->{$subfield}->{authorised_value} ) {
1700 my @authorised_values;
1703 # builds list, depending on authorised value...
1705 if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) {
1706 if ( ( C4::Context->preference("IndependentBranches") )
1707 && !C4::Context->IsSuperLibrarian() ) {
1708 my $sth = $dbh->prepare( "SELECT branchcode,branchname FROM branches WHERE branchcode = ? ORDER BY branchname" );
1709 $sth->execute( C4::Context->userenv->{branch} );
1710 push @authorised_values, ""
1711 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
1712 while ( my ( $branchcode, $branchname ) = $sth->fetchrow_array ) {
1713 push @authorised_values, $branchcode;
1714 $authorised_lib{$branchcode} = $branchname;
1717 my $sth = $dbh->prepare( "SELECT branchcode,branchname FROM branches ORDER BY branchname" );
1719 push @authorised_values, ""
1720 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
1721 while ( my ( $branchcode, $branchname ) = $sth->fetchrow_array ) {
1722 push @authorised_values, $branchcode;
1723 $authorised_lib{$branchcode} = $branchname;
1727 $defaultvalue = C4::Context->userenv ? C4::Context->userenv->{branch} : undef;
1728 if ( $defaultvalues and $defaultvalues->{branchcode} ) {
1729 $defaultvalue = $defaultvalues->{branchcode};
1733 } elsif ( $tagslib->{$tag}->{$subfield}->{authorised_value} eq "itemtypes" ) {
1734 my $itemtypes = Koha::ItemTypes->search_with_localization;
1735 push @authorised_values, "";
1736 while ( my $itemtype = $itemtypes->next ) {
1737 push @authorised_values, $itemtype->itemtype;
1738 $authorised_lib{$itemtype->itemtype} = $itemtype->translated_description;
1740 if ($defaultvalues && $defaultvalues->{'itemtype'}) {
1741 $defaultvalue = $defaultvalues->{'itemtype'};
1745 } elsif ( $tagslib->{$tag}->{$subfield}->{authorised_value} eq "cn_source" ) {
1746 push @authorised_values, "";
1748 my $class_sources = GetClassSources();
1749 my $default_source = $defaultvalue || C4::Context->preference("DefaultClassificationSource");
1751 foreach my $class_source (sort keys %$class_sources) {
1752 next unless $class_sources->{$class_source}->{'used'} or
1753 ($class_source eq $default_source);
1754 push @authorised_values, $class_source;
1755 $authorised_lib{$class_source} = $class_sources->{$class_source}->{'description'};
1758 $defaultvalue = $default_source;
1760 #---- "true" authorised value
1762 $authorised_values_sth->execute(
1763 $tagslib->{$tag}->{$subfield}->{authorised_value},
1764 $branch_limit ? $branch_limit : ()
1766 push @authorised_values, "";
1767 while ( my ( $value, $lib ) = $authorised_values_sth->fetchrow_array ) {
1768 push @authorised_values, $value;
1769 $authorised_lib{$value} = $lib;
1772 $subfield_data{marc_value} = {
1774 values => \@authorised_values,
1775 default => $defaultvalue // q{},
1776 labels => \%authorised_lib,
1778 } elsif ( $tagslib->{$tag}->{$subfield}->{value_builder} ) {
1780 require Koha::FrameworkPlugin;
1781 my $plugin = Koha::FrameworkPlugin->new({
1782 name => $tagslib->{$tag}->{$subfield}->{value_builder},
1785 my $pars = { dbh => $dbh, record => undef, tagslib =>$tagslib, id => $subfield_data{id}, tabloop => undef };
1786 $plugin->build( $pars );
1787 if ( $itemrecord and my $field = $itemrecord->field($tag) ) {
1788 $defaultvalue = $field->subfield($subfield) || q{};
1790 if( !$plugin->errstr ) {
1791 #TODO Move html to template; see report 12176/13397
1792 my $tab= $plugin->noclick? '-1': '';
1793 my $class= $plugin->noclick? ' disabled': '';
1794 my $title= $plugin->noclick? 'No popup': 'Tag editor';
1795 $subfield_data{marc_value} = qq[<input type="text" id="$subfield_data{id}" name="field_value" class="input_marceditor" size="50" maxlength="$maxlength" value="$defaultvalue" /><a href="#" id="buttonDot_$subfield_data{id}" class="buttonDot $class" title="$title">...</a>\n].$plugin->javascript;
1797 warn $plugin->errstr;
1798 $subfield_data{marc_value} = qq(<input type="text" id="$subfield_data{id}" name="field_value" class="input_marceditor" size="50" maxlength="$maxlength" value="$defaultvalue" />); # supply default input form
1801 elsif ( $tag eq '' ) { # it's an hidden field
1802 $subfield_data{marc_value} = qq(<input type="hidden" id="$subfield_data{id}" name="field_value" class="input_marceditor" size="50" maxlength="$maxlength" value="$defaultvalue" />);
1804 elsif ( $tagslib->{$tag}->{$subfield}->{'hidden'} ) { # FIXME: shouldn't input type be "hidden" ?
1805 $subfield_data{marc_value} = qq(<input type="text" id="$subfield_data{id}" name="field_value" class="input_marceditor" size="50" maxlength="$maxlength" value="$defaultvalue" />);
1807 elsif ( length($defaultvalue) > 100
1808 or (C4::Context->preference("marcflavour") eq "UNIMARC" and
1809 300 <= $tag && $tag < 400 && $subfield eq 'a' )
1810 or (C4::Context->preference("marcflavour") eq "MARC21" and
1811 500 <= $tag && $tag < 600 )
1813 # oversize field (textarea)
1814 $subfield_data{marc_value} = qq(<textarea id="$subfield_data{id}" name="field_value" class="input_marceditor" size="50" maxlength="$maxlength">$defaultvalue</textarea>\n");
1816 $subfield_data{marc_value} = qq(<input type="text" id="$subfield_data{id}" name="field_value" class="input_marceditor" size="50" maxlength="$maxlength" value="$defaultvalue" />);
1818 push( @loop_data, \%subfield_data );
1823 if ( $itemrecord && $itemrecord->field($itemtagfield) ) {
1824 $itemnumber = $itemrecord->subfield( $itemtagfield, $itemtagsubfield );
1827 'itemtagfield' => $itemtagfield,
1828 'itemtagsubfield' => $itemtagsubfield,
1829 'itemnumber' => $itemnumber,
1830 'iteminformation' => \@loop_data
1834 sub ToggleNewStatus {
1835 my ( $params ) = @_;
1836 my @rules = @{ $params->{rules} };
1837 my $report_only = $params->{report_only};
1839 my $dbh = C4::Context->dbh;
1841 my @item_columns = map { "items.$_" } Koha::Items->columns;
1842 my @biblioitem_columns = map { "biblioitems.$_" } Koha::Biblioitems->columns;
1844 for my $rule ( @rules ) {
1845 my $age = $rule->{age};
1846 my $conditions = $rule->{conditions};
1847 my $substitutions = $rule->{substitutions};
1848 foreach ( @$substitutions ) {
1849 ( $_->{item_field} ) = ( $_->{field} =~ /items\.(.*)/ );
1856 LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber
1859 for my $condition ( @$conditions ) {
1861 grep { $_ eq $condition->{field} } @item_columns
1862 or grep { $_ eq $condition->{field} } @biblioitem_columns
1864 if ( $condition->{value} =~ /\|/ ) {
1865 my @values = split /\|/, $condition->{value};
1866 $query .= qq| AND $condition->{field} IN (|
1867 . join( ',', ('?') x scalar @values )
1869 push @params, @values;
1871 $query .= qq| AND $condition->{field} = ?|;
1872 push @params, $condition->{value};
1876 if ( defined $age ) {
1877 $query .= q| AND TO_DAYS(NOW()) - TO_DAYS(dateaccessioned) >= ? |;
1880 my $sth = $dbh->prepare($query);
1881 $sth->execute( @params );
1882 while ( my $values = $sth->fetchrow_hashref ) {
1883 my $biblionumber = $values->{biblionumber};
1884 my $itemnumber = $values->{itemnumber};
1885 my $item = Koha::Items->find($itemnumber);
1886 for my $substitution ( @$substitutions ) {
1887 my $field = $substitution->{item_field};
1888 my $value = $substitution->{value};
1889 next unless $substitution->{field};
1890 next if ( defined $values->{ $substitution->{item_field} } and $values->{ $substitution->{item_field} } eq $substitution->{value} );
1891 $item->$field($value);
1892 push @{ $report->{$itemnumber} }, $substitution;
1894 $item->store unless $report_only;