|
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 |
- |
|
|