2 /****************************************************************/
\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
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
15 define('AT_INCLUDE_PATH', '../../../include/');
\r
16 require(AT_INCLUDE_PATH.'vitals.inc.php');
\r
17 authenticate(AT_PRIV_ASSIGNMENTS);
\r
19 if (isset($_GET['edit'])) {
\r
20 $_GET['assignment'] = intval($_GET['assignment']);
\r
21 header('Location: edit_assignment.php?id='. $_GET['assignment']);
\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
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
32 $msg->addInfo('ASSIGNMENT_FS_SUBMISSIONS');
\r
33 require(AT_INCLUDE_PATH.'header.inc.php');
\r
35 // sort order of table
\r
36 $orders = array('ASC' => 'DESC', 'DESC' => 'ASC');
\r
37 $cols = array('title' => 1, 'date_due' => 1);
\r
40 if (isset($_GET['sort'])){
\r
41 $sort = isset($cols[$_GET['sort']]) ? $_GET['sort'] : 'title';
\r
43 if (isset($_GET['order'])){
\r
44 $order = $addslashes($_GET['order']);
\r
45 if (($order != 'ASC') && ($order != 'DESC')){
\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'); ?>