#!/usr/local/bin/perl -wT

use strict;
use CGI;
use CGI::Carp 'fatalsToBrowser';
use DBI;
use Data::FormValidator;
use MIME::Lite;


my $query = new CGI;

#Inserts the Date and Time; used in EMAIL REPLY
my $datetime = localtime;

#Insert Date and Time in MMDDYYhhmm format; used in Confirmation Number
my (undef,$min,$hour,$mday,$mon,$year) = localtime;
my $log_date = sprintf '%02d%02d%02d%02d%02d', $mon + 1, $mday,
       $year % 100, $hour, $min;

# Create a random number; used in Confirmation Number
my $random = int( rand(51)) + 25;

# Central Office email recipient
my $email_CO = 'taylorb@dof.state.va.us';

# Assigned variables (left of =) from FORM INPUT (right of =)
my $name_logger = $query->param('logger_name');		# required
my $address1_logger = $query->param('logger_add1');	# required
my $address2_logger = $query->param('logger_add2');	# not required
my $city_logger = $query->param('logger_city');		# required
my $state = $query->param('logger_state');		# required
my $zipcode = $query->param('logger_zipcode');		# required
my $phone_logger = $query->param('logger_phone');	# required
my $email_logger = $query->param('logger_email');	# required
my $name_landowner = $query->param('landowner_name');	# not required
my $phone_landowner = $query->param('landowner_phone');	# not required
my $county = $query->param('County');			# required
my $location = $query->param('location');		# required
my $logging_start = $query->param('logging_begin');	# required
my $acres = $query->param('acres');			# required
my $Submit = $query->param('Submit');			#
my $Reset = $query->param('Reset');			#

# FORM INPUT: validation criteria
my $logger_info = {
	logger_info => {
	    optional     =>
		[ qw( name_landowner phone_landowner) ],
	    required     =>
		[ qw( name_logger address1_logger city_logger state zipcode phone_logger email_logger county location logging_start acres) ],
	    constraints  =>
		{
		    email_logger	=> "email",
		    phone_logger	=> "american_phone",
		    zipcode		=> '/^\s*\d{5}(?:[-]\d{4})?\s*$/',
		    state		=> "state",

		},
	},


# County names; region email, county email, abbreviations
my %counties = (
Accomack => { 
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'ACC',
},
Albemarle => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'ALB',
},
Alleghany => {
  Region => '',
  County => 'crafta@dof.state.va.us',
  Abbrev => 'ALL',
},
Amelia => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'AME',
},
Amherst => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'AMH',
},
Appomattox => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'APP',
},
Arlington => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'ARL',
},
Augusta => {
  Region => '',
  County => 'mohlerk@dof.state.va.us',
  Abbrev => 'AUG',
},
Bath => {
  Region => '',
  County => 'moyersr@dof.state.va.us',
  Abbrev => 'BAT',
},
Bedford => {
  Region => '',
  County => 'milesr@dof.state.va.us',
  Abbrev => 'BED',
},
Bland => {
  Region => 'caricob@dof.state.va.us',
  County => 'millerw@dof.state.va.us',
  Abbrev => 'BLA',
  },
