showpolicies.php3 4.26 KB
Newer Older
1 2
<?php
#
3
# Copyright (c) 2005, 2006 University of Utah and the Flux Group.
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
# 
# {{{EMULAB-LICENSE
# 
# This file is part of the Emulab network testbed software.
# 
# This file is free software: you can redistribute it and/or modify it
# under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or (at
# your option) any later version.
# 
# This file is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public
# License for more details.
# 
# You should have received a copy of the GNU Affero General Public License
# along with this file.  If not, see <http://www.gnu.org/licenses/>.
# 
# }}}
23 24 25 26 27 28 29
#
include("defs.php3");

#
#
# Only known and logged in users allowed.
#
30 31 32
$this_user = CheckLoginOrDie();
$uid       = $this_user->uid();
$isadmin   = ISADMIN();
33

34 35 36 37 38
#
# Standard Testbed Header
#
PAGEHEADER("Experiment Admission Control Policies");

39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
#
# Only admin people can see this page.
# 
if (!$isadmin && !STUDLY()) {
    USERERROR("You are not allowed to view this page!", 1);
}

#
# Global policies.
#
$query_result = DBQueryFatal("select * from global_policies ".
			     "order by policy,test");

if (mysql_num_rows($query_result)) {
    echo "<br>
          <center><h3>Global Policies</h3></center>
          <table border=2 cellpadding=0 cellspacing=2 align='center'>\n";
    
    echo "<tr>
              <th>Policy</th>
              <th>Test</th>
              <th>Count</th>
              <th>Aux Data</th>
          </tr>\n";
    
    while ($row = mysql_fetch_array($query_result)) {
        $policy  = $row["policy"];
        $test    = $row["test"];
        $count   = $row["count"];
        $auxdata = $row["auxdata"];
    
	if (!$auxdata)
	    $auxdata = "&nbsp";
    
        echo "<tr>
                  <td>$test</td>
                  <td>$policy</td>
                  <td>$count</td>
                  <td>$auxdata</td>\n";
        echo "</tr>\n";
    }
    echo "</table>\n";
}

#
# Group policies.
#
$query_result = DBQueryFatal("select * from group_policies ".
			     "order by pid,gid,policy");

if (mysql_num_rows($query_result)) {
    echo "<br>
          <center><h3>Group Policies</h3></center>
          <table border=2 cellpadding=0 cellspacing=2 align='center'>\n";
    
    echo "<tr>
              <th>Pid</th>
              <th>Gid</th>
              <th>Policy</th>
              <th>Count</th>
              <th>Aux Data</th>
          </tr>\n";
    
    while ($row = mysql_fetch_array($query_result)) {
        $pid     = $row["pid"];
        $gid     = $row["gid"];
        $policy  = $row["policy"];
        $count   = $row["count"];
        $auxdata = $row["auxdata"];
    
	if (!$auxdata)
	    $auxdata = "&nbsp";
    
        echo "<tr>
                  <td><a href='showproject.php3?pid=$pid'>$pid</a></td>
                  <td><a href='showgroup.php3?pid=$pid&gid=$gid'>$gid</a></td>
                  <td>$policy</td>
                  <td>$count</td>
                  <td>$auxdata</td>\n";
        echo "</tr>\n";
    }
    echo "</table>\n";
}

#
# User policies.
#
$query_result = DBQueryFatal("select * from user_policies ".
			     "order by uid,policy");

if (mysql_num_rows($query_result)) {
    echo "<br>
          <center><h3>User Policies</h3></center>
          <table border=2 cellpadding=0 cellspacing=2 align='center'>\n";
    
    echo "<tr>
              <th>Uid</th>
              <th>Policy</th>
              <th>Count</th>
              <th>Aux Data</th>
          </tr>\n";
    
    while ($row = mysql_fetch_array($query_result)) {
        $puid    = $row["uid"];
        $policy  = $row["policy"];
        $count   = $row["count"];
        $auxdata = $row["auxdata"];

147 148 149 150 151
	if (! ($user = User::Lookup($puid))) {
	    TBERROR("Could not lookup object for user $puid", 1);
	}
	$showuser_url = CreateURL("showuser", $user);
	
152 153 154 155
	if (!$auxdata)
	    $auxdata = "&nbsp";
    
        echo "<tr>
156
                  <td><A href='$showuser_url'>$puid</a></td>
157 158 159 160 161 162 163 164 165 166 167 168 169
                  <td>$policy</td>
                  <td>$count</td>
                  <td>$auxdata</td>\n";
        echo "</tr>\n";
    }
    echo "</table>\n";
}

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