package vosFacultyFDADisclosure;
use strict;
use Apache::DBI();
use CGI qw(:standard);
use HTML::Entities;
my ($path) = "../../../";
my ($title) = "FDA Disclosure Form";
my ($dsn) = "DBI:mysql:vos:localhost";
my ($user) = "vosdb_user";
my ($password) = "";
my ($sth);
my (@ary);
my ($facultyname) = '';
my ($facultyid);
my ($num_lectures);
my ($counter) = 1;
my ($header) = '';
my %roles = ();
$main::cgi = new CGI; # to take advantage of the "param" decoding method
$vosFacultyFDADisclosure::meeting_no = $main::cgi->param('id');
if (!$vosFacultyFDADisclosure::meeting_no) {
print $main::cgi->redirect('../index.iphtml');
die "";
}
$main::dbh = DBI->connect ($dsn, $user, $password, { RaiseError => 0, PrintError => 0})
or die "Could not connect to server: $DBI::err ($DBI::errstr)\n";
my %States;
my $Current_Screen;
%States = (
'Default' => \&vosFacultyFDADisclosure::input_page,
'Submit' => \&vosFacultyFDADisclosure::submission_result_page
);
$Current_Screen = param(".State") || "Default";
die "No screen for $Current_Screen" unless $States{$Current_Screen};
!>
#include ../../../includes/wp-vos-header.iphtml
;
my $SQL = "SELECT name, meeting.city, meeting.state, meeting.location, MONTHNAME(meeting.start_date), DAYOFMONTH(meeting.start_date), YEAR(meeting.end_date), MONTHNAME(meeting.end_date), DAYOFMONTH(meeting.end_date) FROM meeting WHERE meeting_no = $vosFacultyFDADisclosure::meeting_no AND meeting.workshop_no = 0 AND meeting.breakout_no = 0";
$sth = $main::dbh->prepare ($SQL) ||
die "Prepare failed: $DBI::errstr\n";
$sth->execute() ||
die "Couldn't execute query $DBI::errstr\n";
undef(@ary);
@ary = $sth->fetchrow;
$sth->finish();
if (@ary) {
print '
#include ../../../includes/wp-vos-footer.iphtml
;
sub input_page {
my $active = shift;
return unless $active;
my $access = 1;
my $username = $main::cgi->remote_user();
my $SQL = <prepare($SQL);
$sth->execute;
my @ary;
@ary = $sth->fetchrow;
$sth->finish;
$facultyid = $ary[0];
if (!$vosFacultyFDADisclosure::meeting_no) {
print $main::cgi->redirect('../index.iphtml');
die "";
}
if (!@ary) {
print $main::cgi->redirect('../index.iphtml');
die "";
}
!>
;
undef($SQL);
$SQL = "SELECT COUNT(*) FROM faculty_lecture WHERE facultyid = '$facultyid' AND meetingid= '$vosFacultyFDADisclosure::meeting_no'";
$sth = $main::dbh->prepare($SQL);
$sth->execute;
undef(@ary);
@ary = $sth->fetchrow;
$sth->finish;
if ($ary[0] eq "0") {
$access = 0;
print p('You are not listed as faculty for the above caption meeting. If this is an error, please contact VOS administrative assistant, Angela Puryear at angela@societyhq.com or phone (804) 565-6312.');
print p('Click',a({href=>"../"},'here'),'to select a different meeting.');
}
if ($access) {
$SQL = <prepare($SQL);
$sth->execute;
undef(@ary);
@ary = $sth->fetchrow;
$facultyname = $ary[0] . ' ' . $ary[1];
$facultyname .= ", $ary[2]" if $ary[2];
my $fac_addr;
$fac_addr .= "$ary[5]\n" if $ary[5];
$fac_addr .= "$ary[6]\n" if $ary[6];
$fac_addr .= "$ary[7]," if $ary[7];
$fac_addr .= " $ary[8]" if $ary[8];
$fac_addr .= " $ary[9]" if $ary[9];
$fac_addr .= "\n$ary[10]" if $ary[10];
print p(' ');
print '
DISCLOSURE FORM FOR: ' . $facultyname . '
';
print p(em('If you are not ' . $facultyname . ', you must close your web browser completely and re-login. | ',a({-href=>"./index.iphtml?id=$vosFacultyFDADisclosure::meeting_no"},'Return to Faculty Forms'),'.'));
# print "
DISCLOSURE FORM FOR: $facultyname If you are not $facultyname, you must close your web browser completely and re-login. | Return to Faculty Forms.