#!/usr/bin/perl
# Copyright 2001-2007 Leslie Richardson
# This file is part of Open Admin for Schools.
# Open Admin for Schools is free software; you can redistribute it
# and/or modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2 of
# the License, or (at your option) any later version.
%lex = ( 'Staff Member Entry' => 'Staff Member Entry',
'Member Entry' => 'Member Entry',
'Staff' => 'Staff',
'Main' => 'Main',
'Eoy' => 'Eoy',
'Unable to open template file:' => 'Unable to open template file:',
'The staff member is now stored in the database' => 'The staff member is now stored in the database',
'Start/End of Year Page' => 'Start/End of Year Page',
'Add Another Staff Member' => 'Add Another Staff Member',
'Add Another Prereg Staff Member' => 'Add Another Prereg Staff Member',
'Sorry. There was an error storing your data.' => 'Sorry. There was an error storing your data.',
'Please record the following error string' => 'Please record the following error string',
'Please contact' => 'Please contact',
'Cannot open libmeta.pl' => 'Cannot open libmeta.pl',
'Cannot open admin.conf!' => 'Cannot open admin.conf!',
'Add Staff Member Information' => 'Add Staff Member Information',
'Warning! You should have a unique userid for each staff.' =>
'Warning! You should have a unique userid for each staff.',
'This userid exists already exists.' => 'This userid exists already exists.',
'Ignore this warning if you are creating another entry' =>
'Ignore this warning if you are creating another entry',
'for the same staff.' => 'for the same staff.',
'You MUST have a unique userid and staff position.' =>
'You MUST have a unique userid and staff position.',
'Please go back and try again.' => 'Please go back and try again.',
'Preregistration' => 'Preregistration',
'Required Field' => 'Required Field',
'Bold' => 'Bold',
);
use CGI;
use DBI;
my $self='staffadd.pl';
my $q = new CGI;
print $q->header;
my %arr = $q->Vars;
# Select table to add to; staff or prereg_staff;
my ($table, $tableview);
if ( $arr{tbl} ){ # add to prereg_staff table
$table = 'prereg_staff';
$tableview = ''. $lex{Preregistration}. ''. q{ }. $lex{Staff};
} else {
$table = 'staff';
$tableview = $lex{Staff};
}
unless (require "../../etc/admin.conf") {
print $lex{'Cannot open admin.conf!'};
die "Cannot open admin.conf!";
}
unless (require "../../lib/libmeta.pl") {
print $lex{'Cannot open libmeta.pl'};
die $lex{'Cannot open libmeta.pl'};
}
$dsn = "DBI:$dbtype:dbname=$dbase";
$dbh = DBI->connect($dsn,$user,$password);
# Print Page Header
print "$doctype\n\n";
print $lex{Staff}. q{ }. $lex{'Member Entry'};
print "\n";
print "$chartype\n[ ";
print $lex{Main}, " | ";
print $lex{Eoy}, " ]
\n";
# Read in Template
unless (open (FH,"<../../template/staff.tpl")) {
print $lex{'Unable to open template file:'},"$!\n";
die $lex{'Unable to open template file:'},"$!\n";
}
my $text;
{ local $/; $text = ; close FH;}
# Parse for simple field replacement / highlighting <*name*> elements
while ( $text =~ m/\<\*(.*)\*\>/g){
push @replace, $1;
}
#print " Replacements: \n",@replace," \n";
# Create Hash to hold replacement text.
foreach my $val (@replace){
$replacement{$val} = metaReplace('staff',$val);
}
#print " Replacement Text \n",%replacement," \n";
# Now put replacement text back in.
$text =~ s{\<\*(.*?)\*\>}
{ exists($replacement{$1})
? $replacement{$1}
: $1
}gsex;
# now parse for form entry replacement elements <@name@>
# Extract fields from template
while ( $text =~ m/\<\@(.*)\@\>/g){
push @fields, $1;
}
# Preprocess Template for Values
#$text =~ s/\<\@studnum\@\>/$studnum/;
# get replacement values for fields
foreach my $val (@fields){
$values{$val} = &metaput('staff',$val,$studnum,'edit');
}
# now put field values back into $text variable...
$text =~ s{ \<\@(.*?)\@\> }
{ exists($values{$1})
? $values{$1}
: "$values{$1}-$1"
}gsex;
# print top of form, then $text, then bottom of page.
print "
\n";
#--------------
sub writeRecord {
#--------------
#foreach my $key (keys %arr) { print "K:$key V:$arr{$key} \n"; }
# Make sure we have userid and position filled....
if ( not $arr{userid} or not $arr{position} ){
print "
". $lex{'You MUST have a unique userid and staff position.'}. "\n";
print $lex{'Please go back and try again.'}. "