mods/gradebook/my_gradebook.php

   1 <?php\r
   2 /************************************************************************/\r
   3 /* ATutor                                                                                                                               */\r
   4 /************************************************************************/\r
   5 /* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg & Heidi Hazelton*/\r
   6 /* Adaptive Technology Resource Centre / University of Toronto                  */\r
   7 /* http://atutor.ca                                                                                                             */\r
   8 /*                                                                                                                                              */\r
   9 /* This program is free software. You can redistribute it and/or                */\r
  10 /* modify it under the terms of the GNU General Public License                  */\r
  11 /* as published by the Free Software Foundation.                                                */\r
  12 /************************************************************************/\r
  13 // $Id: grade_scale.php 7208 2008-05-28 16:07:24Z cindy $\r
  14 \r
  15 $page = 'gradebook';\r
  16 \r
  17 define('AT_INCLUDE_PATH', '../../include/');\r
  18 require (AT_INCLUDE_PATH.'vitals.inc.php');\r
  19 \r
  20 require ('lib/gradebook.inc.php');\r
  21 \r
  22 require(AT_INCLUDE_PATH.'header.inc.php'); \r
  23 \r
  24 ?>\r
  25 \r
  26 <form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">\r
  27 \r
  28 <table summary="" class="data" rules="cols" align="center" style="width: 70%;">\r
  29 \r
  30 <thead>\r
  31 <tr>\r
  32         <th scope="col"><?php echo _AT('title'); ?></th>\r
  33         <th scope="col"><?php echo _AT('your_mark'); ?></th>\r
  34         <th scope="col"><?php echo _AT('class_avg'); ?></th>\r
  35         <th scope="col"><?php echo _AT('due_date'); ?></th>\r
  36         <th scope="col"><?php echo _AT('completed_date'); ?></th>\r
  37         <th scope="col"><?php echo _AT('time_spent'); ?></th>\r
  38 </tr>\r
  39 </thead>\r
  40 \r
  41 <tbody>\r
  42 <?php\r
  43 \r
  44 $sql = "(SELECT g.gradebook_test_id, g.id, type, t.title, t.end_date due_date, grade_scale_id, t.result_release ".\r
  45                                 " FROM ".TABLE_PREFIX."gradebook_tests g, ".TABLE_PREFIX."tests t".\r
  46                                 " WHERE g.type='ATutor Test'".\r
  47                                 " AND g.id = t.test_id".\r
  48                                 " AND t.course_id=".$_SESSION["course_id"].\r
  49                                 " ORDER BY t.title) ".\r
  50                                 " UNION (SELECT g.gradebook_test_id, g.id, g.type, a.title, a.date_due due_date, grade_scale_id, '' result_release ".\r
  51                                 " FROM ".TABLE_PREFIX."gradebook_tests g, ".TABLE_PREFIX."assignments a".\r
  52                                 " WHERE g.type='ATutor Assignment'".\r
  53                                 " AND g.id = a.assignment_id".\r
  54                                 " AND a.course_id=".$_SESSION["course_id"].\r
  55                                 " ORDER BY title)";\r
  56                                 " UNION (SELECT gradebook_test_id, id, type, title, due_date, grade_scale_id, '' result_release ".\r
  57                                 " FROM ".TABLE_PREFIX."gradebook_tests".\r
  58                                 " WHERE course_id=".$_SESSION["course_id"].\r
  59                                 " ORDER BY title)";\r
  60 $result = mysql_query($sql, $db) or die(mysql_error());\r
  61 \r
  62 if (mysql_num_rows($result) == 0)\r
  63 {\r
  64 ?>\r
  65         <tr>\r
  66                 <td colspan="6"><?php echo _AT('none_found'); ?></td>\r
  67         </tr>\r
  68 <?php \r
  69 }\r
  70 else\r
  71 {\r
  72         while ($row = mysql_fetch_assoc($result))\r
  73         {\r
  74                 $sql_grade = "SELECT grade FROM ".TABLE_PREFIX."gradebook_detail WHERE gradebook_test_id=".$row["gradebook_test_id"]." AND member_id=".$_SESSION["member_id"];\r
  75                 $result_grade = mysql_query($sql_grade, $db) or die(mysql_error());\r
  76                 $row_grade = mysql_fetch_assoc($result_grade);\r
  77                 \r
  78                 if (mysql_num_rows($result_grade) == 0)\r
  79                         $grade = "";\r
  80                 else\r
  81                 {\r
  82                         $grade = $row_grade["grade"];\r
  83                 }\r
  84                 \r
  85                 if ($row["type"] == "ATutor Test")\r
  86                 {\r
  87                         // get "completed date" and "time spent"\r
  88                         if ($grade <> "")\r
  89                         {\r
  90                                 $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
  91                                 $result_tr = mysql_query($sql_tr, $db) or die(mysql_error());\r
  92                                 $row_tr = mysql_fetch_assoc($result_tr);\r
  93                         }\r
  94 ?>\r
  95                 <tr>\r
  96 <?php \r
  97                         if ( ($grade != '') && (($row['result_release']==AT_RELEASE_IMMEDIATE) || ($row['result_release']==AT_RELEASE_MARKED)) )\r
  98                                 echo '                  <td><a href="tools/view_results.php?tid='.$row['id'].'&amp;rid='.$row_tr['result_id'].'">'.$row["title"].'</a></td>'."\n\r";\r
  99                         else\r
 100                                 echo '                  <td>'.$row["title"].'</td>'."\n\r";\r
 101 ?>\r
 102                         <td><?php echo ($grade=="") ? _AT("na") : $grade; ?></td>\r
 103                         <td><?php echo get_class_avg($row["gradebook_test_id"]); ?></td>\r
 104                         <td><?php echo $row["due_date"]; ?></td>\r
 105                         <td><?php echo ($grade=="") ? _AT("na") : $row_tr["date_taken"]; ?></td>\r
 106                         <td><?php echo ($grade=="") ? _AT("na") : get_human_time($row_tr['diff']); ?></td>\r
 107                 </tr>\r
 108 <?php \r
 109                 }\r
 110                 else\r
 111                 {\r
 112 ?>\r
 113                 <tr>\r
 114                         <td><?php echo $row["title"]; ?></td>\r
 115                         <td><?php echo ($grade=="") ? _AT("na") : $grade; ?></td>\r
 116                         <td><?php echo get_class_avg($row["gradebook_test_id"]); ?></td>\r
 117                         <td><?php echo $row["due_date"]; ?></td>\r
 118                         <td><?php echo ($grade=="") ? _AT("pending") : _AT("completed"); ?></td>\r
 119                         <td><?php echo _AT("na"); ?></td>\r
 120                 </tr>\r
 121 <?php \r
 122                 }\r
 123         }\r
 124 }\r
 125 ?>\r
 126 \r
 127 </tbody>\r
 128 </table>\r
 129 </form>\r
 130 \r
 131 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>\r