<<

NAME

C4::Items - item management functions

DESCRIPTION

This module contains an API for manipulating item records in Koha, and is used by cataloguing, circulation, acquisitions, and serials management.

A Koha item record is stored in two places: the items table and embedded in a MARC tag in the XML version of the associated bib record in biblioitems.marcxml. This is done to allow the item information to be readily indexed (e.g., by Zebra), but means that each item modification transaction must keep the items table and the MARC XML in sync at all times.

Consequently, all code that creates, modifies, or deletes item records must use an appropriate function from C4::Items. If no existing function is suitable, it is better to add one to C4::Items than to use add one-off SQL statements to add or modify items.

The items table will be considered authoritative. In other words, if there is ever a discrepancy between the items table and the MARC XML, the items table should be considered accurate.

HISTORICAL NOTE

Most of the functions in C4::Items were originally in the C4::Biblio module.

CORE EXPORTED FUNCTIONS

The following functions are meant for use by users of C4::Items

GetItem

  $item = GetItem($itemnumber,$barcode,$serial);

Return item information, for a given itemnumber or barcode. The return value is a hashref mapping item column names to values. If $serial is true, include serial publication data.

CartToShelf

  CartToShelf($itemnumber);

Set the current shelving location of the item record to its stored permanent shelving location. This is primarily used to indicate when an item whose current location is a special processing ('PROC') or shelving cart ('CART') location is back in the stacks.

ShelfToCart

  ShelfToCart($itemnumber);

Set the current shelving location of the item to shelving cart ('CART').

AddItemFromMarc

  my ($biblionumber, $biblioitemnumber, $itemnumber) 
      = AddItemFromMarc($source_item_marc, $biblionumber);

Given a MARC::Record object containing an embedded item record and a biblionumber, create a new item record.

AddItem

  my ($biblionumber, $biblioitemnumber, $itemnumber) 
      = AddItem($item, $biblionumber[, $dbh, $frameworkcode, $unlinked_item_subfields]);

Given a hash containing item column names as keys, create a new Koha item record.

The first two optional parameters ($dbh and $frameworkcode) do not need to be supplied for general use; they exist simply to allow them to be picked up from AddItemFromMarc.

The final optional parameter, $unlinked_item_subfields, contains an arrayref containing subfields present in the original MARC representation of the item (e.g., from the item editor) that are not mapped to items columns directly but should instead be stored in items.more_subfields_xml and included in the biblio items tag for display and indexing.

AddItemBatchFromMarc

  ($itemnumber_ref, $error_ref) = AddItemBatchFromMarc($record, 
             $biblionumber, $biblioitemnumber, $frameworkcode);

Efficiently create item records from a MARC biblio record with embedded item fields. This routine is suitable for batch jobs.

This API assumes that the bib record has already been saved to the biblio and biblioitems tables. It does not expect that biblioitems.marc and biblioitems.marcxml are populated, but it will do so via a call to ModBibiloMarc.

The goal of this API is to have a similar effect to using AddBiblio and AddItems in succession, but without inefficient repeated parsing of the MARC XML bib record.

This function returns an arrayref of new itemsnumbers and an arrayref of item errors encountered during the processing. Each entry in the errors list is a hashref containing the following keys:

item_sequence

Sequence number of original item tag in the MARC record.

item_barcode

Item barcode, provide to assist in the construction of useful error messages.

error_code

Code representing the error condition. Can be 'duplicate_barcode', 'invalid_homebranch', or 'invalid_holdingbranch'.

error_information

Additional information appropriate to the error condition.

ModItemFromMarc

  ModItemFromMarc($item_marc, $biblionumber, $itemnumber);

This function updates an item record based on a supplied MARC::Record object containing an embedded item field. This API is meant for the use of additem.pl; for other purposes, ModItem should be used.

This function uses the hash %default_values_for_mod_from_marc, which contains default values for item fields to apply when modifying an item. This is needed because if an item field's value is cleared, TransformMarcToKoha does not include the column in the hash that's passed to ModItem, which without use of this hash makes it impossible to clear an item field's value. See bug 2466.

Note that only columns that can be directly changed from the cataloging and serials item editors are included in this hash.

