#!/usr/bin/perl

#use utf8;
use strict;
use CGI;
use Encode;
use PDF::Create;
use POSIX qw(
    floor
);

use Opals::Context;

use Time::localtime;

use Opals::Date qw(
    date_parse
    date_today
    date_text
    date_f005
);

use Opals::Template qw(
    tmpl_read
    tmpl_write
    tmpl_preference
);
use Opals::Locale qw(
    loc_getMsgFile
    loc_write
    
);


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

my $cgi = CGI->new;
my $input = $cgi->Vars();
my $pref = tmpl_preference($dbh);
my $dateToday = date_f005();
my $todayStr;

my $eidList =  $input->{'emaillist'};
#----------------------------------------------------------------------------------------------------

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

if ($permission &&  $permission->{'rpt_notice'}) {
    $eidList =~ s/\$+/,/g;
    $eidList =~ s/,$//g;
    
    $dbh->do("update opl_emailRequest set status ='waiting' , retryCount =0 where eid in ($eidList) ");
    
}

my $msgMap  = loc_getMsgFile('circ/notice.msg');
loc_write($template,$msgMap);
tmpl_write($dbh, $cgi, $cookie, $template);