docs/mods/_core/users/user_enrollment.php

   1 <?php
   2 /****************************************************************/
   3 /* ATutor                                                                                                               */
   4 /****************************************************************/
   5 /* Copyright (c) 2002-2010                                      */
   6 /* Inclusive Design Institute                                   */
   7 /* http://atutor.ca                                                                                             */
   8 /*                                                              */
   9 /* This program is free software. You can redistribute it and/or*/
  10 /* modify it under the terms of the GNU General Public License  */
  11 /* as published by the Free Software Foundation.                                */
  12 /****************************************************************/
  13 // $Id$
  14 $_user_location = 'admin';
  15
  16 define('AT_INCLUDE_PATH', '../../../include/');
  17 require(AT_INCLUDE_PATH.'vitals.inc.php');
  18 admin_authenticate(AT_ADMIN_PRIV_ENROLLMENT);
  19
  20 if (isset($_POST['cancel'])) {
  21         $msg->addFeedback('CANCELLED');
  22         header('Location: '.AT_BASE_HREF.'mods/_core/users/users.php');
  23         exit;
  24 } else if (isset($_POST['enrolled_unenroll'])) {
  25         $_POST['id'] = intval($_POST['id']);
  26
  27         if (!is_array($_POST['enrolled'])) {
  28                 $msg->addError('NO_ITEM_SELECTED');
  29         } else {
  30                 $cids = implode(',', $_POST['enrolled']);
  31                 $sql = "DELETE FROM ".TABLE_PREFIX."course_enrollment WHERE member_id={$_POST['id']} AND course_id IN ($cids)";
  32                 mysql_query($sql, $db);
  33
  34                 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
  35                 header('Location: '.$_SERVER['PHP_SELF'] . '?id='.$_POST['id']);
  36                 exit;
  37         }
  38 } else if (isset($_POST['pending_remove'])) {
  39         $_POST['id'] = intval($_POST['id']);
  40
  41         if (!is_array($_POST['pending'])) {
  42                 $msg->addError('NO_ITEM_SELECTED');
  43         } else {
  44                 $cids = implode(',', $_POST['pending']);
  45                 $sql = "DELETE FROM ".TABLE_PREFIX."course_enrollment WHERE member_id={$_POST['id']} AND course_id IN ($cids)";
  46                 mysql_query($sql, $db);
  47
  48                 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
  49                 header('Location: '.$_SERVER['PHP_SELF'] . '?id='.$_POST['id']);
  50                 exit;
  51         }
  52 } else if (isset($_POST['pending_enroll'])) {
  53         $_POST['id'] = intval($_POST['id']);
  54
  55         if (!is_array($_POST['pending'])) {
  56                 $msg->addError('NO_ITEM_SELECTED');
  57         } else {
  58                 $cids = implode(',', $_POST['pending']);
  59                 $sql = "UPDATE ".TABLE_PREFIX."course_enrollment SET approved='y' WHERE member_id={$_POST['id']} AND course_id IN ($cids)";
  60                 mysql_query($sql, $db);
  61
  62                 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
  63                 header('Location: '.$_SERVER['PHP_SELF'] . '?id='.$_POST['id']);
  64                 exit;
  65         }
  66 } else if (isset($_POST['not_enrolled_enroll'])) {
  67         $_POST['id'] = intval($_POST['id']);
  68
  69         if (!is_array($_POST['not_enrolled'])) {
  70                 $msg->addError('NO_ITEM_SELECTED');
  71         } else {
  72                 foreach ($_POST['not_enrolled'] as $cid) {
  73                         $sql = "INSERT INTO ".TABLE_PREFIX."course_enrollment VALUES ({$_POST['id']}, $cid, 'y', 0, '', 0)";
  74                         mysql_query($sql, $db);
  75                 }
  76                 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
  77                 header('Location: '.$_SERVER['PHP_SELF'] . '?id='.$_POST['id']);
  78                 exit;
  79         }
  80 }
  81
  82 $id = intval($_GET['id']);
  83
  84 // add the user's name to the page heading:
  85 $_pages['mods/_core/users/user_enrollment.php']['title'] = _AT('enrollment').': '.get_display_name($id);
  86
  87 require(AT_INCLUDE_PATH.'header.inc.php');
  88
  89 $sql    = "SELECT login FROM ".TABLE_PREFIX."members WHERE member_id=$id";
  90 $result = mysql_query($sql, $db);
  91
  92 if (!$row = mysql_fetch_assoc($result)) {
  93         $msg->printErrors('USER_NOT_FOUND');
  94         require(AT_INCLUDE_PATH.'footer.inc.php');
  95         exit;
  96 }
  97
  98 $enrollment = array();
  99 $sql = "SELECT * FROM ".TABLE_PREFIX."course_enrollment WHERE member_id=$id";
 100 $result = mysql_query($sql, $db);
 101 while ($row = mysql_fetch_assoc($result)) {
 102         $enrollment[$row['course_id']] = $row;
 103 }
 104
 105 $instruct     = array();
 106 $enrolled     = array();
 107 $pending      = array();
 108 $not_enrolled = array();
 109
 110 foreach ($system_courses as $cid => $course) {
 111         if ($course['member_id'] == $id) {
 112                 $instruct[] = $cid;
 113         } else if (isset($enrollment[$cid]) && $enrollment[$cid]['approved'] == 'y') {
 114                 $enrolled[] = $cid;
 115         } else if (isset($enrollment[$cid]) && $enrollment[$cid]['approved'] == 'n') {
 116                 $pending[] = $cid;
 117         } else {
 118                 $not_enrolled[] = $cid;
 119         }
 120 }
 121 $savant->assign('system_courses', $system_courses);
 122 $savant->assign('instruct', $instruct);
 123 $savant->assign('enrolled', $enrolled);
 124 $savant->assign('pending', $pending);
 125 $savant->assign('not_enrolled', $not_enrolled);
 126 $savant->assign('id', $id);
 127 $savant->display('admin/users/user_enrollment.tmpl.php');
 128 require(AT_INCLUDE_PATH.'footer.inc.php'); ?>