Returns item record

ModItem

  ModItem({ column => $newvalue }, $biblionumber, $itemnumber);

Change one or more columns in an item record and update the MARC representation of the item.

The first argument is a hashref mapping from item column names to the new values. The second and third arguments are the biblionumber and itemnumber, respectively.

The fourth, optional parameter, $unlinked_item_subfields, contains an arrayref containing subfields present in the original MARC representation of the item (e.g., from the item editor) that are not mapped to items columns directly but should instead be stored in items.more_subfields_xml and included in the biblio items tag for display and indexing.

If one of the changed columns is used to calculate the derived value of a column such as items.cn_sort, this routine will perform the necessary calculation and set the value.

ModItemTransfer

  ModItemTransfer($itenumber, $frombranch, $tobranch);

Marks an item as being transferred from one branch to another.

ModDateLastSeen

  ModDateLastSeen($itemnum);

Mark item as seen. Is called when an item is issued, returned or manually marked during inventory/stocktaking. $itemnum is the item number

DelItem

  DelItem({ itemnumber => $itemnumber, [ biblionumber => $biblionumber ] } );

Exported function (core API) for deleting an item record in Koha.

CheckItemPreSave

    my $item_ref = TransformMarcToKoha($marc, 'items');
    # do stuff
    my %errors = CheckItemPreSave($item_ref);
    if (exists $errors{'duplicate_barcode'}) {
        print "item has duplicate barcode: ", $errors{'duplicate_barcode'}, "\n";
    } elsif (exists $errors{'invalid_homebranch'}) {
        print "item has invalid home branch: ", $errors{'invalid_homebranch'}, "\n";
    } elsif (exists $errors{'invalid_holdingbranch'}) {
        print "item has invalid holding branch: ", $errors{'invalid_holdingbranch'}, "\n";
    } else {
        print "item is OK";
    }

Given a hashref containing item fields, determine if it can be inserted or updated in the database. Specifically, checks for database integrity issues, and returns a hash containing any of the following keys, if applicable.

duplicate_barcode

Barcode, if it duplicates one already found in the database.

invalid_homebranch

Home branch, if not defined in branches table.

invalid_holdingbranch

Holding branch, if not defined in branches table.

This function does NOT implement any policy-related checks, e.g., whether current operator is allowed to save an item that has a given branch code.

EXPORTED SPECIAL ACCESSOR FUNCTIONS

The following functions provide various ways of getting an item record, a set of item records, or lists of authorized values for certain item fields.

Some of the functions in this group are candidates for refactoring -- for example, some of the code in GetItemsByBiblioitemnumber and GetItemsInfo has copy-and-paste work.

GetItemStatus

  $itemstatushash = GetItemStatus($fwkcode);

Returns a list of valid values for the items.notforloan field.

NOTE: does not return an individual item's status.

Can be MARC dependent. fwkcode is optional. But basically could be can be loan or not Create a status selector with the following code

in PERL SCRIPT

 my $itemstatushash = getitemstatus;
 my @itemstatusloop;
 foreach my $thisstatus (keys %$itemstatushash) {
     my %row =(value => $thisstatus,
                 statusname => $itemstatushash->{$thisstatus}->{'statusname'},
             );
     push @itemstatusloop, \%row;
 }
 $template->param(statusloop=>\@itemstatusloop);

in TEMPLATE

<select name="statusloop" id="statusloop"> <option value="">Default</option> [% FOREACH statusloo IN statusloop %] [% IF ( statusloo.selected ) %] <option value="[% statusloo.value %]" selected="selected">[% statusloo.statusname %]</option> [% ELSE %] <option value="[% statusloo.value %]">[% statusloo.statusname %]</option> [% END %] [% END %] </select>

GetItemLocation

  $itemlochash = GetItemLocation($fwk);

Returns a list of valid values for the items.location field.

NOTE: does not return an individual item's location.

where fwk stands for an optional framework code. Create a location selector with the following code

in PERL SCRIPT

  my $itemlochash = getitemlocation;
  my @itemlocloop;
  foreach my $thisloc (keys %$itemlochash) {
      my $selected = 1 if $thisbranch eq $branch;
      my %row =(locval => $thisloc,
                  selected => $selected,
                  locname => $itemlochash->{$thisloc},
               );
      push @itemlocloop, \%row;
  }
  $template->param(itemlocationloop => \@itemlocloop);

