activity.php 3.58 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
<?php
#
# Copyright (c) 2000-2014 University of Utah and the Flux Group.
# 
# {{{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/>.
# 
# }}}
#
chdir("..");
include("defs.php3");
chdir("apt");
include("quickvm_sup.php");
include("profile_defs.php");
$page_title = "My Profiles";

#
# Get current user.
#
RedirectSecure();
$this_user = CheckLogin($check_status);
if (!$this_user) {
    RedirectLoginPage();
    exit();
}
SPITHEADER(1);

if (!ISADMIN()) {
    SPITUSERERROR("Not enough permission to view this page!");
}
$instances = array();

#
# First existing instances and then the history table.
#
$query1_result =
    DBQueryFatal("select i.uuid,i.profile_version,i.created,'' as destroyed, ".
52
		 "   i.creator,p.uuid as profile_uuid,p.name,p.pid,u.email ".
53 54 55 56
		 "  from apt_instances as i ".
		 "left join apt_profile_versions as p on ".
		 "     p.profileid=i.profile_id and ".
		 "     p.version=i.profile_version ".
57
		 "left join geni.geni_users as u on u.uuid=i.creator_uuid ".
58 59 60
		 "order by i.created desc");
$query2_result =
    DBQueryFatal("select h.uuid,h.profile_version,h.created,h.destroyed, ".
61
		 "    h.creator,p.uuid as profile_uuid,p.name,p.pid,u.email ".
62 63 64 65
		 "  from apt_instance_history as h ".
		 "left join apt_profile_versions as p on ".
		 "     p.profileid=h.profile_id and ".
		 "     p.version=h.profile_version ".
66
		 "left join geni.geni_users as u on u.uuid=h.creator_uuid ".
67 68 69
		 "order by h.created desc");

if (mysql_num_rows($query1_result) == 0 &&
70
    mysql_num_rows($query2_result) == 0) {
71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
    $message = "<b>Oops, there is no activity to show you.</b><br>";
    SPITUSERERROR($message);
    exit();
}

foreach (array($query1_result, $query2_result) as $query_result) {
    while ($row = mysql_fetch_array($query_result)) {
	$uuid      = $row["uuid"];
	$pname     = $row["name"];
	$pproj     = $row["pid"];
	$puuid     = $row["profile_uuid"];
	$pversion  = $row["profile_version"];
	$created   = $row["created"];
	$destroyed = $row["destroyed"];
	$creator   = $row["creator"];
86 87 88 89 90
	$email     = $row["email"];
	# If a guest user, use email instead.
	if (isset($email)) {
	    $creator = $email;
	}
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

	$instance = array();
	$instance["uuid"]        = $uuid;
	$instance["p_name"]      = $pname;
	$instance["p_pid"]       = $pproj;
	$instance["p_uuid"]      = $puuid;
	$instance["p_version"]   = $pversion;
	$instance["creator"]     = $creator;
	$instance["created"]     = $created;
	$instance["destroyed"]   = $destroyed;
	$instances[] = $instance;
    }
}

# Place to hang the toplevel template.
echo "<div id='activity-body'></div>\n";

echo "<script type='text/javascript'>\n";
echo "    window.AJAXURL  = 'server-ajax.php';\n";
echo "</script>\n";
echo "<script type='text/plain' id='instances-json'>\n";
echo json_encode($instances);
echo "</script>\n";
echo "<script src='js/lib/jquery-2.0.3.min.js'></script>\n";
echo "<script src='js/lib/bootstrap.js'></script>\n";
echo "<script src='js/lib/require.js' data-main='js/activity'></script>\n";

SPITFOOTER();
?>