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 under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
29 use C4
::Reserves
qw(AddReserve CancelReserve GetReservesFromBiblionumber GetReservesFromBorrowernumber CanBookBeReserved CanItemBeReserved);
31 use C4
::AuthoritiesMarc
;
32 use C4
::ILSDI
::Utility
;
40 C4::ILS-DI::Services - ILS-DI Services
44 Each function in this module represents an ILS-DI service.
45 They all takes a CGI instance as argument and most of them return a
46 hashref that will be printed by XML::Simple in opac/ilsdi.pl
50 use C4::ILSDI::Services;
56 $out = LookupPatron($cgi);
58 print CGI::header('text/xml');
63 xmldecl => '<?xml version="1.0" encoding="ISO-8859-1" ?>',
64 RootName => 'LookupPatron',
71 =head2 GetAvailability
73 Given a set of biblionumbers or itemnumbers, returns a list with
74 availability of the items associated with the identifiers.
80 list of either biblionumbers or itemnumbers
82 =head3 id_type (Required)
84 defines the type of record identifier being used in the request,
90 =head3 return_type (Optional)
92 requests a particular level of detail in reporting availability,
98 =head3 return_fmt (Optional)
100 requests a particular format or set of formats in reporting
105 sub GetAvailability
{
108 my $out = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
109 $out .= "<dlf:collection\n";
110 $out .= " xmlns:dlf=\"http://diglib.org/ilsdi/1.1\"\n";
111 $out .= " xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n";
112 $out .= " xsi:schemaLocation=\"http://diglib.org/ilsdi/1.1\n";
113 $out .= " http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd\">\n";
115 foreach my $id ( split( / /, $cgi->param('id') ) ) {
116 if ( $cgi->param('id_type') eq "item" ) {
117 my ( $biblionumber, $status, $msg, $location ) = Availability
($id);
119 $out .= " <dlf:record>\n";
120 $out .= " <dlf:bibliographic id=\"" . ( $biblionumber || $id ) . "\" />\n";
121 $out .= " <dlf:items>\n";
122 $out .= " <dlf:item id=\"" . $id . "\">\n";
123 $out .= " <dlf:simpleavailability>\n";
124 $out .= " <dlf:identifier>" . $id . "</dlf:identifier>\n";
125 $out .= " <dlf:availabilitystatus>" . $status . "</dlf:availabilitystatus>\n";
126 if ($msg) { $out .= " <dlf:availabilitymsg>" . $msg . "</dlf:availabilitymsg>\n"; }
127 if ($location) { $out .= " <dlf:location>" . $location . "</dlf:location>\n"; }
128 $out .= " </dlf:simpleavailability>\n";
129 $out .= " </dlf:item>\n";
130 $out .= " </dlf:items>\n";
131 $out .= " </dlf:record>\n";
135 my $biblioitem = ( GetBiblioItemByBiblioNumber
( $id, undef ) )[0];
140 $msg = "Error: could not retrieve availability for this ID";
142 $out .= " <dlf:record>\n";
143 $out .= " <dlf:bibliographic id=\"" . $id . "\" />\n";
144 $out .= " <dlf:simpleavailability>\n";
145 $out .= " <dlf:identifier>" . $id . "</dlf:identifier>\n";
146 $out .= " <dlf:availabilitystatus>" . $status . "</dlf:availabilitystatus>\n";
147 $out .= " <dlf:availabilitymsg>" . $msg . "</dlf:availabilitymsg>\n";
148 $out .= " </dlf:simpleavailability>\n";
149 $out .= " </dlf:record>\n";
152 $out .= "</dlf:collection>\n";
159 Given a list of biblionumbers, returns a list of record objects that
160 contain bibliographic information, as well as associated holdings and item
161 information. The caller may request a specific metadata schema for the
162 record objects to be returned.
164 This function behaves similarly to HarvestBibliographicRecords and
165 HarvestExpandedRecords in Data Aggregation, but allows quick, real time
166 lookup by bibliographic identifier.
168 You can use OAI-PMH ListRecords instead of this service.
173 list of system record identifiers
175 Defines the metadata schema in which the records are returned,
184 # Check if the schema is supported. For now, GetRecords only supports MARCXML
185 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
186 return { code
=> 'UnsupportedSchema' };
191 # Loop over biblionumbers
192 foreach my $biblionumber ( split( / /, $cgi->param('id') ) ) {
194 # Get the biblioitem from the biblionumber
195 my $biblioitem = ( GetBiblioItemByBiblioNumber
( $biblionumber, undef ) )[0];
196 if ( not $biblioitem->{'biblionumber'} ) {
197 $biblioitem->{code
} = "RecordNotFound";
201 my $record = GetMarcBiblio
($biblionumber, $embed_items);
203 $biblioitem->{marcxml
} = $record->as_xml_record();
206 # We don't want MARC to be displayed
207 delete $biblioitem->{'marc'};
209 # Get most of the needed data
210 my $biblioitemnumber = $biblioitem->{'biblioitemnumber'};
211 my @reserves = GetReservesFromBiblionumber
( $biblionumber, undef, undef );
212 my $issues = GetBiblioIssues
($biblionumber);
213 my $items = GetItemsByBiblioitemnumber
($biblioitemnumber);
215 # We loop over the items to clean them
216 foreach my $item (@
$items) {
218 # This hides additionnal XML subfields, we don't need these info
219 delete $item->{'more_subfields_xml'};
221 # Display branch names instead of branch codes
222 $item->{'homebranchname'} = GetBranchName
( $item->{'homebranch'} );
223 $item->{'holdingbranchname'} = GetBranchName
( $item->{'holdingbranch'} );
226 # Hashref building...
227 $biblioitem->{'items'}->{'item'} = $items;
228 $biblioitem->{'reserves'}->{'reserve'} = $reserves[1];
229 $biblioitem->{'issues'}->{'issue'} = $issues;
231 push @records, $biblioitem;
234 return { record
=> \
@records };
237 =head2 GetAuthorityRecords
239 Given a list of authority record identifiers, returns a list of record
240 objects that contain the authority records. The function user may request
241 a specific metadata schema for the record objects.
246 list of authority record identifiers
248 specifies the metadata schema of records to be returned, possible values:
253 sub GetAuthorityRecords
{
256 # If the user asks for an unsupported schema, return an error code
257 if ( $cgi->param('schema') and $cgi->param('schema') ne "MARCXML" ) {
258 return { code
=> 'UnsupportedSchema' };
263 # Let's loop over the authority IDs
264 foreach my $authid ( split( / /, $cgi->param('id') ) ) {
266 # Get the record as XML string, or error code
267 push @records, GetAuthorityXML
($authid) || { code
=> 'RecordNotFound' };
270 return { record
=> \
@records };
275 Looks up a patron in the ILS by an identifier, and returns the borrowernumber.
280 an identifier used to look up the patron in Koha
282 the type of the identifier, possible values:
293 # Get the borrower...
294 my $borrower = GetMember
($cgi->param('id_type') => $cgi->param('id'));
295 if ( not $borrower->{'borrowernumber'} ) {
296 return { message
=> 'PatronNotFound' };
300 my $patron->{'id'} = $borrower->{'borrowernumber'};
301 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
303 # ...and return his ID
307 =head2 AuthenticatePatron
309 Authenticates a user's login credentials and returns the identifier for
314 - username (Required)
315 user's login identifier
316 - password (Required)
321 sub AuthenticatePatron
{
324 # Check if borrower exists, using a C4::Auth function...
325 unless( C4
::Auth
::checkpw
( C4
::Context
->dbh, $cgi->param('username'), $cgi->param('password') ) ) {
326 return { code
=> 'PatronNotFound' };
330 my $borrower = GetMember
( userid
=> $cgi->param('username') );
333 my $patron->{'id'} = $borrower->{'borrowernumber'};
335 # ... and return his ID
341 Returns specified information about the patron, based on options in the
342 request. This function can optionally return patron's contact information,
343 fine information, hold request information, and loan information.
347 - patron_id (Required)
349 - show_contact (Optional, default 1)
350 whether or not to return patron's contact information in the response
351 - show_fines (Optional, default 0)
352 whether or not to return fine information in the response
353 - show_holds (Optional, default 0)
354 whether or not to return hold request information in the response
355 - show_loans (Optional, default 0)
356 whether or not to return loan information request information in the response
364 my $borrowernumber = $cgi->param('patron_id');
365 my $borrower = GetMemberDetails
( $borrowernumber );
366 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
368 # Cleaning the borrower hashref
369 $borrower->{'charges'} = $borrower->{'flags'}->{'CHARGES'}->{'amount'};
370 $borrower->{'branchname'} = GetBranchName
( $borrower->{'branchcode'} );
371 delete $borrower->{'flags'};
372 delete $borrower->{'userid'};
373 delete $borrower->{'password'};
375 # Contact fields management
376 if ( $cgi->param('show_contact') eq "0" ) {
378 # Define contact fields
379 my @contactfields = (
380 'email', 'emailpro', 'fax', 'mobile', 'phone', 'phonepro',
381 'streetnumber', 'zipcode', 'city', 'streettype', 'B_address', 'B_city',
382 'B_email', 'B_phone', 'B_zipcode', 'address', 'address2', 'altcontactaddress1',
383 'altcontactaddress2', 'altcontactaddress3', 'altcontactfirstname', 'altcontactphone', 'altcontactsurname', 'altcontactzipcode'
387 foreach my $field (@contactfields) {
388 delete $borrower->{$field};
393 if ( $cgi->param('show_fines') eq "1" ) {
395 for ( my $i = 1 ; my @charge = getcharges
( $borrowernumber, undef, $i ) ; $i++ ) {
396 push( @charges, @charge );
398 $borrower->{'fines'}->{'fine'} = \
@charges;
401 # Reserves management
402 if ( $cgi->param('show_holds') eq "1" ) {
404 # Get borrower's reserves
405 my @reserves = GetReservesFromBorrowernumber
( $borrowernumber, undef );
406 foreach my $reserve (@reserves) {
408 # Get additional informations
409 my $item = GetBiblioFromItemNumber
( $reserve->{'itemnumber'}, undef );
410 my $branchname = GetBranchName
( $reserve->{'branchcode'} );
412 # Remove unwanted fields
413 delete $item->{'marc'};
414 delete $item->{'marcxml'};
415 delete $item->{'more_subfields_xml'};
417 # Add additional fields
418 $reserve->{'item'} = $item;
419 $reserve->{'branchname'} = $branchname;
420 $reserve->{'title'} = GetBiblio
( $reserve->{'biblionumber'} )->{'title'};
422 $borrower->{'holds'}->{'hold'} = \
@reserves;
426 if ( $cgi->param('show_loans') eq "1" ) {
427 my $issues = GetPendingIssues
($borrowernumber);
428 foreach my $issue ( @
$issues ){
429 $issue->{'issuedate'} = $issue->{'issuedate'}->strftime('%Y-%m-%d %H:%M');
430 $issue->{'date_due'} = $issue->{'date_due'}->strftime('%Y-%m-%d %H:%M');
432 $borrower->{'loans'}->{'loan'} = $issues;
438 =head2 GetPatronStatus
440 Returns a patron's status information.
444 - patron_id (Required)
449 sub GetPatronStatus
{
453 my $borrowernumber = $cgi->param('patron_id');
454 my $borrower = GetMemberDetails
( $borrowernumber );
455 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
459 type
=> $$borrower{categorycode
},
461 expiry
=> $$borrower{dateexpiry
},
467 Returns information about the services available on a particular item for
472 - patron_id (Required)
481 # Get the member, or return an error code if not found
482 my $borrowernumber = $cgi->param('patron_id');
483 my $borrower = GetMemberDetails
( $borrowernumber );
484 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
486 # Get the item, or return an error code if not found
487 my $itemnumber = $cgi->param('item_id');
488 my $item = GetItem
( $itemnumber );
489 return { code
=> 'RecordNotFound' } unless $$item{itemnumber
};
493 # Reserve level management
494 my $biblionumber = $item->{'biblionumber'};
495 my $canbookbereserved = CanBookBeReserved
( $borrower, $biblionumber );
496 if ($canbookbereserved) {
497 push @availablefor, 'title level hold';
498 my $canitembereserved = IsAvailableForItemLevelRequest
($itemnumber);
499 if ($canitembereserved) {
500 push @availablefor, 'item level hold';
504 # Reserve cancellation management
505 my @reserves = GetReservesFromBorrowernumber
( $borrowernumber, undef );
507 foreach my $reserve (@reserves) {
508 push @reserveditems, $reserve->{'itemnumber'};
510 if ( grep { $itemnumber eq $_ } @reserveditems ) {
511 push @availablefor, 'hold cancellation';
515 my @renewal = CanBookBeRenewed
( $borrowernumber, $itemnumber );
517 push @availablefor, 'loan renewal';
521 my $barcode = $item->{'barcode'} || '';
522 $barcode = barcodedecode
($barcode) if ( $barcode && C4
::Context
->preference('itemBarcodeInputFilter') );
524 my ( $issuingimpossible, $needsconfirmation ) = CanBookBeIssued
( $borrower, $barcode );
526 # TODO push @availablefor, 'loan';
530 $out->{'AvailableFor'} = \
@availablefor;
537 Extends the due date for a borrower's existing issue.
541 - patron_id (Required)
545 - desired_due_date (Required)
546 the date the patron would like the item returned by
553 # Get borrower infos or return an error code
554 my $borrowernumber = $cgi->param('patron_id');
555 my $borrower = GetMemberDetails
( $borrowernumber );
556 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
558 # Get the item, or return an error code
559 my $itemnumber = $cgi->param('item_id');
560 my $item = GetItem
( $itemnumber );
561 return { code
=> 'RecordNotFound' } unless $$item{itemnumber
};
563 # Add renewal if possible
564 my @renewal = CanBookBeRenewed
( $borrowernumber, $itemnumber );
565 if ( $renewal[0] ) { AddRenewal
( $borrowernumber, $itemnumber ); }
567 my $issue = GetItemIssue
($itemnumber);
571 $out->{'renewals'} = $issue->{'renewals'};
572 $out->{date_due
} = $issue->{date_due
}->strftime('%Y-%m-%d %H:%S');
573 $out->{'success'} = $renewal[0];
574 $out->{'error'} = $renewal[1];
581 Creates, for a borrower, a biblio-level hold reserve.
585 - patron_id (Required)
589 - request_location (Required)
590 IP address where the end user request is being placed
591 - pickup_location (Optional)
592 a branch code indicating the location to which to deliver the item for pickup
593 - needed_before_date (Optional)
594 date after which hold request is no longer needed
595 - pickup_expiry_date (Optional)
596 date after which item returned to shelf if item is not picked up
603 # Get the borrower or return an error code
604 my $borrowernumber = $cgi->param('patron_id');
605 my $borrower = GetMemberDetails
( $borrowernumber );
606 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
608 # Get the biblio record, or return an error code
609 my $biblionumber = $cgi->param('bib_id');
610 my $biblio = GetBiblio
( $biblionumber );
611 return { code
=> 'RecordNotFound' } unless $$biblio{biblionumber
};
613 my $title = $$biblio{title
};
615 # Check if the biblio can be reserved
616 return { code
=> 'NotHoldable' } unless CanBookBeReserved
( $borrowernumber, $biblionumber );
620 # Pickup branch management
621 if ( $cgi->param('pickup_location') ) {
622 $branch = $cgi->param('pickup_location');
623 my $branches = GetBranches
;
624 return { code
=> 'LocationNotFound' } unless $$branches{$branch};
625 } else { # if the request provide no branch, use the borrower's branch
626 $branch = $$borrower{branchcode
};
630 # $branch, $borrowernumber, $biblionumber, $constraint, $bibitems, $priority, $notes, $title, $checkitem, $found
631 AddReserve
( $branch, $borrowernumber, $biblionumber, 'a', undef, 0, undef, $title, undef, undef );
635 $out->{'title'} = $title;
636 $out->{'pickup_location'} = GetBranchName
($branch);
638 # TODO $out->{'date_available'} = '';
645 Creates, for a borrower, an item-level hold request on a specific item of
646 a bibliographic record in Koha.
650 - patron_id (Required)
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 $borrower = GetMemberDetails
( $borrowernumber );
671 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
673 # Get the biblio or return an error code
674 my $biblionumber = $cgi->param('bib_id');
675 my $biblio = GetBiblio
($biblionumber);
676 return { code
=> 'RecordNotFound' } unless $$biblio{biblionumber
};
678 my $title = $$biblio{title
};
680 # Get the item or return an error code
681 my $itemnumber = $cgi->param('item_id');
682 my $item = GetItem
( $itemnumber );
683 return { code
=> 'RecordNotFound' } unless $$item{itemnumber
};
685 # If the biblio does not match the item, return an error code
686 return { code
=> 'RecordNotFound' } if $$item{biblionumber
} ne $$biblio{biblionumber
};
688 # Check for item disponibility
689 my $canitembereserved = C4
::Reserves
::CanItemBeReserved
( $borrowernumber, $itemnumber );
690 my $canbookbereserved = C4
::Reserves
::CanBookBeReserved
( $borrowernumber, $biblionumber );
691 return { code
=> 'NotHoldable' } unless $canbookbereserved and $canitembereserved;
695 # Pickup branch management
696 if ( $cgi->param('pickup_location') ) {
697 $branch = $cgi->param('pickup_location');
698 my $branches = GetBranches
();
699 return { code
=> 'LocationNotFound' } unless $$branches{$branch};
700 } else { # if the request provide no branch, use the borrower's branch
701 $branch = $$borrower{branchcode
};
708 $rank = '0' unless C4
::Context
->preference('ReservesNeedReturns');
709 if ( $item->{'holdingbranch'} eq $branch ) {
710 $found = 'W' unless C4
::Context
->preference('ReservesNeedReturns');
714 # $branch,$borrowernumber,$biblionumber,$constraint,$bibitems,$priority,$resdate,$expdate,$notes,$title,$checkitem,$found
715 AddReserve
( $branch, $borrowernumber, $biblionumber, 'a', undef, $rank, '', '', '', $title, $itemnumber, $found );
719 $out->{'pickup_location'} = GetBranchName
($branch);
721 # TODO $out->{'date_available'} = '';
728 Cancels an active reserve request for the borrower.
732 - patron_id (Required)
742 # Get the borrower or return an error code
743 my $borrowernumber = $cgi->param('patron_id');
744 my $borrower = GetMemberDetails
( $borrowernumber );
745 return { code
=> 'PatronNotFound' } unless $$borrower{borrowernumber
};
747 # Get the item or return an error code
748 my $itemnumber = $cgi->param('item_id');
749 my $item = GetItem
( $itemnumber );
750 return { code
=> 'RecordNotFound' } unless $$item{itemnumber
};
752 # Get borrower's reserves
753 my @reserves = GetReservesFromBorrowernumber
( $borrowernumber, undef );
756 # ...and loop over it to build an array of reserved itemnumbers
757 foreach my $reserve (@reserves) {
758 push @reserveditems, $reserve->{'itemnumber'};
761 # if the item was not reserved by the borrower, returns an error code
762 return { code
=> 'NotCanceled' } unless any
{ $itemnumber eq $_ } @reserveditems;
765 CancelReserve
( $itemnumber, undef, $borrowernumber );
767 return { code
=> 'Canceled' };