#!/usr/bin/perl =begin ------------------------------------------------------------------------- emulates function of email_alert() for records matching complex rules: notification of: granulomatous inflammation where lab_test = 'TB culture' and organisation code like 'RR8%' and authorised yesterday to chest clinic email contact =cut --------------------------------------------------------------------------- use Getopt::Std; getopts('d:'); # days our($opt_d); # warn $opt_d; exit; use strict; use warnings; my $JUST_TESTING = 0; # email to raj only ############ recipients from contacts.lib ###################################### my $duration = $opt_d || 1; # days my @recipients = qw( chest.clinic.secure ); my @cc = qw( ); # raj.secure ################################################################################ use lib '/home/raj/perl5/lib/perl5'; use Data::Dumper; use FindBin qw($Bin); # warn $Bin; use lib $Bin . '/../../../lib'; use LIMS::Local::ScriptHelpers; my $tools = LIMS::Local::ScriptHelpers->new(); $tools->test_only($JUST_TESTING); # get tools from LIMS::Local::ScriptHelpers: my $sql_lib = $tools->sql_lib(); my $config = $tools->config(); my $dbix = $tools->dbix(); # get sql statment: my $requests = $sql_lib->retr( 'granulomatous_inflammation_status_alert' ); # template: my $tt_file = 'request/message/body.tt'; # email subject line: my $subject = 'HMDS Diagnosis Status Notice'; # HMDS.LTH user_id for request_history: my $service_user = $tools->get_server_user_details(); my $result = $dbix->query($requests, $duration); while (my $vars = $result->hash) { # warn Dumper $vars; next; my $data = $tools->get_diagnosis_alert_data($vars); my $message_body = $tools->process_template($tt_file, $data); my %mail = ( config => $config, message => $message_body, subject => $subject, ); # warn Dumper \%mail; next; my $ok = $tools->send_mail(\%mail, [ @recipients, @cc ]); if ($ok) { # log to request_history: my %args = ( request_id => $vars->{request_id}, user_id => $service_user->{id}, action => 'e-mailed diagnosis alert', ); $tools->log_diagnosis_alert(\%args, \@recipients); } }