in TEMPLATE

  <select name="location">
      <option value="">Default</option>
  <!-- TMPL_LOOP name="itemlocationloop" -->
      <option value="<!-- TMPL_VAR name="locval" -->" <!-- TMPL_IF name="selected" -->selected<!-- /TMPL_IF -->><!-- TMPL_VAR name="locname" --></option>
  <!-- /TMPL_LOOP -->
  </select>

GetLostItems

  $items = GetLostItems( $where );

This function gets a list of lost items.

input:

$where is a hashref. it containts a field of the items table as key and the value to match as value. For example:

{ barcode => 'abc123', homebranch => 'CPL', }

return:

$items is a reference to an array full of hashrefs with columns from the "items" table as keys.

usage in the perl script:
  my $where = { barcode => '0001548' };
  my $items = GetLostItems( $where );
  $template->param( itemsloop => $items );

GetItemsForInventory

($itemlist, $iTotalRecords) = GetItemsForInventory( { minlocation => $minlocation, maxlocation => $maxlocation, location => $location, itemtype => $itemtype, ignoreissued => $ignoreissued, datelastseen => $datelastseen, branchcode => $branchcode, branch => $branch, offset => $offset, size => $size, statushash => $statushash, interface => $interface, } );

Retrieve a list of title/authors/barcode/callnumber, for biblio inventory.

The sub returns a reference to a list of hashes, each containing itemnumber, author, title, barcode, item callnumber, and date last seen. It is ordered by callnumber then title.

The required minlocation & maxlocation parameters are used to specify a range of item callnumbers the datelastseen can be used to specify that you want to see items not seen since a past date only. offset & size can be used to retrieve only a part of the whole listing (defaut behaviour) $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.

$iTotalRecords is the number of rows that would have been returned without the $offset, $size limit clause

GetItemsCount

  $count = &GetItemsCount( $biblionumber);

This function return count of item with $biblionumber

GetItemInfosOf

  GetItemInfosOf(@itemnumbers);

GetItemsByBiblioitemnumber

  GetItemsByBiblioitemnumber($biblioitemnumber);

Returns an arrayref of hashrefs suitable for use in a TMPL_LOOP Called by C4::XISBN

GetItemsInfo

  @results = GetItemsInfo($biblionumber);

Returns information about items with the given biblionumber.

GetItemsInfo returns a list of references-to-hash. Each element contains a number of keys. Most of them are attributes from the biblio, biblioitems, items, and itemtypes tables in the Koha database. Other keys include:

$data->{branchname}

The name (not the code) of the branch to which the book belongs.

$data->{datelastseen}

This is simply items.datelastseen, except that while the date is stored in YYYY-MM-DD format in the database, here it is converted to DD/MM/YYYY format. A NULL date is returned as //.

$data->{datedue}
$data->{class}

This is the concatenation of biblioitems.classification, the book's Dewey code, and biblioitems.subclass.

$data->{ocount}

I think this is the number of copies of the book available.

$data->{order}

If this is set, it is set to One Order.

GetItemsLocationInfo

  my @itemlocinfo = GetItemsLocationInfo($biblionumber);

Returns the branch names, shelving location and itemcallnumber for each item attached to the biblio in question

GetItemsInfo returns a list of references-to-hash. Data returned:

$data->{homebranch}

Branch Name of the item's homebranch

$data->{holdingbranch}

Branch Name of the item's holdingbranch

$data->{location}

Item's shelving location code

$data->{location_intranet}

The intranet description for the Shelving Location as set in authorised_values 'LOC'

$data->{location_opac}

The OPAC description for the Shelving Location as set in authorised_values 'LOC'. Falls back to intranet description if no OPAC description is set.

$data->{itemcallnumber}

Item's itemcallnumber

$data->{cn_sort}

Item's call number normalized for sorting

GetHostItemsInfo

        $hostiteminfo = GetHostItemsInfo($hostfield);
        Returns the iteminfo for items linked to records via a host field

