Subversion Repositories PEEPS

#!/usr/bin/perl

# Redirect error messages to a log of my choosing. (it's annoying to filter for errors in the shared env)

#my $error_log_path = $ENV{SERVER_NAME} eq "volunteers.rollercon.com" ? "/home3/rollerco/logs/" : "/tmp/";

#close STDERR;

#open STDERR, '>>', $error_log_path.'vorc_error.log' or warn "Failed to open redirected logfile ($0): $!";

#warn "Redirecting errors to ${error_log_path}vorc_error.log";

use strict;

use PEEPS;

use CGI qw/param header start_html url/;

use CGI::Cookie;

our $h = HTML::Tiny->new( mode => 'html' );

my $dbh = getRCDBH ();

$ENV{HTTPS} = 'ON' if $ENV{SERVER_NAME} =~ /^peeps/;

use DateTime;

my $dt = DateTime->today;

$dt =~ s/T00\:00\:00$//;

my $cookie_string = authenticate (1) || die;

my ($EML, $PWD, $LVL) = split /&/, $cookie_string;

my $user = $ORCUSER;

#my $activated = $ORCUSER->{access};

my %LOOKUP = (

# colname   =>  [qw(DisplayName       N    type     status)],   status ->  static | default | <blank>

  person_id    => [qw(MemberID      5    number  id         )],

  policy_id    => [qw(PolicyID     10    number  policy_id  )],

  first_name   => [qw(FirstName    15    text    name_first )],

  last_name    => [qw(LastName     20    text    name_last  )],

  skater_name  => [qw(SkaterName   25    text    derby_name )],

);

my %NAME              = map  { $_ => $LOOKUP{$_}->[0] } keys %LOOKUP;

my %colOrderHash      = map  { $_ => $LOOKUP{$_}->[1] } keys %LOOKUP;

sub byfield { $colOrderHash{$a} <=> $colOrderHash{$b}; }

my %colFilterTypeHash = map  { $_ => $LOOKUP{$_}->[2] } keys %LOOKUP;

my %field_name =        map  { $_ => $LOOKUP{$_}->[3] } keys %LOOKUP;

print header (-cookie=>CGI::Cookie->new(-name=>'PEEPSAUTH',-value=>"$cookie_string"));

printRCHeader("Insurance Verification");

#  push @policyhistory, $h->div ({ class=>"rTableRow ".($policy{id} == $active_policy ? "highlighted" : "shaded"), onClick=>"window.location.href='view_policy?id=$policy{id}'" },[ $h->div ({ class=>"rTableCellr", style=>"font-size: smaller;" }, $policy{id}, $policy{policy_name}, $policy{start}, $policy{end}) ]);

my ($EARCH, @ERRORS, $count);

foreach (keys %LOOKUP) {

  $EARCH->{$_} = WebDB::trim scalar param $_;

  if ($colFilterTypeHash{$_} eq "number" and $EARCH->{$_} !~ /^\d*$/) {

    push @ERRORS, "$NAME{$_} should be a number (and you entered '$EARCH->{$_}').";

    $EARCH->{$_} = "";

  }

  if ($colFilterTypeHash{$_} eq "text" and $EARCH->{$_} !~ qr/^[\p{L}\p{M}\p{P}\s\'-]*$/u) {

    push @ERRORS, "$NAME{$_} should be text (and you entered '$EARCH->{$_}').";

    $EARCH->{$_} = "";

  }

  $count++ unless !$EARCH->{$_};

}

push @ERRORS, "At least two fields must be included to search (you entered $count)." unless $count != 1;

print $h->form ( { name => "insuranceVerification", method => "post", action => url }, [

  $h->div ({class=>"hint"}, "At least two fields are required. If more than two are entered, they will all need to match."),

  scalar @ERRORS ? $h->div ({class=>"error"}, @ERRORS) : [],

  $h->div ({ class => "rTableRow" },

    map {  $h->div ({class=>"rTableCellr"}, $NAME{$_}).$h->div ({class=>"rTableCellr"}, $h->input ({name => "$_", value => $EARCH->{$_}})) } sort byfield keys %LOOKUP),

#  "Member ID: ", $h->input ({name => "person_id"}), $h->br,

#  "Policy ID: ", $h->input ({name => "policy_id"}), $h->br,

#  "First Name: ", $h->input ({name => "first_name"}), $h->br,

#  "Last Name: ", $h->input ({name => "last_name"}), $h->br,

#  "Skater Name: ", $h->input ({name => "skater_name"}), $h->br,

  $h->button ("Verify Insurance")#, $h->button ("Reset")

]);

if ($count and !scalar @ERRORS) {

  my $where = join " and ", map { "$field_name{$_} = ?" } grep { $EARCH->{$_} } sort byfield keys %LOOKUP;

  my ($person_id, $first, $last, $derby_name, $policy_id, $league) = $dbh->selectrow_array ("select id, name_first, name_last, derby_name, policy_id, group_concat(distinct league_name SEPARATOR ', ') from v_person where ".$where, undef, map { $EARCH->{$_} } grep { $EARCH->{$_} } sort byfield keys %LOOKUP);

  if ($policy_id) {

    $first =~ s/(.).+(..)/$1 . '*' x (length($&)-3) . $2/e;

    $last  =~ s/(.).+(..)/$1 . '*' x (length($&)-3) . $2/e;

    my $policy = getCoverageByID ($policy_id, $person_id);

    print $h->div ({class => "rTableRow"}, "Results:", [$h->div ({class=>"rTableCell"}, "$first $last", $derby_name." [".$league."]", "Insured Through: $policy->{end}")]);

#    logit ($user->{id}, "Successfull Insurance Lookup: $derby_name [$league] Through: $policy->{end}");

    logit ($user->{id}, "Successfull Insurance Lookup: ".join (": ", map { "$field_name{$_} = $EARCH->{$_}" } grep { $EARCH->{$_} } sort byfield keys %LOOKUP));

  } else {

    print $h->div ({class => "rTableRow"}, "No Matching Results Found.");

    logit ($user->{id}, "Failed Insurance Lookup: ".join (": ", map { "$field_name{$_} = $EARCH->{$_}" } grep { $EARCH->{$_} } sort byfield keys %LOOKUP));

  }

}

print $h->close ("body", "html");