Lines 46-69
my $test_only = 0;
Link Here
|
46 |
my $want_help = 0; |
46 |
my $want_help = 0; |
47 |
my $since; |
47 |
my $since; |
48 |
my $interval; |
48 |
my $interval; |
49 |
my $usestats = 0; |
49 |
my $usestats = 0; |
50 |
my $useitems = 0; |
50 |
my $useitems = 0; |
51 |
my $incremental = 0; |
51 |
my $include_deleted = 0; |
52 |
my $progress = 100; |
52 |
my $incremental = 0; |
|
|
53 |
my $progress = 100; |
53 |
my $unit; |
54 |
my $unit; |
54 |
|
55 |
|
55 |
my $command_line_options = join( " ", @ARGV ); |
56 |
my $command_line_options = join( " ", @ARGV ); |
56 |
|
57 |
|
57 |
my $result = GetOptions( |
58 |
my $result = GetOptions( |
58 |
'v|verbose' => \$verbose, |
59 |
'v|verbose' => \$verbose, |
59 |
't|test' => \$test_only, |
60 |
't|test' => \$test_only, |
60 |
's|since=s' => \$since, |
61 |
's|since=s' => \$since, |
61 |
'i|interval=s' => \$interval, |
62 |
'i|interval=s' => \$interval, |
62 |
'use-stats' => \$usestats, |
63 |
'use-stats' => \$usestats, |
63 |
'use-items' => \$useitems, |
64 |
'use-items' => \$useitems, |
64 |
'incremental' => \$incremental, |
65 |
'use-deleted-items' => \$include_deleted, |
65 |
'p|progress=i' => \$progress, |
66 |
'incremental' => \$incremental, |
66 |
'h|help' => \$want_help |
67 |
'p|progress=i' => \$progress, |
|
|
68 |
'h|help' => \$want_help |
67 |
); |
69 |
); |
68 |
|
70 |
|
69 |
binmode( STDOUT, ":encoding(UTF-8)" ); |
71 |
binmode( STDOUT, ":encoding(UTF-8)" ); |
Lines 109-115
cronlogaction( { action => 'End', info => "COMPLETED" } );
Link Here
|
109 |
exit 0; |
111 |
exit 0; |
110 |
|
112 |
|
111 |
sub process_items { |
113 |
sub process_items { |
112 |
my $query = "SELECT items.biblionumber, SUM(items.issues) FROM items GROUP BY items.biblionumber;"; |
114 |
my $query = |
|
|
115 |
$include_deleted |
116 |
? "SELECT all_items.biblionumber, SUM(all_items.issues) FROM (SELECT items.biblionumber,items.issues FROM items UNION ALL SELECT deleteditems.biblionumber, deleteditems.issues FROM deleteditems) all_items GROUP BY all_items.biblionumber;" |
117 |
: "SELECT items.biblionumber, SUM(items.issues) FROM items GROUP BY items.biblionumber;"; |
113 |
process_query($query); |
118 |
process_query($query); |
114 |
} |
119 |
} |
115 |
|
120 |
|
Lines 243-248
options, by definition. Also note that if both --use-stats and
Link Here
|
243 |
--use-items are specified, the count of biblios processed will be |
248 |
--use-items are specified, the count of biblios processed will be |
244 |
misleading. |
249 |
misleading. |
245 |
|
250 |
|
|
|
251 |
=item B<--use-deleted-items> |
252 |
|
253 |
Only applies when using items as above, will include deleted items in the total |
254 |
count of issues for the bibliographic records. |
255 |
|
246 |
=item B<-s|--since=DATE> |
256 |
=item B<-s|--since=DATE> |
247 |
|
257 |
|
248 |
Only process issues recorded in the statistics table since DATE. |
258 |
Only process issues recorded in the statistics table since DATE. |
249 |
- |
|
|