Lines 138-159
sub process_stats {
Link Here
|
138 |
$dt->subtract( $units{$unit} => $1 ) ); |
138 |
$dt->subtract( $units{$unit} => $1 ) ); |
139 |
} |
139 |
} |
140 |
my $limit = ''; |
140 |
my $limit = ''; |
141 |
$limit = " AND statistics.datetime >= ?" if ( $interval || $since ); |
141 |
$limit = " WHERE statistics.datetime >= ?" if ( $interval || $since ); |
142 |
|
142 |
|
143 |
my $query = |
143 |
my $query = |
144 |
"SELECT biblio.biblionumber, COUNT(statistics.itemnumber) FROM biblio LEFT JOIN items ON (biblio.biblionumber=items.biblionumber) LEFT JOIN statistics ON (items.itemnumber=statistics.itemnumber) WHERE statistics.type = 'issue' $limit GROUP BY biblio.biblionumber;"; |
144 |
"SELECT biblio.biblionumber, COUNT(statistics.itemnumber) FROM biblio\ |
|
|
145 |
LEFT JOIN items ON (biblio.biblionumber=items.biblionumber)\ |
146 |
LEFT JOIN statistics ON (items.itemnumber=statistics.itemnumber AND statistics.type = 'issue') |
147 |
$limit\ |
148 |
GROUP BY biblio.biblionumber"; |
145 |
process_query( $query, $limit ); |
149 |
process_query( $query, $limit ); |
146 |
|
150 |
|
147 |
unless ($incremental) { |
|
|
148 |
$query = |
149 |
"SELECT biblio.biblionumber, 0 FROM biblio LEFT JOIN items ON (biblio.biblionumber=items.biblionumber) LEFT JOIN statistics ON (items.itemnumber=statistics.itemnumber) WHERE statistics.itemnumber IS NULL GROUP BY biblio.biblionumber;"; |
150 |
process_query( $query, '' ); |
151 |
|
152 |
$query = |
153 |
"SELECT biblio.biblionumber, 0 FROM biblio LEFT JOIN items ON (biblio.biblionumber=items.biblionumber) WHERE items.itemnumber IS NULL GROUP BY biblio.biblionumber;"; |
154 |
process_query( $query, '' ); |
155 |
} |
156 |
|
157 |
$dbh->commit(); |
151 |
$dbh->commit(); |
158 |
} |
152 |
} |
159 |
|
153 |
|
160 |
- |
|
|