Bug 22899: Add pending_hold method to Koha::Item

To test:
 1 - Enable course reserves
 2 - Create a course
 3 - Add an item to the course
 4 - Attempt to view the course on the OPAC
 5 - Internal Server Error
 6 - Apply patch
 7 - Add an item to the holds queue by placing a hold and  running holds queue builder or:
     INSERT INTO tmp_holdsqueue (itemnumber) VALUES (###);
 8 - View the course page, note item appears 'Pending hold'
 9 - Remove the holdsqueue line
10 - View the course page, note item appears 'Available'
11 - prove -v t/db_dependent/Koha/Item.t

Signed-off-by: Hayley Mapley <hayleymapley@catalyst.net.nz>
I see Jonathan's comments about small improvements, but will sign off as
everything works as expected here.
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

diff --git a/Koha/Item.pm b/Koha/Item.pm
index 49ae8e1..f97634b 100644 (file)
--- a/Koha/Item.pm
+++ b/Koha/Item.pm
@@ -354,6 +354,20 @@ sub add_to_rota {
     return $self;
 }
 
+=head3 pending_hold
+
+  my $is_pending_hold = $item->pending_hold();
+
+This method checks the tmp_holdsqueue to see if this item has been selected for a hold, but not filled yet and returns true or false
+
+=cut
+
+sub pending_hold {
+    my ( $self ) = @_;
+    my $pending_hold = $self->_result->tmp_holdsqueues;
+    return !C4::Context->preference('AllowItemsOnHoldCheckout') && $pending_hold->count ? 1: 0;
+}
+
 =head2 Internal methods
 
 =head3 _type

diff --git a/t/db_dependent/Koha/Item.t b/t/db_dependent/Koha/Item.t
index f20c2e7..f7b652c 100644 (file)
--- a/t/db_dependent/Koha/Item.t
+++ b/t/db_dependent/Koha/Item.t
@@ -19,7 +19,7 @@
 
 use Modern::Perl;
 
-use Test::More tests => 1;
+use Test::More tests => 2;
 
 use Koha::Items;
 use Koha::Database;
@@ -61,3 +61,24 @@ subtest 'hidden_in_opac() tests' => sub {
 
     $schema->storage->txn_rollback;
 };
+
+subtest 'pending_hold() tests' => sub {
+
+    plan tests => 3;
+
+    $schema->storage->txn_begin;
+
+    my $dbh = C4::Context->dbh;
+    my $item  = $builder->build_sample_item({ itemlost => 0 });
+    my $itemnumber = $item->itemnumber;
+
+    # disable AllowItemsOnHoldCheckout as it ignores pending holds
+    t::lib::Mocks::mock_preference( 'AllowItemsOnHoldCheckout', 0 );
+    $dbh->do("INSERT INTO tmp_holdsqueue (surname,borrowernumber,itemnumber) VALUES ('Clamp',42,$itemnumber)");
+    ok( $item->pending_hold, "Yes, we have a pending hold");
+    t::lib::Mocks::mock_preference( 'AllowItemsOnHoldCheckout', 1 );
+    ok( !$item->pending_hold, "We don't consider a pending hold if hold items can be checked out");
+    t::lib::Mocks::mock_preference( 'AllowItemsOnHoldCheckout', 0 );
+    $dbh->do("DELETE FROM tmp_holdsqueue WHERE itemnumber=$itemnumber");
+    ok( !$item->pending_hold, "We don't have a pending hold if nothing in the tmp_holdsqueue");
+};