tools/groups/index.php

   1 <?php\r
   2 /************************************************************************/\r
   3 /* ATutor                                                                                                                               */\r
   4 /************************************************************************/\r
   5 /* Copyright (c) 2002-2006 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$\r
  14 \r
  15 define('AT_INCLUDE_PATH', '../../include/');\r
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 authenticate(AT_PRIV_GROUPS);\r
  18 \r
  19 if (isset($_GET['edit'], $_GET['id'])) {\r
  20         $parts = explode('_', $_GET['id'], 2);\r
  21         if (isset($parts[1]) && $parts[1]) {\r
  22                 header('Location: edit_group.php?id='.$parts[1]);\r
  23                 exit;\r
  24         } else if ($parts[0]) {\r
  25                 header('Location: edit_type.php?id='.$parts[0]);\r
  26                 exit;\r
  27         }\r
  28 } else if (isset($_GET['delete'], $_GET['id'])) {\r
  29         $parts = explode('_', $_GET['id'], 2);\r
  30         if (isset($parts[1]) && $parts[1]) {\r
  31                 header('Location: delete_group.php?id='.$parts[1]);\r
  32                 exit;\r
  33         } else if ($parts[0]) {\r
  34                 header('Location: delete_type.php?id='.$parts[0]);\r
  35                 exit;\r
  36         }\r
  37 } else if (isset($_GET['members'])) {\r
  38         $parts = explode('_', $_GET['id'], 2);\r
  39         if (isset($parts[1]) && $parts[1]) {\r
  40                 header('Location: members.php?id='.$parts[0].SEP.'gid='.$parts[1]);\r
  41                 exit;\r
  42         } else if ($parts[0]) {\r
  43                 header('Location: members.php?id='.$parts[0]);\r
  44                 exit;\r
  45         } else {\r
  46                 $msg->addError('NO_ITEM_SELECTED');\r
  47         }\r
  48 } else if (isset($_GET['members']) || isset($_GET['delete']) || isset($_GET['edit'])) {\r
  49         $msg->addError('NO_ITEM_SELECTED');\r
  50 }\r
  51 \r
  52 require(AT_INCLUDE_PATH.'header.inc.php');\r
  53 \r
  54 $sql = "SELECT type_id, title FROM ".TABLE_PREFIX."groups_types WHERE course_id=$_SESSION[course_id] ORDER BY title";\r
  55 $result = mysql_query($sql, $db);\r
  56 ?>\r
  57 \r
  58 <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get" name="form">\r
  59 <table class="data" summary="" rules="cols" style="width: 50%">\r
  60 <tfoot>\r
  61 <tr>\r
  62         <td>\r
  63                 <input type="submit" name="edit"    value="<?php echo _AT('edit'); ?>" />\r
  64                 <input type="submit" name="members" value="<?php echo _AT('members'); ?>" />\r
  65                 <input type="submit" name="delete"  value="<?php echo _AT('delete'); ?>" />\r
  66         </td>\r
  67 </tr>\r
  68 </tfoot>\r
  69 <tbody>\r
  70 <?php if ($row = mysql_fetch_assoc($result)): ?>\r
  71         <?php do { ?>\r
  72 \r
  73                 <?php \r
  74                         $sql = "SELECT group_id, title FROM ".TABLE_PREFIX."groups WHERE type_id=$row[type_id] ORDER BY title";\r
  75                         $group_result = mysql_query($sql, $db);\r
  76                         $num_groups = mysql_num_rows($group_result);\r
  77                 ?>\r
  78                 <tr onmousedown="document.form['g<?php echo $row['type_id']; ?>'].checked = true; rowselect(this);" id="r_<?php echo $row['type_id']; ?>">\r
  79                         <th>\r
  80                                 <input type="radio" id="g<?php echo $row['type_id']; ?>" name="id" value="<?php echo $row['type_id']; ?>" />\r
  81                                 <label for="g<?php echo $row['type_id']; ?>"><?php echo $row['title']; ?></label> (<?php echo $num_groups.' '._AT('groups'); ?>)</td>\r
  82                         </th>\r
  83                 </tr>\r
  84                 <?php if ($num_groups) : ?>\r
  85                         <?php while ($group_row = mysql_fetch_assoc($group_result)): ?>\r
  86                                 <?php\r
  87                                         $sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."groups_members WHERE group_id=$group_row[group_id]";\r
  88                                         $group_cnt_result = mysql_query($sql, $db);\r
  89                                         $group_cnt = mysql_fetch_assoc($group_cnt_result);\r
  90                                 ?>\r
  91                                 <tr onmousedown="document.form['g<?php echo $row['type_id'].'_'.$group_row['group_id']; ?>'].checked = true; rowselect(this);" id="r_<?php echo $row['type_id'].'_'.$group_row['group_id']; ?>">\r
  92                                         <td class="indent"><input type="radio" id="g<?php echo $row['type_id'].'_'.$group_row['group_id']; ?>" name="id" value="<?php echo $row['type_id'].'_'.$group_row['group_id']; ?>" /> <label for="g<?php echo $row['type_id'].'_'.$group_row['group_id']; ?>"><?php echo $group_row['title']; ?></label> (<?php echo $group_cnt['cnt'].' '._AT('members'); ?>)</td>\r
  93                                 </tr>\r
  94                         <?php endwhile; ?>\r
  95                 <?php else: ?>\r
  96                         <tr>\r
  97                                 <td class="indent"><em><?php echo _AT('none_found'); ?></em></td>\r
  98                         </tr>\r
  99                 <?php endif; ?>\r
 100 \r
 101         <?php } while ($row = mysql_fetch_assoc($result)); ?>\r
 102 <?php else: ?>\r
 103         <tr>\r
 104                 <td><em><?php echo _AT('none_found'); ?></em></td>\r
 105         </tr>\r
 106 <?php endif; ?>\r
 107 </tbody>\r
 108 </table>\r
 109 </form>\r
 110 \r
 111 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>