GetLastAcquisitions

  my $lastacq = GetLastAcquisitions({'branches' => ('branch1','branch2'), 
                                    'itemtypes' => ('BK','BD')}, 10);

GetItemnumbersForBiblio

  my $itemnumbers = GetItemnumbersForBiblio($biblionumber);

Given a single biblionumber, return an arrayref of all the corresponding itemnumbers

get_itemnumbers_of

  my @itemnumbers_of = get_itemnumbers_of(@biblionumbers);

Given a list of biblionumbers, return the list of corresponding itemnumbers for each biblionumber.

Return a reference on a hash where keys are biblionumbers and values are references on array of itemnumbers.

get_hostitemnumbers_of

  my @itemnumbers_of = get_hostitemnumbers_of($biblionumber);

Given a biblionumber, return the list of corresponding itemnumbers that are linked to it via host fields

Return a reference on a hash where key is a biblionumber and values are references on array of itemnumbers.

GetItemnumberFromBarcode

  $result = GetItemnumberFromBarcode($barcode);

GetBarcodeFromItemnumber

  $result = GetBarcodeFromItemnumber($itemnumber);

GetHiddenItemnumbers

    my @itemnumbers_to_hide = GetHiddenItemnumbers(@items);

Given a list of items it checks which should be hidden from the OPAC given the current configuration. Returns a list of itemnumbers corresponding to those that should be hidden.

get_item_authorised_values

find the types and values for all authorised values assigned to this item.

parameters: itemnumber

returns: a hashref malling the authorised value to the value set for this itemnumber

    $authorised_values = {
             'CCODE'      => undef,
             'DAMAGED'    => '0',
             'LOC'        => '3',
             'LOST'       => '0'
             'NOT_LOAN'   => '0',
             'RESTRICTED' => undef,
             'STACK'      => undef,
             'WITHDRAWN'  => '0',
             'branches'   => 'CPL',
             'cn_source'  => undef,
             'itemtypes'  => 'SER',
           };

Notes: see C4::Biblio::get_biblio_authorised_values for a similar method at the biblio level.

get_authorised_value_images

find a list of icons that are appropriate for display based on the authorised values for a biblio.

parameters: listref of authorised values, such as comes from get_item_authorised_values or from C4::Biblio::get_biblio_authorised_values

returns: listref of hashrefs for each image. Each hashref looks like this:

      { imageurl => '/intranet-tmpl/prog/img/itemtypeimg/npl/WEB.gif',
        label    => '',
        category => '',
        value    => '', }

Notes: Currently, I put on the full path to the images on the staff side. This should either be configurable or not done at all. Since I have to deal with 'intranet' or 'opac' in get_biblio_authorised_values, perhaps I should be passing it in.

LIMITED USE FUNCTIONS

The following functions, while part of the public API, are not exported. This is generally because they are meant to be used by only one script for a specific purpose, and should not be used in any other context without careful thought.

GetMarcItem

  my $item_marc = GetMarcItem($biblionumber, $itemnumber);

Returns MARC::Record of the item passed in parameter. This function is meant for use only in cataloguing/additem.pl, where it is needed to support that script's MARC-like editor.

PRIVATE FUNCTIONS AND VARIABLES

The following functions are not meant to be called directly, but are documented in order to explain the inner workings of C4::Items.

%derived_columns

This hash keeps track of item columns that are strictly derived from other columns in the item record and are not meant to be set independently.

Each key in the hash should be the name of a column (as named by TransformMarcToKoha). Each value should be hashref whose keys are the columns on which the derived column depends. The hashref should also contain a 'BUILDER' key that is a reference to a sub that calculates the derived value.

_set_derived_columns_for_add

  _set_derived_column_for_add($item);

Given an item hash representing a new item to be added, calculate any derived columns. Currently the only such column is items.cn_sort.

_set_derived_columns_for_mod

  _set_derived_column_for_mod($item);

Given an item hash representing a new item to be modified. calculate any derived columns. Currently the only such column is items.cn_sort.

This routine differs from _set_derived_columns_for_add in that it needs to handle partial item records. In other words, the caller of ModItem may have supplied only one or two columns to be changed, so this function needs to determine whether any of the columns to be changed affect any of the derived columns. Also, if a derived column depends on more than one column, but the caller is not changing all of then, this routine retrieves the unchanged values from the database in order to ensure a correct calculation.

