3 # Copyright 2016 PTFS Europe
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 3 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
26 --[a]dmin-email An address to which email reports should also be sent
27 --[b]ranchcode Select branch to report on for 'email' reports (default: all)
28 --e[x]ecute Actually perform stockrotation housekeeping
29 --[r]eport Select either 'full' or 'email'
30 --[S]end-all Send email reports even if the report body is empty
31 --[s]end-email Send reports by email
32 --[h]elp Display this help message
34 Cron script implementing scheduled stockrotation functionality.
36 By default this script merely reports on the current status of the
37 stockrotation subsystem. In order to actually place items in transit, the
38 script must be run with the `execute` argument.
40 `report` allows you to select the type of report that will be emitted. It's
41 set to 'full' by default. If the `email` report is selected, you can use the
42 `branchcode` parameter to specify which branch's report you would like to see.
45 `admin-email` is an additional email address to which we will send all email
46 reports in addition to sending them to branch email addresses.
48 `send-email` will cause the script to send reports by email, and `send-all`
49 will cause even reports with an empty body to be sent.
53 This script is used to move items from one stockrotationstage to the next,
54 if they are elible for processing.
56 it should be run from cron like:
58 stockrotation.pl --report email --send-email --execute
60 Prior to that you can run the script from the command line without the
61 --execute and --send-email parameters to see what reports the script would
62 generate in 'production' mode. This is immensely useful for testing, or for
63 getting to understand how the stockrotation module works: you can set up
64 different scenarios, and then "query" the system on what it would do.
66 Normally you would want to run this script once per day, probably around
67 midnight-ish to move any stockrotationitems along their rotas and to generate
68 the email reports for branch libraries.
70 Each library will receive a report with "items of interest" for them for
71 today's rota checks. Each item there will be an item that should, according
72 to Koha, be located on the shelves of that branch, and which should be picked
73 up and checked in. The item will either:
74 - have been placed in transit to their new stage library;
75 - have been placed in transit to be returned to their current stage library;
76 - have just been added to a rota and will already be at the correct library;
78 In the last case the item will be checked in and no message will pop up. In
79 the other cases a message will pop up requesting the item be posted to their
82 =head2 What does the --execute flag do?
84 To understand this, you will need to know a little bit about the design of
85 this script and the stockrotation modules.
87 This script operates in 3 phases: first it walks the graph of rotas, stages
88 and items. For each active rota, it investigates the items in each stage and
89 determines whether action is required. It does not perform any actions, it
90 just "sieves" all items on active rotas into "actionable" and "non-actionable"
91 baskets. We can use these baskets to perform actions against the items, or to
94 During the second phase this script then loops through the actionable baskets,
95 and performs the relevant action (initiate, repatriate, advance) on each item.
97 Finally, during the third phase we revisit the original baskets and we compile
98 reports (for instance per branch email reports).
100 When the script is run without the "--execute" flag, we perform phase 1, skip
101 phase 2 and move straight onto phase 3.
103 With the "--execute" flag we also perform the database operations.
105 So with or without the flag, the report will look the same (except for the "No
106 database updates have been performed.").
111 use Getopt::Long qw/HelpMessage :config gnu_getopt/;
114 use Koha::StockRotationRotas;
116 my $admin_email = '';
124 'admin-email|a=s' => \$admin_email,
125 'branchcode|b=s' => sub {
126 my ( $opt_name, $opt_value ) = @_;
127 my $branches = Koha::Libraries->search( {},
128 { order_by => { -asc => 'branchname' } } );
129 my $brnch = $branches->find($opt_value);
135 printf("Option $opt_name should be one of (name -> code):\n");
136 while ( my $candidate = $branches->next ) {
137 printf( " %-40s -> %s\n",
138 $candidate->branchname, $candidate->branchcode );
143 'execute|x' => \$execute,
144 'report|r=s' => sub {
145 my ( $opt_name, $opt_value ) = @_;
146 if ( $opt_value eq 'full' || $opt_value eq 'email' ) {
147 $report = $opt_value;
150 printf("Option $opt_name should be either 'email' or 'full'.\n");
154 'send-all|S' => \$send_all,
155 'send-email|s' => \$send_email,
156 'help|h|?' => sub { HelpMessage }
160 $send_email++ if ($send_all); # if we send all, then we must want emails.
166 undef = execute($report);
168 Perform the database updates, within a transaction, that are reported as
169 needing to be performed by $REPORT.
171 $REPORT should be the return value of an invocation of `investigate`.
173 This procedure WILL mess with your database.
181 my $schema = Koha::Database->new->schema;
182 $schema->storage->txn_begin;
184 # Carry out db updates
185 foreach my $item ( @{ $data->{items} } ) {
186 my $reason = $item->{reason};
187 if ( $reason eq 'repatriation' ) {
188 $item->{object}->repatriate;
190 elsif ( grep { $reason eq $_ } qw/in-demand advancement initiation/ ) {
191 $item->{object}->advance;
196 $schema->storage->txn_commit;
201 my $full_report = report_full($report);
203 Return an arrayref containing a string containing a detailed report about the
204 current state of the stockrotation subsystem.
206 $REPORT should be the return value of `investigate`.
208 No data in the database is manipulated by this procedure.
221 --------------------\n";
223 Total number of rotas: %5u
226 Total number of items: %5u
228 Stationary items: %5u
229 Actionable items: %5u
230 Total items to be initiated: %5u
231 Total items to be repatriated: %5u
232 Total items to be advanced: %5u
233 Total items in demand: %5u\n\n",
234 $data->{sum_rotas}, $data->{rotas_inactive}, $data->{rotas_active},
235 $data->{sum_items}, $data->{items_inactive}, $data->{stationary},
236 $data->{actionable}, $data->{initiable}, $data->{repatriable},
237 $data->{advanceable}, $data->{indemand};
239 if ( @{ $data->{rotas} } ) { # Per Rota details
240 $body .= sprintf "ROTAS DETAIL\n------------\n\n";
241 foreach my $rota ( @{ $data->{rotas} } ) {
242 $body .= sprintf "Details for %s [%s]:\n",
243 $rota->{name}, $rota->{id};
244 $body .= sprintf "\n Items:"; # Rota item details
245 if ( @{ $rota->{items} } ) {
247 join( "", map { _print_item($_) } @{ $rota->{items} } );
251 sprintf "\n No items to be processed for this rota.\n";
253 $body .= sprintf "\n Log:"; # Rota log details
254 if ( @{ $rota->{log} } ) {
255 $body .= join( "", map { _print_item($_) } @{ $rota->{log} } );
258 $body .= sprintf "\n No items in log for this rota.\n\n";
266 title => 'Stockrotation Report',
267 content => $body # The body of the report
269 status => 1, # We have a meaningful report
270 no_branch_email => 1, # We don't expect branch email in report
277 my $email_report = report_email($report);
279 Returns an arrayref containing a header string, with basic report information,
280 and any number of 'per_branch' strings, containing a detailed report about the
281 current state of the stockrotation subsystem, from the perspective of those
284 $REPORT should be the return value of `investigate`, and $BRANCH should be
285 either 0 (to indicate 'all'), or a specific Koha::Library object.
287 No data in the database is manipulated by this procedure.
292 my ( $data, $branch ) = @_;
298 my $branched = $data->{branched};
302 BRANCH-BASED STOCKROTATION REPORT
303 ---------------------------------\n";
304 push @{$out}, $header;
306 if ($branch) { # Branch limited report
307 push @{$out}, _report_per_branch( $branched->{ $branch->branchcode } );
309 elsif ( $data->{actionable} ) { # Full email report
310 while ( my ( $branchcode_id, $details ) = each %{$branched} ) {
311 push @{$out}, _report_per_branch($details)
312 if ( @{ $details->{items} } );
318 No actionable items at any libraries.\n\n", # The body of the report
319 no_branch_email => 1, # We don't expect branch email in report
325 =head3 _report_per_branch
327 my $branch_string = _report_per_branch($branch_details, $branchcode, $branchname);
329 return a string containing details about the stockrotation items and their
330 status for the branch identified by $BRANCHCODE.
332 This helper procedure is only used from within `report_email`.
334 No data in the database is manipulated by this procedure.
338 sub _report_per_branch {
342 if ( $branch && @{ $branch->{items} } ) {
347 my $letter = C4::Letters::GetPreparedLetter(
348 module => 'circulation',
349 letter_code => "SR_SLIP",
350 message_transport_type => 'email',
351 substitute => $branch
357 email_address => $branch->{email},
366 my $string = _print_item($item_section);
368 Return a string containing an overview about $ITEM_SECTION.
370 This helper procedure is only used from within `report_full`.
372 No data in the database is manipulated by this procedure.
386 Current Library: %s [%s]\n\n",
387 $item->{title} || "N/A", $item->{author} || "N/A",
388 $item->{callnumber} || "N/A", $item->{location} || "N/A",
389 $item->{barcode} || "N/A", $item->{onloan} ? 'Yes' : 'No',
390 $item->{reason} || "N/A", $item->{branch}->branchname,
391 $item->{branch}->branchcode;
396 undef = emit($params);
398 $PARAMS should be a hashref of the following format:
399 admin_email: the address to which a copy of all reports should be sent.
400 execute: the flag indicating whether we performed db updates
401 send_all: the flag indicating whether we should send even empty reports
402 send_email: the flag indicating whether we want to emit to stdout or email
403 report: the data structure returned from one of the report procedures
405 No data in the database is manipulated by this procedure.
407 The return value is unspecified: we simply emit a message as a side-effect or
415 # REPORT is an arrayref of at least 2 elements:
416 # - The header for the report, which will be repeated for each part
417 # - a "part" for each report we want to emit
418 # PARTS are hashrefs:
419 # - part->{status}: a boolean indicating whether the reported part is empty or not
420 # - part->{email_address}: the email address to send the report to
421 # - part->{no_branch_email}: a boolean indicating that we are missing a branch email
422 # - part->{letter}: a GetPreparedLetter hash as returned by the C4::Letters module
423 my $report = $params->{report};
424 my $header = shift @{$report};
428 foreach my $part ( @{$parts} ) {
430 if ( $part->{status} || $params->{send_all} ) {
432 # We have a report to send, or we want to send even empty
437 if ( $part->{email_address} ) {
438 $addressee = $part->{email_address};
440 elsif ( !$part->{no_branch_email} ) {
442 #push @emails, "***We tried to send a branch report, but we have no email address for this branch.***\n\n";
443 $addressee = C4::Context->preference('KohaAdminEmailAddress')
444 if ( C4::Context->preference('KohaAdminEmailAddress') );
447 if ( $params->{send_email} ) { # Only email if emails requested
448 if ( defined($addressee) ) {
449 C4::Letters::EnqueueLetter(
451 letter => $part->{letter},
452 to_address => $addressee,
453 message_transport_type => 'email',
457 "can't enqueue letter $part->{letter} for $addressee";
461 if ( $params->{admin_email} ) {
462 C4::Letters::EnqueueLetter(
464 letter => $part->{letter},
465 to_address => $params->{admin_email},
466 message_transport_type => 'email',
470 "can't enqueue letter $part->{letter} for $params->{admin_email}";
475 "-------- Email message --------" . "\n\n" . "To: "
476 . defined($addressee) ? $addressee
477 : defined( $params->{admin_email} ) ? $params->{admin_email}
480 . $part->{letter}->{title} . "\n\n"
481 . $part->{letter}->{content};
482 push @emails, $email;
487 # Emit to stdout instead of email?
488 if ( !$params->{send_email} ) {
490 # The final message is the header + body of this part.
492 $msg .= "No database updates have been performed.\n\n"
493 unless ( $params->{execute} );
495 # Append email reports to message
496 $msg .= join( "\n\n", @emails );
503 # Compile Stockrotation Report data
504 my $rotas = Koha::StockRotationRotas->search(undef,{ order_by => { '-asc' => 'title' }});
505 my $data = $rotas->investigate;
507 # Perform db updates if requested
508 execute($data) if ($execute);
512 $out_report = report_email( $data, $branch ) if $report eq 'email';
513 $out_report = report_full( $data, $branch ) if $report eq 'full';
516 admin_email => $admin_email,
518 report => $out_report,
519 send_all => $send_all,
520 send_email => $send_email,
526 Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com>