View | Details | Raw Unified | Return to bug 7887
Collapse All | Expand All

(-)a/circ/reserveratios.pl (-7 / +7 lines)
Lines 104-110 if ($order eq "biblio") { Link Here
104
	$sqlorderby = " ORDER BY reservecount DESC ";
104
	$sqlorderby = " ORDER BY reservecount DESC ";
105
}
105
}
106
106
107
my $on_order_sql = ( $include_on_order_items ) ? "+ aqorders.quantity" : "";
107
my $on_order_sql1 = ( $include_on_order_items ) ? "+ COALESCE(aqorders.quantity, 0)" : q{};
108
my $on_order_sql2 = ( $include_on_order_items ) ? "LEFT JOIN aqorders ON reserves.biblionumber=aqorders.biblionumber" : q{};
108
my $not_for_loan_comparison = ( $include_will_be_available ) ? "<=" : "=";
109
my $not_for_loan_comparison = ( $include_will_be_available ) ? "<=" : "=";
109
110
110
my $strsth =
111
my $strsth =
Lines 127-139 my $strsth = Link Here
127
        reserves.found,
128
        reserves.found,
128
        biblio.title,
129
        biblio.title,
129
        biblio.author,
130
        biblio.author,
130
        count(DISTINCT reserves.borrowernumber) as reservecount, 
131
        count(DISTINCT reserves.borrowernumber) as reservecount,
131
        count(DISTINCT items.itemnumber) $on_order_sql as itemcount
132
        count(DISTINCT items.itemnumber) $on_order_sql1 as itemcount
132
 FROM  reserves
133
 FROM  reserves
133
 LEFT JOIN items ON items.biblionumber=reserves.biblionumber 
134
 LEFT JOIN items ON items.biblionumber=reserves.biblionumber
134
 LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
135
 LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
135
 LEFT JOIN aqorders ON reserves.biblionumber=aqorders.biblionumber
136
 $on_order_sql2
136
 WHERE 
137
 WHERE
137
notforloan $not_for_loan_comparison 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0
138
notforloan $not_for_loan_comparison 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0
138
 $sqldatewhere
139
 $sqldatewhere
139
";
140
";
140
- 

Return to bug 7887