3 # Copyright 2007 Liblime Ltd
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use C4::Scheduler qw( add_at_job get_jobs remove_at_job );
23 use C4::Reports::Guided qw( get_saved_reports );
24 use C4::Auth qw( get_template_and_user );
26 use C4::Output qw( output_html_with_http_headers );
27 use Koha::DateUtils qw( dt_from_string );;
34 if ( C4::Context->config('supportdir') ) {
35 $base = C4::Context->config('supportdir');
38 $base = "/usr/share/koha/bin";
41 my $CONFIG_NAME = $ENV{'KOHA_CONF'};
43 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
45 template_name => "tools/scheduler.tt",
48 flagsrequired => { tools => 'schedule_tasks' },
52 my $op = $input->param('op') // q{};
53 my $id = $input->param('id');
55 if ( $op eq 'cud-add' ) {
57 my $startdate = dt_from_string( scalar $input->param('startdate'), 'iso' )->ymd;
59 # Formatting it for Schedule::At
60 $startdate = join('', (split /-/, $startdate));
61 my $starttime = $input->param('starttime');
62 $starttime =~ s/\://g;
63 my $start = $startdate . $starttime;
64 my $report = $input->param('report');
67 my $report_id = int($report);
69 $saved_report = Koha::Reports->find($report_id);
71 if ( !$saved_report ) {
75 my $format = $input->param('format');
77 unless ( $format eq 'text' || $format eq 'csv' || $format eq 'html' ) {
81 my $email = $input->param('email');
83 my $is_valid = Koha::Email->is_valid($email);
88 if ( $report && $format && $email ) {
90 #NOTE: Escape any single quotes in email since we're wrapping it in single quotes in bash
91 $email =~ s/'/'"'"'/g;
93 "export KOHA_CONF=\"$CONFIG_NAME\"; "
94 . "$base/cronjobs/runreport.pl $report --format=$format --to='$email'";
96 unless ( add_at_job( $start, $command ) ) {
97 $template->param( job_add_failed => 1 );
101 $template->param( job_add_failed => 1 );
103 } elsif ( $op eq 'cud-delete' ) {
104 my $jobid = $input->param('jobid');
105 remove_at_job($jobid);
108 my $jobs = get_jobs();
110 foreach my $job ( values %$jobs ) {
114 @jobloop = sort { $a->{TIME} cmp $b->{TIME} } @jobloop;
116 my $reports = get_saved_reports();
118 foreach my $report (@$reports) {
119 $report->{'selected'} = 1 if $report->{'id'} eq $id;
123 $template->param( 'savedreports' => $reports );
124 $template->param( JOBS => \@jobloop );
125 my $time = localtime(time);
126 $template->param( 'time' => $time );
127 output_html_with_http_headers $input, $cookie, $template->output;