docs/mods/_standard/assignments/index_instructor.php

   1 <?php\r
   2 /****************************************************************/\r
   3 /* ATutor                                                                                                               */\r
   4 /****************************************************************/\r
   5 /* Copyright (c) 2002-2008                                      */\r
   6 /* Written by Greg Gay & Joel Kronenberg & Chris Ridpath        */\r
   7 /* Inclusive Design Institute                                   */\r
   8 /* http://atutor.ca                                                                                             */\r
   9 /*                                                              */\r
  10 /* This program is free software. You can redistribute it and/or*/\r
  11 /* modify it under the terms of the GNU General Public License  */\r
  12 /* as published by the Free Software Foundation.                                */\r
  13 /****************************************************************/\r
  14 // $Id$\r
  15 define('AT_INCLUDE_PATH', '../../../include/');\r
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 authenticate(AT_PRIV_ASSIGNMENTS);\r
  18 \r
  19 if (isset($_GET['edit'])) {\r
  20         $_GET['assignment'] = intval($_GET['assignment']);\r
  21         header('Location: edit_assignment.php?id='. $_GET['assignment']);\r
  22         exit;\r
  23 } else if (isset($_GET['delete'])) {\r
  24         $_GET['assignment'] = intval($_GET['assignment']);\r
  25         header('Location: delete_assignment.php?id='. $_GET['assignment']);\r
  26         exit;\r
  27 } else if (isset($_GET['submissions'])){\r
  28         $_GET['assignment'] = intval($_GET['assignment']);\r
  29         header('Location: '.url_rewrite('mods/_standard/file_storage/index.php?ot='.WORKSPACE_ASSIGNMENT.SEP.'oid='.$_GET['assignment'], AT_PRETTY_URL_IS_HEADER));\r
  30         exit;\r
  31 }\r
  32 $msg->addInfo('ASSIGNMENT_FS_SUBMISSIONS'); \r
  33 require(AT_INCLUDE_PATH.'header.inc.php'); \r
  34 \r
  35 // sort order of table\r
  36 $orders = array('ASC' => 'DESC', 'DESC' => 'ASC');\r
  37 $cols   = array('title' => 1, 'date_due' => 1);\r
  38 $sort = 'title';\r
  39 $order = 'ASC';\r
  40 if (isset($_GET['sort'])){\r
  41         $sort = isset($cols[$_GET['sort']]) ? $_GET['sort'] : 'title';\r
  42 }\r
  43 if (isset($_GET['order'])){\r
  44         $order = $addslashes($_GET['order']);\r
  45         if (($order != 'ASC') && ($order != 'DESC')){\r
  46                 $order = 'ASC';\r
  47         }\r
  48 }\r
  49 $sql = "SELECT * FROM ".TABLE_PREFIX."assignments WHERE course_id=$_SESSION[course_id] ORDER BY $sort $order";\r
  50 $result = mysql_query($sql, $db);\r
  51 $sql2 = "SELECT title FROM ".TABLE_PREFIX."groups_types WHERE type_id=$row[assign_to] AND course_id=$_SESSION[course_id]";\r
  52 $type_result = mysql_query($sql2, $db);\r
  53 $savant->assign('result', $result);\r
  54 $savant->assign('sort', $sort);\r
  55 $savant->assign('type_result', $type_result);\r
  56 $savant->display('instructor/assignments/index_instructor.tmpl.php');\r
  57 require (AT_INCLUDE_PATH.'footer.inc.php'); ?>