approveuser_form.php3

<?php
#
# EMULAB-COPYRIGHT
# Copyright (c) 2000-2003 University of Utah and the Flux Group.
# All rights reserved.
#
include("defs.php3");

#
# Standard Testbed Header
#
PAGEHEADER("New Users Approval Form");

#
# Only known and logged in users can be verified.
#
$auth_usr = GETLOGIN();
LOGGEDINORDIE($auth_usr);

echo "
      <h2>Approve new users in your Project or Group</h2>
      <p>
      Use this page to approve new members of your Project or Group.  Once
      approved, they will be able to log into machines in your Project's 
      experiments. Be sure to toggle the menu options appropriately for
      each pending user.
      </p>

      <center>
      <h4>You have the following choices for <b>Action</b>:</h4>
      <table cellspacing=2 border=0>
        <tr>
            <td><b>Postpone</b></td>
            <td>Do nothing; application remains, pending a decision.</td>
        </tr>
        <tr>
            <td><b>Deny</b></td>
            <td>Deny user application and so notify the user.</td>
        </tr>
        <tr>
            <td><b>Nuke</b></td>
            <td>Nuke user application.  Kills user account, without
		notice to user.  Useful for
                bogus project applications.</td>
        </tr>
        <tr>
            <td><b>Approve</b></td>
            <td>Approve the user</td>
        </tr>
      </table>
      <br />
      <h4>You have the following choices for <b>Trust</b>:</h4>
      <table cellspacing=2 cellpadding=4 border=0>
        <tr>
            <td><b>User</b></td>
            <td>User may log into machines in your experiments</td>
        </tr>
        <tr>
            <td><b>Local Root</b></td>
            <td>User may create/destroy experiments in your project and
                has root privileges on machines in your experiments</td>
        </tr>
        <tr>
            <td><b>Group Root</b></td>
            <td>In addition to Local Root privileges, user may also
                approve new group members and 
                modify user info for other users within the group. This
                level of trust is typically given only to TAs and the
                like.</td>
        </tr>
      </table>
      <br />
      <b>Important group
       <a href='docwrapper.php3?docname=groups.html#SECURITY'>
       security issues</a> are discussed in the
       <a href='docwrapper.php3?docname=groups.html'>Groups Tutorial</a>.
      </b>
      </center><br />

      \n";

#
# Find all of the groups that this person has project/group root in, and 
# then in all of those groups, all of the people who are awaiting to be
# approved (status = none).
#
# First off, just determine if this person has group/project root anywhere.
#
$query_result =
    DBQueryFatal("SELECT pid FROM group_membership WHERE uid='$auth_usr' ".
		 "and (trust='group_root' or trust='project_root')");
if (mysql_num_rows($query_result) == 0) {
    USERERROR("You do not have Root permissions in any Project or Group.", 1);
}

#
# Okay, so this operation sucks out the right people by joining the
# group_membership table with itself. Kinda obtuse if you are not a natural
# DB guy. Sorry. Well, obtuse to me.
# 
$query_result =
    DBQueryFatal("select g.* from group_membership as authed ".
		 "left join group_membership as g on ".
		 " g.pid=authed.pid and g.gid=authed.gid ".
		 "left join users as u on u.uid=g.uid ".
		 "where u.status!='".
		 TBDB_USERSTATUS_UNVERIFIED . "' and ".
		 " u.status!='" . TBDB_USERSTATUS_NEWUSER . 
		 "' and g.uid!='$auth_usr' and ".
		 "  g.trust='". TBDB_TRUSTSTRING_NONE . "' ".
		 "  and authed.uid='$auth_usr' and ".
		 "  (authed.trust='group_root' or ".
		 "   authed.trust='project_root') ".
		 "ORDER BY g.uid,g.pid,g.gid");

if (mysql_num_rows($query_result) == 0) {
    USERERROR("You have no new project members who need approval.", 1);
}

