$studentid = $studentid[0];
} else {
$studentid = $_POST['student'];
}
print "\n <h1>View Grades</h1>\n <br>\n <table align='center' width='600' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='grades' action='./index.php' method='POST'>\n <br />\n <table width='595' class='dynamiclist' cellpadding='5' cellspacing='0'>\n <tr class='header'>\n <th>Assignment Name</th>\n <th>Date Submitted</th>\n <th>Earned Points</th>\n <th>Possible Points</th>\n <th>Grade</th>\n <th>Comment</th>\n <th>Late</th>\n </tr>";
// Get the list of grades and students for this assignment //
$query = mysql_query("SELECT assignmentid, title FROM assignments WHERE courseid = {$_POST['selectclass']} ORDER BY duedate DESC") or die("ViewGrades.php: Unable to get the list of assignments for this class - " . mysql_error());
require_once "DBFunctions.php";
$row = 0;
while ($assignment = mysql_fetch_row($query)) {
$q = mysql_query("SELECT gradeid, points, submitdate, islate, comment FROM grades WHERE studentid = '{$studentid}' AND courseid = '{$_POST['selectclass']}' AND assignmentid = '{$assignment['0']}'") or die("ManageGrades.php: Unable to get a list of gradess - " . mysql_error());
$grade = mysql_fetch_row($q);
$q = mysql_query("SELECT title,totalpoints FROM assignments WHERE assignmentid = '{$assignment['0']}'");
$assignmentinfo = mysql_fetch_row($q);
$row++;
print "<tr class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n <td>{$assignment['1']}</td>\n <td>" . (convertfromdb($grade[2]) != "//" ? convertfromdb($grade[2]) : "") . "</td>\n <td>{$grade['1']}</td>\n <td>{$assignmentinfo['1']}</td>\n\t<td>";
// Calculate and display the letter grade //
$q = mysql_query("SELECT aperc,bperc,cperc,dperc,fperc FROM courses WHERE courseid = {$_POST['selectclass']}") or die("ManageGrades.php: Unable to get the grade percentages - " . mysql_error());
$percs = mysql_fetch_row($q);
if ($assignmentinfo[1] == 0) {
$assignmentinfo[1] = 1;
}
$letter = $grade[1] / $assignmentinfo[1];
$letter = $letter * 100;
if ($assignmentinfo[1] == 0) {
$letter = -1;
}
if ($grade[3] != NULL) {
if ($letter == -1) {
print "Total Not Found";
} elseif ($letter >= $percs[0]) {
print "<script language='JavaScript'>\n\n // Function to make sure the assignment wants to delete the assignment(s) //\n function validate()\n {\n if( document.assignments.selectassignment.value > 0 )\n {\n\tvar confirmed = confirm(\"Are you sure you want to delete this assignment?\");\n\n\tif( confirmed == true )\n\t{\n\t document.assignments.submit();\n\t}\n }\n else\n {\n\talert('You must select a assignment to delete.');\n }\n }\n\n\n // Function to make sure only one checkbox has been selected //\n function checkboxes()\n {\n if( document.assignments.selectassignment.value == 1 )\n {\n\tdocument.assignments.submit();\n }\n else\n {\n\tif( document.assignments.selectassignment.value > 1 )\n\t{\n\t alert('You can only edit one assignment at a time.');\n\t}\n\telse\n\t{\n\t alert('You must select a assignment to edit.');\n\t}\n }\n }\n\n\n // Function to keep track of how many checkboxes are checked //\n function updateboxes(row)\n {\n row = row + 2;\n if(document.assignments.elements[row].checked)\n {\n\tdocument.assignments.selectassignment.value = Math.round(document.assignments.selectassignment.value) + 1;\n }\n else\n {\n\tdocument.assignments.selectassignment.value = Math.round(document.assignments.selectassignment.value) - 1;\n }\n }\n </script>\n\n <h1>Manage Assignments</h1>\n <br><br>\n <table align='center' width='600' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='assignments' action='./index.php' method='POST'>\n <input type='button' value='Add' onClick='document.assignments.page2.value=4;document.assignments.submit();'>\n <input type='button' value='Edit' onClick='document.assignments.page2.value=5;checkboxes();'>\n <input type='button' value='Delete' onClick='document.assignments.deleteassignment.value=1;validate();'>\n <br><br>\n <table cellspacing='0' width='600' cellpadding='8' class='dynamiclist'>\n <tr class='header'>\n\t<th colspan='6'><h2>{$coursename}</th>\n </tr>\n <tr class='header'>\n\t<td> </td>\n\t<th>Title</th>\n\t<th>Assigned Task</th>\n\t<th>Possible Points</th>\n\t<th>Date Assigned</th>\n\t<th>Date Due</th>\n </tr>";
// Get the total number of assignments to know how many pages to have //
$query = mysql_query("SELECT COUNT(*) FROM assignments") or die("ManageAssignments.php: Unable to retrieve total number of assignments - " . mysql_error());
$numrows = mysql_result($query, 0);
$numpages = ceil($numrows / 25);
if ($_POST["onpage"] == "") {
$_POST["onpage"] = 1;
}
// Get and display the assignments //
$query = mysql_query("SELECT assignmentid, title, totalpoints, assigneddate, duedate, assignmentinformation FROM assignments WHERE courseid = {$_POST['selectclass']} ORDER BY assigneddate DESC") or die("ManageAssignments.php: Unable to get a list of assignments - " . mysql_error());
$row = 0;
$actualrow = 0;
while ($assignment = mysql_fetch_row($query)) {
$row++;
if ($row > $_POST["onpage"] * 25 - 25 && $row <= $_POST["onpage"] * 25) {
$actualrow++;
$assignment[2] = number_format($assignment[2], 0);
$assignment[3] = convertfromdb($assignment[3]);
$assignment[4] = convertfromdb($assignment[4]);
print "<tr class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n\t <td><input type='checkbox' name='delete[]' value='{$assignment['0']}' onClick='updateboxes({$actualrow});' /></td>\n\t <td>{$assignment['1']}</td>\n\t <td style='text-align: left;'>{$assignment['5']}</td>\n\t <td>{$assignment['2']}</td>\n\t <td>{$assignment['3']}</td>\n\t <td>{$assignment['4']}</td>\n\t </tr>";
}
}
print " </table>\n <br>\n <input type='button' value='Add' onClick='document.assignments.page2.value=4;document.assignments.submit();'>\n <input type='button' value='Edit' onClick='document.assignments.page2.value=5;checkboxes();'>\n <input type='button' value='Delete' onClick='document.assignments.deleteassignment.value=1;validate();'>\n <br><br>\n\n <center>Page: ";
for ($i = 1; $i <= $numpages; $i++) {
if ($i == $_POST["onpage"]) {
print "<a href='JavaScript: document.assignments.deleteassignment.value=0;document.assignments.page2.value=2;document.assignments.onpage.value={$i};document.assignments.submit();' class='selectedpagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
} else {
print "<a href='JavaScript: document.assignments.deleteassignment.value=0;document.assignments.page2.value=2;document.assignments.onpage.value={$i};document.assignments.submit();' class='pagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
}
}
print "\n</center>\n <input type='hidden' name='deleteassignment'>\n <input type='hidden' name='selectassignment'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='onpage' value='{$_POST['onpage']}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='selectclass' value='{$_POST['selectclass']}' />\n <input type='hidden' name='page' value='{$page}'>\n </form>\n </td>\n </tr>\n </table>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n <empty>\n </td>\n </tr>\n </table>\n ";
deleteTerm($delete[$i]);
}
}
print "<script language='JavaScript'>\n // Function to make sure the user wants to delete the term(s) //\n function validate()\n {\n if( document.terms.selectterm.value > 0 )\n {\n\tvar confirmed = confirm(\"Deleteing a term will also delete the semesters, classes, bulletins, tardies, attendance, assignments, and registrations that occured during that term. \\n \\nAre you sure?\");\n\n\tif( confirmed == true )\n\t{\n\t document.terms.submit();\n\t}\n }\n else\n {\n\talert('You must select a term to delete.');\n }\n }\n\n\n // Function to make sure only one checkbox has been selected //\n function checkboxes()\n {\n if( document.terms.selectterm.value == 1 )\n {\n\tdocument.terms.submit();\n }\n else\n {\n\tif( document.terms.selectterm.value > 1 )\n\t{\n\t alert('You can only edit one term at a time.');\n\t}\n\telse\n\t{\n\t alert('You must select a term to edit.');\n\t}\n }\n }\n\n\n // Function to keep track of how many checkboxes are checked //\n function updateboxes(row)\n {\n row = row + 2;\n if(document.terms.elements[row].checked)\n {\n\tdocument.terms.selectterm.value = Math.round(document.terms.selectterm.value) + 1;\n }\n else\n {\n\tdocument.terms.selectterm.value = Math.round(document.terms.selectterm.value) - 1;\n }\n }\n </script>\n\n <h1>Manage Terms</h1>\n <br><br>\n <table align='center' width='450' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='terms' action='./index.php' method='POST'>\n <input type='button' value='Add' onClick='document.terms.page2.value=8;document.terms.submit();'>\n <input type='button' value='Edit' onClick='document.terms.page2.value=12;checkboxes();'>\n <input type='button' value='Delete' onClick='document.terms.deleteterm.value=1;validate();'>\n <br><br>\n <table cellspacing='0' width='450' cellpadding='8' class='dynamiclist'>\n <tr class='header'>\n <td> </td>\n <th>Term Name</th>\n <th>Start Date</th>\n <th>End Date</th>\n </tr>";
// Get the total number of teachers to know how many pages to have //
$query = mysql_query("SELECT COUNT(*) FROM terms") or die("ManageTerms.php: Unable to retrieve total number of terms - " . mysql_error());
$numrows = mysql_result($query, 0);
$numpages = ceil($numrows / 25);
if ($_POST["onpage"] == "") {
$_POST["onpage"] = 1;
}
// Get and display the terms //
$query = mysql_query("SELECT termid,title,startdate,enddate FROM terms ORDER BY enddate DESC");
$row = 0;
$actualrow = 0;
while ($term = mysql_fetch_row($query)) {
$row++;
if ($row > $_POST["onpage"] * 25 - 25 && $row <= $_POST["onpage"] * 25) {
$actualrow++;
print "<tr class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n\t <td><input type='checkbox' name='delete[]' value='{$term['0']}' onClick='updateboxes({$actualrow});' /></td>\n\t <td>{$term['1']}</td>\n\t <td>" . convertfromdb($term[2]) . "</td>\n\t <td>" . convertfromdb($term[3]) . "</td>\n\t <tr>";
}
}
print " </table>\n <br>\n <input type='button' value='Add' onClick='document.terms.page2.value=8;document.terms.submit();'>\n <input type='button' value='Edit' onClick='document.terms.page2.value=12;checkboxes();'>\n <input type='button' value='Delete' onClick='document.terms.deleteterm.value=1;validate();'>\n\n <br><br>\n <font color='red'>* Deleting a term will also delete the semesters, classes in each semester, and the information for those classes</font>\n\t<br><br>\n\n <center>Page: ";
for ($i = 1; $i <= $numpages; $i++) {
if ($i == $_POST["onpage"]) {
print "<a href='JavaScript: document.terms.deleteterm.value=0;document.terms.page2.value=6;document.terms.onpage.value={$i};document.terms.submit();' class='selectedpagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
} else {
print "<a href='JavaScript: document.terms.deleteterm.value=0;document.terms.page2.value=6;document.terms.onpage.value={$i};document.terms.submit();' class='pagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
}
}
print "\n</center>\n <input type='hidden' name='deleteterm'>\n <input type='hidden' name='selectterm'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='onpage' value='{$_POST['onpage']}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n </form>\n </td>\n </tr>\n </table>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n <empty>\n </td>\n </tr>\n </table>\n ";
<?php
$id = $_POST["delete"];
// Get the information for the current announcement //
$query = mysql_query("SELECT * FROM schoolbulletins WHERE sbulletinid = {$id['0']}") or die("EditAnnouncement.php: Unable to retrieve the information about the announcement to edit - " . mysql_error());
$announcement = mysql_fetch_row($query);
print "<h1>Edit Announcement</h1>\n\n <form name='editannouncement' action='./index.php' method='POST'>\n <br><br><br>\n <table cellspacing='0' cellpadding='5' class='dynamiclist' align='center' width='600'>\n <tr class='header'>\n\t<th>Title</th>\n\t<th>Message</th>\n\t<th>Date</th>\n </tr>\n <tr class='even' valign='top'>\n\t<td><input type='text' name='title' maxlength='15' value='{$announcement['1']}' /></td>\n\t<td><textarea name='message' rows='5' cols='30'>{$announcement['2']}</textarea></td>\n\t<td><input type='text' name='date' value='" . convertfromdb($announcement[3]) . "' /></td>\n </tr>\n </table>\n\n <br>\n\n <table cellpadding='0' border='0' align='center' width='600'>\n <tr>\n <td>\n\t<input type='button' value='Edit Announcement' onClick='document.editannouncement.editannouncement.value=1;document.editannouncement.page2.value=4;document.editannouncement.submit();'>\n\t<input type='button' value='Cancel' onClick='document.editannouncement.page2.value=4;document.editannouncement.submit();'>\n </td>\n </tr>\n </table>\n\n <input type='hidden' name='editannouncement'>\n <input type='hidden' name='announcementid' value='{$id['0']}'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n\n </form>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n\t \n </td>\n </tr>\n </table>\n ";
}
print "<script language='JavaScript'>\n\n // Function to make sure the user wants to delete the semester(s) //\n function validate()\n {\n if( document.semesters.selectsemester.value > 0 )\n {\n\tvar confirmed = confirm(\"Deleteing a semester will also delete the classes, bulletins, tardies, attendance, assignments, and registrations that occured during that semester. \\n \\nAre you sure?\");\n\n\tif( confirmed == true )\n\t{\n\t document.semesters.submit();\n\t}\n }\n else\n {\n\talert('You must select a semester to delete.');\n }\n }\n\n\n // Function to make sure only one checkbox has been selected //\n function checkboxes()\n {\n if( document.semesters.selectsemester.value == 1 )\n {\n\tdocument.semesters.submit();\n }\n else\n {\n\tif( document.semesters.selectsemester.value > 1 )\n\t{\n\t alert('You can only edit one semester at a time.');\n\t}\n\telse\n\t{\n\t alert('You must select a semester to edit.');\n\t}\n }\n }\n\n\n // Function to keep track of how many checkboxes are checked //\n function updateboxes(row)\n {\n row = row + 2;\n if(document.semesters.elements[row].checked)\n {\n\tdocument.semesters.selectsemester.value = Math.round(document.semesters.selectsemester.value) + 1;\n }\n else\n {\n\tdocument.semesters.selectsemester.value = Math.round(document.semesters.selectsemester.value) - 1;\n }\n }\n </script>\n\n <h1>Manage Semesters</h1>\n <br><br>\n <table align='center' width='600' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='semesters' action='./index.php' method='POST'>\n <input type='button' value='Add' onClick='document.semesters.page2.value=7;document.semesters.submit();'>\n <input type='button' value='Edit' onClick='document.semesters.page2.value=13;checkboxes();'>\n <input type='button' value='Delete' onClick='document.semesters.deletesemester.value=1;validate();'>\n <br><br>\n <table cellspacing='0' width='600' cellpadding='8' class='dynamiclist'>\n <tr class='header'>\n\t<td> </td>\n\t<th>Semester Name</th>\n\t<th>Term</th>\n\t<th>Start Date</th>\n\t<th>Midterm Date</th>\n\t<th>End Date</th>\n\t<th>Half</th>\n </tr>";
// Get the total number of semesters to know how many pages to have //
$query = mysql_query("SELECT COUNT(*) FROM semesters") or die("ManageSemesters.php: Unable to retrieve total number of semesters - " . mysql_error());
$numrows = mysql_result($query, 0);
$numpages = ceil($numrows / 25);
if ($_POST["onpage"] == "") {
$_POST["onpage"] = 1;
}
// Get and display the semesters //
$query = mysql_query("SELECT semesterid,termid,title,startdate,midtermdate,enddate,type FROM semesters ORDER BY enddate DESC");
$row = 0;
$actualrow = 0;
while ($smstr = mysql_fetch_row($query)) {
$query2 = mysql_query("SELECT title FROM terms WHERE termid='{$smstr['1']}'");
$term = mysql_result($query2, 0);
$row++;
if ($row > $_POST["onpage"] * 25 - 25 && $row <= $_POST["onpage"] * 25) {
$actualrow++;
print "<tr class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n\t <td><input type='checkbox' name='delete[]' value='{$smstr['0']}' onClick='updateboxes({$actualrow});' /></td>\n\t <td>{$smstr['2']}</td>\n\t <td>{$term}</td>\n\t <td>" . convertfromdb($smstr[3]) . "</td>\n\t <td>" . convertfromdb($smstr[4]) . "</td>\n\t <td>" . convertfromdb($smstr[5]) . "</td>\n\t <td>" . ($smstr[6] == 1 ? "First" : "Second") . "</td>\n\t </tr>";
}
}
print " </table>\n <br>\n <input type='button' value='Add' onClick='document.semesters.page2.value=7;document.semesters.submit();'>\n <input type='button' value='Edit' onClick='document.semesters.page2.value=13;checkboxes();'>\n <input type='button' value='Delete' onClick='document.semesters.deletesemester.value=1;validate();'>\n <br><br>\n <font color='red'>* Deleting a semester will also delete the classes in that semester and the information for those classes</font>\n\t<br><br>\n\n <center>Page: ";
for ($i = 1; $i <= $numpages; $i++) {
if ($i == $_POST["onpage"]) {
print "<a href='JavaScript: document.semesters.deletesemester.value=0;document.semesters.page2.value=5;document.semesters.onpage.value={$i};document.semesters.submit();' class='selectedpagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
} else {
print "<a href='JavaScript: document.semesters.deletesemester.value=0;document.semesters.page2.value=5;document.semesters.onpage.value={$i};document.semesters.submit();' class='pagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
}
}
print "\n</center>\n <input type='hidden' name='deletesemester'>\n <input type='hidden' name='selectsemester'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='onpage' value='{$_POST['onpage']}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n </form>\n </td>\n </tr>\n </table>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n <empty>\n </td>\n </tr>\n </table>\n ";
<?php
$id = $_POST["delete"];
// Get the information for the current assignment //
$query = mysql_query("SELECT * FROM assignments WHERE assignmentid = {$id['0']}") or die("EditAssignment.php: Unable to retrieve the information about the assignment to edit - " . mysql_error());
$assignment = mysql_fetch_row($query);
print "<h1>Edit Assignment</h1>\n\n <form name='editassignment' action='./index.php' method='POST'>\n <br><br><br>\n <table cellspacing='0' cellpadding='5' class='dynamiclist' align='center' width='700'>\n <tr class='header'>\n\t<th>Title</th>\n\t<th>Assigned Task</th>\n\t<th>Total Points</th>\n\t<th>Date Assigned</th>\n\t<th>Date Due</th>\n </tr>\n <tr class='even' valign='top'>\n\t<td><input type='text' name='title' maxlength='15' size='15' value='{$assignment['2']}' /></td>\n\t<td><textarea name='task'>{$assignment['6']}</textarea></td>\n\t<td><input type='text' name='total' maxlength='6' size='15' value='" . number_format($assignment[3], 0) . "' /></td>\n\t<td><input type='text' name='assigneddate' maxlength='10' size='15' value='" . convertfromdb($assignment[4]) . "' /></td>\n\t<td><input type='text' name='duedate' maxlength='10' size='15' value='" . convertfromdb($assignment[5]) . "' /></td>\n </tr>\n </table>\n\n <br>\n\n <table cellpadding='0' border='0' align='center' width='700'>\n <tr>\n <td>\n\t<input type='button' value='Edit Assignment' onClick='document.editassignment.editassignment.value=1;document.editassignment.page2.value=2;document.editassignment.submit();'>\n\t<input type='button' value='Cancel' onClick='document.editassignment.page2.value=2;document.editassignment.submit();'>\n </td>\n </tr>\n </table>\n\n <input type='hidden' name='editassignment'>\n <input type='hidden' name='assignmentid' value='{$id['0']}'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='selectclass' value='{$_POST['selectclass']}' />\n <input type='hidden' name='logout'>\n <input type='hidden' name='wastotal' value='{$assignment['3']}'>\n <input type='hidden' name='wasdate' value='{$assignment['5']}'>\n <input type='hidden' name='page' value='{$page}'>\n\n </form>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n\t \n </td>\n </tr>\n </table>\n ";
$_POST["assignment"] = $assignment[0];
}
print "<option value='{$assignment['0']}' " . ($_POST['assignment'] == $assignment[0] && $_POST['assignment'] != NULL ? "SELECTED" : "") . ">{$assignment['1']}</option>";
}
print " </select>\n <br /><br />\n <table width='595' class='dynamiclist' cellpadding='5' cellspacing='0'>\n <tr class='header'>\n <th> </th>\n <th>Student Name</th>\n <th>Date Submitted</th>\n <th>Earned Points</th>\n <th>Possible Points</th>\n <th>Grade</th>\n <th>Late</th>\n </tr>";
// Get the list of grades and students for this assignment //
$query = mysql_query("SELECT DISTINCT s.studentid, s.fname, s.lname FROM students s, registrations r WHERE s.studentid = r.studentid AND r.courseid = {$_POST['selectclass']} ORDER BY UPPER(s.lname) ASC") or die("ManageGrades.php: Unable to get the list of students for this class - " . mysql_error());
require_once "DBFunctions.php";
$row = 0;
while ($student = mysql_fetch_row($query)) {
$q = mysql_query("SELECT gradeid, points, comment, submitdate, islate, studentid, comment FROM grades WHERE assignmentid = '{$_POST['assignment']}' AND courseid = '{$_POST['selectclass']}' AND studentid = '{$student['0']}'") or die("ManageGrades.php: Unable to get a list of gradess - " . mysql_error());
$grade = mysql_fetch_row($q);
$q = mysql_query("SELECT title,totalpoints FROM assignments WHERE assignmentid = '{$_POST['assignment']}'");
$assignment = mysql_fetch_row($q);
$row++;
print "<tr class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n <td><input type='checkbox' name='delete[]' value='{$student['0']}' onClick='updateboxes({$row});' /></td>\n <td>{$student['1']} {$student['2']}</td>\n <td>" . (convertfromdb($grade[3]) != "//" ? convertfromdb($grade[3]) : "") . "</td>\n <td>{$grade['1']}</td>\n <td>{$assignment['1']}</td>\n\t<td>";
// Calculate and display the letter grade //
$q = mysql_query("SELECT aperc,bperc,cperc,dperc,fperc FROM courses WHERE courseid = {$_POST['selectclass']}") or die("ManageGrades.php: Unable to get the grade percentages - " . mysql_error());
$percs = mysql_fetch_row($q);
if ($assignment[1] == 0) {
$assignment[1] = 1;
}
$letter = $grade[1] / $assignment[1];
$letter = $letter * 100;
if ($assignment[1] == 0) {
$letter = -1;
}
if ($grade[4] != NULL) {
if ($letter == -1) {
print "Total Not Found";
} elseif ($letter >= $percs[0]) {
<?php
print "<h1>View Announcements</h1>\n <br><br>\n <table align='center' width='600' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='announcements' action='./index.php' method='POST'>\n <table cellspacing='0' width='600' cellpadding='8' class='dynamiclist'>\n <tr class='header'>\n\t<th>Title</th>\n\t<th>Message</th>\n\t<th>Date</th>\n </tr>";
// Get the total number of announcements to know how many pages to have //
$query = mysql_query("SELECT COUNT(*) FROM schoolbulletins") or die("ViewAnnouncements.php: Unable to retrieve total number of announcements - " . mysql_error());
$numrows = mysql_result($query, 0);
$numpages = ceil($numrows / 25);
if ($_POST["onpage"] == "") {
$_POST["onpage"] = 1;
}
// Get and display the announcements //
$query = mysql_query("SELECT * FROM schoolbulletins ORDER BY bulletindate DESC") or die("ViewAnnouncements.php: Unable to retrieve the announcements - " . mysql_error());
$row = 0;
$actualrow = 0;
while ($announcement = mysql_fetch_row($query)) {
$row++;
if ($row > $_POST["onpage"] * 25 - 25 && $row <= $_POST["onpage"] * 25) {
$actualrow++;
print "<tr class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n\t <td><b>{$announcement['1']}</b></td>\n\t <td class='announcement'>{$announcement['2']}</td>\n\t <td>" . convertfromdb($announcement[3]) . "</td>\n\t </tr>";
}
}
print " </table>\n <br><br>\n\n <center>Page: ";
for ($i = 1; $i <= $numpages; $i++) {
if ($i == $_POST["onpage"]) {
print "<a href='JavaScript: document.announcements.deleteannouncement.value=0;document.announcements.page2.value=4;document.announcements.onpage.value={$i};document.announcements.submit();' class='selectedpagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
} else {
print "<a href='JavaScript: document.announcements.deleteannouncement.value=0;document.announcements.page2.value=4;document.announcements.onpage.value={$i};document.announcements.submit();' class='pagenum' onMouseover=\"window.status='Go to page {$i}';return true;\" onMouseout=\"window.status='';return true;\">{$i}</a> \n";
}
}
print "\n</center>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='onpage' value='{$_POST['onpage']}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n </form>\n </td>\n </tr>\n </table>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n <empty>\n </td>\n </tr>\n </table>\n ";
$_POST["student"] = $student[0];
}
print "<option value='{$student['0']}' " . ($_POST['student'] == $student[0] && $_POST['student'] != NULL ? "SELECTED" : "") . ">{$student['1']} {$student['2']}</option>";
}
print " </select>\n <br /><br />\n <table width='400' class='dynamiclist' cellpadding='5' cellspacing='0'>\n <tr class='header' align='center'>\n <th> </th><th>Tardy</th><th>Absent</th>\n </tr>";
// Get the date restrictions for the current semester //
if ($_POST['semester'] != NULL) {
$query = mysql_query("SELECT startdate, enddate FROM semesters WHERE semesterid = {$_POST['semester']}");
$semesterdates = mysql_fetch_row($query);
// Get the list of registrations for this student //
$query = mysql_query("SELECT sattendid,sattenddate,type FROM schoolattendance WHERE studentid = '{$_POST['student']}' AND '{$semesterdates['0']}' <= sattenddate AND sattenddate <= '{$semesterdates['1']}' ORDER BY sattenddate ASC") or die("ManageAttendance.php: Unable to get a list of registrations - " . mysql_error());
$row = 0;
while ($reg = mysql_fetch_row($query)) {
$row++;
if ($reg[2] == 'tardy') {
$class[0] = $reg[1];
} else {
$class[1] = $reg[1];
}
print "<tr style='color: red; font-weight: bold;' align='center' class='" . ($row % 2 == 0 ? "even" : "odd") . "'>\n <td><input type='checkbox' name='delete[]' value='{$reg['0']}' onClick='updateboxes({$row});' /></td>\n <td>" . ($class[0] != "" ? convertfromdb($class[0]) : "") . "</td>\n <td>" . ($class[1] != "" ? convertfromdb($class[1]) : "") . "</td>\n </tr>\n ";
unset($class);
}
if ($row == 0) {
print "<tr class='even'><td> </td><td>N/A</td><td>N/A</td></tr>";
}
$query = mysql_query("SELECT count(*) FROM schoolattendance WHERE type='tardy' AND studentid = '{$_POST['student']}' AND '{$semesterdates['0']}' <= sattenddate AND sattenddate <= '{$semesterdates['1']}'") or die("ManageAttendance.php: Unable to get the total number of tardies - " . mysql_error());
$tardytotal = mysql_fetch_row($query);
$query = mysql_query("SELECT count(*) FROM schoolattendance WHERE type='absent' AND studentid = '{$_POST['student']}' AND '{$semesterdates['0']}' <= sattenddate AND sattenddate <= '{$semesterdates['1']}'") or die("ManageAttendance.php: Unable to get the total number of absences - " . mysql_error());
$absenttotal = mysql_fetch_row($query);
}
print "\n <tr class='header' align='center'>\n\t<td><b>Totals:</td><td>{$tardytotal['0']}</td><td>{$absenttotal['0']}</td>\n </tr>\n </table>\n <br />\n <input type='button' value='Add' onClick='document.registration.addattend.value=1;document.registration.page2.value=31;document.registration.submit();'> <input type='button' value='Delete' onClick='document.registration.deletereg.value=1;validate();'>\n\n <input type='hidden' name='addattend' />\n <input type='hidden' name='deletereg' />\n <input type='hidden' name='selectreg' />\n <input type='hidden' name='page2' value='{$page2}' />\n <input type='hidden' name='logout' />\n <input type='hidden' name='page' value='{$page}' />\n </form>\n </td>\n </tr>\n </table>\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n <empty>\n </td>\n </tr>\n </table>\n ";
<?php
$id = $_POST['delete'];
$query = mysql_query("SELECT submitdate, points, comment, islate, gradeid FROM grades WHERE studentid = '{$id['0']}' AND assignmentid = '{$_POST['assignment']}'") or die("EditGrade.php: Unable to retrieve the information about the grade - " . mysql_error());
$grade = mysql_fetch_row($query);
print "<h1>Edit Grade</h1>\n\n <form name='editgrade' action='./index.php' method='POST'>\n <br><br><br>\n <table cellspacing='0' cellpadding='5' class='dynamiclist' align='center' width='500'>\n <tr class='header'>\n\t<th>Student Name</th>\n\t<th>Date Submitted</th>\n\t<th>Earned Points</th>\n\t<th>Comment</th>\n\t<th>Late</th>\n </tr>\n <tr class='even' valign='top'>\n\t<td>";
$query = mysql_query('SELECT fname, lname FROM students WHERE studentid =\'' . $id[0] . '\'') or die('EditGrade.php: Unable to get the student\'s name - ' . mysql_error());
$student = mysql_fetch_row($query);
print "{$student['0']} {$student['1']}";
print "\t</td>\n\t<td><input type='text' name='gradedate' maxlength='10' size='10' value='" . (convertfromdb($grade[0]) != "//" ? convertfromdb($grade[0]) : "") . "' /></td>\n\t<td><input type='text' name='points' maxlength='5' size='5' value='" . number_format($grade[1], 1) . "' /></td>\n\t<td><textarea cols='20' rows='3' name='comment'>{$grade['2']}</textarea></td>\n\t<td><input type='checkbox' name='late' value='1'" . ($grade[3] == 1 ? "CHECKED" : "") . " /></td>\n </tr>\n </table>\n\n <br>\n\n <table cellpadding='0' border='0' align='center' width='500'>\n <tr>\n <td><input type='button' value='Edit Grade' onClick='document.editgrade.editgrade.value=1;document.editgrade.page2.value=3;document.editgrade.submit();'> <input type='button' value='Cancel' onClick='document.editgrade.page2.value=3;document.editgrade.submit();'></td>\n </tr>\n </table>\n\n <input type='hidden' name='editgrade' value=''>\n <input type='hidden' name='gradeid' value='{$grade['4']}' />\n <input type='hidden' name='wasgrade' value='" . number_format($grade[1], 1) . "' />\n <input type='hidden' name='wasdate' value='" . (convertfromdb($grade[0]) != "//" ? convertfromdb($grade[0]) : "") . "' />\n <input type='hidden' name='student' value='{$id['0']}' />\n <input type='hidden' name='assignment' value='{$_POST['assignment']}' />\n <input type='hidden' name='selectclass' value='{$_POST['selectclass']}' />\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='date'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n\n </form>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n\t \n </td>\n </tr>\n </table>\n ";
<?php
$id = $_POST["delete"];
// Get the information for the current semester //
$query = mysql_query("SELECT title, startdate, midtermdate, enddate, type FROM semesters WHERE semesterid = {$id['0']}") or die("EditSemester.php: Unable to retrieve the information about the semester to edit - " . mysql_error());
$semester = mysql_fetch_row($query);
$query = mysql_query("SELECT termid,title FROM terms");
print "<h1>Edit Semester</h1>\n\n <form name='editsemester' action='./index.php' method='POST'>\n <br><br><br>\n <table cellspacing='0' cellpadding='5' class='dynamiclist' align='center' width='600'>\n <tr class='header'>\n\t<th>Semester Name</th>\n\t<th>Term</th>\n\t<th>Start Date</th>\n\t<th>Midterm Date</th>\n\t<th>End Date</th>\n\t<th>Half</th>\n </tr>\n <tr class='even'>\n\t<td><input type='text' name='title' maxlength='15' value='{$semester['0']}' /></td>\n\t<td><select name='term'>";
// print out the list of terms for the drop-down box //
while ($terms = mysql_fetch_row($query)) {
print "<option value='{$terms['0']}'>{$terms['1']}</option>\n";
}
print "</select>\n\t</td>\n\t<td><input type='text' maxlength='10' name='startdate' size='8' value='" . convertfromdb($semester[1]) . "' /></td>\n\t<td><input type='text' maxlength='10' name='middate' size='8' value='" . convertfromdb($semester[2]) . "' /></td>\n\t<td><input type='text' maxlength='10' name='enddate' size='8' value='" . convertfromdb($semester[3]) . "' /></td>\n\t<td>\n\t <select name='half'>\n\t <option value='1' " . ($semester[4] == 1 ? "SELECTED" : "") . ">First</option>\n\t <option value='2' " . ($semester[4] == 2 ? "SELECTED" : "") . ">Second</option>\n\t </select>\n\t</td>\n </tr>\n </table>\n\n <br>\n\n <table cellpadding='0' border='0' align='center' width='600'>\n <tr>\n <td>\n\t<input type='button' value='Edit Semester' onClick='document.editsemester.editsemester.value=1;document.editsemester.page2.value=5;document.editsemester.submit();'>\n\t<input type='button' value='Cancel' onClick='document.editsemester.page2.value=5;document.editsemester.submit();'>\n </td>\n </tr>\n </table>\n\n <input type='hidden' name='editsemester'>\n <input type='hidden' name='semesterid' value='{$id['0']}'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n\n </form>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n\t \n </td>\n </tr>\n </table>\n ";
<?php
$id = $_POST["delete"];
// Get the information for the current term //
$query = mysql_query("SELECT title, startdate, enddate FROM terms WHERE termid = {$id['0']}") or die("EditTerm.php: Unable to retrieve the information about the term to edit - " . mysql_error());
$term = mysql_fetch_row($query);
print "<h1>Edit Term</h1>\n\n <form name='editterm' action='./index.php' method='POST'>\n <br><br><br>\n <table cellspacing='0' cellpadding='5' class='dynamiclist' align='center' width='450'>\n <tr class='header'>\n\t<th>Term Name</th>\n\t<th>Start Date</th>\n\t<th>End Date</th>\n </tr>\n <tr class='even'>\n\t<td><input type='text' name='title' maxlength='15' value='{$term['0']}' /></td>\n\t<td><input type='text' name='startdate' value='" . convertfromdb($term[1]) . "' /></td>\n\t<td><input type='text' name='enddate' value='" . convertfromdb($term[2]) . "' /></td>\n </tr>\n </table>\n\n <br>\n\n <table cellpadding='0' border='0' align='center' width='450'>\n <tr>\n <td>\n\t<input type='button' value='Edit Term' onClick='document.editterm.editterm.value=1;document.editterm.page2.value=6;document.editterm.submit();'>\n\t<input type='button' value='Cancel' onClick='document.editterm.page2.value=6;document.editterm.submit();'>\n </td>\n </tr>\n </table>\n\n <input type='hidden' name='editterm'>\n <input type='hidden' name='termid' value='{$id['0']}'>\n <input type='hidden' name='page2' value='{$page2}'>\n <input type='hidden' name='logout'>\n <input type='hidden' name='page' value='{$page}'>\n\n </form>\n\n <table width='520' border=0 cellspacing=0 cellpadding=0 height=1>\n <tr>\n <td valign='top'>\n\t \n </td>\n </tr>\n </table>\n ";
