Add option to inventory tool to ignore copies on loan

[koha.git] / C4 / Items.pm

diff --git a/C4/Items.pm b/C4/Items.pm
index c9818a0..b843ca5 100644 (file)
--- a/C4/Items.pm
+++ b/C4/Items.pm
@@ -1071,6 +1071,11 @@ END_SQL
         push @where_strings, 'issues.date_due IS NULL';
     }
 
+    if ( $ignoreissued) {
+        $query .= "LEFT JOIN issues ON items.itemnumber = issues.itemnumber ";
+        push @where_strings, 'issues.date_due IS NULL';
+    }
+
     if ( @where_strings ) {
         $query .= 'WHERE ';
         $query .= join ' AND ', @where_strings;