+++ /dev/null
-<?php\r
-/************************************************************************/\r
-/* ATutor */\r
-/************************************************************************/\r
-/* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg & Heidi Hazelton*/\r
-/* Adaptive Technology Resource Centre / University of Toronto */\r
-/* http://atutor.ca */\r
-/* */\r
-/* This program is free software. You can redistribute it and/or */\r
-/* modify it under the terms of the GNU General Public License */\r
-/* as published by the Free Software Foundation. */\r
-/************************************************************************/\r
-// $Id: grade_scale.php 7208 2008-05-28 16:07:24Z cindy $\r
-\r
-$page = 'gradebook';\r
-\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require (AT_INCLUDE_PATH.'vitals.inc.php');\r
-\r
-require ('lib/gradebook.inc.php');\r
-\r
-require(AT_INCLUDE_PATH.'header.inc.php'); \r
-\r
-?>\r
-\r
-<form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">\r
-\r
-<table summary="" class="data" rules="cols" align="center" style="width: 70%;">\r
-\r
-<thead>\r
-<tr>\r
- <th scope="col"><?php echo _AT('title'); ?></th>\r
- <th scope="col"><?php echo _AT('your_mark'); ?></th>\r
- <th scope="col"><?php echo _AT('class_avg'); ?></th>\r
- <th scope="col"><?php echo _AT('due_date'); ?></th>\r
- <th scope="col"><?php echo _AT('completed_date'); ?></th>\r
- <th scope="col"><?php echo _AT('time_spent'); ?></th>\r
-</tr>\r
-</thead>\r
-\r
-<tbody>\r
-<?php\r
-\r
-$sql = "(SELECT g.gradebook_test_id, g.id, type, t.title, t.end_date due_date, grade_scale_id, t.result_release ".\r
- " FROM ".TABLE_PREFIX."gradebook_tests g, ".TABLE_PREFIX."tests t".\r
- " WHERE g.type='ATutor Test'".\r
- " AND g.id = t.test_id".\r
- " AND t.course_id=".$_SESSION["course_id"].\r
- " ORDER BY t.title) ".\r
- " UNION (SELECT g.gradebook_test_id, g.id, g.type, a.title, a.date_due due_date, grade_scale_id, '' result_release ".\r
- " FROM ".TABLE_PREFIX."gradebook_tests g, ".TABLE_PREFIX."assignments a".\r
- " WHERE g.type='ATutor Assignment'".\r
- " AND g.id = a.assignment_id".\r
- " AND a.course_id=".$_SESSION["course_id"].\r
- " ORDER BY title)";\r
- " UNION (SELECT gradebook_test_id, id, type, title, due_date, grade_scale_id, '' result_release ".\r
- " FROM ".TABLE_PREFIX."gradebook_tests".\r
- " WHERE course_id=".$_SESSION["course_id"].\r
- " ORDER BY title)";\r
-$result = mysql_query($sql, $db) or die(mysql_error());\r
-\r
-if (mysql_num_rows($result) == 0)\r
-{\r
-?>\r
- <tr>\r
- <td colspan="6"><?php echo _AT('none_found'); ?></td>\r
- </tr>\r
-<?php \r
-}\r
-else\r
-{\r
- while ($row = mysql_fetch_assoc($result))\r
- {\r
- $sql_grade = "SELECT grade FROM ".TABLE_PREFIX."gradebook_detail WHERE gradebook_test_id=".$row["gradebook_test_id"]." AND member_id=".$_SESSION["member_id"];\r
- $result_grade = mysql_query($sql_grade, $db) or die(mysql_error());\r
- $row_grade = mysql_fetch_assoc($result_grade);\r
- \r
- if (mysql_num_rows($result_grade) == 0)\r
- $grade = "";\r
- else\r
- {\r
- $grade = $row_grade["grade"];\r
- }\r
- \r
- if ($row["type"] == "ATutor Test")\r
- {\r
- // get "completed date" and "time spent"\r
- if ($grade <> "")\r
- {\r
- $sql_tr = "SELECT R.result_id, R.date_taken, (UNIX_TIMESTAMP(R.end_time) - UNIX_TIMESTAMP(R.date_taken)) AS diff FROM ".TABLE_PREFIX."tests_results R WHERE R.status=1 AND R.test_id=".$row["id"]." AND R.member_id=".$_SESSION[member_id];\r
- $result_tr = mysql_query($sql_tr, $db) or die(mysql_error());\r
- $row_tr = mysql_fetch_assoc($result_tr);\r
- }\r
-?>\r
- <tr>\r
-<?php \r
- if ( ($grade != '') && (($row['result_release']==AT_RELEASE_IMMEDIATE) || ($row['result_release']==AT_RELEASE_MARKED)) )\r
- echo ' <td><a href="tools/view_results.php?tid='.$row['id'].'&rid='.$row_tr['result_id'].'">'.$row["title"].'</a></td>'."\n\r";\r
- else\r
- echo ' <td>'.$row["title"].'</td>'."\n\r";\r
-?>\r
- <td><?php echo ($grade=="") ? _AT("na") : $grade; ?></td>\r
- <td><?php echo get_class_avg($row["gradebook_test_id"]); ?></td>\r
- <td><?php echo $row["due_date"]; ?></td>\r
- <td><?php echo ($grade=="") ? _AT("na") : $row_tr["date_taken"]; ?></td>\r
- <td><?php echo ($grade=="") ? _AT("na") : get_human_time($row_tr['diff']); ?></td>\r
- </tr>\r
-<?php \r
- }\r
- else\r
- {\r
-?>\r
- <tr>\r
- <td><?php echo $row["title"]; ?></td>\r
- <td><?php echo ($grade=="") ? _AT("na") : $grade; ?></td>\r
- <td><?php echo get_class_avg($row["gradebook_test_id"]); ?></td>\r
- <td><?php echo $row["due_date"]; ?></td>\r
- <td><?php echo ($grade=="") ? _AT("pending") : _AT("completed"); ?></td>\r
- <td><?php echo _AT("na"); ?></td>\r
- </tr>\r
-<?php \r
- }\r
- }\r
-}\r
-?>\r
-\r
-</tbody>\r
-</table>\r
-</form>\r
-\r
-<?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>\r