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);
47 C4::ILS-DI::Services - ILS-DI Services
51 Each function in this module represents an ILS-DI service.
52 They all takes a CGI instance as argument and most of them return a
53 hashref that will be printed by XML::Simple in opac/ilsdi.pl
57 use C4::ILSDI::Services;
63 $out = LookupPatron($cgi);
65 print CGI::header('text/xml');
70 xmldecl => '<?xml version="1.0" encoding="UTF-8" ?>',
71 RootName => 'LookupPatron',
78 =head2 GetAvailability
80 Given a set of biblionumbers or itemnumbers, returns a list with
81 availability of the items associated with the identifiers.
87 list of either biblionumbers or itemnumbers
89 =head3 id_type (Required)
91 defines the type of record identifier being used in the request,
97 =head3 return_type (Optional)
99 requests a particular level of detail in reporting availability,
105 =head3 return_fmt (Optional)
107 requests a particular format or set of formats in reporting
112 sub GetAvailability {
115 my $out = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n";
116 $out .= "<dlf:collection\n";
117 $out .= " xmlns:dlf=\"http://diglib.org/ilsdi/1.1\"\n";
118 $out .= " xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n";
119 $out .= " xsi:schemaLocation=\"http://diglib.org/ilsdi/1.1\n";
120 $out .= " http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd\">\n";
122 foreach my $id ( split( / /, $cgi->param('id') ) ) {
123 if ( $cgi->param('id_type') eq "item" ) {
124 my ( $biblionumber, $status, $msg, $location ) = _availability($id);
126 $out .= " <dlf:record>\n";
127 $out .= " <dlf:bibliographic id=\"" . ( $biblionumber || $id ) . "\" />\n";
128 $out .= " <dlf:items>\n";
129 $out .= " <dlf:item id=\"" . $id . "\">\n";
130 $out .= " <dlf:simpleavailability>\n";
131 $out .= " <dlf:identifier>" . $id . "</dlf:identifier>\n";
132 $out .= " <dlf:availabilitystatus>" . $status . "</dlf:availabilitystatus>\n";
133 if ($msg) { $out .= " <dlf:availabilitymsg>" . $msg . "</dlf:availabilitymsg>\n"; }
134 if ($location) { $out .= " <dlf:location>" . $location . "</dlf:location>\n"; }
135 $out .= " </dlf:simpleavailability>\n";
136 $out .= " </dlf:item>\n";
137 $out .= " </dlf:items>\n";
138 $out .= " </dlf:record>\n";
142 my $items = Koha::Items->search({ biblionumber => $id });
145 $out .= " <dlf:record>\n";
146 $out .= " <dlf:bibliographic id=\"" .$id. "\" />\n";
147 $out .= " <dlf:items>\n";
148 # We loop over the items to clean them
149 while ( my $item = $items->next ) {
150 my $itemnumber = $item->itemnumber;
151 my ( $biblionumber, $status, $msg, $location ) = _availability($itemnumber);
152 $out .= " <dlf:item id=\"" . $itemnumber . "\">\n";
153 $out .= " <dlf:simpleavailability>\n";
154 $out .= " <dlf:identifier>" . $itemnumber . "</dlf:identifier>\n";
155 $out .= " <dlf:availabilitystatus>" . $status . "</dlf:availabilitystatus>\n";
156 if ($msg) { $out .= " <dlf:availabilitymsg>" . $msg . "</dlf:availabilitymsg>\n"; }
157 if ($location) { $out .= " <dlf:location>" . $location . "</dlf:location>\n"; }
158 $out .= " </dlf:simpleavailability>\n";
159 $out .= " </dlf:item>\n";
162 $out .= " </dlf:items>\n";
163 $out .= " </dlf:record>\n";
166 $msg = "Error: could not retrieve availability for this ID";
170 $out .= "</dlf:collection>\n";
177 Given a list of biblionumbers, returns a list of record objects that
178 contain bibliographic information, as well as associated holdings and item
179 information. The caller may request a specific metadata schema for the
180 record objects to be returned.
182 This function behaves similarly to HarvestBibliographicRecords and
183 HarvestExpandedRecords in Data Aggregation, but allows quick, real time
184 lookup by bibliographic identifier.
186 You can use OAI-PMH ListRecords instead of this service.
191 list of system record identifiers
193 Defines the metadata schema in which the records are returned,
202 # Check if the schema is supported. For now, GetRecords only supports MARCXML
203 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
204 return { code => 'UnsupportedSchema' };
209 # Loop over biblionumbers
210 foreach my $biblionumber ( split( / /, $cgi->param('id') ) ) {
212 # Get the biblioitem from the biblionumber
213 my $biblio = Koha::Biblios->find( $biblionumber );
215 push @records, { code => "RecordNotFound" };
219 my $biblioitem = $biblio->biblioitem->unblessed;
222 my $record = GetMarcBiblio({
223 biblionumber => $biblionumber,
224 embed_items => $embed_items });
226 $biblioitem->{marcxml} = $record->as_xml_record();
229 # Get most of the needed data
230 my $biblioitemnumber = $biblioitem->{'biblioitemnumber'};
231 my $holds = $biblio->current_holds->unblessed;
232 my $issues = GetBiblioIssues($biblionumber);
233 my $items = $biblio->items->unblessed;
235 # We loop over the items to clean them
236 foreach my $item (@$items) {
238 # This hides additionnal XML subfields, we don't need these info
239 delete $item->{'more_subfields_xml'};
241 # Display branch names instead of branch codes
242 my $home_library = Koha::Libraries->find( $item->{homebranch} );
243 my $holding_library = Koha::Libraries->find( $item->{holdingbranch} );
244 $item->{'homebranchname'} = $home_library ? $home_library->branchname : '';
245 $item->{'holdingbranchname'} = $holding_library ? $holding_library->branchname : '';
247 my ($transferDate, $transferFrom, $transferTo) = GetTransfers($item->{itemnumber});
249 $item->{transfer} = {
250 datesent => $transferDate,
251 frombranch => $transferFrom,
252 tobranch => $transferTo,
257 # Hashref building...
258 $biblioitem->{'items'}->{'item'} = $items;
259 $biblioitem->{'reserves'}->{'reserve'} = $holds;
260 $biblioitem->{'issues'}->{'issue'} = $issues;
262 push @records, $biblioitem;
265 return { record => \@records };
268 =head2 GetAuthorityRecords
270 Given a list of authority record identifiers, returns a list of record
271 objects that contain the authority records. The function user may request
272 a specific metadata schema for the record objects.
277 list of authority record identifiers
279 specifies the metadata schema of records to be returned, possible values:
284 sub GetAuthorityRecords {
287 # If the user asks for an unsupported schema, return an error code
288 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
289 return { code => 'UnsupportedSchema' };
294 # Let's loop over the authority IDs
295 foreach my $authid ( split( / /, $cgi->param('id') ) ) {
297 # Get the record as XML string, or error code
298 push @records, GetAuthorityXML($authid) || { code => 'RecordNotFound' };
301 return { record => \@records };
306 Looks up a patron in the ILS by an identifier, and returns the borrowernumber.
311 an identifier used to look up the patron in Koha
313 the type of the identifier, possible values:
326 my $id = $cgi->param('id');
328 return { message => 'PatronNotFound' };
332 my $passed_id_type = $cgi->param('id_type');
333 if($passed_id_type) {
334 $patrons = Koha::Patrons->search( { $passed_id_type => $id } );
336 foreach my $id_type ('cardnumber', 'userid', 'email', 'borrowernumber',
337 'surname', 'firstname') {
338 $patrons = Koha::Patrons->search( { $id_type => $id } );
339 last if($patrons->count);
342 unless ( $patrons->count ) {
343 return { message => 'PatronNotFound' };
346 return { id => $patrons->next->borrowernumber };
349 =head2 AuthenticatePatron
351 Authenticates a user's login credentials and returns the identifier for
356 - username (Required)
357 user's login identifier (userid or cardnumber)
358 - password (Required)
363 sub AuthenticatePatron {
365 my $username = $cgi->param('username');
366 my $password = $cgi->param('password');
367 my ($status, $cardnumber, $userid) = C4::Auth::checkpw( C4::Context->dbh, $username, $password );
370 my $patron = Koha::Patrons->find( { userid => $userid } );
371 return { id => $patron->borrowernumber };
374 return { code => 'PatronNotFound' };
380 Returns specified information about the patron, based on options in the
381 request. This function can optionally return patron's contact information,
382 fine information, hold request information, and loan information.
386 - patron_id (Required)
388 - show_contact (Optional, default 1)
389 whether or not to return patron's contact information in the response
390 - show_fines (Optional, default 0)
391 whether or not to return fine information in the response
392 - show_holds (Optional, default 0)
393 whether or not to return hold request information in the response
394 - show_loans (Optional, default 0)
395 whether or not to return loan information request information in the response
396 - show_attributes (Optional, default 0)
397 whether or not to return additional patron attributes, when enabled the attributes
398 are limited to those marked as opac visible only.
406 my $borrowernumber = $cgi->param('patron_id');
407 my $patron = Koha::Patrons->find( $borrowernumber );
408 return { code => 'PatronNotFound' } unless $patron;
410 # Cleaning the borrower hashref
411 my $borrower = $patron->unblessed;
412 $borrower->{charges} = sprintf "%.02f", $patron->account->non_issues_charges; # FIXME Formatting should not be done here
413 my $library = Koha::Libraries->find( $borrower->{branchcode} );
414 $borrower->{'branchname'} = $library ? $library->branchname : '';
415 delete $borrower->{'userid'};
416 delete $borrower->{'password'};
418 # Contact fields management
419 if ( defined $cgi->param('show_contact') && $cgi->param('show_contact') eq "0" ) {
421 # Define contact fields
422 my @contactfields = (
423 'email', 'emailpro', 'fax', 'mobile', 'phone', 'phonepro',
424 'streetnumber', 'zipcode', 'city', 'streettype', 'B_address', 'B_city',
425 'B_email', 'B_phone', 'B_zipcode', 'address', 'address2', 'altcontactaddress1',
426 'altcontactaddress2', 'altcontactaddress3', 'altcontactfirstname', 'altcontactphone', 'altcontactsurname', 'altcontactzipcode'
430 foreach my $field (@contactfields) {
431 delete $borrower->{$field};
436 if ( $cgi->param('show_fines') && $cgi->param('show_fines') eq "1" ) {
437 $borrower->{fines}{fine} = $patron->account->lines->unblessed;
440 # Reserves management
441 if ( $cgi->param('show_holds') && $cgi->param('show_holds') eq "1" ) {
443 # Get borrower's reserves
444 my $holds = $patron->holds;
445 while ( my $hold = $holds->next ) {
447 my ( $item, $biblio, $biblioitem ) = ( {}, {}, {} );
448 # Get additional informations
449 if ( $hold->itemnumber ) { # item level holds
450 $item = Koha::Items->find( $hold->itemnumber );
451 $biblio = $item->biblio;
452 $biblioitem = $biblio->biblioitem;
454 # Remove unwanted fields
455 $item = $item->unblessed;
456 delete $item->{more_subfields_xml};
457 $biblio = $biblio->unblessed;
458 $biblioitem = $biblioitem->unblessed;
461 # Add additional fields
462 my $unblessed_hold = $hold->unblessed;
463 $unblessed_hold->{item} = { %$item, %$biblio, %$biblioitem };
464 my $library = Koha::Libraries->find( $hold->branchcode );
465 my $branchname = $library ? $library->branchname : '';
466 $unblessed_hold->{branchname} = $branchname;
467 $biblio = Koha::Biblios->find( $hold->biblionumber ); # Should be $hold->get_biblio
468 $unblessed_hold->{title} = $biblio ? $biblio->title : ''; # Just in case, but should not be needed
470 push @{ $borrower->{holds}{hold} }, $unblessed_hold;
476 if ( $cgi->param('show_loans') && $cgi->param('show_loans') eq "1" ) {
477 my $pending_checkouts = $patron->pending_checkouts;
479 while ( my $c = $pending_checkouts->next ) {
480 # FIXME We should only retrieve what is needed in the template
481 my $issue = $c->unblessed_all_relateds;
482 push @checkouts, $issue
484 $borrower->{'loans'}->{'loan'} = \@checkouts;
487 if ( $cgi->param('show_attributes') eq "1" ) {
488 my $attrs = GetBorrowerAttributes( $borrowernumber, 1 );
489 $borrower->{'attributes'} = $attrs;
492 # Add is expired information
493 $borrower->{'is_expired'} = $patron->is_expired ? 1 : 0;
498 =head2 GetPatronStatus
500 Returns a patron's status information.
504 - patron_id (Required)
509 sub GetPatronStatus {
513 my $borrowernumber = $cgi->param('patron_id');
514 my $patron = Koha::Patrons->find( $borrowernumber );
515 return { code => 'PatronNotFound' } unless $patron;
519 type => $patron->categorycode,
521 expiry => $patron->dateexpiry,
527 Returns information about the services available on a particular item for
532 - patron_id (Required)
542 # Get the member, or return an error code if not found
543 my $borrowernumber = $cgi->param('patron_id');
544 my $patron = Koha::Patrons->find( $borrowernumber );
545 return { code => 'PatronNotFound' } unless $patron;
547 my $borrower = $patron->unblessed;
548 # Get the item, or return an error code if not found
549 my $itemnumber = $cgi->param('item_id');
550 my $item = Koha::Items->find($itemnumber);
551 return { code => 'RecordNotFound' } unless $item;
555 # Reserve level management
556 my $biblionumber = $item->biblionumber;
557 my $canbookbereserved = CanBookBeReserved( $borrower, $biblionumber );
558 if ($canbookbereserved->{status} eq 'OK') {
559 push @availablefor, 'title level hold';
560 my $canitembereserved = IsAvailableForItemLevelRequest($item->unblessed, $borrower);
561 if ($canitembereserved) {
562 push @availablefor, 'item level hold';
566 # Reserve cancellation management
567 my $holds = $patron->holds;
569 while ( my $hold = $holds->next ) { # FIXME This could be improved
570 push @reserveditems, $hold->itemnumber;
572 if ( grep { $itemnumber eq $_ } @reserveditems ) {
573 push @availablefor, 'hold cancellation';
577 my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
579 push @availablefor, 'loan renewal';
583 my $barcode = $item->barcode || '';
584 $barcode = barcodedecode($barcode) if ( $barcode && C4::Context->preference('itemBarcodeInputFilter') );
586 my ( $issuingimpossible, $needsconfirmation ) = CanBookBeIssued( $patron, $barcode );
588 # TODO push @availablefor, 'loan';
592 $out->{'AvailableFor'} = \@availablefor;
599 Extends the due date for a borrower's existing issue.
603 - patron_id (Required)
607 - desired_due_date (Required)
608 the date the patron would like the item returned by
615 # Get borrower infos or return an error code
616 my $borrowernumber = $cgi->param('patron_id');
617 my $patron = Koha::Patrons->find( $borrowernumber );
618 return { code => 'PatronNotFound' } unless $patron;
620 # Get the item, or return an error code
621 my $itemnumber = $cgi->param('item_id');
622 my $item = Koha::Items->find($itemnumber);
623 return { code => 'RecordNotFound' } unless $item;
625 # Add renewal if possible
626 my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
627 if ( $renewal[0] ) { AddRenewal( $borrowernumber, $itemnumber ); }
629 return unless $item; # FIXME should be handled
631 my $issue = $item->checkout;
632 return $issue; # FIXME should be handled
636 $out->{'renewals'} = $issue->renewals;
637 $out->{date_due} = dt_from_string($issue->date_due)->strftime('%Y-%m-%d %H:%S');
638 $out->{'success'} = $renewal[0];
639 $out->{'error'} = $renewal[1];
646 Creates, for a borrower, a biblio-level hold reserve.
650 - patron_id (Required)
654 - request_location (Required)
655 IP address where the end user request is being placed
656 - pickup_location (Optional)
657 a branch code indicating the location to which to deliver the item for pickup
658 - needed_before_date (Optional)
659 date after which hold request is no longer needed
660 - pickup_expiry_date (Optional)
661 date after which item returned to shelf if item is not picked up
668 # Get the borrower or return an error code
669 my $borrowernumber = $cgi->param('patron_id');
670 my $patron = Koha::Patrons->find( $borrowernumber );
671 return { code => 'PatronNotFound' } unless $patron;
673 # Get the biblio record, or return an error code
674 my $biblionumber = $cgi->param('bib_id');
675 my $biblio = Koha::Biblios->find( $biblionumber );
676 return { code => 'RecordNotFound' } unless $biblio;
678 my @hostitems = get_hostitemnumbers_of($biblionumber);
681 push(@itemnumbers, @hostitems);
684 my $items = Koha::Items->search({ -or => { biblionumber => $biblionumber, itemnumber => { in => \@itemnumbers } } });
686 unless ( $items->count ) {
687 return { code => 'NoItems' };
690 my $title = $biblio ? $biblio->title : '';
692 # Check if the biblio can be reserved
693 my $code = CanBookBeReserved( $borrowernumber, $biblionumber )->{status};
694 return { code => $code } unless ( $code eq 'OK' );
698 # Pickup branch management
699 if ( $cgi->param('pickup_location') ) {
700 $branch = $cgi->param('pickup_location');
701 return { code => 'LocationNotFound' } unless Koha::Libraries->find($branch);
702 } else { # if the request provide no branch, use the borrower's branch
703 $branch = $patron->branchcode;
706 my $destination = Koha::Libraries->find($branch);
707 return { code => 'libraryNotPickupLocation' } unless $destination->pickup_location;
708 return { code => 'cannotBeTransferred' } unless $biblio->can_be_transferred({ to => $destination });
711 # $branch, $borrowernumber, $biblionumber,
712 # $constraint, $bibitems, $priority, $resdate, $expdate, $notes,
713 # $title, $checkitem, $found
714 my $priority= C4::Reserves::CalculatePriority( $biblionumber );
715 AddReserve( $branch, $borrowernumber, $biblionumber, undef, $priority, undef, undef, undef, $title, undef, undef );
719 $out->{'title'} = $title;
720 my $library = Koha::Libraries->find( $branch );
721 $out->{'pickup_location'} = $library ? $library->branchname : '';
723 # TODO $out->{'date_available'} = '';
730 Creates, for a borrower, an item-level hold request on a specific item of
731 a bibliographic record in Koha.
735 - patron_id (Required)
741 - pickup_location (Optional)
742 a branch code indicating the location to which to deliver the item for pickup
743 - needed_before_date (Optional)
744 date after which hold request is no longer needed
745 - pickup_expiry_date (Optional)
746 date after which item returned to shelf if item is not picked up
753 # Get the borrower or return an error code
754 my $borrowernumber = $cgi->param('patron_id');
755 my $patron = Koha::Patrons->find( $borrowernumber );
756 return { code => 'PatronNotFound' } unless $patron;
758 # Get the biblio or return an error code
759 my $biblionumber = $cgi->param('bib_id');
760 my $biblio = Koha::Biblios->find( $biblionumber );
761 return { code => 'RecordNotFound' } unless $biblio;
763 my $title = $biblio ? $biblio->title : '';
765 # Get the item or return an error code
766 my $itemnumber = $cgi->param('item_id');
767 my $item = Koha::Items->find($itemnumber);
768 return { code => 'RecordNotFound' } unless $item;
770 # If the biblio does not match the item, return an error code
771 return { code => 'RecordNotFound' } if $item->biblionumber ne $biblio->biblionumber;
773 # Pickup branch management
775 if ( $cgi->param('pickup_location') ) {
776 $branch = $cgi->param('pickup_location');
777 return { code => 'LocationNotFound' } unless Koha::Libraries->find($branch);
778 } else { # if the request provide no branch, use the borrower's branch
779 $branch = $patron->branchcode;
782 # Check for item disponibility
783 my $canitembereserved = C4::Reserves::CanItemBeReserved( $borrowernumber, $itemnumber, $branch )->{status};
784 return { code => $canitembereserved } unless $canitembereserved eq 'OK';
787 # $branch, $borrowernumber, $biblionumber,
788 # $constraint, $bibitems, $priority, $resdate, $expdate, $notes,
789 # $title, $checkitem, $found
790 my $priority= C4::Reserves::CalculatePriority( $biblionumber );
791 AddReserve( $branch, $borrowernumber, $biblionumber, undef, $priority, undef, undef, undef, $title, $itemnumber, undef );
795 my $library = Koha::Libraries->find( $branch );
796 $out->{'pickup_location'} = $library ? $library->branchname : '';
798 # TODO $out->{'date_available'} = '';
805 Cancels an active reserve request for the borrower.
809 - patron_id (Required)
819 # Get the borrower or return an error code
820 my $borrowernumber = $cgi->param('patron_id');
821 my $patron = Koha::Patrons->find( $borrowernumber );
822 return { code => 'PatronNotFound' } unless $patron;
824 # Get the reserve or return an error code
825 my $reserve_id = $cgi->param('item_id');
826 my $hold = Koha::Holds->find( $reserve_id );
827 return { code => 'RecordNotFound' } unless $hold;
828 return { code => 'RecordNotFound' } unless ($hold->borrowernumber == $borrowernumber);
832 return { code => 'Canceled' };
837 Returns, for an itemnumber, an array containing availability information.
839 my ($biblionumber, $status, $msg, $location) = _availability($id);
844 my ($itemnumber) = @_;
845 my $item = Koha::Items->find($itemnumber);
848 return ( undef, 'unknown', 'Error: could not retrieve availability for this ID', undef );
851 my $biblionumber = $item->biblioitemnumber;
852 my $library = Koha::Libraries->find( $item->holdingbranch );
853 my $location = $library ? $library->branchname : '';
855 if ( $item->notforloan ) {
856 return ( $biblionumber, 'not available', 'Not for loan', $location );
857 } elsif ( $item->onloan ) {
858 return ( $biblionumber, 'not available', 'Checked out', $location );
859 } elsif ( $item->itemlost ) {
860 return ( $biblionumber, 'not available', 'Item lost', $location );
861 } elsif ( $item->withdrawn ) {
862 return ( $biblionumber, 'not available', 'Item withdrawn', $location );
863 } elsif ( $item->damaged ) {
864 return ( $biblionumber, 'not available', 'Item damaged', $location );
866 return ( $biblionumber, 'available', undef, $location );