C4/SIP/ILS.pm

   1 #
   2 # ILS.pm: Koha ILS interface module
   3 #
   4
   5 package C4::SIP::ILS;
   6
   7 use warnings;
   8 use strict;
   9 use C4::SIP::Sip qw(siplog);
  10 use Data::Dumper;
  11
  12 use C4::SIP::ILS::Item;
  13 use C4::SIP::ILS::Patron;
  14 use C4::SIP::ILS::Transaction;
  15 use C4::SIP::ILS::Transaction::Checkout;
  16 use C4::SIP::ILS::Transaction::Checkin;
  17 use C4::SIP::ILS::Transaction::FeePayment;
  18 use C4::SIP::ILS::Transaction::Hold;
  19 use C4::SIP::ILS::Transaction::Renew;
  20 use C4::SIP::ILS::Transaction::RenewAll;
  21
  22 my $debug = 0;
  23
  24 my %supports = (
  25     'magnetic media'        => 1,
  26     'security inhibit'      => 0,
  27     'offline operation'     => 0,
  28     "patron status request" => 1,
  29     "checkout"              => 1,
  30     "checkin"               => 1,
  31     "block patron"          => 1,
  32     "acs status"            => 1,
  33     "login"                 => 1,
  34     "patron information"    => 1,
  35     "end patron session"    => 1,
  36     "fee paid"              => 1,
  37     "item information"      => 1,
  38     "item status update"    => 0,
  39     "patron enable"         => 1,
  40     "hold"                  => 1,
  41     "renew"                 => 1,
  42     "renew all"             => 1,
  43 );
  44
  45 sub new {
  46     my ($class, $institution) = @_;
  47     my $type = ref($class) || $class;
  48     my $self = {};
  49         $debug and warn "new ILS: INSTITUTION: " . Dumper($institution);
  50     siplog("LOG_DEBUG", "new ILS '%s'", $institution->{id});
  51     $self->{institution} = $institution;
  52     return bless $self, $type;
  53 }
  54
  55 sub find_patron {
  56     my $self = shift;
  57         $debug and warn "ILS: finding patron";
  58     return C4::SIP::ILS::Patron->new(@_);
  59 }
  60
  61 sub find_item {
  62     my $self = shift;
  63         $debug and warn "ILS: finding item";
  64     return C4::SIP::ILS::Item->new(@_);
  65 }
  66
  67 sub institution {
  68     my $self = shift;
  69     return $self->{institution}->{id};  # consider making this return the whole institution
  70 }
  71
  72 sub institution_id {
  73     my $self = shift;
  74     return $self->{institution}->{id};
  75 }
  76
  77 sub supports {
  78     my ($self, $op) = @_;
  79     return (exists($supports{$op}) && $supports{$op});
  80 }
  81
  82 sub check_inst_id {
  83     my ($self, $id, $whence) = @_;
  84     if ($id ne $self->{institution}->{id}) {
  85         siplog("LOG_WARNING", "%s: received institution '%s', expected '%s'", $whence, $id, $self->{institution}->{id});
  86         # Just an FYI check, we don't expect the user to change location from that in SIPconfig.xml
  87     }
  88 }
  89
  90 sub to_bool {
  91     my $bool = shift;
  92     # If it's defined, and matches a true sort of string, or is
  93     # a non-zero number, then it's true.
  94     defined($bool) or return;                   # false
  95     ($bool =~ /true|y|yes/i) and return 1;      # true
  96     return ($bool =~ /^\d+$/ and $bool != 0);   # true for non-zero numbers, false otherwise
  97 }
  98
  99 sub checkout_ok {
 100     my $self = shift;
 101     return (exists($self->{institution}->{policy}->{checkout})
 102             && to_bool($self->{institution}->{policy}->{checkout}));
 103 }
 104 sub checkin_ok {
 105     my $self = shift;
 106     return (exists($self->{institution}->{policy}->{checkin})
 107             && to_bool($self->{institution}->{policy}->{checkin}));
 108 }
 109 sub status_update_ok {
 110     my $self = shift;
 111     return (exists($self->{institution}->{policy}->{status_update})
 112             && to_bool($self->{institution}->{policy}->{status_update}));
 113 }
 114 sub offline_ok {
 115     my $self = shift;
 116     return (exists($self->{institution}->{policy}->{offline})
 117             && to_bool($self->{institution}->{policy}->{offline}));
 118 }
 119
 120 #
 121 # Checkout(patron_id, item_id, sc_renew):
 122 #    patron_id & item_id are the identifiers send by the terminal
 123 #    sc_renew is the renewal policy configured on the terminal
 124 # returns a status opject that can be queried for the various bits
 125 # of information that the protocol (SIP or NCIP) needs to generate
 126 # the response.
 127 #
 128 sub checkout {
 129     my ( $self, $patron_id, $item_id, $sc_renew, $fee_ack ) = @_;
 130     my ( $patron, $item, $circ );
 131
 132     $circ = C4::SIP::ILS::Transaction::Checkout->new();
 133
 134     # BEGIN TRANSACTION
 135     $circ->patron( $patron = C4::SIP::ILS::Patron->new($patron_id) );
 136     $circ->item( $item     = C4::SIP::ILS::Item->new($item_id) );
 137     if ($fee_ack) {
 138         $circ->fee_ack($fee_ack);
 139     }
 140
 141     if ( !$patron ) {
 142         $circ->screen_msg("Invalid Patron");
 143     }
 144     elsif ( !$patron->charge_ok ) {
 145         $circ->screen_msg("Patron Blocked");
 146     }
 147     elsif ( !$item ) {
 148         $circ->screen_msg("Invalid Item");
 149     }
 150     elsif ( $item->{borrowernumber}
 151         && !_ci_cardnumber_cmp( $item->{borrowernumber}, $patron_id ) )
 152     {
 153         $circ->screen_msg("Item checked out to another patron");
 154     }
 155     else {
 156         $circ->do_checkout();
 157         if ( $circ->ok ) {
 158             $debug and warn "circ is ok";
 159
 160             # If the item is already associated with this patron, then
 161             # we're renewing it.
 162             $circ->renew_ok( $item->{borrowernumber}
 163                   && _ci_cardnumber_cmp( $item->{borrowernumber}, $patron_id ) );
 164
 165             $item->{borrowernumber}   = $patron_id;
 166             $item->{due_date} = $circ->{due};
 167             push( @{ $patron->{items} }, { barcode => $item_id } );
 168             $circ->desensitize( !$item->magnetic_media );
 169
 170             siplog(
 171                 "LOG_DEBUG", "ILS::Checkout: patron %s has checked out %s",
 172                 $patron_id, join( ', ', map{ $_->{barcode} } @{ $patron->{items} } )
 173             );
 174         }
 175         else {
 176             siplog( "LOG_ERR", "ILS::Checkout Issue failed" );
 177         }
 178     }
 179
 180     # END TRANSACTION
 181
 182     return $circ;
 183 }
 184
 185 sub _ci_cardnumber_cmp {
 186     my ( $s1, $s2) = @_;
 187     # As the database is case insensitive we need to normalize two strings
 188     # before comparing them
 189     return ( uc($s1) eq uc($s2) );
 190 }
 191
 192 # wrapper which allows above to be called for testing
 193
 194 sub test_cardnumber_compare {
 195     my ($self, $str1, $str2) = @_;
 196     return _ci_cardnumber_cmp($str1, $str2);
 197 }
 198
 199 sub checkin {
 200     my ( $self, $item_id, $trans_date, $return_date, $current_loc, $item_props, $cancel, $account ) = @_;
 201
 202     my $checked_in_ok     = $account->{checked_in_ok};
 203     my $cv_triggers_alert = $account->{cv_triggers_alert};
 204     my $holds_block_checkin  = $account->{holds_block_checkin};
 205
 206     my ( $patron, $item, $circ );
 207
 208     $circ = C4::SIP::ILS::Transaction::Checkin->new();
 209
 210     # BEGIN TRANSACTION
 211     $circ->item( $item = C4::SIP::ILS::Item->new($item_id) );
 212
 213     my $data;
 214     if ($item) {
 215         $data = $circ->do_checkin( $current_loc, $return_date, $account );
 216     }
 217     else {
 218         $circ->alert(1);
 219         $circ->alert_type(99);
 220         $circ->ok( 0 );
 221         $circ->screen_msg('Invalid Item');
 222         return $circ;
 223     }
 224
 225     if ( !$circ->ok && $circ->alert_type && $circ->alert_type == 98 ) { # data corruption
 226         $circ->screen_msg("Checkin failed: data problem");
 227         siplog( "LOG_WARNING", "Problem with issue_id in issues and old_issues; check the about page" );
 228     } elsif ( $data->{messages}->{ResFound} && !$circ->ok && $holds_block_checkin ) {
 229         $circ->screen_msg("Item is on hold, please return to circulation desk");
 230         siplog ("LOG_DEBUG", "C4::SIP::ILS::Checkin - item on hold");
 231     } elsif ( $data->{messages}->{withdrawn} && !$circ->ok && C4::Context->preference("BlockReturnOfWithdrawnItems") ) {
 232             $circ->screen_msg("Item withdrawn, return not allowed");
 233             siplog ("LOG_DEBUG", "C4::SIP::ILS::Checkin - item withdrawn");
 234     } elsif ( $data->{messages}->{WasLost} && !$circ->ok && C4::Context->preference("BlockReturnOfLostItems") ) {
 235             $circ->screen_msg("Item lost, return not allowed");
 236             siplog("LOG_DEBUG", "C4::SIP::ILS::Checkin - item lost");
 237     } elsif ( !$item->{borrowernumber} ) {
 238         if ( $checked_in_ok ) { # Mark checkin ok although book not checked out
 239             $circ->ok( 1 );
 240             siplog("LOG_DEBUG", "C4::SIP::ILS::Checkin - using checked_in_ok");
 241         } else {
 242             $circ->screen_msg("Item not checked out");
 243             siplog("LOG_DEBUG", "C4::SIP::ILS::Checkin - item not checked out");
 244         }
 245     } elsif ( $circ->ok ) {
 246         $circ->patron( $patron = C4::SIP::ILS::Patron->new( $item->{borrowernumber} ) );
 247         delete $item->{borrowernumber};
 248         delete $item->{due_date};
 249         $patron->{items} = [ grep { $_ ne $item_id } @{ $patron->{items} } ];
 250     } else {
 251         # Checkin failed: Wrongbranch or withdrawn?
 252         # Bug 10748 with pref BlockReturnOfLostItems adds another case to come
 253         # here: returning a lost item when the pref is set.
 254         $circ->screen_msg("Checkin failed");
 255         siplog( "LOG_WARNING", "Checkin failed: probably for Wrongbranch or withdrawn" );
 256     }
 257
 258     return $circ;
 259 }
 260
 261 # If the ILS caches patron information, this lets it free
 262 # it up
 263 sub end_patron_session {
 264     my ($self, $patron_id) = @_;
 265
 266     # success?, screen_msg, print_line
 267     return (1, 'Thank you !', '');
 268 }
 269
 270 sub pay_fee {
 271     my ($self, $patron_id, $patron_pwd, $fee_amt, $fee_type, $pay_type, $fee_id, $trans_id, $currency, $is_writeoff, $disallow_overpayment, $register_id) = @_;
 272
 273     my $trans = C4::SIP::ILS::Transaction::FeePayment->new();
 274
 275     $trans->transaction_id($trans_id);
 276     my $patron;
 277     $trans->patron($patron = C4::SIP::ILS::Patron->new($patron_id));
 278     if (!$patron) {
 279         $trans->screen_msg('Invalid patron barcode.');
 280         return $trans;
 281     }
 282     my $trans_result = $trans->pay( $patron->{borrowernumber}, $fee_amt, $pay_type, $fee_id, $is_writeoff, $disallow_overpayment, $register_id );
 283     my $ok = $trans_result->{ok};
 284     $trans->ok($ok);
 285
 286     return {
 287         status       => $trans,
 288         pay_response => $trans_result->{pay_response}
 289     };
 290 }
 291
 292 sub add_hold {
 293     my ($self, $patron_id, $patron_pwd, $item_id, $title_id,
 294         $expiry_date, $pickup_location, $hold_type, $fee_ack) = @_;
 295     my ($patron, $item);
 296
 297         my $trans = C4::SIP::ILS::Transaction::Hold->new();
 298
 299     $patron = C4::SIP::ILS::Patron->new( $patron_id);
 300     if (!$patron
 301         || (defined($patron_pwd) && !$patron->check_password($patron_pwd))) {
 302                 $trans->screen_msg("Invalid Patron.");
 303                 return $trans;
 304     }
 305
 306         unless ($item = C4::SIP::ILS::Item->new($item_id || $title_id)) {
 307                 $trans->screen_msg("No such item.");
 308                 return $trans;
 309         }
 310
 311     if ( $patron->holds_blocked_by_excessive_fees() ) {
 312         $trans->screen_msg("Excessive fees blocking placement of hold.");
 313     }
 314
 315    if ($item->fee and $fee_ack ne 'Y') {
 316                 $trans->screen_msg = "Fee required to place hold.";
 317                 return $trans;
 318     }
 319
 320     my $hold = {
 321         item_id         => $item->id,
 322         patron_id       => $patron->id,
 323         expiration_date => $expiry_date,
 324         pickup_location => $pickup_location,
 325         hold_type       => $hold_type,
 326     };
 327
 328     $trans->ok(1);
 329     $trans->patron($patron);
 330     $trans->item($item);
 331     $trans->pickup_location($pickup_location);
 332         $trans->do_hold;
 333
 334     push(@{$item->hold_queue},     $hold);
 335     push(@{$patron->{hold_items}}, $hold);
 336
 337     return $trans;
 338 }
 339
 340 sub cancel_hold {
 341     my ($self, $patron_id, $patron_pwd, $item_id, $title_id) = @_;
 342     my ($patron, $item, $hold);
 343
 344         my $trans = C4::SIP::ILS::Transaction::Hold->new();
 345
 346     $patron = C4::SIP::ILS::Patron->new( $patron_id );
 347     if (!$patron) {
 348                 $trans->screen_msg("Invalid patron barcode.");
 349                 return $trans;
 350     } elsif (defined($patron_pwd) && !$patron->check_password($patron_pwd)) {
 351                 $trans->screen_msg('Invalid patron password.');
 352                 return $trans;
 353     }
 354
 355     unless ($item = C4::SIP::ILS::Item->new($item_id || $title_id)) {
 356                 $trans->screen_msg("No such item.");
 357                 return $trans;
 358     }
 359
 360     $trans->patron($patron);
 361     $trans->item($item);
 362         $trans->drop_hold;
 363         unless ($trans->ok) {
 364                 $trans->screen_msg("Error with transaction drop_hold: " . $trans->screen_msg);
 365                 return $trans;
 366         }
 367     # Remove the hold from the patron's record first
 368     $trans->ok($patron->drop_hold($item_id));   # different than the transaction drop!
 369
 370     unless ($trans->ok) {
 371                 # We didn't find it on the patron record
 372                 $trans->screen_msg("No such hold on patron record.");
 373                 return $trans;
 374     }
 375
 376     # Now, remove it from the item record.  If it was on the patron
 377     # record but not on the item record, we'll treat that as success.
 378     foreach my $i (0 .. scalar @{$item->hold_queue}) {
 379                 $hold = $item->hold_queue->[$i];
 380                 if ($item->barcode_is_borrowernumber($patron->id, $hold->{borrowernumber})) {
 381                     # found it: delete it.
 382                     splice @{$item->hold_queue}, $i, 1;
 383                     last;               # ?? should we keep going, in case there are multiples
 384                 }
 385     }
 386
 387     $trans->screen_msg("Hold Cancelled.");
 388
 389     return $trans;
 390 }
 391
 392
 393 # The patron and item id's can't be altered, but the
 394 # date, location, and type can.
 395 sub alter_hold {
 396     my ($self, $patron_id, $patron_pwd, $item_id, $title_id,
 397         $expiry_date, $pickup_location, $hold_type, $fee_ack) = @_;
 398     my ($patron, $item);
 399     my $hold;
 400     my $trans;
 401
 402     $trans = C4::SIP::ILS::Transaction::Hold->new();
 403
 404     # BEGIN TRANSACTION
 405     $patron = C4::SIP::ILS::Patron->new( $patron_id );
 406     unless ($patron) {
 407                 $trans->screen_msg("Invalid patron barcode: '$patron_id'.");
 408                 return $trans;
 409     }
 410
 411     foreach my $i (0 .. scalar @{$patron->{hold_items}}) {
 412                 $hold = $patron->{hold_items}[$i];
 413
 414         if ($hold->{item_id} eq $item_id) {
 415             # Found it.  So fix it.
 416             $hold->{expiration_date} = $expiry_date     if $expiry_date;
 417             $hold->{pickup_location} = $pickup_location if $pickup_location;
 418             $hold->{hold_type}       = $hold_type       if $hold_type;
 419                 $trans->change_hold();
 420             # $trans->ok(1);
 421             $trans->screen_msg("Hold updated.");
 422             $trans->patron($patron);
 423             $trans->item(C4::SIP::ILS::Item->new( $hold->{item_id}));
 424             last;
 425         }
 426     }
 427
 428     # The same hold structure is linked into both the patron's
 429     # list of hold items and into the queue of outstanding holds
 430     # for the item, so we don't need to search the hold queue for
 431     # the item, since it's already been updated by the patron code.
 432
 433     if (!$trans->ok) {
 434                 $trans->screen_msg("No such outstanding hold.");
 435     }
 436
 437     return $trans;
 438 }
 439
 440 sub renew {
 441     my ($self, $patron_id, $patron_pwd, $item_id, $title_id,
 442         $no_block, $nb_due_date, $third_party,
 443         $item_props, $fee_ack) = @_;
 444     my ($patron, $item);
 445     my $trans;
 446
 447     $trans = C4::SIP::ILS::Transaction::Renew->new();
 448     $trans->patron($patron = C4::SIP::ILS::Patron->new( $patron_id ));
 449
 450     if (!$patron) {
 451                 $trans->screen_msg("Invalid patron barcode.");
 452                 return $trans;
 453     } elsif (!$patron->renew_ok) {
 454                 $trans->screen_msg("Renewals not allowed.");
 455                 return $trans;
 456     }
 457
 458         # Previously: renewing a title, rather than an item (sort of)
 459         # This is gross, but in a real ILS it would be better
 460
 461     # if (defined($title_id)) {
 462         #       foreach my $i (@{$patron->{items}}) {
 463         #               $item = new ILS::Item $i;
 464         #               last if ($title_id eq $item->title_id);
 465         #               $item = undef;
 466         #       }
 467     # } else {
 468                 my $j = 0;
 469                 my $count = scalar @{$patron->{items}};
 470                 foreach my $i (@{$patron->{items}}) {
 471             unless (defined $i->{barcode}) {    # FIXME: using data instead of objects may violate the abstraction layer
 472                 siplog("LOG_ERR", "No barcode for item %s of %s: $item_id", $j+1, $count);
 473                 next;
 474             }
 475             siplog("LOG_DEBUG", "checking item %s of %s: $item_id vs. %s", ++$j, $count, $i->{barcode});
 476             if ($i->{barcode} eq $item_id) {
 477                                 # We have it checked out
 478                                 $item = C4::SIP::ILS::Item->new( $item_id );
 479                                 last;
 480                         }
 481                 }
 482     # }
 483
 484     $trans->item($item);
 485
 486     if (!defined($item)) {
 487                 $trans->screen_msg("Item not checked out to " . $patron->name);     # not checked out to $patron_id
 488         $trans->ok(0);
 489     } else {
 490         $trans->do_renew();
 491         if ($trans->renewal_ok()) {
 492             $item->{due_date} = $trans->{due};
 493             $trans->desensitize(0);
 494         }
 495     }
 496
 497     return $trans;
 498 }
 499
 500 sub renew_all {
 501     my ($self, $patron_id, $patron_pwd, $fee_ack) = @_;
 502     my ($patron, $item_id);
 503     my $trans;
 504
 505     $trans = C4::SIP::ILS::Transaction::RenewAll->new();
 506
 507     $trans->patron($patron = C4::SIP::ILS::Patron->new( $patron_id ));
 508     if (defined $patron) {
 509         siplog("LOG_DEBUG", "ILS::renew_all: patron '%s': renew_ok: %s", $patron->name, $patron->renew_ok);
 510     } else {
 511         siplog("LOG_DEBUG", "ILS::renew_all: Invalid patron id: '%s'", $patron_id);
 512     }
 513
 514     if (!defined($patron)) {
 515                 $trans->screen_msg("Invalid patron barcode.");
 516                 return $trans;
 517     } elsif (!$patron->renew_ok) {
 518                 $trans->screen_msg("Renewals not allowed.");
 519                 return $trans;
 520     } elsif (defined($patron_pwd) && !$patron->check_password($patron_pwd)) {
 521                 $trans->screen_msg("Invalid patron password.");
 522                 return $trans;
 523     }
 524
 525         $trans->do_renew_all;
 526     $trans->ok(1);
 527     return $trans;
 528 }
 529
 530 1;
 531 __END__
 532