if (!empty($value)) {
$lockedGrade = makeSQLsafe($value);
$sql = "\n INSERT into lockedGrades (student_id, class_id, lockedGrade)\n VALUES(" . $stud . "," . $classID . ",'" . $lockedGrade . "')\n ON DUPLICATE KEY UPDATE\n lockedGrade='" . $lockedGrade . "'";
$db->query($sql);
} else {
// remove from db
$sql = "DELETE from lockedGrades where student_id = " . $stud . " AND class_id = " . $classID;
$db->query($sql);
}
}
}
}
$order_by = $_SESSION[$_CONF['sess_name'] . '_gradebook_sortBy'];
$bc = "blue";
$t = "Gradebook - Class Selection";
$b = "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=\"classes\">\n\t\t\t<center>" . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $classID, 'class_id', "classes") . "\n <br />\n Sort Assignments by : \n <select name=gradebook_sortBy onChange=document.forms['classes'].submit();>\n <option value=\"assignments.due_date desc\"";
if ($_SESSION[$_CONF['sess_name'] . '_gradebook_sortBy'] == "assignments.due_date desc") {
$b .= " selected";
}
$b .= ">Date (descending)</option>\n <option value=\"assignments.due_date asc\"";
if ($_SESSION[$_CONF['sess_name'] . '_gradebook_sortBy'] == "assignments.due_date asc") {
$b .= " selected";
}
$b .= ">Date (ascending)</option>\n <option value=\"categories.category_name\"";
if ($_SESSION[$_CONF['sess_name'] . '_gradebook_sortBy'] == "categories.category_name") {
$b .= " selected";
$order_by .= ",assignments.due_date asc";
}
$b .= ">Category Name</option>\n </select> \n </form>\n </center>";
$main .= make_box($t, $b, $bc) . "<br />";
$bc = "";
$fromClassID = -1;
if (isset($_POST['from_class_id'])) {
$fromClassID = $_POST['from_class_id'];
}
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_class'])) {
$classID = $_SESSION[$_CONF['sess_name'] . '_selected_class'];
}
$t = "Schedule Students";
$b = "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=classes>\n\t\t\t<center>" . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $classID, 'class_id', "classes") . "</center></form>";
$main .= make_box($t, $b);
if (isset($_POST['copy_from'])) {
$t = "Copy From Another Class";
$bc = "yellow";
$b = "<table border=0 cellspacing=0 cellpadding=3>\n\t\t\t\t<tr><td>Copy From Class...<br />";
$b .= "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST>";
$b .= get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $fromClassID, 'from_class_id', "classes", "off");
$b .= "</td><td>";
/** the copy to is from the previous screen POST variables... **/
$b .= "You are copying the students to...<br />";
$sql2 = "SELECT classes.class_id, courses.course_name, terms.term_name, terms.term_start_date, terms.term_end_date\n\t\t\t\tFROM courses, classes, terms\n\t\t\t\tWHERE classes.class_id=" . $classID . "\n AND courses.course_id=classes.course_id\n AND terms.term_id=classes.term_id";
$result2 = $db->query($sql2);
$row2 = $result2->fetch_assoc();
$b .= $row2['course_name'] . " - " . $row2['term_name'] . "<br />";
$b .= "</td>";
$b .= "<tr><td colspan=2 align=center>\n\t\t\t\t<input type=submit class=submit name=copy_to value=\"Copy Students\" />\n\t\t\t\t<input type=hidden name=to_class_id value=" . $classID . " />\n\t\t\t\t</td></tr></form>\n\t\t\t\t</table>";
$main .= make_box($t, $b, $bc);
}
if (isset($_POST['copy_to'])) {
/**
Need to change this so I get the list of assignemnts for this class
So I can add to the grades table for each of these students....
<?php
if ($_SESSION[$_CONF['sess_name'] . '_isTeacher']) {
global $info;
$cid = -1;
$className = $termName = $teacherName = "";
$_SESSION[$_CONF['sess_name'] . '_selected_teacher'] = $_SESSION[$_CONF['sess_name'] . '_myUID'];
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_class'])) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_class'];
$result = get_class_info($cid);
$row = $result->fetch_assoc();
$term_id = $row['term_id'];
$className = $row['course_name'];
$termName = $row['term_name'];
$teacherName = $row['first_name'] . " " . $row['last_name'];
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
}
$t = "Class Score Summary";
$b = "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=classes>\n\t\t\t<center>" . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_selected_teacher'], $cid, 'class_id', "classes") . "</center></form><br />";
if ($cid != -1) {
$classArray = array($cid => $className);
include 'classSummary.php';
$b .= "<span style=color:red>NOTE: Red grades mean they are locked by the teacher to that value rather than the calculated grade.</span>" . $summary_table . "<br />" . $print_button;
}
// end if isset class_id
$main .= make_box($t, $b);
} else {
$main .= login_error();
}
if (isset($_SESSION[$_CONF['sess_name'] . '_selected_student'])) {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
}
/** the following is used for sorting the grades on this page only... **/
if (!isset($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'])) {
//session_register($_CONF['sess_name'].'_progress_sortBy');
$_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] = "assignments.due_date asc";
}
if (isset($_POST['progress_sortBy'])) {
$_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] = $_POST['progress_sortBy'];
}
$order_by = $_SESSION[$_CONF['sess_name'] . '_progress_sortBy'];
$print_button = "\t\n\t\t\t<CENTER>\n\t\t\t<FORM action=printview_progressreport.php method=POST target=new name=printview>\n\t\t\tPrint/View <input type=submit class=submit name=submit value=\"Current\" /> Student Report.\n\t\t\t</form>\n <FORM action=printview_progressreport.php method=POST target=new name=printview>\n Download <input type=submit class=submit name=all value=\"All\" /> Current Class Reports (Sinlge File).\n <input type=hidden name=all value=all />\n </form>\n </CENTER>";
$t = "Student Progress Reports";
/** Function get_teacher_class_list($teacher_id,$class_id=-1,$select_name='class_id',$form, $change="on") **/
$b = "<center><FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST id=classes naame=classes>\n\t\t\t<center>" . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $cid, 'class_id', 'classes', 'on') . "\n </form><br />";
if ($cid != -1) {
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=students>\n\t\t<center>" . make_selection_list($los, $sid, 'student_id', 'students', 'Student', 'on') . "<br>\n\t\t\tSort Assignments by : \n <select name=progress_sortBy onChange=document.forms['students'].submit();>\n <option value=\"assignments.due_date desc\"";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "assignments.due_date desc") {
$b .= " selected";
}
$b .= ">Date (descending)</option>\n <option value=\"assignments.due_date asc\"";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "assignments.due_date asc") {
$b .= " selected";
}
$b .= ">Date (ascending)</option>\n <option value=categories.category_name";
if ($_SESSION[$_CONF['sess_name'] . '_progress_sortBy'] == "categories.category_name") {
$b .= " selected";
}
$b .= ">Category Name</option>\n </select> \n </form>\n </center>";
}
$result = get_class_info($cid);
$row = $result->fetch_assoc();
$term_id = $row['term_id'];
$className = $row['class_name'];
$termName = $row['term_name'];
$teacherName = $row['first_name'] . " " . $row['last_name'];
}
if ($tid != -1) {
$custom_scores = array();
$custom_scores = get_custom_scores($tid, $_SESSION[$_CONF['sess_name'] . '_current_school_year']);
$classList = get_teacher_class_list($tid, $cid, 'class_id', "classes");
}
if (isset($_POST['teacher_id'])) {
$tid = $_SESSION[$_CONF['sess_name'] . '_selected_teacher'] = $_POST['teacher_id'];
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_class'] = -1;
$classList = get_teacher_class_list($tid, $cid, 'class_id', "classes");
}
$t = "Class Score Summary";
$b = "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=teachers>";
$b .= "<center>" . make_selection_list($teacherList, $tid, 'teacher_id', 'teachers', 'Teacher', 'on') . "</center>";
$b .= "</form>";
if ($tid > -1) {
$b .= "<FORM action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=classes>";
$b .= "<center>" . $classList . "</center>";
$b .= "</form>";
}
if ($cid > -1) {
include 'classSummary.php';
$b .= $summary_table . "<br />" . $print_button;
}
// end if isset class_id
$count = $row['count'];
$copyALL = "\n\t\t\t\t<tr><td colspan=5><span style=\"color:red\">Copy ALL CLASS DATA from another class ?<br>\n\t\t\t\tWARNING : This will replace ALL data in the Categories, Assignments AND Grades Tables for the (Copy To) Class.<br>\n It will also remove current student and replace with student in the copy FROM class.</span></td><td>\n\t\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST name=copyAllForm>\n\t\t\t\t<input type=submit class=submit name=copy_ALL_from id=copy_ALL_from value=\"COPY ALL\" />\n\t\t\t\t</form><br /></span>\n\t\t\t\t</td></tr>";
if ($count != 0) {
$bc = "blue";
/** list the assignments for the selected class **/
$sql = "SELECT assignments.assignment_id, assignments.assignment_name, assignments.due_date, assignments.max_score,\n assignments.assignment_weight, assignments.isExtraCredit, categories.category_name\n\t\t\t\t\tFROM assignments, categories\n\t\t\t\t\tWHERE categories.class_id=" . $classID . " and assignments.category_id=categories.category_id\n\t\t\t\t\tORDER by assignments.due_date";
$result = $db->query($sql);
$numAssigns = $result->num_rows;
$t = "Assignments";
$b = "\n <script type=\"text/javascript\">\n \$(document).ready(function() {\n \$('#numAssignsForm').validationEngine({inlineValidation: true});\n });\n </script>\n\t\t\t\t<center>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t<form id=\"numAssignsForm\" name=\"numAssignsForm\" action=\"\" method=POST>\n\t\t\t\t\t\t<span style=white-space:nowrap>I would like to add <input class=\"validate[required,custom[integer]]\" type=text size=3 id=\"numAssigns\" name=numAssigns /> assignments to this class.\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t<input type=submit class=submit id=\"addNewAssigns\" name=\"addNewAssigns\" value=Add />\n\t\t\t\t\t\t<input type=hidden class=submit id=\"class_id\" name=\"class_id\" value=\"" . $classID . "\" />\n\t\t\t\t\t\t</form></span>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t<form id=assignmentListForm name=assignmentListForm action=\"\" method=post>\n\t\t\t\t<table id=\"assignsTable\"border=0 bgcolor=white cellspacing=3 cellpadding=3>\n\t\t\t\t<thead>\n\t\t\t\t</thead>";
if ($numAssigns > 0) {
$b .= "\n\t\t\t\t<tbody id=\"assignmentList\">\n\t\t\t\t<tr>\n\t\t\t\t\t<th></th>\n\t\t\t\t\t<th bgcolor=white>Name</th>\n\t\t\t\t\t<th bgcolor=white>Category</th>\n\t\t\t\t\t<th bgcolor=white>Due Date</th>\n\t\t\t\t\t<th bgcolor=white>Max Score</th>\n\t\t\t\t\t<th bgcolor=white>Weight</th>\n\t\t\t\t\t<th bgcolor=white>Extra Credit</th>\n\t\t\t\t</tr>";
while ($myrow = $result->fetch_assoc()) {
$b .= "\n\t\t\t\t<tr id=\"assign_" . $myrow['assignment_id'] . "\">\n\t\t\t\t\t<td bgcolor=white>\n\t\t\t\t\t<input type=checkbox name=assign_" . $myrow['assignment_id'] . " id=assign_" . $myrow['assignment_id'] . " value=assign_" . $myrow['assignment_id'] . " />\n\t\t\t\t\t</td>\n\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['assignment_name'] . "</span></td>\n\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['category_name'] . "</span></td>\n\t\t\t\t\t<td bgcolor=white><span style=white-space:nowrap>" . $myrow['due_date'] . "</span></td>\n\t\t\t\t\t<td bgcolor=white align=center><span style=white-space:nowrap>" . $myrow['max_score'] . "</span></td>\n\t\t\t\t\t<td bgcolor=white align=center><span style=white-space:nowrap>" . $myrow['assignment_weight'] . "</span></td>\n\t\t\t\t\t<td bgcolor=white align=center><span style=white-space:nowrap>" . $myrow['isExtraCredit'] . "</span></td>\n\t\t\t\t</tr>";
}
$b .= "\n\t\t\t\t</tbody>\n\t\t\t\t<tfoot>\n\t\t\t\t<tr>\n\t\t\t\t<td colspan=7 align=center>\n <input type=submit class=submit id=editAssigns name=editAssigns value=Edit />\n\t\t\t\t<input type=submit class=submit id=deleteAssigns name=deleteAssigns value=Delete /><br>\n <input type=submit class=submit id=copyFromAssigns name=copyFromAssigns value=Copy />\n <span style=\"color:red\">Copy These Assignments to the following class :</span> " . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $classID, 'copy_to_class_id', "classes", 'off') . "<br>\n\n\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t</tfoot>\n\t\t\t\t";
} else {
$b .= "\n\t\t\t\t<tbody id=\"assignmentList\">\n\t\t\t\t</tbody>\n\t\t\t\t<tfoot>There are no assignments for this class yet.\n\t\t\t\t</tfoot>\n\t\t\t\t";
}
$b .= "\n\t\t\t</table>\n\t\t\t</form>";
if ($courseInfo['isCore'] != 'Y') {
$b .= "<table>" . $copyALL . "</table>";
}
$b .= "\n\t\t\t</center>";
$main .= make_box($t, $b, $bc);
} else {
$bc = "red";
$t = "Error...";
$b = "You must first create categories for this class before entering assignments.";
$b .= "You have 3 options...<br />";
$b .= "<table border=0 cellspacing=0 cellpadding=3>\n\t\t\t\t\t<tr><td colspan=5>Proceed to add a category</td><td>\n\t\t\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=category method=POST>\n\t\t\t\t\t<input type=submit class=submit name=go value=OK />\n\t\t\t\t\t</form></td></tr>";
$b = "The file was uploaded successfully.<br />";
$c = "blue";
// add entry to db
$sql = "INSERT into downloads (filename,description,title,size,file_type,class_id)\n values('" . $sqlfilename . "','" . $sqlfiledesc . "','" . $filetitle . "','" . $filesize . "','" . $sqlfiletype . "'," . $classid . ")";
$result = $db->query($sql);
} else {
$b = "There was an error uploading the file {" . $_FILES['upload_file']['filename'] . "}.<br >" . $downloads_path;
$c = "red";
}
$main .= "<br />" . make_box($t, $b, $c);
}
// end if upload
if ($_SESSION[$_CONF['sess_name'] . '_isTeacher']) {
// generate the upload input...
$t = "Upload a file";
$b = "<form enctype=\"multipart/form-data\" action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=\"post\">\n\t\t\t<center><table border=0 cellspacin=2 cellpadding=2>\n\t\t\t<tr>\n\t\t\t\t<td align=right>Please Select a Class :</td>\n\t\t\t\t<td align=left>" . get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], $cid, 'class_id', "classes") . "</td>\n\t\t\t\t</tr>\n\t\t\t<tr>\n <td align=right>Please select the file to upload :</td>\n <td align=left><input name=\"upload_file\" type=\"file\"></td>\n </tr>\n <tr>\n <td align=right>Please provide a Title :</td>\n <td align=left><input name=\"title\" type=text size=20></td>\n </tr>\n <tr>\n <td align=right valign=top>Description :</td> \n <td align=left><textarea name=description rows=6 cols=30></textarea></td>\n </tr>\n <tr>\n <td colspan=2 align=center><input type=\"submit\" name=\"upload\" value=\"Upload\"></td>\n </tr>\n </table>\n\t\t\t\t</center>\n </FORM>";
$main .= "<br />" . make_box($t, $b);
}
// table for files is called downloads
// fields are filename, size, description
// get the list of files available for download from DB
$sql = "SELECT download_id, filename, description, title from downloads order by title";
$result = $db->query($sql);
$t = "Files Available for Download";
$b = "";
if ($result->num_rows != 0) {
$b = "<center><table border=0 cellspacing=2 cellpadding=2>";
while ($row = $result->fetch_assoc()) {
$b .= "<tr>";
$b .= "<td valign=top nowrap><b>" . $row['title'] . " :</b></td>";
$b .= "<td valign=top>" . $row['description'] . "</td>";
$b .= "<span style=\"color:red;text-decoration: line-through;\">" . $row['category_weight'] . "</span>";
}
$b .= "\n\t\t\t\t</td>\n\t\t\t</tr>";
}
$b .= "\n\t\t\t<tr>\n\t\t\t\t<td colspan=2 align=center>\n\t\t\t\t<input type=hidden id=\"toBeDeleted\" name=\"toBeDeleted\" value=" . $selectedCats . " />\n\t\t\t\t<input type=submit class=submit id=\"really_delCat\" name=really_delCat value=Delete>\n\t\t\t\t<input type=submit class=submit id=\"cancel_delete\" name=cancel_delete value=Cancel>\n\t\t\t\t<input type=hidden name=cat_id value=" . $_POST['cat_id'] . ">\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</form>\n\t\t";
$main .= make_box($t, $b, $bc);
}
if (isset($_POST['copy_from'])) {
$t = "Copy From Another Class";
$bc = "yellow";
/** copy from prior term **/
$b = "<table border=0 cellspacing=0 cellpadding=3>\n\t\t<tr><td>";
/** the copy from shold be selection list...**/
$b .= "<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " method=POST>";
//$b .= $classList = get_teacher_class_list($_SESSION[$_CONF['sess_name'].'_myUID'],$classID,'from_class_id',"classes","off");
$b .= $classList = get_teacher_class_list($_SESSION[$_CONF['sess_name'] . '_myUID'], -1, 'from_class_id', "classes", "off");
$b .= "</td><td>";
/** the copy to is from the previous screen POST variables... **/
$b .= "You are copying the categories to the following class...<br />";
$sql = "SELECT *\n\t\tFROM terms, classes\n\t\tWHERE classes.term_id = terms.term_id\n\t\tAND classes.class_id =" . $_SESSION[$_CONF['sess_name'] . '_selected_class'];
$result = $db->query($sql);
$row = $result->fetch_assoc();
$b .= $row['term_name'] . " : " . $row['term_start_date'] . "-" . $row['term_end_date'] . "<br />";
$sql = "SELECT * from classes where class_id=" . $classID;
$result = $db->query($sql);
$row = $result->fetch_assoc();
$b .= $row['class_name'] . "<br />";
$b .= "</td>";
$b .= "<tr><td colspan=2 align=center>\n\t\t<input type=submit class=submit name=copy_to value=Copy />\n\t\t<input type=hidden name=to_class_id value=" . $classID . " />\n\t\t</td></tr></form>\n\t\t</table>";
$main .= make_box($t, $b, $bc);
}