1 package C4::ILSDI::Services;
3 # Copyright 2009 SARL Biblibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
28 use C4::Reserves qw(AddReserve CanBookBeReserved CanItemBeReserved IsAvailableForItemLevelRequest);
30 use C4::AuthoritiesMarc;
36 use C4::Members::Attributes qw(GetBorrowerAttributes);
46 C4::ILS-DI::Services - ILS-DI Services
50 Each function in this module represents an ILS-DI service.
51 They all takes a CGI instance as argument and most of them return a
52 hashref that will be printed by XML::Simple in opac/ilsdi.pl
56 use C4::ILSDI::Services;
62 $out = LookupPatron($cgi);
64 print CGI::header('text/xml');
69 xmldecl => '<?xml version="1.0" encoding="UTF-8" ?>',
70 RootName => 'LookupPatron',
77 =head2 GetAvailability
79 Given a set of biblionumbers or itemnumbers, returns a list with
80 availability of the items associated with the identifiers.
86 list of either biblionumbers or itemnumbers
88 =head3 id_type (Required)
90 defines the type of record identifier being used in the request,
96 =head3 return_type (Optional)
98 requests a particular level of detail in reporting availability,
104 =head3 return_fmt (Optional)
106 requests a particular format or set of formats in reporting
111 sub GetAvailability {
114 my $out = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n";
115 $out .= "<dlf:collection\n";
116 $out .= " xmlns:dlf=\"http://diglib.org/ilsdi/1.1\"\n";
117 $out .= " xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n";
118 $out .= " xsi:schemaLocation=\"http://diglib.org/ilsdi/1.1\n";
119 $out .= " http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd\">\n";
121 foreach my $id ( split( / /, $cgi->param('id') ) ) {
122 if ( $cgi->param('id_type') eq "item" ) {
123 my ( $biblionumber, $status, $msg, $location ) = _availability($id);
125 $out .= " <dlf:record>\n";
126 $out .= " <dlf:bibliographic id=\"" . ( $biblionumber || $id ) . "\" />\n";
127 $out .= " <dlf:items>\n";
128 $out .= " <dlf:item id=\"" . $id . "\">\n";
129 $out .= " <dlf:simpleavailability>\n";
130 $out .= " <dlf:identifier>" . $id . "</dlf:identifier>\n";
131 $out .= " <dlf:availabilitystatus>" . $status . "</dlf:availabilitystatus>\n";
132 if ($msg) { $out .= " <dlf:availabilitymsg>" . $msg . "</dlf:availabilitymsg>\n"; }
133 if ($location) { $out .= " <dlf:location>" . $location . "</dlf:location>\n"; }
134 $out .= " </dlf:simpleavailability>\n";
135 $out .= " </dlf:item>\n";
136 $out .= " </dlf:items>\n";
137 $out .= " </dlf:record>\n";
141 my $items = GetItemnumbersForBiblio($id);
144 $out .= " <dlf:record>\n";
145 $out .= " <dlf:bibliographic id=\"" .$id. "\" />\n";
146 $out .= " <dlf:items>\n";
147 # We loop over the items to clean them
148 foreach my $itemnumber (@$items) {
149 my ( $biblionumber, $status, $msg, $location ) = _availability($itemnumber);
150 $out .= " <dlf:item id=\"" . $itemnumber . "\">\n";
151 $out .= " <dlf:simpleavailability>\n";
152 $out .= " <dlf:identifier>" . $itemnumber . "</dlf:identifier>\n";
153 $out .= " <dlf:availabilitystatus>" . $status . "</dlf:availabilitystatus>\n";
154 if ($msg) { $out .= " <dlf:availabilitymsg>" . $msg . "</dlf:availabilitymsg>\n"; }
155 if ($location) { $out .= " <dlf:location>" . $location . "</dlf:location>\n"; }
156 $out .= " </dlf:simpleavailability>\n";
157 $out .= " </dlf:item>\n";
160 $out .= " </dlf:items>\n";
161 $out .= " </dlf:record>\n";
164 $msg = "Error: could not retrieve availability for this ID";
168 $out .= "</dlf:collection>\n";
175 Given a list of biblionumbers, returns a list of record objects that
176 contain bibliographic information, as well as associated holdings and item
177 information. The caller may request a specific metadata schema for the
178 record objects to be returned.
180 This function behaves similarly to HarvestBibliographicRecords and
181 HarvestExpandedRecords in Data Aggregation, but allows quick, real time
182 lookup by bibliographic identifier.
184 You can use OAI-PMH ListRecords instead of this service.
189 list of system record identifiers
191 Defines the metadata schema in which the records are returned,
200 # Check if the schema is supported. For now, GetRecords only supports MARCXML
201 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
202 return { code => 'UnsupportedSchema' };
207 # Loop over biblionumbers
208 foreach my $biblionumber ( split( / /, $cgi->param('id') ) ) {
210 # Get the biblioitem from the biblionumber
211 my $biblioitem = ( GetBiblioItemByBiblioNumber( $biblionumber, undef ) )[0];
212 if ( not $biblioitem->{'biblionumber'} ) {
213 $biblioitem->{code} = "RecordNotFound";
217 my $record = GetMarcBiblio($biblionumber, $embed_items);
219 $biblioitem->{marcxml} = $record->as_xml_record();
222 # Get most of the needed data
223 my $biblioitemnumber = $biblioitem->{'biblioitemnumber'};
224 my $biblio = Koha::Biblios->find( $biblionumber );
225 my $holds = $biblio->current_holds->unblessed;
226 my $issues = GetBiblioIssues($biblionumber);
227 my $items = GetItemsByBiblioitemnumber($biblioitemnumber);
229 # We loop over the items to clean them
230 foreach my $item (@$items) {
232 # This hides additionnal XML subfields, we don't need these info
233 delete $item->{'more_subfields_xml'};
235 # Display branch names instead of branch codes
236 my $home_library = Koha::Libraries->find( $item->{homebranch} );
237 my $holding_library = Koha::Libraries->find( $item->{holdingbranch} );
238 $item->{'homebranchname'} = $home_library ? $home_library->branchname : '';
239 $item->{'holdingbranchname'} = $holding_library ? $holding_library->branchname : '';
242 # Hashref building...
243 $biblioitem->{'items'}->{'item'} = $items;
244 $biblioitem->{'reserves'}->{'reserve'} = $holds;
245 $biblioitem->{'issues'}->{'issue'} = $issues;
247 push @records, $biblioitem;
250 return { record => \@records };
253 =head2 GetAuthorityRecords
255 Given a list of authority record identifiers, returns a list of record
256 objects that contain the authority records. The function user may request
257 a specific metadata schema for the record objects.
262 list of authority record identifiers
264 specifies the metadata schema of records to be returned, possible values:
269 sub GetAuthorityRecords {
272 # If the user asks for an unsupported schema, return an error code
273 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
274 return { code => 'UnsupportedSchema' };
279 # Let's loop over the authority IDs
280 foreach my $authid ( split( / /, $cgi->param('id') ) ) {
282 # Get the record as XML string, or error code
283 push @records, GetAuthorityXML($authid) || { code => 'RecordNotFound' };
286 return { record => \@records };
291 Looks up a patron in the ILS by an identifier, and returns the borrowernumber.
296 an identifier used to look up the patron in Koha
298 the type of the identifier, possible values:
309 my $patrons = Koha::Patrons->search( { $cgi->param('id_type') => $cgi->param('id') } );
310 unless ( $patrons->count ) {
311 return { message => 'PatronNotFound' };
314 return { id => $patrons->next->borrowernumber };
317 =head2 AuthenticatePatron
319 Authenticates a user's login credentials and returns the identifier for
324 - username (Required)
325 user's login identifier (userid or cardnumber)
326 - password (Required)
331 sub AuthenticatePatron {
333 my $username = $cgi->param('username');
334 my $password = $cgi->param('password');
335 my ($status, $cardnumber, $userid) = C4::Auth::checkpw( C4::Context->dbh, $username, $password );
338 my $patron = Koha::Patrons->find( { cardnumber => $cardnumber } );
339 return { id => $patron->borrowernumber };
342 return { code => 'PatronNotFound' };
348 Returns specified information about the patron, based on options in the
349 request. This function can optionally return patron's contact information,
350 fine information, hold request information, and loan information.
354 - patron_id (Required)
356 - show_contact (Optional, default 1)
357 whether or not to return patron's contact information in the response
358 - show_fines (Optional, default 0)
359 whether or not to return fine information in the response
360 - show_holds (Optional, default 0)
361 whether or not to return hold request information in the response
362 - show_loans (Optional, default 0)
363 whether or not to return loan information request information in the response
371 my $borrowernumber = $cgi->param('patron_id');
372 my $patron = Koha::Patrons->find( $borrowernumber );
373 return { code => 'PatronNotFound' } unless $patron;
375 # Cleaning the borrower hashref
376 my $borrower = $patron->unblessed;
377 my $flags = C4::Members::patronflags( $borrower );
378 $borrower->{'charges'} = $flags->{'CHARGES'}->{'amount'};
379 my $library = Koha::Libraries->find( $borrower->{branchcode} );
380 $borrower->{'branchname'} = $library ? $library->branchname : '';
381 delete $borrower->{'userid'};
382 delete $borrower->{'password'};
384 # Contact fields management
385 if ( defined $cgi->param('show_contact') && $cgi->param('show_contact') eq "0" ) {
387 # Define contact fields
388 my @contactfields = (
389 'email', 'emailpro', 'fax', 'mobile', 'phone', 'phonepro',
390 'streetnumber', 'zipcode', 'city', 'streettype', 'B_address', 'B_city',
391 'B_email', 'B_phone', 'B_zipcode', 'address', 'address2', 'altcontactaddress1',
392 'altcontactaddress2', 'altcontactaddress3', 'altcontactfirstname', 'altcontactphone', 'altcontactsurname', 'altcontactzipcode'
396 foreach my $field (@contactfields) {
397 delete $borrower->{$field};
402 if ( $cgi->param('show_fines') && $cgi->param('show_fines') eq "1" ) {
404 for ( my $i = 1 ; my @charge = getcharges( $borrowernumber, undef, $i ) ; $i++ ) {
405 push( @charges, @charge );
407 $borrower->{'fines'}->{'fine'} = \@charges;
410 # Reserves management
411 if ( $cgi->param('show_holds') && $cgi->param('show_holds') eq "1" ) {
413 # Get borrower's reserves
414 my $holds = $patron->holds;
415 while ( my $hold = $holds->next ) {
417 my ( $item, $biblio, $biblioitem ) = ( {}, {}, {} );
418 # Get additional informations
419 if ( $hold->itemnumber ) { # item level holds
420 $item = Koha::Items->find( $hold->itemnumber );
421 $biblio = $item->biblio;
422 $biblioitem = $biblio->biblioitem;
424 # Remove unwanted fields
425 $item = $item->unblessed;
426 delete $item->{more_subfields_xml};
427 $biblio = $biblio->unblessed;
428 $biblioitem = $biblioitem->unblessed;
431 # Add additional fields
432 my $unblessed_hold = $hold->unblessed;
433 $unblessed_hold->{item} = { %$item, %$biblio, %$biblioitem };
434 my $library = Koha::Libraries->find( $hold->branchcode );
435 my $branchname = $library ? $library->branchname : '';
436 $unblessed_hold->{branchname} = $branchname;
437 $biblio = Koha::Biblios->find( $hold->biblionumber ); # Should be $hold->get_biblio
438 $unblessed_hold->{title} = $biblio ? $biblio->title : ''; # Just in case, but should not be needed
440 push @{ $borrower->{holds}{hold} }, $unblessed_hold;
446 if ( $cgi->param('show_loans') && $cgi->param('show_loans') eq "1" ) {
447 my $issues = GetPendingIssues($borrowernumber);
448 foreach my $issue ( @$issues ){
449 $issue->{'issuedate'} = $issue->{'issuedate'}->strftime('%Y-%m-%d %H:%M');
450 $issue->{'date_due'} = $issue->{'date_due'}->strftime('%Y-%m-%d %H:%M');
452 $borrower->{'loans'}->{'loan'} = $issues;
455 if ( $cgi->param('show_attributes') eq "1" ) {
456 my $attrs = GetBorrowerAttributes( $borrowernumber, 0, 1 );
457 $borrower->{'attributes'} = $attrs;
463 =head2 GetPatronStatus
465 Returns a patron's status information.
469 - patron_id (Required)
474 sub GetPatronStatus {
478 my $borrowernumber = $cgi->param('patron_id');
479 my $patron = Koha::Patrons->find( $borrowernumber );
480 return { code => 'PatronNotFound' } unless $patron;
484 type => $patron->categorycode,
486 expiry => $patron->dateexpiry,
492 Returns information about the services available on a particular item for
497 - patron_id (Required)
507 # Get the member, or return an error code if not found
508 my $borrowernumber = $cgi->param('patron_id');
509 my $patron = Koha::Patrons->find( $borrowernumber );
510 return { code => 'PatronNotFound' } unless $patron;
512 my $borrower = $patron->unblessed;
513 # Get the item, or return an error code if not found
514 my $itemnumber = $cgi->param('item_id');
515 my $item = GetItem( $itemnumber );
516 return { code => 'RecordNotFound' } unless $$item{itemnumber};
520 # Reserve level management
521 my $biblionumber = $item->{'biblionumber'};
522 my $canbookbereserved = CanBookBeReserved( $borrower, $biblionumber );
523 if ($canbookbereserved eq 'OK') {
524 push @availablefor, 'title level hold';
525 my $canitembereserved = IsAvailableForItemLevelRequest($item, $borrower);
526 if ($canitembereserved) {
527 push @availablefor, 'item level hold';
531 # Reserve cancellation management
532 my $holds = $patron->holds;
534 while ( my $hold = $holds->next ) { # FIXME This could be improved
535 push @reserveditems, $hold->itemnumber;
537 if ( grep { $itemnumber eq $_ } @reserveditems ) {
538 push @availablefor, 'hold cancellation';
542 my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
544 push @availablefor, 'loan renewal';
548 my $barcode = $item->{'barcode'} || '';
549 $barcode = barcodedecode($barcode) if ( $barcode && C4::Context->preference('itemBarcodeInputFilter') );
551 my ( $issuingimpossible, $needsconfirmation ) = CanBookBeIssued( $borrower, $barcode );
553 # TODO push @availablefor, 'loan';
557 $out->{'AvailableFor'} = \@availablefor;
564 Extends the due date for a borrower's existing issue.
568 - patron_id (Required)
572 - desired_due_date (Required)
573 the date the patron would like the item returned by
580 # Get borrower infos or return an error code
581 my $borrowernumber = $cgi->param('patron_id');
582 my $patron = Koha::Patrons->find( $borrowernumber );
583 return { code => 'PatronNotFound' } unless $patron;
585 # Get the item, or return an error code
586 my $itemnumber = $cgi->param('item_id');
587 my $item = GetItem( $itemnumber );
588 return { code => 'RecordNotFound' } unless $$item{itemnumber};
590 # Add renewal if possible
591 my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
592 if ( $renewal[0] ) { AddRenewal( $borrowernumber, $itemnumber ); }
594 my $issue = Koha::Checkouts->find( { itemnumber => $itemnumber } ) or return; # FIXME should be handled
598 $out->{'renewals'} = $issue->renewals;
599 $out->{date_due} = dt_from_string($issue->date_due)->strftime('%Y-%m-%d %H:%S');
600 $out->{'success'} = $renewal[0];
601 $out->{'error'} = $renewal[1];
608 Creates, for a borrower, a biblio-level hold reserve.
612 - patron_id (Required)
616 - request_location (Required)
617 IP address where the end user request is being placed
618 - pickup_location (Optional)
619 a branch code indicating the location to which to deliver the item for pickup
620 - needed_before_date (Optional)
621 date after which hold request is no longer needed
622 - pickup_expiry_date (Optional)
623 date after which item returned to shelf if item is not picked up
630 # Get the borrower or return an error code
631 my $borrowernumber = $cgi->param('patron_id');
632 my $patron = Koha::Patrons->find( $borrowernumber );
633 return { code => 'PatronNotFound' } unless $patron;
635 # Get the biblio record, or return an error code
636 my $biblionumber = $cgi->param('bib_id');
637 my $biblio = Koha::Biblios->find( $biblionumber );
638 return { code => 'RecordNotFound' } unless $biblio;
640 my $title = $biblio ? $biblio->title : '';
642 # Check if the biblio can be reserved
643 return { code => 'NotHoldable' } unless CanBookBeReserved( $borrowernumber, $biblionumber ) eq 'OK';
647 # Pickup branch management
648 if ( $cgi->param('pickup_location') ) {
649 $branch = $cgi->param('pickup_location');
650 return { code => 'LocationNotFound' } unless Koha::Libraries->find($branch);
651 } else { # if the request provide no branch, use the borrower's branch
652 $branch = $patron->branchcode;
656 # $branch, $borrowernumber, $biblionumber,
657 # $constraint, $bibitems, $priority, $resdate, $expdate, $notes,
658 # $title, $checkitem, $found
659 my $priority= C4::Reserves::CalculatePriority( $biblionumber );
660 AddReserve( $branch, $borrowernumber, $biblionumber, undef, $priority, undef, undef, undef, $title, undef, undef );
664 $out->{'title'} = $title;
665 my $library = Koha::Libraries->find( $branch );
666 $out->{'pickup_location'} = $library ? $library->branchname : '';
668 # TODO $out->{'date_available'} = '';
675 Creates, for a borrower, an item-level hold request on a specific item of
676 a bibliographic record in Koha.
680 - patron_id (Required)
686 - pickup_location (Optional)
687 a branch code indicating the location to which to deliver the item for pickup
688 - needed_before_date (Optional)
689 date after which hold request is no longer needed
690 - pickup_expiry_date (Optional)
691 date after which item returned to shelf if item is not picked up
698 # Get the borrower or return an error code
699 my $borrowernumber = $cgi->param('patron_id');
700 my $patron = Koha::Patrons->find( $borrowernumber );
701 return { code => 'PatronNotFound' } unless $patron;
703 # Get the biblio or return an error code
704 my $biblionumber = $cgi->param('bib_id');
705 my $biblio = Koha::Biblios->find( $biblionumber );
706 return { code => 'RecordNotFound' } unless $biblio;
708 my $title = $biblio ? $biblio->title : '';
710 # Get the item or return an error code
711 my $itemnumber = $cgi->param('item_id');
712 my $item = GetItem( $itemnumber );
713 return { code => 'RecordNotFound' } unless $$item{itemnumber};
715 # If the biblio does not match the item, return an error code
716 return { code => 'RecordNotFound' } if $$item{biblionumber} ne $biblio->biblionumber;
718 # Check for item disponibility
719 my $canitembereserved = C4::Reserves::CanItemBeReserved( $borrowernumber, $itemnumber );
720 my $canbookbereserved = C4::Reserves::CanBookBeReserved( $borrowernumber, $biblionumber );
721 return { code => 'NotHoldable' } unless $canbookbereserved eq 'OK' and $canitembereserved eq 'OK';
723 # Pickup branch management
725 if ( $cgi->param('pickup_location') ) {
726 $branch = $cgi->param('pickup_location');
727 return { code => 'LocationNotFound' } unless Koha::Libraries->find($branch);
728 } else { # if the request provide no branch, use the borrower's branch
729 $branch = $patron->branchcode;
733 # $branch, $borrowernumber, $biblionumber,
734 # $constraint, $bibitems, $priority, $resdate, $expdate, $notes,
735 # $title, $checkitem, $found
736 my $priority= C4::Reserves::CalculatePriority( $biblionumber );
737 AddReserve( $branch, $borrowernumber, $biblionumber, undef, $priority, undef, undef, undef, $title, $itemnumber, undef );
741 my $library = Koha::Libraries->find( $branch );
742 $out->{'pickup_location'} = $library ? $library->branchname : '';
744 # TODO $out->{'date_available'} = '';
751 Cancels an active reserve request for the borrower.
755 - patron_id (Required)
765 # Get the borrower or return an error code
766 my $borrowernumber = $cgi->param('patron_id');
767 my $patron = Koha::Patrons->find( $borrowernumber );
768 return { code => 'PatronNotFound' } unless $patron;
770 # Get the reserve or return an error code
771 my $reserve_id = $cgi->param('item_id');
772 my $reserve = C4::Reserves::GetReserve($reserve_id);
773 return { code => 'RecordNotFound' } unless $reserve;
774 return { code => 'RecordNotFound' } unless ($reserve->{borrowernumber} == $borrowernumber);
776 C4::Reserves::CancelReserve({reserve_id => $reserve_id});
778 return { code => 'Canceled' };
783 Returns, for an itemnumber, an array containing availability information.
785 my ($biblionumber, $status, $msg, $location) = _availability($id);
790 my ($itemnumber) = @_;
791 my $item = GetItem( $itemnumber, undef, undef );
793 if ( not $item->{'itemnumber'} ) {
794 return ( undef, 'unknown', 'Error: could not retrieve availability for this ID', undef );
797 my $biblionumber = $item->{'biblioitemnumber'};
798 my $library = Koha::Libraries->find( $item->{holdingbranch} );
799 my $location = $library ? $library->branchname : '';
801 if ( $item->{'notforloan'} ) {
802 return ( $biblionumber, 'not available', 'Not for loan', $location );
803 } elsif ( $item->{'onloan'} ) {
804 return ( $biblionumber, 'not available', 'Checked out', $location );
805 } elsif ( $item->{'itemlost'} ) {
806 return ( $biblionumber, 'not available', 'Item lost', $location );
807 } elsif ( $item->{'withdrawn'} ) {
808 return ( $biblionumber, 'not available', 'Item withdrawn', $location );
809 } elsif ( $item->{'damaged'} ) {
810 return ( $biblionumber, 'not available', 'Item damaged', $location );
812 return ( $biblionumber, 'available', undef, $location );