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({
218 biblionumber => $biblionumber,
219 embed_items => $embed_items });
221 $biblioitem->{marcxml} = $record->as_xml_record();
224 # Get most of the needed data
225 my $biblioitemnumber = $biblioitem->{'biblioitemnumber'};
226 my $biblio = Koha::Biblios->find( $biblionumber );
227 my $holds = $biblio->current_holds->unblessed;
228 my $issues = GetBiblioIssues($biblionumber);
229 my $items = GetItemsByBiblioitemnumber($biblioitemnumber);
231 # We loop over the items to clean them
232 foreach my $item (@$items) {
234 # This hides additionnal XML subfields, we don't need these info
235 delete $item->{'more_subfields_xml'};
237 # Display branch names instead of branch codes
238 my $home_library = Koha::Libraries->find( $item->{homebranch} );
239 my $holding_library = Koha::Libraries->find( $item->{holdingbranch} );
240 $item->{'homebranchname'} = $home_library ? $home_library->branchname : '';
241 $item->{'holdingbranchname'} = $holding_library ? $holding_library->branchname : '';
244 # Hashref building...
245 $biblioitem->{'items'}->{'item'} = $items;
246 $biblioitem->{'reserves'}->{'reserve'} = $holds;
247 $biblioitem->{'issues'}->{'issue'} = $issues;
249 push @records, $biblioitem;
252 return { record => \@records };
255 =head2 GetAuthorityRecords
257 Given a list of authority record identifiers, returns a list of record
258 objects that contain the authority records. The function user may request
259 a specific metadata schema for the record objects.
264 list of authority record identifiers
266 specifies the metadata schema of records to be returned, possible values:
271 sub GetAuthorityRecords {
274 # If the user asks for an unsupported schema, return an error code
275 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
276 return { code => 'UnsupportedSchema' };
281 # Let's loop over the authority IDs
282 foreach my $authid ( split( / /, $cgi->param('id') ) ) {
284 # Get the record as XML string, or error code
285 push @records, GetAuthorityXML($authid) || { code => 'RecordNotFound' };
288 return { record => \@records };
293 Looks up a patron in the ILS by an identifier, and returns the borrowernumber.
298 an identifier used to look up the patron in Koha
300 the type of the identifier, possible values:
313 my $id = $cgi->param('id');
315 return { message => 'PatronNotFound' };
319 my $passed_id_type = $cgi->param('id_type');
320 if($passed_id_type) {
321 $patrons = Koha::Patrons->search( { $passed_id_type => $id } );
323 foreach my $id_type ('cardnumber', 'userid', 'email', 'borrowernumber',
324 'surname', 'firstname') {
325 $patrons = Koha::Patrons->search( { $id_type => $id } );
326 last if($patrons->count);
329 unless ( $patrons->count ) {
330 return { message => 'PatronNotFound' };
333 return { id => $patrons->next->borrowernumber };
336 =head2 AuthenticatePatron
338 Authenticates a user's login credentials and returns the identifier for
343 - username (Required)
344 user's login identifier (userid or cardnumber)
345 - password (Required)
350 sub AuthenticatePatron {
352 my $username = $cgi->param('username');
353 my $password = $cgi->param('password');
354 my ($status, $cardnumber, $userid) = C4::Auth::checkpw( C4::Context->dbh, $username, $password );
357 my $patron = Koha::Patrons->find( { cardnumber => $cardnumber } );
358 return { id => $patron->borrowernumber };
361 return { code => 'PatronNotFound' };
367 Returns specified information about the patron, based on options in the
368 request. This function can optionally return patron's contact information,
369 fine information, hold request information, and loan information.
373 - patron_id (Required)
375 - show_contact (Optional, default 1)
376 whether or not to return patron's contact information in the response
377 - show_fines (Optional, default 0)
378 whether or not to return fine information in the response
379 - show_holds (Optional, default 0)
380 whether or not to return hold request information in the response
381 - show_loans (Optional, default 0)
382 whether or not to return loan information request information in the response
390 my $borrowernumber = $cgi->param('patron_id');
391 my $patron = Koha::Patrons->find( $borrowernumber );
392 return { code => 'PatronNotFound' } unless $patron;
394 # Cleaning the borrower hashref
395 my $borrower = $patron->unblessed;
396 my $flags = C4::Members::patronflags( $borrower );
397 $borrower->{'charges'} = $flags->{'CHARGES'}->{'amount'};
398 my $library = Koha::Libraries->find( $borrower->{branchcode} );
399 $borrower->{'branchname'} = $library ? $library->branchname : '';
400 delete $borrower->{'userid'};
401 delete $borrower->{'password'};
403 # Contact fields management
404 if ( defined $cgi->param('show_contact') && $cgi->param('show_contact') eq "0" ) {
406 # Define contact fields
407 my @contactfields = (
408 'email', 'emailpro', 'fax', 'mobile', 'phone', 'phonepro',
409 'streetnumber', 'zipcode', 'city', 'streettype', 'B_address', 'B_city',
410 'B_email', 'B_phone', 'B_zipcode', 'address', 'address2', 'altcontactaddress1',
411 'altcontactaddress2', 'altcontactaddress3', 'altcontactfirstname', 'altcontactphone', 'altcontactsurname', 'altcontactzipcode'
415 foreach my $field (@contactfields) {
416 delete $borrower->{$field};
421 if ( $cgi->param('show_fines') && $cgi->param('show_fines') eq "1" ) {
423 for ( my $i = 1 ; my @charge = getcharges( $borrowernumber, undef, $i ) ; $i++ ) {
424 push( @charges, @charge );
426 $borrower->{'fines'}->{'fine'} = \@charges;
429 # Reserves management
430 if ( $cgi->param('show_holds') && $cgi->param('show_holds') eq "1" ) {
432 # Get borrower's reserves
433 my $holds = $patron->holds;
434 while ( my $hold = $holds->next ) {
436 my ( $item, $biblio, $biblioitem ) = ( {}, {}, {} );
437 # Get additional informations
438 if ( $hold->itemnumber ) { # item level holds
439 $item = Koha::Items->find( $hold->itemnumber );
440 $biblio = $item->biblio;
441 $biblioitem = $biblio->biblioitem;
443 # Remove unwanted fields
444 $item = $item->unblessed;
445 delete $item->{more_subfields_xml};
446 $biblio = $biblio->unblessed;
447 $biblioitem = $biblioitem->unblessed;
450 # Add additional fields
451 my $unblessed_hold = $hold->unblessed;
452 $unblessed_hold->{item} = { %$item, %$biblio, %$biblioitem };
453 my $library = Koha::Libraries->find( $hold->branchcode );
454 my $branchname = $library ? $library->branchname : '';
455 $unblessed_hold->{branchname} = $branchname;
456 $biblio = Koha::Biblios->find( $hold->biblionumber ); # Should be $hold->get_biblio
457 $unblessed_hold->{title} = $biblio ? $biblio->title : ''; # Just in case, but should not be needed
459 push @{ $borrower->{holds}{hold} }, $unblessed_hold;
465 if ( $cgi->param('show_loans') && $cgi->param('show_loans') eq "1" ) {
466 my $issues = GetPendingIssues($borrowernumber);
467 foreach my $issue ( @$issues ){
468 $issue->{'issuedate'} = $issue->{'issuedate'}->strftime('%Y-%m-%d %H:%M');
469 $issue->{'date_due'} = $issue->{'date_due'}->strftime('%Y-%m-%d %H:%M');
471 $borrower->{'loans'}->{'loan'} = $issues;
474 if ( $cgi->param('show_attributes') eq "1" ) {
475 my $attrs = GetBorrowerAttributes( $borrowernumber, 0, 1 );
476 $borrower->{'attributes'} = $attrs;
482 =head2 GetPatronStatus
484 Returns a patron's status information.
488 - patron_id (Required)
493 sub GetPatronStatus {
497 my $borrowernumber = $cgi->param('patron_id');
498 my $patron = Koha::Patrons->find( $borrowernumber );
499 return { code => 'PatronNotFound' } unless $patron;
503 type => $patron->categorycode,
505 expiry => $patron->dateexpiry,
511 Returns information about the services available on a particular item for
516 - patron_id (Required)
526 # Get the member, or return an error code if not found
527 my $borrowernumber = $cgi->param('patron_id');
528 my $patron = Koha::Patrons->find( $borrowernumber );
529 return { code => 'PatronNotFound' } unless $patron;
531 my $borrower = $patron->unblessed;
532 # Get the item, or return an error code if not found
533 my $itemnumber = $cgi->param('item_id');
534 my $item = GetItem( $itemnumber );
535 return { code => 'RecordNotFound' } unless $$item{itemnumber};
539 # Reserve level management
540 my $biblionumber = $item->{'biblionumber'};
541 my $canbookbereserved = CanBookBeReserved( $borrower, $biblionumber );
542 if ($canbookbereserved eq 'OK') {
543 push @availablefor, 'title level hold';
544 my $canitembereserved = IsAvailableForItemLevelRequest($item, $borrower);
545 if ($canitembereserved) {
546 push @availablefor, 'item level hold';
550 # Reserve cancellation management
551 my $holds = $patron->holds;
553 while ( my $hold = $holds->next ) { # FIXME This could be improved
554 push @reserveditems, $hold->itemnumber;
556 if ( grep { $itemnumber eq $_ } @reserveditems ) {
557 push @availablefor, 'hold cancellation';
561 my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
563 push @availablefor, 'loan renewal';
567 my $barcode = $item->{'barcode'} || '';
568 $barcode = barcodedecode($barcode) if ( $barcode && C4::Context->preference('itemBarcodeInputFilter') );
570 my ( $issuingimpossible, $needsconfirmation ) = CanBookBeIssued( $patron, $barcode );
572 # TODO push @availablefor, 'loan';
576 $out->{'AvailableFor'} = \@availablefor;
583 Extends the due date for a borrower's existing issue.
587 - patron_id (Required)
591 - desired_due_date (Required)
592 the date the patron would like the item returned by
599 # Get borrower infos or return an error code
600 my $borrowernumber = $cgi->param('patron_id');
601 my $patron = Koha::Patrons->find( $borrowernumber );
602 return { code => 'PatronNotFound' } unless $patron;
604 # Get the item, or return an error code
605 my $itemnumber = $cgi->param('item_id');
606 my $item = GetItem( $itemnumber );
607 return { code => 'RecordNotFound' } unless $$item{itemnumber};
609 # Add renewal if possible
610 my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
611 if ( $renewal[0] ) { AddRenewal( $borrowernumber, $itemnumber ); }
613 my $issue = Koha::Checkouts->find( { itemnumber => $itemnumber } ) or return; # FIXME should be handled
617 $out->{'renewals'} = $issue->renewals;
618 $out->{date_due} = dt_from_string($issue->date_due)->strftime('%Y-%m-%d %H:%S');
619 $out->{'success'} = $renewal[0];
620 $out->{'error'} = $renewal[1];
627 Creates, for a borrower, a biblio-level hold reserve.
631 - patron_id (Required)
635 - request_location (Required)
636 IP address where the end user request is being placed
637 - pickup_location (Optional)
638 a branch code indicating the location to which to deliver the item for pickup
639 - needed_before_date (Optional)
640 date after which hold request is no longer needed
641 - pickup_expiry_date (Optional)
642 date after which item returned to shelf if item is not picked up
649 # Get the borrower or return an error code
650 my $borrowernumber = $cgi->param('patron_id');
651 my $patron = Koha::Patrons->find( $borrowernumber );
652 return { code => 'PatronNotFound' } unless $patron;
654 # Get the biblio record, or return an error code
655 my $biblionumber = $cgi->param('bib_id');
656 my $biblio = Koha::Biblios->find( $biblionumber );
657 return { code => 'RecordNotFound' } unless $biblio;
659 my $title = $biblio ? $biblio->title : '';
661 # Check if the biblio can be reserved
662 return { code => 'NotHoldable' } unless CanBookBeReserved( $borrowernumber, $biblionumber ) eq 'OK';
666 # Pickup branch management
667 if ( $cgi->param('pickup_location') ) {
668 $branch = $cgi->param('pickup_location');
669 return { code => 'LocationNotFound' } unless Koha::Libraries->find($branch);
670 } else { # if the request provide no branch, use the borrower's branch
671 $branch = $patron->branchcode;
675 # $branch, $borrowernumber, $biblionumber,
676 # $constraint, $bibitems, $priority, $resdate, $expdate, $notes,
677 # $title, $checkitem, $found
678 my $priority= C4::Reserves::CalculatePriority( $biblionumber );
679 AddReserve( $branch, $borrowernumber, $biblionumber, undef, $priority, undef, undef, undef, $title, undef, undef );
683 $out->{'title'} = $title;
684 my $library = Koha::Libraries->find( $branch );
685 $out->{'pickup_location'} = $library ? $library->branchname : '';
687 # TODO $out->{'date_available'} = '';
694 Creates, for a borrower, an item-level hold request on a specific item of
695 a bibliographic record in Koha.
699 - patron_id (Required)
705 - pickup_location (Optional)
706 a branch code indicating the location to which to deliver the item for pickup
707 - needed_before_date (Optional)
708 date after which hold request is no longer needed
709 - pickup_expiry_date (Optional)
710 date after which item returned to shelf if item is not picked up
717 # Get the borrower or return an error code
718 my $borrowernumber = $cgi->param('patron_id');
719 my $patron = Koha::Patrons->find( $borrowernumber );
720 return { code => 'PatronNotFound' } unless $patron;
722 # Get the biblio or return an error code
723 my $biblionumber = $cgi->param('bib_id');
724 my $biblio = Koha::Biblios->find( $biblionumber );
725 return { code => 'RecordNotFound' } unless $biblio;
727 my $title = $biblio ? $biblio->title : '';
729 # Get the item or return an error code
730 my $itemnumber = $cgi->param('item_id');
731 my $item = GetItem( $itemnumber );
732 return { code => 'RecordNotFound' } unless $$item{itemnumber};
734 # If the biblio does not match the item, return an error code
735 return { code => 'RecordNotFound' } if $$item{biblionumber} ne $biblio->biblionumber;
737 # Check for item disponibility
738 my $canitembereserved = C4::Reserves::CanItemBeReserved( $borrowernumber, $itemnumber );
739 my $canbookbereserved = C4::Reserves::CanBookBeReserved( $borrowernumber, $biblionumber );
740 return { code => 'NotHoldable' } unless $canbookbereserved eq 'OK' and $canitembereserved eq 'OK';
742 # Pickup branch management
744 if ( $cgi->param('pickup_location') ) {
745 $branch = $cgi->param('pickup_location');
746 return { code => 'LocationNotFound' } unless Koha::Libraries->find($branch);
747 } else { # if the request provide no branch, use the borrower's branch
748 $branch = $patron->branchcode;
752 # $branch, $borrowernumber, $biblionumber,
753 # $constraint, $bibitems, $priority, $resdate, $expdate, $notes,
754 # $title, $checkitem, $found
755 my $priority= C4::Reserves::CalculatePriority( $biblionumber );
756 AddReserve( $branch, $borrowernumber, $biblionumber, undef, $priority, undef, undef, undef, $title, $itemnumber, undef );
760 my $library = Koha::Libraries->find( $branch );
761 $out->{'pickup_location'} = $library ? $library->branchname : '';
763 # TODO $out->{'date_available'} = '';
770 Cancels an active reserve request for the borrower.
774 - patron_id (Required)
784 # Get the borrower or return an error code
785 my $borrowernumber = $cgi->param('patron_id');
786 my $patron = Koha::Patrons->find( $borrowernumber );
787 return { code => 'PatronNotFound' } unless $patron;
789 # Get the reserve or return an error code
790 my $reserve_id = $cgi->param('item_id');
791 my $hold = Koha::Holds->find( $reserve_id );
792 return { code => 'RecordNotFound' } unless $hold;
793 return { code => 'RecordNotFound' } unless ($hold->borrowernumber == $borrowernumber);
797 return { code => 'Canceled' };
802 Returns, for an itemnumber, an array containing availability information.
804 my ($biblionumber, $status, $msg, $location) = _availability($id);
809 my ($itemnumber) = @_;
810 my $item = GetItem( $itemnumber, undef, undef );
812 if ( not $item->{'itemnumber'} ) {
813 return ( undef, 'unknown', 'Error: could not retrieve availability for this ID', undef );
816 my $biblionumber = $item->{'biblioitemnumber'};
817 my $library = Koha::Libraries->find( $item->{holdingbranch} );
818 my $location = $library ? $library->branchname : '';
820 if ( $item->{'notforloan'} ) {
821 return ( $biblionumber, 'not available', 'Not for loan', $location );
822 } elsif ( $item->{'onloan'} ) {
823 return ( $biblionumber, 'not available', 'Checked out', $location );
824 } elsif ( $item->{'itemlost'} ) {
825 return ( $biblionumber, 'not available', 'Item lost', $location );
826 } elsif ( $item->{'withdrawn'} ) {
827 return ( $biblionumber, 'not available', 'Item withdrawn', $location );
828 } elsif ( $item->{'damaged'} ) {
829 return ( $biblionumber, 'not available', 'Item damaged', $location );
831 return ( $biblionumber, 'available', undef, $location );