require 'pdffunc.php';
@($current_user = $_SESSION['username']);
$dt = $_POST['date'];
$pdf = new PDF_TOC('L', 'mm', 'A4');
$pdf->startPageNums();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->Ln(70);
$pdf->SetFont('Times', '', 32);
$pdf->Cell(0, 1, 'CPU Utilization Report', 0, 1, 'C');
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT distinct server,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******' group by server")) {
$pdf->AddPage();
$pdf->Ln(3);
$pdf->SetFont('Arial', '', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'List of Servers', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Servers', 0);
$pdf->SetFont('Times', '', 14);
$pdf->SetTextColor(0, 0, 0);
while ($query_row = mysql_fetch_assoc($query)) {
$hostname = $query_row['server'];
$environ = $query_row['environ'];
$pdf->Cell(0, 10, 'Server: ' . $hostname . ' [' . $environ . ']', 0, 1, 'L');
}
$cpuquerytot = mysql_query("SELECT date(date)as date,time(date) as time,user,nice,system,iowait,steal,idle from cpurep where date(date) = '{$dt}'");
if (mysql_num_rows($cpuquerytot)) {
$pdf->SetFont('Arial', '', 20);
$pdf->Ln(10);
$pdf->setFillColor(63, 139, 202);