_do_column_fixes_for_mod

  _do_column_fixes_for_mod($item);

Given an item hashref containing one or more columns to modify, fix up certain values. Specifically, set to 0 any passed value of notforloan, damaged, itemlost, or withdrawn that is either undefined or contains the empty string.

_get_single_item_column

  _get_single_item_column($column, $itemnumber);

Retrieves the value of a single column from an items row specified by $itemnumber.

_calc_items_cn_sort

  _calc_items_cn_sort($item, $source_values);

Helper routine to calculate items.cn_sort.

_set_defaults_for_add

  _set_defaults_for_add($item_hash);

Given an item hash representing an item to be added, set correct default values for columns whose default value is not handled by the DBMS. This includes the following columns:

_koha_new_item

  my ($itemnumber,$error) = _koha_new_item( $item, $barcode );

Perform the actual insert into the items table.

MoveItemFromBiblio

  MoveItemFromBiblio($itenumber, $frombiblio, $tobiblio);

Moves an item from a biblio to another

Returns undef if the move failed or the biblionumber of the destination record otherwise

DelItemCheck

   DelItemCheck($dbh, $biblionumber, $itemnumber);

Exported function (core API) for deleting an item record in Koha if there no current issue.

_koha_modify_item

  my ($itemnumber,$error) =_koha_modify_item( $item );

Perform the actual update of the items row. Note that this routine accepts a hashref specifying the columns to update.

_koha_delete_item

  _koha_delete_item( $itemnum );

Internal function to delete an item record from the koha tables

_marc_from_item_hash

  my $item_marc = _marc_from_item_hash($item, $frameworkcode[, $unlinked_item_subfields]);

Given an item hash representing a complete item record, create a MARC::Record object containing an embedded tag representing that item.

The third, optional parameter $unlinked_item_subfields is an arrayref of subfields (not mapped to items fields per the framework) to be added to the MARC representation of the item.

_repack_item_errors

Add an error message hash generated by CheckItemPreSave to a list of errors.

_get_unlinked_item_subfields

  my $unlinked_item_subfields = _get_unlinked_item_subfields($original_item_marc, $frameworkcode);

_get_unlinked_subfields_xml

  my $unlinked_subfields_xml = _get_unlinked_subfields_xml($unlinked_item_subfields);

_parse_unlinked_item_subfields_from_xml

  my $unlinked_item_subfields = _parse_unlinked_item_subfields_from_xml($whole_item->{'more_subfields_xml'}):

GetAnalyticsCount

  $count= &GetAnalyticsCount($itemnumber)

counts Usage of itemnumber in Analytical bibliorecords.

GetItemHolds

  $holds = &GetItemHolds($biblionumber, $itemnumber);

This function return the count of holds with $biblionumber and $itemnumber

SearchItemsByField

    my $items = SearchItemsByField($field, $value);

SearchItemsByField will search for items on a specific given field. For instance you can search all items with a specific stocknumber like this:

    my $items = SearchItemsByField('stocknumber', $stocknumber);

SearchItems

    my ($items, $total) = SearchItems($filter, $params);

Perform a search among items

$filter is a reference to a hash which can be a filter, or a combination of filters.

A filter has the following keys:

A combination of filters hash the following keys:

$params is a reference to a hash that can contain the following parameters:

OTHER FUNCTIONS

_find_value

  ($indicators, $value) = _find_value($tag, $subfield, $record,$encoding);

Find the given $subfield in the given $tag in the given MARC::Record $record. If the subfield is found, returns the (indicators, value) pair; otherwise, (undef, undef) is returned.

PROPOSITION : Such a function is used in addbiblio AND additem and serial-edit and maybe could be used in Authorities. I suggest we export it from this module.

PrepareItemrecordDisplay

  PrepareItemrecordDisplay($itemrecord,$bibnum,$itemumber,$frameworkcode);

Returns a hash with all the fields for Display a given item data in a template

The $frameworkcode returns the item for the given frameworkcode, ONLY if bibnum is not provided

<<