#! /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.
$parpage = '/index.html';
my %lex = ('Main' => 'Main',
'Homework' => 'Homework',
'No Courses Found' => 'No Courses Found',
'View' => 'View',
'Continue' => 'Continue',
'Grade' => 'Grade',
'Error' => 'Error',
'by' => 'by',
'Teacher' => 'Teacher',
'Start Date' => 'Start Date',
'Date' => 'Date',
'Topic' => 'Topic',
'Description' => 'Description',
'Or' => 'Or',
'Not Found' => 'Not Found',
'Courses' => 'Courses',
);
my $self = 'viewhomework.pl';
use DBI;
use CGI;
# The location where to load the config file from.
my $configlocation = '../etc';
eval require "$configlocation/admin.conf";
if ( $@ ) {
print $lex{Error}. ": $@ \n";
die $lex{Error}. ": $@\n";
}
my $q = new CGI;
print $q->header( -charset, $charset );
my %arr = $q->Vars;
# Get Current Date
my @tim = localtime(time);
my $year = $tim[5] + 1900;
my $month = $tim[4] + 1;
my $currdate = "$year-$month-$tim[3]";
my $dsn = "DBI:$dbtype:dbname=$dbase";
my $dbh = DBI->connect($dsn,$rouser,$ropassword);
$dbh->{mysql_enable_utf8} = 1;
# Read in values from conf_system;
my $sth = $dbh->prepare("select datavalue from conf_system
where dataname = ?");
foreach my $dataname ( qw( r_SupressSubject r_AdditionalComments )) {
$sth->execute( $dataname );
if ( $DBI::errstr ) { print $DBI::errstr; die $DBI::errstr; }
my $datavalue = $sth->fetchrow;
eval $datavalue;
if ( $@ ) {
print $lex{Error}. " $@ \n";
die $lex{Error}. " $@\n";
}
}
my $title = "$lex{View} $lex{Homework}";
print qq{$doctype\n$title\n};
print qq{\n};
print qq{\n};
print qq{$chartype\n\n};
print qq{[ $lex{Main} ]\n};
print qq{
$title
\n};
if ( not $arr{page} ) {
showStartPage();
} elsif ( $arr{page} == 1 ) {
delete $arr{page};
showHomework();
}
#----------------
sub showStartPage {
#----------------
# Read grades
my $sth = $dbh->prepare("select distinct grade from student
where grade is not NULL and grade != ''");
$sth->execute;
if ($DBI::errstr) { print $DBI::errstr; die $DBI::errstr; }
my @grades = ();
while ( my $grade = $sth->fetchrow ) {
push @grades, $grade;
}
@grades = sort {$a <=> $b} @grades;
# Read Teachers
$sth = $dbh->prepare("select distinct s.teacher, st.lastname, st.firstname
from subject s, staff st
where s.teacher = st.userid and
(s.teacher is not NULL ) and ( s.teacher != '' )
order by st.lastname, st.firstname, st.userid");
$sth->execute;
if ($DBI::errstr) { print $DBI::errstr; die $DBI::errstr; }
my %teacher = ();
while ( my ( $userid, $lastname, $firstname ) = $sth->fetchrow ) {
$teacher{"$lastname, $firstname ($userid)"} = $userid;
}
print qq{\n};
exit;
}
#---------------
sub showHomework {
#---------------
# foreach my $key ( sort keys %arr ) { print qq{K:$key V:$arr{$key} \n}; }
if ( $arr{grade} ) { # find homework by grade
# Read grades to verify
my $sth = $dbh->prepare("select distinct grade from student
where (grade is not NULL ) and (grade != '' )");
$sth->execute;
if ($DBI::errstr) { print $DBI::errstr; die $DBI::errstr; }
my %grades = ();
while ( my $grade = $sth->fetchrow ) {
$grades{$grade} = 1;
}
if ( not $grades{ "$arr{grade}" } ) { # no grade match; crack attempt
print qq{