committers/committertools/diskspace.php

<?php
	require_once("/home/data/httpd/eclipse-php-classes/people/ldapperson.class.php");
	require_once("/home/data/httpd/eclipse-php-classes/menu/menu.class.php");
	require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection.class.php");
	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
	
	#*****************************************************************************
	#
	# diskspace.php
	#
	# Author: 		Denis Roy
	# Date:			2007-02-14
	#
	# Description: Show disk space usage and quotas for projects
	#
	# HISTORY:
	#
	#****************************************************************************

	$App 	= new App();
	$App->runStdWebAppCacheable();
	$ErrorMessage = "";
	
	$LDAPPerson = new LDAPPerson();
	$LDAPPerson = $LDAPPerson->redirectIfNotLoggedIn();
	
	# Incoming parameters
	$_STATE 		= ($_GET['state'] ? $_GET['state'] : $_POST['state']);
	
	$dbc = new DBConnection();
	$dbh = $dbc->connect();
	$sql = "SELECT 
				PRJ.project_id, PRJ.disk_quota_gb,
				SUM(DSK.disk_space) AS GBUsed 
			FROM projects as PRJ
				LEFT JOIN project_disk_space_usage as DSK ON DSK.project_id = PRJ.project_id 
			WHERE DSK.is_quota <> 0 AND PRJ.is_active=1
			GROUP BY PRJ.project_id, PRJ.disk_quota_gb";
			
	$rs = mysql_query($sql, $dbh);
	
	
	include("inc/en_diskspace.php");
	
	$dbc->disconnect();
	unset($dbc);

?>