[Summary view] [Print] [Text view]

   1  <?php // $Id: members.php,v 1.3.2.8 2008/07/24 11:39:05 skodak Exp $
   2  /**
   3   * Add/remove members from group.
   4   *
   5   * @copyright &copy; 2006 The Open University
   6   * @author N.D.Freear AT open.ac.uk
   7   * @author J.White AT open.ac.uk
   8   * @license http://www.gnu.org/copyleft/gpl.html GNU Public License
   9   * @package groups
  10   */
  11  require_once ('../config.php');
  12  require_once ('lib.php');
  13  
  14  define("MAX_USERS_PER_PAGE", 5000);
  15  
  16  $groupid    = required_param('group', PARAM_INT);
  17  $searchtext = optional_param('searchtext', '', PARAM_RAW); // search string
  18  $showall    = optional_param('showall', 0, PARAM_BOOL);
  19  
  20  if ($showall) {
  21      $searchtext = '';
  22  }
  23  
  24  if (!$group = get_record('groups', 'id', $groupid)) {
  25      error('Incorrect group id');
  26  }
  27  
  28  if (!$course = get_record('course', 'id', $group->courseid)) {
  29      print_error('invalidcourse');
  30  }
  31  $courseid = $course->id;
  32  
  33  require_login($course);
  34  $context = get_context_instance(CONTEXT_COURSE, $courseid);
  35  require_capability('moodle/course:managegroups', $context);
  36  
  37  $strsearch = get_string('search');
  38  $strshowall = get_string('showall');
  39  $returnurl = $CFG->wwwroot.'/group/index.php?id='.$courseid.'&group='.$group->id;
  40  
  41  
  42  if ($frm = data_submitted() and confirm_sesskey()) {
  43  
  44      if (isset($frm->cancel)) {
  45          redirect($returnurl);
  46  
  47      } else if (isset($frm->add) and !empty($frm->addselect)) {
  48  
  49          foreach ($frm->addselect as $userid) {
  50              if (! $userid = clean_param($userid, PARAM_INT)) {
  51                  continue;
  52              }
  53              if (!groups_add_member($groupid, $userid)) {
  54                  print_error('erroraddremoveuser', 'group', $returnurl);
  55              }
  56          }
  57  
  58      } else if (isset($frm->remove) and !empty($frm->removeselect)) {
  59  
  60          foreach ($frm->removeselect as $userid) {
  61              if (! $userid = clean_param($userid, PARAM_INT)) {
  62                  continue;
  63              }
  64              if (!groups_remove_member($groupid, $userid)) {
  65                  print_error('erroraddremoveuser', 'group', $returnurl);
  66              }
  67          }
  68      }
  69  }
  70  
  71  $groupmembersoptions = '';
  72  $groupmemberscount = 0;
  73  
  74  // Get members, organised by role, and display
  75  if ($groupmemberroles = groups_get_members_by_role($groupid,$courseid,'u.id,u.firstname,u.lastname')) {
  76      foreach($groupmemberroles as $roleid=>$roledata) {
  77          $groupmembersoptions .= '<optgroup label="'.htmlspecialchars($roledata->name).'">';
  78          foreach($roledata->users as $member) {
  79              $groupmembersoptions .= '<option value="'.$member->id.'">'.fullname($member, true).'</option>';
  80              $groupmemberscount ++;
  81          }
  82          $groupmembersoptions .= '</optgroup>';
  83      }
  84  } else {
  85      $groupmembersoptions .= '<option>&nbsp;</option>';
  86  }
  87  
  88  $potentialmembers = array();
  89  $potentialmembersoptions = '';
  90  $potentialmemberscount = 0;
  91  
  92  // Get potential members, organised by role, and count them
  93  $potentialmembersbyrole = groups_get_users_not_in_group_by_role($courseid, $groupid, $searchtext);
  94  $potentialmemberscount=0;
  95  $potentialmembersids=array();
  96  if (!empty($potentialmembersbyrole)) {
  97      foreach($potentialmembersbyrole as $roledata) {
  98          $potentialmemberscount+=count($roledata->users);
  99          $potentialmembersids=array_merge($potentialmembersids,array_keys($roledata->users));
 100      }
 101  }
 102  
 103  $usergroups = array();
 104  
 105  if ($potentialmemberscount <=  MAX_USERS_PER_PAGE) {
 106  
 107      if ($potentialmemberscount != 0) {
 108          // Get other groups user already belongs to
 109          $sql = "SELECT u.id AS userid, g.* FROM {$CFG->prefix}user u " .
 110                      "INNER JOIN {$CFG->prefix}groups_members gm ON u.id = gm.userid " .
 111                      "INNER JOIN {$CFG->prefix}groups g ON gm.groupid = g.id " .
 112                 "WHERE u.id IN (".implode(',',$potentialmembersids).") AND g.courseid = {$course->id} ";
 113          $rs = get_recordset_sql($sql);
 114          while ($usergroup =  rs_fetch_next_record($rs)) {
 115              $usergroups[$usergroup->userid][$usergroup->id] = $usergroup;
 116          }
 117          rs_close($rs);
 118  
 119          foreach($potentialmembersbyrole as $roleid=>$roledata) {
 120              $potentialmembersoptions .= '<optgroup label="'.htmlspecialchars($roledata->name).'">';
 121              foreach($roledata->users as $member) {
 122                  $name=htmlspecialchars(fullname($member, true));
 123                  $potentialmembersoptions .= '<option value="'.$member->id.
 124                      '" title="'.$name.'">'.$name.
 125                      ' ('.@count($usergroups[$member->id]).')</option>';
 126                  $potentialmembers[$member->id] = $member;
 127              }
 128              $potentialmembersoptions .= '</optgroup>';
 129          }
 130      } else {
 131          $potentialmembersoptions .= '<option>&nbsp;</option>';
 132      }
 133  }
 134  
 135  // Print the page and form
 136  $strgroups = get_string('groups');
 137  $strparticipants = get_string('participants');
 138  $stradduserstogroup = get_string('adduserstogroup', 'group');
 139  $strusergroupmembership = get_string('usergroupmembership', 'group');
 140  
 141  $groupname = format_string($group->name);
 142  
 143  $navlinks = array();
 144  $navlinks[] = array('name' => $strparticipants, 'link' => "$CFG->wwwroot/user/index.php?id=$courseid", 'type' => 'misc');
 145  $navlinks[] = array('name' => $strgroups, 'link' => "$CFG->wwwroot/group/index.php?id=$courseid", 'type' => 'misc');
 146  $navlinks[] = array('name' => $stradduserstogroup, 'link' => null, 'type' => 'misc');
 147  $navigation = build_navigation($navlinks);
 148  
 149  print_header("$course->shortname: $strgroups", $course->fullname, $navigation, '', '', true, '', user_login_string($course, $USER));
 150  
 151  // Print Javascript for showing the selected users group membership
 152  ?>
 153  <script type="text/javascript">
 154  //<![CDATA[
 155  var userSummaries = Array(
 156  <?php
 157  $membercnt = count($potentialmembers);
 158  $i=1;
 159  foreach ($potentialmembers as $userid => $potentalmember) {
 160  
 161      if (isset($usergroups[$userid])) {
 162          $usergrouplist = '<ul>';
 163  
 164          foreach ($usergroups[$userid] as $groupitem) {
 165              $usergrouplist .= '<li>'.addslashes_js(format_string($groupitem->name)).'</li>';
 166          }
 167          $usergrouplist .= '</ul>';
 168      }
 169      else {
 170          $usergrouplist = '';
 171      }
 172      echo "'$usergrouplist'";
 173      if ($i < $membercnt) {
 174          echo ', ';
 175      }
 176      $i++;
 177  }
 178  ?>
 179  );
 180  
 181  function updateUserSummary() {
 182  
 183      var selectEl = document.getElementById('addselect');
 184      var summaryDiv = document.getElementById('group-usersummary');
 185      var length = selectEl.length;
 186      var selectCnt = 0;
 187      var selectIdx = -1;
 188  
 189      for(i=0;i<length;i++) {
 190          if (selectEl.options[i].selected) {
 191              selectCnt++;
 192              selectIdx = i;
 193          }
 194      }
 195  
 196      if (selectCnt == 1 && userSummaries[selectIdx]) {
 197          summaryDiv.innerHTML = userSummaries[selectIdx];
 198      } else {
 199          summaryDiv.innerHTML = '';
 200      }
 201  
 202      return(true);
 203  }
 204  //]]>
 205  </script>
 206  
 207  <div id="addmembersform">
 208      <h3 class="main"><?php print_string('adduserstogroup', 'group'); echo ": $groupname"; ?></h3>
 209  
 210      <form id="assignform" method="post" action="members.php">
 211      <div>
 212      <input type="hidden" name="sesskey" value="<?php p(sesskey()); ?>" />
 213      <input type="hidden" name="group" value="<?php echo $groupid; ?>" />
 214  
 215      <table cellpadding="6" class="generaltable generalbox groupmanagementtable boxaligncenter" summary="">
 216      <tr>
 217        <td valign="top">
 218            <p>
 219              <label for="removeselect"><?php print_string('existingmembers', 'group', $groupmemberscount); //count($contextusers) ?></label>
 220            </p>
 221            <select name="removeselect[]" size="20" id="removeselect" multiple="multiple"
 222                    onfocus="document.getElementById('assignform').add.disabled=true;
 223                             document.getElementById('assignform').remove.disabled=false;
 224                             document.getElementById('assignform').addselect.selectedIndex=-1;"
 225                    onclick="this.focus();updateUserSummary();">
 226            <?php echo $groupmembersoptions ?>
 227            </select></td>
 228        <td valign="top">
 229  <?php // Hidden assignment? ?>
 230  
 231          <?php check_theme_arrows(); ?>
 232          <p class="arrow_button">
 233              <input name="add" id="add" type="submit" value="<?php echo $THEME->larrow.'&nbsp;'.get_string('add'); ?>" title="<?php print_string('add'); ?>" /><br />
 234              <input name="remove" id="remove" type="submit" value="<?php echo get_string('remove').'&nbsp;'.$THEME->rarrow; ?>" title="<?php print_string('remove'); ?>" />
 235          </p>
 236        </td>
 237        <td valign="top">
 238            <p>
 239              <label for="addselect"><?php print_string('potentialmembers', 'group', $potentialmemberscount); //$usercount ?></label>
 240            </p>
 241            <select name="addselect[]" size="20" id="addselect" multiple="multiple"
 242                    onfocus="updateUserSummary();document.getElementById('assignform').add.disabled=false;
 243                             document.getElementById('assignform').remove.disabled=true;
 244                             document.getElementById('assignform').removeselect.selectedIndex=-1;"
 245                    onclick="this.focus();updateUserSummary();">
 246            <?php
 247              if ($potentialmemberscount > MAX_USERS_PER_PAGE) {
 248                  echo '<optgroup label="'.get_string('toomanytoshow').'"><option></option></optgroup>'."\n"
 249                          .'<optgroup label="'.get_string('trysearching').'"><option></option></optgroup>'."\n";
 250              } else {
 251                  echo $potentialmembersoptions;
 252              }
 253            ?>
 254           </select>
 255           <br />
 256           <label for="searchtext" class="accesshide"><?php p($strsearch) ?></label>
 257           <input type="text" name="searchtext" id="searchtext" size="21" value="<?php p($searchtext, true) ?>"
 258                    onfocus ="getElementById('assignform').add.disabled=true;
 259                              getElementById('assignform').remove.disabled=true;
 260                              getElementById('assignform').removeselect.selectedIndex=-1;
 261                              getElementById('assignform').addselect.selectedIndex=-1;"
 262                    onkeydown = "var keyCode = event.which ? event.which : event.keyCode;
 263                                 if (keyCode == 13) {
 264                                      getElementById('assignform').previoussearch.value=1;
 265                                      getElementById('assignform').submit();
 266                                 } " />
 267           <input name="search" id="search" type="submit" value="<?php p($strsearch) ?>" />
 268           <?php
 269                if (!empty($searchtext)) {
 270                    echo '<br /><input name="showall" id="showall" type="submit" value="'.$strshowall.'" />'."\n";
 271                }
 272           ?>
 273         </td>
 274         <td valign="top">
 275          <p><?php echo($strusergroupmembership) ?></p>
 276          <div id="group-usersummary"></div>
 277         </td>
 278      </tr>
 279      <tr><td>
 280          <input type="submit" name="cancel" value="<?php print_string('backtogroups', 'group'); ?>" />
 281      </td></tr>
 282      </table>
 283      </div>
 284      </form>
 285  </div>
 286  
 287  <?php
 288      print_footer($course);
 289  ?>