function add_test($test_id, $title)
{
global $db, $msg;
$no_error = true;
$studs_take_num = get_studs_take_more_than_once($_SESSION["course_id"], $test_id);
foreach ($studs_take_num as $member_id => $num)
{
if ($no_error) $no_error = false;
$error_msg .= get_display_name($member_id) . ": " . $num . " times<br>";
}
if (!$no_error)
{
$f = array('ADD_TEST_INTO_GRADEBOOK',
$title,
$error_msg);
$msg->addFeedback($f);
}
if ($no_error) // add into gradebook
{
$_POST["selected_grade_scale_id"] = intval($_POST["selected_grade_scale_id"]);
$sql_insert = "INSERT INTO ".TABLE_PREFIX."gradebook_tests (id, type, grade_scale_id)
VALUES (". $test_id. ", 'ATutor Test', ".$_POST["selected_grade_scale_id"].")";
$result_insert = mysql_query($sql_insert, $db) or die(mysql_error());
}
}
function add_test($test_id, $title)
{
global $msg;
$no_error = true;
$studs_take_num = get_studs_take_more_than_once($_SESSION["course_id"], $test_id);
foreach ($studs_take_num as $member_id => $num) {
if ($no_error) {
$no_error = false;
}
$error_msg .= get_display_name($member_id) . ": " . $num . " times<br>";
}
if (!$no_error) {
$f = array('ADD_TEST_INTO_GRADEBOOK', $title, $error_msg);
$msg->addFeedback($f);
}
if ($no_error) {
$sql_insert = "INSERT INTO %sgradebook_tests (id, type, grade_scale_id) VALUES (%d, 'ATutor Test', %d)";
$result_insert = queryDB($sql_insert, array(TABLE_PREFIX, $test_id, $_POST["selected_grade_scale_id"]));
}
}
function is_test_updatable($gradebook_test_id)
{
global $msg;
$sql = "SELECT g.id, t.title FROM %sgradebook_tests g, %stests t WHERE g.id=t.test_id AND g.type='ATutor Test' AND g.gradebook_test_id = %d";
$row = queryDB($sql, array(TABLE_PREFIX, TABLE_PREFIX, $gradebook_test_id), TRUE);
$no_error = true;
$studs_take_num = get_studs_take_more_than_once($_SESSION["course_id"], $row["id"]);
foreach ($studs_take_num as $member_id => $num) {
if ($no_error) {
$no_error = false;
}
$error_msg .= get_display_name($member_id) . ": " . $num . " times<br>";
}
if (!$no_error) {
$f = array('UPDATE_GRADEBOOK', $row['title'], $error_msg);
$msg->addFeedback($f);
}
if ($no_error) {
return true;
} else {
return false;
}
}
function is_test_updatable($gradebook_test_id)
{
global $db, $msg;
$sql = "SELECT g.id, t.title FROM " . TABLE_PREFIX . "gradebook_tests g, " . TABLE_PREFIX . "tests t WHERE g.id=t.test_id AND g.type='ATutor Test' AND g.gradebook_test_id = " . $gradebook_test_id;
$result = mysql_query($sql, $db) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$no_error = true;
$studs_take_num = get_studs_take_more_than_once($_SESSION["course_id"], $row["id"]);
foreach ($studs_take_num as $member_id => $num) {
if ($no_error) {
$no_error = false;
}
$error_msg .= get_display_name($member_id) . ": " . $num . " times<br>";
}
if (!$no_error) {
$f = array('UPDATE_GRADEBOOK', $row['title'], $error_msg);
$msg->addFeedback($f);
}
if ($no_error) {
return true;
} else {
return false;
}
}
$order_col = 'name';
}
}
if ($_GET['reset_filter']) {
unset($_GET);
}
// Initialize all applicable tests array and all enrolled students array
$all_tests = array();
$all_students = array();
// generate test array
$sql = "(SELECT g.gradebook_test_id, g.id, g.type, t.title" . " FROM " . TABLE_PREFIX . "gradebook_tests g, " . TABLE_PREFIX . "tests t" . " WHERE g.type='ATutor Test'" . " AND g.id = t.test_id" . " AND t.course_id=" . $_SESSION["course_id"] . " ORDER BY title)" . " UNION (SELECT g.gradebook_test_id, g.id, g.type, a.title" . " FROM " . TABLE_PREFIX . "gradebook_tests g, " . TABLE_PREFIX . "assignments a" . " WHERE g.type='ATutor Assignment'" . " AND g.id = a.assignment_id" . " AND a.course_id=" . $_SESSION["course_id"] . " ORDER BY title)" . " UNION (SELECT gradebook_test_id, id, type, title" . " FROM " . TABLE_PREFIX . "gradebook_tests" . " WHERE course_id=" . $_SESSION["course_id"] . " ORDER BY title)";
$result = mysql_query($sql, $db) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
$no_error = true;
if ($row["type"] == "ATutor Test") {
$studs_take_num = get_studs_take_more_than_once($_SESSION["course_id"], $row["id"]);
foreach ($studs_take_num as $member_id => $num) {
if ($no_error) {
$no_error = false;
}
$error_msg .= get_display_name($member_id) . ": " . $num . " times<br>";
}
if (!$no_error) {
$f = array('ADD_TEST_INTO_GRADEBOOK', $row['title'], $error_msg);
$msg->addFeedback($f);
}
}
if ($no_error) {
array_push($all_tests, $row);
}
}
if (isset($_POST['cancel'])) {
$msg->addFeedback('CANCELLED');
header('Location: update_gradebook.php');
exit;
} else {
if (!isset($_POST["gradebook_test_id"]) || !isset($_POST["test_id"])) {
$msg->addError('MISSING_TEST');
header('Location: update_gradebook.php');
exit;
} else {
if (isset($_POST['combine'])) {
//Check if the "combine from test" has students taking it more than once
$no_error = true;
$sql = "SELECT title FROM %stests WHERE test_id=%d";
$row = queryDB($sql, array(TABLE_PREFIX, $_POST["test_id"]), TRUE);
$studs_take_num = get_studs_take_more_than_once($_SESSION["course_id"], $_POST["test_id"]);
foreach ($studs_take_num as $member_id => $num) {
if ($no_error) {
$no_error = false;
}
$error_msg .= get_display_name($member_id) . ": " . $num . " times<br>";
}
if (!$no_error) {
$error = array('COMBINE_TESTS', $row["title"], $error_msg);
$msg->addError($error);
}
if (!$msg->containsErrors()) {
$sql = "SELECT id, grade_scale_id FROM %sgradebook_tests WHERE gradebook_test_id = %d";
$row = queryDB($sql, array(TABLE_PREFIX, $_POST["gradebook_test_id"]), TRUE);
$grade_scale_id = $row["grade_scale_id"];
$sql = "SELECT m.first_name, m.last_name, m.email, e.member_id FROM %smembers m, %scourse_enrollment e WHERE m.member_id = e.member_id AND e.course_id=%d AND e.approved='y' AND e.role<>'Instructor' ORDER BY m.first_name,m.last_name";
