#!/usr/bin/perl
#use utf8;
use strict;
use CGI;
use POSIX qw(
    floor
);
use Opals::Context;
use Date::Calc qw(Day_of_Week Week_Number Day_of_Year);

use Opals::User qw(
    user_getInformation
);
use Opals::Date qw(
    date_f005
);
use Opals::Template qw(
    tmpl_read
    tmpl_write
    tmpl_preference
);

use Opals::Locale qw(
    loc_getMsgFile
    loc_write
);

use JSON;
my $dbh = Opals::Context->dbh();
END { $dbh->disconnect(); }

my $cgi = CGI->new;
my $input = $cgi->Vars();



my ($permission, $cookie, $template) = tmpl_read(
        {
            dbh             => $dbh,
            cgi             => $cgi,
            tmplFile        => 'report/BEDSreport.tmpl',
            reqPermission   => 'rpt_catRec',
        }
);

    $template->param(hlpUrl     => Opals::Constant->getHlpUrl('BEDSreport') );
    my $pref = tmpl_preference($dbh);
    my $dateToday = date_f005();
    $dateToday =~ s/([\d]{4})([\d]{2})([\d]{2})[\d]+\.(0|1)/$1-$2-$3/;
    my $dateFirst = $pref->{'dateFirst'};
    my $dateLast  = $pref->{'dateLast'};
    
    my $dateFrom= $input->{'dateFrom'};
    my $dateTo  = $input->{'dateTo'};
    
    $dateFrom = $dateFirst if ( !$dateFrom );
    $dateFrom .= " 00:00:00";
    $dateTo = $dateLast if ( !$dateTo );
    $dateTo .= " 23:59:59";
    $template->param(
                     dateFrom  =>$dateFrom,
                     dateTo    =>$dateTo,
                     dateToday =>$dateToday
                    );
  

    my $msgMap            =loc_getMsgFile('report/reports.msg');
    loc_write($template,$msgMap);
 
tmpl_write($dbh, $cgi, $cookie, $template);
#-----------------------------------------------------------------------------------------------