#
# Now build a table with a bunch of selections. The thing to note about the
# form inside this table is that the selection fields are constructed with
# name= on the fly, from the uid of the user to be approved. In other words:
#
#             uid     menu     project/group
#	name=stoller$$approval-testbed/testbed value=approved,denied,postpone
#	name=stoller$$trust-testbed/testbed value=user,local_root
#
# so that we can go through the entire list of post variables, looking
# for these. The alternative is to work backwards, and I do not like that.
# 
echo "<table width=\"100%\" border=2 cellpadding=2 cellspacing=2
       align=\"center\">\n";

echo "<tr>
          <th rowspan=2>User</th>
          <th rowspan=2>Project</th>
          <th rowspan=2>Group</th>
          <th rowspan=2>Date<br>Applied</th>
          <th rowspan=2>Action</th>
          <th rowspan=2>Trust</th>
          <th>Name</th>
          <th>Title</th>
          <th>Affil</th>
          <th>E-mail</th>
          <th>Phone</th>
      </tr>
      <tr>
          <th colspan=5>Address</th>
      </tr>\n";

echo "<form action='approveuser.php3' method='post'>\n";

while ($usersrow = mysql_fetch_array($query_result)) {
    $newuid        = $usersrow[uid];
    $pid           = $usersrow[pid];
    $gid           = $usersrow[gid];
    $date_applied  = $usersrow[date_applied];

    #
    # Cause this field was added late and might be null.
    # 
    if (! $date_applied) {
	$date_applied = "--";
    }

    $userinfo_result =
	DBQueryFatal("SELECT * from users where uid='$newuid'");

    $row	= mysql_fetch_array($userinfo_result);
    $name	= $row[usr_name];
    $email	= $row[usr_email];
    $title	= $row[usr_title];
    $affil	= $row[usr_affil];
    $addr	= $row[usr_addr];
    $addr2	= $row[usr_addr2];
    $city	= $row[usr_city];
    $state	= $row[usr_state];
    $zip	= $row[usr_zip];
    $country	= $row[usr_country];
    $phone	= $row[usr_phone];

     echo "<tr>
              <td rowspan=2>$newuid</td>
              <td rowspan=2>$pid</td>
              <td rowspan=2>$gid</td>
              <td rowspan=2>$date_applied</td>
              <td rowspan=2>
                  <select name=\"$newuid\$\$approval-$pid/$gid\">
                          <option value='postpone'>Postpone </option>
                          <option value='approve'>Approve </option>
                          <option value='deny'>Deny </option>
                          <option value='nuke'>Nuke </option>
                  </select>
              </td>
              <td rowspan=2>
                  <select name=\"$newuid\$\$trust-$pid/$gid\">\n";
    if (TBCheckGroupTrustConsistency($newuid, $pid, $gid, "user", 0)) {
	echo  "<option value='user'>User </option>\n";
    }
    if (TBCheckGroupTrustConsistency($newuid, $pid, $gid, "local_root", 0)) {       
	# local_root means any root is valid.
        echo  "<option value='local_root'>Local Root </option>\n";
	if (TBProjAccessCheck($auth_usr, $pid, $gid,
                              $TB_PROJECT_BESTOWGROUPROOT)) {
	    echo  "<option value='group_root'>Group Root </option>\n";
	}
    }	
    echo "        </select>
              </td>\n";

    echo "    <td>&nbsp;$name&nbsp;</td>
              <td>&nbsp;$title&nbsp;</td>
              <td>&nbsp;$affil&nbsp;</td>
              <td>&nbsp;$email&nbsp;</td>
              <td>&nbsp;$phone&nbsp;</td>
          </tr>\n";
    echo "<tr>
              <td colspan=5>&nbsp;$addr&nbsp;";
    if (strcmp($addr2,"")) { 
	echo "&nbsp;$addr2&nbsp;"; 
    }
    echo "                  &nbsp;$city&nbsp;
                            &nbsp;$state&nbsp;
                            &nbsp;$zip&nbsp;
                            &nbsp;$country&nbsp;</td>
          </tr>\n";
}
echo "<tr>
          <td align=center colspan=11>
              <b><input type='submit' value='Submit' name='OK'></td>
      </tr>
      </form>
      </table>\n";

#
# Standard Testbed Footer
# 
PAGEFOOTER();
?>