#!/usr/bin/perl
# Copyright 2001-2024 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; version 2 of
# the License, only.
# Basic version with only simple form add.
my %lex = ('Please Log In' => 'Please Log In',
'Error' => 'Error',
'Homework' => 'Homework',
'Main' => 'Main',
'Subject' => 'Subject',
'Date' => 'Date',
'Time' => 'Time',
'Continue' => 'Continue',
'Topic' => 'Topic',
'Description' => 'Description',
'Edit' => 'Edit',
'Delete' => 'Delete',
'Due Date' => 'Due Date',
'New' => 'New',
'or' => 'or',
'Required Field Missing' => 'Required Field Missing',
'Record Updated' => 'Record Updated',
'Contact' => 'Contact',
'Subject-Section' => 'Subject-Section',
'Are you sure' => 'Are you sure',
'Record' => 'Record',
'Yes' => 'Yes',
'Deleted' => 'Deleted',
'Not Found' => 'Not Found',
);
my $self = 'hwkdeled.pl';
use DBI;
use CGI;
use CGI::Session;
use Time::JulianDay;
my $q = new CGI;
my %arr = $q->Vars;
eval require "../../etc/admin.conf";
if ( $@ ) {
print $lex{Error}. " $@ \n";
die $lex{Error}. " $@ \n";
}
my $dsn = "DBI:$dbtype:dbname=$dbase";
my $dbh = DBI->connect($dsn,$user,$password);
# Set Page Title
my $title = "$lex{Edit}/$lex{Delete} $lex{Homework}";
# Get Session
my $session = new CGI::Session("driver:$dbtype;serializer:FreezeThaw",
undef,{Handle => $dbh}) or die CGI::Session->errstr;
if ( not $session->param('logged_in') ){
$userid = $session->param('userid');
print $q->header( -charset, $charset );
print qq{
\n};
if ( not $arr{page} ) {
showStartPage();
} elsif ( $arr{page} == 1 ) {
delete $arr{page};
editRecord( $arr{id} );
} elsif ( $arr{page} == 2 ) {
delete $arr{page};
writeRecord();
} elsif ( $arr{page} == 3 ) {
delete $arr{page};
confirmDelete( $arr{id} );
} elsif ( $arr{page} == 4 ) {
delete $arr{page};
deleteRecord();
}
#----------------
sub showStartPage {
#----------------
# Get Subjects Taught
my @subjects;
my $sth = $dbh->prepare("select subjsec from subject where teacher = ? order by description");
$sth->execute( $userid );
if ( $DBI::errstr ) { print $DBI::errstr; die $DBI::errstr; }
while ( my $subjsec = $sth->fetchrow ) {
push @subjects, $subjsec;
}
my $sth1 = $dbh->prepare("select id, subjsec, duedatetime, topic, description from plan_homework
where subjsec = ? order by duedatetime");
my $sth2 = $dbh->prepare("select description from subject where subjsec = ?");
my $globalfirst = 1; # test to see if any homework records, any subjects
foreach my $subjsec ( @subjects ) {
# find any records
$sth1->execute( $subjsec );
if ( $DBI::errstr ) { print $DBI::errstr; die $DBI::errstr; }
my $first = 1;
while ( my $ref = $sth1->fetchrow_hashref ) {
$globalfirst = 0; # if any homework records
if ( $first ) {
# Get Description
$sth2->execute( $subjsec );
if ( $DBI::errstr ) { print $DBI::errstr; die $DBI::errstr; }
my $desc = $sth2->fetchrow;
print qq{
$desc ( $subjsec )
\n};
# Start Table
print qq{
\n};
print qq{
$lex{'Due Date'}
$lex{Description}
\n};
$first = 0;
}
print qq{
$ref->{duedatetime}
};
print qq{
$ref->{topic} ($ref->{description})
\n};
print qq{
\n};
print qq{
\n};
print qq{
\n};
}
if ( not $first ) { print qq{
\n}; }
} # end of subject loop
if ( $globalfirst ) {
print qq{
$lex{Homework}: $lex{'Not Found'}
\n};
}
print qq{\n};
exit;
}
#-------------
sub editRecord {
#-------------
my $id = shift;
# Load Homework Record
my $sth = $dbh->prepare("select * from plan_homework where id = ?");
$sth->execute( $id );
if ($DBI::errstr){ print $DBI::errstr; die $DBI::errstr; }
my $ref = $sth->fetchrow_hashref;
if ($DBI::errstr){ print $DBI::errstr; die $DBI::errstr; }
# Load Subject
my %subjects = ();
$sth = $dbh->prepare("select description, subjsec from subject where teacher = ?");
$sth->execute( $userid );
if ($DBI::errstr){ print $DBI::errstr; die $DBI::errstr; }
while ( my ($description, $subjsec) = $sth->fetchrow ) {
$subjects{$subjsec} = $description;
}
# Start Form
print qq{