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

(-)a/misc/cronjobs/update_totalissues.pl (-13 / +6 lines)
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
- 

Return to bug 24527