projects
/
koha.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Bug 10184 - Circulation History reverses sort order
[koha.git]
/
circ
/
pendingreserves.pl
diff --git
a/circ/pendingreserves.pl
b/circ/pendingreserves.pl
index
0f5d3da
..
9a60ec1
100755
(executable)
--- a/
circ/pendingreserves.pl
+++ b/
circ/pendingreserves.pl
@@
-141,6
+141,7
@@
if ( $run_report ) {
$sqldatewhere
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
$sqldatewhere
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
+ AND items.itemnumber NOT IN (select itemnumber FROM reserves where found='W')
AND issues.itemnumber IS NULL
AND reserves.priority <> 0
AND reserves.suspend = 0
AND issues.itemnumber IS NULL
AND reserves.priority <> 0
AND reserves.suspend = 0
@@
-150,7
+151,7
@@
if ( $run_report ) {
# multiple patrons have a hold on an item
# multiple patrons have a hold on an item
- if (C4::Context->preference('Independ
a
ntBranches')){
+ if (C4::Context->preference('Independ
e
ntBranches')){
$strsth .= " AND items.holdingbranch=? ";
push @query_params, C4::Context->userenv->{'branch'};
}
$strsth .= " AND items.holdingbranch=? ";
push @query_params, C4::Context->userenv->{'branch'};
}