Botetourt => {
  Region => '',
  County => 'millers@dof.state.va.us',
  Abbrev => 'BOT',
},
Brunswick => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'BRU',
},
Buchanan => {
  Region => 'caricob@dof.state.va.us',
  County => 'millerw@dof.state.va.us',
  Abbrev => 'BUH',
},
Buckingham => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'BUK',
},
Campbell => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'CAM',
},
Caroline => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'CAR',
},
Carroll => {
  Region => 'caricob@dof.state.va.us',
  County => 'millerw@dof.state.va.us',
  Abbrev => 'CRL',
},
'Charles City' => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'CHC',
},
Charlotte => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'CHA',
},
Chesterfield => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'CFD',
},
Clarke => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'CLA',
},
Craig => {
  Region => '',
  County => 'crafta@dof.state.va.us',
  Abbrev => 'CRA',
},
Culpeper => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'CUL',
},
Cumberland => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'CUM',
},
Dickenson => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'DIC',
},
Dinwiddie => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'DIN',
},
Essex => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'ESS',
},
Fairfax => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'FAX',
},
Fauquier => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'FAQ',
},
Floyd => {
  Region => '',
  County => 'polantl@dof.state.va.us',
  Abbrev => 'FLO',
},
Fluvanna => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'FLU',
},
Franklin => {
  Region => 'sourss@dof.state.va.us',
  County => 'lawr@dof.state.va.us',
  Abbrev => 'FRA',
},
Frederick => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'FRE',
},
Giles => {
  Region => 'clarkj@dof.state.va.us',
  County => '',
  Abbrev => 'GIL',
},
Gloucester => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'GLO',
},
Goochland => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'GOO',
},
Grayson => {
  Region => 'caricob@dof.state.va.us',
  County => 'millerw@dof.state.va.us',
  Abbrev => 'GRA',
},
Greene => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'GRN',
},
Greensville => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'GNV',
},
Halifax => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'HAL',
},
Hanover => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'HAN',
},
Henrico => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'HEN',
},
Henry => {
  Region => '',
  County => 'keithk@dof.state.va.us',
  Abbrev => 'HNY',
},
Highland => {
  Region => '',
  County => 'moyersr@dof.state.va.us',
  Abbrev => 'HIG',
},
'Isle of Wight' => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'IOW',
},
'James City' => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'JAC',
},
'King and Queen' => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'KAQ',
},
'King George' => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'KGE',
},
'King William' => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'KWM',
},
Lancaster => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'LAN',
},
Lee => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'LEE',
},
Loudoun => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'LUD',
},
Louisa => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'LSA',
},
Lunenburg => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'LUN',
},
Madison => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'MAD',
},
Mathews => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'MAT',
},
Mecklenburg => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'MEC',
},
Middlesex => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'MID',
},
Montgomery => {
  Region => '',
  County => 'yoppc@dof.state.va.us',
  Abbrev => 'MON',
},
Nelson => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'NEL',
},
'New Kent' => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'NKT',
},
Northampton => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'NHP',
},
Northumberland => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'NUB',
},
Nottoway => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'NOT',
},
Orange => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'ORA',
},
Page => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'PAG',
},
Patrick => {
  Region => 'wrighth@dof.state.va.us',
  County => '',
  Abbrev => 'PAT',
},
Pittsylvania => {
  Region => 'macel@dof.state.va.us',
  County => 'inger@dof.state.va.us',
  Abbrev => 'PIT',
},
Powhatan => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'POW',
},
'Prince Edward' => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'PED',
},
'Prince George' => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'PGE',
},
'Prince William' => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'PWM',
},
Pulaski => {
  Region => '',
  County => 'cooperj@dof.state.va.us',
  Abbrev => 'PUL',
},
Rappahannock => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'RAP',
},
Richmond => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'RMD',
},
Roanoke => {
  Region => '',
  County => 'millers@dof.state.va.us',
  Abbrev => 'RKE',
},
Rockbridge => {
  Region => '',
  County => 'mohlerk@dof.state.va.us',
  Abbrev => 'RCB',
},
Rockingham => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'RKH',
},
Russell => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'RUS',
},
Scott => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'SCO',
},
Shenandoah => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'SHE',
},
Smyth => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'SMY',
},
Southampton => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'SHP',
},
Spotsylvania => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'SPO',
},
Stafford => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'STA',
},
Surry => {
  Region => 'conarya@dof.state.va.us',
  County => '',
  Abbrev => 'SUR',
},
Sussex => {
  Region => 'conarya@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'SUS',
},
Tazewell => {
  Region => 'caricob@dof.state.va.us',
  County => 'millerw@dof.state.va.us',
  Abbrev => 'TAZ',
},
Warren => {
  Region => 'odonnellg@dof.state.va.us',
  County => 'odonnellg@dof.state.va.us',
  Abbrev => 'WAR',
},
Washington => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'WAS',
},
Westmoreland => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'WES',
},
Wise => {
  Region => 'caricob@dof.state.va.us',
  County => 'sullivanc@dof.state.va.us',
  Abbrev => 'WIS',
},
Wythe => {
  Region => 'caricob@dof.state.va.us',
  County => 'millerw@dof.state.va.us',
  Abbrev => 'WYT',
},
York => {
  Region => 'bronnerc@dof.state.va.us',
  County => 'rowec@dof.state.va.us',
  Abbrev => 'YOR',
},
);

# Validate County was received
if ( ! {$counties}) {
  # No county was passed.
  # Display error page to the user, or ignore the request.
}
elsif ( ! exists($counties{$county}) ) {
  # They sent a county, but we have no data for it.
  # Display error page to the user, or ignore the request.
}
else {
  # Valid county was selected.
  # return EMAIL ADDRESS
  my $email_county = $counties{$query->param('County')}->{County} || '';
  # return REGION EMAIL ADDRESS
  my $email_region = $counties{$query->param('County')}->{Region} || '';
  # return ABBREVIATION
  my $county_abbrev = $counties{$query->param('County')}->{Abbrev} || '';
}


# Create CONFIRMATION NUMBER from values
my $conf_number = "I-$county_abbrev-$random-$log_date";

####################################################################
# EMAIL REPLY: Begin
####################################################################

# EMAIL REPLY: create message BODY
my $email_reply_body = << "END OF MESSAGE";
Thank you for notifying us of your logging job. Your information was sent: $datetime
Logger name: $name_logger
Logger phone number: $phone_logger
Logger email address: $email_logger 
Logger address: $address1_logger $address2_logger $city_logger $state $zipcode
Landowner information, if known: $name_landowner $phone_landowner
County where logging will occur: $county
Directions to logging site: $location
Date to begin logging: $logging_start
Estimated size of logging operation: $acres
Confirmation Number: $conf_number
END OF MESSAGE


my $msg = MIME::Lite->new( 
               From     => '$email_CO',
               To       => '$email_logger',
	       Cc	=> '$email_county $email_region $email_CO',
               Subject  => "Logging Notification: Confirmation Number",
               Type     => 'TEXT',
               Data     => '$email_reply_body'
			   );

$msg->send();

####################################################################
# EMAIL REPLY: End 
####################################################################

my $validator = new Data::FormValidator( $logger_info );

##################################################################
# BEGIN database connection code; send file data into a .csv table
##################################################################
my $dbh = DBI->connect("DBI:CSV:f_dir=/home/state/dof/wq/logger-notify-table.csv");
$dbh->{'csv_tables'}->{'logger'} = { 'file' => 'logger.csv'};
my $sth = $dbh->do("INSERT INTO logger VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", undef, $datetime, $conf_number, $name_logger, $phone_logger, $email_logger, $address1_logger, $address2_logger, $city_logger, $state, $zipcode, $name_landowner, $phone_landowner, $county, $location, $logging_start, $acres); 

$sth->execute() or die "Cannot execute: " . $sth->errstr();
$sth->finish();
$dbh->disconnect();
#################################################################
# END database connection code
#################################################################

# Output on error
sub PrintError { 
print $query->header();
print $message ;

exit 0 ;
return 1 ; 
}

# Output on success
sub PrintSuccess { 
print $query->header();
print $email_reply_body ;

exit;
}
}




