[Sommaire] [Imprimer]

   1  <?php
   2  #CMS - CMS Made Simple
   3  #(c)2004 by Ted Kulp (wishy@users.sf.net)
   4  #This project's homepage is: http://cmsmadesimple.sf.net
   5  #
   6  #This program is free software; you can redistribute it and/or modify
   7  #it under the terms of the GNU General Public License as published by
   8  #the Free Software Foundation; either version 2 of the License, or
   9  #(at your option) any later version.
  10  #
  11  #This program is distributed in the hope that it will be useful,
  12  #but WITHOUT ANY WARRANTY; without even the implied warranty of
  13  #MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14  #GNU General Public License for more details.
  15  #You should have received a copy of the GNU General Public License
  16  #along with this program; if not, write to the Free Software
  17  #Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  18  #
  19  #$Id: changegroupassign.php 3624 2006-12-27 00:53:22Z dittmann $
  20  
  21  $CMS_ADMIN_PAGE=1;
  22  
  23  require_once ("../include.php");
  24  
  25  check_login();
  26  $group_id= - 1;
  27  if (isset($_POST["group_id"])) $group_id = $_POST["group_id"];
  28  else if (isset($_GET["group_id"])) $group_id = $_GET["group_id"];
  29  
  30  $submitted= - 1;
  31  if (isset($_POST["submitted"])) $submitted = $_POST["submitted"];
  32  else if (isset($_GET["submitted"])) $submitted = $_GET["submitted"];
  33  
  34  $group_name="";
  35  
  36  if (isset($_POST["cancel"])) {
  37      redirect("topusers.php");
  38      return;
  39  }
  40  
  41  $userid = get_userid();
  42  $access = check_permission($userid, 'Modify Group Assignments');
  43  
  44  $message = '';
  45  
  46  include_once ("header.php");
  47  
  48  global $gCms;
  49  $db =& $gCms->GetDb();
  50  
  51  if (!$access) {
  52      echo "<div class=\"pageerrorcontainer\"><p class=\"pageerror\">".lang('noaccessto',array(lang('modifygrouppermissions')))."</p></div>";
  53  }
  54  else {
  55  
  56  ?>
  57  
  58  <div class="pagecontainer">
  59  <?php
  60      echo $themeObject->ShowHeader('usersassignedtogroup',array($group_name));
  61      // always display the group pulldown
  62      global $gCms;
  63      $groupops =& $gCms->GetGroupOperations();
  64      $groups = $groupops->LoadGroups();
  65      if (count($groups) > 0)
  66          {
  67          echo '<form id="groupname" method="post" action="changegroupassign.php">';
  68          echo '<div class="pageoverflow">';
  69          echo '<p class="pagetext">'.lang('groupname').':</p>';
  70          echo '<p class="pageinput">';
  71          echo '<select name="group_id"';
  72          echo '><option value="-1">'.lang('selectgroup').'</option>';
  73          foreach ($groups as $onegroup)
  74              {
  75              echo '<option value="'.$onegroup->id.'"';
  76              if ($onegroup->id == $group_id)
  77                  {
  78                  echo ' selected="selected"';
  79                  }
  80              echo '>'.$onegroup->name.'</option>';
  81              }
  82          echo '</select>';
  83          echo '<input id="groupsubmit" type="submit" value="'.lang('selectgroup').'" /></p>';
  84          echo '</div></form>';
  85          }
  86      if ($group_id != -1 && $submitted == -1)
  87          {
  88          // a group has been selected
  89          echo '<form method="post" action="changegroupassign.php">';
  90          $query = "SELECT u.user_id, u.username, ug.group_id FROM ".cms_db_prefix()."users u LEFT JOIN ".
  91              cms_db_prefix()."user_groups ug ON u.user_id = ug.user_id and group_id = ? ORDER BY u.username";
  92          $result = $db->Execute($query,array($group_id));
  93          echo "<table cellspacing=\"0\" class=\"pagetable\">\n";
  94          echo '<thead>';
  95          echo "<tr>\n";
  96          echo "<th>".lang('assignments')."</th>\n";
  97          echo "<th class=\"pagew10\">&nbsp;</th>\n";
  98          echo "</tr>\n";
  99          echo '</thead>';
 100          echo '<tbody>';
 101          $currow = "row1";
 102          while($result && $row = $result->FetchRow())
 103              {
 104              echo "<tr class=\"".$currow."\" onmouseover=\"this.className='".$currow.'hover'."';\" onmouseout=\"this.className='".$currow."';\">\n";
 105              echo '<td>'.$row['username'].'</td>'."\n";
 106              echo '<td><input class="pagecheckbox" type="checkbox" name="user-'.$row['user_id'].'" value="1" '.(isset($row['group_id'])?" checked=\"checked\"":"").'/></td>'."\n";
 107              echo "</tr>\n";
 108  
 109              ($currow=="row1"?$currow="row2":$currow="row1");    
 110              }
 111          ?>
 112          </tbody>
 113          </table>
 114          <div class="pageoptions">
 115              <p class="pageoptions">
 116                  <input type="hidden" name="group_id" value="<?php echo $group_id?>" />
 117                  <input type="hidden" name="submitted" value="1" />
 118                  <input type="submit" name="changeassign" value="<?php echo lang('submit')?>" class="pagebutton" onmouseover="this.className='pagebuttonhover'" onmouseout="this.className='pagebutton'" />
 119                  <input type="submit" name="cancel" value="<?php echo lang('cancel')?>" class="pagebutton" onmouseover="this.className='pagebuttonhover'" onmouseout="this.className='pagebutton'" />
 120              </p>
 121          </div>
 122          </form>
 123          <?php
 124          }
 125      else if ($group_id != -1 && $submitted != -1)
 126          {
 127          // we have group preferences
 128          $groupobj =& $groupops->LoadGroupByID($group_id);
 129          $userops =& $gCms->GetUserOperations();
 130          
 131          #Send the ChangeGroupAssignPost event
 132          Events::SendEvent('Core', 'ChangeGroupAssignPre', array('group' => $groupobj, 'users' => $userops->LoadUsersInGroup($group_id)));
 133          $query = "DELETE FROM ".cms_db_prefix()."user_groups WHERE group_id = ?";
 134          $result = $db->Execute($query, array($group_id));
 135          foreach ($_POST as $key=>$value)
 136          {
 137              if (strpos($key,"user-") == 0 && strpos($key,"user-") !== false)
 138              {
 139                  $query = "INSERT INTO ".cms_db_prefix()."user_groups (group_id, user_id, create_date, modified_date) VALUES (".$db->qstr($group_id).", ".$db->qstr(substr($key,5)).", ".$db->DBTimeStamp(time()).", ".$db->DBTimeStamp(time()).")";
 140                  $result = $db->Execute($query);
 141              }
 142          }
 143          
 144          #Send the ChangeGroupAssignPost event
 145          Events::SendEvent('Core', 'ChangeGroupAssignPost', array('group' => $groupobj, 'users' => $userops->LoadUsersInGroup($group_id)));
 146          audit($group_id, 'Group ID', lang('assignmentchanged'));
 147          echo '<p class="pageheader">'.lang('assignmentchanged').'</p>';
 148          }
 149  echo '</div>';
 150  }
 151  echo '<p class="pageback"><a class="pageback" href="'.$themeObject->BackUrl().'">&#171; '.lang('back').'</a></p>';
 152  
 153  include_once ("footer.php");
 154  
 155  # vim:ts=4 sw=4 noet
 156  ?>
 157