$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);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'CPU Utilization', 1, 1, 'C', 1);
$pdf->TOC_Entry('CPU Utilization', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->ln(1);
if ($querycpu = mysql_query("SELECT distinct server FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******' group by server")) {
while ($query_rowcpu = mysql_fetch_assoc($querycpu)) {
$hostname = $query_rowcpu['server'];
$cpunumquery = mysql_query("SELECT distinct dbuid,date(cpurep.date)as date,time(cpurep.date) as time,cpurep.user,cpurep.system,cpurep.iowait,cpurep.idle from cpurep,configureddb WHERE cpurep.dbid=configureddb.dbuid and server='{$hostname}' and date(date) = '{$dt}' ORDER BY date desc");
if (mysql_num_rows($cpunumquery)) {
$pdf->TOC_Entry($hostname, 1);
$pdf->SetFont('Arial', 'B', 14);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 7, 'Server: ' . $hostname, 1, 1, 'C', 1);
$pdf->SetTextColor(0, 0, 0);
$pdf->AddCol('time', 55, 'Time ', 'C');
$pdf->AddCol('date', 55, 'Date ', 'C');
$pdf->AddCol('user', 55, '% User', 'C');
$pdf->AddCol('system', 57, '% System ', 'C');
$pdf->Cell(0, 10, 'Database: ' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$longtrans = mysql_query("SELECT * FROM longtrans where date(date) = '{$dt}'");
if (mysql_num_rows($longtrans)) {
if ($query = mysql_query("SELECT dbuid,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->SetFont('Arial', '', 20);
$pdf->Cell(0, 10, 'Database Long Running Transaction', 1, 1, 'C', 1);
$pdf->TOC_Entry('Database Long Running Transaction', 0);
$pdf->SetTextColor(0, 0, 0);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$databaseName = $query_row['dbname'];
$pdf->SetFont('Arial', 'B', 15);
$pdf->ln(5);
$ltsquery = mysql_query("SELECT time(date) as time,date(date)as date,usrno,user,pid,transno,timerunning FROM longtrans WHERE dbid ='{$dbuid}' and date(date) = '{$dt}'");
if (mysql_num_rows($ltsquery)) {
$pdf->TOC_Entry($databaseName, 1);
$pdf->SetFont('Arial', 'B', 14);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 7, 'Database: ' . $databaseName, 1, 1, 'C', 1);
$pdf->SetTextColor(0, 0, 0);
$pdf->AddCol('time', 33, 'Time', 'C');
$pdf->AddCol('date', 34, 'Date', 'C');
$pdf->AddCol('usrno', 40, 'User No', 'C');
$pdf->AddCol('user', 45, 'User', 'C');
$pdf->AddCol('pid', 35, 'Pid');
$pdf->AddCol('transno', 50, 'Transaction No');
$pdf->AddCol('timerunning', 40, 'Time Running(sec)');
