#!/usr/bin/perl
# Copyright 2001-2022 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.
my %lex = ('Withdraw' => 'Withdraw',
'Student' => 'Student',
'No Student(s) Found' => 'No Student(s) Found',
'Withdrawn' => 'Withdrawn',
'Contact' => 'Contact',
'Main' => 'Main',
'Error' => 'Error',
'Last,First/Last/Initials/Studnum' => 'Last,First/Last/Initials/Studnum',
'Search' => 'Search',
'Name' => 'Name',
'Birthdate' => 'Birthdate',
'Grade' => 'Grade',
'Homeroom' => 'Homeroom',
'Province' => 'Province',
'Country' => 'Country',
'Description' => 'Description',
'Reason' => 'Reason',
'Code' => 'Code',
'Transfer' => 'Transfer',
'Date' => 'Date',
'Yes' => 'Yes',
'Delete' => 'Delete',
'Insert' => 'Insert',
'Cannot open' => 'Cannot open',
'Student Number' => 'Student Number',
);
use DBI;
use CGI;
use Time::JulianDay;
my $self = 'movestudent.pl';
eval require "../../etc/admin.conf";
if ( $@ ) {
print $lex{Error}. ": $@ \n";
die $lex{Error}. ": $@\n";
}
# Load audit write function
eval require "../../lib/libaudit.pl";
if ( $@ ) {
print $lex{Error}. ": $@ \n";
die $lex{Error}. ": $@\n";
}
my $q = new CGI;
print $q->header( -charset, $charset );
my %arr = $q->Vars;
my $dsn = "DBI:$dbtype:dbname=$dbase";
my $dbh = DBI->connect($dsn,$user,$password);
# Page Header.
my $title = qq{Move $lex{Student} to Withdrawn};
print qq{$doctype\n$title
\n};
print qq{$chartype\n\n};
print qq{\n};
print qq{
\n};
if ( not $arr{page} ) {
showStartPage();
} elsif ( $arr{page} == 1 ) {
delete $arr{page};
moveStudent();
}
#----------------
sub showStartPage {
#----------------
print qq{\n};
print qq{\n};
exit;
} # end of showStartPage
#------------------
sub moveStudent {
#------------------
# foreach my $key (keys %arr ) { print qq{K:$key V:$arr{$key} \n}; }
# Passed fields: studnum
# Check that the student IS a current student.
# Shouldn't be necessary, since we only search current students at the start.
my $sth = $dbh->prepare("select * from student where studnum = ?"); # not studentwd/studentall
$sth->execute( $arr{studnum} );
if ($DBI::errstr){ print $DBI::errstr; die $DBI::errstr; }
my $ref = $sth->fetchrow_hashref; # use this for transfer records.
$sth->execute( $arr{studnum} );
if ($DBI::errstr){ print $DBI::errstr; die $DBI::errstr; }
my @student = $sth->fetchrow;
if ( not $student[0] ) { # not a current student.
print qq{
$lex{Error}: You cannot withdraw a student who is already withdrawn!