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

(-)a/circ/reserveratios.pl (-2 / +12 lines)
Lines 83-88 push @query_params, output_pref({ dt => $startdate, dateformat => 'iso' }) ; Link Here
83
$sqldatewhere .= " AND reservedate <= ?";
83
$sqldatewhere .= " AND reservedate <= ?";
84
push @query_params, output_pref({ dt => $enddate, dateformat => 'iso' });
84
push @query_params, output_pref({ dt => $enddate, dateformat => 'iso' });
85
85
86
my $include_aqorders_qty =
87
  C4::Context->preference('AcqCreateItem') eq 'receiving'
88
  ? '+ COALESCE(aqorders.quantity, 0) - COALESCE(aqorders.quantityreceived, 0)'
89
  : q{};
90
91
my $include_aqorders_qty_join =
92
  C4::Context->preference('AcqCreateItem') eq 'receiving'
93
  ? 'LEFT JOIN aqorders ON reserves.biblionumber=aqorders.biblionumber'
94
  : q{};
95
86
my $nfl_comparison = $include_ordered ? '<=' : '=';
96
my $nfl_comparison = $include_ordered ? '<=' : '=';
87
my $strsth =
97
my $strsth =
88
"SELECT reservedate,
98
"SELECT reservedate,
Lines 107-116 my $strsth = Link Here
107
        biblio.title,
117
        biblio.title,
108
        biblio.author,
118
        biblio.author,
109
        count(DISTINCT reserves.borrowernumber) as reservecount, 
119
        count(DISTINCT reserves.borrowernumber) as reservecount, 
110
        count(DISTINCT items.itemnumber) as itemcount 
120
        count(DISTINCT items.itemnumber) $include_aqorders_qty as itemcount
111
 FROM  reserves
121
 FROM  reserves
112
 LEFT JOIN items ON items.biblionumber=reserves.biblionumber 
122
 LEFT JOIN items ON items.biblionumber=reserves.biblionumber 
113
 LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
123
 LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
124
 $include_aqorders_qty_join
114
 WHERE
125
 WHERE
115
 notforloan $nfl_comparison 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0
126
 notforloan $nfl_comparison 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0
116
 $sqldatewhere
127
 $sqldatewhere
117
- 

Return to bug 15997